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

Hardware and OS info

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

Server and database settinfs 


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

Test configuration settings 

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

Test finish info 


FINISH_STATE                    NORMAL: TEST_TIME EXPIRED AT 2024-04-07 16:09:41
DTS_END                         2024-04-07 16:09:41.8090
FB_GDSCODE                      -1
FB_MNEMONA                      
STACK                           SP_ADD_INVOICE_TO_STOCK(190:30) ==> SP_CUSTOMER_RESERVE(47:5) ==> SP_CHECK_TO_STOP_WORK(32:12) ==> SP_HALT_ON_ERROR(57:17)
IP                              ::1/52192
TRN_ID                          172746
ATT_ID                          603
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: 8821.04 22157 882104
customer order: creation 169.51 356 16951
customer order: refuse 14.33 412 1433
order to supplier: creation 44.32 1254 4432
order to supplier: removal 3.29 115704 329
invoice (draft): creation 45.17 3609 4517
invoice (draft): removal 48.02 866 4802
invoice accept: apply 40.73 22425 4073
invoice accept: cancel 42.81 1032 4281
customer reserve: creation 3877.50 216 387750
customer reserve: removal 4254.58 71 425458
realization accept: apply 81.18 213 8118
realization accept: cancel 71.48 138 7148
payment from customer: creation 57.82 144 5782
payment from customer: removal 6.05 130 605
payment to supplier: creation 49.01 180 4901
payment to supplier: removal 3.25 91 325
service: total inventory turnovers 4.69 968 469
service: total monetary turnovers 6.41 26 641
service: aggregate perf. data 0.86 18150 86
service: refresh index statistics 0.03 277164 3

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:03, from 07-04-2024 16:11:05 to 07-04-2024 16:11:08.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 3924
TEST_TIME 2 4242
TEST_TIME 3 3190
TEST_TIME 4 3683
TEST_TIME 5 4251
TEST_TIME 6 4453
TEST_TIME 7 4834
TEST_TIME 8 5058
TEST_TIME 9 5184
TEST_TIME 10 5733
TEST_TIME 11 5474
TEST_TIME 12 5574
TEST_TIME 13 5915
TEST_TIME 14 5872
TEST_TIME 15 5873
TEST_TIME 16 5909
TEST_TIME 17 6048
TEST_TIME 18 6143
TEST_TIME 19 6359
TEST_TIME 20 6506
TEST_TIME 21 6708
TEST_TIME 22 7160
TEST_TIME 23 7110
TEST_TIME 24 7409
TEST_TIME 25 7407
TEST_TIME 26 7888
TEST_TIME 27 8289
TEST_TIME 28 8895
TEST_TIME 29 9086
TEST_TIME 30 9158
TEST_TIME 31 9015
TEST_TIME 32 8845
TEST_TIME 33 8899
TEST_TIME 34 8785
TEST_TIME 35 8678
TEST_TIME 36 8637
TEST_TIME 37 8704
TEST_TIME 38 8609
TEST_TIME 39 8578
TEST_TIME 40 8601
TEST_TIME 41 8631
TEST_TIME 42 8674
TEST_TIME 43 8664
TEST_TIME 44 8550
TEST_TIME 45 8568
TEST_TIME 46 8634
TEST_TIME 47 8643
TEST_TIME 48 8598
TEST_TIME 49 8645
TEST_TIME 50 8708
TEST_TIME 51 8684
TEST_TIME 52 8668
TEST_TIME 53 8795
TEST_TIME 54 8770
TEST_TIME 55 8723
TEST_TIME 56 8757
TEST_TIME 57 8806
TEST_TIME 58 8762
TEST_TIME 59 8939
TEST_TIME 60 8930
TEST_TIME 61 8794
TEST_TIME 62 8719
TEST_TIME 63 8820
TEST_TIME 64 8741
TEST_TIME 65 8752
TEST_TIME 66 8741
TEST_TIME 67 8674
TEST_TIME 68 8690
TEST_TIME 69 8609
TEST_TIME 70 8587
TEST_TIME 71 8627
TEST_TIME 72 8667
TEST_TIME 73 8678
TEST_TIME 74 8688
TEST_TIME 75 8678
TEST_TIME 76 8726
TEST_TIME 77 8729
TEST_TIME 78 8832
TEST_TIME 79 8902
TEST_TIME 80 8902
TEST_TIME 81 8913
TEST_TIME 82 8945
TEST_TIME 83 8907
TEST_TIME 84 8996
TEST_TIME 85 9021
TEST_TIME 86 8939
TEST_TIME 87 8898
TEST_TIME 88 8902
TEST_TIME 89 8851
TEST_TIME 90 8890
TEST_TIME 91 8859
TEST_TIME 92 8863
TEST_TIME 93 8815
TEST_TIME 94 8763
TEST_TIME 95 8719
TEST_TIME 96 8738
TEST_TIME 97 8746
TEST_TIME 98 8845
TEST_TIME 99 8802
TEST_TIME 100 8825

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:03, from 07-04-2024 16:11:09 to 07-04-2024 16:11:12.

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 1237409 1237409 0 0.00 0 31245 8 0 0
doc_list_biud 1237405 1237405 0 0.00 0 59068 30 0 0
sp_add_invoice_to_stock 4159 4073 86 2.06 56 219195 22426 0 86
sp_cancel_adding_invoice 4281 4281 0 0.00 3 101106 1033 0 0
sp_cancel_client_order 1433 1433 0 0.00 4 11178 412 0 0
sp_cancel_customer_reserve 425458 425458 0 0.00 0 59072 71 0 0
sp_cancel_pay_from_customer 605 605 0 0.00 2 10759 131 0 0
sp_cancel_pay_to_supplier 325 325 0 0.00 3 4591 92 0 0
sp_cancel_supplier_invoice 4808 4802 6 0.12 1 19715 866 0 6
sp_cancel_supplier_order 329 329 0 0.00 9 1229788 115704 0 0
sp_cancel_write_off 7148 7148 0 0.00 1 15046 138 0 0
sp_client_order 16951 16951 0 0.00 3 24705 357 0 0
sp_customer_reserve 387750 387750 0 0.00 0 42039 217 0 0
sp_fill_shopping_cart 25893 25893 0 0.00 1 16565 41 0 0
sp_fill_shopping_cart_clo_res 387746 387746 0 0.00 0 13092 16 0 0
sp_get_clo_for_invoice 4067 4067 0 0.00 0 26510 305 0 0
sp_kill_cost_storno 12359 12359 0 0.00 0 10456 73 0 0
sp_kill_qstorno_ret_qs2qd 863195 863195 0 0.00 0 59063 38 0 0
sp_kill_qty_storno 455636 455636 0 0.00 0 59068 82 0 0
sp_lock_selected_doc 16893 16893 0 0.00 0 8837 4 0 0
sp_make_cost_storno 22868 22868 0 0.00 0 21921 71 0 0
sp_multiply_rows_for_pdistr 22867 22867 0 0.00 0 11071 38 0 0
sp_multiply_rows_for_qdistr 16950 16950 0 0.00 0 12170 150 0 0
sp_pay_from_customer 5782 5782 0 0.00 4 25159 144 0 0
sp_pay_to_supplier 4901 4901 0 0.00 4 29781 180 0 0
sp_payment_common 10682 10682 0 0.00 2 12685 40 0 0
sp_qd_handle_on_cancel_clo 1433 1433 0 0.00 0 11171 374 0 0
sp_qd_handle_on_invoice_upd_sts 8348 8348 0 0.00 0 34219 385 0 0
sp_qd_handle_on_reserve_upd_sts 8118 8118 0 0.00 0 17005 67 0 0
sp_reserve_write_off 8118 8118 0 0.00 5 22042 213 0 0
sp_supplier_invoice 4517 4517 0 0.00 6 78775 3610 0 0
sp_supplier_order 4432 4432 0 0.00 5 26294 1254 0 0
srv_aggregate_perf_data 86 86 0 0.00 1948 251804 18151 0 0
srv_fill_mon_cache_memory 56 56 0 0.00 2377 126673 39654 0 0
srv_find_qd_qs_mism 840720 840720 0 0.00 0 31244 7 0 0
srv_make_invnt_saldo 469 469 0 0.00 40 20966 969 0 0
srv_make_money_saldo 641 641 0 0.00 0 722 27 0 0
srv_recalc_idx_stat 3 3 0 0.00 196156 436412 277164 0 0
t$perf-abend:sp_add_invoice_to_stock 86 86 0 0.00 0 0 0 0 0
t$perf-abend:sp_cancel_supplier_invoice 6 6 0 0.00 0 0 0 0 0
t$perf-norm:sp_add_invoice_to_stock 4073 4073 0 0.00 0 13038 189 0 0
t$perf-norm:sp_cancel_adding_invoice 310 310 0 0.00 0 9894 121 0 0
t$perf-norm:sp_cancel_client_order 1433 1433 0 0.00 0 3235 13 0 0
t$perf-norm:sp_cancel_customer_reserve 576 576 0 0.00 0 683 9 0 0
t$perf-norm:sp_cancel_pay_from_customer 605 605 0 0.00 0 203 2 0 0
t$perf-norm:sp_cancel_pay_to_supplier 325 325 0 0.00 0 1038 11 0 0
t$perf-norm:sp_cancel_supplier_invoice 332 332 0 0.00 0 4695 37 0 0
t$perf-norm:sp_cancel_supplier_order 329 329 0 0.00 0 24979 1752 0 0
t$perf-norm:sp_cancel_write_off 798 798 0 0.00 0 3098 18 0 0
t$perf-norm:sp_client_order 16951 16951 0 0.00 0 10194 20 0 0
t$perf-norm:sp_customer_reserve 812 812 0 0.00 0 2710 7 0 0
t$perf-norm:sp_pay_from_customer 5782 5782 0 0.00 0 3830 10 0 0
t$perf-norm:sp_pay_to_supplier 4901 4901 0 0.00 0 3132 7 0 0
t$perf-norm:sp_reserve_write_off 8118 8118 0 0.00 0 5566 11 0 0
t$perf-norm:sp_supplier_invoice 4517 4517 0 0.00 0 4710 20 0 0
t$perf-norm:sp_supplier_order 4432 4432 0 0.00 0 4897 18 0 0
t$perf-norm:srv_aggregate_perf_data 86 86 0 0.00 0 333 16 0 0
t$perf-norm:srv_fill_mon_cache_memory 56 56 0 0.00 0 57 2 0 0
t$perf-norm:srv_make_invnt_saldo 469 469 0 0.00 0 1188 30 0 0
t$perf-norm:srv_make_money_saldo 641 641 0 0.00 0 1046 24 0 0
t$perf-norm:srv_recalc_idx_stat 3 3 0 0.00 1 7 4 0 0
v_add_invoice_to_stock 8306 8134 172 2.07 0 5267 16 0 172
v_all_customers 30916 30916 0 0.00 0 69 1 0 0
v_all_suppliers 25686 25686 0 0.00 0 20 1 0 0
v_all_wares 33894 33894 0 0.00 0 45 1 0 0
v_cancel_adding_invoice 620 620 0 0.00 0 1003 12 0 0
v_cancel_client_order 2866 2866 0 0.00 0 5130 11 0 0
v_cancel_customer_prepayment 1210 1210 0 0.00 0 7754 15 0 0
v_cancel_customer_reserve 1152 1152 0 0.00 0 3208 6 0 0
v_cancel_payment_to_supplier 650 650 0 0.00 0 330 3 0 0
v_cancel_supplier_invoice 676 664 12 1.77 0 880 17 0 12
v_cancel_supplier_order 658 658 0 0.00 0 4668 18 0 0
v_cancel_write_off 1596 1596 0 0.00 0 1208 13 0 0
v_max_id_clo_ord 4430 4430 0 0.00 0 1680 2 0 0
v_max_id_clo_res 812 812 0 0.00 0 1555 10 0 0
v_max_id_ord_sup 4515 4515 0 0.00 0 5009 5 0 0
v_max_non_paid_invoice 1002 1002 0 0.00 0 3302 6 0 0
v_max_non_paid_realizn 2996 2996 0 0.00 0 8166 7 0 0
v_min_id_clo_ord 4430 4430 0 0.00 0 5742 10 0 0
v_min_id_clo_res 812 812 0 0.00 0 2946 7 0 0
v_min_id_ord_sup 4515 4515 0 0.00 0 4758 7 0 0
v_min_non_paid_invoice 4900 4900 0 0.00 0 11897 25 0 0
v_min_non_paid_realizn 5782 5782 0 0.00 0 11986 31 0 0
v_our_firm 8550 8550 0 0.00 0 17 1 0 0
v_reserve_write_off 16236 16236 0 0.00 0 6662 8 0 0
x_lock_depdocs_on_canc_invoice 8751 8751 0 0.00 0 21401 176 0 0
x_lock_depdocs_on_canc_sup_ord 329 329 0 0.00 0 28266 516 0 0
x_make_qstorno_1000_1200 4432 4432 0 0.00 2 26276 1171 0 0
x_make_qstorno_1200_2000 4517 4517 0 0.00 2 77900 3456 0 0
x_make_qstorno_2100_3300 387750 387750 0 0.00 0 42038 197 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 07-04-2024 16:11:13 to 07-04-2024 16:11:17.

Memory consumption, metadata cache, attachments activity 

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


Page cache type: shared, buffers: 1000000 for all connections, with total size: 8192000000
measurement_dts measurement duration ms page cache memo used memo used, total memo allocated, total metadata cache metadata cache percent of total total attachments cnt active attachments cnt running statements cnt stalled statements cnt memo used by attachments memo used by transactions memo used by statements
14:09:45 4 8192000000 8799009520 8810303488 5304288 0.064 2 1 2 0 5403888 56816 42784
14:10:46 18843 8192000000 9873966064 10180911104 968322400 10.570 100 86 171 0 996187136 5163808 22700928
14:12:20 22630 8192000000 9930663760 10250948608 1018633296 11.059 100 91 182 1 1050378256 7695488 24049472
14:13:52 7643 8192000000 9980601808 10311294976 1067308288 11.526 100 86 172 0 1097381616 8965808 21107520
14:15:15 5426 8192000000 10042401744 10387177472 1125282384 12.077 100 87 174 0 1156916960 10868064 20766512
14:16:25 8288 8192000000 10079768256 10436640768 1165914736 12.459 100 84 166 1 1197856736 12840624 19101376
14:17:35 3306 8192000000 10109286944 10475241472 1201631312 12.791 100 80 156 0 1231694560 12906336 17156912
14:18:40 1914 8192000000 10151885392 10523459584 1237952464 13.127 100 85 168 0 1269536128 12684176 18899488
14:19:45 1627 8192000000 10193303504 10575933440 1275771344 13.474 100 80 158 0 1306705216 13463760 17470112
14:20:48 1430 8192000000 10203279232 10587090944 1294446016 13.645 100 85 171 0 1327398768 13369632 19583120
14:21:52 27163 8192000000 10202270112 10610851840 1310053792 13.787 100 42 84 0 1327390896 7758592 9578512
14:23:20 6657 8192000000 10201967216 10619650048 1314832240 13.830 100 22 44 0 1330000448 9985680 5182528
14:24:27 7521 8192000000 10206923184 10625146880 1322643408 13.901 100 19 38 0 1333154544 6205920 4305216
14:25:37 73237 8192000000 10220710592 10646609920 1318929200 13.867 99 32 64 0 1331931056 5678256 7323600
14:27:55 8683 8192000000 10219279152 10646003712 1322739920 13.902 99 17 34 1 1332118048 5721104 3657024
14:29:05 5663 8192000000 10217991952 10636664832 1330611904 13.973 100 19 38 1 1339778768 4921360 4245504
14:30:18 11918 8192000000 10237314576 10637688832 1323964768 13.913 100 56 111 1 1345012848 8325232 12722848
14:31:34 18679 8192000000 10244508816 10655997952 1337978672 14.039 100 41 81 1 1357216384 10009808 9227904
14:32:55 18548 8192000000 10234695760 10648969216 1321191696 13.887 99 43 86 0 1344348368 12983680 10172992
14:34:20 35347 8192000000 10222973728 10635780096 1315981536 13.840 100 35 70 0 1335773312 11755872 8035904
14:35:58 42007 8192000000 10233904000 10644377600 1302541472 13.718 98 52 103 0 1330867664 17072880 11253312
14:37:53 19563 8192000000 10204072176 10596589568 1263631312 13.363 98 58 117 0 1300345488 22908432 13805744
14:39:17 5248 8192000000 10213917680 10611220480 1298009440 13.677 100 56 106 2 1331750384 21771952 11968992
14:40:33 19588 8192000000 10235143312 10634424320 1316586208 13.846 100 52 103 0 1350019888 21832304 11601376
14:41:58 6044 8192000000 10239752736 10641453056 1304668384 13.738 99 48 96 0 1340792224 24182128 11941712
14:43:14 8316 8192000000 10257165296 10668044288 1336380576 14.025 100 43 85 0 1370977952 23847440 10749936
14:44:35 6434 8192000000 10285188064 10687127552 1354297280 14.186 100 61 119 0 1396899680 27907344 14695056
14:45:51 3979 8192000000 10300154992 10696765440 1358277472 14.222 100 67 129 0 1403326752 28743728 16305552
14:47:00 2547 8192000000 10319955568 10716160000 1372672640 14.351 100 87 169 3 1426984688 33192048 21120000
14:48:08 8596 8192000000 10326364064 10732269568 1377643680 14.395 100 73 144 0 1432433344 37399456 17390208
14:49:22 4809 8192000000 10340741328 10747166720 1389660480 14.503 100 76 150 0 1445025456 37002784 18362192
14:50:30 2374 8192000000 10354950528 10761056256 1389218960 14.499 99 80 159 2 1448479456 39794480 19466016
14:51:37 5164 8192000000 10337602624 10758426624 1393564384 14.538 100 50 100 0 1446841088 40350064 12926640
14:52:59 6309 8192000000 10355580512 10776903680 1404251680 14.633 100 52 104 1 1459932672 41908272 13772720
14:54:10 2770 8192000000 10344475200 10783051776 1400299760 14.598 100 36 73 3 1454106608 43532592 10274256
14:55:21 23494 8192000000 10340865424 10780979200 1401518640 14.609 100 27 54 0 1456227344 46053040 8655664
14:56:53 15867 8192000000 10322945888 10771034112 1381910880 14.434 99 28 56 0 1435220272 45926720 7382672
14:58:12 9037 8192000000 10313088960 10744336384 1383727568 14.450 100 41 83 1 1416692896 23461616 9503712
14:59:24 8794 8192000000 10307711504 10749231104 1396491232 14.564 100 34 68 0 1419234672 14924864 7818576
15:00:39 91137 8192000000 10309185360 10753785856 1382528080 14.439 99 37 74 1 1408788576 17318192 8942304
15:03:42 18886 8192000000 10311855792 10751107072 1394217536 14.543 100 52 103 0 1416752976 10114928 12420512
15:05:04 81899 8192000000 10330225264 10781614080 1409062032 14.676 100 29 58 1 1441281568 24936304 7283232
15:07:39 70695 8192000000 10325495696 10772320256 1410084576 14.685 100 21 43 0 1433077808 17730064 5263168
15:09:50 70853 8192000000 10314205792 10774188032 1394135584 14.543 99 13 26 0 1414080960 16964448 2980928
15:12:01 68127 8192000000 10294958848 10759954432 1402933200 14.621 100 16 32 0 1415337648 8569840 3834608
15:14:40 59578 8192000000 10300653536 10762477568 1375425472 14.376 98 21 42 1 1394867568 14707824 4734272
15:17:08 22374 8192000000 10321860288 10763849728 1391894528 14.523 99 53 105 0 1411141168 6722912 12523728
15:18:30 87795 8192000000 10269862640 10729910272 1290784688 13.611 92 15 30 0 1306145248 11557840 3802720
15:21:15 42703 8192000000 10290707280 10733056000 1335937600 14.021 96 38 76 0 1358107744 13444928 8725216
15:23:00 63967 8192000000 10297802336 10730188800 1338914944 14.048 97 31 62 2 1354790624 9101184 6774496
15:25:06 27796 8192000000 10275644880 10715701248 1350846896 14.155 100 39 79 1 1370509424 11551616 8110912
15:26:36 56838 8192000000 10265205472 10700603392 1276323568 13.479 93 26 52 0 1299071216 17273216 5474432
15:28:33 126672 8192000000 10274569312 10727071744 1318740464 13.865 97 14 28 0 1346440144 24723536 2976144
15:32:08 84308 8192000000 10232562432 10677587968 1281244512 13.524 95 11 22 0 1295718192 12261152 2212528
15:34:34 68644 8192000000 10217244208 10663882752 1317837104 13.857 98 23 47 0 1333512608 10143856 5531648
15:36:43 60593 8192000000 10223118544 10672742400 1282577760 13.537 95 9 18 0 1299180096 14033856 2568480
15:38:44 63027 8192000000 10248265664 10695454720 1342504528 14.080 100 13 26 0 1356855008 11902256 2448224
15:40:47 100254 8192000000 10264775232 10704834560 1313082000 13.814 96 11 22 0 1330279088 14950928 2246160
15:43:41 30917 8192000000 10285365008 10725629952 1367273936 14.303 100 37 74 0 1387630256 12131648 8224672
15:45:18 64935 8192000000 10284892016 10730868736 1360840368 14.245 99 16 31 2 1376913136 12791184 3281584
15:48:21 72861 8192000000 10299076768 10754080768 1375984112 14.381 99 14 28 0 1399881456 20806672 3090672
15:50:35 36254 8192000000 10278297200 10727686144 1359967856 14.237 98 12 24 1 1369959840 7599472 2392512
15:52:12 39831 8192000000 10318362432 10755506176 1384674912 14.458 100 33 66 0 1404423936 12637616 7111408
15:54:06 46851 8192000000 10290410304 10740301824 1372366768 14.348 99 26 52 0 1394866336 16856144 5643424
15:56:00 100730 8192000000 10297550976 10755682304 1376838096 14.388 99 26 52 0 1392334784 9697408 5799280
15:58:50 11304 8192000000 10311224752 10757799936 1401250016 14.606 100 52 105 0 1424186496 10177456 12759024
16:00:01 50423 8192000000 10291159632 10762289152 1384630960 14.458 99 7 14 0 1400663392 14466528 1565904
16:01:56 21918 8192000000 10282238832 10725085184 1350420528 14.151 97 33 64 2 1366238080 7983808 7833744
16:03:21 78323 8192000000 10292001904 10747236352 1376299232 14.383 99 29 58 0 1399913472 16794464 6819776
16:05:56 54806 8192000000 10271652496 10731655168 1315356336 13.835 95 11 22 1 1336406592 18172000 2878256
16:07:52 38932 8192000000 10268687072 10719064064 1327214672 13.942 96 11 20 1 1337252592 7223744 2814176
16:09:36 20902 8192000000 9060297760 9264828416 232248448 2.756 17 4 8 0 236476752 3555776 672528

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:14, from 07-04-2024 16:11:19 to 07-04-2024 16:11:33.

Exceptions occured during test was in run

FB_MNEMONA CNT UNIT FB_GDSCODE
except 86 v_add_invoice_to_stock 335544517
except 6 v_cancel_supplier_invoice 335544517

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

Content of mon$database and FB version 


MON$DATABASE_NAME               /home/bases/oltp30-etalone.fdb
MON$PAGE_SIZE                   8192
MON$ODS_MAJOR                   12
MON$ODS_MINOR                   0
MON$OLDEST_TRANSACTION          173055
MON$OLDEST_ACTIVE               173056
MON$OLDEST_SNAPSHOT             173056
MON$NEXT_TRANSACTION            173056
MON$PAGE_BUFFERS                1000000
MON$SQL_DIALECT                 3
MON$SHUTDOWN_MODE               0
MON$SWEEP_INTERVAL              0
MON$READ_ONLY                   0
MON$FORCED_WRITES               1
MON$RESERVE_SPACE               1
MON$CREATION_DATE               2020-04-03 16:41:55.3470
MON$PAGES                       1889216
MON$STAT_ID                     1
MON$BACKUP_STATE                0
MON$CRYPT_PAGE                  0
MON$OWNER                       SYSDBA                                                                                       
MON$SEC_DATABASE                Default


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

Database statistics 

 
Database "/home/bases/oltp30-etalone.fdb" 
Gstat execution time Sun Apr  7 16:11:37 2024 
 
Database header page information: 
    Flags            0 
    Generation        90209 
    System Change Number    0 
    Page size        8192 
    ODS version        12.0 
    Oldest transaction    173055 
    Oldest active        173056 
    Oldest snapshot        173056 
    Next transaction    173057 
    Sequence number        0 
    Next attachment ID    705 
    Implementation        HW=AMD/Intel/x64 little-endian OS=Linux CC=gcc 
    Shadow count        0 
    Page buffers        0 
    Next header page    0 
    Database dialect    3 
    Creation date        Apr 3, 2020 16:41:55 
    Attributes        force write 
 
    Variable header data: 
    Sweep interval:        0 
    Unrecognized option 11, length 16 
    *END* 
 
 
Database file sequence: 
File /home/bases/oltp30-etalone.fdb is the only file 
 
Analyzing database pages ... 
AGENTS (150) 
    Primary pointer page: 496, Index root page: 497 
    Total formats: 1, used formats: 1 
    Average record length: 33.60, total records: 50 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 344.00, compression ratio: 10.24 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 31% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 1 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index AGENTS_ID_DESC (2) 
    Root page: 1504311, depth: 1, leaf buckets: 1, nodes: 50 
    Average node length: 11.82, total dup: 0, max dup: 0 
    Average key length: 10.80, compression ratio: 0.83 
    Average prefix length: 1.18, average data length: 7.82 
    Clustering factor: 1, ratio: 0.02 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index AGENTS_IS_OUR_FIRM (4) 
    Root page: 1504313, depth: 1, leaf buckets: 1, nodes: 50 
    Average node length: 3.08, total dup: 48, max dup: 48 
    Average key length: 2.04, compression ratio: 0.50 
    Average prefix length: 0.96, average data length: 0.06 
    Clustering factor: 1, ratio: 0.02 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index AGENTS_IS_SUPPLIER (3) 
    Root page: 1504312, depth: 1, leaf buckets: 1, nodes: 50 
    Average node length: 3.08, total dup: 48, max dup: 44 
    Average key length: 2.04, compression ratio: 0.54 
    Average prefix length: 1.04, average data length: 0.06 
    Clustering factor: 1, ratio: 0.02 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index AGENTS_NAME_UNQ (1) 
    Root page: 1504310, depth: 1, leaf buckets: 1, nodes: 50 
    Average node length: 17.20, total dup: 0, max dup: 0 
    Average key length: 15.88, compression ratio: 0.92 
    Average prefix length: 1.42, average data length: 13.20 
    Clustering factor: 1, ratio: 0.02 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PK_AGENTS (0) 
    Root page: 1504309, depth: 1, leaf buckets: 1, nodes: 50 
    Average node length: 11.82, total dup: 0, max dup: 0 
    Average key length: 10.80, compression ratio: 0.83 
    Average prefix length: 1.18, average data length: 7.82 
    Clustering factor: 1, ratio: 0.02 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
BUSINESS_OPS (154) 
    Primary pointer page: 504, Index root page: 505 
    Total formats: 1, used formats: 1 
    Average record length: 108.20, total records: 20 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1235.00, compression ratio: 11.41 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 31% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 1 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index BO_UNIT_UNQ (1) 
    Root page: 1504242, depth: 1, leaf buckets: 1, nodes: 20 
    Average node length: 18.25, total dup: 0, max dup: 0 
    Average key length: 17.20, compression ratio: 1.24 
    Average prefix length: 7.05, average data length: 14.25 
    Clustering factor: 1, ratio: 0.05 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index BUSINESS_OPS_PREDICT_PRIOR (3) 
    Root page: 1504244, depth: 1, leaf buckets: 1, nodes: 20 
    Average node length: 5.40, total dup: 0, max dup: 0 
    Average key length: 4.35, compression ratio: 0.67 
    Average prefix length: 1.20, average data length: 1.70 
    Clustering factor: 1, ratio: 0.05 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index BUSINESS_OPS_RND_WGTH (2) 
    Root page: 1504243, depth: 1, leaf buckets: 1, nodes: 20 
    Average node length: 4.30, total dup: 6, max dup: 3 
    Average key length: 3.25, compression ratio: 0.72 
    Average prefix length: 1.35, average data length: 1.00 
    Clustering factor: 1, ratio: 0.05 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index RDB$1 (0) 
    Root page: 1504241, depth: 1, leaf buckets: 1, nodes: 20 
    Average node length: 5.20, total dup: 0, max dup: 0 
    Average key length: 4.15, compression ratio: 0.65 
    Average prefix length: 1.10, average data length: 1.60 
    Clustering factor: 1, ratio: 0.05 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
DOC_DATA (139) 
    Primary pointer page: 474, Index root page: 475 
    Total formats: 1, used formats: 1 
    Average record length: 47.36, total records: 7746959 
    Average version length: 48.16, total versions: 85437, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 64.00, compression ratio: 1.35 
    Pointer pages: 54, data page slots: 86584 
    Data pages: 86584, average fill: 71% 
    Primary pages: 86584, secondary pages: 0, swept pages: 18766 
    Empty pages: 3, full pages: 65017 
    Fill distribution: 
     0 - 19% = 16 
    20 - 39% = 135 
    40 - 59% = 1841 
    60 - 79% = 84567 
    80 - 99% = 25 
 
    Index DOC_DATA_DOC_WARE_UNQ (0) 
    Root page: 1510614, depth: 3, leaf buckets: 23141, nodes: 7746959 
    Average node length: 18.89, total dup: 0, max dup: 0 
    Average key length: 15.90, compression ratio: 1.70 
    Average prefix length: 14.10, average data length: 12.90 
    Clustering factor: 1721643, ratio: 0.22 
    Fill distribution: 
         0 - 19% = 329 
        20 - 39% = 1715 
        40 - 59% = 4041 
        60 - 79% = 2382 
        80 - 99% = 14674 
 
    Index DOC_DATA_ID_DESC (1) 
    Root page: 1528118, depth: 3, leaf buckets: 13444, nodes: 7746959 
    Average node length: 11.20, total dup: 0, max dup: 0 
    Average key length: 8.21, compression ratio: 1.10 
    Average prefix length: 3.79, average data length: 5.21 
    Clustering factor: 1544424, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 1520 
        40 - 59% = 2002 
        60 - 79% = 1123 
        80 - 99% = 8799 
 
    Index FK_DOC_DATA_DOC_LIST (2) 
    Root page: 1546711, depth: 3, leaf buckets: 8264, nodes: 7746959 
    Average node length: 6.62, total dup: 5792346, max dup: 49 
    Average key length: 3.63, compression ratio: 2.48 
    Average prefix length: 7.62, average data length: 1.38 
    Clustering factor: 1537426, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 101 
        20 - 39% = 925 
        40 - 59% = 1352 
        60 - 79% = 919 
        80 - 99% = 4967 
 
DOC_LIST (138) 
    Primary pointer page: 472, Index root page: 473 
    Total formats: 1, used formats: 1 
    Average record length: 56.31, total records: 2245221 
    Average version length: 34.62, total versions: 87964, max versions: 3 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 84.00, compression ratio: 1.49 
    Pointer pages: 18, data page slots: 28312 
    Data pages: 28312, average fill: 73% 
    Primary pages: 28306, secondary pages: 6, swept pages: 10323 
    Empty pages: 3, full pages: 20156 
    Fill distribution: 
     0 - 19% = 18 
    20 - 39% = 58 
    40 - 59% = 1245 
    60 - 79% = 26336 
    80 - 99% = 655 
 
    Index DOC_LIST_ID_DESC (1) 
    Root page: 1541130, depth: 3, leaf buckets: 4525, nodes: 2245221 
    Average node length: 11.41, total dup: 0, max dup: 0 
    Average key length: 8.44, compression ratio: 1.07 
    Average prefix length: 3.55, average data length: 5.45 
    Clustering factor: 698345, ratio: 0.31 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 869 
        40 - 59% = 848 
        60 - 79% = 712 
        80 - 99% = 2096 
 
    Index DOC_LIST_WORKER_OPTYPE (2) 
    Root page: 1544376, depth: 3, leaf buckets: 2508, nodes: 2247494 
    Average node length: 4.97, total dup: 2246595, max dup: 18272 
    Average key length: 2.01, compression ratio: 4.47 
    Average prefix length: 8.99, average data length: 0.01 
    Clustering factor: 1245495, ratio: 0.55 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 266 
        40 - 59% = 1478 
        60 - 79% = 571 
        80 - 99% = 192 
 
    Index FK_DOC_LIST_AGENTS (3) 
    Root page: 1545909, depth: 3, leaf buckets: 1998, nodes: 2245221 
    Average node length: 4.97, total dup: 2245171, max dup: 130323 
    Average key length: 2.01, compression ratio: 4.48 
    Average prefix length: 8.99, average data length: 0.01 
    Clustering factor: 1058067, ratio: 0.47 
    Fill distribution: 
         0 - 19% = 3 
        20 - 39% = 33 
        40 - 59% = 1052 
        60 - 79% = 50 
        80 - 99% = 860 
 
    Index PK_DOC_LIST (0) 
    Root page: 1538187, depth: 3, leaf buckets: 4337, nodes: 2245221 
    Average node length: 11.41, total dup: 0, max dup: 0 
    Average key length: 8.44, compression ratio: 1.07 
    Average prefix length: 3.55, average data length: 5.45 
    Clustering factor: 698345, ratio: 0.31 
    Fill distribution: 
         0 - 19% = 106 
        20 - 39% = 552 
        40 - 59% = 640 
        60 - 79% = 828 
        80 - 99% = 2211 
 
DOC_STATES (149) 
    Primary pointer page: 494, Index root page: 495 
    Total formats: 1, used formats: 1 
    Average record length: 67.50, total records: 4 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 650.00, compression ratio: 9.63 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 4% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index DOC_STATES_MCODE_UNQ (1) 
    Root page: 1504315, depth: 1, leaf buckets: 1, nodes: 4 
    Average node length: 17.75, total dup: 0, max dup: 0 
    Average key length: 16.50, compression ratio: 1.08 
    Average prefix length: 4.00, average data length: 13.75 
    Clustering factor: 1, ratio: 0.25 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index DOC_STATES_NAME_UNQ (2) 
    Root page: 1504316, depth: 1, leaf buckets: 1, nodes: 4 
    Average node length: 33.25, total dup: 0, max dup: 0 
    Average key length: 32.00, compression ratio: 0.99 
    Average prefix length: 2.50, average data length: 29.25 
    Clustering factor: 1, ratio: 0.25 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PK_DOC_STATES (0) 
    Root page: 1504314, depth: 1, leaf buckets: 1, nodes: 4 
    Average node length: 4.75, total dup: 0, max dup: 0 
    Average key length: 3.50, compression ratio: 0.86 
    Average prefix length: 1.50, average data length: 1.50 
    Clustering factor: 1, ratio: 0.25 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
FB_ERRORS (155) 
    Primary pointer page: 506, Index root page: 507 
    Total formats: 2, used formats: 2 
    Average record length: 54.76, total records: 2182 
    Average version length: 79.61, total versions: 757, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 270.43, compression ratio: 4.94 
    Pointer pages: 1, data page slots: 40 
    Data pages: 40, average fill: 70% 
    Primary pages: 40, secondary pages: 0, swept pages: 0 
    Empty pages: 7, full pages: 32 
    Fill distribution: 
     0 - 19% = 7 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 7 
    80 - 99% = 26 
 
    Index FB_ERRORS_GDS_CODE (0) 
    Root page: 382, depth: 2, leaf buckets: 2, nodes: 2182 
    Average node length: 4.40, total dup: 756, max dup: 1 
    Average key length: 2.67, compression ratio: 1.87 
    Average prefix length: 4.33, average data length: 0.67 
    Clustering factor: 1515, ratio: 0.69 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 0 
        40 - 59% = 1 
        60 - 79% = 1 
        80 - 99% = 0 
 
INVNT_SALDO (145) 
    Primary pointer page: 486, Index root page: 487 
    Total formats: 2, used formats: 1 
    Average record length: 82.56, total records: 400 
    Average version length: 22.69, total versions: 235652, max versions: 618 
    Average fragment length: 2.00, total fragments: 41, max fragments: 1 
    Average unpacked length: 104.00, compression ratio: 1.26 
    Pointer pages: 1, data page slots: 1472 
    Data pages: 1304, average fill: 89% 
    Primary pages: 17, secondary pages: 1287, swept pages: 0 
    Empty pages: 10, full pages: 1292 
    Fill distribution: 
     0 - 19% = 11 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 2 
    80 - 99% = 1291 
 
    Index PK_INVNT_SALDO (0) 
    Root page: 1510349, depth: 1, leaf buckets: 1, nodes: 400 
    Average node length: 11.22, total dup: 0, max dup: 0 
    Average key length: 10.22, compression ratio: 0.88 
    Average prefix length: 1.78, average data length: 7.22 
    Clustering factor: 326, ratio: 0.81 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 0 
        40 - 59% = 1 
        60 - 79% = 0 
        80 - 99% = 0 
 
INVNT_TURNOVER_LOG (153) 
    Primary pointer page: 502, Index root page: 503 
    Total formats: 1, used formats: 1 
    Average record length: 18.95, total records: 96562 
    Average version length: 68.30, total versions: 69783, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 88.00, compression ratio: 4.64 
    Pointer pages: 7, data page slots: 2360 
    Data pages: 1992, average fill: 59% 
    Primary pages: 1991, secondary pages: 1, swept pages: 0 
    Empty pages: 275, full pages: 988 
    Fill distribution: 
     0 - 19% = 400 
    20 - 39% = 174 
    40 - 59% = 232 
    60 - 79% = 385 
    80 - 99% = 801 
 
    Index INVNT_TURNOVER_LOG_WARE_DD_ID (0) 
    Root page: 1705709, depth: 3, leaf buckets: 297, nodes: 96562 
    Average node length: 13.04, total dup: 8049, max dup: 1 
    Average key length: 10.60, compression ratio: 2.55 
    Average prefix length: 19.31, average data length: 7.69 
    Clustering factor: 70009, ratio: 0.73 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 63 
        40 - 59% = 140 
        60 - 79% = 90 
        80 - 99% = 4 
 
MONEY_SALDO (141) 
    Primary pointer page: 478, Index root page: 479 
    Total formats: 1, used formats: 1 
    Average record length: 15.29, total records: 49 
    Average version length: 9.00, total versions: 17681, max versions: 924 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 32.00, compression ratio: 2.09 
    Pointer pages: 1, data page slots: 64 
    Data pages: 64, average fill: 89% 
    Primary pages: 2, secondary pages: 62, swept pages: 0 
    Empty pages: 1, full pages: 62 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 6 
    80 - 99% = 57 
 
    Index PK_MONEY_SALDO (0) 
    Root page: 1510361, depth: 1, leaf buckets: 1, nodes: 49 
    Average node length: 11.82, total dup: 0, max dup: 0 
    Average key length: 10.80, compression ratio: 0.83 
    Average prefix length: 1.18, average data length: 7.82 
    Clustering factor: 1, ratio: 0.02 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
MONEY_TURNOVER_LOG (140) 
    Primary pointer page: 476, Index root page: 477 
    Total formats: 1, used formats: 1 
    Average record length: 5.21, total records: 1460 
    Average version length: 43.64, total versions: 1291, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 58.00, compression ratio: 11.14 
    Pointer pages: 1, data page slots: 32 
    Data pages: 31, average fill: 45% 
    Primary pages: 30, secondary pages: 1, swept pages: 0 
    Empty pages: 8, full pages: 9 
    Fill distribution: 
     0 - 19% = 11 
    20 - 39% = 2 
    40 - 59% = 5 
    60 - 79% = 6 
    80 - 99% = 7 
 
    Index MONEY_TURNOVER_LOG_AGENT_OPTYPE (0) 
    Root page: 89021, depth: 2, leaf buckets: 2, nodes: 1460 
    Average node length: 4.31, total dup: 1364, max dup: 190 
    Average key length: 2.71, compression ratio: 7.02 
    Average prefix length: 18.36, average data length: 0.64 
    Clustering factor: 758, ratio: 0.52 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 1 
        40 - 59% = 1 
        60 - 79% = 0 
        80 - 99% = 0 
 
MON_CACHE_MEMORY (165) 
    Primary pointer page: 526, Index root page: 527 
    Total formats: 2, used formats: 1 
    Average record length: 97.28, total records: 72 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 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% = 1 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 1 
 
    Index PK_MON_CACHE_MEMORY (0) 
    Root page: 1504215, depth: 1, leaf buckets: 1, nodes: 72 
    Average node length: 11.69, total dup: 0, max dup: 0 
    Average key length: 10.68, compression ratio: 0.84 
    Average prefix length: 1.31, average data length: 7.69 
    Clustering factor: 2, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
MON_LOG (162) 
    Primary pointer page: 520, Index root page: 521 
    Total formats: 2, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index MON_LOG_DTS (4) 
    Root page: 1504229, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index MON_LOG_GDSCODE (2) 
    Root page: 1504227, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index MON_LOG_ROWSET_DESC (1) 
    Root page: 1504226, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index MON_LOG_UNIT (3) 
    Root page: 1504228, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PK_MON_LOG (0) 
    Root page: 1504225, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
MON_LOG_TABLE_STATS (163) 
    Primary pointer page: 522, Index root page: 523 
    Total formats: 2, used formats: 1 
    Average record length: 67.13, total records: 30 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 611.00, compression ratio: 9.10 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 31% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 1 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index MON_LOG_TABLE_STATS_DTS (4) 
    Root page: 1504224, depth: 1, leaf buckets: 1, nodes: 30 
    Average node length: 3.50, total dup: 23, max dup: 4 
    Average key length: 2.47, compression ratio: 3.24 
    Average prefix length: 7.53, average data length: 0.47 
    Clustering factor: 1, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index MON_LOG_TABLE_STATS_GDSCODE (2) 
    Root page: 1504222, depth: 1, leaf buckets: 1, nodes: 30 
    Average node length: 2.00, total dup: 29, max dup: 29 
    Average key length: 1.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 1, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index MON_LOG_TABLE_STATS_ROWSET (1) 
    Root page: 1504221, depth: 1, leaf buckets: 1, nodes: 30 
    Average node length: 3.33, total dup: 29, max dup: 29 
    Average key length: 2.30, compression ratio: 3.91 
    Average prefix length: 8.70, average data length: 0.30 
    Clustering factor: 1, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index MON_LOG_TABLE_STATS_TN_UNIT (3) 
    Root page: 1504223, depth: 1, leaf buckets: 1, nodes: 30 
    Average node length: 12.90, total dup: 0, max dup: 0 
    Average key length: 11.87, compression ratio: 1.42 
    Average prefix length: 7.63, average data length: 9.20 
    Clustering factor: 1, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PK_MON_LOG_TABLE_STATS (0) 
    Root page: 1504220, depth: 1, leaf buckets: 1, nodes: 30 
    Average node length: 8.37, total dup: 0, max dup: 0 
    Average key length: 7.33, compression ratio: 1.23 
    Average prefix length: 4.63, average data length: 4.37 
    Clustering factor: 1, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
OPTYPES (136) 
    Primary pointer page: 468, Index root page: 469 
    Total formats: 2, used formats: 1 
    Average record length: 67.56, total records: 9 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 386.00, compression ratio: 5.71 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 9% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index OPTYPES_MCODE_UNQ (1) 
    Root page: 1544805, depth: 1, leaf buckets: 1, nodes: 9 
    Average node length: 8.56, total dup: 0, max dup: 0 
    Average key length: 6.89, compression ratio: 0.73 
    Average prefix length: 0.44, average data length: 4.56 
    Clustering factor: 1, ratio: 0.11 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PK_OPTYPES (0) 
    Root page: 1544804, depth: 1, leaf buckets: 1, nodes: 9 
    Average node length: 6.11, total dup: 0, max dup: 0 
    Average key length: 5.00, compression ratio: 0.60 
    Average prefix length: 0.89, average data length: 2.11 
    Clustering factor: 1, ratio: 0.11 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
PDISTR (146) 
    Primary pointer page: 488, Index root page: 489 
    Total formats: 1, used formats: 1 
    Average record length: 36.20, total records: 795316 
    Average version length: 25.32, total versions: 64080, max versions: 4 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 54.00, compression ratio: 1.49 
    Pointer pages: 5, data page slots: 8088 
    Data pages: 8072, average fill: 69% 
    Primary pages: 8041, secondary pages: 31, swept pages: 1717 
    Empty pages: 91, full pages: 7169 
    Fill distribution: 
     0 - 19% = 213 
    20 - 39% = 185 
    40 - 59% = 184 
    60 - 79% = 7192 
    80 - 99% = 298 
 
    Index PDISTR_AGENT_ID (2) 
    Root page: 1509308, depth: 2, leaf buckets: 897, nodes: 795316 
    Average node length: 4.87, total dup: 795267, max dup: 156361 
    Average key length: 2.01, compression ratio: 4.48 
    Average prefix length: 8.99, average data length: 0.01 
    Clustering factor: 88425, ratio: 0.11 
    Fill distribution: 
         0 - 19% = 4 
        20 - 39% = 143 
        40 - 59% = 509 
        60 - 79% = 199 
        80 - 99% = 42 
 
    Index PDISTR_SNDOP_RCVOP_SNDID_ASC (0) 
    Root page: 1508613, depth: 3, leaf buckets: 882, nodes: 795316 
    Average node length: 5.87, total dup: 708103, max dup: 42 
    Average key length: 3.02, compression ratio: 7.29 
    Average prefix length: 21.09, average data length: 0.91 
    Clustering factor: 159137, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 97 
        40 - 59% = 310 
        60 - 79% = 126 
        80 - 99% = 348 
 
    Index PDISTR_SNDOP_RCVOP_SNDID_DESC (1) 
    Root page: 1509187, depth: 3, leaf buckets: 928, nodes: 795316 
    Average node length: 5.88, total dup: 708103, max dup: 42 
    Average key length: 3.02, compression ratio: 7.29 
    Average prefix length: 21.09, average data length: 0.91 
    Clustering factor: 161121, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 193 
        40 - 59% = 288 
        60 - 79% = 99 
        80 - 99% = 348 
 
    Index PDISTR_WORKER_SND_ID (3) 
    Root page: 1510178, depth: 3, leaf buckets: 1136, nodes: 795316 
    Average node length: 5.96, total dup: 708103, max dup: 42 
    Average key length: 3.10, compression ratio: 5.48 
    Average prefix length: 16.01, average data length: 0.99 
    Clustering factor: 153428, ratio: 0.19 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 252 
        40 - 59% = 604 
        60 - 79% = 190 
        80 - 99% = 89 
 
PERF_AGG (158) 
    Primary pointer page: 512, Index root page: 513 
    Total formats: 1, used formats: 1 
    Average record length: 62.80, total records: 5420 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 2.51, total fragments: 73, max fragments: 1 
    Average unpacked length: 379.00, compression ratio: 6.04 
    Pointer pages: 1, data page slots: 96 
    Data pages: 94, average fill: 57% 
    Primary pages: 75, secondary pages: 19, swept pages: 51 
    Empty pages: 13, full pages: 63 
    Fill distribution: 
     0 - 19% = 23 
    20 - 39% = 1 
    40 - 59% = 2 
    60 - 79% = 68 
    80 - 99% = 0 
 
    Index PERF_AGG_UNQ (1) 
    Root page: 1504238, depth: 2, leaf buckets: 6, nodes: 5420 
    Average node length: 5.49, total dup: 0, max dup: 0 
    Average key length: 3.59, compression ratio: 10.00 
    Average prefix length: 34.34, average data length: 1.55 
    Clustering factor: 5204, ratio: 0.96 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 0 
        40 - 59% = 4 
        60 - 79% = 1 
        80 - 99% = 1 
 
    Index PK_PERF_AGG (0) 
    Root page: 1504233, depth: 2, leaf buckets: 10, nodes: 5420 
    Average node length: 11.11, total dup: 0, max dup: 0 
    Average key length: 9.21, compression ratio: 0.98 
    Average prefix length: 2.79, average data length: 6.21 
    Clustering factor: 151, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 1 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 7 
 
PERF_ESTIMATED (280) 
    Primary pointer page: 1504218, Index root page: 1504219 
    Total formats: 1, used formats: 1 
    Average record length: 39.14, total records: 79304 
    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: 768 
    Data pages: 768, average fill: 71% 
    Primary pages: 768, secondary pages: 0, swept pages: 0 
    Empty pages: 3, full pages: 764 
    Fill distribution: 
     0 - 19% = 3 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 765 
    80 - 99% = 0 
 
    Index PK_PERF_ESTIMATED (0) 
    Root page: 32997, depth: 2, leaf buckets: 101, nodes: 79304 
    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: 3454, ratio: 0.04 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 100 
 
PERF_ISQL_STAT (156) 
    Primary pointer page: 508, Index root page: 509 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index PERF_ISQL_STAT_TRN (0) 
    Root page: 1504239, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
PERF_LOG (159) 
    Primary pointer page: 514, Index root page: 515 
    Total formats: 1, used formats: 1 
    Average record length: 111.12, total records: 72 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1691.00, compression ratio: 15.22 
    Pointer pages: 1, data page slots: 2 
    Data pages: 2, average fill: 57% 
    Primary pages: 2, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 1 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 1 
    40 - 59% = 0 
    60 - 79% = 1 
    80 - 99% = 0 
 
PERF_SPLIT_0 (281) 
    Primary pointer page: 573, Index root page: 574 
    Total formats: 1, used formats: 1 
    Average record length: 138.64, total records: 182778 
    Average version length: 154.43, total versions: 14812, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 12.23 
    Pointer pages: 7, data page slots: 5152 
    Data pages: 4408, average fill: 86% 
    Primary pages: 4408, secondary pages: 0, swept pages: 4 
    Empty pages: 58, full pages: 4321 
    Fill distribution: 
     0 - 19% = 63 
    20 - 39% = 3 
    40 - 59% = 17 
    60 - 79% = 4 
    80 - 99% = 4321 
 
PERF_SPLIT_1 (282) 
    Primary pointer page: 576, Index root page: 577 
    Total formats: 1, used formats: 1 
    Average record length: 147.02, total records: 179790 
    Average version length: 151.21, total versions: 4749, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.54 
    Pointer pages: 7, data page slots: 5696 
    Data pages: 4296, average fill: 86% 
    Primary pages: 4296, secondary pages: 0, swept pages: 1 
    Empty pages: 30, full pages: 4254 
    Fill distribution: 
     0 - 19% = 30 
    20 - 39% = 7 
    40 - 59% = 0 
    60 - 79% = 7 
    80 - 99% = 4252 
 
PERF_SPLIT_2 (283) 
    Primary pointer page: 578, Index root page: 579 
    Total formats: 1, used formats: 1 
    Average record length: 139.68, total records: 177300 
    Average version length: 153.90, total versions: 13095, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 12.14 
    Pointer pages: 8, data page slots: 5328 
    Data pages: 4224, average fill: 87% 
    Primary pages: 4224, secondary pages: 0, swept pages: 1 
    Empty pages: 14, full pages: 4188 
    Fill distribution: 
     0 - 19% = 15 
    20 - 39% = 4 
    40 - 59% = 4 
    60 - 79% = 12 
    80 - 99% = 4189 
 
PERF_SPLIT_3 (284) 
    Primary pointer page: 580, Index root page: 581 
    Total formats: 1, used formats: 1 
    Average record length: 137.53, total records: 197351 
    Average version length: 154.32, total versions: 17488, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 12.33 
    Pointer pages: 6, data page slots: 5424 
    Data pages: 4712, average fill: 87% 
    Primary pages: 4712, secondary pages: 0, swept pages: 1 
    Empty pages: 26, full pages: 4674 
    Fill distribution: 
     0 - 19% = 28 
    20 - 39% = 2 
    40 - 59% = 1 
    60 - 79% = 7 
    80 - 99% = 4674 
 
PERF_SPLIT_4 (285) 
    Primary pointer page: 582, Index root page: 583 
    Total formats: 1, used formats: 1 
    Average record length: 147.04, total records: 150159 
    Average version length: 150.86, total versions: 3518, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.53 
    Pointer pages: 6, data page slots: 5768 
    Data pages: 3616, average fill: 85% 
    Primary pages: 3616, secondary pages: 0, swept pages: 3 
    Empty pages: 55, full pages: 3536 
    Fill distribution: 
     0 - 19% = 58 
    20 - 39% = 5 
    40 - 59% = 9 
    60 - 79% = 8 
    80 - 99% = 3536 
 
PERF_SPLIT_5 (286) 
    Primary pointer page: 584, Index root page: 585 
    Total formats: 1, used formats: 1 
    Average record length: 145.77, total records: 161373 
    Average version length: 152.32, total versions: 5187, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.63 
    Pointer pages: 7, data page slots: 4128 
    Data pages: 3872, average fill: 86% 
    Primary pages: 3872, secondary pages: 0, swept pages: 1 
    Empty pages: 44, full pages: 3804 
    Fill distribution: 
     0 - 19% = 46 
    20 - 39% = 7 
    40 - 59% = 7 
    60 - 79% = 8 
    80 - 99% = 3804 
 
PERF_SPLIT_6 (287) 
    Primary pointer page: 586, Index root page: 587 
    Total formats: 1, used formats: 1 
    Average record length: 128.89, total records: 195450 
    Average version length: 154.99, total versions: 28326, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 13.16 
    Pointer pages: 8, data page slots: 7504 
    Data pages: 4680, average fill: 87% 
    Primary pages: 4680, secondary pages: 0, swept pages: 2 
    Empty pages: 30, full pages: 4632 
    Fill distribution: 
     0 - 19% = 30 
    20 - 39% = 8 
    40 - 59% = 5 
    60 - 79% = 6 
    80 - 99% = 4631 
 
PERF_SPLIT_7 (288) 
    Primary pointer page: 588, Index root page: 589 
    Total formats: 1, used formats: 1 
    Average record length: 147.30, total records: 168864 
    Average version length: 150.42, total versions: 3913, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.51 
    Pointer pages: 7, data page slots: 5536 
    Data pages: 4040, average fill: 86% 
    Primary pages: 4040, secondary pages: 0, swept pages: 3 
    Empty pages: 38, full pages: 3989 
    Fill distribution: 
     0 - 19% = 40 
    20 - 39% = 5 
    40 - 59% = 2 
    60 - 79% = 4 
    80 - 99% = 3989 
 
PERF_SPLIT_8 (289) 
    Primary pointer page: 590, Index root page: 591 
    Total formats: 1, used formats: 1 
    Average record length: 150.28, total records: 175315 
    Average version length: 144.07, total versions: 890, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.29 
    Pointer pages: 7, data page slots: 5480 
    Data pages: 4208, average fill: 86% 
    Primary pages: 4207, secondary pages: 1, swept pages: 10 
    Empty pages: 48, full pages: 4146 
    Fill distribution: 
     0 - 19% = 50 
    20 - 39% = 5 
    40 - 59% = 4 
    60 - 79% = 3 
    80 - 99% = 4146 
 
PERF_SPLIT_9 (290) 
    Primary pointer page: 593, Index root page: 594 
    Total formats: 1, used formats: 1 
    Average record length: 141.88, total records: 163726 
    Average version length: 152.36, total versions: 9531, 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: 5256 
    Data pages: 3912, average fill: 86% 
    Primary pages: 3911, secondary pages: 1, swept pages: 1 
    Empty pages: 32, full pages: 3863 
    Fill distribution: 
     0 - 19% = 32 
    20 - 39% = 6 
    40 - 59% = 6 
    60 - 79% = 5 
    80 - 99% = 3863 
 
PHRASES (143) 
    Primary pointer page: 482, Index root page: 483 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index PHRASES_ID_DESC (3) 
    Root page: 1510354, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PHRASES_NAME (2) 
    Root page: 1510353, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PHRASES_UNQ (1) 
    Root page: 1510352, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PK_PHRASES (0) 
    Root page: 1510351, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
PSTORNED (147) 
    Primary pointer page: 490, Index root page: 491 
    Total formats: 1, used formats: 1 
    Average record length: 51.80, total records: 2112629 
    Average version length: 52.91, total versions: 37687, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 70.00, compression ratio: 1.35 
    Pointer pages: 16, data page slots: 25528 
    Data pages: 25528, average fill: 71% 
    Primary pages: 25528, secondary pages: 0, swept pages: 10882 
    Empty pages: 252, full pages: 20813 
    Fill distribution: 
     0 - 19% = 472 
    20 - 39% = 432 
    40 - 59% = 1020 
    60 - 79% = 23278 
    80 - 99% = 326 
 
    Index PSTORNED_RCV_ID (1) 
    Root page: 1506186, depth: 3, leaf buckets: 2591, nodes: 2112629 
    Average node length: 5.44, total dup: 1971077, max dup: 1147 
    Average key length: 2.49, compression ratio: 3.62 
    Average prefix length: 8.58, average data length: 0.42 
    Clustering factor: 183046, ratio: 0.09 
    Fill distribution: 
         0 - 19% = 6 
        20 - 39% = 269 
        40 - 59% = 1729 
        60 - 79% = 284 
        80 - 99% = 303 
 
    Index PSTORNED_SND_ID (0) 
    Root page: 1504819, depth: 3, leaf buckets: 2758, nodes: 2112629 
    Average node length: 5.69, total dup: 1896428, max dup: 64 
    Average key length: 2.74, compression ratio: 3.29 
    Average prefix length: 8.36, average data length: 0.64 
    Clustering factor: 377353, ratio: 0.18 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 5 
        40 - 59% = 2360 
        60 - 79% = 366 
        80 - 99% = 27 
 
    Index PSTORNED_WORKER_ID (2) 
    Root page: 1507996, depth: 3, leaf buckets: 2152, nodes: 2112629 
    Average node length: 4.96, total dup: 2112529, max dup: 26253 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.42, average data length: 0.00 
    Clustering factor: 180636, ratio: 0.09 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 201 
        40 - 59% = 1150 
        60 - 79% = 381 
        80 - 99% = 420 
 
RULES_FOR_PDISTR (148) 
    Primary pointer page: 492, Index root page: 493 
    Total formats: 1, used formats: 1 
    Average record length: 17.00, total records: 4 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 334.00, compression ratio: 19.65 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 2% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index RULES_FOR_PDISTR_UNQ (0) 
    Root page: 1504317, depth: 1, leaf buckets: 1, nodes: 4 
    Average node length: 11.50, total dup: 0, max dup: 0 
    Average key length: 10.25, compression ratio: 0.88 
    Average prefix length: 1.50, average data length: 7.50 
    Clustering factor: 1, ratio: 0.25 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
RULES_FOR_QDISTR (137) 
    Primary pointer page: 470, Index root page: 471 
    Total formats: 1, used formats: 1 
    Average record length: 32.71, total records: 7 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 332.00, compression ratio: 10.15 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 4% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index RULES_FOR_QDISTR_RCVOP (1) 
    Root page: 1544803, depth: 1, leaf buckets: 1, nodes: 7 
    Average node length: 5.29, total dup: 2, max dup: 2 
    Average key length: 4.14, compression ratio: 0.72 
    Average prefix length: 1.43, average data length: 1.57 
    Clustering factor: 1, ratio: 0.14 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index RULES_FOR_QDISTR_UNQ (0) 
    Root page: 1544802, depth: 1, leaf buckets: 1, nodes: 7 
    Average node length: 10.14, total dup: 0, max dup: 0 
    Average key length: 8.86, compression ratio: 0.94 
    Average prefix length: 2.14, average data length: 6.14 
    Clustering factor: 1, ratio: 0.14 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
SEMAPHORES (152) 
    Primary pointer page: 500, Index root page: 501 
    Total formats: 1, used formats: 1 
    Average record length: 43.40, total records: 5 
    Average version length: 9.00, total versions: 1, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 346.00, compression ratio: 7.97 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 4% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index PK_SEMAPHORES (0) 
    Root page: 1504305, depth: 1, leaf buckets: 1, nodes: 5 
    Average node length: 12.40, total dup: 0, max dup: 0 
    Average key length: 11.00, compression ratio: 0.82 
    Average prefix length: 0.60, average data length: 8.40 
    Clustering factor: 1, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index SEMAPHORES_TASK_UNQ (1) 
    Root page: 1504306, depth: 1, leaf buckets: 1, nodes: 5 
    Average node length: 23.40, total dup: 0, max dup: 0 
    Average key length: 22.00, compression ratio: 1.07 
    Average prefix length: 4.20, average data length: 19.40 
    Clustering factor: 1, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
SETTINGS (135) 
    Primary pointer page: 466, Index root page: 467 
    Total formats: 1, used formats: 1 
    Average record length: 97.63, total records: 149 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1347.00, compression ratio: 13.80 
    Pointer pages: 1, data page slots: 3 
    Data pages: 3, average fill: 70% 
    Primary pages: 3, secondary pages: 0, swept pages: 2 
    Empty pages: 0, full pages: 2 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 1 
    60 - 79% = 0 
    80 - 99% = 2 
 
    Index SETTINGS_MCODE_WM_UNQ (1) 
    Root page: 525, depth: 1, leaf buckets: 1, nodes: 149 
    Average node length: 14.66, total dup: 0, max dup: 0 
    Average key length: 13.55, compression ratio: 2.19 
    Average prefix length: 19.07, average data length: 10.66 
    Clustering factor: 48, ratio: 0.32 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 1 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index SETTINGS_MODE_CODE (0) 
    Root page: 1544806, depth: 1, leaf buckets: 1, nodes: 149 
    Average node length: 25.56, total dup: 0, max dup: 0 
    Average key length: 24.56, compression ratio: 1.63 
    Average prefix length: 18.58, average data length: 21.56 
    Clustering factor: 14, ratio: 0.09 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 0 
        40 - 59% = 1 
        60 - 79% = 0 
        80 - 99% = 0 
 
TMP$DEP_DOCS (129) 
    Primary pointer page: 454, Index root page: 455 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index TMP_DEP_DOCS_UNQ (0) 
    Root page: 1544810, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
TMP$IDX_RECALC (132) 
    Primary pointer page: 460, Index root page: 461 
    Total formats: 2, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index TMP_IDX_RECALC_IDX_NAME_UNQ (0) 
    Root page: 1544807, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
TMP$MON_LOG (133) 
    Primary pointer page: 462, Index root page: 463 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
TMP$MON_LOG_TABLE_STATS (134) 
    Primary pointer page: 464, Index root page: 465 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
TMP$PERF_EST_WHOLE (161) 
    Primary pointer page: 518, Index root page: 519 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
TMP$PERF_LOG (160) 
    Primary pointer page: 516, Index root page: 517 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index TMP$PERF_LOG_UNIT_TRN_DTS_END (0) 
    Root page: 1504230, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
TMP$PERF_MON (131) 
    Primary pointer page: 458, Index root page: 459 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
TMP$RESULT_SET (130) 
    Primary pointer page: 456, Index root page: 457 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index TMP_RESULT_SET_DOC (1) 
    Root page: 1544809, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index TMP_RESULT_SET_WARE_DOC (0) 
    Root page: 1544808, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
TMP$SHOPPING_CART (128) 
    Primary pointer page: 452, Index root page: 453 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index TMP_SHOPCART_UNQ (0) 
    Root page: 1544811, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
TPAUSE (166) 
    Primary pointer page: 528, Index root page: 529 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index RDB$PRIMARY2 (0) 
    Root page: 1504214, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
TRACE_STAT (157) 
    Primary pointer page: 510, Index root page: 511 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
WARES (142) 
    Primary pointer page: 480, Index root page: 481 
    Total formats: 1, used formats: 1 
    Average record length: 77.52, total records: 400 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 444.00, compression ratio: 5.73 
    Pointer pages: 1, data page slots: 6 
    Data pages: 6, average fill: 77% 
    Primary pages: 6, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 5 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 5 
    80 - 99% = 1 
 
    Index FK_WARES_WARE_GROUPS (3) 
    Root page: 1552159, depth: 1, leaf buckets: 1, nodes: 400 
    Average node length: 3.17, total dup: 392, max dup: 60 
    Average key length: 2.16, compression ratio: 4.16 
    Average prefix length: 8.86, average data length: 0.14 
    Clustering factor: 48, ratio: 0.12 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PK_WARES (0) 
    Root page: 1510355, depth: 1, leaf buckets: 1, nodes: 400 
    Average node length: 11.22, total dup: 0, max dup: 0 
    Average key length: 10.22, compression ratio: 0.88 
    Average prefix length: 1.78, average data length: 7.22 
    Clustering factor: 344, ratio: 0.86 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 0 
        40 - 59% = 1 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index WARES_ID_DESC (2) 
    Root page: 1510360, depth: 1, leaf buckets: 1, nodes: 400 
    Average node length: 11.22, total dup: 0, max dup: 0 
    Average key length: 10.22, compression ratio: 0.88 
    Average prefix length: 1.78, average data length: 7.22 
    Clustering factor: 344, ratio: 0.86 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 0 
        40 - 59% = 1 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index WARES_NUMB_UNQ (1) 
    Root page: 1510358, depth: 2, leaf buckets: 3, nodes: 400 
    Average node length: 53.25, total dup: 0, max dup: 0 
    Average key length: 52.23, compression ratio: 1.00 
    Average prefix length: 2.74, average data length: 49.25 
    Clustering factor: 355, ratio: 0.89 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 1 
        80 - 99% = 2 
 
WARE_GROUPS (151) 
    Primary pointer page: 498, Index root page: 499 
    Total formats: 1, used formats: 1 
    Average record length: 32.12, total records: 8 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 346.00, compression ratio: 10.77 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 5% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index PK_WARE_GROUPS (0) 
    Root page: 1504307, depth: 1, leaf buckets: 1, nodes: 8 
    Average node length: 11.25, total dup: 0, max dup: 0 
    Average key length: 10.12, compression ratio: 0.89 
    Average prefix length: 1.75, average data length: 7.25 
    Clustering factor: 1, ratio: 0.12 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index WARE_GROUPS_NAME_UNQ (1) 
    Root page: 1504308, depth: 1, leaf buckets: 1, nodes: 8 
    Average node length: 19.88, total dup: 0, max dup: 0 
    Average key length: 18.12, compression ratio: 0.89 
    Average prefix length: 0.25, average data length: 15.88 
    Clustering factor: 1, ratio: 0.12 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
XQD_1000_1200 (176) 
    Primary pointer page: 549, Index root page: 550 
    Total formats: 1, used formats: 1 
    Average record length: 41.21, total records: 128426 
    Average version length: 69.16, total versions: 51967, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 3.06 
    Pointer pages: 3, data page slots: 4272 
    Data pages: 3240, average fill: 46% 
    Primary pages: 3240, secondary pages: 0, swept pages: 735 
    Empty pages: 865, full pages: 1548 
    Fill distribution: 
     0 - 19% = 1231 
    20 - 39% = 282 
    40 - 59% = 146 
    60 - 79% = 445 
    80 - 99% = 1136 
 
    Index XQD_1000_1200_WA_SO_RO_WKR_SND (0) 
    Root page: 99237, depth: 3, leaf buckets: 197, nodes: 128426 
    Average node length: 6.35, total dup: 111792, max dup: 14 
    Average key length: 3.96, compression ratio: 10.59 
    Average prefix length: 40.16, average data length: 1.84 
    Clustering factor: 22397, ratio: 0.17 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 43 
        40 - 59% = 100 
        60 - 79% = 43 
        80 - 99% = 11 
 
XQD_1000_3300 (178) 
    Primary pointer page: 553, Index root page: 554 
    Total formats: 1, used formats: 1 
    Average record length: 65.79, total records: 7072274 
    Average version length: 68.79, total versions: 325628, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.92 
    Pointer pages: 63, data page slots: 101696 
    Data pages: 101696, average fill: 74% 
    Primary pages: 101696, secondary pages: 0, swept pages: 28249 
    Empty pages: 42, full pages: 82520 
    Fill distribution: 
     0 - 19% = 390 
    20 - 39% = 1276 
    40 - 59% = 5668 
    60 - 79% = 88906 
    80 - 99% = 5456 
 
    Index XQD_1000_3300_WA_SO_RO_WKR_SND (0) 
    Root page: 1480454, depth: 3, leaf buckets: 10697, nodes: 7072274 
    Average node length: 6.51, total dup: 6116624, max dup: 29 
    Average key length: 3.52, compression ratio: 11.93 
    Average prefix length: 40.61, average data length: 1.39 
    Clustering factor: 1571390, ratio: 0.22 
    Fill distribution: 
         0 - 19% = 5 
        20 - 39% = 1685 
        40 - 59% = 5827 
        60 - 79% = 2677 
        80 - 99% = 503 
 
    Index XQD_1000_3300_WKR_DOC_ASC (1) 
    Root page: 1486068, depth: 3, leaf buckets: 8493, nodes: 7072274 
    Average node length: 5.40, total dup: 6789682, max dup: 156 
    Average key length: 2.41, compression ratio: 7.06 
    Average prefix length: 16.63, average data length: 0.37 
    Clustering factor: 1371917, ratio: 0.19 
    Fill distribution: 
         0 - 19% = 7 
        20 - 39% = 1041 
        40 - 59% = 4840 
        60 - 79% = 1614 
        80 - 99% = 991 
 
    Index XQD_1000_3300_WKR_DOC_DEC (2) 
    Root page: 1490608, depth: 3, leaf buckets: 8559, nodes: 7072274 
    Average node length: 5.40, total dup: 6789682, max dup: 156 
    Average key length: 2.41, compression ratio: 7.06 
    Average prefix length: 16.63, average data length: 0.37 
    Clustering factor: 1374539, ratio: 0.19 
    Fill distribution: 
         0 - 19% = 5 
        20 - 39% = 1147 
        40 - 59% = 4821 
        60 - 79% = 1598 
        80 - 99% = 988 
 
XQD_1200_2000 (177) 
    Primary pointer page: 551, Index root page: 552 
    Total formats: 1, used formats: 1 
    Average record length: 67.41, total records: 12059044 
    Average version length: 68.72, total versions: 269509, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.87 
    Pointer pages: 103, data page slots: 167280 
    Data pages: 167280, average fill: 76% 
    Primary pages: 167280, secondary pages: 0, swept pages: 79363 
    Empty pages: 8, full pages: 157919 
    Fill distribution: 
     0 - 19% = 64 
    20 - 39% = 505 
    40 - 59% = 2963 
    60 - 79% = 158417 
    80 - 99% = 5331 
 
    Index XQD_1200_2000_WA_SO_RO_WKR_SND (0) 
    Root page: 1495028, depth: 3, leaf buckets: 18396, nodes: 12059044 
    Average node length: 6.58, total dup: 10509799, max dup: 68 
    Average key length: 3.43, compression ratio: 12.25 
    Average prefix length: 40.70, average data length: 1.30 
    Clustering factor: 2377244, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 21 
        20 - 39% = 2454 
        40 - 59% = 10674 
        60 - 79% = 4429 
        80 - 99% = 818 
 
XQD_2000_3300 (179) 
    Primary pointer page: 555, Index root page: 556 
    Total formats: 1, used formats: 1 
    Average record length: 42.89, total records: 1628480 
    Average version length: 69.11, total versions: 618414, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 2.94 
    Pointer pages: 26, data page slots: 41328 
    Data pages: 28984, average fill: 64% 
    Primary pages: 28984, secondary pages: 0, swept pages: 7802 
    Empty pages: 2898, full pages: 19247 
    Fill distribution: 
     0 - 19% = 4695 
    20 - 39% = 1810 
    40 - 59% = 1735 
    60 - 79% = 11121 
    80 - 99% = 9623 
 
    Index XQD_2000_3300_WA_SO_RO_WKR_SND (0) 
    Root page: 1479712, depth: 3, leaf buckets: 2166, nodes: 1628480 
    Average node length: 5.52, total dup: 1562175, max dup: 49 
    Average key length: 2.56, compression ratio: 16.40 
    Average prefix length: 41.48, average data length: 0.52 
    Clustering factor: 108968, ratio: 0.07 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 504 
        40 - 59% = 1071 
        60 - 79% = 461 
        80 - 99% = 128 
 
XQD_2100_3300 (180) 
    Primary pointer page: 557, Index root page: 558 
    Total formats: 1, used formats: 1 
    Average record length: 40.34, total records: 1081487 
    Average version length: 69.13, total versions: 449462, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 3.12 
    Pointer pages: 21, data page slots: 34088 
    Data pages: 28800, average fill: 44% 
    Primary pages: 28800, secondary pages: 0, swept pages: 8096 
    Empty pages: 7506, full pages: 11919 
    Fill distribution: 
     0 - 19% = 11856 
    20 - 39% = 2134 
    40 - 59% = 1426 
    60 - 79% = 5113 
    80 - 99% = 8271 
 
    Index XQD_2100_3300_WA_SO_RO_WKR_SND (0) 
    Root page: 1479207, depth: 3, leaf buckets: 1438, nodes: 1081487 
    Average node length: 5.79, total dup: 1009010, max dup: 99 
    Average key length: 2.86, compression ratio: 14.68 
    Average prefix length: 41.20, average data length: 0.80 
    Clustering factor: 150181, ratio: 0.14 
    Fill distribution: 
         0 - 19% = 5 
        20 - 39% = 257 
        40 - 59% = 701 
        60 - 79% = 353 
        80 - 99% = 122 
 
XQD_3300_3400 (181) 
    Primary pointer page: 559, Index root page: 560 
    Total formats: 1, used formats: 1 
    Average record length: 65.50, total records: 9159393 
    Average version length: 68.97, total versions: 451584, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.92 
    Pointer pages: 87, data page slots: 141832 
    Data pages: 141824, average fill: 69% 
    Primary pages: 141824, secondary pages: 0, swept pages: 54436 
    Empty pages: 239, full pages: 78357 
    Fill distribution: 
     0 - 19% = 962 
    20 - 39% = 5115 
    40 - 59% = 22031 
    60 - 79% = 106943 
    80 - 99% = 6773 
 
    Index XQD_3300_3400_WA_SO_RO_WKR_SND (0) 
    Root page: 1472590, depth: 3, leaf buckets: 13456, nodes: 9159393 
    Average node length: 6.67, total dup: 7595973, max dup: 27 
    Average key length: 3.67, compression ratio: 11.45 
    Average prefix length: 40.50, average data length: 1.50 
    Clustering factor: 1972915, ratio: 0.22 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 1298 
        40 - 59% = 6954 
        60 - 79% = 4576 
        80 - 99% = 626 
 
XQS_1000_1200 (182) 
    Primary pointer page: 561, Index root page: 562 
    Total formats: 1, used formats: 1 
    Average record length: 82.50, total records: 21152064 
    Average version length: 82.94, total versions: 10493, 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: 318864 
    Data pages: 318864, average fill: 81% 
    Primary pages: 318864, secondary pages: 0, swept pages: 12463 
    Empty pages: 32, full pages: 317857 
    Fill distribution: 
     0 - 19% = 59 
    20 - 39% = 65 
    40 - 59% = 145 
    60 - 79% = 27554 
    80 - 99% = 291041 
 
    Index XQS_1000_1200_DOC_ID (1) 
    Root page: 1426716, depth: 3, leaf buckets: 19260, nodes: 21152064 
    Average node length: 5.72, total dup: 20670953, max dup: 128 
    Average key length: 2.16, compression ratio: 4.16 
    Average prefix length: 8.86, average data length: 0.14 
    Clustering factor: 3281220, ratio: 0.16 
    Fill distribution: 
         0 - 19% = 9 
        20 - 39% = 1 
        40 - 59% = 7906 
        60 - 79% = 526 
        80 - 99% = 10818 
 
    Index XQS_1000_1200_RCV_ID (3) 
    Root page: 1456980, depth: 3, leaf buckets: 17162, nodes: 21152064 
    Average node length: 6.31, total dup: 18589146, max dup: 49 
    Average key length: 2.75, compression ratio: 3.27 
    Average prefix length: 8.37, average data length: 0.63 
    Clustering factor: 914168, ratio: 0.04 
    Fill distribution: 
         0 - 19% = 4 
        20 - 39% = 6 
        40 - 59% = 769 
        60 - 79% = 260 
        80 - 99% = 16123 
 
    Index XQS_1000_1200_SND_ID (2) 
    Root page: 1441073, depth: 3, leaf buckets: 21011, nodes: 21152064 
    Average node length: 6.35, total dup: 18507501, max dup: 29 
    Average key length: 2.79, compression ratio: 3.23 
    Average prefix length: 8.34, average data length: 0.66 
    Clustering factor: 3575231, ratio: 0.17 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 2 
        40 - 59% = 8121 
        60 - 79% = 590 
        80 - 99% = 12296 
 
    Index XQS_1000_1200_WORKER_ID (0) 
    Root page: 1413348, depth: 3, leaf buckets: 16035, nodes: 21152064 
    Average node length: 5.56, total dup: 21151964, max dup: 228906 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.42, average data length: 0.00 
    Clustering factor: 942986, ratio: 0.04 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 12 
        40 - 59% = 2774 
        60 - 79% = 363 
        80 - 99% = 12885 
 
XQS_1000_3300 (184) 
    Primary pointer page: 565, Index root page: 566 
    Total formats: 1, used formats: 1 
    Average record length: 78.49, total records: 9627545 
    Average version length: 82.68, total versions: 457812, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.61 
    Pointer pages: 102, data page slots: 166280 
    Data pages: 166256, average fill: 72% 
    Primary pages: 166256, secondary pages: 0, swept pages: 68297 
    Empty pages: 403, full pages: 100355 
    Fill distribution: 
     0 - 19% = 1288 
    20 - 39% = 5155 
    40 - 59% = 21839 
    60 - 79% = 76174 
    80 - 99% = 61800 
 
    Index XQS_1000_3300_DOC_ID (1) 
    Root page: 1367502, depth: 3, leaf buckets: 11338, nodes: 9627545 
    Average node length: 5.35, total dup: 9318686, max dup: 189 
    Average key length: 2.23, compression ratio: 4.03 
    Average prefix length: 8.80, average data length: 0.20 
    Clustering factor: 2133631, ratio: 0.22 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 64 
        40 - 59% = 8471 
        60 - 79% = 2739 
        80 - 99% = 62 
 
    Index XQS_1000_3300_RCV_ID (3) 
    Root page: 1379261, depth: 3, leaf buckets: 13272, nodes: 9627545 
    Average node length: 6.22, total dup: 7979810, max dup: 14 
    Average key length: 3.10, compression ratio: 2.90 
    Average prefix length: 8.07, average data length: 0.93 
    Clustering factor: 1478731, ratio: 0.15 
    Fill distribution: 
         0 - 19% = 141 
        20 - 39% = 3695 
        40 - 59% = 4339 
        60 - 79% = 2591 
        80 - 99% = 2506 
 
    Index XQS_1000_3300_SND_ID (2) 
    Root page: 1373059, depth: 3, leaf buckets: 12654, nodes: 9627545 
    Average node length: 5.97, total dup: 8350604, max dup: 41 
    Average key length: 2.85, compression ratio: 3.16 
    Average prefix length: 8.28, average data length: 0.72 
    Clustering factor: 2324273, ratio: 0.24 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 75 
        40 - 59% = 9441 
        60 - 79% = 3051 
        80 - 99% = 85 
 
    Index XQS_1000_3300_WORKER_ID (0) 
    Root page: 1362767, depth: 3, leaf buckets: 10063, nodes: 9627545 
    Average node length: 5.12, total dup: 9627445, max dup: 143930 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.42, average data length: 0.00 
    Clustering factor: 1503666, ratio: 0.16 
    Fill distribution: 
         0 - 19% = 29 
        20 - 39% = 1247 
        40 - 59% = 4995 
        60 - 79% = 1779 
        80 - 99% = 2013 
 
XQS_1200_2000 (183) 
    Primary pointer page: 563, Index root page: 564 
    Total formats: 1, used formats: 1 
    Average record length: 79.70, total records: 11282829 
    Average version length: 82.58, total versions: 356682, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.58 
    Pointer pages: 117, data page slots: 190648 
    Data pages: 189464, average fill: 73% 
    Primary pages: 189464, secondary pages: 0, swept pages: 73536 
    Empty pages: 2600, full pages: 140504 
    Fill distribution: 
     0 - 19% = 4426 
    20 - 39% = 6977 
    40 - 59% = 17582 
    60 - 79% = 45994 
    80 - 99% = 114485 
 
    Index XQS_1200_2000_DOC_ID (1) 
    Root page: 1392101, depth: 3, leaf buckets: 13114, nodes: 11282829 
    Average node length: 5.30, total dup: 11172711, max dup: 641 
    Average key length: 2.08, compression ratio: 4.33 
    Average prefix length: 8.93, average data length: 0.07 
    Clustering factor: 2350565, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 102 
        40 - 59% = 9198 
        60 - 79% = 3684 
        80 - 99% = 130 
 
    Index XQS_1200_2000_RCV_ID (3) 
    Root page: 1406110, depth: 3, leaf buckets: 10355, nodes: 11282829 
    Average node length: 5.50, total dup: 10789577, max dup: 49 
    Average key length: 2.28, compression ratio: 3.95 
    Average prefix length: 8.77, average data length: 0.23 
    Clustering factor: 709632, ratio: 0.06 
    Fill distribution: 
         0 - 19% = 147 
        20 - 39% = 834 
        40 - 59% = 2490 
        60 - 79% = 1792 
        80 - 99% = 5092 
 
    Index XQS_1200_2000_SND_ID (2) 
    Root page: 1398638, depth: 3, leaf buckets: 14999, nodes: 11282829 
    Average node length: 6.03, total dup: 9842809, max dup: 71 
    Average key length: 2.81, compression ratio: 3.21 
    Average prefix length: 8.32, average data length: 0.68 
    Clustering factor: 2366959, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 3 
        20 - 39% = 134 
        40 - 59% = 10679 
        60 - 79% = 4031 
        80 - 99% = 152 
 
    Index XQS_1200_2000_WORKER_ID (0) 
    Root page: 1386211, depth: 3, leaf buckets: 10785, nodes: 11282829 
    Average node length: 5.22, total dup: 11282729, max dup: 179182 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.42, average data length: 0.00 
    Clustering factor: 698737, ratio: 0.06 
    Fill distribution: 
         0 - 19% = 86 
        20 - 39% = 877 
        40 - 59% = 4819 
        60 - 79% = 1444 
        80 - 99% = 3559 
 
XQS_2000_3300 (185) 
    Primary pointer page: 567, Index root page: 568 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index XQS_2000_3300_DOC_ID (1) 
    Root page: 1361753, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index XQS_2000_3300_RCV_ID (3) 
    Root page: 1361755, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index XQS_2000_3300_SND_ID (2) 
    Root page: 1361754, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index XQS_2000_3300_WORKER_ID (0) 
    Root page: 1361752, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
XQS_2100_3300 (186) 
    Primary pointer page: 569, Index root page: 570 
    Total formats: 1, used formats: 1 
    Average record length: 79.07, total records: 9714049 
    Average version length: 82.93, total versions: 429993, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.59 
    Pointer pages: 105, data page slots: 169792 
    Data pages: 169744, average fill: 71% 
    Primary pages: 169744, secondary pages: 0, swept pages: 72421 
    Empty pages: 433, full pages: 100500 
    Fill distribution: 
     0 - 19% = 1465 
    20 - 39% = 6431 
    40 - 59% = 23986 
    60 - 79% = 77066 
    80 - 99% = 60796 
 
    Index XQS_2100_3300_DOC_ID (1) 
    Root page: 1344686, depth: 3, leaf buckets: 11757, nodes: 9714049 
    Average node length: 5.16, total dup: 9685037, max dup: 1677 
    Average key length: 2.03, compression ratio: 4.43 
    Average prefix length: 8.97, average data length: 0.03 
    Clustering factor: 1920487, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 32 
        20 - 39% = 1477 
        40 - 59% = 7908 
        60 - 79% = 1776 
        80 - 99% = 564 
 
    Index XQS_2100_3300_RCV_ID (3) 
    Root page: 1355717, depth: 3, leaf buckets: 13418, nodes: 9714049 
    Average node length: 6.23, total dup: 8051322, max dup: 14 
    Average key length: 3.10, compression ratio: 2.90 
    Average prefix length: 8.07, average data length: 0.93 
    Clustering factor: 1436781, ratio: 0.15 
    Fill distribution: 
         0 - 19% = 185 
        20 - 39% = 3769 
        40 - 59% = 4277 
        60 - 79% = 2571 
        80 - 99% = 2616 
 
    Index XQS_2100_3300_SND_ID (2) 
    Root page: 1350049, depth: 3, leaf buckets: 12441, nodes: 9714049 
    Average node length: 5.42, total dup: 9277435, max dup: 99 
    Average key length: 2.29, compression ratio: 3.93 
    Average prefix length: 8.76, average data length: 0.24 
    Clustering factor: 2054899, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 30 
        20 - 39% = 1470 
        40 - 59% = 8856 
        60 - 79% = 1577 
        80 - 99% = 508 
 
    Index XQS_2100_3300_WORKER_ID (0) 
    Root page: 985805, depth: 3, leaf buckets: 10171, nodes: 9714049 
    Average node length: 5.13, total dup: 9713949, max dup: 145736 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.42, average data length: 0.00 
    Clustering factor: 1511661, ratio: 0.16 
    Fill distribution: 
         0 - 19% = 48 
        20 - 39% = 1329 
        40 - 59% = 4923 
        60 - 79% = 1728 
        80 - 99% = 2143 
 
XQS_3300_3400 (187) 
    Primary pointer page: 571, Index root page: 572 
    Total formats: 1, used formats: 1 
    Average record length: 67.52, total records: 581826 
    Average version length: 68.77, total versions: 5579, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.87 
    Pointer pages: 5, data page slots: 8000 
    Data pages: 8000, average fill: 76% 
    Primary pages: 8000, secondary pages: 0, swept pages: 3774 
    Empty pages: 5, full pages: 7105 
    Fill distribution: 
     0 - 19% = 5 
    20 - 39% = 7 
    40 - 59% = 98 
    60 - 79% = 7777 
    80 - 99% = 113 
 
    Index XQS_3300_3400_DOC_ID (1) 
    Root page: 33278, depth: 3, leaf buckets: 727, nodes: 581826 
    Average node length: 5.95, total dup: 495542, max dup: 82 
    Average key length: 3.09, compression ratio: 2.91 
    Average prefix length: 8.06, average data length: 0.94 
    Clustering factor: 101265, ratio: 0.17 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 28 
        40 - 59% = 488 
        60 - 79% = 109 
        80 - 99% = 102 
 
    Index XQS_3300_3400_SND_ID (2) 
    Root page: 21380, depth: 3, leaf buckets: 740, nodes: 581826 
    Average node length: 6.15, total dup: 477292, max dup: 29 
    Average key length: 3.29, compression ratio: 2.73 
    Average prefix length: 7.89, average data length: 1.11 
    Clustering factor: 101313, ratio: 0.17 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 21 
        40 - 59% = 493 
        60 - 79% = 105 
        80 - 99% = 121 
 
    Index XQS_3300_3400_WORKER_ID (0) 
    Root page: 375548, depth: 2, leaf buckets: 585, nodes: 581826 
    Average node length: 4.86, total dup: 581726, max dup: 9823 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.42, average data length: 0.00 
    Clustering factor: 89916, ratio: 0.15 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 29 
        40 - 59% = 366 
        60 - 79% = 75 
        80 - 99% = 113 
 
ZDOC_DATA (170) 
    Primary pointer page: 537, Index root page: 538 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
ZDOC_LIST (169) 
    Primary pointer page: 535, Index root page: 536 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
ZINVNT_TURNOVER_LOG (171) 
    Primary pointer page: 539, Index root page: 540 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
ZPDISTR (174) 
    Primary pointer page: 545, Index root page: 546 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index ZPDISTR_ID (0) 
    Root page: 1504207, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
ZPSTORNED (175) 
    Primary pointer page: 547, Index root page: 548 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index ZPSTORNED_ID (0) 
    Root page: 1504206, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
ZQDISTR (172) 
    Primary pointer page: 541, Index root page: 542 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index ZQDISTR_ID (0) 
    Root page: 1504212, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index ZQDISTR_WARE_SNDOP_RCVOP (1) 
    Root page: 1504213, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
ZQSTORNED (173) 
    Primary pointer page: 543, Index root page: 544 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index ZQSTORNED_DOC_ID (1) 
    Root page: 1504209, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index ZQSTORNED_ID (0) 
    Root page: 1504208, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index ZQSTORNED_RCV_ID (3) 
    Root page: 1504211, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index ZQSTORNED_SND_ID (2) 
    Root page: 1504210, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
ZTMP_DEP_DOCS (168) 
    Primary pointer page: 533, Index root page: 534 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
ZTMP_SHOPPING_CART (167) 
    Primary pointer page: 531, Index root page: 532 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
Z_USED_VIEWS (144) 
    Primary pointer page: 484, Index root page: 485 
    Total formats: 1, used formats: 1 
    Average record length: 29.38, total records: 29 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 99.00, compression ratio: 3.37 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 16% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index Z_USED_VIEWS_UNQ (0) 
    Root page: 1510350, depth: 1, leaf buckets: 1, nodes: 29 
    Average node length: 15.17, total dup: 0, max dup: 0 
    Average key length: 14.14, compression ratio: 1.44 
    Average prefix length: 9.17, average data length: 11.17 
    Clustering factor: 1, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
Gstat completion time Sun Apr  7 16:12:01 2024

Record versions statistics, table

TABLE_NAME TOTAL_RECS TOTAL_VERS MAX_VERSIONS VERS_TO_RECS_PRC MAXV_TO_VERS_PRC
DOC_DATA 7746959 85437 1 0.0000 0.0000
DOC_LIST 2245221 87964 3 0.0000 0.0000
FB_ERRORS 2182 757 1 0.0000 0.0000
INVNT_SALDO 400 235652 618 58900.0000 0.0000
INVNT_TURNOVER_LOG 96562 69783 1 0.0000 0.0000
MONEY_SALDO 49 17681 924 36000.0000 0.0000
MONEY_TURNOVER_LOG 1460 1291 1 0.0000 0.0000
PDISTR 795316 64080 4 0.0000 0.0000
PERF_SPLIT_0 182778 14812 1 0.0000 0.0000
PERF_SPLIT_1 179790 4749 1 0.0000 0.0000
PERF_SPLIT_2 177300 13095 1 0.0000 0.0000
PERF_SPLIT_3 197351 17488 1 0.0000 0.0000
PERF_SPLIT_4 150159 3518 1 0.0000 0.0000
PERF_SPLIT_5 161373 5187 1 0.0000 0.0000
PERF_SPLIT_6 195450 28326 1 0.0000 0.0000
PERF_SPLIT_7 168864 3913 1 0.0000 0.0000
PERF_SPLIT_8 175315 890 1 0.0000 0.0000
PERF_SPLIT_9 163726 9531 1 0.0000 0.0000
PSTORNED 2112629 37687 1 0.0000 0.0000
SEMAPHORES 5 1 1 0.0000 100.0000
XQD_1000_1200 128426 51967 1 0.0000 0.0000
XQD_1000_3300 7072274 325628 1 0.0000 0.0000
XQD_1200_2000 12059044 269509 1 0.0000 0.0000
XQD_2000_3300 1628480 618414 1 0.0000 0.0000
XQD_2100_3300 1081487 449462 1 0.0000 0.0000
XQD_3300_3400 9159393 451584 1 0.0000 0.0000
XQS_1000_1200 21152064 10493 1 0.0000 0.0000
XQS_1000_3300 9627545 457812 1 0.0000 0.0000
XQS_1200_2000 11282829 356682 1 0.0000 0.0000
XQS_2100_3300 9714049 429993 1 0.0000 0.0000
XQS_3300_3400 581826 5579 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 ---
:890: 
:891: mscs-test-161.budzdorov.ru    Sun Apr  7 16:10:06 2024
:892:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:893: 
--- end of diff output ---

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

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