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

Hardware and OS info

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

Server and database settinfs 


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

Test configuration settings 

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

Test finish info 


FINISH_STATE                    NORMAL: TEST_TIME EXPIRED AT 2024-04-10 01:09:44
DTS_END                         2024-04-10 01:09:44.0240
FB_GDSCODE                      -1
FB_MNEMONA                      
STACK                           SP_ADD_INVOICE_TO_STOCK(190:30) ==> SP_CUSTOMER_RESERVE(47:5) ==> SP_CHECK_TO_STOP_WORK(32:12) ==> SP_HALT_ON_ERROR(57:17)
IP                              ::1/56794
TRN_ID                          168359
ATT_ID                          566
EXC_UNIT                        2

Test workload details

SETTING_NAME SETTING_VALUE
WORKING_MODE SMALL_03
C_WARES_MAX_ID 400
C_CUSTOMER_DOC_MAX_ROWS 10
C_SUPPLIER_DOC_MAX_ROWS 50
C_CUSTOMER_DOC_MAX_QTY 15
C_SUPPLIER_DOC_MAX_QTY 50
C_NUMBER_OF_AGENTS 50

Indexes for heavy-loaded tables

TAB_NAME IDX_NAME IDX_KEY
XQD_1000_1200 XQD_1000_1200_WA_SO_RO_WKR_SND WARE_ID,SND_OPTYPE_ID,RCV_OPTYPE_ID,WORKER_ID,SND_ID
XQD_1000_3300 XQD_1000_3300_WA_SO_RO_WKR_SND WARE_ID,SND_OPTYPE_ID,RCV_OPTYPE_ID,WORKER_ID,SND_ID
XQD_1000_3300 XQD_1000_3300_WKR_DOC_ASC WORKER_ID,DOC_ID
XQD_1000_3300 XQD_1000_3300_WKR_DOC_DEC WORKER_ID,DOC_ID
XQD_1200_2000 XQD_1200_2000_WA_SO_RO_WKR_SND WARE_ID,SND_OPTYPE_ID,RCV_OPTYPE_ID,WORKER_ID,SND_ID
XQD_2000_3300 XQD_2000_3300_WA_SO_RO_WKR_SND WARE_ID,SND_OPTYPE_ID,RCV_OPTYPE_ID,WORKER_ID,SND_ID
XQD_2100_3300 XQD_2100_3300_WA_SO_RO_WKR_SND WARE_ID,SND_OPTYPE_ID,RCV_OPTYPE_ID,WORKER_ID,SND_ID
XQD_3300_3400 XQD_3300_3400_WA_SO_RO_WKR_SND WARE_ID,SND_OPTYPE_ID,RCV_OPTYPE_ID,WORKER_ID,SND_ID

Performance in TOTAL

ACTION AVG_TIMES_PER_MINUTE AVG_ELAPSED_MS SUCCESSFUL_TIMES_DONE
*** OVERALL *** for 100 minutes: 9131.14 24449 913114
customer order: creation 169.13 372 16913
customer order: refuse 14.45 367 1445
order to supplier: creation 43.70 1343 4370
order to supplier: removal 3.67 97674 367
invoice (draft): creation 44.73 3544 4473
invoice (draft): removal 52.14 775 5214
invoice accept: apply 39.96 21408 3996
invoice accept: cancel 47.22 992 4722
customer reserve: creation 3824.03 205 382403
customer reserve: removal 4601.18 62 460118
realization accept: apply 79.87 211 7987
realization accept: cancel 85.81 121 8581
payment from customer: creation 56.33 141 5633
payment from customer: removal 5.58 113 558
payment to supplier: creation 48.27 162 4827
payment to supplier: removal 3.39 139 339
service: total inventory turnovers 4.52 1162 452
service: total monetary turnovers 6.39 28 639
service: aggregate perf. data 0.74 18214 74
service: refresh index statistics 0.03 341944 3

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:03, from 10-04-2024 01:11:00 to 10-04-2024 01:11:03.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 1225
TEST_TIME 2 2114
TEST_TIME 3 3410
TEST_TIME 4 3067
TEST_TIME 5 3101
TEST_TIME 6 3524
TEST_TIME 7 3809
TEST_TIME 8 4206
TEST_TIME 9 4144
TEST_TIME 10 4659
TEST_TIME 11 4859
TEST_TIME 12 5101
TEST_TIME 13 5427
TEST_TIME 14 5875
TEST_TIME 15 6352
TEST_TIME 16 6752
TEST_TIME 17 6971
TEST_TIME 18 7055
TEST_TIME 19 7411
TEST_TIME 20 7436
TEST_TIME 21 7835
TEST_TIME 22 8173
TEST_TIME 23 8228
TEST_TIME 24 8263
TEST_TIME 25 9414
TEST_TIME 26 9630
TEST_TIME 27 9308
TEST_TIME 28 9284
TEST_TIME 29 9338
TEST_TIME 30 9470
TEST_TIME 31 9359
TEST_TIME 32 9228
TEST_TIME 33 9123
TEST_TIME 34 9053
TEST_TIME 35 8982
TEST_TIME 36 9042
TEST_TIME 37 8883
TEST_TIME 38 8830
TEST_TIME 39 8767
TEST_TIME 40 8775
TEST_TIME 41 8759
TEST_TIME 42 8661
TEST_TIME 43 8595
TEST_TIME 44 8545
TEST_TIME 45 8708
TEST_TIME 46 8984
TEST_TIME 47 9186
TEST_TIME 48 9157
TEST_TIME 49 9196
TEST_TIME 50 9123
TEST_TIME 51 9087
TEST_TIME 52 9152
TEST_TIME 53 9161
TEST_TIME 54 9219
TEST_TIME 55 9197
TEST_TIME 56 9169
TEST_TIME 57 9260
TEST_TIME 58 9223
TEST_TIME 59 9309
TEST_TIME 60 9235
TEST_TIME 61 9163
TEST_TIME 62 9053
TEST_TIME 63 9050
TEST_TIME 64 9031
TEST_TIME 65 9031
TEST_TIME 66 8970
TEST_TIME 67 9036
TEST_TIME 68 8982
TEST_TIME 69 8901
TEST_TIME 70 8853
TEST_TIME 71 8943
TEST_TIME 72 8980
TEST_TIME 73 8998
TEST_TIME 74 8960
TEST_TIME 75 9028
TEST_TIME 76 9117
TEST_TIME 77 9072
TEST_TIME 78 9100
TEST_TIME 79 9153
TEST_TIME 80 9219
TEST_TIME 81 9253
TEST_TIME 82 9235
TEST_TIME 83 9225
TEST_TIME 84 9311
TEST_TIME 85 9226
TEST_TIME 86 9206
TEST_TIME 87 9148
TEST_TIME 88 9137
TEST_TIME 89 9106
TEST_TIME 90 9086
TEST_TIME 91 9035
TEST_TIME 92 9010
TEST_TIME 93 9042
TEST_TIME 94 9101
TEST_TIME 95 9067
TEST_TIME 96 9051
TEST_TIME 97 9119
TEST_TIME 98 9094
TEST_TIME 99 9128
TEST_TIME 100 9133

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:03, from 10-04-2024 01:11:04 to 10-04-2024 01:11:07.

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 1263758 1263758 0 0.00 0 22886 7 0 0
doc_list_biud 1263758 1263758 0 0.00 0 60568 29 0 0
sp_add_invoice_to_stock 4077 3996 81 1.98 55 193996 21408 0 81
sp_cancel_adding_invoice 4722 4722 0 0.00 4 68216 992 0 0
sp_cancel_client_order 1445 1445 0 0.00 4 13876 368 0 0
sp_cancel_customer_reserve 460118 460118 0 0.00 0 60569 62 0 0
sp_cancel_pay_from_customer 558 558 0 0.00 2 14068 114 0 0
sp_cancel_pay_to_supplier 339 339 0 0.00 3 12239 139 0 0
sp_cancel_supplier_invoice 5220 5214 6 0.11 1 15824 775 0 6
sp_cancel_supplier_order 367 367 0 0.00 7 877289 97674 0 0
sp_cancel_write_off 8581 8581 0 0.00 1 7628 121 0 0
sp_client_order 16913 16913 0 0.00 3 21916 373 0 0
sp_customer_reserve 382403 382403 0 0.00 0 51542 206 0 0
sp_fill_shopping_cart 25754 25754 0 0.00 1 31956 41 0 0
sp_fill_shopping_cart_clo_res 382401 382401 0 0.00 0 16499 17 0 0
sp_get_clo_for_invoice 3994 3994 0 0.00 0 22980 340 0 0
sp_kill_cost_storno 14200 14200 0 0.00 0 6122 62 0 0
sp_kill_qstorno_ret_qs2qd 934398 934398 0 0.00 0 60565 33 0 0
sp_kill_qty_storno 492428 492428 0 0.00 0 60568 73 0 0
sp_lock_selected_doc 16758 16758 0 0.00 0 6942 7 0 0
sp_make_cost_storno 22441 22441 0 0.00 0 21539 76 0 0
sp_multiply_rows_for_pdistr 22441 22441 0 0.00 0 14972 32 0 0
sp_multiply_rows_for_qdistr 16913 16913 0 0.00 0 12061 169 0 0
sp_pay_from_customer 5633 5633 0 0.00 4 16104 141 0 0
sp_pay_to_supplier 4827 4827 0 0.00 4 30331 162 0 0
sp_payment_common 10460 10460 0 0.00 1 30301 45 0 0
sp_qd_handle_on_cancel_clo 1445 1445 0 0.00 0 13866 346 0 0
sp_qd_handle_on_invoice_upd_sts 8716 8716 0 0.00 0 27488 364 0 0
sp_qd_handle_on_reserve_upd_sts 7987 7987 0 0.00 0 16386 62 0 0
sp_reserve_write_off 7987 7987 0 0.00 6 16398 212 0 0
sp_supplier_invoice 4473 4473 0 0.00 6 110832 3545 0 0
sp_supplier_order 4370 4370 0 0.00 5 38237 1343 0 0
srv_aggregate_perf_data 75 74 1 1.33 2259 339642 18215 0 1
srv_fill_mon_cache_memory 55 55 0 0.00 1434 123119 44083 0 0
srv_find_qd_qs_mism 872416 872416 0 0.00 0 22885 6 0 0
srv_make_invnt_saldo 452 452 0 0.00 55 27694 1162 0 0
srv_make_money_saldo 639 639 0 0.00 1 2109 29 0 0
srv_recalc_idx_stat 3 3 0 0.00 183248 522013 341945 0 0
t$perf-abend:sp_add_invoice_to_stock 81 81 0 0.00 0 0 0 0 0
t$perf-abend:sp_cancel_supplier_invoice 6 6 0 0.00 0 0 0 0 0
t$perf-abend:srv_aggregate_perf_data 1 1 0 0.00 0 0 0 0 0
t$perf-norm:sp_add_invoice_to_stock 3996 3996 0 0.00 0 5369 153 0 0
t$perf-norm:sp_cancel_adding_invoice 361 361 0 0.00 0 3885 129 0 0
t$perf-norm:sp_cancel_client_order 1445 1445 0 0.00 0 1112 10 0 0
t$perf-norm:sp_cancel_customer_reserve 571 571 0 0.00 0 1079 14 0 0
t$perf-norm:sp_cancel_pay_from_customer 558 558 0 0.00 0 800 5 0 0
t$perf-norm:sp_cancel_pay_to_supplier 339 339 0 0.00 0 833 5 0 0
t$perf-norm:sp_cancel_supplier_invoice 332 332 0 0.00 0 1869 28 0 0
t$perf-norm:sp_cancel_supplier_order 367 367 0 0.00 0 35019 1732 0 0
t$perf-norm:sp_cancel_write_off 804 804 0 0.00 0 2654 10 0 0
t$perf-norm:sp_client_order 16913 16913 0 0.00 0 8303 17 0 0
t$perf-norm:sp_customer_reserve 819 819 0 0.00 0 1599 8 0 0
t$perf-norm:sp_pay_from_customer 5633 5633 0 0.00 0 6689 13 0 0
t$perf-norm:sp_pay_to_supplier 4827 4827 0 0.00 0 5094 12 0 0
t$perf-norm:sp_reserve_write_off 7987 7987 0 0.00 0 10628 13 0 0
t$perf-norm:sp_supplier_invoice 4473 4473 0 0.00 0 8322 19 0 0
t$perf-norm:sp_supplier_order 4370 4370 0 0.00 0 4552 20 0 0
t$perf-norm:srv_aggregate_perf_data 74 74 0 0.00 0 331 9 0 0
t$perf-norm:srv_fill_mon_cache_memory 55 55 0 0.00 0 755 15 0 0
t$perf-norm:srv_make_invnt_saldo 452 452 0 0.00 0 1912 26 0 0
t$perf-norm:srv_make_money_saldo 639 639 0 0.00 0 1429 17 0 0
t$perf-norm:srv_recalc_idx_stat 3 3 0 0.00 1 10 5 0 0
v_add_invoice_to_stock 8150 7988 162 1.98 0 21696 26 0 162
v_all_customers 31122 31122 0 0.00 0 22 1 0 0
v_all_suppliers 25478 25478 0 0.00 0 21 1 0 0
v_all_wares 33826 33826 0 0.00 0 104 1 0 0
v_cancel_adding_invoice 722 722 0 0.00 0 3534 12 0 0
v_cancel_client_order 2890 2890 0 0.00 0 1559 4 0 0
v_cancel_customer_prepayment 1116 1116 0 0.00 0 14052 22 0 0
v_cancel_customer_reserve 1142 1142 0 0.00 0 14112 35 0 0
v_cancel_payment_to_supplier 678 678 0 0.00 0 12182 29 0 0
v_cancel_supplier_invoice 676 664 12 1.77 0 477 13 0 12
v_cancel_supplier_order 734 734 0 0.00 0 2809 8 0 0
v_cancel_write_off 1608 1608 0 0.00 0 7481 21 0 0
v_max_id_clo_ord 4370 4370 0 0.00 0 3092 2 0 0
v_max_id_clo_res 819 819 0 0.00 0 1366 8 0 0
v_max_id_ord_sup 4471 4471 0 0.00 0 3295 6 0 0
v_max_non_paid_invoice 929 929 0 0.00 0 2872 9 0 0
v_max_non_paid_realizn 2794 2794 0 0.00 0 2858 7 0 0
v_min_id_clo_ord 4370 4370 0 0.00 0 5113 9 0 0
v_min_id_clo_res 819 819 0 0.00 0 9841 15 0 0
v_min_id_ord_sup 4471 4471 0 0.00 0 4329 6 0 0
v_min_non_paid_invoice 4827 4827 0 0.00 0 30295 33 0 0
v_min_non_paid_realizn 5633 5633 0 0.00 0 12825 37 0 0
v_our_firm 8382 8382 0 0.00 0 22 1 0 0
v_reserve_write_off 15974 15974 0 0.00 0 14072 11 0 0
x_lock_depdocs_on_canc_invoice 9604 9604 0 0.00 0 12836 149 0 0
x_lock_depdocs_on_canc_sup_ord 367 367 0 0.00 0 17508 413 0 0
x_make_qstorno_1000_1200 4370 4370 0 0.00 1 38226 1258 0 0
x_make_qstorno_1200_2000 4473 4473 0 0.00 3 110791 3394 0 0
x_make_qstorno_2100_3300 382403 382403 0 0.00 0 44600 186 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 10-04-2024 01:11:08 to 10-04-2024 01:11:12.

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
23:09:47 2 8192000000 8797116944 8807743488 3953616 0.048 1 1 2 0 4051888 55488 42784
23:10:49 31509 8192000000 9903551968 10212581376 973308864 10.619 100 87 174 0 1002596704 5993248 23294592
23:12:28 18943 8192000000 9942372000 10262220800 1023484448 11.106 100 91 182 0 1054690832 8268544 22937840
23:13:49 17206 8192000000 9968622496 10298482688 1057386048 11.431 100 83 166 0 1087136096 9598144 20151904
23:15:14 9318 8192000000 10021770912 10371457024 1112401824 11.955 100 71 142 0 1138869824 9790128 16677872
23:16:29 6961 8192000000 10075412816 10434129920 1164676576 12.447 100 80 159 1 1194973952 11535264 18762112
23:17:40 2722 8192000000 10133200752 10499649536 1215775232 12.923 100 85 171 0 1247124432 12731808 18617392
23:18:45 1773 8192000000 10156321856 10529558528 1244387296 13.187 100 81 162 0 1275989248 14235456 17366496
23:19:48 1765 8192000000 10178292080 10558160896 1263364992 13.361 100 77 154 1 1293711920 13446336 16900592
23:20:52 2032 8192000000 10209242640 10595971072 1294927328 13.649 100 82 164 0 1326436960 13533872 17975760
23:21:56 35205 8192000000 10197951056 10601897984 1297594304 13.673 100 43 87 2 1313378016 5038096 10745616
23:23:31 8140 8192000000 10193354256 10611728384 1309479136 13.781 100 24 48 2 1321967216 6269280 6218800
23:24:42 12271 8192000000 10204353280 10619142144 1314511008 13.827 100 23 47 0 1325576848 5781856 5283984
23:25:59 7862 8192000000 10202953616 10624450560 1320123472 13.878 100 19 38 0 1330514288 6206736 4184080
23:27:08 36090 8192000000 10211488560 10635108352 1322774112 13.902 100 29 58 2 1334740096 5087888 6878096
23:28:46 9659 8192000000 10219186768 10639994880 1325862544 13.930 100 24 47 1 1336641712 5900592 4878576
23:30:01 53538 8192000000 10235272016 10646409216 1325022896 13.922 100 36 71 1 1338628816 5671376 7934544
23:32:03 22308 8192000000 10267714608 10671755264 1323612976 13.909 98 61 122 0 1353970576 16344912 14012688
23:33:30 91050 8192000000 10246524288 10661560320 1298531440 13.682 97 43 86 0 1324612496 15798832 10282224
23:36:22 57569 8192000000 10232606848 10647388160 1265820320 13.383 94 28 56 0 1292546736 19897472 6828944
23:38:26 12065 8192000000 10233839552 10636976128 1297818000 13.675 98 55 106 0 1330788256 19794160 13176096
23:39:42 32547 8192000000 10233165552 10643632128 1299214368 13.688 98 39 76 1 1327345824 19151712 8979744
23:41:18 19318 8192000000 10235892880 10634702848 1302525648 13.718 100 55 109 0 1343905824 28560848 12819328
23:42:47 3492 8192000000 10267000320 10659688448 1322091472 13.896 100 74 145 4 1372221952 32875072 17255408
23:43:54 1908 8192000000 10286079136 10685706240 1338638256 14.045 100 74 142 1 1393577552 37100304 17838992
23:45:06 5520 8192000000 10291027232 10695319552 1348037328 14.130 100 79 155 1 1399947840 32586656 19323856
23:46:21 2782 8192000000 10296628864 10700996608 1357054448 14.211 100 67 134 2 1398509920 25239616 16215856
23:47:28 6063 8192000000 10321969472 10725085184 1374730592 14.369 100 89 174 2 1424897984 29276992 20890400
23:48:38 1433 8192000000 10324886704 10730397696 1379245072 14.410 100 83 164 0 1431266944 30316848 21705024
23:49:43 9900 8192000000 10324271216 10729553920 1374810496 14.370 100 70 137 2 1423020176 30426176 17783504
23:50:58 19461 8192000000 10307196336 10740932608 1383465760 14.448 100 29 56 0 1423933664 32904448 7563456
23:52:19 19363 8192000000 10308115200 10742091776 1374232432 14.365 100 26 52 0 1421075840 39236192 7607216
23:53:57 9820 8192000000 10330864096 10754338816 1378226640 14.401 100 53 106 1 1439351504 47249664 13875200
23:55:09 78318 8192000000 10298318992 10733506560 1379519504 14.412 100 21 43 1 1398632944 13888976 5224464
23:57:35 5972 8192000000 10299924640 10743525376 1387871776 14.487 100 33 66 2 1411749840 16707584 7170480
23:58:47 23440 8192000000 10300329280 10755731456 1399071600 14.587 100 17 34 0 1419301520 16361344 3868576
00:00:12 87378 8192000000 10296323856 10747981824 1381569072 14.431 99 15 28 1 1394991536 9828128 3594336
00:02:39 112446 8192000000 10295856464 10751291392 1384182128 14.454 99 41 82 1 1412048000 17673584 10192288
00:05:37 42063 8192000000 10311428608 10758746112 1403192288 14.623 100 20 40 0 1421215728 12851696 5171744
00:07:22 36781 8192000000 10322277072 10774999040 1417566096 14.751 100 28 56 0 1441330144 17164096 6599952
00:09:01 21047 8192000000 10332055184 10784366592 1417065904 14.747 100 29 57 3 1444003296 19386832 7550560
00:10:29 57565 8192000000 10350570736 10808926208 1432050144 14.879 100 27 54 0 1468069344 29110544 6908656
00:12:51 100501 8192000000 10336786544 10797182976 1411272496 14.695 99 20 40 0 1447947632 31589536 5085600
00:15:43 78284 8192000000 10301351568 10775584768 1370092976 14.328 97 7 14 0 1392478928 20753440 1632512
00:18:02 18675 8192000000 10296547056 10737881088 1372730240 14.352 98 38 72 1 1389323216 7872064 8720912
00:19:25 22690 8192000000 10289005168 10732978176 1377896320 14.398 99 55 106 2 1399702832 8396352 13410160
00:21:18 17570 8192000000 10293945872 10738216960 1385952128 14.470 100 27 54 0 1400366080 8492624 5921328
00:22:36 123119 8192000000 10286816368 10743480320 1349223920 14.140 97 14 28 0 1365228128 13125968 2878240
00:25:39 45465 8192000000 10249265824 10692866048 1290762560 13.611 95 26 52 0 1315066832 18876096 5428176
00:27:26 43709 8192000000 10266920240 10704396288 1330216064 13.969 98 20 40 0 1346665264 11849872 4599328
00:29:15 86672 8192000000 10273270368 10713518080 1348803056 14.137 99 32 63 1 1368089312 12372752 6913504
00:31:54 14724 8192000000 10263542864 10695327744 1344869456 14.101 99 37 74 0 1363249360 9205056 9174848
00:33:09 21149 8192000000 10260651488 10686898176 1331287856 13.979 99 46 92 1 1350329168 8759216 10282096
00:34:39 66247 8192000000 10258728256 10705444864 1345887008 14.110 99 11 22 0 1363521360 15131008 2503344
00:36:47 22553 8192000000 10262719232 10708484096 1351332512 14.159 99 12 24 0 1366299280 12172224 2794544
00:38:22 57778 8192000000 10255733168 10698964992 1347778416 14.127 99 15 30 0 1361923600 10672752 3472432
00:40:41 36685 8192000000 10250455760 10693193728 1328317600 13.952 97 7 14 0 1341255056 11827952 1109504
00:42:30 54210 8192000000 10289127648 10726109184 1363715216 14.271 99 23 47 0 1378325504 9283456 5326832
00:44:25 72455 8192000000 10294975168 10747387904 1383862080 14.451 100 7 14 0 1400768736 15457440 1449216
00:46:37 41888 8192000000 10311765056 10750148608 1392597232 14.529 100 30 60 0 1410343088 10814816 6931040
00:48:25 57902 8192000000 10311837600 10757259264 1380604576 14.422 99 25 46 0 1400458448 15034048 4819824
00:50:37 34240 8192000000 10303164688 10748264448 1394679744 14.548 100 18 36 0 1407469632 8654768 4135120
00:52:12 5826 8192000000 10326025216 10752585728 1395639424 14.556 100 64 128 0 1420318464 10401488 14277552
00:53:20 46366 8192000000 10321532912 10773164032 1403319472 14.625 100 15 26 0 1421965344 16012048 2633824
00:55:08 110670 8192000000 10301313216 10757767168 1377011392 14.390 98 29 58 0 1394160960 10522720 6626848
00:58:03 83637 8192000000 10292363776 10764734464 1398423008 14.581 100 7 14 0 1414525248 14296464 1805776
01:00:28 64373 8192000000 10298100656 10747711488 1341540960 14.071 95 21 41 0 1362494000 15538592 5414448
01:02:32 93235 8192000000 10284209648 10760409088 1346287984 14.114 97 8 16 0 1365751488 17595328 1868176
01:05:07 41854 8192000000 10294943296 10745110528 1379128144 14.409 99 32 64 1 1396057664 9486736 7442784
01:06:52 76852 8192000000 10300261536 10741739520 1338870016 14.047 96 24 48 1 1353762272 9565312 5326944
01:09:13 52006 8192000000 9105122528 9330327552 257666688 3.049 19 3 6 0 261809664 3520272 622704

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 01:11:14 to 10-04-2024 01:11:28.

Exceptions occured during test was in run

FB_MNEMONA CNT UNIT FB_GDSCODE
except 1 srv_aggregate_perf_data 335544517
except 81 v_add_invoice_to_stock 335544517
except 6 v_cancel_supplier_invoice 335544517

Completed "Exceptions occured during test was in run". Done for 00:00:02, from 10-04-2024 01:11:29 to 10-04-2024 01:11:31.

Content of mon$database and FB version 


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


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

Database statistics 

 
Database "/home/bases/oltp30-etalone.fdb" 
Gstat execution time Wed Apr 10 01:11:32 2024 
 
Database header page information: 
    Flags            0 
    Generation        88794 
    System Change Number    0 
    Page size        8192 
    ODS version        12.0 
    Oldest transaction    170419 
    Oldest active        170420 
    Oldest snapshot        170420 
    Next transaction    170421 
    Sequence number        0 
    Next attachment ID    698 
    Implementation        HW=AMD/Intel/x64 little-endian OS=Linux CC=gcc 
    Shadow count        0 
    Page buffers        0 
    Next header page    0 
    Database dialect    3 
    Creation date        Apr 3, 2020 16:41:55 
    Attributes        force write 
 
    Variable header data: 
    Sweep interval:        0 
    Unrecognized option 11, length 16 
    *END* 
 
 
Database file sequence: 
File /home/bases/oltp30-etalone.fdb is the only file 
 
Analyzing database pages ... 
AGENTS (150) 
    Primary pointer page: 496, Index root page: 497 
    Total formats: 1, used formats: 1 
    Average record length: 33.60, total records: 50 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 344.00, compression ratio: 10.24 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 31% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 1 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index AGENTS_ID_DESC (2) 
    Root page: 1504311, depth: 1, leaf buckets: 1, nodes: 50 
    Average node length: 11.82, total dup: 0, max dup: 0 
    Average key length: 10.80, compression ratio: 0.83 
    Average prefix length: 1.18, average data length: 7.82 
    Clustering factor: 1, ratio: 0.02 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index AGENTS_IS_OUR_FIRM (4) 
    Root page: 1504313, depth: 1, leaf buckets: 1, nodes: 50 
    Average node length: 3.08, total dup: 48, max dup: 48 
    Average key length: 2.04, compression ratio: 0.50 
    Average prefix length: 0.96, average data length: 0.06 
    Clustering factor: 1, ratio: 0.02 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index AGENTS_IS_SUPPLIER (3) 
    Root page: 1504312, depth: 1, leaf buckets: 1, nodes: 50 
    Average node length: 3.08, total dup: 48, max dup: 44 
    Average key length: 2.04, compression ratio: 0.54 
    Average prefix length: 1.04, average data length: 0.06 
    Clustering factor: 1, ratio: 0.02 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index AGENTS_NAME_UNQ (1) 
    Root page: 1504310, depth: 1, leaf buckets: 1, nodes: 50 
    Average node length: 17.20, total dup: 0, max dup: 0 
    Average key length: 15.88, compression ratio: 0.92 
    Average prefix length: 1.42, average data length: 13.20 
    Clustering factor: 1, ratio: 0.02 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PK_AGENTS (0) 
    Root page: 1504309, depth: 1, leaf buckets: 1, nodes: 50 
    Average node length: 11.82, total dup: 0, max dup: 0 
    Average key length: 10.80, compression ratio: 0.83 
    Average prefix length: 1.18, average data length: 7.82 
    Clustering factor: 1, ratio: 0.02 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
BUSINESS_OPS (154) 
    Primary pointer page: 504, Index root page: 505 
    Total formats: 1, used formats: 1 
    Average record length: 108.20, total records: 20 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1235.00, compression ratio: 11.41 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 31% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 1 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index BO_UNIT_UNQ (1) 
    Root page: 1504242, depth: 1, leaf buckets: 1, nodes: 20 
    Average node length: 18.25, total dup: 0, max dup: 0 
    Average key length: 17.20, compression ratio: 1.24 
    Average prefix length: 7.05, average data length: 14.25 
    Clustering factor: 1, ratio: 0.05 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index BUSINESS_OPS_PREDICT_PRIOR (3) 
    Root page: 1504244, depth: 1, leaf buckets: 1, nodes: 20 
    Average node length: 5.40, total dup: 0, max dup: 0 
    Average key length: 4.35, compression ratio: 0.67 
    Average prefix length: 1.20, average data length: 1.70 
    Clustering factor: 1, ratio: 0.05 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index BUSINESS_OPS_RND_WGTH (2) 
    Root page: 1504243, depth: 1, leaf buckets: 1, nodes: 20 
    Average node length: 4.30, total dup: 6, max dup: 3 
    Average key length: 3.25, compression ratio: 0.72 
    Average prefix length: 1.35, average data length: 1.00 
    Clustering factor: 1, ratio: 0.05 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index RDB$1 (0) 
    Root page: 1504241, depth: 1, leaf buckets: 1, nodes: 20 
    Average node length: 5.20, total dup: 0, max dup: 0 
    Average key length: 4.15, compression ratio: 0.65 
    Average prefix length: 1.10, average data length: 1.60 
    Clustering factor: 1, ratio: 0.05 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
DOC_DATA (139) 
    Primary pointer page: 474, Index root page: 475 
    Total formats: 1, used formats: 1 
    Average record length: 47.02, total records: 7723936 
    Average version length: 48.16, total versions: 141098, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 64.00, compression ratio: 1.36 
    Pointer pages: 53, data page slots: 86384 
    Data pages: 86384, average fill: 72% 
    Primary pages: 86384, secondary pages: 0, swept pages: 13002 
    Empty pages: 1, full pages: 67474 
    Fill distribution: 
     0 - 19% = 18 
    20 - 39% = 156 
    40 - 59% = 2594 
    60 - 79% = 83567 
    80 - 99% = 49 
 
    Index DOC_DATA_DOC_WARE_UNQ (0) 
    Root page: 1510614, depth: 3, leaf buckets: 23085, nodes: 7723936 
    Average node length: 18.87, total dup: 0, max dup: 0 
    Average key length: 15.88, compression ratio: 1.70 
    Average prefix length: 14.11, average data length: 12.89 
    Clustering factor: 1715996, ratio: 0.22 
    Fill distribution: 
         0 - 19% = 328 
        20 - 39% = 1656 
        40 - 59% = 4089 
        60 - 79% = 2429 
        80 - 99% = 14583 
 
    Index DOC_DATA_ID_DESC (1) 
    Root page: 1528118, depth: 3, leaf buckets: 13426, nodes: 7723936 
    Average node length: 11.20, total dup: 0, max dup: 0 
    Average key length: 8.21, compression ratio: 1.10 
    Average prefix length: 3.79, average data length: 5.21 
    Clustering factor: 1538656, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 1467 
        40 - 59% = 2060 
        60 - 79% = 1145 
        80 - 99% = 8754 
 
    Index FK_DOC_DATA_DOC_LIST (2) 
    Root page: 1546711, depth: 3, leaf buckets: 8260, nodes: 7723936 
    Average node length: 6.61, total dup: 5786903, max dup: 49 
    Average key length: 3.62, compression ratio: 2.49 
    Average prefix length: 7.63, average data length: 1.37 
    Clustering factor: 1531862, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 125 
        20 - 39% = 915 
        40 - 59% = 1347 
        60 - 79% = 941 
        80 - 99% = 4932 
 
DOC_LIST (138) 
    Primary pointer page: 472, Index root page: 473 
    Total formats: 1, used formats: 1 
    Average record length: 55.62, total records: 2224398 
    Average version length: 34.56, total versions: 135943, max versions: 3 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 84.00, compression ratio: 1.51 
    Pointer pages: 18, data page slots: 28208 
    Data pages: 28208, average fill: 73% 
    Primary pages: 28203, secondary pages: 5, swept pages: 7540 
    Empty pages: 1, full pages: 20723 
    Fill distribution: 
     0 - 19% = 24 
    20 - 39% = 151 
    40 - 59% = 1794 
    60 - 79% = 24927 
    80 - 99% = 1312 
 
    Index DOC_LIST_ID_DESC (1) 
    Root page: 1541130, depth: 3, leaf buckets: 4487, nodes: 2224398 
    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: 686542, ratio: 0.31 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 824 
        40 - 59% = 877 
        60 - 79% = 766 
        80 - 99% = 2020 
 
    Index DOC_LIST_WORKER_OPTYPE (2) 
    Root page: 1544376, depth: 3, leaf buckets: 2516, nodes: 2227484 
    Average node length: 4.97, total dup: 2226585, max dup: 18838 
    Average key length: 2.01, compression ratio: 4.47 
    Average prefix length: 8.99, average data length: 0.01 
    Clustering factor: 1239563, ratio: 0.56 
    Fill distribution: 
         0 - 19% = 6 
        20 - 39% = 245 
        40 - 59% = 1591 
        60 - 79% = 505 
        80 - 99% = 169 
 
    Index FK_DOC_LIST_AGENTS (3) 
    Root page: 1545909, depth: 3, leaf buckets: 1970, nodes: 2224398 
    Average node length: 4.97, total dup: 2224348, max dup: 130135 
    Average key length: 2.01, compression ratio: 4.48 
    Average prefix length: 8.99, average data length: 0.01 
    Clustering factor: 1049883, ratio: 0.47 
    Fill distribution: 
         0 - 19% = 4 
        20 - 39% = 82 
        40 - 59% = 956 
        60 - 79% = 54 
        80 - 99% = 874 
 
    Index PK_DOC_LIST (0) 
    Root page: 1538187, depth: 3, leaf buckets: 4275, nodes: 2224398 
    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: 686542, ratio: 0.31 
    Fill distribution: 
         0 - 19% = 103 
        20 - 39% = 502 
        40 - 59% = 634 
        60 - 79% = 841 
        80 - 99% = 2195 
 
DOC_STATES (149) 
    Primary pointer page: 494, Index root page: 495 
    Total formats: 1, used formats: 1 
    Average record length: 67.50, total records: 4 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 650.00, compression ratio: 9.63 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 4% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index DOC_STATES_MCODE_UNQ (1) 
    Root page: 1504315, depth: 1, leaf buckets: 1, nodes: 4 
    Average node length: 17.75, total dup: 0, max dup: 0 
    Average key length: 16.50, compression ratio: 1.08 
    Average prefix length: 4.00, average data length: 13.75 
    Clustering factor: 1, ratio: 0.25 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index DOC_STATES_NAME_UNQ (2) 
    Root page: 1504316, depth: 1, leaf buckets: 1, nodes: 4 
    Average node length: 33.25, total dup: 0, max dup: 0 
    Average key length: 32.00, compression ratio: 0.99 
    Average prefix length: 2.50, average data length: 29.25 
    Clustering factor: 1, ratio: 0.25 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PK_DOC_STATES (0) 
    Root page: 1504314, depth: 1, leaf buckets: 1, nodes: 4 
    Average node length: 4.75, total dup: 0, max dup: 0 
    Average key length: 3.50, compression ratio: 0.86 
    Average prefix length: 1.50, average data length: 1.50 
    Clustering factor: 1, ratio: 0.25 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
FB_ERRORS (155) 
    Primary pointer page: 506, Index root page: 507 
    Total formats: 2, used formats: 2 
    Average record length: 54.76, total records: 2182 
    Average version length: 79.61, total versions: 757, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 270.43, compression ratio: 4.94 
    Pointer pages: 1, data page slots: 40 
    Data pages: 40, average fill: 70% 
    Primary pages: 40, secondary pages: 0, swept pages: 0 
    Empty pages: 7, full pages: 32 
    Fill distribution: 
     0 - 19% = 7 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 7 
    80 - 99% = 26 
 
    Index FB_ERRORS_GDS_CODE (0) 
    Root page: 382, depth: 2, leaf buckets: 2, nodes: 2182 
    Average node length: 4.40, total dup: 756, max dup: 1 
    Average key length: 2.67, compression ratio: 1.87 
    Average prefix length: 4.33, average data length: 0.67 
    Clustering factor: 1515, ratio: 0.69 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 0 
        40 - 59% = 1 
        60 - 79% = 1 
        80 - 99% = 0 
 
INVNT_SALDO (145) 
    Primary pointer page: 486, Index root page: 487 
    Total formats: 2, used formats: 1 
    Average record length: 82.64, total records: 400 
    Average version length: 22.98, total versions: 224907, max versions: 594 
    Average fragment length: 2.00, total fragments: 37, max fragments: 1 
    Average unpacked length: 104.00, compression ratio: 1.26 
    Pointer pages: 1, data page slots: 1224 
    Data pages: 1224, average fill: 91% 
    Primary pages: 7, secondary pages: 1217, swept pages: 0 
    Empty pages: 0, full pages: 1223 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 1 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 1223 
 
    Index PK_INVNT_SALDO (0) 
    Root page: 1510349, depth: 1, leaf buckets: 1, nodes: 400 
    Average node length: 11.22, total dup: 0, max dup: 0 
    Average key length: 10.22, compression ratio: 0.88 
    Average prefix length: 1.78, average data length: 7.22 
    Clustering factor: 326, ratio: 0.81 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 0 
        40 - 59% = 1 
        60 - 79% = 0 
        80 - 99% = 0 
 
INVNT_TURNOVER_LOG (153) 
    Primary pointer page: 502, Index root page: 503 
    Total formats: 1, used formats: 1 
    Average record length: 13.00, total records: 111989 
    Average version length: 68.29, total versions: 90672, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 88.00, compression ratio: 6.77 
    Pointer pages: 7, data page slots: 3576 
    Data pages: 2336, average fill: 59% 
    Primary pages: 2336, secondary pages: 0, swept pages: 0 
    Empty pages: 503, full pages: 1320 
    Fill distribution: 
     0 - 19% = 592 
    20 - 39% = 109 
    40 - 59% = 185 
    60 - 79% = 336 
    80 - 99% = 1114 
 
    Index INVNT_TURNOVER_LOG_WARE_DD_ID (0) 
    Root page: 1697391, depth: 3, leaf buckets: 402, nodes: 111989 
    Average node length: 13.34, total dup: 8466, max dup: 2 
    Average key length: 10.64, compression ratio: 2.54 
    Average prefix length: 19.28, average data length: 7.72 
    Clustering factor: 82027, ratio: 0.73 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 83 
        40 - 59% = 301 
        60 - 79% = 17 
        80 - 99% = 0 
 
MONEY_SALDO (141) 
    Primary pointer page: 478, Index root page: 479 
    Total formats: 1, used formats: 1 
    Average record length: 15.22, total records: 49 
    Average version length: 9.00, total versions: 16897, max versions: 937 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 32.00, compression ratio: 2.10 
    Pointer pages: 1, data page slots: 64 
    Data pages: 64, average fill: 85% 
    Primary pages: 4, secondary pages: 60, swept pages: 0 
    Empty pages: 3, full pages: 60 
    Fill distribution: 
     0 - 19% = 3 
    20 - 39% = 1 
    40 - 59% = 0 
    60 - 79% = 3 
    80 - 99% = 57 
 
    Index PK_MONEY_SALDO (0) 
    Root page: 1510361, depth: 1, leaf buckets: 1, nodes: 49 
    Average node length: 11.82, total dup: 0, max dup: 0 
    Average key length: 10.80, compression ratio: 0.83 
    Average prefix length: 1.18, average data length: 7.82 
    Clustering factor: 1, ratio: 0.02 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
MONEY_TURNOVER_LOG (140) 
    Primary pointer page: 476, Index root page: 477 
    Total formats: 1, used formats: 1 
    Average record length: 7.17, total records: 1826 
    Average version length: 43.63, total versions: 1536, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 58.00, compression ratio: 8.09 
    Pointer pages: 1, data page slots: 96 
    Data pages: 39, average fill: 45% 
    Primary pages: 38, secondary pages: 1, swept pages: 0 
    Empty pages: 10, full pages: 14 
    Fill distribution: 
     0 - 19% = 15 
    20 - 39% = 3 
    40 - 59% = 2 
    60 - 79% = 8 
    80 - 99% = 11 
 
    Index MONEY_TURNOVER_LOG_AGENT_OPTYPE (0) 
    Root page: 92163, depth: 2, leaf buckets: 3, nodes: 1826 
    Average node length: 4.20, total dup: 1729, max dup: 207 
    Average key length: 2.57, compression ratio: 7.40 
    Average prefix length: 18.48, average data length: 0.52 
    Clustering factor: 972, ratio: 0.53 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 1 
        40 - 59% = 1 
        60 - 79% = 0 
        80 - 99% = 0 
 
MON_CACHE_MEMORY (165) 
    Primary pointer page: 526, Index root page: 527 
    Total formats: 2, used formats: 1 
    Average record length: 97.11, total records: 71 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 112.00, compression ratio: 1.15 
    Pointer pages: 1, data page slots: 2 
    Data pages: 2, average fill: 50% 
    Primary pages: 2, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 1 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 1 
 
    Index PK_MON_CACHE_MEMORY (0) 
    Root page: 1504215, depth: 1, leaf buckets: 1, nodes: 71 
    Average node length: 11.70, total dup: 0, max dup: 0 
    Average key length: 10.69, compression ratio: 0.84 
    Average prefix length: 1.30, average data length: 7.70 
    Clustering factor: 2, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
MON_LOG (162) 
    Primary pointer page: 520, Index root page: 521 
    Total formats: 2, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index MON_LOG_DTS (4) 
    Root page: 1504229, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index MON_LOG_GDSCODE (2) 
    Root page: 1504227, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index MON_LOG_ROWSET_DESC (1) 
    Root page: 1504226, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index MON_LOG_UNIT (3) 
    Root page: 1504228, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PK_MON_LOG (0) 
    Root page: 1504225, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
MON_LOG_TABLE_STATS (163) 
    Primary pointer page: 522, Index root page: 523 
    Total formats: 2, used formats: 1 
    Average record length: 67.13, total records: 30 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 611.00, compression ratio: 9.10 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 31% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 1 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index MON_LOG_TABLE_STATS_DTS (4) 
    Root page: 1504224, depth: 1, leaf buckets: 1, nodes: 30 
    Average node length: 3.50, total dup: 23, max dup: 4 
    Average key length: 2.47, compression ratio: 3.24 
    Average prefix length: 7.53, average data length: 0.47 
    Clustering factor: 1, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index MON_LOG_TABLE_STATS_GDSCODE (2) 
    Root page: 1504222, depth: 1, leaf buckets: 1, nodes: 30 
    Average node length: 2.00, total dup: 29, max dup: 29 
    Average key length: 1.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 1, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index MON_LOG_TABLE_STATS_ROWSET (1) 
    Root page: 1504221, depth: 1, leaf buckets: 1, nodes: 30 
    Average node length: 3.33, total dup: 29, max dup: 29 
    Average key length: 2.30, compression ratio: 3.91 
    Average prefix length: 8.70, average data length: 0.30 
    Clustering factor: 1, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index MON_LOG_TABLE_STATS_TN_UNIT (3) 
    Root page: 1504223, depth: 1, leaf buckets: 1, nodes: 30 
    Average node length: 12.90, total dup: 0, max dup: 0 
    Average key length: 11.87, compression ratio: 1.42 
    Average prefix length: 7.63, average data length: 9.20 
    Clustering factor: 1, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PK_MON_LOG_TABLE_STATS (0) 
    Root page: 1504220, depth: 1, leaf buckets: 1, nodes: 30 
    Average node length: 8.37, total dup: 0, max dup: 0 
    Average key length: 7.33, compression ratio: 1.23 
    Average prefix length: 4.63, average data length: 4.37 
    Clustering factor: 1, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
OPTYPES (136) 
    Primary pointer page: 468, Index root page: 469 
    Total formats: 2, used formats: 1 
    Average record length: 67.56, total records: 9 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 386.00, compression ratio: 5.71 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 9% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index OPTYPES_MCODE_UNQ (1) 
    Root page: 1544805, depth: 1, leaf buckets: 1, nodes: 9 
    Average node length: 8.56, total dup: 0, max dup: 0 
    Average key length: 6.89, compression ratio: 0.73 
    Average prefix length: 0.44, average data length: 4.56 
    Clustering factor: 1, ratio: 0.11 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PK_OPTYPES (0) 
    Root page: 1544804, depth: 1, leaf buckets: 1, nodes: 9 
    Average node length: 6.11, total dup: 0, max dup: 0 
    Average key length: 5.00, compression ratio: 0.60 
    Average prefix length: 0.89, average data length: 2.11 
    Clustering factor: 1, ratio: 0.11 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
PDISTR (146) 
    Primary pointer page: 488, Index root page: 489 
    Total formats: 1, used formats: 1 
    Average record length: 35.84, total records: 836724 
    Average version length: 25.19, total versions: 82614, max versions: 4 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 54.00, compression ratio: 1.51 
    Pointer pages: 5, data page slots: 8128 
    Data pages: 8128, average fill: 72% 
    Primary pages: 8111, secondary pages: 17, swept pages: 968 
    Empty pages: 8, full pages: 7837 
    Fill distribution: 
     0 - 19% = 10 
    20 - 39% = 5 
    40 - 59% = 17 
    60 - 79% = 7735 
    80 - 99% = 361 
 
    Index PDISTR_AGENT_ID (2) 
    Root page: 1509308, depth: 2, leaf buckets: 899, nodes: 836724 
    Average node length: 4.87, total dup: 836675, max dup: 154970 
    Average key length: 2.01, compression ratio: 4.48 
    Average prefix length: 8.99, average data length: 0.01 
    Clustering factor: 91922, ratio: 0.11 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 89 
        40 - 59% = 504 
        60 - 79% = 238 
        80 - 99% = 66 
 
    Index PDISTR_SNDOP_RCVOP_SNDID_ASC (0) 
    Root page: 1508613, depth: 3, leaf buckets: 959, nodes: 836724 
    Average node length: 5.88, total dup: 744804, max dup: 43 
    Average key length: 3.02, compression ratio: 7.29 
    Average prefix length: 21.09, average data length: 0.91 
    Clustering factor: 166750, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 70 
        40 - 59% = 467 
        60 - 79% = 111 
        80 - 99% = 309 
 
    Index PDISTR_SNDOP_RCVOP_SNDID_DESC (1) 
    Root page: 1509187, depth: 3, leaf buckets: 1002, nodes: 836724 
    Average node length: 5.88, total dup: 744804, max dup: 43 
    Average key length: 3.02, compression ratio: 7.28 
    Average prefix length: 21.09, average data length: 0.91 
    Clustering factor: 168673, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 176 
        40 - 59% = 417 
        60 - 79% = 105 
        80 - 99% = 304 
 
    Index PDISTR_WORKER_SND_ID (3) 
    Root page: 1510178, depth: 3, leaf buckets: 1158, nodes: 836724 
    Average node length: 5.97, total dup: 744804, max dup: 43 
    Average key length: 3.10, compression ratio: 5.48 
    Average prefix length: 16.01, average data length: 0.99 
    Clustering factor: 161246, ratio: 0.19 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 220 
        40 - 59% = 605 
        60 - 79% = 236 
        80 - 99% = 95 
 
PERF_AGG (158) 
    Primary pointer page: 512, Index root page: 513 
    Total formats: 1, used formats: 1 
    Average record length: 62.81, total records: 5382 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 3.25, total fragments: 57, max fragments: 1 
    Average unpacked length: 379.00, compression ratio: 6.03 
    Pointer pages: 1, data page slots: 96 
    Data pages: 96, average fill: 56% 
    Primary pages: 77, secondary pages: 19, swept pages: 46 
    Empty pages: 12, full pages: 64 
    Fill distribution: 
     0 - 19% = 27 
    20 - 39% = 0 
    40 - 59% = 1 
    60 - 79% = 68 
    80 - 99% = 0 
 
    Index PERF_AGG_UNQ (1) 
    Root page: 1504238, depth: 2, leaf buckets: 5, nodes: 5382 
    Average node length: 5.48, total dup: 0, max dup: 0 
    Average key length: 3.60, compression ratio: 9.97 
    Average prefix length: 34.29, average data length: 1.56 
    Clustering factor: 5101, ratio: 0.95 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 0 
        40 - 59% = 2 
        60 - 79% = 1 
        80 - 99% = 2 
 
    Index PK_PERF_AGG (0) 
    Root page: 1504233, depth: 2, leaf buckets: 10, nodes: 5382 
    Average node length: 11.09, 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: 143, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 1 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 7 
 
PERF_ESTIMATED (280) 
    Primary pointer page: 1504218, Index root page: 1504219 
    Total formats: 1, used formats: 1 
    Average record length: 39.10, total records: 77379 
    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: 752 
    Data pages: 752, average fill: 71% 
    Primary pages: 752, secondary pages: 0, swept pages: 0 
    Empty pages: 6, full pages: 745 
    Fill distribution: 
     0 - 19% = 6 
    20 - 39% = 1 
    40 - 59% = 0 
    60 - 79% = 745 
    80 - 99% = 0 
 
    Index PK_PERF_ESTIMATED (0) 
    Root page: 34027, depth: 2, leaf buckets: 98, nodes: 77379 
    Average node length: 10.17, total dup: 0, max dup: 0 
    Average key length: 8.18, compression ratio: 1.10 
    Average prefix length: 3.82, average data length: 5.18 
    Clustering factor: 3181, ratio: 0.04 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 0 
        40 - 59% = 1 
        60 - 79% = 0 
        80 - 99% = 97 
 
PERF_ISQL_STAT (156) 
    Primary pointer page: 508, Index root page: 509 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index PERF_ISQL_STAT_TRN (0) 
    Root page: 1504239, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
PERF_LOG (159) 
    Primary pointer page: 514, Index root page: 515 
    Total formats: 1, used formats: 1 
    Average record length: 111.12, total records: 72 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1691.00, compression ratio: 15.22 
    Pointer pages: 1, data page slots: 2 
    Data pages: 2, average fill: 57% 
    Primary pages: 2, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 1 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 1 
    40 - 59% = 0 
    60 - 79% = 1 
    80 - 99% = 0 
 
PERF_SPLIT_0 (281) 
    Primary pointer page: 573, Index root page: 574 
    Total formats: 1, used formats: 1 
    Average record length: 137.33, total records: 195499 
    Average version length: 153.64, total versions: 17576, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 12.35 
    Pointer pages: 6, data page slots: 7168 
    Data pages: 4840, average fill: 84% 
    Primary pages: 4840, secondary pages: 0, swept pages: 1 
    Empty pages: 184, full pages: 4612 
    Fill distribution: 
     0 - 19% = 186 
    20 - 39% = 9 
    40 - 59% = 21 
    60 - 79% = 13 
    80 - 99% = 4611 
 
PERF_SPLIT_1 (282) 
    Primary pointer page: 576, Index root page: 577 
    Total formats: 1, used formats: 1 
    Average record length: 139.36, total records: 163404 
    Average version length: 153.27, total versions: 12121, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 12.17 
    Pointer pages: 6, data page slots: 4464 
    Data pages: 4000, average fill: 85% 
    Primary pages: 3999, secondary pages: 1, swept pages: 3 
    Empty pages: 113, full pages: 3850 
    Fill distribution: 
     0 - 19% = 120 
    20 - 39% = 9 
    40 - 59% = 15 
    60 - 79% = 5 
    80 - 99% = 3851 
 
PERF_SPLIT_2 (283) 
    Primary pointer page: 578, Index root page: 579 
    Total formats: 1, used formats: 1 
    Average record length: 140.98, total records: 201734 
    Average version length: 153.14, total versions: 13747, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 12.03 
    Pointer pages: 7, data page slots: 6536 
    Data pages: 4848, average fill: 86% 
    Primary pages: 4848, secondary pages: 0, swept pages: 4 
    Empty pages: 50, full pages: 4782 
    Fill distribution: 
     0 - 19% = 53 
    20 - 39% = 3 
    40 - 59% = 6 
    60 - 79% = 7 
    80 - 99% = 4779 
 
PERF_SPLIT_3 (284) 
    Primary pointer page: 580, Index root page: 581 
    Total formats: 1, used formats: 1 
    Average record length: 129.66, total records: 197882 
    Average version length: 154.52, total versions: 27987, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 13.08 
    Pointer pages: 9, data page slots: 5200 
    Data pages: 4760, average fill: 87% 
    Primary pages: 4760, secondary pages: 0, swept pages: 2 
    Empty pages: 45, full pages: 4695 
    Fill distribution: 
     0 - 19% = 52 
    20 - 39% = 6 
    40 - 59% = 3 
    60 - 79% = 3 
    80 - 99% = 4696 
 
PERF_SPLIT_4 (285) 
    Primary pointer page: 582, Index root page: 583 
    Total formats: 1, used formats: 1 
    Average record length: 142.17, total records: 164882 
    Average version length: 152.37, total versions: 9822, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.93 
    Pointer pages: 8, data page slots: 5600 
    Data pages: 4048, average fill: 84% 
    Primary pages: 4047, secondary pages: 1, swept pages: 1 
    Empty pages: 104, full pages: 3882 
    Fill distribution: 
     0 - 19% = 109 
    20 - 39% = 11 
    40 - 59% = 38 
    60 - 79% = 7 
    80 - 99% = 3883 
 
PERF_SPLIT_5 (286) 
    Primary pointer page: 584, Index root page: 585 
    Total formats: 1, used formats: 1 
    Average record length: 141.79, total records: 177967 
    Average version length: 152.87, total versions: 10939, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.96 
    Pointer pages: 8, data page slots: 8008 
    Data pages: 4360, average fill: 85% 
    Primary pages: 4360, secondary pages: 0, swept pages: 1 
    Empty pages: 118, full pages: 4204 
    Fill distribution: 
     0 - 19% = 123 
    20 - 39% = 13 
    40 - 59% = 11 
    60 - 79% = 9 
    80 - 99% = 4204 
 
PERF_SPLIT_6 (287) 
    Primary pointer page: 586, Index root page: 587 
    Total formats: 1, used formats: 1 
    Average record length: 116.50, total records: 186396 
    Average version length: 154.53, total versions: 42225, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 14.56 
    Pointer pages: 6, data page slots: 4928 
    Data pages: 4464, average fill: 88% 
    Primary pages: 4464, secondary pages: 0, swept pages: 1 
    Empty pages: 27, full pages: 4423 
    Fill distribution: 
     0 - 19% = 29 
    20 - 39% = 5 
    40 - 59% = 2 
    60 - 79% = 6 
    80 - 99% = 4422 
 
PERF_SPLIT_7 (288) 
    Primary pointer page: 588, Index root page: 589 
    Total formats: 1, used formats: 1 
    Average record length: 126.10, total records: 184810 
    Average version length: 154.44, total versions: 30279, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 13.45 
    Pointer pages: 6, data page slots: 6192 
    Data pages: 4496, average fill: 86% 
    Primary pages: 4496, secondary pages: 0, swept pages: 1 
    Empty pages: 90, full pages: 4368 
    Fill distribution: 
     0 - 19% = 90 
    20 - 39% = 9 
    40 - 59% = 19 
    60 - 79% = 9 
    80 - 99% = 4369 
 
PERF_SPLIT_8 (289) 
    Primary pointer page: 590, Index root page: 591 
    Total formats: 1, used formats: 1 
    Average record length: 138.69, total records: 171566 
    Average version length: 153.56, total versions: 13848, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 12.23 
    Pointer pages: 7, data page slots: 5832 
    Data pages: 4136, average fill: 86% 
    Primary pages: 4136, secondary pages: 0, swept pages: 2 
    Empty pages: 61, full pages: 4057 
    Fill distribution: 
     0 - 19% = 61 
    20 - 39% = 7 
    40 - 59% = 5 
    60 - 79% = 7 
    80 - 99% = 4056 
 
PERF_SPLIT_9 (290) 
    Primary pointer page: 593, Index root page: 594 
    Total formats: 1, used formats: 1 
    Average record length: 141.69, total records: 151530 
    Average version length: 152.33, total versions: 8970, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.97 
    Pointer pages: 8, data page slots: 5248 
    Data pages: 3656, average fill: 86% 
    Primary pages: 3656, secondary pages: 0, swept pages: 2 
    Empty pages: 62, full pages: 3569 
    Fill distribution: 
     0 - 19% = 62 
    20 - 39% = 9 
    40 - 59% = 10 
    60 - 79% = 6 
    80 - 99% = 3569 
 
PHRASES (143) 
    Primary pointer page: 482, Index root page: 483 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index PHRASES_ID_DESC (3) 
    Root page: 1510354, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PHRASES_NAME (2) 
    Root page: 1510353, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PHRASES_UNQ (1) 
    Root page: 1510352, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PK_PHRASES (0) 
    Root page: 1510351, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
PSTORNED (147) 
    Primary pointer page: 490, Index root page: 491 
    Total formats: 1, used formats: 1 
    Average record length: 51.06, total records: 2104196 
    Average version length: 52.92, total versions: 67241, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 70.00, compression ratio: 1.37 
    Pointer pages: 16, data page slots: 25560 
    Data pages: 25552, average fill: 71% 
    Primary pages: 25552, secondary pages: 0, swept pages: 9707 
    Empty pages: 297, full pages: 20681 
    Fill distribution: 
     0 - 19% = 545 
    20 - 39% = 424 
    40 - 59% = 1116 
    60 - 79% = 22875 
    80 - 99% = 592 
 
    Index PSTORNED_RCV_ID (1) 
    Root page: 1506186, depth: 3, leaf buckets: 2595, nodes: 2104196 
    Average node length: 5.44, total dup: 1964110, max dup: 1218 
    Average key length: 2.49, compression ratio: 3.62 
    Average prefix length: 8.58, average data length: 0.42 
    Clustering factor: 181494, ratio: 0.09 
    Fill distribution: 
         0 - 19% = 5 
        20 - 39% = 292 
        40 - 59% = 1734 
        60 - 79% = 266 
        80 - 99% = 298 
 
    Index PSTORNED_SND_ID (0) 
    Root page: 1504819, depth: 3, leaf buckets: 2757, nodes: 2104196 
    Average node length: 5.69, total dup: 1888984, max dup: 76 
    Average key length: 2.74, compression ratio: 3.29 
    Average prefix length: 8.36, average data length: 0.64 
    Clustering factor: 375620, ratio: 0.18 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 6 
        40 - 59% = 2389 
        60 - 79% = 335 
        80 - 99% = 25 
 
    Index PSTORNED_WORKER_ID (2) 
    Root page: 1507996, depth: 3, leaf buckets: 2133, nodes: 2104196 
    Average node length: 4.96, total dup: 2104096, max dup: 27901 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.42, average data length: 0.00 
    Clustering factor: 179257, ratio: 0.09 
    Fill distribution: 
         0 - 19% = 3 
        20 - 39% = 170 
        40 - 59% = 1157 
        60 - 79% = 383 
        80 - 99% = 420 
 
RULES_FOR_PDISTR (148) 
    Primary pointer page: 492, Index root page: 493 
    Total formats: 1, used formats: 1 
    Average record length: 17.00, total records: 4 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 334.00, compression ratio: 19.65 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 2% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index RULES_FOR_PDISTR_UNQ (0) 
    Root page: 1504317, depth: 1, leaf buckets: 1, nodes: 4 
    Average node length: 11.50, total dup: 0, max dup: 0 
    Average key length: 10.25, compression ratio: 0.88 
    Average prefix length: 1.50, average data length: 7.50 
    Clustering factor: 1, ratio: 0.25 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
RULES_FOR_QDISTR (137) 
    Primary pointer page: 470, Index root page: 471 
    Total formats: 1, used formats: 1 
    Average record length: 32.71, total records: 7 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 332.00, compression ratio: 10.15 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 4% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index RULES_FOR_QDISTR_RCVOP (1) 
    Root page: 1544803, depth: 1, leaf buckets: 1, nodes: 7 
    Average node length: 5.29, total dup: 2, max dup: 2 
    Average key length: 4.14, compression ratio: 0.72 
    Average prefix length: 1.43, average data length: 1.57 
    Clustering factor: 1, ratio: 0.14 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index RULES_FOR_QDISTR_UNQ (0) 
    Root page: 1544802, depth: 1, leaf buckets: 1, nodes: 7 
    Average node length: 10.14, total dup: 0, max dup: 0 
    Average key length: 8.86, compression ratio: 0.94 
    Average prefix length: 2.14, average data length: 6.14 
    Clustering factor: 1, ratio: 0.14 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
SEMAPHORES (152) 
    Primary pointer page: 500, Index root page: 501 
    Total formats: 1, used formats: 1 
    Average record length: 43.40, total records: 5 
    Average version length: 9.00, total versions: 1, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 346.00, compression ratio: 7.97 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 4% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index PK_SEMAPHORES (0) 
    Root page: 1504305, depth: 1, leaf buckets: 1, nodes: 5 
    Average node length: 12.40, total dup: 0, max dup: 0 
    Average key length: 11.00, compression ratio: 0.82 
    Average prefix length: 0.60, average data length: 8.40 
    Clustering factor: 1, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index SEMAPHORES_TASK_UNQ (1) 
    Root page: 1504306, depth: 1, leaf buckets: 1, nodes: 5 
    Average node length: 23.40, total dup: 0, max dup: 0 
    Average key length: 22.00, compression ratio: 1.07 
    Average prefix length: 4.20, average data length: 19.40 
    Clustering factor: 1, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
SETTINGS (135) 
    Primary pointer page: 466, Index root page: 467 
    Total formats: 1, used formats: 1 
    Average record length: 97.63, total records: 149 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1347.00, compression ratio: 13.80 
    Pointer pages: 1, data page slots: 3 
    Data pages: 3, average fill: 70% 
    Primary pages: 3, secondary pages: 0, swept pages: 2 
    Empty pages: 0, full pages: 2 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 1 
    60 - 79% = 0 
    80 - 99% = 2 
 
    Index SETTINGS_MCODE_WM_UNQ (1) 
    Root page: 525, depth: 1, leaf buckets: 1, nodes: 149 
    Average node length: 14.66, total dup: 0, max dup: 0 
    Average key length: 13.55, compression ratio: 2.19 
    Average prefix length: 19.07, average data length: 10.66 
    Clustering factor: 48, ratio: 0.32 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 1 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index SETTINGS_MODE_CODE (0) 
    Root page: 1544806, depth: 1, leaf buckets: 1, nodes: 149 
    Average node length: 25.56, total dup: 0, max dup: 0 
    Average key length: 24.56, compression ratio: 1.63 
    Average prefix length: 18.58, average data length: 21.56 
    Clustering factor: 14, ratio: 0.09 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 0 
        40 - 59% = 1 
        60 - 79% = 0 
        80 - 99% = 0 
 
TMP$DEP_DOCS (129) 
    Primary pointer page: 454, Index root page: 455 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index TMP_DEP_DOCS_UNQ (0) 
    Root page: 1544810, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
TMP$IDX_RECALC (132) 
    Primary pointer page: 460, Index root page: 461 
    Total formats: 2, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index TMP_IDX_RECALC_IDX_NAME_UNQ (0) 
    Root page: 1544807, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
TMP$MON_LOG (133) 
    Primary pointer page: 462, Index root page: 463 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
TMP$MON_LOG_TABLE_STATS (134) 
    Primary pointer page: 464, Index root page: 465 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
TMP$PERF_EST_WHOLE (161) 
    Primary pointer page: 518, Index root page: 519 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
TMP$PERF_LOG (160) 
    Primary pointer page: 516, Index root page: 517 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index TMP$PERF_LOG_UNIT_TRN_DTS_END (0) 
    Root page: 1504230, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
TMP$PERF_MON (131) 
    Primary pointer page: 458, Index root page: 459 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
TMP$RESULT_SET (130) 
    Primary pointer page: 456, Index root page: 457 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index TMP_RESULT_SET_DOC (1) 
    Root page: 1544809, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index TMP_RESULT_SET_WARE_DOC (0) 
    Root page: 1544808, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
TMP$SHOPPING_CART (128) 
    Primary pointer page: 452, Index root page: 453 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index TMP_SHOPCART_UNQ (0) 
    Root page: 1544811, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
TPAUSE (166) 
    Primary pointer page: 528, Index root page: 529 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index RDB$PRIMARY2 (0) 
    Root page: 1504214, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
TRACE_STAT (157) 
    Primary pointer page: 510, Index root page: 511 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
WARES (142) 
    Primary pointer page: 480, Index root page: 481 
    Total formats: 1, used formats: 1 
    Average record length: 77.52, total records: 400 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 444.00, compression ratio: 5.73 
    Pointer pages: 1, data page slots: 6 
    Data pages: 6, average fill: 77% 
    Primary pages: 6, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 5 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 5 
    80 - 99% = 1 
 
    Index FK_WARES_WARE_GROUPS (3) 
    Root page: 1552159, depth: 1, leaf buckets: 1, nodes: 400 
    Average node length: 3.17, total dup: 392, max dup: 60 
    Average key length: 2.16, compression ratio: 4.16 
    Average prefix length: 8.86, average data length: 0.14 
    Clustering factor: 48, ratio: 0.12 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PK_WARES (0) 
    Root page: 1510355, depth: 1, leaf buckets: 1, nodes: 400 
    Average node length: 11.22, total dup: 0, max dup: 0 
    Average key length: 10.22, compression ratio: 0.88 
    Average prefix length: 1.78, average data length: 7.22 
    Clustering factor: 344, ratio: 0.86 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 0 
        40 - 59% = 1 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index WARES_ID_DESC (2) 
    Root page: 1510360, depth: 1, leaf buckets: 1, nodes: 400 
    Average node length: 11.22, total dup: 0, max dup: 0 
    Average key length: 10.22, compression ratio: 0.88 
    Average prefix length: 1.78, average data length: 7.22 
    Clustering factor: 344, ratio: 0.86 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 0 
        40 - 59% = 1 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index WARES_NUMB_UNQ (1) 
    Root page: 1510358, depth: 2, leaf buckets: 3, nodes: 400 
    Average node length: 53.25, total dup: 0, max dup: 0 
    Average key length: 52.23, compression ratio: 1.00 
    Average prefix length: 2.74, average data length: 49.25 
    Clustering factor: 355, ratio: 0.89 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 1 
        80 - 99% = 2 
 
WARE_GROUPS (151) 
    Primary pointer page: 498, Index root page: 499 
    Total formats: 1, used formats: 1 
    Average record length: 32.12, total records: 8 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 346.00, compression ratio: 10.77 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 5% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index PK_WARE_GROUPS (0) 
    Root page: 1504307, depth: 1, leaf buckets: 1, nodes: 8 
    Average node length: 11.25, total dup: 0, max dup: 0 
    Average key length: 10.12, compression ratio: 0.89 
    Average prefix length: 1.75, average data length: 7.25 
    Clustering factor: 1, ratio: 0.12 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index WARE_GROUPS_NAME_UNQ (1) 
    Root page: 1504308, depth: 1, leaf buckets: 1, nodes: 8 
    Average node length: 19.88, total dup: 0, max dup: 0 
    Average key length: 18.12, compression ratio: 0.89 
    Average prefix length: 0.25, average data length: 15.88 
    Clustering factor: 1, ratio: 0.12 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
XQD_1000_1200 (176) 
    Primary pointer page: 549, Index root page: 550 
    Total formats: 1, used formats: 1 
    Average record length: 39.84, total records: 176678 
    Average version length: 69.18, total versions: 74989, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 3.16 
    Pointer pages: 3, data page slots: 4328 
    Data pages: 3704, average fill: 55% 
    Primary pages: 3704, secondary pages: 0, swept pages: 617 
    Empty pages: 836, full pages: 2229 
    Fill distribution: 
     0 - 19% = 1096 
    20 - 39% = 98 
    40 - 59% = 117 
    60 - 79% = 915 
    80 - 99% = 1478 
 
    Index XQD_1000_1200_WA_SO_RO_WKR_SND (0) 
    Root page: 101167, depth: 3, leaf buckets: 268, nodes: 176678 
    Average node length: 6.46, total dup: 153879, max dup: 14 
    Average key length: 3.90, compression ratio: 10.77 
    Average prefix length: 40.23, average data length: 1.77 
    Clustering factor: 29982, ratio: 0.17 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 43 
        40 - 59% = 137 
        60 - 79% = 75 
        80 - 99% = 12 
 
XQD_1000_3300 (178) 
    Primary pointer page: 553, Index root page: 554 
    Total formats: 1, used formats: 1 
    Average record length: 64.33, total records: 7596149 
    Average version length: 68.75, total versions: 508489, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.96 
    Pointer pages: 65, data page slots: 104792 
    Data pages: 104616, average fill: 78% 
    Primary pages: 104616, secondary pages: 0, swept pages: 17277 
    Empty pages: 42, full pages: 103161 
    Fill distribution: 
     0 - 19% = 116 
    20 - 39% = 266 
    40 - 59% = 407 
    60 - 79% = 90765 
    80 - 99% = 13062 
 
    Index XQD_1000_3300_WA_SO_RO_WKR_SND (0) 
    Root page: 1480454, depth: 3, leaf buckets: 10856, nodes: 7596149 
    Average node length: 6.50, total dup: 6574637, max dup: 29 
    Average key length: 3.51, compression ratio: 11.96 
    Average prefix length: 40.62, average data length: 1.38 
    Clustering factor: 1687167, ratio: 0.22 
    Fill distribution: 
         0 - 19% = 14 
        20 - 39% = 1217 
        40 - 59% = 5470 
        60 - 79% = 3298 
        80 - 99% = 857 
 
    Index XQD_1000_3300_WKR_DOC_ASC (1) 
    Root page: 1486068, depth: 3, leaf buckets: 8800, nodes: 7596149 
    Average node length: 5.38, total dup: 7305945, max dup: 180 
    Average key length: 2.39, compression ratio: 7.11 
    Average prefix length: 16.65, average data length: 0.35 
    Clustering factor: 1459217, ratio: 0.19 
    Fill distribution: 
         0 - 19% = 12 
        20 - 39% = 925 
        40 - 59% = 4787 
        60 - 79% = 1820 
        80 - 99% = 1256 
 
    Index XQD_1000_3300_WKR_DOC_DEC (2) 
    Root page: 1490608, depth: 3, leaf buckets: 8891, nodes: 7596149 
    Average node length: 5.38, total dup: 7305945, max dup: 180 
    Average key length: 2.39, compression ratio: 7.11 
    Average prefix length: 16.65, average data length: 0.35 
    Clustering factor: 1461869, ratio: 0.19 
    Fill distribution: 
         0 - 19% = 6 
        20 - 39% = 989 
        40 - 59% = 4821 
        60 - 79% = 1857 
        80 - 99% = 1218 
 
XQD_1200_2000 (177) 
    Primary pointer page: 551, Index root page: 552 
    Total formats: 1, used formats: 1 
    Average record length: 66.83, total records: 12436757 
    Average version length: 68.71, total versions: 380491, 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: 105, data page slots: 170264 
    Data pages: 170256, average fill: 77% 
    Primary pages: 170256, secondary pages: 0, swept pages: 67524 
    Empty pages: 28, full pages: 170190 
    Fill distribution: 
     0 - 19% = 34 
    20 - 39% = 6 
    40 - 59% = 3 
    60 - 79% = 160983 
    80 - 99% = 9230 
 
    Index XQD_1200_2000_WA_SO_RO_WKR_SND (0) 
    Root page: 1495028, depth: 3, leaf buckets: 18488, nodes: 12436757 
    Average node length: 6.60, total dup: 10842413, max dup: 61 
    Average key length: 3.42, compression ratio: 12.27 
    Average prefix length: 40.70, average data length: 1.30 
    Clustering factor: 2426748, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 35 
        20 - 39% = 1955 
        40 - 59% = 10412 
        60 - 79% = 5019 
        80 - 99% = 1067 
 
XQD_2000_3300 (179) 
    Primary pointer page: 555, Index root page: 556 
    Total formats: 1, used formats: 1 
    Average record length: 36.77, total records: 1912486 
    Average version length: 69.11, total versions: 894950, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 3.43 
    Pointer pages: 26, data page slots: 40968 
    Data pages: 30256, average fill: 73% 
    Primary pages: 30256, secondary pages: 0, swept pages: 4616 
    Empty pages: 1657, full pages: 23584 
    Fill distribution: 
     0 - 19% = 2608 
    20 - 39% = 1284 
    40 - 59% = 1411 
    60 - 79% = 10420 
    80 - 99% = 14533 
 
    Index XQD_2000_3300_WA_SO_RO_WKR_SND (0) 
    Root page: 1479712, depth: 3, leaf buckets: 2337, nodes: 1912486 
    Average node length: 5.50, total dup: 1835501, max dup: 99 
    Average key length: 2.54, compression ratio: 16.51 
    Average prefix length: 41.50, average data length: 0.50 
    Clustering factor: 131497, ratio: 0.07 
    Fill distribution: 
         0 - 19% = 11 
        20 - 39% = 337 
        40 - 59% = 1112 
        60 - 79% = 665 
        80 - 99% = 212 
 
XQD_2100_3300 (180) 
    Primary pointer page: 557, Index root page: 558 
    Total formats: 1, used formats: 1 
    Average record length: 36.00, total records: 1281012 
    Average version length: 69.12, total versions: 613000, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 3.50 
    Pointer pages: 21, data page slots: 33688 
    Data pages: 28608, average fill: 52% 
    Primary pages: 28608, secondary pages: 0, swept pages: 6355 
    Empty pages: 6586, full pages: 15854 
    Fill distribution: 
     0 - 19% = 9439 
    20 - 39% = 1085 
    40 - 59% = 848 
    60 - 79% = 6907 
    80 - 99% = 10329 
 
    Index XQD_2100_3300_WA_SO_RO_WKR_SND (0) 
    Root page: 1479207, depth: 3, leaf buckets: 1688, nodes: 1281012 
    Average node length: 5.78, total dup: 1197046, max dup: 99 
    Average key length: 2.84, compression ratio: 14.79 
    Average prefix length: 41.22, average data length: 0.78 
    Clustering factor: 188984, ratio: 0.15 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 285 
        40 - 59% = 793 
        60 - 79% = 482 
        80 - 99% = 127 
 
XQD_3300_3400 (181) 
    Primary pointer page: 559, Index root page: 560 
    Total formats: 1, used formats: 1 
    Average record length: 63.08, total records: 9141870 
    Average version length: 68.97, total versions: 770753, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 2.00 
    Pointer pages: 87, data page slots: 141384 
    Data pages: 141360, average fill: 70% 
    Primary pages: 141360, secondary pages: 0, swept pages: 35365 
    Empty pages: 394, full pages: 84423 
    Fill distribution: 
     0 - 19% = 1390 
    20 - 39% = 5885 
    40 - 59% = 20284 
    60 - 79% = 100018 
    80 - 99% = 13783 
 
    Index XQD_3300_3400_WA_SO_RO_WKR_SND (0) 
    Root page: 1472590, depth: 3, leaf buckets: 13467, nodes: 9141870 
    Average node length: 6.67, total dup: 7582728, max dup: 27 
    Average key length: 3.67, compression ratio: 11.45 
    Average prefix length: 40.50, average data length: 1.50 
    Clustering factor: 1975838, ratio: 0.22 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 1372 
        40 - 59% = 7023 
        60 - 79% = 4348 
        80 - 99% = 722 
 
XQS_1000_1200 (182) 
    Primary pointer page: 561, Index root page: 562 
    Total formats: 1, used formats: 1 
    Average record length: 82.47, total records: 21118527 
    Average version length: 82.91, total versions: 18454, 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: 318280 
    Data pages: 318280, average fill: 81% 
    Primary pages: 318280, secondary pages: 0, swept pages: 12101 
    Empty pages: 26, full pages: 317555 
    Fill distribution: 
     0 - 19% = 40 
    20 - 39% = 32 
    40 - 59% = 98 
    60 - 79% = 27312 
    80 - 99% = 290798 
 
    Index XQS_1000_1200_DOC_ID (1) 
    Root page: 1426716, depth: 3, leaf buckets: 19474, nodes: 21118527 
    Average node length: 5.72, total dup: 20638101, max dup: 182 
    Average key length: 2.16, compression ratio: 4.16 
    Average prefix length: 8.86, average data length: 0.14 
    Clustering factor: 3277862, ratio: 0.16 
    Fill distribution: 
         0 - 19% = 4 
        20 - 39% = 1 
        40 - 59% = 8372 
        60 - 79% = 563 
        80 - 99% = 10534 
 
    Index XQS_1000_1200_RCV_ID (3) 
    Root page: 1456980, depth: 3, leaf buckets: 17137, nodes: 21118527 
    Average node length: 6.31, total dup: 18560734, max dup: 49 
    Average key length: 2.75, compression ratio: 3.27 
    Average prefix length: 8.37, average data length: 0.63 
    Clustering factor: 913108, ratio: 0.04 
    Fill distribution: 
         0 - 19% = 4 
        20 - 39% = 2 
        40 - 59% = 769 
        60 - 79% = 282 
        80 - 99% = 16080 
 
    Index XQS_1000_1200_SND_ID (2) 
    Root page: 1441073, depth: 3, leaf buckets: 21244, nodes: 21118527 
    Average node length: 6.35, total dup: 18478118, max dup: 29 
    Average key length: 2.79, compression ratio: 3.23 
    Average prefix length: 8.34, average data length: 0.66 
    Clustering factor: 3570543, ratio: 0.17 
    Fill distribution: 
         0 - 19% = 12 
        20 - 39% = 0 
        40 - 59% = 8620 
        60 - 79% = 603 
        80 - 99% = 12009 
 
    Index XQS_1000_1200_WORKER_ID (0) 
    Root page: 1413348, depth: 3, leaf buckets: 15992, nodes: 21118527 
    Average node length: 5.56, total dup: 21118427, max dup: 229792 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.42, average data length: 0.00 
    Clustering factor: 941885, ratio: 0.04 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 6 
        40 - 59% = 2730 
        60 - 79% = 379 
        80 - 99% = 12877 
 
XQS_1000_3300 (184) 
    Primary pointer page: 565, Index root page: 566 
    Total formats: 1, used formats: 1 
    Average record length: 76.32, total records: 9525643 
    Average version length: 82.59, total versions: 702344, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.65 
    Pointer pages: 103, data page slots: 166688 
    Data pages: 166640, average fill: 71% 
    Primary pages: 166640, secondary pages: 0, swept pages: 53904 
    Empty pages: 533, full pages: 102324 
    Fill distribution: 
     0 - 19% = 1773 
    20 - 39% = 7143 
    40 - 59% = 24676 
    60 - 79% = 65718 
    80 - 99% = 67330 
 
    Index XQS_1000_3300_DOC_ID (1) 
    Root page: 1367502, depth: 3, leaf buckets: 11336, nodes: 9525643 
    Average node length: 5.35, total dup: 9219100, max dup: 196 
    Average key length: 2.24, compression ratio: 4.03 
    Average prefix length: 8.80, average data length: 0.20 
    Clustering factor: 2098397, ratio: 0.22 
    Fill distribution: 
         0 - 19% = 5 
        20 - 39% = 122 
        40 - 59% = 8607 
        60 - 79% = 2554 
        80 - 99% = 48 
 
    Index XQS_1000_3300_RCV_ID (3) 
    Root page: 1379261, depth: 3, leaf buckets: 13220, nodes: 9525643 
    Average node length: 6.22, total dup: 7895613, max dup: 14 
    Average key length: 3.10, compression ratio: 2.90 
    Average prefix length: 8.07, average data length: 0.93 
    Clustering factor: 1451582, ratio: 0.15 
    Fill distribution: 
         0 - 19% = 142 
        20 - 39% = 3642 
        40 - 59% = 4456 
        60 - 79% = 2646 
        80 - 99% = 2334 
 
    Index XQS_1000_3300_SND_ID (2) 
    Root page: 1373059, depth: 3, leaf buckets: 12650, nodes: 9525643 
    Average node length: 5.96, total dup: 8267428, max dup: 44 
    Average key length: 2.85, compression ratio: 3.16 
    Average prefix length: 8.28, average data length: 0.72 
    Clustering factor: 2290219, ratio: 0.24 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 137 
        40 - 59% = 9647 
        60 - 79% = 2810 
        80 - 99% = 54 
 
    Index XQS_1000_3300_WORKER_ID (0) 
    Root page: 1362767, depth: 3, leaf buckets: 9955, nodes: 9525643 
    Average node length: 5.12, total dup: 9525543, max dup: 149485 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.42, average data length: 0.00 
    Clustering factor: 1482135, ratio: 0.16 
    Fill distribution: 
         0 - 19% = 40 
        20 - 39% = 1240 
        40 - 59% = 4930 
        60 - 79% = 1739 
        80 - 99% = 2006 
 
XQS_1200_2000 (183) 
    Primary pointer page: 563, Index root page: 564 
    Total formats: 1, used formats: 1 
    Average record length: 78.02, total records: 11199590 
    Average version length: 82.54, total versions: 580821, 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: 117, data page slots: 190376 
    Data pages: 188864, average fill: 73% 
    Primary pages: 188864, secondary pages: 0, swept pages: 64079 
    Empty pages: 3203, full pages: 140882 
    Fill distribution: 
     0 - 19% = 5226 
    20 - 39% = 7226 
    40 - 59% = 17312 
    60 - 79% = 42328 
    80 - 99% = 116772 
 
    Index XQS_1200_2000_DOC_ID (1) 
    Root page: 1392101, depth: 3, leaf buckets: 13112, nodes: 11199590 
    Average node length: 5.29, total dup: 11090181, max dup: 642 
    Average key length: 2.08, compression ratio: 4.33 
    Average prefix length: 8.93, average data length: 0.07 
    Clustering factor: 2335446, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 206 
        40 - 59% = 9332 
        60 - 79% = 3444 
        80 - 99% = 128 
 
    Index XQS_1200_2000_RCV_ID (3) 
    Root page: 1406110, depth: 3, leaf buckets: 10311, nodes: 11199590 
    Average node length: 5.49, total dup: 10710629, max dup: 49 
    Average key length: 2.28, compression ratio: 3.95 
    Average prefix length: 8.77, average data length: 0.23 
    Clustering factor: 706575, ratio: 0.06 
    Fill distribution: 
         0 - 19% = 172 
        20 - 39% = 844 
        40 - 59% = 2490 
        60 - 79% = 1790 
        80 - 99% = 5015 
 
    Index XQS_1200_2000_SND_ID (2) 
    Root page: 1398638, depth: 3, leaf buckets: 14995, nodes: 11199590 
    Average node length: 6.02, total dup: 9770817, max dup: 73 
    Average key length: 2.81, compression ratio: 3.21 
    Average prefix length: 8.32, average data length: 0.68 
    Clustering factor: 2351856, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 250 
        40 - 59% = 10845 
        60 - 79% = 3756 
        80 - 99% = 142 
 
    Index XQS_1200_2000_WORKER_ID (0) 
    Root page: 1386211, depth: 3, leaf buckets: 10594, nodes: 11199590 
    Average node length: 5.21, total dup: 11199490, max dup: 184001 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.42, average data length: 0.00 
    Clustering factor: 695962, ratio: 0.06 
    Fill distribution: 
         0 - 19% = 96 
        20 - 39% = 837 
        40 - 59% = 4642 
        60 - 79% = 1427 
        80 - 99% = 3592 
 
XQS_2000_3300 (185) 
    Primary pointer page: 567, Index root page: 568 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index XQS_2000_3300_DOC_ID (1) 
    Root page: 1361753, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index XQS_2000_3300_RCV_ID (3) 
    Root page: 1361755, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index XQS_2000_3300_SND_ID (2) 
    Root page: 1361754, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index XQS_2000_3300_WORKER_ID (0) 
    Root page: 1361752, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
XQS_2100_3300 (186) 
    Primary pointer page: 569, Index root page: 570 
    Total formats: 1, used formats: 1 
    Average record length: 77.06, total records: 9590682 
    Average version length: 82.91, total versions: 657461, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.64 
    Pointer pages: 105, data page slots: 169784 
    Data pages: 169744, average fill: 70% 
    Primary pages: 169744, secondary pages: 0, swept pages: 59688 
    Empty pages: 531, full pages: 99520 
    Fill distribution: 
     0 - 19% = 1886 
    20 - 39% = 7929 
    40 - 59% = 26427 
    60 - 79% = 69157 
    80 - 99% = 64345 
 
    Index XQS_2100_3300_DOC_ID (1) 
    Root page: 1344686, depth: 3, leaf buckets: 11570, nodes: 9590682 
    Average node length: 5.16, total dup: 9561958, max dup: 2352 
    Average key length: 2.03, compression ratio: 4.43 
    Average prefix length: 8.97, average data length: 0.03 
    Clustering factor: 1901325, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 25 
        20 - 39% = 1517 
        40 - 59% = 7631 
        60 - 79% = 1810 
        80 - 99% = 587 
 
    Index XQS_2100_3300_RCV_ID (3) 
    Root page: 1355717, depth: 3, leaf buckets: 13316, nodes: 9590682 
    Average node length: 6.23, total dup: 7949532, max dup: 14 
    Average key length: 3.10, compression ratio: 2.90 
    Average prefix length: 8.07, average data length: 0.93 
    Clustering factor: 1417616, ratio: 0.15 
    Fill distribution: 
         0 - 19% = 158 
        20 - 39% = 3771 
        40 - 59% = 4321 
        60 - 79% = 2594 
        80 - 99% = 2472 
 
    Index XQS_2100_3300_SND_ID (2) 
    Root page: 1350049, depth: 3, leaf buckets: 12193, nodes: 9590682 
    Average node length: 5.41, total dup: 9161388, max dup: 99 
    Average key length: 2.29, compression ratio: 3.94 
    Average prefix length: 8.76, average data length: 0.24 
    Clustering factor: 2033567, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 20 
        20 - 39% = 1463 
        40 - 59% = 8537 
        60 - 79% = 1634 
        80 - 99% = 539 
 
    Index XQS_2100_3300_WORKER_ID (0) 
    Root page: 985805, depth: 3, leaf buckets: 10022, nodes: 9590682 
    Average node length: 5.13, total dup: 9590582, max dup: 150789 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.42, average data length: 0.00 
    Clustering factor: 1497234, ratio: 0.16 
    Fill distribution: 
         0 - 19% = 42 
        20 - 39% = 1254 
        40 - 59% = 4937 
        60 - 79% = 1751 
        80 - 99% = 2038 
 
XQS_3300_3400 (187) 
    Primary pointer page: 571, Index root page: 572 
    Total formats: 1, used formats: 1 
    Average record length: 67.03, total records: 571561 
    Average version length: 68.72, total versions: 9457, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.88 
    Pointer pages: 5, data page slots: 7952 
    Data pages: 7952, average fill: 75% 
    Primary pages: 7952, secondary pages: 0, swept pages: 3548 
    Empty pages: 5, full pages: 6657 
    Fill distribution: 
     0 - 19% = 8 
    20 - 39% = 18 
    40 - 59% = 236 
    60 - 79% = 7540 
    80 - 99% = 150 
 
    Index XQS_3300_3400_DOC_ID (1) 
    Root page: 41101, depth: 3, leaf buckets: 731, nodes: 571561 
    Average node length: 5.95, total dup: 486511, max dup: 82 
    Average key length: 3.09, compression ratio: 2.91 
    Average prefix length: 8.05, average data length: 0.95 
    Clustering factor: 99632, ratio: 0.17 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 37 
        40 - 59% = 516 
        60 - 79% = 81 
        80 - 99% = 97 
 
    Index XQS_3300_3400_SND_ID (2) 
    Root page: 33348, depth: 3, leaf buckets: 745, nodes: 571561 
    Average node length: 6.15, total dup: 468722, max dup: 25 
    Average key length: 3.29, compression ratio: 2.73 
    Average prefix length: 7.89, average data length: 1.11 
    Clustering factor: 99685, ratio: 0.17 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 34 
        40 - 59% = 510 
        60 - 79% = 93 
        80 - 99% = 108 
 
    Index XQS_3300_3400_WORKER_ID (0) 
    Root page: 375548, depth: 2, leaf buckets: 573, nodes: 571561 
    Average node length: 4.86, total dup: 571461, max dup: 9819 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.42, average data length: 0.00 
    Clustering factor: 88323, ratio: 0.15 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 38 
        40 - 59% = 328 
        60 - 79% = 90 
        80 - 99% = 116 
 
ZDOC_DATA (170) 
    Primary pointer page: 537, Index root page: 538 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
ZDOC_LIST (169) 
    Primary pointer page: 535, Index root page: 536 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
ZINVNT_TURNOVER_LOG (171) 
    Primary pointer page: 539, Index root page: 540 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
ZPDISTR (174) 
    Primary pointer page: 545, Index root page: 546 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index ZPDISTR_ID (0) 
    Root page: 1504207, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
ZPSTORNED (175) 
    Primary pointer page: 547, Index root page: 548 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index ZPSTORNED_ID (0) 
    Root page: 1504206, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
ZQDISTR (172) 
    Primary pointer page: 541, Index root page: 542 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index ZQDISTR_ID (0) 
    Root page: 1504212, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index ZQDISTR_WARE_SNDOP_RCVOP (1) 
    Root page: 1504213, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
ZQSTORNED (173) 
    Primary pointer page: 543, Index root page: 544 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index ZQSTORNED_DOC_ID (1) 
    Root page: 1504209, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index ZQSTORNED_ID (0) 
    Root page: 1504208, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index ZQSTORNED_RCV_ID (3) 
    Root page: 1504211, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index ZQSTORNED_SND_ID (2) 
    Root page: 1504210, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
ZTMP_DEP_DOCS (168) 
    Primary pointer page: 533, Index root page: 534 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
ZTMP_SHOPPING_CART (167) 
    Primary pointer page: 531, Index root page: 532 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
Z_USED_VIEWS (144) 
    Primary pointer page: 484, Index root page: 485 
    Total formats: 1, used formats: 1 
    Average record length: 29.38, total records: 29 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 99.00, compression ratio: 3.37 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 16% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index Z_USED_VIEWS_UNQ (0) 
    Root page: 1510350, depth: 1, leaf buckets: 1, nodes: 29 
    Average node length: 15.17, total dup: 0, max dup: 0 
    Average key length: 14.14, compression ratio: 1.44 
    Average prefix length: 9.17, average data length: 11.17 
    Clustering factor: 1, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
Gstat completion time Wed Apr 10 01:11:55 2024

Record versions statistics, table

TABLE_NAME TOTAL_RECS TOTAL_VERS MAX_VERSIONS VERS_TO_RECS_PRC MAXV_TO_VERS_PRC
DOC_DATA 7723936 141098 1 0.0000 0.0000
DOC_LIST 2224398 135943 3 0.0000 0.0000
FB_ERRORS 2182 757 1 0.0000 0.0000
INVNT_SALDO 400 224907 594 56200.0000 0.0000
INVNT_TURNOVER_LOG 111989 90672 1 0.0000 0.0000
MONEY_SALDO 49 16897 937 34400.0000 0.0000
MONEY_TURNOVER_LOG 1826 1536 1 0.0000 0.0000
PDISTR 836724 82614 4 0.0000 0.0000
PERF_SPLIT_0 195499 17576 1 0.0000 0.0000
PERF_SPLIT_1 163404 12121 1 0.0000 0.0000
PERF_SPLIT_2 201734 13747 1 0.0000 0.0000
PERF_SPLIT_3 197882 27987 1 0.0000 0.0000
PERF_SPLIT_4 164882 9822 1 0.0000 0.0000
PERF_SPLIT_5 177967 10939 1 0.0000 0.0000
PERF_SPLIT_6 186396 42225 1 0.0000 0.0000
PERF_SPLIT_7 184810 30279 1 0.0000 0.0000
PERF_SPLIT_8 171566 13848 1 0.0000 0.0000
PERF_SPLIT_9 151530 8970 1 0.0000 0.0000
PSTORNED 2104196 67241 1 0.0000 0.0000
SEMAPHORES 5 1 1 0.0000 100.0000
XQD_1000_1200 176678 74989 1 0.0000 0.0000
XQD_1000_3300 7596149 508489 1 0.0000 0.0000
XQD_1200_2000 12436757 380491 1 0.0000 0.0000
XQD_2000_3300 1912486 894950 1 0.0000 0.0000
XQD_2100_3300 1281012 613000 1 0.0000 0.0000
XQD_3300_3400 9141870 770753 1 0.0000 0.0000
XQS_1000_1200 21118527 18454 1 0.0000 0.0000
XQS_1000_3300 9525643 702344 1 0.0000 0.0000
XQS_1200_2000 11199590 580821 1 0.0000 0.0000
XQS_2100_3300 9590682 657461 1 0.0000 0.0000
XQS_3300_3400 571561 9457 1 0.0000 0.0000

Record versions statistics, chart

Total records and versions, chart

Ratios versions / total_records and max_versions / total_versions

Database validation 


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

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

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

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

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