Generated by /opt/oltp-emul/oltp_isql_run_worker.sh, ISQL session No. 1 of total launched 100. 12.03.2024 04:08
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 15760692 kB
MemAvailable 30263584 kB
Buffers 20 kB
Cached 15935628 kB
SwapCached 2332 kB
Command: fdisk -l
WARNING: fdisk GPT support is currently new, and therefore in an experimental phase. Use at your own discretion.
Disk /dev/sda: 599.9 GB, 599932581888 bytes, 1171743324 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 262144 bytes / 524288 bytes
Disk label type: gpt
Disk identifier: 919DACA4-2F35-4CBB-BAA7-2A8CD8F7168C
# Start End Size Type Name
1 2048 411647 200M EFI System EFI System Partition
2 411648 2508799 1G Microsoft basic
3 2508800 1171742719 557.5G Linux LVM
Disk /dev/mapper/centos_mscs--test--161-root: 53.7 GB, 53687091200 bytes, 104857600 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 262144 bytes / 524288 bytes
Disk /dev/mapper/centos_mscs--test--161-swap: 16.8 GB, 16844324864 bytes, 32899072 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 262144 bytes / 524288 bytes
Disk /dev/sdb: 536 MB, 536870912 bytes, 1048576 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 512 bytes / 512 bytes
Disk label type: dos
Disk identifier: 0x00000046
Device Boot Start End Blocks Id System
/dev/sdb1 63 514079 257008+ c W95 FAT32 (LBA)
Disk /dev/mapper/centos_mscs--test--161-home: 528.1 GB, 528109010944 bytes, 1031462912 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 262144 bytes / 524288 bytes

Server and database settinfs 


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

Test configuration settings 

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

Test finish info 


FINISH_STATE                    NORMAL: TEST_TIME EXPIRED AT 2024-03-12 04:07:48
DTS_END                         2024-03-12 04:07:48.1770
FB_GDSCODE                      -1
FB_MNEMONA                      
STACK                           SP_CANCEL_SUPPLIER_ORDER(116:18) ==> SP_CANCEL_CUSTOMER_RESERVE(36:5) ==> SP_CHECK_TO_STOP_WORK(32:12) ==> SP_HALT_ON_ERROR(68:17)
IP                              ::1/37844
TRN_ID                          175080
ATT_ID                          560
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: 8882.18 21836 888218
customer order: creation 177.65 430 17765
customer order: refuse 15.78 380 1578
order to supplier: creation 47.95 1379 4795
order to supplier: removal 3.36 101228 336
invoice (draft): creation 48.53 3160 4853
invoice (draft): removal 46.50 797 4650
invoice accept: apply 42.13 22588 4213
invoice accept: cancel 42.10 931 4210
customer reserve: creation 4032.07 218 403207
customer reserve: removal 4132.34 67 413234
realization accept: apply 85.96 203 8596
realization accept: cancel 76.00 131 7600
payment from customer: creation 61.76 126 6176
payment from customer: removal 6.04 71 604
payment to supplier: creation 49.36 131 4936
payment to supplier: removal 3.60 163 360
service: total inventory turnovers 4.02 3682 402
service: total monetary turnovers 6.08 730 608
service: aggregate perf. data 0.92 13721 92
service: refresh index statistics 0.03 286587 3

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:02, from 12-03-2024 04:09:18 to 12-03-2024 04:09:20.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 4486
TEST_TIME 2 4645
TEST_TIME 3 4093
TEST_TIME 4 3930
TEST_TIME 5 4448
TEST_TIME 6 4367
TEST_TIME 7 4449
TEST_TIME 8 4886
TEST_TIME 9 5323
TEST_TIME 10 5753
TEST_TIME 11 5787
TEST_TIME 12 5984
TEST_TIME 13 6369
TEST_TIME 14 6788
TEST_TIME 15 6861
TEST_TIME 16 6945
TEST_TIME 17 7088
TEST_TIME 18 7270
TEST_TIME 19 7496
TEST_TIME 20 7778
TEST_TIME 21 8188
TEST_TIME 22 8286
TEST_TIME 23 9024
TEST_TIME 24 8822
TEST_TIME 25 9160
TEST_TIME 26 9573
TEST_TIME 27 10079
TEST_TIME 28 9840
TEST_TIME 29 9639
TEST_TIME 30 9356
TEST_TIME 31 9332
TEST_TIME 32 9256
TEST_TIME 33 9279
TEST_TIME 34 9177
TEST_TIME 35 9233
TEST_TIME 36 9167
TEST_TIME 37 9119
TEST_TIME 38 9088
TEST_TIME 39 8901
TEST_TIME 40 9024
TEST_TIME 41 9287
TEST_TIME 42 9356
TEST_TIME 43 9354
TEST_TIME 44 9293
TEST_TIME 45 9325
TEST_TIME 46 9429
TEST_TIME 47 9395
TEST_TIME 48 9387
TEST_TIME 49 9344
TEST_TIME 50 9395
TEST_TIME 51 9539
TEST_TIME 52 9475
TEST_TIME 53 9399
TEST_TIME 54 9350
TEST_TIME 55 9259
TEST_TIME 56 9227
TEST_TIME 57 9159
TEST_TIME 58 9167
TEST_TIME 59 9106
TEST_TIME 60 9096
TEST_TIME 61 9218
TEST_TIME 62 9195
TEST_TIME 63 9216
TEST_TIME 64 9181
TEST_TIME 65 9185
TEST_TIME 66 9273
TEST_TIME 67 9247
TEST_TIME 68 9184
TEST_TIME 69 9226
TEST_TIME 70 9240
TEST_TIME 71 9235
TEST_TIME 72 9288
TEST_TIME 73 9333
TEST_TIME 74 9226
TEST_TIME 75 9139
TEST_TIME 76 9124
TEST_TIME 77 9054
TEST_TIME 78 9061
TEST_TIME 79 9039
TEST_TIME 80 9033
TEST_TIME 81 9000
TEST_TIME 82 9083
TEST_TIME 83 9055
TEST_TIME 84 9056
TEST_TIME 85 9063
TEST_TIME 86 9148
TEST_TIME 87 9118
TEST_TIME 88 9147
TEST_TIME 89 9172
TEST_TIME 90 9169
TEST_TIME 91 9111
TEST_TIME 92 9033
TEST_TIME 93 9071
TEST_TIME 94 9025
TEST_TIME 95 8966
TEST_TIME 96 8965
TEST_TIME 97 8950
TEST_TIME 98 8941
TEST_TIME 99 8931
TEST_TIME 100 8892

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:03, from 12-03-2024 04:09:22 to 12-03-2024 04:09:25.

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 1257489 1257489 0 0.00 0 28354 8 0 0
doc_list_biud 1257489 1257489 0 0.00 0 33360 28 0 0
sp_add_invoice_to_stock 4330 4213 117 2.70 27 228445 22589 0 117
sp_cancel_adding_invoice 4210 4210 0 0.00 4 57294 932 0 0
sp_cancel_client_order 1578 1578 0 0.00 4 21019 380 0 0
sp_cancel_customer_reserve 413234 413234 0 0.00 0 33363 67 0 0
sp_cancel_pay_from_customer 604 604 0 0.00 3 8741 71 0 0
sp_cancel_pay_to_supplier 360 360 0 0.00 2 11923 164 0 0
sp_cancel_supplier_invoice 4654 4650 4 0.08 1 27498 798 0 4
sp_cancel_supplier_order 336 336 0 0.00 6 860857 101229 0 0
sp_cancel_write_off 7600 7600 0 0.00 1 17847 131 0 0
sp_client_order 17765 17765 0 0.00 3 34430 431 0 0
sp_customer_reserve 403207 403207 0 0.00 0 47418 218 0 0
sp_fill_shopping_cart 27404 27404 0 0.00 1 21048 39 0 0
sp_fill_shopping_cart_clo_res 403199 403199 0 0.00 0 26646 17 0 0
sp_get_clo_for_invoice 4205 4205 0 0.00 0 31347 360 0 0
sp_kill_cost_storno 12774 12774 0 0.00 0 14641 72 0 0
sp_kill_qstorno_ret_qs2qd 839054 839054 0 0.00 0 33348 36 0 0
sp_kill_qty_storno 444409 444409 0 0.00 0 33360 77 0 0
sp_lock_selected_doc 17787 17787 0 0.00 0 8934 5 0 0
sp_make_cost_storno 23913 23913 0 0.00 0 23237 67 0 0
sp_multiply_rows_for_pdistr 23913 23913 0 0.00 0 28345 37 0 0
sp_multiply_rows_for_qdistr 17765 17765 0 0.00 0 34413 214 0 0
sp_pay_from_customer 6176 6176 0 0.00 4 12887 127 0 0
sp_pay_to_supplier 4936 4936 0 0.00 4 18257 132 0 0
sp_payment_common 11112 11112 0 0.00 1 9105 23 0 0
sp_qd_handle_on_cancel_clo 1578 1578 0 0.00 0 21009 358 0 0
sp_qd_handle_on_invoice_upd_sts 8415 8415 0 0.00 0 29435 338 0 0
sp_qd_handle_on_reserve_upd_sts 8596 8596 0 0.00 0 21842 60 0 0
sp_reserve_write_off 8596 8596 0 0.00 6 28358 203 0 0
sp_supplier_invoice 4853 4853 0 0.00 5 88011 3160 0 0
sp_supplier_order 4795 4795 0 0.00 5 61405 1380 0 0
srv_aggregate_perf_data 92 92 0 0.00 1729 131678 13721 0 0
srv_fill_mon_cache_memory 56 56 0 0.00 1296 131173 38807 0 0
srv_find_qd_qs_mism 844919 844919 0 0.00 0 21496 7 0 0
srv_make_invnt_saldo 402 402 0 0.00 35 113522 3683 0 0
srv_make_money_saldo 608 608 0 0.00 0 19895 731 0 0
srv_recalc_idx_stat 3 3 0 0.00 264407 314940 286588 0 0
t$perf-abend:sp_add_invoice_to_stock 117 117 0 0.00 0 0 0 0 0
t$perf-abend:sp_cancel_supplier_invoice 4 4 0 0.00 0 0 0 0 0
t$perf-norm:sp_add_invoice_to_stock 4215 4215 0 0.00 0 12873 179 0 0
t$perf-norm:sp_cancel_adding_invoice 372 372 0 0.00 0 2482 72 0 0
t$perf-norm:sp_cancel_client_order 1578 1578 0 0.00 0 3661 10 0 0
t$perf-norm:sp_cancel_customer_reserve 580 580 0 0.00 0 2903 14 0 0
t$perf-norm:sp_cancel_pay_from_customer 604 604 0 0.00 0 13554 31 0 0
t$perf-norm:sp_cancel_pay_to_supplier 360 360 0 0.00 0 3413 14 0 0
t$perf-norm:sp_cancel_supplier_invoice 325 325 0 0.00 0 515 11 0 0
t$perf-norm:sp_cancel_supplier_order 336 336 0 0.00 0 22836 1705 0 0
t$perf-norm:sp_cancel_write_off 831 831 0 0.00 0 2213 10 0 0
t$perf-norm:sp_client_order 17768 17768 0 0.00 0 4030 17 0 0
t$perf-norm:sp_customer_reserve 850 850 0 0.00 0 1673 8 0 0
t$perf-norm:sp_pay_from_customer 6176 6176 0 0.00 0 6161 11 0 0
t$perf-norm:sp_pay_to_supplier 4936 4936 0 0.00 0 3313 8 0 0
t$perf-norm:sp_reserve_write_off 8596 8596 0 0.00 0 5376 9 0 0
t$perf-norm:sp_supplier_invoice 4853 4853 0 0.00 0 13515 21 0 0
t$perf-norm:sp_supplier_order 4796 4796 0 0.00 0 5405 15 0 0
t$perf-norm:srv_aggregate_perf_data 92 92 0 0.00 0 319 9 0 0
t$perf-norm:srv_fill_mon_cache_memory 56 56 0 0.00 0 1118 22 0 0
t$perf-norm:srv_make_invnt_saldo 402 402 0 0.00 0 3081 22 0 0
t$perf-norm:srv_make_money_saldo 608 608 0 0.00 0 3515 13 0 0
t$perf-norm:srv_recalc_idx_stat 3 3 0 0.00 1 56 22 0 0
v_add_invoice_to_stock 8644 8410 234 2.70 0 6506 19 0 234
v_all_customers 33034 33034 0 0.00 0 27 1 0 0
v_all_suppliers 27112 27112 0 0.00 0 26 1 0 0
v_all_wares 35524 35524 0 0.00 0 20 1 0 0
v_cancel_adding_invoice 744 744 0 0.00 0 3698 18 0 0
v_cancel_client_order 3156 3156 0 0.00 0 1699 4 0 0
v_cancel_customer_prepayment 1208 1208 0 0.00 0 8731 10 0 0
v_cancel_customer_reserve 1160 1160 0 0.00 0 3959 13 0 0
v_cancel_payment_to_supplier 720 720 0 0.00 0 4677 16 0 0
v_cancel_supplier_invoice 658 650 8 1.21 0 276 11 0 8
v_cancel_supplier_order 672 672 0 0.00 0 2009 8 0 0
v_cancel_write_off 1662 1662 0 0.00 0 4529 20 0 0
v_max_id_clo_ord 4789 4789 0 0.00 0 497 1 0 0
v_max_id_clo_res 850 850 0 0.00 0 1019 6 0 0
v_max_id_ord_sup 4852 4852 0 0.00 0 6836 4 0 0
v_max_non_paid_invoice 1021 1021 0 0.00 0 1081 3 0 0
v_max_non_paid_realizn 3009 3009 0 0.00 0 1199 3 0 0
v_min_id_clo_ord 4789 4789 0 0.00 0 5616 11 0 0
v_min_id_clo_res 850 850 0 0.00 0 2258 9 0 0
v_min_id_ord_sup 4852 4852 0 0.00 0 5774 6 0 0
v_min_non_paid_invoice 4936 4936 0 0.00 0 5933 13 0 0
v_min_non_paid_realizn 6176 6176 0 0.00 0 9102 19 0 0
v_our_firm 8824 8824 0 0.00 0 26 1 0 0
v_reserve_write_off 17192 17192 0 0.00 0 5649 8 0 0
x_lock_depdocs_on_canc_invoice 8535 8535 0 0.00 0 16455 129 0 0
x_lock_depdocs_on_canc_sup_ord 336 336 0 0.00 0 3792 323 0 0
x_make_qstorno_1000_1200 4795 4795 0 0.00 1 61357 1300 0 0
x_make_qstorno_1200_2000 4853 4853 0 0.00 2 87962 3018 0 0
x_make_qstorno_2100_3300 403207 403207 0 0.00 0 47416 199 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 12-03-2024 04:09:26 to 12-03-2024 04:09:30.

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
02:07:52 3 8192000000 8798583680 8809734144 4459392 0.054 2 1 2 0 4558784 63616 35776
02:08:52 32074 8192000000 9711623360 10008829952 798183984 8.878 100 90 180 0 827973648 7743296 22046368
02:10:29 21251 8192000000 9751491872 10058432512 826699184 9.166 100 90 179 0 861357424 12778352 21879888
02:11:53 11538 8192000000 9783989584 10101821440 856980864 9.470 100 84 168 0 896006528 19698672 19326992
02:13:08 10257 8192000000 9842522448 10169827328 892788432 9.827 100 80 158 0 952435184 42455088 17191664
02:14:27 4814 8192000000 9883496064 10226835456 929601648 10.191 100 66 128 0 1004581344 61144240 13835456
02:15:37 4595 8192000000 9946202912 10299174912 974415488 10.630 100 78 155 0 1066518144 76425472 15677184
02:16:44 1774 8192000000 9978515936 10337648640 1006282112 10.939 100 79 158 0 1094828432 72285056 16261264
02:17:47 1797 8192000000 10005288032 10369130496 1030318592 11.172 100 94 188 0 1119020816 70469104 18233120
02:18:51 1812 8192000000 10023512880 10393759744 1050053424 11.361 100 84 167 0 1135244688 68261856 16929408
02:19:54 20636 8192000000 9974979408 10357428224 1060793552 11.464 100 57 114 0 1101401872 27205792 13402528
02:21:16 7927 8192000000 9987202048 10387120128 1070984048 11.561 100 31 63 0 1107574864 30263440 6327376
02:22:25 10153 8192000000 9995561584 10406199296 1079974208 11.647 100 28 57 0 1114715120 28674688 6066224
02:23:38 4326 8192000000 10005396464 10405330944 1090572880 11.748 100 38 76 1 1123947824 25418432 7956512
02:24:44 40956 8192000000 9995562864 10392330240 1081889104 11.665 99 57 112 3 1111311680 16772288 12650288
02:26:28 5656 8192000000 10002653792 10405502976 1097386896 11.813 100 32 64 2 1133349664 28676688 7286080
02:27:34 7751 8192000000 10002781264 10405863424 1079661776 11.644 99 26 52 0 1104210992 18717472 5831744
02:28:53 17858 8192000000 10017585168 10414829568 1095558144 11.795 100 35 68 0 1121230512 18280912 7391456
02:30:12 72862 8192000000 10084465920 10487783424 1110750960 11.940 100 49 96 0 1201452320 81304816 9396544
02:32:26 12356 8192000000 10075017168 10484731904 1096919488 11.808 99 37 73 0 1186564656 82104944 7540224
02:33:48 13287 8192000000 10111047152 10505875456 1098835632 11.827 100 61 120 0 1235110880 123372416 12902832
02:35:06 14948 8192000000 10085287152 10497269760 1091639440 11.758 100 37 74 0 1204946624 105341200 7965984
02:36:23 8092 8192000000 10100494176 10510991360 1090229120 11.745 100 51 100 2 1209042672 106924784 11888768
02:37:36 13072 8192000000 10138704912 10546601984 1097713008 11.816 100 50 99 0 1254606864 146291696 10602160
02:38:58 26806 8192000000 10167963200 10579304448 1088852640 11.732 98 41 80 1 1255089040 156922096 9314304
02:40:31 4780 8192000000 10215157824 10603327488 1114379360 11.974 100 81 160 1 1309665920 178985776 16300784
02:41:40 4022 8192000000 10188386064 10578219008 1118359440 12.011 100 63 127 0 1288768944 156566944 13842560
02:42:47 4120 8192000000 10224125536 10620747776 1122346592 12.049 100 70 141 0 1324157984 186015840 15795552
02:43:56 4502 8192000000 10262362368 10659565568 1135212688 12.170 100 79 154 2 1368351120 215255568 17882864
02:45:05 1294 8192000000 10339833072 10742710272 1142395984 12.238 100 86 169 1 1446078384 283801600 19880800
02:46:15 6718 8192000000 10336710432 10748571648 1147852208 12.289 100 74 145 1 1449550128 284842800 16855120
02:47:26 2502 8192000000 10314464976 10728681472 1142675712 12.241 100 80 159 0 1411899520 250970032 18253776
02:48:31 10665 8192000000 10314647520 10759118848 1157251360 12.378 100 49 97 0 1443298224 274293824 11753040
02:49:46 5922 8192000000 10310331856 10745376768 1169469216 12.492 100 42 84 0 1423227216 244164880 9593120
02:50:54 10063 8192000000 10258162000 10731630592 1169801712 12.495 100 20 40 0 1358747264 184208512 4737040
02:52:25 14391 8192000000 10267122736 10753150976 1159279680 12.397 100 19 38 0 1374970080 211107392 4583008
02:53:46 30942 8192000000 10110176176 10649948160 1140022080 12.216 100 12 24 0 1277307168 134132608 3152480
02:55:18 85469 8192000000 10058825696 10494717952 1129520432 12.117 99 39 79 1 1157904480 19479536 8904512
02:57:44 15475 8192000000 10090058608 10520133632 1143229936 12.246 100 51 102 2 1185366032 31710656 10425440
02:59:06 19103 8192000000 10111818432 10542206976 1153735424 12.345 100 63 126 0 1224077792 57130864 13211504
03:00:29 54028 8192000000 10158381104 10608357376 1164343456 12.444 100 16 32 0 1250865088 83149888 3371744
03:03:18 51095 8192000000 10149194944 10603954176 1161122432 12.414 99 20 40 0 1260324064 95206704 3994928
03:05:15 103943 8192000000 10191975152 10650333184 1156726832 12.373 99 31 62 0 1256684592 92647568 7310192
03:08:07 62864 8192000000 10131794464 10692923392 1168737488 12.485 100 10 20 0 1298521952 127609712 2174752
03:10:16 77540 8192000000 10106144288 10561921024 1098947728 11.828 94 13 27 0 1137492976 35886976 2658272
03:12:39 41094 8192000000 10089434640 10550423552 1123468848 12.060 97 26 52 0 1191610096 61860272 6280976
03:14:30 35745 8192000000 10081294832 10503491584 1071056288 11.562 93 49 97 0 1109971760 28317088 10598384
03:16:12 17310 8192000000 10051516592 10471563264 1087360784 11.718 97 38 75 1 1138599968 44303728 6935456
03:17:34 15866 8192000000 10118638128 10551619584 1124237072 12.067 100 48 96 0 1198958800 64877760 9843968
03:18:56 52319 8192000000 10094123344 10516049920 1138284192 12.199 100 29 58 0 1185506560 40532608 6689760
03:20:50 76489 8192000000 10072477424 10541293568 1139302112 12.209 100 39 71 1 1187932384 40799424 7830848
03:23:16 6594 8192000000 10057706512 10522353664 1116765872 11.996 99 26 52 0 1162122128 40121744 5234512
03:24:25 19929 8192000000 10129254736 10559127552 1109048880 11.923 98 50 99 1 1189349680 70416880 9883920
03:25:46 48197 8192000000 10093507360 10526089216 1076457376 11.614 95 12 23 0 1168213264 89379552 2376336
03:28:10 37567 8192000000 10083916656 10582593536 1107045344 11.904 99 10 20 0 1186123024 76878496 2199184
03:30:26 42726 8192000000 10038123536 10472108032 1076957632 11.618 97 16 32 0 1121620048 41699488 2962928
03:32:10 65717 8192000000 10088606896 10542219264 1105320864 11.888 99 20 41 0 1199280800 89780032 4179904
03:34:34 118888 8192000000 10066900224 10513772544 1023597344 11.107 92 31 60 0 1050849792 21462352 5790096
03:37:35 35290 8192000000 10071110016 10490929152 1105527744 11.890 99 35 70 1 1143095520 31021648 6546128
03:39:12 54775 8192000000 10089189264 10550562816 1116210000 11.991 99 31 62 0 1193506816 71579952 5716864
03:41:08 84547 8192000000 10048107264 10491846656 1131493072 12.135 100 33 64 0 1175183888 36697856 6992960
03:43:55 59011 8192000000 10084424304 10543329280 1133311936 12.153 100 10 20 0 1185690016 50157392 2220688
03:46:22 44876 8192000000 10072835600 10521526272 1134806592 12.167 100 17 34 0 1191206400 52717664 3682144
03:48:08 56442 8192000000 10110369264 10552995840 1135444464 12.173 100 15 30 0 1205516592 66931520 3140608
03:50:08 50715 8192000000 10102517200 10551443456 1141301472 12.228 99 25 51 0 1200613296 53698784 5613040
03:52:02 65591 8192000000 10108902080 10618925056 1150691856 12.316 100 18 36 0 1231380288 76349232 4339200
03:54:12 38752 8192000000 10132159200 10581155840 1141339664 12.228 99 35 69 0 1184400816 36373456 6687696
03:55:57 72180 8192000000 10092582080 10535780352 1076803744 11.617 95 25 50 0 1136423936 54604048 5016144
03:58:09 131173 8192000000 10086441552 10540167168 1113127488 11.962 100 23 46 0 1213817760 95698272 4992000
04:01:30 39608 8192000000 10037576336 10497036288 1102646144 11.863 98 10 20 0 1137332880 32846912 1839824
04:03:15 46987 8192000000 10041717904 10495565824 1113934272 11.970 99 12 24 0 1158996160 42394592 2667296
04:05:07 37778 8192000000 10044067248 10486231040 1090447856 11.747 98 13 26 0 1120533872 27483488 2602528
04:06:46 28239 8192000000 10104895248 10535948288 1083043728 11.676 96 24 48 0 1166308784 78050928 5214128

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:14, from 12-03-2024 04:09:32 to 12-03-2024 04:09:46.

Exceptions occured during test was in run

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

Completed "Exceptions occured during test was in run". Done for 00:00:02, from 12-03-2024 04:09:47 to 12-03-2024 04:09:49.

Content of mon$database and FB version 


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


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

Database statistics 

 
Database "/home/bases/oltp40-etalone.fdb" 
Gstat execution time Tue Mar 12 04:09:50 2024 
 
Database header page information: 
    Flags            0 
    Generation        92127 
    System Change Number    0 
    Page size        8192 
    ODS version        13.0 
    Oldest transaction    170648 
    Oldest active        176408 
    Oldest snapshot        176408 
    Next transaction    176409 
    Sequence number        0 
    Next attachment ID    705 
    Implementation        HW=AMD/Intel/x64 little-endian OS=Linux CC=gcc 
    Shadow count        0 
    Page buffers        0 
    Next header page    0 
    Database dialect    3 
    Creation date        Apr 30, 2020 7:30:08 
    Attributes        force write 
 
    Variable header data: 
    Database GUID:    {58978C10-B735-40F5-8B7D-F7A1956E782B} 
    Sweep interval:        0 
    *END* 
 
 
Database file sequence: 
File /home/bases/oltp40-etalone.fdb is the only file 
 
Analyzing database pages ... 
AGENTS (150) 
    Primary pointer page: 524, Index root page: 525 
    Total formats: 1, used formats: 1 
    Average record length: 33.60, total records: 50 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 344.00, compression ratio: 10.24 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 31% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 1 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index AGENTS_ID_DESC (2) 
    Root page: 1504333, depth: 1, leaf buckets: 1, nodes: 50 
    Average node length: 11.82, total dup: 0, max dup: 0 
    Average key length: 10.80, compression ratio: 0.83 
    Average prefix length: 1.18, average data length: 7.82 
    Clustering factor: 1, ratio: 0.02 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index AGENTS_IS_OUR_FIRM (4) 
    Root page: 1504335, depth: 1, leaf buckets: 1, nodes: 50 
    Average node length: 3.08, total dup: 48, max dup: 48 
    Average key length: 2.04, compression ratio: 0.50 
    Average prefix length: 0.96, average data length: 0.06 
    Clustering factor: 1, ratio: 0.02 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index AGENTS_IS_SUPPLIER (3) 
    Root page: 1504334, depth: 1, leaf buckets: 1, nodes: 50 
    Average node length: 3.08, total dup: 48, max dup: 44 
    Average key length: 2.04, compression ratio: 0.54 
    Average prefix length: 1.04, average data length: 0.06 
    Clustering factor: 1, ratio: 0.02 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index AGENTS_NAME_UNQ (1) 
    Root page: 1504332, depth: 1, leaf buckets: 1, nodes: 50 
    Average node length: 17.20, total dup: 0, max dup: 0 
    Average key length: 15.88, compression ratio: 0.92 
    Average prefix length: 1.42, average data length: 13.20 
    Clustering factor: 1, ratio: 0.02 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PK_AGENTS (0) 
    Root page: 1504331, depth: 1, leaf buckets: 1, nodes: 50 
    Average node length: 11.82, total dup: 0, max dup: 0 
    Average key length: 10.80, compression ratio: 0.83 
    Average prefix length: 1.18, average data length: 7.82 
    Clustering factor: 1, ratio: 0.02 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
BUSINESS_OPS (154) 
    Primary pointer page: 532, Index root page: 533 
    Total formats: 1, used formats: 1 
    Average record length: 108.20, total records: 20 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1235.00, compression ratio: 11.41 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 31% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 1 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index BO_UNIT_UNQ (1) 
    Root page: 1504264, depth: 1, leaf buckets: 1, nodes: 20 
    Average node length: 18.25, total dup: 0, max dup: 0 
    Average key length: 17.20, compression ratio: 1.24 
    Average prefix length: 7.05, average data length: 14.25 
    Clustering factor: 1, ratio: 0.05 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index BUSINESS_OPS_PREDICT_PRIOR (3) 
    Root page: 1504266, depth: 1, leaf buckets: 1, nodes: 20 
    Average node length: 5.40, total dup: 0, max dup: 0 
    Average key length: 4.35, compression ratio: 0.67 
    Average prefix length: 1.20, average data length: 1.70 
    Clustering factor: 1, ratio: 0.05 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index BUSINESS_OPS_RND_WGTH (2) 
    Root page: 1504265, depth: 1, leaf buckets: 1, nodes: 20 
    Average node length: 4.30, total dup: 6, max dup: 3 
    Average key length: 3.25, compression ratio: 0.72 
    Average prefix length: 1.35, average data length: 1.00 
    Clustering factor: 1, ratio: 0.05 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index RDB$1 (0) 
    Root page: 1504263, depth: 1, leaf buckets: 1, nodes: 20 
    Average node length: 5.20, total dup: 0, max dup: 0 
    Average key length: 4.15, compression ratio: 0.65 
    Average prefix length: 1.10, average data length: 1.60 
    Clustering factor: 1, ratio: 0.05 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
DOC_DATA (139) 
    Primary pointer page: 502, Index root page: 503 
    Total formats: 1, used formats: 1 
    Average record length: 47.55, total records: 7778403 
    Average version length: 48.14, total versions: 69763, 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: 55, data page slots: 89368 
    Data pages: 89368, average fill: 70% 
    Primary pages: 89367, secondary pages: 1, swept pages: 36747 
    Empty pages: 3, full pages: 70112 
    Fill distribution: 
     0 - 19% = 14 
    20 - 39% = 53 
    40 - 59% = 1826 
    60 - 79% = 87453 
    80 - 99% = 22 
 
    Index DOC_DATA_DOC_WARE_UNQ (0) 
    Root page: 1510636, depth: 3, leaf buckets: 23251, nodes: 7778403 
    Average node length: 18.90, total dup: 0, max dup: 0 
    Average key length: 15.91, compression ratio: 1.70 
    Average prefix length: 14.09, average data length: 12.91 
    Clustering factor: 1684316, ratio: 0.22 
    Fill distribution: 
         0 - 19% = 355 
        20 - 39% = 1456 
        40 - 59% = 4365 
        60 - 79% = 2463 
        80 - 99% = 14612 
 
    Index DOC_DATA_ID_DESC (1) 
    Root page: 1528140, depth: 3, leaf buckets: 13491, nodes: 7778403 
    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: 1508859, ratio: 0.19 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 1337 
        40 - 59% = 2239 
        60 - 79% = 1126 
        80 - 99% = 8788 
 
    Index FK_DOC_DATA_DOC_LIST (2) 
    Root page: 1546735, depth: 3, leaf buckets: 8333, nodes: 7778403 
    Average node length: 6.62, total dup: 5811302, max dup: 49 
    Average key length: 3.63, compression ratio: 2.48 
    Average prefix length: 7.62, average data length: 1.38 
    Clustering factor: 1501944, ratio: 0.19 
    Fill distribution: 
         0 - 19% = 128 
        20 - 39% = 786 
        40 - 59% = 1558 
        60 - 79% = 948 
        80 - 99% = 4913 
 
DOC_LIST (138) 
    Primary pointer page: 500, Index root page: 501 
    Total formats: 1, used formats: 1 
    Average record length: 56.71, total records: 2257348 
    Average version length: 58.85, total versions: 34929, max versions: 2 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 84.00, compression ratio: 1.48 
    Pointer pages: 18, data page slots: 28816 
    Data pages: 28816, average fill: 72% 
    Primary pages: 28814, secondary pages: 2, swept pages: 8817 
    Empty pages: 58, full pages: 18769 
    Fill distribution: 
     0 - 19% = 72 
    20 - 39% = 17 
    40 - 59% = 367 
    60 - 79% = 28292 
    80 - 99% = 68 
 
    Index DOC_LIST_ID_DESC (1) 
    Root page: 1541152, depth: 3, leaf buckets: 4548, nodes: 2257348 
    Average node length: 11.40, total dup: 0, max dup: 0 
    Average key length: 8.44, compression ratio: 1.07 
    Average prefix length: 3.56, average data length: 5.44 
    Clustering factor: 685570, ratio: 0.30 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 805 
        40 - 59% = 963 
        60 - 79% = 708 
        80 - 99% = 2072 
 
    Index DOC_LIST_WORKER_OPTYPE (2) 
    Root page: 1544398, depth: 3, leaf buckets: 2435, nodes: 2258842 
    Average node length: 4.97, total dup: 2257943, max dup: 20483 
    Average key length: 2.01, compression ratio: 4.48 
    Average prefix length: 8.99, average data length: 0.01 
    Clustering factor: 1270304, ratio: 0.56 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 195 
        40 - 59% = 1418 
        60 - 79% = 573 
        80 - 99% = 249 
 
    Index FK_DOC_LIST_AGENTS (3) 
    Root page: 1545933, depth: 3, leaf buckets: 1801, nodes: 2257348 
    Average node length: 4.97, total dup: 2257298, max dup: 130251 
    Average key length: 2.01, compression ratio: 4.48 
    Average prefix length: 8.99, average data length: 0.01 
    Clustering factor: 1070639, ratio: 0.47 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 0 
        40 - 59% = 663 
        60 - 79% = 53 
        80 - 99% = 1085 
 
    Index PK_DOC_LIST (0) 
    Root page: 1538209, depth: 3, leaf buckets: 4325, nodes: 2257348 
    Average node length: 11.40, total dup: 0, max dup: 0 
    Average key length: 8.44, compression ratio: 1.07 
    Average prefix length: 3.56, average data length: 5.44 
    Clustering factor: 685570, ratio: 0.30 
    Fill distribution: 
         0 - 19% = 83 
        20 - 39% = 496 
        40 - 59% = 718 
        60 - 79% = 817 
        80 - 99% = 2211 
 
DOC_STATES (149) 
    Primary pointer page: 522, Index root page: 523 
    Total formats: 1, used formats: 1 
    Average record length: 67.50, total records: 4 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 650.00, compression ratio: 9.63 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 4% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index DOC_STATES_MCODE_UNQ (1) 
    Root page: 1504337, depth: 1, leaf buckets: 1, nodes: 4 
    Average node length: 17.75, total dup: 0, max dup: 0 
    Average key length: 16.50, compression ratio: 1.08 
    Average prefix length: 4.00, average data length: 13.75 
    Clustering factor: 1, ratio: 0.25 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index DOC_STATES_NAME_UNQ (2) 
    Root page: 1504338, depth: 1, leaf buckets: 1, nodes: 4 
    Average node length: 33.25, total dup: 0, max dup: 0 
    Average key length: 32.00, compression ratio: 0.99 
    Average prefix length: 2.50, average data length: 29.25 
    Clustering factor: 1, ratio: 0.25 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PK_DOC_STATES (0) 
    Root page: 1504336, depth: 1, leaf buckets: 1, nodes: 4 
    Average node length: 4.75, total dup: 0, max dup: 0 
    Average key length: 3.50, compression ratio: 0.86 
    Average prefix length: 1.50, average data length: 1.50 
    Clustering factor: 1, ratio: 0.25 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
FB_ERRORS (155) 
    Primary pointer page: 534, Index root page: 535 
    Total formats: 2, used formats: 2 
    Average record length: 57.88, total records: 2182 
    Average version length: 79.61, total versions: 757, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 270.43, compression ratio: 4.67 
    Pointer pages: 1, data page slots: 40 
    Data pages: 40, average fill: 72% 
    Primary pages: 39, secondary pages: 1, swept pages: 0 
    Empty pages: 4, full pages: 34 
    Fill distribution: 
     0 - 19% = 5 
    20 - 39% = 0 
    40 - 59% = 1 
    60 - 79% = 22 
    80 - 99% = 12 
 
    Index FB_ERRORS_GDS_CODE (0) 
    Root page: 398, depth: 2, leaf buckets: 2, nodes: 2182 
    Average node length: 4.40, total dup: 756, max dup: 1 
    Average key length: 2.67, compression ratio: 1.87 
    Average prefix length: 4.33, average data length: 0.67 
    Clustering factor: 1518, ratio: 0.70 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 0 
        40 - 59% = 1 
        60 - 79% = 1 
        80 - 99% = 0 
 
INVNT_SALDO (145) 
    Primary pointer page: 514, Index root page: 515 
    Total formats: 2, used formats: 1 
    Average record length: 83.33, total records: 400 
    Average version length: 27.01, total versions: 4072, max versions: 11 
    Average fragment length: 2.00, total fragments: 8, max fragments: 1 
    Average unpacked length: 104.00, compression ratio: 1.25 
    Pointer pages: 1, data page slots: 40 
    Data pages: 40, average fill: 68% 
    Primary pages: 7, secondary pages: 33, swept pages: 0 
    Empty pages: 3, full pages: 28 
    Fill distribution: 
     0 - 19% = 9 
    20 - 39% = 2 
    40 - 59% = 0 
    60 - 79% = 6 
    80 - 99% = 23 
 
    Index PK_INVNT_SALDO (0) 
    Root page: 1510371, depth: 1, leaf buckets: 1, nodes: 400 
    Average node length: 11.22, total dup: 0, max dup: 0 
    Average key length: 10.22, compression ratio: 0.88 
    Average prefix length: 1.78, average data length: 7.22 
    Clustering factor: 326, ratio: 0.81 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 0 
        40 - 59% = 1 
        60 - 79% = 0 
        80 - 99% = 0 
 
INVNT_TURNOVER_LOG (153) 
    Primary pointer page: 530, Index root page: 531 
    Total formats: 1, used formats: 1 
    Average record length: 10.17, total records: 125362 
    Average version length: 68.27, total versions: 122891, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 88.00, compression ratio: 8.66 
    Pointer pages: 7, data page slots: 3240 
    Data pages: 2160, average fill: 79% 
    Primary pages: 2159, secondary pages: 1, swept pages: 0 
    Empty pages: 72, full pages: 1698 
    Fill distribution: 
     0 - 19% = 188 
    20 - 39% = 90 
    40 - 59% = 118 
    60 - 79% = 189 
    80 - 99% = 1575 
 
    Index INVNT_TURNOVER_LOG_WARE_DD_ID (0) 
    Root page: 1707341, depth: 3, leaf buckets: 396, nodes: 125362 
    Average node length: 13.15, total dup: 6849, max dup: 3 
    Average key length: 10.72, compression ratio: 2.52 
    Average prefix length: 19.22, average data length: 7.78 
    Clustering factor: 93536, ratio: 0.75 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 6 
        40 - 59% = 347 
        60 - 79% = 39 
        80 - 99% = 3 
 
MONEY_SALDO (141) 
    Primary pointer page: 506, Index root page: 507 
    Total formats: 1, used formats: 1 
    Average record length: 15.24, total records: 49 
    Average version length: 9.00, total versions: 373, max versions: 11 
    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: 16 
    Data pages: 16, average fill: 9% 
    Primary pages: 7, secondary pages: 9, swept pages: 0 
    Empty pages: 6, full pages: 1 
    Fill distribution: 
     0 - 19% = 15 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 1 
 
    Index PK_MONEY_SALDO (0) 
    Root page: 1510383, depth: 1, leaf buckets: 1, nodes: 49 
    Average node length: 11.82, total dup: 0, max dup: 0 
    Average key length: 10.80, compression ratio: 0.83 
    Average prefix length: 1.18, average data length: 7.82 
    Clustering factor: 1, ratio: 0.02 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
MONEY_TURNOVER_LOG (140) 
    Primary pointer page: 504, Index root page: 505 
    Total formats: 1, used formats: 1 
    Average record length: 10.77, total records: 1938 
    Average version length: 43.04, total versions: 1836, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 58.00, compression ratio: 5.39 
    Pointer pages: 1, data page slots: 32 
    Data pages: 32, average fill: 64% 
    Primary pages: 31, secondary pages: 1, swept pages: 0 
    Empty pages: 1, full pages: 15 
    Fill distribution: 
     0 - 19% = 4 
    20 - 39% = 4 
    40 - 59% = 4 
    60 - 79% = 6 
    80 - 99% = 14 
 
    Index MONEY_TURNOVER_LOG_AGENT_OPTYPE (0) 
    Root page: 92114, depth: 2, leaf buckets: 4, nodes: 1938 
    Average node length: 4.23, total dup: 1840, max dup: 156 
    Average key length: 2.55, compression ratio: 7.44 
    Average prefix length: 18.50, average data length: 0.50 
    Clustering factor: 1119, ratio: 0.58 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 3 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
MON_CACHE_MEMORY (165) 
    Primary pointer page: 555, Index root page: 556 
    Total formats: 2, used formats: 1 
    Average record length: 97.67, total records: 73 
    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: 51% 
    Primary pages: 2, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 1 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 1 
    40 - 59% = 0 
    60 - 79% = 1 
    80 - 99% = 0 
 
    Index PK_MON_CACHE_MEMORY (0) 
    Root page: 1504238, depth: 1, leaf buckets: 1, nodes: 73 
    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: 548, Index root page: 549 
    Total formats: 2, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index MON_LOG_DTS (4) 
    Root page: 1504251, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index MON_LOG_GDSCODE (2) 
    Root page: 1504249, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index MON_LOG_ROWSET_DESC (1) 
    Root page: 1504248, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index MON_LOG_UNIT (3) 
    Root page: 1504250, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PK_MON_LOG (0) 
    Root page: 1504247, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
MON_LOG_TABLE_STATS (163) 
    Primary pointer page: 550, Index root page: 551 
    Total formats: 2, used formats: 1 
    Average record length: 67.13, total records: 30 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 611.00, compression ratio: 9.10 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 31% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 1 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index MON_LOG_TABLE_STATS_DTS (4) 
    Root page: 1504246, depth: 1, leaf buckets: 1, nodes: 30 
    Average node length: 3.50, total dup: 23, max dup: 4 
    Average key length: 2.47, compression ratio: 3.24 
    Average prefix length: 7.53, average data length: 0.47 
    Clustering factor: 1, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index MON_LOG_TABLE_STATS_GDSCODE (2) 
    Root page: 1504244, depth: 1, leaf buckets: 1, nodes: 30 
    Average node length: 2.00, total dup: 29, max dup: 29 
    Average key length: 1.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 1, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index MON_LOG_TABLE_STATS_ROWSET (1) 
    Root page: 1504243, depth: 1, leaf buckets: 1, nodes: 30 
    Average node length: 3.33, total dup: 29, max dup: 29 
    Average key length: 2.30, compression ratio: 3.91 
    Average prefix length: 8.70, average data length: 0.30 
    Clustering factor: 1, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index MON_LOG_TABLE_STATS_TN_UNIT (3) 
    Root page: 1504245, depth: 1, leaf buckets: 1, nodes: 30 
    Average node length: 12.90, total dup: 0, max dup: 0 
    Average key length: 11.87, compression ratio: 1.42 
    Average prefix length: 7.63, average data length: 9.20 
    Clustering factor: 1, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PK_MON_LOG_TABLE_STATS (0) 
    Root page: 1504242, depth: 1, leaf buckets: 1, nodes: 30 
    Average node length: 8.37, total dup: 0, max dup: 0 
    Average key length: 7.33, compression ratio: 1.23 
    Average prefix length: 4.63, average data length: 4.37 
    Clustering factor: 1, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
OPTYPES (136) 
    Primary pointer page: 496, Index root page: 497 
    Total formats: 2, used formats: 1 
    Average record length: 67.56, total records: 9 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 386.00, compression ratio: 5.71 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 9% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index OPTYPES_MCODE_UNQ (1) 
    Root page: 1544827, depth: 1, leaf buckets: 1, nodes: 9 
    Average node length: 8.56, total dup: 0, max dup: 0 
    Average key length: 6.89, compression ratio: 0.73 
    Average prefix length: 0.44, average data length: 4.56 
    Clustering factor: 1, ratio: 0.11 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PK_OPTYPES (0) 
    Root page: 1544826, depth: 1, leaf buckets: 1, nodes: 9 
    Average node length: 6.11, total dup: 0, max dup: 0 
    Average key length: 5.00, compression ratio: 0.60 
    Average prefix length: 0.89, average data length: 2.11 
    Clustering factor: 1, ratio: 0.11 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
PDISTR (146) 
    Primary pointer page: 516, Index root page: 517 
    Total formats: 1, used formats: 1 
    Average record length: 35.77, total records: 805481 
    Average version length: 37.93, total versions: 39865, max versions: 2 
    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: 8528 
    Data pages: 8528, average fill: 65% 
    Primary pages: 8525, secondary pages: 3, swept pages: 1417 
    Empty pages: 20, full pages: 5636 
    Fill distribution: 
     0 - 19% = 41 
    20 - 39% = 75 
    40 - 59% = 772 
    60 - 79% = 7563 
    80 - 99% = 77 
 
    Index PDISTR_AGENT_ID (2) 
    Root page: 1509330, depth: 2, leaf buckets: 860, nodes: 786336 
    Average node length: 4.88, total dup: 786287, max dup: 142299 
    Average key length: 2.01, compression ratio: 4.48 
    Average prefix length: 8.99, average data length: 0.01 
    Clustering factor: 89851, ratio: 0.11 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 133 
        40 - 59% = 475 
        60 - 79% = 154 
        80 - 99% = 98 
 
    Index PDISTR_SNDOP_RCVOP_SNDID_ASC (0) 
    Root page: 1508635, depth: 3, leaf buckets: 928, nodes: 786336 
    Average node length: 5.89, total dup: 699962, max dup: 42 
    Average key length: 3.02, compression ratio: 7.29 
    Average prefix length: 21.09, average data length: 0.91 
    Clustering factor: 157724, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 80 
        40 - 59% = 466 
        60 - 79% = 89 
        80 - 99% = 293 
 
    Index PDISTR_SNDOP_RCVOP_SNDID_DESC (1) 
    Root page: 1509209, depth: 3, leaf buckets: 950, nodes: 786336 
    Average node length: 5.89, total dup: 699962, max dup: 42 
    Average key length: 3.02, compression ratio: 7.28 
    Average prefix length: 21.09, average data length: 0.91 
    Clustering factor: 159635, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 119 
        40 - 59% = 445 
        60 - 79% = 95 
        80 - 99% = 290 
 
    Index PDISTR_WORKER_SND_ID (3) 
    Root page: 1510200, depth: 3, leaf buckets: 1144, nodes: 786336 
    Average node length: 5.97, total dup: 699962, max dup: 42 
    Average key length: 3.10, compression ratio: 5.48 
    Average prefix length: 16.01, average data length: 0.99 
    Clustering factor: 152365, ratio: 0.19 
    Fill distribution: 
         0 - 19% = 4 
        20 - 39% = 258 
        40 - 59% = 631 
        60 - 79% = 166 
        80 - 99% = 85 
 
PERF_AGG (158) 
    Primary pointer page: 540, Index root page: 541 
    Total formats: 1, used formats: 1 
    Average record length: 62.77, total records: 5431 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 3.89, total fragments: 18, max fragments: 1 
    Average unpacked length: 379.00, compression ratio: 6.04 
    Pointer pages: 1, data page slots: 96 
    Data pages: 95, average fill: 56% 
    Primary pages: 78, secondary pages: 17, swept pages: 54 
    Empty pages: 16, full pages: 57 
    Fill distribution: 
     0 - 19% = 21 
    20 - 39% = 1 
    40 - 59% = 1 
    60 - 79% = 72 
    80 - 99% = 0 
 
    Index PERF_AGG_UNQ (1) 
    Root page: 1504260, depth: 2, leaf buckets: 6, nodes: 5431 
    Average node length: 5.50, total dup: 0, max dup: 0 
    Average key length: 3.58, compression ratio: 10.03 
    Average prefix length: 34.35, average data length: 1.55 
    Clustering factor: 5185, ratio: 0.95 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 0 
        40 - 59% = 4 
        60 - 79% = 1 
        80 - 99% = 1 
 
    Index PK_PERF_AGG (0) 
    Root page: 1504255, depth: 2, leaf buckets: 10, nodes: 5431 
    Average node length: 11.13, total dup: 0, max dup: 0 
    Average key length: 9.21, compression ratio: 0.98 
    Average prefix length: 2.79, average data length: 6.21 
    Clustering factor: 166, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 1 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 7 
 
PERF_ESTIMATED (280) 
    Primary pointer page: 399, Index root page: 434 
    Total formats: 1, used formats: 1 
    Average record length: 39.08, total records: 79655 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 48.00, compression ratio: 1.23 
    Pointer pages: 1, data page slots: 832 
    Data pages: 832, average fill: 66% 
    Primary pages: 832, secondary pages: 0, swept pages: 0 
    Empty pages: 4, full pages: 827 
    Fill distribution: 
     0 - 19% = 4 
    20 - 39% = 0 
    40 - 59% = 1 
    60 - 79% = 827 
    80 - 99% = 0 
 
    Index PK_PERF_ESTIMATED (0) 
    Root page: 38792, depth: 2, leaf buckets: 104, nodes: 79655 
    Average node length: 10.15, total dup: 0, max dup: 0 
    Average key length: 8.16, compression ratio: 1.10 
    Average prefix length: 3.84, average data length: 5.16 
    Clustering factor: 3174, ratio: 0.04 
    Fill distribution: 
         0 - 19% = 3 
        20 - 39% = 1 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 100 
 
PERF_ISQL_STAT (156) 
    Primary pointer page: 536, Index root page: 537 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index PERF_ISQL_STAT_TRN (0) 
    Root page: 1504261, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
PERF_LOG (159) 
    Primary pointer page: 542, Index root page: 543 
    Total formats: 1, used formats: 1 
    Average record length: 111.17, total records: 71 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1691.00, compression ratio: 15.21 
    Pointer pages: 1, data page slots: 2 
    Data pages: 2, average fill: 56% 
    Primary pages: 2, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 1 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 1 
    40 - 59% = 0 
    60 - 79% = 1 
    80 - 99% = 0 
 
PERF_SPLIT_0 (281) 
    Primary pointer page: 601, Index root page: 602 
    Total formats: 1, used formats: 1 
    Average record length: 145.83, total records: 180969 
    Average version length: 153.29, total versions: 6961, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.63 
    Pointer pages: 7, data page slots: 6256 
    Data pages: 4552, average fill: 82% 
    Primary pages: 4551, secondary pages: 1, swept pages: 3 
    Empty pages: 77, full pages: 4426 
    Fill distribution: 
     0 - 19% = 81 
    20 - 39% = 15 
    40 - 59% = 20 
    60 - 79% = 10 
    80 - 99% = 4426 
 
PERF_SPLIT_1 (282) 
    Primary pointer page: 603, Index root page: 604 
    Total formats: 1, used formats: 1 
    Average record length: 145.42, total records: 153050 
    Average version length: 151.05, total versions: 5826, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.66 
    Pointer pages: 7, data page slots: 4264 
    Data pages: 3792, average fill: 83% 
    Primary pages: 3790, secondary pages: 2, swept pages: 4 
    Empty pages: 34, full pages: 3746 
    Fill distribution: 
     0 - 19% = 39 
    20 - 39% = 3 
    40 - 59% = 3 
    60 - 79% = 0 
    80 - 99% = 3747 
 
PERF_SPLIT_2 (283) 
    Primary pointer page: 605, Index root page: 606 
    Total formats: 1, used formats: 1 
    Average record length: 144.41, total records: 160624 
    Average version length: 151.68, total versions: 7159, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.74 
    Pointer pages: 7, data page slots: 4600 
    Data pages: 3992, average fill: 83% 
    Primary pages: 3989, secondary pages: 3, swept pages: 1 
    Empty pages: 46, full pages: 3928 
    Fill distribution: 
     0 - 19% = 49 
    20 - 39% = 5 
    40 - 59% = 7 
    60 - 79% = 3 
    80 - 99% = 3928 
 
PERF_SPLIT_3 (284) 
    Primary pointer page: 607, Index root page: 616 
    Total formats: 1, used formats: 1 
    Average record length: 146.07, total records: 187982 
    Average version length: 152.00, total versions: 6958, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.61 
    Pointer pages: 8, data page slots: 5072 
    Data pages: 4640, average fill: 84% 
    Primary pages: 4638, secondary pages: 2, swept pages: 1 
    Empty pages: 13, full pages: 4618 
    Fill distribution: 
     0 - 19% = 16 
    20 - 39% = 1 
    40 - 59% = 3 
    60 - 79% = 2 
    80 - 99% = 4618 
 
PERF_SPLIT_4 (285) 
    Primary pointer page: 617, Index root page: 618 
    Total formats: 1, used formats: 1 
    Average record length: 146.89, total records: 164259 
    Average version length: 151.43, total versions: 4796, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.55 
    Pointer pages: 10, data page slots: 4888 
    Data pages: 4088, average fill: 83% 
    Primary pages: 4086, secondary pages: 2, swept pages: 9 
    Empty pages: 46, full pages: 4024 
    Fill distribution: 
     0 - 19% = 49 
    20 - 39% = 5 
    40 - 59% = 5 
    60 - 79% = 5 
    80 - 99% = 4024 
 
PERF_SPLIT_5 (286) 
    Primary pointer page: 619, Index root page: 620 
    Total formats: 1, used formats: 1 
    Average record length: 145.13, total records: 159451 
    Average version length: 152.44, total versions: 6513, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.69 
    Pointer pages: 5, data page slots: 6104 
    Data pages: 3984, average fill: 83% 
    Primary pages: 3981, secondary pages: 3, swept pages: 3 
    Empty pages: 59, full pages: 3903 
    Fill distribution: 
     0 - 19% = 62 
    20 - 39% = 8 
    40 - 59% = 4 
    60 - 79% = 6 
    80 - 99% = 3904 
 
PERF_SPLIT_6 (287) 
    Primary pointer page: 621, Index root page: 622 
    Total formats: 1, used formats: 1 
    Average record length: 146.56, total records: 171575 
    Average version length: 151.36, total versions: 5587, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.57 
    Pointer pages: 8, data page slots: 5904 
    Data pages: 4280, average fill: 83% 
    Primary pages: 4278, secondary pages: 2, swept pages: 1 
    Empty pages: 57, full pages: 4207 
    Fill distribution: 
     0 - 19% = 58 
    20 - 39% = 8 
    40 - 59% = 3 
    60 - 79% = 5 
    80 - 99% = 4206 
 
PERF_SPLIT_7 (288) 
    Primary pointer page: 626, Index root page: 627 
    Total formats: 1, used formats: 1 
    Average record length: 145.59, total records: 158743 
    Average version length: 152.13, total versions: 6078, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.65 
    Pointer pages: 6, data page slots: 4696 
    Data pages: 3944, average fill: 83% 
    Primary pages: 3942, secondary pages: 2, swept pages: 9 
    Empty pages: 37, full pages: 3890 
    Fill distribution: 
     0 - 19% = 38 
    20 - 39% = 6 
    40 - 59% = 4 
    60 - 79% = 9 
    80 - 99% = 3887 
 
PERF_SPLIT_8 (289) 
    Primary pointer page: 628, Index root page: 629 
    Total formats: 1, used formats: 1 
    Average record length: 142.76, total records: 152399 
    Average version length: 151.96, total versions: 8638, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.88 
    Pointer pages: 7, data page slots: 5744 
    Data pages: 3792, average fill: 83% 
    Primary pages: 3788, secondary pages: 4, swept pages: 2 
    Empty pages: 47, full pages: 3729 
    Fill distribution: 
     0 - 19% = 50 
    20 - 39% = 5 
    40 - 59% = 2 
    60 - 79% = 4 
    80 - 99% = 3731 
 
PERF_SPLIT_9 (290) 
    Primary pointer page: 630, Index root page: 631 
    Total formats: 1, used formats: 1 
    Average record length: 142.40, total records: 165064 
    Average version length: 152.70, total versions: 9770, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.91 
    Pointer pages: 6, data page slots: 4728 
    Data pages: 4064, average fill: 84% 
    Primary pages: 4063, secondary pages: 1, swept pages: 1 
    Empty pages: 11, full pages: 4043 
    Fill distribution: 
     0 - 19% = 13 
    20 - 39% = 3 
    40 - 59% = 1 
    60 - 79% = 4 
    80 - 99% = 4043 
 
PHRASES (143) 
    Primary pointer page: 510, Index root page: 511 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index PHRASES_ID_DESC (3) 
    Root page: 1510376, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PHRASES_NAME (2) 
    Root page: 1510375, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PHRASES_UNQ (1) 
    Root page: 1510374, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PK_PHRASES (0) 
    Root page: 1510373, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
PSTORNED (147) 
    Primary pointer page: 518, Index root page: 519 
    Total formats: 1, used formats: 1 
    Average record length: 52.10, total records: 2116300 
    Average version length: 52.91, total versions: 31056, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 70.00, compression ratio: 1.34 
    Pointer pages: 16, data page slots: 25744 
    Data pages: 25744, average fill: 71% 
    Primary pages: 25726, secondary pages: 18, swept pages: 10254 
    Empty pages: 93, full pages: 22955 
    Fill distribution: 
     0 - 19% = 196 
    20 - 39% = 189 
    40 - 59% = 654 
    60 - 79% = 24424 
    80 - 99% = 281 
 
    Index PSTORNED_RCV_ID (1) 
    Root page: 1506208, depth: 3, leaf buckets: 2592, nodes: 2116300 
    Average node length: 5.44, total dup: 1975194, max dup: 1889 
    Average key length: 2.49, compression ratio: 3.62 
    Average prefix length: 8.58, average data length: 0.42 
    Clustering factor: 183097, ratio: 0.09 
    Fill distribution: 
         0 - 19% = 7 
        20 - 39% = 294 
        40 - 59% = 1670 
        60 - 79% = 320 
        80 - 99% = 301 
 
    Index PSTORNED_SND_ID (0) 
    Root page: 1504841, depth: 3, leaf buckets: 2757, nodes: 2116300 
    Average node length: 5.69, total dup: 1899824, max dup: 64 
    Average key length: 2.74, compression ratio: 3.29 
    Average prefix length: 8.36, average data length: 0.64 
    Clustering factor: 378385, ratio: 0.18 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 3 
        40 - 59% = 2388 
        60 - 79% = 339 
        80 - 99% = 27 
 
    Index PSTORNED_WORKER_ID (2) 
    Root page: 1508018, depth: 3, leaf buckets: 2110, nodes: 2116300 
    Average node length: 4.96, total dup: 2116200, max dup: 28447 
    Average key length: 2.00, compression ratio: 1.20 
    Average prefix length: 2.40, average data length: 0.00 
    Clustering factor: 180939, ratio: 0.09 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 200 
        40 - 59% = 1042 
        60 - 79% = 401 
        80 - 99% = 466 
 
RULES_FOR_PDISTR (148) 
    Primary pointer page: 520, Index root page: 521 
    Total formats: 1, used formats: 1 
    Average record length: 17.00, total records: 4 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 334.00, compression ratio: 19.65 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 2% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index RULES_FOR_PDISTR_UNQ (0) 
    Root page: 1504339, depth: 1, leaf buckets: 1, nodes: 4 
    Average node length: 11.50, total dup: 0, max dup: 0 
    Average key length: 10.25, compression ratio: 0.88 
    Average prefix length: 1.50, average data length: 7.50 
    Clustering factor: 1, ratio: 0.25 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
RULES_FOR_QDISTR (137) 
    Primary pointer page: 498, Index root page: 499 
    Total formats: 1, used formats: 1 
    Average record length: 32.71, total records: 7 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 332.00, compression ratio: 10.15 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 4% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index RULES_FOR_QDISTR_RCVOP (1) 
    Root page: 1544825, depth: 1, leaf buckets: 1, nodes: 7 
    Average node length: 5.29, total dup: 2, max dup: 2 
    Average key length: 4.14, compression ratio: 0.72 
    Average prefix length: 1.43, average data length: 1.57 
    Clustering factor: 1, ratio: 0.14 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index RULES_FOR_QDISTR_UNQ (0) 
    Root page: 1544824, depth: 1, leaf buckets: 1, nodes: 7 
    Average node length: 10.14, total dup: 0, max dup: 0 
    Average key length: 8.86, compression ratio: 0.94 
    Average prefix length: 2.14, average data length: 6.14 
    Clustering factor: 1, ratio: 0.14 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
SEMAPHORES (152) 
    Primary pointer page: 528, Index root page: 529 
    Total formats: 1, used formats: 1 
    Average record length: 43.40, total records: 5 
    Average version length: 9.00, total versions: 1, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 346.00, compression ratio: 7.97 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 4% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index PK_SEMAPHORES (0) 
    Root page: 1504327, depth: 1, leaf buckets: 1, nodes: 5 
    Average node length: 12.40, total dup: 0, max dup: 0 
    Average key length: 11.00, compression ratio: 0.82 
    Average prefix length: 0.60, average data length: 8.40 
    Clustering factor: 1, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index SEMAPHORES_TASK_UNQ (1) 
    Root page: 1504328, depth: 1, leaf buckets: 1, nodes: 5 
    Average node length: 23.40, total dup: 0, max dup: 0 
    Average key length: 22.00, compression ratio: 1.07 
    Average prefix length: 4.20, average data length: 19.40 
    Clustering factor: 1, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
SETTINGS (135) 
    Primary pointer page: 494, Index root page: 495 
    Total formats: 1, used formats: 1 
    Average record length: 97.62, total records: 149 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1347.00, compression ratio: 13.80 
    Pointer pages: 1, data page slots: 3 
    Data pages: 3, average fill: 70% 
    Primary pages: 3, secondary pages: 0, swept pages: 2 
    Empty pages: 0, full pages: 2 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 1 
    60 - 79% = 0 
    80 - 99% = 2 
 
    Index SETTINGS_MCODE_WM_UNQ (1) 
    Root page: 1544931, depth: 1, leaf buckets: 1, nodes: 149 
    Average node length: 14.66, total dup: 0, max dup: 0 
    Average key length: 13.55, compression ratio: 2.19 
    Average prefix length: 19.07, average data length: 10.66 
    Clustering factor: 48, ratio: 0.32 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 1 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index SETTINGS_MODE_CODE (0) 
    Root page: 1544828, depth: 1, leaf buckets: 1, nodes: 149 
    Average node length: 25.56, total dup: 0, max dup: 0 
    Average key length: 24.56, compression ratio: 1.63 
    Average prefix length: 18.58, average data length: 21.56 
    Clustering factor: 14, ratio: 0.09 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 0 
        40 - 59% = 1 
        60 - 79% = 0 
        80 - 99% = 0 
 
TMP$DEP_DOCS (129) 
    Primary pointer page: 482, Index root page: 483 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index TMP_DEP_DOCS_UNQ (0) 
    Root page: 1544832, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
TMP$IDX_RECALC (132) 
    Primary pointer page: 488, Index root page: 489 
    Total formats: 2, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index TMP_IDX_RECALC_IDX_NAME_UNQ (0) 
    Root page: 1544829, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
TMP$MON_LOG (133) 
    Primary pointer page: 490, Index root page: 491 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
TMP$MON_LOG_TABLE_STATS (134) 
    Primary pointer page: 492, Index root page: 493 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
TMP$PERF_EST_WHOLE (161) 
    Primary pointer page: 546, Index root page: 547 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
TMP$PERF_LOG (160) 
    Primary pointer page: 544, Index root page: 545 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index TMP$PERF_LOG_UNIT_TRN_DTS_END (0) 
    Root page: 1504252, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
TMP$PERF_MON (131) 
    Primary pointer page: 486, Index root page: 487 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
TMP$RESULT_SET (130) 
    Primary pointer page: 484, Index root page: 485 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index TMP_RESULT_SET_DOC (1) 
    Root page: 1544831, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index TMP_RESULT_SET_WARE_DOC (0) 
    Root page: 1544830, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
TMP$SHOPPING_CART (128) 
    Primary pointer page: 480, Index root page: 481 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index TMP_SHOPCART_UNQ (0) 
    Root page: 1544833, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
TPAUSE (166) 
    Primary pointer page: 557, Index root page: 558 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index RDB$PRIMARY2 (0) 
    Root page: 1504237, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
TRACE_STAT (157) 
    Primary pointer page: 538, Index root page: 539 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
WARES (142) 
    Primary pointer page: 508, Index root page: 509 
    Total formats: 1, used formats: 1 
    Average record length: 77.52, total records: 400 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 444.00, compression ratio: 5.73 
    Pointer pages: 1, data page slots: 6 
    Data pages: 6, average fill: 77% 
    Primary pages: 6, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 5 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 5 
    80 - 99% = 1 
 
    Index FK_WARES_WARE_GROUPS (3) 
    Root page: 1552183, depth: 1, leaf buckets: 1, nodes: 400 
    Average node length: 3.17, total dup: 392, max dup: 60 
    Average key length: 2.16, compression ratio: 4.16 
    Average prefix length: 8.86, average data length: 0.14 
    Clustering factor: 48, ratio: 0.12 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PK_WARES (0) 
    Root page: 1510377, depth: 1, leaf buckets: 1, nodes: 400 
    Average node length: 11.22, total dup: 0, max dup: 0 
    Average key length: 10.22, compression ratio: 0.88 
    Average prefix length: 1.78, average data length: 7.22 
    Clustering factor: 344, ratio: 0.86 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 0 
        40 - 59% = 1 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index WARES_ID_DESC (2) 
    Root page: 1510382, depth: 1, leaf buckets: 1, nodes: 400 
    Average node length: 11.22, total dup: 0, max dup: 0 
    Average key length: 10.22, compression ratio: 0.88 
    Average prefix length: 1.78, average data length: 7.22 
    Clustering factor: 344, ratio: 0.86 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 0 
        40 - 59% = 1 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index WARES_NUMB_UNQ (1) 
    Root page: 1510380, depth: 2, leaf buckets: 3, nodes: 400 
    Average node length: 53.25, total dup: 0, max dup: 0 
    Average key length: 52.23, compression ratio: 1.00 
    Average prefix length: 2.74, average data length: 49.25 
    Clustering factor: 355, ratio: 0.89 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 1 
        80 - 99% = 2 
 
WARE_GROUPS (151) 
    Primary pointer page: 526, Index root page: 527 
    Total formats: 1, used formats: 1 
    Average record length: 32.12, total records: 8 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 346.00, compression ratio: 10.77 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 5% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index PK_WARE_GROUPS (0) 
    Root page: 1504329, depth: 1, leaf buckets: 1, nodes: 8 
    Average node length: 11.25, total dup: 0, max dup: 0 
    Average key length: 10.12, compression ratio: 0.89 
    Average prefix length: 1.75, average data length: 7.25 
    Clustering factor: 1, ratio: 0.12 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index WARE_GROUPS_NAME_UNQ (1) 
    Root page: 1504330, depth: 1, leaf buckets: 1, nodes: 8 
    Average node length: 19.88, total dup: 0, max dup: 0 
    Average key length: 18.12, compression ratio: 0.89 
    Average prefix length: 0.25, average data length: 15.88 
    Clustering factor: 1, ratio: 0.12 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
XQD_1000_1200 (176) 
    Primary pointer page: 577, Index root page: 578 
    Total formats: 1, used formats: 1 
    Average record length: 38.44, total records: 145967 
    Average version length: 69.18, total versions: 74618, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 3.28 
    Pointer pages: 3, data page slots: 4040 
    Data pages: 3168, average fill: 57% 
    Primary pages: 3168, secondary pages: 0, swept pages: 346 
    Empty pages: 477, full pages: 1684 
    Fill distribution: 
     0 - 19% = 673 
    20 - 39% = 292 
    40 - 59% = 322 
    60 - 79% = 719 
    80 - 99% = 1162 
 
    Index XQD_1000_1200_WA_SO_RO_WKR_SND (0) 
    Root page: 1556321, depth: 3, leaf buckets: 239, nodes: 145967 
    Average node length: 6.43, total dup: 127145, max dup: 14 
    Average key length: 3.94, compression ratio: 10.67 
    Average prefix length: 40.19, average data length: 1.81 
    Clustering factor: 25541, ratio: 0.17 
    Fill distribution: 
         0 - 19% = 3 
        20 - 39% = 65 
        40 - 59% = 108 
        60 - 79% = 59 
        80 - 99% = 4 
 
XQD_1000_3300 (178) 
    Primary pointer page: 581, Index root page: 582 
    Total formats: 1, used formats: 1 
    Average record length: 65.32, total records: 6960390 
    Average version length: 68.79, total versions: 422506, 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: 65, data page slots: 105744 
    Data pages: 105744, average fill: 71% 
    Primary pages: 105743, secondary pages: 1, swept pages: 19031 
    Empty pages: 3, full pages: 62343 
    Fill distribution: 
     0 - 19% = 36 
    20 - 39% = 515 
    40 - 59% = 8297 
    60 - 79% = 95622 
    80 - 99% = 1274 
 
    Index XQD_1000_3300_WA_SO_RO_WKR_SND (0) 
    Root page: 1480476, depth: 3, leaf buckets: 10629, nodes: 6960390 
    Average node length: 6.52, total dup: 6018475, max dup: 29 
    Average key length: 3.52, compression ratio: 11.92 
    Average prefix length: 40.61, average data length: 1.39 
    Clustering factor: 1645523, ratio: 0.24 
    Fill distribution: 
         0 - 19% = 7 
        20 - 39% = 1777 
        40 - 59% = 5705 
        60 - 79% = 2697 
        80 - 99% = 443 
 
    Index XQD_1000_3300_WKR_DOC_ASC (1) 
    Root page: 1486090, depth: 3, leaf buckets: 8479, nodes: 6960390 
    Average node length: 5.40, total dup: 6679842, max dup: 174 
    Average key length: 2.41, compression ratio: 7.05 
    Average prefix length: 16.63, average data length: 0.37 
    Clustering factor: 1452964, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 10 
        20 - 39% = 1185 
        40 - 59% = 4797 
        60 - 79% = 1461 
        80 - 99% = 1026 
 
    Index XQD_1000_3300_WKR_DOC_DEC (2) 
    Root page: 1490630, depth: 3, leaf buckets: 8559, nodes: 6960390 
    Average node length: 5.40, total dup: 6679842, max dup: 174 
    Average key length: 2.41, compression ratio: 7.05 
    Average prefix length: 16.63, average data length: 0.37 
    Clustering factor: 1455290, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 5 
        20 - 39% = 1269 
        40 - 59% = 4816 
        60 - 79% = 1477 
        80 - 99% = 992 
 
XQD_1200_2000 (177) 
    Primary pointer page: 579, Index root page: 580 
    Total formats: 1, used formats: 1 
    Average record length: 67.19, total records: 11847247 
    Average version length: 68.79, total versions: 346206, 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: 106, data page slots: 172776 
    Data pages: 172776, average fill: 73% 
    Primary pages: 172776, secondary pages: 0, swept pages: 64946 
    Empty pages: 8, full pages: 143532 
    Fill distribution: 
     0 - 19% = 49 
    20 - 39% = 571 
    40 - 59% = 6072 
    60 - 79% = 164158 
    80 - 99% = 1926 
 
    Index XQD_1200_2000_WA_SO_RO_WKR_SND (0) 
    Root page: 1495050, depth: 3, leaf buckets: 18308, nodes: 11845141 
    Average node length: 6.60, total dup: 10323152, max dup: 54 
    Average key length: 3.43, compression ratio: 12.25 
    Average prefix length: 40.70, average data length: 1.30 
    Clustering factor: 2447984, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 32 
        20 - 39% = 2501 
        40 - 59% = 10839 
        60 - 79% = 4191 
        80 - 99% = 745 
 
XQD_2000_3300 (179) 
    Primary pointer page: 583, Index root page: 584 
    Total formats: 1, used formats: 1 
    Average record length: 49.84, total records: 1670066 
    Average version length: 69.06, total versions: 366633, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 2.53 
    Pointer pages: 28, data page slots: 43776 
    Data pages: 30584, average fill: 58% 
    Primary pages: 30508, secondary pages: 76, swept pages: 6982 
    Empty pages: 2641, full pages: 19443 
    Fill distribution: 
     0 - 19% = 4418 
    20 - 39% = 3775 
    40 - 59% = 3102 
    60 - 79% = 14474 
    80 - 99% = 4815 
 
    Index XQD_2000_3300_WA_SO_RO_WKR_SND (0) 
    Root page: 1479735, depth: 3, leaf buckets: 1997, nodes: 1500320 
    Average node length: 5.51, total dup: 1439718, max dup: 49 
    Average key length: 2.56, compression ratio: 16.41 
    Average prefix length: 41.48, average data length: 0.52 
    Clustering factor: 105857, ratio: 0.07 
    Fill distribution: 
         0 - 19% = 16 
        20 - 39% = 418 
        40 - 59% = 979 
        60 - 79% = 488 
        80 - 99% = 96 
 
XQD_2100_3300 (180) 
    Primary pointer page: 585, Index root page: 586 
    Total formats: 1, used formats: 1 
    Average record length: 38.88, total records: 1200755 
    Average version length: 69.04, total versions: 149437, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 3.24 
    Pointer pages: 22, data page slots: 34776 
    Data pages: 28960, average fill: 35% 
    Primary pages: 28958, secondary pages: 2, swept pages: 7007 
    Empty pages: 6669, full pages: 8710 
    Fill distribution: 
     0 - 19% = 10267 
    20 - 39% = 4586 
    40 - 59% = 7254 
    60 - 79% = 6588 
    80 - 99% = 265 
 
    Index XQD_2100_3300_WA_SO_RO_WKR_SND (0) 
    Root page: 1479229, depth: 3, leaf buckets: 1177, nodes: 747485 
    Average node length: 5.93, total dup: 689204, max dup: 63 
    Average key length: 3.00, compression ratio: 14.00 
    Average prefix length: 41.08, average data length: 0.92 
    Clustering factor: 106176, ratio: 0.14 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 395 
        40 - 59% = 556 
        60 - 79% = 219 
        80 - 99% = 5 
 
XQD_3300_3400 (181) 
    Primary pointer page: 587, Index root page: 588 
    Total formats: 1, used formats: 1 
    Average record length: 66.67, total records: 9261667 
    Average version length: 68.97, total versions: 338840, 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: 87, data page slots: 141200 
    Data pages: 141184, average fill: 70% 
    Primary pages: 141172, secondary pages: 12, swept pages: 44056 
    Empty pages: 185, full pages: 86198 
    Fill distribution: 
     0 - 19% = 504 
    20 - 39% = 2245 
    40 - 59% = 13404 
    60 - 79% = 123122 
    80 - 99% = 1909 
 
    Index XQD_3300_3400_WA_SO_RO_WKR_SND (0) 
    Root page: 1472612, depth: 3, leaf buckets: 13480, nodes: 9256325 
    Average node length: 6.67, total dup: 7677969, max dup: 14 
    Average key length: 3.67, compression ratio: 11.45 
    Average prefix length: 40.50, average data length: 1.50 
    Clustering factor: 2124476, ratio: 0.23 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 1172 
        40 - 59% = 6921 
        60 - 79% = 4699 
        80 - 99% = 686 
 
XQS_1000_1200 (182) 
    Primary pointer page: 589, Index root page: 590 
    Total formats: 1, used formats: 1 
    Average record length: 82.50, total records: 21152591 
    Average version length: 82.84, total versions: 11618, 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: 319832 
    Data pages: 319832, average fill: 81% 
    Primary pages: 319827, secondary pages: 5, swept pages: 12976 
    Empty pages: 39, full pages: 319159 
    Fill distribution: 
     0 - 19% = 57 
    20 - 39% = 31 
    40 - 59% = 87 
    60 - 79% = 49024 
    80 - 99% = 270633 
 
    Index XQS_1000_1200_DOC_ID (1) 
    Root page: 1426738, depth: 3, leaf buckets: 19206, nodes: 21152591 
    Average node length: 5.72, total dup: 20671610, max dup: 129 
    Average key length: 2.16, compression ratio: 4.16 
    Average prefix length: 8.86, average data length: 0.14 
    Clustering factor: 3282430, ratio: 0.16 
    Fill distribution: 
         0 - 19% = 5 
        20 - 39% = 2 
        40 - 59% = 7779 
        60 - 79% = 544 
        80 - 99% = 10876 
 
    Index XQS_1000_1200_RCV_ID (3) 
    Root page: 1457002, depth: 3, leaf buckets: 17183, nodes: 21152591 
    Average node length: 6.31, total dup: 18587915, max dup: 49 
    Average key length: 2.75, compression ratio: 3.27 
    Average prefix length: 8.37, average data length: 0.63 
    Clustering factor: 916815, ratio: 0.04 
    Fill distribution: 
         0 - 19% = 6 
        20 - 39% = 5 
        40 - 59% = 781 
        60 - 79% = 283 
        80 - 99% = 16108 
 
    Index XQS_1000_1200_SND_ID (2) 
    Root page: 1441095, depth: 3, leaf buckets: 20930, nodes: 21152591 
    Average node length: 6.35, total dup: 18508094, max dup: 29 
    Average key length: 2.79, compression ratio: 3.23 
    Average prefix length: 8.34, average data length: 0.66 
    Clustering factor: 3577473, ratio: 0.17 
    Fill distribution: 
         0 - 19% = 4 
        20 - 39% = 1 
        40 - 59% = 7913 
        60 - 79% = 624 
        80 - 99% = 12388 
 
    Index XQS_1000_1200_WORKER_ID (0) 
    Root page: 1413370, depth: 3, leaf buckets: 16047, nodes: 21152591 
    Average node length: 5.56, total dup: 21152491, max dup: 230084 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.42, average data length: 0.00 
    Clustering factor: 945589, ratio: 0.04 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 5 
        40 - 59% = 2828 
        60 - 79% = 330 
        80 - 99% = 12884 
 
XQS_1000_3300 (184) 
    Primary pointer page: 593, Index root page: 594 
    Total formats: 1, used formats: 1 
    Average record length: 80.07, total records: 9682030 
    Average version length: 82.56, total versions: 309353, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.57 
    Pointer pages: 104, data page slots: 168960 
    Data pages: 168944, average fill: 71% 
    Primary pages: 168920, secondary pages: 24, swept pages: 70935 
    Empty pages: 339, full pages: 103977 
    Fill distribution: 
     0 - 19% = 1114 
    20 - 39% = 5124 
    40 - 59% = 19981 
    60 - 79% = 123193 
    80 - 99% = 19532 
 
    Index XQS_1000_3300_DOC_ID (1) 
    Root page: 1367524, depth: 3, leaf buckets: 11328, nodes: 9682030 
    Average node length: 5.36, total dup: 9372632, max dup: 197 
    Average key length: 2.23, compression ratio: 4.03 
    Average prefix length: 8.80, average data length: 0.20 
    Clustering factor: 2228333, ratio: 0.23 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 53 
        40 - 59% = 8249 
        60 - 79% = 2948 
        80 - 99% = 76 
 
    Index XQS_1000_3300_RCV_ID (3) 
    Root page: 1379283, depth: 3, leaf buckets: 13399, nodes: 9682030 
    Average node length: 6.22, total dup: 8026594, max dup: 14 
    Average key length: 3.10, compression ratio: 2.90 
    Average prefix length: 8.07, average data length: 0.93 
    Clustering factor: 1580483, ratio: 0.16 
    Fill distribution: 
         0 - 19% = 134 
        20 - 39% = 3583 
        40 - 59% = 4692 
        60 - 79% = 2596 
        80 - 99% = 2394 
 
    Index XQS_1000_3300_SND_ID (2) 
    Root page: 1373081, depth: 3, leaf buckets: 12645, nodes: 9682030 
    Average node length: 5.97, total dup: 8400037, max dup: 38 
    Average key length: 2.85, compression ratio: 3.16 
    Average prefix length: 8.28, average data length: 0.72 
    Clustering factor: 2414829, ratio: 0.25 
    Fill distribution: 
         0 - 19% = 4 
        20 - 39% = 67 
        40 - 59% = 9135 
        60 - 79% = 3338 
        80 - 99% = 101 
 
    Index XQS_1000_3300_WORKER_ID (0) 
    Root page: 1362789, depth: 3, leaf buckets: 10132, nodes: 9682030 
    Average node length: 5.13, total dup: 9681930, max dup: 161951 
    Average key length: 2.00, compression ratio: 1.20 
    Average prefix length: 2.40, average data length: 0.00 
    Clustering factor: 1596341, ratio: 0.16 
    Fill distribution: 
         0 - 19% = 37 
        20 - 39% = 1246 
        40 - 59% = 5055 
        60 - 79% = 1738 
        80 - 99% = 2056 
 
XQS_1200_2000 (183) 
    Primary pointer page: 591, Index root page: 592 
    Total formats: 1, used formats: 1 
    Average record length: 80.96, total records: 11433537 
    Average version length: 82.47, total versions: 211454, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.56 
    Pointer pages: 119, data page slots: 193328 
    Data pages: 191888, average fill: 73% 
    Primary pages: 191769, secondary pages: 119, swept pages: 64484 
    Empty pages: 2009, full pages: 151911 
    Fill distribution: 
     0 - 19% = 3585 
    20 - 39% = 5991 
    40 - 59% = 15080 
    60 - 79% = 104269 
    80 - 99% = 62963 
 
    Index XQS_1200_2000_DOC_ID (1) 
    Root page: 1392123, depth: 3, leaf buckets: 13120, nodes: 11433537 
    Average node length: 5.31, total dup: 11323459, max dup: 651 
    Average key length: 2.08, compression ratio: 4.33 
    Average prefix length: 8.93, average data length: 0.07 
    Clustering factor: 2399119, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 96 
        40 - 59% = 8728 
        60 - 79% = 4101 
        80 - 99% = 195 
 
    Index XQS_1200_2000_RCV_ID (3) 
    Root page: 1406132, depth: 3, leaf buckets: 10553, nodes: 11433537 
    Average node length: 5.50, total dup: 10935722, max dup: 49 
    Average key length: 2.28, compression ratio: 3.95 
    Average prefix length: 8.77, average data length: 0.23 
    Clustering factor: 740452, ratio: 0.06 
    Fill distribution: 
         0 - 19% = 156 
        20 - 39% = 830 
        40 - 59% = 2620 
        60 - 79% = 1844 
        80 - 99% = 5103 
 
    Index XQS_1200_2000_SND_ID (2) 
    Root page: 1398660, depth: 3, leaf buckets: 15008, nodes: 11433537 
    Average node length: 6.03, total dup: 9978457, max dup: 71 
    Average key length: 2.80, compression ratio: 3.21 
    Average prefix length: 8.32, average data length: 0.68 
    Clustering factor: 2415576, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 134 
        40 - 59% = 10177 
        60 - 79% = 4472 
        80 - 99% = 224 
 
    Index XQS_1200_2000_WORKER_ID (0) 
    Root page: 1386233, depth: 3, leaf buckets: 10933, nodes: 11433537 
    Average node length: 5.23, total dup: 11433437, max dup: 204801 
    Average key length: 2.00, compression ratio: 1.20 
    Average prefix length: 2.40, average data length: 0.00 
    Clustering factor: 729040, ratio: 0.06 
    Fill distribution: 
         0 - 19% = 104 
        20 - 39% = 824 
        40 - 59% = 4937 
        60 - 79% = 1534 
        80 - 99% = 3534 
 
XQS_2000_3300 (185) 
    Primary pointer page: 595, Index root page: 596 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index XQS_2000_3300_DOC_ID (1) 
    Root page: 1361775, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index XQS_2000_3300_RCV_ID (3) 
    Root page: 1361777, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index XQS_2000_3300_SND_ID (2) 
    Root page: 1361776, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index XQS_2000_3300_WORKER_ID (0) 
    Root page: 1361774, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
XQS_2100_3300 (186) 
    Primary pointer page: 597, Index root page: 598 
    Total formats: 1, used formats: 1 
    Average record length: 80.45, total records: 9794263 
    Average version length: 82.88, total versions: 303915, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.57 
    Pointer pages: 106, data page slots: 172576 
    Data pages: 172544, average fill: 70% 
    Primary pages: 172521, secondary pages: 23, swept pages: 75224 
    Empty pages: 403, full pages: 103709 
    Fill distribution: 
     0 - 19% = 1328 
    20 - 39% = 5814 
    40 - 59% = 22080 
    60 - 79% = 124426 
    80 - 99% = 18896 
 
    Index XQS_2100_3300_DOC_ID (1) 
    Root page: 1344708, depth: 3, leaf buckets: 11806, nodes: 9794263 
    Average node length: 5.17, total dup: 9765614, max dup: 1548 
    Average key length: 2.03, compression ratio: 4.43 
    Average prefix length: 8.97, average data length: 0.03 
    Clustering factor: 2031554, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 31 
        20 - 39% = 1433 
        40 - 59% = 7939 
        60 - 79% = 1779 
        80 - 99% = 624 
 
    Index XQS_2100_3300_RCV_ID (3) 
    Root page: 1355739, depth: 3, leaf buckets: 13563, nodes: 9794263 
    Average node length: 6.24, total dup: 8119153, max dup: 14 
    Average key length: 3.10, compression ratio: 2.90 
    Average prefix length: 8.07, average data length: 0.93 
    Clustering factor: 1551886, ratio: 0.16 
    Fill distribution: 
         0 - 19% = 199 
        20 - 39% = 3573 
        40 - 59% = 4661 
        60 - 79% = 2598 
        80 - 99% = 2532 
 
    Index XQS_2100_3300_SND_ID (2) 
    Root page: 1350071, depth: 3, leaf buckets: 12413, nodes: 9794263 
    Average node length: 5.42, total dup: 9356651, max dup: 99 
    Average key length: 2.29, compression ratio: 3.94 
    Average prefix length: 8.76, average data length: 0.24 
    Clustering factor: 2165941, ratio: 0.22 
    Fill distribution: 
         0 - 19% = 37 
        20 - 39% = 1358 
        40 - 59% = 8752 
        60 - 79% = 1661 
        80 - 99% = 605 
 
    Index XQS_2100_3300_WORKER_ID (0) 
    Root page: 987843, depth: 3, leaf buckets: 10291, nodes: 9794263 
    Average node length: 5.14, total dup: 9794163, max dup: 164147 
    Average key length: 2.00, compression ratio: 1.20 
    Average prefix length: 2.40, average data length: 0.00 
    Clustering factor: 1621982, ratio: 0.17 
    Fill distribution: 
         0 - 19% = 50 
        20 - 39% = 1276 
        40 - 59% = 5206 
        60 - 79% = 1673 
        80 - 99% = 2086 
 
XQS_3300_3400 (187) 
    Primary pointer page: 599, Index root page: 600 
    Total formats: 1, used formats: 1 
    Average record length: 67.64, total records: 578142 
    Average version length: 68.51, total versions: 5279, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.86 
    Pointer pages: 5, data page slots: 8104 
    Data pages: 8104, average fill: 75% 
    Primary pages: 8104, secondary pages: 0, swept pages: 3468 
    Empty pages: 0, full pages: 6970 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 5 
    40 - 59% = 131 
    60 - 79% = 7842 
    80 - 99% = 125 
 
    Index XQS_3300_3400_DOC_ID (1) 
    Root page: 42850, depth: 3, leaf buckets: 730, nodes: 578142 
    Average node length: 5.95, total dup: 492337, max dup: 82 
    Average key length: 3.09, compression ratio: 2.91 
    Average prefix length: 8.06, average data length: 0.94 
    Clustering factor: 101480, ratio: 0.18 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 27 
        40 - 59% = 499 
        60 - 79% = 108 
        80 - 99% = 96 
 
    Index XQS_3300_3400_SND_ID (2) 
    Root page: 35050, depth: 3, leaf buckets: 756, nodes: 578142 
    Average node length: 6.15, total dup: 474158, max dup: 27 
    Average key length: 3.29, compression ratio: 2.73 
    Average prefix length: 7.89, average data length: 1.11 
    Clustering factor: 101521, ratio: 0.18 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 27 
        40 - 59% = 527 
        60 - 79% = 102 
        80 - 99% = 100 
 
    Index XQS_3300_3400_WORKER_ID (0) 
    Root page: 377587, depth: 2, leaf buckets: 569, nodes: 578142 
    Average node length: 4.86, total dup: 578042, max dup: 9464 
    Average key length: 2.00, compression ratio: 1.20 
    Average prefix length: 2.41, average data length: 0.00 
    Clustering factor: 90237, ratio: 0.16 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 39 
        40 - 59% = 325 
        60 - 79% = 71 
        80 - 99% = 134 
 
ZDOC_DATA (170) 
    Primary pointer page: 565, Index root page: 566 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
ZDOC_LIST (169) 
    Primary pointer page: 563, Index root page: 564 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
ZINVNT_TURNOVER_LOG (171) 
    Primary pointer page: 567, Index root page: 568 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
ZPDISTR (174) 
    Primary pointer page: 573, Index root page: 574 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index ZPDISTR_ID (0) 
    Root page: 1504230, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
ZPSTORNED (175) 
    Primary pointer page: 575, Index root page: 576 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index ZPSTORNED_ID (0) 
    Root page: 1504229, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
ZQDISTR (172) 
    Primary pointer page: 569, Index root page: 570 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index ZQDISTR_ID (0) 
    Root page: 1504235, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index ZQDISTR_WARE_SNDOP_RCVOP (1) 
    Root page: 1504236, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
ZQSTORNED (173) 
    Primary pointer page: 571, Index root page: 572 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index ZQSTORNED_DOC_ID (1) 
    Root page: 1504232, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index ZQSTORNED_ID (0) 
    Root page: 1504231, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index ZQSTORNED_RCV_ID (3) 
    Root page: 1504234, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index ZQSTORNED_SND_ID (2) 
    Root page: 1504233, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
ZTMP_DEP_DOCS (168) 
    Primary pointer page: 561, Index root page: 562 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
ZTMP_SHOPPING_CART (167) 
    Primary pointer page: 559, Index root page: 560 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
Z_USED_VIEWS (144) 
    Primary pointer page: 512, Index root page: 513 
    Total formats: 1, used formats: 1 
    Average record length: 29.38, total records: 29 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 99.00, compression ratio: 3.37 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 16% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index Z_USED_VIEWS_UNQ (0) 
    Root page: 1510372, depth: 1, leaf buckets: 1, nodes: 29 
    Average node length: 15.17, total dup: 0, max dup: 0 
    Average key length: 14.14, compression ratio: 1.44 
    Average prefix length: 9.17, average data length: 11.17 
    Clustering factor: 1, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
Gstat completion time Tue Mar 12 04:10:13 2024

Record versions statistics, table

TABLE_NAME TOTAL_RECS TOTAL_VERS MAX_VERSIONS VERS_TO_RECS_PRC MAXV_TO_VERS_PRC
DOC_DATA 7778403 69763 1 0.0000 0.0000
DOC_LIST 2257348 34929 2 0.0000 0.0000
FB_ERRORS 2182 757 1 0.0000 0.0000
INVNT_SALDO 400 4072 11 1000.0000 0.0000
INVNT_TURNOVER_LOG 125362 122891 1 0.0000 0.0000
MONEY_SALDO 49 373 11 700.0000 0.0000
MONEY_TURNOVER_LOG 1938 1836 1 0.0000 0.0000
PDISTR 805481 39865 2 0.0000 0.0000
PERF_SPLIT_0 180969 6961 1 0.0000 0.0000
PERF_SPLIT_1 153050 5826 1 0.0000 0.0000
PERF_SPLIT_2 160624 7159 1 0.0000 0.0000
PERF_SPLIT_3 187982 6958 1 0.0000 0.0000
PERF_SPLIT_4 164259 4796 1 0.0000 0.0000
PERF_SPLIT_5 159451 6513 1 0.0000 0.0000
PERF_SPLIT_6 171575 5587 1 0.0000 0.0000
PERF_SPLIT_7 158743 6078 1 0.0000 0.0000
PERF_SPLIT_8 152399 8638 1 0.0000 0.0000
PERF_SPLIT_9 165064 9770 1 0.0000 0.0000
PSTORNED 2116300 31056 1 0.0000 0.0000
SEMAPHORES 5 1 1 0.0000 100.0000
XQD_1000_1200 145967 74618 1 0.0000 0.0000
XQD_1000_3300 6960390 422506 1 0.0000 0.0000
XQD_1200_2000 11847247 346206 1 0.0000 0.0000
XQD_2000_3300 1670066 366633 1 0.0000 0.0000
XQD_2100_3300 1200755 149437 1 0.0000 0.0000
XQD_3300_3400 9261667 338840 1 0.0000 0.0000
XQS_1000_1200 21152591 11618 1 0.0000 0.0000
XQS_1000_3300 9682030 309353 1 0.0000 0.0000
XQS_1200_2000 11433537 211454 1 0.0000 0.0000
XQS_2100_3300 9794263 303915 1 0.0000 0.0000
XQS_3300_3400 578142 5279 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 ---
:743: 
:744: mscs-test-161.budzdorov.ru    Tue Mar 12 04:07:53 2024
:745:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3400
:746: 
:747: 
:748: mscs-test-161.budzdorov.ru    Tue Mar 12 04:07:53 2024
:749:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3400
:750: 
:751: 
:752: mscs-test-161.budzdorov.ru    Tue Mar 12 04:07:55 2024
:753:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3400
:754: 
:755: 
:756: mscs-test-161.budzdorov.ru    Tue Mar 12 04:07:57 2024
:757:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3400
:758: 
:759: 
:760: mscs-test-161.budzdorov.ru    Tue Mar 12 04:08:01 2024
:761:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3400
:762: 
--- end of diff output ---

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

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