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

Hardware and OS info

Command: hostnamectl
Static hostname mscs-test-161.budzdorov.ru
Icon name computer-server
Chassis server
Machine ID aeee285d2cca40bf84c40a748f599e77
Boot ID 2a7b53d1c5ed44b9bb2712fffac5d8c6
Operating System CentOS Linux 7 (Core)
CPE OS Name cpe:/o:centos:centos:7
Kernel Linux 3.10.0-1127.10.1.el7.x86_64
Architecture x86-64
Command: who -b
bootup_info system boot 2021-11-11 18:28
Command: dmidecode -t system|grep -i -e 'manufacturer\|product\|hypervisor'
Manufacturer HP
Product Name ProLiant DL380 Gen9
Command: dmesg | grep DMI
[ 0.000000] DMI HP ProLiant DL380 Gen9/ProLiant DL380 Gen9, BIOS P89 05/21/2018
Command: lscpu | grep -i -v flags
Architecture x86_64
CPU op-mode(s) 32-bit, 64-bit
Byte Order Little Endian
CPU(s) 24
On-line CPU(s) list 0-23
Thread(s) per core 2
Core(s) per socket 6
Socket(s) 2
NUMA node(s) 2
Vendor ID GenuineIntel
CPU family 6
Model 63
Model name Intel(R) Xeon(R) CPU E5-2620 v3 @ 2.40GHz
Stepping 2
CPU MHz 1200.000
CPU max MHz 2400.0000
CPU min MHz 1200.0000
BogoMIPS 4794.33
Virtualization VT-x
L1d cache 32K
L1i cache 32K
L2 cache 256K
L3 cache 15360K
NUMA node0 CPU(s) 0-5,12-17
NUMA node1 CPU(s) 6-11,18-23
Command: cat /proc/meminfo | grep -i -e 'memtotal\|memfree\|memavail\|buffers\|cached\|swapcached'
MemTotal 32643792 kB
MemFree 15774884 kB
MemAvailable 30313204 kB
Buffers 0 kB
Cached 15980684 kB
SwapCached 2624 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-23 13:07:51
DTS_END                         2024-03-23 13:07:51.9840
FB_GDSCODE                      -1
FB_MNEMONA                      
STACK                           SP_ADD_INVOICE_TO_STOCK(190:30) ==> SP_CUSTOMER_RESERVE(47:5) ==> SP_CHECK_TO_STOP_WORK(32:12) ==> SP_HALT_ON_ERROR(68:17)
IP                              ::1/54676
TRN_ID                          184451
ATT_ID                          594
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: 9145.78 16255 914578
customer order: creation 193.56 385 19356
customer order: refuse 16.32 376 1632
order to supplier: creation 50.21 1200 5021
order to supplier: removal 3.34 78819 334
invoice (draft): creation 50.33 3138 5033
invoice (draft): removal 47.39 650 4739
invoice accept: apply 45.02 20192 4502
invoice accept: cancel 42.47 809 4247
customer reserve: creation 4268.78 196 426878
customer reserve: removal 4113.67 51 411367
realization accept: apply 94.08 187 9408
realization accept: cancel 78.74 146 7874
payment from customer: creation 64.93 127 6493
payment from customer: removal 6.27 107 627
payment to supplier: creation 54.46 171 5446
payment to supplier: removal 3.70 73 370
service: total inventory turnovers 4.71 3096 471
service: total monetary turnovers 6.69 460 669
service: aggregate perf. data 1.07 12188 107
service: refresh index statistics 0.04 202732 4

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:03, from 23-03-2024 13:09:35 to 23-03-2024 13:09:38.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 3251
TEST_TIME 2 3180
TEST_TIME 3 3927
TEST_TIME 4 3805
TEST_TIME 5 3372
TEST_TIME 6 4092
TEST_TIME 7 4665
TEST_TIME 8 5482
TEST_TIME 9 6044
TEST_TIME 10 6137
TEST_TIME 11 5933
TEST_TIME 12 6525
TEST_TIME 13 6728
TEST_TIME 14 6941
TEST_TIME 15 7426
TEST_TIME 16 7641
TEST_TIME 17 7701
TEST_TIME 18 8210
TEST_TIME 19 8184
TEST_TIME 20 8146
TEST_TIME 21 8458
TEST_TIME 22 8641
TEST_TIME 23 8948
TEST_TIME 24 8864
TEST_TIME 25 9429
TEST_TIME 26 9227
TEST_TIME 27 9059
TEST_TIME 28 9219
TEST_TIME 29 9307
TEST_TIME 30 9199
TEST_TIME 31 9167
TEST_TIME 32 9141
TEST_TIME 33 9547
TEST_TIME 34 9547
TEST_TIME 35 9395
TEST_TIME 36 9357
TEST_TIME 37 9178
TEST_TIME 38 9152
TEST_TIME 39 9111
TEST_TIME 40 9191
TEST_TIME 41 9161
TEST_TIME 42 9163
TEST_TIME 43 9071
TEST_TIME 44 9004
TEST_TIME 45 9005
TEST_TIME 46 9006
TEST_TIME 47 8987
TEST_TIME 48 9000
TEST_TIME 49 9069
TEST_TIME 50 9169
TEST_TIME 51 9320
TEST_TIME 52 9307
TEST_TIME 53 9353
TEST_TIME 54 9370
TEST_TIME 55 9391
TEST_TIME 56 9445
TEST_TIME 57 9512
TEST_TIME 58 9407
TEST_TIME 59 9299
TEST_TIME 60 9170
TEST_TIME 61 9183
TEST_TIME 62 9162
TEST_TIME 63 9145
TEST_TIME 64 9072
TEST_TIME 65 8996
TEST_TIME 66 9097
TEST_TIME 67 9082
TEST_TIME 68 9048
TEST_TIME 69 9041
TEST_TIME 70 9242
TEST_TIME 71 9221
TEST_TIME 72 9242
TEST_TIME 73 9274
TEST_TIME 74 9339
TEST_TIME 75 9374
TEST_TIME 76 9370
TEST_TIME 77 9411
TEST_TIME 78 9384
TEST_TIME 79 9314
TEST_TIME 80 9259
TEST_TIME 81 9250
TEST_TIME 82 9273
TEST_TIME 83 9201
TEST_TIME 84 9147
TEST_TIME 85 9130
TEST_TIME 86 9076
TEST_TIME 87 9063
TEST_TIME 88 9082
TEST_TIME 89 9070
TEST_TIME 90 9111
TEST_TIME 91 9116
TEST_TIME 92 9133
TEST_TIME 93 9156
TEST_TIME 94 9164
TEST_TIME 95 9221
TEST_TIME 96 9282
TEST_TIME 97 9259
TEST_TIME 98 9272
TEST_TIME 99 9191
TEST_TIME 100 9156

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:03, from 23-03-2024 13:09:39 to 23-03-2024 13:09:42.

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 1305411 1305411 0 0.00 0 32142 8 0 0
doc_list_biud 1305411 1305411 0 0.00 0 31752 21 0 0
sp_add_invoice_to_stock 4656 4502 154 3.30 27 171892 20192 0 154
sp_cancel_adding_invoice 4247 4247 0 0.00 4 49293 810 0 0
sp_cancel_client_order 1632 1632 0 0.00 4 13769 377 0 0
sp_cancel_customer_reserve 411367 411367 0 0.00 0 31753 51 0 0
sp_cancel_pay_from_customer 627 627 0 0.00 3 8869 108 0 0
sp_cancel_pay_to_supplier 370 370 0 0.00 3 4178 74 0 0
sp_cancel_supplier_invoice 4758 4739 19 0.39 2 22975 650 0 19
sp_cancel_supplier_order 334 334 0 0.00 5 617456 78820 0 0
sp_cancel_write_off 7874 7874 0 0.00 1 14559 146 0 0
sp_client_order 19356 19356 0 0.00 3 33929 386 0 0
sp_customer_reserve 426878 426878 0 0.00 0 54148 197 0 0
sp_fill_shopping_cart 29408 29408 0 0.00 1 22217 42 0 0
sp_fill_shopping_cart_clo_res 426863 426863 0 0.00 0 16550 15 0 0
sp_get_clo_for_invoice 4487 4487 0 0.00 0 42755 388 0 0
sp_kill_cost_storno 13118 13118 0 0.00 0 11049 67 0 0
sp_kill_qstorno_ret_qs2qd 835681 835681 0 0.00 0 31747 28 0 0
sp_kill_qty_storno 444088 444088 0 0.00 0 31752 61 0 0
sp_lock_selected_doc 19213 19213 0 0.00 0 9744 7 0 0
sp_make_cost_storno 25834 25834 0 0.00 0 22125 71 0 0
sp_multiply_rows_for_pdistr 25834 25834 0 0.00 0 16428 38 0 0
sp_multiply_rows_for_qdistr 19356 19356 0 0.00 0 24474 200 0 0
sp_pay_from_customer 6493 6493 0 0.00 4 18096 127 0 0
sp_pay_to_supplier 5446 5446 0 0.00 3 23400 171 0 0
sp_payment_common 11939 11939 0 0.00 1 11130 29 0 0
sp_qd_handle_on_cancel_clo 1632 1632 0 0.00 0 13764 342 0 0
sp_qd_handle_on_invoice_upd_sts 8734 8734 0 0.00 0 18758 272 0 0
sp_qd_handle_on_reserve_upd_sts 9408 9408 0 0.00 0 18416 55 0 0
sp_reserve_write_off 9408 9408 0 0.00 6 18429 187 0 0
sp_supplier_invoice 5033 5033 0 0.00 6 106294 3139 0 0
sp_supplier_order 5021 5021 0 0.00 4 33615 1201 0 0
srv_aggregate_perf_data 108 107 1 0.92 1482 155572 12188 0 1
srv_fill_mon_cache_memory 57 57 0 0.00 1473 123214 38400 0 0
srv_find_qd_qs_mism 868284 868284 0 0.00 0 32141 7 0 0
srv_make_invnt_saldo 471 471 0 0.00 25 97330 3097 0 0
srv_make_money_saldo 669 669 0 0.00 1 12499 461 0 0
srv_recalc_idx_stat 4 4 0 0.00 144553 255399 202733 0 0
t$perf-abend:sp_add_invoice_to_stock 154 154 0 0.00 0 0 0 0 0
t$perf-abend:sp_cancel_supplier_invoice 19 19 0 0.00 0 0 0 0 0
t$perf-abend:srv_aggregate_perf_data 1 1 0 0.00 0 0 0 0 0
t$perf-norm:sp_add_invoice_to_stock 4502 4502 0 0.00 0 8635 160 0 0
t$perf-norm:sp_cancel_adding_invoice 387 387 0 0.00 0 7724 110 0 0
t$perf-norm:sp_cancel_client_order 1632 1632 0 0.00 0 5369 14 0 0
t$perf-norm:sp_cancel_customer_reserve 628 628 0 0.00 0 2473 12 0 0
t$perf-norm:sp_cancel_pay_from_customer 627 627 0 0.00 0 2068 7 0 0
t$perf-norm:sp_cancel_pay_to_supplier 370 370 0 0.00 0 7393 32 0 0
t$perf-norm:sp_cancel_supplier_invoice 396 396 0 0.00 0 529 7 0 0
t$perf-norm:sp_cancel_supplier_order 334 334 0 0.00 0 18192 1555 0 0
t$perf-norm:sp_cancel_write_off 944 944 0 0.00 0 3910 7 0 0
t$perf-norm:sp_client_order 19356 19356 0 0.00 0 4970 15 0 0
t$perf-norm:sp_customer_reserve 850 850 0 0.00 0 1280 5 0 0
t$perf-norm:sp_pay_from_customer 6493 6493 0 0.00 0 7116 7 0 0
t$perf-norm:sp_pay_to_supplier 5446 5446 0 0.00 0 7098 10 0 0
t$perf-norm:sp_reserve_write_off 9408 9408 0 0.00 0 9066 8 0 0
t$perf-norm:sp_supplier_invoice 5033 5033 0 0.00 0 6526 20 0 0
t$perf-norm:sp_supplier_order 5021 5021 0 0.00 0 3404 12 0 0
t$perf-norm:srv_aggregate_perf_data 107 107 0 0.00 0 633 16 0 0
t$perf-norm:srv_fill_mon_cache_memory 57 57 0 0.00 0 190 5 0 0
t$perf-norm:srv_make_invnt_saldo 471 471 0 0.00 0 3635 18 0 0
t$perf-norm:srv_make_money_saldo 669 669 0 0.00 0 3682 12 0 0
t$perf-norm:srv_recalc_idx_stat 4 4 0 0.00 1 11 5 0 0
v_add_invoice_to_stock 9282 8974 308 3.31 0 4286 17 0 308
v_all_customers 35240 35240 0 0.00 0 20 1 0 0
v_all_suppliers 28556 28556 0 0.00 0 34 1 0 0
v_all_wares 38710 38710 0 0.00 0 45 1 0 0
v_cancel_adding_invoice 774 774 0 0.00 0 6219 14 0 0
v_cancel_client_order 3264 3264 0 0.00 0 6151 8 0 0
v_cancel_customer_prepayment 1254 1254 0 0.00 0 4566 10 0 0
v_cancel_customer_reserve 1256 1256 0 0.00 0 465 3 0 0
v_cancel_payment_to_supplier 740 740 0 0.00 0 225 3 0 0
v_cancel_supplier_invoice 830 792 38 4.57 0 588 12 0 38
v_cancel_supplier_order 668 668 0 0.00 0 575 3 0 0
v_cancel_write_off 1888 1888 0 0.00 0 2750 18 0 0
v_max_id_clo_ord 5021 5021 0 0.00 0 1791 2 0 0
v_max_id_clo_res 850 850 0 0.00 0 6017 18 0 0
v_max_id_ord_sup 5031 5031 0 0.00 0 8765 6 0 0
v_max_non_paid_invoice 1220 1220 0 0.00 0 2908 4 0 0
v_max_non_paid_realizn 3283 3283 0 0.00 0 1576 4 0 0
v_min_id_clo_ord 5021 5021 0 0.00 0 16013 15 0 0
v_min_id_clo_res 850 850 0 0.00 0 9763 23 0 0
v_min_id_ord_sup 5031 5031 0 0.00 0 5725 6 0 0
v_min_non_paid_invoice 5446 5446 0 0.00 0 10918 22 0 0
v_min_non_paid_realizn 6493 6493 0 0.00 0 6614 18 0 0
v_our_firm 9890 9890 0 0.00 0 19 1 0 0
v_reserve_write_off 18816 18816 0 0.00 0 6173 5 0 0
x_lock_depdocs_on_canc_invoice 8590 8590 0 0.00 0 14910 119 0 0
x_lock_depdocs_on_canc_sup_ord 334 334 0 0.00 0 3033 294 0 0
x_make_qstorno_1000_1200 5021 5021 0 0.00 1 33599 1114 0 0
x_make_qstorno_1200_2000 5033 5033 0 0.00 2 106289 2979 0 0
x_make_qstorno_2100_3300 426878 426878 0 0.00 0 54147 179 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 23-03-2024 13:09:43 to 23-03-2024 13:09:47.

Memory consumption, metadata cache, attachments activity 

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


Page cache type: shared, buffers: 1000000 for all connections, with total size: 8192000000
measurement_dts measurement duration ms page cache memo used memo used, total memo allocated, total metadata cache metadata cache percent of total total attachments cnt active attachments cnt running statements cnt stalled statements cnt memo used by attachments memo used by transactions memo used by statements
11:07:55 4 8192000000 8801845312 8814190592 7020768 0.085 3 2 2 0 7125600 69056 35776
11:08:57 18798 8192000000 9718658592 10018353152 794956048 8.845 100 90 180 0 824514032 7576800 21981184
11:10:21 17307 8192000000 9761991168 10069237760 835487488 9.254 100 91 182 0 867958816 11198144 21273184
11:11:46 15257 8192000000 9786835648 10101608448 857517520 9.475 100 89 178 0 894417488 16511952 20388016
11:13:09 9450 8192000000 9828773328 10161172480 896212544 9.861 100 75 150 1 942351072 30202384 15936144
11:14:26 6875 8192000000 9897965648 10236252160 932177504 10.216 100 82 164 0 1005009088 55912752 16918832
11:15:35 4993 8192000000 9942338720 10290388992 962432752 10.513 100 78 156 0 1059535952 81311888 15791312
11:16:42 2763 8192000000 9953077472 10311110656 995612544 10.836 100 85 170 0 1064637328 52053184 16971600
11:17:47 2096 8192000000 9993695296 10359259136 1018908816 11.061 100 84 167 1 1111515968 76769328 15837824
11:18:51 2163 8192000000 10013061328 10390740992 1043400640 11.297 100 79 158 1 1136854464 78220400 15233424
11:19:54 1688 8192000000 10032170912 10414411776 1067169008 11.525 100 83 164 1 1157206896 74115552 15922336
11:20:57 8541 8192000000 10001547456 10394869760 1070345520 11.555 100 55 113 2 1116201776 34084528 11771728
11:22:07 5902 8192000000 9990887280 10391408640 1075173968 11.601 100 39 77 0 1112648800 29219120 8255712
11:23:14 7179 8192000000 9991854640 10395148288 1078485776 11.633 100 31 58 2 1099444256 14571488 6386992
11:24:26 62905 8192000000 10007040000 10426601472 1081871200 11.665 100 40 80 0 1117060592 26618800 8570592
11:26:36 4576 8192000000 9994095552 10398461952 1082647664 11.673 100 35 68 1 1115456736 25322416 7486656
11:27:42 4846 8192000000 9998972288 10402979840 1069574944 11.548 99 33 64 1 1109564624 33786992 6202688
11:28:55 8767 8192000000 10006277856 10402398208 1057081200 11.429 97 44 86 1 1100356864 34353392 8922272
11:30:06 123214 8192000000 10079900832 10507210752 1068294080 11.536 98 32 64 0 1164152368 89033648 6824640
11:33:33 22607 8192000000 10086665360 10493394944 1082670176 11.673 99 42 82 1 1177135632 85385040 9080416
11:35:00 7655 8192000000 10093722672 10490118144 1083746848 11.683 100 56 114 0 1196677600 101531648 11399104
11:36:11 5096 8192000000 10085451936 10483970048 1093053008 11.772 100 53 106 0 1202668528 98431664 11183856
11:37:23 10364 8192000000 10076646448 10488061952 1091180944 11.754 100 41 79 0 1193268544 94326000 7761600
11:38:37 10251 8192000000 10110331520 10495717376 1063052352 11.486 98 60 118 2 1195373760 120108576 12212832
11:40:04 2742 8192000000 10104596080 10487554048 1079725824 11.645 100 79 156 1 1205344368 109837328 15781216
11:41:11 1472 8192000000 10155895936 10543656960 1089988928 11.743 100 75 150 0 1261872096 157033952 14849216
11:42:20 8095 8192000000 10136239040 10533437440 1082983840 11.676 100 60 116 1 1238860496 143105408 12771248
11:43:32 5078 8192000000 10188566304 10578325504 1106923568 11.903 100 73 144 0 1287752224 165938448 14890208
11:44:43 2143 8192000000 10200799376 10594988032 1113919728 11.970 100 80 158 1 1299874384 169190608 16764048
11:45:48 28728 8192000000 10168361520 10570395648 1120310880 12.030 100 36 72 1 1268844544 139939952 8593712
11:47:24 2133 8192000000 10234073632 10629726208 1134945728 12.168 100 74 143 1 1332914096 182354112 15614256
11:48:32 4569 8192000000 10222780128 10642735104 1131453200 12.135 100 53 104 0 1323364288 180550080 11361008
11:49:38 3965 8192000000 10203123600 10639237120 1133568160 12.155 100 38 76 0 1316638608 174561248 8509200
11:50:49 14093 8192000000 10169185168 10648039424 1135225856 12.171 100 13 26 0 1283201104 145490960 2484288
11:53:18 13817 8192000000 10047453696 10471845888 1131561136 12.136 100 48 97 1 1152176304 10867088 9748080
11:54:37 16497 8192000000 10099320480 10513444864 1115620608 11.986 99 57 112 1 1177391584 51038512 10732464
11:55:58 81318 8192000000 10054442656 10482388992 1127324448 12.096 100 11 22 0 1168105504 38735616 2045440
11:58:28 3658 8192000000 10088572208 10509049856 1135361424 12.172 100 56 106 3 1185080416 38499200 11219792
11:59:33 35329 8192000000 10146898912 10597834752 1136734960 12.185 100 23 46 0 1234746576 93125200 4886416
12:01:12 118462 8192000000 10081120464 10519646208 1143691872 12.250 100 19 38 0 1187707392 40219712 3795808
12:04:14 39536 8192000000 10080108064 10517082112 1145167792 12.264 100 33 67 1 1176157200 24329168 6660240
12:05:56 32528 8192000000 10059086592 10518614016 1120842224 12.035 99 15 30 1 1165394752 41512064 3040464
12:07:31 32370 8192000000 10062598240 10512125952 1129616048 12.118 100 11 22 0 1180085408 48205008 2264352
12:09:03 16933 8192000000 10064848944 10520215552 1132720464 12.147 100 16 32 0 1176725584 40341072 3664048
12:10:27 21180 8192000000 10083523104 10523316224 1104355616 11.879 97 18 34 0 1151597616 43656800 3585200
12:11:49 45213 8192000000 10077800784 10520604672 1121434064 12.041 99 20 40 0 1176069056 50393376 4241616
12:13:36 38702 8192000000 10040555648 10484785152 1073946064 11.590 96 11 22 0 1112844880 36664912 2233904
12:15:19 29922 8192000000 10116178720 10563088384 1126821840 12.091 99 23 44 0 1198746384 67222944 4701600
12:16:56 44670 8192000000 10154861904 10617446400 1105335616 11.888 98 17 34 1 1263631904 154414240 3882048
12:18:41 17546 8192000000 10033951936 10451480576 1087414304 11.718 99 47 93 1 1119093584 22289744 9389536
12:20:04 39239 8192000000 10028152976 10471436288 1054972320 11.408 96 31 62 0 1128785264 68151408 5661536
12:21:48 11754 8192000000 10060190848 10488946688 1070996048 11.562 97 63 126 0 1122216272 38859088 12361136
12:23:01 19957 8192000000 10074890608 10493956096 1054966656 11.408 96 35 70 0 1129765664 67941232 6857776
12:24:22 77443 8192000000 10007573840 10442653696 1044023616 11.303 96 11 22 1 1071669824 25560608 2085600
12:26:42 83373 8192000000 10030665472 10470359040 1049922480 11.360 96 31 62 0 1083066944 26759552 6384912
12:29:45 30718 8192000000 10011641344 10496860160 1083580576 11.682 100 12 24 0 1137757008 51364240 2812192
12:31:18 47743 8192000000 10058095088 10514894848 1103596992 11.872 100 9 18 0 1165764208 60350624 1816592
12:33:09 67570 8192000000 10020246128 10461114368 1073891264 11.589 97 16 32 0 1103347040 26511712 2944064
12:35:20 14489 8192000000 10079017056 10503704576 1114781872 11.978 100 52 103 0 1183891728 57902704 11207152
12:36:35 68157 8192000000 10079683024 10640863232 1116985680 11.999 100 13 26 0 1281373104 161385360 3002064
12:38:58 43202 8192000000 10065634688 10526298112 1114515152 11.975 99 28 54 0 1166278160 46356384 5406624
12:40:44 62280 8192000000 10067535136 10516791296 1134827200 12.167 100 17 34 0 1191260352 53148384 3284768
12:42:50 93675 8192000000 10098391168 10561798144 1097658032 11.815 96 29 58 0 1144257232 40390256 6208944
12:45:29 112390 8192000000 10106643776 10609344512 1132435824 12.144 100 18 36 0 1179480096 42970800 4073472
12:48:49 34703 8192000000 10053285072 10549407744 1133164144 12.151 100 17 34 1 1194989760 57436144 4389472
12:50:25 45691 8192000000 10048587248 10499657728 1131582352 12.136 100 19 38 0 1158942800 23383968 3976480
12:52:11 65011 8192000000 10061515616 10542821376 1128544288 12.108 99 10 20 0 1180352464 49454016 2354160
12:54:27 40650 8192000000 10061852848 10515861504 1113711376 11.968 98 17 34 0 1148899584 31564800 3623408
12:56:08 51150 8192000000 10059867664 10505617408 1079962448 11.647 95 16 32 0 1116917664 33771872 3183344
12:58:03 41144 8192000000 10084928096 10534359040 1115386432 11.983 99 31 60 0 1161800320 40603920 5809968
12:59:44 43328 8192000000 10082995920 10553290752 1098896336 11.827 98 22 44 0 1156225808 52693760 4635712
13:01:28 57755 8192000000 10055676448 10559885312 1108585408 11.919 99 13 26 0 1195072480 83906336 2580736
13:03:31 105106 8192000000 10032948720 10455613440 1013765520 11.012 91 26 52 0 1055562896 36811088 4986288
13:06:19 83568 8192000000 10004530176 10448465920 1059023536 11.447 98 30 58 0 1112240624 47578944 5638144

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:15, from 23-03-2024 13:09:49 to 23-03-2024 13:10:04.

Exceptions occured during test was in run

FB_MNEMONA CNT UNIT FB_GDSCODE
except 1 srv_aggregate_perf_data 335544517
except 154 v_add_invoice_to_stock 335544517
except 19 v_cancel_supplier_invoice 335544517

Completed "Exceptions occured during test was in run". Done for 00:00:02, from 23-03-2024 13:10:05 to 23-03-2024 13:10:07.

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          184761
MON$OLDEST_ACTIVE               184762
MON$OLDEST_SNAPSHOT             184762
MON$NEXT_TRANSACTION            184762
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                       1912032
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             719
MON$NEXT_STATEMENT              53
MON$REPLICA_MODE                0


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

Database statistics 

 
Database "/home/bases/oltp40-etalone.fdb" 
Gstat execution time Sat Mar 23 13:10:08 2024 
 
Database header page information: 
    Flags            0 
    Generation        96568 
    System Change Number    0 
    Page size        8192 
    ODS version        13.0 
    Oldest transaction    184761 
    Oldest active        184762 
    Oldest snapshot        184762 
    Next transaction    184763 
    Sequence number        0 
    Next attachment ID    719 
    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: 7784304 
    Average version length: 48.16, total versions: 49901, 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: 89384 
    Data pages: 89384, average fill: 70% 
    Primary pages: 89382, secondary pages: 2, swept pages: 45716 
    Empty pages: 3, full pages: 65802 
    Fill distribution: 
     0 - 19% = 10 
    20 - 39% = 48 
    40 - 59% = 1775 
    60 - 79% = 87522 
    80 - 99% = 29 
 
    Index DOC_DATA_DOC_WARE_UNQ (0) 
    Root page: 1510636, depth: 3, leaf buckets: 23368, nodes: 7784304 
    Average node length: 18.90, total dup: 0, max dup: 0 
    Average key length: 15.91, compression ratio: 1.70 
    Average prefix length: 14.08, average data length: 12.92 
    Clustering factor: 1699903, ratio: 0.22 
    Fill distribution: 
         0 - 19% = 336 
        20 - 39% = 1773 
        40 - 59% = 4173 
        60 - 79% = 2351 
        80 - 99% = 14735 
 
    Index DOC_DATA_ID_DESC (1) 
    Root page: 1528140, depth: 3, leaf buckets: 13578, nodes: 7784304 
    Average node length: 11.20, total dup: 0, max dup: 0 
    Average key length: 8.21, compression ratio: 1.10 
    Average prefix length: 3.79, average data length: 5.21 
    Clustering factor: 1523359, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 1628 
        40 - 59% = 2028 
        60 - 79% = 1082 
        80 - 99% = 8840 
 
    Index FK_DOC_DATA_DOC_LIST (2) 
    Root page: 1546735, depth: 3, leaf buckets: 8361, nodes: 7784304 
    Average node length: 6.62, total dup: 5810908, max dup: 49 
    Average key length: 3.64, compression ratio: 2.48 
    Average prefix length: 7.62, average data length: 1.38 
    Clustering factor: 1516185, ratio: 0.19 
    Fill distribution: 
         0 - 19% = 123 
        20 - 39% = 947 
        40 - 59% = 1378 
        60 - 79% = 923 
        80 - 99% = 4990 
 
DOC_LIST (138) 
    Primary pointer page: 500, Index root page: 501 
    Total formats: 1, used formats: 1 
    Average record length: 56.93, total records: 2264837 
    Average version length: 58.87, total versions: 24544, 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: 29096 
    Data pages: 29096, average fill: 72% 
    Primary pages: 29094, secondary pages: 2, swept pages: 16245 
    Empty pages: 6, full pages: 16853 
    Fill distribution: 
     0 - 19% = 16 
    20 - 39% = 30 
    40 - 59% = 605 
    60 - 79% = 28396 
    80 - 99% = 49 
 
    Index DOC_LIST_ID_DESC (1) 
    Root page: 1541152, depth: 3, leaf buckets: 4583, nodes: 2264837 
    Average node length: 11.40, total dup: 0, max dup: 0 
    Average key length: 8.44, compression ratio: 1.07 
    Average prefix length: 3.56, average data length: 5.44 
    Clustering factor: 681375, ratio: 0.30 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 936 
        40 - 59% = 825 
        60 - 79% = 728 
        80 - 99% = 2094 
 
    Index DOC_LIST_WORKER_OPTYPE (2) 
    Root page: 1544398, depth: 3, leaf buckets: 2438, nodes: 2265765 
    Average node length: 4.97, total dup: 2264866, max dup: 20585 
    Average key length: 2.01, compression ratio: 4.48 
    Average prefix length: 8.99, average data length: 0.01 
    Clustering factor: 1270487, ratio: 0.56 
    Fill distribution: 
         0 - 19% = 4 
        20 - 39% = 209 
        40 - 59% = 1405 
        60 - 79% = 551 
        80 - 99% = 269 
 
    Index FK_DOC_LIST_AGENTS (3) 
    Root page: 1545933, depth: 3, leaf buckets: 1806, nodes: 2264837 
    Average node length: 4.97, total dup: 2264787, max dup: 130775 
    Average key length: 2.01, compression ratio: 4.48 
    Average prefix length: 8.99, average data length: 0.01 
    Clustering factor: 1078897, ratio: 0.48 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 3 
        40 - 59% = 646 
        60 - 79% = 49 
        80 - 99% = 1108 
 
    Index PK_DOC_LIST (0) 
    Root page: 1538209, depth: 3, leaf buckets: 4376, nodes: 2264837 
    Average node length: 11.40, total dup: 0, max dup: 0 
    Average key length: 8.44, compression ratio: 1.07 
    Average prefix length: 3.56, average data length: 5.44 
    Clustering factor: 681375, ratio: 0.30 
    Fill distribution: 
         0 - 19% = 92 
        20 - 39% = 589 
        40 - 59% = 644 
        60 - 79% = 813 
        80 - 99% = 2238 
 
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.44, total records: 400 
    Average version length: 28.25, total versions: 1487, max versions: 4 
    Average fragment length: 2.00, total fragments: 2, max fragments: 1 
    Average unpacked length: 104.00, compression ratio: 1.25 
    Pointer pages: 1, data page slots: 24 
    Data pages: 24, average fill: 55% 
    Primary pages: 7, secondary pages: 17, swept pages: 0 
    Empty pages: 6, full pages: 11 
    Fill distribution: 
     0 - 19% = 9 
    20 - 39% = 0 
    40 - 59% = 2 
    60 - 79% = 2 
    80 - 99% = 11 
 
    Index PK_INVNT_SALDO (0) 
    Root page: 1510371, depth: 1, leaf buckets: 1, nodes: 400 
    Average node length: 11.22, total dup: 0, max dup: 0 
    Average key length: 10.22, compression ratio: 0.88 
    Average prefix length: 1.78, average data length: 7.22 
    Clustering factor: 326, ratio: 0.81 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 0 
        40 - 59% = 1 
        60 - 79% = 0 
        80 - 99% = 0 
 
INVNT_TURNOVER_LOG (153) 
    Primary pointer page: 530, Index root page: 531 
    Total formats: 1, used formats: 1 
    Average record length: 14.83, total records: 90563 
    Average version length: 68.29, total versions: 81650, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 88.00, compression ratio: 5.93 
    Pointer pages: 6, data page slots: 1896 
    Data pages: 1848, average fill: 66% 
    Primary pages: 1847, secondary pages: 1, swept pages: 39 
    Empty pages: 171, full pages: 971 
    Fill distribution: 
     0 - 19% = 225 
    20 - 39% = 170 
    40 - 59% = 255 
    60 - 79% = 326 
    80 - 99% = 872 
 
    Index INVNT_TURNOVER_LOG_WARE_DD_ID (0) 
    Root page: 1700676, depth: 3, leaf buckets: 338, nodes: 90563 
    Average node length: 13.52, total dup: 5839, max dup: 1 
    Average key length: 10.81, compression ratio: 2.50 
    Average prefix length: 19.12, average data length: 7.88 
    Clustering factor: 68398, ratio: 0.76 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 134 
        40 - 59% = 152 
        60 - 79% = 49 
        80 - 99% = 2 
 
MONEY_SALDO (141) 
    Primary pointer page: 506, Index root page: 507 
    Total formats: 1, used formats: 1 
    Average record length: 15.27, total records: 49 
    Average version length: 9.00, total versions: 143, max versions: 5 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 32.00, compression ratio: 2.10 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 65% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 1 
    80 - 99% = 0 
 
    Index PK_MONEY_SALDO (0) 
    Root page: 1510383, depth: 1, leaf buckets: 1, nodes: 49 
    Average node length: 11.82, total dup: 0, max dup: 0 
    Average key length: 10.80, compression ratio: 0.83 
    Average prefix length: 1.18, average data length: 7.82 
    Clustering factor: 1, ratio: 0.02 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
MONEY_TURNOVER_LOG (140) 
    Primary pointer page: 504, Index root page: 505 
    Total formats: 1, used formats: 1 
    Average record length: 12.49, total records: 1635 
    Average version length: 43.44, total versions: 1471, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 58.00, compression ratio: 4.64 
    Pointer pages: 1, data page slots: 40 
    Data pages: 32, average fill: 54% 
    Primary pages: 30, secondary pages: 2, swept pages: 0 
    Empty pages: 4, full pages: 11 
    Fill distribution: 
     0 - 19% = 8 
    20 - 39% = 3 
    40 - 59% = 5 
    60 - 79% = 4 
    80 - 99% = 12 
 
    Index MONEY_TURNOVER_LOG_AGENT_OPTYPE (0) 
    Root page: 92285, depth: 2, leaf buckets: 2, nodes: 1635 
    Average node length: 4.34, total dup: 1537, max dup: 185 
    Average key length: 2.63, compression ratio: 7.21 
    Average prefix length: 18.43, average data length: 0.57 
    Clustering factor: 895, ratio: 0.55 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 1 
        40 - 59% = 0 
        60 - 79% = 1 
        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.59, total records: 74 
    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: 52% 
    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: 74 
    Average node length: 11.69, total dup: 0, max dup: 0 
    Average key length: 10.68, compression ratio: 0.84 
    Average prefix length: 1.31, average data length: 7.69 
    Clustering factor: 2, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
MON_LOG (162) 
    Primary pointer page: 548, Index root page: 549 
    Total formats: 2, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index MON_LOG_DTS (4) 
    Root page: 1504251, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index MON_LOG_GDSCODE (2) 
    Root page: 1504249, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index MON_LOG_ROWSET_DESC (1) 
    Root page: 1504248, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index MON_LOG_UNIT (3) 
    Root page: 1504250, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PK_MON_LOG (0) 
    Root page: 1504247, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
MON_LOG_TABLE_STATS (163) 
    Primary pointer page: 550, Index root page: 551 
    Total formats: 2, used formats: 1 
    Average record length: 67.13, total records: 30 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 611.00, compression ratio: 9.10 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 31% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 1 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index MON_LOG_TABLE_STATS_DTS (4) 
    Root page: 1504246, depth: 1, leaf buckets: 1, nodes: 30 
    Average node length: 3.50, total dup: 23, max dup: 4 
    Average key length: 2.47, compression ratio: 3.24 
    Average prefix length: 7.53, average data length: 0.47 
    Clustering factor: 1, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index MON_LOG_TABLE_STATS_GDSCODE (2) 
    Root page: 1504244, depth: 1, leaf buckets: 1, nodes: 30 
    Average node length: 2.00, total dup: 29, max dup: 29 
    Average key length: 1.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 1, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index MON_LOG_TABLE_STATS_ROWSET (1) 
    Root page: 1504243, depth: 1, leaf buckets: 1, nodes: 30 
    Average node length: 3.33, total dup: 29, max dup: 29 
    Average key length: 2.30, compression ratio: 3.91 
    Average prefix length: 8.70, average data length: 0.30 
    Clustering factor: 1, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index MON_LOG_TABLE_STATS_TN_UNIT (3) 
    Root page: 1504245, depth: 1, leaf buckets: 1, nodes: 30 
    Average node length: 12.90, total dup: 0, max dup: 0 
    Average key length: 11.87, compression ratio: 1.42 
    Average prefix length: 7.63, average data length: 9.20 
    Clustering factor: 1, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PK_MON_LOG_TABLE_STATS (0) 
    Root page: 1504242, depth: 1, leaf buckets: 1, nodes: 30 
    Average node length: 8.37, total dup: 0, max dup: 0 
    Average key length: 7.33, compression ratio: 1.23 
    Average prefix length: 4.63, average data length: 4.37 
    Clustering factor: 1, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
OPTYPES (136) 
    Primary pointer page: 496, Index root page: 497 
    Total formats: 2, used formats: 1 
    Average record length: 67.56, total records: 9 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 386.00, compression ratio: 5.71 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 9% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index OPTYPES_MCODE_UNQ (1) 
    Root page: 1544827, depth: 1, leaf buckets: 1, nodes: 9 
    Average node length: 8.56, total dup: 0, max dup: 0 
    Average key length: 6.89, compression ratio: 0.73 
    Average prefix length: 0.44, average data length: 4.56 
    Clustering factor: 1, ratio: 0.11 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PK_OPTYPES (0) 
    Root page: 1544826, depth: 1, leaf buckets: 1, nodes: 9 
    Average node length: 6.11, total dup: 0, max dup: 0 
    Average key length: 5.00, compression ratio: 0.60 
    Average prefix length: 0.89, average data length: 2.11 
    Clustering factor: 1, ratio: 0.11 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
PDISTR (146) 
    Primary pointer page: 516, Index root page: 517 
    Total formats: 1, used formats: 1 
    Average record length: 36.72, total records: 773845 
    Average version length: 37.93, total versions: 21629, 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: 8256 
    Data pages: 8256, average fill: 64% 
    Primary pages: 8254, secondary pages: 2, swept pages: 3582 
    Empty pages: 4, full pages: 3787 
    Fill distribution: 
     0 - 19% = 12 
    20 - 39% = 35 
    40 - 59% = 893 
    60 - 79% = 7267 
    80 - 99% = 49 
 
    Index PDISTR_AGENT_ID (2) 
    Root page: 1509330, depth: 2, leaf buckets: 832, nodes: 764527 
    Average node length: 4.88, total dup: 764478, max dup: 137721 
    Average key length: 2.01, compression ratio: 4.48 
    Average prefix length: 8.99, average data length: 0.01 
    Clustering factor: 89962, ratio: 0.12 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 141 
        40 - 59% = 430 
        60 - 79% = 164 
        80 - 99% = 95 
 
    Index PDISTR_SNDOP_RCVOP_SNDID_ASC (0) 
    Root page: 1508635, depth: 3, leaf buckets: 855, nodes: 764527 
    Average node length: 5.89, total dup: 680544, max dup: 42 
    Average key length: 3.02, compression ratio: 7.29 
    Average prefix length: 21.09, average data length: 0.91 
    Clustering factor: 156034, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 50 
        40 - 59% = 353 
        60 - 79% = 135 
        80 - 99% = 315 
 
    Index PDISTR_SNDOP_RCVOP_SNDID_DESC (1) 
    Root page: 1509209, depth: 3, leaf buckets: 896, nodes: 764527 
    Average node length: 5.89, total dup: 680544, max dup: 42 
    Average key length: 3.02, compression ratio: 7.28 
    Average prefix length: 21.09, average data length: 0.91 
    Clustering factor: 157881, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 130 
        40 - 59% = 334 
        60 - 79% = 148 
        80 - 99% = 284 
 
    Index PDISTR_WORKER_SND_ID (3) 
    Root page: 1510200, depth: 3, leaf buckets: 1088, nodes: 764527 
    Average node length: 5.97, total dup: 680544, max dup: 42 
    Average key length: 3.10, compression ratio: 5.48 
    Average prefix length: 16.01, average data length: 0.99 
    Clustering factor: 150831, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 5 
        20 - 39% = 235 
        40 - 59% = 578 
        60 - 79% = 183 
        80 - 99% = 87 
 
PERF_AGG (158) 
    Primary pointer page: 540, Index root page: 541 
    Total formats: 1, used formats: 1 
    Average record length: 63.01, total records: 5563 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 3.22, total fragments: 37, max fragments: 1 
    Average unpacked length: 379.00, compression ratio: 6.02 
    Pointer pages: 1, data page slots: 96 
    Data pages: 95, average fill: 58% 
    Primary pages: 82, secondary pages: 13, swept pages: 66 
    Empty pages: 9, full pages: 66 
    Fill distribution: 
     0 - 19% = 18 
    20 - 39% = 1 
    40 - 59% = 5 
    60 - 79% = 71 
    80 - 99% = 0 
 
    Index PERF_AGG_UNQ (1) 
    Root page: 1504260, depth: 2, leaf buckets: 6, nodes: 5563 
    Average node length: 5.52, total dup: 0, max dup: 0 
    Average key length: 3.58, compression ratio: 10.12 
    Average prefix length: 34.72, average data length: 1.55 
    Clustering factor: 5297, ratio: 0.95 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 0 
        40 - 59% = 3 
        60 - 79% = 1 
        80 - 99% = 2 
 
    Index PK_PERF_AGG (0) 
    Root page: 1504255, depth: 2, leaf buckets: 10, nodes: 5563 
    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: 171, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 2 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 7 
 
PERF_ESTIMATED (280) 
    Primary pointer page: 399, Index root page: 434 
    Total formats: 1, used formats: 1 
    Average record length: 39.06, total records: 84225 
    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: 880 
    Data pages: 880, average fill: 66% 
    Primary pages: 880, secondary pages: 0, swept pages: 0 
    Empty pages: 5, full pages: 874 
    Fill distribution: 
     0 - 19% = 5 
    20 - 39% = 0 
    40 - 59% = 1 
    60 - 79% = 874 
    80 - 99% = 0 
 
    Index PK_PERF_ESTIMATED (0) 
    Root page: 37599, depth: 2, leaf buckets: 107, nodes: 84225 
    Average node length: 10.14, total dup: 0, max dup: 0 
    Average key length: 8.15, compression ratio: 1.10 
    Average prefix length: 3.85, average data length: 5.15 
    Clustering factor: 3350, ratio: 0.04 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 106 
 
PERF_ISQL_STAT (156) 
    Primary pointer page: 536, Index root page: 537 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index PERF_ISQL_STAT_TRN (0) 
    Root page: 1504261, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
PERF_LOG (159) 
    Primary pointer page: 542, Index root page: 543 
    Total formats: 1, used formats: 1 
    Average record length: 111.07, total records: 71 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1691.00, compression ratio: 15.22 
    Pointer pages: 1, data page slots: 2 
    Data pages: 2, average fill: 56% 
    Primary pages: 2, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 1 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 1 
    40 - 59% = 0 
    60 - 79% = 1 
    80 - 99% = 0 
 
PERF_SPLIT_0 (281) 
    Primary pointer page: 601, Index root page: 602 
    Total formats: 1, used formats: 1 
    Average record length: 144.56, total records: 158194 
    Average version length: 149.67, total versions: 7054, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.73 
    Pointer pages: 6, data page slots: 5416 
    Data pages: 3976, average fill: 82% 
    Primary pages: 3973, secondary pages: 3, swept pages: 11 
    Empty pages: 82, full pages: 3863 
    Fill distribution: 
     0 - 19% = 85 
    20 - 39% = 9 
    40 - 59% = 5 
    60 - 79% = 18 
    80 - 99% = 3859 
 
PERF_SPLIT_1 (282) 
    Primary pointer page: 603, Index root page: 604 
    Total formats: 1, used formats: 1 
    Average record length: 143.14, total records: 131697 
    Average version length: 151.31, total versions: 6839, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.85 
    Pointer pages: 5, data page slots: 4368 
    Data pages: 3280, average fill: 83% 
    Primary pages: 3277, secondary pages: 3, swept pages: 2 
    Empty pages: 48, full pages: 3217 
    Fill distribution: 
     0 - 19% = 51 
    20 - 39% = 4 
    40 - 59% = 6 
    60 - 79% = 3 
    80 - 99% = 3216 
 
PERF_SPLIT_2 (283) 
    Primary pointer page: 605, Index root page: 606 
    Total formats: 1, used formats: 1 
    Average record length: 141.28, total records: 152712 
    Average version length: 151.41, total versions: 10081, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 12.00 
    Pointer pages: 6, data page slots: 4864 
    Data pages: 3800, average fill: 83% 
    Primary pages: 3797, secondary pages: 3, swept pages: 1 
    Empty pages: 53, full pages: 3733 
    Fill distribution: 
     0 - 19% = 53 
    20 - 39% = 3 
    40 - 59% = 7 
    60 - 79% = 3 
    80 - 99% = 3734 
 
PERF_SPLIT_3 (284) 
    Primary pointer page: 607, Index root page: 616 
    Total formats: 1, used formats: 1 
    Average record length: 130.79, total records: 175381 
    Average version length: 153.86, total versions: 24804, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 12.97 
    Pointer pages: 6, data page slots: 5136 
    Data pages: 4376, average fill: 84% 
    Primary pages: 4374, secondary pages: 2, swept pages: 1 
    Empty pages: 56, full pages: 4300 
    Fill distribution: 
     0 - 19% = 61 
    20 - 39% = 5 
    40 - 59% = 3 
    60 - 79% = 7 
    80 - 99% = 4300 
 
PERF_SPLIT_4 (285) 
    Primary pointer page: 617, Index root page: 618 
    Total formats: 1, used formats: 1 
    Average record length: 142.16, total records: 166490 
    Average version length: 152.60, total versions: 10295, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.93 
    Pointer pages: 6, data page slots: 4912 
    Data pages: 4152, average fill: 83% 
    Primary pages: 4148, secondary pages: 4, swept pages: 5 
    Empty pages: 64, full pages: 4077 
    Fill distribution: 
     0 - 19% = 64 
    20 - 39% = 8 
    40 - 59% = 1 
    60 - 79% = 2 
    80 - 99% = 4077 
 
PERF_SPLIT_5 (286) 
    Primary pointer page: 619, Index root page: 620 
    Total formats: 1, used formats: 1 
    Average record length: 133.13, total records: 185458 
    Average version length: 153.78, total versions: 23522, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 12.74 
    Pointer pages: 7, data page slots: 6008 
    Data pages: 4600, average fill: 85% 
    Primary pages: 4598, secondary pages: 2, swept pages: 10 
    Empty pages: 33, full pages: 4554 
    Fill distribution: 
     0 - 19% = 33 
    20 - 39% = 5 
    40 - 59% = 1 
    60 - 79% = 8 
    80 - 99% = 4553 
 
PERF_SPLIT_6 (287) 
    Primary pointer page: 621, Index root page: 622 
    Total formats: 1, used formats: 1 
    Average record length: 131.46, total records: 191362 
    Average version length: 153.66, total versions: 26597, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 12.90 
    Pointer pages: 5, data page slots: 5312 
    Data pages: 4784, average fill: 84% 
    Primary pages: 4782, secondary pages: 2, swept pages: 5 
    Empty pages: 60, full pages: 4690 
    Fill distribution: 
     0 - 19% = 62 
    20 - 39% = 8 
    40 - 59% = 7 
    60 - 79% = 17 
    80 - 99% = 4690 
 
PERF_SPLIT_7 (288) 
    Primary pointer page: 626, Index root page: 627 
    Total formats: 1, used formats: 1 
    Average record length: 145.14, total records: 162885 
    Average version length: 150.47, total versions: 6643, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.69 
    Pointer pages: 6, data page slots: 5984 
    Data pages: 4064, average fill: 83% 
    Primary pages: 4062, secondary pages: 2, swept pages: 6 
    Empty pages: 59, full pages: 3987 
    Fill distribution: 
     0 - 19% = 60 
    20 - 39% = 9 
    40 - 59% = 2 
    60 - 79% = 7 
    80 - 99% = 3986 
 
PERF_SPLIT_8 (289) 
    Primary pointer page: 628, Index root page: 629 
    Total formats: 1, used formats: 1 
    Average record length: 132.43, total records: 188032 
    Average version length: 153.73, total versions: 24606, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 12.81 
    Pointer pages: 6, data page slots: 7040 
    Data pages: 4736, average fill: 83% 
    Primary pages: 4734, secondary pages: 2, swept pages: 5 
    Empty pages: 100, full pages: 4607 
    Fill distribution: 
     0 - 19% = 102 
    20 - 39% = 8 
    40 - 59% = 7 
    60 - 79% = 14 
    80 - 99% = 4605 
 
PERF_SPLIT_9 (290) 
    Primary pointer page: 630, Index root page: 631 
    Total formats: 1, used formats: 1 
    Average record length: 135.85, total records: 156309 
    Average version length: 153.71, total versions: 16282, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 12.48 
    Pointer pages: 7, data page slots: 4584 
    Data pages: 3952, average fill: 83% 
    Primary pages: 3950, secondary pages: 2, swept pages: 2 
    Empty pages: 99, full pages: 3813 
    Fill distribution: 
     0 - 19% = 103 
    20 - 39% = 10 
    40 - 59% = 16 
    60 - 79% = 10 
    80 - 99% = 3813 
 
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.29, total records: 2119763 
    Average version length: 52.95, total versions: 22140, 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: 25920 
    Data pages: 25920, average fill: 70% 
    Primary pages: 25910, secondary pages: 10, swept pages: 11584 
    Empty pages: 115, full pages: 22670 
    Fill distribution: 
     0 - 19% = 246 
    20 - 39% = 237 
    40 - 59% = 797 
    60 - 79% = 24439 
    80 - 99% = 201 
 
    Index PSTORNED_RCV_ID (1) 
    Root page: 1506208, depth: 3, leaf buckets: 2616, nodes: 2119763 
    Average node length: 5.44, total dup: 1978052, max dup: 1416 
    Average key length: 2.49, compression ratio: 3.62 
    Average prefix length: 8.58, average data length: 0.42 
    Clustering factor: 184348, ratio: 0.09 
    Fill distribution: 
         0 - 19% = 5 
        20 - 39% = 303 
        40 - 59% = 1715 
        60 - 79% = 294 
        80 - 99% = 299 
 
    Index PSTORNED_SND_ID (0) 
    Root page: 1504841, depth: 3, leaf buckets: 2764, nodes: 2119763 
    Average node length: 5.69, total dup: 1902391, max dup: 69 
    Average key length: 2.74, compression ratio: 3.29 
    Average prefix length: 8.36, average data length: 0.64 
    Clustering factor: 379545, ratio: 0.18 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 3 
        40 - 59% = 2357 
        60 - 79% = 362 
        80 - 99% = 40 
 
    Index PSTORNED_WORKER_ID (2) 
    Root page: 1508018, depth: 3, leaf buckets: 2138, nodes: 2119763 
    Average node length: 4.96, total dup: 2119663, max dup: 28364 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.42, average data length: 0.00 
    Clustering factor: 181997, ratio: 0.09 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 199 
        40 - 59% = 1111 
        60 - 79% = 389 
        80 - 99% = 438 
 
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: 49.67, total records: 132449 
    Average version length: 69.20, total versions: 43007, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 2.54 
    Pointer pages: 3, data page slots: 3936 
    Data pages: 3128, average fill: 50% 
    Primary pages: 3128, secondary pages: 0, swept pages: 484 
    Empty pages: 400, full pages: 685 
    Fill distribution: 
     0 - 19% = 573 
    20 - 39% = 280 
    40 - 59% = 843 
    60 - 79% = 1180 
    80 - 99% = 252 
 
    Index XQD_1000_1200_WA_SO_RO_WKR_SND (0) 
    Root page: 316356, depth: 3, leaf buckets: 243, nodes: 132449 
    Average node length: 6.54, total dup: 115323, max dup: 14 
    Average key length: 3.96, compression ratio: 10.61 
    Average prefix length: 40.17, average data length: 1.83 
    Clustering factor: 23428, ratio: 0.18 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 94 
        40 - 59% = 123 
        60 - 79% = 24 
        80 - 99% = 0 
 
XQD_1000_3300 (178) 
    Primary pointer page: 581, Index root page: 582 
    Total formats: 1, used formats: 1 
    Average record length: 67.23, total records: 6757100 
    Average version length: 68.78, total versions: 195744, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.87 
    Pointer pages: 64, data page slots: 103432 
    Data pages: 103432, average fill: 70% 
    Primary pages: 103431, secondary pages: 1, swept pages: 56545 
    Empty pages: 27, full pages: 44468 
    Fill distribution: 
     0 - 19% = 99 
    20 - 39% = 428 
    40 - 59% = 7778 
    60 - 79% = 94682 
    80 - 99% = 445 
 
    Index XQD_1000_3300_WA_SO_RO_WKR_SND (0) 
    Root page: 1480476, depth: 3, leaf buckets: 10501, nodes: 6757100 
    Average node length: 6.51, total dup: 5845688, max dup: 29 
    Average key length: 3.52, compression ratio: 11.93 
    Average prefix length: 40.61, average data length: 1.39 
    Clustering factor: 1580503, ratio: 0.23 
    Fill distribution: 
         0 - 19% = 5 
        20 - 39% = 2018 
        40 - 59% = 5648 
        60 - 79% = 2348 
        80 - 99% = 482 
 
    Index XQD_1000_3300_WKR_DOC_ASC (1) 
    Root page: 1486090, depth: 3, leaf buckets: 8297, nodes: 6757100 
    Average node length: 5.40, total dup: 6483366, max dup: 174 
    Average key length: 2.41, compression ratio: 7.04 
    Average prefix length: 16.63, average data length: 0.37 
    Clustering factor: 1388618, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 8 
        20 - 39% = 1311 
        40 - 59% = 4588 
        60 - 79% = 1441 
        80 - 99% = 949 
 
    Index XQD_1000_3300_WKR_DOC_DEC (2) 
    Root page: 1490630, depth: 3, leaf buckets: 8395, nodes: 6757100 
    Average node length: 5.40, total dup: 6483366, max dup: 174 
    Average key length: 2.41, compression ratio: 7.04 
    Average prefix length: 16.63, average data length: 0.37 
    Clustering factor: 1390994, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 5 
        20 - 39% = 1394 
        40 - 59% = 4629 
        60 - 79% = 1446 
        80 - 99% = 921 
 
XQD_1200_2000 (177) 
    Primary pointer page: 579, Index root page: 580 
    Total formats: 1, used formats: 1 
    Average record length: 67.90, total records: 11669089 
    Average version length: 68.77, total versions: 205442, 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: 105, data page slots: 170728 
    Data pages: 170728, average fill: 73% 
    Primary pages: 170727, secondary pages: 1, swept pages: 91610 
    Empty pages: 2, full pages: 127418 
    Fill distribution: 
     0 - 19% = 30 
    20 - 39% = 356 
    40 - 59% = 5434 
    60 - 79% = 163728 
    80 - 99% = 1180 
 
    Index XQD_1200_2000_WA_SO_RO_WKR_SND (0) 
    Root page: 1495050, depth: 3, leaf buckets: 18250, nodes: 11667481 
    Average node length: 6.60, total dup: 10172927, max dup: 55 
    Average key length: 3.42, compression ratio: 12.26 
    Average prefix length: 40.70, average data length: 1.30 
    Clustering factor: 2422181, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 25 
        20 - 39% = 2800 
        40 - 59% = 10864 
        60 - 79% = 3762 
        80 - 99% = 799 
 
XQD_2000_3300 (179) 
    Primary pointer page: 583, Index root page: 584 
    Total formats: 1, used formats: 1 
    Average record length: 55.20, total records: 1442775 
    Average version length: 69.03, total versions: 201476, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 2.28 
    Pointer pages: 27, data page slots: 43088 
    Data pages: 29160, average fill: 52% 
    Primary pages: 29096, secondary pages: 64, swept pages: 11938 
    Empty pages: 3511, full pages: 15058 
    Fill distribution: 
     0 - 19% = 5917 
    20 - 39% = 3950 
    40 - 59% = 3452 
    60 - 79% = 13150 
    80 - 99% = 2691 
 
    Index XQD_2000_3300_WA_SO_RO_WKR_SND (0) 
    Root page: 1479735, depth: 3, leaf buckets: 1969, nodes: 1309617 
    Average node length: 5.53, total dup: 1256616, max dup: 49 
    Average key length: 2.57, compression ratio: 16.33 
    Average prefix length: 41.47, average data length: 0.53 
    Clustering factor: 95745, ratio: 0.07 
    Fill distribution: 
         0 - 19% = 6 
        20 - 39% = 728 
        40 - 59% = 905 
        60 - 79% = 313 
        80 - 99% = 17 
 
XQD_2100_3300 (180) 
    Primary pointer page: 585, Index root page: 586 
    Total formats: 1, used formats: 1 
    Average record length: 50.42, total records: 993361 
    Average version length: 69.06, total versions: 83913, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 2.50 
    Pointer pages: 18, data page slots: 27960 
    Data pages: 24696, average fill: 39% 
    Primary pages: 24696, secondary pages: 0, swept pages: 9374 
    Empty pages: 2391, full pages: 2002 
    Fill distribution: 
     0 - 19% = 5697 
    20 - 39% = 5814 
    40 - 59% = 8426 
    60 - 79% = 4723 
    80 - 99% = 36 
 
    Index XQD_2100_3300_WA_SO_RO_WKR_SND (0) 
    Root page: 1479229, depth: 3, leaf buckets: 1176, nodes: 769345 
    Average node length: 5.92, total dup: 710244, max dup: 53 
    Average key length: 2.99, compression ratio: 14.07 
    Average prefix length: 41.09, average data length: 0.91 
    Clustering factor: 108748, ratio: 0.14 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 359 
        40 - 59% = 566 
        60 - 79% = 236 
        80 - 99% = 15 
 
XQD_3300_3400 (181) 
    Primary pointer page: 587, Index root page: 588 
    Total formats: 1, used formats: 1 
    Average record length: 67.24, total records: 9203114 
    Average version length: 68.96, total versions: 249681, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.87 
    Pointer pages: 90, data page slots: 145696 
    Data pages: 145688, average fill: 67% 
    Primary pages: 145671, secondary pages: 17, swept pages: 71759 
    Empty pages: 460, full pages: 70373 
    Fill distribution: 
     0 - 19% = 1253 
    20 - 39% = 5082 
    40 - 59% = 20220 
    60 - 79% = 117591 
    80 - 99% = 1542 
 
    Index XQD_3300_3400_WA_SO_RO_WKR_SND (0) 
    Root page: 1472612, depth: 3, leaf buckets: 13491, nodes: 9198984 
    Average node length: 6.69, total dup: 7629322, max dup: 14 
    Average key length: 3.67, compression ratio: 11.45 
    Average prefix length: 40.50, average data length: 1.50 
    Clustering factor: 2091491, ratio: 0.23 
    Fill distribution: 
         0 - 19% = 5 
        20 - 39% = 1333 
        40 - 59% = 6778 
        60 - 79% = 4672 
        80 - 99% = 703 
 
XQS_1000_1200 (182) 
    Primary pointer page: 589, Index root page: 590 
    Total formats: 1, used formats: 1 
    Average record length: 82.51, total records: 21204546 
    Average version length: 82.97, total versions: 8083, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.53 
    Pointer pages: 197, data page slots: 320712 
    Data pages: 320712, average fill: 81% 
    Primary pages: 320707, secondary pages: 5, swept pages: 14063 
    Empty pages: 28, full pages: 319967 
    Fill distribution: 
     0 - 19% = 44 
    20 - 39% = 39 
    40 - 59% = 103 
    60 - 79% = 50674 
    80 - 99% = 269852 
 
    Index XQS_1000_1200_DOC_ID (1) 
    Root page: 1426738, depth: 3, leaf buckets: 19284, nodes: 21204546 
    Average node length: 5.72, total dup: 20722263, max dup: 128 
    Average key length: 2.16, compression ratio: 4.16 
    Average prefix length: 8.86, average data length: 0.14 
    Clustering factor: 3292354, ratio: 0.16 
    Fill distribution: 
         0 - 19% = 5 
        20 - 39% = 1 
        40 - 59% = 7829 
        60 - 79% = 581 
        80 - 99% = 10868 
 
    Index XQS_1000_1200_RCV_ID (3) 
    Root page: 1457002, depth: 3, leaf buckets: 17233, nodes: 21204546 
    Average node length: 6.31, total dup: 18634816, max dup: 49 
    Average key length: 2.75, compression ratio: 3.27 
    Average prefix length: 8.37, average data length: 0.63 
    Clustering factor: 920605, ratio: 0.04 
    Fill distribution: 
         0 - 19% = 3 
        20 - 39% = 1 
        40 - 59% = 793 
        60 - 79% = 283 
        80 - 99% = 16153 
 
    Index XQS_1000_1200_SND_ID (2) 
    Root page: 1441095, depth: 3, leaf buckets: 21080, nodes: 21204546 
    Average node length: 6.35, total dup: 18553265, max dup: 27 
    Average key length: 2.79, compression ratio: 3.23 
    Average prefix length: 8.34, average data length: 0.66 
    Clustering factor: 3587016, ratio: 0.17 
    Fill distribution: 
         0 - 19% = 4 
        20 - 39% = 0 
        40 - 59% = 8089 
        60 - 79% = 674 
        80 - 99% = 12313 
 
    Index XQS_1000_1200_WORKER_ID (0) 
    Root page: 1413370, depth: 3, leaf buckets: 16220, nodes: 21204546 
    Average node length: 5.56, total dup: 21204446, max dup: 232525 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.42, average data length: 0.00 
    Clustering factor: 949572, ratio: 0.04 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 8 
        40 - 59% = 3069 
        60 - 79% = 353 
        80 - 99% = 12790 
 
XQS_1000_3300 (184) 
    Primary pointer page: 593, Index root page: 594 
    Total formats: 1, used formats: 1 
    Average record length: 78.90, total records: 9879586 
    Average version length: 82.58, total versions: 473741, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.60 
    Pointer pages: 106, data page slots: 171960 
    Data pages: 171936, average fill: 71% 
    Primary pages: 171913, secondary pages: 23, swept pages: 78387 
    Empty pages: 359, full pages: 106925 
    Fill distribution: 
     0 - 19% = 1155 
    20 - 39% = 4643 
    40 - 59% = 20194 
    60 - 79% = 121233 
    80 - 99% = 24711 
 
    Index XQS_1000_3300_DOC_ID (1) 
    Root page: 1367524, depth: 3, leaf buckets: 11379, nodes: 9879586 
    Average node length: 5.37, total dup: 9567687, max dup: 201 
    Average key length: 2.23, compression ratio: 4.04 
    Average prefix length: 8.80, average data length: 0.20 
    Clustering factor: 2245599, ratio: 0.23 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 49 
        40 - 59% = 7593 
        60 - 79% = 3609 
        80 - 99% = 126 
 
    Index XQS_1000_3300_RCV_ID (3) 
    Root page: 1379283, depth: 3, leaf buckets: 13665, nodes: 9879586 
    Average node length: 6.24, total dup: 8191272, max dup: 14 
    Average key length: 3.10, compression ratio: 2.90 
    Average prefix length: 8.07, average data length: 0.93 
    Clustering factor: 1579879, ratio: 0.16 
    Fill distribution: 
         0 - 19% = 147 
        20 - 39% = 3797 
        40 - 59% = 4615 
        60 - 79% = 2502 
        80 - 99% = 2604 
 
    Index XQS_1000_3300_SND_ID (2) 
    Root page: 1373081, depth: 3, leaf buckets: 12696, nodes: 9879586 
    Average node length: 5.98, total dup: 8577464, max dup: 44 
    Average key length: 2.85, compression ratio: 3.16 
    Average prefix length: 8.29, average data length: 0.71 
    Clustering factor: 2436341, ratio: 0.25 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 55 
        40 - 59% = 8546 
        60 - 79% = 3930 
        80 - 99% = 163 
 
    Index XQS_1000_3300_WORKER_ID (0) 
    Root page: 1362789, depth: 3, leaf buckets: 10406, nodes: 9879586 
    Average node length: 5.14, total dup: 9879486, max dup: 165422 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.42, average data length: 0.00 
    Clustering factor: 1600260, ratio: 0.16 
    Fill distribution: 
         0 - 19% = 50 
        20 - 39% = 1285 
        40 - 59% = 5301 
        60 - 79% = 1719 
        80 - 99% = 2051 
 
XQS_1200_2000 (183) 
    Primary pointer page: 591, Index root page: 592 
    Total formats: 1, used formats: 1 
    Average record length: 81.17, total records: 11497073 
    Average version length: 82.61, total versions: 179254, 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: 120, data page slots: 194256 
    Data pages: 192760, average fill: 73% 
    Primary pages: 192672, secondary pages: 88, swept pages: 67646 
    Empty pages: 2257, full pages: 152648 
    Fill distribution: 
     0 - 19% = 3816 
    20 - 39% = 5688 
    40 - 59% = 14711 
    60 - 79% = 104857 
    80 - 99% = 63688 
 
    Index XQS_1200_2000_DOC_ID (1) 
    Root page: 1392123, depth: 3, leaf buckets: 13150, nodes: 11497073 
    Average node length: 5.32, total dup: 11386569, max dup: 635 
    Average key length: 2.08, compression ratio: 4.33 
    Average prefix length: 8.93, average data length: 0.07 
    Clustering factor: 2420018, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 68 
        40 - 59% = 8684 
        60 - 79% = 4163 
        80 - 99% = 234 
 
    Index XQS_1200_2000_RCV_ID (3) 
    Root page: 1406132, depth: 3, leaf buckets: 10637, nodes: 11497073 
    Average node length: 5.52, total dup: 10996954, max dup: 49 
    Average key length: 2.28, compression ratio: 3.96 
    Average prefix length: 8.77, average data length: 0.23 
    Clustering factor: 752470, ratio: 0.07 
    Fill distribution: 
         0 - 19% = 144 
        20 - 39% = 894 
        40 - 59% = 2594 
        60 - 79% = 1811 
        80 - 99% = 5194 
 
    Index XQS_1200_2000_SND_ID (2) 
    Root page: 1398660, depth: 3, leaf buckets: 15038, nodes: 11497073 
    Average node length: 6.05, total dup: 10033217, max dup: 59 
    Average key length: 2.80, compression ratio: 3.21 
    Average prefix length: 8.32, average data length: 0.68 
    Clustering factor: 2436347, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 3 
        20 - 39% = 86 
        40 - 59% = 10093 
        60 - 79% = 4579 
        80 - 99% = 277 
 
    Index XQS_1200_2000_WORKER_ID (0) 
    Root page: 1386233, depth: 3, leaf buckets: 11034, nodes: 11497073 
    Average node length: 5.24, total dup: 11496973, max dup: 208003 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.42, average data length: 0.00 
    Clustering factor: 739930, ratio: 0.06 
    Fill distribution: 
         0 - 19% = 101 
        20 - 39% = 809 
        40 - 59% = 5012 
        60 - 79% = 1539 
        80 - 99% = 3573 
 
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: 77.39, total records: 10269665 
    Average version length: 82.92, total versions: 745419, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.63 
    Pointer pages: 108, data page slots: 176064 
    Data pages: 176040, average fill: 73% 
    Primary pages: 176017, secondary pages: 23, swept pages: 44322 
    Empty pages: 432, full pages: 130936 
    Fill distribution: 
     0 - 19% = 1224 
    20 - 39% = 4742 
    40 - 59% = 18226 
    60 - 79% = 117251 
    80 - 99% = 34597 
 
    Index XQS_2100_3300_DOC_ID (1) 
    Root page: 1344708, depth: 3, leaf buckets: 12228, nodes: 10269665 
    Average node length: 5.18, total dup: 10240309, max dup: 2058 
    Average key length: 2.03, compression ratio: 4.43 
    Average prefix length: 8.97, average data length: 0.03 
    Clustering factor: 2104505, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 32 
        20 - 39% = 1307 
        40 - 59% = 8214 
        60 - 79% = 2022 
        80 - 99% = 653 
 
    Index XQS_2100_3300_RCV_ID (3) 
    Root page: 1355739, depth: 3, leaf buckets: 13869, nodes: 10269665 
    Average node length: 6.25, total dup: 8515041, max dup: 14 
    Average key length: 3.10, compression ratio: 2.90 
    Average prefix length: 8.07, average data length: 0.93 
    Clustering factor: 1590910, ratio: 0.15 
    Fill distribution: 
         0 - 19% = 196 
        20 - 39% = 3488 
        40 - 59% = 4624 
        60 - 79% = 2574 
        80 - 99% = 2987 
 
    Index XQS_2100_3300_SND_ID (2) 
    Root page: 1350071, depth: 3, leaf buckets: 12852, nodes: 10269665 
    Average node length: 5.43, total dup: 9817105, max dup: 99 
    Average key length: 2.28, compression ratio: 3.94 
    Average prefix length: 8.76, average data length: 0.24 
    Clustering factor: 2244746, ratio: 0.22 
    Fill distribution: 
         0 - 19% = 20 
        20 - 39% = 1217 
        40 - 59% = 9173 
        60 - 79% = 1787 
        80 - 99% = 655 
 
    Index XQS_2100_3300_WORKER_ID (0) 
    Root page: 987843, depth: 3, leaf buckets: 10660, nodes: 10269665 
    Average node length: 5.15, total dup: 10269565, max dup: 167346 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.42, average data length: 0.00 
    Clustering factor: 1670285, ratio: 0.16 
    Fill distribution: 
         0 - 19% = 35 
        20 - 39% = 1134 
        40 - 59% = 5483 
        60 - 79% = 1773 
        80 - 99% = 2235 
 
XQS_3300_3400 (187) 
    Primary pointer page: 599, Index root page: 600 
    Total formats: 1, used formats: 1 
    Average record length: 67.09, total records: 585695 
    Average version length: 68.76, total versions: 10752, 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: 5, data page slots: 8088 
    Data pages: 8088, average fill: 76% 
    Primary pages: 8088, secondary pages: 0, swept pages: 2386 
    Empty pages: 0, full pages: 8057 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 1 
    40 - 59% = 2 
    60 - 79% = 7879 
    80 - 99% = 206 
 
    Index XQS_3300_3400_DOC_ID (1) 
    Root page: 50057, depth: 3, leaf buckets: 733, nodes: 585695 
    Average node length: 5.95, total dup: 498490, max dup: 82 
    Average key length: 3.09, compression ratio: 2.91 
    Average prefix length: 8.06, average data length: 0.94 
    Clustering factor: 103543, ratio: 0.18 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 22 
        40 - 59% = 495 
        60 - 79% = 113 
        80 - 99% = 103 
 
    Index XQS_3300_3400_SND_ID (2) 
    Root page: 41584, depth: 3, leaf buckets: 758, nodes: 585695 
    Average node length: 6.15, total dup: 480471, max dup: 25 
    Average key length: 3.29, compression ratio: 2.73 
    Average prefix length: 7.89, average data length: 1.11 
    Clustering factor: 103603, ratio: 0.18 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 26 
        40 - 59% = 517 
        60 - 79% = 105 
        80 - 99% = 110 
 
    Index XQS_3300_3400_WORKER_ID (0) 
    Root page: 377587, depth: 2, leaf buckets: 571, nodes: 585695 
    Average node length: 4.86, total dup: 585595, max dup: 9323 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.42, average data length: 0.00 
    Clustering factor: 91974, ratio: 0.16 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 31 
        40 - 59% = 319 
        60 - 79% = 85 
        80 - 99% = 136 
 
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 Sat Mar 23 13:10:32 2024

Record versions statistics, table

TABLE_NAME TOTAL_RECS TOTAL_VERS MAX_VERSIONS VERS_TO_RECS_PRC MAXV_TO_VERS_PRC
DOC_DATA 7784304 49901 1 0.0000 0.0000
DOC_LIST 2264837 24544 2 0.0000 0.0000
FB_ERRORS 2182 757 1 0.0000 0.0000
INVNT_SALDO 400 1487 4 300.0000 0.0000
INVNT_TURNOVER_LOG 90563 81650 1 0.0000 0.0000
MONEY_SALDO 49 143 5 200.0000 0.0000
MONEY_TURNOVER_LOG 1635 1471 1 0.0000 0.0000
PDISTR 773845 21629 2 0.0000 0.0000
PERF_SPLIT_0 158194 7054 1 0.0000 0.0000
PERF_SPLIT_1 131697 6839 1 0.0000 0.0000
PERF_SPLIT_2 152712 10081 1 0.0000 0.0000
PERF_SPLIT_3 175381 24804 1 0.0000 0.0000
PERF_SPLIT_4 166490 10295 1 0.0000 0.0000
PERF_SPLIT_5 185458 23522 1 0.0000 0.0000
PERF_SPLIT_6 191362 26597 1 0.0000 0.0000
PERF_SPLIT_7 162885 6643 1 0.0000 0.0000
PERF_SPLIT_8 188032 24606 1 0.0000 0.0000
PERF_SPLIT_9 156309 16282 1 0.0000 0.0000
PSTORNED 2119763 22140 1 0.0000 0.0000
SEMAPHORES 5 1 1 0.0000 100.0000
XQD_1000_1200 132449 43007 1 0.0000 0.0000
XQD_1000_3300 6757100 195744 1 0.0000 0.0000
XQD_1200_2000 11669089 205442 1 0.0000 0.0000
XQD_2000_3300 1442775 201476 1 0.0000 0.0000
XQD_2100_3300 993361 83913 1 0.0000 0.0000
XQD_3300_3400 9203114 249681 1 0.0000 0.0000
XQS_1000_1200 21204546 8083 1 0.0000 0.0000
XQS_1000_3300 9879586 473741 1 0.0000 0.0000
XQS_1200_2000 11497073 179254 1 0.0000 0.0000
XQS_2100_3300 10269665 745419 1 0.0000 0.0000
XQS_3300_3400 585695 10752 1 0.0000 0.0000

Record versions statistics, chart

Total records and versions, chart

Ratios versions / total_records and max_versions / total_versions

Database validation 


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

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

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

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

23.03.24 13:10:44. 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-23 13:10:47 No severe PSQL-related problems occured
23.03.24 13:10:48. End of report.