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

Hardware and OS info

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

Server and database settinfs 


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

Test configuration settings 

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

Test finish info 


FINISH_STATE                    NORMAL: TEST_TIME EXPIRED AT 2024-04-05 16:09:38
DTS_END                         2024-04-05 16:09:38.4210
FB_GDSCODE                      -1
FB_MNEMONA                      
STACK                           SP_ADD_INVOICE_TO_STOCK(190:30) ==> SP_CUSTOMER_RESERVE(47:5) ==> SP_CHECK_TO_STOP_WORK(32:12) ==> SP_HALT_ON_ERROR(57:17)
IP                              ::1/52338
TRN_ID                          174721
ATT_ID                          566
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: 8787.45 23359 878745
customer order: creation 170.33 349 17033
customer order: refuse 15.46 352 1546
order to supplier: creation 44.59 1330 4459
order to supplier: removal 3.34 103723 334
invoice (draft): creation 45.35 3612 4535
invoice (draft): removal 46.88 837 4688
invoice accept: apply 41.22 20910 4122
invoice accept: cancel 42.48 840 4248
customer reserve: creation 3915.30 201 391530
customer reserve: removal 4173.59 63 417359
realization accept: apply 83.43 215 8343
realization accept: cancel 79.50 148 7950
payment from customer: creation 57.48 152 5748
payment from customer: removal 5.38 86 538
payment to supplier: creation 47.17 163 4717
payment to supplier: removal 3.36 75 336
service: total inventory turnovers 4.56 1156 456
service: total monetary turnovers 7.18 36 718
service: aggregate perf. data 0.82 17860 82
service: refresh index statistics 0.03 315078 3

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:02, from 05-04-2024 16:10:42 to 05-04-2024 16:10:44.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 2809
TEST_TIME 2 2806
TEST_TIME 3 3482
TEST_TIME 4 2888
TEST_TIME 5 3331
TEST_TIME 6 3488
TEST_TIME 7 3902
TEST_TIME 8 4233
TEST_TIME 9 4755
TEST_TIME 10 4955
TEST_TIME 11 5298
TEST_TIME 12 5373
TEST_TIME 13 5264
TEST_TIME 14 5354
TEST_TIME 15 5358
TEST_TIME 16 5483
TEST_TIME 17 5871
TEST_TIME 18 6069
TEST_TIME 19 6385
TEST_TIME 20 6428
TEST_TIME 21 7035
TEST_TIME 22 7551
TEST_TIME 23 7892
TEST_TIME 24 7965
TEST_TIME 25 8281
TEST_TIME 26 8200
TEST_TIME 27 8794
TEST_TIME 28 8937
TEST_TIME 29 8777
TEST_TIME 30 8751
TEST_TIME 31 8900
TEST_TIME 32 8880
TEST_TIME 33 8770
TEST_TIME 34 8667
TEST_TIME 35 8515
TEST_TIME 36 8622
TEST_TIME 37 8577
TEST_TIME 38 8481
TEST_TIME 39 8402
TEST_TIME 40 8512
TEST_TIME 41 8457
TEST_TIME 42 8333
TEST_TIME 43 8311
TEST_TIME 44 8238
TEST_TIME 45 8400
TEST_TIME 46 8315
TEST_TIME 47 8194
TEST_TIME 48 8441
TEST_TIME 49 8458
TEST_TIME 50 8469
TEST_TIME 51 8430
TEST_TIME 52 8472
TEST_TIME 53 8453
TEST_TIME 54 8584
TEST_TIME 55 8784
TEST_TIME 56 8792
TEST_TIME 57 8739
TEST_TIME 58 8793
TEST_TIME 59 8775
TEST_TIME 60 8807
TEST_TIME 61 8803
TEST_TIME 62 8799
TEST_TIME 63 8761
TEST_TIME 64 8678
TEST_TIME 65 8686
TEST_TIME 66 8644
TEST_TIME 67 8668
TEST_TIME 68 8602
TEST_TIME 69 8602
TEST_TIME 70 8639
TEST_TIME 71 8598
TEST_TIME 72 8583
TEST_TIME 73 8567
TEST_TIME 74 8611
TEST_TIME 75 8648
TEST_TIME 76 8625
TEST_TIME 77 8657
TEST_TIME 78 8655
TEST_TIME 79 8685
TEST_TIME 80 8687
TEST_TIME 81 8736
TEST_TIME 82 8764
TEST_TIME 83 8795
TEST_TIME 84 8806
TEST_TIME 85 8872
TEST_TIME 86 8919
TEST_TIME 87 8850
TEST_TIME 88 8803
TEST_TIME 89 8761
TEST_TIME 90 8718
TEST_TIME 91 8707
TEST_TIME 92 8710
TEST_TIME 93 8698
TEST_TIME 94 8726
TEST_TIME 95 8781
TEST_TIME 96 8777
TEST_TIME 97 8795
TEST_TIME 98 8847
TEST_TIME 99 8847
TEST_TIME 100 8791

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:04, from 05-04-2024 16:10:45 to 05-04-2024 16:10:49.

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 1238007 1238007 0 0.00 0 35961 8 0 0
doc_list_biud 1238006 1238006 0 0.00 0 42444 27 0 0
sp_add_invoice_to_stock 4212 4122 90 2.13 32 230042 20911 0 90
sp_cancel_adding_invoice 4248 4248 0 0.00 4 73533 841 0 0
sp_cancel_client_order 1546 1546 0 0.00 4 12494 353 0 0
sp_cancel_customer_reserve 417359 417359 0 0.00 0 42446 64 0 0
sp_cancel_pay_from_customer 538 538 0 0.00 2 7552 86 0 0
sp_cancel_pay_to_supplier 336 336 0 0.00 3 2400 76 0 0
sp_cancel_supplier_invoice 4696 4688 8 0.17 1 21552 837 0 8
sp_cancel_supplier_order 334 334 0 0.00 11 848035 103724 0 0
sp_cancel_write_off 7950 7950 0 0.00 1 15049 148 0 0
sp_client_order 17033 17033 0 0.00 3 28364 349 0 0
sp_customer_reserve 391530 391530 0 0.00 0 55574 201 0 0
sp_fill_shopping_cart 26018 26018 0 0.00 1 20299 40 0 0
sp_fill_shopping_cart_clo_res 391520 391520 0 0.00 0 18809 17 0 0
sp_get_clo_for_invoice 4112 4112 0 0.00 0 30380 376 0 0
sp_kill_cost_storno 13072 13072 0 0.00 0 15046 75 0 0
sp_kill_qstorno_ret_qs2qd 847690 847690 0 0.00 0 42309 35 0 0
sp_kill_qty_storno 448579 448579 0 0.00 0 42444 75 0 0
sp_lock_selected_doc 17278 17278 0 0.00 0 9975 5 0 0
sp_make_cost_storno 22920 22920 0 0.00 0 35947 81 0 0
sp_multiply_rows_for_pdistr 22919 22919 0 0.00 0 12128 34 0 0
sp_multiply_rows_for_qdistr 17033 17033 0 0.00 0 17673 147 0 0
sp_pay_from_customer 5748 5748 0 0.00 4 30072 153 0 0
sp_pay_to_supplier 4717 4717 0 0.00 4 24580 164 0 0
sp_payment_common 10465 10465 0 0.00 1 15053 36 0 0
sp_qd_handle_on_cancel_clo 1546 1546 0 0.00 0 11736 319 0 0
sp_qd_handle_on_invoice_upd_sts 8360 8360 0 0.00 0 19192 343 0 0
sp_qd_handle_on_reserve_upd_sts 8342 8342 0 0.00 0 7872 60 0 0
sp_reserve_write_off 8343 8343 0 0.00 6 32295 215 0 0
sp_supplier_invoice 4535 4535 0 0.00 7 92338 3612 0 0
sp_supplier_order 4459 4459 0 0.00 5 49090 1330 0 0
srv_aggregate_perf_data 83 82 1 1.20 2315 216112 17861 0 1
srv_fill_mon_cache_memory 54 54 0 0.00 2186 120934 41961 0 0
srv_find_qd_qs_mism 837632 837632 0 0.00 0 10578 6 0 0
srv_make_invnt_saldo 456 456 0 0.00 41 54872 1156 0 0
srv_make_money_saldo 718 718 0 0.00 1 11139 37 0 0
srv_recalc_idx_stat 3 3 0 0.00 237360 427958 315079 0 0
t$perf-abend:sp_add_invoice_to_stock 90 90 0 0.00 0 0 0 0 0
t$perf-abend:sp_cancel_supplier_invoice 8 8 0 0.00 0 0 0 0 0
t$perf-abend:srv_aggregate_perf_data 1 1 0 0.00 0 0 0 0 0
t$perf-norm:sp_add_invoice_to_stock 4122 4122 0 0.00 0 13711 181 0 0
t$perf-norm:sp_cancel_adding_invoice 318 318 0 0.00 0 6897 116 0 0
t$perf-norm:sp_cancel_client_order 1546 1546 0 0.00 0 2533 15 0 0
t$perf-norm:sp_cancel_customer_reserve 552 552 0 0.00 0 1265 16 0 0
t$perf-norm:sp_cancel_pay_from_customer 538 538 0 0.00 0 2390 9 0 0
t$perf-norm:sp_cancel_pay_to_supplier 336 336 0 0.00 0 442 3 0 0
t$perf-norm:sp_cancel_supplier_invoice 331 331 0 0.00 0 862 15 0 0
t$perf-norm:sp_cancel_supplier_order 334 334 0 0.00 0 19417 1941 0 0
t$perf-norm:sp_cancel_write_off 869 869 0 0.00 0 824 4 0 0
t$perf-norm:sp_client_order 17033 17033 0 0.00 0 7168 17 0 0
t$perf-norm:sp_customer_reserve 829 829 0 0.00 0 827 5 0 0
t$perf-norm:sp_pay_from_customer 5748 5748 0 0.00 0 4501 10 0 0
t$perf-norm:sp_pay_to_supplier 4717 4717 0 0.00 0 5203 14 0 0
t$perf-norm:sp_reserve_write_off 8343 8343 0 0.00 0 5222 8 0 0
t$perf-norm:sp_supplier_invoice 4535 4535 0 0.00 0 4043 20 0 0
t$perf-norm:sp_supplier_order 4459 4459 0 0.00 0 3722 16 0 0
t$perf-norm:srv_aggregate_perf_data 82 82 0 0.00 0 773 13 0 0
t$perf-norm:srv_fill_mon_cache_memory 54 54 0 0.00 0 491 11 0 0
t$perf-norm:srv_make_invnt_saldo 456 456 0 0.00 0 2273 33 0 0
t$perf-norm:srv_make_money_saldo 718 718 0 0.00 0 1261 22 0 0
t$perf-norm:srv_recalc_idx_stat 3 3 0 0.00 1 9 4 0 0
v_add_invoice_to_stock 8404 8224 180 2.14 0 4849 18 0 180
v_all_customers 31162 31162 0 0.00 0 16 1 0 0
v_all_suppliers 25196 25196 0 0.00 0 27 1 0 0
v_all_wares 34060 34060 0 0.00 0 75 1 0 0
v_cancel_adding_invoice 636 636 0 0.00 0 1001 7 0 0
v_cancel_client_order 3092 3092 0 0.00 0 12411 11 0 0
v_cancel_customer_prepayment 1076 1076 0 0.00 0 7546 12 0 0
v_cancel_customer_reserve 1104 1104 0 0.00 0 1686 5 0 0
v_cancel_payment_to_supplier 672 672 0 0.00 0 1757 9 0 0
v_cancel_supplier_invoice 678 662 16 2.35 0 5245 29 0 16
v_cancel_supplier_order 668 668 0 0.00 0 870 6 0 0
v_cancel_write_off 1738 1738 0 0.00 0 11152 18 0 0
v_max_id_clo_ord 4457 4457 0 0.00 0 88 1 0 0
v_max_id_clo_res 829 829 0 0.00 0 1490 11 0 0
v_max_id_ord_sup 4531 4531 0 0.00 0 3964 6 0 0
v_max_non_paid_invoice 1107 1107 0 0.00 0 2142 5 0 0
v_max_non_paid_realizn 2868 2868 0 0.00 0 2450 4 0 0
v_min_id_clo_ord 4457 4457 0 0.00 0 15654 16 0 0
v_min_id_clo_res 829 829 0 0.00 0 4490 12 0 0
v_min_id_ord_sup 4531 4531 0 0.00 0 3930 6 0 0
v_min_non_paid_invoice 4717 4717 0 0.00 0 8998 24 0 0
v_min_non_paid_realizn 5748 5748 0 0.00 0 15046 31 0 0
v_our_firm 8658 8658 0 0.00 0 22 1 0 0
v_reserve_write_off 16684 16684 0 0.00 0 17888 15 0 0
x_lock_depdocs_on_canc_invoice 8605 8605 0 0.00 0 19855 146 0 0
x_lock_depdocs_on_canc_sup_ord 334 334 0 0.00 0 5957 361 0 0
x_make_qstorno_1000_1200 4459 4459 0 0.00 1 49079 1242 0 0
x_make_qstorno_1200_2000 4535 4535 0 0.00 3 92311 3471 0 0
x_make_qstorno_2100_3300 391530 391530 0 0.00 0 54782 181 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 05-04-2024 16:10:50 to 05-04-2024 16:10:54.

Memory consumption, metadata cache, attachments activity 

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


Page cache type: shared, buffers: 1000000 for all connections, with total size: 8192000000
measurement_dts measurement duration ms page cache memo used memo used, total memo allocated, total metadata cache metadata cache percent of total total attachments cnt active attachments cnt running statements cnt stalled statements cnt memo used by attachments memo used by transactions memo used by statements
14:09:42 1 8192000000 8797116944 8807743488 3953616 0.048 1 1 2 0 4051888 55488 42784
14:10:43 26618 8192000000 9903380688 10212925440 978623552 10.671 100 88 176 0 1007824576 6255152 22945872
14:12:15 22188 8192000000 9945431920 10267156480 1025491072 11.125 100 95 190 0 1058862256 9030304 24340880
14:13:40 14592 8192000000 9968312208 10298388480 1051812000 11.378 100 87 172 0 1083735408 10411904 21511504
14:15:03 11237 8192000000 10028513776 10371821568 1109131152 11.924 100 87 173 0 1141934288 12179872 20623264
14:16:25 8462 8192000000 10063993904 10421850112 1152258896 12.331 100 74 146 0 1181917008 12892688 16765424
14:17:37 4549 8192000000 10105658416 10474405888 1200435888 12.780 100 74 148 0 1229969712 13412656 16121168
14:18:44 2045 8192000000 10152315168 10526117888 1240926400 13.155 100 78 156 0 1269790832 11968608 16895824
14:19:49 1523 8192000000 10183772624 10564886528 1273602672 13.455 100 85 170 0 1305881632 13038976 19239984
14:20:52 990 8192000000 10209004000 10591268864 1289984944 13.604 100 87 175 0 1323463696 13369776 20108976
14:21:55 12760 8192000000 10195662768 10602176512 1301541984 13.709 100 46 92 0 1319884064 8169568 10172512
14:23:10 5441 8192000000 10196575648 10610491392 1312142336 13.806 100 22 44 0 1323309376 6408448 4758592
14:24:17 3140 8192000000 10208163680 10623455232 1320844496 13.884 100 29 56 1 1334280688 7335040 6101152
14:25:21 6600 8192000000 10218695680 10634366976 1330177792 13.969 100 41 82 0 1345884176 6900784 8805600
14:26:29 14107 8192000000 10237999840 10647203840 1336094192 14.022 100 60 119 0 1355903024 6105616 13703216
14:27:43 1288 8192000000 10230636976 10648543232 1335515856 14.017 100 38 76 2 1350205376 6815408 7874112
14:28:47 9195 8192000000 10215333680 10633535488 1305824144 13.748 98 20 38 1 1316179360 5752848 4602368
14:30:03 22792 8192000000 10208600736 10614259712 1298445232 13.681 99 36 73 0 1315100112 8517312 8137568
14:31:35 30220 8192000000 10220807536 10624090112 1301636560 13.710 98 39 78 0 1321824784 11159040 9029184
14:33:07 71583 8192000000 10231179312 10645614592 1317112128 13.851 99 44 88 3 1339508288 12376112 10020048
14:35:46 52587 8192000000 10200394992 10607599616 1260349888 13.333 94 41 78 1 1283547408 14093792 9103728
14:37:43 48812 8192000000 10213874384 10631397376 1274959136 13.467 96 36 72 0 1301606720 17493776 9153808
14:39:41 21073 8192000000 10226614768 10635354112 1296922048 13.667 98 40 79 0 1324996224 18575760 9498416
14:41:06 5074 8192000000 10258241312 10660487168 1334889584 14.011 100 67 131 0 1370578416 19611104 16077728
14:42:25 10462 8192000000 10256368944 10653294592 1323736448 13.911 99 64 125 2 1357700928 20042096 13922384
14:43:41 6747 8192000000 10256895264 10660843520 1328510768 13.954 100 55 110 2 1370056784 27581104 13964912
14:44:56 2352 8192000000 10300670960 10694520832 1345570848 14.108 99 85 169 1 1398723872 32045088 21107936
14:46:06 2468 8192000000 10324302416 10723463168 1375827744 14.379 100 73 146 1 1428382560 34133360 18421456
14:47:15 2184 8192000000 10339262880 10741698560 1383650096 14.449 100 74 147 2 1440473872 37715216 19108560
14:48:24 3538 8192000000 10333755568 10741878784 1370907808 14.335 99 73 144 0 1431243632 42036640 18299184
14:49:33 5916 8192000000 10348655888 10759008256 1390453520 14.510 100 72 143 0 1453123184 44050512 18619152
14:50:47 3409 8192000000 10344820064 10763558912 1398703232 14.583 100 61 122 0 1449717536 35533840 15480464
14:51:53 14570 8192000000 10326366640 10763919360 1391361232 14.518 100 32 63 0 1433350352 33189824 8799296
14:53:11 24472 8192000000 10328773200 10766094336 1390807200 14.513 100 22 44 0 1428905360 31969376 6128784
14:54:38 54345 8192000000 10324379184 10759204864 1382499632 14.439 100 21 40 3 1426997616 38846688 5651296
14:56:34 13181 8192000000 10311215856 10760728576 1388114176 14.489 100 31 62 1 1430307104 34280848 7912080
14:58:56 42245 8192000000 10310331360 10748641280 1389652432 14.503 100 45 83 1 1415836048 14684528 11499088
15:00:40 17475 8192000000 10302784736 10749427712 1396338752 14.562 100 27 54 0 1412445904 10349232 5757920
15:02:06 69310 8192000000 10297504688 10753171456 1399939632 14.594 100 16 32 0 1412206576 8708704 3558240
15:04:21 89446 8192000000 10310456832 10768334848 1409994384 14.684 100 14 28 0 1427159056 13696720 3467952
15:06:53 56507 8192000000 10321710640 10763157504 1410619584 14.689 100 33 64 1 1426072512 8035568 7417360
15:08:51 94998 8192000000 10286140336 10748022784 1356543392 14.206 96 21 42 0 1372973152 11963120 4466640
15:11:31 33988 8192000000 10313379200 10769473536 1417533824 14.751 100 23 44 0 1431412960 8799376 5079760
15:13:06 21780 8192000000 10319459104 10753437696 1397868816 14.576 100 51 98 1 1422819488 13185392 11765280
15:14:30 34608 8192000000 10302723008 10765627392 1397141936 14.570 100 23 46 0 1416062320 13967040 4953344
15:16:15 63524 8192000000 10290133312 10739953664 1377844256 14.397 99 25 51 0 1397327872 13502464 5981152
15:19:48 41831 8192000000 10308687504 10751369216 1372173104 14.347 98 24 47 0 1388132976 11436800 4523072
15:21:31 56609 8192000000 10301649904 10753454080 1369718016 14.325 98 17 33 0 1388214272 14837296 3658960
15:23:45 39166 8192000000 10283652064 10725343232 1323244640 13.906 95 33 64 1 1349473504 18872528 7356336
15:25:25 69707 8192000000 10274350576 10712596480 1317780272 13.857 97 10 20 0 1329881280 10094864 2006144
15:27:41 63344 8192000000 10262601856 10704748544 1307502448 13.763 96 17 34 0 1325339648 14387024 3450176
15:29:47 69744 8192000000 10246734480 10676465664 1274909936 13.467 95 30 59 0 1292959248 11754656 6294656
15:32:01 93577 8192000000 10275138144 10711187456 1348448256 14.134 100 43 86 1 1379648032 21288896 9910880
15:34:57 14243 8192000000 10245444224 10688770048 1337223328 14.032 100 18 36 0 1353719744 12552672 3943744
15:36:12 26300 8192000000 10241946720 10686377984 1317651952 13.855 98 23 46 1 1337500608 14461248 5387408
15:37:40 48670 8192000000 10241668976 10686902272 1333664432 14.000 99 18 36 0 1348657360 10811840 4181088
15:39:30 39843 8192000000 10246499808 10676588544 1325195024 13.924 99 27 54 0 1339185664 7890832 6099808
15:41:10 23722 8192000000 10240538912 10684465152 1341218992 14.068 100 20 40 2 1352261216 7315808 3726416
15:42:34 44682 8192000000 10259667136 10693566464 1309971312 13.786 97 34 68 0 1331289072 13752128 7565632
15:44:23 36983 8192000000 10247293264 10687000576 1333662048 14.000 99 18 36 1 1345159744 7702256 3795440
15:46:03 71379 8192000000 10259962272 10705432576 1340645504 14.063 98 18 35 0 1353366528 9083920 3637104
15:48:15 51085 8192000000 10285242896 10724380672 1360500304 14.242 99 27 54 0 1376335104 9676784 6158016
15:50:07 84110 8192000000 10289754288 10738515968 1367405600 14.304 99 15 30 0 1385844880 14410288 4028992
15:52:53 69151 8192000000 10304229792 10740973568 1370017072 14.327 99 27 53 0 1390284816 14743312 5524432
15:55:08 65568 8192000000 10278142144 10699640832 1322414304 13.899 95 30 60 1 1339394064 10390592 6589168
15:57:18 120934 8192000000 10259336768 10703572992 1304688384 13.738 95 17 34 0 1320509872 11980144 3841344
16:00:19 46458 8192000000 10257908624 10716971008 1351827536 14.164 99 17 34 0 1369580912 13999456 3753920
16:03:37 34343 8192000000 10282107200 10735550464 1376242496 14.383 99 24 48 0 1393393904 11554064 5597344
16:05:27 45232 8192000000 10294029360 10741972992 1385866944 14.469 100 18 36 0 1402143760 11996496 4280320
16:07:17 69621 8192000000 10267391216 10709958656 1293706336 13.638 94 12 24 0 1307906672 11734576 2465760
16:09:31 19866 8192000000 9032175024 9227055104 198827984 2.369 15 3 6 0 204456304 5250912 377408

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:13, from 05-04-2024 16:10:56 to 05-04-2024 16:11:09.

Exceptions occured during test was in run

FB_MNEMONA CNT UNIT FB_GDSCODE
except 1 srv_aggregate_perf_data 335544517
except 90 v_add_invoice_to_stock 335544517
except 8 v_cancel_supplier_invoice 335544517

Completed "Exceptions occured during test was in run". Done for 00:00:02, from 05-04-2024 16:11:10 to 05-04-2024 16:11:12.

Content of mon$database and FB version 


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


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

Database statistics 

 
Database "/home/bases/oltp30-etalone.fdb" 
Gstat execution time Fri Apr  5 16:11:13 2024 
 
Database header page information: 
    Flags            0 
    Generation        91423 
    System Change Number    0 
    Page size        8192 
    ODS version        12.0 
    Oldest transaction    173428 
    Oldest active        175006 
    Oldest snapshot        175006 
    Next transaction    175007 
    Sequence number        0 
    Next attachment ID    713 
    Implementation        HW=AMD/Intel/x64 little-endian OS=Linux CC=gcc 
    Shadow count        0 
    Page buffers        0 
    Next header page    0 
    Database dialect    3 
    Creation date        Apr 3, 2020 16:41:55 
    Attributes        force write 
 
    Variable header data: 
    Sweep interval:        0 
    Unrecognized option 11, length 16 
    *END* 
 
 
Database file sequence: 
File /home/bases/oltp30-etalone.fdb is the only file 
 
Analyzing database pages ... 
AGENTS (150) 
    Primary pointer page: 496, Index root page: 497 
    Total formats: 1, used formats: 1 
    Average record length: 33.60, total records: 50 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 344.00, compression ratio: 10.24 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 31% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 1 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index AGENTS_ID_DESC (2) 
    Root page: 1504311, depth: 1, leaf buckets: 1, nodes: 50 
    Average node length: 11.82, total dup: 0, max dup: 0 
    Average key length: 10.80, compression ratio: 0.83 
    Average prefix length: 1.18, average data length: 7.82 
    Clustering factor: 1, ratio: 0.02 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index AGENTS_IS_OUR_FIRM (4) 
    Root page: 1504313, depth: 1, leaf buckets: 1, nodes: 50 
    Average node length: 3.08, total dup: 48, max dup: 48 
    Average key length: 2.04, compression ratio: 0.50 
    Average prefix length: 0.96, average data length: 0.06 
    Clustering factor: 1, ratio: 0.02 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index AGENTS_IS_SUPPLIER (3) 
    Root page: 1504312, depth: 1, leaf buckets: 1, nodes: 50 
    Average node length: 3.08, total dup: 48, max dup: 44 
    Average key length: 2.04, compression ratio: 0.54 
    Average prefix length: 1.04, average data length: 0.06 
    Clustering factor: 1, ratio: 0.02 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index AGENTS_NAME_UNQ (1) 
    Root page: 1504310, depth: 1, leaf buckets: 1, nodes: 50 
    Average node length: 17.20, total dup: 0, max dup: 0 
    Average key length: 15.88, compression ratio: 0.92 
    Average prefix length: 1.42, average data length: 13.20 
    Clustering factor: 1, ratio: 0.02 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PK_AGENTS (0) 
    Root page: 1504309, depth: 1, leaf buckets: 1, nodes: 50 
    Average node length: 11.82, total dup: 0, max dup: 0 
    Average key length: 10.80, compression ratio: 0.83 
    Average prefix length: 1.18, average data length: 7.82 
    Clustering factor: 1, ratio: 0.02 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
BUSINESS_OPS (154) 
    Primary pointer page: 504, Index root page: 505 
    Total formats: 1, used formats: 1 
    Average record length: 108.20, total records: 20 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1235.00, compression ratio: 11.41 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 31% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 1 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index BO_UNIT_UNQ (1) 
    Root page: 1504242, depth: 1, leaf buckets: 1, nodes: 20 
    Average node length: 18.25, total dup: 0, max dup: 0 
    Average key length: 17.20, compression ratio: 1.24 
    Average prefix length: 7.05, average data length: 14.25 
    Clustering factor: 1, ratio: 0.05 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index BUSINESS_OPS_PREDICT_PRIOR (3) 
    Root page: 1504244, depth: 1, leaf buckets: 1, nodes: 20 
    Average node length: 5.40, total dup: 0, max dup: 0 
    Average key length: 4.35, compression ratio: 0.67 
    Average prefix length: 1.20, average data length: 1.70 
    Clustering factor: 1, ratio: 0.05 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index BUSINESS_OPS_RND_WGTH (2) 
    Root page: 1504243, depth: 1, leaf buckets: 1, nodes: 20 
    Average node length: 4.30, total dup: 6, max dup: 3 
    Average key length: 3.25, compression ratio: 0.72 
    Average prefix length: 1.35, average data length: 1.00 
    Clustering factor: 1, ratio: 0.05 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index RDB$1 (0) 
    Root page: 1504241, depth: 1, leaf buckets: 1, nodes: 20 
    Average node length: 5.20, total dup: 0, max dup: 0 
    Average key length: 4.15, compression ratio: 0.65 
    Average prefix length: 1.10, average data length: 1.60 
    Clustering factor: 1, ratio: 0.05 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
DOC_DATA (139) 
    Primary pointer page: 474, Index root page: 475 
    Total formats: 1, used formats: 1 
    Average record length: 47.17, total records: 7813987 
    Average version length: 48.16, total versions: 117852, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 64.00, compression ratio: 1.36 
    Pointer pages: 53, data page slots: 86400 
    Data pages: 86400, average fill: 72% 
    Primary pages: 86400, secondary pages: 0, swept pages: 13178 
    Empty pages: 2, full pages: 74652 
    Fill distribution: 
     0 - 19% = 9 
    20 - 39% = 73 
    40 - 59% = 1143 
    60 - 79% = 85139 
    80 - 99% = 36 
 
    Index DOC_DATA_DOC_WARE_UNQ (0) 
    Root page: 1510614, depth: 3, leaf buckets: 23291, nodes: 7813987 
    Average node length: 18.92, total dup: 0, max dup: 0 
    Average key length: 15.93, compression ratio: 1.70 
    Average prefix length: 14.07, average data length: 12.93 
    Clustering factor: 1750342, ratio: 0.22 
    Fill distribution: 
         0 - 19% = 325 
        20 - 39% = 1598 
        40 - 59% = 4208 
        60 - 79% = 2240 
        80 - 99% = 14920 
 
    Index DOC_DATA_ID_DESC (1) 
    Root page: 1528118, depth: 3, leaf buckets: 13504, nodes: 7813987 
    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: 1572626, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 1383 
        40 - 59% = 2163 
        60 - 79% = 975 
        80 - 99% = 8983 
 
    Index FK_DOC_DATA_DOC_LIST (2) 
    Root page: 1546711, depth: 3, leaf buckets: 8352, nodes: 7813987 
    Average node length: 6.63, total dup: 5821887, max dup: 49 
    Average key length: 3.65, compression ratio: 2.47 
    Average prefix length: 7.61, average data length: 1.39 
    Clustering factor: 1565576, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 136 
        20 - 39% = 873 
        40 - 59% = 1428 
        60 - 79% = 826 
        80 - 99% = 5089 
 
DOC_LIST (138) 
    Primary pointer page: 472, Index root page: 473 
    Total formats: 1, used formats: 1 
    Average record length: 55.95, total records: 2282004 
    Average version length: 34.62, total versions: 119773, max versions: 4 
    Average fragment length: 6.67, total fragments: 3, max fragments: 1 
    Average unpacked length: 84.00, compression ratio: 1.50 
    Pointer pages: 18, data page slots: 28304 
    Data pages: 28304, average fill: 75% 
    Primary pages: 28298, secondary pages: 6, swept pages: 7746 
    Empty pages: 8, full pages: 24162 
    Fill distribution: 
     0 - 19% = 20 
    20 - 39% = 66 
    40 - 59% = 1018 
    60 - 79% = 25790 
    80 - 99% = 1410 
 
    Index DOC_LIST_ID_DESC (1) 
    Root page: 1541130, depth: 3, leaf buckets: 4564, nodes: 2282004 
    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: 701102, ratio: 0.31 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 839 
        40 - 59% = 889 
        60 - 79% = 660 
        80 - 99% = 2176 
 
    Index DOC_LIST_WORKER_OPTYPE (2) 
    Root page: 1544376, depth: 3, leaf buckets: 2530, nodes: 2284960 
    Average node length: 4.97, total dup: 2284061, max dup: 19861 
    Average key length: 2.01, compression ratio: 4.47 
    Average prefix length: 8.99, average data length: 0.01 
    Clustering factor: 1259028, ratio: 0.55 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 217 
        40 - 59% = 1560 
        60 - 79% = 558 
        80 - 99% = 194 
 
    Index FK_DOC_LIST_AGENTS (3) 
    Root page: 1545909, depth: 3, leaf buckets: 1987, nodes: 2282004 
    Average node length: 4.97, total dup: 2281954, max dup: 130389 
    Average key length: 2.01, compression ratio: 4.48 
    Average prefix length: 8.99, average data length: 0.01 
    Clustering factor: 1065380, ratio: 0.47 
    Fill distribution: 
         0 - 19% = 4 
        20 - 39% = 12 
        40 - 59% = 1044 
        60 - 79% = 59 
        80 - 99% = 868 
 
    Index PK_DOC_LIST (0) 
    Root page: 1538187, depth: 3, leaf buckets: 4358, nodes: 2282004 
    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: 701102, ratio: 0.31 
    Fill distribution: 
         0 - 19% = 97 
        20 - 39% = 557 
        40 - 59% = 620 
        60 - 79% = 732 
        80 - 99% = 2352 
 
DOC_STATES (149) 
    Primary pointer page: 494, Index root page: 495 
    Total formats: 1, used formats: 1 
    Average record length: 67.50, total records: 4 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 650.00, compression ratio: 9.63 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 4% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index DOC_STATES_MCODE_UNQ (1) 
    Root page: 1504315, depth: 1, leaf buckets: 1, nodes: 4 
    Average node length: 17.75, total dup: 0, max dup: 0 
    Average key length: 16.50, compression ratio: 1.08 
    Average prefix length: 4.00, average data length: 13.75 
    Clustering factor: 1, ratio: 0.25 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index DOC_STATES_NAME_UNQ (2) 
    Root page: 1504316, depth: 1, leaf buckets: 1, nodes: 4 
    Average node length: 33.25, total dup: 0, max dup: 0 
    Average key length: 32.00, compression ratio: 0.99 
    Average prefix length: 2.50, average data length: 29.25 
    Clustering factor: 1, ratio: 0.25 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PK_DOC_STATES (0) 
    Root page: 1504314, depth: 1, leaf buckets: 1, nodes: 4 
    Average node length: 4.75, total dup: 0, max dup: 0 
    Average key length: 3.50, compression ratio: 0.86 
    Average prefix length: 1.50, average data length: 1.50 
    Clustering factor: 1, ratio: 0.25 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
FB_ERRORS (155) 
    Primary pointer page: 506, Index root page: 507 
    Total formats: 2, used formats: 2 
    Average record length: 54.76, total records: 2182 
    Average version length: 79.61, total versions: 757, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 270.43, compression ratio: 4.94 
    Pointer pages: 1, data page slots: 40 
    Data pages: 40, average fill: 70% 
    Primary pages: 40, secondary pages: 0, swept pages: 0 
    Empty pages: 7, full pages: 32 
    Fill distribution: 
     0 - 19% = 7 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 7 
    80 - 99% = 26 
 
    Index FB_ERRORS_GDS_CODE (0) 
    Root page: 382, depth: 2, leaf buckets: 2, nodes: 2182 
    Average node length: 4.40, total dup: 756, max dup: 1 
    Average key length: 2.67, compression ratio: 1.87 
    Average prefix length: 4.33, average data length: 0.67 
    Clustering factor: 1515, ratio: 0.69 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 0 
        40 - 59% = 1 
        60 - 79% = 1 
        80 - 99% = 0 
 
INVNT_SALDO (145) 
    Primary pointer page: 486, Index root page: 487 
    Total formats: 2, used formats: 1 
    Average record length: 82.63, total records: 400 
    Average version length: 23.21, total versions: 229790, max versions: 594 
    Average fragment length: 2.00, total fragments: 40, max fragments: 1 
    Average unpacked length: 104.00, compression ratio: 1.26 
    Pointer pages: 1, data page slots: 1272 
    Data pages: 1272, average fill: 90% 
    Primary pages: 14, secondary pages: 1258, swept pages: 0 
    Empty pages: 7, full pages: 1264 
    Fill distribution: 
     0 - 19% = 7 
    20 - 39% = 0 
    40 - 59% = 1 
    60 - 79% = 0 
    80 - 99% = 1264 
 
    Index PK_INVNT_SALDO (0) 
    Root page: 1510349, depth: 1, leaf buckets: 1, nodes: 400 
    Average node length: 11.22, total dup: 0, max dup: 0 
    Average key length: 10.22, compression ratio: 0.88 
    Average prefix length: 1.78, average data length: 7.22 
    Clustering factor: 326, ratio: 0.81 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 0 
        40 - 59% = 1 
        60 - 79% = 0 
        80 - 99% = 0 
 
INVNT_TURNOVER_LOG (153) 
    Primary pointer page: 502, Index root page: 503 
    Total formats: 1, used formats: 1 
    Average record length: 3.07, total records: 66260 
    Average version length: 68.29, total versions: 63279, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 88.00, compression ratio: 28.66 
    Pointer pages: 6, data page slots: 2776 
    Data pages: 1885, average fill: 45% 
    Primary pages: 1884, secondary pages: 1, swept pages: 0 
    Empty pages: 513, full pages: 613 
    Fill distribution: 
     0 - 19% = 671 
    20 - 39% = 238 
    40 - 59% = 220 
    60 - 79% = 203 
    80 - 99% = 553 
 
    Index INVNT_TURNOVER_LOG_WARE_DD_ID (0) 
    Root page: 1708751, depth: 3, leaf buckets: 309, nodes: 66260 
    Average node length: 13.43, total dup: 4188, max dup: 2 
    Average key length: 10.76, compression ratio: 2.51 
    Average prefix length: 19.17, average data length: 7.83 
    Clustering factor: 47533, ratio: 0.72 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 222 
        40 - 59% = 78 
        60 - 79% = 8 
        80 - 99% = 1 
 
MONEY_SALDO (141) 
    Primary pointer page: 478, Index root page: 479 
    Total formats: 1, used formats: 1 
    Average record length: 15.24, total records: 49 
    Average version length: 9.00, total versions: 18526, max versions: 1027 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 32.00, compression ratio: 2.10 
    Pointer pages: 1, data page slots: 72 
    Data pages: 72, average fill: 83% 
    Primary pages: 7, secondary pages: 65, swept pages: 0 
    Empty pages: 6, full pages: 65 
    Fill distribution: 
     0 - 19% = 6 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 9 
    80 - 99% = 57 
 
    Index PK_MONEY_SALDO (0) 
    Root page: 1510361, depth: 1, leaf buckets: 1, nodes: 49 
    Average node length: 11.82, total dup: 0, max dup: 0 
    Average key length: 10.80, compression ratio: 0.83 
    Average prefix length: 1.18, average data length: 7.82 
    Clustering factor: 1, ratio: 0.02 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
MONEY_TURNOVER_LOG (140) 
    Primary pointer page: 476, Index root page: 477 
    Total formats: 1, used formats: 1 
    Average record length: 3.00, total records: 836 
    Average version length: 43.26, total versions: 778, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 58.00, compression ratio: 19.36 
    Pointer pages: 1, data page slots: 32 
    Data pages: 29, average fill: 30% 
    Primary pages: 27, secondary pages: 2, swept pages: 0 
    Empty pages: 9, full pages: 3 
    Fill distribution: 
     0 - 19% = 15 
    20 - 39% = 6 
    40 - 59% = 1 
    60 - 79% = 5 
    80 - 99% = 2 
 
    Index MONEY_TURNOVER_LOG_AGENT_OPTYPE (0) 
    Root page: 88465, depth: 2, leaf buckets: 2, nodes: 836 
    Average node length: 5.09, total dup: 739, max dup: 100 
    Average key length: 3.24, compression ratio: 5.87 
    Average prefix length: 17.88, average data length: 1.12 
    Clustering factor: 477, ratio: 0.57 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 2 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
MON_CACHE_MEMORY (165) 
    Primary pointer page: 526, Index root page: 527 
    Total formats: 2, used formats: 1 
    Average record length: 97.01, total records: 71 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 112.00, compression ratio: 1.15 
    Pointer pages: 1, data page slots: 2 
    Data pages: 2, average fill: 50% 
    Primary pages: 2, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 1 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 1 
 
    Index PK_MON_CACHE_MEMORY (0) 
    Root page: 1504215, depth: 1, leaf buckets: 1, nodes: 71 
    Average node length: 11.70, total dup: 0, max dup: 0 
    Average key length: 10.69, compression ratio: 0.84 
    Average prefix length: 1.30, average data length: 7.70 
    Clustering factor: 2, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
MON_LOG (162) 
    Primary pointer page: 520, Index root page: 521 
    Total formats: 2, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index MON_LOG_DTS (4) 
    Root page: 1504229, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index MON_LOG_GDSCODE (2) 
    Root page: 1504227, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index MON_LOG_ROWSET_DESC (1) 
    Root page: 1504226, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index MON_LOG_UNIT (3) 
    Root page: 1504228, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PK_MON_LOG (0) 
    Root page: 1504225, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
MON_LOG_TABLE_STATS (163) 
    Primary pointer page: 522, Index root page: 523 
    Total formats: 2, used formats: 1 
    Average record length: 67.13, total records: 30 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 611.00, compression ratio: 9.10 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 31% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 1 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index MON_LOG_TABLE_STATS_DTS (4) 
    Root page: 1504224, depth: 1, leaf buckets: 1, nodes: 30 
    Average node length: 3.50, total dup: 23, max dup: 4 
    Average key length: 2.47, compression ratio: 3.24 
    Average prefix length: 7.53, average data length: 0.47 
    Clustering factor: 1, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index MON_LOG_TABLE_STATS_GDSCODE (2) 
    Root page: 1504222, depth: 1, leaf buckets: 1, nodes: 30 
    Average node length: 2.00, total dup: 29, max dup: 29 
    Average key length: 1.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 1, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index MON_LOG_TABLE_STATS_ROWSET (1) 
    Root page: 1504221, depth: 1, leaf buckets: 1, nodes: 30 
    Average node length: 3.33, total dup: 29, max dup: 29 
    Average key length: 2.30, compression ratio: 3.91 
    Average prefix length: 8.70, average data length: 0.30 
    Clustering factor: 1, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index MON_LOG_TABLE_STATS_TN_UNIT (3) 
    Root page: 1504223, depth: 1, leaf buckets: 1, nodes: 30 
    Average node length: 12.90, total dup: 0, max dup: 0 
    Average key length: 11.87, compression ratio: 1.42 
    Average prefix length: 7.63, average data length: 9.20 
    Clustering factor: 1, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PK_MON_LOG_TABLE_STATS (0) 
    Root page: 1504220, depth: 1, leaf buckets: 1, nodes: 30 
    Average node length: 8.37, total dup: 0, max dup: 0 
    Average key length: 7.33, compression ratio: 1.23 
    Average prefix length: 4.63, average data length: 4.37 
    Clustering factor: 1, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
OPTYPES (136) 
    Primary pointer page: 468, Index root page: 469 
    Total formats: 2, used formats: 1 
    Average record length: 67.56, total records: 9 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 386.00, compression ratio: 5.71 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 9% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index OPTYPES_MCODE_UNQ (1) 
    Root page: 1544805, depth: 1, leaf buckets: 1, nodes: 9 
    Average node length: 8.56, total dup: 0, max dup: 0 
    Average key length: 6.89, compression ratio: 0.73 
    Average prefix length: 0.44, average data length: 4.56 
    Clustering factor: 1, ratio: 0.11 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PK_OPTYPES (0) 
    Root page: 1544804, depth: 1, leaf buckets: 1, nodes: 9 
    Average node length: 6.11, total dup: 0, max dup: 0 
    Average key length: 5.00, compression ratio: 0.60 
    Average prefix length: 0.89, average data length: 2.11 
    Clustering factor: 1, ratio: 0.11 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
PDISTR (146) 
    Primary pointer page: 488, Index root page: 489 
    Total formats: 1, used formats: 1 
    Average record length: 35.78, total records: 811267 
    Average version length: 25.48, total versions: 80509, max versions: 4 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 54.00, compression ratio: 1.51 
    Pointer pages: 5, data page slots: 7960 
    Data pages: 7952, average fill: 72% 
    Primary pages: 7942, secondary pages: 10, swept pages: 1073 
    Empty pages: 27, full pages: 7204 
    Fill distribution: 
     0 - 19% = 51 
    20 - 39% = 27 
    40 - 59% = 53 
    60 - 79% = 7489 
    80 - 99% = 332 
 
    Index PDISTR_AGENT_ID (2) 
    Root page: 1509308, depth: 2, leaf buckets: 876, nodes: 811267 
    Average node length: 4.87, total dup: 811218, max dup: 145308 
    Average key length: 2.01, compression ratio: 4.48 
    Average prefix length: 8.99, average data length: 0.01 
    Clustering factor: 91173, ratio: 0.11 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 103 
        40 - 59% = 500 
        60 - 79% = 205 
        80 - 99% = 67 
 
    Index PDISTR_SNDOP_RCVOP_SNDID_ASC (0) 
    Root page: 1508613, depth: 3, leaf buckets: 949, nodes: 811267 
    Average node length: 5.88, total dup: 722423, max dup: 42 
    Average key length: 3.02, compression ratio: 7.29 
    Average prefix length: 21.09, average data length: 0.91 
    Clustering factor: 162598, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 95 
        40 - 59% = 448 
        60 - 79% = 113 
        80 - 99% = 293 
 
    Index PDISTR_SNDOP_RCVOP_SNDID_DESC (1) 
    Root page: 1509187, depth: 3, leaf buckets: 980, nodes: 811267 
    Average node length: 5.88, total dup: 722423, max dup: 42 
    Average key length: 3.02, compression ratio: 7.29 
    Average prefix length: 21.09, average data length: 0.91 
    Clustering factor: 164576, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 177 
        40 - 59% = 397 
        60 - 79% = 104 
        80 - 99% = 301 
 
    Index PDISTR_WORKER_SND_ID (3) 
    Root page: 1510178, depth: 3, leaf buckets: 1156, nodes: 811267 
    Average node length: 5.96, total dup: 722423, max dup: 42 
    Average key length: 3.10, compression ratio: 5.49 
    Average prefix length: 16.01, average data length: 0.99 
    Clustering factor: 157629, ratio: 0.19 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 256 
        40 - 59% = 607 
        60 - 79% = 204 
        80 - 99% = 87 
 
PERF_AGG (158) 
    Primary pointer page: 512, Index root page: 513 
    Total formats: 1, used formats: 1 
    Average record length: 62.80, total records: 5422 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 2.46, total fragments: 61, max fragments: 1 
    Average unpacked length: 379.00, compression ratio: 6.03 
    Pointer pages: 1, data page slots: 96 
    Data pages: 96, average fill: 56% 
    Primary pages: 76, secondary pages: 20, swept pages: 52 
    Empty pages: 16, full pages: 62 
    Fill distribution: 
     0 - 19% = 25 
    20 - 39% = 1 
    40 - 59% = 1 
    60 - 79% = 69 
    80 - 99% = 0 
 
    Index PERF_AGG_UNQ (1) 
    Root page: 1504238, depth: 2, leaf buckets: 6, nodes: 5422 
    Average node length: 5.48, total dup: 0, max dup: 0 
    Average key length: 3.59, compression ratio: 10.01 
    Average prefix length: 34.35, average data length: 1.55 
    Clustering factor: 5100, 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: 1504233, depth: 2, leaf buckets: 10, nodes: 5422 
    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: 138, 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: 1504218, Index root page: 1504219 
    Total formats: 1, used formats: 1 
    Average record length: 39.16, total records: 79604 
    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: 768 
    Data pages: 768, average fill: 71% 
    Primary pages: 768, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 767 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 768 
    80 - 99% = 0 
 
    Index PK_PERF_ESTIMATED (0) 
    Root page: 39842, depth: 2, leaf buckets: 101, nodes: 79604 
    Average node length: 10.16, total dup: 0, max dup: 0 
    Average key length: 8.17, compression ratio: 1.10 
    Average prefix length: 3.83, average data length: 5.17 
    Clustering factor: 3049, ratio: 0.04 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 0 
        40 - 59% = 1 
        60 - 79% = 0 
        80 - 99% = 100 
 
PERF_ISQL_STAT (156) 
    Primary pointer page: 508, Index root page: 509 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index PERF_ISQL_STAT_TRN (0) 
    Root page: 1504239, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
PERF_LOG (159) 
    Primary pointer page: 514, Index root page: 515 
    Total formats: 1, used formats: 1 
    Average record length: 111.12, total records: 72 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1691.00, compression ratio: 15.22 
    Pointer pages: 1, data page slots: 2 
    Data pages: 2, average fill: 57% 
    Primary pages: 2, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 1 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 1 
    40 - 59% = 0 
    60 - 79% = 1 
    80 - 99% = 0 
 
PERF_SPLIT_0 (281) 
    Primary pointer page: 573, Index root page: 574 
    Total formats: 1, used formats: 1 
    Average record length: 146.25, total records: 176207 
    Average version length: 149.90, total versions: 5513, 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: 7, data page slots: 5312 
    Data pages: 4288, average fill: 85% 
    Primary pages: 4288, secondary pages: 0, swept pages: 4 
    Empty pages: 99, full pages: 4158 
    Fill distribution: 
     0 - 19% = 101 
    20 - 39% = 12 
    40 - 59% = 8 
    60 - 79% = 9 
    80 - 99% = 4158 
 
PERF_SPLIT_1 (282) 
    Primary pointer page: 576, Index root page: 577 
    Total formats: 1, used formats: 1 
    Average record length: 145.89, total records: 169725 
    Average version length: 149.81, total versions: 5752, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.63 
    Pointer pages: 8, data page slots: 5432 
    Data pages: 4104, average fill: 85% 
    Primary pages: 4102, secondary pages: 2, swept pages: 1 
    Empty pages: 71, full pages: 4013 
    Fill distribution: 
     0 - 19% = 77 
    20 - 39% = 7 
    40 - 59% = 3 
    60 - 79% = 5 
    80 - 99% = 4012 
 
PERF_SPLIT_2 (283) 
    Primary pointer page: 578, Index root page: 579 
    Total formats: 1, used formats: 1 
    Average record length: 146.31, total records: 159259 
    Average version length: 148.38, total versions: 4465, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.59 
    Pointer pages: 6, data page slots: 5216 
    Data pages: 3888, average fill: 84% 
    Primary pages: 3888, secondary pages: 0, swept pages: 1 
    Empty pages: 112, full pages: 3749 
    Fill distribution: 
     0 - 19% = 112 
    20 - 39% = 12 
    40 - 59% = 10 
    60 - 79% = 5 
    80 - 99% = 3749 
 
PERF_SPLIT_3 (284) 
    Primary pointer page: 580, Index root page: 581 
    Total formats: 1, used formats: 1 
    Average record length: 143.97, total records: 177912 
    Average version length: 151.86, total versions: 8445, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.78 
    Pointer pages: 6, data page slots: 5424 
    Data pages: 4320, average fill: 85% 
    Primary pages: 4320, secondary pages: 0, swept pages: 3 
    Empty pages: 88, full pages: 4208 
    Fill distribution: 
     0 - 19% = 93 
    20 - 39% = 8 
    40 - 59% = 4 
    60 - 79% = 9 
    80 - 99% = 4206 
 
PERF_SPLIT_4 (285) 
    Primary pointer page: 582, Index root page: 583 
    Total formats: 1, used formats: 1 
    Average record length: 129.67, total records: 182082 
    Average version length: 153.67, total versions: 25684, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 13.08 
    Pointer pages: 7, data page slots: 5320 
    Data pages: 4440, average fill: 86% 
    Primary pages: 4440, secondary pages: 0, swept pages: 3 
    Empty pages: 102, full pages: 4306 
    Fill distribution: 
     0 - 19% = 105 
    20 - 39% = 9 
    40 - 59% = 7 
    60 - 79% = 13 
    80 - 99% = 4306 
 
PERF_SPLIT_5 (286) 
    Primary pointer page: 584, Index root page: 585 
    Total formats: 1, used formats: 1 
    Average record length: 146.06, total records: 184463 
    Average version length: 152.14, total versions: 6064, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.61 
    Pointer pages: 7, data page slots: 7200 
    Data pages: 4504, average fill: 85% 
    Primary pages: 4504, secondary pages: 0, swept pages: 7 
    Empty pages: 112, full pages: 4350 
    Fill distribution: 
     0 - 19% = 114 
    20 - 39% = 14 
    40 - 59% = 12 
    60 - 79% = 14 
    80 - 99% = 4350 
 
PERF_SPLIT_6 (287) 
    Primary pointer page: 586, Index root page: 587 
    Total formats: 1, used formats: 1 
    Average record length: 141.68, total records: 199733 
    Average version length: 153.65, total versions: 12380, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.97 
    Pointer pages: 8, data page slots: 6552 
    Data pages: 4872, average fill: 85% 
    Primary pages: 4870, secondary pages: 2, swept pages: 1 
    Empty pages: 115, full pages: 4720 
    Fill distribution: 
     0 - 19% = 117 
    20 - 39% = 13 
    40 - 59% = 14 
    60 - 79% = 9 
    80 - 99% = 4719 
 
PERF_SPLIT_7 (288) 
    Primary pointer page: 588, Index root page: 589 
    Total formats: 1, used formats: 1 
    Average record length: 146.13, total records: 187771 
    Average version length: 150.95, total versions: 6186, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.61 
    Pointer pages: 7, data page slots: 6704 
    Data pages: 4520, average fill: 86% 
    Primary pages: 4520, secondary pages: 0, swept pages: 4 
    Empty pages: 51, full pages: 4436 
    Fill distribution: 
     0 - 19% = 55 
    20 - 39% = 13 
    40 - 59% = 8 
    60 - 79% = 8 
    80 - 99% = 4436 
 
PERF_SPLIT_8 (289) 
    Primary pointer page: 590, Index root page: 591 
    Total formats: 1, used formats: 1 
    Average record length: 137.60, total records: 198924 
    Average version length: 153.92, total versions: 17886, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 12.33 
    Pointer pages: 7, data page slots: 6120 
    Data pages: 4856, average fill: 85% 
    Primary pages: 4856, secondary pages: 0, swept pages: 3 
    Empty pages: 100, full pages: 4701 
    Fill distribution: 
     0 - 19% = 104 
    20 - 39% = 22 
    40 - 59% = 21 
    60 - 79% = 10 
    80 - 99% = 4699 
 
PERF_SPLIT_9 (290) 
    Primary pointer page: 593, Index root page: 594 
    Total formats: 1, used formats: 1 
    Average record length: 141.78, total records: 196329 
    Average version length: 152.93, total versions: 12141, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.96 
    Pointer pages: 6, data page slots: 5352 
    Data pages: 4760, average fill: 85% 
    Primary pages: 4760, secondary pages: 0, swept pages: 1 
    Empty pages: 86, full pages: 4637 
    Fill distribution: 
     0 - 19% = 86 
    20 - 39% = 10 
    40 - 59% = 15 
    60 - 79% = 14 
    80 - 99% = 4635 
 
PHRASES (143) 
    Primary pointer page: 482, Index root page: 483 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index PHRASES_ID_DESC (3) 
    Root page: 1510354, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PHRASES_NAME (2) 
    Root page: 1510353, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PHRASES_UNQ (1) 
    Root page: 1510352, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PK_PHRASES (0) 
    Root page: 1510351, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
PSTORNED (147) 
    Primary pointer page: 490, Index root page: 491 
    Total formats: 1, used formats: 1 
    Average record length: 51.43, total records: 2119933 
    Average version length: 52.91, total versions: 52871, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 70.00, compression ratio: 1.36 
    Pointer pages: 16, data page slots: 25416 
    Data pages: 25416, average fill: 72% 
    Primary pages: 25416, secondary pages: 0, swept pages: 9321 
    Empty pages: 208, full pages: 21650 
    Fill distribution: 
     0 - 19% = 407 
    20 - 39% = 389 
    40 - 59% = 833 
    60 - 79% = 23318 
    80 - 99% = 469 
 
    Index PSTORNED_RCV_ID (1) 
    Root page: 1506186, depth: 3, leaf buckets: 2589, nodes: 2119933 
    Average node length: 5.44, total dup: 1978210, max dup: 1406 
    Average key length: 2.49, compression ratio: 3.62 
    Average prefix length: 8.58, average data length: 0.42 
    Clustering factor: 183362, ratio: 0.09 
    Fill distribution: 
         0 - 19% = 8 
        20 - 39% = 263 
        40 - 59% = 1713 
        60 - 79% = 303 
        80 - 99% = 302 
 
    Index PSTORNED_SND_ID (0) 
    Root page: 1504819, depth: 3, leaf buckets: 2762, nodes: 2119933 
    Average node length: 5.69, total dup: 1903436, max dup: 65 
    Average key length: 2.74, compression ratio: 3.29 
    Average prefix length: 8.37, average data length: 0.63 
    Clustering factor: 378826, ratio: 0.18 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 7 
        40 - 59% = 2405 
        60 - 79% = 320 
        80 - 99% = 29 
 
    Index PSTORNED_WORKER_ID (2) 
    Root page: 1507996, depth: 3, leaf buckets: 2126, nodes: 2119933 
    Average node length: 4.96, total dup: 2119833, max dup: 28379 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.42, average data length: 0.00 
    Clustering factor: 180993, ratio: 0.09 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 150 
        40 - 59% = 1159 
        60 - 79% = 388 
        80 - 99% = 428 
 
RULES_FOR_PDISTR (148) 
    Primary pointer page: 492, Index root page: 493 
    Total formats: 1, used formats: 1 
    Average record length: 17.00, total records: 4 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 334.00, compression ratio: 19.65 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 2% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index RULES_FOR_PDISTR_UNQ (0) 
    Root page: 1504317, depth: 1, leaf buckets: 1, nodes: 4 
    Average node length: 11.50, total dup: 0, max dup: 0 
    Average key length: 10.25, compression ratio: 0.88 
    Average prefix length: 1.50, average data length: 7.50 
    Clustering factor: 1, ratio: 0.25 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
RULES_FOR_QDISTR (137) 
    Primary pointer page: 470, Index root page: 471 
    Total formats: 1, used formats: 1 
    Average record length: 32.71, total records: 7 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 332.00, compression ratio: 10.15 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 4% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index RULES_FOR_QDISTR_RCVOP (1) 
    Root page: 1544803, depth: 1, leaf buckets: 1, nodes: 7 
    Average node length: 5.29, total dup: 2, max dup: 2 
    Average key length: 4.14, compression ratio: 0.72 
    Average prefix length: 1.43, average data length: 1.57 
    Clustering factor: 1, ratio: 0.14 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index RULES_FOR_QDISTR_UNQ (0) 
    Root page: 1544802, depth: 1, leaf buckets: 1, nodes: 7 
    Average node length: 10.14, total dup: 0, max dup: 0 
    Average key length: 8.86, compression ratio: 0.94 
    Average prefix length: 2.14, average data length: 6.14 
    Clustering factor: 1, ratio: 0.14 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
SEMAPHORES (152) 
    Primary pointer page: 500, Index root page: 501 
    Total formats: 1, used formats: 1 
    Average record length: 43.40, total records: 5 
    Average version length: 9.00, total versions: 1, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 346.00, compression ratio: 7.97 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 4% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index PK_SEMAPHORES (0) 
    Root page: 1504305, depth: 1, leaf buckets: 1, nodes: 5 
    Average node length: 12.40, total dup: 0, max dup: 0 
    Average key length: 11.00, compression ratio: 0.82 
    Average prefix length: 0.60, average data length: 8.40 
    Clustering factor: 1, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index SEMAPHORES_TASK_UNQ (1) 
    Root page: 1504306, depth: 1, leaf buckets: 1, nodes: 5 
    Average node length: 23.40, total dup: 0, max dup: 0 
    Average key length: 22.00, compression ratio: 1.07 
    Average prefix length: 4.20, average data length: 19.40 
    Clustering factor: 1, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
SETTINGS (135) 
    Primary pointer page: 466, Index root page: 467 
    Total formats: 1, used formats: 1 
    Average record length: 97.63, total records: 149 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1347.00, compression ratio: 13.80 
    Pointer pages: 1, data page slots: 3 
    Data pages: 3, average fill: 70% 
    Primary pages: 3, secondary pages: 0, swept pages: 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: 525, depth: 1, leaf buckets: 1, nodes: 149 
    Average node length: 14.66, total dup: 0, max dup: 0 
    Average key length: 13.55, compression ratio: 2.19 
    Average prefix length: 19.07, average data length: 10.66 
    Clustering factor: 48, ratio: 0.32 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 1 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index SETTINGS_MODE_CODE (0) 
    Root page: 1544806, depth: 1, leaf buckets: 1, nodes: 149 
    Average node length: 25.56, total dup: 0, max dup: 0 
    Average key length: 24.56, compression ratio: 1.63 
    Average prefix length: 18.58, average data length: 21.56 
    Clustering factor: 14, ratio: 0.09 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 0 
        40 - 59% = 1 
        60 - 79% = 0 
        80 - 99% = 0 
 
TMP$DEP_DOCS (129) 
    Primary pointer page: 454, Index root page: 455 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index TMP_DEP_DOCS_UNQ (0) 
    Root page: 1544810, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
TMP$IDX_RECALC (132) 
    Primary pointer page: 460, Index root page: 461 
    Total formats: 2, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index TMP_IDX_RECALC_IDX_NAME_UNQ (0) 
    Root page: 1544807, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
TMP$MON_LOG (133) 
    Primary pointer page: 462, Index root page: 463 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
TMP$MON_LOG_TABLE_STATS (134) 
    Primary pointer page: 464, Index root page: 465 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
TMP$PERF_EST_WHOLE (161) 
    Primary pointer page: 518, Index root page: 519 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
TMP$PERF_LOG (160) 
    Primary pointer page: 516, Index root page: 517 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index TMP$PERF_LOG_UNIT_TRN_DTS_END (0) 
    Root page: 1504230, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
TMP$PERF_MON (131) 
    Primary pointer page: 458, Index root page: 459 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
TMP$RESULT_SET (130) 
    Primary pointer page: 456, Index root page: 457 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index TMP_RESULT_SET_DOC (1) 
    Root page: 1544809, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index TMP_RESULT_SET_WARE_DOC (0) 
    Root page: 1544808, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
TMP$SHOPPING_CART (128) 
    Primary pointer page: 452, Index root page: 453 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index TMP_SHOPCART_UNQ (0) 
    Root page: 1544811, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
TPAUSE (166) 
    Primary pointer page: 528, Index root page: 529 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index RDB$PRIMARY2 (0) 
    Root page: 1504214, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
TRACE_STAT (157) 
    Primary pointer page: 510, Index root page: 511 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
WARES (142) 
    Primary pointer page: 480, Index root page: 481 
    Total formats: 1, used formats: 1 
    Average record length: 77.52, total records: 400 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 444.00, compression ratio: 5.73 
    Pointer pages: 1, data page slots: 6 
    Data pages: 6, average fill: 77% 
    Primary pages: 6, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 5 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 5 
    80 - 99% = 1 
 
    Index FK_WARES_WARE_GROUPS (3) 
    Root page: 1552159, depth: 1, leaf buckets: 1, nodes: 400 
    Average node length: 3.17, total dup: 392, max dup: 60 
    Average key length: 2.16, compression ratio: 4.16 
    Average prefix length: 8.86, average data length: 0.14 
    Clustering factor: 48, ratio: 0.12 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PK_WARES (0) 
    Root page: 1510355, depth: 1, leaf buckets: 1, nodes: 400 
    Average node length: 11.22, total dup: 0, max dup: 0 
    Average key length: 10.22, compression ratio: 0.88 
    Average prefix length: 1.78, average data length: 7.22 
    Clustering factor: 344, ratio: 0.86 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 0 
        40 - 59% = 1 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index WARES_ID_DESC (2) 
    Root page: 1510360, depth: 1, leaf buckets: 1, nodes: 400 
    Average node length: 11.22, total dup: 0, max dup: 0 
    Average key length: 10.22, compression ratio: 0.88 
    Average prefix length: 1.78, average data length: 7.22 
    Clustering factor: 344, ratio: 0.86 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 0 
        40 - 59% = 1 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index WARES_NUMB_UNQ (1) 
    Root page: 1510358, depth: 2, leaf buckets: 3, nodes: 400 
    Average node length: 53.25, total dup: 0, max dup: 0 
    Average key length: 52.23, compression ratio: 1.00 
    Average prefix length: 2.74, average data length: 49.25 
    Clustering factor: 355, ratio: 0.89 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 1 
        80 - 99% = 2 
 
WARE_GROUPS (151) 
    Primary pointer page: 498, Index root page: 499 
    Total formats: 1, used formats: 1 
    Average record length: 32.12, total records: 8 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 346.00, compression ratio: 10.77 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 5% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index PK_WARE_GROUPS (0) 
    Root page: 1504307, depth: 1, leaf buckets: 1, nodes: 8 
    Average node length: 11.25, total dup: 0, max dup: 0 
    Average key length: 10.12, compression ratio: 0.89 
    Average prefix length: 1.75, average data length: 7.25 
    Clustering factor: 1, ratio: 0.12 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index WARE_GROUPS_NAME_UNQ (1) 
    Root page: 1504308, depth: 1, leaf buckets: 1, nodes: 8 
    Average node length: 19.88, total dup: 0, max dup: 0 
    Average key length: 18.12, compression ratio: 0.89 
    Average prefix length: 0.25, average data length: 15.88 
    Clustering factor: 1, ratio: 0.12 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
XQD_1000_1200 (176) 
    Primary pointer page: 549, Index root page: 550 
    Total formats: 1, used formats: 1 
    Average record length: 37.07, total records: 177390 
    Average version length: 69.18, total versions: 82422, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 3.40 
    Pointer pages: 3, data page slots: 3896 
    Data pages: 3248, average fill: 63% 
    Primary pages: 3248, secondary pages: 0, swept pages: 397 
    Empty pages: 525, full pages: 2227 
    Fill distribution: 
     0 - 19% = 650 
    20 - 39% = 24 
    40 - 59% = 95 
    60 - 79% = 1023 
    80 - 99% = 1456 
 
    Index XQD_1000_1200_WA_SO_RO_WKR_SND (0) 
    Root page: 102240, depth: 3, leaf buckets: 244, nodes: 177390 
    Average node length: 6.47, total dup: 154484, max dup: 29 
    Average key length: 3.89, compression ratio: 10.80 
    Average prefix length: 40.24, average data length: 1.76 
    Clustering factor: 30085, ratio: 0.17 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 22 
        40 - 59% = 112 
        60 - 79% = 71 
        80 - 99% = 37 
 
XQD_1000_3300 (178) 
    Primary pointer page: 553, Index root page: 554 
    Total formats: 1, used formats: 1 
    Average record length: 64.15, total records: 7057621 
    Average version length: 68.77, total versions: 492084, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.96 
    Pointer pages: 62, data page slots: 100608 
    Data pages: 100608, average fill: 75% 
    Primary pages: 100608, secondary pages: 0, swept pages: 18606 
    Empty pages: 186, full pages: 87194 
    Fill distribution: 
     0 - 19% = 768 
    20 - 39% = 1305 
    40 - 59% = 3391 
    60 - 79% = 84919 
    80 - 99% = 10225 
 
    Index XQD_1000_3300_WA_SO_RO_WKR_SND (0) 
    Root page: 1480454, depth: 3, leaf buckets: 10706, nodes: 7057621 
    Average node length: 6.51, total dup: 6105996, max dup: 29 
    Average key length: 3.52, compression ratio: 11.93 
    Average prefix length: 40.61, average data length: 1.39 
    Clustering factor: 1575026, ratio: 0.22 
    Fill distribution: 
         0 - 19% = 3 
        20 - 39% = 1662 
        40 - 59% = 5932 
        60 - 79% = 2612 
        80 - 99% = 497 
 
    Index XQD_1000_3300_WKR_DOC_ASC (1) 
    Root page: 1486068, depth: 3, leaf buckets: 8458, nodes: 7057621 
    Average node length: 5.39, total dup: 6777526, max dup: 168 
    Average key length: 2.41, compression ratio: 7.07 
    Average prefix length: 16.63, average data length: 0.37 
    Clustering factor: 1372892, ratio: 0.19 
    Fill distribution: 
         0 - 19% = 7 
        20 - 39% = 1168 
        40 - 59% = 4656 
        60 - 79% = 1592 
        80 - 99% = 1035 
 
    Index XQD_1000_3300_WKR_DOC_DEC (2) 
    Root page: 1490608, depth: 3, leaf buckets: 8529, nodes: 7057621 
    Average node length: 5.40, total dup: 6777526, max dup: 168 
    Average key length: 2.41, compression ratio: 7.07 
    Average prefix length: 16.63, average data length: 0.37 
    Clustering factor: 1375458, ratio: 0.19 
    Fill distribution: 
         0 - 19% = 9 
        20 - 39% = 1248 
        40 - 59% = 4651 
        60 - 79% = 1587 
        80 - 99% = 1034 
 
XQD_1200_2000 (177) 
    Primary pointer page: 551, Index root page: 552 
    Total formats: 1, used formats: 1 
    Average record length: 66.72, total records: 11986258 
    Average version length: 68.76, total versions: 388051, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.89 
    Pointer pages: 102, data page slots: 166256 
    Data pages: 166256, average fill: 77% 
    Primary pages: 166256, secondary pages: 0, swept pages: 68692 
    Empty pages: 1, full pages: 156416 
    Fill distribution: 
     0 - 19% = 34 
    20 - 39% = 377 
    40 - 59% = 2770 
    60 - 79% = 155284 
    80 - 99% = 7791 
 
    Index XQD_1200_2000_WA_SO_RO_WKR_SND (0) 
    Root page: 1495028, depth: 3, leaf buckets: 18476, nodes: 11986258 
    Average node length: 6.57, total dup: 10450393, max dup: 57 
    Average key length: 3.43, compression ratio: 12.26 
    Average prefix length: 40.70, average data length: 1.30 
    Clustering factor: 2367024, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 17 
        20 - 39% = 2393 
        40 - 59% = 11176 
        60 - 79% = 4274 
        80 - 99% = 616 
 
XQD_2000_3300 (179) 
    Primary pointer page: 555, Index root page: 556 
    Total formats: 1, used formats: 1 
    Average record length: 37.49, total records: 1778730 
    Average version length: 69.12, total versions: 814580, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 3.36 
    Pointer pages: 25, data page slots: 39368 
    Data pages: 28912, average fill: 71% 
    Primary pages: 28912, secondary pages: 0, swept pages: 4845 
    Empty pages: 2062, full pages: 22403 
    Fill distribution: 
     0 - 19% = 3228 
    20 - 39% = 1338 
    40 - 59% = 1059 
    60 - 79% = 9742 
    80 - 99% = 13545 
 
    Index XQD_2000_3300_WA_SO_RO_WKR_SND (0) 
    Root page: 1479712, depth: 3, leaf buckets: 2243, nodes: 1778730 
    Average node length: 5.51, total dup: 1706504, max dup: 99 
    Average key length: 2.55, compression ratio: 16.44 
    Average prefix length: 41.49, average data length: 0.51 
    Clustering factor: 120909, ratio: 0.07 
    Fill distribution: 
         0 - 19% = 12 
        20 - 39% = 406 
        40 - 59% = 1046 
        60 - 79% = 591 
        80 - 99% = 188 
 
XQD_2100_3300 (180) 
    Primary pointer page: 557, Index root page: 558 
    Total formats: 1, used formats: 1 
    Average record length: 37.58, total records: 1235267 
    Average version length: 69.14, total versions: 562572, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 3.35 
    Pointer pages: 21, data page slots: 33376 
    Data pages: 27544, average fill: 52% 
    Primary pages: 27544, secondary pages: 0, swept pages: 6460 
    Empty pages: 6210, full pages: 15031 
    Fill distribution: 
     0 - 19% = 9011 
    20 - 39% = 1171 
    40 - 59% = 908 
    60 - 79% = 6648 
    80 - 99% = 9806 
 
    Index XQD_2100_3300_WA_SO_RO_WKR_SND (0) 
    Root page: 1479207, depth: 3, leaf buckets: 1608, nodes: 1235267 
    Average node length: 5.76, total dup: 1156397, max dup: 116 
    Average key length: 2.82, compression ratio: 14.89 
    Average prefix length: 41.24, average data length: 0.76 
    Clustering factor: 164841, ratio: 0.13 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 245 
        40 - 59% = 786 
        60 - 79% = 460 
        80 - 99% = 115 
 
XQD_3300_3400 (181) 
    Primary pointer page: 559, Index root page: 560 
    Total formats: 1, used formats: 1 
    Average record length: 64.60, total records: 9482810 
    Average version length: 68.96, total versions: 590954, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.95 
    Pointer pages: 88, data page slots: 142192 
    Data pages: 142176, average fill: 71% 
    Primary pages: 142176, secondary pages: 0, swept pages: 41574 
    Empty pages: 221, full pages: 96064 
    Fill distribution: 
     0 - 19% = 813 
    20 - 39% = 4303 
    40 - 59% = 16045 
    60 - 79% = 110267 
    80 - 99% = 10748 
 
    Index XQD_3300_3400_WA_SO_RO_WKR_SND (0) 
    Root page: 1472590, depth: 3, leaf buckets: 13485, nodes: 9482810 
    Average node length: 6.67, total dup: 7866537, max dup: 27 
    Average key length: 3.66, compression ratio: 11.46 
    Average prefix length: 40.51, average data length: 1.49 
    Clustering factor: 2036339, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 3 
        20 - 39% = 883 
        40 - 59% = 6638 
        60 - 79% = 5228 
        80 - 99% = 733 
 
XQS_1000_1200 (182) 
    Primary pointer page: 561, Index root page: 562 
    Total formats: 1, used formats: 1 
    Average record length: 82.47, total records: 21135862 
    Average version length: 82.96, total versions: 16483, 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: 318520 
    Data pages: 318520, average fill: 81% 
    Primary pages: 318520, secondary pages: 0, swept pages: 12486 
    Empty pages: 16, full pages: 317845 
    Fill distribution: 
     0 - 19% = 25 
    20 - 39% = 33 
    40 - 59% = 57 
    60 - 79% = 27494 
    80 - 99% = 290911 
 
    Index XQS_1000_1200_DOC_ID (1) 
    Root page: 1426716, depth: 3, leaf buckets: 19294, nodes: 21135862 
    Average node length: 5.72, total dup: 20654931, max dup: 132 
    Average key length: 2.16, compression ratio: 4.16 
    Average prefix length: 8.86, average data length: 0.14 
    Clustering factor: 3279045, ratio: 0.16 
    Fill distribution: 
         0 - 19% = 8 
        20 - 39% = 2 
        40 - 59% = 7978 
        60 - 79% = 571 
        80 - 99% = 10735 
 
    Index XQS_1000_1200_RCV_ID (3) 
    Root page: 1456980, depth: 3, leaf buckets: 17150, nodes: 21135862 
    Average node length: 6.31, total dup: 18574148, max dup: 49 
    Average key length: 2.75, compression ratio: 3.27 
    Average prefix length: 8.37, average data length: 0.63 
    Clustering factor: 914120, ratio: 0.04 
    Fill distribution: 
         0 - 19% = 3 
        20 - 39% = 2 
        40 - 59% = 781 
        60 - 79% = 258 
        80 - 99% = 16106 
 
    Index XQS_1000_1200_SND_ID (2) 
    Root page: 1441073, depth: 3, leaf buckets: 21057, nodes: 21135862 
    Average node length: 6.35, total dup: 18493023, max dup: 29 
    Average key length: 2.79, compression ratio: 3.23 
    Average prefix length: 8.34, average data length: 0.66 
    Clustering factor: 3573313, ratio: 0.17 
    Fill distribution: 
         0 - 19% = 4 
        20 - 39% = 2 
        40 - 59% = 8249 
        60 - 79% = 569 
        80 - 99% = 12233 
 
    Index XQS_1000_1200_WORKER_ID (0) 
    Root page: 1413348, depth: 3, leaf buckets: 16041, nodes: 21135862 
    Average node length: 5.56, total dup: 21135762, max dup: 227333 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.42, average data length: 0.00 
    Clustering factor: 942958, ratio: 0.04 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 6 
        40 - 59% = 2798 
        60 - 79% = 389 
        80 - 99% = 12847 
 
XQS_1000_3300 (184) 
    Primary pointer page: 565, Index root page: 566 
    Total formats: 1, used formats: 1 
    Average record length: 77.97, total records: 9880013 
    Average version length: 82.61, total versions: 533649, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.62 
    Pointer pages: 102, data page slots: 166312 
    Data pages: 166296, average fill: 73% 
    Primary pages: 166296, secondary pages: 0, swept pages: 59765 
    Empty pages: 341, full pages: 115171 
    Fill distribution: 
     0 - 19% = 1079 
    20 - 39% = 4349 
    40 - 59% = 17084 
    60 - 79% = 70859 
    80 - 99% = 72925 
 
    Index XQS_1000_3300_DOC_ID (1) 
    Root page: 1367502, depth: 3, leaf buckets: 11365, nodes: 9880013 
    Average node length: 5.34, total dup: 9569777, max dup: 178 
    Average key length: 2.23, compression ratio: 4.04 
    Average prefix length: 8.80, average data length: 0.20 
    Clustering factor: 2173416, ratio: 0.22 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 48 
        40 - 59% = 7865 
        60 - 79% = 3306 
        80 - 99% = 145 
 
    Index XQS_1000_3300_RCV_ID (3) 
    Root page: 1379261, depth: 3, leaf buckets: 13591, nodes: 9880013 
    Average node length: 6.21, total dup: 8190708, max dup: 14 
    Average key length: 3.10, compression ratio: 2.90 
    Average prefix length: 8.07, average data length: 0.93 
    Clustering factor: 1510600, ratio: 0.15 
    Fill distribution: 
         0 - 19% = 178 
        20 - 39% = 3730 
        40 - 59% = 4432 
        60 - 79% = 2631 
        80 - 99% = 2620 
 
    Index XQS_1000_3300_SND_ID (2) 
    Root page: 1373059, depth: 3, leaf buckets: 12692, nodes: 9880013 
    Average node length: 5.96, total dup: 8578992, max dup: 41 
    Average key length: 2.84, compression ratio: 3.16 
    Average prefix length: 8.29, average data length: 0.71 
    Clustering factor: 2370594, ratio: 0.24 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 43 
        40 - 59% = 8821 
        60 - 79% = 3662 
        80 - 99% = 164 
 
    Index XQS_1000_3300_WORKER_ID (0) 
    Root page: 1362767, depth: 3, leaf buckets: 10161, nodes: 9880013 
    Average node length: 5.12, total dup: 9879913, max dup: 154092 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.43, average data length: 0.00 
    Clustering factor: 1533188, ratio: 0.16 
    Fill distribution: 
         0 - 19% = 30 
        20 - 39% = 1160 
        40 - 59% = 4990 
        60 - 79% = 1811 
        80 - 99% = 2170 
 
XQS_1200_2000 (183) 
    Primary pointer page: 563, Index root page: 564 
    Total formats: 1, used formats: 1 
    Average record length: 79.35, total records: 11513480 
    Average version length: 82.54, total versions: 414201, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.59 
    Pointer pages: 117, data page slots: 190112 
    Data pages: 188712, average fill: 75% 
    Primary pages: 188712, secondary pages: 0, swept pages: 62114 
    Empty pages: 1818, full pages: 150092 
    Fill distribution: 
     0 - 19% = 3191 
    20 - 39% = 5428 
    40 - 59% = 13991 
    60 - 79% = 42053 
    80 - 99% = 124049 
 
    Index XQS_1200_2000_DOC_ID (1) 
    Root page: 1392101, depth: 3, leaf buckets: 13134, nodes: 11513480 
    Average node length: 5.30, total dup: 11403618, max dup: 642 
    Average key length: 2.08, compression ratio: 4.33 
    Average prefix length: 8.93, average data length: 0.07 
    Clustering factor: 2396123, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 69 
        40 - 59% = 8790 
        60 - 79% = 4057 
        80 - 99% = 216 
 
    Index XQS_1200_2000_RCV_ID (3) 
    Root page: 1406110, depth: 3, leaf buckets: 10513, nodes: 11513480 
    Average node length: 5.50, total dup: 11011025, max dup: 49 
    Average key length: 2.28, compression ratio: 3.95 
    Average prefix length: 8.77, average data length: 0.23 
    Clustering factor: 718529, ratio: 0.06 
    Fill distribution: 
         0 - 19% = 124 
        20 - 39% = 824 
        40 - 59% = 2544 
        60 - 79% = 1782 
        80 - 99% = 5239 
 
    Index XQS_1200_2000_SND_ID (2) 
    Root page: 1398638, depth: 3, leaf buckets: 15018, nodes: 11513480 
    Average node length: 6.02, total dup: 10054568, max dup: 79 
    Average key length: 2.80, compression ratio: 3.21 
    Average prefix length: 8.33, average data length: 0.67 
    Clustering factor: 2412691, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 85 
        40 - 59% = 10239 
        60 - 79% = 4455 
        80 - 99% = 238 
 
    Index XQS_1200_2000_WORKER_ID (0) 
    Root page: 1386211, depth: 3, leaf buckets: 10849, nodes: 11513480 
    Average node length: 5.23, total dup: 11513380, max dup: 187783 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.43, average data length: 0.00 
    Clustering factor: 706602, ratio: 0.06 
    Fill distribution: 
         0 - 19% = 88 
        20 - 39% = 795 
        40 - 59% = 4787 
        60 - 79% = 1451 
        80 - 99% = 3728 
 
XQS_2000_3300 (185) 
    Primary pointer page: 567, Index root page: 568 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index XQS_2000_3300_DOC_ID (1) 
    Root page: 1361753, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index XQS_2000_3300_RCV_ID (3) 
    Root page: 1361755, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index XQS_2000_3300_SND_ID (2) 
    Root page: 1361754, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index XQS_2000_3300_WORKER_ID (0) 
    Root page: 1361752, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
XQS_2100_3300 (186) 
    Primary pointer page: 569, Index root page: 570 
    Total formats: 1, used formats: 1 
    Average record length: 78.41, total records: 9985419 
    Average version length: 82.90, total versions: 522985, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.61 
    Pointer pages: 104, data page slots: 169272 
    Data pages: 169224, average fill: 73% 
    Primary pages: 169224, secondary pages: 0, swept pages: 61332 
    Empty pages: 388, full pages: 117122 
    Fill distribution: 
     0 - 19% = 1232 
    20 - 39% = 5014 
    40 - 59% = 18410 
    60 - 79% = 70458 
    80 - 99% = 74110 
 
    Index XQS_2100_3300_DOC_ID (1) 
    Root page: 1344686, depth: 3, leaf buckets: 11979, nodes: 9985419 
    Average node length: 5.16, total dup: 9955843, max dup: 1553 
    Average key length: 2.03, compression ratio: 4.43 
    Average prefix length: 8.97, average data length: 0.03 
    Clustering factor: 1987833, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 29 
        20 - 39% = 1420 
        40 - 59% = 8097 
        60 - 79% = 1814 
        80 - 99% = 619 
 
    Index XQS_2100_3300_RCV_ID (3) 
    Root page: 1355717, depth: 3, leaf buckets: 13653, nodes: 9985419 
    Average node length: 6.22, total dup: 8277764, max dup: 14 
    Average key length: 3.10, compression ratio: 2.90 
    Average prefix length: 8.07, average data length: 0.93 
    Clustering factor: 1487725, ratio: 0.15 
    Fill distribution: 
         0 - 19% = 190 
        20 - 39% = 3742 
        40 - 59% = 4362 
        60 - 79% = 2576 
        80 - 99% = 2783 
 
    Index XQS_2100_3300_SND_ID (2) 
    Root page: 1350049, depth: 3, leaf buckets: 12608, nodes: 9985419 
    Average node length: 5.41, total dup: 9539344, max dup: 99 
    Average key length: 2.29, compression ratio: 3.94 
    Average prefix length: 8.76, average data length: 0.24 
    Clustering factor: 2124185, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 24 
        20 - 39% = 1368 
        40 - 59% = 8950 
        60 - 79% = 1694 
        80 - 99% = 572 
 
    Index XQS_2100_3300_WORKER_ID (0) 
    Root page: 985805, depth: 3, leaf buckets: 10240, nodes: 9985419 
    Average node length: 5.13, total dup: 9985319, max dup: 157022 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.43, average data length: 0.00 
    Clustering factor: 1564972, ratio: 0.16 
    Fill distribution: 
         0 - 19% = 46 
        20 - 39% = 1115 
        40 - 59% = 5047 
        60 - 79% = 1763 
        80 - 99% = 2269 
 
XQS_3300_3400 (187) 
    Primary pointer page: 571, Index root page: 572 
    Total formats: 1, used formats: 1 
    Average record length: 67.13, total records: 579430 
    Average version length: 68.81, total versions: 8852, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.88 
    Pointer pages: 5, data page slots: 7936 
    Data pages: 7936, average fill: 76% 
    Primary pages: 7936, secondary pages: 0, swept pages: 3374 
    Empty pages: 6, full pages: 7269 
    Fill distribution: 
     0 - 19% = 6 
    20 - 39% = 4 
    40 - 59% = 66 
    60 - 79% = 7690 
    80 - 99% = 170 
 
    Index XQS_3300_3400_DOC_ID (1) 
    Root page: 44635, depth: 3, leaf buckets: 731, nodes: 579430 
    Average node length: 5.95, total dup: 493243, max dup: 82 
    Average key length: 3.09, compression ratio: 2.91 
    Average prefix length: 8.06, average data length: 0.94 
    Clustering factor: 101142, ratio: 0.17 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 20 
        40 - 59% = 515 
        60 - 79% = 99 
        80 - 99% = 97 
 
    Index XQS_3300_3400_SND_ID (2) 
    Root page: 38112, depth: 3, leaf buckets: 753, nodes: 579430 
    Average node length: 6.15, total dup: 475135, max dup: 27 
    Average key length: 3.29, compression ratio: 2.73 
    Average prefix length: 7.89, average data length: 1.11 
    Clustering factor: 101210, ratio: 0.17 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 21 
        40 - 59% = 533 
        60 - 79% = 90 
        80 - 99% = 109 
 
    Index XQS_3300_3400_WORKER_ID (0) 
    Root page: 375548, depth: 2, leaf buckets: 566, nodes: 579430 
    Average node length: 4.86, total dup: 579330, max dup: 9580 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.42, average data length: 0.00 
    Clustering factor: 89612, ratio: 0.15 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 33 
        40 - 59% = 317 
        60 - 79% = 87 
        80 - 99% = 128 
 
ZDOC_DATA (170) 
    Primary pointer page: 537, Index root page: 538 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
ZDOC_LIST (169) 
    Primary pointer page: 535, Index root page: 536 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
ZINVNT_TURNOVER_LOG (171) 
    Primary pointer page: 539, Index root page: 540 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
ZPDISTR (174) 
    Primary pointer page: 545, Index root page: 546 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index ZPDISTR_ID (0) 
    Root page: 1504207, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
ZPSTORNED (175) 
    Primary pointer page: 547, Index root page: 548 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index ZPSTORNED_ID (0) 
    Root page: 1504206, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
ZQDISTR (172) 
    Primary pointer page: 541, Index root page: 542 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index ZQDISTR_ID (0) 
    Root page: 1504212, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index ZQDISTR_WARE_SNDOP_RCVOP (1) 
    Root page: 1504213, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
ZQSTORNED (173) 
    Primary pointer page: 543, Index root page: 544 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index ZQSTORNED_DOC_ID (1) 
    Root page: 1504209, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index ZQSTORNED_ID (0) 
    Root page: 1504208, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index ZQSTORNED_RCV_ID (3) 
    Root page: 1504211, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index ZQSTORNED_SND_ID (2) 
    Root page: 1504210, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
ZTMP_DEP_DOCS (168) 
    Primary pointer page: 533, Index root page: 534 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
ZTMP_SHOPPING_CART (167) 
    Primary pointer page: 531, Index root page: 532 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
Z_USED_VIEWS (144) 
    Primary pointer page: 484, Index root page: 485 
    Total formats: 1, used formats: 1 
    Average record length: 29.38, total records: 29 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 99.00, compression ratio: 3.37 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 16% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index Z_USED_VIEWS_UNQ (0) 
    Root page: 1510350, depth: 1, leaf buckets: 1, nodes: 29 
    Average node length: 15.17, total dup: 0, max dup: 0 
    Average key length: 14.14, compression ratio: 1.44 
    Average prefix length: 9.17, average data length: 11.17 
    Clustering factor: 1, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
Gstat completion time Fri Apr  5 16:11:37 2024

Record versions statistics, table

TABLE_NAME TOTAL_RECS TOTAL_VERS MAX_VERSIONS VERS_TO_RECS_PRC MAXV_TO_VERS_PRC
DOC_DATA 7813987 117852 1 0.0000 0.0000
DOC_LIST 2282004 119773 4 0.0000 0.0000
FB_ERRORS 2182 757 1 0.0000 0.0000
INVNT_SALDO 400 229790 594 57400.0000 0.0000
INVNT_TURNOVER_LOG 66260 63279 1 0.0000 0.0000
MONEY_SALDO 49 18526 1027 37800.0000 0.0000
MONEY_TURNOVER_LOG 836 778 1 0.0000 0.0000
PDISTR 811267 80509 4 0.0000 0.0000
PERF_SPLIT_0 176207 5513 1 0.0000 0.0000
PERF_SPLIT_1 169725 5752 1 0.0000 0.0000
PERF_SPLIT_2 159259 4465 1 0.0000 0.0000
PERF_SPLIT_3 177912 8445 1 0.0000 0.0000
PERF_SPLIT_4 182082 25684 1 0.0000 0.0000
PERF_SPLIT_5 184463 6064 1 0.0000 0.0000
PERF_SPLIT_6 199733 12380 1 0.0000 0.0000
PERF_SPLIT_7 187771 6186 1 0.0000 0.0000
PERF_SPLIT_8 198924 17886 1 0.0000 0.0000
PERF_SPLIT_9 196329 12141 1 0.0000 0.0000
PSTORNED 2119933 52871 1 0.0000 0.0000
SEMAPHORES 5 1 1 0.0000 100.0000
XQD_1000_1200 177390 82422 1 0.0000 0.0000
XQD_1000_3300 7057621 492084 1 0.0000 0.0000
XQD_1200_2000 11986258 388051 1 0.0000 0.0000
XQD_2000_3300 1778730 814580 1 0.0000 0.0000
XQD_2100_3300 1235267 562572 1 0.0000 0.0000
XQD_3300_3400 9482810 590954 1 0.0000 0.0000
XQS_1000_1200 21135862 16483 1 0.0000 0.0000
XQS_1000_3300 9880013 533649 1 0.0000 0.0000
XQS_1200_2000 11513480 414201 1 0.0000 0.0000
XQS_2100_3300 9985419 522985 1 0.0000 0.0000
XQS_3300_3400 579430 8852 1 0.0000 0.0000

Record versions statistics, chart

Total records and versions, chart

Ratios versions / total_records and max_versions / total_versions

Database validation 


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

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

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

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

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