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

Hardware and OS info

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

Server and database settinfs 


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

Test configuration settings 

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

Test finish info 


FINISH_STATE                    NORMAL: TEST_TIME EXPIRED AT 2024-03-02 16:09:40
DTS_END                         2024-03-02 16:09:40.4630
FB_GDSCODE                      -1
FB_MNEMONA                      
STACK                           SP_ADD_INVOICE_TO_STOCK(190:30) ==> SP_CUSTOMER_RESERVE(47:5) ==> SP_CHECK_TO_STOP_WORK(32:12) ==> SP_HALT_ON_ERROR(57:17)
IP                              ::1/32844
TRN_ID                          167780
ATT_ID                          577
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: 8735.64 17985 873564
customer order: creation 165.05 389 16505
customer order: refuse 14.64 379 1464
order to supplier: creation 44.44 1397 4444
order to supplier: removal 3.63 105362 363
invoice (draft): creation 44.60 3453 4460
invoice (draft): removal 48.61 957 4861
invoice accept: apply 39.21 20806 3921
invoice accept: cancel 44.16 924 4416
customer reserve: creation 3744.94 201 374494
customer reserve: removal 4307.04 70 430704
realization accept: apply 79.55 210 7955
realization accept: cancel 78.06 132 7806
payment from customer: creation 55.64 114 5564
payment from customer: removal 5.09 105 509
payment to supplier: creation 45.72 148 4572
payment to supplier: removal 3.31 74 331
service: total inventory turnovers 4.66 1235 466
service: total monetary turnovers 6.32 25 632
service: aggregate perf. data 0.94 18976 94
service: refresh index statistics 0.03 204748 3

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:02, from 02-03-2024 16:10:49 to 02-03-2024 16:10:51.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 3763
TEST_TIME 2 3986
TEST_TIME 3 4058
TEST_TIME 4 4183
TEST_TIME 5 4478
TEST_TIME 6 4582
TEST_TIME 7 4470
TEST_TIME 8 4568
TEST_TIME 9 4756
TEST_TIME 10 4993
TEST_TIME 11 5068
TEST_TIME 12 5509
TEST_TIME 13 5876
TEST_TIME 14 6158
TEST_TIME 15 6199
TEST_TIME 16 6211
TEST_TIME 17 6182
TEST_TIME 18 6136
TEST_TIME 19 6609
TEST_TIME 20 6508
TEST_TIME 21 6597
TEST_TIME 22 6886
TEST_TIME 23 6842
TEST_TIME 24 6798
TEST_TIME 25 7117
TEST_TIME 26 7463
TEST_TIME 27 7332
TEST_TIME 28 7520
TEST_TIME 29 7638
TEST_TIME 30 8315
TEST_TIME 31 8839
TEST_TIME 32 8630
TEST_TIME 33 8549
TEST_TIME 34 8410
TEST_TIME 35 8273
TEST_TIME 36 8385
TEST_TIME 37 8335
TEST_TIME 38 8347
TEST_TIME 39 8273
TEST_TIME 40 8231
TEST_TIME 41 8231
TEST_TIME 42 8162
TEST_TIME 43 8186
TEST_TIME 44 8065
TEST_TIME 45 8206
TEST_TIME 46 8133
TEST_TIME 47 8171
TEST_TIME 48 8165
TEST_TIME 49 8105
TEST_TIME 50 8052
TEST_TIME 51 8225
TEST_TIME 52 8305
TEST_TIME 53 8270
TEST_TIME 54 8398
TEST_TIME 55 8314
TEST_TIME 56 8424
TEST_TIME 57 8485
TEST_TIME 58 8542
TEST_TIME 59 8548
TEST_TIME 60 8592
TEST_TIME 61 8579
TEST_TIME 62 8527
TEST_TIME 63 8442
TEST_TIME 64 8551
TEST_TIME 65 8499
TEST_TIME 66 8499
TEST_TIME 67 8465
TEST_TIME 68 8428
TEST_TIME 69 8367
TEST_TIME 70 8361
TEST_TIME 71 8455
TEST_TIME 72 8440
TEST_TIME 73 8484
TEST_TIME 74 8541
TEST_TIME 75 8552
TEST_TIME 76 8601
TEST_TIME 77 8593
TEST_TIME 78 8646
TEST_TIME 79 8757
TEST_TIME 80 8775
TEST_TIME 81 8757
TEST_TIME 82 8798
TEST_TIME 83 8857
TEST_TIME 84 8848
TEST_TIME 85 8833
TEST_TIME 86 8741
TEST_TIME 87 8738
TEST_TIME 88 8733
TEST_TIME 89 8748
TEST_TIME 90 8719
TEST_TIME 91 8666
TEST_TIME 92 8643
TEST_TIME 93 8640
TEST_TIME 94 8638
TEST_TIME 95 8630
TEST_TIME 96 8676
TEST_TIME 97 8714
TEST_TIME 98 8735
TEST_TIME 99 8721
TEST_TIME 100 8739

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:04, from 02-03-2024 16:10:52 to 02-03-2024 16:10:56.

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 1217140 1217140 0 0.00 0 27907 7 0 0
doc_list_biud 1217138 1217138 0 0.00 0 45700 32 0 0
sp_add_invoice_to_stock 4057 3921 136 3.35 37 226225 20807 0 136
sp_cancel_adding_invoice 4416 4416 0 0.00 3 59290 924 0 0
sp_cancel_client_order 1464 1464 0 0.00 4 14957 379 0 0
sp_cancel_customer_reserve 430704 430704 0 0.00 0 45701 70 0 0
sp_cancel_pay_from_customer 509 509 0 0.00 2 10191 106 0 0
sp_cancel_pay_to_supplier 331 331 0 0.00 2 2498 75 0 0
sp_cancel_supplier_invoice 4873 4861 12 0.24 1 32703 957 0 12
sp_cancel_supplier_order 363 363 0 0.00 5 840431 105363 0 0
sp_cancel_write_off 7806 7806 0 0.00 1 11846 133 0 0
sp_client_order 16505 16505 0 0.00 3 29750 389 0 0
sp_customer_reserve 374494 374494 0 0.00 0 44462 201 0 0
sp_fill_shopping_cart 25405 25405 0 0.00 1 10279 38 0 0
sp_fill_shopping_cart_clo_res 374489 374489 0 0.00 0 23894 16 0 0
sp_get_clo_for_invoice 3916 3916 0 0.00 0 32678 308 0 0
sp_kill_cost_storno 13062 13062 0 0.00 0 24291 75 0 0
sp_kill_qstorno_ret_qs2qd 874438 874438 0 0.00 0 45698 38 0 0
sp_kill_qty_storno 461484 461484 0 0.00 0 45699 83 0 0
sp_lock_selected_doc 16543 16543 0 0.00 0 9552 6 0 0
sp_make_cost_storno 22007 22007 0 0.00 0 27903 63 0 0
sp_multiply_rows_for_pdistr 22006 22006 0 0.00 0 11934 30 0 0
sp_multiply_rows_for_qdistr 16505 16505 0 0.00 0 12015 172 0 0
sp_pay_from_customer 5564 5564 0 0.00 4 11546 114 0 0
sp_pay_to_supplier 4572 4572 0 0.00 5 15548 148 0 0
sp_payment_common 10136 10136 0 0.00 1 10632 29 0 0
sp_qd_handle_on_cancel_clo 1464 1464 0 0.00 0 14938 345 0 0
sp_qd_handle_on_invoice_upd_sts 8331 8331 0 0.00 0 29534 360 0 0
sp_qd_handle_on_reserve_upd_sts 7955 7955 0 0.00 0 24910 88 0 0
sp_reserve_write_off 7955 7955 0 0.00 6 27916 210 0 0
sp_supplier_invoice 4460 4460 0 0.00 6 79171 3453 0 0
sp_supplier_order 4444 4444 0 0.00 5 42762 1398 0 0
srv_aggregate_perf_data 94 94 0 0.00 1684 572666 18976 0 0
srv_fill_mon_cache_memory 54 54 0 0.00 802 119571 41200 0 0
srv_find_qd_qs_mism 833825 833825 0 0.00 0 25426 6 0 0
srv_make_invnt_saldo 466 466 0 0.00 36 116899 1235 0 0
srv_make_money_saldo 632 632 0 0.00 1 719 26 0 0
srv_recalc_idx_stat 3 3 0 0.00 172572 249354 204749 0 0
t$perf-abend:sp_add_invoice_to_stock 136 136 0 0.00 0 0 0 0 0
t$perf-abend:sp_cancel_supplier_invoice 12 12 0 0.00 0 0 0 0 0
t$perf-norm:sp_add_invoice_to_stock 3922 3922 0 0.00 0 23317 258 0 0
t$perf-norm:sp_cancel_adding_invoice 327 327 0 0.00 0 5349 120 0 0
t$perf-norm:sp_cancel_client_order 1464 1464 0 0.00 0 7961 22 0 0
t$perf-norm:sp_cancel_customer_reserve 536 536 0 0.00 0 621 11 0 0
t$perf-norm:sp_cancel_pay_from_customer 509 509 0 0.00 0 21667 49 0 0
t$perf-norm:sp_cancel_pay_to_supplier 331 331 0 0.00 0 214 2 0 0
t$perf-norm:sp_cancel_supplier_invoice 310 310 0 0.00 0 1359 14 0 0
t$perf-norm:sp_cancel_supplier_order 363 363 0 0.00 0 35932 1814 0 0
t$perf-norm:sp_cancel_write_off 833 833 0 0.00 0 11382 32 0 0
t$perf-norm:sp_client_order 16505 16505 0 0.00 0 30812 24 0 0
t$perf-norm:sp_customer_reserve 782 782 0 0.00 0 10156 28 0 0
t$perf-norm:sp_pay_from_customer 5564 5564 0 0.00 0 22252 12 0 0
t$perf-norm:sp_pay_to_supplier 4572 4572 0 0.00 0 7873 13 0 0
t$perf-norm:sp_reserve_write_off 7955 7955 0 0.00 0 14027 19 0 0
t$perf-norm:sp_supplier_invoice 4460 4460 0 0.00 0 21504 34 0 0
t$perf-norm:sp_supplier_order 4444 4444 0 0.00 0 22223 34 0 0
t$perf-norm:srv_aggregate_perf_data 94 94 0 0.00 0 450 14 0 0
t$perf-norm:srv_fill_mon_cache_memory 54 54 0 0.00 0 1355 29 0 0
t$perf-norm:srv_make_invnt_saldo 466 466 0 0.00 0 949 20 0 0
t$perf-norm:srv_make_money_saldo 632 632 0 0.00 0 463 10 0 0
t$perf-norm:srv_recalc_idx_stat 3 3 0 0.00 1 17 7 0 0
v_add_invoice_to_stock 8102 7830 272 3.35 0 4681 18 0 272
v_all_customers 30566 30566 0 0.00 0 19 0 0 0
v_all_suppliers 24866 24866 0 0.00 0 18 1 0 0
v_all_wares 33010 33010 0 0.00 0 17 1 0 0
v_cancel_adding_invoice 654 654 0 0.00 0 2782 12 0 0
v_cancel_client_order 2928 2928 0 0.00 0 1538 5 0 0
v_cancel_customer_prepayment 1018 1018 0 0.00 0 2870 10 0 0
v_cancel_customer_reserve 1072 1072 0 0.00 0 2769 10 0 0
v_cancel_payment_to_supplier 662 662 0 0.00 0 1927 12 0 0
v_cancel_supplier_invoice 644 620 24 3.72 0 634 13 0 24
v_cancel_supplier_order 726 726 0 0.00 0 1421 10 0 0
v_cancel_write_off 1666 1666 0 0.00 0 1858 12 0 0
v_max_id_clo_ord 4443 4443 0 0.00 0 613 2 0 0
v_max_id_clo_res 782 782 0 0.00 0 1177 11 0 0
v_max_id_ord_sup 4457 4457 0 0.00 0 3140 3 0 0
v_max_non_paid_invoice 1039 1039 0 0.00 0 2226 5 0 0
v_max_non_paid_realizn 2717 2717 0 0.00 0 7622 6 0 0
v_min_id_clo_ord 4443 4443 0 0.00 0 4790 12 0 0
v_min_id_clo_res 782 782 0 0.00 0 13450 29 0 0
v_min_id_ord_sup 4457 4457 0 0.00 0 5484 9 0 0
v_min_non_paid_invoice 4572 4572 0 0.00 0 10624 21 0 0
v_min_non_paid_realizn 5564 5564 0 0.00 0 10562 20 0 0
v_our_firm 8138 8138 0 0.00 0 82 1 0 0
v_reserve_write_off 15910 15910 0 0.00 0 5639 7 0 0
x_lock_depdocs_on_canc_invoice 8967 8967 0 0.00 0 9984 128 0 0
x_lock_depdocs_on_canc_sup_ord 363 363 0 0.00 0 14752 390 0 0
x_make_qstorno_1000_1200 4444 4444 0 0.00 1 42756 1317 0 0
x_make_qstorno_1200_2000 4460 4460 0 0.00 3 71765 3318 0 0
x_make_qstorno_2100_3300 374494 374494 0 0.00 0 43207 182 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 02-03-2024 16:10:57 to 02-03-2024 16:11:01.

Memory consumption, metadata cache, attachments activity 

Fields:
  page cache memo used            = page cache total size, bytes:
  memo used, total                = total of mon$memory_usage.mon$memory_used for database level (mon$stat_group = 0);
  memo allocated, total           = the same of mon$memory_usage.mon$memory_allocated;
  metadata cache memo used        = metadata cache, bytes;
  metadata cache percent of total = ratio: metadata cache / (metadata cache + page cache);
  total attachments cnt           = total number of attachments, regardless of state;
  active attachments cnt          = number of attachments with mon$state = 1;
  running statements cnt          = number of statements that are operating with data from page cache (mon$state = 1);
  stalled statements cnt          = number of statements that are waiting for client request for fetching ( mon$state = 2);
  memo used by attachments        = total of mon$memory_usage.mon$memory_used for attachment level (mon$stat_group = 1);
  memo used by transactions       = the same of transaction level (mon$stat_group = 2);
  memo used by statements         = the same of statement level (mon$stat_group = 3);


Page cache type: shared, buffers: 1000000 for all connections, with total size: 8192000000
measurement_dts measurement duration ms page cache memo used memo used, total memo allocated, total metadata cache metadata cache percent of total total attachments cnt active attachments cnt running statements cnt stalled statements cnt memo used by attachments memo used by transactions memo used by statements
14:09:44 2 8192000000 8797116768 8807743488 3953616 0.048 1 1 2 0 4051888 55488 42784
14:10:45 22680 8192000000 9892502992 10195738624 971909984 10.605 100 89 178 0 1001675184 4993840 24771360
14:12:14 14301 8192000000 9927585120 10242195456 1010871136 10.984 100 93 185 0 1042435600 7111136 24453328
14:13:36 12478 8192000000 9952486592 10276925440 1039584704 11.261 100 83 166 0 1069359632 8754672 21020256
14:15:01 8204 8192000000 10018381568 10361376768 1106618896 11.900 100 81 162 0 1135543632 10025952 18898784
14:16:14 4864 8192000000 10073143280 10426257408 1156896816 12.374 100 86 172 0 1189485136 12748672 19839648
14:17:21 3157 8192000000 10110127536 10477916160 1200596192 12.782 100 79 158 1 1232202448 12899264 18706992
14:18:26 2049 8192000000 10153754784 10524327936 1239185808 13.139 100 92 184 0 1272842672 13332784 20324080
14:19:31 1768 8192000000 10178847760 10558439424 1268490256 13.408 100 91 183 0 1302655152 14125440 20039456
14:20:34 693 8192000000 10194198288 10576367616 1281693936 13.528 100 85 171 1 1313462336 12849888 18918512
14:21:37 10312 8192000000 10206285120 10594959360 1294355792 13.644 100 70 139 1 1322257184 13052992 14848400
14:22:48 3166 8192000000 10200267312 10605424640 1304023552 13.732 100 37 74 2 1320733968 9145072 7565344
14:23:52 5209 8192000000 10192850784 10606718976 1309498080 13.782 100 34 67 0 1324702976 7749776 7455120
14:24:59 9615 8192000000 10206984896 10619871232 1318016688 13.859 100 23 46 0 1329861536 6817536 5027312
14:26:10 60575 8192000000 10209558432 10628505600 1321048384 13.886 100 17 33 0 1329763392 5102512 3612496
14:28:14 5752 8192000000 10224071280 10636554240 1315680832 13.838 99 34 68 1 1329980032 6867888 7431312
14:29:22 8238 8192000000 10198104432 10614980608 1299509120 13.691 98 18 36 0 1309234144 5494560 4230464
14:30:38 21930 8192000000 10215808912 10623778816 1310467040 13.790 99 50 99 0 1330520832 8159056 11894736
14:32:04 60866 8192000000 10208300368 10618814464 1295524704 13.655 97 45 90 0 1314868416 8869632 10474080
14:34:27 14116 8192000000 10225187152 10635063296 1298020384 13.677 96 33 64 0 1312604384 7219088 7364912
14:35:48 13642 8192000000 10238685616 10648485888 1325790448 13.929 99 46 89 0 1346374752 9915120 10669184
14:37:07 16871 8192000000 10254942304 10668265472 1344726672 14.100 100 56 112 0 1374416736 16525328 13164736
14:38:28 18836 8192000000 10230426512 10633183232 1307359664 13.762 99 48 96 0 1332616064 13938176 11318224
14:39:52 24501 8192000000 10222362096 10631299072 1319050816 13.868 100 43 86 0 1344638864 14717072 10870976
14:41:20 6821 8192000000 10234785680 10641575936 1315794288 13.839 99 40 81 0 1338424736 12673936 9956512
14:42:32 14907 8192000000 10255129456 10657513472 1331861584 13.984 100 66 128 2 1365174272 18453408 14859280
14:43:52 12331 8192000000 10264761936 10674814976 1350283104 14.150 100 54 108 0 1379157808 15595264 13279440
14:45:19 13647 8192000000 10282527824 10698342400 1359960256 14.237 100 44 86 0 1392343328 21550256 10832816
14:46:42 9763 8192000000 10245608000 10655506432 1322379632 13.898 99 41 81 0 1350674128 18524912 9769584
14:48:08 8202 8192000000 10297984912 10699001856 1360351216 14.241 100 77 149 1 1403275648 24733408 18191024
14:49:20 2989 8192000000 10309567952 10719334400 1374610528 14.368 100 56 109 2 1418449888 30243280 13596080
14:50:28 796 8192000000 10334750352 10746224640 1397498720 14.573 100 76 149 1 1446623088 29636096 19488272
14:51:32 13916 8192000000 10327426560 10749743104 1399050080 14.587 100 38 76 0 1437856208 28474096 10332032
14:53:09 7314 8192000000 10350055056 10765914112 1409874576 14.683 100 49 96 1 1456364928 33404800 13085552
14:54:21 5830 8192000000 10352965776 10775539712 1412528208 14.706 100 49 94 1 1458722560 33146496 13047856
14:55:41 27576 8192000000 10328313856 10770223104 1402447104 14.617 100 26 52 1 1444914336 35175216 7292016
14:58:00 36791 8192000000 10331907568 10781716480 1392428080 14.528 100 33 66 0 1447299552 45706960 9164512
14:59:40 40111 8192000000 10294793392 10768932864 1389026000 14.497 100 17 30 0 1421801440 28874064 3901376
15:01:34 32190 8192000000 10311094608 10758275072 1399645856 14.592 100 32 65 0 1424296016 16833680 7816480
15:03:12 56913 8192000000 10309259840 10757492736 1405609248 14.645 100 15 31 0 1421180944 12056192 3515504
15:05:10 57726 8192000000 10306754848 10766995456 1408895552 14.674 100 11 22 0 1424676752 13212432 2568768
15:07:52 40840 8192000000 10302435616 10753568768 1395670528 14.556 99 36 70 0 1410849968 7131184 8048256
15:09:39 72025 8192000000 10309379392 10764779520 1404217152 14.633 99 32 63 0 1418424592 7329488 6877952
15:12:02 37918 8192000000 10320642864 10776453120 1425168400 14.819 100 20 40 0 1440194000 10428160 4597440
15:13:50 54065 8192000000 10317783024 10780618752 1408799456 14.673 99 26 52 0 1432086560 17225440 6061664
15:15:45 68751 8192000000 10309362432 10787942400 1409917648 14.683 100 15 31 0 1429579200 16012784 3648768
15:18:15 59017 8192000000 10320446528 10780348416 1411932656 14.701 100 18 38 0 1429950560 13722192 4295712
15:20:34 77454 8192000000 10284414720 10721878016 1302794832 13.721 92 17 34 0 1316130416 9688544 3647040
15:22:53 87233 8192000000 10318787616 10754842624 1345530400 14.107 96 17 34 0 1359011824 10092160 3389264
15:25:22 40953 8192000000 10297137136 10741624832 1359174832 14.230 98 35 70 0 1380200576 13678256 7347488
15:27:03 38923 8192000000 10275036608 10723844096 1344647456 14.099 98 16 32 0 1359649408 11382784 3619168
15:28:51 17162 8192000000 10276786368 10704982016 1319106160 13.869 96 42 84 1 1338804720 10799104 8899456
15:30:09 26729 8192000000 10281202608 10714058752 1334963840 14.012 97 23 46 0 1351559712 11743056 4852816
15:31:37 97309 8192000000 10259616608 10704302080 1346863072 14.119 100 50 100 0 1377281248 19089104 11329072
15:34:23 24958 8192000000 10251408080 10688458752 1334931856 14.012 99 34 68 0 1350519792 7757280 7830656
15:35:49 33822 8192000000 10221320624 10661949440 1312808960 13.812 98 18 36 0 1326682224 9851232 4022032
15:37:23 32187 8192000000 10211726032 10655399936 1294854944 13.648 97 5 10 0 1304837120 9102864 879312
15:39:24 64862 8192000000 10231250656 10682257408 1285339888 13.562 96 12 24 0 1302662128 14886384 2435856
15:41:40 48618 8192000000 10244768672 10689028096 1299057408 13.687 96 18 36 1 1312348928 9204336 4087184
15:43:29 42486 8192000000 10256771952 10699313152 1346254912 14.114 99 22 43 1 1364713296 13583872 4874512
15:45:19 46777 8192000000 10274546752 10707943424 1357151792 14.212 99 16 32 0 1371394800 10497360 3745648
15:47:08 40350 8192000000 10286912896 10733699072 1376412384 14.384 100 22 44 0 1396125136 14375632 5337120
15:48:59 85639 8192000000 10296086800 10748153856 1386588416 14.475 100 11 22 0 1404173744 15193600 2391728
15:51:35 119571 8192000000 10306589936 10759499776 1397362080 14.572 100 10 20 0 1418409056 18691936 2355040
15:54:41 113585 8192000000 10288704736 10743664640 1364409952 14.277 98 42 80 2 1384397520 11371264 8616304
15:57:42 19109 8192000000 10291619248 10756239360 1391098976 14.516 100 17 34 0 1410114384 15314192 3701216
15:59:01 39309 8192000000 10275349504 10736754688 1380775984 14.423 100 12 24 0 1392665360 9174128 2715248
16:00:40 41148 8192000000 10287464832 10739126272 1378838064 14.406 99 10 20 0 1388774656 7647856 2288736
16:02:23 70584 8192000000 10299249088 10772459520 1404851648 14.638 100 23 46 1 1425513024 14910112 5751264
16:05:03 83869 8192000000 10273936368 10737455104 1293142464 13.633 92 14 28 0 1312511552 16155344 3213744
16:07:28 80941 8192000000 10298486304 10747858944 1348931376 14.138 97 15 30 0 1360460272 8167552 3361344

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:13, from 02-03-2024 16:11:03 to 02-03-2024 16:11:16.

Exceptions occured during test was in run

FB_MNEMONA CNT UNIT FB_GDSCODE
except 136 v_add_invoice_to_stock 335544517
except 12 v_cancel_supplier_invoice 335544517

Completed "Exceptions occured during test was in run". Done for 00:00:02, from 02-03-2024 16:11:17 to 02-03-2024 16:11:19.

Content of mon$database and FB version 


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


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

Database statistics 

 
Database "/home/bases/oltp30-etalone.fdb" 
Gstat execution time Sat Mar  2 16:11:20 2024 
 
Database header page information: 
    Flags            0 
    Generation        87468 
    System Change Number    0 
    Page size        8192 
    ODS version        12.0 
    Oldest transaction    166591 
    Oldest active        167915 
    Oldest snapshot        167915 
    Next transaction    167916 
    Sequence number        0 
    Next attachment ID    694 
    Implementation        HW=AMD/Intel/x64 little-endian OS=Linux CC=gcc 
    Shadow count        0 
    Page buffers        0 
    Next header page    0 
    Database dialect    3 
    Creation date        Apr 3, 2020 16:41:55 
    Attributes        force write 
 
    Variable header data: 
    Sweep interval:        0 
    Unrecognized option 11, length 16 
    *END* 
 
 
Database file sequence: 
File /home/bases/oltp30-etalone.fdb is the only file 
 
Analyzing database pages ... 
AGENTS (150) 
    Primary pointer page: 496, Index root page: 497 
    Total formats: 1, used formats: 1 
    Average record length: 33.60, total records: 50 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 344.00, compression ratio: 10.24 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 31% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 1 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index AGENTS_ID_DESC (2) 
    Root page: 1504311, depth: 1, leaf buckets: 1, nodes: 50 
    Average node length: 11.82, total dup: 0, max dup: 0 
    Average key length: 10.80, compression ratio: 0.83 
    Average prefix length: 1.18, average data length: 7.82 
    Clustering factor: 1, ratio: 0.02 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index AGENTS_IS_OUR_FIRM (4) 
    Root page: 1504313, depth: 1, leaf buckets: 1, nodes: 50 
    Average node length: 3.08, total dup: 48, max dup: 48 
    Average key length: 2.04, compression ratio: 0.50 
    Average prefix length: 0.96, average data length: 0.06 
    Clustering factor: 1, ratio: 0.02 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index AGENTS_IS_SUPPLIER (3) 
    Root page: 1504312, depth: 1, leaf buckets: 1, nodes: 50 
    Average node length: 3.08, total dup: 48, max dup: 44 
    Average key length: 2.04, compression ratio: 0.54 
    Average prefix length: 1.04, average data length: 0.06 
    Clustering factor: 1, ratio: 0.02 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index AGENTS_NAME_UNQ (1) 
    Root page: 1504310, depth: 1, leaf buckets: 1, nodes: 50 
    Average node length: 17.20, total dup: 0, max dup: 0 
    Average key length: 15.88, compression ratio: 0.92 
    Average prefix length: 1.42, average data length: 13.20 
    Clustering factor: 1, ratio: 0.02 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PK_AGENTS (0) 
    Root page: 1504309, depth: 1, leaf buckets: 1, nodes: 50 
    Average node length: 11.82, total dup: 0, max dup: 0 
    Average key length: 10.80, compression ratio: 0.83 
    Average prefix length: 1.18, average data length: 7.82 
    Clustering factor: 1, ratio: 0.02 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
BUSINESS_OPS (154) 
    Primary pointer page: 504, Index root page: 505 
    Total formats: 1, used formats: 1 
    Average record length: 108.20, total records: 20 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1235.00, compression ratio: 11.41 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 31% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 1 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index BO_UNIT_UNQ (1) 
    Root page: 1504242, depth: 1, leaf buckets: 1, nodes: 20 
    Average node length: 18.25, total dup: 0, max dup: 0 
    Average key length: 17.20, compression ratio: 1.24 
    Average prefix length: 7.05, average data length: 14.25 
    Clustering factor: 1, ratio: 0.05 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index BUSINESS_OPS_PREDICT_PRIOR (3) 
    Root page: 1504244, depth: 1, leaf buckets: 1, nodes: 20 
    Average node length: 5.40, total dup: 0, max dup: 0 
    Average key length: 4.35, compression ratio: 0.67 
    Average prefix length: 1.20, average data length: 1.70 
    Clustering factor: 1, ratio: 0.05 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index BUSINESS_OPS_RND_WGTH (2) 
    Root page: 1504243, depth: 1, leaf buckets: 1, nodes: 20 
    Average node length: 4.30, total dup: 6, max dup: 3 
    Average key length: 3.25, compression ratio: 0.72 
    Average prefix length: 1.35, average data length: 1.00 
    Clustering factor: 1, ratio: 0.05 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index RDB$1 (0) 
    Root page: 1504241, depth: 1, leaf buckets: 1, nodes: 20 
    Average node length: 5.20, total dup: 0, max dup: 0 
    Average key length: 4.15, compression ratio: 0.65 
    Average prefix length: 1.10, average data length: 1.60 
    Clustering factor: 1, ratio: 0.05 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
DOC_DATA (139) 
    Primary pointer page: 474, Index root page: 475 
    Total formats: 1, used formats: 1 
    Average record length: 47.12, total records: 7756099 
    Average version length: 48.16, total versions: 125263, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 64.00, compression ratio: 1.36 
    Pointer pages: 53, data page slots: 86128 
    Data pages: 86128, average fill: 72% 
    Primary pages: 86128, secondary pages: 0, swept pages: 15137 
    Empty pages: 3, full pages: 66902 
    Fill distribution: 
     0 - 19% = 7 
    20 - 39% = 33 
    40 - 59% = 756 
    60 - 79% = 85282 
    80 - 99% = 50 
 
    Index DOC_DATA_DOC_WARE_UNQ (0) 
    Root page: 1510614, depth: 3, leaf buckets: 23077, nodes: 7756099 
    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: 1740492, ratio: 0.22 
    Fill distribution: 
         0 - 19% = 317 
        20 - 39% = 1458 
        40 - 59% = 4251 
        60 - 79% = 2269 
        80 - 99% = 14782 
 
    Index DOC_DATA_ID_DESC (1) 
    Root page: 1528118, depth: 3, leaf buckets: 13396, nodes: 7756099 
    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: 1563231, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 1386 
        40 - 59% = 2057 
        60 - 79% = 1033 
        80 - 99% = 8919 
 
    Index FK_DOC_DATA_DOC_LIST (2) 
    Root page: 1546711, depth: 3, leaf buckets: 8265, nodes: 7756099 
    Average node length: 6.62, total dup: 5795269, max dup: 49 
    Average key length: 3.63, compression ratio: 2.48 
    Average prefix length: 7.62, average data length: 1.38 
    Clustering factor: 1556187, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 129 
        20 - 39% = 804 
        40 - 59% = 1438 
        60 - 79% = 866 
        80 - 99% = 5028 
 
DOC_LIST (138) 
    Primary pointer page: 472, Index root page: 473 
    Total formats: 1, used formats: 1 
    Average record length: 55.80, total records: 2249992 
    Average version length: 34.49, total versions: 127668, max versions: 4 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 84.00, compression ratio: 1.51 
    Pointer pages: 18, data page slots: 28104 
    Data pages: 28104, average fill: 74% 
    Primary pages: 28098, secondary pages: 6, swept pages: 8708 
    Empty pages: 3, full pages: 21463 
    Fill distribution: 
     0 - 19% = 11 
    20 - 39% = 50 
    40 - 59% = 939 
    60 - 79% = 25710 
    80 - 99% = 1394 
 
    Index DOC_LIST_ID_DESC (1) 
    Root page: 1541130, depth: 3, leaf buckets: 4497, nodes: 2249992 
    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: 703894, ratio: 0.31 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 833 
        40 - 59% = 826 
        60 - 79% = 729 
        80 - 99% = 2109 
 
    Index DOC_LIST_WORKER_OPTYPE (2) 
    Root page: 1544376, depth: 3, leaf buckets: 2497, nodes: 2252581 
    Average node length: 4.97, total dup: 2251682, max dup: 20046 
    Average key length: 2.01, compression ratio: 4.47 
    Average prefix length: 8.99, average data length: 0.01 
    Clustering factor: 1249528, ratio: 0.55 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 244 
        40 - 59% = 1507 
        60 - 79% = 545 
        80 - 99% = 199 
 
    Index FK_DOC_LIST_AGENTS (3) 
    Root page: 1545909, depth: 3, leaf buckets: 2009, nodes: 2249992 
    Average node length: 4.97, total dup: 2249942, max dup: 130036 
    Average key length: 2.01, compression ratio: 4.48 
    Average prefix length: 8.99, average data length: 0.01 
    Clustering factor: 1054368, ratio: 0.47 
    Fill distribution: 
         0 - 19% = 4 
        20 - 39% = 26 
        40 - 59% = 1094 
        60 - 79% = 55 
        80 - 99% = 830 
 
    Index PK_DOC_LIST (0) 
    Root page: 1538187, depth: 3, leaf buckets: 4309, nodes: 2249992 
    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: 703894, ratio: 0.31 
    Fill distribution: 
         0 - 19% = 102 
        20 - 39% = 532 
        40 - 59% = 607 
        60 - 79% = 795 
        80 - 99% = 2273 
 
DOC_STATES (149) 
    Primary pointer page: 494, Index root page: 495 
    Total formats: 1, used formats: 1 
    Average record length: 67.50, total records: 4 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 650.00, compression ratio: 9.63 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 4% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index DOC_STATES_MCODE_UNQ (1) 
    Root page: 1504315, depth: 1, leaf buckets: 1, nodes: 4 
    Average node length: 17.75, total dup: 0, max dup: 0 
    Average key length: 16.50, compression ratio: 1.08 
    Average prefix length: 4.00, average data length: 13.75 
    Clustering factor: 1, ratio: 0.25 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index DOC_STATES_NAME_UNQ (2) 
    Root page: 1504316, depth: 1, leaf buckets: 1, nodes: 4 
    Average node length: 33.25, total dup: 0, max dup: 0 
    Average key length: 32.00, compression ratio: 0.99 
    Average prefix length: 2.50, average data length: 29.25 
    Clustering factor: 1, ratio: 0.25 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PK_DOC_STATES (0) 
    Root page: 1504314, depth: 1, leaf buckets: 1, nodes: 4 
    Average node length: 4.75, total dup: 0, max dup: 0 
    Average key length: 3.50, compression ratio: 0.86 
    Average prefix length: 1.50, average data length: 1.50 
    Clustering factor: 1, ratio: 0.25 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
FB_ERRORS (155) 
    Primary pointer page: 506, Index root page: 507 
    Total formats: 2, used formats: 2 
    Average record length: 54.76, total records: 2182 
    Average version length: 79.61, total versions: 757, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 270.43, compression ratio: 4.94 
    Pointer pages: 1, data page slots: 40 
    Data pages: 40, average fill: 70% 
    Primary pages: 40, secondary pages: 0, swept pages: 0 
    Empty pages: 7, full pages: 32 
    Fill distribution: 
     0 - 19% = 7 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 7 
    80 - 99% = 26 
 
    Index FB_ERRORS_GDS_CODE (0) 
    Root page: 382, depth: 2, leaf buckets: 2, nodes: 2182 
    Average node length: 4.40, total dup: 756, max dup: 1 
    Average key length: 2.67, compression ratio: 1.87 
    Average prefix length: 4.33, average data length: 0.67 
    Clustering factor: 1515, ratio: 0.69 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 0 
        40 - 59% = 1 
        60 - 79% = 1 
        80 - 99% = 0 
 
INVNT_SALDO (145) 
    Primary pointer page: 486, Index root page: 487 
    Total formats: 2, used formats: 1 
    Average record length: 82.60, total records: 400 
    Average version length: 22.74, total versions: 235124, max versions: 611 
    Average fragment length: 2.00, total fragments: 40, max fragments: 1 
    Average unpacked length: 104.00, compression ratio: 1.26 
    Pointer pages: 1, data page slots: 1288 
    Data pages: 1288, average fill: 90% 
    Primary pages: 10, secondary pages: 1278, swept pages: 0 
    Empty pages: 3, full pages: 1284 
    Fill distribution: 
     0 - 19% = 4 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 1284 
 
    Index PK_INVNT_SALDO (0) 
    Root page: 1510349, depth: 1, leaf buckets: 1, nodes: 400 
    Average node length: 11.22, total dup: 0, max dup: 0 
    Average key length: 10.22, compression ratio: 0.88 
    Average prefix length: 1.78, average data length: 7.22 
    Clustering factor: 326, ratio: 0.81 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 0 
        40 - 59% = 1 
        60 - 79% = 0 
        80 - 99% = 0 
 
INVNT_TURNOVER_LOG (153) 
    Primary pointer page: 502, Index root page: 503 
    Total formats: 1, used formats: 1 
    Average record length: 12.38, total records: 119597 
    Average version length: 68.30, total versions: 97923, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 88.00, compression ratio: 7.11 
    Pointer pages: 6, data page slots: 3440 
    Data pages: 2640, average fill: 56% 
    Primary pages: 2639, secondary pages: 1, swept pages: 0 
    Empty pages: 508, full pages: 1412 
    Fill distribution: 
     0 - 19% = 758 
    20 - 39% = 198 
    40 - 59% = 162 
    60 - 79% = 288 
    80 - 99% = 1234 
 
    Index INVNT_TURNOVER_LOG_WARE_DD_ID (0) 
    Root page: 1707120, depth: 3, leaf buckets: 394, nodes: 119597 
    Average node length: 13.22, total dup: 9586, max dup: 2 
    Average key length: 10.61, compression ratio: 2.55 
    Average prefix length: 19.31, average data length: 7.69 
    Clustering factor: 87331, ratio: 0.73 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 42 
        40 - 59% = 299 
        60 - 79% = 48 
        80 - 99% = 4 
 
MONEY_SALDO (141) 
    Primary pointer page: 478, Index root page: 479 
    Total formats: 1, used formats: 1 
    Average record length: 15.27, total records: 49 
    Average version length: 9.00, total versions: 17685, max versions: 926 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 32.00, compression ratio: 2.10 
    Pointer pages: 1, data page slots: 64 
    Data pages: 64, average fill: 89% 
    Primary pages: 2, secondary pages: 62, swept pages: 0 
    Empty pages: 1, full pages: 62 
    Fill distribution: 
     0 - 19% = 2 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 2 
    80 - 99% = 60 
 
    Index PK_MONEY_SALDO (0) 
    Root page: 1510361, depth: 1, leaf buckets: 1, nodes: 49 
    Average node length: 11.82, total dup: 0, max dup: 0 
    Average key length: 10.80, compression ratio: 0.83 
    Average prefix length: 1.18, average data length: 7.82 
    Clustering factor: 1, ratio: 0.02 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
MONEY_TURNOVER_LOG (140) 
    Primary pointer page: 476, Index root page: 477 
    Total formats: 1, used formats: 1 
    Average record length: 7.73, total records: 1653 
    Average version length: 43.72, total versions: 1370, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 58.00, compression ratio: 7.50 
    Pointer pages: 1, data page slots: 32 
    Data pages: 28, average fill: 56% 
    Primary pages: 28, secondary pages: 0, swept pages: 2 
    Empty pages: 4, full pages: 16 
    Fill distribution: 
     0 - 19% = 8 
    20 - 39% = 3 
    40 - 59% = 1 
    60 - 79% = 3 
    80 - 99% = 13 
 
    Index MONEY_TURNOVER_LOG_AGENT_OPTYPE (0) 
    Root page: 88848, depth: 2, leaf buckets: 2, nodes: 1653 
    Average node length: 4.33, total dup: 1556, max dup: 221 
    Average key length: 2.63, compression ratio: 7.23 
    Average prefix length: 18.43, average data length: 0.57 
    Clustering factor: 805, ratio: 0.49 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 1 
        40 - 59% = 0 
        60 - 79% = 1 
        80 - 99% = 0 
 
MON_CACHE_MEMORY (165) 
    Primary pointer page: 526, Index root page: 527 
    Total formats: 2, used formats: 1 
    Average record length: 96.85, 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: 112.00, compression ratio: 1.16 
    Pointer pages: 1, data page slots: 2 
    Data pages: 2, average fill: 49% 
    Primary pages: 2, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 1 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 1 
 
    Index PK_MON_CACHE_MEMORY (0) 
    Root page: 1504215, depth: 1, leaf buckets: 1, nodes: 71 
    Average node length: 11.70, total dup: 0, max dup: 0 
    Average key length: 10.69, compression ratio: 0.84 
    Average prefix length: 1.30, average data length: 7.70 
    Clustering factor: 2, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
MON_LOG (162) 
    Primary pointer page: 520, Index root page: 521 
    Total formats: 2, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index MON_LOG_DTS (4) 
    Root page: 1504229, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index MON_LOG_GDSCODE (2) 
    Root page: 1504227, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index MON_LOG_ROWSET_DESC (1) 
    Root page: 1504226, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index MON_LOG_UNIT (3) 
    Root page: 1504228, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PK_MON_LOG (0) 
    Root page: 1504225, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
MON_LOG_TABLE_STATS (163) 
    Primary pointer page: 522, Index root page: 523 
    Total formats: 2, used formats: 1 
    Average record length: 67.13, total records: 30 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 611.00, compression ratio: 9.10 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 31% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 1 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index MON_LOG_TABLE_STATS_DTS (4) 
    Root page: 1504224, depth: 1, leaf buckets: 1, nodes: 30 
    Average node length: 3.50, total dup: 23, max dup: 4 
    Average key length: 2.47, compression ratio: 3.24 
    Average prefix length: 7.53, average data length: 0.47 
    Clustering factor: 1, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index MON_LOG_TABLE_STATS_GDSCODE (2) 
    Root page: 1504222, depth: 1, leaf buckets: 1, nodes: 30 
    Average node length: 2.00, total dup: 29, max dup: 29 
    Average key length: 1.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 1, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index MON_LOG_TABLE_STATS_ROWSET (1) 
    Root page: 1504221, depth: 1, leaf buckets: 1, nodes: 30 
    Average node length: 3.33, total dup: 29, max dup: 29 
    Average key length: 2.30, compression ratio: 3.91 
    Average prefix length: 8.70, average data length: 0.30 
    Clustering factor: 1, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index MON_LOG_TABLE_STATS_TN_UNIT (3) 
    Root page: 1504223, depth: 1, leaf buckets: 1, nodes: 30 
    Average node length: 12.90, total dup: 0, max dup: 0 
    Average key length: 11.87, compression ratio: 1.42 
    Average prefix length: 7.63, average data length: 9.20 
    Clustering factor: 1, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PK_MON_LOG_TABLE_STATS (0) 
    Root page: 1504220, depth: 1, leaf buckets: 1, nodes: 30 
    Average node length: 8.37, total dup: 0, max dup: 0 
    Average key length: 7.33, compression ratio: 1.23 
    Average prefix length: 4.63, average data length: 4.37 
    Clustering factor: 1, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
OPTYPES (136) 
    Primary pointer page: 468, Index root page: 469 
    Total formats: 2, used formats: 1 
    Average record length: 67.56, total records: 9 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 386.00, compression ratio: 5.71 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 9% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index OPTYPES_MCODE_UNQ (1) 
    Root page: 1544805, depth: 1, leaf buckets: 1, nodes: 9 
    Average node length: 8.56, total dup: 0, max dup: 0 
    Average key length: 6.89, compression ratio: 0.73 
    Average prefix length: 0.44, average data length: 4.56 
    Clustering factor: 1, ratio: 0.11 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PK_OPTYPES (0) 
    Root page: 1544804, depth: 1, leaf buckets: 1, nodes: 9 
    Average node length: 6.11, total dup: 0, max dup: 0 
    Average key length: 5.00, compression ratio: 0.60 
    Average prefix length: 0.89, average data length: 2.11 
    Clustering factor: 1, ratio: 0.11 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
PDISTR (146) 
    Primary pointer page: 488, Index root page: 489 
    Total formats: 1, used formats: 1 
    Average record length: 36.18, total records: 813891 
    Average version length: 25.26, total versions: 66697, max versions: 4 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 54.00, compression ratio: 1.49 
    Pointer pages: 5, data page slots: 7984 
    Data pages: 7984, average fill: 71% 
    Primary pages: 7967, secondary pages: 17, swept pages: 1294 
    Empty pages: 39, full pages: 7713 
    Fill distribution: 
     0 - 19% = 63 
    20 - 39% = 63 
    40 - 59% = 57 
    60 - 79% = 7505 
    80 - 99% = 296 
 
    Index PDISTR_AGENT_ID (2) 
    Root page: 1509308, depth: 2, leaf buckets: 896, nodes: 813891 
    Average node length: 4.87, total dup: 813842, max dup: 154082 
    Average key length: 2.01, compression ratio: 4.48 
    Average prefix length: 8.99, average data length: 0.01 
    Clustering factor: 89750, ratio: 0.11 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 112 
        40 - 59% = 522 
        60 - 79% = 192 
        80 - 99% = 69 
 
    Index PDISTR_SNDOP_RCVOP_SNDID_ASC (0) 
    Root page: 1508613, depth: 3, leaf buckets: 961, nodes: 813891 
    Average node length: 5.88, total dup: 724660, max dup: 42 
    Average key length: 3.02, compression ratio: 7.29 
    Average prefix length: 21.09, average data length: 0.91 
    Clustering factor: 163406, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 94 
        40 - 59% = 476 
        60 - 79% = 103 
        80 - 99% = 287 
 
    Index PDISTR_SNDOP_RCVOP_SNDID_DESC (1) 
    Root page: 1509187, depth: 3, leaf buckets: 994, nodes: 813891 
    Average node length: 5.88, total dup: 724660, max dup: 42 
    Average key length: 3.02, compression ratio: 7.29 
    Average prefix length: 21.09, average data length: 0.91 
    Clustering factor: 165323, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 190 
        40 - 59% = 419 
        60 - 79% = 88 
        80 - 99% = 296 
 
    Index PDISTR_WORKER_SND_ID (3) 
    Root page: 1510178, depth: 3, leaf buckets: 1140, nodes: 813891 
    Average node length: 5.96, total dup: 724660, max dup: 42 
    Average key length: 3.10, compression ratio: 5.48 
    Average prefix length: 16.01, average data length: 0.99 
    Clustering factor: 158057, ratio: 0.19 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 227 
        40 - 59% = 607 
        60 - 79% = 205 
        80 - 99% = 99 
 
PERF_AGG (158) 
    Primary pointer page: 512, Index root page: 513 
    Total formats: 1, used formats: 1 
    Average record length: 62.83, total records: 5479 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 2.90, total fragments: 81, max fragments: 1 
    Average unpacked length: 379.00, compression ratio: 6.03 
    Pointer pages: 1, data page slots: 88 
    Data pages: 88, average fill: 62% 
    Primary pages: 71, secondary pages: 17, swept pages: 47 
    Empty pages: 4, full pages: 63 
    Fill distribution: 
     0 - 19% = 17 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 71 
    80 - 99% = 0 
 
    Index PERF_AGG_UNQ (1) 
    Root page: 1504238, depth: 2, leaf buckets: 6, nodes: 5479 
    Average node length: 5.52, total dup: 0, max dup: 0 
    Average key length: 3.58, compression ratio: 10.06 
    Average prefix length: 34.48, average data length: 1.54 
    Clustering factor: 5209, ratio: 0.95 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 0 
        40 - 59% = 4 
        60 - 79% = 0 
        80 - 99% = 2 
 
    Index PK_PERF_AGG (0) 
    Root page: 1504233, depth: 2, leaf buckets: 10, nodes: 5479 
    Average node length: 11.15, 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: 157, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 2 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 7 
 
PERF_ESTIMATED (280) 
    Primary pointer page: 1504218, Index root page: 1504219 
    Total formats: 1, used formats: 1 
    Average record length: 39.13, total records: 76801 
    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: 744 
    Data pages: 744, average fill: 71% 
    Primary pages: 744, secondary pages: 0, swept pages: 0 
    Empty pages: 2, full pages: 740 
    Fill distribution: 
     0 - 19% = 3 
    20 - 39% = 1 
    40 - 59% = 0 
    60 - 79% = 740 
    80 - 99% = 0 
 
    Index PK_PERF_ESTIMATED (0) 
    Root page: 35051, depth: 2, leaf buckets: 98, nodes: 76801 
    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: 3334, ratio: 0.04 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 1 
        40 - 59% = 1 
        60 - 79% = 0 
        80 - 99% = 96 
 
PERF_ISQL_STAT (156) 
    Primary pointer page: 508, Index root page: 509 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index PERF_ISQL_STAT_TRN (0) 
    Root page: 1504239, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
PERF_LOG (159) 
    Primary pointer page: 514, Index root page: 515 
    Total formats: 1, used formats: 1 
    Average record length: 111.12, total records: 72 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1691.00, compression ratio: 15.22 
    Pointer pages: 1, data page slots: 2 
    Data pages: 2, average fill: 57% 
    Primary pages: 2, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 1 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 1 
    40 - 59% = 0 
    60 - 79% = 1 
    80 - 99% = 0 
 
PERF_SPLIT_0 (281) 
    Primary pointer page: 573, Index root page: 574 
    Total formats: 1, used formats: 1 
    Average record length: 151.07, total records: 166247 
    Average version length: 136.66, total versions: 109, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.23 
    Pointer pages: 6, data page slots: 5064 
    Data pages: 3976, average fill: 86% 
    Primary pages: 3976, secondary pages: 0, swept pages: 3 
    Empty pages: 27, full pages: 3940 
    Fill distribution: 
     0 - 19% = 30 
    20 - 39% = 4 
    40 - 59% = 1 
    60 - 79% = 1 
    80 - 99% = 3940 
 
PERF_SPLIT_1 (282) 
    Primary pointer page: 576, Index root page: 577 
    Total formats: 1, used formats: 1 
    Average record length: 150.40, total records: 172203 
    Average version length: 151.18, total versions: 845, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.28 
    Pointer pages: 8, data page slots: 5256 
    Data pages: 4120, average fill: 86% 
    Primary pages: 4120, secondary pages: 0, swept pages: 1 
    Empty pages: 31, full pages: 4078 
    Fill distribution: 
     0 - 19% = 32 
    20 - 39% = 6 
    40 - 59% = 1 
    60 - 79% = 3 
    80 - 99% = 4078 
 
PERF_SPLIT_2 (283) 
    Primary pointer page: 578, Index root page: 579 
    Total formats: 1, used formats: 1 
    Average record length: 127.43, total records: 202284 
    Average version length: 154.96, total versions: 31554, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 13.31 
    Pointer pages: 7, data page slots: 5920 
    Data pages: 4912, average fill: 86% 
    Primary pages: 4912, secondary pages: 0, swept pages: 4 
    Empty pages: 88, full pages: 4796 
    Fill distribution: 
     0 - 19% = 90 
    20 - 39% = 7 
    40 - 59% = 5 
    60 - 79% = 15 
    80 - 99% = 4795 
 
PERF_SPLIT_3 (284) 
    Primary pointer page: 580, Index root page: 581 
    Total formats: 1, used formats: 1 
    Average record length: 136.73, total records: 192822 
    Average version length: 155.46, total versions: 18247, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 12.40 
    Pointer pages: 5, data page slots: 5248 
    Data pages: 4656, average fill: 86% 
    Primary pages: 4656, secondary pages: 0, swept pages: 2 
    Empty pages: 47, full pages: 4558 
    Fill distribution: 
     0 - 19% = 53 
    20 - 39% = 11 
    40 - 59% = 28 
    60 - 79% = 6 
    80 - 99% = 4558 
 
PERF_SPLIT_4 (285) 
    Primary pointer page: 582, Index root page: 583 
    Total formats: 1, used formats: 1 
    Average record length: 146.43, total records: 155120 
    Average version length: 153.69, total versions: 4790, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.58 
    Pointer pages: 7, data page slots: 5904 
    Data pages: 3840, average fill: 83% 
    Primary pages: 3840, secondary pages: 0, swept pages: 3 
    Empty pages: 142, full pages: 3659 
    Fill distribution: 
     0 - 19% = 143 
    20 - 39% = 15 
    40 - 59% = 12 
    60 - 79% = 12 
    80 - 99% = 3658 
 
PERF_SPLIT_5 (286) 
    Primary pointer page: 584, Index root page: 585 
    Total formats: 1, used formats: 1 
    Average record length: 148.65, total records: 173244 
    Average version length: 153.65, total versions: 2733, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.41 
    Pointer pages: 6, data page slots: 4984 
    Data pages: 4176, average fill: 86% 
    Primary pages: 4176, secondary pages: 0, swept pages: 4 
    Empty pages: 60, full pages: 4094 
    Fill distribution: 
     0 - 19% = 61 
    20 - 39% = 5 
    40 - 59% = 6 
    60 - 79% = 9 
    80 - 99% = 4095 
 
PERF_SPLIT_6 (287) 
    Primary pointer page: 586, Index root page: 587 
    Total formats: 1, used formats: 1 
    Average record length: 149.16, total records: 161415 
    Average version length: 153.33, total versions: 1971, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.37 
    Pointer pages: 7, data page slots: 4672 
    Data pages: 3928, average fill: 85% 
    Primary pages: 3928, secondary pages: 0, swept pages: 2 
    Empty pages: 83, full pages: 3809 
    Fill distribution: 
     0 - 19% = 84 
    20 - 39% = 14 
    40 - 59% = 17 
    60 - 79% = 4 
    80 - 99% = 3809 
 
PERF_SPLIT_7 (288) 
    Primary pointer page: 588, Index root page: 589 
    Total formats: 1, used formats: 1 
    Average record length: 150.07, total records: 178482 
    Average version length: 153.35, total versions: 1333, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.30 
    Pointer pages: 7, data page slots: 5560 
    Data pages: 4344, average fill: 85% 
    Primary pages: 4344, secondary pages: 0, swept pages: 3 
    Empty pages: 99, full pages: 4225 
    Fill distribution: 
     0 - 19% = 103 
    20 - 39% = 8 
    40 - 59% = 6 
    60 - 79% = 2 
    80 - 99% = 4225 
 
PERF_SPLIT_8 (289) 
    Primary pointer page: 590, Index root page: 591 
    Total formats: 1, used formats: 1 
    Average record length: 150.56, total records: 168159 
    Average version length: 151.98, total versions: 649, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.26 
    Pointer pages: 6, data page slots: 4888 
    Data pages: 4040, average fill: 86% 
    Primary pages: 4040, secondary pages: 0, swept pages: 3 
    Empty pages: 47, full pages: 3981 
    Fill distribution: 
     0 - 19% = 52 
    20 - 39% = 3 
    40 - 59% = 2 
    60 - 79% = 2 
    80 - 99% = 3981 
 
PERF_SPLIT_9 (290) 
    Primary pointer page: 593, Index root page: 594 
    Total formats: 1, used formats: 1 
    Average record length: 150.95, total records: 167111 
    Average version length: 138.05, total versions: 187, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.24 
    Pointer pages: 6, data page slots: 4480 
    Data pages: 4008, average fill: 86% 
    Primary pages: 4007, secondary pages: 1, swept pages: 4 
    Empty pages: 37, full pages: 3958 
    Fill distribution: 
     0 - 19% = 43 
    20 - 39% = 5 
    40 - 59% = 1 
    60 - 79% = 1 
    80 - 99% = 3958 
 
PHRASES (143) 
    Primary pointer page: 482, Index root page: 483 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index PHRASES_ID_DESC (3) 
    Root page: 1510354, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PHRASES_NAME (2) 
    Root page: 1510353, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PHRASES_UNQ (1) 
    Root page: 1510352, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PK_PHRASES (0) 
    Root page: 1510351, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
PSTORNED (147) 
    Primary pointer page: 490, Index root page: 491 
    Total formats: 1, used formats: 1 
    Average record length: 51.39, total records: 2104666 
    Average version length: 52.99, total versions: 53963, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 70.00, compression ratio: 1.36 
    Pointer pages: 16, data page slots: 25312 
    Data pages: 25312, average fill: 72% 
    Primary pages: 25312, secondary pages: 0, swept pages: 10139 
    Empty pages: 219, full pages: 21015 
    Fill distribution: 
     0 - 19% = 425 
    20 - 39% = 380 
    40 - 59% = 885 
    60 - 79% = 23123 
    80 - 99% = 499 
 
    Index PSTORNED_RCV_ID (1) 
    Root page: 1506186, depth: 3, leaf buckets: 2579, nodes: 2104666 
    Average node length: 5.44, total dup: 1964385, max dup: 1510 
    Average key length: 2.49, compression ratio: 3.62 
    Average prefix length: 8.58, average data length: 0.42 
    Clustering factor: 181926, ratio: 0.09 
    Fill distribution: 
         0 - 19% = 5 
        20 - 39% = 281 
        40 - 59% = 1702 
        60 - 79% = 307 
        80 - 99% = 284 
 
    Index PSTORNED_SND_ID (0) 
    Root page: 1504819, depth: 3, leaf buckets: 2754, nodes: 2104666 
    Average node length: 5.69, total dup: 1889308, max dup: 64 
    Average key length: 2.74, compression ratio: 3.29 
    Average prefix length: 8.36, average data length: 0.64 
    Clustering factor: 375795, ratio: 0.18 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 4 
        40 - 59% = 2431 
        60 - 79% = 295 
        80 - 99% = 24 
 
    Index PSTORNED_WORKER_ID (2) 
    Root page: 1507996, depth: 3, leaf buckets: 2140, nodes: 2104666 
    Average node length: 4.96, total dup: 2104566, max dup: 27743 
    Average key length: 2.00, compression ratio: 1.20 
    Average prefix length: 2.41, average data length: 0.00 
    Clustering factor: 179631, ratio: 0.09 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 192 
        40 - 59% = 1149 
        60 - 79% = 377 
        80 - 99% = 420 
 
RULES_FOR_PDISTR (148) 
    Primary pointer page: 492, Index root page: 493 
    Total formats: 1, used formats: 1 
    Average record length: 17.00, total records: 4 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 334.00, compression ratio: 19.65 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 2% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index RULES_FOR_PDISTR_UNQ (0) 
    Root page: 1504317, depth: 1, leaf buckets: 1, nodes: 4 
    Average node length: 11.50, total dup: 0, max dup: 0 
    Average key length: 10.25, compression ratio: 0.88 
    Average prefix length: 1.50, average data length: 7.50 
    Clustering factor: 1, ratio: 0.25 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
RULES_FOR_QDISTR (137) 
    Primary pointer page: 470, Index root page: 471 
    Total formats: 1, used formats: 1 
    Average record length: 32.71, total records: 7 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 332.00, compression ratio: 10.15 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 4% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index RULES_FOR_QDISTR_RCVOP (1) 
    Root page: 1544803, depth: 1, leaf buckets: 1, nodes: 7 
    Average node length: 5.29, total dup: 2, max dup: 2 
    Average key length: 4.14, compression ratio: 0.72 
    Average prefix length: 1.43, average data length: 1.57 
    Clustering factor: 1, ratio: 0.14 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index RULES_FOR_QDISTR_UNQ (0) 
    Root page: 1544802, depth: 1, leaf buckets: 1, nodes: 7 
    Average node length: 10.14, total dup: 0, max dup: 0 
    Average key length: 8.86, compression ratio: 0.94 
    Average prefix length: 2.14, average data length: 6.14 
    Clustering factor: 1, ratio: 0.14 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
SEMAPHORES (152) 
    Primary pointer page: 500, Index root page: 501 
    Total formats: 1, used formats: 1 
    Average record length: 43.40, total records: 5 
    Average version length: 9.00, total versions: 1, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 346.00, compression ratio: 7.97 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 4% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index PK_SEMAPHORES (0) 
    Root page: 1504305, depth: 1, leaf buckets: 1, nodes: 5 
    Average node length: 12.40, total dup: 0, max dup: 0 
    Average key length: 11.00, compression ratio: 0.82 
    Average prefix length: 0.60, average data length: 8.40 
    Clustering factor: 1, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index SEMAPHORES_TASK_UNQ (1) 
    Root page: 1504306, depth: 1, leaf buckets: 1, nodes: 5 
    Average node length: 23.40, total dup: 0, max dup: 0 
    Average key length: 22.00, compression ratio: 1.07 
    Average prefix length: 4.20, average data length: 19.40 
    Clustering factor: 1, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
SETTINGS (135) 
    Primary pointer page: 466, Index root page: 467 
    Total formats: 1, used formats: 1 
    Average record length: 97.63, total records: 149 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1347.00, compression ratio: 13.80 
    Pointer pages: 1, data page slots: 3 
    Data pages: 3, average fill: 70% 
    Primary pages: 3, secondary pages: 0, swept pages: 2 
    Empty pages: 0, full pages: 2 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 1 
    60 - 79% = 0 
    80 - 99% = 2 
 
    Index SETTINGS_MCODE_WM_UNQ (1) 
    Root page: 525, depth: 1, leaf buckets: 1, nodes: 149 
    Average node length: 14.66, total dup: 0, max dup: 0 
    Average key length: 13.55, compression ratio: 2.19 
    Average prefix length: 19.07, average data length: 10.66 
    Clustering factor: 48, ratio: 0.32 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 1 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index SETTINGS_MODE_CODE (0) 
    Root page: 1544806, depth: 1, leaf buckets: 1, nodes: 149 
    Average node length: 25.56, total dup: 0, max dup: 0 
    Average key length: 24.56, compression ratio: 1.63 
    Average prefix length: 18.58, average data length: 21.56 
    Clustering factor: 14, ratio: 0.09 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 0 
        40 - 59% = 1 
        60 - 79% = 0 
        80 - 99% = 0 
 
TMP$DEP_DOCS (129) 
    Primary pointer page: 454, Index root page: 455 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index TMP_DEP_DOCS_UNQ (0) 
    Root page: 1544810, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
TMP$IDX_RECALC (132) 
    Primary pointer page: 460, Index root page: 461 
    Total formats: 2, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index TMP_IDX_RECALC_IDX_NAME_UNQ (0) 
    Root page: 1544807, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
TMP$MON_LOG (133) 
    Primary pointer page: 462, Index root page: 463 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
TMP$MON_LOG_TABLE_STATS (134) 
    Primary pointer page: 464, Index root page: 465 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
TMP$PERF_EST_WHOLE (161) 
    Primary pointer page: 518, Index root page: 519 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
TMP$PERF_LOG (160) 
    Primary pointer page: 516, Index root page: 517 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index TMP$PERF_LOG_UNIT_TRN_DTS_END (0) 
    Root page: 1504230, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
TMP$PERF_MON (131) 
    Primary pointer page: 458, Index root page: 459 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
TMP$RESULT_SET (130) 
    Primary pointer page: 456, Index root page: 457 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index TMP_RESULT_SET_DOC (1) 
    Root page: 1544809, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index TMP_RESULT_SET_WARE_DOC (0) 
    Root page: 1544808, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
TMP$SHOPPING_CART (128) 
    Primary pointer page: 452, Index root page: 453 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index TMP_SHOPCART_UNQ (0) 
    Root page: 1544811, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
TPAUSE (166) 
    Primary pointer page: 528, Index root page: 529 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index RDB$PRIMARY2 (0) 
    Root page: 1504214, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
TRACE_STAT (157) 
    Primary pointer page: 510, Index root page: 511 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
WARES (142) 
    Primary pointer page: 480, Index root page: 481 
    Total formats: 1, used formats: 1 
    Average record length: 77.52, total records: 400 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 444.00, compression ratio: 5.73 
    Pointer pages: 1, data page slots: 6 
    Data pages: 6, average fill: 77% 
    Primary pages: 6, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 5 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 5 
    80 - 99% = 1 
 
    Index FK_WARES_WARE_GROUPS (3) 
    Root page: 1552159, depth: 1, leaf buckets: 1, nodes: 400 
    Average node length: 3.17, total dup: 392, max dup: 60 
    Average key length: 2.16, compression ratio: 4.16 
    Average prefix length: 8.86, average data length: 0.14 
    Clustering factor: 48, ratio: 0.12 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PK_WARES (0) 
    Root page: 1510355, depth: 1, leaf buckets: 1, nodes: 400 
    Average node length: 11.22, total dup: 0, max dup: 0 
    Average key length: 10.22, compression ratio: 0.88 
    Average prefix length: 1.78, average data length: 7.22 
    Clustering factor: 344, ratio: 0.86 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 0 
        40 - 59% = 1 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index WARES_ID_DESC (2) 
    Root page: 1510360, depth: 1, leaf buckets: 1, nodes: 400 
    Average node length: 11.22, total dup: 0, max dup: 0 
    Average key length: 10.22, compression ratio: 0.88 
    Average prefix length: 1.78, average data length: 7.22 
    Clustering factor: 344, ratio: 0.86 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 0 
        40 - 59% = 1 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index WARES_NUMB_UNQ (1) 
    Root page: 1510358, depth: 2, leaf buckets: 3, nodes: 400 
    Average node length: 53.25, total dup: 0, max dup: 0 
    Average key length: 52.23, compression ratio: 1.00 
    Average prefix length: 2.74, average data length: 49.25 
    Clustering factor: 355, ratio: 0.89 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 1 
        80 - 99% = 2 
 
WARE_GROUPS (151) 
    Primary pointer page: 498, Index root page: 499 
    Total formats: 1, used formats: 1 
    Average record length: 32.12, total records: 8 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 346.00, compression ratio: 10.77 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 5% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index PK_WARE_GROUPS (0) 
    Root page: 1504307, depth: 1, leaf buckets: 1, nodes: 8 
    Average node length: 11.25, total dup: 0, max dup: 0 
    Average key length: 10.12, compression ratio: 0.89 
    Average prefix length: 1.75, average data length: 7.25 
    Clustering factor: 1, ratio: 0.12 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index WARE_GROUPS_NAME_UNQ (1) 
    Root page: 1504308, depth: 1, leaf buckets: 1, nodes: 8 
    Average node length: 19.88, total dup: 0, max dup: 0 
    Average key length: 18.12, compression ratio: 0.89 
    Average prefix length: 0.25, average data length: 15.88 
    Clustering factor: 1, ratio: 0.12 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
XQD_1000_1200 (176) 
    Primary pointer page: 549, Index root page: 550 
    Total formats: 1, used formats: 1 
    Average record length: 38.93, total records: 147312 
    Average version length: 69.16, total versions: 64461, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 3.24 
    Pointer pages: 3, data page slots: 3648 
    Data pages: 3112, average fill: 55% 
    Primary pages: 3112, secondary pages: 0, swept pages: 484 
    Empty pages: 644, full pages: 1836 
    Fill distribution: 
     0 - 19% = 866 
    20 - 39% = 193 
    40 - 59% = 163 
    60 - 79% = 581 
    80 - 99% = 1309 
 
    Index XQD_1000_1200_WA_SO_RO_WKR_SND (0) 
    Root page: 102777, depth: 3, leaf buckets: 221, nodes: 147312 
    Average node length: 6.43, total dup: 128011, max dup: 14 
    Average key length: 3.95, compression ratio: 10.62 
    Average prefix length: 40.18, average data length: 1.82 
    Clustering factor: 25251, ratio: 0.17 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 39 
        40 - 59% = 108 
        60 - 79% = 58 
        80 - 99% = 15 
 
XQD_1000_3300 (178) 
    Primary pointer page: 553, Index root page: 554 
    Total formats: 1, used formats: 1 
    Average record length: 65.33, total records: 7208790 
    Average version length: 68.75, total versions: 380050, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.93 
    Pointer pages: 62, data page slots: 100384 
    Data pages: 100384, average fill: 77% 
    Primary pages: 100384, secondary pages: 0, swept pages: 21919 
    Empty pages: 9, full pages: 93052 
    Fill distribution: 
     0 - 19% = 43 
    20 - 39% = 275 
    40 - 59% = 2145 
    60 - 79% = 89704 
    80 - 99% = 8217 
 
    Index XQD_1000_3300_WA_SO_RO_WKR_SND (0) 
    Root page: 1480454, depth: 3, leaf buckets: 10661, nodes: 7208790 
    Average node length: 6.51, total dup: 6237310, max dup: 29 
    Average key length: 3.52, compression ratio: 11.94 
    Average prefix length: 40.62, average data length: 1.38 
    Clustering factor: 1620818, ratio: 0.22 
    Fill distribution: 
         0 - 19% = 4 
        20 - 39% = 1421 
        40 - 59% = 5766 
        60 - 79% = 2856 
        80 - 99% = 614 
 
    Index XQD_1000_3300_WKR_DOC_ASC (1) 
    Root page: 1486068, depth: 3, leaf buckets: 8502, nodes: 7208790 
    Average node length: 5.39, total dup: 6927236, max dup: 186 
    Average key length: 2.40, compression ratio: 7.09 
    Average prefix length: 16.64, average data length: 0.36 
    Clustering factor: 1413821, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 11 
        20 - 39% = 1037 
        40 - 59% = 4562 
        60 - 79% = 1776 
        80 - 99% = 1116 
 
    Index XQD_1000_3300_WKR_DOC_DEC (2) 
    Root page: 1490608, depth: 3, leaf buckets: 8577, nodes: 7208790 
    Average node length: 5.39, total dup: 6927236, max dup: 186 
    Average key length: 2.40, compression ratio: 7.09 
    Average prefix length: 16.64, average data length: 0.36 
    Clustering factor: 1416383, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 7 
        20 - 39% = 1070 
        40 - 59% = 4656 
        60 - 79% = 1758 
        80 - 99% = 1086 
 
XQD_1200_2000 (177) 
    Primary pointer page: 551, Index root page: 552 
    Total formats: 1, used formats: 1 
    Average record length: 67.21, total records: 12051091 
    Average version length: 68.75, total versions: 304770, 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: 102, data page slots: 165504 
    Data pages: 165504, average fill: 77% 
    Primary pages: 165504, secondary pages: 0, swept pages: 69665 
    Empty pages: 6, full pages: 163120 
    Fill distribution: 
     0 - 19% = 12 
    20 - 39% = 111 
    40 - 59% = 755 
    60 - 79% = 157799 
    80 - 99% = 6827 
 
    Index XQD_1200_2000_WA_SO_RO_WKR_SND (0) 
    Root page: 1495028, depth: 3, leaf buckets: 18324, nodes: 12051091 
    Average node length: 6.57, total dup: 10505433, max dup: 60 
    Average key length: 3.43, compression ratio: 12.26 
    Average prefix length: 40.70, average data length: 1.30 
    Clustering factor: 2375783, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 34 
        20 - 39% = 2245 
        40 - 59% = 10851 
        60 - 79% = 4372 
        80 - 99% = 822 
 
XQD_2000_3300 (179) 
    Primary pointer page: 555, Index root page: 556 
    Total formats: 1, used formats: 1 
    Average record length: 40.11, total records: 1774799 
    Average version length: 69.11, total versions: 745306, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 3.14 
    Pointer pages: 25, data page slots: 39736 
    Data pages: 29616, average fill: 69% 
    Primary pages: 29615, secondary pages: 1, swept pages: 6274 
    Empty pages: 2070, full pages: 21389 
    Fill distribution: 
     0 - 19% = 3487 
    20 - 39% = 1789 
    40 - 59% = 1605 
    60 - 79% = 10321 
    80 - 99% = 12414 
 
    Index XQD_2000_3300_WA_SO_RO_WKR_SND (0) 
    Root page: 1479712, depth: 3, leaf buckets: 2270, nodes: 1774799 
    Average node length: 5.51, total dup: 1703054, max dup: 99 
    Average key length: 2.55, compression ratio: 16.46 
    Average prefix length: 41.49, average data length: 0.51 
    Clustering factor: 121043, ratio: 0.07 
    Fill distribution: 
         0 - 19% = 10 
        20 - 39% = 447 
        40 - 59% = 1071 
        60 - 79% = 568 
        80 - 99% = 174 
 
XQD_2100_3300 (180) 
    Primary pointer page: 557, Index root page: 558 
    Total formats: 1, used formats: 1 
    Average record length: 38.40, total records: 1296721 
    Average version length: 69.13, total versions: 575162, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 3.28 
    Pointer pages: 20, data page slots: 32480 
    Data pages: 26104, average fill: 57% 
    Primary pages: 26104, secondary pages: 0, swept pages: 5207 
    Empty pages: 5253, full pages: 16145 
    Fill distribution: 
     0 - 19% = 7143 
    20 - 39% = 711 
    40 - 59% = 760 
    60 - 79% = 6379 
    80 - 99% = 11111 
 
    Index XQD_2100_3300_WA_SO_RO_WKR_SND (0) 
    Root page: 1479207, depth: 3, leaf buckets: 1659, nodes: 1296721 
    Average node length: 5.80, total dup: 1209768, max dup: 113 
    Average key length: 2.86, compression ratio: 14.71 
    Average prefix length: 41.21, average data length: 0.79 
    Clustering factor: 179525, ratio: 0.14 
    Fill distribution: 
         0 - 19% = 4 
        20 - 39% = 225 
        40 - 59% = 794 
        60 - 79% = 467 
        80 - 99% = 169 
 
XQD_3300_3400 (181) 
    Primary pointer page: 559, Index root page: 560 
    Total formats: 1, used formats: 1 
    Average record length: 64.28, total records: 9218694 
    Average version length: 68.95, total versions: 616829, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.96 
    Pointer pages: 86, data page slots: 139040 
    Data pages: 139032, average fill: 71% 
    Primary pages: 139032, secondary pages: 0, swept pages: 42921 
    Empty pages: 241, full pages: 82348 
    Fill distribution: 
     0 - 19% = 614 
    20 - 39% = 2602 
    40 - 59% = 17201 
    60 - 79% = 107822 
    80 - 99% = 10793 
 
    Index XQD_3300_3400_WA_SO_RO_WKR_SND (0) 
    Root page: 1472590, depth: 3, leaf buckets: 13478, nodes: 9218694 
    Average node length: 6.66, total dup: 7648688, max dup: 29 
    Average key length: 3.67, compression ratio: 11.46 
    Average prefix length: 40.50, average data length: 1.50 
    Clustering factor: 1991514, ratio: 0.22 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 1206 
        40 - 59% = 7021 
        60 - 79% = 4614 
        80 - 99% = 636 
 
XQS_1000_1200 (182) 
    Primary pointer page: 561, Index root page: 562 
    Total formats: 1, used formats: 1 
    Average record length: 82.48, total records: 21107401 
    Average version length: 82.97, total versions: 15541, 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: 195, data page slots: 318160 
    Data pages: 318160, average fill: 81% 
    Primary pages: 318160, secondary pages: 0, swept pages: 12519 
    Empty pages: 36, full pages: 317306 
    Fill distribution: 
     0 - 19% = 57 
    20 - 39% = 44 
    40 - 59% = 121 
    60 - 79% = 27551 
    80 - 99% = 290387 
 
    Index XQS_1000_1200_DOC_ID (1) 
    Root page: 1426716, depth: 3, leaf buckets: 19403, nodes: 21107401 
    Average node length: 5.72, total dup: 20627341, max dup: 138 
    Average key length: 2.16, compression ratio: 4.16 
    Average prefix length: 8.86, average data length: 0.14 
    Clustering factor: 3272366, ratio: 0.16 
    Fill distribution: 
         0 - 19% = 3 
        20 - 39% = 0 
        40 - 59% = 8251 
        60 - 79% = 554 
        80 - 99% = 10595 
 
    Index XQS_1000_1200_RCV_ID (3) 
    Root page: 1456980, depth: 3, leaf buckets: 17121, nodes: 21107401 
    Average node length: 6.31, total dup: 18548912, max dup: 49 
    Average key length: 2.75, compression ratio: 3.27 
    Average prefix length: 8.37, average data length: 0.63 
    Clustering factor: 911790, ratio: 0.04 
    Fill distribution: 
         0 - 19% = 4 
        20 - 39% = 2 
        40 - 59% = 763 
        60 - 79% = 272 
        80 - 99% = 16080 
 
    Index XQS_1000_1200_SND_ID (2) 
    Root page: 1441073, depth: 3, leaf buckets: 21154, nodes: 21107401 
    Average node length: 6.34, total dup: 18468624, max dup: 29 
    Average key length: 2.79, compression ratio: 3.23 
    Average prefix length: 8.34, average data length: 0.66 
    Clustering factor: 3566972, ratio: 0.17 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 2 
        40 - 59% = 8473 
        60 - 79% = 591 
        80 - 99% = 12087 
 
    Index XQS_1000_1200_WORKER_ID (0) 
    Root page: 1413348, depth: 3, leaf buckets: 16081, nodes: 21107401 
    Average node length: 5.56, total dup: 21107301, max dup: 229702 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.42, average data length: 0.00 
    Clustering factor: 940586, ratio: 0.04 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 11 
        40 - 59% = 2930 
        60 - 79% = 369 
        80 - 99% = 12769 
 
XQS_1000_3300 (184) 
    Primary pointer page: 565, Index root page: 566 
    Total formats: 1, used formats: 1 
    Average record length: 77.13, total records: 9675504 
    Average version length: 82.62, total versions: 619092, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.63 
    Pointer pages: 101, data page slots: 163688 
    Data pages: 163656, average fill: 73% 
    Primary pages: 163656, secondary pages: 0, swept pages: 59796 
    Empty pages: 405, full pages: 106206 
    Fill distribution: 
     0 - 19% = 1003 
    20 - 39% = 3573 
    40 - 59% = 17171 
    60 - 79% = 76073 
    80 - 99% = 65836 
 
    Index XQS_1000_3300_DOC_ID (1) 
    Root page: 1367502, depth: 3, leaf buckets: 11330, nodes: 9675504 
    Average node length: 5.34, total dup: 9367660, max dup: 203 
    Average key length: 2.23, compression ratio: 4.03 
    Average prefix length: 8.80, average data length: 0.20 
    Clustering factor: 2134002, ratio: 0.22 
    Fill distribution: 
         0 - 19% = 4 
        20 - 39% = 37 
        40 - 59% = 8411 
        60 - 79% = 2800 
        80 - 99% = 78 
 
    Index XQS_1000_3300_RCV_ID (3) 
    Root page: 1379261, depth: 3, leaf buckets: 13318, nodes: 9675504 
    Average node length: 6.21, total dup: 8022578, max dup: 14 
    Average key length: 3.10, compression ratio: 2.90 
    Average prefix length: 8.07, average data length: 0.93 
    Clustering factor: 1487919, ratio: 0.15 
    Fill distribution: 
         0 - 19% = 123 
        20 - 39% = 3723 
        40 - 59% = 4341 
        60 - 79% = 2658 
        80 - 99% = 2473 
 
    Index XQS_1000_3300_SND_ID (2) 
    Root page: 1373059, depth: 3, leaf buckets: 12650, nodes: 9675504 
    Average node length: 5.96, total dup: 8398834, max dup: 44 
    Average key length: 2.85, compression ratio: 3.16 
    Average prefix length: 8.28, average data length: 0.72 
    Clustering factor: 2328100, ratio: 0.24 
    Fill distribution: 
         0 - 19% = 4 
        20 - 39% = 51 
        40 - 59% = 9360 
        60 - 79% = 3135 
        80 - 99% = 100 
 
    Index XQS_1000_3300_WORKER_ID (0) 
    Root page: 1362767, depth: 3, leaf buckets: 10115, nodes: 9675504 
    Average node length: 5.11, total dup: 9675404, max dup: 154284 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.42, average data length: 0.00 
    Clustering factor: 1504202, ratio: 0.16 
    Fill distribution: 
         0 - 19% = 45 
        20 - 39% = 1260 
        40 - 59% = 5031 
        60 - 79% = 1755 
        80 - 99% = 2024 
 
XQS_1200_2000 (183) 
    Primary pointer page: 563, Index root page: 564 
    Total formats: 1, used formats: 1 
    Average record length: 78.77, total records: 11411461 
    Average version length: 82.56, total versions: 489429, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.60 
    Pointer pages: 116, data page slots: 189240 
    Data pages: 188056, average fill: 75% 
    Primary pages: 188056, secondary pages: 0, swept pages: 61590 
    Empty pages: 2023, full pages: 147403 
    Fill distribution: 
     0 - 19% = 3565 
    20 - 39% = 5614 
    40 - 59% = 14689 
    60 - 79% = 42383 
    80 - 99% = 121805 
 
    Index XQS_1200_2000_DOC_ID (1) 
    Root page: 1392101, depth: 3, leaf buckets: 13140, nodes: 11411461 
    Average node length: 5.30, total dup: 11301749, max dup: 636 
    Average key length: 2.08, compression ratio: 4.33 
    Average prefix length: 8.93, average data length: 0.07 
    Clustering factor: 2373465, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 86 
        40 - 59% = 9012 
        60 - 79% = 3861 
        80 - 99% = 180 
 
    Index XQS_1200_2000_RCV_ID (3) 
    Root page: 1406110, depth: 3, leaf buckets: 10457, nodes: 11411461 
    Average node length: 5.50, total dup: 10913484, max dup: 49 
    Average key length: 2.28, compression ratio: 3.95 
    Average prefix length: 8.77, average data length: 0.23 
    Clustering factor: 712728, ratio: 0.06 
    Fill distribution: 
         0 - 19% = 155 
        20 - 39% = 755 
        40 - 59% = 2553 
        60 - 79% = 1876 
        80 - 99% = 5118 
 
    Index XQS_1200_2000_SND_ID (2) 
    Root page: 1398638, depth: 3, leaf buckets: 15026, nodes: 11411461 
    Average node length: 6.02, total dup: 9962628, max dup: 71 
    Average key length: 2.80, compression ratio: 3.21 
    Average prefix length: 8.32, average data length: 0.68 
    Clustering factor: 2390039, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 3 
        20 - 39% = 113 
        40 - 59% = 10480 
        60 - 79% = 4191 
        80 - 99% = 239 
 
    Index XQS_1200_2000_WORKER_ID (0) 
    Root page: 1386211, depth: 3, leaf buckets: 10765, nodes: 11411461 
    Average node length: 5.22, total dup: 11411361, max dup: 192796 
    Average key length: 2.00, compression ratio: 1.20 
    Average prefix length: 2.41, average data length: 0.00 
    Clustering factor: 701059, ratio: 0.06 
    Fill distribution: 
         0 - 19% = 82 
        20 - 39% = 724 
        40 - 59% = 4834 
        60 - 79% = 1461 
        80 - 99% = 3664 
 
XQS_2000_3300 (185) 
    Primary pointer page: 567, Index root page: 568 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index XQS_2000_3300_DOC_ID (1) 
    Root page: 1361753, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index XQS_2000_3300_RCV_ID (3) 
    Root page: 1361755, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index XQS_2000_3300_SND_ID (2) 
    Root page: 1361754, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index XQS_2000_3300_WORKER_ID (0) 
    Root page: 1361752, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
XQS_2100_3300 (186) 
    Primary pointer page: 569, Index root page: 570 
    Total formats: 1, used formats: 1 
    Average record length: 77.51, total records: 9788253 
    Average version length: 82.91, total versions: 617273, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.63 
    Pointer pages: 102, data page slots: 166440 
    Data pages: 166376, average fill: 73% 
    Primary pages: 166376, secondary pages: 0, swept pages: 61264 
    Empty pages: 423, full pages: 105592 
    Fill distribution: 
     0 - 19% = 1012 
    20 - 39% = 3486 
    40 - 59% = 17565 
    60 - 79% = 79816 
    80 - 99% = 64497 
 
    Index XQS_2100_3300_DOC_ID (1) 
    Root page: 1344686, depth: 3, leaf buckets: 11815, nodes: 9788253 
    Average node length: 5.16, total dup: 9759062, max dup: 1642 
    Average key length: 2.03, compression ratio: 4.43 
    Average prefix length: 8.97, average data length: 0.03 
    Clustering factor: 1946200, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 33 
        20 - 39% = 1450 
        40 - 59% = 7939 
        60 - 79% = 1847 
        80 - 99% = 546 
 
    Index XQS_2100_3300_RCV_ID (3) 
    Root page: 1355717, depth: 3, leaf buckets: 13406, nodes: 9788253 
    Average node length: 6.23, total dup: 8115772, max dup: 14 
    Average key length: 3.10, compression ratio: 2.90 
    Average prefix length: 8.07, average data length: 0.93 
    Clustering factor: 1462152, ratio: 0.15 
    Fill distribution: 
         0 - 19% = 153 
        20 - 39% = 3665 
        40 - 59% = 4267 
        60 - 79% = 2696 
        80 - 99% = 2625 
 
    Index XQS_2100_3300_SND_ID (2) 
    Root page: 1350049, depth: 3, leaf buckets: 12417, nodes: 9788253 
    Average node length: 5.42, total dup: 9349135, max dup: 99 
    Average key length: 2.29, compression ratio: 3.93 
    Average prefix length: 8.76, average data length: 0.24 
    Clustering factor: 2080794, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 21 
        20 - 39% = 1415 
        40 - 59% = 8753 
        60 - 79% = 1640 
        80 - 99% = 588 
 
    Index XQS_2100_3300_WORKER_ID (0) 
    Root page: 985805, depth: 3, leaf buckets: 10219, nodes: 9788253 
    Average node length: 5.14, total dup: 9788153, max dup: 157203 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.42, average data length: 0.00 
    Clustering factor: 1534241, ratio: 0.16 
    Fill distribution: 
         0 - 19% = 38 
        20 - 39% = 1317 
        40 - 59% = 4996 
        60 - 79% = 1776 
        80 - 99% = 2092 
 
XQS_3300_3400 (187) 
    Primary pointer page: 571, Index root page: 572 
    Total formats: 1, used formats: 1 
    Average record length: 67.40, total records: 575546 
    Average version length: 68.72, total versions: 6431, 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: 5, data page slots: 7944 
    Data pages: 7944, average fill: 76% 
    Primary pages: 7944, secondary pages: 0, swept pages: 3866 
    Empty pages: 3, full pages: 6844 
    Fill distribution: 
     0 - 19% = 3 
    20 - 39% = 9 
    40 - 59% = 115 
    60 - 79% = 7725 
    80 - 99% = 92 
 
    Index XQS_3300_3400_DOC_ID (1) 
    Root page: 41178, depth: 3, leaf buckets: 724, nodes: 575546 
    Average node length: 5.95, total dup: 490168, max dup: 82 
    Average key length: 3.09, compression ratio: 2.91 
    Average prefix length: 8.06, average data length: 0.94 
    Clustering factor: 100232, ratio: 0.17 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 28 
        40 - 59% = 508 
        60 - 79% = 83 
        80 - 99% = 105 
 
    Index XQS_3300_3400_SND_ID (2) 
    Root page: 26997, depth: 3, leaf buckets: 749, nodes: 575546 
    Average node length: 6.15, total dup: 472160, max dup: 23 
    Average key length: 3.29, compression ratio: 2.73 
    Average prefix length: 7.89, average data length: 1.11 
    Clustering factor: 100283, ratio: 0.17 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 33 
        40 - 59% = 512 
        60 - 79% = 93 
        80 - 99% = 110 
 
    Index XQS_3300_3400_WORKER_ID (0) 
    Root page: 375548, depth: 2, leaf buckets: 568, nodes: 575546 
    Average node length: 4.86, total dup: 575446, max dup: 9568 
    Average key length: 2.00, compression ratio: 1.20 
    Average prefix length: 2.41, average data length: 0.00 
    Clustering factor: 88968, ratio: 0.15 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 36 
        40 - 59% = 329 
        60 - 79% = 79 
        80 - 99% = 124 
 
ZDOC_DATA (170) 
    Primary pointer page: 537, Index root page: 538 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
ZDOC_LIST (169) 
    Primary pointer page: 535, Index root page: 536 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
ZINVNT_TURNOVER_LOG (171) 
    Primary pointer page: 539, Index root page: 540 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
ZPDISTR (174) 
    Primary pointer page: 545, Index root page: 546 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index ZPDISTR_ID (0) 
    Root page: 1504207, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
ZPSTORNED (175) 
    Primary pointer page: 547, Index root page: 548 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index ZPSTORNED_ID (0) 
    Root page: 1504206, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
ZQDISTR (172) 
    Primary pointer page: 541, Index root page: 542 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index ZQDISTR_ID (0) 
    Root page: 1504212, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index ZQDISTR_WARE_SNDOP_RCVOP (1) 
    Root page: 1504213, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
ZQSTORNED (173) 
    Primary pointer page: 543, Index root page: 544 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index ZQSTORNED_DOC_ID (1) 
    Root page: 1504209, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index ZQSTORNED_ID (0) 
    Root page: 1504208, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index ZQSTORNED_RCV_ID (3) 
    Root page: 1504211, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index ZQSTORNED_SND_ID (2) 
    Root page: 1504210, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
ZTMP_DEP_DOCS (168) 
    Primary pointer page: 533, Index root page: 534 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
ZTMP_SHOPPING_CART (167) 
    Primary pointer page: 531, Index root page: 532 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
Z_USED_VIEWS (144) 
    Primary pointer page: 484, Index root page: 485 
    Total formats: 1, used formats: 1 
    Average record length: 29.38, total records: 29 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 99.00, compression ratio: 3.37 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 16% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index Z_USED_VIEWS_UNQ (0) 
    Root page: 1510350, depth: 1, leaf buckets: 1, nodes: 29 
    Average node length: 15.17, total dup: 0, max dup: 0 
    Average key length: 14.14, compression ratio: 1.44 
    Average prefix length: 9.17, average data length: 11.17 
    Clustering factor: 1, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
Gstat completion time Sat Mar  2 16:11:44 2024

Record versions statistics, table

TABLE_NAME TOTAL_RECS TOTAL_VERS MAX_VERSIONS VERS_TO_RECS_PRC MAXV_TO_VERS_PRC
DOC_DATA 7756099 125263 1 0.0000 0.0000
DOC_LIST 2249992 127668 4 0.0000 0.0000
FB_ERRORS 2182 757 1 0.0000 0.0000
INVNT_SALDO 400 235124 611 58700.0000 0.0000
INVNT_TURNOVER_LOG 119597 97923 1 0.0000 0.0000
MONEY_SALDO 49 17685 926 36000.0000 0.0000
MONEY_TURNOVER_LOG 1653 1370 1 0.0000 0.0000
PDISTR 813891 66697 4 0.0000 0.0000
PERF_SPLIT_0 166247 109 1 0.0000 0.0000
PERF_SPLIT_1 172203 845 1 0.0000 0.0000
PERF_SPLIT_2 202284 31554 1 0.0000 0.0000
PERF_SPLIT_3 192822 18247 1 0.0000 0.0000
PERF_SPLIT_4 155120 4790 1 0.0000 0.0000
PERF_SPLIT_5 173244 2733 1 0.0000 0.0000
PERF_SPLIT_6 161415 1971 1 0.0000 0.0000
PERF_SPLIT_7 178482 1333 1 0.0000 0.0000
PERF_SPLIT_8 168159 649 1 0.0000 0.0000
PERF_SPLIT_9 167111 187 1 0.0000 0.0000
PSTORNED 2104666 53963 1 0.0000 0.0000
SEMAPHORES 5 1 1 0.0000 100.0000
XQD_1000_1200 147312 64461 1 0.0000 0.0000
XQD_1000_3300 7208790 380050 1 0.0000 0.0000
XQD_1200_2000 12051091 304770 1 0.0000 0.0000
XQD_2000_3300 1774799 745306 1 0.0000 0.0000
XQD_2100_3300 1296721 575162 1 0.0000 0.0000
XQD_3300_3400 9218694 616829 1 0.0000 0.0000
XQS_1000_1200 21107401 15541 1 0.0000 0.0000
XQS_1000_3300 9675504 619092 1 0.0000 0.0000
XQS_1200_2000 11411461 489429 1 0.0000 0.0000
XQS_2100_3300 9788253 617273 1 0.0000 0.0000
XQS_3300_3400 575546 6431 1 0.0000 0.0000

Record versions statistics, chart

Total records and versions, chart

Ratios versions / total_records and max_versions / total_versions

Database validation 


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

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

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

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

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