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

Hardware and OS info

Command: hostnamectl
Static hostname mscs-test-161.budzdorov.ru
Icon name computer-server
Chassis server
Machine ID aeee285d2cca40bf84c40a748f599e77
Boot ID 2a7b53d1c5ed44b9bb2712fffac5d8c6
Operating System CentOS Linux 7 (Core)
CPE OS Name cpe:/o:centos:centos:7
Kernel Linux 3.10.0-1127.10.1.el7.x86_64
Architecture x86-64
Command: who -b
bootup_info system boot 2021-11-11 18:28
Command: dmidecode -t system|grep -i -e 'manufacturer\|product\|hypervisor'
Manufacturer HP
Product Name ProLiant DL380 Gen9
Command: dmesg | grep DMI
[ 0.000000] DMI HP ProLiant DL380 Gen9/ProLiant DL380 Gen9, BIOS P89 05/21/2018
Command: lscpu | grep -i -v flags
Architecture x86_64
CPU op-mode(s) 32-bit, 64-bit
Byte Order Little Endian
CPU(s) 24
On-line CPU(s) list 0-23
Thread(s) per core 2
Core(s) per socket 6
Socket(s) 2
NUMA node(s) 2
Vendor ID GenuineIntel
CPU family 6
Model 63
Model name Intel(R) Xeon(R) CPU E5-2620 v3 @ 2.40GHz
Stepping 2
CPU MHz 1200.000
CPU max MHz 2400.0000
CPU min MHz 1200.0000
BogoMIPS 4794.33
Virtualization VT-x
L1d cache 32K
L1i cache 32K
L2 cache 256K
L3 cache 15360K
NUMA node0 CPU(s) 0-5,12-17
NUMA node1 CPU(s) 6-11,18-23
Command: cat /proc/meminfo | grep -i -e 'memtotal\|memfree\|memavail\|buffers\|cached\|swapcached'
MemTotal 32643792 kB
MemFree 15706272 kB
MemAvailable 30276372 kB
Buffers 20 kB
Cached 15996396 kB
SwapCached 2604 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-03-24 04:07:52
DTS_END                         2024-03-24 04:07:52.0980
FB_GDSCODE                      -1
FB_MNEMONA                      
STACK                           SP_CANCEL_SUPPLIER_ORDER(116:18) ==> SP_CANCEL_CUSTOMER_RESERVE(36:5) ==> SP_CHECK_TO_STOP_WORK(32:12) ==> SP_HALT_ON_ERROR(68:17)
IP                              ::1/34952
TRN_ID                          170344
ATT_ID                          537
EXC_UNIT                        2

Test workload details

SETTING_NAME SETTING_VALUE
WORKING_MODE SMALL_03
C_WARES_MAX_ID 400
C_CUSTOMER_DOC_MAX_ROWS 10
C_SUPPLIER_DOC_MAX_ROWS 50
C_CUSTOMER_DOC_MAX_QTY 15
C_SUPPLIER_DOC_MAX_QTY 50
C_NUMBER_OF_AGENTS 50

Indexes for heavy-loaded tables

TAB_NAME IDX_NAME IDX_KEY
XQD_1000_1200 XQD_1000_1200_WA_SO_RO_WKR_SND WARE_ID,SND_OPTYPE_ID,RCV_OPTYPE_ID,WORKER_ID,SND_ID
XQD_1000_3300 XQD_1000_3300_WA_SO_RO_WKR_SND WARE_ID,SND_OPTYPE_ID,RCV_OPTYPE_ID,WORKER_ID,SND_ID
XQD_1000_3300 XQD_1000_3300_WKR_DOC_ASC WORKER_ID,DOC_ID
XQD_1000_3300 XQD_1000_3300_WKR_DOC_DEC WORKER_ID,DOC_ID
XQD_1200_2000 XQD_1200_2000_WA_SO_RO_WKR_SND WARE_ID,SND_OPTYPE_ID,RCV_OPTYPE_ID,WORKER_ID,SND_ID
XQD_2000_3300 XQD_2000_3300_WA_SO_RO_WKR_SND WARE_ID,SND_OPTYPE_ID,RCV_OPTYPE_ID,WORKER_ID,SND_ID
XQD_2100_3300 XQD_2100_3300_WA_SO_RO_WKR_SND WARE_ID,SND_OPTYPE_ID,RCV_OPTYPE_ID,WORKER_ID,SND_ID
XQD_3300_3400 XQD_3300_3400_WA_SO_RO_WKR_SND WARE_ID,SND_OPTYPE_ID,RCV_OPTYPE_ID,WORKER_ID,SND_ID

Performance in TOTAL

ACTION AVG_TIMES_PER_MINUTE AVG_ELAPSED_MS SUCCESSFUL_TIMES_DONE
*** OVERALL *** for 100 minutes: 9203.21 19352 920321
customer order: creation 170.90 370 17090
customer order: refuse 15.15 370 1515
order to supplier: creation 46.25 1263 4625
order to supplier: removal 3.66 83828 366
invoice (draft): creation 46.43 3130 4643
invoice (draft): removal 50.46 713 5046
invoice accept: apply 42.36 20628 4236
invoice accept: cancel 45.70 806 4570
customer reserve: creation 4040.63 200 404063
customer reserve: removal 4440.06 55 444006
realization accept: apply 85.81 195 8581
realization accept: cancel 86.26 131 8626
payment from customer: creation 59.89 118 5989
payment from customer: removal 5.78 81 578
payment to supplier: creation 48.57 153 4857
payment to supplier: removal 3.53 64 353
service: total inventory turnovers 4.35 3297 435
service: total monetary turnovers 6.40 518 640
service: aggregate perf. data 0.98 13831 98
service: refresh index statistics 0.04 257280 4

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:02, from 24-03-2024 04:10:19 to 24-03-2024 04:10:21.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 2187
TEST_TIME 2 2979
TEST_TIME 3 3549
TEST_TIME 4 4146
TEST_TIME 5 3568
TEST_TIME 6 4281
TEST_TIME 7 5154
TEST_TIME 8 5462
TEST_TIME 9 5820
TEST_TIME 10 6480
TEST_TIME 11 6475
TEST_TIME 12 6779
TEST_TIME 13 7079
TEST_TIME 14 7053
TEST_TIME 15 7185
TEST_TIME 16 7437
TEST_TIME 17 8104
TEST_TIME 18 7916
TEST_TIME 19 8231
TEST_TIME 20 8137
TEST_TIME 21 8013
TEST_TIME 22 8333
TEST_TIME 23 8827
TEST_TIME 24 8774
TEST_TIME 25 8997
TEST_TIME 26 9248
TEST_TIME 27 9497
TEST_TIME 28 9461
TEST_TIME 29 9229
TEST_TIME 30 9270
TEST_TIME 31 9596
TEST_TIME 32 9467
TEST_TIME 33 9347
TEST_TIME 34 9592
TEST_TIME 35 9402
TEST_TIME 36 9242
TEST_TIME 37 9286
TEST_TIME 38 9098
TEST_TIME 39 9118
TEST_TIME 40 9123
TEST_TIME 41 9117
TEST_TIME 42 9154
TEST_TIME 43 9175
TEST_TIME 44 9099
TEST_TIME 45 9100
TEST_TIME 46 9171
TEST_TIME 47 9159
TEST_TIME 48 9250
TEST_TIME 49 9374
TEST_TIME 50 9426
TEST_TIME 51 9530
TEST_TIME 52 9502
TEST_TIME 53 9511
TEST_TIME 54 9438
TEST_TIME 55 9457
TEST_TIME 56 9618
TEST_TIME 57 9629
TEST_TIME 58 9514
TEST_TIME 59 9404
TEST_TIME 60 9296
TEST_TIME 61 9234
TEST_TIME 62 9275
TEST_TIME 63 9248
TEST_TIME 64 9190
TEST_TIME 65 9149
TEST_TIME 66 9115
TEST_TIME 67 9090
TEST_TIME 68 9071
TEST_TIME 69 9097
TEST_TIME 70 9128
TEST_TIME 71 9177
TEST_TIME 72 9199
TEST_TIME 73 9266
TEST_TIME 74 9233
TEST_TIME 75 9289
TEST_TIME 76 9282
TEST_TIME 77 9460
TEST_TIME 78 9470
TEST_TIME 79 9390
TEST_TIME 80 9335
TEST_TIME 81 9298
TEST_TIME 82 9225
TEST_TIME 83 9204
TEST_TIME 84 9204
TEST_TIME 85 9193
TEST_TIME 86 9232
TEST_TIME 87 9244
TEST_TIME 88 9222
TEST_TIME 89 9234
TEST_TIME 90 9327
TEST_TIME 91 9281
TEST_TIME 92 9292
TEST_TIME 93 9367
TEST_TIME 94 9360
TEST_TIME 95 9352
TEST_TIME 96 9383
TEST_TIME 97 9317
TEST_TIME 98 9252
TEST_TIME 99 9258
TEST_TIME 100 9208
TEST_TIME 101 9117

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:04, from 24-03-2024 04:10:22 to 24-03-2024 04:10:26.

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 1289560 1289560 0 0.00 0 21211 7 0 0
doc_list_biud 1289558 1289558 0 0.00 0 69740 24 0 0
sp_add_invoice_to_stock 4319 4236 83 1.92 38 193528 20628 0 83
sp_cancel_adding_invoice 4570 4570 0 0.00 2 102412 807 0 0
sp_cancel_client_order 1515 1515 0 0.00 4 13550 371 0 0
sp_cancel_customer_reserve 444006 444006 0 0.00 0 69742 55 0 0
sp_cancel_pay_from_customer 578 578 0 0.00 3 13112 81 0 0
sp_cancel_pay_to_supplier 353 353 0 0.00 2 1819 65 0 0
sp_cancel_supplier_invoice 5054 5046 8 0.15 1 68969 714 0 8
sp_cancel_supplier_order 366 366 0 0.00 11 780697 83828 0 0
sp_cancel_write_off 8626 8626 0 0.00 1 16992 132 0 0
sp_client_order 17090 17090 0 0.00 3 23713 371 0 0
sp_customer_reserve 404063 404063 0 0.00 0 40544 201 0 0
sp_fill_shopping_cart 26350 26350 0 0.00 1 15503 42 0 0
sp_fill_shopping_cart_clo_res 404058 404058 0 0.00 0 25369 19 0 0
sp_get_clo_for_invoice 4231 4231 0 0.00 0 58878 370 0 0
sp_kill_cost_storno 14127 14127 0 0.00 0 16965 65 0 0
sp_kill_qstorno_ret_qs2qd 902050 902050 0 0.00 0 68962 30 0 0
sp_kill_qty_storno 476937 476937 0 0.00 0 69740 65 0 0
sp_lock_selected_doc 17742 17742 0 0.00 0 8412 6 0 0
sp_make_cost_storno 23656 23656 0 0.00 0 17387 66 0 0
sp_multiply_rows_for_pdistr 23654 23654 0 0.00 0 16160 36 0 0
sp_multiply_rows_for_qdistr 17090 17090 0 0.00 0 17774 189 0 0
sp_pay_from_customer 5989 5989 0 0.00 4 17779 119 0 0
sp_pay_to_supplier 4857 4857 0 0.00 4 15538 153 0 0
sp_payment_common 10846 10846 0 0.00 1 14331 27 0 0
sp_qd_handle_on_cancel_clo 1515 1515 0 0.00 0 13543 351 0 0
sp_qd_handle_on_invoice_upd_sts 8797 8797 0 0.00 0 20954 287 0 0
sp_qd_handle_on_reserve_upd_sts 8581 8581 0 0.00 0 29684 67 0 0
sp_reserve_write_off 8581 8581 0 0.00 6 29781 195 0 0
sp_supplier_invoice 4643 4643 0 0.00 5 85812 3131 0 0
sp_supplier_order 4625 4625 0 0.00 4 30408 1264 0 0
srv_aggregate_perf_data 98 98 0 0.00 1415 254652 13832 0 0
srv_fill_mon_cache_memory 56 56 0 0.00 945 174004 43131 0 0
srv_find_qd_qs_mism 877362 877362 0 0.00 0 21210 6 0 0
srv_make_invnt_saldo 435 435 0 0.00 43 85773 3298 0 0
srv_make_money_saldo 640 640 0 0.00 1 18837 519 0 0
srv_recalc_idx_stat 4 4 0 0.00 139919 423991 257281 0 0
t$perf-abend:sp_add_invoice_to_stock 83 83 0 0.00 0 0 0 0 0
t$perf-abend:sp_cancel_supplier_invoice 8 8 0 0.00 0 0 0 0 0
t$perf-norm:sp_add_invoice_to_stock 4238 4238 0 0.00 0 28311 167 0 0
t$perf-norm:sp_cancel_adding_invoice 360 360 0 0.00 0 2793 89 0 0
t$perf-norm:sp_cancel_client_order 1515 1515 0 0.00 0 27743 27 0 0
t$perf-norm:sp_cancel_customer_reserve 590 590 0 0.00 0 2195 11 0 0
t$perf-norm:sp_cancel_pay_from_customer 578 578 0 0.00 0 255 3 0 0
t$perf-norm:sp_cancel_pay_to_supplier 353 353 0 0.00 0 295 3 0 0
t$perf-norm:sp_cancel_supplier_invoice 311 311 0 0.00 0 3553 25 0 0
t$perf-norm:sp_cancel_supplier_order 366 366 0 0.00 0 21261 1440 0 0
t$perf-norm:sp_cancel_write_off 861 861 0 0.00 0 2446 8 0 0
t$perf-norm:sp_client_order 17090 17090 0 0.00 0 25874 18 0 0
t$perf-norm:sp_customer_reserve 835 835 0 0.00 0 879 6 0 0
t$perf-norm:sp_pay_from_customer 5989 5989 0 0.00 0 4717 15 0 0
t$perf-norm:sp_pay_to_supplier 4857 4857 0 0.00 0 6156 13 0 0
t$perf-norm:sp_reserve_write_off 8581 8581 0 0.00 0 28630 17 0 0
t$perf-norm:sp_supplier_invoice 4643 4643 0 0.00 0 4480 15 0 0
t$perf-norm:sp_supplier_order 4625 4625 0 0.00 0 3399 13 0 0
t$perf-norm:srv_aggregate_perf_data 98 98 0 0.00 0 711 15 0 0
t$perf-norm:srv_fill_mon_cache_memory 56 56 0 0.00 0 3115 67 0 0
t$perf-norm:srv_make_invnt_saldo 435 435 0 0.00 0 1191 11 0 0
t$perf-norm:srv_make_money_saldo 640 640 0 0.00 0 1120 5 0 0
t$perf-norm:srv_recalc_idx_stat 4 4 0 0.00 1 75 27 0 0
v_add_invoice_to_stock 8620 8454 166 1.92 0 3667 15 0 166
v_all_customers 31968 31968 0 0.00 0 106 1 0 0
v_all_suppliers 26122 26122 0 0.00 0 118 1 0 0
v_all_wares 34178 34178 0 0.00 0 22 1 0 0
v_cancel_adding_invoice 720 720 0 0.00 0 1202 8 0 0
v_cancel_client_order 3030 3030 0 0.00 0 2211 4 0 0
v_cancel_customer_prepayment 1156 1156 0 0.00 0 1442 6 0 0
v_cancel_customer_reserve 1180 1180 0 0.00 0 1097 4 0 0
v_cancel_payment_to_supplier 706 706 0 0.00 0 1204 5 0 0
v_cancel_supplier_invoice 638 622 16 2.50 0 1992 15 0 16
v_cancel_supplier_order 732 732 0 0.00 0 1423 6 0 0
v_cancel_write_off 1722 1722 0 0.00 0 1196 13 0 0
v_max_id_clo_ord 4623 4623 0 0.00 0 440 1 0 0
v_max_id_clo_res 835 835 0 0.00 0 7199 18 0 0
v_max_id_ord_sup 4638 4638 0 0.00 0 10739 8 0 0
v_max_non_paid_invoice 1057 1057 0 0.00 0 33 1 0 0
v_max_non_paid_realizn 2787 2787 0 0.00 0 3964 4 0 0
v_min_id_clo_ord 4623 4623 0 0.00 0 2376 7 0 0
v_min_id_clo_res 835 835 0 0.00 0 8158 31 0 0
v_min_id_ord_sup 4638 4638 0 0.00 0 6853 9 0 0
v_min_non_paid_invoice 4857 4857 0 0.00 0 13676 24 0 0
v_min_non_paid_realizn 5989 5989 0 0.00 0 14327 16 0 0
v_our_firm 8614 8614 0 0.00 0 31 1 0 0
v_reserve_write_off 17162 17162 0 0.00 0 4001 5 0 0
x_lock_depdocs_on_canc_invoice 9305 9305 0 0.00 0 24318 115 0 0
x_lock_depdocs_on_canc_sup_ord 366 366 0 0.00 0 13755 365 0 0
x_make_qstorno_1000_1200 4625 4625 0 0.00 1 30404 1193 0 0
x_make_qstorno_1200_2000 4643 4643 0 0.00 2 84770 2960 0 0
x_make_qstorno_2100_3300 404063 404063 0 0.00 0 35269 179 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 24-03-2024 04:10:27 to 24-03-2024 04:10:31.

Memory consumption, metadata cache, attachments activity 

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


Page cache type: shared, buffers: 1000000 for all connections, with total size: 8192000000
measurement_dts measurement duration ms page cache memo used memo used, total memo allocated, total metadata cache metadata cache percent of total total attachments cnt active attachments cnt running statements cnt stalled statements cnt memo used by attachments memo used by transactions memo used by statements
02:07:55 2 8192000000 8799069344 8810516480 4076656 0.049 2 1 2 0 4176048 63616 35776
02:08:56 23686 8192000000 9715499776 10012303360 790648896 8.801 100 87 174 0 819018080 7339808 21029376
02:10:24 18534 8192000000 9764148880 10075930624 843059968 9.330 100 88 176 0 873791440 10596096 20135376
02:11:46 19393 8192000000 9797181488 10116096000 867182176 9.572 100 92 184 0 905879984 18182880 20514928
02:13:13 9164 8192000000 9838944048 10170568704 901477200 9.913 100 76 152 0 953436976 35273488 16686288
02:14:29 5323 8192000000 9889216288 10233835520 938449040 10.278 100 77 154 0 1004059904 49323616 16287248
02:15:36 4214 8192000000 9929363648 10284707840 974465408 10.630 100 75 150 0 1044076560 54563024 15048128
02:16:44 2340 8192000000 9976970640 10338516992 1000438448 10.883 100 81 159 0 1090555744 74939376 15177920
02:17:49 1842 8192000000 9985606240 10350460928 1020429072 11.076 100 87 172 1 1099364752 62209376 16726304
02:18:54 2449 8192000000 10002107648 10377179136 1033260480 11.200 100 75 146 0 1124356336 76995024 14100832
02:19:59 1590 8192000000 10018446640 10395701248 1057991328 11.437 100 89 177 2 1136467312 60863808 17612176
02:21:02 23484 8192000000 9996481408 10387443712 1058608976 11.443 100 47 93 0 1135699744 68178784 8911984
02:22:27 4161 8192000000 9984561200 10382123008 1068456928 11.537 100 28 56 1 1105592976 31356544 5779504
02:23:32 8350 8192000000 9988841200 10398330880 1078729632 11.635 100 40 80 0 1101909216 13603856 9575728
02:24:42 57401 8192000000 9991753472 10400620544 1085666880 11.701 100 37 75 0 1123229584 28522880 9039824
02:26:40 6994 8192000000 10010235808 10426863616 1092690400 11.768 100 45 91 1 1124628272 22521312 9416560
02:27:50 31802 8192000000 10017785392 10420535296 1100572960 11.843 100 39 76 0 1123381456 15314384 7494112
02:29:27 13446 8192000000 10095191712 10493505536 1107416672 11.908 99 59 116 0 1181857168 63153104 11287392
02:30:48 99053 8192000000 10099897072 10509287424 1097903568 11.818 98 34 68 1 1211939312 106754336 7281408
02:33:44 15778 8192000000 10092701952 10531090432 1100107024 11.839 100 31 59 2 1219353472 112359344 6887104
02:35:06 28316 8192000000 10093351184 10512384000 1109109456 11.924 99 41 82 0 1211231504 93746352 8375696
02:36:40 6107 8192000000 10097277088 10490757120 1079858240 11.646 99 54 108 0 1203655264 113321568 10475456
02:37:52 9450 8192000000 10063024128 10465542144 1089102512 11.734 99 43 84 0 1169070528 71185936 8782080
02:39:14 13760 8192000000 10087350000 10485825536 1077258960 11.621 97 43 86 1 1177128256 90903264 8966032
02:40:32 942 8192000000 10099563520 10479448064 1081062384 11.658 99 87 172 4 1199664320 100761776 17840160
02:41:37 9612 8192000000 10176179488 10568941568 1101104672 11.848 100 73 146 1 1286850768 170406352 15339744
02:42:53 2962 8192000000 10186401840 10576089088 1079563104 11.643 100 69 138 0 1287962064 193456320 14942640
02:44:00 2175 8192000000 10184293776 10574401536 1100999760 11.847 100 75 150 1 1283574240 166840128 15734352
02:45:05 25320 8192000000 10184554976 10598445056 1094017552 11.781 99 45 90 0 1286693152 182757312 9918288
02:46:49 4908 8192000000 10197300016 10634092544 1115712464 11.986 100 44 86 0 1303729696 179040624 8976608
02:48:18 6668 8192000000 10215288064 10616811520 1102654000 11.863 100 50 101 1 1312539520 198971408 10914112
02:49:30 4477 8192000000 10248461120 10676875264 1108185408 11.915 100 51 103 1 1355438368 235490048 11762912
02:50:39 14528 8192000000 10183095888 10650394624 1107430064 11.908 100 16 32 0 1298182512 187022880 3729568
02:52:02 24336 8192000000 10137134352 10591481856 1112377664 11.955 100 25 50 0 1268771072 150685552 5707856
02:53:28 19214 8192000000 10146137760 10617643008 1112530704 11.956 100 10 20 0 1247628544 132654880 2442960
02:55:43 47226 8192000000 10088710608 10510639104 1127443360 12.097 100 39 75 0 1189520480 54341728 7735392
02:57:32 50315 8192000000 10129808544 10578944000 1118158912 12.010 99 9 18 0 1221187328 100966384 2062032
02:59:23 26937 8192000000 10056397328 10485358592 1131781920 12.138 100 21 43 0 1154382000 17927488 4672592
03:00:53 36817 8192000000 10085024208 10572226560 1138018896 12.197 100 21 42 1 1211209488 69227136 3963456
03:02:32 107434 8192000000 10090758736 10530398208 1147589472 12.287 100 37 74 1 1178080416 23115824 7375120
03:05:24 39577 8192000000 10072378656 10520072192 1135330848 12.172 99 20 40 0 1177658256 37912432 4414976
03:07:05 23580 8192000000 10134977264 10576498688 1142560432 12.240 100 31 62 0 1219574960 70006240 7008288
03:08:37 45451 8192000000 10138525280 10603139072 1136141152 12.179 99 20 40 0 1227343024 86616368 4585504
03:10:23 62999 8192000000 10145630368 10629627904 1137294128 12.190 99 18 36 0 1226545968 85423296 3828544
03:12:28 51433 8192000000 10065991168 10574774272 1137512960 12.192 99 13 26 0 1219729584 79440480 2776144
03:14:20 13438 8192000000 10115823904 10555207680 1149283760 12.303 100 36 72 1 1202339376 46104416 6951200
03:15:39 57089 8192000000 10103702528 10586488832 1149356944 12.303 100 17 34 0 1214525152 62068224 3099984
03:18:02 80985 8192000000 10073957312 10554941440 1102622080 11.863 96 12 24 0 1190702288 85711472 2368736
03:20:23 22353 8192000000 10143845664 10589835264 1144092160 12.254 100 37 72 0 1222320992 71260288 6968544
03:21:48 49069 8192000000 10171154064 10629988352 1124666480 12.071 99 26 52 0 1248491232 118447776 5376976
03:23:38 174004 8192000000 10008106256 10442334208 964521424 10.533 86 28 56 1 1022607888 52363552 5722912
03:27:32 45876 8192000000 10021751840 10441236480 1078429808 11.633 98 40 78 2 1105372944 19244192 7698944
03:29:19 52020 8192000000 10054440608 10524758016 1114743504 11.977 100 22 45 0 1183651744 64545488 4362752
03:31:12 66851 8192000000 10036620272 10504953856 1050502656 11.365 95 10 19 0 1100681456 48214608 1964192
03:33:19 43634 8192000000 9996116512 10438459392 1057280848 11.430 97 17 33 0 1086591888 25959552 3351488
03:35:03 26764 8192000000 10028931376 10469752832 1081004560 11.657 99 22 40 1 1122156496 36974624 4177312
03:36:30 56754 8192000000 10029432656 10495606784 1065908976 11.513 98 19 38 1 1128708064 58722624 4076464
03:38:27 62468 8192000000 10061348240 10525732864 1068831328 11.541 98 30 60 0 1152846912 77918864 6096720
03:40:31 85941 8192000000 10058215760 10486272000 1067386528 11.527 97 21 42 0 1119044016 47871232 3786256
03:43:03 62742 8192000000 10119720464 10593161216 1096375328 11.803 98 26 52 0 1203796000 102371056 5049616
03:45:06 56700 8192000000 10064965136 10528677888 1110496768 11.937 99 16 32 0 1155849536 42077408 3275360
03:47:05 75996 8192000000 10076314992 10536796160 1121161824 12.038 100 27 52 0 1183680784 56791008 5727952
03:49:23 65223 8192000000 10110772288 10567573504 1119885424 12.026 99 12 24 0 1205683184 82828928 2968832
03:51:29 41664 8192000000 10059988016 10523131904 1127950272 12.102 100 14 28 0 1183196768 52489952 2756544
03:53:12 47519 8192000000 10063181216 10531549184 1110196880 11.934 98 20 40 0 1164320480 49599792 4523808
03:54:59 24735 8192000000 10097460688 10521853952 1122308288 12.049 99 31 62 0 1166486496 38245120 5933088
03:56:28 103071 8192000000 10061773808 10560278528 1123032896 12.056 99 13 26 2 1226193184 99994336 3165952
03:59:14 64933 8192000000 10121979680 10571685888 1127951920 12.102 99 15 28 0 1185744480 54812512 2980048
04:01:20 15701 8192000000 10069550464 10495549440 1128913840 12.111 100 42 83 0 1153775120 17119456 7741824
04:02:36 25749 8192000000 10087538016 10533408768 1121681648 12.043 99 24 48 0 1174067344 47574016 4811680
04:04:04 102647 8192000000 10062406592 10506096640 1135104432 12.169 100 33 66 0 1168478496 26931024 6443040
04:06:49 66753 8192000000 9957594688 10399813632 994251488 10.823 88 11 22 0 1040631280 44047552 2332240

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:14, from 24-03-2024 04:10:33 to 24-03-2024 04:10:47.

Exceptions occured during test was in run

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

Completed "Exceptions occured during test was in run". Done for 00:00:02, from 24-03-2024 04:10:48 to 24-03-2024 04:10:50.

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          171476
MON$OLDEST_ACTIVE               171477
MON$OLDEST_SNAPSHOT             171477
MON$NEXT_TRANSACTION            171477
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                       1910560
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             685
MON$NEXT_STATEMENT              53
MON$REPLICA_MODE                0


ISQL Version: LI-V4.0.5.3081 Firebird 4.0
Server version:
Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V4.0.5.3081 Firebird 4.0"
Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-V4.0.5.3081 Firebird 4.0/tcp (mscs-test-161.budzdorov.ru)/P17:C"
Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-V4.0.5.3081 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 Sun Mar 24 04:10:51 2024 
 
Database header page information: 
    Flags            0 
    Generation        89542 
    System Change Number    0 
    Page size        8192 
    ODS version        13.0 
    Oldest transaction    171476 
    Oldest active        171477 
    Oldest snapshot        171477 
    Next transaction    171478 
    Sequence number        0 
    Next attachment ID    685 
    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.78, total records: 7649845 
    Average version length: 48.16, total versions: 22608, 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: 88664 
    Data pages: 88664, average fill: 69% 
    Primary pages: 88663, secondary pages: 1, swept pages: 53563 
    Empty pages: 12, full pages: 59346 
    Fill distribution: 
     0 - 19% = 32 
    20 - 39% = 186 
    40 - 59% = 3813 
    60 - 79% = 84614 
    80 - 99% = 19 
 
    Index DOC_DATA_DOC_WARE_UNQ (0) 
    Root page: 1510636, depth: 3, leaf buckets: 23021, nodes: 7649845 
    Average node length: 18.85, total dup: 0, max dup: 0 
    Average key length: 15.86, compression ratio: 1.70 
    Average prefix length: 14.14, average data length: 12.86 
    Clustering factor: 1658424, ratio: 0.22 
    Fill distribution: 
         0 - 19% = 294 
        20 - 39% = 1944 
        40 - 59% = 3894 
        60 - 79% = 2693 
        80 - 99% = 14196 
 
    Index DOC_DATA_ID_DESC (1) 
    Root page: 1528140, depth: 3, leaf buckets: 13374, nodes: 7649845 
    Average node length: 11.20, total dup: 0, max dup: 0 
    Average key length: 8.21, compression ratio: 1.10 
    Average prefix length: 3.78, average data length: 5.22 
    Clustering factor: 1482932, ratio: 0.19 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 1647 
        40 - 59% = 1828 
        60 - 79% = 1286 
        80 - 99% = 8613 
 
    Index FK_DOC_DATA_DOC_LIST (2) 
    Root page: 1546735, depth: 3, leaf buckets: 8270, nodes: 7649845 
    Average node length: 6.60, total dup: 5748644, max dup: 49 
    Average key length: 3.61, compression ratio: 2.49 
    Average prefix length: 7.64, average data length: 1.36 
    Clustering factor: 1476118, ratio: 0.19 
    Fill distribution: 
         0 - 19% = 139 
        20 - 39% = 1018 
        40 - 59% = 1288 
        60 - 79% = 1054 
        80 - 99% = 4771 
 
DOC_LIST (138) 
    Primary pointer page: 500, Index root page: 501 
    Total formats: 1, used formats: 1 
    Average record length: 57.13, total records: 2192242 
    Average version length: 58.79, total versions: 12770, 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: 28392 
    Data pages: 28392, average fill: 71% 
    Primary pages: 28390, secondary pages: 2, swept pages: 17281 
    Empty pages: 1, full pages: 15246 
    Fill distribution: 
     0 - 19% = 4 
    20 - 39% = 44 
    40 - 59% = 818 
    60 - 79% = 27500 
    80 - 99% = 26 
 
    Index DOC_LIST_ID_DESC (1) 
    Root page: 1541152, depth: 3, leaf buckets: 4492, nodes: 2192242 
    Average node length: 11.41, total dup: 0, max dup: 0 
    Average key length: 8.45, compression ratio: 1.06 
    Average prefix length: 3.54, average data length: 5.46 
    Clustering factor: 676880, ratio: 0.31 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 922 
        40 - 59% = 806 
        60 - 79% = 827 
        80 - 99% = 1937 
 
    Index DOC_LIST_WORKER_OPTYPE (2) 
    Root page: 1544398, depth: 3, leaf buckets: 2404, nodes: 2192833 
    Average node length: 4.97, total dup: 2191934, max dup: 18957 
    Average key length: 2.01, compression ratio: 4.47 
    Average prefix length: 8.99, average data length: 0.01 
    Clustering factor: 1250107, ratio: 0.57 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 236 
        40 - 59% = 1402 
        60 - 79% = 542 
        80 - 99% = 223 
 
    Index FK_DOC_LIST_AGENTS (3) 
    Root page: 1545933, depth: 3, leaf buckets: 1752, nodes: 2192242 
    Average node length: 4.97, total dup: 2192192, max dup: 130123 
    Average key length: 2.01, compression ratio: 4.48 
    Average prefix length: 8.99, average data length: 0.01 
    Clustering factor: 1048582, ratio: 0.48 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 3 
        40 - 59% = 604 
        60 - 79% = 50 
        80 - 99% = 1095 
 
    Index PK_DOC_LIST (0) 
    Root page: 1538209, depth: 3, leaf buckets: 4310, nodes: 2192242 
    Average node length: 11.41, total dup: 0, max dup: 0 
    Average key length: 8.45, compression ratio: 1.06 
    Average prefix length: 3.55, average data length: 5.45 
    Clustering factor: 676880, ratio: 0.31 
    Fill distribution: 
         0 - 19% = 100 
        20 - 39% = 618 
        40 - 59% = 600 
        60 - 79% = 924 
        80 - 99% = 2068 
 
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.06, total records: 400 
    Average version length: 24.02, total versions: 631, max versions: 7 
    Average fragment length: 2.00, total fragments: 15, max fragments: 1 
    Average unpacked length: 104.00, compression ratio: 1.25 
    Pointer pages: 1, data page slots: 24 
    Data pages: 24, average fill: 37% 
    Primary pages: 7, secondary pages: 17, swept pages: 0 
    Empty pages: 5, full pages: 6 
    Fill distribution: 
     0 - 19% = 8 
    20 - 39% = 9 
    40 - 59% = 1 
    60 - 79% = 0 
    80 - 99% = 6 
 
    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: 16.98, total records: 70463 
    Average version length: 68.27, total versions: 60981, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 88.00, compression ratio: 5.18 
    Pointer pages: 6, data page slots: 2480 
    Data pages: 1520, average fill: 63% 
    Primary pages: 1519, secondary pages: 1, swept pages: 81 
    Empty pages: 101, full pages: 766 
    Fill distribution: 
     0 - 19% = 216 
    20 - 39% = 204 
    40 - 59% = 210 
    60 - 79% = 224 
    80 - 99% = 666 
 
    Index INVNT_TURNOVER_LOG_WARE_DD_ID (0) 
    Root page: 1694775, depth: 3, leaf buckets: 304, nodes: 70463 
    Average node length: 13.71, total dup: 2813, max dup: 1 
    Average key length: 10.96, compression ratio: 2.46 
    Average prefix length: 18.99, average data length: 8.01 
    Clustering factor: 53685, ratio: 0.76 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 197 
        40 - 59% = 81 
        60 - 79% = 25 
        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: 83, 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: 49% 
    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% = 1 
    60 - 79% = 0 
    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: 13.50, total records: 817 
    Average version length: 42.94, total versions: 709, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 58.00, compression ratio: 4.30 
    Pointer pages: 1, data page slots: 24 
    Data pages: 21, average fill: 42% 
    Primary pages: 20, secondary pages: 1, swept pages: 2 
    Empty pages: 2, full pages: 4 
    Fill distribution: 
     0 - 19% = 8 
    20 - 39% = 3 
    40 - 59% = 2 
    60 - 79% = 4 
    80 - 99% = 4 
 
    Index MONEY_TURNOVER_LOG_AGENT_OPTYPE (0) 
    Root page: 89451, depth: 2, leaf buckets: 1, nodes: 817 
    Average node length: 4.75, total dup: 720, max dup: 83 
    Average key length: 3.24, compression ratio: 5.86 
    Average prefix length: 17.87, average data length: 1.13 
    Clustering factor: 467, ratio: 0.57 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 0 
        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.50, total records: 72 
    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% = 0 
    20 - 39% = 1 
    40 - 59% = 0 
    60 - 79% = 1 
    80 - 99% = 0 
 
    Index PK_MON_CACHE_MEMORY (0) 
    Root page: 1504238, depth: 1, leaf buckets: 1, nodes: 72 
    Average node length: 11.69, total dup: 0, max dup: 0 
    Average key length: 10.68, compression ratio: 0.84 
    Average prefix length: 1.31, average data length: 7.69 
    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.95, total records: 830007 
    Average version length: 37.90, total versions: 17917, max versions: 2 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 54.00, compression ratio: 1.46 
    Pointer pages: 6, data page slots: 8936 
    Data pages: 8936, average fill: 63% 
    Primary pages: 8933, secondary pages: 3, swept pages: 4204 
    Empty pages: 19, full pages: 4442 
    Fill distribution: 
     0 - 19% = 47 
    20 - 39% = 75 
    40 - 59% = 1161 
    60 - 79% = 7631 
    80 - 99% = 22 
 
    Index PDISTR_AGENT_ID (2) 
    Root page: 1509330, depth: 2, leaf buckets: 902, nodes: 821778 
    Average node length: 4.88, total dup: 821729, max dup: 163231 
    Average key length: 2.01, compression ratio: 4.48 
    Average prefix length: 8.99, average data length: 0.01 
    Clustering factor: 92409, ratio: 0.11 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 150 
        40 - 59% = 477 
        60 - 79% = 194 
        80 - 99% = 81 
 
    Index PDISTR_SNDOP_RCVOP_SNDID_ASC (0) 
    Root page: 1508635, depth: 3, leaf buckets: 1017, nodes: 821778 
    Average node length: 5.89, total dup: 731691, max dup: 42 
    Average key length: 3.02, compression ratio: 7.29 
    Average prefix length: 21.09, average data length: 0.91 
    Clustering factor: 163529, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 38 
        40 - 59% = 669 
        60 - 79% = 74 
        80 - 99% = 236 
 
    Index PDISTR_SNDOP_RCVOP_SNDID_DESC (1) 
    Root page: 1509209, depth: 3, leaf buckets: 1047, nodes: 821778 
    Average node length: 5.89, total dup: 731691, max dup: 42 
    Average key length: 3.02, compression ratio: 7.29 
    Average prefix length: 21.09, average data length: 0.91 
    Clustering factor: 165403, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 91 
        40 - 59% = 663 
        60 - 79% = 69 
        80 - 99% = 224 
 
    Index PDISTR_WORKER_SND_ID (3) 
    Root page: 1510200, depth: 3, leaf buckets: 1163, nodes: 821778 
    Average node length: 5.97, total dup: 731691, max dup: 42 
    Average key length: 3.10, compression ratio: 5.48 
    Average prefix length: 16.01, average data length: 0.99 
    Clustering factor: 157489, ratio: 0.19 
    Fill distribution: 
         0 - 19% = 6 
        20 - 39% = 238 
        40 - 59% = 615 
        60 - 79% = 222 
        80 - 99% = 82 
 
PERF_AGG (158) 
    Primary pointer page: 540, Index root page: 541 
    Total formats: 1, used formats: 1 
    Average record length: 62.95, total records: 5496 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 3.05, total fragments: 22, max fragments: 1 
    Average unpacked length: 379.00, compression ratio: 6.02 
    Pointer pages: 1, data page slots: 96 
    Data pages: 94, average fill: 58% 
    Primary pages: 83, secondary pages: 11, swept pages: 60 
    Empty pages: 10, full pages: 61 
    Fill distribution: 
     0 - 19% = 18 
    20 - 39% = 2 
    40 - 59% = 2 
    60 - 79% = 72 
    80 - 99% = 0 
 
    Index PERF_AGG_UNQ (1) 
    Root page: 1504260, depth: 2, leaf buckets: 6, nodes: 5496 
    Average node length: 5.50, total dup: 0, max dup: 0 
    Average key length: 3.58, compression ratio: 10.09 
    Average prefix length: 34.56, average data length: 1.54 
    Clustering factor: 5232, 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: 5496 
    Average node length: 11.13, 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: 157, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 2 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 7 
 
PERF_ESTIMATED (280) 
    Primary pointer page: 399, Index root page: 434 
    Total formats: 1, used formats: 1 
    Average record length: 39.05, total records: 77598 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 48.00, compression ratio: 1.23 
    Pointer pages: 1, data page slots: 808 
    Data pages: 808, average fill: 66% 
    Primary pages: 808, secondary pages: 0, swept pages: 0 
    Empty pages: 1, full pages: 806 
    Fill distribution: 
     0 - 19% = 2 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 806 
    80 - 99% = 0 
 
    Index PK_PERF_ESTIMATED (0) 
    Root page: 34627, depth: 2, leaf buckets: 99, nodes: 77598 
    Average node length: 10.16, total dup: 0, max dup: 0 
    Average key length: 8.17, compression ratio: 1.10 
    Average prefix length: 3.82, average data length: 5.18 
    Clustering factor: 2699, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 1 
        80 - 99% = 97 
 
PERF_ISQL_STAT (156) 
    Primary pointer page: 536, Index root page: 537 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index PERF_ISQL_STAT_TRN (0) 
    Root page: 1504261, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
PERF_LOG (159) 
    Primary pointer page: 542, Index root page: 543 
    Total formats: 1, used formats: 1 
    Average record length: 111.17, total records: 71 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1691.00, compression ratio: 15.21 
    Pointer pages: 1, data page slots: 2 
    Data pages: 2, average fill: 56% 
    Primary pages: 2, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 1 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 1 
    40 - 59% = 0 
    60 - 79% = 1 
    80 - 99% = 0 
 
PERF_SPLIT_0 (281) 
    Primary pointer page: 601, Index root page: 602 
    Total formats: 1, used formats: 1 
    Average record length: 149.30, total records: 142943 
    Average version length: 149.35, total versions: 1577, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.36 
    Pointer pages: 7, data page slots: 4704 
    Data pages: 3592, average fill: 82% 
    Primary pages: 3590, secondary pages: 2, swept pages: 17 
    Empty pages: 74, full pages: 3497 
    Fill distribution: 
     0 - 19% = 78 
    20 - 39% = 10 
    40 - 59% = 4 
    60 - 79% = 2 
    80 - 99% = 3498 
 
PERF_SPLIT_1 (282) 
    Primary pointer page: 603, Index root page: 604 
    Total formats: 1, used formats: 1 
    Average record length: 138.06, total records: 161971 
    Average version length: 154.55, total versions: 14823, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 12.28 
    Pointer pages: 6, data page slots: 4728 
    Data pages: 4064, average fill: 83% 
    Primary pages: 4062, secondary pages: 2, swept pages: 24 
    Empty pages: 72, full pages: 3972 
    Fill distribution: 
     0 - 19% = 75 
    20 - 39% = 9 
    40 - 59% = 3 
    60 - 79% = 5 
    80 - 99% = 3972 
 
PERF_SPLIT_2 (283) 
    Primary pointer page: 605, Index root page: 606 
    Total formats: 1, used formats: 1 
    Average record length: 145.21, total records: 145771 
    Average version length: 151.74, total versions: 5469, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.68 
    Pointer pages: 6, data page slots: 4320 
    Data pages: 3624, average fill: 83% 
    Primary pages: 3622, secondary pages: 2, swept pages: 22 
    Empty pages: 45, full pages: 3554 
    Fill distribution: 
     0 - 19% = 47 
    20 - 39% = 9 
    40 - 59% = 7 
    60 - 79% = 5 
    80 - 99% = 3556 
 
PERF_SPLIT_3 (284) 
    Primary pointer page: 607, Index root page: 616 
    Total formats: 1, used formats: 1 
    Average record length: 144.39, total records: 156820 
    Average version length: 152.65, total versions: 7270, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.75 
    Pointer pages: 8, data page slots: 4448 
    Data pages: 3912, average fill: 83% 
    Primary pages: 3910, secondary pages: 2, swept pages: 19 
    Empty pages: 54, full pages: 3844 
    Fill distribution: 
     0 - 19% = 56 
    20 - 39% = 5 
    40 - 59% = 5 
    60 - 79% = 1 
    80 - 99% = 3845 
 
PERF_SPLIT_4 (285) 
    Primary pointer page: 617, Index root page: 618 
    Total formats: 1, used formats: 1 
    Average record length: 148.32, total records: 147108 
    Average version length: 149.69, total versions: 2443, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.43 
    Pointer pages: 6, data page slots: 4872 
    Data pages: 3688, average fill: 82% 
    Primary pages: 3686, secondary pages: 2, swept pages: 17 
    Empty pages: 70, full pages: 3593 
    Fill distribution: 
     0 - 19% = 76 
    20 - 39% = 8 
    40 - 59% = 3 
    60 - 79% = 9 
    80 - 99% = 3592 
 
PERF_SPLIT_5 (286) 
    Primary pointer page: 619, Index root page: 620 
    Total formats: 1, used formats: 1 
    Average record length: 146.25, total records: 149870 
    Average version length: 152.38, total versions: 4864, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.60 
    Pointer pages: 7, data page slots: 4016 
    Data pages: 3728, average fill: 83% 
    Primary pages: 3726, secondary pages: 2, swept pages: 28 
    Empty pages: 42, full pages: 3669 
    Fill distribution: 
     0 - 19% = 49 
    20 - 39% = 2 
    40 - 59% = 2 
    60 - 79% = 8 
    80 - 99% = 3667 
 
PERF_SPLIT_6 (287) 
    Primary pointer page: 621, Index root page: 622 
    Total formats: 1, used formats: 1 
    Average record length: 144.04, total records: 163072 
    Average version length: 154.30, total versions: 7780, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.77 
    Pointer pages: 5, data page slots: 5552 
    Data pages: 4112, average fill: 82% 
    Primary pages: 4110, secondary pages: 2, swept pages: 32 
    Empty pages: 98, full pages: 3980 
    Fill distribution: 
     0 - 19% = 105 
    20 - 39% = 5 
    40 - 59% = 14 
    60 - 79% = 7 
    80 - 99% = 3981 
 
PERF_SPLIT_7 (288) 
    Primary pointer page: 626, Index root page: 627 
    Total formats: 1, used formats: 1 
    Average record length: 146.05, total records: 148323 
    Average version length: 152.81, total versions: 5339, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.61 
    Pointer pages: 6, data page slots: 4896 
    Data pages: 3744, average fill: 82% 
    Primary pages: 3743, secondary pages: 1, swept pages: 25 
    Empty pages: 85, full pages: 3633 
    Fill distribution: 
     0 - 19% = 88 
    20 - 39% = 11 
    40 - 59% = 8 
    60 - 79% = 5 
    80 - 99% = 3632 
 
PERF_SPLIT_8 (289) 
    Primary pointer page: 628, Index root page: 629 
    Total formats: 1, used formats: 1 
    Average record length: 142.17, total records: 167261 
    Average version length: 153.13, total versions: 10627, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.93 
    Pointer pages: 6, data page slots: 4624 
    Data pages: 4160, average fill: 84% 
    Primary pages: 4158, secondary pages: 2, swept pages: 33 
    Empty pages: 41, full pages: 4106 
    Fill distribution: 
     0 - 19% = 44 
    20 - 39% = 4 
    40 - 59% = 2 
    60 - 79% = 4 
    80 - 99% = 4106 
 
PERF_SPLIT_9 (290) 
    Primary pointer page: 630, Index root page: 631 
    Total formats: 1, used formats: 1 
    Average record length: 148.10, total records: 158279 
    Average version length: 152.66, total versions: 3391, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.45 
    Pointer pages: 6, data page slots: 4648 
    Data pages: 3952, average fill: 83% 
    Primary pages: 3950, secondary pages: 2, swept pages: 34 
    Empty pages: 52, full pages: 3880 
    Fill distribution: 
     0 - 19% = 54 
    20 - 39% = 11 
    40 - 59% = 4 
    60 - 79% = 3 
    80 - 99% = 3880 
 
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: 2041348 
    Average version length: 52.86, total versions: 12012, 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: 25496 
    Data pages: 25480, average fill: 69% 
    Primary pages: 25465, secondary pages: 15, swept pages: 13389 
    Empty pages: 199, full pages: 20415 
    Fill distribution: 
     0 - 19% = 415 
    20 - 39% = 391 
    40 - 59% = 1298 
    60 - 79% = 23284 
    80 - 99% = 92 
 
    Index PSTORNED_RCV_ID (1) 
    Root page: 1506208, depth: 3, leaf buckets: 2543, nodes: 2041348 
    Average node length: 5.45, total dup: 1903272, max dup: 1416 
    Average key length: 2.49, compression ratio: 3.61 
    Average prefix length: 8.57, average data length: 0.43 
    Clustering factor: 179052, ratio: 0.09 
    Fill distribution: 
         0 - 19% = 7 
        20 - 39% = 362 
        40 - 59% = 1590 
        60 - 79% = 287 
        80 - 99% = 297 
 
    Index PSTORNED_SND_ID (0) 
    Root page: 1504841, depth: 3, leaf buckets: 2749, nodes: 2041348 
    Average node length: 5.70, total dup: 1831510, max dup: 70 
    Average key length: 2.74, compression ratio: 3.28 
    Average prefix length: 8.36, average data length: 0.64 
    Clustering factor: 367051, ratio: 0.18 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 7 
        40 - 59% = 2560 
        60 - 79% = 162 
        80 - 99% = 20 
 
    Index PSTORNED_WORKER_ID (2) 
    Root page: 1508018, depth: 3, leaf buckets: 2070, nodes: 2041348 
    Average node length: 4.96, total dup: 2041248, max dup: 27664 
    Average key length: 2.00, compression ratio: 1.20 
    Average prefix length: 2.40, average data length: 0.00 
    Clustering factor: 176883, ratio: 0.09 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 193 
        40 - 59% = 1060 
        60 - 79% = 406 
        80 - 99% = 411 
 
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: 47.62, total records: 121157 
    Average version length: 69.18, total versions: 43478, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 2.65 
    Pointer pages: 3, data page slots: 3856 
    Data pages: 2912, average fill: 50% 
    Primary pages: 2912, secondary pages: 0, swept pages: 509 
    Empty pages: 465, full pages: 963 
    Fill distribution: 
     0 - 19% = 701 
    20 - 39% = 280 
    40 - 59% = 535 
    60 - 79% = 899 
    80 - 99% = 497 
 
    Index XQD_1000_1200_WA_SO_RO_WKR_SND (0) 
    Root page: 106400, depth: 3, leaf buckets: 220, nodes: 121157 
    Average node length: 6.49, total dup: 105350, max dup: 14 
    Average key length: 4.01, compression ratio: 10.48 
    Average prefix length: 40.12, average data length: 1.88 
    Clustering factor: 21100, ratio: 0.17 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 86 
        40 - 59% = 108 
        60 - 79% = 23 
        80 - 99% = 2 
 
XQD_1000_3300 (178) 
    Primary pointer page: 581, Index root page: 582 
    Total formats: 1, used formats: 1 
    Average record length: 67.30, total records: 6999796 
    Average version length: 68.80, total versions: 193199, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.87 
    Pointer pages: 67, data page slots: 108784 
    Data pages: 108784, average fill: 69% 
    Primary pages: 108783, secondary pages: 1, swept pages: 58190 
    Empty pages: 13, full pages: 41599 
    Fill distribution: 
     0 - 19% = 132 
    20 - 39% = 898 
    40 - 59% = 11658 
    60 - 79% = 95740 
    80 - 99% = 356 
 
    Index XQD_1000_3300_WA_SO_RO_WKR_SND (0) 
    Root page: 1480476, depth: 3, leaf buckets: 10785, nodes: 6999796 
    Average node length: 6.51, total dup: 6053873, max dup: 29 
    Average key length: 3.52, compression ratio: 11.92 
    Average prefix length: 40.61, average data length: 1.39 
    Clustering factor: 1631721, ratio: 0.23 
    Fill distribution: 
         0 - 19% = 4 
        20 - 39% = 1871 
        40 - 59% = 5874 
        60 - 79% = 2631 
        80 - 99% = 405 
 
    Index XQD_1000_3300_WKR_DOC_ASC (1) 
    Root page: 1486090, depth: 3, leaf buckets: 8800, nodes: 6999796 
    Average node length: 5.40, total dup: 6718973, max dup: 130 
    Average key length: 2.41, compression ratio: 7.05 
    Average prefix length: 16.63, average data length: 0.37 
    Clustering factor: 1443030, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 10 
        20 - 39% = 1412 
        40 - 59% = 5211 
        60 - 79% = 1323 
        80 - 99% = 844 
 
    Index XQD_1000_3300_WKR_DOC_DEC (2) 
    Root page: 1490630, depth: 3, leaf buckets: 8826, nodes: 6999796 
    Average node length: 5.40, total dup: 6718973, max dup: 130 
    Average key length: 2.41, compression ratio: 7.05 
    Average prefix length: 16.63, average data length: 0.37 
    Clustering factor: 1445338, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 9 
        20 - 39% = 1455 
        40 - 59% = 5110 
        60 - 79% = 1398 
        80 - 99% = 854 
 
XQD_1200_2000 (177) 
    Primary pointer page: 579, Index root page: 580 
    Total formats: 1, used formats: 1 
    Average record length: 68.15, total records: 12103187 
    Average version length: 68.70, total versions: 160366, 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: 109, data page slots: 177744 
    Data pages: 177744, average fill: 72% 
    Primary pages: 177743, secondary pages: 1, swept pages: 104145 
    Empty pages: 8, full pages: 127476 
    Fill distribution: 
     0 - 19% = 45 
    20 - 39% = 623 
    40 - 59% = 7087 
    60 - 79% = 169218 
    80 - 99% = 771 
 
    Index XQD_1200_2000_WA_SO_RO_WKR_SND (0) 
    Root page: 1495050, depth: 3, leaf buckets: 18450, nodes: 12102825 
    Average node length: 6.63, total dup: 10548227, max dup: 50 
    Average key length: 3.43, compression ratio: 12.25 
    Average prefix length: 40.70, average data length: 1.30 
    Clustering factor: 2458207, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 13 
        20 - 39% = 2333 
        40 - 59% = 10579 
        60 - 79% = 4658 
        80 - 99% = 867 
 
XQD_2000_3300 (179) 
    Primary pointer page: 583, Index root page: 584 
    Total formats: 1, used formats: 1 
    Average record length: 55.29, total records: 1234418 
    Average version length: 69.09, total versions: 229445, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 2.28 
    Pointer pages: 28, data page slots: 43952 
    Data pages: 28176, average fill: 48% 
    Primary pages: 28024, secondary pages: 152, swept pages: 13673 
    Empty pages: 5365, full pages: 12413 
    Fill distribution: 
     0 - 19% = 7928 
    20 - 39% = 3088 
    40 - 59% = 2901 
    60 - 79% = 11341 
    80 - 99% = 2918 
 
    Index XQD_2000_3300_WA_SO_RO_WKR_SND (0) 
    Root page: 1479735, depth: 3, leaf buckets: 1838, nodes: 1179686 
    Average node length: 5.53, total dup: 1131398, max dup: 49 
    Average key length: 2.59, compression ratio: 16.24 
    Average prefix length: 41.45, average data length: 0.55 
    Clustering factor: 82440, ratio: 0.07 
    Fill distribution: 
         0 - 19% = 7 
        20 - 39% = 772 
        40 - 59% = 812 
        60 - 79% = 232 
        80 - 99% = 15 
 
XQD_2100_3300 (180) 
    Primary pointer page: 585, Index root page: 586 
    Total formats: 1, used formats: 1 
    Average record length: 48.79, total records: 896102 
    Average version length: 69.03, total versions: 100089, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 2.58 
    Pointer pages: 20, data page slots: 31888 
    Data pages: 27272, average fill: 32% 
    Primary pages: 27272, secondary pages: 0, swept pages: 10506 
    Empty pages: 5136, full pages: 3069 
    Fill distribution: 
     0 - 19% = 9651 
    20 - 39% = 6135 
    40 - 59% = 7511 
    60 - 79% = 3933 
    80 - 99% = 42 
 
    Index XQD_2100_3300_WA_SO_RO_WKR_SND (0) 
    Root page: 1479229, depth: 3, leaf buckets: 1161, nodes: 694218 
    Average node length: 5.90, total dup: 642211, max dup: 65 
    Average key length: 2.98, compression ratio: 14.12 
    Average prefix length: 41.10, average data length: 0.90 
    Clustering factor: 95948, ratio: 0.14 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 504 
        40 - 59% = 500 
        60 - 79% = 145 
        80 - 99% = 10 
 
XQD_3300_3400 (181) 
    Primary pointer page: 587, Index root page: 588 
    Total formats: 1, used formats: 1 
    Average record length: 68.03, total records: 8752155 
    Average version length: 68.95, total versions: 126060, 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: 88, data page slots: 143432 
    Data pages: 143376, average fill: 65% 
    Primary pages: 143359, secondary pages: 17, swept pages: 88444 
    Empty pages: 457, full pages: 53654 
    Fill distribution: 
     0 - 19% = 1705 
    20 - 39% = 8019 
    40 - 59% = 24202 
    60 - 79% = 109089 
    80 - 99% = 361 
 
    Index XQD_3300_3400_WA_SO_RO_WKR_SND (0) 
    Root page: 1472612, depth: 3, leaf buckets: 13382, nodes: 8751283 
    Average node length: 6.68, total dup: 7257071, max dup: 14 
    Average key length: 3.67, compression ratio: 11.44 
    Average prefix length: 40.50, average data length: 1.50 
    Clustering factor: 1973716, ratio: 0.23 
    Fill distribution: 
         0 - 19% = 7 
        20 - 39% = 1933 
        40 - 59% = 6931 
        60 - 79% = 4033 
        80 - 99% = 478 
 
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: 21103338 
    Average version length: 83.02, total versions: 6330, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.53 
    Pointer pages: 196, data page slots: 319168 
    Data pages: 319168, average fill: 81% 
    Primary pages: 319161, secondary pages: 7, swept pages: 13634 
    Empty pages: 47, full pages: 318136 
    Fill distribution: 
     0 - 19% = 86 
    20 - 39% = 57 
    40 - 59% = 136 
    60 - 79% = 48698 
    80 - 99% = 270191 
 
    Index XQS_1000_1200_DOC_ID (1) 
    Root page: 1426738, depth: 3, leaf buckets: 19485, nodes: 21103338 
    Average node length: 5.72, total dup: 20623418, max dup: 148 
    Average key length: 2.16, compression ratio: 4.16 
    Average prefix length: 8.86, average data length: 0.14 
    Clustering factor: 3278211, ratio: 0.16 
    Fill distribution: 
         0 - 19% = 4 
        20 - 39% = 2 
        40 - 59% = 8408 
        60 - 79% = 534 
        80 - 99% = 10537 
 
    Index XQS_1000_1200_RCV_ID (3) 
    Root page: 1457002, depth: 3, leaf buckets: 17139, nodes: 21103338 
    Average node length: 6.31, total dup: 18545337, max dup: 49 
    Average key length: 2.75, compression ratio: 3.27 
    Average prefix length: 8.37, average data length: 0.63 
    Clustering factor: 917718, ratio: 0.04 
    Fill distribution: 
         0 - 19% = 3 
        20 - 39% = 3 
        40 - 59% = 769 
        60 - 79% = 294 
        80 - 99% = 16070 
 
    Index XQS_1000_1200_SND_ID (2) 
    Root page: 1441095, depth: 3, leaf buckets: 21304, nodes: 21103338 
    Average node length: 6.35, total dup: 18464637, max dup: 29 
    Average key length: 2.79, compression ratio: 3.23 
    Average prefix length: 8.34, average data length: 0.66 
    Clustering factor: 3571444, ratio: 0.17 
    Fill distribution: 
         0 - 19% = 5 
        20 - 39% = 0 
        40 - 59% = 8785 
        60 - 79% = 572 
        80 - 99% = 11942 
 
    Index XQS_1000_1200_WORKER_ID (0) 
    Root page: 1413370, depth: 3, leaf buckets: 16048, nodes: 21103338 
    Average node length: 5.56, total dup: 21103238, max dup: 230971 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.42, average data length: 0.00 
    Clustering factor: 946308, ratio: 0.04 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 15 
        40 - 59% = 2857 
        60 - 79% = 351 
        80 - 99% = 12823 
 
XQS_1000_3300 (184) 
    Primary pointer page: 593, Index root page: 594 
    Total formats: 1, used formats: 1 
    Average record length: 81.74, total records: 9156883 
    Average version length: 82.65, total versions: 82623, 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: 105, data page slots: 170168 
    Data pages: 170088, average fill: 66% 
    Primary pages: 170057, secondary pages: 31, swept pages: 115942 
    Empty pages: 862, full pages: 79961 
    Fill distribution: 
     0 - 19% = 2795 
    20 - 39% = 11163 
    40 - 59% = 29126 
    60 - 79% = 113383 
    80 - 99% = 13621 
 
    Index XQS_1000_3300_DOC_ID (1) 
    Root page: 1367524, depth: 3, leaf buckets: 11324, nodes: 9156883 
    Average node length: 5.36, total dup: 8853403, max dup: 169 
    Average key length: 2.24, compression ratio: 4.01 
    Average prefix length: 8.79, average data length: 0.21 
    Clustering factor: 2069985, ratio: 0.23 
    Fill distribution: 
         0 - 19% = 3 
        20 - 39% = 178 
        40 - 59% = 9454 
        60 - 79% = 1670 
        80 - 99% = 19 
 
    Index XQS_1000_3300_RCV_ID (3) 
    Root page: 1379283, depth: 3, leaf buckets: 12962, nodes: 9156883 
    Average node length: 6.22, total dup: 7589157, max dup: 14 
    Average key length: 3.10, compression ratio: 2.90 
    Average prefix length: 8.07, average data length: 0.93 
    Clustering factor: 1448121, ratio: 0.16 
    Fill distribution: 
         0 - 19% = 102 
        20 - 39% = 3705 
        40 - 59% = 4417 
        60 - 79% = 2721 
        80 - 99% = 2017 
 
    Index XQS_1000_3300_SND_ID (2) 
    Root page: 1373081, depth: 3, leaf buckets: 12630, nodes: 9156883 
    Average node length: 5.98, total dup: 7931222, max dup: 29 
    Average key length: 2.86, compression ratio: 3.15 
    Average prefix length: 8.27, average data length: 0.73 
    Clustering factor: 2244715, ratio: 0.25 
    Fill distribution: 
         0 - 19% = 3 
        20 - 39% = 189 
        40 - 59% = 10519 
        60 - 79% = 1897 
        80 - 99% = 22 
 
    Index XQS_1000_3300_WORKER_ID (0) 
    Root page: 1362789, depth: 3, leaf buckets: 9629, nodes: 9156883 
    Average node length: 5.12, total dup: 9156783, max dup: 149461 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.41, average data length: 0.00 
    Clustering factor: 1471629, ratio: 0.16 
    Fill distribution: 
         0 - 19% = 48 
        20 - 39% = 1286 
        40 - 59% = 4679 
        60 - 79% = 1675 
        80 - 99% = 1941 
 
XQS_1200_2000 (183) 
    Primary pointer page: 591, Index root page: 592 
    Total formats: 1, used formats: 1 
    Average record length: 81.81, total records: 10803285 
    Average version length: 82.53, total versions: 70501, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.54 
    Pointer pages: 118, data page slots: 191456 
    Data pages: 189912, average fill: 70% 
    Primary pages: 189784, secondary pages: 128, swept pages: 84336 
    Empty pages: 3714, full pages: 132413 
    Fill distribution: 
     0 - 19% = 6561 
    20 - 39% = 9412 
    40 - 59% = 21276 
    60 - 79% = 97671 
    80 - 99% = 54992 
 
    Index XQS_1200_2000_DOC_ID (1) 
    Root page: 1392123, depth: 3, leaf buckets: 13118, nodes: 10803285 
    Average node length: 5.30, total dup: 10694558, max dup: 635 
    Average key length: 2.08, compression ratio: 4.32 
    Average prefix length: 8.93, average data length: 0.07 
    Clustering factor: 2255974, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 315 
        40 - 59% = 10198 
        60 - 79% = 2536 
        80 - 99% = 67 
 
    Index XQS_1200_2000_RCV_ID (3) 
    Root page: 1406132, depth: 3, leaf buckets: 10100, nodes: 10803285 
    Average node length: 5.49, total dup: 10330193, max dup: 49 
    Average key length: 2.28, compression ratio: 3.95 
    Average prefix length: 8.77, average data length: 0.23 
    Clustering factor: 688890, ratio: 0.06 
    Fill distribution: 
         0 - 19% = 174 
        20 - 39% = 914 
        40 - 59% = 2473 
        60 - 79% = 1827 
        80 - 99% = 4712 
 
    Index XQS_1200_2000_SND_ID (2) 
    Root page: 1398660, depth: 3, leaf buckets: 15003, nodes: 10803285 
    Average node length: 6.03, total dup: 9414306, max dup: 68 
    Average key length: 2.81, compression ratio: 3.20 
    Average prefix length: 8.31, average data length: 0.69 
    Clustering factor: 2272117, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 379 
        40 - 59% = 11734 
        60 - 79% = 2802 
        80 - 99% = 86 
 
    Index XQS_1200_2000_WORKER_ID (0) 
    Root page: 1386233, depth: 3, leaf buckets: 10430, nodes: 10803285 
    Average node length: 5.22, total dup: 10803185, max dup: 182310 
    Average key length: 2.00, compression ratio: 1.20 
    Average prefix length: 2.41, average data length: 0.00 
    Clustering factor: 678468, ratio: 0.06 
    Fill distribution: 
         0 - 19% = 109 
        20 - 39% = 924 
        40 - 59% = 4616 
        60 - 79% = 1479 
        80 - 99% = 3302 
 
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: 82.23, total records: 9252374 
    Average version length: 82.88, total versions: 63960, 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: 107, data page slots: 174016 
    Data pages: 173944, average fill: 66% 
    Primary pages: 173904, secondary pages: 40, swept pages: 122584 
    Empty pages: 1022, full pages: 79386 
    Fill distribution: 
     0 - 19% = 3029 
    20 - 39% = 12376 
    40 - 59% = 31962 
    60 - 79% = 113613 
    80 - 99% = 12964 
 
    Index XQS_2100_3300_DOC_ID (1) 
    Root page: 1344708, depth: 3, leaf buckets: 11363, nodes: 9252374 
    Average node length: 5.17, total dup: 9224212, max dup: 2346 
    Average key length: 2.03, compression ratio: 4.43 
    Average prefix length: 8.97, average data length: 0.03 
    Clustering factor: 1868868, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 25 
        20 - 39% = 1630 
        40 - 59% = 7552 
        60 - 79% = 1620 
        80 - 99% = 536 
 
    Index XQS_2100_3300_RCV_ID (3) 
    Root page: 1355739, depth: 3, leaf buckets: 13128, nodes: 9252374 
    Average node length: 6.24, total dup: 7668298, max dup: 14 
    Average key length: 3.11, compression ratio: 2.90 
    Average prefix length: 8.07, average data length: 0.93 
    Clustering factor: 1417910, ratio: 0.15 
    Fill distribution: 
         0 - 19% = 183 
        20 - 39% = 3792 
        40 - 59% = 4293 
        60 - 79% = 2698 
        80 - 99% = 2162 
 
    Index XQS_2100_3300_SND_ID (2) 
    Root page: 1350071, depth: 3, leaf buckets: 11943, nodes: 9252374 
    Average node length: 5.43, total dup: 8833439, max dup: 99 
    Average key length: 2.29, compression ratio: 3.93 
    Average prefix length: 8.75, average data length: 0.25 
    Clustering factor: 1996569, ratio: 0.22 
    Fill distribution: 
         0 - 19% = 37 
        20 - 39% = 1528 
        40 - 59% = 8276 
        60 - 79% = 1599 
        80 - 99% = 503 
 
    Index XQS_2100_3300_WORKER_ID (0) 
    Root page: 987843, depth: 3, leaf buckets: 9804, nodes: 9252374 
    Average node length: 5.14, total dup: 9252274, max dup: 153796 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.41, average data length: 0.00 
    Clustering factor: 1493259, ratio: 0.16 
    Fill distribution: 
         0 - 19% = 42 
        20 - 39% = 1325 
        40 - 59% = 4836 
        60 - 79% = 1653 
        80 - 99% = 1948 
 
XQS_3300_3400 (187) 
    Primary pointer page: 599, Index root page: 600 
    Total formats: 1, used formats: 1 
    Average record length: 67.96, total records: 565144 
    Average version length: 68.75, total versions: 1953, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.85 
    Pointer pages: 5, data page slots: 8008 
    Data pages: 8008, average fill: 74% 
    Primary pages: 8008, secondary pages: 0, swept pages: 4386 
    Empty pages: 1, full pages: 6421 
    Fill distribution: 
     0 - 19% = 3 
    20 - 39% = 15 
    40 - 59% = 243 
    60 - 79% = 7732 
    80 - 99% = 15 
 
    Index XQS_3300_3400_DOC_ID (1) 
    Root page: 43019, depth: 3, leaf buckets: 730, nodes: 565144 
    Average node length: 5.95, total dup: 480947, max dup: 82 
    Average key length: 3.10, compression ratio: 2.91 
    Average prefix length: 8.05, average data length: 0.95 
    Clustering factor: 99556, ratio: 0.18 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 35 
        40 - 59% = 520 
        60 - 79% = 86 
        80 - 99% = 89 
 
    Index XQS_3300_3400_SND_ID (2) 
    Root page: 34341, depth: 3, leaf buckets: 749, nodes: 565144 
    Average node length: 6.15, total dup: 463425, max dup: 21 
    Average key length: 3.30, compression ratio: 2.73 
    Average prefix length: 7.88, average data length: 1.12 
    Clustering factor: 99601, ratio: 0.18 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 41 
        40 - 59% = 529 
        60 - 79% = 77 
        80 - 99% = 102 
 
    Index XQS_3300_3400_WORKER_ID (0) 
    Root page: 377587, depth: 2, leaf buckets: 573, nodes: 565144 
    Average node length: 4.86, total dup: 565044, max dup: 9575 
    Average key length: 2.00, compression ratio: 1.20 
    Average prefix length: 2.41, average data length: 0.00 
    Clustering factor: 88649, ratio: 0.16 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 44 
        40 - 59% = 346 
        60 - 79% = 77 
        80 - 99% = 106 
 
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 Sun Mar 24 04:11:14 2024

Record versions statistics, table

TABLE_NAME TOTAL_RECS TOTAL_VERS MAX_VERSIONS VERS_TO_RECS_PRC MAXV_TO_VERS_PRC
DOC_DATA 7649845 22608 1 0.0000 0.0000
DOC_LIST 2192242 12770 2 0.0000 0.0000
FB_ERRORS 2182 757 1 0.0000 0.0000
INVNT_SALDO 400 631 7 100.0000 0.0000
INVNT_TURNOVER_LOG 70463 60981 1 0.0000 0.0000
MONEY_SALDO 49 83 5 100.0000 0.0000
MONEY_TURNOVER_LOG 817 709 1 0.0000 0.0000
PDISTR 830007 17917 2 0.0000 0.0000
PERF_SPLIT_0 142943 1577 1 0.0000 0.0000
PERF_SPLIT_1 161971 14823 1 0.0000 0.0000
PERF_SPLIT_2 145771 5469 1 0.0000 0.0000
PERF_SPLIT_3 156820 7270 1 0.0000 0.0000
PERF_SPLIT_4 147108 2443 1 0.0000 0.0000
PERF_SPLIT_5 149870 4864 1 0.0000 0.0000
PERF_SPLIT_6 163072 7780 1 0.0000 0.0000
PERF_SPLIT_7 148323 5339 1 0.0000 0.0000
PERF_SPLIT_8 167261 10627 1 0.0000 0.0000
PERF_SPLIT_9 158279 3391 1 0.0000 0.0000
PSTORNED 2041348 12012 1 0.0000 0.0000
SEMAPHORES 5 1 1 0.0000 100.0000
XQD_1000_1200 121157 43478 1 0.0000 0.0000
XQD_1000_3300 6999796 193199 1 0.0000 0.0000
XQD_1200_2000 12103187 160366 1 0.0000 0.0000
XQD_2000_3300 1234418 229445 1 0.0000 0.0000
XQD_2100_3300 896102 100089 1 0.0000 0.0000
XQD_3300_3400 8752155 126060 1 0.0000 0.0000
XQS_1000_1200 21103338 6330 1 0.0000 0.0000
XQS_1000_3300 9156883 82623 1 0.0000 0.0000
XQS_1200_2000 10803285 70501 1 0.0000 0.0000
XQS_2100_3300 9252374 63960 1 0.0000 0.0000
XQS_3300_3400 565144 1953 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'  

24.03.24 04:11:26. 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-03-24 04:11:29 No severe PSQL-related problems occured
24.03.24 04:11:30. End of report.