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

Hardware and OS info

Command: hostnamectl
Static hostname mscs-test-161.budzdorov.ru
Icon name computer-server
Chassis server
Machine ID aeee285d2cca40bf84c40a748f599e77
Boot ID 2a7b53d1c5ed44b9bb2712fffac5d8c6
Operating System CentOS Linux 7 (Core)
CPE OS Name cpe:/o:centos:centos:7
Kernel Linux 3.10.0-1127.10.1.el7.x86_64
Architecture x86-64
Command: who -b
bootup_info system boot 2021-11-11 18:28
Command: dmidecode -t system|grep -i -e 'manufacturer\|product\|hypervisor'
Manufacturer HP
Product Name ProLiant DL380 Gen9
Command: dmesg | grep DMI
[ 0.000000] DMI HP ProLiant DL380 Gen9/ProLiant DL380 Gen9, BIOS P89 05/21/2018
Command: lscpu | grep -i -v flags
Architecture x86_64
CPU op-mode(s) 32-bit, 64-bit
Byte Order Little Endian
CPU(s) 24
On-line CPU(s) list 0-23
Thread(s) per core 2
Core(s) per socket 6
Socket(s) 2
NUMA node(s) 2
Vendor ID GenuineIntel
CPU family 6
Model 63
Model name Intel(R) Xeon(R) CPU E5-2620 v3 @ 2.40GHz
Stepping 2
CPU MHz 1200.000
CPU max MHz 2400.0000
CPU min MHz 1200.0000
BogoMIPS 4794.33
Virtualization VT-x
L1d cache 32K
L1i cache 32K
L2 cache 256K
L3 cache 15360K
NUMA node0 CPU(s) 0-5,12-17
NUMA node1 CPU(s) 6-11,18-23
Command: cat /proc/meminfo | grep -i -e 'memtotal\|memfree\|memavail\|buffers\|cached\|swapcached'
MemTotal 32643792 kB
MemFree 15830128 kB
MemAvailable 30265932 kB
Buffers 0 kB
Cached 15914144 kB
SwapCached 2208 kB
Command: fdisk -l
WARNING: fdisk GPT support is currently new, and therefore in an experimental phase. Use at your own discretion.
Disk /dev/sda: 599.9 GB, 599932581888 bytes, 1171743324 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 262144 bytes / 524288 bytes
Disk label type: gpt
Disk identifier: 919DACA4-2F35-4CBB-BAA7-2A8CD8F7168C
# Start End Size Type Name
1 2048 411647 200M EFI System EFI System Partition
2 411648 2508799 1G Microsoft basic
3 2508800 1171742719 557.5G Linux LVM
Disk /dev/mapper/centos_mscs--test--161-root: 53.7 GB, 53687091200 bytes, 104857600 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 262144 bytes / 524288 bytes
Disk /dev/mapper/centos_mscs--test--161-swap: 16.8 GB, 16844324864 bytes, 32899072 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 262144 bytes / 524288 bytes
Disk /dev/sdb: 536 MB, 536870912 bytes, 1048576 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 512 bytes / 512 bytes
Disk label type: dos
Disk identifier: 0x00000046
Device Boot Start End Blocks Id System
/dev/sdb1 63 514079 257008+ c W95 FAT32 (LBA)
Disk /dev/mapper/centos_mscs--test--161-home: 528.1 GB, 528109010944 bytes, 1031462912 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 262144 bytes / 524288 bytes

Server and database settinfs 


SERVER_MODE                     SuperServer 3.0.12
DB_NAME                         /home/bases/oltp30-etalone.fdb
FORCED_WRITES                   ON
SWEEP_INT                       0
PAGE_BUFFERS                    1000000
PAGE_SIZE                       8192

Test configuration settings 

param=actions_todo_before_reconnect, val=300
param=create_with_compound_columns_order, val=most_selective_first
param=create_with_debug_objects, val=1
param=create_with_fw, val=sync
param=create_with_separate_qdistr_idx, val=0
param=create_with_split_heavy_tabs, val=1
param=create_with_sweep, val=0
param=dbnm, val=/home/bases/oltp30-etalone.fdb
param=detailed_info, val=0
param=etalon_dbnm, val=/home/bases/oltp30-etalone.fd0
param=expected_workers, val=100
param=fbc, val=/opt/fb30/bin
param=file_name_this_host_info, val=bz_cpu24_ram32
param=file_name_with_test_params, val=regular
param=gather_hardware_info, val=1
param=halt_test_on_errors, val=/CK/
param=host, val=localhost
param=init_buff, val=10000
param=init_docs, val=0
param=is_embed, val=0
param=make_html, val=1
param=max_cps, val=25
param=mon_query_interval, val=60
param=mon_query_role, val=tmp$oemul$worker
param=mon_unit_list, val=//
param=mon_unit_perf, val=2
param=mon_usr_prefix, val=tmp$oemul$user_
param=no_auto_undo, val=1
param=port, val=3333
param=pwd, val=masterkey
param=qmism_verify_bitset, val=1
param=recalc_idx_min_interval, val=30
param=remove_isql_logs, val=if_no_severe_errors
param=replace_instance, val=1
param=report_compress_cmd, val=/usr/bin/7za
param=results_storage_fbk, val=/home/bases/oltp30-results-storage.fbk
param=run_db_statistics, val=1
param=run_db_validation, val=0
param=separate_workers, val=1
param=sleep_ddl, val=./oltp_sleepUDF_nix.sql
param=sleep_max, val=0
param=test_intervals, val=60
param=test_time, val=100
param=tmpdir, val=/var/tmp/logs-oltp30
param=unit_selection_method, val=random
param=update_conflict_percent, val=0
param=used_in_replication, val=0
param=use_mtee, val=0
param=usr, val=SYSDBA
param=wait_after_create, val=0
param=wait_for_copy, val=1
param=wait_if_not_exists, val=0
param=warm_time, val=20
param=working_mode, val=small_03
Custom name of interactive SQL utility: parameter: 'clu', value: |isql|

Test finish info 


FINISH_STATE                    NORMAL: TEST_TIME EXPIRED AT 2024-03-07 16:09:41
DTS_END                         2024-03-07 16:09:41.4210
FB_GDSCODE                      -1
FB_MNEMONA                      
STACK                           SP_CANCEL_SUPPLIER_ORDER(116:18) ==> SP_CANCEL_CUSTOMER_RESERVE(36:5) ==> SP_CHECK_TO_STOP_WORK(32:12) ==> SP_HALT_ON_ERROR(57:17)
IP                              ::1/45022
TRN_ID                          172095
ATT_ID                          540
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: 8883.81 20482 888381
customer order: creation 172.99 378 17299
customer order: refuse 14.63 388 1463
order to supplier: creation 45.22 1414 4522
order to supplier: removal 3.77 99456 377
invoice (draft): creation 46.28 3657 4628
invoice (draft): removal 48.34 895 4834
invoice accept: apply 41.12 21276 4112
invoice accept: cancel 43.21 896 4321
customer reserve: creation 3937.61 203 393761
customer reserve: removal 4248.38 69 424838
realization accept: apply 82.89 236 8289
realization accept: cancel 71.21 136 7121
payment from customer: creation 59.19 165 5919
payment from customer: removal 5.79 104 579
payment to supplier: creation 47.29 195 4729
payment to supplier: removal 3.41 68 341
service: total inventory turnovers 4.77 1228 477
service: total monetary turnovers 6.93 38 693
service: aggregate perf. data 0.75 18861 75
service: refresh index statistics 0.03 259978 3

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:02, from 07-03-2024 16:10:46 to 07-03-2024 16:10:48.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 4234
TEST_TIME 2 3810
TEST_TIME 3 3196
TEST_TIME 4 3441
TEST_TIME 5 3944
TEST_TIME 6 3922
TEST_TIME 7 4432
TEST_TIME 8 4350
TEST_TIME 9 4353
TEST_TIME 10 4732
TEST_TIME 11 4659
TEST_TIME 12 4773
TEST_TIME 13 5268
TEST_TIME 14 5287
TEST_TIME 15 5531
TEST_TIME 16 5527
TEST_TIME 17 5982
TEST_TIME 18 6373
TEST_TIME 19 6693
TEST_TIME 20 6741
TEST_TIME 21 6961
TEST_TIME 22 7199
TEST_TIME 23 7579
TEST_TIME 24 7630
TEST_TIME 25 7787
TEST_TIME 26 7809
TEST_TIME 27 7992
TEST_TIME 28 8403
TEST_TIME 29 9052
TEST_TIME 30 9692
TEST_TIME 31 9469
TEST_TIME 32 9460
TEST_TIME 33 9335
TEST_TIME 34 9139
TEST_TIME 35 9063
TEST_TIME 36 9055
TEST_TIME 37 8965
TEST_TIME 38 8969
TEST_TIME 39 8864
TEST_TIME 40 8927
TEST_TIME 41 8930
TEST_TIME 42 8871
TEST_TIME 43 8783
TEST_TIME 44 8799
TEST_TIME 45 8634
TEST_TIME 46 8638
TEST_TIME 47 8684
TEST_TIME 48 8693
TEST_TIME 49 8706
TEST_TIME 50 8721
TEST_TIME 51 8785
TEST_TIME 52 8794
TEST_TIME 53 8860
TEST_TIME 54 8805
TEST_TIME 55 8767
TEST_TIME 56 8839
TEST_TIME 57 8808
TEST_TIME 58 8858
TEST_TIME 59 8951
TEST_TIME 60 8977
TEST_TIME 61 8910
TEST_TIME 62 8811
TEST_TIME 63 8797
TEST_TIME 64 8753
TEST_TIME 65 8697
TEST_TIME 66 8725
TEST_TIME 67 8696
TEST_TIME 68 8643
TEST_TIME 69 8572
TEST_TIME 70 8607
TEST_TIME 71 8665
TEST_TIME 72 8769
TEST_TIME 73 8753
TEST_TIME 74 8742
TEST_TIME 75 8882
TEST_TIME 76 8869
TEST_TIME 77 8892
TEST_TIME 78 8934
TEST_TIME 79 8962
TEST_TIME 80 8944
TEST_TIME 81 9046
TEST_TIME 82 9138
TEST_TIME 83 9135
TEST_TIME 84 9104
TEST_TIME 85 9031
TEST_TIME 86 9023
TEST_TIME 87 8974
TEST_TIME 88 8954
TEST_TIME 89 8969
TEST_TIME 90 8949
TEST_TIME 91 8900
TEST_TIME 92 8896
TEST_TIME 93 8862
TEST_TIME 94 8863
TEST_TIME 95 8866
TEST_TIME 96 8887
TEST_TIME 97 8867
TEST_TIME 98 8937
TEST_TIME 99 8927
TEST_TIME 100 8888

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:04, from 07-03-2024 16:10:49 to 07-03-2024 16:10:53.

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 1249854 1249854 0 0.00 0 52774 8 0 0
doc_list_biud 1249853 1249853 0 0.00 0 44835 30 0 0
sp_add_invoice_to_stock 4186 4112 74 1.76 46 202906 21277 0 74
sp_cancel_adding_invoice 4321 4321 0 0.00 4 86719 897 0 0
sp_cancel_client_order 1463 1463 0 0.00 4 14898 389 0 0
sp_cancel_customer_reserve 424838 424838 0 0.00 0 44837 69 0 0
sp_cancel_pay_from_customer 579 579 0 0.00 3 10013 105 0 0
sp_cancel_pay_to_supplier 341 341 0 0.00 3 5054 68 0 0
sp_cancel_supplier_invoice 4839 4834 5 0.10 1 18371 895 0 5
sp_cancel_supplier_order 377 377 0 0.00 9 1044607 99456 0 0
sp_cancel_write_off 7121 7121 0 0.00 1 27915 137 0 0
sp_client_order 17299 17299 0 0.00 3 30276 379 0 0
sp_customer_reserve 393761 393761 0 0.00 0 45390 203 0 0
sp_fill_shopping_cart 26438 26438 0 0.00 1 16767 45 0 0
sp_fill_shopping_cart_clo_res 393753 393753 0 0.00 0 14697 15 0 0
sp_get_clo_for_invoice 4104 4104 0 0.00 0 28146 336 0 0
sp_kill_cost_storno 12362 12362 0 0.00 0 9999 67 0 0
sp_kill_qstorno_ret_qs2qd 862008 862008 0 0.00 0 38441 37 0 0
sp_kill_qty_storno 455347 455347 0 0.00 0 44835 81 0 0
sp_lock_selected_doc 17189 17189 0 0.00 0 10667 7 0 0
sp_make_cost_storno 23041 23041 0 0.00 0 52612 83 0 0
sp_multiply_rows_for_pdistr 23041 23041 0 0.00 0 24056 42 0 0
sp_multiply_rows_for_qdistr 17299 17299 0 0.00 0 11709 169 0 0
sp_pay_from_customer 5919 5919 0 0.00 3 24070 166 0 0
sp_pay_to_supplier 4729 4729 0 0.00 5 28983 196 0 0
sp_payment_common 10648 10648 0 0.00 1 21899 38 0 0
sp_qd_handle_on_cancel_clo 1463 1463 0 0.00 0 7472 321 0 0
sp_qd_handle_on_invoice_upd_sts 8425 8425 0 0.00 0 27765 377 0 0
sp_qd_handle_on_reserve_upd_sts 8289 8289 0 0.00 0 30259 68 0 0
sp_reserve_write_off 8289 8289 0 0.00 6 30377 236 0 0
sp_supplier_invoice 4628 4628 0 0.00 7 103679 3657 0 0
sp_supplier_order 4522 4522 0 0.00 4 50178 1414 0 0
srv_aggregate_perf_data 75 75 0 0.00 1576 152838 18861 0 0
srv_fill_mon_cache_memory 53 53 0 0.00 1178 108071 43622 0 0
srv_find_qd_qs_mism 846825 846825 0 0.00 0 20225 6 0 0
srv_make_invnt_saldo 477 477 0 0.00 52 152234 1229 0 0
srv_make_money_saldo 693 693 0 0.00 1 6791 38 0 0
srv_recalc_idx_stat 3 3 0 0.00 186726 400539 259978 0 0
t$perf-abend:sp_add_invoice_to_stock 74 74 0 0.00 0 0 0 0 0
t$perf-abend:sp_cancel_supplier_invoice 5 5 0 0.00 0 0 0 0 0
t$perf-norm:sp_add_invoice_to_stock 4112 4112 0 0.00 0 25814 231 0 0
t$perf-norm:sp_cancel_adding_invoice 340 340 0 0.00 1 4230 89 0 0
t$perf-norm:sp_cancel_client_order 1463 1463 0 0.00 0 1135 14 0 0
t$perf-norm:sp_cancel_customer_reserve 549 549 0 0.00 0 3049 22 0 0
t$perf-norm:sp_cancel_pay_from_customer 579 579 0 0.00 0 422 4 0 0
t$perf-norm:sp_cancel_pay_to_supplier 341 341 0 0.00 0 327 2 0 0
t$perf-norm:sp_cancel_supplier_invoice 329 329 0 0.00 0 1325 23 0 0
t$perf-norm:sp_cancel_supplier_order 377 377 0 0.00 0 28721 1816 0 0
t$perf-norm:sp_cancel_write_off 818 818 0 0.00 0 1329 6 0 0
t$perf-norm:sp_client_order 17299 17299 0 0.00 0 16836 23 0 0
t$perf-norm:sp_customer_reserve 837 837 0 0.00 0 6529 20 0 0
t$perf-norm:sp_pay_from_customer 5919 5919 0 0.00 0 3651 8 0 0
t$perf-norm:sp_pay_to_supplier 4729 4729 0 0.00 0 16027 13 0 0
t$perf-norm:sp_reserve_write_off 8289 8289 0 0.00 0 6739 10 0 0
t$perf-norm:sp_supplier_invoice 4628 4628 0 0.00 0 8995 16 0 0
t$perf-norm:sp_supplier_order 4522 4522 0 0.00 0 16010 24 0 0
t$perf-norm:srv_aggregate_perf_data 75 75 0 0.00 0 393 7 0 0
t$perf-norm:srv_fill_mon_cache_memory 53 53 0 0.00 0 9 1 0 0
t$perf-norm:srv_make_invnt_saldo 477 477 0 0.00 0 954 24 0 0
t$perf-norm:srv_make_money_saldo 693 693 0 0.00 0 549 10 0 0
t$perf-norm:srv_recalc_idx_stat 3 3 0 0.00 2 14 7 0 0
v_add_invoice_to_stock 8356 8208 148 1.77 0 6317 20 0 148
v_all_customers 31798 31798 0 0.00 0 113 1 0 0
v_all_suppliers 25570 25570 0 0.00 0 111 1 0 0
v_all_wares 34594 34594 0 0.00 0 25 1 0 0
v_cancel_adding_invoice 680 680 0 0.00 0 2169 12 0 0
v_cancel_client_order 2926 2926 0 0.00 0 14517 19 0 0
v_cancel_customer_prepayment 1158 1158 0 0.00 0 1903 7 0 0
v_cancel_customer_reserve 1098 1098 0 0.00 0 1990 7 0 0
v_cancel_payment_to_supplier 682 682 0 0.00 0 542 4 0 0
v_cancel_supplier_invoice 668 658 10 1.49 0 1301 16 0 10
v_cancel_supplier_order 754 754 0 0.00 0 3403 15 0 0
v_cancel_write_off 1636 1636 0 0.00 0 647 12 0 0
v_max_id_clo_ord 4519 4519 0 0.00 0 1637 3 0 0
v_max_id_clo_res 837 837 0 0.00 0 2258 14 0 0
v_max_id_ord_sup 4621 4621 0 0.00 0 5973 5 0 0
v_max_non_paid_invoice 1084 1084 0 0.00 0 1276 6 0 0
v_max_non_paid_realizn 2942 2942 0 0.00 0 2228 5 0 0
v_min_id_clo_ord 4519 4519 0 0.00 0 9565 23 0 0
v_min_id_clo_res 837 837 0 0.00 0 879 5 0 0
v_min_id_ord_sup 4621 4621 0 0.00 0 4910 6 0 0
v_min_non_paid_invoice 4729 4729 0 0.00 0 17897 36 0 0
v_min_non_paid_realizn 5919 5919 0 0.00 0 15829 24 0 0
v_our_firm 8750 8750 0 0.00 0 31 1 0 0
v_reserve_write_off 16578 16578 0 0.00 0 13577 9 0 0
x_lock_depdocs_on_canc_invoice 8826 8826 0 0.00 0 13191 155 0 0
x_lock_depdocs_on_canc_sup_ord 377 377 0 0.00 0 6827 328 0 0
x_make_qstorno_1000_1200 4522 4522 0 0.00 1 50028 1318 0 0
x_make_qstorno_1200_2000 4628 4628 0 0.00 2 103382 3494 0 0
x_make_qstorno_2100_3300 393761 393761 0 0.00 0 45389 185 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 07-03-2024 16:10:54 to 07-03-2024 16:10:58.

Memory consumption, metadata cache, attachments activity 

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


Page cache type: shared, buffers: 1000000 for all connections, with total size: 8192000000
measurement_dts measurement duration ms page cache memo used memo used, total memo allocated, total metadata cache metadata cache percent of total total attachments cnt active attachments cnt running statements cnt stalled statements cnt memo used by attachments memo used by transactions memo used by statements
14:09:45 7 8192000000 8813494688 8830160896 17376720 0.211 6 4 4 0 17566432 82608 107104
14:10:45 33738 8192000000 9905225408 10217435136 979981888 10.684 100 85 168 0 1007397552 5573104 21842560
14:12:22 29357 8192000000 9948138032 10271145984 1034523760 11.212 100 87 174 0 1064458432 8009488 21925184
14:14:00 14041 8192000000 9995519952 10333388800 1074739760 11.597 100 81 162 0 1104453232 9746656 19966816
14:15:17 17248 8192000000 10042868576 10389983232 1122548880 12.051 100 79 158 0 1151953536 10259680 19144976
14:16:37 8897 8192000000 10098012176 10459672576 1183382480 12.622 100 83 162 0 1214299040 12450160 18466400
14:17:49 3367 8192000000 10140987616 10512805888 1229432224 13.049 100 75 149 0 1258113344 12758240 15922880
14:18:56 1123 8192000000 10177577920 10553176064 1262682160 13.355 100 90 181 1 1295499888 12810992 20006736
14:20:00 1439 8192000000 10191740640 10575237120 1285350064 13.562 100 83 165 0 1317146128 13364320 18431744
14:21:02 16626 8192000000 10202818976 10599104512 1298797488 13.684 100 70 138 1 1324463984 10080608 15585888
14:22:20 1120 8192000000 10211999728 10613620736 1312054416 13.805 100 56 114 2 1334043488 9657472 12331600
14:23:24 10642 8192000000 10205310448 10621460480 1320583328 13.882 100 16 31 1 1329348864 5615744 3149792
14:24:36 9357 8192000000 10212725440 10631589888 1327685392 13.946 100 19 39 0 1341649856 10078144 3886320
14:25:50 42056 8192000000 10217332864 10646827008 1334807712 14.011 100 31 60 1 1347224960 5208000 7209248
14:27:33 7152 8192000000 10235706608 10656550912 1340089392 14.058 100 40 79 0 1356724464 7854944 8780128
14:28:44 6805 8192000000 10214012752 10633449472 1323569232 13.909 100 16 31 0 1332468864 5747840 3151792
14:29:57 46240 8192000000 10223450000 10621026304 1296844944 13.667 98 51 99 1 1314575072 6249376 11480752
14:31:52 77155 8192000000 10227294976 10646224896 1318832448 13.866 99 44 86 0 1345161488 15666992 10662048
14:34:44 15102 8192000000 10231005872 10653003776 1330451808 13.971 100 42 84 0 1352086592 11871680 9763104
14:36:09 26227 8192000000 10219360528 10629554176 1301545680 13.709 98 42 82 1 1329851792 18961856 9344256
14:37:41 36799 8192000000 10234943376 10649833472 1305379456 13.744 98 38 76 0 1331598272 17115168 9103648
14:39:57 14530 8192000000 10230149296 10632699904 1304547296 13.737 99 52 104 1 1334893152 18266976 12078880
14:41:16 5428 8192000000 10216798416 10610872320 1277021088 13.486 98 55 108 0 1308540016 18735728 12783200
14:42:26 13845 8192000000 10240965552 10638102528 1298416384 13.681 99 54 107 1 1337775712 26199056 13160272
14:43:45 10333 8192000000 10266444080 10671845376 1335759168 14.019 100 51 102 0 1375428016 27110000 12558848
14:45:06 8037 8192000000 10288841344 10686390272 1342995792 14.084 100 76 150 0 1390768176 30184672 17587712
14:46:19 1213 8192000000 10302997936 10703634432 1354890000 14.191 100 73 143 1 1406971712 34345600 17736112
14:47:25 2053 8192000000 10306865424 10711396352 1356753152 14.208 100 73 145 0 1411679312 36787472 18138688
14:48:33 1178 8192000000 10329220112 10728034304 1371054128 14.336 100 93 181 0 1428401920 36241968 21105824
14:49:38 3905 8192000000 10336217360 10739261440 1377056544 14.390 100 75 149 0 1435765312 40886672 17822096
14:50:49 5548 8192000000 10343669232 10752258048 1384868944 14.460 100 74 147 0 1447823808 44600992 18353872
14:52:03 6458 8192000000 10356412048 10775531520 1400061856 14.596 100 50 97 0 1462013168 49326176 12625136
14:53:13 18225 8192000000 10359823904 10784448512 1398719456 14.584 100 30 60 0 1452496912 45042112 8735344
14:54:40 10343 8192000000 10347797616 10776281088 1383527488 14.448 99 43 83 0 1442071152 47214208 11329456
14:56:01 11137 8192000000 10329245360 10758602752 1365769328 14.289 99 27 52 0 1426329232 52855088 7704816
14:57:53 56327 8192000000 10316663984 10765852672 1373810048 14.361 100 18 36 0 1430854336 51596880 5447408
14:59:55 38253 8192000000 10287485920 10728169472 1363015232 14.264 99 21 40 0 1378273120 10308384 4949504
15:01:39 75837 8192000000 10275741952 10727796736 1373257712 14.356 100 23 46 0 1388472336 9780640 5433984
15:04:01 33061 8192000000 10288868512 10734731264 1383795120 14.450 100 30 59 1 1397773280 7863968 6114192
15:05:38 26284 8192000000 10309689072 10745114624 1398195488 14.579 100 55 110 2 1417464128 6798432 12470208
15:07:08 90453 8192000000 10297355328 10755362816 1389890768 14.505 99 10 20 0 1403987680 11722272 2374640
15:09:49 88991 8192000000 10303159856 10757509120 1370880320 14.335 97 17 34 0 1386823264 12308336 3634608
15:12:40 72063 8192000000 10298855136 10757529600 1402834144 14.620 100 16 31 0 1421077680 14146640 4096896
15:14:54 56076 8192000000 10297925600 10769195008 1403919168 14.630 100 13 26 0 1416077888 9400272 2758448
15:17:00 72428 8192000000 10310726352 10777022464 1407322976 14.660 100 12 24 0 1423124880 13263680 2538224
15:19:32 58945 8192000000 10317539520 10772967424 1408744560 14.673 100 14 28 0 1421208192 9085504 3378128
15:21:33 86558 8192000000 10282694480 10736988160 1321595904 13.891 94 6 12 0 1331698208 9044880 1057424
15:24:01 14395 8192000000 10297457184 10732343296 1376924384 14.389 100 54 108 0 1401057408 12029152 12103872
15:25:19 52291 8192000000 10262286144 10702323712 1280947184 13.522 94 36 72 0 1301232064 12390624 7894256
15:27:12 46341 8192000000 10289265968 10734088192 1361171056 14.248 100 38 76 0 1386486400 17066208 8249136
15:29:03 18806 8192000000 10282739728 10714632192 1339146400 14.050 98 29 58 1 1354076864 8327536 6602928
15:30:27 83260 8192000000 10237631408 10673262592 1274595584 13.464 94 24 44 0 1288096288 7492672 6008032
15:32:58 77851 8192000000 10228996016 10675318784 1309351248 13.780 98 15 30 0 1322063216 9726128 2985840
15:35:18 45700 8192000000 10236854256 10684305408 1330273488 13.970 99 13 26 0 1343674336 10327888 3072960
15:38:19 61242 8192000000 10223449952 10678439936 1323300480 13.907 99 12 24 0 1340786992 14820112 2666400
15:40:26 53372 8192000000 10257689968 10702008320 1343936064 14.093 99 9 18 0 1355318256 9454912 1927280
15:42:21 24271 8192000000 10269191360 10708307968 1350324256 14.150 99 21 42 0 1361530672 6773456 4432960
15:43:53 72654 8192000000 10250404176 10698096640 1312907888 13.812 96 17 34 0 1334882832 17777520 4197424
15:46:11 22331 8192000000 10274102256 10712215552 1349317264 14.141 99 32 64 0 1365983696 9543712 7122720
15:47:34 49290 8192000000 10285434352 10717892608 1354516464 14.188 99 24 48 0 1372056048 11795936 5743648
15:49:26 78886 8192000000 10281445984 10742755328 1365895136 14.290 99 13 26 0 1387299872 18255632 3149104
15:51:52 84229 8192000000 10286506976 10736697344 1375158944 14.373 100 18 34 2 1394081152 15401488 3520720
15:54:17 108071 8192000000 10291583168 10741063680 1385734592 14.468 100 21 42 0 1398557760 8067584 4755584
15:57:14 17660 8192000000 10307065280 10748530688 1390749664 14.513 100 44 88 0 1411194480 11029456 9415360
15:58:33 44113 8192000000 10285100368 10742501376 1377224624 14.392 99 7 14 1 1386422288 7333920 1863744
16:00:17 60895 8192000000 10267874064 10722246656 1346111568 14.112 97 11 22 0 1356857616 8202640 2543408
16:02:50 72177 8192000000 10278196016 10734759936 1366784464 14.298 99 14 28 1 1380662992 10432688 3445840
16:05:02 70852 8192000000 10277249024 10732544000 1359906912 14.237 98 19 38 0 1375242240 10900000 4435328
16:07:17 84205 8192000000 10276889920 10729451520 1358136432 14.221 98 24 48 0 1373563120 9937328 5489360

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:13, from 07-03-2024 16:11:00 to 07-03-2024 16:11:13.

Exceptions occured during test was in run

FB_MNEMONA CNT UNIT FB_GDSCODE
except 74 v_add_invoice_to_stock 335544517
except 5 v_cancel_supplier_invoice 335544517

Completed "Exceptions occured during test was in run". Done for 00:00:02, from 07-03-2024 16:11:14 to 07-03-2024 16:11:16.

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          171333
MON$OLDEST_ACTIVE               173156
MON$OLDEST_SNAPSHOT             173156
MON$NEXT_TRANSACTION            173156
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                       1901472
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.33734 Firebird 3.0
Server version:
Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V3.0.12.33734 Firebird 3.0"
Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-V3.0.12.33734 Firebird 3.0/tcp (mscs-test-161.budzdorov.ru)/P15:C"
Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-V3.0.12.33734 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 Thu Mar  7 16:11:17 2024 
 
Database header page information: 
    Flags            0 
    Generation        90124 
    System Change Number    0 
    Page size        8192 
    ODS version        12.0 
    Oldest transaction    171333 
    Oldest active        173156 
    Oldest snapshot        173156 
    Next transaction    173157 
    Sequence number        0 
    Next attachment ID    701 
    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.30, total records: 7787961 
    Average version length: 48.16, total versions: 96918, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 64.00, compression ratio: 1.35 
    Pointer pages: 54, data page slots: 86760 
    Data pages: 86760, average fill: 72% 
    Primary pages: 86760, secondary pages: 0, swept pages: 15646 
    Empty pages: 4, full pages: 70713 
    Fill distribution: 
     0 - 19% = 26 
    20 - 39% = 124 
    40 - 59% = 1927 
    60 - 79% = 84655 
    80 - 99% = 28 
 
    Index DOC_DATA_DOC_WARE_UNQ (0) 
    Root page: 1510614, depth: 3, leaf buckets: 23346, nodes: 7787961 
    Average node length: 18.91, total dup: 0, max dup: 0 
    Average key length: 15.92, compression ratio: 1.70 
    Average prefix length: 14.08, average data length: 12.92 
    Clustering factor: 1729918, ratio: 0.22 
    Fill distribution: 
         0 - 19% = 366 
        20 - 39% = 1713 
        40 - 59% = 4220 
        60 - 79% = 2289 
        80 - 99% = 14758 
 
    Index DOC_DATA_ID_DESC (1) 
    Root page: 1528118, depth: 3, leaf buckets: 13552, nodes: 7787961 
    Average node length: 11.20, total dup: 0, max dup: 0 
    Average key length: 8.21, compression ratio: 1.10 
    Average prefix length: 3.79, average data length: 5.21 
    Clustering factor: 1553006, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 1577 
        40 - 59% = 2061 
        60 - 79% = 1073 
        80 - 99% = 8841 
 
    Index FK_DOC_DATA_DOC_LIST (2) 
    Root page: 1546711, depth: 3, leaf buckets: 8353, nodes: 7787961 
    Average node length: 6.63, total dup: 5812788, max dup: 49 
    Average key length: 3.64, compression ratio: 2.47 
    Average prefix length: 7.62, average data length: 1.38 
    Clustering factor: 1545906, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 136 
        20 - 39% = 907 
        40 - 59% = 1426 
        60 - 79% = 905 
        80 - 99% = 4979 
 
DOC_LIST (138) 
    Primary pointer page: 472, Index root page: 473 
    Total formats: 1, used formats: 1 
    Average record length: 56.25, total records: 2264599 
    Average version length: 34.56, total versions: 94926, max versions: 3 
    Average fragment length: 6.00, total fragments: 2, max fragments: 1 
    Average unpacked length: 84.00, compression ratio: 1.49 
    Pointer pages: 18, data page slots: 28416 
    Data pages: 28416, average fill: 74% 
    Primary pages: 28408, secondary pages: 8, swept pages: 9284 
    Empty pages: 7, full pages: 22222 
    Fill distribution: 
     0 - 19% = 31 
    20 - 39% = 113 
    40 - 59% = 1522 
    60 - 79% = 25791 
    80 - 99% = 959 
 
    Index DOC_LIST_ID_DESC (1) 
    Root page: 1541130, depth: 3, leaf buckets: 4572, nodes: 2264599 
    Average node length: 11.40, total dup: 0, max dup: 0 
    Average key length: 8.44, compression ratio: 1.07 
    Average prefix length: 3.56, average data length: 5.44 
    Clustering factor: 704419, ratio: 0.31 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 913 
        40 - 59% = 862 
        60 - 79% = 680 
        80 - 99% = 2117 
 
    Index DOC_LIST_WORKER_OPTYPE (2) 
    Root page: 1544376, depth: 3, leaf buckets: 2520, nodes: 2267075 
    Average node length: 4.97, total dup: 2266176, max dup: 18239 
    Average key length: 2.01, compression ratio: 4.47 
    Average prefix length: 8.99, average data length: 0.01 
    Clustering factor: 1250558, ratio: 0.55 
    Fill distribution: 
         0 - 19% = 4 
        20 - 39% = 266 
        40 - 59% = 1511 
        60 - 79% = 528 
        80 - 99% = 211 
 
    Index FK_DOC_LIST_AGENTS (3) 
    Root page: 1545909, depth: 3, leaf buckets: 1997, nodes: 2264599 
    Average node length: 4.97, total dup: 2264549, max dup: 130404 
    Average key length: 2.01, compression ratio: 4.48 
    Average prefix length: 8.99, average data length: 0.01 
    Clustering factor: 1063505, ratio: 0.47 
    Fill distribution: 
         0 - 19% = 5 
        20 - 39% = 81 
        40 - 59% = 991 
        60 - 79% = 46 
        80 - 99% = 874 
 
    Index PK_DOC_LIST (0) 
    Root page: 1538187, depth: 3, leaf buckets: 4353, nodes: 2264599 
    Average node length: 11.40, total dup: 0, max dup: 0 
    Average key length: 8.44, compression ratio: 1.07 
    Average prefix length: 3.56, average data length: 5.44 
    Clustering factor: 704419, ratio: 0.31 
    Fill distribution: 
         0 - 19% = 99 
        20 - 39% = 567 
        40 - 59% = 637 
        60 - 79% = 778 
        80 - 99% = 2272 
 
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.23, total records: 400 
    Average version length: 23.00, total versions: 239132, max versions: 623 
    Average fragment length: 2.00, total fragments: 60, max fragments: 1 
    Average unpacked length: 104.00, compression ratio: 1.26 
    Pointer pages: 1, data page slots: 1328 
    Data pages: 1328, average fill: 90% 
    Primary pages: 8, secondary pages: 1320, swept pages: 0 
    Empty pages: 1, full pages: 1326 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 0 
    40 - 59% = 1 
    60 - 79% = 0 
    80 - 99% = 1326 
 
    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: 5.42, total records: 69379 
    Average version length: 68.29, total versions: 63870, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 88.00, compression ratio: 16.23 
    Pointer pages: 7, data page slots: 2216 
    Data pages: 1960, average fill: 45% 
    Primary pages: 1958, secondary pages: 2, swept pages: 0 
    Empty pages: 595, full pages: 725 
    Fill distribution: 
     0 - 19% = 771 
    20 - 39% = 177 
    40 - 59% = 175 
    60 - 79% = 211 
    80 - 99% = 626 
 
    Index INVNT_TURNOVER_LOG_WARE_DD_ID (0) 
    Root page: 1710329, depth: 3, leaf buckets: 299, nodes: 69379 
    Average node length: 13.43, total dup: 4196, max dup: 2 
    Average key length: 10.83, compression ratio: 2.49 
    Average prefix length: 19.10, average data length: 7.90 
    Clustering factor: 52017, ratio: 0.75 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 186 
        40 - 59% = 106 
        60 - 79% = 7 
        80 - 99% = 0 
 
MONEY_SALDO (141) 
    Primary pointer page: 478, Index root page: 479 
    Total formats: 1, used formats: 1 
    Average record length: 15.22, total records: 49 
    Average version length: 9.00, total versions: 18023, max versions: 959 
    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: 80% 
    Primary pages: 8, secondary pages: 64, swept pages: 0 
    Empty pages: 7, full pages: 64 
    Fill distribution: 
     0 - 19% = 7 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 9 
    80 - 99% = 56 
 
    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: 3.45, total records: 1035 
    Average version length: 43.38, total versions: 953, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 58.00, compression ratio: 16.82 
    Pointer pages: 1, data page slots: 40 
    Data pages: 27, average fill: 39% 
    Primary pages: 25, secondary pages: 2, swept pages: 1 
    Empty pages: 5, full pages: 6 
    Fill distribution: 
     0 - 19% = 10 
    20 - 39% = 5 
    40 - 59% = 5 
    60 - 79% = 2 
    80 - 99% = 5 
 
    Index MONEY_TURNOVER_LOG_AGENT_OPTYPE (0) 
    Root page: 91476, depth: 2, leaf buckets: 3, nodes: 1035 
    Average node length: 4.73, total dup: 937, max dup: 114 
    Average key length: 3.00, compression ratio: 6.33 
    Average prefix length: 18.09, average data length: 0.91 
    Clustering factor: 609, ratio: 0.59 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 2 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
MON_CACHE_MEMORY (165) 
    Primary pointer page: 526, Index root page: 527 
    Total formats: 2, used formats: 1 
    Average record length: 97.14, total records: 69 
    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: 48% 
    Primary pages: 2, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 1 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 1 
 
    Index PK_MON_CACHE_MEMORY (0) 
    Root page: 1504215, depth: 1, leaf buckets: 1, nodes: 69 
    Average node length: 11.71, total dup: 0, max dup: 0 
    Average key length: 10.70, compression ratio: 0.84 
    Average prefix length: 1.29, average data length: 7.71 
    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.00, total records: 793297 
    Average version length: 25.53, total versions: 70599, max versions: 5 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 54.00, compression ratio: 1.50 
    Pointer pages: 5, data page slots: 8160 
    Data pages: 8160, average fill: 68% 
    Primary pages: 8134, secondary pages: 26, swept pages: 1570 
    Empty pages: 119, full pages: 6992 
    Fill distribution: 
     0 - 19% = 249 
    20 - 39% = 240 
    40 - 59% = 271 
    60 - 79% = 7107 
    80 - 99% = 293 
 
    Index PDISTR_AGENT_ID (2) 
    Root page: 1509308, depth: 2, leaf buckets: 884, nodes: 793297 
    Average node length: 4.87, total dup: 793248, max dup: 145711 
    Average key length: 2.01, compression ratio: 4.48 
    Average prefix length: 8.99, average data length: 0.01 
    Clustering factor: 88125, ratio: 0.11 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 158 
        40 - 59% = 464 
        60 - 79% = 201 
        80 - 99% = 59 
 
    Index PDISTR_SNDOP_RCVOP_SNDID_ASC (0) 
    Root page: 1508613, depth: 3, leaf buckets: 930, nodes: 793297 
    Average node length: 5.87, total dup: 706498, max dup: 43 
    Average key length: 3.02, compression ratio: 7.29 
    Average prefix length: 21.09, average data length: 0.91 
    Clustering factor: 157845, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 115 
        40 - 59% = 392 
        60 - 79% = 130 
        80 - 99% = 291 
 
    Index PDISTR_SNDOP_RCVOP_SNDID_DESC (1) 
    Root page: 1509187, depth: 3, leaf buckets: 978, nodes: 793297 
    Average node length: 5.88, total dup: 706498, max dup: 43 
    Average key length: 3.02, compression ratio: 7.29 
    Average prefix length: 21.09, average data length: 0.91 
    Clustering factor: 159806, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 208 
        40 - 59% = 364 
        60 - 79% = 117 
        80 - 99% = 289 
 
    Index PDISTR_WORKER_SND_ID (3) 
    Root page: 1510178, depth: 3, leaf buckets: 1119, nodes: 793297 
    Average node length: 5.96, total dup: 706498, max dup: 43 
    Average key length: 3.10, compression ratio: 5.49 
    Average prefix length: 16.01, average data length: 0.99 
    Clustering factor: 152450, ratio: 0.19 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 233 
        40 - 59% = 596 
        60 - 79% = 193 
        80 - 99% = 96 
 
PERF_AGG (158) 
    Primary pointer page: 512, Index root page: 513 
    Total formats: 1, used formats: 1 
    Average record length: 62.80, total records: 5408 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 3.00, total fragments: 47, max fragments: 1 
    Average unpacked length: 379.00, compression ratio: 6.04 
    Pointer pages: 1, data page slots: 88 
    Data pages: 88, average fill: 61% 
    Primary pages: 74, secondary pages: 14, swept pages: 52 
    Empty pages: 9, full pages: 66 
    Fill distribution: 
     0 - 19% = 18 
    20 - 39% = 0 
    40 - 59% = 2 
    60 - 79% = 68 
    80 - 99% = 0 
 
    Index PERF_AGG_UNQ (1) 
    Root page: 1504238, depth: 2, leaf buckets: 5, nodes: 5408 
    Average node length: 5.50, total dup: 0, max dup: 0 
    Average key length: 3.58, compression ratio: 10.01 
    Average prefix length: 34.33, average data length: 1.55 
    Clustering factor: 5002, ratio: 0.92 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 0 
        40 - 59% = 2 
        60 - 79% = 1 
        80 - 99% = 2 
 
    Index PK_PERF_AGG (0) 
    Root page: 1504233, depth: 2, leaf buckets: 10, nodes: 5408 
    Average node length: 11.12, 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: 136, 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.14, total records: 79697 
    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: 776 
    Data pages: 776, average fill: 71% 
    Primary pages: 776, secondary pages: 0, swept pages: 0 
    Empty pages: 7, full pages: 768 
    Fill distribution: 
     0 - 19% = 7 
    20 - 39% = 1 
    40 - 59% = 0 
    60 - 79% = 768 
    80 - 99% = 0 
 
    Index PK_PERF_ESTIMATED (0) 
    Root page: 32302, depth: 2, leaf buckets: 102, nodes: 79697 
    Average node length: 10.16, total dup: 0, max dup: 0 
    Average key length: 8.17, compression ratio: 1.10 
    Average prefix length: 3.83, average data length: 5.17 
    Clustering factor: 3029, ratio: 0.04 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 1 
        60 - 79% = 0 
        80 - 99% = 100 
 
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.22, 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.20 
    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: 128.88, total records: 204769 
    Average version length: 153.67, total versions: 30117, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 13.16 
    Pointer pages: 8, data page slots: 5536 
    Data pages: 4968, average fill: 86% 
    Primary pages: 4968, secondary pages: 0, swept pages: 2 
    Empty pages: 93, full pages: 4853 
    Fill distribution: 
     0 - 19% = 96 
    20 - 39% = 9 
    40 - 59% = 7 
    60 - 79% = 4 
    80 - 99% = 4852 
 
PERF_SPLIT_1 (282) 
    Primary pointer page: 576, Index root page: 577 
    Total formats: 1, used formats: 1 
    Average record length: 134.47, total records: 186953 
    Average version length: 153.55, total versions: 20631, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 12.61 
    Pointer pages: 7, data page slots: 5664 
    Data pages: 4544, average fill: 86% 
    Primary pages: 4544, secondary pages: 0, swept pages: 2 
    Empty pages: 94, full pages: 4432 
    Fill distribution: 
     0 - 19% = 97 
    20 - 39% = 5 
    40 - 59% = 7 
    60 - 79% = 4 
    80 - 99% = 4431 
 
PERF_SPLIT_2 (283) 
    Primary pointer page: 578, Index root page: 579 
    Total formats: 1, used formats: 1 
    Average record length: 139.53, total records: 183806 
    Average version length: 152.21, total versions: 13851, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 12.16 
    Pointer pages: 5, data page slots: 5240 
    Data pages: 4480, average fill: 85% 
    Primary pages: 4480, secondary pages: 0, swept pages: 3 
    Empty pages: 109, full pages: 4339 
    Fill distribution: 
     0 - 19% = 110 
    20 - 39% = 11 
    40 - 59% = 12 
    60 - 79% = 9 
    80 - 99% = 4338 
 
PERF_SPLIT_3 (284) 
    Primary pointer page: 580, Index root page: 581 
    Total formats: 1, used formats: 1 
    Average record length: 146.84, total records: 187324 
    Average version length: 149.67, total versions: 5435, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.55 
    Pointer pages: 8, data page slots: 5168 
    Data pages: 4496, average fill: 86% 
    Primary pages: 4496, secondary pages: 0, swept pages: 3 
    Empty pages: 44, full pages: 4433 
    Fill distribution: 
     0 - 19% = 47 
    20 - 39% = 5 
    40 - 59% = 2 
    60 - 79% = 10 
    80 - 99% = 4432 
 
PERF_SPLIT_4 (285) 
    Primary pointer page: 582, Index root page: 583 
    Total formats: 1, used formats: 1 
    Average record length: 136.89, total records: 169773 
    Average version length: 152.80, total versions: 15815, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 12.39 
    Pointer pages: 6, data page slots: 6288 
    Data pages: 4168, average fill: 85% 
    Primary pages: 4168, secondary pages: 0, swept pages: 3 
    Empty pages: 125, full pages: 4009 
    Fill distribution: 
     0 - 19% = 128 
    20 - 39% = 12 
    40 - 59% = 9 
    60 - 79% = 9 
    80 - 99% = 4010 
 
PERF_SPLIT_5 (286) 
    Primary pointer page: 584, Index root page: 585 
    Total formats: 1, used formats: 1 
    Average record length: 138.93, total records: 180543 
    Average version length: 152.29, total versions: 14304, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 12.21 
    Pointer pages: 6, data page slots: 5952 
    Data pages: 4360, average fill: 86% 
    Primary pages: 4360, secondary pages: 0, swept pages: 5 
    Empty pages: 74, full pages: 4266 
    Fill distribution: 
     0 - 19% = 75 
    20 - 39% = 5 
    40 - 59% = 5 
    60 - 79% = 11 
    80 - 99% = 4264 
 
PERF_SPLIT_6 (287) 
    Primary pointer page: 586, Index root page: 587 
    Total formats: 1, used formats: 1 
    Average record length: 139.93, total records: 185089 
    Average version length: 152.02, total versions: 13407, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 12.12 
    Pointer pages: 6, data page slots: 6888 
    Data pages: 4472, average fill: 86% 
    Primary pages: 4471, secondary pages: 1, swept pages: 1 
    Empty pages: 74, full pages: 4371 
    Fill distribution: 
     0 - 19% = 79 
    20 - 39% = 8 
    40 - 59% = 7 
    60 - 79% = 6 
    80 - 99% = 4372 
 
PERF_SPLIT_7 (288) 
    Primary pointer page: 588, Index root page: 589 
    Total formats: 1, used formats: 1 
    Average record length: 141.52, total records: 202163 
    Average version length: 152.02, total versions: 13051, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.98 
    Pointer pages: 8, data page slots: 6624 
    Data pages: 4888, average fill: 86% 
    Primary pages: 4888, secondary pages: 0, swept pages: 2 
    Empty pages: 73, full pages: 4782 
    Fill distribution: 
     0 - 19% = 76 
    20 - 39% = 11 
    40 - 59% = 8 
    60 - 79% = 13 
    80 - 99% = 4780 
 
PERF_SPLIT_8 (289) 
    Primary pointer page: 590, Index root page: 591 
    Total formats: 1, used formats: 1 
    Average record length: 141.09, total records: 183402 
    Average version length: 152.78, total versions: 12059, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 12.02 
    Pointer pages: 6, data page slots: 6720 
    Data pages: 4440, average fill: 86% 
    Primary pages: 4440, secondary pages: 0, swept pages: 1 
    Empty pages: 79, full pages: 4338 
    Fill distribution: 
     0 - 19% = 81 
    20 - 39% = 8 
    40 - 59% = 7 
    60 - 79% = 7 
    80 - 99% = 4337 
 
PERF_SPLIT_9 (290) 
    Primary pointer page: 593, Index root page: 594 
    Total formats: 1, used formats: 1 
    Average record length: 138.48, total records: 196615 
    Average version length: 153.16, total versions: 16436, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 12.25 
    Pointer pages: 6, data page slots: 7072 
    Data pages: 4744, average fill: 86% 
    Primary pages: 4744, secondary pages: 0, swept pages: 2 
    Empty pages: 64, full pages: 4653 
    Fill distribution: 
     0 - 19% = 66 
    20 - 39% = 9 
    40 - 59% = 7 
    60 - 79% = 9 
    80 - 99% = 4653 
 
PHRASES (143) 
    Primary pointer page: 482, Index root page: 483 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index PHRASES_ID_DESC (3) 
    Root page: 1510354, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PHRASES_NAME (2) 
    Root page: 1510353, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PHRASES_UNQ (1) 
    Root page: 1510352, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PK_PHRASES (0) 
    Root page: 1510351, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
PSTORNED (147) 
    Primary pointer page: 490, Index root page: 491 
    Total formats: 1, used formats: 1 
    Average record length: 51.48, total records: 2131404 
    Average version length: 52.95, total versions: 51298, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 70.00, compression ratio: 1.36 
    Pointer pages: 16, data page slots: 25568 
    Data pages: 25568, average fill: 72% 
    Primary pages: 25568, secondary pages: 0, swept pages: 9726 
    Empty pages: 210, full pages: 21692 
    Fill distribution: 
     0 - 19% = 430 
    20 - 39% = 348 
    40 - 59% = 917 
    60 - 79% = 23399 
    80 - 99% = 474 
 
    Index PSTORNED_RCV_ID (1) 
    Root page: 1506186, depth: 3, leaf buckets: 2615, nodes: 2131404 
    Average node length: 5.44, total dup: 1989508, max dup: 1656 
    Average key length: 2.48, compression ratio: 3.62 
    Average prefix length: 8.58, average data length: 0.42 
    Clustering factor: 183801, ratio: 0.09 
    Fill distribution: 
         0 - 19% = 4 
        20 - 39% = 260 
        40 - 59% = 1755 
        60 - 79% = 305 
        80 - 99% = 291 
 
    Index PSTORNED_SND_ID (0) 
    Root page: 1504819, depth: 3, leaf buckets: 2765, nodes: 2131404 
    Average node length: 5.69, total dup: 1913777, max dup: 69 
    Average key length: 2.74, compression ratio: 3.29 
    Average prefix length: 8.37, average data length: 0.63 
    Clustering factor: 380337, ratio: 0.18 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 3 
        40 - 59% = 2365 
        60 - 79% = 366 
        80 - 99% = 31 
 
    Index PSTORNED_WORKER_ID (2) 
    Root page: 1507996, depth: 3, leaf buckets: 2161, nodes: 2131404 
    Average node length: 4.96, total dup: 2131304, max dup: 28778 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.41, average data length: 0.00 
    Clustering factor: 181484, ratio: 0.09 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 166 
        40 - 59% = 1204 
        60 - 79% = 374 
        80 - 99% = 416 
 
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: 37.66, total records: 158349 
    Average version length: 69.19, total versions: 72194, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 3.35 
    Pointer pages: 3, data page slots: 4200 
    Data pages: 3296, average fill: 56% 
    Primary pages: 3296, secondary pages: 0, swept pages: 529 
    Empty pages: 763, full pages: 2062 
    Fill distribution: 
     0 - 19% = 992 
    20 - 39% = 72 
    40 - 59% = 77 
    60 - 79% = 759 
    80 - 99% = 1396 
 
    Index XQD_1000_1200_WA_SO_RO_WKR_SND (0) 
    Root page: 318393, depth: 3, leaf buckets: 225, nodes: 158349 
    Average node length: 6.44, total dup: 137826, max dup: 14 
    Average key length: 3.92, compression ratio: 10.71 
    Average prefix length: 40.21, average data length: 1.79 
    Clustering factor: 26564, ratio: 0.17 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 25 
        40 - 59% = 113 
        60 - 79% = 69 
        80 - 99% = 18 
 
XQD_1000_3300 (178) 
    Primary pointer page: 553, Index root page: 554 
    Total formats: 1, used formats: 1 
    Average record length: 64.73, total records: 7052965 
    Average version length: 68.78, total versions: 432066, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.95 
    Pointer pages: 62, data page slots: 100656 
    Data pages: 100656, average fill: 75% 
    Primary pages: 100656, secondary pages: 0, swept pages: 21508 
    Empty pages: 0, full pages: 82317 
    Fill distribution: 
     0 - 19% = 40 
    20 - 39% = 619 
    40 - 59% = 5397 
    60 - 79% = 86827 
    80 - 99% = 7773 
 
    Index XQD_1000_3300_WA_SO_RO_WKR_SND (0) 
    Root page: 1480454, depth: 3, leaf buckets: 10684, nodes: 7052965 
    Average node length: 6.51, total dup: 6101476, max dup: 29 
    Average key length: 3.52, compression ratio: 11.93 
    Average prefix length: 40.61, average data length: 1.39 
    Clustering factor: 1584378, ratio: 0.22 
    Fill distribution: 
         0 - 19% = 4 
        20 - 39% = 1554 
        40 - 59% = 6013 
        60 - 79% = 2714 
        80 - 99% = 399 
 
    Index XQD_1000_3300_WKR_DOC_ASC (1) 
    Root page: 1486068, depth: 3, leaf buckets: 8341, nodes: 7052965 
    Average node length: 5.40, total dup: 6771531, max dup: 173 
    Average key length: 2.41, compression ratio: 7.06 
    Average prefix length: 16.63, average data length: 0.37 
    Clustering factor: 1379649, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 3 
        20 - 39% = 959 
        40 - 59% = 4615 
        60 - 79% = 1773 
        80 - 99% = 991 
 
    Index XQD_1000_3300_WKR_DOC_DEC (2) 
    Root page: 1490608, depth: 3, leaf buckets: 8460, nodes: 7052965 
    Average node length: 5.40, total dup: 6771531, max dup: 173 
    Average key length: 2.41, compression ratio: 7.06 
    Average prefix length: 16.63, average data length: 0.37 
    Clustering factor: 1382155, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 9 
        20 - 39% = 1075 
        40 - 59% = 4673 
        60 - 79% = 1703 
        80 - 99% = 1000 
 
XQD_1200_2000 (177) 
    Primary pointer page: 551, Index root page: 552 
    Total formats: 1, used formats: 1 
    Average record length: 66.67, total records: 12051739 
    Average version length: 68.74, total versions: 399245, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.89 
    Pointer pages: 103, data page slots: 167952 
    Data pages: 167952, average fill: 76% 
    Primary pages: 167952, secondary pages: 0, swept pages: 69025 
    Empty pages: 3, full pages: 154668 
    Fill distribution: 
     0 - 19% = 38 
    20 - 39% = 546 
    40 - 59% = 3865 
    60 - 79% = 155810 
    80 - 99% = 7693 
 
    Index XQD_1200_2000_WA_SO_RO_WKR_SND (0) 
    Root page: 1495028, depth: 3, leaf buckets: 18384, nodes: 12051739 
    Average node length: 6.57, total dup: 10509375, max dup: 67 
    Average key length: 3.42, compression ratio: 12.27 
    Average prefix length: 40.70, average data length: 1.30 
    Clustering factor: 2382206, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 29 
        20 - 39% = 2276 
        40 - 59% = 10975 
        60 - 79% = 4333 
        80 - 99% = 771 
 
XQD_2000_3300 (179) 
    Primary pointer page: 555, Index root page: 556 
    Total formats: 1, used formats: 1 
    Average record length: 41.46, total records: 1694394 
    Average version length: 69.10, total versions: 678823, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 3.04 
    Pointer pages: 27, data page slots: 43472 
    Data pages: 27728, average fill: 70% 
    Primary pages: 27727, secondary pages: 1, swept pages: 4850 
    Empty pages: 2113, full pages: 21468 
    Fill distribution: 
     0 - 19% = 3419 
    20 - 39% = 1173 
    40 - 59% = 869 
    60 - 79% = 11036 
    80 - 99% = 11231 
 
    Index XQD_2000_3300_WA_SO_RO_WKR_SND (0) 
    Root page: 1479712, depth: 3, leaf buckets: 2069, nodes: 1694394 
    Average node length: 5.51, total dup: 1625763, max dup: 99 
    Average key length: 2.56, compression ratio: 16.43 
    Average prefix length: 41.48, average data length: 0.52 
    Clustering factor: 112465, ratio: 0.07 
    Fill distribution: 
         0 - 19% = 12 
        20 - 39% = 286 
        40 - 59% = 971 
        60 - 79% = 597 
        80 - 99% = 203 
 
XQD_2100_3300 (180) 
    Primary pointer page: 557, Index root page: 558 
    Total formats: 1, used formats: 1 
    Average record length: 38.73, total records: 1131840 
    Average version length: 69.14, total versions: 496632, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 3.25 
    Pointer pages: 23, data page slots: 36704 
    Data pages: 28784, average fill: 46% 
    Primary pages: 28783, secondary pages: 1, swept pages: 7501 
    Empty pages: 7356, full pages: 12998 
    Fill distribution: 
     0 - 19% = 11193 
    20 - 39% = 2064 
    40 - 59% = 1279 
    60 - 79% = 5406 
    80 - 99% = 8842 
 
    Index XQD_2100_3300_WA_SO_RO_WKR_SND (0) 
    Root page: 1479207, depth: 3, leaf buckets: 1509, nodes: 1131840 
    Average node length: 5.83, total dup: 1053224, max dup: 99 
    Average key length: 2.90, compression ratio: 14.50 
    Average prefix length: 41.17, average data length: 0.83 
    Clustering factor: 153372, ratio: 0.14 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 271 
        40 - 59% = 726 
        60 - 79% = 398 
        80 - 99% = 112 
 
XQD_3300_3400 (181) 
    Primary pointer page: 559, Index root page: 560 
    Total formats: 1, used formats: 1 
    Average record length: 65.21, total records: 9337881 
    Average version length: 68.99, total versions: 498965, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.93 
    Pointer pages: 88, data page slots: 143248 
    Data pages: 143208, average fill: 70% 
    Primary pages: 143208, secondary pages: 0, swept pages: 48361 
    Empty pages: 411, full pages: 86705 
    Fill distribution: 
     0 - 19% = 1109 
    20 - 39% = 5204 
    40 - 59% = 20934 
    60 - 79% = 106910 
    80 - 99% = 9051 
 
    Index XQD_3300_3400_WA_SO_RO_WKR_SND (0) 
    Root page: 1472590, depth: 3, leaf buckets: 13513, nodes: 9337881 
    Average node length: 6.68, total dup: 7744301, max dup: 25 
    Average key length: 3.67, compression ratio: 11.45 
    Average prefix length: 40.50, average data length: 1.50 
    Clustering factor: 2011838, ratio: 0.22 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 1004 
        40 - 59% = 6934 
        60 - 79% = 4871 
        80 - 99% = 703 
 
XQS_1000_1200 (182) 
    Primary pointer page: 561, Index root page: 562 
    Total formats: 1, used formats: 1 
    Average record length: 82.48, total records: 21156769 
    Average version length: 82.95, total versions: 15915, 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: 318800 
    Data pages: 318800, average fill: 81% 
    Primary pages: 318800, secondary pages: 0, swept pages: 11731 
    Empty pages: 29, full pages: 318292 
    Fill distribution: 
     0 - 19% = 40 
    20 - 39% = 23 
    40 - 59% = 55 
    60 - 79% = 27040 
    80 - 99% = 291642 
 
    Index XQS_1000_1200_DOC_ID (1) 
    Root page: 1426716, depth: 3, leaf buckets: 19560, nodes: 21156769 
    Average node length: 5.72, total dup: 20675506, max dup: 134 
    Average key length: 2.16, compression ratio: 4.16 
    Average prefix length: 8.86, average data length: 0.14 
    Clustering factor: 3282220, ratio: 0.16 
    Fill distribution: 
         0 - 19% = 4 
        20 - 39% = 1 
        40 - 59% = 8512 
        60 - 79% = 534 
        80 - 99% = 10509 
 
    Index XQS_1000_1200_RCV_ID (3) 
    Root page: 1456980, depth: 3, leaf buckets: 17192, nodes: 21156769 
    Average node length: 6.31, total dup: 18593183, max dup: 49 
    Average key length: 2.75, compression ratio: 3.27 
    Average prefix length: 8.37, average data length: 0.63 
    Clustering factor: 914605, ratio: 0.04 
    Fill distribution: 
         0 - 19% = 6 
        20 - 39% = 3 
        40 - 59% = 800 
        60 - 79% = 273 
        80 - 99% = 16110 
 
    Index XQS_1000_1200_SND_ID (2) 
    Root page: 1441073, depth: 3, leaf buckets: 21379, nodes: 21156769 
    Average node length: 6.35, total dup: 18511512, max dup: 29 
    Average key length: 2.79, compression ratio: 3.23 
    Average prefix length: 8.34, average data length: 0.66 
    Clustering factor: 3576424, ratio: 0.17 
    Fill distribution: 
         0 - 19% = 9 
        20 - 39% = 0 
        40 - 59% = 8839 
        60 - 79% = 593 
        80 - 99% = 11938 
 
    Index XQS_1000_1200_WORKER_ID (0) 
    Root page: 1413348, depth: 3, leaf buckets: 16031, nodes: 21156769 
    Average node length: 5.56, total dup: 21156669, max dup: 230518 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.42, average data length: 0.00 
    Clustering factor: 943309, ratio: 0.04 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 9 
        40 - 59% = 2736 
        60 - 79% = 396 
        80 - 99% = 12889 
 
XQS_1000_3300 (184) 
    Primary pointer page: 565, Index root page: 566 
    Total formats: 1, used formats: 1 
    Average record length: 78.36, total records: 9780294 
    Average version length: 82.63, total versions: 481824, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.61 
    Pointer pages: 103, data page slots: 167872 
    Data pages: 167848, average fill: 72% 
    Primary pages: 167848, secondary pages: 0, swept pages: 66697 
    Empty pages: 447, full pages: 106786 
    Fill distribution: 
     0 - 19% = 1341 
    20 - 39% = 5613 
    40 - 59% = 21137 
    60 - 79% = 72179 
    80 - 99% = 67578 
 
    Index XQS_1000_3300_DOC_ID (1) 
    Root page: 1367502, depth: 3, leaf buckets: 11353, nodes: 9780294 
    Average node length: 5.35, total dup: 9471517, max dup: 190 
    Average key length: 2.23, compression ratio: 4.03 
    Average prefix length: 8.80, average data length: 0.20 
    Clustering factor: 2163604, ratio: 0.22 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 44 
        40 - 59% = 8135 
        60 - 79% = 3066 
        80 - 99% = 106 
 
    Index XQS_1000_3300_RCV_ID (3) 
    Root page: 1379261, depth: 3, leaf buckets: 13560, nodes: 9780294 
    Average node length: 6.22, total dup: 8107238, max dup: 14 
    Average key length: 3.10, compression ratio: 2.90 
    Average prefix length: 8.07, average data length: 0.93 
    Clustering factor: 1503007, ratio: 0.15 
    Fill distribution: 
         0 - 19% = 156 
        20 - 39% = 3907 
        40 - 59% = 4425 
        60 - 79% = 2483 
        80 - 99% = 2589 
 
    Index XQS_1000_3300_SND_ID (2) 
    Root page: 1373059, depth: 3, leaf buckets: 12671, nodes: 9780294 
    Average node length: 5.96, total dup: 8489552, max dup: 44 
    Average key length: 2.85, compression ratio: 3.16 
    Average prefix length: 8.28, average data length: 0.72 
    Clustering factor: 2361977, ratio: 0.24 
    Fill distribution: 
         0 - 19% = 4 
        20 - 39% = 49 
        40 - 59% = 9102 
        60 - 79% = 3388 
        80 - 99% = 128 
 
    Index XQS_1000_3300_WORKER_ID (0) 
    Root page: 1362767, depth: 3, leaf buckets: 10199, nodes: 9780294 
    Average node length: 5.12, total dup: 9780194, max dup: 147875 
    Average key length: 2.00, compression ratio: 1.20 
    Average prefix length: 2.41, average data length: 0.00 
    Clustering factor: 1527342, ratio: 0.16 
    Fill distribution: 
         0 - 19% = 49 
        20 - 39% = 1210 
        40 - 59% = 5064 
        60 - 79% = 1799 
        80 - 99% = 2077 
 
XQS_1200_2000 (183) 
    Primary pointer page: 563, Index root page: 564 
    Total formats: 1, used formats: 1 
    Average record length: 79.79, total records: 11412500 
    Average version length: 82.56, total versions: 347784, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.58 
    Pointer pages: 117, data page slots: 190928 
    Data pages: 189256, average fill: 74% 
    Primary pages: 189256, secondary pages: 0, swept pages: 65344 
    Empty pages: 2783, full pages: 148027 
    Fill distribution: 
     0 - 19% = 4441 
    20 - 39% = 6204 
    40 - 59% = 15245 
    60 - 79% = 41136 
    80 - 99% = 122230 
 
    Index XQS_1200_2000_DOC_ID (1) 
    Root page: 1392101, depth: 3, leaf buckets: 13115, nodes: 11412500 
    Average node length: 5.29, total dup: 11302669, max dup: 636 
    Average key length: 2.08, compression ratio: 4.33 
    Average prefix length: 8.93, average data length: 0.07 
    Clustering factor: 2374178, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 81 
        40 - 59% = 9080 
        60 - 79% = 3790 
        80 - 99% = 164 
 
    Index XQS_1200_2000_RCV_ID (3) 
    Root page: 1406110, depth: 3, leaf buckets: 10514, nodes: 11412500 
    Average node length: 5.49, total dup: 10915291, max dup: 49 
    Average key length: 2.28, compression ratio: 3.95 
    Average prefix length: 8.77, average data length: 0.23 
    Clustering factor: 709974, ratio: 0.06 
    Fill distribution: 
         0 - 19% = 160 
        20 - 39% = 892 
        40 - 59% = 2538 
        60 - 79% = 1802 
        80 - 99% = 5122 
 
    Index XQS_1200_2000_SND_ID (2) 
    Root page: 1398638, depth: 3, leaf buckets: 14998, nodes: 11412500 
    Average node length: 6.01, total dup: 9962317, max dup: 64 
    Average key length: 2.80, compression ratio: 3.21 
    Average prefix length: 8.32, average data length: 0.68 
    Clustering factor: 2390731, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 95 
        40 - 59% = 10619 
        60 - 79% = 4087 
        80 - 99% = 197 
 
    Index XQS_1200_2000_WORKER_ID (0) 
    Root page: 1386211, depth: 3, leaf buckets: 10838, nodes: 11412500 
    Average node length: 5.21, total dup: 11412400, max dup: 190442 
    Average key length: 2.00, compression ratio: 1.20 
    Average prefix length: 2.40, average data length: 0.00 
    Clustering factor: 698201, ratio: 0.06 
    Fill distribution: 
         0 - 19% = 93 
        20 - 39% = 829 
        40 - 59% = 4843 
        60 - 79% = 1457 
        80 - 99% = 3616 
 
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: 78.53, total records: 9917835 
    Average version length: 82.93, total versions: 503898, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.60 
    Pointer pages: 105, data page slots: 170064 
    Data pages: 170008, average fill: 72% 
    Primary pages: 170008, secondary pages: 0, swept pages: 65002 
    Empty pages: 573, full pages: 110024 
    Fill distribution: 
     0 - 19% = 1521 
    20 - 39% = 5132 
    40 - 59% = 20230 
    60 - 79% = 73706 
    80 - 99% = 69419 
 
    Index XQS_2100_3300_DOC_ID (1) 
    Root page: 1344686, depth: 3, leaf buckets: 11920, nodes: 9917835 
    Average node length: 5.17, total dup: 9888490, max dup: 1662 
    Average key length: 2.03, compression ratio: 4.43 
    Average prefix length: 8.97, average data length: 0.03 
    Clustering factor: 1990138, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 25 
        20 - 39% = 1450 
        40 - 59% = 7963 
        60 - 79% = 1870 
        80 - 99% = 612 
 
    Index XQS_2100_3300_RCV_ID (3) 
    Root page: 1355717, depth: 3, leaf buckets: 13655, nodes: 9917835 
    Average node length: 6.24, total dup: 8220097, max dup: 14 
    Average key length: 3.10, compression ratio: 2.90 
    Average prefix length: 8.07, average data length: 0.93 
    Clustering factor: 1489898, ratio: 0.15 
    Fill distribution: 
         0 - 19% = 172 
        20 - 39% = 3870 
        40 - 59% = 4363 
        60 - 79% = 2465 
        80 - 99% = 2785 
 
    Index XQS_2100_3300_SND_ID (2) 
    Root page: 1350049, depth: 3, leaf buckets: 12545, nodes: 9917835 
    Average node length: 5.42, total dup: 9474446, max dup: 97 
    Average key length: 2.29, compression ratio: 3.94 
    Average prefix length: 8.76, average data length: 0.24 
    Clustering factor: 2125902, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 14 
        20 - 39% = 1340 
        40 - 59% = 8917 
        60 - 79% = 1698 
        80 - 99% = 576 
 
    Index XQS_2100_3300_WORKER_ID (0) 
    Root page: 985805, depth: 3, leaf buckets: 10367, nodes: 9917835 
    Average node length: 5.14, total dup: 9917735, max dup: 150661 
    Average key length: 2.00, compression ratio: 1.20 
    Average prefix length: 2.41, average data length: 0.00 
    Clustering factor: 1563257, ratio: 0.16 
    Fill distribution: 
         0 - 19% = 25 
        20 - 39% = 1257 
        40 - 59% = 5149 
        60 - 79% = 1824 
        80 - 99% = 2112 
 
XQS_3300_3400 (187) 
    Primary pointer page: 571, Index root page: 572 
    Total formats: 1, used formats: 1 
    Average record length: 67.40, total records: 581685 
    Average version length: 68.80, total versions: 6664, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.87 
    Pointer pages: 5, data page slots: 8016 
    Data pages: 8016, average fill: 76% 
    Primary pages: 8016, secondary pages: 0, swept pages: 3690 
    Empty pages: 1, full pages: 7031 
    Fill distribution: 
     0 - 19% = 2 
    20 - 39% = 9 
    40 - 59% = 150 
    60 - 79% = 7729 
    80 - 99% = 126 
 
    Index XQS_3300_3400_DOC_ID (1) 
    Root page: 38893, depth: 3, leaf buckets: 745, nodes: 581685 
    Average node length: 5.95, total dup: 495313, max dup: 83 
    Average key length: 3.09, compression ratio: 2.91 
    Average prefix length: 8.06, average data length: 0.94 
    Clustering factor: 101205, ratio: 0.17 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 22 
        40 - 59% = 531 
        60 - 79% = 107 
        80 - 99% = 85 
 
    Index XQS_3300_3400_SND_ID (2) 
    Root page: 28954, depth: 3, leaf buckets: 767, nodes: 581685 
    Average node length: 6.15, total dup: 477142, max dup: 29 
    Average key length: 3.29, compression ratio: 2.73 
    Average prefix length: 7.89, average data length: 1.11 
    Clustering factor: 101259, ratio: 0.17 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 17 
        40 - 59% = 552 
        60 - 79% = 106 
        80 - 99% = 92 
 
    Index XQS_3300_3400_WORKER_ID (0) 
    Root page: 375548, depth: 2, leaf buckets: 572, nodes: 581685 
    Average node length: 4.86, total dup: 581585, max dup: 9639 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.42, average data length: 0.00 
    Clustering factor: 89776, ratio: 0.15 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 26 
        40 - 59% = 341 
        60 - 79% = 76 
        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 Thu Mar  7 16:11:41 2024

Record versions statistics, table

TABLE_NAME TOTAL_RECS TOTAL_VERS MAX_VERSIONS VERS_TO_RECS_PRC MAXV_TO_VERS_PRC
DOC_DATA 7787961 96918 1 0.0000 0.0000
DOC_LIST 2264599 94926 3 0.0000 0.0000
FB_ERRORS 2182 757 1 0.0000 0.0000
INVNT_SALDO 400 239132 623 59700.0000 0.0000
INVNT_TURNOVER_LOG 69379 63870 1 0.0000 0.0000
MONEY_SALDO 49 18023 959 36700.0000 0.0000
MONEY_TURNOVER_LOG 1035 953 1 0.0000 0.0000
PDISTR 793297 70599 5 0.0000 0.0000
PERF_SPLIT_0 204769 30117 1 0.0000 0.0000
PERF_SPLIT_1 186953 20631 1 0.0000 0.0000
PERF_SPLIT_2 183806 13851 1 0.0000 0.0000
PERF_SPLIT_3 187324 5435 1 0.0000 0.0000
PERF_SPLIT_4 169773 15815 1 0.0000 0.0000
PERF_SPLIT_5 180543 14304 1 0.0000 0.0000
PERF_SPLIT_6 185089 13407 1 0.0000 0.0000
PERF_SPLIT_7 202163 13051 1 0.0000 0.0000
PERF_SPLIT_8 183402 12059 1 0.0000 0.0000
PERF_SPLIT_9 196615 16436 1 0.0000 0.0000
PSTORNED 2131404 51298 1 0.0000 0.0000
SEMAPHORES 5 1 1 0.0000 100.0000
XQD_1000_1200 158349 72194 1 0.0000 0.0000
XQD_1000_3300 7052965 432066 1 0.0000 0.0000
XQD_1200_2000 12051739 399245 1 0.0000 0.0000
XQD_2000_3300 1694394 678823 1 0.0000 0.0000
XQD_2100_3300 1131840 496632 1 0.0000 0.0000
XQD_3300_3400 9337881 498965 1 0.0000 0.0000
XQS_1000_1200 21156769 15915 1 0.0000 0.0000
XQS_1000_3300 9780294 481824 1 0.0000 0.0000
XQS_1200_2000 11412500 347784 1 0.0000 0.0000
XQS_2100_3300 9917835 503898 1 0.0000 0.0000
XQS_3300_3400 581685 6664 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 ---
:50: 
:51: mscs-test-161.budzdorov.ru    Thu Mar  7 16:09:46 2024
:52:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:53: 
:54: 
:55: mscs-test-161.budzdorov.ru    Thu Mar  7 16:09:46 2024
:56:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:57: 
:58: 
:59: mscs-test-161.budzdorov.ru    Thu Mar  7 16:09:46 2024
:60:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:61: 
:62: 
:63: mscs-test-161.budzdorov.ru    Thu Mar  7 16:09:47 2024
:64:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:65: 
:66: 
:67: mscs-test-161.budzdorov.ru    Thu Mar  7 16:09:51 2024
:68:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:69: 
--- end of diff output ---

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

07.03.24 16:11:53. There are 3 logs in /var/tmp/logs-oltp30 that can be removed if no severe errors occured, see config setting 'remove_isql_logs'
Following values of gdscode are considered as SEVERE:
            0 Unidentified error in PSQL code: gdscode=0 within WHEN block when exception raised.
    335544321 'string truncation'. Attempt to assign too long text into string variable.
    335544347 'not_valid'. Validation error for column.
    335544349 'no_dup'. Attempt to store duplicate value visible to active transactions.
    335544558 'check_constraint'. Operation violates CHECK constraint on view or table.
    335544665 'unique_key_violation'. Violation of PRIMARY or UNIQUE KEY constraint.
    335544838 'foreign_key_target_doesnt_exist'. Foreign key reference target does not exist.
    335544839 'foreign_key_references_present'. Foreign key references are present for the record.
FINISHED_AT ERRORS_RESULT
2024-03-07 16:11:56 No severe PSQL-related problems occured
07.03.24 16:11:57. End of report.