Generated by /opt/oltp-emul/oltp_isql_run_worker.sh, ISQL session No. 1 of total launched 100. 14.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 15459904 kB
MemAvailable 30183472 kB
Buffers 20 kB
Cached 16164164 kB
SwapCached 2704 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-14 04:07:48
DTS_END                         2024-03-14 04:07:48.6900
FB_GDSCODE                      -1
FB_MNEMONA                      
STACK                           SP_ADD_INVOICE_TO_STOCK(190:30) ==> SP_CUSTOMER_RESERVE(47:5) ==> SP_CHECK_TO_STOP_WORK(32:12) ==> SP_HALT_ON_ERROR(68:17)
IP                              ::1/37332
TRN_ID                          173745
ATT_ID                          543
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: 9516.68 18438 951668
customer order: creation 182.46 394 18246
customer order: refuse 15.87 318 1587
order to supplier: creation 48.35 1366 4835
order to supplier: removal 3.80 89196 380
invoice (draft): creation 49.53 2896 4953
invoice (draft): removal 52.89 693 5289
invoice accept: apply 42.93 18524 4293
invoice accept: cancel 48.37 762 4837
customer reserve: creation 4074.94 180 407494
customer reserve: removal 4682.94 58 468294
realization accept: apply 87.74 176 8774
realization accept: cancel 92.75 107 9275
payment from customer: creation 61.66 105 6166
payment from customer: removal 5.95 78 595
payment to supplier: creation 51.47 127 5147
payment to supplier: removal 3.59 77 359
service: total inventory turnovers 4.04 3595 404
service: total monetary turnovers 6.36 484 636
service: aggregate perf. data 1.01 12427 101
service: refresh index statistics 0.03 237204 3

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:02, from 14-03-2024 04:08:30 to 14-03-2024 04:08:32.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 2188
TEST_TIME 2 4388
TEST_TIME 3 3215
TEST_TIME 4 3648
TEST_TIME 5 3934
TEST_TIME 6 4236
TEST_TIME 7 4860
TEST_TIME 8 5229
TEST_TIME 9 5609
TEST_TIME 10 5749
TEST_TIME 11 6091
TEST_TIME 12 6495
TEST_TIME 13 6514
TEST_TIME 14 6688
TEST_TIME 15 6686
TEST_TIME 16 6825
TEST_TIME 17 7324
TEST_TIME 18 7667
TEST_TIME 19 7828
TEST_TIME 20 8040
TEST_TIME 21 8169
TEST_TIME 22 8574
TEST_TIME 23 8676
TEST_TIME 24 8878
TEST_TIME 25 9208
TEST_TIME 26 9801
TEST_TIME 27 10060
TEST_TIME 28 9842
TEST_TIME 29 9775
TEST_TIME 30 9769
TEST_TIME 31 9882
TEST_TIME 32 9892
TEST_TIME 33 9905
TEST_TIME 34 10055
TEST_TIME 35 10041
TEST_TIME 36 9917
TEST_TIME 37 9934
TEST_TIME 38 10109
TEST_TIME 39 9866
TEST_TIME 40 9684
TEST_TIME 41 9493
TEST_TIME 42 9525
TEST_TIME 43 9429
TEST_TIME 44 9400
TEST_TIME 45 9455
TEST_TIME 46 9412
TEST_TIME 47 9410
TEST_TIME 48 9333
TEST_TIME 49 9271
TEST_TIME 50 9375
TEST_TIME 51 9422
TEST_TIME 52 9479
TEST_TIME 53 9478
TEST_TIME 54 9449
TEST_TIME 55 9622
TEST_TIME 56 9592
TEST_TIME 57 9676
TEST_TIME 58 9628
TEST_TIME 59 9739
TEST_TIME 60 9662
TEST_TIME 61 9810
TEST_TIME 62 9655
TEST_TIME 63 9566
TEST_TIME 64 9535
TEST_TIME 65 9488
TEST_TIME 66 9404
TEST_TIME 67 9365
TEST_TIME 68 9320
TEST_TIME 69 9310
TEST_TIME 70 9377
TEST_TIME 71 9383
TEST_TIME 72 9383
TEST_TIME 73 9412
TEST_TIME 74 9510
TEST_TIME 75 9471
TEST_TIME 76 9478
TEST_TIME 77 9479
TEST_TIME 78 9568
TEST_TIME 79 9608
TEST_TIME 80 9608
TEST_TIME 81 9687
TEST_TIME 82 9670
TEST_TIME 83 9572
TEST_TIME 84 9516
TEST_TIME 85 9452
TEST_TIME 86 9489
TEST_TIME 87 9463
TEST_TIME 88 9422
TEST_TIME 89 9377
TEST_TIME 90 9345
TEST_TIME 91 9403
TEST_TIME 92 9371
TEST_TIME 93 9410
TEST_TIME 94 9405
TEST_TIME 95 9428
TEST_TIME 96 9552
TEST_TIME 97 9541
TEST_TIME 98 9533
TEST_TIME 99 9543
TEST_TIME 100 9524

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:03, from 14-03-2024 04:08:34 to 14-03-2024 04:08:37.

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 1326024 1326024 0 0.00 0 13263 6 0 0
doc_list_biud 1326024 1326024 0 0.00 0 36519 26 0 0
sp_add_invoice_to_stock 4356 4293 63 1.44 42 179647 18525 0 63
sp_cancel_adding_invoice 4837 4837 0 0.00 3 58765 763 0 0
sp_cancel_client_order 1587 1587 0 0.00 4 14395 319 0 0
sp_cancel_customer_reserve 468294 468294 0 0.00 0 36521 59 0 0
sp_cancel_pay_from_customer 595 595 0 0.00 3 4234 79 0 0
sp_cancel_pay_to_supplier 359 359 0 0.00 2 5447 78 0 0
sp_cancel_supplier_invoice 5298 5289 9 0.16 1 18169 694 0 9
sp_cancel_supplier_order 380 380 0 0.00 13 827205 89196 0 0
sp_cancel_write_off 9275 9275 0 0.00 1 7626 108 0 0
sp_client_order 18246 18246 0 0.00 3 35949 395 0 0
sp_customer_reserve 407494 407494 0 0.00 0 69880 180 0 0
sp_fill_shopping_cart 28024 28024 0 0.00 1 12217 37 0 0
sp_fill_shopping_cart_clo_res 407491 407491 0 0.00 0 21551 15 0 0
sp_get_clo_for_invoice 4285 4285 0 0.00 0 26021 311 0 0
sp_kill_cost_storno 15066 15066 0 0.00 0 11389 60 0 0
sp_kill_qstorno_ret_qs2qd 951532 951532 0 0.00 0 32849 31 0 0
sp_kill_qty_storno 502721 502721 0 0.00 0 36518 67 0 0
sp_lock_selected_doc 18157 18157 0 0.00 0 8367 4 0 0
sp_make_cost_storno 24372 24372 0 0.00 0 13257 57 0 0
sp_multiply_rows_for_pdistr 24372 24372 0 0.00 0 7944 30 0 0
sp_multiply_rows_for_qdistr 18246 18246 0 0.00 0 35838 194 0 0
sp_pay_from_customer 6166 6166 0 0.00 3 11239 105 0 0
sp_pay_to_supplier 5147 5147 0 0.00 4 15530 127 0 0
sp_payment_common 11313 11313 0 0.00 1 11618 21 0 0
sp_qd_handle_on_cancel_clo 1587 1587 0 0.00 0 14388 296 0 0
sp_qd_handle_on_invoice_upd_sts 9122 9122 0 0.00 0 31262 295 0 0
sp_qd_handle_on_reserve_upd_sts 8774 8774 0 0.00 0 19102 62 0 0
sp_reserve_write_off 8774 8774 0 0.00 6 19146 176 0 0
sp_supplier_invoice 4953 4953 0 0.00 5 87790 2897 0 0
sp_supplier_order 4835 4835 0 0.00 4 31243 1366 0 0
srv_aggregate_perf_data 101 101 0 0.00 1726 211434 12427 0 0
srv_fill_mon_cache_memory 56 56 0 0.00 1461 101848 39765 0 0
srv_find_qd_qs_mism 908244 908244 0 0.00 0 13147 6 0 0
srv_make_invnt_saldo 404 404 0 0.00 37 91819 3596 0 0
srv_make_money_saldo 636 636 0 0.00 1 15978 485 0 0
srv_recalc_idx_stat 3 3 0 0.00 186897 287514 237205 0 0
t$perf-abend:sp_add_invoice_to_stock 63 63 0 0.00 0 0 0 0 0
t$perf-abend:sp_cancel_supplier_invoice 9 9 0 0.00 0 0 0 0 0
t$perf-norm:sp_add_invoice_to_stock 4293 4293 0 0.00 0 10642 160 0 0
t$perf-norm:sp_cancel_adding_invoice 364 364 0 0.00 0 2444 69 0 0
t$perf-norm:sp_cancel_client_order 1587 1587 0 0.00 0 2504 10 0 0
t$perf-norm:sp_cancel_customer_reserve 610 610 0 0.00 0 1218 11 0 0
t$perf-norm:sp_cancel_pay_from_customer 595 595 0 0.00 0 2338 8 0 0
t$perf-norm:sp_cancel_pay_to_supplier 359 359 0 0.00 0 3975 12 0 0
t$perf-norm:sp_cancel_supplier_invoice 327 327 0 0.00 0 598 12 0 0
t$perf-norm:sp_cancel_supplier_order 380 380 0 0.00 0 21394 1531 0 0
t$perf-norm:sp_cancel_write_off 876 876 0 0.00 0 3133 12 0 0
t$perf-norm:sp_client_order 18246 18246 0 0.00 0 14495 17 0 0
t$perf-norm:sp_customer_reserve 875 875 0 0.00 0 2707 6 0 0
t$perf-norm:sp_pay_from_customer 6166 6166 0 0.00 0 3465 8 0 0
t$perf-norm:sp_pay_to_supplier 5147 5147 0 0.00 0 4338 9 0 0
t$perf-norm:sp_reserve_write_off 8774 8774 0 0.00 0 11647 12 0 0
t$perf-norm:sp_supplier_invoice 4953 4953 0 0.00 0 5940 17 0 0
t$perf-norm:sp_supplier_order 4835 4835 0 0.00 0 4213 15 0 0
t$perf-norm:srv_aggregate_perf_data 101 101 0 0.00 0 195 3 0 0
t$perf-norm:srv_fill_mon_cache_memory 56 56 0 0.00 0 905 35 0 0
t$perf-norm:srv_make_invnt_saldo 404 404 0 0.00 0 1370 9 0 0
t$perf-norm:srv_make_money_saldo 636 636 0 0.00 0 266 4 0 0
t$perf-norm:srv_recalc_idx_stat 3 3 0 0.00 1 4 3 0 0
v_add_invoice_to_stock 8696 8570 126 1.44 0 4414 14 0 126
v_all_customers 34048 34048 0 0.00 0 19 1 0 0
v_all_suppliers 27784 27784 0 0.00 0 110 1 0 0
v_all_wares 36492 36492 0 0.00 0 19 1 0 0
v_cancel_adding_invoice 728 728 0 0.00 0 752 6 0 0
v_cancel_client_order 3174 3174 0 0.00 0 2307 4 0 0
v_cancel_customer_prepayment 1190 1190 0 0.00 0 833 5 0 0
v_cancel_customer_reserve 1220 1220 0 0.00 0 1844 6 0 0
v_cancel_payment_to_supplier 718 718 0 0.00 0 3692 11 0 0
v_cancel_supplier_invoice 672 654 18 2.67 0 967 15 0 18
v_cancel_supplier_order 760 760 0 0.00 0 4110 19 0 0
v_cancel_write_off 1752 1752 0 0.00 0 2406 12 0 0
v_max_id_clo_ord 4835 4835 0 0.00 0 1631 2 0 0
v_max_id_clo_res 875 875 0 0.00 0 2380 14 0 0
v_max_id_ord_sup 4943 4943 0 0.00 0 2891 5 0 0
v_max_non_paid_invoice 1033 1033 0 0.00 0 1936 4 0 0
v_max_non_paid_realizn 2871 2871 0 0.00 0 11225 8 0 0
v_min_id_clo_ord 4835 4835 0 0.00 0 2213 7 0 0
v_min_id_clo_res 875 875 0 0.00 0 2965 9 0 0
v_min_id_ord_sup 4943 4943 0 0.00 0 5593 7 0 0
v_min_non_paid_invoice 5147 5147 0 0.00 0 11611 16 0 0
v_min_non_paid_realizn 6166 6166 0 0.00 0 5935 12 0 0
v_our_firm 9034 9034 0 0.00 0 14 1 0 0
v_reserve_write_off 17548 17548 0 0.00 0 4542 5 0 0
x_lock_depdocs_on_canc_invoice 9799 9799 0 0.00 0 12113 96 0 0
x_lock_depdocs_on_canc_sup_ord 380 380 0 0.00 0 8338 323 0 0
x_make_qstorno_1000_1200 4835 4835 0 0.00 1 31234 1294 0 0
x_make_qstorno_1200_2000 4953 4953 0 0.00 2 87782 2758 0 0
x_make_qstorno_2100_3300 407494 407494 0 0.00 0 51955 163 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 14-03-2024 04:08:38 to 14-03-2024 04:08:42.

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 2 8192000000 8796669552 8807108608 3187328 0.038 1 1 2 0 3284944 61840 35776
02:08:53 18917 8192000000 9716572736 10012450816 789531872 8.790 100 85 169 1 817638560 6880752 21225936
02:10:20 34144 8192000000 9764413520 10071650304 838632496 9.286 100 92 184 0 871631824 10933536 22065792
02:12:01 15277 8192000000 9800940720 10117177344 863481456 9.535 100 86 172 0 908986592 25280480 20224656
02:13:24 10641 8192000000 9849500928 10182582272 913950224 10.036 100 78 156 1 962091184 30222080 17918880
02:14:39 8910 8192000000 9904480912 10248019968 964368432 10.532 100 79 156 0 1017319744 37371072 15580240
02:15:51 5273 8192000000 9961018736 10321092608 993528448 10.816 100 77 154 1 1077345808 68526240 15291120
02:16:58 2894 8192000000 9984432544 10347524096 1020746816 11.079 100 77 152 2 1098838240 62487872 15603552
02:18:04 2485 8192000000 9993866256 10364518400 1038927152 11.254 100 71 141 2 1114543632 61979968 13636512
02:19:08 1144 8192000000 10028691088 10404974592 1052863968 11.388 100 88 176 1 1144890496 73971984 18054544
02:20:12 1772 8192000000 10050824896 10429362176 1068045552 11.533 100 76 152 0 1157084544 74112960 14926032
02:21:18 3025 8192000000 10004240656 10390974464 1072353088 11.575 100 52 104 1 1121882320 39323456 10205776
02:22:22 5171 8192000000 10020294016 10411687936 1082392336 11.670 100 46 92 0 1127205088 34619744 10193008
02:23:28 2272 8192000000 10008077136 10410418176 1087742720 11.721 100 44 89 0 1127655472 31058480 8854272
02:24:31 60865 8192000000 9991444864 10396254208 1093029792 11.771 100 40 81 1 1112965536 9541808 10393936
02:26:33 5221 8192000000 10016746880 10424729600 1100040624 11.838 100 36 71 1 1148172000 41359360 6772016
02:27:39 5581 8192000000 10016968016 10418900992 1102756976 11.864 100 26 52 0 1142429072 34011280 5660816
02:28:51 12120 8192000000 10044700112 10447351808 1097878688 11.818 99 42 83 2 1136513408 29508688 9126032
02:30:06 101847 8192000000 10083644160 10506731520 1097855024 11.817 98 31 62 0 1176950144 72778736 6316384
02:32:59 6152 8192000000 10113972000 10517278720 1115958816 11.989 99 56 110 0 1216825424 89632912 11233696
02:34:12 19243 8192000000 10159075728 10570686464 1127887776 12.101 99 49 96 0 1265431344 127622944 9920624
02:35:35 14160 8192000000 10101715728 10499981312 1087785904 11.722 97 35 68 1 1199351760 104242816 7323040
02:36:55 7775 8192000000 10146220320 10537881600 1105622944 11.891 100 54 107 0 1254305472 137965344 10717184
02:38:07 16648 8192000000 10168331232 10571239424 1090771504 11.750 97 43 86 1 1256452224 155929184 9751536
02:39:40 14618 8192000000 10148215168 10551287808 1089483520 11.738 96 43 85 0 1216374864 117735360 9155984
02:41:06 5476 8192000000 10173274704 10569859072 1118153104 12.010 100 54 106 0 1277030256 147225872 11651280
02:42:16 3992 8192000000 10219405056 10633969664 1139218480 12.208 100 54 108 0 1325314064 173890704 12204880
02:43:23 2107 8192000000 10258711296 10663514112 1125666976 12.080 100 85 170 0 1374548544 229619296 19262272
02:44:30 3543 8192000000 10287457072 10686676992 1129619456 12.118 99 67 124 0 1388186000 244010032 14556512
02:45:38 1745 8192000000 10342283424 10742169600 1152292560 12.331 100 78 154 0 1450083984 279960144 17831280
02:46:51 1460 8192000000 10364529440 10771009536 1166581392 12.465 100 84 159 2 1459911392 274971104 18358896
02:48:00 4784 8192000000 10399086704 10829262848 1171533152 12.511 100 50 100 0 1501325472 318124240 11668080
02:49:11 14498 8192000000 10387634784 10823364608 1142448288 12.239 99 34 66 0 1484380960 333244960 8687712
02:50:38 59768 8192000000 10289215024 10791571456 1146917072 12.281 100 29 58 0 1419739424 265816000 7006352
02:52:44 45689 8192000000 10210294880 10746687488 1136817520 12.186 100 18 36 0 1326449952 184960816 4671616
02:55:34 39184 8192000000 10141776688 10582167552 1145496672 12.267 100 25 49 0 1195514768 45075456 4942640
02:57:14 28490 8192000000 10103949792 10546106368 1145603904 12.268 100 25 49 1 1231501472 80683344 5214224
02:58:44 52494 8192000000 10099581552 10579984384 1149200576 12.302 100 11 23 0 1205048272 53485664 2362032
03:00:46 62899 8192000000 10086545328 10598035456 1150991728 12.319 100 7 14 0 1204164864 51728352 1444784
03:02:50 31651 8192000000 10084466864 10524807168 1160875248 12.411 100 13 26 0 1186684160 23156416 2652496
03:04:26 39463 8192000000 10152039760 10628440064 1162376112 12.426 100 17 34 0 1270730032 104371360 3982560
03:06:16 71141 8192000000 10104554432 10556153856 1162885248 12.430 100 24 48 0 1191626448 23540960 5200240
03:08:34 32791 8192000000 10143525984 10586013696 1177575744 12.568 100 33 66 0 1231518688 47633424 6309520
03:10:08 69560 8192000000 10182431472 10648158208 1161624368 12.418 98 32 65 0 1239349632 70528240 7197024
03:12:27 61336 8192000000 10121972912 10606338048 1149275792 12.303 98 17 34 0 1245648368 92332608 4039968
03:14:53 57427 8192000000 10141720576 10599907328 1161655424 12.419 99 17 33 0 1228037376 62839616 3542336
03:16:56 26481 8192000000 10167225184 10635202560 1165473904 12.455 100 16 32 0 1249440208 80091888 3874416
03:18:22 47134 8192000000 10094450640 10558267392 1088296528 11.726 94 14 28 0 1141517360 50233984 2986848
03:20:31 48501 8192000000 10124472000 10586243072 1151888208 12.327 100 29 59 0 1209966688 52453872 5624608
03:22:30 73107 8192000000 10066132752 10542497792 1045469840 11.317 91 18 34 0 1080452928 31750480 3232608
03:24:48 56616 8192000000 10075164576 10513674240 1057933632 11.437 94 27 53 0 1121018480 57450304 5634544
03:26:48 45779 8192000000 10092901520 10528399360 1088847072 11.732 97 14 28 0 1151132864 59409344 2876448
03:28:47 53122 8192000000 10058368304 10540527616 1121010576 12.037 100 6 12 0 1165262528 43288576 963376
03:30:41 43528 8192000000 10045498320 10475106304 1103010848 11.866 100 31 60 0 1153873376 44928112 5934416
03:32:27 67356 8192000000 10073615984 10534789120 1108916320 11.922 99 18 36 0 1154225776 41269568 4039888
03:34:45 69616 8192000000 10068854496 10536964096 1079214688 11.640 97 15 30 0 1160756896 78053360 3488848
03:37:24 60639 8192000000 10074135952 10505977856 1078061808 11.629 97 14 28 0 1118000560 37447536 2491216
03:39:25 56142 8192000000 10077427056 10500063232 1084226896 11.688 97 28 55 0 1126871744 37225856 5418992
03:41:24 52194 8192000000 10042004688 10512068608 1073052496 11.581 96 6 12 0 1121683776 47398624 1232656
03:43:24 23080 8192000000 10099325008 10535464960 1130475968 12.126 100 45 90 0 1191959616 52467008 9016640
03:44:48 37133 8192000000 10097966240 10561732608 1119283184 12.020 99 25 50 0 1184176080 59590256 5302640
03:46:28 60070 8192000000 10094246240 10523074560 1123857184 12.063 99 44 88 0 1203131696 69615728 9658784
03:48:28 62788 8192000000 10071349056 10554232832 1127867584 12.101 99 15 29 0 1163432912 32378320 3187008
03:50:31 57861 8192000000 10056782096 10520772608 1136014432 12.178 100 15 30 0 1168417840 29175616 3227792
03:52:32 9530 8192000000 10080823920 10515197952 1134575264 12.164 99 48 90 1 1177011248 34174512 8261472
03:53:42 61941 8192000000 10077179056 10548584448 1135852832 12.177 99 14 24 1 1183234000 44893520 2487648
03:55:46 41326 8192000000 10091517520 10554093568 1149077504 12.301 100 18 35 0 1187002688 34058352 3866832
03:57:27 59780 8192000000 10108948224 10580279296 1122446704 12.050 97 20 40 0 1185745120 58463968 4834448
03:59:28 45057 8192000000 10115417408 10571272192 1126883648 12.092 98 27 54 1 1179370608 46936400 5550560
04:01:13 33748 8192000000 10100017136 10540396544 1127644608 12.099 98 26 52 0 1181453584 47614576 6194400
04:02:48 48987 8192000000 10185824768 10656497664 1145888560 12.271 99 20 40 0 1247482512 96875616 4718336
04:05:15 58673 8192000000 10101043104 10546446336 1068562928 11.538 93 26 51 0 1109266688 35327200 5376560
04:07:16 44555 8192000000 8997725856 9202782208 151164960 1.811 14 3 6 0 160340256 8753712 421584

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:14, from 14-03-2024 04:08:44 to 14-03-2024 04:08:58.

Exceptions occured during test was in run

FB_MNEMONA CNT UNIT FB_GDSCODE
except 63 v_add_invoice_to_stock 335544517
except 9 v_cancel_supplier_invoice 335544517

Completed "Exceptions occured during test was in run". Done for 00:00:02, from 14-03-2024 04:08:59 to 14-03-2024 04:09:01.

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          174041
MON$OLDEST_ACTIVE               174042
MON$OLDEST_SNAPSHOT             174042
MON$NEXT_TRANSACTION            174042
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                       1932640
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             695
MON$NEXT_STATEMENT              53
MON$REPLICA_MODE                0


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

Database statistics 

 
Database "/home/bases/oltp40-etalone.fdb" 
Gstat execution time Thu Mar 14 04:09:02 2024 
 
Database header page information: 
    Flags            0 
    Generation        91172 
    System Change Number    0 
    Page size        8192 
    ODS version        13.0 
    Oldest transaction    174041 
    Oldest active        174042 
    Oldest snapshot        174042 
    Next transaction    174043 
    Sequence number        0 
    Next attachment ID    695 
    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.15, total records: 7763962 
    Average version length: 48.16, total versions: 148392, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 64.00, compression ratio: 1.36 
    Pointer pages: 55, data page slots: 88592 
    Data pages: 88592, average fill: 70% 
    Primary pages: 88591, secondary pages: 1, swept pages: 27299 
    Empty pages: 1, full pages: 81885 
    Fill distribution: 
     0 - 19% = 7 
    20 - 39% = 26 
    40 - 59% = 862 
    60 - 79% = 87587 
    80 - 99% = 110 
 
    Index DOC_DATA_DOC_WARE_UNQ (0) 
    Root page: 1510636, depth: 3, leaf buckets: 23326, nodes: 7763962 
    Average node length: 18.88, total dup: 0, max dup: 0 
    Average key length: 15.89, compression ratio: 1.70 
    Average prefix length: 14.11, average data length: 12.89 
    Clustering factor: 1684019, ratio: 0.22 
    Fill distribution: 
         0 - 19% = 356 
        20 - 39% = 1796 
        40 - 59% = 4122 
        60 - 79% = 2554 
        80 - 99% = 14498 
 
    Index DOC_DATA_ID_DESC (1) 
    Root page: 1528140, depth: 3, leaf buckets: 13559, nodes: 7763962 
    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: 1508217, ratio: 0.19 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 1543 
        40 - 59% = 2130 
        60 - 79% = 1124 
        80 - 99% = 8762 
 
    Index FK_DOC_DATA_DOC_LIST (2) 
    Root page: 1546735, depth: 3, leaf buckets: 8345, nodes: 7763962 
    Average node length: 6.61, total dup: 5814911, max dup: 49 
    Average key length: 3.62, compression ratio: 2.48 
    Average prefix length: 7.63, average data length: 1.37 
    Clustering factor: 1501094, ratio: 0.19 
    Fill distribution: 
         0 - 19% = 131 
        20 - 39% = 924 
        40 - 59% = 1417 
        60 - 79% = 961 
        80 - 99% = 4912 
 
DOC_LIST (138) 
    Primary pointer page: 500, Index root page: 501 
    Total formats: 1, used formats: 1 
    Average record length: 55.81, total records: 2239193 
    Average version length: 58.92, total versions: 74889, max versions: 2 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 84.00, compression ratio: 1.50 
    Pointer pages: 18, data page slots: 28584 
    Data pages: 28584, average fill: 72% 
    Primary pages: 28581, secondary pages: 3, swept pages: 6195 
    Empty pages: 6, full pages: 25346 
    Fill distribution: 
     0 - 19% = 16 
    20 - 39% = 69 
    40 - 59% = 1336 
    60 - 79% = 26985 
    80 - 99% = 178 
 
    Index DOC_LIST_ID_DESC (1) 
    Root page: 1541152, depth: 3, leaf buckets: 4543, nodes: 2239193 
    Average node length: 11.41, total dup: 0, max dup: 0 
    Average key length: 8.45, compression ratio: 1.07 
    Average prefix length: 3.55, average data length: 5.45 
    Clustering factor: 673985, ratio: 0.30 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 887 
        40 - 59% = 869 
        60 - 79% = 767 
        80 - 99% = 2020 
 
    Index DOC_LIST_WORKER_OPTYPE (2) 
    Root page: 1544398, depth: 3, leaf buckets: 2408, nodes: 2241187 
    Average node length: 4.97, total dup: 2240288, max dup: 20308 
    Average key length: 2.01, compression ratio: 4.48 
    Average prefix length: 8.99, average data length: 0.01 
    Clustering factor: 1261429, ratio: 0.56 
    Fill distribution: 
         0 - 19% = 4 
        20 - 39% = 193 
        40 - 59% = 1380 
        60 - 79% = 583 
        80 - 99% = 248 
 
    Index FK_DOC_LIST_AGENTS (3) 
    Root page: 1545933, depth: 3, leaf buckets: 1762, nodes: 2239193 
    Average node length: 4.97, total dup: 2239143, max dup: 130317 
    Average key length: 2.01, compression ratio: 4.48 
    Average prefix length: 8.99, average data length: 0.01 
    Clustering factor: 1061596, ratio: 0.47 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 17 
        40 - 59% = 592 
        60 - 79% = 56 
        80 - 99% = 1097 
 
    Index PK_DOC_LIST (0) 
    Root page: 1538209, depth: 3, leaf buckets: 4351, nodes: 2239193 
    Average node length: 11.41, total dup: 0, max dup: 0 
    Average key length: 8.45, compression ratio: 1.07 
    Average prefix length: 3.55, average data length: 5.45 
    Clustering factor: 673985, ratio: 0.30 
    Fill distribution: 
         0 - 19% = 97 
        20 - 39% = 598 
        40 - 59% = 631 
        60 - 79% = 846 
        80 - 99% = 2179 
 
DOC_STATES (149) 
    Primary pointer page: 522, Index root page: 523 
    Total formats: 1, used formats: 1 
    Average record length: 67.50, total records: 4 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 650.00, compression ratio: 9.63 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 4% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index DOC_STATES_MCODE_UNQ (1) 
    Root page: 1504337, depth: 1, leaf buckets: 1, nodes: 4 
    Average node length: 17.75, total dup: 0, max dup: 0 
    Average key length: 16.50, compression ratio: 1.08 
    Average prefix length: 4.00, average data length: 13.75 
    Clustering factor: 1, ratio: 0.25 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index DOC_STATES_NAME_UNQ (2) 
    Root page: 1504338, depth: 1, leaf buckets: 1, nodes: 4 
    Average node length: 33.25, total dup: 0, max dup: 0 
    Average key length: 32.00, compression ratio: 0.99 
    Average prefix length: 2.50, average data length: 29.25 
    Clustering factor: 1, ratio: 0.25 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PK_DOC_STATES (0) 
    Root page: 1504336, depth: 1, leaf buckets: 1, nodes: 4 
    Average node length: 4.75, total dup: 0, max dup: 0 
    Average key length: 3.50, compression ratio: 0.86 
    Average prefix length: 1.50, average data length: 1.50 
    Clustering factor: 1, ratio: 0.25 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
FB_ERRORS (155) 
    Primary pointer page: 534, Index root page: 535 
    Total formats: 2, used formats: 2 
    Average record length: 57.88, total records: 2182 
    Average version length: 79.61, total versions: 757, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 270.43, compression ratio: 4.67 
    Pointer pages: 1, data page slots: 40 
    Data pages: 40, average fill: 72% 
    Primary pages: 39, secondary pages: 1, swept pages: 0 
    Empty pages: 4, full pages: 34 
    Fill distribution: 
     0 - 19% = 5 
    20 - 39% = 0 
    40 - 59% = 1 
    60 - 79% = 22 
    80 - 99% = 12 
 
    Index FB_ERRORS_GDS_CODE (0) 
    Root page: 398, depth: 2, leaf buckets: 2, nodes: 2182 
    Average node length: 4.40, total dup: 756, max dup: 1 
    Average key length: 2.67, compression ratio: 1.87 
    Average prefix length: 4.33, average data length: 0.67 
    Clustering factor: 1518, ratio: 0.70 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 0 
        40 - 59% = 1 
        60 - 79% = 1 
        80 - 99% = 0 
 
INVNT_SALDO (145) 
    Primary pointer page: 514, Index root page: 515 
    Total formats: 2, used formats: 1 
    Average record length: 83.20, total records: 400 
    Average version length: 24.38, total versions: 3445, max versions: 12 
    Average fragment length: 2.00, total fragments: 7, max fragments: 1 
    Average unpacked length: 104.00, compression ratio: 1.25 
    Pointer pages: 1, data page slots: 48 
    Data pages: 48, average fill: 48% 
    Primary pages: 11, secondary pages: 37, swept pages: 0 
    Empty pages: 4, full pages: 22 
    Fill distribution: 
     0 - 19% = 21 
    20 - 39% = 4 
    40 - 59% = 1 
    60 - 79% = 0 
    80 - 99% = 22 
 
    Index PK_INVNT_SALDO (0) 
    Root page: 1510371, depth: 1, leaf buckets: 1, nodes: 400 
    Average node length: 11.22, total dup: 0, max dup: 0 
    Average key length: 10.22, compression ratio: 0.88 
    Average prefix length: 1.78, average data length: 7.22 
    Clustering factor: 326, ratio: 0.81 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 0 
        40 - 59% = 1 
        60 - 79% = 0 
        80 - 99% = 0 
 
INVNT_TURNOVER_LOG (153) 
    Primary pointer page: 530, Index root page: 531 
    Total formats: 1, used formats: 1 
    Average record length: 12.89, total records: 117143 
    Average version length: 68.30, total versions: 109453, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 88.00, compression ratio: 6.83 
    Pointer pages: 7, data page slots: 2736 
    Data pages: 2464, average fill: 65% 
    Primary pages: 2463, secondary pages: 1, swept pages: 0 
    Empty pages: 421, full pages: 1511 
    Fill distribution: 
     0 - 19% = 562 
    20 - 39% = 140 
    40 - 59% = 154 
    60 - 79% = 190 
    80 - 99% = 1418 
 
    Index INVNT_TURNOVER_LOG_WARE_DD_ID (0) 
    Root page: 1696962, depth: 3, leaf buckets: 352, nodes: 117143 
    Average node length: 13.23, total dup: 9704, max dup: 2 
    Average key length: 10.60, compression ratio: 2.55 
    Average prefix length: 19.31, average data length: 7.69 
    Clustering factor: 85111, ratio: 0.73 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 21 
        40 - 59% = 239 
        60 - 79% = 69 
        80 - 99% = 22 
 
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: 302, max versions: 9 
    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: 7 
    Data pages: 7, average fill: 17% 
    Primary pages: 1, secondary pages: 6, swept pages: 0 
    Empty pages: 0, full pages: 1 
    Fill distribution: 
     0 - 19% = 6 
    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.09, total records: 2360 
    Average version length: 43.76, total versions: 2287, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 58.00, compression ratio: 5.75 
    Pointer pages: 1, data page slots: 40 
    Data pages: 40, average fill: 64% 
    Primary pages: 38, secondary pages: 2, swept pages: 0 
    Empty pages: 2, full pages: 22 
    Fill distribution: 
     0 - 19% = 6 
    20 - 39% = 6 
    40 - 59% = 6 
    60 - 79% = 1 
    80 - 99% = 21 
 
    Index MONEY_TURNOVER_LOG_AGENT_OPTYPE (0) 
    Root page: 90784, depth: 2, leaf buckets: 3, nodes: 2360 
    Average node length: 4.14, total dup: 2262, max dup: 264 
    Average key length: 2.45, compression ratio: 7.76 
    Average prefix length: 18.59, average data length: 0.41 
    Clustering factor: 1235, ratio: 0.52 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 1 
        40 - 59% = 2 
        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.63, 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.62, total records: 888251 
    Average version length: 37.87, total versions: 42362, max versions: 3 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 54.00, compression ratio: 1.52 
    Pointer pages: 6, data page slots: 9024 
    Data pages: 9024, average fill: 67% 
    Primary pages: 9022, secondary pages: 2, swept pages: 912 
    Empty pages: 11, full pages: 8910 
    Fill distribution: 
     0 - 19% = 20 
    20 - 39% = 9 
    40 - 59% = 14 
    60 - 79% = 8890 
    80 - 99% = 91 
 
    Index PDISTR_AGENT_ID (2) 
    Root page: 1509330, depth: 2, leaf buckets: 924, nodes: 860540 
    Average node length: 4.89, total dup: 860491, max dup: 171550 
    Average key length: 2.01, compression ratio: 4.48 
    Average prefix length: 8.99, average data length: 0.01 
    Clustering factor: 95669, ratio: 0.11 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 123 
        40 - 59% = 499 
        60 - 79% = 200 
        80 - 99% = 101 
 
    Index PDISTR_SNDOP_RCVOP_SNDID_ASC (0) 
    Root page: 1508635, depth: 3, leaf buckets: 1018, nodes: 860540 
    Average node length: 5.90, total dup: 766124, max dup: 42 
    Average key length: 3.02, compression ratio: 7.29 
    Average prefix length: 21.09, average data length: 0.91 
    Clustering factor: 171891, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 29 
        40 - 59% = 627 
        60 - 79% = 103 
        80 - 99% = 258 
 
    Index PDISTR_SNDOP_RCVOP_SNDID_DESC (1) 
    Root page: 1509209, depth: 3, leaf buckets: 1059, nodes: 860540 
    Average node length: 5.90, total dup: 766124, max dup: 42 
    Average key length: 3.02, compression ratio: 7.28 
    Average prefix length: 21.09, average data length: 0.91 
    Clustering factor: 173827, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 65 
        40 - 59% = 655 
        60 - 79% = 103 
        80 - 99% = 236 
 
    Index PDISTR_WORKER_SND_ID (3) 
    Root page: 1510200, depth: 3, leaf buckets: 1190, nodes: 860540 
    Average node length: 5.98, total dup: 766124, max dup: 42 
    Average key length: 3.10, compression ratio: 5.48 
    Average prefix length: 16.01, average data length: 0.99 
    Clustering factor: 165775, ratio: 0.19 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 194 
        40 - 59% = 679 
        60 - 79% = 223 
        80 - 99% = 93 
 
PERF_AGG (158) 
    Primary pointer page: 540, Index root page: 541 
    Total formats: 1, used formats: 1 
    Average record length: 62.69, total records: 5415 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 3.79, total fragments: 28, max fragments: 1 
    Average unpacked length: 379.00, compression ratio: 6.05 
    Pointer pages: 1, data page slots: 88 
    Data pages: 87, average fill: 61% 
    Primary pages: 74, secondary pages: 13, swept pages: 48 
    Empty pages: 7, full pages: 51 
    Fill distribution: 
     0 - 19% = 13 
    20 - 39% = 0 
    40 - 59% = 3 
    60 - 79% = 71 
    80 - 99% = 0 
 
    Index PERF_AGG_UNQ (1) 
    Root page: 1504260, depth: 2, leaf buckets: 7, nodes: 5415 
    Average node length: 5.52, total dup: 0, max dup: 0 
    Average key length: 3.59, compression ratio: 10.00 
    Average prefix length: 34.33, average data length: 1.55 
    Clustering factor: 5152, ratio: 0.95 
    Fill distribution: 
         0 - 19% = 1 
        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: 5415 
    Average node length: 11.14, total dup: 0, max dup: 0 
    Average key length: 9.21, compression ratio: 0.98 
    Average prefix length: 2.79, average data length: 6.21 
    Clustering factor: 155, 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.05, total records: 79668 
    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% = 5 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 827 
    80 - 99% = 0 
 
    Index PK_PERF_ESTIMATED (0) 
    Root page: 30822, depth: 2, leaf buckets: 102, nodes: 79668 
    Average node length: 10.17, total dup: 0, max dup: 0 
    Average key length: 8.18, compression ratio: 1.10 
    Average prefix length: 3.82, average data length: 5.18 
    Clustering factor: 3168, ratio: 0.04 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 0 
        40 - 59% = 3 
        60 - 79% = 0 
        80 - 99% = 99 
 
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.07, 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.22 
    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: 151.11, total records: 156887 
    Average version length: 133.20, total versions: 35, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.22 
    Pointer pages: 6, data page slots: 4024 
    Data pages: 3872, average fill: 83% 
    Primary pages: 3871, secondary pages: 1, swept pages: 5 
    Empty pages: 13, full pages: 3852 
    Fill distribution: 
     0 - 19% = 16 
    20 - 39% = 3 
    40 - 59% = 0 
    60 - 79% = 1 
    80 - 99% = 3852 
 
PERF_SPLIT_1 (282) 
    Primary pointer page: 603, Index root page: 604 
    Total formats: 1, used formats: 1 
    Average record length: 142.65, total records: 148200 
    Average version length: 155.05, total versions: 8665, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.89 
    Pointer pages: 6, data page slots: 4616 
    Data pages: 3664, average fill: 84% 
    Primary pages: 3661, secondary pages: 3, swept pages: 3 
    Empty pages: 19, full pages: 3636 
    Fill distribution: 
     0 - 19% = 22 
    20 - 39% = 2 
    40 - 59% = 1 
    60 - 79% = 2 
    80 - 99% = 3637 
 
PERF_SPLIT_2 (283) 
    Primary pointer page: 605, Index root page: 606 
    Total formats: 1, used formats: 1 
    Average record length: 149.20, total records: 159070 
    Average version length: 153.26, total versions: 2058, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.37 
    Pointer pages: 7, data page slots: 4024 
    Data pages: 3944, average fill: 83% 
    Primary pages: 3941, secondary pages: 3, swept pages: 2 
    Empty pages: 34, full pages: 3898 
    Fill distribution: 
     0 - 19% = 41 
    20 - 39% = 4 
    40 - 59% = 0 
    60 - 79% = 1 
    80 - 99% = 3898 
 
PERF_SPLIT_3 (284) 
    Primary pointer page: 607, Index root page: 616 
    Total formats: 1, used formats: 1 
    Average record length: 146.78, total records: 138462 
    Average version length: 153.77, total versions: 3971, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.56 
    Pointer pages: 5, data page slots: 3896 
    Data pages: 3424, average fill: 84% 
    Primary pages: 3422, secondary pages: 2, swept pages: 1 
    Empty pages: 21, full pages: 3396 
    Fill distribution: 
     0 - 19% = 25 
    20 - 39% = 2 
    40 - 59% = 1 
    60 - 79% = 0 
    80 - 99% = 3396 
 
PERF_SPLIT_4 (285) 
    Primary pointer page: 617, Index root page: 618 
    Total formats: 1, used formats: 1 
    Average record length: 150.07, total records: 161277 
    Average version length: 153.19, total versions: 1539, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.30 
    Pointer pages: 7, data page slots: 4760 
    Data pages: 3992, average fill: 83% 
    Primary pages: 3989, secondary pages: 3, swept pages: 2 
    Empty pages: 19, full pages: 3964 
    Fill distribution: 
     0 - 19% = 20 
    20 - 39% = 4 
    40 - 59% = 3 
    60 - 79% = 1 
    80 - 99% = 3964 
 
PERF_SPLIT_5 (286) 
    Primary pointer page: 619, Index root page: 620 
    Total formats: 1, used formats: 1 
    Average record length: 149.77, total records: 153695 
    Average version length: 152.58, total versions: 1502, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.32 
    Pointer pages: 6, data page slots: 4008 
    Data pages: 3816, average fill: 83% 
    Primary pages: 3813, secondary pages: 3, swept pages: 5 
    Empty pages: 36, full pages: 3772 
    Fill distribution: 
     0 - 19% = 37 
    20 - 39% = 5 
    40 - 59% = 1 
    60 - 79% = 0 
    80 - 99% = 3773 
 
PERF_SPLIT_6 (287) 
    Primary pointer page: 621, Index root page: 622 
    Total formats: 1, used formats: 1 
    Average record length: 149.33, total records: 156786 
    Average version length: 153.93, total versions: 2221, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.36 
    Pointer pages: 7, data page slots: 5216 
    Data pages: 3904, average fill: 83% 
    Primary pages: 3902, secondary pages: 2, swept pages: 3 
    Empty pages: 42, full pages: 3846 
    Fill distribution: 
     0 - 19% = 44 
    20 - 39% = 4 
    40 - 59% = 4 
    60 - 79% = 5 
    80 - 99% = 3847 
 
PERF_SPLIT_7 (288) 
    Primary pointer page: 626, Index root page: 627 
    Total formats: 1, used formats: 1 
    Average record length: 148.53, total records: 157664 
    Average version length: 154.61, total versions: 2831, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.42 
    Pointer pages: 9, data page slots: 4368 
    Data pages: 3888, average fill: 84% 
    Primary pages: 3886, secondary pages: 2, swept pages: 7 
    Empty pages: 10, full pages: 3870 
    Fill distribution: 
     0 - 19% = 14 
    20 - 39% = 2 
    40 - 59% = 1 
    60 - 79% = 1 
    80 - 99% = 3870 
 
PERF_SPLIT_8 (289) 
    Primary pointer page: 628, Index root page: 629 
    Total formats: 1, used formats: 1 
    Average record length: 147.63, total records: 167581 
    Average version length: 154.24, total versions: 4468, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.49 
    Pointer pages: 7, data page slots: 4792 
    Data pages: 4160, average fill: 83% 
    Primary pages: 4158, secondary pages: 2, swept pages: 1 
    Empty pages: 32, full pages: 4119 
    Fill distribution: 
     0 - 19% = 34 
    20 - 39% = 3 
    40 - 59% = 1 
    60 - 79% = 2 
    80 - 99% = 4120 
 
PERF_SPLIT_9 (290) 
    Primary pointer page: 630, Index root page: 631 
    Total formats: 1, used formats: 1 
    Average record length: 147.39, total records: 152495 
    Average version length: 154.41, total versions: 3883, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.51 
    Pointer pages: 6, data page slots: 4368 
    Data pages: 3784, average fill: 83% 
    Primary pages: 3782, secondary pages: 2, swept pages: 2 
    Empty pages: 35, full pages: 3740 
    Fill distribution: 
     0 - 19% = 37 
    20 - 39% = 4 
    40 - 59% = 2 
    60 - 79% = 1 
    80 - 99% = 3740 
 
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: 51.23, total records: 2084796 
    Average version length: 52.89, total versions: 72073, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 70.00, compression ratio: 1.37 
    Pointer pages: 16, data page slots: 25736 
    Data pages: 25736, average fill: 70% 
    Primary pages: 25718, secondary pages: 18, swept pages: 9241 
    Empty pages: 232, full pages: 22864 
    Fill distribution: 
     0 - 19% = 440 
    20 - 39% = 350 
    40 - 59% = 794 
    60 - 79% = 23405 
    80 - 99% = 747 
 
    Index PSTORNED_RCV_ID (1) 
    Root page: 1506208, depth: 3, leaf buckets: 2568, nodes: 2084796 
    Average node length: 5.44, total dup: 1944847, max dup: 1385 
    Average key length: 2.49, compression ratio: 3.62 
    Average prefix length: 8.58, average data length: 0.42 
    Clustering factor: 181281, ratio: 0.09 
    Fill distribution: 
         0 - 19% = 5 
        20 - 39% = 300 
        40 - 59% = 1665 
        60 - 79% = 309 
        80 - 99% = 289 
 
    Index PSTORNED_SND_ID (0) 
    Root page: 1504841, depth: 3, leaf buckets: 2752, nodes: 2084796 
    Average node length: 5.69, total dup: 1871686, max dup: 65 
    Average key length: 2.74, compression ratio: 3.29 
    Average prefix length: 8.36, average data length: 0.64 
    Clustering factor: 373497, ratio: 0.18 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 5 
        40 - 59% = 2471 
        60 - 79% = 251 
        80 - 99% = 25 
 
    Index PSTORNED_WORKER_ID (2) 
    Root page: 1508018, depth: 3, leaf buckets: 2103, nodes: 2084796 
    Average node length: 4.96, total dup: 2084696, max dup: 28704 
    Average key length: 2.00, compression ratio: 1.20 
    Average prefix length: 2.40, average data length: 0.00 
    Clustering factor: 179341, ratio: 0.09 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 189 
        40 - 59% = 1138 
        60 - 79% = 346 
        80 - 99% = 430 
 
RULES_FOR_PDISTR (148) 
    Primary pointer page: 520, Index root page: 521 
    Total formats: 1, used formats: 1 
    Average record length: 17.00, total records: 4 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 334.00, compression ratio: 19.65 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 2% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index RULES_FOR_PDISTR_UNQ (0) 
    Root page: 1504339, depth: 1, leaf buckets: 1, nodes: 4 
    Average node length: 11.50, total dup: 0, max dup: 0 
    Average key length: 10.25, compression ratio: 0.88 
    Average prefix length: 1.50, average data length: 7.50 
    Clustering factor: 1, ratio: 0.25 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
RULES_FOR_QDISTR (137) 
    Primary pointer page: 498, Index root page: 499 
    Total formats: 1, used formats: 1 
    Average record length: 32.71, total records: 7 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 332.00, compression ratio: 10.15 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 4% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index RULES_FOR_QDISTR_RCVOP (1) 
    Root page: 1544825, depth: 1, leaf buckets: 1, nodes: 7 
    Average node length: 5.29, total dup: 2, max dup: 2 
    Average key length: 4.14, compression ratio: 0.72 
    Average prefix length: 1.43, average data length: 1.57 
    Clustering factor: 1, ratio: 0.14 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index RULES_FOR_QDISTR_UNQ (0) 
    Root page: 1544824, depth: 1, leaf buckets: 1, nodes: 7 
    Average node length: 10.14, total dup: 0, max dup: 0 
    Average key length: 8.86, compression ratio: 0.94 
    Average prefix length: 2.14, average data length: 6.14 
    Clustering factor: 1, ratio: 0.14 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
SEMAPHORES (152) 
    Primary pointer page: 528, Index root page: 529 
    Total formats: 1, used formats: 1 
    Average record length: 43.40, total records: 5 
    Average version length: 9.00, total versions: 1, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 346.00, compression ratio: 7.97 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 4% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index PK_SEMAPHORES (0) 
    Root page: 1504327, depth: 1, leaf buckets: 1, nodes: 5 
    Average node length: 12.40, total dup: 0, max dup: 0 
    Average key length: 11.00, compression ratio: 0.82 
    Average prefix length: 0.60, average data length: 8.40 
    Clustering factor: 1, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index SEMAPHORES_TASK_UNQ (1) 
    Root page: 1504328, depth: 1, leaf buckets: 1, nodes: 5 
    Average node length: 23.40, total dup: 0, max dup: 0 
    Average key length: 22.00, compression ratio: 1.07 
    Average prefix length: 4.20, average data length: 19.40 
    Clustering factor: 1, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
SETTINGS (135) 
    Primary pointer page: 494, Index root page: 495 
    Total formats: 1, used formats: 1 
    Average record length: 97.62, total records: 149 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1347.00, compression ratio: 13.80 
    Pointer pages: 1, data page slots: 3 
    Data pages: 3, average fill: 70% 
    Primary pages: 3, secondary pages: 0, swept pages: 1 
    Empty pages: 0, full pages: 2 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 1 
    60 - 79% = 0 
    80 - 99% = 2 
 
    Index SETTINGS_MCODE_WM_UNQ (1) 
    Root page: 1544931, depth: 1, leaf buckets: 1, nodes: 149 
    Average node length: 14.66, total dup: 0, max dup: 0 
    Average key length: 13.55, compression ratio: 2.19 
    Average prefix length: 19.07, average data length: 10.66 
    Clustering factor: 48, ratio: 0.32 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 1 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index SETTINGS_MODE_CODE (0) 
    Root page: 1544828, depth: 1, leaf buckets: 1, nodes: 149 
    Average node length: 25.56, total dup: 0, max dup: 0 
    Average key length: 24.56, compression ratio: 1.63 
    Average prefix length: 18.58, average data length: 21.56 
    Clustering factor: 14, ratio: 0.09 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 0 
        40 - 59% = 1 
        60 - 79% = 0 
        80 - 99% = 0 
 
TMP$DEP_DOCS (129) 
    Primary pointer page: 482, Index root page: 483 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index TMP_DEP_DOCS_UNQ (0) 
    Root page: 1544832, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
TMP$IDX_RECALC (132) 
    Primary pointer page: 488, Index root page: 489 
    Total formats: 2, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index TMP_IDX_RECALC_IDX_NAME_UNQ (0) 
    Root page: 1544829, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
TMP$MON_LOG (133) 
    Primary pointer page: 490, Index root page: 491 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
TMP$MON_LOG_TABLE_STATS (134) 
    Primary pointer page: 492, Index root page: 493 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
TMP$PERF_EST_WHOLE (161) 
    Primary pointer page: 546, Index root page: 547 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
TMP$PERF_LOG (160) 
    Primary pointer page: 544, Index root page: 545 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index TMP$PERF_LOG_UNIT_TRN_DTS_END (0) 
    Root page: 1504252, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
TMP$PERF_MON (131) 
    Primary pointer page: 486, Index root page: 487 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
TMP$RESULT_SET (130) 
    Primary pointer page: 484, Index root page: 485 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index TMP_RESULT_SET_DOC (1) 
    Root page: 1544831, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index TMP_RESULT_SET_WARE_DOC (0) 
    Root page: 1544830, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
TMP$SHOPPING_CART (128) 
    Primary pointer page: 480, Index root page: 481 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index TMP_SHOPCART_UNQ (0) 
    Root page: 1544833, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
TPAUSE (166) 
    Primary pointer page: 557, Index root page: 558 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index RDB$PRIMARY2 (0) 
    Root page: 1504237, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
TRACE_STAT (157) 
    Primary pointer page: 538, Index root page: 539 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
WARES (142) 
    Primary pointer page: 508, Index root page: 509 
    Total formats: 1, used formats: 1 
    Average record length: 77.52, total records: 400 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 444.00, compression ratio: 5.73 
    Pointer pages: 1, data page slots: 6 
    Data pages: 6, average fill: 77% 
    Primary pages: 6, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 5 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 5 
    80 - 99% = 1 
 
    Index FK_WARES_WARE_GROUPS (3) 
    Root page: 1552183, depth: 1, leaf buckets: 1, nodes: 400 
    Average node length: 3.17, total dup: 392, max dup: 60 
    Average key length: 2.16, compression ratio: 4.16 
    Average prefix length: 8.86, average data length: 0.14 
    Clustering factor: 48, ratio: 0.12 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PK_WARES (0) 
    Root page: 1510377, depth: 1, leaf buckets: 1, nodes: 400 
    Average node length: 11.22, total dup: 0, max dup: 0 
    Average key length: 10.22, compression ratio: 0.88 
    Average prefix length: 1.78, average data length: 7.22 
    Clustering factor: 344, ratio: 0.86 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 0 
        40 - 59% = 1 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index WARES_ID_DESC (2) 
    Root page: 1510382, depth: 1, leaf buckets: 1, nodes: 400 
    Average node length: 11.22, total dup: 0, max dup: 0 
    Average key length: 10.22, compression ratio: 0.88 
    Average prefix length: 1.78, average data length: 7.22 
    Clustering factor: 344, ratio: 0.86 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 0 
        40 - 59% = 1 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index WARES_NUMB_UNQ (1) 
    Root page: 1510380, depth: 2, leaf buckets: 3, nodes: 400 
    Average node length: 53.25, total dup: 0, max dup: 0 
    Average key length: 52.23, compression ratio: 1.00 
    Average prefix length: 2.74, average data length: 49.25 
    Clustering factor: 355, ratio: 0.89 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 1 
        80 - 99% = 2 
 
WARE_GROUPS (151) 
    Primary pointer page: 526, Index root page: 527 
    Total formats: 1, used formats: 1 
    Average record length: 32.12, total records: 8 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 346.00, compression ratio: 10.77 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 5% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index PK_WARE_GROUPS (0) 
    Root page: 1504329, depth: 1, leaf buckets: 1, nodes: 8 
    Average node length: 11.25, total dup: 0, max dup: 0 
    Average key length: 10.12, compression ratio: 0.89 
    Average prefix length: 1.75, average data length: 7.25 
    Clustering factor: 1, ratio: 0.12 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index WARE_GROUPS_NAME_UNQ (1) 
    Root page: 1504330, depth: 1, leaf buckets: 1, nodes: 8 
    Average node length: 19.88, total dup: 0, max dup: 0 
    Average key length: 18.12, compression ratio: 0.89 
    Average prefix length: 0.25, average data length: 15.88 
    Clustering factor: 1, ratio: 0.12 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
XQD_1000_1200 (176) 
    Primary pointer page: 577, Index root page: 578 
    Total formats: 1, used formats: 1 
    Average record length: 40.33, total records: 160611 
    Average version length: 69.19, total versions: 77045, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 3.12 
    Pointer pages: 3, data page slots: 4232 
    Data pages: 3176, average fill: 62% 
    Primary pages: 3175, secondary pages: 1, swept pages: 389 
    Empty pages: 559, full pages: 2164 
    Fill distribution: 
     0 - 19% = 695 
    20 - 39% = 58 
    40 - 59% = 108 
    60 - 79% = 984 
    80 - 99% = 1331 
 
    Index XQD_1000_1200_WA_SO_RO_WKR_SND (0) 
    Root page: 1559173, depth: 3, leaf buckets: 237, nodes: 160611 
    Average node length: 6.45, total dup: 139948, max dup: 29 
    Average key length: 3.91, compression ratio: 10.75 
    Average prefix length: 40.22, average data length: 1.78 
    Clustering factor: 28421, ratio: 0.18 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 37 
        40 - 59% = 121 
        60 - 79% = 61 
        80 - 99% = 18 
 
XQD_1000_3300 (178) 
    Primary pointer page: 581, Index root page: 582 
    Total formats: 1, used formats: 1 
    Average record length: 64.08, total records: 7627361 
    Average version length: 68.77, total versions: 618719, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.97 
    Pointer pages: 68, data page slots: 110032 
    Data pages: 110032, average fill: 75% 
    Primary pages: 110031, secondary pages: 1, swept pages: 7617 
    Empty pages: 2, full pages: 105186 
    Fill distribution: 
     0 - 19% = 35 
    20 - 39% = 244 
    40 - 59% = 1216 
    60 - 79% = 104594 
    80 - 99% = 3943 
 
    Index XQD_1000_3300_WA_SO_RO_WKR_SND (0) 
    Root page: 1480476, depth: 3, leaf buckets: 10878, nodes: 7627361 
    Average node length: 6.50, total dup: 6603350, max dup: 29 
    Average key length: 3.51, compression ratio: 11.97 
    Average prefix length: 40.63, average data length: 1.37 
    Clustering factor: 1788752, ratio: 0.23 
    Fill distribution: 
         0 - 19% = 6 
        20 - 39% = 1113 
        40 - 59% = 5517 
        60 - 79% = 3601 
        80 - 99% = 641 
 
    Index XQD_1000_3300_WKR_DOC_ASC (1) 
    Root page: 1486090, depth: 3, leaf buckets: 8907, nodes: 7627361 
    Average node length: 5.38, total dup: 7337062, max dup: 185 
    Average key length: 2.39, compression ratio: 7.12 
    Average prefix length: 16.65, average data length: 0.35 
    Clustering factor: 1564193, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 12 
        20 - 39% = 881 
        40 - 59% = 5050 
        60 - 79% = 1798 
        80 - 99% = 1166 
 
    Index XQD_1000_3300_WKR_DOC_DEC (2) 
    Root page: 1490630, depth: 3, leaf buckets: 8970, nodes: 7627361 
    Average node length: 5.38, total dup: 7337062, max dup: 185 
    Average key length: 2.39, compression ratio: 7.12 
    Average prefix length: 16.65, average data length: 0.35 
    Clustering factor: 1566612, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 5 
        20 - 39% = 964 
        40 - 59% = 5041 
        60 - 79% = 1810 
        80 - 99% = 1150 
 
XQD_1200_2000 (177) 
    Primary pointer page: 579, Index root page: 580 
    Total formats: 1, used formats: 1 
    Average record length: 66.38, total records: 12442284 
    Average version length: 68.70, total versions: 527868, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.90 
    Pointer pages: 109, data page slots: 177560 
    Data pages: 177560, average fill: 75% 
    Primary pages: 177559, secondary pages: 1, swept pages: 44577 
    Empty pages: 3, full pages: 174254 
    Fill distribution: 
     0 - 19% = 42 
    20 - 39% = 261 
    40 - 59% = 978 
    60 - 79% = 171464 
    80 - 99% = 4815 
 
    Index XQD_1200_2000_WA_SO_RO_WKR_SND (0) 
    Root page: 1495050, depth: 3, leaf buckets: 18532, nodes: 12437622 
    Average node length: 6.63, total dup: 10844841, max dup: 69 
    Average key length: 3.42, compression ratio: 12.27 
    Average prefix length: 40.71, average data length: 1.29 
    Clustering factor: 2530735, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 25 
        20 - 39% = 1806 
        40 - 59% = 10504 
        60 - 79% = 5306 
        80 - 99% = 891 
 
XQD_2000_3300 (179) 
    Primary pointer page: 583, Index root page: 584 
    Total formats: 1, used formats: 1 
    Average record length: 40.33, total records: 2150476 
    Average version length: 69.07, total versions: 581033, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 3.12 
    Pointer pages: 30, data page slots: 46704 
    Data pages: 30376, average fill: 70% 
    Primary pages: 30321, secondary pages: 55, swept pages: 619 
    Empty pages: 5, full pages: 30315 
    Fill distribution: 
     0 - 19% = 53 
    20 - 39% = 4538 
    40 - 59% = 1918 
    60 - 79% = 14622 
    80 - 99% = 9245 
 
    Index XQD_2000_3300_WA_SO_RO_WKR_SND (0) 
    Root page: 1479735, depth: 3, leaf buckets: 1960, nodes: 1701173 
    Average node length: 5.51, total dup: 1632777, max dup: 49 
    Average key length: 2.55, compression ratio: 16.49 
    Average prefix length: 41.49, average data length: 0.51 
    Clustering factor: 123783, ratio: 0.07 
    Fill distribution: 
         0 - 19% = 11 
        20 - 39% = 144 
        40 - 59% = 890 
        60 - 79% = 659 
        80 - 99% = 256 
 
XQD_2100_3300 (180) 
    Primary pointer page: 585, Index root page: 586 
    Total formats: 1, used formats: 1 
    Average record length: 32.44, total records: 1696013 
    Average version length: 69.04, total versions: 184512, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 3.88 
    Pointer pages: 23, data page slots: 36000 
    Data pages: 28920, average fill: 43% 
    Primary pages: 28919, secondary pages: 1, swept pages: 5001 
    Empty pages: 5759, full pages: 16314 
    Fill distribution: 
     0 - 19% = 8001 
    20 - 39% = 2850 
    40 - 59% = 6973 
    60 - 79% = 10493 
    80 - 99% = 603 
 
    Index XQD_2100_3300_WA_SO_RO_WKR_SND (0) 
    Root page: 1479229, depth: 3, leaf buckets: 1205, nodes: 847189 
    Average node length: 5.96, total dup: 779432, max dup: 69 
    Average key length: 3.02, compression ratio: 13.92 
    Average prefix length: 41.06, average data length: 0.94 
    Clustering factor: 127516, ratio: 0.15 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 256 
        40 - 59% = 593 
        60 - 79% = 306 
        80 - 99% = 50 
 
XQD_3300_3400 (181) 
    Primary pointer page: 587, Index root page: 588 
    Total formats: 1, used formats: 1 
    Average record length: 63.82, total records: 9250829 
    Average version length: 68.98, total versions: 771176, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.97 
    Pointer pages: 91, data page slots: 147200 
    Data pages: 147160, average fill: 68% 
    Primary pages: 147135, secondary pages: 25, swept pages: 28669 
    Empty pages: 375, full pages: 101588 
    Fill distribution: 
     0 - 19% = 1494 
    20 - 39% = 9167 
    40 - 59% = 20883 
    60 - 79% = 108142 
    80 - 99% = 7474 
 
    Index XQD_3300_3400_WA_SO_RO_WKR_SND (0) 
    Root page: 1472612, depth: 3, leaf buckets: 13442, nodes: 9238770 
    Average node length: 6.69, total dup: 7665665, max dup: 14 
    Average key length: 3.66, compression ratio: 11.46 
    Average prefix length: 40.51, average data length: 1.49 
    Clustering factor: 2040333, ratio: 0.22 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 1094 
        40 - 59% = 6790 
        60 - 79% = 4897 
        80 - 99% = 660 
 
XQS_1000_1200 (182) 
    Primary pointer page: 589, Index root page: 590 
    Total formats: 1, used formats: 1 
    Average record length: 82.45, total records: 21168283 
    Average version length: 82.89, total versions: 26147, 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: 197, data page slots: 319888 
    Data pages: 319888, average fill: 81% 
    Primary pages: 319883, secondary pages: 5, swept pages: 11059 
    Empty pages: 0, full pages: 319883 
    Fill distribution: 
     0 - 19% = 2 
    20 - 39% = 3 
    40 - 59% = 0 
    60 - 79% = 48298 
    80 - 99% = 271585 
 
    Index XQS_1000_1200_DOC_ID (1) 
    Root page: 1426738, depth: 3, leaf buckets: 19771, nodes: 21168283 
    Average node length: 5.72, total dup: 20687051, max dup: 142 
    Average key length: 2.16, compression ratio: 4.16 
    Average prefix length: 8.86, average data length: 0.14 
    Clustering factor: 3287783, ratio: 0.16 
    Fill distribution: 
         0 - 19% = 11 
        20 - 39% = 1 
        40 - 59% = 8907 
        60 - 79% = 542 
        80 - 99% = 10310 
 
    Index XQS_1000_1200_RCV_ID (3) 
    Root page: 1457002, depth: 3, leaf buckets: 17191, nodes: 21168283 
    Average node length: 6.31, total dup: 18602917, max dup: 49 
    Average key length: 2.75, compression ratio: 3.27 
    Average prefix length: 8.37, average data length: 0.63 
    Clustering factor: 918490, ratio: 0.04 
    Fill distribution: 
         0 - 19% = 5 
        20 - 39% = 5 
        40 - 59% = 788 
        60 - 79% = 264 
        80 - 99% = 16129 
 
    Index XQS_1000_1200_SND_ID (2) 
    Root page: 1441095, depth: 3, leaf buckets: 21512, nodes: 21168283 
    Average node length: 6.35, total dup: 18522075, max dup: 29 
    Average key length: 2.79, compression ratio: 3.23 
    Average prefix length: 8.34, average data length: 0.66 
    Clustering factor: 3582018, ratio: 0.17 
    Fill distribution: 
         0 - 19% = 9 
        20 - 39% = 0 
        40 - 59% = 9107 
        60 - 79% = 570 
        80 - 99% = 11826 
 
    Index XQS_1000_1200_WORKER_ID (0) 
    Root page: 1413370, depth: 3, leaf buckets: 16096, nodes: 21168283 
    Average node length: 5.56, total dup: 21168183, max dup: 229487 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.42, average data length: 0.00 
    Clustering factor: 947275, ratio: 0.04 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 5 
        40 - 59% = 2853 
        60 - 79% = 399 
        80 - 99% = 12837 
 
XQS_1000_3300 (184) 
    Primary pointer page: 593, Index root page: 594 
    Total formats: 1, used formats: 1 
    Average record length: 76.85, total records: 9645737 
    Average version length: 82.61, total versions: 729418, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.64 
    Pointer pages: 107, data page slots: 174008 
    Data pages: 173968, average fill: 69% 
    Primary pages: 173927, secondary pages: 41, swept pages: 50566 
    Empty pages: 1000, full pages: 112503 
    Fill distribution: 
     0 - 19% = 2795 
    20 - 39% = 10756 
    40 - 59% = 25354 
    60 - 79% = 104603 
    80 - 99% = 30460 
 
    Index XQS_1000_3300_DOC_ID (1) 
    Root page: 1367524, depth: 3, leaf buckets: 11324, nodes: 9645737 
    Average node length: 5.37, total dup: 9339427, max dup: 202 
    Average key length: 2.23, compression ratio: 4.03 
    Average prefix length: 8.80, average data length: 0.20 
    Clustering factor: 2140901, ratio: 0.22 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 82 
        40 - 59% = 8223 
        60 - 79% = 2952 
        80 - 99% = 67 
 
    Index XQS_1000_3300_RCV_ID (3) 
    Root page: 1379283, depth: 3, leaf buckets: 13480, nodes: 9645737 
    Average node length: 6.24, total dup: 7999119, max dup: 14 
    Average key length: 3.10, compression ratio: 2.90 
    Average prefix length: 8.07, average data length: 0.93 
    Clustering factor: 1493230, ratio: 0.15 
    Fill distribution: 
         0 - 19% = 143 
        20 - 39% = 3743 
        40 - 59% = 4591 
        60 - 79% = 2675 
        80 - 99% = 2328 
 
    Index XQS_1000_3300_SND_ID (2) 
    Root page: 1373081, depth: 3, leaf buckets: 12636, nodes: 9645737 
    Average node length: 5.98, total dup: 8377277, max dup: 44 
    Average key length: 2.84, compression ratio: 3.16 
    Average prefix length: 8.29, average data length: 0.71 
    Clustering factor: 2337647, ratio: 0.24 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 90 
        40 - 59% = 9214 
        60 - 79% = 3246 
        80 - 99% = 84 
 
    Index XQS_1000_3300_WORKER_ID (0) 
    Root page: 1362789, depth: 3, leaf buckets: 9994, nodes: 9645737 
    Average node length: 5.14, total dup: 9645637, max dup: 163039 
    Average key length: 2.00, compression ratio: 1.20 
    Average prefix length: 2.41, average data length: 0.00 
    Clustering factor: 1525721, ratio: 0.16 
    Fill distribution: 
         0 - 19% = 46 
        20 - 39% = 1176 
        40 - 59% = 4890 
        60 - 79% = 1736 
        80 - 99% = 2146 
 
XQS_1200_2000 (183) 
    Primary pointer page: 591, Index root page: 592 
    Total formats: 1, used formats: 1 
    Average record length: 78.44, total records: 11411671 
    Average version length: 82.53, total versions: 600156, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.61 
    Pointer pages: 118, data page slots: 192512 
    Data pages: 191304, average fill: 74% 
    Primary pages: 191137, secondary pages: 167, swept pages: 52660 
    Empty pages: 2477, full pages: 155252 
    Fill distribution: 
     0 - 19% = 4153 
    20 - 39% = 5819 
    40 - 59% = 13862 
    60 - 79% = 96739 
    80 - 99% = 70731 
 
    Index XQS_1200_2000_DOC_ID (1) 
    Root page: 1392123, depth: 3, leaf buckets: 13130, nodes: 11411671 
    Average node length: 5.30, total dup: 11302352, max dup: 702 
    Average key length: 2.08, compression ratio: 4.33 
    Average prefix length: 8.93, average data length: 0.07 
    Clustering factor: 2387463, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 100 
        40 - 59% = 9000 
        60 - 79% = 3880 
        80 - 99% = 148 
 
    Index XQS_1200_2000_RCV_ID (3) 
    Root page: 1406132, depth: 3, leaf buckets: 10493, nodes: 11411671 
    Average node length: 5.49, total dup: 10914138, max dup: 49 
    Average key length: 2.28, compression ratio: 3.95 
    Average prefix length: 8.77, average data length: 0.23 
    Clustering factor: 726071, ratio: 0.06 
    Fill distribution: 
         0 - 19% = 146 
        20 - 39% = 846 
        40 - 59% = 2551 
        60 - 79% = 1836 
        80 - 99% = 5114 
 
    Index XQS_1200_2000_SND_ID (2) 
    Root page: 1398660, depth: 3, leaf buckets: 15011, nodes: 11411671 
    Average node length: 6.02, total dup: 9968158, max dup: 81 
    Average key length: 2.80, compression ratio: 3.21 
    Average prefix length: 8.33, average data length: 0.67 
    Clustering factor: 2404095, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 96 
        40 - 59% = 10610 
        60 - 79% = 4116 
        80 - 99% = 187 
 
    Index XQS_1200_2000_WORKER_ID (0) 
    Root page: 1386233, depth: 3, leaf buckets: 10875, nodes: 11411671 
    Average node length: 5.22, total dup: 11411571, max dup: 199901 
    Average key length: 2.00, compression ratio: 1.20 
    Average prefix length: 2.40, average data length: 0.00 
    Clustering factor: 713534, ratio: 0.06 
    Fill distribution: 
         0 - 19% = 86 
        20 - 39% = 813 
        40 - 59% = 4923 
        60 - 79% = 1476 
        80 - 99% = 3577 
 
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: 77.20, total records: 9760832 
    Average version length: 82.93, total versions: 732134, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.63 
    Pointer pages: 109, data page slots: 177288 
    Data pages: 177224, average fill: 69% 
    Primary pages: 177187, secondary pages: 37, swept pages: 53413 
    Empty pages: 910, full pages: 110261 
    Fill distribution: 
     0 - 19% = 2648 
    20 - 39% = 10937 
    40 - 59% = 27054 
    60 - 79% = 106401 
    80 - 99% = 30184 
 
    Index XQS_2100_3300_DOC_ID (1) 
    Root page: 1344708, depth: 3, leaf buckets: 11732, nodes: 9760832 
    Average node length: 5.18, total dup: 9732105, max dup: 1883 
    Average key length: 2.03, compression ratio: 4.43 
    Average prefix length: 8.97, average data length: 0.03 
    Clustering factor: 1973023, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 25 
        20 - 39% = 1432 
        40 - 59% = 7780 
        60 - 79% = 1869 
        80 - 99% = 626 
 
    Index XQS_2100_3300_RCV_ID (3) 
    Root page: 1355739, depth: 3, leaf buckets: 13637, nodes: 9760832 
    Average node length: 6.25, total dup: 8093640, max dup: 14 
    Average key length: 3.10, compression ratio: 2.90 
    Average prefix length: 8.07, average data length: 0.93 
    Clustering factor: 1468196, ratio: 0.15 
    Fill distribution: 
         0 - 19% = 177 
        20 - 39% = 3803 
        40 - 59% = 4541 
        60 - 79% = 2629 
        80 - 99% = 2487 
 
    Index XQS_2100_3300_SND_ID (2) 
    Root page: 1350071, depth: 3, leaf buckets: 12339, nodes: 9760832 
    Average node length: 5.44, total dup: 9326870, max dup: 102 
    Average key length: 2.29, compression ratio: 3.94 
    Average prefix length: 8.76, average data length: 0.24 
    Clustering factor: 2106594, ratio: 0.22 
    Fill distribution: 
         0 - 19% = 24 
        20 - 39% = 1350 
        40 - 59% = 8660 
        60 - 79% = 1713 
        80 - 99% = 592 
 
    Index XQS_2100_3300_WORKER_ID (0) 
    Root page: 987843, depth: 3, leaf buckets: 10213, nodes: 9760832 
    Average node length: 5.15, total dup: 9760732, max dup: 165781 
    Average key length: 2.00, compression ratio: 1.20 
    Average prefix length: 2.41, average data length: 0.00 
    Clustering factor: 1551461, ratio: 0.16 
    Fill distribution: 
         0 - 19% = 39 
        20 - 39% = 1264 
        40 - 59% = 5118 
        60 - 79% = 1667 
        80 - 99% = 2125 
 
XQS_3300_3400 (187) 
    Primary pointer page: 599, Index root page: 600 
    Total formats: 1, used formats: 1 
    Average record length: 66.73, total records: 574970 
    Average version length: 68.78, total versions: 13866, 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: 5, data page slots: 8024 
    Data pages: 8024, average fill: 75% 
    Primary pages: 8024, secondary pages: 0, swept pages: 2532 
    Empty pages: 7, full pages: 7322 
    Fill distribution: 
     0 - 19% = 7 
    20 - 39% = 0 
    40 - 59% = 88 
    60 - 79% = 7707 
    80 - 99% = 222 
 
    Index XQS_3300_3400_DOC_ID (1) 
    Root page: 36725, depth: 3, leaf buckets: 727, nodes: 574970 
    Average node length: 5.95, total dup: 489647, max dup: 82 
    Average key length: 3.09, compression ratio: 2.91 
    Average prefix length: 8.06, average data length: 0.94 
    Clustering factor: 101086, ratio: 0.18 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 26 
        40 - 59% = 505 
        60 - 79% = 102 
        80 - 99% = 94 
 
    Index XQS_3300_3400_SND_ID (2) 
    Root page: 29388, depth: 3, leaf buckets: 762, nodes: 574970 
    Average node length: 6.15, total dup: 471611, max dup: 27 
    Average key length: 3.29, compression ratio: 2.73 
    Average prefix length: 7.89, average data length: 1.11 
    Clustering factor: 101142, ratio: 0.18 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 37 
        40 - 59% = 534 
        60 - 79% = 94 
        80 - 99% = 97 
 
    Index XQS_3300_3400_WORKER_ID (0) 
    Root page: 377587, depth: 2, leaf buckets: 558, nodes: 574970 
    Average node length: 4.86, total dup: 574870, max dup: 9771 
    Average key length: 2.00, compression ratio: 1.20 
    Average prefix length: 2.41, average data length: 0.00 
    Clustering factor: 89889, ratio: 0.16 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 35 
        40 - 59% = 312 
        60 - 79% = 69 
        80 - 99% = 142 
 
ZDOC_DATA (170) 
    Primary pointer page: 565, Index root page: 566 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
ZDOC_LIST (169) 
    Primary pointer page: 563, Index root page: 564 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
ZINVNT_TURNOVER_LOG (171) 
    Primary pointer page: 567, Index root page: 568 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
ZPDISTR (174) 
    Primary pointer page: 573, Index root page: 574 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index ZPDISTR_ID (0) 
    Root page: 1504230, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
ZPSTORNED (175) 
    Primary pointer page: 575, Index root page: 576 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index ZPSTORNED_ID (0) 
    Root page: 1504229, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
ZQDISTR (172) 
    Primary pointer page: 569, Index root page: 570 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index ZQDISTR_ID (0) 
    Root page: 1504235, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index ZQDISTR_WARE_SNDOP_RCVOP (1) 
    Root page: 1504236, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
ZQSTORNED (173) 
    Primary pointer page: 571, Index root page: 572 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index ZQSTORNED_DOC_ID (1) 
    Root page: 1504232, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index ZQSTORNED_ID (0) 
    Root page: 1504231, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index ZQSTORNED_RCV_ID (3) 
    Root page: 1504234, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index ZQSTORNED_SND_ID (2) 
    Root page: 1504233, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
ZTMP_DEP_DOCS (168) 
    Primary pointer page: 561, Index root page: 562 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
ZTMP_SHOPPING_CART (167) 
    Primary pointer page: 559, Index root page: 560 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
Z_USED_VIEWS (144) 
    Primary pointer page: 512, Index root page: 513 
    Total formats: 1, used formats: 1 
    Average record length: 29.38, total records: 29 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 99.00, compression ratio: 3.37 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 16% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index Z_USED_VIEWS_UNQ (0) 
    Root page: 1510372, depth: 1, leaf buckets: 1, nodes: 29 
    Average node length: 15.17, total dup: 0, max dup: 0 
    Average key length: 14.14, compression ratio: 1.44 
    Average prefix length: 9.17, average data length: 11.17 
    Clustering factor: 1, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
Gstat completion time Thu Mar 14 04:09:26 2024

Record versions statistics, table

TABLE_NAME TOTAL_RECS TOTAL_VERS MAX_VERSIONS VERS_TO_RECS_PRC MAXV_TO_VERS_PRC
DOC_DATA 7763962 148392 1 0.0000 0.0000
DOC_LIST 2239193 74889 2 0.0000 0.0000
FB_ERRORS 2182 757 1 0.0000 0.0000
INVNT_SALDO 400 3445 12 800.0000 0.0000
INVNT_TURNOVER_LOG 117143 109453 1 0.0000 0.0000
MONEY_SALDO 49 302 9 600.0000 0.0000
MONEY_TURNOVER_LOG 2360 2287 1 0.0000 0.0000
PDISTR 888251 42362 3 0.0000 0.0000
PERF_SPLIT_0 156887 35 1 0.0000 0.0000
PERF_SPLIT_1 148200 8665 1 0.0000 0.0000
PERF_SPLIT_2 159070 2058 1 0.0000 0.0000
PERF_SPLIT_3 138462 3971 1 0.0000 0.0000
PERF_SPLIT_4 161277 1539 1 0.0000 0.0000
PERF_SPLIT_5 153695 1502 1 0.0000 0.0000
PERF_SPLIT_6 156786 2221 1 0.0000 0.0000
PERF_SPLIT_7 157664 2831 1 0.0000 0.0000
PERF_SPLIT_8 167581 4468 1 0.0000 0.0000
PERF_SPLIT_9 152495 3883 1 0.0000 0.0000
PSTORNED 2084796 72073 1 0.0000 0.0000
SEMAPHORES 5 1 1 0.0000 100.0000
XQD_1000_1200 160611 77045 1 0.0000 0.0000
XQD_1000_3300 7627361 618719 1 0.0000 0.0000
XQD_1200_2000 12442284 527868 1 0.0000 0.0000
XQD_2000_3300 2150476 581033 1 0.0000 0.0000
XQD_2100_3300 1696013 184512 1 0.0000 0.0000
XQD_3300_3400 9250829 771176 1 0.0000 0.0000
XQS_1000_1200 21168283 26147 1 0.0000 0.0000
XQS_1000_3300 9645737 729418 1 0.0000 0.0000
XQS_1200_2000 11411671 600156 1 0.0000 0.0000
XQS_2100_3300 9760832 732134 1 0.0000 0.0000
XQS_3300_3400 574970 13866 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 ---
:29: 
:30: mscs-test-161.budzdorov.ru    Thu Mar 14 04:08:03 2024
:31:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3400
:32: 
--- end of diff output ---

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

14.03.24 04:09:38. 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-14 04:09:40 No severe PSQL-related problems occured
14.03.24 04:09:42. End of report.