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

Hardware and OS info

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

Server and database settinfs 


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

Test configuration settings 

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

Test finish info 


FINISH_STATE                    NORMAL: TEST_TIME EXPIRED AT 2024-03-08 13:07:50
DTS_END                         2024-03-08 13:07:50.5500
FB_GDSCODE                      -1
FB_MNEMONA                      
STACK                           SP_ADD_INVOICE_TO_STOCK(190:30) ==> SP_CUSTOMER_RESERVE(47:5) ==> SP_CHECK_TO_STOP_WORK(32:12) ==> SP_HALT_ON_ERROR(68:17)
IP                              ::1/43568
TRN_ID                          173608
ATT_ID                          502
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: 8962.42 19013 896242
customer order: creation 177.35 371 17735
customer order: refuse 15.61 327 1561
order to supplier: creation 49.13 1233 4913
order to supplier: removal 3.54 81506 354
invoice (draft): creation 48.37 3057 4837
invoice (draft): removal 47.29 714 4729
invoice accept: apply 43.18 19691 4318
invoice accept: cancel 42.37 758 4237
customer reserve: creation 4151.31 190 415131
customer reserve: removal 4091.21 56 409121
realization accept: apply 87.22 155 8722
realization accept: cancel 72.33 135 7233
payment from customer: creation 61.78 101 6178
payment from customer: removal 5.96 74 596
payment to supplier: creation 51.01 111 5101
payment to supplier: removal 3.59 65 359
service: total inventory turnovers 4.12 3921 412
service: total monetary turnovers 6.26 693 626
service: aggregate perf. data 0.76 16792 76
service: refresh index statistics 0.03 250311 3

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:02, from 08-03-2024 13:09:26 to 08-03-2024 13:09:28.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 2118
TEST_TIME 2 2620
TEST_TIME 3 3762
TEST_TIME 4 3863
TEST_TIME 5 4530
TEST_TIME 6 4655
TEST_TIME 7 5423
TEST_TIME 8 5343
TEST_TIME 9 5276
TEST_TIME 10 5529
TEST_TIME 11 5807
TEST_TIME 12 5801
TEST_TIME 13 6038
TEST_TIME 14 6018
TEST_TIME 15 6041
TEST_TIME 16 6312
TEST_TIME 17 6661
TEST_TIME 18 7046
TEST_TIME 19 7048
TEST_TIME 20 7381
TEST_TIME 21 7312
TEST_TIME 22 7616
TEST_TIME 23 8350
TEST_TIME 24 8478
TEST_TIME 25 8867
TEST_TIME 26 9149
TEST_TIME 27 9379
TEST_TIME 28 9278
TEST_TIME 29 9019
TEST_TIME 30 8835
TEST_TIME 31 8797
TEST_TIME 32 8937
TEST_TIME 33 8838
TEST_TIME 34 8768
TEST_TIME 35 8724
TEST_TIME 36 8771
TEST_TIME 37 8663
TEST_TIME 38 8635
TEST_TIME 39 8496
TEST_TIME 40 8555
TEST_TIME 41 8511
TEST_TIME 42 8416
TEST_TIME 43 8501
TEST_TIME 44 8501
TEST_TIME 45 8489
TEST_TIME 46 8497
TEST_TIME 47 8622
TEST_TIME 48 8708
TEST_TIME 49 8742
TEST_TIME 50 8864
TEST_TIME 51 8970
TEST_TIME 52 8991
TEST_TIME 53 9106
TEST_TIME 54 9128
TEST_TIME 55 9069
TEST_TIME 56 8947
TEST_TIME 57 8885
TEST_TIME 58 8896
TEST_TIME 59 8821
TEST_TIME 60 8826
TEST_TIME 61 8851
TEST_TIME 62 8848
TEST_TIME 63 8835
TEST_TIME 64 8852
TEST_TIME 65 9021
TEST_TIME 66 9016
TEST_TIME 67 9065
TEST_TIME 68 9090
TEST_TIME 69 9079
TEST_TIME 70 9093
TEST_TIME 71 9173
TEST_TIME 72 9239
TEST_TIME 73 9178
TEST_TIME 74 9125
TEST_TIME 75 9039
TEST_TIME 76 9087
TEST_TIME 77 9051
TEST_TIME 78 9011
TEST_TIME 79 8965
TEST_TIME 80 8886
TEST_TIME 81 8911
TEST_TIME 82 8936
TEST_TIME 83 8956
TEST_TIME 84 9011
TEST_TIME 85 9017
TEST_TIME 86 9019
TEST_TIME 87 9104
TEST_TIME 88 9093
TEST_TIME 89 9124
TEST_TIME 90 9116
TEST_TIME 91 9126
TEST_TIME 92 9158
TEST_TIME 93 9211
TEST_TIME 94 9167
TEST_TIME 95 9105
TEST_TIME 96 9063
TEST_TIME 97 9034
TEST_TIME 98 8991
TEST_TIME 99 8982
TEST_TIME 100 8969

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:03, from 08-03-2024 13:09:29 to 08-03-2024 13:09:32.

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 1274357 1274357 0 0.00 0 32727 7 0 0
doc_list_biud 1274354 1274354 0 0.00 0 44698 23 0 0
sp_add_invoice_to_stock 4453 4318 135 3.03 24 196619 19692 0 135
sp_cancel_adding_invoice 4237 4237 0 0.00 5 45439 758 0 0
sp_cancel_client_order 1561 1561 0 0.00 4 7167 328 0 0
sp_cancel_customer_reserve 409121 409121 0 0.00 0 19405 57 0 0
sp_cancel_pay_from_customer 596 596 0 0.00 2 3988 75 0 0
sp_cancel_pay_to_supplier 359 359 0 0.00 2 2644 65 0 0
sp_cancel_supplier_invoice 4733 4729 4 0.08 1 44716 715 0 4
sp_cancel_supplier_order 354 354 0 0.00 5 819945 81507 0 0
sp_cancel_write_off 7233 7233 0 0.00 1 23860 135 0 0
sp_client_order 17735 17735 0 0.00 3 21986 372 0 0
sp_customer_reserve 415131 415131 0 0.00 0 58190 190 0 0
sp_fill_shopping_cart 27471 27471 0 0.00 1 12688 39 0 0
sp_fill_shopping_cart_clo_res 415115 415115 0 0.00 0 13583 14 0 0
sp_get_clo_for_invoice 4302 4302 0 0.00 0 30382 349 0 0
sp_kill_cost_storno 12425 12425 0 0.00 0 10228 68 0 0
sp_kill_qstorno_ret_qs2qd 830558 830558 0 0.00 0 44696 31 0 0
sp_kill_qty_storno 440256 440256 0 0.00 0 44698 66 0 0
sp_lock_selected_doc 18032 18032 0 0.00 0 5998 4 0 0
sp_make_cost_storno 24300 24300 0 0.00 0 11145 49 0 0
sp_multiply_rows_for_pdistr 24300 24300 0 0.00 0 8908 32 0 0
sp_multiply_rows_for_qdistr 17735 17735 0 0.00 0 11958 189 0 0
sp_pay_from_customer 6178 6178 0 0.00 3 11172 102 0 0
sp_pay_to_supplier 5101 5101 0 0.00 4 10087 111 0 0
sp_payment_common 11279 11279 0 0.00 1 8701 18 0 0
sp_qd_handle_on_cancel_clo 1561 1561 0 0.00 0 7161 305 0 0
sp_qd_handle_on_invoice_upd_sts 8536 8536 0 0.00 0 14110 247 0 0
sp_qd_handle_on_reserve_upd_sts 8722 8722 0 0.00 0 22015 46 0 0
sp_reserve_write_off 8722 8722 0 0.00 6 22078 156 0 0
sp_supplier_invoice 4837 4837 0 0.00 5 83520 3057 0 0
sp_supplier_order 4913 4913 0 0.00 5 42823 1234 0 0
srv_aggregate_perf_data 76 76 0 0.00 1665 335427 16792 0 0
srv_fill_mon_cache_memory 57 57 0 0.00 3015 96989 36700 0 0
srv_find_qd_qs_mism 851198 851198 0 0.00 0 32723 7 0 0
srv_make_invnt_saldo 412 412 0 0.00 42 113725 3922 0 0
srv_make_money_saldo 626 626 0 0.00 1 25741 694 0 0
srv_recalc_idx_stat 3 3 0 0.00 215448 278252 250311 0 0
t$perf-abend:sp_add_invoice_to_stock 135 135 0 0.00 0 0 0 0 0
t$perf-abend:sp_cancel_supplier_invoice 4 4 0 0.00 0 0 0 0 0
t$perf-norm:sp_add_invoice_to_stock 4318 4318 0 0.00 0 10167 169 0 0
t$perf-norm:sp_cancel_adding_invoice 336 336 0 0.00 0 6251 124 0 0
t$perf-norm:sp_cancel_client_order 1561 1561 0 0.00 0 2610 14 0 0
t$perf-norm:sp_cancel_customer_reserve 601 601 0 0.00 0 629 7 0 0
t$perf-norm:sp_cancel_pay_from_customer 596 596 0 0.00 0 1951 6 0 0
t$perf-norm:sp_cancel_pay_to_supplier 359 359 0 0.00 0 544 3 0 0
t$perf-norm:sp_cancel_supplier_invoice 332 332 0 0.00 0 715 11 0 0
t$perf-norm:sp_cancel_supplier_order 354 354 0 0.00 0 23814 1571 0 0
t$perf-norm:sp_cancel_write_off 872 872 0 0.00 0 544 5 0 0
t$perf-norm:sp_client_order 17735 17735 0 0.00 0 19868 16 0 0
t$perf-norm:sp_customer_reserve 862 862 0 0.00 0 10221 20 0 0
t$perf-norm:sp_pay_from_customer 6178 6178 0 0.00 0 10078 12 0 0
t$perf-norm:sp_pay_to_supplier 5101 5101 0 0.00 0 8431 14 0 0
t$perf-norm:sp_reserve_write_off 8722 8722 0 0.00 0 6754 10 0 0
t$perf-norm:sp_supplier_invoice 4837 4837 0 0.00 0 10459 19 0 0
t$perf-norm:sp_supplier_order 4913 4913 0 0.00 0 7619 16 0 0
t$perf-norm:srv_aggregate_perf_data 76 76 0 0.00 0 75 2 0 0
t$perf-norm:srv_fill_mon_cache_memory 57 57 0 0.00 0 42 2 0 0
t$perf-norm:srv_make_invnt_saldo 412 412 0 0.00 0 1231 6 0 0
t$perf-norm:srv_make_money_saldo 626 626 0 0.00 0 3564 15 0 0
t$perf-norm:srv_recalc_idx_stat 3 3 0 0.00 2 79 28 0 0
v_add_invoice_to_stock 8868 8598 270 3.04 0 3303 16 0 270
v_all_customers 32864 32864 0 0.00 0 13 0 0 0
v_all_suppliers 27528 27528 0 0.00 0 28 1 0 0
v_all_wares 35470 35470 0 0.00 0 41 1 0 0
v_cancel_adding_invoice 672 672 0 0.00 0 695 7 0 0
v_cancel_client_order 3122 3122 0 0.00 0 2913 4 0 0
v_cancel_customer_prepayment 1192 1192 0 0.00 0 1198 5 0 0
v_cancel_customer_reserve 1202 1202 0 0.00 0 827 4 0 0
v_cancel_payment_to_supplier 718 718 0 0.00 0 2592 8 0 0
v_cancel_supplier_invoice 672 664 8 1.19 0 669 13 0 8
v_cancel_supplier_order 708 708 0 0.00 0 2651 8 0 0
v_cancel_write_off 1744 1744 0 0.00 0 5416 15 0 0
v_max_id_clo_ord 4913 4913 0 0.00 0 683 1 0 0
v_max_id_clo_res 862 862 0 0.00 0 3456 13 0 0
v_max_id_ord_sup 4823 4823 0 0.00 0 5642 8 0 0
v_max_non_paid_invoice 1073 1073 0 0.00 0 527 2 0 0
v_max_non_paid_realizn 3006 3006 0 0.00 0 4296 6 0 0
v_min_id_clo_ord 4913 4913 0 0.00 0 5101 8 0 0
v_min_id_clo_res 862 862 0 0.00 0 1341 6 0 0
v_min_id_ord_sup 4823 4823 0 0.00 0 5996 3 0 0
v_min_non_paid_invoice 5101 5101 0 0.00 0 8694 13 0 0
v_min_non_paid_realizn 6178 6178 0 0.00 0 5583 11 0 0
v_our_firm 8950 8950 0 0.00 0 18 1 0 0
v_reserve_write_off 17444 17444 0 0.00 0 2925 5 0 0
x_lock_depdocs_on_canc_invoice 8634 8634 0 0.00 0 10097 107 0 0
x_lock_depdocs_on_canc_sup_ord 354 354 0 0.00 0 8962 287 0 0
x_make_qstorno_1000_1200 4913 4913 0 0.00 1 42813 1164 0 0
x_make_qstorno_1200_2000 4837 4837 0 0.00 3 83498 2905 0 0
x_make_qstorno_2100_3300 415131 415131 0 0.00 0 56337 174 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 08-03-2024 13:09:33 to 08-03-2024 13:09:37.

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
11:07:54 1 8192000000 8796669328 8807108608 3187328 0.038 1 1 2 0 3284944 61840 35776
11:08:55 13751 8192000000 9696638672 9988059136 775097072 8.643 100 92 184 0 806140992 7984416 23059504
11:10:17 32225 8192000000 9755790640 10059923456 827090944 9.170 100 89 178 0 859406000 11253296 21061760
11:12:06 10613 8192000000 9783507248 10099412992 858372816 9.484 100 76 152 0 894965984 19264352 17328816
11:13:20 11682 8192000000 9842804528 10176401408 904560048 9.943 100 71 142 1 955290208 35461728 15268432
11:14:38 6441 8192000000 9901531024 10245951488 949124544 10.383 100 83 166 0 1018738672 52232128 17382000
11:15:47 4701 8192000000 9958462016 10311786496 986549680 10.748 100 81 162 0 1069401056 66469456 16381920
11:16:59 3457 8192000000 9999663696 10360209408 1016388864 11.037 100 87 172 0 1105852048 72501776 16961408
11:18:07 1796 8192000000 9994476384 10363056128 1030028496 11.169 100 87 169 0 1105715280 59108640 16578144
11:19:10 1450 8192000000 10023249616 10396291072 1048518768 11.346 100 82 164 2 1133186352 67601872 17065712
11:20:14 2442 8192000000 10023830352 10398453760 1063905088 11.494 100 87 173 0 1139466528 57277488 18283952
11:21:18 53446 8192000000 10000033888 10385125376 1079853360 11.646 100 73 146 1 1127407216 31161232 16392624
11:23:13 7719 8192000000 10005646576 10401894400 1080596896 11.653 100 45 92 0 1111759408 21611552 9550960
11:24:21 6079 8192000000 9993133984 10396557312 1087200256 11.716 100 44 86 1 1119223776 22336256 9687264
11:25:31 6723 8192000000 10004331696 10403475456 1091015136 11.752 100 32 62 1 1131394112 34467936 5911040
11:26:39 10861 8192000000 9988292752 10399694848 1093345952 11.774 100 24 48 1 1121106288 22957200 4803136
11:27:50 50894 8192000000 10022384160 10425131008 1095687040 11.797 100 53 106 0 1130811824 24019456 11105328
11:29:51 18865 8192000000 10073804240 10481119232 1110141520 11.934 100 42 83 1 1180328704 61509664 8677520
11:31:16 23944 8192000000 10077253856 10485231616 1099111296 11.829 99 39 78 0 1174871392 67414848 8345248
11:32:45 11682 8192000000 10080151728 10484006912 1101875264 11.855 100 36 72 0 1198832112 88926736 8030112
11:33:59 16129 8192000000 10111593920 10524491776 1112942400 11.960 100 41 80 2 1232307584 110327840 9037344
11:35:32 25409 8192000000 10124407136 10539606016 1113704112 11.967 99 45 90 1 1239394912 115802928 9887872
11:37:06 9231 8192000000 10135277616 10534871040 1093047200 11.772 98 51 103 0 1221451616 117397376 11007040
11:38:22 19888 8192000000 10163228224 10564849664 1116274656 11.992 99 51 100 0 1253684368 126169008 11240704
11:39:53 3015 8192000000 10191311536 10594033664 1126402400 12.087 99 57 112 0 1296562976 157676192 12484384
11:41:01 5253 8192000000 10212610688 10604163072 1115881888 11.988 99 80 159 1 1307734480 174357216 17495376
11:42:11 7943 8192000000 10235473648 10645073920 1115665808 11.986 100 45 87 2 1348667424 222792608 10209008
11:43:23 4385 8192000000 10265527168 10682175488 1105204560 11.887 100 65 130 1 1387821584 267386640 15230384
11:44:35 17142 8192000000 10238902640 10677940224 1083937136 11.685 98 41 81 0 1328505728 234881200 9687392
11:46:07 7948 8192000000 10228949728 10626424832 1110126112 11.934 100 66 125 1 1325317744 201250080 13941552
11:47:18 8528 8192000000 10239745440 10661281792 1115435008 11.984 99 42 83 1 1362543712 237675024 9433680
11:48:41 17127 8192000000 10249939008 10695041024 1116169264 11.991 100 26 52 0 1368539552 245960784 6409504
11:50:14 18990 8192000000 10237693040 10655522816 1115734208 11.987 98 37 74 1 1317996816 194210176 8052432
11:51:35 13323 8192000000 10187161424 10639015936 1130150240 12.123 100 17 34 0 1295015536 160977952 3887344
11:53:01 23072 8192000000 10148451744 10568802304 1127311120 12.096 100 34 67 0 1240973248 105943872 7718256
11:54:35 91496 8192000000 10094381232 10566672384 1129270800 12.114 100 12 24 1 1213058016 81386192 2401024
11:57:15 35167 8192000000 10073814656 10498641920 1109134480 11.924 98 33 65 1 1171841312 55998592 6708240
11:58:53 6027 8192000000 10125612880 10545729536 1128966400 12.112 100 54 108 1 1215277968 75228304 11083264
12:00:08 30075 8192000000 10075035936 10497323008 1133177616 12.151 100 23 46 0 1153250928 15250912 4822400
12:01:40 53516 8192000000 10109214032 10561105920 1149120256 12.301 100 11 22 0 1219000160 67465152 2414752
12:03:42 20361 8192000000 10083308992 10526167040 1144381392 12.257 100 12 24 1 1204655936 57425136 2849408
12:05:03 22890 8192000000 10121682128 10576871424 1153669232 12.344 100 13 27 1 1224079376 67388960 3021184
12:06:40 26777 8192000000 10126325072 10558644224 1158770272 12.392 100 55 108 2 1231744448 61297840 11676336
12:08:14 23361 8192000000 10110725568 10553298944 1152092736 12.329 100 22 44 0 1204235872 47520976 4622160
12:09:42 70729 8192000000 10073029136 10568425472 1141824512 12.233 99 12 24 1 1177911616 33677072 2410032
12:11:53 39145 8192000000 10095264480 10534744064 1139762352 12.213 99 25 50 0 1193904000 49139536 5002112
12:13:36 26520 8192000000 10143454800 10585862144 1162121392 12.423 100 26 52 0 1244235760 76785632 5328736
12:15:07 40367 8192000000 10091367120 10556137472 1135211376 12.170 98 40 77 1 1199423024 55078032 9133616
12:16:49 41877 8192000000 10151588688 10602528768 1141143680 12.226 99 26 50 0 1205893280 59785312 4964288
12:19:47 54240 8192000000 10092398992 10579034112 1120471120 12.031 98 23 45 0 1198252560 73775664 4005776
12:21:44 64211 8192000000 10054384784 10511904768 1079111264 11.639 95 20 40 1 1120809184 38316096 3381824
12:24:09 15968 8192000000 10090276160 10518642688 1117308720 12.002 98 38 76 0 1174122560 49140032 7673808
12:25:26 46652 8192000000 10044285120 10486390784 1071061248 11.562 97 10 20 0 1129982432 57069760 1851424
12:27:26 45669 8192000000 10072554096 10531852288 1086884368 11.713 98 24 49 0 1136690912 44331376 5475168
12:29:12 66251 8192000000 10077741568 10509475840 1058598208 11.443 95 21 39 0 1146161200 83298224 4264768
12:31:26 71628 8192000000 10058388144 10505134080 1033665088 11.204 94 19 38 0 1135591344 97685680 4240576
12:34:16 68031 8192000000 10033547408 10478792704 1048223008 11.344 96 9 18 0 1091567248 41669936 1674304
12:36:27 31866 8192000000 10049483824 10451677184 1065072304 11.505 97 37 70 0 1096882720 23712672 8097744
12:38:04 46860 8192000000 10042360704 10497458176 1098198128 11.821 100 7 15 0 1134157440 34767008 1192304
12:39:51 89707 8192000000 10054498752 10486022144 1115219952 11.982 100 15 30 0 1190578496 72043184 3315360
12:42:49 5658 8192000000 10063932832 10493423616 1122258656 12.048 100 53 107 3 1160930608 27009248 11662704
12:43:56 85975 8192000000 10056708464 10523738112 1104996848 11.885 98 5 10 0 1151112800 45278192 837760
12:46:23 33021 8192000000 10066808016 10533011456 1133691552 12.156 100 19 38 0 1182846352 44900848 4253952
12:48:34 42803 8192000000 10091255744 10563190784 1145861936 12.271 100 11 20 0 1185806880 37678688 2266256
12:50:26 90727 8192000000 10105663008 10569039872 1131654576 12.137 98 23 47 0 1240162512 103321392 5186544
12:52:59 64416 8192000000 10146540208 10584137728 1161623264 12.418 100 25 50 0 1210010400 43241568 5145568
12:55:03 31464 8192000000 10092345136 10519818240 1122970800 12.055 97 26 53 0 1161113808 32427568 5715440
12:56:37 32444 8192000000 10096958656 10539999232 1157053488 12.376 100 26 52 0 1201539216 39571952 4913776
12:58:09 17717 8192000000 10129733824 10562318336 1155370256 12.360 100 53 105 0 1215789728 50262896 10156576
12:59:29 47602 8192000000 10093151616 10554937344 1140106640 12.217 99 24 47 1 1238849264 94003648 4738976
13:01:17 96989 8192000000 10078551312 10518384640 1147601840 12.287 100 27 54 0 1190485440 36741248 6142352
13:03:57 65645 8192000000 10077398672 10534350848 1124922208 12.073 98 5 10 0 1170197904 44297136 978560
13:06:17 45234 8192000000 10062838416 10532417536 1118239872 12.010 99 11 22 0 1164495120 43847984 2407264

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:14, from 08-03-2024 13:09:39 to 08-03-2024 13:09:53.

Exceptions occured during test was in run

FB_MNEMONA CNT UNIT FB_GDSCODE
except 135 v_add_invoice_to_stock 335544517
except 4 v_cancel_supplier_invoice 335544517

Completed "Exceptions occured during test was in run". Done for 00:00:02, from 08-03-2024 13:09:54 to 08-03-2024 13:09:56.

Content of mon$database and FB version 


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


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

Database statistics 

 
Database "/home/bases/oltp40-etalone.fdb" 
Gstat execution time Fri Mar  8 13:09:57 2024 
 
Database header page information: 
    Flags            0 
    Generation        90656 
    System Change Number    0 
    Page size        8192 
    ODS version        13.0 
    Oldest transaction    171464 
    Oldest active        173795 
    Oldest snapshot        173795 
    Next transaction    173796 
    Sequence number        0 
    Next attachment ID    692 
    Implementation        HW=AMD/Intel/x64 little-endian OS=Linux CC=gcc 
    Shadow count        0 
    Page buffers        0 
    Next header page    0 
    Database dialect    3 
    Creation date        Apr 30, 2020 7:30:08 
    Attributes        force write 
 
    Variable header data: 
    Database GUID:    {58978C10-B735-40F5-8B7D-F7A1956E782B} 
    Sweep interval:        0 
    *END* 
 
 
Database file sequence: 
File /home/bases/oltp40-etalone.fdb is the only file 
 
Analyzing database pages ... 
AGENTS (150) 
    Primary pointer page: 524, Index root page: 525 
    Total formats: 1, used formats: 1 
    Average record length: 33.60, total records: 50 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 344.00, compression ratio: 10.24 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 31% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 1 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index AGENTS_ID_DESC (2) 
    Root page: 1504333, depth: 1, leaf buckets: 1, nodes: 50 
    Average node length: 11.82, total dup: 0, max dup: 0 
    Average key length: 10.80, compression ratio: 0.83 
    Average prefix length: 1.18, average data length: 7.82 
    Clustering factor: 1, ratio: 0.02 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index AGENTS_IS_OUR_FIRM (4) 
    Root page: 1504335, depth: 1, leaf buckets: 1, nodes: 50 
    Average node length: 3.08, total dup: 48, max dup: 48 
    Average key length: 2.04, compression ratio: 0.50 
    Average prefix length: 0.96, average data length: 0.06 
    Clustering factor: 1, ratio: 0.02 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index AGENTS_IS_SUPPLIER (3) 
    Root page: 1504334, depth: 1, leaf buckets: 1, nodes: 50 
    Average node length: 3.08, total dup: 48, max dup: 44 
    Average key length: 2.04, compression ratio: 0.54 
    Average prefix length: 1.04, average data length: 0.06 
    Clustering factor: 1, ratio: 0.02 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index AGENTS_NAME_UNQ (1) 
    Root page: 1504332, depth: 1, leaf buckets: 1, nodes: 50 
    Average node length: 17.20, total dup: 0, max dup: 0 
    Average key length: 15.88, compression ratio: 0.92 
    Average prefix length: 1.42, average data length: 13.20 
    Clustering factor: 1, ratio: 0.02 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PK_AGENTS (0) 
    Root page: 1504331, depth: 1, leaf buckets: 1, nodes: 50 
    Average node length: 11.82, total dup: 0, max dup: 0 
    Average key length: 10.80, compression ratio: 0.83 
    Average prefix length: 1.18, average data length: 7.82 
    Clustering factor: 1, ratio: 0.02 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
BUSINESS_OPS (154) 
    Primary pointer page: 532, Index root page: 533 
    Total formats: 1, used formats: 1 
    Average record length: 108.20, total records: 20 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1235.00, compression ratio: 11.41 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 31% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 1 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index BO_UNIT_UNQ (1) 
    Root page: 1504264, depth: 1, leaf buckets: 1, nodes: 20 
    Average node length: 18.25, total dup: 0, max dup: 0 
    Average key length: 17.20, compression ratio: 1.24 
    Average prefix length: 7.05, average data length: 14.25 
    Clustering factor: 1, ratio: 0.05 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index BUSINESS_OPS_PREDICT_PRIOR (3) 
    Root page: 1504266, depth: 1, leaf buckets: 1, nodes: 20 
    Average node length: 5.40, total dup: 0, max dup: 0 
    Average key length: 4.35, compression ratio: 0.67 
    Average prefix length: 1.20, average data length: 1.70 
    Clustering factor: 1, ratio: 0.05 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index BUSINESS_OPS_RND_WGTH (2) 
    Root page: 1504265, depth: 1, leaf buckets: 1, nodes: 20 
    Average node length: 4.30, total dup: 6, max dup: 3 
    Average key length: 3.25, compression ratio: 0.72 
    Average prefix length: 1.35, average data length: 1.00 
    Clustering factor: 1, ratio: 0.05 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index RDB$1 (0) 
    Root page: 1504263, depth: 1, leaf buckets: 1, nodes: 20 
    Average node length: 5.20, total dup: 0, max dup: 0 
    Average key length: 4.15, compression ratio: 0.65 
    Average prefix length: 1.10, average data length: 1.60 
    Clustering factor: 1, ratio: 0.05 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
DOC_DATA (139) 
    Primary pointer page: 502, Index root page: 503 
    Total formats: 1, used formats: 1 
    Average record length: 47.59, total records: 7759667 
    Average version length: 48.17, total versions: 60862, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 64.00, compression ratio: 1.34 
    Pointer pages: 55, data page slots: 89168 
    Data pages: 89168, average fill: 70% 
    Primary pages: 89167, secondary pages: 1, swept pages: 41654 
    Empty pages: 1, full pages: 69409 
    Fill distribution: 
     0 - 19% = 11 
    20 - 39% = 67 
    40 - 59% = 2264 
    60 - 79% = 86779 
    80 - 99% = 47 
 
    Index DOC_DATA_DOC_WARE_UNQ (0) 
    Root page: 1510636, depth: 3, leaf buckets: 23193, nodes: 7759667 
    Average node length: 18.90, total dup: 0, max dup: 0 
    Average key length: 15.91, compression ratio: 1.70 
    Average prefix length: 14.09, average data length: 12.91 
    Clustering factor: 1684648, ratio: 0.22 
    Fill distribution: 
         0 - 19% = 340 
        20 - 39% = 1660 
        40 - 59% = 4094 
        60 - 79% = 2401 
        80 - 99% = 14698 
 
    Index DOC_DATA_ID_DESC (1) 
    Root page: 1528140, depth: 3, leaf buckets: 13444, nodes: 7759667 
    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: 1509451, ratio: 0.19 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 1432 
        40 - 59% = 2077 
        60 - 79% = 1085 
        80 - 99% = 8850 
 
    Index FK_DOC_DATA_DOC_LIST (2) 
    Root page: 1546735, depth: 3, leaf buckets: 8286, nodes: 7759667 
    Average node length: 6.62, total dup: 5796365, max dup: 49 
    Average key length: 3.63, compression ratio: 2.48 
    Average prefix length: 7.62, average data length: 1.38 
    Clustering factor: 1502532, ratio: 0.19 
    Fill distribution: 
         0 - 19% = 124 
        20 - 39% = 887 
        40 - 59% = 1375 
        60 - 79% = 899 
        80 - 99% = 5001 
 
DOC_LIST (138) 
    Primary pointer page: 500, Index root page: 501 
    Total formats: 1, used formats: 1 
    Average record length: 56.79, total records: 2253683 
    Average version length: 58.82, total versions: 31191, max versions: 2 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 84.00, compression ratio: 1.48 
    Pointer pages: 18, data page slots: 28776 
    Data pages: 28776, average fill: 72% 
    Primary pages: 28774, secondary pages: 2, swept pages: 10846 
    Empty pages: 3, full pages: 18151 
    Fill distribution: 
     0 - 19% = 9 
    20 - 39% = 39 
    40 - 59% = 492 
    60 - 79% = 28169 
    80 - 99% = 67 
 
    Index DOC_LIST_ID_DESC (1) 
    Root page: 1541152, depth: 3, leaf buckets: 4539, nodes: 2253683 
    Average node length: 11.40, total dup: 0, max dup: 0 
    Average key length: 8.44, compression ratio: 1.07 
    Average prefix length: 3.56, average data length: 5.44 
    Clustering factor: 691332, ratio: 0.31 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 878 
        40 - 59% = 849 
        60 - 79% = 746 
        80 - 99% = 2066 
 
    Index DOC_LIST_WORKER_OPTYPE (2) 
    Root page: 1544398, depth: 3, leaf buckets: 2435, nodes: 2254996 
    Average node length: 4.97, total dup: 2254097, max dup: 18652 
    Average key length: 2.01, compression ratio: 4.48 
    Average prefix length: 8.99, average data length: 0.01 
    Clustering factor: 1261071, ratio: 0.56 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 185 
        40 - 59% = 1450 
        60 - 79% = 525 
        80 - 99% = 274 
 
    Index FK_DOC_LIST_AGENTS (3) 
    Root page: 1545933, depth: 3, leaf buckets: 1778, nodes: 2253683 
    Average node length: 4.97, total dup: 2253633, max dup: 130264 
    Average key length: 2.01, compression ratio: 4.48 
    Average prefix length: 8.99, average data length: 0.01 
    Clustering factor: 1070304, ratio: 0.47 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 4 
        40 - 59% = 625 
        60 - 79% = 45 
        80 - 99% = 1104 
 
    Index PK_DOC_LIST (0) 
    Root page: 1538209, depth: 3, leaf buckets: 4318, nodes: 2253683 
    Average node length: 11.40, total dup: 0, max dup: 0 
    Average key length: 8.44, compression ratio: 1.07 
    Average prefix length: 3.56, average data length: 5.44 
    Clustering factor: 691332, ratio: 0.31 
    Fill distribution: 
         0 - 19% = 97 
        20 - 39% = 546 
        40 - 59% = 597 
        60 - 79% = 814 
        80 - 99% = 2264 
 
DOC_STATES (149) 
    Primary pointer page: 522, Index root page: 523 
    Total formats: 1, used formats: 1 
    Average record length: 67.50, total records: 4 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 650.00, compression ratio: 9.63 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 4% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index DOC_STATES_MCODE_UNQ (1) 
    Root page: 1504337, depth: 1, leaf buckets: 1, nodes: 4 
    Average node length: 17.75, total dup: 0, max dup: 0 
    Average key length: 16.50, compression ratio: 1.08 
    Average prefix length: 4.00, average data length: 13.75 
    Clustering factor: 1, ratio: 0.25 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index DOC_STATES_NAME_UNQ (2) 
    Root page: 1504338, depth: 1, leaf buckets: 1, nodes: 4 
    Average node length: 33.25, total dup: 0, max dup: 0 
    Average key length: 32.00, compression ratio: 0.99 
    Average prefix length: 2.50, average data length: 29.25 
    Clustering factor: 1, ratio: 0.25 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PK_DOC_STATES (0) 
    Root page: 1504336, depth: 1, leaf buckets: 1, nodes: 4 
    Average node length: 4.75, total dup: 0, max dup: 0 
    Average key length: 3.50, compression ratio: 0.86 
    Average prefix length: 1.50, average data length: 1.50 
    Clustering factor: 1, ratio: 0.25 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
FB_ERRORS (155) 
    Primary pointer page: 534, Index root page: 535 
    Total formats: 2, used formats: 2 
    Average record length: 57.88, total records: 2182 
    Average version length: 79.61, total versions: 757, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 270.43, compression ratio: 4.67 
    Pointer pages: 1, data page slots: 40 
    Data pages: 40, average fill: 72% 
    Primary pages: 39, secondary pages: 1, swept pages: 0 
    Empty pages: 4, full pages: 34 
    Fill distribution: 
     0 - 19% = 5 
    20 - 39% = 0 
    40 - 59% = 1 
    60 - 79% = 22 
    80 - 99% = 12 
 
    Index FB_ERRORS_GDS_CODE (0) 
    Root page: 398, depth: 2, leaf buckets: 2, nodes: 2182 
    Average node length: 4.40, total dup: 756, max dup: 1 
    Average key length: 2.67, compression ratio: 1.87 
    Average prefix length: 4.33, average data length: 0.67 
    Clustering factor: 1518, ratio: 0.70 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 0 
        40 - 59% = 1 
        60 - 79% = 1 
        80 - 99% = 0 
 
INVNT_SALDO (145) 
    Primary pointer page: 514, Index root page: 515 
    Total formats: 2, used formats: 1 
    Average record length: 83.17, total records: 400 
    Average version length: 29.62, total versions: 2023, max versions: 6 
    Average fragment length: 2.15, total fragments: 13, max fragments: 1 
    Average unpacked length: 104.00, compression ratio: 1.25 
    Pointer pages: 1, data page slots: 24 
    Data pages: 24, average fill: 69% 
    Primary pages: 12, secondary pages: 12, swept pages: 0 
    Empty pages: 5, full pages: 17 
    Fill distribution: 
     0 - 19% = 5 
    20 - 39% = 2 
    40 - 59% = 0 
    60 - 79% = 1 
    80 - 99% = 16 
 
    Index PK_INVNT_SALDO (0) 
    Root page: 1510371, depth: 1, leaf buckets: 1, nodes: 400 
    Average node length: 11.22, total dup: 0, max dup: 0 
    Average key length: 10.22, compression ratio: 0.88 
    Average prefix length: 1.78, average data length: 7.22 
    Clustering factor: 326, ratio: 0.81 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 0 
        40 - 59% = 1 
        60 - 79% = 0 
        80 - 99% = 0 
 
INVNT_TURNOVER_LOG (153) 
    Primary pointer page: 530, Index root page: 531 
    Total formats: 1, used formats: 1 
    Average record length: 11.70, total records: 78603 
    Average version length: 68.27, total versions: 75022, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 88.00, compression ratio: 7.52 
    Pointer pages: 6, data page slots: 2368 
    Data pages: 1464, average fill: 73% 
    Primary pages: 1463, secondary pages: 1, swept pages: 3 
    Empty pages: 124, full pages: 1011 
    Fill distribution: 
     0 - 19% = 227 
    20 - 39% = 58 
    40 - 59% = 74 
    60 - 79% = 130 
    80 - 99% = 975 
 
    Index INVNT_TURNOVER_LOG_WARE_DD_ID (0) 
    Root page: 1701840, depth: 3, leaf buckets: 354, nodes: 78603 
    Average node length: 13.36, total dup: 4447, max dup: 2 
    Average key length: 10.75, compression ratio: 2.51 
    Average prefix length: 19.19, average data length: 7.81 
    Clustering factor: 58429, ratio: 0.74 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 278 
        40 - 59% = 63 
        60 - 79% = 13 
        80 - 99% = 0 
 
MONEY_SALDO (141) 
    Primary pointer page: 506, Index root page: 507 
    Total formats: 1, used formats: 1 
    Average record length: 15.18, total records: 49 
    Average version length: 9.00, total versions: 173, max versions: 5 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 32.00, compression ratio: 2.11 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 75% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 1 
    80 - 99% = 0 
 
    Index PK_MONEY_SALDO (0) 
    Root page: 1510383, depth: 1, leaf buckets: 1, nodes: 49 
    Average node length: 11.82, total dup: 0, max dup: 0 
    Average key length: 10.80, compression ratio: 0.83 
    Average prefix length: 1.18, average data length: 7.82 
    Clustering factor: 1, ratio: 0.02 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
MONEY_TURNOVER_LOG (140) 
    Primary pointer page: 504, Index root page: 505 
    Total formats: 1, used formats: 1 
    Average record length: 10.37, total records: 1598 
    Average version length: 43.18, total versions: 1535, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 58.00, compression ratio: 5.59 
    Pointer pages: 1, data page slots: 40 
    Data pages: 40, average fill: 43% 
    Primary pages: 39, secondary pages: 1, swept pages: 6 
    Empty pages: 15, full pages: 15 
    Fill distribution: 
     0 - 19% = 21 
    20 - 39% = 0 
    40 - 59% = 1 
    60 - 79% = 4 
    80 - 99% = 14 
 
    Index MONEY_TURNOVER_LOG_AGENT_OPTYPE (0) 
    Root page: 90676, depth: 2, leaf buckets: 2, nodes: 1598 
    Average node length: 4.30, total dup: 1501, max dup: 138 
    Average key length: 2.65, compression ratio: 7.17 
    Average prefix length: 18.41, average data length: 0.59 
    Clustering factor: 873, 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: 555, Index root page: 556 
    Total formats: 2, used formats: 1 
    Average record length: 97.73, total records: 73 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 112.00, compression ratio: 1.15 
    Pointer pages: 1, data page slots: 2 
    Data pages: 2, average fill: 51% 
    Primary pages: 2, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 1 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 1 
    40 - 59% = 0 
    60 - 79% = 1 
    80 - 99% = 0 
 
    Index PK_MON_CACHE_MEMORY (0) 
    Root page: 1504238, depth: 1, leaf buckets: 1, nodes: 73 
    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: 548, Index root page: 549 
    Total formats: 2, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index MON_LOG_DTS (4) 
    Root page: 1504251, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index MON_LOG_GDSCODE (2) 
    Root page: 1504249, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index MON_LOG_ROWSET_DESC (1) 
    Root page: 1504248, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index MON_LOG_UNIT (3) 
    Root page: 1504250, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PK_MON_LOG (0) 
    Root page: 1504247, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
MON_LOG_TABLE_STATS (163) 
    Primary pointer page: 550, Index root page: 551 
    Total formats: 2, used formats: 1 
    Average record length: 67.13, total records: 30 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 611.00, compression ratio: 9.10 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 31% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 1 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index MON_LOG_TABLE_STATS_DTS (4) 
    Root page: 1504246, depth: 1, leaf buckets: 1, nodes: 30 
    Average node length: 3.50, total dup: 23, max dup: 4 
    Average key length: 2.47, compression ratio: 3.24 
    Average prefix length: 7.53, average data length: 0.47 
    Clustering factor: 1, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index MON_LOG_TABLE_STATS_GDSCODE (2) 
    Root page: 1504244, depth: 1, leaf buckets: 1, nodes: 30 
    Average node length: 2.00, total dup: 29, max dup: 29 
    Average key length: 1.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 1, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index MON_LOG_TABLE_STATS_ROWSET (1) 
    Root page: 1504243, depth: 1, leaf buckets: 1, nodes: 30 
    Average node length: 3.33, total dup: 29, max dup: 29 
    Average key length: 2.30, compression ratio: 3.91 
    Average prefix length: 8.70, average data length: 0.30 
    Clustering factor: 1, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index MON_LOG_TABLE_STATS_TN_UNIT (3) 
    Root page: 1504245, depth: 1, leaf buckets: 1, nodes: 30 
    Average node length: 12.90, total dup: 0, max dup: 0 
    Average key length: 11.87, compression ratio: 1.42 
    Average prefix length: 7.63, average data length: 9.20 
    Clustering factor: 1, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PK_MON_LOG_TABLE_STATS (0) 
    Root page: 1504242, depth: 1, leaf buckets: 1, nodes: 30 
    Average node length: 8.37, total dup: 0, max dup: 0 
    Average key length: 7.33, compression ratio: 1.23 
    Average prefix length: 4.63, average data length: 4.37 
    Clustering factor: 1, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
OPTYPES (136) 
    Primary pointer page: 496, Index root page: 497 
    Total formats: 2, used formats: 1 
    Average record length: 67.56, total records: 9 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 386.00, compression ratio: 5.71 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 9% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index OPTYPES_MCODE_UNQ (1) 
    Root page: 1544827, depth: 1, leaf buckets: 1, nodes: 9 
    Average node length: 8.56, total dup: 0, max dup: 0 
    Average key length: 6.89, compression ratio: 0.73 
    Average prefix length: 0.44, average data length: 4.56 
    Clustering factor: 1, ratio: 0.11 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PK_OPTYPES (0) 
    Root page: 1544826, depth: 1, leaf buckets: 1, nodes: 9 
    Average node length: 6.11, total dup: 0, max dup: 0 
    Average key length: 5.00, compression ratio: 0.60 
    Average prefix length: 0.89, average data length: 2.11 
    Clustering factor: 1, ratio: 0.11 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
PDISTR (146) 
    Primary pointer page: 516, Index root page: 517 
    Total formats: 1, used formats: 1 
    Average record length: 35.93, total records: 793456 
    Average version length: 37.92, total versions: 36194, max versions: 2 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 54.00, compression ratio: 1.50 
    Pointer pages: 6, data page slots: 8360 
    Data pages: 8360, average fill: 65% 
    Primary pages: 8359, secondary pages: 1, swept pages: 1891 
    Empty pages: 10, full pages: 5554 
    Fill distribution: 
     0 - 19% = 28 
    20 - 39% = 53 
    40 - 59% = 685 
    60 - 79% = 7528 
    80 - 99% = 66 
 
    Index PDISTR_AGENT_ID (2) 
    Root page: 1509330, depth: 2, leaf buckets: 813, nodes: 776108 
    Average node length: 4.88, total dup: 776059, max dup: 133504 
    Average key length: 2.01, compression ratio: 4.48 
    Average prefix length: 8.99, average data length: 0.01 
    Clustering factor: 89541, ratio: 0.12 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 111 
        40 - 59% = 403 
        60 - 79% = 189 
        80 - 99% = 109 
 
    Index PDISTR_SNDOP_RCVOP_SNDID_ASC (0) 
    Root page: 1508635, depth: 3, leaf buckets: 886, nodes: 776108 
    Average node length: 5.89, total dup: 690756, max dup: 42 
    Average key length: 3.02, compression ratio: 7.28 
    Average prefix length: 21.09, average data length: 0.91 
    Clustering factor: 156487, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 43 
        40 - 59% = 427 
        60 - 79% = 107 
        80 - 99% = 308 
 
    Index PDISTR_SNDOP_RCVOP_SNDID_DESC (1) 
    Root page: 1509209, depth: 3, leaf buckets: 925, nodes: 776108 
    Average node length: 5.89, total dup: 690756, max dup: 42 
    Average key length: 3.02, compression ratio: 7.28 
    Average prefix length: 21.09, average data length: 0.91 
    Clustering factor: 158355, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 104 
        40 - 59% = 432 
        60 - 79% = 99 
        80 - 99% = 290 
 
    Index PDISTR_WORKER_SND_ID (3) 
    Root page: 1510200, depth: 3, leaf buckets: 1120, nodes: 776108 
    Average node length: 5.97, total dup: 690756, max dup: 42 
    Average key length: 3.10, compression ratio: 5.48 
    Average prefix length: 16.01, average data length: 0.99 
    Clustering factor: 151336, ratio: 0.19 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 260 
        40 - 59% = 599 
        60 - 79% = 175 
        80 - 99% = 84 
 
PERF_AGG (158) 
    Primary pointer page: 540, Index root page: 541 
    Total formats: 1, used formats: 1 
    Average record length: 62.73, total records: 5454 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 5.50, total fragments: 10, max fragments: 1 
    Average unpacked length: 379.00, compression ratio: 6.04 
    Pointer pages: 1, data page slots: 88 
    Data pages: 87, average fill: 62% 
    Primary pages: 74, secondary pages: 13, swept pages: 51 
    Empty pages: 7, full pages: 64 
    Fill distribution: 
     0 - 19% = 13 
    20 - 39% = 1 
    40 - 59% = 1 
    60 - 79% = 72 
    80 - 99% = 0 
 
    Index PERF_AGG_UNQ (1) 
    Root page: 1504260, depth: 2, leaf buckets: 6, nodes: 5454 
    Average node length: 5.49, total dup: 0, max dup: 0 
    Average key length: 3.58, compression ratio: 10.04 
    Average prefix length: 34.40, average data length: 1.55 
    Clustering factor: 5086, ratio: 0.93 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 0 
        40 - 59% = 4 
        60 - 79% = 1 
        80 - 99% = 1 
 
    Index PK_PERF_AGG (0) 
    Root page: 1504255, depth: 2, leaf buckets: 10, nodes: 5454 
    Average node length: 11.11, total dup: 0, max dup: 0 
    Average key length: 9.21, compression ratio: 0.98 
    Average prefix length: 2.79, average data length: 6.21 
    Clustering factor: 160, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 1 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 7 
 
PERF_ESTIMATED (280) 
    Primary pointer page: 399, Index root page: 434 
    Total formats: 1, used formats: 1 
    Average record length: 39.13, total records: 78741 
    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: 824 
    Data pages: 824, average fill: 66% 
    Primary pages: 824, secondary pages: 0, swept pages: 0 
    Empty pages: 5, full pages: 818 
    Fill distribution: 
     0 - 19% = 5 
    20 - 39% = 0 
    40 - 59% = 1 
    60 - 79% = 818 
    80 - 99% = 0 
 
    Index PK_PERF_ESTIMATED (0) 
    Root page: 34954, depth: 2, leaf buckets: 100, nodes: 78741 
    Average node length: 10.16, total dup: 0, max dup: 0 
    Average key length: 8.17, compression ratio: 1.10 
    Average prefix length: 3.83, average data length: 5.17 
    Clustering factor: 3056, ratio: 0.04 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 1 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 99 
 
PERF_ISQL_STAT (156) 
    Primary pointer page: 536, Index root page: 537 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index PERF_ISQL_STAT_TRN (0) 
    Root page: 1504261, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
PERF_LOG (159) 
    Primary pointer page: 542, Index root page: 543 
    Total formats: 1, used formats: 1 
    Average record length: 111.07, total records: 71 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1691.00, compression ratio: 15.22 
    Pointer pages: 1, data page slots: 2 
    Data pages: 2, average fill: 56% 
    Primary pages: 2, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 1 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 1 
    40 - 59% = 0 
    60 - 79% = 1 
    80 - 99% = 0 
 
PERF_SPLIT_0 (281) 
    Primary pointer page: 601, Index root page: 602 
    Total formats: 1, used formats: 1 
    Average record length: 145.80, total records: 162458 
    Average version length: 150.66, total versions: 6201, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.63 
    Pointer pages: 5, data page slots: 5512 
    Data pages: 4104, average fill: 82% 
    Primary pages: 4101, secondary pages: 3, swept pages: 11 
    Empty pages: 95, full pages: 3978 
    Fill distribution: 
     0 - 19% = 103 
    20 - 39% = 5 
    40 - 59% = 7 
    60 - 79% = 12 
    80 - 99% = 3977 
 
PERF_SPLIT_1 (282) 
    Primary pointer page: 603, Index root page: 604 
    Total formats: 1, used formats: 1 
    Average record length: 146.34, total records: 136229 
    Average version length: 149.51, total versions: 4665, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.59 
    Pointer pages: 7, data page slots: 4600 
    Data pages: 3416, average fill: 83% 
    Primary pages: 3414, secondary pages: 2, swept pages: 3 
    Empty pages: 57, full pages: 3337 
    Fill distribution: 
     0 - 19% = 62 
    20 - 39% = 7 
    40 - 59% = 6 
    60 - 79% = 5 
    80 - 99% = 3336 
 
PERF_SPLIT_2 (283) 
    Primary pointer page: 605, Index root page: 606 
    Total formats: 1, used formats: 1 
    Average record length: 118.66, total records: 177924 
    Average version length: 154.68, total versions: 40321, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 14.29 
    Pointer pages: 7, data page slots: 5408 
    Data pages: 4424, average fill: 86% 
    Primary pages: 4420, secondary pages: 4, swept pages: 3 
    Empty pages: 35, full pages: 4370 
    Fill distribution: 
     0 - 19% = 42 
    20 - 39% = 8 
    40 - 59% = 1 
    60 - 79% = 2 
    80 - 99% = 4371 
 
PERF_SPLIT_3 (284) 
    Primary pointer page: 607, Index root page: 608 
    Total formats: 1, used formats: 1 
    Average record length: 142.43, total records: 152287 
    Average version length: 152.53, total versions: 9237, 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: 9, data page slots: 4408 
    Data pages: 3816, average fill: 83% 
    Primary pages: 3815, secondary pages: 1, swept pages: 3 
    Empty pages: 61, full pages: 3726 
    Fill distribution: 
     0 - 19% = 66 
    20 - 39% = 5 
    40 - 59% = 13 
    60 - 79% = 6 
    80 - 99% = 3726 
 
PERF_SPLIT_4 (285) 
    Primary pointer page: 609, Index root page: 610 
    Total formats: 1, used formats: 1 
    Average record length: 144.46, total records: 168146 
    Average version length: 151.28, total versions: 8128, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.74 
    Pointer pages: 7, data page slots: 4664 
    Data pages: 4184, average fill: 83% 
    Primary pages: 4181, secondary pages: 3, swept pages: 2 
    Empty pages: 44, full pages: 4126 
    Fill distribution: 
     0 - 19% = 46 
    20 - 39% = 5 
    40 - 59% = 2 
    60 - 79% = 5 
    80 - 99% = 4126 
 
PERF_SPLIT_5 (286) 
    Primary pointer page: 611, Index root page: 612 
    Total formats: 1, used formats: 1 
    Average record length: 147.71, total records: 151421 
    Average version length: 148.99, total versions: 3728, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.48 
    Pointer pages: 7, data page slots: 4704 
    Data pages: 3792, average fill: 83% 
    Primary pages: 3790, secondary pages: 2, swept pages: 6 
    Empty pages: 63, full pages: 3711 
    Fill distribution: 
     0 - 19% = 65 
    20 - 39% = 11 
    40 - 59% = 2 
    60 - 79% = 2 
    80 - 99% = 3712 
 
PERF_SPLIT_6 (287) 
    Primary pointer page: 613, Index root page: 614 
    Total formats: 1, used formats: 1 
    Average record length: 134.65, total records: 166329 
    Average version length: 153.74, total versions: 19190, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 12.60 
    Pointer pages: 7, data page slots: 5440 
    Data pages: 4160, average fill: 84% 
    Primary pages: 4156, secondary pages: 4, swept pages: 3 
    Empty pages: 60, full pages: 4080 
    Fill distribution: 
     0 - 19% = 65 
    20 - 39% = 9 
    40 - 59% = 2 
    60 - 79% = 3 
    80 - 99% = 4081 
 
PERF_SPLIT_7 (288) 
    Primary pointer page: 615, Index root page: 616 
    Total formats: 1, used formats: 1 
    Average record length: 146.64, total records: 139949 
    Average version length: 147.92, total versions: 4096, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.57 
    Pointer pages: 7, data page slots: 4512 
    Data pages: 3544, average fill: 81% 
    Primary pages: 3542, secondary pages: 2, swept pages: 3 
    Empty pages: 97, full pages: 3415 
    Fill distribution: 
     0 - 19% = 101 
    20 - 39% = 15 
    40 - 59% = 5 
    60 - 79% = 7 
    80 - 99% = 3416 
 
PERF_SPLIT_8 (289) 
    Primary pointer page: 617, Index root page: 618 
    Total formats: 1, used formats: 1 
    Average record length: 136.31, total records: 162649 
    Average version length: 152.80, total versions: 16722, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 12.44 
    Pointer pages: 5, data page slots: 5120 
    Data pages: 4088, average fill: 83% 
    Primary pages: 4085, secondary pages: 3, swept pages: 2 
    Empty pages: 67, full pages: 3968 
    Fill distribution: 
     0 - 19% = 71 
    20 - 39% = 10 
    40 - 59% = 33 
    60 - 79% = 5 
    80 - 99% = 3969 
 
PERF_SPLIT_9 (290) 
    Primary pointer page: 619, Index root page: 620 
    Total formats: 1, used formats: 1 
    Average record length: 131.12, total records: 174301 
    Average version length: 154.29, total versions: 24569, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 12.94 
    Pointer pages: 6, data page slots: 5728 
    Data pages: 4344, average fill: 85% 
    Primary pages: 4341, secondary pages: 3, swept pages: 10 
    Empty pages: 45, full pages: 4286 
    Fill distribution: 
     0 - 19% = 48 
    20 - 39% = 7 
    40 - 59% = 1 
    60 - 79% = 2 
    80 - 99% = 4286 
 
PHRASES (143) 
    Primary pointer page: 510, Index root page: 511 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index PHRASES_ID_DESC (3) 
    Root page: 1510376, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PHRASES_NAME (2) 
    Root page: 1510375, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PHRASES_UNQ (1) 
    Root page: 1510374, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PK_PHRASES (0) 
    Root page: 1510373, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
PSTORNED (147) 
    Primary pointer page: 518, Index root page: 519 
    Total formats: 1, used formats: 1 
    Average record length: 52.14, total records: 2119137 
    Average version length: 53.04, total versions: 29395, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 70.00, compression ratio: 1.34 
    Pointer pages: 16, data page slots: 25688 
    Data pages: 25688, average fill: 71% 
    Primary pages: 25670, secondary pages: 18, swept pages: 10805 
    Empty pages: 77, full pages: 23010 
    Fill distribution: 
     0 - 19% = 176 
    20 - 39% = 147 
    40 - 59% = 541 
    60 - 79% = 24529 
    80 - 99% = 295 
 
    Index PSTORNED_RCV_ID (1) 
    Root page: 1506208, depth: 3, leaf buckets: 2592, nodes: 2119137 
    Average node length: 5.44, total dup: 1978260, max dup: 1817 
    Average key length: 2.48, compression ratio: 3.62 
    Average prefix length: 8.58, average data length: 0.42 
    Clustering factor: 183378, ratio: 0.09 
    Fill distribution: 
         0 - 19% = 5 
        20 - 39% = 246 
        40 - 59% = 1737 
        60 - 79% = 319 
        80 - 99% = 285 
 
    Index PSTORNED_SND_ID (0) 
    Root page: 1504841, depth: 3, leaf buckets: 2757, nodes: 2119137 
    Average node length: 5.69, total dup: 1902310, max dup: 64 
    Average key length: 2.74, compression ratio: 3.29 
    Average prefix length: 8.36, average data length: 0.64 
    Clustering factor: 378801, ratio: 0.18 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 7 
        40 - 59% = 2365 
        60 - 79% = 359 
        80 - 99% = 26 
 
    Index PSTORNED_WORKER_ID (2) 
    Root page: 1508018, depth: 3, leaf buckets: 2083, nodes: 2119137 
    Average node length: 4.96, total dup: 2119037, max dup: 27398 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.43, average data length: 0.00 
    Clustering factor: 180542, ratio: 0.09 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 175 
        40 - 59% = 992 
        60 - 79% = 417 
        80 - 99% = 498 
 
RULES_FOR_PDISTR (148) 
    Primary pointer page: 520, Index root page: 521 
    Total formats: 1, used formats: 1 
    Average record length: 17.00, total records: 4 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 334.00, compression ratio: 19.65 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 2% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index RULES_FOR_PDISTR_UNQ (0) 
    Root page: 1504339, depth: 1, leaf buckets: 1, nodes: 4 
    Average node length: 11.50, total dup: 0, max dup: 0 
    Average key length: 10.25, compression ratio: 0.88 
    Average prefix length: 1.50, average data length: 7.50 
    Clustering factor: 1, ratio: 0.25 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
RULES_FOR_QDISTR (137) 
    Primary pointer page: 498, Index root page: 499 
    Total formats: 1, used formats: 1 
    Average record length: 32.71, total records: 7 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 332.00, compression ratio: 10.15 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 4% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index RULES_FOR_QDISTR_RCVOP (1) 
    Root page: 1544825, depth: 1, leaf buckets: 1, nodes: 7 
    Average node length: 5.29, total dup: 2, max dup: 2 
    Average key length: 4.14, compression ratio: 0.72 
    Average prefix length: 1.43, average data length: 1.57 
    Clustering factor: 1, ratio: 0.14 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index RULES_FOR_QDISTR_UNQ (0) 
    Root page: 1544824, depth: 1, leaf buckets: 1, nodes: 7 
    Average node length: 10.14, total dup: 0, max dup: 0 
    Average key length: 8.86, compression ratio: 0.94 
    Average prefix length: 2.14, average data length: 6.14 
    Clustering factor: 1, ratio: 0.14 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
SEMAPHORES (152) 
    Primary pointer page: 528, Index root page: 529 
    Total formats: 1, used formats: 1 
    Average record length: 43.40, total records: 5 
    Average version length: 9.00, total versions: 1, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 346.00, compression ratio: 7.97 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 4% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index PK_SEMAPHORES (0) 
    Root page: 1504327, depth: 1, leaf buckets: 1, nodes: 5 
    Average node length: 12.40, total dup: 0, max dup: 0 
    Average key length: 11.00, compression ratio: 0.82 
    Average prefix length: 0.60, average data length: 8.40 
    Clustering factor: 1, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index SEMAPHORES_TASK_UNQ (1) 
    Root page: 1504328, depth: 1, leaf buckets: 1, nodes: 5 
    Average node length: 23.40, total dup: 0, max dup: 0 
    Average key length: 22.00, compression ratio: 1.07 
    Average prefix length: 4.20, average data length: 19.40 
    Clustering factor: 1, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
SETTINGS (135) 
    Primary pointer page: 494, Index root page: 495 
    Total formats: 1, used formats: 1 
    Average record length: 97.62, total records: 149 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1347.00, compression ratio: 13.80 
    Pointer pages: 1, data page slots: 3 
    Data pages: 3, average fill: 70% 
    Primary pages: 3, secondary pages: 0, swept pages: 1 
    Empty pages: 0, full pages: 2 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 1 
    60 - 79% = 0 
    80 - 99% = 2 
 
    Index SETTINGS_MCODE_WM_UNQ (1) 
    Root page: 1544931, depth: 1, leaf buckets: 1, nodes: 149 
    Average node length: 14.66, total dup: 0, max dup: 0 
    Average key length: 13.55, compression ratio: 2.19 
    Average prefix length: 19.07, average data length: 10.66 
    Clustering factor: 48, ratio: 0.32 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 1 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index SETTINGS_MODE_CODE (0) 
    Root page: 1544828, depth: 1, leaf buckets: 1, nodes: 149 
    Average node length: 25.56, total dup: 0, max dup: 0 
    Average key length: 24.56, compression ratio: 1.63 
    Average prefix length: 18.58, average data length: 21.56 
    Clustering factor: 14, ratio: 0.09 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 0 
        40 - 59% = 1 
        60 - 79% = 0 
        80 - 99% = 0 
 
TMP$DEP_DOCS (129) 
    Primary pointer page: 482, Index root page: 483 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index TMP_DEP_DOCS_UNQ (0) 
    Root page: 1544832, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
TMP$IDX_RECALC (132) 
    Primary pointer page: 488, Index root page: 489 
    Total formats: 2, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index TMP_IDX_RECALC_IDX_NAME_UNQ (0) 
    Root page: 1544829, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
TMP$MON_LOG (133) 
    Primary pointer page: 490, Index root page: 491 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
TMP$MON_LOG_TABLE_STATS (134) 
    Primary pointer page: 492, Index root page: 493 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
TMP$PERF_EST_WHOLE (161) 
    Primary pointer page: 546, Index root page: 547 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
TMP$PERF_LOG (160) 
    Primary pointer page: 544, Index root page: 545 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index TMP$PERF_LOG_UNIT_TRN_DTS_END (0) 
    Root page: 1504252, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
TMP$PERF_MON (131) 
    Primary pointer page: 486, Index root page: 487 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
TMP$RESULT_SET (130) 
    Primary pointer page: 484, Index root page: 485 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index TMP_RESULT_SET_DOC (1) 
    Root page: 1544831, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index TMP_RESULT_SET_WARE_DOC (0) 
    Root page: 1544830, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
TMP$SHOPPING_CART (128) 
    Primary pointer page: 480, Index root page: 481 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index TMP_SHOPCART_UNQ (0) 
    Root page: 1544833, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
TPAUSE (166) 
    Primary pointer page: 557, Index root page: 558 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index RDB$PRIMARY2 (0) 
    Root page: 1504237, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
TRACE_STAT (157) 
    Primary pointer page: 538, Index root page: 539 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
WARES (142) 
    Primary pointer page: 508, Index root page: 509 
    Total formats: 1, used formats: 1 
    Average record length: 77.52, total records: 400 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 444.00, compression ratio: 5.73 
    Pointer pages: 1, data page slots: 6 
    Data pages: 6, average fill: 77% 
    Primary pages: 6, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 5 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 5 
    80 - 99% = 1 
 
    Index FK_WARES_WARE_GROUPS (3) 
    Root page: 1552183, depth: 1, leaf buckets: 1, nodes: 400 
    Average node length: 3.17, total dup: 392, max dup: 60 
    Average key length: 2.16, compression ratio: 4.16 
    Average prefix length: 8.86, average data length: 0.14 
    Clustering factor: 48, ratio: 0.12 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PK_WARES (0) 
    Root page: 1510377, depth: 1, leaf buckets: 1, nodes: 400 
    Average node length: 11.22, total dup: 0, max dup: 0 
    Average key length: 10.22, compression ratio: 0.88 
    Average prefix length: 1.78, average data length: 7.22 
    Clustering factor: 344, ratio: 0.86 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 0 
        40 - 59% = 1 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index WARES_ID_DESC (2) 
    Root page: 1510382, depth: 1, leaf buckets: 1, nodes: 400 
    Average node length: 11.22, total dup: 0, max dup: 0 
    Average key length: 10.22, compression ratio: 0.88 
    Average prefix length: 1.78, average data length: 7.22 
    Clustering factor: 344, ratio: 0.86 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 0 
        40 - 59% = 1 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index WARES_NUMB_UNQ (1) 
    Root page: 1510380, depth: 2, leaf buckets: 3, nodes: 400 
    Average node length: 53.25, total dup: 0, max dup: 0 
    Average key length: 52.23, compression ratio: 1.00 
    Average prefix length: 2.74, average data length: 49.25 
    Clustering factor: 355, ratio: 0.89 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 1 
        80 - 99% = 2 
 
WARE_GROUPS (151) 
    Primary pointer page: 526, Index root page: 527 
    Total formats: 1, used formats: 1 
    Average record length: 32.12, total records: 8 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 346.00, compression ratio: 10.77 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 5% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index PK_WARE_GROUPS (0) 
    Root page: 1504329, depth: 1, leaf buckets: 1, nodes: 8 
    Average node length: 11.25, total dup: 0, max dup: 0 
    Average key length: 10.12, compression ratio: 0.89 
    Average prefix length: 1.75, average data length: 7.25 
    Clustering factor: 1, ratio: 0.12 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index WARE_GROUPS_NAME_UNQ (1) 
    Root page: 1504330, depth: 1, leaf buckets: 1, nodes: 8 
    Average node length: 19.88, total dup: 0, max dup: 0 
    Average key length: 18.12, compression ratio: 0.89 
    Average prefix length: 0.25, average data length: 15.88 
    Clustering factor: 1, ratio: 0.12 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
XQD_1000_1200 (176) 
    Primary pointer page: 577, Index root page: 578 
    Total formats: 1, used formats: 1 
    Average record length: 42.32, total records: 157391 
    Average version length: 69.18, total versions: 70309, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 2.98 
    Pointer pages: 3, data page slots: 3888 
    Data pages: 2784, average fill: 69% 
    Primary pages: 2784, secondary pages: 0, swept pages: 74 
    Empty pages: 83, full pages: 1764 
    Fill distribution: 
     0 - 19% = 143 
    20 - 39% = 177 
    40 - 59% = 409 
    60 - 79% = 973 
    80 - 99% = 1082 
 
    Index XQD_1000_1200_WA_SO_RO_WKR_SND (0) 
    Root page: 1555846, depth: 3, leaf buckets: 235, nodes: 157391 
    Average node length: 6.50, total dup: 137086, max dup: 14 
    Average key length: 3.94, compression ratio: 10.67 
    Average prefix length: 40.19, average data length: 1.81 
    Clustering factor: 26706, ratio: 0.17 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 30 
        40 - 59% = 125 
        60 - 79% = 63 
        80 - 99% = 15 
 
XQD_1000_3300 (178) 
    Primary pointer page: 581, Index root page: 582 
    Total formats: 1, used formats: 1 
    Average record length: 65.63, total records: 6891284 
    Average version length: 68.80, total versions: 381634, 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: 65, data page slots: 105872 
    Data pages: 105872, average fill: 70% 
    Primary pages: 105869, secondary pages: 3, swept pages: 27658 
    Empty pages: 58, full pages: 57547 
    Fill distribution: 
     0 - 19% = 439 
    20 - 39% = 1241 
    40 - 59% = 8396 
    60 - 79% = 95005 
    80 - 99% = 791 
 
    Index XQD_1000_3300_WA_SO_RO_WKR_SND (0) 
    Root page: 1480476, depth: 3, leaf buckets: 10749, nodes: 6891284 
    Average node length: 6.52, total dup: 5958953, max dup: 29 
    Average key length: 3.53, compression ratio: 11.91 
    Average prefix length: 40.61, average data length: 1.39 
    Clustering factor: 1610298, ratio: 0.23 
    Fill distribution: 
         0 - 19% = 6 
        20 - 39% = 1970 
        40 - 59% = 6086 
        60 - 79% = 2247 
        80 - 99% = 440 
 
    Index XQD_1000_3300_WKR_DOC_ASC (1) 
    Root page: 1486090, depth: 3, leaf buckets: 8387, nodes: 6891284 
    Average node length: 5.40, total dup: 6612647, max dup: 177 
    Average key length: 2.41, compression ratio: 7.05 
    Average prefix length: 16.63, average data length: 0.37 
    Clustering factor: 1422841, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 10 
        20 - 39% = 1140 
        40 - 59% = 4864 
        60 - 79% = 1242 
        80 - 99% = 1131 
 
    Index XQD_1000_3300_WKR_DOC_DEC (2) 
    Root page: 1490630, depth: 3, leaf buckets: 8438, nodes: 6891284 
    Average node length: 5.40, total dup: 6612647, max dup: 177 
    Average key length: 2.41, compression ratio: 7.05 
    Average prefix length: 16.63, average data length: 0.37 
    Clustering factor: 1425245, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 8 
        20 - 39% = 1214 
        40 - 59% = 4809 
        60 - 79% = 1269 
        80 - 99% = 1138 
 
XQD_1200_2000 (177) 
    Primary pointer page: 579, Index root page: 580 
    Total formats: 1, used formats: 1 
    Average record length: 67.44, total records: 11839515 
    Average version length: 68.76, total versions: 295603, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.87 
    Pointer pages: 107, data page slots: 173536 
    Data pages: 173536, average fill: 73% 
    Primary pages: 173535, secondary pages: 1, swept pages: 77148 
    Empty pages: 7, full pages: 134448 
    Fill distribution: 
     0 - 19% = 30 
    20 - 39% = 614 
    40 - 59% = 6812 
    60 - 79% = 164563 
    80 - 99% = 1517 
 
    Index XQD_1200_2000_WA_SO_RO_WKR_SND (0) 
    Root page: 1495050, depth: 3, leaf buckets: 18406, nodes: 11837507 
    Average node length: 6.61, total dup: 10316684, max dup: 58 
    Average key length: 3.43, compression ratio: 12.25 
    Average prefix length: 40.70, average data length: 1.30 
    Clustering factor: 2429190, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 25 
        20 - 39% = 2651 
        40 - 59% = 10914 
        60 - 79% = 4040 
        80 - 99% = 776 
 
XQD_2000_3300 (179) 
    Primary pointer page: 583, Index root page: 584 
    Total formats: 1, used formats: 1 
    Average record length: 50.36, total records: 1554898 
    Average version length: 69.02, total versions: 318201, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 2.50 
    Pointer pages: 25, data page slots: 40576 
    Data pages: 30936, average fill: 53% 
    Primary pages: 30832, secondary pages: 104, swept pages: 10488 
    Empty pages: 3851, full pages: 16789 
    Fill distribution: 
     0 - 19% = 5938 
    20 - 39% = 4298 
    40 - 59% = 3440 
    60 - 79% = 13321 
    80 - 99% = 3939 
 
    Index XQD_2000_3300_WA_SO_RO_WKR_SND (0) 
    Root page: 1479735, depth: 3, leaf buckets: 2007, nodes: 1387493 
    Average node length: 5.52, total dup: 1330963, max dup: 49 
    Average key length: 2.57, compression ratio: 16.35 
    Average prefix length: 41.47, average data length: 0.53 
    Clustering factor: 97800, ratio: 0.07 
    Fill distribution: 
         0 - 19% = 10 
        20 - 39% = 618 
        40 - 59% = 1000 
        60 - 79% = 345 
        80 - 99% = 34 
 
XQD_2100_3300 (180) 
    Primary pointer page: 585, Index root page: 586 
    Total formats: 1, used formats: 1 
    Average record length: 40.47, total records: 1099907 
    Average version length: 69.05, total versions: 144624, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 3.11 
    Pointer pages: 21, data page slots: 32520 
    Data pages: 26696, average fill: 36% 
    Primary pages: 26696, secondary pages: 0, swept pages: 7264 
    Empty pages: 5431, full pages: 7302 
    Fill distribution: 
     0 - 19% = 8670 
    20 - 39% = 4327 
    40 - 59% = 7403 
    60 - 79% = 6131 
    80 - 99% = 165 
 
    Index XQD_2100_3300_WA_SO_RO_WKR_SND (0) 
    Root page: 1479229, depth: 3, leaf buckets: 1152, nodes: 721612 
    Average node length: 5.95, total dup: 665022, max dup: 68 
    Average key length: 3.01, compression ratio: 13.93 
    Average prefix length: 41.06, average data length: 0.94 
    Clustering factor: 100570, ratio: 0.14 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 395 
        40 - 59% = 566 
        60 - 79% = 180 
        80 - 99% = 10 
 
XQD_3300_3400 (181) 
    Primary pointer page: 587, Index root page: 588 
    Total formats: 1, used formats: 1 
    Average record length: 66.88, total records: 9231424 
    Average version length: 69.00, total versions: 307463, 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: 86, data page slots: 139976 
    Data pages: 139976, average fill: 70% 
    Primary pages: 139967, secondary pages: 9, swept pages: 55457 
    Empty pages: 186, full pages: 78854 
    Fill distribution: 
     0 - 19% = 525 
    20 - 39% = 1609 
    40 - 59% = 10218 
    60 - 79% = 125796 
    80 - 99% = 1828 
 
    Index XQD_3300_3400_WA_SO_RO_WKR_SND (0) 
    Root page: 1472612, depth: 3, leaf buckets: 13448, nodes: 9228112 
    Average node length: 6.66, total dup: 7654777, max dup: 14 
    Average key length: 3.67, compression ratio: 11.46 
    Average prefix length: 40.50, average data length: 1.50 
    Clustering factor: 2100294, ratio: 0.23 
    Fill distribution: 
         0 - 19% = 3 
        20 - 39% = 1307 
        40 - 59% = 6732 
        60 - 79% = 4677 
        80 - 99% = 729 
 
XQS_1000_1200 (182) 
    Primary pointer page: 589, Index root page: 590 
    Total formats: 1, used formats: 1 
    Average record length: 82.50, total records: 21111572 
    Average version length: 82.89, total versions: 10833, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.53 
    Pointer pages: 196, data page slots: 319272 
    Data pages: 319272, average fill: 81% 
    Primary pages: 319267, secondary pages: 5, swept pages: 13609 
    Empty pages: 37, full pages: 318407 
    Fill distribution: 
     0 - 19% = 66 
    20 - 39% = 44 
    40 - 59% = 129 
    60 - 79% = 49066 
    80 - 99% = 269967 
 
    Index XQS_1000_1200_DOC_ID (1) 
    Root page: 1426738, depth: 3, leaf buckets: 19317, nodes: 21111572 
    Average node length: 5.72, total dup: 20631304, max dup: 161 
    Average key length: 2.16, compression ratio: 4.16 
    Average prefix length: 8.86, average data length: 0.14 
    Clustering factor: 3275803, ratio: 0.16 
    Fill distribution: 
         0 - 19% = 3 
        20 - 39% = 1 
        40 - 59% = 8067 
        60 - 79% = 535 
        80 - 99% = 10711 
 
    Index XQS_1000_1200_RCV_ID (3) 
    Root page: 1457002, depth: 3, leaf buckets: 17108, nodes: 21111572 
    Average node length: 6.31, total dup: 18551084, max dup: 49 
    Average key length: 2.75, compression ratio: 3.27 
    Average prefix length: 8.37, average data length: 0.63 
    Clustering factor: 914893, ratio: 0.04 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 2 
        40 - 59% = 716 
        60 - 79% = 256 
        80 - 99% = 16133 
 
    Index XQS_1000_1200_SND_ID (2) 
    Root page: 1441095, depth: 3, leaf buckets: 21118, nodes: 21111572 
    Average node length: 6.35, total dup: 18471615, max dup: 29 
    Average key length: 2.79, compression ratio: 3.23 
    Average prefix length: 8.34, average data length: 0.66 
    Clustering factor: 3570448, ratio: 0.17 
    Fill distribution: 
         0 - 19% = 6 
        20 - 39% = 0 
        40 - 59% = 8377 
        60 - 79% = 589 
        80 - 99% = 12146 
 
    Index XQS_1000_1200_WORKER_ID (0) 
    Root page: 1413370, depth: 3, leaf buckets: 16037, nodes: 21111572 
    Average node length: 5.56, total dup: 21111472, max dup: 228995 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.42, average data length: 0.00 
    Clustering factor: 943768, ratio: 0.04 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 7 
        40 - 59% = 2852 
        60 - 79% = 327 
        80 - 99% = 12851 
 
XQS_1000_3300 (184) 
    Primary pointer page: 593, Index root page: 594 
    Total formats: 1, used formats: 1 
    Average record length: 80.24, total records: 9664658 
    Average version length: 82.67, total versions: 286531, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.57 
    Pointer pages: 103, data page slots: 166616 
    Data pages: 166584, average fill: 72% 
    Primary pages: 166568, secondary pages: 16, swept pages: 77320 
    Empty pages: 343, full pages: 102603 
    Fill distribution: 
     0 - 19% = 983 
    20 - 39% = 3312 
    40 - 59% = 16484 
    60 - 79% = 125917 
    80 - 99% = 19888 
 
    Index XQS_1000_3300_DOC_ID (1) 
    Root page: 1367524, depth: 3, leaf buckets: 11310, nodes: 9664658 
    Average node length: 5.37, total dup: 9355749, max dup: 181 
    Average key length: 2.23, compression ratio: 4.03 
    Average prefix length: 8.80, average data length: 0.20 
    Clustering factor: 2197441, ratio: 0.23 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 46 
        40 - 59% = 8164 
        60 - 79% = 3008 
        80 - 99% = 90 
 
    Index XQS_1000_3300_RCV_ID (3) 
    Root page: 1379283, depth: 3, leaf buckets: 13336, nodes: 9664658 
    Average node length: 6.24, total dup: 8012614, max dup: 14 
    Average key length: 3.10, compression ratio: 2.90 
    Average prefix length: 8.07, average data length: 0.93 
    Clustering factor: 1550436, ratio: 0.16 
    Fill distribution: 
         0 - 19% = 126 
        20 - 39% = 3583 
        40 - 59% = 4400 
        60 - 79% = 2837 
        80 - 99% = 2390 
 
    Index XQS_1000_3300_SND_ID (2) 
    Root page: 1373081, depth: 3, leaf buckets: 12622, nodes: 9664658 
    Average node length: 5.99, total dup: 8384961, max dup: 41 
    Average key length: 2.85, compression ratio: 3.16 
    Average prefix length: 8.28, average data length: 0.72 
    Clustering factor: 2383573, ratio: 0.25 
    Fill distribution: 
         0 - 19% = 5 
        20 - 39% = 58 
        40 - 59% = 9151 
        60 - 79% = 3291 
        80 - 99% = 117 
 
    Index XQS_1000_3300_WORKER_ID (0) 
    Root page: 1362789, depth: 3, leaf buckets: 9978, nodes: 9664658 
    Average node length: 5.14, total dup: 9664558, max dup: 152969 
    Average key length: 2.00, compression ratio: 1.22 
    Average prefix length: 2.44, average data length: 0.00 
    Clustering factor: 1558756, ratio: 0.16 
    Fill distribution: 
         0 - 19% = 48 
        20 - 39% = 1107 
        40 - 59% = 4832 
        60 - 79% = 1816 
        80 - 99% = 2175 
 
XQS_1200_2000 (183) 
    Primary pointer page: 591, Index root page: 592 
    Total formats: 1, used formats: 1 
    Average record length: 80.84, total records: 11367457 
    Average version length: 82.59, total versions: 226465, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.56 
    Pointer pages: 118, data page slots: 191312 
    Data pages: 190096, average fill: 73% 
    Primary pages: 189964, secondary pages: 132, swept pages: 62405 
    Empty pages: 2063, full pages: 152628 
    Fill distribution: 
     0 - 19% = 3679 
    20 - 39% = 5798 
    40 - 59% = 13386 
    60 - 79% = 102822 
    80 - 99% = 64411 
 
    Index XQS_1200_2000_DOC_ID (1) 
    Root page: 1392123, depth: 3, leaf buckets: 13130, nodes: 11367457 
    Average node length: 5.31, total dup: 11257681, max dup: 683 
    Average key length: 2.08, compression ratio: 4.33 
    Average prefix length: 8.93, average data length: 0.07 
    Clustering factor: 2384480, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 112 
        40 - 59% = 8996 
        60 - 79% = 3812 
        80 - 99% = 210 
 
    Index XQS_1200_2000_RCV_ID (3) 
    Root page: 1406132, depth: 3, leaf buckets: 10458, nodes: 11367457 
    Average node length: 5.51, total dup: 10871164, max dup: 49 
    Average key length: 2.28, compression ratio: 3.95 
    Average prefix length: 8.77, average data length: 0.23 
    Clustering factor: 732484, ratio: 0.06 
    Fill distribution: 
         0 - 19% = 155 
        20 - 39% = 809 
        40 - 59% = 2532 
        60 - 79% = 1828 
        80 - 99% = 5134 
 
    Index XQS_1200_2000_SND_ID (2) 
    Root page: 1398660, depth: 3, leaf buckets: 15015, nodes: 11367457 
    Average node length: 6.04, total dup: 9918923, max dup: 69 
    Average key length: 2.81, compression ratio: 3.21 
    Average prefix length: 8.32, average data length: 0.68 
    Clustering factor: 2400936, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 159 
        40 - 59% = 10417 
        60 - 79% = 4222 
        80 - 99% = 217 
 
    Index XQS_1200_2000_WORKER_ID (0) 
    Root page: 1386233, depth: 3, leaf buckets: 10818, nodes: 11367457 
    Average node length: 5.23, total dup: 11367357, max dup: 212772 
    Average key length: 2.00, compression ratio: 1.22 
    Average prefix length: 2.44, average data length: 0.00 
    Clustering factor: 720230, ratio: 0.06 
    Fill distribution: 
         0 - 19% = 98 
        20 - 39% = 819 
        40 - 59% = 4759 
        60 - 79% = 1537 
        80 - 99% = 3605 
 
XQS_2000_3300 (185) 
    Primary pointer page: 595, Index root page: 596 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index XQS_2000_3300_DOC_ID (1) 
    Root page: 1361775, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index XQS_2000_3300_RCV_ID (3) 
    Root page: 1361777, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index XQS_2000_3300_SND_ID (2) 
    Root page: 1361776, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index XQS_2000_3300_WORKER_ID (0) 
    Root page: 1361774, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
XQS_2100_3300 (186) 
    Primary pointer page: 597, Index root page: 598 
    Total formats: 1, used formats: 1 
    Average record length: 81.17, total records: 9701319 
    Average version length: 82.94, total versions: 206607, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.55 
    Pointer pages: 106, data page slots: 171808 
    Data pages: 171760, average fill: 70% 
    Primary pages: 171736, secondary pages: 24, swept pages: 93976 
    Empty pages: 391, full pages: 96349 
    Fill distribution: 
     0 - 19% = 1351 
    20 - 39% = 6128 
    40 - 59% = 21890 
    60 - 79% = 125074 
    80 - 99% = 17317 
 
    Index XQS_2100_3300_DOC_ID (1) 
    Root page: 1344708, depth: 3, leaf buckets: 11746, nodes: 9701319 
    Average node length: 5.17, total dup: 9672695, max dup: 1875 
    Average key length: 2.03, compression ratio: 4.43 
    Average prefix length: 8.97, average data length: 0.03 
    Clustering factor: 1959525, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 31 
        20 - 39% = 1499 
        40 - 59% = 7862 
        60 - 79% = 1753 
        80 - 99% = 601 
 
    Index XQS_2100_3300_RCV_ID (3) 
    Root page: 1355739, depth: 3, leaf buckets: 13411, nodes: 9701319 
    Average node length: 6.24, total dup: 8042679, max dup: 14 
    Average key length: 3.10, compression ratio: 2.90 
    Average prefix length: 8.07, average data length: 0.93 
    Clustering factor: 1493656, ratio: 0.15 
    Fill distribution: 
         0 - 19% = 186 
        20 - 39% = 3668 
        40 - 59% = 4308 
        60 - 79% = 2779 
        80 - 99% = 2470 
 
    Index XQS_2100_3300_SND_ID (2) 
    Root page: 1350071, depth: 3, leaf buckets: 12378, nodes: 9701319 
    Average node length: 5.43, total dup: 9265789, max dup: 99 
    Average key length: 2.29, compression ratio: 3.93 
    Average prefix length: 8.76, average data length: 0.24 
    Clustering factor: 2094408, ratio: 0.22 
    Fill distribution: 
         0 - 19% = 27 
        20 - 39% = 1459 
        40 - 59% = 8718 
        60 - 79% = 1590 
        80 - 99% = 584 
 
    Index XQS_2100_3300_WORKER_ID (0) 
    Root page: 987843, depth: 3, leaf buckets: 10047, nodes: 9701319 
    Average node length: 5.14, total dup: 9701219, max dup: 155655 
    Average key length: 2.00, compression ratio: 1.22 
    Average prefix length: 2.44, average data length: 0.00 
    Clustering factor: 1560480, ratio: 0.16 
    Fill distribution: 
         0 - 19% = 42 
        20 - 39% = 1203 
        40 - 59% = 4901 
        60 - 79% = 1691 
        80 - 99% = 2210 
 
XQS_3300_3400 (187) 
    Primary pointer page: 599, Index root page: 600 
    Total formats: 1, used formats: 1 
    Average record length: 67.86, total records: 577183 
    Average version length: 68.83, total versions: 3120, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.86 
    Pointer pages: 5, data page slots: 8096 
    Data pages: 8096, average fill: 75% 
    Primary pages: 8096, secondary pages: 0, swept pages: 3884 
    Empty pages: 7, full pages: 6984 
    Fill distribution: 
     0 - 19% = 7 
    20 - 39% = 9 
    40 - 59% = 135 
    60 - 79% = 7895 
    80 - 99% = 50 
 
    Index XQS_3300_3400_DOC_ID (1) 
    Root page: 43954, depth: 3, leaf buckets: 738, nodes: 577183 
    Average node length: 5.95, total dup: 491417, max dup: 82 
    Average key length: 3.09, compression ratio: 2.91 
    Average prefix length: 8.06, average data length: 0.94 
    Clustering factor: 101345, ratio: 0.18 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 33 
        40 - 59% = 509 
        60 - 79% = 104 
        80 - 99% = 91 
 
    Index XQS_3300_3400_SND_ID (2) 
    Root page: 33366, depth: 3, leaf buckets: 758, nodes: 577183 
    Average node length: 6.15, total dup: 473439, max dup: 21 
    Average key length: 3.29, compression ratio: 2.73 
    Average prefix length: 7.89, average data length: 1.11 
    Clustering factor: 101400, ratio: 0.18 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 28 
        40 - 59% = 527 
        60 - 79% = 105 
        80 - 99% = 98 
 
    Index XQS_3300_3400_WORKER_ID (0) 
    Root page: 377587, depth: 2, leaf buckets: 559, nodes: 577183 
    Average node length: 4.86, total dup: 577083, max dup: 9029 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.42, average data length: 0.00 
    Clustering factor: 89990, ratio: 0.16 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 29 
        40 - 59% = 316 
        60 - 79% = 70 
        80 - 99% = 142 
 
ZDOC_DATA (170) 
    Primary pointer page: 565, Index root page: 566 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
ZDOC_LIST (169) 
    Primary pointer page: 563, Index root page: 564 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
ZINVNT_TURNOVER_LOG (171) 
    Primary pointer page: 567, Index root page: 568 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
ZPDISTR (174) 
    Primary pointer page: 573, Index root page: 574 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index ZPDISTR_ID (0) 
    Root page: 1504230, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
ZPSTORNED (175) 
    Primary pointer page: 575, Index root page: 576 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index ZPSTORNED_ID (0) 
    Root page: 1504229, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
ZQDISTR (172) 
    Primary pointer page: 569, Index root page: 570 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index ZQDISTR_ID (0) 
    Root page: 1504235, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index ZQDISTR_WARE_SNDOP_RCVOP (1) 
    Root page: 1504236, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
ZQSTORNED (173) 
    Primary pointer page: 571, Index root page: 572 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index ZQSTORNED_DOC_ID (1) 
    Root page: 1504232, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index ZQSTORNED_ID (0) 
    Root page: 1504231, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index ZQSTORNED_RCV_ID (3) 
    Root page: 1504234, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index ZQSTORNED_SND_ID (2) 
    Root page: 1504233, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
ZTMP_DEP_DOCS (168) 
    Primary pointer page: 561, Index root page: 562 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
ZTMP_SHOPPING_CART (167) 
    Primary pointer page: 559, Index root page: 560 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
Z_USED_VIEWS (144) 
    Primary pointer page: 512, Index root page: 513 
    Total formats: 1, used formats: 1 
    Average record length: 29.38, total records: 29 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 99.00, compression ratio: 3.37 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 16% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index Z_USED_VIEWS_UNQ (0) 
    Root page: 1510372, depth: 1, leaf buckets: 1, nodes: 29 
    Average node length: 15.17, total dup: 0, max dup: 0 
    Average key length: 14.14, compression ratio: 1.44 
    Average prefix length: 9.17, average data length: 11.17 
    Clustering factor: 1, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
Gstat completion time Fri Mar  8 13:10:21 2024

Record versions statistics, table

TABLE_NAME TOTAL_RECS TOTAL_VERS MAX_VERSIONS VERS_TO_RECS_PRC MAXV_TO_VERS_PRC
DOC_DATA 7759667 60862 1 0.0000 0.0000
DOC_LIST 2253683 31191 2 0.0000 0.0000
FB_ERRORS 2182 757 1 0.0000 0.0000
INVNT_SALDO 400 2023 6 500.0000 0.0000
INVNT_TURNOVER_LOG 78603 75022 1 0.0000 0.0000
MONEY_SALDO 49 173 5 300.0000 0.0000
MONEY_TURNOVER_LOG 1598 1535 1 0.0000 0.0000
PDISTR 793456 36194 2 0.0000 0.0000
PERF_SPLIT_0 162458 6201 1 0.0000 0.0000
PERF_SPLIT_1 136229 4665 1 0.0000 0.0000
PERF_SPLIT_2 177924 40321 1 0.0000 0.0000
PERF_SPLIT_3 152287 9237 1 0.0000 0.0000
PERF_SPLIT_4 168146 8128 1 0.0000 0.0000
PERF_SPLIT_5 151421 3728 1 0.0000 0.0000
PERF_SPLIT_6 166329 19190 1 0.0000 0.0000
PERF_SPLIT_7 139949 4096 1 0.0000 0.0000
PERF_SPLIT_8 162649 16722 1 0.0000 0.0000
PERF_SPLIT_9 174301 24569 1 0.0000 0.0000
PSTORNED 2119137 29395 1 0.0000 0.0000
SEMAPHORES 5 1 1 0.0000 100.0000
XQD_1000_1200 157391 70309 1 0.0000 0.0000
XQD_1000_3300 6891284 381634 1 0.0000 0.0000
XQD_1200_2000 11839515 295603 1 0.0000 0.0000
XQD_2000_3300 1554898 318201 1 0.0000 0.0000
XQD_2100_3300 1099907 144624 1 0.0000 0.0000
XQD_3300_3400 9231424 307463 1 0.0000 0.0000
XQS_1000_1200 21111572 10833 1 0.0000 0.0000
XQS_1000_3300 9664658 286531 1 0.0000 0.0000
XQS_1200_2000 11367457 226465 1 0.0000 0.0000
XQS_2100_3300 9701319 206607 1 0.0000 0.0000
XQS_3300_3400 577183 3120 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 ---
:312: 
:313: mscs-test-161.budzdorov.ru    Fri Mar  8 13:07:58 2024
:314:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3400
:315: 
:316: 
:317: mscs-test-161.budzdorov.ru    Fri Mar  8 13:08:00 2024
:318:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3400
:319: 
--- end of diff output ---

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

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