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

Hardware and OS info

Command: hostnamectl
Static hostname mscs-test-161.budzdorov.ru
Icon name computer-server
Chassis server
Machine ID aeee285d2cca40bf84c40a748f599e77
Boot ID 2a7b53d1c5ed44b9bb2712fffac5d8c6
Operating System CentOS Linux 7 (Core)
CPE OS Name cpe:/o:centos:centos:7
Kernel Linux 3.10.0-1127.10.1.el7.x86_64
Architecture x86-64
Command: who -b
bootup_info system boot 2021-11-11 18:28
Command: dmidecode -t system|grep -i -e 'manufacturer\|product\|hypervisor'
Manufacturer HP
Product Name ProLiant DL380 Gen9
Command: dmesg | grep DMI
[ 0.000000] DMI HP ProLiant DL380 Gen9/ProLiant DL380 Gen9, BIOS P89 05/21/2018
Command: lscpu | grep -i -v flags
Architecture x86_64
CPU op-mode(s) 32-bit, 64-bit
Byte Order Little Endian
CPU(s) 24
On-line CPU(s) list 0-23
Thread(s) per core 2
Core(s) per socket 6
Socket(s) 2
NUMA node(s) 2
Vendor ID GenuineIntel
CPU family 6
Model 63
Model name Intel(R) Xeon(R) CPU E5-2620 v3 @ 2.40GHz
Stepping 2
CPU MHz 1200.000
CPU max MHz 2400.0000
CPU min MHz 1200.0000
BogoMIPS 4794.33
Virtualization VT-x
L1d cache 32K
L1i cache 32K
L2 cache 256K
L3 cache 15360K
NUMA node0 CPU(s) 0-5,12-17
NUMA node1 CPU(s) 6-11,18-23
Command: cat /proc/meminfo | grep -i -e 'memtotal\|memfree\|memavail\|buffers\|cached\|swapcached'
MemTotal 32643792 kB
MemFree 15470984 kB
MemAvailable 30033844 kB
Buffers 20 kB
Cached 16199876 kB
SwapCached 2496 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-12 04:07:49
DTS_END                         2024-04-12 04:07:49.3350
FB_GDSCODE                      -1
FB_MNEMONA                      
STACK                           SP_SUPPLIER_INVOICE(39:5) ==> X_MAKE_QSTORNO_1200_2000(279:25) ==> SP_CHECK_TO_STOP_WORK(32:12) ==> SP_HALT_ON_ERROR(68:17)
IP                              ::1/44416
TRN_ID                          165456
ATT_ID                          527
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: 9072.59 22638 907259
customer order: creation 170.07 462 17007
customer order: refuse 15.13 352 1513
order to supplier: creation 45.68 1340 4568
order to supplier: removal 3.42 85010 342
invoice (draft): creation 45.43 3524 4543
invoice (draft): removal 48.89 655 4889
invoice accept: apply 41.37 22166 4137
invoice accept: cancel 44.80 819 4480
customer reserve: creation 3934.72 216 393472
customer reserve: removal 4426.40 52 442640
realization accept: apply 82.07 214 8207
realization accept: cancel 86.69 119 8669
payment from customer: creation 59.16 152 5916
payment from customer: removal 5.51 69 551
payment to supplier: creation 49.03 167 4903
payment to supplier: removal 3.44 76 344
service: total inventory turnovers 3.87 3900 387
service: total monetary turnovers 5.87 494 587
service: aggregate perf. data 1.01 14853 101
service: refresh index statistics 0.03 318113 3

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:02, from 12-04-2024 04:10:11 to 12-04-2024 04:10:13.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 4922
TEST_TIME 2 4175
TEST_TIME 3 5102
TEST_TIME 4 5031
TEST_TIME 5 4918
TEST_TIME 6 4770
TEST_TIME 7 5497
TEST_TIME 8 5282
TEST_TIME 9 5617
TEST_TIME 10 6599
TEST_TIME 11 6961
TEST_TIME 12 7178
TEST_TIME 13 7185
TEST_TIME 14 7028
TEST_TIME 15 7090
TEST_TIME 16 7010
TEST_TIME 17 6942
TEST_TIME 18 6999
TEST_TIME 19 7152
TEST_TIME 20 7361
TEST_TIME 21 7829
TEST_TIME 22 7895
TEST_TIME 23 8481
TEST_TIME 24 8492
TEST_TIME 25 8563
TEST_TIME 26 9679
TEST_TIME 27 9667
TEST_TIME 28 9612
TEST_TIME 29 9307
TEST_TIME 30 9123
TEST_TIME 31 8940
TEST_TIME 32 9155
TEST_TIME 33 9417
TEST_TIME 34 9453
TEST_TIME 35 9370
TEST_TIME 36 9206
TEST_TIME 37 9398
TEST_TIME 38 9255
TEST_TIME 39 9117
TEST_TIME 40 9119
TEST_TIME 41 9086
TEST_TIME 42 9002
TEST_TIME 43 9187
TEST_TIME 44 9149
TEST_TIME 45 9151
TEST_TIME 46 9215
TEST_TIME 47 9303
TEST_TIME 48 9232
TEST_TIME 49 9247
TEST_TIME 50 9312
TEST_TIME 51 9420
TEST_TIME 52 9447
TEST_TIME 53 9506
TEST_TIME 54 9617
TEST_TIME 55 9497
TEST_TIME 56 9425
TEST_TIME 57 9308
TEST_TIME 58 9285
TEST_TIME 59 9312
TEST_TIME 60 9224
TEST_TIME 61 9215
TEST_TIME 62 9104
TEST_TIME 63 9144
TEST_TIME 64 9133
TEST_TIME 65 9129
TEST_TIME 66 9140
TEST_TIME 67 9197
TEST_TIME 68 9255
TEST_TIME 69 9228
TEST_TIME 70 9292
TEST_TIME 71 9304
TEST_TIME 72 9298
TEST_TIME 73 9305
TEST_TIME 74 9340
TEST_TIME 75 9379
TEST_TIME 76 9300
TEST_TIME 77 9187
TEST_TIME 78 9101
TEST_TIME 79 9081
TEST_TIME 80 9056
TEST_TIME 81 9080
TEST_TIME 82 9081
TEST_TIME 83 9099
TEST_TIME 84 9117
TEST_TIME 85 9150
TEST_TIME 86 9151
TEST_TIME 87 9184
TEST_TIME 88 9213
TEST_TIME 89 9181
TEST_TIME 90 9312
TEST_TIME 91 9292
TEST_TIME 92 9302
TEST_TIME 93 9330
TEST_TIME 94 9296
TEST_TIME 95 9287
TEST_TIME 96 9227
TEST_TIME 97 9193
TEST_TIME 98 9176
TEST_TIME 99 9134
TEST_TIME 100 9075

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:04, from 12-04-2024 04:10:14 to 12-04-2024 04:10:18.

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 1268330 1268330 0 0.00 0 27518 8 0 0
doc_list_biud 1268329 1268329 0 0.00 0 69878 23 0 0
sp_add_invoice_to_stock 4232 4137 95 2.24 26 196292 22166 0 95
sp_cancel_adding_invoice 4480 4480 0 0.00 5 64495 820 0 0
sp_cancel_client_order 1513 1513 0 0.00 4 11086 353 0 0
sp_cancel_customer_reserve 442640 442640 0 0.00 0 42070 53 0 0
sp_cancel_pay_from_customer 551 551 0 0.00 2 1611 69 0 0
sp_cancel_pay_to_supplier 344 344 0 0.00 3 1961 77 0 0
sp_cancel_supplier_invoice 4900 4889 11 0.22 1 69884 656 0 11
sp_cancel_supplier_order 342 342 0 0.00 6 835870 85010 0 0
sp_cancel_write_off 8669 8669 0 0.00 1 15830 119 0 0
sp_client_order 17007 17007 0 0.00 3 37944 463 0 0
sp_customer_reserve 393472 393472 0 0.00 0 55071 216 0 0
sp_fill_shopping_cart 26109 26109 0 0.00 1 15713 37 0 0
sp_fill_shopping_cart_clo_res 393468 393468 0 0.00 0 20685 16 0 0
sp_get_clo_for_invoice 4132 4132 0 0.00 0 28712 373 0 0
sp_kill_cost_storno 14044 14044 0 0.00 0 14710 67 0 0
sp_kill_qstorno_ret_qs2qd 899180 899180 0 0.00 0 69878 29 0 0
sp_kill_qty_storno 474872 474872 0 0.00 0 69878 62 0 0
sp_lock_selected_doc 17184 17184 0 0.00 0 9514 6 0 0
sp_make_cost_storno 23158 23158 0 0.00 0 27515 76 0 0
sp_multiply_rows_for_pdistr 23158 23158 0 0.00 0 15095 39 0 0
sp_multiply_rows_for_qdistr 17006 17006 0 0.00 0 37894 244 0 0
sp_pay_from_customer 5916 5916 0 0.00 4 18222 153 0 0
sp_pay_to_supplier 4903 4903 0 0.00 4 18440 168 0 0
sp_payment_common 10819 10819 0 0.00 1 18048 44 0 0
sp_qd_handle_on_cancel_clo 1513 1513 0 0.00 0 11067 329 0 0
sp_qd_handle_on_invoice_upd_sts 8612 8612 0 0.00 0 22120 294 0 0
sp_qd_handle_on_reserve_upd_sts 8207 8207 0 0.00 0 11277 59 0 0
sp_reserve_write_off 8207 8207 0 0.00 6 27524 215 0 0
sp_supplier_invoice 4543 4543 0 0.00 6 93702 3524 0 0
sp_supplier_order 4568 4568 0 0.00 4 34281 1341 0 0
srv_aggregate_perf_data 101 101 0 0.00 1404 173829 14853 0 0
srv_fill_mon_cache_memory 56 56 0 0.00 991 134246 40382 0 0
srv_find_qd_qs_mism 865747 865747 0 0.00 0 18556 7 0 0
srv_make_invnt_saldo 387 387 0 0.00 51 80229 3901 0 0
srv_make_money_saldo 587 587 0 0.00 0 14201 494 0 0
srv_recalc_idx_stat 3 3 0 0.00 168608 412168 318113 0 0
t$perf-abend:sp_add_invoice_to_stock 95 95 0 0.00 0 0 0 0 0
t$perf-abend:sp_cancel_supplier_invoice 11 11 0 0.00 0 0 0 0 0
t$perf-norm:sp_add_invoice_to_stock 4137 4137 0 0.00 0 19210 200 0 0
t$perf-norm:sp_cancel_adding_invoice 385 385 0 0.00 0 5013 111 0 0
t$perf-norm:sp_cancel_client_order 1513 1513 0 0.00 0 3463 12 0 0
t$perf-norm:sp_cancel_customer_reserve 551 551 0 0.00 0 2068 15 0 0
t$perf-norm:sp_cancel_pay_from_customer 551 551 0 0.00 0 413 5 0 0
t$perf-norm:sp_cancel_pay_to_supplier 344 344 0 0.00 0 770 5 0 0
t$perf-norm:sp_cancel_supplier_invoice 316 316 0 0.00 0 4534 46 0 0
t$perf-norm:sp_cancel_supplier_order 342 342 0 0.00 0 28757 1613 0 0
t$perf-norm:sp_cancel_write_off 843 843 0 0.00 0 4761 16 0 0
t$perf-norm:sp_client_order 17007 17007 0 0.00 0 12745 16 0 0
t$perf-norm:sp_customer_reserve 798 798 0 0.00 0 1479 8 0 0
t$perf-norm:sp_pay_from_customer 5916 5916 0 0.00 0 4805 9 0 0
t$perf-norm:sp_pay_to_supplier 4903 4903 0 0.00 0 10518 12 0 0
t$perf-norm:sp_reserve_write_off 8207 8207 0 0.00 0 14339 14 0 0
t$perf-norm:sp_supplier_invoice 4543 4543 0 0.00 0 6440 17 0 0
t$perf-norm:sp_supplier_order 4568 4568 0 0.00 0 7296 18 0 0
t$perf-norm:srv_aggregate_perf_data 101 101 0 0.00 0 360 11 0 0
t$perf-norm:srv_fill_mon_cache_memory 56 56 0 0.00 0 53 2 0 0
t$perf-norm:srv_make_invnt_saldo 387 387 0 0.00 0 4133 23 0 0
t$perf-norm:srv_make_money_saldo 587 587 0 0.00 0 2438 11 0 0
t$perf-norm:srv_recalc_idx_stat 3 3 0 0.00 1 7 3 0 0
v_add_invoice_to_stock 8454 8264 190 2.24 0 3792 15 0 190
v_all_customers 31674 31674 0 0.00 0 91 0 0 0
v_all_suppliers 25912 25912 0 0.00 0 30 1 0 0
v_all_wares 34008 34008 0 0.00 0 17 1 0 0
v_cancel_adding_invoice 770 770 0 0.00 0 1096 7 0 0
v_cancel_client_order 3026 3026 0 0.00 0 2916 5 0 0
v_cancel_customer_prepayment 1102 1102 0 0.00 0 1600 8 0 0
v_cancel_customer_reserve 1102 1102 0 0.00 0 2029 5 0 0
v_cancel_payment_to_supplier 688 688 0 0.00 0 419 3 0 0
v_cancel_supplier_invoice 654 632 22 3.36 0 607 11 0 22
v_cancel_supplier_order 684 684 0 0.00 0 394 3 0 0
v_cancel_write_off 1686 1686 0 0.00 0 4604 16 0 0
v_max_id_clo_ord 4566 4566 0 0.00 0 2249 2 0 0
v_max_id_clo_res 798 798 0 0.00 0 3747 15 0 0
v_max_id_ord_sup 4539 4539 0 0.00 0 4487 4 0 0
v_max_non_paid_invoice 1052 1052 0 0.00 0 8192 10 0 0
v_max_non_paid_realizn 2739 2739 0 0.00 0 1101 3 0 0
v_min_id_clo_ord 4566 4566 0 0.00 0 7210 11 0 0
v_min_id_clo_res 798 798 0 0.00 0 6540 19 0 0
v_min_id_ord_sup 4539 4539 0 0.00 0 7521 10 0 0
v_min_non_paid_invoice 4903 4903 0 0.00 0 18044 32 0 0
v_min_non_paid_realizn 5916 5916 0 0.00 0 17763 42 0 0
v_our_firm 8688 8688 0 0.00 0 36 1 0 0
v_reserve_write_off 16414 16414 0 0.00 0 4075 6 0 0
x_lock_depdocs_on_canc_invoice 9053 9053 0 0.00 0 25889 107 0 0
x_lock_depdocs_on_canc_sup_ord 342 342 0 0.00 0 6693 318 0 0
x_make_qstorno_1000_1200 4568 4568 0 0.00 1 34274 1259 0 0
x_make_qstorno_1200_2000 4543 4543 0 0.00 2 87626 3389 0 0
x_make_qstorno_2100_3300 393472 393472 0 0.00 0 52254 198 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 12-04-2024 04:10:19 to 12-04-2024 04:10:23.

Memory consumption, metadata cache, attachments activity 

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


Page cache type: shared, buffers: 1000000 for all connections, with total size: 8192000000
measurement_dts measurement duration ms page cache memo used memo used, total memo allocated, total metadata cache metadata cache percent of total total attachments cnt active attachments cnt running statements cnt stalled statements cnt memo used by attachments memo used by transactions memo used by statements
02:07:53 1 8192000000 8796662832 8807108608 3180608 0.038 1 1 2 0 3278224 61840 35776
02:08:54 29005 8192000000 9701232640 9998938112 779370960 8.687 100 91 182 0 809715184 7920416 22423808
02:10:29 14376 8192000000 9761090112 10068729856 836167824 9.261 100 90 178 0 868423376 12125888 20129664
02:11:49 19388 8192000000 9789527040 10110042112 861767328 9.518 100 79 158 0 895529936 16603648 17158960
02:13:13 15433 8192000000 9850894832 10184540160 905172384 9.950 100 83 166 0 955887008 33191712 17522912
02:14:32 4872 8192000000 9907351152 10245783552 940532128 10.298 100 85 168 0 1014247472 56651328 17064016
02:15:43 5461 8192000000 9928262448 10279997440 963795120 10.526 100 73 144 0 1045774160 67562896 14416144
02:16:51 5936 8192000000 9958758480 10317938688 996694128 10.846 100 83 166 0 1073407440 60355056 16358256
02:18:03 2002 8192000000 9980535200 10353102848 1024121680 11.112 100 74 146 1 1103327024 65078640 14126704
02:19:08 1282 8192000000 10023224304 10391932928 1036393504 11.230 100 80 160 0 1135397568 83499456 15504608
02:20:12 3034 8192000000 10008819968 10386620416 1055619776 11.415 100 82 163 1 1125983200 54556368 15807056
02:21:16 14508 8192000000 10022758768 10404372480 1062667552 11.482 100 69 132 2 1136527680 61478928 12381200
02:22:33 3237 8192000000 10008058592 10400628736 1067709744 11.530 100 54 108 0 1125810192 46921808 11178640
02:23:39 5429 8192000000 9981528320 10386821120 1070907232 11.561 100 35 70 0 1116204608 37422560 7874816
02:24:46 35042 8192000000 9999088896 10394075136 1078615584 11.634 100 62 125 0 1110387616 18889040 12882992
02:26:21 4752 8192000000 9987322992 10394587136 1084030880 11.686 100 37 74 1 1111007424 18564192 8412352
02:27:27 6780 8192000000 10007288384 10410565632 1088956096 11.733 100 35 70 1 1126451376 30101280 7394000
02:28:39 8821 8192000000 10027599696 10435166208 1093632816 11.777 100 48 97 1 1140819088 37145424 10040848
02:29:50 24422 8192000000 10052080880 10453868544 1081903840 11.666 98 52 102 0 1154146896 61957680 10285376
02:31:22 4507 8192000000 10062367584 10469048320 1102013984 11.857 99 51 101 1 1160259760 48445328 9800448
02:32:31 41806 8192000000 10105161648 10517381120 1114338192 11.973 99 42 84 0 1198429104 75483952 8606960
02:34:24 14242 8192000000 10106245600 10535608320 1116465472 11.994 100 44 88 0 1223769008 97955168 9348368
02:35:51 9210 8192000000 10144866048 10540322816 1088980848 11.733 99 61 122 0 1232221856 130575232 12665776
02:37:06 22497 8192000000 10080117600 10523721728 1068540400 11.538 98 36 72 0 1204554272 128406928 7606944
02:38:39 4955 8192000000 10099224416 10495676416 1091577392 11.758 99 51 102 0 1199936752 97798800 10560560
02:39:48 25994 8192000000 10090198688 10487459840 1057266320 11.430 96 50 100 0 1172255488 104098400 10890768
02:41:19 6719 8192000000 10095309936 10484924416 1077944096 11.628 99 67 132 2 1187238544 94904336 14390112
02:42:29 9831 8192000000 10130234032 10542379008 1083092800 11.677 100 45 86 0 1233921472 141733600 9095072
02:43:44 1254 8192000000 10150998768 10546339840 1093007632 11.771 99 50 101 0 1257035712 152634288 11393792
02:44:57 7350 8192000000 10190052112 10573348864 1071549504 11.567 99 57 114 0 1296266256 212050704 12666048
02:46:09 990 8192000000 10258742944 10647203840 1092635952 11.768 100 79 157 2 1360331440 250126480 17569008
02:47:19 3234 8192000000 10284463696 10675621888 1115178064 11.981 100 85 168 0 1383347008 250369168 17799776
02:48:28 3869 8192000000 10324101936 10743808000 1131372528 12.134 100 70 137 0 1417652080 271125856 15153696
02:49:36 11746 8192000000 10313228384 10743365632 1122021264 12.046 100 49 98 0 1406158480 273403120 10734096
02:50:54 21660 8192000000 10246896784 10695843840 1124233184 12.067 99 21 42 0 1344980832 216208384 4539264
02:52:18 26902 8192000000 10274414976 10740838400 1110552160 11.938 99 16 32 0 1367173680 252588704 4032816
02:53:50 45756 8192000000 10063508768 10498686976 1101586352 11.853 98 15 28 0 1154470496 50100656 2783488
02:55:48 134244 8192000000 10158391984 10587377664 1110810368 11.940 98 31 62 0 1235245536 117801056 6634112
02:59:03 7051 8192000000 10169627888 10587078656 1122091328 12.047 99 63 125 1 1259449104 124087600 13270176
03:00:12 14127 8192000000 10133329680 10564505600 1126187072 12.085 100 36 72 2 1232570304 99369664 7013568
03:01:28 76602 8192000000 10084438912 10526511104 1134297872 12.162 100 20 40 0 1164407536 26184528 3925136
03:04:46 39638 8192000000 10083620336 10548797440 1145544896 12.268 100 10 20 0 1191043856 43477616 2021344
03:06:27 73253 8192000000 10113242864 10564943872 1151603984 12.325 100 22 44 0 1193039264 36774048 4661232
03:08:42 48275 8192000000 10120576432 10582204416 1155664512 12.363 100 16 32 0 1228367776 69360624 3342640
03:10:33 58414 8192000000 10108940000 10571075584 1159536528 12.399 100 12 25 0 1222385120 60195552 2653040
03:12:32 49917 8192000000 10130741216 10580611072 1153130784 12.339 99 22 44 0 1223289024 65453408 4704832
03:14:44 28000 8192000000 10097818512 10531844096 1136504192 12.183 98 32 64 0 1170866272 28000656 6361424
03:16:14 20586 8192000000 10158421600 10601127936 1150374368 12.313 100 45 90 0 1251320800 91571584 9374848
03:17:35 42896 8192000000 10108138256 10540601344 1112437584 11.955 96 44 87 0 1176852656 56577744 7837328
03:19:23 28544 8192000000 10108385360 10545917952 1129908208 12.120 99 25 51 0 1200070752 65118944 5043600
03:20:52 68701 8192000000 10075965584 10555863040 1111842352 11.950 98 16 32 0 1191654784 76901856 2910576
03:23:08 60836 8192000000 10057748160 10492911616 1093919584 11.780 96 33 66 0 1117914864 17013952 6981328
03:25:14 45169 8192000000 10068523088 10493186048 1079270160 11.641 95 34 67 0 1128545712 42078592 7196960
03:27:11 52138 8192000000 10001347280 10431352832 1068565168 11.538 96 18 36 0 1102751136 30407744 3778224
03:29:04 53518 8192000000 10069154928 10524798976 1104784688 11.883 100 14 28 0 1159639920 52054224 2801008
03:31:04 32966 8192000000 10014715888 10439872512 1029996176 11.168 93 20 40 0 1077495680 43232320 4267184
03:32:49 33831 8192000000 10054067744 10479529984 1079494848 11.643 99 38 76 0 1134347952 47080672 7772432
03:34:24 78349 8192000000 10024743392 10477772800 1015875328 11.032 93 23 46 0 1077208752 56876736 4456688
03:36:43 71581 8192000000 10010223040 10453811200 1047774624 11.339 96 24 48 0 1106334096 53999216 4560256
03:39:07 45584 8192000000 10023331152 10453147648 1054234304 11.401 97 18 35 0 1081683072 24250272 3198496
03:40:53 24825 8192000000 10097493136 10536697856 1096278000 11.802 100 47 94 0 1192884240 87720416 8885824
03:42:21 99087 8192000000 10012850400 10465550336 1082086832 11.667 99 17 34 0 1142266000 56723776 3455392
03:45:36 36975 8192000000 10069460672 10532974592 1101197824 11.849 100 29 58 0 1171628944 64639280 5791840
03:47:31 77793 8192000000 10063666688 10559299584 1101906704 11.856 99 12 24 0 1194853680 90499104 2447872
03:49:49 80608 8192000000 10080047040 10570661888 1108533360 11.919 99 9 18 0 1161812384 51535216 1743808
03:52:13 44122 8192000000 10085871056 10536189952 1134612192 12.165 100 14 27 0 1183695888 46628720 2454976
03:54:10 61177 8192000000 10087936560 10559303680 1129973968 12.121 99 27 54 0 1201558032 66277600 5306464
03:56:16 51633 8192000000 10140522528 10587549696 1147147152 12.283 100 27 54 0 1201048800 48544368 5357280
03:58:13 53665 8192000000 10087116048 10521112576 1129434016 12.116 98 25 50 0 1157484080 22952176 5097888
04:00:22 73448 8192000000 10083442800 10520743936 1135561280 12.174 99 21 42 3 1172639664 33266848 3811536
04:02:40 118167 8192000000 10071320688 10517680128 1126651216 12.090 99 29 57 0 1178498384 46402768 5444400
04:05:39 52222 8192000000 10094375936 10569445376 1150424864 12.313 100 10 20 0 1206896032 54572416 1898752
04:07:32 27609 8192000000 9407183424 9760890880 540038848 6.184 48 2 4 0 566471632 26121536 311248

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:14, from 12-04-2024 04:10:25 to 12-04-2024 04:10:39.

Exceptions occured during test was in run

FB_MNEMONA CNT UNIT FB_GDSCODE
except 95 v_add_invoice_to_stock 335544517
except 11 v_cancel_supplier_invoice 335544517

Completed "Exceptions occured during test was in run". Done for 00:00:02, from 12-04-2024 04:10:40 to 12-04-2024 04:10:42.

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          165701
MON$OLDEST_ACTIVE               165702
MON$OLDEST_SNAPSHOT             165702
MON$NEXT_TRANSACTION            165702
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                       1909280
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             674
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 Fri Apr 12 04:10:43 2024 
 
Database header page information: 
    Flags            0 
    Generation        87049 
    System Change Number    0 
    Page size        8192 
    ODS version        13.0 
    Oldest transaction    165701 
    Oldest active        165702 
    Oldest snapshot        165702 
    Next transaction    165703 
    Sequence number        0 
    Next attachment ID    674 
    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.71, total records: 7645914 
    Average version length: 48.15, total versions: 35503, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 64.00, compression ratio: 1.34 
    Pointer pages: 55, data page slots: 88552 
    Data pages: 88552, average fill: 69% 
    Primary pages: 88551, secondary pages: 1, swept pages: 50268 
    Empty pages: 3, full pages: 53650 
    Fill distribution: 
     0 - 19% = 22 
    20 - 39% = 122 
    40 - 59% = 2819 
    60 - 79% = 85576 
    80 - 99% = 13 
 
    Index DOC_DATA_DOC_WARE_UNQ (0) 
    Root page: 1510636, depth: 3, leaf buckets: 22970, nodes: 7645914 
    Average node length: 18.84, total dup: 0, max dup: 0 
    Average key length: 15.85, compression ratio: 1.70 
    Average prefix length: 14.14, average data length: 12.86 
    Clustering factor: 1646404, ratio: 0.22 
    Fill distribution: 
         0 - 19% = 310 
        20 - 39% = 1968 
        40 - 59% = 3856 
        60 - 79% = 2521 
        80 - 99% = 14315 
 
    Index DOC_DATA_ID_DESC (1) 
    Root page: 1528140, depth: 3, leaf buckets: 13358, nodes: 7645914 
    Average node length: 11.20, total dup: 0, max dup: 0 
    Average key length: 8.21, compression ratio: 1.10 
    Average prefix length: 3.78, average data length: 5.22 
    Clustering factor: 1470621, ratio: 0.19 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 1656 
        40 - 59% = 1859 
        60 - 79% = 1177 
        80 - 99% = 8666 
 
    Index FK_DOC_DATA_DOC_LIST (2) 
    Root page: 1546735, depth: 3, leaf buckets: 8211, nodes: 7645914 
    Average node length: 6.59, total dup: 5750252, max dup: 49 
    Average key length: 3.60, compression ratio: 2.50 
    Average prefix length: 7.64, average data length: 1.36 
    Clustering factor: 1463791, ratio: 0.19 
    Fill distribution: 
         0 - 19% = 105 
        20 - 39% = 1030 
        40 - 59% = 1270 
        60 - 79% = 986 
        80 - 99% = 4820 
 
DOC_LIST (138) 
    Primary pointer page: 500, Index root page: 501 
    Total formats: 1, used formats: 1 
    Average record length: 56.98, total records: 2186549 
    Average version length: 58.86, total versions: 19244, max versions: 2 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 84.00, compression ratio: 1.47 
    Pointer pages: 18, data page slots: 28480 
    Data pages: 28480, average fill: 71% 
    Primary pages: 28478, secondary pages: 2, swept pages: 15601 
    Empty pages: 6, full pages: 13642 
    Fill distribution: 
     0 - 19% = 11 
    20 - 39% = 46 
    40 - 59% = 842 
    60 - 79% = 27549 
    80 - 99% = 32 
 
    Index DOC_LIST_ID_DESC (1) 
    Root page: 1541152, depth: 3, leaf buckets: 4459, nodes: 2186549 
    Average node length: 11.41, total dup: 0, max dup: 0 
    Average key length: 8.45, compression ratio: 1.06 
    Average prefix length: 3.54, average data length: 5.46 
    Clustering factor: 672247, ratio: 0.31 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 922 
        40 - 59% = 783 
        60 - 79% = 781 
        80 - 99% = 1973 
 
    Index DOC_LIST_WORKER_OPTYPE (2) 
    Root page: 1544398, depth: 3, leaf buckets: 2407, nodes: 2187321 
    Average node length: 4.97, total dup: 2186422, max dup: 19777 
    Average key length: 2.01, compression ratio: 4.47 
    Average prefix length: 8.99, average data length: 0.01 
    Clustering factor: 1245498, ratio: 0.57 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 260 
        40 - 59% = 1384 
        60 - 79% = 541 
        80 - 99% = 220 
 
    Index FK_DOC_LIST_AGENTS (3) 
    Root page: 1545933, depth: 3, leaf buckets: 1755, nodes: 2186549 
    Average node length: 4.97, total dup: 2186499, max dup: 130016 
    Average key length: 2.01, compression ratio: 4.48 
    Average prefix length: 8.99, average data length: 0.01 
    Clustering factor: 1048741, ratio: 0.48 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 3 
        40 - 59% = 603 
        60 - 79% = 39 
        80 - 99% = 1109 
 
    Index PK_DOC_LIST (0) 
    Root page: 1538209, depth: 3, leaf buckets: 4293, nodes: 2186549 
    Average node length: 11.41, total dup: 0, max dup: 0 
    Average key length: 8.45, compression ratio: 1.06 
    Average prefix length: 3.54, average data length: 5.46 
    Clustering factor: 672247, ratio: 0.31 
    Fill distribution: 
         0 - 19% = 95 
        20 - 39% = 639 
        40 - 59% = 602 
        60 - 79% = 851 
        80 - 99% = 2106 
 
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.28, total records: 400 
    Average version length: 32.28, total versions: 2359, max versions: 6 
    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: 60% 
    Primary pages: 14, secondary pages: 18, swept pages: 0 
    Empty pages: 7, full pages: 19 
    Fill distribution: 
     0 - 19% = 11 
    20 - 39% = 1 
    40 - 59% = 0 
    60 - 79% = 3 
    80 - 99% = 17 
 
    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: 10.43, total records: 79402 
    Average version length: 68.26, total versions: 77482, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 88.00, compression ratio: 8.44 
    Pointer pages: 7, data page slots: 3056 
    Data pages: 1520, average fill: 71% 
    Primary pages: 1519, secondary pages: 1, swept pages: 61 
    Empty pages: 153, full pages: 994 
    Fill distribution: 
     0 - 19% = 202 
    20 - 39% = 76 
    40 - 59% = 119 
    60 - 79% = 220 
    80 - 99% = 903 
 
    Index INVNT_TURNOVER_LOG_WARE_DD_ID (0) 
    Root page: 1694027, depth: 3, leaf buckets: 358, nodes: 79402 
    Average node length: 13.70, total dup: 3269, max dup: 1 
    Average key length: 10.88, compression ratio: 2.48 
    Average prefix length: 19.08, average data length: 7.92 
    Clustering factor: 59767, ratio: 0.75 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 272 
        40 - 59% = 58 
        60 - 79% = 26 
        80 - 99% = 0 
 
MONEY_SALDO (141) 
    Primary pointer page: 506, Index root page: 507 
    Total formats: 1, used formats: 1 
    Average record length: 15.22, total records: 49 
    Average version length: 9.00, total versions: 228, max versions: 8 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 32.00, compression ratio: 2.10 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 92% 
    Primary pages: 1, 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% = 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: 9.99, total records: 1466 
    Average version length: 43.11, total versions: 1423, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 58.00, compression ratio: 5.81 
    Pointer pages: 1, data page slots: 56 
    Data pages: 40, average fill: 40% 
    Primary pages: 39, secondary pages: 1, swept pages: 5 
    Empty pages: 14, full pages: 13 
    Fill distribution: 
     0 - 19% = 18 
    20 - 39% = 3 
    40 - 59% = 4 
    60 - 79% = 5 
    80 - 99% = 10 
 
    Index MONEY_TURNOVER_LOG_AGENT_OPTYPE (0) 
    Root page: 91196, depth: 2, leaf buckets: 2, nodes: 1466 
    Average node length: 4.30, total dup: 1368, max dup: 159 
    Average key length: 2.71, compression ratio: 7.01 
    Average prefix length: 18.36, average data length: 0.64 
    Clustering factor: 847, ratio: 0.58 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 1 
        40 - 59% = 1 
        60 - 79% = 0 
        80 - 99% = 0 
 
MON_CACHE_MEMORY (165) 
    Primary pointer page: 555, Index root page: 556 
    Total formats: 2, used formats: 1 
    Average record length: 97.63, total records: 73 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 112.00, compression ratio: 1.15 
    Pointer pages: 1, data page slots: 2 
    Data pages: 2, average fill: 51% 
    Primary pages: 2, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 1 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 1 
    40 - 59% = 0 
    60 - 79% = 1 
    80 - 99% = 0 
 
    Index PK_MON_CACHE_MEMORY (0) 
    Root page: 1504238, depth: 1, leaf buckets: 1, nodes: 73 
    Average node length: 11.68, total dup: 0, max dup: 0 
    Average key length: 10.67, compression ratio: 0.84 
    Average prefix length: 1.32, average data length: 7.68 
    Clustering factor: 2, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
MON_LOG (162) 
    Primary pointer page: 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.76, total records: 843906 
    Average version length: 37.93, total versions: 21366, max versions: 3 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 54.00, compression ratio: 1.47 
    Pointer pages: 6, data page slots: 9000 
    Data pages: 9000, average fill: 64% 
    Primary pages: 8998, secondary pages: 2, swept pages: 3417 
    Empty pages: 11, full pages: 5139 
    Fill distribution: 
     0 - 19% = 35 
    20 - 39% = 79 
    40 - 59% = 952 
    60 - 79% = 7897 
    80 - 99% = 37 
 
    Index PDISTR_AGENT_ID (2) 
    Root page: 1509330, depth: 2, leaf buckets: 920, nodes: 832950 
    Average node length: 4.89, total dup: 832901, max dup: 162262 
    Average key length: 2.01, compression ratio: 4.48 
    Average prefix length: 8.99, average data length: 0.01 
    Clustering factor: 91820, ratio: 0.11 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 149 
        40 - 59% = 506 
        60 - 79% = 173 
        80 - 99% = 91 
 
    Index PDISTR_SNDOP_RCVOP_SNDID_ASC (0) 
    Root page: 1508635, depth: 3, leaf buckets: 1011, nodes: 832950 
    Average node length: 5.90, total dup: 741472, max dup: 42 
    Average key length: 3.02, compression ratio: 7.28 
    Average prefix length: 21.09, average data length: 0.91 
    Clustering factor: 164441, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 30 
        40 - 59% = 654 
        60 - 79% = 72 
        80 - 99% = 253 
 
    Index PDISTR_SNDOP_RCVOP_SNDID_DESC (1) 
    Root page: 1509209, depth: 3, leaf buckets: 1027, nodes: 832950 
    Average node length: 5.90, total dup: 741472, max dup: 42 
    Average key length: 3.02, compression ratio: 7.28 
    Average prefix length: 21.09, average data length: 0.91 
    Clustering factor: 166265, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 65 
        40 - 59% = 645 
        60 - 79% = 60 
        80 - 99% = 257 
 
    Index PDISTR_WORKER_SND_ID (3) 
    Root page: 1510200, depth: 3, leaf buckets: 1152, nodes: 832950 
    Average node length: 5.98, total dup: 741472, max dup: 42 
    Average key length: 3.10, compression ratio: 5.48 
    Average prefix length: 16.01, average data length: 0.99 
    Clustering factor: 158257, ratio: 0.19 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 210 
        40 - 59% = 601 
        60 - 79% = 246 
        80 - 99% = 94 
 
PERF_AGG (158) 
    Primary pointer page: 540, Index root page: 541 
    Total formats: 1, used formats: 1 
    Average record length: 62.77, total records: 5443 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 3.88, total fragments: 25, max fragments: 1 
    Average unpacked length: 379.00, compression ratio: 6.04 
    Pointer pages: 1, data page slots: 96 
    Data pages: 96, average fill: 56% 
    Primary pages: 78, secondary pages: 18, swept pages: 56 
    Empty pages: 10, full pages: 58 
    Fill distribution: 
     0 - 19% = 22 
    20 - 39% = 0 
    40 - 59% = 2 
    60 - 79% = 72 
    80 - 99% = 0 
 
    Index PERF_AGG_UNQ (1) 
    Root page: 1504260, depth: 2, leaf buckets: 6, nodes: 5443 
    Average node length: 5.52, total dup: 0, max dup: 0 
    Average key length: 3.59, compression ratio: 10.02 
    Average prefix length: 34.40, average data length: 1.55 
    Clustering factor: 5159, ratio: 0.95 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 0 
        40 - 59% = 4 
        60 - 79% = 0 
        80 - 99% = 2 
 
    Index PK_PERF_AGG (0) 
    Root page: 1504255, depth: 2, leaf buckets: 10, nodes: 5443 
    Average node length: 11.14, 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: 166, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 1 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 7 
 
PERF_ESTIMATED (280) 
    Primary pointer page: 399, Index root page: 434 
    Total formats: 1, used formats: 1 
    Average record length: 39.04, total records: 75577 
    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: 792 
    Data pages: 792, average fill: 65% 
    Primary pages: 792, secondary pages: 0, swept pages: 0 
    Empty pages: 7, full pages: 784 
    Fill distribution: 
     0 - 19% = 7 
    20 - 39% = 0 
    40 - 59% = 1 
    60 - 79% = 784 
    80 - 99% = 0 
 
    Index PK_PERF_ESTIMATED (0) 
    Root page: 31006, depth: 2, leaf buckets: 98, nodes: 75577 
    Average node length: 10.18, total dup: 0, max dup: 0 
    Average key length: 8.19, compression ratio: 1.10 
    Average prefix length: 3.81, average data length: 5.19 
    Clustering factor: 3076, ratio: 0.04 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 1 
        40 - 59% = 2 
        60 - 79% = 0 
        80 - 99% = 94 
 
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.08, 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.22 
    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.08, total records: 163425 
    Average version length: 152.80, total versions: 11618, 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: 4880 
    Data pages: 4072, average fill: 84% 
    Primary pages: 4070, secondary pages: 2, swept pages: 26 
    Empty pages: 49, full pages: 4010 
    Fill distribution: 
     0 - 19% = 51 
    20 - 39% = 4 
    40 - 59% = 3 
    60 - 79% = 2 
    80 - 99% = 4012 
 
PERF_SPLIT_1 (282) 
    Primary pointer page: 603, Index root page: 604 
    Total formats: 1, used formats: 1 
    Average record length: 133.34, total records: 147540 
    Average version length: 153.99, total versions: 18386, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 12.72 
    Pointer pages: 7, data page slots: 3984 
    Data pages: 3688, average fill: 84% 
    Primary pages: 3686, secondary pages: 2, swept pages: 27 
    Empty pages: 51, full pages: 3621 
    Fill distribution: 
     0 - 19% = 54 
    20 - 39% = 6 
    40 - 59% = 4 
    60 - 79% = 3 
    80 - 99% = 3621 
 
PERF_SPLIT_2 (283) 
    Primary pointer page: 605, Index root page: 606 
    Total formats: 1, used formats: 1 
    Average record length: 144.84, total records: 163906 
    Average version length: 151.06, total versions: 7545, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.71 
    Pointer pages: 6, data page slots: 4408 
    Data pages: 4120, average fill: 83% 
    Primary pages: 4118, secondary pages: 2, swept pages: 33 
    Empty pages: 77, full pages: 4020 
    Fill distribution: 
     0 - 19% = 77 
    20 - 39% = 11 
    40 - 59% = 5 
    60 - 79% = 7 
    80 - 99% = 4020 
 
PERF_SPLIT_3 (284) 
    Primary pointer page: 607, Index root page: 616 
    Total formats: 1, used formats: 1 
    Average record length: 141.34, total records: 149719 
    Average version length: 151.95, total versions: 10062, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 12.00 
    Pointer pages: 6, data page slots: 5168 
    Data pages: 3776, average fill: 82% 
    Primary pages: 3773, secondary pages: 3, swept pages: 55 
    Empty pages: 83, full pages: 3654 
    Fill distribution: 
     0 - 19% = 86 
    20 - 39% = 7 
    40 - 59% = 23 
    60 - 79% = 6 
    80 - 99% = 3654 
 
PERF_SPLIT_4 (285) 
    Primary pointer page: 617, Index root page: 618 
    Total formats: 1, used formats: 1 
    Average record length: 144.64, total records: 156568 
    Average version length: 151.53, total versions: 7076, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.73 
    Pointer pages: 7, data page slots: 6328 
    Data pages: 3928, average fill: 83% 
    Primary pages: 3926, secondary pages: 2, swept pages: 53 
    Empty pages: 72, full pages: 3830 
    Fill distribution: 
     0 - 19% = 76 
    20 - 39% = 9 
    40 - 59% = 9 
    60 - 79% = 5 
    80 - 99% = 3829 
 
PERF_SPLIT_5 (286) 
    Primary pointer page: 619, Index root page: 620 
    Total formats: 1, used formats: 1 
    Average record length: 136.31, total records: 159364 
    Average version length: 153.93, total versions: 16532, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 12.44 
    Pointer pages: 5, data page slots: 5904 
    Data pages: 4008, average fill: 83% 
    Primary pages: 4006, secondary pages: 2, swept pages: 58 
    Empty pages: 78, full pages: 3902 
    Fill distribution: 
     0 - 19% = 80 
    20 - 39% = 5 
    40 - 59% = 6 
    60 - 79% = 15 
    80 - 99% = 3902 
 
PERF_SPLIT_6 (287) 
    Primary pointer page: 621, Index root page: 622 
    Total formats: 1, used formats: 1 
    Average record length: 134.09, total records: 149426 
    Average version length: 153.91, total versions: 17572, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 12.65 
    Pointer pages: 6, data page slots: 4288 
    Data pages: 3776, average fill: 83% 
    Primary pages: 3774, secondary pages: 2, swept pages: 37 
    Empty pages: 92, full pages: 3657 
    Fill distribution: 
     0 - 19% = 98 
    20 - 39% = 7 
    40 - 59% = 6 
    60 - 79% = 9 
    80 - 99% = 3656 
 
PERF_SPLIT_7 (288) 
    Primary pointer page: 626, Index root page: 627 
    Total formats: 1, used formats: 1 
    Average record length: 145.85, total records: 155550 
    Average version length: 150.38, total versions: 5697, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.63 
    Pointer pages: 6, data page slots: 6664 
    Data pages: 3896, average fill: 83% 
    Primary pages: 3894, secondary pages: 2, swept pages: 15 
    Empty pages: 66, full pages: 3813 
    Fill distribution: 
     0 - 19% = 71 
    20 - 39% = 7 
    40 - 59% = 3 
    60 - 79% = 1 
    80 - 99% = 3814 
 
PERF_SPLIT_8 (289) 
    Primary pointer page: 628, Index root page: 629 
    Total formats: 1, used formats: 1 
    Average record length: 139.33, total records: 153921 
    Average version length: 152.78, total versions: 12889, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 12.17 
    Pointer pages: 7, data page slots: 4520 
    Data pages: 3888, average fill: 83% 
    Primary pages: 3886, secondary pages: 2, swept pages: 15 
    Empty pages: 88, full pages: 3773 
    Fill distribution: 
     0 - 19% = 91 
    20 - 39% = 8 
    40 - 59% = 10 
    60 - 79% = 7 
    80 - 99% = 3772 
 
PERF_SPLIT_9 (290) 
    Primary pointer page: 630, Index root page: 631 
    Total formats: 1, used formats: 1 
    Average record length: 142.23, total records: 158742 
    Average version length: 151.94, total versions: 9999, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.92 
    Pointer pages: 8, data page slots: 4872 
    Data pages: 4024, average fill: 82% 
    Primary pages: 4022, secondary pages: 2, swept pages: 60 
    Empty pages: 104, full pages: 3883 
    Fill distribution: 
     0 - 19% = 107 
    20 - 39% = 12 
    40 - 59% = 8 
    60 - 79% = 16 
    80 - 99% = 3881 
 
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.39, total records: 2028823 
    Average version length: 52.93, total versions: 15950, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 70.00, compression ratio: 1.34 
    Pointer pages: 16, data page slots: 25664 
    Data pages: 25640, average fill: 68% 
    Primary pages: 25624, secondary pages: 16, swept pages: 14207 
    Empty pages: 258, full pages: 19031 
    Fill distribution: 
     0 - 19% = 525 
    20 - 39% = 504 
    40 - 59% = 1643 
    60 - 79% = 22850 
    80 - 99% = 118 
 
    Index PSTORNED_RCV_ID (1) 
    Root page: 1506208, depth: 3, leaf buckets: 2540, nodes: 2028823 
    Average node length: 5.45, total dup: 1890872, max dup: 1416 
    Average key length: 2.50, compression ratio: 3.61 
    Average prefix length: 8.57, average data length: 0.43 
    Clustering factor: 176987, ratio: 0.09 
    Fill distribution: 
         0 - 19% = 8 
        20 - 39% = 332 
        40 - 59% = 1643 
        60 - 79% = 276 
        80 - 99% = 281 
 
    Index PSTORNED_SND_ID (0) 
    Root page: 1504841, depth: 3, leaf buckets: 2749, nodes: 2028823 
    Average node length: 5.70, total dup: 1819762, max dup: 65 
    Average key length: 2.74, compression ratio: 3.28 
    Average prefix length: 8.36, average data length: 0.64 
    Clustering factor: 363864, ratio: 0.18 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 12 
        40 - 59% = 2549 
        60 - 79% = 167 
        80 - 99% = 21 
 
    Index PSTORNED_WORKER_ID (2) 
    Root page: 1508018, depth: 3, leaf buckets: 2046, nodes: 2028823 
    Average node length: 4.96, total dup: 2028723, max dup: 28074 
    Average key length: 2.00, compression ratio: 1.20 
    Average prefix length: 2.41, average data length: 0.00 
    Clustering factor: 175030, ratio: 0.09 
    Fill distribution: 
         0 - 19% = 4 
        20 - 39% = 203 
        40 - 59% = 1018 
        60 - 79% = 384 
        80 - 99% = 437 
 
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.68, total records: 138989 
    Average version length: 69.18, total versions: 54362, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 2.76 
    Pointer pages: 3, data page slots: 4040 
    Data pages: 3024, average fill: 55% 
    Primary pages: 3023, secondary pages: 1, swept pages: 346 
    Empty pages: 320, full pages: 1184 
    Fill distribution: 
     0 - 19% = 484 
    20 - 39% = 308 
    40 - 59% = 595 
    60 - 79% = 1010 
    80 - 99% = 627 
 
    Index XQD_1000_1200_WA_SO_RO_WKR_SND (0) 
    Root page: 103505, depth: 3, leaf buckets: 232, nodes: 138989 
    Average node length: 6.52, total dup: 120815, max dup: 14 
    Average key length: 3.98, compression ratio: 10.56 
    Average prefix length: 40.15, average data length: 1.85 
    Clustering factor: 24277, ratio: 0.17 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 58 
        40 - 59% = 120 
        60 - 79% = 50 
        80 - 99% = 2 
 
XQD_1000_3300 (178) 
    Primary pointer page: 581, Index root page: 582 
    Total formats: 1, used formats: 1 
    Average record length: 66.56, total records: 7160232 
    Average version length: 68.72, total versions: 284209, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.89 
    Pointer pages: 68, data page slots: 110360 
    Data pages: 110360, average fill: 70% 
    Primary pages: 110359, secondary pages: 1, swept pages: 43524 
    Empty pages: 21, full pages: 50188 
    Fill distribution: 
     0 - 19% = 137 
    20 - 39% = 856 
    40 - 59% = 10403 
    60 - 79% = 98131 
    80 - 99% = 833 
 
    Index XQD_1000_3300_WA_SO_RO_WKR_SND (0) 
    Root page: 1480476, depth: 3, leaf buckets: 10778, nodes: 7160232 
    Average node length: 6.51, total dup: 6191767, max dup: 29 
    Average key length: 3.52, compression ratio: 11.92 
    Average prefix length: 40.61, average data length: 1.39 
    Clustering factor: 1647864, ratio: 0.23 
    Fill distribution: 
         0 - 19% = 10 
        20 - 39% = 1591 
        40 - 59% = 5809 
        60 - 79% = 2849 
        80 - 99% = 519 
 
    Index XQD_1000_3300_WKR_DOC_ASC (1) 
    Root page: 1486090, depth: 3, leaf buckets: 8548, nodes: 7160232 
    Average node length: 5.39, total dup: 6877989, max dup: 173 
    Average key length: 2.40, compression ratio: 7.08 
    Average prefix length: 16.64, average data length: 0.36 
    Clustering factor: 1454416, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 12 
        20 - 39% = 1036 
        40 - 59% = 4873 
        60 - 79% = 1639 
        80 - 99% = 988 
 
    Index XQD_1000_3300_WKR_DOC_DEC (2) 
    Root page: 1490630, depth: 3, leaf buckets: 8615, nodes: 7160232 
    Average node length: 5.39, total dup: 6877989, max dup: 173 
    Average key length: 2.40, compression ratio: 7.08 
    Average prefix length: 16.64, average data length: 0.36 
    Clustering factor: 1456666, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 11 
        20 - 39% = 1086 
        40 - 59% = 4843 
        60 - 79% = 1712 
        80 - 99% = 963 
 
XQD_1200_2000 (177) 
    Primary pointer page: 579, Index root page: 580 
    Total formats: 1, used formats: 1 
    Average record length: 67.94, total records: 12120334 
    Average version length: 68.67, total versions: 200801, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.85 
    Pointer pages: 110, data page slots: 178032 
    Data pages: 178032, average fill: 72% 
    Primary pages: 178032, secondary pages: 0, swept pages: 99126 
    Empty pages: 1, full pages: 127524 
    Fill distribution: 
     0 - 19% = 34 
    20 - 39% = 604 
    40 - 59% = 7072 
    60 - 79% = 169255 
    80 - 99% = 1067 
 
    Index XQD_1200_2000_WA_SO_RO_WKR_SND (0) 
    Root page: 1495050, depth: 3, leaf buckets: 18405, nodes: 12119569 
    Average node length: 6.63, total dup: 10562553, max dup: 52 
    Average key length: 3.43, compression ratio: 12.25 
    Average prefix length: 40.70, average data length: 1.30 
    Clustering factor: 2449923, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 24 
        20 - 39% = 2130 
        40 - 59% = 10712 
        60 - 79% = 4717 
        80 - 99% = 822 
 
XQD_2000_3300 (179) 
    Primary pointer page: 583, Index root page: 584 
    Total formats: 1, used formats: 1 
    Average record length: 56.93, total records: 1291111 
    Average version length: 69.02, total versions: 190405, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 2.21 
    Pointer pages: 24, data page slots: 38616 
    Data pages: 29429, average fill: 47% 
    Primary pages: 29360, secondary pages: 69, swept pages: 14039 
    Empty pages: 5057, full pages: 13166 
    Fill distribution: 
     0 - 19% = 8103 
    20 - 39% = 3591 
    40 - 59% = 3071 
    60 - 79% = 12626 
    80 - 99% = 2038 
 
    Index XQD_2000_3300_WA_SO_RO_WKR_SND (0) 
    Root page: 1479735, depth: 3, leaf buckets: 1815, nodes: 1219934 
    Average node length: 5.55, total dup: 1170342, max dup: 49 
    Average key length: 2.58, compression ratio: 16.30 
    Average prefix length: 41.46, average data length: 0.54 
    Clustering factor: 86968, ratio: 0.07 
    Fill distribution: 
         0 - 19% = 13 
        20 - 39% = 613 
        40 - 59% = 875 
        60 - 79% = 290 
        80 - 99% = 24 
 
XQD_2100_3300 (180) 
    Primary pointer page: 585, Index root page: 586 
    Total formats: 1, used formats: 1 
    Average record length: 46.27, total records: 959165 
    Average version length: 69.00, total versions: 129249, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 2.72 
    Pointer pages: 22, data page slots: 34728 
    Data pages: 28800, average fill: 33% 
    Primary pages: 28800, secondary pages: 0, swept pages: 9145 
    Empty pages: 5244, full pages: 3587 
    Fill distribution: 
     0 - 19% = 9668 
    20 - 39% = 7131 
    40 - 59% = 7926 
    60 - 79% = 4006 
    80 - 99% = 69 
 
    Index XQD_2100_3300_WA_SO_RO_WKR_SND (0) 
    Root page: 1479229, depth: 3, leaf buckets: 1206, nodes: 725180 
    Average node length: 5.96, total dup: 667908, max dup: 52 
    Average key length: 3.03, compression ratio: 13.88 
    Average prefix length: 41.05, average data length: 0.95 
    Clustering factor: 103461, ratio: 0.14 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 477 
        40 - 59% = 570 
        60 - 79% = 152 
        80 - 99% = 6 
 
XQD_3300_3400 (181) 
    Primary pointer page: 587, Index root page: 588 
    Total formats: 1, used formats: 1 
    Average record length: 67.92, total records: 8695570 
    Average version length: 68.96, total versions: 138147, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.86 
    Pointer pages: 87, data page slots: 140664 
    Data pages: 140648, average fill: 66% 
    Primary pages: 140630, secondary pages: 18, swept pages: 85207 
    Empty pages: 187, full pages: 47799 
    Fill distribution: 
     0 - 19% = 862 
    20 - 39% = 4632 
    40 - 59% = 25076 
    60 - 79% = 109366 
    80 - 99% = 712 
 
    Index XQD_3300_3400_WA_SO_RO_WKR_SND (0) 
    Root page: 1472612, depth: 3, leaf buckets: 13429, nodes: 8694310 
    Average node length: 6.67, total dup: 7212023, max dup: 14 
    Average key length: 3.67, compression ratio: 11.43 
    Average prefix length: 40.50, average data length: 1.50 
    Clustering factor: 1996821, ratio: 0.23 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 1906 
        40 - 59% = 7319 
        60 - 79% = 3813 
        80 - 99% = 389 
 
XQS_1000_1200 (182) 
    Primary pointer page: 589, Index root page: 590 
    Total formats: 1, used formats: 1 
    Average record length: 82.52, total records: 21088737 
    Average version length: 82.94, total versions: 4591, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.53 
    Pointer pages: 196, data page slots: 319016 
    Data pages: 319016, average fill: 81% 
    Primary pages: 319011, secondary pages: 5, swept pages: 14032 
    Empty pages: 40, full pages: 317553 
    Fill distribution: 
     0 - 19% = 96 
    20 - 39% = 73 
    40 - 59% = 220 
    60 - 79% = 48430 
    80 - 99% = 270197 
 
    Index XQS_1000_1200_DOC_ID (1) 
    Root page: 1426738, depth: 3, leaf buckets: 19268, nodes: 21088737 
    Average node length: 5.72, total dup: 20609187, max dup: 128 
    Average key length: 2.16, compression ratio: 4.16 
    Average prefix length: 8.86, average data length: 0.14 
    Clustering factor: 3274834, ratio: 0.16 
    Fill distribution: 
         0 - 19% = 4 
        20 - 39% = 0 
        40 - 59% = 7995 
        60 - 79% = 559 
        80 - 99% = 10710 
 
    Index XQS_1000_1200_RCV_ID (3) 
    Root page: 1457002, depth: 3, leaf buckets: 17115, nodes: 21088737 
    Average node length: 6.31, total dup: 18533465, max dup: 49 
    Average key length: 2.75, compression ratio: 3.27 
    Average prefix length: 8.37, average data length: 0.63 
    Clustering factor: 915257, ratio: 0.04 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 4 
        40 - 59% = 775 
        60 - 79% = 267 
        80 - 99% = 16069 
 
    Index XQS_1000_1200_SND_ID (2) 
    Root page: 1441095, depth: 3, leaf buckets: 21003, nodes: 21088737 
    Average node length: 6.35, total dup: 18452016, max dup: 29 
    Average key length: 2.79, compression ratio: 3.23 
    Average prefix length: 8.34, average data length: 0.66 
    Clustering factor: 3567692, ratio: 0.17 
    Fill distribution: 
         0 - 19% = 5 
        20 - 39% = 0 
        40 - 59% = 8198 
        60 - 79% = 580 
        80 - 99% = 12220 
 
    Index XQS_1000_1200_WORKER_ID (0) 
    Root page: 1413370, depth: 3, leaf buckets: 15973, nodes: 21088737 
    Average node length: 5.56, total dup: 21088637, max dup: 228989 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.42, average data length: 0.00 
    Clustering factor: 943892, ratio: 0.04 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 7 
        40 - 59% = 2747 
        60 - 79% = 328 
        80 - 99% = 12890 
 
XQS_1000_3300 (184) 
    Primary pointer page: 593, Index root page: 594 
    Total formats: 1, used formats: 1 
    Average record length: 81.44, total records: 9122927 
    Average version length: 82.54, total versions: 119290, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.55 
    Pointer pages: 103, data page slots: 167304 
    Data pages: 167296, average fill: 67% 
    Primary pages: 167272, secondary pages: 24, swept pages: 110485 
    Empty pages: 592, full pages: 75587 
    Fill distribution: 
     0 - 19% = 1998 
    20 - 39% = 8081 
    40 - 59% = 28018 
    60 - 79% = 115183 
    80 - 99% = 14016 
 
    Index XQS_1000_3300_DOC_ID (1) 
    Root page: 1367524, depth: 3, leaf buckets: 11322, nodes: 9122927 
    Average node length: 5.35, total dup: 8820332, max dup: 151 
    Average key length: 2.24, compression ratio: 4.01 
    Average prefix length: 8.79, average data length: 0.21 
    Clustering factor: 2089698, ratio: 0.23 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 159 
        40 - 59% = 9535 
        60 - 79% = 1599 
        80 - 99% = 27 
 
    Index XQS_1000_3300_RCV_ID (3) 
    Root page: 1379283, depth: 3, leaf buckets: 12884, nodes: 9122927 
    Average node length: 6.22, total dup: 7562835, max dup: 14 
    Average key length: 3.10, compression ratio: 2.90 
    Average prefix length: 8.07, average data length: 0.93 
    Clustering factor: 1475022, ratio: 0.16 
    Fill distribution: 
         0 - 19% = 110 
        20 - 39% = 3918 
        40 - 59% = 4102 
        60 - 79% = 2604 
        80 - 99% = 2150 
 
    Index XQS_1000_3300_SND_ID (2) 
    Root page: 1373081, depth: 3, leaf buckets: 12630, nodes: 9122927 
    Average node length: 5.97, total dup: 7900720, max dup: 35 
    Average key length: 2.86, compression ratio: 3.14 
    Average prefix length: 8.27, average data length: 0.73 
    Clustering factor: 2259971, ratio: 0.25 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 177 
        40 - 59% = 10573 
        60 - 79% = 1834 
        80 - 99% = 44 
 
    Index XQS_1000_3300_WORKER_ID (0) 
    Root page: 1362789, depth: 3, leaf buckets: 9633, nodes: 9122927 
    Average node length: 5.11, total dup: 9122827, max dup: 154465 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.41, average data length: 0.00 
    Clustering factor: 1502864, ratio: 0.16 
    Fill distribution: 
         0 - 19% = 41 
        20 - 39% = 1296 
        40 - 59% = 4692 
        60 - 79% = 1726 
        80 - 99% = 1878 
 
XQS_1200_2000 (183) 
    Primary pointer page: 591, Index root page: 592 
    Total formats: 1, used formats: 1 
    Average record length: 81.56, total records: 10849595 
    Average version length: 82.53, total versions: 107517, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.54 
    Pointer pages: 118, data page slots: 191792 
    Data pages: 190152, average fill: 70% 
    Primary pages: 189973, secondary pages: 179, swept pages: 83663 
    Empty pages: 3494, full pages: 132852 
    Fill distribution: 
     0 - 19% = 6021 
    20 - 39% = 9354 
    40 - 59% = 21263 
    60 - 79% = 97195 
    80 - 99% = 56319 
 
    Index XQS_1200_2000_DOC_ID (1) 
    Root page: 1392123, depth: 3, leaf buckets: 13105, nodes: 10849595 
    Average node length: 5.29, total dup: 10740856, max dup: 651 
    Average key length: 2.08, compression ratio: 4.32 
    Average prefix length: 8.93, average data length: 0.07 
    Clustering factor: 2268413, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 280 
        40 - 59% = 10094 
        60 - 79% = 2647 
        80 - 99% = 82 
 
    Index XQS_1200_2000_RCV_ID (3) 
    Root page: 1406132, depth: 3, leaf buckets: 10096, nodes: 10849595 
    Average node length: 5.49, total dup: 10373945, max dup: 49 
    Average key length: 2.28, compression ratio: 3.95 
    Average prefix length: 8.77, average data length: 0.23 
    Clustering factor: 696582, ratio: 0.06 
    Fill distribution: 
         0 - 19% = 163 
        20 - 39% = 882 
        40 - 59% = 2468 
        60 - 79% = 1848 
        80 - 99% = 4735 
 
    Index XQS_1200_2000_SND_ID (2) 
    Root page: 1398660, depth: 3, leaf buckets: 14981, nodes: 10849595 
    Average node length: 6.02, total dup: 9456330, max dup: 69 
    Average key length: 2.81, compression ratio: 3.20 
    Average prefix length: 8.32, average data length: 0.68 
    Clustering factor: 2284602, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 346 
        40 - 59% = 11663 
        60 - 79% = 2867 
        80 - 99% = 103 
 
    Index XQS_1200_2000_WORKER_ID (0) 
    Root page: 1386233, depth: 3, leaf buckets: 10338, nodes: 10849595 
    Average node length: 5.21, total dup: 10849495, max dup: 191113 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.41, average data length: 0.00 
    Clustering factor: 685535, ratio: 0.06 
    Fill distribution: 
         0 - 19% = 98 
        20 - 39% = 912 
        40 - 59% = 4463 
        60 - 79% = 1403 
        80 - 99% = 3462 
 
XQS_2000_3300 (185) 
    Primary pointer page: 595, Index root page: 596 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index XQS_2000_3300_DOC_ID (1) 
    Root page: 1361775, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index XQS_2000_3300_RCV_ID (3) 
    Root page: 1361777, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index XQS_2000_3300_SND_ID (2) 
    Root page: 1361776, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index XQS_2000_3300_WORKER_ID (0) 
    Root page: 1361774, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
XQS_2100_3300 (186) 
    Primary pointer page: 597, Index root page: 598 
    Total formats: 1, used formats: 1 
    Average record length: 81.94, total records: 9214240 
    Average version length: 82.85, total versions: 97622, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.54 
    Pointer pages: 106, data page slots: 171840 
    Data pages: 171792, average fill: 66% 
    Primary pages: 171773, secondary pages: 19, swept pages: 117723 
    Empty pages: 649, full pages: 73893 
    Fill distribution: 
     0 - 19% = 2250 
    20 - 39% = 10090 
    40 - 59% = 31177 
    60 - 79% = 115466 
    80 - 99% = 12809 
 
    Index XQS_2100_3300_DOC_ID (1) 
    Root page: 1344708, depth: 3, leaf buckets: 11294, nodes: 9214240 
    Average node length: 5.16, total dup: 9186294, max dup: 1547 
    Average key length: 2.03, compression ratio: 4.43 
    Average prefix length: 8.97, average data length: 0.03 
    Clustering factor: 1899830, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 31 
        20 - 39% = 1582 
        40 - 59% = 7544 
        60 - 79% = 1611 
        80 - 99% = 526 
 
    Index XQS_2100_3300_RCV_ID (3) 
    Root page: 1355739, depth: 3, leaf buckets: 13036, nodes: 9214240 
    Average node length: 6.23, total dup: 7638344, max dup: 14 
    Average key length: 3.10, compression ratio: 2.90 
    Average prefix length: 8.07, average data length: 0.93 
    Clustering factor: 1439339, ratio: 0.16 
    Fill distribution: 
         0 - 19% = 150 
        20 - 39% = 3979 
        40 - 59% = 4074 
        60 - 79% = 2600 
        80 - 99% = 2233 
 
    Index XQS_2100_3300_SND_ID (2) 
    Root page: 1350071, depth: 3, leaf buckets: 11934, nodes: 9214240 
    Average node length: 5.42, total dup: 8796188, max dup: 99 
    Average key length: 2.29, compression ratio: 3.93 
    Average prefix length: 8.75, average data length: 0.25 
    Clustering factor: 2023658, ratio: 0.22 
    Fill distribution: 
         0 - 19% = 30 
        20 - 39% = 1607 
        40 - 59% = 8270 
        60 - 79% = 1527 
        80 - 99% = 500 
 
    Index XQS_2100_3300_WORKER_ID (0) 
    Root page: 987843, depth: 3, leaf buckets: 9750, nodes: 9214240 
    Average node length: 5.13, total dup: 9214140, max dup: 156645 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.41, average data length: 0.00 
    Clustering factor: 1525712, ratio: 0.17 
    Fill distribution: 
         0 - 19% = 38 
        20 - 39% = 1324 
        40 - 59% = 4837 
        60 - 79% = 1587 
        80 - 99% = 1964 
 
XQS_3300_3400 (187) 
    Primary pointer page: 599, Index root page: 600 
    Total formats: 1, used formats: 1 
    Average record length: 67.98, total records: 562129 
    Average version length: 68.84, total versions: 1674, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.85 
    Pointer pages: 5, data page slots: 7992 
    Data pages: 7992, average fill: 74% 
    Primary pages: 7991, secondary pages: 1, swept pages: 4731 
    Empty pages: 5, full pages: 5999 
    Fill distribution: 
     0 - 19% = 8 
    20 - 39% = 11 
    40 - 59% = 251 
    60 - 79% = 7707 
    80 - 99% = 15 
 
    Index XQS_3300_3400_DOC_ID (1) 
    Root page: 27774, depth: 3, leaf buckets: 729, nodes: 562129 
    Average node length: 5.95, total dup: 478485, max dup: 82 
    Average key length: 3.09, compression ratio: 2.91 
    Average prefix length: 8.05, average data length: 0.95 
    Clustering factor: 99001, ratio: 0.18 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 39 
        40 - 59% = 527 
        60 - 79% = 78 
        80 - 99% = 85 
 
    Index XQS_3300_3400_SND_ID (2) 
    Root page: 22521, depth: 3, leaf buckets: 747, nodes: 562129 
    Average node length: 6.15, total dup: 460938, max dup: 26 
    Average key length: 3.30, compression ratio: 2.73 
    Average prefix length: 7.88, average data length: 1.12 
    Clustering factor: 99047, ratio: 0.18 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 39 
        40 - 59% = 534 
        60 - 79% = 78 
        80 - 99% = 96 
 
    Index XQS_3300_3400_WORKER_ID (0) 
    Root page: 377587, depth: 2, leaf buckets: 566, nodes: 562129 
    Average node length: 4.85, total dup: 562029, max dup: 9543 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.41, average data length: 0.00 
    Clustering factor: 88119, ratio: 0.16 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 45 
        40 - 59% = 329 
        60 - 79% = 73 
        80 - 99% = 118 
 
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 Fri Apr 12 04:11:06 2024

Record versions statistics, table

TABLE_NAME TOTAL_RECS TOTAL_VERS MAX_VERSIONS VERS_TO_RECS_PRC MAXV_TO_VERS_PRC
DOC_DATA 7645914 35503 1 0.0000 0.0000
DOC_LIST 2186549 19244 2 0.0000 0.0000
FB_ERRORS 2182 757 1 0.0000 0.0000
INVNT_SALDO 400 2359 6 500.0000 0.0000
INVNT_TURNOVER_LOG 79402 77482 1 0.0000 0.0000
MONEY_SALDO 49 228 8 400.0000 0.0000
MONEY_TURNOVER_LOG 1466 1423 1 0.0000 0.0000
PDISTR 843906 21366 3 0.0000 0.0000
PERF_SPLIT_0 163425 11618 1 0.0000 0.0000
PERF_SPLIT_1 147540 18386 1 0.0000 0.0000
PERF_SPLIT_2 163906 7545 1 0.0000 0.0000
PERF_SPLIT_3 149719 10062 1 0.0000 0.0000
PERF_SPLIT_4 156568 7076 1 0.0000 0.0000
PERF_SPLIT_5 159364 16532 1 0.0000 0.0000
PERF_SPLIT_6 149426 17572 1 0.0000 0.0000
PERF_SPLIT_7 155550 5697 1 0.0000 0.0000
PERF_SPLIT_8 153921 12889 1 0.0000 0.0000
PERF_SPLIT_9 158742 9999 1 0.0000 0.0000
PSTORNED 2028823 15950 1 0.0000 0.0000
SEMAPHORES 5 1 1 0.0000 100.0000
XQD_1000_1200 138989 54362 1 0.0000 0.0000
XQD_1000_3300 7160232 284209 1 0.0000 0.0000
XQD_1200_2000 12120334 200801 1 0.0000 0.0000
XQD_2000_3300 1291111 190405 1 0.0000 0.0000
XQD_2100_3300 959165 129249 1 0.0000 0.0000
XQD_3300_3400 8695570 138147 1 0.0000 0.0000
XQS_1000_1200 21088737 4591 1 0.0000 0.0000
XQS_1000_3300 9122927 119290 1 0.0000 0.0000
XQS_1200_2000 10849595 107517 1 0.0000 0.0000
XQS_2100_3300 9214240 97622 1 0.0000 0.0000
XQS_3300_3400 562129 1674 1 0.0000 0.0000

Record versions statistics, chart

Total records and versions, chart

Ratios versions / total_records and max_versions / total_versions

Database validation 


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

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

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

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

12.04.24 04:11:19. 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-12 04:11:21 No severe PSQL-related problems occured
12.04.24 04:11:23. End of report.