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

Hardware and OS info

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

Server and database settinfs 


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

Test configuration settings 

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

Test finish info 


FINISH_STATE                    NORMAL: TEST_TIME EXPIRED AT 2024-02-17 19:09:37
DTS_END                         2024-02-17 19:09:37.2220
FB_GDSCODE                      -1
FB_MNEMONA                      
STACK                           SP_ADD_INVOICE_TO_STOCK(190:30) ==> SP_CUSTOMER_RESERVE(47:5) ==> SP_CHECK_TO_STOP_WORK(32:12) ==> SP_HALT_ON_ERROR(57:17)
IP                              ::1/39140
TRN_ID                          173246
ATT_ID                          508
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: 8927.66 22633 892766
customer order: creation 169.20 416 16920
customer order: refuse 14.65 383 1465
order to supplier: creation 44.84 1363 4484
order to supplier: removal 3.40 110440 340
invoice (draft): creation 44.87 3581 4487
invoice (draft): removal 49.75 828 4975
invoice accept: apply 40.32 21228 4032
invoice accept: cancel 45.06 915 4506
customer reserve: creation 3860.73 204 386073
customer reserve: removal 4365.16 68 436516
realization accept: apply 81.95 193 8195
realization accept: cancel 78.48 129 7848
payment from customer: creation 59.51 132 5951
payment from customer: removal 5.90 100 590
payment to supplier: creation 48.06 157 4806
payment to supplier: removal 3.25 126 325
service: total inventory turnovers 4.91 1276 491
service: total monetary turnovers 6.67 41 667
service: aggregate perf. data 0.92 16934 92
service: refresh index statistics 0.03 294148 3

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:02, from 17-02-2024 19:10:41 to 17-02-2024 19:10:43.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 1985
TEST_TIME 2 3636
TEST_TIME 3 3538
TEST_TIME 4 3108
TEST_TIME 5 3813
TEST_TIME 6 4108
TEST_TIME 7 4232
TEST_TIME 8 4411
TEST_TIME 9 4775
TEST_TIME 10 5046
TEST_TIME 11 5459
TEST_TIME 12 5628
TEST_TIME 13 5650
TEST_TIME 14 5881
TEST_TIME 15 5994
TEST_TIME 16 6202
TEST_TIME 17 6599
TEST_TIME 18 6709
TEST_TIME 19 6786
TEST_TIME 20 6778
TEST_TIME 21 7067
TEST_TIME 22 7402
TEST_TIME 23 7549
TEST_TIME 24 7596
TEST_TIME 25 7748
TEST_TIME 26 7958
TEST_TIME 27 8274
TEST_TIME 28 9184
TEST_TIME 29 9355
TEST_TIME 30 9197
TEST_TIME 31 9712
TEST_TIME 32 9516
TEST_TIME 33 9316
TEST_TIME 34 9208
TEST_TIME 35 9079
TEST_TIME 36 8941
TEST_TIME 37 9007
TEST_TIME 38 8927
TEST_TIME 39 8908
TEST_TIME 40 8932
TEST_TIME 41 8862
TEST_TIME 42 8749
TEST_TIME 43 8701
TEST_TIME 44 8516
TEST_TIME 45 8569
TEST_TIME 46 8582
TEST_TIME 47 8810
TEST_TIME 48 8774
TEST_TIME 49 8726
TEST_TIME 50 8817
TEST_TIME 51 8872
TEST_TIME 52 8822
TEST_TIME 53 8948
TEST_TIME 54 8950
TEST_TIME 55 9077
TEST_TIME 56 9042
TEST_TIME 57 9020
TEST_TIME 58 9079
TEST_TIME 59 9135
TEST_TIME 60 9188
TEST_TIME 61 9112
TEST_TIME 62 8980
TEST_TIME 63 9016
TEST_TIME 64 8980
TEST_TIME 65 8967
TEST_TIME 66 8954
TEST_TIME 67 8911
TEST_TIME 68 8935
TEST_TIME 69 8937
TEST_TIME 70 8877
TEST_TIME 71 8822
TEST_TIME 72 8813
TEST_TIME 73 8859
TEST_TIME 74 8830
TEST_TIME 75 8827
TEST_TIME 76 8884
TEST_TIME 77 8910
TEST_TIME 78 8965
TEST_TIME 79 8961
TEST_TIME 80 8977
TEST_TIME 81 9028
TEST_TIME 82 8991
TEST_TIME 83 9030
TEST_TIME 84 9122
TEST_TIME 85 9146
TEST_TIME 86 9130
TEST_TIME 87 9108
TEST_TIME 88 9029
TEST_TIME 89 9004
TEST_TIME 90 8994
TEST_TIME 91 8955
TEST_TIME 92 8961
TEST_TIME 93 8921
TEST_TIME 94 8887
TEST_TIME 95 8900
TEST_TIME 96 8954
TEST_TIME 97 8933
TEST_TIME 98 8931
TEST_TIME 99 8959
TEST_TIME 100 8937

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:03, from 17-02-2024 19:10:45 to 17-02-2024 19:10:48.

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 1246220 1246220 0 0.00 0 22127 7 0 0
doc_list_biud 1246220 1246220 0 0.00 0 30940 30 0 0
sp_add_invoice_to_stock 4122 4032 90 2.18 37 178267 21228 0 90
sp_cancel_adding_invoice 4506 4506 0 0.00 5 60810 915 0 0
sp_cancel_client_order 1465 1465 0 0.00 4 14981 384 0 0
sp_cancel_customer_reserve 436516 436516 0 0.00 0 30953 68 0 0
sp_cancel_pay_from_customer 590 590 0 0.00 3 5441 101 0 0
sp_cancel_pay_to_supplier 325 325 0 0.00 3 4637 126 0 0
sp_cancel_supplier_invoice 4983 4975 8 0.16 2 23700 829 0 8
sp_cancel_supplier_order 340 340 0 0.00 12 922967 110440 0 0
sp_cancel_write_off 7848 7848 0 0.00 1 22218 129 0 0
sp_client_order 16920 16920 0 0.00 3 30031 416 0 0
sp_customer_reserve 386073 386073 0 0.00 0 40441 205 0 0
sp_fill_shopping_cart 25888 25888 0 0.00 1 25745 46 0 0
sp_fill_shopping_cart_clo_res 386066 386066 0 0.00 0 27363 16 0 0
sp_get_clo_for_invoice 4020 4020 0 0.00 0 24796 319 0 0
sp_kill_cost_storno 13269 13269 0 0.00 0 11270 67 0 0
sp_kill_qstorno_ret_qs2qd 886195 886195 0 0.00 0 29463 37 0 0
sp_kill_qty_storno 467865 467865 0 0.00 0 30938 79 0 0
sp_lock_selected_doc 16984 16984 0 0.00 0 3955 4 0 0
sp_make_cost_storno 22972 22972 0 0.00 0 16777 70 0 0
sp_multiply_rows_for_pdistr 22972 22972 0 0.00 0 7059 29 0 0
sp_multiply_rows_for_qdistr 16920 16920 0 0.00 0 23883 176 0 0
sp_pay_from_customer 5951 5951 0 0.00 4 11250 132 0 0
sp_pay_to_supplier 4806 4806 0 0.00 5 16806 158 0 0
sp_payment_common 10757 10757 0 0.00 1 8714 31 0 0
sp_qd_handle_on_cancel_clo 1465 1465 0 0.00 1 14971 357 0 0
sp_qd_handle_on_invoice_upd_sts 8526 8526 0 0.00 0 27066 372 0 0
sp_qd_handle_on_reserve_upd_sts 8195 8195 0 0.00 0 18143 71 0 0
sp_reserve_write_off 8195 8195 0 0.00 5 18185 193 0 0
sp_supplier_invoice 4487 4487 0 0.00 8 102497 3582 0 0
sp_supplier_order 4484 4484 0 0.00 4 37823 1363 0 0
srv_aggregate_perf_data 92 92 0 0.00 1495 151712 16935 0 0
srv_fill_mon_cache_memory 58 58 0 0.00 1886 113149 37167 0 0
srv_find_qd_qs_mism 851211 851211 0 0.00 0 22126 6 0 0
srv_make_invnt_saldo 491 491 0 0.00 43 134732 1277 0 0
srv_make_money_saldo 667 667 0 0.00 1 8956 42 0 0
srv_recalc_idx_stat 3 3 0 0.00 79699 545364 294148 0 0
t$perf-abend:sp_add_invoice_to_stock 90 90 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 4032 4032 0 0.00 0 10908 209 0 0
t$perf-norm:sp_cancel_adding_invoice 332 332 0 0.00 0 14342 151 0 0
t$perf-norm:sp_cancel_client_order 1465 1465 0 0.00 0 1280 11 0 0
t$perf-norm:sp_cancel_customer_reserve 564 564 0 0.00 0 4170 15 0 0
t$perf-norm:sp_cancel_pay_from_customer 590 590 0 0.00 0 4557 25 0 0
t$perf-norm:sp_cancel_pay_to_supplier 325 325 0 0.00 0 1460 10 0 0
t$perf-norm:sp_cancel_supplier_invoice 318 318 0 0.00 0 1061 21 0 0
t$perf-norm:sp_cancel_supplier_order 340 340 0 0.00 0 39102 1836 0 0
t$perf-norm:sp_cancel_write_off 835 835 0 0.00 0 1827 12 0 0
t$perf-norm:sp_client_order 16920 16920 0 0.00 0 6445 16 0 0
t$perf-norm:sp_customer_reserve 834 834 0 0.00 0 1214 6 0 0
t$perf-norm:sp_pay_from_customer 5951 5951 0 0.00 0 6058 13 0 0
t$perf-norm:sp_pay_to_supplier 4806 4806 0 0.00 0 10522 15 0 0
t$perf-norm:sp_reserve_write_off 8195 8195 0 0.00 0 8649 14 0 0
t$perf-norm:sp_supplier_invoice 4487 4487 0 0.00 0 7006 19 0 0
t$perf-norm:sp_supplier_order 4484 4484 0 0.00 0 3309 18 0 0
t$perf-norm:srv_aggregate_perf_data 92 92 0 0.00 0 227 9 0 0
t$perf-norm:srv_fill_mon_cache_memory 58 58 0 0.00 0 1146 20 0 0
t$perf-norm:srv_make_invnt_saldo 491 491 0 0.00 0 834 15 0 0
t$perf-norm:srv_make_money_saldo 667 667 0 0.00 0 5227 22 0 0
t$perf-norm:srv_recalc_idx_stat 3 3 0 0.00 1 16 8 0 0
v_add_invoice_to_stock 8220 8040 180 2.18 0 6194 19 0 180
v_all_customers 31310 31310 0 0.00 0 39 1 0 0
v_all_suppliers 25754 25754 0 0.00 0 20 1 0 0
v_all_wares 33838 33838 0 0.00 0 85 1 0 0
v_cancel_adding_invoice 664 664 0 0.00 0 3873 12 0 0
v_cancel_client_order 2930 2930 0 0.00 0 4554 7 0 0
v_cancel_customer_prepayment 1180 1180 0 0.00 0 3369 13 0 0
v_cancel_customer_reserve 1128 1128 0 0.00 0 1281 6 0 0
v_cancel_payment_to_supplier 650 650 0 0.00 0 3844 17 0 0
v_cancel_supplier_invoice 652 636 16 2.45 0 1382 20 0 16
v_cancel_supplier_order 680 680 0 0.00 0 732 4 0 0
v_cancel_write_off 1670 1670 0 0.00 0 4595 19 0 0
v_max_id_clo_ord 4483 4483 0 0.00 0 2570 3 0 0
v_max_id_clo_res 834 834 0 0.00 0 1288 8 0 0
v_max_id_ord_sup 4486 4486 0 0.00 0 6481 4 0 0
v_max_non_paid_invoice 898 898 0 0.00 0 3357 10 0 0
v_max_non_paid_realizn 2883 2883 0 0.00 0 5323 9 0 0
v_min_id_clo_ord 4483 4483 0 0.00 0 12754 22 0 0
v_min_id_clo_res 834 834 0 0.00 0 2675 9 0 0
v_min_id_ord_sup 4486 4486 0 0.00 0 3933 6 0 0
v_min_non_paid_invoice 4806 4806 0 0.00 0 7007 20 0 0
v_min_non_paid_realizn 5951 5951 0 0.00 0 8703 23 0 0
v_our_firm 8664 8664 0 0.00 0 42 1 0 0
v_reserve_write_off 16390 16390 0 0.00 0 3980 6 0 0
x_lock_depdocs_on_canc_invoice 9163 9163 0 0.00 0 13413 145 0 0
x_lock_depdocs_on_canc_sup_ord 340 340 0 0.00 0 5223 363 0 0
x_make_qstorno_1000_1200 4484 4484 0 0.00 1 37799 1263 0 0
x_make_qstorno_1200_2000 4487 4487 0 0.00 3 102482 3422 0 0
x_make_qstorno_2100_3300 386073 386073 0 0.00 0 40410 186 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 17-02-2024 19:10:49 to 17-02-2024 19:10:53.

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
17:09:41 2 8192000000 8797116768 8807743488 3953616 0.048 1 1 2 0 4051888 55488 42784
17:10:42 36500 8192000000 9899083584 10206457856 972094768 10.607 100 84 168 0 999756496 5640896 22020832
17:12:23 8467 8192000000 9943537872 10261700608 1024899904 11.119 100 90 180 0 1055734912 7855728 22979280
17:13:38 8835 8192000000 9969376544 10296311808 1054826656 11.407 100 88 176 1 1085995760 9368848 21800256
17:14:56 11560 8192000000 10017313408 10358661120 1102401616 11.860 100 79 159 2 1132185056 11138576 18644864
17:16:11 7275 8192000000 10075885584 10431217664 1163753360 12.438 100 84 167 0 1194928048 11803184 19371504
17:17:20 2653 8192000000 10119011152 10485235712 1205956512 12.832 100 83 168 0 1237248400 12484160 18807728
17:18:24 1866 8192000000 10151575600 10526347264 1243081712 13.175 100 82 164 1 1274698848 13873488 17743648
17:19:28 1456 8192000000 10186923792 10565050368 1268431600 13.407 100 91 183 0 1302597680 14264656 19901424
17:20:31 647 8192000000 10208865360 10591637504 1295924096 13.658 100 93 186 1 1330880976 14206800 20750080
17:21:33 52468 8192000000 10212874576 10615504896 1308505536 13.773 100 54 107 0 1329323920 8201120 12617264
17:23:27 7155 8192000000 10210886704 10627670016 1320319184 13.880 100 25 50 0 1332105664 6138416 5648064
17:24:35 11797 8192000000 10219669632 10636386304 1329846992 13.966 100 29 58 0 1351680224 15359424 6473808
17:25:48 12902 8192000000 10223258816 10642182144 1335194640 14.014 100 14 28 0 1344690480 6221488 3274352
17:27:07 12619 8192000000 10225241584 10648854528 1337389904 14.034 100 19 35 1 1350423392 9583168 3450320
17:28:20 6434 8192000000 10227150464 10650771456 1341560480 14.071 100 28 57 0 1354009024 5780192 6668352
17:29:28 7493 8192000000 10206505600 10624245760 1309494704 13.781 99 18 36 1 1319602096 5636208 4471184
17:30:58 12590 8192000000 10240150416 10650550272 1334543120 14.008 100 50 97 0 1355952192 10508096 10900976
17:32:13 98226 8192000000 10261322176 10675179520 1332773056 13.992 99 52 104 0 1360104976 15398272 11933648
17:35:07 51534 8192000000 10244587280 10666258432 1312559856 13.809 97 22 44 0 1333179744 15427312 5192576
17:37:03 25400 8192000000 10255413760 10663911424 1302444192 13.717 97 40 80 0 1328443712 16771424 9228096
17:38:32 16071 8192000000 10249190096 10656817152 1310998144 13.795 98 51 102 1 1341633328 18913232 11721952
17:39:56 7365 8192000000 10231535200 10629238784 1311218960 13.797 100 71 140 0 1349159952 21002768 16938224
17:41:05 2703 8192000000 10236321328 10630447104 1308595216 13.773 100 63 123 1 1346884384 23951824 14337344
17:42:16 5960 8192000000 10251482672 10640896000 1303433440 13.726 99 72 143 0 1348739216 28753792 16551984
17:43:26 2480 8192000000 10275088464 10671452160 1333488720 13.999 100 70 138 0 1383102768 33293424 16320624
17:44:33 12286 8192000000 10269488304 10679914496 1320485280 13.881 98 50 99 0 1367828816 34408592 12934944
17:45:54 1886 8192000000 10329038480 10729013248 1374854912 14.371 100 87 173 0 1432458144 36510320 21092912
17:47:03 6057 8192000000 10325464080 10736521216 1380374432 14.420 100 71 140 0 1431898800 34394752 17129616
17:48:16 3443 8192000000 10337988240 10751365120 1391284256 14.517 100 65 127 0 1442742048 35257472 16200320
17:49:25 2769 8192000000 10354354768 10766077952 1399077040 14.587 100 72 144 0 1456384144 38414016 18893088
17:50:37 11128 8192000000 10337981056 10765422592 1397145456 14.570 100 44 86 0 1445090064 36147376 11797232
17:51:56 3175 8192000000 10361872480 10785357824 1415389072 14.732 100 55 108 1 1469971632 40735824 13846736
17:53:02 8934 8192000000 10351778336 10788704256 1412737408 14.708 100 34 67 0 1458524960 36729648 9057904
17:54:16 16203 8192000000 10357785120 10794303488 1414211904 14.721 100 37 72 0 1465556048 41196368 10147776
17:55:36 11930 8192000000 10358074272 10793267200 1407283632 14.660 100 28 56 1 1460372352 45237056 7851664
17:56:56 11995 8192000000 10355791936 10799607808 1405038704 14.640 100 24 48 0 1464543872 52788208 6716960
17:58:09 34652 8192000000 10317087360 10774740992 1389070944 14.498 99 23 46 1 1420642608 25581648 5990016
18:00:00 28516 8192000000 10316311824 10778419200 1404202432 14.632 100 17 34 0 1426851120 17836656 4812032
18:01:37 86448 8192000000 10308239344 10762874880 1404026688 14.631 100 32 64 0 1422845856 11571376 7247792
18:04:13 51635 8192000000 10318587792 10775453696 1413182128 14.712 100 19 38 0 1428174320 11045840 3946352
18:06:06 25441 8192000000 10312589248 10777481216 1414476864 14.724 100 23 46 0 1434851200 14985600 5388736
18:07:32 32462 8192000000 10330793888 10787024896 1419446288 14.768 100 28 53 0 1436788128 11044544 6297296
18:09:10 56935 8192000000 10321046160 10780286976 1409664208 14.681 99 28 52 0 1425884320 10258448 5961664
18:11:16 30356 8192000000 10325875696 10783789056 1414265168 14.722 99 19 38 1 1429497760 10771712 4460880
18:13:01 63125 8192000000 10327329552 10781339648 1393432048 14.536 98 26 50 0 1417511632 17656400 6423184
18:15:16 24536 8192000000 10305931248 10760052736 1394834896 14.549 99 26 52 0 1416610048 15669408 6105744
18:16:41 48400 8192000000 10303871952 10759131136 1365563888 14.287 97 9 18 0 1379627408 12462528 1600992
18:18:30 19505 8192000000 10289366048 10738626560 1347809472 14.128 96 57 113 5 1371306368 10912880 12584016
18:19:55 59536 8192000000 10294482912 10746851328 1366803200 14.298 98 20 40 1 1385569184 14127040 4638944
18:21:56 35751 8192000000 10293916464 10746970112 1365259568 14.285 98 43 86 0 1385503888 10217472 10026848
18:23:32 4700 8192000000 10293463776 10733584384 1378251680 14.401 100 48 95 0 1400414960 11319568 10843712
18:24:37 80454 8192000000 10251893456 10692476928 1233349808 13.085 89 19 38 0 1248560896 11000096 4210992
18:27:04 30266 8192000000 10248128480 10693742592 1325552816 13.927 98 34 69 0 1345743904 12678304 7512784
18:28:37 53760 8192000000 10278606160 10729590784 1360306608 14.240 100 28 56 0 1387399984 20911776 6181600
18:30:36 101092 8192000000 10247875136 10691518464 1296613360 13.664 96 31 62 0 1310984368 7069536 7301472
18:33:19 32395 8192000000 10231233824 10677202944 1328609792 13.955 100 23 46 0 1345330432 11438208 5282432
18:34:54 55023 8192000000 10249263392 10702880768 1340631680 14.063 99 16 33 0 1358849264 14474464 3743120
18:36:50 32269 8192000000 10256179776 10709114880 1353446464 14.178 100 16 32 0 1368480000 11186768 3846768
18:38:29 78511 8192000000 10250002448 10705489920 1326307056 13.934 97 19 38 0 1339459552 8491024 4661472
18:40:48 64738 8192000000 10255777296 10714374144 1313426240 13.817 96 11 22 0 1324066080 8329136 2310704
18:44:07 38431 8192000000 10286458304 10734059520 1375434160 14.376 100 26 51 0 1392422768 10870624 6117984
18:45:51 37963 8192000000 10295720640 10753175552 1393707184 14.539 100 10 20 0 1407374080 11168080 2498816
18:47:34 24166 8192000000 10302510272 10744680448 1387410704 14.483 100 42 85 0 1407016128 9964688 9640736
18:49:01 60579 8192000000 10314495664 10766999552 1394562384 14.547 100 20 40 0 1410611312 11795408 4253520
18:51:05 42426 8192000000 10310914672 10762973184 1400385312 14.598 100 29 58 0 1418581920 11742272 6454336
18:52:52 43485 8192000000 10317985792 10775580672 1408511056 14.671 100 31 62 1 1427260432 11292992 7456384
18:54:39 113149 8192000000 10321114656 10780520448 1388209008 14.490 98 14 28 0 1403373888 12596208 2568672
18:57:32 49997 8192000000 10319955712 10782117888 1417805840 14.753 100 33 66 0 1435166672 9754048 7606784
18:59:26 63304 8192000000 10314263920 10784616448 1421688256 14.788 100 14 26 1 1435204880 10976192 2540432
19:01:31 41371 8192000000 10303339536 10774306816 1386873712 14.478 98 7 14 0 1395571040 7298624 1398704
19:03:13 72058 8192000000 10279944288 10740797440 1361344240 14.249 96 15 30 0 1373785904 9045472 3396192
19:05:26 47573 8192000000 10288397792 10756968448 1341559120 14.071 96 17 32 0 1361630688 16369488 3702080
19:07:14 49480 8192000000 10275601344 10727129088 1347781392 14.128 98 15 30 0 1360037568 8933312 3322864
19:09:17 28972 8192000000 9088487184 9301811200 246643952 2.922 19 2 4 0 249126160 2397136 85072

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:14, from 17-02-2024 19:10:55 to 17-02-2024 19:11:09.

Exceptions occured during test was in run

FB_MNEMONA CNT UNIT FB_GDSCODE
except 90 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 17-02-2024 19:11:10 to 17-02-2024 19:11:12.

Content of mon$database and FB version 


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


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

Database statistics 

 
Database "/home/bases/oltp30-etalone.fdb" 
Gstat execution time Sat Feb 17 19:11:13 2024 
 
Database header page information: 
    Flags            0 
    Generation        90375 
    System Change Number    0 
    Page size        8192 
    ODS version        12.0 
    Oldest transaction    173664 
    Oldest active        173665 
    Oldest snapshot        173665 
    Next transaction    173666 
    Sequence number        0 
    Next attachment ID    707 
    Implementation        HW=AMD/Intel/x64 little-endian OS=Linux CC=gcc 
    Shadow count        0 
    Page buffers        0 
    Next header page    0 
    Database dialect    3 
    Creation date        Apr 3, 2020 16:41:55 
    Attributes        force write 
 
    Variable header data: 
    Sweep interval:        0 
    Unrecognized option 11, length 16 
    *END* 
 
 
Database file sequence: 
File /home/bases/oltp30-etalone.fdb is the only file 
 
Analyzing database pages ... 
AGENTS (150) 
    Primary pointer page: 496, Index root page: 497 
    Total formats: 1, used formats: 1 
    Average record length: 33.60, total records: 50 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 344.00, compression ratio: 10.24 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 31% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 1 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index AGENTS_ID_DESC (2) 
    Root page: 1504311, depth: 1, leaf buckets: 1, nodes: 50 
    Average node length: 11.82, total dup: 0, max dup: 0 
    Average key length: 10.80, compression ratio: 0.83 
    Average prefix length: 1.18, average data length: 7.82 
    Clustering factor: 1, ratio: 0.02 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index AGENTS_IS_OUR_FIRM (4) 
    Root page: 1504313, depth: 1, leaf buckets: 1, nodes: 50 
    Average node length: 3.08, total dup: 48, max dup: 48 
    Average key length: 2.04, compression ratio: 0.50 
    Average prefix length: 0.96, average data length: 0.06 
    Clustering factor: 1, ratio: 0.02 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index AGENTS_IS_SUPPLIER (3) 
    Root page: 1504312, depth: 1, leaf buckets: 1, nodes: 50 
    Average node length: 3.08, total dup: 48, max dup: 44 
    Average key length: 2.04, compression ratio: 0.54 
    Average prefix length: 1.04, average data length: 0.06 
    Clustering factor: 1, ratio: 0.02 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index AGENTS_NAME_UNQ (1) 
    Root page: 1504310, depth: 1, leaf buckets: 1, nodes: 50 
    Average node length: 17.20, total dup: 0, max dup: 0 
    Average key length: 15.88, compression ratio: 0.92 
    Average prefix length: 1.42, average data length: 13.20 
    Clustering factor: 1, ratio: 0.02 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PK_AGENTS (0) 
    Root page: 1504309, depth: 1, leaf buckets: 1, nodes: 50 
    Average node length: 11.82, total dup: 0, max dup: 0 
    Average key length: 10.80, compression ratio: 0.83 
    Average prefix length: 1.18, average data length: 7.82 
    Clustering factor: 1, ratio: 0.02 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
BUSINESS_OPS (154) 
    Primary pointer page: 504, Index root page: 505 
    Total formats: 1, used formats: 1 
    Average record length: 108.20, total records: 20 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1235.00, compression ratio: 11.41 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 31% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 1 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index BO_UNIT_UNQ (1) 
    Root page: 1504242, depth: 1, leaf buckets: 1, nodes: 20 
    Average node length: 18.25, total dup: 0, max dup: 0 
    Average key length: 17.20, compression ratio: 1.24 
    Average prefix length: 7.05, average data length: 14.25 
    Clustering factor: 1, ratio: 0.05 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index BUSINESS_OPS_PREDICT_PRIOR (3) 
    Root page: 1504244, depth: 1, leaf buckets: 1, nodes: 20 
    Average node length: 5.40, total dup: 0, max dup: 0 
    Average key length: 4.35, compression ratio: 0.67 
    Average prefix length: 1.20, average data length: 1.70 
    Clustering factor: 1, ratio: 0.05 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index BUSINESS_OPS_RND_WGTH (2) 
    Root page: 1504243, depth: 1, leaf buckets: 1, nodes: 20 
    Average node length: 4.30, total dup: 6, max dup: 3 
    Average key length: 3.25, compression ratio: 0.72 
    Average prefix length: 1.35, average data length: 1.00 
    Clustering factor: 1, ratio: 0.05 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index RDB$1 (0) 
    Root page: 1504241, depth: 1, leaf buckets: 1, nodes: 20 
    Average node length: 5.20, total dup: 0, max dup: 0 
    Average key length: 4.15, compression ratio: 0.65 
    Average prefix length: 1.10, average data length: 1.60 
    Clustering factor: 1, ratio: 0.05 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
DOC_DATA (139) 
    Primary pointer page: 474, Index root page: 475 
    Total formats: 1, used formats: 1 
    Average record length: 47.35, total records: 7742776 
    Average version length: 48.16, total versions: 87989, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 64.00, compression ratio: 1.35 
    Pointer pages: 54, data page slots: 86776 
    Data pages: 86776, average fill: 71% 
    Primary pages: 86776, secondary pages: 0, swept pages: 18626 
    Empty pages: 1, full pages: 66637 
    Fill distribution: 
     0 - 19% = 32 
    20 - 39% = 286 
    40 - 59% = 3344 
    60 - 79% = 83095 
    80 - 99% = 19 
 
    Index DOC_DATA_DOC_WARE_UNQ (0) 
    Root page: 1510614, depth: 3, leaf buckets: 23180, nodes: 7742776 
    Average node length: 18.88, total dup: 0, max dup: 0 
    Average key length: 15.89, compression ratio: 1.70 
    Average prefix length: 14.10, average data length: 12.90 
    Clustering factor: 1715548, ratio: 0.22 
    Fill distribution: 
         0 - 19% = 318 
        20 - 39% = 1686 
        40 - 59% = 4211 
        60 - 79% = 2381 
        80 - 99% = 14584 
 
    Index DOC_DATA_ID_DESC (1) 
    Root page: 1528118, depth: 3, leaf buckets: 13483, nodes: 7742776 
    Average node length: 11.20, total dup: 0, max dup: 0 
    Average key length: 8.21, compression ratio: 1.10 
    Average prefix length: 3.79, average data length: 5.21 
    Clustering factor: 1538752, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 1500 
        40 - 59% = 2106 
        60 - 79% = 1083 
        80 - 99% = 8794 
 
    Index FK_DOC_DATA_DOC_LIST (2) 
    Root page: 1546711, depth: 3, leaf buckets: 8327, nodes: 7742776 
    Average node length: 6.61, total dup: 5794809, max dup: 49 
    Average key length: 3.63, compression ratio: 2.48 
    Average prefix length: 7.63, average data length: 1.37 
    Clustering factor: 1531757, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 141 
        20 - 39% = 883 
        40 - 59% = 1475 
        60 - 79% = 900 
        80 - 99% = 4928 
 
DOC_LIST (138) 
    Primary pointer page: 472, Index root page: 473 
    Total formats: 1, used formats: 1 
    Average record length: 56.29, total records: 2238738 
    Average version length: 34.73, total versions: 89230, max versions: 3 
    Average fragment length: 4.00, total fragments: 2, max fragments: 1 
    Average unpacked length: 84.00, compression ratio: 1.49 
    Pointer pages: 18, data page slots: 28448 
    Data pages: 28448, average fill: 73% 
    Primary pages: 28443, secondary pages: 5, swept pages: 10131 
    Empty pages: 8, full pages: 21662 
    Fill distribution: 
     0 - 19% = 27 
    20 - 39% = 199 
    40 - 59% = 2390 
    60 - 79% = 24979 
    80 - 99% = 853 
 
    Index DOC_LIST_ID_DESC (1) 
    Root page: 1541130, depth: 3, leaf buckets: 4534, nodes: 2238738 
    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: 693645, ratio: 0.31 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 865 
        40 - 59% = 894 
        60 - 79% = 701 
        80 - 99% = 2074 
 
    Index DOC_LIST_WORKER_OPTYPE (2) 
    Root page: 1544376, depth: 3, leaf buckets: 2509, nodes: 2241444 
    Average node length: 4.97, total dup: 2240545, max dup: 18173 
    Average key length: 2.01, compression ratio: 4.47 
    Average prefix length: 8.99, average data length: 0.01 
    Clustering factor: 1243444, ratio: 0.55 
    Fill distribution: 
         0 - 19% = 4 
        20 - 39% = 264 
        40 - 59% = 1539 
        60 - 79% = 521 
        80 - 99% = 181 
 
    Index FK_DOC_LIST_AGENTS (3) 
    Root page: 1545909, depth: 3, leaf buckets: 2014, nodes: 2238738 
    Average node length: 4.97, total dup: 2238688, max dup: 130396 
    Average key length: 2.01, compression ratio: 4.48 
    Average prefix length: 8.99, average data length: 0.01 
    Clustering factor: 1057517, ratio: 0.47 
    Fill distribution: 
         0 - 19% = 4 
        20 - 39% = 114 
        40 - 59% = 990 
        60 - 79% = 56 
        80 - 99% = 850 
 
    Index PK_DOC_LIST (0) 
    Root page: 1538187, depth: 3, leaf buckets: 4338, nodes: 2238738 
    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: 693645, ratio: 0.31 
    Fill distribution: 
         0 - 19% = 107 
        20 - 39% = 549 
        40 - 59% = 664 
        60 - 79% = 792 
        80 - 99% = 2226 
 
DOC_STATES (149) 
    Primary pointer page: 494, Index root page: 495 
    Total formats: 1, used formats: 1 
    Average record length: 67.50, total records: 4 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 650.00, compression ratio: 9.63 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 4% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index DOC_STATES_MCODE_UNQ (1) 
    Root page: 1504315, depth: 1, leaf buckets: 1, nodes: 4 
    Average node length: 17.75, total dup: 0, max dup: 0 
    Average key length: 16.50, compression ratio: 1.08 
    Average prefix length: 4.00, average data length: 13.75 
    Clustering factor: 1, ratio: 0.25 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index DOC_STATES_NAME_UNQ (2) 
    Root page: 1504316, depth: 1, leaf buckets: 1, nodes: 4 
    Average node length: 33.25, total dup: 0, max dup: 0 
    Average key length: 32.00, compression ratio: 0.99 
    Average prefix length: 2.50, average data length: 29.25 
    Clustering factor: 1, ratio: 0.25 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PK_DOC_STATES (0) 
    Root page: 1504314, depth: 1, leaf buckets: 1, nodes: 4 
    Average node length: 4.75, total dup: 0, max dup: 0 
    Average key length: 3.50, compression ratio: 0.86 
    Average prefix length: 1.50, average data length: 1.50 
    Clustering factor: 1, ratio: 0.25 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
FB_ERRORS (155) 
    Primary pointer page: 506, Index root page: 507 
    Total formats: 2, used formats: 2 
    Average record length: 54.76, total records: 2182 
    Average version length: 79.61, total versions: 757, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 270.43, compression ratio: 4.94 
    Pointer pages: 1, data page slots: 40 
    Data pages: 40, average fill: 70% 
    Primary pages: 40, secondary pages: 0, swept pages: 0 
    Empty pages: 7, full pages: 32 
    Fill distribution: 
     0 - 19% = 7 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 7 
    80 - 99% = 26 
 
    Index FB_ERRORS_GDS_CODE (0) 
    Root page: 382, depth: 2, leaf buckets: 2, nodes: 2182 
    Average node length: 4.40, total dup: 756, max dup: 1 
    Average key length: 2.67, compression ratio: 1.87 
    Average prefix length: 4.33, average data length: 0.67 
    Clustering factor: 1515, ratio: 0.69 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 0 
        40 - 59% = 1 
        60 - 79% = 1 
        80 - 99% = 0 
 
INVNT_SALDO (145) 
    Primary pointer page: 486, Index root page: 487 
    Total formats: 2, used formats: 1 
    Average record length: 82.17, total records: 400 
    Average version length: 22.98, total versions: 238917, max versions: 623 
    Average fragment length: 2.06, total fragments: 63, max fragments: 1 
    Average unpacked length: 104.00, compression ratio: 1.27 
    Pointer pages: 1, data page slots: 1328 
    Data pages: 1328, average fill: 90% 
    Primary pages: 7, secondary pages: 1321, swept pages: 0 
    Empty pages: 0, full pages: 1327 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 1328 
 
    Index PK_INVNT_SALDO (0) 
    Root page: 1510349, depth: 1, leaf buckets: 1, nodes: 400 
    Average node length: 11.22, total dup: 0, max dup: 0 
    Average key length: 10.22, compression ratio: 0.88 
    Average prefix length: 1.78, average data length: 7.22 
    Clustering factor: 326, ratio: 0.81 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 0 
        40 - 59% = 1 
        60 - 79% = 0 
        80 - 99% = 0 
 
INVNT_TURNOVER_LOG (153) 
    Primary pointer page: 502, Index root page: 503 
    Total formats: 1, used formats: 1 
    Average record length: 3.59, total records: 72471 
    Average version length: 68.28, total versions: 68659, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 88.00, compression ratio: 24.49 
    Pointer pages: 7, data page slots: 2192 
    Data pages: 1304, average fill: 70% 
    Primary pages: 1303, secondary pages: 1, swept pages: 0 
    Empty pages: 93, full pages: 784 
    Fill distribution: 
     0 - 19% = 140 
    20 - 39% = 110 
    40 - 59% = 166 
    60 - 79% = 138 
    80 - 99% = 750 
 
    Index INVNT_TURNOVER_LOG_WARE_DD_ID (0) 
    Root page: 1705989, depth: 3, leaf buckets: 309, nodes: 72471 
    Average node length: 13.22, total dup: 3864, max dup: 2 
    Average key length: 10.83, compression ratio: 2.49 
    Average prefix length: 19.12, average data length: 7.88 
    Clustering factor: 53030, ratio: 0.73 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 199 
        40 - 59% = 95 
        60 - 79% = 15 
        80 - 99% = 0 
 
MONEY_SALDO (141) 
    Primary pointer page: 478, Index root page: 479 
    Total formats: 1, used formats: 1 
    Average record length: 15.27, total records: 49 
    Average version length: 9.00, total versions: 17836, max versions: 962 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 32.00, compression ratio: 2.10 
    Pointer pages: 1, data page slots: 64 
    Data pages: 64, average fill: 89% 
    Primary pages: 2, secondary pages: 62, swept pages: 0 
    Empty pages: 1, full pages: 62 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 0 
    40 - 59% = 1 
    60 - 79% = 3 
    80 - 99% = 59 
 
    Index PK_MONEY_SALDO (0) 
    Root page: 1510361, depth: 1, leaf buckets: 1, nodes: 49 
    Average node length: 11.82, total dup: 0, max dup: 0 
    Average key length: 10.80, compression ratio: 0.83 
    Average prefix length: 1.18, average data length: 7.82 
    Clustering factor: 1, ratio: 0.02 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
MONEY_TURNOVER_LOG (140) 
    Primary pointer page: 476, Index root page: 477 
    Total formats: 1, used formats: 1 
    Average record length: 2.57, total records: 1827 
    Average version length: 43.34, total versions: 1721, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 58.00, compression ratio: 22.56 
    Pointer pages: 1, data page slots: 40 
    Data pages: 30, average fill: 60% 
    Primary pages: 29, secondary pages: 1, swept pages: 0 
    Empty pages: 1, full pages: 16 
    Fill distribution: 
     0 - 19% = 7 
    20 - 39% = 3 
    40 - 59% = 4 
    60 - 79% = 0 
    80 - 99% = 16 
 
    Index MONEY_TURNOVER_LOG_AGENT_OPTYPE (0) 
    Root page: 91246, depth: 2, leaf buckets: 3, nodes: 1827 
    Average node length: 4.21, total dup: 1729, max dup: 175 
    Average key length: 2.58, compression ratio: 7.37 
    Average prefix length: 18.48, average data length: 0.52 
    Clustering factor: 937, ratio: 0.51 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 3 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
MON_CACHE_MEMORY (165) 
    Primary pointer page: 526, Index root page: 527 
    Total formats: 2, used formats: 1 
    Average record length: 97.12, total records: 75 
    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: 52% 
    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% = 0 
    80 - 99% = 1 
 
    Index PK_MON_CACHE_MEMORY (0) 
    Root page: 1504215, depth: 1, leaf buckets: 1, nodes: 75 
    Average node length: 11.68, total dup: 0, max dup: 0 
    Average key length: 10.67, compression ratio: 0.84 
    Average prefix length: 1.32, average data length: 7.68 
    Clustering factor: 2, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
MON_LOG (162) 
    Primary pointer page: 520, Index root page: 521 
    Total formats: 2, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index MON_LOG_DTS (4) 
    Root page: 1504229, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index MON_LOG_GDSCODE (2) 
    Root page: 1504227, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index MON_LOG_ROWSET_DESC (1) 
    Root page: 1504226, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index MON_LOG_UNIT (3) 
    Root page: 1504228, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PK_MON_LOG (0) 
    Root page: 1504225, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
MON_LOG_TABLE_STATS (163) 
    Primary pointer page: 522, Index root page: 523 
    Total formats: 2, used formats: 1 
    Average record length: 67.13, total records: 30 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 611.00, compression ratio: 9.10 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 31% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 1 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index MON_LOG_TABLE_STATS_DTS (4) 
    Root page: 1504224, depth: 1, leaf buckets: 1, nodes: 30 
    Average node length: 3.50, total dup: 23, max dup: 4 
    Average key length: 2.47, compression ratio: 3.24 
    Average prefix length: 7.53, average data length: 0.47 
    Clustering factor: 1, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index MON_LOG_TABLE_STATS_GDSCODE (2) 
    Root page: 1504222, depth: 1, leaf buckets: 1, nodes: 30 
    Average node length: 2.00, total dup: 29, max dup: 29 
    Average key length: 1.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 1, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index MON_LOG_TABLE_STATS_ROWSET (1) 
    Root page: 1504221, depth: 1, leaf buckets: 1, nodes: 30 
    Average node length: 3.33, total dup: 29, max dup: 29 
    Average key length: 2.30, compression ratio: 3.91 
    Average prefix length: 8.70, average data length: 0.30 
    Clustering factor: 1, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index MON_LOG_TABLE_STATS_TN_UNIT (3) 
    Root page: 1504223, depth: 1, leaf buckets: 1, nodes: 30 
    Average node length: 12.90, total dup: 0, max dup: 0 
    Average key length: 11.87, compression ratio: 1.42 
    Average prefix length: 7.63, average data length: 9.20 
    Clustering factor: 1, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PK_MON_LOG_TABLE_STATS (0) 
    Root page: 1504220, depth: 1, leaf buckets: 1, nodes: 30 
    Average node length: 8.37, total dup: 0, max dup: 0 
    Average key length: 7.33, compression ratio: 1.23 
    Average prefix length: 4.63, average data length: 4.37 
    Clustering factor: 1, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
OPTYPES (136) 
    Primary pointer page: 468, Index root page: 469 
    Total formats: 2, used formats: 1 
    Average record length: 67.56, total records: 9 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 386.00, compression ratio: 5.71 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 9% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index OPTYPES_MCODE_UNQ (1) 
    Root page: 1544805, depth: 1, leaf buckets: 1, nodes: 9 
    Average node length: 8.56, total dup: 0, max dup: 0 
    Average key length: 6.89, compression ratio: 0.73 
    Average prefix length: 0.44, average data length: 4.56 
    Clustering factor: 1, ratio: 0.11 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PK_OPTYPES (0) 
    Root page: 1544804, depth: 1, leaf buckets: 1, nodes: 9 
    Average node length: 6.11, total dup: 0, max dup: 0 
    Average key length: 5.00, compression ratio: 0.60 
    Average prefix length: 0.89, average data length: 2.11 
    Clustering factor: 1, ratio: 0.11 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
PDISTR (146) 
    Primary pointer page: 488, Index root page: 489 
    Total formats: 1, used formats: 1 
    Average record length: 35.83, total records: 816978 
    Average version length: 25.41, total versions: 80182, max versions: 4 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 54.00, compression ratio: 1.51 
    Pointer pages: 6, data page slots: 8272 
    Data pages: 8264, average fill: 69% 
    Primary pages: 8234, secondary pages: 30, swept pages: 1377 
    Empty pages: 113, full pages: 7386 
    Fill distribution: 
     0 - 19% = 220 
    20 - 39% = 145 
    40 - 59% = 173 
    60 - 79% = 7374 
    80 - 99% = 352 
 
    Index PDISTR_AGENT_ID (2) 
    Root page: 1509308, depth: 2, leaf buckets: 897, nodes: 816978 
    Average node length: 4.87, total dup: 816929, max dup: 151654 
    Average key length: 2.01, compression ratio: 4.48 
    Average prefix length: 8.99, average data length: 0.01 
    Clustering factor: 90592, ratio: 0.11 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 128 
        40 - 59% = 488 
        60 - 79% = 217 
        80 - 99% = 64 
 
    Index PDISTR_SNDOP_RCVOP_SNDID_ASC (0) 
    Root page: 1508613, depth: 3, leaf buckets: 941, nodes: 816978 
    Average node length: 5.87, total dup: 727773, max dup: 42 
    Average key length: 3.01, compression ratio: 7.30 
    Average prefix length: 21.10, average data length: 0.90 
    Clustering factor: 162039, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 98 
        40 - 59% = 421 
        60 - 79% = 100 
        80 - 99% = 320 
 
    Index PDISTR_SNDOP_RCVOP_SNDID_DESC (1) 
    Root page: 1509187, depth: 3, leaf buckets: 996, nodes: 816978 
    Average node length: 5.88, total dup: 727773, max dup: 42 
    Average key length: 3.01, compression ratio: 7.30 
    Average prefix length: 21.09, average data length: 0.91 
    Clustering factor: 164155, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 199 
        40 - 59% = 404 
        60 - 79% = 87 
        80 - 99% = 306 
 
    Index PDISTR_WORKER_SND_ID (3) 
    Root page: 1510178, depth: 3, leaf buckets: 1167, nodes: 816978 
    Average node length: 5.96, total dup: 727773, max dup: 42 
    Average key length: 3.09, compression ratio: 5.49 
    Average prefix length: 16.01, average data length: 0.99 
    Clustering factor: 157067, ratio: 0.19 
    Fill distribution: 
         0 - 19% = 7 
        20 - 39% = 269 
        40 - 59% = 600 
        60 - 79% = 197 
        80 - 99% = 94 
 
PERF_AGG (158) 
    Primary pointer page: 512, Index root page: 513 
    Total formats: 1, used formats: 1 
    Average record length: 62.78, total records: 5426 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 2.89, total fragments: 70, max fragments: 1 
    Average unpacked length: 379.00, compression ratio: 6.04 
    Pointer pages: 1, data page slots: 96 
    Data pages: 96, average fill: 56% 
    Primary pages: 78, secondary pages: 18, swept pages: 51 
    Empty pages: 14, full pages: 65 
    Fill distribution: 
     0 - 19% = 26 
    20 - 39% = 0 
    40 - 59% = 1 
    60 - 79% = 68 
    80 - 99% = 1 
 
    Index PERF_AGG_UNQ (1) 
    Root page: 1504238, depth: 2, leaf buckets: 6, nodes: 5426 
    Average node length: 5.47, total dup: 0, max dup: 0 
    Average key length: 3.59, compression ratio: 10.01 
    Average prefix length: 34.36, average data length: 1.55 
    Clustering factor: 5209, ratio: 0.96 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 0 
        40 - 59% = 4 
        60 - 79% = 1 
        80 - 99% = 1 
 
    Index PK_PERF_AGG (0) 
    Root page: 1504233, depth: 2, leaf buckets: 10, nodes: 5426 
    Average node length: 11.09, 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: 152, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 1 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 7 
 
PERF_ESTIMATED (280) 
    Primary pointer page: 1504218, Index root page: 1504219 
    Total formats: 1, used formats: 1 
    Average record length: 39.15, total records: 79503 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 48.00, compression ratio: 1.23 
    Pointer pages: 1, data page slots: 768 
    Data pages: 768, average fill: 71% 
    Primary pages: 768, secondary pages: 0, swept pages: 0 
    Empty pages: 1, full pages: 766 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 0 
    40 - 59% = 1 
    60 - 79% = 766 
    80 - 99% = 0 
 
    Index PK_PERF_ESTIMATED (0) 
    Root page: 35681, depth: 2, leaf buckets: 103, nodes: 79503 
    Average node length: 10.17, total dup: 0, max dup: 0 
    Average key length: 8.18, compression ratio: 1.10 
    Average prefix length: 3.81, average data length: 5.19 
    Clustering factor: 3016, ratio: 0.04 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 1 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 100 
 
PERF_ISQL_STAT (156) 
    Primary pointer page: 508, Index root page: 509 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index PERF_ISQL_STAT_TRN (0) 
    Root page: 1504239, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
PERF_LOG (159) 
    Primary pointer page: 514, Index root page: 515 
    Total formats: 1, used formats: 1 
    Average record length: 111.12, total records: 72 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1691.00, compression ratio: 15.22 
    Pointer pages: 1, data page slots: 2 
    Data pages: 2, average fill: 57% 
    Primary pages: 2, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 1 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 1 
    40 - 59% = 0 
    60 - 79% = 1 
    80 - 99% = 0 
 
PERF_SPLIT_0 (281) 
    Primary pointer page: 573, Index root page: 574 
    Total formats: 1, used formats: 1 
    Average record length: 147.73, total records: 171060 
    Average version length: 151.30, total versions: 3451, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.48 
    Pointer pages: 7, data page slots: 4584 
    Data pages: 4104, average fill: 86% 
    Primary pages: 4103, secondary pages: 1, swept pages: 1 
    Empty pages: 47, full pages: 4038 
    Fill distribution: 
     0 - 19% = 48 
    20 - 39% = 9 
    40 - 59% = 4 
    60 - 79% = 4 
    80 - 99% = 4039 
 
PERF_SPLIT_1 (282) 
    Primary pointer page: 576, Index root page: 577 
    Total formats: 1, used formats: 1 
    Average record length: 147.56, total records: 170918 
    Average version length: 152.44, total versions: 3732, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.49 
    Pointer pages: 7, data page slots: 4616 
    Data pages: 4136, average fill: 85% 
    Primary pages: 4136, secondary pages: 0, swept pages: 4 
    Empty pages: 79, full pages: 4037 
    Fill distribution: 
     0 - 19% = 81 
    20 - 39% = 6 
    40 - 59% = 6 
    60 - 79% = 7 
    80 - 99% = 4036 
 
PERF_SPLIT_2 (283) 
    Primary pointer page: 578, Index root page: 579 
    Total formats: 1, used formats: 1 
    Average record length: 147.51, total records: 159400 
    Average version length: 151.40, total versions: 3255, 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: 4144 
    Data pages: 3848, average fill: 85% 
    Primary pages: 3848, secondary pages: 0, swept pages: 2 
    Empty pages: 70, full pages: 3761 
    Fill distribution: 
     0 - 19% = 73 
    20 - 39% = 6 
    40 - 59% = 3 
    60 - 79% = 6 
    80 - 99% = 3760 
 
PERF_SPLIT_3 (284) 
    Primary pointer page: 580, Index root page: 581 
    Total formats: 1, used formats: 1 
    Average record length: 148.67, total records: 190385 
    Average version length: 150.69, total versions: 3013, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.41 
    Pointer pages: 6, data page slots: 5192 
    Data pages: 4600, average fill: 85% 
    Primary pages: 4600, secondary pages: 0, swept pages: 1 
    Empty pages: 78, full pages: 4501 
    Fill distribution: 
     0 - 19% = 81 
    20 - 39% = 8 
    40 - 59% = 5 
    60 - 79% = 5 
    80 - 99% = 4501 
 
PERF_SPLIT_4 (285) 
    Primary pointer page: 582, Index root page: 583 
    Total formats: 1, used formats: 1 
    Average record length: 131.56, total records: 178866 
    Average version length: 154.71, total versions: 22931, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 12.89 
    Pointer pages: 7, data page slots: 5864 
    Data pages: 4384, average fill: 85% 
    Primary pages: 4384, secondary pages: 0, swept pages: 2 
    Empty pages: 118, full pages: 4234 
    Fill distribution: 
     0 - 19% = 119 
    20 - 39% = 13 
    40 - 59% = 12 
    60 - 79% = 7 
    80 - 99% = 4233 
 
PERF_SPLIT_5 (286) 
    Primary pointer page: 584, Index root page: 585 
    Total formats: 1, used formats: 1 
    Average record length: 148.84, total records: 182011 
    Average version length: 151.61, total versions: 2860, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.39 
    Pointer pages: 8, data page slots: 6072 
    Data pages: 4416, average fill: 85% 
    Primary pages: 4416, secondary pages: 0, swept pages: 5 
    Empty pages: 81, full pages: 4303 
    Fill distribution: 
     0 - 19% = 86 
    20 - 39% = 11 
    40 - 59% = 11 
    60 - 79% = 4 
    80 - 99% = 4304 
 
PERF_SPLIT_6 (287) 
    Primary pointer page: 586, Index root page: 587 
    Total formats: 1, used formats: 1 
    Average record length: 148.81, total records: 174589 
    Average version length: 150.26, total versions: 2204, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.40 
    Pointer pages: 7, data page slots: 4824 
    Data pages: 4192, average fill: 86% 
    Primary pages: 4191, secondary pages: 1, swept pages: 8 
    Empty pages: 51, full pages: 4121 
    Fill distribution: 
     0 - 19% = 56 
    20 - 39% = 8 
    40 - 59% = 2 
    60 - 79% = 6 
    80 - 99% = 4120 
 
PERF_SPLIT_7 (288) 
    Primary pointer page: 588, Index root page: 589 
    Total formats: 1, used formats: 1 
    Average record length: 127.43, total records: 189129 
    Average version length: 154.83, total versions: 29382, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 13.31 
    Pointer pages: 7, data page slots: 6072 
    Data pages: 4616, average fill: 86% 
    Primary pages: 4616, secondary pages: 0, swept pages: 1 
    Empty pages: 105, full pages: 4475 
    Fill distribution: 
     0 - 19% = 105 
    20 - 39% = 12 
    40 - 59% = 14 
    60 - 79% = 10 
    80 - 99% = 4475 
 
PERF_SPLIT_8 (289) 
    Primary pointer page: 590, Index root page: 591 
    Total formats: 1, used formats: 1 
    Average record length: 147.40, total records: 188312 
    Average version length: 152.40, total versions: 4659, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.51 
    Pointer pages: 7, data page slots: 4976 
    Data pages: 4536, average fill: 86% 
    Primary pages: 4536, secondary pages: 0, swept pages: 8 
    Empty pages: 62, full pages: 4454 
    Fill distribution: 
     0 - 19% = 65 
    20 - 39% = 6 
    40 - 59% = 2 
    60 - 79% = 9 
    80 - 99% = 4454 
 
PERF_SPLIT_9 (290) 
    Primary pointer page: 593, Index root page: 594 
    Total formats: 1, used formats: 1 
    Average record length: 147.89, total records: 175148 
    Average version length: 152.81, total versions: 3617, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.47 
    Pointer pages: 9, data page slots: 5424 
    Data pages: 4248, average fill: 85% 
    Primary pages: 4248, secondary pages: 0, swept pages: 2 
    Empty pages: 83, full pages: 4138 
    Fill distribution: 
     0 - 19% = 88 
    20 - 39% = 7 
    40 - 59% = 7 
    60 - 79% = 8 
    80 - 99% = 4138 
 
PHRASES (143) 
    Primary pointer page: 482, Index root page: 483 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index PHRASES_ID_DESC (3) 
    Root page: 1510354, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PHRASES_NAME (2) 
    Root page: 1510353, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PHRASES_UNQ (1) 
    Root page: 1510352, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PK_PHRASES (0) 
    Root page: 1510351, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
PSTORNED (147) 
    Primary pointer page: 490, Index root page: 491 
    Total formats: 1, used formats: 1 
    Average record length: 51.57, total records: 2109784 
    Average version length: 52.92, total versions: 46910, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 70.00, compression ratio: 1.36 
    Pointer pages: 16, data page slots: 25688 
    Data pages: 25688, average fill: 71% 
    Primary pages: 25688, secondary pages: 0, swept pages: 10394 
    Empty pages: 339, full pages: 20917 
    Fill distribution: 
     0 - 19% = 627 
    20 - 39% = 459 
    40 - 59% = 1116 
    60 - 79% = 23086 
    80 - 99% = 400 
 
    Index PSTORNED_RCV_ID (1) 
    Root page: 1506186, depth: 3, leaf buckets: 2561, nodes: 2109784 
    Average node length: 5.44, total dup: 1968892, max dup: 1468 
    Average key length: 2.49, compression ratio: 3.62 
    Average prefix length: 8.58, average data length: 0.42 
    Clustering factor: 181541, ratio: 0.09 
    Fill distribution: 
         0 - 19% = 3 
        20 - 39% = 285 
        40 - 59% = 1652 
        60 - 79% = 302 
        80 - 99% = 319 
 
    Index PSTORNED_SND_ID (0) 
    Root page: 1504819, depth: 3, leaf buckets: 2751, nodes: 2109784 
    Average node length: 5.69, total dup: 1893850, max dup: 64 
    Average key length: 2.74, compression ratio: 3.29 
    Average prefix length: 8.36, average data length: 0.64 
    Clustering factor: 376564, ratio: 0.18 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 6 
        40 - 59% = 2408 
        60 - 79% = 312 
        80 - 99% = 25 
 
    Index PSTORNED_WORKER_ID (2) 
    Root page: 1507996, depth: 3, leaf buckets: 2125, nodes: 2109784 
    Average node length: 4.96, total dup: 2109684, max dup: 28089 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.41, average data length: 0.00 
    Clustering factor: 179388, ratio: 0.09 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 171 
        40 - 59% = 1150 
        60 - 79% = 375 
        80 - 99% = 428 
 
RULES_FOR_PDISTR (148) 
    Primary pointer page: 492, Index root page: 493 
    Total formats: 1, used formats: 1 
    Average record length: 17.00, total records: 4 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 334.00, compression ratio: 19.65 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 2% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index RULES_FOR_PDISTR_UNQ (0) 
    Root page: 1504317, depth: 1, leaf buckets: 1, nodes: 4 
    Average node length: 11.50, total dup: 0, max dup: 0 
    Average key length: 10.25, compression ratio: 0.88 
    Average prefix length: 1.50, average data length: 7.50 
    Clustering factor: 1, ratio: 0.25 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
RULES_FOR_QDISTR (137) 
    Primary pointer page: 470, Index root page: 471 
    Total formats: 1, used formats: 1 
    Average record length: 32.71, total records: 7 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 332.00, compression ratio: 10.15 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 4% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index RULES_FOR_QDISTR_RCVOP (1) 
    Root page: 1544803, depth: 1, leaf buckets: 1, nodes: 7 
    Average node length: 5.29, total dup: 2, max dup: 2 
    Average key length: 4.14, compression ratio: 0.72 
    Average prefix length: 1.43, average data length: 1.57 
    Clustering factor: 1, ratio: 0.14 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index RULES_FOR_QDISTR_UNQ (0) 
    Root page: 1544802, depth: 1, leaf buckets: 1, nodes: 7 
    Average node length: 10.14, total dup: 0, max dup: 0 
    Average key length: 8.86, compression ratio: 0.94 
    Average prefix length: 2.14, average data length: 6.14 
    Clustering factor: 1, ratio: 0.14 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
SEMAPHORES (152) 
    Primary pointer page: 500, Index root page: 501 
    Total formats: 1, used formats: 1 
    Average record length: 43.40, total records: 5 
    Average version length: 9.00, total versions: 1, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 346.00, compression ratio: 7.97 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 4% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index PK_SEMAPHORES (0) 
    Root page: 1504305, depth: 1, leaf buckets: 1, nodes: 5 
    Average node length: 12.40, total dup: 0, max dup: 0 
    Average key length: 11.00, compression ratio: 0.82 
    Average prefix length: 0.60, average data length: 8.40 
    Clustering factor: 1, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index SEMAPHORES_TASK_UNQ (1) 
    Root page: 1504306, depth: 1, leaf buckets: 1, nodes: 5 
    Average node length: 23.40, total dup: 0, max dup: 0 
    Average key length: 22.00, compression ratio: 1.07 
    Average prefix length: 4.20, average data length: 19.40 
    Clustering factor: 1, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
SETTINGS (135) 
    Primary pointer page: 466, Index root page: 467 
    Total formats: 1, used formats: 1 
    Average record length: 97.63, total records: 149 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1347.00, compression ratio: 13.80 
    Pointer pages: 1, data page slots: 3 
    Data pages: 3, average fill: 70% 
    Primary pages: 3, secondary pages: 0, swept pages: 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: 525, depth: 1, leaf buckets: 1, nodes: 149 
    Average node length: 14.66, total dup: 0, max dup: 0 
    Average key length: 13.55, compression ratio: 2.19 
    Average prefix length: 19.07, average data length: 10.66 
    Clustering factor: 48, ratio: 0.32 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 1 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index SETTINGS_MODE_CODE (0) 
    Root page: 1544806, depth: 1, leaf buckets: 1, nodes: 149 
    Average node length: 25.56, total dup: 0, max dup: 0 
    Average key length: 24.56, compression ratio: 1.63 
    Average prefix length: 18.58, average data length: 21.56 
    Clustering factor: 14, ratio: 0.09 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 0 
        40 - 59% = 1 
        60 - 79% = 0 
        80 - 99% = 0 
 
TMP$DEP_DOCS (129) 
    Primary pointer page: 454, Index root page: 455 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index TMP_DEP_DOCS_UNQ (0) 
    Root page: 1544810, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
TMP$IDX_RECALC (132) 
    Primary pointer page: 460, Index root page: 461 
    Total formats: 2, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index TMP_IDX_RECALC_IDX_NAME_UNQ (0) 
    Root page: 1544807, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
TMP$MON_LOG (133) 
    Primary pointer page: 462, Index root page: 463 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
TMP$MON_LOG_TABLE_STATS (134) 
    Primary pointer page: 464, Index root page: 465 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
TMP$PERF_EST_WHOLE (161) 
    Primary pointer page: 518, Index root page: 519 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
TMP$PERF_LOG (160) 
    Primary pointer page: 516, Index root page: 517 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index TMP$PERF_LOG_UNIT_TRN_DTS_END (0) 
    Root page: 1504230, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
TMP$PERF_MON (131) 
    Primary pointer page: 458, Index root page: 459 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
TMP$RESULT_SET (130) 
    Primary pointer page: 456, Index root page: 457 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index TMP_RESULT_SET_DOC (1) 
    Root page: 1544809, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index TMP_RESULT_SET_WARE_DOC (0) 
    Root page: 1544808, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
TMP$SHOPPING_CART (128) 
    Primary pointer page: 452, Index root page: 453 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index TMP_SHOPCART_UNQ (0) 
    Root page: 1544811, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
TPAUSE (166) 
    Primary pointer page: 528, Index root page: 529 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index RDB$PRIMARY2 (0) 
    Root page: 1504214, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
TRACE_STAT (157) 
    Primary pointer page: 510, Index root page: 511 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
WARES (142) 
    Primary pointer page: 480, Index root page: 481 
    Total formats: 1, used formats: 1 
    Average record length: 77.52, total records: 400 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 444.00, compression ratio: 5.73 
    Pointer pages: 1, data page slots: 6 
    Data pages: 6, average fill: 77% 
    Primary pages: 6, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 5 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 5 
    80 - 99% = 1 
 
    Index FK_WARES_WARE_GROUPS (3) 
    Root page: 1552159, depth: 1, leaf buckets: 1, nodes: 400 
    Average node length: 3.17, total dup: 392, max dup: 60 
    Average key length: 2.16, compression ratio: 4.16 
    Average prefix length: 8.86, average data length: 0.14 
    Clustering factor: 48, ratio: 0.12 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PK_WARES (0) 
    Root page: 1510355, depth: 1, leaf buckets: 1, nodes: 400 
    Average node length: 11.22, total dup: 0, max dup: 0 
    Average key length: 10.22, compression ratio: 0.88 
    Average prefix length: 1.78, average data length: 7.22 
    Clustering factor: 344, ratio: 0.86 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 0 
        40 - 59% = 1 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index WARES_ID_DESC (2) 
    Root page: 1510360, depth: 1, leaf buckets: 1, nodes: 400 
    Average node length: 11.22, total dup: 0, max dup: 0 
    Average key length: 10.22, compression ratio: 0.88 
    Average prefix length: 1.78, average data length: 7.22 
    Clustering factor: 344, ratio: 0.86 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 0 
        40 - 59% = 1 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index WARES_NUMB_UNQ (1) 
    Root page: 1510358, depth: 2, leaf buckets: 3, nodes: 400 
    Average node length: 53.25, total dup: 0, max dup: 0 
    Average key length: 52.23, compression ratio: 1.00 
    Average prefix length: 2.74, average data length: 49.25 
    Clustering factor: 355, ratio: 0.89 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 1 
        80 - 99% = 2 
 
WARE_GROUPS (151) 
    Primary pointer page: 498, Index root page: 499 
    Total formats: 1, used formats: 1 
    Average record length: 32.12, total records: 8 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 346.00, compression ratio: 10.77 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 5% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index PK_WARE_GROUPS (0) 
    Root page: 1504307, depth: 1, leaf buckets: 1, nodes: 8 
    Average node length: 11.25, total dup: 0, max dup: 0 
    Average key length: 10.12, compression ratio: 0.89 
    Average prefix length: 1.75, average data length: 7.25 
    Clustering factor: 1, ratio: 0.12 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index WARE_GROUPS_NAME_UNQ (1) 
    Root page: 1504308, depth: 1, leaf buckets: 1, nodes: 8 
    Average node length: 19.88, total dup: 0, max dup: 0 
    Average key length: 18.12, compression ratio: 0.89 
    Average prefix length: 0.25, average data length: 15.88 
    Clustering factor: 1, ratio: 0.12 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
XQD_1000_1200 (176) 
    Primary pointer page: 549, Index root page: 550 
    Total formats: 1, used formats: 1 
    Average record length: 39.64, total records: 166022 
    Average version length: 69.18, total versions: 70966, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 3.18 
    Pointer pages: 3, data page slots: 4280 
    Data pages: 3320, average fill: 58% 
    Primary pages: 3320, secondary pages: 0, swept pages: 582 
    Empty pages: 737, full pages: 2246 
    Fill distribution: 
     0 - 19% = 955 
    20 - 39% = 44 
    40 - 59% = 36 
    60 - 79% = 791 
    80 - 99% = 1494 
 
    Index XQD_1000_1200_WA_SO_RO_WKR_SND (0) 
    Root page: 105762, depth: 3, leaf buckets: 237, nodes: 166022 
    Average node length: 6.44, total dup: 144629, max dup: 29 
    Average key length: 3.91, compression ratio: 10.74 
    Average prefix length: 40.22, average data length: 1.78 
    Clustering factor: 28423, ratio: 0.17 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 26 
        40 - 59% = 121 
        60 - 79% = 65 
        80 - 99% = 23 
 
XQD_1000_3300 (178) 
    Primary pointer page: 553, Index root page: 554 
    Total formats: 1, used formats: 1 
    Average record length: 64.85, total records: 7210068 
    Average version length: 68.79, total versions: 430334, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.94 
    Pointer pages: 63, data page slots: 102288 
    Data pages: 102288, average fill: 75% 
    Primary pages: 102288, secondary pages: 0, swept pages: 21888 
    Empty pages: 8, full pages: 86298 
    Fill distribution: 
     0 - 19% = 53 
    20 - 39% = 490 
    40 - 59% = 4402 
    60 - 79% = 90066 
    80 - 99% = 7277 
 
    Index XQD_1000_3300_WA_SO_RO_WKR_SND (0) 
    Root page: 1480454, depth: 3, leaf buckets: 10710, nodes: 7210068 
    Average node length: 6.51, total dup: 6239293, max dup: 29 
    Average key length: 3.52, compression ratio: 11.95 
    Average prefix length: 40.62, average data length: 1.38 
    Clustering factor: 1606604, ratio: 0.22 
    Fill distribution: 
         0 - 19% = 8 
        20 - 39% = 1560 
        40 - 59% = 5567 
        60 - 79% = 2955 
        80 - 99% = 620 
 
    Index XQD_1000_3300_WKR_DOC_ASC (1) 
    Root page: 1486068, depth: 3, leaf buckets: 8663, nodes: 7210068 
    Average node length: 5.39, total dup: 6925855, max dup: 177 
    Average key length: 2.40, compression ratio: 7.08 
    Average prefix length: 16.64, average data length: 0.36 
    Clustering factor: 1399996, ratio: 0.19 
    Fill distribution: 
         0 - 19% = 10 
        20 - 39% = 1191 
        40 - 59% = 4817 
        60 - 79% = 1572 
        80 - 99% = 1073 
 
    Index XQD_1000_3300_WKR_DOC_DEC (2) 
    Root page: 1490608, depth: 3, leaf buckets: 8732, nodes: 7210068 
    Average node length: 5.39, total dup: 6925855, max dup: 177 
    Average key length: 2.40, compression ratio: 7.08 
    Average prefix length: 16.64, average data length: 0.36 
    Clustering factor: 1402544, ratio: 0.19 
    Fill distribution: 
         0 - 19% = 11 
        20 - 39% = 1205 
        40 - 59% = 4913 
        60 - 79% = 1549 
        80 - 99% = 1054 
 
XQD_1200_2000 (177) 
    Primary pointer page: 551, Index root page: 552 
    Total formats: 1, used formats: 1 
    Average record length: 66.83, total records: 12156573 
    Average version length: 68.76, total versions: 374534, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.89 
    Pointer pages: 104, data page slots: 168456 
    Data pages: 168456, average fill: 77% 
    Primary pages: 168456, secondary pages: 0, swept pages: 70424 
    Empty pages: 5, full pages: 159588 
    Fill distribution: 
     0 - 19% = 47 
    20 - 39% = 385 
    40 - 59% = 2569 
    60 - 79% = 158020 
    80 - 99% = 7435 
 
    Index XQD_1200_2000_WA_SO_RO_WKR_SND (0) 
    Root page: 1495028, depth: 3, leaf buckets: 18418, nodes: 12156573 
    Average node length: 6.58, total dup: 10598667, max dup: 87 
    Average key length: 3.42, compression ratio: 12.27 
    Average prefix length: 40.70, average data length: 1.30 
    Clustering factor: 2392623, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 26 
        20 - 39% = 2359 
        40 - 59% = 10519 
        60 - 79% = 4652 
        80 - 99% = 862 
 
XQD_2000_3300 (179) 
    Primary pointer page: 555, Index root page: 556 
    Total formats: 1, used formats: 1 
    Average record length: 41.53, total records: 1764995 
    Average version length: 69.09, total versions: 704850, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 3.03 
    Pointer pages: 27, data page slots: 42400 
    Data pages: 30296, average fill: 67% 
    Primary pages: 30296, secondary pages: 0, swept pages: 6577 
    Empty pages: 2529, full pages: 21098 
    Fill distribution: 
     0 - 19% = 4176 
    20 - 39% = 1835 
    40 - 59% = 1699 
    60 - 79% = 11204 
    80 - 99% = 11382 
 
    Index XQD_2000_3300_WA_SO_RO_WKR_SND (0) 
    Root page: 1479712, depth: 3, leaf buckets: 2265, nodes: 1764995 
    Average node length: 5.51, total dup: 1693196, max dup: 99 
    Average key length: 2.55, compression ratio: 16.44 
    Average prefix length: 41.49, average data length: 0.51 
    Clustering factor: 121140, ratio: 0.07 
    Fill distribution: 
         0 - 19% = 7 
        20 - 39% = 454 
        40 - 59% = 1077 
        60 - 79% = 564 
        80 - 99% = 163 
 
XQD_2100_3300 (180) 
    Primary pointer page: 557, Index root page: 558 
    Total formats: 1, used formats: 1 
    Average record length: 39.14, total records: 1071827 
    Average version length: 69.14, total versions: 463964, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 3.22 
    Pointer pages: 23, data page slots: 36712 
    Data pages: 30368, average fill: 41% 
    Primary pages: 30367, secondary pages: 1, swept pages: 9008 
    Empty pages: 9305, full pages: 11696 
    Fill distribution: 
     0 - 19% = 13750 
    20 - 39% = 1649 
    40 - 59% = 1404 
    60 - 79% = 5883 
    80 - 99% = 7682 
 
    Index XQD_2100_3300_WA_SO_RO_WKR_SND (0) 
    Root page: 1479207, depth: 3, leaf buckets: 1443, nodes: 1071827 
    Average node length: 5.76, total dup: 1003093, max dup: 99 
    Average key length: 2.83, compression ratio: 14.83 
    Average prefix length: 41.23, average data length: 0.77 
    Clustering factor: 142498, ratio: 0.13 
    Fill distribution: 
         0 - 19% = 4 
        20 - 39% = 300 
        40 - 59% = 677 
        60 - 79% = 359 
        80 - 99% = 103 
 
XQD_3300_3400 (181) 
    Primary pointer page: 559, Index root page: 560 
    Total formats: 1, used formats: 1 
    Average record length: 65.43, total records: 9138903 
    Average version length: 68.96, total versions: 458877, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.93 
    Pointer pages: 88, data page slots: 142256 
    Data pages: 142232, average fill: 69% 
    Primary pages: 142232, secondary pages: 0, swept pages: 54719 
    Empty pages: 431, full pages: 83535 
    Fill distribution: 
     0 - 19% = 1332 
    20 - 39% = 6446 
    40 - 59% = 23744 
    60 - 79% = 102145 
    80 - 99% = 8565 
 
    Index XQD_3300_3400_WA_SO_RO_WKR_SND (0) 
    Root page: 1472590, depth: 3, leaf buckets: 13456, nodes: 9138903 
    Average node length: 6.67, total dup: 7579669, max dup: 29 
    Average key length: 3.67, compression ratio: 11.45 
    Average prefix length: 40.50, average data length: 1.50 
    Clustering factor: 1963495, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 1393 
        40 - 59% = 6931 
        60 - 79% = 4394 
        80 - 99% = 736 
 
XQS_1000_1200 (182) 
    Primary pointer page: 561, Index root page: 562 
    Total formats: 1, used formats: 1 
    Average record length: 82.48, total records: 21138807 
    Average version length: 82.94, total versions: 13680, 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: 318576 
    Data pages: 318576, average fill: 81% 
    Primary pages: 318576, secondary pages: 0, swept pages: 12519 
    Empty pages: 32, full pages: 317979 
    Fill distribution: 
     0 - 19% = 47 
    20 - 39% = 30 
    40 - 59% = 86 
    60 - 79% = 27435 
    80 - 99% = 290978 
 
    Index XQS_1000_1200_DOC_ID (1) 
    Root page: 1426716, depth: 3, leaf buckets: 19281, nodes: 21138807 
    Average node length: 5.72, total dup: 20657865, max dup: 144 
    Average key length: 2.16, compression ratio: 4.16 
    Average prefix length: 8.86, average data length: 0.14 
    Clustering factor: 3278623, ratio: 0.16 
    Fill distribution: 
         0 - 19% = 5 
        20 - 39% = 2 
        40 - 59% = 7977 
        60 - 79% = 546 
        80 - 99% = 10751 
 
    Index XQS_1000_1200_RCV_ID (3) 
    Root page: 1456980, depth: 3, leaf buckets: 17161, nodes: 21138807 
    Average node length: 6.31, total dup: 18576845, max dup: 49 
    Average key length: 2.75, compression ratio: 3.27 
    Average prefix length: 8.37, average data length: 0.63 
    Clustering factor: 913585, ratio: 0.04 
    Fill distribution: 
         0 - 19% = 6 
        20 - 39% = 3 
        40 - 59% = 783 
        60 - 79% = 260 
        80 - 99% = 16109 
 
    Index XQS_1000_1200_SND_ID (2) 
    Root page: 1441073, depth: 3, leaf buckets: 21018, nodes: 21138807 
    Average node length: 6.35, total dup: 18495752, max dup: 29 
    Average key length: 2.79, compression ratio: 3.23 
    Average prefix length: 8.34, average data length: 0.66 
    Clustering factor: 3572894, ratio: 0.17 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 2 
        40 - 59% = 8138 
        60 - 79% = 606 
        80 - 99% = 12270 
 
    Index XQS_1000_1200_WORKER_ID (0) 
    Root page: 1413348, depth: 3, leaf buckets: 16057, nodes: 21138807 
    Average node length: 5.56, total dup: 21138707, max dup: 231038 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.41, average data length: 0.00 
    Clustering factor: 942474, ratio: 0.04 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 5 
        40 - 59% = 2817 
        60 - 79% = 377 
        80 - 99% = 12856 
 
XQS_1000_3300 (184) 
    Primary pointer page: 565, Index root page: 566 
    Total formats: 1, used formats: 1 
    Average record length: 78.60, total records: 9579479 
    Average version length: 82.62, total versions: 442752, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.60 
    Pointer pages: 103, data page slots: 166664 
    Data pages: 166640, average fill: 71% 
    Primary pages: 166640, secondary pages: 0, swept pages: 71913 
    Empty pages: 507, full pages: 103615 
    Fill distribution: 
     0 - 19% = 1539 
    20 - 39% = 6779 
    40 - 59% = 24611 
    60 - 79% = 67566 
    80 - 99% = 66145 
 
    Index XQS_1000_3300_DOC_ID (1) 
    Root page: 1367502, depth: 3, leaf buckets: 11321, nodes: 9579479 
    Average node length: 5.35, total dup: 9271968, max dup: 207 
    Average key length: 2.23, compression ratio: 4.03 
    Average prefix length: 8.80, average data length: 0.20 
    Clustering factor: 2105887, ratio: 0.22 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 75 
        40 - 59% = 8543 
        60 - 79% = 2640 
        80 - 99% = 61 
 
    Index XQS_1000_3300_RCV_ID (3) 
    Root page: 1379261, depth: 3, leaf buckets: 13341, nodes: 9579479 
    Average node length: 6.22, total dup: 7940324, max dup: 14 
    Average key length: 3.10, compression ratio: 2.90 
    Average prefix length: 8.07, average data length: 0.93 
    Clustering factor: 1458672, ratio: 0.15 
    Fill distribution: 
         0 - 19% = 136 
        20 - 39% = 3901 
        40 - 59% = 4286 
        60 - 79% = 2635 
        80 - 99% = 2383 
 
    Index XQS_1000_3300_SND_ID (2) 
    Root page: 1373059, depth: 3, leaf buckets: 12645, nodes: 9579479 
    Average node length: 5.97, total dup: 8310660, max dup: 44 
    Average key length: 2.85, compression ratio: 3.16 
    Average prefix length: 8.28, average data length: 0.72 
    Clustering factor: 2296234, ratio: 0.24 
    Fill distribution: 
         0 - 19% = 4 
        20 - 39% = 88 
        40 - 59% = 9588 
        60 - 79% = 2891 
        80 - 99% = 74 
 
    Index XQS_1000_3300_WORKER_ID (0) 
    Root page: 1362767, depth: 3, leaf buckets: 9958, nodes: 9579479 
    Average node length: 5.12, total dup: 9579379, max dup: 149395 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.42, average data length: 0.00 
    Clustering factor: 1486367, ratio: 0.16 
    Fill distribution: 
         0 - 19% = 45 
        20 - 39% = 1207 
        40 - 59% = 4956 
        60 - 79% = 1677 
        80 - 99% = 2073 
 
XQS_1200_2000 (183) 
    Primary pointer page: 563, Index root page: 564 
    Total formats: 1, used formats: 1 
    Average record length: 79.66, total records: 11279900 
    Average version length: 82.53, total versions: 361634, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.58 
    Pointer pages: 117, data page slots: 190848 
    Data pages: 189432, average fill: 73% 
    Primary pages: 189432, secondary pages: 0, swept pages: 69252 
    Empty pages: 2973, full pages: 144051 
    Fill distribution: 
     0 - 19% = 5183 
    20 - 39% = 7293 
    40 - 59% = 16880 
    60 - 79% = 41440 
    80 - 99% = 118636 
 
    Index XQS_1200_2000_DOC_ID (1) 
    Root page: 1392101, depth: 3, leaf buckets: 13121, nodes: 11279900 
    Average node length: 5.29, total dup: 11170357, max dup: 687 
    Average key length: 2.08, compression ratio: 4.33 
    Average prefix length: 8.93, average data length: 0.07 
    Clustering factor: 2348606, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 3 
        20 - 39% = 168 
        40 - 59% = 9156 
        60 - 79% = 3657 
        80 - 99% = 137 
 
    Index XQS_1200_2000_RCV_ID (3) 
    Root page: 1406110, depth: 3, leaf buckets: 10451, nodes: 11279900 
    Average node length: 5.49, total dup: 10787396, max dup: 49 
    Average key length: 2.28, compression ratio: 3.95 
    Average prefix length: 8.77, average data length: 0.23 
    Clustering factor: 705950, ratio: 0.06 
    Fill distribution: 
         0 - 19% = 171 
        20 - 39% = 856 
        40 - 59% = 2647 
        60 - 79% = 1786 
        80 - 99% = 4991 
 
    Index XQS_1200_2000_SND_ID (2) 
    Root page: 1398638, depth: 3, leaf buckets: 15004, nodes: 11279900 
    Average node length: 6.02, total dup: 9844069, max dup: 76 
    Average key length: 2.80, compression ratio: 3.21 
    Average prefix length: 8.32, average data length: 0.68 
    Clustering factor: 2365105, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 237 
        40 - 59% = 10609 
        60 - 79% = 4009 
        80 - 99% = 148 
 
    Index XQS_1200_2000_WORKER_ID (0) 
    Root page: 1386211, depth: 3, leaf buckets: 10686, nodes: 11279900 
    Average node length: 5.22, total dup: 11279800, max dup: 182532 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.42, average data length: 0.00 
    Clustering factor: 694968, ratio: 0.06 
    Fill distribution: 
         0 - 19% = 85 
        20 - 39% = 866 
        40 - 59% = 4697 
        60 - 79% = 1444 
        80 - 99% = 3594 
 
XQS_2000_3300 (185) 
    Primary pointer page: 567, Index root page: 568 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index XQS_2000_3300_DOC_ID (1) 
    Root page: 1361753, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index XQS_2000_3300_RCV_ID (3) 
    Root page: 1361755, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index XQS_2000_3300_SND_ID (2) 
    Root page: 1361754, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index XQS_2000_3300_WORKER_ID (0) 
    Root page: 1361752, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
XQS_2100_3300 (186) 
    Primary pointer page: 569, Index root page: 570 
    Total formats: 1, used formats: 1 
    Average record length: 78.86, total records: 9704234 
    Average version length: 82.92, total versions: 453976, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.60 
    Pointer pages: 105, data page slots: 170376 
    Data pages: 170360, average fill: 71% 
    Primary pages: 170360, secondary pages: 0, swept pages: 75644 
    Empty pages: 569, full pages: 100811 
    Fill distribution: 
     0 - 19% = 1620 
    20 - 39% = 6840 
    40 - 59% = 25961 
    60 - 79% = 72354 
    80 - 99% = 63585 
 
    Index XQS_2100_3300_DOC_ID (1) 
    Root page: 1344686, depth: 3, leaf buckets: 11698, nodes: 9704234 
    Average node length: 5.16, total dup: 9675086, max dup: 1503 
    Average key length: 2.03, compression ratio: 4.43 
    Average prefix length: 8.97, average data length: 0.03 
    Clustering factor: 1911375, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 33 
        20 - 39% = 1428 
        40 - 59% = 7848 
        60 - 79% = 1809 
        80 - 99% = 580 
 
    Index XQS_2100_3300_RCV_ID (3) 
    Root page: 1355717, depth: 3, leaf buckets: 13459, nodes: 9704234 
    Average node length: 6.24, total dup: 8043297, max dup: 14 
    Average key length: 3.10, compression ratio: 2.90 
    Average prefix length: 8.07, average data length: 0.93 
    Clustering factor: 1430430, ratio: 0.15 
    Fill distribution: 
         0 - 19% = 152 
        20 - 39% = 3888 
        40 - 59% = 4303 
        60 - 79% = 2574 
        80 - 99% = 2542 
 
    Index XQS_2100_3300_SND_ID (2) 
    Root page: 1350049, depth: 3, leaf buckets: 12337, nodes: 9704234 
    Average node length: 5.42, total dup: 9268755, max dup: 110 
    Average key length: 2.29, compression ratio: 3.93 
    Average prefix length: 8.76, average data length: 0.24 
    Clustering factor: 2045736, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 27 
        20 - 39% = 1410 
        40 - 59% = 8735 
        60 - 79% = 1590 
        80 - 99% = 575 
 
    Index XQS_2100_3300_WORKER_ID (0) 
    Root page: 985805, depth: 3, leaf buckets: 10079, nodes: 9704234 
    Average node length: 5.13, total dup: 9704134, max dup: 151623 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.43, average data length: 0.00 
    Clustering factor: 1504558, ratio: 0.16 
    Fill distribution: 
         0 - 19% = 38 
        20 - 39% = 1216 
        40 - 59% = 5032 
        60 - 79% = 1613 
        80 - 99% = 2180 
 
XQS_3300_3400 (187) 
    Primary pointer page: 571, Index root page: 572 
    Total formats: 1, used formats: 1 
    Average record length: 67.13, total records: 579074 
    Average version length: 68.85, total versions: 8842, 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: 5, data page slots: 7952 
    Data pages: 7952, average fill: 76% 
    Primary pages: 7952, secondary pages: 0, swept pages: 3335 
    Empty pages: 4, full pages: 7226 
    Fill distribution: 
     0 - 19% = 4 
    20 - 39% = 13 
    40 - 59% = 135 
    60 - 79% = 7624 
    80 - 99% = 176 
 
    Index XQS_3300_3400_DOC_ID (1) 
    Root page: 34762, depth: 3, leaf buckets: 727, nodes: 579074 
    Average node length: 5.95, total dup: 493116, max dup: 83 
    Average key length: 3.09, compression ratio: 2.91 
    Average prefix length: 8.06, average data length: 0.94 
    Clustering factor: 101024, ratio: 0.17 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 19 
        40 - 59% = 519 
        60 - 79% = 88 
        80 - 99% = 101 
 
    Index XQS_3300_3400_SND_ID (2) 
    Root page: 31774, depth: 3, leaf buckets: 751, nodes: 579074 
    Average node length: 6.15, total dup: 475062, max dup: 29 
    Average key length: 3.29, compression ratio: 2.73 
    Average prefix length: 7.89, average data length: 1.11 
    Clustering factor: 101074, ratio: 0.17 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 21 
        40 - 59% = 522 
        60 - 79% = 107 
        80 - 99% = 101 
 
    Index XQS_3300_3400_WORKER_ID (0) 
    Root page: 375548, depth: 2, leaf buckets: 584, nodes: 579074 
    Average node length: 4.86, total dup: 578974, max dup: 9194 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.42, average data length: 0.00 
    Clustering factor: 89654, ratio: 0.15 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 27 
        40 - 59% = 349 
        60 - 79% = 98 
        80 - 99% = 109 
 
ZDOC_DATA (170) 
    Primary pointer page: 537, Index root page: 538 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
ZDOC_LIST (169) 
    Primary pointer page: 535, Index root page: 536 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
ZINVNT_TURNOVER_LOG (171) 
    Primary pointer page: 539, Index root page: 540 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
ZPDISTR (174) 
    Primary pointer page: 545, Index root page: 546 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index ZPDISTR_ID (0) 
    Root page: 1504207, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
ZPSTORNED (175) 
    Primary pointer page: 547, Index root page: 548 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index ZPSTORNED_ID (0) 
    Root page: 1504206, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
ZQDISTR (172) 
    Primary pointer page: 541, Index root page: 542 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index ZQDISTR_ID (0) 
    Root page: 1504212, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index ZQDISTR_WARE_SNDOP_RCVOP (1) 
    Root page: 1504213, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
ZQSTORNED (173) 
    Primary pointer page: 543, Index root page: 544 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index ZQSTORNED_DOC_ID (1) 
    Root page: 1504209, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index ZQSTORNED_ID (0) 
    Root page: 1504208, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index ZQSTORNED_RCV_ID (3) 
    Root page: 1504211, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index ZQSTORNED_SND_ID (2) 
    Root page: 1504210, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
ZTMP_DEP_DOCS (168) 
    Primary pointer page: 533, Index root page: 534 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
ZTMP_SHOPPING_CART (167) 
    Primary pointer page: 531, Index root page: 532 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
Z_USED_VIEWS (144) 
    Primary pointer page: 484, Index root page: 485 
    Total formats: 1, used formats: 1 
    Average record length: 29.38, total records: 29 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 99.00, compression ratio: 3.37 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 16% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index Z_USED_VIEWS_UNQ (0) 
    Root page: 1510350, depth: 1, leaf buckets: 1, nodes: 29 
    Average node length: 15.17, total dup: 0, max dup: 0 
    Average key length: 14.14, compression ratio: 1.44 
    Average prefix length: 9.17, average data length: 11.17 
    Clustering factor: 1, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
Gstat completion time Sat Feb 17 19:11:37 2024

Record versions statistics, table

TABLE_NAME TOTAL_RECS TOTAL_VERS MAX_VERSIONS VERS_TO_RECS_PRC MAXV_TO_VERS_PRC
DOC_DATA 7742776 87989 1 0.0000 0.0000
DOC_LIST 2238738 89230 3 0.0000 0.0000
FB_ERRORS 2182 757 1 0.0000 0.0000
INVNT_SALDO 400 238917 623 59700.0000 0.0000
INVNT_TURNOVER_LOG 72471 68659 1 0.0000 0.0000
MONEY_SALDO 49 17836 962 36400.0000 0.0000
MONEY_TURNOVER_LOG 1827 1721 1 0.0000 0.0000
PDISTR 816978 80182 4 0.0000 0.0000
PERF_SPLIT_0 171060 3451 1 0.0000 0.0000
PERF_SPLIT_1 170918 3732 1 0.0000 0.0000
PERF_SPLIT_2 159400 3255 1 0.0000 0.0000
PERF_SPLIT_3 190385 3013 1 0.0000 0.0000
PERF_SPLIT_4 178866 22931 1 0.0000 0.0000
PERF_SPLIT_5 182011 2860 1 0.0000 0.0000
PERF_SPLIT_6 174589 2204 1 0.0000 0.0000
PERF_SPLIT_7 189129 29382 1 0.0000 0.0000
PERF_SPLIT_8 188312 4659 1 0.0000 0.0000
PERF_SPLIT_9 175148 3617 1 0.0000 0.0000
PSTORNED 2109784 46910 1 0.0000 0.0000
SEMAPHORES 5 1 1 0.0000 100.0000
XQD_1000_1200 166022 70966 1 0.0000 0.0000
XQD_1000_3300 7210068 430334 1 0.0000 0.0000
XQD_1200_2000 12156573 374534 1 0.0000 0.0000
XQD_2000_3300 1764995 704850 1 0.0000 0.0000
XQD_2100_3300 1071827 463964 1 0.0000 0.0000
XQD_3300_3400 9138903 458877 1 0.0000 0.0000
XQS_1000_1200 21138807 13680 1 0.0000 0.0000
XQS_1000_3300 9579479 442752 1 0.0000 0.0000
XQS_1200_2000 11279900 361634 1 0.0000 0.0000
XQS_2100_3300 9704234 453976 1 0.0000 0.0000
XQS_3300_3400 579074 8842 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 ---
:729: 
:730: mscs-test-161.budzdorov.ru    Sat Feb 17 19:09:48 2024
:731:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:732: 
--- end of diff output ---

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

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