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

Hardware and OS info

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

Server and database settinfs 


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

Test configuration settings 

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

Test finish info 


FINISH_STATE                    NORMAL: TEST_TIME EXPIRED AT 2024-04-10 13:07:54
DTS_END                         2024-04-10 13:07:53.9740
FB_GDSCODE                      -1
FB_MNEMONA                      
STACK                           SP_RESERVE_WRITE_OFF(34:5) ==> SP_CHECK_TO_STOP_WORK(32:12) ==> SP_HALT_ON_ERROR(68:17)
IP                              ::1/49936
TRN_ID                          171329
ATT_ID                          488
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: 9205.74 21666 920574
customer order: creation 177.63 352 17763
customer order: refuse 14.69 345 1469
order to supplier: creation 48.28 1227 4828
order to supplier: removal 3.85 70974 385
invoice (draft): creation 47.21 2703 4721
invoice (draft): removal 49.52 614 4952
invoice accept: apply 42.86 22331 4286
invoice accept: cancel 44.97 704 4497
customer reserve: creation 4116.34 217 411634
customer reserve: removal 4364.54 50 436454
realization accept: apply 85.31 180 8531
realization accept: cancel 79.39 120 7939
payment from customer: creation 60.40 105 6040
payment from customer: removal 5.82 75 582
payment to supplier: creation 50.30 136 5030
payment to supplier: removal 3.45 105 345
service: total inventory turnovers 3.65 4075 365
service: total monetary turnovers 6.58 579 658
service: aggregate perf. data 0.92 16089 92
service: refresh index statistics 0.03 312339 3

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:03, from 10-04-2024 13:09:23 to 10-04-2024 13:09:26.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 4882
TEST_TIME 2 5601
TEST_TIME 3 5372
TEST_TIME 4 5496
TEST_TIME 5 6157
TEST_TIME 6 5970
TEST_TIME 7 6333
TEST_TIME 8 6149
TEST_TIME 9 5915
TEST_TIME 10 6131
TEST_TIME 11 6285
TEST_TIME 12 6448
TEST_TIME 13 6807
TEST_TIME 14 6664
TEST_TIME 15 7413
TEST_TIME 16 7595
TEST_TIME 17 7845
TEST_TIME 18 7961
TEST_TIME 19 7985
TEST_TIME 20 8134
TEST_TIME 21 8459
TEST_TIME 22 9023
TEST_TIME 23 9007
TEST_TIME 24 9176
TEST_TIME 25 9852
TEST_TIME 26 9703
TEST_TIME 27 9445
TEST_TIME 28 9255
TEST_TIME 29 9090
TEST_TIME 30 9090
TEST_TIME 31 9141
TEST_TIME 32 9266
TEST_TIME 33 9136
TEST_TIME 34 9206
TEST_TIME 35 9288
TEST_TIME 36 9095
TEST_TIME 37 8985
TEST_TIME 38 8840
TEST_TIME 39 8793
TEST_TIME 40 9022
TEST_TIME 41 9118
TEST_TIME 42 8984
TEST_TIME 43 8944
TEST_TIME 44 8993
TEST_TIME 45 8951
TEST_TIME 46 8914
TEST_TIME 47 9006
TEST_TIME 48 9059
TEST_TIME 49 9208
TEST_TIME 50 9243
TEST_TIME 51 9315
TEST_TIME 52 9296
TEST_TIME 53 9290
TEST_TIME 54 9315
TEST_TIME 55 9412
TEST_TIME 56 9379
TEST_TIME 57 9425
TEST_TIME 58 9561
TEST_TIME 59 9401
TEST_TIME 60 9378
TEST_TIME 61 9281
TEST_TIME 62 9276
TEST_TIME 63 9343
TEST_TIME 64 9269
TEST_TIME 65 9215
TEST_TIME 66 9114
TEST_TIME 67 9071
TEST_TIME 68 9159
TEST_TIME 69 9158
TEST_TIME 70 9174
TEST_TIME 71 9163
TEST_TIME 72 9137
TEST_TIME 73 9197
TEST_TIME 74 9248
TEST_TIME 75 9313
TEST_TIME 76 9295
TEST_TIME 77 9344
TEST_TIME 78 9350
TEST_TIME 79 9367
TEST_TIME 80 9280
TEST_TIME 81 9189
TEST_TIME 82 9191
TEST_TIME 83 9184
TEST_TIME 84 9113
TEST_TIME 85 9177
TEST_TIME 86 9188
TEST_TIME 87 9147
TEST_TIME 88 9146
TEST_TIME 89 9162
TEST_TIME 90 9178
TEST_TIME 91 9200
TEST_TIME 92 9186
TEST_TIME 93 9230
TEST_TIME 94 9263
TEST_TIME 95 9259
TEST_TIME 96 9316
TEST_TIME 97 9288
TEST_TIME 98 9348
TEST_TIME 99 9288
TEST_TIME 100 9211
TEST_TIME 101 9119

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:03, from 10-04-2024 13:09:27 to 10-04-2024 13:09:30.

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 1297770 1297770 0 0.00 0 17410 8 0 0
doc_list_biud 1297769 1297769 0 0.00 0 75697 21 0 0
sp_add_invoice_to_stock 4407 4286 121 2.74 36 176764 22332 0 121
sp_cancel_adding_invoice 4497 4497 0 0.00 4 57809 704 0 0
sp_cancel_client_order 1469 1469 0 0.00 4 11056 345 0 0
sp_cancel_customer_reserve 436454 436454 0 0.00 0 31742 51 0 0
sp_cancel_pay_from_customer 582 582 0 0.00 2 2463 75 0 0
sp_cancel_pay_to_supplier 345 345 0 0.00 2 7147 106 0 0
sp_cancel_supplier_invoice 4965 4952 13 0.26 1 75699 615 0 13
sp_cancel_supplier_order 385 385 0 0.00 5 751013 70974 0 0
sp_cancel_write_off 7939 7939 0 0.00 1 10958 121 0 0
sp_client_order 17763 17763 0 0.00 3 31599 353 0 0
sp_customer_reserve 411634 411634 0 0.00 0 76774 217 0 0
sp_fill_shopping_cart 27295 27295 0 0.00 1 9442 32 0 0
sp_fill_shopping_cart_clo_res 411630 411630 0 0.00 0 15963 15 0 0
sp_get_clo_for_invoice 4279 4279 0 0.00 0 31356 365 0 0
sp_kill_cost_storno 13363 13363 0 0.00 0 10446 53 0 0
sp_kill_qstorno_ret_qs2qd 886184 886184 0 0.00 0 75695 27 0 0
sp_kill_qty_storno 468505 468505 0 0.00 0 75695 59 0 0
sp_lock_selected_doc 17669 17669 0 0.00 0 8576 6 0 0
sp_make_cost_storno 23880 23880 0 0.00 0 17400 61 0 0
sp_multiply_rows_for_pdistr 23880 23880 0 0.00 0 11582 35 0 0
sp_multiply_rows_for_qdistr 17763 17763 0 0.00 0 31593 181 0 0
sp_pay_from_customer 6040 6040 0 0.00 4 11530 106 0 0
sp_pay_to_supplier 5030 5030 0 0.00 4 10347 136 0 0
sp_payment_common 11070 11070 0 0.00 1 6748 17 0 0
sp_qd_handle_on_cancel_clo 1469 1469 0 0.00 0 11049 312 0 0
sp_qd_handle_on_invoice_upd_sts 8775 8775 0 0.00 0 15410 237 0 0
sp_qd_handle_on_reserve_upd_sts 8531 8531 0 0.00 0 16720 47 0 0
sp_reserve_write_off 8531 8531 0 0.00 6 16756 180 0 0
sp_supplier_invoice 4721 4721 0 0.00 5 68324 2703 0 0
sp_supplier_order 4828 4828 0 0.00 5 32696 1227 0 0
srv_aggregate_perf_data 93 92 1 1.07 1998 200645 16090 0 1
srv_fill_mon_cache_memory 55 55 0 0.00 2193 116914 41616 0 0
srv_find_qd_qs_mism 877147 877147 0 0.00 0 16805 8 0 0
srv_make_invnt_saldo 365 365 0 0.00 21 129180 4075 0 0
srv_make_money_saldo 658 658 0 0.00 1 28548 579 0 0
srv_recalc_idx_stat 3 3 0 0.00 197853 369804 312339 0 0
t$perf-abend:sp_add_invoice_to_stock 121 121 0 0.00 0 0 0 0 0
t$perf-abend:sp_cancel_supplier_invoice 13 13 0 0.00 0 0 0 0 0
t$perf-abend:srv_aggregate_perf_data 1 1 0 0.00 0 0 0 0 0
t$perf-norm:sp_add_invoice_to_stock 4286 4286 0 0.00 0 12659 173 0 0
t$perf-norm:sp_cancel_adding_invoice 366 366 0 0.00 0 2619 106 0 0
t$perf-norm:sp_cancel_client_order 1469 1469 0 0.00 0 915 11 0 0
t$perf-norm:sp_cancel_customer_reserve 568 568 0 0.00 0 737 10 0 0
t$perf-norm:sp_cancel_pay_from_customer 582 582 0 0.00 0 2378 8 0 0
t$perf-norm:sp_cancel_pay_to_supplier 345 345 0 0.00 0 2201 15 0 0
t$perf-norm:sp_cancel_supplier_invoice 318 318 0 0.00 0 912 13 0 0
t$perf-norm:sp_cancel_supplier_order 385 385 0 0.00 0 21895 1362 0 0
t$perf-norm:sp_cancel_write_off 827 827 0 0.00 0 1757 7 0 0
t$perf-norm:sp_client_order 17763 17763 0 0.00 0 7886 14 0 0
t$perf-norm:sp_customer_reserve 880 880 0 0.00 0 1140 4 0 0
t$perf-norm:sp_pay_from_customer 6040 6040 0 0.00 0 16783 15 0 0
t$perf-norm:sp_pay_to_supplier 5030 5030 0 0.00 0 9001 10 0 0
t$perf-norm:sp_reserve_write_off 8531 8531 0 0.00 0 8707 12 0 0
t$perf-norm:sp_supplier_invoice 4721 4721 0 0.00 0 7369 19 0 0
t$perf-norm:sp_supplier_order 4828 4828 0 0.00 0 3935 13 0 0
t$perf-norm:srv_aggregate_perf_data 92 92 0 0.00 0 279 6 0 0
t$perf-norm:srv_fill_mon_cache_memory 55 55 0 0.00 0 279 9 0 0
t$perf-norm:srv_make_invnt_saldo 365 365 0 0.00 0 263 4 0 0
t$perf-norm:srv_make_money_saldo 658 658 0 0.00 0 240 3 0 0
t$perf-norm:srv_recalc_idx_stat 3 3 0 0.00 2 9 5 0 0
v_add_invoice_to_stock 8798 8556 242 2.75 0 11130 16 0 242
v_all_customers 32506 32506 0 0.00 0 114 0 0 0
v_all_suppliers 27066 27066 0 0.00 0 16 1 0 0
v_all_wares 35524 35524 0 0.00 0 18 1 0 0
v_cancel_adding_invoice 732 732 0 0.00 0 1037 9 0 0
v_cancel_client_order 2938 2938 0 0.00 0 5301 5 0 0
v_cancel_customer_prepayment 1164 1164 0 0.00 0 2447 7 0 0
v_cancel_customer_reserve 1136 1136 0 0.00 0 2307 10 0 0
v_cancel_payment_to_supplier 690 690 0 0.00 0 7141 15 0 0
v_cancel_supplier_invoice 662 636 26 3.92 0 8466 27 0 26
v_cancel_supplier_order 770 770 0 0.00 0 810 5 0 0
v_cancel_write_off 1654 1654 0 0.00 0 3999 21 0 0
v_max_id_clo_ord 4823 4823 0 0.00 0 1392 1 0 0
v_max_id_clo_res 880 880 0 0.00 0 2958 14 0 0
v_max_id_ord_sup 4710 4710 0 0.00 0 5318 6 0 0
v_max_non_paid_invoice 1030 1030 0 0.00 0 1560 4 0 0
v_max_non_paid_realizn 3087 3087 0 0.00 0 4112 6 0 0
v_min_id_clo_ord 4823 4823 0 0.00 0 4957 10 0 0
v_min_id_clo_res 880 880 0 0.00 0 8530 20 0 0
v_min_id_ord_sup 4710 4710 0 0.00 0 3492 6 0 0
v_min_non_paid_invoice 5030 5030 0 0.00 0 6744 11 0 0
v_min_non_paid_realizn 6040 6040 0 0.00 0 5305 11 0 0
v_our_firm 8924 8924 0 0.00 0 122 1 0 0
v_reserve_write_off 17062 17062 0 0.00 0 5961 6 0 0
x_lock_depdocs_on_canc_invoice 9131 9131 0 0.00 0 16364 109 0 0
x_lock_depdocs_on_canc_sup_ord 385 385 0 0.00 0 5922 299 0 0
x_make_qstorno_1000_1200 4828 4828 0 0.00 1 32691 1153 0 0
x_make_qstorno_1200_2000 4721 4721 0 0.00 3 65444 2591 0 0
x_make_qstorno_2100_3300 411634 411634 0 0.00 0 76731 200 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 10-04-2024 13:09:31 to 10-04-2024 13:09:35.

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
11:07:57 950 8192000000 8956910736 9021644800 13625136 0.166 4 2 4 0 13847920 151296 71488
11:09:00 41282 8192000000 9713499040 10013679616 791102688 8.806 100 88 176 0 819444304 7484832 20856784
11:10:44 8736 8192000000 9747548624 10053722112 821237248 9.111 100 96 192 0 856754080 12940224 22576608
11:11:55 7800 8192000000 9776210928 10092986368 847775808 9.378 100 89 178 0 886094704 18145040 20173856
11:13:07 8168 8192000000 9842623696 10174255104 888157152 9.781 100 79 155 0 950617616 45902640 16557824
11:14:21 7873 8192000000 9884147312 10225123328 922847136 10.124 100 83 164 0 993747808 53426176 17474496
11:15:35 8573 8192000000 9919928992 10273345536 964117984 10.529 100 74 148 1 1034048944 55391152 14539808
11:16:46 4354 8192000000 9993865504 10351083520 997715472 10.856 100 85 169 0 1103569200 88993760 16859968
11:17:52 2753 8192000000 9980249024 10346553344 1020712752 11.079 100 83 164 0 1089518976 52742400 16063824
11:18:58 2186 8192000000 10008535328 10383425536 1043352048 11.297 100 80 161 0 1123431520 64470144 15609328
11:20:02 1610 8192000000 10047468176 10421649408 1053390688 11.393 100 85 171 2 1152989328 82503984 17094656
11:21:05 11466 8192000000 9982100608 10372878336 1064055056 11.495 100 45 88 0 1107773200 33709008 10009136
11:22:20 5713 8192000000 10006787952 10408247296 1065196560 11.506 100 41 82 0 1123219008 50250064 7772384
11:23:27 4791 8192000000 9993066736 10388213760 1075258624 11.602 100 37 73 0 1105986464 22822800 7905040
11:24:33 5567 8192000000 10008220992 10409787392 1082418192 11.671 100 39 78 1 1123587984 33379776 7790016
11:25:41 36901 8192000000 10005697872 10416869376 1089826048 11.741 100 49 96 1 1117212496 17667904 9718544
11:27:35 5369 8192000000 9995441648 10411880448 1091103520 11.753 100 30 60 0 1122664512 25441504 6119488
11:28:50 3971 8192000000 10040302720 10438717440 1101512768 11.852 100 61 123 0 1150311888 35871024 12928096
11:29:57 78124 8192000000 10049454352 10472128512 1107053248 11.905 100 45 89 0 1168578224 51496320 10028656
11:32:20 13163 8192000000 10074634320 10486833152 1110016864 11.933 99 56 109 0 1179582848 58422560 11143424
11:33:38 31522 8192000000 10085386160 10484215808 1047949104 11.341 95 55 109 0 1149276528 89919744 11407680
11:35:14 15782 8192000000 10073722144 10468491264 1067601376 11.529 98 48 95 0 1164363904 86895616 9866912
11:36:39 19240 8192000000 10130010752 10529710080 1081370368 11.661 98 53 104 0 1230133024 138243440 10519216
11:38:02 19045 8192000000 10113455808 10515714048 1078519648 11.633 98 46 92 1 1212799664 124581504 9698512
11:39:33 4527 8192000000 10137284992 10529374208 1099022352 11.828 100 57 109 1 1237512944 126828768 11661824
11:40:41 8340 8192000000 10149617552 10542923776 1086005072 11.705 98 50 100 0 1250637632 153790464 10842096
11:41:55 4790 8192000000 10198668560 10591227904 1098429728 11.823 100 69 136 1 1304749632 191158624 15161280
11:43:04 2225 8192000000 10181539056 10572296192 1096141584 11.801 100 64 127 0 1287725136 178377296 13206256
11:44:10 2193 8192000000 10209702224 10596610048 1095256784 11.793 100 79 153 3 1306726912 196030304 15439824
11:45:21 15034 8192000000 10220717744 10624106496 1106940192 11.903 100 64 127 0 1324009104 203060608 14008304
11:46:41 10196 8192000000 10197084064 10608250880 1107117776 11.905 100 47 92 1 1295400464 177467360 10815328
11:47:59 7149 8192000000 10224856000 10663215104 1108098880 11.914 100 40 79 0 1344718928 228060448 8559600
11:49:09 12814 8192000000 10141248272 10591293440 1102847824 11.865 99 24 48 0 1254037456 145994768 5194864
11:50:24 27092 8192000000 10154370848 10609733632 1099199152 11.830 98 18 36 0 1260165792 156960448 4006192
11:51:54 55932 8192000000 10044247328 10537181184 1115378560 11.983 100 11 22 0 1281082032 163115296 2588176
11:53:52 26301 8192000000 10092592320 10515390464 1133760880 12.157 100 37 72 1 1190434976 48914992 7759104
11:55:24 54378 8192000000 10117355696 10551824384 1122178048 12.048 99 39 75 2 1217231936 87086912 7966976
11:57:43 39439 8192000000 10106250576 10597244928 1135878624 12.177 100 18 36 0 1252714080 113170736 3664720
11:59:25 25607 8192000000 10115405328 10584932352 1140089840 12.216 100 17 34 0 1244453952 100926960 3437152
12:01:38 53463 8192000000 10080612480 10552180736 1131214976 12.133 99 26 51 1 1225103968 88232464 5656528
12:03:35 25906 8192000000 10108007600 10537312256 1144369744 12.257 100 33 65 0 1202409952 50373584 7666624
12:05:02 42072 8192000000 10172352352 10615631872 1158056240 12.385 100 42 83 0 1275108560 107916912 9135408
12:06:45 32143 8192000000 10178418928 10658119680 1154447600 12.351 100 16 31 0 1281106560 123180336 3478624
12:08:57 45203 8192000000 10108913616 10555617280 1156862304 12.374 100 23 45 0 1211472128 49225376 5384448
12:10:54 62489 8192000000 10070600496 10553753600 1141486480 12.230 99 9 18 0 1205084528 61792224 1805824
12:12:56 52537 8192000000 10106735264 10548236288 1149965408 12.309 99 29 58 0 1214370880 58545264 5860208
12:14:50 47714 8192000000 10092912528 10550689792 1121718928 12.043 97 32 62 1 1172997440 45424432 5854080
12:16:39 51711 8192000000 10104692864 10584875008 1119192144 12.019 97 15 30 0 1215870192 92788864 3889184
12:18:34 78463 8192000000 10071801728 10502459392 1098344576 11.822 96 24 48 0 1160566624 57495712 4726336
12:20:54 75943 8192000000 10071705296 10525896704 1070558256 11.557 94 33 66 0 1127021312 50260336 6202720
12:23:13 56518 8192000000 10074643072 10496544768 1042711328 11.291 93 24 48 0 1126717408 79035104 4970976
12:25:11 114774 8192000000 10021460832 10442416128 1045132368 11.314 94 16 32 0 1146346656 98178576 3035712
12:28:18 35658 8192000000 10057283824 10485596160 1100842096 11.846 100 40 80 0 1156299616 47888608 7568912
12:29:55 59809 8192000000 10014378160 10499846144 1055097376 11.410 96 18 36 0 1107799744 49103840 3598528
12:31:56 9855 8192000000 9981610208 10407202816 1061049696 11.467 98 41 79 1 1091152832 21286576 8816560
12:33:06 43109 8192000000 10022091120 10450829312 1045828288 11.321 97 17 34 0 1092031952 42945408 3258256
12:36:00 34880 8192000000 10027317680 10452127744 1086260736 11.707 100 14 28 0 1129734912 40701280 2772896
12:37:38 16862 8192000000 10004124592 10420637696 1077440160 11.623 99 31 60 0 1101269536 17954192 5875184
12:39:01 23815 8192000000 10058961232 10487451648 1093749888 11.778 100 33 66 0 1161742128 61450320 6541920
12:40:30 77449 8192000000 10043761216 10462236672 1053146752 11.391 96 28 56 0 1109930208 51548752 5234704
12:42:48 45455 8192000000 10065987984 10483638272 1095509648 11.795 100 31 62 0 1143154912 41823296 5821968
12:44:35 42355 8192000000 10079803584 10534518784 1109026976 11.923 100 35 70 0 1185356224 69877680 6451568
12:46:22 106795 8192000000 10050185008 10480680960 1108928704 11.922 99 33 65 0 1164509232 49465680 6114848
12:49:10 28911 8192000000 10095804128 10539200512 1132282224 12.143 100 28 56 0 1207841648 70203088 5356336
12:50:44 59758 8192000000 10094744016 10551791616 1140886352 12.224 100 8 16 0 1191567840 49227024 1454464
12:53:04 83349 8192000000 10051925392 10500853760 1118941440 12.017 98 9 16 0 1173619088 52893904 1783744
12:55:47 62848 8192000000 10101048192 10564149248 1132929824 12.149 99 25 49 0 1207515120 69548192 5037104
12:58:10 52505 8192000000 10067015568 10493812736 1118579024 12.014 98 21 41 0 1175366960 52617664 4170272
13:00:03 72906 8192000000 10104869680 10579992576 1116927968 11.998 98 29 54 2 1176497472 53964688 5604816
13:02:23 61718 8192000000 10068930992 10521833472 1051340672 11.374 92 18 36 0 1097136480 42188272 3607536
13:04:31 38094 8192000000 10082847024 10497470464 1108625568 11.919 98 29 56 1 1141604720 27330704 5648448
13:06:13 116912 8192000000 9317281200 9630789632 446563760 5.169 40 7 14 0 462339072 14466704 1308608

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:14, from 10-04-2024 13:09:37 to 10-04-2024 13:09:51.

Exceptions occured during test was in run

FB_MNEMONA CNT UNIT FB_GDSCODE
except 1 srv_aggregate_perf_data 335544517
except 121 v_add_invoice_to_stock 335544517
except 13 v_cancel_supplier_invoice 335544517

Completed "Exceptions occured during test was in run". Done for 00:00:02, from 10-04-2024 13:09:52 to 10-04-2024 13:09:54.

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          170886
MON$OLDEST_ACTIVE               171623
MON$OLDEST_SNAPSHOT             171623
MON$NEXT_TRANSACTION            171623
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                       1910240
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             688
MON$NEXT_STATEMENT              53
MON$REPLICA_MODE                0


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

Database statistics 

 
Database "/home/bases/oltp40-etalone.fdb" 
Gstat execution time Wed Apr 10 13:09:55 2024 
 
Database header page information: 
    Flags            0 
    Generation        89634 
    System Change Number    0 
    Page size        8192 
    ODS version        13.0 
    Oldest transaction    170886 
    Oldest active        171623 
    Oldest snapshot        171623 
    Next transaction    171624 
    Sequence number        0 
    Next attachment ID    688 
    Implementation        HW=AMD/Intel/x64 little-endian OS=Linux CC=gcc 
    Shadow count        0 
    Page buffers        0 
    Next header page    0 
    Database dialect    3 
    Creation date        Apr 30, 2020 7:30:08 
    Attributes        force write 
 
    Variable header data: 
    Database GUID:    {58978C10-B735-40F5-8B7D-F7A1956E782B} 
    Sweep interval:        0 
    *END* 
 
 
Database file sequence: 
File /home/bases/oltp40-etalone.fdb is the only file 
 
Analyzing database pages ... 
AGENTS (150) 
    Primary pointer page: 524, Index root page: 525 
    Total formats: 1, used formats: 1 
    Average record length: 33.60, total records: 50 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 344.00, compression ratio: 10.24 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 31% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 1 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index AGENTS_ID_DESC (2) 
    Root page: 1504333, depth: 1, leaf buckets: 1, nodes: 50 
    Average node length: 11.82, total dup: 0, max dup: 0 
    Average key length: 10.80, compression ratio: 0.83 
    Average prefix length: 1.18, average data length: 7.82 
    Clustering factor: 1, ratio: 0.02 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index AGENTS_IS_OUR_FIRM (4) 
    Root page: 1504335, depth: 1, leaf buckets: 1, nodes: 50 
    Average node length: 3.08, total dup: 48, max dup: 48 
    Average key length: 2.04, compression ratio: 0.50 
    Average prefix length: 0.96, average data length: 0.06 
    Clustering factor: 1, ratio: 0.02 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index AGENTS_IS_SUPPLIER (3) 
    Root page: 1504334, depth: 1, leaf buckets: 1, nodes: 50 
    Average node length: 3.08, total dup: 48, max dup: 44 
    Average key length: 2.04, compression ratio: 0.54 
    Average prefix length: 1.04, average data length: 0.06 
    Clustering factor: 1, ratio: 0.02 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index AGENTS_NAME_UNQ (1) 
    Root page: 1504332, depth: 1, leaf buckets: 1, nodes: 50 
    Average node length: 17.20, total dup: 0, max dup: 0 
    Average key length: 15.88, compression ratio: 0.92 
    Average prefix length: 1.42, average data length: 13.20 
    Clustering factor: 1, ratio: 0.02 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PK_AGENTS (0) 
    Root page: 1504331, depth: 1, leaf buckets: 1, nodes: 50 
    Average node length: 11.82, total dup: 0, max dup: 0 
    Average key length: 10.80, compression ratio: 0.83 
    Average prefix length: 1.18, average data length: 7.82 
    Clustering factor: 1, ratio: 0.02 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
BUSINESS_OPS (154) 
    Primary pointer page: 532, Index root page: 533 
    Total formats: 1, used formats: 1 
    Average record length: 108.20, total records: 20 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1235.00, compression ratio: 11.41 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 31% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 1 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index BO_UNIT_UNQ (1) 
    Root page: 1504264, depth: 1, leaf buckets: 1, nodes: 20 
    Average node length: 18.25, total dup: 0, max dup: 0 
    Average key length: 17.20, compression ratio: 1.24 
    Average prefix length: 7.05, average data length: 14.25 
    Clustering factor: 1, ratio: 0.05 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index BUSINESS_OPS_PREDICT_PRIOR (3) 
    Root page: 1504266, depth: 1, leaf buckets: 1, nodes: 20 
    Average node length: 5.40, total dup: 0, max dup: 0 
    Average key length: 4.35, compression ratio: 0.67 
    Average prefix length: 1.20, average data length: 1.70 
    Clustering factor: 1, ratio: 0.05 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index BUSINESS_OPS_RND_WGTH (2) 
    Root page: 1504265, depth: 1, leaf buckets: 1, nodes: 20 
    Average node length: 4.30, total dup: 6, max dup: 3 
    Average key length: 3.25, compression ratio: 0.72 
    Average prefix length: 1.35, average data length: 1.00 
    Clustering factor: 1, ratio: 0.05 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index RDB$1 (0) 
    Root page: 1504263, depth: 1, leaf buckets: 1, nodes: 20 
    Average node length: 5.20, total dup: 0, max dup: 0 
    Average key length: 4.15, compression ratio: 0.65 
    Average prefix length: 1.10, average data length: 1.60 
    Clustering factor: 1, ratio: 0.05 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
DOC_DATA (139) 
    Primary pointer page: 502, Index root page: 503 
    Total formats: 1, used formats: 1 
    Average record length: 47.63, total records: 7707491 
    Average version length: 48.16, total versions: 52973, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 64.00, compression ratio: 1.34 
    Pointer pages: 55, data page slots: 88968 
    Data pages: 88968, average fill: 69% 
    Primary pages: 88967, secondary pages: 1, swept pages: 47392 
    Empty pages: 9, full pages: 57623 
    Fill distribution: 
     0 - 19% = 21 
    20 - 39% = 51 
    40 - 59% = 2168 
    60 - 79% = 86717 
    80 - 99% = 11 
 
    Index DOC_DATA_DOC_WARE_UNQ (0) 
    Root page: 1510636, depth: 3, leaf buckets: 23185, nodes: 7707491 
    Average node length: 18.88, total dup: 0, max dup: 0 
    Average key length: 15.89, compression ratio: 1.70 
    Average prefix length: 14.11, average data length: 12.89 
    Clustering factor: 1656287, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 304 
        20 - 39% = 1899 
        40 - 59% = 4078 
        60 - 79% = 2506 
        80 - 99% = 14398 
 
    Index DOC_DATA_ID_DESC (1) 
    Root page: 1528140, depth: 3, leaf buckets: 13479, nodes: 7707491 
    Average node length: 11.20, total dup: 0, max dup: 0 
    Average key length: 8.21, compression ratio: 1.10 
    Average prefix length: 3.78, average data length: 5.22 
    Clustering factor: 1481014, ratio: 0.19 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 1677 
        40 - 59% = 1941 
        60 - 79% = 1137 
        80 - 99% = 8724 
 
    Index FK_DOC_DATA_DOC_LIST (2) 
    Root page: 1546735, depth: 3, leaf buckets: 8303, nodes: 7707491 
    Average node length: 6.61, total dup: 5772735, max dup: 49 
    Average key length: 3.62, compression ratio: 2.48 
    Average prefix length: 7.63, average data length: 1.37 
    Clustering factor: 1474270, ratio: 0.19 
    Fill distribution: 
         0 - 19% = 116 
        20 - 39% = 1010 
        40 - 59% = 1340 
        60 - 79% = 953 
        80 - 99% = 4884 
 
DOC_LIST (138) 
    Primary pointer page: 500, Index root page: 501 
    Total formats: 1, used formats: 1 
    Average record length: 56.85, total records: 2224770 
    Average version length: 58.92, total versions: 26480, max versions: 2 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 84.00, compression ratio: 1.48 
    Pointer pages: 18, data page slots: 28728 
    Data pages: 28728, average fill: 71% 
    Primary pages: 28726, secondary pages: 2, swept pages: 16666 
    Empty pages: 3, full pages: 13601 
    Fill distribution: 
     0 - 19% = 6 
    20 - 39% = 23 
    40 - 59% = 544 
    60 - 79% = 28102 
    80 - 99% = 53 
 
    Index DOC_LIST_ID_DESC (1) 
    Root page: 1541152, depth: 3, leaf buckets: 4548, nodes: 2224770 
    Average node length: 11.41, total dup: 0, max dup: 0 
    Average key length: 8.45, compression ratio: 1.07 
    Average prefix length: 3.55, average data length: 5.45 
    Clustering factor: 674588, ratio: 0.30 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 949 
        40 - 59% = 829 
        60 - 79% = 773 
        80 - 99% = 1997 
 
    Index DOC_LIST_WORKER_OPTYPE (2) 
    Root page: 1544398, depth: 3, leaf buckets: 2395, nodes: 2225436 
    Average node length: 4.97, total dup: 2224538, max dup: 19356 
    Average key length: 2.01, compression ratio: 4.48 
    Average prefix length: 8.99, average data length: 0.01 
    Clustering factor: 1257206, ratio: 0.56 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 234 
        40 - 59% = 1338 
        60 - 79% = 564 
        80 - 99% = 258 
 
    Index FK_DOC_LIST_AGENTS (3) 
    Root page: 1545933, depth: 3, leaf buckets: 1782, nodes: 2224770 
    Average node length: 4.97, total dup: 2224720, max dup: 130202 
    Average key length: 2.01, compression ratio: 4.48 
    Average prefix length: 8.99, average data length: 0.01 
    Clustering factor: 1063000, ratio: 0.48 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 11 
        40 - 59% = 625 
        60 - 79% = 47 
        80 - 99% = 1099 
 
    Index PK_DOC_LIST (0) 
    Root page: 1538209, depth: 3, leaf buckets: 4351, nodes: 2224770 
    Average node length: 11.41, total dup: 0, max dup: 0 
    Average key length: 8.45, compression ratio: 1.07 
    Average prefix length: 3.55, average data length: 5.45 
    Clustering factor: 674588, ratio: 0.30 
    Fill distribution: 
         0 - 19% = 103 
        20 - 39% = 590 
        40 - 59% = 653 
        60 - 79% = 862 
        80 - 99% = 2143 
 
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.37, total records: 400 
    Average version length: 34.30, total versions: 1027, max versions: 3 
    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: 24 
    Data pages: 24, average fill: 48% 
    Primary pages: 13, secondary pages: 11, swept pages: 0 
    Empty pages: 7, full pages: 10 
    Fill distribution: 
     0 - 19% = 11 
    20 - 39% = 1 
    40 - 59% = 1 
    60 - 79% = 1 
    80 - 99% = 10 
 
    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: 31.58, total records: 73337 
    Average version length: 68.29, total versions: 45434, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 88.00, compression ratio: 2.79 
    Pointer pages: 6, data page slots: 2424 
    Data pages: 2256, average fill: 41% 
    Primary pages: 2255, secondary pages: 1, swept pages: 458 
    Empty pages: 795, full pages: 771 
    Fill distribution: 
     0 - 19% = 948 
    20 - 39% = 191 
    40 - 59% = 197 
    60 - 79% = 384 
    80 - 99% = 536 
 
    Index INVNT_TURNOVER_LOG_WARE_DD_ID (0) 
    Root page: 1705544, depth: 3, leaf buckets: 289, nodes: 73337 
    Average node length: 13.23, total dup: 6753, max dup: 2 
    Average key length: 10.63, compression ratio: 2.54 
    Average prefix length: 19.28, average data length: 7.72 
    Clustering factor: 53213, ratio: 0.73 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 153 
        40 - 59% = 117 
        60 - 79% = 17 
        80 - 99% = 1 
 
MONEY_SALDO (141) 
    Primary pointer page: 506, Index root page: 507 
    Total formats: 1, used formats: 1 
    Average record length: 15.31, total records: 49 
    Average version length: 9.00, total versions: 130, max versions: 3 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 32.00, compression ratio: 2.09 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 61% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 1 
    80 - 99% = 0 
 
    Index PK_MONEY_SALDO (0) 
    Root page: 1510383, depth: 1, leaf buckets: 1, nodes: 49 
    Average node length: 11.82, total dup: 0, max dup: 0 
    Average key length: 10.80, compression ratio: 0.83 
    Average prefix length: 1.18, average data length: 7.82 
    Clustering factor: 1, ratio: 0.02 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
MONEY_TURNOVER_LOG (140) 
    Primary pointer page: 504, Index root page: 505 
    Total formats: 1, used formats: 1 
    Average record length: 13.44, total records: 1091 
    Average version length: 43.80, total versions: 956, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 58.00, compression ratio: 4.32 
    Pointer pages: 1, data page slots: 32 
    Data pages: 32, average fill: 37% 
    Primary pages: 30, secondary pages: 2, swept pages: 3 
    Empty pages: 6, full pages: 3 
    Fill distribution: 
     0 - 19% = 12 
    20 - 39% = 5 
    40 - 59% = 7 
    60 - 79% = 3 
    80 - 99% = 5 
 
    Index MONEY_TURNOVER_LOG_AGENT_OPTYPE (0) 
    Root page: 93610, depth: 2, leaf buckets: 2, nodes: 1091 
    Average node length: 4.68, total dup: 993, max dup: 113 
    Average key length: 2.94, compression ratio: 6.47 
    Average prefix length: 18.15, average data length: 0.85 
    Clustering factor: 627, ratio: 0.57 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 2 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
MON_CACHE_MEMORY (165) 
    Primary pointer page: 555, Index root page: 556 
    Total formats: 2, used formats: 1 
    Average record length: 97.54, total records: 72 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 112.00, compression ratio: 1.15 
    Pointer pages: 1, data page slots: 2 
    Data pages: 2, average fill: 50% 
    Primary pages: 2, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 1 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 1 
    40 - 59% = 0 
    60 - 79% = 1 
    80 - 99% = 0 
 
    Index PK_MON_CACHE_MEMORY (0) 
    Root page: 1504238, depth: 1, leaf buckets: 1, nodes: 72 
    Average node length: 11.69, total dup: 0, max dup: 0 
    Average key length: 10.68, compression ratio: 0.84 
    Average prefix length: 1.31, average data length: 7.69 
    Clustering factor: 2, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
MON_LOG (162) 
    Primary pointer page: 548, Index root page: 549 
    Total formats: 2, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index MON_LOG_DTS (4) 
    Root page: 1504251, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index MON_LOG_GDSCODE (2) 
    Root page: 1504249, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index MON_LOG_ROWSET_DESC (1) 
    Root page: 1504248, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index MON_LOG_UNIT (3) 
    Root page: 1504250, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PK_MON_LOG (0) 
    Root page: 1504247, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
MON_LOG_TABLE_STATS (163) 
    Primary pointer page: 550, Index root page: 551 
    Total formats: 2, used formats: 1 
    Average record length: 67.13, total records: 30 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 611.00, compression ratio: 9.10 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 31% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 1 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index MON_LOG_TABLE_STATS_DTS (4) 
    Root page: 1504246, depth: 1, leaf buckets: 1, nodes: 30 
    Average node length: 3.50, total dup: 23, max dup: 4 
    Average key length: 2.47, compression ratio: 3.24 
    Average prefix length: 7.53, average data length: 0.47 
    Clustering factor: 1, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index MON_LOG_TABLE_STATS_GDSCODE (2) 
    Root page: 1504244, depth: 1, leaf buckets: 1, nodes: 30 
    Average node length: 2.00, total dup: 29, max dup: 29 
    Average key length: 1.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 1, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index MON_LOG_TABLE_STATS_ROWSET (1) 
    Root page: 1504243, depth: 1, leaf buckets: 1, nodes: 30 
    Average node length: 3.33, total dup: 29, max dup: 29 
    Average key length: 2.30, compression ratio: 3.91 
    Average prefix length: 8.70, average data length: 0.30 
    Clustering factor: 1, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index MON_LOG_TABLE_STATS_TN_UNIT (3) 
    Root page: 1504245, depth: 1, leaf buckets: 1, nodes: 30 
    Average node length: 12.90, total dup: 0, max dup: 0 
    Average key length: 11.87, compression ratio: 1.42 
    Average prefix length: 7.63, average data length: 9.20 
    Clustering factor: 1, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PK_MON_LOG_TABLE_STATS (0) 
    Root page: 1504242, depth: 1, leaf buckets: 1, nodes: 30 
    Average node length: 8.37, total dup: 0, max dup: 0 
    Average key length: 7.33, compression ratio: 1.23 
    Average prefix length: 4.63, average data length: 4.37 
    Clustering factor: 1, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
OPTYPES (136) 
    Primary pointer page: 496, Index root page: 497 
    Total formats: 2, used formats: 1 
    Average record length: 67.56, total records: 9 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 386.00, compression ratio: 5.71 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 9% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index OPTYPES_MCODE_UNQ (1) 
    Root page: 1544827, depth: 1, leaf buckets: 1, nodes: 9 
    Average node length: 8.56, total dup: 0, max dup: 0 
    Average key length: 6.89, compression ratio: 0.73 
    Average prefix length: 0.44, average data length: 4.56 
    Clustering factor: 1, ratio: 0.11 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PK_OPTYPES (0) 
    Root page: 1544826, depth: 1, leaf buckets: 1, nodes: 9 
    Average node length: 6.11, total dup: 0, max dup: 0 
    Average key length: 5.00, compression ratio: 0.60 
    Average prefix length: 0.89, average data length: 2.11 
    Clustering factor: 1, ratio: 0.11 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
PDISTR (146) 
    Primary pointer page: 516, Index root page: 517 
    Total formats: 1, used formats: 1 
    Average record length: 36.94, total records: 788342 
    Average version length: 37.87, total versions: 17939, max versions: 2 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 54.00, compression ratio: 1.46 
    Pointer pages: 6, data page slots: 8496 
    Data pages: 8496, average fill: 64% 
    Primary pages: 8495, secondary pages: 1, swept pages: 4385 
    Empty pages: 24, full pages: 3554 
    Fill distribution: 
     0 - 19% = 35 
    20 - 39% = 42 
    40 - 59% = 1195 
    60 - 79% = 7185 
    80 - 99% = 39 
 
    Index PDISTR_AGENT_ID (2) 
    Root page: 1509330, depth: 2, leaf buckets: 862, nodes: 780826 
    Average node length: 4.88, total dup: 780777, max dup: 136754 
    Average key length: 2.01, compression ratio: 4.48 
    Average prefix length: 8.99, average data length: 0.01 
    Clustering factor: 90514, ratio: 0.12 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 146 
        40 - 59% = 464 
        60 - 79% = 156 
        80 - 99% = 94 
 
    Index PDISTR_SNDOP_RCVOP_SNDID_ASC (0) 
    Root page: 1508635, depth: 3, leaf buckets: 900, nodes: 780826 
    Average node length: 5.89, total dup: 695154, max dup: 45 
    Average key length: 3.02, compression ratio: 7.29 
    Average prefix length: 21.09, average data length: 0.91 
    Clustering factor: 158013, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 38 
        40 - 59% = 458 
        60 - 79% = 119 
        80 - 99% = 285 
 
    Index PDISTR_SNDOP_RCVOP_SNDID_DESC (1) 
    Root page: 1509209, depth: 3, leaf buckets: 951, nodes: 780826 
    Average node length: 5.89, total dup: 695154, max dup: 45 
    Average key length: 3.02, compression ratio: 7.28 
    Average prefix length: 21.09, average data length: 0.91 
    Clustering factor: 159798, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 94 
        40 - 59% = 489 
        60 - 79% = 108 
        80 - 99% = 258 
 
    Index PDISTR_WORKER_SND_ID (3) 
    Root page: 1510200, depth: 3, leaf buckets: 1114, nodes: 780826 
    Average node length: 5.97, total dup: 695154, max dup: 45 
    Average key length: 3.10, compression ratio: 5.48 
    Average prefix length: 16.01, average data length: 0.99 
    Clustering factor: 152933, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 262 
        40 - 59% = 560 
        60 - 79% = 205 
        80 - 99% = 85 
 
PERF_AGG (158) 
    Primary pointer page: 540, Index root page: 541 
    Total formats: 1, used formats: 1 
    Average record length: 62.75, total records: 5461 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 3.28, total fragments: 29, max fragments: 1 
    Average unpacked length: 379.00, compression ratio: 6.04 
    Pointer pages: 1, data page slots: 88 
    Data pages: 88, average fill: 61% 
    Primary pages: 75, secondary pages: 13, swept pages: 56 
    Empty pages: 5, full pages: 61 
    Fill distribution: 
     0 - 19% = 14 
    20 - 39% = 1 
    40 - 59% = 0 
    60 - 79% = 73 
    80 - 99% = 0 
 
    Index PERF_AGG_UNQ (1) 
    Root page: 1504260, depth: 2, leaf buckets: 6, nodes: 5461 
    Average node length: 5.53, total dup: 0, max dup: 0 
    Average key length: 3.59, compression ratio: 10.02 
    Average prefix length: 34.45, average data length: 1.56 
    Clustering factor: 5064, ratio: 0.93 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 0 
        40 - 59% = 4 
        60 - 79% = 0 
        80 - 99% = 2 
 
    Index PK_PERF_AGG (0) 
    Root page: 1504255, depth: 2, leaf buckets: 10, nodes: 5461 
    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: 161, 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.03, total records: 78067 
    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: 816 
    Data pages: 816, average fill: 66% 
    Primary pages: 816, secondary pages: 0, swept pages: 0 
    Empty pages: 5, full pages: 810 
    Fill distribution: 
     0 - 19% = 5 
    20 - 39% = 1 
    40 - 59% = 0 
    60 - 79% = 810 
    80 - 99% = 0 
 
    Index PK_PERF_ESTIMATED (0) 
    Root page: 40083, depth: 2, leaf buckets: 100, nodes: 78067 
    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: 2936, ratio: 0.04 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 0 
        40 - 59% = 3 
        60 - 79% = 0 
        80 - 99% = 97 
 
PERF_ISQL_STAT (156) 
    Primary pointer page: 536, Index root page: 537 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index PERF_ISQL_STAT_TRN (0) 
    Root page: 1504261, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
PERF_LOG (159) 
    Primary pointer page: 542, Index root page: 543 
    Total formats: 1, used formats: 1 
    Average record length: 110.58, 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.29 
    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: 148.58, total records: 170503 
    Average version length: 152.66, total versions: 3056, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.41 
    Pointer pages: 6, data page slots: 5064 
    Data pages: 4224, average fill: 83% 
    Primary pages: 4222, secondary pages: 2, swept pages: 1 
    Empty pages: 30, full pages: 4182 
    Fill distribution: 
     0 - 19% = 33 
    20 - 39% = 6 
    40 - 59% = 0 
    60 - 79% = 3 
    80 - 99% = 4182 
 
PERF_SPLIT_1 (282) 
    Primary pointer page: 603, Index root page: 604 
    Total formats: 1, used formats: 1 
    Average record length: 127.40, total records: 159518 
    Average version length: 154.91, total versions: 26443, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 13.31 
    Pointer pages: 5, data page slots: 4832 
    Data pages: 4024, average fill: 84% 
    Primary pages: 4022, secondary pages: 2, swept pages: 1 
    Empty pages: 80, full pages: 3909 
    Fill distribution: 
     0 - 19% = 84 
    20 - 39% = 12 
    40 - 59% = 9 
    60 - 79% = 10 
    80 - 99% = 3909 
 
PERF_SPLIT_2 (283) 
    Primary pointer page: 605, Index root page: 606 
    Total formats: 1, used formats: 1 
    Average record length: 136.08, total records: 161661 
    Average version length: 154.77, total versions: 17201, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 12.46 
    Pointer pages: 8, data page slots: 6176 
    Data pages: 4104, average fill: 83% 
    Primary pages: 4102, secondary pages: 2, swept pages: 1 
    Empty pages: 112, full pages: 3970 
    Fill distribution: 
     0 - 19% = 116 
    20 - 39% = 10 
    40 - 59% = 3 
    60 - 79% = 5 
    80 - 99% = 3970 
 
PERF_SPLIT_3 (284) 
    Primary pointer page: 607, Index root page: 616 
    Total formats: 1, used formats: 1 
    Average record length: 133.77, total records: 161406 
    Average version length: 154.90, total versions: 19617, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 12.68 
    Pointer pages: 8, data page slots: 5512 
    Data pages: 4152, average fill: 82% 
    Primary pages: 4150, secondary pages: 2, swept pages: 6 
    Empty pages: 155, full pages: 3948 
    Fill distribution: 
     0 - 19% = 158 
    20 - 39% = 22 
    40 - 59% = 13 
    60 - 79% = 12 
    80 - 99% = 3947 
 
PERF_SPLIT_4 (285) 
    Primary pointer page: 617, Index root page: 618 
    Total formats: 1, used formats: 1 
    Average record length: 148.02, total records: 157650 
    Average version length: 153.22, total versions: 3538, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.46 
    Pointer pages: 7, data page slots: 6144 
    Data pages: 3968, average fill: 82% 
    Primary pages: 3966, secondary pages: 2, swept pages: 2 
    Empty pages: 80, full pages: 3867 
    Fill distribution: 
     0 - 19% = 82 
    20 - 39% = 10 
    40 - 59% = 8 
    60 - 79% = 1 
    80 - 99% = 3867 
 
PERF_SPLIT_5 (286) 
    Primary pointer page: 619, Index root page: 620 
    Total formats: 1, used formats: 1 
    Average record length: 141.35, total records: 145057 
    Average version length: 153.75, total versions: 9477, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 12.00 
    Pointer pages: 6, data page slots: 4744 
    Data pages: 3592, average fill: 84% 
    Primary pages: 3589, secondary pages: 3, swept pages: 1 
    Empty pages: 31, full pages: 3552 
    Fill distribution: 
     0 - 19% = 36 
    20 - 39% = 2 
    40 - 59% = 1 
    60 - 79% = 1 
    80 - 99% = 3552 
 
PERF_SPLIT_6 (287) 
    Primary pointer page: 621, Index root page: 622 
    Total formats: 1, used formats: 1 
    Average record length: 135.58, total records: 173166 
    Average version length: 154.94, total versions: 18880, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 12.51 
    Pointer pages: 7, data page slots: 5320 
    Data pages: 4328, average fill: 84% 
    Primary pages: 4326, secondary pages: 2, swept pages: 3 
    Empty pages: 59, full pages: 4244 
    Fill distribution: 
     0 - 19% = 63 
    20 - 39% = 7 
    40 - 59% = 4 
    60 - 79% = 9 
    80 - 99% = 4245 
 
PERF_SPLIT_7 (288) 
    Primary pointer page: 626, Index root page: 627 
    Total formats: 1, used formats: 1 
    Average record length: 146.53, total records: 157607 
    Average version length: 153.36, total versions: 4994, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.57 
    Pointer pages: 6, data page slots: 5968 
    Data pages: 3920, average fill: 83% 
    Primary pages: 3918, secondary pages: 2, swept pages: 1 
    Empty pages: 41, full pages: 3861 
    Fill distribution: 
     0 - 19% = 45 
    20 - 39% = 6 
    40 - 59% = 1 
    60 - 79% = 7 
    80 - 99% = 3861 
 
PERF_SPLIT_8 (289) 
    Primary pointer page: 628, Index root page: 629 
    Total formats: 1, used formats: 1 
    Average record length: 149.54, total records: 156254 
    Average version length: 151.82, total versions: 1964, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.34 
    Pointer pages: 7, data page slots: 4752 
    Data pages: 3912, average fill: 82% 
    Primary pages: 3910, secondary pages: 2, swept pages: 5 
    Empty pages: 63, full pages: 3834 
    Fill distribution: 
     0 - 19% = 67 
    20 - 39% = 2 
    40 - 59% = 5 
    60 - 79% = 4 
    80 - 99% = 3834 
 
PERF_SPLIT_9 (290) 
    Primary pointer page: 630, Index root page: 631 
    Total formats: 1, used formats: 1 
    Average record length: 148.22, total records: 165154 
    Average version length: 152.50, total versions: 3317, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.44 
    Pointer pages: 5, data page slots: 4592 
    Data pages: 4112, average fill: 83% 
    Primary pages: 4110, secondary pages: 2, swept pages: 1 
    Empty pages: 46, full pages: 4045 
    Fill distribution: 
     0 - 19% = 48 
    20 - 39% = 7 
    40 - 59% = 6 
    60 - 79% = 6 
    80 - 99% = 4045 
 
PHRASES (143) 
    Primary pointer page: 510, Index root page: 511 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index PHRASES_ID_DESC (3) 
    Root page: 1510376, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PHRASES_NAME (2) 
    Root page: 1510375, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PHRASES_UNQ (1) 
    Root page: 1510374, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PK_PHRASES (0) 
    Root page: 1510373, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
PSTORNED (147) 
    Primary pointer page: 518, Index root page: 519 
    Total formats: 1, used formats: 1 
    Average record length: 52.17, total records: 2093530 
    Average version length: 52.83, total versions: 27685, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 70.00, compression ratio: 1.34 
    Pointer pages: 16, data page slots: 25800 
    Data pages: 25784, average fill: 70% 
    Primary pages: 25769, secondary pages: 15, swept pages: 12121 
    Empty pages: 153, full pages: 21412 
    Fill distribution: 
     0 - 19% = 286 
    20 - 39% = 289 
    40 - 59% = 1008 
    60 - 79% = 23939 
    80 - 99% = 262 
 
    Index PSTORNED_RCV_ID (1) 
    Root page: 1506208, depth: 3, leaf buckets: 2573, nodes: 2093530 
    Average node length: 5.44, total dup: 1953552, max dup: 1640 
    Average key length: 2.49, compression ratio: 3.62 
    Average prefix length: 8.58, average data length: 0.42 
    Clustering factor: 181076, ratio: 0.09 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 289 
        40 - 59% = 1681 
        60 - 79% = 305 
        80 - 99% = 296 
 
    Index PSTORNED_SND_ID (0) 
    Root page: 1504841, depth: 3, leaf buckets: 2754, nodes: 2093530 
    Average node length: 5.69, total dup: 1878646, max dup: 68 
    Average key length: 2.74, compression ratio: 3.28 
    Average prefix length: 8.36, average data length: 0.64 
    Clustering factor: 373838, ratio: 0.18 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 8 
        40 - 59% = 2401 
        60 - 79% = 318 
        80 - 99% = 27 
 
    Index PSTORNED_WORKER_ID (2) 
    Root page: 1508018, depth: 3, leaf buckets: 2090, nodes: 2093530 
    Average node length: 4.96, total dup: 2093430, max dup: 28035 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.41, average data length: 0.00 
    Clustering factor: 178877, ratio: 0.09 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 192 
        40 - 59% = 1059 
        60 - 79% = 379 
        80 - 99% = 460 
 
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: 50.71, total records: 114680 
    Average version length: 69.18, total versions: 35256, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 2.48 
    Pointer pages: 3, data page slots: 3848 
    Data pages: 2800, average fill: 49% 
    Primary pages: 2800, secondary pages: 0, swept pages: 463 
    Empty pages: 288, full pages: 452 
    Fill distribution: 
     0 - 19% = 454 
    20 - 39% = 377 
    40 - 59% = 861 
    60 - 79% = 975 
    80 - 99% = 133 
 
    Index XQD_1000_1200_WA_SO_RO_WKR_SND (0) 
    Root page: 104935, depth: 3, leaf buckets: 225, nodes: 114680 
    Average node length: 6.56, total dup: 99696, max dup: 14 
    Average key length: 4.00, compression ratio: 10.49 
    Average prefix length: 40.12, average data length: 1.88 
    Clustering factor: 20558, ratio: 0.18 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 110 
        40 - 59% = 95 
        60 - 79% = 19 
        80 - 99% = 1 
 
XQD_1000_3300 (178) 
    Primary pointer page: 581, Index root page: 582 
    Total formats: 1, used formats: 1 
    Average record length: 67.33, total records: 6911932 
    Average version length: 68.80, total versions: 187454, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.87 
    Pointer pages: 66, data page slots: 107288 
    Data pages: 107288, average fill: 69% 
    Primary pages: 107288, secondary pages: 0, swept pages: 63802 
    Empty pages: 10, full pages: 40457 
    Fill distribution: 
     0 - 19% = 42 
    20 - 39% = 583 
    40 - 59% = 11382 
    60 - 79% = 94737 
    80 - 99% = 544 
 
    Index XQD_1000_3300_WA_SO_RO_WKR_SND (0) 
    Root page: 1480476, depth: 3, leaf buckets: 10645, nodes: 6911932 
    Average node length: 6.51, total dup: 5979025, max dup: 29 
    Average key length: 3.52, compression ratio: 11.93 
    Average prefix length: 40.61, average data length: 1.39 
    Clustering factor: 1595020, ratio: 0.23 
    Fill distribution: 
         0 - 19% = 5 
        20 - 39% = 1881 
        40 - 59% = 5824 
        60 - 79% = 2416 
        80 - 99% = 519 
 
    Index XQD_1000_3300_WKR_DOC_ASC (1) 
    Root page: 1486090, depth: 3, leaf buckets: 8410, nodes: 6911932 
    Average node length: 5.40, total dup: 6633290, max dup: 139 
    Average key length: 2.41, compression ratio: 7.05 
    Average prefix length: 16.63, average data length: 0.37 
    Clustering factor: 1408849, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 12 
        20 - 39% = 1200 
        40 - 59% = 4647 
        60 - 79% = 1650 
        80 - 99% = 901 
 
    Index XQD_1000_3300_WKR_DOC_DEC (2) 
    Root page: 1490630, depth: 3, leaf buckets: 8470, nodes: 6911932 
    Average node length: 5.40, total dup: 6633290, max dup: 139 
    Average key length: 2.41, compression ratio: 7.05 
    Average prefix length: 16.63, average data length: 0.37 
    Clustering factor: 1411115, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 8 
        20 - 39% = 1267 
        40 - 59% = 4679 
        60 - 79% = 1622 
        80 - 99% = 894 
 
XQD_1200_2000 (177) 
    Primary pointer page: 579, Index root page: 580 
    Total formats: 1, used formats: 1 
    Average record length: 68.17, total records: 11976098 
    Average version length: 68.76, total versions: 154599, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.85 
    Pointer pages: 109, data page slots: 176384 
    Data pages: 176384, average fill: 72% 
    Primary pages: 176383, secondary pages: 1, swept pages: 108962 
    Empty pages: 2, full pages: 121543 
    Fill distribution: 
     0 - 19% = 43 
    20 - 39% = 619 
    40 - 59% = 7434 
    60 - 79% = 167394 
    80 - 99% = 894 
 
    Index XQD_1200_2000_WA_SO_RO_WKR_SND (0) 
    Root page: 1495050, depth: 3, leaf buckets: 18387, nodes: 11973932 
    Average node length: 6.62, total dup: 10441216, max dup: 59 
    Average key length: 3.42, compression ratio: 12.27 
    Average prefix length: 40.70, average data length: 1.30 
    Clustering factor: 2433635, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 37 
        20 - 39% = 2336 
        40 - 59% = 10899 
        60 - 79% = 4248 
        80 - 99% = 867 
 
XQD_2000_3300 (179) 
    Primary pointer page: 583, Index root page: 584 
    Total formats: 1, used formats: 1 
    Average record length: 50.67, total records: 1417238 
    Average version length: 69.04, total versions: 263018, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 2.49 
    Pointer pages: 25, data page slots: 39632 
    Data pages: 30808, average fill: 48% 
    Primary pages: 30649, secondary pages: 159, swept pages: 14399 
    Empty pages: 5156, full pages: 14967 
    Fill distribution: 
     0 - 19% = 7640 
    20 - 39% = 5130 
    40 - 59% = 3273 
    60 - 79% = 11253 
    80 - 99% = 3512 
 
    Index XQD_2000_3300_WA_SO_RO_WKR_SND (0) 
    Root page: 1479735, depth: 3, leaf buckets: 1945, nodes: 1244765 
    Average node length: 5.54, total dup: 1194239, max dup: 49 
    Average key length: 2.58, compression ratio: 16.27 
    Average prefix length: 41.46, average data length: 0.54 
    Clustering factor: 84439, ratio: 0.07 
    Fill distribution: 
         0 - 19% = 12 
        20 - 39% = 753 
        40 - 59% = 922 
        60 - 79% = 253 
        80 - 99% = 5 
 
XQD_2100_3300 (180) 
    Primary pointer page: 585, Index root page: 586 
    Total formats: 1, used formats: 1 
    Average record length: 54.62, total records: 792986 
    Average version length: 69.03, total versions: 42816, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 2.31 
    Pointer pages: 21, data page slots: 33288 
    Data pages: 26984, average fill: 30% 
    Primary pages: 26984, secondary pages: 0, swept pages: 14671 
    Empty pages: 5733, full pages: 1264 
    Fill distribution: 
     0 - 19% = 9518 
    20 - 39% = 7373 
    40 - 59% = 7875 
    60 - 79% = 2207 
    80 - 99% = 11 
 
    Index XQD_2100_3300_WA_SO_RO_WKR_SND (0) 
    Root page: 1479229, depth: 3, leaf buckets: 1119, nodes: 645723 
    Average node length: 5.97, total dup: 594606, max dup: 49 
    Average key length: 3.03, compression ratio: 13.84 
    Average prefix length: 41.04, average data length: 0.96 
    Clustering factor: 92317, ratio: 0.14 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 488 
        40 - 59% = 537 
        60 - 79% = 88 
        80 - 99% = 6 
 
XQD_3300_3400 (181) 
    Primary pointer page: 587, Index root page: 588 
    Total formats: 1, used formats: 1 
    Average record length: 67.73, total records: 8891443 
    Average version length: 68.95, total versions: 170527, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.86 
    Pointer pages: 88, data page slots: 142560 
    Data pages: 142536, average fill: 67% 
    Primary pages: 142520, secondary pages: 16, swept pages: 91390 
    Empty pages: 322, full pages: 48264 
    Fill distribution: 
     0 - 19% = 916 
    20 - 39% = 4045 
    40 - 59% = 22638 
    60 - 79% = 114151 
    80 - 99% = 786 
 
    Index XQD_3300_3400_WA_SO_RO_WKR_SND (0) 
    Root page: 1472612, depth: 3, leaf buckets: 13460, nodes: 8889006 
    Average node length: 6.68, total dup: 7371159, max dup: 14 
    Average key length: 3.67, compression ratio: 11.44 
    Average prefix length: 40.50, average data length: 1.50 
    Clustering factor: 2041509, ratio: 0.23 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 1822 
        40 - 59% = 6949 
        60 - 79% = 4119 
        80 - 99% = 569 
 
XQS_1000_1200 (182) 
    Primary pointer page: 589, Index root page: 590 
    Total formats: 1, used formats: 1 
    Average record length: 82.53, total records: 21117461 
    Average version length: 82.94, total versions: 3416, 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: 319496 
    Data pages: 319496, average fill: 81% 
    Primary pages: 319492, secondary pages: 4, swept pages: 13966 
    Empty pages: 63, full pages: 318087 
    Fill distribution: 
     0 - 19% = 102 
    20 - 39% = 98 
    40 - 59% = 239 
    60 - 79% = 48993 
    80 - 99% = 270064 
 
    Index XQS_1000_1200_DOC_ID (1) 
    Root page: 1426738, depth: 3, leaf buckets: 19473, nodes: 21117461 
    Average node length: 5.72, total dup: 20637059, max dup: 128 
    Average key length: 2.16, compression ratio: 4.16 
    Average prefix length: 8.86, average data length: 0.14 
    Clustering factor: 3278259, ratio: 0.16 
    Fill distribution: 
         0 - 19% = 6 
        20 - 39% = 0 
        40 - 59% = 8392 
        60 - 79% = 505 
        80 - 99% = 10570 
 
    Index XQS_1000_1200_RCV_ID (3) 
    Root page: 1457002, depth: 3, leaf buckets: 17156, nodes: 21117461 
    Average node length: 6.31, total dup: 18558116, max dup: 49 
    Average key length: 2.75, compression ratio: 3.27 
    Average prefix length: 8.37, average data length: 0.63 
    Clustering factor: 914804, ratio: 0.04 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 6 
        40 - 59% = 792 
        60 - 79% = 277 
        80 - 99% = 16080 
 
    Index XQS_1000_1200_SND_ID (2) 
    Root page: 1441095, depth: 3, leaf buckets: 21236, nodes: 21117461 
    Average node length: 6.35, total dup: 18476491, max dup: 25 
    Average key length: 2.79, compression ratio: 3.23 
    Average prefix length: 8.34, average data length: 0.66 
    Clustering factor: 3571890, ratio: 0.17 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 3 
        40 - 59% = 8628 
        60 - 79% = 562 
        80 - 99% = 12041 
 
    Index XQS_1000_1200_WORKER_ID (0) 
    Root page: 1413370, depth: 3, leaf buckets: 16027, nodes: 21117461 
    Average node length: 5.56, total dup: 21117361, max dup: 229683 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.42, average data length: 0.00 
    Clustering factor: 943539, ratio: 0.04 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 22 
        40 - 59% = 2779 
        60 - 79% = 345 
        80 - 99% = 12879 
 
XQS_1000_3300 (184) 
    Primary pointer page: 593, Index root page: 594 
    Total formats: 1, used formats: 1 
    Average record length: 75.34, total records: 10149514 
    Average version length: 82.60, total versions: 977966, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.67 
    Pointer pages: 103, data page slots: 167160 
    Data pages: 167144, average fill: 76% 
    Primary pages: 167123, secondary pages: 21, swept pages: 25011 
    Empty pages: 250, full pages: 142923 
    Fill distribution: 
     0 - 19% = 636 
    20 - 39% = 2124 
    40 - 59% = 8817 
    60 - 79% = 110739 
    80 - 99% = 44828 
 
    Index XQS_1000_3300_DOC_ID (1) 
    Root page: 1367524, depth: 3, leaf buckets: 11335, nodes: 10149514 
    Average node length: 5.36, total dup: 9838611, max dup: 253 
    Average key length: 2.22, compression ratio: 4.05 
    Average prefix length: 8.81, average data length: 0.19 
    Clustering factor: 2338449, ratio: 0.23 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 32 
        40 - 59% = 6694 
        60 - 79% = 4412 
        80 - 99% = 195 
 
    Index XQS_1000_3300_RCV_ID (3) 
    Root page: 1379283, depth: 3, leaf buckets: 13694, nodes: 10149514 
    Average node length: 6.23, total dup: 8417344, max dup: 14 
    Average key length: 3.10, compression ratio: 2.91 
    Average prefix length: 8.07, average data length: 0.93 
    Clustering factor: 1670644, ratio: 0.16 
    Fill distribution: 
         0 - 19% = 143 
        20 - 39% = 3410 
        40 - 59% = 4678 
        60 - 79% = 2747 
        80 - 99% = 2716 
 
    Index XQS_1000_3300_SND_ID (2) 
    Root page: 1373081, depth: 3, leaf buckets: 12644, nodes: 10149514 
    Average node length: 5.96, total dup: 8837183, max dup: 47 
    Average key length: 2.83, compression ratio: 3.18 
    Average prefix length: 8.30, average data length: 0.70 
    Clustering factor: 2544817, ratio: 0.25 
    Fill distribution: 
         0 - 19% = 3 
        20 - 39% = 33 
        40 - 59% = 7597 
        60 - 79% = 4775 
        80 - 99% = 236 
 
    Index XQS_1000_3300_WORKER_ID (0) 
    Root page: 1362789, depth: 3, leaf buckets: 10289, nodes: 10149514 
    Average node length: 5.13, total dup: 10149414, max dup: 159793 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.41, average data length: 0.00 
    Clustering factor: 1687112, ratio: 0.17 
    Fill distribution: 
         0 - 19% = 40 
        20 - 39% = 945 
        40 - 59% = 5100 
        60 - 79% = 1859 
        80 - 99% = 2345 
 
XQS_1200_2000 (183) 
    Primary pointer page: 591, Index root page: 592 
    Total formats: 1, used formats: 1 
    Average record length: 77.87, total records: 11569015 
    Average version length: 82.50, total versions: 697621, 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: 118, data page slots: 191952 
    Data pages: 190824, average fill: 75% 
    Primary pages: 190698, secondary pages: 126, swept pages: 44298 
    Empty pages: 2132, full pages: 161723 
    Fill distribution: 
     0 - 19% = 3367 
    20 - 39% = 4475 
    40 - 59% = 11009 
    60 - 79% = 94716 
    80 - 99% = 77257 
 
    Index XQS_1200_2000_DOC_ID (1) 
    Root page: 1392123, depth: 3, leaf buckets: 13098, nodes: 11569015 
    Average node length: 5.30, total dup: 11459073, max dup: 639 
    Average key length: 2.08, compression ratio: 4.33 
    Average prefix length: 8.93, average data length: 0.07 
    Clustering factor: 2417081, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 117 
        40 - 59% = 8259 
        60 - 79% = 4515 
        80 - 99% = 206 
 
    Index XQS_1200_2000_RCV_ID (3) 
    Root page: 1406132, depth: 3, leaf buckets: 10512, nodes: 11569015 
    Average node length: 5.50, total dup: 11065123, max dup: 49 
    Average key length: 2.28, compression ratio: 3.95 
    Average prefix length: 8.77, average data length: 0.23 
    Clustering factor: 729470, ratio: 0.06 
    Fill distribution: 
         0 - 19% = 148 
        20 - 39% = 759 
        40 - 59% = 2534 
        60 - 79% = 1774 
        80 - 99% = 5297 
 
    Index XQS_1200_2000_SND_ID (2) 
    Root page: 1398660, depth: 3, leaf buckets: 14981, nodes: 11569015 
    Average node length: 6.02, total dup: 10108107, max dup: 78 
    Average key length: 2.80, compression ratio: 3.22 
    Average prefix length: 8.33, average data length: 0.67 
    Clustering factor: 2433670, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 145 
        40 - 59% = 9799 
        60 - 79% = 4792 
        80 - 99% = 243 
 
    Index XQS_1200_2000_WORKER_ID (0) 
    Root page: 1386233, depth: 3, leaf buckets: 10916, nodes: 11569015 
    Average node length: 5.22, total dup: 11568915, max dup: 185608 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.42, average data length: 0.00 
    Clustering factor: 717548, ratio: 0.06 
    Fill distribution: 
         0 - 19% = 84 
        20 - 39% = 764 
        40 - 59% = 4952 
        60 - 79% = 1391 
        80 - 99% = 3725 
 
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: 75.85, total records: 10243235 
    Average version length: 82.90, total versions: 956495, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.66 
    Pointer pages: 106, data page slots: 172888 
    Data pages: 172880, average fill: 74% 
    Primary pages: 172856, secondary pages: 24, swept pages: 30551 
    Empty pages: 389, full pages: 142649 
    Fill distribution: 
     0 - 19% = 1114 
    20 - 39% = 4420 
    40 - 59% = 14809 
    60 - 79% = 108311 
    80 - 99% = 44226 
 
    Index XQS_2100_3300_DOC_ID (1) 
    Root page: 1344708, depth: 3, leaf buckets: 12039, nodes: 10243235 
    Average node length: 5.17, total dup: 10213977, max dup: 2420 
    Average key length: 2.03, compression ratio: 4.43 
    Average prefix length: 8.97, average data length: 0.03 
    Clustering factor: 2155264, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 28 
        20 - 39% = 1231 
        40 - 59% = 7946 
        60 - 79% = 2136 
        80 - 99% = 698 
 
    Index XQS_2100_3300_RCV_ID (3) 
    Root page: 1355739, depth: 3, leaf buckets: 13803, nodes: 10243235 
    Average node length: 6.24, total dup: 8494126, max dup: 14 
    Average key length: 3.10, compression ratio: 2.91 
    Average prefix length: 8.07, average data length: 0.93 
    Clustering factor: 1632445, ratio: 0.16 
    Fill distribution: 
         0 - 19% = 185 
        20 - 39% = 3408 
        40 - 59% = 4677 
        60 - 79% = 2706 
        80 - 99% = 2827 
 
    Index XQS_2100_3300_SND_ID (2) 
    Root page: 1350071, depth: 3, leaf buckets: 12723, nodes: 10243235 
    Average node length: 5.42, total dup: 9794464, max dup: 101 
    Average key length: 2.28, compression ratio: 3.95 
    Average prefix length: 8.76, average data length: 0.24 
    Clustering factor: 2293094, ratio: 0.22 
    Fill distribution: 
         0 - 19% = 26 
        20 - 39% = 1306 
        40 - 59% = 8865 
        60 - 79% = 1851 
        80 - 99% = 675 
 
    Index XQS_2100_3300_WORKER_ID (0) 
    Root page: 987843, depth: 3, leaf buckets: 10458, nodes: 10243235 
    Average node length: 5.14, total dup: 10243135, max dup: 162255 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.41, average data length: 0.00 
    Clustering factor: 1703109, ratio: 0.17 
    Fill distribution: 
         0 - 19% = 36 
        20 - 39% = 984 
        40 - 59% = 5335 
        60 - 79% = 1789 
        80 - 99% = 2314 
 
XQS_3300_3400 (187) 
    Primary pointer page: 599, Index root page: 600 
    Total formats: 1, used formats: 1 
    Average record length: 66.83, total records: 581367 
    Average version length: 68.85, total versions: 13106, 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: 5, data page slots: 8048 
    Data pages: 8048, average fill: 76% 
    Primary pages: 8047, secondary pages: 1, swept pages: 2232 
    Empty pages: 4, full pages: 7825 
    Fill distribution: 
     0 - 19% = 4 
    20 - 39% = 4 
    40 - 59% = 46 
    60 - 79% = 7738 
    80 - 99% = 256 
 
    Index XQS_3300_3400_DOC_ID (1) 
    Root page: 54165, depth: 3, leaf buckets: 723, nodes: 581367 
    Average node length: 5.95, total dup: 495086, max dup: 82 
    Average key length: 3.09, compression ratio: 2.91 
    Average prefix length: 8.06, average data length: 0.94 
    Clustering factor: 102093, ratio: 0.18 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 23 
        40 - 59% = 496 
        60 - 79% = 96 
        80 - 99% = 108 
 
    Index XQS_3300_3400_SND_ID (2) 
    Root page: 45360, depth: 3, leaf buckets: 748, nodes: 581367 
    Average node length: 6.15, total dup: 476769, max dup: 25 
    Average key length: 3.29, compression ratio: 2.73 
    Average prefix length: 7.89, average data length: 1.11 
    Clustering factor: 102130, ratio: 0.18 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 22 
        40 - 59% = 510 
        60 - 79% = 105 
        80 - 99% = 111 
 
    Index XQS_3300_3400_WORKER_ID (0) 
    Root page: 377587, depth: 2, leaf buckets: 553, nodes: 581367 
    Average node length: 4.86, total dup: 581267, max dup: 9808 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.42, average data length: 0.00 
    Clustering factor: 90699, ratio: 0.16 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 33 
        40 - 59% = 293 
        60 - 79% = 74 
        80 - 99% = 153 
 
ZDOC_DATA (170) 
    Primary pointer page: 565, Index root page: 566 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
ZDOC_LIST (169) 
    Primary pointer page: 563, Index root page: 564 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
ZINVNT_TURNOVER_LOG (171) 
    Primary pointer page: 567, Index root page: 568 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
ZPDISTR (174) 
    Primary pointer page: 573, Index root page: 574 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index ZPDISTR_ID (0) 
    Root page: 1504230, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
ZPSTORNED (175) 
    Primary pointer page: 575, Index root page: 576 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index ZPSTORNED_ID (0) 
    Root page: 1504229, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
ZQDISTR (172) 
    Primary pointer page: 569, Index root page: 570 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index ZQDISTR_ID (0) 
    Root page: 1504235, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index ZQDISTR_WARE_SNDOP_RCVOP (1) 
    Root page: 1504236, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
ZQSTORNED (173) 
    Primary pointer page: 571, Index root page: 572 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index ZQSTORNED_DOC_ID (1) 
    Root page: 1504232, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index ZQSTORNED_ID (0) 
    Root page: 1504231, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index ZQSTORNED_RCV_ID (3) 
    Root page: 1504234, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index ZQSTORNED_SND_ID (2) 
    Root page: 1504233, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
ZTMP_DEP_DOCS (168) 
    Primary pointer page: 561, Index root page: 562 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
ZTMP_SHOPPING_CART (167) 
    Primary pointer page: 559, Index root page: 560 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
Z_USED_VIEWS (144) 
    Primary pointer page: 512, Index root page: 513 
    Total formats: 1, used formats: 1 
    Average record length: 29.38, total records: 29 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 99.00, compression ratio: 3.37 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 16% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index Z_USED_VIEWS_UNQ (0) 
    Root page: 1510372, depth: 1, leaf buckets: 1, nodes: 29 
    Average node length: 15.17, total dup: 0, max dup: 0 
    Average key length: 14.14, compression ratio: 1.44 
    Average prefix length: 9.17, average data length: 11.17 
    Clustering factor: 1, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
Gstat completion time Wed Apr 10 13:10:19 2024

Record versions statistics, table

TABLE_NAME TOTAL_RECS TOTAL_VERS MAX_VERSIONS VERS_TO_RECS_PRC MAXV_TO_VERS_PRC
DOC_DATA 7707491 52973 1 0.0000 0.0000
DOC_LIST 2224770 26480 2 0.0000 0.0000
FB_ERRORS 2182 757 1 0.0000 0.0000
INVNT_SALDO 400 1027 3 200.0000 0.0000
INVNT_TURNOVER_LOG 73337 45434 1 0.0000 0.0000
MONEY_SALDO 49 130 3 200.0000 0.0000
MONEY_TURNOVER_LOG 1091 956 1 0.0000 0.0000
PDISTR 788342 17939 2 0.0000 0.0000
PERF_SPLIT_0 170503 3056 1 0.0000 0.0000
PERF_SPLIT_1 159518 26443 1 0.0000 0.0000
PERF_SPLIT_2 161661 17201 1 0.0000 0.0000
PERF_SPLIT_3 161406 19617 1 0.0000 0.0000
PERF_SPLIT_4 157650 3538 1 0.0000 0.0000
PERF_SPLIT_5 145057 9477 1 0.0000 0.0000
PERF_SPLIT_6 173166 18880 1 0.0000 0.0000
PERF_SPLIT_7 157607 4994 1 0.0000 0.0000
PERF_SPLIT_8 156254 1964 1 0.0000 0.0000
PERF_SPLIT_9 165154 3317 1 0.0000 0.0000
PSTORNED 2093530 27685 1 0.0000 0.0000
SEMAPHORES 5 1 1 0.0000 100.0000
XQD_1000_1200 114680 35256 1 0.0000 0.0000
XQD_1000_3300 6911932 187454 1 0.0000 0.0000
XQD_1200_2000 11976098 154599 1 0.0000 0.0000
XQD_2000_3300 1417238 263018 1 0.0000 0.0000
XQD_2100_3300 792986 42816 1 0.0000 0.0000
XQD_3300_3400 8891443 170527 1 0.0000 0.0000
XQS_1000_1200 21117461 3416 1 0.0000 0.0000
XQS_1000_3300 10149514 977966 1 0.0000 0.0000
XQS_1200_2000 11569015 697621 1 0.0000 0.0000
XQS_2100_3300 10243235 956495 1 0.0000 0.0000
XQS_3300_3400 581367 13106 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 ---
:404: 
:405: mscs-test-161.budzdorov.ru    Wed Apr 10 13:08:14 2024
:406:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3400
:407: 
--- end of diff output ---

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

10.04.24 13:10:31. 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-04-10 13:10:34 No severe PSQL-related problems occured
10.04.24 13:10:35. End of report.