Generated by /opt/oltp-emul/oltp_isql_run_worker.sh, ISQL session No. 1 of total launched 100. 25.03.2024 07:08
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 15629180 kB
MemAvailable 30229828 kB
Buffers 0 kB
Cached 16064256 kB
SwapCached 2596 kB
Command: fdisk -l
WARNING: fdisk GPT support is currently new, and therefore in an experimental phase. Use at your own discretion.
Disk /dev/sda: 599.9 GB, 599932581888 bytes, 1171743324 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 262144 bytes / 524288 bytes
Disk label type: gpt
Disk identifier: 919DACA4-2F35-4CBB-BAA7-2A8CD8F7168C
# Start End Size Type Name
1 2048 411647 200M EFI System EFI System Partition
2 411648 2508799 1G Microsoft basic
3 2508800 1171742719 557.5G Linux LVM
Disk /dev/mapper/centos_mscs--test--161-root: 53.7 GB, 53687091200 bytes, 104857600 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 262144 bytes / 524288 bytes
Disk /dev/mapper/centos_mscs--test--161-swap: 16.8 GB, 16844324864 bytes, 32899072 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 262144 bytes / 524288 bytes
Disk /dev/sdb: 536 MB, 536870912 bytes, 1048576 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 512 bytes / 512 bytes
Disk label type: dos
Disk identifier: 0x00000046
Device Boot Start End Blocks Id System
/dev/sdb1 63 514079 257008+ c W95 FAT32 (LBA)
Disk /dev/mapper/centos_mscs--test--161-home: 528.1 GB, 528109010944 bytes, 1031462912 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 262144 bytes / 524288 bytes

Server and database settinfs 


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

Test configuration settings 

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

Test finish info 


FINISH_STATE                    NORMAL: TEST_TIME EXPIRED AT 2024-03-25 07:07:48
DTS_END                         2024-03-25 07:07:48.9360
FB_GDSCODE                      -1
FB_MNEMONA                      
STACK                           SP_CLIENT_ORDER(57:5) ==> SP_CHECK_TO_STOP_WORK(32:12) ==> SP_HALT_ON_ERROR(68:17)
IP                              ::1/50418
TRN_ID                          178194
ATT_ID                          544
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: 9573.25 19818 957325
customer order: creation 186.78 405 18678
customer order: refuse 15.59 377 1559
order to supplier: creation 49.68 1386 4968
order to supplier: removal 3.77 83642 377
invoice (draft): creation 49.67 2985 4967
invoice (draft): removal 51.55 702 5155
invoice accept: apply 44.58 19107 4458
invoice accept: cancel 45.76 783 4576
customer reserve: creation 4324.48 181 432448
customer reserve: removal 4492.65 56 449265
realization accept: apply 89.80 212 8980
realization accept: cancel 80.72 136 8072
payment from customer: creation 63.31 150 6331
payment from customer: removal 5.92 87 592
payment to supplier: creation 52.86 157 5286
payment to supplier: removal 3.93 99 393
service: total inventory turnovers 4.27 3254 427
service: total monetary turnovers 6.91 395 691
service: aggregate perf. data 0.98 12537 98
service: refresh index statistics 0.04 269703 4

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:02, from 25-03-2024 07:08:41 to 25-03-2024 07:08:43.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 1583
TEST_TIME 2 2873
TEST_TIME 3 2861
TEST_TIME 4 3701
TEST_TIME 5 3894
TEST_TIME 6 4271
TEST_TIME 7 4757
TEST_TIME 8 5399
TEST_TIME 9 5276
TEST_TIME 10 5781
TEST_TIME 11 5999
TEST_TIME 12 6287
TEST_TIME 13 6435
TEST_TIME 14 6654
TEST_TIME 15 6999
TEST_TIME 16 7351
TEST_TIME 17 8004
TEST_TIME 18 8471
TEST_TIME 19 8556
TEST_TIME 20 8927
TEST_TIME 21 8880
TEST_TIME 22 8910
TEST_TIME 23 8952
TEST_TIME 24 8812
TEST_TIME 25 8866
TEST_TIME 26 9673
TEST_TIME 27 9883
TEST_TIME 28 9854
TEST_TIME 29 9639
TEST_TIME 30 9677
TEST_TIME 31 9553
TEST_TIME 32 9699
TEST_TIME 33 9728
TEST_TIME 34 9772
TEST_TIME 35 10008
TEST_TIME 36 9877
TEST_TIME 37 9699
TEST_TIME 38 9644
TEST_TIME 39 9642
TEST_TIME 40 9471
TEST_TIME 41 9444
TEST_TIME 42 9458
TEST_TIME 43 9477
TEST_TIME 44 9543
TEST_TIME 45 9556
TEST_TIME 46 9436
TEST_TIME 47 9544
TEST_TIME 48 9476
TEST_TIME 49 9438
TEST_TIME 50 9437
TEST_TIME 51 9466
TEST_TIME 52 9484
TEST_TIME 53 9491
TEST_TIME 54 9430
TEST_TIME 55 9466
TEST_TIME 56 9651
TEST_TIME 57 9704
TEST_TIME 58 9634
TEST_TIME 59 9774
TEST_TIME 60 9870
TEST_TIME 61 9824
TEST_TIME 62 9710
TEST_TIME 63 9656
TEST_TIME 64 9612
TEST_TIME 65 9538
TEST_TIME 66 9581
TEST_TIME 67 9600
TEST_TIME 68 9535
TEST_TIME 69 9501
TEST_TIME 70 9436
TEST_TIME 71 9422
TEST_TIME 72 9388
TEST_TIME 73 9419
TEST_TIME 74 9399
TEST_TIME 75 9376
TEST_TIME 76 9484
TEST_TIME 77 9497
TEST_TIME 78 9519
TEST_TIME 79 9566
TEST_TIME 80 9542
TEST_TIME 81 9631
TEST_TIME 82 9641
TEST_TIME 83 9690
TEST_TIME 84 9649
TEST_TIME 85 9675
TEST_TIME 86 9574
TEST_TIME 87 9580
TEST_TIME 88 9599
TEST_TIME 89 9548
TEST_TIME 90 9469
TEST_TIME 91 9479
TEST_TIME 92 9470
TEST_TIME 93 9465
TEST_TIME 94 9468
TEST_TIME 95 9478
TEST_TIME 96 9497
TEST_TIME 97 9481
TEST_TIME 98 9531
TEST_TIME 99 9579
TEST_TIME 100 9576

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:04, from 25-03-2024 07:08:44 to 25-03-2024 07:08:48.

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 1351839 1351839 0 0.00 0 23413 7 0 0
doc_list_biud 1351836 1351836 0 0.00 0 24863 24 0 0
sp_add_invoice_to_stock 4584 4458 126 2.74 43 204268 19107 0 126
sp_cancel_adding_invoice 4576 4576 0 0.00 5 62062 783 0 0
sp_cancel_client_order 1559 1559 0 0.00 4 7140 377 0 0
sp_cancel_customer_reserve 449265 449265 0 0.00 0 24867 56 0 0
sp_cancel_pay_from_customer 592 592 0 0.00 2 7884 87 0 0
sp_cancel_pay_to_supplier 393 393 0 0.00 2 3464 100 0 0
sp_cancel_supplier_invoice 5168 5155 13 0.25 1 23004 702 0 13
sp_cancel_supplier_order 377 377 0 0.00 10 728337 83642 0 0
sp_cancel_write_off 8072 8072 0 0.00 1 11136 137 0 0
sp_client_order 18678 18678 0 0.00 3 27689 405 0 0
sp_customer_reserve 432448 432448 0 0.00 0 43763 181 0 0
sp_fill_shopping_cart 28600 28600 0 0.00 1 20278 41 0 0
sp_fill_shopping_cart_clo_res 432444 432444 0 0.00 0 21075 17 0 0
sp_get_clo_for_invoice 4454 4454 0 0.00 0 32609 364 0 0
sp_kill_cost_storno 13633 13633 0 0.00 0 6765 68 0 0
sp_kill_qstorno_ret_qs2qd 912134 912134 0 0.00 0 24861 30 0 0
sp_kill_qty_storno 482436 482436 0 0.00 0 24863 66 0 0
sp_lock_selected_doc 18610 18610 0 0.00 0 8009 6 0 0
sp_make_cost_storno 25051 25051 0 0.00 0 22786 71 0 0
sp_multiply_rows_for_pdistr 25048 25048 0 0.00 0 23383 40 0 0
sp_multiply_rows_for_qdistr 18678 18678 0 0.00 0 20698 205 0 0
sp_pay_from_customer 6331 6331 0 0.00 4 23417 151 0 0
sp_pay_to_supplier 5286 5286 0 0.00 4 22811 158 0 0
sp_payment_common 11616 11616 0 0.00 1 16423 29 0 0
sp_qd_handle_on_cancel_clo 1559 1559 0 0.00 0 7134 340 0 0
sp_qd_handle_on_invoice_upd_sts 9028 9028 0 0.00 0 16805 285 0 0
sp_qd_handle_on_reserve_upd_sts 8980 8980 0 0.00 0 24703 75 0 0
sp_reserve_write_off 8980 8980 0 0.00 6 24923 213 0 0
sp_supplier_invoice 4967 4967 0 0.00 5 93057 2985 0 0
sp_supplier_order 4968 4968 0 0.00 4 94089 1387 0 0
srv_aggregate_perf_data 98 98 0 0.00 1346 81481 12538 0 0
srv_fill_mon_cache_memory 57 57 0 0.00 2872 105782 39336 0 0
srv_find_qd_qs_mism 910844 910844 0 0.00 0 18799 6 0 0
srv_make_invnt_saldo 427 427 0 0.00 45 82182 3254 0 0
srv_make_money_saldo 691 691 0 0.00 1 12067 395 0 0
srv_recalc_idx_stat 4 4 0 0.00 198101 307205 269703 0 0
t$perf-abend:sp_add_invoice_to_stock 126 126 0 0.00 0 0 0 0 0
t$perf-abend:sp_cancel_supplier_invoice 13 13 0 0.00 0 0 0 0 0
t$perf-norm:sp_add_invoice_to_stock 4458 4458 0 0.00 0 26202 184 0 0
t$perf-norm:sp_cancel_adding_invoice 339 339 0 0.00 0 1813 70 0 0
t$perf-norm:sp_cancel_client_order 1559 1559 0 0.00 0 4863 14 0 0
t$perf-norm:sp_cancel_customer_reserve 635 635 0 0.00 0 1179 7 0 0
t$perf-norm:sp_cancel_pay_from_customer 592 592 0 0.00 0 10578 23 0 0
t$perf-norm:sp_cancel_pay_to_supplier 393 393 0 0.00 0 123 1 0 0
t$perf-norm:sp_cancel_supplier_invoice 374 374 0 0.00 0 688 12 0 0
t$perf-norm:sp_cancel_supplier_order 377 377 0 0.00 0 27060 1738 0 0
t$perf-norm:sp_cancel_write_off 913 913 0 0.00 0 15394 31 0 0
t$perf-norm:sp_client_order 18678 18678 0 0.00 0 13841 19 0 0
t$perf-norm:sp_customer_reserve 911 911 0 0.00 0 13836 32 0 0
t$perf-norm:sp_pay_from_customer 6331 6331 0 0.00 0 13889 13 0 0
t$perf-norm:sp_pay_to_supplier 5286 5286 0 0.00 0 11995 18 0 0
t$perf-norm:sp_reserve_write_off 8980 8980 0 0.00 0 13603 14 0 0
t$perf-norm:sp_supplier_invoice 4967 4967 0 0.00 0 7562 16 0 0
t$perf-norm:sp_supplier_order 4968 4968 0 0.00 0 1493 11 0 0
t$perf-norm:srv_aggregate_perf_data 98 98 0 0.00 0 185 5 0 0
t$perf-norm:srv_fill_mon_cache_memory 57 57 0 0.00 0 3249 65 0 0
t$perf-norm:srv_make_invnt_saldo 427 427 0 0.00 0 764 10 0 0
t$perf-norm:srv_make_money_saldo 691 691 0 0.00 0 5462 31 0 0
t$perf-norm:srv_recalc_idx_stat 4 4 0 0.00 2 10 6 0 0
v_add_invoice_to_stock 9150 8898 252 2.75 0 1977 15 0 252
v_all_customers 34662 34662 0 0.00 0 40 1 0 0
v_all_suppliers 28352 28352 0 0.00 0 78 1 0 0
v_all_wares 37354 37354 0 0.00 0 36 1 0 0
v_cancel_adding_invoice 678 678 0 0.00 0 1144 8 0 0
v_cancel_client_order 3118 3118 0 0.00 0 2831 5 0 0
v_cancel_customer_prepayment 1184 1184 0 0.00 0 822 5 0 0
v_cancel_customer_reserve 1270 1270 0 0.00 0 1824 7 0 0
v_cancel_payment_to_supplier 786 786 0 0.00 0 1166 11 0 0
v_cancel_supplier_invoice 774 748 26 3.35 0 1248 17 0 26
v_cancel_supplier_order 754 754 0 0.00 0 1952 7 0 0
v_cancel_write_off 1826 1826 0 0.00 0 2027 16 0 0
v_max_id_clo_ord 4962 4962 0 0.00 0 274 1 0 0
v_max_id_clo_res 911 911 0 0.00 0 2547 12 0 0
v_max_id_ord_sup 4959 4959 0 0.00 0 3193 3 0 0
v_max_non_paid_invoice 1030 1030 0 0.00 0 144 2 0 0
v_max_non_paid_realizn 2975 2975 0 0.00 0 6386 7 0 0
v_min_id_clo_ord 4962 4962 0 0.00 0 16649 12 0 0
v_min_id_clo_res 911 911 0 0.00 0 6979 11 0 0
v_min_id_ord_sup 4959 4959 0 0.00 0 18600 13 0 0
v_min_non_paid_invoice 5285 5285 0 0.00 0 6545 13 0 0
v_min_non_paid_realizn 6331 6331 0 0.00 0 16418 23 0 0
v_our_firm 9404 9404 0 0.00 0 18 1 0 0
v_reserve_write_off 17956 17956 0 0.00 0 6411 8 0 0
x_lock_depdocs_on_canc_invoice 9357 9357 0 0.00 0 22490 118 0 0
x_lock_depdocs_on_canc_sup_ord 377 377 0 0.00 0 3655 285 0 0
x_make_qstorno_1000_1200 4968 4968 0 0.00 1 94051 1304 0 0
x_make_qstorno_1200_2000 4967 4967 0 0.00 2 85754 2831 0 0
x_make_qstorno_2100_3300 432448 432448 0 0.00 0 43762 161 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 25-03-2024 07:08:49 to 25-03-2024 07:08:53.

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
05:07:52 10 8192000000 8798422496 8809533440 4463136 0.054 2 1 2 0 4562528 63616 35776
05:08:53 33244 8192000000 9707851408 10005540864 780398448 8.697 100 86 172 0 808561056 7914672 20247936
05:10:31 25061 8192000000 9762140992 10071945216 834083264 9.240 100 87 175 0 866229136 11925504 20220368
05:12:02 14962 8192000000 9795063840 10114453504 864890672 9.549 100 84 168 0 903596928 19607568 19098688
05:13:21 11175 8192000000 9848516224 10179698688 898729232 9.886 100 77 154 0 954063584 38814720 16519632
05:14:37 8740 8192000000 9889747648 10233458688 935038208 10.244 100 70 140 0 999894496 51014576 13841712
05:15:48 7338 8192000000 9931272928 10285797376 972546288 10.612 100 69 138 1 1040959088 54942128 13470672
05:17:03 2625 8192000000 9981971664 10341883904 1000027680 10.879 100 85 170 0 1089953520 73022704 16903136
05:18:07 2816 8192000000 9981293584 10355261440 1026614768 11.136 100 81 162 0 1098404800 56378064 15411968
05:19:12 2279 8192000000 10015731520 10395930624 1044332256 11.306 100 79 156 0 1127314112 67501440 15480416
05:20:17 3212 8192000000 10002735312 10381041664 1052630208 11.386 100 81 161 0 1115526928 47536256 15360464
05:21:24 2614 8192000000 10015838720 10396274688 1058954064 11.446 100 79 158 0 1134553856 60341936 15257856
05:22:28 4222 8192000000 10031771776 10426916864 1065316400 11.507 100 46 88 2 1146625936 72211552 9097984
05:23:34 4748 8192000000 9990484880 10394640384 1067917888 11.532 100 46 91 3 1107752800 29978288 9856624
05:24:40 58052 8192000000 9986285536 10388164608 1074067136 11.591 100 34 68 2 1094793184 13838528 6887520
05:26:39 6332 8192000000 10010048480 10418376704 1077843408 11.627 100 44 88 1 1117895856 31493984 8558464
05:27:48 4887 8192000000 9985260656 10388725760 1080151264 11.649 100 32 63 0 1099396816 12440864 6804688
05:29:06 21959 8192000000 10043363216 10449068032 1093415680 11.775 100 51 99 1 1143884832 40632240 9836912
05:30:33 105782 8192000000 10068545296 10493108224 1106695888 11.901 100 25 49 1 1195749648 83801680 5252080
05:33:28 13589 8192000000 10150311312 10558181376 1114499168 11.975 100 57 111 1 1241290320 116325680 10465472
05:34:48 25003 8192000000 10101808000 10533650432 1111345424 11.945 99 34 68 0 1216087920 97419024 7323472
05:36:27 4894 8192000000 10138721280 10550575104 1131268752 12.133 100 55 110 0 1245199760 102083680 11847328
05:37:39 11318 8192000000 10146597408 10556919808 1121478976 12.041 100 56 112 1 1259112208 126074576 11558656
05:38:57 6655 8192000000 10155178192 10555113472 1089619104 11.739 97 64 126 0 1251251712 148183296 13449312
05:40:07 9854 8192000000 10167727392 10567364608 1094865344 11.789 99 55 109 0 1260654640 154432992 11356304
05:41:20 11936 8192000000 10173181616 10564284416 1077888464 11.627 98 65 129 0 1256770400 165630992 13250944
05:42:36 4165 8192000000 10198223344 10597216256 1098654400 11.825 100 51 102 0 1295382288 185729968 10997920
05:43:43 2871 8192000000 10200779952 10584268800 1078378960 11.632 99 83 166 0 1298545008 202122944 18043104
05:44:54 4844 8192000000 10211601712 10606825472 1104255712 11.878 100 83 160 1 1315008416 194024992 16727712
05:46:04 4438 8192000000 10156598896 10547666944 1081488816 11.662 99 63 126 1 1252731920 157955536 13287568
05:47:11 12468 8192000000 10124613024 10583891968 1106386880 11.898 100 21 40 0 1236495184 125149104 4959200
05:48:27 13014 8192000000 10164972080 10590187520 1110941824 11.941 100 47 92 1 1267814240 146444800 10427616
05:49:41 25997 8192000000 10165067248 10585890816 1110285936 11.935 100 39 79 1 1274387312 154520704 9580672
05:51:25 23493 8192000000 10189768944 10636017664 1099901744 11.837 99 15 30 0 1286415808 182742848 3771216
05:54:14 83027 8192000000 10033531808 10478862336 1084733296 11.693 99 11 21 0 1146859600 60290704 1835600
05:56:37 41454 8192000000 10056105296 10492919808 1105229440 11.887 100 29 59 1 1173740832 61858320 6653072
05:58:26 43934 8192000000 10058477088 10514534400 1108688352 11.920 100 30 60 0 1178516480 62970784 6857344
06:00:15 84529 8192000000 10125593440 10558554112 1125384816 12.078 100 24 46 1 1173421936 43573616 4463504
06:02:47 58695 8192000000 10056448976 10515951616 1133965536 12.159 100 18 37 0 1175758688 38357152 3436000
06:04:48 58190 8192000000 10076237952 10505486336 1126051584 12.084 99 41 80 0 1159986736 24794800 9140352
06:06:51 80564 8192000000 10106535712 10542546944 1136162704 12.179 99 26 51 1 1196676032 55167120 5346208
06:09:14 38236 8192000000 10144729808 10589474816 1157056912 12.376 100 41 82 0 1251272928 84935280 9280736
06:10:55 35011 8192000000 10133319712 10613817344 1153532224 12.343 100 23 46 0 1259462112 100940912 4988976
06:12:32 52932 8192000000 10114219408 10564063232 1143476176 12.248 99 14 28 1 1219284368 72956608 2851584
06:14:26 33861 8192000000 10058813792 10524246016 1128354272 12.106 98 14 28 0 1185452880 54346816 2751792
06:16:00 24328 8192000000 10068452624 10536026112 1139509296 12.211 99 16 32 1 1172763728 30456752 2797680
06:17:25 45369 8192000000 10071995904 10529431552 1129437376 12.116 99 27 54 0 1156605456 22334208 4833872
06:19:27 55651 8192000000 10060165536 10508951552 1124940144 12.074 99 28 54 1 1168277376 37313456 6023776
06:21:25 26116 8192000000 10084032704 10510782464 1074497936 11.595 95 31 62 0 1146543840 65138576 6907328
06:22:52 47365 8192000000 10013980320 10467426304 1059241584 11.449 96 7 15 0 1112027888 51392464 1393840
06:24:39 46348 8192000000 10048239808 10492444672 1051692544 11.377 95 17 35 0 1104444048 49141664 3609840
06:26:40 73429 8192000000 10034561872 10517200896 1043391936 11.297 96 17 34 0 1129851792 83265840 3194016
06:28:54 101437 8192000000 10019190416 10463535104 1039978160 11.264 96 27 54 0 1086606416 41439904 5188352
06:32:01 20430 8192000000 10009529504 10427219968 1083094416 11.677 100 31 63 0 1109086864 19903360 6089088
06:33:23 42976 8192000000 10079334448 10517929984 1095889216 11.799 100 37 74 0 1165483456 61595568 7998672
06:35:12 25880 8192000000 10027941984 10454695936 1095073744 11.791 100 27 53 0 1121996960 21167808 5755408
06:36:40 50080 8192000000 10066473472 10507927552 1094231296 11.783 99 15 30 0 1160120496 63164832 2724368
06:39:21 5233 8192000000 10007422416 10438115328 1082402560 11.670 99 52 102 2 1106606800 14094224 10110016
06:40:27 54070 8192000000 10022549536 10490589184 1050510192 11.366 96 15 29 0 1092311008 39038240 2762576
06:42:21 45964 8192000000 10113356080 10537484288 1106713536 11.901 99 19 38 0 1213247376 102697200 3836640
06:44:14 53122 8192000000 10061754208 10509565952 1128163984 12.104 100 28 56 0 1171618464 38242832 5211648
06:46:12 52767 8192000000 10070995376 10512199680 1125088912 12.075 99 17 34 1 1184848544 56516592 3243040
06:48:06 54989 8192000000 10090431280 10580463616 1144208112 12.255 100 28 56 0 1232673360 83071392 5393856
06:50:20 41897 8192000000 10089030464 10525282304 1146451088 12.276 100 24 47 0 1216335536 65106656 4777792
06:52:03 45455 8192000000 10121379120 10572775424 1128152752 12.104 98 38 74 0 1206986608 71873760 6960096
06:53:50 88401 8192000000 10093879920 10540875776 1110284496 11.935 97 27 54 0 1174717488 59409536 5023456
06:56:19 43714 8192000000 10050265104 10507284480 1105041200 11.885 98 12 24 0 1150875504 43374480 2459824
06:58:12 36106 8192000000 10086127408 10531123200 1129918480 12.121 100 20 40 0 1198106432 63996080 4191872
06:59:49 37427 8192000000 10034921376 10480656384 1072878720 11.580 96 23 46 0 1112212416 34599648 4734048
07:01:28 28274 8192000000 10089033344 10523959296 1111582128 11.947 99 26 52 0 1190284592 73148656 5553808
07:03:03 67202 8192000000 10047171136 10528407552 1056790464 11.426 94 18 36 0 1105930848 45279568 3860816
07:05:11 94409 8192000000 10052887200 10513358848 1053227840 11.392 95 15 31 0 1122986096 66621584 3136672
07:07:46 16058 8192000000 9027835840 9272090624 177707872 2.123 17 1 2 0 188548144 10804864 35408

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:14, from 25-03-2024 07:08:55 to 25-03-2024 07:09:09.

Exceptions occured during test was in run

FB_MNEMONA CNT UNIT FB_GDSCODE
except 126 v_add_invoice_to_stock 335544517
except 13 v_cancel_supplier_invoice 335544517

Completed "Exceptions occured during test was in run". Done for 00:00:02, from 25-03-2024 07:09:10 to 25-03-2024 07:09:12.

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          178481
MON$OLDEST_ACTIVE               178482
MON$OLDEST_SNAPSHOT             178482
MON$NEXT_TRANSACTION            178482
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                       1920160
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             710
MON$NEXT_STATEMENT              53
MON$REPLICA_MODE                0


ISQL Version: LI-V4.0.5.3081 Firebird 4.0
Server version:
Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V4.0.5.3081 Firebird 4.0"
Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-V4.0.5.3081 Firebird 4.0/tcp (mscs-test-161.budzdorov.ru)/P17:C"
Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-V4.0.5.3081 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 Mon Mar 25 07:09:13 2024 
 
Database header page information: 
    Flags            0 
    Generation        93105 
    System Change Number    0 
    Page size        8192 
    ODS version        13.0 
    Oldest transaction    178481 
    Oldest active        178482 
    Oldest snapshot        178482 
    Next transaction    178483 
    Sequence number        0 
    Next attachment ID    710 
    Implementation        HW=AMD/Intel/x64 little-endian OS=Linux CC=gcc 
    Shadow count        0 
    Page buffers        0 
    Next header page    0 
    Database dialect    3 
    Creation date        Apr 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.15, total records: 7812491 
    Average version length: 48.15, total versions: 148272, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 64.00, compression ratio: 1.36 
    Pointer pages: 55, data page slots: 88768 
    Data pages: 88768, average fill: 71% 
    Primary pages: 88766, secondary pages: 2, swept pages: 26638 
    Empty pages: 2, full pages: 84363 
    Fill distribution: 
     0 - 19% = 7 
    20 - 39% = 18 
    40 - 59% = 201 
    60 - 79% = 88449 
    80 - 99% = 93 
 
    Index DOC_DATA_DOC_WARE_UNQ (0) 
    Root page: 1510636, depth: 3, leaf buckets: 23412, nodes: 7812491 
    Average node length: 18.91, total dup: 0, max dup: 0 
    Average key length: 15.92, compression ratio: 1.70 
    Average prefix length: 14.08, average data length: 12.92 
    Clustering factor: 1724099, ratio: 0.22 
    Fill distribution: 
         0 - 19% = 345 
        20 - 39% = 1550 
        40 - 59% = 4387 
        60 - 79% = 2534 
        80 - 99% = 14596 
 
    Index DOC_DATA_ID_DESC (1) 
    Root page: 1528140, depth: 3, leaf buckets: 13595, nodes: 7812491 
    Average node length: 11.20, total dup: 0, max dup: 0 
    Average key length: 8.21, compression ratio: 1.10 
    Average prefix length: 3.79, average data length: 5.21 
    Clustering factor: 1547485, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 1428 
        40 - 59% = 2236 
        60 - 79% = 1137 
        80 - 99% = 8793 
 
    Index FK_DOC_DATA_DOC_LIST (2) 
    Root page: 1546735, depth: 3, leaf buckets: 8406, nodes: 7812491 
    Average node length: 6.63, total dup: 5828958, max dup: 49 
    Average key length: 3.64, compression ratio: 2.47 
    Average prefix length: 7.61, average data length: 1.39 
    Clustering factor: 1540431, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 151 
        20 - 39% = 850 
        40 - 59% = 1512 
        60 - 79% = 933 
        80 - 99% = 4960 
 
DOC_LIST (138) 
    Primary pointer page: 500, Index root page: 501 
    Total formats: 1, used formats: 1 
    Average record length: 55.79, total records: 2274599 
    Average version length: 58.88, total versions: 78106, max versions: 2 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 84.00, compression ratio: 1.51 
    Pointer pages: 18, data page slots: 28520 
    Data pages: 28520, average fill: 74% 
    Primary pages: 28518, secondary pages: 2, swept pages: 6582 
    Empty pages: 5, full pages: 27058 
    Fill distribution: 
     0 - 19% = 7 
    20 - 39% = 0 
    40 - 59% = 18 
    60 - 79% = 28339 
    80 - 99% = 156 
 
    Index DOC_LIST_ID_DESC (1) 
    Root page: 1541152, depth: 3, leaf buckets: 4590, nodes: 2274599 
    Average node length: 11.40, total dup: 0, max dup: 0 
    Average key length: 8.44, compression ratio: 1.07 
    Average prefix length: 3.56, average data length: 5.44 
    Clustering factor: 699289, ratio: 0.31 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 841 
        40 - 59% = 945 
        60 - 79% = 753 
        80 - 99% = 2051 
 
    Index DOC_LIST_WORKER_OPTYPE (2) 
    Root page: 1544398, depth: 3, leaf buckets: 2438, nodes: 2276581 
    Average node length: 4.97, total dup: 2275682, max dup: 18088 
    Average key length: 2.01, compression ratio: 4.48 
    Average prefix length: 8.99, average data length: 0.01 
    Clustering factor: 1282267, ratio: 0.56 
    Fill distribution: 
         0 - 19% = 3 
        20 - 39% = 190 
        40 - 59% = 1392 
        60 - 79% = 595 
        80 - 99% = 258 
 
    Index FK_DOC_LIST_AGENTS (3) 
    Root page: 1545933, depth: 3, leaf buckets: 1759, nodes: 2274599 
    Average node length: 4.97, total dup: 2274549, max dup: 130486 
    Average key length: 2.01, compression ratio: 4.48 
    Average prefix length: 8.99, average data length: 0.01 
    Clustering factor: 1070048, ratio: 0.47 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 6 
        40 - 59% = 593 
        60 - 79% = 43 
        80 - 99% = 1116 
 
    Index PK_DOC_LIST (0) 
    Root page: 1538209, depth: 3, leaf buckets: 4397, nodes: 2274599 
    Average node length: 11.40, total dup: 0, max dup: 0 
    Average key length: 8.44, compression ratio: 1.07 
    Average prefix length: 3.56, average data length: 5.44 
    Clustering factor: 699289, ratio: 0.31 
    Fill distribution: 
         0 - 19% = 116 
        20 - 39% = 542 
        40 - 59% = 687 
        60 - 79% = 830 
        80 - 99% = 2222 
 
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.39, total records: 400 
    Average version length: 28.53, total versions: 2266, max versions: 6 
    Average fragment length: 2.00, total fragments: 1, max fragments: 1 
    Average unpacked length: 104.00, compression ratio: 1.25 
    Pointer pages: 1, data page slots: 32 
    Data pages: 32, average fill: 55% 
    Primary pages: 14, secondary pages: 18, swept pages: 0 
    Empty pages: 7, full pages: 15 
    Fill distribution: 
     0 - 19% = 10 
    20 - 39% = 3 
    40 - 59% = 0 
    60 - 79% = 3 
    80 - 99% = 16 
 
    Index PK_INVNT_SALDO (0) 
    Root page: 1510371, depth: 1, leaf buckets: 1, nodes: 400 
    Average node length: 11.22, total dup: 0, max dup: 0 
    Average key length: 10.22, compression ratio: 0.88 
    Average prefix length: 1.78, average data length: 7.22 
    Clustering factor: 326, ratio: 0.81 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 0 
        40 - 59% = 1 
        60 - 79% = 0 
        80 - 99% = 0 
 
INVNT_TURNOVER_LOG (153) 
    Primary pointer page: 530, Index root page: 531 
    Total formats: 1, used formats: 1 
    Average record length: 15.33, total records: 119523 
    Average version length: 68.30, total versions: 106775, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 88.00, compression ratio: 5.74 
    Pointer pages: 7, data page slots: 3200 
    Data pages: 2592, average fill: 62% 
    Primary pages: 2591, secondary pages: 1, swept pages: 0 
    Empty pages: 318, full pages: 1344 
    Fill distribution: 
     0 - 19% = 492 
    20 - 39% = 272 
    40 - 59% = 306 
    60 - 79% = 305 
    80 - 99% = 1217 
 
    Index INVNT_TURNOVER_LOG_WARE_DD_ID (0) 
    Root page: 1690944, depth: 3, leaf buckets: 423, nodes: 119523 
    Average node length: 13.09, total dup: 10626, max dup: 2 
    Average key length: 10.56, compression ratio: 2.56 
    Average prefix length: 19.35, average data length: 7.65 
    Clustering factor: 84942, ratio: 0.71 
    Fill distribution: 
         0 - 19% = 3 
        20 - 39% = 99 
        40 - 59% = 283 
        60 - 79% = 38 
        80 - 99% = 0 
 
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: 250, max versions: 8 
    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: 5 
    Data pages: 5, average fill: 20% 
    Primary pages: 1, secondary pages: 4, swept pages: 0 
    Empty pages: 0, full pages: 1 
    Fill distribution: 
     0 - 19% = 4 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 1 
 
    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: 11.91, total records: 1790 
    Average version length: 43.98, total versions: 1646, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 58.00, compression ratio: 4.87 
    Pointer pages: 1, data page slots: 40 
    Data pages: 40, average fill: 49% 
    Primary pages: 39, secondary pages: 1, swept pages: 0 
    Empty pages: 7, full pages: 16 
    Fill distribution: 
     0 - 19% = 16 
    20 - 39% = 2 
    40 - 59% = 3 
    60 - 79% = 3 
    80 - 99% = 16 
 
    Index MONEY_TURNOVER_LOG_AGENT_OPTYPE (0) 
    Root page: 94399, depth: 2, leaf buckets: 2, nodes: 1790 
    Average node length: 4.47, total dup: 1694, max dup: 246 
    Average key length: 2.58, compression ratio: 7.37 
    Average prefix length: 18.48, average data length: 0.52 
    Clustering factor: 941, ratio: 0.53 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 0 
        40 - 59% = 2 
        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.45, total records: 73 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 112.00, compression ratio: 1.15 
    Pointer pages: 1, data page slots: 2 
    Data pages: 2, average fill: 51% 
    Primary pages: 2, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 1 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 1 
    40 - 59% = 0 
    60 - 79% = 1 
    80 - 99% = 0 
 
    Index PK_MON_CACHE_MEMORY (0) 
    Root page: 1504238, depth: 1, leaf buckets: 1, nodes: 73 
    Average node length: 11.68, total dup: 0, max dup: 0 
    Average key length: 10.67, compression ratio: 0.84 
    Average prefix length: 1.32, average data length: 7.68 
    Clustering factor: 2, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
MON_LOG (162) 
    Primary pointer page: 548, Index root page: 549 
    Total formats: 2, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index MON_LOG_DTS (4) 
    Root page: 1504251, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index MON_LOG_GDSCODE (2) 
    Root page: 1504249, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index MON_LOG_ROWSET_DESC (1) 
    Root page: 1504248, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index MON_LOG_UNIT (3) 
    Root page: 1504250, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PK_MON_LOG (0) 
    Root page: 1504247, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
MON_LOG_TABLE_STATS (163) 
    Primary pointer page: 550, Index root page: 551 
    Total formats: 2, used formats: 1 
    Average record length: 67.13, total records: 30 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 611.00, compression ratio: 9.10 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 31% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 1 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index MON_LOG_TABLE_STATS_DTS (4) 
    Root page: 1504246, depth: 1, leaf buckets: 1, nodes: 30 
    Average node length: 3.50, total dup: 23, max dup: 4 
    Average key length: 2.47, compression ratio: 3.24 
    Average prefix length: 7.53, average data length: 0.47 
    Clustering factor: 1, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index MON_LOG_TABLE_STATS_GDSCODE (2) 
    Root page: 1504244, depth: 1, leaf buckets: 1, nodes: 30 
    Average node length: 2.00, total dup: 29, max dup: 29 
    Average key length: 1.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 1, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index MON_LOG_TABLE_STATS_ROWSET (1) 
    Root page: 1504243, depth: 1, leaf buckets: 1, nodes: 30 
    Average node length: 3.33, total dup: 29, max dup: 29 
    Average key length: 2.30, compression ratio: 3.91 
    Average prefix length: 8.70, average data length: 0.30 
    Clustering factor: 1, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index MON_LOG_TABLE_STATS_TN_UNIT (3) 
    Root page: 1504245, depth: 1, leaf buckets: 1, nodes: 30 
    Average node length: 12.90, total dup: 0, max dup: 0 
    Average key length: 11.87, compression ratio: 1.42 
    Average prefix length: 7.63, average data length: 9.20 
    Clustering factor: 1, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PK_MON_LOG_TABLE_STATS (0) 
    Root page: 1504242, depth: 1, leaf buckets: 1, nodes: 30 
    Average node length: 8.37, total dup: 0, max dup: 0 
    Average key length: 7.33, compression ratio: 1.23 
    Average prefix length: 4.63, average data length: 4.37 
    Clustering factor: 1, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
OPTYPES (136) 
    Primary pointer page: 496, Index root page: 497 
    Total formats: 2, used formats: 1 
    Average record length: 67.56, total records: 9 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 386.00, compression ratio: 5.71 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 9% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index OPTYPES_MCODE_UNQ (1) 
    Root page: 1544827, depth: 1, leaf buckets: 1, nodes: 9 
    Average node length: 8.56, total dup: 0, max dup: 0 
    Average key length: 6.89, compression ratio: 0.73 
    Average prefix length: 0.44, average data length: 4.56 
    Clustering factor: 1, ratio: 0.11 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PK_OPTYPES (0) 
    Root page: 1544826, depth: 1, leaf buckets: 1, nodes: 9 
    Average node length: 6.11, total dup: 0, max dup: 0 
    Average key length: 5.00, compression ratio: 0.60 
    Average prefix length: 0.89, average data length: 2.11 
    Clustering factor: 1, ratio: 0.11 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
PDISTR (146) 
    Primary pointer page: 516, Index root page: 517 
    Total formats: 1, used formats: 1 
    Average record length: 35.38, total records: 849921 
    Average version length: 37.93, total versions: 47347, max versions: 3 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 54.00, compression ratio: 1.53 
    Pointer pages: 6, data page slots: 8616 
    Data pages: 8616, average fill: 67% 
    Primary pages: 8614, secondary pages: 2, swept pages: 898 
    Empty pages: 2, full pages: 8494 
    Fill distribution: 
     0 - 19% = 5 
    20 - 39% = 3 
    40 - 59% = 4 
    60 - 79% = 8483 
    80 - 99% = 121 
 
    Index PDISTR_AGENT_ID (2) 
    Root page: 1509330, depth: 2, leaf buckets: 878, nodes: 822905 
    Average node length: 4.88, total dup: 822856, max dup: 152747 
    Average key length: 2.01, compression ratio: 4.48 
    Average prefix length: 8.99, average data length: 0.01 
    Clustering factor: 93122, ratio: 0.11 
    Fill distribution: 
         0 - 19% = 3 
        20 - 39% = 118 
        40 - 59% = 474 
        60 - 79% = 174 
        80 - 99% = 109 
 
    Index PDISTR_SNDOP_RCVOP_SNDID_ASC (0) 
    Root page: 1508635, depth: 3, leaf buckets: 1021, nodes: 822905 
    Average node length: 5.89, total dup: 732772, max dup: 42 
    Average key length: 3.02, compression ratio: 7.29 
    Average prefix length: 21.09, average data length: 0.91 
    Clustering factor: 165339, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 59 
        40 - 59% = 658 
        60 - 79% = 59 
        80 - 99% = 245 
 
    Index PDISTR_SNDOP_RCVOP_SNDID_DESC (1) 
    Root page: 1509209, depth: 3, leaf buckets: 1054, nodes: 822905 
    Average node length: 5.89, total dup: 732772, max dup: 42 
    Average key length: 3.02, compression ratio: 7.29 
    Average prefix length: 21.09, average data length: 0.91 
    Clustering factor: 167209, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 115 
        40 - 59% = 649 
        60 - 79% = 55 
        80 - 99% = 235 
 
    Index PDISTR_WORKER_SND_ID (3) 
    Root page: 1510200, depth: 3, leaf buckets: 1153, nodes: 822905 
    Average node length: 5.97, total dup: 732772, max dup: 42 
    Average key length: 3.10, compression ratio: 5.49 
    Average prefix length: 16.01, average data length: 0.99 
    Clustering factor: 159597, ratio: 0.19 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 259 
        40 - 59% = 583 
        60 - 79% = 197 
        80 - 99% = 112 
 
PERF_AGG (158) 
    Primary pointer page: 540, Index root page: 541 
    Total formats: 1, used formats: 1 
    Average record length: 63.00, total records: 5533 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 3.71, total fragments: 31, max fragments: 1 
    Average unpacked length: 379.00, compression ratio: 6.02 
    Pointer pages: 1, data page slots: 96 
    Data pages: 95, average fill: 58% 
    Primary pages: 80, secondary pages: 15, swept pages: 50 
    Empty pages: 10, full pages: 54 
    Fill distribution: 
     0 - 19% = 20 
    20 - 39% = 0 
    40 - 59% = 1 
    60 - 79% = 74 
    80 - 99% = 0 
 
    Index PERF_AGG_UNQ (1) 
    Root page: 1504260, depth: 2, leaf buckets: 6, nodes: 5533 
    Average node length: 5.51, total dup: 0, max dup: 0 
    Average key length: 3.57, compression ratio: 10.13 
    Average prefix length: 34.66, average data length: 1.54 
    Clustering factor: 5312, ratio: 0.96 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 0 
        40 - 59% = 4 
        60 - 79% = 0 
        80 - 99% = 2 
 
    Index PK_PERF_AGG (0) 
    Root page: 1504255, depth: 2, leaf buckets: 10, nodes: 5533 
    Average node length: 11.14, 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: 165, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 2 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 7 
 
PERF_ESTIMATED (280) 
    Primary pointer page: 399, Index root page: 434 
    Total formats: 1, used formats: 1 
    Average record length: 39.03, total records: 80770 
    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: 1, full pages: 838 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 1 
    40 - 59% = 0 
    60 - 79% = 838 
    80 - 99% = 0 
 
    Index PK_PERF_ESTIMATED (0) 
    Root page: 34196, depth: 2, leaf buckets: 103, nodes: 80770 
    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: 3088, ratio: 0.04 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 1 
        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: 110.49, 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.30 
    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: 124.13, total records: 187371 
    Average version length: 154.77, total versions: 35681, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 13.66 
    Pointer pages: 6, data page slots: 6160 
    Data pages: 4712, average fill: 85% 
    Primary pages: 4708, secondary pages: 4, swept pages: 1 
    Empty pages: 76, full pages: 4601 
    Fill distribution: 
     0 - 19% = 78 
    20 - 39% = 11 
    40 - 59% = 16 
    60 - 79% = 6 
    80 - 99% = 4601 
 
PERF_SPLIT_1 (282) 
    Primary pointer page: 603, Index root page: 604 
    Total formats: 1, used formats: 1 
    Average record length: 137.82, total records: 140585 
    Average version length: 154.26, total versions: 13005, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 12.31 
    Pointer pages: 7, data page slots: 4848 
    Data pages: 3544, average fill: 83% 
    Primary pages: 3541, secondary pages: 3, swept pages: 1 
    Empty pages: 73, full pages: 3444 
    Fill distribution: 
     0 - 19% = 80 
    20 - 39% = 10 
    40 - 59% = 3 
    60 - 79% = 7 
    80 - 99% = 3444 
 
PERF_SPLIT_2 (283) 
    Primary pointer page: 605, Index root page: 606 
    Total formats: 1, used formats: 1 
    Average record length: 132.78, total records: 165518 
    Average version length: 154.37, total versions: 21273, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 12.77 
    Pointer pages: 5, data page slots: 5312 
    Data pages: 4200, average fill: 83% 
    Primary pages: 4196, secondary pages: 4, swept pages: 1 
    Empty pages: 111, full pages: 4055 
    Fill distribution: 
     0 - 19% = 120 
    20 - 39% = 9 
    40 - 59% = 5 
    60 - 79% = 11 
    80 - 99% = 4055 
 
PERF_SPLIT_3 (284) 
    Primary pointer page: 607, Index root page: 616 
    Total formats: 1, used formats: 1 
    Average record length: 147.80, total records: 145007 
    Average version length: 150.74, total versions: 3460, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.48 
    Pointer pages: 8, data page slots: 5152 
    Data pages: 3616, average fill: 83% 
    Primary pages: 3612, secondary pages: 4, swept pages: 1 
    Empty pages: 47, full pages: 3554 
    Fill distribution: 
     0 - 19% = 48 
    20 - 39% = 6 
    40 - 59% = 3 
    60 - 79% = 4 
    80 - 99% = 3555 
 
PERF_SPLIT_4 (285) 
    Primary pointer page: 617, Index root page: 618 
    Total formats: 1, used formats: 1 
    Average record length: 148.88, total records: 139767 
    Average version length: 150.73, total versions: 1965, 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: 5256 
    Data pages: 3480, average fill: 83% 
    Primary pages: 3478, secondary pages: 2, swept pages: 3 
    Empty pages: 48, full pages: 3415 
    Fill distribution: 
     0 - 19% = 52 
    20 - 39% = 2 
    40 - 59% = 4 
    60 - 79% = 7 
    80 - 99% = 3415 
 
PERF_SPLIT_5 (286) 
    Primary pointer page: 619, Index root page: 620 
    Total formats: 1, used formats: 1 
    Average record length: 147.50, total records: 153568 
    Average version length: 151.57, total versions: 3939, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.50 
    Pointer pages: 6, data page slots: 4992 
    Data pages: 3864, average fill: 82% 
    Primary pages: 3862, secondary pages: 2, swept pages: 3 
    Empty pages: 74, full pages: 3763 
    Fill distribution: 
     0 - 19% = 81 
    20 - 39% = 12 
    40 - 59% = 3 
    60 - 79% = 4 
    80 - 99% = 3764 
 
PERF_SPLIT_6 (287) 
    Primary pointer page: 621, Index root page: 622 
    Total formats: 1, used formats: 1 
    Average record length: 138.76, total records: 164385 
    Average version length: 153.73, total versions: 14339, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 12.22 
    Pointer pages: 7, data page slots: 5080 
    Data pages: 4104, average fill: 84% 
    Primary pages: 4102, secondary pages: 2, swept pages: 1 
    Empty pages: 52, full pages: 4035 
    Fill distribution: 
     0 - 19% = 55 
    20 - 39% = 7 
    40 - 59% = 4 
    60 - 79% = 4 
    80 - 99% = 4034 
 
PERF_SPLIT_7 (288) 
    Primary pointer page: 626, Index root page: 627 
    Total formats: 1, used formats: 1 
    Average record length: 127.97, total records: 172655 
    Average version length: 154.63, total versions: 28042, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 13.25 
    Pointer pages: 6, data page slots: 5752 
    Data pages: 4320, average fill: 85% 
    Primary pages: 4318, secondary pages: 2, swept pages: 2 
    Empty pages: 53, full pages: 4234 
    Fill distribution: 
     0 - 19% = 58 
    20 - 39% = 4 
    40 - 59% = 19 
    60 - 79% = 4 
    80 - 99% = 4235 
 
PERF_SPLIT_8 (289) 
    Primary pointer page: 628, Index root page: 629 
    Total formats: 1, used formats: 1 
    Average record length: 130.54, total records: 173060 
    Average version length: 154.68, total versions: 24860, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 12.99 
    Pointer pages: 7, data page slots: 6104 
    Data pages: 4344, average fill: 84% 
    Primary pages: 4342, secondary pages: 2, swept pages: 1 
    Empty pages: 74, full pages: 4248 
    Fill distribution: 
     0 - 19% = 81 
    20 - 39% = 8 
    40 - 59% = 5 
    60 - 79% = 2 
    80 - 99% = 4248 
 
PERF_SPLIT_9 (290) 
    Primary pointer page: 630, Index root page: 631 
    Total formats: 1, used formats: 1 
    Average record length: 148.35, total records: 141552 
    Average version length: 149.14, total versions: 2515, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.43 
    Pointer pages: 5, data page slots: 4744 
    Data pages: 3544, average fill: 82% 
    Primary pages: 3541, secondary pages: 3, swept pages: 3 
    Empty pages: 59, full pages: 3461 
    Fill distribution: 
     0 - 19% = 65 
    20 - 39% = 6 
    40 - 59% = 5 
    60 - 79% = 8 
    80 - 99% = 3460 
 
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: 51.35, total records: 2126440 
    Average version length: 52.92, total versions: 68062, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 70.00, compression ratio: 1.36 
    Pointer pages: 16, data page slots: 25600 
    Data pages: 25592, average fill: 72% 
    Primary pages: 25583, secondary pages: 9, swept pages: 8276 
    Empty pages: 47, full pages: 24345 
    Fill distribution: 
     0 - 19% = 97 
    20 - 39% = 110 
    40 - 59% = 333 
    60 - 79% = 24342 
    80 - 99% = 710 
 
    Index PSTORNED_RCV_ID (1) 
    Root page: 1506208, depth: 3, leaf buckets: 2599, nodes: 2126440 
    Average node length: 5.44, total dup: 1984770, max dup: 1602 
    Average key length: 2.49, compression ratio: 3.62 
    Average prefix length: 8.58, average data length: 0.42 
    Clustering factor: 184142, ratio: 0.09 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 275 
        40 - 59% = 1695 
        60 - 79% = 346 
        80 - 99% = 281 
 
    Index PSTORNED_SND_ID (0) 
    Root page: 1504841, depth: 3, leaf buckets: 2755, nodes: 2126440 
    Average node length: 5.69, total dup: 1909461, max dup: 71 
    Average key length: 2.74, compression ratio: 3.29 
    Average prefix length: 8.37, average data length: 0.63 
    Clustering factor: 380477, ratio: 0.18 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 3 
        40 - 59% = 2376 
        60 - 79% = 350 
        80 - 99% = 26 
 
    Index PSTORNED_WORKER_ID (2) 
    Root page: 1508018, depth: 3, leaf buckets: 2111, nodes: 2126440 
    Average node length: 4.96, total dup: 2126340, max dup: 28445 
    Average key length: 2.00, compression ratio: 1.20 
    Average prefix length: 2.40, average data length: 0.00 
    Clustering factor: 181781, ratio: 0.09 
    Fill distribution: 
         0 - 19% = 3 
        20 - 39% = 165 
        40 - 59% = 1063 
        60 - 79% = 424 
        80 - 99% = 456 
 
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: 38.93, total records: 165551 
    Average version length: 69.18, total versions: 83292, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 3.24 
    Pointer pages: 3, data page slots: 3856 
    Data pages: 3072, average fill: 66% 
    Primary pages: 3072, secondary pages: 0, swept pages: 360 
    Empty pages: 486, full pages: 2395 
    Fill distribution: 
     0 - 19% = 594 
    20 - 39% = 10 
    40 - 59% = 15 
    60 - 79% = 929 
    80 - 99% = 1524 
 
    Index XQD_1000_1200_WA_SO_RO_WKR_SND (0) 
    Root page: 104242, depth: 3, leaf buckets: 234, nodes: 165551 
    Average node length: 6.47, total dup: 144286, max dup: 14 
    Average key length: 3.90, compression ratio: 10.76 
    Average prefix length: 40.22, average data length: 1.78 
    Clustering factor: 29051, ratio: 0.18 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 27 
        40 - 59% = 114 
        60 - 79% = 73 
        80 - 99% = 19 
 
XQD_1000_3300 (178) 
    Primary pointer page: 581, Index root page: 582 
    Total formats: 1, used formats: 1 
    Average record length: 64.21, total records: 7352673 
    Average version length: 68.80, total versions: 582603, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.96 
    Pointer pages: 66, data page slots: 106184 
    Data pages: 106184, average fill: 75% 
    Primary pages: 106184, secondary pages: 0, swept pages: 7523 
    Empty pages: 9, full pages: 102929 
    Fill distribution: 
     0 - 19% = 159 
    20 - 39% = 562 
    40 - 59% = 1161 
    60 - 79% = 100480 
    80 - 99% = 3822 
 
    Index XQD_1000_3300_WA_SO_RO_WKR_SND (0) 
    Root page: 1480476, depth: 3, leaf buckets: 10804, nodes: 7352673 
    Average node length: 6.51, total dup: 6362750, max dup: 29 
    Average key length: 3.51, compression ratio: 11.95 
    Average prefix length: 40.62, average data length: 1.38 
    Clustering factor: 1740981, ratio: 0.24 
    Fill distribution: 
         0 - 19% = 7 
        20 - 39% = 1325 
        40 - 59% = 5874 
        60 - 79% = 2971 
        80 - 99% = 627 
 
    Index XQD_1000_3300_WKR_DOC_ASC (1) 
    Root page: 1486090, depth: 3, leaf buckets: 8781, nodes: 7352673 
    Average node length: 5.39, total dup: 7066055, max dup: 172 
    Average key length: 2.40, compression ratio: 7.09 
    Average prefix length: 16.64, average data length: 0.36 
    Clustering factor: 1531791, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 6 
        20 - 39% = 998 
        40 - 59% = 5129 
        60 - 79% = 1592 
        80 - 99% = 1056 
 
    Index XQD_1000_3300_WKR_DOC_DEC (2) 
    Root page: 1490630, depth: 3, leaf buckets: 8838, nodes: 7352673 
    Average node length: 5.39, total dup: 7066055, max dup: 172 
    Average key length: 2.40, compression ratio: 7.09 
    Average prefix length: 16.64, average data length: 0.36 
    Clustering factor: 1534227, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 8 
        20 - 39% = 1050 
        40 - 59% = 5103 
        60 - 79% = 1645 
        80 - 99% = 1032 
 
XQD_1200_2000 (177) 
    Primary pointer page: 579, Index root page: 580 
    Total formats: 1, used formats: 1 
    Average record length: 66.58, total records: 12373909 
    Average version length: 68.74, total versions: 485261, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.89 
    Pointer pages: 108, data page slots: 175984 
    Data pages: 175944, average fill: 75% 
    Primary pages: 175944, secondary pages: 0, swept pages: 46439 
    Empty pages: 13, full pages: 175672 
    Fill distribution: 
     0 - 19% = 14 
    20 - 39% = 2 
    40 - 59% = 12 
    60 - 79% = 171242 
    80 - 99% = 4674 
 
    Index XQD_1200_2000_WA_SO_RO_WKR_SND (0) 
    Root page: 1495050, depth: 3, leaf buckets: 18534, nodes: 12369062 
    Average node length: 6.62, total dup: 10782947, max dup: 63 
    Average key length: 3.42, compression ratio: 12.27 
    Average prefix length: 40.70, average data length: 1.30 
    Clustering factor: 2528440, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 20 
        20 - 39% = 1818 
        40 - 59% = 10761 
        60 - 79% = 5085 
        80 - 99% = 850 
 
XQD_2000_3300 (179) 
    Primary pointer page: 583, Index root page: 584 
    Total formats: 1, used formats: 1 
    Average record length: 37.82, total records: 1997124 
    Average version length: 69.09, total versions: 583065, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 3.33 
    Pointer pages: 29, data page slots: 44680 
    Data pages: 28400, average fill: 69% 
    Primary pages: 28321, secondary pages: 79, swept pages: 711 
    Empty pages: 87, full pages: 28057 
    Fill distribution: 
     0 - 19% = 176 
    20 - 39% = 4449 
    40 - 59% = 2314 
    60 - 79% = 12740 
    80 - 99% = 8721 
 
    Index XQD_2000_3300_WA_SO_RO_WKR_SND (0) 
    Root page: 1479735, depth: 3, leaf buckets: 1880, nodes: 1539942 
    Average node length: 5.52, total dup: 1477751, max dup: 49 
    Average key length: 2.56, compression ratio: 16.42 
    Average prefix length: 41.48, average data length: 0.52 
    Clustering factor: 109348, ratio: 0.07 
    Fill distribution: 
         0 - 19% = 19 
        20 - 39% = 221 
        40 - 59% = 925 
        60 - 79% = 523 
        80 - 99% = 192 
 
XQD_2100_3300 (180) 
    Primary pointer page: 585, Index root page: 586 
    Total formats: 1, used formats: 1 
    Average record length: 32.14, total records: 1618590 
    Average version length: 69.02, total versions: 197086, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 3.92 
    Pointer pages: 20, data page slots: 32496 
    Data pages: 25968, average fill: 46% 
    Primary pages: 25968, secondary pages: 0, swept pages: 4211 
    Empty pages: 4448, full pages: 17146 
    Fill distribution: 
     0 - 19% = 6271 
    20 - 39% = 2302 
    40 - 59% = 5993 
    60 - 79% = 10558 
    80 - 99% = 844 
 
    Index XQD_2100_3300_WA_SO_RO_WKR_SND (0) 
    Root page: 1479229, depth: 3, leaf buckets: 1132, nodes: 820851 
    Average node length: 5.94, total dup: 755957, max dup: 86 
    Average key length: 3.00, compression ratio: 13.99 
    Average prefix length: 41.08, average data length: 0.92 
    Clustering factor: 121828, ratio: 0.15 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 198 
        40 - 59% = 550 
        60 - 79% = 331 
        80 - 99% = 52 
 
XQD_3300_3400 (181) 
    Primary pointer page: 587, Index root page: 588 
    Total formats: 1, used formats: 1 
    Average record length: 64.33, total records: 9429733 
    Average version length: 68.97, total versions: 709273, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.96 
    Pointer pages: 89, data page slots: 145072 
    Data pages: 145056, average fill: 70% 
    Primary pages: 145035, secondary pages: 21, swept pages: 28504 
    Empty pages: 320, full pages: 107046 
    Fill distribution: 
     0 - 19% = 1040 
    20 - 39% = 5046 
    40 - 59% = 15825 
    60 - 79% = 116887 
    80 - 99% = 6258 
 
    Index XQD_3300_3400_WA_SO_RO_WKR_SND (0) 
    Root page: 1472612, depth: 3, leaf buckets: 13464, nodes: 9419353 
    Average node length: 6.68, total dup: 7816726, max dup: 19 
    Average key length: 3.66, compression ratio: 11.47 
    Average prefix length: 40.51, average data length: 1.49 
    Clustering factor: 2111453, ratio: 0.22 
    Fill distribution: 
         0 - 19% = 3 
        20 - 39% = 1019 
        40 - 59% = 6511 
        60 - 79% = 5135 
        80 - 99% = 796 
 
XQS_1000_1200 (182) 
    Primary pointer page: 589, Index root page: 590 
    Total formats: 1, used formats: 1 
    Average record length: 82.47, total records: 21183405 
    Average version length: 82.93, total versions: 21207, 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: 320152 
    Data pages: 320152, average fill: 81% 
    Primary pages: 320148, secondary pages: 4, swept pages: 11538 
    Empty pages: 3, full pages: 320145 
    Fill distribution: 
     0 - 19% = 5 
    20 - 39% = 1 
    40 - 59% = 0 
    60 - 79% = 48885 
    80 - 99% = 271261 
 
    Index XQS_1000_1200_DOC_ID (1) 
    Root page: 1426738, depth: 3, leaf buckets: 19582, nodes: 21183405 
    Average node length: 5.72, total dup: 20701934, max dup: 132 
    Average key length: 2.16, compression ratio: 4.16 
    Average prefix length: 8.86, average data length: 0.14 
    Clustering factor: 3289985, ratio: 0.16 
    Fill distribution: 
         0 - 19% = 11 
        20 - 39% = 0 
        40 - 59% = 8471 
        60 - 79% = 562 
        80 - 99% = 10538 
 
    Index XQS_1000_1200_RCV_ID (3) 
    Root page: 1457002, depth: 3, leaf buckets: 17217, nodes: 21183405 
    Average node length: 6.31, total dup: 18616010, max dup: 49 
    Average key length: 2.75, compression ratio: 3.27 
    Average prefix length: 8.37, average data length: 0.63 
    Clustering factor: 921034, ratio: 0.04 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 4 
        40 - 59% = 806 
        60 - 79% = 295 
        80 - 99% = 16111 
 
    Index XQS_1000_1200_SND_ID (2) 
    Root page: 1441095, depth: 3, leaf buckets: 21348, nodes: 21183405 
    Average node length: 6.35, total dup: 18535177, max dup: 29 
    Average key length: 2.79, compression ratio: 3.23 
    Average prefix length: 8.34, average data length: 0.66 
    Clustering factor: 3584689, ratio: 0.17 
    Fill distribution: 
         0 - 19% = 8 
        20 - 39% = 4 
        40 - 59% = 8724 
        60 - 79% = 601 
        80 - 99% = 12011 
 
    Index XQS_1000_1200_WORKER_ID (0) 
    Root page: 1413370, depth: 3, leaf buckets: 16118, nodes: 21183405 
    Average node length: 5.56, total dup: 21183305, max dup: 230856 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.42, average data length: 0.00 
    Clustering factor: 949722, ratio: 0.04 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 7 
        40 - 59% = 2900 
        60 - 79% = 361 
        80 - 99% = 12850 
 
XQS_1000_3300 (184) 
    Primary pointer page: 593, Index root page: 594 
    Total formats: 1, used formats: 1 
    Average record length: 77.10, total records: 9878591 
    Average version length: 82.62, total versions: 715700, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.63 
    Pointer pages: 106, data page slots: 172816 
    Data pages: 172800, average fill: 71% 
    Primary pages: 172771, secondary pages: 29, swept pages: 44855 
    Empty pages: 500, full pages: 121352 
    Fill distribution: 
     0 - 19% = 1486 
    20 - 39% = 6925 
    40 - 59% = 22689 
    60 - 79% = 110508 
    80 - 99% = 31192 
 
    Index XQS_1000_3300_DOC_ID (1) 
    Root page: 1367524, depth: 3, leaf buckets: 11333, nodes: 9878591 
    Average node length: 5.37, total dup: 9569796, max dup: 206 
    Average key length: 2.23, compression ratio: 4.04 
    Average prefix length: 8.80, average data length: 0.20 
    Clustering factor: 2202921, ratio: 0.22 
    Fill distribution: 
         0 - 19% = 3 
        20 - 39% = 63 
        40 - 59% = 7534 
        60 - 79% = 3615 
        80 - 99% = 118 
 
    Index XQS_1000_3300_RCV_ID (3) 
    Root page: 1379283, depth: 3, leaf buckets: 13735, nodes: 9878591 
    Average node length: 6.24, total dup: 8192063, max dup: 14 
    Average key length: 3.10, compression ratio: 2.90 
    Average prefix length: 8.07, average data length: 0.93 
    Clustering factor: 1548479, ratio: 0.16 
    Fill distribution: 
         0 - 19% = 128 
        20 - 39% = 3703 
        40 - 59% = 4852 
        60 - 79% = 2648 
        80 - 99% = 2404 
 
    Index XQS_1000_3300_SND_ID (2) 
    Root page: 1373081, depth: 3, leaf buckets: 12646, nodes: 9878591 
    Average node length: 5.98, total dup: 8582725, max dup: 44 
    Average key length: 2.84, compression ratio: 3.17 
    Average prefix length: 8.29, average data length: 0.71 
    Clustering factor: 2402333, ratio: 0.24 
    Fill distribution: 
         0 - 19% = 3 
        20 - 39% = 48 
        40 - 59% = 8555 
        60 - 79% = 3900 
        80 - 99% = 140 
 
    Index XQS_1000_3300_WORKER_ID (0) 
    Root page: 1362789, depth: 3, leaf buckets: 10255, nodes: 9878591 
    Average node length: 5.14, total dup: 9878491, max dup: 148623 
    Average key length: 2.00, compression ratio: 1.20 
    Average prefix length: 2.41, average data length: 0.00 
    Clustering factor: 1567504, ratio: 0.16 
    Fill distribution: 
         0 - 19% = 39 
        20 - 39% = 1178 
        40 - 59% = 5146 
        60 - 79% = 1747 
        80 - 99% = 2145 
 
XQS_1200_2000 (183) 
    Primary pointer page: 591, Index root page: 592 
    Total formats: 1, used formats: 1 
    Average record length: 78.72, total records: 11415373 
    Average version length: 82.52, total versions: 555931, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.60 
    Pointer pages: 119, data page slots: 192912 
    Data pages: 191384, average fill: 74% 
    Primary pages: 191269, secondary pages: 115, swept pages: 52405 
    Empty pages: 2615, full pages: 155290 
    Fill distribution: 
     0 - 19% = 4112 
    20 - 39% = 5736 
    40 - 59% = 14128 
    60 - 79% = 96349 
    80 - 99% = 71059 
 
    Index XQS_1200_2000_DOC_ID (1) 
    Root page: 1392123, depth: 3, leaf buckets: 13103, nodes: 11415373 
    Average node length: 5.29, total dup: 11305888, max dup: 682 
    Average key length: 2.08, compression ratio: 4.33 
    Average prefix length: 8.93, average data length: 0.07 
    Clustering factor: 2399337, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 79 
        40 - 59% = 8941 
        60 - 79% = 3970 
        80 - 99% = 113 
 
    Index XQS_1200_2000_RCV_ID (3) 
    Root page: 1406132, depth: 3, leaf buckets: 10506, nodes: 11415373 
    Average node length: 5.49, total dup: 10917862, max dup: 49 
    Average key length: 2.28, compression ratio: 3.95 
    Average prefix length: 8.77, average data length: 0.23 
    Clustering factor: 740700, ratio: 0.06 
    Fill distribution: 
         0 - 19% = 157 
        20 - 39% = 826 
        40 - 59% = 2591 
        60 - 79% = 1886 
        80 - 99% = 5046 
 
    Index XQS_1200_2000_SND_ID (2) 
    Root page: 1398660, depth: 3, leaf buckets: 14987, nodes: 11415373 
    Average node length: 6.02, total dup: 9968329, max dup: 66 
    Average key length: 2.80, compression ratio: 3.21 
    Average prefix length: 8.33, average data length: 0.67 
    Clustering factor: 2415761, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 3 
        20 - 39% = 97 
        40 - 59% = 10485 
        60 - 79% = 4243 
        80 - 99% = 159 
 
    Index XQS_1200_2000_WORKER_ID (0) 
    Root page: 1386233, depth: 3, leaf buckets: 10877, nodes: 11415373 
    Average node length: 5.22, total dup: 11415273, max dup: 187958 
    Average key length: 2.00, compression ratio: 1.20 
    Average prefix length: 2.41, average data length: 0.00 
    Clustering factor: 728634, ratio: 0.06 
    Fill distribution: 
         0 - 19% = 91 
        20 - 39% = 793 
        40 - 59% = 4936 
        60 - 79% = 1542 
        80 - 99% = 3515 
 
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: 77.48, total records: 9990938 
    Average version length: 82.91, total versions: 712138, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.63 
    Pointer pages: 109, data page slots: 176480 
    Data pages: 176400, average fill: 71% 
    Primary pages: 176375, secondary pages: 25, swept pages: 48798 
    Empty pages: 460, full pages: 117952 
    Fill distribution: 
     0 - 19% = 1538 
    20 - 39% = 7316 
    40 - 59% = 24294 
    60 - 79% = 112857 
    80 - 99% = 30395 
 
    Index XQS_2100_3300_DOC_ID (1) 
    Root page: 1344708, depth: 3, leaf buckets: 11983, nodes: 9990938 
    Average node length: 5.18, total dup: 9961795, max dup: 1703 
    Average key length: 2.03, compression ratio: 4.43 
    Average prefix length: 8.97, average data length: 0.03 
    Clustering factor: 2019008, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 28 
        20 - 39% = 1470 
        40 - 59% = 7874 
        60 - 79% = 2000 
        80 - 99% = 611 
 
    Index XQS_2100_3300_RCV_ID (3) 
    Root page: 1355739, depth: 3, leaf buckets: 13936, nodes: 9990938 
    Average node length: 6.25, total dup: 8284446, max dup: 14 
    Average key length: 3.10, compression ratio: 2.90 
    Average prefix length: 8.07, average data length: 0.93 
    Clustering factor: 1517777, ratio: 0.15 
    Fill distribution: 
         0 - 19% = 242 
        20 - 39% = 3682 
        40 - 59% = 4855 
        60 - 79% = 2606 
        80 - 99% = 2551 
 
    Index XQS_2100_3300_SND_ID (2) 
    Root page: 1350071, depth: 3, leaf buckets: 12581, nodes: 9990938 
    Average node length: 5.44, total dup: 9547174, max dup: 115 
    Average key length: 2.28, compression ratio: 3.94 
    Average prefix length: 8.76, average data length: 0.24 
    Clustering factor: 2155433, ratio: 0.22 
    Fill distribution: 
         0 - 19% = 35 
        20 - 39% = 1332 
        40 - 59% = 8814 
        60 - 79% = 1789 
        80 - 99% = 611 
 
    Index XQS_2100_3300_WORKER_ID (0) 
    Root page: 987843, depth: 3, leaf buckets: 10418, nodes: 9990938 
    Average node length: 5.16, total dup: 9990838, max dup: 150743 
    Average key length: 2.00, compression ratio: 1.20 
    Average prefix length: 2.40, average data length: 0.00 
    Clustering factor: 1593055, ratio: 0.16 
    Fill distribution: 
         0 - 19% = 44 
        20 - 39% = 1226 
        40 - 59% = 5262 
        60 - 79% = 1674 
        80 - 99% = 2212 
 
XQS_3300_3400 (187) 
    Primary pointer page: 599, Index root page: 600 
    Total formats: 1, used formats: 1 
    Average record length: 66.95, total records: 580636 
    Average version length: 68.84, total versions: 11916, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.88 
    Pointer pages: 5, data page slots: 8048 
    Data pages: 8048, average fill: 76% 
    Primary pages: 8048, secondary pages: 0, swept pages: 2493 
    Empty pages: 4, full pages: 7720 
    Fill distribution: 
     0 - 19% = 5 
    20 - 39% = 0 
    40 - 59% = 36 
    60 - 79% = 7781 
    80 - 99% = 226 
 
    Index XQS_3300_3400_DOC_ID (1) 
    Root page: 36966, depth: 3, leaf buckets: 739, nodes: 580636 
    Average node length: 5.95, total dup: 494191, max dup: 83 
    Average key length: 3.09, compression ratio: 2.91 
    Average prefix length: 8.05, average data length: 0.95 
    Clustering factor: 102331, ratio: 0.18 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 30 
        40 - 59% = 518 
        60 - 79% = 92 
        80 - 99% = 99 
 
    Index XQS_3300_3400_SND_ID (2) 
    Root page: 30097, depth: 3, leaf buckets: 758, nodes: 580636 
    Average node length: 6.15, total dup: 476036, max dup: 25 
    Average key length: 3.29, compression ratio: 2.73 
    Average prefix length: 7.88, average data length: 1.12 
    Clustering factor: 102380, ratio: 0.18 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 17 
        40 - 59% = 536 
        60 - 79% = 99 
        80 - 99% = 105 
 
    Index XQS_3300_3400_WORKER_ID (0) 
    Root page: 377587, depth: 2, leaf buckets: 562, nodes: 580636 
    Average node length: 4.86, total dup: 580536, max dup: 9820 
    Average key length: 2.00, compression ratio: 1.20 
    Average prefix length: 2.41, average data length: 0.00 
    Clustering factor: 90998, ratio: 0.16 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 31 
        40 - 59% = 317 
        60 - 79% = 74 
        80 - 99% = 139 
 
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 Mon Mar 25 07:09:37 2024

Record versions statistics, table

TABLE_NAME TOTAL_RECS TOTAL_VERS MAX_VERSIONS VERS_TO_RECS_PRC MAXV_TO_VERS_PRC
DOC_DATA 7812491 148272 1 0.0000 0.0000
DOC_LIST 2274599 78106 2 0.0000 0.0000
FB_ERRORS 2182 757 1 0.0000 0.0000
INVNT_SALDO 400 2266 6 500.0000 0.0000
INVNT_TURNOVER_LOG 119523 106775 1 0.0000 0.0000
MONEY_SALDO 49 250 8 500.0000 0.0000
MONEY_TURNOVER_LOG 1790 1646 1 0.0000 0.0000
PDISTR 849921 47347 3 0.0000 0.0000
PERF_SPLIT_0 187371 35681 1 0.0000 0.0000
PERF_SPLIT_1 140585 13005 1 0.0000 0.0000
PERF_SPLIT_2 165518 21273 1 0.0000 0.0000
PERF_SPLIT_3 145007 3460 1 0.0000 0.0000
PERF_SPLIT_4 139767 1965 1 0.0000 0.0000
PERF_SPLIT_5 153568 3939 1 0.0000 0.0000
PERF_SPLIT_6 164385 14339 1 0.0000 0.0000
PERF_SPLIT_7 172655 28042 1 0.0000 0.0000
PERF_SPLIT_8 173060 24860 1 0.0000 0.0000
PERF_SPLIT_9 141552 2515 1 0.0000 0.0000
PSTORNED 2126440 68062 1 0.0000 0.0000
SEMAPHORES 5 1 1 0.0000 100.0000
XQD_1000_1200 165551 83292 1 0.0000 0.0000
XQD_1000_3300 7352673 582603 1 0.0000 0.0000
XQD_1200_2000 12373909 485261 1 0.0000 0.0000
XQD_2000_3300 1997124 583065 1 0.0000 0.0000
XQD_2100_3300 1618590 197086 1 0.0000 0.0000
XQD_3300_3400 9429733 709273 1 0.0000 0.0000
XQS_1000_1200 21183405 21207 1 0.0000 0.0000
XQS_1000_3300 9878591 715700 1 0.0000 0.0000
XQS_1200_2000 11415373 555931 1 0.0000 0.0000
XQS_2100_3300 9990938 712138 1 0.0000 0.0000
XQS_3300_3400 580636 11916 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 ---
:102: 
:103: mscs-test-161.budzdorov.ru    Mon Mar 25 07:08:03 2024
:104:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3400
:105: 
--- end of diff output ---

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

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