Generated by /opt/oltp-emul/oltp_isql_run_worker.sh, ISQL session No. 1 of total launched 100. 14.04.2024 01: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 15372324 kB
MemAvailable 30001744 kB
Buffers 0 kB
Cached 16312032 kB
SwapCached 2744 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-04-14 01:09:50
DTS_END                         2024-04-14 01:09:50.3660
FB_GDSCODE                      -1
FB_MNEMONA                      
STACK                           SP_SUPPLIER_INVOICE(39:5) ==> X_MAKE_QSTORNO_1200_2000(279:25) ==> SP_CHECK_TO_STOP_WORK(32:12) ==> SP_HALT_ON_ERROR(57:17)
IP                              ::1/55784
TRN_ID                          179666
ATT_ID                          607
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: 9252.98 20852 925298
customer order: creation 180.14 351 18014
customer order: refuse 14.78 394 1478
order to supplier: creation 47.77 1284 4777
order to supplier: removal 3.54 109452 354
invoice (draft): creation 47.47 3432 4747
invoice (draft): removal 50.28 868 5028
invoice accept: apply 43.64 21970 4364
invoice accept: cancel 45.23 1003 4523
customer reserve: creation 4094.24 215 409424
customer reserve: removal 4427.11 67 442711
realization accept: apply 87.99 215 8799
realization accept: cancel 76.74 128 7674
payment from customer: creation 61.62 133 6162
payment from customer: removal 5.80 93 580
payment to supplier: creation 50.12 178 5012
payment to supplier: removal 3.32 64 332
service: total inventory turnovers 5.18 1004 518
service: total monetary turnovers 7.10 48 710
service: aggregate perf. data 0.88 17539 88
service: refresh index statistics 0.03 258602 3

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:02, from 14-04-2024 01:11:06 to 14-04-2024 01:11:08.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 2946
TEST_TIME 2 1747
TEST_TIME 3 1797
TEST_TIME 4 4193
TEST_TIME 5 4320
TEST_TIME 6 4877
TEST_TIME 7 4932
TEST_TIME 8 4868
TEST_TIME 9 5019
TEST_TIME 10 4966
TEST_TIME 11 5382
TEST_TIME 12 6040
TEST_TIME 13 6240
TEST_TIME 14 7002
TEST_TIME 15 7061
TEST_TIME 16 7023
TEST_TIME 17 6968
TEST_TIME 18 6967
TEST_TIME 19 7160
TEST_TIME 20 7370
TEST_TIME 21 7560
TEST_TIME 22 7738
TEST_TIME 23 7711
TEST_TIME 24 7893
TEST_TIME 25 7780
TEST_TIME 26 8036
TEST_TIME 27 7880
TEST_TIME 28 7807
TEST_TIME 29 8065
TEST_TIME 30 8379
TEST_TIME 31 8892
TEST_TIME 32 9098
TEST_TIME 33 9343
TEST_TIME 34 9286
TEST_TIME 35 9280
TEST_TIME 36 9095
TEST_TIME 37 9253
TEST_TIME 38 9279
TEST_TIME 39 9392
TEST_TIME 40 9297
TEST_TIME 41 9391
TEST_TIME 42 9503
TEST_TIME 43 9427
TEST_TIME 44 9296
TEST_TIME 45 9203
TEST_TIME 46 9117
TEST_TIME 47 9215
TEST_TIME 48 9189
TEST_TIME 49 9210
TEST_TIME 50 9129
TEST_TIME 51 9198
TEST_TIME 52 9101
TEST_TIME 53 9066
TEST_TIME 54 8982
TEST_TIME 55 8931
TEST_TIME 56 8935
TEST_TIME 57 8987
TEST_TIME 58 8979
TEST_TIME 59 8906
TEST_TIME 60 8888
TEST_TIME 61 8934
TEST_TIME 62 8906
TEST_TIME 63 8889
TEST_TIME 64 8965
TEST_TIME 65 8953
TEST_TIME 66 8967
TEST_TIME 67 8977
TEST_TIME 68 9070
TEST_TIME 69 9070
TEST_TIME 70 9144
TEST_TIME 71 9109
TEST_TIME 72 9180
TEST_TIME 73 9294
TEST_TIME 74 9284
TEST_TIME 75 9310
TEST_TIME 76 9272
TEST_TIME 77 9216
TEST_TIME 78 9182
TEST_TIME 79 9163
TEST_TIME 80 9129
TEST_TIME 81 9138
TEST_TIME 82 9119
TEST_TIME 83 9081
TEST_TIME 84 9033
TEST_TIME 85 9026
TEST_TIME 86 9092
TEST_TIME 87 9094
TEST_TIME 88 9092
TEST_TIME 89 9118
TEST_TIME 90 9093
TEST_TIME 91 9140
TEST_TIME 92 9108
TEST_TIME 93 9242
TEST_TIME 94 9218
TEST_TIME 95 9160
TEST_TIME 96 9287
TEST_TIME 97 9291
TEST_TIME 98 9359
TEST_TIME 99 9343
TEST_TIME 100 9257
TEST_TIME 101 9166

Performance per minute, chart


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

Performance in DETAILS

UNIT CNT_ALL CNT_OK CNT_ERR ERR_PRC OK_MIN_MS OK_MAX_MS OK_AVG_MS CNT_LK_CONFL CNT_USER_EXC
doc_list_aiud 1300157 1300157 0 0.00 0 26861 8 0 0
doc_list_biud 1300155 1300155 0 0.00 0 34747 29 0 0
sp_add_invoice_to_stock 4464 4364 100 2.24 35 203062 21970 0 100
sp_cancel_adding_invoice 4523 4523 0 0.00 3 71191 1004 0 0
sp_cancel_client_order 1478 1478 0 0.00 4 14003 395 0 0
sp_cancel_customer_reserve 442711 442711 0 0.00 1 34753 67 0 0
sp_cancel_pay_from_customer 580 580 0 0.00 2 5452 94 0 0
sp_cancel_pay_to_supplier 332 332 0 0.00 3 976 65 0 0
sp_cancel_supplier_invoice 5036 5028 8 0.15 1 34694 868 0 8
sp_cancel_supplier_order 354 354 0 0.00 6 796637 109453 0 0
sp_cancel_write_off 7674 7674 0 0.00 1 12156 128 0 0
sp_client_order 18014 18014 0 0.00 3 26864 351 0 0
sp_customer_reserve 409424 409424 0 0.00 0 56794 216 0 0
sp_fill_shopping_cart 27535 27535 0 0.00 1 12987 37 0 0
sp_fill_shopping_cart_clo_res 409416 409416 0 0.00 0 15146 13 0 0
sp_get_clo_for_invoice 4353 4353 0 0.00 0 18609 236 0 0
sp_kill_cost_storno 13109 13109 0 0.00 0 5484 65 0 0
sp_kill_qstorno_ret_qs2qd 898478 898478 0 0.00 0 34745 36 0 0
sp_kill_qty_storno 474919 474919 0 0.00 0 34747 79 0 0
sp_lock_selected_doc 18107 18107 0 0.00 0 6392 5 0 0
sp_make_cost_storno 24325 24325 0 0.00 0 26840 85 0 0
sp_multiply_rows_for_pdistr 24324 24324 0 0.00 0 16525 29 0 0
sp_multiply_rows_for_qdistr 18014 18014 0 0.00 0 15296 129 0 0
sp_pay_from_customer 6162 6162 0 0.00 4 25805 134 0 0
sp_pay_to_supplier 5012 5012 0 0.00 5 26601 178 0 0
sp_payment_common 11173 11173 0 0.00 1 24898 28 0 0
sp_qd_handle_on_cancel_clo 1478 1478 0 0.00 0 13997 368 0 0
sp_qd_handle_on_invoice_upd_sts 8875 8875 0 0.00 0 26234 394 0 0
sp_qd_handle_on_reserve_upd_sts 8799 8799 0 0.00 0 22750 66 0 0
sp_reserve_write_off 8799 8799 0 0.00 6 26744 215 0 0
sp_supplier_invoice 4747 4747 0 0.00 6 99170 3433 0 0
sp_supplier_order 4777 4777 0 0.00 5 36020 1284 0 0
srv_aggregate_perf_data 88 88 0 0.00 2172 254889 17539 0 0
srv_fill_mon_cache_memory 57 57 0 0.00 1595 112398 37947 0 0
srv_find_qd_qs_mism 881500 881500 0 0.00 0 19694 7 0 0
srv_make_invnt_saldo 518 518 0 0.00 39 27160 1005 0 0
srv_make_money_saldo 710 710 0 0.00 0 6846 48 0 0
srv_recalc_idx_stat 3 3 0 0.00 118939 519763 258602 0 0
t$perf-abend:sp_add_invoice_to_stock 100 100 0 0.00 0 0 0 0 0
t$perf-abend:sp_cancel_supplier_invoice 8 8 0 0.00 0 0 0 0 0
t$perf-norm:sp_add_invoice_to_stock 4364 4364 0 0.00 0 17419 220 0 0
t$perf-norm:sp_cancel_adding_invoice 357 357 0 0.00 0 4644 102 0 0
t$perf-norm:sp_cancel_client_order 1478 1478 0 0.00 0 1416 13 0 0
t$perf-norm:sp_cancel_customer_reserve 655 655 0 0.00 0 1167 12 0 0
t$perf-norm:sp_cancel_pay_from_customer 580 580 0 0.00 0 11115 28 0 0
t$perf-norm:sp_cancel_pay_to_supplier 332 332 0 0.00 0 118 2 0 0
t$perf-norm:sp_cancel_supplier_invoice 351 351 0 0.00 0 548 14 0 0
t$perf-norm:sp_cancel_supplier_order 354 354 0 0.00 0 28754 2273 0 0
t$perf-norm:sp_cancel_write_off 852 852 0 0.00 0 3482 15 0 0
t$perf-norm:sp_client_order 18014 18014 0 0.00 0 10750 18 0 0
t$perf-norm:sp_customer_reserve 819 819 0 0.00 0 2156 11 0 0
t$perf-norm:sp_pay_from_customer 6162 6162 0 0.00 0 19639 13 0 0
t$perf-norm:sp_pay_to_supplier 5012 5012 0 0.00 0 15415 16 0 0
t$perf-norm:sp_reserve_write_off 8799 8799 0 0.00 0 9165 12 0 0
t$perf-norm:sp_supplier_invoice 4747 4747 0 0.00 0 13145 23 0 0
t$perf-norm:sp_supplier_order 4777 4777 0 0.00 0 5261 26 0 0
t$perf-norm:srv_aggregate_perf_data 88 88 0 0.00 0 309 9 0 0
t$perf-norm:srv_fill_mon_cache_memory 57 57 0 0.00 0 19 1 0 0
t$perf-norm:srv_make_invnt_saldo 518 518 0 0.00 0 780 27 0 0
t$perf-norm:srv_make_money_saldo 710 710 0 0.00 0 2478 25 0 0
t$perf-norm:srv_recalc_idx_stat 3 3 0 0.00 1 3 2 0 0
v_add_invoice_to_stock 8902 8702 200 2.24 0 12297 21 0 200
v_all_customers 32936 32936 0 0.00 0 28 1 0 0
v_all_suppliers 26792 26792 0 0.00 0 31 1 0 0
v_all_wares 36024 36024 0 0.00 0 18 1 0 0
v_cancel_adding_invoice 714 714 0 0.00 0 571 8 0 0
v_cancel_client_order 2956 2956 0 0.00 0 1069 3 0 0
v_cancel_customer_prepayment 1160 1160 0 0.00 0 710 6 0 0
v_cancel_customer_reserve 1310 1310 0 0.00 0 378 4 0 0
v_cancel_payment_to_supplier 664 664 0 0.00 0 542 4 0 0
v_cancel_supplier_invoice 718 702 16 2.22 0 2077 17 0 16
v_cancel_supplier_order 708 708 0 0.00 0 1848 9 0 0
v_cancel_write_off 1704 1704 0 0.00 0 9287 21 0 0
v_max_id_clo_ord 4776 4776 0 0.00 0 640 2 0 0
v_max_id_clo_res 819 819 0 0.00 0 1908 12 0 0
v_max_id_ord_sup 4746 4746 0 0.00 0 2808 4 0 0
v_max_non_paid_invoice 1137 1137 0 0.00 0 215 3 0 0
v_max_non_paid_realizn 3099 3099 0 0.00 0 1219 5 0 0
v_min_id_clo_ord 4776 4776 0 0.00 0 4089 7 0 0
v_min_id_clo_res 819 819 0 0.00 0 351 3 0 0
v_min_id_ord_sup 4746 4746 0 0.00 0 8568 8 0 0
v_min_non_paid_invoice 5011 5011 0 0.00 0 4471 14 0 0
v_min_non_paid_realizn 6162 6162 0 0.00 0 9601 20 0 0
v_our_firm 9214 9214 0 0.00 0 15 1 0 0
v_reserve_write_off 17594 17594 0 0.00 0 2850 5 0 0
x_lock_depdocs_on_canc_invoice 9200 9200 0 0.00 0 29484 166 0 0
x_lock_depdocs_on_canc_sup_ord 354 354 0 0.00 0 14874 434 0 0
x_make_qstorno_1000_1200 4777 4777 0 0.00 1 35987 1192 0 0
x_make_qstorno_1200_2000 4747 4747 0 0.00 2 98680 3307 0 0
x_make_qstorno_2100_3300 409424 409424 0 0.00 0 56793 199 0 0

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

Memory consumption, metadata cache, attachments activity 

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


Page cache type: shared, buffers: 1000000 for all connections, with total size: 8192000000
measurement_dts measurement duration ms page cache memo used memo used, total memo allocated, total metadata cache metadata cache percent of total total attachments cnt active attachments cnt running statements cnt stalled statements cnt memo used by attachments memo used by transactions memo used by statements
23:09:53 2 8192000000 8797116944 8807743488 3953616 0.048 1 1 2 0 4051888 55488 42784
23:10:54 32482 8192000000 9909715120 10218004480 994213104 10.822 100 89 180 0 1023548064 5673728 23661232
23:12:30 17063 8192000000 9949594512 10269921280 1032913216 11.196 100 91 182 0 1064239744 8165760 23160768
23:13:54 18728 8192000000 9979689136 10309881856 1061630336 11.472 100 88 176 0 1093257216 9251840 22375040
23:15:16 12864 8192000000 10036354832 10385227776 1124653024 12.071 100 74 147 0 1152539664 10379856 17506784
23:16:31 4735 8192000000 10078769424 10442887168 1175806320 12.551 100 70 140 0 1202876848 11645376 15425152
23:17:39 3137 8192000000 10137143600 10507177984 1222035712 12.980 100 83 166 1 1254152000 13740192 18376096
23:18:46 3866 8192000000 10163803360 10540814336 1254500464 13.280 100 74 146 0 1283112224 12868784 15742976
23:19:52 913 8192000000 10199302592 10579144704 1284973760 13.558 100 93 185 0 1319912960 13485040 21454160
23:20:55 1528 8192000000 10213413392 10599084032 1299328272 13.689 100 88 176 0 1333167920 14659104 19180544
23:21:58 2989 8192000000 10206282464 10605363200 1305491120 13.745 100 56 111 1 1325262256 7439920 12331216
23:23:03 3759 8192000000 10202407504 10615107584 1314049824 13.823 100 41 80 2 1330736896 8048912 8638160
23:24:10 6445 8192000000 10213937392 10629677056 1324442672 13.917 100 28 56 1 1336878992 6315072 6121248
23:25:17 18151 8192000000 10214710976 10637918208 1329786992 13.965 100 15 30 1 1339424256 6320720 3316544
23:26:37 31808 8192000000 10250781760 10655604736 1337845664 14.038 100 67 136 3 1360150944 5666384 16638896
23:28:10 3890 8192000000 10237326128 10655248384 1338230128 14.041 100 25 50 0 1354945920 11541968 5173824
23:29:16 18644 8192000000 10200352384 10619023360 1295128576 13.651 97 27 54 0 1306728208 5071088 6528544
23:30:43 112398 8192000000 10236708656 10649018368 1311489776 13.800 98 49 98 0 1331877824 9256352 11131696
23:33:40 7942 8192000000 10221561008 10625105920 1285924592 13.567 97 52 104 1 1312022016 13924880 12172544
23:34:53 14002 8192000000 10231494192 10633826304 1317810896 13.857 100 60 120 1 1345931840 14837648 13283296
23:36:11 18863 8192000000 10225547008 10632540160 1295549472 13.655 97 43 84 0 1317587328 12190192 9847664
23:37:40 10516 8192000000 10232493456 10639880192 1304367056 13.735 98 56 111 1 1333218624 16346944 12504624
23:38:54 8748 8192000000 10235813536 10643193856 1316524224 13.845 99 54 108 0 1345540416 16231120 12785072
23:40:07 8254 8192000000 10241288464 10642305024 1313266528 13.816 99 59 117 0 1344737376 18048976 13421872
23:41:22 9680 8192000000 10236084016 10632413184 1299125648 13.687 99 58 112 0 1331895712 18634656 14135408
23:42:34 3351 8192000000 10247245600 10654130176 1325014512 13.922 100 46 92 2 1356195392 19910112 11270768
23:43:44 1608 8192000000 10258973136 10656235520 1333033936 13.995 100 80 160 0 1369962480 17332496 19596048
23:44:50 4085 8192000000 10264794256 10665705472 1339180976 14.050 100 68 136 0 1370514176 15352000 15981200
23:45:58 2000 8192000000 10279157824 10680217600 1351745232 14.163 100 78 152 4 1385424688 15544528 18134928
23:47:06 5249 8192000000 10302050352 10704531456 1367954384 14.309 100 85 170 1 1407177792 19168576 20054832
23:48:19 1595 8192000000 10311227296 10717925376 1380044960 14.417 100 76 152 3 1420643632 21891088 18707584
23:49:26 10268 8192000000 10319898928 10728751104 1382166736 14.436 100 75 150 0 1425370864 24891104 18313024
23:50:49 2082 8192000000 10347178848 10754973696 1398179968 14.579 100 85 169 0 1448442448 30023232 20239248
23:51:56 4177 8192000000 10350945760 10766934016 1411310352 14.696 100 62 124 3 1455781552 28525456 15945744
23:53:07 1772 8192000000 10378359200 10792341504 1422103968 14.791 100 82 160 0 1478272224 35287680 20880576
23:54:17 4120 8192000000 10364671168 10790363136 1426762048 14.833 100 52 102 0 1472316512 32086544 13467920
23:55:29 13826 8192000000 10364697184 10805202944 1429034192 14.853 100 33 66 0 1477002176 38075440 9892544
23:57:18 15467 8192000000 10351683440 10788315136 1398179392 14.579 99 30 60 1 1448295232 41012896 9102944
23:58:47 35458 8192000000 10327872608 10791313408 1400612816 14.600 100 30 60 1 1454640992 45026192 9001984
00:00:49 21296 8192000000 10319438032 10775801856 1395609136 14.556 100 25 50 0 1428719264 26593504 6516624
00:02:11 59491 8192000000 10296036944 10754961408 1383241216 14.446 99 13 26 0 1401875888 15510240 3124432
00:04:13 54289 8192000000 10314002304 10756214784 1397021344 14.568 100 14 28 0 1411563600 11315152 3227104
00:06:16 16002 8192000000 10316842368 10772471808 1407650704 14.663 100 18 34 0 1424177792 12540992 3986096
00:07:35 106409 8192000000 10320909040 10769825792 1384384832 14.456 98 7 14 0 1403814560 18035424 1394304
00:10:23 63616 8192000000 10303524688 10752196608 1340576816 14.063 95 16 32 0 1352992064 8674592 3740656
00:12:29 48366 8192000000 10313849136 10758320128 1393696448 14.539 99 31 62 1 1410630352 10114864 6819040
00:14:22 59710 8192000000 10293920336 10738200576 1357879056 14.218 97 34 66 0 1374858704 9386800 7592848
00:17:00 21720 8192000000 10275564736 10724884480 1359743392 14.235 99 14 28 0 1373857904 11229808 2884704
00:18:23 10534 8192000000 10295896608 10743173120 1386353584 14.473 100 32 64 0 1405701952 11388752 7959616
00:19:52 29851 8192000000 10279292864 10734026752 1356473728 14.206 98 13 26 0 1374023360 14547360 3002272
00:21:23 32982 8192000000 10265154128 10700521472 1322014880 13.895 96 48 95 0 1346334864 13644800 10675184
00:24:01 44031 8192000000 10241269152 10684682240 1313816896 13.821 97 13 26 0 1332914736 15893632 3204208
00:25:55 84937 8192000000 10238381584 10685698048 1321931424 13.894 98 21 38 0 1338309088 12175216 4202448
00:28:24 83369 8192000000 10233368320 10687594496 1313855536 13.821 97 18 31 1 1328742112 11289280 3597296
00:30:54 54318 8192000000 10244249472 10696986624 1327036304 13.940 99 12 24 1 1338780080 9443696 2300080
00:32:49 32190 8192000000 10248882208 10689490944 1332202080 13.987 100 35 69 1 1356044000 15839120 8002800
00:34:22 11741 8192000000 10264664384 10695806976 1346583152 14.117 100 43 85 1 1364868432 8645264 9640016
00:35:35 56767 8192000000 10242786176 10680623104 1321992864 13.895 99 25 51 0 1341164256 13931760 5239632
00:37:34 69689 8192000000 10254584016 10691698688 1307472064 13.763 97 17 34 0 1320702656 9398928 3831664
00:39:47 52955 8192000000 10286473952 10713088000 1343497616 14.089 98 47 92 0 1362896880 9442160 9957104
00:41:40 74881 8192000000 10286078672 10740961280 1370450928 14.331 100 5 10 0 1386797808 15378672 968208
00:44:12 71800 8192000000 10287137376 10730999808 1353570720 14.180 98 30 60 2 1370175264 9737072 6867472
00:46:36 101285 8192000000 10282756896 10734518272 1368252240 14.311 99 23 46 0 1381693392 8322864 5118288
00:49:34 46579 8192000000 10278829936 10734907392 1375190640 14.374 99 28 56 0 1390728832 9610272 5927920
00:51:22 73201 8192000000 10293275520 10748235776 1392170896 14.525 100 14 28 0 1408734880 13041024 3522960
00:53:43 78081 8192000000 10278545248 10737733632 1363935968 14.273 99 20 40 1 1380760992 11950352 4874672
00:56:03 62887 8192000000 10294228592 10748440576 1383178400 14.445 100 17 34 0 1394670032 7766352 3725280
00:58:11 45273 8192000000 10294850432 10750484480 1380349488 14.420 99 31 62 1 1399700816 12461824 6889504
00:59:58 38374 8192000000 10305201056 10761441280 1397900800 14.576 100 21 42 0 1414718448 12412640 4405008
01:01:36 26710 8192000000 10302995392 10749370368 1365134240 14.283 97 30 60 0 1384740064 12933136 6672688
01:03:03 64584 8192000000 10276279184 10721529856 1342933824 14.084 97 22 44 0 1362848080 15479840 4434416
01:05:08 108314 8192000000 10285281584 10730323968 1310397584 13.790 95 12 24 1 1327124384 13878688 2848112
01:07:59 46660 8192000000 10264334304 10717597696 1339489312 14.053 98 12 24 1 1353295808 11113136 2693360
01:09:47 14576 8192000000 9105967408 9329147904 272519872 3.219 21 3 6 0 274924848 1949984 454992

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


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

Exceptions occured during test was in run

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

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

Content of mon$database and FB version 


MON$DATABASE_NAME               /home/bases/oltp30-etalone.fdb
MON$PAGE_SIZE                   8192
MON$ODS_MAJOR                   12
MON$ODS_MINOR                   0
MON$OLDEST_TRANSACTION          179194
MON$OLDEST_ACTIVE               180140
MON$OLDEST_SNAPSHOT             180140
MON$NEXT_TRANSACTION            180140
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                       1925280
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.33740 Firebird 3.0
Server version:
Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V3.0.12.33740 Firebird 3.0"
Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-V3.0.12.33740 Firebird 3.0/tcp (mscs-test-161.budzdorov.ru)/P15:C"
Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-V3.0.12.33740 Firebird 3.0/tcp (mscs-test-161.budzdorov.ru)/P15:C"
on disk structure version 12.0

Database statistics 

 
Database "/home/bases/oltp30-etalone.fdb" 
Gstat execution time Sun Apr 14 01:11:38 2024 
 
Database header page information: 
    Flags            0 
    Generation        94003 
    System Change Number    0 
    Page size        8192 
    ODS version        12.0 
    Oldest transaction    179194 
    Oldest active        180140 
    Oldest snapshot        180140 
    Next transaction    180141 
    Sequence number        0 
    Next attachment ID    722 
    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.65, total records: 7728900 
    Average version length: 48.14, total versions: 38960, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 64.00, compression ratio: 1.34 
    Pointer pages: 54, data page slots: 87640 
    Data pages: 87640, average fill: 70% 
    Primary pages: 87640, secondary pages: 0, swept pages: 40539 
    Empty pages: 10, full pages: 49964 
    Fill distribution: 
     0 - 19% = 44 
    20 - 39% = 389 
    40 - 59% = 4411 
    60 - 79% = 82778 
    80 - 99% = 18 
 
    Index DOC_DATA_DOC_WARE_UNQ (0) 
    Root page: 1510614, depth: 3, leaf buckets: 23408, nodes: 7728900 
    Average node length: 18.88, total dup: 0, max dup: 0 
    Average key length: 15.89, compression ratio: 1.70 
    Average prefix length: 14.11, average data length: 12.89 
    Clustering factor: 1695487, ratio: 0.22 
    Fill distribution: 
         0 - 19% = 370 
        20 - 39% = 1998 
        40 - 59% = 4150 
        60 - 79% = 2580 
        80 - 99% = 14310 
 
    Index DOC_DATA_ID_DESC (1) 
    Root page: 1528118, depth: 3, leaf buckets: 13562, nodes: 7728900 
    Average node length: 11.20, total dup: 0, max dup: 0 
    Average key length: 8.21, compression ratio: 1.10 
    Average prefix length: 3.78, average data length: 5.22 
    Clustering factor: 1518018, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 1714 
        40 - 59% = 1997 
        60 - 79% = 1168 
        80 - 99% = 8683 
 
    Index FK_DOC_DATA_DOC_LIST (2) 
    Root page: 1546711, depth: 3, leaf buckets: 8366, nodes: 7728900 
    Average node length: 6.61, total dup: 5787305, max dup: 49 
    Average key length: 3.62, compression ratio: 2.48 
    Average prefix length: 7.63, average data length: 1.37 
    Clustering factor: 1510909, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 122 
        20 - 39% = 1044 
        40 - 59% = 1354 
        60 - 79% = 1046 
        80 - 99% = 4800 
 
DOC_LIST (138) 
    Primary pointer page: 472, Index root page: 473 
    Total formats: 1, used formats: 1 
    Average record length: 56.82, total records: 2234176 
    Average version length: 34.97, total versions: 45000, max versions: 3 
    Average fragment length: 5.00, total fragments: 2, max fragments: 1 
    Average unpacked length: 84.00, compression ratio: 1.48 
    Pointer pages: 18, data page slots: 28832 
    Data pages: 28832, average fill: 71% 
    Primary pages: 28821, secondary pages: 11, swept pages: 17610 
    Empty pages: 7, full pages: 16969 
    Fill distribution: 
     0 - 19% = 27 
    20 - 39% = 206 
    40 - 59% = 2735 
    60 - 79% = 25511 
    80 - 99% = 353 
 
    Index DOC_LIST_ID_DESC (1) 
    Root page: 1541130, depth: 3, leaf buckets: 4570, nodes: 2234176 
    Average node length: 11.41, total dup: 0, max dup: 0 
    Average key length: 8.45, compression ratio: 1.07 
    Average prefix length: 3.55, average data length: 5.45 
    Clustering factor: 678191, ratio: 0.30 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 981 
        40 - 59% = 820 
        60 - 79% = 788 
        80 - 99% = 1981 
 
    Index DOC_LIST_WORKER_OPTYPE (2) 
    Root page: 1544376, depth: 3, leaf buckets: 2514, nodes: 2236195 
    Average node length: 4.97, total dup: 2235296, max dup: 20008 
    Average key length: 2.01, compression ratio: 4.47 
    Average prefix length: 8.99, average data length: 0.01 
    Clustering factor: 1249366, ratio: 0.56 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 284 
        40 - 59% = 1511 
        60 - 79% = 531 
        80 - 99% = 186 
 
    Index FK_DOC_LIST_AGENTS (3) 
    Root page: 1545909, depth: 3, leaf buckets: 2070, nodes: 2234176 
    Average node length: 4.97, total dup: 2234126, max dup: 130633 
    Average key length: 2.01, compression ratio: 4.48 
    Average prefix length: 8.99, average data length: 0.01 
    Clustering factor: 1064471, ratio: 0.48 
    Fill distribution: 
         0 - 19% = 4 
        20 - 39% = 224 
        40 - 59% = 955 
        60 - 79% = 56 
        80 - 99% = 831 
 
    Index PK_DOC_LIST (0) 
    Root page: 1538187, depth: 3, leaf buckets: 4399, nodes: 2234176 
    Average node length: 11.41, total dup: 0, max dup: 0 
    Average key length: 8.45, compression ratio: 1.07 
    Average prefix length: 3.55, average data length: 5.45 
    Clustering factor: 678191, ratio: 0.30 
    Fill distribution: 
         0 - 19% = 123 
        20 - 39% = 666 
        40 - 59% = 592 
        60 - 79% = 873 
        80 - 99% = 2145 
 
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.50, total records: 400 
    Average version length: 23.05, total versions: 246875, max versions: 641 
    Average fragment length: 2.14, total fragments: 44, max fragments: 1 
    Average unpacked length: 104.00, compression ratio: 1.26 
    Pointer pages: 1, data page slots: 1400 
    Data pages: 1376, average fill: 90% 
    Primary pages: 9, secondary pages: 1367, swept pages: 0 
    Empty pages: 2, full pages: 1372 
    Fill distribution: 
     0 - 19% = 2 
    20 - 39% = 1 
    40 - 59% = 1 
    60 - 79% = 1 
    80 - 99% = 1371 
 
    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: 2.77, total records: 63338 
    Average version length: 68.27, total versions: 60769, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 88.00, compression ratio: 31.77 
    Pointer pages: 7, data page slots: 3720 
    Data pages: 1824, average fill: 44% 
    Primary pages: 1823, secondary pages: 1, swept pages: 153 
    Empty pages: 543, full pages: 538 
    Fill distribution: 
     0 - 19% = 632 
    20 - 39% = 223 
    40 - 59% = 251 
    60 - 79% = 228 
    80 - 99% = 490 
 
    Index INVNT_TURNOVER_LOG_WARE_DD_ID (0) 
    Root page: 1706848, depth: 3, leaf buckets: 294, nodes: 63338 
    Average node length: 13.47, total dup: 4678, max dup: 1 
    Average key length: 10.78, compression ratio: 2.51 
    Average prefix length: 19.14, average data length: 7.86 
    Clustering factor: 46398, ratio: 0.73 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 201 
        40 - 59% = 80 
        60 - 79% = 12 
        80 - 99% = 1 
 
MONEY_SALDO (141) 
    Primary pointer page: 478, Index root page: 479 
    Total formats: 1, used formats: 1 
    Average record length: 15.27, total records: 49 
    Average version length: 9.00, total versions: 18477, max versions: 1013 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 32.00, compression ratio: 2.10 
    Pointer pages: 1, data page slots: 72 
    Data pages: 72, average fill: 83% 
    Primary pages: 6, secondary pages: 66, swept pages: 0 
    Empty pages: 5, full pages: 66 
    Fill distribution: 
     0 - 19% = 5 
    20 - 39% = 0 
    40 - 59% = 1 
    60 - 79% = 11 
    80 - 99% = 55 
 
    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: 0.99, total records: 1440 
    Average version length: 43.84, total versions: 1407, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 58.00, compression ratio: 58.53 
    Pointer pages: 1, data page slots: 32 
    Data pages: 31, average fill: 46% 
    Primary pages: 30, secondary pages: 1, swept pages: 1 
    Empty pages: 7, full pages: 5 
    Fill distribution: 
     0 - 19% = 11 
    20 - 39% = 1 
    40 - 59% = 4 
    60 - 79% = 9 
    80 - 99% = 6 
 
    Index MONEY_TURNOVER_LOG_AGENT_OPTYPE (0) 
    Root page: 90636, depth: 2, leaf buckets: 2, nodes: 1440 
    Average node length: 4.39, total dup: 1343, max dup: 114 
    Average key length: 2.71, compression ratio: 7.02 
    Average prefix length: 18.36, average data length: 0.64 
    Clustering factor: 825, ratio: 0.57 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 1 
        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.04, total records: 74 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 112.00, compression ratio: 1.15 
    Pointer pages: 1, data page slots: 2 
    Data pages: 2, average fill: 52% 
    Primary pages: 2, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 1 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 1 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 1 
 
    Index PK_MON_CACHE_MEMORY (0) 
    Root page: 1504215, depth: 1, leaf buckets: 1, nodes: 74 
    Average node length: 11.69, total dup: 0, max dup: 0 
    Average key length: 10.68, compression ratio: 0.84 
    Average prefix length: 1.31, average data length: 7.69 
    Clustering factor: 2, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
MON_LOG (162) 
    Primary pointer page: 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.90, total records: 779536 
    Average version length: 25.98, total versions: 35031, max versions: 4 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 54.00, compression ratio: 1.46 
    Pointer pages: 5, data page slots: 8032 
    Data pages: 8032, average fill: 67% 
    Primary pages: 8015, secondary pages: 17, swept pages: 4072 
    Empty pages: 50, full pages: 3697 
    Fill distribution: 
     0 - 19% = 88 
    20 - 39% = 83 
    40 - 59% = 627 
    60 - 79% = 7116 
    80 - 99% = 118 
 
    Index PDISTR_AGENT_ID (2) 
    Root page: 1509308, depth: 2, leaf buckets: 877, nodes: 779536 
    Average node length: 4.87, total dup: 779487, max dup: 142562 
    Average key length: 2.01, compression ratio: 4.48 
    Average prefix length: 8.99, average data length: 0.01 
    Clustering factor: 87315, ratio: 0.11 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 137 
        40 - 59% = 515 
        60 - 79% = 160 
        80 - 99% = 63 
 
    Index PDISTR_SNDOP_RCVOP_SNDID_ASC (0) 
    Root page: 1508613, depth: 3, leaf buckets: 915, nodes: 779536 
    Average node length: 5.88, total dup: 694100, max dup: 42 
    Average key length: 3.02, compression ratio: 7.29 
    Average prefix length: 21.09, average data length: 0.91 
    Clustering factor: 155385, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 125 
        40 - 59% = 354 
        60 - 79% = 148 
        80 - 99% = 287 
 
    Index PDISTR_SNDOP_RCVOP_SNDID_DESC (1) 
    Root page: 1509187, depth: 3, leaf buckets: 952, nodes: 779536 
    Average node length: 5.88, total dup: 694100, max dup: 42 
    Average key length: 3.02, compression ratio: 7.29 
    Average prefix length: 21.09, average data length: 0.91 
    Clustering factor: 157311, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 217 
        40 - 59% = 312 
        60 - 79% = 139 
        80 - 99% = 283 
 
    Index PDISTR_WORKER_SND_ID (3) 
    Root page: 1510178, depth: 3, leaf buckets: 1130, nodes: 779536 
    Average node length: 5.96, total dup: 694100, max dup: 42 
    Average key length: 3.10, compression ratio: 5.48 
    Average prefix length: 16.01, average data length: 0.99 
    Clustering factor: 150234, ratio: 0.19 
    Fill distribution: 
         0 - 19% = 3 
        20 - 39% = 284 
        40 - 59% = 586 
        60 - 79% = 169 
        80 - 99% = 88 
 
PERF_AGG (158) 
    Primary pointer page: 512, Index root page: 513 
    Total formats: 1, used formats: 1 
    Average record length: 62.80, total records: 5422 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 2.71, total fragments: 80, max fragments: 1 
    Average unpacked length: 379.00, compression ratio: 6.04 
    Pointer pages: 1, data page slots: 96 
    Data pages: 93, average fill: 58% 
    Primary pages: 74, secondary pages: 19, swept pages: 61 
    Empty pages: 10, full pages: 64 
    Fill distribution: 
     0 - 19% = 22 
    20 - 39% = 1 
    40 - 59% = 1 
    60 - 79% = 68 
    80 - 99% = 1 
 
    Index PERF_AGG_UNQ (1) 
    Root page: 1504238, depth: 2, leaf buckets: 6, nodes: 5422 
    Average node length: 5.51, total dup: 0, max dup: 0 
    Average key length: 3.58, compression ratio: 10.03 
    Average prefix length: 34.38, average data length: 1.55 
    Clustering factor: 5120, ratio: 0.94 
    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: 5422 
    Average node length: 11.14, total dup: 0, max dup: 0 
    Average key length: 9.21, compression ratio: 0.98 
    Average prefix length: 2.79, average data length: 6.21 
    Clustering factor: 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.10, total records: 82561 
    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: 800 
    Data pages: 800, average fill: 71% 
    Primary pages: 800, secondary pages: 0, swept pages: 0 
    Empty pages: 4, full pages: 795 
    Fill distribution: 
     0 - 19% = 5 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 795 
    80 - 99% = 0 
 
    Index PK_PERF_ESTIMATED (0) 
    Root page: 32947, depth: 2, leaf buckets: 106, nodes: 82561 
    Average node length: 10.17, total dup: 0, max dup: 0 
    Average key length: 8.18, compression ratio: 1.10 
    Average prefix length: 3.82, average data length: 5.18 
    Clustering factor: 3420, ratio: 0.04 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 104 
 
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.14, 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: 147.03, total records: 173999 
    Average version length: 152.90, total versions: 4487, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.54 
    Pointer pages: 6, data page slots: 5136 
    Data pages: 4184, average fill: 86% 
    Primary pages: 4183, secondary pages: 1, swept pages: 4 
    Empty pages: 52, full pages: 4114 
    Fill distribution: 
     0 - 19% = 56 
    20 - 39% = 7 
    40 - 59% = 1 
    60 - 79% = 5 
    80 - 99% = 4115 
 
PERF_SPLIT_1 (282) 
    Primary pointer page: 576, Index root page: 577 
    Total formats: 1, used formats: 1 
    Average record length: 150.31, total records: 166885 
    Average version length: 140.39, total versions: 543, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.28 
    Pointer pages: 7, data page slots: 4320 
    Data pages: 3992, average fill: 86% 
    Primary pages: 3992, secondary pages: 0, swept pages: 3 
    Empty pages: 39, full pages: 3944 
    Fill distribution: 
     0 - 19% = 41 
    20 - 39% = 2 
    40 - 59% = 1 
    60 - 79% = 3 
    80 - 99% = 3945 
 
PERF_SPLIT_2 (283) 
    Primary pointer page: 578, Index root page: 579 
    Total formats: 1, used formats: 1 
    Average record length: 150.69, total records: 168493 
    Average version length: 136.73, total versions: 445, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.26 
    Pointer pages: 7, data page slots: 4664 
    Data pages: 4048, average fill: 86% 
    Primary pages: 4048, secondary pages: 0, swept pages: 2 
    Empty pages: 46, full pages: 3988 
    Fill distribution: 
     0 - 19% = 48 
    20 - 39% = 7 
    40 - 59% = 3 
    60 - 79% = 2 
    80 - 99% = 3988 
 
PERF_SPLIT_3 (284) 
    Primary pointer page: 580, Index root page: 581 
    Total formats: 1, used formats: 1 
    Average record length: 149.06, total records: 168167 
    Average version length: 150.37, total versions: 2135, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.38 
    Pointer pages: 6, data page slots: 4408 
    Data pages: 4072, average fill: 85% 
    Primary pages: 4072, secondary pages: 0, swept pages: 2 
    Empty pages: 76, full pages: 3972 
    Fill distribution: 
     0 - 19% = 79 
    20 - 39% = 9 
    40 - 59% = 6 
    60 - 79% = 6 
    80 - 99% = 3972 
 
PERF_SPLIT_4 (285) 
    Primary pointer page: 582, Index root page: 583 
    Total formats: 1, used formats: 1 
    Average record length: 128.96, total records: 185215 
    Average version length: 153.78, total versions: 26935, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 13.15 
    Pointer pages: 8, data page slots: 5120 
    Data pages: 4504, average fill: 86% 
    Primary pages: 4504, secondary pages: 0, swept pages: 1 
    Empty pages: 81, full pages: 4366 
    Fill distribution: 
     0 - 19% = 83 
    20 - 39% = 5 
    40 - 59% = 45 
    60 - 79% = 5 
    80 - 99% = 4366 
 
PERF_SPLIT_5 (286) 
    Primary pointer page: 584, Index root page: 585 
    Total formats: 1, used formats: 1 
    Average record length: 149.86, total records: 182438 
    Average version length: 149.94, total versions: 1464, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.32 
    Pointer pages: 8, data page slots: 5032 
    Data pages: 4376, average fill: 86% 
    Primary pages: 4376, secondary pages: 0, swept pages: 2 
    Empty pages: 43, full pages: 4318 
    Fill distribution: 
     0 - 19% = 45 
    20 - 39% = 8 
    40 - 59% = 3 
    60 - 79% = 3 
    80 - 99% = 4317 
 
PERF_SPLIT_6 (287) 
    Primary pointer page: 586, Index root page: 587 
    Total formats: 1, used formats: 1 
    Average record length: 150.07, total records: 173984 
    Average version length: 145.91, total versions: 918, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.30 
    Pointer pages: 8, data page slots: 4856 
    Data pages: 4152, average fill: 86% 
    Primary pages: 4151, secondary pages: 1, swept pages: 5 
    Empty pages: 31, full pages: 4112 
    Fill distribution: 
     0 - 19% = 32 
    20 - 39% = 2 
    40 - 59% = 3 
    60 - 79% = 3 
    80 - 99% = 4112 
 
PERF_SPLIT_7 (288) 
    Primary pointer page: 588, Index root page: 589 
    Total formats: 1, used formats: 1 
    Average record length: 136.03, total records: 199747 
    Average version length: 154.07, total versions: 19851, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 12.47 
    Pointer pages: 6, data page slots: 7032 
    Data pages: 4800, average fill: 87% 
    Primary pages: 4800, secondary pages: 0, swept pages: 2 
    Empty pages: 46, full pages: 4733 
    Fill distribution: 
     0 - 19% = 50 
    20 - 39% = 9 
    40 - 59% = 5 
    60 - 79% = 2 
    80 - 99% = 4734 
 
PERF_SPLIT_8 (289) 
    Primary pointer page: 590, Index root page: 591 
    Total formats: 1, used formats: 1 
    Average record length: 145.92, total records: 173286 
    Average version length: 152.04, total versions: 5726, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.62 
    Pointer pages: 10, data page slots: 4992 
    Data pages: 4200, average fill: 85% 
    Primary pages: 4200, secondary pages: 0, swept pages: 2 
    Empty pages: 84, full pages: 4090 
    Fill distribution: 
     0 - 19% = 86 
    20 - 39% = 6 
    40 - 59% = 9 
    60 - 79% = 9 
    80 - 99% = 4090 
 
PERF_SPLIT_9 (290) 
    Primary pointer page: 593, Index root page: 594 
    Total formats: 1, used formats: 1 
    Average record length: 147.24, total records: 171869 
    Average version length: 153.63, total versions: 4173, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.52 
    Pointer pages: 7, data page slots: 5536 
    Data pages: 4136, average fill: 86% 
    Primary pages: 4136, secondary pages: 0, swept pages: 1 
    Empty pages: 58, full pages: 4064 
    Fill distribution: 
     0 - 19% = 59 
    20 - 39% = 5 
    40 - 59% = 3 
    60 - 79% = 5 
    80 - 99% = 4064 
 
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.07, total records: 2106032 
    Average version length: 52.83, total versions: 26944, 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: 25728 
    Data pages: 25704, average fill: 70% 
    Primary pages: 25704, secondary pages: 0, swept pages: 12143 
    Empty pages: 311, full pages: 20083 
    Fill distribution: 
     0 - 19% = 577 
    20 - 39% = 474 
    40 - 59% = 1224 
    60 - 79% = 23216 
    80 - 99% = 213 
 
    Index PSTORNED_RCV_ID (1) 
    Root page: 1506186, depth: 3, leaf buckets: 2632, nodes: 2106032 
    Average node length: 5.44, total dup: 1964613, max dup: 1416 
    Average key length: 2.49, compression ratio: 3.62 
    Average prefix length: 8.58, average data length: 0.42 
    Clustering factor: 182537, ratio: 0.09 
    Fill distribution: 
         0 - 19% = 8 
        20 - 39% = 300 
        40 - 59% = 1781 
        60 - 79% = 273 
        80 - 99% = 270 
 
    Index PSTORNED_SND_ID (0) 
    Root page: 1504819, depth: 3, leaf buckets: 2761, nodes: 2106032 
    Average node length: 5.69, total dup: 1890037, max dup: 72 
    Average key length: 2.74, compression ratio: 3.29 
    Average prefix length: 8.36, average data length: 0.64 
    Clustering factor: 376712, ratio: 0.18 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 5 
        40 - 59% = 2396 
        60 - 79% = 338 
        80 - 99% = 22 
 
    Index PSTORNED_WORKER_ID (2) 
    Root page: 1507996, depth: 3, leaf buckets: 2202, nodes: 2106032 
    Average node length: 4.96, total dup: 2105932, max dup: 28037 
    Average key length: 2.00, compression ratio: 1.20 
    Average prefix length: 2.40, average data length: 0.00 
    Clustering factor: 180464, ratio: 0.09 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 232 
        40 - 59% = 1220 
        60 - 79% = 376 
        80 - 99% = 374 
 
RULES_FOR_PDISTR (148) 
    Primary pointer page: 492, Index root page: 493 
    Total formats: 1, used formats: 1 
    Average record length: 17.00, total records: 4 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 334.00, compression ratio: 19.65 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 2% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index RULES_FOR_PDISTR_UNQ (0) 
    Root page: 1504317, depth: 1, leaf buckets: 1, nodes: 4 
    Average node length: 11.50, total dup: 0, max dup: 0 
    Average key length: 10.25, compression ratio: 0.88 
    Average prefix length: 1.50, average data length: 7.50 
    Clustering factor: 1, ratio: 0.25 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
RULES_FOR_QDISTR (137) 
    Primary pointer page: 470, Index root page: 471 
    Total formats: 1, used formats: 1 
    Average record length: 32.71, total records: 7 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 332.00, compression ratio: 10.15 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 4% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index RULES_FOR_QDISTR_RCVOP (1) 
    Root page: 1544803, depth: 1, leaf buckets: 1, nodes: 7 
    Average node length: 5.29, total dup: 2, max dup: 2 
    Average key length: 4.14, compression ratio: 0.72 
    Average prefix length: 1.43, average data length: 1.57 
    Clustering factor: 1, ratio: 0.14 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index RULES_FOR_QDISTR_UNQ (0) 
    Root page: 1544802, depth: 1, leaf buckets: 1, nodes: 7 
    Average node length: 10.14, total dup: 0, max dup: 0 
    Average key length: 8.86, compression ratio: 0.94 
    Average prefix length: 2.14, average data length: 6.14 
    Clustering factor: 1, ratio: 0.14 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
SEMAPHORES (152) 
    Primary pointer page: 500, Index root page: 501 
    Total formats: 1, used formats: 1 
    Average record length: 43.40, total records: 5 
    Average version length: 9.00, total versions: 1, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 346.00, compression ratio: 7.97 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 4% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index PK_SEMAPHORES (0) 
    Root page: 1504305, depth: 1, leaf buckets: 1, nodes: 5 
    Average node length: 12.40, total dup: 0, max dup: 0 
    Average key length: 11.00, compression ratio: 0.82 
    Average prefix length: 0.60, average data length: 8.40 
    Clustering factor: 1, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index SEMAPHORES_TASK_UNQ (1) 
    Root page: 1504306, depth: 1, leaf buckets: 1, nodes: 5 
    Average node length: 23.40, total dup: 0, max dup: 0 
    Average key length: 22.00, compression ratio: 1.07 
    Average prefix length: 4.20, average data length: 19.40 
    Clustering factor: 1, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
SETTINGS (135) 
    Primary pointer page: 466, Index root page: 467 
    Total formats: 1, used formats: 1 
    Average record length: 97.63, total records: 149 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1347.00, compression ratio: 13.80 
    Pointer pages: 1, data page slots: 3 
    Data pages: 3, average fill: 70% 
    Primary pages: 3, secondary pages: 0, swept pages: 2 
    Empty pages: 0, full pages: 2 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 1 
    60 - 79% = 0 
    80 - 99% = 2 
 
    Index SETTINGS_MCODE_WM_UNQ (1) 
    Root page: 525, depth: 1, leaf buckets: 1, nodes: 149 
    Average node length: 14.66, total dup: 0, max dup: 0 
    Average key length: 13.55, compression ratio: 2.19 
    Average prefix length: 19.07, average data length: 10.66 
    Clustering factor: 48, ratio: 0.32 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 1 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index SETTINGS_MODE_CODE (0) 
    Root page: 1544806, depth: 1, leaf buckets: 1, nodes: 149 
    Average node length: 25.56, total dup: 0, max dup: 0 
    Average key length: 24.56, compression ratio: 1.63 
    Average prefix length: 18.58, average data length: 21.56 
    Clustering factor: 14, ratio: 0.09 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 0 
        40 - 59% = 1 
        60 - 79% = 0 
        80 - 99% = 0 
 
TMP$DEP_DOCS (129) 
    Primary pointer page: 454, Index root page: 455 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index TMP_DEP_DOCS_UNQ (0) 
    Root page: 1544810, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
TMP$IDX_RECALC (132) 
    Primary pointer page: 460, Index root page: 461 
    Total formats: 2, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index TMP_IDX_RECALC_IDX_NAME_UNQ (0) 
    Root page: 1544807, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
TMP$MON_LOG (133) 
    Primary pointer page: 462, Index root page: 463 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
TMP$MON_LOG_TABLE_STATS (134) 
    Primary pointer page: 464, Index root page: 465 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
TMP$PERF_EST_WHOLE (161) 
    Primary pointer page: 518, Index root page: 519 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
TMP$PERF_LOG (160) 
    Primary pointer page: 516, Index root page: 517 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index TMP$PERF_LOG_UNIT_TRN_DTS_END (0) 
    Root page: 1504230, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
TMP$PERF_MON (131) 
    Primary pointer page: 458, Index root page: 459 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
TMP$RESULT_SET (130) 
    Primary pointer page: 456, Index root page: 457 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index TMP_RESULT_SET_DOC (1) 
    Root page: 1544809, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index TMP_RESULT_SET_WARE_DOC (0) 
    Root page: 1544808, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
TMP$SHOPPING_CART (128) 
    Primary pointer page: 452, Index root page: 453 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index TMP_SHOPCART_UNQ (0) 
    Root page: 1544811, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
TPAUSE (166) 
    Primary pointer page: 528, Index root page: 529 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index RDB$PRIMARY2 (0) 
    Root page: 1504214, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
TRACE_STAT (157) 
    Primary pointer page: 510, Index root page: 511 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
WARES (142) 
    Primary pointer page: 480, Index root page: 481 
    Total formats: 1, used formats: 1 
    Average record length: 77.52, total records: 400 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 444.00, compression ratio: 5.73 
    Pointer pages: 1, data page slots: 6 
    Data pages: 6, average fill: 77% 
    Primary pages: 6, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 5 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 5 
    80 - 99% = 1 
 
    Index FK_WARES_WARE_GROUPS (3) 
    Root page: 1552159, depth: 1, leaf buckets: 1, nodes: 400 
    Average node length: 3.17, total dup: 392, max dup: 60 
    Average key length: 2.16, compression ratio: 4.16 
    Average prefix length: 8.86, average data length: 0.14 
    Clustering factor: 48, ratio: 0.12 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PK_WARES (0) 
    Root page: 1510355, depth: 1, leaf buckets: 1, nodes: 400 
    Average node length: 11.22, total dup: 0, max dup: 0 
    Average key length: 10.22, compression ratio: 0.88 
    Average prefix length: 1.78, average data length: 7.22 
    Clustering factor: 344, ratio: 0.86 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 0 
        40 - 59% = 1 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index WARES_ID_DESC (2) 
    Root page: 1510360, depth: 1, leaf buckets: 1, nodes: 400 
    Average node length: 11.22, total dup: 0, max dup: 0 
    Average key length: 10.22, compression ratio: 0.88 
    Average prefix length: 1.78, average data length: 7.22 
    Clustering factor: 344, ratio: 0.86 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 0 
        40 - 59% = 1 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index WARES_NUMB_UNQ (1) 
    Root page: 1510358, depth: 2, leaf buckets: 3, nodes: 400 
    Average node length: 53.25, total dup: 0, max dup: 0 
    Average key length: 52.23, compression ratio: 1.00 
    Average prefix length: 2.74, average data length: 49.25 
    Clustering factor: 355, ratio: 0.89 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 1 
        80 - 99% = 2 
 
WARE_GROUPS (151) 
    Primary pointer page: 498, Index root page: 499 
    Total formats: 1, used formats: 1 
    Average record length: 32.12, total records: 8 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 346.00, compression ratio: 10.77 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 5% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index PK_WARE_GROUPS (0) 
    Root page: 1504307, depth: 1, leaf buckets: 1, nodes: 8 
    Average node length: 11.25, total dup: 0, max dup: 0 
    Average key length: 10.12, compression ratio: 0.89 
    Average prefix length: 1.75, average data length: 7.25 
    Clustering factor: 1, ratio: 0.12 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index WARE_GROUPS_NAME_UNQ (1) 
    Root page: 1504308, depth: 1, leaf buckets: 1, nodes: 8 
    Average node length: 19.88, total dup: 0, max dup: 0 
    Average key length: 18.12, compression ratio: 0.89 
    Average prefix length: 0.25, average data length: 15.88 
    Clustering factor: 1, ratio: 0.12 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
XQD_1000_1200 (176) 
    Primary pointer page: 549, Index root page: 550 
    Total formats: 1, used formats: 1 
    Average record length: 49.19, total records: 115535 
    Average version length: 69.16, total versions: 33445, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 2.56 
    Pointer pages: 3, data page slots: 4168 
    Data pages: 2912, average fill: 46% 
    Primary pages: 2912, secondary pages: 0, swept pages: 508 
    Empty pages: 413, full pages: 354 
    Fill distribution: 
     0 - 19% = 540 
    20 - 39% = 384 
    40 - 59% = 1011 
    60 - 79% = 855 
    80 - 99% = 122 
 
    Index XQD_1000_1200_WA_SO_RO_WKR_SND (0) 
    Root page: 94871, depth: 3, leaf buckets: 226, nodes: 115535 
    Average node length: 6.55, total dup: 100552, max dup: 14 
    Average key length: 3.99, compression ratio: 10.52 
    Average prefix length: 40.14, average data length: 1.86 
    Clustering factor: 20240, ratio: 0.18 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 112 
        40 - 59% = 95 
        60 - 79% = 15 
        80 - 99% = 3 
 
XQD_1000_3300 (178) 
    Primary pointer page: 553, Index root page: 554 
    Total formats: 1, used formats: 1 
    Average record length: 67.29, total records: 6850040 
    Average version length: 68.79, total versions: 165955, 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: 63, data page slots: 102416 
    Data pages: 102416, average fill: 71% 
    Primary pages: 102416, secondary pages: 0, swept pages: 65676 
    Empty pages: 42, full pages: 54162 
    Fill distribution: 
     0 - 19% = 272 
    20 - 39% = 656 
    40 - 59% = 7769 
    60 - 79% = 91984 
    80 - 99% = 1735 
 
    Index XQD_1000_3300_WA_SO_RO_WKR_SND (0) 
    Root page: 1480454, depth: 3, leaf buckets: 10726, nodes: 6850040 
    Average node length: 6.51, total dup: 5924168, max dup: 29 
    Average key length: 3.52, compression ratio: 11.92 
    Average prefix length: 40.61, average data length: 1.39 
    Clustering factor: 1512240, ratio: 0.22 
    Fill distribution: 
         0 - 19% = 7 
        20 - 39% = 1963 
        40 - 59% = 6023 
        60 - 79% = 2421 
        80 - 99% = 312 
 
    Index XQD_1000_3300_WKR_DOC_ASC (1) 
    Root page: 1486068, depth: 3, leaf buckets: 8560, nodes: 6850040 
    Average node length: 5.40, total dup: 6573129, max dup: 126 
    Average key length: 2.41, compression ratio: 7.05 
    Average prefix length: 16.63, average data length: 0.37 
    Clustering factor: 1326229, ratio: 0.19 
    Fill distribution: 
         0 - 19% = 10 
        20 - 39% = 1419 
        40 - 59% = 4851 
        60 - 79% = 1452 
        80 - 99% = 828 
 
    Index XQD_1000_3300_WKR_DOC_DEC (2) 
    Root page: 1490608, depth: 3, leaf buckets: 8599, nodes: 6850040 
    Average node length: 5.40, total dup: 6573129, max dup: 126 
    Average key length: 2.41, compression ratio: 7.05 
    Average prefix length: 16.63, average data length: 0.37 
    Clustering factor: 1328637, ratio: 0.19 
    Fill distribution: 
         0 - 19% = 6 
        20 - 39% = 1456 
        40 - 59% = 4857 
        60 - 79% = 1459 
        80 - 99% = 821 
 
XQD_1200_2000 (177) 
    Primary pointer page: 551, Index root page: 552 
    Total formats: 1, used formats: 1 
    Average record length: 68.07, total records: 11969244 
    Average version length: 68.77, total versions: 153800, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.85 
    Pointer pages: 105, data page slots: 169880 
    Data pages: 169880, average fill: 75% 
    Primary pages: 169880, secondary pages: 0, swept pages: 115758 
    Empty pages: 11, full pages: 132382 
    Fill distribution: 
     0 - 19% = 33 
    20 - 39% = 336 
    40 - 59% = 5155 
    60 - 79% = 161806 
    80 - 99% = 2550 
 
    Index XQD_1200_2000_WA_SO_RO_WKR_SND (0) 
    Root page: 1495028, depth: 3, leaf buckets: 18446, nodes: 11969244 
    Average node length: 6.59, total dup: 10436908, max dup: 49 
    Average key length: 3.42, compression ratio: 12.27 
    Average prefix length: 40.70, average data length: 1.30 
    Clustering factor: 2348253, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 28 
        20 - 39% = 2351 
        40 - 59% = 11151 
        60 - 79% = 4303 
        80 - 99% = 613 
 
XQD_2000_3300 (179) 
    Primary pointer page: 555, Index root page: 556 
    Total formats: 1, used formats: 1 
    Average record length: 50.96, total records: 1235861 
    Average version length: 69.02, total versions: 325112, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 2.47 
    Pointer pages: 30, data page slots: 46552 
    Data pages: 29103, average fill: 48% 
    Primary pages: 29102, secondary pages: 1, swept pages: 16367 
    Empty pages: 6213, full pages: 12472 
    Fill distribution: 
     0 - 19% = 9084 
    20 - 39% = 3171 
    40 - 59% = 2671 
    60 - 79% = 9427 
    80 - 99% = 4750 
 
    Index XQD_2000_3300_WA_SO_RO_WKR_SND (0) 
    Root page: 1479712, depth: 3, leaf buckets: 2195, nodes: 1235861 
    Average node length: 5.55, total dup: 1185340, max dup: 52 
    Average key length: 2.59, compression ratio: 16.23 
    Average prefix length: 41.45, average data length: 0.55 
    Clustering factor: 82612, ratio: 0.07 
    Fill distribution: 
         0 - 19% = 10 
        20 - 39% = 1260 
        40 - 59% = 807 
        60 - 79% = 114 
        80 - 99% = 4 
 
XQD_2100_3300 (180) 
    Primary pointer page: 557, Index root page: 558 
    Total formats: 1, used formats: 1 
    Average record length: 33.17, total records: 1365741 
    Average version length: 69.10, total versions: 709221, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 3.80 
    Pointer pages: 21, data page slots: 34120 
    Data pages: 27160, average fill: 59% 
    Primary pages: 27160, secondary pages: 0, swept pages: 4053 
    Empty pages: 4968, full pages: 16363 
    Fill distribution: 
     0 - 19% = 6637 
    20 - 39% = 539 
    40 - 59% = 1179 
    60 - 79% = 8015 
    80 - 99% = 10790 
 
    Index XQD_2100_3300_WA_SO_RO_WKR_SND (0) 
    Root page: 1479207, depth: 3, leaf buckets: 1703, nodes: 1365741 
    Average node length: 5.74, total dup: 1280355, max dup: 99 
    Average key length: 2.80, compression ratio: 15.01 
    Average prefix length: 41.26, average data length: 0.74 
    Clustering factor: 185437, ratio: 0.14 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 200 
        40 - 59% = 789 
        60 - 79% = 554 
        80 - 99% = 159 
 
XQD_3300_3400 (181) 
    Primary pointer page: 559, Index root page: 560 
    Total formats: 1, used formats: 1 
    Average record length: 61.14, total records: 9928154 
    Average version length: 68.96, total versions: 1117895, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 2.06 
    Pointer pages: 90, data page slots: 146880 
    Data pages: 146848, average fill: 73% 
    Primary pages: 146848, secondary pages: 0, swept pages: 21894 
    Empty pages: 246, full pages: 113998 
    Fill distribution: 
     0 - 19% = 813 
    20 - 39% = 4367 
    40 - 59% = 17647 
    60 - 79% = 93904 
    80 - 99% = 30117 
 
    Index XQD_3300_3400_WA_SO_RO_WKR_SND (0) 
    Root page: 1472590, depth: 3, leaf buckets: 13556, nodes: 9928154 
    Average node length: 6.69, total dup: 8239601, max dup: 29 
    Average key length: 3.66, compression ratio: 11.47 
    Average prefix length: 40.51, average data length: 1.49 
    Clustering factor: 2157896, ratio: 0.22 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 602 
        40 - 59% = 5955 
        60 - 79% = 5764 
        80 - 99% = 1233 
 
XQS_1000_1200 (182) 
    Primary pointer page: 561, Index root page: 562 
    Total formats: 1, used formats: 1 
    Average record length: 82.43, total records: 21220841 
    Average version length: 82.89, total versions: 28322, 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: 319616 
    Data pages: 319616, average fill: 81% 
    Primary pages: 319616, secondary pages: 0, swept pages: 9928 
    Empty pages: 0, full pages: 319607 
    Fill distribution: 
     0 - 19% = 3 
    20 - 39% = 2 
    40 - 59% = 1 
    60 - 79% = 26240 
    80 - 99% = 293370 
 
    Index XQS_1000_1200_DOC_ID (1) 
    Root page: 1426716, depth: 3, leaf buckets: 19762, nodes: 21220841 
    Average node length: 5.72, total dup: 20738622, max dup: 148 
    Average key length: 2.16, compression ratio: 4.16 
    Average prefix length: 8.86, average data length: 0.14 
    Clustering factor: 3292995, ratio: 0.16 
    Fill distribution: 
         0 - 19% = 7 
        20 - 39% = 0 
        40 - 59% = 8829 
        60 - 79% = 548 
        80 - 99% = 10378 
 
    Index XQS_1000_1200_RCV_ID (3) 
    Root page: 1456980, depth: 3, leaf buckets: 17222, nodes: 21220841 
    Average node length: 6.31, total dup: 18650035, max dup: 49 
    Average key length: 2.75, compression ratio: 3.27 
    Average prefix length: 8.37, average data length: 0.63 
    Clustering factor: 918812, ratio: 0.04 
    Fill distribution: 
         0 - 19% = 8 
        20 - 39% = 3 
        40 - 59% = 771 
        60 - 79% = 287 
        80 - 99% = 16153 
 
    Index XQS_1000_1200_SND_ID (2) 
    Root page: 1441073, depth: 3, leaf buckets: 21568, nodes: 21220841 
    Average node length: 6.35, total dup: 18568911, max dup: 29 
    Average key length: 2.79, compression ratio: 3.23 
    Average prefix length: 8.34, average data length: 0.66 
    Clustering factor: 3587841, ratio: 0.17 
    Fill distribution: 
         0 - 19% = 8 
        20 - 39% = 2 
        40 - 59% = 9091 
        60 - 79% = 646 
        80 - 99% = 11821 
 
    Index XQS_1000_1200_WORKER_ID (0) 
    Root page: 1413348, depth: 3, leaf buckets: 16179, nodes: 21220841 
    Average node length: 5.56, total dup: 21220741, max dup: 228746 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.42, average data length: 0.00 
    Clustering factor: 947534, ratio: 0.04 
    Fill distribution: 
         0 - 19% = 4 
        20 - 39% = 7 
        40 - 59% = 2947 
        60 - 79% = 404 
        80 - 99% = 12817 
 
XQS_1000_3300 (184) 
    Primary pointer page: 565, Index root page: 566 
    Total formats: 1, used formats: 1 
    Average record length: 74.03, total records: 10321916 
    Average version length: 82.64, total versions: 1051337, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.70 
    Pointer pages: 107, data page slots: 173752 
    Data pages: 173744, average fill: 74% 
    Primary pages: 173744, secondary pages: 0, swept pages: 36914 
    Empty pages: 708, full pages: 129678 
    Fill distribution: 
     0 - 19% = 1746 
    20 - 39% = 5601 
    40 - 59% = 21374 
    60 - 79% = 45261 
    80 - 99% = 99762 
 
    Index XQS_1000_3300_DOC_ID (1) 
    Root page: 1367502, depth: 3, leaf buckets: 11413, nodes: 10321916 
    Average node length: 5.37, total dup: 10008848, max dup: 244 
    Average key length: 2.22, compression ratio: 4.05 
    Average prefix length: 8.81, average data length: 0.19 
    Clustering factor: 2268145, ratio: 0.22 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 21 
        40 - 59% = 6194 
        60 - 79% = 4953 
        80 - 99% = 244 
 
    Index XQS_1000_3300_RCV_ID (3) 
    Root page: 1379261, depth: 3, leaf buckets: 13920, nodes: 10321916 
    Average node length: 6.25, total dup: 8561305, max dup: 14 
    Average key length: 3.10, compression ratio: 2.91 
    Average prefix length: 8.07, average data length: 0.93 
    Clustering factor: 1585501, ratio: 0.15 
    Fill distribution: 
         0 - 19% = 148 
        20 - 39% = 3409 
        40 - 59% = 4869 
        60 - 79% = 2592 
        80 - 99% = 2902 
 
    Index XQS_1000_3300_SND_ID (2) 
    Root page: 1373059, depth: 3, leaf buckets: 12743, nodes: 10321916 
    Average node length: 5.98, total dup: 8987817, max dup: 47 
    Average key length: 2.83, compression ratio: 3.18 
    Average prefix length: 8.30, average data length: 0.70 
    Clustering factor: 2481574, ratio: 0.24 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 42 
        40 - 59% = 7153 
        60 - 79% = 5286 
        80 - 99% = 260 
 
    Index XQS_1000_3300_WORKER_ID (0) 
    Root page: 1362767, depth: 3, leaf buckets: 10553, nodes: 10321916 
    Average node length: 5.16, total dup: 10321816, max dup: 160602 
    Average key length: 2.00, compression ratio: 1.20 
    Average prefix length: 2.40, average data length: 0.00 
    Clustering factor: 1627562, ratio: 0.16 
    Fill distribution: 
         0 - 19% = 44 
        20 - 39% = 1046 
        40 - 59% = 5356 
        60 - 79% = 1728 
        80 - 99% = 2379 
 
XQS_1200_2000 (183) 
    Primary pointer page: 563, Index root page: 564 
    Total formats: 1, used formats: 1 
    Average record length: 76.29, total records: 11814818 
    Average version length: 82.54, total versions: 863091, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.65 
    Pointer pages: 118, data page slots: 191416 
    Data pages: 190448, average fill: 77% 
    Primary pages: 190448, secondary pages: 0, swept pages: 43388 
    Empty pages: 2270, full pages: 162083 
    Fill distribution: 
     0 - 19% = 3420 
    20 - 39% = 4041 
    40 - 59% = 10432 
    60 - 79% = 34603 
    80 - 99% = 137952 
 
    Index XQS_1200_2000_DOC_ID (1) 
    Root page: 1392101, depth: 3, leaf buckets: 13147, nodes: 11814818 
    Average node length: 5.30, total dup: 11704761, max dup: 727 
    Average key length: 2.08, compression ratio: 4.33 
    Average prefix length: 8.93, average data length: 0.07 
    Clustering factor: 2475555, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 36 
        40 - 59% = 7938 
        60 - 79% = 4954 
        80 - 99% = 218 
 
    Index XQS_1200_2000_RCV_ID (3) 
    Root page: 1406110, depth: 3, leaf buckets: 10649, nodes: 11814818 
    Average node length: 5.49, total dup: 11300407, max dup: 49 
    Average key length: 2.28, compression ratio: 3.96 
    Average prefix length: 8.77, average data length: 0.23 
    Clustering factor: 756066, ratio: 0.06 
    Fill distribution: 
         0 - 19% = 125 
        20 - 39% = 715 
        40 - 59% = 2574 
        60 - 79% = 1778 
        80 - 99% = 5457 
 
    Index XQS_1200_2000_SND_ID (2) 
    Root page: 1398638, depth: 3, leaf buckets: 15026, nodes: 11814818 
    Average node length: 6.01, total dup: 10330689, max dup: 76 
    Average key length: 2.79, compression ratio: 3.22 
    Average prefix length: 8.33, average data length: 0.67 
    Clustering factor: 2492317, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 56 
        40 - 59% = 9373 
        60 - 79% = 5328 
        80 - 99% = 267 
 
    Index XQS_1200_2000_WORKER_ID (0) 
    Root page: 1386211, depth: 3, leaf buckets: 11111, nodes: 11814818 
    Average node length: 5.22, total dup: 11814718, max dup: 211848 
    Average key length: 2.00, compression ratio: 1.20 
    Average prefix length: 2.40, average data length: 0.00 
    Clustering factor: 743347, ratio: 0.06 
    Fill distribution: 
         0 - 19% = 89 
        20 - 39% = 726 
        40 - 59% = 5019 
        60 - 79% = 1478 
        80 - 99% = 3799 
 
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: 74.79, total records: 10381721 
    Average version length: 82.91, total versions: 997263, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.68 
    Pointer pages: 110, data page slots: 178528 
    Data pages: 178464, average fill: 73% 
    Primary pages: 178464, secondary pages: 0, swept pages: 44592 
    Empty pages: 681, full pages: 123800 
    Fill distribution: 
     0 - 19% = 1871 
    20 - 39% = 7047 
    40 - 59% = 25305 
    60 - 79% = 50223 
    80 - 99% = 94018 
 
    Index XQS_2100_3300_DOC_ID (1) 
    Root page: 1344686, depth: 3, leaf buckets: 12309, nodes: 10381721 
    Average node length: 5.21, total dup: 10352262, max dup: 1978 
    Average key length: 2.03, compression ratio: 4.43 
    Average prefix length: 8.97, average data length: 0.03 
    Clustering factor: 2084283, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 31 
        20 - 39% = 1267 
        40 - 59% = 8162 
        60 - 79% = 2174 
        80 - 99% = 675 
 
    Index XQS_2100_3300_RCV_ID (3) 
    Root page: 1355717, depth: 3, leaf buckets: 14063, nodes: 10381721 
    Average node length: 6.27, total dup: 8611115, max dup: 14 
    Average key length: 3.10, compression ratio: 2.91 
    Average prefix length: 8.07, average data length: 0.93 
    Clustering factor: 1527783, ratio: 0.15 
    Fill distribution: 
         0 - 19% = 192 
        20 - 39% = 3478 
        40 - 59% = 4829 
        60 - 79% = 2567 
        80 - 99% = 2997 
 
    Index XQS_2100_3300_SND_ID (2) 
    Root page: 1350049, depth: 3, leaf buckets: 12978, nodes: 10381721 
    Average node length: 5.46, total dup: 9927252, max dup: 102 
    Average key length: 2.28, compression ratio: 3.95 
    Average prefix length: 8.76, average data length: 0.24 
    Clustering factor: 2221910, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 24 
        20 - 39% = 1267 
        40 - 59% = 9071 
        60 - 79% = 1980 
        80 - 99% = 636 
 
    Index XQS_2100_3300_WORKER_ID (0) 
    Root page: 985805, depth: 3, leaf buckets: 10672, nodes: 10381721 
    Average node length: 5.18, total dup: 10381621, max dup: 163426 
    Average key length: 2.00, compression ratio: 1.20 
    Average prefix length: 2.40, average data length: 0.00 
    Clustering factor: 1631042, ratio: 0.16 
    Fill distribution: 
         0 - 19% = 45 
        20 - 39% = 1104 
        40 - 59% = 5400 
        60 - 79% = 1677 
        80 - 99% = 2446 
 
XQS_3300_3400 (187) 
    Primary pointer page: 571, Index root page: 572 
    Total formats: 1, used formats: 1 
    Average record length: 66.30, total records: 590430 
    Average version length: 68.74, total versions: 16231, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.90 
    Pointer pages: 5, data page slots: 8080 
    Data pages: 8080, average fill: 77% 
    Primary pages: 8080, secondary pages: 0, swept pages: 2584 
    Empty pages: 2, full pages: 7473 
    Fill distribution: 
     0 - 19% = 4 
    20 - 39% = 12 
    40 - 59% = 104 
    60 - 79% = 7593 
    80 - 99% = 367 
 
    Index XQS_3300_3400_DOC_ID (1) 
    Root page: 35001, depth: 3, leaf buckets: 741, nodes: 590430 
    Average node length: 5.95, total dup: 502927, max dup: 83 
    Average key length: 3.09, compression ratio: 2.91 
    Average prefix length: 8.06, average data length: 0.94 
    Clustering factor: 102420, ratio: 0.17 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 21 
        40 - 59% = 506 
        60 - 79% = 120 
        80 - 99% = 94 
 
    Index XQS_3300_3400_SND_ID (2) 
    Root page: 28196, depth: 3, leaf buckets: 773, nodes: 590430 
    Average node length: 6.15, total dup: 484348, max dup: 24 
    Average key length: 3.29, compression ratio: 2.74 
    Average prefix length: 7.89, average data length: 1.11 
    Clustering factor: 102469, ratio: 0.17 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 17 
        40 - 59% = 545 
        60 - 79% = 119 
        80 - 99% = 92 
 
    Index XQS_3300_3400_WORKER_ID (0) 
    Root page: 375548, depth: 2, leaf buckets: 572, nodes: 590430 
    Average node length: 4.86, total dup: 590330, max dup: 9839 
    Average key length: 2.00, compression ratio: 1.20 
    Average prefix length: 2.41, average data length: 0.00 
    Clustering factor: 90847, ratio: 0.15 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 11 
        40 - 59% = 333 
        60 - 79% = 99 
        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 Sun Apr 14 01:12:02 2024

Record versions statistics, table

TABLE_NAME TOTAL_RECS TOTAL_VERS MAX_VERSIONS VERS_TO_RECS_PRC MAXV_TO_VERS_PRC
DOC_DATA 7728900 38960 1 0.0000 0.0000
DOC_LIST 2234176 45000 3 0.0000 0.0000
FB_ERRORS 2182 757 1 0.0000 0.0000
INVNT_SALDO 400 246875 641 61700.0000 0.0000
INVNT_TURNOVER_LOG 63338 60769 1 0.0000 0.0000
MONEY_SALDO 49 18477 1013 37700.0000 0.0000
MONEY_TURNOVER_LOG 1440 1407 1 0.0000 0.0000
PDISTR 779536 35031 4 0.0000 0.0000
PERF_SPLIT_0 173999 4487 1 0.0000 0.0000
PERF_SPLIT_1 166885 543 1 0.0000 0.0000
PERF_SPLIT_2 168493 445 1 0.0000 0.0000
PERF_SPLIT_3 168167 2135 1 0.0000 0.0000
PERF_SPLIT_4 185215 26935 1 0.0000 0.0000
PERF_SPLIT_5 182438 1464 1 0.0000 0.0000
PERF_SPLIT_6 173984 918 1 0.0000 0.0000
PERF_SPLIT_7 199747 19851 1 0.0000 0.0000
PERF_SPLIT_8 173286 5726 1 0.0000 0.0000
PERF_SPLIT_9 171869 4173 1 0.0000 0.0000
PSTORNED 2106032 26944 1 0.0000 0.0000
SEMAPHORES 5 1 1 0.0000 100.0000
XQD_1000_1200 115535 33445 1 0.0000 0.0000
XQD_1000_3300 6850040 165955 1 0.0000 0.0000
XQD_1200_2000 11969244 153800 1 0.0000 0.0000
XQD_2000_3300 1235861 325112 1 0.0000 0.0000
XQD_2100_3300 1365741 709221 1 0.0000 0.0000
XQD_3300_3400 9928154 1117895 1 0.0000 0.0000
XQS_1000_1200 21220841 28322 1 0.0000 0.0000
XQS_1000_3300 10321916 1051337 1 0.0000 0.0000
XQS_1200_2000 11814818 863091 1 0.0000 0.0000
XQS_2100_3300 10381721 997263 1 0.0000 0.0000
XQS_3300_3400 590430 16231 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 ---
:1185: 
:1186: mscs-test-161.budzdorov.ru    Sun Apr 14 01:10:07 2024
:1187:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:1188: 
--- end of diff output ---

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

14.04.24 01:12:14. 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-04-14 01:12:16 No severe PSQL-related problems occured
14.04.24 01:12:18. End of report.