Generated by /opt/oltp-emul/oltp_isql_run_worker.sh, ISQL session No. 1 of total launched 100. 08.04.2024 13: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 15607828 kB
MemAvailable 30107704 kB
Buffers 0 kB
Cached 16121064 kB
SwapCached 2512 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-08 13:07:51
DTS_END                         2024-04-08 13:07:51.4270
FB_GDSCODE                      -1
FB_MNEMONA                      
STACK                           SP_ADD_INVOICE_TO_STOCK(190:30) ==> SP_CUSTOMER_RESERVE(47:5) ==> SP_CHECK_TO_STOP_WORK(32:12) ==> SP_HALT_ON_ERROR(68:17)
IP                              ::1/50396
TRN_ID                          176837
ATT_ID                          484
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: 9134.36 16349 913436
customer order: creation 187.82 416 18782
customer order: refuse 15.28 367 1528
order to supplier: creation 49.95 1310 4995
order to supplier: removal 3.36 79608 336
invoice (draft): creation 49.64 2917 4964
invoice (draft): removal 46.34 734 4634
invoice accept: apply 44.34 21329 4434
invoice accept: cancel 41.38 887 4138
customer reserve: creation 4292.62 204 429262
customer reserve: removal 4105.97 52 410597
realization accept: apply 90.49 178 9049
realization accept: cancel 70.22 128 7022
payment from customer: creation 63.92 138 6392
payment from customer: removal 6.13 107 613
payment to supplier: creation 51.98 129 5198
payment to supplier: removal 3.61 74 361
service: total inventory turnovers 4.15 3375 415
service: total monetary turnovers 6.16 505 616
service: aggregate perf. data 0.97 12515 97
service: refresh index statistics 0.03 202010 3

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:02, from 08-04-2024 13:09:26 to 08-04-2024 13:09:28.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 2980
TEST_TIME 2 3828
TEST_TIME 3 3492
TEST_TIME 4 4211
TEST_TIME 5 3627
TEST_TIME 6 4224
TEST_TIME 7 4181
TEST_TIME 8 4244
TEST_TIME 9 4623
TEST_TIME 10 5671
TEST_TIME 11 5991
TEST_TIME 12 6264
TEST_TIME 13 6934
TEST_TIME 14 6980
TEST_TIME 15 7209
TEST_TIME 16 7561
TEST_TIME 17 8110
TEST_TIME 18 8219
TEST_TIME 19 8768
TEST_TIME 20 8736
TEST_TIME 21 8622
TEST_TIME 22 8886
TEST_TIME 23 9123
TEST_TIME 24 9402
TEST_TIME 25 9342
TEST_TIME 26 9171
TEST_TIME 27 9353
TEST_TIME 28 9337
TEST_TIME 29 9277
TEST_TIME 30 9442
TEST_TIME 31 9492
TEST_TIME 32 9471
TEST_TIME 33 9597
TEST_TIME 34 9592
TEST_TIME 35 9401
TEST_TIME 36 9300
TEST_TIME 37 9246
TEST_TIME 38 9122
TEST_TIME 39 9126
TEST_TIME 40 9074
TEST_TIME 41 9158
TEST_TIME 42 9027
TEST_TIME 43 8938
TEST_TIME 44 8980
TEST_TIME 45 8972
TEST_TIME 46 9101
TEST_TIME 47 9078
TEST_TIME 48 9204
TEST_TIME 49 9216
TEST_TIME 50 9275
TEST_TIME 51 9252
TEST_TIME 52 9515
TEST_TIME 53 9478
TEST_TIME 54 9472
TEST_TIME 55 9586
TEST_TIME 56 9511
TEST_TIME 57 9380
TEST_TIME 58 9286
TEST_TIME 59 9331
TEST_TIME 60 9326
TEST_TIME 61 9254
TEST_TIME 62 9147
TEST_TIME 63 9106
TEST_TIME 64 9065
TEST_TIME 65 9091
TEST_TIME 66 9148
TEST_TIME 67 9200
TEST_TIME 68 9244
TEST_TIME 69 9282
TEST_TIME 70 9297
TEST_TIME 71 9411
TEST_TIME 72 9408
TEST_TIME 73 9433
TEST_TIME 74 9427
TEST_TIME 75 9470
TEST_TIME 76 9406
TEST_TIME 77 9373
TEST_TIME 78 9356
TEST_TIME 79 9273
TEST_TIME 80 9249
TEST_TIME 81 9262
TEST_TIME 82 9276
TEST_TIME 83 9254
TEST_TIME 84 9255
TEST_TIME 85 9287
TEST_TIME 86 9301
TEST_TIME 87 9310
TEST_TIME 88 9327
TEST_TIME 89 9315
TEST_TIME 90 9348
TEST_TIME 91 9327
TEST_TIME 92 9377
TEST_TIME 93 9439
TEST_TIME 94 9348
TEST_TIME 95 9252
TEST_TIME 96 9301
TEST_TIME 97 9271
TEST_TIME 98 9210
TEST_TIME 99 9187
TEST_TIME 100 9135

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:03, from 08-04-2024 13:09:30 to 08-04-2024 13:09:33.

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 1303133 1303133 0 0.00 0 27703 8 0 0
doc_list_biud 1303133 1303133 0 0.00 0 43654 21 0 0
sp_add_invoice_to_stock 4542 4434 108 2.37 39 208053 21330 0 108
sp_cancel_adding_invoice 4138 4138 0 0.00 4 64778 887 0 0
sp_cancel_client_order 1528 1528 0 0.00 4 9324 368 0 0
sp_cancel_customer_reserve 410597 410597 0 0.00 0 25879 52 0 0
sp_cancel_pay_from_customer 613 613 0 0.00 2 8912 108 0 0
sp_cancel_pay_to_supplier 361 361 0 0.00 3 3513 75 0 0
sp_cancel_supplier_invoice 4645 4634 11 0.23 1 27089 734 0 11
sp_cancel_supplier_order 336 336 0 0.00 6 736815 79608 0 0
sp_cancel_write_off 7022 7022 0 0.00 1 19325 129 0 0
sp_client_order 18782 18782 0 0.00 3 43665 416 0 0
sp_customer_reserve 429262 429262 0 0.00 0 90785 204 0 0
sp_fill_shopping_cart 28730 28730 0 0.00 1 12122 39 0 0
sp_fill_shopping_cart_clo_res 429261 429261 0 0.00 0 27597 18 0 0
sp_get_clo_for_invoice 4431 4431 0 0.00 0 21937 357 0 0
sp_kill_cost_storno 12134 12134 0 0.00 0 27699 66 0 0
sp_kill_qstorno_ret_qs2qd 833186 833186 0 0.00 0 27080 29 0 0
sp_kill_qty_storno 441735 441735 0 0.00 0 43654 62 0 0
sp_lock_selected_doc 18536 18536 0 0.00 0 8488 6 0 0
sp_make_cost_storno 25070 25070 0 0.00 0 14137 60 0 0
sp_multiply_rows_for_pdistr 25070 25070 0 0.00 0 11929 33 0 0
sp_multiply_rows_for_qdistr 18782 18782 0 0.00 0 38551 212 0 0
sp_pay_from_customer 6392 6392 0 0.00 4 11926 138 0 0
sp_pay_to_supplier 5198 5198 0 0.00 4 14192 130 0 0
sp_payment_common 11590 11590 0 0.00 1 11495 24 0 0
sp_qd_handle_on_cancel_clo 1528 1528 0 0.00 0 9316 338 0 0
sp_qd_handle_on_invoice_upd_sts 8569 8569 0 0.00 0 43653 291 0 0
sp_qd_handle_on_reserve_upd_sts 9049 9049 0 0.00 0 16573 46 0 0
sp_reserve_write_off 9049 9049 0 0.00 6 20129 179 0 0
sp_supplier_invoice 4964 4964 0 0.00 6 97467 2917 0 0
sp_supplier_order 4995 4995 0 0.00 4 39665 1311 0 0
srv_aggregate_perf_data 97 97 0 0.00 1555 234082 12515 0 0
srv_fill_mon_cache_memory 55 55 0 0.00 1411 133689 41283 0 0
srv_find_qd_qs_mism 866156 866156 0 0.00 0 10315 7 0 0
srv_make_invnt_saldo 415 415 0 0.00 52 129473 3376 0 0
srv_make_money_saldo 616 616 0 0.00 1 13555 506 0 0
srv_recalc_idx_stat 3 3 0 0.00 138747 302771 202011 0 0
t$perf-abend:sp_add_invoice_to_stock 108 108 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 4434 4434 0 0.00 0 8202 164 0 0
t$perf-norm:sp_cancel_adding_invoice 370 370 0 0.00 1 4715 95 0 0
t$perf-norm:sp_cancel_client_order 1528 1528 0 0.00 0 8709 24 0 0
t$perf-norm:sp_cancel_customer_reserve 618 618 0 0.00 0 1755 10 0 0
t$perf-norm:sp_cancel_pay_from_customer 613 613 0 0.00 0 1040 4 0 0
t$perf-norm:sp_cancel_pay_to_supplier 361 361 0 0.00 0 1917 10 0 0
t$perf-norm:sp_cancel_supplier_invoice 363 363 0 0.00 0 625 11 0 0
t$perf-norm:sp_cancel_supplier_order 336 336 0 0.00 0 20000 1489 0 0
t$perf-norm:sp_cancel_write_off 867 867 0 0.00 0 3232 8 0 0
t$perf-norm:sp_client_order 18782 18782 0 0.00 0 5680 15 0 0
t$perf-norm:sp_customer_reserve 903 903 0 0.00 0 572 4 0 0
t$perf-norm:sp_pay_from_customer 6392 6392 0 0.00 0 4095 8 0 0
t$perf-norm:sp_pay_to_supplier 5198 5198 0 0.00 0 7292 8 0 0
t$perf-norm:sp_reserve_write_off 9049 9049 0 0.00 0 4929 9 0 0
t$perf-norm:sp_supplier_invoice 4964 4964 0 0.00 0 4931 16 0 0
t$perf-norm:sp_supplier_order 4995 4995 0 0.00 0 5078 14 0 0
t$perf-norm:srv_aggregate_perf_data 97 97 0 0.00 0 156 3 0 0
t$perf-norm:srv_fill_mon_cache_memory 55 55 0 0.00 0 94 4 0 0
t$perf-norm:srv_make_invnt_saldo 415 415 0 0.00 0 3580 14 0 0
t$perf-norm:srv_make_money_saldo 616 616 0 0.00 0 1622 9 0 0
t$perf-norm:srv_recalc_idx_stat 3 3 0 0.00 1 9 4 0 0
v_add_invoice_to_stock 9076 8860 216 2.37 0 8904 20 0 216
v_all_customers 34910 34910 0 0.00 0 21 1 0 0
v_all_suppliers 27996 27996 0 0.00 0 26 1 0 0
v_all_wares 37562 37562 0 0.00 0 24 1 0 0
v_cancel_adding_invoice 740 740 0 0.00 0 3347 12 0 0
v_cancel_client_order 3056 3056 0 0.00 0 4168 7 0 0
v_cancel_customer_prepayment 1226 1226 0 0.00 0 8908 20 0 0
v_cancel_customer_reserve 1236 1236 0 0.00 0 788 4 0 0
v_cancel_payment_to_supplier 722 722 0 0.00 0 3504 9 0 0
v_cancel_supplier_invoice 748 726 22 2.94 0 308 11 0 22
v_cancel_supplier_order 672 672 0 0.00 0 694 4 0 0
v_cancel_write_off 1734 1734 0 0.00 0 3602 18 0 0
v_max_id_clo_ord 4988 4988 0 0.00 0 3153 2 0 0
v_max_id_clo_res 903 903 0 0.00 0 3173 12 0 0
v_max_id_ord_sup 4960 4960 0 0.00 0 6379 4 0 0
v_max_non_paid_invoice 1148 1148 0 0.00 0 576 2 0 0
v_max_non_paid_realizn 3043 3043 0 0.00 0 6522 7 0 0
v_min_id_clo_ord 4988 4988 0 0.00 0 1872 6 0 0
v_min_id_clo_res 903 903 0 0.00 0 1289 7 0 0
v_min_id_ord_sup 4960 4960 0 0.00 0 4454 8 0 0
v_min_non_paid_invoice 5198 5198 0 0.00 0 3439 9 0 0
v_min_non_paid_realizn 6392 6392 0 0.00 0 11492 23 0 0
v_our_firm 9350 9350 0 0.00 0 23 1 0 0
v_reserve_write_off 18098 18098 0 0.00 0 10893 11 0 0
x_lock_depdocs_on_canc_invoice 8409 8409 0 0.00 0 7242 103 0 0
x_lock_depdocs_on_canc_sup_ord 336 336 0 0.00 0 2322 243 0 0
x_make_qstorno_1000_1200 4995 4995 0 0.00 1 39660 1227 0 0
x_make_qstorno_1200_2000 4964 4964 0 0.00 3 97458 2773 0 0
x_make_qstorno_2100_3300 429262 429262 0 0.00 0 90782 184 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 08-04-2024 13:09:34 to 08-04-2024 13:09:38.

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
11:07:55 13 8192000000 8812912832 8829530112 15091872 0.183 6 4 6 0 15357248 142704 122672
11:08:56 34067 8192000000 9718179008 10014547968 787070416 8.765 100 85 170 0 814241712 7155600 20015696
11:10:53 18340 8192000000 9753221504 10062020608 821582304 9.114 100 86 173 0 854169408 12574016 20013088
11:12:16 18739 8192000000 9799777120 10121490432 861375536 9.514 100 79 156 1 895033344 16499856 17157952
11:13:45 13505 8192000000 9868159936 10202177536 910152464 9.999 100 78 156 0 966460400 40731120 15576816
11:15:05 9305 8192000000 9928954592 10272096256 945231808 10.344 100 89 178 0 1033695248 70689088 17774352
11:16:18 4382 8192000000 9942748864 10301276160 964166160 10.530 100 72 142 0 1046676192 68173040 14336992
11:17:25 2301 8192000000 9988746560 10353659904 997245248 10.852 100 82 164 0 1090704064 76954704 16504112
11:18:30 1858 8192000000 10003178464 10372448256 1016262320 11.036 100 87 171 0 1104328688 71747296 16319072
11:19:33 1405 8192000000 10020450416 10395561984 1035598384 11.222 100 83 162 0 1115703456 63668176 16436896
11:20:36 21756 8192000000 10005191216 10393931776 1050900512 11.369 100 63 123 0 1138537552 75914848 11722192
11:21:58 7953 8192000000 9982653328 10376437760 1058398240 11.441 100 38 74 0 1084950416 19167744 7384432
11:23:07 9612 8192000000 9982521792 10394521600 1061408720 11.470 100 33 64 0 1084590848 16143408 7038720
11:24:17 7691 8192000000 9998719248 10412507136 1066174928 11.516 100 30 61 0 1095101872 22866016 6060928
11:25:26 64376 8192000000 9990692448 10402586624 1071792656 11.569 100 26 52 0 1093762992 16243216 5727120
11:27:33 3246 8192000000 10023556064 10425905152 1085345680 11.698 100 44 86 0 1124214576 29191488 9677408
11:28:43 15923 8192000000 10033519728 10436681728 1092205712 11.764 100 41 83 0 1127585792 26885648 8494432
11:30:05 11000 8192000000 10070142832 10472607744 1106002688 11.895 100 62 124 0 1173459824 54472304 12984832
11:31:31 54196 8192000000 10099820480 10507071488 1102185360 11.858 99 43 84 0 1195373744 83807776 9380608
11:33:44 14844 8192000000 10116269680 10528174080 1115551824 11.985 100 42 82 0 1222087584 97950672 8585088
11:35:08 16060 8192000000 10169020544 10575491072 1115772016 11.987 99 41 82 0 1250392128 126265728 8354384
11:36:28 9483 8192000000 10175588576 10584322048 1106561776 11.900 99 48 93 0 1277543920 160516400 10465744
11:37:40 7127 8192000000 10136805408 10555527168 1067253952 11.526 97 59 118 2 1224831408 144470544 13106912
11:38:54 5612 8192000000 10133002368 10545057792 1104438928 11.880 100 61 117 0 1242304304 125680336 12185040
11:40:03 9895 8192000000 10122538864 10518863872 1075812784 11.608 100 59 116 0 1228455856 140122800 12520272
11:41:18 2798 8192000000 10107191840 10492596224 1044245344 11.305 97 68 133 1 1197598608 139500080 13853184
11:42:24 9573 8192000000 10096968992 10486607872 1045360512 11.316 99 56 112 0 1213547632 156111312 12075808
11:43:38 3046 8192000000 10111907680 10500042752 1071436608 11.566 100 67 132 0 1212329712 126451888 14441216
11:44:46 4953 8192000000 10148653152 10536693760 1088731056 11.731 100 76 150 1 1245199424 141123392 15344976
11:45:58 1407 8192000000 10173694608 10559197184 1095219696 11.792 100 80 157 3 1268043344 155564384 17259264
11:47:04 7641 8192000000 10137990080 10549207040 1103695088 11.873 100 42 83 0 1247801952 135372576 8734288
11:48:12 42900 8192000000 10157656992 10578202624 1103449296 11.870 100 38 76 0 1249309936 136918128 8942512
11:50:02 33387 8192000000 10108821712 10581831680 1087032048 11.714 100 17 34 0 1221360144 130286064 4042032
11:51:40 41678 8192000000 10051589872 10497310720 1097838368 11.817 100 27 56 0 1154515440 50431840 6245232
11:53:23 21237 8192000000 10070634336 10491764736 1107713520 11.911 100 38 74 1 1160638704 45289728 7635456
11:54:47 21165 8192000000 10070972848 10521882624 1111828656 11.950 100 9 16 0 1177513440 63729344 1955440
11:56:22 71658 8192000000 10090544624 10550833152 1109308672 11.926 100 23 43 1 1192366272 78751504 4306096
11:58:44 47254 8192000000 10071108560 10520891392 1122342672 12.049 100 14 28 0 1154262288 28883696 3035920
12:00:32 54860 8192000000 10069669136 10531860480 1123410112 12.059 100 7 14 0 1189653376 64518160 1725104
12:02:31 93196 8192000000 10063200432 10502692864 1114595536 11.976 99 40 78 0 1153568464 30939216 8033712
12:05:05 46837 8192000000 10048873360 10486566912 1127321360 12.096 100 29 56 0 1149673248 16283056 6068832
12:06:53 26398 8192000000 10110024816 10538905600 1140990816 12.225 100 48 94 1 1195431856 44913488 9527552
12:08:24 47943 8192000000 10120308432 10588499968 1146823120 12.280 99 26 51 1 1225197424 72958384 5415920
12:10:13 37280 8192000000 10127816576 10606428160 1157720784 12.382 100 10 20 0 1237653712 77897872 2035056
12:12:19 35877 8192000000 10114936640 10566762496 1134210352 12.161 99 12 25 0 1199719808 62925264 2584192
12:13:56 36644 8192000000 10102016928 10543845376 1109402784 11.927 97 25 50 0 1165952560 51523248 5026528
12:15:37 35736 8192000000 10077477568 10515955712 1092462976 11.766 97 28 56 0 1154014272 55650400 5900896
12:17:14 42794 8192000000 10091537888 10545225728 1067581952 11.529 95 17 32 0 1134349120 63407456 3359712
12:18:58 68360 8192000000 10047729872 10552803328 1067782688 11.531 96 21 42 0 1192596576 120319216 4494672
12:21:07 111945 8192000000 10017646832 10455650304 1005868080 10.935 91 8 16 1 1052990784 45643632 1479072
12:24:02 133689 8192000000 10071865056 10515738624 1073276112 11.583 99 39 78 0 1184899184 103784704 7838368
12:27:19 33766 8192000000 9992585760 10418139136 1061219680 11.468 98 10 20 0 1109270384 46264464 1786240
12:29:03 56198 8192000000 10004248784 10442166272 1070955168 11.561 99 17 30 0 1109236416 34889488 3391760
12:31:01 48187 8192000000 10038249280 10482298880 1046848608 11.330 97 15 30 0 1119332400 69537232 2946560
12:32:58 62348 8192000000 10045514384 10474614784 1055501440 11.413 98 11 22 0 1137618768 79684560 2432768
12:35:07 33777 8192000000 10118855264 10547539968 1077945120 11.628 98 43 86 0 1172472368 86101168 8426080
12:36:50 66344 8192000000 10104959760 10554118144 1099550208 11.833 99 14 28 0 1182249632 79915168 2784256
12:38:56 23151 8192000000 10056232496 10490343424 1112463600 11.956 99 43 85 0 1152425728 31563600 8398528
12:40:21 10756 8192000000 10098050800 10512658432 1123686064 12.062 100 71 139 2 1188366608 50528752 14151792
12:41:33 22441 8192000000 10117940288 10544832512 1121590320 12.042 99 54 106 0 1193674640 62103904 9980416
12:42:56 25275 8192000000 10120092544 10539622400 1133964640 12.159 100 52 102 0 1211843856 67846336 10032880
12:44:28 42202 8192000000 10083137280 10531127296 1141804096 12.232 100 47 94 0 1203518352 52487120 9227136
12:46:13 39829 8192000000 10081471344 10529849344 1144396400 12.257 100 15 30 0 1193371904 46087952 2887552
12:49:42 71559 8192000000 10096897232 10543263744 1149478400 12.305 100 28 56 0 1201718800 46365024 5875376
12:51:54 102400 8192000000 10108555456 10582269952 1127247328 12.095 98 8 17 0 1174470672 45645248 1578096
12:55:05 59581 8192000000 10089810352 10555576320 1141454032 12.229 100 15 29 0 1180722384 36355856 2912496
12:57:08 71412 8192000000 10111082368 10545500160 1116606176 11.995 98 11 22 0 1145539952 26940096 1993680
12:59:20 70796 8192000000 10121118416 10600947712 1102663520 11.863 98 20 40 0 1173906048 67481360 3761168
13:01:53 91564 8192000000 10038744576 10538680320 1064853840 11.503 95 18 36 0 1146990624 78116992 4019792
13:04:58 94844 8192000000 10031825648 10485051392 1065510352 11.509 97 13 26 0 1110860224 42720880 2628992
13:07:41 19711 8192000000 9027230976 9255735296 194556400 2.319 18 5 10 0 223221856 27807328 858128

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:14, from 08-04-2024 13:09:40 to 08-04-2024 13:09:54.

Exceptions occured during test was in run

FB_MNEMONA CNT UNIT FB_GDSCODE
except 108 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 08-04-2024 13:09:55 to 08-04-2024 13:09:57.

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          177163
MON$OLDEST_ACTIVE               177164
MON$OLDEST_SNAPSHOT             177164
MON$NEXT_TRANSACTION            177164
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                       1907424
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             704
MON$NEXT_STATEMENT              53
MON$REPLICA_MODE                0


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

Database statistics 

 
Database "/home/bases/oltp40-etalone.fdb" 
Gstat execution time Mon Apr  8 13:09:58 2024 
 
Database header page information: 
    Flags            0 
    Generation        92379 
    System Change Number    0 
    Page size        8192 
    ODS version        13.0 
    Oldest transaction    177163 
    Oldest active        177164 
    Oldest snapshot        177164 
    Next transaction    177165 
    Sequence number        0 
    Next attachment ID    704 
    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.79, total records: 7750177 
    Average version length: 48.17, total versions: 20293, 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: 89432 
    Data pages: 89432, average fill: 69% 
    Primary pages: 89431, secondary pages: 1, swept pages: 51529 
    Empty pages: 7, full pages: 64607 
    Fill distribution: 
     0 - 19% = 28 
    20 - 39% = 94 
    40 - 59% = 2559 
    60 - 79% = 86743 
    80 - 99% = 8 
 
    Index DOC_DATA_DOC_WARE_UNQ (0) 
    Root page: 1510636, depth: 3, leaf buckets: 23291, nodes: 7750177 
    Average node length: 18.89, total dup: 0, max dup: 0 
    Average key length: 15.90, compression ratio: 1.70 
    Average prefix length: 14.10, average data length: 12.90 
    Clustering factor: 1680180, ratio: 0.22 
    Fill distribution: 
         0 - 19% = 362 
        20 - 39% = 1795 
        40 - 59% = 4102 
        60 - 79% = 2491 
        80 - 99% = 14541 
 
    Index DOC_DATA_ID_DESC (1) 
    Root page: 1528140, depth: 3, leaf buckets: 13515, nodes: 7750177 
    Average node length: 11.20, total dup: 0, max dup: 0 
    Average key length: 8.21, compression ratio: 1.10 
    Average prefix length: 3.79, average data length: 5.21 
    Clustering factor: 1504164, ratio: 0.19 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 1560 
        40 - 59% = 2053 
        60 - 79% = 1166 
        80 - 99% = 8735 
 
    Index FK_DOC_DATA_DOC_LIST (2) 
    Root page: 1546735, depth: 3, leaf buckets: 8346, nodes: 7750177 
    Average node length: 6.62, total dup: 5795458, max dup: 49 
    Average key length: 3.63, compression ratio: 2.48 
    Average prefix length: 7.62, average data length: 1.38 
    Clustering factor: 1497347, ratio: 0.19 
    Fill distribution: 
         0 - 19% = 131 
        20 - 39% = 947 
        40 - 59% = 1392 
        60 - 79% = 972 
        80 - 99% = 4904 
 
DOC_LIST (138) 
    Primary pointer page: 500, Index root page: 501 
    Total formats: 1, used formats: 1 
    Average record length: 57.07, total records: 2253504 
    Average version length: 58.85, total versions: 18000, 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: 28952 
    Data pages: 28952, average fill: 71% 
    Primary pages: 28950, secondary pages: 2, swept pages: 14360 
    Empty pages: 4, full pages: 17316 
    Fill distribution: 
     0 - 19% = 10 
    20 - 39% = 37 
    40 - 59% = 429 
    60 - 79% = 28439 
    80 - 99% = 37 
 
    Index DOC_LIST_ID_DESC (1) 
    Root page: 1541152, depth: 3, leaf buckets: 4571, nodes: 2253504 
    Average node length: 11.40, total dup: 0, max dup: 0 
    Average key length: 8.44, compression ratio: 1.07 
    Average prefix length: 3.56, average data length: 5.44 
    Clustering factor: 684622, ratio: 0.30 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 917 
        40 - 59% = 859 
        60 - 79% = 747 
        80 - 99% = 2048 
 
    Index DOC_LIST_WORKER_OPTYPE (2) 
    Root page: 1544398, depth: 3, leaf buckets: 2425, nodes: 2254492 
    Average node length: 4.97, total dup: 2253594, max dup: 18005 
    Average key length: 2.01, compression ratio: 4.48 
    Average prefix length: 8.99, average data length: 0.01 
    Clustering factor: 1262873, ratio: 0.56 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 208 
        40 - 59% = 1399 
        60 - 79% = 556 
        80 - 99% = 260 
 
    Index FK_DOC_LIST_AGENTS (3) 
    Root page: 1545933, depth: 3, leaf buckets: 1801, nodes: 2253504 
    Average node length: 4.97, total dup: 2253454, max dup: 130357 
    Average key length: 2.01, compression ratio: 4.48 
    Average prefix length: 8.99, average data length: 0.01 
    Clustering factor: 1073836, ratio: 0.48 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 651 
        60 - 79% = 47 
        80 - 99% = 1102 
 
    Index PK_DOC_LIST (0) 
    Root page: 1538209, depth: 3, leaf buckets: 4337, nodes: 2253504 
    Average node length: 11.40, total dup: 0, max dup: 0 
    Average key length: 8.44, compression ratio: 1.07 
    Average prefix length: 3.56, average data length: 5.44 
    Clustering factor: 684622, ratio: 0.30 
    Fill distribution: 
         0 - 19% = 95 
        20 - 39% = 553 
        40 - 59% = 630 
        60 - 79% = 841 
        80 - 99% = 2218 
 
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.31, total records: 400 
    Average version length: 26.80, total versions: 2050, max versions: 6 
    Average fragment length: 2.00, total fragments: 6, max fragments: 1 
    Average unpacked length: 104.00, compression ratio: 1.25 
    Pointer pages: 1, data page slots: 24 
    Data pages: 24, average fill: 67% 
    Primary pages: 7, secondary pages: 17, swept pages: 0 
    Empty pages: 2, full pages: 12 
    Fill distribution: 
     0 - 19% = 5 
    20 - 39% = 1 
    40 - 59% = 2 
    60 - 79% = 3 
    80 - 99% = 13 
 
    Index PK_INVNT_SALDO (0) 
    Root page: 1510371, depth: 1, leaf buckets: 1, nodes: 400 
    Average node length: 11.22, total dup: 0, max dup: 0 
    Average key length: 10.22, compression ratio: 0.88 
    Average prefix length: 1.78, average data length: 7.22 
    Clustering factor: 326, ratio: 0.81 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 0 
        40 - 59% = 1 
        60 - 79% = 0 
        80 - 99% = 0 
 
INVNT_TURNOVER_LOG (153) 
    Primary pointer page: 530, Index root page: 531 
    Total formats: 1, used formats: 1 
    Average record length: 11.73, total records: 76184 
    Average version length: 68.29, total versions: 72677, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 88.00, compression ratio: 7.50 
    Pointer pages: 6, data page slots: 4376 
    Data pages: 1624, average fill: 64% 
    Primary pages: 1623, secondary pages: 1, swept pages: 30 
    Empty pages: 176, full pages: 893 
    Fill distribution: 
     0 - 19% = 257 
    20 - 39% = 183 
    40 - 59% = 187 
    60 - 79% = 194 
    80 - 99% = 803 
 
    Index INVNT_TURNOVER_LOG_WARE_DD_ID (0) 
    Root page: 1695651, depth: 3, leaf buckets: 341, nodes: 76184 
    Average node length: 13.64, total dup: 4366, max dup: 1 
    Average key length: 10.75, compression ratio: 2.51 
    Average prefix length: 19.19, average data length: 7.81 
    Clustering factor: 54650, ratio: 0.72 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 255 
        40 - 59% = 58 
        60 - 79% = 27 
        80 - 99% = 1 
 
MONEY_SALDO (141) 
    Primary pointer page: 506, Index root page: 507 
    Total formats: 1, used formats: 1 
    Average record length: 15.27, total records: 49 
    Average version length: 9.00, total versions: 152, max versions: 5 
    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: 68% 
    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% = 1 
    80 - 99% = 0 
 
    Index PK_MONEY_SALDO (0) 
    Root page: 1510383, depth: 1, leaf buckets: 1, nodes: 49 
    Average node length: 11.82, total dup: 0, max dup: 0 
    Average key length: 10.80, compression ratio: 0.83 
    Average prefix length: 1.18, average data length: 7.82 
    Clustering factor: 1, ratio: 0.02 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
MONEY_TURNOVER_LOG (140) 
    Primary pointer page: 504, Index root page: 505 
    Total formats: 1, used formats: 1 
    Average record length: 15.97, total records: 1593 
    Average version length: 43.43, total versions: 1279, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 58.00, compression ratio: 3.63 
    Pointer pages: 1, data page slots: 24 
    Data pages: 24, average fill: 68% 
    Primary pages: 23, secondary pages: 1, swept pages: 1 
    Empty pages: 1, full pages: 14 
    Fill distribution: 
     0 - 19% = 2 
    20 - 39% = 1 
    40 - 59% = 6 
    60 - 79% = 2 
    80 - 99% = 13 
 
    Index MONEY_TURNOVER_LOG_AGENT_OPTYPE (0) 
    Root page: 93869, depth: 2, leaf buckets: 2, nodes: 1593 
    Average node length: 4.20, total dup: 1495, max dup: 158 
    Average key length: 2.65, compression ratio: 7.17 
    Average prefix length: 18.41, average data length: 0.59 
    Clustering factor: 843, ratio: 0.53 
    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.49, 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: 112.00, compression ratio: 1.15 
    Pointer pages: 1, data page slots: 2 
    Data pages: 2, average fill: 50% 
    Primary pages: 2, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 1 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 1 
    80 - 99% = 0 
 
    Index PK_MON_CACHE_MEMORY (0) 
    Root page: 1504238, depth: 1, leaf buckets: 1, nodes: 71 
    Average node length: 11.70, total dup: 0, max dup: 0 
    Average key length: 10.69, compression ratio: 0.84 
    Average prefix length: 1.30, average data length: 7.70 
    Clustering factor: 2, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
MON_LOG (162) 
    Primary pointer page: 548, Index root page: 549 
    Total formats: 2, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index MON_LOG_DTS (4) 
    Root page: 1504251, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index MON_LOG_GDSCODE (2) 
    Root page: 1504249, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index MON_LOG_ROWSET_DESC (1) 
    Root page: 1504248, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index MON_LOG_UNIT (3) 
    Root page: 1504250, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PK_MON_LOG (0) 
    Root page: 1504247, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
MON_LOG_TABLE_STATS (163) 
    Primary pointer page: 550, Index root page: 551 
    Total formats: 2, used formats: 1 
    Average record length: 67.13, total records: 30 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 611.00, compression ratio: 9.10 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 31% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 1 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index MON_LOG_TABLE_STATS_DTS (4) 
    Root page: 1504246, depth: 1, leaf buckets: 1, nodes: 30 
    Average node length: 3.50, total dup: 23, max dup: 4 
    Average key length: 2.47, compression ratio: 3.24 
    Average prefix length: 7.53, average data length: 0.47 
    Clustering factor: 1, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index MON_LOG_TABLE_STATS_GDSCODE (2) 
    Root page: 1504244, depth: 1, leaf buckets: 1, nodes: 30 
    Average node length: 2.00, total dup: 29, max dup: 29 
    Average key length: 1.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 1, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index MON_LOG_TABLE_STATS_ROWSET (1) 
    Root page: 1504243, depth: 1, leaf buckets: 1, nodes: 30 
    Average node length: 3.33, total dup: 29, max dup: 29 
    Average key length: 2.30, compression ratio: 3.91 
    Average prefix length: 8.70, average data length: 0.30 
    Clustering factor: 1, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index MON_LOG_TABLE_STATS_TN_UNIT (3) 
    Root page: 1504245, depth: 1, leaf buckets: 1, nodes: 30 
    Average node length: 12.90, total dup: 0, max dup: 0 
    Average key length: 11.87, compression ratio: 1.42 
    Average prefix length: 7.63, average data length: 9.20 
    Clustering factor: 1, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PK_MON_LOG_TABLE_STATS (0) 
    Root page: 1504242, depth: 1, leaf buckets: 1, nodes: 30 
    Average node length: 8.37, total dup: 0, max dup: 0 
    Average key length: 7.33, compression ratio: 1.23 
    Average prefix length: 4.63, average data length: 4.37 
    Clustering factor: 1, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
OPTYPES (136) 
    Primary pointer page: 496, Index root page: 497 
    Total formats: 2, used formats: 1 
    Average record length: 67.56, total records: 9 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 386.00, compression ratio: 5.71 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 9% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index OPTYPES_MCODE_UNQ (1) 
    Root page: 1544827, depth: 1, leaf buckets: 1, nodes: 9 
    Average node length: 8.56, total dup: 0, max dup: 0 
    Average key length: 6.89, compression ratio: 0.73 
    Average prefix length: 0.44, average data length: 4.56 
    Clustering factor: 1, ratio: 0.11 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PK_OPTYPES (0) 
    Root page: 1544826, depth: 1, leaf buckets: 1, nodes: 9 
    Average node length: 6.11, total dup: 0, max dup: 0 
    Average key length: 5.00, compression ratio: 0.60 
    Average prefix length: 0.89, average data length: 2.11 
    Clustering factor: 1, ratio: 0.11 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
PDISTR (146) 
    Primary pointer page: 516, Index root page: 517 
    Total formats: 1, used formats: 1 
    Average record length: 36.70, total records: 765763 
    Average version length: 37.93, total versions: 19718, max versions: 2 
    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: 8224 
    Data pages: 8224, average fill: 64% 
    Primary pages: 8223, secondary pages: 1, swept pages: 2780 
    Empty pages: 15, full pages: 4624 
    Fill distribution: 
     0 - 19% = 37 
    20 - 39% = 78 
    40 - 59% = 1088 
    60 - 79% = 6991 
    80 - 99% = 30 
 
    Index PDISTR_AGENT_ID (2) 
    Root page: 1509330, depth: 2, leaf buckets: 842, nodes: 754504 
    Average node length: 4.87, total dup: 754455, max dup: 132789 
    Average key length: 2.01, compression ratio: 4.48 
    Average prefix length: 8.99, average data length: 0.01 
    Clustering factor: 88778, ratio: 0.12 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 160 
        40 - 59% = 446 
        60 - 79% = 149 
        80 - 99% = 86 
 
    Index PDISTR_SNDOP_RCVOP_SNDID_ASC (0) 
    Root page: 1508635, depth: 3, leaf buckets: 882, nodes: 754504 
    Average node length: 5.88, total dup: 671748, max dup: 42 
    Average key length: 3.02, compression ratio: 7.29 
    Average prefix length: 21.09, average data length: 0.91 
    Clustering factor: 153397, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 86 
        40 - 59% = 382 
        60 - 79% = 139 
        80 - 99% = 275 
 
    Index PDISTR_SNDOP_RCVOP_SNDID_DESC (1) 
    Root page: 1509209, depth: 3, leaf buckets: 897, nodes: 754504 
    Average node length: 5.88, total dup: 671748, max dup: 42 
    Average key length: 3.02, compression ratio: 7.29 
    Average prefix length: 21.09, average data length: 0.91 
    Clustering factor: 155351, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 144 
        40 - 59% = 340 
        60 - 79% = 127 
        80 - 99% = 286 
 
    Index PDISTR_WORKER_SND_ID (3) 
    Root page: 1510200, depth: 3, leaf buckets: 1094, nodes: 754504 
    Average node length: 5.96, total dup: 671748, max dup: 42 
    Average key length: 3.10, compression ratio: 5.48 
    Average prefix length: 16.01, average data length: 0.99 
    Clustering factor: 148399, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 3 
        20 - 39% = 274 
        40 - 59% = 565 
        60 - 79% = 163 
        80 - 99% = 89 
 
PERF_AGG (158) 
    Primary pointer page: 540, Index root page: 541 
    Total formats: 1, used formats: 1 
    Average record length: 62.80, total records: 5478 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 3.22, total fragments: 18, max fragments: 1 
    Average unpacked length: 379.00, compression ratio: 6.04 
    Pointer pages: 1, data page slots: 88 
    Data pages: 88, average fill: 61% 
    Primary pages: 77, secondary pages: 11, swept pages: 60 
    Empty pages: 7, full pages: 65 
    Fill distribution: 
     0 - 19% = 13 
    20 - 39% = 1 
    40 - 59% = 1 
    60 - 79% = 73 
    80 - 99% = 0 
 
    Index PERF_AGG_UNQ (1) 
    Root page: 1504260, depth: 2, leaf buckets: 6, nodes: 5478 
    Average node length: 5.49, total dup: 0, max dup: 0 
    Average key length: 3.58, compression ratio: 10.06 
    Average prefix length: 34.47, average data length: 1.54 
    Clustering factor: 5224, ratio: 0.95 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 0 
        40 - 59% = 4 
        60 - 79% = 1 
        80 - 99% = 1 
 
    Index PK_PERF_AGG (0) 
    Root page: 1504255, depth: 2, leaf buckets: 10, nodes: 5478 
    Average node length: 11.11, total dup: 0, max dup: 0 
    Average key length: 9.21, compression ratio: 0.98 
    Average prefix length: 2.79, average data length: 6.21 
    Clustering factor: 171, 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.03, total records: 80738 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 48.00, compression ratio: 1.23 
    Pointer pages: 1, data page slots: 840 
    Data pages: 840, average fill: 66% 
    Primary pages: 840, secondary pages: 0, swept pages: 0 
    Empty pages: 1, full pages: 838 
    Fill distribution: 
     0 - 19% = 2 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 838 
    80 - 99% = 0 
 
    Index PK_PERF_ESTIMATED (0) 
    Root page: 36253, depth: 2, leaf buckets: 103, nodes: 80738 
    Average node length: 10.16, total dup: 0, max dup: 0 
    Average key length: 8.17, compression ratio: 1.10 
    Average prefix length: 3.83, average data length: 5.17 
    Clustering factor: 3043, ratio: 0.04 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 1 
        80 - 99% = 101 
 
PERF_ISQL_STAT (156) 
    Primary pointer page: 536, Index root page: 537 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index PERF_ISQL_STAT_TRN (0) 
    Root page: 1504261, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
PERF_LOG (159) 
    Primary pointer page: 542, Index root page: 543 
    Total formats: 1, used formats: 1 
    Average record length: 111.07, 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: 149.87, total records: 161166 
    Average version length: 151.27, total versions: 1375, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.32 
    Pointer pages: 7, data page slots: 5328 
    Data pages: 4072, average fill: 82% 
    Primary pages: 4069, secondary pages: 3, swept pages: 6 
    Empty pages: 99, full pages: 3948 
    Fill distribution: 
     0 - 19% = 104 
    20 - 39% = 11 
    40 - 59% = 4 
    60 - 79% = 7 
    80 - 99% = 3946 
 
PERF_SPLIT_1 (282) 
    Primary pointer page: 603, Index root page: 604 
    Total formats: 1, used formats: 1 
    Average record length: 146.87, total records: 133130 
    Average version length: 152.22, total versions: 3849, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.55 
    Pointer pages: 7, data page slots: 3824 
    Data pages: 3328, average fill: 83% 
    Primary pages: 3325, secondary pages: 3, swept pages: 2 
    Empty pages: 50, full pages: 3260 
    Fill distribution: 
     0 - 19% = 57 
    20 - 39% = 2 
    40 - 59% = 3 
    60 - 79% = 5 
    80 - 99% = 3261 
 
PERF_SPLIT_2 (283) 
    Primary pointer page: 605, Index root page: 606 
    Total formats: 1, used formats: 1 
    Average record length: 150.35, total records: 159159 
    Average version length: 147.46, total versions: 782, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.28 
    Pointer pages: 8, data page slots: 5128 
    Data pages: 3936, average fill: 83% 
    Primary pages: 3933, secondary pages: 3, swept pages: 4 
    Empty pages: 26, full pages: 3897 
    Fill distribution: 
     0 - 19% = 29 
    20 - 39% = 3 
    40 - 59% = 2 
    60 - 79% = 4 
    80 - 99% = 3898 
 
PERF_SPLIT_3 (284) 
    Primary pointer page: 607, Index root page: 616 
    Total formats: 1, used formats: 1 
    Average record length: 131.72, total records: 150912 
    Average version length: 153.92, total versions: 20146, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 12.88 
    Pointer pages: 6, data page slots: 4864 
    Data pages: 3776, average fill: 84% 
    Primary pages: 3774, secondary pages: 2, swept pages: 1 
    Empty pages: 61, full pages: 3696 
    Fill distribution: 
     0 - 19% = 63 
    20 - 39% = 11 
    40 - 59% = 2 
    60 - 79% = 4 
    80 - 99% = 3696 
 
PERF_SPLIT_4 (285) 
    Primary pointer page: 617, Index root page: 618 
    Total formats: 1, used formats: 1 
    Average record length: 150.35, total records: 145145 
    Average version length: 144.54, total versions: 563, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.28 
    Pointer pages: 6, data page slots: 4688 
    Data pages: 3616, average fill: 83% 
    Primary pages: 3613, secondary pages: 3, swept pages: 2 
    Empty pages: 47, full pages: 3554 
    Fill distribution: 
     0 - 19% = 52 
    20 - 39% = 4 
    40 - 59% = 4 
    60 - 79% = 1 
    80 - 99% = 3555 
 
PERF_SPLIT_5 (286) 
    Primary pointer page: 619, Index root page: 620 
    Total formats: 1, used formats: 1 
    Average record length: 139.64, total records: 142421 
    Average version length: 154.65, total versions: 11128, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 12.15 
    Pointer pages: 5, data page slots: 3640 
    Data pages: 3536, average fill: 84% 
    Primary pages: 3535, secondary pages: 1, swept pages: 3 
    Empty pages: 32, full pages: 3487 
    Fill distribution: 
     0 - 19% = 36 
    20 - 39% = 6 
    40 - 59% = 0 
    60 - 79% = 7 
    80 - 99% = 3487 
 
PERF_SPLIT_6 (287) 
    Primary pointer page: 621, Index root page: 622 
    Total formats: 1, used formats: 1 
    Average record length: 147.76, total records: 154377 
    Average version length: 152.65, total versions: 3478, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.48 
    Pointer pages: 7, data page slots: 5040 
    Data pages: 3840, average fill: 83% 
    Primary pages: 3838, secondary pages: 2, swept pages: 1 
    Empty pages: 46, full pages: 3781 
    Fill distribution: 
     0 - 19% = 50 
    20 - 39% = 4 
    40 - 59% = 3 
    60 - 79% = 1 
    80 - 99% = 3782 
 
PERF_SPLIT_7 (288) 
    Primary pointer page: 626, Index root page: 627 
    Total formats: 1, used formats: 1 
    Average record length: 149.15, total records: 147610 
    Average version length: 149.96, total versions: 2020, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.37 
    Pointer pages: 7, data page slots: 6616 
    Data pages: 3680, average fill: 83% 
    Primary pages: 3678, secondary pages: 2, swept pages: 2 
    Empty pages: 46, full pages: 3612 
    Fill distribution: 
     0 - 19% = 51 
    20 - 39% = 3 
    40 - 59% = 6 
    60 - 79% = 7 
    80 - 99% = 3613 
 
PERF_SPLIT_8 (289) 
    Primary pointer page: 628, Index root page: 629 
    Total formats: 1, used formats: 1 
    Average record length: 148.21, total records: 153851 
    Average version length: 151.27, total versions: 3162, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.44 
    Pointer pages: 6, data page slots: 4848 
    Data pages: 3872, average fill: 82% 
    Primary pages: 3869, secondary pages: 3, swept pages: 1 
    Empty pages: 82, full pages: 3769 
    Fill distribution: 
     0 - 19% = 86 
    20 - 39% = 10 
    40 - 59% = 3 
    60 - 79% = 4 
    80 - 99% = 3769 
 
PERF_SPLIT_9 (290) 
    Primary pointer page: 630, Index root page: 631 
    Total formats: 1, used formats: 1 
    Average record length: 148.49, total records: 158218 
    Average version length: 151.98, total versions: 3082, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.42 
    Pointer pages: 6, data page slots: 5168 
    Data pages: 3936, average fill: 83% 
    Primary pages: 3934, secondary pages: 2, swept pages: 2 
    Empty pages: 38, full pages: 3884 
    Fill distribution: 
     0 - 19% = 41 
    20 - 39% = 8 
    40 - 59% = 2 
    60 - 79% = 2 
    80 - 99% = 3883 
 
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.49, total records: 2112838 
    Average version length: 52.83, total versions: 12462, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 70.00, compression ratio: 1.33 
    Pointer pages: 16, data page slots: 25960 
    Data pages: 25960, average fill: 70% 
    Primary pages: 25950, secondary pages: 10, swept pages: 12332 
    Empty pages: 118, full pages: 21801 
    Fill distribution: 
     0 - 19% = 256 
    20 - 39% = 282 
    40 - 59% = 1004 
    60 - 79% = 24314 
    80 - 99% = 104 
 
    Index PSTORNED_RCV_ID (1) 
    Root page: 1506208, depth: 3, leaf buckets: 2587, nodes: 2112838 
    Average node length: 5.44, total dup: 1971378, max dup: 1416 
    Average key length: 2.49, compression ratio: 3.62 
    Average prefix length: 8.58, average data length: 0.42 
    Clustering factor: 182631, ratio: 0.09 
    Fill distribution: 
         0 - 19% = 4 
        20 - 39% = 263 
        40 - 59% = 1733 
        60 - 79% = 298 
        80 - 99% = 289 
 
    Index PSTORNED_SND_ID (0) 
    Root page: 1504841, depth: 3, leaf buckets: 2763, nodes: 2112838 
    Average node length: 5.69, total dup: 1896281, max dup: 64 
    Average key length: 2.74, compression ratio: 3.29 
    Average prefix length: 8.36, average data length: 0.64 
    Clustering factor: 377384, ratio: 0.18 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 2 
        40 - 59% = 2390 
        60 - 79% = 352 
        80 - 99% = 19 
 
    Index PSTORNED_WORKER_ID (2) 
    Root page: 1508018, depth: 3, leaf buckets: 2124, nodes: 2112838 
    Average node length: 4.96, total dup: 2112738, max dup: 27947 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.42, average data length: 0.00 
    Clustering factor: 180572, ratio: 0.09 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 219 
        40 - 59% = 1057 
        60 - 79% = 400 
        80 - 99% = 446 
 
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.52, total records: 137185 
    Average version length: 69.17, total versions: 53995, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 2.77 
    Pointer pages: 3, data page slots: 3864 
    Data pages: 2904, average fill: 57% 
    Primary pages: 2904, secondary pages: 0, swept pages: 257 
    Empty pages: 286, full pages: 1296 
    Fill distribution: 
     0 - 19% = 426 
    20 - 39% = 323 
    40 - 59% = 547 
    60 - 79% = 880 
    80 - 99% = 728 
 
    Index XQD_1000_1200_WA_SO_RO_WKR_SND (0) 
    Root page: 1555019, depth: 3, leaf buckets: 231, nodes: 137185 
    Average node length: 6.44, total dup: 119413, max dup: 14 
    Average key length: 3.96, compression ratio: 10.61 
    Average prefix length: 40.17, average data length: 1.83 
    Clustering factor: 23993, ratio: 0.17 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 71 
        40 - 59% = 116 
        60 - 79% = 39 
        80 - 99% = 3 
 
XQD_1000_3300 (178) 
    Primary pointer page: 581, Index root page: 582 
    Total formats: 1, used formats: 1 
    Average record length: 66.54, total records: 6732539 
    Average version length: 68.79, total versions: 272317, 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: 64, data page slots: 103960 
    Data pages: 103960, average fill: 69% 
    Primary pages: 103959, secondary pages: 1, swept pages: 38643 
    Empty pages: 16, full pages: 45849 
    Fill distribution: 
     0 - 19% = 50 
    20 - 39% = 488 
    40 - 59% = 10561 
    60 - 79% = 92129 
    80 - 99% = 732 
 
    Index XQD_1000_3300_WA_SO_RO_WKR_SND (0) 
    Root page: 1480476, depth: 3, leaf buckets: 10537, nodes: 6732539 
    Average node length: 6.52, total dup: 5820324, max dup: 29 
    Average key length: 3.53, compression ratio: 11.90 
    Average prefix length: 40.61, average data length: 1.39 
    Clustering factor: 1577579, ratio: 0.23 
    Fill distribution: 
         0 - 19% = 6 
        20 - 39% = 2071 
        40 - 59% = 5754 
        60 - 79% = 2301 
        80 - 99% = 405 
 
    Index XQD_1000_3300_WKR_DOC_ASC (1) 
    Root page: 1486090, depth: 3, leaf buckets: 8398, nodes: 6732539 
    Average node length: 5.41, total dup: 6456655, max dup: 143 
    Average key length: 2.42, compression ratio: 7.03 
    Average prefix length: 16.62, average data length: 0.38 
    Clustering factor: 1395219, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 10 
        20 - 39% = 1219 
        40 - 59% = 5038 
        60 - 79% = 1275 
        80 - 99% = 856 
 
    Index XQD_1000_3300_WKR_DOC_DEC (2) 
    Root page: 1490630, depth: 3, leaf buckets: 8481, nodes: 6732539 
    Average node length: 5.41, total dup: 6456655, max dup: 143 
    Average key length: 2.42, compression ratio: 7.03 
    Average prefix length: 16.62, average data length: 0.38 
    Clustering factor: 1397548, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 6 
        20 - 39% = 1328 
        40 - 59% = 5017 
        60 - 79% = 1285 
        80 - 99% = 845 
 
XQD_1200_2000 (177) 
    Primary pointer page: 579, Index root page: 580 
    Total formats: 1, used formats: 1 
    Average record length: 67.92, total records: 11689306 
    Average version length: 68.76, total versions: 202428, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.86 
    Pointer pages: 106, data page slots: 171424 
    Data pages: 171424, average fill: 72% 
    Primary pages: 171423, secondary pages: 1, swept pages: 85131 
    Empty pages: 3, full pages: 131214 
    Fill distribution: 
     0 - 19% = 38 
    20 - 39% = 604 
    40 - 59% = 6931 
    60 - 79% = 162986 
    80 - 99% = 865 
 
    Index XQD_1200_2000_WA_SO_RO_WKR_SND (0) 
    Root page: 1495050, depth: 3, leaf buckets: 18280, nodes: 11688593 
    Average node length: 6.60, total dup: 10188171, max dup: 74 
    Average key length: 3.43, compression ratio: 12.25 
    Average prefix length: 40.70, average data length: 1.30 
    Clustering factor: 2428684, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 31 
        20 - 39% = 2831 
        40 - 59% = 10790 
        60 - 79% = 3864 
        80 - 99% = 764 
 
XQD_2000_3300 (179) 
    Primary pointer page: 583, Index root page: 584 
    Total formats: 1, used formats: 1 
    Average record length: 56.46, total records: 1315759 
    Average version length: 69.06, total versions: 226222, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 2.23 
    Pointer pages: 28, data page slots: 44160 
    Data pages: 28808, average fill: 50% 
    Primary pages: 28735, secondary pages: 73, swept pages: 12701 
    Empty pages: 4243, full pages: 13224 
    Fill distribution: 
     0 - 19% = 6677 
    20 - 39% = 3680 
    40 - 59% = 3517 
    60 - 79% = 12343 
    80 - 99% = 2591 
 
    Index XQD_2000_3300_WA_SO_RO_WKR_SND (0) 
    Root page: 1479735, depth: 3, leaf buckets: 1898, nodes: 1264186 
    Average node length: 5.54, total dup: 1212872, max dup: 49 
    Average key length: 2.58, compression ratio: 16.31 
    Average prefix length: 41.46, average data length: 0.54 
    Clustering factor: 87106, ratio: 0.07 
    Fill distribution: 
         0 - 19% = 6 
        20 - 39% = 702 
        40 - 59% = 884 
        60 - 79% = 284 
        80 - 99% = 22 
 
XQD_2100_3300 (180) 
    Primary pointer page: 585, Index root page: 586 
    Total formats: 1, used formats: 1 
    Average record length: 46.04, total records: 1008461 
    Average version length: 69.03, total versions: 115545, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 2.74 
    Pointer pages: 19, data page slots: 29984 
    Data pages: 25128, average fill: 38% 
    Primary pages: 25128, secondary pages: 0, swept pages: 7086 
    Empty pages: 3379, full pages: 5453 
    Fill distribution: 
     0 - 19% = 6355 
    20 - 39% = 5938 
    40 - 59% = 7907 
    60 - 79% = 4843 
    80 - 99% = 85 
 
    Index XQD_2100_3300_WA_SO_RO_WKR_SND (0) 
    Root page: 1479229, depth: 3, leaf buckets: 1146, nodes: 737946 
    Average node length: 5.89, total dup: 682524, max dup: 57 
    Average key length: 2.97, compression ratio: 14.16 
    Average prefix length: 41.11, average data length: 0.89 
    Clustering factor: 101686, ratio: 0.14 
    Fill distribution: 
         0 - 19% = 3 
        20 - 39% = 373 
        40 - 59% = 562 
        60 - 79% = 198 
        80 - 99% = 10 
 
XQD_3300_3400 (181) 
    Primary pointer page: 587, Index root page: 588 
    Total formats: 1, used formats: 1 
    Average record length: 67.94, total records: 9154229 
    Average version length: 68.92, total versions: 143110, 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: 89, data page slots: 144304 
    Data pages: 144288, average fill: 68% 
    Primary pages: 144277, secondary pages: 11, swept pages: 81374 
    Empty pages: 365, full pages: 63070 
    Fill distribution: 
     0 - 19% = 922 
    20 - 39% = 3381 
    40 - 59% = 20759 
    60 - 79% = 118391 
    80 - 99% = 835 
 
    Index XQD_3300_3400_WA_SO_RO_WKR_SND (0) 
    Root page: 1472612, depth: 3, leaf buckets: 13481, nodes: 9151434 
    Average node length: 6.68, total dup: 7590211, max dup: 14 
    Average key length: 3.67, compression ratio: 11.45 
    Average prefix length: 40.50, average data length: 1.50 
    Clustering factor: 2083917, ratio: 0.23 
    Fill distribution: 
         0 - 19% = 5 
        20 - 39% = 1423 
        40 - 59% = 6802 
        60 - 79% = 4560 
        80 - 99% = 691 
 
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: 21154405 
    Average version length: 82.96, total versions: 4397, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.53 
    Pointer pages: 197, data page slots: 319904 
    Data pages: 319904, average fill: 81% 
    Primary pages: 319899, secondary pages: 5, swept pages: 14215 
    Empty pages: 31, full pages: 319265 
    Fill distribution: 
     0 - 19% = 47 
    20 - 39% = 27 
    40 - 59% = 59 
    60 - 79% = 50092 
    80 - 99% = 269679 
 
    Index XQS_1000_1200_DOC_ID (1) 
    Root page: 1426738, depth: 3, leaf buckets: 19217, nodes: 21154405 
    Average node length: 5.72, total dup: 20673139, max dup: 128 
    Average key length: 2.16, compression ratio: 4.16 
    Average prefix length: 8.86, average data length: 0.14 
    Clustering factor: 3285120, ratio: 0.16 
    Fill distribution: 
         0 - 19% = 5 
        20 - 39% = 2 
        40 - 59% = 7794 
        60 - 79% = 549 
        80 - 99% = 10867 
 
    Index XQS_1000_1200_RCV_ID (3) 
    Root page: 1457002, depth: 3, leaf buckets: 17176, nodes: 21154405 
    Average node length: 6.31, total dup: 18589733, max dup: 49 
    Average key length: 2.75, compression ratio: 3.27 
    Average prefix length: 8.37, average data length: 0.63 
    Clustering factor: 919283, ratio: 0.04 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 3 
        40 - 59% = 779 
        60 - 79% = 268 
        80 - 99% = 16126 
 
    Index XQS_1000_1200_SND_ID (2) 
    Root page: 1441095, depth: 3, leaf buckets: 20985, nodes: 21154405 
    Average node length: 6.35, total dup: 18509054, max dup: 29 
    Average key length: 2.79, compression ratio: 3.23 
    Average prefix length: 8.34, average data length: 0.66 
    Clustering factor: 3579498, ratio: 0.17 
    Fill distribution: 
         0 - 19% = 3 
        20 - 39% = 3 
        40 - 59% = 7996 
        60 - 79% = 664 
        80 - 99% = 12319 
 
    Index XQS_1000_1200_WORKER_ID (0) 
    Root page: 1413370, depth: 3, leaf buckets: 16253, nodes: 21154405 
    Average node length: 5.56, total dup: 21154305, max dup: 228280 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.42, average data length: 0.00 
    Clustering factor: 948260, ratio: 0.04 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 11 
        40 - 59% = 3197 
        60 - 79% = 358 
        80 - 99% = 12686 
 
XQS_1000_3300 (184) 
    Primary pointer page: 593, Index root page: 594 
    Total formats: 1, used formats: 1 
    Average record length: 81.09, total records: 9643322 
    Average version length: 82.58, total versions: 175240, 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: 105, data page slots: 170904 
    Data pages: 170872, average fill: 70% 
    Primary pages: 170852, secondary pages: 20, swept pages: 98275 
    Empty pages: 501, full pages: 93208 
    Fill distribution: 
     0 - 19% = 1383 
    20 - 39% = 5415 
    40 - 59% = 23352 
    60 - 79% = 125010 
    80 - 99% = 15712 
 
    Index XQS_1000_3300_DOC_ID (1) 
    Root page: 1367524, depth: 3, leaf buckets: 11358, nodes: 9643322 
    Average node length: 5.37, total dup: 9333335, max dup: 163 
    Average key length: 2.23, compression ratio: 4.03 
    Average prefix length: 8.80, average data length: 0.20 
    Clustering factor: 2212502, ratio: 0.23 
    Fill distribution: 
         0 - 19% = 3 
        20 - 39% = 45 
        40 - 59% = 8373 
        60 - 79% = 2839 
        80 - 99% = 98 
 
    Index XQS_1000_3300_RCV_ID (3) 
    Root page: 1379283, depth: 3, leaf buckets: 13376, nodes: 9643322 
    Average node length: 6.24, total dup: 7992486, max dup: 14 
    Average key length: 3.10, compression ratio: 2.90 
    Average prefix length: 8.07, average data length: 0.93 
    Clustering factor: 1555067, ratio: 0.16 
    Fill distribution: 
         0 - 19% = 120 
        20 - 39% = 3789 
        40 - 59% = 4412 
        60 - 79% = 2581 
        80 - 99% = 2474 
 
    Index XQS_1000_3300_SND_ID (2) 
    Root page: 1373081, depth: 3, leaf buckets: 12694, nodes: 9643322 
    Average node length: 5.99, total dup: 8361131, max dup: 42 
    Average key length: 2.85, compression ratio: 3.15 
    Average prefix length: 8.28, average data length: 0.72 
    Clustering factor: 2396780, ratio: 0.25 
    Fill distribution: 
         0 - 19% = 3 
        20 - 39% = 67 
        40 - 59% = 9384 
        60 - 79% = 3112 
        80 - 99% = 128 
 
    Index XQS_1000_3300_WORKER_ID (0) 
    Root page: 1362789, depth: 3, leaf buckets: 10141, nodes: 9643322 
    Average node length: 5.14, total dup: 9643222, max dup: 160402 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.42, average data length: 0.00 
    Clustering factor: 1580666, ratio: 0.16 
    Fill distribution: 
         0 - 19% = 50 
        20 - 39% = 1260 
        40 - 59% = 4971 
        60 - 79% = 1850 
        80 - 99% = 2010 
 
XQS_1200_2000 (183) 
    Primary pointer page: 591, Index root page: 592 
    Total formats: 1, used formats: 1 
    Average record length: 81.71, total records: 11338564 
    Average version length: 82.57, total versions: 92673, 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: 119, data page slots: 192992 
    Data pages: 191504, average fill: 72% 
    Primary pages: 191385, secondary pages: 119, swept pages: 71804 
    Empty pages: 2238, full pages: 147653 
    Fill distribution: 
     0 - 19% = 3912 
    20 - 39% = 6440 
    40 - 59% = 16089 
    60 - 79% = 104948 
    80 - 99% = 60115 
 
    Index XQS_1200_2000_DOC_ID (1) 
    Root page: 1392123, depth: 3, leaf buckets: 13130, nodes: 11338564 
    Average node length: 5.32, total dup: 11228428, max dup: 620 
    Average key length: 2.08, compression ratio: 4.33 
    Average prefix length: 8.93, average data length: 0.07 
    Clustering factor: 2380113, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 115 
        40 - 59% = 8991 
        60 - 79% = 3836 
        80 - 99% = 187 
 
    Index XQS_1200_2000_RCV_ID (3) 
    Root page: 1406132, depth: 3, leaf buckets: 10507, nodes: 11338564 
    Average node length: 5.51, total dup: 10843798, max dup: 49 
    Average key length: 2.28, compression ratio: 3.95 
    Average prefix length: 8.77, average data length: 0.23 
    Clustering factor: 733961, ratio: 0.06 
    Fill distribution: 
         0 - 19% = 175 
        20 - 39% = 835 
        40 - 59% = 2614 
        60 - 79% = 1807 
        80 - 99% = 5076 
 
    Index XQS_1200_2000_SND_ID (2) 
    Root page: 1398660, depth: 3, leaf buckets: 15018, nodes: 11338564 
    Average node length: 6.05, total dup: 9890777, max dup: 61 
    Average key length: 2.81, compression ratio: 3.21 
    Average prefix length: 8.32, average data length: 0.68 
    Clustering factor: 2396452, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 3 
        20 - 39% = 121 
        40 - 59% = 10513 
        60 - 79% = 4149 
        80 - 99% = 232 
 
    Index XQS_1200_2000_WORKER_ID (0) 
    Root page: 1386233, depth: 3, leaf buckets: 10875, nodes: 11338564 
    Average node length: 5.24, total dup: 11338464, max dup: 201716 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.42, average data length: 0.00 
    Clustering factor: 721878, ratio: 0.06 
    Fill distribution: 
         0 - 19% = 94 
        20 - 39% = 804 
        40 - 59% = 4872 
        60 - 79% = 1633 
        80 - 99% = 3472 
 
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.72, total records: 9719578 
    Average version length: 82.85, total versions: 134052, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.54 
    Pointer pages: 107, data page slots: 174008 
    Data pages: 173960, average fill: 69% 
    Primary pages: 173940, secondary pages: 20, swept pages: 106801 
    Empty pages: 515, full pages: 90995 
    Fill distribution: 
     0 - 19% = 1515 
    20 - 39% = 5960 
    40 - 59% = 26169 
    60 - 79% = 125338 
    80 - 99% = 14978 
 
    Index XQS_2100_3300_DOC_ID (1) 
    Root page: 1344708, depth: 3, leaf buckets: 11824, nodes: 9719578 
    Average node length: 5.18, total dup: 9690745, max dup: 1547 
    Average key length: 2.03, compression ratio: 4.43 
    Average prefix length: 8.97, average data length: 0.03 
    Clustering factor: 1996591, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 33 
        20 - 39% = 1514 
        40 - 59% = 7901 
        60 - 79% = 1816 
        80 - 99% = 560 
 
    Index XQS_2100_3300_RCV_ID (3) 
    Root page: 1355739, depth: 3, leaf buckets: 13533, nodes: 9719578 
    Average node length: 6.25, total dup: 8056540, max dup: 14 
    Average key length: 3.10, compression ratio: 2.90 
    Average prefix length: 8.07, average data length: 0.93 
    Clustering factor: 1520287, ratio: 0.16 
    Fill distribution: 
         0 - 19% = 185 
        20 - 39% = 3840 
        40 - 59% = 4428 
        60 - 79% = 2527 
        80 - 99% = 2553 
 
    Index XQS_2100_3300_SND_ID (2) 
    Root page: 1350071, depth: 3, leaf buckets: 12490, nodes: 9719578 
    Average node length: 5.44, total dup: 9281357, max dup: 91 
    Average key length: 2.29, compression ratio: 3.93 
    Average prefix length: 8.76, average data length: 0.24 
    Clustering factor: 2131335, ratio: 0.22 
    Fill distribution: 
         0 - 19% = 33 
        20 - 39% = 1488 
        40 - 59% = 8853 
        60 - 79% = 1584 
        80 - 99% = 532 
 
    Index XQS_2100_3300_WORKER_ID (0) 
    Root page: 987843, depth: 3, leaf buckets: 10218, nodes: 9719578 
    Average node length: 5.15, total dup: 9719478, max dup: 163155 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.42, average data length: 0.00 
    Clustering factor: 1598501, ratio: 0.16 
    Fill distribution: 
         0 - 19% = 55 
        20 - 39% = 1263 
        40 - 59% = 5035 
        60 - 79% = 1765 
        80 - 99% = 2100 
 
XQS_3300_3400 (187) 
    Primary pointer page: 599, Index root page: 600 
    Total formats: 1, used formats: 1 
    Average record length: 67.84, total records: 580444 
    Average version length: 68.86, total versions: 3242, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.86 
    Pointer pages: 5, data page slots: 8128 
    Data pages: 8128, average fill: 75% 
    Primary pages: 8128, secondary pages: 0, swept pages: 3768 
    Empty pages: 2, full pages: 6941 
    Fill distribution: 
     0 - 19% = 2 
    20 - 39% = 5 
    40 - 59% = 116 
    60 - 79% = 7952 
    80 - 99% = 53 
 
    Index XQS_3300_3400_DOC_ID (1) 
    Root page: 48806, depth: 3, leaf buckets: 735, nodes: 580444 
    Average node length: 5.95, total dup: 494057, max dup: 83 
    Average key length: 3.09, compression ratio: 2.91 
    Average prefix length: 8.05, average data length: 0.95 
    Clustering factor: 101900, ratio: 0.18 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 26 
        40 - 59% = 510 
        60 - 79% = 105 
        80 - 99% = 93 
 
    Index XQS_3300_3400_SND_ID (2) 
    Root page: 31624, depth: 3, leaf buckets: 766, nodes: 580444 
    Average node length: 6.15, total dup: 476034, max dup: 21 
    Average key length: 3.29, compression ratio: 2.73 
    Average prefix length: 7.89, average data length: 1.11 
    Clustering factor: 101951, ratio: 0.18 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 27 
        40 - 59% = 544 
        60 - 79% = 104 
        80 - 99% = 91 
 
    Index XQS_3300_3400_WORKER_ID (0) 
    Root page: 377587, depth: 2, leaf buckets: 565, nodes: 580444 
    Average node length: 4.86, total dup: 580344, max dup: 9740 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.42, average data length: 0.00 
    Clustering factor: 90654, ratio: 0.16 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 23 
        40 - 59% = 339 
        60 - 79% = 64 
        80 - 99% = 139 
 
ZDOC_DATA (170) 
    Primary pointer page: 565, Index root page: 566 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
ZDOC_LIST (169) 
    Primary pointer page: 563, Index root page: 564 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
ZINVNT_TURNOVER_LOG (171) 
    Primary pointer page: 567, Index root page: 568 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
ZPDISTR (174) 
    Primary pointer page: 573, Index root page: 574 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index ZPDISTR_ID (0) 
    Root page: 1504230, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
ZPSTORNED (175) 
    Primary pointer page: 575, Index root page: 576 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index ZPSTORNED_ID (0) 
    Root page: 1504229, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
ZQDISTR (172) 
    Primary pointer page: 569, Index root page: 570 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index ZQDISTR_ID (0) 
    Root page: 1504235, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index ZQDISTR_WARE_SNDOP_RCVOP (1) 
    Root page: 1504236, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
ZQSTORNED (173) 
    Primary pointer page: 571, Index root page: 572 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index ZQSTORNED_DOC_ID (1) 
    Root page: 1504232, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index ZQSTORNED_ID (0) 
    Root page: 1504231, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index ZQSTORNED_RCV_ID (3) 
    Root page: 1504234, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index ZQSTORNED_SND_ID (2) 
    Root page: 1504233, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
ZTMP_DEP_DOCS (168) 
    Primary pointer page: 561, Index root page: 562 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
ZTMP_SHOPPING_CART (167) 
    Primary pointer page: 559, Index root page: 560 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
Z_USED_VIEWS (144) 
    Primary pointer page: 512, Index root page: 513 
    Total formats: 1, used formats: 1 
    Average record length: 29.38, total records: 29 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 99.00, compression ratio: 3.37 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 16% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index Z_USED_VIEWS_UNQ (0) 
    Root page: 1510372, depth: 1, leaf buckets: 1, nodes: 29 
    Average node length: 15.17, total dup: 0, max dup: 0 
    Average key length: 14.14, compression ratio: 1.44 
    Average prefix length: 9.17, average data length: 11.17 
    Clustering factor: 1, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
Gstat completion time Mon Apr  8 13:10:22 2024

Record versions statistics, table

TABLE_NAME TOTAL_RECS TOTAL_VERS MAX_VERSIONS VERS_TO_RECS_PRC MAXV_TO_VERS_PRC
DOC_DATA 7750177 20293 1 0.0000 0.0000
DOC_LIST 2253504 18000 2 0.0000 0.0000
FB_ERRORS 2182 757 1 0.0000 0.0000
INVNT_SALDO 400 2050 6 500.0000 0.0000
INVNT_TURNOVER_LOG 76184 72677 1 0.0000 0.0000
MONEY_SALDO 49 152 5 300.0000 0.0000
MONEY_TURNOVER_LOG 1593 1279 1 0.0000 0.0000
PDISTR 765763 19718 2 0.0000 0.0000
PERF_SPLIT_0 161166 1375 1 0.0000 0.0000
PERF_SPLIT_1 133130 3849 1 0.0000 0.0000
PERF_SPLIT_2 159159 782 1 0.0000 0.0000
PERF_SPLIT_3 150912 20146 1 0.0000 0.0000
PERF_SPLIT_4 145145 563 1 0.0000 0.0000
PERF_SPLIT_5 142421 11128 1 0.0000 0.0000
PERF_SPLIT_6 154377 3478 1 0.0000 0.0000
PERF_SPLIT_7 147610 2020 1 0.0000 0.0000
PERF_SPLIT_8 153851 3162 1 0.0000 0.0000
PERF_SPLIT_9 158218 3082 1 0.0000 0.0000
PSTORNED 2112838 12462 1 0.0000 0.0000
SEMAPHORES 5 1 1 0.0000 100.0000
XQD_1000_1200 137185 53995 1 0.0000 0.0000
XQD_1000_3300 6732539 272317 1 0.0000 0.0000
XQD_1200_2000 11689306 202428 1 0.0000 0.0000
XQD_2000_3300 1315759 226222 1 0.0000 0.0000
XQD_2100_3300 1008461 115545 1 0.0000 0.0000
XQD_3300_3400 9154229 143110 1 0.0000 0.0000
XQS_1000_1200 21154405 4397 1 0.0000 0.0000
XQS_1000_3300 9643322 175240 1 0.0000 0.0000
XQS_1200_2000 11338564 92673 1 0.0000 0.0000
XQS_2100_3300 9719578 134052 1 0.0000 0.0000
XQS_3300_3400 580444 3242 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'  

08.04.24 13:10:34. 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-08 13:10:37 No severe PSQL-related problems occured
08.04.24 13:10:38. End of report.