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

Hardware and OS info

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

Server and database settinfs 


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

Test configuration settings 

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

Test finish info 


FINISH_STATE                    NORMAL: TEST_TIME EXPIRED AT 2024-02-22 13:07:50
DTS_END                         2024-02-22 13:07:50.6440
FB_GDSCODE                      -1
FB_MNEMONA                      
STACK                           SP_CLIENT_ORDER(57:5) ==> SP_CHECK_TO_STOP_WORK(32:12) ==> SP_HALT_ON_ERROR(68:17)
IP                              ::1/35138
TRN_ID                          174238
ATT_ID                          589
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: 9353.22 20829 935322
customer order: creation 179.90 373 17990
customer order: refuse 16.40 352 1640
order to supplier: creation 47.89 1285 4789
order to supplier: removal 3.94 91264 394
invoice (draft): creation 48.94 3110 4894
invoice (draft): removal 50.88 699 5088
invoice accept: apply 43.18 21416 4318
invoice accept: cancel 45.55 835 4555
customer reserve: creation 4171.60 204 417160
customer reserve: removal 4443.79 66 444379
realization accept: apply 88.17 190 8817
realization accept: cancel 78.89 148 7889
payment from customer: creation 61.82 119 6182
payment from customer: removal 6.22 59 622
payment to supplier: creation 51.35 129 5135
payment to supplier: removal 3.71 90 371
service: total inventory turnovers 3.75 4188 375
service: total monetary turnovers 6.30 570 630
service: aggregate perf. data 0.91 11483 91
service: refresh index statistics 0.03 279997 3

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:03, from 22-02-2024 13:09:43 to 22-02-2024 13:09:46.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 5717
TEST_TIME 2 5369
TEST_TIME 3 5867
TEST_TIME 4 5443
TEST_TIME 5 5853
TEST_TIME 6 5717
TEST_TIME 7 5866
TEST_TIME 8 5944
TEST_TIME 9 6106
TEST_TIME 10 6499
TEST_TIME 11 6509
TEST_TIME 12 6876
TEST_TIME 13 6915
TEST_TIME 14 7019
TEST_TIME 15 7452
TEST_TIME 16 7604
TEST_TIME 17 7534
TEST_TIME 18 7909
TEST_TIME 19 7816
TEST_TIME 20 7885
TEST_TIME 21 8407
TEST_TIME 22 8585
TEST_TIME 23 8885
TEST_TIME 24 9086
TEST_TIME 25 9638
TEST_TIME 26 10741
TEST_TIME 27 10705
TEST_TIME 28 10687
TEST_TIME 29 10604
TEST_TIME 30 10361
TEST_TIME 31 10160
TEST_TIME 32 9962
TEST_TIME 33 10108
TEST_TIME 34 10001
TEST_TIME 35 9826
TEST_TIME 36 9825
TEST_TIME 37 9830
TEST_TIME 38 9759
TEST_TIME 39 9871
TEST_TIME 40 9960
TEST_TIME 41 9852
TEST_TIME 42 9759
TEST_TIME 43 9737
TEST_TIME 44 9786
TEST_TIME 45 9813
TEST_TIME 46 9842
TEST_TIME 47 9901
TEST_TIME 48 9983
TEST_TIME 49 9911
TEST_TIME 50 10037
TEST_TIME 51 10085
TEST_TIME 52 10004
TEST_TIME 53 9981
TEST_TIME 54 10039
TEST_TIME 55 10060
TEST_TIME 56 9948
TEST_TIME 57 9832
TEST_TIME 58 9770
TEST_TIME 59 9708
TEST_TIME 60 9684
TEST_TIME 61 9665
TEST_TIME 62 9622
TEST_TIME 63 9578
TEST_TIME 64 9514
TEST_TIME 65 9515
TEST_TIME 66 9530
TEST_TIME 67 9514
TEST_TIME 68 9535
TEST_TIME 69 9588
TEST_TIME 70 9628
TEST_TIME 71 9651
TEST_TIME 72 9638
TEST_TIME 73 9660
TEST_TIME 74 9678
TEST_TIME 75 9753
TEST_TIME 76 9660
TEST_TIME 77 9555
TEST_TIME 78 9536
TEST_TIME 79 9522
TEST_TIME 80 9455
TEST_TIME 81 9440
TEST_TIME 82 9446
TEST_TIME 83 9423
TEST_TIME 84 9454
TEST_TIME 85 9452
TEST_TIME 86 9451
TEST_TIME 87 9454
TEST_TIME 88 9464
TEST_TIME 89 9515
TEST_TIME 90 9500
TEST_TIME 91 9537
TEST_TIME 92 9541
TEST_TIME 93 9532
TEST_TIME 94 9597
TEST_TIME 95 9566
TEST_TIME 96 9565
TEST_TIME 97 9487
TEST_TIME 98 9464
TEST_TIME 99 9439
TEST_TIME 100 9361

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:03, from 22-02-2024 13:09:47 to 22-02-2024 13:09:50.

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 1317532 1317532 0 0.00 0 24953 8 0 0
doc_list_biud 1317530 1317530 0 0.00 0 24562 27 0 0
sp_add_invoice_to_stock 4431 4318 113 2.55 46 213011 21417 0 113
sp_cancel_adding_invoice 4555 4555 0 0.00 5 58145 836 0 0
sp_cancel_client_order 1640 1640 0 0.00 4 6168 352 0 0
sp_cancel_customer_reserve 444379 444379 0 0.00 0 21572 66 0 0
sp_cancel_pay_from_customer 622 622 0 0.00 2 2619 59 0 0
sp_cancel_pay_to_supplier 371 371 0 0.00 2 4738 91 0 0
sp_cancel_supplier_invoice 5096 5088 8 0.15 2 20121 699 0 8
sp_cancel_supplier_order 394 394 0 0.00 5 1011210 91264 0 0
sp_cancel_write_off 7889 7889 0 0.00 1 11192 149 0 0
sp_client_order 17990 17990 0 0.00 3 16226 373 0 0
sp_customer_reserve 417160 417160 0 0.00 0 49281 205 0 0
sp_fill_shopping_cart 27641 27641 0 0.00 1 14563 35 0 0
sp_fill_shopping_cart_clo_res 417141 417141 0 0.00 0 13406 15 0 0
sp_get_clo_for_invoice 4298 4298 0 0.00 0 22465 315 0 0
sp_kill_cost_storno 13437 13437 0 0.00 0 5789 68 0 0
sp_kill_qstorno_ret_qs2qd 902129 902129 0 0.00 0 21568 35 0 0
sp_kill_qty_storno 477059 477059 0 0.00 0 24562 75 0 0
sp_lock_selected_doc 18464 18464 0 0.00 0 6133 3 0 0
sp_make_cost_storno 24431 24431 0 0.00 0 14218 63 0 0
sp_multiply_rows_for_pdistr 24429 24429 0 0.00 0 7076 33 0 0
sp_multiply_rows_for_qdistr 17990 17990 0 0.00 0 16218 185 0 0
sp_pay_from_customer 6182 6182 0 0.00 4 13872 120 0 0
sp_pay_to_supplier 5135 5135 0 0.00 5 14607 130 0 0
sp_payment_common 11315 11315 0 0.00 1 7101 19 0 0
sp_qd_handle_on_cancel_clo 1640 1640 0 0.00 0 6134 318 0 0
sp_qd_handle_on_invoice_upd_sts 8852 8852 0 0.00 0 24562 295 0 0
sp_qd_handle_on_reserve_upd_sts 8817 8817 0 0.00 0 24310 60 0 0
sp_reserve_write_off 8817 8817 0 0.00 6 24446 190 0 0
sp_supplier_invoice 4894 4894 0 0.00 6 103287 3111 0 0
sp_supplier_order 4789 4789 0 0.00 4 24106 1285 0 0
srv_aggregate_perf_data 91 91 0 0.00 1417 78893 11484 0 0
srv_fill_mon_cache_memory 56 56 0 0.00 1679 183423 41076 0 0
srv_find_qd_qs_mism 891158 891158 0 0.00 0 24952 7 0 0
srv_make_invnt_saldo 375 375 0 0.00 57 105955 4188 0 0
srv_make_money_saldo 630 630 0 0.00 0 14921 571 0 0
srv_recalc_idx_stat 3 3 0 0.00 152115 453347 279997 0 0
t$perf-abend:sp_add_invoice_to_stock 113 113 0 0.00 0 0 0 0 0
t$perf-abend:sp_cancel_supplier_invoice 8 8 0 0.00 0 0 0 0 0
t$perf-norm:sp_add_invoice_to_stock 4318 4318 0 0.00 0 11455 187 0 0
t$perf-norm:sp_cancel_adding_invoice 357 357 0 0.00 0 2072 100 0 0
t$perf-norm:sp_cancel_client_order 1640 1640 0 0.00 0 2567 12 0 0
t$perf-norm:sp_cancel_customer_reserve 637 637 0 0.00 0 1285 9 0 0
t$perf-norm:sp_cancel_pay_from_customer 622 622 0 0.00 0 1627 7 0 0
t$perf-norm:sp_cancel_pay_to_supplier 371 371 0 0.00 0 191 2 0 0
t$perf-norm:sp_cancel_supplier_invoice 386 386 0 0.00 0 474 11 0 0
t$perf-norm:sp_cancel_supplier_order 394 394 0 0.00 0 18410 1407 0 0
t$perf-norm:sp_cancel_write_off 948 948 0 0.00 0 2057 7 0 0
t$perf-norm:sp_client_order 17990 17990 0 0.00 0 11161 15 0 0
t$perf-norm:sp_customer_reserve 869 869 0 0.00 0 460 4 0 0
t$perf-norm:sp_pay_from_customer 6182 6182 0 0.00 0 2414 5 0 0
t$perf-norm:sp_pay_to_supplier 5135 5135 0 0.00 0 4030 9 0 0
t$perf-norm:sp_reserve_write_off 8817 8817 0 0.00 0 8185 10 0 0
t$perf-norm:sp_supplier_invoice 4894 4894 0 0.00 0 3235 15 0 0
t$perf-norm:sp_supplier_order 4789 4789 0 0.00 0 6931 12 0 0
t$perf-norm:srv_aggregate_perf_data 91 91 0 0.00 0 202 8 0 0
t$perf-norm:srv_fill_mon_cache_memory 56 56 0 0.00 0 1838 43 0 0
t$perf-norm:srv_make_invnt_saldo 375 375 0 0.00 0 639 7 0 0
t$perf-norm:srv_make_money_saldo 630 630 0 0.00 0 1147 5 0 0
t$perf-norm:srv_recalc_idx_stat 3 3 0 0.00 2 3 3 0 0
v_add_invoice_to_stock 8810 8584 226 2.56 0 5830 16 0 226
v_all_customers 33176 33176 0 0.00 0 78 1 0 0
v_all_suppliers 27808 27808 0 0.00 0 49 1 0 0
v_all_wares 35976 35976 0 0.00 0 77 1 0 0
v_cancel_adding_invoice 714 714 0 0.00 0 5909 18 0 0
v_cancel_client_order 3280 3280 0 0.00 0 4402 9 0 0
v_cancel_customer_prepayment 1244 1244 0 0.00 0 2483 6 0 0
v_cancel_customer_reserve 1274 1274 0 0.00 0 1737 7 0 0
v_cancel_payment_to_supplier 742 742 0 0.00 0 4733 15 0 0
v_cancel_supplier_invoice 788 772 16 2.03 0 391 13 0 16
v_cancel_supplier_order 788 788 0 0.00 0 1123 7 0 0
v_cancel_write_off 1896 1896 0 0.00 0 3520 16 0 0
v_max_id_clo_ord 4785 4785 0 0.00 0 224 1 0 0
v_max_id_clo_res 869 869 0 0.00 0 3079 10 0 0
v_max_id_ord_sup 4867 4867 0 0.00 0 4281 6 0 0
v_max_non_paid_invoice 881 881 0 0.00 0 212 2 0 0
v_max_non_paid_realizn 3005 3005 0 0.00 0 1659 4 0 0
v_min_id_clo_ord 4785 4785 0 0.00 0 4228 6 0 0
v_min_id_clo_res 869 869 0 0.00 0 6379 13 0 0
v_min_id_ord_sup 4867 4867 0 0.00 0 5492 7 0 0
v_min_non_paid_invoice 5134 5134 0 0.00 0 4586 9 0 0
v_min_non_paid_realizn 6181 6181 0 0.00 0 4805 14 0 0
v_our_firm 9152 9152 0 0.00 0 23 1 0 0
v_reserve_write_off 17634 17634 0 0.00 0 5439 8 0 0
x_lock_depdocs_on_canc_invoice 9257 9257 0 0.00 0 17795 116 0 0
x_lock_depdocs_on_canc_sup_ord 394 394 0 0.00 0 5012 299 0 0
x_make_qstorno_1000_1200 4789 4789 0 0.00 1 24095 1208 0 0
x_make_qstorno_1200_2000 4894 4894 0 0.00 2 103268 2977 0 0
x_make_qstorno_2100_3300 417160 417160 0 0.00 0 41750 187 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 22-02-2024 13:09:51 to 22-02-2024 13:09:55.

Memory consumption, metadata cache, attachments activity 

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


Page cache type: shared, buffers: 1000000 for all connections, with total size: 8192000000
measurement_dts measurement duration ms page cache memo used memo used, total memo allocated, total metadata cache metadata cache percent of total total attachments cnt active attachments cnt running statements cnt stalled statements cnt memo used by attachments memo used by transactions memo used by statements
11:07:53 2 8192000000 8798842480 8810123264 4048064 0.049 2 1 2 0 4147456 63616 35776
11:08:54 30439 8192000000 9713994736 10010587136 793306768 8.828 100 88 176 0 822027744 7468896 21252080
11:10:27 13617 8192000000 9748289344 10053742592 826554720 9.165 100 86 172 0 858469200 11289232 20625248
11:11:56 19398 8192000000 9787324464 10100740096 860612240 9.506 100 94 188 0 900110800 17635312 21863248
11:13:21 15087 8192000000 9832986528 10161491968 884513600 9.745 100 72 144 0 944515056 43978400 16023056
11:14:39 8596 8192000000 9891846016 10232659968 941852048 10.311 100 83 164 0 1008113328 48512960 17748320
11:15:50 3881 8192000000 9932217584 10283208704 982068912 10.704 100 79 158 0 1043211776 45191248 15951616
11:16:55 2030 8192000000 9983840416 10344415232 1002348880 10.901 100 85 165 0 1098013504 79300736 16363888
11:17:59 1609 8192000000 10012054176 10376888320 1025888160 11.129 100 84 168 0 1119716064 77146736 16681168
11:19:03 1556 8192000000 10024852880 10394386432 1042549184 11.289 100 88 177 0 1139573008 79465200 17558624
11:20:06 21482 8192000000 9993586336 10378330112 1058774144 11.445 100 55 109 1 1115196064 45165648 11256272
11:21:28 4371 8192000000 10009276352 10409361408 1074621904 11.596 100 39 78 0 1128012416 45707872 7682640
11:22:34 25729 8192000000 9994492384 10406658048 1079916992 11.647 100 37 74 0 1121304848 33718096 7669760
11:24:00 6050 8192000000 9996070864 10403729408 1087228832 11.716 100 31 61 2 1111219552 16590096 7400624
11:25:10 7366 8192000000 10017961760 10423549952 1096378768 11.803 100 35 70 0 1119505440 15211664 7915008
11:26:19 4383 8192000000 10028044048 10428837888 1101481744 11.852 100 34 68 0 1150474640 42039072 6953824
11:27:25 26821 8192000000 10020988048 10424188928 1091936224 11.761 99 49 98 0 1117232048 14801680 10494144
11:29:01 14747 8192000000 10063137888 10461659136 1118388288 12.012 100 68 135 0 1177321168 44817760 14115120
11:30:23 20727 8192000000 10081388048 10488504320 1120025248 12.027 100 52 104 0 1205202928 74095088 11082592
11:31:49 26956 8192000000 10102898800 10510516224 1106056928 11.895 98 54 107 1 1197750512 80022064 11671520
11:33:28 20443 8192000000 10127986336 10549506048 1134215808 12.161 100 47 94 0 1249702432 104755296 10731328
11:34:54 13038 8192000000 10150028640 10569924608 1138458000 12.201 100 43 86 0 1266443808 118553088 9432720
11:36:16 7974 8192000000 10176766512 10593460224 1141246512 12.227 100 41 82 0 1285032496 134450048 9335936
11:37:28 15112 8192000000 10170492880 10588958720 1095014096 11.790 97 42 84 2 1276616080 172284096 9317888
11:38:50 15181 8192000000 10160855648 10569637888 1089498048 11.738 98 42 80 0 1258551264 159838576 9214640
11:40:24 4610 8192000000 10188875664 10592636928 1119206784 12.019 100 57 112 1 1300308304 169002400 12099120
11:41:39 15774 8192000000 10236912544 10628706304 1105302752 11.888 100 65 128 0 1340018416 220535168 14180496
11:42:59 5912 8192000000 10206184384 10603302912 1087173808 11.716 100 61 122 0 1315307616 214623248 13510560
11:44:11 2997 8192000000 10231042864 10626334720 1106328224 11.898 100 70 137 0 1331637760 210401680 14907856
11:45:22 4989 8192000000 10246476624 10663686144 1131010528 12.131 100 63 125 1 1351197776 205681488 14505760
11:46:31 2230 8192000000 10321645856 10719453184 1130080720 12.122 100 81 159 0 1426171408 278261024 17829664
11:47:39 1677 8192000000 10412648944 10814955520 1143407536 12.248 100 81 162 1 1509039632 347064112 18567984
11:48:46 15264 8192000000 10387326544 10816790528 1152806288 12.336 100 59 115 1 1487570720 321139312 13625120
11:50:10 17581 8192000000 10342878576 10830311424 1154750112 12.354 100 31 62 0 1464998160 302386000 7862048
11:52:24 48990 8192000000 10193660512 10696019968 1126810720 12.091 100 18 36 0 1363912112 232949456 4151936
11:54:28 81809 8192000000 10090326160 10565623808 1104332368 11.879 97 16 32 0 1160747888 53511552 2903968
11:56:52 18269 8192000000 10070895440 10485764096 1139246080 12.208 100 35 67 1 1158777872 13043936 6487856
11:58:14 93811 8192000000 10123592496 10561531904 1144153360 12.255 100 37 73 0 1216958688 64890912 7914416
12:00:54 71119 8192000000 10096003776 10547183616 1133155440 12.151 99 33 64 1 1170675760 30903168 6617152
12:03:09 17371 8192000000 10129174160 10586284032 1156011568 12.366 100 29 58 0 1253906080 91513456 6381056
12:04:57 40533 8192000000 10179239488 10621710336 1161329920 12.416 100 40 79 0 1286834192 116375312 9128960
12:06:48 44038 8192000000 10148209056 10626473984 1151564880 12.324 99 18 36 0 1262099136 105622160 4912096
12:08:32 38992 8192000000 10117564848 10587439104 1166565056 12.465 100 9 18 0 1229973792 61144384 2264352
12:10:12 48036 8192000000 10117098832 10620723200 1140204800 12.217 98 21 42 0 1203398160 58701328 4492032
12:12:01 39317 8192000000 10144651680 10604310528 1160629200 12.409 100 39 76 0 1221444256 51765024 9050032
12:13:44 81242 8192000000 10121330400 10627956736 1160566576 12.409 99 28 56 0 1223158192 56933888 5657728
12:16:36 15959 8192000000 10106489552 10550018048 1167719568 12.476 100 29 57 2 1195436640 21188816 6528256
12:17:52 67869 8192000000 10099413120 10624131072 1105688432 11.892 95 13 26 0 1148373152 40419520 2265200
12:20:03 50695 8192000000 10083850464 10522791936 1092946944 11.771 95 29 56 0 1132340944 34167392 5226608
12:21:54 49765 8192000000 10075766576 10504130560 1071758160 11.569 94 16 32 0 1096815632 21903872 3153600
12:23:44 113215 8192000000 10036646144 10474000384 1067781056 11.531 94 28 56 1 1102963136 29899600 5282480
12:26:48 16382 8192000000 10061075632 10479915008 1102609328 11.862 99 39 78 0 1149080448 38501312 7969808
12:28:07 51657 8192000000 10028268640 10494562304 1076519728 11.614 97 10 20 0 1113741472 35017456 2204288
12:29:59 45189 8192000000 10042308576 10465816576 1049264928 11.354 94 26 52 0 1086825056 32176080 5384048
12:31:48 70931 8192000000 10061400208 10520850432 1071224352 11.564 96 7 15 0 1111157744 38231712 1701680
12:34:00 23689 8192000000 10063596496 10488918016 1086023088 11.705 97 33 66 0 1139555200 46624624 6907488
12:35:27 64751 8192000000 10099003760 10547920896 1115662992 11.986 99 17 34 0 1182584208 63324256 3596960
12:37:34 43397 8192000000 10073739056 10508558336 1114730576 11.977 99 21 42 0 1170480928 51524160 4226192
12:39:19 29909 8192000000 10115543968 10540597248 1131659696 12.137 100 40 80 0 1181146464 41101536 8385232
12:41:09 31419 8192000000 10099454624 10536116224 1099794880 11.836 97 43 86 0 1165955312 57981264 8179168
12:42:42 103304 8192000000 10044948544 10481356800 1112786256 11.959 99 30 60 0 1144788416 25442912 6559248
12:45:27 28305 8192000000 10090824320 10535829504 1130981648 12.131 100 36 72 0 1208809552 70693104 7134800
12:46:59 34159 8192000000 10062141936 10526146560 1132569168 12.146 100 10 20 0 1180481120 45722592 2189360
12:48:36 183423 8192000000 10112841984 10627416064 1117494912 12.003 97 15 30 0 1208162240 87725216 2942112
12:52:42 44443 8192000000 10094596800 10553294848 1139568496 12.211 99 20 40 0 1187217952 42793088 4856368
12:54:35 55452 8192000000 10095592384 10544758784 1122995600 12.055 97 20 42 0 1178110352 51467792 3646960
12:56:30 69852 8192000000 10106949200 10573684736 1135861776 12.177 99 14 28 0 1187296704 48178112 3256816
12:58:44 45130 8192000000 10104824320 10539171840 1139701168 12.213 99 43 81 0 1189595008 41564704 8329136
13:00:37 35322 8192000000 10139035248 10588733440 1147271984 12.284 100 22 44 0 1203954592 52106560 4576048
13:02:22 28433 8192000000 10077415136 10507497472 1103710704 11.873 97 18 35 1 1144836448 37759904 3365840
13:03:56 103548 8192000000 10057527968 10519175168 1107347872 11.907 98 20 40 0 1149941088 38608384 3984832
13:06:42 38428 8192000000 10059022224 10532679680 1117617152 12.004 100 6 12 0 1170759472 51817968 1324352

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:14, from 22-02-2024 13:09:57 to 22-02-2024 13:10:11.

Exceptions occured during test was in run

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

Completed "Exceptions occured during test was in run". Done for 00:00:02, from 22-02-2024 13:10:12 to 22-02-2024 13:10:14.

Content of mon$database and FB version 


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


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

Database statistics 

 
Database "/home/bases/oltp40-etalone.fdb" 
Gstat execution time Thu Feb 22 13:10:15 2024 
 
Database header page information: 
    Flags            0 
    Generation        91082 
    System Change Number    0 
    Page size        8192 
    ODS version        13.0 
    Oldest transaction    174546 
    Oldest active        174547 
    Oldest snapshot        174547 
    Next transaction    174548 
    Sequence number        0 
    Next attachment ID    698 
    Implementation        HW=AMD/Intel/x64 little-endian OS=Linux CC=gcc 
    Shadow count        0 
    Page buffers        0 
    Next header page    0 
    Database dialect    3 
    Creation date        Apr 30, 2020 7:30:08 
    Attributes        force write 
 
    Variable header data: 
    Database GUID:    {58978C10-B735-40F5-8B7D-F7A1956E782B} 
    Sweep interval:        0 
    *END* 
 
 
Database file sequence: 
File /home/bases/oltp40-etalone.fdb is the only file 
 
Analyzing database pages ... 
AGENTS (150) 
    Primary pointer page: 524, Index root page: 525 
    Total formats: 1, used formats: 1 
    Average record length: 33.60, total records: 50 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 344.00, compression ratio: 10.24 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 31% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 1 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index AGENTS_ID_DESC (2) 
    Root page: 1504333, depth: 1, leaf buckets: 1, nodes: 50 
    Average node length: 11.82, total dup: 0, max dup: 0 
    Average key length: 10.80, compression ratio: 0.83 
    Average prefix length: 1.18, average data length: 7.82 
    Clustering factor: 1, ratio: 0.02 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index AGENTS_IS_OUR_FIRM (4) 
    Root page: 1504335, depth: 1, leaf buckets: 1, nodes: 50 
    Average node length: 3.08, total dup: 48, max dup: 48 
    Average key length: 2.04, compression ratio: 0.50 
    Average prefix length: 0.96, average data length: 0.06 
    Clustering factor: 1, ratio: 0.02 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index AGENTS_IS_SUPPLIER (3) 
    Root page: 1504334, depth: 1, leaf buckets: 1, nodes: 50 
    Average node length: 3.08, total dup: 48, max dup: 44 
    Average key length: 2.04, compression ratio: 0.54 
    Average prefix length: 1.04, average data length: 0.06 
    Clustering factor: 1, ratio: 0.02 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index AGENTS_NAME_UNQ (1) 
    Root page: 1504332, depth: 1, leaf buckets: 1, nodes: 50 
    Average node length: 17.20, total dup: 0, max dup: 0 
    Average key length: 15.88, compression ratio: 0.92 
    Average prefix length: 1.42, average data length: 13.20 
    Clustering factor: 1, ratio: 0.02 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PK_AGENTS (0) 
    Root page: 1504331, depth: 1, leaf buckets: 1, nodes: 50 
    Average node length: 11.82, total dup: 0, max dup: 0 
    Average key length: 10.80, compression ratio: 0.83 
    Average prefix length: 1.18, average data length: 7.82 
    Clustering factor: 1, ratio: 0.02 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
BUSINESS_OPS (154) 
    Primary pointer page: 532, Index root page: 533 
    Total formats: 1, used formats: 1 
    Average record length: 108.20, total records: 20 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1235.00, compression ratio: 11.41 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 31% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 1 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index BO_UNIT_UNQ (1) 
    Root page: 1504264, depth: 1, leaf buckets: 1, nodes: 20 
    Average node length: 18.25, total dup: 0, max dup: 0 
    Average key length: 17.20, compression ratio: 1.24 
    Average prefix length: 7.05, average data length: 14.25 
    Clustering factor: 1, ratio: 0.05 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index BUSINESS_OPS_PREDICT_PRIOR (3) 
    Root page: 1504266, depth: 1, leaf buckets: 1, nodes: 20 
    Average node length: 5.40, total dup: 0, max dup: 0 
    Average key length: 4.35, compression ratio: 0.67 
    Average prefix length: 1.20, average data length: 1.70 
    Clustering factor: 1, ratio: 0.05 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index BUSINESS_OPS_RND_WGTH (2) 
    Root page: 1504265, depth: 1, leaf buckets: 1, nodes: 20 
    Average node length: 4.30, total dup: 6, max dup: 3 
    Average key length: 3.25, compression ratio: 0.72 
    Average prefix length: 1.35, average data length: 1.00 
    Clustering factor: 1, ratio: 0.05 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index RDB$1 (0) 
    Root page: 1504263, depth: 1, leaf buckets: 1, nodes: 20 
    Average node length: 5.20, total dup: 0, max dup: 0 
    Average key length: 4.15, compression ratio: 0.65 
    Average prefix length: 1.10, average data length: 1.60 
    Clustering factor: 1, ratio: 0.05 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
DOC_DATA (139) 
    Primary pointer page: 502, Index root page: 503 
    Total formats: 1, used formats: 1 
    Average record length: 47.68, total records: 7695636 
    Average version length: 48.16, total versions: 42425, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 64.00, compression ratio: 1.34 
    Pointer pages: 55, data page slots: 88928 
    Data pages: 88928, average fill: 69% 
    Primary pages: 88927, secondary pages: 1, swept pages: 48779 
    Empty pages: 9, full pages: 57066 
    Fill distribution: 
     0 - 19% = 17 
    20 - 39% = 68 
    40 - 59% = 2201 
    60 - 79% = 86625 
    80 - 99% = 17 
 
    Index DOC_DATA_DOC_WARE_UNQ (0) 
    Root page: 1510636, depth: 3, leaf buckets: 23294, nodes: 7695636 
    Average node length: 18.86, total dup: 0, max dup: 0 
    Average key length: 15.88, compression ratio: 1.70 
    Average prefix length: 14.12, average data length: 12.88 
    Clustering factor: 1670024, ratio: 0.22 
    Fill distribution: 
         0 - 19% = 345 
        20 - 39% = 1897 
        40 - 59% = 4156 
        60 - 79% = 2752 
        80 - 99% = 14144 
 
    Index DOC_DATA_ID_DESC (1) 
    Root page: 1528140, depth: 3, leaf buckets: 13513, nodes: 7695636 
    Average node length: 11.20, total dup: 0, max dup: 0 
    Average key length: 8.21, compression ratio: 1.10 
    Average prefix length: 3.78, average data length: 5.22 
    Clustering factor: 1493857, ratio: 0.19 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 1655 
        40 - 59% = 1963 
        60 - 79% = 1323 
        80 - 99% = 8572 
 
    Index FK_DOC_DATA_DOC_LIST (2) 
    Root page: 1546735, depth: 3, leaf buckets: 8342, nodes: 7695636 
    Average node length: 6.60, total dup: 5771434, max dup: 49 
    Average key length: 3.62, compression ratio: 2.49 
    Average prefix length: 7.63, average data length: 1.37 
    Clustering factor: 1487020, ratio: 0.19 
    Fill distribution: 
         0 - 19% = 130 
        20 - 39% = 969 
        40 - 59% = 1397 
        60 - 79% = 1120 
        80 - 99% = 4726 
 
DOC_LIST (138) 
    Primary pointer page: 500, Index root page: 501 
    Total formats: 1, used formats: 1 
    Average record length: 56.99, total records: 2215021 
    Average version length: 58.81, total versions: 20210, max versions: 2 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 84.00, compression ratio: 1.47 
    Pointer pages: 18, data page slots: 28584 
    Data pages: 28584, average fill: 71% 
    Primary pages: 28583, secondary pages: 1, swept pages: 15523 
    Empty pages: 8, full pages: 14796 
    Fill distribution: 
     0 - 19% = 11 
    20 - 39% = 15 
    40 - 59% = 461 
    60 - 79% = 28072 
    80 - 99% = 25 
 
    Index DOC_LIST_ID_DESC (1) 
    Root page: 1541152, depth: 3, leaf buckets: 4555, nodes: 2215021 
    Average node length: 11.41, total dup: 0, max dup: 0 
    Average key length: 8.45, compression ratio: 1.07 
    Average prefix length: 3.55, average data length: 5.45 
    Clustering factor: 679372, ratio: 0.31 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 925 
        40 - 59% = 896 
        60 - 79% = 828 
        80 - 99% = 1905 
 
    Index DOC_LIST_WORKER_OPTYPE (2) 
    Root page: 1544398, depth: 3, leaf buckets: 2398, nodes: 2215814 
    Average node length: 4.97, total dup: 2214915, max dup: 17771 
    Average key length: 2.01, compression ratio: 4.48 
    Average prefix length: 8.99, average data length: 0.01 
    Clustering factor: 1259162, ratio: 0.57 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 214 
        40 - 59% = 1387 
        60 - 79% = 543 
        80 - 99% = 253 
 
    Index FK_DOC_LIST_AGENTS (3) 
    Root page: 1545933, depth: 3, leaf buckets: 1772, nodes: 2215021 
    Average node length: 4.97, total dup: 2214971, max dup: 130303 
    Average key length: 2.01, compression ratio: 4.48 
    Average prefix length: 8.99, average data length: 0.01 
    Clustering factor: 1057338, ratio: 0.48 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 6 
        40 - 59% = 624 
        60 - 79% = 33 
        80 - 99% = 1108 
 
    Index PK_DOC_LIST (0) 
    Root page: 1538209, depth: 3, leaf buckets: 4387, nodes: 2215021 
    Average node length: 11.41, total dup: 0, max dup: 0 
    Average key length: 8.45, compression ratio: 1.07 
    Average prefix length: 3.55, average data length: 5.45 
    Clustering factor: 679372, ratio: 0.31 
    Fill distribution: 
         0 - 19% = 122 
        20 - 39% = 596 
        40 - 59% = 686 
        60 - 79% = 944 
        80 - 99% = 2039 
 
DOC_STATES (149) 
    Primary pointer page: 522, Index root page: 523 
    Total formats: 1, used formats: 1 
    Average record length: 67.50, total records: 4 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 650.00, compression ratio: 9.63 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 4% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index DOC_STATES_MCODE_UNQ (1) 
    Root page: 1504337, depth: 1, leaf buckets: 1, nodes: 4 
    Average node length: 17.75, total dup: 0, max dup: 0 
    Average key length: 16.50, compression ratio: 1.08 
    Average prefix length: 4.00, average data length: 13.75 
    Clustering factor: 1, ratio: 0.25 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index DOC_STATES_NAME_UNQ (2) 
    Root page: 1504338, depth: 1, leaf buckets: 1, nodes: 4 
    Average node length: 33.25, total dup: 0, max dup: 0 
    Average key length: 32.00, compression ratio: 0.99 
    Average prefix length: 2.50, average data length: 29.25 
    Clustering factor: 1, ratio: 0.25 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PK_DOC_STATES (0) 
    Root page: 1504336, depth: 1, leaf buckets: 1, nodes: 4 
    Average node length: 4.75, total dup: 0, max dup: 0 
    Average key length: 3.50, compression ratio: 0.86 
    Average prefix length: 1.50, average data length: 1.50 
    Clustering factor: 1, ratio: 0.25 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
FB_ERRORS (155) 
    Primary pointer page: 534, Index root page: 535 
    Total formats: 2, used formats: 2 
    Average record length: 57.88, total records: 2182 
    Average version length: 79.61, total versions: 757, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 270.43, compression ratio: 4.67 
    Pointer pages: 1, data page slots: 40 
    Data pages: 40, average fill: 72% 
    Primary pages: 39, secondary pages: 1, swept pages: 0 
    Empty pages: 4, full pages: 34 
    Fill distribution: 
     0 - 19% = 5 
    20 - 39% = 0 
    40 - 59% = 1 
    60 - 79% = 22 
    80 - 99% = 12 
 
    Index FB_ERRORS_GDS_CODE (0) 
    Root page: 398, depth: 2, leaf buckets: 2, nodes: 2182 
    Average node length: 4.40, total dup: 756, max dup: 1 
    Average key length: 2.67, compression ratio: 1.87 
    Average prefix length: 4.33, average data length: 0.67 
    Clustering factor: 1518, ratio: 0.70 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 0 
        40 - 59% = 1 
        60 - 79% = 1 
        80 - 99% = 0 
 
INVNT_SALDO (145) 
    Primary pointer page: 514, Index root page: 515 
    Total formats: 2, used formats: 1 
    Average record length: 83.20, total records: 400 
    Average version length: 28.78, total versions: 1498, max versions: 4 
    Average fragment length: 2.00, total fragments: 8, max fragments: 1 
    Average unpacked length: 104.00, compression ratio: 1.25 
    Pointer pages: 1, data page slots: 24 
    Data pages: 24, average fill: 56% 
    Primary pages: 7, secondary pages: 17, swept pages: 0 
    Empty pages: 7, full pages: 13 
    Fill distribution: 
     0 - 19% = 10 
    20 - 39% = 0 
    40 - 59% = 1 
    60 - 79% = 0 
    80 - 99% = 13 
 
    Index PK_INVNT_SALDO (0) 
    Root page: 1510371, depth: 1, leaf buckets: 1, nodes: 400 
    Average node length: 11.22, total dup: 0, max dup: 0 
    Average key length: 10.22, compression ratio: 0.88 
    Average prefix length: 1.78, average data length: 7.22 
    Clustering factor: 326, ratio: 0.81 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 0 
        40 - 59% = 1 
        60 - 79% = 0 
        80 - 99% = 0 
 
INVNT_TURNOVER_LOG (153) 
    Primary pointer page: 530, Index root page: 531 
    Total formats: 1, used formats: 1 
    Average record length: 12.88, total records: 87619 
    Average version length: 68.29, total versions: 81880, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 88.00, compression ratio: 6.83 
    Pointer pages: 7, data page slots: 2960 
    Data pages: 1880, average fill: 63% 
    Primary pages: 1879, secondary pages: 1, swept pages: 82 
    Empty pages: 361, full pages: 1106 
    Fill distribution: 
     0 - 19% = 443 
    20 - 39% = 99 
    40 - 59% = 121 
    60 - 79% = 218 
    80 - 99% = 999 
 
    Index INVNT_TURNOVER_LOG_WARE_DD_ID (0) 
    Root page: 1696311, depth: 3, leaf buckets: 359, nodes: 87619 
    Average node length: 13.48, total dup: 5235, max dup: 1 
    Average key length: 10.83, compression ratio: 2.49 
    Average prefix length: 19.11, average data length: 7.89 
    Clustering factor: 65585, ratio: 0.75 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 210 
        40 - 59% = 122 
        60 - 79% = 26 
        80 - 99% = 1 
 
MONEY_SALDO (141) 
    Primary pointer page: 506, Index root page: 507 
    Total formats: 1, used formats: 1 
    Average record length: 15.18, total records: 49 
    Average version length: 9.00, total versions: 104, max versions: 3 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 32.00, compression ratio: 2.11 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 53% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 1 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index PK_MONEY_SALDO (0) 
    Root page: 1510383, depth: 1, leaf buckets: 1, nodes: 49 
    Average node length: 11.82, total dup: 0, max dup: 0 
    Average key length: 10.80, compression ratio: 0.83 
    Average prefix length: 1.18, average data length: 7.82 
    Clustering factor: 1, ratio: 0.02 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
MONEY_TURNOVER_LOG (140) 
    Primary pointer page: 504, Index root page: 505 
    Total formats: 1, used formats: 1 
    Average record length: 11.20, total records: 1293 
    Average version length: 43.39, total versions: 1210, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 58.00, compression ratio: 5.18 
    Pointer pages: 1, data page slots: 40 
    Data pages: 31, average fill: 45% 
    Primary pages: 30, secondary pages: 1, swept pages: 3 
    Empty pages: 10, full pages: 11 
    Fill distribution: 
     0 - 19% = 14 
    20 - 39% = 1 
    40 - 59% = 2 
    60 - 79% = 4 
    80 - 99% = 10 
 
    Index MONEY_TURNOVER_LOG_AGENT_OPTYPE (0) 
    Root page: 89444, depth: 2, leaf buckets: 2, nodes: 1293 
    Average node length: 4.33, total dup: 1195, max dup: 165 
    Average key length: 2.80, compression ratio: 6.78 
    Average prefix length: 18.27, average data length: 0.73 
    Clustering factor: 695, ratio: 0.54 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 1 
        60 - 79% = 0 
        80 - 99% = 0 
 
MON_CACHE_MEMORY (165) 
    Primary pointer page: 555, Index root page: 556 
    Total formats: 2, used formats: 1 
    Average record length: 97.57, 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% = 0 
    20 - 39% = 1 
    40 - 59% = 0 
    60 - 79% = 1 
    80 - 99% = 0 
 
    Index PK_MON_CACHE_MEMORY (0) 
    Root page: 1504238, depth: 1, leaf buckets: 1, nodes: 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: 548, Index root page: 549 
    Total formats: 2, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index MON_LOG_DTS (4) 
    Root page: 1504251, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index MON_LOG_GDSCODE (2) 
    Root page: 1504249, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index MON_LOG_ROWSET_DESC (1) 
    Root page: 1504248, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index MON_LOG_UNIT (3) 
    Root page: 1504250, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PK_MON_LOG (0) 
    Root page: 1504247, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
MON_LOG_TABLE_STATS (163) 
    Primary pointer page: 550, Index root page: 551 
    Total formats: 2, used formats: 1 
    Average record length: 67.13, total records: 30 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 611.00, compression ratio: 9.10 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 31% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 1 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index MON_LOG_TABLE_STATS_DTS (4) 
    Root page: 1504246, depth: 1, leaf buckets: 1, nodes: 30 
    Average node length: 3.50, total dup: 23, max dup: 4 
    Average key length: 2.47, compression ratio: 3.24 
    Average prefix length: 7.53, average data length: 0.47 
    Clustering factor: 1, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index MON_LOG_TABLE_STATS_GDSCODE (2) 
    Root page: 1504244, depth: 1, leaf buckets: 1, nodes: 30 
    Average node length: 2.00, total dup: 29, max dup: 29 
    Average key length: 1.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 1, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index MON_LOG_TABLE_STATS_ROWSET (1) 
    Root page: 1504243, depth: 1, leaf buckets: 1, nodes: 30 
    Average node length: 3.33, total dup: 29, max dup: 29 
    Average key length: 2.30, compression ratio: 3.91 
    Average prefix length: 8.70, average data length: 0.30 
    Clustering factor: 1, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index MON_LOG_TABLE_STATS_TN_UNIT (3) 
    Root page: 1504245, depth: 1, leaf buckets: 1, nodes: 30 
    Average node length: 12.90, total dup: 0, max dup: 0 
    Average key length: 11.87, compression ratio: 1.42 
    Average prefix length: 7.63, average data length: 9.20 
    Clustering factor: 1, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PK_MON_LOG_TABLE_STATS (0) 
    Root page: 1504242, depth: 1, leaf buckets: 1, nodes: 30 
    Average node length: 8.37, total dup: 0, max dup: 0 
    Average key length: 7.33, compression ratio: 1.23 
    Average prefix length: 4.63, average data length: 4.37 
    Clustering factor: 1, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
OPTYPES (136) 
    Primary pointer page: 496, Index root page: 497 
    Total formats: 2, used formats: 1 
    Average record length: 67.56, total records: 9 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 386.00, compression ratio: 5.71 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 9% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index OPTYPES_MCODE_UNQ (1) 
    Root page: 1544827, depth: 1, leaf buckets: 1, nodes: 9 
    Average node length: 8.56, total dup: 0, max dup: 0 
    Average key length: 6.89, compression ratio: 0.73 
    Average prefix length: 0.44, average data length: 4.56 
    Clustering factor: 1, ratio: 0.11 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PK_OPTYPES (0) 
    Root page: 1544826, depth: 1, leaf buckets: 1, nodes: 9 
    Average node length: 6.11, total dup: 0, max dup: 0 
    Average key length: 5.00, compression ratio: 0.60 
    Average prefix length: 0.89, average data length: 2.11 
    Clustering factor: 1, ratio: 0.11 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
PDISTR (146) 
    Primary pointer page: 516, Index root page: 517 
    Total formats: 1, used formats: 1 
    Average record length: 36.88, total records: 786302 
    Average version length: 37.94, total versions: 17682, max versions: 2 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 54.00, compression ratio: 1.46 
    Pointer pages: 6, data page slots: 8592 
    Data pages: 8576, average fill: 63% 
    Primary pages: 8573, secondary pages: 3, swept pages: 4004 
    Empty pages: 51, full pages: 3657 
    Fill distribution: 
     0 - 19% = 96 
    20 - 39% = 96 
    40 - 59% = 1319 
    60 - 79% = 7035 
    80 - 99% = 30 
 
    Index PDISTR_AGENT_ID (2) 
    Root page: 1509330, depth: 2, leaf buckets: 841, nodes: 777367 
    Average node length: 4.88, total dup: 777318, max dup: 135162 
    Average key length: 2.01, compression ratio: 4.48 
    Average prefix length: 8.99, average data length: 0.01 
    Clustering factor: 89192, ratio: 0.11 
    Fill distribution: 
         0 - 19% = 3 
        20 - 39% = 146 
        40 - 59% = 419 
        60 - 79% = 167 
        80 - 99% = 106 
 
    Index PDISTR_SNDOP_RCVOP_SNDID_ASC (0) 
    Root page: 1508635, depth: 3, leaf buckets: 1025, nodes: 777367 
    Average node length: 5.89, total dup: 692030, max dup: 42 
    Average key length: 3.02, compression ratio: 7.28 
    Average prefix length: 21.09, average data length: 0.91 
    Clustering factor: 154866, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 3 
        20 - 39% = 118 
        40 - 59% = 626 
        60 - 79% = 85 
        80 - 99% = 193 
 
    Index PDISTR_SNDOP_RCVOP_SNDID_DESC (1) 
    Root page: 1509209, depth: 3, leaf buckets: 1057, nodes: 777367 
    Average node length: 5.89, total dup: 692030, max dup: 42 
    Average key length: 3.02, compression ratio: 7.28 
    Average prefix length: 21.09, average data length: 0.91 
    Clustering factor: 156665, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 165 
        40 - 59% = 636 
        60 - 79% = 73 
        80 - 99% = 182 
 
    Index PDISTR_WORKER_SND_ID (3) 
    Root page: 1510200, depth: 3, leaf buckets: 1123, nodes: 777367 
    Average node length: 5.97, total dup: 692030, max dup: 42 
    Average key length: 3.10, compression ratio: 5.48 
    Average prefix length: 16.01, average data length: 0.99 
    Clustering factor: 149936, ratio: 0.19 
    Fill distribution: 
         0 - 19% = 3 
        20 - 39% = 254 
        40 - 59% = 595 
        60 - 79% = 198 
        80 - 99% = 73 
 
PERF_AGG (158) 
    Primary pointer page: 540, Index root page: 541 
    Total formats: 1, used formats: 1 
    Average record length: 62.76, total records: 5425 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 2.88, total fragments: 16, max fragments: 1 
    Average unpacked length: 379.00, compression ratio: 6.04 
    Pointer pages: 1, data page slots: 88 
    Data pages: 87, average fill: 61% 
    Primary pages: 77, secondary pages: 10, swept pages: 58 
    Empty pages: 7, full pages: 58 
    Fill distribution: 
     0 - 19% = 13 
    20 - 39% = 0 
    40 - 59% = 3 
    60 - 79% = 71 
    80 - 99% = 0 
 
    Index PERF_AGG_UNQ (1) 
    Root page: 1504260, depth: 2, leaf buckets: 6, nodes: 5425 
    Average node length: 5.52, total dup: 0, max dup: 0 
    Average key length: 3.59, compression ratio: 10.02 
    Average prefix length: 34.38, average data length: 1.55 
    Clustering factor: 5166, 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: 1504255, depth: 2, leaf buckets: 10, nodes: 5425 
    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: 167, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 1 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 7 
 
PERF_ESTIMATED (280) 
    Primary pointer page: 399, Index root page: 434 
    Total formats: 1, used formats: 1 
    Average record length: 39.16, total records: 79365 
    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: 832 
    Data pages: 832, average fill: 66% 
    Primary pages: 832, secondary pages: 0, swept pages: 0 
    Empty pages: 6, full pages: 825 
    Fill distribution: 
     0 - 19% = 6 
    20 - 39% = 1 
    40 - 59% = 0 
    60 - 79% = 825 
    80 - 99% = 0 
 
    Index PK_PERF_ESTIMATED (0) 
    Root page: 36241, depth: 2, leaf buckets: 101, nodes: 79365 
    Average node length: 10.16, total dup: 0, max dup: 0 
    Average key length: 8.17, compression ratio: 1.10 
    Average prefix length: 3.83, average data length: 5.17 
    Clustering factor: 3038, ratio: 0.04 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 100 
 
PERF_ISQL_STAT (156) 
    Primary pointer page: 536, Index root page: 537 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index PERF_ISQL_STAT_TRN (0) 
    Root page: 1504261, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
PERF_LOG (159) 
    Primary pointer page: 542, Index root page: 543 
    Total formats: 1, used formats: 1 
    Average record length: 110.51, total records: 71 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1691.00, compression ratio: 15.30 
    Pointer pages: 1, data page slots: 2 
    Data pages: 2, average fill: 56% 
    Primary pages: 2, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 1 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 1 
    40 - 59% = 0 
    60 - 79% = 1 
    80 - 99% = 0 
 
PERF_SPLIT_0 (281) 
    Primary pointer page: 601, Index root page: 602 
    Total formats: 1, used formats: 1 
    Average record length: 147.19, total records: 150199 
    Average version length: 153.57, total versions: 4123, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.52 
    Pointer pages: 7, data page slots: 4952 
    Data pages: 3760, average fill: 83% 
    Primary pages: 3758, secondary pages: 2, swept pages: 6 
    Empty pages: 57, full pages: 3684 
    Fill distribution: 
     0 - 19% = 66 
    20 - 39% = 5 
    40 - 59% = 1 
    60 - 79% = 5 
    80 - 99% = 3683 
 
PERF_SPLIT_1 (282) 
    Primary pointer page: 603, Index root page: 604 
    Total formats: 1, used formats: 1 
    Average record length: 150.91, total records: 137658 
    Average version length: 137.96, total versions: 253, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.24 
    Pointer pages: 6, data page slots: 3920 
    Data pages: 3464, average fill: 82% 
    Primary pages: 3462, secondary pages: 2, swept pages: 2 
    Empty pages: 73, full pages: 3372 
    Fill distribution: 
     0 - 19% = 80 
    20 - 39% = 9 
    40 - 59% = 1 
    60 - 79% = 1 
    80 - 99% = 3373 
 
PERF_SPLIT_2 (283) 
    Primary pointer page: 605, Index root page: 606 
    Total formats: 1, used formats: 1 
    Average record length: 148.08, total records: 144838 
    Average version length: 152.49, total versions: 3105, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.45 
    Pointer pages: 7, data page slots: 4808 
    Data pages: 3616, average fill: 83% 
    Primary pages: 3613, secondary pages: 3, swept pages: 7 
    Empty pages: 47, full pages: 3549 
    Fill distribution: 
     0 - 19% = 51 
    20 - 39% = 6 
    40 - 59% = 6 
    60 - 79% = 3 
    80 - 99% = 3550 
 
PERF_SPLIT_3 (284) 
    Primary pointer page: 607, Index root page: 608 
    Total formats: 1, used formats: 1 
    Average record length: 147.48, total records: 151379 
    Average version length: 152.82, total versions: 3760, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.50 
    Pointer pages: 7, data page slots: 4952 
    Data pages: 3760, average fill: 83% 
    Primary pages: 3757, secondary pages: 3, swept pages: 1 
    Empty pages: 34, full pages: 3709 
    Fill distribution: 
     0 - 19% = 40 
    20 - 39% = 4 
    40 - 59% = 3 
    60 - 79% = 3 
    80 - 99% = 3710 
 
PERF_SPLIT_4 (285) 
    Primary pointer page: 609, Index root page: 610 
    Total formats: 1, used formats: 1 
    Average record length: 148.48, total records: 151867 
    Average version length: 152.08, total versions: 2838, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.42 
    Pointer pages: 6, data page slots: 4416 
    Data pages: 3808, average fill: 82% 
    Primary pages: 3805, secondary pages: 3, swept pages: 1 
    Empty pages: 64, full pages: 3724 
    Fill distribution: 
     0 - 19% = 70 
    20 - 39% = 9 
    40 - 59% = 3 
    60 - 79% = 2 
    80 - 99% = 3724 
 
PERF_SPLIT_5 (286) 
    Primary pointer page: 611, Index root page: 612 
    Total formats: 1, used formats: 1 
    Average record length: 150.24, total records: 151182 
    Average version length: 149.12, total versions: 1165, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.29 
    Pointer pages: 6, data page slots: 4784 
    Data pages: 3792, average fill: 82% 
    Primary pages: 3790, secondary pages: 2, swept pages: 5 
    Empty pages: 61, full pages: 3712 
    Fill distribution: 
     0 - 19% = 69 
    20 - 39% = 8 
    40 - 59% = 1 
    60 - 79% = 2 
    80 - 99% = 3712 
 
PERF_SPLIT_6 (287) 
    Primary pointer page: 613, Index root page: 614 
    Total formats: 1, used formats: 1 
    Average record length: 132.49, total records: 187810 
    Average version length: 155.10, total versions: 24975, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 12.80 
    Pointer pages: 8, data page slots: 5504 
    Data pages: 4744, average fill: 84% 
    Primary pages: 4741, secondary pages: 3, swept pages: 22 
    Empty pages: 92, full pages: 4611 
    Fill distribution: 
     0 - 19% = 97 
    20 - 39% = 15 
    40 - 59% = 9 
    60 - 79% = 13 
    80 - 99% = 4610 
 
PERF_SPLIT_7 (288) 
    Primary pointer page: 615, Index root page: 616 
    Total formats: 1, used formats: 1 
    Average record length: 150.43, total records: 155867 
    Average version length: 151.43, total versions: 817, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.27 
    Pointer pages: 9, data page slots: 4320 
    Data pages: 3880, average fill: 83% 
    Primary pages: 3878, secondary pages: 2, swept pages: 5 
    Empty pages: 40, full pages: 3824 
    Fill distribution: 
     0 - 19% = 47 
    20 - 39% = 5 
    40 - 59% = 2 
    60 - 79% = 3 
    80 - 99% = 3823 
 
PERF_SPLIT_8 (289) 
    Primary pointer page: 617, Index root page: 618 
    Total formats: 1, used formats: 1 
    Average record length: 142.58, total records: 150019 
    Average version length: 155.00, total versions: 8572, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.90 
    Pointer pages: 6, data page slots: 4008 
    Data pages: 3720, average fill: 84% 
    Primary pages: 3718, secondary pages: 2, swept pages: 3 
    Empty pages: 28, full pages: 3672 
    Fill distribution: 
     0 - 19% = 33 
    20 - 39% = 6 
    40 - 59% = 7 
    60 - 79% = 2 
    80 - 99% = 3672 
 
PERF_SPLIT_9 (290) 
    Primary pointer page: 619, Index root page: 620 
    Total formats: 1, used formats: 1 
    Average record length: 150.86, total records: 160402 
    Average version length: 137.36, total versions: 371, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.24 
    Pointer pages: 9, data page slots: 4584 
    Data pages: 4016, average fill: 82% 
    Primary pages: 4014, secondary pages: 2, swept pages: 45 
    Empty pages: 61, full pages: 3932 
    Fill distribution: 
     0 - 19% = 71 
    20 - 39% = 7 
    40 - 59% = 0 
    60 - 79% = 6 
    80 - 99% = 3932 
 
PHRASES (143) 
    Primary pointer page: 510, Index root page: 511 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index PHRASES_ID_DESC (3) 
    Root page: 1510376, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PHRASES_NAME (2) 
    Root page: 1510375, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PHRASES_UNQ (1) 
    Root page: 1510374, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PK_PHRASES (0) 
    Root page: 1510373, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
PSTORNED (147) 
    Primary pointer page: 518, Index root page: 519 
    Total formats: 1, used formats: 1 
    Average record length: 52.41, total records: 2087451 
    Average version length: 52.91, total versions: 15975, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 70.00, compression ratio: 1.34 
    Pointer pages: 16, data page slots: 25656 
    Data pages: 25656, average fill: 70% 
    Primary pages: 25644, secondary pages: 12, swept pages: 12594 
    Empty pages: 92, full pages: 21464 
    Fill distribution: 
     0 - 19% = 215 
    20 - 39% = 287 
    40 - 59% = 1029 
    60 - 79% = 23986 
    80 - 99% = 139 
 
    Index PSTORNED_RCV_ID (1) 
    Root page: 1506208, depth: 3, leaf buckets: 2587, nodes: 2087451 
    Average node length: 5.44, total dup: 1948059, max dup: 1513 
    Average key length: 2.49, compression ratio: 3.62 
    Average prefix length: 8.58, average data length: 0.42 
    Clustering factor: 181360, ratio: 0.09 
    Fill distribution: 
         0 - 19% = 3 
        20 - 39% = 339 
        40 - 59% = 1656 
        60 - 79% = 301 
        80 - 99% = 288 
 
    Index PSTORNED_SND_ID (0) 
    Root page: 1504841, depth: 3, leaf buckets: 2754, nodes: 2087451 
    Average node length: 5.69, total dup: 1873391, max dup: 64 
    Average key length: 2.74, compression ratio: 3.29 
    Average prefix length: 8.36, average data length: 0.64 
    Clustering factor: 373798, ratio: 0.18 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 9 
        40 - 59% = 2434 
        60 - 79% = 292 
        80 - 99% = 19 
 
    Index PSTORNED_WORKER_ID (2) 
    Root page: 1508018, depth: 3, leaf buckets: 2065, nodes: 2087451 
    Average node length: 4.96, total dup: 2087351, max dup: 28092 
    Average key length: 2.00, compression ratio: 1.20 
    Average prefix length: 2.41, average data length: 0.00 
    Clustering factor: 179150, ratio: 0.09 
    Fill distribution: 
         0 - 19% = 3 
        20 - 39% = 184 
        40 - 59% = 1013 
        60 - 79% = 389 
        80 - 99% = 476 
 
RULES_FOR_PDISTR (148) 
    Primary pointer page: 520, Index root page: 521 
    Total formats: 1, used formats: 1 
    Average record length: 17.00, total records: 4 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 334.00, compression ratio: 19.65 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 2% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index RULES_FOR_PDISTR_UNQ (0) 
    Root page: 1504339, depth: 1, leaf buckets: 1, nodes: 4 
    Average node length: 11.50, total dup: 0, max dup: 0 
    Average key length: 10.25, compression ratio: 0.88 
    Average prefix length: 1.50, average data length: 7.50 
    Clustering factor: 1, ratio: 0.25 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
RULES_FOR_QDISTR (137) 
    Primary pointer page: 498, Index root page: 499 
    Total formats: 1, used formats: 1 
    Average record length: 32.71, total records: 7 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 332.00, compression ratio: 10.15 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 4% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index RULES_FOR_QDISTR_RCVOP (1) 
    Root page: 1544825, depth: 1, leaf buckets: 1, nodes: 7 
    Average node length: 5.29, total dup: 2, max dup: 2 
    Average key length: 4.14, compression ratio: 0.72 
    Average prefix length: 1.43, average data length: 1.57 
    Clustering factor: 1, ratio: 0.14 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index RULES_FOR_QDISTR_UNQ (0) 
    Root page: 1544824, depth: 1, leaf buckets: 1, nodes: 7 
    Average node length: 10.14, total dup: 0, max dup: 0 
    Average key length: 8.86, compression ratio: 0.94 
    Average prefix length: 2.14, average data length: 6.14 
    Clustering factor: 1, ratio: 0.14 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
SEMAPHORES (152) 
    Primary pointer page: 528, Index root page: 529 
    Total formats: 1, used formats: 1 
    Average record length: 43.40, total records: 5 
    Average version length: 9.00, total versions: 1, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 346.00, compression ratio: 7.97 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 4% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index PK_SEMAPHORES (0) 
    Root page: 1504327, depth: 1, leaf buckets: 1, nodes: 5 
    Average node length: 12.40, total dup: 0, max dup: 0 
    Average key length: 11.00, compression ratio: 0.82 
    Average prefix length: 0.60, average data length: 8.40 
    Clustering factor: 1, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index SEMAPHORES_TASK_UNQ (1) 
    Root page: 1504328, depth: 1, leaf buckets: 1, nodes: 5 
    Average node length: 23.40, total dup: 0, max dup: 0 
    Average key length: 22.00, compression ratio: 1.07 
    Average prefix length: 4.20, average data length: 19.40 
    Clustering factor: 1, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
SETTINGS (135) 
    Primary pointer page: 494, Index root page: 495 
    Total formats: 1, used formats: 1 
    Average record length: 97.62, total records: 149 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1347.00, compression ratio: 13.80 
    Pointer pages: 1, data page slots: 3 
    Data pages: 3, average fill: 70% 
    Primary pages: 3, secondary pages: 0, swept pages: 1 
    Empty pages: 0, full pages: 2 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 1 
    60 - 79% = 0 
    80 - 99% = 2 
 
    Index SETTINGS_MCODE_WM_UNQ (1) 
    Root page: 1544931, depth: 1, leaf buckets: 1, nodes: 149 
    Average node length: 14.66, total dup: 0, max dup: 0 
    Average key length: 13.55, compression ratio: 2.19 
    Average prefix length: 19.07, average data length: 10.66 
    Clustering factor: 48, ratio: 0.32 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 1 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index SETTINGS_MODE_CODE (0) 
    Root page: 1544828, depth: 1, leaf buckets: 1, nodes: 149 
    Average node length: 25.56, total dup: 0, max dup: 0 
    Average key length: 24.56, compression ratio: 1.63 
    Average prefix length: 18.58, average data length: 21.56 
    Clustering factor: 14, ratio: 0.09 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 0 
        40 - 59% = 1 
        60 - 79% = 0 
        80 - 99% = 0 
 
TMP$DEP_DOCS (129) 
    Primary pointer page: 482, Index root page: 483 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index TMP_DEP_DOCS_UNQ (0) 
    Root page: 1544832, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
TMP$IDX_RECALC (132) 
    Primary pointer page: 488, Index root page: 489 
    Total formats: 2, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index TMP_IDX_RECALC_IDX_NAME_UNQ (0) 
    Root page: 1544829, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
TMP$MON_LOG (133) 
    Primary pointer page: 490, Index root page: 491 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
TMP$MON_LOG_TABLE_STATS (134) 
    Primary pointer page: 492, Index root page: 493 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
TMP$PERF_EST_WHOLE (161) 
    Primary pointer page: 546, Index root page: 547 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
TMP$PERF_LOG (160) 
    Primary pointer page: 544, Index root page: 545 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index TMP$PERF_LOG_UNIT_TRN_DTS_END (0) 
    Root page: 1504252, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
TMP$PERF_MON (131) 
    Primary pointer page: 486, Index root page: 487 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
TMP$RESULT_SET (130) 
    Primary pointer page: 484, Index root page: 485 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index TMP_RESULT_SET_DOC (1) 
    Root page: 1544831, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index TMP_RESULT_SET_WARE_DOC (0) 
    Root page: 1544830, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
TMP$SHOPPING_CART (128) 
    Primary pointer page: 480, Index root page: 481 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index TMP_SHOPCART_UNQ (0) 
    Root page: 1544833, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
TPAUSE (166) 
    Primary pointer page: 557, Index root page: 558 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index RDB$PRIMARY2 (0) 
    Root page: 1504237, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
TRACE_STAT (157) 
    Primary pointer page: 538, Index root page: 539 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
WARES (142) 
    Primary pointer page: 508, Index root page: 509 
    Total formats: 1, used formats: 1 
    Average record length: 77.52, total records: 400 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 444.00, compression ratio: 5.73 
    Pointer pages: 1, data page slots: 6 
    Data pages: 6, average fill: 77% 
    Primary pages: 6, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 5 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 5 
    80 - 99% = 1 
 
    Index FK_WARES_WARE_GROUPS (3) 
    Root page: 1552183, depth: 1, leaf buckets: 1, nodes: 400 
    Average node length: 3.17, total dup: 392, max dup: 60 
    Average key length: 2.16, compression ratio: 4.16 
    Average prefix length: 8.86, average data length: 0.14 
    Clustering factor: 48, ratio: 0.12 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PK_WARES (0) 
    Root page: 1510377, depth: 1, leaf buckets: 1, nodes: 400 
    Average node length: 11.22, total dup: 0, max dup: 0 
    Average key length: 10.22, compression ratio: 0.88 
    Average prefix length: 1.78, average data length: 7.22 
    Clustering factor: 344, ratio: 0.86 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 0 
        40 - 59% = 1 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index WARES_ID_DESC (2) 
    Root page: 1510382, depth: 1, leaf buckets: 1, nodes: 400 
    Average node length: 11.22, total dup: 0, max dup: 0 
    Average key length: 10.22, compression ratio: 0.88 
    Average prefix length: 1.78, average data length: 7.22 
    Clustering factor: 344, ratio: 0.86 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 0 
        40 - 59% = 1 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index WARES_NUMB_UNQ (1) 
    Root page: 1510380, depth: 2, leaf buckets: 3, nodes: 400 
    Average node length: 53.25, total dup: 0, max dup: 0 
    Average key length: 52.23, compression ratio: 1.00 
    Average prefix length: 2.74, average data length: 49.25 
    Clustering factor: 355, ratio: 0.89 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 1 
        80 - 99% = 2 
 
WARE_GROUPS (151) 
    Primary pointer page: 526, Index root page: 527 
    Total formats: 1, used formats: 1 
    Average record length: 32.12, total records: 8 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 346.00, compression ratio: 10.77 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 5% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index PK_WARE_GROUPS (0) 
    Root page: 1504329, depth: 1, leaf buckets: 1, nodes: 8 
    Average node length: 11.25, total dup: 0, max dup: 0 
    Average key length: 10.12, compression ratio: 0.89 
    Average prefix length: 1.75, average data length: 7.25 
    Clustering factor: 1, ratio: 0.12 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index WARE_GROUPS_NAME_UNQ (1) 
    Root page: 1504330, depth: 1, leaf buckets: 1, nodes: 8 
    Average node length: 19.88, total dup: 0, max dup: 0 
    Average key length: 18.12, compression ratio: 0.89 
    Average prefix length: 0.25, average data length: 15.88 
    Clustering factor: 1, ratio: 0.12 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
XQD_1000_1200 (176) 
    Primary pointer page: 577, Index root page: 578 
    Total formats: 1, used formats: 1 
    Average record length: 49.88, total records: 121719 
    Average version length: 69.17, total versions: 39060, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 2.53 
    Pointer pages: 3, data page slots: 4120 
    Data pages: 2943, average fill: 49% 
    Primary pages: 2943, secondary pages: 0, swept pages: 428 
    Empty pages: 429, full pages: 797 
    Fill distribution: 
     0 - 19% = 579 
    20 - 39% = 362 
    40 - 59% = 742 
    60 - 79% = 936 
    80 - 99% = 324 
 
    Index XQD_1000_1200_WA_SO_RO_WKR_SND (0) 
    Root page: 1555189, depth: 3, leaf buckets: 221, nodes: 121719 
    Average node length: 6.53, total dup: 105769, max dup: 14 
    Average key length: 4.00, compression ratio: 10.50 
    Average prefix length: 40.13, average data length: 1.87 
    Clustering factor: 22150, ratio: 0.18 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 87 
        40 - 59% = 99 
        60 - 79% = 35 
        80 - 99% = 0 
 
XQD_1000_3300 (178) 
    Primary pointer page: 581, Index root page: 582 
    Total formats: 1, used formats: 1 
    Average record length: 66.89, total records: 6978723 
    Average version length: 68.78, total versions: 239080, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.88 
    Pointer pages: 67, data page slots: 108320 
    Data pages: 108320, average fill: 69% 
    Primary pages: 108319, secondary pages: 1, swept pages: 52315 
    Empty pages: 8, full pages: 40130 
    Fill distribution: 
     0 - 19% = 34 
    20 - 39% = 513 
    40 - 59% = 11481 
    60 - 79% = 95558 
    80 - 99% = 734 
 
    Index XQD_1000_3300_WA_SO_RO_WKR_SND (0) 
    Root page: 1480476, depth: 3, leaf buckets: 10752, nodes: 6978723 
    Average node length: 6.51, total dup: 6036016, max dup: 29 
    Average key length: 3.52, compression ratio: 11.92 
    Average prefix length: 40.61, average data length: 1.39 
    Clustering factor: 1636625, ratio: 0.23 
    Fill distribution: 
         0 - 19% = 10 
        20 - 39% = 1843 
        40 - 59% = 5879 
        60 - 79% = 2647 
        80 - 99% = 373 
 
    Index XQD_1000_3300_WKR_DOC_ASC (1) 
    Root page: 1486090, depth: 3, leaf buckets: 8619, nodes: 6978723 
    Average node length: 5.40, total dup: 6697809, max dup: 128 
    Average key length: 2.41, compression ratio: 7.05 
    Average prefix length: 16.63, average data length: 0.37 
    Clustering factor: 1440417, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 8 
        20 - 39% = 1421 
        40 - 59% = 4731 
        60 - 79% = 1571 
        80 - 99% = 888 
 
    Index XQD_1000_3300_WKR_DOC_DEC (2) 
    Root page: 1490630, depth: 3, leaf buckets: 8697, nodes: 6978723 
    Average node length: 5.40, total dup: 6697809, max dup: 128 
    Average key length: 2.41, compression ratio: 7.05 
    Average prefix length: 16.63, average data length: 0.37 
    Clustering factor: 1442862, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 3 
        20 - 39% = 1523 
        40 - 59% = 4731 
        60 - 79% = 1554 
        80 - 99% = 886 
 
XQD_1200_2000 (177) 
    Primary pointer page: 579, Index root page: 580 
    Total formats: 1, used formats: 1 
    Average record length: 67.99, total records: 12056373 
    Average version length: 68.75, total versions: 191411, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.85 
    Pointer pages: 109, data page slots: 177120 
    Data pages: 177120, average fill: 72% 
    Primary pages: 177118, secondary pages: 2, swept pages: 98459 
    Empty pages: 8, full pages: 130430 
    Fill distribution: 
     0 - 19% = 40 
    20 - 39% = 638 
    40 - 59% = 7754 
    60 - 79% = 167751 
    80 - 99% = 937 
 
    Index XQD_1200_2000_WA_SO_RO_WKR_SND (0) 
    Root page: 1495050, depth: 3, leaf buckets: 18479, nodes: 12055118 
    Average node length: 6.62, total dup: 10511004, max dup: 54 
    Average key length: 3.42, compression ratio: 12.27 
    Average prefix length: 40.70, average data length: 1.30 
    Clustering factor: 2463938, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 17 
        20 - 39% = 2359 
        40 - 59% = 10743 
        60 - 79% = 4664 
        80 - 99% = 696 
 
XQD_2000_3300 (179) 
    Primary pointer page: 583, Index root page: 584 
    Total formats: 1, used formats: 1 
    Average record length: 54.91, total records: 1291767 
    Average version length: 69.11, total versions: 208543, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 2.29 
    Pointer pages: 27, data page slots: 42160 
    Data pages: 28847, average fill: 48% 
    Primary pages: 28780, secondary pages: 67, swept pages: 13147 
    Empty pages: 4602, full pages: 13149 
    Fill distribution: 
     0 - 19% = 7324 
    20 - 39% = 4222 
    40 - 59% = 3176 
    60 - 79% = 11671 
    80 - 99% = 2454 
 
    Index XQD_2000_3300_WA_SO_RO_WKR_SND (0) 
    Root page: 1479735, depth: 3, leaf buckets: 1780, nodes: 1194193 
    Average node length: 5.53, total dup: 1145724, max dup: 49 
    Average key length: 2.58, compression ratio: 16.30 
    Average prefix length: 41.46, average data length: 0.54 
    Clustering factor: 84343, ratio: 0.07 
    Fill distribution: 
         0 - 19% = 8 
        20 - 39% = 642 
        40 - 59% = 829 
        60 - 79% = 278 
        80 - 99% = 23 
 
XQD_2100_3300 (180) 
    Primary pointer page: 585, Index root page: 586 
    Total formats: 1, used formats: 1 
    Average record length: 49.80, total records: 847896 
    Average version length: 69.03, total versions: 93234, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 2.53 
    Pointer pages: 23, data page slots: 36536 
    Data pages: 27072, average fill: 31% 
    Primary pages: 27072, secondary pages: 0, swept pages: 10786 
    Empty pages: 5879, full pages: 3084 
    Fill distribution: 
     0 - 19% = 9494 
    20 - 39% = 6200 
    40 - 59% = 8178 
    60 - 79% = 3168 
    80 - 99% = 32 
 
    Index XQD_2100_3300_WA_SO_RO_WKR_SND (0) 
    Root page: 1479229, depth: 3, leaf buckets: 1102, nodes: 669586 
    Average node length: 5.99, total dup: 615073, max dup: 49 
    Average key length: 3.05, compression ratio: 13.76 
    Average prefix length: 41.03, average data length: 0.97 
    Clustering factor: 97732, ratio: 0.15 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 435 
        40 - 59% = 498 
        60 - 79% = 157 
        80 - 99% = 11 
 
XQD_3300_3400 (181) 
    Primary pointer page: 587, Index root page: 588 
    Total formats: 1, used formats: 1 
    Average record length: 67.57, total records: 8898317 
    Average version length: 68.99, total versions: 195178, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.86 
    Pointer pages: 89, data page slots: 143696 
    Data pages: 143664, average fill: 66% 
    Primary pages: 143638, secondary pages: 26, swept pages: 81290 
    Empty pages: 388, full pages: 54862 
    Fill distribution: 
     0 - 19% = 1247 
    20 - 39% = 5432 
    40 - 59% = 23558 
    60 - 79% = 112615 
    80 - 99% = 812 
 
    Index XQD_3300_3400_WA_SO_RO_WKR_SND (0) 
    Root page: 1472612, depth: 3, leaf buckets: 13453, nodes: 8896560 
    Average node length: 6.68, total dup: 7377658, max dup: 14 
    Average key length: 3.67, compression ratio: 11.44 
    Average prefix length: 40.50, average data length: 1.50 
    Clustering factor: 2012375, ratio: 0.23 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 1645 
        40 - 59% = 7189 
        60 - 79% = 4049 
        80 - 99% = 568 
 
XQS_1000_1200 (182) 
    Primary pointer page: 589, Index root page: 590 
    Total formats: 1, used formats: 1 
    Average record length: 82.51, total records: 21121067 
    Average version length: 82.75, total versions: 6790, 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: 319496 
    Data pages: 319496, average fill: 81% 
    Primary pages: 319489, secondary pages: 7, swept pages: 14623 
    Empty pages: 48, full pages: 318336 
    Fill distribution: 
     0 - 19% = 81 
    20 - 39% = 58 
    40 - 59% = 152 
    60 - 79% = 49590 
    80 - 99% = 269615 
 
    Index XQS_1000_1200_DOC_ID (1) 
    Root page: 1426738, depth: 3, leaf buckets: 19556, nodes: 21121067 
    Average node length: 5.72, total dup: 20640585, max dup: 143 
    Average key length: 2.16, compression ratio: 4.16 
    Average prefix length: 8.86, average data length: 0.14 
    Clustering factor: 3280476, ratio: 0.16 
    Fill distribution: 
         0 - 19% = 7 
        20 - 39% = 1 
        40 - 59% = 8500 
        60 - 79% = 557 
        80 - 99% = 10491 
 
    Index XQS_1000_1200_RCV_ID (3) 
    Root page: 1457002, depth: 3, leaf buckets: 17156, nodes: 21121067 
    Average node length: 6.31, total dup: 18561253, max dup: 49 
    Average key length: 2.75, compression ratio: 3.27 
    Average prefix length: 8.37, average data length: 0.63 
    Clustering factor: 917579, ratio: 0.04 
    Fill distribution: 
         0 - 19% = 4 
        20 - 39% = 7 
        40 - 59% = 752 
        60 - 79% = 300 
        80 - 99% = 16093 
 
    Index XQS_1000_1200_SND_ID (2) 
    Root page: 1441095, depth: 3, leaf buckets: 21352, nodes: 21121067 
    Average node length: 6.35, total dup: 18480031, max dup: 29 
    Average key length: 2.79, compression ratio: 3.23 
    Average prefix length: 8.34, average data length: 0.66 
    Clustering factor: 3573686, ratio: 0.17 
    Fill distribution: 
         0 - 19% = 4 
        20 - 39% = 0 
        40 - 59% = 8842 
        60 - 79% = 577 
        80 - 99% = 11929 
 
    Index XQS_1000_1200_WORKER_ID (0) 
    Root page: 1413370, depth: 3, leaf buckets: 16079, nodes: 21121067 
    Average node length: 5.56, total dup: 21120967, max dup: 230384 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.42, average data length: 0.00 
    Clustering factor: 946282, ratio: 0.04 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 13 
        40 - 59% = 2877 
        60 - 79% = 362 
        80 - 99% = 12827 
 
XQS_1000_3300 (184) 
    Primary pointer page: 593, Index root page: 594 
    Total formats: 1, used formats: 1 
    Average record length: 81.07, total records: 9328942 
    Average version length: 82.67, total versions: 170835, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.55 
    Pointer pages: 105, data page slots: 170904 
    Data pages: 170848, average fill: 67% 
    Primary pages: 170803, secondary pages: 45, swept pages: 104472 
    Empty pages: 614, full pages: 82833 
    Fill distribution: 
     0 - 19% = 1935 
    20 - 39% = 8884 
    40 - 59% = 29043 
    60 - 79% = 116210 
    80 - 99% = 14776 
 
    Index XQS_1000_3300_DOC_ID (1) 
    Root page: 1367524, depth: 3, leaf buckets: 11330, nodes: 9328942 
    Average node length: 5.37, total dup: 9023445, max dup: 151 
    Average key length: 2.24, compression ratio: 4.02 
    Average prefix length: 8.79, average data length: 0.21 
    Clustering factor: 2136506, ratio: 0.23 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 119 
        40 - 59% = 9098 
        60 - 79% = 2084 
        80 - 99% = 27 
 
    Index XQS_1000_3300_RCV_ID (3) 
    Root page: 1379283, depth: 3, leaf buckets: 13360, nodes: 9328942 
    Average node length: 6.23, total dup: 7731888, max dup: 14 
    Average key length: 3.10, compression ratio: 2.90 
    Average prefix length: 8.07, average data length: 0.93 
    Clustering factor: 1509598, ratio: 0.16 
    Fill distribution: 
         0 - 19% = 122 
        20 - 39% = 4002 
        40 - 59% = 4592 
        60 - 79% = 2625 
        80 - 99% = 2019 
 
    Index XQS_1000_3300_SND_ID (2) 
    Root page: 1373081, depth: 3, leaf buckets: 12640, nodes: 9328942 
    Average node length: 5.99, total dup: 8083714, max dup: 35 
    Average key length: 2.86, compression ratio: 3.15 
    Average prefix length: 8.27, average data length: 0.73 
    Clustering factor: 2313216, ratio: 0.25 
    Fill distribution: 
         0 - 19% = 4 
        20 - 39% = 141 
        40 - 59% = 10144 
        60 - 79% = 2308 
        80 - 99% = 43 
 
    Index XQS_1000_3300_WORKER_ID (0) 
    Root page: 1362789, depth: 3, leaf buckets: 9907, nodes: 9328942 
    Average node length: 5.13, total dup: 9328842, max dup: 142289 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.41, average data length: 0.00 
    Clustering factor: 1541105, ratio: 0.17 
    Fill distribution: 
         0 - 19% = 45 
        20 - 39% = 1327 
        40 - 59% = 4910 
        60 - 79% = 1735 
        80 - 99% = 1890 
 
XQS_1200_2000 (183) 
    Primary pointer page: 591, Index root page: 592 
    Total formats: 1, used formats: 1 
    Average record length: 81.30, total records: 10982385 
    Average version length: 82.61, total versions: 148842, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.55 
    Pointer pages: 117, data page slots: 190856 
    Data pages: 189136, average fill: 71% 
    Primary pages: 189003, secondary pages: 133, swept pages: 76929 
    Empty pages: 2746, full pages: 138251 
    Fill distribution: 
     0 - 19% = 4755 
    20 - 39% = 7821 
    40 - 59% = 18971 
    60 - 79% = 100813 
    80 - 99% = 56776 
 
    Index XQS_1200_2000_DOC_ID (1) 
    Root page: 1392123, depth: 3, leaf buckets: 13091, nodes: 10982385 
    Average node length: 5.30, total dup: 10873294, max dup: 624 
    Average key length: 2.08, compression ratio: 4.32 
    Average prefix length: 8.93, average data length: 0.07 
    Clustering factor: 2304896, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 172 
        40 - 59% = 9945 
        60 - 79% = 2910 
        80 - 99% = 62 
 
    Index XQS_1200_2000_RCV_ID (3) 
    Root page: 1406132, depth: 3, leaf buckets: 10282, nodes: 10982385 
    Average node length: 5.49, total dup: 10501956, max dup: 49 
    Average key length: 2.28, compression ratio: 3.95 
    Average prefix length: 8.77, average data length: 0.23 
    Clustering factor: 707831, ratio: 0.06 
    Fill distribution: 
         0 - 19% = 171 
        20 - 39% = 933 
        40 - 59% = 2542 
        60 - 79% = 1860 
        80 - 99% = 4776 
 
    Index XQS_1200_2000_SND_ID (2) 
    Root page: 1398660, depth: 3, leaf buckets: 14967, nodes: 10982385 
    Average node length: 6.03, total dup: 9577033, max dup: 69 
    Average key length: 2.81, compression ratio: 3.20 
    Average prefix length: 8.32, average data length: 0.68 
    Clustering factor: 2321170, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 229 
        40 - 59% = 11477 
        60 - 79% = 3180 
        80 - 99% = 80 
 
    Index XQS_1200_2000_WORKER_ID (0) 
    Root page: 1386233, depth: 3, leaf buckets: 10612, nodes: 10982385 
    Average node length: 5.22, total dup: 10982285, max dup: 173726 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.41, average data length: 0.00 
    Clustering factor: 696988, ratio: 0.06 
    Fill distribution: 
         0 - 19% = 106 
        20 - 39% = 880 
        40 - 59% = 4752 
        60 - 79% = 1578 
        80 - 99% = 3296 
 
XQS_2000_3300 (185) 
    Primary pointer page: 595, Index root page: 596 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index XQS_2000_3300_DOC_ID (1) 
    Root page: 1361775, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index XQS_2000_3300_RCV_ID (3) 
    Root page: 1361777, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index XQS_2000_3300_SND_ID (2) 
    Root page: 1361776, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index XQS_2000_3300_WORKER_ID (0) 
    Root page: 1361774, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
XQS_2100_3300 (186) 
    Primary pointer page: 597, Index root page: 598 
    Total formats: 1, used formats: 1 
    Average record length: 81.40, total records: 9442541 
    Average version length: 82.95, total versions: 171000, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.55 
    Pointer pages: 107, data page slots: 174552 
    Data pages: 174472, average fill: 67% 
    Primary pages: 174431, secondary pages: 41, swept pages: 106875 
    Empty pages: 655, full pages: 83899 
    Fill distribution: 
     0 - 19% = 2055 
    20 - 39% = 10145 
    40 - 59% = 30651 
    60 - 79% = 117126 
    80 - 99% = 14495 
 
    Index XQS_2100_3300_DOC_ID (1) 
    Root page: 1344708, depth: 3, leaf buckets: 11578, nodes: 9442541 
    Average node length: 5.17, total dup: 9414342, max dup: 1505 
    Average key length: 2.03, compression ratio: 4.43 
    Average prefix length: 8.97, average data length: 0.03 
    Clustering factor: 1944612, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 25 
        20 - 39% = 1606 
        40 - 59% = 7670 
        60 - 79% = 1747 
        80 - 99% = 530 
 
    Index XQS_2100_3300_RCV_ID (3) 
    Root page: 1355739, depth: 3, leaf buckets: 13524, nodes: 9442541 
    Average node length: 6.25, total dup: 7825931, max dup: 14 
    Average key length: 3.10, compression ratio: 2.90 
    Average prefix length: 8.07, average data length: 0.93 
    Clustering factor: 1480291, ratio: 0.16 
    Fill distribution: 
         0 - 19% = 162 
        20 - 39% = 4112 
        40 - 59% = 4502 
        60 - 79% = 2600 
        80 - 99% = 2148 
 
    Index XQS_2100_3300_SND_ID (2) 
    Root page: 1350071, depth: 3, leaf buckets: 12216, nodes: 9442541 
    Average node length: 5.43, total dup: 9016087, max dup: 87 
    Average key length: 2.29, compression ratio: 3.93 
    Average prefix length: 8.76, average data length: 0.24 
    Clustering factor: 2072902, ratio: 0.22 
    Fill distribution: 
         0 - 19% = 33 
        20 - 39% = 1600 
        40 - 59% = 8493 
        60 - 79% = 1581 
        80 - 99% = 509 
 
    Index XQS_2100_3300_WORKER_ID (0) 
    Root page: 987843, depth: 3, leaf buckets: 10141, nodes: 9442541 
    Average node length: 5.15, total dup: 9442441, max dup: 143856 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.41, average data length: 0.00 
    Clustering factor: 1559027, ratio: 0.17 
    Fill distribution: 
         0 - 19% = 32 
        20 - 39% = 1462 
        40 - 59% = 5066 
        60 - 79% = 1697 
        80 - 99% = 1884 
 
XQS_3300_3400 (187) 
    Primary pointer page: 599, Index root page: 600 
    Total formats: 1, used formats: 1 
    Average record length: 67.90, total records: 572767 
    Average version length: 68.71, total versions: 2608, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.86 
    Pointer pages: 5, data page slots: 8048 
    Data pages: 8048, average fill: 74% 
    Primary pages: 8048, secondary pages: 0, swept pages: 4104 
    Empty pages: 1, full pages: 6749 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 11 
    40 - 59% = 137 
    60 - 79% = 7875 
    80 - 99% = 24 
 
    Index XQS_3300_3400_DOC_ID (1) 
    Root page: 38782, depth: 3, leaf buckets: 728, nodes: 572767 
    Average node length: 5.95, total dup: 487637, max dup: 83 
    Average key length: 3.09, compression ratio: 2.91 
    Average prefix length: 8.06, average data length: 0.94 
    Clustering factor: 100820, ratio: 0.18 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 31 
        40 - 59% = 521 
        60 - 79% = 80 
        80 - 99% = 96 
 
    Index XQS_3300_3400_SND_ID (2) 
    Root page: 31025, depth: 3, leaf buckets: 753, nodes: 572767 
    Average node length: 6.15, total dup: 469721, max dup: 19 
    Average key length: 3.29, compression ratio: 2.73 
    Average prefix length: 7.89, average data length: 1.11 
    Clustering factor: 100880, ratio: 0.18 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 42 
        40 - 59% = 523 
        60 - 79% = 82 
        80 - 99% = 106 
 
    Index XQS_3300_3400_WORKER_ID (0) 
    Root page: 377587, depth: 2, leaf buckets: 559, nodes: 572767 
    Average node length: 4.86, total dup: 572667, max dup: 9682 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.41, average data length: 0.00 
    Clustering factor: 89727, ratio: 0.16 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 31 
        40 - 59% = 314 
        60 - 79% = 79 
        80 - 99% = 134 
 
ZDOC_DATA (170) 
    Primary pointer page: 565, Index root page: 566 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
ZDOC_LIST (169) 
    Primary pointer page: 563, Index root page: 564 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
ZINVNT_TURNOVER_LOG (171) 
    Primary pointer page: 567, Index root page: 568 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
ZPDISTR (174) 
    Primary pointer page: 573, Index root page: 574 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index ZPDISTR_ID (0) 
    Root page: 1504230, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
ZPSTORNED (175) 
    Primary pointer page: 575, Index root page: 576 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index ZPSTORNED_ID (0) 
    Root page: 1504229, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
ZQDISTR (172) 
    Primary pointer page: 569, Index root page: 570 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index ZQDISTR_ID (0) 
    Root page: 1504235, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index ZQDISTR_WARE_SNDOP_RCVOP (1) 
    Root page: 1504236, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
ZQSTORNED (173) 
    Primary pointer page: 571, Index root page: 572 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index ZQSTORNED_DOC_ID (1) 
    Root page: 1504232, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index ZQSTORNED_ID (0) 
    Root page: 1504231, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index ZQSTORNED_RCV_ID (3) 
    Root page: 1504234, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index ZQSTORNED_SND_ID (2) 
    Root page: 1504233, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
ZTMP_DEP_DOCS (168) 
    Primary pointer page: 561, Index root page: 562 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
ZTMP_SHOPPING_CART (167) 
    Primary pointer page: 559, Index root page: 560 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
Z_USED_VIEWS (144) 
    Primary pointer page: 512, Index root page: 513 
    Total formats: 1, used formats: 1 
    Average record length: 29.38, total records: 29 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 99.00, compression ratio: 3.37 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 16% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index Z_USED_VIEWS_UNQ (0) 
    Root page: 1510372, depth: 1, leaf buckets: 1, nodes: 29 
    Average node length: 15.17, total dup: 0, max dup: 0 
    Average key length: 14.14, compression ratio: 1.44 
    Average prefix length: 9.17, average data length: 11.17 
    Clustering factor: 1, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
Gstat completion time Thu Feb 22 13:10:38 2024

Record versions statistics, table

TABLE_NAME TOTAL_RECS TOTAL_VERS MAX_VERSIONS VERS_TO_RECS_PRC MAXV_TO_VERS_PRC
DOC_DATA 7695636 42425 1 0.0000 0.0000
DOC_LIST 2215021 20210 2 0.0000 0.0000
FB_ERRORS 2182 757 1 0.0000 0.0000
INVNT_SALDO 400 1498 4 300.0000 0.0000
INVNT_TURNOVER_LOG 87619 81880 1 0.0000 0.0000
MONEY_SALDO 49 104 3 200.0000 0.0000
MONEY_TURNOVER_LOG 1293 1210 1 0.0000 0.0000
PDISTR 786302 17682 2 0.0000 0.0000
PERF_SPLIT_0 150199 4123 1 0.0000 0.0000
PERF_SPLIT_1 137658 253 1 0.0000 0.0000
PERF_SPLIT_2 144838 3105 1 0.0000 0.0000
PERF_SPLIT_3 151379 3760 1 0.0000 0.0000
PERF_SPLIT_4 151867 2838 1 0.0000 0.0000
PERF_SPLIT_5 151182 1165 1 0.0000 0.0000
PERF_SPLIT_6 187810 24975 1 0.0000 0.0000
PERF_SPLIT_7 155867 817 1 0.0000 0.0000
PERF_SPLIT_8 150019 8572 1 0.0000 0.0000
PERF_SPLIT_9 160402 371 1 0.0000 0.0000
PSTORNED 2087451 15975 1 0.0000 0.0000
SEMAPHORES 5 1 1 0.0000 100.0000
XQD_1000_1200 121719 39060 1 0.0000 0.0000
XQD_1000_3300 6978723 239080 1 0.0000 0.0000
XQD_1200_2000 12056373 191411 1 0.0000 0.0000
XQD_2000_3300 1291767 208543 1 0.0000 0.0000
XQD_2100_3300 847896 93234 1 0.0000 0.0000
XQD_3300_3400 8898317 195178 1 0.0000 0.0000
XQS_1000_1200 21121067 6790 1 0.0000 0.0000
XQS_1000_3300 9328942 170835 1 0.0000 0.0000
XQS_1200_2000 10982385 148842 1 0.0000 0.0000
XQS_2100_3300 9442541 171000 1 0.0000 0.0000
XQS_3300_3400 572767 2608 1 0.0000 0.0000

Record versions statistics, chart

Total records and versions, chart

Ratios versions / total_records and max_versions / total_versions

Database validation 


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

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

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

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

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