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

Server and database settinfs 


SERVER_MODE                     SuperServer 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-25 10:07:49
DTS_END                         2024-03-25 10:07:49.8080
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/52094
TRN_ID                          174085
ATT_ID                          520
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: 9762.71 21465 976271
customer order: creation 180.80 394 18080
customer order: refuse 15.81 383 1581
order to supplier: creation 47.75 1297 4775
order to supplier: removal 3.63 103630 363
invoice (draft): creation 47.95 2965 4795
invoice (draft): removal 52.90 706 5290
invoice accept: apply 44.28 19285 4428
invoice accept: cancel 48.04 821 4804
customer reserve: creation 4287.81 183 428781
customer reserve: removal 4713.71 64 471371
realization accept: apply 87.71 190 8771
realization accept: cancel 97.28 139 9728
payment from customer: creation 62.58 130 6258
payment from customer: removal 5.96 86 596
payment to supplier: creation 50.55 140 5055
payment to supplier: removal 4.18 66 418
service: total inventory turnovers 3.84 4117 384
service: total monetary turnovers 6.99 419 699
service: aggregate perf. data 0.90 15451 90
service: refresh index statistics 0.04 278840 4

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:03, from 25-03-2024 10:08:29 to 25-03-2024 10:08:32.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 5251
TEST_TIME 2 4480
TEST_TIME 3 3997
TEST_TIME 4 4951
TEST_TIME 5 5323
TEST_TIME 6 5030
TEST_TIME 7 5342
TEST_TIME 8 5285
TEST_TIME 9 5250
TEST_TIME 10 5856
TEST_TIME 11 5829
TEST_TIME 12 5629
TEST_TIME 13 5824
TEST_TIME 14 6061
TEST_TIME 15 6532
TEST_TIME 16 6531
TEST_TIME 17 7028
TEST_TIME 18 7484
TEST_TIME 19 7587
TEST_TIME 20 7718
TEST_TIME 21 8205
TEST_TIME 22 8126
TEST_TIME 23 8343
TEST_TIME 24 8869
TEST_TIME 25 9609
TEST_TIME 26 9796
TEST_TIME 27 10347
TEST_TIME 28 10434
TEST_TIME 29 10508
TEST_TIME 30 10352
TEST_TIME 31 10224
TEST_TIME 32 10211
TEST_TIME 33 10294
TEST_TIME 34 10268
TEST_TIME 35 10386
TEST_TIME 36 10175
TEST_TIME 37 9967
TEST_TIME 38 9880
TEST_TIME 39 9979
TEST_TIME 40 9791
TEST_TIME 41 9782
TEST_TIME 42 9707
TEST_TIME 43 9709
TEST_TIME 44 9842
TEST_TIME 45 9876
TEST_TIME 46 9786
TEST_TIME 47 9756
TEST_TIME 48 9740
TEST_TIME 49 9790
TEST_TIME 50 9824
TEST_TIME 51 9899
TEST_TIME 52 9877
TEST_TIME 53 9909
TEST_TIME 54 9888
TEST_TIME 55 10018
TEST_TIME 56 10128
TEST_TIME 57 10133
TEST_TIME 58 10178
TEST_TIME 59 10125
TEST_TIME 60 10207
TEST_TIME 61 10186
TEST_TIME 62 10040
TEST_TIME 63 10023
TEST_TIME 64 10034
TEST_TIME 65 9945
TEST_TIME 66 10023
TEST_TIME 67 9961
TEST_TIME 68 9899
TEST_TIME 69 9843
TEST_TIME 70 9772
TEST_TIME 71 9799
TEST_TIME 72 9756
TEST_TIME 73 9766
TEST_TIME 74 9772
TEST_TIME 75 9811
TEST_TIME 76 9846
TEST_TIME 77 9810
TEST_TIME 78 9826
TEST_TIME 79 9872
TEST_TIME 80 9832
TEST_TIME 81 9892
TEST_TIME 82 9941
TEST_TIME 83 9890
TEST_TIME 84 9795
TEST_TIME 85 9746
TEST_TIME 86 9729
TEST_TIME 87 9687
TEST_TIME 88 9631
TEST_TIME 89 9641
TEST_TIME 90 9636
TEST_TIME 91 9636
TEST_TIME 92 9627
TEST_TIME 93 9607
TEST_TIME 94 9623
TEST_TIME 95 9622
TEST_TIME 96 9660
TEST_TIME 97 9726
TEST_TIME 98 9775
TEST_TIME 99 9786
TEST_TIME 100 9780

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:03, from 25-03-2024 10:08:33 to 25-03-2024 10:08:36.

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 1368065 1368065 0 0.00 0 18463 7 0 0
doc_list_biud 1368064 1368064 0 0.00 0 69378 27 0 0
sp_add_invoice_to_stock 4571 4428 143 3.12 37 201914 19286 0 143
sp_cancel_adding_invoice 4804 4804 0 0.00 4 85017 822 0 0
sp_cancel_client_order 1581 1581 0 0.00 3 11524 384 0 0
sp_cancel_customer_reserve 471371 471371 0 0.00 0 31614 65 0 0
sp_cancel_pay_from_customer 596 596 0 0.00 2 4679 87 0 0
sp_cancel_pay_to_supplier 418 418 0 0.00 3 2923 66 0 0
sp_cancel_supplier_invoice 5301 5290 11 0.20 1 69382 707 0 11
sp_cancel_supplier_order 363 363 0 0.00 6 1045827 103630 0 0
sp_cancel_write_off 9728 9728 0 0.00 1 9315 139 0 0
sp_client_order 18080 18080 0 0.00 3 19253 395 0 0
sp_customer_reserve 428781 428781 0 0.00 0 113630 183 0 0
sp_fill_shopping_cart 27644 27644 0 0.00 1 14809 37 0 0
sp_fill_shopping_cart_clo_res 428760 428760 0 0.00 0 18203 17 0 0
sp_get_clo_for_invoice 4408 4408 0 0.00 0 16263 330 0 0
sp_kill_cost_storno 15546 15546 0 0.00 0 5681 73 0 0
sp_kill_qstorno_ret_qs2qd 958123 958123 0 0.00 0 69377 34 0 0
sp_kill_qty_storno 506314 506314 0 0.00 0 69378 73 0 0
sp_lock_selected_doc 18275 18275 0 0.00 0 6520 4 0 0
sp_make_cost_storno 24490 24490 0 0.00 0 18460 64 0 0
sp_multiply_rows_for_pdistr 24490 24490 0 0.00 0 8902 34 0 0
sp_multiply_rows_for_qdistr 18080 18080 0 0.00 0 17839 188 0 0
sp_pay_from_customer 6258 6258 0 0.00 3 16801 130 0 0
sp_pay_to_supplier 5055 5055 0 0.00 4 12562 140 0 0
sp_payment_common 11312 11312 0 0.00 1 8223 18 0 0
sp_qd_handle_on_cancel_clo 1581 1581 0 0.00 0 11504 357 0 0
sp_qd_handle_on_invoice_upd_sts 9210 9210 0 0.00 0 28655 296 0 0
sp_qd_handle_on_reserve_upd_sts 8771 8771 0 0.00 0 16571 60 0 0
sp_reserve_write_off 8771 8771 0 0.00 6 16624 191 0 0
sp_supplier_invoice 4795 4795 0 0.00 7 78112 2965 0 0
sp_supplier_order 4775 4775 0 0.00 4 32301 1298 0 0
srv_aggregate_perf_data 91 90 1 1.09 1620 219020 15451 0 1
srv_fill_mon_cache_memory 55 55 0 0.00 1377 105024 42354 0 0
srv_find_qd_qs_mism 931039 931039 0 0.00 0 16573 6 0 0
srv_make_invnt_saldo 384 384 0 0.00 35 113942 4117 0 0
srv_make_money_saldo 699 699 0 0.00 1 12060 419 0 0
srv_recalc_idx_stat 4 4 0 0.00 185105 426093 278841 0 0
t$perf-abend:sp_add_invoice_to_stock 143 143 0 0.00 0 0 0 0 0
t$perf-abend:sp_cancel_supplier_invoice 11 11 0 0.00 0 0 0 0 0
t$perf-abend:srv_aggregate_perf_data 1 1 0 0.00 0 0 0 0 0
t$perf-norm:sp_add_invoice_to_stock 4428 4428 0 0.00 0 13217 176 0 0
t$perf-norm:sp_cancel_adding_invoice 358 358 0 0.00 0 2687 100 0 0
t$perf-norm:sp_cancel_client_order 1581 1581 0 0.00 0 3498 11 0 0
t$perf-norm:sp_cancel_customer_reserve 588 588 0 0.00 0 5475 20 0 0
t$perf-norm:sp_cancel_pay_from_customer 596 596 0 0.00 0 15602 47 0 0
t$perf-norm:sp_cancel_pay_to_supplier 418 418 0 0.00 0 6815 28 0 0
t$perf-norm:sp_cancel_supplier_invoice 341 341 0 0.00 0 1540 33 0 0
t$perf-norm:sp_cancel_supplier_order 363 363 0 0.00 0 28429 1789 0 0
t$perf-norm:sp_cancel_write_off 855 855 0 0.00 0 4755 17 0 0
t$perf-norm:sp_client_order 18080 18080 0 0.00 0 17216 17 0 0
t$perf-norm:sp_customer_reserve 882 882 0 0.00 0 2203 9 0 0
t$perf-norm:sp_pay_from_customer 6258 6258 0 0.00 0 7615 13 0 0
t$perf-norm:sp_pay_to_supplier 5055 5055 0 0.00 0 6002 10 0 0
t$perf-norm:sp_reserve_write_off 8771 8771 0 0.00 0 8328 16 0 0
t$perf-norm:sp_supplier_invoice 4795 4795 0 0.00 0 10418 21 0 0
t$perf-norm:sp_supplier_order 4775 4775 0 0.00 0 4699 14 0 0
t$perf-norm:srv_aggregate_perf_data 90 90 0 0.00 0 1318 19 0 0
t$perf-norm:srv_fill_mon_cache_memory 55 55 0 0.00 0 233 6 0 0
t$perf-norm:srv_make_invnt_saldo 384 384 0 0.00 0 1772 11 0 0
t$perf-norm:srv_make_money_saldo 699 699 0 0.00 0 2329 10 0 0
t$perf-norm:srv_recalc_idx_stat 4 4 0 0.00 1 7 4 0 0
v_add_invoice_to_stock 9096 8810 286 3.14 0 5950 19 0 286
v_all_customers 33766 33766 0 0.00 0 24 1 0 0
v_all_suppliers 27388 27388 0 0.00 0 22 1 0 0
v_all_wares 36148 36148 0 0.00 0 21 1 0 0
v_cancel_adding_invoice 716 716 0 0.00 0 267 5 0 0
v_cancel_client_order 3162 3162 0 0.00 0 2774 7 0 0
v_cancel_customer_prepayment 1192 1192 0 0.00 0 1857 4 0 0
v_cancel_customer_reserve 1176 1176 0 0.00 0 2653 6 0 0
v_cancel_payment_to_supplier 836 836 0 0.00 0 2437 7 0 0
v_cancel_supplier_invoice 704 682 22 3.12 0 1789 19 0 22
v_cancel_supplier_order 726 726 0 0.00 0 1492 7 0 0
v_cancel_write_off 1710 1710 0 0.00 0 3308 17 0 0
v_max_id_clo_ord 4775 4775 0 0.00 0 871 2 0 0
v_max_id_clo_res 881 881 0 0.00 0 3133 10 0 0
v_max_id_ord_sup 4795 4795 0 0.00 0 2872 2 0 0
v_max_non_paid_invoice 931 931 0 0.00 0 1305 3 0 0
v_max_non_paid_realizn 2884 2884 0 0.00 0 3967 4 0 0
v_min_id_clo_ord 4775 4775 0 0.00 0 3324 7 0 0
v_min_id_clo_res 881 881 0 0.00 0 8842 15 0 0
v_min_id_ord_sup 4795 4795 0 0.00 0 8221 13 0 0
v_min_non_paid_invoice 5055 5055 0 0.00 0 3423 12 0 0
v_min_non_paid_realizn 6257 6257 0 0.00 0 4676 14 0 0
v_our_firm 9128 9128 0 0.00 0 19 1 0 0
v_reserve_write_off 17540 17540 0 0.00 0 3312 7 0 0
x_lock_depdocs_on_canc_invoice 9753 9753 0 0.00 0 11205 112 0 0
x_lock_depdocs_on_canc_sup_ord 363 363 0 0.00 0 10230 352 0 0
x_make_qstorno_1000_1200 4775 4775 0 0.00 1 32281 1220 0 0
x_make_qstorno_1200_2000 4795 4795 0 0.00 3 75238 2829 0 0
x_make_qstorno_2100_3300 428781 428781 0 0.00 0 113626 164 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 25-03-2024 10:08:37 to 25-03-2024 10:08:41.

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
08:07:53 1 8192000000 8796662832 8807108608 3180608 0.038 1 1 2 0 3278224 61840 35776
08:08:54 11498 8192000000 9697218992 9994731520 783232128 8.726 100 89 178 0 813190784 7639808 22318848
08:10:14 20755 8192000000 9751435488 10060976128 823686000 9.136 100 82 164 0 852648160 10249568 18712592
08:11:38 17821 8192000000 9782165744 10096660480 853105568 9.431 100 85 170 0 887898528 15812224 18980736
08:13:01 15170 8192000000 9822267584 10150367232 884062176 9.740 100 77 154 0 933100656 32706272 16332208
08:14:32 9231 8192000000 9884390928 10221133824 917776320 10.074 100 78 156 0 987867584 53918128 16173136
08:15:45 7937 8192000000 9901148064 10248757248 948242912 10.374 100 75 150 0 1016951840 53396784 15312144
08:16:54 4018 8192000000 9939660480 10300682240 977404192 10.659 100 76 151 1 1057055088 65133200 14517696
08:18:00 2408 8192000000 9982599408 10347225088 1010305696 10.978 100 79 158 0 1096958992 71627728 15025568
08:19:05 1562 8192000000 10003676816 10380357632 1037684688 11.242 100 82 162 1 1126626352 73246768 15694896
08:20:10 2106 8192000000 10030254000 10408128512 1047480000 11.337 100 74 146 0 1133532096 71854240 14197856
08:21:13 7317 8192000000 9992153120 10375909376 1052837456 11.388 100 69 139 0 1103007728 34881968 15288304
08:22:23 4359 8192000000 9978395440 10380259328 1062246144 11.478 100 29 58 0 1120066912 51730752 6090016
08:23:29 5350 8192000000 9991442224 10395766784 1073404032 11.585 100 28 56 0 1111281376 32488784 5388560
08:24:35 33208 8192000000 9985838384 10390245376 1077609552 11.625 100 41 81 0 1103814112 18045920 8158640
08:26:14 6893 8192000000 9989772640 10395099136 1084550144 11.691 100 37 72 2 1108790208 16678720 7561344
08:27:26 7024 8192000000 10002560640 10408722432 1081190560 11.659 99 24 48 0 1111105120 25016096 4898464
08:28:38 11894 8192000000 10051371824 10448650240 1100939504 11.847 100 51 101 0 1159895072 49074336 9881232
08:29:53 69289 8192000000 10073714064 10483978240 1090677408 11.749 98 45 90 0 1174343600 74717504 8948688
08:32:06 14373 8192000000 10072217920 10480230400 1120855360 12.035 100 38 74 0 1181921936 53254160 7812416
08:33:26 38780 8192000000 10090682464 10510004224 1086333808 11.708 97 46 93 0 1183065072 86673744 10057520
08:35:11 21927 8192000000 10132639680 10537709568 1110765968 11.940 99 45 88 0 1225686576 105171232 9749376
08:36:40 11029 8192000000 10174433584 10571976704 1116116048 11.990 99 59 118 0 1273666640 145213248 12337344
08:37:57 9586 8192000000 10173276352 10583396352 1122656048 12.052 99 39 78 0 1272198672 141658400 7884224
08:39:27 10097 8192000000 10190076672 10587316224 1095967728 11.799 98 49 95 0 1284569792 177912400 10689664
08:40:47 14619 8192000000 10252712528 10675466240 1116466992 11.994 99 51 102 0 1352923520 225035488 11421040
08:42:08 8647 8192000000 10292506912 10699698176 1121383632 12.040 100 70 138 0 1406043648 269957872 14702144
08:43:25 5492 8192000000 10325920592 10725109760 1124798640 12.072 100 70 139 1 1429472368 289503232 15170496
08:44:38 2975 8192000000 10355483696 10791182336 1132070704 12.141 100 80 160 1 1459309840 309569888 17669248
08:45:46 1375 8192000000 10353356208 10740871168 1126791312 12.091 100 93 184 0 1449526704 302719120 20016272
08:46:54 9843 8192000000 10391639936 10786852864 1123305728 12.058 100 81 162 0 1481464192 339943232 18215232
08:48:10 2521 8192000000 10392049248 10810699776 1140119520 12.217 100 69 137 0 1493656016 338145248 15391248
08:49:15 21999 8192000000 10396826192 10851856384 1142735168 12.241 100 30 60 0 1500674528 349956608 7982752
08:51:19 33758 8192000000 10313437504 10818859008 1119431600 12.022 100 25 50 0 1480604656 354485136 6687920
08:53:09 22550 8192000000 10142618384 10660192256 1113811456 11.968 100 14 28 0 1310902416 194038880 3052080
08:54:35 43653 8192000000 10082893568 10559250432 1107568912 11.909 99 13 25 0 1192542928 82538240 2435776
08:56:22 49924 8192000000 10050140592 10516144128 1116436176 11.993 100 4 9 0 1172443536 55286000 721360
08:58:15 31241 8192000000 10060832480 10483261440 1105563920 11.890 99 37 74 1 1139902592 26346528 7992144
08:59:50 33244 8192000000 10070213168 10512916480 1124915440 12.073 100 16 31 0 1169030240 41238000 2876800
09:01:27 91177 8192000000 10057003104 10542358528 1101632752 11.853 98 15 30 0 1152336464 47667936 3035776
09:03:59 80385 8192000000 10078094336 10524626944 1116254816 11.992 99 30 60 0 1142328240 20104736 5968688
09:06:32 91746 8192000000 10090235712 10519347200 1124557680 12.070 99 28 54 0 1153270928 22237824 6475424
09:09:05 54386 8192000000 10145266080 10591330304 1135848768 12.176 99 34 66 1 1246422048 103009472 7563808
09:11:05 34542 8192000000 10133753888 10611355648 1143073840 12.244 100 37 74 0 1261350096 110380720 7895536
09:13:25 43194 8192000000 10124521504 10595282944 1135032240 12.169 99 14 28 0 1230585360 92487072 3066048
09:15:08 82239 8192000000 10101961536 10584653824 1111045248 11.942 97 15 30 0 1199613184 85703376 2864560
09:17:31 41294 8192000000 10108278880 10569330688 1144925824 12.262 100 12 24 0 1180418208 33290208 2202176
09:19:14 30457 8192000000 10088353408 10523447296 1112990880 11.961 97 32 64 0 1156478800 36529440 6958480
09:20:46 53279 8192000000 10112768128 10567520256 1093980272 11.780 96 26 51 0 1160227184 61438288 4808624
09:22:41 79541 8192000000 10062503696 10564153344 1041453168 11.279 92 11 20 0 1100977216 57511776 2012272
09:25:02 52973 8192000000 10049109808 10527555584 1104475328 11.880 99 16 30 0 1177268048 69974016 2818704
09:26:55 57000 8192000000 10088556896 10553192448 1072542960 11.576 97 32 65 0 1145608848 66298384 6767504
09:29:01 105024 8192000000 10058939328 10519224320 1075141792 11.601 97 29 58 0 1134733056 53483360 6107904
09:31:50 39619 8192000000 10044830544 10491604992 1085700960 11.702 99 37 74 0 1135501152 42561792 7238400
09:33:32 50346 8192000000 10035651264 10523406336 1096636544 11.806 100 19 38 2 1171651920 71078896 3936480
09:35:37 81577 8192000000 10060283568 10501840896 1062398464 11.479 96 19 38 1 1127142848 60855376 3889008
09:38:02 51679 8192000000 10014896896 10475495424 1081673664 11.663 98 6 12 0 1132925456 50022784 1229008
09:39:59 31844 8192000000 10058480784 10487463936 1089821328 11.741 98 31 62 0 1141658512 45729312 6107872
09:41:32 10636 8192000000 10028858368 10446536704 1087777152 11.722 97 49 93 0 1115419504 18187360 9454992
09:42:45 94184 8192000000 10040001552 10489491456 1102336912 11.860 98 15 30 0 1132360160 27781152 2242096
09:45:20 61949 8192000000 10090207360 10552758272 1135866896 12.177 100 33 66 1 1191764128 49629760 6267472
09:47:23 5779 8192000000 10100541872 10514452480 1142509744 12.239 100 71 142 0 1184395264 27211600 14673920
09:48:30 53394 8192000000 10106681568 10636115968 1153627488 12.344 100 27 54 0 1252623824 93771264 5225072
09:51:01 99777 8192000000 10088464752 10530598912 1141316352 12.228 99 24 48 1 1181297296 35253280 4727664
09:53:41 41188 8192000000 10080405760 10547417088 1145574032 12.268 100 15 29 0 1191865392 43620496 2670864
09:55:33 56772 8192000000 10072332928 10572726272 1126743232 12.091 98 9 18 0 1185156080 56583648 1829200
09:57:48 22358 8192000000 10069945984 10506182656 1132154320 12.142 99 28 56 1 1172277760 34593120 5530320
09:59:32 24828 8192000000 10086928176 10531393536 1120140784 12.028 98 29 58 0 1183750192 57522960 6086448
10:00:57 59943 8192000000 10123923472 10597961728 1119625984 12.023 98 24 48 0 1209498368 84659616 5212768
10:02:59 80180 8192000000 10077174560 10566455296 1093783152 11.779 96 20 40 0 1163571472 65455120 4333200
10:05:22 84334 8192000000 10072159440 10522632192 1080373632 11.651 96 20 40 0 1147473712 62519184 4580896
10:07:47 12967 8192000000 8957238064 9162067968 119139728 1.433 11 3 6 0 154604112 34882928 581456

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:14, from 25-03-2024 10:08:43 to 25-03-2024 10:08:57.

Exceptions occured during test was in run

FB_MNEMONA CNT UNIT FB_GDSCODE
except 1 srv_aggregate_perf_data 335544517
except 143 v_add_invoice_to_stock 335544517
except 11 v_cancel_supplier_invoice 335544517

Completed "Exceptions occured during test was in run". Done for 00:00:02, from 25-03-2024 10:08:59 to 25-03-2024 10: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          174527
MON$OLDEST_ACTIVE               174528
MON$OLDEST_SNAPSHOT             174528
MON$NEXT_TRANSACTION            174528
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                       1934176
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             699
MON$NEXT_STATEMENT              53
MON$REPLICA_MODE                0


ISQL Version: LI-V4.0.5.3081 Firebird 4.0
Server version:
Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V4.0.5.3081 Firebird 4.0"
Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-V4.0.5.3081 Firebird 4.0/tcp (mscs-test-161.budzdorov.ru)/P17:C"
Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-V4.0.5.3081 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 Mon Mar 25 10:09:02 2024 
 
Database header page information: 
    Flags            0 
    Generation        91558 
    System Change Number    0 
    Page size        8192 
    ODS version        13.0 
    Oldest transaction    174527 
    Oldest active        174528 
    Oldest snapshot        174528 
    Next transaction    174529 
    Sequence number        0 
    Next attachment ID    699 
    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.10, total records: 7778856 
    Average version length: 48.16, total versions: 157828, 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: 88256 
    Data pages: 88256, average fill: 71% 
    Primary pages: 88255, secondary pages: 1, swept pages: 28022 
    Empty pages: 2, full pages: 88248 
    Fill distribution: 
     0 - 19% = 3 
    20 - 39% = 3 
    40 - 59% = 1 
    60 - 79% = 88172 
    80 - 99% = 77 
 
    Index DOC_DATA_DOC_WARE_UNQ (0) 
    Root page: 1510636, depth: 3, leaf buckets: 23375, nodes: 7778856 
    Average node length: 18.89, total dup: 0, max dup: 0 
    Average key length: 15.90, compression ratio: 1.70 
    Average prefix length: 14.10, average data length: 12.90 
    Clustering factor: 1710521, ratio: 0.22 
    Fill distribution: 
         0 - 19% = 355 
        20 - 39% = 1538 
        40 - 59% = 4453 
        60 - 79% = 2478 
        80 - 99% = 14551 
 
    Index DOC_DATA_ID_DESC (1) 
    Root page: 1528140, depth: 3, leaf buckets: 13573, nodes: 7778856 
    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: 1533643, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 1392 
        40 - 59% = 2269 
        60 - 79% = 1176 
        80 - 99% = 8736 
 
    Index FK_DOC_DATA_DOC_LIST (2) 
    Root page: 1546735, depth: 3, leaf buckets: 8362, nodes: 7778856 
    Average node length: 6.62, total dup: 5817609, max dup: 49 
    Average key length: 3.63, compression ratio: 2.48 
    Average prefix length: 7.62, average data length: 1.38 
    Clustering factor: 1526744, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 125 
        20 - 39% = 822 
        40 - 59% = 1550 
        60 - 79% = 962 
        80 - 99% = 4903 
 
DOC_LIST (138) 
    Primary pointer page: 500, Index root page: 501 
    Total formats: 1, used formats: 1 
    Average record length: 55.71, total records: 2251699 
    Average version length: 58.84, total versions: 80412, max versions: 2 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 84.00, compression ratio: 1.51 
    Pointer pages: 18, data page slots: 28440 
    Data pages: 28440, average fill: 73% 
    Primary pages: 28438, secondary pages: 2, swept pages: 6351 
    Empty pages: 7, full pages: 26548 
    Fill distribution: 
     0 - 19% = 11 
    20 - 39% = 26 
    40 - 59% = 495 
    60 - 79% = 27722 
    80 - 99% = 186 
 
    Index DOC_LIST_ID_DESC (1) 
    Root page: 1541152, depth: 3, leaf buckets: 4584, nodes: 2251699 
    Average node length: 11.40, total dup: 0, max dup: 0 
    Average key length: 8.44, compression ratio: 1.07 
    Average prefix length: 3.56, average data length: 5.44 
    Clustering factor: 680019, ratio: 0.30 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 835 
        40 - 59% = 983 
        60 - 79% = 752 
        80 - 99% = 2014 
 
    Index DOC_LIST_WORKER_OPTYPE (2) 
    Root page: 1544398, depth: 3, leaf buckets: 2411, nodes: 2253677 
    Average node length: 4.97, total dup: 2252778, max dup: 19088 
    Average key length: 2.01, compression ratio: 4.48 
    Average prefix length: 8.99, average data length: 0.01 
    Clustering factor: 1272623, ratio: 0.56 
    Fill distribution: 
         0 - 19% = 3 
        20 - 39% = 173 
        40 - 59% = 1406 
        60 - 79% = 577 
        80 - 99% = 252 
 
    Index FK_DOC_LIST_AGENTS (3) 
    Root page: 1545933, depth: 3, leaf buckets: 1753, nodes: 2251699 
    Average node length: 4.97, total dup: 2251649, max dup: 130305 
    Average key length: 2.01, compression ratio: 4.48 
    Average prefix length: 8.99, average data length: 0.01 
    Clustering factor: 1062629, ratio: 0.47 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 3 
        40 - 59% = 597 
        60 - 79% = 58 
        80 - 99% = 1095 
 
    Index PK_DOC_LIST (0) 
    Root page: 1538209, depth: 3, leaf buckets: 4344, nodes: 2251699 
    Average node length: 11.40, total dup: 0, max dup: 0 
    Average key length: 8.44, compression ratio: 1.07 
    Average prefix length: 3.56, average data length: 5.44 
    Clustering factor: 680019, ratio: 0.30 
    Fill distribution: 
         0 - 19% = 92 
        20 - 39% = 532 
        40 - 59% = 676 
        60 - 79% = 835 
        80 - 99% = 2209 
 
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.42, total records: 400 
    Average version length: 32.63, total versions: 798, max versions: 2 
    Average fragment length: 2.00, total fragments: 1, max fragments: 1 
    Average unpacked length: 104.00, compression ratio: 1.25 
    Pointer pages: 1, data page slots: 24 
    Data pages: 24, average fill: 41% 
    Primary pages: 14, secondary pages: 10, swept pages: 0 
    Empty pages: 8, full pages: 8 
    Fill distribution: 
     0 - 19% = 12 
    20 - 39% = 2 
    40 - 59% = 1 
    60 - 79% = 0 
    80 - 99% = 9 
 
    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: 23.67, total records: 110984 
    Average version length: 68.30, total versions: 83529, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 88.00, compression ratio: 3.72 
    Pointer pages: 7, data page slots: 3368 
    Data pages: 2424, average fill: 60% 
    Primary pages: 2423, secondary pages: 1, swept pages: 0 
    Empty pages: 343, full pages: 1331 
    Fill distribution: 
     0 - 19% = 583 
    20 - 39% = 210 
    40 - 59% = 178 
    60 - 79% = 428 
    80 - 99% = 1025 
 
    Index INVNT_TURNOVER_LOG_WARE_DD_ID (0) 
    Root page: 1693936, depth: 3, leaf buckets: 422, nodes: 110984 
    Average node length: 13.36, total dup: 9849, max dup: 2 
    Average key length: 10.57, compression ratio: 2.55 
    Average prefix length: 19.34, average data length: 7.66 
    Clustering factor: 78882, ratio: 0.71 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 136 
        40 - 59% = 273 
        60 - 79% = 13 
        80 - 99% = 0 
 
MONEY_SALDO (141) 
    Primary pointer page: 506, Index root page: 507 
    Total formats: 1, used formats: 1 
    Average record length: 15.29, total records: 49 
    Average version length: 9.00, total versions: 158, max versions: 5 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 32.00, compression ratio: 2.09 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 70% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 1 
    80 - 99% = 0 
 
    Index PK_MONEY_SALDO (0) 
    Root page: 1510383, depth: 1, leaf buckets: 1, nodes: 49 
    Average node length: 11.82, total dup: 0, max dup: 0 
    Average key length: 10.80, compression ratio: 0.83 
    Average prefix length: 1.18, average data length: 7.82 
    Clustering factor: 1, ratio: 0.02 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
MONEY_TURNOVER_LOG (140) 
    Primary pointer page: 504, Index root page: 505 
    Total formats: 1, used formats: 1 
    Average record length: 12.99, total records: 1754 
    Average version length: 43.82, total versions: 1555, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 58.00, compression ratio: 4.46 
    Pointer pages: 1, data page slots: 40 
    Data pages: 40, average fill: 48% 
    Primary pages: 39, secondary pages: 1, swept pages: 0 
    Empty pages: 6, full pages: 15 
    Fill distribution: 
     0 - 19% = 15 
    20 - 39% = 6 
    40 - 59% = 1 
    60 - 79% = 7 
    80 - 99% = 11 
 
    Index MONEY_TURNOVER_LOG_AGENT_OPTYPE (0) 
    Root page: 91996, depth: 2, leaf buckets: 3, nodes: 1754 
    Average node length: 4.27, total dup: 1656, max dup: 236 
    Average key length: 2.60, compression ratio: 7.30 
    Average prefix length: 18.45, average data length: 0.55 
    Clustering factor: 920, ratio: 0.52 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 3 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
MON_CACHE_MEMORY (165) 
    Primary pointer page: 555, Index root page: 556 
    Total formats: 2, used formats: 1 
    Average record length: 97.50, total records: 72 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 112.00, compression ratio: 1.15 
    Pointer pages: 1, data page slots: 2 
    Data pages: 2, average fill: 50% 
    Primary pages: 2, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 1 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 1 
    40 - 59% = 0 
    60 - 79% = 1 
    80 - 99% = 0 
 
    Index PK_MON_CACHE_MEMORY (0) 
    Root page: 1504238, depth: 1, leaf buckets: 1, nodes: 72 
    Average node length: 11.69, total dup: 0, max dup: 0 
    Average key length: 10.68, compression ratio: 0.84 
    Average prefix length: 1.31, average data length: 7.69 
    Clustering factor: 2, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
MON_LOG (162) 
    Primary pointer page: 548, Index root page: 549 
    Total formats: 2, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index MON_LOG_DTS (4) 
    Root page: 1504251, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index MON_LOG_GDSCODE (2) 
    Root page: 1504249, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index MON_LOG_ROWSET_DESC (1) 
    Root page: 1504248, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index MON_LOG_UNIT (3) 
    Root page: 1504250, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PK_MON_LOG (0) 
    Root page: 1504247, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
MON_LOG_TABLE_STATS (163) 
    Primary pointer page: 550, Index root page: 551 
    Total formats: 2, used formats: 1 
    Average record length: 67.13, total records: 30 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 611.00, compression ratio: 9.10 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 31% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 1 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index MON_LOG_TABLE_STATS_DTS (4) 
    Root page: 1504246, depth: 1, leaf buckets: 1, nodes: 30 
    Average node length: 3.50, total dup: 23, max dup: 4 
    Average key length: 2.47, compression ratio: 3.24 
    Average prefix length: 7.53, average data length: 0.47 
    Clustering factor: 1, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index MON_LOG_TABLE_STATS_GDSCODE (2) 
    Root page: 1504244, depth: 1, leaf buckets: 1, nodes: 30 
    Average node length: 2.00, total dup: 29, max dup: 29 
    Average key length: 1.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 1, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index MON_LOG_TABLE_STATS_ROWSET (1) 
    Root page: 1504243, depth: 1, leaf buckets: 1, nodes: 30 
    Average node length: 3.33, total dup: 29, max dup: 29 
    Average key length: 2.30, compression ratio: 3.91 
    Average prefix length: 8.70, average data length: 0.30 
    Clustering factor: 1, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index MON_LOG_TABLE_STATS_TN_UNIT (3) 
    Root page: 1504245, depth: 1, leaf buckets: 1, nodes: 30 
    Average node length: 12.90, total dup: 0, max dup: 0 
    Average key length: 11.87, compression ratio: 1.42 
    Average prefix length: 7.63, average data length: 9.20 
    Clustering factor: 1, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PK_MON_LOG_TABLE_STATS (0) 
    Root page: 1504242, depth: 1, leaf buckets: 1, nodes: 30 
    Average node length: 8.37, total dup: 0, max dup: 0 
    Average key length: 7.33, compression ratio: 1.23 
    Average prefix length: 4.63, average data length: 4.37 
    Clustering factor: 1, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
OPTYPES (136) 
    Primary pointer page: 496, Index root page: 497 
    Total formats: 2, used formats: 1 
    Average record length: 67.56, total records: 9 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 386.00, compression ratio: 5.71 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 9% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index OPTYPES_MCODE_UNQ (1) 
    Root page: 1544827, depth: 1, leaf buckets: 1, nodes: 9 
    Average node length: 8.56, total dup: 0, max dup: 0 
    Average key length: 6.89, compression ratio: 0.73 
    Average prefix length: 0.44, average data length: 4.56 
    Clustering factor: 1, ratio: 0.11 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PK_OPTYPES (0) 
    Root page: 1544826, depth: 1, leaf buckets: 1, nodes: 9 
    Average node length: 6.11, total dup: 0, max dup: 0 
    Average key length: 5.00, compression ratio: 0.60 
    Average prefix length: 0.89, average data length: 2.11 
    Clustering factor: 1, ratio: 0.11 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
PDISTR (146) 
    Primary pointer page: 516, Index root page: 517 
    Total formats: 1, used formats: 1 
    Average record length: 35.45, total records: 892605 
    Average version length: 37.83, total versions: 46397, 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: 9104 
    Data pages: 9104, average fill: 67% 
    Primary pages: 9103, secondary pages: 1, swept pages: 959 
    Empty pages: 14, full pages: 8515 
    Fill distribution: 
     0 - 19% = 26 
    20 - 39% = 21 
    40 - 59% = 75 
    60 - 79% = 8864 
    80 - 99% = 118 
 
    Index PDISTR_AGENT_ID (2) 
    Root page: 1509330, depth: 2, leaf buckets: 917, nodes: 863930 
    Average node length: 4.89, total dup: 863881, max dup: 165003 
    Average key length: 2.01, compression ratio: 4.48 
    Average prefix length: 8.99, average data length: 0.01 
    Clustering factor: 95556, ratio: 0.11 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 116 
        40 - 59% = 475 
        60 - 79% = 224 
        80 - 99% = 101 
 
    Index PDISTR_SNDOP_RCVOP_SNDID_ASC (0) 
    Root page: 1508635, depth: 3, leaf buckets: 1118, nodes: 863930 
    Average node length: 5.90, total dup: 769318, max dup: 42 
    Average key length: 3.02, compression ratio: 7.29 
    Average prefix length: 21.09, average data length: 0.91 
    Clustering factor: 171537, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 40 
        40 - 59% = 817 
        60 - 79% = 99 
        80 - 99% = 162 
 
    Index PDISTR_SNDOP_RCVOP_SNDID_DESC (1) 
    Root page: 1509209, depth: 3, leaf buckets: 1153, nodes: 863930 
    Average node length: 5.90, total dup: 769318, max dup: 42 
    Average key length: 3.02, compression ratio: 7.29 
    Average prefix length: 21.09, average data length: 0.91 
    Clustering factor: 173571, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 66 
        40 - 59% = 852 
        60 - 79% = 91 
        80 - 99% = 143 
 
    Index PDISTR_WORKER_SND_ID (3) 
    Root page: 1510200, depth: 3, leaf buckets: 1199, nodes: 863930 
    Average node length: 5.98, total dup: 769318, max dup: 42 
    Average key length: 3.10, compression ratio: 5.49 
    Average prefix length: 16.01, average data length: 0.99 
    Clustering factor: 165584, ratio: 0.19 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 234 
        40 - 59% = 626 
        60 - 79% = 234 
        80 - 99% = 103 
 
PERF_AGG (158) 
    Primary pointer page: 540, Index root page: 541 
    Total formats: 1, used formats: 1 
    Average record length: 62.98, total records: 5546 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 3.96, total fragments: 24, max fragments: 1 
    Average unpacked length: 379.00, compression ratio: 6.02 
    Pointer pages: 1, data page slots: 96 
    Data pages: 96, average fill: 57% 
    Primary pages: 81, secondary pages: 15, swept pages: 50 
    Empty pages: 12, full pages: 52 
    Fill distribution: 
     0 - 19% = 20 
    20 - 39% = 0 
    40 - 59% = 2 
    60 - 79% = 74 
    80 - 99% = 0 
 
    Index PERF_AGG_UNQ (1) 
    Root page: 1504260, depth: 2, leaf buckets: 6, nodes: 5546 
    Average node length: 5.49, total dup: 0, max dup: 0 
    Average key length: 3.57, compression ratio: 10.13 
    Average prefix length: 34.67, average data length: 1.54 
    Clustering factor: 5264, ratio: 0.95 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 0 
        40 - 59% = 4 
        60 - 79% = 1 
        80 - 99% = 1 
 
    Index PK_PERF_AGG (0) 
    Root page: 1504255, depth: 2, leaf buckets: 10, nodes: 5546 
    Average node length: 11.13, total dup: 0, max dup: 0 
    Average key length: 9.21, compression ratio: 0.98 
    Average prefix length: 2.79, average data length: 6.21 
    Clustering factor: 153, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 2 
        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.03, total records: 79208 
    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: 824 
    Data pages: 824, average fill: 66% 
    Primary pages: 824, secondary pages: 0, swept pages: 0 
    Empty pages: 1, full pages: 822 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 1 
    40 - 59% = 0 
    60 - 79% = 822 
    80 - 99% = 0 
 
    Index PK_PERF_ESTIMATED (0) 
    Root page: 35927, depth: 2, leaf buckets: 101, nodes: 79208 
    Average node length: 10.16, total dup: 0, max dup: 0 
    Average key length: 8.17, compression ratio: 1.10 
    Average prefix length: 3.83, average data length: 5.17 
    Clustering factor: 3095, ratio: 0.04 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 1 
        40 - 59% = 1 
        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: 149.88, total records: 164030 
    Average version length: 145.47, total versions: 1655, 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: 7, data page slots: 5872 
    Data pages: 4128, average fill: 82% 
    Primary pages: 4126, secondary pages: 2, swept pages: 5 
    Empty pages: 80, full pages: 4025 
    Fill distribution: 
     0 - 19% = 90 
    20 - 39% = 8 
    40 - 59% = 4 
    60 - 79% = 0 
    80 - 99% = 4026 
 
PERF_SPLIT_1 (282) 
    Primary pointer page: 603, Index root page: 604 
    Total formats: 1, used formats: 1 
    Average record length: 146.70, total records: 142766 
    Average version length: 151.38, total versions: 4605, 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: 6, data page slots: 3768 
    Data pages: 3568, average fill: 83% 
    Primary pages: 3565, secondary pages: 3, swept pages: 3 
    Empty pages: 49, full pages: 3503 
    Fill distribution: 
     0 - 19% = 51 
    20 - 39% = 8 
    40 - 59% = 3 
    60 - 79% = 3 
    80 - 99% = 3503 
 
PERF_SPLIT_2 (283) 
    Primary pointer page: 605, Index root page: 606 
    Total formats: 1, used formats: 1 
    Average record length: 113.21, total records: 178828 
    Average version length: 154.74, total versions: 47402, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 14.98 
    Pointer pages: 6, data page slots: 4936 
    Data pages: 4456, average fill: 86% 
    Primary pages: 4454, secondary pages: 2, swept pages: 3 
    Empty pages: 43, full pages: 4398 
    Fill distribution: 
     0 - 19% = 46 
    20 - 39% = 2 
    40 - 59% = 4 
    60 - 79% = 6 
    80 - 99% = 4398 
 
PERF_SPLIT_3 (284) 
    Primary pointer page: 607, Index root page: 616 
    Total formats: 1, used formats: 1 
    Average record length: 132.74, total records: 172282 
    Average version length: 154.30, total versions: 22157, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 12.78 
    Pointer pages: 8, data page slots: 5200 
    Data pages: 4328, average fill: 84% 
    Primary pages: 4325, secondary pages: 3, swept pages: 10 
    Empty pages: 74, full pages: 4218 
    Fill distribution: 
     0 - 19% = 78 
    20 - 39% = 9 
    40 - 59% = 17 
    60 - 79% = 8 
    80 - 99% = 4216 
 
PERF_SPLIT_4 (285) 
    Primary pointer page: 617, Index root page: 618 
    Total formats: 1, used formats: 1 
    Average record length: 125.29, total records: 170538 
    Average version length: 154.40, total versions: 30800, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 13.54 
    Pointer pages: 7, data page slots: 5280 
    Data pages: 4224, average fill: 86% 
    Primary pages: 4221, secondary pages: 3, swept pages: 3 
    Empty pages: 19, full pages: 4190 
    Fill distribution: 
     0 - 19% = 22 
    20 - 39% = 2 
    40 - 59% = 6 
    60 - 79% = 5 
    80 - 99% = 4189 
 
PERF_SPLIT_5 (286) 
    Primary pointer page: 619, Index root page: 620 
    Total formats: 1, used formats: 1 
    Average record length: 145.87, total records: 143421 
    Average version length: 151.54, total versions: 5022, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.63 
    Pointer pages: 6, data page slots: 6088 
    Data pages: 3560, average fill: 83% 
    Primary pages: 3557, secondary pages: 3, swept pages: 5 
    Empty pages: 34, full pages: 3512 
    Fill distribution: 
     0 - 19% = 39 
    20 - 39% = 2 
    40 - 59% = 5 
    60 - 79% = 1 
    80 - 99% = 3513 
 
PERF_SPLIT_6 (287) 
    Primary pointer page: 621, Index root page: 622 
    Total formats: 1, used formats: 1 
    Average record length: 136.46, total records: 167025 
    Average version length: 154.06, total versions: 17133, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 12.43 
    Pointer pages: 6, data page slots: 5888 
    Data pages: 4152, average fill: 84% 
    Primary pages: 4149, secondary pages: 3, swept pages: 1 
    Empty pages: 40, full pages: 4098 
    Fill distribution: 
     0 - 19% = 42 
    20 - 39% = 7 
    40 - 59% = 3 
    60 - 79% = 2 
    80 - 99% = 4098 
 
PERF_SPLIT_7 (288) 
    Primary pointer page: 626, Index root page: 627 
    Total formats: 1, used formats: 1 
    Average record length: 138.71, total records: 156221 
    Average version length: 154.04, total versions: 13294, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 12.23 
    Pointer pages: 7, data page slots: 4768 
    Data pages: 3864, average fill: 84% 
    Primary pages: 3862, secondary pages: 2, swept pages: 4 
    Empty pages: 21, full pages: 3830 
    Fill distribution: 
     0 - 19% = 25 
    20 - 39% = 4 
    40 - 59% = 4 
    60 - 79% = 2 
    80 - 99% = 3829 
 
PERF_SPLIT_8 (289) 
    Primary pointer page: 628, Index root page: 629 
    Total formats: 1, used formats: 1 
    Average record length: 145.03, total records: 153548 
    Average version length: 151.19, total versions: 6616, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.69 
    Pointer pages: 8, data page slots: 4088 
    Data pages: 3816, average fill: 83% 
    Primary pages: 3815, secondary pages: 1, swept pages: 4 
    Empty pages: 37, full pages: 3766 
    Fill distribution: 
     0 - 19% = 40 
    20 - 39% = 5 
    40 - 59% = 2 
    60 - 79% = 4 
    80 - 99% = 3765 
 
PERF_SPLIT_9 (290) 
    Primary pointer page: 630, Index root page: 631 
    Total formats: 1, used formats: 1 
    Average record length: 146.14, total records: 146342 
    Average version length: 151.01, total versions: 5137, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.60 
    Pointer pages: 6, data page slots: 5784 
    Data pages: 3632, average fill: 83% 
    Primary pages: 3629, secondary pages: 3, swept pages: 4 
    Empty pages: 32, full pages: 3588 
    Fill distribution: 
     0 - 19% = 32 
    20 - 39% = 5 
    40 - 59% = 4 
    60 - 79% = 3 
    80 - 99% = 3588 
 
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.40, total records: 2076171 
    Average version length: 52.96, total versions: 63859, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 70.00, compression ratio: 1.36 
    Pointer pages: 16, data page slots: 25736 
    Data pages: 25736, average fill: 70% 
    Primary pages: 25717, secondary pages: 19, swept pages: 9860 
    Empty pages: 227, full pages: 22792 
    Fill distribution: 
     0 - 19% = 472 
    20 - 39% = 352 
    40 - 59% = 824 
    60 - 79% = 23441 
    80 - 99% = 647 
 
    Index PSTORNED_RCV_ID (1) 
    Root page: 1506208, depth: 3, leaf buckets: 2542, nodes: 2076171 
    Average node length: 5.44, total dup: 1937650, max dup: 1605 
    Average key length: 2.49, compression ratio: 3.62 
    Average prefix length: 8.58, average data length: 0.42 
    Clustering factor: 180377, ratio: 0.09 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 334 
        40 - 59% = 1572 
        60 - 79% = 326 
        80 - 99% = 308 
 
    Index PSTORNED_SND_ID (0) 
    Root page: 1504841, depth: 3, leaf buckets: 2753, nodes: 2076171 
    Average node length: 5.69, total dup: 1863783, max dup: 65 
    Average key length: 2.74, compression ratio: 3.29 
    Average prefix length: 8.36, average data length: 0.64 
    Clustering factor: 372159, ratio: 0.18 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 13 
        40 - 59% = 2471 
        60 - 79% = 247 
        80 - 99% = 20 
 
    Index PSTORNED_WORKER_ID (2) 
    Root page: 1508018, depth: 3, leaf buckets: 2097, nodes: 2076171 
    Average node length: 4.96, total dup: 2076071, max dup: 27226 
    Average key length: 2.00, compression ratio: 1.20 
    Average prefix length: 2.41, average data length: 0.00 
    Clustering factor: 178009, ratio: 0.09 
    Fill distribution: 
         0 - 19% = 4 
        20 - 39% = 182 
        40 - 59% = 1092 
        60 - 79% = 396 
        80 - 99% = 423 
 
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: 36.63, total records: 171643 
    Average version length: 69.18, total versions: 92913, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 3.44 
    Pointer pages: 3, data page slots: 3952 
    Data pages: 3128, average fill: 68% 
    Primary pages: 3128, secondary pages: 0, swept pages: 248 
    Empty pages: 372, full pages: 2435 
    Fill distribution: 
     0 - 19% = 480 
    20 - 39% = 70 
    40 - 59% = 59 
    60 - 79% = 927 
    80 - 99% = 1592 
 
    Index XQD_1000_1200_WA_SO_RO_WKR_SND (0) 
    Root page: 1557956, depth: 3, leaf buckets: 247, nodes: 171643 
    Average node length: 6.49, total dup: 149421, max dup: 14 
    Average key length: 3.91, compression ratio: 10.74 
    Average prefix length: 40.22, average data length: 1.78 
    Clustering factor: 29751, ratio: 0.17 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 24 
        40 - 59% = 130 
        60 - 79% = 74 
        80 - 99% = 19 
 
XQD_1000_3300 (178) 
    Primary pointer page: 581, Index root page: 582 
    Total formats: 1, used formats: 1 
    Average record length: 63.69, total records: 7576257 
    Average version length: 68.75, total versions: 663181, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.98 
    Pointer pages: 68, data page slots: 109888 
    Data pages: 109888, average fill: 75% 
    Primary pages: 109888, secondary pages: 0, swept pages: 7550 
    Empty pages: 48, full pages: 104847 
    Fill distribution: 
     0 - 19% = 373 
    20 - 39% = 735 
    40 - 59% = 1494 
    60 - 79% = 102636 
    80 - 99% = 4650 
 
    Index XQD_1000_3300_WA_SO_RO_WKR_SND (0) 
    Root page: 1480476, depth: 3, leaf buckets: 10857, nodes: 7576257 
    Average node length: 6.50, total dup: 6560725, max dup: 44 
    Average key length: 3.51, compression ratio: 11.98 
    Average prefix length: 40.63, average data length: 1.37 
    Clustering factor: 1793405, ratio: 0.24 
    Fill distribution: 
         0 - 19% = 13 
        20 - 39% = 1163 
        40 - 59% = 5496 
        60 - 79% = 3520 
        80 - 99% = 665 
 
    Index XQD_1000_3300_WKR_DOC_ASC (1) 
    Root page: 1486090, depth: 3, leaf buckets: 9119, nodes: 7576257 
    Average node length: 5.38, total dup: 7285331, max dup: 179 
    Average key length: 2.39, compression ratio: 7.10 
    Average prefix length: 16.65, average data length: 0.35 
    Clustering factor: 1573136, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 8 
        20 - 39% = 1150 
        40 - 59% = 5267 
        60 - 79% = 1685 
        80 - 99% = 1009 
 
    Index XQD_1000_3300_WKR_DOC_DEC (2) 
    Root page: 1490630, depth: 3, leaf buckets: 9197, nodes: 7576257 
    Average node length: 5.38, total dup: 7285331, max dup: 179 
    Average key length: 2.39, compression ratio: 7.10 
    Average prefix length: 16.65, average data length: 0.35 
    Clustering factor: 1575561, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 8 
        20 - 39% = 1198 
        40 - 59% = 5325 
        60 - 79% = 1661 
        80 - 99% = 1005 
 
XQD_1200_2000 (177) 
    Primary pointer page: 579, Index root page: 580 
    Total formats: 1, used formats: 1 
    Average record length: 66.60, total records: 12548517 
    Average version length: 68.67, total versions: 483518, 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: 110, data page slots: 178280 
    Data pages: 178280, average fill: 75% 
    Primary pages: 178280, secondary pages: 0, swept pages: 47828 
    Empty pages: 9, full pages: 178269 
    Fill distribution: 
     0 - 19% = 10 
    20 - 39% = 0 
    40 - 59% = 2 
    60 - 79% = 173360 
    80 - 99% = 4908 
 
    Index XQD_1200_2000_WA_SO_RO_WKR_SND (0) 
    Root page: 1495050, depth: 3, leaf buckets: 18596, nodes: 12543661 
    Average node length: 6.63, total dup: 10937162, max dup: 69 
    Average key length: 3.42, compression ratio: 12.27 
    Average prefix length: 40.71, average data length: 1.29 
    Clustering factor: 2547157, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 30 
        20 - 39% = 1876 
        40 - 59% = 10212 
        60 - 79% = 5515 
        80 - 99% = 963 
 
XQD_2000_3300 (179) 
    Primary pointer page: 583, Index root page: 584 
    Total formats: 1, used formats: 1 
    Average record length: 36.71, total records: 2082411 
    Average version length: 69.10, total versions: 628222, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 3.43 
    Pointer pages: 31, data page slots: 48320 
    Data pages: 29176, average fill: 70% 
    Primary pages: 29088, secondary pages: 88, swept pages: 672 
    Empty pages: 1, full pages: 29088 
    Fill distribution: 
     0 - 19% = 72 
    20 - 39% = 4635 
    40 - 59% = 2126 
    60 - 79% = 12856 
    80 - 99% = 9487 
 
    Index XQD_2000_3300_WA_SO_RO_WKR_SND (0) 
    Root page: 1479735, depth: 3, leaf buckets: 1908, nodes: 1587770 
    Average node length: 5.51, total dup: 1524038, max dup: 49 
    Average key length: 2.55, compression ratio: 16.46 
    Average prefix length: 41.49, average data length: 0.51 
    Clustering factor: 109626, ratio: 0.07 
    Fill distribution: 
         0 - 19% = 9 
        20 - 39% = 209 
        40 - 59% = 914 
        60 - 79% = 588 
        80 - 99% = 188 
 
XQD_2100_3300 (180) 
    Primary pointer page: 585, Index root page: 586 
    Total formats: 1, used formats: 1 
    Average record length: 28.71, total records: 1776683 
    Average version length: 69.02, total versions: 230606, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 4.39 
    Pointer pages: 23, data page slots: 37120 
    Data pages: 28664, average fill: 44% 
    Primary pages: 28664, secondary pages: 0, swept pages: 5002 
    Empty pages: 5511, full pages: 19156 
    Fill distribution: 
     0 - 19% = 7434 
    20 - 39% = 3040 
    40 - 59% = 7324 
    60 - 79% = 9850 
    80 - 99% = 1016 
 
    Index XQD_2100_3300_WA_SO_RO_WKR_SND (0) 
    Root page: 1479229, depth: 3, leaf buckets: 1135, nodes: 814074 
    Average node length: 5.97, total dup: 748121, max dup: 79 
    Average key length: 3.03, compression ratio: 13.87 
    Average prefix length: 41.05, average data length: 0.95 
    Clustering factor: 124109, ratio: 0.15 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 205 
        40 - 59% = 571 
        60 - 79% = 301 
        80 - 99% = 58 
 
XQD_3300_3400 (181) 
    Primary pointer page: 587, Index root page: 588 
    Total formats: 1, used formats: 1 
    Average record length: 63.73, total records: 9357754 
    Average version length: 68.96, total versions: 798190, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.98 
    Pointer pages: 90, data page slots: 145440 
    Data pages: 145408, average fill: 70% 
    Primary pages: 145390, secondary pages: 18, swept pages: 25623 
    Empty pages: 248, full pages: 112785 
    Fill distribution: 
     0 - 19% = 1009 
    20 - 39% = 7057 
    40 - 59% = 17950 
    60 - 79% = 111629 
    80 - 99% = 7763 
 
    Index XQD_3300_3400_WA_SO_RO_WKR_SND (0) 
    Root page: 1472612, depth: 3, leaf buckets: 13486, nodes: 9349880 
    Average node length: 6.69, total dup: 7756397, max dup: 23 
    Average key length: 3.66, compression ratio: 11.46 
    Average prefix length: 40.51, average data length: 1.49 
    Clustering factor: 2095620, ratio: 0.22 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 1045 
        40 - 59% = 6755 
        60 - 79% = 4927 
        80 - 99% = 758 
 
XQS_1000_1200 (182) 
    Primary pointer page: 589, Index root page: 590 
    Total formats: 1, used formats: 1 
    Average record length: 82.47, total records: 21151469 
    Average version length: 82.81, total versions: 19599, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.53 
    Pointer pages: 196, data page slots: 319664 
    Data pages: 319664, average fill: 81% 
    Primary pages: 319660, secondary pages: 4, swept pages: 11799 
    Empty pages: 6, full pages: 319654 
    Fill distribution: 
     0 - 19% = 8 
    20 - 39% = 0 
    40 - 59% = 2 
    60 - 79% = 48698 
    80 - 99% = 270956 
 
    Index XQS_1000_1200_DOC_ID (1) 
    Root page: 1426738, depth: 3, leaf buckets: 19455, nodes: 21151469 
    Average node length: 5.72, total dup: 20670559, max dup: 136 
    Average key length: 2.16, compression ratio: 4.16 
    Average prefix length: 8.86, average data length: 0.14 
    Clustering factor: 3285461, ratio: 0.16 
    Fill distribution: 
         0 - 19% = 4 
        20 - 39% = 1 
        40 - 59% = 8277 
        60 - 79% = 566 
        80 - 99% = 10607 
 
    Index XQS_1000_1200_RCV_ID (3) 
    Root page: 1457002, depth: 3, leaf buckets: 17174, nodes: 21151469 
    Average node length: 6.31, total dup: 18588595, max dup: 49 
    Average key length: 2.75, compression ratio: 3.27 
    Average prefix length: 8.37, average data length: 0.63 
    Clustering factor: 918084, ratio: 0.04 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 3 
        40 - 59% = 785 
        60 - 79% = 276 
        80 - 99% = 16108 
 
    Index XQS_1000_1200_SND_ID (2) 
    Root page: 1441095, depth: 3, leaf buckets: 21257, nodes: 21151469 
    Average node length: 6.35, total dup: 18506920, max dup: 29 
    Average key length: 2.79, compression ratio: 3.23 
    Average prefix length: 8.34, average data length: 0.66 
    Clustering factor: 3579028, ratio: 0.17 
    Fill distribution: 
         0 - 19% = 4 
        20 - 39% = 2 
        40 - 59% = 8602 
        60 - 79% = 596 
        80 - 99% = 12053 
 
    Index XQS_1000_1200_WORKER_ID (0) 
    Root page: 1413370, depth: 3, leaf buckets: 16078, nodes: 21151469 
    Average node length: 5.56, total dup: 21151369, max dup: 228401 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.42, average data length: 0.00 
    Clustering factor: 946771, ratio: 0.04 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 8 
        40 - 59% = 2835 
        60 - 79% = 397 
        80 - 99% = 12836 
 
XQS_1000_3300 (184) 
    Primary pointer page: 593, Index root page: 594 
    Total formats: 1, used formats: 1 
    Average record length: 76.50, total records: 9785229 
    Average version length: 82.60, total versions: 787259, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.65 
    Pointer pages: 107, data page slots: 174472 
    Data pages: 174456, average fill: 70% 
    Primary pages: 174405, secondary pages: 51, swept pages: 47847 
    Empty pages: 1087, full pages: 121269 
    Fill distribution: 
     0 - 19% = 2714 
    20 - 39% = 9343 
    40 - 59% = 24667 
    60 - 79% = 105134 
    80 - 99% = 32598 
 
    Index XQS_1000_3300_DOC_ID (1) 
    Root page: 1367524, depth: 3, leaf buckets: 11309, nodes: 9785229 
    Average node length: 5.38, total dup: 9477231, max dup: 189 
    Average key length: 2.23, compression ratio: 4.04 
    Average prefix length: 8.80, average data length: 0.20 
    Clustering factor: 2171748, ratio: 0.22 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 43 
        40 - 59% = 7687 
        60 - 79% = 3502 
        80 - 99% = 76 
 
    Index XQS_1000_3300_RCV_ID (3) 
    Root page: 1379283, depth: 3, leaf buckets: 13773, nodes: 9785229 
    Average node length: 6.25, total dup: 8112785, max dup: 14 
    Average key length: 3.10, compression ratio: 2.90 
    Average prefix length: 8.07, average data length: 0.93 
    Clustering factor: 1521292, ratio: 0.16 
    Fill distribution: 
         0 - 19% = 140 
        20 - 39% = 3666 
        40 - 59% = 5021 
        60 - 79% = 2729 
        80 - 99% = 2217 
 
    Index XQS_1000_3300_SND_ID (2) 
    Root page: 1373081, depth: 3, leaf buckets: 12632, nodes: 9785229 
    Average node length: 5.99, total dup: 8500763, max dup: 44 
    Average key length: 2.84, compression ratio: 3.17 
    Average prefix length: 8.29, average data length: 0.71 
    Clustering factor: 2372861, ratio: 0.24 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 60 
        40 - 59% = 8702 
        60 - 79% = 3766 
        80 - 99% = 102 
 
    Index XQS_1000_3300_WORKER_ID (0) 
    Root page: 1362789, depth: 3, leaf buckets: 10229, nodes: 9785229 
    Average node length: 5.15, total dup: 9785129, max dup: 163659 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.42, average data length: 0.00 
    Clustering factor: 1551900, ratio: 0.16 
    Fill distribution: 
         0 - 19% = 35 
        20 - 39% = 1155 
        40 - 59% = 5187 
        60 - 79% = 1823 
        80 - 99% = 2029 
 
XQS_1200_2000 (183) 
    Primary pointer page: 591, Index root page: 592 
    Total formats: 1, used formats: 1 
    Average record length: 78.56, total records: 11222286 
    Average version length: 82.55, total versions: 570509, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.60 
    Pointer pages: 119, data page slots: 194000 
    Data pages: 192576, average fill: 72% 
    Primary pages: 192370, secondary pages: 206, swept pages: 58908 
    Empty pages: 3468, full pages: 148441 
    Fill distribution: 
     0 - 19% = 5821 
    20 - 39% = 7661 
    40 - 59% = 16667 
    60 - 79% = 95246 
    80 - 99% = 67181 
 
    Index XQS_1200_2000_DOC_ID (1) 
    Root page: 1392123, depth: 3, leaf buckets: 13091, nodes: 11222286 
    Average node length: 5.30, total dup: 11113262, max dup: 635 
    Average key length: 2.08, compression ratio: 4.33 
    Average prefix length: 8.93, average data length: 0.07 
    Clustering factor: 2349527, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 133 
        40 - 59% = 9246 
        60 - 79% = 3606 
        80 - 99% = 106 
 
    Index XQS_1200_2000_RCV_ID (3) 
    Root page: 1406132, depth: 3, leaf buckets: 10393, nodes: 11222286 
    Average node length: 5.50, total dup: 10732590, max dup: 49 
    Average key length: 2.28, compression ratio: 3.95 
    Average prefix length: 8.77, average data length: 0.23 
    Clustering factor: 716587, ratio: 0.06 
    Fill distribution: 
         0 - 19% = 142 
        20 - 39% = 801 
        40 - 59% = 2631 
        60 - 79% = 1868 
        80 - 99% = 4951 
 
    Index XQS_1200_2000_SND_ID (2) 
    Root page: 1398660, depth: 3, leaf buckets: 14976, nodes: 11222286 
    Average node length: 6.03, total dup: 9794645, max dup: 80 
    Average key length: 2.80, compression ratio: 3.21 
    Average prefix length: 8.32, average data length: 0.68 
    Clustering factor: 2365891, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 166 
        40 - 59% = 10888 
        60 - 79% = 3789 
        80 - 99% = 131 
 
    Index XQS_1200_2000_WORKER_ID (0) 
    Root page: 1386233, depth: 3, leaf buckets: 10711, nodes: 11222286 
    Average node length: 5.23, total dup: 11222186, max dup: 194713 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.41, average data length: 0.00 
    Clustering factor: 704838, ratio: 0.06 
    Fill distribution: 
         0 - 19% = 97 
        20 - 39% = 802 
        40 - 59% = 4850 
        60 - 79% = 1506 
        80 - 99% = 3456 
 
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: 76.93, total records: 9886461 
    Average version length: 82.90, total versions: 777700, 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: 109, data page slots: 177720 
    Data pages: 177688, average fill: 70% 
    Primary pages: 177642, secondary pages: 46, swept pages: 49749 
    Empty pages: 941, full pages: 119787 
    Fill distribution: 
     0 - 19% = 2567 
    20 - 39% = 9926 
    40 - 59% = 26713 
    60 - 79% = 106813 
    80 - 99% = 31669 
 
    Index XQS_2100_3300_DOC_ID (1) 
    Root page: 1344708, depth: 3, leaf buckets: 11849, nodes: 9886461 
    Average node length: 5.19, total dup: 9857586, max dup: 2403 
    Average key length: 2.03, compression ratio: 4.43 
    Average prefix length: 8.97, average data length: 0.03 
    Clustering factor: 2011660, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 24 
        20 - 39% = 1503 
        40 - 59% = 7664 
        60 - 79% = 1992 
        80 - 99% = 666 
 
    Index XQS_2100_3300_RCV_ID (3) 
    Root page: 1355739, depth: 3, leaf buckets: 13893, nodes: 9886461 
    Average node length: 6.26, total dup: 8196167, max dup: 14 
    Average key length: 3.10, compression ratio: 2.90 
    Average prefix length: 8.07, average data length: 0.93 
    Clustering factor: 1492021, ratio: 0.15 
    Fill distribution: 
         0 - 19% = 185 
        20 - 39% = 3706 
        40 - 59% = 4953 
        60 - 79% = 2696 
        80 - 99% = 2353 
 
    Index XQS_2100_3300_SND_ID (2) 
    Root page: 1350071, depth: 3, leaf buckets: 12435, nodes: 9886461 
    Average node length: 5.45, total dup: 9447973, max dup: 108 
    Average key length: 2.28, compression ratio: 3.94 
    Average prefix length: 8.76, average data length: 0.24 
    Clustering factor: 2143703, ratio: 0.22 
    Fill distribution: 
         0 - 19% = 32 
        20 - 39% = 1431 
        40 - 59% = 8509 
        60 - 79% = 1786 
        80 - 99% = 677 
 
    Index XQS_2100_3300_WORKER_ID (0) 
    Root page: 987843, depth: 3, leaf buckets: 10372, nodes: 9886461 
    Average node length: 5.16, total dup: 9886361, max dup: 164937 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.41, average data length: 0.00 
    Clustering factor: 1574041, ratio: 0.16 
    Fill distribution: 
         0 - 19% = 40 
        20 - 39% = 1234 
        40 - 59% = 5257 
        60 - 79% = 1706 
        80 - 99% = 2135 
 
XQS_3300_3400 (187) 
    Primary pointer page: 599, Index root page: 600 
    Total formats: 1, used formats: 1 
    Average record length: 67.20, total records: 566215 
    Average version length: 68.80, total versions: 9144, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.87 
    Pointer pages: 5, data page slots: 8016 
    Data pages: 8016, average fill: 74% 
    Primary pages: 8015, secondary pages: 1, swept pages: 3044 
    Empty pages: 1, full pages: 6960 
    Fill distribution: 
     0 - 19% = 7 
    20 - 39% = 43 
    40 - 59% = 276 
    60 - 79% = 7589 
    80 - 99% = 101 
 
    Index XQS_3300_3400_DOC_ID (1) 
    Root page: 43398, depth: 3, leaf buckets: 730, nodes: 566215 
    Average node length: 5.94, total dup: 482159, max dup: 82 
    Average key length: 3.09, compression ratio: 2.91 
    Average prefix length: 8.06, average data length: 0.94 
    Clustering factor: 99599, ratio: 0.18 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 38 
        40 - 59% = 507 
        60 - 79% = 97 
        80 - 99% = 87 
 
    Index XQS_3300_3400_SND_ID (2) 
    Root page: 32142, depth: 3, leaf buckets: 752, nodes: 566215 
    Average node length: 6.15, total dup: 464410, max dup: 25 
    Average key length: 3.29, compression ratio: 2.73 
    Average prefix length: 7.89, average data length: 1.11 
    Clustering factor: 99649, ratio: 0.18 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 47 
        40 - 59% = 511 
        60 - 79% = 95 
        80 - 99% = 99 
 
    Index XQS_3300_3400_WORKER_ID (0) 
    Root page: 377587, depth: 2, leaf buckets: 563, nodes: 566215 
    Average node length: 4.86, total dup: 566115, max dup: 9210 
    Average key length: 2.00, compression ratio: 1.20 
    Average prefix length: 2.41, average data length: 0.00 
    Clustering factor: 88621, ratio: 0.16 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 30 
        40 - 59% = 320 
        60 - 79% = 96 
        80 - 99% = 115 
 
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 Mon Mar 25 10:09:25 2024

Record versions statistics, table

TABLE_NAME TOTAL_RECS TOTAL_VERS MAX_VERSIONS VERS_TO_RECS_PRC MAXV_TO_VERS_PRC
DOC_DATA 7778856 157828 1 0.0000 0.0000
DOC_LIST 2251699 80412 2 0.0000 0.0000
FB_ERRORS 2182 757 1 0.0000 0.0000
INVNT_SALDO 400 798 2 100.0000 0.0000
INVNT_TURNOVER_LOG 110984 83529 1 0.0000 0.0000
MONEY_SALDO 49 158 5 300.0000 0.0000
MONEY_TURNOVER_LOG 1754 1555 1 0.0000 0.0000
PDISTR 892605 46397 3 0.0000 0.0000
PERF_SPLIT_0 164030 1655 1 0.0000 0.0000
PERF_SPLIT_1 142766 4605 1 0.0000 0.0000
PERF_SPLIT_2 178828 47402 1 0.0000 0.0000
PERF_SPLIT_3 172282 22157 1 0.0000 0.0000
PERF_SPLIT_4 170538 30800 1 0.0000 0.0000
PERF_SPLIT_5 143421 5022 1 0.0000 0.0000
PERF_SPLIT_6 167025 17133 1 0.0000 0.0000
PERF_SPLIT_7 156221 13294 1 0.0000 0.0000
PERF_SPLIT_8 153548 6616 1 0.0000 0.0000
PERF_SPLIT_9 146342 5137 1 0.0000 0.0000
PSTORNED 2076171 63859 1 0.0000 0.0000
SEMAPHORES 5 1 1 0.0000 100.0000
XQD_1000_1200 171643 92913 1 0.0000 0.0000
XQD_1000_3300 7576257 663181 1 0.0000 0.0000
XQD_1200_2000 12548517 483518 1 0.0000 0.0000
XQD_2000_3300 2082411 628222 1 0.0000 0.0000
XQD_2100_3300 1776683 230606 1 0.0000 0.0000
XQD_3300_3400 9357754 798190 1 0.0000 0.0000
XQS_1000_1200 21151469 19599 1 0.0000 0.0000
XQS_1000_3300 9785229 787259 1 0.0000 0.0000
XQS_1200_2000 11222286 570509 1 0.0000 0.0000
XQS_2100_3300 9886461 777700 1 0.0000 0.0000
XQS_3300_3400 566215 9144 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 ---
:111: 
:112: mscs-test-161.budzdorov.ru    Mon Mar 25 10:08:02 2024
:113:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3400
:114: 
--- end of diff output ---

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

25.03.24 10:09:37. 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-25 10:09:40 No severe PSQL-related problems occured
25.03.24 10:09:41. End of report.