Generated by /opt/oltp-emul/oltp_isql_run_worker.sh, ISQL session No. 1 of total launched 100. 01.03.2024 16:14
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 15685916 kB
MemAvailable 30284676 kB
Buffers 0 kB
Cached 16071260 kB
SwapCached 2276 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-01 16:13:10
DTS_END                         2024-03-01 16:13:10.1620
FB_GDSCODE                      -1
FB_MNEMONA                      
STACK                           SP_CANCEL_SUPPLIER_ORDER(116:18) ==> SP_CANCEL_CUSTOMER_RESERVE(36:5) ==> SP_CHECK_TO_STOP_WORK(32:12) ==> SP_HALT_ON_ERROR(57:17)
IP                              ::1/47092
TRN_ID                          176830
ATT_ID                          592
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: 9327.57 20493 932757
customer order: creation 179.97 332 17997
customer order: refuse 15.30 344 1530
order to supplier: creation 47.48 1309 4748
order to supplier: removal 3.58 111671 358
invoice (draft): creation 47.86 3313 4786
invoice (draft): removal 50.10 842 5010
invoice accept: apply 42.91 22148 4291
invoice accept: cancel 45.69 895 4569
customer reserve: creation 4084.91 214 408491
customer reserve: removal 4506.32 70 450632
realization accept: apply 86.87 208 8687
realization accept: cancel 83.02 133 8302
payment from customer: creation 61.69 127 6169
payment from customer: removal 6.14 89 614
payment to supplier: creation 49.10 142 4910
payment to supplier: removal 3.32 78 332
service: total inventory turnovers 5.44 1053 544
service: total monetary turnovers 7.00 72 700
service: aggregate perf. data 0.84 23451 84
service: refresh index statistics 0.03 243360 3

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:02, from 01-03-2024 16:14:39 to 01-03-2024 16:14:41.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 10406
TEST_TIME 2 8023
TEST_TIME 3 7272
TEST_TIME 4 6885
TEST_TIME 5 7408
TEST_TIME 6 6520
TEST_TIME 7 7259
TEST_TIME 8 6826
TEST_TIME 9 6713
TEST_TIME 10 6643
TEST_TIME 11 6622
TEST_TIME 12 6627
TEST_TIME 13 6391
TEST_TIME 14 6601
TEST_TIME 15 6679
TEST_TIME 16 6802
TEST_TIME 17 6966
TEST_TIME 18 7109
TEST_TIME 19 7007
TEST_TIME 20 7010
TEST_TIME 21 7265
TEST_TIME 22 7183
TEST_TIME 23 7363
TEST_TIME 24 7477
TEST_TIME 25 7721
TEST_TIME 26 7741
TEST_TIME 27 8219
TEST_TIME 28 8260
TEST_TIME 29 8110
TEST_TIME 30 8796
TEST_TIME 31 9988
TEST_TIME 32 9878
TEST_TIME 33 9974
TEST_TIME 34 9828
TEST_TIME 35 9919
TEST_TIME 36 9925
TEST_TIME 37 9923
TEST_TIME 38 9748
TEST_TIME 39 9618
TEST_TIME 40 9587
TEST_TIME 41 9603
TEST_TIME 42 9560
TEST_TIME 43 9535
TEST_TIME 44 9502
TEST_TIME 45 9489
TEST_TIME 46 9527
TEST_TIME 47 9494
TEST_TIME 48 9483
TEST_TIME 49 9411
TEST_TIME 50 9429
TEST_TIME 51 9344
TEST_TIME 52 9192
TEST_TIME 53 9338
TEST_TIME 54 9256
TEST_TIME 55 9242
TEST_TIME 56 9216
TEST_TIME 57 9202
TEST_TIME 58 9122
TEST_TIME 59 9310
TEST_TIME 60 9352
TEST_TIME 61 9416
TEST_TIME 62 9489
TEST_TIME 63 9438
TEST_TIME 64 9462
TEST_TIME 65 9561
TEST_TIME 66 9644
TEST_TIME 67 9758
TEST_TIME 68 9729
TEST_TIME 69 9603
TEST_TIME 70 9523
TEST_TIME 71 9453
TEST_TIME 72 9416
TEST_TIME 73 9511
TEST_TIME 74 9440
TEST_TIME 75 9415
TEST_TIME 76 9417
TEST_TIME 77 9380
TEST_TIME 78 9390
TEST_TIME 79 9433
TEST_TIME 80 9453
TEST_TIME 81 9462
TEST_TIME 82 9432
TEST_TIME 83 9515
TEST_TIME 84 9518
TEST_TIME 85 9510
TEST_TIME 86 9610
TEST_TIME 87 9588
TEST_TIME 88 9594
TEST_TIME 89 9607
TEST_TIME 90 9505
TEST_TIME 91 9503
TEST_TIME 92 9514
TEST_TIME 93 9555
TEST_TIME 94 9494
TEST_TIME 95 9440
TEST_TIME 96 9406
TEST_TIME 97 9400
TEST_TIME 98 9384
TEST_TIME 99 9415
TEST_TIME 100 9334

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:03, from 01-03-2024 16:14:43 to 01-03-2024 16:14:46.

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 1307632 1307632 0 0.00 0 33941 7 0 0
doc_list_biud 1307628 1307628 0 0.00 0 62870 30 0 0
sp_add_invoice_to_stock 4374 4291 83 1.89 30 195979 22149 0 83
sp_cancel_adding_invoice 4569 4569 0 0.00 4 62051 895 0 0
sp_cancel_client_order 1530 1530 0 0.00 4 5950 344 0 0
sp_cancel_customer_reserve 450632 450632 0 0.00 0 62872 71 0 0
sp_cancel_pay_from_customer 614 614 0 0.00 3 2786 90 0 0
sp_cancel_pay_to_supplier 332 332 0 0.00 3 5135 78 0 0
sp_cancel_supplier_invoice 5012 5010 2 0.03 1 26818 842 0 2
sp_cancel_supplier_order 358 358 0 0.00 7 993114 111672 0 0
sp_cancel_write_off 8302 8302 0 0.00 1 13085 133 0 0
sp_client_order 17997 17997 0 0.00 3 23364 332 0 0
sp_customer_reserve 408491 408491 0 0.00 0 105596 214 0 0
sp_fill_shopping_cart 27529 27529 0 0.00 1 8865 36 0 0
sp_fill_shopping_cart_clo_res 408488 408488 0 0.00 0 15722 15 0 0
sp_get_clo_for_invoice 4286 4286 0 0.00 0 32039 291 0 0
sp_kill_cost_storno 13817 13817 0 0.00 0 9389 69 0 0
sp_kill_qstorno_ret_qs2qd 914934 914934 0 0.00 0 62867 38 0 0
sp_kill_qty_storno 483372 483372 0 0.00 0 62869 81 0 0
sp_lock_selected_doc 17911 17911 0 0.00 0 9150 7 0 0
sp_make_cost_storno 24052 24052 0 0.00 0 33761 62 0 0
sp_multiply_rows_for_pdistr 24051 24051 0 0.00 0 7264 33 0 0
sp_multiply_rows_for_qdistr 17997 17997 0 0.00 0 14033 138 0 0
sp_pay_from_customer 6169 6169 0 0.00 4 27600 127 0 0
sp_pay_to_supplier 4910 4910 0 0.00 4 34015 143 0 0
sp_payment_common 11077 11077 0 0.00 1 27587 33 0 0
sp_qd_handle_on_cancel_clo 1530 1530 0 0.00 0 5423 312 0 0
sp_qd_handle_on_invoice_upd_sts 8853 8853 0 0.00 0 19086 354 0 0
sp_qd_handle_on_reserve_upd_sts 8687 8687 0 0.00 0 17558 68 0 0
sp_reserve_write_off 8687 8687 0 0.00 6 17628 209 0 0
sp_supplier_invoice 4786 4786 0 0.00 7 70498 3314 0 0
sp_supplier_order 4748 4748 0 0.00 5 36475 1309 0 0
srv_aggregate_perf_data 84 84 0 0.00 1508 571534 23452 0 0
srv_fill_mon_cache_memory 58 58 0 0.00 2722 113248 35972 0 0
srv_find_qd_qs_mism 889491 889491 0 0.00 0 13056 7 0 0
srv_make_invnt_saldo 544 544 0 0.00 43 67647 1054 0 0
srv_make_money_saldo 700 700 0 0.00 1 20381 73 0 0
srv_recalc_idx_stat 3 3 0 0.00 226583 262357 243360 0 0
t$perf-abend:sp_add_invoice_to_stock 83 83 0 0.00 0 0 0 0 0
t$perf-abend:sp_cancel_supplier_invoice 2 2 0 0.00 0 0 0 0 0
t$perf-norm:sp_add_invoice_to_stock 4292 4292 0 0.00 0 8601 200 0 0
t$perf-norm:sp_cancel_adding_invoice 366 366 0 0.00 0 15771 163 0 0
t$perf-norm:sp_cancel_client_order 1530 1530 0 0.00 0 4443 18 0 0
t$perf-norm:sp_cancel_customer_reserve 605 605 0 0.00 0 3991 23 0 0
t$perf-norm:sp_cancel_pay_from_customer 614 614 0 0.00 0 5760 12 0 0
t$perf-norm:sp_cancel_pay_to_supplier 332 332 0 0.00 0 115 2 0 0
t$perf-norm:sp_cancel_supplier_invoice 316 316 0 0.00 0 1767 29 0 0
t$perf-norm:sp_cancel_supplier_order 358 358 0 0.00 0 35798 1810 0 0
t$perf-norm:sp_cancel_write_off 821 821 0 0.00 0 2981 6 0 0
t$perf-norm:sp_client_order 17997 17997 0 0.00 0 7131 17 0 0
t$perf-norm:sp_customer_reserve 902 902 0 0.00 0 2925 13 0 0
t$perf-norm:sp_pay_from_customer 6169 6169 0 0.00 0 9244 8 0 0
t$perf-norm:sp_pay_to_supplier 4910 4910 0 0.00 0 3220 9 0 0
t$perf-norm:sp_reserve_write_off 8688 8688 0 0.00 0 5359 10 0 0
t$perf-norm:sp_supplier_invoice 4786 4786 0 0.00 0 4589 22 0 0
t$perf-norm:sp_supplier_order 4749 4749 0 0.00 0 7769 22 0 0
t$perf-norm:srv_aggregate_perf_data 84 84 0 0.00 0 718 17 0 0
t$perf-norm:srv_fill_mon_cache_memory 58 58 0 0.00 0 1259 23 0 0
t$perf-norm:srv_make_invnt_saldo 544 544 0 0.00 0 859 26 0 0
t$perf-norm:srv_make_money_saldo 700 700 0 0.00 0 578 16 0 0
t$perf-norm:srv_recalc_idx_stat 3 3 0 0.00 2 4 3 0 0
v_add_invoice_to_stock 8730 8564 166 1.90 0 8679 19 0 166
v_all_customers 33010 33010 0 0.00 0 22 1 0 0
v_all_suppliers 26696 26696 0 0.00 0 28 1 0 0
v_all_wares 35994 35994 0 0.00 0 17 1 0 0
v_cancel_adding_invoice 732 732 0 0.00 0 1191 8 0 0
v_cancel_client_order 3060 3060 0 0.00 0 4171 8 0 0
v_cancel_customer_prepayment 1228 1228 0 0.00 0 2778 8 0 0
v_cancel_customer_reserve 1210 1210 0 0.00 0 2966 6 0 0
v_cancel_payment_to_supplier 664 664 0 0.00 0 702 4 0 0
v_cancel_supplier_invoice 636 632 4 0.62 0 9475 26 0 4
v_cancel_supplier_order 716 716 0 0.00 0 1657 5 0 0
v_cancel_write_off 1642 1642 0 0.00 0 3688 16 0 0
v_max_id_clo_ord 4746 4746 0 0.00 0 1153 2 0 0
v_max_id_clo_res 902 902 0 0.00 0 1887 16 0 0
v_max_id_ord_sup 4786 4786 0 0.00 0 3789 4 0 0
v_max_non_paid_invoice 1094 1094 0 0.00 0 386 3 0 0
v_max_non_paid_realizn 3107 3107 0 0.00 0 1592 5 0 0
v_min_id_clo_ord 4746 4746 0 0.00 0 4120 11 0 0
v_min_id_clo_res 902 902 0 0.00 0 702 3 0 0
v_min_id_ord_sup 4786 4786 0 0.00 0 4278 6 0 0
v_min_non_paid_invoice 4910 4910 0 0.00 0 3915 17 0 0
v_min_non_paid_realizn 6167 6167 0 0.00 0 27584 29 0 0
v_our_firm 9104 9104 0 0.00 0 24 1 0 0
v_reserve_write_off 17374 17374 0 0.00 0 4445 6 0 0
x_lock_depdocs_on_canc_invoice 9263 9263 0 0.00 0 12801 153 0 0
x_lock_depdocs_on_canc_sup_ord 358 358 0 0.00 0 9543 366 0 0
x_make_qstorno_1000_1200 4748 4748 0 0.00 1 36462 1219 0 0
x_make_qstorno_1200_2000 4786 4786 0 0.00 2 70489 3189 0 0
x_make_qstorno_2100_3300 408491 408491 0 0.00 0 105593 196 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 01-03-2024 16:14:47 to 01-03-2024 16:14:51.

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:13:14 5 8192000000 8805232880 8818757632 10430304 0.127 4 2 3 0 10574048 68800 74944
14:14:14 36323 8192000000 9887113600 10197442560 964768640 10.536 100 83 166 0 993052896 6045584 22238672
14:15:59 17358 8192000000 9940722080 10261217280 1021110784 11.083 100 87 174 0 1052170032 8597360 22461888
14:17:26 19963 8192000000 9975738592 10307629056 1058011216 11.437 100 83 166 0 1088656848 9954784 20690848
14:18:50 10089 8192000000 10028958544 10373529600 1111840672 11.950 100 72 144 0 1139620256 10689232 17090352
14:20:05 7019 8192000000 10073488224 10430529536 1159339008 12.397 100 80 160 0 1190760288 13314640 18106640
14:21:15 4997 8192000000 10113568848 10480402432 1197937552 12.757 100 81 158 0 1228264624 12797184 17529888
14:22:22 1727 8192000000 10138179008 10516459520 1234703936 13.097 100 78 148 1 1263620880 12126816 16790128
14:23:25 1730 8192000000 10181806272 10563448832 1268191296 13.405 100 82 164 2 1299715936 13425712 18098928
14:24:29 3481 8192000000 10205784992 10590883840 1296223552 13.661 100 83 166 0 1326693520 12467456 18002512
14:25:33 21926 8192000000 10190811792 10598268928 1300074848 13.696 100 37 75 2 1314050672 5605248 8370576
14:26:57 5860 8192000000 10214163968 10618884096 1313277712 13.816 100 41 82 0 1330518096 8159216 9081168
14:28:06 3624 8192000000 10214740480 10623209472 1319441504 13.872 100 43 84 1 1336494032 6888352 10164176
14:29:11 67550 8192000000 10217022816 10637168640 1325554080 13.927 100 27 53 5 1341363360 9674048 6135232
14:31:19 5585 8192000000 10226110464 10646016000 1334557536 14.008 100 19 37 0 1344135664 6118880 3459248
14:32:25 5455 8192000000 10235261376 10651787264 1335678640 14.018 100 26 53 1 1347395040 5758896 5957504
14:33:41 11076 8192000000 10212943744 10614640640 1282833248 13.539 96 53 107 1 1302839600 6830832 13175520
14:34:54 20662 8192000000 10220784224 10619183104 1304649936 13.738 99 43 83 0 1319206944 5104368 9452640
14:36:23 10814 8192000000 10223286496 10628956160 1316194608 13.842 100 55 108 2 1337367264 9070928 12101728
14:37:39 5520 8192000000 10212016816 10616791040 1295487728 13.654 99 46 92 0 1316276912 10362448 10426736
14:38:51 5593 8192000000 10217960960 10614829056 1303822720 13.730 99 59 118 0 1328880704 12078192 12979792
14:40:31 16910 8192000000 10204841600 10613514240 1279201584 13.506 98 33 64 1 1303008336 16339392 7467360
14:41:54 13463 8192000000 10213698976 10610675712 1296383792 13.662 99 57 113 0 1325644416 16206000 13054624
14:43:13 7808 8192000000 10220930448 10615742464 1287333232 13.580 98 65 130 1 1321415456 19697664 14384560
14:44:25 10443 8192000000 10247351440 10651807744 1318732272 13.865 99 54 109 0 1349910176 18207776 12970128
14:45:43 11848 8192000000 10232316544 10634223616 1313210080 13.815 99 53 106 1 1342018208 16651936 12156192
14:47:04 21338 8192000000 10244894960 10654486528 1325362304 13.925 99 41 83 0 1355331280 20020864 9948112
14:48:27 5164 8192000000 10281342272 10687623168 1350197200 14.149 100 62 124 1 1388505520 23450112 14858208
14:49:35 3909 8192000000 10293711264 10702770176 1363734832 14.271 100 60 119 1 1401691408 23434976 14521600
14:50:46 4062 8192000000 10318474304 10726150144 1378417056 14.402 100 72 144 0 1422783328 27076288 17289984
14:51:58 2721 8192000000 10331148480 10740019200 1387380448 14.482 100 77 152 2 1433835440 28293616 18161376
14:53:06 3358 8192000000 10348379648 10759307264 1398675248 14.583 100 73 147 3 1452844528 35544704 18624576
14:54:16 4214 8192000000 10373241344 10787045376 1414271600 14.722 100 73 144 0 1475768800 43249936 18247264
14:55:27 8810 8192000000 10393853776 10807398400 1427974576 14.843 100 80 160 1 1496605024 48140816 20489632
14:56:42 4266 8192000000 10407184384 10822701056 1441025024 14.959 100 73 146 0 1505846992 45514320 19307648
14:57:51 5809 8192000000 10394804496 10826219520 1441004704 14.959 100 46 92 1 1502922928 48941024 12977200
14:58:58 19300 8192000000 10387846704 10819420160 1436420432 14.918 100 53 106 0 1498004976 47449424 14135120
15:01:00 4041 8192000000 10409817152 10839465984 1448739040 15.027 100 62 122 0 1507063904 43506688 14818176
15:02:18 18221 8192000000 10386639680 10822430720 1424591136 14.813 100 34 69 0 1487572560 53177472 9803952
15:04:06 20500 8192000000 10338784800 10818203648 1406035232 14.649 100 10 20 0 1457345504 48182480 3127792
15:05:28 19805 8192000000 10327343600 10774171648 1418399744 14.759 100 42 80 0 1433832288 6849184 8583360
15:06:51 89153 8192000000 10325482416 10786611200 1415539632 14.733 100 10 20 0 1429291152 11623664 2127856
15:09:21 113248 8192000000 10311960048 10768224256 1366798768 14.298 97 15 29 1 1380053744 10346208 2908768
15:12:15 78898 8192000000 10330501520 10782437376 1385099248 14.462 98 42 84 0 1407173488 12068768 10005472
15:14:34 35544 8192000000 10287480992 10743058432 1322336048 13.898 94 22 44 0 1338951904 11910704 4705152
15:17:18 33211 8192000000 10313315120 10766241792 1395431168 14.554 100 28 54 0 1414373280 12741968 6200144
15:18:57 44699 8192000000 10288559792 10747584512 1374643920 14.369 99 25 50 0 1393258960 12517232 6097808
15:21:06 37335 8192000000 10267795040 10722463744 1352338336 14.169 98 15 31 0 1365193760 9187616 3667808
15:22:44 13842 8192000000 10270824368 10722951168 1354836848 14.191 99 14 28 1 1371398432 13419888 3141696
15:24:02 85599 8192000000 10263483200 10721185792 1356029968 14.202 98 23 46 1 1372313104 10599376 5683760
15:26:31 28575 8192000000 10221265920 10683609088 1297479152 13.672 95 15 29 0 1313257104 12451376 3326576
15:28:00 66944 8192000000 10228954752 10681892864 1311813424 13.803 97 10 20 1 1322772720 8610672 2348624
15:30:07 39622 8192000000 10270836240 10715881472 1361534560 14.251 100 27 54 0 1378524304 10925616 6064128
15:31:47 58316 8192000000 10256457152 10710319104 1330005792 13.967 97 20 39 0 1348346528 13446368 4894368
15:33:55 11030 8192000000 10272180112 10707537920 1339454192 14.052 99 42 84 0 1362964032 14428528 9081312
15:35:55 33504 8192000000 10269338224 10702520320 1331256000 13.979 99 16 32 0 1344293456 9416496 3620960
15:37:34 64814 8192000000 10257966352 10696925184 1293605120 13.637 96 14 26 1 1316034320 19294992 3134208
15:39:45 77848 8192000000 10267348432 10735910912 1353583792 14.180 100 26 48 1 1377927504 18951120 5392592
15:42:12 73164 8192000000 10275510464 10717061120 1363169392 14.266 100 26 50 1 1376216336 7040960 6005984
15:44:26 8063 8192000000 10288158256 10732810240 1380229536 14.419 100 31 59 2 1393812400 7689392 5893472
15:45:35 56886 8192000000 10288795824 10751713280 1376968128 14.389 99 16 32 0 1393700992 13140496 3592368
15:47:33 27230 8192000000 10280967952 10743021568 1376014416 14.381 99 9 18 0 1392011728 13506480 2490832
15:49:01 54524 8192000000 10280954864 10750046208 1371309136 14.339 99 6 12 0 1381734160 9349008 1076016
15:50:56 36207 8192000000 10295294304 10749452288 1378674784 14.405 99 24 48 0 1397514592 13280000 5559808
15:52:45 112273 8192000000 10305146672 10773753856 1387508272 14.484 99 13 26 0 1399160368 9174336 2477760
15:55:38 60086 8192000000 10310170480 10779705344 1379452208 14.412 98 31 60 1 1400468768 14308592 6707968
15:57:42 42359 8192000000 10332646688 10773393408 1389955168 14.505 99 42 83 0 1410380608 10612848 9812592
15:59:26 87926 8192000000 10298621024 10747416576 1347827808 14.128 96 13 26 0 1358860560 8368864 2663888
16:01:57 35544 8192000000 10317501568 10763558912 1379363792 14.411 99 35 70 0 1406686480 19401456 7921232
16:03:34 86929 8192000000 10297463856 10757754880 1367982576 14.309 98 28 56 0 1388512384 13651648 6878160
16:06:09 51130 8192000000 10280941888 10750214144 1377942928 14.398 99 18 36 0 1389087936 7255328 3889680
16:08:08 84415 8192000000 10299882352 10763866112 1377177712 14.391 98 14 26 0 1391869568 11758480 2933376
16:10:36 37497 8192000000 10278282416 10743160832 1378950208 14.407 99 23 46 0 1397269312 12738016 5581088
16:12:13 60242 8192000000 9716805168 10092331008 835384336 9.253 60 9 18 0 845712880 8127424 2201120

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:14, from 01-03-2024 16:14:53 to 01-03-2024 16:15:07.

Exceptions occured during test was in run

FB_MNEMONA CNT UNIT FB_GDSCODE
except 83 v_add_invoice_to_stock 335544517
except 2 v_cancel_supplier_invoice 335544517

Completed "Exceptions occured during test was in run". Done for 00:00:02, from 01-03-2024 16:15:08 to 01-03-2024 16:15:10.

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          176718
MON$OLDEST_ACTIVE               177174
MON$OLDEST_SNAPSHOT             177174
MON$NEXT_TRANSACTION            177174
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                       1920032
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 Fri Mar  1 16:15:11 2024 
 
Database header page information: 
    Flags            0 
    Generation        92472 
    System Change Number    0 
    Page size        8192 
    ODS version        12.0 
    Oldest transaction    176718 
    Oldest active        177174 
    Oldest snapshot        177174 
    Next transaction    177175 
    Sequence number        0 
    Next attachment ID    710 
    Implementation        HW=AMD/Intel/x64 little-endian OS=Linux CC=gcc 
    Shadow count        0 
    Page buffers        0 
    Next header page    0 
    Database dialect    3 
    Creation date        Apr 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.52, total records: 7733671 
    Average version length: 48.17, total versions: 59754, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 64.00, compression ratio: 1.35 
    Pointer pages: 54, data page slots: 87512 
    Data pages: 87512, average fill: 71% 
    Primary pages: 87512, secondary pages: 0, swept pages: 30025 
    Empty pages: 1, full pages: 56892 
    Fill distribution: 
     0 - 19% = 25 
    20 - 39% = 351 
    40 - 59% = 4173 
    60 - 79% = 82944 
    80 - 99% = 19 
 
    Index DOC_DATA_DOC_WARE_UNQ (0) 
    Root page: 1510614, depth: 3, leaf buckets: 23316, nodes: 7733671 
    Average node length: 18.87, total dup: 0, max dup: 0 
    Average key length: 15.88, compression ratio: 1.70 
    Average prefix length: 14.12, average data length: 12.88 
    Clustering factor: 1690005, ratio: 0.22 
    Fill distribution: 
         0 - 19% = 299 
        20 - 39% = 1966 
        40 - 59% = 4027 
        60 - 79% = 2562 
        80 - 99% = 14462 
 
    Index DOC_DATA_ID_DESC (1) 
    Root page: 1528118, depth: 3, leaf buckets: 13566, nodes: 7733671 
    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: 1512816, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 1729 
        40 - 59% = 1935 
        60 - 79% = 1158 
        80 - 99% = 8743 
 
    Index FK_DOC_DATA_DOC_LIST (2) 
    Root page: 1546711, depth: 3, leaf buckets: 8368, nodes: 7733671 
    Average node length: 6.61, total dup: 5796038, max dup: 49 
    Average key length: 3.62, compression ratio: 2.49 
    Average prefix length: 7.63, average data length: 1.37 
    Clustering factor: 1505908, ratio: 0.19 
    Fill distribution: 
         0 - 19% = 116 
        20 - 39% = 1089 
        40 - 59% = 1300 
        60 - 79% = 994 
        80 - 99% = 4869 
 
DOC_LIST (138) 
    Primary pointer page: 472, Index root page: 473 
    Total formats: 1, used formats: 1 
    Average record length: 56.67, total records: 2228527 
    Average version length: 34.62, total versions: 59030, max versions: 3 
    Average fragment length: 4.00, total fragments: 1, max fragments: 1 
    Average unpacked length: 84.00, compression ratio: 1.48 
    Pointer pages: 18, data page slots: 28752 
    Data pages: 28752, average fill: 72% 
    Primary pages: 28746, secondary pages: 6, swept pages: 13080 
    Empty pages: 6, full pages: 18112 
    Fill distribution: 
     0 - 19% = 29 
    20 - 39% = 203 
    40 - 59% = 2827 
    60 - 79% = 25276 
    80 - 99% = 417 
 
    Index DOC_LIST_ID_DESC (1) 
    Root page: 1541130, depth: 3, leaf buckets: 4577, nodes: 2228527 
    Average node length: 11.41, total dup: 0, max dup: 0 
    Average key length: 8.45, compression ratio: 1.07 
    Average prefix length: 3.55, average data length: 5.45 
    Clustering factor: 679558, ratio: 0.30 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 1007 
        40 - 59% = 787 
        60 - 79% = 782 
        80 - 99% = 2001 
 
    Index DOC_LIST_WORKER_OPTYPE (2) 
    Root page: 1544376, depth: 3, leaf buckets: 2540, nodes: 2230484 
    Average node length: 4.97, total dup: 2229585, max dup: 17982 
    Average key length: 2.01, compression ratio: 4.47 
    Average prefix length: 8.99, average data length: 0.01 
    Clustering factor: 1243521, ratio: 0.56 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 298 
        40 - 59% = 1563 
        60 - 79% = 519 
        80 - 99% = 159 
 
    Index FK_DOC_LIST_AGENTS (3) 
    Root page: 1545909, depth: 3, leaf buckets: 2094, nodes: 2228527 
    Average node length: 4.97, total dup: 2228477, max dup: 130507 
    Average key length: 2.01, compression ratio: 4.48 
    Average prefix length: 8.99, average data length: 0.01 
    Clustering factor: 1061983, ratio: 0.48 
    Fill distribution: 
         0 - 19% = 6 
        20 - 39% = 246 
        40 - 59% = 998 
        60 - 79% = 44 
        80 - 99% = 800 
 
    Index PK_DOC_LIST (0) 
    Root page: 1538187, depth: 3, leaf buckets: 4374, nodes: 2228527 
    Average node length: 11.41, total dup: 0, max dup: 0 
    Average key length: 8.44, compression ratio: 1.07 
    Average prefix length: 3.55, average data length: 5.45 
    Clustering factor: 679558, ratio: 0.30 
    Fill distribution: 
         0 - 19% = 108 
        20 - 39% = 672 
        40 - 59% = 560 
        60 - 79% = 876 
        80 - 99% = 2158 
 
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.17, total records: 400 
    Average version length: 22.51, total versions: 257898, max versions: 672 
    Average fragment length: 2.00, total fragments: 63, max fragments: 1 
    Average unpacked length: 104.00, compression ratio: 1.27 
    Pointer pages: 1, data page slots: 1432 
    Data pages: 1424, average fill: 89% 
    Primary pages: 12, secondary pages: 1412, swept pages: 0 
    Empty pages: 5, full pages: 1418 
    Fill distribution: 
     0 - 19% = 5 
    20 - 39% = 1 
    40 - 59% = 0 
    60 - 79% = 1 
    80 - 99% = 1417 
 
    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: 10.86, total records: 134568 
    Average version length: 68.28, total versions: 113171, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 88.00, compression ratio: 8.10 
    Pointer pages: 7, data page slots: 3032 
    Data pages: 1932, average fill: 85% 
    Primary pages: 1931, secondary pages: 1, swept pages: 20 
    Empty pages: 26, full pages: 1768 
    Fill distribution: 
     0 - 19% = 42 
    20 - 39% = 36 
    40 - 59% = 52 
    60 - 79% = 183 
    80 - 99% = 1619 
 
    Index INVNT_TURNOVER_LOG_WARE_DD_ID (0) 
    Root page: 1714736, depth: 3, leaf buckets: 373, nodes: 134568 
    Average node length: 13.07, total dup: 9953, max dup: 2 
    Average key length: 10.56, compression ratio: 2.56 
    Average prefix length: 19.37, average data length: 7.63 
    Clustering factor: 98686, ratio: 0.73 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 3 
        40 - 59% = 245 
        60 - 79% = 97 
        80 - 99% = 28 
 
MONEY_SALDO (141) 
    Primary pointer page: 478, Index root page: 479 
    Total formats: 1, used formats: 1 
    Average record length: 15.24, total records: 49 
    Average version length: 9.00, total versions: 18160, max versions: 985 
    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: 91% 
    Primary pages: 1, secondary pages: 63, swept pages: 0 
    Empty pages: 0, full pages: 63 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 4 
    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: 3.78, total records: 2089 
    Average version length: 43.16, total versions: 1915, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 58.00, compression ratio: 15.35 
    Pointer pages: 1, data page slots: 32 
    Data pages: 31, average fill: 63% 
    Primary pages: 29, secondary pages: 2, swept pages: 1 
    Empty pages: 7, full pages: 21 
    Fill distribution: 
     0 - 19% = 9 
    20 - 39% = 1 
    40 - 59% = 0 
    60 - 79% = 1 
    80 - 99% = 20 
 
    Index MONEY_TURNOVER_LOG_AGENT_OPTYPE (0) 
    Root page: 92879, depth: 2, leaf buckets: 3, nodes: 2089 
    Average node length: 4.13, total dup: 1991, max dup: 245 
    Average key length: 2.50, compression ratio: 7.61 
    Average prefix length: 18.55, average data length: 0.45 
    Clustering factor: 1061, ratio: 0.51 
    Fill distribution: 
         0 - 19% = 1 
        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: 97.05, total records: 74 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 112.00, compression ratio: 1.15 
    Pointer pages: 1, data page slots: 2 
    Data pages: 2, average fill: 52% 
    Primary pages: 2, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 1 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 1 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 1 
 
    Index PK_MON_CACHE_MEMORY (0) 
    Root page: 1504215, depth: 1, leaf buckets: 1, nodes: 74 
    Average node length: 11.69, total dup: 0, max dup: 0 
    Average key length: 10.68, compression ratio: 0.84 
    Average prefix length: 1.31, average data length: 7.69 
    Clustering factor: 2, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
MON_LOG (162) 
    Primary pointer page: 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.25, total records: 809890 
    Average version length: 25.77, total versions: 61857, 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: 8152 
    Data pages: 8144, average fill: 69% 
    Primary pages: 8119, secondary pages: 25, swept pages: 2060 
    Empty pages: 64, full pages: 6808 
    Fill distribution: 
     0 - 19% = 122 
    20 - 39% = 107 
    40 - 59% = 320 
    60 - 79% = 7343 
    80 - 99% = 252 
 
    Index PDISTR_AGENT_ID (2) 
    Root page: 1509308, depth: 2, leaf buckets: 905, nodes: 809890 
    Average node length: 4.87, total dup: 809841, max dup: 154324 
    Average key length: 2.01, compression ratio: 4.48 
    Average prefix length: 8.99, average data length: 0.01 
    Clustering factor: 89493, ratio: 0.11 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 138 
        40 - 59% = 501 
        60 - 79% = 215 
        80 - 99% = 49 
 
    Index PDISTR_SNDOP_RCVOP_SNDID_ASC (0) 
    Root page: 1508613, depth: 3, leaf buckets: 956, nodes: 809890 
    Average node length: 5.88, total dup: 720813, max dup: 42 
    Average key length: 3.02, compression ratio: 7.28 
    Average prefix length: 21.09, average data length: 0.91 
    Clustering factor: 160979, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 91 
        40 - 59% = 472 
        60 - 79% = 116 
        80 - 99% = 277 
 
    Index PDISTR_SNDOP_RCVOP_SNDID_DESC (1) 
    Root page: 1509187, depth: 3, leaf buckets: 1026, nodes: 809890 
    Average node length: 5.88, total dup: 720813, max dup: 42 
    Average key length: 3.02, compression ratio: 7.28 
    Average prefix length: 21.09, average data length: 0.91 
    Clustering factor: 162913, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 198 
        40 - 59% = 481 
        60 - 79% = 88 
        80 - 99% = 259 
 
    Index PDISTR_WORKER_SND_ID (3) 
    Root page: 1510178, depth: 3, leaf buckets: 1152, nodes: 809890 
    Average node length: 5.96, total dup: 720813, max dup: 42 
    Average key length: 3.10, compression ratio: 5.48 
    Average prefix length: 16.01, average data length: 0.99 
    Clustering factor: 155521, ratio: 0.19 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 242 
        40 - 59% = 620 
        60 - 79% = 195 
        80 - 99% = 94 
 
PERF_AGG (158) 
    Primary pointer page: 512, Index root page: 513 
    Total formats: 1, used formats: 1 
    Average record length: 62.86, total records: 5403 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 2.93, total fragments: 56, max fragments: 1 
    Average unpacked length: 379.00, compression ratio: 6.03 
    Pointer pages: 1, data page slots: 96 
    Data pages: 96, average fill: 56% 
    Primary pages: 78, secondary pages: 18, swept pages: 56 
    Empty pages: 16, full pages: 66 
    Fill distribution: 
     0 - 19% = 27 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 69 
    80 - 99% = 0 
 
    Index PERF_AGG_UNQ (1) 
    Root page: 1504238, depth: 2, leaf buckets: 5, nodes: 5403 
    Average node length: 5.44, total dup: 0, max dup: 0 
    Average key length: 3.57, compression ratio: 10.03 
    Average prefix length: 34.30, average data length: 1.54 
    Clustering factor: 5049, ratio: 0.93 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 0 
        40 - 59% = 2 
        60 - 79% = 1 
        80 - 99% = 2 
 
    Index PK_PERF_AGG (0) 
    Root page: 1504233, depth: 2, leaf buckets: 10, nodes: 5403 
    Average node length: 11.08, 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: 155, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 1 
        40 - 59% = 2 
        60 - 79% = 0 
        80 - 99% = 6 
 
PERF_ESTIMATED (280) 
    Primary pointer page: 1504218, Index root page: 1504219 
    Total formats: 1, used formats: 1 
    Average record length: 39.18, total records: 81369 
    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: 792 
    Data pages: 792, average fill: 71% 
    Primary pages: 792, secondary pages: 0, swept pages: 0 
    Empty pages: 6, full pages: 784 
    Fill distribution: 
     0 - 19% = 7 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 785 
    80 - 99% = 0 
 
    Index PK_PERF_ESTIMATED (0) 
    Root page: 35434, depth: 2, leaf buckets: 104, nodes: 81369 
    Average node length: 10.17, total dup: 0, max dup: 0 
    Average key length: 8.18, compression ratio: 1.10 
    Average prefix length: 3.82, average data length: 5.18 
    Clustering factor: 3501, ratio: 0.04 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 1 
        60 - 79% = 0 
        80 - 99% = 102 
 
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.22, 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.20 
    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: 117.21, total records: 206505 
    Average version length: 154.72, total versions: 45937, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 14.47 
    Pointer pages: 7, data page slots: 5408 
    Data pages: 4952, average fill: 88% 
    Primary pages: 4951, secondary pages: 1, swept pages: 4 
    Empty pages: 34, full pages: 4907 
    Fill distribution: 
     0 - 19% = 39 
    20 - 39% = 3 
    40 - 59% = 1 
    60 - 79% = 3 
    80 - 99% = 4906 
 
PERF_SPLIT_1 (282) 
    Primary pointer page: 576, Index root page: 577 
    Total formats: 1, used formats: 1 
    Average record length: 145.08, total records: 166071 
    Average version length: 151.69, total versions: 6405, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.69 
    Pointer pages: 7, data page slots: 5088 
    Data pages: 4024, average fill: 85% 
    Primary pages: 4024, secondary pages: 0, swept pages: 1 
    Empty pages: 80, full pages: 3922 
    Fill distribution: 
     0 - 19% = 84 
    20 - 39% = 5 
    40 - 59% = 9 
    60 - 79% = 4 
    80 - 99% = 3922 
 
PERF_SPLIT_2 (283) 
    Primary pointer page: 578, Index root page: 579 
    Total formats: 1, used formats: 1 
    Average record length: 148.55, total records: 154403 
    Average version length: 148.21, total versions: 2460, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.42 
    Pointer pages: 6, data page slots: 3992 
    Data pages: 3720, average fill: 85% 
    Primary pages: 3719, secondary pages: 1, swept pages: 4 
    Empty pages: 55, full pages: 3652 
    Fill distribution: 
     0 - 19% = 61 
    20 - 39% = 4 
    40 - 59% = 1 
    60 - 79% = 2 
    80 - 99% = 3652 
 
PERF_SPLIT_3 (284) 
    Primary pointer page: 580, Index root page: 581 
    Total formats: 1, used formats: 1 
    Average record length: 145.67, total records: 171242 
    Average version length: 151.02, total versions: 6055, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.64 
    Pointer pages: 7, data page slots: 4904 
    Data pages: 4120, average fill: 86% 
    Primary pages: 4119, secondary pages: 1, swept pages: 2 
    Empty pages: 57, full pages: 4052 
    Fill distribution: 
     0 - 19% = 62 
    20 - 39% = 1 
    40 - 59% = 0 
    60 - 79% = 5 
    80 - 99% = 4052 
 
PERF_SPLIT_4 (285) 
    Primary pointer page: 582, Index root page: 583 
    Total formats: 1, used formats: 1 
    Average record length: 141.81, total records: 153337 
    Average version length: 152.98, total versions: 9239, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.96 
    Pointer pages: 7, data page slots: 5920 
    Data pages: 3752, average fill: 85% 
    Primary pages: 3752, secondary pages: 0, swept pages: 1 
    Empty pages: 101, full pages: 3614 
    Fill distribution: 
     0 - 19% = 102 
    20 - 39% = 12 
    40 - 59% = 12 
    60 - 79% = 12 
    80 - 99% = 3614 
 
PERF_SPLIT_5 (286) 
    Primary pointer page: 584, Index root page: 585 
    Total formats: 1, used formats: 1 
    Average record length: 147.45, total records: 195546 
    Average version length: 151.79, total versions: 4863, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.50 
    Pointer pages: 8, data page slots: 7456 
    Data pages: 4720, average fill: 86% 
    Primary pages: 4720, secondary pages: 0, swept pages: 3 
    Empty pages: 72, full pages: 4626 
    Fill distribution: 
     0 - 19% = 74 
    20 - 39% = 6 
    40 - 59% = 8 
    60 - 79% = 6 
    80 - 99% = 4626 
 
PERF_SPLIT_6 (287) 
    Primary pointer page: 586, Index root page: 587 
    Total formats: 1, used formats: 1 
    Average record length: 145.80, total records: 188375 
    Average version length: 151.43, total versions: 6639, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.63 
    Pointer pages: 7, data page slots: 4944 
    Data pages: 4488, average fill: 87% 
    Primary pages: 4488, secondary pages: 0, swept pages: 8 
    Empty pages: 19, full pages: 4463 
    Fill distribution: 
     0 - 19% = 19 
    20 - 39% = 4 
    40 - 59% = 1 
    60 - 79% = 5 
    80 - 99% = 4459 
 
PERF_SPLIT_7 (288) 
    Primary pointer page: 588, Index root page: 589 
    Total formats: 1, used formats: 1 
    Average record length: 130.74, total records: 192435 
    Average version length: 154.86, total versions: 25712, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 12.97 
    Pointer pages: 8, data page slots: 6032 
    Data pages: 4680, average fill: 86% 
    Primary pages: 4680, secondary pages: 0, swept pages: 7 
    Empty pages: 91, full pages: 4558 
    Fill distribution: 
     0 - 19% = 98 
    20 - 39% = 7 
    40 - 59% = 7 
    60 - 79% = 12 
    80 - 99% = 4556 
 
PERF_SPLIT_8 (289) 
    Primary pointer page: 590, Index root page: 591 
    Total formats: 1, used formats: 1 
    Average record length: 140.64, total records: 184580 
    Average version length: 153.92, total versions: 12648, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 12.06 
    Pointer pages: 7, data page slots: 5824 
    Data pages: 4416, average fill: 87% 
    Primary pages: 4416, secondary pages: 0, swept pages: 1 
    Empty pages: 35, full pages: 4373 
    Fill distribution: 
     0 - 19% = 37 
    20 - 39% = 2 
    40 - 59% = 1 
    60 - 79% = 2 
    80 - 99% = 4374 
 
PERF_SPLIT_9 (290) 
    Primary pointer page: 593, Index root page: 594 
    Total formats: 1, used formats: 1 
    Average record length: 146.56, total records: 171583 
    Average version length: 151.67, total versions: 5063, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.57 
    Pointer pages: 7, data page slots: 5272 
    Data pages: 4120, average fill: 86% 
    Primary pages: 4120, secondary pages: 0, swept pages: 2 
    Empty pages: 50, full pages: 4062 
    Fill distribution: 
     0 - 19% = 52 
    20 - 39% = 2 
    40 - 59% = 3 
    60 - 79% = 1 
    80 - 99% = 4062 
 
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: 52.22, total records: 2076782 
    Average version length: 52.99, total versions: 20857, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 70.00, compression ratio: 1.34 
    Pointer pages: 16, data page slots: 25744 
    Data pages: 25744, average fill: 69% 
    Primary pages: 25744, secondary pages: 0, swept pages: 12722 
    Empty pages: 426, full pages: 19519 
    Fill distribution: 
     0 - 19% = 781 
    20 - 39% = 610 
    40 - 59% = 1519 
    60 - 79% = 22672 
    80 - 99% = 162 
 
    Index PSTORNED_RCV_ID (1) 
    Root page: 1506186, depth: 3, leaf buckets: 2562, nodes: 2076782 
    Average node length: 5.44, total dup: 1937252, max dup: 2042 
    Average key length: 2.49, compression ratio: 3.62 
    Average prefix length: 8.58, average data length: 0.42 
    Clustering factor: 180065, ratio: 0.09 
    Fill distribution: 
         0 - 19% = 3 
        20 - 39% = 322 
        40 - 59% = 1644 
        60 - 79% = 297 
        80 - 99% = 296 
 
    Index PSTORNED_SND_ID (0) 
    Root page: 1504819, depth: 3, leaf buckets: 2761, nodes: 2076782 
    Average node length: 5.69, total dup: 1863412, max dup: 65 
    Average key length: 2.74, compression ratio: 3.28 
    Average prefix length: 8.36, average data length: 0.64 
    Clustering factor: 371301, ratio: 0.18 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 9 
        40 - 59% = 2468 
        60 - 79% = 261 
        80 - 99% = 22 
 
    Index PSTORNED_WORKER_ID (2) 
    Root page: 1507996, depth: 3, leaf buckets: 2129, nodes: 2076782 
    Average node length: 4.96, total dup: 2076682, max dup: 27887 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.43, average data length: 0.00 
    Clustering factor: 178157, ratio: 0.09 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 219 
        40 - 59% = 1109 
        60 - 79% = 398 
        80 - 99% = 402 
 
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: 40.43, total records: 139074 
    Average version length: 69.17, total versions: 57846, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 3.12 
    Pointer pages: 3, data page slots: 4088 
    Data pages: 3312, average fill: 49% 
    Primary pages: 3312, secondary pages: 0, swept pages: 692 
    Empty pages: 788, full pages: 1538 
    Fill distribution: 
     0 - 19% = 1125 
    20 - 39% = 226 
    40 - 59% = 252 
    60 - 79% = 540 
    80 - 99% = 1169 
 
    Index XQD_1000_1200_WA_SO_RO_WKR_SND (0) 
    Root page: 99398, depth: 3, leaf buckets: 231, nodes: 139074 
    Average node length: 6.40, total dup: 120828, max dup: 14 
    Average key length: 3.97, compression ratio: 10.57 
    Average prefix length: 40.16, average data length: 1.84 
    Clustering factor: 24095, ratio: 0.17 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 73 
        40 - 59% = 112 
        60 - 79% = 38 
        80 - 99% = 8 
 
XQD_1000_3300 (178) 
    Primary pointer page: 553, Index root page: 554 
    Total formats: 1, used formats: 1 
    Average record length: 65.85, total records: 7078090 
    Average version length: 68.77, total versions: 320288, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.91 
    Pointer pages: 64, data page slots: 103784 
    Data pages: 103784, average fill: 73% 
    Primary pages: 103784, secondary pages: 0, swept pages: 36610 
    Empty pages: 10, full pages: 70470 
    Fill distribution: 
     0 - 19% = 51 
    20 - 39% = 752 
    40 - 59% = 8291 
    60 - 79% = 90940 
    80 - 99% = 3750 
 
    Index XQD_1000_3300_WA_SO_RO_WKR_SND (0) 
    Root page: 1480454, depth: 3, leaf buckets: 10713, nodes: 7078090 
    Average node length: 6.51, total dup: 6120682, max dup: 32 
    Average key length: 3.52, compression ratio: 11.92 
    Average prefix length: 40.61, average data length: 1.39 
    Clustering factor: 1576018, ratio: 0.22 
    Fill distribution: 
         0 - 19% = 6 
        20 - 39% = 1593 
        40 - 59% = 5889 
        60 - 79% = 2743 
        80 - 99% = 482 
 
    Index XQD_1000_3300_WKR_DOC_ASC (1) 
    Root page: 1486068, depth: 3, leaf buckets: 8582, nodes: 7078090 
    Average node length: 5.40, total dup: 6796113, max dup: 187 
    Average key length: 2.41, compression ratio: 7.06 
    Average prefix length: 16.63, average data length: 0.37 
    Clustering factor: 1376531, ratio: 0.19 
    Fill distribution: 
         0 - 19% = 4 
        20 - 39% = 1236 
        40 - 59% = 4819 
        60 - 79% = 1512 
        80 - 99% = 1011 
 
    Index XQD_1000_3300_WKR_DOC_DEC (2) 
    Root page: 1490608, depth: 3, leaf buckets: 8641, nodes: 7078090 
    Average node length: 5.40, total dup: 6796113, max dup: 187 
    Average key length: 2.41, compression ratio: 7.06 
    Average prefix length: 16.63, average data length: 0.37 
    Clustering factor: 1379068, ratio: 0.19 
    Fill distribution: 
         0 - 19% = 6 
        20 - 39% = 1289 
        40 - 59% = 4802 
        60 - 79% = 1555 
        80 - 99% = 989 
 
XQD_1200_2000 (177) 
    Primary pointer page: 551, Index root page: 552 
    Total formats: 1, used formats: 1 
    Average record length: 67.53, total records: 12031924 
    Average version length: 68.76, total versions: 249395, 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: 104, data page slots: 168104 
    Data pages: 168104, average fill: 76% 
    Primary pages: 168104, secondary pages: 0, swept pages: 86742 
    Empty pages: 5, full pages: 151565 
    Fill distribution: 
     0 - 19% = 39 
    20 - 39% = 416 
    40 - 59% = 4053 
    60 - 79% = 159503 
    80 - 99% = 4093 
 
    Index XQD_1200_2000_WA_SO_RO_WKR_SND (0) 
    Root page: 1495028, depth: 3, leaf buckets: 18345, nodes: 12031924 
    Average node length: 6.58, total dup: 10488332, max dup: 60 
    Average key length: 3.43, compression ratio: 12.26 
    Average prefix length: 40.70, average data length: 1.30 
    Clustering factor: 2374873, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 33 
        20 - 39% = 2311 
        40 - 59% = 10839 
        60 - 79% = 4315 
        80 - 99% = 847 
 
XQD_2000_3300 (179) 
    Primary pointer page: 555, Index root page: 556 
    Total formats: 1, used formats: 1 
    Average record length: 48.54, total records: 1464633 
    Average version length: 69.12, total versions: 436948, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 2.60 
    Pointer pages: 28, data page slots: 44472 
    Data pages: 27936, average fill: 59% 
    Primary pages: 27935, secondary pages: 1, swept pages: 9497 
    Empty pages: 3463, full pages: 16460 
    Fill distribution: 
     0 - 19% = 5550 
    20 - 39% = 2263 
    40 - 59% = 1947 
    60 - 79% = 11443 
    80 - 99% = 6733 
 
    Index XQD_2000_3300_WA_SO_RO_WKR_SND (0) 
    Root page: 1479712, depth: 3, leaf buckets: 2185, nodes: 1464633 
    Average node length: 5.52, total dup: 1405264, max dup: 97 
    Average key length: 2.57, compression ratio: 16.35 
    Average prefix length: 41.47, average data length: 0.53 
    Clustering factor: 97564, ratio: 0.07 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 810 
        40 - 59% = 1028 
        60 - 79% = 301 
        80 - 99% = 44 
 
XQD_2100_3300 (180) 
    Primary pointer page: 557, Index root page: 558 
    Total formats: 1, used formats: 1 
    Average record length: 41.36, total records: 1065935 
    Average version length: 69.13, total versions: 427182, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 3.05 
    Pointer pages: 22, data page slots: 35512 
    Data pages: 27560, average fill: 45% 
    Primary pages: 27560, secondary pages: 0, swept pages: 7910 
    Empty pages: 6462, full pages: 11133 
    Fill distribution: 
     0 - 19% = 10147 
    20 - 39% = 2794 
    40 - 59% = 2391 
    60 - 79% = 3695 
    80 - 99% = 8533 
 
    Index XQD_2100_3300_WA_SO_RO_WKR_SND (0) 
    Root page: 1479207, depth: 3, leaf buckets: 1563, nodes: 1065935 
    Average node length: 5.78, total dup: 996154, max dup: 99 
    Average key length: 2.85, compression ratio: 14.74 
    Average prefix length: 41.22, average data length: 0.78 
    Clustering factor: 145073, ratio: 0.14 
    Fill distribution: 
         0 - 19% = 5 
        20 - 39% = 450 
        40 - 59% = 751 
        60 - 79% = 316 
        80 - 99% = 41 
 
XQD_3300_3400 (181) 
    Primary pointer page: 559, Index root page: 560 
    Total formats: 1, used formats: 1 
    Average record length: 66.53, total records: 9043468 
    Average version length: 68.97, total versions: 309581, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.89 
    Pointer pages: 90, data page slots: 146624 
    Data pages: 146584, average fill: 66% 
    Primary pages: 146584, secondary pages: 0, swept pages: 76680 
    Empty pages: 622, full pages: 70373 
    Fill distribution: 
     0 - 19% = 1995 
    20 - 39% = 9782 
    40 - 59% = 28559 
    60 - 79% = 102383 
    80 - 99% = 3865 
 
    Index XQD_3300_3400_WA_SO_RO_WKR_SND (0) 
    Root page: 1472590, depth: 3, leaf buckets: 13499, nodes: 9043468 
    Average node length: 6.70, total dup: 7502565, max dup: 15 
    Average key length: 3.67, compression ratio: 11.45 
    Average prefix length: 40.50, average data length: 1.50 
    Clustering factor: 1935770, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 1382 
        40 - 59% = 7213 
        60 - 79% = 4394 
        80 - 99% = 510 
 
XQS_1000_1200 (182) 
    Primary pointer page: 561, Index root page: 562 
    Total formats: 1, used formats: 1 
    Average record length: 82.51, total records: 21182097 
    Average version length: 82.94, total versions: 8642, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.53 
    Pointer pages: 196, data page slots: 319296 
    Data pages: 319296, average fill: 81% 
    Primary pages: 319296, secondary pages: 0, swept pages: 13282 
    Empty pages: 36, full pages: 318405 
    Fill distribution: 
     0 - 19% = 54 
    20 - 39% = 43 
    40 - 59% = 98 
    60 - 79% = 27921 
    80 - 99% = 291180 
 
    Index XQS_1000_1200_DOC_ID (1) 
    Root page: 1426716, depth: 3, leaf buckets: 19348, nodes: 21182097 
    Average node length: 5.72, total dup: 20700401, max dup: 132 
    Average key length: 2.16, compression ratio: 4.16 
    Average prefix length: 8.86, average data length: 0.14 
    Clustering factor: 3288022, ratio: 0.16 
    Fill distribution: 
         0 - 19% = 9 
        20 - 39% = 1 
        40 - 59% = 7975 
        60 - 79% = 607 
        80 - 99% = 10756 
 
    Index XQS_1000_1200_RCV_ID (3) 
    Root page: 1456980, depth: 3, leaf buckets: 17232, nodes: 21182097 
    Average node length: 6.31, total dup: 18615160, max dup: 49 
    Average key length: 2.75, compression ratio: 3.27 
    Average prefix length: 8.37, average data length: 0.63 
    Clustering factor: 917126, ratio: 0.04 
    Fill distribution: 
         0 - 19% = 3 
        20 - 39% = 5 
        40 - 59% = 837 
        60 - 79% = 273 
        80 - 99% = 16114 
 
    Index XQS_1000_1200_SND_ID (2) 
    Root page: 1441073, depth: 3, leaf buckets: 21109, nodes: 21182097 
    Average node length: 6.35, total dup: 18533160, max dup: 29 
    Average key length: 2.79, compression ratio: 3.23 
    Average prefix length: 8.34, average data length: 0.66 
    Clustering factor: 3582218, ratio: 0.17 
    Fill distribution: 
         0 - 19% = 5 
        20 - 39% = 2 
        40 - 59% = 8223 
        60 - 79% = 631 
        80 - 99% = 12248 
 
    Index XQS_1000_1200_WORKER_ID (0) 
    Root page: 1413348, depth: 3, leaf buckets: 16155, nodes: 21182097 
    Average node length: 5.56, total dup: 21181997, max dup: 231258 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.42, average data length: 0.00 
    Clustering factor: 945979, ratio: 0.04 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 13 
        40 - 59% = 2954 
        60 - 79% = 389 
        80 - 99% = 12799 
 
XQS_1000_3300 (184) 
    Primary pointer page: 565, Index root page: 566 
    Total formats: 1, used formats: 1 
    Average record length: 79.46, total records: 9528050 
    Average version length: 82.65, total versions: 340758, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.59 
    Pointer pages: 107, data page slots: 174096 
    Data pages: 174032, average fill: 68% 
    Primary pages: 174032, secondary pages: 0, swept pages: 93755 
    Empty pages: 1019, full pages: 91398 
    Fill distribution: 
     0 - 19% = 2955 
    20 - 39% = 11099 
    40 - 59% = 32395 
    60 - 79% = 74235 
    80 - 99% = 53348 
 
    Index XQS_1000_3300_DOC_ID (1) 
    Root page: 1367502, depth: 3, leaf buckets: 11418, nodes: 9528050 
    Average node length: 5.38, total dup: 9220861, max dup: 179 
    Average key length: 2.24, compression ratio: 4.03 
    Average prefix length: 8.80, average data length: 0.20 
    Clustering factor: 2085918, ratio: 0.22 
    Fill distribution: 
         0 - 19% = 6 
        20 - 39% = 110 
        40 - 59% = 8745 
        60 - 79% = 2506 
        80 - 99% = 51 
 
    Index XQS_1000_3300_RCV_ID (3) 
    Root page: 1379261, depth: 3, leaf buckets: 13579, nodes: 9528050 
    Average node length: 6.25, total dup: 7898973, max dup: 14 
    Average key length: 3.10, compression ratio: 2.90 
    Average prefix length: 8.07, average data length: 0.93 
    Clustering factor: 1438540, ratio: 0.15 
    Fill distribution: 
         0 - 19% = 155 
        20 - 39% = 4153 
        40 - 59% = 4345 
        60 - 79% = 2702 
        80 - 99% = 2224 
 
    Index XQS_1000_3300_SND_ID (2) 
    Root page: 1373059, depth: 3, leaf buckets: 12741, nodes: 9528050 
    Average node length: 6.00, total dup: 8261311, max dup: 37 
    Average key length: 2.85, compression ratio: 3.15 
    Average prefix length: 8.28, average data length: 0.72 
    Clustering factor: 2272952, ratio: 0.24 
    Fill distribution: 
         0 - 19% = 3 
        20 - 39% = 139 
        40 - 59% = 9726 
        60 - 79% = 2793 
        80 - 99% = 80 
 
    Index XQS_1000_3300_WORKER_ID (0) 
    Root page: 1362767, depth: 3, leaf buckets: 10062, nodes: 9528050 
    Average node length: 5.15, total dup: 9527950, max dup: 149142 
    Average key length: 2.00, compression ratio: 1.22 
    Average prefix length: 2.43, average data length: 0.00 
    Clustering factor: 1488570, ratio: 0.16 
    Fill distribution: 
         0 - 19% = 45 
        20 - 39% = 1381 
        40 - 59% = 4855 
        60 - 79% = 1777 
        80 - 99% = 2004 
 
XQS_1200_2000 (183) 
    Primary pointer page: 563, Index root page: 564 
    Total formats: 1, used formats: 1 
    Average record length: 80.65, total records: 11192765 
    Average version length: 82.59, total versions: 224501, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.56 
    Pointer pages: 120, data page slots: 194768 
    Data pages: 193144, average fill: 71% 
    Primary pages: 193144, secondary pages: 0, swept pages: 82378 
    Empty pages: 3815, full pages: 135810 
    Fill distribution: 
     0 - 19% = 6554 
    20 - 39% = 9402 
    40 - 59% = 20992 
    60 - 79% = 46515 
    80 - 99% = 109681 
 
    Index XQS_1200_2000_DOC_ID (1) 
    Root page: 1392101, depth: 3, leaf buckets: 13130, nodes: 11192765 
    Average node length: 5.31, total dup: 11083161, max dup: 642 
    Average key length: 2.08, compression ratio: 4.32 
    Average prefix length: 8.93, average data length: 0.07 
    Clustering factor: 2334889, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 120 
        40 - 59% = 9437 
        60 - 79% = 3424 
        80 - 99% = 149 
 
    Index XQS_1200_2000_RCV_ID (3) 
    Root page: 1406110, depth: 3, leaf buckets: 10424, nodes: 11192765 
    Average node length: 5.51, total dup: 10703751, max dup: 49 
    Average key length: 2.28, compression ratio: 3.95 
    Average prefix length: 8.77, average data length: 0.23 
    Clustering factor: 708143, ratio: 0.06 
    Fill distribution: 
         0 - 19% = 169 
        20 - 39% = 870 
        40 - 59% = 2532 
        60 - 79% = 1966 
        80 - 99% = 4887 
 
    Index XQS_1200_2000_SND_ID (2) 
    Root page: 1398638, depth: 3, leaf buckets: 15026, nodes: 11192765 
    Average node length: 6.04, total dup: 9760087, max dup: 59 
    Average key length: 2.81, compression ratio: 3.20 
    Average prefix length: 8.32, average data length: 0.68 
    Clustering factor: 2351256, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 4 
        20 - 39% = 139 
        40 - 59% = 10972 
        60 - 79% = 3769 
        80 - 99% = 142 
 
    Index XQS_1200_2000_WORKER_ID (0) 
    Root page: 1386211, depth: 3, leaf buckets: 10717, nodes: 11192765 
    Average node length: 5.23, total dup: 11192665, max dup: 204387 
    Average key length: 2.00, compression ratio: 1.22 
    Average prefix length: 2.43, average data length: 0.00 
    Clustering factor: 697066, ratio: 0.06 
    Fill distribution: 
         0 - 19% = 86 
        20 - 39% = 906 
        40 - 59% = 4678 
        60 - 79% = 1558 
        80 - 99% = 3489 
 
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: 80.08, total records: 9610363 
    Average version length: 82.92, total versions: 308537, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.57 
    Pointer pages: 110, data page slots: 177952 
    Data pages: 177872, average fill: 67% 
    Primary pages: 177872, secondary pages: 0, swept pages: 101675 
    Empty pages: 985, full pages: 88025 
    Fill distribution: 
     0 - 19% = 3098 
    20 - 39% = 11914 
    40 - 59% = 35784 
    60 - 79% = 75107 
    80 - 99% = 51969 
 
    Index XQS_2100_3300_DOC_ID (1) 
    Root page: 1344686, depth: 3, leaf buckets: 11732, nodes: 9610363 
    Average node length: 5.19, total dup: 9581754, max dup: 1547 
    Average key length: 2.03, compression ratio: 4.43 
    Average prefix length: 8.97, average data length: 0.03 
    Clustering factor: 1903373, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 33 
        20 - 39% = 1558 
        40 - 59% = 7749 
        60 - 79% = 1864 
        80 - 99% = 528 
 
    Index XQS_2100_3300_RCV_ID (3) 
    Root page: 1355717, depth: 3, leaf buckets: 13661, nodes: 9610363 
    Average node length: 6.26, total dup: 7967347, max dup: 14 
    Average key length: 3.10, compression ratio: 2.90 
    Average prefix length: 8.07, average data length: 0.93 
    Clustering factor: 1392775, ratio: 0.14 
    Fill distribution: 
         0 - 19% = 173 
        20 - 39% = 4197 
        40 - 59% = 4214 
        60 - 79% = 2725 
        80 - 99% = 2352 
 
    Index XQS_2100_3300_SND_ID (2) 
    Root page: 1350049, depth: 3, leaf buckets: 12382, nodes: 9610363 
    Average node length: 5.45, total dup: 9177345, max dup: 99 
    Average key length: 2.29, compression ratio: 3.93 
    Average prefix length: 8.76, average data length: 0.24 
    Clustering factor: 2032201, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 33 
        20 - 39% = 1545 
        40 - 59% = 8634 
        60 - 79% = 1617 
        80 - 99% = 553 
 
    Index XQS_2100_3300_WORKER_ID (0) 
    Root page: 985805, depth: 3, leaf buckets: 10164, nodes: 9610363 
    Average node length: 5.16, total dup: 9610263, max dup: 151199 
    Average key length: 2.00, compression ratio: 1.22 
    Average prefix length: 2.43, average data length: 0.00 
    Clustering factor: 1504252, ratio: 0.16 
    Fill distribution: 
         0 - 19% = 30 
        20 - 39% = 1363 
        40 - 59% = 5034 
        60 - 79% = 1685 
        80 - 99% = 2052 
 
XQS_3300_3400 (187) 
    Primary pointer page: 571, Index root page: 572 
    Total formats: 1, used formats: 1 
    Average record length: 67.83, total records: 570745 
    Average version length: 68.69, total versions: 2806, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.86 
    Pointer pages: 5, data page slots: 8056 
    Data pages: 8056, average fill: 74% 
    Primary pages: 8056, secondary pages: 0, swept pages: 4526 
    Empty pages: 3, full pages: 6245 
    Fill distribution: 
     0 - 19% = 8 
    20 - 39% = 50 
    40 - 59% = 395 
    60 - 79% = 7567 
    80 - 99% = 36 
 
    Index XQS_3300_3400_DOC_ID (1) 
    Root page: 47642, depth: 3, leaf buckets: 732, nodes: 570745 
    Average node length: 5.95, total dup: 485831, max dup: 83 
    Average key length: 3.09, compression ratio: 2.91 
    Average prefix length: 8.05, average data length: 0.95 
    Clustering factor: 99054, ratio: 0.17 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 40 
        40 - 59% = 515 
        60 - 79% = 85 
        80 - 99% = 92 
 
    Index XQS_3300_3400_SND_ID (2) 
    Root page: 35382, depth: 3, leaf buckets: 747, nodes: 570745 
    Average node length: 6.15, total dup: 468083, max dup: 27 
    Average key length: 3.29, compression ratio: 2.73 
    Average prefix length: 7.89, average data length: 1.11 
    Clustering factor: 99111, ratio: 0.17 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 32 
        40 - 59% = 530 
        60 - 79% = 80 
        80 - 99% = 105 
 
    Index XQS_3300_3400_WORKER_ID (0) 
    Root page: 375548, depth: 2, leaf buckets: 577, nodes: 570745 
    Average node length: 4.86, total dup: 570645, max dup: 9763 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.43, average data length: 0.00 
    Clustering factor: 88083, ratio: 0.15 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 39 
        40 - 59% = 348 
        60 - 79% = 86 
        80 - 99% = 104 
 
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 Fri Mar  1 16:15:34 2024

Record versions statistics, table

TABLE_NAME TOTAL_RECS TOTAL_VERS MAX_VERSIONS VERS_TO_RECS_PRC MAXV_TO_VERS_PRC
DOC_DATA 7733671 59754 1 0.0000 0.0000
DOC_LIST 2228527 59030 3 0.0000 0.0000
FB_ERRORS 2182 757 1 0.0000 0.0000
INVNT_SALDO 400 257898 672 64400.0000 0.0000
INVNT_TURNOVER_LOG 134568 113171 1 0.0000 0.0000
MONEY_SALDO 49 18160 985 37000.0000 0.0000
MONEY_TURNOVER_LOG 2089 1915 1 0.0000 0.0000
PDISTR 809890 61857 4 0.0000 0.0000
PERF_SPLIT_0 206505 45937 1 0.0000 0.0000
PERF_SPLIT_1 166071 6405 1 0.0000 0.0000
PERF_SPLIT_2 154403 2460 1 0.0000 0.0000
PERF_SPLIT_3 171242 6055 1 0.0000 0.0000
PERF_SPLIT_4 153337 9239 1 0.0000 0.0000
PERF_SPLIT_5 195546 4863 1 0.0000 0.0000
PERF_SPLIT_6 188375 6639 1 0.0000 0.0000
PERF_SPLIT_7 192435 25712 1 0.0000 0.0000
PERF_SPLIT_8 184580 12648 1 0.0000 0.0000
PERF_SPLIT_9 171583 5063 1 0.0000 0.0000
PSTORNED 2076782 20857 1 0.0000 0.0000
SEMAPHORES 5 1 1 0.0000 100.0000
XQD_1000_1200 139074 57846 1 0.0000 0.0000
XQD_1000_3300 7078090 320288 1 0.0000 0.0000
XQD_1200_2000 12031924 249395 1 0.0000 0.0000
XQD_2000_3300 1464633 436948 1 0.0000 0.0000
XQD_2100_3300 1065935 427182 1 0.0000 0.0000
XQD_3300_3400 9043468 309581 1 0.0000 0.0000
XQS_1000_1200 21182097 8642 1 0.0000 0.0000
XQS_1000_3300 9528050 340758 1 0.0000 0.0000
XQS_1200_2000 11192765 224501 1 0.0000 0.0000
XQS_2100_3300 9610363 308537 1 0.0000 0.0000
XQS_3300_3400 570745 2806 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'  

01.03.24 16:15:46. 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-01 16:15:49 No severe PSQL-related problems occured
01.03.24 16:15:50. End of report.