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

Hardware and OS info

Command: hostnamectl
Static hostname mscs-test-161.budzdorov.ru
Icon name computer-server
Chassis server
Machine ID aeee285d2cca40bf84c40a748f599e77
Boot ID 2a7b53d1c5ed44b9bb2712fffac5d8c6
Operating System CentOS Linux 7 (Core)
CPE OS Name cpe:/o:centos:centos:7
Kernel Linux 3.10.0-1127.10.1.el7.x86_64
Architecture x86-64
Command: who -b
bootup_info system boot 2021-11-11 18:28
Command: dmidecode -t system|grep -i -e 'manufacturer\|product\|hypervisor'
Manufacturer HP
Product Name ProLiant DL380 Gen9
Command: dmesg | grep DMI
[ 0.000000] DMI HP ProLiant DL380 Gen9/ProLiant DL380 Gen9, BIOS P89 05/21/2018
Command: lscpu | grep -i -v flags
Architecture x86_64
CPU op-mode(s) 32-bit, 64-bit
Byte Order Little Endian
CPU(s) 24
On-line CPU(s) list 0-23
Thread(s) per core 2
Core(s) per socket 6
Socket(s) 2
NUMA node(s) 2
Vendor ID GenuineIntel
CPU family 6
Model 63
Model name Intel(R) Xeon(R) CPU E5-2620 v3 @ 2.40GHz
Stepping 2
CPU MHz 1200.000
CPU max MHz 2400.0000
CPU min MHz 1200.0000
BogoMIPS 4794.33
Virtualization VT-x
L1d cache 32K
L1i cache 32K
L2 cache 256K
L3 cache 15360K
NUMA node0 CPU(s) 0-5,12-17
NUMA node1 CPU(s) 6-11,18-23
Command: cat /proc/meminfo | grep -i -e 'memtotal\|memfree\|memavail\|buffers\|cached\|swapcached'
MemTotal 32643792 kB
MemFree 15850684 kB
MemAvailable 30302852 kB
Buffers 0 kB
Cached 15908036 kB
SwapCached 2708 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-18 10:07:51
DTS_END                         2024-03-18 10:07:51.1370
FB_GDSCODE                      -1
FB_MNEMONA                      
STACK                           SP_ADD_INVOICE_TO_STOCK(190:30) ==> SP_CUSTOMER_RESERVE(47:5) ==> SP_CHECK_TO_STOP_WORK(32:12) ==> SP_HALT_ON_ERROR(68:17)
IP                              ::1/39748
TRN_ID                          176365
ATT_ID                          533
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: 9235.42 18295 923542
customer order: creation 188.56 399 18856
customer order: refuse 16.14 338 1614
order to supplier: creation 50.54 1213 5054
order to supplier: removal 3.51 88151 351
invoice (draft): creation 49.10 2927 4910
invoice (draft): removal 48.30 713 4830
invoice accept: apply 45.35 22305 4535
invoice accept: cancel 43.85 812 4385
customer reserve: creation 4249.27 220 424927
customer reserve: removal 4230.36 59 423036
realization accept: apply 93.26 176 9326
realization accept: cancel 76.09 134 7609
payment from customer: creation 65.72 116 6572
payment from customer: removal 5.89 95 589
payment to supplier: creation 53.60 123 5360
payment to supplier: removal 4.06 80 406
service: total inventory turnovers 4.44 3549 444
service: total monetary turnovers 6.47 620 647
service: aggregate perf. data 0.88 16571 88
service: refresh index statistics 0.03 227295 3

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:02, from 18-03-2024 10:09:25 to 18-03-2024 10:09:27.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 2234
TEST_TIME 2 3170
TEST_TIME 3 5050
TEST_TIME 4 4599
TEST_TIME 5 4699
TEST_TIME 6 4917
TEST_TIME 7 5051
TEST_TIME 8 5167
TEST_TIME 9 5387
TEST_TIME 10 5900
TEST_TIME 11 5935
TEST_TIME 12 6009
TEST_TIME 13 6189
TEST_TIME 14 6456
TEST_TIME 15 6705
TEST_TIME 16 6944
TEST_TIME 17 7864
TEST_TIME 18 7910
TEST_TIME 19 7917
TEST_TIME 20 7921
TEST_TIME 21 8624
TEST_TIME 22 8876
TEST_TIME 23 9187
TEST_TIME 24 9196
TEST_TIME 25 9529
TEST_TIME 26 9998
TEST_TIME 27 9960
TEST_TIME 28 9955
TEST_TIME 29 9926
TEST_TIME 30 9778
TEST_TIME 31 9823
TEST_TIME 32 9918
TEST_TIME 33 9837
TEST_TIME 34 9584
TEST_TIME 35 9514
TEST_TIME 36 9366
TEST_TIME 37 9328
TEST_TIME 38 9317
TEST_TIME 39 9307
TEST_TIME 40 9508
TEST_TIME 41 9519
TEST_TIME 42 9380
TEST_TIME 43 9394
TEST_TIME 44 9509
TEST_TIME 45 9531
TEST_TIME 46 9532
TEST_TIME 47 9625
TEST_TIME 48 9766
TEST_TIME 49 9742
TEST_TIME 50 9731
TEST_TIME 51 9856
TEST_TIME 52 9854
TEST_TIME 53 9928
TEST_TIME 54 9894
TEST_TIME 55 9799
TEST_TIME 56 9742
TEST_TIME 57 9610
TEST_TIME 58 9556
TEST_TIME 59 9591
TEST_TIME 60 9569
TEST_TIME 61 9500
TEST_TIME 62 9442
TEST_TIME 63 9420
TEST_TIME 64 9359
TEST_TIME 65 9364
TEST_TIME 66 9348
TEST_TIME 67 9480
TEST_TIME 68 9476
TEST_TIME 69 9486
TEST_TIME 70 9484
TEST_TIME 71 9507
TEST_TIME 72 9557
TEST_TIME 73 9623
TEST_TIME 74 9619
TEST_TIME 75 9663
TEST_TIME 76 9749
TEST_TIME 77 9643
TEST_TIME 78 9543
TEST_TIME 79 9526
TEST_TIME 80 9486
TEST_TIME 81 9426
TEST_TIME 82 9379
TEST_TIME 83 9370
TEST_TIME 84 9365
TEST_TIME 85 9357
TEST_TIME 86 9400
TEST_TIME 87 9379
TEST_TIME 88 9390
TEST_TIME 89 9387
TEST_TIME 90 9387
TEST_TIME 91 9408
TEST_TIME 92 9402
TEST_TIME 93 9385
TEST_TIME 94 9401
TEST_TIME 95 9330
TEST_TIME 96 9301
TEST_TIME 97 9282
TEST_TIME 98 9274
TEST_TIME 99 9238
TEST_TIME 100 9237

Performance per minute, chart


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

Performance in DETAILS

UNIT CNT_ALL CNT_OK CNT_ERR ERR_PRC OK_MIN_MS OK_MAX_MS OK_AVG_MS CNT_LK_CONFL CNT_USER_EXC
doc_list_aiud 1314693 1314693 0 0.00 0 23958 8 0 0
doc_list_biud 1314693 1314693 0 0.00 0 29162 24 0 0
sp_add_invoice_to_stock 4613 4535 78 1.69 35 270106 22306 0 78
sp_cancel_adding_invoice 4385 4385 0 0.00 4 61825 812 0 0
sp_cancel_client_order 1614 1614 0 0.00 4 8538 338 0 0
sp_cancel_customer_reserve 423036 423036 0 0.00 0 24186 59 0 0
sp_cancel_pay_from_customer 589 589 0 0.00 2 7156 96 0 0
sp_cancel_pay_to_supplier 406 406 0 0.00 2 4563 80 0 0
sp_cancel_supplier_invoice 4835 4830 5 0.10 2 19709 713 0 5
sp_cancel_supplier_order 351 351 0 0.00 6 936841 88152 0 0
sp_cancel_write_off 7609 7609 0 0.00 1 8390 134 0 0
sp_client_order 18856 18856 0 0.00 3 33220 400 0 0
sp_customer_reserve 424927 424927 0 0.00 0 91413 221 0 0
sp_fill_shopping_cart 28801 28801 0 0.00 1 37286 34 0 0
sp_fill_shopping_cart_clo_res 424923 424923 0 0.00 0 23278 17 0 0
sp_get_clo_for_invoice 4531 4531 0 0.00 0 26896 372 0 0
sp_kill_cost_storno 12989 12989 0 0.00 0 9925 70 0 0
sp_kill_qstorno_ret_qs2qd 858862 858862 0 0.00 0 21239 32 0 0
sp_kill_qty_storno 455682 455682 0 0.00 0 29161 68 0 0
sp_lock_selected_doc 19063 19063 0 0.00 0 9210 5 0 0
sp_make_cost_storno 25789 25789 0 0.00 0 14243 61 0 0
sp_multiply_rows_for_pdistr 25789 25789 0 0.00 0 8495 34 0 0
sp_multiply_rows_for_qdistr 18856 18856 0 0.00 0 20566 215 0 0
sp_pay_from_customer 6572 6572 0 0.00 3 16504 116 0 0
sp_pay_to_supplier 5360 5360 0 0.00 4 13630 124 0 0
sp_payment_common 11932 11932 0 0.00 1 16494 21 0 0
sp_qd_handle_on_cancel_clo 1614 1614 0 0.00 0 8525 309 0 0
sp_qd_handle_on_invoice_upd_sts 8916 8916 0 0.00 0 29161 296 0 0
sp_qd_handle_on_reserve_upd_sts 9326 9326 0 0.00 0 8999 45 0 0
sp_reserve_write_off 9326 9326 0 0.00 6 13422 176 0 0
sp_supplier_invoice 4910 4910 0 0.00 5 81660 2927 0 0
sp_supplier_order 5054 5054 0 0.00 5 43726 1214 0 0
srv_aggregate_perf_data 88 88 0 0.00 1920 211006 16572 0 0
srv_fill_mon_cache_memory 58 58 0 0.00 2131 165304 39093 0 0
srv_find_qd_qs_mism 878733 878733 0 0.00 0 23958 8 0 0
srv_make_invnt_saldo 444 444 0 0.00 35 115256 3550 0 0
srv_make_money_saldo 647 647 0 0.00 1 13918 620 0 0
srv_recalc_idx_stat 3 3 0 0.00 93591 411155 227295 0 0
t$perf-abend:sp_add_invoice_to_stock 78 78 0 0.00 0 0 0 0 0
t$perf-abend:sp_cancel_supplier_invoice 5 5 0 0.00 0 0 0 0 0
t$perf-norm:sp_add_invoice_to_stock 4535 4535 0 0.00 0 10861 169 0 0
t$perf-norm:sp_cancel_adding_invoice 400 400 0 0.00 0 2371 80 0 0
t$perf-norm:sp_cancel_client_order 1614 1614 0 0.00 0 4959 16 0 0
t$perf-norm:sp_cancel_customer_reserve 615 615 0 0.00 0 2496 16 0 0
t$perf-norm:sp_cancel_pay_from_customer 589 589 0 0.00 0 2016 12 0 0
t$perf-norm:sp_cancel_pay_to_supplier 406 406 0 0.00 0 257 3 0 0
t$perf-norm:sp_cancel_supplier_invoice 356 356 0 0.00 0 1365 15 0 0
t$perf-norm:sp_cancel_supplier_order 351 351 0 0.00 0 26828 1608 0 0
t$perf-norm:sp_cancel_write_off 875 875 0 0.00 0 1026 5 0 0
t$perf-norm:sp_client_order 18856 18856 0 0.00 0 6444 15 0 0
t$perf-norm:sp_customer_reserve 928 928 0 0.00 0 1150 6 0 0
t$perf-norm:sp_pay_from_customer 6572 6572 0 0.00 0 4184 8 0 0
t$perf-norm:sp_pay_to_supplier 5360 5360 0 0.00 0 6012 8 0 0
t$perf-norm:sp_reserve_write_off 9326 9326 0 0.00 0 14084 11 0 0
t$perf-norm:sp_supplier_invoice 4910 4910 0 0.00 0 3551 15 0 0
t$perf-norm:sp_supplier_order 5054 5054 0 0.00 0 3383 15 0 0
t$perf-norm:srv_aggregate_perf_data 88 88 0 0.00 0 1474 18 0 0
t$perf-norm:srv_fill_mon_cache_memory 58 58 0 0.00 0 594 11 0 0
t$perf-norm:srv_make_invnt_saldo 444 444 0 0.00 0 1046 11 0 0
t$perf-norm:srv_make_money_saldo 647 647 0 0.00 0 2289 7 0 0
t$perf-norm:srv_recalc_idx_stat 3 3 0 0.00 1 3 2 0 0
v_add_invoice_to_stock 9218 9062 156 1.69 0 4873 17 0 156
v_all_customers 35226 35226 0 0.00 0 20 1 0 0
v_all_suppliers 28186 28186 0 0.00 0 24 1 0 0
v_all_wares 37712 37712 0 0.00 0 16 1 0 0
v_cancel_adding_invoice 800 800 0 0.00 0 2788 12 0 0
v_cancel_client_order 3228 3228 0 0.00 0 2569 6 0 0
v_cancel_customer_prepayment 1178 1178 0 0.00 0 1857 6 0 0
v_cancel_customer_reserve 1230 1230 0 0.00 0 2412 7 0 0
v_cancel_payment_to_supplier 812 812 0 0.00 0 1207 6 0 0
v_cancel_supplier_invoice 722 712 10 1.38 0 1791 16 0 10
v_cancel_supplier_order 702 702 0 0.00 0 1250 5 0 0
v_cancel_write_off 1750 1750 0 0.00 0 3052 15 0 0
v_max_id_clo_ord 5053 5053 0 0.00 0 383 1 0 0
v_max_id_clo_res 928 928 0 0.00 0 2805 16 0 0
v_max_id_ord_sup 4892 4892 0 0.00 0 4308 4 0 0
v_max_non_paid_invoice 1212 1212 0 0.00 0 487 2 0 0
v_max_non_paid_realizn 3173 3173 0 0.00 0 2402 4 0 0
v_min_id_clo_ord 5053 5053 0 0.00 0 3246 6 0 0
v_min_id_clo_res 928 928 0 0.00 0 1022 5 0 0
v_min_id_ord_sup 4892 4892 0 0.00 0 9203 14 0 0
v_min_non_paid_invoice 5360 5360 0 0.00 0 5839 11 0 0
v_min_non_paid_realizn 6572 6572 0 0.00 0 16484 18 0 0
v_our_firm 9284 9284 0 0.00 0 22 1 0 0
v_reserve_write_off 18652 18652 0 0.00 0 4342 6 0 0
x_lock_depdocs_on_canc_invoice 8859 8859 0 0.00 0 16783 110 0 0
x_lock_depdocs_on_canc_sup_ord 351 351 0 0.00 0 13008 329 0 0
x_make_qstorno_1000_1200 5054 5054 0 0.00 1 43717 1141 0 0
x_make_qstorno_1200_2000 4910 4910 0 0.00 2 80931 2796 0 0
x_make_qstorno_2100_3300 424927 424927 0 0.00 0 91413 200 0 0

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

Memory consumption, metadata cache, attachments activity 

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


Page cache type: shared, buffers: 1000000 for all connections, with total size: 8192000000
measurement_dts measurement duration ms page cache memo used memo used, total memo allocated, total metadata cache metadata cache percent of total total attachments cnt active attachments cnt running statements cnt stalled statements cnt memo used by attachments memo used by transactions memo used by statements
08:07:55 1 8192000000 8796662832 8807108608 3180608 0.038 1 1 2 0 3278224 61840 35776
08:08:56 26385 8192000000 9711171024 10009243648 781891456 8.712 100 88 176 0 810318576 6959744 21467376
08:10:28 22090 8192000000 9746371120 10053206016 822225952 9.121 100 89 178 0 853710864 10082928 21401984
08:11:54 18547 8192000000 9772770144 10090782720 845168128 9.352 100 77 154 0 878694224 15313808 18212288
08:13:25 9093 8192000000 9837462416 10170671104 893400592 9.833 100 76 148 1 949236752 39917824 15918336
08:14:44 6703 8192000000 9885061968 10229075968 936329552 10.257 100 78 154 0 994982320 42874416 15778352
08:15:53 3917 8192000000 9941523920 10292355072 976727904 10.652 100 79 155 0 1047605680 56116480 14761296
08:16:59 2760 8192000000 9995165728 10356367360 1003237648 10.910 100 90 180 0 1105803856 85224544 17341664
08:18:04 1874 8192000000 9984148576 10352660480 1022480800 11.096 100 77 152 1 1101920304 65022624 14416880
08:19:08 3496 8192000000 10001972304 10371448832 1034727440 11.214 100 85 167 1 1120636608 69966192 15942976
08:20:13 1043 8192000000 10047900864 10424942592 1054225424 11.401 100 94 181 0 1163392176 90562288 18604464
08:21:15 5526 8192000000 9990528112 10374438912 1058134448 11.439 100 66 129 0 1110308848 37679600 14494800
08:22:22 4132 8192000000 10046261392 10435985408 1065160288 11.506 100 76 148 0 1156511680 75907232 15444160
08:23:28 8387 8192000000 9984618608 10388877312 1071298400 11.564 100 36 73 2 1091363904 12590688 7474816
08:24:37 5144 8192000000 10004270432 10405109760 1079702544 11.645 100 41 84 1 1117551056 29090880 8757632
08:25:46 8163 8192000000 10023659680 10425503744 1088387008 11.727 100 37 75 1 1125138896 28959840 7792048
08:26:56 57634 8192000000 9997953824 10405371904 1094485984 11.785 100 32 59 0 1127636048 27134832 6015232
08:29:00 20982 8192000000 10076966368 10478411776 1108720480 11.920 100 59 117 0 1165672208 45713088 11238640
08:30:26 36171 8192000000 10049621440 10480988160 1097719552 11.816 98 30 60 0 1161587184 58235648 5631984
08:32:09 20721 8192000000 10071448512 10485760000 1112137360 11.953 99 32 64 1 1178082880 58921216 7024304
08:33:43 34820 8192000000 10122300496 10528464896 1117580752 12.004 99 51 99 0 1203885520 76611696 9693072
08:35:24 10361 8192000000 10160914560 10566955008 1126170032 12.085 99 58 113 0 1254504480 116987472 11346976
08:36:39 9151 8192000000 10182874080 10584645632 1110490016 11.937 100 53 104 1 1272761280 151187776 11083488
08:37:52 7355 8192000000 10188062496 10584936448 1110862512 11.941 99 61 122 1 1295150944 171988656 12299776
08:39:02 14588 8192000000 10189783136 10607009792 1119203456 12.019 100 43 85 0 1304153168 176050064 8899648
08:40:34 14629 8192000000 10177858592 10602455040 1081250928 11.659 98 39 78 1 1260775568 170976928 8547712
08:41:52 12013 8192000000 10174417808 10592141312 1088533632 11.729 99 47 91 0 1279633760 181149488 9950640
08:43:10 2545 8192000000 10245061792 10635075584 1112099248 11.952 100 74 143 0 1344617184 217027696 15490240
08:44:18 3192 8192000000 10260678864 10680938496 1116376640 11.993 100 58 114 0 1370705360 242111136 12217584
08:45:27 3360 8192000000 10238353648 10630299648 1098469312 11.823 99 76 153 0 1331350736 216175168 16706256
08:46:34 5462 8192000000 10308105536 10718572544 1123894608 12.064 100 69 137 1 1406330368 267168624 15267136
08:47:44 2131 8192000000 10343690160 10748989440 1132335568 12.143 100 70 140 1 1443148496 295178384 15634544
08:48:50 2828 8192000000 10268955056 10693394432 1136798320 12.185 100 62 123 1 1377236544 226910432 13527792
08:50:01 13374 8192000000 10266269280 10703802368 1129779872 12.119 100 32 64 0 1360495040 222574624 8140544
08:51:18 44920 8192000000 10202459984 10665246720 1123023360 12.056 100 16 32 0 1319902912 192698272 4181280
08:53:05 77455 8192000000 10076922528 10583576576 1103648848 11.872 99 9 18 0 1161544032 56028544 1866640
08:55:31 34407 8192000000 10053860288 10493104128 1104382640 11.879 99 24 47 0 1130973568 21310560 5280368
08:57:09 34781 8192000000 10073881024 10492837888 1094333344 11.784 98 44 87 0 1152516144 48388912 9793888
08:58:51 37509 8192000000 10067896496 10523680768 1106748000 11.902 99 28 54 0 1173253344 60964624 5540720
09:00:29 165303 8192000000 10034624352 10487545856 1104182112 11.877 99 19 38 0 1136353328 28133952 4037264
09:05:00 13740 8192000000 10164355696 10594422784 1142427152 12.238 100 55 108 1 1255745072 101978000 11339920
09:06:23 45042 8192000000 10132359456 10611380224 1119812080 12.025 98 27 52 0 1245915520 120648192 5455248
09:08:18 22798 8192000000 10100146048 10573398016 1141212992 12.227 100 20 39 1 1198236976 52960128 4063856
09:09:43 43813 8192000000 10107607504 10562912256 1145271168 12.265 100 21 42 0 1222890080 73483968 4134944
09:12:13 57122 8192000000 10087775984 10544230400 1100617792 11.844 96 13 26 0 1172141744 68915312 2608640
09:14:17 14833 8192000000 10105675200 10557771776 1128377680 12.106 100 59 118 2 1195714160 55263440 12073040
09:15:34 46974 8192000000 10053392112 10540122112 1106376768 11.898 98 15 30 0 1169383424 60125152 2881504
09:17:35 32279 8192000000 10100609728 10523099136 1104377024 11.879 98 31 61 0 1139992480 29948896 5666560
09:19:07 84775 8192000000 10086046352 10549542912 1065041504 11.505 95 16 33 0 1133892592 65347840 3503248
09:21:37 31738 8192000000 10063277568 10475474944 1075959344 11.609 97 29 58 0 1127164992 46046848 5158800
09:23:09 123466 8192000000 10067410800 10514419712 1089074096 11.734 98 29 56 0 1141257344 46687264 5495984
09:26:13 40300 8192000000 10068374016 10543190016 1098162880 11.820 98 22 44 0 1151359536 48790144 4406512
09:27:59 42482 8192000000 10043382816 10512351232 1095379488 11.794 98 9 16 0 1134499248 37452320 1667440
09:29:44 55313 8192000000 10012157248 10461003776 1065099296 11.505 97 14 28 0 1092517808 24663792 2754720
09:31:46 27558 8192000000 10080997376 10508136448 1098620224 11.825 98 41 80 2 1156246816 49283728 8342864
09:33:18 67354 8192000000 10080771952 10577973248 1084834928 11.694 98 25 50 1 1177414464 87113296 5466240
09:35:29 28142 8192000000 10038727728 10472198144 1094708720 11.787 99 17 35 0 1133572928 35464672 3399536
09:37:02 15803 8192000000 10058419632 10474323968 1102345920 11.860 100 45 88 1 1154669440 44361056 7962464
09:38:22 17724 8192000000 10075448320 10494017536 1112955216 11.960 100 43 86 0 1175623040 54769344 7898480
09:39:40 24031 8192000000 10088924576 10566754304 1115615104 11.986 100 32 64 0 1202017968 80089344 6313520
09:41:05 30521 8192000000 10083128512 10506014720 1130290768 12.124 100 45 90 1 1164518944 25433120 8795056
09:42:39 34713 8192000000 10127323408 10573250560 1125202208 12.076 99 20 40 0 1197150496 68005936 3942352
09:44:15 94102 8192000000 10069502640 10506973184 1135478256 12.173 100 34 68 1 1162324208 19751296 7094656
09:47:27 28688 8192000000 10055794160 10546638848 1136321856 12.181 100 5 8 0 1167492992 30661056 510080
09:48:57 67490 8192000000 10076108192 10528346112 1133435504 12.154 99 5 10 0 1163936224 29191616 1309104
09:51:05 52805 8192000000 10096128128 10546159616 1125680016 12.081 98 22 44 0 1173043312 42954368 4408928
09:53:02 47920 8192000000 10056759824 10540011520 1122350528 12.049 99 19 38 1 1168322848 41938992 4033328
09:54:51 31517 8192000000 10062001744 10499764224 1112974448 11.961 98 40 80 1 1156071712 34486432 8610832
09:56:28 69817 8192000000 10072564976 10528747520 1098177232 11.820 97 26 52 0 1164286112 61476192 4632688
09:58:39 58523 8192000000 10063219376 10536222720 1076981888 11.619 96 19 38 0 1151326992 70749232 3595872
10:00:38 18785 8192000000 10066069760 10487296000 1096075968 11.800 100 59 116 1 1152157792 45176176 10905648
10:01:57 98057 8192000000 10071221952 10533580800 1103631888 11.872 100 41 82 0 1195666224 83931904 8102432
10:04:44 56506 8192000000 10052963728 10497089536 1101001120 11.847 99 14 28 0 1149886944 46204800 2681024
10:06:40 76917 8192000000 9528514544 9892630528 601796848 6.843 53 13 26 0 630063712 25709824 2557040

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


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

Exceptions occured during test was in run

FB_MNEMONA CNT UNIT FB_GDSCODE
except 78 v_add_invoice_to_stock 335544517
except 5 v_cancel_supplier_invoice 335544517

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

Content of mon$database and FB version 


MON$DATABASE_NAME               /home/bases/oltp40-etalone.fdb
MON$PAGE_SIZE                   8192
MON$ODS_MAJOR                   13
MON$ODS_MINOR                   0
MON$OLDEST_TRANSACTION          174940
MON$OLDEST_ACTIVE               176962
MON$OLDEST_SNAPSHOT             176962
MON$NEXT_TRANSACTION            176962
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                       1902624
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             702
MON$NEXT_STATEMENT              53
MON$REPLICA_MODE                0


ISQL Version: LI-V4.0.5.3080 Firebird 4.0
Server version:
Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V4.0.5.3080 Firebird 4.0"
Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-V4.0.5.3080 Firebird 4.0/tcp (mscs-test-161.budzdorov.ru)/P17:C"
Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-V4.0.5.3080 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 18 10:09:57 2024 
 
Database header page information: 
    Flags            0 
    Generation        92385 
    System Change Number    0 
    Page size        8192 
    ODS version        13.0 
    Oldest transaction    174940 
    Oldest active        176962 
    Oldest snapshot        176962 
    Next transaction    176963 
    Sequence number        0 
    Next attachment ID    702 
    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.63, total records: 7746584 
    Average version length: 48.16, total versions: 53362, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 64.00, compression ratio: 1.34 
    Pointer pages: 55, data page slots: 88640 
    Data pages: 88640, average fill: 70% 
    Primary pages: 88640, secondary pages: 0, swept pages: 40712 
    Empty pages: 0, full pages: 71043 
    Fill distribution: 
     0 - 19% = 3 
    20 - 39% = 35 
    40 - 59% = 899 
    60 - 79% = 87679 
    80 - 99% = 24 
 
    Index DOC_DATA_DOC_WARE_UNQ (0) 
    Root page: 1510636, depth: 3, leaf buckets: 23288, nodes: 7746584 
    Average node length: 18.88, total dup: 0, max dup: 0 
    Average key length: 15.89, compression ratio: 1.70 
    Average prefix length: 14.10, average data length: 12.90 
    Clustering factor: 1705085, ratio: 0.22 
    Fill distribution: 
         0 - 19% = 339 
        20 - 39% = 1797 
        40 - 59% = 4147 
        60 - 79% = 2467 
        80 - 99% = 14538 
 
    Index DOC_DATA_ID_DESC (1) 
    Root page: 1528140, depth: 3, leaf buckets: 13527, nodes: 7746584 
    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: 1528533, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 1589 
        40 - 59% = 2036 
        60 - 79% = 1135 
        80 - 99% = 8767 
 
    Index FK_DOC_DATA_DOC_LIST (2) 
    Root page: 1546735, depth: 3, leaf buckets: 8331, nodes: 7746584 
    Average node length: 6.61, total dup: 5795531, max dup: 49 
    Average key length: 3.63, compression ratio: 2.48 
    Average prefix length: 7.62, average data length: 1.38 
    Clustering factor: 1521423, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 108 
        20 - 39% = 943 
        40 - 59% = 1423 
        60 - 79% = 964 
        80 - 99% = 4893 
 
DOC_LIST (138) 
    Primary pointer page: 500, Index root page: 501 
    Total formats: 1, used formats: 1 
    Average record length: 56.86, total records: 2242358 
    Average version length: 58.78, total versions: 27424, max versions: 2 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 84.00, compression ratio: 1.48 
    Pointer pages: 18, data page slots: 28456 
    Data pages: 28456, average fill: 72% 
    Primary pages: 28456, secondary pages: 0, swept pages: 11838 
    Empty pages: 25, full pages: 20522 
    Fill distribution: 
     0 - 19% = 28 
    20 - 39% = 7 
    40 - 59% = 159 
    60 - 79% = 28215 
    80 - 99% = 47 
 
    Index DOC_LIST_ID_DESC (1) 
    Root page: 1541152, depth: 3, leaf buckets: 4558, nodes: 2242358 
    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: 689451, ratio: 0.31 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 891 
        40 - 59% = 892 
        60 - 79% = 737 
        80 - 99% = 2038 
 
    Index DOC_LIST_WORKER_OPTYPE (2) 
    Root page: 1544398, depth: 3, leaf buckets: 2409, nodes: 2243781 
    Average node length: 4.97, total dup: 2242882, max dup: 18898 
    Average key length: 2.01, compression ratio: 4.48 
    Average prefix length: 8.99, average data length: 0.01 
    Clustering factor: 1280473, ratio: 0.57 
    Fill distribution: 
         0 - 19% = 3 
        20 - 39% = 187 
        40 - 59% = 1393 
        60 - 79% = 569 
        80 - 99% = 257 
 
    Index FK_DOC_LIST_AGENTS (3) 
    Root page: 1545933, depth: 3, leaf buckets: 1750, nodes: 2242358 
    Average node length: 4.97, total dup: 2242308, max dup: 130194 
    Average key length: 2.01, compression ratio: 4.48 
    Average prefix length: 8.99, average data length: 0.01 
    Clustering factor: 1061248, ratio: 0.47 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 6 
        40 - 59% = 573 
        60 - 79% = 57 
        80 - 99% = 1113 
 
    Index PK_DOC_LIST (0) 
    Root page: 1538209, depth: 3, leaf buckets: 4348, nodes: 2242358 
    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: 689451, ratio: 0.31 
    Fill distribution: 
         0 - 19% = 95 
        20 - 39% = 583 
        40 - 59% = 657 
        60 - 79% = 850 
        80 - 99% = 2163 
 
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.36, total records: 400 
    Average version length: 26.35, total versions: 2582, max versions: 8 
    Average fragment length: 2.00, total fragments: 3, max fragments: 1 
    Average unpacked length: 104.00, compression ratio: 1.25 
    Pointer pages: 1, data page slots: 32 
    Data pages: 32, average fill: 59% 
    Primary pages: 12, secondary pages: 20, swept pages: 0 
    Empty pages: 5, full pages: 20 
    Fill distribution: 
     0 - 19% = 10 
    20 - 39% = 1 
    40 - 59% = 1 
    60 - 79% = 3 
    80 - 99% = 17 
 
    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: 17.48, total records: 96068 
    Average version length: 68.27, total versions: 82339, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 88.00, compression ratio: 5.03 
    Pointer pages: 7, data page slots: 3008 
    Data pages: 2448, average fill: 53% 
    Primary pages: 2447, secondary pages: 1, swept pages: 0 
    Empty pages: 519, full pages: 1037 
    Fill distribution: 
     0 - 19% = 735 
    20 - 39% = 191 
    40 - 59% = 242 
    60 - 79% = 409 
    80 - 99% = 871 
 
    Index INVNT_TURNOVER_LOG_WARE_DD_ID (0) 
    Root page: 1694014, depth: 3, leaf buckets: 391, nodes: 96068 
    Average node length: 13.29, total dup: 5149, max dup: 2 
    Average key length: 10.80, compression ratio: 2.50 
    Average prefix length: 19.14, average data length: 7.86 
    Clustering factor: 71817, ratio: 0.75 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 192 
        40 - 59% = 191 
        60 - 79% = 8 
        80 - 99% = 0 
 
MONEY_SALDO (141) 
    Primary pointer page: 506, Index root page: 507 
    Total formats: 1, used formats: 1 
    Average record length: 15.16, total records: 49 
    Average version length: 9.00, total versions: 173, max versions: 5 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 32.00, compression ratio: 2.11 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 74% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 1 
    80 - 99% = 0 
 
    Index PK_MONEY_SALDO (0) 
    Root page: 1510383, depth: 1, leaf buckets: 1, nodes: 49 
    Average node length: 11.82, total dup: 0, max dup: 0 
    Average key length: 10.80, compression ratio: 0.83 
    Average prefix length: 1.18, average data length: 7.82 
    Clustering factor: 1, ratio: 0.02 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
MONEY_TURNOVER_LOG (140) 
    Primary pointer page: 504, Index root page: 505 
    Total formats: 1, used formats: 1 
    Average record length: 14.86, total records: 1374 
    Average version length: 43.19, total versions: 1142, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 58.00, compression ratio: 3.90 
    Pointer pages: 1, data page slots: 40 
    Data pages: 40, average fill: 36% 
    Primary pages: 39, secondary pages: 1, swept pages: 1 
    Empty pages: 11, full pages: 9 
    Fill distribution: 
     0 - 19% = 19 
    20 - 39% = 4 
    40 - 59% = 5 
    60 - 79% = 4 
    80 - 99% = 8 
 
    Index MONEY_TURNOVER_LOG_AGENT_OPTYPE (0) 
    Root page: 90779, depth: 2, leaf buckets: 3, nodes: 1374 
    Average node length: 4.58, total dup: 1277, max dup: 160 
    Average key length: 2.77, compression ratio: 6.86 
    Average prefix length: 18.30, average data length: 0.70 
    Clustering factor: 741, ratio: 0.54 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 3 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
MON_CACHE_MEMORY (165) 
    Primary pointer page: 555, Index root page: 556 
    Total formats: 2, used formats: 1 
    Average record length: 97.54, total records: 74 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 112.00, compression ratio: 1.15 
    Pointer pages: 1, data page slots: 2 
    Data pages: 2, average fill: 52% 
    Primary pages: 2, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 1 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 1 
    40 - 59% = 0 
    60 - 79% = 1 
    80 - 99% = 0 
 
    Index PK_MON_CACHE_MEMORY (0) 
    Root page: 1504238, depth: 1, leaf buckets: 1, nodes: 74 
    Average node length: 11.69, total dup: 0, max dup: 0 
    Average key length: 10.68, compression ratio: 0.84 
    Average prefix length: 1.31, average data length: 7.69 
    Clustering factor: 2, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
MON_LOG (162) 
    Primary pointer page: 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.94, total records: 801414 
    Average version length: 37.91, total versions: 38073, max versions: 3 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 54.00, compression ratio: 1.50 
    Pointer pages: 6, data page slots: 8504 
    Data pages: 8504, average fill: 65% 
    Primary pages: 8501, secondary pages: 3, swept pages: 1943 
    Empty pages: 32, full pages: 5799 
    Fill distribution: 
     0 - 19% = 72 
    20 - 39% = 99 
    40 - 59% = 631 
    60 - 79% = 7605 
    80 - 99% = 97 
 
    Index PDISTR_AGENT_ID (2) 
    Root page: 1509330, depth: 2, leaf buckets: 851, nodes: 785953 
    Average node length: 4.88, total dup: 785904, max dup: 145423 
    Average key length: 2.01, compression ratio: 4.48 
    Average prefix length: 8.99, average data length: 0.01 
    Clustering factor: 89997, ratio: 0.11 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 136 
        40 - 59% = 453 
        60 - 79% = 161 
        80 - 99% = 99 
 
    Index PDISTR_SNDOP_RCVOP_SNDID_ASC (0) 
    Root page: 1508635, depth: 3, leaf buckets: 969, nodes: 785953 
    Average node length: 5.88, total dup: 699949, max dup: 42 
    Average key length: 3.02, compression ratio: 7.29 
    Average prefix length: 21.09, average data length: 0.91 
    Clustering factor: 158363, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 59 
        40 - 59% = 566 
        60 - 79% = 88 
        80 - 99% = 255 
 
    Index PDISTR_SNDOP_RCVOP_SNDID_DESC (1) 
    Root page: 1509209, depth: 3, leaf buckets: 998, nodes: 785953 
    Average node length: 5.88, total dup: 699949, max dup: 42 
    Average key length: 3.02, compression ratio: 7.29 
    Average prefix length: 21.09, average data length: 0.91 
    Clustering factor: 160277, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 110 
        40 - 59% = 558 
        60 - 79% = 86 
        80 - 99% = 244 
 
    Index PDISTR_WORKER_SND_ID (3) 
    Root page: 1510200, depth: 3, leaf buckets: 1126, nodes: 785953 
    Average node length: 5.96, total dup: 699949, max dup: 42 
    Average key length: 3.10, compression ratio: 5.49 
    Average prefix length: 16.01, average data length: 0.99 
    Clustering factor: 153107, ratio: 0.19 
    Fill distribution: 
         0 - 19% = 4 
        20 - 39% = 248 
        40 - 59% = 599 
        60 - 79% = 203 
        80 - 99% = 72 
 
PERF_AGG (158) 
    Primary pointer page: 540, Index root page: 541 
    Total formats: 1, used formats: 1 
    Average record length: 62.74, total records: 5437 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 2.87, total fragments: 39, max fragments: 1 
    Average unpacked length: 379.00, compression ratio: 6.04 
    Pointer pages: 1, data page slots: 88 
    Data pages: 88, average fill: 61% 
    Primary pages: 75, secondary pages: 13, swept pages: 60 
    Empty pages: 6, full pages: 60 
    Fill distribution: 
     0 - 19% = 13 
    20 - 39% = 1 
    40 - 59% = 4 
    60 - 79% = 70 
    80 - 99% = 0 
 
    Index PERF_AGG_UNQ (1) 
    Root page: 1504260, depth: 2, leaf buckets: 6, nodes: 5437 
    Average node length: 5.48, total dup: 0, max dup: 0 
    Average key length: 3.58, compression ratio: 10.03 
    Average prefix length: 34.37, average data length: 1.55 
    Clustering factor: 5101, ratio: 0.94 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 0 
        40 - 59% = 4 
        60 - 79% = 1 
        80 - 99% = 1 
 
    Index PK_PERF_AGG (0) 
    Root page: 1504255, depth: 2, leaf buckets: 10, nodes: 5437 
    Average node length: 11.11, total dup: 0, max dup: 0 
    Average key length: 9.21, compression ratio: 0.98 
    Average prefix length: 2.79, average data length: 6.21 
    Clustering factor: 167, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 1 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 7 
 
PERF_ESTIMATED (280) 
    Primary pointer page: 399, Index root page: 434 
    Total formats: 1, used formats: 1 
    Average record length: 39.13, total records: 80468 
    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: 2, full pages: 836 
    Fill distribution: 
     0 - 19% = 3 
    20 - 39% = 1 
    40 - 59% = 0 
    60 - 79% = 836 
    80 - 99% = 0 
 
    Index PK_PERF_ESTIMATED (0) 
    Root page: 30628, depth: 2, leaf buckets: 102, nodes: 80468 
    Average node length: 10.17, total dup: 0, max dup: 0 
    Average key length: 8.17, compression ratio: 1.10 
    Average prefix length: 3.82, average data length: 5.18 
    Clustering factor: 2867, ratio: 0.04 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 0 
        40 - 59% = 1 
        60 - 79% = 0 
        80 - 99% = 101 
 
PERF_ISQL_STAT (156) 
    Primary pointer page: 536, Index root page: 537 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index PERF_ISQL_STAT_TRN (0) 
    Root page: 1504261, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
PERF_LOG (159) 
    Primary pointer page: 542, Index root page: 543 
    Total formats: 1, used formats: 1 
    Average record length: 111.07, total records: 71 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1691.00, compression ratio: 15.22 
    Pointer pages: 1, data page slots: 2 
    Data pages: 2, average fill: 56% 
    Primary pages: 2, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 1 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 1 
    40 - 59% = 0 
    60 - 79% = 1 
    80 - 99% = 0 
 
PERF_SPLIT_0 (281) 
    Primary pointer page: 601, Index root page: 602 
    Total formats: 1, used formats: 1 
    Average record length: 149.38, total records: 140480 
    Average version length: 149.53, total versions: 1705, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.35 
    Pointer pages: 6, data page slots: 5184 
    Data pages: 3512, average fill: 82% 
    Primary pages: 3509, secondary pages: 3, swept pages: 4 
    Empty pages: 55, full pages: 3439 
    Fill distribution: 
     0 - 19% = 57 
    20 - 39% = 5 
    40 - 59% = 5 
    60 - 79% = 6 
    80 - 99% = 3439 
 
PERF_SPLIT_1 (282) 
    Primary pointer page: 603, Index root page: 604 
    Total formats: 1, used formats: 1 
    Average record length: 147.32, total records: 125185 
    Average version length: 151.72, total versions: 3323, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.51 
    Pointer pages: 7, data page slots: 4224 
    Data pages: 3136, average fill: 82% 
    Primary pages: 3132, secondary pages: 4, swept pages: 4 
    Empty pages: 53, full pages: 3069 
    Fill distribution: 
     0 - 19% = 56 
    20 - 39% = 6 
    40 - 59% = 4 
    60 - 79% = 2 
    80 - 99% = 3068 
 
PERF_SPLIT_2 (283) 
    Primary pointer page: 605, Index root page: 606 
    Total formats: 1, used formats: 1 
    Average record length: 132.69, total records: 149483 
    Average version length: 154.71, total versions: 19290, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 12.78 
    Pointer pages: 5, data page slots: 4552 
    Data pages: 3840, average fill: 82% 
    Primary pages: 3838, secondary pages: 2, swept pages: 3 
    Empty pages: 141, full pages: 3655 
    Fill distribution: 
     0 - 19% = 143 
    20 - 39% = 12 
    40 - 59% = 19 
    60 - 79% = 9 
    80 - 99% = 3657 
 
PERF_SPLIT_3 (284) 
    Primary pointer page: 607, Index root page: 616 
    Total formats: 1, used formats: 1 
    Average record length: 148.17, total records: 142930 
    Average version length: 151.65, total versions: 2801, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.45 
    Pointer pages: 6, data page slots: 3968 
    Data pages: 3544, average fill: 83% 
    Primary pages: 3542, secondary pages: 2, swept pages: 3 
    Empty pages: 31, full pages: 3504 
    Fill distribution: 
     0 - 19% = 34 
    20 - 39% = 4 
    40 - 59% = 1 
    60 - 79% = 1 
    80 - 99% = 3504 
 
PERF_SPLIT_4 (285) 
    Primary pointer page: 617, Index root page: 618 
    Total formats: 1, used formats: 1 
    Average record length: 143.27, total records: 166150 
    Average version length: 154.68, total versions: 9787, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.84 
    Pointer pages: 9, data page slots: 7224 
    Data pages: 4224, average fill: 82% 
    Primary pages: 4222, secondary pages: 2, swept pages: 8 
    Empty pages: 107, full pages: 4078 
    Fill distribution: 
     0 - 19% = 111 
    20 - 39% = 13 
    40 - 59% = 14 
    60 - 79% = 6 
    80 - 99% = 4080 
 
PERF_SPLIT_5 (286) 
    Primary pointer page: 619, Index root page: 620 
    Total formats: 1, used formats: 1 
    Average record length: 148.53, total records: 148065 
    Average version length: 151.45, total versions: 2774, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.42 
    Pointer pages: 6, data page slots: 4928 
    Data pages: 3712, average fill: 82% 
    Primary pages: 3709, secondary pages: 3, swept pages: 6 
    Empty pages: 59, full pages: 3623 
    Fill distribution: 
     0 - 19% = 63 
    20 - 39% = 8 
    40 - 59% = 9 
    60 - 79% = 9 
    80 - 99% = 3623 
 
PERF_SPLIT_6 (287) 
    Primary pointer page: 621, Index root page: 622 
    Total formats: 1, used formats: 1 
    Average record length: 149.90, total records: 126418 
    Average version length: 145.03, total versions: 922, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.31 
    Pointer pages: 7, data page slots: 3384 
    Data pages: 3160, average fill: 82% 
    Primary pages: 3157, secondary pages: 3, swept pages: 5 
    Empty pages: 52, full pages: 3093 
    Fill distribution: 
     0 - 19% = 56 
    20 - 39% = 2 
    40 - 59% = 2 
    60 - 79% = 6 
    80 - 99% = 3094 
 
PERF_SPLIT_7 (288) 
    Primary pointer page: 626, Index root page: 627 
    Total formats: 1, used formats: 1 
    Average record length: 146.21, total records: 148673 
    Average version length: 152.63, total versions: 5199, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.60 
    Pointer pages: 8, data page slots: 4688 
    Data pages: 3688, average fill: 83% 
    Primary pages: 3687, secondary pages: 1, swept pages: 1 
    Empty pages: 25, full pages: 3644 
    Fill distribution: 
     0 - 19% = 30 
    20 - 39% = 3 
    40 - 59% = 7 
    60 - 79% = 4 
    80 - 99% = 3644 
 
PERF_SPLIT_8 (289) 
    Primary pointer page: 628, Index root page: 629 
    Total formats: 1, used formats: 1 
    Average record length: 150.76, total records: 151833 
    Average version length: 139.16, total versions: 650, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.25 
    Pointer pages: 7, data page slots: 5264 
    Data pages: 3792, average fill: 83% 
    Primary pages: 3788, secondary pages: 4, swept pages: 3 
    Empty pages: 50, full pages: 3729 
    Fill distribution: 
     0 - 19% = 55 
    20 - 39% = 5 
    40 - 59% = 2 
    60 - 79% = 3 
    80 - 99% = 3727 
 
PERF_SPLIT_9 (290) 
    Primary pointer page: 630, Index root page: 631 
    Total formats: 1, used formats: 1 
    Average record length: 136.88, total records: 160273 
    Average version length: 154.50, total versions: 16203, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 12.39 
    Pointer pages: 6, data page slots: 5592 
    Data pages: 4064, average fill: 83% 
    Primary pages: 4063, secondary pages: 1, swept pages: 1 
    Empty pages: 102, full pages: 3933 
    Fill distribution: 
     0 - 19% = 104 
    20 - 39% = 15 
    40 - 59% = 7 
    60 - 79% = 5 
    80 - 99% = 3933 
 
PHRASES (143) 
    Primary pointer page: 510, Index root page: 511 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index PHRASES_ID_DESC (3) 
    Root page: 1510376, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PHRASES_NAME (2) 
    Root page: 1510375, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PHRASES_UNQ (1) 
    Root page: 1510374, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PK_PHRASES (0) 
    Root page: 1510373, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
PSTORNED (147) 
    Primary pointer page: 518, Index root page: 519 
    Total formats: 1, used formats: 1 
    Average record length: 52.28, total records: 2107925 
    Average version length: 52.89, total versions: 22383, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 70.00, compression ratio: 1.34 
    Pointer pages: 16, data page slots: 25544 
    Data pages: 25544, average fill: 71% 
    Primary pages: 25534, secondary pages: 10, swept pages: 10460 
    Empty pages: 84, full pages: 23364 
    Fill distribution: 
     0 - 19% = 163 
    20 - 39% = 150 
    40 - 59% = 495 
    60 - 79% = 24522 
    80 - 99% = 214 
 
    Index PSTORNED_RCV_ID (1) 
    Root page: 1506208, depth: 3, leaf buckets: 2607, nodes: 2107925 
    Average node length: 5.44, total dup: 1967341, max dup: 1596 
    Average key length: 2.49, compression ratio: 3.62 
    Average prefix length: 8.58, average data length: 0.42 
    Clustering factor: 183319, ratio: 0.09 
    Fill distribution: 
         0 - 19% = 7 
        20 - 39% = 294 
        40 - 59% = 1709 
        60 - 79% = 295 
        80 - 99% = 302 
 
    Index PSTORNED_SND_ID (0) 
    Root page: 1504841, depth: 3, leaf buckets: 2760, nodes: 2107925 
    Average node length: 5.69, total dup: 1892106, max dup: 68 
    Average key length: 2.74, compression ratio: 3.29 
    Average prefix length: 8.36, average data length: 0.64 
    Clustering factor: 377609, ratio: 0.18 
    Fill distribution: 
         0 - 19% = 3 
        20 - 39% = 1 
        40 - 59% = 2409 
        60 - 79% = 318 
        80 - 99% = 29 
 
    Index PSTORNED_WORKER_ID (2) 
    Root page: 1508018, depth: 3, leaf buckets: 2118, nodes: 2107925 
    Average node length: 4.96, total dup: 2107825, max dup: 28639 
    Average key length: 2.00, compression ratio: 1.20 
    Average prefix length: 2.41, average data length: 0.00 
    Clustering factor: 180977, ratio: 0.09 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 160 
        40 - 59% = 1121 
        60 - 79% = 408 
        80 - 99% = 428 
 
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: 40.61, total records: 160389 
    Average version length: 69.18, total versions: 76196, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 3.10 
    Pointer pages: 3, data page slots: 4128 
    Data pages: 2807, average fill: 70% 
    Primary pages: 2807, secondary pages: 0, swept pages: 134 
    Empty pages: 178, full pages: 1953 
    Fill distribution: 
     0 - 19% = 233 
    20 - 39% = 95 
    40 - 59% = 231 
    60 - 79% = 1009 
    80 - 99% = 1239 
 
    Index XQD_1000_1200_WA_SO_RO_WKR_SND (0) 
    Root page: 1559248, depth: 3, leaf buckets: 215, nodes: 160389 
    Average node length: 6.49, total dup: 139729, max dup: 14 
    Average key length: 3.93, compression ratio: 10.69 
    Average prefix length: 40.20, average data length: 1.80 
    Clustering factor: 27169, ratio: 0.17 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 10 
        40 - 59% = 102 
        60 - 79% = 69 
        80 - 99% = 33 
 
XQD_1000_3300 (178) 
    Primary pointer page: 581, Index root page: 582 
    Total formats: 1, used formats: 1 
    Average record length: 65.65, total records: 6984861 
    Average version length: 68.78, total versions: 383689, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.92 
    Pointer pages: 65, data page slots: 105240 
    Data pages: 105240, average fill: 71% 
    Primary pages: 105240, secondary pages: 0, swept pages: 25275 
    Empty pages: 10, full pages: 64339 
    Fill distribution: 
     0 - 19% = 89 
    20 - 39% = 631 
    40 - 59% = 6060 
    60 - 79% = 97563 
    80 - 99% = 897 
 
    Index XQD_1000_3300_WA_SO_RO_WKR_SND (0) 
    Root page: 1480476, depth: 3, leaf buckets: 10730, nodes: 6984861 
    Average node length: 6.51, total dup: 6042467, max dup: 29 
    Average key length: 3.52, compression ratio: 11.93 
    Average prefix length: 40.61, average data length: 1.39 
    Clustering factor: 1645903, ratio: 0.24 
    Fill distribution: 
         0 - 19% = 15 
        20 - 39% = 1794 
        40 - 59% = 5885 
        60 - 79% = 2638 
        80 - 99% = 398 
 
    Index XQD_1000_3300_WKR_DOC_ASC (1) 
    Root page: 1486090, depth: 3, leaf buckets: 8527, nodes: 6984861 
    Average node length: 5.40, total dup: 6706125, max dup: 155 
    Average key length: 2.41, compression ratio: 7.06 
    Average prefix length: 16.63, average data length: 0.37 
    Clustering factor: 1448800, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 5 
        20 - 39% = 1250 
        40 - 59% = 4756 
        60 - 79% = 1624 
        80 - 99% = 892 
 
    Index XQD_1000_3300_WKR_DOC_DEC (2) 
    Root page: 1490630, depth: 3, leaf buckets: 8549, nodes: 6984861 
    Average node length: 5.40, total dup: 6706125, max dup: 155 
    Average key length: 2.41, compression ratio: 7.06 
    Average prefix length: 16.63, average data length: 0.37 
    Clustering factor: 1451188, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 3 
        20 - 39% = 1263 
        40 - 59% = 4719 
        60 - 79% = 1696 
        80 - 99% = 868 
 
XQD_1200_2000 (177) 
    Primary pointer page: 579, Index root page: 580 
    Total formats: 1, used formats: 1 
    Average record length: 67.50, total records: 11963631 
    Average version length: 68.73, total versions: 287968, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.87 
    Pointer pages: 107, data page slots: 173288 
    Data pages: 173288, average fill: 73% 
    Primary pages: 173288, secondary pages: 0, swept pages: 70914 
    Empty pages: 4, full pages: 148489 
    Fill distribution: 
     0 - 19% = 19 
    20 - 39% = 335 
    40 - 59% = 4142 
    60 - 79% = 167046 
    80 - 99% = 1746 
 
    Index XQD_1200_2000_WA_SO_RO_WKR_SND (0) 
    Root page: 1495050, depth: 3, leaf buckets: 18431, nodes: 11961887 
    Average node length: 6.61, total dup: 10429417, max dup: 66 
    Average key length: 3.42, compression ratio: 12.26 
    Average prefix length: 40.70, average data length: 1.30 
    Clustering factor: 2465335, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 19 
        20 - 39% = 2391 
        40 - 59% = 11017 
        60 - 79% = 4287 
        80 - 99% = 717 
 
XQD_2000_3300 (179) 
    Primary pointer page: 583, Index root page: 584 
    Total formats: 1, used formats: 1 
    Average record length: 49.01, total records: 1473056 
    Average version length: 69.11, total versions: 340737, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 2.57 
    Pointer pages: 26, data page slots: 41928 
    Data pages: 27544, average fill: 57% 
    Primary pages: 27455, secondary pages: 89, swept pages: 7750 
    Empty pages: 2655, full pages: 16445 
    Fill distribution: 
     0 - 19% = 4471 
    20 - 39% = 3357 
    40 - 59% = 2680 
    60 - 79% = 12604 
    80 - 99% = 4432 
 
    Index XQD_2000_3300_WA_SO_RO_WKR_SND (0) 
    Root page: 1479735, depth: 3, leaf buckets: 1835, nodes: 1320553 
    Average node length: 5.53, total dup: 1266940, max dup: 49 
    Average key length: 2.57, compression ratio: 16.33 
    Average prefix length: 41.47, average data length: 0.53 
    Clustering factor: 90987, ratio: 0.07 
    Fill distribution: 
         0 - 19% = 9 
        20 - 39% = 484 
        40 - 59% = 903 
        60 - 79% = 398 
        80 - 99% = 41 
 
XQD_2100_3300 (180) 
    Primary pointer page: 585, Index root page: 586 
    Total formats: 1, used formats: 1 
    Average record length: 40.41, total records: 1190899 
    Average version length: 69.05, total versions: 164192, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 3.12 
    Pointer pages: 22, data page slots: 34352 
    Data pages: 28976, average fill: 36% 
    Primary pages: 28975, secondary pages: 1, swept pages: 7954 
    Empty pages: 6431, full pages: 8271 
    Fill distribution: 
     0 - 19% = 10238 
    20 - 39% = 4191 
    40 - 59% = 6629 
    60 - 79% = 7704 
    80 - 99% = 214 
 
    Index XQD_2100_3300_WA_SO_RO_WKR_SND (0) 
    Root page: 1479229, depth: 3, leaf buckets: 1204, nodes: 787616 
    Average node length: 5.91, total dup: 727525, max dup: 79 
    Average key length: 2.98, compression ratio: 14.10 
    Average prefix length: 41.10, average data length: 0.90 
    Clustering factor: 110254, ratio: 0.14 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 357 
        40 - 59% = 596 
        60 - 79% = 229 
        80 - 99% = 21 
 
XQD_3300_3400 (181) 
    Primary pointer page: 587, Index root page: 588 
    Total formats: 1, used formats: 1 
    Average record length: 67.06, total records: 9136421 
    Average version length: 68.96, total versions: 277031, 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: 88, data page slots: 142504 
    Data pages: 142480, average fill: 69% 
    Primary pages: 142463, secondary pages: 17, swept pages: 59239 
    Empty pages: 270, full pages: 74446 
    Fill distribution: 
     0 - 19% = 923 
    20 - 39% = 4350 
    40 - 59% = 16391 
    60 - 79% = 119365 
    80 - 99% = 1451 
 
    Index XQD_3300_3400_WA_SO_RO_WKR_SND (0) 
    Root page: 1472612, depth: 3, leaf buckets: 13456, nodes: 9133919 
    Average node length: 6.68, total dup: 7573651, max dup: 23 
    Average key length: 3.67, compression ratio: 11.44 
    Average prefix length: 40.50, average data length: 1.50 
    Clustering factor: 2168927, ratio: 0.24 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 1329 
        40 - 59% = 6989 
        60 - 79% = 4492 
        80 - 99% = 645 
 
XQS_1000_1200 (182) 
    Primary pointer page: 589, Index root page: 590 
    Total formats: 1, used formats: 1 
    Average record length: 82.51, total records: 21136340 
    Average version length: 83.03, total versions: 8911, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.53 
    Pointer pages: 196, data page slots: 319616 
    Data pages: 319616, average fill: 81% 
    Primary pages: 319613, secondary pages: 3, swept pages: 13458 
    Empty pages: 31, full pages: 318906 
    Fill distribution: 
     0 - 19% = 54 
    20 - 39% = 39 
    40 - 59% = 97 
    60 - 79% = 49174 
    80 - 99% = 270252 
 
    Index XQS_1000_1200_DOC_ID (1) 
    Root page: 1426738, depth: 3, leaf buckets: 19396, nodes: 21136340 
    Average node length: 5.72, total dup: 20655629, max dup: 131 
    Average key length: 2.16, compression ratio: 4.16 
    Average prefix length: 8.86, average data length: 0.14 
    Clustering factor: 3280478, ratio: 0.16 
    Fill distribution: 
         0 - 19% = 4 
        20 - 39% = 1 
        40 - 59% = 8185 
        60 - 79% = 549 
        80 - 99% = 10657 
 
    Index XQS_1000_1200_RCV_ID (3) 
    Root page: 1457002, depth: 3, leaf buckets: 17191, nodes: 21136340 
    Average node length: 6.31, total dup: 18573505, max dup: 49 
    Average key length: 2.75, compression ratio: 3.27 
    Average prefix length: 8.37, average data length: 0.63 
    Clustering factor: 917640, ratio: 0.04 
    Fill distribution: 
         0 - 19% = 3 
        20 - 39% = 4 
        40 - 59% = 838 
        60 - 79% = 260 
        80 - 99% = 16086 
 
    Index XQS_1000_1200_SND_ID (2) 
    Root page: 1441095, depth: 3, leaf buckets: 21189, nodes: 21136340 
    Average node length: 6.35, total dup: 18493456, max dup: 29 
    Average key length: 2.79, compression ratio: 3.23 
    Average prefix length: 8.34, average data length: 0.66 
    Clustering factor: 3575173, ratio: 0.17 
    Fill distribution: 
         0 - 19% = 4 
        20 - 39% = 4 
        40 - 59% = 8463 
        60 - 79% = 622 
        80 - 99% = 12096 
 
    Index XQS_1000_1200_WORKER_ID (0) 
    Root page: 1413370, depth: 3, leaf buckets: 16125, nodes: 21136340 
    Average node length: 5.56, total dup: 21136240, max dup: 230269 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.42, average data length: 0.00 
    Clustering factor: 946493, ratio: 0.04 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 9 
        40 - 59% = 2968 
        60 - 79% = 357 
        80 - 99% = 12790 
 
XQS_1000_3300 (184) 
    Primary pointer page: 593, Index root page: 594 
    Total formats: 1, used formats: 1 
    Average record length: 80.28, total records: 9593818 
    Average version length: 82.60, total versions: 278436, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.57 
    Pointer pages: 105, data page slots: 170536 
    Data pages: 170496, average fill: 69% 
    Primary pages: 170462, secondary pages: 34, swept pages: 78836 
    Empty pages: 543, full pages: 102698 
    Fill distribution: 
     0 - 19% = 1729 
    20 - 39% = 7178 
    40 - 59% = 24124 
    60 - 79% = 119259 
    80 - 99% = 18206 
 
    Index XQS_1000_3300_DOC_ID (1) 
    Root page: 1367524, depth: 3, leaf buckets: 11329, nodes: 9593818 
    Average node length: 5.36, total dup: 9287716, max dup: 177 
    Average key length: 2.23, compression ratio: 4.03 
    Average prefix length: 8.80, average data length: 0.20 
    Clustering factor: 2258448, ratio: 0.24 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 55 
        40 - 59% = 8502 
        60 - 79% = 2696 
        80 - 99% = 75 
 
    Index XQS_1000_3300_RCV_ID (3) 
    Root page: 1379283, depth: 3, leaf buckets: 13439, nodes: 9593818 
    Average node length: 6.23, total dup: 7950210, max dup: 14 
    Average key length: 3.10, compression ratio: 2.90 
    Average prefix length: 8.07, average data length: 0.93 
    Clustering factor: 1618811, ratio: 0.17 
    Fill distribution: 
         0 - 19% = 125 
        20 - 39% = 3955 
        40 - 59% = 4267 
        60 - 79% = 2787 
        80 - 99% = 2305 
 
    Index XQS_1000_3300_SND_ID (2) 
    Root page: 1373081, depth: 3, leaf buckets: 12648, nodes: 9593818 
    Average node length: 5.98, total dup: 8321976, max dup: 44 
    Average key length: 2.85, compression ratio: 3.16 
    Average prefix length: 8.28, average data length: 0.72 
    Clustering factor: 2440711, ratio: 0.25 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 73 
        40 - 59% = 9497 
        60 - 79% = 2991 
        80 - 99% = 87 
 
    Index XQS_1000_3300_WORKER_ID (0) 
    Root page: 1362789, depth: 3, leaf buckets: 10083, nodes: 9593818 
    Average node length: 5.13, total dup: 9593718, max dup: 156984 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.42, average data length: 0.00 
    Clustering factor: 1633804, ratio: 0.17 
    Fill distribution: 
         0 - 19% = 41 
        20 - 39% = 1242 
        40 - 59% = 4980 
        60 - 79% = 1798 
        80 - 99% = 2022 
 
XQS_1200_2000 (183) 
    Primary pointer page: 591, Index root page: 592 
    Total formats: 1, used formats: 1 
    Average record length: 81.05, total records: 11227529 
    Average version length: 82.57, total versions: 192116, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.55 
    Pointer pages: 118, data page slots: 191664 
    Data pages: 190088, average fill: 72% 
    Primary pages: 189965, secondary pages: 123, swept pages: 64836 
    Empty pages: 2856, full pages: 149357 
    Fill distribution: 
     0 - 19% = 4642 
    20 - 39% = 6431 
    40 - 59% = 15677 
    60 - 79% = 101805 
    80 - 99% = 61533 
 
    Index XQS_1200_2000_DOC_ID (1) 
    Root page: 1392123, depth: 3, leaf buckets: 13133, nodes: 11227529 
    Average node length: 5.29, total dup: 11118460, max dup: 636 
    Average key length: 2.08, compression ratio: 4.33 
    Average prefix length: 8.93, average data length: 0.07 
    Clustering factor: 2354600, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 139 
        40 - 59% = 9415 
        60 - 79% = 3478 
        80 - 99% = 99 
 
    Index XQS_1200_2000_RCV_ID (3) 
    Root page: 1406132, depth: 3, leaf buckets: 10348, nodes: 11227529 
    Average node length: 5.49, total dup: 10736870, max dup: 49 
    Average key length: 2.28, compression ratio: 3.95 
    Average prefix length: 8.77, average data length: 0.23 
    Clustering factor: 723371, ratio: 0.06 
    Fill distribution: 
         0 - 19% = 173 
        20 - 39% = 834 
        40 - 59% = 2536 
        60 - 79% = 1768 
        80 - 99% = 5037 
 
    Index XQS_1200_2000_SND_ID (2) 
    Root page: 1398660, depth: 3, leaf buckets: 15016, nodes: 11227529 
    Average node length: 6.02, total dup: 9796468, max dup: 67 
    Average key length: 2.81, compression ratio: 3.21 
    Average prefix length: 8.32, average data length: 0.68 
    Clustering factor: 2371052, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 193 
        40 - 59% = 10956 
        60 - 79% = 3740 
        80 - 99% = 127 
 
    Index XQS_1200_2000_WORKER_ID (0) 
    Root page: 1386233, depth: 3, leaf buckets: 10665, nodes: 11227529 
    Average node length: 5.21, total dup: 11227429, max dup: 217091 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.41, average data length: 0.00 
    Clustering factor: 711262, ratio: 0.06 
    Fill distribution: 
         0 - 19% = 102 
        20 - 39% = 797 
        40 - 59% = 4737 
        60 - 79% = 1493 
        80 - 99% = 3536 
 
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: 80.91, total records: 9671796 
    Average version length: 82.92, total versions: 239623, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.56 
    Pointer pages: 107, data page slots: 174152 
    Data pages: 174128, average fill: 69% 
    Primary pages: 174098, secondary pages: 30, swept pages: 85326 
    Empty pages: 635, full pages: 104356 
    Fill distribution: 
     0 - 19% = 2006 
    20 - 39% = 9137 
    40 - 59% = 26856 
    60 - 79% = 118185 
    80 - 99% = 17944 
 
    Index XQS_2100_3300_DOC_ID (1) 
    Root page: 1344708, depth: 3, leaf buckets: 11720, nodes: 9671796 
    Average node length: 5.17, total dup: 9642977, max dup: 1536 
    Average key length: 2.03, compression ratio: 4.43 
    Average prefix length: 8.97, average data length: 0.03 
    Clustering factor: 2052202, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 26 
        20 - 39% = 1488 
        40 - 59% = 7856 
        60 - 79% = 1788 
        80 - 99% = 562 
 
    Index XQS_2100_3300_RCV_ID (3) 
    Root page: 1355739, depth: 3, leaf buckets: 13557, nodes: 9671796 
    Average node length: 6.24, total dup: 8015421, max dup: 14 
    Average key length: 3.10, compression ratio: 2.90 
    Average prefix length: 8.07, average data length: 0.93 
    Clustering factor: 1580611, ratio: 0.16 
    Fill distribution: 
         0 - 19% = 159 
        20 - 39% = 3966 
        40 - 59% = 4288 
        60 - 79% = 2746 
        80 - 99% = 2398 
 
    Index XQS_2100_3300_SND_ID (2) 
    Root page: 1350071, depth: 3, leaf buckets: 12324, nodes: 9671796 
    Average node length: 5.43, total dup: 9237063, max dup: 97 
    Average key length: 2.29, compression ratio: 3.93 
    Average prefix length: 8.76, average data length: 0.24 
    Clustering factor: 2182975, ratio: 0.23 
    Fill distribution: 
         0 - 19% = 25 
        20 - 39% = 1395 
        40 - 59% = 8772 
        60 - 79% = 1561 
        80 - 99% = 571 
 
    Index XQS_2100_3300_WORKER_ID (0) 
    Root page: 987843, depth: 3, leaf buckets: 10276, nodes: 9671796 
    Average node length: 5.14, total dup: 9671696, max dup: 159329 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.42, average data length: 0.00 
    Clustering factor: 1647694, ratio: 0.17 
    Fill distribution: 
         0 - 19% = 44 
        20 - 39% = 1346 
        40 - 59% = 5152 
        60 - 79% = 1755 
        80 - 99% = 1979 
 
XQS_3300_3400 (187) 
    Primary pointer page: 599, Index root page: 600 
    Total formats: 1, used formats: 1 
    Average record length: 67.85, total records: 578461 
    Average version length: 68.86, total versions: 3176, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.86 
    Pointer pages: 5, data page slots: 8064 
    Data pages: 8064, average fill: 75% 
    Primary pages: 8064, secondary pages: 0, swept pages: 3550 
    Empty pages: 3, full pages: 7316 
    Fill distribution: 
     0 - 19% = 3 
    20 - 39% = 3 
    40 - 59% = 68 
    60 - 79% = 7955 
    80 - 99% = 35 
 
    Index XQS_3300_3400_DOC_ID (1) 
    Root page: 38502, depth: 3, leaf buckets: 740, nodes: 578461 
    Average node length: 5.95, total dup: 492584, max dup: 83 
    Average key length: 3.09, compression ratio: 2.91 
    Average prefix length: 8.06, average data length: 0.94 
    Clustering factor: 101796, ratio: 0.18 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 26 
        40 - 59% = 527 
        60 - 79% = 99 
        80 - 99% = 88 
 
    Index XQS_3300_3400_SND_ID (2) 
    Root page: 31507, depth: 3, leaf buckets: 758, nodes: 578461 
    Average node length: 6.15, total dup: 474438, max dup: 17 
    Average key length: 3.29, compression ratio: 2.73 
    Average prefix length: 7.89, average data length: 1.11 
    Clustering factor: 101845, ratio: 0.18 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 26 
        40 - 59% = 539 
        60 - 79% = 88 
        80 - 99% = 105 
 
    Index XQS_3300_3400_WORKER_ID (0) 
    Root page: 377587, depth: 2, leaf buckets: 565, nodes: 578461 
    Average node length: 4.86, total dup: 578361, max dup: 9366 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.41, average data length: 0.00 
    Clustering factor: 90356, ratio: 0.16 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 29 
        40 - 59% = 334 
        60 - 79% = 68 
        80 - 99% = 134 
 
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 18 10:10:21 2024

Record versions statistics, table

TABLE_NAME TOTAL_RECS TOTAL_VERS MAX_VERSIONS VERS_TO_RECS_PRC MAXV_TO_VERS_PRC
DOC_DATA 7746584 53362 1 0.0000 0.0000
DOC_LIST 2242358 27424 2 0.0000 0.0000
FB_ERRORS 2182 757 1 0.0000 0.0000
INVNT_SALDO 400 2582 8 600.0000 0.0000
INVNT_TURNOVER_LOG 96068 82339 1 0.0000 0.0000
MONEY_SALDO 49 173 5 300.0000 0.0000
MONEY_TURNOVER_LOG 1374 1142 1 0.0000 0.0000
PDISTR 801414 38073 3 0.0000 0.0000
PERF_SPLIT_0 140480 1705 1 0.0000 0.0000
PERF_SPLIT_1 125185 3323 1 0.0000 0.0000
PERF_SPLIT_2 149483 19290 1 0.0000 0.0000
PERF_SPLIT_3 142930 2801 1 0.0000 0.0000
PERF_SPLIT_4 166150 9787 1 0.0000 0.0000
PERF_SPLIT_5 148065 2774 1 0.0000 0.0000
PERF_SPLIT_6 126418 922 1 0.0000 0.0000
PERF_SPLIT_7 148673 5199 1 0.0000 0.0000
PERF_SPLIT_8 151833 650 1 0.0000 0.0000
PERF_SPLIT_9 160273 16203 1 0.0000 0.0000
PSTORNED 2107925 22383 1 0.0000 0.0000
SEMAPHORES 5 1 1 0.0000 100.0000
XQD_1000_1200 160389 76196 1 0.0000 0.0000
XQD_1000_3300 6984861 383689 1 0.0000 0.0000
XQD_1200_2000 11963631 287968 1 0.0000 0.0000
XQD_2000_3300 1473056 340737 1 0.0000 0.0000
XQD_2100_3300 1190899 164192 1 0.0000 0.0000
XQD_3300_3400 9136421 277031 1 0.0000 0.0000
XQS_1000_1200 21136340 8911 1 0.0000 0.0000
XQS_1000_3300 9593818 278436 1 0.0000 0.0000
XQS_1200_2000 11227529 192116 1 0.0000 0.0000
XQS_2100_3300 9671796 239623 1 0.0000 0.0000
XQS_3300_3400 578461 3176 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 ---
:83: 
:84: mscs-test-161.budzdorov.ru    Mon Mar 18 10:08:05 2024
:85:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3400
:86: 
--- end of diff output ---

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

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