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

Hardware and OS info

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

Server and database settinfs 


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

Test configuration settings 

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

Test finish info 


FINISH_STATE                    NORMAL: TEST_TIME EXPIRED AT 2024-02-28 10:07:48
DTS_END                         2024-02-28 10:07:48.4160
FB_GDSCODE                      -1
FB_MNEMONA                      
STACK                           SP_ADD_INVOICE_TO_STOCK(190:30) ==> SP_CUSTOMER_RESERVE(47:5) ==> SP_CHECK_TO_STOP_WORK(32:12) ==> SP_HALT_ON_ERROR(68:17)
IP                              ::1/60180
TRN_ID                          176639
ATT_ID                          583
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: 9230.85 19469 923085
customer order: creation 185.71 393 18571
customer order: refuse 16.40 348 1640
order to supplier: creation 49.43 1263 4943
order to supplier: removal 3.72 96257 372
invoice (draft): creation 49.54 3113 4954
invoice (draft): removal 50.53 712 5053
invoice accept: apply 43.97 21325 4397
invoice accept: cancel 45.09 918 4509
customer reserve: creation 4153.98 209 415398
customer reserve: removal 4319.32 66 431932
realization accept: apply 90.06 194 9006
realization accept: cancel 85.09 143 8509
payment from customer: creation 64.41 108 6441
payment from customer: removal 5.64 113 564
payment to supplier: creation 52.75 134 5275
payment to supplier: removal 3.76 113 376
service: total inventory turnovers 4.25 3801 425
service: total monetary turnovers 6.24 659 624
service: aggregate perf. data 0.93 15344 93
service: refresh index statistics 0.03 244157 3

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:03, from 28-02-2024 10:09:32 to 28-02-2024 10:09:35.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 4987
TEST_TIME 2 5281
TEST_TIME 3 4154
TEST_TIME 4 4510
TEST_TIME 5 4902
TEST_TIME 6 5828
TEST_TIME 7 5975
TEST_TIME 8 5736
TEST_TIME 9 5847
TEST_TIME 10 6030
TEST_TIME 11 6176
TEST_TIME 12 6559
TEST_TIME 13 6574
TEST_TIME 14 6747
TEST_TIME 15 7065
TEST_TIME 16 6963
TEST_TIME 17 6963
TEST_TIME 18 7271
TEST_TIME 19 7372
TEST_TIME 20 7733
TEST_TIME 21 8123
TEST_TIME 22 8196
TEST_TIME 23 8602
TEST_TIME 24 8765
TEST_TIME 25 9128
TEST_TIME 26 9504
TEST_TIME 27 10227
TEST_TIME 28 10164
TEST_TIME 29 9933
TEST_TIME 30 10002
TEST_TIME 31 10034
TEST_TIME 32 9734
TEST_TIME 33 9638
TEST_TIME 34 9403
TEST_TIME 35 9372
TEST_TIME 36 9455
TEST_TIME 37 9406
TEST_TIME 38 9331
TEST_TIME 39 9253
TEST_TIME 40 9160
TEST_TIME 41 9119
TEST_TIME 42 9015
TEST_TIME 43 9290
TEST_TIME 44 9471
TEST_TIME 45 9495
TEST_TIME 46 9643
TEST_TIME 47 9755
TEST_TIME 48 9652
TEST_TIME 49 9805
TEST_TIME 50 9751
TEST_TIME 51 9725
TEST_TIME 52 9849
TEST_TIME 53 9921
TEST_TIME 54 9841
TEST_TIME 55 9685
TEST_TIME 56 9664
TEST_TIME 57 9551
TEST_TIME 58 9598
TEST_TIME 59 9578
TEST_TIME 60 9538
TEST_TIME 61 9488
TEST_TIME 62 9399
TEST_TIME 63 9421
TEST_TIME 64 9373
TEST_TIME 65 9410
TEST_TIME 66 9403
TEST_TIME 67 9457
TEST_TIME 68 9412
TEST_TIME 69 9501
TEST_TIME 70 9490
TEST_TIME 71 9518
TEST_TIME 72 9483
TEST_TIME 73 9597
TEST_TIME 74 9664
TEST_TIME 75 9732
TEST_TIME 76 9645
TEST_TIME 77 9533
TEST_TIME 78 9519
TEST_TIME 79 9566
TEST_TIME 80 9547
TEST_TIME 81 9465
TEST_TIME 82 9433
TEST_TIME 83 9375
TEST_TIME 84 9331
TEST_TIME 85 9348
TEST_TIME 86 9331
TEST_TIME 87 9334
TEST_TIME 88 9393
TEST_TIME 89 9396
TEST_TIME 90 9399
TEST_TIME 91 9489
TEST_TIME 92 9474
TEST_TIME 93 9438
TEST_TIME 94 9483
TEST_TIME 95 9476
TEST_TIME 96 9412
TEST_TIME 97 9352
TEST_TIME 98 9350
TEST_TIME 99 9290
TEST_TIME 100 9242

Performance per minute, chart


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

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 1302686 1302686 0 0.00 0 24893 8 0 0
doc_list_biud 1302686 1302686 0 0.00 0 51829 27 0 0
sp_add_invoice_to_stock 4489 4397 92 2.04 33 199842 21325 0 92
sp_cancel_adding_invoice 4509 4509 0 0.00 4 54572 918 0 0
sp_cancel_client_order 1640 1640 0 0.00 4 8281 349 0 0
sp_cancel_customer_reserve 431932 431932 0 0.00 0 21989 67 0 0
sp_cancel_pay_from_customer 564 564 0 0.00 2 10646 113 0 0
sp_cancel_pay_to_supplier 376 376 0 0.00 2 8493 113 0 0
sp_cancel_supplier_invoice 5063 5053 10 0.19 1 16634 713 0 10
sp_cancel_supplier_order 372 372 0 0.00 6 1093498 96258 0 0
sp_cancel_write_off 8509 8509 0 0.00 1 24558 143 0 0
sp_client_order 18571 18571 0 0.00 3 42798 393 0 0
sp_customer_reserve 415398 415398 0 0.00 0 84358 210 0 0
sp_fill_shopping_cart 28460 28460 0 0.00 1 14026 34 0 0
sp_fill_shopping_cart_clo_res 415384 415384 0 0.00 0 19605 17 0 0
sp_get_clo_for_invoice 4380 4380 0 0.00 0 28257 294 0 0
sp_kill_cost_storno 13958 13958 0 0.00 0 21237 70 0 0
sp_kill_qstorno_ret_qs2qd 877798 877798 0 0.00 0 24478 36 0 0
sp_kill_qty_storno 465401 465401 0 0.00 0 51828 76 0 0
sp_lock_selected_doc 18488 18488 0 0.00 0 8324 7 0 0
sp_make_cost_storno 25102 25102 0 0.00 0 16006 63 0 0
sp_multiply_rows_for_pdistr 25102 25102 0 0.00 0 17364 33 0 0
sp_multiply_rows_for_qdistr 18571 18571 0 0.00 0 42785 204 0 0
sp_pay_from_customer 6441 6441 0 0.00 3 13300 109 0 0
sp_pay_to_supplier 5275 5275 0 0.00 4 17381 135 0 0
sp_payment_common 11716 11716 0 0.00 1 11392 19 0 0
sp_qd_handle_on_cancel_clo 1640 1640 0 0.00 0 7035 319 0 0
sp_qd_handle_on_invoice_upd_sts 8889 8889 0 0.00 0 51827 307 0 0
sp_qd_handle_on_reserve_upd_sts 9006 9006 0 0.00 0 15745 60 0 0
sp_reserve_write_off 9006 9006 0 0.00 6 15787 194 0 0
sp_supplier_invoice 4954 4954 0 0.00 6 78973 3114 0 0
sp_supplier_order 4943 4943 0 0.00 4 46929 1264 0 0
srv_aggregate_perf_data 93 93 0 0.00 1613 90009 15344 0 0
srv_fill_mon_cache_memory 54 54 0 0.00 2689 142778 44039 0 0
srv_find_qd_qs_mism 877726 877726 0 0.00 0 24893 7 0 0
srv_make_invnt_saldo 425 425 0 0.00 42 106486 3802 0 0
srv_make_money_saldo 624 624 0 0.00 1 19605 660 0 0
srv_recalc_idx_stat 3 3 0 0.00 175325 324064 244157 0 0
t$perf-abend:sp_add_invoice_to_stock 92 92 0 0.00 0 0 0 0 0
t$perf-abend:sp_cancel_supplier_invoice 10 10 0 0.00 0 0 0 0 0
t$perf-norm:sp_add_invoice_to_stock 4397 4397 0 0.00 0 14585 184 0 0
t$perf-norm:sp_cancel_adding_invoice 363 363 0 0.00 0 3027 103 0 0
t$perf-norm:sp_cancel_client_order 1640 1640 0 0.00 0 4575 18 0 0
t$perf-norm:sp_cancel_customer_reserve 582 582 0 0.00 0 3054 12 0 0
t$perf-norm:sp_cancel_pay_from_customer 564 564 0 0.00 0 2459 10 0 0
t$perf-norm:sp_cancel_pay_to_supplier 376 376 0 0.00 0 3721 16 0 0
t$perf-norm:sp_cancel_supplier_invoice 343 343 0 0.00 0 896 17 0 0
t$perf-norm:sp_cancel_supplier_order 372 372 0 0.00 0 26549 1648 0 0
t$perf-norm:sp_cancel_write_off 862 862 0 0.00 0 4286 11 0 0
t$perf-norm:sp_client_order 18571 18571 0 0.00 0 7719 15 0 0
t$perf-norm:sp_customer_reserve 910 910 0 0.00 0 14481 31 0 0
t$perf-norm:sp_pay_from_customer 6441 6441 0 0.00 0 7043 13 0 0
t$perf-norm:sp_pay_to_supplier 5275 5275 0 0.00 0 4236 8 0 0
t$perf-norm:sp_reserve_write_off 9006 9006 0 0.00 0 12252 13 0 0
t$perf-norm:sp_supplier_invoice 4954 4954 0 0.00 0 11306 25 0 0
t$perf-norm:sp_supplier_order 4943 4943 0 0.00 0 2716 13 0 0
t$perf-norm:srv_aggregate_perf_data 93 93 0 0.00 0 108 5 0 0
t$perf-norm:srv_fill_mon_cache_memory 54 54 0 0.00 0 1648 36 0 0
t$perf-norm:srv_make_invnt_saldo 425 425 0 0.00 0 473 6 0 0
t$perf-norm:srv_make_money_saldo 624 624 0 0.00 0 2661 9 0 0
t$perf-norm:srv_recalc_idx_stat 3 3 0 0.00 2 4 3 0 0
v_add_invoice_to_stock 8944 8760 184 2.05 0 4893 17 0 184
v_all_customers 34508 34508 0 0.00 0 29 1 0 0
v_all_suppliers 28076 28076 0 0.00 0 240 1 0 0
v_all_wares 37132 37132 0 0.00 0 22 1 0 0
v_cancel_adding_invoice 726 726 0 0.00 0 9665 21 0 0
v_cancel_client_order 3280 3280 0 0.00 0 2684 5 0 0
v_cancel_customer_prepayment 1128 1128 0 0.00 0 2591 8 0 0
v_cancel_customer_reserve 1164 1164 0 0.00 0 3702 8 0 0
v_cancel_payment_to_supplier 752 752 0 0.00 0 477 5 0 0
v_cancel_supplier_invoice 706 686 20 2.83 0 2258 14 0 20
v_cancel_supplier_order 744 744 0 0.00 0 410 5 0 0
v_cancel_write_off 1724 1724 0 0.00 0 927 14 0 0
v_max_id_clo_ord 4941 4941 0 0.00 0 470 1 0 0
v_max_id_clo_res 909 909 0 0.00 0 2093 11 0 0
v_max_id_ord_sup 4953 4953 0 0.00 0 5040 6 0 0
v_max_non_paid_invoice 1130 1130 0 0.00 0 134 2 0 0
v_max_non_paid_realizn 3126 3126 0 0.00 0 6640 5 0 0
v_min_id_clo_ord 4940 4940 0 0.00 0 3787 11 0 0
v_min_id_clo_res 909 909 0 0.00 0 4687 13 0 0
v_min_id_ord_sup 4953 4953 0 0.00 0 4813 7 0 0
v_min_non_paid_invoice 5275 5275 0 0.00 0 9039 13 0 0
v_min_non_paid_realizn 6441 6441 0 0.00 0 5522 11 0 0
v_our_firm 9254 9254 0 0.00 0 28 1 0 0
v_reserve_write_off 18012 18012 0 0.00 0 8934 7 0 0
x_lock_depdocs_on_canc_invoice 9219 9219 0 0.00 0 15664 137 0 0
x_lock_depdocs_on_canc_sup_ord 372 372 0 0.00 0 5637 314 0 0
x_make_qstorno_1000_1200 4943 4943 0 0.00 1 46913 1184 0 0
x_make_qstorno_1200_2000 4954 4954 0 0.00 2 77026 2996 0 0
x_make_qstorno_2100_3300 415398 415398 0 0.00 0 84356 190 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 28-02-2024 10:09:40 to 28-02-2024 10:09:44.

Memory consumption, metadata cache, attachments activity 

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


Page cache type: shared, buffers: 1000000 for all connections, with total size: 8192000000
measurement_dts measurement duration ms page cache memo used memo used, total memo allocated, total metadata cache metadata cache percent of total total attachments cnt active attachments cnt running statements cnt stalled statements cnt memo used by attachments memo used by transactions memo used by statements
08:07:52 1126 8192000000 8955522848 9017421824 7898400 0.096 4 2 4 0 8058912 89024 71488
08:08:55 30289 8192000000 9721173520 10019475456 795751296 8.853 100 81 160 0 822463584 7871056 18841232
08:10:28 23388 8192000000 9770372784 10077523968 835617728 9.256 100 88 174 1 867157056 10997632 20541696
08:12:01 15991 8192000000 9797210864 10116030464 863485584 9.535 100 80 160 0 900016416 17964400 18566432
08:13:25 13608 8192000000 9862951120 10194550784 911326400 10.010 100 86 172 1 968600352 38063344 19210608
08:14:43 5215 8192000000 9908264736 10252857344 947427200 10.366 100 89 176 1 1024455888 57777056 19251632
08:15:53 5739 8192000000 9943690544 10295664640 981497152 10.699 100 80 160 0 1055971632 58079968 16394512
08:17:00 3125 8192000000 9988941984 10347294720 1007929248 10.955 100 80 159 0 1101295856 77690896 15675712
08:18:07 1928 8192000000 9990163344 10362978304 1032415056 11.192 100 75 145 3 1105115024 58422880 14277088
08:19:11 1863 8192000000 10037769248 10410672128 1056012864 11.418 100 89 177 0 1148038624 74063168 17962592
08:20:15 858 8192000000 10030809392 10406486016 1066991184 11.523 100 87 175 0 1138413104 53750000 17671920
08:21:18 1912 8192000000 10048682336 10434490368 1072972048 11.580 100 76 153 0 1158324048 69727760 15624240
08:22:21 4602 8192000000 10014015536 10408480768 1075369968 11.603 100 46 93 1 1132872688 48410576 9092144
08:23:27 3773 8192000000 10013078112 10406539264 1084059040 11.686 100 37 70 1 1125447104 34002080 7385984
08:24:32 54286 8192000000 10008662432 10404524032 1088083232 11.724 100 39 76 1 1114728272 18652112 7992928
08:26:27 2573 8192000000 10020369520 10416562176 1092445168 11.766 100 52 100 2 1134939424 31208240 11286016
08:27:33 7221 8192000000 9998397680 10414505984 1092778032 11.769 100 14 28 0 1124146528 28471280 2897216
08:28:44 11695 8192000000 10044633344 10443116544 1104074832 11.876 100 57 115 2 1161010176 44000752 12934592
08:30:05 96105 8192000000 10059354128 10471165952 1083242432 11.678 97 45 90 1 1151837264 59960032 8634800
08:32:49 17674 8192000000 10084236016 10486165504 1084223440 11.688 96 50 99 0 1172073856 77416112 10434304
08:34:09 20075 8192000000 10102139744 10509434880 1093480848 11.776 98 50 100 0 1184191824 79775648 10935328
08:35:33 23319 8192000000 10107233600 10516381696 1096991920 11.809 99 40 80 0 1210544064 104579136 8973008
08:37:09 12869 8192000000 10165043232 10573099008 1112901664 11.960 98 55 110 0 1256773728 131863088 12008976
08:38:25 8889 8192000000 10194063808 10597965824 1121314288 12.039 99 56 111 0 1290436544 156926096 12196160
08:39:40 3666 8192000000 10198500672 10607902720 1124230048 12.067 100 48 95 0 1308396224 173197344 10968832
08:40:52 19544 8192000000 10238656416 10644246528 1110198512 11.934 99 62 124 0 1335798416 212257008 13342896
08:42:18 2689 8192000000 10206702544 10605076480 1120437104 12.031 100 62 119 0 1312226128 178586096 13202928
08:43:33 5844 8192000000 10237153632 10642214912 1121137952 12.038 100 56 110 0 1341073536 207129104 12806480
08:44:46 3262 8192000000 10283464800 10679463936 1107922336 11.913 99 73 146 0 1384338096 260081072 16334688
08:45:56 3079 8192000000 10311995936 10702336000 1126871568 12.092 100 83 165 1 1411707488 265975600 18860320
08:47:02 2865 8192000000 10343734176 10767986688 1138427856 12.201 100 78 156 0 1465918960 309346752 18144352
08:48:15 4319 8192000000 10326120544 10727350272 1149450112 12.304 100 77 154 3 1420158912 253500400 17208400
08:49:22 10339 8192000000 10328698752 10737926144 1155961168 12.365 100 61 122 0 1431807296 262227536 13618592
08:50:37 12659 8192000000 10327585776 10765651968 1148336848 12.294 100 32 64 1 1428708752 271428528 8943376
08:51:55 27419 8192000000 10336139264 10823630848 1148407168 12.295 100 23 46 0 1417689552 263379296 5903088
08:53:30 25354 8192000000 10186321968 10707890176 1138943824 12.206 100 15 30 0 1308783264 166276336 3563104
08:54:57 47179 8192000000 10064644672 10506027008 1138794160 12.204 100 25 50 0 1181201072 37223232 5183680
08:56:52 26810 8192000000 10108672224 10533179392 1139314320 12.209 100 45 87 1 1185644480 36529168 9800992
08:58:28 142778 8192000000 10068140720 10511302656 1134779552 12.166 100 25 50 0 1178638416 38593216 5265648
09:01:53 63647 8192000000 10112435136 10560557056 1135091440 12.169 99 24 48 0 1193137152 52254048 5791664
09:03:58 19538 8192000000 10117651904 10575802368 1146455328 12.276 100 43 84 0 1223995824 69420384 8120112
09:05:49 75952 8192000000 10185652656 10629070848 1130964944 12.130 97 28 56 0 1258000656 120344320 6691392
09:08:24 37941 8192000000 10229199936 10690162688 1155727520 12.363 99 22 44 0 1313677936 153185664 4764752
09:10:03 44640 8192000000 10202252608 10735083520 1156150112 12.367 99 32 62 1 1333381600 169953920 7277568
09:11:52 58117 8192000000 10149984080 10604777472 1152148672 12.330 99 21 40 0 1236068016 78745952 5173392
09:14:01 89370 8192000000 10087276464 10514604032 1103707408 11.873 96 19 38 0 1148159312 40350560 4101344
09:16:33 43614 8192000000 10096464624 10576314368 1130983312 12.131 99 24 48 0 1213610896 77695744 4931840
09:18:30 53681 8192000000 10081852544 10586431488 1068160160 11.535 95 27 54 0 1159461600 85839520 5461920
09:20:25 55270 8192000000 10060081776 10484408320 1094763840 11.788 97 23 44 0 1121824320 22904912 4155568
09:22:20 80657 8192000000 10079631264 10533789696 1088402640 11.727 97 48 97 0 1171463168 72670944 10389584
09:24:46 11534 8192000000 10096323072 10544697344 1093010880 11.771 98 33 67 0 1182214496 82661600 6542016
09:26:00 35409 8192000000 9986372960 10439147520 1033416176 11.201 94 14 28 0 1069491344 33096368 2978800
09:27:39 61103 8192000000 10021517360 10456068096 1052144496 11.381 96 20 40 0 1090758928 34434848 4179584
09:30:20 64350 8192000000 10016594608 10477670400 1055204672 11.411 96 10 20 0 1111090016 53521312 2364032
09:32:25 43495 8192000000 10044998784 10508386304 1069231040 11.545 98 20 40 0 1154216944 80564720 4421184
09:34:09 43308 8192000000 10045822368 10477068288 1090052864 11.743 99 27 54 0 1150671984 54706192 5912928
09:36:00 72621 8192000000 10066613072 10506911744 1105699184 11.892 100 13 26 0 1173203552 64691632 2812736
09:38:16 120110 8192000000 10112544544 10597412864 1109760736 11.930 98 25 50 0 1184347568 70084624 4502208
09:41:24 53539 8192000000 10055720736 10511589376 1094808288 11.788 97 16 32 0 1166268576 68075792 3384496
09:43:19 82869 8192000000 10150674416 10581647360 1128844608 12.110 99 34 68 0 1194569536 58555856 7169072
09:45:43 51627 8192000000 10074299984 10555199488 1133312752 12.153 100 9 18 0 1188639856 53267728 2059376
09:47:44 38851 8192000000 10060413872 10524332032 1137430464 12.191 100 3 6 0 1172704688 34767936 506288
09:49:29 52122 8192000000 10053051904 10499923968 1120312608 12.030 98 13 26 0 1153009632 30200176 2496848
09:51:22 59837 8192000000 10082964800 10536460288 1122855216 12.054 98 14 28 0 1169543888 43732160 2956512
09:53:25 49856 8192000000 10089887056 10551205888 1102583648 11.862 96 27 54 0 1171304464 62865456 5855360
09:55:21 46611 8192000000 10089160368 10565984256 1137200272 12.189 100 21 42 0 1206013184 64414832 4398080
09:57:08 18647 8192000000 10078550160 10529140736 1114722608 11.977 98 35 70 0 1162236528 40436096 7077824
09:58:37 87550 8192000000 10064945872 10510594048 1104381824 11.879 97 22 44 0 1148012736 38893344 4737568
10:01:12 116961 8192000000 10050281696 10482429952 999606464 10.875 89 27 54 0 1049251584 44377120 5268000
10:04:12 62460 8192000000 10047145312 10470752256 1105559072 11.890 99 37 74 0 1141120144 28213824 7347248
10:06:16 54342 8192000000 10096075648 10570211328 1127357024 12.096 100 7 14 0 1198001328 68614304 2030000

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


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

Exceptions occured during test was in run

FB_MNEMONA CNT UNIT FB_GDSCODE
except 92 v_add_invoice_to_stock 335544517
except 10 v_cancel_supplier_invoice 335544517

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

Content of mon$database and FB version 


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


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

Database statistics 

 
Database "/home/bases/oltp40-etalone.fdb" 
Gstat execution time Wed Feb 28 10:10:04 2024 
 
Database header page information: 
    Flags            0 
    Generation        92525 
    System Change Number    0 
    Page size        8192 
    ODS version        13.0 
    Oldest transaction    176091 
    Oldest active        177126 
    Oldest snapshot        177126 
    Next transaction    177127 
    Sequence number        0 
    Next attachment ID    701 
    Implementation        HW=AMD/Intel/x64 little-endian OS=Linux CC=gcc 
    Shadow count        0 
    Page buffers        0 
    Next header page    0 
    Database dialect    3 
    Creation date        Apr 30, 2020 7:30:08 
    Attributes        force write 
 
    Variable header data: 
    Database GUID:    {58978C10-B735-40F5-8B7D-F7A1956E782B} 
    Sweep interval:        0 
    *END* 
 
 
Database file sequence: 
File /home/bases/oltp40-etalone.fdb is the only file 
 
Analyzing database pages ... 
AGENTS (150) 
    Primary pointer page: 524, Index root page: 525 
    Total formats: 1, used formats: 1 
    Average record length: 33.60, total records: 50 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 344.00, compression ratio: 10.24 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 31% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 1 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index AGENTS_ID_DESC (2) 
    Root page: 1504333, depth: 1, leaf buckets: 1, nodes: 50 
    Average node length: 11.82, total dup: 0, max dup: 0 
    Average key length: 10.80, compression ratio: 0.83 
    Average prefix length: 1.18, average data length: 7.82 
    Clustering factor: 1, ratio: 0.02 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index AGENTS_IS_OUR_FIRM (4) 
    Root page: 1504335, depth: 1, leaf buckets: 1, nodes: 50 
    Average node length: 3.08, total dup: 48, max dup: 48 
    Average key length: 2.04, compression ratio: 0.50 
    Average prefix length: 0.96, average data length: 0.06 
    Clustering factor: 1, ratio: 0.02 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index AGENTS_IS_SUPPLIER (3) 
    Root page: 1504334, depth: 1, leaf buckets: 1, nodes: 50 
    Average node length: 3.08, total dup: 48, max dup: 44 
    Average key length: 2.04, compression ratio: 0.54 
    Average prefix length: 1.04, average data length: 0.06 
    Clustering factor: 1, ratio: 0.02 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index AGENTS_NAME_UNQ (1) 
    Root page: 1504332, depth: 1, leaf buckets: 1, nodes: 50 
    Average node length: 17.20, total dup: 0, max dup: 0 
    Average key length: 15.88, compression ratio: 0.92 
    Average prefix length: 1.42, average data length: 13.20 
    Clustering factor: 1, ratio: 0.02 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PK_AGENTS (0) 
    Root page: 1504331, depth: 1, leaf buckets: 1, nodes: 50 
    Average node length: 11.82, total dup: 0, max dup: 0 
    Average key length: 10.80, compression ratio: 0.83 
    Average prefix length: 1.18, average data length: 7.82 
    Clustering factor: 1, ratio: 0.02 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
BUSINESS_OPS (154) 
    Primary pointer page: 532, Index root page: 533 
    Total formats: 1, used formats: 1 
    Average record length: 108.20, total records: 20 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1235.00, compression ratio: 11.41 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 31% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 1 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index BO_UNIT_UNQ (1) 
    Root page: 1504264, depth: 1, leaf buckets: 1, nodes: 20 
    Average node length: 18.25, total dup: 0, max dup: 0 
    Average key length: 17.20, compression ratio: 1.24 
    Average prefix length: 7.05, average data length: 14.25 
    Clustering factor: 1, ratio: 0.05 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index BUSINESS_OPS_PREDICT_PRIOR (3) 
    Root page: 1504266, depth: 1, leaf buckets: 1, nodes: 20 
    Average node length: 5.40, total dup: 0, max dup: 0 
    Average key length: 4.35, compression ratio: 0.67 
    Average prefix length: 1.20, average data length: 1.70 
    Clustering factor: 1, ratio: 0.05 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index BUSINESS_OPS_RND_WGTH (2) 
    Root page: 1504265, depth: 1, leaf buckets: 1, nodes: 20 
    Average node length: 4.30, total dup: 6, max dup: 3 
    Average key length: 3.25, compression ratio: 0.72 
    Average prefix length: 1.35, average data length: 1.00 
    Clustering factor: 1, ratio: 0.05 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index RDB$1 (0) 
    Root page: 1504263, depth: 1, leaf buckets: 1, nodes: 20 
    Average node length: 5.20, total dup: 0, max dup: 0 
    Average key length: 4.15, compression ratio: 0.65 
    Average prefix length: 1.10, average data length: 1.60 
    Clustering factor: 1, ratio: 0.05 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
DOC_DATA (139) 
    Primary pointer page: 502, Index root page: 503 
    Total formats: 1, used formats: 1 
    Average record length: 47.72, total records: 7715530 
    Average version length: 48.16, total versions: 35065, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 64.00, compression ratio: 1.34 
    Pointer pages: 55, data page slots: 88576 
    Data pages: 88576, average fill: 70% 
    Primary pages: 88575, secondary pages: 1, swept pages: 47109 
    Empty pages: 26, full pages: 64837 
    Fill distribution: 
     0 - 19% = 34 
    20 - 39% = 42 
    40 - 59% = 1130 
    60 - 79% = 87367 
    80 - 99% = 3 
 
    Index DOC_DATA_DOC_WARE_UNQ (0) 
    Root page: 1510636, depth: 3, leaf buckets: 23310, nodes: 7715530 
    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: 1680229, ratio: 0.22 
    Fill distribution: 
         0 - 19% = 361 
        20 - 39% = 1971 
        40 - 59% = 4116 
        60 - 79% = 2439 
        80 - 99% = 14423 
 
    Index DOC_DATA_ID_DESC (1) 
    Root page: 1528140, depth: 3, leaf buckets: 13512, nodes: 7715530 
    Average node length: 11.20, total dup: 0, max dup: 0 
    Average key length: 8.21, compression ratio: 1.10 
    Average prefix length: 3.78, average data length: 5.22 
    Clustering factor: 1502969, ratio: 0.19 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 1612 
        40 - 59% = 2073 
        60 - 79% = 1140 
        80 - 99% = 8687 
 
    Index FK_DOC_DATA_DOC_LIST (2) 
    Root page: 1546735, depth: 3, leaf buckets: 8329, nodes: 7715530 
    Average node length: 6.61, total dup: 5782664, max dup: 49 
    Average key length: 3.62, compression ratio: 2.49 
    Average prefix length: 7.63, average data length: 1.37 
    Clustering factor: 1496029, ratio: 0.19 
    Fill distribution: 
         0 - 19% = 127 
        20 - 39% = 1015 
        40 - 59% = 1368 
        60 - 79% = 930 
        80 - 99% = 4889 
 
DOC_LIST (138) 
    Primary pointer page: 500, Index root page: 501 
    Total formats: 1, used formats: 1 
    Average record length: 57.07, total records: 2224048 
    Average version length: 58.87, total versions: 16892, max versions: 2 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 84.00, compression ratio: 1.47 
    Pointer pages: 18, data page slots: 28512 
    Data pages: 28512, average fill: 72% 
    Primary pages: 28510, secondary pages: 2, swept pages: 13973 
    Empty pages: 2, full pages: 17792 
    Fill distribution: 
     0 - 19% = 9 
    20 - 39% = 40 
    40 - 59% = 830 
    60 - 79% = 27609 
    80 - 99% = 24 
 
    Index DOC_LIST_ID_DESC (1) 
    Root page: 1541152, depth: 3, leaf buckets: 4548, nodes: 2224048 
    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: 678671, ratio: 0.31 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 944 
        40 - 59% = 838 
        60 - 79% = 742 
        80 - 99% = 2024 
 
    Index DOC_LIST_WORKER_OPTYPE (2) 
    Root page: 1544398, depth: 3, leaf buckets: 2421, nodes: 2224881 
    Average node length: 4.97, total dup: 2223982, max dup: 17815 
    Average key length: 2.01, compression ratio: 4.47 
    Average prefix length: 8.99, average data length: 0.01 
    Clustering factor: 1264594, ratio: 0.57 
    Fill distribution: 
         0 - 19% = 3 
        20 - 39% = 200 
        40 - 59% = 1439 
        60 - 79% = 546 
        80 - 99% = 233 
 
    Index FK_DOC_LIST_AGENTS (3) 
    Root page: 1545933, depth: 3, leaf buckets: 1766, nodes: 2224048 
    Average node length: 4.97, total dup: 2223998, max dup: 130350 
    Average key length: 2.01, compression ratio: 4.48 
    Average prefix length: 8.99, average data length: 0.01 
    Clustering factor: 1058314, ratio: 0.48 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 7 
        40 - 59% = 614 
        60 - 79% = 55 
        80 - 99% = 1090 
 
    Index PK_DOC_LIST (0) 
    Root page: 1538209, depth: 3, leaf buckets: 4354, nodes: 2224048 
    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: 678671, ratio: 0.31 
    Fill distribution: 
         0 - 19% = 97 
        20 - 39% = 627 
        40 - 59% = 634 
        60 - 79% = 852 
        80 - 99% = 2144 
 
DOC_STATES (149) 
    Primary pointer page: 522, Index root page: 523 
    Total formats: 1, used formats: 1 
    Average record length: 67.50, total records: 4 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 650.00, compression ratio: 9.63 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 4% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index DOC_STATES_MCODE_UNQ (1) 
    Root page: 1504337, depth: 1, leaf buckets: 1, nodes: 4 
    Average node length: 17.75, total dup: 0, max dup: 0 
    Average key length: 16.50, compression ratio: 1.08 
    Average prefix length: 4.00, average data length: 13.75 
    Clustering factor: 1, ratio: 0.25 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index DOC_STATES_NAME_UNQ (2) 
    Root page: 1504338, depth: 1, leaf buckets: 1, nodes: 4 
    Average node length: 33.25, total dup: 0, max dup: 0 
    Average key length: 32.00, compression ratio: 0.99 
    Average prefix length: 2.50, average data length: 29.25 
    Clustering factor: 1, ratio: 0.25 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PK_DOC_STATES (0) 
    Root page: 1504336, depth: 1, leaf buckets: 1, nodes: 4 
    Average node length: 4.75, total dup: 0, max dup: 0 
    Average key length: 3.50, compression ratio: 0.86 
    Average prefix length: 1.50, average data length: 1.50 
    Clustering factor: 1, ratio: 0.25 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
FB_ERRORS (155) 
    Primary pointer page: 534, Index root page: 535 
    Total formats: 2, used formats: 2 
    Average record length: 57.88, total records: 2182 
    Average version length: 79.61, total versions: 757, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 270.43, compression ratio: 4.67 
    Pointer pages: 1, data page slots: 40 
    Data pages: 40, average fill: 72% 
    Primary pages: 39, secondary pages: 1, swept pages: 0 
    Empty pages: 4, full pages: 34 
    Fill distribution: 
     0 - 19% = 5 
    20 - 39% = 0 
    40 - 59% = 1 
    60 - 79% = 22 
    80 - 99% = 12 
 
    Index FB_ERRORS_GDS_CODE (0) 
    Root page: 398, depth: 2, leaf buckets: 2, nodes: 2182 
    Average node length: 4.40, total dup: 756, max dup: 1 
    Average key length: 2.67, compression ratio: 1.87 
    Average prefix length: 4.33, average data length: 0.67 
    Clustering factor: 1518, ratio: 0.70 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 0 
        40 - 59% = 1 
        60 - 79% = 1 
        80 - 99% = 0 
 
INVNT_SALDO (145) 
    Primary pointer page: 514, Index root page: 515 
    Total formats: 2, used formats: 1 
    Average record length: 83.27, total records: 400 
    Average version length: 32.80, total versions: 1597, max versions: 4 
    Average fragment length: 2.00, total fragments: 6, max fragments: 1 
    Average unpacked length: 104.00, compression ratio: 1.25 
    Pointer pages: 1, data page slots: 24 
    Data pages: 24, average fill: 61% 
    Primary pages: 7, secondary pages: 17, swept pages: 0 
    Empty pages: 7, full pages: 14 
    Fill distribution: 
     0 - 19% = 9 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 15 
 
    Index PK_INVNT_SALDO (0) 
    Root page: 1510371, depth: 1, leaf buckets: 1, nodes: 400 
    Average node length: 11.22, total dup: 0, max dup: 0 
    Average key length: 10.22, compression ratio: 0.88 
    Average prefix length: 1.78, average data length: 7.22 
    Clustering factor: 326, ratio: 0.81 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 0 
        40 - 59% = 1 
        60 - 79% = 0 
        80 - 99% = 0 
 
INVNT_TURNOVER_LOG (153) 
    Primary pointer page: 530, Index root page: 531 
    Total formats: 1, used formats: 1 
    Average record length: 18.87, total records: 71043 
    Average version length: 68.27, total versions: 59223, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 88.00, compression ratio: 4.66 
    Pointer pages: 7, data page slots: 3808 
    Data pages: 1552, average fill: 61% 
    Primary pages: 1551, secondary pages: 1, swept pages: 87 
    Empty pages: 236, full pages: 903 
    Fill distribution: 
     0 - 19% = 363 
    20 - 39% = 125 
    40 - 59% = 118 
    60 - 79% = 156 
    80 - 99% = 790 
 
    Index INVNT_TURNOVER_LOG_WARE_DD_ID (0) 
    Root page: 1703516, depth: 3, leaf buckets: 206, nodes: 71043 
    Average node length: 13.22, total dup: 3079, max dup: 1 
    Average key length: 10.98, compression ratio: 2.46 
    Average prefix length: 18.97, average data length: 8.03 
    Clustering factor: 55776, ratio: 0.79 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 8 
        40 - 59% = 130 
        60 - 79% = 55 
        80 - 99% = 13 
 
MONEY_SALDO (141) 
    Primary pointer page: 506, Index root page: 507 
    Total formats: 1, used formats: 1 
    Average record length: 15.20, total records: 49 
    Average version length: 9.00, total versions: 145, max versions: 7 
    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: 1 
    Data pages: 1, average fill: 69% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 1 
    80 - 99% = 0 
 
    Index PK_MONEY_SALDO (0) 
    Root page: 1510383, depth: 1, leaf buckets: 1, nodes: 49 
    Average node length: 11.82, total dup: 0, max dup: 0 
    Average key length: 10.80, compression ratio: 0.83 
    Average prefix length: 1.18, average data length: 7.82 
    Clustering factor: 1, ratio: 0.02 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
MONEY_TURNOVER_LOG (140) 
    Primary pointer page: 504, Index root page: 505 
    Total formats: 1, used formats: 1 
    Average record length: 14.51, total records: 1375 
    Average version length: 42.95, total versions: 1161, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 58.00, compression ratio: 4.00 
    Pointer pages: 1, data page slots: 48 
    Data pages: 30, average fill: 47% 
    Primary pages: 29, secondary pages: 1, swept pages: 1 
    Empty pages: 11, full pages: 13 
    Fill distribution: 
     0 - 19% = 14 
    20 - 39% = 1 
    40 - 59% = 0 
    60 - 79% = 3 
    80 - 99% = 12 
 
    Index MONEY_TURNOVER_LOG_AGENT_OPTYPE (0) 
    Root page: 90151, depth: 2, leaf buckets: 3, nodes: 1375 
    Average node length: 4.38, total dup: 1277, max dup: 130 
    Average key length: 2.77, compression ratio: 6.87 
    Average prefix length: 18.30, average data length: 0.70 
    Clustering factor: 722, ratio: 0.53 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 2 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
MON_CACHE_MEMORY (165) 
    Primary pointer page: 555, Index root page: 556 
    Total formats: 2, used formats: 1 
    Average record length: 97.80, total records: 71 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 112.00, compression ratio: 1.15 
    Pointer pages: 1, data page slots: 2 
    Data pages: 2, average fill: 50% 
    Primary pages: 2, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 1 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 1 
    40 - 59% = 0 
    60 - 79% = 1 
    80 - 99% = 0 
 
    Index PK_MON_CACHE_MEMORY (0) 
    Root page: 1504238, depth: 1, leaf buckets: 1, nodes: 71 
    Average node length: 11.70, total dup: 0, max dup: 0 
    Average key length: 10.69, compression ratio: 0.84 
    Average prefix length: 1.30, average data length: 7.70 
    Clustering factor: 2, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
MON_LOG (162) 
    Primary pointer page: 548, Index root page: 549 
    Total formats: 2, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index MON_LOG_DTS (4) 
    Root page: 1504251, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index MON_LOG_GDSCODE (2) 
    Root page: 1504249, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index MON_LOG_ROWSET_DESC (1) 
    Root page: 1504248, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index MON_LOG_UNIT (3) 
    Root page: 1504250, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PK_MON_LOG (0) 
    Root page: 1504247, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
MON_LOG_TABLE_STATS (163) 
    Primary pointer page: 550, Index root page: 551 
    Total formats: 2, used formats: 1 
    Average record length: 67.13, total records: 30 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 611.00, compression ratio: 9.10 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 31% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 1 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index MON_LOG_TABLE_STATS_DTS (4) 
    Root page: 1504246, depth: 1, leaf buckets: 1, nodes: 30 
    Average node length: 3.50, total dup: 23, max dup: 4 
    Average key length: 2.47, compression ratio: 3.24 
    Average prefix length: 7.53, average data length: 0.47 
    Clustering factor: 1, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index MON_LOG_TABLE_STATS_GDSCODE (2) 
    Root page: 1504244, depth: 1, leaf buckets: 1, nodes: 30 
    Average node length: 2.00, total dup: 29, max dup: 29 
    Average key length: 1.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 1, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index MON_LOG_TABLE_STATS_ROWSET (1) 
    Root page: 1504243, depth: 1, leaf buckets: 1, nodes: 30 
    Average node length: 3.33, total dup: 29, max dup: 29 
    Average key length: 2.30, compression ratio: 3.91 
    Average prefix length: 8.70, average data length: 0.30 
    Clustering factor: 1, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index MON_LOG_TABLE_STATS_TN_UNIT (3) 
    Root page: 1504245, depth: 1, leaf buckets: 1, nodes: 30 
    Average node length: 12.90, total dup: 0, max dup: 0 
    Average key length: 11.87, compression ratio: 1.42 
    Average prefix length: 7.63, average data length: 9.20 
    Clustering factor: 1, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PK_MON_LOG_TABLE_STATS (0) 
    Root page: 1504242, depth: 1, leaf buckets: 1, nodes: 30 
    Average node length: 8.37, total dup: 0, max dup: 0 
    Average key length: 7.33, compression ratio: 1.23 
    Average prefix length: 4.63, average data length: 4.37 
    Clustering factor: 1, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
OPTYPES (136) 
    Primary pointer page: 496, Index root page: 497 
    Total formats: 2, used formats: 1 
    Average record length: 67.56, total records: 9 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 386.00, compression ratio: 5.71 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 9% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index OPTYPES_MCODE_UNQ (1) 
    Root page: 1544827, depth: 1, leaf buckets: 1, nodes: 9 
    Average node length: 8.56, total dup: 0, max dup: 0 
    Average key length: 6.89, compression ratio: 0.73 
    Average prefix length: 0.44, average data length: 4.56 
    Clustering factor: 1, ratio: 0.11 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PK_OPTYPES (0) 
    Root page: 1544826, depth: 1, leaf buckets: 1, nodes: 9 
    Average node length: 6.11, total dup: 0, max dup: 0 
    Average key length: 5.00, compression ratio: 0.60 
    Average prefix length: 0.89, average data length: 2.11 
    Clustering factor: 1, ratio: 0.11 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
PDISTR (146) 
    Primary pointer page: 516, Index root page: 517 
    Total formats: 1, used formats: 1 
    Average record length: 36.71, total records: 809072 
    Average version length: 37.93, total versions: 22073, max versions: 3 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 54.00, compression ratio: 1.47 
    Pointer pages: 6, data page slots: 8712 
    Data pages: 8712, average fill: 64% 
    Primary pages: 8708, secondary pages: 4, swept pages: 3322 
    Empty pages: 37, full pages: 4787 
    Fill distribution: 
     0 - 19% = 81 
    20 - 39% = 95 
    40 - 59% = 997 
    60 - 79% = 7510 
    80 - 99% = 29 
 
    Index PDISTR_AGENT_ID (2) 
    Root page: 1509330, depth: 2, leaf buckets: 873, nodes: 798621 
    Average node length: 4.88, total dup: 798572, max dup: 146941 
    Average key length: 2.01, compression ratio: 4.48 
    Average prefix length: 8.99, average data length: 0.01 
    Clustering factor: 90449, ratio: 0.11 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 146 
        40 - 59% = 459 
        60 - 79% = 176 
        80 - 99% = 92 
 
    Index PDISTR_SNDOP_RCVOP_SNDID_ASC (0) 
    Root page: 1508635, depth: 3, leaf buckets: 1018, nodes: 798621 
    Average node length: 5.89, total dup: 711192, max dup: 42 
    Average key length: 3.02, compression ratio: 7.29 
    Average prefix length: 21.09, average data length: 0.91 
    Clustering factor: 159497, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 90 
        40 - 59% = 622 
        60 - 79% = 86 
        80 - 99% = 220 
 
    Index PDISTR_SNDOP_RCVOP_SNDID_DESC (1) 
    Root page: 1509209, depth: 3, leaf buckets: 1048, nodes: 798621 
    Average node length: 5.89, total dup: 711192, max dup: 42 
    Average key length: 3.02, compression ratio: 7.29 
    Average prefix length: 21.09, average data length: 0.91 
    Clustering factor: 161421, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 132 
        40 - 59% = 633 
        60 - 79% = 77 
        80 - 99% = 205 
 
    Index PDISTR_WORKER_SND_ID (3) 
    Root page: 1510200, depth: 3, leaf buckets: 1139, nodes: 798621 
    Average node length: 5.97, total dup: 711192, max dup: 42 
    Average key length: 3.10, compression ratio: 5.49 
    Average prefix length: 16.01, average data length: 0.99 
    Clustering factor: 154133, ratio: 0.19 
    Fill distribution: 
         0 - 19% = 3 
        20 - 39% = 255 
        40 - 59% = 592 
        60 - 79% = 205 
        80 - 99% = 84 
 
PERF_AGG (158) 
    Primary pointer page: 540, Index root page: 541 
    Total formats: 1, used formats: 1 
    Average record length: 62.76, total records: 5446 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 3.56, total fragments: 36, max fragments: 1 
    Average unpacked length: 379.00, compression ratio: 6.04 
    Pointer pages: 1, data page slots: 88 
    Data pages: 88, average fill: 61% 
    Primary pages: 78, secondary pages: 10, swept pages: 57 
    Empty pages: 5, full pages: 61 
    Fill distribution: 
     0 - 19% = 14 
    20 - 39% = 1 
    40 - 59% = 0 
    60 - 79% = 73 
    80 - 99% = 0 
 
    Index PERF_AGG_UNQ (1) 
    Root page: 1504260, depth: 2, leaf buckets: 7, nodes: 5446 
    Average node length: 5.49, total dup: 0, max dup: 0 
    Average key length: 3.59, compression ratio: 10.02 
    Average prefix length: 34.39, average data length: 1.55 
    Clustering factor: 5105, ratio: 0.94 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 4 
        60 - 79% = 1 
        80 - 99% = 1 
 
    Index PK_PERF_AGG (0) 
    Root page: 1504255, depth: 2, leaf buckets: 10, nodes: 5446 
    Average node length: 11.11, total dup: 0, max dup: 0 
    Average key length: 9.21, compression ratio: 0.98 
    Average prefix length: 2.79, average data length: 6.21 
    Clustering factor: 172, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 1 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 7 
 
PERF_ESTIMATED (280) 
    Primary pointer page: 399, Index root page: 434 
    Total formats: 1, used formats: 1 
    Average record length: 39.05, total records: 80863 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 48.00, compression ratio: 1.23 
    Pointer pages: 1, data page slots: 840 
    Data pages: 840, average fill: 66% 
    Primary pages: 840, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 839 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 1 
    40 - 59% = 0 
    60 - 79% = 839 
    80 - 99% = 0 
 
    Index PK_PERF_ESTIMATED (0) 
    Root page: 34919, depth: 2, leaf buckets: 104, nodes: 80863 
    Average node length: 10.16, total dup: 0, max dup: 0 
    Average key length: 8.17, compression ratio: 1.10 
    Average prefix length: 3.83, average data length: 5.17 
    Clustering factor: 3197, ratio: 0.04 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 2 
        60 - 79% = 0 
        80 - 99% = 101 
 
PERF_ISQL_STAT (156) 
    Primary pointer page: 536, Index root page: 537 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index PERF_ISQL_STAT_TRN (0) 
    Root page: 1504261, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
PERF_LOG (159) 
    Primary pointer page: 542, Index root page: 543 
    Total formats: 1, used formats: 1 
    Average record length: 111.07, total records: 71 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1691.00, compression ratio: 15.22 
    Pointer pages: 1, data page slots: 2 
    Data pages: 2, average fill: 56% 
    Primary pages: 2, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 1 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 1 
    40 - 59% = 0 
    60 - 79% = 1 
    80 - 99% = 0 
 
PERF_SPLIT_0 (281) 
    Primary pointer page: 601, Index root page: 602 
    Total formats: 1, used formats: 1 
    Average record length: 135.92, total records: 210318 
    Average version length: 155.39, total versions: 23072, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 12.48 
    Pointer pages: 8, data page slots: 5880 
    Data pages: 5232, average fill: 85% 
    Primary pages: 5230, secondary pages: 2, swept pages: 2 
    Empty pages: 38, full pages: 5182 
    Fill distribution: 
     0 - 19% = 40 
    20 - 39% = 5 
    40 - 59% = 2 
    60 - 79% = 5 
    80 - 99% = 5180 
 
PERF_SPLIT_1 (282) 
    Primary pointer page: 603, Index root page: 604 
    Total formats: 1, used formats: 1 
    Average record length: 150.50, total records: 151009 
    Average version length: 149.00, total versions: 481, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.27 
    Pointer pages: 7, data page slots: 4280 
    Data pages: 3720, average fill: 84% 
    Primary pages: 3719, secondary pages: 1, swept pages: 4 
    Empty pages: 13, full pages: 3696 
    Fill distribution: 
     0 - 19% = 17 
    20 - 39% = 3 
    40 - 59% = 2 
    60 - 79% = 3 
    80 - 99% = 3695 
 
PERF_SPLIT_2 (283) 
    Primary pointer page: 605, Index root page: 606 
    Total formats: 1, used formats: 1 
    Average record length: 148.95, total records: 147545 
    Average version length: 153.34, total versions: 2332, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.39 
    Pointer pages: 7, data page slots: 4344 
    Data pages: 3680, average fill: 83% 
    Primary pages: 3678, secondary pages: 2, swept pages: 4 
    Empty pages: 46, full pages: 3617 
    Fill distribution: 
     0 - 19% = 49 
    20 - 39% = 8 
    40 - 59% = 1 
    60 - 79% = 5 
    80 - 99% = 3617 
 
PERF_SPLIT_3 (284) 
    Primary pointer page: 607, Index root page: 608 
    Total formats: 1, used formats: 1 
    Average record length: 149.79, total records: 138051 
    Average version length: 153.20, total versions: 1409, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.32 
    Pointer pages: 7, data page slots: 4016 
    Data pages: 3448, average fill: 83% 
    Primary pages: 3446, secondary pages: 2, swept pages: 7 
    Empty pages: 37, full pages: 3380 
    Fill distribution: 
     0 - 19% = 44 
    20 - 39% = 10 
    40 - 59% = 8 
    60 - 79% = 8 
    80 - 99% = 3378 
 
PERF_SPLIT_4 (285) 
    Primary pointer page: 609, Index root page: 610 
    Total formats: 1, used formats: 1 
    Average record length: 150.14, total records: 142335 
    Average version length: 152.44, total versions: 922, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.30 
    Pointer pages: 9, data page slots: 4168 
    Data pages: 3520, average fill: 83% 
    Primary pages: 3518, secondary pages: 2, swept pages: 1 
    Empty pages: 21, full pages: 3491 
    Fill distribution: 
     0 - 19% = 22 
    20 - 39% = 4 
    40 - 59% = 2 
    60 - 79% = 1 
    80 - 99% = 3491 
 
PERF_SPLIT_5 (286) 
    Primary pointer page: 611, Index root page: 612 
    Total formats: 1, used formats: 1 
    Average record length: 151.09, total records: 160856 
    Average version length: 136.70, total versions: 86, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.23 
    Pointer pages: 7, data page slots: 4544 
    Data pages: 3976, average fill: 83% 
    Primary pages: 3976, secondary pages: 0, swept pages: 10 
    Empty pages: 18, full pages: 3946 
    Fill distribution: 
     0 - 19% = 22 
    20 - 39% = 4 
    40 - 59% = 1 
    60 - 79% = 4 
    80 - 99% = 3945 
 
PERF_SPLIT_6 (287) 
    Primary pointer page: 613, Index root page: 614 
    Total formats: 1, used formats: 1 
    Average record length: 150.81, total records: 139574 
    Average version length: 137.17, total versions: 131, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.25 
    Pointer pages: 6, data page slots: 3720 
    Data pages: 3456, average fill: 83% 
    Primary pages: 3454, secondary pages: 2, swept pages: 8 
    Empty pages: 21, full pages: 3418 
    Fill distribution: 
     0 - 19% = 29 
    20 - 39% = 4 
    40 - 59% = 4 
    60 - 79% = 2 
    80 - 99% = 3417 
 
PERF_SPLIT_7 (288) 
    Primary pointer page: 615, Index root page: 616 
    Total formats: 1, used formats: 1 
    Average record length: 145.22, total records: 156709 
    Average version length: 154.89, total versions: 6360, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.68 
    Pointer pages: 7, data page slots: 5016 
    Data pages: 3872, average fill: 84% 
    Primary pages: 3869, secondary pages: 3, swept pages: 5 
    Empty pages: 19, full pages: 3842 
    Fill distribution: 
     0 - 19% = 21 
    20 - 39% = 2 
    40 - 59% = 4 
    60 - 79% = 3 
    80 - 99% = 3842 
 
PERF_SPLIT_8 (289) 
    Primary pointer page: 617, Index root page: 618 
    Total formats: 1, used formats: 1 
    Average record length: 150.26, total records: 152297 
    Average version length: 152.94, total versions: 967, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.29 
    Pointer pages: 10, data page slots: 4424 
    Data pages: 3768, average fill: 83% 
    Primary pages: 3767, secondary pages: 1, swept pages: 7 
    Empty pages: 23, full pages: 3733 
    Fill distribution: 
     0 - 19% = 27 
    20 - 39% = 4 
    40 - 59% = 2 
    60 - 79% = 3 
    80 - 99% = 3732 
 
PERF_SPLIT_9 (290) 
    Primary pointer page: 619, Index root page: 620 
    Total formats: 1, used formats: 1 
    Average record length: 150.05, total records: 140151 
    Average version length: 151.62, total versions: 699, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.30 
    Pointer pages: 7, data page slots: 3872 
    Data pages: 3448, average fill: 84% 
    Primary pages: 3446, secondary pages: 2, swept pages: 6 
    Empty pages: 9, full pages: 3432 
    Fill distribution: 
     0 - 19% = 13 
    20 - 39% = 0 
    40 - 59% = 1 
    60 - 79% = 2 
    80 - 99% = 3432 
 
PHRASES (143) 
    Primary pointer page: 510, Index root page: 511 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index PHRASES_ID_DESC (3) 
    Root page: 1510376, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PHRASES_NAME (2) 
    Root page: 1510375, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PHRASES_UNQ (1) 
    Root page: 1510374, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PK_PHRASES (0) 
    Root page: 1510373, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
PSTORNED (147) 
    Primary pointer page: 518, Index root page: 519 
    Total formats: 1, used formats: 1 
    Average record length: 52.44, total records: 2075505 
    Average version length: 52.91, total versions: 14455, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 70.00, compression ratio: 1.33 
    Pointer pages: 16, data page slots: 25704 
    Data pages: 25696, average fill: 69% 
    Primary pages: 25680, secondary pages: 16, swept pages: 12219 
    Empty pages: 219, full pages: 22069 
    Fill distribution: 
     0 - 19% = 412 
    20 - 39% = 338 
    40 - 59% = 935 
    60 - 79% = 23894 
    80 - 99% = 117 
 
    Index PSTORNED_RCV_ID (1) 
    Root page: 1506208, depth: 3, leaf buckets: 2564, nodes: 2075505 
    Average node length: 5.44, total dup: 1936521, max dup: 1517 
    Average key length: 2.49, compression ratio: 3.62 
    Average prefix length: 8.58, average data length: 0.42 
    Clustering factor: 181076, ratio: 0.09 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 323 
        40 - 59% = 1658 
        60 - 79% = 277 
        80 - 99% = 305 
 
    Index PSTORNED_SND_ID (0) 
    Root page: 1504841, depth: 3, leaf buckets: 2759, nodes: 2075505 
    Average node length: 5.70, total dup: 1862212, max dup: 71 
    Average key length: 2.74, compression ratio: 3.28 
    Average prefix length: 8.36, average data length: 0.64 
    Clustering factor: 372050, ratio: 0.18 
    Fill distribution: 
         0 - 19% = 3 
        20 - 39% = 8 
        40 - 59% = 2463 
        60 - 79% = 260 
        80 - 99% = 25 
 
    Index PSTORNED_WORKER_ID (2) 
    Root page: 1508018, depth: 3, leaf buckets: 2119, nodes: 2075505 
    Average node length: 4.96, total dup: 2075405, max dup: 27753 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.42, average data length: 0.00 
    Clustering factor: 179041, ratio: 0.09 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 193 
        40 - 59% = 1127 
        60 - 79% = 413 
        80 - 99% = 385 
 
RULES_FOR_PDISTR (148) 
    Primary pointer page: 520, Index root page: 521 
    Total formats: 1, used formats: 1 
    Average record length: 17.00, total records: 4 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 334.00, compression ratio: 19.65 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 2% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index RULES_FOR_PDISTR_UNQ (0) 
    Root page: 1504339, depth: 1, leaf buckets: 1, nodes: 4 
    Average node length: 11.50, total dup: 0, max dup: 0 
    Average key length: 10.25, compression ratio: 0.88 
    Average prefix length: 1.50, average data length: 7.50 
    Clustering factor: 1, ratio: 0.25 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
RULES_FOR_QDISTR (137) 
    Primary pointer page: 498, Index root page: 499 
    Total formats: 1, used formats: 1 
    Average record length: 32.71, total records: 7 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 332.00, compression ratio: 10.15 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 4% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index RULES_FOR_QDISTR_RCVOP (1) 
    Root page: 1544825, depth: 1, leaf buckets: 1, nodes: 7 
    Average node length: 5.29, total dup: 2, max dup: 2 
    Average key length: 4.14, compression ratio: 0.72 
    Average prefix length: 1.43, average data length: 1.57 
    Clustering factor: 1, ratio: 0.14 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index RULES_FOR_QDISTR_UNQ (0) 
    Root page: 1544824, depth: 1, leaf buckets: 1, nodes: 7 
    Average node length: 10.14, total dup: 0, max dup: 0 
    Average key length: 8.86, compression ratio: 0.94 
    Average prefix length: 2.14, average data length: 6.14 
    Clustering factor: 1, ratio: 0.14 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
SEMAPHORES (152) 
    Primary pointer page: 528, Index root page: 529 
    Total formats: 1, used formats: 1 
    Average record length: 43.40, total records: 5 
    Average version length: 9.00, total versions: 1, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 346.00, compression ratio: 7.97 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 4% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index PK_SEMAPHORES (0) 
    Root page: 1504327, depth: 1, leaf buckets: 1, nodes: 5 
    Average node length: 12.40, total dup: 0, max dup: 0 
    Average key length: 11.00, compression ratio: 0.82 
    Average prefix length: 0.60, average data length: 8.40 
    Clustering factor: 1, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index SEMAPHORES_TASK_UNQ (1) 
    Root page: 1504328, depth: 1, leaf buckets: 1, nodes: 5 
    Average node length: 23.40, total dup: 0, max dup: 0 
    Average key length: 22.00, compression ratio: 1.07 
    Average prefix length: 4.20, average data length: 19.40 
    Clustering factor: 1, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
SETTINGS (135) 
    Primary pointer page: 494, Index root page: 495 
    Total formats: 1, used formats: 1 
    Average record length: 97.62, total records: 149 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1347.00, compression ratio: 13.80 
    Pointer pages: 1, data page slots: 3 
    Data pages: 3, average fill: 70% 
    Primary pages: 3, secondary pages: 0, swept pages: 1 
    Empty pages: 0, full pages: 2 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 1 
    60 - 79% = 0 
    80 - 99% = 2 
 
    Index SETTINGS_MCODE_WM_UNQ (1) 
    Root page: 1544931, depth: 1, leaf buckets: 1, nodes: 149 
    Average node length: 14.66, total dup: 0, max dup: 0 
    Average key length: 13.55, compression ratio: 2.19 
    Average prefix length: 19.07, average data length: 10.66 
    Clustering factor: 48, ratio: 0.32 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 1 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index SETTINGS_MODE_CODE (0) 
    Root page: 1544828, depth: 1, leaf buckets: 1, nodes: 149 
    Average node length: 25.56, total dup: 0, max dup: 0 
    Average key length: 24.56, compression ratio: 1.63 
    Average prefix length: 18.58, average data length: 21.56 
    Clustering factor: 14, ratio: 0.09 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 0 
        40 - 59% = 1 
        60 - 79% = 0 
        80 - 99% = 0 
 
TMP$DEP_DOCS (129) 
    Primary pointer page: 482, Index root page: 483 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index TMP_DEP_DOCS_UNQ (0) 
    Root page: 1544832, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
TMP$IDX_RECALC (132) 
    Primary pointer page: 488, Index root page: 489 
    Total formats: 2, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index TMP_IDX_RECALC_IDX_NAME_UNQ (0) 
    Root page: 1544829, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
TMP$MON_LOG (133) 
    Primary pointer page: 490, Index root page: 491 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
TMP$MON_LOG_TABLE_STATS (134) 
    Primary pointer page: 492, Index root page: 493 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
TMP$PERF_EST_WHOLE (161) 
    Primary pointer page: 546, Index root page: 547 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
TMP$PERF_LOG (160) 
    Primary pointer page: 544, Index root page: 545 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index TMP$PERF_LOG_UNIT_TRN_DTS_END (0) 
    Root page: 1504252, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
TMP$PERF_MON (131) 
    Primary pointer page: 486, Index root page: 487 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
TMP$RESULT_SET (130) 
    Primary pointer page: 484, Index root page: 485 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index TMP_RESULT_SET_DOC (1) 
    Root page: 1544831, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index TMP_RESULT_SET_WARE_DOC (0) 
    Root page: 1544830, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
TMP$SHOPPING_CART (128) 
    Primary pointer page: 480, Index root page: 481 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index TMP_SHOPCART_UNQ (0) 
    Root page: 1544833, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
TPAUSE (166) 
    Primary pointer page: 557, Index root page: 558 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index RDB$PRIMARY2 (0) 
    Root page: 1504237, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
TRACE_STAT (157) 
    Primary pointer page: 538, Index root page: 539 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
WARES (142) 
    Primary pointer page: 508, Index root page: 509 
    Total formats: 1, used formats: 1 
    Average record length: 77.52, total records: 400 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 444.00, compression ratio: 5.73 
    Pointer pages: 1, data page slots: 6 
    Data pages: 6, average fill: 77% 
    Primary pages: 6, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 5 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 5 
    80 - 99% = 1 
 
    Index FK_WARES_WARE_GROUPS (3) 
    Root page: 1552183, depth: 1, leaf buckets: 1, nodes: 400 
    Average node length: 3.17, total dup: 392, max dup: 60 
    Average key length: 2.16, compression ratio: 4.16 
    Average prefix length: 8.86, average data length: 0.14 
    Clustering factor: 48, ratio: 0.12 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PK_WARES (0) 
    Root page: 1510377, depth: 1, leaf buckets: 1, nodes: 400 
    Average node length: 11.22, total dup: 0, max dup: 0 
    Average key length: 10.22, compression ratio: 0.88 
    Average prefix length: 1.78, average data length: 7.22 
    Clustering factor: 344, ratio: 0.86 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 0 
        40 - 59% = 1 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index WARES_ID_DESC (2) 
    Root page: 1510382, depth: 1, leaf buckets: 1, nodes: 400 
    Average node length: 11.22, total dup: 0, max dup: 0 
    Average key length: 10.22, compression ratio: 0.88 
    Average prefix length: 1.78, average data length: 7.22 
    Clustering factor: 344, ratio: 0.86 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 0 
        40 - 59% = 1 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index WARES_NUMB_UNQ (1) 
    Root page: 1510380, depth: 2, leaf buckets: 3, nodes: 400 
    Average node length: 53.25, total dup: 0, max dup: 0 
    Average key length: 52.23, compression ratio: 1.00 
    Average prefix length: 2.74, average data length: 49.25 
    Clustering factor: 355, ratio: 0.89 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 1 
        80 - 99% = 2 
 
WARE_GROUPS (151) 
    Primary pointer page: 526, Index root page: 527 
    Total formats: 1, used formats: 1 
    Average record length: 32.12, total records: 8 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 346.00, compression ratio: 10.77 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 5% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index PK_WARE_GROUPS (0) 
    Root page: 1504329, depth: 1, leaf buckets: 1, nodes: 8 
    Average node length: 11.25, total dup: 0, max dup: 0 
    Average key length: 10.12, compression ratio: 0.89 
    Average prefix length: 1.75, average data length: 7.25 
    Clustering factor: 1, ratio: 0.12 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index WARE_GROUPS_NAME_UNQ (1) 
    Root page: 1504330, depth: 1, leaf buckets: 1, nodes: 8 
    Average node length: 19.88, total dup: 0, max dup: 0 
    Average key length: 18.12, compression ratio: 0.89 
    Average prefix length: 0.25, average data length: 15.88 
    Clustering factor: 1, ratio: 0.12 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
XQD_1000_1200 (176) 
    Primary pointer page: 577, Index root page: 578 
    Total formats: 1, used formats: 1 
    Average record length: 48.48, total records: 124908 
    Average version length: 69.16, total versions: 43011, 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: 3, data page slots: 4472 
    Data pages: 3071, average fill: 49% 
    Primary pages: 3071, secondary pages: 0, swept pages: 487 
    Empty pages: 458, full pages: 821 
    Fill distribution: 
     0 - 19% = 632 
    20 - 39% = 376 
    40 - 59% = 793 
    60 - 79% = 878 
    80 - 99% = 392 
 
    Index XQD_1000_1200_WA_SO_RO_WKR_SND (0) 
    Root page: 103096, depth: 3, leaf buckets: 231, nodes: 124908 
    Average node length: 6.53, total dup: 108713, max dup: 14 
    Average key length: 3.98, compression ratio: 10.56 
    Average prefix length: 40.15, average data length: 1.85 
    Clustering factor: 22003, ratio: 0.18 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 89 
        40 - 59% = 116 
        60 - 79% = 25 
        80 - 99% = 1 
 
XQD_1000_3300 (178) 
    Primary pointer page: 581, Index root page: 582 
    Total formats: 1, used formats: 1 
    Average record length: 67.04, total records: 6912913 
    Average version length: 68.80, total versions: 220949, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.88 
    Pointer pages: 66, data page slots: 107656 
    Data pages: 107656, average fill: 69% 
    Primary pages: 107656, secondary pages: 0, swept pages: 44214 
    Empty pages: 22, full pages: 47275 
    Fill distribution: 
     0 - 19% = 270 
    20 - 39% = 1617 
    40 - 59% = 11652 
    60 - 79% = 93843 
    80 - 99% = 274 
 
    Index XQD_1000_3300_WA_SO_RO_WKR_SND (0) 
    Root page: 1480476, depth: 3, leaf buckets: 10679, nodes: 6912913 
    Average node length: 6.51, total dup: 5980946, max dup: 29 
    Average key length: 3.52, compression ratio: 11.93 
    Average prefix length: 40.61, average data length: 1.39 
    Clustering factor: 1634040, ratio: 0.24 
    Fill distribution: 
         0 - 19% = 12 
        20 - 39% = 1878 
        40 - 59% = 5884 
        60 - 79% = 2505 
        80 - 99% = 400 
 
    Index XQD_1000_3300_WKR_DOC_ASC (1) 
    Root page: 1486090, depth: 3, leaf buckets: 8587, nodes: 6912913 
    Average node length: 5.40, total dup: 6636731, max dup: 151 
    Average key length: 2.41, compression ratio: 7.06 
    Average prefix length: 16.63, average data length: 0.37 
    Clustering factor: 1441673, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 8 
        20 - 39% = 1457 
        40 - 59% = 4763 
        60 - 79% = 1429 
        80 - 99% = 930 
 
    Index XQD_1000_3300_WKR_DOC_DEC (2) 
    Root page: 1490630, depth: 3, leaf buckets: 8694, nodes: 6912913 
    Average node length: 5.40, total dup: 6636731, max dup: 151 
    Average key length: 2.41, compression ratio: 7.06 
    Average prefix length: 16.63, average data length: 0.37 
    Clustering factor: 1443965, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 8 
        20 - 39% = 1530 
        40 - 59% = 4861 
        60 - 79% = 1415 
        80 - 99% = 880 
 
XQD_1200_2000 (177) 
    Primary pointer page: 579, Index root page: 580 
    Total formats: 1, used formats: 1 
    Average record length: 68.04, total records: 11910657 
    Average version length: 68.75, total versions: 180761, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.85 
    Pointer pages: 108, data page slots: 174896 
    Data pages: 174896, average fill: 72% 
    Primary pages: 174895, secondary pages: 1, swept pages: 100432 
    Empty pages: 8, full pages: 125620 
    Fill distribution: 
     0 - 19% = 25 
    20 - 39% = 481 
    40 - 59% = 6608 
    60 - 79% = 166979 
    80 - 99% = 803 
 
    Index XQD_1200_2000_WA_SO_RO_WKR_SND (0) 
    Root page: 1495050, depth: 3, leaf buckets: 18422, nodes: 11909891 
    Average node length: 6.61, total dup: 10385702, max dup: 51 
    Average key length: 3.42, compression ratio: 12.27 
    Average prefix length: 40.70, average data length: 1.30 
    Clustering factor: 2455547, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 24 
        20 - 39% = 2484 
        40 - 59% = 10935 
        60 - 79% = 4292 
        80 - 99% = 687 
 
XQD_2000_3300 (179) 
    Primary pointer page: 583, Index root page: 584 
    Total formats: 1, used formats: 1 
    Average record length: 56.67, total records: 1317535 
    Average version length: 69.09, total versions: 205194, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 2.22 
    Pointer pages: 28, data page slots: 45336 
    Data pages: 27624, average fill: 52% 
    Primary pages: 27541, secondary pages: 83, swept pages: 12377 
    Empty pages: 3916, full pages: 13473 
    Fill distribution: 
     0 - 19% = 6158 
    20 - 39% = 3012 
    40 - 59% = 3159 
    60 - 79% = 12813 
    80 - 99% = 2482 
 
    Index XQD_2000_3300_WA_SO_RO_WKR_SND (0) 
    Root page: 1479735, depth: 3, leaf buckets: 1899, nodes: 1249168 
    Average node length: 5.53, total dup: 1198517, max dup: 49 
    Average key length: 2.58, compression ratio: 16.30 
    Average prefix length: 41.46, average data length: 0.54 
    Clustering factor: 87304, ratio: 0.07 
    Fill distribution: 
         0 - 19% = 8 
        20 - 39% = 705 
        40 - 59% = 900 
        60 - 79% = 270 
        80 - 99% = 16 
 
XQD_2100_3300 (180) 
    Primary pointer page: 585, Index root page: 586 
    Total formats: 1, used formats: 1 
    Average record length: 49.94, total records: 890370 
    Average version length: 69.06, total versions: 81250, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 2.52 
    Pointer pages: 22, data page slots: 35096 
    Data pages: 28560, average fill: 30% 
    Primary pages: 28560, secondary pages: 0, swept pages: 11841 
    Empty pages: 5846, full pages: 3946 
    Fill distribution: 
     0 - 19% = 11687 
    20 - 39% = 5949 
    40 - 59% = 6627 
    60 - 79% = 4253 
    80 - 99% = 44 
 
    Index XQD_2100_3300_WA_SO_RO_WKR_SND (0) 
    Root page: 1479229, depth: 3, leaf buckets: 1166, nodes: 688665 
    Average node length: 5.91, total dup: 636695, max dup: 50 
    Average key length: 2.98, compression ratio: 14.08 
    Average prefix length: 41.09, average data length: 0.91 
    Clustering factor: 94411, ratio: 0.14 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 523 
        40 - 59% = 512 
        60 - 79% = 119 
        80 - 99% = 11 
 
XQD_3300_3400 (181) 
    Primary pointer page: 587, Index root page: 588 
    Total formats: 1, used formats: 1 
    Average record length: 67.91, total records: 8931673 
    Average version length: 68.99, total versions: 145149, 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: 88, data page slots: 143048 
    Data pages: 143024, average fill: 67% 
    Primary pages: 143001, secondary pages: 23, swept pages: 74262 
    Empty pages: 350, full pages: 69319 
    Fill distribution: 
     0 - 19% = 1339 
    20 - 39% = 7088 
    40 - 59% = 21758 
    60 - 79% = 112224 
    80 - 99% = 615 
 
    Index XQD_3300_3400_WA_SO_RO_WKR_SND (0) 
    Root page: 1472612, depth: 3, leaf buckets: 13379, nodes: 8929993 
    Average node length: 6.68, total dup: 7405639, max dup: 14 
    Average key length: 3.67, compression ratio: 11.44 
    Average prefix length: 40.50, average data length: 1.50 
    Clustering factor: 2044107, ratio: 0.23 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 1498 
        40 - 59% = 7136 
        60 - 79% = 4136 
        80 - 99% = 607 
 
XQS_1000_1200 (182) 
    Primary pointer page: 589, Index root page: 590 
    Total formats: 1, used formats: 1 
    Average record length: 82.52, total records: 21156192 
    Average version length: 82.95, total versions: 5296, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.53 
    Pointer pages: 197, data page slots: 320048 
    Data pages: 320048, average fill: 81% 
    Primary pages: 320043, secondary pages: 5, swept pages: 14489 
    Empty pages: 53, full pages: 318851 
    Fill distribution: 
     0 - 19% = 80 
    20 - 39% = 47 
    40 - 59% = 138 
    60 - 79% = 50233 
    80 - 99% = 269550 
 
    Index XQS_1000_1200_DOC_ID (1) 
    Root page: 1426738, depth: 3, leaf buckets: 19573, nodes: 21156192 
    Average node length: 5.72, total dup: 20675101, max dup: 128 
    Average key length: 2.16, compression ratio: 4.16 
    Average prefix length: 8.86, average data length: 0.14 
    Clustering factor: 3286053, ratio: 0.16 
    Fill distribution: 
         0 - 19% = 7 
        20 - 39% = 0 
        40 - 59% = 8499 
        60 - 79% = 544 
        80 - 99% = 10523 
 
    Index XQS_1000_1200_RCV_ID (3) 
    Root page: 1457002, depth: 3, leaf buckets: 17196, nodes: 21156192 
    Average node length: 6.31, total dup: 18592472, max dup: 49 
    Average key length: 2.75, compression ratio: 3.27 
    Average prefix length: 8.37, average data length: 0.63 
    Clustering factor: 918885, ratio: 0.04 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 7 
        40 - 59% = 783 
        60 - 79% = 293 
        80 - 99% = 16112 
 
    Index XQS_1000_1200_SND_ID (2) 
    Root page: 1441095, depth: 3, leaf buckets: 21361, nodes: 21156192 
    Average node length: 6.35, total dup: 18510921, max dup: 29 
    Average key length: 2.79, compression ratio: 3.23 
    Average prefix length: 8.34, average data length: 0.66 
    Clustering factor: 3579837, ratio: 0.17 
    Fill distribution: 
         0 - 19% = 3 
        20 - 39% = 2 
        40 - 59% = 8779 
        60 - 79% = 608 
        80 - 99% = 11969 
 
    Index XQS_1000_1200_WORKER_ID (0) 
    Root page: 1413370, depth: 3, leaf buckets: 16144, nodes: 21156192 
    Average node length: 5.56, total dup: 21156092, max dup: 230640 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.42, average data length: 0.00 
    Clustering factor: 947557, ratio: 0.04 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 14 
        40 - 59% = 2937 
        60 - 79% = 390 
        80 - 99% = 12801 
 
XQS_1000_3300 (184) 
    Primary pointer page: 593, Index root page: 594 
    Total formats: 1, used formats: 1 
    Average record length: 81.08, total records: 9406874 
    Average version length: 82.63, total versions: 170770, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.55 
    Pointer pages: 105, data page slots: 170928 
    Data pages: 170872, average fill: 68% 
    Primary pages: 170839, secondary pages: 33, swept pages: 92855 
    Empty pages: 488, full pages: 96950 
    Fill distribution: 
     0 - 19% = 1788 
    20 - 39% = 10631 
    40 - 59% = 27745 
    60 - 79% = 114484 
    80 - 99% = 16224 
 
    Index XQS_1000_3300_DOC_ID (1) 
    Root page: 1367524, depth: 3, leaf buckets: 11338, nodes: 9406874 
    Average node length: 5.37, total dup: 9100927, max dup: 188 
    Average key length: 2.24, compression ratio: 4.02 
    Average prefix length: 8.79, average data length: 0.21 
    Clustering factor: 2146892, ratio: 0.23 
    Fill distribution: 
         0 - 19% = 4 
        20 - 39% = 95 
        40 - 59% = 8927 
        60 - 79% = 2265 
        80 - 99% = 47 
 
    Index XQS_1000_3300_RCV_ID (3) 
    Root page: 1379283, depth: 3, leaf buckets: 13298, nodes: 9406874 
    Average node length: 6.23, total dup: 7796526, max dup: 14 
    Average key length: 3.10, compression ratio: 2.90 
    Average prefix length: 8.07, average data length: 0.93 
    Clustering factor: 1512203, ratio: 0.16 
    Fill distribution: 
         0 - 19% = 113 
        20 - 39% = 4043 
        40 - 59% = 4332 
        60 - 79% = 2484 
        80 - 99% = 2326 
 
    Index XQS_1000_3300_SND_ID (2) 
    Root page: 1373081, depth: 3, leaf buckets: 12662, nodes: 9406874 
    Average node length: 5.98, total dup: 8154709, max dup: 35 
    Average key length: 2.86, compression ratio: 3.15 
    Average prefix length: 8.28, average data length: 0.72 
    Clustering factor: 2326266, ratio: 0.25 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 122 
        40 - 59% = 9956 
        60 - 79% = 2503 
        80 - 99% = 79 
 
    Index XQS_1000_3300_WORKER_ID (0) 
    Root page: 1362789, depth: 3, leaf buckets: 9890, nodes: 9406874 
    Average node length: 5.13, total dup: 9406774, max dup: 146981 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.43, average data length: 0.00 
    Clustering factor: 1542050, ratio: 0.16 
    Fill distribution: 
         0 - 19% = 47 
        20 - 39% = 1219 
        40 - 59% = 4913 
        60 - 79% = 1730 
        80 - 99% = 1981 
 
XQS_1200_2000 (183) 
    Primary pointer page: 591, Index root page: 592 
    Total formats: 1, used formats: 1 
    Average record length: 81.64, total records: 11103099 
    Average version length: 82.53, total versions: 99047, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.54 
    Pointer pages: 119, data page slots: 193712 
    Data pages: 191776, average fill: 71% 
    Primary pages: 191617, secondary pages: 159, swept pages: 75480 
    Empty pages: 3081, full pages: 142608 
    Fill distribution: 
     0 - 19% = 5511 
    20 - 39% = 8521 
    40 - 59% = 19133 
    60 - 79% = 101594 
    80 - 99% = 57017 
 
    Index XQS_1200_2000_DOC_ID (1) 
    Root page: 1392123, depth: 3, leaf buckets: 13115, nodes: 11103099 
    Average node length: 5.30, total dup: 10993740, max dup: 642 
    Average key length: 2.08, compression ratio: 4.32 
    Average prefix length: 8.93, average data length: 0.07 
    Clustering factor: 2322959, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 3 
        20 - 39% = 192 
        40 - 59% = 9628 
        60 - 79% = 3195 
        80 - 99% = 97 
 
    Index XQS_1200_2000_RCV_ID (3) 
    Root page: 1406132, depth: 3, leaf buckets: 10345, nodes: 11103099 
    Average node length: 5.49, total dup: 10617789, max dup: 49 
    Average key length: 2.28, compression ratio: 3.95 
    Average prefix length: 8.77, average data length: 0.23 
    Clustering factor: 711950, ratio: 0.06 
    Fill distribution: 
         0 - 19% = 166 
        20 - 39% = 918 
        40 - 59% = 2501 
        60 - 79% = 1902 
        80 - 99% = 4858 
 
    Index XQS_1200_2000_SND_ID (2) 
    Root page: 1398660, depth: 3, leaf buckets: 14999, nodes: 11103099 
    Average node length: 6.02, total dup: 9683924, max dup: 61 
    Average key length: 2.81, compression ratio: 3.20 
    Average prefix length: 8.32, average data length: 0.68 
    Clustering factor: 2339163, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 239 
        40 - 59% = 11184 
        60 - 79% = 3467 
        80 - 99% = 108 
 
    Index XQS_1200_2000_WORKER_ID (0) 
    Root page: 1386233, depth: 3, leaf buckets: 10612, nodes: 11103099 
    Average node length: 5.22, total dup: 11102999, max dup: 183960 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.42, average data length: 0.00 
    Clustering factor: 701388, ratio: 0.06 
    Fill distribution: 
         0 - 19% = 101 
        20 - 39% = 915 
        40 - 59% = 4576 
        60 - 79% = 1561 
        80 - 99% = 3459 
 
XQS_2000_3300 (185) 
    Primary pointer page: 595, Index root page: 596 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index XQS_2000_3300_DOC_ID (1) 
    Root page: 1361775, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index XQS_2000_3300_RCV_ID (3) 
    Root page: 1361777, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index XQS_2000_3300_SND_ID (2) 
    Root page: 1361776, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index XQS_2000_3300_WORKER_ID (0) 
    Root page: 1361774, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
XQS_2100_3300 (186) 
    Primary pointer page: 597, Index root page: 598 
    Total formats: 1, used formats: 1 
    Average record length: 81.57, total records: 9502827 
    Average version length: 82.91, total versions: 150164, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.54 
    Pointer pages: 108, data page slots: 175528 
    Data pages: 175392, average fill: 67% 
    Primary pages: 175354, secondary pages: 38, swept pages: 100270 
    Empty pages: 949, full pages: 94735 
    Fill distribution: 
     0 - 19% = 2673 
    20 - 39% = 11624 
    40 - 59% = 30418 
    60 - 79% = 115661 
    80 - 99% = 15016 
 
    Index XQS_2100_3300_DOC_ID (1) 
    Root page: 1344708, depth: 3, leaf buckets: 11637, nodes: 9502827 
    Average node length: 5.18, total dup: 9474422, max dup: 1547 
    Average key length: 2.03, compression ratio: 4.43 
    Average prefix length: 8.97, average data length: 0.03 
    Clustering factor: 1952931, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 38 
        20 - 39% = 1639 
        40 - 59% = 7673 
        60 - 79% = 1740 
        80 - 99% = 547 
 
    Index XQS_2100_3300_RCV_ID (3) 
    Root page: 1355739, depth: 3, leaf buckets: 13482, nodes: 9502827 
    Average node length: 6.25, total dup: 7875950, max dup: 14 
    Average key length: 3.10, compression ratio: 2.90 
    Average prefix length: 8.07, average data length: 0.93 
    Clustering factor: 1477833, ratio: 0.16 
    Fill distribution: 
         0 - 19% = 174 
        20 - 39% = 4090 
        40 - 59% = 4336 
        60 - 79% = 2436 
        80 - 99% = 2446 
 
    Index XQS_2100_3300_SND_ID (2) 
    Root page: 1350071, depth: 3, leaf buckets: 12237, nodes: 9502827 
    Average node length: 5.44, total dup: 9073801, max dup: 99 
    Average key length: 2.29, compression ratio: 3.93 
    Average prefix length: 8.76, average data length: 0.24 
    Clustering factor: 2081675, ratio: 0.22 
    Fill distribution: 
         0 - 19% = 27 
        20 - 39% = 1578 
        40 - 59% = 8433 
        60 - 79% = 1656 
        80 - 99% = 543 
 
    Index XQS_2100_3300_WORKER_ID (0) 
    Root page: 987843, depth: 3, leaf buckets: 10025, nodes: 9502827 
    Average node length: 5.15, total dup: 9502727, max dup: 149397 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.43, average data length: 0.00 
    Clustering factor: 1566571, ratio: 0.16 
    Fill distribution: 
         0 - 19% = 40 
        20 - 39% = 1215 
        40 - 59% = 5078 
        60 - 79% = 1694 
        80 - 99% = 1998 
 
XQS_3300_3400 (187) 
    Primary pointer page: 599, Index root page: 600 
    Total formats: 1, used formats: 1 
    Average record length: 67.99, total records: 569593 
    Average version length: 68.98, total versions: 1774, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.85 
    Pointer pages: 5, data page slots: 8040 
    Data pages: 8040, average fill: 74% 
    Primary pages: 8040, secondary pages: 0, swept pages: 3982 
    Empty pages: 7, full pages: 6787 
    Fill distribution: 
     0 - 19% = 12 
    20 - 39% = 14 
    40 - 59% = 205 
    60 - 79% = 7792 
    80 - 99% = 17 
 
    Index XQS_3300_3400_DOC_ID (1) 
    Root page: 40792, depth: 3, leaf buckets: 733, nodes: 569593 
    Average node length: 5.95, total dup: 484927, max dup: 82 
    Average key length: 3.09, compression ratio: 2.91 
    Average prefix length: 8.06, average data length: 0.94 
    Clustering factor: 100453, ratio: 0.18 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 35 
        40 - 59% = 521 
        60 - 79% = 85 
        80 - 99% = 92 
 
    Index XQS_3300_3400_SND_ID (2) 
    Root page: 37052, depth: 3, leaf buckets: 756, nodes: 569593 
    Average node length: 6.15, total dup: 467139, max dup: 21 
    Average key length: 3.29, compression ratio: 2.73 
    Average prefix length: 7.89, average data length: 1.11 
    Clustering factor: 100498, ratio: 0.18 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 40 
        40 - 59% = 523 
        60 - 79% = 95 
        80 - 99% = 96 
 
    Index XQS_3300_3400_WORKER_ID (0) 
    Root page: 377587, depth: 2, leaf buckets: 569, nodes: 569593 
    Average node length: 4.86, total dup: 569493, max dup: 9865 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.42, average data length: 0.00 
    Clustering factor: 89480, ratio: 0.16 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 36 
        40 - 59% = 334 
        60 - 79% = 90 
        80 - 99% = 109 
 
ZDOC_DATA (170) 
    Primary pointer page: 565, Index root page: 566 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
ZDOC_LIST (169) 
    Primary pointer page: 563, Index root page: 564 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
ZINVNT_TURNOVER_LOG (171) 
    Primary pointer page: 567, Index root page: 568 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
ZPDISTR (174) 
    Primary pointer page: 573, Index root page: 574 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index ZPDISTR_ID (0) 
    Root page: 1504230, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
ZPSTORNED (175) 
    Primary pointer page: 575, Index root page: 576 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index ZPSTORNED_ID (0) 
    Root page: 1504229, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
ZQDISTR (172) 
    Primary pointer page: 569, Index root page: 570 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index ZQDISTR_ID (0) 
    Root page: 1504235, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index ZQDISTR_WARE_SNDOP_RCVOP (1) 
    Root page: 1504236, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
ZQSTORNED (173) 
    Primary pointer page: 571, Index root page: 572 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index ZQSTORNED_DOC_ID (1) 
    Root page: 1504232, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index ZQSTORNED_ID (0) 
    Root page: 1504231, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index ZQSTORNED_RCV_ID (3) 
    Root page: 1504234, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index ZQSTORNED_SND_ID (2) 
    Root page: 1504233, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
ZTMP_DEP_DOCS (168) 
    Primary pointer page: 561, Index root page: 562 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
ZTMP_SHOPPING_CART (167) 
    Primary pointer page: 559, Index root page: 560 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
Z_USED_VIEWS (144) 
    Primary pointer page: 512, Index root page: 513 
    Total formats: 1, used formats: 1 
    Average record length: 29.38, total records: 29 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 99.00, compression ratio: 3.37 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 16% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index Z_USED_VIEWS_UNQ (0) 
    Root page: 1510372, depth: 1, leaf buckets: 1, nodes: 29 
    Average node length: 15.17, total dup: 0, max dup: 0 
    Average key length: 14.14, compression ratio: 1.44 
    Average prefix length: 9.17, average data length: 11.17 
    Clustering factor: 1, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
Gstat completion time Wed Feb 28 10:10:28 2024

Record versions statistics, table

TABLE_NAME TOTAL_RECS TOTAL_VERS MAX_VERSIONS VERS_TO_RECS_PRC MAXV_TO_VERS_PRC
DOC_DATA 7715530 35065 1 0.0000 0.0000
DOC_LIST 2224048 16892 2 0.0000 0.0000
FB_ERRORS 2182 757 1 0.0000 0.0000
INVNT_SALDO 400 1597 4 300.0000 0.0000
INVNT_TURNOVER_LOG 71043 59223 1 0.0000 0.0000
MONEY_SALDO 49 145 7 200.0000 0.0000
MONEY_TURNOVER_LOG 1375 1161 1 0.0000 0.0000
PDISTR 809072 22073 3 0.0000 0.0000
PERF_SPLIT_0 210318 23072 1 0.0000 0.0000
PERF_SPLIT_1 151009 481 1 0.0000 0.0000
PERF_SPLIT_2 147545 2332 1 0.0000 0.0000
PERF_SPLIT_3 138051 1409 1 0.0000 0.0000
PERF_SPLIT_4 142335 922 1 0.0000 0.0000
PERF_SPLIT_5 160856 86 1 0.0000 0.0000
PERF_SPLIT_6 139574 131 1 0.0000 0.0000
PERF_SPLIT_7 156709 6360 1 0.0000 0.0000
PERF_SPLIT_8 152297 967 1 0.0000 0.0000
PERF_SPLIT_9 140151 699 1 0.0000 0.0000
PSTORNED 2075505 14455 1 0.0000 0.0000
SEMAPHORES 5 1 1 0.0000 100.0000
XQD_1000_1200 124908 43011 1 0.0000 0.0000
XQD_1000_3300 6912913 220949 1 0.0000 0.0000
XQD_1200_2000 11910657 180761 1 0.0000 0.0000
XQD_2000_3300 1317535 205194 1 0.0000 0.0000
XQD_2100_3300 890370 81250 1 0.0000 0.0000
XQD_3300_3400 8931673 145149 1 0.0000 0.0000
XQS_1000_1200 21156192 5296 1 0.0000 0.0000
XQS_1000_3300 9406874 170770 1 0.0000 0.0000
XQS_1200_2000 11103099 99047 1 0.0000 0.0000
XQS_2100_3300 9502827 150164 1 0.0000 0.0000
XQS_3300_3400 569593 1774 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 ---
:467: 
:468: mscs-test-161.budzdorov.ru    Wed Feb 28 10:07:58 2024
:469:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3400
:470: 
:471: 
:472: mscs-test-161.budzdorov.ru    Wed Feb 28 10:08:07 2024
:473:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3400
:474: 
--- end of diff output ---

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

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