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

Hardware and OS info

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

Server and database settinfs 


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

Test configuration settings 

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

Test finish info 


FINISH_STATE                    NORMAL: TEST_TIME EXPIRED AT 2024-03-07 04:07:46
DTS_END                         2024-03-07 04:07:46.9460
FB_GDSCODE                      -1
FB_MNEMONA                      
STACK                           SP_ADD_INVOICE_TO_STOCK(190:30) ==> SP_CUSTOMER_RESERVE(47:5) ==> SP_CHECK_TO_STOP_WORK(32:12) ==> SP_HALT_ON_ERROR(68:17)
IP                              ::1/53368
TRN_ID                          164438
ATT_ID                          559
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: 9031.66 15959 903166
customer order: creation 171.92 430 17192
customer order: refuse 14.86 357 1486
order to supplier: creation 45.00 1353 4500
order to supplier: removal 3.50 84130 350
invoice (draft): creation 46.12 2990 4612
invoice (draft): removal 48.73 729 4873
invoice accept: apply 42.14 21341 4214
invoice accept: cancel 43.91 809 4391
customer reserve: creation 4054.03 205 405403
customer reserve: removal 4266.05 55 426605
realization accept: apply 82.38 214 8238
realization accept: cancel 84.11 154 8411
payment from customer: creation 59.61 121 5961
payment from customer: removal 5.81 87 581
payment to supplier: creation 48.96 141 4896
payment to supplier: removal 3.17 144 317
service: total inventory turnovers 3.91 3598 391
service: total monetary turnovers 6.46 403 646
service: aggregate perf. data 0.96 10464 96
service: refresh index statistics 0.03 191461 3

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:02, from 07-03-2024 04:08:36 to 07-03-2024 04:08:38.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 2810
TEST_TIME 2 2788
TEST_TIME 3 3960
TEST_TIME 4 3769
TEST_TIME 5 4027
TEST_TIME 6 4091
TEST_TIME 7 4042
TEST_TIME 8 4292
TEST_TIME 9 4560
TEST_TIME 10 4846
TEST_TIME 11 5367
TEST_TIME 12 5481
TEST_TIME 13 5660
TEST_TIME 14 6326
TEST_TIME 15 6601
TEST_TIME 16 6803
TEST_TIME 17 7507
TEST_TIME 18 8436
TEST_TIME 19 8808
TEST_TIME 20 9364
TEST_TIME 21 8988
TEST_TIME 22 8718
TEST_TIME 23 8818
TEST_TIME 24 8688
TEST_TIME 25 8633
TEST_TIME 26 8460
TEST_TIME 27 8290
TEST_TIME 28 8240
TEST_TIME 29 8176
TEST_TIME 30 8128
TEST_TIME 31 8052
TEST_TIME 32 8121
TEST_TIME 33 8218
TEST_TIME 34 8184
TEST_TIME 35 8425
TEST_TIME 36 8412
TEST_TIME 37 8762
TEST_TIME 38 8670
TEST_TIME 39 8869
TEST_TIME 40 9080
TEST_TIME 41 9033
TEST_TIME 42 8890
TEST_TIME 43 8720
TEST_TIME 44 8598
TEST_TIME 45 8584
TEST_TIME 46 8650
TEST_TIME 47 8707
TEST_TIME 48 8584
TEST_TIME 49 8466
TEST_TIME 50 8627
TEST_TIME 51 8592
TEST_TIME 52 8656
TEST_TIME 53 8716
TEST_TIME 54 8744
TEST_TIME 55 8745
TEST_TIME 56 8904
TEST_TIME 57 8982
TEST_TIME 58 8984
TEST_TIME 59 8908
TEST_TIME 60 9172
TEST_TIME 61 9124
TEST_TIME 62 9070
TEST_TIME 63 8966
TEST_TIME 64 8955
TEST_TIME 65 8992
TEST_TIME 66 8984
TEST_TIME 67 8919
TEST_TIME 68 8873
TEST_TIME 69 8857
TEST_TIME 70 8908
TEST_TIME 71 8883
TEST_TIME 72 8904
TEST_TIME 73 8944
TEST_TIME 74 8970
TEST_TIME 75 9012
TEST_TIME 76 9003
TEST_TIME 77 9041
TEST_TIME 78 9087
TEST_TIME 79 9148
TEST_TIME 80 9164
TEST_TIME 81 9165
TEST_TIME 82 9104
TEST_TIME 83 9045
TEST_TIME 84 9046
TEST_TIME 85 8969
TEST_TIME 86 8945
TEST_TIME 87 8927
TEST_TIME 88 8937
TEST_TIME 89 8904
TEST_TIME 90 8856
TEST_TIME 91 8812
TEST_TIME 92 8803
TEST_TIME 93 8861
TEST_TIME 94 8920
TEST_TIME 95 8936
TEST_TIME 96 8922
TEST_TIME 97 8921
TEST_TIME 98 8965
TEST_TIME 99 8906
TEST_TIME 100 9044

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:03, from 07-03-2024 04:08:39 to 07-03-2024 04:08:42.

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 1272511 1272511 0 0.00 0 26128 7 0 0
doc_list_biud 1272510 1272510 0 0.00 0 35184 24 0 0
sp_add_invoice_to_stock 4313 4214 99 2.29 29 190712 21342 0 99
sp_cancel_adding_invoice 4391 4391 0 0.00 2 59912 809 0 0
sp_cancel_client_order 1486 1486 0 0.00 4 7127 358 0 0
sp_cancel_customer_reserve 426605 426605 0 0.00 0 26848 55 0 0
sp_cancel_pay_from_customer 581 581 0 0.00 3 3639 88 0 0
sp_cancel_pay_to_supplier 317 317 0 0.00 2 8115 145 0 0
sp_cancel_supplier_invoice 4879 4873 6 0.12 1 35187 730 0 6
sp_cancel_supplier_order 350 350 0 0.00 7 967142 84131 0 0
sp_cancel_write_off 8411 8411 0 0.00 1 15887 155 0 0
sp_client_order 17192 17192 0 0.00 3 26221 430 0 0
sp_customer_reserve 405403 405403 0 0.00 0 71042 205 0 0
sp_fill_shopping_cart 26296 26296 0 0.00 1 13239 41 0 0
sp_fill_shopping_cart_clo_res 405383 405383 0 0.00 0 18545 20 0 0
sp_get_clo_for_invoice 4194 4194 0 0.00 0 24671 385 0 0
sp_kill_cost_storno 13700 13700 0 0.00 0 8569 70 0 0
sp_kill_qstorno_ret_qs2qd 866844 866844 0 0.00 0 35183 30 0 0
sp_kill_qty_storno 458547 458547 0 0.00 0 35183 66 0 0
sp_lock_selected_doc 17280 17280 0 0.00 0 8794 5 0 0
sp_make_cost_storno 23289 23289 0 0.00 0 13109 60 0 0
sp_multiply_rows_for_pdistr 23288 23288 0 0.00 0 11516 39 0 0
sp_multiply_rows_for_qdistr 17192 17192 0 0.00 0 19269 248 0 0
sp_pay_from_customer 5961 5961 0 0.00 3 18046 122 0 0
sp_pay_to_supplier 4896 4896 0 0.00 4 17878 142 0 0
sp_payment_common 10857 10857 0 0.00 1 10012 25 0 0
sp_qd_handle_on_cancel_clo 1486 1486 0 0.00 0 7070 329 0 0
sp_qd_handle_on_invoice_upd_sts 8584 8584 0 0.00 0 32517 283 0 0
sp_qd_handle_on_reserve_upd_sts 8238 8238 0 0.00 0 20075 72 0 0
sp_reserve_write_off 8238 8238 0 0.00 6 20142 215 0 0
sp_supplier_invoice 4612 4612 0 0.00 6 84596 2991 0 0
sp_supplier_order 4500 4500 0 0.00 4 34869 1354 0 0
srv_aggregate_perf_data 96 96 0 0.00 1661 90511 10464 0 0
srv_fill_mon_cache_memory 54 54 0 0.00 1359 146903 43302 0 0
srv_find_qd_qs_mism 859664 859664 0 0.00 0 26127 7 0 0
srv_make_invnt_saldo 391 391 0 0.00 67 114441 3598 0 0
srv_make_money_saldo 646 646 0 0.00 1 12214 403 0 0
srv_recalc_idx_stat 3 3 0 0.00 152720 214136 191462 0 0
t$perf-abend:sp_add_invoice_to_stock 99 99 0 0.00 0 0 0 0 0
t$perf-abend:sp_cancel_supplier_invoice 6 6 0 0.00 0 0 0 0 0
t$perf-norm:sp_add_invoice_to_stock 4214 4214 0 0.00 0 9955 144 0 0
t$perf-norm:sp_cancel_adding_invoice 370 370 0 0.00 0 1946 77 0 0
t$perf-norm:sp_cancel_client_order 1486 1486 0 0.00 0 2239 11 0 0
t$perf-norm:sp_cancel_customer_reserve 536 536 0 0.00 0 1678 17 0 0
t$perf-norm:sp_cancel_pay_from_customer 581 581 0 0.00 0 1180 4 0 0
t$perf-norm:sp_cancel_pay_to_supplier 317 317 0 0.00 0 59 1 0 0
t$perf-norm:sp_cancel_supplier_invoice 369 369 0 0.00 0 1577 14 0 0
t$perf-norm:sp_cancel_supplier_order 350 350 0 0.00 0 21829 1368 0 0
t$perf-norm:sp_cancel_write_off 840 840 0 0.00 0 2213 7 0 0
t$perf-norm:sp_client_order 17192 17192 0 0.00 0 7239 13 0 0
t$perf-norm:sp_customer_reserve 819 819 0 0.00 0 3302 6 0 0
t$perf-norm:sp_pay_from_customer 5961 5961 0 0.00 0 4553 8 0 0
t$perf-norm:sp_pay_to_supplier 4896 4896 0 0.00 0 5767 9 0 0
t$perf-norm:sp_reserve_write_off 8238 8238 0 0.00 0 3300 6 0 0
t$perf-norm:sp_supplier_invoice 4612 4612 0 0.00 0 2568 13 0 0
t$perf-norm:sp_supplier_order 4500 4500 0 0.00 0 2873 12 0 0
t$perf-norm:srv_aggregate_perf_data 96 96 0 0.00 0 210 7 0 0
t$perf-norm:srv_fill_mon_cache_memory 54 54 0 0.00 0 113 3 0 0
t$perf-norm:srv_make_invnt_saldo 391 391 0 0.00 0 1806 11 0 0
t$perf-norm:srv_make_money_saldo 646 646 0 0.00 0 955 9 0 0
t$perf-norm:srv_recalc_idx_stat 3 3 0 0.00 1 4 3 0 0
v_add_invoice_to_stock 8584 8386 198 2.30 0 4608 14 0 198
v_all_customers 32016 32016 0 0.00 0 28 1 0 0
v_all_suppliers 25894 25894 0 0.00 0 24 1 0 0
v_all_wares 34384 34384 0 0.00 0 65 1 0 0
v_cancel_adding_invoice 740 740 0 0.00 0 399 6 0 0
v_cancel_client_order 2972 2972 0 0.00 0 4781 6 0 0
v_cancel_customer_prepayment 1162 1162 0 0.00 0 3130 13 0 0
v_cancel_customer_reserve 1072 1072 0 0.00 0 3408 14 0 0
v_cancel_payment_to_supplier 634 634 0 0.00 0 2790 13 0 0
v_cancel_supplier_invoice 750 738 12 1.60 0 180 10 0 12
v_cancel_supplier_order 700 700 0 0.00 0 2948 7 0 0
v_cancel_write_off 1680 1680 0 0.00 0 10697 25 0 0
v_max_id_clo_ord 4500 4500 0 0.00 0 170 1 0 0
v_max_id_clo_res 819 819 0 0.00 0 798 7 0 0
v_max_id_ord_sup 4604 4604 0 0.00 0 4869 5 0 0
v_max_non_paid_invoice 1053 1053 0 0.00 0 1823 4 0 0
v_max_non_paid_realizn 2778 2778 0 0.00 0 1452 3 0 0
v_min_id_clo_ord 4500 4500 0 0.00 0 9622 12 0 0
v_min_id_clo_res 819 819 0 0.00 0 2637 9 0 0
v_min_id_ord_sup 4604 4604 0 0.00 0 3326 5 0 0
v_min_non_paid_invoice 4896 4896 0 0.00 0 6365 14 0 0
v_min_non_paid_realizn 5961 5961 0 0.00 0 9613 21 0 0
v_our_firm 8734 8734 0 0.00 0 26 1 0 0
v_reserve_write_off 16476 16476 0 0.00 0 10677 7 0 0
x_lock_depdocs_on_canc_invoice 8895 8895 0 0.00 0 17295 112 0 0
x_lock_depdocs_on_canc_sup_ord 350 350 0 0.00 0 11012 320 0 0
x_make_qstorno_1000_1200 4500 4500 0 0.00 1 34836 1271 0 0
x_make_qstorno_1200_2000 4612 4612 0 0.00 3 84407 2836 0 0
x_make_qstorno_2100_3300 405403 405403 0 0.00 0 71042 183 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 07-03-2024 04:08:44 to 07-03-2024 04:08:48.

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
02:07:50 1165 8192000000 8940254160 8998821888 3896544 0.047 2 1 2 0 3994160 61840 35776
02:08:54 19082 8192000000 9711066112 10011250688 789581600 8.791 100 84 168 0 817918784 7278640 21058544
02:10:20 14593 8192000000 9761035248 10069151744 840513552 9.305 100 89 178 1 872679072 10291216 21874304
02:11:37 12467 8192000000 9785921136 10101084160 860013360 9.500 100 87 174 0 896959504 16542928 20403216
02:12:55 12403 8192000000 9831056432 10157793280 893794848 9.837 100 79 154 1 941414080 30036480 17582752
02:14:12 11254 8192000000 9882160352 10223329280 930714480 10.202 100 78 156 0 991399056 43553632 17130944
02:15:29 8632 8192000000 9919261104 10267242496 970686128 10.593 100 81 158 0 1033093136 46119424 16287584
02:16:42 5341 8192000000 9970568880 10329567232 1005691392 10.934 100 74 146 0 1081459296 61106240 14661664
02:17:50 2430 8192000000 10011407840 10376577024 1027173600 11.141 100 88 174 0 1121572800 77321696 17077504
02:18:55 1952 8192000000 10029984688 10399793152 1041001728 11.274 100 76 152 0 1141078848 84634912 15442208
02:19:59 2023 8192000000 10041513408 10416357376 1066291888 11.517 100 93 186 0 1158237152 72778368 19166896
02:21:03 1384 8192000000 10021687408 10402680832 1073802432 11.588 100 78 158 0 1138629312 49621424 15205456
02:22:08 11478 8192000000 10060971536 10444337152 1084074288 11.686 100 78 157 0 1174818400 75262272 15481840
02:23:21 7584 8192000000 10015132496 10415775744 1086302816 11.707 100 35 67 0 1136390304 43280704 6806784
02:24:33 4667 8192000000 10013376096 10411548672 1092314032 11.765 100 37 74 0 1126971744 26964960 7692752
02:25:41 6479 8192000000 10010607280 10418757632 1095856272 11.798 100 28 54 0 1131512192 29742928 5912992
02:26:48 26483 8192000000 10014815760 10413412352 1100318960 11.841 100 45 90 0 1122010160 12058288 9632912
02:28:23 28476 8192000000 10041329408 10447966208 1107703712 11.911 100 48 97 0 1149588624 32273680 9611232
02:29:57 5348 8192000000 10085819152 10490093568 1125744176 12.081 100 61 122 1 1197745296 59586912 12414208
02:31:09 18228 8192000000 10105757552 10519117824 1134215824 12.161 100 38 76 0 1210067472 66875264 8976384
02:32:30 65438 8192000000 10153733600 10582683648 1138764720 12.204 100 36 72 1 1264736032 117509520 8461792
02:34:48 17808 8192000000 10177015888 10587111424 1117366048 12.002 98 38 76 0 1262453056 136661984 8425024
02:36:13 21458 8192000000 10207702032 10638905344 1144657600 12.259 100 43 86 0 1328432816 173528528 10246688
02:37:43 12059 8192000000 10240028784 10664914944 1138494384 12.201 100 58 112 1 1333823776 183246432 12082960
02:39:05 7661 8192000000 10237199552 10639360000 1121610208 12.042 99 63 120 0 1329049216 194463664 12975344
02:40:19 1813 8192000000 10238235760 10645614592 1098018608 11.819 97 67 134 1 1320635456 207376544 15240304
02:41:32 3957 8192000000 10235875696 10667352064 1093902016 11.780 98 73 141 0 1324393280 214570480 15920784
02:42:39 1357 8192000000 10275933040 10670407680 1115594272 11.985 100 75 147 0 1369241936 237528912 16118752
02:43:47 2552 8192000000 10301176832 10696486912 1111814880 11.950 100 80 157 2 1403086416 273549632 17721904
02:44:54 4714 8192000000 10247800432 10688425984 1102785664 11.864 99 47 94 0 1337973536 224417616 10770256
02:46:07 15862 8192000000 10136802320 10581569536 1112054272 11.952 100 22 44 0 1232035088 114786640 5194176
02:47:25 25393 8192000000 10022848080 10476224512 1047341952 11.335 96 17 34 0 1101920896 50941216 3637728
02:48:52 71477 8192000000 10094519312 10511552512 1100961392 11.847 100 59 117 1 1179359600 66233440 12164768
02:51:04 55951 8192000000 10056889088 10500214784 1102359216 11.860 100 19 38 0 1154392176 47925744 4107216
02:53:02 77514 8192000000 10026911760 10472288256 1097175808 11.811 99 31 62 0 1151566624 47204832 7185984
02:56:04 43762 8192000000 10039605920 10485014528 1104262064 11.878 99 21 38 0 1134433792 25811072 4360656
02:57:48 42893 8192000000 10105449952 10538110976 1111882896 11.950 99 27 54 0 1202635664 85257488 5495280
02:59:32 56101 8192000000 10106086848 10569760768 1116371296 11.993 99 20 41 0 1194396816 73254432 4771088
03:01:31 63746 8192000000 10144447744 10640621568 1126674064 12.090 99 15 30 0 1222268672 92231648 3362960
03:03:40 51311 8192000000 10073525664 10605301760 1114112304 11.971 99 14 28 0 1233492112 116528800 2851008
03:05:36 31786 8192000000 10124539728 10554093568 1120869184 12.035 98 39 76 0 1194021408 64888176 8264048
03:07:09 57926 8192000000 10084868960 10584125440 1141161472 12.226 100 9 18 0 1235123584 92238064 1724048
03:09:08 23067 8192000000 10069762192 10496434176 1150866144 12.318 100 34 66 1 1175946576 19012448 6067984
03:10:31 32080 8192000000 10106810256 10534277120 1142286672 12.237 99 45 88 1 1179238512 28404304 8547536
03:12:10 33783 8192000000 10138918800 10576224256 1156109536 12.367 100 29 58 0 1229139136 67163264 5866336
03:13:51 146903 8192000000 10128482752 10592071680 1134849648 12.167 98 15 30 0 1219191824 80802656 3539520
03:18:22 46938 8192000000 10135665040 10588196864 1156325872 12.369 99 17 34 0 1230216464 70689920 3200672
03:20:10 38411 8192000000 10101365664 10535936000 1108668880 11.920 96 28 56 0 1158919728 44569488 5681360
03:21:55 48719 8192000000 10110007104 10537078784 1133849264 12.158 99 24 46 1 1212586608 74171472 4565872
03:23:46 43913 8192000000 10101032576 10529161216 1093617520 11.777 96 26 52 0 1162403120 63116608 5668992
03:25:31 40273 8192000000 10114707600 10545045504 1133368848 12.153 100 23 43 1 1204979328 67300624 4309856
03:27:11 59136 8192000000 10059015408 10555973632 1101072592 11.848 98 20 40 0 1208612736 103489296 4050848
03:29:14 73708 8192000000 10073816128 10523521024 1106738944 11.902 100 33 66 0 1174002992 60386592 6877456
03:31:32 55396 8192000000 10040932720 10543652864 1081402064 11.661 98 33 66 0 1162180272 74194176 6584032
03:33:36 48233 8192000000 10020184672 10467971072 1104586768 11.881 100 11 22 0 1152687952 45826800 2274384
03:35:27 58661 8192000000 10042298928 10484756480 1083179296 11.678 99 10 20 1 1142030672 56371808 2479568
03:37:26 56060 8192000000 10014174320 10441138176 1046368208 11.326 94 21 38 0 1073968736 23759648 3840880
03:39:24 64839 8192000000 10097480320 10534760448 1117666256 12.005 99 27 54 0 1191799536 68715664 5417616
03:41:32 46853 8192000000 10091724288 10520485888 1109726608 11.930 98 32 64 0 1167360464 51154144 6479712
03:43:49 23403 8192000000 10110791456 10532958208 1124760064 12.072 100 54 108 0 1194292192 58450880 11081248
03:45:14 49028 8192000000 10083497904 10515603456 1095906528 11.799 97 25 50 1 1171135056 70181648 5046880
03:48:14 58831 8192000000 10067088400 10499883008 1125288048 12.077 100 25 50 0 1167883776 37624576 4971152
03:50:15 131236 8192000000 10052377712 10500288512 1108808832 11.921 98 28 54 0 1155713440 40853760 6050848
03:53:54 33355 8192000000 10057528848 10505277440 1109541600 11.928 98 31 62 1 1158543712 42636432 6365680
03:55:29 48710 8192000000 10040602912 10512191488 1105931616 11.894 98 10 20 1 1140464944 32886304 1647024
03:57:20 65094 8192000000 10093782080 10530365440 1128255472 12.105 99 20 40 0 1163898768 31206384 4436912
03:59:40 66637 8192000000 10137666336 10613415936 1122846256 12.054 98 24 48 0 1217274608 89043552 5384800
04:01:51 31467 8192000000 10091054288 10531119104 1121955712 12.045 99 24 48 0 1156508304 29313520 5239072
04:03:30 20144 8192000000 10088812784 10513862656 1131537488 12.136 99 48 94 1 1185143440 44318160 9287792
04:04:52 34524 8192000000 10143354288 10576257024 1145874752 12.271 99 43 86 3 1222637872 67738336 9024784
04:06:31 74201 8192000000 10116481408 10643005440 1118268704 12.011 97 12 24 0 1252635520 131820224 2546592

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:13, from 07-03-2024 04:08:50 to 07-03-2024 04:09:03.

Exceptions occured during test was in run

FB_MNEMONA CNT UNIT FB_GDSCODE
except 99 v_add_invoice_to_stock 335544517
except 6 v_cancel_supplier_invoice 335544517

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

Content of mon$database and FB version 


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


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

Database statistics 

 
Database "/home/bases/oltp40-etalone.fdb" 
Gstat execution time Thu Mar  7 04:09:07 2024 
 
Database header page information: 
    Flags            0 
    Generation        85786 
    System Change Number    0 
    Page size        8192 
    ODS version        13.0 
    Oldest transaction    163681 
    Oldest active        164611 
    Oldest snapshot        164611 
    Next transaction    164612 
    Sequence number        0 
    Next attachment ID    673 
    Implementation        HW=AMD/Intel/x64 little-endian OS=Linux CC=gcc 
    Shadow count        0 
    Page buffers        0 
    Next header page    0 
    Database dialect    3 
    Creation date        Apr 30, 2020 7:30:08 
    Attributes        force write 
 
    Variable header data: 
    Database GUID:    {58978C10-B735-40F5-8B7D-F7A1956E782B} 
    Sweep interval:        0 
    *END* 
 
 
Database file sequence: 
File /home/bases/oltp40-etalone.fdb is the only file 
 
Analyzing database pages ... 
AGENTS (150) 
    Primary pointer page: 524, Index root page: 525 
    Total formats: 1, used formats: 1 
    Average record length: 33.60, total records: 50 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 344.00, compression ratio: 10.24 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 31% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 1 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index AGENTS_ID_DESC (2) 
    Root page: 1504333, depth: 1, leaf buckets: 1, nodes: 50 
    Average node length: 11.82, total dup: 0, max dup: 0 
    Average key length: 10.80, compression ratio: 0.83 
    Average prefix length: 1.18, average data length: 7.82 
    Clustering factor: 1, ratio: 0.02 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index AGENTS_IS_OUR_FIRM (4) 
    Root page: 1504335, depth: 1, leaf buckets: 1, nodes: 50 
    Average node length: 3.08, total dup: 48, max dup: 48 
    Average key length: 2.04, compression ratio: 0.50 
    Average prefix length: 0.96, average data length: 0.06 
    Clustering factor: 1, ratio: 0.02 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index AGENTS_IS_SUPPLIER (3) 
    Root page: 1504334, depth: 1, leaf buckets: 1, nodes: 50 
    Average node length: 3.08, total dup: 48, max dup: 44 
    Average key length: 2.04, compression ratio: 0.54 
    Average prefix length: 1.04, average data length: 0.06 
    Clustering factor: 1, ratio: 0.02 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index AGENTS_NAME_UNQ (1) 
    Root page: 1504332, depth: 1, leaf buckets: 1, nodes: 50 
    Average node length: 17.20, total dup: 0, max dup: 0 
    Average key length: 15.88, compression ratio: 0.92 
    Average prefix length: 1.42, average data length: 13.20 
    Clustering factor: 1, ratio: 0.02 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PK_AGENTS (0) 
    Root page: 1504331, depth: 1, leaf buckets: 1, nodes: 50 
    Average node length: 11.82, total dup: 0, max dup: 0 
    Average key length: 10.80, compression ratio: 0.83 
    Average prefix length: 1.18, average data length: 7.82 
    Clustering factor: 1, ratio: 0.02 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
BUSINESS_OPS (154) 
    Primary pointer page: 532, Index root page: 533 
    Total formats: 1, used formats: 1 
    Average record length: 108.20, total records: 20 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1235.00, compression ratio: 11.41 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 31% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 1 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index BO_UNIT_UNQ (1) 
    Root page: 1504264, depth: 1, leaf buckets: 1, nodes: 20 
    Average node length: 18.25, total dup: 0, max dup: 0 
    Average key length: 17.20, compression ratio: 1.24 
    Average prefix length: 7.05, average data length: 14.25 
    Clustering factor: 1, ratio: 0.05 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index BUSINESS_OPS_PREDICT_PRIOR (3) 
    Root page: 1504266, depth: 1, leaf buckets: 1, nodes: 20 
    Average node length: 5.40, total dup: 0, max dup: 0 
    Average key length: 4.35, compression ratio: 0.67 
    Average prefix length: 1.20, average data length: 1.70 
    Clustering factor: 1, ratio: 0.05 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index BUSINESS_OPS_RND_WGTH (2) 
    Root page: 1504265, depth: 1, leaf buckets: 1, nodes: 20 
    Average node length: 4.30, total dup: 6, max dup: 3 
    Average key length: 3.25, compression ratio: 0.72 
    Average prefix length: 1.35, average data length: 1.00 
    Clustering factor: 1, ratio: 0.05 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index RDB$1 (0) 
    Root page: 1504263, depth: 1, leaf buckets: 1, nodes: 20 
    Average node length: 5.20, total dup: 0, max dup: 0 
    Average key length: 4.15, compression ratio: 0.65 
    Average prefix length: 1.10, average data length: 1.60 
    Clustering factor: 1, ratio: 0.05 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
DOC_DATA (139) 
    Primary pointer page: 502, Index root page: 503 
    Total formats: 1, used formats: 1 
    Average record length: 47.17, total records: 7771032 
    Average version length: 48.16, total versions: 143445, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 64.00, compression ratio: 1.36 
    Pointer pages: 55, data page slots: 88872 
    Data pages: 88872, average fill: 70% 
    Primary pages: 88869, secondary pages: 3, swept pages: 29385 
    Empty pages: 3, full pages: 79261 
    Fill distribution: 
     0 - 19% = 27 
    20 - 39% = 128 
    40 - 59% = 1481 
    60 - 79% = 87129 
    80 - 99% = 107 
 
    Index DOC_DATA_DOC_WARE_UNQ (0) 
    Root page: 1510636, depth: 3, leaf buckets: 23031, nodes: 7771032 
    Average node length: 18.90, total dup: 0, max dup: 0 
    Average key length: 15.91, compression ratio: 1.70 
    Average prefix length: 14.08, average data length: 12.92 
    Clustering factor: 1698006, ratio: 0.22 
    Fill distribution: 
         0 - 19% = 335 
        20 - 39% = 1433 
        40 - 59% = 4106 
        60 - 79% = 2218 
        80 - 99% = 14939 
 
    Index DOC_DATA_ID_DESC (1) 
    Root page: 1528140, depth: 3, leaf buckets: 13375, nodes: 7771032 
    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: 1522418, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 1364 
        40 - 59% = 2035 
        60 - 79% = 994 
        80 - 99% = 8982 
 
    Index FK_DOC_DATA_DOC_LIST (2) 
    Root page: 1546735, depth: 3, leaf buckets: 8247, nodes: 7771032 
    Average node length: 6.62, total dup: 5800533, max dup: 49 
    Average key length: 3.64, compression ratio: 2.47 
    Average prefix length: 7.62, average data length: 1.38 
    Clustering factor: 1515519, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 130 
        20 - 39% = 773 
        40 - 59% = 1419 
        60 - 79% = 824 
        80 - 99% = 5101 
 
DOC_LIST (138) 
    Primary pointer page: 500, Index root page: 501 
    Total formats: 1, used formats: 1 
    Average record length: 55.85, total records: 2259685 
    Average version length: 58.88, total versions: 74396, max versions: 2 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 84.00, compression ratio: 1.50 
    Pointer pages: 18, data page slots: 28544 
    Data pages: 28544, average fill: 73% 
    Primary pages: 28542, secondary pages: 2, swept pages: 7000 
    Empty pages: 0, full pages: 24446 
    Fill distribution: 
     0 - 19% = 6 
    20 - 39% = 17 
    40 - 59% = 158 
    60 - 79% = 28162 
    80 - 99% = 201 
 
    Index DOC_LIST_ID_DESC (1) 
    Root page: 1541152, depth: 3, leaf buckets: 4486, nodes: 2259685 
    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: 688884, ratio: 0.30 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 776 
        40 - 59% = 862 
        60 - 79% = 711 
        80 - 99% = 2137 
 
    Index DOC_LIST_WORKER_OPTYPE (2) 
    Root page: 1544398, depth: 3, leaf buckets: 2425, nodes: 2261493 
    Average node length: 4.97, total dup: 2260594, max dup: 18981 
    Average key length: 2.01, compression ratio: 4.48 
    Average prefix length: 8.99, average data length: 0.01 
    Clustering factor: 1267194, ratio: 0.56 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 186 
        40 - 59% = 1415 
        60 - 79% = 555 
        80 - 99% = 268 
 
    Index FK_DOC_LIST_AGENTS (3) 
    Root page: 1545933, depth: 3, leaf buckets: 1758, nodes: 2259685 
    Average node length: 4.97, total dup: 2259635, max dup: 129999 
    Average key length: 2.01, compression ratio: 4.48 
    Average prefix length: 8.99, average data length: 0.01 
    Clustering factor: 1066782, ratio: 0.47 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 3 
        40 - 59% = 600 
        60 - 79% = 37 
        80 - 99% = 1118 
 
    Index PK_DOC_LIST (0) 
    Root page: 1538209, depth: 3, leaf buckets: 4311, nodes: 2259685 
    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: 688884, ratio: 0.30 
    Fill distribution: 
         0 - 19% = 99 
        20 - 39% = 513 
        40 - 59% = 637 
        60 - 79% = 754 
        80 - 99% = 2308 
 
DOC_STATES (149) 
    Primary pointer page: 522, Index root page: 523 
    Total formats: 1, used formats: 1 
    Average record length: 67.50, total records: 4 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 650.00, compression ratio: 9.63 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 4% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index DOC_STATES_MCODE_UNQ (1) 
    Root page: 1504337, depth: 1, leaf buckets: 1, nodes: 4 
    Average node length: 17.75, total dup: 0, max dup: 0 
    Average key length: 16.50, compression ratio: 1.08 
    Average prefix length: 4.00, average data length: 13.75 
    Clustering factor: 1, ratio: 0.25 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index DOC_STATES_NAME_UNQ (2) 
    Root page: 1504338, depth: 1, leaf buckets: 1, nodes: 4 
    Average node length: 33.25, total dup: 0, max dup: 0 
    Average key length: 32.00, compression ratio: 0.99 
    Average prefix length: 2.50, average data length: 29.25 
    Clustering factor: 1, ratio: 0.25 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PK_DOC_STATES (0) 
    Root page: 1504336, depth: 1, leaf buckets: 1, nodes: 4 
    Average node length: 4.75, total dup: 0, max dup: 0 
    Average key length: 3.50, compression ratio: 0.86 
    Average prefix length: 1.50, average data length: 1.50 
    Clustering factor: 1, ratio: 0.25 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
FB_ERRORS (155) 
    Primary pointer page: 534, Index root page: 535 
    Total formats: 2, used formats: 2 
    Average record length: 57.88, total records: 2182 
    Average version length: 79.61, total versions: 757, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 270.43, compression ratio: 4.67 
    Pointer pages: 1, data page slots: 40 
    Data pages: 40, average fill: 72% 
    Primary pages: 39, secondary pages: 1, swept pages: 0 
    Empty pages: 4, full pages: 34 
    Fill distribution: 
     0 - 19% = 5 
    20 - 39% = 0 
    40 - 59% = 1 
    60 - 79% = 22 
    80 - 99% = 12 
 
    Index FB_ERRORS_GDS_CODE (0) 
    Root page: 398, depth: 2, leaf buckets: 2, nodes: 2182 
    Average node length: 4.40, total dup: 756, max dup: 1 
    Average key length: 2.67, compression ratio: 1.87 
    Average prefix length: 4.33, average data length: 0.67 
    Clustering factor: 1518, ratio: 0.70 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 0 
        40 - 59% = 1 
        60 - 79% = 1 
        80 - 99% = 0 
 
INVNT_SALDO (145) 
    Primary pointer page: 514, Index root page: 515 
    Total formats: 2, used formats: 1 
    Average record length: 83.36, total records: 400 
    Average version length: 31.73, total versions: 2394, max versions: 6 
    Average fragment length: 2.00, total fragments: 2, max fragments: 1 
    Average unpacked length: 104.00, compression ratio: 1.25 
    Pointer pages: 1, data page slots: 32 
    Data pages: 32, average fill: 61% 
    Primary pages: 7, secondary pages: 25, swept pages: 0 
    Empty pages: 1, full pages: 16 
    Fill distribution: 
     0 - 19% = 10 
    20 - 39% = 1 
    40 - 59% = 3 
    60 - 79% = 2 
    80 - 99% = 16 
 
    Index PK_INVNT_SALDO (0) 
    Root page: 1510371, depth: 1, leaf buckets: 1, nodes: 400 
    Average node length: 11.22, total dup: 0, max dup: 0 
    Average key length: 10.22, compression ratio: 0.88 
    Average prefix length: 1.78, average data length: 7.22 
    Clustering factor: 326, ratio: 0.81 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 0 
        40 - 59% = 1 
        60 - 79% = 0 
        80 - 99% = 0 
 
INVNT_TURNOVER_LOG (153) 
    Primary pointer page: 530, Index root page: 531 
    Total formats: 1, used formats: 1 
    Average record length: 30.91, total records: 139789 
    Average version length: 68.28, total versions: 88153, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 88.00, compression ratio: 2.85 
    Pointer pages: 5, data page slots: 3680 
    Data pages: 2192, average fill: 80% 
    Primary pages: 2191, secondary pages: 1, swept pages: 0 
    Empty pages: 103, full pages: 1961 
    Fill distribution: 
     0 - 19% = 141 
    20 - 39% = 30 
    40 - 59% = 36 
    60 - 79% = 525 
    80 - 99% = 1460 
 
    Index INVNT_TURNOVER_LOG_WARE_DD_ID (0) 
    Root page: 1684690, depth: 3, leaf buckets: 387, nodes: 139789 
    Average node length: 13.04, total dup: 11086, max dup: 2 
    Average key length: 10.58, compression ratio: 2.55 
    Average prefix length: 19.33, average data length: 7.67 
    Clustering factor: 104175, ratio: 0.75 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 0 
        40 - 59% = 247 
        60 - 79% = 120 
        80 - 99% = 18 
 
MONEY_SALDO (141) 
    Primary pointer page: 506, Index root page: 507 
    Total formats: 1, used formats: 1 
    Average record length: 15.27, total records: 49 
    Average version length: 9.00, total versions: 221, max versions: 8 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 32.00, compression ratio: 2.10 
    Pointer pages: 1, data page slots: 2 
    Data pages: 2, average fill: 46% 
    Primary pages: 1, secondary pages: 1, 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_MONEY_SALDO (0) 
    Root page: 1510383, depth: 1, leaf buckets: 1, nodes: 49 
    Average node length: 11.82, total dup: 0, max dup: 0 
    Average key length: 10.80, compression ratio: 0.83 
    Average prefix length: 1.18, average data length: 7.82 
    Clustering factor: 1, ratio: 0.02 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
MONEY_TURNOVER_LOG (140) 
    Primary pointer page: 504, Index root page: 505 
    Total formats: 1, used formats: 1 
    Average record length: 22.60, total records: 2361 
    Average version length: 43.20, total versions: 1468, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 58.00, compression ratio: 2.57 
    Pointer pages: 1, data page slots: 32 
    Data pages: 31, average fill: 72% 
    Primary pages: 30, secondary pages: 1, swept pages: 0 
    Empty pages: 2, full pages: 24 
    Fill distribution: 
     0 - 19% = 4 
    20 - 39% = 0 
    40 - 59% = 2 
    60 - 79% = 5 
    80 - 99% = 20 
 
    Index MONEY_TURNOVER_LOG_AGENT_OPTYPE (0) 
    Root page: 89900, depth: 2, leaf buckets: 4, nodes: 2361 
    Average node length: 4.19, total dup: 2263, max dup: 284 
    Average key length: 2.45, compression ratio: 7.74 
    Average prefix length: 18.59, average data length: 0.41 
    Clustering factor: 1183, ratio: 0.50 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 2 
        40 - 59% = 1 
        60 - 79% = 0 
        80 - 99% = 0 
 
MON_CACHE_MEMORY (165) 
    Primary pointer page: 555, Index root page: 556 
    Total formats: 2, used formats: 1 
    Average record length: 97.59, 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% = 1 
    80 - 99% = 0 
 
    Index PK_MON_CACHE_MEMORY (0) 
    Root page: 1504238, depth: 1, leaf buckets: 1, nodes: 71 
    Average node length: 11.70, total dup: 0, max dup: 0 
    Average key length: 10.69, compression ratio: 0.84 
    Average prefix length: 1.30, average data length: 7.70 
    Clustering factor: 2, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
MON_LOG (162) 
    Primary pointer page: 548, Index root page: 549 
    Total formats: 2, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index MON_LOG_DTS (4) 
    Root page: 1504251, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index MON_LOG_GDSCODE (2) 
    Root page: 1504249, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index MON_LOG_ROWSET_DESC (1) 
    Root page: 1504248, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index MON_LOG_UNIT (3) 
    Root page: 1504250, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PK_MON_LOG (0) 
    Root page: 1504247, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
MON_LOG_TABLE_STATS (163) 
    Primary pointer page: 550, Index root page: 551 
    Total formats: 2, used formats: 1 
    Average record length: 67.13, total records: 30 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 611.00, compression ratio: 9.10 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 31% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 1 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index MON_LOG_TABLE_STATS_DTS (4) 
    Root page: 1504246, depth: 1, leaf buckets: 1, nodes: 30 
    Average node length: 3.50, total dup: 23, max dup: 4 
    Average key length: 2.47, compression ratio: 3.24 
    Average prefix length: 7.53, average data length: 0.47 
    Clustering factor: 1, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index MON_LOG_TABLE_STATS_GDSCODE (2) 
    Root page: 1504244, depth: 1, leaf buckets: 1, nodes: 30 
    Average node length: 2.00, total dup: 29, max dup: 29 
    Average key length: 1.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 1, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index MON_LOG_TABLE_STATS_ROWSET (1) 
    Root page: 1504243, depth: 1, leaf buckets: 1, nodes: 30 
    Average node length: 3.33, total dup: 29, max dup: 29 
    Average key length: 2.30, compression ratio: 3.91 
    Average prefix length: 8.70, average data length: 0.30 
    Clustering factor: 1, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index MON_LOG_TABLE_STATS_TN_UNIT (3) 
    Root page: 1504245, depth: 1, leaf buckets: 1, nodes: 30 
    Average node length: 12.90, total dup: 0, max dup: 0 
    Average key length: 11.87, compression ratio: 1.42 
    Average prefix length: 7.63, average data length: 9.20 
    Clustering factor: 1, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PK_MON_LOG_TABLE_STATS (0) 
    Root page: 1504242, depth: 1, leaf buckets: 1, nodes: 30 
    Average node length: 8.37, total dup: 0, max dup: 0 
    Average key length: 7.33, compression ratio: 1.23 
    Average prefix length: 4.63, average data length: 4.37 
    Clustering factor: 1, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
OPTYPES (136) 
    Primary pointer page: 496, Index root page: 497 
    Total formats: 2, used formats: 1 
    Average record length: 67.56, total records: 9 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 386.00, compression ratio: 5.71 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 9% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index OPTYPES_MCODE_UNQ (1) 
    Root page: 1544827, depth: 1, leaf buckets: 1, nodes: 9 
    Average node length: 8.56, total dup: 0, max dup: 0 
    Average key length: 6.89, compression ratio: 0.73 
    Average prefix length: 0.44, average data length: 4.56 
    Clustering factor: 1, ratio: 0.11 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PK_OPTYPES (0) 
    Root page: 1544826, depth: 1, leaf buckets: 1, nodes: 9 
    Average node length: 6.11, total dup: 0, max dup: 0 
    Average key length: 5.00, compression ratio: 0.60 
    Average prefix length: 0.89, average data length: 2.11 
    Clustering factor: 1, ratio: 0.11 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
PDISTR (146) 
    Primary pointer page: 516, Index root page: 517 
    Total formats: 1, used formats: 1 
    Average record length: 35.84, total records: 834066 
    Average version length: 37.87, total versions: 37882, max versions: 3 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 54.00, compression ratio: 1.51 
    Pointer pages: 6, data page slots: 8496 
    Data pages: 8496, average fill: 67% 
    Primary pages: 8495, secondary pages: 1, swept pages: 968 
    Empty pages: 8, full pages: 8303 
    Fill distribution: 
     0 - 19% = 10 
    20 - 39% = 3 
    40 - 59% = 26 
    60 - 79% = 8390 
    80 - 99% = 67 
 
    Index PDISTR_AGENT_ID (2) 
    Root page: 1509330, depth: 2, leaf buckets: 861, nodes: 812974 
    Average node length: 4.88, total dup: 812925, max dup: 149243 
    Average key length: 2.01, compression ratio: 4.48 
    Average prefix length: 8.99, average data length: 0.01 
    Clustering factor: 93690, ratio: 0.12 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 113 
        40 - 59% = 457 
        60 - 79% = 183 
        80 - 99% = 108 
 
    Index PDISTR_SNDOP_RCVOP_SNDID_ASC (0) 
    Root page: 1508635, depth: 3, leaf buckets: 942, nodes: 812974 
    Average node length: 5.89, total dup: 723381, max dup: 45 
    Average key length: 3.02, compression ratio: 7.28 
    Average prefix length: 21.09, average data length: 0.91 
    Clustering factor: 164423, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 27 
        40 - 59% = 532 
        60 - 79% = 107 
        80 - 99% = 276 
 
    Index PDISTR_SNDOP_RCVOP_SNDID_DESC (1) 
    Root page: 1509209, depth: 3, leaf buckets: 962, nodes: 812974 
    Average node length: 5.89, total dup: 723381, max dup: 45 
    Average key length: 3.02, compression ratio: 7.27 
    Average prefix length: 21.09, average data length: 0.91 
    Clustering factor: 166407, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 79 
        40 - 59% = 502 
        60 - 79% = 113 
        80 - 99% = 268 
 
    Index PDISTR_WORKER_SND_ID (3) 
    Root page: 1510200, depth: 3, leaf buckets: 1153, nodes: 812974 
    Average node length: 5.98, total dup: 723381, max dup: 45 
    Average key length: 3.11, compression ratio: 5.47 
    Average prefix length: 16.00, average data length: 1.00 
    Clustering factor: 159073, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 4 
        20 - 39% = 232 
        40 - 59% = 626 
        60 - 79% = 196 
        80 - 99% = 95 
 
PERF_AGG (158) 
    Primary pointer page: 540, Index root page: 541 
    Total formats: 1, used formats: 1 
    Average record length: 62.69, total records: 5435 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 2.71, total fragments: 35, max fragments: 1 
    Average unpacked length: 379.00, compression ratio: 6.05 
    Pointer pages: 1, data page slots: 96 
    Data pages: 95, average fill: 57% 
    Primary pages: 76, secondary pages: 19, swept pages: 57 
    Empty pages: 14, full pages: 58 
    Fill distribution: 
     0 - 19% = 21 
    20 - 39% = 0 
    40 - 59% = 2 
    60 - 79% = 72 
    80 - 99% = 0 
 
    Index PERF_AGG_UNQ (1) 
    Root page: 1504260, depth: 2, leaf buckets: 6, nodes: 5435 
    Average node length: 5.52, total dup: 0, max dup: 0 
    Average key length: 3.58, compression ratio: 10.02 
    Average prefix length: 34.38, average data length: 1.55 
    Clustering factor: 5097, ratio: 0.94 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 0 
        40 - 59% = 4 
        60 - 79% = 1 
        80 - 99% = 1 
 
    Index PK_PERF_AGG (0) 
    Root page: 1504255, depth: 2, leaf buckets: 10, nodes: 5435 
    Average node length: 11.14, total dup: 0, max dup: 0 
    Average key length: 9.21, compression ratio: 0.98 
    Average prefix length: 2.79, average data length: 6.21 
    Clustering factor: 171, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 1 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 7 
 
PERF_ESTIMATED (280) 
    Primary pointer page: 399, Index root page: 434 
    Total formats: 1, used formats: 1 
    Average record length: 39.07, total records: 75003 
    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: 784 
    Data pages: 784, average fill: 66% 
    Primary pages: 784, secondary pages: 0, swept pages: 0 
    Empty pages: 3, full pages: 779 
    Fill distribution: 
     0 - 19% = 4 
    20 - 39% = 1 
    40 - 59% = 0 
    60 - 79% = 779 
    80 - 99% = 0 
 
    Index PK_PERF_ESTIMATED (0) 
    Root page: 30888, depth: 2, leaf buckets: 95, nodes: 75003 
    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: 2869, ratio: 0.04 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 0 
        40 - 59% = 1 
        60 - 79% = 0 
        80 - 99% = 94 
 
PERF_ISQL_STAT (156) 
    Primary pointer page: 536, Index root page: 537 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index PERF_ISQL_STAT_TRN (0) 
    Root page: 1504261, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
PERF_LOG (159) 
    Primary pointer page: 542, Index root page: 543 
    Total formats: 1, used formats: 1 
    Average record length: 111.07, total records: 71 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1691.00, compression ratio: 15.22 
    Pointer pages: 1, data page slots: 2 
    Data pages: 2, average fill: 56% 
    Primary pages: 2, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 1 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 1 
    40 - 59% = 0 
    60 - 79% = 1 
    80 - 99% = 0 
 
PERF_SPLIT_0 (281) 
    Primary pointer page: 601, Index root page: 602 
    Total formats: 1, used formats: 1 
    Average record length: 145.34, total records: 144398 
    Average version length: 151.22, total versions: 5880, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.67 
    Pointer pages: 6, data page slots: 6072 
    Data pages: 3616, average fill: 83% 
    Primary pages: 3614, secondary pages: 2, swept pages: 5 
    Empty pages: 55, full pages: 3537 
    Fill distribution: 
     0 - 19% = 61 
    20 - 39% = 10 
    40 - 59% = 5 
    60 - 79% = 2 
    80 - 99% = 3538 
 
PERF_SPLIT_1 (282) 
    Primary pointer page: 603, Index root page: 604 
    Total formats: 1, used formats: 1 
    Average record length: 138.38, total records: 138012 
    Average version length: 152.32, total versions: 12326, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 12.26 
    Pointer pages: 6, data page slots: 4512 
    Data pages: 3456, average fill: 83% 
    Primary pages: 3454, secondary pages: 2, swept pages: 2 
    Empty pages: 52, full pages: 3382 
    Fill distribution: 
     0 - 19% = 56 
    20 - 39% = 7 
    40 - 59% = 8 
    60 - 79% = 4 
    80 - 99% = 3381 
 
PERF_SPLIT_2 (283) 
    Primary pointer page: 605, Index root page: 606 
    Total formats: 1, used formats: 1 
    Average record length: 137.77, total records: 148762 
    Average version length: 153.59, total versions: 14001, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 12.31 
    Pointer pages: 5, data page slots: 4696 
    Data pages: 3704, average fill: 84% 
    Primary pages: 3702, secondary pages: 2, swept pages: 5 
    Empty pages: 36, full pages: 3650 
    Fill distribution: 
     0 - 19% = 38 
    20 - 39% = 8 
    40 - 59% = 4 
    60 - 79% = 5 
    80 - 99% = 3649 
 
PERF_SPLIT_3 (284) 
    Primary pointer page: 607, Index root page: 608 
    Total formats: 1, used formats: 1 
    Average record length: 141.93, total records: 145939 
    Average version length: 152.37, total versions: 9358, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.95 
    Pointer pages: 5, data page slots: 3984 
    Data pages: 3640, average fill: 83% 
    Primary pages: 3637, secondary pages: 3, swept pages: 6 
    Empty pages: 44, full pages: 3572 
    Fill distribution: 
     0 - 19% = 48 
    20 - 39% = 6 
    40 - 59% = 6 
    60 - 79% = 7 
    80 - 99% = 3573 
 
PERF_SPLIT_4 (285) 
    Primary pointer page: 609, Index root page: 610 
    Total formats: 1, used formats: 1 
    Average record length: 106.13, total records: 212902 
    Average version length: 154.79, total versions: 67569, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 15.98 
    Pointer pages: 6, data page slots: 5792 
    Data pages: 5376, average fill: 86% 
    Primary pages: 5373, secondary pages: 3, swept pages: 5 
    Empty pages: 98, full pages: 5243 
    Fill distribution: 
     0 - 19% = 101 
    20 - 39% = 11 
    40 - 59% = 12 
    60 - 79% = 9 
    80 - 99% = 5243 
 
PERF_SPLIT_5 (286) 
    Primary pointer page: 611, Index root page: 612 
    Total formats: 1, used formats: 1 
    Average record length: 129.10, total records: 176253 
    Average version length: 154.20, total versions: 27518, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 13.14 
    Pointer pages: 7, data page slots: 5368 
    Data pages: 4448, average fill: 84% 
    Primary pages: 4445, secondary pages: 3, swept pages: 3 
    Empty pages: 91, full pages: 4329 
    Fill distribution: 
     0 - 19% = 99 
    20 - 39% = 8 
    40 - 59% = 3 
    60 - 79% = 8 
    80 - 99% = 4330 
 
PERF_SPLIT_6 (287) 
    Primary pointer page: 613, Index root page: 614 
    Total formats: 1, used formats: 1 
    Average record length: 115.91, total records: 170494 
    Average version length: 154.45, total versions: 42165, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 14.63 
    Pointer pages: 6, data page slots: 5520 
    Data pages: 4280, average fill: 86% 
    Primary pages: 4278, secondary pages: 2, swept pages: 4 
    Empty pages: 65, full pages: 4194 
    Fill distribution: 
     0 - 19% = 71 
    20 - 39% = 8 
    40 - 59% = 4 
    60 - 79% = 2 
    80 - 99% = 4195 
 
PERF_SPLIT_7 (288) 
    Primary pointer page: 615, Index root page: 616 
    Total formats: 1, used formats: 1 
    Average record length: 125.83, total records: 168362 
    Average version length: 154.40, total versions: 30066, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 13.48 
    Pointer pages: 5, data page slots: 4736 
    Data pages: 4216, average fill: 85% 
    Primary pages: 4214, secondary pages: 2, swept pages: 3 
    Empty pages: 53, full pages: 4131 
    Fill distribution: 
     0 - 19% = 56 
    20 - 39% = 10 
    40 - 59% = 10 
    60 - 79% = 8 
    80 - 99% = 4132 
 
PERF_SPLIT_8 (289) 
    Primary pointer page: 617, Index root page: 618 
    Total formats: 1, used formats: 1 
    Average record length: 117.69, total records: 186113 
    Average version length: 154.49, total versions: 43777, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 14.41 
    Pointer pages: 6, data page slots: 5208 
    Data pages: 4648, average fill: 86% 
    Primary pages: 4646, secondary pages: 2, swept pages: 8 
    Empty pages: 47, full pages: 4576 
    Fill distribution: 
     0 - 19% = 52 
    20 - 39% = 10 
    40 - 59% = 4 
    60 - 79% = 5 
    80 - 99% = 4577 
 
PERF_SPLIT_9 (290) 
    Primary pointer page: 619, Index root page: 620 
    Total formats: 1, used formats: 1 
    Average record length: 117.02, total records: 178329 
    Average version length: 154.59, total versions: 42872, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 14.49 
    Pointer pages: 6, data page slots: 5112 
    Data pages: 4456, average fill: 86% 
    Primary pages: 4453, secondary pages: 3, swept pages: 1 
    Empty pages: 49, full pages: 4390 
    Fill distribution: 
     0 - 19% = 52 
    20 - 39% = 6 
    40 - 59% = 3 
    60 - 79% = 5 
    80 - 99% = 4390 
 
PHRASES (143) 
    Primary pointer page: 510, Index root page: 511 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index PHRASES_ID_DESC (3) 
    Root page: 1510376, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PHRASES_NAME (2) 
    Root page: 1510375, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PHRASES_UNQ (1) 
    Root page: 1510374, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PK_PHRASES (0) 
    Root page: 1510373, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
PSTORNED (147) 
    Primary pointer page: 518, Index root page: 519 
    Total formats: 1, used formats: 1 
    Average record length: 51.35, total records: 2116763 
    Average version length: 52.92, total versions: 67530, 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: 25384 
    Data pages: 25384, average fill: 72% 
    Primary pages: 25375, secondary pages: 9, swept pages: 8740 
    Empty pages: 22, full pages: 23900 
    Fill distribution: 
     0 - 19% = 57 
    20 - 39% = 93 
    40 - 59% = 303 
    60 - 79% = 24172 
    80 - 99% = 759 
 
    Index PSTORNED_RCV_ID (1) 
    Root page: 1506208, depth: 3, leaf buckets: 2548, nodes: 2116763 
    Average node length: 5.44, total dup: 1976812, max dup: 1416 
    Average key length: 2.48, compression ratio: 3.63 
    Average prefix length: 8.58, average data length: 0.42 
    Clustering factor: 183379, ratio: 0.09 
    Fill distribution: 
         0 - 19% = 3 
        20 - 39% = 241 
        40 - 59% = 1680 
        60 - 79% = 282 
        80 - 99% = 342 
 
    Index PSTORNED_SND_ID (0) 
    Root page: 1504841, depth: 3, leaf buckets: 2756, nodes: 2116763 
    Average node length: 5.69, total dup: 1900337, max dup: 63 
    Average key length: 2.74, compression ratio: 3.29 
    Average prefix length: 8.36, average data length: 0.64 
    Clustering factor: 378536, ratio: 0.18 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 6 
        40 - 59% = 2384 
        60 - 79% = 341 
        80 - 99% = 25 
 
    Index PSTORNED_WORKER_ID (2) 
    Root page: 1508018, depth: 3, leaf buckets: 2091, nodes: 2116763 
    Average node length: 4.96, total dup: 2116663, max dup: 27371 
    Average key length: 2.00, compression ratio: 1.20 
    Average prefix length: 2.41, average data length: 0.00 
    Clustering factor: 180884, ratio: 0.09 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 156 
        40 - 59% = 1080 
        60 - 79% = 388 
        80 - 99% = 465 
 
RULES_FOR_PDISTR (148) 
    Primary pointer page: 520, Index root page: 521 
    Total formats: 1, used formats: 1 
    Average record length: 17.00, total records: 4 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 334.00, compression ratio: 19.65 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 2% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index RULES_FOR_PDISTR_UNQ (0) 
    Root page: 1504339, depth: 1, leaf buckets: 1, nodes: 4 
    Average node length: 11.50, total dup: 0, max dup: 0 
    Average key length: 10.25, compression ratio: 0.88 
    Average prefix length: 1.50, average data length: 7.50 
    Clustering factor: 1, ratio: 0.25 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
RULES_FOR_QDISTR (137) 
    Primary pointer page: 498, Index root page: 499 
    Total formats: 1, used formats: 1 
    Average record length: 32.71, total records: 7 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 332.00, compression ratio: 10.15 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 4% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index RULES_FOR_QDISTR_RCVOP (1) 
    Root page: 1544825, depth: 1, leaf buckets: 1, nodes: 7 
    Average node length: 5.29, total dup: 2, max dup: 2 
    Average key length: 4.14, compression ratio: 0.72 
    Average prefix length: 1.43, average data length: 1.57 
    Clustering factor: 1, ratio: 0.14 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index RULES_FOR_QDISTR_UNQ (0) 
    Root page: 1544824, depth: 1, leaf buckets: 1, nodes: 7 
    Average node length: 10.14, total dup: 0, max dup: 0 
    Average key length: 8.86, compression ratio: 0.94 
    Average prefix length: 2.14, average data length: 6.14 
    Clustering factor: 1, ratio: 0.14 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
SEMAPHORES (152) 
    Primary pointer page: 528, Index root page: 529 
    Total formats: 1, used formats: 1 
    Average record length: 43.40, total records: 5 
    Average version length: 9.00, total versions: 1, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 346.00, compression ratio: 7.97 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 4% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index PK_SEMAPHORES (0) 
    Root page: 1504327, depth: 1, leaf buckets: 1, nodes: 5 
    Average node length: 12.40, total dup: 0, max dup: 0 
    Average key length: 11.00, compression ratio: 0.82 
    Average prefix length: 0.60, average data length: 8.40 
    Clustering factor: 1, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index SEMAPHORES_TASK_UNQ (1) 
    Root page: 1504328, depth: 1, leaf buckets: 1, nodes: 5 
    Average node length: 23.40, total dup: 0, max dup: 0 
    Average key length: 22.00, compression ratio: 1.07 
    Average prefix length: 4.20, average data length: 19.40 
    Clustering factor: 1, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
SETTINGS (135) 
    Primary pointer page: 494, Index root page: 495 
    Total formats: 1, used formats: 1 
    Average record length: 97.62, total records: 149 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1347.00, compression ratio: 13.80 
    Pointer pages: 1, data page slots: 3 
    Data pages: 3, average fill: 70% 
    Primary pages: 3, secondary pages: 0, swept pages: 1 
    Empty pages: 0, full pages: 2 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 1 
    60 - 79% = 0 
    80 - 99% = 2 
 
    Index SETTINGS_MCODE_WM_UNQ (1) 
    Root page: 1544931, depth: 1, leaf buckets: 1, nodes: 149 
    Average node length: 14.66, total dup: 0, max dup: 0 
    Average key length: 13.55, compression ratio: 2.19 
    Average prefix length: 19.07, average data length: 10.66 
    Clustering factor: 48, ratio: 0.32 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 1 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index SETTINGS_MODE_CODE (0) 
    Root page: 1544828, depth: 1, leaf buckets: 1, nodes: 149 
    Average node length: 25.56, total dup: 0, max dup: 0 
    Average key length: 24.56, compression ratio: 1.63 
    Average prefix length: 18.58, average data length: 21.56 
    Clustering factor: 14, ratio: 0.09 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 0 
        40 - 59% = 1 
        60 - 79% = 0 
        80 - 99% = 0 
 
TMP$DEP_DOCS (129) 
    Primary pointer page: 482, Index root page: 483 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index TMP_DEP_DOCS_UNQ (0) 
    Root page: 1544832, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
TMP$IDX_RECALC (132) 
    Primary pointer page: 488, Index root page: 489 
    Total formats: 2, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index TMP_IDX_RECALC_IDX_NAME_UNQ (0) 
    Root page: 1544829, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
TMP$MON_LOG (133) 
    Primary pointer page: 490, Index root page: 491 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
TMP$MON_LOG_TABLE_STATS (134) 
    Primary pointer page: 492, Index root page: 493 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
TMP$PERF_EST_WHOLE (161) 
    Primary pointer page: 546, Index root page: 547 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
TMP$PERF_LOG (160) 
    Primary pointer page: 544, Index root page: 545 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index TMP$PERF_LOG_UNIT_TRN_DTS_END (0) 
    Root page: 1504252, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
TMP$PERF_MON (131) 
    Primary pointer page: 486, Index root page: 487 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
TMP$RESULT_SET (130) 
    Primary pointer page: 484, Index root page: 485 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index TMP_RESULT_SET_DOC (1) 
    Root page: 1544831, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index TMP_RESULT_SET_WARE_DOC (0) 
    Root page: 1544830, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
TMP$SHOPPING_CART (128) 
    Primary pointer page: 480, Index root page: 481 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index TMP_SHOPCART_UNQ (0) 
    Root page: 1544833, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
TPAUSE (166) 
    Primary pointer page: 557, Index root page: 558 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index RDB$PRIMARY2 (0) 
    Root page: 1504237, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
TRACE_STAT (157) 
    Primary pointer page: 538, Index root page: 539 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
WARES (142) 
    Primary pointer page: 508, Index root page: 509 
    Total formats: 1, used formats: 1 
    Average record length: 77.52, total records: 400 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 444.00, compression ratio: 5.73 
    Pointer pages: 1, data page slots: 6 
    Data pages: 6, average fill: 77% 
    Primary pages: 6, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 5 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 5 
    80 - 99% = 1 
 
    Index FK_WARES_WARE_GROUPS (3) 
    Root page: 1552183, depth: 1, leaf buckets: 1, nodes: 400 
    Average node length: 3.17, total dup: 392, max dup: 60 
    Average key length: 2.16, compression ratio: 4.16 
    Average prefix length: 8.86, average data length: 0.14 
    Clustering factor: 48, ratio: 0.12 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PK_WARES (0) 
    Root page: 1510377, depth: 1, leaf buckets: 1, nodes: 400 
    Average node length: 11.22, total dup: 0, max dup: 0 
    Average key length: 10.22, compression ratio: 0.88 
    Average prefix length: 1.78, average data length: 7.22 
    Clustering factor: 344, ratio: 0.86 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 0 
        40 - 59% = 1 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index WARES_ID_DESC (2) 
    Root page: 1510382, depth: 1, leaf buckets: 1, nodes: 400 
    Average node length: 11.22, total dup: 0, max dup: 0 
    Average key length: 10.22, compression ratio: 0.88 
    Average prefix length: 1.78, average data length: 7.22 
    Clustering factor: 344, ratio: 0.86 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 0 
        40 - 59% = 1 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index WARES_NUMB_UNQ (1) 
    Root page: 1510380, depth: 2, leaf buckets: 3, nodes: 400 
    Average node length: 53.25, total dup: 0, max dup: 0 
    Average key length: 52.23, compression ratio: 1.00 
    Average prefix length: 2.74, average data length: 49.25 
    Clustering factor: 355, ratio: 0.89 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 1 
        80 - 99% = 2 
 
WARE_GROUPS (151) 
    Primary pointer page: 526, Index root page: 527 
    Total formats: 1, used formats: 1 
    Average record length: 32.12, total records: 8 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 346.00, compression ratio: 10.77 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 5% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index PK_WARE_GROUPS (0) 
    Root page: 1504329, depth: 1, leaf buckets: 1, nodes: 8 
    Average node length: 11.25, total dup: 0, max dup: 0 
    Average key length: 10.12, compression ratio: 0.89 
    Average prefix length: 1.75, average data length: 7.25 
    Clustering factor: 1, ratio: 0.12 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index WARE_GROUPS_NAME_UNQ (1) 
    Root page: 1504330, depth: 1, leaf buckets: 1, nodes: 8 
    Average node length: 19.88, total dup: 0, max dup: 0 
    Average key length: 18.12, compression ratio: 0.89 
    Average prefix length: 0.25, average data length: 15.88 
    Clustering factor: 1, ratio: 0.12 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
XQD_1000_1200 (176) 
    Primary pointer page: 577, Index root page: 578 
    Total formats: 1, used formats: 1 
    Average record length: 41.64, total records: 166382 
    Average version length: 69.16, total versions: 76172, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 3.03 
    Pointer pages: 3, data page slots: 3584 
    Data pages: 2952, average fill: 68% 
    Primary pages: 2952, secondary pages: 0, swept pages: 273 
    Empty pages: 378, full pages: 2415 
    Fill distribution: 
     0 - 19% = 495 
    20 - 39% = 21 
    40 - 59% = 5 
    60 - 79% = 895 
    80 - 99% = 1536 
 
    Index XQD_1000_1200_WA_SO_RO_WKR_SND (0) 
    Root page: 102665, depth: 3, leaf buckets: 225, nodes: 166382 
    Average node length: 6.48, total dup: 144859, max dup: 14 
    Average key length: 3.92, compression ratio: 10.72 
    Average prefix length: 40.21, average data length: 1.79 
    Clustering factor: 28543, ratio: 0.17 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 16 
        40 - 59% = 105 
        60 - 79% = 72 
        80 - 99% = 31 
 
XQD_1000_3300 (178) 
    Primary pointer page: 581, Index root page: 582 
    Total formats: 1, used formats: 1 
    Average record length: 64.70, total records: 7269597 
    Average version length: 68.75, total versions: 515058, 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: 65, data page slots: 105296 
    Data pages: 105296, average fill: 74% 
    Primary pages: 105296, secondary pages: 0, swept pages: 9144 
    Empty pages: 6, full pages: 99072 
    Fill distribution: 
     0 - 19% = 73 
    20 - 39% = 478 
    40 - 59% = 1956 
    60 - 79% = 99802 
    80 - 99% = 2987 
 
    Index XQD_1000_3300_WA_SO_RO_WKR_SND (0) 
    Root page: 1480476, depth: 3, leaf buckets: 10707, nodes: 7269597 
    Average node length: 6.51, total dup: 6291304, max dup: 29 
    Average key length: 3.51, compression ratio: 11.95 
    Average prefix length: 40.62, average data length: 1.38 
    Clustering factor: 1711626, ratio: 0.24 
    Fill distribution: 
         0 - 19% = 9 
        20 - 39% = 1460 
        40 - 59% = 5730 
        60 - 79% = 2792 
        80 - 99% = 716 
 
    Index XQD_1000_3300_WKR_DOC_ASC (1) 
    Root page: 1486090, depth: 3, leaf buckets: 8565, nodes: 7269597 
    Average node length: 5.39, total dup: 6987433, max dup: 156 
    Average key length: 2.40, compression ratio: 7.09 
    Average prefix length: 16.64, average data length: 0.36 
    Clustering factor: 1506432, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 6 
        20 - 39% = 934 
        40 - 59% = 4844 
        60 - 79% = 1729 
        80 - 99% = 1052 
 
    Index XQD_1000_3300_WKR_DOC_DEC (2) 
    Root page: 1490630, depth: 3, leaf buckets: 8669, nodes: 7269597 
    Average node length: 5.39, total dup: 6987433, max dup: 156 
    Average key length: 2.40, compression ratio: 7.09 
    Average prefix length: 16.64, average data length: 0.36 
    Clustering factor: 1508862, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 13 
        20 - 39% = 1032 
        40 - 59% = 4868 
        60 - 79% = 1720 
        80 - 99% = 1036 
 
XQD_1200_2000 (177) 
    Primary pointer page: 579, Index root page: 580 
    Total formats: 1, used formats: 1 
    Average record length: 66.71, total records: 12264768 
    Average version length: 68.71, total versions: 451277, 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: 107, data page slots: 174304 
    Data pages: 174304, average fill: 75% 
    Primary pages: 174303, secondary pages: 1, swept pages: 44281 
    Empty pages: 4, full pages: 174078 
    Fill distribution: 
     0 - 19% = 5 
    20 - 39% = 1 
    40 - 59% = 10 
    60 - 79% = 169993 
    80 - 99% = 4295 
 
    Index XQD_1200_2000_WA_SO_RO_WKR_SND (0) 
    Root page: 1495050, depth: 3, leaf buckets: 18456, nodes: 12259801 
    Average node length: 6.62, total dup: 10687300, max dup: 73 
    Average key length: 3.43, compression ratio: 12.26 
    Average prefix length: 40.70, average data length: 1.30 
    Clustering factor: 2515193, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 35 
        20 - 39% = 2064 
        40 - 59% = 10600 
        60 - 79% = 4822 
        80 - 99% = 935 
 
XQD_2000_3300 (179) 
    Primary pointer page: 583, Index root page: 584 
    Total formats: 1, used formats: 1 
    Average record length: 39.63, total records: 1908520 
    Average version length: 69.05, total versions: 500879, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 3.18 
    Pointer pages: 23, data page slots: 37288 
    Data pages: 27439, average fill: 68% 
    Primary pages: 27343, secondary pages: 96, swept pages: 1018 
    Empty pages: 188, full pages: 26901 
    Fill distribution: 
     0 - 19% = 350 
    20 - 39% = 4528 
    40 - 59% = 2157 
    60 - 79% = 13034 
    80 - 99% = 7370 
 
    Index XQD_2000_3300_WA_SO_RO_WKR_SND (0) 
    Root page: 1479735, depth: 3, leaf buckets: 1799, nodes: 1473081 
    Average node length: 5.52, total dup: 1413361, max dup: 49 
    Average key length: 2.56, compression ratio: 16.39 
    Average prefix length: 41.48, average data length: 0.52 
    Clustering factor: 105994, ratio: 0.07 
    Fill distribution: 
         0 - 19% = 12 
        20 - 39% = 245 
        40 - 59% = 820 
        60 - 79% = 557 
        80 - 99% = 165 
 
XQD_2100_3300 (180) 
    Primary pointer page: 585, Index root page: 586 
    Total formats: 1, used formats: 1 
    Average record length: 33.06, total records: 1583831 
    Average version length: 69.01, total versions: 189094, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 3.81 
    Pointer pages: 17, data page slots: 27416 
    Data pages: 24968, average fill: 48% 
    Primary pages: 24968, secondary pages: 0, swept pages: 2865 
    Empty pages: 2925, full pages: 17270 
    Fill distribution: 
     0 - 19% = 4527 
    20 - 39% = 2988 
    40 - 59% = 7446 
    60 - 79% = 9436 
    80 - 99% = 571 
 
    Index XQD_2100_3300_WA_SO_RO_WKR_SND (0) 
    Root page: 1479229, depth: 3, leaf buckets: 1155, nodes: 824257 
    Average node length: 5.94, total dup: 759751, max dup: 82 
    Average key length: 3.00, compression ratio: 14.00 
    Average prefix length: 41.08, average data length: 0.92 
    Clustering factor: 121211, ratio: 0.15 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 218 
        40 - 59% = 573 
        60 - 79% = 334 
        80 - 99% = 30 
 
XQD_3300_3400 (181) 
    Primary pointer page: 587, Index root page: 588 
    Total formats: 1, used formats: 1 
    Average record length: 64.64, total records: 9323840 
    Average version length: 68.95, total versions: 652529, 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: 87, data page slots: 141360 
    Data pages: 141336, average fill: 71% 
    Primary pages: 141325, secondary pages: 11, swept pages: 25916 
    Empty pages: 442, full pages: 99263 
    Fill distribution: 
     0 - 19% = 911 
    20 - 39% = 2404 
    40 - 59% = 12164 
    60 - 79% = 120416 
    80 - 99% = 5441 
 
    Index XQD_3300_3400_WA_SO_RO_WKR_SND (0) 
    Root page: 1472612, depth: 3, leaf buckets: 13441, nodes: 9314333 
    Average node length: 6.66, total dup: 7730338, max dup: 23 
    Average key length: 3.66, compression ratio: 11.47 
    Average prefix length: 40.51, average data length: 1.49 
    Clustering factor: 2132247, ratio: 0.23 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 1154 
        40 - 59% = 6707 
        60 - 79% = 4856 
        80 - 99% = 723 
 
XQS_1000_1200 (182) 
    Primary pointer page: 589, Index root page: 590 
    Total formats: 1, used formats: 1 
    Average record length: 82.47, total records: 21081032 
    Average version length: 82.77, total versions: 18751, 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: 318584 
    Data pages: 318584, average fill: 81% 
    Primary pages: 318580, secondary pages: 4, swept pages: 11534 
    Empty pages: 22, full pages: 318285 
    Fill distribution: 
     0 - 19% = 29 
    20 - 39% = 15 
    40 - 59% = 46 
    60 - 79% = 47160 
    80 - 99% = 271334 
 
    Index XQS_1000_1200_DOC_ID (1) 
    Root page: 1426738, depth: 3, leaf buckets: 19089, nodes: 21081032 
    Average node length: 5.72, total dup: 20601501, max dup: 144 
    Average key length: 2.16, compression ratio: 4.16 
    Average prefix length: 8.86, average data length: 0.14 
    Clustering factor: 3274202, ratio: 0.16 
    Fill distribution: 
         0 - 19% = 6 
        20 - 39% = 0 
        40 - 59% = 7683 
        60 - 79% = 526 
        80 - 99% = 10874 
 
    Index XQS_1000_1200_RCV_ID (3) 
    Root page: 1457002, depth: 3, leaf buckets: 17069, nodes: 21081032 
    Average node length: 6.31, total dup: 18526224, max dup: 49 
    Average key length: 2.75, compression ratio: 3.27 
    Average prefix length: 8.37, average data length: 0.63 
    Clustering factor: 915408, ratio: 0.04 
    Fill distribution: 
         0 - 19% = 5 
        20 - 39% = 5 
        40 - 59% = 700 
        60 - 79% = 262 
        80 - 99% = 16097 
 
    Index XQS_1000_1200_SND_ID (2) 
    Root page: 1441095, depth: 3, leaf buckets: 20856, nodes: 21081032 
    Average node length: 6.34, total dup: 18445268, max dup: 29 
    Average key length: 2.79, compression ratio: 3.23 
    Average prefix length: 8.34, average data length: 0.66 
    Clustering factor: 3566730, ratio: 0.17 
    Fill distribution: 
         0 - 19% = 3 
        20 - 39% = 0 
        40 - 59% = 7950 
        60 - 79% = 564 
        80 - 99% = 12339 
 
    Index XQS_1000_1200_WORKER_ID (0) 
    Root page: 1413370, depth: 3, leaf buckets: 16040, nodes: 21081032 
    Average node length: 5.56, total dup: 21080932, max dup: 230833 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.42, average data length: 0.00 
    Clustering factor: 944027, ratio: 0.04 
    Fill distribution: 
         0 - 19% = 4 
        20 - 39% = 6 
        40 - 59% = 2886 
        60 - 79% = 351 
        80 - 99% = 12793 
 
XQS_1000_3300 (184) 
    Primary pointer page: 593, Index root page: 594 
    Total formats: 1, used formats: 1 
    Average record length: 77.50, total records: 9762488 
    Average version length: 82.57, total versions: 652534, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.63 
    Pointer pages: 103, data page slots: 166576 
    Data pages: 166536, average fill: 73% 
    Primary pages: 166513, secondary pages: 23, swept pages: 46564 
    Empty pages: 571, full pages: 116804 
    Fill distribution: 
     0 - 19% = 1279 
    20 - 39% = 3596 
    40 - 59% = 14581 
    60 - 79% = 117222 
    80 - 99% = 29858 
 
    Index XQS_1000_3300_DOC_ID (1) 
    Root page: 1367524, depth: 3, leaf buckets: 11299, nodes: 9762488 
    Average node length: 5.36, total dup: 9454840, max dup: 194 
    Average key length: 2.23, compression ratio: 4.04 
    Average prefix length: 8.80, average data length: 0.20 
    Clustering factor: 2212915, ratio: 0.23 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 31 
        40 - 59% = 7880 
        60 - 79% = 3295 
        80 - 99% = 92 
 
    Index XQS_1000_3300_RCV_ID (3) 
    Root page: 1379283, depth: 3, leaf buckets: 13298, nodes: 9762488 
    Average node length: 6.23, total dup: 8096995, max dup: 14 
    Average key length: 3.10, compression ratio: 2.91 
    Average prefix length: 8.07, average data length: 0.93 
    Clustering factor: 1569959, ratio: 0.16 
    Fill distribution: 
         0 - 19% = 147 
        20 - 39% = 3434 
        40 - 59% = 4436 
        60 - 79% = 2702 
        80 - 99% = 2579 
 
    Index XQS_1000_3300_SND_ID (2) 
    Root page: 1373081, depth: 3, leaf buckets: 12616, nodes: 9762488 
    Average node length: 5.97, total dup: 8478855, max dup: 44 
    Average key length: 2.84, compression ratio: 3.16 
    Average prefix length: 8.29, average data length: 0.71 
    Clustering factor: 2407449, ratio: 0.25 
    Fill distribution: 
         0 - 19% = 3 
        20 - 39% = 40 
        40 - 59% = 8928 
        60 - 79% = 3526 
        80 - 99% = 119 
 
    Index XQS_1000_3300_WORKER_ID (0) 
    Root page: 1362789, depth: 3, leaf buckets: 9905, nodes: 9762488 
    Average node length: 5.13, total dup: 9762388, max dup: 147800 
    Average key length: 2.00, compression ratio: 1.20 
    Average prefix length: 2.40, average data length: 0.00 
    Clustering factor: 1572068, ratio: 0.16 
    Fill distribution: 
         0 - 19% = 43 
        20 - 39% = 1033 
        40 - 59% = 4721 
        60 - 79% = 1801 
        80 - 99% = 2307 
 
XQS_1200_2000 (183) 
    Primary pointer page: 591, Index root page: 592 
    Total formats: 1, used formats: 1 
    Average record length: 78.98, total records: 11344209 
    Average version length: 82.47, total versions: 512984, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.60 
    Pointer pages: 116, data page slots: 188296 
    Data pages: 186848, average fill: 75% 
    Primary pages: 186739, secondary pages: 109, swept pages: 50467 
    Empty pages: 1552, full pages: 155616 
    Fill distribution: 
     0 - 19% = 2685 
    20 - 39% = 4397 
    40 - 59% = 11139 
    60 - 79% = 97192 
    80 - 99% = 71435 
 
    Index XQS_1200_2000_DOC_ID (1) 
    Root page: 1392123, depth: 3, leaf buckets: 13106, nodes: 11344209 
    Average node length: 5.31, total dup: 11234543, max dup: 693 
    Average key length: 2.08, compression ratio: 4.33 
    Average prefix length: 8.93, average data length: 0.07 
    Clustering factor: 2372956, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 121 
        40 - 59% = 8963 
        60 - 79% = 3845 
        80 - 99% = 176 
 
    Index XQS_1200_2000_RCV_ID (3) 
    Root page: 1406132, depth: 3, leaf buckets: 10375, nodes: 11344209 
    Average node length: 5.50, total dup: 10849084, max dup: 49 
    Average key length: 2.28, compression ratio: 3.95 
    Average prefix length: 8.77, average data length: 0.23 
    Clustering factor: 724244, ratio: 0.06 
    Fill distribution: 
         0 - 19% = 158 
        20 - 39% = 818 
        40 - 59% = 2463 
        60 - 79% = 1750 
        80 - 99% = 5186 
 
    Index XQS_1200_2000_SND_ID (2) 
    Root page: 1398660, depth: 3, leaf buckets: 14990, nodes: 11344209 
    Average node length: 6.03, total dup: 9901828, max dup: 80 
    Average key length: 2.80, compression ratio: 3.21 
    Average prefix length: 8.32, average data length: 0.68 
    Clustering factor: 2389444, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 4 
        20 - 39% = 157 
        40 - 59% = 10466 
        60 - 79% = 4152 
        80 - 99% = 211 
 
    Index XQS_1200_2000_WORKER_ID (0) 
    Root page: 1386233, depth: 3, leaf buckets: 10632, nodes: 11344209 
    Average node length: 5.23, total dup: 11344109, max dup: 180092 
    Average key length: 2.00, compression ratio: 1.20 
    Average prefix length: 2.40, average data length: 0.00 
    Clustering factor: 711192, ratio: 0.06 
    Fill distribution: 
         0 - 19% = 87 
        20 - 39% = 797 
        40 - 59% = 4555 
        60 - 79% = 1408 
        80 - 99% = 3785 
 
XQS_2000_3300 (185) 
    Primary pointer page: 595, Index root page: 596 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index XQS_2000_3300_DOC_ID (1) 
    Root page: 1361775, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index XQS_2000_3300_RCV_ID (3) 
    Root page: 1361777, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index XQS_2000_3300_SND_ID (2) 
    Root page: 1361776, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index XQS_2000_3300_WORKER_ID (0) 
    Root page: 1361774, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
XQS_2100_3300 (186) 
    Primary pointer page: 597, Index root page: 598 
    Total formats: 1, used formats: 1 
    Average record length: 77.80, total records: 9884379 
    Average version length: 82.90, total versions: 660519, 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: 103, data page slots: 166840 
    Data pages: 166760, average fill: 74% 
    Primary pages: 166738, secondary pages: 22, swept pages: 45308 
    Empty pages: 435, full pages: 117656 
    Fill distribution: 
     0 - 19% = 957 
    20 - 39% = 2171 
    40 - 59% = 10880 
    60 - 79% = 122597 
    80 - 99% = 30155 
 
    Index XQS_2100_3300_DOC_ID (1) 
    Root page: 1344708, depth: 3, leaf buckets: 11856, nodes: 9884379 
    Average node length: 5.18, total dup: 9855623, max dup: 1629 
    Average key length: 2.03, compression ratio: 4.43 
    Average prefix length: 8.97, average data length: 0.03 
    Clustering factor: 2050631, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 44 
        20 - 39% = 1391 
        40 - 59% = 7871 
        60 - 79% = 1922 
        80 - 99% = 628 
 
    Index XQS_2100_3300_RCV_ID (3) 
    Root page: 1355739, depth: 3, leaf buckets: 13460, nodes: 9884379 
    Average node length: 6.25, total dup: 8197397, max dup: 14 
    Average key length: 3.10, compression ratio: 2.90 
    Average prefix length: 8.07, average data length: 0.93 
    Clustering factor: 1575639, ratio: 0.16 
    Fill distribution: 
         0 - 19% = 164 
        20 - 39% = 3447 
        40 - 59% = 4494 
        60 - 79% = 2631 
        80 - 99% = 2724 
 
    Index XQS_2100_3300_SND_ID (2) 
    Root page: 1350071, depth: 3, leaf buckets: 12459, nodes: 9884379 
    Average node length: 5.44, total dup: 9444272, max dup: 99 
    Average key length: 2.29, compression ratio: 3.94 
    Average prefix length: 8.76, average data length: 0.24 
    Clustering factor: 2185546, ratio: 0.22 
    Fill distribution: 
         0 - 19% = 37 
        20 - 39% = 1290 
        40 - 59% = 8813 
        60 - 79% = 1709 
        80 - 99% = 610 
 
    Index XQS_2100_3300_WORKER_ID (0) 
    Root page: 987843, depth: 3, leaf buckets: 10080, nodes: 9884379 
    Average node length: 5.15, total dup: 9884279, max dup: 150188 
    Average key length: 2.00, compression ratio: 1.20 
    Average prefix length: 2.40, average data length: 0.00 
    Clustering factor: 1621447, ratio: 0.16 
    Fill distribution: 
         0 - 19% = 49 
        20 - 39% = 1041 
        40 - 59% = 4816 
        60 - 79% = 1848 
        80 - 99% = 2326 
 
XQS_3300_3400 (187) 
    Primary pointer page: 599, Index root page: 600 
    Total formats: 1, used formats: 1 
    Average record length: 67.09, total records: 572350 
    Average version length: 68.78, total versions: 10294, 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: 7968 
    Data pages: 7968, average fill: 75% 
    Primary pages: 7968, secondary pages: 0, swept pages: 2845 
    Empty pages: 5, full pages: 7370 
    Fill distribution: 
     0 - 19% = 5 
    20 - 39% = 3 
    40 - 59% = 58 
    60 - 79% = 7720 
    80 - 99% = 182 
 
    Index XQS_3300_3400_DOC_ID (1) 
    Root page: 32406, depth: 3, leaf buckets: 727, nodes: 572350 
    Average node length: 5.94, total dup: 487452, max dup: 83 
    Average key length: 3.09, compression ratio: 2.91 
    Average prefix length: 8.06, average data length: 0.94 
    Clustering factor: 100943, ratio: 0.18 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 22 
        40 - 59% = 523 
        60 - 79% = 87 
        80 - 99% = 95 
 
    Index XQS_3300_3400_SND_ID (2) 
    Root page: 26248, depth: 3, leaf buckets: 745, nodes: 572350 
    Average node length: 6.15, total dup: 469598, max dup: 19 
    Average key length: 3.29, compression ratio: 2.73 
    Average prefix length: 7.89, average data length: 1.11 
    Clustering factor: 100994, ratio: 0.18 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 23 
        40 - 59% = 525 
        60 - 79% = 91 
        80 - 99% = 106 
 
    Index XQS_3300_3400_WORKER_ID (0) 
    Root page: 377587, depth: 2, leaf buckets: 553, nodes: 572350 
    Average node length: 4.86, total dup: 572250, max dup: 9661 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.41, average data length: 0.00 
    Clustering factor: 89607, ratio: 0.16 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 31 
        40 - 59% = 307 
        60 - 79% = 86 
        80 - 99% = 129 
 
ZDOC_DATA (170) 
    Primary pointer page: 565, Index root page: 566 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
ZDOC_LIST (169) 
    Primary pointer page: 563, Index root page: 564 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
ZINVNT_TURNOVER_LOG (171) 
    Primary pointer page: 567, Index root page: 568 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
ZPDISTR (174) 
    Primary pointer page: 573, Index root page: 574 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index ZPDISTR_ID (0) 
    Root page: 1504230, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
ZPSTORNED (175) 
    Primary pointer page: 575, Index root page: 576 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index ZPSTORNED_ID (0) 
    Root page: 1504229, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
ZQDISTR (172) 
    Primary pointer page: 569, Index root page: 570 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index ZQDISTR_ID (0) 
    Root page: 1504235, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index ZQDISTR_WARE_SNDOP_RCVOP (1) 
    Root page: 1504236, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
ZQSTORNED (173) 
    Primary pointer page: 571, Index root page: 572 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index ZQSTORNED_DOC_ID (1) 
    Root page: 1504232, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index ZQSTORNED_ID (0) 
    Root page: 1504231, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index ZQSTORNED_RCV_ID (3) 
    Root page: 1504234, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index ZQSTORNED_SND_ID (2) 
    Root page: 1504233, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
ZTMP_DEP_DOCS (168) 
    Primary pointer page: 561, Index root page: 562 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
ZTMP_SHOPPING_CART (167) 
    Primary pointer page: 559, Index root page: 560 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
Z_USED_VIEWS (144) 
    Primary pointer page: 512, Index root page: 513 
    Total formats: 1, used formats: 1 
    Average record length: 29.38, total records: 29 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 99.00, compression ratio: 3.37 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 16% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index Z_USED_VIEWS_UNQ (0) 
    Root page: 1510372, depth: 1, leaf buckets: 1, nodes: 29 
    Average node length: 15.17, total dup: 0, max dup: 0 
    Average key length: 14.14, compression ratio: 1.44 
    Average prefix length: 9.17, average data length: 11.17 
    Clustering factor: 1, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
Gstat completion time Thu Mar  7 04:09:31 2024

Record versions statistics, table

TABLE_NAME TOTAL_RECS TOTAL_VERS MAX_VERSIONS VERS_TO_RECS_PRC MAXV_TO_VERS_PRC
DOC_DATA 7771032 143445 1 0.0000 0.0000
DOC_LIST 2259685 74396 2 0.0000 0.0000
FB_ERRORS 2182 757 1 0.0000 0.0000
INVNT_SALDO 400 2394 6 500.0000 0.0000
INVNT_TURNOVER_LOG 139789 88153 1 0.0000 0.0000
MONEY_SALDO 49 221 8 400.0000 0.0000
MONEY_TURNOVER_LOG 2361 1468 1 0.0000 0.0000
PDISTR 834066 37882 3 0.0000 0.0000
PERF_SPLIT_0 144398 5880 1 0.0000 0.0000
PERF_SPLIT_1 138012 12326 1 0.0000 0.0000
PERF_SPLIT_2 148762 14001 1 0.0000 0.0000
PERF_SPLIT_3 145939 9358 1 0.0000 0.0000
PERF_SPLIT_4 212902 67569 1 0.0000 0.0000
PERF_SPLIT_5 176253 27518 1 0.0000 0.0000
PERF_SPLIT_6 170494 42165 1 0.0000 0.0000
PERF_SPLIT_7 168362 30066 1 0.0000 0.0000
PERF_SPLIT_8 186113 43777 1 0.0000 0.0000
PERF_SPLIT_9 178329 42872 1 0.0000 0.0000
PSTORNED 2116763 67530 1 0.0000 0.0000
SEMAPHORES 5 1 1 0.0000 100.0000
XQD_1000_1200 166382 76172 1 0.0000 0.0000
XQD_1000_3300 7269597 515058 1 0.0000 0.0000
XQD_1200_2000 12264768 451277 1 0.0000 0.0000
XQD_2000_3300 1908520 500879 1 0.0000 0.0000
XQD_2100_3300 1583831 189094 1 0.0000 0.0000
XQD_3300_3400 9323840 652529 1 0.0000 0.0000
XQS_1000_1200 21081032 18751 1 0.0000 0.0000
XQS_1000_3300 9762488 652534 1 0.0000 0.0000
XQS_1200_2000 11344209 512984 1 0.0000 0.0000
XQS_2100_3300 9884379 660519 1 0.0000 0.0000
XQS_3300_3400 572350 10294 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 ---
:257: 
:258: mscs-test-161.budzdorov.ru    Thu Mar  7 04:07:59 2024
:259:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3400
:260: 
--- end of diff output ---

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

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