Generated by /opt/oltp-emul/oltp_isql_run_worker.sh, ISQL session No. 1 of total launched 100. 03.03.2024 19:10
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 15761352 kB
MemAvailable 30257276 kB
Buffers 0 kB
Cached 15996820 kB
SwapCached 2188 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 3.0.12
DB_NAME                         /home/bases/oltp30-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/oltp30-etalone.fdb
param=detailed_info, val=0
param=etalon_dbnm, val=/home/bases/oltp30-etalone.fd0
param=expected_workers, val=100
param=fbc, val=/opt/fb30/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=3333
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/oltp30-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-oltp30
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-03 19:09:41
DTS_END                         2024-03-03 19:09:41.3760
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(57:17)
IP                              ::1/48092
TRN_ID                          176836
ATT_ID                          561
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: 9250.80 19564 925080
customer order: creation 177.25 368 17725
customer order: refuse 15.54 353 1554
order to supplier: creation 47.45 1139 4745
order to supplier: removal 3.64 98408 364
invoice (draft): creation 47.21 3250 4721
invoice (draft): removal 49.27 738 4927
invoice accept: apply 43.43 22340 4343
invoice accept: cancel 44.57 982 4457
customer reserve: creation 4150.11 215 415011
customer reserve: removal 4361.70 65 436170
realization accept: apply 87.77 190 8777
realization accept: cancel 87.92 128 8792
payment from customer: creation 62.37 132 6237
payment from customer: removal 5.91 76 591
payment to supplier: creation 50.37 163 5037
payment to supplier: removal 3.79 83 379
service: total inventory turnovers 5.08 1117 508
service: total monetary turnovers 6.57 29 657
service: aggregate perf. data 0.82 23407 82
service: refresh index statistics 0.03 238098 3

Performance in TOTAL, chart


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

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 2223
TEST_TIME 2 5281
TEST_TIME 3 5350
TEST_TIME 4 5213
TEST_TIME 5 5104
TEST_TIME 6 4982
TEST_TIME 7 5421
TEST_TIME 8 5610
TEST_TIME 9 5898
TEST_TIME 10 5722
TEST_TIME 11 5817
TEST_TIME 12 5962
TEST_TIME 13 6105
TEST_TIME 14 6259
TEST_TIME 15 6548
TEST_TIME 16 6579
TEST_TIME 17 6793
TEST_TIME 18 7235
TEST_TIME 19 7383
TEST_TIME 20 7503
TEST_TIME 21 7920
TEST_TIME 22 8038
TEST_TIME 23 8075
TEST_TIME 24 8418
TEST_TIME 25 8302
TEST_TIME 26 8478
TEST_TIME 27 8680
TEST_TIME 28 9222
TEST_TIME 29 9762
TEST_TIME 30 9596
TEST_TIME 31 9692
TEST_TIME 32 9490
TEST_TIME 33 9521
TEST_TIME 34 9470
TEST_TIME 35 9831
TEST_TIME 36 9608
TEST_TIME 37 9434
TEST_TIME 38 9365
TEST_TIME 39 9244
TEST_TIME 40 9209
TEST_TIME 41 9205
TEST_TIME 42 9252
TEST_TIME 43 9388
TEST_TIME 44 9409
TEST_TIME 45 9326
TEST_TIME 46 9221
TEST_TIME 47 9093
TEST_TIME 48 9096
TEST_TIME 49 9110
TEST_TIME 50 9291
TEST_TIME 51 9312
TEST_TIME 52 9293
TEST_TIME 53 9314
TEST_TIME 54 9330
TEST_TIME 55 9452
TEST_TIME 56 9408
TEST_TIME 57 9448
TEST_TIME 58 9427
TEST_TIME 59 9434
TEST_TIME 60 9523
TEST_TIME 61 9482
TEST_TIME 62 9511
TEST_TIME 63 9579
TEST_TIME 64 9455
TEST_TIME 65 9376
TEST_TIME 66 9427
TEST_TIME 67 9345
TEST_TIME 68 9330
TEST_TIME 69 9302
TEST_TIME 70 9237
TEST_TIME 71 9227
TEST_TIME 72 9192
TEST_TIME 73 9144
TEST_TIME 74 9167
TEST_TIME 75 9179
TEST_TIME 76 9166
TEST_TIME 77 9204
TEST_TIME 78 9205
TEST_TIME 79 9352
TEST_TIME 80 9348
TEST_TIME 81 9371
TEST_TIME 82 9399
TEST_TIME 83 9426
TEST_TIME 84 9472
TEST_TIME 85 9476
TEST_TIME 86 9502
TEST_TIME 87 9501
TEST_TIME 88 9411
TEST_TIME 89 9372
TEST_TIME 90 9349
TEST_TIME 91 9320
TEST_TIME 92 9329
TEST_TIME 93 9281
TEST_TIME 94 9300
TEST_TIME 95 9275
TEST_TIME 96 9275
TEST_TIME 97 9271
TEST_TIME 98 9258
TEST_TIME 99 9221
TEST_TIME 100 9254

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:03, from 03-03-2024 19:11:10 to 03-03-2024 19:11:13.

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 1305150 1305150 0 0.00 0 35396 8 0 0
doc_list_biud 1305149 1305149 0 0.00 0 57797 27 0 0
sp_add_invoice_to_stock 4508 4343 165 3.66 38 205835 22340 0 165
sp_cancel_adding_invoice 4457 4457 0 0.00 5 64349 982 0 0
sp_cancel_client_order 1554 1554 0 0.00 4 18669 353 0 0
sp_cancel_customer_reserve 436170 436170 0 0.00 1 57800 66 0 0
sp_cancel_pay_from_customer 591 591 0 0.00 3 3343 76 0 0
sp_cancel_pay_to_supplier 379 379 0 0.00 3 5861 83 0 0
sp_cancel_supplier_invoice 4939 4927 12 0.24 2 16852 739 0 12
sp_cancel_supplier_order 364 364 0 0.00 9 985049 98408 0 0
sp_cancel_write_off 8792 8792 0 0.00 1 10645 129 0 0
sp_client_order 17725 17725 0 0.00 3 48202 368 0 0
sp_customer_reserve 415011 415011 0 0.00 0 81652 216 0 0
sp_fill_shopping_cart 27184 27184 0 0.00 1 14102 34 0 0
sp_fill_shopping_cart_clo_res 415003 415003 0 0.00 0 18005 15 0 0
sp_get_clo_for_invoice 4335 4335 0 0.00 0 44787 314 0 0
sp_kill_cost_storno 14219 14219 0 0.00 0 9254 67 0 0
sp_kill_qstorno_ret_qs2qd 886423 886423 0 0.00 0 57790 35 0 0
sp_kill_qty_storno 469375 469375 0 0.00 0 57797 76 0 0
sp_lock_selected_doc 18165 18165 0 0.00 0 7550 4 0 0
sp_make_cost_storno 24386 24386 0 0.00 0 35389 68 0 0
sp_multiply_rows_for_pdistr 24386 24386 0 0.00 0 8056 34 0 0
sp_multiply_rows_for_qdistr 17725 17725 0 0.00 0 48191 170 0 0
sp_pay_from_customer 6237 6237 0 0.00 4 23145 133 0 0
sp_pay_to_supplier 5037 5037 0 0.00 5 15099 164 0 0
sp_payment_common 11274 11274 0 0.00 2 23136 38 0 0
sp_qd_handle_on_cancel_clo 1554 1554 0 0.00 0 18661 324 0 0
sp_qd_handle_on_invoice_upd_sts 8792 8792 0 0.00 0 15466 363 0 0
sp_qd_handle_on_reserve_upd_sts 8776 8776 0 0.00 0 14315 62 0 0
sp_reserve_write_off 8777 8777 0 0.00 6 20677 191 0 0
sp_supplier_invoice 4721 4721 0 0.00 6 88795 3251 0 0
sp_supplier_order 4745 4745 0 0.00 5 24767 1140 0 0
srv_aggregate_perf_data 82 82 0 0.00 1414 214324 23407 0 0
srv_fill_mon_cache_memory 56 56 0 0.00 1182 126215 37842 0 0
srv_find_qd_qs_mism 881144 881144 0 0.00 0 16027 7 0 0
srv_make_invnt_saldo 508 508 0 0.00 41 46198 1118 0 0
srv_make_money_saldo 657 657 0 0.00 1 785 30 0 0
srv_recalc_idx_stat 3 3 0 0.00 136087 369768 238099 0 0
t$perf-abend:sp_add_invoice_to_stock 165 165 0 0.00 0 0 0 0 0
t$perf-abend:sp_cancel_supplier_invoice 12 12 0 0.00 0 0 0 0 0
t$perf-norm:sp_add_invoice_to_stock 4343 4343 0 0.00 0 8256 181 0 0
t$perf-norm:sp_cancel_adding_invoice 359 359 0 0.00 0 3097 95 0 0
t$perf-norm:sp_cancel_client_order 1554 1554 0 0.00 0 2027 15 0 0
t$perf-norm:sp_cancel_customer_reserve 601 601 0 0.00 0 4232 27 0 0
t$perf-norm:sp_cancel_pay_from_customer 591 591 0 0.00 0 868 9 0 0
t$perf-norm:sp_cancel_pay_to_supplier 379 379 0 0.00 0 950 4 0 0
t$perf-norm:sp_cancel_supplier_invoice 373 373 0 0.00 0 2373 24 0 0
t$perf-norm:sp_cancel_supplier_order 364 364 0 0.00 0 37891 1695 0 0
t$perf-norm:sp_cancel_write_off 836 836 0 0.00 0 901 7 0 0
t$perf-norm:sp_client_order 17725 17725 0 0.00 0 5426 17 0 0
t$perf-norm:sp_customer_reserve 896 896 0 0.00 0 1045 7 0 0
t$perf-norm:sp_pay_from_customer 6237 6237 0 0.00 0 5277 8 0 0
t$perf-norm:sp_pay_to_supplier 5037 5037 0 0.00 0 4305 11 0 0
t$perf-norm:sp_reserve_write_off 8777 8777 0 0.00 0 6463 13 0 0
t$perf-norm:sp_supplier_invoice 4721 4721 0 0.00 0 9796 20 0 0
t$perf-norm:sp_supplier_order 4745 4745 0 0.00 0 12511 22 0 0
t$perf-norm:srv_aggregate_perf_data 82 82 0 0.00 0 350 12 0 0
t$perf-norm:srv_fill_mon_cache_memory 56 56 0 0.00 0 1166 22 0 0
t$perf-norm:srv_make_invnt_saldo 508 508 0 0.00 0 1523 31 0 0
t$perf-norm:srv_make_money_saldo 657 657 0 0.00 0 779 21 0 0
t$perf-norm:srv_recalc_idx_stat 3 3 0 0.00 1 18 7 0 0
v_add_invoice_to_stock 8994 8664 330 3.66 0 6846 21 0 330
v_all_customers 32956 32956 0 0.00 0 17 1 0 0
v_all_suppliers 26716 26716 0 0.00 0 22 1 0 0
v_all_wares 35450 35450 0 0.00 0 22 1 0 0
v_cancel_adding_invoice 718 718 0 0.00 0 2616 16 0 0
v_cancel_client_order 3108 3108 0 0.00 0 1299 7 0 0
v_cancel_customer_prepayment 1182 1182 0 0.00 0 3108 9 0 0
v_cancel_customer_reserve 1202 1202 0 0.00 0 1609 7 0 0
v_cancel_payment_to_supplier 758 758 0 0.00 0 5324 13 0 0
v_cancel_supplier_invoice 770 746 24 3.11 0 338 14 0 24
v_cancel_supplier_order 728 728 0 0.00 0 1147 5 0 0
v_cancel_write_off 1672 1672 0 0.00 0 1203 14 0 0
v_max_id_clo_ord 4744 4744 0 0.00 0 3373 2 0 0
v_max_id_clo_res 896 896 0 0.00 0 1793 15 0 0
v_max_id_ord_sup 4715 4715 0 0.00 0 5011 4 0 0
v_max_non_paid_invoice 1138 1138 0 0.00 0 3096 6 0 0
v_max_non_paid_realizn 3007 3007 0 0.00 0 2167 4 0 0
v_min_id_clo_ord 4744 4744 0 0.00 0 2247 5 0 0
v_min_id_clo_res 896 896 0 0.00 0 2552 7 0 0
v_min_id_ord_sup 4715 4715 0 0.00 0 3998 3 0 0
v_min_non_paid_invoice 5037 5037 0 0.00 0 14697 31 0 0
v_min_non_paid_realizn 6237 6237 0 0.00 0 23130 30 0 0
v_our_firm 8954 8954 0 0.00 0 19 1 0 0
v_reserve_write_off 17552 17552 0 0.00 0 4852 6 0 0
x_lock_depdocs_on_canc_invoice 9011 9011 0 0.00 0 18569 160 0 0
x_lock_depdocs_on_canc_sup_ord 364 364 0 0.00 0 6940 326 0 0
x_make_qstorno_1000_1200 4745 4745 0 0.00 2 24678 1056 0 0
x_make_qstorno_1200_2000 4721 4721 0 0.00 2 88786 3139 0 0
x_make_qstorno_2100_3300 415011 415011 0 0.00 0 81646 197 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 03-03-2024 19:11:14 to 03-03-2024 19:11:18.

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
17:09:44 3 8192000000 8802422240 8814759936 7934208 0.096 2 2 3 0 8075296 66144 74944
17:10:45 33447 8192000000 9911918816 10226483200 995417072 10.834 100 91 182 0 1024784224 5690864 23676288
17:12:24 20622 8192000000 9958056640 10281336832 1037486112 11.240 100 91 183 0 1069703056 8231136 23985808
17:13:48 14920 8192000000 9980741008 10312806400 1063113696 11.486 100 82 164 0 1093313104 9237568 20961840
17:15:10 10901 8192000000 10027736176 10377953280 1116916096 11.998 100 71 142 0 1144505280 10155424 17433760
17:16:25 7996 8192000000 10085016720 10441289728 1169947984 12.496 100 86 172 1 1202491776 12794864 19748928
17:17:38 3335 8192000000 10116079408 10483449856 1202945088 12.804 100 81 162 1 1234434752 12828064 18661600
17:18:44 2298 8192000000 10152269568 10526711808 1241705056 13.162 100 81 161 0 1272663904 12743296 18215552
17:19:48 2578 8192000000 10184460288 10567368704 1271094448 13.432 100 77 154 0 1300945312 13084688 16766176
17:20:51 1168 8192000000 10215612016 10597715968 1299835120 13.694 100 92 183 2 1333040464 13242352 19962992
17:21:53 1281 8192000000 10212108240 10603094016 1305385552 13.744 100 66 130 0 1328576464 8022416 15168496
17:22:55 8269 8192000000 10209319984 10610176000 1308398608 13.772 100 21 42 0 1319290544 5641840 5250096
17:24:05 13561 8192000000 10209956512 10623791104 1324318752 13.916 100 38 77 0 1339436768 6007920 9110096
17:25:19 2394 8192000000 10224270720 10635784192 1325134368 13.923 100 53 107 1 1343920848 5837536 12948944
17:26:22 3276 8192000000 10224417088 10640691200 1333162704 13.996 100 35 70 1 1348632336 7703600 7766032
17:27:26 10336 8192000000 10224562928 10649939968 1340413888 14.061 100 20 40 0 1350506928 5947120 4145920
17:28:46 45928 8192000000 10228681104 10646724608 1303995904 13.732 97 26 53 0 1316079392 5906768 6176720
17:30:43 21099 8192000000 10250150512 10666315776 1349452944 14.143 100 56 114 0 1371930016 9854016 12623056
17:32:07 13401 8192000000 10239740064 10658340864 1333516960 13.999 99 44 87 0 1351636624 8742960 9376704
17:33:25 3118 8192000000 10251497872 10655838208 1322369472 13.898 98 56 111 0 1346866656 11902240 12594944
17:34:33 24432 8192000000 10251284576 10658435072 1341499424 14.071 100 43 86 2 1365108576 13075600 10533552
17:36:01 16880 8192000000 10251262304 10659586048 1323626752 13.910 99 48 96 0 1355973664 21501664 10845248
17:37:25 11649 8192000000 10252221520 10657382400 1326304336 13.934 99 57 113 0 1358299824 18843520 13151968
17:38:41 22313 8192000000 10252407840 10658238464 1295082608 13.651 96 55 108 1 1324217296 16427072 12707616
17:40:13 8067 8192000000 10253108272 10655891456 1320122432 13.878 98 53 105 1 1350523184 18019168 12381584
17:41:24 7949 8192000000 10266953632 10667106304 1335787232 14.019 100 59 117 0 1373591744 23880672 13923840
17:42:38 15232 8192000000 10249346272 10646601728 1318950928 13.867 99 52 103 1 1354050480 23096032 12003520
17:44:03 4728 8192000000 10258657744 10653847552 1324460864 13.917 100 71 141 1 1366623440 25523232 16639344
17:45:21 1781 8192000000 10291569344 10690924544 1351626544 14.162 100 69 135 0 1395504752 27863776 16014432
17:46:29 3479 8192000000 10319722464 10724352000 1372948864 14.353 100 72 143 0 1425079904 33982896 18148144
17:47:38 1512 8192000000 10329925296 10738761728 1381734112 14.432 100 83 165 1 1438470112 35786576 20949424
17:48:43 1182 8192000000 10338560912 10742222848 1386669248 14.476 100 92 184 0 1440692896 32512016 21511632
17:49:47 2494 8192000000 10356640128 10761056256 1396905312 14.567 100 89 172 1 1456460928 37531536 22024080
17:50:57 8882 8192000000 10339374432 10762698752 1397133552 14.569 100 54 109 0 1448526176 37301040 14091584
17:52:12 2811 8192000000 10360377520 10780397568 1411520752 14.697 100 76 149 3 1465713552 36365712 17827088
17:53:20 13361 8192000000 10355688784 10787639296 1417629120 14.752 100 49 94 1 1468685552 39350576 11705856
17:54:44 12395 8192000000 10345221744 10783334400 1408996304 14.675 100 40 76 1 1458219456 38959904 10263248
17:57:00 23090 8192000000 10318648304 10776424448 1376711888 14.387 99 16 32 0 1431537856 50140464 4685504
17:58:25 24018 8192000000 10296974688 10762448896 1390022208 14.506 100 13 26 0 1415927728 22962320 2943200
18:00:34 63610 8192000000 10327146896 10768707584 1395531264 14.555 100 21 43 0 1411347920 11612768 4203888
18:02:39 36540 8192000000 10316817904 10764992512 1387288432 14.482 99 27 55 0 1409647392 16516528 5842432
18:04:23 84902 8192000000 10309534912 10763280384 1398791296 14.584 100 22 44 1 1424831840 20773216 5267328
18:06:49 53326 8192000000 10333111104 10782892032 1406346016 14.651 100 28 56 0 1427696480 15481424 5869040
18:08:48 55832 8192000000 10313861008 10748977152 1360931824 14.246 96 36 72 1 1380543312 11892112 7719376
18:10:45 31333 8192000000 10305983488 10757267456 1376624032 14.386 98 36 71 1 1397699568 13391120 7684416
18:12:23 30185 8192000000 10301440640 10755796992 1378089104 14.399 98 20 40 0 1391721376 9205536 4426736
18:13:57 22787 8192000000 10311393744 10775416832 1405718816 14.646 100 10 20 0 1418562368 10527744 2315808
18:15:21 70221 8192000000 10294967056 10745462784 1348311616 14.132 96 20 38 0 1363669328 10625696 4732016
18:17:34 126202 8192000000 10283387904 10740785152 1318636576 13.864 95 23 46 0 1337414688 13300256 5477856
18:20:41 68279 8192000000 10300434832 10746855424 1354995616 14.192 98 23 46 0 1376579264 15722928 5860720
18:22:53 32593 8192000000 10292787584 10741604352 1362999408 14.264 99 31 63 1 1383200784 13462448 6738928
18:24:34 62725 8192000000 10286641040 10731114496 1342494816 14.080 97 25 50 1 1357086880 8686288 5905776
18:26:38 64560 8192000000 10265353872 10700972032 1273473632 13.453 93 22 44 1 1288250928 9818464 4958832
18:28:45 32475 8192000000 10280146208 10721243136 1339629552 14.054 98 52 103 0 1363552384 12640208 11282624
18:30:20 54758 8192000000 10258741248 10697846784 1290486544 13.609 95 18 36 0 1305572608 11131536 3954528
18:32:18 89271 8192000000 10264805632 10713505792 1353260944 14.177 100 15 28 0 1373143840 16917984 2964912
18:34:47 19892 8192000000 10276819184 10720591872 1360304880 14.240 100 37 74 0 1378173840 9724288 8144672
18:36:08 35058 8192000000 10264471920 10721705984 1351212000 14.158 99 11 22 0 1366246000 12807056 2226944
18:38:09 73041 8192000000 10272304336 10725568512 1364585936 14.279 100 11 22 0 1374465344 7574976 2304432
18:40:54 53519 8192000000 10252750400 10709614592 1363702640 14.271 100 12 24 1 1373638768 7554288 2381840
18:42:50 77382 8192000000 10277153152 10736173056 1354495280 14.188 98 13 26 0 1368176960 10712352 2969328
18:45:09 26571 8192000000 10311895792 10747244544 1383949312 14.452 99 50 99 1 1406777216 11435744 11392160
18:46:41 72188 8192000000 10296633600 10749202432 1363482448 14.269 98 19 38 0 1382715760 14784352 4448960
18:49:01 44077 8192000000 10303801056 10746032128 1372162384 14.346 99 37 74 0 1390986624 10763728 8060512
18:50:46 51586 8192000000 10298664176 10752667648 1378340576 14.402 99 24 48 0 1398640496 15065760 5234160
18:52:39 19154 8192000000 10314752496 10764107776 1395383568 14.554 100 23 45 1 1412682752 12754736 4544448
18:54:01 99462 8192000000 10304781200 10753372160 1332637152 13.991 95 13 26 0 1349677696 14599584 2440960
18:56:41 79218 8192000000 10277918928 10729181184 1358948640 14.228 99 19 38 0 1374215344 11392160 3874544
18:59:04 39892 8192000000 10283823408 10739421184 1384909296 14.460 100 23 44 0 1400409472 10385584 5114592
19:00:49 60947 8192000000 10257403984 10720264192 1325897664 13.930 96 26 52 0 1342455696 10976720 5581312
19:04:15 51856 8192000000 10255057040 10712043520 1347199024 14.122 99 13 26 0 1357389504 7011056 3179424
19:06:32 37398 8192000000 10282776464 10733723648 1347067616 14.121 98 26 52 0 1371845728 18578128 6199984
19:08:12 54406 8192000000 10294383824 10746474496 1362045952 14.256 99 19 38 0 1389906032 23327904 4532176

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:14, from 03-03-2024 19:11:20 to 03-03-2024 19:11:34.

Exceptions occured during test was in run

FB_MNEMONA CNT UNIT FB_GDSCODE
except 165 v_add_invoice_to_stock 335544517
except 12 v_cancel_supplier_invoice 335544517

Completed "Exceptions occured during test was in run". Done for 00:00:02, from 03-03-2024 19:11:35 to 03-03-2024 19:11:37.

Content of mon$database and FB version 


MON$DATABASE_NAME               /home/bases/oltp30-etalone.fdb
MON$PAGE_SIZE                   8192
MON$ODS_MAJOR                   12
MON$ODS_MINOR                   0
MON$OLDEST_TRANSACTION          173024
MON$OLDEST_ACTIVE               177038
MON$OLDEST_SNAPSHOT             177038
MON$NEXT_TRANSACTION            177038
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-03 16:41:55.3470
MON$PAGES                       1907616
MON$STAT_ID                     1
MON$BACKUP_STATE                0
MON$CRYPT_PAGE                  0
MON$OWNER                       SYSDBA                                                                                       
MON$SEC_DATABASE                Default


ISQL Version: LI-V3.0.12.33733 Firebird 3.0
Server version:
Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V3.0.12.33733 Firebird 3.0"
Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-V3.0.12.33733 Firebird 3.0/tcp (mscs-test-161.budzdorov.ru)/P15:C"
Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-V3.0.12.33733 Firebird 3.0/tcp (mscs-test-161.budzdorov.ru)/P15:C"
on disk structure version 12.0

Database statistics 

 
Database "/home/bases/oltp30-etalone.fdb" 
Gstat execution time Sun Mar  3 19:11:38 2024 
 
Database header page information: 
    Flags            0 
    Generation        92443 
    System Change Number    0 
    Page size        8192 
    ODS version        12.0 
    Oldest transaction    173024 
    Oldest active        177038 
    Oldest snapshot        177038 
    Next transaction    177039 
    Sequence number        0 
    Next attachment ID    716 
    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 3, 2020 16:41:55 
    Attributes        force write 
 
    Variable header data: 
    Sweep interval:        0 
    Unrecognized option 11, length 16 
    *END* 
 
 
Database file sequence: 
File /home/bases/oltp30-etalone.fdb is the only file 
 
Analyzing database pages ... 
AGENTS (150) 
    Primary pointer page: 496, Index root page: 497 
    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: 1504311, 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: 1504313, 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: 1504312, 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: 1504310, 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: 1504309, 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: 504, Index root page: 505 
    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: 1504242, 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: 1504244, 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: 1504243, 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: 1504241, 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: 474, Index root page: 475 
    Total formats: 1, used formats: 1 
    Average record length: 47.38, total records: 7759461 
    Average version length: 48.16, total versions: 83276, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 64.00, compression ratio: 1.35 
    Pointer pages: 54, data page slots: 87128 
    Data pages: 87128, average fill: 71% 
    Primary pages: 87128, secondary pages: 0, swept pages: 18849 
    Empty pages: 7, full pages: 65053 
    Fill distribution: 
     0 - 19% = 19 
    20 - 39% = 213 
    40 - 59% = 3611 
    60 - 79% = 83269 
    80 - 99% = 16 
 
    Index DOC_DATA_DOC_WARE_UNQ (0) 
    Root page: 1510614, depth: 3, leaf buckets: 23325, nodes: 7759461 
    Average node length: 18.89, total dup: 0, max dup: 0 
    Average key length: 15.90, compression ratio: 1.70 
    Average prefix length: 14.09, average data length: 12.91 
    Clustering factor: 1719974, ratio: 0.22 
    Fill distribution: 
         0 - 19% = 297 
        20 - 39% = 1730 
        40 - 59% = 4366 
        60 - 79% = 2354 
        80 - 99% = 14578 
 
    Index DOC_DATA_ID_DESC (1) 
    Root page: 1528118, depth: 3, leaf buckets: 13561, nodes: 7759461 
    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: 1543080, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 1547 
        40 - 59% = 2139 
        60 - 79% = 1092 
        80 - 99% = 8783 
 
    Index FK_DOC_DATA_DOC_LIST (2) 
    Root page: 1546711, depth: 3, leaf buckets: 8390, nodes: 7759461 
    Average node length: 6.62, total dup: 5799205, max dup: 49 
    Average key length: 3.63, compression ratio: 2.48 
    Average prefix length: 7.62, average data length: 1.38 
    Clustering factor: 1535974, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 151 
        20 - 39% = 932 
        40 - 59% = 1457 
        60 - 79% = 920 
        80 - 99% = 4930 
 
DOC_LIST (138) 
    Primary pointer page: 472, Index root page: 473 
    Total formats: 1, used formats: 1 
    Average record length: 56.38, total records: 2251676 
    Average version length: 34.87, total versions: 82963, max versions: 3 
    Average fragment length: 5.67, total fragments: 3, max fragments: 1 
    Average unpacked length: 84.00, compression ratio: 1.49 
    Pointer pages: 18, data page slots: 28472 
    Data pages: 28472, average fill: 73% 
    Primary pages: 28466, secondary pages: 6, swept pages: 9012 
    Empty pages: 7, full pages: 21425 
    Fill distribution: 
     0 - 19% = 26 
    20 - 39% = 124 
    40 - 59% = 2046 
    60 - 79% = 25543 
    80 - 99% = 733 
 
    Index DOC_LIST_ID_DESC (1) 
    Root page: 1541130, depth: 3, leaf buckets: 4569, nodes: 2251676 
    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: 697813, ratio: 0.31 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 863 
        40 - 59% = 922 
        60 - 79% = 745 
        80 - 99% = 2038 
 
    Index DOC_LIST_WORKER_OPTYPE (2) 
    Root page: 1544376, depth: 3, leaf buckets: 2534, nodes: 2254425 
    Average node length: 4.97, total dup: 2253526, max dup: 18722 
    Average key length: 2.01, compression ratio: 4.47 
    Average prefix length: 8.99, average data length: 0.01 
    Clustering factor: 1254659, ratio: 0.56 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 257 
        40 - 59% = 1572 
        60 - 79% = 523 
        80 - 99% = 181 
 
    Index FK_DOC_LIST_AGENTS (3) 
    Root page: 1545909, depth: 3, leaf buckets: 2068, nodes: 2251676 
    Average node length: 4.97, total dup: 2251626, max dup: 130461 
    Average key length: 2.01, compression ratio: 4.48 
    Average prefix length: 8.99, average data length: 0.01 
    Clustering factor: 1061706, ratio: 0.47 
    Fill distribution: 
         0 - 19% = 4 
        20 - 39% = 112 
        40 - 59% = 1100 
        60 - 79% = 43 
        80 - 99% = 809 
 
    Index PK_DOC_LIST (0) 
    Root page: 1538187, depth: 3, leaf buckets: 4397, nodes: 2251676 
    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: 697813, ratio: 0.31 
    Fill distribution: 
         0 - 19% = 107 
        20 - 39% = 599 
        40 - 59% = 683 
        60 - 79% = 798 
        80 - 99% = 2210 
 
DOC_STATES (149) 
    Primary pointer page: 494, Index root page: 495 
    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: 1504315, 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: 1504316, 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: 1504314, 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: 506, Index root page: 507 
    Total formats: 2, used formats: 2 
    Average record length: 54.76, 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.94 
    Pointer pages: 1, data page slots: 40 
    Data pages: 40, average fill: 70% 
    Primary pages: 40, secondary pages: 0, swept pages: 0 
    Empty pages: 7, full pages: 32 
    Fill distribution: 
     0 - 19% = 7 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 7 
    80 - 99% = 26 
 
    Index FB_ERRORS_GDS_CODE (0) 
    Root page: 382, 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: 1515, ratio: 0.69 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 0 
        40 - 59% = 1 
        60 - 79% = 1 
        80 - 99% = 0 
 
INVNT_SALDO (145) 
    Primary pointer page: 486, Index root page: 487 
    Total formats: 2, used formats: 1 
    Average record length: 83.17, total records: 400 
    Average version length: 23.25, total versions: 31640, max versions: 619 
    Average fragment length: 2.00, total fragments: 15, max fragments: 1 
    Average unpacked length: 104.00, compression ratio: 1.25 
    Pointer pages: 1, data page slots: 1344 
    Data pages: 1343, average fill: 15% 
    Primary pages: 14, secondary pages: 1329, swept pages: 0 
    Empty pages: 476, full pages: 38 
    Fill distribution: 
     0 - 19% = 853 
    20 - 39% = 450 
    40 - 59% = 2 
    60 - 79% = 0 
    80 - 99% = 38 
 
    Index PK_INVNT_SALDO (0) 
    Root page: 1510349, 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: 502, Index root page: 503 
    Total formats: 1, used formats: 1 
    Average record length: 13.99, total records: 103357 
    Average version length: 68.29, total versions: 82205, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 88.00, compression ratio: 6.29 
    Pointer pages: 6, data page slots: 2160 
    Data pages: 2024, average fill: 63% 
    Primary pages: 2023, secondary pages: 1, swept pages: 0 
    Empty pages: 207, full pages: 1102 
    Fill distribution: 
     0 - 19% = 306 
    20 - 39% = 189 
    40 - 59% = 268 
    60 - 79% = 377 
    80 - 99% = 884 
 
    Index INVNT_TURNOVER_LOG_WARE_DD_ID (0) 
    Root page: 1694670, depth: 3, leaf buckets: 386, nodes: 103357 
    Average node length: 13.26, total dup: 7943, max dup: 2 
    Average key length: 10.64, compression ratio: 2.54 
    Average prefix length: 19.28, average data length: 7.72 
    Clustering factor: 73887, ratio: 0.71 
    Fill distribution: 
         0 - 19% = 3 
        20 - 39% = 136 
        40 - 59% = 224 
        60 - 79% = 23 
        80 - 99% = 0 
 
MONEY_SALDO (141) 
    Primary pointer page: 478, Index root page: 479 
    Total formats: 1, used formats: 1 
    Average record length: 15.27, total records: 49 
    Average version length: 9.00, total versions: 18827, max versions: 956 
    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: 72 
    Data pages: 72, average fill: 84% 
    Primary pages: 4, secondary pages: 68, swept pages: 0 
    Empty pages: 3, full pages: 68 
    Fill distribution: 
     0 - 19% = 3 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 17 
    80 - 99% = 52 
 
    Index PK_MONEY_SALDO (0) 
    Root page: 1510361, 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: 476, Index root page: 477 
    Total formats: 1, used formats: 1 
    Average record length: 8.60, total records: 2549 
    Average version length: 43.51, total versions: 2061, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 58.00, compression ratio: 6.75 
    Pointer pages: 1, data page slots: 32 
    Data pages: 31, average fill: 76% 
    Primary pages: 30, secondary pages: 1, swept pages: 0 
    Empty pages: 0, full pages: 25 
    Fill distribution: 
     0 - 19% = 2 
    20 - 39% = 1 
    40 - 59% = 2 
    60 - 79% = 8 
    80 - 99% = 18 
 
    Index MONEY_TURNOVER_LOG_AGENT_OPTYPE (0) 
    Root page: 88006, depth: 2, leaf buckets: 4, nodes: 2549 
    Average node length: 4.18, total dup: 2451, max dup: 265 
    Average key length: 2.42, compression ratio: 7.85 
    Average prefix length: 18.62, average data length: 0.38 
    Clustering factor: 1271, ratio: 0.50 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 2 
        40 - 59% = 1 
        60 - 79% = 0 
        80 - 99% = 0 
 
MON_CACHE_MEMORY (165) 
    Primary pointer page: 526, Index root page: 527 
    Total formats: 2, used formats: 1 
    Average record length: 97.07, total records: 73 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 112.00, compression ratio: 1.15 
    Pointer pages: 1, data page slots: 2 
    Data pages: 2, average fill: 51% 
    Primary pages: 2, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 1 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 1 
 
    Index PK_MON_CACHE_MEMORY (0) 
    Root page: 1504215, depth: 1, leaf buckets: 1, nodes: 73 
    Average node length: 11.68, total dup: 0, max dup: 0 
    Average key length: 10.67, compression ratio: 0.84 
    Average prefix length: 1.32, average data length: 7.68 
    Clustering factor: 2, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
MON_LOG (162) 
    Primary pointer page: 520, Index root page: 521 
    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: 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 
 
    Index MON_LOG_GDSCODE (2) 
    Root page: 1504227, 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: 1504226, 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: 1504228, 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: 1504225, 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: 522, Index root page: 523 
    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: 1504224, 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: 1504222, 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: 1504221, 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: 1504223, 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: 1504220, 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: 468, Index root page: 469 
    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: 1544805, 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: 1544804, 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: 488, Index root page: 489 
    Total formats: 1, used formats: 1 
    Average record length: 36.09, total records: 823394 
    Average version length: 25.50, total versions: 69668, max versions: 5 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 54.00, compression ratio: 1.50 
    Pointer pages: 6, data page slots: 8240 
    Data pages: 8240, average fill: 70% 
    Primary pages: 8217, secondary pages: 23, swept pages: 1614 
    Empty pages: 31, full pages: 6859 
    Fill distribution: 
     0 - 19% = 56 
    20 - 39% = 93 
    40 - 59% = 339 
    60 - 79% = 7504 
    80 - 99% = 248 
 
    Index PDISTR_AGENT_ID (2) 
    Root page: 1509308, depth: 2, leaf buckets: 912, nodes: 823394 
    Average node length: 4.87, total dup: 823345, max dup: 151256 
    Average key length: 2.01, compression ratio: 4.48 
    Average prefix length: 8.99, average data length: 0.01 
    Clustering factor: 90960, ratio: 0.11 
    Fill distribution: 
         0 - 19% = 3 
        20 - 39% = 106 
        40 - 59% = 546 
        60 - 79% = 196 
        80 - 99% = 61 
 
    Index PDISTR_SNDOP_RCVOP_SNDID_ASC (0) 
    Root page: 1508613, depth: 3, leaf buckets: 995, nodes: 823394 
    Average node length: 5.88, total dup: 733343, max dup: 43 
    Average key length: 3.02, compression ratio: 7.29 
    Average prefix length: 21.09, average data length: 0.91 
    Clustering factor: 162802, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 101 
        40 - 59% = 521 
        60 - 79% = 107 
        80 - 99% = 264 
 
    Index PDISTR_SNDOP_RCVOP_SNDID_DESC (1) 
    Root page: 1509187, depth: 3, leaf buckets: 1052, nodes: 823394 
    Average node length: 5.88, total dup: 733343, max dup: 43 
    Average key length: 3.02, compression ratio: 7.29 
    Average prefix length: 21.09, average data length: 0.91 
    Clustering factor: 164831, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 221 
        40 - 59% = 484 
        60 - 79% = 92 
        80 - 99% = 255 
 
    Index PDISTR_WORKER_SND_ID (3) 
    Root page: 1510178, depth: 3, leaf buckets: 1179, nodes: 823394 
    Average node length: 5.96, total dup: 733343, max dup: 43 
    Average key length: 3.10, compression ratio: 5.49 
    Average prefix length: 16.01, average data length: 0.99 
    Clustering factor: 157458, ratio: 0.19 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 262 
        40 - 59% = 635 
        60 - 79% = 199 
        80 - 99% = 81 
 
PERF_AGG (158) 
    Primary pointer page: 512, Index root page: 513 
    Total formats: 1, used formats: 1 
    Average record length: 62.86, total records: 5504 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 2.79, total fragments: 76, max fragments: 1 
    Average unpacked length: 379.00, compression ratio: 6.03 
    Pointer pages: 1, data page slots: 128 
    Data pages: 119, average fill: 46% 
    Primary pages: 98, secondary pages: 21, swept pages: 58 
    Empty pages: 31, full pages: 67 
    Fill distribution: 
     0 - 19% = 48 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 71 
    80 - 99% = 0 
 
    Index PERF_AGG_UNQ (1) 
    Root page: 1504238, depth: 2, leaf buckets: 6, nodes: 5504 
    Average node length: 5.47, total dup: 0, max dup: 0 
    Average key length: 3.57, compression ratio: 10.09 
    Average prefix length: 34.52, average data length: 1.54 
    Clustering factor: 5237, ratio: 0.95 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 0 
        40 - 59% = 4 
        60 - 79% = 1 
        80 - 99% = 1 
 
    Index PK_PERF_AGG (0) 
    Root page: 1504233, depth: 2, leaf buckets: 10, nodes: 5504 
    Average node length: 11.11, total dup: 0, max dup: 0 
    Average key length: 9.21, compression ratio: 0.98 
    Average prefix length: 2.79, average data length: 6.21 
    Clustering factor: 142, 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: 1504218, Index root page: 1504219 
    Total formats: 1, used formats: 1 
    Average record length: 39.18, total records: 81085 
    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: 784 
    Data pages: 784, average fill: 71% 
    Primary pages: 784, secondary pages: 0, swept pages: 0 
    Empty pages: 1, full pages: 782 
    Fill distribution: 
     0 - 19% = 2 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 782 
    80 - 99% = 0 
 
    Index PK_PERF_ESTIMATED (0) 
    Root page: 33804, depth: 2, leaf buckets: 105, nodes: 81085 
    Average node length: 10.18, total dup: 0, max dup: 0 
    Average key length: 8.19, compression ratio: 1.10 
    Average prefix length: 3.81, average data length: 5.19 
    Clustering factor: 3383, ratio: 0.04 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 1 
        40 - 59% = 2 
        60 - 79% = 0 
        80 - 99% = 101 
 
PERF_ISQL_STAT (156) 
    Primary pointer page: 508, Index root page: 509 
    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: 1504239, 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: 514, Index root page: 515 
    Total formats: 1, used formats: 1 
    Average record length: 111.10, total records: 72 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1691.00, compression ratio: 15.22 
    Pointer pages: 1, data page slots: 2 
    Data pages: 2, average fill: 57% 
    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: 573, Index root page: 574 
    Total formats: 1, used formats: 1 
    Average record length: 122.93, total records: 183056 
    Average version length: 154.85, total versions: 33815, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 13.80 
    Pointer pages: 6, data page slots: 4840 
    Data pages: 4432, average fill: 87% 
    Primary pages: 4432, secondary pages: 0, swept pages: 1 
    Empty pages: 69, full pages: 4347 
    Fill distribution: 
     0 - 19% = 78 
    20 - 39% = 3 
    40 - 59% = 1 
    60 - 79% = 3 
    80 - 99% = 4347 
 
PERF_SPLIT_1 (282) 
    Primary pointer page: 576, Index root page: 577 
    Total formats: 1, used formats: 1 
    Average record length: 149.12, total records: 163038 
    Average version length: 149.73, total versions: 1957, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.37 
    Pointer pages: 6, data page slots: 4168 
    Data pages: 3912, average fill: 86% 
    Primary pages: 3912, secondary pages: 0, swept pages: 4 
    Empty pages: 44, full pages: 3855 
    Fill distribution: 
     0 - 19% = 46 
    20 - 39% = 4 
    40 - 59% = 3 
    60 - 79% = 5 
    80 - 99% = 3854 
 
PERF_SPLIT_2 (283) 
    Primary pointer page: 578, Index root page: 579 
    Total formats: 1, used formats: 1 
    Average record length: 146.43, total records: 146021 
    Average version length: 151.72, total versions: 4044, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.58 
    Pointer pages: 6, data page slots: 4080 
    Data pages: 3488, average fill: 86% 
    Primary pages: 3488, secondary pages: 0, swept pages: 2 
    Empty pages: 32, full pages: 3447 
    Fill distribution: 
     0 - 19% = 33 
    20 - 39% = 3 
    40 - 59% = 2 
    60 - 79% = 3 
    80 - 99% = 3447 
 
PERF_SPLIT_3 (284) 
    Primary pointer page: 580, Index root page: 581 
    Total formats: 1, used formats: 1 
    Average record length: 148.46, total records: 175459 
    Average version length: 151.32, total versions: 3056, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.42 
    Pointer pages: 7, data page slots: 4960 
    Data pages: 4176, average fill: 87% 
    Primary pages: 4176, secondary pages: 0, swept pages: 6 
    Empty pages: 12, full pages: 4155 
    Fill distribution: 
     0 - 19% = 15 
    20 - 39% = 4 
    40 - 59% = 1 
    60 - 79% = 2 
    80 - 99% = 4154 
 
PERF_SPLIT_4 (285) 
    Primary pointer page: 582, Index root page: 583 
    Total formats: 1, used formats: 1 
    Average record length: 147.44, total records: 153594 
    Average version length: 152.61, total versions: 3536, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.50 
    Pointer pages: 7, data page slots: 5320 
    Data pages: 3680, average fill: 86% 
    Primary pages: 3680, secondary pages: 0, swept pages: 1 
    Empty pages: 33, full pages: 3631 
    Fill distribution: 
     0 - 19% = 37 
    20 - 39% = 7 
    40 - 59% = 4 
    60 - 79% = 1 
    80 - 99% = 3631 
 
PERF_SPLIT_5 (286) 
    Primary pointer page: 584, Index root page: 585 
    Total formats: 1, used formats: 1 
    Average record length: 148.24, total records: 159494 
    Average version length: 151.35, total versions: 2763, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.44 
    Pointer pages: 7, data page slots: 4696 
    Data pages: 3800, average fill: 86% 
    Primary pages: 3800, secondary pages: 0, swept pages: 3 
    Empty pages: 20, full pages: 3772 
    Fill distribution: 
     0 - 19% = 24 
    20 - 39% = 2 
    40 - 59% = 0 
    60 - 79% = 2 
    80 - 99% = 3772 
 
PERF_SPLIT_6 (287) 
    Primary pointer page: 586, Index root page: 587 
    Total formats: 1, used formats: 1 
    Average record length: 149.88, total records: 180102 
    Average version length: 149.02, total versions: 1653, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.32 
    Pointer pages: 7, data page slots: 4680 
    Data pages: 4288, average fill: 87% 
    Primary pages: 4288, secondary pages: 0, swept pages: 2 
    Empty pages: 12, full pages: 4269 
    Fill distribution: 
     0 - 19% = 12 
    20 - 39% = 2 
    40 - 59% = 2 
    60 - 79% = 4 
    80 - 99% = 4268 
 
PERF_SPLIT_7 (288) 
    Primary pointer page: 588, Index root page: 589 
    Total formats: 1, used formats: 1 
    Average record length: 121.23, total records: 186114 
    Average version length: 154.87, total versions: 36560, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 13.99 
    Pointer pages: 6, data page slots: 5040 
    Data pages: 4464, average fill: 88% 
    Primary pages: 4464, secondary pages: 0, swept pages: 3 
    Empty pages: 32, full pages: 4422 
    Fill distribution: 
     0 - 19% = 34 
    20 - 39% = 2 
    40 - 59% = 2 
    60 - 79% = 5 
    80 - 99% = 4421 
 
PERF_SPLIT_8 (289) 
    Primary pointer page: 590, Index root page: 591 
    Total formats: 1, used formats: 1 
    Average record length: 145.72, total records: 176968 
    Average version length: 153.16, total versions: 6368, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.64 
    Pointer pages: 7, data page slots: 4832 
    Data pages: 4232, average fill: 86% 
    Primary pages: 4232, secondary pages: 0, swept pages: 5 
    Empty pages: 28, full pages: 4193 
    Fill distribution: 
     0 - 19% = 29 
    20 - 39% = 4 
    40 - 59% = 4 
    60 - 79% = 3 
    80 - 99% = 4192 
 
PERF_SPLIT_9 (290) 
    Primary pointer page: 593, Index root page: 594 
    Total formats: 1, used formats: 1 
    Average record length: 149.76, total records: 152831 
    Average version length: 148.00, total versions: 1008, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.33 
    Pointer pages: 6, data page slots: 3968 
    Data pages: 3648, average fill: 86% 
    Primary pages: 3648, secondary pages: 0, swept pages: 2 
    Empty pages: 28, full pages: 3612 
    Fill distribution: 
     0 - 19% = 29 
    20 - 39% = 2 
    40 - 59% = 3 
    60 - 79% = 3 
    80 - 99% = 3611 
 
PHRASES (143) 
    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 PHRASES_ID_DESC (3) 
    Root page: 1510354, 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: 1510353, 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: 1510352, 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: 1510351, 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: 490, Index root page: 491 
    Total formats: 1, used formats: 1 
    Average record length: 51.77, total records: 2091674 
    Average version length: 52.92, total versions: 38946, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 70.00, compression ratio: 1.35 
    Pointer pages: 16, data page slots: 25552 
    Data pages: 25552, average fill: 70% 
    Primary pages: 25552, secondary pages: 0, swept pages: 10982 
    Empty pages: 328, full pages: 20216 
    Fill distribution: 
     0 - 19% = 600 
    20 - 39% = 506 
    40 - 59% = 1215 
    60 - 79% = 22905 
    80 - 99% = 326 
 
    Index PSTORNED_RCV_ID (1) 
    Root page: 1506186, depth: 3, leaf buckets: 2577, nodes: 2091674 
    Average node length: 5.44, total dup: 1951454, max dup: 1606 
    Average key length: 2.49, compression ratio: 3.62 
    Average prefix length: 8.58, average data length: 0.42 
    Clustering factor: 181051, ratio: 0.09 
    Fill distribution: 
         0 - 19% = 6 
        20 - 39% = 303 
        40 - 59% = 1664 
        60 - 79% = 312 
        80 - 99% = 292 
 
    Index PSTORNED_SND_ID (0) 
    Root page: 1504819, depth: 3, leaf buckets: 2757, nodes: 2091674 
    Average node length: 5.69, total dup: 1877205, max dup: 64 
    Average key length: 2.74, compression ratio: 3.29 
    Average prefix length: 8.36, average data length: 0.64 
    Clustering factor: 374027, ratio: 0.18 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 5 
        40 - 59% = 2433 
        60 - 79% = 293 
        80 - 99% = 25 
 
    Index PSTORNED_WORKER_ID (2) 
    Root page: 1507996, depth: 3, leaf buckets: 2133, nodes: 2091674 
    Average node length: 4.96, total dup: 2091574, max dup: 28069 
    Average key length: 2.00, compression ratio: 1.20 
    Average prefix length: 2.40, average data length: 0.00 
    Clustering factor: 178956, ratio: 0.09 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 187 
        40 - 59% = 1164 
        60 - 79% = 369 
        80 - 99% = 411 
 
RULES_FOR_PDISTR (148) 
    Primary pointer page: 492, Index root page: 493 
    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: 1504317, 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: 470, Index root page: 471 
    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: 1544803, 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: 1544802, 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: 500, Index root page: 501 
    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: 1504305, 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: 1504306, 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: 466, Index root page: 467 
    Total formats: 1, used formats: 1 
    Average record length: 97.63, 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: 2 
    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: 525, 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: 1544806, 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: 454, Index root page: 455 
    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: 1544810, 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: 460, Index root page: 461 
    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: 1544807, 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: 462, Index root page: 463 
    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: 464, Index root page: 465 
    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: 518, Index root page: 519 
    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: 516, Index root page: 517 
    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: 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 
 
TMP$PERF_MON (131) 
    Primary pointer page: 458, Index root page: 459 
    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: 456, Index root page: 457 
    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: 1544809, 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: 1544808, 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: 452, Index root page: 453 
    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: 1544811, 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: 528, Index root page: 529 
    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: 1504214, 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: 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 
 
WARES (142) 
    Primary pointer page: 480, Index root page: 481 
    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: 1552159, 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: 1510355, 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: 1510360, 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: 1510358, 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: 498, Index root page: 499 
    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: 1504307, 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: 1504308, 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: 549, Index root page: 550 
    Total formats: 1, used formats: 1 
    Average record length: 39.62, total records: 131850 
    Average version length: 69.18, total versions: 56361, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 3.18 
    Pointer pages: 3, data page slots: 4272 
    Data pages: 3088, average fill: 50% 
    Primary pages: 3087, secondary pages: 1, swept pages: 532 
    Empty pages: 657, full pages: 1569 
    Fill distribution: 
     0 - 19% = 1005 
    20 - 39% = 306 
    40 - 59% = 140 
    60 - 79% = 524 
    80 - 99% = 1113 
 
    Index XQD_1000_1200_WA_SO_RO_WKR_SND (0) 
    Root page: 98693, depth: 3, leaf buckets: 218, nodes: 131850 
    Average node length: 6.39, total dup: 114656, max dup: 14 
    Average key length: 3.98, compression ratio: 10.56 
    Average prefix length: 40.15, average data length: 1.85 
    Clustering factor: 22635, ratio: 0.17 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 75 
        40 - 59% = 86 
        60 - 79% = 50 
        80 - 99% = 6 
 
XQD_1000_3300 (178) 
    Primary pointer page: 553, Index root page: 554 
    Total formats: 1, used formats: 1 
    Average record length: 65.39, total records: 7036261 
    Average version length: 68.78, total versions: 364929, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.93 
    Pointer pages: 63, data page slots: 102088 
    Data pages: 102088, average fill: 74% 
    Primary pages: 102088, secondary pages: 0, swept pages: 25204 
    Empty pages: 18, full pages: 77709 
    Fill distribution: 
     0 - 19% = 143 
    20 - 39% = 1090 
    40 - 59% = 6980 
    60 - 79% = 88717 
    80 - 99% = 5158 
 
    Index XQD_1000_3300_WA_SO_RO_WKR_SND (0) 
    Root page: 1480454, depth: 3, leaf buckets: 10723, nodes: 7036261 
    Average node length: 6.51, total dup: 6086807, max dup: 29 
    Average key length: 3.52, compression ratio: 11.93 
    Average prefix length: 40.61, average data length: 1.39 
    Clustering factor: 1577774, ratio: 0.22 
    Fill distribution: 
         0 - 19% = 6 
        20 - 39% = 1680 
        40 - 59% = 5980 
        60 - 79% = 2616 
        80 - 99% = 441 
 
    Index XQD_1000_3300_WKR_DOC_ASC (1) 
    Root page: 1486068, depth: 3, leaf buckets: 8502, nodes: 7036261 
    Average node length: 5.40, total dup: 6755052, max dup: 166 
    Average key length: 2.41, compression ratio: 7.06 
    Average prefix length: 16.63, average data length: 0.37 
    Clustering factor: 1375511, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 13 
        20 - 39% = 1195 
        40 - 59% = 4663 
        60 - 79% = 1614 
        80 - 99% = 1017 
 
    Index XQD_1000_3300_WKR_DOC_DEC (2) 
    Root page: 1490608, depth: 3, leaf buckets: 8581, nodes: 7036261 
    Average node length: 5.40, total dup: 6755052, max dup: 166 
    Average key length: 2.41, compression ratio: 7.06 
    Average prefix length: 16.63, average data length: 0.37 
    Clustering factor: 1378029, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 5 
        20 - 39% = 1260 
        40 - 59% = 4716 
        60 - 79% = 1615 
        80 - 99% = 985 
 
XQD_1200_2000 (177) 
    Primary pointer page: 551, Index root page: 552 
    Total formats: 1, used formats: 1 
    Average record length: 67.31, total records: 12073271 
    Average version length: 68.71, total versions: 288879, 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: 104, data page slots: 169016 
    Data pages: 169016, average fill: 76% 
    Primary pages: 169016, secondary pages: 0, swept pages: 83042 
    Empty pages: 9, full pages: 151803 
    Fill distribution: 
     0 - 19% = 49 
    20 - 39% = 660 
    40 - 59% = 4742 
    60 - 79% = 158761 
    80 - 99% = 4804 
 
    Index XQD_1200_2000_WA_SO_RO_WKR_SND (0) 
    Root page: 1495028, depth: 3, leaf buckets: 18400, nodes: 12073271 
    Average node length: 6.58, total dup: 10524660, max dup: 59 
    Average key length: 3.43, compression ratio: 12.26 
    Average prefix length: 40.70, average data length: 1.30 
    Clustering factor: 2374867, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 15 
        20 - 39% = 2320 
        40 - 59% = 10739 
        60 - 79% = 4610 
        80 - 99% = 716 
 
XQD_2000_3300 (179) 
    Primary pointer page: 555, Index root page: 556 
    Total formats: 1, used formats: 1 
    Average record length: 42.80, total records: 1502682 
    Average version length: 69.13, total versions: 572747, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 2.94 
    Pointer pages: 27, data page slots: 42976 
    Data pages: 26192, average fill: 66% 
    Primary pages: 26192, secondary pages: 0, swept pages: 6348 
    Empty pages: 2291, full pages: 18235 
    Fill distribution: 
     0 - 19% = 4226 
    20 - 39% = 1495 
    40 - 59% = 1244 
    60 - 79% = 9802 
    80 - 99% = 9425 
 
    Index XQD_2000_3300_WA_SO_RO_WKR_SND (0) 
    Root page: 1479712, depth: 3, leaf buckets: 2038, nodes: 1502682 
    Average node length: 5.51, total dup: 1441907, max dup: 99 
    Average key length: 2.56, compression ratio: 16.39 
    Average prefix length: 41.48, average data length: 0.52 
    Clustering factor: 100262, ratio: 0.07 
    Fill distribution: 
         0 - 19% = 12 
        20 - 39% = 540 
        40 - 59% = 944 
        60 - 79% = 414 
        80 - 99% = 128 
 
XQD_2100_3300 (180) 
    Primary pointer page: 557, Index root page: 558 
    Total formats: 1, used formats: 1 
    Average record length: 39.42, total records: 1134534 
    Average version length: 69.14, total versions: 486524, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 3.20 
    Pointer pages: 22, data page slots: 34192 
    Data pages: 28456, average fill: 46% 
    Primary pages: 28455, secondary pages: 1, swept pages: 7886 
    Empty pages: 6761, full pages: 13043 
    Fill distribution: 
     0 - 19% = 11085 
    20 - 39% = 1957 
    40 - 59% = 1424 
    60 - 79% = 4343 
    80 - 99% = 9647 
 
    Index XQD_2100_3300_WA_SO_RO_WKR_SND (0) 
    Root page: 1479207, depth: 3, leaf buckets: 1511, nodes: 1134534 
    Average node length: 5.77, total dup: 1060571, max dup: 111 
    Average key length: 2.84, compression ratio: 14.79 
    Average prefix length: 41.23, average data length: 0.77 
    Clustering factor: 152763, ratio: 0.13 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 282 
        40 - 59% = 710 
        60 - 79% = 428 
        80 - 99% = 90 
 
XQD_3300_3400 (181) 
    Primary pointer page: 559, Index root page: 560 
    Total formats: 1, used formats: 1 
    Average record length: 65.71, total records: 9224227 
    Average version length: 68.99, total versions: 426882, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.92 
    Pointer pages: 89, data page slots: 144632 
    Data pages: 144632, average fill: 68% 
    Primary pages: 144631, secondary pages: 1, swept pages: 53736 
    Empty pages: 199, full pages: 77350 
    Fill distribution: 
     0 - 19% = 909 
    20 - 39% = 6863 
    40 - 59% = 25406 
    60 - 79% = 104537 
    80 - 99% = 6917 
 
    Index XQD_3300_3400_WA_SO_RO_WKR_SND (0) 
    Root page: 1472590, depth: 3, leaf buckets: 13464, nodes: 9224227 
    Average node length: 6.68, total dup: 7654428, max dup: 19 
    Average key length: 3.67, compression ratio: 11.46 
    Average prefix length: 40.50, average data length: 1.50 
    Clustering factor: 1996032, ratio: 0.22 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 1224 
        40 - 59% = 6835 
        60 - 79% = 4696 
        80 - 99% = 709 
 
XQS_1000_1200 (182) 
    Primary pointer page: 561, Index root page: 562 
    Total formats: 1, used formats: 1 
    Average record length: 82.50, total records: 21159307 
    Average version length: 82.74, total versions: 10965, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.53 
    Pointer pages: 196, data page slots: 318912 
    Data pages: 318912, average fill: 81% 
    Primary pages: 318912, secondary pages: 0, swept pages: 12679 
    Empty pages: 35, full pages: 318169 
    Fill distribution: 
     0 - 19% = 52 
    20 - 39% = 26 
    40 - 59% = 104 
    60 - 79% = 27498 
    80 - 99% = 291232 
 
    Index XQS_1000_1200_DOC_ID (1) 
    Root page: 1426716, depth: 3, leaf buckets: 19537, nodes: 21159307 
    Average node length: 5.72, total dup: 20678058, max dup: 192 
    Average key length: 2.16, compression ratio: 4.16 
    Average prefix length: 8.86, average data length: 0.14 
    Clustering factor: 3283065, ratio: 0.16 
    Fill distribution: 
         0 - 19% = 5 
        20 - 39% = 0 
        40 - 59% = 8436 
        60 - 79% = 543 
        80 - 99% = 10553 
 
    Index XQS_1000_1200_RCV_ID (3) 
    Root page: 1456980, depth: 3, leaf buckets: 17182, nodes: 21159307 
    Average node length: 6.31, total dup: 18594412, max dup: 49 
    Average key length: 2.75, compression ratio: 3.27 
    Average prefix length: 8.37, average data length: 0.63 
    Clustering factor: 916050, ratio: 0.04 
    Fill distribution: 
         0 - 19% = 3 
        20 - 39% = 0 
        40 - 59% = 804 
        60 - 79% = 251 
        80 - 99% = 16124 
 
    Index XQS_1000_1200_SND_ID (2) 
    Root page: 1441073, depth: 3, leaf buckets: 21341, nodes: 21159307 
    Average node length: 6.35, total dup: 18513964, max dup: 29 
    Average key length: 2.79, compression ratio: 3.23 
    Average prefix length: 8.34, average data length: 0.66 
    Clustering factor: 3577734, ratio: 0.17 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 1 
        40 - 59% = 8745 
        60 - 79% = 635 
        80 - 99% = 11959 
 
    Index XQS_1000_1200_WORKER_ID (0) 
    Root page: 1413348, depth: 3, leaf buckets: 16163, nodes: 21159307 
    Average node length: 5.56, total dup: 21159207, max dup: 228952 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.42, average data length: 0.00 
    Clustering factor: 944890, ratio: 0.04 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 5 
        40 - 59% = 2979 
        60 - 79% = 421 
        80 - 99% = 12757 
 
XQS_1000_3300 (184) 
    Primary pointer page: 565, Index root page: 566 
    Total formats: 1, used formats: 1 
    Average record length: 78.53, total records: 9707143 
    Average version length: 82.64, total versions: 458037, 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: 172296 
    Data pages: 172248, average fill: 70% 
    Primary pages: 172248, secondary pages: 0, swept pages: 70725 
    Empty pages: 597, full pages: 96553 
    Fill distribution: 
     0 - 19% = 1715 
    20 - 39% = 7923 
    40 - 59% = 29038 
    60 - 79% = 72395 
    80 - 99% = 61177 
 
    Index XQS_1000_3300_DOC_ID (1) 
    Root page: 1367502, depth: 3, leaf buckets: 11368, nodes: 9707143 
    Average node length: 5.38, total dup: 9398577, max dup: 181 
    Average key length: 2.23, compression ratio: 4.03 
    Average prefix length: 8.80, average data length: 0.20 
    Clustering factor: 2149540, ratio: 0.22 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 57 
        40 - 59% = 8183 
        60 - 79% = 3044 
        80 - 99% = 83 
 
    Index XQS_1000_3300_RCV_ID (3) 
    Root page: 1379261, depth: 3, leaf buckets: 13721, nodes: 9707143 
    Average node length: 6.24, total dup: 8049527, max dup: 14 
    Average key length: 3.10, compression ratio: 2.90 
    Average prefix length: 8.07, average data length: 0.93 
    Clustering factor: 1497865, ratio: 0.15 
    Fill distribution: 
         0 - 19% = 129 
        20 - 39% = 4102 
        40 - 59% = 4583 
        60 - 79% = 2511 
        80 - 99% = 2396 
 
    Index XQS_1000_3300_SND_ID (2) 
    Root page: 1373059, depth: 3, leaf buckets: 12696, nodes: 9707143 
    Average node length: 5.99, total dup: 8424272, max dup: 41 
    Average key length: 2.85, compression ratio: 3.16 
    Average prefix length: 8.28, average data length: 0.72 
    Clustering factor: 2334815, ratio: 0.24 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 69 
        40 - 59% = 9147 
        60 - 79% = 3366 
        80 - 99% = 112 
 
    Index XQS_1000_3300_WORKER_ID (0) 
    Root page: 1362767, depth: 3, leaf buckets: 10138, nodes: 9707143 
    Average node length: 5.15, total dup: 9707043, max dup: 144133 
    Average key length: 2.00, compression ratio: 1.20 
    Average prefix length: 2.40, average data length: 0.00 
    Clustering factor: 1546556, ratio: 0.16 
    Fill distribution: 
         0 - 19% = 34 
        20 - 39% = 1213 
        40 - 59% = 5097 
        60 - 79% = 1676 
        80 - 99% = 2118 
 
XQS_1200_2000 (183) 
    Primary pointer page: 563, Index root page: 564 
    Total formats: 1, used formats: 1 
    Average record length: 80.02, total records: 11252771 
    Average version length: 82.56, total versions: 311576, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.57 
    Pointer pages: 118, data page slots: 191864 
    Data pages: 190608, average fill: 72% 
    Primary pages: 190608, secondary pages: 0, swept pages: 72862 
    Empty pages: 3201, full pages: 140943 
    Fill distribution: 
     0 - 19% = 5515 
    20 - 39% = 7887 
    40 - 59% = 18617 
    60 - 79% = 42142 
    80 - 99% = 116447 
 
    Index XQS_1200_2000_DOC_ID (1) 
    Root page: 1392101, depth: 3, leaf buckets: 13122, nodes: 11252771 
    Average node length: 5.30, total dup: 11143580, max dup: 669 
    Average key length: 2.08, compression ratio: 4.33 
    Average prefix length: 8.93, average data length: 0.07 
    Clustering factor: 2343530, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 3 
        20 - 39% = 133 
        40 - 59% = 9359 
        60 - 79% = 3495 
        80 - 99% = 132 
 
    Index XQS_1200_2000_RCV_ID (3) 
    Root page: 1406110, depth: 3, leaf buckets: 10380, nodes: 11252771 
    Average node length: 5.49, total dup: 10761683, max dup: 49 
    Average key length: 2.28, compression ratio: 3.95 
    Average prefix length: 8.77, average data length: 0.23 
    Clustering factor: 706386, ratio: 0.06 
    Fill distribution: 
         0 - 19% = 147 
        20 - 39% = 835 
        40 - 59% = 2596 
        60 - 79% = 1772 
        80 - 99% = 5030 
 
    Index XQS_1200_2000_SND_ID (2) 
    Root page: 1398638, depth: 3, leaf buckets: 15007, nodes: 11252771 
    Average node length: 6.02, total dup: 9819616, max dup: 63 
    Average key length: 2.81, compression ratio: 3.21 
    Average prefix length: 8.32, average data length: 0.68 
    Clustering factor: 2359936, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 169 
        40 - 59% = 10872 
        60 - 79% = 3825 
        80 - 99% = 139 
 
    Index XQS_1200_2000_WORKER_ID (0) 
    Root page: 1386211, depth: 3, leaf buckets: 10693, nodes: 11252771 
    Average node length: 5.22, total dup: 11252671, max dup: 191908 
    Average key length: 2.00, compression ratio: 1.20 
    Average prefix length: 2.39, average data length: 0.00 
    Clustering factor: 695942, ratio: 0.06 
    Fill distribution: 
         0 - 19% = 93 
        20 - 39% = 849 
        40 - 59% = 4728 
        60 - 79% = 1453 
        80 - 99% = 3570 
 
XQS_2000_3300 (185) 
    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 
 
    Index XQS_2000_3300_DOC_ID (1) 
    Root page: 1361753, 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: 1361755, 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: 1361754, 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: 1361752, 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: 569, Index root page: 570 
    Total formats: 1, used formats: 1 
    Average record length: 79.00, total records: 9806792 
    Average version length: 82.93, total versions: 443542, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.59 
    Pointer pages: 108, data page slots: 175320 
    Data pages: 175264, average fill: 69% 
    Primary pages: 175264, secondary pages: 0, swept pages: 74653 
    Empty pages: 654, full pages: 97865 
    Fill distribution: 
     0 - 19% = 2036 
    20 - 39% = 8773 
    40 - 59% = 29688 
    60 - 79% = 73759 
    80 - 99% = 61008 
 
    Index XQS_2100_3300_DOC_ID (1) 
    Root page: 1344686, depth: 3, leaf buckets: 11895, nodes: 9806792 
    Average node length: 5.19, total dup: 9777956, max dup: 1875 
    Average key length: 2.03, compression ratio: 4.43 
    Average prefix length: 8.97, average data length: 0.03 
    Clustering factor: 1961525, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 29 
        20 - 39% = 1520 
        40 - 59% = 7891 
        60 - 79% = 1884 
        80 - 99% = 571 
 
    Index XQS_2100_3300_RCV_ID (3) 
    Root page: 1355717, depth: 3, leaf buckets: 13849, nodes: 9806792 
    Average node length: 6.26, total dup: 8132023, max dup: 14 
    Average key length: 3.10, compression ratio: 2.90 
    Average prefix length: 8.07, average data length: 0.93 
    Clustering factor: 1461351, ratio: 0.15 
    Fill distribution: 
         0 - 19% = 183 
        20 - 39% = 4060 
        40 - 59% = 4601 
        60 - 79% = 2518 
        80 - 99% = 2487 
 
    Index XQS_2100_3300_SND_ID (2) 
    Root page: 1350049, depth: 3, leaf buckets: 12533, nodes: 9806792 
    Average node length: 5.44, total dup: 9368374, max dup: 99 
    Average key length: 2.29, compression ratio: 3.94 
    Average prefix length: 8.76, average data length: 0.24 
    Clustering factor: 2092551, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 19 
        20 - 39% = 1523 
        40 - 59% = 8752 
        60 - 79% = 1658 
        80 - 99% = 581 
 
    Index XQS_2100_3300_WORKER_ID (0) 
    Root page: 985805, depth: 3, leaf buckets: 10326, nodes: 9806792 
    Average node length: 5.16, total dup: 9806692, max dup: 146579 
    Average key length: 2.00, compression ratio: 1.20 
    Average prefix length: 2.40, average data length: 0.00 
    Clustering factor: 1562602, ratio: 0.16 
    Fill distribution: 
         0 - 19% = 49 
        20 - 39% = 1255 
        40 - 59% = 5254 
        60 - 79% = 1668 
        80 - 99% = 2100 
 
XQS_3300_3400 (187) 
    Primary pointer page: 571, Index root page: 572 
    Total formats: 1, used formats: 1 
    Average record length: 67.21, total records: 573957 
    Average version length: 68.81, total versions: 8052, 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: 5, data page slots: 8016 
    Data pages: 8016, average fill: 75% 
    Primary pages: 8016, secondary pages: 0, swept pages: 3793 
    Empty pages: 1, full pages: 6536 
    Fill distribution: 
     0 - 19% = 4 
    20 - 39% = 37 
    40 - 59% = 255 
    60 - 79% = 7591 
    80 - 99% = 129 
 
    Index XQS_3300_3400_DOC_ID (1) 
    Root page: 34945, depth: 3, leaf buckets: 734, nodes: 573957 
    Average node length: 5.95, total dup: 488658, max dup: 82 
    Average key length: 3.09, compression ratio: 2.91 
    Average prefix length: 8.06, average data length: 0.94 
    Clustering factor: 99726, ratio: 0.17 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 29 
        40 - 59% = 519 
        60 - 79% = 88 
        80 - 99% = 98 
 
    Index XQS_3300_3400_SND_ID (2) 
    Root page: 31163, depth: 3, leaf buckets: 753, nodes: 573957 
    Average node length: 6.15, total dup: 470902, max dup: 15 
    Average key length: 3.29, compression ratio: 2.73 
    Average prefix length: 7.89, average data length: 1.11 
    Clustering factor: 99778, ratio: 0.17 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 34 
        40 - 59% = 526 
        60 - 79% = 84 
        80 - 99% = 109 
 
    Index XQS_3300_3400_WORKER_ID (0) 
    Root page: 375548, depth: 2, leaf buckets: 567, nodes: 573957 
    Average node length: 4.86, total dup: 573857, max dup: 9020 
    Average key length: 2.00, compression ratio: 1.20 
    Average prefix length: 2.40, average data length: 0.00 
    Clustering factor: 88662, ratio: 0.15 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 37 
        40 - 59% = 321 
        60 - 79% = 86 
        80 - 99% = 123 
 
ZDOC_DATA (170) 
    Primary pointer page: 537, Index root page: 538 
    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: 535, Index root page: 536 
    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: 539, Index root page: 540 
    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: 545, Index root page: 546 
    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: 1504207, 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: 547, Index root page: 548 
    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: 1504206, 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: 541, Index root page: 542 
    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: 1504212, 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: 1504213, 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: 543, Index root page: 544 
    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: 1504209, 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: 1504208, 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: 1504211, 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: 1504210, 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: 533, Index root page: 534 
    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: 531, Index root page: 532 
    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: 484, Index root page: 485 
    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: 1510350, depth: 1, leaf buckets: 1, nodes: 29 
    Average node length: 15.17, total dup: 0, max dup: 0 
    Average key length: 14.14, compression ratio: 1.44 
    Average prefix length: 9.17, average data length: 11.17 
    Clustering factor: 1, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
Gstat completion time Sun Mar  3 19:12:02 2024

Record versions statistics, table

TABLE_NAME TOTAL_RECS TOTAL_VERS MAX_VERSIONS VERS_TO_RECS_PRC MAXV_TO_VERS_PRC
DOC_DATA 7759461 83276 1 0.0000 0.0000
DOC_LIST 2251676 82963 3 0.0000 0.0000
FB_ERRORS 2182 757 1 0.0000 0.0000
INVNT_SALDO 400 31640 619 7900.0000 0.0000
INVNT_TURNOVER_LOG 103357 82205 1 0.0000 0.0000
MONEY_SALDO 49 18827 956 38400.0000 0.0000
MONEY_TURNOVER_LOG 2549 2061 1 0.0000 0.0000
PDISTR 823394 69668 5 0.0000 0.0000
PERF_SPLIT_0 183056 33815 1 0.0000 0.0000
PERF_SPLIT_1 163038 1957 1 0.0000 0.0000
PERF_SPLIT_2 146021 4044 1 0.0000 0.0000
PERF_SPLIT_3 175459 3056 1 0.0000 0.0000
PERF_SPLIT_4 153594 3536 1 0.0000 0.0000
PERF_SPLIT_5 159494 2763 1 0.0000 0.0000
PERF_SPLIT_6 180102 1653 1 0.0000 0.0000
PERF_SPLIT_7 186114 36560 1 0.0000 0.0000
PERF_SPLIT_8 176968 6368 1 0.0000 0.0000
PERF_SPLIT_9 152831 1008 1 0.0000 0.0000
PSTORNED 2091674 38946 1 0.0000 0.0000
SEMAPHORES 5 1 1 0.0000 100.0000
XQD_1000_1200 131850 56361 1 0.0000 0.0000
XQD_1000_3300 7036261 364929 1 0.0000 0.0000
XQD_1200_2000 12073271 288879 1 0.0000 0.0000
XQD_2000_3300 1502682 572747 1 0.0000 0.0000
XQD_2100_3300 1134534 486524 1 0.0000 0.0000
XQD_3300_3400 9224227 426882 1 0.0000 0.0000
XQS_1000_1200 21159307 10965 1 0.0000 0.0000
XQS_1000_3300 9707143 458037 1 0.0000 0.0000
XQS_1200_2000 11252771 311576 1 0.0000 0.0000
XQS_2100_3300 9806792 443542 1 0.0000 0.0000
XQS_3300_3400 573957 8052 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 ---
:103: 
:104: mscs-test-161.budzdorov.ru    Sun Mar  3 19:09:44 2024
:105:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:106: 
:107: 
:108: mscs-test-161.budzdorov.ru    Sun Mar  3 19:09:44 2024
:109:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:110: 
:111: 
:112: mscs-test-161.budzdorov.ru    Sun Mar  3 19:09:45 2024
:113:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:114: 
:115: 
:116: mscs-test-161.budzdorov.ru    Sun Mar  3 19:09:46 2024
:117:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:118: 
:119: 
:120: mscs-test-161.budzdorov.ru    Sun Mar  3 19:10:01 2024
:121:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:122: 
--- end of diff output ---

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

03.03.24 19:12:13. There are 3 logs in /var/tmp/logs-oltp30 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-03 19:12:16 No severe PSQL-related problems occured
03.03.24 19:12:17. End of report.