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

Hardware and OS info

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

Server and database settinfs 


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

Test configuration settings 

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

Test finish info 


FINISH_STATE                    NORMAL: TEST_TIME EXPIRED AT 2024-03-18 13:08:13
DTS_END                         2024-03-18 13:07:49.6310
FB_GDSCODE                      -1
FB_MNEMONA                      
STACK                           SRV_FILL_MON_CACHE_MEMORY(20:5) ==> SP_CHECK_TO_STOP_WORK(32:12) ==> SP_HALT_ON_ERROR(68:17)
IP                              ::1/40394
TRN_ID                          173326
ATT_ID                          259
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: 9600.38 21193 960038
customer order: creation 176.61 386 17661
customer order: refuse 14.55 393 1455
order to supplier: creation 46.70 1392 4670
order to supplier: removal 3.54 99508 354
invoice (draft): creation 46.13 3133 4613
invoice (draft): removal 52.95 770 5295
invoice accept: apply 43.54 20411 4354
invoice accept: cancel 47.72 758 4772
customer reserve: creation 4214.03 194 421403
customer reserve: removal 4652.69 59 465269
realization accept: apply 85.59 231 8559
realization accept: cancel 86.38 133 8638
payment from customer: creation 60.31 120 6031
payment from customer: removal 5.54 90 554
payment to supplier: creation 50.30 153 5030
payment to supplier: removal 3.05 58 305
service: total inventory turnovers 3.73 4350 373
service: total monetary turnovers 6.08 631 608
service: aggregate perf. data 0.91 14702 91
service: refresh index statistics 0.03 276382 3

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:03, from 18-03-2024 13:09:39 to 18-03-2024 13:09:42.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 1323
TEST_TIME 2 1053
TEST_TIME 3 2351
TEST_TIME 4 2303
TEST_TIME 5 3247
TEST_TIME 6 4298
TEST_TIME 7 4323
TEST_TIME 8 4624
TEST_TIME 9 4698
TEST_TIME 10 5573
TEST_TIME 11 5662
TEST_TIME 12 6452
TEST_TIME 13 6871
TEST_TIME 14 6895
TEST_TIME 15 7057
TEST_TIME 16 7573
TEST_TIME 17 7766
TEST_TIME 18 8074
TEST_TIME 19 8134
TEST_TIME 20 8359
TEST_TIME 21 8546
TEST_TIME 22 8426
TEST_TIME 23 9162
TEST_TIME 24 9663
TEST_TIME 25 10438
TEST_TIME 26 10292
TEST_TIME 27 10100
TEST_TIME 28 10052
TEST_TIME 29 9735
TEST_TIME 30 10243
TEST_TIME 31 10087
TEST_TIME 32 9938
TEST_TIME 33 9769
TEST_TIME 34 9863
TEST_TIME 35 9901
TEST_TIME 36 9991
TEST_TIME 37 9935
TEST_TIME 38 10114
TEST_TIME 39 10076
TEST_TIME 40 10096
TEST_TIME 41 10079
TEST_TIME 42 10057
TEST_TIME 43 10155
TEST_TIME 44 10169
TEST_TIME 45 10124
TEST_TIME 46 9979
TEST_TIME 47 9882
TEST_TIME 48 9974
TEST_TIME 49 9843
TEST_TIME 50 9826
TEST_TIME 51 9753
TEST_TIME 52 9742
TEST_TIME 53 9716
TEST_TIME 54 9866
TEST_TIME 55 9843
TEST_TIME 56 9726
TEST_TIME 57 9578
TEST_TIME 58 9617
TEST_TIME 59 9732
TEST_TIME 60 9913
TEST_TIME 61 9910
TEST_TIME 62 10013
TEST_TIME 63 9991
TEST_TIME 64 10070
TEST_TIME 65 10060
TEST_TIME 66 10042
TEST_TIME 67 10084
TEST_TIME 68 10057
TEST_TIME 69 10111
TEST_TIME 70 10055
TEST_TIME 71 9983
TEST_TIME 72 9954
TEST_TIME 73 9916
TEST_TIME 74 9854
TEST_TIME 75 9788
TEST_TIME 76 9705
TEST_TIME 77 9804
TEST_TIME 78 9792
TEST_TIME 79 9756
TEST_TIME 80 9732
TEST_TIME 81 9829
TEST_TIME 82 9795
TEST_TIME 83 9858
TEST_TIME 84 9843
TEST_TIME 85 9943
TEST_TIME 86 9924
TEST_TIME 87 10001
TEST_TIME 88 9973
TEST_TIME 89 9939
TEST_TIME 90 9880
TEST_TIME 91 9874
TEST_TIME 92 9814
TEST_TIME 93 9804
TEST_TIME 94 9782
TEST_TIME 95 9801
TEST_TIME 96 9789
TEST_TIME 97 9754
TEST_TIME 98 9699
TEST_TIME 99 9638
TEST_TIME 100 9602

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:03, from 18-03-2024 13:09:43 to 18-03-2024 13:09:46.

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 1345336 1345336 0 0.00 0 22537 7 0 0
doc_list_biud 1345336 1345336 0 0.00 0 56509 26 0 0
sp_add_invoice_to_stock 4471 4354 117 2.61 30 206771 20411 0 117
sp_cancel_adding_invoice 4772 4772 0 0.00 4 54067 759 0 0
sp_cancel_client_order 1455 1455 0 0.00 3 15166 394 0 0
sp_cancel_customer_reserve 465269 465269 0 0.00 0 24517 59 0 0
sp_cancel_pay_from_customer 554 554 0 0.00 3 7349 90 0 0
sp_cancel_pay_to_supplier 305 305 0 0.00 2 898 58 0 0
sp_cancel_supplier_invoice 5303 5295 8 0.15 1 56521 771 0 8
sp_cancel_supplier_order 354 354 0 0.00 14 996284 99508 0 0
sp_cancel_write_off 8638 8638 0 0.00 1 14432 134 0 0
sp_client_order 17661 17661 0 0.00 3 23044 387 0 0
sp_customer_reserve 421403 421403 0 0.00 0 114144 194 0 0
sp_fill_shopping_cart 26940 26940 0 0.00 1 15556 39 0 0
sp_fill_shopping_cart_clo_res 421403 421403 0 0.00 0 19917 16 0 0
sp_get_clo_for_invoice 4353 4353 0 0.00 0 21906 340 0 0
sp_kill_cost_storno 14269 14269 0 0.00 0 14431 73 0 0
sp_kill_qstorno_ret_qs2qd 944825 944825 0 0.00 0 56505 32 0 0
sp_kill_qty_storno 498695 498695 0 0.00 0 56508 69 0 0
sp_lock_selected_doc 17651 17651 0 0.00 0 8786 5 0 0
sp_make_cost_storno 23973 23973 0 0.00 0 20744 72 0 0
sp_multiply_rows_for_pdistr 23973 23973 0 0.00 0 16344 40 0 0
sp_multiply_rows_for_qdistr 17661 17661 0 0.00 0 23037 178 0 0
sp_pay_from_customer 6031 6031 0 0.00 4 17314 120 0 0
sp_pay_to_supplier 5030 5030 0 0.00 4 19822 153 0 0
sp_payment_common 11061 11061 0 0.00 1 15502 25 0 0
sp_qd_handle_on_cancel_clo 1455 1455 0 0.00 0 15160 355 0 0
sp_qd_handle_on_invoice_upd_sts 9125 9125 0 0.00 0 22005 311 0 0
sp_qd_handle_on_reserve_upd_sts 8559 8559 0 0.00 0 17805 71 0 0
sp_reserve_write_off 8559 8559 0 0.00 6 20831 231 0 0
sp_supplier_invoice 4613 4613 0 0.00 6 71928 3134 0 0
sp_supplier_order 4670 4670 0 0.00 5 42387 1392 0 0
srv_aggregate_perf_data 91 91 0 0.00 1856 151246 14703 0 0
srv_fill_mon_cache_memory 55 55 0 0.00 1690 109615 38566 0 0
srv_find_qd_qs_mism 916057 916057 0 0.00 0 22537 6 0 0
srv_make_invnt_saldo 373 373 0 0.00 50 79088 4351 0 0
srv_make_money_saldo 608 608 0 0.00 1 13184 632 0 0
srv_recalc_idx_stat 3 3 0 0.00 157722 506773 276382 0 0
t$perf-abend:sp_add_invoice_to_stock 117 117 0 0.00 0 0 0 0 0
t$perf-abend:sp_cancel_supplier_invoice 8 8 0 0.00 0 0 0 0 0
t$perf-norm:sp_add_invoice_to_stock 4354 4354 0 0.00 0 11004 180 0 0
t$perf-norm:sp_cancel_adding_invoice 319 319 0 0.00 0 2837 100 0 0
t$perf-norm:sp_cancel_client_order 1455 1455 0 0.00 0 1142 13 0 0
t$perf-norm:sp_cancel_customer_reserve 571 571 0 0.00 0 1108 12 0 0
t$perf-norm:sp_cancel_pay_from_customer 554 554 0 0.00 0 5865 25 0 0
t$perf-norm:sp_cancel_pay_to_supplier 305 305 0 0.00 0 787 9 0 0
t$perf-norm:sp_cancel_supplier_invoice 331 331 0 0.00 0 1038 14 0 0
t$perf-norm:sp_cancel_supplier_order 354 354 0 0.00 0 25788 1781 0 0
t$perf-norm:sp_cancel_write_off 850 850 0 0.00 0 6000 16 0 0
t$perf-norm:sp_client_order 17661 17661 0 0.00 0 5527 18 0 0
t$perf-norm:sp_customer_reserve 868 868 0 0.00 0 3647 12 0 0
t$perf-norm:sp_pay_from_customer 6031 6031 0 0.00 0 8061 11 0 0
t$perf-norm:sp_pay_to_supplier 5030 5030 0 0.00 0 6464 10 0 0
t$perf-norm:sp_reserve_write_off 8559 8559 0 0.00 0 6730 11 0 0
t$perf-norm:sp_supplier_invoice 4613 4613 0 0.00 0 18241 18 0 0
t$perf-norm:sp_supplier_order 4670 4670 0 0.00 0 4292 14 0 0
t$perf-norm:srv_aggregate_perf_data 91 91 0 0.00 0 152 7 0 0
t$perf-norm:srv_fill_mon_cache_memory 55 55 0 0.00 0 492 11 0 0
t$perf-norm:srv_make_invnt_saldo 373 373 0 0.00 0 2106 17 0 0
t$perf-norm:srv_make_money_saldo 608 608 0 0.00 0 1998 9 0 0
t$perf-norm:srv_recalc_idx_stat 3 3 0 0.00 1 11 6 0 0
v_add_invoice_to_stock 8940 8706 234 2.61 0 5729 20 0 234
v_all_customers 32874 32874 0 0.00 0 83 1 0 0
v_all_suppliers 26454 26454 0 0.00 0 83 1 0 0
v_all_wares 35322 35322 0 0.00 0 81 1 0 0
v_cancel_adding_invoice 638 638 0 0.00 0 1090 9 0 0
v_cancel_client_order 2910 2910 0 0.00 0 6809 11 0 0
v_cancel_customer_prepayment 1108 1108 0 0.00 0 4528 9 0 0
v_cancel_customer_reserve 1142 1142 0 0.00 0 933 4 0 0
v_cancel_payment_to_supplier 610 610 0 0.00 0 287 4 0 0
v_cancel_supplier_invoice 678 662 16 2.35 0 6478 38 0 16
v_cancel_supplier_order 708 708 0 0.00 0 1279 5 0 0
v_cancel_write_off 1700 1700 0 0.00 0 5268 23 0 0
v_max_id_clo_ord 4668 4668 0 0.00 0 800 1 0 0
v_max_id_clo_res 868 868 0 0.00 0 3300 19 0 0
v_max_id_ord_sup 4611 4611 0 0.00 0 4649 5 0 0
v_max_non_paid_invoice 1082 1082 0 0.00 0 36 2 0 0
v_max_non_paid_realizn 2841 2841 0 0.00 0 702 3 0 0
v_min_id_clo_ord 4668 4668 0 0.00 0 1604 7 0 0
v_min_id_clo_res 868 868 0 0.00 0 3220 21 0 0
v_min_id_ord_sup 4611 4611 0 0.00 0 4119 5 0 0
v_min_non_paid_invoice 5030 5030 0 0.00 0 13409 21 0 0
v_min_non_paid_realizn 6031 6031 0 0.00 0 14534 19 0 0
v_our_firm 8828 8828 0 0.00 0 22 1 0 0
v_reserve_write_off 17118 17118 0 0.00 0 5458 8 0 0
x_lock_depdocs_on_canc_invoice 9736 9736 0 0.00 0 10304 116 0 0
x_lock_depdocs_on_canc_sup_ord 354 354 0 0.00 0 6015 334 0 0
x_make_qstorno_1000_1200 4670 4670 0 0.00 1 42380 1316 0 0
x_make_qstorno_1200_2000 4613 4613 0 0.00 2 71909 2988 0 0
x_make_qstorno_2100_3300 421403 421403 0 0.00 0 114137 175 0 0

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

Memory consumption, metadata cache, attachments activity 

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


Page cache type: shared, buffers: 1000000 for all connections, with total size: 8192000000
measurement_dts measurement duration ms page cache memo used memo used, total memo allocated, total metadata cache metadata cache percent of total total attachments cnt active attachments cnt running statements cnt stalled statements cnt memo used by attachments memo used by transactions memo used by statements
11:07:53 2 8192000000 8796662832 8807108608 3180608 0.038 1 1 2 0 3278224 61840 35776
11:08:54 31745 8192000000 9715276512 10012184576 780015536 8.693 100 94 188 0 810033584 7542544 22475504
11:10:30 26418 8192000000 9740153424 10044157952 817133664 9.070 100 90 180 0 850199744 11728592 21337488
11:12:09 13539 8192000000 9780675664 10096742400 844162112 9.342 100 82 164 0 886362720 23995808 18204800
11:13:50 7746 8192000000 9857651760 10190368768 902964672 9.928 100 79 158 0 959644528 40072912 16606944
11:15:01 13062 8192000000 9899296448 10250563584 931332448 10.208 100 67 132 0 1013477952 68623296 13522208
11:16:17 3168 8192000000 9930541424 10288173056 981417136 10.698 100 77 149 1 1054054608 57856656 14780816
11:17:23 3356 8192000000 9955244368 10321747968 1008369664 10.960 100 63 126 0 1067177968 46513968 12294336
11:18:31 1440 8192000000 9986539120 10358566912 1028503200 11.154 100 76 152 0 1097268416 53871040 14894176
11:19:34 1876 8192000000 10000380176 10376253440 1045663856 11.319 100 81 162 1 1112282736 49295920 17322960
11:20:37 8894 8192000000 9989221616 10387386368 1051735136 11.377 100 55 110 0 1110470960 47840208 10895616
11:21:50 3101 8192000000 9988951952 10380791808 1060208400 11.458 100 43 85 1 1106435792 37162896 9064496
11:22:54 7907 8192000000 9982077264 10381606912 1064530304 11.500 100 46 91 0 1095156640 21171728 9454608
11:24:03 64246 8192000000 9964256224 10372333568 1077204624 11.621 100 36 72 1 1100617760 14796944 8616192
11:26:08 6059 8192000000 9995989776 10400641024 1079074800 11.639 100 34 66 1 1105228048 18714672 7438576
11:27:17 8231 8192000000 9988174640 10394005504 1071568016 11.567 99 25 49 1 1101526864 24918656 5040192
11:28:33 15841 8192000000 10009793024 10409291776 1086144896 11.706 100 40 80 1 1112968704 18881904 7941904
11:30:18 37187 8192000000 10048075664 10458271744 1080338496 11.651 98 47 94 0 1165443248 75141488 9963264
11:31:58 37643 8192000000 10090342448 10505457664 1083637728 11.682 99 37 74 0 1199428608 108472256 7318624
11:33:42 20792 8192000000 10058779856 10456653824 1055782816 11.416 95 39 77 0 1140596288 76593840 8219632
11:35:06 39257 8192000000 10125667632 10539732992 1094368416 11.784 99 41 80 1 1233861488 130400560 9092512
11:36:52 17822 8192000000 10141823344 10546647040 1059877072 11.455 97 50 100 0 1227583408 156125936 11580400
11:38:12 18187 8192000000 10131575616 10516021248 1062401296 11.479 99 55 110 0 1222524208 149009456 11113456
11:39:37 5776 8192000000 10122498800 10503593984 1069403360 11.546 98 73 142 1 1213782992 129892096 14487536
11:40:50 1814 8192000000 10175809312 10561036288 1097585792 11.815 100 86 170 0 1276812880 161416752 17810336
11:42:01 10431 8192000000 10212548736 10601340928 1093328080 11.774 100 73 140 3 1314621040 206404944 14888016
11:43:20 2868 8192000000 10232330784 10640105472 1101661888 11.853 100 79 158 0 1332935792 214651104 16622800
11:44:25 1758 8192000000 10265873632 10652557312 1110442352 11.937 100 87 174 1 1370310256 241024880 18843024
11:45:31 1891 8192000000 10338048112 10755981312 1138066896 12.197 100 92 184 2 1434806384 276154704 20584784
11:46:40 1687 8192000000 10321157120 10717622272 1128575520 12.108 99 79 158 0 1414730800 268600944 17554336
11:47:47 9955 8192000000 10322499520 10761359360 1139064144 12.207 100 43 86 0 1442613936 292857840 10691952
11:49:03 4221 8192000000 10362209296 10776305664 1150882432 12.318 100 55 107 0 1456651136 293585792 12182912
11:50:11 8703 8192000000 10385487216 10849566720 1141985424 12.234 100 38 76 0 1496295152 344826912 9482816
11:51:21 21319 8192000000 10262085824 10749820928 1116776480 11.997 100 18 36 0 1375883168 254260720 4845968
11:53:24 4643 8192000000 10119800880 10533236736 1131499472 12.135 100 66 129 2 1213100704 68323728 13277504
11:54:31 6689 8192000000 10115052032 10537177088 1136525104 12.183 100 64 118 3 1207395872 58581376 12289392
11:55:38 74442 8192000000 10166750864 10635325440 1133599568 12.155 100 12 24 0 1272886912 136418416 2868928
11:58:13 93897 8192000000 10067033472 10527117312 1112163968 11.953 98 18 35 0 1150702368 35185232 3353168
12:00:53 61128 8192000000 10106839680 10544648192 1131091472 12.132 100 34 67 0 1210050272 71802048 7156752
12:03:08 44788 8192000000 10061605616 10496925696 1137564368 12.193 100 36 70 2 1183131152 38800480 6766304
12:04:56 44118 8192000000 10118406416 10622058496 1143566592 12.249 100 21 42 0 1235599056 87709120 4323344
12:06:45 49542 8192000000 10059602912 10502414336 1133068080 12.150 99 23 46 1 1166434928 28483168 4883680
12:08:39 27337 8192000000 10062457680 10495524864 1106279872 11.897 97 28 45 1 1127135104 17210432 3644800
12:10:07 69366 8192000000 10050262544 10496696320 1070055088 11.553 94 8 16 0 1128945888 57377136 1513664
12:12:45 94319 8192000000 10051225808 10497335296 1107190400 11.906 98 34 66 1 1157582320 43341168 7050752
12:15:25 18809 8192000000 10089502176 10522275840 1111278512 11.945 100 59 118 0 1187280496 64138336 11863648
12:16:48 59651 8192000000 10060367904 10493419520 1036490640 11.231 93 26 52 0 1071063584 29620976 4951968
12:18:48 8288 8192000000 10069742544 10488680448 1078467008 11.633 97 59 117 2 1146758096 55899808 12391280
12:20:00 10122 8192000000 10111364736 10529308672 1095858528 11.798 98 51 97 0 1196939504 90425872 10655104
12:21:12 55710 8192000000 10062937344 10532573184 1082201024 11.668 97 19 37 0 1185279936 99317136 3761776
12:23:25 54964 8192000000 10131030320 10565865472 1092037920 11.762 98 18 34 0 1194428992 99017792 3373280
12:25:46 67327 8192000000 10113941904 10554667008 1107059040 11.905 100 20 41 0 1218692512 107214592 4418880
12:27:59 34684 8192000000 10093069872 10535555072 1093519536 11.776 98 47 95 1 1171631248 67911552 10200160
12:29:36 53943 8192000000 10072794464 10509041664 1059344272 11.450 96 19 38 0 1128489088 65432400 3712416
12:32:04 20661 8192000000 10032296992 10467508224 1098234896 11.821 100 53 101 0 1141991888 32605392 11151600
12:33:28 24358 8192000000 10044477520 10452832256 1073397024 11.585 98 50 97 0 1116680112 33866304 9416784
12:34:55 52025 8192000000 10058496672 10484133888 1089054640 11.734 99 22 44 0 1133487504 40372784 4060080
12:37:02 57104 8192000000 10049521056 10516279296 1098956368 11.828 100 10 20 0 1171184384 70655392 1572624
12:39:03 49952 8192000000 10078289456 10527174656 1107161504 11.906 99 30 60 0 1179282368 66629296 5491568
12:40:53 45940 8192000000 10046866816 10515759104 1113452672 11.965 100 8 14 0 1165161136 50347840 1360624
12:42:41 71070 8192000000 10098695920 10547613696 1099800048 11.836 97 12 24 0 1167311408 65022752 2488608
12:45:21 65040 8192000000 10082907440 10516287488 1116213056 11.991 99 12 24 0 1137883152 18945392 2724704
12:47:29 68904 8192000000 10101824352 10626453504 1144081104 12.254 100 16 31 0 1244522128 97308864 3132160
12:49:55 27717 8192000000 10086682192 10562895872 1140234304 12.218 100 34 67 0 1213189552 66503104 6452144
12:51:27 14239 8192000000 10118792736 10543247360 1133441088 12.154 100 48 96 0 1199902224 57536336 8924800
12:52:46 109615 8192000000 10112496496 10659565568 1135337568 12.172 100 16 32 0 1198333760 60223888 2772304
12:56:42 95863 8192000000 10077324960 10513416192 1108327104 11.917 99 41 82 0 1192916096 76811760 7777232
12:59:30 26267 8192000000 10064574432 10498048000 1100827344 11.845 98 33 64 0 1152537056 45541216 6168496
13:00:57 45550 8192000000 10080372288 10548817920 1094376720 11.784 98 11 22 0 1165305376 68707696 2220960
13:02:50 63885 8192000000 10056173184 10522669056 1120651584 12.033 99 21 40 1 1158411696 33405056 4355056
13:05:38 91775 8192000000 10066580720 10529320960 1091293552 11.755 97 10 20 0 1133646784 40391616 1961616

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:14, from 18-03-2024 13:09:53 to 18-03-2024 13:10:07.

Exceptions occured during test was in run

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

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

Content of mon$database and FB version 


MON$DATABASE_NAME               /home/bases/oltp40-etalone.fdb
MON$PAGE_SIZE                   8192
MON$ODS_MAJOR                   13
MON$ODS_MINOR                   0
MON$OLDEST_TRANSACTION          183284
MON$OLDEST_ACTIVE               183285
MON$OLDEST_SNAPSHOT             183285
MON$NEXT_TRANSACTION            183285
MON$PAGE_BUFFERS                1000000
MON$SQL_DIALECT                 3
MON$SHUTDOWN_MODE               0
MON$SWEEP_INTERVAL              0
MON$READ_ONLY                   0
MON$FORCED_WRITES               1
MON$RESERVE_SPACE               1
MON$CREATION_DATE               2020-04-30 07:30:08.6030 GMT
MON$PAGES                       1980800
MON$STAT_ID                     1
MON$BACKUP_STATE                0
MON$CRYPT_PAGE                  0
MON$OWNER                       SYSDBA                                                                                                                                                                                                                                                      
MON$SEC_DATABASE                Default
MON$CRYPT_STATE                 0
MON$GUID                        {58978C10-B735-40F5-8B7D-F7A1956E782B}
MON$FILE_ID                     02fd0000000000002e02000000000000
MON$NEXT_ATTACHMENT             694
MON$NEXT_STATEMENT              53
MON$REPLICA_MODE                0


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

Database statistics 

 
Database "/home/bases/oltp40-etalone.fdb" 
Gstat execution time Mon Mar 18 13:10:11 2024 
 
Database header page information: 
    Flags            0 
    Generation        98021 
    System Change Number    0 
    Page size        8192 
    ODS version        13.0 
    Oldest transaction    183284 
    Oldest active        183285 
    Oldest snapshot        183285 
    Next transaction    183286 
    Sequence number        0 
    Next attachment ID    694 
    Implementation        HW=AMD/Intel/x64 little-endian OS=Linux CC=gcc 
    Shadow count        0 
    Page buffers        0 
    Next header page    0 
    Database dialect    3 
    Creation date        Apr 30, 2020 7:30:08 
    Attributes        force write 
 
    Variable header data: 
    Database GUID:    {58978C10-B735-40F5-8B7D-F7A1956E782B} 
    Sweep interval:        0 
    *END* 
 
 
Database file sequence: 
File /home/bases/oltp40-etalone.fdb is the only file 
 
Analyzing database pages ... 
AGENTS (150) 
    Primary pointer page: 524, Index root page: 525 
    Total formats: 1, used formats: 1 
    Average record length: 33.60, total records: 50 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 344.00, compression ratio: 10.24 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 31% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 1 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index AGENTS_ID_DESC (2) 
    Root page: 1504333, depth: 1, leaf buckets: 1, nodes: 50 
    Average node length: 11.82, total dup: 0, max dup: 0 
    Average key length: 10.80, compression ratio: 0.83 
    Average prefix length: 1.18, average data length: 7.82 
    Clustering factor: 1, ratio: 0.02 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index AGENTS_IS_OUR_FIRM (4) 
    Root page: 1504335, depth: 1, leaf buckets: 1, nodes: 50 
    Average node length: 3.08, total dup: 48, max dup: 48 
    Average key length: 2.04, compression ratio: 0.50 
    Average prefix length: 0.96, average data length: 0.06 
    Clustering factor: 1, ratio: 0.02 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index AGENTS_IS_SUPPLIER (3) 
    Root page: 1504334, depth: 1, leaf buckets: 1, nodes: 50 
    Average node length: 3.08, total dup: 48, max dup: 44 
    Average key length: 2.04, compression ratio: 0.54 
    Average prefix length: 1.04, average data length: 0.06 
    Clustering factor: 1, ratio: 0.02 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index AGENTS_NAME_UNQ (1) 
    Root page: 1504332, depth: 1, leaf buckets: 1, nodes: 50 
    Average node length: 17.20, total dup: 0, max dup: 0 
    Average key length: 15.88, compression ratio: 0.92 
    Average prefix length: 1.42, average data length: 13.20 
    Clustering factor: 1, ratio: 0.02 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PK_AGENTS (0) 
    Root page: 1504331, depth: 1, leaf buckets: 1, nodes: 50 
    Average node length: 11.82, total dup: 0, max dup: 0 
    Average key length: 10.80, compression ratio: 0.83 
    Average prefix length: 1.18, average data length: 7.82 
    Clustering factor: 1, ratio: 0.02 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
BUSINESS_OPS (154) 
    Primary pointer page: 532, Index root page: 533 
    Total formats: 1, used formats: 1 
    Average record length: 108.20, total records: 20 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1235.00, compression ratio: 11.41 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 31% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 1 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index BO_UNIT_UNQ (1) 
    Root page: 1504264, depth: 1, leaf buckets: 1, nodes: 20 
    Average node length: 18.25, total dup: 0, max dup: 0 
    Average key length: 17.20, compression ratio: 1.24 
    Average prefix length: 7.05, average data length: 14.25 
    Clustering factor: 1, ratio: 0.05 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index BUSINESS_OPS_PREDICT_PRIOR (3) 
    Root page: 1504266, depth: 1, leaf buckets: 1, nodes: 20 
    Average node length: 5.40, total dup: 0, max dup: 0 
    Average key length: 4.35, compression ratio: 0.67 
    Average prefix length: 1.20, average data length: 1.70 
    Clustering factor: 1, ratio: 0.05 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index BUSINESS_OPS_RND_WGTH (2) 
    Root page: 1504265, depth: 1, leaf buckets: 1, nodes: 20 
    Average node length: 4.30, total dup: 6, max dup: 3 
    Average key length: 3.25, compression ratio: 0.72 
    Average prefix length: 1.35, average data length: 1.00 
    Clustering factor: 1, ratio: 0.05 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index RDB$1 (0) 
    Root page: 1504263, depth: 1, leaf buckets: 1, nodes: 20 
    Average node length: 5.20, total dup: 0, max dup: 0 
    Average key length: 4.15, compression ratio: 0.65 
    Average prefix length: 1.10, average data length: 1.60 
    Clustering factor: 1, ratio: 0.05 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
DOC_DATA (139) 
    Primary pointer page: 502, Index root page: 503 
    Total formats: 1, used formats: 1 
    Average record length: 47.70, total records: 7670600 
    Average version length: 48.16, total versions: 38702, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 64.00, compression ratio: 1.34 
    Pointer pages: 55, data page slots: 88968 
    Data pages: 88968, average fill: 69% 
    Primary pages: 88966, secondary pages: 2, swept pages: 46690 
    Empty pages: 9, full pages: 64089 
    Fill distribution: 
     0 - 19% = 38 
    20 - 39% = 230 
    40 - 59% = 3741 
    60 - 79% = 84944 
    80 - 99% = 15 
 
    Index DOC_DATA_DOC_WARE_UNQ (0) 
    Root page: 1510636, depth: 3, leaf buckets: 23265, nodes: 7670600 
    Average node length: 18.86, total dup: 0, max dup: 0 
    Average key length: 15.87, compression ratio: 1.70 
    Average prefix length: 14.13, average data length: 12.87 
    Clustering factor: 1648366, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 327 
        20 - 39% = 2101 
        40 - 59% = 3969 
        60 - 79% = 2704 
        80 - 99% = 14164 
 
    Index DOC_DATA_ID_DESC (1) 
    Root page: 1528140, depth: 3, leaf buckets: 13512, nodes: 7670600 
    Average node length: 11.20, total dup: 0, max dup: 0 
    Average key length: 8.21, compression ratio: 1.10 
    Average prefix length: 3.78, average data length: 5.22 
    Clustering factor: 1472635, ratio: 0.19 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 1774 
        40 - 59% = 1903 
        60 - 79% = 1287 
        80 - 99% = 8548 
 
    Index FK_DOC_DATA_DOC_LIST (2) 
    Root page: 1546735, depth: 3, leaf buckets: 8318, nodes: 7670600 
    Average node length: 6.60, total dup: 5758831, max dup: 49 
    Average key length: 3.61, compression ratio: 2.49 
    Average prefix length: 7.64, average data length: 1.36 
    Clustering factor: 1465740, ratio: 0.19 
    Fill distribution: 
         0 - 19% = 119 
        20 - 39% = 1077 
        40 - 59% = 1296 
        60 - 79% = 1097 
        80 - 99% = 4729 
 
DOC_LIST (138) 
    Primary pointer page: 500, Index root page: 501 
    Total formats: 1, used formats: 1 
    Average record length: 56.99, total records: 2201559 
    Average version length: 58.82, total versions: 19515, max versions: 2 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 84.00, compression ratio: 1.47 
    Pointer pages: 18, data page slots: 29224 
    Data pages: 29224, average fill: 69% 
    Primary pages: 29222, secondary pages: 2, swept pages: 15638 
    Empty pages: 10, full pages: 16053 
    Fill distribution: 
     0 - 19% = 36 
    20 - 39% = 293 
    40 - 59% = 2707 
    60 - 79% = 26167 
    80 - 99% = 21 
 
    Index DOC_LIST_ID_DESC (1) 
    Root page: 1541152, depth: 3, leaf buckets: 4552, nodes: 2201559 
    Average node length: 11.41, total dup: 0, max dup: 0 
    Average key length: 8.45, compression ratio: 1.06 
    Average prefix length: 3.55, average data length: 5.45 
    Clustering factor: 656470, ratio: 0.30 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 1000 
        40 - 59% = 807 
        60 - 79% = 822 
        80 - 99% = 1923 
 
    Index DOC_LIST_WORKER_OPTYPE (2) 
    Root page: 1544398, depth: 3, leaf buckets: 2419, nodes: 2202255 
    Average node length: 4.97, total dup: 2201357, max dup: 18570 
    Average key length: 2.01, compression ratio: 4.47 
    Average prefix length: 8.99, average data length: 0.01 
    Clustering factor: 1244544, ratio: 0.57 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 236 
        40 - 59% = 1432 
        60 - 79% = 529 
        80 - 99% = 220 
 
    Index FK_DOC_LIST_AGENTS (3) 
    Root page: 1545933, depth: 3, leaf buckets: 1827, nodes: 2201559 
    Average node length: 4.97, total dup: 2201509, max dup: 130273 
    Average key length: 2.01, compression ratio: 4.48 
    Average prefix length: 8.99, average data length: 0.01 
    Clustering factor: 1064508, ratio: 0.48 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 102 
        40 - 59% = 603 
        60 - 79% = 34 
        80 - 99% = 1088 
 
    Index PK_DOC_LIST (0) 
    Root page: 1538209, depth: 3, leaf buckets: 4331, nodes: 2201559 
    Average node length: 11.41, total dup: 0, max dup: 0 
    Average key length: 8.45, compression ratio: 1.06 
    Average prefix length: 3.55, average data length: 5.45 
    Clustering factor: 656470, ratio: 0.30 
    Fill distribution: 
         0 - 19% = 92 
        20 - 39% = 632 
        40 - 59% = 604 
        60 - 79% = 939 
        80 - 99% = 2064 
 
DOC_STATES (149) 
    Primary pointer page: 522, Index root page: 523 
    Total formats: 1, used formats: 1 
    Average record length: 67.50, total records: 4 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 650.00, compression ratio: 9.63 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 4% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index DOC_STATES_MCODE_UNQ (1) 
    Root page: 1504337, depth: 1, leaf buckets: 1, nodes: 4 
    Average node length: 17.75, total dup: 0, max dup: 0 
    Average key length: 16.50, compression ratio: 1.08 
    Average prefix length: 4.00, average data length: 13.75 
    Clustering factor: 1, ratio: 0.25 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index DOC_STATES_NAME_UNQ (2) 
    Root page: 1504338, depth: 1, leaf buckets: 1, nodes: 4 
    Average node length: 33.25, total dup: 0, max dup: 0 
    Average key length: 32.00, compression ratio: 0.99 
    Average prefix length: 2.50, average data length: 29.25 
    Clustering factor: 1, ratio: 0.25 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PK_DOC_STATES (0) 
    Root page: 1504336, depth: 1, leaf buckets: 1, nodes: 4 
    Average node length: 4.75, total dup: 0, max dup: 0 
    Average key length: 3.50, compression ratio: 0.86 
    Average prefix length: 1.50, average data length: 1.50 
    Clustering factor: 1, ratio: 0.25 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
FB_ERRORS (155) 
    Primary pointer page: 534, Index root page: 535 
    Total formats: 2, used formats: 2 
    Average record length: 57.88, total records: 2182 
    Average version length: 79.61, total versions: 757, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 270.43, compression ratio: 4.67 
    Pointer pages: 1, data page slots: 40 
    Data pages: 40, average fill: 72% 
    Primary pages: 39, secondary pages: 1, swept pages: 0 
    Empty pages: 4, full pages: 34 
    Fill distribution: 
     0 - 19% = 5 
    20 - 39% = 0 
    40 - 59% = 1 
    60 - 79% = 22 
    80 - 99% = 12 
 
    Index FB_ERRORS_GDS_CODE (0) 
    Root page: 398, depth: 2, leaf buckets: 2, nodes: 2182 
    Average node length: 4.40, total dup: 756, max dup: 1 
    Average key length: 2.67, compression ratio: 1.87 
    Average prefix length: 4.33, average data length: 0.67 
    Clustering factor: 1518, ratio: 0.70 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 0 
        40 - 59% = 1 
        60 - 79% = 1 
        80 - 99% = 0 
 
INVNT_SALDO (145) 
    Primary pointer page: 514, Index root page: 515 
    Total formats: 2, used formats: 1 
    Average record length: 83.37, total records: 400 
    Average version length: 30.07, total versions: 1578, max versions: 4 
    Average fragment length: 2.00, total fragments: 3, max fragments: 1 
    Average unpacked length: 104.00, compression ratio: 1.25 
    Pointer pages: 1, data page slots: 24 
    Data pages: 24, average fill: 59% 
    Primary pages: 10, secondary pages: 14, swept pages: 0 
    Empty pages: 3, full pages: 12 
    Fill distribution: 
     0 - 19% = 8 
    20 - 39% = 1 
    40 - 59% = 0 
    60 - 79% = 2 
    80 - 99% = 13 
 
    Index PK_INVNT_SALDO (0) 
    Root page: 1510371, depth: 1, leaf buckets: 1, nodes: 400 
    Average node length: 11.22, total dup: 0, max dup: 0 
    Average key length: 10.22, compression ratio: 0.88 
    Average prefix length: 1.78, average data length: 7.22 
    Clustering factor: 326, ratio: 0.81 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 0 
        40 - 59% = 1 
        60 - 79% = 0 
        80 - 99% = 0 
 
INVNT_TURNOVER_LOG (153) 
    Primary pointer page: 530, Index root page: 531 
    Total formats: 1, used formats: 1 
    Average record length: 23.86, total records: 63817 
    Average version length: 68.26, total versions: 47830, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 88.00, compression ratio: 3.69 
    Pointer pages: 8, data page slots: 2760 
    Data pages: 1616, average fill: 52% 
    Primary pages: 1615, secondary pages: 1, swept pages: 159 
    Empty pages: 320, full pages: 645 
    Fill distribution: 
     0 - 19% = 415 
    20 - 39% = 219 
    40 - 59% = 216 
    60 - 79% = 248 
    80 - 99% = 518 
 
    Index INVNT_TURNOVER_LOG_WARE_DD_ID (0) 
    Root page: 1701490, depth: 3, leaf buckets: 285, nodes: 63817 
    Average node length: 13.31, total dup: 3509, max dup: 1 
    Average key length: 10.80, compression ratio: 2.50 
    Average prefix length: 19.14, average data length: 7.86 
    Clustering factor: 46453, ratio: 0.73 
    Fill distribution: 
         0 - 19% = 3 
        20 - 39% = 184 
        40 - 59% = 85 
        60 - 79% = 10 
        80 - 99% = 3 
 
MONEY_SALDO (141) 
    Primary pointer page: 506, Index root page: 507 
    Total formats: 1, used formats: 1 
    Average record length: 15.27, total records: 49 
    Average version length: 9.00, total versions: 138, max versions: 4 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 32.00, compression ratio: 2.10 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 64% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 1 
    80 - 99% = 0 
 
    Index PK_MONEY_SALDO (0) 
    Root page: 1510383, depth: 1, leaf buckets: 1, nodes: 49 
    Average node length: 11.82, total dup: 0, max dup: 0 
    Average key length: 10.80, compression ratio: 0.83 
    Average prefix length: 1.18, average data length: 7.82 
    Clustering factor: 1, ratio: 0.02 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
MONEY_TURNOVER_LOG (140) 
    Primary pointer page: 504, Index root page: 505 
    Total formats: 1, used formats: 1 
    Average record length: 12.42, total records: 1073 
    Average version length: 42.89, total versions: 971, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 58.00, compression ratio: 4.67 
    Pointer pages: 1, data page slots: 56 
    Data pages: 40, average fill: 29% 
    Primary pages: 39, secondary pages: 1, swept pages: 6 
    Empty pages: 20, full pages: 9 
    Fill distribution: 
     0 - 19% = 24 
    20 - 39% = 3 
    40 - 59% = 4 
    60 - 79% = 0 
    80 - 99% = 9 
 
    Index MONEY_TURNOVER_LOG_AGENT_OPTYPE (0) 
    Root page: 94551, depth: 2, leaf buckets: 2, nodes: 1073 
    Average node length: 4.43, total dup: 975, max dup: 140 
    Average key length: 2.97, compression ratio: 6.41 
    Average prefix length: 18.12, average data length: 0.88 
    Clustering factor: 604, ratio: 0.56 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 2 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
MON_CACHE_MEMORY (165) 
    Primary pointer page: 555, Index root page: 556 
    Total formats: 2, used formats: 1 
    Average record length: 97.76, total records: 71 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 112.00, compression ratio: 1.15 
    Pointer pages: 1, data page slots: 2 
    Data pages: 2, average fill: 50% 
    Primary pages: 2, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 1 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 1 
    40 - 59% = 0 
    60 - 79% = 1 
    80 - 99% = 0 
 
    Index PK_MON_CACHE_MEMORY (0) 
    Root page: 1504238, depth: 1, leaf buckets: 1, nodes: 71 
    Average node length: 11.70, total dup: 0, max dup: 0 
    Average key length: 10.69, compression ratio: 0.84 
    Average prefix length: 1.30, average data length: 7.70 
    Clustering factor: 2, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
MON_LOG (162) 
    Primary pointer page: 548, Index root page: 549 
    Total formats: 2, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index MON_LOG_DTS (4) 
    Root page: 1504251, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index MON_LOG_GDSCODE (2) 
    Root page: 1504249, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index MON_LOG_ROWSET_DESC (1) 
    Root page: 1504248, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index MON_LOG_UNIT (3) 
    Root page: 1504250, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PK_MON_LOG (0) 
    Root page: 1504247, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
MON_LOG_TABLE_STATS (163) 
    Primary pointer page: 550, Index root page: 551 
    Total formats: 2, used formats: 1 
    Average record length: 67.13, total records: 30 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 611.00, compression ratio: 9.10 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 31% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 1 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index MON_LOG_TABLE_STATS_DTS (4) 
    Root page: 1504246, depth: 1, leaf buckets: 1, nodes: 30 
    Average node length: 3.50, total dup: 23, max dup: 4 
    Average key length: 2.47, compression ratio: 3.24 
    Average prefix length: 7.53, average data length: 0.47 
    Clustering factor: 1, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index MON_LOG_TABLE_STATS_GDSCODE (2) 
    Root page: 1504244, depth: 1, leaf buckets: 1, nodes: 30 
    Average node length: 2.00, total dup: 29, max dup: 29 
    Average key length: 1.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 1, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index MON_LOG_TABLE_STATS_ROWSET (1) 
    Root page: 1504243, depth: 1, leaf buckets: 1, nodes: 30 
    Average node length: 3.33, total dup: 29, max dup: 29 
    Average key length: 2.30, compression ratio: 3.91 
    Average prefix length: 8.70, average data length: 0.30 
    Clustering factor: 1, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index MON_LOG_TABLE_STATS_TN_UNIT (3) 
    Root page: 1504245, depth: 1, leaf buckets: 1, nodes: 30 
    Average node length: 12.90, total dup: 0, max dup: 0 
    Average key length: 11.87, compression ratio: 1.42 
    Average prefix length: 7.63, average data length: 9.20 
    Clustering factor: 1, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PK_MON_LOG_TABLE_STATS (0) 
    Root page: 1504242, depth: 1, leaf buckets: 1, nodes: 30 
    Average node length: 8.37, total dup: 0, max dup: 0 
    Average key length: 7.33, compression ratio: 1.23 
    Average prefix length: 4.63, average data length: 4.37 
    Clustering factor: 1, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
OPTYPES (136) 
    Primary pointer page: 496, Index root page: 497 
    Total formats: 2, used formats: 1 
    Average record length: 67.56, total records: 9 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 386.00, compression ratio: 5.71 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 9% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index OPTYPES_MCODE_UNQ (1) 
    Root page: 1544827, depth: 1, leaf buckets: 1, nodes: 9 
    Average node length: 8.56, total dup: 0, max dup: 0 
    Average key length: 6.89, compression ratio: 0.73 
    Average prefix length: 0.44, average data length: 4.56 
    Clustering factor: 1, ratio: 0.11 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PK_OPTYPES (0) 
    Root page: 1544826, depth: 1, leaf buckets: 1, nodes: 9 
    Average node length: 6.11, total dup: 0, max dup: 0 
    Average key length: 5.00, compression ratio: 0.60 
    Average prefix length: 0.89, average data length: 2.11 
    Clustering factor: 1, ratio: 0.11 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
PDISTR (146) 
    Primary pointer page: 516, Index root page: 517 
    Total formats: 1, used formats: 1 
    Average record length: 36.93, total records: 828176 
    Average version length: 37.93, total versions: 18787, max versions: 2 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 54.00, compression ratio: 1.46 
    Pointer pages: 6, data page slots: 8896 
    Data pages: 8896, average fill: 64% 
    Primary pages: 8895, secondary pages: 1, swept pages: 3529 
    Empty pages: 20, full pages: 5465 
    Fill distribution: 
     0 - 19% = 56 
    20 - 39% = 131 
    40 - 59% = 923 
    60 - 79% = 7747 
    80 - 99% = 39 
 
    Index PDISTR_AGENT_ID (2) 
    Root page: 1509330, depth: 2, leaf buckets: 911, nodes: 819883 
    Average node length: 4.88, total dup: 819834, max dup: 158643 
    Average key length: 2.01, compression ratio: 4.48 
    Average prefix length: 8.99, average data length: 0.01 
    Clustering factor: 91968, ratio: 0.11 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 136 
        40 - 59% = 526 
        60 - 79% = 179 
        80 - 99% = 68 
 
    Index PDISTR_SNDOP_RCVOP_SNDID_ASC (0) 
    Root page: 1508635, depth: 3, leaf buckets: 1041, nodes: 819883 
    Average node length: 5.90, total dup: 729662, max dup: 42 
    Average key length: 3.02, compression ratio: 7.28 
    Average prefix length: 21.09, average data length: 0.91 
    Clustering factor: 164041, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 3 
        20 - 39% = 55 
        40 - 59% = 691 
        60 - 79% = 84 
        80 - 99% = 208 
 
    Index PDISTR_SNDOP_RCVOP_SNDID_DESC (1) 
    Root page: 1509209, depth: 3, leaf buckets: 1076, nodes: 819883 
    Average node length: 5.90, total dup: 729662, max dup: 42 
    Average key length: 3.02, compression ratio: 7.28 
    Average prefix length: 21.09, average data length: 0.91 
    Clustering factor: 165934, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 109 
        40 - 59% = 691 
        60 - 79% = 80 
        80 - 99% = 196 
 
    Index PDISTR_WORKER_SND_ID (3) 
    Root page: 1510200, depth: 3, leaf buckets: 1158, nodes: 819883 
    Average node length: 5.98, total dup: 729662, max dup: 42 
    Average key length: 3.10, compression ratio: 5.48 
    Average prefix length: 16.01, average data length: 0.99 
    Clustering factor: 158022, ratio: 0.19 
    Fill distribution: 
         0 - 19% = 5 
        20 - 39% = 225 
        40 - 59% = 609 
        60 - 79% = 239 
        80 - 99% = 80 
 
PERF_AGG (158) 
    Primary pointer page: 540, Index root page: 541 
    Total formats: 1, used formats: 1 
    Average record length: 62.78, total records: 5466 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 3.15, total fragments: 41, max fragments: 1 
    Average unpacked length: 379.00, compression ratio: 6.04 
    Pointer pages: 1, data page slots: 104 
    Data pages: 102, average fill: 53% 
    Primary pages: 85, secondary pages: 17, swept pages: 57 
    Empty pages: 14, full pages: 66 
    Fill distribution: 
     0 - 19% = 28 
    20 - 39% = 0 
    40 - 59% = 1 
    60 - 79% = 73 
    80 - 99% = 0 
 
    Index PERF_AGG_UNQ (1) 
    Root page: 1504260, depth: 2, leaf buckets: 7, nodes: 5466 
    Average node length: 5.51, total dup: 0, max dup: 0 
    Average key length: 3.59, compression ratio: 10.03 
    Average prefix length: 34.42, average data length: 1.55 
    Clustering factor: 5178, ratio: 0.95 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 4 
        60 - 79% = 1 
        80 - 99% = 1 
 
    Index PK_PERF_AGG (0) 
    Root page: 1504255, depth: 2, leaf buckets: 10, nodes: 5466 
    Average node length: 11.13, 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: 159, 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: 399, Index root page: 434 
    Total formats: 1, used formats: 1 
    Average record length: 39.06, total records: 78951 
    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: 824 
    Data pages: 824, average fill: 66% 
    Primary pages: 824, secondary pages: 0, swept pages: 0 
    Empty pages: 3, full pages: 820 
    Fill distribution: 
     0 - 19% = 4 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 820 
    80 - 99% = 0 
 
    Index PK_PERF_ESTIMATED (0) 
    Root page: 38211, depth: 2, leaf buckets: 101, nodes: 78951 
    Average node length: 10.17, total dup: 0, max dup: 0 
    Average key length: 8.18, compression ratio: 1.10 
    Average prefix length: 3.82, average data length: 5.18 
    Clustering factor: 3124, ratio: 0.04 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 1 
        60 - 79% = 0 
        80 - 99% = 99 
 
PERF_ISQL_STAT (156) 
    Primary pointer page: 536, Index root page: 537 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index PERF_ISQL_STAT_TRN (0) 
    Root page: 1504261, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
PERF_LOG (159) 
    Primary pointer page: 542, Index root page: 543 
    Total formats: 1, used formats: 1 
    Average record length: 110.65, total records: 71 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1691.00, compression ratio: 15.28 
    Pointer pages: 1, data page slots: 2 
    Data pages: 2, average fill: 56% 
    Primary pages: 2, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 1 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 1 
    40 - 59% = 0 
    60 - 79% = 1 
    80 - 99% = 0 
 
PERF_SPLIT_0 (281) 
    Primary pointer page: 601, Index root page: 602 
    Total formats: 1, used formats: 1 
    Average record length: 123.13, total records: 201368 
    Average version length: 154.96, total versions: 39649, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 13.77 
    Pointer pages: 6, data page slots: 5536 
    Data pages: 5008, average fill: 86% 
    Primary pages: 5005, secondary pages: 3, swept pages: 1 
    Empty pages: 40, full pages: 4949 
    Fill distribution: 
     0 - 19% = 41 
    20 - 39% = 4 
    40 - 59% = 2 
    60 - 79% = 9 
    80 - 99% = 4952 
 
PERF_SPLIT_1 (282) 
    Primary pointer page: 603, Index root page: 604 
    Total formats: 1, used formats: 1 
    Average record length: 145.74, total records: 136249 
    Average version length: 150.65, total versions: 4687, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.64 
    Pointer pages: 6, data page slots: 4512 
    Data pages: 3400, average fill: 83% 
    Primary pages: 3398, secondary pages: 2, swept pages: 1 
    Empty pages: 50, full pages: 3326 
    Fill distribution: 
     0 - 19% = 55 
    20 - 39% = 10 
    40 - 59% = 0 
    60 - 79% = 8 
    80 - 99% = 3327 
 
PERF_SPLIT_2 (283) 
    Primary pointer page: 605, Index root page: 606 
    Total formats: 1, used formats: 1 
    Average record length: 145.50, total records: 154489 
    Average version length: 152.03, total versions: 6001, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.66 
    Pointer pages: 7, data page slots: 6040 
    Data pages: 3912, average fill: 82% 
    Primary pages: 3909, secondary pages: 3, swept pages: 1 
    Empty pages: 106, full pages: 3779 
    Fill distribution: 
     0 - 19% = 109 
    20 - 39% = 10 
    40 - 59% = 5 
    60 - 79% = 9 
    80 - 99% = 3779 
 
PERF_SPLIT_3 (284) 
    Primary pointer page: 607, Index root page: 616 
    Total formats: 1, used formats: 1 
    Average record length: 141.47, total records: 171105 
    Average version length: 152.71, total versions: 11670, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.99 
    Pointer pages: 7, data page slots: 5264 
    Data pages: 4272, average fill: 83% 
    Primary pages: 4270, secondary pages: 2, swept pages: 2 
    Empty pages: 55, full pages: 4193 
    Fill distribution: 
     0 - 19% = 60 
    20 - 39% = 6 
    40 - 59% = 3 
    60 - 79% = 9 
    80 - 99% = 4194 
 
PERF_SPLIT_4 (285) 
    Primary pointer page: 617, Index root page: 618 
    Total formats: 1, used formats: 1 
    Average record length: 145.62, total records: 164318 
    Average version length: 150.32, total versions: 6391, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.65 
    Pointer pages: 9, data page slots: 5720 
    Data pages: 4096, average fill: 83% 
    Primary pages: 4095, secondary pages: 1, swept pages: 5 
    Empty pages: 49, full pages: 4024 
    Fill distribution: 
     0 - 19% = 51 
    20 - 39% = 9 
    40 - 59% = 5 
    60 - 79% = 6 
    80 - 99% = 4025 
 
PERF_SPLIT_5 (286) 
    Primary pointer page: 619, Index root page: 620 
    Total formats: 1, used formats: 1 
    Average record length: 141.95, total records: 174830 
    Average version length: 152.17, total versions: 11226, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.95 
    Pointer pages: 7, data page slots: 4944 
    Data pages: 4352, average fill: 84% 
    Primary pages: 4349, secondary pages: 3, swept pages: 1 
    Empty pages: 48, full pages: 4282 
    Fill distribution: 
     0 - 19% = 49 
    20 - 39% = 5 
    40 - 59% = 6 
    60 - 79% = 8 
    80 - 99% = 4284 
 
PERF_SPLIT_6 (287) 
    Primary pointer page: 621, Index root page: 622 
    Total formats: 1, used formats: 1 
    Average record length: 146.54, total records: 150802 
    Average version length: 151.32, total versions: 4221, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.57 
    Pointer pages: 6, data page slots: 4440 
    Data pages: 3760, average fill: 83% 
    Primary pages: 3758, secondary pages: 2, swept pages: 1 
    Empty pages: 60, full pages: 3681 
    Fill distribution: 
     0 - 19% = 66 
    20 - 39% = 5 
    40 - 59% = 4 
    60 - 79% = 4 
    80 - 99% = 3681 
 
PERF_SPLIT_7 (288) 
    Primary pointer page: 626, Index root page: 627 
    Total formats: 1, used formats: 1 
    Average record length: 141.40, total records: 178513 
    Average version length: 153.50, total versions: 12251, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.99 
    Pointer pages: 7, data page slots: 6264 
    Data pages: 4456, average fill: 83% 
    Primary pages: 4454, secondary pages: 2, swept pages: 7 
    Empty pages: 59, full pages: 4380 
    Fill distribution: 
     0 - 19% = 60 
    20 - 39% = 9 
    40 - 59% = 3 
    60 - 79% = 4 
    80 - 99% = 4380 
 
PERF_SPLIT_8 (289) 
    Primary pointer page: 628, Index root page: 629 
    Total formats: 1, used formats: 1 
    Average record length: 143.98, total records: 160511 
    Average version length: 151.79, total versions: 7919, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.78 
    Pointer pages: 7, data page slots: 5000 
    Data pages: 4008, average fill: 83% 
    Primary pages: 4006, secondary pages: 2, swept pages: 3 
    Empty pages: 50, full pages: 3924 
    Fill distribution: 
     0 - 19% = 55 
    20 - 39% = 3 
    40 - 59% = 22 
    60 - 79% = 6 
    80 - 99% = 3922 
 
PERF_SPLIT_9 (290) 
    Primary pointer page: 630, Index root page: 631 
    Total formats: 1, used formats: 1 
    Average record length: 148.29, total records: 155044 
    Average version length: 148.64, total versions: 2766, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.44 
    Pointer pages: 7, data page slots: 4856 
    Data pages: 3880, average fill: 82% 
    Primary pages: 3877, secondary pages: 3, swept pages: 1 
    Empty pages: 67, full pages: 3794 
    Fill distribution: 
     0 - 19% = 75 
    20 - 39% = 4 
    40 - 59% = 5 
    60 - 79% = 4 
    80 - 99% = 3792 
 
PHRASES (143) 
    Primary pointer page: 510, Index root page: 511 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index PHRASES_ID_DESC (3) 
    Root page: 1510376, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PHRASES_NAME (2) 
    Root page: 1510375, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PHRASES_UNQ (1) 
    Root page: 1510374, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PK_PHRASES (0) 
    Root page: 1510373, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
PSTORNED (147) 
    Primary pointer page: 518, Index root page: 519 
    Total formats: 1, used formats: 1 
    Average record length: 52.49, total records: 2042025 
    Average version length: 52.89, total versions: 12129, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 70.00, compression ratio: 1.33 
    Pointer pages: 17, data page slots: 26232 
    Data pages: 26232, average fill: 67% 
    Primary pages: 26210, secondary pages: 22, swept pages: 14490 
    Empty pages: 429, full pages: 19669 
    Fill distribution: 
     0 - 19% = 836 
    20 - 39% = 713 
    40 - 59% = 1808 
    60 - 79% = 22778 
    80 - 99% = 97 
 
    Index PSTORNED_RCV_ID (1) 
    Root page: 1506208, depth: 3, leaf buckets: 2572, nodes: 2042025 
    Average node length: 5.45, total dup: 1903666, max dup: 1562 
    Average key length: 2.49, compression ratio: 3.61 
    Average prefix length: 8.57, average data length: 0.43 
    Clustering factor: 177829, ratio: 0.09 
    Fill distribution: 
         0 - 19% = 7 
        20 - 39% = 376 
        40 - 59% = 1636 
        60 - 79% = 267 
        80 - 99% = 286 
 
    Index PSTORNED_SND_ID (0) 
    Root page: 1504841, depth: 3, leaf buckets: 2756, nodes: 2042025 
    Average node length: 5.70, total dup: 1831873, max dup: 64 
    Average key length: 2.74, compression ratio: 3.28 
    Average prefix length: 8.36, average data length: 0.64 
    Clustering factor: 366008, ratio: 0.18 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 12 
        40 - 59% = 2536 
        60 - 79% = 189 
        80 - 99% = 19 
 
    Index PSTORNED_WORKER_ID (2) 
    Root page: 1508018, depth: 3, leaf buckets: 2098, nodes: 2042025 
    Average node length: 4.96, total dup: 2041925, max dup: 27446 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.41, average data length: 0.00 
    Clustering factor: 176105, ratio: 0.09 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 233 
        40 - 59% = 1099 
        60 - 79% = 354 
        80 - 99% = 411 
 
RULES_FOR_PDISTR (148) 
    Primary pointer page: 520, Index root page: 521 
    Total formats: 1, used formats: 1 
    Average record length: 17.00, total records: 4 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 334.00, compression ratio: 19.65 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 2% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index RULES_FOR_PDISTR_UNQ (0) 
    Root page: 1504339, depth: 1, leaf buckets: 1, nodes: 4 
    Average node length: 11.50, total dup: 0, max dup: 0 
    Average key length: 10.25, compression ratio: 0.88 
    Average prefix length: 1.50, average data length: 7.50 
    Clustering factor: 1, ratio: 0.25 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
RULES_FOR_QDISTR (137) 
    Primary pointer page: 498, Index root page: 499 
    Total formats: 1, used formats: 1 
    Average record length: 32.71, total records: 7 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 332.00, compression ratio: 10.15 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 4% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index RULES_FOR_QDISTR_RCVOP (1) 
    Root page: 1544825, depth: 1, leaf buckets: 1, nodes: 7 
    Average node length: 5.29, total dup: 2, max dup: 2 
    Average key length: 4.14, compression ratio: 0.72 
    Average prefix length: 1.43, average data length: 1.57 
    Clustering factor: 1, ratio: 0.14 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index RULES_FOR_QDISTR_UNQ (0) 
    Root page: 1544824, depth: 1, leaf buckets: 1, nodes: 7 
    Average node length: 10.14, total dup: 0, max dup: 0 
    Average key length: 8.86, compression ratio: 0.94 
    Average prefix length: 2.14, average data length: 6.14 
    Clustering factor: 1, ratio: 0.14 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
SEMAPHORES (152) 
    Primary pointer page: 528, Index root page: 529 
    Total formats: 1, used formats: 1 
    Average record length: 43.40, total records: 5 
    Average version length: 9.00, total versions: 1, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 346.00, compression ratio: 7.97 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 4% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index PK_SEMAPHORES (0) 
    Root page: 1504327, depth: 1, leaf buckets: 1, nodes: 5 
    Average node length: 12.40, total dup: 0, max dup: 0 
    Average key length: 11.00, compression ratio: 0.82 
    Average prefix length: 0.60, average data length: 8.40 
    Clustering factor: 1, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index SEMAPHORES_TASK_UNQ (1) 
    Root page: 1504328, depth: 1, leaf buckets: 1, nodes: 5 
    Average node length: 23.40, total dup: 0, max dup: 0 
    Average key length: 22.00, compression ratio: 1.07 
    Average prefix length: 4.20, average data length: 19.40 
    Clustering factor: 1, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
SETTINGS (135) 
    Primary pointer page: 494, Index root page: 495 
    Total formats: 1, used formats: 1 
    Average record length: 97.62, total records: 149 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1347.00, compression ratio: 13.80 
    Pointer pages: 1, data page slots: 3 
    Data pages: 3, average fill: 70% 
    Primary pages: 3, secondary pages: 0, swept pages: 1 
    Empty pages: 0, full pages: 2 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 1 
    60 - 79% = 0 
    80 - 99% = 2 
 
    Index SETTINGS_MCODE_WM_UNQ (1) 
    Root page: 1544931, depth: 1, leaf buckets: 1, nodes: 149 
    Average node length: 14.66, total dup: 0, max dup: 0 
    Average key length: 13.55, compression ratio: 2.19 
    Average prefix length: 19.07, average data length: 10.66 
    Clustering factor: 48, ratio: 0.32 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 1 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index SETTINGS_MODE_CODE (0) 
    Root page: 1544828, depth: 1, leaf buckets: 1, nodes: 149 
    Average node length: 25.56, total dup: 0, max dup: 0 
    Average key length: 24.56, compression ratio: 1.63 
    Average prefix length: 18.58, average data length: 21.56 
    Clustering factor: 14, ratio: 0.09 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 0 
        40 - 59% = 1 
        60 - 79% = 0 
        80 - 99% = 0 
 
TMP$DEP_DOCS (129) 
    Primary pointer page: 482, Index root page: 483 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index TMP_DEP_DOCS_UNQ (0) 
    Root page: 1544832, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
TMP$IDX_RECALC (132) 
    Primary pointer page: 488, Index root page: 489 
    Total formats: 2, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index TMP_IDX_RECALC_IDX_NAME_UNQ (0) 
    Root page: 1544829, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
TMP$MON_LOG (133) 
    Primary pointer page: 490, Index root page: 491 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
TMP$MON_LOG_TABLE_STATS (134) 
    Primary pointer page: 492, Index root page: 493 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
TMP$PERF_EST_WHOLE (161) 
    Primary pointer page: 546, Index root page: 547 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
TMP$PERF_LOG (160) 
    Primary pointer page: 544, Index root page: 545 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index TMP$PERF_LOG_UNIT_TRN_DTS_END (0) 
    Root page: 1504252, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
TMP$PERF_MON (131) 
    Primary pointer page: 486, Index root page: 487 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
TMP$RESULT_SET (130) 
    Primary pointer page: 484, Index root page: 485 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index TMP_RESULT_SET_DOC (1) 
    Root page: 1544831, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index TMP_RESULT_SET_WARE_DOC (0) 
    Root page: 1544830, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
TMP$SHOPPING_CART (128) 
    Primary pointer page: 480, Index root page: 481 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index TMP_SHOPCART_UNQ (0) 
    Root page: 1544833, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
TPAUSE (166) 
    Primary pointer page: 557, Index root page: 558 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index RDB$PRIMARY2 (0) 
    Root page: 1504237, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
TRACE_STAT (157) 
    Primary pointer page: 538, Index root page: 539 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
WARES (142) 
    Primary pointer page: 508, Index root page: 509 
    Total formats: 1, used formats: 1 
    Average record length: 77.52, total records: 400 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 444.00, compression ratio: 5.73 
    Pointer pages: 1, data page slots: 6 
    Data pages: 6, average fill: 77% 
    Primary pages: 6, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 5 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 5 
    80 - 99% = 1 
 
    Index FK_WARES_WARE_GROUPS (3) 
    Root page: 1552183, depth: 1, leaf buckets: 1, nodes: 400 
    Average node length: 3.17, total dup: 392, max dup: 60 
    Average key length: 2.16, compression ratio: 4.16 
    Average prefix length: 8.86, average data length: 0.14 
    Clustering factor: 48, ratio: 0.12 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PK_WARES (0) 
    Root page: 1510377, depth: 1, leaf buckets: 1, nodes: 400 
    Average node length: 11.22, total dup: 0, max dup: 0 
    Average key length: 10.22, compression ratio: 0.88 
    Average prefix length: 1.78, average data length: 7.22 
    Clustering factor: 344, ratio: 0.86 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 0 
        40 - 59% = 1 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index WARES_ID_DESC (2) 
    Root page: 1510382, depth: 1, leaf buckets: 1, nodes: 400 
    Average node length: 11.22, total dup: 0, max dup: 0 
    Average key length: 10.22, compression ratio: 0.88 
    Average prefix length: 1.78, average data length: 7.22 
    Clustering factor: 344, ratio: 0.86 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 0 
        40 - 59% = 1 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index WARES_NUMB_UNQ (1) 
    Root page: 1510380, depth: 2, leaf buckets: 3, nodes: 400 
    Average node length: 53.25, total dup: 0, max dup: 0 
    Average key length: 52.23, compression ratio: 1.00 
    Average prefix length: 2.74, average data length: 49.25 
    Clustering factor: 355, ratio: 0.89 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 1 
        80 - 99% = 2 
 
WARE_GROUPS (151) 
    Primary pointer page: 526, Index root page: 527 
    Total formats: 1, used formats: 1 
    Average record length: 32.12, total records: 8 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 346.00, compression ratio: 10.77 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 5% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index PK_WARE_GROUPS (0) 
    Root page: 1504329, depth: 1, leaf buckets: 1, nodes: 8 
    Average node length: 11.25, total dup: 0, max dup: 0 
    Average key length: 10.12, compression ratio: 0.89 
    Average prefix length: 1.75, average data length: 7.25 
    Clustering factor: 1, ratio: 0.12 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index WARE_GROUPS_NAME_UNQ (1) 
    Root page: 1504330, depth: 1, leaf buckets: 1, nodes: 8 
    Average node length: 19.88, total dup: 0, max dup: 0 
    Average key length: 18.12, compression ratio: 0.89 
    Average prefix length: 0.25, average data length: 15.88 
    Clustering factor: 1, ratio: 0.12 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
XQD_1000_1200 (176) 
    Primary pointer page: 577, Index root page: 578 
    Total formats: 1, used formats: 1 
    Average record length: 51.45, total records: 141250 
    Average version length: 69.17, total versions: 41648, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 2.45 
    Pointer pages: 3, data page slots: 4464 
    Data pages: 3624, average fill: 46% 
    Primary pages: 3624, secondary pages: 0, swept pages: 887 
    Empty pages: 635, full pages: 1170 
    Fill distribution: 
     0 - 19% = 1012 
    20 - 39% = 527 
    40 - 59% = 497 
    60 - 79% = 1137 
    80 - 99% = 451 
 
    Index XQD_1000_1200_WA_SO_RO_WKR_SND (0) 
    Root page: 106226, depth: 3, leaf buckets: 250, nodes: 141250 
    Average node length: 6.47, total dup: 122655, max dup: 14 
    Average key length: 3.97, compression ratio: 10.57 
    Average prefix length: 40.16, average data length: 1.84 
    Clustering factor: 24516, ratio: 0.17 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 82 
        40 - 59% = 130 
        60 - 79% = 34 
        80 - 99% = 2 
 
XQD_1000_3300 (178) 
    Primary pointer page: 581, Index root page: 582 
    Total formats: 1, used formats: 1 
    Average record length: 67.15, total records: 7060213 
    Average version length: 68.78, total versions: 213427, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.88 
    Pointer pages: 68, data page slots: 110056 
    Data pages: 110056, average fill: 69% 
    Primary pages: 110055, secondary pages: 1, swept pages: 48239 
    Empty pages: 13, full pages: 54846 
    Fill distribution: 
     0 - 19% = 177 
    20 - 39% = 1915 
    40 - 59% = 13986 
    60 - 79% = 93688 
    80 - 99% = 290 
 
    Index XQD_1000_3300_WA_SO_RO_WKR_SND (0) 
    Root page: 1480476, depth: 3, leaf buckets: 10852, nodes: 7060213 
    Average node length: 6.52, total dup: 6103405, max dup: 29 
    Average key length: 3.53, compression ratio: 11.91 
    Average prefix length: 40.61, average data length: 1.39 
    Clustering factor: 1648250, ratio: 0.23 
    Fill distribution: 
         0 - 19% = 6 
        20 - 39% = 1755 
        40 - 59% = 6002 
        60 - 79% = 2718 
        80 - 99% = 371 
 
    Index XQD_1000_3300_WKR_DOC_ASC (1) 
    Root page: 1486090, depth: 3, leaf buckets: 8710, nodes: 7060213 
    Average node length: 5.40, total dup: 6776832, max dup: 119 
    Average key length: 2.41, compression ratio: 7.05 
    Average prefix length: 16.63, average data length: 0.37 
    Clustering factor: 1454476, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 11 
        20 - 39% = 1311 
        40 - 59% = 4942 
        60 - 79% = 1555 
        80 - 99% = 891 
 
    Index XQD_1000_3300_WKR_DOC_DEC (2) 
    Root page: 1490630, depth: 3, leaf buckets: 8787, nodes: 7060213 
    Average node length: 5.40, total dup: 6776832, max dup: 119 
    Average key length: 2.41, compression ratio: 7.05 
    Average prefix length: 16.63, average data length: 0.37 
    Clustering factor: 1456724, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 8 
        20 - 39% = 1427 
        40 - 59% = 4907 
        60 - 79% = 1565 
        80 - 99% = 880 
 
XQD_1200_2000 (177) 
    Primary pointer page: 579, Index root page: 580 
    Total formats: 1, used formats: 1 
    Average record length: 68.15, total records: 12148377 
    Average version length: 68.69, total versions: 161519, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.85 
    Pointer pages: 109, data page slots: 177888 
    Data pages: 177888, average fill: 72% 
    Primary pages: 177887, secondary pages: 1, swept pages: 88758 
    Empty pages: 4, full pages: 141953 
    Fill distribution: 
     0 - 19% = 55 
    20 - 39% = 879 
    40 - 59% = 7489 
    60 - 79% = 168797 
    80 - 99% = 668 
 
    Index XQD_1200_2000_WA_SO_RO_WKR_SND (0) 
    Root page: 1495050, depth: 3, leaf buckets: 18507, nodes: 12147540 
    Average node length: 6.63, total dup: 10584680, max dup: 55 
    Average key length: 3.43, compression ratio: 12.24 
    Average prefix length: 40.70, average data length: 1.30 
    Clustering factor: 2487504, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 22 
        20 - 39% = 2190 
        40 - 59% = 10819 
        60 - 79% = 4661 
        80 - 99% = 815 
 
XQD_2000_3300 (179) 
    Primary pointer page: 583, Index root page: 584 
    Total formats: 1, used formats: 1 
    Average record length: 55.68, total records: 1184816 
    Average version length: 68.96, total versions: 178808, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 2.26 
    Pointer pages: 32, data page slots: 49680 
    Data pages: 29048, average fill: 44% 
    Primary pages: 28962, secondary pages: 86, swept pages: 14752 
    Empty pages: 5991, full pages: 11745 
    Fill distribution: 
     0 - 19% = 9148 
    20 - 39% = 4116 
    40 - 59% = 3038 
    60 - 79% = 10610 
    80 - 99% = 2136 
 
    Index XQD_2000_3300_WA_SO_RO_WKR_SND (0) 
    Root page: 1479735, depth: 3, leaf buckets: 1789, nodes: 1098243 
    Average node length: 5.54, total dup: 1052930, max dup: 49 
    Average key length: 2.60, compression ratio: 16.17 
    Average prefix length: 41.44, average data length: 0.56 
    Clustering factor: 76154, ratio: 0.07 
    Fill distribution: 
         0 - 19% = 6 
        20 - 39% = 870 
        40 - 59% = 724 
        60 - 79% = 168 
        80 - 99% = 21 
 
XQD_2100_3300 (180) 
    Primary pointer page: 585, Index root page: 586 
    Total formats: 1, used formats: 1 
    Average record length: 52.54, total records: 838272 
    Average version length: 69.06, total versions: 81637, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 2.40 
    Pointer pages: 24, data page slots: 38288 
    Data pages: 29232, average fill: 29% 
    Primary pages: 29230, secondary pages: 2, swept pages: 13911 
    Empty pages: 5892, full pages: 2707 
    Fill distribution: 
     0 - 19% = 11711 
    20 - 39% = 7287 
    40 - 59% = 6511 
    60 - 79% = 3658 
    80 - 99% = 65 
 
    Index XQD_2100_3300_WA_SO_RO_WKR_SND (0) 
    Root page: 1479229, depth: 3, leaf buckets: 1213, nodes: 689680 
    Average node length: 5.95, total dup: 635707, max dup: 61 
    Average key length: 3.02, compression ratio: 13.92 
    Average prefix length: 41.06, average data length: 0.94 
    Clustering factor: 98847, ratio: 0.14 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 579 
        40 - 59% = 522 
        60 - 79% = 109 
        80 - 99% = 3 
 
XQD_3300_3400 (181) 
    Primary pointer page: 587, Index root page: 588 
    Total formats: 1, used formats: 1 
    Average record length: 67.72, total records: 8787098 
    Average version length: 68.95, total versions: 171885, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.86 
    Pointer pages: 94, data page slots: 152408 
    Data pages: 152384, average fill: 62% 
    Primary pages: 152357, secondary pages: 27, swept pages: 93816 
    Empty pages: 751, full pages: 51535 
    Fill distribution: 
     0 - 19% = 2670 
    20 - 39% = 13092 
    40 - 59% = 38668 
    60 - 79% = 96812 
    80 - 99% = 1142 
 
    Index XQD_3300_3400_WA_SO_RO_WKR_SND (0) 
    Root page: 1472612, depth: 3, leaf buckets: 13511, nodes: 8786112 
    Average node length: 6.73, total dup: 7285759, max dup: 14 
    Average key length: 3.67, compression ratio: 11.44 
    Average prefix length: 40.50, average data length: 1.50 
    Clustering factor: 1915182, ratio: 0.22 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 1702 
        40 - 59% = 7412 
        60 - 79% = 3958 
        80 - 99% = 439 
 
XQS_1000_1200 (182) 
    Primary pointer page: 589, Index root page: 590 
    Total formats: 1, used formats: 1 
    Average record length: 82.49, total records: 21130382 
    Average version length: 82.99, total versions: 14675, 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: 319536 
    Data pages: 319536, average fill: 81% 
    Primary pages: 319527, secondary pages: 9, swept pages: 12920 
    Empty pages: 41, full pages: 318571 
    Fill distribution: 
     0 - 19% = 75 
    20 - 39% = 55 
    40 - 59% = 125 
    60 - 79% = 48220 
    80 - 99% = 271061 
 
    Index XQS_1000_1200_DOC_ID (1) 
    Root page: 1426738, depth: 3, leaf buckets: 19548, nodes: 21130382 
    Average node length: 5.72, total dup: 20649599, max dup: 186 
    Average key length: 2.16, compression ratio: 4.16 
    Average prefix length: 8.86, average data length: 0.14 
    Clustering factor: 3281752, ratio: 0.16 
    Fill distribution: 
         0 - 19% = 3 
        20 - 39% = 0 
        40 - 59% = 8505 
        60 - 79% = 551 
        80 - 99% = 10489 
 
    Index XQS_1000_1200_RCV_ID (3) 
    Root page: 1457002, depth: 3, leaf buckets: 17161, nodes: 21130382 
    Average node length: 6.31, total dup: 18569166, max dup: 49 
    Average key length: 2.75, compression ratio: 3.27 
    Average prefix length: 8.37, average data length: 0.63 
    Clustering factor: 918773, ratio: 0.04 
    Fill distribution: 
         0 - 19% = 8 
        20 - 39% = 9 
        40 - 59% = 768 
        60 - 79% = 272 
        80 - 99% = 16104 
 
    Index XQS_1000_1200_SND_ID (2) 
    Root page: 1441095, depth: 3, leaf buckets: 21314, nodes: 21130382 
    Average node length: 6.35, total dup: 18488709, max dup: 29 
    Average key length: 2.79, compression ratio: 3.23 
    Average prefix length: 8.34, average data length: 0.66 
    Clustering factor: 3575683, ratio: 0.17 
    Fill distribution: 
         0 - 19% = 4 
        20 - 39% = 2 
        40 - 59% = 8747 
        60 - 79% = 602 
        80 - 99% = 11959 
 
    Index XQS_1000_1200_WORKER_ID (0) 
    Root page: 1413370, depth: 3, leaf buckets: 15934, nodes: 21130382 
    Average node length: 5.56, total dup: 21130282, max dup: 232032 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.42, average data length: 0.00 
    Clustering factor: 947481, ratio: 0.04 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 13 
        40 - 59% = 2610 
        60 - 79% = 325 
        80 - 99% = 12986 
 
XQS_1000_3300 (184) 
    Primary pointer page: 593, Index root page: 594 
    Total formats: 1, used formats: 1 
    Average record length: 80.58, total records: 9299614 
    Average version length: 82.63, total versions: 232839, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.56 
    Pointer pages: 113, data page slots: 183408 
    Data pages: 183376, average fill: 63% 
    Primary pages: 183329, secondary pages: 47, swept pages: 116561 
    Empty pages: 1397, full pages: 72310 
    Fill distribution: 
     0 - 19% = 4708 
    20 - 39% = 17600 
    40 - 59% = 43821 
    60 - 79% = 100289 
    80 - 99% = 16958 
 
    Index XQS_1000_3300_DOC_ID (1) 
    Root page: 1367524, depth: 3, leaf buckets: 11431, nodes: 9299614 
    Average node length: 5.43, total dup: 8993947, max dup: 170 
    Average key length: 2.24, compression ratio: 4.02 
    Average prefix length: 8.79, average data length: 0.21 
    Clustering factor: 2029450, ratio: 0.22 
    Fill distribution: 
         0 - 19% = 3 
        20 - 39% = 220 
        40 - 59% = 8939 
        60 - 79% = 2239 
        80 - 99% = 30 
 
    Index XQS_1000_3300_RCV_ID (3) 
    Root page: 1379283, depth: 3, leaf buckets: 13503, nodes: 9299614 
    Average node length: 6.29, total dup: 7705690, max dup: 14 
    Average key length: 3.10, compression ratio: 2.90 
    Average prefix length: 8.07, average data length: 0.93 
    Clustering factor: 1382638, ratio: 0.15 
    Fill distribution: 
         0 - 19% = 127 
        20 - 39% = 4276 
        40 - 59% = 4376 
        60 - 79% = 2665 
        80 - 99% = 2059 
 
    Index XQS_1000_3300_SND_ID (2) 
    Root page: 1373081, depth: 3, leaf buckets: 12765, nodes: 9299614 
    Average node length: 6.04, total dup: 8059741, max dup: 44 
    Average key length: 2.86, compression ratio: 3.15 
    Average prefix length: 8.28, average data length: 0.72 
    Clustering factor: 2213032, ratio: 0.24 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 265 
        40 - 59% = 10051 
        60 - 79% = 2410 
        80 - 99% = 38 
 
    Index XQS_1000_3300_WORKER_ID (0) 
    Root page: 1362789, depth: 3, leaf buckets: 9973, nodes: 9299614 
    Average node length: 5.19, total dup: 9299514, max dup: 143014 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.42, average data length: 0.00 
    Clustering factor: 1433705, ratio: 0.15 
    Fill distribution: 
         0 - 19% = 52 
        20 - 39% = 1449 
        40 - 59% = 4859 
        60 - 79% = 1613 
        80 - 99% = 2000 
 
XQS_1200_2000 (183) 
    Primary pointer page: 591, Index root page: 592 
    Total formats: 1, used formats: 1 
    Average record length: 80.65, total records: 10949930 
    Average version length: 82.63, total versions: 244418, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.56 
    Pointer pages: 123, data page slots: 200112 
    Data pages: 198400, average fill: 68% 
    Primary pages: 198177, secondary pages: 223, swept pages: 93807 
    Empty pages: 4317, full pages: 127300 
    Fill distribution: 
     0 - 19% = 7987 
    20 - 39% = 13062 
    40 - 59% = 27782 
    60 - 79% = 90101 
    80 - 99% = 59468 
 
    Index XQS_1200_2000_DOC_ID (1) 
    Root page: 1392123, depth: 3, leaf buckets: 13142, nodes: 10949930 
    Average node length: 5.33, total dup: 10840446, max dup: 684 
    Average key length: 2.08, compression ratio: 4.32 
    Average prefix length: 8.93, average data length: 0.07 
    Clustering factor: 2283836, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 166 
        40 - 59% = 9880 
        60 - 79% = 3010 
        80 - 99% = 85 
 
    Index XQS_1200_2000_RCV_ID (3) 
    Root page: 1406132, depth: 3, leaf buckets: 10336, nodes: 10949930 
    Average node length: 5.53, total dup: 10469379, max dup: 49 
    Average key length: 2.28, compression ratio: 3.95 
    Average prefix length: 8.77, average data length: 0.23 
    Clustering factor: 694260, ratio: 0.06 
    Fill distribution: 
         0 - 19% = 171 
        20 - 39% = 941 
        40 - 59% = 2531 
        60 - 79% = 1954 
        80 - 99% = 4739 
 
    Index XQS_1200_2000_SND_ID (2) 
    Root page: 1398660, depth: 3, leaf buckets: 15025, nodes: 10949930 
    Average node length: 6.06, total dup: 9545975, max dup: 81 
    Average key length: 2.81, compression ratio: 3.20 
    Average prefix length: 8.32, average data length: 0.68 
    Clustering factor: 2300092, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 207 
        40 - 59% = 11445 
        60 - 79% = 3289 
        80 - 99% = 82 
 
    Index XQS_1200_2000_WORKER_ID (0) 
    Root page: 1386233, depth: 3, leaf buckets: 10477, nodes: 10949930 
    Average node length: 5.25, total dup: 10949830, max dup: 188805 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.41, average data length: 0.00 
    Clustering factor: 684110, ratio: 0.06 
    Fill distribution: 
         0 - 19% = 91 
        20 - 39% = 947 
        40 - 59% = 4451 
        60 - 79% = 1464 
        80 - 99% = 3524 
 
XQS_2000_3300 (185) 
    Primary pointer page: 595, Index root page: 596 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index XQS_2000_3300_DOC_ID (1) 
    Root page: 1361775, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index XQS_2000_3300_RCV_ID (3) 
    Root page: 1361777, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index XQS_2000_3300_SND_ID (2) 
    Root page: 1361776, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index XQS_2000_3300_WORKER_ID (0) 
    Root page: 1361774, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
XQS_2100_3300 (186) 
    Primary pointer page: 597, Index root page: 598 
    Total formats: 1, used formats: 1 
    Average record length: 80.88, total records: 9415713 
    Average version length: 82.89, total versions: 237679, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.56 
    Pointer pages: 114, data page slots: 184752 
    Data pages: 184736, average fill: 63% 
    Primary pages: 184692, secondary pages: 44, swept pages: 115152 
    Empty pages: 1336, full pages: 70069 
    Fill distribution: 
     0 - 19% = 4180 
    20 - 39% = 15300 
    40 - 59% = 44411 
    60 - 79% = 105651 
    80 - 99% = 15194 
 
    Index XQS_2100_3300_DOC_ID (1) 
    Root page: 1344708, depth: 3, leaf buckets: 11735, nodes: 9415713 
    Average node length: 5.22, total dup: 9386679, max dup: 1498 
    Average key length: 2.03, compression ratio: 4.43 
    Average prefix length: 8.97, average data length: 0.03 
    Clustering factor: 1865177, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 36 
        20 - 39% = 1797 
        40 - 59% = 7680 
        60 - 79% = 1720 
        80 - 99% = 502 
 
    Index XQS_2100_3300_RCV_ID (3) 
    Root page: 1355739, depth: 3, leaf buckets: 13667, nodes: 9415713 
    Average node length: 6.30, total dup: 7801637, max dup: 14 
    Average key length: 3.11, compression ratio: 2.90 
    Average prefix length: 8.07, average data length: 0.93 
    Clustering factor: 1380918, ratio: 0.15 
    Fill distribution: 
         0 - 19% = 184 
        20 - 39% = 4333 
        40 - 59% = 4304 
        60 - 79% = 2657 
        80 - 99% = 2189 
 
    Index XQS_2100_3300_SND_ID (2) 
    Root page: 1350071, depth: 3, leaf buckets: 12307, nodes: 9415713 
    Average node length: 5.48, total dup: 8986783, max dup: 94 
    Average key length: 2.29, compression ratio: 3.93 
    Average prefix length: 8.75, average data length: 0.25 
    Clustering factor: 1993971, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 26 
        20 - 39% = 1701 
        40 - 59% = 8497 
        60 - 79% = 1552 
        80 - 99% = 531 
 
    Index XQS_2100_3300_WORKER_ID (0) 
    Root page: 987843, depth: 3, leaf buckets: 10163, nodes: 9415713 
    Average node length: 5.19, total dup: 9415613, max dup: 145714 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.41, average data length: 0.00 
    Clustering factor: 1478734, ratio: 0.16 
    Fill distribution: 
         0 - 19% = 49 
        20 - 39% = 1487 
        40 - 59% = 5017 
        60 - 79% = 1642 
        80 - 99% = 1968 
 
XQS_3300_3400 (187) 
    Primary pointer page: 599, Index root page: 600 
    Total formats: 1, used formats: 1 
    Average record length: 67.85, total records: 566843 
    Average version length: 68.74, total versions: 3036, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.86 
    Pointer pages: 5, data page slots: 8112 
    Data pages: 8112, average fill: 73% 
    Primary pages: 8111, secondary pages: 1, swept pages: 4422 
    Empty pages: 4, full pages: 6087 
    Fill distribution: 
     0 - 19% = 8 
    20 - 39% = 51 
    40 - 59% = 386 
    60 - 79% = 7651 
    80 - 99% = 16 
 
    Index XQS_3300_3400_DOC_ID (1) 
    Root page: 46305, depth: 3, leaf buckets: 749, nodes: 566843 
    Average node length: 5.95, total dup: 482396, max dup: 83 
    Average key length: 3.10, compression ratio: 2.91 
    Average prefix length: 8.05, average data length: 0.95 
    Clustering factor: 99076, ratio: 0.17 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 49 
        40 - 59% = 544 
        60 - 79% = 78 
        80 - 99% = 78 
 
    Index XQS_3300_3400_SND_ID (2) 
    Root page: 33500, depth: 3, leaf buckets: 772, nodes: 566843 
    Average node length: 6.15, total dup: 464638, max dup: 14 
    Average key length: 3.30, compression ratio: 2.73 
    Average prefix length: 7.88, average data length: 1.12 
    Clustering factor: 99128, ratio: 0.17 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 49 
        40 - 59% = 556 
        60 - 79% = 83 
        80 - 99% = 84 
 
    Index XQS_3300_3400_WORKER_ID (0) 
    Root page: 377587, depth: 2, leaf buckets: 557, nodes: 566843 
    Average node length: 4.86, total dup: 566743, max dup: 9381 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.41, average data length: 0.00 
    Clustering factor: 88232, ratio: 0.16 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 39 
        40 - 59% = 311 
        60 - 79% = 66 
        80 - 99% = 139 
 
ZDOC_DATA (170) 
    Primary pointer page: 565, Index root page: 566 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
ZDOC_LIST (169) 
    Primary pointer page: 563, Index root page: 564 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
ZINVNT_TURNOVER_LOG (171) 
    Primary pointer page: 567, Index root page: 568 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
ZPDISTR (174) 
    Primary pointer page: 573, Index root page: 574 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index ZPDISTR_ID (0) 
    Root page: 1504230, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
ZPSTORNED (175) 
    Primary pointer page: 575, Index root page: 576 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index ZPSTORNED_ID (0) 
    Root page: 1504229, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
ZQDISTR (172) 
    Primary pointer page: 569, Index root page: 570 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index ZQDISTR_ID (0) 
    Root page: 1504235, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index ZQDISTR_WARE_SNDOP_RCVOP (1) 
    Root page: 1504236, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
ZQSTORNED (173) 
    Primary pointer page: 571, Index root page: 572 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index ZQSTORNED_DOC_ID (1) 
    Root page: 1504232, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index ZQSTORNED_ID (0) 
    Root page: 1504231, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index ZQSTORNED_RCV_ID (3) 
    Root page: 1504234, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index ZQSTORNED_SND_ID (2) 
    Root page: 1504233, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
ZTMP_DEP_DOCS (168) 
    Primary pointer page: 561, Index root page: 562 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
ZTMP_SHOPPING_CART (167) 
    Primary pointer page: 559, Index root page: 560 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
Z_USED_VIEWS (144) 
    Primary pointer page: 512, Index root page: 513 
    Total formats: 1, used formats: 1 
    Average record length: 29.38, total records: 29 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 99.00, compression ratio: 3.37 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 16% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index Z_USED_VIEWS_UNQ (0) 
    Root page: 1510372, depth: 1, leaf buckets: 1, nodes: 29 
    Average node length: 15.17, total dup: 0, max dup: 0 
    Average key length: 14.14, compression ratio: 1.44 
    Average prefix length: 9.17, average data length: 11.17 
    Clustering factor: 1, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
Gstat completion time Mon Mar 18 13:10:35 2024

Record versions statistics, table

TABLE_NAME TOTAL_RECS TOTAL_VERS MAX_VERSIONS VERS_TO_RECS_PRC MAXV_TO_VERS_PRC
DOC_DATA 7670600 38702 1 0.0000 0.0000
DOC_LIST 2201559 19515 2 0.0000 0.0000
FB_ERRORS 2182 757 1 0.0000 0.0000
INVNT_SALDO 400 1578 4 300.0000 0.0000
INVNT_TURNOVER_LOG 63817 47830 1 0.0000 0.0000
MONEY_SALDO 49 138 4 200.0000 0.0000
MONEY_TURNOVER_LOG 1073 971 1 0.0000 0.0000
PDISTR 828176 18787 2 0.0000 0.0000
PERF_SPLIT_0 201368 39649 1 0.0000 0.0000
PERF_SPLIT_1 136249 4687 1 0.0000 0.0000
PERF_SPLIT_2 154489 6001 1 0.0000 0.0000
PERF_SPLIT_3 171105 11670 1 0.0000 0.0000
PERF_SPLIT_4 164318 6391 1 0.0000 0.0000
PERF_SPLIT_5 174830 11226 1 0.0000 0.0000
PERF_SPLIT_6 150802 4221 1 0.0000 0.0000
PERF_SPLIT_7 178513 12251 1 0.0000 0.0000
PERF_SPLIT_8 160511 7919 1 0.0000 0.0000
PERF_SPLIT_9 155044 2766 1 0.0000 0.0000
PSTORNED 2042025 12129 1 0.0000 0.0000
SEMAPHORES 5 1 1 0.0000 100.0000
XQD_1000_1200 141250 41648 1 0.0000 0.0000
XQD_1000_3300 7060213 213427 1 0.0000 0.0000
XQD_1200_2000 12148377 161519 1 0.0000 0.0000
XQD_2000_3300 1184816 178808 1 0.0000 0.0000
XQD_2100_3300 838272 81637 1 0.0000 0.0000
XQD_3300_3400 8787098 171885 1 0.0000 0.0000
XQS_1000_1200 21130382 14675 1 0.0000 0.0000
XQS_1000_3300 9299614 232839 1 0.0000 0.0000
XQS_1200_2000 10949930 244418 1 0.0000 0.0000
XQS_2100_3300 9415713 237679 1 0.0000 0.0000
XQS_3300_3400 566843 3036 1 0.0000 0.0000

Record versions statistics, chart

Total records and versions, chart

Ratios versions / total_records and max_versions / total_versions

Database validation 


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

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

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

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

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