Generated by /opt/oltp-emul/oltp_isql_run_worker.sh, ISQL session No. 1 of total launched 100. 14.04.2024 22:12
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 15460476 kB
MemAvailable 30065112 kB
Buffers 0 kB
Cached 16297528 kB
SwapCached 2752 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-14 22:09:43
DTS_END                         2024-04-14 22:09:43.0940
FB_GDSCODE                      -1
FB_MNEMONA                      
STACK                           SP_CANCEL_SUPPLIER_ORDER(134:18) ==> SP_CANCEL_SUPPLIER_INVOICE(36:5) ==> SP_CHECK_TO_STOP_WORK(32:12) ==> SP_HALT_ON_ERROR(57:17)
IP                              ::1/39410
TRN_ID                          181735
ATT_ID                          579
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: 9149.34 28279 914934
customer order: creation 185.72 326 18572
customer order: refuse 15.59 354 1559
order to supplier: creation 49.96 1286 4996
order to supplier: removal 3.25 89878 325
invoice (draft): creation 47.94 3606 4794
invoice (draft): removal 47.16 769 4716
invoice accept: apply 45.20 21649 4520
invoice accept: cancel 42.05 906 4205
customer reserve: creation 4287.86 207 428786
customer reserve: removal 4127.92 55 412792
realization accept: apply 91.09 210 9109
realization accept: cancel 65.40 129 6540
payment from customer: creation 64.64 139 6464
payment from customer: removal 5.87 105 587
payment to supplier: creation 52.94 149 5294
payment to supplier: removal 3.44 91 344
service: total inventory turnovers 4.94 1422 494
service: total monetary turnovers 7.52 52 752
service: aggregate perf. data 0.82 22652 82
service: refresh index statistics 0.03 421601 3

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:03, from 14-04-2024 22:12:21 to 14-04-2024 22:12:24.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 3564
TEST_TIME 2 3793
TEST_TIME 3 3330
TEST_TIME 4 3592
TEST_TIME 5 3612
TEST_TIME 6 3752
TEST_TIME 7 4581
TEST_TIME 8 4780
TEST_TIME 9 5551
TEST_TIME 10 5469
TEST_TIME 11 5838
TEST_TIME 12 6242
TEST_TIME 13 7041
TEST_TIME 14 7090
TEST_TIME 15 7090
TEST_TIME 16 7506
TEST_TIME 17 7659
TEST_TIME 18 8098
TEST_TIME 19 8050
TEST_TIME 20 8042
TEST_TIME 21 8261
TEST_TIME 22 8524
TEST_TIME 23 8946
TEST_TIME 24 9055
TEST_TIME 25 9117
TEST_TIME 26 9083
TEST_TIME 27 9218
TEST_TIME 28 9681
TEST_TIME 29 9552
TEST_TIME 30 9671
TEST_TIME 31 9727
TEST_TIME 32 9724
TEST_TIME 33 9721
TEST_TIME 34 9743
TEST_TIME 35 9675
TEST_TIME 36 9697
TEST_TIME 37 9588
TEST_TIME 38 9489
TEST_TIME 39 9431
TEST_TIME 40 9393
TEST_TIME 41 9397
TEST_TIME 42 9337
TEST_TIME 43 9257
TEST_TIME 44 9273
TEST_TIME 45 9129
TEST_TIME 46 9190
TEST_TIME 47 9145
TEST_TIME 48 9154
TEST_TIME 49 9202
TEST_TIME 50 9156
TEST_TIME 51 9065
TEST_TIME 52 8985
TEST_TIME 53 9030
TEST_TIME 54 8973
TEST_TIME 55 8909
TEST_TIME 56 8869
TEST_TIME 57 8822
TEST_TIME 58 8727
TEST_TIME 59 8816
TEST_TIME 60 8828
TEST_TIME 61 8857
TEST_TIME 62 8875
TEST_TIME 63 8917
TEST_TIME 64 8936
TEST_TIME 65 8978
TEST_TIME 66 8973
TEST_TIME 67 9012
TEST_TIME 68 9057
TEST_TIME 69 9153
TEST_TIME 70 9260
TEST_TIME 71 9196
TEST_TIME 72 9265
TEST_TIME 73 9187
TEST_TIME 74 9096
TEST_TIME 75 9071
TEST_TIME 76 9066
TEST_TIME 77 9027
TEST_TIME 78 9097
TEST_TIME 79 9133
TEST_TIME 80 9130
TEST_TIME 81 9119
TEST_TIME 82 9146
TEST_TIME 83 9145
TEST_TIME 84 9167
TEST_TIME 85 9218
TEST_TIME 86 9244
TEST_TIME 87 9278
TEST_TIME 88 9266
TEST_TIME 89 9291
TEST_TIME 90 9323
TEST_TIME 91 9314
TEST_TIME 92 9240
TEST_TIME 93 9220
TEST_TIME 94 9246
TEST_TIME 95 9204
TEST_TIME 96 9216
TEST_TIME 97 9222
TEST_TIME 98 9188
TEST_TIME 99 9189
TEST_TIME 100 9156

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:03, from 14-04-2024 22:12:25 to 14-04-2024 22:12:28.

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 1305327 1305327 0 0.00 0 26389 8 0 0
doc_list_biud 1305327 1305327 0 0.00 0 89856 23 0 0
sp_add_invoice_to_stock 4661 4520 141 3.02 47 216300 21650 0 141
sp_cancel_adding_invoice 4205 4205 0 0.00 4 72830 907 0 0
sp_cancel_client_order 1559 1559 0 0.00 4 9020 354 0 0
sp_cancel_customer_reserve 412792 412792 0 0.00 0 28666 55 0 0
sp_cancel_pay_from_customer 587 587 0 0.00 3 7756 106 0 0
sp_cancel_pay_to_supplier 344 344 0 0.00 3 2108 92 0 0
sp_cancel_supplier_invoice 4725 4716 9 0.19 1 89861 770 0 9
sp_cancel_supplier_order 325 325 0 0.00 8 956685 89879 0 0
sp_cancel_write_off 6540 6540 0 0.00 1 8047 129 0 0
sp_client_order 18572 18572 0 0.00 3 26868 327 0 0
sp_customer_reserve 428786 428786 0 0.00 0 50561 208 0 0
sp_fill_shopping_cart 28356 28356 0 0.00 1 14319 39 0 0
sp_fill_shopping_cart_clo_res 428776 428776 0 0.00 0 27447 14 0 0
sp_get_clo_for_invoice 4508 4508 0 0.00 0 25633 304 0 0
sp_kill_cost_storno 11676 11676 0 0.00 0 8999 64 0 0
sp_kill_qstorno_ret_qs2qd 837165 837165 0 0.00 0 89855 30 0 0
sp_kill_qty_storno 443750 443750 0 0.00 0 89856 67 0 0
sp_lock_selected_doc 18767 18767 0 0.00 0 7706 4 0 0
sp_make_cost_storno 25371 25371 0 0.00 0 26382 68 0 0
sp_multiply_rows_for_pdistr 25371 25371 0 0.00 0 9463 31 0 0
sp_multiply_rows_for_qdistr 18572 18572 0 0.00 0 16804 128 0 0
sp_pay_from_customer 6464 6464 0 0.00 4 21495 139 0 0
sp_pay_to_supplier 5294 5294 0 0.00 4 11291 149 0 0
sp_payment_common 11758 11758 0 0.00 2 21485 38 0 0
sp_qd_handle_on_cancel_clo 1559 1559 0 0.00 0 9012 326 0 0
sp_qd_handle_on_invoice_upd_sts 8709 8709 0 0.00 0 27538 389 0 0
sp_qd_handle_on_reserve_upd_sts 9109 9109 0 0.00 0 25210 60 0 0
sp_reserve_write_off 9109 9109 0 0.00 6 26406 211 0 0
sp_supplier_invoice 4794 4794 0 0.00 5 92104 3606 0 0
sp_supplier_order 4996 4996 0 0.00 4 41983 1287 0 0
srv_aggregate_perf_data 82 82 0 0.00 1386 350708 22653 0 0
srv_fill_mon_cache_memory 56 56 0 0.00 1193 148633 40808 0 0
srv_find_qd_qs_mism 868200 868200 0 0.00 0 19621 7 0 0
srv_make_invnt_saldo 494 494 0 0.00 48 61526 1423 0 0
srv_make_money_saldo 752 752 0 0.00 0 11774 53 0 0
srv_recalc_idx_stat 3 3 0 0.00 136182 618004 421602 0 0
t$perf-abend:sp_add_invoice_to_stock 141 141 0 0.00 0 0 0 0 0
t$perf-abend:sp_cancel_supplier_invoice 9 9 0 0.00 0 0 0 0 0
t$perf-norm:sp_add_invoice_to_stock 4520 4520 0 0.00 0 10415 208 0 0
t$perf-norm:sp_cancel_adding_invoice 359 359 0 0.00 0 4323 83 0 0
t$perf-norm:sp_cancel_client_order 1559 1559 0 0.00 0 3543 23 0 0
t$perf-norm:sp_cancel_customer_reserve 635 635 0 0.00 0 3139 17 0 0
t$perf-norm:sp_cancel_pay_from_customer 587 587 0 0.00 0 1934 9 0 0
t$perf-norm:sp_cancel_pay_to_supplier 344 344 0 0.00 0 294 3 0 0
t$perf-norm:sp_cancel_supplier_invoice 387 387 0 0.00 0 743 17 0 0
t$perf-norm:sp_cancel_supplier_order 325 325 0 0.00 0 17992 1581 0 0
t$perf-norm:sp_cancel_write_off 959 959 0 0.00 0 1431 10 0 0
t$perf-norm:sp_client_order 18572 18572 0 0.00 0 7277 18 0 0
t$perf-norm:sp_customer_reserve 938 938 0 0.00 0 494 5 0 0
t$perf-norm:sp_pay_from_customer 6464 6464 0 0.00 0 6654 13 0 0
t$perf-norm:sp_pay_to_supplier 5294 5294 0 0.00 0 2302 10 0 0
t$perf-norm:sp_reserve_write_off 9109 9109 0 0.00 0 6155 13 0 0
t$perf-norm:sp_supplier_invoice 4794 4794 0 0.00 0 7512 23 0 0
t$perf-norm:sp_supplier_order 4996 4996 0 0.00 0 2329 20 0 0
t$perf-norm:srv_aggregate_perf_data 82 82 0 0.00 0 186 6 0 0
t$perf-norm:srv_fill_mon_cache_memory 56 56 0 0.00 0 254 5 0 0
t$perf-norm:srv_make_invnt_saldo 494 494 0 0.00 0 652 31 0 0
t$perf-norm:srv_make_money_saldo 752 752 0 0.00 0 4578 27 0 0
t$perf-norm:srv_recalc_idx_stat 3 3 0 0.00 1 7 4 0 0
v_add_invoice_to_stock 9290 9008 282 3.03 0 8678 20 0 282
v_all_customers 34096 34096 0 0.00 0 22 1 0 0
v_all_suppliers 27734 27734 0 0.00 0 42 1 0 0
v_all_wares 37140 37140 0 0.00 0 40 1 0 0
v_cancel_adding_invoice 718 718 0 0.00 0 577 7 0 0
v_cancel_client_order 3118 3118 0 0.00 0 3266 5 0 0
v_cancel_customer_prepayment 1174 1174 0 0.00 0 1216 4 0 0
v_cancel_customer_reserve 1270 1270 0 0.00 0 4408 10 0 0
v_cancel_payment_to_supplier 688 688 0 0.00 0 1899 9 0 0
v_cancel_supplier_invoice 792 774 18 2.27 0 2138 22 0 18
v_cancel_supplier_order 650 650 0 0.00 0 224 3 0 0
v_cancel_write_off 1918 1918 0 0.00 0 5773 22 0 0
v_max_id_clo_ord 4992 4992 0 0.00 0 236 2 0 0
v_max_id_clo_res 938 938 0 0.00 0 2898 14 0 0
v_max_id_ord_sup 4794 4794 0 0.00 0 4351 6 0 0
v_max_non_paid_invoice 1213 1213 0 0.00 0 426 4 0 0
v_max_non_paid_realizn 3299 3299 0 0.00 0 7043 9 0 0
v_min_id_clo_ord 4992 4992 0 0.00 0 7617 7 0 0
v_min_id_clo_res 938 938 0 0.00 0 10388 16 0 0
v_min_id_ord_sup 4794 4794 0 0.00 0 4145 4 0 0
v_min_non_paid_invoice 5294 5294 0 0.00 0 11248 26 0 0
v_min_non_paid_realizn 6464 6464 0 0.00 0 11890 26 0 0
v_our_firm 9374 9374 0 0.00 0 34 1 0 0
v_reserve_write_off 18216 18216 0 0.00 0 9019 10 0 0
x_lock_depdocs_on_canc_invoice 8534 8534 0 0.00 0 20282 156 0 0
x_lock_depdocs_on_canc_sup_ord 325 325 0 0.00 0 12462 442 0 0
x_make_qstorno_1000_1200 4996 4996 0 0.00 1 41974 1194 0 0
x_make_qstorno_1200_2000 4794 4794 0 0.00 2 90875 3476 0 0
x_make_qstorno_2100_3300 428786 428786 0 0.00 0 50531 190 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 14-04-2024 22:12:29 to 14-04-2024 22:12:33.

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
20:09:47 1 8192000000 8797116944 8807743488 3953616 0.048 1 1 2 0 4051888 55488 42784
20:10:48 18809 8192000000 9897793024 10204205056 970903936 10.596 100 88 176 0 999131968 5365312 22862720
20:12:10 28838 8192000000 9942952400 10263465984 1023284384 11.104 100 92 184 0 1055634736 8515568 23834784
20:13:50 11228 8192000000 9979679712 10310529024 1059516288 11.452 100 85 170 0 1090893552 10107840 21269424
20:15:04 11101 8192000000 10025741808 10370392064 1110018336 11.933 100 82 164 0 1140552224 11116480 19417408
20:16:19 9517 8192000000 10065076640 10421821440 1151162560 12.320 100 74 146 0 1179701472 11551584 16987328
20:17:31 5307 8192000000 10119885744 10485252096 1201437696 12.790 100 78 156 1 1230833152 12149456 17246000
20:18:37 5193 8192000000 10155066592 10528231424 1238505728 13.132 100 91 182 0 1272182576 14417056 19259792
20:19:47 924 8192000000 10183535712 10563174400 1265835184 13.383 100 83 164 0 1297578112 13566400 18176528
20:20:50 898 8192000000 10205760304 10589511680 1291627296 13.619 100 83 162 0 1323606848 14097280 17882272
20:21:51 7609 8192000000 10202577616 10594766848 1297615888 13.674 100 70 141 0 1323957424 11301504 15040032
20:23:00 9817 8192000000 10186612224 10597900288 1301761200 13.711 100 15 30 0 1315005376 10058544 3185632
20:24:16 4707 8192000000 10199259744 10610651136 1312963808 13.813 100 15 28 1 1321194752 5242832 2988112
20:25:23 7727 8192000000 10198344832 10617135104 1316900592 13.849 100 16 32 0 1326166336 5740176 3525568
20:26:37 44063 8192000000 10239478736 10638995456 1325766992 13.929 100 47 94 0 1344094832 6843120 11484720
20:28:22 5616 8192000000 10226323952 10646609920 1335135072 14.014 100 34 68 1 1350591824 8273776 7182976
20:29:30 5195 8192000000 10232531680 10653392896 1339777312 14.055 100 31 62 0 1353439824 6870576 6791936
20:30:42 6740 8192000000 10245511968 10649915392 1328972208 13.958 99 56 103 2 1350619760 9811520 11836032
20:31:53 62558 8192000000 10222411648 10633723904 1278010672 13.495 95 46 90 0 1300859760 11245680 11603408
20:34:10 12920 8192000000 10217347472 10627022848 1312632944 13.810 99 45 89 0 1335794480 13312080 9849456
20:35:30 11978 8192000000 10234494768 10639708160 1303182384 13.724 98 44 88 0 1332305184 19173168 9949632
20:36:46 4088 8192000000 10211238144 10615083008 1295095744 13.651 99 45 90 1 1324292976 18938112 10259120
20:38:05 5345 8192000000 10217943648 10617188352 1291289584 13.616 99 50 100 0 1319940256 17000944 11649728
20:39:18 14586 8192000000 10221262016 10624016384 1306948784 13.758 100 47 91 1 1333826016 16204064 10673168
20:40:39 9444 8192000000 10218239744 10622275584 1289251360 13.597 98 37 73 0 1319243168 21367744 8624064
20:41:54 4142 8192000000 10224536720 10619400192 1301215792 13.706 100 71 137 0 1338688864 21389104 16083968
20:43:03 7740 8192000000 10226589344 10623557632 1303534416 13.727 99 56 111 0 1330874064 15228304 12111344
20:44:14 1190 8192000000 10263671040 10657214464 1328046064 13.949 100 77 153 1 1365706912 19624944 18035904
20:45:22 1880 8192000000 10276113904 10677485568 1341576288 14.072 100 78 156 1 1381474752 21646912 18251552
20:46:27 2079 8192000000 10291144016 10691317760 1342516608 14.080 99 87 175 1 1384357040 20612992 21227440
20:47:34 1646 8192000000 10312654080 10713006080 1372422816 14.349 100 96 191 1 1417682032 23055248 22203968
20:48:39 9525 8192000000 10312288736 10724003840 1378971616 14.407 100 71 141 1 1417777536 21864160 16941760
20:49:54 1895 8192000000 10335892720 10747641856 1391175008 14.516 100 81 162 0 1436839520 26403152 19261360
20:51:01 3474 8192000000 10336412416 10750943232 1392078192 14.524 100 76 147 1 1442147488 30850032 19219264
20:52:09 13519 8192000000 10317481264 10758922240 1398868128 14.585 100 23 47 1 1426981584 21938384 6175072
20:53:25 11567 8192000000 10327521408 10770837504 1406992016 14.657 100 25 49 1 1437303216 23997680 6313520
20:54:46 14637 8192000000 10343748144 10779643904 1409453488 14.679 100 41 80 1 1445586064 25483104 10649472
20:56:08 1315 8192000000 10366210496 10790125568 1412384720 14.705 100 78 155 1 1464947776 33225440 19337616
20:57:11 32811 8192000000 10348978512 10795208704 1399781120 14.593 99 40 80 2 1447906576 37358256 10767200
20:59:07 36126 8192000000 10317913152 10779299840 1400733696 14.602 100 16 32 1 1431554256 26905792 3914768
21:00:47 9972 8192000000 10331805760 10778157056 1397940512 14.577 99 39 78 0 1425578848 18557136 9081200
21:02:08 55523 8192000000 10310961424 10770456576 1402615424 14.618 100 24 46 1 1425933936 17642592 5675920
21:04:08 69398 8192000000 10310897024 10774294528 1403524976 14.626 100 23 45 0 1423511312 14733232 5253104
21:06:25 45131 8192000000 10331761024 10774110208 1402555312 14.618 100 35 67 1 1431799792 20916144 8328336
21:08:11 113873 8192000000 10296351200 10747322368 1390420640 14.510 100 24 48 0 1410469664 14113920 5935104
21:11:30 46469 8192000000 10295127104 10739855360 1358011696 14.220 97 36 72 2 1377590400 10944016 8634688
21:14:32 14300 8192000000 10285207456 10722979840 1350649216 14.153 97 41 76 1 1367865568 9829424 7386928
21:15:48 22184 8192000000 10275550304 10713649152 1345853568 14.110 99 41 83 0 1369208192 13193632 10160992
21:17:11 56405 8192000000 10247734688 10690007040 1293907040 13.640 95 21 42 0 1311062256 12386176 4769040
21:19:09 83549 8192000000 10258819072 10705047552 1340298192 14.060 98 19 38 0 1354912384 9634848 4979344
21:21:37 53107 8192000000 10263778528 10718031872 1350927904 14.156 99 18 36 0 1366657920 11325168 4404848
21:23:46 59471 8192000000 10223255360 10672570368 1283386928 13.544 96 33 66 0 1308376464 18120752 6868784
21:25:45 51431 8192000000 10218544512 10663665664 1312649312 13.810 99 16 32 0 1326665616 10290992 3725312
21:27:38 112255 8192000000 10224689888 10690076672 1263729024 13.364 95 4 8 0 1276775280 12176512 869744
21:30:31 40337 8192000000 10229488432 10676051968 1314201536 13.824 98 32 64 0 1334744288 13294656 7248096
21:32:16 30205 8192000000 10234892080 10673831936 1315316176 13.834 98 24 44 0 1328734256 8107536 5310544
21:33:47 77577 8192000000 10261061120 10698928128 1319400496 13.871 98 19 38 0 1335431728 12073440 3957792
21:36:10 33528 8192000000 10268676928 10708496384 1347006352 14.121 99 30 60 0 1369622624 15732576 6883696
21:37:45 119724 8192000000 10279550800 10728701952 1358763504 14.226 100 10 20 0 1381440400 20371648 2305248
21:40:53 130077 8192000000 10288279536 10747645952 1383307920 14.446 100 10 21 0 1402927216 17666608 1952688
21:44:22 16659 8192000000 10288123872 10730909696 1384916192 14.460 100 58 114 1 1410704448 12825696 12962560
21:45:39 47092 8192000000 10292656352 10752393216 1384777280 14.459 100 10 20 0 1396951552 9927344 2246928
21:47:27 119134 8192000000 10295629808 10743697408 1362056784 14.256 98 16 32 0 1375423680 9822896 3544000
21:50:38 43448 8192000000 10308028304 10759471104 1385575472 14.466 99 38 76 1 1404375184 10161920 8637792
21:52:22 29474 8192000000 10296953648 10751033344 1380804576 14.424 99 8 16 0 1389869216 7364976 1699664
21:53:52 113236 8192000000 10293424528 10750304256 1279345552 13.507 92 13 26 0 1292927104 10959712 2621840
21:56:46 148633 8192000000 10275422144 10715201536 1244999920 13.192 90 13 25 0 1261152048 13979488 2172640
22:00:15 49323 8192000000 10276048624 10718408704 1306363728 13.753 96 22 41 1 1328627008 17639760 4623520
22:02:08 80084 8192000000 10285085536 10725109760 1321453408 13.890 97 22 39 0 1343971312 17701632 4816272
22:04:33 6393 8192000000 10259739008 10705551360 1342391824 14.079 100 28 56 2 1363746640 15456016 5898800
22:05:40 44448 8192000000 10235195504 10690154496 1314982656 13.831 97 13 26 0 1326788320 9009296 2796368
22:07:25 31387 8192000000 10230436432 10673524736 1330353104 13.970 99 19 38 0 1342177168 7641408 4182656
22:08:57 60133 8192000000 9436286512 9752260608 562769856 6.428 42 8 16 0 568794816 4092080 1932880

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:14, from 14-04-2024 22:12:35 to 14-04-2024 22:12:49.

Exceptions occured during test was in run

FB_MNEMONA CNT UNIT FB_GDSCODE
except 141 v_add_invoice_to_stock 335544517
except 9 v_cancel_supplier_invoice 335544517

Completed "Exceptions occured during test was in run". Done for 00:00:02, from 14-04-2024 22:12:50 to 14-04-2024 22:12:52.

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          185367
MON$OLDEST_ACTIVE               185368
MON$OLDEST_SNAPSHOT             185368
MON$NEXT_TRANSACTION            185368
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                       1918624
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 Sun Apr 14 22:12:53 2024 
 
Database header page information: 
    Flags            0 
    Generation        96891 
    System Change Number    0 
    Page size        8192 
    ODS version        12.0 
    Oldest transaction    185367 
    Oldest active        185368 
    Oldest snapshot        185368 
    Next transaction    185369 
    Sequence number        0 
    Next attachment ID    738 
    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.72, total records: 7791262 
    Average version length: 48.17, total versions: 28431, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 64.00, compression ratio: 1.34 
    Pointer pages: 54, data page slots: 87520 
    Data pages: 87520, average fill: 71% 
    Primary pages: 87520, secondary pages: 0, swept pages: 35350 
    Empty pages: 7, full pages: 55549 
    Fill distribution: 
     0 - 19% = 12 
    20 - 39% = 45 
    40 - 59% = 1659 
    60 - 79% = 85801 
    80 - 99% = 3 
 
    Index DOC_DATA_DOC_WARE_UNQ (0) 
    Root page: 1510614, depth: 3, leaf buckets: 23447, nodes: 7791262 
    Average node length: 18.92, total dup: 0, max dup: 0 
    Average key length: 15.93, compression ratio: 1.70 
    Average prefix length: 14.07, average data length: 12.93 
    Clustering factor: 1725123, ratio: 0.22 
    Fill distribution: 
         0 - 19% = 319 
        20 - 39% = 1973 
        40 - 59% = 4136 
        60 - 79% = 2247 
        80 - 99% = 14772 
 
    Index DOC_DATA_ID_DESC (1) 
    Root page: 1528118, depth: 3, leaf buckets: 13624, nodes: 7791262 
    Average node length: 11.20, total dup: 0, max dup: 0 
    Average key length: 8.21, compression ratio: 1.10 
    Average prefix length: 3.78, average data length: 5.22 
    Clustering factor: 1547522, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 1718 
        40 - 59% = 2038 
        60 - 79% = 1017 
        80 - 99% = 8851 
 
    Index FK_DOC_DATA_DOC_LIST (2) 
    Root page: 1546711, depth: 3, leaf buckets: 8432, nodes: 7791262 
    Average node length: 6.63, total dup: 5807864, max dup: 49 
    Average key length: 3.64, compression ratio: 2.47 
    Average prefix length: 7.61, average data length: 1.39 
    Clustering factor: 1540503, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 128 
        20 - 39% = 1045 
        40 - 59% = 1407 
        60 - 79% = 859 
        80 - 99% = 4993 
 
DOC_LIST (138) 
    Primary pointer page: 472, Index root page: 473 
    Total formats: 1, used formats: 1 
    Average record length: 57.08, total records: 2275570 
    Average version length: 34.85, total versions: 30737, max versions: 3 
    Average fragment length: 8.00, total fragments: 2, max fragments: 1 
    Average unpacked length: 84.00, compression ratio: 1.47 
    Pointer pages: 18, data page slots: 28784 
    Data pages: 28784, average fill: 73% 
    Primary pages: 28778, secondary pages: 6, swept pages: 16633 
    Empty pages: 2, full pages: 18041 
    Fill distribution: 
     0 - 19% = 11 
    20 - 39% = 60 
    40 - 59% = 1016 
    60 - 79% = 27499 
    80 - 99% = 198 
 
    Index DOC_LIST_ID_DESC (1) 
    Root page: 1541130, depth: 3, leaf buckets: 4636, nodes: 2275570 
    Average node length: 11.40, total dup: 0, max dup: 0 
    Average key length: 8.44, compression ratio: 1.07 
    Average prefix length: 3.56, average data length: 5.44 
    Clustering factor: 701988, ratio: 0.31 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 1012 
        40 - 59% = 835 
        60 - 79% = 695 
        80 - 99% = 2094 
 
    Index DOC_LIST_WORKER_OPTYPE (2) 
    Root page: 1544376, depth: 3, leaf buckets: 2551, nodes: 2277259 
    Average node length: 4.97, total dup: 2276360, max dup: 20132 
    Average key length: 2.01, compression ratio: 4.47 
    Average prefix length: 8.99, average data length: 0.01 
    Clustering factor: 1261430, ratio: 0.55 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 268 
        40 - 59% = 1543 
        60 - 79% = 547 
        80 - 99% = 192 
 
    Index FK_DOC_LIST_AGENTS (3) 
    Root page: 1545909, depth: 3, leaf buckets: 2011, nodes: 2275570 
    Average node length: 4.97, total dup: 2275520, max dup: 130702 
    Average key length: 2.01, compression ratio: 4.48 
    Average prefix length: 8.99, average data length: 0.01 
    Clustering factor: 1074955, ratio: 0.47 
    Fill distribution: 
         0 - 19% = 4 
        20 - 39% = 51 
        40 - 59% = 1015 
        60 - 79% = 51 
        80 - 99% = 890 
 
    Index PK_DOC_LIST (0) 
    Root page: 1538187, depth: 3, leaf buckets: 4413, nodes: 2275570 
    Average node length: 11.40, total dup: 0, max dup: 0 
    Average key length: 8.44, compression ratio: 1.07 
    Average prefix length: 3.56, average data length: 5.44 
    Clustering factor: 701988, ratio: 0.31 
    Fill distribution: 
         0 - 19% = 81 
        20 - 39% = 670 
        40 - 59% = 622 
        60 - 79% = 765 
        80 - 99% = 2275 
 
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.30, total records: 400 
    Average version length: 22.99, total versions: 247176, max versions: 645 
    Average fragment length: 2.12, total fragments: 57, max fragments: 1 
    Average unpacked length: 104.00, compression ratio: 1.26 
    Pointer pages: 1, data page slots: 1592 
    Data pages: 1592, average fill: 77% 
    Primary pages: 195, secondary pages: 1397, swept pages: 0 
    Empty pages: 188, full pages: 1377 
    Fill distribution: 
     0 - 19% = 214 
    20 - 39% = 0 
    40 - 59% = 1 
    60 - 79% = 2 
    80 - 99% = 1375 
 
    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: 5.76, total records: 89911 
    Average version length: 68.28, total versions: 82333, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 88.00, compression ratio: 15.28 
    Pointer pages: 7, data page slots: 2000 
    Data pages: 1544, average fill: 73% 
    Primary pages: 1543, secondary pages: 1, swept pages: 94 
    Empty pages: 102, full pages: 1094 
    Fill distribution: 
     0 - 19% = 160 
    20 - 39% = 101 
    40 - 59% = 107 
    60 - 79% = 209 
    80 - 99% = 967 
 
    Index INVNT_TURNOVER_LOG_WARE_DD_ID (0) 
    Root page: 1707966, depth: 3, leaf buckets: 334, nodes: 89911 
    Average node length: 13.60, total dup: 4214, max dup: 2 
    Average key length: 10.84, compression ratio: 2.49 
    Average prefix length: 19.11, average data length: 7.89 
    Clustering factor: 67275, ratio: 0.75 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 126 
        40 - 59% = 156 
        60 - 79% = 52 
        80 - 99% = 0 
 
MONEY_SALDO (141) 
    Primary pointer page: 478, Index root page: 479 
    Total formats: 1, used formats: 1 
    Average record length: 15.27, total records: 49 
    Average version length: 9.00, total versions: 16248, max versions: 1034 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 32.00, compression ratio: 2.10 
    Pointer pages: 1, data page slots: 72 
    Data pages: 72, average fill: 74% 
    Primary pages: 6, secondary pages: 66, swept pages: 0 
    Empty pages: 5, full pages: 66 
    Fill distribution: 
     0 - 19% = 5 
    20 - 39% = 1 
    40 - 59% = 0 
    60 - 79% = 39 
    80 - 99% = 27 
 
    Index PK_MONEY_SALDO (0) 
    Root page: 1510361, depth: 1, leaf buckets: 1, nodes: 49 
    Average node length: 11.82, total dup: 0, max dup: 0 
    Average key length: 10.80, compression ratio: 0.83 
    Average prefix length: 1.18, average data length: 7.82 
    Clustering factor: 1, ratio: 0.02 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
MONEY_TURNOVER_LOG (140) 
    Primary pointer page: 476, Index root page: 477 
    Total formats: 1, used formats: 1 
    Average record length: 3.20, total records: 1473 
    Average version length: 43.29, total versions: 1366, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 58.00, compression ratio: 18.11 
    Pointer pages: 1, data page slots: 32 
    Data pages: 32, average fill: 45% 
    Primary pages: 31, secondary pages: 1, swept pages: 3 
    Empty pages: 8, full pages: 9 
    Fill distribution: 
     0 - 19% = 13 
    20 - 39% = 1 
    40 - 59% = 6 
    60 - 79% = 3 
    80 - 99% = 9 
 
    Index MONEY_TURNOVER_LOG_AGENT_OPTYPE (0) 
    Root page: 93859, depth: 2, leaf buckets: 3, nodes: 1473 
    Average node length: 4.40, total dup: 1375, max dup: 169 
    Average key length: 2.71, compression ratio: 7.02 
    Average prefix length: 18.36, average data length: 0.64 
    Clustering factor: 792, ratio: 0.54 
    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.21, total records: 73 
    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: 51% 
    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: 73 
    Average node length: 11.68, total dup: 0, max dup: 0 
    Average key length: 10.67, compression ratio: 0.84 
    Average prefix length: 1.32, average data length: 7.68 
    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: 36.58, total records: 737515 
    Average version length: 25.66, total versions: 44922, max versions: 4 
    Average fragment length: 30.00, total fragments: 1, max fragments: 1 
    Average unpacked length: 54.00, compression ratio: 1.48 
    Pointer pages: 6, data page slots: 8312 
    Data pages: 8304, average fill: 62% 
    Primary pages: 8225, secondary pages: 79, swept pages: 3899 
    Empty pages: 194, full pages: 4000 
    Fill distribution: 
     0 - 19% = 459 
    20 - 39% = 590 
    40 - 59% = 781 
    60 - 79% = 6311 
    80 - 99% = 163 
 
    Index PDISTR_AGENT_ID (2) 
    Root page: 1509308, depth: 2, leaf buckets: 876, nodes: 737515 
    Average node length: 4.86, total dup: 737466, max dup: 134962 
    Average key length: 2.01, compression ratio: 4.47 
    Average prefix length: 8.99, average data length: 0.01 
    Clustering factor: 83096, ratio: 0.11 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 210 
        40 - 59% = 487 
        60 - 79% = 139 
        80 - 99% = 40 
 
    Index PDISTR_SNDOP_RCVOP_SNDID_ASC (0) 
    Root page: 1508613, depth: 3, leaf buckets: 841, nodes: 737515 
    Average node length: 5.86, total dup: 656828, max dup: 43 
    Average key length: 3.02, compression ratio: 7.30 
    Average prefix length: 21.09, average data length: 0.91 
    Clustering factor: 144977, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 127 
        40 - 59% = 228 
        60 - 79% = 210 
        80 - 99% = 274 
 
    Index PDISTR_SNDOP_RCVOP_SNDID_DESC (1) 
    Root page: 1509187, depth: 3, leaf buckets: 892, nodes: 737515 
    Average node length: 5.87, total dup: 656828, max dup: 43 
    Average key length: 3.02, compression ratio: 7.29 
    Average prefix length: 21.09, average data length: 0.91 
    Clustering factor: 146926, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 225 
        40 - 59% = 207 
        60 - 79% = 204 
        80 - 99% = 256 
 
    Index PDISTR_WORKER_SND_ID (3) 
    Root page: 1510178, depth: 3, leaf buckets: 1082, nodes: 737515 
    Average node length: 5.95, total dup: 656828, max dup: 43 
    Average key length: 3.10, compression ratio: 5.49 
    Average prefix length: 16.01, average data length: 0.99 
    Clustering factor: 140228, ratio: 0.19 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 282 
        40 - 59% = 573 
        60 - 79% = 154 
        80 - 99% = 71 
 
PERF_AGG (158) 
    Primary pointer page: 512, Index root page: 513 
    Total formats: 1, used formats: 1 
    Average record length: 62.86, total records: 5457 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 2.86, total fragments: 76, 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: 71, secondary pages: 25, swept pages: 56 
    Empty pages: 14, full pages: 66 
    Fill distribution: 
     0 - 19% = 25 
    20 - 39% = 1 
    40 - 59% = 1 
    60 - 79% = 69 
    80 - 99% = 0 
 
    Index PERF_AGG_UNQ (1) 
    Root page: 1504238, depth: 2, leaf buckets: 7, nodes: 5457 
    Average node length: 5.48, total dup: 0, max dup: 0 
    Average key length: 3.58, compression ratio: 10.05 
    Average prefix length: 34.41, average data length: 1.55 
    Clustering factor: 5122, ratio: 0.94 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 4 
        60 - 79% = 1 
        80 - 99% = 1 
 
    Index PK_PERF_AGG (0) 
    Root page: 1504233, depth: 2, leaf buckets: 10, nodes: 5457 
    Average node length: 11.11, total dup: 0, max dup: 0 
    Average key length: 9.21, compression ratio: 0.98 
    Average prefix length: 2.79, average data length: 6.21 
    Clustering factor: 142, 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.11, total records: 84232 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 48.00, compression ratio: 1.23 
    Pointer pages: 1, data page slots: 816 
    Data pages: 816, average fill: 71% 
    Primary pages: 816, secondary pages: 0, swept pages: 0 
    Empty pages: 4, full pages: 811 
    Fill distribution: 
     0 - 19% = 5 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 811 
    80 - 99% = 0 
 
    Index PK_PERF_ESTIMATED (0) 
    Root page: 40624, depth: 2, leaf buckets: 107, nodes: 84232 
    Average node length: 10.18, total dup: 0, max dup: 0 
    Average key length: 8.19, compression ratio: 1.10 
    Average prefix length: 3.81, average data length: 5.19 
    Clustering factor: 3523, ratio: 0.04 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 0 
        40 - 59% = 1 
        60 - 79% = 1 
        80 - 99% = 105 
 
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.22, 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.20 
    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: 148.82, total records: 169112 
    Average version length: 152.48, total versions: 2326, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.40 
    Pointer pages: 7, data page slots: 4800 
    Data pages: 4080, average fill: 85% 
    Primary pages: 4080, secondary pages: 0, swept pages: 9 
    Empty pages: 64, full pages: 3993 
    Fill distribution: 
     0 - 19% = 67 
    20 - 39% = 6 
    40 - 59% = 9 
    60 - 79% = 5 
    80 - 99% = 3993 
 
PERF_SPLIT_1 (282) 
    Primary pointer page: 576, Index root page: 577 
    Total formats: 1, used formats: 1 
    Average record length: 150.62, total records: 166880 
    Average version length: 144.36, total versions: 355, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.26 
    Pointer pages: 7, data page slots: 5016 
    Data pages: 4000, average fill: 86% 
    Primary pages: 4000, secondary pages: 0, swept pages: 21 
    Empty pages: 42, full pages: 3944 
    Fill distribution: 
     0 - 19% = 42 
    20 - 39% = 8 
    40 - 59% = 2 
    60 - 79% = 4 
    80 - 99% = 3944 
 
PERF_SPLIT_2 (283) 
    Primary pointer page: 578, Index root page: 579 
    Total formats: 1, used formats: 1 
    Average record length: 148.01, total records: 167961 
    Average version length: 153.31, total versions: 3100, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.46 
    Pointer pages: 8, data page slots: 5744 
    Data pages: 4048, average fill: 85% 
    Primary pages: 4048, secondary pages: 0, swept pages: 8 
    Empty pages: 59, full pages: 3965 
    Fill distribution: 
     0 - 19% = 65 
    20 - 39% = 7 
    40 - 59% = 5 
    60 - 79% = 7 
    80 - 99% = 3964 
 
PERF_SPLIT_3 (284) 
    Primary pointer page: 580, Index root page: 581 
    Total formats: 1, used formats: 1 
    Average record length: 142.83, total records: 203715 
    Average version length: 154.73, total versions: 11409, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.87 
    Pointer pages: 8, data page slots: 6512 
    Data pages: 4928, average fill: 86% 
    Primary pages: 4928, secondary pages: 0, swept pages: 5 
    Empty pages: 72, full pages: 4822 
    Fill distribution: 
     0 - 19% = 76 
    20 - 39% = 11 
    40 - 59% = 4 
    60 - 79% = 15 
    80 - 99% = 4822 
 
PERF_SPLIT_4 (285) 
    Primary pointer page: 582, Index root page: 583 
    Total formats: 1, used formats: 1 
    Average record length: 148.42, total records: 159993 
    Average version length: 152.95, total versions: 2687, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.43 
    Pointer pages: 7, data page slots: 4160 
    Data pages: 3848, average fill: 86% 
    Primary pages: 3848, secondary pages: 0, swept pages: 5 
    Empty pages: 53, full pages: 3786 
    Fill distribution: 
     0 - 19% = 57 
    20 - 39% = 3 
    40 - 59% = 1 
    60 - 79% = 1 
    80 - 99% = 3786 
 
PERF_SPLIT_5 (286) 
    Primary pointer page: 584, Index root page: 585 
    Total formats: 1, used formats: 1 
    Average record length: 148.66, total records: 165958 
    Average version length: 152.79, total versions: 2387, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.41 
    Pointer pages: 6, data page slots: 4392 
    Data pages: 3968, average fill: 86% 
    Primary pages: 3968, secondary pages: 0, swept pages: 8 
    Empty pages: 35, full pages: 3922 
    Fill distribution: 
     0 - 19% = 36 
    20 - 39% = 5 
    40 - 59% = 5 
    60 - 79% = 1 
    80 - 99% = 3921 
 
PERF_SPLIT_6 (287) 
    Primary pointer page: 586, Index root page: 587 
    Total formats: 1, used formats: 1 
    Average record length: 149.59, total records: 169663 
    Average version length: 152.33, total versions: 1462, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.34 
    Pointer pages: 8, data page slots: 4960 
    Data pages: 4104, average fill: 85% 
    Primary pages: 4104, secondary pages: 0, swept pages: 13 
    Empty pages: 78, full pages: 4008 
    Fill distribution: 
     0 - 19% = 80 
    20 - 39% = 9 
    40 - 59% = 3 
    60 - 79% = 5 
    80 - 99% = 4007 
 
PERF_SPLIT_7 (288) 
    Primary pointer page: 588, Index root page: 589 
    Total formats: 1, used formats: 1 
    Average record length: 146.74, total records: 166338 
    Average version length: 153.31, total versions: 4632, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.56 
    Pointer pages: 7, data page slots: 5296 
    Data pages: 4000, average fill: 86% 
    Primary pages: 3999, secondary pages: 1, swept pages: 7 
    Empty pages: 50, full pages: 3931 
    Fill distribution: 
     0 - 19% = 56 
    20 - 39% = 5 
    40 - 59% = 2 
    60 - 79% = 5 
    80 - 99% = 3932 
 
PERF_SPLIT_8 (289) 
    Primary pointer page: 590, Index root page: 591 
    Total formats: 1, used formats: 1 
    Average record length: 148.90, total records: 178049 
    Average version length: 153.40, total versions: 2543, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.39 
    Pointer pages: 8, data page slots: 4816 
    Data pages: 4272, average fill: 86% 
    Primary pages: 4272, secondary pages: 0, swept pages: 14 
    Empty pages: 44, full pages: 4210 
    Fill distribution: 
     0 - 19% = 47 
    20 - 39% = 3 
    40 - 59% = 3 
    60 - 79% = 8 
    80 - 99% = 4211 
 
PERF_SPLIT_9 (290) 
    Primary pointer page: 593, Index root page: 594 
    Total formats: 1, used formats: 1 
    Average record length: 145.04, total records: 184720 
    Average version length: 154.48, total versions: 7288, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.69 
    Pointer pages: 6, data page slots: 7264 
    Data pages: 4488, average fill: 85% 
    Primary pages: 4488, secondary pages: 0, swept pages: 6 
    Empty pages: 95, full pages: 4367 
    Fill distribution: 
     0 - 19% = 97 
    20 - 39% = 10 
    40 - 59% = 1 
    60 - 79% = 15 
    80 - 99% = 4365 
 
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: 52.45, total records: 2142760 
    Average version length: 52.86, total versions: 12470, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 70.00, compression ratio: 1.33 
    Pointer pages: 16, data page slots: 25808 
    Data pages: 25792, average fill: 71% 
    Primary pages: 25792, secondary pages: 0, swept pages: 12237 
    Empty pages: 191, full pages: 20692 
    Fill distribution: 
     0 - 19% = 369 
    20 - 39% = 333 
    40 - 59% = 1136 
    60 - 79% = 23856 
    80 - 99% = 98 
 
    Index PSTORNED_RCV_ID (1) 
    Root page: 1506186, depth: 3, leaf buckets: 2640, nodes: 2142760 
    Average node length: 5.44, total dup: 1999820, max dup: 1320 
    Average key length: 2.49, compression ratio: 3.62 
    Average prefix length: 8.58, average data length: 0.42 
    Clustering factor: 184197, ratio: 0.09 
    Fill distribution: 
         0 - 19% = 6 
        20 - 39% = 269 
        40 - 59% = 1795 
        60 - 79% = 297 
        80 - 99% = 273 
 
    Index PSTORNED_SND_ID (0) 
    Root page: 1504819, depth: 3, leaf buckets: 2765, nodes: 2142760 
    Average node length: 5.69, total dup: 1923397, max dup: 72 
    Average key length: 2.74, compression ratio: 3.29 
    Average prefix length: 8.36, average data length: 0.64 
    Clustering factor: 381868, ratio: 0.18 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 1 
        40 - 59% = 2311 
        60 - 79% = 422 
        80 - 99% = 31 
 
    Index PSTORNED_WORKER_ID (2) 
    Root page: 1507996, depth: 3, leaf buckets: 2163, nodes: 2142760 
    Average node length: 4.96, total dup: 2142660, max dup: 28552 
    Average key length: 2.00, compression ratio: 1.20 
    Average prefix length: 2.41, average data length: 0.00 
    Clustering factor: 182305, ratio: 0.09 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 180 
        40 - 59% = 1143 
        60 - 79% = 396 
        80 - 99% = 443 
 
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: 48.24, total records: 107970 
    Average version length: 69.17, total versions: 32746, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 2.61 
    Pointer pages: 4, data page slots: 5584 
    Data pages: 2984, average fill: 42% 
    Primary pages: 2984, secondary pages: 0, swept pages: 751 
    Empty pages: 635, full pages: 600 
    Fill distribution: 
     0 - 19% = 940 
    20 - 39% = 380 
    40 - 59% = 549 
    60 - 79% = 823 
    80 - 99% = 292 
 
    Index XQD_1000_1200_WA_SO_RO_WKR_SND (0) 
    Root page: 105316, depth: 3, leaf buckets: 213, nodes: 107970 
    Average node length: 6.46, total dup: 93921, max dup: 14 
    Average key length: 4.02, compression ratio: 10.46 
    Average prefix length: 40.11, average data length: 1.89 
    Clustering factor: 18509, ratio: 0.17 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 114 
        40 - 59% = 80 
        60 - 79% = 18 
        80 - 99% = 0 
 
XQD_1000_3300 (178) 
    Primary pointer page: 553, Index root page: 554 
    Total formats: 1, used formats: 1 
    Average record length: 66.70, total records: 6596712 
    Average version length: 68.81, total versions: 216720, 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: 62, data page slots: 99832 
    Data pages: 99832, average fill: 71% 
    Primary pages: 99832, secondary pages: 0, swept pages: 52358 
    Empty pages: 13, full pages: 54876 
    Fill distribution: 
     0 - 19% = 127 
    20 - 39% = 1389 
    40 - 59% = 12442 
    60 - 79% = 83400 
    80 - 99% = 2474 
 
    Index XQD_1000_3300_WA_SO_RO_WKR_SND (0) 
    Root page: 1480454, depth: 3, leaf buckets: 10492, nodes: 6596712 
    Average node length: 6.51, total dup: 5704765, max dup: 29 
    Average key length: 3.53, compression ratio: 11.91 
    Average prefix length: 40.61, average data length: 1.39 
    Clustering factor: 1439086, ratio: 0.22 
    Fill distribution: 
         0 - 19% = 13 
        20 - 39% = 2224 
        40 - 59% = 5679 
        60 - 79% = 2285 
        80 - 99% = 291 
 
    Index XQD_1000_3300_WKR_DOC_ASC (1) 
    Root page: 1486068, depth: 3, leaf buckets: 8306, nodes: 6596712 
    Average node length: 5.41, total dup: 6323692, max dup: 128 
    Average key length: 2.42, compression ratio: 7.02 
    Average prefix length: 16.62, average data length: 0.38 
    Clustering factor: 1260027, ratio: 0.19 
    Fill distribution: 
         0 - 19% = 9 
        20 - 39% = 1496 
        40 - 59% = 4553 
        60 - 79% = 1442 
        80 - 99% = 806 
 
    Index XQD_1000_3300_WKR_DOC_DEC (2) 
    Root page: 1490608, depth: 3, leaf buckets: 8350, nodes: 6596712 
    Average node length: 5.41, total dup: 6323692, max dup: 128 
    Average key length: 2.42, compression ratio: 7.02 
    Average prefix length: 16.62, average data length: 0.38 
    Clustering factor: 1262608, ratio: 0.19 
    Fill distribution: 
         0 - 19% = 10 
        20 - 39% = 1553 
        40 - 59% = 4538 
        60 - 79% = 1439 
        80 - 99% = 810 
 
XQD_1200_2000 (177) 
    Primary pointer page: 551, Index root page: 552 
    Total formats: 1, used formats: 1 
    Average record length: 67.94, total records: 11731793 
    Average version length: 68.80, total versions: 174106, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.85 
    Pointer pages: 103, data page slots: 167112 
    Data pages: 167112, average fill: 74% 
    Primary pages: 167112, secondary pages: 0, swept pages: 104876 
    Empty pages: 5, full pages: 131996 
    Fill distribution: 
     0 - 19% = 62 
    20 - 39% = 786 
    40 - 59% = 7208 
    60 - 79% = 156771 
    80 - 99% = 2285 
 
    Index XQD_1200_2000_WA_SO_RO_WKR_SND (0) 
    Root page: 1495028, depth: 3, leaf buckets: 18238, nodes: 11731793 
    Average node length: 6.57, total dup: 10227504, max dup: 58 
    Average key length: 3.43, compression ratio: 12.26 
    Average prefix length: 40.70, average data length: 1.30 
    Clustering factor: 2311450, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 28 
        20 - 39% = 2725 
        40 - 59% = 10732 
        60 - 79% = 4058 
        80 - 99% = 695 
 
XQD_2000_3300 (179) 
    Primary pointer page: 555, Index root page: 556 
    Total formats: 1, used formats: 1 
    Average record length: 50.53, total records: 1200024 
    Average version length: 69.09, total versions: 323076, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 2.49 
    Pointer pages: 29, data page slots: 45624 
    Data pages: 28576, average fill: 48% 
    Primary pages: 28576, secondary pages: 0, swept pages: 13331 
    Empty pages: 5698, full pages: 11923 
    Fill distribution: 
     0 - 19% = 9057 
    20 - 39% = 2968 
    40 - 59% = 2565 
    60 - 79% = 9932 
    80 - 99% = 4054 
 
    Index XQD_2000_3300_WA_SO_RO_WKR_SND (0) 
    Root page: 1479712, depth: 3, leaf buckets: 2001, nodes: 1200024 
    Average node length: 5.54, total dup: 1150517, max dup: 49 
    Average key length: 2.59, compression ratio: 16.19 
    Average prefix length: 41.45, average data length: 0.55 
    Clustering factor: 82756, ratio: 0.07 
    Fill distribution: 
         0 - 19% = 8 
        20 - 39% = 1043 
        40 - 59% = 740 
        60 - 79% = 193 
        80 - 99% = 17 
 
XQD_2100_3300 (180) 
    Primary pointer page: 557, Index root page: 558 
    Total formats: 1, used formats: 1 
    Average record length: 49.24, total records: 913753 
    Average version length: 69.12, total versions: 261974, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 2.56 
    Pointer pages: 24, data page slots: 37720 
    Data pages: 30016, average fill: 35% 
    Primary pages: 30016, secondary pages: 0, swept pages: 12553 
    Empty pages: 7125, full pages: 5027 
    Fill distribution: 
     0 - 19% = 12227 
    20 - 39% = 4868 
    40 - 59% = 4678 
    60 - 79% = 5547 
    80 - 99% = 2696 
 
    Index XQD_2100_3300_WA_SO_RO_WKR_SND (0) 
    Root page: 1479207, depth: 3, leaf buckets: 1574, nodes: 913753 
    Average node length: 5.82, total dup: 852591, max dup: 99 
    Average key length: 2.88, compression ratio: 14.59 
    Average prefix length: 41.19, average data length: 0.81 
    Clustering factor: 118424, ratio: 0.13 
    Fill distribution: 
         0 - 19% = 3 
        20 - 39% = 796 
        40 - 59% = 618 
        60 - 79% = 145 
        80 - 99% = 12 
 
XQD_3300_3400 (181) 
    Primary pointer page: 559, Index root page: 560 
    Total formats: 1, used formats: 1 
    Average record length: 67.48, total records: 9306743 
    Average version length: 68.99, total versions: 190839, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.87 
    Pointer pages: 89, data page slots: 145240 
    Data pages: 145216, average fill: 68% 
    Primary pages: 145216, secondary pages: 0, swept pages: 88583 
    Empty pages: 247, full pages: 68975 
    Fill distribution: 
     0 - 19% = 730 
    20 - 39% = 4237 
    40 - 59% = 24760 
    60 - 79% = 112906 
    80 - 99% = 2583 
 
    Index XQD_3300_3400_WA_SO_RO_WKR_SND (0) 
    Root page: 1472590, depth: 3, leaf buckets: 13612, nodes: 9306743 
    Average node length: 6.69, total dup: 7716753, max dup: 27 
    Average key length: 3.67, compression ratio: 11.44 
    Average prefix length: 40.50, average data length: 1.50 
    Clustering factor: 1975341, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 1301 
        40 - 59% = 6787 
        60 - 79% = 4793 
        80 - 99% = 729 
 
XQS_1000_1200 (182) 
    Primary pointer page: 561, Index root page: 562 
    Total formats: 1, used formats: 1 
    Average record length: 82.52, total records: 21211868 
    Average version length: 82.97, total versions: 4542, 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: 197, data page slots: 319880 
    Data pages: 319880, average fill: 81% 
    Primary pages: 319880, secondary pages: 0, swept pages: 14256 
    Empty pages: 59, full pages: 318575 
    Fill distribution: 
     0 - 19% = 89 
    20 - 39% = 64 
    40 - 59% = 184 
    60 - 79% = 28405 
    80 - 99% = 291138 
 
    Index XQS_1000_1200_DOC_ID (1) 
    Root page: 1426716, depth: 3, leaf buckets: 19651, nodes: 21211868 
    Average node length: 5.72, total dup: 20729608, max dup: 133 
    Average key length: 2.16, compression ratio: 4.16 
    Average prefix length: 8.86, average data length: 0.14 
    Clustering factor: 3291578, ratio: 0.16 
    Fill distribution: 
         0 - 19% = 7 
        20 - 39% = 2 
        40 - 59% = 8575 
        60 - 79% = 526 
        80 - 99% = 10541 
 
    Index XQS_1000_1200_RCV_ID (3) 
    Root page: 1456980, depth: 3, leaf buckets: 17289, nodes: 21211868 
    Average node length: 6.31, total dup: 18640901, max dup: 49 
    Average key length: 2.75, compression ratio: 3.27 
    Average prefix length: 8.37, average data length: 0.63 
    Clustering factor: 917990, ratio: 0.04 
    Fill distribution: 
         0 - 19% = 3 
        20 - 39% = 4 
        40 - 59% = 897 
        60 - 79% = 287 
        80 - 99% = 16098 
 
    Index XQS_1000_1200_SND_ID (2) 
    Root page: 1441073, depth: 3, leaf buckets: 21412, nodes: 21211868 
    Average node length: 6.35, total dup: 18559374, max dup: 29 
    Average key length: 2.79, compression ratio: 3.23 
    Average prefix length: 8.34, average data length: 0.66 
    Clustering factor: 3586712, ratio: 0.17 
    Fill distribution: 
         0 - 19% = 8 
        20 - 39% = 2 
        40 - 59% = 8741 
        60 - 79% = 653 
        80 - 99% = 12008 
 
    Index XQS_1000_1200_WORKER_ID (0) 
    Root page: 1413348, depth: 3, leaf buckets: 16267, nodes: 21211868 
    Average node length: 5.56, total dup: 21211768, max dup: 231701 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.42, average data length: 0.00 
    Clustering factor: 946795, ratio: 0.04 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 14 
        40 - 59% = 3122 
        60 - 79% = 402 
        80 - 99% = 12728 
 
XQS_1000_3300 (184) 
    Primary pointer page: 565, Index root page: 566 
    Total formats: 1, used formats: 1 
    Average record length: 79.50, total records: 9935563 
    Average version length: 82.67, total versions: 353134, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.59 
    Pointer pages: 106, data page slots: 172728 
    Data pages: 172728, average fill: 71% 
    Primary pages: 172728, secondary pages: 0, swept pages: 89817 
    Empty pages: 363, full pages: 100656 
    Fill distribution: 
     0 - 19% = 1158 
    20 - 39% = 5448 
    40 - 59% = 24992 
    60 - 79% = 80149 
    80 - 99% = 60981 
 
    Index XQS_1000_3300_DOC_ID (1) 
    Root page: 1367502, depth: 3, leaf buckets: 11448, nodes: 9935563 
    Average node length: 5.38, total dup: 9622902, max dup: 253 
    Average key length: 2.23, compression ratio: 4.04 
    Average prefix length: 8.80, average data length: 0.20 
    Clustering factor: 2183325, ratio: 0.22 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 84 
        40 - 59% = 7474 
        60 - 79% = 3772 
        80 - 99% = 117 
 
    Index XQS_1000_3300_RCV_ID (3) 
    Root page: 1379261, depth: 3, leaf buckets: 13800, nodes: 9935563 
    Average node length: 6.26, total dup: 8234424, max dup: 14 
    Average key length: 3.10, compression ratio: 2.90 
    Average prefix length: 8.07, average data length: 0.93 
    Clustering factor: 1505853, ratio: 0.15 
    Fill distribution: 
         0 - 19% = 142 
        20 - 39% = 4023 
        40 - 59% = 4349 
        60 - 79% = 2562 
        80 - 99% = 2724 
 
    Index XQS_1000_3300_SND_ID (2) 
    Root page: 1373059, depth: 3, leaf buckets: 12791, nodes: 9935563 
    Average node length: 6.00, total dup: 8625077, max dup: 44 
    Average key length: 2.85, compression ratio: 3.16 
    Average prefix length: 8.29, average data length: 0.71 
    Clustering factor: 2379234, ratio: 0.24 
    Fill distribution: 
         0 - 19% = 3 
        20 - 39% = 109 
        40 - 59% = 8446 
        60 - 79% = 4082 
        80 - 99% = 151 
 
    Index XQS_1000_3300_WORKER_ID (0) 
    Root page: 1362767, depth: 3, leaf buckets: 10295, nodes: 9935563 
    Average node length: 5.16, total dup: 9935463, max dup: 170463 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.41, average data length: 0.00 
    Clustering factor: 1554259, ratio: 0.16 
    Fill distribution: 
         0 - 19% = 50 
        20 - 39% = 1205 
        40 - 59% = 4973 
        60 - 79% = 1792 
        80 - 99% = 2275 
 
XQS_1200_2000 (183) 
    Primary pointer page: 563, Index root page: 564 
    Total formats: 1, used formats: 1 
    Average record length: 80.50, total records: 11481812 
    Average version length: 82.57, total versions: 251765, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.57 
    Pointer pages: 120, data page slots: 194520 
    Data pages: 193088, average fill: 73% 
    Primary pages: 193088, secondary pages: 0, swept pages: 77449 
    Empty pages: 2433, full pages: 143088 
    Fill distribution: 
     0 - 19% = 4352 
    20 - 39% = 7421 
    40 - 59% = 18540 
    60 - 79% = 47524 
    80 - 99% = 115251 
 
    Index XQS_1200_2000_DOC_ID (1) 
    Root page: 1392101, depth: 3, leaf buckets: 13159, nodes: 11481812 
    Average node length: 5.32, total dup: 11371128, max dup: 621 
    Average key length: 2.08, compression ratio: 4.33 
    Average prefix length: 8.93, average data length: 0.07 
    Clustering factor: 2408037, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 75 
        40 - 59% = 8670 
        60 - 79% = 4223 
        80 - 99% = 189 
 
    Index XQS_1200_2000_RCV_ID (3) 
    Root page: 1406110, depth: 3, leaf buckets: 10641, nodes: 11481812 
    Average node length: 5.52, total dup: 10979837, max dup: 49 
    Average key length: 2.28, compression ratio: 3.95 
    Average prefix length: 8.77, average data length: 0.23 
    Clustering factor: 743307, ratio: 0.06 
    Fill distribution: 
         0 - 19% = 171 
        20 - 39% = 858 
        40 - 59% = 2616 
        60 - 79% = 1832 
        80 - 99% = 5164 
 
    Index XQS_1200_2000_SND_ID (2) 
    Root page: 1398638, depth: 3, leaf buckets: 15060, nodes: 11481812 
    Average node length: 6.05, total dup: 10019235, max dup: 68 
    Average key length: 2.80, compression ratio: 3.21 
    Average prefix length: 8.32, average data length: 0.68 
    Clustering factor: 2424531, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 5 
        20 - 39% = 84 
        40 - 59% = 10276 
        60 - 79% = 4474 
        80 - 99% = 221 
 
    Index XQS_1200_2000_WORKER_ID (0) 
    Root page: 1386211, depth: 3, leaf buckets: 11047, nodes: 11481812 
    Average node length: 5.24, total dup: 11481712, max dup: 200235 
    Average key length: 2.00, compression ratio: 1.20 
    Average prefix length: 2.41, average data length: 0.00 
    Clustering factor: 731765, ratio: 0.06 
    Fill distribution: 
         0 - 19% = 85 
        20 - 39% = 927 
        40 - 59% = 4885 
        60 - 79% = 1573 
        80 - 99% = 3577 
 
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: 80.52, total records: 9969563 
    Average version length: 82.95, total versions: 268243, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.56 
    Pointer pages: 107, data page slots: 173536 
    Data pages: 173480, average fill: 71% 
    Primary pages: 173480, secondary pages: 0, swept pages: 103943 
    Empty pages: 451, full pages: 97039 
    Fill distribution: 
     0 - 19% = 1179 
    20 - 39% = 4687 
    40 - 59% = 23791 
    60 - 79% = 88143 
    80 - 99% = 55680 
 
    Index XQS_2100_3300_DOC_ID (1) 
    Root page: 1344686, depth: 3, leaf buckets: 12198, nodes: 9969563 
    Average node length: 5.20, total dup: 9939945, max dup: 1564 
    Average key length: 2.03, compression ratio: 4.43 
    Average prefix length: 8.97, average data length: 0.03 
    Clustering factor: 1984226, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 34 
        20 - 39% = 1641 
        40 - 59% = 8091 
        60 - 79% = 1864 
        80 - 99% = 568 
 
    Index XQS_2100_3300_RCV_ID (3) 
    Root page: 1355717, depth: 3, leaf buckets: 13892, nodes: 9969563 
    Average node length: 6.27, total dup: 8261153, max dup: 14 
    Average key length: 3.10, compression ratio: 2.90 
    Average prefix length: 8.07, average data length: 0.93 
    Clustering factor: 1477543, ratio: 0.15 
    Fill distribution: 
         0 - 19% = 166 
        20 - 39% = 4177 
        40 - 59% = 4228 
        60 - 79% = 2521 
        80 - 99% = 2800 
 
    Index XQS_2100_3300_SND_ID (2) 
    Root page: 1350049, depth: 3, leaf buckets: 12823, nodes: 9969563 
    Average node length: 5.46, total dup: 9519893, max dup: 93 
    Average key length: 2.29, compression ratio: 3.93 
    Average prefix length: 8.76, average data length: 0.24 
    Clustering factor: 2119763, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 22 
        20 - 39% = 1525 
        40 - 59% = 9081 
        60 - 79% = 1605 
        80 - 99% = 590 
 
    Index XQS_2100_3300_WORKER_ID (0) 
    Root page: 985805, depth: 3, leaf buckets: 10382, nodes: 9969563 
    Average node length: 5.17, total dup: 9969463, max dup: 170860 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.41, average data length: 0.00 
    Clustering factor: 1575760, ratio: 0.16 
    Fill distribution: 
         0 - 19% = 30 
        20 - 39% = 1229 
        40 - 59% = 5028 
        60 - 79% = 1813 
        80 - 99% = 2282 
 
XQS_3300_3400 (187) 
    Primary pointer page: 571, Index root page: 572 
    Total formats: 1, used formats: 1 
    Average record length: 67.90, total records: 587952 
    Average version length: 68.75, total versions: 2536, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.86 
    Pointer pages: 5, data page slots: 8144 
    Data pages: 8144, average fill: 75% 
    Primary pages: 8144, secondary pages: 0, swept pages: 4344 
    Empty pages: 7, full pages: 6868 
    Fill distribution: 
     0 - 19% = 7 
    20 - 39% = 8 
    40 - 59% = 159 
    60 - 79% = 7926 
    80 - 99% = 44 
 
    Index XQS_3300_3400_DOC_ID (1) 
    Root page: 43923, depth: 3, leaf buckets: 755, nodes: 587952 
    Average node length: 5.95, total dup: 500704, max dup: 83 
    Average key length: 3.09, compression ratio: 2.91 
    Average prefix length: 8.06, average data length: 0.94 
    Clustering factor: 101832, ratio: 0.17 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 18 
        40 - 59% = 550 
        60 - 79% = 108 
        80 - 99% = 79 
 
    Index XQS_3300_3400_SND_ID (2) 
    Root page: 33503, depth: 3, leaf buckets: 778, nodes: 587952 
    Average node length: 6.15, total dup: 482361, max dup: 27 
    Average key length: 3.29, compression ratio: 2.74 
    Average prefix length: 7.89, average data length: 1.11 
    Clustering factor: 101881, ratio: 0.17 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 16 
        40 - 59% = 571 
        60 - 79% = 107 
        80 - 99% = 84 
 
    Index XQS_3300_3400_WORKER_ID (0) 
    Root page: 375548, depth: 2, leaf buckets: 563, nodes: 587952 
    Average node length: 4.86, total dup: 587852, max dup: 9713 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.41, average data length: 0.00 
    Clustering factor: 90486, ratio: 0.15 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 24 
        40 - 59% = 324 
        60 - 79% = 62 
        80 - 99% = 153 
 
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 Sun Apr 14 22:13:17 2024

Record versions statistics, table

TABLE_NAME TOTAL_RECS TOTAL_VERS MAX_VERSIONS VERS_TO_RECS_PRC MAXV_TO_VERS_PRC
DOC_DATA 7791262 28431 1 0.0000 0.0000
DOC_LIST 2275570 30737 3 0.0000 0.0000
FB_ERRORS 2182 757 1 0.0000 0.0000
INVNT_SALDO 400 247176 645 61700.0000 0.0000
INVNT_TURNOVER_LOG 89911 82333 1 0.0000 0.0000
MONEY_SALDO 49 16248 1034 33100.0000 0.0000
MONEY_TURNOVER_LOG 1473 1366 1 0.0000 0.0000
PDISTR 737515 44922 4 0.0000 0.0000
PERF_SPLIT_0 169112 2326 1 0.0000 0.0000
PERF_SPLIT_1 166880 355 1 0.0000 0.0000
PERF_SPLIT_2 167961 3100 1 0.0000 0.0000
PERF_SPLIT_3 203715 11409 1 0.0000 0.0000
PERF_SPLIT_4 159993 2687 1 0.0000 0.0000
PERF_SPLIT_5 165958 2387 1 0.0000 0.0000
PERF_SPLIT_6 169663 1462 1 0.0000 0.0000
PERF_SPLIT_7 166338 4632 1 0.0000 0.0000
PERF_SPLIT_8 178049 2543 1 0.0000 0.0000
PERF_SPLIT_9 184720 7288 1 0.0000 0.0000
PSTORNED 2142760 12470 1 0.0000 0.0000
SEMAPHORES 5 1 1 0.0000 100.0000
XQD_1000_1200 107970 32746 1 0.0000 0.0000
XQD_1000_3300 6596712 216720 1 0.0000 0.0000
XQD_1200_2000 11731793 174106 1 0.0000 0.0000
XQD_2000_3300 1200024 323076 1 0.0000 0.0000
XQD_2100_3300 913753 261974 1 0.0000 0.0000
XQD_3300_3400 9306743 190839 1 0.0000 0.0000
XQS_1000_1200 21211868 4542 1 0.0000 0.0000
XQS_1000_3300 9935563 353134 1 0.0000 0.0000
XQS_1200_2000 11481812 251765 1 0.0000 0.0000
XQS_2100_3300 9969563 268243 1 0.0000 0.0000
XQS_3300_3400 587952 2536 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 ---
:1212: 
:1213: mscs-test-161.budzdorov.ru    Sun Apr 14 22:10:14 2024
:1214:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:1215: 
:1216: 
:1217: mscs-test-161.budzdorov.ru    Sun Apr 14 22:10:28 2024
:1218:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:1219: 
:1220: 
:1221: mscs-test-161.budzdorov.ru    Sun Apr 14 22:10:28 2024
:1222:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:1223: 
:1224: 
:1225: mscs-test-161.budzdorov.ru    Sun Apr 14 22:10:29 2024
:1226:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:1227: 
--- end of diff output ---

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

14.04.24 22:13:29. 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-14 22:13:32 No severe PSQL-related problems occured
14.04.24 22:13:33. End of report.