Generated by /opt/oltp-emul/oltp_isql_run_worker.sh, ISQL session No. 1 of total launched 100. 01.04.2024 07:16
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 15695356 kB
MemAvailable 30199204 kB
Buffers 0 kB
Cached 16035152 kB
SwapCached 2484 kB
Command: fdisk -l
WARNING: fdisk GPT support is currently new, and therefore in an experimental phase. Use at your own discretion.
Disk /dev/sda: 599.9 GB, 599932581888 bytes, 1171743324 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 262144 bytes / 524288 bytes
Disk label type: gpt
Disk identifier: 919DACA4-2F35-4CBB-BAA7-2A8CD8F7168C
# Start End Size Type Name
1 2048 411647 200M EFI System EFI System Partition
2 411648 2508799 1G Microsoft basic
3 2508800 1171742719 557.5G Linux LVM
Disk /dev/mapper/centos_mscs--test--161-root: 53.7 GB, 53687091200 bytes, 104857600 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 262144 bytes / 524288 bytes
Disk /dev/mapper/centos_mscs--test--161-swap: 16.8 GB, 16844324864 bytes, 32899072 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 262144 bytes / 524288 bytes
Disk /dev/sdb: 536 MB, 536870912 bytes, 1048576 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 512 bytes / 512 bytes
Disk label type: dos
Disk identifier: 0x00000046
Device Boot Start End Blocks Id System
/dev/sdb1 63 514079 257008+ c W95 FAT32 (LBA)
Disk /dev/mapper/centos_mscs--test--161-home: 528.1 GB, 528109010944 bytes, 1031462912 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 262144 bytes / 524288 bytes

Server and database settinfs 


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

Test configuration settings 

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

Test finish info 


FINISH_STATE                    NORMAL: TEST_TIME EXPIRED AT 2024-04-01 07:15:11
DTS_END                         2024-04-01 07:15:11.7990
FB_GDSCODE                      -1
FB_MNEMONA                      
STACK                           SP_ADD_INVOICE_TO_STOCK(190:30) ==> SP_CUSTOMER_RESERVE(47:5) ==> SP_CHECK_TO_STOP_WORK(32:12) ==> SP_HALT_ON_ERROR(68:17)
IP                              ::1/34702
TRN_ID                          176111
ATT_ID                          538
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: 9061.60 18657 906160
customer order: creation 184.27 404 18427
customer order: refuse 16.27 358 1627
order to supplier: creation 49.30 1333 4930
order to supplier: removal 3.55 83405 355
invoice (draft): creation 47.75 3403 4775
invoice (draft): removal 47.74 738 4774
invoice accept: apply 43.88 19898 4388
invoice accept: cancel 42.50 742 4250
customer reserve: creation 4220.25 190 422025
customer reserve: removal 4110.89 57 411089
realization accept: apply 88.74 178 8874
realization accept: cancel 70.89 136 7089
payment from customer: creation 61.98 118 6198
payment from customer: removal 6.00 80 600
payment to supplier: creation 51.98 152 5198
payment to supplier: removal 3.54 80 354
service: total inventory turnovers 4.34 3453 434
service: total monetary turnovers 6.82 440 682
service: aggregate perf. data 0.88 18785 88
service: refresh index statistics 0.03 239190 3

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:02, from 01-04-2024 07:16:30 to 01-04-2024 07:16:32.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 5076
TEST_TIME 2 5156
TEST_TIME 3 5026
TEST_TIME 4 5289
TEST_TIME 5 5408
TEST_TIME 6 5556
TEST_TIME 7 6011
TEST_TIME 8 6322
TEST_TIME 9 6325
TEST_TIME 10 6568
TEST_TIME 11 6999
TEST_TIME 12 6732
TEST_TIME 13 6666
TEST_TIME 14 6793
TEST_TIME 15 6874
TEST_TIME 16 7720
TEST_TIME 17 7645
TEST_TIME 18 8099
TEST_TIME 19 8109
TEST_TIME 20 8817
TEST_TIME 21 8706
TEST_TIME 22 8860
TEST_TIME 23 9833
TEST_TIME 24 9665
TEST_TIME 25 9567
TEST_TIME 26 9537
TEST_TIME 27 9466
TEST_TIME 28 9142
TEST_TIME 29 9280
TEST_TIME 30 9088
TEST_TIME 31 8960
TEST_TIME 32 8972
TEST_TIME 33 9211
TEST_TIME 34 9071
TEST_TIME 35 9022
TEST_TIME 36 8926
TEST_TIME 37 8862
TEST_TIME 38 8754
TEST_TIME 39 8709
TEST_TIME 40 8740
TEST_TIME 41 8738
TEST_TIME 42 8758
TEST_TIME 43 8905
TEST_TIME 44 8823
TEST_TIME 45 8891
TEST_TIME 46 9031
TEST_TIME 47 9035
TEST_TIME 48 9097
TEST_TIME 49 9157
TEST_TIME 50 9156
TEST_TIME 51 9259
TEST_TIME 52 9305
TEST_TIME 53 9366
TEST_TIME 54 9229
TEST_TIME 55 9142
TEST_TIME 56 9112
TEST_TIME 57 9119
TEST_TIME 58 9036
TEST_TIME 59 8951
TEST_TIME 60 8971
TEST_TIME 61 8962
TEST_TIME 62 9009
TEST_TIME 63 8989
TEST_TIME 64 9003
TEST_TIME 65 9026
TEST_TIME 66 9233
TEST_TIME 67 9183
TEST_TIME 68 9201
TEST_TIME 69 9237
TEST_TIME 70 9298
TEST_TIME 71 9347
TEST_TIME 72 9362
TEST_TIME 73 9299
TEST_TIME 74 9243
TEST_TIME 75 9208
TEST_TIME 76 9156
TEST_TIME 77 9159
TEST_TIME 78 9224
TEST_TIME 79 9179
TEST_TIME 80 9169
TEST_TIME 81 9198
TEST_TIME 82 9229
TEST_TIME 83 9261
TEST_TIME 84 9228
TEST_TIME 85 9266
TEST_TIME 86 9269
TEST_TIME 87 9324
TEST_TIME 88 9323
TEST_TIME 89 9338
TEST_TIME 90 9358
TEST_TIME 91 9274
TEST_TIME 92 9208
TEST_TIME 93 9213
TEST_TIME 94 9157
TEST_TIME 95 9088
TEST_TIME 96 9099
TEST_TIME 97 9130
TEST_TIME 98 9132
TEST_TIME 99 9151
TEST_TIME 100 9072

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:03, from 01-04-2024 07:16:34 to 01-04-2024 07:16:37.

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 1291130 1291130 0 0.00 0 17205 7 0 0
doc_list_biud 1291130 1291130 0 0.00 0 91842 24 0 0
sp_add_invoice_to_stock 4525 4388 137 3.02 37 182799 19899 0 137
sp_cancel_adding_invoice 4250 4250 0 0.00 4 48649 743 0 0
sp_cancel_client_order 1627 1627 0 0.00 4 11015 358 0 0
sp_cancel_customer_reserve 411089 411089 0 0.00 0 56725 58 0 0
sp_cancel_pay_from_customer 600 600 0 0.00 3 10927 81 0 0
sp_cancel_pay_to_supplier 354 354 0 0.00 3 5117 80 0 0
sp_cancel_supplier_invoice 4792 4774 18 0.37 1 91846 738 0 18
sp_cancel_supplier_order 355 355 0 0.00 4 681616 83405 0 0
sp_cancel_write_off 7089 7089 0 0.00 1 15394 136 0 0
sp_client_order 18427 18427 0 0.00 3 34698 405 0 0
sp_customer_reserve 422025 422025 0 0.00 0 87355 191 0 0
sp_fill_shopping_cart 28121 28121 0 0.00 1 16156 40 0 0
sp_fill_shopping_cart_clo_res 422024 422024 0 0.00 0 22204 18 0 0
sp_get_clo_for_invoice 4379 4379 0 0.00 0 29528 442 0 0
sp_kill_cost_storno 12293 12293 0 0.00 0 12014 61 0 0
sp_kill_qstorno_ret_qs2qd 834396 834396 0 0.00 0 91840 32 0 0
sp_kill_qty_storno 442436 442436 0 0.00 0 91841 68 0 0
sp_lock_selected_doc 18477 18477 0 0.00 0 8579 7 0 0
sp_make_cost_storno 24648 24648 0 0.00 0 11442 59 0 0
sp_multiply_rows_for_pdistr 24648 24648 0 0.00 0 11382 32 0 0
sp_multiply_rows_for_qdistr 18427 18427 0 0.00 0 34362 228 0 0
sp_pay_from_customer 6198 6198 0 0.00 3 14271 119 0 0
sp_pay_to_supplier 5198 5198 0 0.00 4 18949 153 0 0
sp_payment_common 11396 11396 0 0.00 1 18806 23 0 0
sp_qd_handle_on_cancel_clo 1627 1627 0 0.00 0 11008 326 0 0
sp_qd_handle_on_invoice_upd_sts 8628 8628 0 0.00 0 29161 282 0 0
sp_qd_handle_on_reserve_upd_sts 8874 8874 0 0.00 0 16294 60 0 0
sp_reserve_write_off 8874 8874 0 0.00 6 16720 178 0 0
sp_supplier_invoice 4775 4775 0 0.00 6 76506 3404 0 0
sp_supplier_order 4930 4930 0 0.00 4 52244 1334 0 0
srv_aggregate_perf_data 88 88 0 0.00 1530 631332 18785 0 0
srv_fill_mon_cache_memory 54 54 0 0.00 1721 176626 44302 0 0
srv_find_qd_qs_mism 860614 860614 0 0.00 0 10763 6 0 0
srv_make_invnt_saldo 434 434 0 0.00 81 106234 3454 0 0
srv_make_money_saldo 682 682 0 0.00 1 12340 441 0 0
srv_recalc_idx_stat 3 3 0 0.00 161601 301770 239190 0 0
t$perf-abend:sp_add_invoice_to_stock 137 137 0 0.00 0 0 0 0 0
t$perf-abend:sp_cancel_supplier_invoice 18 18 0 0.00 0 0 0 0 0
t$perf-norm:sp_add_invoice_to_stock 4388 4388 0 0.00 0 9788 129 0 0
t$perf-norm:sp_cancel_adding_invoice 362 362 0 0.00 0 4070 69 0 0
t$perf-norm:sp_cancel_client_order 1627 1627 0 0.00 0 1811 9 0 0
t$perf-norm:sp_cancel_customer_reserve 641 641 0 0.00 0 8188 27 0 0
t$perf-norm:sp_cancel_pay_from_customer 600 600 0 0.00 0 3124 7 0 0
t$perf-norm:sp_cancel_pay_to_supplier 354 354 0 0.00 0 82 1 0 0
t$perf-norm:sp_cancel_supplier_invoice 346 346 0 0.00 0 1328 15 0 0
t$perf-norm:sp_cancel_supplier_order 355 355 0 0.00 0 25484 1401 0 0
t$perf-norm:sp_cancel_write_off 940 940 0 0.00 0 365 3 0 0
t$perf-norm:sp_client_order 18427 18427 0 0.00 0 6499 11 0 0
t$perf-norm:sp_customer_reserve 899 899 0 0.00 0 1353 6 0 0
t$perf-norm:sp_pay_from_customer 6198 6198 0 0.00 0 3847 7 0 0
t$perf-norm:sp_pay_to_supplier 5198 5198 0 0.00 0 6642 9 0 0
t$perf-norm:sp_reserve_write_off 8874 8874 0 0.00 0 2832 7 0 0
t$perf-norm:sp_supplier_invoice 4775 4775 0 0.00 0 3895 12 0 0
t$perf-norm:sp_supplier_order 4930 4930 0 0.00 0 5184 10 0 0
t$perf-norm:srv_aggregate_perf_data 88 88 0 0.00 0 147 3 0 0
t$perf-norm:srv_fill_mon_cache_memory 54 54 0 0.00 0 725 27 0 0
t$perf-norm:srv_make_invnt_saldo 434 434 0 0.00 0 237 3 0 0
t$perf-norm:srv_make_money_saldo 682 682 0 0.00 0 7687 20 0 0
t$perf-norm:srv_recalc_idx_stat 3 3 0 0.00 1 17 6 0 0
v_add_invoice_to_stock 9030 8756 274 3.03 0 15889 18 0 274
v_all_customers 33982 33982 0 0.00 0 77 0 0 0
v_all_suppliers 27478 27478 0 0.00 0 21 1 0 0
v_all_wares 36850 36850 0 0.00 0 29 1 0 0
v_cancel_adding_invoice 724 724 0 0.00 0 291 6 0 0
v_cancel_client_order 3254 3254 0 0.00 0 3119 4 0 0
v_cancel_customer_prepayment 1200 1200 0 0.00 0 10890 15 0 0
v_cancel_customer_reserve 1282 1282 0 0.00 0 156 2 0 0
v_cancel_payment_to_supplier 708 708 0 0.00 0 3484 8 0 0
v_cancel_supplier_invoice 728 692 36 4.94 0 3389 19 0 36
v_cancel_supplier_order 710 710 0 0.00 0 449 4 0 0
v_cancel_write_off 1880 1880 0 0.00 0 6946 21 0 0
v_max_id_clo_ord 4930 4930 0 0.00 0 1980 2 0 0
v_max_id_clo_res 899 899 0 0.00 0 2297 10 0 0
v_max_id_ord_sup 4766 4766 0 0.00 0 6949 8 0 0
v_max_non_paid_invoice 1155 1155 0 0.00 0 190 2 0 0
v_max_non_paid_realizn 3048 3048 0 0.00 0 5176 5 0 0
v_min_id_clo_ord 4930 4930 0 0.00 0 6267 14 0 0
v_min_id_clo_res 899 899 0 0.00 0 5451 28 0 0
v_min_id_ord_sup 4766 4766 0 0.00 0 4401 6 0 0
v_min_non_paid_invoice 5198 5198 0 0.00 0 11390 19 0 0
v_min_non_paid_realizn 6198 6198 0 0.00 0 9129 15 0 0
v_our_firm 9168 9168 0 0.00 0 16 1 0 0
v_reserve_write_off 17748 17748 0 0.00 0 10891 6 0 0
x_lock_depdocs_on_canc_invoice 8678 8678 0 0.00 0 12680 99 0 0
x_lock_depdocs_on_canc_sup_ord 355 355 0 0.00 0 8269 306 0 0
x_make_qstorno_1000_1200 4930 4930 0 0.00 1 52236 1257 0 0
x_make_qstorno_1200_2000 4775 4775 0 0.00 3 75891 3244 0 0
x_make_qstorno_2100_3300 422025 422025 0 0.00 0 87354 171 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 01-04-2024 07:16:38 to 01-04-2024 07:16:42.

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
05:15:15 14 8192000000 8801731008 8814190592 6888944 0.084 3 1 2 0 6994896 70176 35776
05:16:17 28576 8192000000 9711807216 10006818816 784449904 8.738 100 93 186 0 814590528 8044096 22096528
05:17:51 24919 8192000000 9743914816 10050048000 817058512 9.069 100 84 168 0 847783696 11186944 19538240
05:19:29 14492 8192000000 9785659040 10102153216 855199152 9.452 100 81 162 0 890407840 16767920 18440768
05:20:56 13861 8192000000 9851797728 10185359360 901728880 9.915 100 80 160 0 957562992 38265264 17568848
05:22:12 6136 8192000000 9903765664 10247950336 943870064 10.331 100 77 153 0 1009858288 51111632 14876592
05:23:19 6703 8192000000 9943567840 10294038528 969420304 10.581 100 85 168 0 1059834336 74134240 16279792
05:24:27 3328 8192000000 9974336528 10337660928 1000217328 10.881 100 77 152 0 1090118304 75549056 14351920
05:25:32 2147 8192000000 9999150736 10364608512 1021774656 11.089 100 91 182 1 1113076896 73606416 17695824
05:26:38 1094 8192000000 10012027440 10384789504 1043220128 11.296 100 84 168 0 1124859904 65632480 16007296
05:27:41 24619 8192000000 10003821312 10385731584 1054295952 11.402 100 59 115 0 1108375296 43115040 10964304
05:29:06 6504 8192000000 10005639696 10406211584 1063303712 11.488 100 36 73 0 1128040656 57882976 6853968
05:30:13 48837 8192000000 10002038032 10398695424 1071926336 11.570 100 52 104 1 1110425808 27014496 11484976
05:32:09 4736 8192000000 9999446464 10395947008 1074391104 11.594 100 36 70 0 1109987680 28463936 7132640
05:33:14 4591 8192000000 10000776800 10398937088 1079049936 11.638 100 42 84 3 1113792432 25728720 9013776
05:34:20 5621 8192000000 9993710864 10390298624 1081033968 11.657 100 37 72 0 1109728176 20912800 7781408
05:35:26 67007 8192000000 10005692560 10410643456 1089294784 11.736 100 40 80 0 1120416832 22541408 8580640
05:37:39 8453 8192000000 10076201632 10472075264 1087430160 11.718 98 55 110 0 1166212784 67937440 10845184
05:38:50 10882 8192000000 10095778464 10492383232 1098380800 11.822 100 57 113 1 1209403264 99980704 11041760
05:40:05 11203 8192000000 10097973632 10498654208 1099199488 11.830 99 46 91 1 1198604960 90275792 9129680
05:41:20 22666 8192000000 10134837168 10544095232 1096887584 11.808 98 48 96 0 1225838736 119119360 9831792
05:42:47 17489 8192000000 10119807328 10535645184 1092946416 11.771 98 36 72 0 1208606128 107941120 7718592
05:44:08 33794 8192000000 10125710592 10543972352 1082802960 11.674 98 43 86 1 1228453408 136188928 9461520
05:46:07 12423 8192000000 10149878816 10556792832 1115366128 11.983 100 47 94 0 1257657312 132433456 9857728
05:47:27 5041 8192000000 10143807312 10539376640 1107219328 11.906 100 60 120 1 1244510784 125360368 11931088
05:48:35 11541 8192000000 10225044160 10624528384 1115408976 11.984 100 58 116 1 1335105408 207672656 12023776
05:49:49 1719 8192000000 10226726800 10614980608 1106947200 11.904 100 75 147 0 1326228000 203177104 16103696
05:50:58 2346 8192000000 10259943536 10655985664 1113231936 11.963 100 76 152 0 1364917296 235040864 16644496
05:52:06 12634 8192000000 10193508720 10616205312 1098837008 11.827 98 27 54 0 1297893680 192921744 6134928
05:53:22 17831 8192000000 10285472992 10698964992 1131460304 12.135 100 55 108 0 1397601760 253600512 12540944
05:54:44 9915 8192000000 10319046160 10744115200 1130106992 12.122 100 39 78 1 1412027872 273027568 8893312
05:56:08 63527 8192000000 10221894608 10651148288 1113790848 11.968 99 35 67 0 1309409904 188005168 7613888
05:58:14 21095 8192000000 10079809056 10586607616 1108830400 11.921 100 22 44 0 1215974064 102462848 4680816
05:59:45 13459 8192000000 10050125264 10470907904 1086709376 11.711 98 50 98 0 1138448704 41820368 9918960
06:01:04 84726 8192000000 10073411888 10527191040 1112160560 11.953 99 34 66 0 1166790352 47939856 6689936
06:03:31 141880 8192000000 10080410016 10520530944 1113296256 11.964 99 17 34 0 1193490064 76556000 3637808
06:06:58 30200 8192000000 10104947184 10565697536 1135656016 12.175 100 22 44 0 1225561232 85332832 4572384
06:08:30 33109 8192000000 10070879344 10587136000 1138192928 12.199 100 21 42 0 1188282736 45675056 4414752
06:10:05 73091 8192000000 10071796080 10564018176 1148029344 12.291 100 20 40 0 1199424528 47317632 4077552
06:12:28 47740 8192000000 10074768688 10533711872 1150316896 12.312 100 24 48 0 1200098400 44974608 4806896
06:14:26 48622 8192000000 10073241360 10532118528 1153883136 12.346 100 18 34 0 1176743648 19793968 3066544
06:16:19 13515 8192000000 10083242800 10521968640 1161699744 12.419 100 36 71 0 1176962928 7820528 7442656
06:17:33 40108 8192000000 10109888000 10568495104 1137143280 12.189 98 38 75 0 1183163024 38648336 7371408
06:19:20 13431 8192000000 10097165728 10520924160 1116407408 11.993 96 43 85 1 1163062976 38470048 8185520
06:20:41 29500 8192000000 10128231840 10605273088 1131826112 12.139 98 33 66 0 1213592992 75161088 6605792
06:22:15 39276 8192000000 10090708928 10523799552 1121643776 12.043 98 16 32 1 1156013136 31305024 3064336
06:23:55 68552 8192000000 10053542384 10486120448 1067423712 11.527 95 19 38 0 1124577696 53325824 3828160
06:26:04 62027 8192000000 10062313776 10518102016 1036264656 11.229 92 31 62 0 1095000880 52817248 5918976
06:28:08 37027 8192000000 10035142976 10484490240 1065300176 11.507 98 34 65 0 1112003504 40383712 6319616
06:29:46 75112 8192000000 10020888672 10447499264 1079278208 11.641 99 39 78 0 1111743056 24677568 7787280
06:32:02 23139 8192000000 10032657264 10451402752 1078101424 11.629 99 48 90 0 1128153712 41450576 8601712
06:33:36 133028 8192000000 9984971936 10429583360 1041918016 11.283 96 10 20 0 1079321872 35394464 2009392
06:36:50 47154 8192000000 10042566208 10487894016 1073023392 11.581 98 30 60 0 1142652016 62988928 6639696
06:38:38 14930 8192000000 10094892592 10511704064 1106859600 11.903 100 36 72 0 1179737072 65360112 7517360
06:39:54 38612 8192000000 10134909120 10555125760 1106221792 11.897 100 35 70 0 1225392896 111754256 7416848
06:41:58 50208 8192000000 10065366768 10484629504 1102094176 11.858 100 24 47 0 1155679776 48908240 4677360
06:43:54 22360 8192000000 10063463696 10496167936 1102204528 11.859 99 46 92 0 1147124416 35765840 9154048
06:45:19 45641 8192000000 10071571312 10517319680 1104800160 11.883 99 19 38 0 1163046544 54527056 3719328
06:47:07 76125 8192000000 10080423408 10540589056 1127860112 12.101 100 22 43 1 1193269328 60688640 4720576
06:49:52 43607 8192000000 10093201696 10535211008 1117910304 12.007 99 42 83 0 1175203296 49513056 7779936
06:51:40 65943 8192000000 10124404240 10624167936 1137079120 12.188 100 13 26 0 1225784064 85976752 2728192
06:53:46 65640 8192000000 10091787968 10512588800 1123001072 12.055 98 44 87 0 1162782416 30789968 8991376
06:55:55 58504 8192000000 10087934544 10525876224 1146489600 12.277 100 10 20 0 1191936352 43684384 1762368
06:57:54 88067 8192000000 10072571120 10540400640 1125903728 12.083 98 8 16 0 1184862368 57374512 1584128
07:00:29 70292 8192000000 10103056240 10556825600 1136498736 12.183 99 14 28 0 1179371056 40112960 2759360
07:02:58 42766 8192000000 10088502944 10525786112 1132583968 12.146 99 14 28 0 1159648400 24524128 2540304
07:04:46 50536 8192000000 10062681056 10517467136 1083072496 11.677 96 18 36 0 1159974656 73331760 3570400
07:06:40 176626 8192000000 10059990032 10513940480 1053660480 11.396 93 15 30 0 1084955568 28419968 2875120
07:12:26 49906 8192000000 10032680848 10474143744 1065063600 11.505 96 16 32 1 1117358592 49098208 3196784
07:14:28 48229 8192000000 9555369920 9947226112 659556400 7.451 60 14 28 0 705240080 43045120 2638560

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:14, from 01-04-2024 07:16:44 to 01-04-2024 07:16:58.

Exceptions occured during test was in run

FB_MNEMONA CNT UNIT FB_GDSCODE
except 137 v_add_invoice_to_stock 335544517
except 18 v_cancel_supplier_invoice 335544517

Completed "Exceptions occured during test was in run". Done for 00:00:02, from 01-04-2024 07:16:59 to 01-04-2024 07:17:01.

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          173283
MON$OLDEST_ACTIVE               176385
MON$OLDEST_SNAPSHOT             176385
MON$NEXT_TRANSACTION            176385
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                       1908448
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             700
MON$NEXT_STATEMENT              53
MON$REPLICA_MODE                0


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

Database statistics 

 
Database "/home/bases/oltp40-etalone.fdb" 
Gstat execution time Mon Apr  1 07:17:02 2024 
 
Database header page information: 
    Flags            0 
    Generation        91879 
    System Change Number    0 
    Page size        8192 
    ODS version        13.0 
    Oldest transaction    173283 
    Oldest active        176385 
    Oldest snapshot        176385 
    Next transaction    176386 
    Sequence number        0 
    Next attachment ID    700 
    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.45, total records: 7799355 
    Average version length: 48.16, total versions: 88184, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 64.00, compression ratio: 1.35 
    Pointer pages: 56, data page slots: 89776 
    Data pages: 89776, average fill: 70% 
    Primary pages: 89776, secondary pages: 0, swept pages: 37270 
    Empty pages: 8, full pages: 68989 
    Fill distribution: 
     0 - 19% = 17 
    20 - 39% = 67 
    40 - 59% = 2266 
    60 - 79% = 87377 
    80 - 99% = 49 
 
    Index DOC_DATA_DOC_WARE_UNQ (0) 
    Root page: 1510636, depth: 3, leaf buckets: 23338, nodes: 7799355 
    Average node length: 18.92, total dup: 0, max dup: 0 
    Average key length: 15.93, compression ratio: 1.70 
    Average prefix length: 14.07, average data length: 12.93 
    Clustering factor: 1682329, ratio: 0.22 
    Fill distribution: 
         0 - 19% = 353 
        20 - 39% = 1675 
        40 - 59% = 4146 
        60 - 79% = 2357 
        80 - 99% = 14807 
 
    Index DOC_DATA_ID_DESC (1) 
    Root page: 1528140, depth: 3, leaf buckets: 13521, nodes: 7799355 
    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: 1506963, ratio: 0.19 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 1476 
        40 - 59% = 2072 
        60 - 79% = 1074 
        80 - 99% = 8898 
 
    Index FK_DOC_DATA_DOC_LIST (2) 
    Root page: 1546735, depth: 3, leaf buckets: 8362, nodes: 7799355 
    Average node length: 6.63, total dup: 5811566, max dup: 49 
    Average key length: 3.64, compression ratio: 2.47 
    Average prefix length: 7.61, average data length: 1.39 
    Clustering factor: 1500226, ratio: 0.19 
    Fill distribution: 
         0 - 19% = 126 
        20 - 39% = 903 
        40 - 59% = 1422 
        60 - 79% = 909 
        80 - 99% = 5002 
 
DOC_LIST (138) 
    Primary pointer page: 500, Index root page: 501 
    Total formats: 1, used formats: 1 
    Average record length: 56.50, total records: 2279009 
    Average version length: 58.85, total versions: 45276, max versions: 2 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 84.00, compression ratio: 1.49 
    Pointer pages: 18, data page slots: 29240 
    Data pages: 29240, average fill: 72% 
    Primary pages: 29239, secondary pages: 1, swept pages: 10465 
    Empty pages: 15, full pages: 18739 
    Fill distribution: 
     0 - 19% = 21 
    20 - 39% = 29 
    40 - 59% = 470 
    60 - 79% = 28629 
    80 - 99% = 91 
 
    Index DOC_LIST_ID_DESC (1) 
    Root page: 1541152, depth: 3, leaf buckets: 4576, nodes: 2279009 
    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: 691389, ratio: 0.30 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 868 
        40 - 59% = 884 
        60 - 79% = 697 
        80 - 99% = 2127 
 
    Index DOC_LIST_WORKER_OPTYPE (2) 
    Root page: 1544398, depth: 3, leaf buckets: 2457, nodes: 2280241 
    Average node length: 4.97, total dup: 2279342, max dup: 18868 
    Average key length: 2.01, compression ratio: 4.48 
    Average prefix length: 8.99, average data length: 0.01 
    Clustering factor: 1259430, ratio: 0.55 
    Fill distribution: 
         0 - 19% = 3 
        20 - 39% = 210 
        40 - 59% = 1432 
        60 - 79% = 533 
        80 - 99% = 279 
 
    Index FK_DOC_LIST_AGENTS (3) 
    Root page: 1545933, depth: 3, leaf buckets: 1820, nodes: 2279009 
    Average node length: 4.97, total dup: 2278959, max dup: 130356 
    Average key length: 2.01, compression ratio: 4.48 
    Average prefix length: 8.99, average data length: 0.01 
    Clustering factor: 1085666, ratio: 0.48 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 2 
        40 - 59% = 676 
        60 - 79% = 34 
        80 - 99% = 1108 
 
    Index PK_DOC_LIST (0) 
    Root page: 1538209, depth: 3, leaf buckets: 4393, nodes: 2279009 
    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: 691389, ratio: 0.30 
    Fill distribution: 
         0 - 19% = 117 
        20 - 39% = 544 
        40 - 59% = 682 
        60 - 79% = 771 
        80 - 99% = 2279 
 
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.41, total records: 400 
    Average version length: 31.48, total versions: 1924, max versions: 5 
    Average fragment length: 2.00, total fragments: 4, max fragments: 1 
    Average unpacked length: 104.00, compression ratio: 1.25 
    Pointer pages: 1, data page slots: 32 
    Data pages: 32, average fill: 52% 
    Primary pages: 8, secondary pages: 24, swept pages: 0 
    Empty pages: 6, full pages: 15 
    Fill distribution: 
     0 - 19% = 11 
    20 - 39% = 5 
    40 - 59% = 1 
    60 - 79% = 0 
    80 - 99% = 15 
 
    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: 14.66, total records: 117644 
    Average version length: 68.29, total versions: 106416, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 88.00, compression ratio: 6.00 
    Pointer pages: 6, data page slots: 2600 
    Data pages: 2248, average fill: 70% 
    Primary pages: 2247, secondary pages: 1, swept pages: 0 
    Empty pages: 367, full pages: 1614 
    Fill distribution: 
     0 - 19% = 464 
    20 - 39% = 37 
    40 - 59% = 79 
    60 - 79% = 206 
    80 - 99% = 1462 
 
    Index INVNT_TURNOVER_LOG_WARE_DD_ID (0) 
    Root page: 1702047, depth: 3, leaf buckets: 331, nodes: 117644 
    Average node length: 13.31, total dup: 8797, max dup: 2 
    Average key length: 10.61, compression ratio: 2.54 
    Average prefix length: 19.31, average data length: 7.69 
    Clustering factor: 84795, ratio: 0.72 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 3 
        40 - 59% = 221 
        60 - 79% = 58 
        80 - 99% = 49 
 
MONEY_SALDO (141) 
    Primary pointer page: 506, Index root page: 507 
    Total formats: 1, used formats: 1 
    Average record length: 15.29, total records: 49 
    Average version length: 9.00, total versions: 244, max versions: 7 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 32.00, compression ratio: 2.09 
    Pointer pages: 1, data page slots: 5 
    Data pages: 5, average fill: 20% 
    Primary pages: 1, secondary pages: 4, swept pages: 0 
    Empty pages: 0, full pages: 1 
    Fill distribution: 
     0 - 19% = 4 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 1 
 
    Index PK_MONEY_SALDO (0) 
    Root page: 1510383, depth: 1, leaf buckets: 1, nodes: 49 
    Average node length: 11.82, total dup: 0, max dup: 0 
    Average key length: 10.80, compression ratio: 0.83 
    Average prefix length: 1.18, average data length: 7.82 
    Clustering factor: 1, ratio: 0.02 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
MONEY_TURNOVER_LOG (140) 
    Primary pointer page: 504, Index root page: 505 
    Total formats: 1, used formats: 1 
    Average record length: 12.19, total records: 1916 
    Average version length: 43.52, total versions: 1746, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 58.00, compression ratio: 4.76 
    Pointer pages: 1, data page slots: 40 
    Data pages: 32, average fill: 62% 
    Primary pages: 31, secondary pages: 1, swept pages: 1 
    Empty pages: 7, full pages: 21 
    Fill distribution: 
     0 - 19% = 10 
    20 - 39% = 1 
    40 - 59% = 0 
    60 - 79% = 2 
    80 - 99% = 19 
 
    Index MONEY_TURNOVER_LOG_AGENT_OPTYPE (0) 
    Root page: 94174, depth: 2, leaf buckets: 3, nodes: 1916 
    Average node length: 4.18, total dup: 1818, max dup: 216 
    Average key length: 2.55, compression ratio: 7.44 
    Average prefix length: 18.50, average data length: 0.50 
    Clustering factor: 993, ratio: 0.52 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 1 
        40 - 59% = 1 
        60 - 79% = 0 
        80 - 99% = 0 
 
MON_CACHE_MEMORY (165) 
    Primary pointer page: 555, Index root page: 556 
    Total formats: 2, used formats: 1 
    Average record length: 97.53, total records: 70 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 112.00, compression ratio: 1.15 
    Pointer pages: 1, data page slots: 2 
    Data pages: 2, average fill: 49% 
    Primary pages: 2, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 1 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 1 
    80 - 99% = 0 
 
    Index PK_MON_CACHE_MEMORY (0) 
    Root page: 1504238, depth: 1, leaf buckets: 1, nodes: 70 
    Average node length: 11.70, total dup: 0, max dup: 0 
    Average key length: 10.69, compression ratio: 0.84 
    Average prefix length: 1.30, average data length: 7.70 
    Clustering factor: 2, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
MON_LOG (162) 
    Primary pointer page: 548, Index root page: 549 
    Total formats: 2, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index MON_LOG_DTS (4) 
    Root page: 1504251, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index MON_LOG_GDSCODE (2) 
    Root page: 1504249, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index MON_LOG_ROWSET_DESC (1) 
    Root page: 1504248, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index MON_LOG_UNIT (3) 
    Root page: 1504250, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PK_MON_LOG (0) 
    Root page: 1504247, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
MON_LOG_TABLE_STATS (163) 
    Primary pointer page: 550, Index root page: 551 
    Total formats: 2, used formats: 1 
    Average record length: 67.13, total records: 30 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 611.00, compression ratio: 9.10 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 31% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 1 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index MON_LOG_TABLE_STATS_DTS (4) 
    Root page: 1504246, depth: 1, leaf buckets: 1, nodes: 30 
    Average node length: 3.50, total dup: 23, max dup: 4 
    Average key length: 2.47, compression ratio: 3.24 
    Average prefix length: 7.53, average data length: 0.47 
    Clustering factor: 1, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index MON_LOG_TABLE_STATS_GDSCODE (2) 
    Root page: 1504244, depth: 1, leaf buckets: 1, nodes: 30 
    Average node length: 2.00, total dup: 29, max dup: 29 
    Average key length: 1.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 1, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index MON_LOG_TABLE_STATS_ROWSET (1) 
    Root page: 1504243, depth: 1, leaf buckets: 1, nodes: 30 
    Average node length: 3.33, total dup: 29, max dup: 29 
    Average key length: 2.30, compression ratio: 3.91 
    Average prefix length: 8.70, average data length: 0.30 
    Clustering factor: 1, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index MON_LOG_TABLE_STATS_TN_UNIT (3) 
    Root page: 1504245, depth: 1, leaf buckets: 1, nodes: 30 
    Average node length: 12.90, total dup: 0, max dup: 0 
    Average key length: 11.87, compression ratio: 1.42 
    Average prefix length: 7.63, average data length: 9.20 
    Clustering factor: 1, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PK_MON_LOG_TABLE_STATS (0) 
    Root page: 1504242, depth: 1, leaf buckets: 1, nodes: 30 
    Average node length: 8.37, total dup: 0, max dup: 0 
    Average key length: 7.33, compression ratio: 1.23 
    Average prefix length: 4.63, average data length: 4.37 
    Clustering factor: 1, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
OPTYPES (136) 
    Primary pointer page: 496, Index root page: 497 
    Total formats: 2, used formats: 1 
    Average record length: 67.56, total records: 9 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 386.00, compression ratio: 5.71 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 9% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index OPTYPES_MCODE_UNQ (1) 
    Root page: 1544827, depth: 1, leaf buckets: 1, nodes: 9 
    Average node length: 8.56, total dup: 0, max dup: 0 
    Average key length: 6.89, compression ratio: 0.73 
    Average prefix length: 0.44, average data length: 4.56 
    Clustering factor: 1, ratio: 0.11 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PK_OPTYPES (0) 
    Root page: 1544826, depth: 1, leaf buckets: 1, nodes: 9 
    Average node length: 6.11, total dup: 0, max dup: 0 
    Average key length: 5.00, compression ratio: 0.60 
    Average prefix length: 0.89, average data length: 2.11 
    Clustering factor: 1, ratio: 0.11 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
PDISTR (146) 
    Primary pointer page: 516, Index root page: 517 
    Total formats: 1, used formats: 1 
    Average record length: 36.27, total records: 776101 
    Average version length: 37.88, total versions: 29114, max versions: 2 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 54.00, compression ratio: 1.49 
    Pointer pages: 5, data page slots: 8096 
    Data pages: 8096, average fill: 66% 
    Primary pages: 8095, secondary pages: 1, swept pages: 1543 
    Empty pages: 19, full pages: 6832 
    Fill distribution: 
     0 - 19% = 40 
    20 - 39% = 50 
    40 - 59% = 333 
    60 - 79% = 7613 
    80 - 99% = 60 
 
    Index PDISTR_AGENT_ID (2) 
    Root page: 1509330, depth: 2, leaf buckets: 817, nodes: 762102 
    Average node length: 4.87, total dup: 762053, max dup: 138240 
    Average key length: 2.01, compression ratio: 4.48 
    Average prefix length: 8.99, average data length: 0.01 
    Clustering factor: 89266, ratio: 0.12 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 117 
        40 - 59% = 428 
        60 - 79% = 184 
        80 - 99% = 87 
 
    Index PDISTR_SNDOP_RCVOP_SNDID_ASC (0) 
    Root page: 1508635, depth: 3, leaf buckets: 836, nodes: 762102 
    Average node length: 5.88, total dup: 678259, max dup: 42 
    Average key length: 3.02, compression ratio: 7.28 
    Average prefix length: 21.09, average data length: 0.91 
    Clustering factor: 155769, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 48 
        40 - 59% = 316 
        60 - 79% = 150 
        80 - 99% = 320 
 
    Index PDISTR_SNDOP_RCVOP_SNDID_DESC (1) 
    Root page: 1509209, depth: 3, leaf buckets: 865, nodes: 762102 
    Average node length: 5.88, total dup: 678259, max dup: 42 
    Average key length: 3.02, compression ratio: 7.28 
    Average prefix length: 21.09, average data length: 0.91 
    Clustering factor: 157619, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 106 
        40 - 59% = 296 
        60 - 79% = 155 
        80 - 99% = 307 
 
    Index PDISTR_WORKER_SND_ID (3) 
    Root page: 1510200, depth: 3, leaf buckets: 1105, nodes: 762102 
    Average node length: 5.97, total dup: 678259, max dup: 42 
    Average key length: 3.10, compression ratio: 5.48 
    Average prefix length: 16.00, average data length: 1.00 
    Clustering factor: 150601, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 267 
        40 - 59% = 575 
        60 - 79% = 189 
        80 - 99% = 73 
 
PERF_AGG (158) 
    Primary pointer page: 540, Index root page: 541 
    Total formats: 1, used formats: 1 
    Average record length: 62.73, total records: 5507 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 3.32, total fragments: 37, max fragments: 1 
    Average unpacked length: 379.00, compression ratio: 6.04 
    Pointer pages: 1, data page slots: 96 
    Data pages: 96, average fill: 57% 
    Primary pages: 82, secondary pages: 14, swept pages: 54 
    Empty pages: 12, full pages: 59 
    Fill distribution: 
     0 - 19% = 21 
    20 - 39% = 1 
    40 - 59% = 1 
    60 - 79% = 73 
    80 - 99% = 0 
 
    Index PERF_AGG_UNQ (1) 
    Root page: 1504260, depth: 2, leaf buckets: 6, nodes: 5507 
    Average node length: 5.52, total dup: 0, max dup: 0 
    Average key length: 3.58, compression ratio: 10.08 
    Average prefix length: 34.53, average data length: 1.54 
    Clustering factor: 5139, ratio: 0.93 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 0 
        40 - 59% = 4 
        60 - 79% = 0 
        80 - 99% = 2 
 
    Index PK_PERF_AGG (0) 
    Root page: 1504255, depth: 2, leaf buckets: 10, nodes: 5507 
    Average node length: 11.16, 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: 172, 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.17, total records: 80558 
    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: 840 
    Data pages: 840, average fill: 66% 
    Primary pages: 840, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 838 
    Fill distribution: 
     0 - 19% = 2 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 838 
    80 - 99% = 0 
 
    Index PK_PERF_ESTIMATED (0) 
    Root page: 35972, depth: 2, leaf buckets: 102, nodes: 80558 
    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: 3089, ratio: 0.04 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 1 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 101 
 
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.06, total records: 71 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1691.00, compression ratio: 15.23 
    Pointer pages: 1, data page slots: 2 
    Data pages: 2, average fill: 56% 
    Primary pages: 2, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 1 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 1 
    40 - 59% = 0 
    60 - 79% = 1 
    80 - 99% = 0 
 
PERF_SPLIT_0 (281) 
    Primary pointer page: 601, Index root page: 602 
    Total formats: 1, used formats: 1 
    Average record length: 141.11, total records: 164360 
    Average version length: 154.90, total versions: 11544, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 12.02 
    Pointer pages: 6, data page slots: 4616 
    Data pages: 4080, average fill: 84% 
    Primary pages: 4078, secondary pages: 2, swept pages: 1 
    Empty pages: 36, full pages: 4032 
    Fill distribution: 
     0 - 19% = 38 
    20 - 39% = 2 
    40 - 59% = 2 
    60 - 79% = 5 
    80 - 99% = 4033 
 
PERF_SPLIT_1 (282) 
    Primary pointer page: 603, Index root page: 604 
    Total formats: 1, used formats: 1 
    Average record length: 146.32, total records: 134009 
    Average version length: 153.95, total versions: 4166, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.59 
    Pointer pages: 5, data page slots: 4256 
    Data pages: 3304, average fill: 84% 
    Primary pages: 3302, secondary pages: 2, swept pages: 1 
    Empty pages: 15, full pages: 3283 
    Fill distribution: 
     0 - 19% = 16 
    20 - 39% = 3 
    40 - 59% = 1 
    60 - 79% = 1 
    80 - 99% = 3283 
 
PERF_SPLIT_2 (283) 
    Primary pointer page: 605, Index root page: 606 
    Total formats: 1, used formats: 1 
    Average record length: 138.02, total records: 173392 
    Average version length: 154.93, total versions: 15972, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 12.29 
    Pointer pages: 7, data page slots: 5584 
    Data pages: 4320, average fill: 84% 
    Primary pages: 4318, secondary pages: 2, swept pages: 6 
    Empty pages: 47, full pages: 4259 
    Fill distribution: 
     0 - 19% = 49 
    20 - 39% = 9 
    40 - 59% = 0 
    60 - 79% = 3 
    80 - 99% = 4259 
 
PERF_SPLIT_3 (284) 
    Primary pointer page: 607, Index root page: 616 
    Total formats: 1, used formats: 1 
    Average record length: 149.91, total records: 156138 
    Average version length: 151.03, total versions: 1199, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.31 
    Pointer pages: 6, data page slots: 4080 
    Data pages: 3864, average fill: 83% 
    Primary pages: 3862, secondary pages: 2, swept pages: 2 
    Empty pages: 25, full pages: 3825 
    Fill distribution: 
     0 - 19% = 30 
    20 - 39% = 2 
    40 - 59% = 3 
    60 - 79% = 3 
    80 - 99% = 3826 
 
PERF_SPLIT_4 (285) 
    Primary pointer page: 617, Index root page: 618 
    Total formats: 1, used formats: 1 
    Average record length: 149.00, total records: 149317 
    Average version length: 152.81, total versions: 2005, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.38 
    Pointer pages: 7, data page slots: 4040 
    Data pages: 3712, average fill: 83% 
    Primary pages: 3710, secondary pages: 2, swept pages: 3 
    Empty pages: 42, full pages: 3657 
    Fill distribution: 
     0 - 19% = 45 
    20 - 39% = 4 
    40 - 59% = 5 
    60 - 79% = 1 
    80 - 99% = 3657 
 
PERF_SPLIT_5 (286) 
    Primary pointer page: 619, Index root page: 620 
    Total formats: 1, used formats: 1 
    Average record length: 150.76, total records: 154115 
    Average version length: 138.11, total versions: 149, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.25 
    Pointer pages: 5, data page slots: 3832 
    Data pages: 3800, average fill: 83% 
    Primary pages: 3798, secondary pages: 2, swept pages: 1 
    Empty pages: 17, full pages: 3775 
    Fill distribution: 
     0 - 19% = 19 
    20 - 39% = 2 
    40 - 59% = 2 
    60 - 79% = 2 
    80 - 99% = 3775 
 
PERF_SPLIT_6 (287) 
    Primary pointer page: 621, Index root page: 622 
    Total formats: 1, used formats: 1 
    Average record length: 150.21, total records: 155810 
    Average version length: 150.67, total versions: 849, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.29 
    Pointer pages: 5, data page slots: 3912 
    Data pages: 3848, average fill: 83% 
    Primary pages: 3846, secondary pages: 2, swept pages: 1 
    Empty pages: 21, full pages: 3817 
    Fill distribution: 
     0 - 19% = 23 
    20 - 39% = 4 
    40 - 59% = 1 
    60 - 79% = 1 
    80 - 99% = 3819 
 
PERF_SPLIT_7 (288) 
    Primary pointer page: 626, Index root page: 627 
    Total formats: 1, used formats: 1 
    Average record length: 150.45, total records: 161045 
    Average version length: 150.21, total versions: 780, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.27 
    Pointer pages: 5, data page slots: 4840 
    Data pages: 3992, average fill: 83% 
    Primary pages: 3990, secondary pages: 2, swept pages: 4 
    Empty pages: 30, full pages: 3951 
    Fill distribution: 
     0 - 19% = 34 
    20 - 39% = 2 
    40 - 59% = 5 
    60 - 79% = 0 
    80 - 99% = 3951 
 
PERF_SPLIT_8 (289) 
    Primary pointer page: 628, Index root page: 629 
    Total formats: 1, used formats: 1 
    Average record length: 147.58, total records: 168214 
    Average version length: 153.59, total versions: 4449, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.49 
    Pointer pages: 6, data page slots: 5632 
    Data pages: 4168, average fill: 84% 
    Primary pages: 4166, secondary pages: 2, swept pages: 6 
    Empty pages: 23, full pages: 4131 
    Fill distribution: 
     0 - 19% = 25 
    20 - 39% = 5 
    40 - 59% = 2 
    60 - 79% = 6 
    80 - 99% = 4130 
 
PERF_SPLIT_9 (290) 
    Primary pointer page: 630, Index root page: 631 
    Total formats: 1, used formats: 1 
    Average record length: 150.36, total records: 130969 
    Average version length: 137.49, total versions: 168, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.28 
    Pointer pages: 7, data page slots: 3376 
    Data pages: 3232, average fill: 83% 
    Primary pages: 3229, secondary pages: 3, swept pages: 1 
    Empty pages: 23, full pages: 3199 
    Fill distribution: 
     0 - 19% = 27 
    20 - 39% = 2 
    40 - 59% = 1 
    60 - 79% = 3 
    80 - 99% = 3199 
 
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.01, total records: 2134729 
    Average version length: 52.92, total versions: 36335, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 70.00, compression ratio: 1.35 
    Pointer pages: 16, data page slots: 26016 
    Data pages: 26016, average fill: 71% 
    Primary pages: 25997, secondary pages: 19, swept pages: 11176 
    Empty pages: 126, full pages: 22906 
    Fill distribution: 
     0 - 19% = 223 
    20 - 39% = 200 
    40 - 59% = 767 
    60 - 79% = 24447 
    80 - 99% = 379 
 
    Index PSTORNED_RCV_ID (1) 
    Root page: 1506208, depth: 3, leaf buckets: 2596, nodes: 2134729 
    Average node length: 5.44, total dup: 1993044, max dup: 1696 
    Average key length: 2.48, compression ratio: 3.62 
    Average prefix length: 8.58, average data length: 0.42 
    Clustering factor: 184052, ratio: 0.09 
    Fill distribution: 
         0 - 19% = 5 
        20 - 39% = 263 
        40 - 59% = 1715 
        60 - 79% = 302 
        80 - 99% = 311 
 
    Index PSTORNED_SND_ID (0) 
    Root page: 1504841, depth: 3, leaf buckets: 2760, nodes: 2134729 
    Average node length: 5.69, total dup: 1916437, max dup: 66 
    Average key length: 2.74, compression ratio: 3.29 
    Average prefix length: 8.37, average data length: 0.63 
    Clustering factor: 380935, ratio: 0.18 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 3 
        40 - 59% = 2345 
        60 - 79% = 383 
        80 - 99% = 29 
 
    Index PSTORNED_WORKER_ID (2) 
    Root page: 1508018, depth: 3, leaf buckets: 2100, nodes: 2134729 
    Average node length: 4.96, total dup: 2134629, max dup: 28199 
    Average key length: 2.00, compression ratio: 1.20 
    Average prefix length: 2.40, average data length: 0.00 
    Clustering factor: 181554, ratio: 0.09 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 176 
        40 - 59% = 1076 
        60 - 79% = 351 
        80 - 99% = 495 
 
RULES_FOR_PDISTR (148) 
    Primary pointer page: 520, Index root page: 521 
    Total formats: 1, used formats: 1 
    Average record length: 17.00, total records: 4 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 334.00, compression ratio: 19.65 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 2% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index RULES_FOR_PDISTR_UNQ (0) 
    Root page: 1504339, depth: 1, leaf buckets: 1, nodes: 4 
    Average node length: 11.50, total dup: 0, max dup: 0 
    Average key length: 10.25, compression ratio: 0.88 
    Average prefix length: 1.50, average data length: 7.50 
    Clustering factor: 1, ratio: 0.25 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
RULES_FOR_QDISTR (137) 
    Primary pointer page: 498, Index root page: 499 
    Total formats: 1, used formats: 1 
    Average record length: 32.71, total records: 7 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 332.00, compression ratio: 10.15 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 4% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index RULES_FOR_QDISTR_RCVOP (1) 
    Root page: 1544825, depth: 1, leaf buckets: 1, nodes: 7 
    Average node length: 5.29, total dup: 2, max dup: 2 
    Average key length: 4.14, compression ratio: 0.72 
    Average prefix length: 1.43, average data length: 1.57 
    Clustering factor: 1, ratio: 0.14 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index RULES_FOR_QDISTR_UNQ (0) 
    Root page: 1544824, depth: 1, leaf buckets: 1, nodes: 7 
    Average node length: 10.14, total dup: 0, max dup: 0 
    Average key length: 8.86, compression ratio: 0.94 
    Average prefix length: 2.14, average data length: 6.14 
    Clustering factor: 1, ratio: 0.14 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
SEMAPHORES (152) 
    Primary pointer page: 528, Index root page: 529 
    Total formats: 1, used formats: 1 
    Average record length: 43.40, total records: 5 
    Average version length: 9.00, total versions: 1, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 346.00, compression ratio: 7.97 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 4% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index PK_SEMAPHORES (0) 
    Root page: 1504327, depth: 1, leaf buckets: 1, nodes: 5 
    Average node length: 12.40, total dup: 0, max dup: 0 
    Average key length: 11.00, compression ratio: 0.82 
    Average prefix length: 0.60, average data length: 8.40 
    Clustering factor: 1, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index SEMAPHORES_TASK_UNQ (1) 
    Root page: 1504328, depth: 1, leaf buckets: 1, nodes: 5 
    Average node length: 23.40, total dup: 0, max dup: 0 
    Average key length: 22.00, compression ratio: 1.07 
    Average prefix length: 4.20, average data length: 19.40 
    Clustering factor: 1, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
SETTINGS (135) 
    Primary pointer page: 494, Index root page: 495 
    Total formats: 1, used formats: 1 
    Average record length: 97.62, total records: 149 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1347.00, compression ratio: 13.80 
    Pointer pages: 1, data page slots: 3 
    Data pages: 3, average fill: 70% 
    Primary pages: 3, secondary pages: 0, swept pages: 1 
    Empty pages: 0, full pages: 2 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 1 
    60 - 79% = 0 
    80 - 99% = 2 
 
    Index SETTINGS_MCODE_WM_UNQ (1) 
    Root page: 1544931, depth: 1, leaf buckets: 1, nodes: 149 
    Average node length: 14.66, total dup: 0, max dup: 0 
    Average key length: 13.55, compression ratio: 2.19 
    Average prefix length: 19.07, average data length: 10.66 
    Clustering factor: 48, ratio: 0.32 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 1 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index SETTINGS_MODE_CODE (0) 
    Root page: 1544828, depth: 1, leaf buckets: 1, nodes: 149 
    Average node length: 25.56, total dup: 0, max dup: 0 
    Average key length: 24.56, compression ratio: 1.63 
    Average prefix length: 18.58, average data length: 21.56 
    Clustering factor: 14, ratio: 0.09 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 0 
        40 - 59% = 1 
        60 - 79% = 0 
        80 - 99% = 0 
 
TMP$DEP_DOCS (129) 
    Primary pointer page: 482, Index root page: 483 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index TMP_DEP_DOCS_UNQ (0) 
    Root page: 1544832, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
TMP$IDX_RECALC (132) 
    Primary pointer page: 488, Index root page: 489 
    Total formats: 2, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index TMP_IDX_RECALC_IDX_NAME_UNQ (0) 
    Root page: 1544829, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
TMP$MON_LOG (133) 
    Primary pointer page: 490, Index root page: 491 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
TMP$MON_LOG_TABLE_STATS (134) 
    Primary pointer page: 492, Index root page: 493 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
TMP$PERF_EST_WHOLE (161) 
    Primary pointer page: 546, Index root page: 547 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
TMP$PERF_LOG (160) 
    Primary pointer page: 544, Index root page: 545 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index TMP$PERF_LOG_UNIT_TRN_DTS_END (0) 
    Root page: 1504252, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
TMP$PERF_MON (131) 
    Primary pointer page: 486, Index root page: 487 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
TMP$RESULT_SET (130) 
    Primary pointer page: 484, Index root page: 485 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index TMP_RESULT_SET_DOC (1) 
    Root page: 1544831, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index TMP_RESULT_SET_WARE_DOC (0) 
    Root page: 1544830, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
TMP$SHOPPING_CART (128) 
    Primary pointer page: 480, Index root page: 481 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index TMP_SHOPCART_UNQ (0) 
    Root page: 1544833, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
TPAUSE (166) 
    Primary pointer page: 557, Index root page: 558 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index RDB$PRIMARY2 (0) 
    Root page: 1504237, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
TRACE_STAT (157) 
    Primary pointer page: 538, Index root page: 539 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
WARES (142) 
    Primary pointer page: 508, Index root page: 509 
    Total formats: 1, used formats: 1 
    Average record length: 77.52, total records: 400 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 444.00, compression ratio: 5.73 
    Pointer pages: 1, data page slots: 6 
    Data pages: 6, average fill: 77% 
    Primary pages: 6, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 5 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 5 
    80 - 99% = 1 
 
    Index FK_WARES_WARE_GROUPS (3) 
    Root page: 1552183, depth: 1, leaf buckets: 1, nodes: 400 
    Average node length: 3.17, total dup: 392, max dup: 60 
    Average key length: 2.16, compression ratio: 4.16 
    Average prefix length: 8.86, average data length: 0.14 
    Clustering factor: 48, ratio: 0.12 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PK_WARES (0) 
    Root page: 1510377, depth: 1, leaf buckets: 1, nodes: 400 
    Average node length: 11.22, total dup: 0, max dup: 0 
    Average key length: 10.22, compression ratio: 0.88 
    Average prefix length: 1.78, average data length: 7.22 
    Clustering factor: 344, ratio: 0.86 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 0 
        40 - 59% = 1 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index WARES_ID_DESC (2) 
    Root page: 1510382, depth: 1, leaf buckets: 1, nodes: 400 
    Average node length: 11.22, total dup: 0, max dup: 0 
    Average key length: 10.22, compression ratio: 0.88 
    Average prefix length: 1.78, average data length: 7.22 
    Clustering factor: 344, ratio: 0.86 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 0 
        40 - 59% = 1 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index WARES_NUMB_UNQ (1) 
    Root page: 1510380, depth: 2, leaf buckets: 3, nodes: 400 
    Average node length: 53.25, total dup: 0, max dup: 0 
    Average key length: 52.23, compression ratio: 1.00 
    Average prefix length: 2.74, average data length: 49.25 
    Clustering factor: 355, ratio: 0.89 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 1 
        80 - 99% = 2 
 
WARE_GROUPS (151) 
    Primary pointer page: 526, Index root page: 527 
    Total formats: 1, used formats: 1 
    Average record length: 32.12, total records: 8 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 346.00, compression ratio: 10.77 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 5% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index PK_WARE_GROUPS (0) 
    Root page: 1504329, depth: 1, leaf buckets: 1, nodes: 8 
    Average node length: 11.25, total dup: 0, max dup: 0 
    Average key length: 10.12, compression ratio: 0.89 
    Average prefix length: 1.75, average data length: 7.25 
    Clustering factor: 1, ratio: 0.12 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index WARE_GROUPS_NAME_UNQ (1) 
    Root page: 1504330, depth: 1, leaf buckets: 1, nodes: 8 
    Average node length: 19.88, total dup: 0, max dup: 0 
    Average key length: 18.12, compression ratio: 0.89 
    Average prefix length: 0.25, average data length: 15.88 
    Clustering factor: 1, ratio: 0.12 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
XQD_1000_1200 (176) 
    Primary pointer page: 577, Index root page: 578 
    Total formats: 1, used formats: 1 
    Average record length: 45.88, total records: 150000 
    Average version length: 69.15, total versions: 58156, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 2.75 
    Pointer pages: 3, data page slots: 3840 
    Data pages: 3032, average fill: 59% 
    Primary pages: 3031, secondary pages: 1, swept pages: 262 
    Empty pages: 279, full pages: 1705 
    Fill distribution: 
     0 - 19% = 445 
    20 - 39% = 346 
    40 - 59% = 396 
    60 - 79% = 897 
    80 - 99% = 948 
 
    Index XQD_1000_1200_WA_SO_RO_WKR_SND (0) 
    Root page: 1555710, depth: 3, leaf buckets: 233, nodes: 150000 
    Average node length: 6.43, total dup: 130627, max dup: 14 
    Average key length: 3.94, compression ratio: 10.67 
    Average prefix length: 40.19, average data length: 1.81 
    Clustering factor: 26027, ratio: 0.17 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 38 
        40 - 59% = 136 
        60 - 79% = 53 
        80 - 99% = 6 
 
XQD_1000_3300 (178) 
    Primary pointer page: 581, Index root page: 582 
    Total formats: 1, used formats: 1 
    Average record length: 65.89, total records: 6910594 
    Average version length: 68.74, total versions: 352036, 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: 104016 
    Data pages: 104016, average fill: 71% 
    Primary pages: 104016, secondary pages: 0, swept pages: 19364 
    Empty pages: 6, full pages: 72129 
    Fill distribution: 
     0 - 19% = 63 
    20 - 39% = 816 
    40 - 59% = 7721 
    60 - 79% = 94426 
    80 - 99% = 990 
 
    Index XQD_1000_3300_WA_SO_RO_WKR_SND (0) 
    Root page: 1480476, depth: 3, leaf buckets: 10579, nodes: 6910594 
    Average node length: 6.51, total dup: 5977456, max dup: 29 
    Average key length: 3.52, compression ratio: 11.93 
    Average prefix length: 40.61, average data length: 1.39 
    Clustering factor: 1637095, ratio: 0.24 
    Fill distribution: 
         0 - 19% = 6 
        20 - 39% = 1872 
        40 - 59% = 5636 
        60 - 79% = 2588 
        80 - 99% = 477 
 
    Index XQD_1000_3300_WKR_DOC_ASC (1) 
    Root page: 1486090, depth: 3, leaf buckets: 8302, nodes: 6910594 
    Average node length: 5.40, total dup: 6631916, max dup: 169 
    Average key length: 2.41, compression ratio: 7.05 
    Average prefix length: 16.63, average data length: 0.37 
    Clustering factor: 1439816, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 10 
        20 - 39% = 1160 
        40 - 59% = 4440 
        60 - 79% = 1670 
        80 - 99% = 1022 
 
    Index XQD_1000_3300_WKR_DOC_DEC (2) 
    Root page: 1490630, depth: 3, leaf buckets: 8364, nodes: 6910594 
    Average node length: 5.40, total dup: 6631916, max dup: 169 
    Average key length: 2.41, compression ratio: 7.05 
    Average prefix length: 16.63, average data length: 0.37 
    Clustering factor: 1442174, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 8 
        20 - 39% = 1272 
        40 - 59% = 4429 
        60 - 79% = 1598 
        80 - 99% = 1057 
 
XQD_1200_2000 (177) 
    Primary pointer page: 579, Index root page: 580 
    Total formats: 1, used formats: 1 
    Average record length: 67.53, total records: 11893880 
    Average version length: 68.76, total versions: 278920, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.87 
    Pointer pages: 106, data page slots: 172144 
    Data pages: 172144, average fill: 73% 
    Primary pages: 172144, secondary pages: 0, swept pages: 63177 
    Empty pages: 3, full pages: 154061 
    Fill distribution: 
     0 - 19% = 38 
    20 - 39% = 542 
    40 - 59% = 4379 
    60 - 79% = 165619 
    80 - 99% = 1566 
 
    Index XQD_1200_2000_WA_SO_RO_WKR_SND (0) 
    Root page: 1495050, depth: 3, leaf buckets: 18306, nodes: 11891096 
    Average node length: 6.60, total dup: 10366047, max dup: 64 
    Average key length: 3.43, compression ratio: 12.26 
    Average prefix length: 40.70, average data length: 1.30 
    Clustering factor: 2473678, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 22 
        20 - 39% = 2570 
        40 - 59% = 10656 
        60 - 79% = 4250 
        80 - 99% = 808 
 
XQD_2000_3300 (179) 
    Primary pointer page: 583, Index root page: 584 
    Total formats: 1, used formats: 1 
    Average record length: 47.24, total records: 1534432 
    Average version length: 69.08, total versions: 309892, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 2.67 
    Pointer pages: 25, data page slots: 39296 
    Data pages: 29151, average fill: 53% 
    Primary pages: 29073, secondary pages: 78, swept pages: 8640 
    Empty pages: 3412, full pages: 18098 
    Fill distribution: 
     0 - 19% = 5310 
    20 - 39% = 4660 
    40 - 59% = 3017 
    60 - 79% = 12139 
    80 - 99% = 4025 
 
    Index XQD_2000_3300_WA_SO_RO_WKR_SND (0) 
    Root page: 1479735, depth: 3, leaf buckets: 1823, nodes: 1285361 
    Average node length: 5.54, total dup: 1233158, max dup: 49 
    Average key length: 2.57, compression ratio: 16.32 
    Average prefix length: 41.47, average data length: 0.53 
    Clustering factor: 90724, ratio: 0.07 
    Fill distribution: 
         0 - 19% = 4 
        20 - 39% = 559 
        40 - 59% = 856 
        60 - 79% = 363 
        80 - 99% = 41 
 
XQD_2100_3300 (180) 
    Primary pointer page: 585, Index root page: 586 
    Total formats: 1, used formats: 1 
    Average record length: 40.62, total records: 1230018 
    Average version length: 69.02, total versions: 149464, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 3.10 
    Pointer pages: 19, data page slots: 30144 
    Data pages: 25192, average fill: 42% 
    Primary pages: 25192, secondary pages: 0, swept pages: 4870 
    Empty pages: 3707, full pages: 11442 
    Fill distribution: 
     0 - 19% = 6335 
    20 - 39% = 3611 
    40 - 59% = 7122 
    60 - 79% = 7797 
    80 - 99% = 327 
 
    Index XQD_2100_3300_WA_SO_RO_WKR_SND (0) 
    Root page: 1479229, depth: 3, leaf buckets: 1145, nodes: 797378 
    Average node length: 5.94, total dup: 734624, max dup: 62 
    Average key length: 3.00, compression ratio: 13.98 
    Average prefix length: 41.07, average data length: 0.93 
    Clustering factor: 120147, ratio: 0.15 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 254 
        40 - 59% = 570 
        60 - 79% = 298 
        80 - 99% = 23 
 
XQD_3300_3400 (181) 
    Primary pointer page: 587, Index root page: 588 
    Total formats: 1, used formats: 1 
    Average record length: 65.87, total records: 9393732 
    Average version length: 68.97, total versions: 469535, 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: 88, data page slots: 143536 
    Data pages: 143536, average fill: 70% 
    Primary pages: 143522, secondary pages: 14, swept pages: 45424 
    Empty pages: 76, full pages: 76772 
    Fill distribution: 
     0 - 19% = 232 
    20 - 39% = 1144 
    40 - 59% = 14157 
    60 - 79% = 124903 
    80 - 99% = 3100 
 
    Index XQD_3300_3400_WA_SO_RO_WKR_SND (0) 
    Root page: 1472612, depth: 3, leaf buckets: 13494, nodes: 9388591 
    Average node length: 6.69, total dup: 7785248, max dup: 14 
    Average key length: 3.67, compression ratio: 11.46 
    Average prefix length: 40.50, average data length: 1.50 
    Clustering factor: 2105810, ratio: 0.22 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 1120 
        40 - 59% = 6666 
        60 - 79% = 4853 
        80 - 99% = 854 
 
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: 21158595 
    Average version length: 82.93, total versions: 10916, 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: 319984 
    Data pages: 319984, average fill: 81% 
    Primary pages: 319979, secondary pages: 5, swept pages: 13604 
    Empty pages: 38, full pages: 319165 
    Fill distribution: 
     0 - 19% = 65 
    20 - 39% = 35 
    40 - 59% = 84 
    60 - 79% = 49565 
    80 - 99% = 270235 
 
    Index XQS_1000_1200_DOC_ID (1) 
    Root page: 1426738, depth: 3, leaf buckets: 19297, nodes: 21158595 
    Average node length: 5.72, total dup: 20677384, max dup: 128 
    Average key length: 2.16, compression ratio: 4.16 
    Average prefix length: 8.86, average data length: 0.14 
    Clustering factor: 3286296, ratio: 0.16 
    Fill distribution: 
         0 - 19% = 8 
        20 - 39% = 0 
        40 - 59% = 7935 
        60 - 79% = 565 
        80 - 99% = 10789 
 
    Index XQS_1000_1200_RCV_ID (3) 
    Root page: 1457002, depth: 3, leaf buckets: 17202, nodes: 21158595 
    Average node length: 6.31, total dup: 18594500, max dup: 49 
    Average key length: 2.75, compression ratio: 3.27 
    Average prefix length: 8.37, average data length: 0.63 
    Clustering factor: 919608, ratio: 0.04 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 5 
        40 - 59% = 806 
        60 - 79% = 295 
        80 - 99% = 16095 
 
    Index XQS_1000_1200_SND_ID (2) 
    Root page: 1441095, depth: 3, leaf buckets: 21064, nodes: 21158595 
    Average node length: 6.35, total dup: 18512937, max dup: 29 
    Average key length: 2.79, compression ratio: 3.23 
    Average prefix length: 8.34, average data length: 0.66 
    Clustering factor: 3580597, ratio: 0.17 
    Fill distribution: 
         0 - 19% = 5 
        20 - 39% = 0 
        40 - 59% = 8175 
        60 - 79% = 630 
        80 - 99% = 12254 
 
    Index XQS_1000_1200_WORKER_ID (0) 
    Root page: 1413370, depth: 3, leaf buckets: 16186, nodes: 21158595 
    Average node length: 5.56, total dup: 21158495, max dup: 229755 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.42, average data length: 0.00 
    Clustering factor: 948513, ratio: 0.04 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 9 
        40 - 59% = 3068 
        60 - 79% = 346 
        80 - 99% = 12762 
 
XQS_1000_3300 (184) 
    Primary pointer page: 593, Index root page: 594 
    Total formats: 1, used formats: 1 
    Average record length: 78.60, total records: 9891048 
    Average version length: 82.59, total versions: 514938, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.60 
    Pointer pages: 106, data page slots: 172160 
    Data pages: 172136, average fill: 71% 
    Primary pages: 172109, secondary pages: 27, swept pages: 68961 
    Empty pages: 539, full pages: 103988 
    Fill distribution: 
     0 - 19% = 1374 
    20 - 39% = 4169 
    40 - 59% = 20010 
    60 - 79% = 119051 
    80 - 99% = 27532 
 
    Index XQS_1000_3300_DOC_ID (1) 
    Root page: 1367524, depth: 3, leaf buckets: 11348, nodes: 9891048 
    Average node length: 5.38, total dup: 9579487, max dup: 198 
    Average key length: 2.23, compression ratio: 4.04 
    Average prefix length: 8.80, average data length: 0.20 
    Clustering factor: 2200585, ratio: 0.22 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 19 
        40 - 59% = 7441 
        60 - 79% = 3729 
        80 - 99% = 158 
 
    Index XQS_1000_3300_RCV_ID (3) 
    Root page: 1379283, depth: 3, leaf buckets: 13621, nodes: 9891048 
    Average node length: 6.26, total dup: 8196697, max dup: 14 
    Average key length: 3.10, compression ratio: 2.90 
    Average prefix length: 8.07, average data length: 0.93 
    Clustering factor: 1523675, ratio: 0.15 
    Fill distribution: 
         0 - 19% = 134 
        20 - 39% = 3639 
        40 - 59% = 4578 
        60 - 79% = 2628 
        80 - 99% = 2642 
 
    Index XQS_1000_3300_SND_ID (2) 
    Root page: 1373081, depth: 3, leaf buckets: 12672, nodes: 9891048 
    Average node length: 6.00, total dup: 8591531, max dup: 56 
    Average key length: 2.84, compression ratio: 3.17 
    Average prefix length: 8.29, average data length: 0.71 
    Clustering factor: 2398614, ratio: 0.24 
    Fill distribution: 
         0 - 19% = 3 
        20 - 39% = 31 
        40 - 59% = 8348 
        60 - 79% = 4092 
        80 - 99% = 198 
 
    Index XQS_1000_3300_WORKER_ID (0) 
    Root page: 1362789, depth: 3, leaf buckets: 10304, nodes: 9891048 
    Average node length: 5.16, total dup: 9890948, max dup: 149756 
    Average key length: 2.00, compression ratio: 1.20 
    Average prefix length: 2.41, average data length: 0.00 
    Clustering factor: 1541071, ratio: 0.16 
    Fill distribution: 
         0 - 19% = 40 
        20 - 39% = 1249 
        40 - 59% = 4959 
        60 - 79% = 1871 
        80 - 99% = 2185 
 
XQS_1200_2000 (183) 
    Primary pointer page: 591, Index root page: 592 
    Total formats: 1, used formats: 1 
    Average record length: 80.09, total records: 11464636 
    Average version length: 82.52, total versions: 346550, 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: 118, data page slots: 192096 
    Data pages: 190880, average fill: 74% 
    Primary pages: 190752, secondary pages: 128, swept pages: 59872 
    Empty pages: 1989, full pages: 153387 
    Fill distribution: 
     0 - 19% = 3513 
    20 - 39% = 5245 
    40 - 59% = 12691 
    60 - 79% = 99109 
    80 - 99% = 70322 
 
    Index XQS_1200_2000_DOC_ID (1) 
    Root page: 1392123, depth: 3, leaf buckets: 13130, nodes: 11464636 
    Average node length: 5.32, total dup: 11354386, max dup: 624 
    Average key length: 2.08, compression ratio: 4.33 
    Average prefix length: 8.93, average data length: 0.07 
    Clustering factor: 2405913, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 110 
        40 - 59% = 8517 
        60 - 79% = 4306 
        80 - 99% = 195 
 
    Index XQS_1200_2000_RCV_ID (3) 
    Root page: 1406132, depth: 3, leaf buckets: 10552, nodes: 11464636 
    Average node length: 5.52, total dup: 10964587, max dup: 49 
    Average key length: 2.28, compression ratio: 3.95 
    Average prefix length: 8.77, average data length: 0.23 
    Clustering factor: 741330, ratio: 0.06 
    Fill distribution: 
         0 - 19% = 143 
        20 - 39% = 826 
        40 - 59% = 2613 
        60 - 79% = 1727 
        80 - 99% = 5243 
 
    Index XQS_1200_2000_SND_ID (2) 
    Root page: 1398660, depth: 3, leaf buckets: 15015, nodes: 11464636 
    Average node length: 6.04, total dup: 10008656, max dup: 87 
    Average key length: 2.80, compression ratio: 3.21 
    Average prefix length: 8.32, average data length: 0.68 
    Clustering factor: 2422299, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 4 
        20 - 39% = 150 
        40 - 59% = 9987 
        60 - 79% = 4619 
        80 - 99% = 255 
 
    Index XQS_1200_2000_WORKER_ID (0) 
    Root page: 1386233, depth: 3, leaf buckets: 10728, nodes: 11464636 
    Average node length: 5.24, total dup: 11464536, max dup: 195482 
    Average key length: 2.00, compression ratio: 1.20 
    Average prefix length: 2.41, average data length: 0.00 
    Clustering factor: 728135, ratio: 0.06 
    Fill distribution: 
         0 - 19% = 97 
        20 - 39% = 770 
        40 - 59% = 4453 
        60 - 79% = 1560 
        80 - 99% = 3848 
 
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: 79.08, total records: 9990277 
    Average version length: 82.88, total versions: 495574, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.59 
    Pointer pages: 107, data page slots: 174136 
    Data pages: 174112, average fill: 71% 
    Primary pages: 174088, secondary pages: 24, swept pages: 71479 
    Empty pages: 567, full pages: 105391 
    Fill distribution: 
     0 - 19% = 1404 
    20 - 39% = 4136 
    40 - 59% = 19473 
    60 - 79% = 122652 
    80 - 99% = 26447 
 
    Index XQS_2100_3300_DOC_ID (1) 
    Root page: 1344708, depth: 3, leaf buckets: 12063, nodes: 9990277 
    Average node length: 5.20, total dup: 9960618, max dup: 1547 
    Average key length: 2.03, compression ratio: 4.43 
    Average prefix length: 8.97, average data length: 0.03 
    Clustering factor: 1994996, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 32 
        20 - 39% = 1381 
        40 - 59% = 8150 
        60 - 79% = 1895 
        80 - 99% = 605 
 
    Index XQS_2100_3300_RCV_ID (3) 
    Root page: 1355739, depth: 3, leaf buckets: 13678, nodes: 9990277 
    Average node length: 6.27, total dup: 8278474, max dup: 14 
    Average key length: 3.10, compression ratio: 2.90 
    Average prefix length: 8.07, average data length: 0.93 
    Clustering factor: 1512211, ratio: 0.15 
    Fill distribution: 
         0 - 19% = 178 
        20 - 39% = 3656 
        40 - 59% = 4379 
        60 - 79% = 2669 
        80 - 99% = 2796 
 
    Index XQS_2100_3300_SND_ID (2) 
    Root page: 1350071, depth: 3, leaf buckets: 12743, nodes: 9990277 
    Average node length: 5.45, total dup: 9540859, max dup: 99 
    Average key length: 2.29, compression ratio: 3.93 
    Average prefix length: 8.76, average data length: 0.24 
    Clustering factor: 2135148, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 30 
        20 - 39% = 1407 
        40 - 59% = 9032 
        60 - 79% = 1668 
        80 - 99% = 606 
 
    Index XQS_2100_3300_WORKER_ID (0) 
    Root page: 987843, depth: 3, leaf buckets: 10445, nodes: 9990277 
    Average node length: 5.17, total dup: 9990177, max dup: 152039 
    Average key length: 2.00, compression ratio: 1.20 
    Average prefix length: 2.41, average data length: 0.00 
    Clustering factor: 1572797, ratio: 0.16 
    Fill distribution: 
         0 - 19% = 34 
        20 - 39% = 1308 
        40 - 59% = 5062 
        60 - 79% = 1841 
        80 - 99% = 2200 
 
XQS_3300_3400 (187) 
    Primary pointer page: 599, Index root page: 600 
    Total formats: 1, used formats: 1 
    Average record length: 67.22, total records: 585138 
    Average version length: 68.67, total versions: 9491, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.87 
    Pointer pages: 5, data page slots: 8160 
    Data pages: 8160, average fill: 75% 
    Primary pages: 8160, secondary pages: 0, swept pages: 3435 
    Empty pages: 5, full pages: 7200 
    Fill distribution: 
     0 - 19% = 6 
    20 - 39% = 6 
    40 - 59% = 131 
    60 - 79% = 7686 
    80 - 99% = 331 
 
    Index XQS_3300_3400_DOC_ID (1) 
    Root page: 43040, depth: 3, leaf buckets: 735, nodes: 585138 
    Average node length: 5.95, total dup: 498296, max dup: 82 
    Average key length: 3.09, compression ratio: 2.91 
    Average prefix length: 8.06, average data length: 0.94 
    Clustering factor: 102320, ratio: 0.17 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 13 
        40 - 59% = 518 
        60 - 79% = 103 
        80 - 99% = 101 
 
    Index XQS_3300_3400_SND_ID (2) 
    Root page: 34924, depth: 3, leaf buckets: 758, nodes: 585138 
    Average node length: 6.15, total dup: 479935, max dup: 29 
    Average key length: 3.29, compression ratio: 2.73 
    Average prefix length: 7.89, average data length: 1.11 
    Clustering factor: 102383, ratio: 0.17 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 12 
        40 - 59% = 536 
        60 - 79% = 96 
        80 - 99% = 113 
 
    Index XQS_3300_3400_WORKER_ID (0) 
    Root page: 377587, depth: 2, leaf buckets: 557, nodes: 585138 
    Average node length: 4.86, total dup: 585038, max dup: 9599 
    Average key length: 2.00, compression ratio: 1.20 
    Average prefix length: 2.41, average data length: 0.00 
    Clustering factor: 90968, ratio: 0.16 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 27 
        40 - 59% = 317 
        60 - 79% = 54 
        80 - 99% = 157 
 
ZDOC_DATA (170) 
    Primary pointer page: 565, Index root page: 566 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
ZDOC_LIST (169) 
    Primary pointer page: 563, Index root page: 564 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
ZINVNT_TURNOVER_LOG (171) 
    Primary pointer page: 567, Index root page: 568 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
ZPDISTR (174) 
    Primary pointer page: 573, Index root page: 574 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index ZPDISTR_ID (0) 
    Root page: 1504230, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
ZPSTORNED (175) 
    Primary pointer page: 575, Index root page: 576 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index ZPSTORNED_ID (0) 
    Root page: 1504229, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
ZQDISTR (172) 
    Primary pointer page: 569, Index root page: 570 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index ZQDISTR_ID (0) 
    Root page: 1504235, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index ZQDISTR_WARE_SNDOP_RCVOP (1) 
    Root page: 1504236, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
ZQSTORNED (173) 
    Primary pointer page: 571, Index root page: 572 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index ZQSTORNED_DOC_ID (1) 
    Root page: 1504232, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index ZQSTORNED_ID (0) 
    Root page: 1504231, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index ZQSTORNED_RCV_ID (3) 
    Root page: 1504234, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index ZQSTORNED_SND_ID (2) 
    Root page: 1504233, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
ZTMP_DEP_DOCS (168) 
    Primary pointer page: 561, Index root page: 562 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
ZTMP_SHOPPING_CART (167) 
    Primary pointer page: 559, Index root page: 560 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
Z_USED_VIEWS (144) 
    Primary pointer page: 512, Index root page: 513 
    Total formats: 1, used formats: 1 
    Average record length: 29.38, total records: 29 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 99.00, compression ratio: 3.37 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 16% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index Z_USED_VIEWS_UNQ (0) 
    Root page: 1510372, depth: 1, leaf buckets: 1, nodes: 29 
    Average node length: 15.17, total dup: 0, max dup: 0 
    Average key length: 14.14, compression ratio: 1.44 
    Average prefix length: 9.17, average data length: 11.17 
    Clustering factor: 1, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
Gstat completion time Mon Apr  1 07:17:26 2024

Record versions statistics, table

TABLE_NAME TOTAL_RECS TOTAL_VERS MAX_VERSIONS VERS_TO_RECS_PRC MAXV_TO_VERS_PRC
DOC_DATA 7799355 88184 1 0.0000 0.0000
DOC_LIST 2279009 45276 2 0.0000 0.0000
FB_ERRORS 2182 757 1 0.0000 0.0000
INVNT_SALDO 400 1924 5 400.0000 0.0000
INVNT_TURNOVER_LOG 117644 106416 1 0.0000 0.0000
MONEY_SALDO 49 244 7 400.0000 0.0000
MONEY_TURNOVER_LOG 1916 1746 1 0.0000 0.0000
PDISTR 776101 29114 2 0.0000 0.0000
PERF_SPLIT_0 164360 11544 1 0.0000 0.0000
PERF_SPLIT_1 134009 4166 1 0.0000 0.0000
PERF_SPLIT_2 173392 15972 1 0.0000 0.0000
PERF_SPLIT_3 156138 1199 1 0.0000 0.0000
PERF_SPLIT_4 149317 2005 1 0.0000 0.0000
PERF_SPLIT_5 154115 149 1 0.0000 0.0000
PERF_SPLIT_6 155810 849 1 0.0000 0.0000
PERF_SPLIT_7 161045 780 1 0.0000 0.0000
PERF_SPLIT_8 168214 4449 1 0.0000 0.0000
PERF_SPLIT_9 130969 168 1 0.0000 0.0000
PSTORNED 2134729 36335 1 0.0000 0.0000
SEMAPHORES 5 1 1 0.0000 100.0000
XQD_1000_1200 150000 58156 1 0.0000 0.0000
XQD_1000_3300 6910594 352036 1 0.0000 0.0000
XQD_1200_2000 11893880 278920 1 0.0000 0.0000
XQD_2000_3300 1534432 309892 1 0.0000 0.0000
XQD_2100_3300 1230018 149464 1 0.0000 0.0000
XQD_3300_3400 9393732 469535 1 0.0000 0.0000
XQS_1000_1200 21158595 10916 1 0.0000 0.0000
XQS_1000_3300 9891048 514938 1 0.0000 0.0000
XQS_1200_2000 11464636 346550 1 0.0000 0.0000
XQS_2100_3300 9990277 495574 1 0.0000 0.0000
XQS_3300_3400 585138 9491 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 ---
:6: 
:7: mscs-test-161.budzdorov.ru    Mon Apr  1 07:15:18 2024
:8:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3400
:9: 
:10: 
:11: mscs-test-161.budzdorov.ru    Mon Apr  1 07:15:31 2024
:12:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3400
:13: 
--- end of diff output ---

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

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