Generated by /opt/oltp-emul/oltp_isql_run_worker.sh, ISQL session No. 1 of total launched 100. 27.02.2024 16: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 15775040 kB
MemAvailable 30313644 kB
Buffers 0 kB
Cached 15980936 kB
SwapCached 2480 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-02-27 16:09:39
DTS_END                         2024-02-27 16:09:39.6900
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/34786
TRN_ID                          175901
ATT_ID                          600
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: 9126.01 21809 912601
customer order: creation 173.49 368 17349
customer order: refuse 15.37 408 1537
order to supplier: creation 46.58 1516 4658
order to supplier: removal 3.47 99682 347
invoice (draft): creation 47.30 3623 4730
invoice (draft): removal 50.25 782 5025
invoice accept: apply 42.62 21212 4262
invoice accept: cancel 45.08 987 4508
customer reserve: creation 4016.64 204 401664
customer reserve: removal 4386.87 62 438687
realization accept: apply 85.74 209 8574
realization accept: cancel 81.23 133 8123
payment from customer: creation 59.12 148 5912
payment from customer: removal 5.64 87 564
payment to supplier: creation 50.03 222 5003
payment to supplier: removal 3.65 123 365
service: total inventory turnovers 4.76 1169 476
service: total monetary turnovers 7.25 32 725
service: aggregate perf. data 0.89 21333 89
service: refresh index statistics 0.03 283879 3

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:02, from 27-02-2024 16:11:16 to 27-02-2024 16:11:18.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 3587
TEST_TIME 2 3249
TEST_TIME 3 3224
TEST_TIME 4 3654
TEST_TIME 5 4248
TEST_TIME 6 4008
TEST_TIME 7 4098
TEST_TIME 8 4155
TEST_TIME 9 4956
TEST_TIME 10 5113
TEST_TIME 11 5412
TEST_TIME 12 5477
TEST_TIME 13 5812
TEST_TIME 14 5996
TEST_TIME 15 6300
TEST_TIME 16 6550
TEST_TIME 17 6844
TEST_TIME 18 7023
TEST_TIME 19 7166
TEST_TIME 20 7268
TEST_TIME 21 7543
TEST_TIME 22 7891
TEST_TIME 23 8028
TEST_TIME 24 8188
TEST_TIME 25 8632
TEST_TIME 26 9009
TEST_TIME 27 9463
TEST_TIME 28 9611
TEST_TIME 29 9530
TEST_TIME 30 9382
TEST_TIME 31 9441
TEST_TIME 32 9168
TEST_TIME 33 9052
TEST_TIME 34 9044
TEST_TIME 35 9371
TEST_TIME 36 9351
TEST_TIME 37 9478
TEST_TIME 38 9319
TEST_TIME 39 9369
TEST_TIME 40 9278
TEST_TIME 41 9127
TEST_TIME 42 8963
TEST_TIME 43 9035
TEST_TIME 44 9058
TEST_TIME 45 8963
TEST_TIME 46 8953
TEST_TIME 47 9019
TEST_TIME 48 8944
TEST_TIME 49 8846
TEST_TIME 50 8698
TEST_TIME 51 8802
TEST_TIME 52 8784
TEST_TIME 53 8722
TEST_TIME 54 8809
TEST_TIME 55 8851
TEST_TIME 56 8908
TEST_TIME 57 8933
TEST_TIME 58 8884
TEST_TIME 59 9098
TEST_TIME 60 9068
TEST_TIME 61 9104
TEST_TIME 62 9078
TEST_TIME 63 9234
TEST_TIME 64 9287
TEST_TIME 65 9244
TEST_TIME 66 9208
TEST_TIME 67 9130
TEST_TIME 68 9123
TEST_TIME 69 9084
TEST_TIME 70 9041
TEST_TIME 71 9057
TEST_TIME 72 9029
TEST_TIME 73 8998
TEST_TIME 74 9076
TEST_TIME 75 9059
TEST_TIME 76 9006
TEST_TIME 77 9004
TEST_TIME 78 9087
TEST_TIME 79 9140
TEST_TIME 80 9270
TEST_TIME 81 9270
TEST_TIME 82 9316
TEST_TIME 83 9339
TEST_TIME 84 9441
TEST_TIME 85 9417
TEST_TIME 86 9408
TEST_TIME 87 9480
TEST_TIME 88 9407
TEST_TIME 89 9328
TEST_TIME 90 9290
TEST_TIME 91 9300
TEST_TIME 92 9353
TEST_TIME 93 9299
TEST_TIME 94 9294
TEST_TIME 95 9241
TEST_TIME 96 9212
TEST_TIME 97 9205
TEST_TIME 98 9209
TEST_TIME 99 9180
TEST_TIME 100 9127

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:04, from 27-02-2024 16:11:19 to 27-02-2024 16:11:23.

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 1279457 1279457 0 0.00 0 47472 8 0 0
doc_list_biud 1279457 1279457 0 0.00 0 50051 27 0 0
sp_add_invoice_to_stock 4401 4262 139 3.15 37 234107 21213 0 139
sp_cancel_adding_invoice 4508 4508 0 0.00 6 75630 987 0 0
sp_cancel_client_order 1537 1537 0 0.00 4 10854 408 0 0
sp_cancel_customer_reserve 438687 438687 0 0.00 0 50052 63 0 0
sp_cancel_pay_from_customer 564 564 0 0.00 3 13446 87 0 0
sp_cancel_pay_to_supplier 365 365 0 0.00 2 4881 123 0 0
sp_cancel_supplier_invoice 5037 5025 12 0.23 1 14378 783 0 12
sp_cancel_supplier_order 347 347 0 0.00 8 1098553 99683 0 0
sp_cancel_write_off 8123 8123 0 0.00 1 27110 133 0 0
sp_client_order 17349 17349 0 0.00 4 34165 368 0 0
sp_customer_reserve 401664 401664 0 0.00 0 53085 205 0 0
sp_fill_shopping_cart 26734 26734 0 0.00 1 15888 44 0 0
sp_fill_shopping_cart_clo_res 401661 401661 0 0.00 0 13623 16 0 0
sp_get_clo_for_invoice 4260 4260 0 0.00 0 22649 288 0 0
sp_kill_cost_storno 13560 13560 0 0.00 0 36972 73 0 0
sp_kill_qstorno_ret_qs2qd 890869 890869 0 0.00 0 50050 34 0 0
sp_kill_qty_storno 471061 471061 0 0.00 0 50051 74 0 0
sp_lock_selected_doc 17809 17809 0 0.00 0 7762 8 0 0
sp_make_cost_storno 23749 23749 0 0.00 0 31383 68 0 0
sp_multiply_rows_for_pdistr 23749 23749 0 0.00 0 45730 46 0 0
sp_multiply_rows_for_qdistr 17349 17349 0 0.00 0 21491 152 0 0
sp_pay_from_customer 5912 5912 0 0.00 4 49277 149 0 0
sp_pay_to_supplier 5003 5003 0 0.00 5 53309 222 0 0
sp_payment_common 10915 10915 0 0.00 1 33650 52 0 0
sp_qd_handle_on_cancel_clo 1537 1537 0 0.00 1 10849 378 0 0
sp_qd_handle_on_invoice_upd_sts 8768 8768 0 0.00 0 20714 370 0 0
sp_qd_handle_on_reserve_upd_sts 8574 8574 0 0.00 0 15859 64 0 0
sp_reserve_write_off 8574 8574 0 0.00 6 35399 210 0 0
sp_supplier_invoice 4730 4730 0 0.00 6 95308 3624 0 0
sp_supplier_order 4658 4658 0 0.00 5 92457 1516 0 0
srv_aggregate_perf_data 90 89 1 1.11 1572 186669 21333 0 1
srv_fill_mon_cache_memory 56 56 0 0.00 1844 172461 39575 0 0
srv_find_qd_qs_mism 869340 869340 0 0.00 0 18256 7 0 0
srv_make_invnt_saldo 476 476 0 0.00 62 65296 1170 0 0
srv_make_money_saldo 725 725 0 0.00 0 1053 32 0 0
srv_recalc_idx_stat 3 3 0 0.00 191304 399767 283880 0 0
t$perf-abend:sp_add_invoice_to_stock 139 139 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-abend:srv_aggregate_perf_data 1 1 0 0.00 0 0 0 0 0
t$perf-norm:sp_add_invoice_to_stock 4262 4262 0 0.00 0 14131 193 0 0
t$perf-norm:sp_cancel_adding_invoice 357 357 0 0.00 0 4658 152 0 0
t$perf-norm:sp_cancel_client_order 1537 1537 0 0.00 0 5614 16 0 0
t$perf-norm:sp_cancel_customer_reserve 560 560 0 0.00 0 1137 12 0 0
t$perf-norm:sp_cancel_pay_from_customer 564 564 0 0.00 0 498 5 0 0
t$perf-norm:sp_cancel_pay_to_supplier 365 365 0 0.00 0 239 2 0 0
t$perf-norm:sp_cancel_supplier_invoice 374 374 0 0.00 0 1151 20 0 0
t$perf-norm:sp_cancel_supplier_order 347 347 0 0.00 0 28174 1806 0 0
t$perf-norm:sp_cancel_write_off 871 871 0 0.00 0 1210 7 0 0
t$perf-norm:sp_client_order 17349 17349 0 0.00 0 6183 19 0 0
t$perf-norm:sp_customer_reserve 866 866 0 0.00 0 763 5 0 0
t$perf-norm:sp_pay_from_customer 5912 5912 0 0.00 0 3610 9 0 0
t$perf-norm:sp_pay_to_supplier 5003 5003 0 0.00 0 3605 11 0 0
t$perf-norm:sp_reserve_write_off 8574 8574 0 0.00 0 4253 9 0 0
t$perf-norm:sp_supplier_invoice 4730 4730 0 0.00 0 5914 21 0 0
t$perf-norm:sp_supplier_order 4658 4658 0 0.00 0 4885 17 0 0
t$perf-norm:srv_aggregate_perf_data 89 89 0 0.00 0 191 4 0 0
t$perf-norm:srv_fill_mon_cache_memory 56 56 0 0.00 0 226 10 0 0
t$perf-norm:srv_make_invnt_saldo 476 476 0 0.00 0 973 24 0 0
t$perf-norm:srv_make_money_saldo 725 725 0 0.00 0 2313 30 0 0
t$perf-norm:srv_recalc_idx_stat 3 3 0 0.00 2 4 3 0 0
v_add_invoice_to_stock 8798 8520 278 3.15 0 4711 19 0 278
v_all_customers 31888 31888 0 0.00 0 34 1 0 0
v_all_suppliers 26454 26454 0 0.00 0 60 1 0 0
v_all_wares 34698 34698 0 0.00 0 28 1 0 0
v_cancel_adding_invoice 714 714 0 0.00 0 1264 10 0 0
v_cancel_client_order 3074 3074 0 0.00 0 1149 4 0 0
v_cancel_customer_prepayment 1128 1128 0 0.00 0 601 4 0 0
v_cancel_customer_reserve 1120 1120 0 0.00 0 1315 6 0 0
v_cancel_payment_to_supplier 730 730 0 0.00 0 4869 12 0 0
v_cancel_supplier_invoice 772 748 24 3.10 0 1928 22 0 24
v_cancel_supplier_order 694 694 0 0.00 0 3176 12 0 0
v_cancel_write_off 1742 1742 0 0.00 0 4369 17 0 0
v_max_id_clo_ord 4657 4657 0 0.00 0 290 1 0 0
v_max_id_clo_res 865 865 0 0.00 0 2825 17 0 0
v_max_id_ord_sup 4728 4728 0 0.00 0 7515 8 0 0
v_max_non_paid_invoice 1161 1161 0 0.00 0 1724 5 0 0
v_max_non_paid_realizn 3003 3003 0 0.00 0 4951 7 0 0
v_min_id_clo_ord 4657 4657 0 0.00 0 13230 11 0 0
v_min_id_clo_res 865 865 0 0.00 0 4513 15 0 0
v_min_id_ord_sup 4728 4728 0 0.00 0 5290 8 0 0
v_min_non_paid_invoice 5003 5003 0 0.00 0 33644 47 0 0
v_min_non_paid_realizn 5912 5912 0 0.00 0 32030 40 0 0
v_our_firm 8628 8628 0 0.00 0 34 1 0 0
v_reserve_write_off 17148 17148 0 0.00 0 8329 7 0 0
x_lock_depdocs_on_canc_invoice 9159 9159 0 0.00 0 28708 156 0 0
x_lock_depdocs_on_canc_sup_ord 347 347 0 0.00 0 16060 400 0 0
x_make_qstorno_1000_1200 4658 4658 0 0.00 2 92451 1414 0 0
x_make_qstorno_1200_2000 4730 4730 0 0.00 2 95289 3471 0 0
x_make_qstorno_2100_3300 401664 401664 0 0.00 0 53042 185 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 27-02-2024 16:11:24 to 27-02-2024 16:11:28.

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
14:09:43 1 8192000000 8797116768 8807743488 3953616 0.048 1 1 2 0 4051888 55488 42784
14:10:44 17811 8192000000 9884429136 10191773696 967001104 10.557 100 83 166 0 994219952 5619632 21599216
14:12:08 22514 8192000000 9940531312 10258767872 1023087328 11.102 100 93 186 0 1055669968 8766048 23816592
14:13:33 12802 8192000000 9958879152 10283077632 1039182928 11.257 100 89 176 0 1071748288 9865296 22700064
14:14:50 11302 8192000000 9999627616 10337910784 1082260608 11.669 100 78 156 0 1112687872 11129072 19298192
14:16:05 8604 8192000000 10050961632 10400497664 1136254304 12.180 100 83 166 0 1167783552 12159328 19369920
14:17:18 3454 8192000000 10090974528 10453868544 1180164272 12.592 100 76 150 0 1210695376 13490768 17040336
14:18:27 3517 8192000000 10137044880 10504949760 1219839504 12.960 100 86 172 0 1252483264 13852080 18791680
14:19:33 1490 8192000000 10165970480 10543575040 1252446080 13.261 100 73 141 0 1280944144 12755872 15742192
14:20:37 1549 8192000000 10203034960 10584842240 1289785728 13.602 100 94 185 1 1322174000 12761664 19626608
14:21:40 41425 8192000000 10205475008 10604802048 1308379712 13.771 100 50 99 0 1325636592 5214352 12042528
14:23:22 3884 8192000000 10211239680 10617921536 1313117232 13.814 100 44 88 0 1333405216 10187056 10100928
14:24:27 14348 8192000000 10208606960 10622902272 1318424272 13.862 100 19 37 0 1332058192 9400672 4233248
14:25:41 8882 8192000000 10206458208 10624946176 1324412160 13.917 100 22 42 1 1335590240 6193488 4984592
14:26:51 25901 8192000000 10222687552 10638782464 1328399216 13.953 100 38 76 0 1343136784 6821872 7915696
14:28:21 6740 8192000000 10222009504 10638585856 1328343904 13.952 100 38 72 1 1342917456 5896624 8676928
14:29:29 6937 8192000000 10210352064 10631913472 1306738048 13.756 98 16 31 0 1316340416 6457408 3144960
14:30:42 84317 8192000000 10231761072 10631286784 1289750624 13.602 97 49 94 2 1312092080 11535552 10805904
14:33:12 33030 8192000000 10241573008 10651869184 1329424848 13.962 100 46 91 1 1356604624 17209648 9970128
14:34:49 11255 8192000000 10218753280 10628145152 1289501840 13.600 97 35 70 1 1310751568 12609872 8639856
14:36:02 21923 8192000000 10235753920 10643533824 1322668720 13.901 100 38 76 0 1346885520 15566864 8649936
14:37:31 15555 8192000000 10243241216 10644922368 1319145632 13.869 100 48 96 0 1351033600 20514368 11373600
14:39:06 12556 8192000000 10231581168 10632814592 1310962160 13.795 100 53 101 2 1341703504 19148096 11593248
14:40:24 15181 8192000000 10221011952 10625601536 1290090448 13.605 98 43 83 1 1316879696 16931488 9857760
14:41:45 5627 8192000000 10245260640 10647793664 1326671136 13.937 100 70 138 0 1364341696 20969872 16700688
14:42:54 6899 8192000000 10250254336 10655604736 1324447312 13.917 100 46 92 0 1356412816 20912576 11052928
14:44:17 7348 8192000000 10240178544 10638671872 1294794896 13.648 98 57 115 0 1334405456 25934896 13675664
14:45:29 6853 8192000000 10258863376 10651344896 1317885792 13.858 100 79 154 1 1363565952 26495056 19185104
14:46:47 1843 8192000000 10279785728 10688106496 1345698816 14.109 100 69 135 3 1382562816 20864832 15999168
14:47:55 3192 8192000000 10299329088 10701230080 1358349008 14.223 100 86 172 0 1404845216 25520928 20975280
14:49:05 4066 8192000000 10320970176 10726989824 1374864048 14.371 100 82 163 0 1421518128 26228640 20425440
14:50:11 7758 8192000000 10312885456 10731667456 1378280720 14.401 100 53 104 0 1421181456 29105616 13795120
14:51:21 19585 8192000000 10299568864 10730676224 1379892144 14.416 100 24 48 0 1409252576 23031856 6328576
14:52:49 16489 8192000000 10299767312 10732761088 1366532832 14.296 99 25 48 0 1400262016 26912016 6817168
14:54:10 3994 8192000000 10334974480 10758098944 1387773744 14.486 100 64 126 1 1436285344 33188528 15323072
14:55:17 13075 8192000000 10327574976 10771193856 1389931696 14.505 100 40 80 2 1436110256 35950768 10227792
14:56:37 7304 8192000000 10316304016 10746241024 1392867344 14.531 100 39 78 0 1421349808 19747680 8734784
14:57:49 19852 8192000000 10300075104 10743541760 1393315904 14.535 100 18 36 1 1410031712 12718304 3997504
14:59:41 3925 8192000000 10341004624 10763141120 1403482336 14.626 100 59 118 2 1436276976 18312768 14481872
15:00:46 81273 8192000000 10321998320 10761240576 1387193024 14.481 98 30 62 0 1413215280 18251104 7771152
15:03:15 20659 8192000000 10330182560 10774269952 1413454432 14.715 100 31 61 0 1443596032 23267056 6874544
15:04:46 31444 8192000000 10317569568 10783137792 1401845008 14.611 100 7 15 0 1422126832 18407248 1874576
15:06:19 68802 8192000000 10306721968 10757373952 1395014800 14.551 99 15 30 1 1416178480 17422928 3740752
15:08:41 45864 8192000000 10297562032 10753683456 1376319504 14.384 98 5 10 0 1384910352 7887024 703824
15:10:27 172460 8192000000 10297720816 10757058560 1358672016 14.225 96 36 72 0 1378198800 11285808 8240976
15:14:24 20993 8192000000 10288767360 10739695616 1379822896 14.415 98 21 41 1 1391697392 7794560 4079936
15:15:47 38560 8192000000 10263941232 10712854528 1353346736 14.178 98 42 85 0 1373044912 10070400 9627776
15:17:32 33961 8192000000 10265115504 10715881472 1353901280 14.183 98 23 46 0 1368458768 9231504 5325984
15:19:09 51066 8192000000 10268887568 10710700032 1358014496 14.220 99 19 38 0 1374746976 12161456 4571024
15:21:42 44135 8192000000 10250222608 10694725632 1314625856 13.828 96 12 24 0 1327123456 9578640 2918960
15:23:27 73729 8192000000 10253462384 10701885440 1327417232 13.944 98 13 26 0 1348964224 18749152 2797840
15:25:59 71709 8192000000 10258487552 10692575232 1294142032 13.642 96 12 25 0 1316661552 19404720 3114800
15:28:17 54021 8192000000 10256909392 10687107072 1304160832 13.733 97 18 36 0 1321180784 12733648 4286304
15:30:11 76101 8192000000 10278898432 10718261248 1335255296 14.015 98 31 61 0 1357636064 15541600 6839168
15:32:37 92816 8192000000 10273271040 10714353664 1355954768 14.201 99 10 20 0 1371824848 13839456 2030624
15:35:12 83761 8192000000 10262190720 10707865600 1352153408 14.167 99 28 55 0 1365550880 7498320 5899152
15:37:52 72745 8192000000 10259761088 10699612160 1315386304 13.835 96 21 42 0 1328322272 8302080 4633888
15:40:08 29535 8192000000 10291594272 10734895104 1374167040 14.364 99 50 98 0 1398979568 13985968 10826560
15:41:40 40929 8192000000 10299366912 10750902272 1393229664 14.535 100 14 28 0 1413134672 16950848 2954160
15:43:26 60213 8192000000 10288614816 10742218752 1362318592 14.258 98 13 26 1 1378442928 13048944 3075392
15:45:43 16387 8192000000 10333225312 10775302144 1415763360 14.735 100 42 85 1 1441772864 15990720 10018784
15:47:01 60358 8192000000 10324998928 10788716544 1406205664 14.650 99 20 40 0 1430099760 18655744 5238352
15:49:09 83353 8192000000 10328509056 10777886720 1385479280 14.466 98 13 26 1 1412651040 23903904 3267856
15:51:32 78495 8192000000 10353443872 10815758336 1421946256 14.790 100 19 38 0 1450699536 24644080 4109200
15:54:50 23149 8192000000 10343617984 10776494080 1417234464 14.748 100 38 76 1 1433822208 7818160 8769584
15:56:14 32619 8192000000 10345170768 10793373696 1419934864 14.772 100 33 66 0 1442544688 14863936 7745888
15:57:47 132764 8192000000 10303626688 10745204736 1371197312 14.338 97 24 46 1 1392781024 16155904 5427808
16:01:02 3580 8192000000 10328776096 10768248832 1410690880 14.690 100 62 122 2 1434547936 9974912 13882144
16:02:07 38818 8192000000 10302355072 10775203840 1394819920 14.549 99 7 14 0 1410085616 13643968 1621728
16:03:46 82821 8192000000 10307269680 10765127680 1360890688 14.245 97 9 19 0 1372572096 9850816 1830592
16:06:09 19649 8192000000 10298133440 10747002880 1378160768 14.400 99 25 50 0 1395299904 11560448 5578688
16:07:31 48932 8192000000 10295486960 10763083776 1381511648 14.430 99 7 14 0 1400001744 17441200 1048896
16:09:35 8767 8192000000 8885966448 9029079040 62175856 0.753 5 2 4 0 65191296 2678784 336656

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:14, from 27-02-2024 16:11:30 to 27-02-2024 16:11:44.

Exceptions occured during test was in run

FB_MNEMONA CNT UNIT FB_GDSCODE
except 1 srv_aggregate_perf_data 335544517
except 139 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 27-02-2024 16:11:45 to 27-02-2024 16:11:47.

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          176446
MON$OLDEST_ACTIVE               176447
MON$OLDEST_SNAPSHOT             176447
MON$NEXT_TRANSACTION            176447
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                       1911776
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.33731 Firebird 3.0
Server version:
Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V3.0.12.33731 Firebird 3.0"
Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-V3.0.12.33731 Firebird 3.0/tcp (mscs-test-161.budzdorov.ru)/P15:C"
Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-V3.0.12.33731 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 Tue Feb 27 16:11:48 2024 
 
Database header page information: 
    Flags            0 
    Generation        92171 
    System Change Number    0 
    Page size        8192 
    ODS version        12.0 
    Oldest transaction    176446 
    Oldest active        176447 
    Oldest snapshot        176447 
    Next transaction    176448 
    Sequence number        0 
    Next attachment ID    713 
    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.55, total records: 7722699 
    Average version length: 48.16, total versions: 55889, 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: 87432 
    Data pages: 87432, average fill: 70% 
    Primary pages: 87432, secondary pages: 0, swept pages: 28104 
    Empty pages: 3, full pages: 58134 
    Fill distribution: 
     0 - 19% = 28 
    20 - 39% = 282 
    40 - 59% = 4277 
    60 - 79% = 82832 
    80 - 99% = 13 
 
    Index DOC_DATA_DOC_WARE_UNQ (0) 
    Root page: 1510614, depth: 3, leaf buckets: 23253, nodes: 7722699 
    Average node length: 18.88, total dup: 0, max dup: 0 
    Average key length: 15.90, compression ratio: 1.70 
    Average prefix length: 14.10, average data length: 12.90 
    Clustering factor: 1701058, ratio: 0.22 
    Fill distribution: 
         0 - 19% = 337 
        20 - 39% = 1846 
        40 - 59% = 4066 
        60 - 79% = 2515 
        80 - 99% = 14489 
 
    Index DOC_DATA_ID_DESC (1) 
    Root page: 1528118, depth: 3, leaf buckets: 13490, nodes: 7722699 
    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: 1523848, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 1643 
        40 - 59% = 1954 
        60 - 79% = 1154 
        80 - 99% = 8739 
 
    Index FK_DOC_DATA_DOC_LIST (2) 
    Root page: 1546711, depth: 3, leaf buckets: 8347, nodes: 7722699 
    Average node length: 6.61, total dup: 5778168, max dup: 49 
    Average key length: 3.63, compression ratio: 2.48 
    Average prefix length: 7.62, average data length: 1.38 
    Clustering factor: 1517025, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 125 
        20 - 39% = 1003 
        40 - 59% = 1344 
        60 - 79% = 999 
        80 - 99% = 4876 
 
DOC_LIST (138) 
    Primary pointer page: 472, Index root page: 473 
    Total formats: 1, used formats: 1 
    Average record length: 56.66, total records: 2235757 
    Average version length: 34.88, total versions: 60665, max versions: 3 
    Average fragment length: 6.00, total fragments: 4, max fragments: 1 
    Average unpacked length: 84.00, compression ratio: 1.48 
    Pointer pages: 18, data page slots: 28784 
    Data pages: 28784, average fill: 72% 
    Primary pages: 28778, secondary pages: 6, swept pages: 13661 
    Empty pages: 6, full pages: 17940 
    Fill distribution: 
     0 - 19% = 25 
    20 - 39% = 162 
    40 - 59% = 2390 
    60 - 79% = 25826 
    80 - 99% = 381 
 
    Index DOC_LIST_ID_DESC (1) 
    Root page: 1541130, depth: 3, leaf buckets: 4558, nodes: 2235757 
    Average node length: 11.41, total dup: 0, max dup: 0 
    Average key length: 8.44, compression ratio: 1.07 
    Average prefix length: 3.55, average data length: 5.45 
    Clustering factor: 688406, ratio: 0.31 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 959 
        40 - 59% = 799 
        60 - 79% = 778 
        80 - 99% = 2022 
 
    Index DOC_LIST_WORKER_OPTYPE (2) 
    Root page: 1544376, depth: 3, leaf buckets: 2544, nodes: 2238014 
    Average node length: 4.97, total dup: 2237115, max dup: 17921 
    Average key length: 2.01, compression ratio: 4.47 
    Average prefix length: 8.99, average data length: 0.01 
    Clustering factor: 1242256, ratio: 0.56 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 317 
        40 - 59% = 1540 
        60 - 79% = 523 
        80 - 99% = 162 
 
    Index FK_DOC_LIST_AGENTS (3) 
    Root page: 1545909, depth: 3, leaf buckets: 2060, nodes: 2235757 
    Average node length: 4.97, total dup: 2235707, max dup: 130316 
    Average key length: 2.01, compression ratio: 4.48 
    Average prefix length: 8.99, average data length: 0.01 
    Clustering factor: 1064589, ratio: 0.48 
    Fill distribution: 
         0 - 19% = 7 
        20 - 39% = 139 
        40 - 59% = 1028 
        60 - 79% = 45 
        80 - 99% = 841 
 
    Index PK_DOC_LIST (0) 
    Root page: 1538187, depth: 3, leaf buckets: 4388, nodes: 2235757 
    Average node length: 11.41, total dup: 0, max dup: 0 
    Average key length: 8.44, compression ratio: 1.07 
    Average prefix length: 3.55, average data length: 5.45 
    Clustering factor: 688406, ratio: 0.31 
    Fill distribution: 
         0 - 19% = 106 
        20 - 39% = 664 
        40 - 59% = 608 
        60 - 79% = 849 
        80 - 99% = 2161 
 
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: 82.57, total records: 400 
    Average version length: 22.78, total versions: 240237, max versions: 629 
    Average fragment length: 2.00, total fragments: 42, max fragments: 1 
    Average unpacked length: 104.00, compression ratio: 1.26 
    Pointer pages: 1, data page slots: 1320 
    Data pages: 1320, average fill: 90% 
    Primary pages: 11, secondary pages: 1309, swept pages: 0 
    Empty pages: 4, full pages: 1314 
    Fill distribution: 
     0 - 19% = 5 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 1 
    80 - 99% = 1314 
 
    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: 7.92, total records: 93312 
    Average version length: 68.28, total versions: 82488, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 88.00, compression ratio: 11.11 
    Pointer pages: 7, data page slots: 3760 
    Data pages: 1720, average fill: 68% 
    Primary pages: 1719, secondary pages: 1, swept pages: 14 
    Empty pages: 163, full pages: 1086 
    Fill distribution: 
     0 - 19% = 242 
    20 - 39% = 159 
    40 - 59% = 138 
    60 - 79% = 227 
    80 - 99% = 954 
 
    Index INVNT_TURNOVER_LOG_WARE_DD_ID (0) 
    Root page: 1704951, depth: 3, leaf buckets: 381, nodes: 93312 
    Average node length: 13.61, total dup: 5437, max dup: 1 
    Average key length: 10.76, compression ratio: 2.51 
    Average prefix length: 19.18, average data length: 7.82 
    Clustering factor: 66270, ratio: 0.71 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 205 
        40 - 59% = 156 
        60 - 79% = 20 
        80 - 99% = 0 
 
MONEY_SALDO (141) 
    Primary pointer page: 478, Index root page: 479 
    Total formats: 1, used formats: 1 
    Average record length: 15.20, total records: 49 
    Average version length: 9.00, total versions: 18161, max versions: 1005 
    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: 64 
    Data pages: 64, average fill: 91% 
    Primary pages: 1, secondary pages: 63, swept pages: 0 
    Empty pages: 0, full pages: 63 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 3 
    80 - 99% = 61 
 
    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: 2.42, total records: 1723 
    Average version length: 43.51, total versions: 1627, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 58.00, compression ratio: 23.94 
    Pointer pages: 1, data page slots: 40 
    Data pages: 39, average fill: 43% 
    Primary pages: 38, secondary pages: 1, swept pages: 8 
    Empty pages: 14, full pages: 13 
    Fill distribution: 
     0 - 19% = 19 
    20 - 39% = 2 
    40 - 59% = 0 
    60 - 79% = 4 
    80 - 99% = 14 
 
    Index MONEY_TURNOVER_LOG_AGENT_OPTYPE (0) 
    Root page: 97717, depth: 2, leaf buckets: 3, nodes: 1723 
    Average node length: 4.19, total dup: 1625, max dup: 162 
    Average key length: 2.61, compression ratio: 7.27 
    Average prefix length: 18.44, average data length: 0.56 
    Clustering factor: 896, ratio: 0.52 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 1 
        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.11, 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.16, total records: 812134 
    Average version length: 25.31, total versions: 67255, max versions: 5 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 54.00, compression ratio: 1.49 
    Pointer pages: 5, data page slots: 8128 
    Data pages: 8128, average fill: 70% 
    Primary pages: 8108, secondary pages: 20, swept pages: 1925 
    Empty pages: 56, full pages: 6705 
    Fill distribution: 
     0 - 19% = 114 
    20 - 39% = 94 
    40 - 59% = 208 
    60 - 79% = 7412 
    80 - 99% = 300 
 
    Index PDISTR_AGENT_ID (2) 
    Root page: 1509308, depth: 2, leaf buckets: 909, nodes: 812134 
    Average node length: 4.87, total dup: 812085, max dup: 151904 
    Average key length: 2.01, compression ratio: 4.48 
    Average prefix length: 8.99, average data length: 0.01 
    Clustering factor: 87835, ratio: 0.11 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 136 
        40 - 59% = 541 
        60 - 79% = 175 
        80 - 99% = 55 
 
    Index PDISTR_SNDOP_RCVOP_SNDID_ASC (0) 
    Root page: 1508613, depth: 3, leaf buckets: 914, nodes: 812134 
    Average node length: 5.89, total dup: 722436, max dup: 42 
    Average key length: 3.03, compression ratio: 7.27 
    Average prefix length: 21.08, average data length: 0.92 
    Clustering factor: 158752, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 97 
        40 - 59% = 371 
        60 - 79% = 113 
        80 - 99% = 333 
 
    Index PDISTR_SNDOP_RCVOP_SNDID_DESC (1) 
    Root page: 1509187, depth: 3, leaf buckets: 959, nodes: 812134 
    Average node length: 5.89, total dup: 722436, max dup: 42 
    Average key length: 3.03, compression ratio: 7.27 
    Average prefix length: 21.08, average data length: 0.92 
    Clustering factor: 160653, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 189 
        40 - 59% = 330 
        60 - 79% = 116 
        80 - 99% = 323 
 
    Index PDISTR_WORKER_SND_ID (3) 
    Root page: 1510178, depth: 3, leaf buckets: 1143, nodes: 812134 
    Average node length: 5.97, total dup: 722436, max dup: 42 
    Average key length: 3.11, compression ratio: 5.47 
    Average prefix length: 16.00, average data length: 1.00 
    Clustering factor: 152893, ratio: 0.19 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 220 
        40 - 59% = 608 
        60 - 79% = 234 
        80 - 99% = 80 
 
PERF_AGG (158) 
    Primary pointer page: 512, Index root page: 513 
    Total formats: 1, used formats: 1 
    Average record length: 62.85, total records: 5463 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 2.77, total fragments: 83, max fragments: 1 
    Average unpacked length: 379.00, compression ratio: 6.03 
    Pointer pages: 1, data page slots: 104 
    Data pages: 104, average fill: 52% 
    Primary pages: 79, secondary pages: 25, swept pages: 54 
    Empty pages: 19, full pages: 66 
    Fill distribution: 
     0 - 19% = 34 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 70 
    80 - 99% = 0 
 
    Index PERF_AGG_UNQ (1) 
    Root page: 1504238, depth: 2, leaf buckets: 6, nodes: 5463 
    Average node length: 5.47, total dup: 0, max dup: 0 
    Average key length: 3.58, compression ratio: 10.05 
    Average prefix length: 34.45, average data length: 1.55 
    Clustering factor: 5199, 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: 5463 
    Average node length: 11.10, 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: 145, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 1 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 7 
 
PERF_ESTIMATED (280) 
    Primary pointer page: 1504218, Index root page: 1504219 
    Total formats: 1, used formats: 1 
    Average record length: 39.12, total records: 80550 
    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: 6, full pages: 776 
    Fill distribution: 
     0 - 19% = 8 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 776 
    80 - 99% = 0 
 
    Index PK_PERF_ESTIMATED (0) 
    Root page: 37139, depth: 2, leaf buckets: 104, nodes: 80550 
    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: 3302, ratio: 0.04 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 1 
        40 - 59% = 1 
        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.12, 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: 139.04, total records: 200872 
    Average version length: 152.43, total versions: 16045, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 12.20 
    Pointer pages: 7, data page slots: 7152 
    Data pages: 4904, average fill: 85% 
    Primary pages: 4904, secondary pages: 0, swept pages: 5 
    Empty pages: 122, full pages: 4752 
    Fill distribution: 
     0 - 19% = 125 
    20 - 39% = 13 
    40 - 59% = 9 
    60 - 79% = 6 
    80 - 99% = 4751 
 
PERF_SPLIT_1 (282) 
    Primary pointer page: 576, Index root page: 577 
    Total formats: 1, used formats: 1 
    Average record length: 140.88, total records: 184739 
    Average version length: 152.88, total versions: 12539, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 12.04 
    Pointer pages: 6, data page slots: 6344 
    Data pages: 4584, average fill: 84% 
    Primary pages: 4583, secondary pages: 1, swept pages: 3 
    Empty pages: 177, full pages: 4362 
    Fill distribution: 
     0 - 19% = 182 
    20 - 39% = 11 
    40 - 59% = 20 
    60 - 79% = 8 
    80 - 99% = 4363 
 
PERF_SPLIT_2 (283) 
    Primary pointer page: 578, Index root page: 579 
    Total formats: 1, used formats: 1 
    Average record length: 124.98, total records: 184684 
    Average version length: 153.75, total versions: 31627, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 13.57 
    Pointer pages: 6, data page slots: 5976 
    Data pages: 4512, average fill: 86% 
    Primary pages: 4512, secondary pages: 0, swept pages: 1 
    Empty pages: 68, full pages: 4325 
    Fill distribution: 
     0 - 19% = 74 
    20 - 39% = 6 
    40 - 59% = 100 
    60 - 79% = 7 
    80 - 99% = 4325 
 
PERF_SPLIT_3 (284) 
    Primary pointer page: 580, Index root page: 581 
    Total formats: 1, used formats: 1 
    Average record length: 142.79, total records: 190774 
    Average version length: 151.65, total versions: 10601, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.88 
    Pointer pages: 7, data page slots: 5352 
    Data pages: 4576, average fill: 86% 
    Primary pages: 4576, secondary pages: 0, swept pages: 2 
    Empty pages: 44, full pages: 4517 
    Fill distribution: 
     0 - 19% = 48 
    20 - 39% = 3 
    40 - 59% = 4 
    60 - 79% = 5 
    80 - 99% = 4516 
 
PERF_SPLIT_4 (285) 
    Primary pointer page: 582, Index root page: 583 
    Total formats: 1, used formats: 1 
    Average record length: 137.47, total records: 168516 
    Average version length: 152.37, total versions: 15166, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 12.34 
    Pointer pages: 8, data page slots: 6416 
    Data pages: 4040, average fill: 87% 
    Primary pages: 4040, secondary pages: 0, swept pages: 1 
    Empty pages: 36, full pages: 3988 
    Fill distribution: 
     0 - 19% = 37 
    20 - 39% = 7 
    40 - 59% = 1 
    60 - 79% = 6 
    80 - 99% = 3989 
 
PERF_SPLIT_5 (286) 
    Primary pointer page: 584, Index root page: 585 
    Total formats: 1, used formats: 1 
    Average record length: 138.99, total records: 187220 
    Average version length: 152.12, total versions: 14887, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 12.20 
    Pointer pages: 6, data page slots: 6384 
    Data pages: 4528, average fill: 86% 
    Primary pages: 4528, secondary pages: 0, swept pages: 1 
    Empty pages: 79, full pages: 4423 
    Fill distribution: 
     0 - 19% = 83 
    20 - 39% = 6 
    40 - 59% = 9 
    60 - 79% = 7 
    80 - 99% = 4423 
 
PERF_SPLIT_6 (287) 
    Primary pointer page: 586, Index root page: 587 
    Total formats: 1, used formats: 1 
    Average record length: 140.18, total records: 176443 
    Average version length: 151.82, total versions: 12469, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 12.10 
    Pointer pages: 7, data page slots: 5456 
    Data pages: 4216, average fill: 87% 
    Primary pages: 4215, secondary pages: 1, swept pages: 1 
    Empty pages: 34, full pages: 4174 
    Fill distribution: 
     0 - 19% = 39 
    20 - 39% = 1 
    40 - 59% = 1 
    60 - 79% = 1 
    80 - 99% = 4174 
 
PERF_SPLIT_7 (288) 
    Primary pointer page: 588, Index root page: 589 
    Total formats: 1, used formats: 1 
    Average record length: 138.41, total records: 175843 
    Average version length: 152.27, total versions: 14373, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 12.25 
    Pointer pages: 7, data page slots: 6744 
    Data pages: 4256, average fill: 86% 
    Primary pages: 4256, secondary pages: 0, swept pages: 4 
    Empty pages: 86, full pages: 4152 
    Fill distribution: 
     0 - 19% = 87 
    20 - 39% = 6 
    40 - 59% = 5 
    60 - 79% = 6 
    80 - 99% = 4152 
 
PERF_SPLIT_8 (289) 
    Primary pointer page: 590, Index root page: 591 
    Total formats: 1, used formats: 1 
    Average record length: 138.17, total records: 182488 
    Average version length: 153.12, total versions: 15429, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 12.28 
    Pointer pages: 7, data page slots: 6616 
    Data pages: 4448, average fill: 85% 
    Primary pages: 4448, secondary pages: 0, swept pages: 1 
    Empty pages: 101, full pages: 4309 
    Fill distribution: 
     0 - 19% = 106 
    20 - 39% = 13 
    40 - 59% = 8 
    60 - 79% = 11 
    80 - 99% = 4310 
 
PERF_SPLIT_9 (290) 
    Primary pointer page: 593, Index root page: 594 
    Total formats: 1, used formats: 1 
    Average record length: 122.15, total records: 213177 
    Average version length: 154.37, total versions: 40923, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 13.88 
    Pointer pages: 7, data page slots: 6400 
    Data pages: 5200, average fill: 86% 
    Primary pages: 5200, secondary pages: 0, swept pages: 1 
    Empty pages: 80, full pages: 5028 
    Fill distribution: 
     0 - 19% = 81 
    20 - 39% = 19 
    40 - 59% = 55 
    60 - 79% = 20 
    80 - 99% = 5025 
 
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: 52.08, total records: 2083510 
    Average version length: 52.88, total versions: 26300, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 70.00, compression ratio: 1.34 
    Pointer pages: 16, data page slots: 25824 
    Data pages: 25816, average fill: 69% 
    Primary pages: 25816, secondary pages: 0, swept pages: 12748 
    Empty pages: 381, full pages: 19418 
    Fill distribution: 
     0 - 19% = 762 
    20 - 39% = 599 
    40 - 59% = 1526 
    60 - 79% = 22732 
    80 - 99% = 197 
 
    Index PSTORNED_RCV_ID (1) 
    Root page: 1506186, depth: 3, leaf buckets: 2589, nodes: 2083510 
    Average node length: 5.44, total dup: 1943480, max dup: 1406 
    Average key length: 2.49, compression ratio: 3.62 
    Average prefix length: 8.58, average data length: 0.42 
    Clustering factor: 180492, ratio: 0.09 
    Fill distribution: 
         0 - 19% = 6 
        20 - 39% = 311 
        40 - 59% = 1693 
        60 - 79% = 293 
        80 - 99% = 286 
 
    Index PSTORNED_SND_ID (0) 
    Root page: 1504819, depth: 3, leaf buckets: 2765, nodes: 2083510 
    Average node length: 5.69, total dup: 1869496, max dup: 63 
    Average key length: 2.74, compression ratio: 3.28 
    Average prefix length: 8.36, average data length: 0.64 
    Clustering factor: 372173, ratio: 0.18 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 7 
        40 - 59% = 2482 
        60 - 79% = 253 
        80 - 99% = 23 
 
    Index PSTORNED_WORKER_ID (2) 
    Root page: 1507996, depth: 3, leaf buckets: 2148, nodes: 2083510 
    Average node length: 4.96, total dup: 2083410, max dup: 28803 
    Average key length: 2.00, compression ratio: 1.20 
    Average prefix length: 2.40, average data length: 0.00 
    Clustering factor: 178362, ratio: 0.09 
    Fill distribution: 
         0 - 19% = 3 
        20 - 39% = 216 
        40 - 59% = 1162 
        60 - 79% = 363 
        80 - 99% = 404 
 
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: 1 
    Empty pages: 0, full pages: 2 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 1 
    60 - 79% = 0 
    80 - 99% = 2 
 
    Index SETTINGS_MCODE_WM_UNQ (1) 
    Root page: 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: 42.57, total records: 130937 
    Average version length: 69.16, total versions: 50434, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 2.96 
    Pointer pages: 3, data page slots: 4864 
    Data pages: 3600, average fill: 42% 
    Primary pages: 3600, secondary pages: 0, swept pages: 1016 
    Empty pages: 1045, full pages: 1392 
    Fill distribution: 
     0 - 19% = 1515 
    20 - 39% = 269 
    40 - 59% = 206 
    60 - 79% = 665 
    80 - 99% = 945 
 
    Index XQD_1000_1200_WA_SO_RO_WKR_SND (0) 
    Root page: 102667, depth: 3, leaf buckets: 208, nodes: 130937 
    Average node length: 6.38, total dup: 113920, max dup: 29 
    Average key length: 3.97, compression ratio: 10.58 
    Average prefix length: 40.16, average data length: 1.84 
    Clustering factor: 22159, ratio: 0.17 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 56 
        40 - 59% = 97 
        60 - 79% = 50 
        80 - 99% = 5 
 
XQD_1000_3300 (178) 
    Primary pointer page: 553, Index root page: 554 
    Total formats: 1, used formats: 1 
    Average record length: 65.76, total records: 7094679 
    Average version length: 68.73, total versions: 329550, 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: 64, data page slots: 103520 
    Data pages: 103520, average fill: 73% 
    Primary pages: 103520, secondary pages: 0, swept pages: 37924 
    Empty pages: 6, full pages: 71346 
    Fill distribution: 
     0 - 19% = 31 
    20 - 39% = 618 
    40 - 59% = 7553 
    60 - 79% = 90911 
    80 - 99% = 4407 
 
    Index XQD_1000_3300_WA_SO_RO_WKR_SND (0) 
    Root page: 1480454, depth: 3, leaf buckets: 10652, nodes: 7094679 
    Average node length: 6.52, total dup: 6131994, max dup: 29 
    Average key length: 3.53, compression ratio: 11.91 
    Average prefix length: 40.61, average data length: 1.39 
    Clustering factor: 1556961, ratio: 0.22 
    Fill distribution: 
         0 - 19% = 9 
        20 - 39% = 1655 
        40 - 59% = 5601 
        60 - 79% = 2823 
        80 - 99% = 564 
 
    Index XQD_1000_3300_WKR_DOC_ASC (1) 
    Root page: 1486068, depth: 3, leaf buckets: 8481, nodes: 7094679 
    Average node length: 5.40, total dup: 6809542, max dup: 159 
    Average key length: 2.41, compression ratio: 7.05 
    Average prefix length: 16.63, average data length: 0.37 
    Clustering factor: 1352025, ratio: 0.19 
    Fill distribution: 
         0 - 19% = 12 
        20 - 39% = 1107 
        40 - 59% = 4648 
        60 - 79% = 1585 
        80 - 99% = 1129 
 
    Index XQD_1000_3300_WKR_DOC_DEC (2) 
    Root page: 1490608, depth: 3, leaf buckets: 8565, nodes: 7094679 
    Average node length: 5.40, total dup: 6809542, max dup: 159 
    Average key length: 2.41, compression ratio: 7.05 
    Average prefix length: 16.63, average data length: 0.37 
    Clustering factor: 1354462, ratio: 0.19 
    Fill distribution: 
         0 - 19% = 9 
        20 - 39% = 1257 
        40 - 59% = 4573 
        60 - 79% = 1598 
        80 - 99% = 1128 
 
XQD_1200_2000 (177) 
    Primary pointer page: 551, Index root page: 552 
    Total formats: 1, used formats: 1 
    Average record length: 67.50, total records: 12088752 
    Average version length: 68.71, total versions: 254842, 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: 168832 
    Data pages: 168832, average fill: 76% 
    Primary pages: 168832, secondary pages: 0, swept pages: 87860 
    Empty pages: 4, full pages: 150792 
    Fill distribution: 
     0 - 19% = 13 
    20 - 39% = 348 
    40 - 59% = 3748 
    60 - 79% = 160227 
    80 - 99% = 4496 
 
    Index XQD_1200_2000_WA_SO_RO_WKR_SND (0) 
    Root page: 1495028, depth: 3, leaf buckets: 18435, nodes: 12088752 
    Average node length: 6.59, total dup: 10530026, max dup: 59 
    Average key length: 3.43, compression ratio: 12.23 
    Average prefix length: 40.70, average data length: 1.30 
    Clustering factor: 2367992, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 23 
        20 - 39% = 2223 
        40 - 59% = 10919 
        60 - 79% = 4514 
        80 - 99% = 756 
 
XQD_2000_3300 (179) 
    Primary pointer page: 555, Index root page: 556 
    Total formats: 1, used formats: 1 
    Average record length: 49.07, total records: 1322054 
    Average version length: 69.11, total versions: 384077, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 2.57 
    Pointer pages: 28, data page slots: 44088 
    Data pages: 28125, average fill: 53% 
    Primary pages: 28124, secondary pages: 1, swept pages: 11486 
    Empty pages: 4136, full pages: 13859 
    Fill distribution: 
     0 - 19% = 7236 
    20 - 39% = 2829 
    40 - 59% = 2418 
    60 - 79% = 9981 
    80 - 99% = 5661 
 
    Index XQD_2000_3300_WA_SO_RO_WKR_SND (0) 
    Root page: 1479712, depth: 3, leaf buckets: 2027, nodes: 1322054 
    Average node length: 5.53, total dup: 1268650, max dup: 49 
    Average key length: 2.58, compression ratio: 16.31 
    Average prefix length: 41.46, average data length: 0.54 
    Clustering factor: 91429, ratio: 0.07 
    Fill distribution: 
         0 - 19% = 11 
        20 - 39% = 828 
        40 - 59% = 893 
        60 - 79% = 259 
        80 - 99% = 36 
 
XQD_2100_3300 (180) 
    Primary pointer page: 557, Index root page: 558 
    Total formats: 1, used formats: 1 
    Average record length: 42.82, total records: 1101929 
    Average version length: 69.12, total versions: 418328, 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: 23, data page slots: 36816 
    Data pages: 30144, average fill: 43% 
    Primary pages: 30144, secondary pages: 0, swept pages: 8066 
    Empty pages: 5873, full pages: 8346 
    Fill distribution: 
     0 - 19% = 9673 
    20 - 39% = 4730 
    40 - 59% = 4709 
    60 - 79% = 5468 
    80 - 99% = 5564 
 
    Index XQD_2100_3300_WA_SO_RO_WKR_SND (0) 
    Root page: 1479207, depth: 3, leaf buckets: 1733, nodes: 1101929 
    Average node length: 5.85, total dup: 1023552, max dup: 99 
    Average key length: 2.92, compression ratio: 14.40 
    Average prefix length: 41.15, average data length: 0.85 
    Clustering factor: 156688, ratio: 0.14 
    Fill distribution: 
         0 - 19% = 3 
        20 - 39% = 630 
        40 - 59% = 821 
        60 - 79% = 245 
        80 - 99% = 34 
 
XQD_3300_3400 (181) 
    Primary pointer page: 559, Index root page: 560 
    Total formats: 1, used formats: 1 
    Average record length: 66.56, total records: 9013373 
    Average version length: 68.95, total versions: 304478, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.89 
    Pointer pages: 88, data page slots: 142944 
    Data pages: 142896, average fill: 67% 
    Primary pages: 142896, secondary pages: 0, swept pages: 73596 
    Empty pages: 307, full pages: 68525 
    Fill distribution: 
     0 - 19% = 1053 
    20 - 39% = 5741 
    40 - 59% = 27464 
    60 - 79% = 105052 
    80 - 99% = 3586 
 
    Index XQD_3300_3400_WA_SO_RO_WKR_SND (0) 
    Root page: 1472590, depth: 3, leaf buckets: 13519, nodes: 9013373 
    Average node length: 6.68, total dup: 7472561, max dup: 27 
    Average key length: 3.67, compression ratio: 11.43 
    Average prefix length: 40.50, average data length: 1.50 
    Clustering factor: 1919668, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 1593 
        40 - 59% = 7073 
        60 - 79% = 4314 
        80 - 99% = 538 
 
XQS_1000_1200 (182) 
    Primary pointer page: 561, Index root page: 562 
    Total formats: 1, used formats: 1 
    Average record length: 82.51, total records: 21160648 
    Average version length: 82.92, total versions: 8091, 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: 318832 
    Data pages: 318832, average fill: 81% 
    Primary pages: 318832, secondary pages: 0, swept pages: 13029 
    Empty pages: 24, full pages: 318598 
    Fill distribution: 
     0 - 19% = 37 
    20 - 39% = 10 
    40 - 59% = 25 
    60 - 79% = 27484 
    80 - 99% = 291276 
 
    Index XQS_1000_1200_DOC_ID (1) 
    Root page: 1426716, depth: 3, leaf buckets: 19456, nodes: 21160648 
    Average node length: 5.72, total dup: 20679557, max dup: 128 
    Average key length: 2.16, compression ratio: 4.16 
    Average prefix length: 8.86, average data length: 0.14 
    Clustering factor: 3284905, ratio: 0.16 
    Fill distribution: 
         0 - 19% = 4 
        20 - 39% = 0 
        40 - 59% = 8249 
        60 - 79% = 580 
        80 - 99% = 10623 
 
    Index XQS_1000_1200_RCV_ID (3) 
    Root page: 1456980, depth: 3, leaf buckets: 17223, nodes: 21160648 
    Average node length: 6.31, total dup: 18595214, max dup: 49 
    Average key length: 2.75, compression ratio: 3.27 
    Average prefix length: 8.37, average data length: 0.63 
    Clustering factor: 918245, ratio: 0.04 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 3 
        40 - 59% = 842 
        60 - 79% = 309 
        80 - 99% = 16067 
 
    Index XQS_1000_1200_SND_ID (2) 
    Root page: 1441073, depth: 3, leaf buckets: 21240, nodes: 21160648 
    Average node length: 6.35, total dup: 18514828, max dup: 29 
    Average key length: 2.79, compression ratio: 3.23 
    Average prefix length: 8.34, average data length: 0.66 
    Clustering factor: 3579663, ratio: 0.17 
    Fill distribution: 
         0 - 19% = 7 
        20 - 39% = 0 
        40 - 59% = 8512 
        60 - 79% = 625 
        80 - 99% = 12096 
 
    Index XQS_1000_1200_WORKER_ID (0) 
    Root page: 1413348, depth: 3, leaf buckets: 16228, nodes: 21160648 
    Average node length: 5.56, total dup: 21160548, max dup: 228721 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.42, average data length: 0.00 
    Clustering factor: 946772, ratio: 0.04 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 15 
        40 - 59% = 3082 
        60 - 79% = 445 
        80 - 99% = 12685 
 
XQS_1000_3300 (184) 
    Primary pointer page: 565, Index root page: 566 
    Total formats: 1, used formats: 1 
    Average record length: 79.47, total records: 9501647 
    Average version length: 82.62, total versions: 338886, 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: 103, data page slots: 167712 
    Data pages: 167664, average fill: 70% 
    Primary pages: 167664, secondary pages: 0, swept pages: 86469 
    Empty pages: 397, full pages: 88668 
    Fill distribution: 
     0 - 19% = 1069 
    20 - 39% = 5450 
    40 - 59% = 27322 
    60 - 79% = 82644 
    80 - 99% = 51179 
 
    Index XQS_1000_3300_DOC_ID (1) 
    Root page: 1367502, depth: 3, leaf buckets: 11380, nodes: 9501647 
    Average node length: 5.38, total dup: 9191756, max dup: 175 
    Average key length: 2.24, compression ratio: 4.02 
    Average prefix length: 8.79, average data length: 0.21 
    Clustering factor: 2097651, ratio: 0.22 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 133 
        40 - 59% = 8522 
        60 - 79% = 2667 
        80 - 99% = 57 
 
    Index XQS_1000_3300_RCV_ID (3) 
    Root page: 1379261, depth: 3, leaf buckets: 13503, nodes: 9501647 
    Average node length: 6.25, total dup: 7873251, max dup: 14 
    Average key length: 3.10, compression ratio: 2.90 
    Average prefix length: 8.07, average data length: 0.93 
    Clustering factor: 1455144, ratio: 0.15 
    Fill distribution: 
         0 - 19% = 119 
        20 - 39% = 4302 
        40 - 59% = 4172 
        60 - 79% = 2607 
        80 - 99% = 2303 
 
    Index XQS_1000_3300_SND_ID (2) 
    Root page: 1373059, depth: 3, leaf buckets: 12707, nodes: 9501647 
    Average node length: 6.00, total dup: 8235606, max dup: 36 
    Average key length: 2.86, compression ratio: 3.15 
    Average prefix length: 8.28, average data length: 0.72 
    Clustering factor: 2283185, ratio: 0.24 
    Fill distribution: 
         0 - 19% = 4 
        20 - 39% = 153 
        40 - 59% = 9588 
        60 - 79% = 2886 
        80 - 99% = 76 
 
    Index XQS_1000_3300_WORKER_ID (0) 
    Root page: 1362767, depth: 3, leaf buckets: 10006, nodes: 9501647 
    Average node length: 5.14, total dup: 9501547, max dup: 142590 
    Average key length: 2.00, compression ratio: 1.20 
    Average prefix length: 2.40, average data length: 0.00 
    Clustering factor: 1486811, ratio: 0.16 
    Fill distribution: 
         0 - 19% = 47 
        20 - 39% = 1319 
        40 - 59% = 4831 
        60 - 79% = 1751 
        80 - 99% = 2058 
 
XQS_1200_2000 (183) 
    Primary pointer page: 563, Index root page: 564 
    Total formats: 1, used formats: 1 
    Average record length: 80.71, total records: 11113215 
    Average version length: 82.56, total versions: 214421, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.56 
    Pointer pages: 119, data page slots: 192864 
    Data pages: 191576, average fill: 71% 
    Primary pages: 191576, secondary pages: 0, swept pages: 85282 
    Empty pages: 2736, full pages: 131639 
    Fill distribution: 
     0 - 19% = 5356 
    20 - 39% = 9383 
    40 - 59% = 21933 
    60 - 79% = 49921 
    80 - 99% = 104983 
 
    Index XQS_1200_2000_DOC_ID (1) 
    Root page: 1392101, depth: 3, leaf buckets: 13127, nodes: 11113215 
    Average node length: 5.32, total dup: 11003080, max dup: 658 
    Average key length: 2.08, compression ratio: 4.32 
    Average prefix length: 8.93, average data length: 0.07 
    Clustering factor: 2321439, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 188 
        40 - 59% = 9344 
        60 - 79% = 3491 
        80 - 99% = 103 
 
    Index XQS_1200_2000_RCV_ID (3) 
    Root page: 1406110, depth: 3, leaf buckets: 10369, nodes: 11113215 
    Average node length: 5.51, total dup: 10627144, max dup: 49 
    Average key length: 2.28, compression ratio: 3.95 
    Average prefix length: 8.77, average data length: 0.23 
    Clustering factor: 710021, ratio: 0.06 
    Fill distribution: 
         0 - 19% = 149 
        20 - 39% = 923 
        40 - 59% = 2513 
        60 - 79% = 1865 
        80 - 99% = 4919 
 
    Index XQS_1200_2000_SND_ID (2) 
    Root page: 1398638, depth: 3, leaf buckets: 15015, nodes: 11113215 
    Average node length: 6.05, total dup: 9687091, max dup: 67 
    Average key length: 2.81, compression ratio: 3.20 
    Average prefix length: 8.32, average data length: 0.68 
    Clustering factor: 2337631, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 240 
        40 - 59% = 10787 
        60 - 79% = 3866 
        80 - 99% = 121 
 
    Index XQS_1200_2000_WORKER_ID (0) 
    Root page: 1386211, depth: 3, leaf buckets: 10693, nodes: 11113215 
    Average node length: 5.24, total dup: 11113115, max dup: 174567 
    Average key length: 2.00, compression ratio: 1.20 
    Average prefix length: 2.41, average data length: 0.00 
    Clustering factor: 698342, ratio: 0.06 
    Fill distribution: 
         0 - 19% = 96 
        20 - 39% = 937 
        40 - 59% = 4654 
        60 - 79% = 1566 
        80 - 99% = 3440 
 
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.93, total records: 9602588 
    Average version length: 82.91, total versions: 325372, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.58 
    Pointer pages: 106, data page slots: 171552 
    Data pages: 171528, average fill: 69% 
    Primary pages: 171528, secondary pages: 0, swept pages: 90968 
    Empty pages: 414, full pages: 87066 
    Fill distribution: 
     0 - 19% = 1250 
    20 - 39% = 6245 
    40 - 59% = 30129 
    60 - 79% = 83351 
    80 - 99% = 50553 
 
    Index XQS_2100_3300_DOC_ID (1) 
    Root page: 1344686, depth: 3, leaf buckets: 11793, nodes: 9602588 
    Average node length: 5.19, total dup: 9573384, max dup: 1530 
    Average key length: 2.03, compression ratio: 4.43 
    Average prefix length: 8.97, average data length: 0.03 
    Clustering factor: 1891641, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 33 
        20 - 39% = 1614 
        40 - 59% = 7843 
        60 - 79% = 1759 
        80 - 99% = 544 
 
    Index XQS_2100_3300_RCV_ID (3) 
    Root page: 1355717, depth: 3, leaf buckets: 13569, nodes: 9602588 
    Average node length: 6.26, total dup: 7956132, max dup: 14 
    Average key length: 3.11, compression ratio: 2.90 
    Average prefix length: 8.07, average data length: 0.93 
    Clustering factor: 1416763, ratio: 0.15 
    Fill distribution: 
         0 - 19% = 180 
        20 - 39% = 4205 
        40 - 59% = 4071 
        60 - 79% = 2623 
        80 - 99% = 2490 
 
    Index XQS_2100_3300_SND_ID (2) 
    Root page: 1350049, depth: 3, leaf buckets: 12443, nodes: 9602588 
    Average node length: 5.45, total dup: 9167629, max dup: 99 
    Average key length: 2.29, compression ratio: 3.93 
    Average prefix length: 8.75, average data length: 0.25 
    Clustering factor: 2023571, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 28 
        20 - 39% = 1625 
        40 - 59% = 8663 
        60 - 79% = 1583 
        80 - 99% = 544 
 
    Index XQS_2100_3300_WORKER_ID (0) 
    Root page: 985805, depth: 3, leaf buckets: 10073, nodes: 9602588 
    Average node length: 5.16, total dup: 9602488, max dup: 144981 
    Average key length: 2.00, compression ratio: 1.20 
    Average prefix length: 2.40, average data length: 0.00 
    Clustering factor: 1503247, ratio: 0.16 
    Fill distribution: 
         0 - 19% = 44 
        20 - 39% = 1238 
        40 - 59% = 4935 
        60 - 79% = 1763 
        80 - 99% = 2093 
 
XQS_3300_3400 (187) 
    Primary pointer page: 571, Index root page: 572 
    Total formats: 1, used formats: 1 
    Average record length: 67.54, total records: 573646 
    Average version length: 68.80, total versions: 5325, 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: 8056 
    Data pages: 8056, average fill: 75% 
    Primary pages: 8056, secondary pages: 0, swept pages: 4487 
    Empty pages: 7, full pages: 6220 
    Fill distribution: 
     0 - 19% = 8 
    20 - 39% = 21 
    40 - 59% = 251 
    60 - 79% = 7719 
    80 - 99% = 57 
 
    Index XQS_3300_3400_DOC_ID (1) 
    Root page: 42691, depth: 3, leaf buckets: 733, nodes: 573646 
    Average node length: 5.95, total dup: 488133, max dup: 87 
    Average key length: 3.10, compression ratio: 2.91 
    Average prefix length: 8.05, average data length: 0.95 
    Clustering factor: 99764, ratio: 0.17 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 29 
        40 - 59% = 523 
        60 - 79% = 84 
        80 - 99% = 97 
 
    Index XQS_3300_3400_SND_ID (2) 
    Root page: 26341, depth: 3, leaf buckets: 755, nodes: 573646 
    Average node length: 6.15, total dup: 470380, max dup: 23 
    Average key length: 3.29, compression ratio: 2.73 
    Average prefix length: 7.88, average data length: 1.12 
    Clustering factor: 99818, ratio: 0.17 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 31 
        40 - 59% = 542 
        60 - 79% = 76 
        80 - 99% = 106 
 
    Index XQS_3300_3400_WORKER_ID (0) 
    Root page: 375548, depth: 2, leaf buckets: 567, nodes: 573646 
    Average node length: 4.86, total dup: 573546, max dup: 9162 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.41, average data length: 0.00 
    Clustering factor: 88706, ratio: 0.15 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 43 
        40 - 59% = 323 
        60 - 79% = 73 
        80 - 99% = 128 
 
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 Tue Feb 27 16:12:11 2024

Record versions statistics, table

TABLE_NAME TOTAL_RECS TOTAL_VERS MAX_VERSIONS VERS_TO_RECS_PRC MAXV_TO_VERS_PRC
DOC_DATA 7722699 55889 1 0.0000 0.0000
DOC_LIST 2235757 60665 3 0.0000 0.0000
FB_ERRORS 2182 757 1 0.0000 0.0000
INVNT_SALDO 400 240237 629 60000.0000 0.0000
INVNT_TURNOVER_LOG 93312 82488 1 0.0000 0.0000
MONEY_SALDO 49 18161 1005 37000.0000 0.0000
MONEY_TURNOVER_LOG 1723 1627 1 0.0000 0.0000
PDISTR 812134 67255 5 0.0000 0.0000
PERF_SPLIT_0 200872 16045 1 0.0000 0.0000
PERF_SPLIT_1 184739 12539 1 0.0000 0.0000
PERF_SPLIT_2 184684 31627 1 0.0000 0.0000
PERF_SPLIT_3 190774 10601 1 0.0000 0.0000
PERF_SPLIT_4 168516 15166 1 0.0000 0.0000
PERF_SPLIT_5 187220 14887 1 0.0000 0.0000
PERF_SPLIT_6 176443 12469 1 0.0000 0.0000
PERF_SPLIT_7 175843 14373 1 0.0000 0.0000
PERF_SPLIT_8 182488 15429 1 0.0000 0.0000
PERF_SPLIT_9 213177 40923 1 0.0000 0.0000
PSTORNED 2083510 26300 1 0.0000 0.0000
SEMAPHORES 5 1 1 0.0000 100.0000
XQD_1000_1200 130937 50434 1 0.0000 0.0000
XQD_1000_3300 7094679 329550 1 0.0000 0.0000
XQD_1200_2000 12088752 254842 1 0.0000 0.0000
XQD_2000_3300 1322054 384077 1 0.0000 0.0000
XQD_2100_3300 1101929 418328 1 0.0000 0.0000
XQD_3300_3400 9013373 304478 1 0.0000 0.0000
XQS_1000_1200 21160648 8091 1 0.0000 0.0000
XQS_1000_3300 9501647 338886 1 0.0000 0.0000
XQS_1200_2000 11113215 214421 1 0.0000 0.0000
XQS_2100_3300 9602588 325372 1 0.0000 0.0000
XQS_3300_3400 573646 5325 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 ---
:1232: 
:1233: mscs-test-161.budzdorov.ru    Tue Feb 27 16:09:47 2024
:1234:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:1235: 
--- end of diff output ---

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

27.02.24 16:12:23. 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-02-27 16:12:26 No severe PSQL-related problems occured
27.02.24 16:12:27. End of report.