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

Hardware and OS info

Command: hostnamectl
Static hostname mscs-test-161.budzdorov.ru
Icon name computer-server
Chassis server
Machine ID aeee285d2cca40bf84c40a748f599e77
Boot ID 2a7b53d1c5ed44b9bb2712fffac5d8c6
Operating System CentOS Linux 7 (Core)
CPE OS Name cpe:/o:centos:centos:7
Kernel Linux 3.10.0-1127.10.1.el7.x86_64
Architecture x86-64
Command: who -b
bootup_info system boot 2021-11-11 18:28
Command: dmidecode -t system|grep -i -e 'manufacturer\|product\|hypervisor'
Manufacturer HP
Product Name ProLiant DL380 Gen9
Command: dmesg | grep DMI
[ 0.000000] DMI HP ProLiant DL380 Gen9/ProLiant DL380 Gen9, BIOS P89 05/21/2018
Command: lscpu | grep -i -v flags
Architecture x86_64
CPU op-mode(s) 32-bit, 64-bit
Byte Order Little Endian
CPU(s) 24
On-line CPU(s) list 0-23
Thread(s) per core 2
Core(s) per socket 6
Socket(s) 2
NUMA node(s) 2
Vendor ID GenuineIntel
CPU family 6
Model 63
Model name Intel(R) Xeon(R) CPU E5-2620 v3 @ 2.40GHz
Stepping 2
CPU MHz 1200.000
CPU max MHz 2400.0000
CPU min MHz 1200.0000
BogoMIPS 4794.33
Virtualization VT-x
L1d cache 32K
L1i cache 32K
L2 cache 256K
L3 cache 15360K
NUMA node0 CPU(s) 0-5,12-17
NUMA node1 CPU(s) 6-11,18-23
Command: cat /proc/meminfo | grep -i -e 'memtotal\|memfree\|memavail\|buffers\|cached\|swapcached'
MemTotal 32643792 kB
MemFree 15445608 kB
MemAvailable 30007500 kB
Buffers 20 kB
Cached 16231196 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 4.0.5
DB_NAME                         /home/bases/oltp40-etalone.fdb
FORCED_WRITES                   ON
SWEEP_INT                       0
PAGE_BUFFERS                    1000000
PAGE_SIZE                       8192

Test configuration settings 

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

Test finish info 


FINISH_STATE                    NORMAL: TEST_TIME EXPIRED AT 2024-04-15 04:07:48
DTS_END                         2024-04-15 04:07:48.1340
FB_GDSCODE                      -1
FB_MNEMONA                      
STACK                           SP_ADD_INVOICE_TO_STOCK(190:30) ==> SP_CUSTOMER_RESERVE(47:5) ==> SP_CHECK_TO_STOP_WORK(32:12) ==> SP_HALT_ON_ERROR(68:17)
IP                              ::1/57574
TRN_ID                          170784
ATT_ID                          537
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: 8918.65 27812 891865
customer order: creation 167.99 420 16799
customer order: refuse 14.70 385 1470
order to supplier: creation 45.10 1296 4510
order to supplier: removal 3.51 103092 351
invoice (draft): creation 46.31 2881 4631
invoice (draft): removal 49.33 779 4933
invoice accept: apply 40.55 21773 4055
invoice accept: cancel 44.25 857 4425
customer reserve: creation 3885.99 211 388599
customer reserve: removal 4333.60 66 433360
realization accept: apply 81.45 207 8145
realization accept: cancel 79.70 141 7970
payment from customer: creation 58.83 124 5883
payment from customer: removal 5.58 74 558
payment to supplier: creation 48.11 151 4811
payment to supplier: removal 3.19 73 319
service: total inventory turnovers 3.91 3494 391
service: total monetary turnovers 5.52 581 552
service: aggregate perf. data 1.00 11871 100
service: refresh index statistics 0.03 407773 3

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:03, from 15-04-2024 04:09:06 to 15-04-2024 04:09:09.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 1650
TEST_TIME 2 1618
TEST_TIME 3 3115
TEST_TIME 4 4110
TEST_TIME 5 6035
TEST_TIME 6 5967
TEST_TIME 7 6282
TEST_TIME 8 6224
TEST_TIME 9 5978
TEST_TIME 10 6039
TEST_TIME 11 6090
TEST_TIME 12 6159
TEST_TIME 13 6312
TEST_TIME 14 6305
TEST_TIME 15 6845
TEST_TIME 16 6905
TEST_TIME 17 7090
TEST_TIME 18 7243
TEST_TIME 19 7326
TEST_TIME 20 7518
TEST_TIME 21 7850
TEST_TIME 22 8249
TEST_TIME 23 9099
TEST_TIME 24 9580
TEST_TIME 25 9759
TEST_TIME 26 9525
TEST_TIME 27 9353
TEST_TIME 28 9072
TEST_TIME 29 9011
TEST_TIME 30 8952
TEST_TIME 31 8979
TEST_TIME 32 8966
TEST_TIME 33 9011
TEST_TIME 34 8952
TEST_TIME 35 8917
TEST_TIME 36 8929
TEST_TIME 37 8856
TEST_TIME 38 8987
TEST_TIME 39 8898
TEST_TIME 40 9153
TEST_TIME 41 9395
TEST_TIME 42 9364
TEST_TIME 43 9536
TEST_TIME 44 9599
TEST_TIME 45 9553
TEST_TIME 46 9747
TEST_TIME 47 9666
TEST_TIME 48 9516
TEST_TIME 49 9353
TEST_TIME 50 9268
TEST_TIME 51 9389
TEST_TIME 52 9403
TEST_TIME 53 9385
TEST_TIME 54 9340
TEST_TIME 55 9257
TEST_TIME 56 9200
TEST_TIME 57 9132
TEST_TIME 58 9071
TEST_TIME 59 9087
TEST_TIME 60 9041
TEST_TIME 61 9077
TEST_TIME 62 9146
TEST_TIME 63 9115
TEST_TIME 64 9325
TEST_TIME 65 9300
TEST_TIME 66 9264
TEST_TIME 67 9456
TEST_TIME 68 9558
TEST_TIME 69 9489
TEST_TIME 70 9406
TEST_TIME 71 9347
TEST_TIME 72 9293
TEST_TIME 73 9211
TEST_TIME 74 9148
TEST_TIME 75 9125
TEST_TIME 76 9075
TEST_TIME 77 9081
TEST_TIME 78 9044
TEST_TIME 79 9033
TEST_TIME 80 9048
TEST_TIME 81 9084
TEST_TIME 82 9146
TEST_TIME 83 9200
TEST_TIME 84 9215
TEST_TIME 85 9196
TEST_TIME 86 9211
TEST_TIME 87 9250
TEST_TIME 88 9244
TEST_TIME 89 9252
TEST_TIME 90 9170
TEST_TIME 91 9138
TEST_TIME 92 9096
TEST_TIME 93 9100
TEST_TIME 94 9068
TEST_TIME 95 9041
TEST_TIME 96 8996
TEST_TIME 97 8993
TEST_TIME 98 8966
TEST_TIME 99 8959
TEST_TIME 100 8920

Performance per minute, chart


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

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 1249313 1249313 0 0.00 0 51198 7 0 0
doc_list_biud 1249313 1249313 0 0.00 0 46984 29 0 0
sp_add_invoice_to_stock 4156 4055 101 2.43 43 211985 21774 0 101
sp_cancel_adding_invoice 4425 4425 0 0.00 3 62995 857 0 0
sp_cancel_client_order 1470 1470 0 0.00 4 13304 385 0 0
sp_cancel_customer_reserve 433360 433360 0 0.00 0 44150 67 0 0
sp_cancel_pay_from_customer 558 558 0 0.00 2 6493 75 0 0
sp_cancel_pay_to_supplier 319 319 0 0.00 3 6161 73 0 0
sp_cancel_supplier_invoice 4941 4933 8 0.16 1 30526 779 0 8
sp_cancel_supplier_order 351 351 0 0.00 10 858071 103093 0 0
sp_cancel_write_off 7970 7970 0 0.00 1 17141 141 0 0
sp_client_order 16799 16799 0 0.00 3 35514 420 0 0
sp_customer_reserve 388599 388599 0 0.00 0 69867 211 0 0
sp_fill_shopping_cart 25935 25935 0 0.00 1 11101 33 0 0
sp_fill_shopping_cart_clo_res 388597 388597 0 0.00 0 15998 20 0 0
sp_get_clo_for_invoice 4053 4053 0 0.00 0 31676 335 0 0
sp_kill_cost_storno 13272 13272 0 0.00 0 51192 79 0 0
sp_kill_qstorno_ret_qs2qd 879974 879974 0 0.00 0 46981 36 0 0
sp_kill_qty_storno 464707 464707 0 0.00 0 46984 76 0 0
sp_lock_selected_doc 16931 16931 0 0.00 0 6512 6 0 0
sp_make_cost_storno 22892 22892 0 0.00 0 46588 71 0 0
sp_multiply_rows_for_pdistr 22892 22892 0 0.00 0 39146 36 0 0
sp_multiply_rows_for_qdistr 16799 16799 0 0.00 0 32403 241 0 0
sp_pay_from_customer 5883 5883 0 0.00 4 17377 124 0 0
sp_pay_to_supplier 4811 4811 0 0.00 4 16861 151 0 0
sp_payment_common 10694 10694 0 0.00 1 16965 34 0 0
sp_qd_handle_on_cancel_clo 1470 1470 0 0.00 0 13296 354 0 0
sp_qd_handle_on_invoice_upd_sts 8478 8478 0 0.00 0 27611 323 0 0
sp_qd_handle_on_reserve_upd_sts 8145 8145 0 0.00 0 17345 59 0 0
sp_reserve_write_off 8145 8145 0 0.00 6 17677 207 0 0
sp_supplier_invoice 4631 4631 0 0.00 6 89200 2882 0 0
sp_supplier_order 4510 4510 0 0.00 4 70194 1297 0 0
srv_aggregate_perf_data 100 100 0 0.00 1567 83529 11872 0 0
srv_fill_mon_cache_memory 53 53 0 0.00 1979 195074 43508 0 0
srv_find_qd_qs_mism 851227 851227 0 0.00 0 12762 6 0 0
srv_make_invnt_saldo 391 391 0 0.00 38 104505 3494 0 0
srv_make_money_saldo 552 552 0 0.00 1 17757 582 0 0
srv_recalc_idx_stat 3 3 0 0.00 354203 501766 407773 0 0
t$perf-abend:sp_add_invoice_to_stock 101 101 0 0.00 0 0 0 0 0
t$perf-abend:sp_cancel_supplier_invoice 8 8 0 0.00 0 0 0 0 0
t$perf-norm:sp_add_invoice_to_stock 4055 4055 0 0.00 0 9613 164 0 0
t$perf-norm:sp_cancel_adding_invoice 324 324 0 0.00 0 1783 79 0 0
t$perf-norm:sp_cancel_client_order 1470 1470 0 0.00 0 2244 13 0 0
t$perf-norm:sp_cancel_customer_reserve 563 563 0 0.00 0 1989 10 0 0
t$perf-norm:sp_cancel_pay_from_customer 558 558 0 0.00 0 7863 20 0 0
t$perf-norm:sp_cancel_pay_to_supplier 319 319 0 0.00 0 5313 18 0 0
t$perf-norm:sp_cancel_supplier_invoice 332 332 0 0.00 0 739 11 0 0
t$perf-norm:sp_cancel_supplier_order 351 351 0 0.00 0 49239 1919 0 0
t$perf-norm:sp_cancel_write_off 816 816 0 0.00 0 3819 9 0 0
t$perf-norm:sp_client_order 16799 16799 0 0.00 0 4412 13 0 0
t$perf-norm:sp_customer_reserve 819 819 0 0.00 0 680 4 0 0
t$perf-norm:sp_pay_from_customer 5883 5883 0 0.00 0 5938 7 0 0
t$perf-norm:sp_pay_to_supplier 4811 4811 0 0.00 0 6451 11 0 0
t$perf-norm:sp_reserve_write_off 8145 8145 0 0.00 0 7681 7 0 0
t$perf-norm:sp_supplier_invoice 4631 4631 0 0.00 0 3203 14 0 0
t$perf-norm:sp_supplier_order 4510 4510 0 0.00 0 14682 17 0 0
t$perf-norm:srv_aggregate_perf_data 100 100 0 0.00 0 336 4 0 0
t$perf-norm:srv_fill_mon_cache_memory 53 53 0 0.00 0 32 1 0 0
t$perf-norm:srv_make_invnt_saldo 391 391 0 0.00 0 7090 30 0 0
t$perf-norm:srv_make_money_saldo 552 552 0 0.00 0 577 6 0 0
t$perf-norm:srv_recalc_idx_stat 3 3 0 0.00 1 6 3 0 0
v_add_invoice_to_stock 8308 8106 202 2.43 0 5993 16 0 202
v_all_customers 31326 31326 0 0.00 0 58 1 0 0
v_all_suppliers 25936 25936 0 0.00 0 24 1 0 0
v_all_wares 33598 33598 0 0.00 0 60 1 0 0
v_cancel_adding_invoice 648 648 0 0.00 0 5330 24 0 0
v_cancel_client_order 2940 2940 0 0.00 0 2438 5 0 0
v_cancel_customer_prepayment 1116 1116 0 0.00 0 452 3 0 0
v_cancel_customer_reserve 1126 1126 0 0.00 0 1450 5 0 0
v_cancel_payment_to_supplier 638 638 0 0.00 0 72 2 0 0
v_cancel_supplier_invoice 680 664 16 2.35 0 576 15 0 16
v_cancel_supplier_order 702 702 0 0.00 0 2128 9 0 0
v_cancel_write_off 1632 1632 0 0.00 0 4921 18 0 0
v_max_id_clo_ord 4510 4510 0 0.00 0 621 1 0 0
v_max_id_clo_res 819 819 0 0.00 0 4434 24 0 0
v_max_id_ord_sup 4626 4626 0 0.00 0 6170 4 0 0
v_max_non_paid_invoice 979 979 0 0.00 0 33 1 0 0
v_max_non_paid_realizn 2763 2763 0 0.00 0 16956 10 0 0
v_min_id_clo_ord 4510 4510 0 0.00 0 2189 6 0 0
v_min_id_clo_res 819 819 0 0.00 0 754 3 0 0
v_min_id_ord_sup 4626 4626 0 0.00 0 4351 5 0 0
v_min_non_paid_invoice 4811 4811 0 0.00 0 16127 27 0 0
v_min_non_paid_realizn 5883 5883 0 0.00 0 15079 25 0 0
v_our_firm 8512 8512 0 0.00 0 23 1 0 0
v_reserve_write_off 16290 16290 0 0.00 0 6761 6 0 0
x_lock_depdocs_on_canc_invoice 9026 9026 0 0.00 0 11756 111 0 0
x_lock_depdocs_on_canc_sup_ord 351 351 0 0.00 0 14351 417 0 0
x_make_qstorno_1000_1200 4510 4510 0 0.00 1 70186 1225 0 0
x_make_qstorno_1200_2000 4631 4631 0 0.00 2 81543 2765 0 0
x_make_qstorno_2100_3300 388599 388599 0 0.00 0 69866 189 0 0

Completed "Performance in DETAILS". Done for 00:00:05, from 15-04-2024 04:09:14 to 15-04-2024 04:09:19.

Memory consumption, metadata cache, attachments activity 

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


Page cache type: shared, buffers: 1000000 for all connections, with total size: 8192000000
measurement_dts measurement duration ms page cache memo used memo used, total memo allocated, total metadata cache metadata cache percent of total total attachments cnt active attachments cnt running statements cnt stalled statements cnt memo used by attachments memo used by transactions memo used by statements
02:07:52 2 8192000000 8796662832 8807108608 3180608 0.038 1 1 2 0 3278224 61840 35776
02:08:53 38785 8192000000 9717930256 10017280000 791579552 8.811 100 91 182 0 820838768 7385504 21873712
02:10:40 22627 8192000000 9755476400 10062958592 830061840 9.200 100 91 182 0 863980384 12559568 21358976
02:12:06 12738 8192000000 9787599008 10106630144 856498816 9.465 100 81 162 0 895482736 20659888 18324032
02:13:29 6792 8192000000 9853005520 10187124736 910113456 9.998 100 80 158 0 961118080 34410896 16593728
02:14:41 9855 8192000000 9899678016 10248564736 944169216 10.334 100 78 154 0 1024736976 64691120 15876640
02:15:55 3352 8192000000 9947468496 10299662336 979671584 10.681 100 85 170 0 1064002224 67833008 16497632
02:17:02 2410 8192000000 9980553744 10342363136 1002658656 10.904 100 80 159 0 1097930416 80423152 14848608
02:18:07 7970 8192000000 9993739952 10365849600 1026338640 11.133 100 74 144 1 1109486784 69452432 13695712
02:19:16 1662 8192000000 10027958192 10404810752 1052562528 11.385 100 87 175 0 1137032048 67494704 16974816
02:20:19 6554 8192000000 9984772800 10370686976 1056257296 11.421 100 66 133 0 1103608528 34137888 13213344
02:21:27 5398 8192000000 9998881552 10393649152 1065748560 11.511 100 42 84 1 1108806976 34677408 8381008
02:22:34 6183 8192000000 9974978768 10384338944 1072636352 11.577 100 25 50 0 1104104192 25404784 6063056
02:23:43 3951 8192000000 9998778720 10396807168 1080498624 11.652 100 45 87 1 1114250688 24661712 9090352
02:24:48 5375 8192000000 9990510000 10390880256 1081199328 11.659 100 37 71 0 1096488864 7700224 7589312
02:25:54 6940 8192000000 10012626192 10417717248 1089142080 11.735 100 42 81 0 1130505968 33371888 7992000
02:27:02 4316 8192000000 10010230496 10414948352 1098435408 11.823 100 50 101 0 1135237488 26346432 10455648
02:28:12 24046 8192000000 10037040800 10437173248 1099020128 11.828 100 47 91 1 1127680464 17893040 10767296
02:29:55 19465 8192000000 10076200032 10475479040 1102963312 11.866 100 62 124 0 1177154736 61459376 12732048
02:32:03 17200 8192000000 10071843392 10476834816 1079652992 11.644 98 42 84 0 1184375920 96642496 8080432
02:33:26 14036 8192000000 10055726096 10448236544 1056894448 11.427 98 59 116 1 1137041920 68202944 11944528
02:34:47 36063 8192000000 10066023584 10468470784 1082841168 11.675 99 35 68 0 1162467200 72259056 7366976
02:36:29 28429 8192000000 10128538768 10534776832 1104690880 11.882 100 48 96 0 1218549824 103541040 10317904
02:38:43 15857 8192000000 10125909440 10532200448 1070814304 11.560 97 41 82 0 1216830160 136424592 9591264
02:40:02 1975 8192000000 10192997744 10576105472 1105066320 11.886 100 80 155 1 1289253872 167471328 16716224
02:41:09 7051 8192000000 10214592800 10607960064 1109612208 11.929 100 63 125 0 1323937184 200817760 13507216
02:42:19 3281 8192000000 10238300608 10631942144 1106620464 11.900 99 71 143 0 1343530624 220041056 16869104
02:43:27 8225 8192000000 10257464944 10669039616 1109486048 11.928 99 56 111 2 1360000976 238008000 12506928
02:44:46 8543 8192000000 10314046688 10736320512 1123090624 12.056 100 67 134 0 1415881520 278707840 14083056
02:45:59 3800 8192000000 10332226896 10741813248 1139423008 12.210 100 57 110 0 1433076752 281481792 12171952
02:47:07 23679 8192000000 10349960256 10790117376 1135077456 12.169 100 40 80 0 1454728944 309892080 9759408
02:48:40 22086 8192000000 10303084352 10751807488 1129982000 12.121 100 20 40 0 1402028912 266175616 5871296
02:50:21 26314 8192000000 10170545952 10637221888 1128698416 12.109 100 25 50 0 1303296208 168979744 5618048
02:51:53 85412 8192000000 10039118368 10472038400 1074867136 11.599 96 13 26 0 1110673920 33407968 2398816
02:54:22 195074 8192000000 10120603216 10583715840 1133332752 12.153 100 31 62 1 1222964400 82941152 6690496
02:58:40 30355 8192000000 10123019248 10554912768 1135277856 12.171 100 34 67 1 1222966704 79740384 7948464
03:00:26 50678 8192000000 10133499488 10590318592 1147103248 12.282 100 18 36 0 1242353312 91069088 4180976
03:02:28 9034 8192000000 10138218000 10627506176 1148900416 12.299 100 13 26 0 1246357920 94372576 3084928
03:03:51 49873 8192000000 10174688864 10639618048 1145850448 12.271 100 24 48 0 1256120544 105204720 5065376
03:05:42 58168 8192000000 10174528176 10616299520 1152811952 12.336 99 17 34 0 1276592160 119940576 3839632
03:07:48 40927 8192000000 10080209648 10596814848 1143312400 12.247 100 13 26 0 1262119856 115963760 2843696
03:09:32 8561 8192000000 10109520240 10546540544 1147426976 12.285 100 53 106 0 1213409280 56335520 9646784
03:10:48 47017 8192000000 10073054544 10535030784 1125475040 12.079 98 13 26 0 1160099856 32182864 2441952
03:12:36 38323 8192000000 10105518848 10602123264 1153804768 12.345 100 10 20 0 1219756864 63788608 2163488
03:14:16 31053 8192000000 10137071488 10564923392 1146116944 12.273 99 36 73 1 1209229616 55750832 7361840
03:15:51 96385 8192000000 10138122048 10565242880 1088171744 11.725 95 33 66 0 1199011584 103626624 7213216
03:18:38 36650 8192000000 10074202704 10501824512 1082316656 11.670 96 30 57 0 1157534912 68633488 6584768
03:20:16 56186 8192000000 10030718128 10463207424 1089088096 11.734 98 23 46 0 1123718448 30018864 4611488
03:23:25 64867 8192000000 10024403280 10455597056 1085580976 11.701 99 9 16 1 1116225744 29132480 1512288
03:25:32 44539 8192000000 10033409328 10485350400 1100314672 11.841 99 14 28 0 1140438752 37317616 2806464
03:27:25 23052 8192000000 10059635584 10483474432 1074434496 11.594 97 31 62 0 1136803024 56425664 5942864
03:28:50 27909 8192000000 10049200480 10484588544 1036576432 11.232 95 25 50 0 1118291664 76504176 5211056
03:30:35 57547 8192000000 10090552688 10556964864 1046312880 11.325 96 23 46 0 1158450448 107458064 4679504
03:32:51 9731 8192000000 10044961920 10454151168 1082465536 11.671 100 55 109 0 1132064480 38889120 10709824
03:34:03 47464 8192000000 10159388160 10640986112 1089039712 11.734 100 35 70 0 1262598688 166497008 7061968
03:35:56 152263 8192000000 10057393680 10501033984 1080638528 11.654 98 32 64 1 1129709712 43040016 6031168
03:39:40 61877 8192000000 10029972256 10491797504 1109396800 11.927 100 4 8 0 1146278080 36282272 599008
03:41:45 94469 8192000000 10032200352 10500993024 1110073808 11.933 99 6 12 0 1151491088 40330416 1086864
03:44:21 46890 8192000000 10023240688 10469597184 1075075200 11.601 96 18 35 2 1117387184 38748224 3563760
03:46:19 45501 8192000000 10104392496 10550640640 1128250352 12.105 100 27 53 1 1227454992 93467728 5736912
03:48:10 76518 8192000000 10092130528 10647822336 1124032848 12.065 100 9 18 0 1198691824 72754336 1904640
03:50:32 45227 8192000000 10055728752 10492321792 1112262752 11.954 99 25 50 1 1154092384 36599424 5230208
03:52:19 24284 8192000000 10079029840 10520633344 1122657696 12.052 100 39 79 1 1171791520 41819008 7314816
03:53:44 79081 8192000000 10061957920 10517028864 1116473056 11.994 99 26 52 1 1160763584 39388544 4901984
03:56:03 32113 8192000000 10093600320 10543620096 1128311888 12.105 99 35 67 2 1188652880 54223680 6117312
03:57:37 105450 8192000000 10069926384 10524942336 1143466320 12.248 100 19 38 0 1178414912 30939824 4008768
04:00:30 59715 8192000000 10070510960 10527678464 1117164016 12.000 98 10 20 0 1163617696 44645504 1808176
04:03:52 22992 8192000000 10044878208 10489937920 1095934064 11.799 97 46 94 2 1134152720 28635376 9583280
04:05:19 50000 8192000000 10050531568 10520006656 1112626080 11.957 99 14 28 0 1137210912 22002368 2582464
04:07:13 40610 8192000000 9135819328 9398292480 267827840 3.165 24 9 18 0 314459488 44645344 1986304

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:13, from 15-04-2024 04:09:21 to 15-04-2024 04:09:34.

Exceptions occured during test was in run

FB_MNEMONA CNT UNIT FB_GDSCODE
except 101 v_add_invoice_to_stock 335544517
except 8 v_cancel_supplier_invoice 335544517

Completed "Exceptions occured during test was in run". Done for 00:00:02, from 15-04-2024 04:09:35 to 15-04-2024 04:09:37.

Content of mon$database and FB version 


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


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

Database statistics 

 
Database "/home/bases/oltp40-etalone.fdb" 
Gstat execution time Mon Apr 15 04:09:39 2024 
 
Database header page information: 
    Flags            0 
    Generation        89283 
    System Change Number    0 
    Page size        8192 
    ODS version        13.0 
    Oldest transaction    167641 
    Oldest active        171133 
    Oldest snapshot        171133 
    Next transaction    171134 
    Sequence number        0 
    Next attachment ID    686 
    Implementation        HW=AMD/Intel/x64 little-endian OS=Linux CC=gcc 
    Shadow count        0 
    Page buffers        0 
    Next header page    0 
    Database dialect    3 
    Creation date        Apr 30, 2020 7:30:08 
    Attributes        force write 
 
    Variable header data: 
    Database GUID:    {58978C10-B735-40F5-8B7D-F7A1956E782B} 
    Sweep interval:        0 
    *END* 
 
 
Database file sequence: 
File /home/bases/oltp40-etalone.fdb is the only file 
 
Analyzing database pages ... 
AGENTS (150) 
    Primary pointer page: 524, Index root page: 525 
    Total formats: 1, used formats: 1 
    Average record length: 33.60, total records: 50 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 344.00, compression ratio: 10.24 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 31% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 1 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index AGENTS_ID_DESC (2) 
    Root page: 1504333, depth: 1, leaf buckets: 1, nodes: 50 
    Average node length: 11.82, total dup: 0, max dup: 0 
    Average key length: 10.80, compression ratio: 0.83 
    Average prefix length: 1.18, average data length: 7.82 
    Clustering factor: 1, ratio: 0.02 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index AGENTS_IS_OUR_FIRM (4) 
    Root page: 1504335, depth: 1, leaf buckets: 1, nodes: 50 
    Average node length: 3.08, total dup: 48, max dup: 48 
    Average key length: 2.04, compression ratio: 0.50 
    Average prefix length: 0.96, average data length: 0.06 
    Clustering factor: 1, ratio: 0.02 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index AGENTS_IS_SUPPLIER (3) 
    Root page: 1504334, depth: 1, leaf buckets: 1, nodes: 50 
    Average node length: 3.08, total dup: 48, max dup: 44 
    Average key length: 2.04, compression ratio: 0.54 
    Average prefix length: 1.04, average data length: 0.06 
    Clustering factor: 1, ratio: 0.02 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index AGENTS_NAME_UNQ (1) 
    Root page: 1504332, depth: 1, leaf buckets: 1, nodes: 50 
    Average node length: 17.20, total dup: 0, max dup: 0 
    Average key length: 15.88, compression ratio: 0.92 
    Average prefix length: 1.42, average data length: 13.20 
    Clustering factor: 1, ratio: 0.02 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PK_AGENTS (0) 
    Root page: 1504331, depth: 1, leaf buckets: 1, nodes: 50 
    Average node length: 11.82, total dup: 0, max dup: 0 
    Average key length: 10.80, compression ratio: 0.83 
    Average prefix length: 1.18, average data length: 7.82 
    Clustering factor: 1, ratio: 0.02 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
BUSINESS_OPS (154) 
    Primary pointer page: 532, Index root page: 533 
    Total formats: 1, used formats: 1 
    Average record length: 108.20, total records: 20 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1235.00, compression ratio: 11.41 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 31% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 1 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index BO_UNIT_UNQ (1) 
    Root page: 1504264, depth: 1, leaf buckets: 1, nodes: 20 
    Average node length: 18.25, total dup: 0, max dup: 0 
    Average key length: 17.20, compression ratio: 1.24 
    Average prefix length: 7.05, average data length: 14.25 
    Clustering factor: 1, ratio: 0.05 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index BUSINESS_OPS_PREDICT_PRIOR (3) 
    Root page: 1504266, depth: 1, leaf buckets: 1, nodes: 20 
    Average node length: 5.40, total dup: 0, max dup: 0 
    Average key length: 4.35, compression ratio: 0.67 
    Average prefix length: 1.20, average data length: 1.70 
    Clustering factor: 1, ratio: 0.05 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index BUSINESS_OPS_RND_WGTH (2) 
    Root page: 1504265, depth: 1, leaf buckets: 1, nodes: 20 
    Average node length: 4.30, total dup: 6, max dup: 3 
    Average key length: 3.25, compression ratio: 0.72 
    Average prefix length: 1.35, average data length: 1.00 
    Clustering factor: 1, ratio: 0.05 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index RDB$1 (0) 
    Root page: 1504263, depth: 1, leaf buckets: 1, nodes: 20 
    Average node length: 5.20, total dup: 0, max dup: 0 
    Average key length: 4.15, compression ratio: 0.65 
    Average prefix length: 1.10, average data length: 1.60 
    Clustering factor: 1, ratio: 0.05 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
DOC_DATA (139) 
    Primary pointer page: 502, Index root page: 503 
    Total formats: 1, used formats: 1 
    Average record length: 47.75, total records: 7689212 
    Average version length: 48.15, total versions: 27334, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 64.00, compression ratio: 1.34 
    Pointer pages: 55, data page slots: 88704 
    Data pages: 88704, average fill: 69% 
    Primary pages: 88703, secondary pages: 1, swept pages: 45860 
    Empty pages: 4, full pages: 69724 
    Fill distribution: 
     0 - 19% = 15 
    20 - 39% = 89 
    40 - 59% = 3087 
    60 - 79% = 85496 
    80 - 99% = 17 
 
    Index DOC_DATA_DOC_WARE_UNQ (0) 
    Root page: 1510636, depth: 3, leaf buckets: 23227, nodes: 7689212 
    Average node length: 18.86, total dup: 0, max dup: 0 
    Average key length: 15.87, compression ratio: 1.70 
    Average prefix length: 14.12, average data length: 12.88 
    Clustering factor: 1659802, ratio: 0.22 
    Fill distribution: 
         0 - 19% = 343 
        20 - 39% = 2075 
        40 - 59% = 3937 
        60 - 79% = 2534 
        80 - 99% = 14338 
 
    Index DOC_DATA_ID_DESC (1) 
    Root page: 1528140, depth: 3, leaf buckets: 13466, nodes: 7689212 
    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: 1483880, ratio: 0.19 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 1707 
        40 - 59% = 1892 
        60 - 79% = 1192 
        80 - 99% = 8675 
 
    Index FK_DOC_DATA_DOC_LIST (2) 
    Root page: 1546735, depth: 3, leaf buckets: 8301, nodes: 7689212 
    Average node length: 6.60, total dup: 5767659, max dup: 49 
    Average key length: 3.62, compression ratio: 2.49 
    Average prefix length: 7.63, average data length: 1.37 
    Clustering factor: 1477065, ratio: 0.19 
    Fill distribution: 
         0 - 19% = 114 
        20 - 39% = 1066 
        40 - 59% = 1281 
        60 - 79% = 1026 
        80 - 99% = 4814 
 
DOC_LIST (138) 
    Primary pointer page: 500, Index root page: 501 
    Total formats: 1, used formats: 1 
    Average record length: 57.14, total records: 2211358 
    Average version length: 58.74, total versions: 13309, max versions: 2 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 84.00, compression ratio: 1.47 
    Pointer pages: 18, data page slots: 28400 
    Data pages: 28400, average fill: 71% 
    Primary pages: 28398, secondary pages: 2, swept pages: 11926 
    Empty pages: 6, full pages: 18263 
    Fill distribution: 
     0 - 19% = 12 
    20 - 39% = 47 
    40 - 59% = 726 
    60 - 79% = 27593 
    80 - 99% = 22 
 
    Index DOC_LIST_ID_DESC (1) 
    Root page: 1541152, depth: 3, leaf buckets: 4524, nodes: 2211358 
    Average node length: 11.41, total dup: 0, max dup: 0 
    Average key length: 8.45, compression ratio: 1.07 
    Average prefix length: 3.55, average data length: 5.45 
    Clustering factor: 681406, ratio: 0.31 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 959 
        40 - 59% = 787 
        60 - 79% = 800 
        80 - 99% = 1978 
 
    Index DOC_LIST_WORKER_OPTYPE (2) 
    Root page: 1544398, depth: 3, leaf buckets: 2419, nodes: 2212332 
    Average node length: 4.97, total dup: 2211433, max dup: 20375 
    Average key length: 2.01, compression ratio: 4.47 
    Average prefix length: 8.99, average data length: 0.01 
    Clustering factor: 1257121, ratio: 0.57 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 214 
        40 - 59% = 1452 
        60 - 79% = 523 
        80 - 99% = 228 
 
    Index FK_DOC_LIST_AGENTS (3) 
    Root page: 1545933, depth: 3, leaf buckets: 1768, nodes: 2211358 
    Average node length: 4.97, total dup: 2211308, max dup: 130123 
    Average key length: 2.01, compression ratio: 4.48 
    Average prefix length: 8.99, average data length: 0.01 
    Clustering factor: 1052989, ratio: 0.48 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 19 
        40 - 59% = 608 
        60 - 79% = 64 
        80 - 99% = 1076 
 
    Index PK_DOC_LIST (0) 
    Root page: 1538209, depth: 3, leaf buckets: 4303, nodes: 2211358 
    Average node length: 11.41, total dup: 0, max dup: 0 
    Average key length: 8.45, compression ratio: 1.07 
    Average prefix length: 3.55, average data length: 5.45 
    Clustering factor: 681406, ratio: 0.31 
    Fill distribution: 
         0 - 19% = 77 
        20 - 39% = 629 
        40 - 59% = 595 
        60 - 79% = 908 
        80 - 99% = 2094 
 
DOC_STATES (149) 
    Primary pointer page: 522, Index root page: 523 
    Total formats: 1, used formats: 1 
    Average record length: 67.50, total records: 4 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 650.00, compression ratio: 9.63 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 4% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index DOC_STATES_MCODE_UNQ (1) 
    Root page: 1504337, depth: 1, leaf buckets: 1, nodes: 4 
    Average node length: 17.75, total dup: 0, max dup: 0 
    Average key length: 16.50, compression ratio: 1.08 
    Average prefix length: 4.00, average data length: 13.75 
    Clustering factor: 1, ratio: 0.25 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index DOC_STATES_NAME_UNQ (2) 
    Root page: 1504338, depth: 1, leaf buckets: 1, nodes: 4 
    Average node length: 33.25, total dup: 0, max dup: 0 
    Average key length: 32.00, compression ratio: 0.99 
    Average prefix length: 2.50, average data length: 29.25 
    Clustering factor: 1, ratio: 0.25 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PK_DOC_STATES (0) 
    Root page: 1504336, depth: 1, leaf buckets: 1, nodes: 4 
    Average node length: 4.75, total dup: 0, max dup: 0 
    Average key length: 3.50, compression ratio: 0.86 
    Average prefix length: 1.50, average data length: 1.50 
    Clustering factor: 1, ratio: 0.25 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
FB_ERRORS (155) 
    Primary pointer page: 534, Index root page: 535 
    Total formats: 2, used formats: 2 
    Average record length: 57.88, total records: 2182 
    Average version length: 79.61, total versions: 757, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 270.43, compression ratio: 4.67 
    Pointer pages: 1, data page slots: 40 
    Data pages: 40, average fill: 72% 
    Primary pages: 39, secondary pages: 1, swept pages: 0 
    Empty pages: 4, full pages: 34 
    Fill distribution: 
     0 - 19% = 5 
    20 - 39% = 0 
    40 - 59% = 1 
    60 - 79% = 22 
    80 - 99% = 12 
 
    Index FB_ERRORS_GDS_CODE (0) 
    Root page: 398, depth: 2, leaf buckets: 2, nodes: 2182 
    Average node length: 4.40, total dup: 756, max dup: 1 
    Average key length: 2.67, compression ratio: 1.87 
    Average prefix length: 4.33, average data length: 0.67 
    Clustering factor: 1518, ratio: 0.70 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 0 
        40 - 59% = 1 
        60 - 79% = 1 
        80 - 99% = 0 
 
INVNT_SALDO (145) 
    Primary pointer page: 514, Index root page: 515 
    Total formats: 2, used formats: 1 
    Average record length: 83.14, total records: 400 
    Average version length: 24.03, total versions: 3431, max versions: 10 
    Average fragment length: 2.00, total fragments: 12, max fragments: 1 
    Average unpacked length: 104.00, compression ratio: 1.25 
    Pointer pages: 1, data page slots: 32 
    Data pages: 32, average fill: 70% 
    Primary pages: 9, secondary pages: 23, swept pages: 0 
    Empty pages: 6, full pages: 23 
    Fill distribution: 
     0 - 19% = 7 
    20 - 39% = 1 
    40 - 59% = 0 
    60 - 79% = 1 
    80 - 99% = 23 
 
    Index PK_INVNT_SALDO (0) 
    Root page: 1510371, depth: 1, leaf buckets: 1, nodes: 400 
    Average node length: 11.22, total dup: 0, max dup: 0 
    Average key length: 10.22, compression ratio: 0.88 
    Average prefix length: 1.78, average data length: 7.22 
    Clustering factor: 326, ratio: 0.81 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 0 
        40 - 59% = 1 
        60 - 79% = 0 
        80 - 99% = 0 
 
INVNT_TURNOVER_LOG (153) 
    Primary pointer page: 530, Index root page: 531 
    Total formats: 1, used formats: 1 
    Average record length: 11.23, total records: 74426 
    Average version length: 68.26, total versions: 71630, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 88.00, compression ratio: 7.84 
    Pointer pages: 7, data page slots: 1384 
    Data pages: 1368, average fill: 74% 
    Primary pages: 1367, secondary pages: 1, swept pages: 0 
    Empty pages: 102, full pages: 996 
    Fill distribution: 
     0 - 19% = 150 
    20 - 39% = 82 
    40 - 59% = 83 
    60 - 79% = 183 
    80 - 99% = 870 
 
    Index INVNT_TURNOVER_LOG_WARE_DD_ID (0) 
    Root page: 1713625, depth: 3, leaf buckets: 225, nodes: 74426 
    Average node length: 13.80, total dup: 2346, max dup: 1 
    Average key length: 10.87, compression ratio: 2.48 
    Average prefix length: 19.09, average data length: 7.91 
    Clustering factor: 56683, ratio: 0.76 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 7 
        40 - 59% = 123 
        60 - 79% = 92 
        80 - 99% = 2 
 
MONEY_SALDO (141) 
    Primary pointer page: 506, Index root page: 507 
    Total formats: 1, used formats: 1 
    Average record length: 15.29, total records: 49 
    Average version length: 9.00, total versions: 264, max versions: 9 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 32.00, compression ratio: 2.09 
    Pointer pages: 1, data page slots: 5 
    Data pages: 5, average fill: 21% 
    Primary pages: 1, secondary pages: 4, swept pages: 0 
    Empty pages: 0, full pages: 1 
    Fill distribution: 
     0 - 19% = 4 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 1 
 
    Index PK_MONEY_SALDO (0) 
    Root page: 1510383, depth: 1, leaf buckets: 1, nodes: 49 
    Average node length: 11.82, total dup: 0, max dup: 0 
    Average key length: 10.80, compression ratio: 0.83 
    Average prefix length: 1.18, average data length: 7.82 
    Clustering factor: 1, ratio: 0.02 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
MONEY_TURNOVER_LOG (140) 
    Primary pointer page: 504, Index root page: 505 
    Total formats: 1, used formats: 1 
    Average record length: 10.08, total records: 1289 
    Average version length: 42.74, total versions: 1248, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 58.00, compression ratio: 5.76 
    Pointer pages: 1, data page slots: 56 
    Data pages: 33, average fill: 41% 
    Primary pages: 32, secondary pages: 1, swept pages: 4 
    Empty pages: 8, full pages: 11 
    Fill distribution: 
     0 - 19% = 16 
    20 - 39% = 4 
    40 - 59% = 0 
    60 - 79% = 4 
    80 - 99% = 9 
 
    Index MONEY_TURNOVER_LOG_AGENT_OPTYPE (0) 
    Root page: 95861, depth: 2, leaf buckets: 2, nodes: 1289 
    Average node length: 4.66, total dup: 1191, max dup: 134 
    Average key length: 2.81, compression ratio: 6.77 
    Average prefix length: 18.27, average data length: 0.73 
    Clustering factor: 755, ratio: 0.59 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 1 
        40 - 59% = 1 
        60 - 79% = 0 
        80 - 99% = 0 
 
MON_CACHE_MEMORY (165) 
    Primary pointer page: 555, Index root page: 556 
    Total formats: 2, used formats: 1 
    Average record length: 97.77, total records: 70 
    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: 49% 
    Primary pages: 2, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 1 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 1 
    80 - 99% = 0 
 
    Index PK_MON_CACHE_MEMORY (0) 
    Root page: 1504238, depth: 1, leaf buckets: 1, nodes: 70 
    Average node length: 11.70, total dup: 0, max dup: 0 
    Average key length: 10.69, compression ratio: 0.84 
    Average prefix length: 1.30, average data length: 7.70 
    Clustering factor: 2, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
MON_LOG (162) 
    Primary pointer page: 548, Index root page: 549 
    Total formats: 2, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index MON_LOG_DTS (4) 
    Root page: 1504251, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index MON_LOG_GDSCODE (2) 
    Root page: 1504249, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index MON_LOG_ROWSET_DESC (1) 
    Root page: 1504248, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index MON_LOG_UNIT (3) 
    Root page: 1504250, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PK_MON_LOG (0) 
    Root page: 1504247, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
MON_LOG_TABLE_STATS (163) 
    Primary pointer page: 550, Index root page: 551 
    Total formats: 2, used formats: 1 
    Average record length: 67.13, total records: 30 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 611.00, compression ratio: 9.10 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 31% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 1 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index MON_LOG_TABLE_STATS_DTS (4) 
    Root page: 1504246, depth: 1, leaf buckets: 1, nodes: 30 
    Average node length: 3.50, total dup: 23, max dup: 4 
    Average key length: 2.47, compression ratio: 3.24 
    Average prefix length: 7.53, average data length: 0.47 
    Clustering factor: 1, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index MON_LOG_TABLE_STATS_GDSCODE (2) 
    Root page: 1504244, depth: 1, leaf buckets: 1, nodes: 30 
    Average node length: 2.00, total dup: 29, max dup: 29 
    Average key length: 1.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 1, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index MON_LOG_TABLE_STATS_ROWSET (1) 
    Root page: 1504243, depth: 1, leaf buckets: 1, nodes: 30 
    Average node length: 3.33, total dup: 29, max dup: 29 
    Average key length: 2.30, compression ratio: 3.91 
    Average prefix length: 8.70, average data length: 0.30 
    Clustering factor: 1, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index MON_LOG_TABLE_STATS_TN_UNIT (3) 
    Root page: 1504245, depth: 1, leaf buckets: 1, nodes: 30 
    Average node length: 12.90, total dup: 0, max dup: 0 
    Average key length: 11.87, compression ratio: 1.42 
    Average prefix length: 7.63, average data length: 9.20 
    Clustering factor: 1, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PK_MON_LOG_TABLE_STATS (0) 
    Root page: 1504242, depth: 1, leaf buckets: 1, nodes: 30 
    Average node length: 8.37, total dup: 0, max dup: 0 
    Average key length: 7.33, compression ratio: 1.23 
    Average prefix length: 4.63, average data length: 4.37 
    Clustering factor: 1, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
OPTYPES (136) 
    Primary pointer page: 496, Index root page: 497 
    Total formats: 2, used formats: 1 
    Average record length: 67.56, total records: 9 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 386.00, compression ratio: 5.71 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 9% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index OPTYPES_MCODE_UNQ (1) 
    Root page: 1544827, depth: 1, leaf buckets: 1, nodes: 9 
    Average node length: 8.56, total dup: 0, max dup: 0 
    Average key length: 6.89, compression ratio: 0.73 
    Average prefix length: 0.44, average data length: 4.56 
    Clustering factor: 1, ratio: 0.11 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PK_OPTYPES (0) 
    Root page: 1544826, depth: 1, leaf buckets: 1, nodes: 9 
    Average node length: 6.11, total dup: 0, max dup: 0 
    Average key length: 5.00, compression ratio: 0.60 
    Average prefix length: 0.89, average data length: 2.11 
    Clustering factor: 1, ratio: 0.11 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
PDISTR (146) 
    Primary pointer page: 516, Index root page: 517 
    Total formats: 1, used formats: 1 
    Average record length: 36.68, total records: 802791 
    Average version length: 37.91, total versions: 21987, max versions: 3 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 54.00, compression ratio: 1.47 
    Pointer pages: 6, data page slots: 8728 
    Data pages: 8728, average fill: 63% 
    Primary pages: 8725, secondary pages: 3, swept pages: 3052 
    Empty pages: 42, full pages: 5186 
    Fill distribution: 
     0 - 19% = 95 
    20 - 39% = 161 
    40 - 59% = 1242 
    60 - 79% = 7191 
    80 - 99% = 39 
 
    Index PDISTR_AGENT_ID (2) 
    Root page: 1509330, depth: 2, leaf buckets: 865, nodes: 791870 
    Average node length: 4.88, total dup: 791821, max dup: 144283 
    Average key length: 2.01, compression ratio: 4.48 
    Average prefix length: 8.99, average data length: 0.01 
    Clustering factor: 89802, ratio: 0.11 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 158 
        40 - 59% = 449 
        60 - 79% = 155 
        80 - 99% = 102 
 
    Index PDISTR_SNDOP_RCVOP_SNDID_ASC (0) 
    Root page: 1508635, depth: 3, leaf buckets: 953, nodes: 791870 
    Average node length: 5.89, total dup: 704927, max dup: 42 
    Average key length: 3.02, compression ratio: 7.29 
    Average prefix length: 21.09, average data length: 0.91 
    Clustering factor: 158155, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 60 
        40 - 59% = 540 
        60 - 79% = 82 
        80 - 99% = 270 
 
    Index PDISTR_SNDOP_RCVOP_SNDID_DESC (1) 
    Root page: 1509209, depth: 3, leaf buckets: 987, nodes: 791870 
    Average node length: 5.89, total dup: 704927, max dup: 42 
    Average key length: 3.02, compression ratio: 7.28 
    Average prefix length: 21.09, average data length: 0.91 
    Clustering factor: 160024, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 113 
        40 - 59% = 539 
        60 - 79% = 86 
        80 - 99% = 249 
 
    Index PDISTR_WORKER_SND_ID (3) 
    Root page: 1510200, depth: 3, leaf buckets: 1139, nodes: 791870 
    Average node length: 5.97, total dup: 704927, max dup: 42 
    Average key length: 3.10, compression ratio: 5.48 
    Average prefix length: 16.01, average data length: 0.99 
    Clustering factor: 152687, ratio: 0.19 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 256 
        40 - 59% = 614 
        60 - 79% = 187 
        80 - 99% = 81 
 
PERF_AGG (158) 
    Primary pointer page: 540, Index root page: 541 
    Total formats: 1, used formats: 1 
    Average record length: 62.76, total records: 5446 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 2.96, total fragments: 25, max fragments: 1 
    Average unpacked length: 379.00, compression ratio: 6.04 
    Pointer pages: 1, data page slots: 88 
    Data pages: 88, average fill: 61% 
    Primary pages: 74, secondary pages: 14, swept pages: 59 
    Empty pages: 8, full pages: 64 
    Fill distribution: 
     0 - 19% = 14 
    20 - 39% = 1 
    40 - 59% = 1 
    60 - 79% = 72 
    80 - 99% = 0 
 
    Index PERF_AGG_UNQ (1) 
    Root page: 1504260, depth: 2, leaf buckets: 6, nodes: 5446 
    Average node length: 5.48, total dup: 0, max dup: 0 
    Average key length: 3.58, compression ratio: 10.05 
    Average prefix length: 34.40, average data length: 1.54 
    Clustering factor: 5204, ratio: 0.96 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 0 
        40 - 59% = 4 
        60 - 79% = 1 
        80 - 99% = 1 
 
    Index PK_PERF_AGG (0) 
    Root page: 1504255, depth: 2, leaf buckets: 10, nodes: 5446 
    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: 179, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 1 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 7 
 
PERF_ESTIMATED (280) 
    Primary pointer page: 399, Index root page: 434 
    Total formats: 1, used formats: 1 
    Average record length: 39.10, total records: 77066 
    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: 808 
    Data pages: 808, average fill: 66% 
    Primary pages: 808, secondary pages: 0, swept pages: 0 
    Empty pages: 6, full pages: 801 
    Fill distribution: 
     0 - 19% = 7 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 801 
    80 - 99% = 0 
 
    Index PK_PERF_ESTIMATED (0) 
    Root page: 35252, depth: 2, leaf buckets: 98, nodes: 77066 
    Average node length: 10.17, total dup: 0, max dup: 0 
    Average key length: 8.18, compression ratio: 1.10 
    Average prefix length: 3.82, average data length: 5.18 
    Clustering factor: 3028, ratio: 0.04 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 97 
 
PERF_ISQL_STAT (156) 
    Primary pointer page: 536, Index root page: 537 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index PERF_ISQL_STAT_TRN (0) 
    Root page: 1504261, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
PERF_LOG (159) 
    Primary pointer page: 542, Index root page: 543 
    Total formats: 1, used formats: 1 
    Average record length: 111.03, total records: 71 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1691.00, compression ratio: 15.23 
    Pointer pages: 1, data page slots: 2 
    Data pages: 2, average fill: 56% 
    Primary pages: 2, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 1 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 1 
    40 - 59% = 0 
    60 - 79% = 1 
    80 - 99% = 0 
 
PERF_SPLIT_0 (281) 
    Primary pointer page: 601, Index root page: 602 
    Total formats: 1, used formats: 1 
    Average record length: 151.01, total records: 174520 
    Average version length: 144.46, total versions: 589, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.23 
    Pointer pages: 8, data page slots: 4880 
    Data pages: 4328, average fill: 83% 
    Primary pages: 4326, secondary pages: 2, swept pages: 1 
    Empty pages: 26, full pages: 4290 
    Fill distribution: 
     0 - 19% = 31 
    20 - 39% = 2 
    40 - 59% = 1 
    60 - 79% = 2 
    80 - 99% = 4292 
 
PERF_SPLIT_1 (282) 
    Primary pointer page: 603, Index root page: 604 
    Total formats: 1, used formats: 1 
    Average record length: 147.20, total records: 150959 
    Average version length: 153.18, total versions: 3937, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.52 
    Pointer pages: 7, data page slots: 4760 
    Data pages: 3736, average fill: 83% 
    Primary pages: 3733, secondary pages: 3, swept pages: 1 
    Empty pages: 27, full pages: 3700 
    Fill distribution: 
     0 - 19% = 30 
    20 - 39% = 2 
    40 - 59% = 2 
    60 - 79% = 1 
    80 - 99% = 3701 
 
PERF_SPLIT_2 (283) 
    Primary pointer page: 605, Index root page: 606 
    Total formats: 1, used formats: 1 
    Average record length: 149.85, total records: 187192 
    Average version length: 152.84, total versions: 1957, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.32 
    Pointer pages: 7, data page slots: 5088 
    Data pages: 4632, average fill: 83% 
    Primary pages: 4628, secondary pages: 4, swept pages: 4 
    Empty pages: 23, full pages: 4601 
    Fill distribution: 
     0 - 19% = 27 
    20 - 39% = 3 
    40 - 59% = 1 
    60 - 79% = 0 
    80 - 99% = 4601 
 
PERF_SPLIT_3 (284) 
    Primary pointer page: 607, Index root page: 616 
    Total formats: 1, used formats: 1 
    Average record length: 149.51, total records: 176792 
    Average version length: 153.36, total versions: 2184, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.34 
    Pointer pages: 7, data page slots: 4616 
    Data pages: 4360, average fill: 84% 
    Primary pages: 4358, secondary pages: 2, swept pages: 2 
    Empty pages: 7, full pages: 4344 
    Fill distribution: 
     0 - 19% = 12 
    20 - 39% = 2 
    40 - 59% = 1 
    60 - 79% = 1 
    80 - 99% = 4344 
 
PERF_SPLIT_4 (285) 
    Primary pointer page: 617, Index root page: 618 
    Total formats: 1, used formats: 1 
    Average record length: 150.60, total records: 168510 
    Average version length: 149.65, total versions: 730, 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: 8, data page slots: 4464 
    Data pages: 4168, average fill: 83% 
    Primary pages: 4166, secondary pages: 2, swept pages: 3 
    Empty pages: 24, full pages: 4137 
    Fill distribution: 
     0 - 19% = 27 
    20 - 39% = 1 
    40 - 59% = 1 
    60 - 79% = 1 
    80 - 99% = 4138 
 
PERF_SPLIT_5 (286) 
    Primary pointer page: 619, Index root page: 620 
    Total formats: 1, used formats: 1 
    Average record length: 149.67, total records: 165448 
    Average version length: 152.25, total versions: 1959, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.33 
    Pointer pages: 7, data page slots: 5624 
    Data pages: 4104, average fill: 83% 
    Primary pages: 4102, secondary pages: 2, swept pages: 1 
    Empty pages: 29, full pages: 4062 
    Fill distribution: 
     0 - 19% = 31 
    20 - 39% = 5 
    40 - 59% = 2 
    60 - 79% = 4 
    80 - 99% = 4062 
 
PERF_SPLIT_6 (287) 
    Primary pointer page: 621, Index root page: 622 
    Total formats: 1, used formats: 1 
    Average record length: 150.06, total records: 173000 
    Average version length: 152.39, total versions: 1527, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.30 
    Pointer pages: 6, data page slots: 4784 
    Data pages: 4280, average fill: 83% 
    Primary pages: 4278, secondary pages: 2, swept pages: 1 
    Empty pages: 21, full pages: 4249 
    Fill distribution: 
     0 - 19% = 24 
    20 - 39% = 5 
    40 - 59% = 1 
    60 - 79% = 0 
    80 - 99% = 4250 
 
PERF_SPLIT_7 (288) 
    Primary pointer page: 626, Index root page: 627 
    Total formats: 1, used formats: 1 
    Average record length: 149.25, total records: 166187 
    Average version length: 152.17, total versions: 2044, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.36 
    Pointer pages: 7, data page slots: 4664 
    Data pages: 4088, average fill: 84% 
    Primary pages: 4086, secondary pages: 2, swept pages: 3 
    Empty pages: 6, full pages: 4076 
    Fill distribution: 
     0 - 19% = 8 
    20 - 39% = 2 
    40 - 59% = 2 
    60 - 79% = 0 
    80 - 99% = 4076 
 
PERF_SPLIT_8 (289) 
    Primary pointer page: 628, Index root page: 629 
    Total formats: 1, used formats: 1 
    Average record length: 149.27, total records: 170430 
    Average version length: 153.32, total versions: 2329, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.36 
    Pointer pages: 7, data page slots: 4864 
    Data pages: 4208, average fill: 84% 
    Primary pages: 4206, secondary pages: 2, swept pages: 2 
    Empty pages: 14, full pages: 4187 
    Fill distribution: 
     0 - 19% = 17 
    20 - 39% = 1 
    40 - 59% = 2 
    60 - 79% = 2 
    80 - 99% = 4186 
 
PERF_SPLIT_9 (290) 
    Primary pointer page: 630, Index root page: 631 
    Total formats: 1, used formats: 1 
    Average record length: 150.36, total records: 155112 
    Average version length: 153.41, total versions: 769, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.28 
    Pointer pages: 7, data page slots: 3976 
    Data pages: 3848, average fill: 83% 
    Primary pages: 3846, secondary pages: 2, swept pages: 2 
    Empty pages: 33, full pages: 3804 
    Fill distribution: 
     0 - 19% = 34 
    20 - 39% = 7 
    40 - 59% = 1 
    60 - 79% = 2 
    80 - 99% = 3804 
 
PHRASES (143) 
    Primary pointer page: 510, Index root page: 511 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index PHRASES_ID_DESC (3) 
    Root page: 1510376, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PHRASES_NAME (2) 
    Root page: 1510375, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PHRASES_UNQ (1) 
    Root page: 1510374, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PK_PHRASES (0) 
    Root page: 1510373, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
PSTORNED (147) 
    Primary pointer page: 518, Index root page: 519 
    Total formats: 1, used formats: 1 
    Average record length: 52.54, total records: 2068149 
    Average version length: 52.93, total versions: 9876, 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: 25576 
    Data pages: 25568, average fill: 69% 
    Primary pages: 25551, secondary pages: 17, swept pages: 11690 
    Empty pages: 231, full pages: 22127 
    Fill distribution: 
     0 - 19% = 413 
    20 - 39% = 324 
    40 - 59% = 928 
    60 - 79% = 23832 
    80 - 99% = 71 
 
    Index PSTORNED_RCV_ID (1) 
    Root page: 1506208, depth: 3, leaf buckets: 2556, nodes: 2068149 
    Average node length: 5.44, total dup: 1929304, max dup: 1471 
    Average key length: 2.49, compression ratio: 3.62 
    Average prefix length: 8.58, average data length: 0.42 
    Clustering factor: 180997, ratio: 0.09 
    Fill distribution: 
         0 - 19% = 4 
        20 - 39% = 343 
        40 - 59% = 1606 
        60 - 79% = 310 
        80 - 99% = 293 
 
    Index PSTORNED_SND_ID (0) 
    Root page: 1504841, depth: 3, leaf buckets: 2753, nodes: 2068149 
    Average node length: 5.70, total dup: 1855661, max dup: 64 
    Average key length: 2.74, compression ratio: 3.28 
    Average prefix length: 8.36, average data length: 0.64 
    Clustering factor: 371097, ratio: 0.18 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 12 
        40 - 59% = 2485 
        60 - 79% = 225 
        80 - 99% = 31 
 
    Index PSTORNED_WORKER_ID (2) 
    Root page: 1508018, depth: 3, leaf buckets: 2105, nodes: 2068149 
    Average node length: 4.96, total dup: 2068049, max dup: 28356 
    Average key length: 2.00, compression ratio: 1.20 
    Average prefix length: 2.40, average data length: 0.00 
    Clustering factor: 178488, ratio: 0.09 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 222 
        40 - 59% = 1067 
        60 - 79% = 386 
        80 - 99% = 429 
 
RULES_FOR_PDISTR (148) 
    Primary pointer page: 520, Index root page: 521 
    Total formats: 1, used formats: 1 
    Average record length: 17.00, total records: 4 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 334.00, compression ratio: 19.65 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 2% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index RULES_FOR_PDISTR_UNQ (0) 
    Root page: 1504339, depth: 1, leaf buckets: 1, nodes: 4 
    Average node length: 11.50, total dup: 0, max dup: 0 
    Average key length: 10.25, compression ratio: 0.88 
    Average prefix length: 1.50, average data length: 7.50 
    Clustering factor: 1, ratio: 0.25 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
RULES_FOR_QDISTR (137) 
    Primary pointer page: 498, Index root page: 499 
    Total formats: 1, used formats: 1 
    Average record length: 32.71, total records: 7 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 332.00, compression ratio: 10.15 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 4% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index RULES_FOR_QDISTR_RCVOP (1) 
    Root page: 1544825, depth: 1, leaf buckets: 1, nodes: 7 
    Average node length: 5.29, total dup: 2, max dup: 2 
    Average key length: 4.14, compression ratio: 0.72 
    Average prefix length: 1.43, average data length: 1.57 
    Clustering factor: 1, ratio: 0.14 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index RULES_FOR_QDISTR_UNQ (0) 
    Root page: 1544824, depth: 1, leaf buckets: 1, nodes: 7 
    Average node length: 10.14, total dup: 0, max dup: 0 
    Average key length: 8.86, compression ratio: 0.94 
    Average prefix length: 2.14, average data length: 6.14 
    Clustering factor: 1, ratio: 0.14 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
SEMAPHORES (152) 
    Primary pointer page: 528, Index root page: 529 
    Total formats: 1, used formats: 1 
    Average record length: 43.40, total records: 5 
    Average version length: 9.00, total versions: 1, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 346.00, compression ratio: 7.97 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 4% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index PK_SEMAPHORES (0) 
    Root page: 1504327, depth: 1, leaf buckets: 1, nodes: 5 
    Average node length: 12.40, total dup: 0, max dup: 0 
    Average key length: 11.00, compression ratio: 0.82 
    Average prefix length: 0.60, average data length: 8.40 
    Clustering factor: 1, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index SEMAPHORES_TASK_UNQ (1) 
    Root page: 1504328, depth: 1, leaf buckets: 1, nodes: 5 
    Average node length: 23.40, total dup: 0, max dup: 0 
    Average key length: 22.00, compression ratio: 1.07 
    Average prefix length: 4.20, average data length: 19.40 
    Clustering factor: 1, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
SETTINGS (135) 
    Primary pointer page: 494, Index root page: 495 
    Total formats: 1, used formats: 1 
    Average record length: 97.62, total records: 149 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1347.00, compression ratio: 13.80 
    Pointer pages: 1, data page slots: 3 
    Data pages: 3, average fill: 70% 
    Primary pages: 3, secondary pages: 0, swept pages: 1 
    Empty pages: 0, full pages: 2 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 1 
    60 - 79% = 0 
    80 - 99% = 2 
 
    Index SETTINGS_MCODE_WM_UNQ (1) 
    Root page: 1544931, depth: 1, leaf buckets: 1, nodes: 149 
    Average node length: 14.66, total dup: 0, max dup: 0 
    Average key length: 13.55, compression ratio: 2.19 
    Average prefix length: 19.07, average data length: 10.66 
    Clustering factor: 48, ratio: 0.32 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 1 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index SETTINGS_MODE_CODE (0) 
    Root page: 1544828, depth: 1, leaf buckets: 1, nodes: 149 
    Average node length: 25.56, total dup: 0, max dup: 0 
    Average key length: 24.56, compression ratio: 1.63 
    Average prefix length: 18.58, average data length: 21.56 
    Clustering factor: 14, ratio: 0.09 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 0 
        40 - 59% = 1 
        60 - 79% = 0 
        80 - 99% = 0 
 
TMP$DEP_DOCS (129) 
    Primary pointer page: 482, Index root page: 483 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index TMP_DEP_DOCS_UNQ (0) 
    Root page: 1544832, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
TMP$IDX_RECALC (132) 
    Primary pointer page: 488, Index root page: 489 
    Total formats: 2, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index TMP_IDX_RECALC_IDX_NAME_UNQ (0) 
    Root page: 1544829, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
TMP$MON_LOG (133) 
    Primary pointer page: 490, Index root page: 491 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
TMP$MON_LOG_TABLE_STATS (134) 
    Primary pointer page: 492, Index root page: 493 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
TMP$PERF_EST_WHOLE (161) 
    Primary pointer page: 546, Index root page: 547 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
TMP$PERF_LOG (160) 
    Primary pointer page: 544, Index root page: 545 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index TMP$PERF_LOG_UNIT_TRN_DTS_END (0) 
    Root page: 1504252, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
TMP$PERF_MON (131) 
    Primary pointer page: 486, Index root page: 487 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
TMP$RESULT_SET (130) 
    Primary pointer page: 484, Index root page: 485 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index TMP_RESULT_SET_DOC (1) 
    Root page: 1544831, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index TMP_RESULT_SET_WARE_DOC (0) 
    Root page: 1544830, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
TMP$SHOPPING_CART (128) 
    Primary pointer page: 480, Index root page: 481 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index TMP_SHOPCART_UNQ (0) 
    Root page: 1544833, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
TPAUSE (166) 
    Primary pointer page: 557, Index root page: 558 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index RDB$PRIMARY2 (0) 
    Root page: 1504237, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
TRACE_STAT (157) 
    Primary pointer page: 538, Index root page: 539 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
WARES (142) 
    Primary pointer page: 508, Index root page: 509 
    Total formats: 1, used formats: 1 
    Average record length: 77.52, total records: 400 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 444.00, compression ratio: 5.73 
    Pointer pages: 1, data page slots: 6 
    Data pages: 6, average fill: 77% 
    Primary pages: 6, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 5 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 5 
    80 - 99% = 1 
 
    Index FK_WARES_WARE_GROUPS (3) 
    Root page: 1552183, depth: 1, leaf buckets: 1, nodes: 400 
    Average node length: 3.17, total dup: 392, max dup: 60 
    Average key length: 2.16, compression ratio: 4.16 
    Average prefix length: 8.86, average data length: 0.14 
    Clustering factor: 48, ratio: 0.12 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PK_WARES (0) 
    Root page: 1510377, depth: 1, leaf buckets: 1, nodes: 400 
    Average node length: 11.22, total dup: 0, max dup: 0 
    Average key length: 10.22, compression ratio: 0.88 
    Average prefix length: 1.78, average data length: 7.22 
    Clustering factor: 344, ratio: 0.86 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 0 
        40 - 59% = 1 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index WARES_ID_DESC (2) 
    Root page: 1510382, depth: 1, leaf buckets: 1, nodes: 400 
    Average node length: 11.22, total dup: 0, max dup: 0 
    Average key length: 10.22, compression ratio: 0.88 
    Average prefix length: 1.78, average data length: 7.22 
    Clustering factor: 344, ratio: 0.86 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 0 
        40 - 59% = 1 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index WARES_NUMB_UNQ (1) 
    Root page: 1510380, depth: 2, leaf buckets: 3, nodes: 400 
    Average node length: 53.25, total dup: 0, max dup: 0 
    Average key length: 52.23, compression ratio: 1.00 
    Average prefix length: 2.74, average data length: 49.25 
    Clustering factor: 355, ratio: 0.89 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 1 
        80 - 99% = 2 
 
WARE_GROUPS (151) 
    Primary pointer page: 526, Index root page: 527 
    Total formats: 1, used formats: 1 
    Average record length: 32.12, total records: 8 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 346.00, compression ratio: 10.77 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 5% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index PK_WARE_GROUPS (0) 
    Root page: 1504329, depth: 1, leaf buckets: 1, nodes: 8 
    Average node length: 11.25, total dup: 0, max dup: 0 
    Average key length: 10.12, compression ratio: 0.89 
    Average prefix length: 1.75, average data length: 7.25 
    Clustering factor: 1, ratio: 0.12 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index WARE_GROUPS_NAME_UNQ (1) 
    Root page: 1504330, depth: 1, leaf buckets: 1, nodes: 8 
    Average node length: 19.88, total dup: 0, max dup: 0 
    Average key length: 18.12, compression ratio: 0.89 
    Average prefix length: 0.25, average data length: 15.88 
    Clustering factor: 1, ratio: 0.12 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
XQD_1000_1200 (176) 
    Primary pointer page: 577, Index root page: 578 
    Total formats: 1, used formats: 1 
    Average record length: 45.71, total records: 136240 
    Average version length: 69.18, total versions: 53215, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 2.76 
    Pointer pages: 3, data page slots: 3400 
    Data pages: 2928, average fill: 56% 
    Primary pages: 2928, secondary pages: 0, swept pages: 343 
    Empty pages: 312, full pages: 1564 
    Fill distribution: 
     0 - 19% = 605 
    20 - 39% = 365 
    40 - 59% = 279 
    60 - 79% = 730 
    80 - 99% = 949 
 
    Index XQD_1000_1200_WA_SO_RO_WKR_SND (0) 
    Root page: 1555990, depth: 3, leaf buckets: 213, nodes: 136240 
    Average node length: 6.40, total dup: 118634, max dup: 14 
    Average key length: 3.95, compression ratio: 10.63 
    Average prefix length: 40.18, average data length: 1.82 
    Clustering factor: 23961, ratio: 0.18 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 50 
        40 - 59% = 101 
        60 - 79% = 51 
        80 - 99% = 10 
 
XQD_1000_3300 (178) 
    Primary pointer page: 581, Index root page: 582 
    Total formats: 1, used formats: 1 
    Average record length: 66.45, total records: 6950725 
    Average version length: 68.76, total versions: 289526, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.90 
    Pointer pages: 68, data page slots: 109520 
    Data pages: 109520, average fill: 68% 
    Primary pages: 109517, secondary pages: 3, swept pages: 36144 
    Empty pages: 19, full pages: 51939 
    Fill distribution: 
     0 - 19% = 256 
    20 - 39% = 2173 
    40 - 59% = 15647 
    60 - 79% = 90886 
    80 - 99% = 558 
 
    Index XQD_1000_3300_WA_SO_RO_WKR_SND (0) 
    Root page: 1480476, depth: 3, leaf buckets: 10747, nodes: 6950725 
    Average node length: 6.51, total dup: 6011371, max dup: 29 
    Average key length: 3.52, compression ratio: 11.92 
    Average prefix length: 40.61, average data length: 1.39 
    Clustering factor: 1654695, ratio: 0.24 
    Fill distribution: 
         0 - 19% = 6 
        20 - 39% = 1660 
        40 - 59% = 6322 
        60 - 79% = 2432 
        80 - 99% = 327 
 
    Index XQD_1000_3300_WKR_DOC_ASC (1) 
    Root page: 1486090, depth: 3, leaf buckets: 8493, nodes: 6950725 
    Average node length: 5.40, total dup: 6670623, max dup: 121 
    Average key length: 2.41, compression ratio: 7.05 
    Average prefix length: 16.63, average data length: 0.37 
    Clustering factor: 1463995, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 7 
        20 - 39% = 1262 
        40 - 59% = 4828 
        60 - 79% = 1318 
        80 - 99% = 1078 
 
    Index XQD_1000_3300_WKR_DOC_DEC (2) 
    Root page: 1490630, depth: 3, leaf buckets: 8567, nodes: 6950725 
    Average node length: 5.40, total dup: 6670623, max dup: 121 
    Average key length: 2.41, compression ratio: 7.05 
    Average prefix length: 16.63, average data length: 0.37 
    Clustering factor: 1466356, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 4 
        20 - 39% = 1375 
        40 - 59% = 4806 
        60 - 79% = 1340 
        80 - 99% = 1042 
 
XQD_1200_2000 (177) 
    Primary pointer page: 579, Index root page: 580 
    Total formats: 1, used formats: 1 
    Average record length: 67.84, total records: 11994544 
    Average version length: 68.71, total versions: 221624, 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: 109, data page slots: 177336 
    Data pages: 177336, average fill: 72% 
    Primary pages: 177335, secondary pages: 1, swept pages: 86721 
    Empty pages: 6, full pages: 133797 
    Fill distribution: 
     0 - 19% = 156 
    20 - 39% = 1372 
    40 - 59% = 10220 
    60 - 79% = 164628 
    80 - 99% = 960 
 
    Index XQD_1200_2000_WA_SO_RO_WKR_SND (0) 
    Root page: 1495050, depth: 3, leaf buckets: 18472, nodes: 11993857 
    Average node length: 6.62, total dup: 10456428, max dup: 71 
    Average key length: 3.43, compression ratio: 12.26 
    Average prefix length: 40.70, average data length: 1.30 
    Clustering factor: 2453799, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 44 
        20 - 39% = 2248 
        40 - 59% = 11093 
        60 - 79% = 4373 
        80 - 99% = 714 
 
XQD_2000_3300 (179) 
    Primary pointer page: 583, Index root page: 584 
    Total formats: 1, used formats: 1 
    Average record length: 55.34, total records: 1312137 
    Average version length: 69.09, total versions: 235022, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 2.28 
    Pointer pages: 25, data page slots: 39104 
    Data pages: 26119, average fill: 55% 
    Primary pages: 26060, secondary pages: 59, swept pages: 9542 
    Empty pages: 3218, full pages: 14622 
    Fill distribution: 
     0 - 19% = 5212 
    20 - 39% = 2688 
    40 - 59% = 2565 
    60 - 79% = 12496 
    80 - 99% = 3158 
 
    Index XQD_2000_3300_WA_SO_RO_WKR_SND (0) 
    Root page: 1479735, depth: 3, leaf buckets: 1719, nodes: 1245792 
    Average node length: 5.53, total dup: 1195153, max dup: 49 
    Average key length: 2.58, compression ratio: 16.30 
    Average prefix length: 41.46, average data length: 0.54 
    Clustering factor: 85312, ratio: 0.07 
    Fill distribution: 
         0 - 19% = 14 
        20 - 39% = 450 
        40 - 59% = 815 
        60 - 79% = 385 
        80 - 99% = 55 
 
XQD_2100_3300 (180) 
    Primary pointer page: 585, Index root page: 586 
    Total formats: 1, used formats: 1 
    Average record length: 45.73, total records: 903120 
    Average version length: 69.06, total versions: 123861, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 2.76 
    Pointer pages: 20, data page slots: 31632 
    Data pages: 27456, average fill: 32% 
    Primary pages: 27455, secondary pages: 1, swept pages: 7716 
    Empty pages: 5200, full pages: 6742 
    Fill distribution: 
     0 - 19% = 10720 
    20 - 39% = 6292 
    40 - 59% = 5320 
    60 - 79% = 4855 
    80 - 99% = 269 
 
    Index XQD_2100_3300_WA_SO_RO_WKR_SND (0) 
    Root page: 1479229, depth: 3, leaf buckets: 1150, nodes: 676656 
    Average node length: 5.88, total dup: 626691, max dup: 49 
    Average key length: 2.96, compression ratio: 14.19 
    Average prefix length: 41.11, average data length: 0.89 
    Clustering factor: 92056, ratio: 0.14 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 515 
        40 - 59% = 518 
        60 - 79% = 105 
        80 - 99% = 12 
 
XQD_3300_3400 (181) 
    Primary pointer page: 587, Index root page: 588 
    Total formats: 1, used formats: 1 
    Average record length: 67.74, total records: 8947187 
    Average version length: 68.95, total versions: 170950, 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: 87, data page slots: 141976 
    Data pages: 141944, average fill: 67% 
    Primary pages: 141925, secondary pages: 19, swept pages: 63444 
    Empty pages: 435, full pages: 71976 
    Fill distribution: 
     0 - 19% = 1141 
    20 - 39% = 4962 
    40 - 59% = 21218 
    60 - 79% = 113875 
    80 - 99% = 748 
 
    Index XQD_3300_3400_WA_SO_RO_WKR_SND (0) 
    Root page: 1472612, depth: 3, leaf buckets: 13423, nodes: 8945757 
    Average node length: 6.68, total dup: 7418117, max dup: 14 
    Average key length: 3.67, compression ratio: 11.44 
    Average prefix length: 40.50, average data length: 1.50 
    Clustering factor: 2021163, ratio: 0.23 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 1438 
        40 - 59% = 7263 
        60 - 79% = 4254 
        80 - 99% = 466 
 
XQS_1000_1200 (182) 
    Primary pointer page: 589, Index root page: 590 
    Total formats: 1, used formats: 1 
    Average record length: 82.51, total records: 21110388 
    Average version length: 82.97, total versions: 6828, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.53 
    Pointer pages: 196, data page slots: 319240 
    Data pages: 319240, average fill: 81% 
    Primary pages: 319236, secondary pages: 4, swept pages: 12474 
    Empty pages: 57, full pages: 318154 
    Fill distribution: 
     0 - 19% = 81 
    20 - 39% = 57 
    40 - 59% = 145 
    60 - 79% = 47970 
    80 - 99% = 270987 
 
    Index XQS_1000_1200_DOC_ID (1) 
    Root page: 1426738, depth: 3, leaf buckets: 19404, nodes: 21110388 
    Average node length: 5.72, total dup: 20630365, max dup: 149 
    Average key length: 2.16, compression ratio: 4.16 
    Average prefix length: 8.86, average data length: 0.14 
    Clustering factor: 3276018, ratio: 0.16 
    Fill distribution: 
         0 - 19% = 3 
        20 - 39% = 0 
        40 - 59% = 8245 
        60 - 79% = 561 
        80 - 99% = 10595 
 
    Index XQS_1000_1200_RCV_ID (3) 
    Root page: 1457002, depth: 3, leaf buckets: 17132, nodes: 21110388 
    Average node length: 6.31, total dup: 18551323, max dup: 49 
    Average key length: 2.75, compression ratio: 3.27 
    Average prefix length: 8.37, average data length: 0.63 
    Clustering factor: 915189, ratio: 0.04 
    Fill distribution: 
         0 - 19% = 5 
        20 - 39% = 2 
        40 - 59% = 754 
        60 - 79% = 289 
        80 - 99% = 16082 
 
    Index XQS_1000_1200_SND_ID (2) 
    Root page: 1441095, depth: 3, leaf buckets: 21205, nodes: 21110388 
    Average node length: 6.35, total dup: 18471074, max dup: 29 
    Average key length: 2.79, compression ratio: 3.23 
    Average prefix length: 8.34, average data length: 0.66 
    Clustering factor: 3570220, ratio: 0.17 
    Fill distribution: 
         0 - 19% = 4 
        20 - 39% = 0 
        40 - 59% = 8574 
        60 - 79% = 584 
        80 - 99% = 12043 
 
    Index XQS_1000_1200_WORKER_ID (0) 
    Root page: 1413370, depth: 3, leaf buckets: 16015, nodes: 21110388 
    Average node length: 5.56, total dup: 21110288, max dup: 233058 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.42, average data length: 0.00 
    Clustering factor: 943960, ratio: 0.04 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 11 
        40 - 59% = 2819 
        60 - 79% = 314 
        80 - 99% = 12870 
 
XQS_1000_3300 (184) 
    Primary pointer page: 593, Index root page: 594 
    Total formats: 1, used formats: 1 
    Average record length: 81.06, total records: 9399034 
    Average version length: 82.66, total versions: 172304, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.55 
    Pointer pages: 104, data page slots: 168968 
    Data pages: 168896, average fill: 69% 
    Primary pages: 168867, secondary pages: 29, swept pages: 91312 
    Empty pages: 635, full pages: 91189 
    Fill distribution: 
     0 - 19% = 1813 
    20 - 39% = 7240 
    40 - 59% = 25771 
    60 - 79% = 117985 
    80 - 99% = 16087 
 
    Index XQS_1000_3300_DOC_ID (1) 
    Root page: 1367524, depth: 3, leaf buckets: 11330, nodes: 9399034 
    Average node length: 5.36, total dup: 9093776, max dup: 186 
    Average key length: 2.24, compression ratio: 4.02 
    Average prefix length: 8.79, average data length: 0.21 
    Clustering factor: 2124463, ratio: 0.23 
    Fill distribution: 
         0 - 19% = 3 
        20 - 39% = 85 
        40 - 59% = 9092 
        60 - 79% = 2115 
        80 - 99% = 35 
 
    Index XQS_1000_3300_RCV_ID (3) 
    Root page: 1379283, depth: 3, leaf buckets: 13228, nodes: 9399034 
    Average node length: 6.22, total dup: 7789544, max dup: 14 
    Average key length: 3.10, compression ratio: 2.90 
    Average prefix length: 8.07, average data length: 0.93 
    Clustering factor: 1489473, ratio: 0.16 
    Fill distribution: 
         0 - 19% = 110 
        20 - 39% = 3891 
        40 - 59% = 4374 
        60 - 79% = 2622 
        80 - 99% = 2231 
 
    Index XQS_1000_3300_SND_ID (2) 
    Root page: 1373081, depth: 3, leaf buckets: 12645, nodes: 9399034 
    Average node length: 5.97, total dup: 8149297, max dup: 44 
    Average key length: 2.85, compression ratio: 3.15 
    Average prefix length: 8.28, average data length: 0.72 
    Clustering factor: 2311099, ratio: 0.25 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 108 
        40 - 59% = 10118 
        60 - 79% = 2375 
        80 - 99% = 43 
 
    Index XQS_1000_3300_WORKER_ID (0) 
    Root page: 1362789, depth: 3, leaf buckets: 9909, nodes: 9399034 
    Average node length: 5.12, total dup: 9398934, max dup: 162965 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.42, average data length: 0.00 
    Clustering factor: 1510502, ratio: 0.16 
    Fill distribution: 
         0 - 19% = 46 
        20 - 39% = 1337 
        40 - 59% = 4796 
        60 - 79% = 1779 
        80 - 99% = 1951 
 
XQS_1200_2000 (183) 
    Primary pointer page: 591, Index root page: 592 
    Total formats: 1, used formats: 1 
    Average record length: 81.47, total records: 11029741 
    Average version length: 82.69, total versions: 124921, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.55 
    Pointer pages: 118, data page slots: 191416 
    Data pages: 189808, average fill: 71% 
    Primary pages: 189665, secondary pages: 143, swept pages: 73038 
    Empty pages: 3450, full pages: 143090 
    Fill distribution: 
     0 - 19% = 5687 
    20 - 39% = 8024 
    40 - 59% = 17202 
    60 - 79% = 101492 
    80 - 99% = 57403 
 
    Index XQS_1200_2000_DOC_ID (1) 
    Root page: 1392123, depth: 3, leaf buckets: 13102, nodes: 11029741 
    Average node length: 5.29, total dup: 10920680, max dup: 631 
    Average key length: 2.08, compression ratio: 4.32 
    Average prefix length: 8.93, average data length: 0.07 
    Clustering factor: 2307383, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 138 
        40 - 59% = 10055 
        60 - 79% = 2844 
        80 - 99% = 65 
 
    Index XQS_1200_2000_RCV_ID (3) 
    Root page: 1406132, depth: 3, leaf buckets: 10272, nodes: 11029741 
    Average node length: 5.48, total dup: 10546681, max dup: 49 
    Average key length: 2.28, compression ratio: 3.95 
    Average prefix length: 8.77, average data length: 0.23 
    Clustering factor: 700523, ratio: 0.06 
    Fill distribution: 
         0 - 19% = 170 
        20 - 39% = 901 
        40 - 59% = 2542 
        60 - 79% = 1842 
        80 - 99% = 4817 
 
    Index XQS_1200_2000_SND_ID (2) 
    Root page: 1398660, depth: 3, leaf buckets: 14988, nodes: 11029741 
    Average node length: 6.02, total dup: 9618856, max dup: 73 
    Average key length: 2.81, compression ratio: 3.20 
    Average prefix length: 8.32, average data length: 0.68 
    Clustering factor: 2323712, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 5 
        20 - 39% = 185 
        40 - 59% = 11583 
        60 - 79% = 3134 
        80 - 99% = 81 
 
    Index XQS_1200_2000_WORKER_ID (0) 
    Root page: 1386233, depth: 3, leaf buckets: 10574, nodes: 11029741 
    Average node length: 5.21, total dup: 11029641, max dup: 196659 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.41, average data length: 0.00 
    Clustering factor: 689239, ratio: 0.06 
    Fill distribution: 
         0 - 19% = 113 
        20 - 39% = 923 
        40 - 59% = 4582 
        60 - 79% = 1542 
        80 - 99% = 3414 
 
XQS_2000_3300 (185) 
    Primary pointer page: 595, Index root page: 596 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index XQS_2000_3300_DOC_ID (1) 
    Root page: 1361775, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index XQS_2000_3300_RCV_ID (3) 
    Root page: 1361777, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index XQS_2000_3300_SND_ID (2) 
    Root page: 1361776, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index XQS_2000_3300_WORKER_ID (0) 
    Root page: 1361774, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
XQS_2100_3300 (186) 
    Primary pointer page: 597, Index root page: 598 
    Total formats: 1, used formats: 1 
    Average record length: 81.64, total records: 9482800 
    Average version length: 82.90, total versions: 141545, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.54 
    Pointer pages: 107, data page slots: 173168 
    Data pages: 173112, average fill: 68% 
    Primary pages: 173081, secondary pages: 31, swept pages: 99420 
    Empty pages: 634, full pages: 88943 
    Fill distribution: 
     0 - 19% = 1938 
    20 - 39% = 8735 
    40 - 59% = 29550 
    60 - 79% = 117851 
    80 - 99% = 15038 
 
    Index XQS_2100_3300_DOC_ID (1) 
    Root page: 1344708, depth: 3, leaf buckets: 11489, nodes: 9482800 
    Average node length: 5.17, total dup: 9454173, max dup: 2539 
    Average key length: 2.03, compression ratio: 4.43 
    Average prefix length: 8.97, average data length: 0.03 
    Clustering factor: 1928530, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 34 
        20 - 39% = 1541 
        40 - 59% = 7545 
        60 - 79% = 1805 
        80 - 99% = 564 
 
    Index XQS_2100_3300_RCV_ID (3) 
    Root page: 1355739, depth: 3, leaf buckets: 13383, nodes: 9482800 
    Average node length: 6.24, total dup: 7858866, max dup: 14 
    Average key length: 3.10, compression ratio: 2.90 
    Average prefix length: 8.07, average data length: 0.93 
    Clustering factor: 1448137, ratio: 0.15 
    Fill distribution: 
         0 - 19% = 167 
        20 - 39% = 3980 
        40 - 59% = 4277 
        60 - 79% = 2657 
        80 - 99% = 2302 
 
    Index XQS_2100_3300_SND_ID (2) 
    Root page: 1350071, depth: 3, leaf buckets: 12124, nodes: 9482800 
    Average node length: 5.42, total dup: 9054663, max dup: 99 
    Average key length: 2.29, compression ratio: 3.93 
    Average prefix length: 8.76, average data length: 0.24 
    Clustering factor: 2058189, ratio: 0.22 
    Fill distribution: 
         0 - 19% = 25 
        20 - 39% = 1482 
        40 - 59% = 8433 
        60 - 79% = 1666 
        80 - 99% = 518 
 
    Index XQS_2100_3300_WORKER_ID (0) 
    Root page: 987843, depth: 3, leaf buckets: 10001, nodes: 9482800 
    Average node length: 5.14, total dup: 9482700, max dup: 165290 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.42, average data length: 0.00 
    Clustering factor: 1528497, ratio: 0.16 
    Fill distribution: 
         0 - 19% = 49 
        20 - 39% = 1313 
        40 - 59% = 4901 
        60 - 79% = 1752 
        80 - 99% = 1986 
 
XQS_3300_3400 (187) 
    Primary pointer page: 599, Index root page: 600 
    Total formats: 1, used formats: 1 
    Average record length: 67.93, total records: 568776 
    Average version length: 68.79, total versions: 2328, 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: 5, data page slots: 7992 
    Data pages: 7992, average fill: 74% 
    Primary pages: 7992, secondary pages: 0, swept pages: 3858 
    Empty pages: 1, full pages: 6867 
    Fill distribution: 
     0 - 19% = 3 
    20 - 39% = 12 
    40 - 59% = 157 
    60 - 79% = 7805 
    80 - 99% = 15 
 
    Index XQS_3300_3400_DOC_ID (1) 
    Root page: 39568, depth: 3, leaf buckets: 726, nodes: 568776 
    Average node length: 5.95, total dup: 484158, max dup: 82 
    Average key length: 3.09, compression ratio: 2.91 
    Average prefix length: 8.05, average data length: 0.95 
    Clustering factor: 100207, ratio: 0.18 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 28 
        40 - 59% = 506 
        60 - 79% = 95 
        80 - 99% = 97 
 
    Index XQS_3300_3400_SND_ID (2) 
    Root page: 33472, depth: 3, leaf buckets: 747, nodes: 568776 
    Average node length: 6.15, total dup: 466424, max dup: 25 
    Average key length: 3.29, compression ratio: 2.73 
    Average prefix length: 7.89, average data length: 1.11 
    Clustering factor: 100270, ratio: 0.18 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 33 
        40 - 59% = 513 
        60 - 79% = 94 
        80 - 99% = 106 
 
    Index XQS_3300_3400_WORKER_ID (0) 
    Root page: 377587, depth: 2, leaf buckets: 561, nodes: 568776 
    Average node length: 4.86, total dup: 568676, max dup: 8862 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.41, average data length: 0.00 
    Clustering factor: 89166, ratio: 0.16 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 33 
        40 - 59% = 322 
        60 - 79% = 75 
        80 - 99% = 129 
 
ZDOC_DATA (170) 
    Primary pointer page: 565, Index root page: 566 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
ZDOC_LIST (169) 
    Primary pointer page: 563, Index root page: 564 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
ZINVNT_TURNOVER_LOG (171) 
    Primary pointer page: 567, Index root page: 568 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
ZPDISTR (174) 
    Primary pointer page: 573, Index root page: 574 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index ZPDISTR_ID (0) 
    Root page: 1504230, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
ZPSTORNED (175) 
    Primary pointer page: 575, Index root page: 576 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index ZPSTORNED_ID (0) 
    Root page: 1504229, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
ZQDISTR (172) 
    Primary pointer page: 569, Index root page: 570 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index ZQDISTR_ID (0) 
    Root page: 1504235, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index ZQDISTR_WARE_SNDOP_RCVOP (1) 
    Root page: 1504236, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
ZQSTORNED (173) 
    Primary pointer page: 571, Index root page: 572 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index ZQSTORNED_DOC_ID (1) 
    Root page: 1504232, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index ZQSTORNED_ID (0) 
    Root page: 1504231, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index ZQSTORNED_RCV_ID (3) 
    Root page: 1504234, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index ZQSTORNED_SND_ID (2) 
    Root page: 1504233, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
ZTMP_DEP_DOCS (168) 
    Primary pointer page: 561, Index root page: 562 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
ZTMP_SHOPPING_CART (167) 
    Primary pointer page: 559, Index root page: 560 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
Z_USED_VIEWS (144) 
    Primary pointer page: 512, Index root page: 513 
    Total formats: 1, used formats: 1 
    Average record length: 29.38, total records: 29 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 99.00, compression ratio: 3.37 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 16% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index Z_USED_VIEWS_UNQ (0) 
    Root page: 1510372, depth: 1, leaf buckets: 1, nodes: 29 
    Average node length: 15.17, total dup: 0, max dup: 0 
    Average key length: 14.14, compression ratio: 1.44 
    Average prefix length: 9.17, average data length: 11.17 
    Clustering factor: 1, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
Gstat completion time Mon Apr 15 04:10:02 2024

Record versions statistics, table

TABLE_NAME TOTAL_RECS TOTAL_VERS MAX_VERSIONS VERS_TO_RECS_PRC MAXV_TO_VERS_PRC
DOC_DATA 7689212 27334 1 0.0000 0.0000
DOC_LIST 2211358 13309 2 0.0000 0.0000
FB_ERRORS 2182 757 1 0.0000 0.0000
INVNT_SALDO 400 3431 10 800.0000 0.0000
INVNT_TURNOVER_LOG 74426 71630 1 0.0000 0.0000
MONEY_SALDO 49 264 9 500.0000 0.0000
MONEY_TURNOVER_LOG 1289 1248 1 0.0000 0.0000
PDISTR 802791 21987 3 0.0000 0.0000
PERF_SPLIT_0 174520 589 1 0.0000 0.0000
PERF_SPLIT_1 150959 3937 1 0.0000 0.0000
PERF_SPLIT_2 187192 1957 1 0.0000 0.0000
PERF_SPLIT_3 176792 2184 1 0.0000 0.0000
PERF_SPLIT_4 168510 730 1 0.0000 0.0000
PERF_SPLIT_5 165448 1959 1 0.0000 0.0000
PERF_SPLIT_6 173000 1527 1 0.0000 0.0000
PERF_SPLIT_7 166187 2044 1 0.0000 0.0000
PERF_SPLIT_8 170430 2329 1 0.0000 0.0000
PERF_SPLIT_9 155112 769 1 0.0000 0.0000
PSTORNED 2068149 9876 1 0.0000 0.0000
SEMAPHORES 5 1 1 0.0000 100.0000
XQD_1000_1200 136240 53215 1 0.0000 0.0000
XQD_1000_3300 6950725 289526 1 0.0000 0.0000
XQD_1200_2000 11994544 221624 1 0.0000 0.0000
XQD_2000_3300 1312137 235022 1 0.0000 0.0000
XQD_2100_3300 903120 123861 1 0.0000 0.0000
XQD_3300_3400 8947187 170950 1 0.0000 0.0000
XQS_1000_1200 21110388 6828 1 0.0000 0.0000
XQS_1000_3300 9399034 172304 1 0.0000 0.0000
XQS_1200_2000 11029741 124921 1 0.0000 0.0000
XQS_2100_3300 9482800 141545 1 0.0000 0.0000
XQS_3300_3400 568776 2328 1 0.0000 0.0000

Record versions statistics, chart

Total records and versions, chart

Ratios versions / total_records and max_versions / total_versions

Database validation 


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

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

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

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

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