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

Hardware and OS info

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

Server and database settinfs 


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

Test configuration settings 

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

Test finish info 


FINISH_STATE                    NORMAL: TEST_TIME EXPIRED AT 2024-03-09 01:09:44
DTS_END                         2024-03-09 01:09:44.2570
FB_GDSCODE                      -1
FB_MNEMONA                      
STACK                           SP_CANCEL_SUPPLIER_ORDER(116:18) ==> SP_CANCEL_CUSTOMER_RESERVE(36:5) ==> SP_CHECK_TO_STOP_WORK(32:12) ==> SP_HALT_ON_ERROR(57:17)
IP                              ::1/36058
TRN_ID                          182119
ATT_ID                          581
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: 9437.06 19870 943706
customer order: creation 186.46 357 18646
customer order: refuse 14.78 388 1478
order to supplier: creation 49.39 1271 4939
order to supplier: removal 3.38 102772 338
invoice (draft): creation 49.08 3150 4908
invoice (draft): removal 49.44 833 4944
invoice accept: apply 44.24 19707 4424
invoice accept: cancel 45.26 840 4526
customer reserve: creation 4236.56 188 423656
customer reserve: removal 4444.20 61 444420
realization accept: apply 91.28 213 9128
realization accept: cancel 81.13 145 8113
payment from customer: creation 64.32 149 6432
payment from customer: removal 6.51 73 651
payment to supplier: creation 53.23 165 5323
payment to supplier: removal 3.78 70 378
service: total inventory turnovers 5.14 1101 514
service: total monetary turnovers 7.89 44 789
service: aggregate perf. data 0.96 17126 96
service: refresh index statistics 0.03 248748 3

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:02, from 09-03-2024 01:10:45 to 09-03-2024 01:10:47.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 3770
TEST_TIME 2 2928
TEST_TIME 3 3266
TEST_TIME 4 3025
TEST_TIME 5 3242
TEST_TIME 6 4263
TEST_TIME 7 4568
TEST_TIME 8 4635
TEST_TIME 9 4542
TEST_TIME 10 4698
TEST_TIME 11 4868
TEST_TIME 12 5208
TEST_TIME 13 5854
TEST_TIME 14 5920
TEST_TIME 15 6176
TEST_TIME 16 6385
TEST_TIME 17 6616
TEST_TIME 18 6782
TEST_TIME 19 6888
TEST_TIME 20 6813
TEST_TIME 21 7546
TEST_TIME 22 7878
TEST_TIME 23 7895
TEST_TIME 24 8274
TEST_TIME 25 8923
TEST_TIME 26 9664
TEST_TIME 27 9637
TEST_TIME 28 9421
TEST_TIME 29 9539
TEST_TIME 30 9434
TEST_TIME 31 9249
TEST_TIME 32 9200
TEST_TIME 33 9170
TEST_TIME 34 9188
TEST_TIME 35 9137
TEST_TIME 36 9057
TEST_TIME 37 9074
TEST_TIME 38 9044
TEST_TIME 39 9016
TEST_TIME 40 8995
TEST_TIME 41 9016
TEST_TIME 42 9062
TEST_TIME 43 9149
TEST_TIME 44 9086
TEST_TIME 45 9307
TEST_TIME 46 9481
TEST_TIME 47 9423
TEST_TIME 48 9329
TEST_TIME 49 9419
TEST_TIME 50 9483
TEST_TIME 51 9412
TEST_TIME 52 9523
TEST_TIME 53 9682
TEST_TIME 54 9658
TEST_TIME 55 9730
TEST_TIME 56 9655
TEST_TIME 57 9767
TEST_TIME 58 9662
TEST_TIME 59 9548
TEST_TIME 60 9555
TEST_TIME 61 9471
TEST_TIME 62 9457
TEST_TIME 63 9518
TEST_TIME 64 9432
TEST_TIME 65 9420
TEST_TIME 66 9382
TEST_TIME 67 9316
TEST_TIME 68 9281
TEST_TIME 69 9308
TEST_TIME 70 9279
TEST_TIME 71 9345
TEST_TIME 72 9332
TEST_TIME 73 9345
TEST_TIME 74 9500
TEST_TIME 75 9458
TEST_TIME 76 9507
TEST_TIME 77 9441
TEST_TIME 78 9498
TEST_TIME 79 9594
TEST_TIME 80 9563
TEST_TIME 81 9629
TEST_TIME 82 9691
TEST_TIME 83 9627
TEST_TIME 84 9532
TEST_TIME 85 9520
TEST_TIME 86 9495
TEST_TIME 87 9472
TEST_TIME 88 9456
TEST_TIME 89 9479
TEST_TIME 90 9456
TEST_TIME 91 9393
TEST_TIME 92 9372
TEST_TIME 93 9383
TEST_TIME 94 9389
TEST_TIME 95 9409
TEST_TIME 96 9410
TEST_TIME 97 9430
TEST_TIME 98 9475
TEST_TIME 99 9449
TEST_TIME 100 9445

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:04, from 09-03-2024 01:10:48 to 09-03-2024 01:10:52.

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 1330806 1330806 0 0.00 0 32460 7 0 0
doc_list_biud 1330806 1330806 0 0.00 0 58506 26 0 0
sp_add_invoice_to_stock 4551 4424 127 2.79 55 184969 19708 0 127
sp_cancel_adding_invoice 4526 4526 0 0.00 3 69180 841 0 0
sp_cancel_client_order 1478 1478 0 0.00 4 23039 388 0 0
sp_cancel_customer_reserve 444420 444420 0 0.00 0 58509 62 0 0
sp_cancel_pay_from_customer 651 651 0 0.00 3 2621 74 0 0
sp_cancel_pay_to_supplier 378 378 0 0.00 2 4074 71 0 0
sp_cancel_supplier_invoice 4950 4944 6 0.12 2 50436 833 0 6
sp_cancel_supplier_order 338 338 0 0.00 5 932668 102772 0 0
sp_cancel_write_off 8113 8113 0 0.00 1 18344 146 0 0
sp_client_order 18646 18646 0 0.00 3 55046 358 0 0
sp_customer_reserve 423656 423656 0 0.00 0 42018 188 0 0
sp_fill_shopping_cart 28490 28490 0 0.00 1 10205 36 0 0
sp_fill_shopping_cart_clo_res 423652 423652 0 0.00 0 22819 16 0 0
sp_get_clo_for_invoice 4413 4413 0 0.00 0 23179 308 0 0
sp_kill_cost_storno 13668 13668 0 0.00 0 18315 69 0 0
sp_kill_qstorno_ret_qs2qd 902235 902235 0 0.00 0 58499 34 0 0
sp_kill_qty_storno 477360 477360 0 0.00 0 58506 73 0 0
sp_lock_selected_doc 18620 18620 0 0.00 0 8221 4 0 0
sp_make_cost_storno 25296 25296 0 0.00 0 26449 69 0 0
sp_multiply_rows_for_pdistr 25296 25296 0 0.00 0 16390 41 0 0
sp_multiply_rows_for_qdistr 18646 18646 0 0.00 0 55036 163 0 0
sp_pay_from_customer 6432 6432 0 0.00 4 17995 149 0 0
sp_pay_to_supplier 5323 5323 0 0.00 5 17609 166 0 0
sp_payment_common 11755 11755 0 0.00 2 17952 41 0 0
sp_qd_handle_on_cancel_clo 1478 1478 0 0.00 0 23032 359 0 0
sp_qd_handle_on_invoice_upd_sts 8939 8939 0 0.00 0 14018 317 0 0
sp_qd_handle_on_reserve_upd_sts 9128 9128 0 0.00 0 28714 68 0 0
sp_reserve_write_off 9128 9128 0 0.00 6 28750 214 0 0
sp_supplier_invoice 4908 4908 0 0.00 8 111236 3150 0 0
sp_supplier_order 4939 4939 0 0.00 5 18915 1272 0 0
srv_aggregate_perf_data 97 96 1 1.03 1547 301366 17127 0 1
srv_fill_mon_cache_memory 56 56 0 0.00 1069 111954 39544 0 0
srv_find_qd_qs_mism 897694 897694 0 0.00 0 32459 6 0 0
srv_make_invnt_saldo 514 514 0 0.00 43 69434 1101 0 0
srv_make_money_saldo 789 789 0 0.00 1 9085 44 0 0
srv_recalc_idx_stat 3 3 0 0.00 165044 322780 248748 0 0
t$perf-abend:sp_add_invoice_to_stock 127 127 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-abend:srv_aggregate_perf_data 1 1 0 0.00 0 0 0 0 0
t$perf-norm:sp_add_invoice_to_stock 4425 4425 0 0.00 0 15267 210 0 0
t$perf-norm:sp_cancel_adding_invoice 361 361 0 0.00 0 3215 84 0 0
t$perf-norm:sp_cancel_client_order 1478 1478 0 0.00 0 1350 12 0 0
t$perf-norm:sp_cancel_customer_reserve 607 607 0 0.00 0 2024 19 0 0
t$perf-norm:sp_cancel_pay_from_customer 651 651 0 0.00 0 4508 17 0 0
t$perf-norm:sp_cancel_pay_to_supplier 378 378 0 0.00 0 1099 7 0 0
t$perf-norm:sp_cancel_supplier_invoice 368 368 0 0.00 0 3578 35 0 0
t$perf-norm:sp_cancel_supplier_order 338 338 0 0.00 0 34601 1713 0 0
t$perf-norm:sp_cancel_write_off 899 899 0 0.00 0 4513 16 0 0
t$perf-norm:sp_client_order 18646 18646 0 0.00 0 11568 20 0 0
t$perf-norm:sp_customer_reserve 887 887 0 0.00 0 2043 5 0 0
t$perf-norm:sp_pay_from_customer 6432 6432 0 0.00 0 5738 12 0 0
t$perf-norm:sp_pay_to_supplier 5323 5323 0 0.00 0 4013 11 0 0
t$perf-norm:sp_reserve_write_off 9128 9128 0 0.00 0 5882 12 0 0
t$perf-norm:sp_supplier_invoice 4908 4908 0 0.00 0 6989 20 0 0
t$perf-norm:sp_supplier_order 4939 4939 0 0.00 0 4549 18 0 0
t$perf-norm:srv_aggregate_perf_data 96 96 0 0.00 0 172 7 0 0
t$perf-norm:srv_fill_mon_cache_memory 56 56 0 0.00 0 85 3 0 0
t$perf-norm:srv_make_invnt_saldo 514 514 0 0.00 0 1263 30 0 0
t$perf-norm:srv_make_money_saldo 789 789 0 0.00 0 3776 27 0 0
t$perf-norm:srv_recalc_idx_stat 3 3 0 0.00 2 13 6 0 0
v_add_invoice_to_stock 9080 8826 254 2.79 0 7487 22 0 254
v_all_customers 34534 34534 0 0.00 0 150 1 0 0
v_all_suppliers 27868 27868 0 0.00 0 21 1 0 0
v_all_wares 37292 37292 0 0.00 0 29 1 0 0
v_cancel_adding_invoice 722 722 0 0.00 0 841 8 0 0
v_cancel_client_order 2956 2956 0 0.00 0 2086 4 0 0
v_cancel_customer_prepayment 1302 1302 0 0.00 0 2258 7 0 0
v_cancel_customer_reserve 1214 1214 0 0.00 0 2190 7 0 0
v_cancel_payment_to_supplier 756 756 0 0.00 0 4059 10 0 0
v_cancel_supplier_invoice 748 736 12 1.60 0 635 15 0 12
v_cancel_supplier_order 676 676 0 0.00 0 1770 10 0 0
v_cancel_write_off 1798 1798 0 0.00 0 5312 18 0 0
v_max_id_clo_ord 4938 4938 0 0.00 0 1207 2 0 0
v_max_id_clo_res 887 887 0 0.00 0 4384 17 0 0
v_max_id_ord_sup 4906 4906 0 0.00 0 6559 3 0 0
v_max_non_paid_invoice 1233 1233 0 0.00 0 785 4 0 0
v_max_non_paid_realizn 3195 3195 0 0.00 0 5823 7 0 0
v_min_id_clo_ord 4938 4938 0 0.00 0 5736 8 0 0
v_min_id_clo_res 887 887 0 0.00 0 7431 14 0 0
v_min_id_ord_sup 4906 4906 0 0.00 0 8593 5 0 0
v_min_non_paid_invoice 5323 5323 0 0.00 0 17538 27 0 0
v_min_non_paid_realizn 6432 6432 0 0.00 0 17947 37 0 0
v_our_firm 9232 9232 0 0.00 0 17 1 0 0
v_reserve_write_off 18254 18254 0 0.00 0 5370 7 0 0
x_lock_depdocs_on_canc_invoice 9102 9102 0 0.00 0 16681 140 0 0
x_lock_depdocs_on_canc_sup_ord 338 338 0 0.00 0 8507 325 0 0
x_make_qstorno_1000_1200 4939 4939 0 0.00 1 18886 1185 0 0
x_make_qstorno_1200_2000 4908 4908 0 0.00 3 109422 3025 0 0
x_make_qstorno_2100_3300 423656 423656 0 0.00 0 42016 168 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 09-03-2024 01:10:53 to 09-03-2024 01:10:57.

Memory consumption, metadata cache, attachments activity 

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


Page cache type: shared, buffers: 1000000 for all connections, with total size: 8192000000
measurement_dts measurement duration ms page cache memo used memo used, total memo allocated, total metadata cache metadata cache percent of total total attachments cnt active attachments cnt running statements cnt stalled statements cnt memo used by attachments memo used by transactions memo used by statements
23:09:48 2 8192000000 8797116768 8807743488 3953616 0.048 1 1 2 0 4051888 55488 42784
23:10:49 31124 8192000000 9910710160 10220871680 984297056 10.726 100 86 172 0 1012751952 5920160 22534736
23:12:28 15984 8192000000 9955470000 10278219776 1035275232 11.219 100 87 174 0 1066364528 8509088 22580208
23:13:54 16283 8192000000 9990553920 10327470080 1078170000 11.630 100 80 161 0 1108601872 9824032 20607840
23:15:18 11418 8192000000 10036345344 10384863232 1123348672 12.059 100 82 164 0 1153580528 11067200 19164656
23:16:33 6780 8192000000 10076271808 10437591040 1164014896 12.441 100 76 150 0 1193690480 12099456 17576128
23:17:47 3254 8192000000 10123435296 10495442944 1213442912 12.901 100 73 146 0 1242829200 12679888 16706400
23:18:54 1720 8192000000 10159457536 10535927808 1252393024 13.260 100 82 164 0 1283095216 13487200 17214992
23:19:58 2224 8192000000 10196103056 10581229568 1288308544 13.589 100 86 172 1 1322097248 14260224 19528480
23:21:03 1158 8192000000 10226196848 10614571008 1311965008 13.804 100 85 170 1 1344050960 13338496 18747456
23:22:05 24923 8192000000 10216551376 10618494976 1315475744 13.836 100 64 125 3 1336917616 7455728 13986144
23:23:30 8300 8192000000 10211006224 10623119360 1319021600 13.868 100 34 69 1 1334747312 8386720 7338992
23:24:40 8589 8192000000 10208762432 10630057984 1328470752 13.953 100 22 43 2 1340025984 6810176 4745056
23:25:49 6382 8192000000 10224572768 10643296256 1334858944 14.011 100 32 63 0 1357233824 15269120 7105760
23:26:55 55747 8192000000 10242430720 10654375936 1336559888 14.026 100 54 103 2 1354784592 5821232 12403472
23:28:52 2726 8192000000 10235242096 10650591232 1323262768 13.906 99 40 78 0 1340732080 8505232 8964080
23:29:57 21165 8192000000 10240875712 10647486464 1327297728 13.943 100 59 114 0 1347958512 7991008 12669776
23:31:47 72768 8192000000 10252787184 10673262592 1354623392 14.189 100 37 73 0 1374546240 11133504 8789344
23:34:39 62788 8192000000 10258457008 10689261568 1327489744 13.944 97 44 89 2 1359787936 21727952 10570240
23:36:45 76987 8192000000 10251910944 10668978176 1295206976 13.652 95 25 51 0 1320150448 18329184 6614288
23:39:07 21430 8192000000 10260290512 10669395968 1321995040 13.895 98 46 92 0 1357163344 24534704 10633600
23:40:32 16374 8192000000 10274045984 10685685760 1318440288 13.863 97 42 82 0 1355251472 26444096 10367088
23:41:53 4278 8192000000 10267603344 10670747648 1329069008 13.959 100 56 111 0 1373107888 30444112 13594768
23:43:05 5550 8192000000 10270218656 10671304704 1340813936 14.065 100 68 134 0 1379848288 23511296 15523056
23:44:15 6436 8192000000 10261464592 10670399488 1336493296 14.026 100 43 86 0 1376172784 28363696 11315792
23:45:34 1068 8192000000 10303269616 10694963200 1343627616 14.090 99 89 178 0 1396932656 32330208 20974832
23:46:42 2659 8192000000 10315017104 10714083328 1364605216 14.279 100 79 158 2 1418741280 33901136 20234928
23:47:48 8735 8192000000 10311410944 10714877952 1364470464 14.277 100 66 132 1 1417528320 36824432 16233424
23:49:01 8121 8192000000 10342074192 10749628416 1383782496 14.450 100 70 140 2 1441455232 40400288 17272448
23:50:22 1737 8192000000 10370513344 10778107904 1409003696 14.675 100 91 182 1 1472181920 41464768 21713456
23:51:28 6016 8192000000 10341467552 10773733376 1406379888 14.652 100 38 75 1 1453053232 37265344 9408000
23:52:38 5719 8192000000 10346521168 10773983232 1401140528 14.605 100 40 80 0 1451597840 39755024 10702288
23:53:47 27672 8192000000 10333849152 10774687744 1397764976 14.575 100 20 40 0 1439302320 36123008 5414336
23:55:36 66801 8192000000 10296499152 10754904064 1384843072 14.460 100 6 11 0 1400906464 15259056 804336
23:57:47 14713 8192000000 10316347760 10749480960 1393956800 14.541 100 46 88 3 1415613360 12484208 9172352
23:59:05 27329 8192000000 10312802384 10753396736 1399362992 14.589 100 35 70 0 1414683424 7834976 7485456
00:00:36 41188 8192000000 10313159552 10758799360 1407255520 14.660 100 37 73 1 1424562864 9484752 7822592
00:02:49 50490 8192000000 10316463776 10764865536 1406450432 14.652 100 35 69 1 1423163936 8400624 8312880
00:04:42 34832 8192000000 10309372432 10763403264 1410635744 14.690 100 35 70 1 1426981616 8049776 8296096
00:06:18 42280 8192000000 10315537056 10758598656 1361041344 14.247 96 38 73 1 1386351504 16281296 9028864
00:08:03 8604 8192000000 10345004944 10781609984 1418822672 14.762 100 61 118 0 1455859376 22462784 14573920
00:09:15 25142 8192000000 10330971664 10779303936 1409013952 14.675 99 23 46 0 1437338176 22624912 5699312
00:10:56 16233 8192000000 10329082512 10776657920 1394185792 14.543 98 26 52 1 1427438944 26359520 6893632
00:12:21 23216 8192000000 10323130272 10780893184 1415406528 14.732 100 13 24 0 1436233968 18024496 2802944
00:13:46 40991 8192000000 10324086336 10782744576 1402556752 14.618 99 17 34 0 1427625472 20781408 4287312
00:15:42 73875 8192000000 10253364048 10687844352 1246469424 13.206 89 10 20 1 1257578832 8953104 2156304
00:17:57 11931 8192000000 10297524976 10720198656 1353052320 14.175 99 52 102 0 1379127184 13875168 12199696
00:19:10 44718 8192000000 10280319616 10718289920 1312627264 13.810 96 31 62 0 1335746880 16185712 6933904
00:21:05 73416 8192000000 10279118208 10744250368 1340384304 14.061 98 20 40 0 1369551360 24664608 4502448
00:23:21 35438 8192000000 10273642160 10705010688 1328551216 13.954 98 21 42 0 1345895184 12464880 4879088
00:24:57 52082 8192000000 10264896224 10698948608 1327853248 13.948 98 25 51 0 1342466912 8803664 5810000
00:26:51 111954 8192000000 10265143504 10701029376 1342106496 14.076 99 32 65 2 1358902928 9177296 7619136
00:30:11 43117 8192000000 10227567552 10669793280 1327519184 13.945 99 23 46 0 1341913664 9383568 5010912
00:31:58 36040 8192000000 10229829616 10678763520 1324534432 13.918 98 23 43 0 1337270592 7949184 4786976
00:33:35 35994 8192000000 10247630208 10692923392 1339707376 14.055 99 11 21 0 1350059696 7512160 2840160
00:35:19 66038 8192000000 10225508384 10674270208 1316370352 13.844 97 16 32 0 1331208512 11123280 3714880
00:37:35 62934 8192000000 10251333712 10709254144 1351364176 14.160 100 6 12 0 1365235696 12497488 1374032
00:39:40 90191 8192000000 10253225376 10701463552 1293382752 13.635 94 13 24 0 1305871376 9307280 3181344
00:42:13 83357 8192000000 10300130176 10747355136 1366151056 14.293 99 18 34 1 1389003648 18813584 4039008
00:45:04 68116 8192000000 10288211488 10738884608 1352186112 14.167 97 19 39 0 1366602224 10216864 4199248
00:47:12 49794 8192000000 10305971168 10759835648 1390534896 14.511 99 36 66 3 1411650336 13521392 7594048
00:49:03 74311 8192000000 10309063232 10766745600 1376941248 14.389 98 17 34 0 1395876624 14802320 4133056
00:51:24 80230 8192000000 10305303712 10754605056 1387288896 14.482 99 16 31 2 1399848560 9688464 2871200
00:53:52 81036 8192000000 10304691632 10753130496 1378465952 14.403 98 40 78 0 1395620832 8453792 8701088
00:56:15 18507 8192000000 10291858272 10750681088 1389846624 14.504 100 22 43 0 1401256704 6704688 4705392
00:57:38 67977 8192000000 10247785376 10705760256 1311914256 13.803 94 11 22 0 1323314080 8460736 2939088
01:00:11 46377 8192000000 10268938560 10725146624 1352507136 14.170 98 9 18 0 1369004480 14866912 1630432
01:02:57 6775 8192000000 10262084864 10708807680 1360524416 14.242 100 46 93 0 1379310544 7176400 11609728
01:04:05 47349 8192000000 10265997008 10709016576 1314857024 13.830 96 28 56 0 1328910192 7170048 6883120
01:05:52 56046 8192000000 10265300096 10712711168 1324497728 13.917 97 23 46 0 1347706704 17929280 5279696
01:07:58 22621 8192000000 10219448240 10645315584 1295919632 13.658 98 44 88 0 1314233776 9036464 9277680
01:09:22 32886 8192000000 9507196976 9831034880 643778096 7.286 48 7 14 0 656999648 11581296 1640256

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:14, from 09-03-2024 01:10:59 to 09-03-2024 01:11:13.

Exceptions occured during test was in run

FB_MNEMONA CNT UNIT FB_GDSCODE
except 1 srv_aggregate_perf_data 335544517
except 127 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 09-03-2024 01:11:13 to 09-03-2024 01:11:15.

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          182477
MON$OLDEST_ACTIVE               182478
MON$OLDEST_SNAPSHOT             182478
MON$NEXT_TRANSACTION            182478
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                       1904800
MON$STAT_ID                     1
MON$BACKUP_STATE                0
MON$CRYPT_PAGE                  0
MON$OWNER                       SYSDBA                                                                                       
MON$SEC_DATABASE                Default


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

Database statistics 

 
Database "/home/bases/oltp30-etalone.fdb" 
Gstat execution time Sat Mar  9 01:11:16 2024 
 
Database header page information: 
    Flags            0 
    Generation        95176 
    System Change Number    0 
    Page size        8192 
    ODS version        12.0 
    Oldest transaction    182477 
    Oldest active        182478 
    Oldest snapshot        182478 
    Next transaction    182479 
    Sequence number        0 
    Next attachment ID    734 
    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.18, total records: 7813349 
    Average version length: 48.16, total versions: 116892, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 64.00, compression ratio: 1.36 
    Pointer pages: 54, data page slots: 86816 
    Data pages: 86816, average fill: 72% 
    Primary pages: 86816, secondary pages: 0, swept pages: 14549 
    Empty pages: 4, full pages: 72348 
    Fill distribution: 
     0 - 19% = 22 
    20 - 39% = 167 
    40 - 59% = 1601 
    60 - 79% = 84984 
    80 - 99% = 42 
 
    Index DOC_DATA_DOC_WARE_UNQ (0) 
    Root page: 1510614, depth: 3, leaf buckets: 23541, nodes: 7813349 
    Average node length: 18.91, total dup: 0, max dup: 0 
    Average key length: 15.92, compression ratio: 1.70 
    Average prefix length: 14.08, average data length: 12.92 
    Clustering factor: 1747687, ratio: 0.22 
    Fill distribution: 
         0 - 19% = 355 
        20 - 39% = 1782 
        40 - 59% = 4312 
        60 - 79% = 2320 
        80 - 99% = 14772 
 
    Index DOC_DATA_ID_DESC (1) 
    Root page: 1528118, depth: 3, leaf buckets: 13623, nodes: 7813349 
    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: 1569317, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 1581 
        40 - 59% = 2097 
        60 - 79% = 1087 
        80 - 99% = 8858 
 
    Index FK_DOC_DATA_DOC_LIST (2) 
    Root page: 1546711, depth: 3, leaf buckets: 8428, nodes: 7813349 
    Average node length: 6.63, total dup: 5826339, max dup: 49 
    Average key length: 3.64, compression ratio: 2.47 
    Average prefix length: 7.61, average data length: 1.39 
    Clustering factor: 1562269, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 143 
        20 - 39% = 909 
        40 - 59% = 1469 
        60 - 79% = 887 
        80 - 99% = 5020 
 
DOC_LIST (138) 
    Primary pointer page: 472, Index root page: 473 
    Total formats: 1, used formats: 1 
    Average record length: 55.86, total records: 2278240 
    Average version length: 34.45, total versions: 122494, max versions: 3 
    Average fragment length: 6.33, total fragments: 6, max fragments: 1 
    Average unpacked length: 84.00, compression ratio: 1.50 
    Pointer pages: 18, data page slots: 28304 
    Data pages: 28304, average fill: 75% 
    Primary pages: 28299, secondary pages: 5, swept pages: 8280 
    Empty pages: 2, full pages: 24036 
    Fill distribution: 
     0 - 19% = 14 
    20 - 39% = 104 
    40 - 59% = 1023 
    60 - 79% = 25751 
    80 - 99% = 1412 
 
    Index DOC_LIST_ID_DESC (1) 
    Root page: 1541130, depth: 3, leaf buckets: 4623, nodes: 2278240 
    Average node length: 11.40, total dup: 0, max dup: 0 
    Average key length: 8.44, compression ratio: 1.07 
    Average prefix length: 3.56, average data length: 5.44 
    Clustering factor: 710214, ratio: 0.31 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 922 
        40 - 59% = 879 
        60 - 79% = 711 
        80 - 99% = 2111 
 
    Index DOC_LIST_WORKER_OPTYPE (2) 
    Root page: 1544376, depth: 3, leaf buckets: 2540, nodes: 2281079 
    Average node length: 4.97, total dup: 2280181, max dup: 18921 
    Average key length: 2.01, compression ratio: 4.47 
    Average prefix length: 8.99, average data length: 0.01 
    Clustering factor: 1264139, ratio: 0.55 
    Fill distribution: 
         0 - 19% = 3 
        20 - 39% = 230 
        40 - 59% = 1556 
        60 - 79% = 566 
        80 - 99% = 185 
 
    Index FK_DOC_LIST_AGENTS (3) 
    Root page: 1545909, depth: 3, leaf buckets: 2047, nodes: 2278240 
    Average node length: 4.97, total dup: 2278190, max dup: 130519 
    Average key length: 2.01, compression ratio: 4.48 
    Average prefix length: 8.99, average data length: 0.01 
    Clustering factor: 1063945, ratio: 0.47 
    Fill distribution: 
         0 - 19% = 8 
        20 - 39% = 23 
        40 - 59% = 1143 
        60 - 79% = 62 
        80 - 99% = 811 
 
    Index PK_DOC_LIST (0) 
    Root page: 1538187, depth: 3, leaf buckets: 4409, nodes: 2278240 
    Average node length: 11.40, total dup: 0, max dup: 0 
    Average key length: 8.44, compression ratio: 1.07 
    Average prefix length: 3.56, average data length: 5.44 
    Clustering factor: 710214, ratio: 0.31 
    Fill distribution: 
         0 - 19% = 105 
        20 - 39% = 590 
        40 - 59% = 648 
        60 - 79% = 791 
        80 - 99% = 2275 
 
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.18, total records: 400 
    Average version length: 22.68, total versions: 246913, max versions: 651 
    Average fragment length: 2.00, total fragments: 62, max fragments: 1 
    Average unpacked length: 104.00, compression ratio: 1.27 
    Pointer pages: 1, data page slots: 1368 
    Data pages: 1368, average fill: 89% 
    Primary pages: 9, secondary pages: 1359, swept pages: 0 
    Empty pages: 2, full pages: 1365 
    Fill distribution: 
     0 - 19% = 2 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 2 
    80 - 99% = 1364 
 
    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: 12.72, total records: 71627 
    Average version length: 68.29, total versions: 58293, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 88.00, compression ratio: 6.92 
    Pointer pages: 6, data page slots: 1936 
    Data pages: 1704, average fill: 53% 
    Primary pages: 1703, secondary pages: 1, swept pages: 0 
    Empty pages: 296, full pages: 697 
    Fill distribution: 
     0 - 19% = 420 
    20 - 39% = 164 
    40 - 59% = 250 
    60 - 79% = 410 
    80 - 99% = 460 
 
    Index INVNT_TURNOVER_LOG_WARE_DD_ID (0) 
    Root page: 1698187, depth: 3, leaf buckets: 279, nodes: 71627 
    Average node length: 13.21, total dup: 5314, max dup: 2 
    Average key length: 10.77, compression ratio: 2.51 
    Average prefix length: 19.16, average data length: 7.84 
    Clustering factor: 52362, ratio: 0.73 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 132 
        40 - 59% = 128 
        60 - 79% = 18 
        80 - 99% = 0 
 
MONEY_SALDO (141) 
    Primary pointer page: 478, Index root page: 479 
    Total formats: 1, used formats: 1 
    Average record length: 15.22, total records: 49 
    Average version length: 9.00, total versions: 19090, max versions: 1051 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 32.00, compression ratio: 2.10 
    Pointer pages: 1, data page slots: 72 
    Data pages: 72, average fill: 85% 
    Primary pages: 6, secondary pages: 66, swept pages: 0 
    Empty pages: 5, full pages: 66 
    Fill distribution: 
     0 - 19% = 5 
    20 - 39% = 0 
    40 - 59% = 1 
    60 - 79% = 0 
    80 - 99% = 66 
 
    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: 6.25, total records: 2276 
    Average version length: 43.29, total versions: 1951, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 58.00, compression ratio: 9.28 
    Pointer pages: 1, data page slots: 112 
    Data pages: 32, average fill: 65% 
    Primary pages: 31, secondary pages: 1, swept pages: 0 
    Empty pages: 6, full pages: 21 
    Fill distribution: 
     0 - 19% = 8 
    20 - 39% = 1 
    40 - 59% = 0 
    60 - 79% = 4 
    80 - 99% = 19 
 
    Index MONEY_TURNOVER_LOG_AGENT_OPTYPE (0) 
    Root page: 89853, depth: 2, leaf buckets: 3, nodes: 2276 
    Average node length: 4.08, total dup: 2178, max dup: 259 
    Average key length: 2.46, compression ratio: 7.71 
    Average prefix length: 18.58, average data length: 0.42 
    Clustering factor: 1141, ratio: 0.50 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 2 
        60 - 79% = 0 
        80 - 99% = 0 
 
MON_CACHE_MEMORY (165) 
    Primary pointer page: 526, Index root page: 527 
    Total formats: 2, used formats: 1 
    Average record length: 97.11, total records: 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: 35.62, total records: 814122 
    Average version length: 25.23, total versions: 88094, max versions: 4 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 54.00, compression ratio: 1.52 
    Pointer pages: 5, data page slots: 8152 
    Data pages: 8152, average fill: 70% 
    Primary pages: 8129, secondary pages: 23, swept pages: 1063 
    Empty pages: 82, full pages: 7303 
    Fill distribution: 
     0 - 19% = 143 
    20 - 39% = 106 
    40 - 59% = 155 
    60 - 79% = 7394 
    80 - 99% = 354 
 
    Index PDISTR_AGENT_ID (2) 
    Root page: 1509308, depth: 2, leaf buckets: 897, nodes: 814122 
    Average node length: 4.87, total dup: 814073, max dup: 147563 
    Average key length: 2.01, compression ratio: 4.48 
    Average prefix length: 8.99, average data length: 0.01 
    Clustering factor: 90449, ratio: 0.11 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 106 
        40 - 59% = 524 
        60 - 79% = 212 
        80 - 99% = 53 
 
    Index PDISTR_SNDOP_RCVOP_SNDID_ASC (0) 
    Root page: 1508613, depth: 3, leaf buckets: 979, nodes: 814122 
    Average node length: 5.87, total dup: 725198, max dup: 42 
    Average key length: 3.01, compression ratio: 7.30 
    Average prefix length: 21.09, average data length: 0.91 
    Clustering factor: 161483, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 3 
        20 - 39% = 103 
        40 - 59% = 484 
        60 - 79% = 113 
        80 - 99% = 276 
 
    Index PDISTR_SNDOP_RCVOP_SNDID_DESC (1) 
    Root page: 1509187, depth: 3, leaf buckets: 1023, nodes: 814122 
    Average node length: 5.88, total dup: 725198, max dup: 42 
    Average key length: 3.02, compression ratio: 7.30 
    Average prefix length: 21.09, average data length: 0.91 
    Clustering factor: 163447, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 205 
        40 - 59% = 456 
        60 - 79% = 91 
        80 - 99% = 271 
 
    Index PDISTR_WORKER_SND_ID (3) 
    Root page: 1510178, depth: 3, leaf buckets: 1129, nodes: 814122 
    Average node length: 5.96, total dup: 725198, max dup: 42 
    Average key length: 3.09, compression ratio: 5.49 
    Average prefix length: 16.01, average data length: 0.99 
    Clustering factor: 156406, ratio: 0.19 
    Fill distribution: 
         0 - 19% = 7 
        20 - 39% = 212 
        40 - 59% = 586 
        60 - 79% = 226 
        80 - 99% = 98 
 
PERF_AGG (158) 
    Primary pointer page: 512, Index root page: 513 
    Total formats: 1, used formats: 1 
    Average record length: 62.77, total records: 5463 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 2.68, total fragments: 113, max fragments: 1 
    Average unpacked length: 379.00, compression ratio: 6.04 
    Pointer pages: 1, data page slots: 96 
    Data pages: 94, average fill: 58% 
    Primary pages: 72, secondary pages: 22, swept pages: 51 
    Empty pages: 8, full pages: 64 
    Fill distribution: 
     0 - 19% = 23 
    20 - 39% = 0 
    40 - 59% = 2 
    60 - 79% = 68 
    80 - 99% = 1 
 
    Index PERF_AGG_UNQ (1) 
    Root page: 1504238, depth: 2, leaf buckets: 6, nodes: 5463 
    Average node length: 5.52, total dup: 0, max dup: 0 
    Average key length: 3.59, compression ratio: 10.02 
    Average prefix length: 34.43, average data length: 1.55 
    Clustering factor: 5215, ratio: 0.95 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 0 
        40 - 59% = 4 
        60 - 79% = 1 
        80 - 99% = 1 
 
    Index PK_PERF_AGG (0) 
    Root page: 1504233, depth: 2, leaf buckets: 10, nodes: 5463 
    Average node length: 11.14, total dup: 0, max dup: 0 
    Average key length: 9.21, compression ratio: 0.98 
    Average prefix length: 2.79, average data length: 6.21 
    Clustering factor: 147, 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.09, total records: 83445 
    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: 808 
    Data pages: 808, average fill: 71% 
    Primary pages: 808, secondary pages: 0, swept pages: 0 
    Empty pages: 4, full pages: 803 
    Fill distribution: 
     0 - 19% = 4 
    20 - 39% = 1 
    40 - 59% = 0 
    60 - 79% = 803 
    80 - 99% = 0 
 
    Index PK_PERF_ESTIMATED (0) 
    Root page: 33740, depth: 2, leaf buckets: 109, nodes: 83445 
    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: 3459, ratio: 0.04 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 1 
        40 - 59% = 4 
        60 - 79% = 0 
        80 - 99% = 103 
 
PERF_ISQL_STAT (156) 
    Primary pointer page: 508, Index root page: 509 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index PERF_ISQL_STAT_TRN (0) 
    Root page: 1504239, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
PERF_LOG (159) 
    Primary pointer page: 514, Index root page: 515 
    Total formats: 1, used formats: 1 
    Average record length: 111.22, total records: 72 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1691.00, compression ratio: 15.20 
    Pointer pages: 1, data page slots: 2 
    Data pages: 2, average fill: 57% 
    Primary pages: 2, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 1 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 1 
    40 - 59% = 0 
    60 - 79% = 1 
    80 - 99% = 0 
 
PERF_SPLIT_0 (281) 
    Primary pointer page: 573, Index root page: 574 
    Total formats: 1, used formats: 1 
    Average record length: 119.92, total records: 185648 
    Average version length: 154.97, total versions: 38008, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 14.14 
    Pointer pages: 6, data page slots: 5040 
    Data pages: 4432, average fill: 88% 
    Primary pages: 4432, secondary pages: 0, swept pages: 1 
    Empty pages: 14, full pages: 4412 
    Fill distribution: 
     0 - 19% = 15 
    20 - 39% = 2 
    40 - 59% = 3 
    60 - 79% = 0 
    80 - 99% = 4412 
 
PERF_SPLIT_1 (282) 
    Primary pointer page: 576, Index root page: 577 
    Total formats: 1, used formats: 1 
    Average record length: 146.88, total records: 175799 
    Average version length: 152.28, total versions: 5212, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.55 
    Pointer pages: 7, data page slots: 5104 
    Data pages: 4192, average fill: 87% 
    Primary pages: 4192, secondary pages: 0, swept pages: 4 
    Empty pages: 13, full pages: 4168 
    Fill distribution: 
     0 - 19% = 14 
    20 - 39% = 6 
    40 - 59% = 0 
    60 - 79% = 5 
    80 - 99% = 4167 
 
PERF_SPLIT_2 (283) 
    Primary pointer page: 578, Index root page: 579 
    Total formats: 1, used formats: 1 
    Average record length: 146.30, total records: 167943 
    Average version length: 153.09, total versions: 5331, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.59 
    Pointer pages: 6, data page slots: 4480 
    Data pages: 4024, average fill: 86% 
    Primary pages: 4022, secondary pages: 2, swept pages: 2 
    Empty pages: 36, full pages: 3978 
    Fill distribution: 
     0 - 19% = 40 
    20 - 39% = 1 
    40 - 59% = 5 
    60 - 79% = 0 
    80 - 99% = 3978 
 
PERF_SPLIT_3 (284) 
    Primary pointer page: 580, Index root page: 581 
    Total formats: 1, used formats: 1 
    Average record length: 146.43, total records: 168838 
    Average version length: 152.54, total versions: 4927, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.58 
    Pointer pages: 6, data page slots: 5496 
    Data pages: 4120, average fill: 84% 
    Primary pages: 4119, secondary pages: 1, swept pages: 3 
    Empty pages: 109, full pages: 3987 
    Fill distribution: 
     0 - 19% = 111 
    20 - 39% = 7 
    40 - 59% = 11 
    60 - 79% = 4 
    80 - 99% = 3987 
 
PERF_SPLIT_4 (285) 
    Primary pointer page: 582, Index root page: 583 
    Total formats: 1, used formats: 1 
    Average record length: 145.93, total records: 147774 
    Average version length: 152.01, total versions: 4723, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.62 
    Pointer pages: 9, data page slots: 3944 
    Data pages: 3528, average fill: 86% 
    Primary pages: 3528, secondary pages: 0, swept pages: 1 
    Empty pages: 27, full pages: 3491 
    Fill distribution: 
     0 - 19% = 28 
    20 - 39% = 5 
    40 - 59% = 3 
    60 - 79% = 1 
    80 - 99% = 3491 
 
PERF_SPLIT_5 (286) 
    Primary pointer page: 584, Index root page: 585 
    Total formats: 1, used formats: 1 
    Average record length: 143.34, total records: 157696 
    Average version length: 153.35, total versions: 7817, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.83 
    Pointer pages: 6, data page slots: 6480 
    Data pages: 3848, average fill: 85% 
    Primary pages: 3848, secondary pages: 0, swept pages: 4 
    Empty pages: 94, full pages: 3719 
    Fill distribution: 
     0 - 19% = 99 
    20 - 39% = 12 
    40 - 59% = 14 
    60 - 79% = 5 
    80 - 99% = 3718 
 
PERF_SPLIT_6 (287) 
    Primary pointer page: 586, Index root page: 587 
    Total formats: 1, used formats: 1 
    Average record length: 147.41, total records: 186239 
    Average version length: 151.52, total versions: 4863, 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: 6, data page slots: 5544 
    Data pages: 4456, average fill: 86% 
    Primary pages: 4456, secondary pages: 0, swept pages: 4 
    Empty pages: 27, full pages: 4416 
    Fill distribution: 
     0 - 19% = 30 
    20 - 39% = 6 
    40 - 59% = 1 
    60 - 79% = 2 
    80 - 99% = 4417 
 
PERF_SPLIT_7 (288) 
    Primary pointer page: 588, Index root page: 589 
    Total formats: 1, used formats: 1 
    Average record length: 145.75, total records: 180876 
    Average version length: 153.24, total versions: 6507, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.64 
    Pointer pages: 7, data page slots: 5960 
    Data pages: 4344, average fill: 86% 
    Primary pages: 4344, secondary pages: 0, swept pages: 9 
    Empty pages: 41, full pages: 4283 
    Fill distribution: 
     0 - 19% = 45 
    20 - 39% = 5 
    40 - 59% = 7 
    60 - 79% = 7 
    80 - 99% = 4280 
 
PERF_SPLIT_8 (289) 
    Primary pointer page: 590, Index root page: 591 
    Total formats: 1, used formats: 1 
    Average record length: 144.85, total records: 174899 
    Average version length: 153.16, total versions: 7159, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.71 
    Pointer pages: 7, data page slots: 5320 
    Data pages: 4184, average fill: 86% 
    Primary pages: 4184, secondary pages: 0, swept pages: 1 
    Empty pages: 29, full pages: 4141 
    Fill distribution: 
     0 - 19% = 33 
    20 - 39% = 6 
    40 - 59% = 2 
    60 - 79% = 2 
    80 - 99% = 4141 
 
PERF_SPLIT_9 (290) 
    Primary pointer page: 593, Index root page: 594 
    Total formats: 1, used formats: 1 
    Average record length: 147.56, total records: 177500 
    Average version length: 151.85, total versions: 4462, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.49 
    Pointer pages: 7, data page slots: 5272 
    Data pages: 4256, average fill: 86% 
    Primary pages: 4256, secondary pages: 0, swept pages: 4 
    Empty pages: 34, full pages: 4209 
    Fill distribution: 
     0 - 19% = 35 
    20 - 39% = 5 
    40 - 59% = 4 
    60 - 79% = 3 
    80 - 99% = 4209 
 
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.44, total records: 2128675 
    Average version length: 53.03, total versions: 53049, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 70.00, compression ratio: 1.36 
    Pointer pages: 16, data page slots: 25696 
    Data pages: 25696, average fill: 71% 
    Primary pages: 25696, secondary pages: 0, swept pages: 9471 
    Empty pages: 300, full pages: 21938 
    Fill distribution: 
     0 - 19% = 560 
    20 - 39% = 414 
    40 - 59% = 956 
    60 - 79% = 23247 
    80 - 99% = 519 
 
    Index PSTORNED_RCV_ID (1) 
    Root page: 1506186, depth: 3, leaf buckets: 2585, nodes: 2128675 
    Average node length: 5.44, total dup: 1987050, max dup: 1406 
    Average key length: 2.48, compression ratio: 3.62 
    Average prefix length: 8.58, average data length: 0.42 
    Clustering factor: 184210, ratio: 0.09 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 274 
        40 - 59% = 1663 
        60 - 79% = 339 
        80 - 99% = 307 
 
    Index PSTORNED_SND_ID (0) 
    Root page: 1504819, depth: 3, leaf buckets: 2764, nodes: 2128675 
    Average node length: 5.69, total dup: 1911016, max dup: 71 
    Average key length: 2.74, compression ratio: 3.29 
    Average prefix length: 8.37, average data length: 0.63 
    Clustering factor: 380707, ratio: 0.18 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 3 
        40 - 59% = 2365 
        60 - 79% = 366 
        80 - 99% = 30 
 
    Index PSTORNED_WORKER_ID (2) 
    Root page: 1507996, depth: 3, leaf buckets: 2178, nodes: 2128675 
    Average node length: 4.96, total dup: 2128575, max dup: 28114 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.42, average data length: 0.00 
    Clustering factor: 181666, ratio: 0.09 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 191 
        40 - 59% = 1192 
        60 - 79% = 393 
        80 - 99% = 400 
 
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: 35.35, total records: 150560 
    Average version length: 69.18, total versions: 73686, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 3.56 
    Pointer pages: 3, data page slots: 4080 
    Data pages: 2888, average fill: 61% 
    Primary pages: 2888, secondary pages: 0, swept pages: 344 
    Empty pages: 514, full pages: 1967 
    Fill distribution: 
     0 - 19% = 687 
    20 - 39% = 69 
    40 - 59% = 37 
    60 - 79% = 752 
    80 - 99% = 1343 
 
    Index XQD_1000_1200_WA_SO_RO_WKR_SND (0) 
    Root page: 98549, depth: 3, leaf buckets: 217, nodes: 150560 
    Average node length: 6.44, total dup: 131013, max dup: 14 
    Average key length: 3.95, compression ratio: 10.64 
    Average prefix length: 40.18, average data length: 1.82 
    Clustering factor: 26061, ratio: 0.17 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 32 
        40 - 59% = 107 
        60 - 79% = 55 
        80 - 99% = 23 
 
XQD_1000_3300 (178) 
    Primary pointer page: 553, Index root page: 554 
    Total formats: 1, used formats: 1 
    Average record length: 63.98, total records: 7208827 
    Average version length: 68.79, total versions: 519662, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.97 
    Pointer pages: 63, data page slots: 101912 
    Data pages: 101912, average fill: 76% 
    Primary pages: 101912, secondary pages: 0, swept pages: 15742 
    Empty pages: 14, full pages: 89918 
    Fill distribution: 
     0 - 19% = 93 
    20 - 39% = 795 
    40 - 59% = 4128 
    60 - 79% = 86759 
    80 - 99% = 10137 
 
    Index XQD_1000_3300_WA_SO_RO_WKR_SND (0) 
    Root page: 1480454, depth: 3, leaf buckets: 10683, nodes: 7208827 
    Average node length: 6.50, total dup: 6238956, max dup: 29 
    Average key length: 3.51, compression ratio: 11.95 
    Average prefix length: 40.62, average data length: 1.38 
    Clustering factor: 1608152, ratio: 0.22 
    Fill distribution: 
         0 - 19% = 12 
        20 - 39% = 1498 
        40 - 59% = 5718 
        60 - 79% = 2745 
        80 - 99% = 710 
 
    Index XQD_1000_3300_WKR_DOC_ASC (1) 
    Root page: 1486068, depth: 3, leaf buckets: 8613, nodes: 7208827 
    Average node length: 5.39, total dup: 6924622, max dup: 192 
    Average key length: 2.40, compression ratio: 7.08 
    Average prefix length: 16.64, average data length: 0.36 
    Clustering factor: 1398266, ratio: 0.19 
    Fill distribution: 
         0 - 19% = 15 
        20 - 39% = 1194 
        40 - 59% = 4630 
        60 - 79% = 1753 
        80 - 99% = 1021 
 
    Index XQD_1000_3300_WKR_DOC_DEC (2) 
    Root page: 1490608, depth: 3, leaf buckets: 8722, nodes: 7208827 
    Average node length: 5.39, total dup: 6924622, max dup: 192 
    Average key length: 2.40, compression ratio: 7.08 
    Average prefix length: 16.64, average data length: 0.36 
    Clustering factor: 1400931, ratio: 0.19 
    Fill distribution: 
         0 - 19% = 4 
        20 - 39% = 1295 
        40 - 59% = 4705 
        60 - 79% = 1739 
        80 - 99% = 979 
 
XQD_1200_2000 (177) 
    Primary pointer page: 551, Index root page: 552 
    Total formats: 1, used formats: 1 
    Average record length: 66.32, total records: 12181146 
    Average version length: 68.73, total versions: 464093, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.90 
    Pointer pages: 104, data page slots: 168152 
    Data pages: 168152, average fill: 77% 
    Primary pages: 168152, secondary pages: 0, swept pages: 61372 
    Empty pages: 10, full pages: 162411 
    Fill distribution: 
     0 - 19% = 56 
    20 - 39% = 358 
    40 - 59% = 1795 
    60 - 79% = 155446 
    80 - 99% = 10497 
 
    Index XQD_1200_2000_WA_SO_RO_WKR_SND (0) 
    Root page: 1495028, depth: 3, leaf buckets: 18382, nodes: 12181146 
    Average node length: 6.58, total dup: 10620487, max dup: 65 
    Average key length: 3.42, compression ratio: 12.27 
    Average prefix length: 40.70, average data length: 1.30 
    Clustering factor: 2402864, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 25 
        20 - 39% = 2175 
        40 - 59% = 10809 
        60 - 79% = 4463 
        80 - 99% = 910 
 
XQD_2000_3300 (179) 
    Primary pointer page: 555, Index root page: 556 
    Total formats: 1, used formats: 1 
    Average record length: 38.45, total records: 1827265 
    Average version length: 69.13, total versions: 811138, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 3.28 
    Pointer pages: 26, data page slots: 41144 
    Data pages: 26040, average fill: 81% 
    Primary pages: 26040, secondary pages: 0, swept pages: 1813 
    Empty pages: 646, full pages: 24429 
    Fill distribution: 
     0 - 19% = 861 
    20 - 39% = 309 
    40 - 59% = 263 
    60 - 79% = 9646 
    80 - 99% = 14961 
 
    Index XQD_2000_3300_WA_SO_RO_WKR_SND (0) 
    Root page: 1479712, depth: 3, leaf buckets: 2109, nodes: 1827265 
    Average node length: 5.50, total dup: 1753991, max dup: 99 
    Average key length: 2.54, compression ratio: 16.50 
    Average prefix length: 41.49, average data length: 0.51 
    Clustering factor: 126809, ratio: 0.07 
    Fill distribution: 
         0 - 19% = 16 
        20 - 39% = 146 
        40 - 59% = 1002 
        60 - 79% = 668 
        80 - 99% = 277 
 
XQD_2100_3300 (180) 
    Primary pointer page: 557, Index root page: 558 
    Total formats: 1, used formats: 1 
    Average record length: 37.25, total records: 1202832 
    Average version length: 69.14, total versions: 553633, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 3.38 
    Pointer pages: 20, data page slots: 32464 
    Data pages: 27856, average fill: 50% 
    Primary pages: 27856, secondary pages: 0, swept pages: 5000 
    Empty pages: 5486, full pages: 14138 
    Fill distribution: 
     0 - 19% = 9420 
    20 - 39% = 1909 
    40 - 59% = 984 
    60 - 79% = 6006 
    80 - 99% = 9537 
 
    Index XQD_2100_3300_WA_SO_RO_WKR_SND (0) 
    Root page: 1479207, depth: 3, leaf buckets: 1602, nodes: 1202832 
    Average node length: 5.76, total dup: 1126165, max dup: 109 
    Average key length: 2.82, compression ratio: 14.91 
    Average prefix length: 41.25, average data length: 0.75 
    Clustering factor: 159534, ratio: 0.13 
    Fill distribution: 
         0 - 19% = 5 
        20 - 39% = 320 
        40 - 59% = 739 
        60 - 79% = 412 
        80 - 99% = 126 
 
XQD_3300_3400 (181) 
    Primary pointer page: 559, Index root page: 560 
    Total formats: 1, used formats: 1 
    Average record length: 64.73, total records: 9375190 
    Average version length: 68.98, total versions: 567113, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.95 
    Pointer pages: 89, data page slots: 144064 
    Data pages: 144016, average fill: 70% 
    Primary pages: 144015, secondary pages: 1, swept pages: 43681 
    Empty pages: 284, full pages: 90838 
    Fill distribution: 
     0 - 19% = 1088 
    20 - 39% = 6256 
    40 - 59% = 21505 
    60 - 79% = 104318 
    80 - 99% = 10849 
 
    Index XQD_3300_3400_WA_SO_RO_WKR_SND (0) 
    Root page: 1472590, depth: 3, leaf buckets: 13522, nodes: 9375190 
    Average node length: 6.68, total dup: 7779042, max dup: 21 
    Average key length: 3.66, compression ratio: 11.47 
    Average prefix length: 40.51, average data length: 1.49 
    Clustering factor: 2018846, ratio: 0.22 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 1176 
        40 - 59% = 6680 
        60 - 79% = 4819 
        80 - 99% = 845 
 
XQS_1000_1200 (182) 
    Primary pointer page: 561, Index root page: 562 
    Total formats: 1, used formats: 1 
    Average record length: 82.48, total records: 21206067 
    Average version length: 82.95, total versions: 16482, 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: 319416 
    Data pages: 319416, average fill: 81% 
    Primary pages: 319416, secondary pages: 0, swept pages: 11186 
    Empty pages: 1, full pages: 319415 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 26736 
    80 - 99% = 292679 
 
    Index XQS_1000_1200_DOC_ID (1) 
    Root page: 1426716, depth: 3, leaf buckets: 19395, nodes: 21206067 
    Average node length: 5.72, total dup: 20723892, max dup: 128 
    Average key length: 2.16, compression ratio: 4.16 
    Average prefix length: 8.86, average data length: 0.14 
    Clustering factor: 3290002, ratio: 0.16 
    Fill distribution: 
         0 - 19% = 4 
        20 - 39% = 0 
        40 - 59% = 8091 
        60 - 79% = 564 
        80 - 99% = 10736 
 
    Index XQS_1000_1200_RCV_ID (3) 
    Root page: 1456980, depth: 3, leaf buckets: 17253, nodes: 21206067 
    Average node length: 6.31, total dup: 18634983, max dup: 49 
    Average key length: 2.75, compression ratio: 3.27 
    Average prefix length: 8.37, average data length: 0.63 
    Clustering factor: 918532, ratio: 0.04 
    Fill distribution: 
         0 - 19% = 3 
        20 - 39% = 5 
        40 - 59% = 851 
        60 - 79% = 275 
        80 - 99% = 16119 
 
    Index XQS_1000_1200_SND_ID (2) 
    Root page: 1441073, depth: 3, leaf buckets: 21170, nodes: 21206067 
    Average node length: 6.35, total dup: 18554908, max dup: 29 
    Average key length: 2.79, compression ratio: 3.23 
    Average prefix length: 8.34, average data length: 0.66 
    Clustering factor: 3585458, ratio: 0.17 
    Fill distribution: 
         0 - 19% = 9 
        20 - 39% = 0 
        40 - 59% = 8311 
        60 - 79% = 648 
        80 - 99% = 12202 
 
    Index XQS_1000_1200_WORKER_ID (0) 
    Root page: 1413348, depth: 3, leaf buckets: 16206, nodes: 21206067 
    Average node length: 5.56, total dup: 21205967, max dup: 229126 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.42, average data length: 0.00 
    Clustering factor: 947285, ratio: 0.04 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 7 
        40 - 59% = 3024 
        60 - 79% = 414 
        80 - 99% = 12761 
 
XQS_1000_3300 (184) 
    Primary pointer page: 565, Index root page: 566 
    Total formats: 1, used formats: 1 
    Average record length: 77.79, total records: 9819154 
    Average version length: 82.68, total versions: 551520, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.62 
    Pointer pages: 106, data page slots: 172304 
    Data pages: 172240, average fill: 71% 
    Primary pages: 172240, secondary pages: 0, swept pages: 63554 
    Empty pages: 620, full pages: 105679 
    Fill distribution: 
     0 - 19% = 1857 
    20 - 39% = 8280 
    40 - 59% = 26032 
    60 - 79% = 67026 
    80 - 99% = 69045 
 
    Index XQS_1000_3300_DOC_ID (1) 
    Root page: 1367502, depth: 3, leaf buckets: 11406, nodes: 9819154 
    Average node length: 5.37, total dup: 9509523, max dup: 191 
    Average key length: 2.23, compression ratio: 4.04 
    Average prefix length: 8.80, average data length: 0.20 
    Clustering factor: 2150840, ratio: 0.22 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 58 
        40 - 59% = 8049 
        60 - 79% = 3185 
        80 - 99% = 112 
 
    Index XQS_1000_3300_RCV_ID (3) 
    Root page: 1379261, depth: 3, leaf buckets: 13687, nodes: 9819154 
    Average node length: 6.24, total dup: 8141933, max dup: 14 
    Average key length: 3.10, compression ratio: 2.90 
    Average prefix length: 8.07, average data length: 0.93 
    Clustering factor: 1487558, ratio: 0.15 
    Fill distribution: 
         0 - 19% = 136 
        20 - 39% = 3934 
        40 - 59% = 4469 
        60 - 79% = 2685 
        80 - 99% = 2463 
 
    Index XQS_1000_3300_SND_ID (2) 
    Root page: 1373059, depth: 3, leaf buckets: 12736, nodes: 9819154 
    Average node length: 5.98, total dup: 8525017, max dup: 55 
    Average key length: 2.85, compression ratio: 3.16 
    Average prefix length: 8.29, average data length: 0.71 
    Clustering factor: 2343849, ratio: 0.24 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 78 
        40 - 59% = 9010 
        60 - 79% = 3516 
        80 - 99% = 130 
 
    Index XQS_1000_3300_WORKER_ID (0) 
    Root page: 1362767, depth: 3, leaf buckets: 10172, nodes: 9819154 
    Average node length: 5.14, total dup: 9819054, max dup: 154050 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.42, average data length: 0.00 
    Clustering factor: 1533417, ratio: 0.16 
    Fill distribution: 
         0 - 19% = 49 
        20 - 39% = 1219 
        40 - 59% = 5038 
        60 - 79% = 1657 
        80 - 99% = 2209 
 
XQS_1200_2000 (183) 
    Primary pointer page: 563, Index root page: 564 
    Total formats: 1, used formats: 1 
    Average record length: 79.36, total records: 11456562 
    Average version length: 82.62, total versions: 409462, 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: 118, data page slots: 192216 
    Data pages: 190744, average fill: 74% 
    Primary pages: 190744, secondary pages: 0, swept pages: 63780 
    Empty pages: 2857, full pages: 148365 
    Fill distribution: 
     0 - 19% = 4688 
    20 - 39% = 6650 
    40 - 59% = 16301 
    60 - 79% = 39741 
    80 - 99% = 123364 
 
    Index XQS_1200_2000_DOC_ID (1) 
    Root page: 1392101, depth: 3, leaf buckets: 13132, nodes: 11456562 
    Average node length: 5.29, total dup: 11346459, max dup: 652 
    Average key length: 2.08, compression ratio: 4.33 
    Average prefix length: 8.93, average data length: 0.07 
    Clustering factor: 2395302, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 3 
        20 - 39% = 105 
        40 - 59% = 8850 
        60 - 79% = 3986 
        80 - 99% = 188 
 
    Index XQS_1200_2000_RCV_ID (3) 
    Root page: 1406110, depth: 3, leaf buckets: 10551, nodes: 11456562 
    Average node length: 5.49, total dup: 10957326, max dup: 49 
    Average key length: 2.28, compression ratio: 3.95 
    Average prefix length: 8.77, average data length: 0.23 
    Clustering factor: 728937, ratio: 0.06 
    Fill distribution: 
         0 - 19% = 162 
        20 - 39% = 838 
        40 - 59% = 2608 
        60 - 79% = 1839 
        80 - 99% = 5104 
 
    Index XQS_1200_2000_SND_ID (2) 
    Root page: 1398638, depth: 3, leaf buckets: 15017, nodes: 11456562 
    Average node length: 6.02, total dup: 10000449, max dup: 69 
    Average key length: 2.80, compression ratio: 3.21 
    Average prefix length: 8.32, average data length: 0.68 
    Clustering factor: 2411845, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 3 
        20 - 39% = 127 
        40 - 59% = 10330 
        60 - 79% = 4330 
        80 - 99% = 227 
 
    Index XQS_1200_2000_WORKER_ID (0) 
    Root page: 1386211, depth: 3, leaf buckets: 10859, nodes: 11456562 
    Average node length: 5.22, total dup: 11456462, max dup: 205787 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.42, average data length: 0.00 
    Clustering factor: 717492, ratio: 0.06 
    Fill distribution: 
         0 - 19% = 86 
        20 - 39% = 764 
        40 - 59% = 4934 
        60 - 79% = 1476 
        80 - 99% = 3599 
 
XQS_2000_3300 (185) 
    Primary pointer page: 567, Index root page: 568 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index XQS_2000_3300_DOC_ID (1) 
    Root page: 1361753, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index XQS_2000_3300_RCV_ID (3) 
    Root page: 1361755, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index XQS_2000_3300_SND_ID (2) 
    Root page: 1361754, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index XQS_2000_3300_WORKER_ID (0) 
    Root page: 1361752, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
XQS_2100_3300 (186) 
    Primary pointer page: 569, Index root page: 570 
    Total formats: 1, used formats: 1 
    Average record length: 78.12, total records: 9936957 
    Average version length: 82.93, total versions: 555183, 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: 107, data page slots: 174568 
    Data pages: 174536, average fill: 71% 
    Primary pages: 174536, secondary pages: 0, swept pages: 66718 
    Empty pages: 483, full pages: 103459 
    Fill distribution: 
     0 - 19% = 1549 
    20 - 39% = 7376 
    40 - 59% = 26483 
    60 - 79% = 73409 
    80 - 99% = 65719 
 
    Index XQS_2100_3300_DOC_ID (1) 
    Root page: 1344686, depth: 3, leaf buckets: 12010, nodes: 9936957 
    Average node length: 5.18, total dup: 9907974, max dup: 2331 
    Average key length: 2.03, compression ratio: 4.43 
    Average prefix length: 8.97, average data length: 0.03 
    Clustering factor: 1955680, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 43 
        20 - 39% = 1494 
        40 - 59% = 8020 
        60 - 79% = 1839 
        80 - 99% = 614 
 
    Index XQS_2100_3300_RCV_ID (3) 
    Root page: 1355717, depth: 3, leaf buckets: 13831, nodes: 9936957 
    Average node length: 6.25, total dup: 8239042, max dup: 14 
    Average key length: 3.10, compression ratio: 2.90 
    Average prefix length: 8.07, average data length: 0.93 
    Clustering factor: 1456187, ratio: 0.15 
    Fill distribution: 
         0 - 19% = 210 
        20 - 39% = 3953 
        40 - 59% = 4383 
        60 - 79% = 2680 
        80 - 99% = 2605 
 
    Index XQS_2100_3300_SND_ID (2) 
    Root page: 1350049, depth: 3, leaf buckets: 12650, nodes: 9936957 
    Average node length: 5.43, total dup: 9493576, max dup: 99 
    Average key length: 2.29, compression ratio: 3.94 
    Average prefix length: 8.76, average data length: 0.24 
    Clustering factor: 2091282, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 31 
        20 - 39% = 1468 
        40 - 59% = 8913 
        60 - 79% = 1660 
        80 - 99% = 578 
 
    Index XQS_2100_3300_WORKER_ID (0) 
    Root page: 985805, depth: 3, leaf buckets: 10361, nodes: 9936957 
    Average node length: 5.15, total dup: 9936857, max dup: 155760 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.42, average data length: 0.00 
    Clustering factor: 1545587, ratio: 0.16 
    Fill distribution: 
         0 - 19% = 49 
        20 - 39% = 1329 
        40 - 59% = 5139 
        60 - 79% = 1585 
        80 - 99% = 2259 
 
XQS_3300_3400 (187) 
    Primary pointer page: 571, Index root page: 572 
    Total formats: 1, used formats: 1 
    Average record length: 67.36, total records: 580678 
    Average version length: 68.85, total versions: 6981, 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: 8032 
    Data pages: 8032, average fill: 76% 
    Primary pages: 8032, secondary pages: 0, swept pages: 3475 
    Empty pages: 11, full pages: 7074 
    Fill distribution: 
     0 - 19% = 12 
    20 - 39% = 21 
    40 - 59% = 196 
    60 - 79% = 7673 
    80 - 99% = 130 
 
    Index XQS_3300_3400_DOC_ID (1) 
    Root page: 37168, depth: 3, leaf buckets: 743, nodes: 580678 
    Average node length: 5.95, total dup: 494433, max dup: 83 
    Average key length: 3.09, compression ratio: 2.91 
    Average prefix length: 8.06, average data length: 0.94 
    Clustering factor: 101131, ratio: 0.17 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 31 
        40 - 59% = 514 
        60 - 79% = 109 
        80 - 99% = 88 
 
    Index XQS_3300_3400_SND_ID (2) 
    Root page: 25642, depth: 3, leaf buckets: 772, nodes: 580678 
    Average node length: 6.15, total dup: 476244, max dup: 25 
    Average key length: 3.29, compression ratio: 2.73 
    Average prefix length: 7.89, average data length: 1.11 
    Clustering factor: 101184, ratio: 0.17 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 33 
        40 - 59% = 549 
        60 - 79% = 101 
        80 - 99% = 89 
 
    Index XQS_3300_3400_WORKER_ID (0) 
    Root page: 375548, depth: 2, leaf buckets: 585, nodes: 580678 
    Average node length: 4.86, total dup: 580578, max dup: 9805 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.42, average data length: 0.00 
    Clustering factor: 89755, ratio: 0.15 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 28 
        40 - 59% = 351 
        60 - 79% = 104 
        80 - 99% = 102 
 
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 Sat Mar  9 01:11:40 2024

Record versions statistics, table

TABLE_NAME TOTAL_RECS TOTAL_VERS MAX_VERSIONS VERS_TO_RECS_PRC MAXV_TO_VERS_PRC
DOC_DATA 7813349 116892 1 0.0000 0.0000
DOC_LIST 2278240 122494 3 0.0000 0.0000
FB_ERRORS 2182 757 1 0.0000 0.0000
INVNT_SALDO 400 246913 651 61700.0000 0.0000
INVNT_TURNOVER_LOG 71627 58293 1 0.0000 0.0000
MONEY_SALDO 49 19090 1051 38900.0000 0.0000
MONEY_TURNOVER_LOG 2276 1951 1 0.0000 0.0000
PDISTR 814122 88094 4 0.0000 0.0000
PERF_SPLIT_0 185648 38008 1 0.0000 0.0000
PERF_SPLIT_1 175799 5212 1 0.0000 0.0000
PERF_SPLIT_2 167943 5331 1 0.0000 0.0000
PERF_SPLIT_3 168838 4927 1 0.0000 0.0000
PERF_SPLIT_4 147774 4723 1 0.0000 0.0000
PERF_SPLIT_5 157696 7817 1 0.0000 0.0000
PERF_SPLIT_6 186239 4863 1 0.0000 0.0000
PERF_SPLIT_7 180876 6507 1 0.0000 0.0000
PERF_SPLIT_8 174899 7159 1 0.0000 0.0000
PERF_SPLIT_9 177500 4462 1 0.0000 0.0000
PSTORNED 2128675 53049 1 0.0000 0.0000
SEMAPHORES 5 1 1 0.0000 100.0000
XQD_1000_1200 150560 73686 1 0.0000 0.0000
XQD_1000_3300 7208827 519662 1 0.0000 0.0000
XQD_1200_2000 12181146 464093 1 0.0000 0.0000
XQD_2000_3300 1827265 811138 1 0.0000 0.0000
XQD_2100_3300 1202832 553633 1 0.0000 0.0000
XQD_3300_3400 9375190 567113 1 0.0000 0.0000
XQS_1000_1200 21206067 16482 1 0.0000 0.0000
XQS_1000_3300 9819154 551520 1 0.0000 0.0000
XQS_1200_2000 11456562 409462 1 0.0000 0.0000
XQS_2100_3300 9936957 555183 1 0.0000 0.0000
XQS_3300_3400 580678 6981 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 ---
:165: 
:166: mscs-test-161.budzdorov.ru    Sat Mar  9 01:10:02 2024
:167:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:168: 
--- end of diff output ---

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

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