Generated by /opt/oltp-emul/oltp_isql_run_worker.sh, ISQL session No. 1 of total launched 100. 06.03.2024 13:08
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 15830860 kB
MemAvailable 30301832 kB
Buffers 0 kB
Cached 15932176 kB
SwapCached 2208 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-06 13:07:50
DTS_END                         2024-03-06 13:07:50.8320
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/44172
TRN_ID                          171878
ATT_ID                          490
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: 9141.89 21180 914189
customer order: creation 172.05 436 17205
customer order: refuse 15.18 350 1518
order to supplier: creation 44.51 1474 4451
order to supplier: removal 3.35 112085 335
invoice (draft): creation 45.83 3198 4583
invoice (draft): removal 49.94 799 4994
invoice accept: apply 41.20 19668 4120
invoice accept: cancel 45.09 860 4509
customer reserve: creation 4030.91 183 403091
customer reserve: removal 4406.52 68 440652
realization accept: apply 82.71 208 8271
realization accept: cancel 77.08 148 7708
payment from customer: creation 58.57 125 5857
payment from customer: removal 5.22 96 522
payment to supplier: creation 49.24 156 4924
payment to supplier: removal 3.28 57 328
service: total inventory turnovers 4.00 3585 400
service: total monetary turnovers 6.19 469 619
service: aggregate perf. data 0.98 14727 98
service: refresh index statistics 0.04 264905 4

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:02, from 06-03-2024 13:09:19 to 06-03-2024 13:09:21.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 2856
TEST_TIME 2 3387
TEST_TIME 3 4683
TEST_TIME 4 5010
TEST_TIME 5 4924
TEST_TIME 6 4971
TEST_TIME 7 5186
TEST_TIME 8 5166
TEST_TIME 9 4869
TEST_TIME 10 5340
TEST_TIME 11 5453
TEST_TIME 12 5514
TEST_TIME 13 6137
TEST_TIME 14 6522
TEST_TIME 15 6526
TEST_TIME 16 6710
TEST_TIME 17 6810
TEST_TIME 18 7180
TEST_TIME 19 7427
TEST_TIME 20 7749
TEST_TIME 21 7705
TEST_TIME 22 7658
TEST_TIME 23 8995
TEST_TIME 24 9429
TEST_TIME 25 9607
TEST_TIME 26 9854
TEST_TIME 27 10234
TEST_TIME 28 10362
TEST_TIME 29 10039
TEST_TIME 30 9764
TEST_TIME 31 10098
TEST_TIME 32 9996
TEST_TIME 33 9859
TEST_TIME 34 9696
TEST_TIME 35 9570
TEST_TIME 36 9548
TEST_TIME 37 9470
TEST_TIME 38 9475
TEST_TIME 39 9384
TEST_TIME 40 9324
TEST_TIME 41 9252
TEST_TIME 42 9215
TEST_TIME 43 9135
TEST_TIME 44 8978
TEST_TIME 45 8923
TEST_TIME 46 9047
TEST_TIME 47 9060
TEST_TIME 48 9021
TEST_TIME 49 9110
TEST_TIME 50 9127
TEST_TIME 51 9097
TEST_TIME 52 9128
TEST_TIME 53 9143
TEST_TIME 54 9186
TEST_TIME 55 9154
TEST_TIME 56 9420
TEST_TIME 57 9404
TEST_TIME 58 9431
TEST_TIME 59 9326
TEST_TIME 60 9207
TEST_TIME 61 9152
TEST_TIME 62 9209
TEST_TIME 63 9206
TEST_TIME 64 9136
TEST_TIME 65 9076
TEST_TIME 66 9023
TEST_TIME 67 9115
TEST_TIME 68 9121
TEST_TIME 69 9127
TEST_TIME 70 9200
TEST_TIME 71 9254
TEST_TIME 72 9222
TEST_TIME 73 9356
TEST_TIME 74 9318
TEST_TIME 75 9338
TEST_TIME 76 9383
TEST_TIME 77 9357
TEST_TIME 78 9249
TEST_TIME 79 9228
TEST_TIME 80 9180
TEST_TIME 81 9134
TEST_TIME 82 9066
TEST_TIME 83 9020
TEST_TIME 84 9028
TEST_TIME 85 9146
TEST_TIME 86 9152
TEST_TIME 87 9137
TEST_TIME 88 9225
TEST_TIME 89 9238
TEST_TIME 90 9223
TEST_TIME 91 9300
TEST_TIME 92 9306
TEST_TIME 93 9281
TEST_TIME 94 9334
TEST_TIME 95 9301
TEST_TIME 96 9210
TEST_TIME 97 9195
TEST_TIME 98 9128
TEST_TIME 99 9163
TEST_TIME 100 9150

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:03, from 06-03-2024 13:09:22 to 06-03-2024 13:09:25.

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 1280228 1280228 0 0.00 0 30354 7 0 0
doc_list_biud 1280226 1280226 0 0.00 0 27021 29 0 0
sp_add_invoice_to_stock 4211 4120 91 2.16 48 199768 19668 0 91
sp_cancel_adding_invoice 4509 4509 0 0.00 4 58070 861 0 0
sp_cancel_client_order 1518 1518 0 0.00 4 7356 351 0 0
sp_cancel_customer_reserve 440652 440652 0 0.00 0 23675 68 0 0
sp_cancel_pay_from_customer 522 522 0 0.00 2 10900 97 0 0
sp_cancel_pay_to_supplier 328 328 0 0.00 2 1470 58 0 0
sp_cancel_supplier_invoice 4997 4994 3 0.06 1 26042 799 0 3
sp_cancel_supplier_order 335 335 0 0.00 6 1060687 112086 0 0
sp_cancel_write_off 7708 7708 0 0.00 1 11498 148 0 0
sp_client_order 17205 17205 0 0.00 3 28172 437 0 0
sp_customer_reserve 403091 403091 0 0.00 0 45165 184 0 0
sp_fill_shopping_cart 26229 26229 0 0.00 1 13433 40 0 0
sp_fill_shopping_cart_clo_res 403081 403081 0 0.00 0 22131 16 0 0
sp_get_clo_for_invoice 4108 4108 0 0.00 0 20363 395 0 0
sp_kill_cost_storno 13067 13067 0 0.00 0 30343 79 0 0
sp_kill_qstorno_ret_qs2qd 894341 894341 0 0.00 0 26029 36 0 0
sp_kill_qty_storno 472095 472095 0 0.00 0 27020 77 0 0
sp_lock_selected_doc 17151 17151 0 0.00 0 8404 8 0 0
sp_make_cost_storno 23160 23160 0 0.00 0 19795 65 0 0
sp_multiply_rows_for_pdistr 23160 23160 0 0.00 0 8867 35 0 0
sp_multiply_rows_for_qdistr 17205 17205 0 0.00 0 17911 228 0 0
sp_pay_from_customer 5857 5857 0 0.00 3 13105 125 0 0
sp_pay_to_supplier 4924 4924 0 0.00 4 15744 156 0 0
sp_payment_common 10781 10781 0 0.00 1 8341 22 0 0
sp_qd_handle_on_cancel_clo 1518 1518 0 0.00 0 6113 310 0 0
sp_qd_handle_on_invoice_upd_sts 8617 8617 0 0.00 0 27019 320 0 0
sp_qd_handle_on_reserve_upd_sts 8271 8271 0 0.00 0 14332 56 0 0
sp_reserve_write_off 8271 8271 0 0.00 6 15285 208 0 0
sp_supplier_invoice 4583 4583 0 0.00 6 84851 3198 0 0
sp_supplier_order 4451 4451 0 0.00 5 31486 1475 0 0
srv_aggregate_perf_data 98 98 0 0.00 1669 155823 14727 0 0
srv_fill_mon_cache_memory 55 55 0 0.00 1097 96893 39977 0 0
srv_find_qd_qs_mism 870354 870354 0 0.00 0 16074 6 0 0
srv_make_invnt_saldo 400 400 0 0.00 37 110146 3585 0 0
srv_make_money_saldo 619 619 0 0.00 0 11230 470 0 0
srv_recalc_idx_stat 4 4 0 0.00 196033 421884 264906 0 0
t$perf-abend:sp_add_invoice_to_stock 91 91 0 0.00 0 0 0 0 0
t$perf-abend:sp_cancel_supplier_invoice 3 3 0 0.00 0 0 0 0 0
t$perf-norm:sp_add_invoice_to_stock 4120 4120 0 0.00 0 13263 187 0 0
t$perf-norm:sp_cancel_adding_invoice 340 340 0 0.00 0 5752 127 0 0
t$perf-norm:sp_cancel_client_order 1518 1518 0 0.00 0 2172 9 0 0
t$perf-norm:sp_cancel_customer_reserve 547 547 0 0.00 0 1043 11 0 0
t$perf-norm:sp_cancel_pay_from_customer 522 522 0 0.00 0 4097 24 0 0
t$perf-norm:sp_cancel_pay_to_supplier 328 328 0 0.00 0 4827 19 0 0
t$perf-norm:sp_cancel_supplier_invoice 359 359 0 0.00 0 3163 28 0 0
t$perf-norm:sp_cancel_supplier_order 335 335 0 0.00 0 27734 1965 0 0
t$perf-norm:sp_cancel_write_off 823 823 0 0.00 0 6243 17 0 0
t$perf-norm:sp_client_order 17205 17205 0 0.00 0 10020 17 0 0
t$perf-norm:sp_customer_reserve 891 891 0 0.00 0 2719 7 0 0
t$perf-norm:sp_pay_from_customer 5857 5857 0 0.00 0 6066 11 0 0
t$perf-norm:sp_pay_to_supplier 4924 4924 0 0.00 0 12560 12 0 0
t$perf-norm:sp_reserve_write_off 8271 8271 0 0.00 0 7324 16 0 0
t$perf-norm:sp_supplier_invoice 4583 4583 0 0.00 0 5224 17 0 0
t$perf-norm:sp_supplier_order 4451 4451 0 0.00 0 3642 14 0 0
t$perf-norm:srv_aggregate_perf_data 98 98 0 0.00 0 312 5 0 0
t$perf-norm:srv_fill_mon_cache_memory 55 55 0 0.00 0 269 9 0 0
t$perf-norm:srv_make_invnt_saldo 400 400 0 0.00 0 1877 20 0 0
t$perf-norm:srv_make_money_saldo 619 619 0 0.00 0 1395 6 0 0
t$perf-norm:srv_recalc_idx_stat 4 4 0 0.00 1 15 8 0 0
v_add_invoice_to_stock 8398 8216 182 2.16 0 6651 21 0 182
v_all_customers 32172 32172 0 0.00 0 50 1 0 0
v_all_suppliers 25992 25992 0 0.00 0 51 1 0 0
v_all_wares 34410 34410 0 0.00 0 29 1 0 0
v_cancel_adding_invoice 680 680 0 0.00 0 4936 16 0 0
v_cancel_client_order 3036 3036 0 0.00 0 5562 11 0 0
v_cancel_customer_prepayment 1044 1044 0 0.00 0 7272 16 0 0
v_cancel_customer_reserve 1094 1094 0 0.00 0 6593 24 0 0
v_cancel_payment_to_supplier 656 656 0 0.00 0 1436 6 0 0
v_cancel_supplier_invoice 724 718 6 0.82 0 7333 26 0 6
v_cancel_supplier_order 670 670 0 0.00 0 430 3 0 0
v_cancel_write_off 1646 1646 0 0.00 0 6813 25 0 0
v_max_id_clo_ord 4448 4448 0 0.00 0 594 1 0 0
v_max_id_clo_res 891 891 0 0.00 0 4241 11 0 0
v_max_id_ord_sup 4575 4575 0 0.00 0 3142 3 0 0
v_max_non_paid_invoice 951 951 0 0.00 0 106 2 0 0
v_max_non_paid_realizn 2706 2706 0 0.00 0 1258 3 0 0
v_min_id_clo_ord 4448 4448 0 0.00 0 6716 17 0 0
v_min_id_clo_res 891 891 0 0.00 0 6070 14 0 0
v_min_id_ord_sup 4575 4575 0 0.00 0 9295 7 0 0
v_min_non_paid_invoice 4924 4924 0 0.00 0 5185 13 0 0
v_min_non_paid_realizn 5857 5857 0 0.00 0 5930 17 0 0
v_our_firm 8540 8540 0 0.00 0 25 1 0 0
v_reserve_write_off 16540 16540 0 0.00 0 11540 11 0 0
x_lock_depdocs_on_canc_invoice 9144 9144 0 0.00 0 22254 138 0 0
x_lock_depdocs_on_canc_sup_ord 335 335 0 0.00 0 24051 474 0 0
x_make_qstorno_1000_1200 4451 4451 0 0.00 1 31412 1390 0 0
x_make_qstorno_1200_2000 4583 4583 0 0.00 2 84838 3054 0 0
x_make_qstorno_2100_3300 403091 403091 0 0.00 0 45163 165 0 0

Completed "Performance in DETAILS". Done for 00:00:05, from 06-03-2024 13:09:26 to 06-03-2024 13:09: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
11:07:54 11 8192000000 8808456480 8823300096 12547216 0.152 4 4 6 0 12844208 175360 121632
11:08:56 32482 8192000000 9716816224 10012123136 797620880 8.872 100 91 182 0 827137632 7294832 22221920
11:10:33 21161 8192000000 9746536864 10048348160 821466176 9.113 100 93 186 0 855304336 11444896 22393264
11:12:07 15374 8192000000 9780881952 10094747648 847806480 9.378 100 85 170 0 888213904 20112880 20294544
11:13:32 13620 8192000000 9865853648 10195521536 913875152 10.036 100 78 156 0 967466640 36916464 16675024
11:14:48 7351 8192000000 9895358720 10237079552 948823296 10.380 100 81 160 0 1011555392 46048960 16683136
11:15:59 4127 8192000000 9956325024 10308669440 986359760 10.746 100 86 170 1 1069083152 65148384 17575008
11:17:06 2245 8192000000 9996577104 10358710272 1011635936 10.991 100 88 175 0 1111637680 82345968 17655776
11:18:09 1542 8192000000 10011243616 10378096640 1044997584 11.313 100 88 176 0 1124050000 61271728 17780688
11:19:12 1521 8192000000 10045914736 10421272576 1061864976 11.474 100 83 163 0 1158268576 80014432 16389168
11:20:15 25631 8192000000 9978989568 10377412608 1073266080 11.583 100 42 84 1 1135238576 53149008 8823488
11:21:43 15731 8192000000 10055340800 10454159360 1083986336 11.685 100 65 130 1 1186162640 88454848 13721456
11:23:00 3330 8192000000 10015547616 10406248448 1086726960 11.712 100 52 103 3 1116767360 19183184 10857216
11:24:05 12527 8192000000 9998233328 10412281856 1098124400 11.820 100 19 36 1 1124797472 23336464 3336608
11:25:18 5736 8192000000 10025569456 10427068416 1099444800 11.832 100 27 54 1 1141509616 36454688 5610128
11:26:26 33143 8192000000 9996602400 10412711936 1095277184 11.793 100 37 75 0 1117647568 13642800 8727584
11:28:01 40273 8192000000 10010508176 10412900352 1096059328 11.800 100 39 77 0 1121541376 16799248 8682800
11:29:46 27019 8192000000 10084781904 10484973568 1096986848 11.809 99 48 96 0 1180256048 73065408 10203792
11:31:17 34739 8192000000 10113379104 10533109760 1128045056 12.103 100 47 94 1 1217526976 79457568 10024352
11:32:59 28904 8192000000 10088367168 10498375680 1062811824 11.483 95 31 62 0 1158266208 88819408 6634976
11:34:46 29768 8192000000 10103316592 10507001856 1073525312 11.586 98 38 76 0 1197584032 116169888 7888832
11:36:26 27169 8192000000 10194010192 10594291712 1114480496 11.975 100 54 108 0 1288255968 162134992 11640480
11:38:01 15752 8192000000 10211378384 10615689216 1099127520 11.829 98 49 98 0 1311615792 200625552 11862720
11:39:22 16497 8192000000 10233722528 10636742656 1090428128 11.747 98 43 83 0 1323271600 223330880 9512592
11:40:41 3087 8192000000 10223600528 10616930304 1090973072 11.752 98 66 126 1 1321454032 216770144 13710816
11:41:53 2766 8192000000 10271946880 10671439872 1133790160 12.157 100 73 144 1 1374171872 223796752 16584960
11:43:02 1940 8192000000 10339727968 10730344448 1130832064 12.129 100 86 170 1 1435878416 286440880 18605472
11:44:09 1095 8192000000 10369119552 10772254720 1141246368 12.227 100 72 144 2 1471509168 314320432 15942368
11:45:18 1327 8192000000 10435036992 10833010688 1149373632 12.304 100 84 168 0 1532684848 364616320 18694896
11:46:23 5974 8192000000 10398246480 10802069504 1166450768 12.464 100 79 151 1 1490115712 306682928 16982016
11:47:33 9858 8192000000 10430458320 10902626304 1171286624 12.509 100 50 100 1 1581858208 397739216 12832368
11:49:01 2423 8192000000 10454534416 10883043328 1158918160 12.393 100 49 93 0 1551267216 379775168 12573888
11:50:08 6409 8192000000 10456840480 10954518528 1162566608 12.427 100 45 90 0 1570726192 396072000 12087584
11:51:27 11472 8192000000 10277353584 10758840320 1151139824 12.320 100 22 44 0 1389313520 232505808 5667888
11:52:41 15593 8192000000 10275574864 10807156736 1144456672 12.257 100 14 28 0 1405034720 256745872 3832176
11:53:58 62337 8192000000 10107907520 10591354880 1100390528 11.841 97 39 74 1 1217340992 108722736 8227728
11:56:03 56517 8192000000 10167873536 10614251520 1141428624 12.229 100 17 31 0 1264384528 119332112 3623792
11:59:19 84657 8192000000 10064433696 10521448448 1135809296 12.176 100 33 64 0 1192771952 50403968 6558688
12:02:31 27430 8192000000 10092761648 10530258944 1145008288 12.263 100 36 72 1 1200366000 47643776 7713936
12:04:02 33300 8192000000 10103469648 10530381824 1152555872 12.333 100 39 78 0 1193406784 32380656 8470256
12:05:38 37807 8192000000 10066532960 10502049792 1143366016 12.247 99 16 30 0 1161871968 15124096 3381856
12:07:21 17740 8192000000 10091517904 10557915136 1155739088 12.363 100 4 8 0 1195730608 39287360 704160
12:08:40 44707 8192000000 10094306016 10564493312 1143701232 12.250 99 9 18 0 1191231168 45984592 1545344
12:10:27 66140 8192000000 10135577520 10591522816 1159785872 12.401 100 22 45 0 1213416368 48417376 5213120
12:12:55 49407 8192000000 10084740064 10581991424 1161060688 12.413 100 10 20 0 1208405296 45539616 1804992
12:14:46 51650 8192000000 10088392736 10543333376 1137287664 12.190 98 18 36 0 1182309296 41715264 3306368
12:16:38 66323 8192000000 10089345424 10543058944 1146595328 12.278 99 21 42 1 1196241008 45419840 4225840
12:18:45 23466 8192000000 10107871952 10542133248 1145272112 12.265 99 43 86 0 1195327280 40308704 9746464
12:20:09 37449 8192000000 10095491712 10556944384 1122074064 12.047 98 27 54 0 1174559344 47164560 5320720
12:22:00 66651 8192000000 10168243888 10634915840 1091263408 11.755 96 23 46 0 1198110112 102099024 4747680
12:24:07 64085 8192000000 10045429744 10482941952 1055234640 11.411 93 15 30 0 1078260576 19896832 3129104
12:26:23 68190 8192000000 10093385984 10516688896 1111418304 11.946 99 55 110 0 1175904016 53325216 11160496
12:28:41 41158 8192000000 10063537504 10524745728 1111388848 11.946 100 23 46 0 1177561760 61293904 4879008
12:30:23 63833 8192000000 10010409536 10464342016 1050868000 11.369 94 8 16 0 1078663840 26395008 1400832
12:32:35 68525 8192000000 10056091232 10514567168 1091986272 11.762 98 12 23 0 1141306832 46995168 2325392
12:34:48 31254 8192000000 10038331488 10477338624 1078255920 11.631 97 21 43 1 1119907088 37594688 4056480
12:36:21 68110 8192000000 10073867376 10519752704 1077732800 11.626 97 20 38 0 1129966224 48177376 4056048
12:38:42 60872 8192000000 10045335840 10471424000 1082557728 11.672 97 23 46 0 1110917696 23460688 4899280
12:41:00 56335 8192000000 10077670848 10496991232 1133246288 12.152 100 24 48 0 1170229520 32783696 4199536
12:42:57 48001 8192000000 10080177984 10515025920 1124225744 12.067 99 20 40 1 1187529840 59215184 4088912
12:44:49 96892 8192000000 10073831232 10514702336 1144601424 12.259 100 28 56 0 1184436880 34121408 5714048
12:47:30 66673 8192000000 10115057952 10573238272 1126006656 12.084 98 20 40 0 1182249728 52300736 3942336
12:51:47 91332 8192000000 10084432848 10595737600 1124661984 12.071 98 21 42 1 1210165120 80642336 4860800
12:54:19 34797 8192000000 10113653792 10558066688 1149191216 12.302 100 23 46 0 1207498544 53127856 5179472
12:56:12 47985 8192000000 10121386224 10600906752 1138431392 12.201 98 32 64 0 1193558736 48536224 6591120
12:58:05 40011 8192000000 10101915984 10543169536 1111715488 11.949 97 17 34 0 1164213712 48826704 3671520
12:59:50 26003 8192000000 10074493744 10511769600 1106064512 11.895 97 25 50 0 1147054512 36059376 4930624
13:01:17 58863 8192000000 10093118368 10546348032 1117884800 12.007 98 32 64 0 1179229344 55039760 6304784
13:03:16 83798 8192000000 10076680720 10527006720 1117082432 11.999 98 18 34 1 1172074544 51077744 3914368
13:05:41 51372 8192000000 10077727696 10545164288 1108211232 11.915 98 8 16 0 1174556560 64523728 1821600
13:07:34 22938 8192000000 9047175968 9277857792 204478384 2.435 19 4 8 0 239465488 34369216 617888

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:13, from 06-03-2024 13:09:33 to 06-03-2024 13:09:46.

Exceptions occured during test was in run

FB_MNEMONA CNT UNIT FB_GDSCODE
except 91 v_add_invoice_to_stock 335544517
except 3 v_cancel_supplier_invoice 335544517

Completed "Exceptions occured during test was in run". Done for 00:00:02, from 06-03-2024 13:09:47 to 06-03-2024 13:09:49.

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          171786
MON$OLDEST_ACTIVE               172280
MON$OLDEST_SNAPSHOT             172280
MON$NEXT_TRANSACTION            172280
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                       1906976
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             689
MON$NEXT_STATEMENT              53
MON$REPLICA_MODE                0


ISQL Version: LI-V4.0.5.3062 Firebird 4.0
Server version:
Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V4.0.5.3062 Firebird 4.0"
Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-V4.0.5.3062 Firebird 4.0/tcp (mscs-test-161.budzdorov.ru)/P17:C"
Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-V4.0.5.3062 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 Wed Mar  6 13:09:50 2024 
 
Database header page information: 
    Flags            0 
    Generation        89879 
    System Change Number    0 
    Page size        8192 
    ODS version        13.0 
    Oldest transaction    171786 
    Oldest active        172280 
    Oldest snapshot        172280 
    Next transaction    172281 
    Sequence number        0 
    Next attachment ID    689 
    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.65, total records: 7697286 
    Average version length: 48.17, total versions: 47694, 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: 88632 
    Data pages: 88632, average fill: 69% 
    Primary pages: 88630, secondary pages: 2, swept pages: 44978 
    Empty pages: 9, full pages: 65031 
    Fill distribution: 
     0 - 19% = 16 
    20 - 39% = 69 
    40 - 59% = 2226 
    60 - 79% = 86286 
    80 - 99% = 35 
 
    Index DOC_DATA_DOC_WARE_UNQ (0) 
    Root page: 1510636, depth: 3, leaf buckets: 23094, nodes: 7697286 
    Average node length: 18.87, total dup: 0, max dup: 0 
    Average key length: 15.88, compression ratio: 1.70 
    Average prefix length: 14.12, average data length: 12.88 
    Clustering factor: 1662468, ratio: 0.22 
    Fill distribution: 
         0 - 19% = 304 
        20 - 39% = 1798 
        40 - 59% = 4027 
        60 - 79% = 2544 
        80 - 99% = 14421 
 
    Index DOC_DATA_ID_DESC (1) 
    Root page: 1528140, depth: 3, leaf buckets: 13454, nodes: 7697286 
    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: 1486475, ratio: 0.19 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 1590 
        40 - 59% = 1995 
        60 - 79% = 1192 
        80 - 99% = 8677 
 
    Index FK_DOC_DATA_DOC_LIST (2) 
    Root page: 1546735, depth: 3, leaf buckets: 8293, nodes: 7697286 
    Average node length: 6.61, total dup: 5770275, max dup: 49 
    Average key length: 3.62, compression ratio: 2.49 
    Average prefix length: 7.63, average data length: 1.37 
    Clustering factor: 1479502, ratio: 0.19 
    Fill distribution: 
         0 - 19% = 136 
        20 - 39% = 941 
        40 - 59% = 1364 
        60 - 79% = 1013 
        80 - 99% = 4839 
 
DOC_LIST (138) 
    Primary pointer page: 500, Index root page: 501 
    Total formats: 1, used formats: 1 
    Average record length: 56.86, total records: 2217097 
    Average version length: 58.86, total versions: 26189, max versions: 2 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 84.00, compression ratio: 1.48 
    Pointer pages: 18, data page slots: 28464 
    Data pages: 28464, average fill: 72% 
    Primary pages: 28462, secondary pages: 2, swept pages: 13671 
    Empty pages: 4, full pages: 16676 
    Fill distribution: 
     0 - 19% = 8 
    20 - 39% = 25 
    40 - 59% = 408 
    60 - 79% = 27968 
    80 - 99% = 55 
 
    Index DOC_LIST_ID_DESC (1) 
    Root page: 1541152, depth: 3, leaf buckets: 4511, nodes: 2217097 
    Average node length: 11.41, total dup: 0, max dup: 0 
    Average key length: 8.45, compression ratio: 1.07 
    Average prefix length: 3.55, average data length: 5.45 
    Clustering factor: 672637, ratio: 0.30 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 846 
        40 - 59% = 914 
        60 - 79% = 758 
        80 - 99% = 1993 
 
    Index DOC_LIST_WORKER_OPTYPE (2) 
    Root page: 1544398, depth: 3, leaf buckets: 2387, nodes: 2218077 
    Average node length: 4.97, total dup: 2217178, max dup: 17953 
    Average key length: 2.01, compression ratio: 4.48 
    Average prefix length: 8.99, average data length: 0.01 
    Clustering factor: 1255798, ratio: 0.57 
    Fill distribution: 
         0 - 19% = 4 
        20 - 39% = 180 
        40 - 59% = 1392 
        60 - 79% = 565 
        80 - 99% = 246 
 
    Index FK_DOC_LIST_AGENTS (3) 
    Root page: 1545933, depth: 3, leaf buckets: 1756, nodes: 2217097 
    Average node length: 4.97, total dup: 2217047, max dup: 130066 
    Average key length: 2.01, compression ratio: 4.48 
    Average prefix length: 8.99, average data length: 0.01 
    Clustering factor: 1056077, ratio: 0.48 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 606 
        60 - 79% = 37 
        80 - 99% = 1112 
 
    Index PK_DOC_LIST (0) 
    Root page: 1538209, depth: 3, leaf buckets: 4326, nodes: 2217097 
    Average node length: 11.41, total dup: 0, max dup: 0 
    Average key length: 8.45, compression ratio: 1.07 
    Average prefix length: 3.55, average data length: 5.45 
    Clustering factor: 672637, ratio: 0.30 
    Fill distribution: 
         0 - 19% = 108 
        20 - 39% = 555 
        40 - 59% = 662 
        60 - 79% = 864 
        80 - 99% = 2137 
 
DOC_STATES (149) 
    Primary pointer page: 522, Index root page: 523 
    Total formats: 1, used formats: 1 
    Average record length: 67.50, total records: 4 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 650.00, compression ratio: 9.63 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 4% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index DOC_STATES_MCODE_UNQ (1) 
    Root page: 1504337, depth: 1, leaf buckets: 1, nodes: 4 
    Average node length: 17.75, total dup: 0, max dup: 0 
    Average key length: 16.50, compression ratio: 1.08 
    Average prefix length: 4.00, average data length: 13.75 
    Clustering factor: 1, ratio: 0.25 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index DOC_STATES_NAME_UNQ (2) 
    Root page: 1504338, depth: 1, leaf buckets: 1, nodes: 4 
    Average node length: 33.25, total dup: 0, max dup: 0 
    Average key length: 32.00, compression ratio: 0.99 
    Average prefix length: 2.50, average data length: 29.25 
    Clustering factor: 1, ratio: 0.25 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PK_DOC_STATES (0) 
    Root page: 1504336, depth: 1, leaf buckets: 1, nodes: 4 
    Average node length: 4.75, total dup: 0, max dup: 0 
    Average key length: 3.50, compression ratio: 0.86 
    Average prefix length: 1.50, average data length: 1.50 
    Clustering factor: 1, ratio: 0.25 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
FB_ERRORS (155) 
    Primary pointer page: 534, Index root page: 535 
    Total formats: 2, used formats: 2 
    Average record length: 57.88, total records: 2182 
    Average version length: 79.61, total versions: 757, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 270.43, compression ratio: 4.67 
    Pointer pages: 1, data page slots: 40 
    Data pages: 40, average fill: 72% 
    Primary pages: 39, secondary pages: 1, swept pages: 0 
    Empty pages: 4, full pages: 34 
    Fill distribution: 
     0 - 19% = 5 
    20 - 39% = 0 
    40 - 59% = 1 
    60 - 79% = 22 
    80 - 99% = 12 
 
    Index FB_ERRORS_GDS_CODE (0) 
    Root page: 398, depth: 2, leaf buckets: 2, nodes: 2182 
    Average node length: 4.40, total dup: 756, max dup: 1 
    Average key length: 2.67, compression ratio: 1.87 
    Average prefix length: 4.33, average data length: 0.67 
    Clustering factor: 1518, ratio: 0.70 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 0 
        40 - 59% = 1 
        60 - 79% = 1 
        80 - 99% = 0 
 
INVNT_SALDO (145) 
    Primary pointer page: 514, Index root page: 515 
    Total formats: 2, used formats: 1 
    Average record length: 83.31, total records: 400 
    Average version length: 29.30, total versions: 882, max versions: 3 
    Average fragment length: 2.00, total fragments: 6, max fragments: 1 
    Average unpacked length: 104.00, compression ratio: 1.25 
    Pointer pages: 1, data page slots: 24 
    Data pages: 24, average fill: 42% 
    Primary pages: 7, secondary pages: 17, swept pages: 0 
    Empty pages: 7, full pages: 9 
    Fill distribution: 
     0 - 19% = 13 
    20 - 39% = 1 
    40 - 59% = 1 
    60 - 79% = 0 
    80 - 99% = 9 
 
    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: 19.99, total records: 82685 
    Average version length: 68.29, total versions: 67369, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 88.00, compression ratio: 4.40 
    Pointer pages: 7, data page slots: 2552 
    Data pages: 1640, average fill: 67% 
    Primary pages: 1639, secondary pages: 1, swept pages: 0 
    Empty pages: 145, full pages: 903 
    Fill distribution: 
     0 - 19% = 234 
    20 - 39% = 120 
    40 - 59% = 182 
    60 - 79% = 304 
    80 - 99% = 800 
 
    Index INVNT_TURNOVER_LOG_WARE_DD_ID (0) 
    Root page: 1704924, depth: 3, leaf buckets: 264, nodes: 82685 
    Average node length: 12.96, total dup: 5668, max dup: 1 
    Average key length: 10.63, compression ratio: 2.54 
    Average prefix length: 19.30, average data length: 7.70 
    Clustering factor: 57455, ratio: 0.69 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 61 
        40 - 59% = 135 
        60 - 79% = 66 
        80 - 99% = 2 
 
MONEY_SALDO (141) 
    Primary pointer page: 506, Index root page: 507 
    Total formats: 1, used formats: 1 
    Average record length: 15.24, total records: 49 
    Average version length: 9.00, total versions: 115, max versions: 3 
    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: 56% 
    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: 15.36, total records: 1424 
    Average version length: 43.32, total versions: 1169, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 58.00, compression ratio: 3.78 
    Pointer pages: 1, data page slots: 40 
    Data pages: 32, average fill: 46% 
    Primary pages: 30, secondary pages: 2, swept pages: 0 
    Empty pages: 7, full pages: 10 
    Fill distribution: 
     0 - 19% = 9 
    20 - 39% = 5 
    40 - 59% = 4 
    60 - 79% = 7 
    80 - 99% = 7 
 
    Index MONEY_TURNOVER_LOG_AGENT_OPTYPE (0) 
    Root page: 90968, depth: 2, leaf buckets: 2, nodes: 1424 
    Average node length: 4.36, total dup: 1327, max dup: 157 
    Average key length: 2.73, compression ratio: 6.97 
    Average prefix length: 18.34, average data length: 0.66 
    Clustering factor: 797, ratio: 0.56 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 1 
        40 - 59% = 1 
        60 - 79% = 0 
        80 - 99% = 0 
 
MON_CACHE_MEMORY (165) 
    Primary pointer page: 555, Index root page: 556 
    Total formats: 2, used formats: 1 
    Average record length: 97.73, total records: 71 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 112.00, compression ratio: 1.15 
    Pointer pages: 1, data page slots: 2 
    Data pages: 2, average fill: 50% 
    Primary pages: 2, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 1 
    Fill distribution: 
     0 - 19% = 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: 71 
    Average node length: 11.70, total dup: 0, max dup: 0 
    Average key length: 10.69, compression ratio: 0.84 
    Average prefix length: 1.30, average data length: 7.70 
    Clustering factor: 2, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
MON_LOG (162) 
    Primary pointer page: 548, Index root page: 549 
    Total formats: 2, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index MON_LOG_DTS (4) 
    Root page: 1504251, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index MON_LOG_GDSCODE (2) 
    Root page: 1504249, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index MON_LOG_ROWSET_DESC (1) 
    Root page: 1504248, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index MON_LOG_UNIT (3) 
    Root page: 1504250, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PK_MON_LOG (0) 
    Root page: 1504247, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
MON_LOG_TABLE_STATS (163) 
    Primary pointer page: 550, Index root page: 551 
    Total formats: 2, used formats: 1 
    Average record length: 67.13, total records: 30 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 611.00, compression ratio: 9.10 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 31% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 1 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index MON_LOG_TABLE_STATS_DTS (4) 
    Root page: 1504246, depth: 1, leaf buckets: 1, nodes: 30 
    Average node length: 3.50, total dup: 23, max dup: 4 
    Average key length: 2.47, compression ratio: 3.24 
    Average prefix length: 7.53, average data length: 0.47 
    Clustering factor: 1, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index MON_LOG_TABLE_STATS_GDSCODE (2) 
    Root page: 1504244, depth: 1, leaf buckets: 1, nodes: 30 
    Average node length: 2.00, total dup: 29, max dup: 29 
    Average key length: 1.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 1, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index MON_LOG_TABLE_STATS_ROWSET (1) 
    Root page: 1504243, depth: 1, leaf buckets: 1, nodes: 30 
    Average node length: 3.33, total dup: 29, max dup: 29 
    Average key length: 2.30, compression ratio: 3.91 
    Average prefix length: 8.70, average data length: 0.30 
    Clustering factor: 1, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index MON_LOG_TABLE_STATS_TN_UNIT (3) 
    Root page: 1504245, depth: 1, leaf buckets: 1, nodes: 30 
    Average node length: 12.90, total dup: 0, max dup: 0 
    Average key length: 11.87, compression ratio: 1.42 
    Average prefix length: 7.63, average data length: 9.20 
    Clustering factor: 1, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PK_MON_LOG_TABLE_STATS (0) 
    Root page: 1504242, depth: 1, leaf buckets: 1, nodes: 30 
    Average node length: 8.37, total dup: 0, max dup: 0 
    Average key length: 7.33, compression ratio: 1.23 
    Average prefix length: 4.63, average data length: 4.37 
    Clustering factor: 1, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
OPTYPES (136) 
    Primary pointer page: 496, Index root page: 497 
    Total formats: 2, used formats: 1 
    Average record length: 67.56, total records: 9 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 386.00, compression ratio: 5.71 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 9% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index OPTYPES_MCODE_UNQ (1) 
    Root page: 1544827, depth: 1, leaf buckets: 1, nodes: 9 
    Average node length: 8.56, total dup: 0, max dup: 0 
    Average key length: 6.89, compression ratio: 0.73 
    Average prefix length: 0.44, average data length: 4.56 
    Clustering factor: 1, ratio: 0.11 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PK_OPTYPES (0) 
    Root page: 1544826, depth: 1, leaf buckets: 1, nodes: 9 
    Average node length: 6.11, total dup: 0, max dup: 0 
    Average key length: 5.00, compression ratio: 0.60 
    Average prefix length: 0.89, average data length: 2.11 
    Clustering factor: 1, ratio: 0.11 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
PDISTR (146) 
    Primary pointer page: 516, Index root page: 517 
    Total formats: 1, used formats: 1 
    Average record length: 36.62, total records: 823978 
    Average version length: 37.96, total versions: 23832, max versions: 2 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 54.00, compression ratio: 1.47 
    Pointer pages: 6, data page slots: 8592 
    Data pages: 8592, average fill: 65% 
    Primary pages: 8591, secondary pages: 1, swept pages: 2055 
    Empty pages: 6, full pages: 6830 
    Fill distribution: 
     0 - 19% = 13 
    20 - 39% = 29 
    40 - 59% = 417 
    60 - 79% = 8095 
    80 - 99% = 38 
 
    Index PDISTR_AGENT_ID (2) 
    Root page: 1509330, depth: 2, leaf buckets: 868, nodes: 812316 
    Average node length: 4.88, total dup: 812267, max dup: 155326 
    Average key length: 2.01, compression ratio: 4.48 
    Average prefix length: 8.99, average data length: 0.01 
    Clustering factor: 91172, ratio: 0.11 
    Fill distribution: 
         0 - 19% = 3 
        20 - 39% = 119 
        40 - 59% = 467 
        60 - 79% = 164 
        80 - 99% = 115 
 
    Index PDISTR_SNDOP_RCVOP_SNDID_ASC (0) 
    Root page: 1508635, depth: 3, leaf buckets: 1014, nodes: 812316 
    Average node length: 5.88, total dup: 723715, max dup: 46 
    Average key length: 3.01, compression ratio: 7.30 
    Average prefix length: 21.10, average data length: 0.90 
    Clustering factor: 162833, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 72 
        40 - 59% = 619 
        60 - 79% = 83 
        80 - 99% = 240 
 
    Index PDISTR_SNDOP_RCVOP_SNDID_DESC (1) 
    Root page: 1509209, depth: 3, leaf buckets: 1034, nodes: 812316 
    Average node length: 5.89, total dup: 723715, max dup: 46 
    Average key length: 3.01, compression ratio: 7.30 
    Average prefix length: 21.09, average data length: 0.91 
    Clustering factor: 164803, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 105 
        40 - 59% = 611 
        60 - 79% = 77 
        80 - 99% = 240 
 
    Index PDISTR_WORKER_SND_ID (3) 
    Root page: 1510200, depth: 3, leaf buckets: 1148, nodes: 812316 
    Average node length: 5.97, total dup: 723715, max dup: 46 
    Average key length: 3.09, compression ratio: 5.49 
    Average prefix length: 16.01, average data length: 0.99 
    Clustering factor: 157172, ratio: 0.19 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 234 
        40 - 59% = 620 
        60 - 79% = 201 
        80 - 99% = 91 
 
PERF_AGG (158) 
    Primary pointer page: 540, Index root page: 541 
    Total formats: 1, used formats: 1 
    Average record length: 62.95, total records: 5444 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 4.00, total fragments: 19, max fragments: 1 
    Average unpacked length: 379.00, compression ratio: 6.02 
    Pointer pages: 1, data page slots: 88 
    Data pages: 87, average fill: 62% 
    Primary pages: 79, secondary pages: 8, swept pages: 61 
    Empty pages: 7, full pages: 64 
    Fill distribution: 
     0 - 19% = 13 
    20 - 39% = 0 
    40 - 59% = 1 
    60 - 79% = 73 
    80 - 99% = 0 
 
    Index PERF_AGG_UNQ (1) 
    Root page: 1504260, depth: 2, leaf buckets: 6, nodes: 5444 
    Average node length: 5.52, total dup: 0, max dup: 0 
    Average key length: 3.58, compression ratio: 10.05 
    Average prefix length: 34.48, average data length: 1.55 
    Clustering factor: 5184, 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: 5444 
    Average node length: 11.14, total dup: 0, max dup: 0 
    Average key length: 9.21, compression ratio: 0.98 
    Average prefix length: 2.79, average data length: 6.21 
    Clustering factor: 160, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 1 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 7 
 
PERF_ESTIMATED (280) 
    Primary pointer page: 399, Index root page: 434 
    Total formats: 1, used formats: 1 
    Average record length: 39.12, total records: 77525 
    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% = 1 
    20 - 39% = 1 
    40 - 59% = 0 
    60 - 79% = 806 
    80 - 99% = 0 
 
    Index PK_PERF_ESTIMATED (0) 
    Root page: 35219, depth: 2, leaf buckets: 99, nodes: 77525 
    Average node length: 10.15, total dup: 0, max dup: 0 
    Average key length: 8.16, compression ratio: 1.10 
    Average prefix length: 3.84, average data length: 5.16 
    Clustering factor: 2938, ratio: 0.04 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 1 
        60 - 79% = 0 
        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: 147.91, total records: 167296 
    Average version length: 150.20, total versions: 3824, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.47 
    Pointer pages: 7, data page slots: 5640 
    Data pages: 4224, average fill: 82% 
    Primary pages: 4221, secondary pages: 3, swept pages: 5 
    Empty pages: 95, full pages: 4094 
    Fill distribution: 
     0 - 19% = 100 
    20 - 39% = 14 
    40 - 59% = 9 
    60 - 79% = 7 
    80 - 99% = 4094 
 
PERF_SPLIT_1 (282) 
    Primary pointer page: 603, Index root page: 604 
    Total formats: 1, used formats: 1 
    Average record length: 146.12, total records: 141054 
    Average version length: 151.31, total versions: 4831, 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: 4696 
    Data pages: 3512, average fill: 83% 
    Primary pages: 3510, secondary pages: 2, swept pages: 11 
    Empty pages: 41, full pages: 3454 
    Fill distribution: 
     0 - 19% = 44 
    20 - 39% = 5 
    40 - 59% = 3 
    60 - 79% = 6 
    80 - 99% = 3454 
 
PERF_SPLIT_2 (283) 
    Primary pointer page: 605, Index root page: 606 
    Total formats: 1, used formats: 1 
    Average record length: 149.60, total records: 157944 
    Average version length: 143.89, total versions: 1700, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.34 
    Pointer pages: 9, data page slots: 5096 
    Data pages: 3944, average fill: 83% 
    Primary pages: 3942, secondary pages: 2, swept pages: 1 
    Empty pages: 51, full pages: 3871 
    Fill distribution: 
     0 - 19% = 64 
    20 - 39% = 2 
    40 - 59% = 4 
    60 - 79% = 3 
    80 - 99% = 3871 
 
PERF_SPLIT_3 (284) 
    Primary pointer page: 607, Index root page: 608 
    Total formats: 1, used formats: 1 
    Average record length: 146.87, total records: 155209 
    Average version length: 150.68, total versions: 4334, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.55 
    Pointer pages: 7, data page slots: 4192 
    Data pages: 3832, average fill: 84% 
    Primary pages: 3830, secondary pages: 2, swept pages: 3 
    Empty pages: 21, full pages: 3800 
    Fill distribution: 
     0 - 19% = 22 
    20 - 39% = 6 
    40 - 59% = 3 
    60 - 79% = 1 
    80 - 99% = 3800 
 
PERF_SPLIT_4 (285) 
    Primary pointer page: 609, Index root page: 610 
    Total formats: 1, used formats: 1 
    Average record length: 112.03, total records: 210232 
    Average version length: 154.92, total versions: 57601, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 15.14 
    Pointer pages: 6, data page slots: 5544 
    Data pages: 5208, average fill: 87% 
    Primary pages: 5206, secondary pages: 2, swept pages: 7 
    Empty pages: 18, full pages: 5172 
    Fill distribution: 
     0 - 19% = 20 
    20 - 39% = 4 
    40 - 59% = 6 
    60 - 79% = 6 
    80 - 99% = 5172 
 
PERF_SPLIT_5 (286) 
    Primary pointer page: 611, Index root page: 612 
    Total formats: 1, used formats: 1 
    Average record length: 134.41, total records: 180530 
    Average version length: 154.02, total versions: 21109, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 12.62 
    Pointer pages: 6, data page slots: 4760 
    Data pages: 4456, average fill: 85% 
    Primary pages: 4453, secondary pages: 3, swept pages: 2 
    Empty pages: 12, full pages: 4432 
    Fill distribution: 
     0 - 19% = 15 
    20 - 39% = 2 
    40 - 59% = 4 
    60 - 79% = 2 
    80 - 99% = 4433 
 
PERF_SPLIT_6 (287) 
    Primary pointer page: 613, Index root page: 614 
    Total formats: 1, used formats: 1 
    Average record length: 147.92, total records: 160000 
    Average version length: 152.53, total versions: 3254, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.47 
    Pointer pages: 7, data page slots: 5544 
    Data pages: 3992, average fill: 83% 
    Primary pages: 3990, secondary pages: 2, swept pages: 5 
    Empty pages: 56, full pages: 3911 
    Fill distribution: 
     0 - 19% = 59 
    20 - 39% = 8 
    40 - 59% = 8 
    60 - 79% = 6 
    80 - 99% = 3911 
 
PERF_SPLIT_7 (288) 
    Primary pointer page: 615, Index root page: 616 
    Total formats: 1, used formats: 1 
    Average record length: 147.50, total records: 158458 
    Average version length: 151.86, total versions: 3973, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.50 
    Pointer pages: 7, data page slots: 5496 
    Data pages: 3920, average fill: 84% 
    Primary pages: 3918, secondary pages: 2, swept pages: 3 
    Empty pages: 23, full pages: 3884 
    Fill distribution: 
     0 - 19% = 28 
    20 - 39% = 1 
    40 - 59% = 3 
    60 - 79% = 4 
    80 - 99% = 3884 
 
PERF_SPLIT_8 (289) 
    Primary pointer page: 617, Index root page: 618 
    Total formats: 1, used formats: 1 
    Average record length: 140.70, total records: 184474 
    Average version length: 153.80, total versions: 13588, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 12.05 
    Pointer pages: 6, data page slots: 6144 
    Data pages: 4600, average fill: 84% 
    Primary pages: 4598, secondary pages: 2, swept pages: 4 
    Empty pages: 54, full pages: 4523 
    Fill distribution: 
     0 - 19% = 57 
    20 - 39% = 9 
    40 - 59% = 3 
    60 - 79% = 8 
    80 - 99% = 4523 
 
PERF_SPLIT_9 (290) 
    Primary pointer page: 619, Index root page: 620 
    Total formats: 1, used formats: 1 
    Average record length: 132.32, total records: 195010 
    Average version length: 154.41, total versions: 26070, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 12.82 
    Pointer pages: 9, data page slots: 5536 
    Data pages: 4856, average fill: 85% 
    Primary pages: 4853, secondary pages: 3, swept pages: 3 
    Empty pages: 45, full pages: 4795 
    Fill distribution: 
     0 - 19% = 48 
    20 - 39% = 5 
    40 - 59% = 2 
    60 - 79% = 5 
    80 - 99% = 4796 
 
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.09, total records: 2071749 
    Average version length: 52.88, total versions: 30960, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 70.00, compression ratio: 1.34 
    Pointer pages: 16, data page slots: 25512 
    Data pages: 25512, average fill: 70% 
    Primary pages: 25490, secondary pages: 22, swept pages: 11747 
    Empty pages: 142, full pages: 21673 
    Fill distribution: 
     0 - 19% = 298 
    20 - 39% = 295 
    40 - 59% = 958 
    60 - 79% = 23640 
    80 - 99% = 321 
 
    Index PSTORNED_RCV_ID (1) 
    Root page: 1506208, depth: 3, leaf buckets: 2566, nodes: 2071749 
    Average node length: 5.45, total dup: 1932068, max dup: 1734 
    Average key length: 2.49, compression ratio: 3.61 
    Average prefix length: 8.58, average data length: 0.42 
    Clustering factor: 180628, ratio: 0.09 
    Fill distribution: 
         0 - 19% = 6 
        20 - 39% = 303 
        40 - 59% = 1685 
        60 - 79% = 287 
        80 - 99% = 285 
 
    Index PSTORNED_SND_ID (0) 
    Root page: 1504841, depth: 3, leaf buckets: 2754, nodes: 2071749 
    Average node length: 5.69, total dup: 1859190, max dup: 63 
    Average key length: 2.74, compression ratio: 3.28 
    Average prefix length: 8.36, average data length: 0.64 
    Clustering factor: 371580, ratio: 0.18 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 10 
        40 - 59% = 2476 
        60 - 79% = 245 
        80 - 99% = 23 
 
    Index PSTORNED_WORKER_ID (2) 
    Root page: 1508018, depth: 3, leaf buckets: 2055, nodes: 2071749 
    Average node length: 4.96, total dup: 2071649, max dup: 26926 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.42, average data length: 0.00 
    Clustering factor: 178392, ratio: 0.09 
    Fill distribution: 
         0 - 19% = 4 
        20 - 39% = 174 
        40 - 59% = 1013 
        60 - 79% = 393 
        80 - 99% = 471 
 
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: 46.99, total records: 137502 
    Average version length: 69.17, total versions: 50765, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 2.68 
    Pointer pages: 3, data page slots: 4328 
    Data pages: 3120, average fill: 53% 
    Primary pages: 3120, secondary pages: 0, swept pages: 424 
    Empty pages: 513, full pages: 1187 
    Fill distribution: 
     0 - 19% = 681 
    20 - 39% = 212 
    40 - 59% = 563 
    60 - 79% = 1103 
    80 - 99% = 561 
 
    Index XQD_1000_1200_WA_SO_RO_WKR_SND (0) 
    Root page: 369422, depth: 3, leaf buckets: 229, nodes: 137502 
    Average node length: 6.47, total dup: 119703, max dup: 14 
    Average key length: 3.96, compression ratio: 10.60 
    Average prefix length: 40.16, average data length: 1.84 
    Clustering factor: 24214, ratio: 0.18 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 70 
        40 - 59% = 104 
        60 - 79% = 52 
        80 - 99% = 3 
 
XQD_1000_3300 (178) 
    Primary pointer page: 581, Index root page: 582 
    Total formats: 1, used formats: 1 
    Average record length: 66.49, total records: 7007847 
    Average version length: 68.72, total versions: 287515, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.90 
    Pointer pages: 66, data page slots: 106568 
    Data pages: 106568, average fill: 70% 
    Primary pages: 106568, secondary pages: 0, swept pages: 32669 
    Empty pages: 64, full pages: 63101 
    Fill distribution: 
     0 - 19% = 528 
    20 - 39% = 1031 
    40 - 59% = 7124 
    60 - 79% = 97286 
    80 - 99% = 599 
 
    Index XQD_1000_3300_WA_SO_RO_WKR_SND (0) 
    Root page: 1480476, depth: 3, leaf buckets: 10742, nodes: 7007847 
    Average node length: 6.51, total dup: 6061323, max dup: 29 
    Average key length: 3.52, compression ratio: 11.93 
    Average prefix length: 40.61, average data length: 1.39 
    Clustering factor: 1665160, ratio: 0.24 
    Fill distribution: 
         0 - 19% = 8 
        20 - 39% = 2001 
        40 - 59% = 5616 
        60 - 79% = 2598 
        80 - 99% = 519 
 
    Index XQD_1000_3300_WKR_DOC_ASC (1) 
    Root page: 1486090, depth: 3, leaf buckets: 8561, nodes: 7007847 
    Average node length: 5.40, total dup: 6729224, max dup: 146 
    Average key length: 2.41, compression ratio: 7.07 
    Average prefix length: 16.63, average data length: 0.37 
    Clustering factor: 1474422, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 11 
        20 - 39% = 1351 
        40 - 59% = 4625 
        60 - 79% = 1643 
        80 - 99% = 931 
 
    Index XQD_1000_3300_WKR_DOC_DEC (2) 
    Root page: 1490630, depth: 3, leaf buckets: 8653, nodes: 7007847 
    Average node length: 5.40, total dup: 6729224, max dup: 146 
    Average key length: 2.41, compression ratio: 7.06 
    Average prefix length: 16.63, average data length: 0.37 
    Clustering factor: 1476733, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 8 
        20 - 39% = 1485 
        40 - 59% = 4618 
        60 - 79% = 1596 
        80 - 99% = 946 
 
XQD_1200_2000 (177) 
    Primary pointer page: 579, Index root page: 580 
    Total formats: 1, used formats: 1 
    Average record length: 67.95, total records: 12051877 
    Average version length: 68.74, total versions: 198623, 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: 108, data page slots: 175640 
    Data pages: 175640, average fill: 73% 
    Primary pages: 175638, secondary pages: 2, swept pages: 85991 
    Empty pages: 5, full pages: 141345 
    Fill distribution: 
     0 - 19% = 26 
    20 - 39% = 414 
    40 - 59% = 5713 
    60 - 79% = 168551 
    80 - 99% = 936 
 
    Index XQD_1200_2000_WA_SO_RO_WKR_SND (0) 
    Root page: 1495050, depth: 3, leaf buckets: 18475, nodes: 12050559 
    Average node length: 6.61, total dup: 10508333, max dup: 57 
    Average key length: 3.42, compression ratio: 12.27 
    Average prefix length: 40.70, average data length: 1.30 
    Clustering factor: 2478385, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 21 
        20 - 39% = 2560 
        40 - 59% = 10626 
        60 - 79% = 4327 
        80 - 99% = 941 
 
XQD_2000_3300 (179) 
    Primary pointer page: 583, Index root page: 584 
    Total formats: 1, used formats: 1 
    Average record length: 51.75, total records: 1378952 
    Average version length: 68.98, total versions: 252753, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 2.44 
    Pointer pages: 28, data page slots: 44136 
    Data pages: 28688, average fill: 51% 
    Primary pages: 28601, secondary pages: 87, swept pages: 11174 
    Empty pages: 3913, full pages: 15039 
    Fill distribution: 
     0 - 19% = 6563 
    20 - 39% = 3979 
    40 - 59% = 2965 
    60 - 79% = 12035 
    80 - 99% = 3146 
 
    Index XQD_2000_3300_WA_SO_RO_WKR_SND (0) 
    Root page: 1479735, depth: 3, leaf buckets: 1842, nodes: 1233180 
    Average node length: 5.53, total dup: 1182544, max dup: 49 
    Average key length: 2.58, compression ratio: 16.27 
    Average prefix length: 41.46, average data length: 0.54 
    Clustering factor: 86185, ratio: 0.07 
    Fill distribution: 
         0 - 19% = 8 
        20 - 39% = 654 
        40 - 59% = 864 
        60 - 79% = 295 
        80 - 99% = 21 
 
XQD_2100_3300 (180) 
    Primary pointer page: 585, Index root page: 586 
    Total formats: 1, used formats: 1 
    Average record length: 42.07, total records: 1007670 
    Average version length: 69.04, total versions: 132790, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 2.99 
    Pointer pages: 25, data page slots: 40568 
    Data pages: 31168, average fill: 29% 
    Primary pages: 31168, secondary pages: 0, swept pages: 10521 
    Empty pages: 9567, full pages: 6740 
    Fill distribution: 
     0 - 19% = 14020 
    20 - 39% = 4755 
    40 - 59% = 6946 
    60 - 79% = 5311 
    80 - 99% = 136 
 
    Index XQD_2100_3300_WA_SO_RO_WKR_SND (0) 
    Root page: 1479229, depth: 3, leaf buckets: 1082, nodes: 688090 
    Average node length: 5.93, total dup: 634911, max dup: 99 
    Average key length: 3.00, compression ratio: 13.98 
    Average prefix length: 41.07, average data length: 0.93 
    Clustering factor: 96837, ratio: 0.14 
    Fill distribution: 
         0 - 19% = 4 
        20 - 39% = 360 
        40 - 59% = 520 
        60 - 79% = 189 
        80 - 99% = 9 
 
XQD_3300_3400 (181) 
    Primary pointer page: 587, Index root page: 588 
    Total formats: 1, used formats: 1 
    Average record length: 67.15, total records: 8986813 
    Average version length: 68.91, total versions: 259605, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.88 
    Pointer pages: 88, data page slots: 143160 
    Data pages: 143128, average fill: 67% 
    Primary pages: 143102, secondary pages: 26, swept pages: 68502 
    Empty pages: 419, full pages: 67240 
    Fill distribution: 
     0 - 19% = 1320 
    20 - 39% = 5292 
    40 - 59% = 21240 
    60 - 79% = 113435 
    80 - 99% = 1841 
 
    Index XQD_3300_3400_WA_SO_RO_WKR_SND (0) 
    Root page: 1472612, depth: 3, leaf buckets: 13425, nodes: 8983881 
    Average node length: 6.68, total dup: 7452131, max dup: 14 
    Average key length: 3.67, compression ratio: 11.45 
    Average prefix length: 40.50, average data length: 1.50 
    Clustering factor: 1997200, ratio: 0.22 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 1646 
        40 - 59% = 6834 
        60 - 79% = 4270 
        80 - 99% = 673 
 
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: 21108434 
    Average version length: 82.98, total versions: 5077, 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: 319200 
    Data pages: 319200, average fill: 81% 
    Primary pages: 319195, secondary pages: 5, swept pages: 13508 
    Empty pages: 34, full pages: 318315 
    Fill distribution: 
     0 - 19% = 56 
    20 - 39% = 51 
    40 - 59% = 119 
    60 - 79% = 48732 
    80 - 99% = 270242 
 
    Index XQS_1000_1200_DOC_ID (1) 
    Root page: 1426738, depth: 3, leaf buckets: 19204, nodes: 21108434 
    Average node length: 5.72, total dup: 20628374, max dup: 128 
    Average key length: 2.16, compression ratio: 4.16 
    Average prefix length: 8.86, average data length: 0.14 
    Clustering factor: 3278572, ratio: 0.16 
    Fill distribution: 
         0 - 19% = 3 
        20 - 39% = 2 
        40 - 59% = 7854 
        60 - 79% = 526 
        80 - 99% = 10819 
 
    Index XQS_1000_1200_RCV_ID (3) 
    Root page: 1457002, depth: 3, leaf buckets: 17130, nodes: 21108434 
    Average node length: 6.31, total dup: 18550673, max dup: 49 
    Average key length: 2.75, compression ratio: 3.27 
    Average prefix length: 8.37, average data length: 0.63 
    Clustering factor: 915768, ratio: 0.04 
    Fill distribution: 
         0 - 19% = 3 
        20 - 39% = 4 
        40 - 59% = 752 
        60 - 79% = 284 
        80 - 99% = 16087 
 
    Index XQS_1000_1200_SND_ID (2) 
    Root page: 1441095, depth: 3, leaf buckets: 20955, nodes: 21108434 
    Average node length: 6.35, total dup: 18468683, max dup: 29 
    Average key length: 2.79, compression ratio: 3.23 
    Average prefix length: 8.34, average data length: 0.66 
    Clustering factor: 3571285, ratio: 0.17 
    Fill distribution: 
         0 - 19% = 4 
        20 - 39% = 2 
        40 - 59% = 8068 
        60 - 79% = 576 
        80 - 99% = 12305 
 
    Index XQS_1000_1200_WORKER_ID (0) 
    Root page: 1413370, depth: 3, leaf buckets: 16006, nodes: 21108434 
    Average node length: 5.56, total dup: 21108334, max dup: 228566 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.42, average data length: 0.00 
    Clustering factor: 944556, ratio: 0.04 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 12 
        40 - 59% = 2779 
        60 - 79% = 345 
        80 - 99% = 12870 
 
XQS_1000_3300 (184) 
    Primary pointer page: 593, Index root page: 594 
    Total formats: 1, used formats: 1 
    Average record length: 80.49, total records: 9426916 
    Average version length: 82.58, total versions: 247292, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.57 
    Pointer pages: 103, data page slots: 167480 
    Data pages: 167440, average fill: 69% 
    Primary pages: 167402, secondary pages: 38, swept pages: 89996 
    Empty pages: 646, full pages: 94150 
    Fill distribution: 
     0 - 19% = 1899 
    20 - 39% = 6118 
    40 - 59% = 21894 
    60 - 79% = 119951 
    80 - 99% = 17578 
 
    Index XQS_1000_3300_DOC_ID (1) 
    Root page: 1367524, depth: 3, leaf buckets: 11315, nodes: 9426916 
    Average node length: 5.35, total dup: 9120989, max dup: 166 
    Average key length: 2.24, compression ratio: 4.02 
    Average prefix length: 8.80, average data length: 0.20 
    Clustering factor: 2131702, ratio: 0.23 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 82 
        40 - 59% = 8882 
        60 - 79% = 2273 
        80 - 99% = 77 
 
    Index XQS_1000_3300_RCV_ID (3) 
    Root page: 1379283, depth: 3, leaf buckets: 13166, nodes: 9426916 
    Average node length: 6.22, total dup: 7814777, max dup: 14 
    Average key length: 3.10, compression ratio: 2.90 
    Average prefix length: 8.07, average data length: 0.93 
    Clustering factor: 1485807, ratio: 0.16 
    Fill distribution: 
         0 - 19% = 104 
        20 - 39% = 3791 
        40 - 59% = 4378 
        60 - 79% = 2658 
        80 - 99% = 2235 
 
    Index XQS_1000_3300_SND_ID (2) 
    Root page: 1373081, depth: 3, leaf buckets: 12623, nodes: 9426916 
    Average node length: 5.97, total dup: 8173776, max dup: 40 
    Average key length: 2.85, compression ratio: 3.15 
    Average prefix length: 8.28, average data length: 0.72 
    Clustering factor: 2316347, ratio: 0.25 
    Fill distribution: 
         0 - 19% = 3 
        20 - 39% = 85 
        40 - 59% = 9873 
        60 - 79% = 2564 
        80 - 99% = 98 
 
    Index XQS_1000_3300_WORKER_ID (0) 
    Root page: 1362789, depth: 3, leaf buckets: 9826, nodes: 9426916 
    Average node length: 5.12, total dup: 9426816, max dup: 148261 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.43, average data length: 0.00 
    Clustering factor: 1514083, ratio: 0.16 
    Fill distribution: 
         0 - 19% = 35 
        20 - 39% = 1210 
        40 - 59% = 4810 
        60 - 79% = 1751 
        80 - 99% = 2020 
 
XQS_1200_2000 (183) 
    Primary pointer page: 591, Index root page: 592 
    Total formats: 1, used formats: 1 
    Average record length: 80.90, total records: 11039094 
    Average version length: 82.48, total versions: 209492, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.56 
    Pointer pages: 118, data page slots: 191584 
    Data pages: 189800, average fill: 71% 
    Primary pages: 189650, secondary pages: 150, swept pages: 71175 
    Empty pages: 3081, full pages: 142706 
    Fill distribution: 
     0 - 19% = 5297 
    20 - 39% = 8006 
    40 - 59% = 17429 
    60 - 79% = 99724 
    80 - 99% = 59344 
 
    Index XQS_1200_2000_DOC_ID (1) 
    Root page: 1392123, depth: 3, leaf buckets: 13098, nodes: 11039094 
    Average node length: 5.29, total dup: 10929970, max dup: 633 
    Average key length: 2.08, compression ratio: 4.32 
    Average prefix length: 8.93, average data length: 0.07 
    Clustering factor: 2309679, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 308 
        40 - 59% = 9575 
        60 - 79% = 3093 
        80 - 99% = 122 
 
    Index XQS_1200_2000_RCV_ID (3) 
    Root page: 1406132, depth: 3, leaf buckets: 10224, nodes: 11039094 
    Average node length: 5.49, total dup: 10555892, max dup: 49 
    Average key length: 2.28, compression ratio: 3.95 
    Average prefix length: 8.77, average data length: 0.23 
    Clustering factor: 706159, ratio: 0.06 
    Fill distribution: 
         0 - 19% = 155 
        20 - 39% = 847 
        40 - 59% = 2507 
        60 - 79% = 1874 
        80 - 99% = 4841 
 
    Index XQS_1200_2000_SND_ID (2) 
    Root page: 1398660, depth: 3, leaf buckets: 14989, nodes: 11039094 
    Average node length: 6.02, total dup: 9627890, max dup: 61 
    Average key length: 2.81, compression ratio: 3.20 
    Average prefix length: 8.32, average data length: 0.68 
    Clustering factor: 2325982, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 3 
        20 - 39% = 386 
        40 - 59% = 11047 
        60 - 79% = 3410 
        80 - 99% = 143 
 
    Index XQS_1200_2000_WORKER_ID (0) 
    Root page: 1386233, depth: 3, leaf buckets: 10468, nodes: 11039094 
    Average node length: 5.21, total dup: 11038994, max dup: 187495 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.43, average data length: 0.00 
    Clustering factor: 694458, ratio: 0.06 
    Fill distribution: 
         0 - 19% = 95 
        20 - 39% = 846 
        40 - 59% = 4560 
        60 - 79% = 1457 
        80 - 99% = 3510 
 
XQS_2000_3300 (185) 
    Primary pointer page: 595, Index root page: 596 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index XQS_2000_3300_DOC_ID (1) 
    Root page: 1361775, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index XQS_2000_3300_RCV_ID (3) 
    Root page: 1361777, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index XQS_2000_3300_SND_ID (2) 
    Root page: 1361776, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index XQS_2000_3300_WORKER_ID (0) 
    Root page: 1361774, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
XQS_2100_3300 (186) 
    Primary pointer page: 597, Index root page: 598 
    Total formats: 1, used formats: 1 
    Average record length: 81.11, total records: 9504575 
    Average version length: 82.88, total versions: 210700, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.55 
    Pointer pages: 105, data page slots: 170832 
    Data pages: 170784, average fill: 69% 
    Primary pages: 170751, secondary pages: 33, swept pages: 95379 
    Empty pages: 586, full pages: 93151 
    Fill distribution: 
     0 - 19% = 1913 
    20 - 39% = 7480 
    40 - 59% = 24386 
    60 - 79% = 120617 
    80 - 99% = 16388 
 
    Index XQS_2100_3300_DOC_ID (1) 
    Root page: 1344708, depth: 3, leaf buckets: 11542, nodes: 9504575 
    Average node length: 5.16, total dup: 9476131, max dup: 1549 
    Average key length: 2.03, compression ratio: 4.43 
    Average prefix length: 8.97, average data length: 0.03 
    Clustering factor: 1920353, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 24 
        20 - 39% = 1563 
        40 - 59% = 7601 
        60 - 79% = 1793 
        80 - 99% = 561 
 
    Index XQS_2100_3300_RCV_ID (3) 
    Root page: 1355739, depth: 3, leaf buckets: 13293, nodes: 9504575 
    Average node length: 6.23, total dup: 7880186, max dup: 14 
    Average key length: 3.10, compression ratio: 2.90 
    Average prefix length: 8.07, average data length: 0.93 
    Clustering factor: 1450840, ratio: 0.15 
    Fill distribution: 
         0 - 19% = 179 
        20 - 39% = 3773 
        40 - 59% = 4365 
        60 - 79% = 2588 
        80 - 99% = 2388 
 
    Index XQS_2100_3300_SND_ID (2) 
    Root page: 1350071, depth: 3, leaf buckets: 12136, nodes: 9504575 
    Average node length: 5.42, total dup: 9075888, max dup: 87 
    Average key length: 2.29, compression ratio: 3.93 
    Average prefix length: 8.76, average data length: 0.24 
    Clustering factor: 2051618, ratio: 0.22 
    Fill distribution: 
         0 - 19% = 31 
        20 - 39% = 1515 
        40 - 59% = 8359 
        60 - 79% = 1641 
        80 - 99% = 590 
 
    Index XQS_2100_3300_WORKER_ID (0) 
    Root page: 987843, depth: 3, leaf buckets: 9853, nodes: 9504575 
    Average node length: 5.13, total dup: 9504475, max dup: 150435 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.43, average data length: 0.00 
    Clustering factor: 1521611, ratio: 0.16 
    Fill distribution: 
         0 - 19% = 47 
        20 - 39% = 1194 
        40 - 59% = 4777 
        60 - 79% = 1755 
        80 - 99% = 2080 
 
XQS_3300_3400 (187) 
    Primary pointer page: 599, Index root page: 600 
    Total formats: 1, used formats: 1 
    Average record length: 67.78, total records: 573403 
    Average version length: 68.84, total versions: 3804, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.86 
    Pointer pages: 5, data page slots: 8016 
    Data pages: 8016, average fill: 75% 
    Primary pages: 8016, secondary pages: 0, swept pages: 3677 
    Empty pages: 2, full pages: 7007 
    Fill distribution: 
     0 - 19% = 2 
    20 - 39% = 4 
    40 - 59% = 81 
    60 - 79% = 7882 
    80 - 99% = 47 
 
    Index XQS_3300_3400_DOC_ID (1) 
    Root page: 40556, depth: 3, leaf buckets: 729, nodes: 573403 
    Average node length: 5.95, total dup: 488226, max dup: 82 
    Average key length: 3.09, compression ratio: 2.91 
    Average prefix length: 8.06, average data length: 0.94 
    Clustering factor: 101049, ratio: 0.18 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 19 
        40 - 59% = 522 
        60 - 79% = 93 
        80 - 99% = 95 
 
    Index XQS_3300_3400_SND_ID (2) 
    Root page: 31063, depth: 3, leaf buckets: 746, nodes: 573403 
    Average node length: 6.15, total dup: 470326, max dup: 29 
    Average key length: 3.29, compression ratio: 2.73 
    Average prefix length: 7.89, average data length: 1.11 
    Clustering factor: 101097, ratio: 0.18 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 20 
        40 - 59% = 529 
        60 - 79% = 88 
        80 - 99% = 108 
 
    Index XQS_3300_3400_WORKER_ID (0) 
    Root page: 377587, depth: 2, leaf buckets: 545, nodes: 573403 
    Average node length: 4.86, total dup: 573303, max dup: 9373 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.42, average data length: 0.00 
    Clustering factor: 89714, ratio: 0.16 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 19 
        40 - 59% = 300 
        60 - 79% = 84 
        80 - 99% = 142 
 
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 Wed Mar  6 13:10:14 2024

Record versions statistics, table

TABLE_NAME TOTAL_RECS TOTAL_VERS MAX_VERSIONS VERS_TO_RECS_PRC MAXV_TO_VERS_PRC
DOC_DATA 7697286 47694 1 0.0000 0.0000
DOC_LIST 2217097 26189 2 0.0000 0.0000
FB_ERRORS 2182 757 1 0.0000 0.0000
INVNT_SALDO 400 882 3 200.0000 0.0000
INVNT_TURNOVER_LOG 82685 67369 1 0.0000 0.0000
MONEY_SALDO 49 115 3 200.0000 0.0000
MONEY_TURNOVER_LOG 1424 1169 1 0.0000 0.0000
PDISTR 823978 23832 2 0.0000 0.0000
PERF_SPLIT_0 167296 3824 1 0.0000 0.0000
PERF_SPLIT_1 141054 4831 1 0.0000 0.0000
PERF_SPLIT_2 157944 1700 1 0.0000 0.0000
PERF_SPLIT_3 155209 4334 1 0.0000 0.0000
PERF_SPLIT_4 210232 57601 1 0.0000 0.0000
PERF_SPLIT_5 180530 21109 1 0.0000 0.0000
PERF_SPLIT_6 160000 3254 1 0.0000 0.0000
PERF_SPLIT_7 158458 3973 1 0.0000 0.0000
PERF_SPLIT_8 184474 13588 1 0.0000 0.0000
PERF_SPLIT_9 195010 26070 1 0.0000 0.0000
PSTORNED 2071749 30960 1 0.0000 0.0000
SEMAPHORES 5 1 1 0.0000 100.0000
XQD_1000_1200 137502 50765 1 0.0000 0.0000
XQD_1000_3300 7007847 287515 1 0.0000 0.0000
XQD_1200_2000 12051877 198623 1 0.0000 0.0000
XQD_2000_3300 1378952 252753 1 0.0000 0.0000
XQD_2100_3300 1007670 132790 1 0.0000 0.0000
XQD_3300_3400 8986813 259605 1 0.0000 0.0000
XQS_1000_1200 21108434 5077 1 0.0000 0.0000
XQS_1000_3300 9426916 247292 1 0.0000 0.0000
XQS_1200_2000 11039094 209492 1 0.0000 0.0000
XQS_2100_3300 9504575 210700 1 0.0000 0.0000
XQS_3300_3400 573403 3804 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 ---
:240: 
:241: mscs-test-161.budzdorov.ru    Wed Mar  6 13:08:01 2024
:242:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3400
:243: 
:244: 
:245: mscs-test-161.budzdorov.ru    Wed Mar  6 13:08:01 2024
:246:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3400
:247: 
:248: 
:249: mscs-test-161.budzdorov.ru    Wed Mar  6 13:08:01 2024
:250:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3400
:251: 
--- end of diff output ---

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

06.03.24 13:10:25. 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-06 13:10:28 No severe PSQL-related problems occured
06.03.24 13:10:29. End of report.