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

Hardware and OS info

Command: hostnamectl
Static hostname mscs-test-161.budzdorov.ru
Icon name computer-server
Chassis server
Machine ID aeee285d2cca40bf84c40a748f599e77
Boot ID 2a7b53d1c5ed44b9bb2712fffac5d8c6
Operating System CentOS Linux 7 (Core)
CPE OS Name cpe:/o:centos:centos:7
Kernel Linux 3.10.0-1127.10.1.el7.x86_64
Architecture x86-64
Command: who -b
bootup_info system boot 2021-11-11 18:28
Command: dmidecode -t system|grep -i -e 'manufacturer\|product\|hypervisor'
Manufacturer HP
Product Name ProLiant DL380 Gen9
Command: dmesg | grep DMI
[ 0.000000] DMI HP ProLiant DL380 Gen9/ProLiant DL380 Gen9, BIOS P89 05/21/2018
Command: lscpu | grep -i -v flags
Architecture x86_64
CPU op-mode(s) 32-bit, 64-bit
Byte Order Little Endian
CPU(s) 24
On-line CPU(s) list 0-23
Thread(s) per core 2
Core(s) per socket 6
Socket(s) 2
NUMA node(s) 2
Vendor ID GenuineIntel
CPU family 6
Model 63
Model name Intel(R) Xeon(R) CPU E5-2620 v3 @ 2.40GHz
Stepping 2
CPU MHz 1200.000
CPU max MHz 2400.0000
CPU min MHz 1200.0000
BogoMIPS 4794.33
Virtualization VT-x
L1d cache 32K
L1i cache 32K
L2 cache 256K
L3 cache 15360K
NUMA node0 CPU(s) 0-5,12-17
NUMA node1 CPU(s) 6-11,18-23
Command: cat /proc/meminfo | grep -i -e 'memtotal\|memfree\|memavail\|buffers\|cached\|swapcached'
MemTotal 32643792 kB
MemFree 15805492 kB
MemAvailable 30305540 kB
Buffers 0 kB
Cached 15953420 kB
SwapCached 2400 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-02-22 10:07:50
DTS_END                         2024-02-22 10:07:50.7600
FB_GDSCODE                      -1
FB_MNEMONA                      
STACK                           SP_CANCEL_SUPPLIER_ORDER(116:18) ==> SP_CANCEL_CUSTOMER_RESERVE(36:5) ==> SP_CHECK_TO_STOP_WORK(32:12) ==> SP_HALT_ON_ERROR(68:17)
IP                              ::1/33414
TRN_ID                          180442
ATT_ID                          600
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: 9235.03 19078 923503
customer order: creation 189.06 395 18906
customer order: refuse 15.91 357 1591
order to supplier: creation 49.52 1292 4952
order to supplier: removal 3.73 83106 373
invoice (draft): creation 49.48 3406 4948
invoice (draft): removal 48.16 683 4816
invoice accept: apply 44.03 20402 4403
invoice accept: cancel 43.08 845 4308
customer reserve: creation 4249.16 195 424916
customer reserve: removal 4232.21 59 423221
realization accept: apply 92.78 226 9278
realization accept: cancel 78.28 143 7828
payment from customer: creation 64.01 137 6401
payment from customer: removal 6.34 101 634
payment to supplier: creation 53.38 172 5338
payment to supplier: removal 3.90 130 390
service: total inventory turnovers 4.32 3436 432
service: total monetary turnovers 6.65 648 665
service: aggregate perf. data 1.00 12248 100
service: refresh index statistics 0.03 253569 3

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:02, from 22-02-2024 10:09:39 to 22-02-2024 10:09:41.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 1325
TEST_TIME 2 2470
TEST_TIME 3 2679
TEST_TIME 4 3901
TEST_TIME 5 4062
TEST_TIME 6 4358
TEST_TIME 7 4696
TEST_TIME 8 5954
TEST_TIME 9 5822
TEST_TIME 10 5823
TEST_TIME 11 6391
TEST_TIME 12 6580
TEST_TIME 13 6576
TEST_TIME 14 6490
TEST_TIME 15 6732
TEST_TIME 16 6806
TEST_TIME 17 6808
TEST_TIME 18 6991
TEST_TIME 19 6964
TEST_TIME 20 7326
TEST_TIME 21 7684
TEST_TIME 22 7633
TEST_TIME 23 8165
TEST_TIME 24 8476
TEST_TIME 25 8916
TEST_TIME 26 9366
TEST_TIME 27 9869
TEST_TIME 28 9917
TEST_TIME 29 9899
TEST_TIME 30 9797
TEST_TIME 31 9819
TEST_TIME 32 9797
TEST_TIME 33 9537
TEST_TIME 34 9508
TEST_TIME 35 9295
TEST_TIME 36 9298
TEST_TIME 37 9177
TEST_TIME 38 9323
TEST_TIME 39 9283
TEST_TIME 40 9150
TEST_TIME 41 9283
TEST_TIME 42 9331
TEST_TIME 43 9229
TEST_TIME 44 9244
TEST_TIME 45 9241
TEST_TIME 46 9240
TEST_TIME 47 9297
TEST_TIME 48 9351
TEST_TIME 49 9419
TEST_TIME 50 9392
TEST_TIME 51 9381
TEST_TIME 52 9505
TEST_TIME 53 9521
TEST_TIME 54 9542
TEST_TIME 55 9618
TEST_TIME 56 9643
TEST_TIME 57 9655
TEST_TIME 58 9532
TEST_TIME 59 9483
TEST_TIME 60 9384
TEST_TIME 61 9380
TEST_TIME 62 9422
TEST_TIME 63 9370
TEST_TIME 64 9292
TEST_TIME 65 9241
TEST_TIME 66 9229
TEST_TIME 67 9226
TEST_TIME 68 9343
TEST_TIME 69 9329
TEST_TIME 70 9340
TEST_TIME 71 9386
TEST_TIME 72 9368
TEST_TIME 73 9450
TEST_TIME 74 9411
TEST_TIME 75 9446
TEST_TIME 76 9501
TEST_TIME 77 9521
TEST_TIME 78 9525
TEST_TIME 79 9432
TEST_TIME 80 9401
TEST_TIME 81 9416
TEST_TIME 82 9400
TEST_TIME 83 9330
TEST_TIME 84 9251
TEST_TIME 85 9262
TEST_TIME 86 9257
TEST_TIME 87 9262
TEST_TIME 88 9294
TEST_TIME 89 9282
TEST_TIME 90 9282
TEST_TIME 91 9274
TEST_TIME 92 9326
TEST_TIME 93 9314
TEST_TIME 94 9353
TEST_TIME 95 9323
TEST_TIME 96 9369
TEST_TIME 97 9361
TEST_TIME 98 9280
TEST_TIME 99 9258
TEST_TIME 100 9239

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:03, from 22-02-2024 10:09:42 to 22-02-2024 10:09:45.

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 1312367 1312367 0 0.00 0 24246 8 0 0
doc_list_biud 1312367 1312367 0 0.00 0 25717 24 0 0
sp_add_invoice_to_stock 4528 4403 125 2.76 30 218040 20402 0 125
sp_cancel_adding_invoice 4308 4308 0 0.00 4 61048 845 0 0
sp_cancel_client_order 1591 1591 0 0.00 4 8888 357 0 0
sp_cancel_customer_reserve 423221 423221 0 0.00 0 23512 59 0 0
sp_cancel_pay_from_customer 634 634 0 0.00 3 6381 102 0 0
sp_cancel_pay_to_supplier 390 390 0 0.00 2 14220 130 0 0
sp_cancel_supplier_invoice 4829 4816 13 0.26 1 18143 683 0 13
sp_cancel_supplier_order 373 373 0 0.00 5 951451 83106 0 0
sp_cancel_write_off 7828 7828 0 0.00 1 16635 144 0 0
sp_client_order 18906 18906 0 0.00 3 24380 396 0 0
sp_customer_reserve 424916 424916 0 0.00 0 46169 196 0 0
sp_fill_shopping_cart 28802 28802 0 0.00 1 10065 32 0 0
sp_fill_shopping_cart_clo_res 424911 424911 0 0.00 0 14928 14 0 0
sp_get_clo_for_invoice 4397 4397 0 0.00 0 22706 330 0 0
sp_kill_cost_storno 13160 13160 0 0.00 0 14488 73 0 0
sp_kill_qstorno_ret_qs2qd 859459 859459 0 0.00 0 23507 31 0 0
sp_kill_qty_storno 455812 455812 0 0.00 0 25717 68 0 0
sp_lock_selected_doc 18860 18860 0 0.00 0 8863 9 0 0
sp_make_cost_storno 25414 25414 0 0.00 0 22849 77 0 0
sp_multiply_rows_for_pdistr 25414 25414 0 0.00 0 8759 38 0 0
sp_multiply_rows_for_qdistr 18906 18906 0 0.00 0 13297 185 0 0
sp_pay_from_customer 6401 6401 0 0.00 3 21382 138 0 0
sp_pay_to_supplier 5338 5338 0 0.00 4 21534 173 0 0
sp_payment_common 11739 11739 0 0.00 1 16540 32 0 0
sp_qd_handle_on_cancel_clo 1591 1591 0 0.00 0 8882 337 0 0
sp_qd_handle_on_invoice_upd_sts 8705 8705 0 0.00 0 25717 308 0 0
sp_qd_handle_on_reserve_upd_sts 9278 9278 0 0.00 0 18599 60 0 0
sp_reserve_write_off 9278 9278 0 0.00 6 19682 226 0 0
sp_supplier_invoice 4948 4948 0 0.00 5 89195 3407 0 0
sp_supplier_order 4952 4952 0 0.00 5 86770 1292 0 0
srv_aggregate_perf_data 100 100 0 0.00 1580 147187 12248 0 0
srv_fill_mon_cache_memory 58 58 0 0.00 1178 102796 37488 0 0
srv_find_qd_qs_mism 877712 877712 0 0.00 0 24245 8 0 0
srv_make_invnt_saldo 432 432 0 0.00 41 87086 3436 0 0
srv_make_money_saldo 665 665 0 0.00 0 14871 649 0 0
srv_recalc_idx_stat 3 3 0 0.00 131595 440815 253569 0 0
t$perf-abend:sp_add_invoice_to_stock 125 125 0 0.00 0 0 0 0 0
t$perf-abend:sp_cancel_supplier_invoice 13 13 0 0.00 0 0 0 0 0
t$perf-norm:sp_add_invoice_to_stock 4403 4403 0 0.00 0 5814 164 0 0
t$perf-norm:sp_cancel_adding_invoice 341 341 0 0.00 0 3189 84 0 0
t$perf-norm:sp_cancel_client_order 1591 1591 0 0.00 0 2608 13 0 0
t$perf-norm:sp_cancel_customer_reserve 563 563 0 0.00 0 610 12 0 0
t$perf-norm:sp_cancel_pay_from_customer 634 634 0 0.00 0 562 2 0 0
t$perf-norm:sp_cancel_pay_to_supplier 390 390 0 0.00 0 1144 7 0 0
t$perf-norm:sp_cancel_supplier_invoice 372 372 0 0.00 0 681 12 0 0
t$perf-norm:sp_cancel_supplier_order 373 373 0 0.00 0 19223 1269 0 0
t$perf-norm:sp_cancel_write_off 921 921 0 0.00 0 3880 17 0 0
t$perf-norm:sp_client_order 18906 18906 0 0.00 0 10930 16 0 0
t$perf-norm:sp_customer_reserve 913 913 0 0.00 0 3791 9 0 0
t$perf-norm:sp_pay_from_customer 6401 6401 0 0.00 0 4380 8 0 0
t$perf-norm:sp_pay_to_supplier 5338 5338 0 0.00 0 4119 9 0 0
t$perf-norm:sp_reserve_write_off 9278 9278 0 0.00 0 14692 11 0 0
t$perf-norm:sp_supplier_invoice 4948 4948 0 0.00 0 3760 15 0 0
t$perf-norm:sp_supplier_order 4952 4952 0 0.00 0 4718 17 0 0
t$perf-norm:srv_aggregate_perf_data 100 100 0 0.00 0 589 14 0 0
t$perf-norm:srv_fill_mon_cache_memory 58 58 0 0.00 0 1912 53 0 0
t$perf-norm:srv_make_invnt_saldo 432 432 0 0.00 0 692 7 0 0
t$perf-norm:srv_make_money_saldo 665 665 0 0.00 0 838 8 0 0
t$perf-norm:srv_recalc_idx_stat 3 3 0 0.00 1 3 2 0 0
v_add_invoice_to_stock 9044 8794 250 2.76 0 6309 17 0 250
v_all_customers 35104 35104 0 0.00 0 26 1 0 0
v_all_suppliers 28104 28104 0 0.00 0 20 1 0 0
v_all_wares 37812 37812 0 0.00 0 26 1 0 0
v_cancel_adding_invoice 682 682 0 0.00 0 672 6 0 0
v_cancel_client_order 3182 3182 0 0.00 0 2374 3 0 0
v_cancel_customer_prepayment 1268 1268 0 0.00 0 3703 9 0 0
v_cancel_customer_reserve 1126 1126 0 0.00 0 3962 15 0 0
v_cancel_payment_to_supplier 780 780 0 0.00 0 1504 6 0 0
v_cancel_supplier_invoice 770 744 26 3.37 0 3300 15 0 26
v_cancel_supplier_order 746 746 0 0.00 0 297 2 0 0
v_cancel_write_off 1842 1842 0 0.00 0 7647 20 0 0
v_max_id_clo_ord 4952 4952 0 0.00 0 307 1 0 0
v_max_id_clo_res 913 913 0 0.00 0 1552 11 0 0
v_max_id_ord_sup 4944 4944 0 0.00 0 3735 6 0 0
v_max_non_paid_invoice 1182 1182 0 0.00 0 2648 4 0 0
v_max_non_paid_realizn 3115 3115 0 0.00 0 880 3 0 0
v_min_id_clo_ord 4952 4952 0 0.00 0 2386 6 0 0
v_min_id_clo_res 913 913 0 0.00 0 3325 15 0 0
v_min_id_ord_sup 4944 4944 0 0.00 0 4152 6 0 0
v_min_non_paid_invoice 5338 5338 0 0.00 0 16535 25 0 0
v_min_non_paid_realizn 6401 6401 0 0.00 0 7137 23 0 0
v_our_firm 9280 9280 0 0.00 0 14 1 0 0
v_reserve_write_off 18556 18556 0 0.00 0 3330 6 0 0
x_lock_depdocs_on_canc_invoice 8752 8752 0 0.00 0 11868 105 0 0
x_lock_depdocs_on_canc_sup_ord 373 373 0 0.00 0 19933 372 0 0
x_make_qstorno_1000_1200 4952 4952 0 0.00 1 86613 1225 0 0
x_make_qstorno_1200_2000 4948 4948 0 0.00 2 89096 3282 0 0
x_make_qstorno_2100_3300 424916 424916 0 0.00 0 42202 179 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 22-02-2024 10:09:47 to 22-02-2024 10:09:51.

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
08:07:54 5 8192000000 8799498192 8810975232 5402096 0.065 2 1 2 0 5503696 65824 35776
08:08:55 30952 8192000000 9713893712 10010660864 794318464 8.839 100 92 184 1 824464240 7753376 22392400
08:10:33 21793 8192000000 9768613392 10076946432 836836192 9.268 100 83 164 0 867206640 11220528 19149920
08:11:59 20978 8192000000 9805871680 10123640832 867664752 9.577 100 86 172 0 908324208 21234416 19425040
08:13:21 9474 8192000000 9849023664 10179878912 900612496 9.904 100 77 152 0 964086912 47066624 16407792
08:14:35 9141 8192000000 9898774752 10238767104 941181712 10.305 100 79 158 0 1017654640 59686720 16786208
08:15:53 7701 8192000000 9934037488 10287108096 967086864 10.558 100 77 152 0 1047072560 64752800 15232896
08:17:03 2929 8192000000 9975293856 10337681408 1000566976 10.884 100 77 153 0 1087230384 71386272 15277136
08:18:12 1721 8192000000 9995280832 10360188928 1027303728 11.142 100 85 169 0 1111532704 67184976 17044000
08:19:16 1177 8192000000 10012928816 10383237120 1049682576 11.358 100 82 161 0 1122849088 56978656 16187856
08:20:19 2270 8192000000 10038694096 10410065920 1063962192 11.494 100 82 164 2 1147488336 67359936 16166208
08:21:23 1529 8192000000 10030750528 10413199360 1078758304 11.636 100 71 143 3 1155381856 62391904 14231648
08:22:26 3207 8192000000 10030386336 10430996480 1082056016 11.667 100 56 111 0 1146119456 52709568 11353872
08:23:31 25970 8192000000 9994279616 10389090304 1083336320 11.679 100 54 109 0 1106394992 9925504 13133168
08:24:59 4526 8192000000 10019456720 10422087680 1089539488 11.738 100 30 60 0 1122579104 27350784 5688832
08:26:05 6906 8192000000 10004985888 10407202816 1097297712 11.812 100 26 52 0 1141076448 38131472 5647264
08:27:13 5673 8192000000 9995497264 10400800768 1076514368 11.614 98 25 50 0 1099525424 17748640 5262416
08:28:23 26142 8192000000 10000353776 10401497088 1094053312 11.781 100 33 67 1 1118858384 17665504 7139568
08:29:52 59310 8192000000 10062537776 10475524096 1102238832 11.859 99 56 110 0 1172886016 58651152 11996032
08:31:55 8133 8192000000 10095651360 10499690496 1105225216 11.887 99 51 100 0 1204629984 89379744 10025024
08:33:09 6664 8192000000 10112332352 10522693632 1119336048 12.021 100 43 86 0 1236169216 108215008 8618160
08:34:21 8250 8192000000 10077611328 10483412992 1082123856 11.668 97 42 84 0 1177174112 85466848 9583408
08:35:33 16504 8192000000 10043373472 10469412864 1069803504 11.550 97 42 84 0 1138984976 59604816 9576656
08:36:54 4595 8192000000 10076780240 10479792128 1079514192 11.643 98 51 102 1 1176715552 86116944 11084416
08:38:06 19289 8192000000 10080933632 10487025664 1053072304 11.390 96 43 86 1 1164355472 102008000 9275168
08:39:32 1877 8192000000 10065666912 10458218496 1087846816 11.722 100 61 125 0 1175285024 73293024 14145184
08:40:37 14199 8192000000 10119884208 10528612352 1094087808 11.782 99 46 92 0 1231309808 127452528 9769472
08:42:02 5993 8192000000 10171102752 10578997248 1110243728 11.935 100 51 102 0 1287389360 166174080 10971552
08:43:14 2322 8192000000 10198847552 10585567232 1115822752 11.988 100 79 158 0 1295470224 162213296 17434176
08:44:25 5586 8192000000 10263151152 10656256000 1120866320 12.035 100 69 136 1 1361967184 225908384 15192480
08:45:34 2618 8192000000 10308547056 10705711104 1140182064 12.217 100 83 165 1 1408947776 249568048 19197664
08:46:41 1172 8192000000 10369383872 10761687040 1145450400 12.267 100 91 183 0 1469793472 303745024 20598048
08:47:48 1536 8192000000 10346865168 10763538432 1149808320 12.308 100 84 168 1 1462341200 293074736 19458144
08:48:54 9877 8192000000 10370394576 10797764608 1160837296 12.411 100 51 102 0 1475317728 302932976 11547456
08:50:23 14217 8192000000 10365666720 10852184064 1156826400 12.374 100 38 76 0 1500457696 334245808 9385488
08:51:42 13611 8192000000 10352251216 10813599744 1149465584 12.304 100 23 46 0 1445510736 289834496 6210656
08:53:20 38732 8192000000 10225236736 10751107072 1142966752 12.243 100 13 26 0 1368135792 221754096 3414944
08:55:03 49092 8192000000 10067104832 10516598784 1115670496 11.986 98 13 26 1 1146808720 28672336 2465888
08:56:57 40714 8192000000 10075967872 10508124160 1143465424 12.248 100 34 66 1 1170860032 20794544 6600064
08:58:41 66025 8192000000 10068165632 10534965248 1149099648 12.301 100 16 33 0 1199657488 47018176 3539664
09:00:47 48744 8192000000 10097478704 10538323968 1151746832 12.326 100 33 64 0 1205028608 46615792 6665984
09:02:38 32018 8192000000 10076071744 10527694848 1155251712 12.359 100 19 38 0 1181135040 22313104 3570224
09:04:12 31719 8192000000 10157217984 10597892096 1165696048 12.457 100 44 87 0 1240968864 65660560 9612256
09:05:50 40875 8192000000 10123709424 10595229696 1164995664 12.450 100 10 20 0 1229897904 62487744 2414496
09:07:49 46240 8192000000 10145408560 10625851392 1158965728 12.394 99 14 28 0 1255958816 94144768 2848320
09:09:41 30059 8192000000 10082956560 10571026432 1138491984 12.201 99 12 24 0 1189488832 48341952 2654896
09:11:14 61847 8192000000 10072691520 10565222400 1143521568 12.249 99 13 26 0 1177702320 31002016 3178736
09:13:16 42263 8192000000 10095597344 10540937216 1115811264 11.987 97 22 44 0 1175093072 54858208 4423600
09:15:10 40606 8192000000 10085602656 10557222912 1129706144 12.119 99 13 25 0 1195881712 63482464 2693104
09:16:52 46045 8192000000 10067695504 10498609152 1080194096 11.649 95 31 62 0 1116455632 29143968 7117568
09:18:40 49074 8192000000 10089124624 10551889920 1070232800 11.554 95 25 50 0 1163833328 88547056 5053472
09:20:31 36977 8192000000 10069817360 10520047616 1065138384 11.506 95 42 83 1 1103575408 29557920 8879104
09:22:08 42680 8192000000 10072923504 10559307776 1100578192 11.843 98 15 30 0 1158782160 55175968 3028000
09:23:52 86856 8192000000 10034281728 10511826944 1070855696 11.560 97 8 16 0 1121154816 48758384 1540736
09:26:52 56608 8192000000 10052958128 10482302976 1081969456 11.666 98 26 52 0 1141121248 54108640 5043152
09:29:16 73874 8192000000 10024561664 10488532992 1098860608 11.827 100 18 35 0 1145626208 43061616 3703984
09:31:30 64724 8192000000 10039627664 10500108288 1107316112 11.907 100 14 28 1 1148296768 38074288 2906368
09:33:46 53135 8192000000 10094133168 10526224384 1093843952 11.779 98 33 66 0 1157634176 56822336 6967888
09:36:26 16652 8192000000 10047212208 10481303552 1112688624 11.958 100 38 76 0 1143981200 23478912 7813664
09:37:43 42580 8192000000 10073878560 10525028352 1106870736 11.903 98 28 56 0 1168354720 56145248 5338736
09:39:26 55339 8192000000 10080790384 10544615424 1092617888 11.768 97 16 32 0 1173513264 77506432 3388944
09:41:26 27324 8192000000 10107368384 10543894528 1137461296 12.192 100 38 76 0 1193984240 49016464 7506480
09:42:56 38817 8192000000 10086060832 10570346496 1138259664 12.199 100 28 56 1 1198038000 54380384 5397952
09:44:36 67640 8192000000 10095296816 10559070208 1128725520 12.109 98 45 90 0 1190107008 52533040 8848448
09:46:47 102795 8192000000 10117948352 10613100544 1140773680 12.223 99 26 52 0 1214947152 68674496 5498976
09:50:04 47328 8192000000 10073655280 10528890880 1139177968 12.208 99 21 42 0 1175130096 31055792 4896336
09:51:51 83604 8192000000 10063041056 10534584320 1122690944 12.052 98 8 15 0 1162917920 38691248 1535728
09:54:15 33262 8192000000 10091213104 10530074624 1128552048 12.108 99 27 54 0 1163868064 29385616 5930400
09:55:56 63041 8192000000 10079319264 10526982144 1114203648 11.972 97 18 36 0 1170227536 52131024 3892864
09:57:59 55474 8192000000 10104891104 10561884160 1111965008 11.951 97 26 52 0 1186454224 68953488 5535728
09:59:58 29718 8192000000 10070785536 10500268032 1084993392 11.695 96 29 58 0 1128643024 37457056 6192576
10:01:29 39356 8192000000 10080707312 10525917184 1102232592 11.859 98 28 56 0 1169479344 61804480 5442272
10:03:10 41636 8192000000 10074384128 10527891456 1102068992 11.857 100 50 100 0 1203796528 91818880 9908656
10:04:56 98515 8192000000 10060250624 10499280896 1085718640 11.702 98 30 60 0 1143842496 51800368 6323488
10:07:35 30390 8192000000 9547467200 9945821184 663223632 7.489 60 2 4 0 683030432 19735680 71120

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:14, from 22-02-2024 10:09:53 to 22-02-2024 10:10:07.

Exceptions occured during test was in run

FB_MNEMONA CNT UNIT FB_GDSCODE
except 125 v_add_invoice_to_stock 335544517
except 13 v_cancel_supplier_invoice 335544517

Completed "Exceptions occured during test was in run". Done for 00:00:02, from 22-02-2024 10:10:08 to 22-02-2024 10:10:10.

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          180307
MON$OLDEST_ACTIVE               181105
MON$OLDEST_SNAPSHOT             181105
MON$NEXT_TRANSACTION            181105
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                       1913376
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             715
MON$NEXT_STATEMENT              53
MON$REPLICA_MODE                0


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

Database statistics 

 
Database "/home/bases/oltp40-etalone.fdb" 
Gstat execution time Thu Feb 22 10:10:11 2024 
 
Database header page information: 
    Flags            0 
    Generation        95204 
    System Change Number    0 
    Page size        8192 
    ODS version        13.0 
    Oldest transaction    180307 
    Oldest active        181105 
    Oldest snapshot        181105 
    Next transaction    181106 
    Sequence number        0 
    Next attachment ID    715 
    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.62, total records: 7779827 
    Average version length: 48.15, total versions: 55544, 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: 88984 
    Data pages: 88984, average fill: 70% 
    Primary pages: 88984, secondary pages: 0, swept pages: 41658 
    Empty pages: 4, full pages: 68651 
    Fill distribution: 
     0 - 19% = 6 
    20 - 39% = 13 
    40 - 59% = 738 
    60 - 79% = 88187 
    80 - 99% = 40 
 
    Index DOC_DATA_DOC_WARE_UNQ (0) 
    Root page: 1510636, depth: 3, leaf buckets: 23380, nodes: 7779827 
    Average node length: 18.90, total dup: 0, max dup: 0 
    Average key length: 15.91, compression ratio: 1.70 
    Average prefix length: 14.09, average data length: 12.91 
    Clustering factor: 1703840, ratio: 0.22 
    Fill distribution: 
         0 - 19% = 332 
        20 - 39% = 1837 
        40 - 59% = 4066 
        60 - 79% = 2556 
        80 - 99% = 14589 
 
    Index DOC_DATA_ID_DESC (1) 
    Root page: 1528140, depth: 3, leaf buckets: 13561, nodes: 7779827 
    Average node length: 11.20, total dup: 0, max dup: 0 
    Average key length: 8.21, compression ratio: 1.10 
    Average prefix length: 3.79, average data length: 5.21 
    Clustering factor: 1527315, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 1566 
        40 - 59% = 2041 
        60 - 79% = 1157 
        80 - 99% = 8797 
 
    Index FK_DOC_DATA_DOC_LIST (2) 
    Root page: 1546735, depth: 3, leaf buckets: 8372, nodes: 7779827 
    Average node length: 6.62, total dup: 5812084, max dup: 49 
    Average key length: 3.63, compression ratio: 2.48 
    Average prefix length: 7.62, average data length: 1.38 
    Clustering factor: 1520125, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 116 
        20 - 39% = 983 
        40 - 59% = 1379 
        60 - 79% = 939 
        80 - 99% = 4955 
 
DOC_LIST (138) 
    Primary pointer page: 500, Index root page: 501 
    Total formats: 1, used formats: 1 
    Average record length: 56.86, total records: 2259456 
    Average version length: 58.81, total versions: 27875, max versions: 2 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 84.00, compression ratio: 1.48 
    Pointer pages: 18, data page slots: 28696 
    Data pages: 28696, average fill: 72% 
    Primary pages: 28696, secondary pages: 0, swept pages: 12899 
    Empty pages: 25, full pages: 18855 
    Fill distribution: 
     0 - 19% = 29 
    20 - 39% = 7 
    40 - 59% = 172 
    60 - 79% = 28440 
    80 - 99% = 48 
 
    Index DOC_LIST_ID_DESC (1) 
    Root page: 1541152, depth: 3, leaf buckets: 4591, nodes: 2259456 
    Average node length: 11.40, total dup: 0, max dup: 0 
    Average key length: 8.44, compression ratio: 1.07 
    Average prefix length: 3.56, average data length: 5.44 
    Clustering factor: 688214, ratio: 0.30 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 965 
        40 - 59% = 831 
        60 - 79% = 738 
        80 - 99% = 2057 
 
    Index DOC_LIST_WORKER_OPTYPE (2) 
    Root page: 1544398, depth: 3, leaf buckets: 2435, nodes: 2260696 
    Average node length: 4.97, total dup: 2259797, max dup: 18328 
    Average key length: 2.01, compression ratio: 4.48 
    Average prefix length: 8.99, average data length: 0.01 
    Clustering factor: 1279446, ratio: 0.57 
    Fill distribution: 
         0 - 19% = 4 
        20 - 39% = 205 
        40 - 59% = 1391 
        60 - 79% = 588 
        80 - 99% = 247 
 
    Index FK_DOC_LIST_AGENTS (3) 
    Root page: 1545933, depth: 3, leaf buckets: 1794, nodes: 2259456 
    Average node length: 4.97, total dup: 2259406, max dup: 130431 
    Average key length: 2.01, compression ratio: 4.48 
    Average prefix length: 8.99, average data length: 0.01 
    Clustering factor: 1069734, ratio: 0.47 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 6 
        40 - 59% = 657 
        60 - 79% = 44 
        80 - 99% = 1087 
 
    Index PK_DOC_LIST (0) 
    Root page: 1538209, depth: 3, leaf buckets: 4413, nodes: 2259456 
    Average node length: 11.40, total dup: 0, max dup: 0 
    Average key length: 8.44, compression ratio: 1.07 
    Average prefix length: 3.56, average data length: 5.44 
    Clustering factor: 688214, ratio: 0.30 
    Fill distribution: 
         0 - 19% = 110 
        20 - 39% = 622 
        40 - 59% = 653 
        60 - 79% = 831 
        80 - 99% = 2197 
 
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.24, total records: 400 
    Average version length: 24.12, total versions: 3255, max versions: 9 
    Average fragment length: 2.00, total fragments: 9, max fragments: 1 
    Average unpacked length: 104.00, compression ratio: 1.25 
    Pointer pages: 1, data page slots: 32 
    Data pages: 32, average fill: 67% 
    Primary pages: 7, secondary pages: 25, swept pages: 0 
    Empty pages: 5, full pages: 23 
    Fill distribution: 
     0 - 19% = 8 
    20 - 39% = 1 
    40 - 59% = 0 
    60 - 79% = 0 
    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: 23.51, total records: 156494 
    Average version length: 68.27, total versions: 118191, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 88.00, compression ratio: 3.74 
    Pointer pages: 7, data page slots: 3200 
    Data pages: 2280, average fill: 88% 
    Primary pages: 2279, secondary pages: 1, swept pages: 2 
    Empty pages: 2, full pages: 2232 
    Fill distribution: 
     0 - 19% = 2 
    20 - 39% = 6 
    40 - 59% = 12 
    60 - 79% = 473 
    80 - 99% = 1787 
 
    Index INVNT_TURNOVER_LOG_WARE_DD_ID (0) 
    Root page: 1706274, depth: 3, leaf buckets: 398, nodes: 156494 
    Average node length: 13.31, total dup: 9564, max dup: 2 
    Average key length: 10.72, compression ratio: 2.52 
    Average prefix length: 19.22, average data length: 7.78 
    Clustering factor: 121143, ratio: 0.77 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 0 
        40 - 59% = 145 
        60 - 79% = 216 
        80 - 99% = 37 
 
MONEY_SALDO (141) 
    Primary pointer page: 506, Index root page: 507 
    Total formats: 1, used formats: 1 
    Average record length: 15.14, total records: 49 
    Average version length: 9.00, total versions: 240, max versions: 7 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 32.00, compression ratio: 2.11 
    Pointer pages: 1, data page slots: 6 
    Data pages: 6, average fill: 16% 
    Primary pages: 1, secondary pages: 5, swept pages: 0 
    Empty pages: 0, full pages: 1 
    Fill distribution: 
     0 - 19% = 5 
    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: 15.82, total records: 2711 
    Average version length: 43.07, total versions: 2181, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 58.00, compression ratio: 3.67 
    Pointer pages: 1, data page slots: 32 
    Data pages: 32, average fill: 85% 
    Primary pages: 31, secondary pages: 1, swept pages: 0 
    Empty pages: 0, full pages: 28 
    Fill distribution: 
     0 - 19% = 2 
    20 - 39% = 0 
    40 - 59% = 1 
    60 - 79% = 5 
    80 - 99% = 24 
 
    Index MONEY_TURNOVER_LOG_AGENT_OPTYPE (0) 
    Root page: 91594, depth: 2, leaf buckets: 4, nodes: 2711 
    Average node length: 4.13, total dup: 2613, max dup: 297 
    Average key length: 2.39, compression ratio: 7.95 
    Average prefix length: 18.65, average data length: 0.35 
    Clustering factor: 1420, ratio: 0.52 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 2 
        40 - 59% = 0 
        60 - 79% = 1 
        80 - 99% = 0 
 
MON_CACHE_MEMORY (165) 
    Primary pointer page: 555, Index root page: 556 
    Total formats: 2, used formats: 1 
    Average record length: 97.59, total records: 75 
    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: 53% 
    Primary pages: 2, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 1 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 1 
    40 - 59% = 0 
    60 - 79% = 1 
    80 - 99% = 0 
 
    Index PK_MON_CACHE_MEMORY (0) 
    Root page: 1504238, depth: 1, leaf buckets: 1, nodes: 75 
    Average node length: 11.68, total dup: 0, max dup: 0 
    Average key length: 10.67, compression ratio: 0.84 
    Average prefix length: 1.32, average data length: 7.68 
    Clustering factor: 2, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
MON_LOG (162) 
    Primary pointer page: 548, Index root page: 549 
    Total formats: 2, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index MON_LOG_DTS (4) 
    Root page: 1504251, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index MON_LOG_GDSCODE (2) 
    Root page: 1504249, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index MON_LOG_ROWSET_DESC (1) 
    Root page: 1504248, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index MON_LOG_UNIT (3) 
    Root page: 1504250, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PK_MON_LOG (0) 
    Root page: 1504247, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
MON_LOG_TABLE_STATS (163) 
    Primary pointer page: 550, Index root page: 551 
    Total formats: 2, used formats: 1 
    Average record length: 67.13, total records: 30 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 611.00, compression ratio: 9.10 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 31% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 1 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index MON_LOG_TABLE_STATS_DTS (4) 
    Root page: 1504246, depth: 1, leaf buckets: 1, nodes: 30 
    Average node length: 3.50, total dup: 23, max dup: 4 
    Average key length: 2.47, compression ratio: 3.24 
    Average prefix length: 7.53, average data length: 0.47 
    Clustering factor: 1, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index MON_LOG_TABLE_STATS_GDSCODE (2) 
    Root page: 1504244, depth: 1, leaf buckets: 1, nodes: 30 
    Average node length: 2.00, total dup: 29, max dup: 29 
    Average key length: 1.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 1, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index MON_LOG_TABLE_STATS_ROWSET (1) 
    Root page: 1504243, depth: 1, leaf buckets: 1, nodes: 30 
    Average node length: 3.33, total dup: 29, max dup: 29 
    Average key length: 2.30, compression ratio: 3.91 
    Average prefix length: 8.70, average data length: 0.30 
    Clustering factor: 1, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index MON_LOG_TABLE_STATS_TN_UNIT (3) 
    Root page: 1504245, depth: 1, leaf buckets: 1, nodes: 30 
    Average node length: 12.90, total dup: 0, max dup: 0 
    Average key length: 11.87, compression ratio: 1.42 
    Average prefix length: 7.63, average data length: 9.20 
    Clustering factor: 1, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PK_MON_LOG_TABLE_STATS (0) 
    Root page: 1504242, depth: 1, leaf buckets: 1, nodes: 30 
    Average node length: 8.37, total dup: 0, max dup: 0 
    Average key length: 7.33, compression ratio: 1.23 
    Average prefix length: 4.63, average data length: 4.37 
    Clustering factor: 1, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
OPTYPES (136) 
    Primary pointer page: 496, Index root page: 497 
    Total formats: 2, used formats: 1 
    Average record length: 67.56, total records: 9 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 386.00, compression ratio: 5.71 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 9% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index OPTYPES_MCODE_UNQ (1) 
    Root page: 1544827, depth: 1, leaf buckets: 1, nodes: 9 
    Average node length: 8.56, total dup: 0, max dup: 0 
    Average key length: 6.89, compression ratio: 0.73 
    Average prefix length: 0.44, average data length: 4.56 
    Clustering factor: 1, ratio: 0.11 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PK_OPTYPES (0) 
    Root page: 1544826, depth: 1, leaf buckets: 1, nodes: 9 
    Average node length: 6.11, total dup: 0, max dup: 0 
    Average key length: 5.00, compression ratio: 0.60 
    Average prefix length: 0.89, average data length: 2.11 
    Clustering factor: 1, ratio: 0.11 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
PDISTR (146) 
    Primary pointer page: 516, Index root page: 517 
    Total formats: 1, used formats: 1 
    Average record length: 35.99, total records: 781205 
    Average version length: 37.96, total versions: 38468, max versions: 3 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 54.00, compression ratio: 1.50 
    Pointer pages: 6, data page slots: 8384 
    Data pages: 8384, average fill: 64% 
    Primary pages: 8381, secondary pages: 3, swept pages: 2664 
    Empty pages: 68, full pages: 4725 
    Fill distribution: 
     0 - 19% = 121 
    20 - 39% = 87 
    40 - 59% = 659 
    60 - 79% = 7417 
    80 - 99% = 100 
 
    Index PDISTR_AGENT_ID (2) 
    Root page: 1509330, depth: 2, leaf buckets: 832, nodes: 768792 
    Average node length: 4.87, total dup: 768743, max dup: 139138 
    Average key length: 2.01, compression ratio: 4.48 
    Average prefix length: 8.99, average data length: 0.01 
    Clustering factor: 89091, ratio: 0.12 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 127 
        40 - 59% = 431 
        60 - 79% = 179 
        80 - 99% = 93 
 
    Index PDISTR_SNDOP_RCVOP_SNDID_ASC (0) 
    Root page: 1508635, depth: 3, leaf buckets: 960, nodes: 768792 
    Average node length: 5.88, total dup: 684600, max dup: 42 
    Average key length: 3.02, compression ratio: 7.29 
    Average prefix length: 21.09, average data length: 0.91 
    Clustering factor: 155328, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 93 
        40 - 59% = 522 
        60 - 79% = 126 
        80 - 99% = 218 
 
    Index PDISTR_SNDOP_RCVOP_SNDID_DESC (1) 
    Root page: 1509209, depth: 3, leaf buckets: 999, nodes: 768792 
    Average node length: 5.88, total dup: 684600, max dup: 42 
    Average key length: 3.02, compression ratio: 7.29 
    Average prefix length: 21.09, average data length: 0.91 
    Clustering factor: 157323, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 147 
        40 - 59% = 525 
        60 - 79% = 131 
        80 - 99% = 195 
 
    Index PDISTR_WORKER_SND_ID (3) 
    Root page: 1510200, depth: 3, leaf buckets: 1117, nodes: 768792 
    Average node length: 5.96, total dup: 684600, max dup: 42 
    Average key length: 3.10, compression ratio: 5.48 
    Average prefix length: 16.01, average data length: 0.99 
    Clustering factor: 150421, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 287 
        40 - 59% = 569 
        60 - 79% = 171 
        80 - 99% = 90 
 
PERF_AGG (158) 
    Primary pointer page: 540, Index root page: 541 
    Total formats: 1, used formats: 1 
    Average record length: 62.75, total records: 5492 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 2.87, total fragments: 38, max fragments: 1 
    Average unpacked length: 379.00, compression ratio: 6.04 
    Pointer pages: 1, data page slots: 96 
    Data pages: 95, average fill: 57% 
    Primary pages: 75, secondary pages: 20, swept pages: 62 
    Empty pages: 10, full pages: 68 
    Fill distribution: 
     0 - 19% = 20 
    20 - 39% = 0 
    40 - 59% = 4 
    60 - 79% = 71 
    80 - 99% = 0 
 
    Index PERF_AGG_UNQ (1) 
    Root page: 1504260, depth: 2, leaf buckets: 6, nodes: 5492 
    Average node length: 5.52, total dup: 0, max dup: 0 
    Average key length: 3.58, compression ratio: 10.07 
    Average prefix length: 34.51, average data length: 1.54 
    Clustering factor: 5223, ratio: 0.95 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 0 
        40 - 59% = 4 
        60 - 79% = 0 
        80 - 99% = 2 
 
    Index PK_PERF_AGG (0) 
    Root page: 1504255, depth: 2, leaf buckets: 10, nodes: 5492 
    Average node length: 11.15, 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: 167, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 2 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 7 
 
PERF_ESTIMATED (280) 
    Primary pointer page: 399, Index root page: 434 
    Total formats: 1, used formats: 1 
    Average record length: 39.07, total records: 82617 
    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: 864 
    Data pages: 864, average fill: 66% 
    Primary pages: 864, secondary pages: 0, swept pages: 0 
    Empty pages: 5, full pages: 858 
    Fill distribution: 
     0 - 19% = 6 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 858 
    80 - 99% = 0 
 
    Index PK_PERF_ESTIMATED (0) 
    Root page: 35153, depth: 2, leaf buckets: 107, nodes: 82617 
    Average node length: 10.15, total dup: 0, max dup: 0 
    Average key length: 8.16, compression ratio: 1.10 
    Average prefix length: 3.84, average data length: 5.16 
    Clustering factor: 3161, ratio: 0.04 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 4 
        60 - 79% = 0 
        80 - 99% = 102 
 
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.17, 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.21 
    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: 135.55, total records: 168806 
    Average version length: 152.97, total versions: 18394, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 12.51 
    Pointer pages: 6, data page slots: 4632 
    Data pages: 4224, average fill: 84% 
    Primary pages: 4222, secondary pages: 2, swept pages: 3 
    Empty pages: 66, full pages: 4141 
    Fill distribution: 
     0 - 19% = 69 
    20 - 39% = 8 
    40 - 59% = 1 
    60 - 79% = 7 
    80 - 99% = 4139 
 
PERF_SPLIT_1 (282) 
    Primary pointer page: 603, Index root page: 604 
    Total formats: 1, used formats: 1 
    Average record length: 118.23, total records: 181639 
    Average version length: 154.11, total versions: 41948, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 14.35 
    Pointer pages: 6, data page slots: 5464 
    Data pages: 4584, average fill: 85% 
    Primary pages: 4581, secondary pages: 3, swept pages: 6 
    Empty pages: 90, full pages: 4457 
    Fill distribution: 
     0 - 19% = 91 
    20 - 39% = 16 
    40 - 59% = 7 
    60 - 79% = 16 
    80 - 99% = 4454 
 
PERF_SPLIT_2 (283) 
    Primary pointer page: 605, Index root page: 606 
    Total formats: 1, used formats: 1 
    Average record length: 125.29, total records: 197563 
    Average version length: 153.76, total versions: 35742, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 13.54 
    Pointer pages: 6, data page slots: 5560 
    Data pages: 4968, average fill: 84% 
    Primary pages: 4965, secondary pages: 3, swept pages: 1 
    Empty pages: 97, full pages: 4849 
    Fill distribution: 
     0 - 19% = 97 
    20 - 39% = 9 
    40 - 59% = 8 
    60 - 79% = 3 
    80 - 99% = 4851 
 
PERF_SPLIT_3 (284) 
    Primary pointer page: 607, Index root page: 608 
    Total formats: 1, used formats: 1 
    Average record length: 130.63, total records: 187865 
    Average version length: 153.76, total versions: 27143, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 12.98 
    Pointer pages: 6, data page slots: 5640 
    Data pages: 4704, average fill: 84% 
    Primary pages: 4702, secondary pages: 2, swept pages: 2 
    Empty pages: 69, full pages: 4610 
    Fill distribution: 
     0 - 19% = 73 
    20 - 39% = 8 
    40 - 59% = 5 
    60 - 79% = 7 
    80 - 99% = 4611 
 
PERF_SPLIT_4 (285) 
    Primary pointer page: 609, Index root page: 610 
    Total formats: 1, used formats: 1 
    Average record length: 127.65, total records: 196712 
    Average version length: 154.14, total versions: 32678, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 13.29 
    Pointer pages: 7, data page slots: 6032 
    Data pages: 4944, average fill: 84% 
    Primary pages: 4941, secondary pages: 3, swept pages: 1 
    Empty pages: 83, full pages: 4830 
    Fill distribution: 
     0 - 19% = 85 
    20 - 39% = 8 
    40 - 59% = 6 
    60 - 79% = 15 
    80 - 99% = 4830 
 
PERF_SPLIT_5 (286) 
    Primary pointer page: 611, Index root page: 612 
    Total formats: 1, used formats: 1 
    Average record length: 123.63, total records: 193828 
    Average version length: 153.78, total versions: 37598, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 13.72 
    Pointer pages: 7, data page slots: 5296 
    Data pages: 4808, average fill: 86% 
    Primary pages: 4805, secondary pages: 3, swept pages: 2 
    Empty pages: 27, full pages: 4766 
    Fill distribution: 
     0 - 19% = 29 
    20 - 39% = 1 
    40 - 59% = 7 
    60 - 79% = 5 
    80 - 99% = 4766 
 
PERF_SPLIT_6 (287) 
    Primary pointer page: 613, Index root page: 614 
    Total formats: 1, used formats: 1 
    Average record length: 141.00, total records: 158758 
    Average version length: 152.91, total versions: 11077, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 12.03 
    Pointer pages: 7, data page slots: 5008 
    Data pages: 4032, average fill: 82% 
    Primary pages: 4031, secondary pages: 1, swept pages: 1 
    Empty pages: 124, full pages: 3886 
    Fill distribution: 
     0 - 19% = 124 
    20 - 39% = 10 
    40 - 59% = 3 
    60 - 79% = 8 
    80 - 99% = 3887 
 
PERF_SPLIT_7 (288) 
    Primary pointer page: 615, Index root page: 616 
    Total formats: 1, used formats: 1 
    Average record length: 132.45, total records: 175024 
    Average version length: 153.31, total versions: 22791, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 12.80 
    Pointer pages: 6, data page slots: 5384 
    Data pages: 4376, average fill: 84% 
    Primary pages: 4373, secondary pages: 3, swept pages: 1 
    Empty pages: 63, full pages: 4287 
    Fill distribution: 
     0 - 19% = 66 
    20 - 39% = 8 
    40 - 59% = 4 
    60 - 79% = 11 
    80 - 99% = 4287 
 
PERF_SPLIT_8 (289) 
    Primary pointer page: 617, Index root page: 618 
    Total formats: 1, used formats: 1 
    Average record length: 137.10, total records: 195040 
    Average version length: 153.39, total versions: 19805, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 12.37 
    Pointer pages: 7, data page slots: 6504 
    Data pages: 4912, average fill: 83% 
    Primary pages: 4908, secondary pages: 4, swept pages: 6 
    Empty pages: 90, full pages: 4790 
    Fill distribution: 
     0 - 19% = 93 
    20 - 39% = 10 
    40 - 59% = 8 
    60 - 79% = 11 
    80 - 99% = 4790 
 
PERF_SPLIT_9 (290) 
    Primary pointer page: 619, Index root page: 620 
    Total formats: 1, used formats: 1 
    Average record length: 141.90, total records: 163214 
    Average version length: 152.48, total versions: 10572, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.95 
    Pointer pages: 8, data page slots: 6832 
    Data pages: 4144, average fill: 82% 
    Primary pages: 4142, secondary pages: 2, swept pages: 1 
    Empty pages: 113, full pages: 3991 
    Fill distribution: 
     0 - 19% = 115 
    20 - 39% = 16 
    40 - 59% = 11 
    60 - 79% = 11 
    80 - 99% = 3991 
 
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.28, total records: 2128700 
    Average version length: 52.97, total versions: 22930, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 70.00, compression ratio: 1.34 
    Pointer pages: 16, data page slots: 25720 
    Data pages: 25720, average fill: 71% 
    Primary pages: 25712, secondary pages: 8, swept pages: 10515 
    Empty pages: 56, full pages: 23619 
    Fill distribution: 
     0 - 19% = 123 
    20 - 39% = 127 
    40 - 59% = 458 
    60 - 79% = 24783 
    80 - 99% = 229 
 
    Index PSTORNED_RCV_ID (1) 
    Root page: 1506208, depth: 3, leaf buckets: 2607, nodes: 2128700 
    Average node length: 5.44, total dup: 1987539, max dup: 1396 
    Average key length: 2.48, compression ratio: 3.62 
    Average prefix length: 8.58, average data length: 0.42 
    Clustering factor: 184499, ratio: 0.09 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 289 
        40 - 59% = 1709 
        60 - 79% = 306 
        80 - 99% = 301 
 
    Index PSTORNED_SND_ID (0) 
    Root page: 1504841, depth: 3, leaf buckets: 2763, nodes: 2128700 
    Average node length: 5.69, total dup: 1910832, max dup: 65 
    Average key length: 2.74, compression ratio: 3.29 
    Average prefix length: 8.36, average data length: 0.64 
    Clustering factor: 380900, ratio: 0.18 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 3 
        40 - 59% = 2340 
        60 - 79% = 393 
        80 - 99% = 26 
 
    Index PSTORNED_WORKER_ID (2) 
    Root page: 1508018, depth: 3, leaf buckets: 2151, nodes: 2128700 
    Average node length: 4.96, total dup: 2128600, max dup: 27890 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.42, average data length: 0.00 
    Clustering factor: 182134, ratio: 0.09 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 176 
        40 - 59% = 1134 
        60 - 79% = 427 
        80 - 99% = 412 
 
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: 43.28, total records: 155279 
    Average version length: 69.17, total versions: 66889, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 2.91 
    Pointer pages: 3, data page slots: 4384 
    Data pages: 3016, average fill: 62% 
    Primary pages: 3015, secondary pages: 1, swept pages: 240 
    Empty pages: 270, full pages: 1432 
    Fill distribution: 
     0 - 19% = 337 
    20 - 39% = 129 
    40 - 59% = 513 
    60 - 79% = 1269 
    80 - 99% = 768 
 
    Index XQD_1000_1200_WA_SO_RO_WKR_SND (0) 
    Root page: 103565, depth: 3, leaf buckets: 227, nodes: 155279 
    Average node length: 6.51, total dup: 135277, max dup: 14 
    Average key length: 3.92, compression ratio: 10.71 
    Average prefix length: 40.21, average data length: 1.79 
    Clustering factor: 26543, ratio: 0.17 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 24 
        40 - 59% = 117 
        60 - 79% = 69 
        80 - 99% = 17 
 
XQD_1000_3300 (178) 
    Primary pointer page: 581, Index root page: 582 
    Total formats: 1, used formats: 1 
    Average record length: 66.14, total records: 6864445 
    Average version length: 68.79, total versions: 323287, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.91 
    Pointer pages: 64, data page slots: 104136 
    Data pages: 104136, average fill: 71% 
    Primary pages: 104136, secondary pages: 0, swept pages: 34099 
    Empty pages: 16, full pages: 60735 
    Fill distribution: 
     0 - 19% = 100 
    20 - 39% = 1029 
    40 - 59% = 7156 
    60 - 79% = 94999 
    80 - 99% = 852 
 
    Index XQD_1000_3300_WA_SO_RO_WKR_SND (0) 
    Root page: 1480476, depth: 3, leaf buckets: 10604, nodes: 6864445 
    Average node length: 6.51, total dup: 5937802, max dup: 29 
    Average key length: 3.52, compression ratio: 11.93 
    Average prefix length: 40.61, average data length: 1.39 
    Clustering factor: 1616535, ratio: 0.24 
    Fill distribution: 
         0 - 19% = 6 
        20 - 39% = 1877 
        40 - 59% = 5847 
        60 - 79% = 2450 
        80 - 99% = 424 
 
    Index XQD_1000_3300_WKR_DOC_ASC (1) 
    Root page: 1486090, depth: 3, leaf buckets: 8439, nodes: 6864445 
    Average node length: 5.40, total dup: 6586682, max dup: 156 
    Average key length: 2.41, compression ratio: 7.05 
    Average prefix length: 16.63, average data length: 0.37 
    Clustering factor: 1426174, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 8 
        20 - 39% = 1252 
        40 - 59% = 4804 
        60 - 79% = 1421 
        80 - 99% = 954 
 
    Index XQD_1000_3300_WKR_DOC_DEC (2) 
    Root page: 1490630, depth: 3, leaf buckets: 8482, nodes: 6864445 
    Average node length: 5.40, total dup: 6586682, max dup: 156 
    Average key length: 2.41, compression ratio: 7.04 
    Average prefix length: 16.63, average data length: 0.37 
    Clustering factor: 1428707, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 6 
        20 - 39% = 1333 
        40 - 59% = 4769 
        60 - 79% = 1403 
        80 - 99% = 971 
 
XQD_1200_2000 (177) 
    Primary pointer page: 579, Index root page: 580 
    Total formats: 1, used formats: 1 
    Average record length: 67.62, total records: 11877709 
    Average version length: 68.79, total versions: 263043, 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: 106, data page slots: 172856 
    Data pages: 172856, average fill: 73% 
    Primary pages: 172855, secondary pages: 1, swept pages: 80380 
    Empty pages: 8, full pages: 139605 
    Fill distribution: 
     0 - 19% = 17 
    20 - 39% = 346 
    40 - 59% = 4834 
    60 - 79% = 165946 
    80 - 99% = 1713 
 
    Index XQD_1200_2000_WA_SO_RO_WKR_SND (0) 
    Root page: 1495050, depth: 3, leaf buckets: 18424, nodes: 11875884 
    Average node length: 6.60, total dup: 10355216, max dup: 66 
    Average key length: 3.42, compression ratio: 12.27 
    Average prefix length: 40.70, average data length: 1.30 
    Clustering factor: 2459608, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 27 
        20 - 39% = 2501 
        40 - 59% = 11062 
        60 - 79% = 4133 
        80 - 99% = 701 
 
XQD_2000_3300 (179) 
    Primary pointer page: 583, Index root page: 584 
    Total formats: 1, used formats: 1 
    Average record length: 49.71, total records: 1480269 
    Average version length: 69.12, total versions: 312753, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 2.53 
    Pointer pages: 27, data page slots: 42552 
    Data pages: 27720, average fill: 56% 
    Primary pages: 27621, secondary pages: 99, swept pages: 8632 
    Empty pages: 2992, full pages: 16777 
    Fill distribution: 
     0 - 19% = 4451 
    20 - 39% = 3568 
    40 - 59% = 2909 
    60 - 79% = 12625 
    80 - 99% = 4167 
 
    Index XQD_2000_3300_WA_SO_RO_WKR_SND (0) 
    Root page: 1479735, depth: 3, leaf buckets: 1855, nodes: 1314344 
    Average node length: 5.53, total dup: 1261313, max dup: 99 
    Average key length: 2.57, compression ratio: 16.34 
    Average prefix length: 41.47, average data length: 0.53 
    Clustering factor: 93025, ratio: 0.07 
    Fill distribution: 
         0 - 19% = 11 
        20 - 39% = 512 
        40 - 59% = 917 
        60 - 79% = 373 
        80 - 99% = 42 
 
XQD_2100_3300 (180) 
    Primary pointer page: 585, Index root page: 586 
    Total formats: 1, used formats: 1 
    Average record length: 42.89, total records: 1080663 
    Average version length: 69.03, total versions: 146093, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 2.94 
    Pointer pages: 22, data page slots: 35136 
    Data pages: 27968, average fill: 35% 
    Primary pages: 27966, secondary pages: 2, swept pages: 9126 
    Empty pages: 6285, full pages: 5353 
    Fill distribution: 
     0 - 19% = 9653 
    20 - 39% = 4495 
    40 - 59% = 7252 
    60 - 79% = 6363 
    80 - 99% = 205 
 
    Index XQD_2100_3300_WA_SO_RO_WKR_SND (0) 
    Root page: 1479229, depth: 3, leaf buckets: 1149, nodes: 756243 
    Average node length: 5.96, total dup: 695693, max dup: 81 
    Average key length: 3.03, compression ratio: 13.87 
    Average prefix length: 41.05, average data length: 0.95 
    Clustering factor: 107454, ratio: 0.14 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 334 
        40 - 59% = 545 
        60 - 79% = 247 
        80 - 99% = 22 
 
XQD_3300_3400 (181) 
    Primary pointer page: 587, Index root page: 588 
    Total formats: 1, used formats: 1 
    Average record length: 66.91, total records: 9264087 
    Average version length: 68.97, total versions: 302975, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.88 
    Pointer pages: 89, data page slots: 143944 
    Data pages: 143912, average fill: 69% 
    Primary pages: 143893, secondary pages: 19, swept pages: 57723 
    Empty pages: 232, full pages: 83163 
    Fill distribution: 
     0 - 19% = 886 
    20 - 39% = 5140 
    40 - 59% = 15551 
    60 - 79% = 120510 
    80 - 99% = 1825 
 
    Index XQD_3300_3400_WA_SO_RO_WKR_SND (0) 
    Root page: 1472612, depth: 3, leaf buckets: 13460, nodes: 9260603 
    Average node length: 6.68, total dup: 7682320, max dup: 14 
    Average key length: 3.67, compression ratio: 11.46 
    Average prefix length: 40.50, average data length: 1.50 
    Clustering factor: 2148877, ratio: 0.23 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 1292 
        40 - 59% = 6646 
        60 - 79% = 4801 
        80 - 99% = 721 
 
XQS_1000_1200 (182) 
    Primary pointer page: 589, Index root page: 590 
    Total formats: 1, used formats: 1 
    Average record length: 82.50, total records: 21187712 
    Average version length: 82.97, total versions: 10288, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.53 
    Pointer pages: 197, data page slots: 320440 
    Data pages: 320440, average fill: 81% 
    Primary pages: 320437, secondary pages: 3, swept pages: 13499 
    Empty pages: 33, full pages: 319563 
    Fill distribution: 
     0 - 19% = 62 
    20 - 39% = 48 
    40 - 59% = 94 
    60 - 79% = 49867 
    80 - 99% = 270369 
 
    Index XQS_1000_1200_DOC_ID (1) 
    Root page: 1426738, depth: 3, leaf buckets: 19502, nodes: 21187712 
    Average node length: 5.72, total dup: 20705827, max dup: 134 
    Average key length: 2.16, compression ratio: 4.16 
    Average prefix length: 8.86, average data length: 0.14 
    Clustering factor: 3290774, ratio: 0.16 
    Fill distribution: 
         0 - 19% = 5 
        20 - 39% = 1 
        40 - 59% = 8295 
        60 - 79% = 581 
        80 - 99% = 10620 
 
    Index XQS_1000_1200_RCV_ID (3) 
    Root page: 1457002, depth: 3, leaf buckets: 17236, nodes: 21187712 
    Average node length: 6.31, total dup: 18618892, max dup: 49 
    Average key length: 2.75, compression ratio: 3.27 
    Average prefix length: 8.37, average data length: 0.63 
    Clustering factor: 920880, ratio: 0.04 
    Fill distribution: 
         0 - 19% = 3 
        20 - 39% = 3 
        40 - 59% = 817 
        60 - 79% = 304 
        80 - 99% = 16109 
 
    Index XQS_1000_1200_SND_ID (2) 
    Root page: 1441095, depth: 3, leaf buckets: 21304, nodes: 21187712 
    Average node length: 6.35, total dup: 18538512, max dup: 29 
    Average key length: 2.79, compression ratio: 3.23 
    Average prefix length: 8.34, average data length: 0.66 
    Clustering factor: 3585368, ratio: 0.17 
    Fill distribution: 
         0 - 19% = 4 
        20 - 39% = 0 
        40 - 59% = 8613 
        60 - 79% = 618 
        80 - 99% = 12069 
 
    Index XQS_1000_1200_WORKER_ID (0) 
    Root page: 1413370, depth: 3, leaf buckets: 16157, nodes: 21187712 
    Average node length: 5.56, total dup: 21187612, max dup: 230362 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.42, average data length: 0.00 
    Clustering factor: 949668, ratio: 0.04 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 10 
        40 - 59% = 2963 
        60 - 79% = 366 
        80 - 99% = 12817 
 
XQS_1000_3300 (184) 
    Primary pointer page: 593, Index root page: 594 
    Total formats: 1, used formats: 1 
    Average record length: 80.05, total records: 9730982 
    Average version length: 82.63, total versions: 314145, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.57 
    Pointer pages: 105, data page slots: 171032 
    Data pages: 171016, average fill: 70% 
    Primary pages: 170985, secondary pages: 31, swept pages: 76264 
    Empty pages: 477, full pages: 108791 
    Fill distribution: 
     0 - 19% = 1509 
    20 - 39% = 6886 
    40 - 59% = 21130 
    60 - 79% = 121905 
    80 - 99% = 19586 
 
    Index XQS_1000_3300_DOC_ID (1) 
    Root page: 1367524, depth: 3, leaf buckets: 11352, nodes: 9730982 
    Average node length: 5.36, total dup: 9420817, max dup: 173 
    Average key length: 2.23, compression ratio: 4.03 
    Average prefix length: 8.80, average data length: 0.20 
    Clustering factor: 2258907, ratio: 0.23 
    Fill distribution: 
         0 - 19% = 3 
        20 - 39% = 57 
        40 - 59% = 8113 
        60 - 79% = 3077 
        80 - 99% = 102 
 
    Index XQS_1000_3300_RCV_ID (3) 
    Root page: 1379283, depth: 3, leaf buckets: 13563, nodes: 9730982 
    Average node length: 6.23, total dup: 8067366, max dup: 14 
    Average key length: 3.10, compression ratio: 2.90 
    Average prefix length: 8.07, average data length: 0.93 
    Clustering factor: 1607743, ratio: 0.17 
    Fill distribution: 
         0 - 19% = 128 
        20 - 39% = 3948 
        40 - 59% = 4330 
        60 - 79% = 2753 
        80 - 99% = 2404 
 
    Index XQS_1000_3300_SND_ID (2) 
    Root page: 1373081, depth: 3, leaf buckets: 12675, nodes: 9730982 
    Average node length: 5.98, total dup: 8441314, max dup: 42 
    Average key length: 2.85, compression ratio: 3.16 
    Average prefix length: 8.28, average data length: 0.72 
    Clustering factor: 2445055, ratio: 0.25 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 70 
        40 - 59% = 9083 
        60 - 79% = 3411 
        80 - 99% = 110 
 
    Index XQS_1000_3300_WORKER_ID (0) 
    Root page: 1362789, depth: 3, leaf buckets: 10193, nodes: 9730982 
    Average node length: 5.13, total dup: 9730882, max dup: 152623 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.42, average data length: 0.00 
    Clustering factor: 1629170, ratio: 0.17 
    Fill distribution: 
         0 - 19% = 43 
        20 - 39% = 1264 
        40 - 59% = 5025 
        60 - 79% = 1800 
        80 - 99% = 2061 
 
XQS_1200_2000 (183) 
    Primary pointer page: 591, Index root page: 592 
    Total formats: 1, used formats: 1 
    Average record length: 80.85, total records: 11370910 
    Average version length: 82.66, total versions: 225033, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.56 
    Pointer pages: 119, data page slots: 193680 
    Data pages: 192072, average fill: 73% 
    Primary pages: 191955, secondary pages: 117, swept pages: 63863 
    Empty pages: 2811, full pages: 152101 
    Fill distribution: 
     0 - 19% = 4554 
    20 - 39% = 6465 
    40 - 59% = 15481 
    60 - 79% = 101705 
    80 - 99% = 63867 
 
    Index XQS_1200_2000_DOC_ID (1) 
    Root page: 1392123, depth: 3, leaf buckets: 13104, nodes: 11370910 
    Average node length: 5.30, total dup: 11260957, max dup: 634 
    Average key length: 2.08, compression ratio: 4.33 
    Average prefix length: 8.93, average data length: 0.07 
    Clustering factor: 2392692, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 154 
        40 - 59% = 8817 
        60 - 79% = 3990 
        80 - 99% = 142 
 
    Index XQS_1200_2000_RCV_ID (3) 
    Root page: 1406132, depth: 3, leaf buckets: 10483, nodes: 11370910 
    Average node length: 5.49, total dup: 10875626, max dup: 49 
    Average key length: 2.28, compression ratio: 3.95 
    Average prefix length: 8.77, average data length: 0.23 
    Clustering factor: 739198, ratio: 0.07 
    Fill distribution: 
         0 - 19% = 164 
        20 - 39% = 853 
        40 - 59% = 2560 
        60 - 79% = 1851 
        80 - 99% = 5055 
 
    Index XQS_1200_2000_SND_ID (2) 
    Root page: 1398660, depth: 3, leaf buckets: 14991, nodes: 11370910 
    Average node length: 6.02, total dup: 9922456, max dup: 67 
    Average key length: 2.81, compression ratio: 3.21 
    Average prefix length: 8.32, average data length: 0.68 
    Clustering factor: 2409082, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 4 
        20 - 39% = 175 
        40 - 59% = 10329 
        60 - 79% = 4322 
        80 - 99% = 161 
 
    Index XQS_1200_2000_WORKER_ID (0) 
    Root page: 1386233, depth: 3, leaf buckets: 10955, nodes: 11370910 
    Average node length: 5.22, total dup: 11370810, max dup: 186793 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.43, average data length: 0.00 
    Clustering factor: 726937, ratio: 0.06 
    Fill distribution: 
         0 - 19% = 97 
        20 - 39% = 864 
        40 - 59% = 4973 
        60 - 79% = 1587 
        80 - 99% = 3434 
 
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: 80.37, total records: 9851202 
    Average version length: 82.92, total versions: 317066, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.57 
    Pointer pages: 107, data page slots: 174608 
    Data pages: 174592, average fill: 70% 
    Primary pages: 174562, secondary pages: 30, swept pages: 79636 
    Empty pages: 530, full pages: 109174 
    Fill distribution: 
     0 - 19% = 1685 
    20 - 39% = 7384 
    40 - 59% = 23372 
    60 - 79% = 122682 
    80 - 99% = 19469 
 
    Index XQS_2100_3300_DOC_ID (1) 
    Root page: 1344708, depth: 3, leaf buckets: 11903, nodes: 9851202 
    Average node length: 5.17, total dup: 9822329, max dup: 2436 
    Average key length: 2.03, compression ratio: 4.43 
    Average prefix length: 8.97, average data length: 0.03 
    Clustering factor: 2061773, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 41 
        20 - 39% = 1515 
        40 - 59% = 7896 
        60 - 79% = 1828 
        80 - 99% = 623 
 
    Index XQS_2100_3300_RCV_ID (3) 
    Root page: 1355739, depth: 3, leaf buckets: 13696, nodes: 9851202 
    Average node length: 6.24, total dup: 8166672, max dup: 14 
    Average key length: 3.10, compression ratio: 2.90 
    Average prefix length: 8.07, average data length: 0.93 
    Clustering factor: 1573487, ratio: 0.16 
    Fill distribution: 
         0 - 19% = 182 
        20 - 39% = 3938 
        40 - 59% = 4286 
        60 - 79% = 2743 
        80 - 99% = 2547 
 
    Index XQS_2100_3300_SND_ID (2) 
    Root page: 1350071, depth: 3, leaf buckets: 12516, nodes: 9851202 
    Average node length: 5.43, total dup: 9410147, max dup: 99 
    Average key length: 2.29, compression ratio: 3.94 
    Average prefix length: 8.76, average data length: 0.24 
    Clustering factor: 2195417, ratio: 0.22 
    Fill distribution: 
         0 - 19% = 35 
        20 - 39% = 1407 
        40 - 59% = 8797 
        60 - 79% = 1687 
        80 - 99% = 590 
 
    Index XQS_2100_3300_WORKER_ID (0) 
    Root page: 987843, depth: 3, leaf buckets: 10407, nodes: 9851202 
    Average node length: 5.14, total dup: 9851102, max dup: 154157 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.42, average data length: 0.00 
    Clustering factor: 1645585, ratio: 0.17 
    Fill distribution: 
         0 - 19% = 39 
        20 - 39% = 1300 
        40 - 59% = 5250 
        60 - 79% = 1788 
        80 - 99% = 2030 
 
XQS_3300_3400 (187) 
    Primary pointer page: 599, Index root page: 600 
    Total formats: 1, used formats: 1 
    Average record length: 67.80, total records: 580249 
    Average version length: 68.86, total versions: 3741, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.86 
    Pointer pages: 5, data page slots: 8088 
    Data pages: 8088, average fill: 75% 
    Primary pages: 8088, secondary pages: 0, swept pages: 3423 
    Empty pages: 3, full pages: 7360 
    Fill distribution: 
     0 - 19% = 4 
    20 - 39% = 4 
    40 - 59% = 70 
    60 - 79% = 7966 
    80 - 99% = 44 
 
    Index XQS_3300_3400_DOC_ID (1) 
    Root page: 43945, depth: 3, leaf buckets: 743, nodes: 580249 
    Average node length: 5.95, total dup: 494157, max dup: 83 
    Average key length: 3.09, compression ratio: 2.91 
    Average prefix length: 8.06, average data length: 0.94 
    Clustering factor: 102341, ratio: 0.18 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 35 
        40 - 59% = 513 
        60 - 79% = 106 
        80 - 99% = 89 
 
    Index XQS_3300_3400_SND_ID (2) 
    Root page: 28377, depth: 3, leaf buckets: 770, nodes: 580249 
    Average node length: 6.15, total dup: 475974, max dup: 17 
    Average key length: 3.29, compression ratio: 2.73 
    Average prefix length: 7.89, average data length: 1.11 
    Clustering factor: 102392, ratio: 0.18 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 27 
        40 - 59% = 553 
        60 - 79% = 95 
        80 - 99% = 95 
 
    Index XQS_3300_3400_WORKER_ID (0) 
    Root page: 377587, depth: 2, leaf buckets: 563, nodes: 580249 
    Average node length: 4.86, total dup: 580149, max dup: 9884 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.41, average data length: 0.00 
    Clustering factor: 90968, ratio: 0.16 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 28 
        40 - 59% = 327 
        60 - 79% = 71 
        80 - 99% = 137 
 
ZDOC_DATA (170) 
    Primary pointer page: 565, Index root page: 566 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
ZDOC_LIST (169) 
    Primary pointer page: 563, Index root page: 564 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
ZINVNT_TURNOVER_LOG (171) 
    Primary pointer page: 567, Index root page: 568 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
ZPDISTR (174) 
    Primary pointer page: 573, Index root page: 574 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index ZPDISTR_ID (0) 
    Root page: 1504230, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
ZPSTORNED (175) 
    Primary pointer page: 575, Index root page: 576 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index ZPSTORNED_ID (0) 
    Root page: 1504229, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
ZQDISTR (172) 
    Primary pointer page: 569, Index root page: 570 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index ZQDISTR_ID (0) 
    Root page: 1504235, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index ZQDISTR_WARE_SNDOP_RCVOP (1) 
    Root page: 1504236, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
ZQSTORNED (173) 
    Primary pointer page: 571, Index root page: 572 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index ZQSTORNED_DOC_ID (1) 
    Root page: 1504232, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index ZQSTORNED_ID (0) 
    Root page: 1504231, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index ZQSTORNED_RCV_ID (3) 
    Root page: 1504234, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index ZQSTORNED_SND_ID (2) 
    Root page: 1504233, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
ZTMP_DEP_DOCS (168) 
    Primary pointer page: 561, Index root page: 562 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
ZTMP_SHOPPING_CART (167) 
    Primary pointer page: 559, Index root page: 560 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
Z_USED_VIEWS (144) 
    Primary pointer page: 512, Index root page: 513 
    Total formats: 1, used formats: 1 
    Average record length: 29.38, total records: 29 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 99.00, compression ratio: 3.37 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 16% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index Z_USED_VIEWS_UNQ (0) 
    Root page: 1510372, depth: 1, leaf buckets: 1, nodes: 29 
    Average node length: 15.17, total dup: 0, max dup: 0 
    Average key length: 14.14, compression ratio: 1.44 
    Average prefix length: 9.17, average data length: 11.17 
    Clustering factor: 1, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
Gstat completion time Thu Feb 22 10:10:34 2024

Record versions statistics, table

TABLE_NAME TOTAL_RECS TOTAL_VERS MAX_VERSIONS VERS_TO_RECS_PRC MAXV_TO_VERS_PRC
DOC_DATA 7779827 55544 1 0.0000 0.0000
DOC_LIST 2259456 27875 2 0.0000 0.0000
FB_ERRORS 2182 757 1 0.0000 0.0000
INVNT_SALDO 400 3255 9 800.0000 0.0000
INVNT_TURNOVER_LOG 156494 118191 1 0.0000 0.0000
MONEY_SALDO 49 240 7 400.0000 0.0000
MONEY_TURNOVER_LOG 2711 2181 1 0.0000 0.0000
PDISTR 781205 38468 3 0.0000 0.0000
PERF_SPLIT_0 168806 18394 1 0.0000 0.0000
PERF_SPLIT_1 181639 41948 1 0.0000 0.0000
PERF_SPLIT_2 197563 35742 1 0.0000 0.0000
PERF_SPLIT_3 187865 27143 1 0.0000 0.0000
PERF_SPLIT_4 196712 32678 1 0.0000 0.0000
PERF_SPLIT_5 193828 37598 1 0.0000 0.0000
PERF_SPLIT_6 158758 11077 1 0.0000 0.0000
PERF_SPLIT_7 175024 22791 1 0.0000 0.0000
PERF_SPLIT_8 195040 19805 1 0.0000 0.0000
PERF_SPLIT_9 163214 10572 1 0.0000 0.0000
PSTORNED 2128700 22930 1 0.0000 0.0000
SEMAPHORES 5 1 1 0.0000 100.0000
XQD_1000_1200 155279 66889 1 0.0000 0.0000
XQD_1000_3300 6864445 323287 1 0.0000 0.0000
XQD_1200_2000 11877709 263043 1 0.0000 0.0000
XQD_2000_3300 1480269 312753 1 0.0000 0.0000
XQD_2100_3300 1080663 146093 1 0.0000 0.0000
XQD_3300_3400 9264087 302975 1 0.0000 0.0000
XQS_1000_1200 21187712 10288 1 0.0000 0.0000
XQS_1000_3300 9730982 314145 1 0.0000 0.0000
XQS_1200_2000 11370910 225033 1 0.0000 0.0000
XQS_2100_3300 9851202 317066 1 0.0000 0.0000
XQS_3300_3400 580249 3741 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'  

22.02.24 10:10:46. 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-02-22 10:10:49 No severe PSQL-related problems occured
22.02.24 10:10:50. End of report.