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

Hardware and OS info

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

Server and database settinfs 


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

Test configuration settings 

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

Test finish info 


FINISH_STATE                    NORMAL: TEST_TIME EXPIRED AT 2024-03-18 19:09:37
DTS_END                         2024-03-18 19:09:37.0190
FB_GDSCODE                      -1
FB_MNEMONA                      
STACK                           SP_ADD_INVOICE_TO_STOCK(190:30) ==> SP_CUSTOMER_RESERVE(47:5) ==> SP_CHECK_TO_STOP_WORK(32:12) ==> SP_HALT_ON_ERROR(57:17)
IP                              ::1/58214
TRN_ID                          172072
ATT_ID                          503
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: 9446.09 22838 944609
customer order: creation 170.12 385 17012
customer order: refuse 14.63 400 1463
order to supplier: creation 46.66 1341 4666
order to supplier: removal 3.58 98890 358
invoice (draft): creation 45.45 3648 4545
invoice (draft): removal 53.00 767 5300
invoice accept: apply 41.22 20807 4122
invoice accept: cancel 47.90 853 4790
customer reserve: creation 4000.02 197 400002
customer reserve: removal 4734.22 59 473422
realization accept: apply 83.28 184 8328
realization accept: cancel 77.98 127 7798
payment from customer: creation 58.03 127 5803
payment from customer: removal 5.70 64 570
payment to supplier: creation 48.65 155 4865
payment to supplier: removal 3.45 100 345
service: total inventory turnovers 4.58 1202 458
service: total monetary turnovers 6.83 45 683
service: aggregate perf. data 0.76 20879 76
service: refresh index statistics 0.03 306525 3

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:02, from 18-03-2024 19:10:33 to 18-03-2024 19:10:35.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 2280
TEST_TIME 2 3079
TEST_TIME 3 3780
TEST_TIME 4 3933
TEST_TIME 5 4738
TEST_TIME 6 5040
TEST_TIME 7 5347
TEST_TIME 8 5526
TEST_TIME 9 5696
TEST_TIME 10 5759
TEST_TIME 11 5892
TEST_TIME 12 6028
TEST_TIME 13 6080
TEST_TIME 14 6166
TEST_TIME 15 6192
TEST_TIME 16 6278
TEST_TIME 17 6374
TEST_TIME 18 6738
TEST_TIME 19 7638
TEST_TIME 20 7732
TEST_TIME 21 7912
TEST_TIME 22 8203
TEST_TIME 23 8464
TEST_TIME 24 8352
TEST_TIME 25 8582
TEST_TIME 26 9003
TEST_TIME 27 9820
TEST_TIME 28 9858
TEST_TIME 29 9525
TEST_TIME 30 9329
TEST_TIME 31 9157
TEST_TIME 32 9278
TEST_TIME 33 9366
TEST_TIME 34 9222
TEST_TIME 35 9166
TEST_TIME 36 9186
TEST_TIME 37 9282
TEST_TIME 38 9182
TEST_TIME 39 9064
TEST_TIME 40 8971
TEST_TIME 41 8963
TEST_TIME 42 9038
TEST_TIME 43 9108
TEST_TIME 44 9029
TEST_TIME 45 8958
TEST_TIME 46 8977
TEST_TIME 47 9013
TEST_TIME 48 8973
TEST_TIME 49 8991
TEST_TIME 50 9119
TEST_TIME 51 9113
TEST_TIME 52 9176
TEST_TIME 53 9203
TEST_TIME 54 9390
TEST_TIME 55 9337
TEST_TIME 56 9372
TEST_TIME 57 9429
TEST_TIME 58 9452
TEST_TIME 59 9512
TEST_TIME 60 9514
TEST_TIME 61 9377
TEST_TIME 62 9457
TEST_TIME 63 9388
TEST_TIME 64 9302
TEST_TIME 65 9298
TEST_TIME 66 9258
TEST_TIME 67 9213
TEST_TIME 68 9160
TEST_TIME 69 9116
TEST_TIME 70 9282
TEST_TIME 71 9280
TEST_TIME 72 9365
TEST_TIME 73 9347
TEST_TIME 74 9462
TEST_TIME 75 9492
TEST_TIME 76 9504
TEST_TIME 77 9498
TEST_TIME 78 9526
TEST_TIME 79 9584
TEST_TIME 80 9565
TEST_TIME 81 9546
TEST_TIME 82 9612
TEST_TIME 83 9516
TEST_TIME 84 9510
TEST_TIME 85 9446
TEST_TIME 86 9398
TEST_TIME 87 9438
TEST_TIME 88 9415
TEST_TIME 89 9371
TEST_TIME 90 9338
TEST_TIME 91 9312
TEST_TIME 92 9312
TEST_TIME 93 9319
TEST_TIME 94 9374
TEST_TIME 95 9334
TEST_TIME 96 9432
TEST_TIME 97 9417
TEST_TIME 98 9470
TEST_TIME 99 9483
TEST_TIME 100 9449

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:04, from 18-03-2024 19:10:36 to 18-03-2024 19:10:40.

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 1311505 1311505 0 0.00 0 18461 7 0 0
doc_list_biud 1311505 1311505 0 0.00 0 29357 27 0 0
sp_add_invoice_to_stock 4259 4122 137 3.21 34 167525 20808 0 137
sp_cancel_adding_invoice 4790 4790 0 0.00 4 74533 854 0 0
sp_cancel_client_order 1463 1463 0 0.00 5 20360 401 0 0
sp_cancel_customer_reserve 473422 473422 0 0.00 0 23821 59 0 0
sp_cancel_pay_from_customer 570 570 0 0.00 3 3117 65 0 0
sp_cancel_pay_to_supplier 345 345 0 0.00 3 3433 100 0 0
sp_cancel_supplier_invoice 5315 5300 15 0.28 1 13306 767 0 15
sp_cancel_supplier_order 358 358 0 0.00 9 1050349 98890 0 0
sp_cancel_write_off 7798 7798 0 0.00 1 7453 128 0 0
sp_client_order 17012 17012 0 0.00 3 18769 386 0 0
sp_customer_reserve 400002 400002 0 0.00 0 27167 197 0 0
sp_fill_shopping_cart 26183 26183 0 0.00 1 26700 35 0 0
sp_fill_shopping_cart_clo_res 399999 399999 0 0.00 0 10898 14 0 0
sp_get_clo_for_invoice 4117 4117 0 0.00 0 19317 304 0 0
sp_kill_cost_storno 13503 13503 0 0.00 0 9301 64 0 0
sp_kill_qstorno_ret_qs2qd 960300 960300 0 0.00 0 23817 32 0 0
sp_kill_qty_storno 505576 505576 0 0.00 0 29356 70 0 0
sp_lock_selected_doc 17268 17268 0 0.00 0 6313 5 0 0
sp_make_cost_storno 23113 23113 0 0.00 0 18457 68 0 0
sp_multiply_rows_for_pdistr 23113 23113 0 0.00 0 7615 29 0 0
sp_multiply_rows_for_qdistr 17012 17012 0 0.00 0 17224 171 0 0
sp_pay_from_customer 5803 5803 0 0.00 4 18467 127 0 0
sp_pay_to_supplier 4865 4865 0 0.00 5 15030 155 0 0
sp_payment_common 10668 10668 0 0.00 2 12864 32 0 0
sp_qd_handle_on_cancel_clo 1463 1463 0 0.00 0 20354 355 0 0
sp_qd_handle_on_invoice_upd_sts 8907 8907 0 0.00 0 29355 362 0 0
sp_qd_handle_on_reserve_upd_sts 8328 8328 0 0.00 0 11645 55 0 0
sp_reserve_write_off 8328 8328 0 0.00 6 15823 185 0 0
sp_supplier_invoice 4545 4545 0 0.00 6 79031 3648 0 0
sp_supplier_order 4666 4666 0 0.00 4 55825 1342 0 0
srv_aggregate_perf_data 76 76 0 0.00 2035 439845 20879 0 0
srv_fill_mon_cache_memory 55 55 0 0.00 825 119880 40901 0 0
srv_find_qd_qs_mism 902769 902769 0 0.00 0 8768 6 0 0
srv_make_invnt_saldo 458 458 0 0.00 53 57661 1203 0 0
srv_make_money_saldo 683 683 0 0.00 1 11043 45 0 0
srv_recalc_idx_stat 3 3 0 0.00 169718 385129 306526 0 0
t$perf-abend:sp_add_invoice_to_stock 137 137 0 0.00 0 0 0 0 0
t$perf-abend:sp_cancel_supplier_invoice 15 15 0 0.00 0 0 0 0 0
t$perf-norm:sp_add_invoice_to_stock 4122 4122 0 0.00 0 10509 200 0 0
t$perf-norm:sp_cancel_adding_invoice 336 336 0 0.00 0 1732 88 0 0
t$perf-norm:sp_cancel_client_order 1463 1463 0 0.00 0 2390 11 0 0
t$perf-norm:sp_cancel_customer_reserve 566 566 0 0.00 0 6294 25 0 0
t$perf-norm:sp_cancel_pay_from_customer 570 570 0 0.00 0 4778 23 0 0
t$perf-norm:sp_cancel_pay_to_supplier 345 345 0 0.00 0 2518 13 0 0
t$perf-norm:sp_cancel_supplier_invoice 348 348 0 0.00 0 620 16 0 0
t$perf-norm:sp_cancel_supplier_order 358 358 0 0.00 0 29818 1642 0 0
t$perf-norm:sp_cancel_write_off 837 837 0 0.00 0 7784 27 0 0
t$perf-norm:sp_client_order 17012 17012 0 0.00 0 9145 18 0 0
t$perf-norm:sp_customer_reserve 845 845 0 0.00 0 3585 8 0 0
t$perf-norm:sp_pay_from_customer 5803 5803 0 0.00 0 4465 8 0 0
t$perf-norm:sp_pay_to_supplier 4865 4865 0 0.00 0 11668 15 0 0
t$perf-norm:sp_reserve_write_off 8328 8328 0 0.00 0 11231 16 0 0
t$perf-norm:sp_supplier_invoice 4545 4545 0 0.00 0 7163 16 0 0
t$perf-norm:sp_supplier_order 4666 4666 0 0.00 0 3849 18 0 0
t$perf-norm:srv_aggregate_perf_data 76 76 0 0.00 0 697 13 0 0
t$perf-norm:srv_fill_mon_cache_memory 55 55 0 0.00 0 1371 27 0 0
t$perf-norm:srv_make_invnt_saldo 458 458 0 0.00 0 1031 27 0 0
t$perf-norm:srv_make_money_saldo 683 683 0 0.00 0 609 12 0 0
t$perf-norm:srv_recalc_idx_stat 3 3 0 0.00 2 10 5 0 0
v_add_invoice_to_stock 8508 8234 274 3.22 0 7004 20 0 274
v_all_customers 31596 31596 0 0.00 0 54 1 0 0
v_all_suppliers 25994 25994 0 0.00 0 21 1 0 0
v_all_wares 34024 34024 0 0.00 0 92 1 0 0
v_cancel_adding_invoice 672 672 0 0.00 0 325 7 0 0
v_cancel_client_order 2926 2926 0 0.00 0 3324 9 0 0
v_cancel_customer_prepayment 1140 1140 0 0.00 0 2446 10 0 0
v_cancel_customer_reserve 1132 1132 0 0.00 0 2556 7 0 0
v_cancel_payment_to_supplier 690 690 0 0.00 0 3165 12 0 0
v_cancel_supplier_invoice 726 696 30 4.13 0 791 17 0 30
v_cancel_supplier_order 716 716 0 0.00 0 2422 8 0 0
v_cancel_write_off 1674 1674 0 0.00 0 2386 16 0 0
v_max_id_clo_ord 4666 4666 0 0.00 0 461 1 0 0
v_max_id_clo_res 845 845 0 0.00 0 2300 12 0 0
v_max_id_ord_sup 4504 4504 0 0.00 0 3003 2 0 0
v_max_non_paid_invoice 1038 1038 0 0.00 0 800 4 0 0
v_max_non_paid_realizn 2839 2839 0 0.00 0 4230 7 0 0
v_min_id_clo_ord 4666 4666 0 0.00 0 2885 8 0 0
v_min_id_clo_res 845 845 0 0.00 0 7924 24 0 0
v_min_id_ord_sup 4504 4504 0 0.00 0 6636 9 0 0
v_min_non_paid_invoice 4865 4865 0 0.00 0 6035 23 0 0
v_min_non_paid_realizn 5803 5803 0 0.00 0 5658 23 0 0
v_our_firm 8356 8356 0 0.00 0 18 1 0 0
v_reserve_write_off 16656 16656 0 0.00 0 7269 7 0 0
x_lock_depdocs_on_canc_invoice 9742 9742 0 0.00 0 14059 137 0 0
x_lock_depdocs_on_canc_sup_ord 358 358 0 0.00 0 2804 289 0 0
x_make_qstorno_1000_1200 4666 4666 0 0.00 2 55806 1261 0 0
x_make_qstorno_1200_2000 4545 4545 0 0.00 3 76979 3512 0 0
x_make_qstorno_2100_3300 400002 400002 0 0.00 0 26262 180 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 18-03-2024 19:10:41 to 18-03-2024 19:10:45.

Memory consumption, metadata cache, attachments activity 

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


Page cache type: shared, buffers: 1000000 for all connections, with total size: 8192000000
measurement_dts measurement duration ms page cache memo used memo used, total memo allocated, total metadata cache metadata cache percent of total total attachments cnt active attachments cnt running statements cnt stalled statements cnt memo used by attachments memo used by transactions memo used by statements
17:09:40 2 8192000000 8797116944 8807743488 3953616 0.048 1 1 2 0 4051888 55488 42784
17:10:42 22433 8192000000 9891597216 10197299200 973945776 10.625 100 91 180 0 1003358480 5045264 24367440
17:12:09 32063 8192000000 9936949456 10258087936 1023537712 11.106 100 92 184 0 1055028560 7859088 23631760
17:13:51 11554 8192000000 9972289120 10299879424 1052517888 11.385 100 85 172 0 1082871376 8875600 21477888
17:15:07 9968 8192000000 10011136832 10360803328 1105931392 11.894 100 68 136 1 1131421968 9521760 15968816
17:16:20 4477 8192000000 10086663264 10442588160 1167706416 12.475 100 84 168 0 1199185488 12269360 19209712
17:17:31 4368 8192000000 10125141008 10492133376 1213536304 12.902 100 83 166 0 1245545680 14146208 17863168
17:18:38 2100 8192000000 10157481232 10530844672 1245796912 13.200 100 85 166 0 1277054704 13294928 17962864
17:19:42 1189 8192000000 10193400768 10572173312 1279386688 13.507 100 85 169 1 1311877472 13080944 19409840
17:20:44 979 8192000000 10210068144 10592014336 1295433152 13.654 100 94 187 0 1329926224 13036048 21457024
17:21:46 3182 8192000000 10195912224 10598023168 1296792592 13.666 100 53 107 0 1318615024 10679920 11142512
17:22:52 7799 8192000000 10195711872 10609414144 1309162528 13.778 100 14 28 0 1318524400 5441184 3920688
17:24:00 14194 8192000000 10195747088 10616807424 1318050832 13.859 100 19 38 1 1328686928 5349552 5286544
17:25:15 21329 8192000000 10215963360 10635075584 1320614640 13.882 100 22 44 0 1335701088 10605744 4480704
17:26:39 15191 8192000000 10214918016 10636181504 1323449776 13.908 100 18 36 0 1333051600 5159008 4442816
17:27:55 10180 8192000000 10214941104 10638524416 1328078224 13.950 100 19 38 0 1338649968 5776688 4795056
17:29:06 44392 8192000000 10240935632 10651336704 1335266080 14.015 100 51 100 2 1353574864 5254592 13054192
17:31:06 22497 8192000000 10253082592 10670149632 1335595296 14.018 99 38 72 1 1354637008 10788320 8253392
17:32:32 13523 8192000000 10247438880 10658254848 1320181200 13.878 98 54 106 1 1347761248 15309984 12270064
17:33:56 3155 8192000000 10260451168 10668023808 1335500784 14.017 99 69 135 0 1367731984 17227200 15004000
17:35:01 25758 8192000000 10275086896 10686296064 1331683568 13.982 98 46 89 1 1363204784 21236960 10284256
17:36:31 19093 8192000000 10251631648 10661388288 1306787616 13.757 97 52 102 1 1340046400 21563216 11695568
17:37:55 12673 8192000000 10253159904 10662559744 1332448416 13.989 100 50 100 1 1368083248 23893248 11741584
17:39:11 18855 8192000000 10255292320 10661773312 1328347920 13.952 99 50 97 1 1361495104 21694864 11452320
17:40:32 6267 8192000000 10252655568 10647805952 1300752816 13.702 98 69 139 3 1341873072 24822928 16297328
17:41:46 6649 8192000000 10265803088 10660909056 1322299616 13.898 99 72 141 0 1366149616 26696736 17153264
17:42:57 4389 8192000000 10288345296 10681958400 1345142240 14.104 100 82 162 0 1396675296 32925968 18607088
17:44:05 1206 8192000000 10307145856 10705776640 1357160064 14.212 100 75 148 1 1412513680 37885136 17468480
17:45:11 7703 8192000000 10297533584 10706845696 1351776768 14.163 100 51 102 1 1406891760 41406592 13708400
17:46:24 7671 8192000000 10328478768 10734149632 1361226848 14.248 100 60 119 2 1430733056 54167408 15338800
17:47:38 2348 8192000000 10352467328 10753966080 1379403424 14.411 100 82 162 1 1452024480 52926400 19694656
17:48:44 4206 8192000000 10329305280 10750394368 1385717936 14.468 100 43 86 0 1436208720 39443120 11047664
17:49:57 2089 8192000000 10332410208 10745823232 1374787792 14.370 99 71 137 3 1428803408 36066192 17949424
17:51:03 3140 8192000000 10332556624 10755772416 1386071536 14.471 100 48 98 2 1439940544 40426192 13442816
17:52:09 19937 8192000000 10312448320 10747764736 1369833952 14.326 99 20 40 0 1414519424 39275072 5410400
17:53:35 15084 8192000000 10314880128 10747019264 1363768928 14.271 100 21 42 0 1417638304 47771552 6097824
17:55:32 5368 8192000000 10327723728 10757844992 1370687952 14.333 100 40 80 0 1429926384 49185072 10053360
17:56:40 33835 8192000000 10269002048 10715316224 1352329664 14.168 99 9 18 2 1366635952 11700000 2606288
17:58:21 52743 8192000000 10287642592 10720964608 1360413296 14.241 99 57 115 1 1379774176 5758928 13601952
18:00:16 20653 8192000000 10298640576 10726641664 1377818544 14.397 100 52 100 3 1398579424 10140048 10620832
18:01:39 13394 8192000000 10290432208 10733232128 1380630624 14.422 100 38 73 1 1403005344 14534400 7840320
18:02:59 41499 8192000000 10277575616 10732433408 1382970576 14.443 100 14 28 0 1395775824 9667104 3138144
18:04:46 84677 8192000000 10288643728 10752208896 1378812720 14.406 99 21 42 1 1401109776 16709472 5587584
18:07:14 48740 8192000000 10296945424 10744791040 1381965760 14.434 99 29 58 0 1397149008 8775696 6407552
18:09:09 15804 8192000000 10304409088 10750300160 1393817344 14.540 99 33 66 0 1416450240 14825216 7807680
18:10:27 67130 8192000000 10320774544 10771214336 1403775616 14.629 100 31 62 0 1429950544 18605152 7569776
18:12:44 46090 8192000000 10284105680 10733576192 1369498512 14.323 98 16 28 2 1383470832 11198016 2774304
18:14:31 60558 8192000000 10306169680 10767515648 1403830544 14.629 100 18 36 1 1423934128 15540192 4563392
18:17:50 45947 8192000000 10302516080 10750492672 1377526176 14.394 99 34 68 0 1399872256 14582848 7763232
18:19:36 43466 8192000000 10278717888 10736717824 1374370288 14.366 99 21 42 0 1394381776 15106400 4905088
18:23:18 36018 8192000000 10262192000 10707742720 1339092480 14.049 98 15 30 0 1358358816 15820304 3446032
18:24:56 50412 8192000000 10266679552 10706960384 1301582240 13.710 96 25 50 0 1322417856 15503536 5332080
18:26:49 119880 8192000000 10284644544 10728210432 1260680032 13.336 92 19 36 1 1278519488 13860848 3978608
18:29:50 71658 8192000000 10248733952 10683699200 1308243088 13.770 97 15 30 0 1325780160 14297104 3239968
18:32:24 60542 8192000000 10249079296 10700664832 1344864480 14.101 100 22 44 2 1365689712 16351248 4473984
18:34:27 824 8192000000 10269263632 10695827456 1350549616 14.152 100 59 114 1 1374148544 10517504 13081424
18:35:29 52333 8192000000 10258076112 10707476480 1352431696 14.169 100 15 30 0 1370409984 14147424 3830864
18:37:28 67007 8192000000 10257537648 10700410880 1350889872 14.155 99 18 36 0 1373275280 17904768 4480640
18:39:37 31992 8192000000 10258380672 10696531968 1338098304 14.040 98 27 54 1 1352666912 8801344 5767264
18:41:09 115252 8192000000 10307580272 10764173312 1355237568 14.195 98 14 25 1 1367707824 10455440 2014816
18:44:06 80318 8192000000 10299459776 10751397888 1377407952 14.393 99 13 26 1 1391957984 11952816 2597216
18:46:26 57860 8192000000 10310028512 10760966144 1365263840 14.285 98 36 73 1 1387852048 15137904 7450304
18:48:29 97386 8192000000 10301401328 10749693952 1355694368 14.199 97 15 30 0 1368766528 9748608 3323552
18:51:06 62406 8192000000 10295734368 10758516736 1377303184 14.392 99 21 42 0 1399889312 18021872 4564256
18:54:03 82660 8192000000 10320683552 10767716352 1389687200 14.503 99 30 60 0 1406057664 9801728 6568736
18:56:26 44840 8192000000 10295513312 10755743744 1376857840 14.388 98 15 30 0 1396754896 16301776 3595280
18:58:12 46320 8192000000 10302356464 10755166208 1400443600 14.599 100 11 22 0 1410442016 7383264 2615152
18:59:58 97936 8192000000 10302897680 10765959168 1389189184 14.499 99 18 36 0 1410002544 16400720 4412640
19:02:44 68670 8192000000 10291385664 10756116480 1371222912 14.338 97 14 28 0 1383879568 9129168 3527488
19:04:52 85707 8192000000 10290038624 10742394880 1312108496 13.805 93 27 54 1 1330660064 12271312 6280256
19:07:18 98974 8192000000 10262179488 10717585408 1320909024 13.885 96 19 38 0 1339588816 14563152 4116640

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:13, from 18-03-2024 19:10:47 to 18-03-2024 19:11:00.

Exceptions occured during test was in run

FB_MNEMONA CNT UNIT FB_GDSCODE
except 137 v_add_invoice_to_stock 335544517
except 15 v_cancel_supplier_invoice 335544517

Completed "Exceptions occured during test was in run". Done for 00:00:02, from 18-03-2024 19:11:01 to 18-03-2024 19:11:03.

Content of mon$database and FB version 


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


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

Database statistics 

 
Database "/home/bases/oltp30-etalone.fdb" 
Gstat execution time Mon Mar 18 19:11:04 2024 
 
Database header page information: 
    Flags            0 
    Generation        89900 
    System Change Number    0 
    Page size        8192 
    ODS version        12.0 
    Oldest transaction    171291 
    Oldest active        172367 
    Oldest snapshot        172367 
    Next transaction    172368 
    Sequence number        0 
    Next attachment ID    705 
    Implementation        HW=AMD/Intel/x64 little-endian OS=Linux CC=gcc 
    Shadow count        0 
    Page buffers        0 
    Next header page    0 
    Database dialect    3 
    Creation date        Apr 3, 2020 16:41:55 
    Attributes        force write 
 
    Variable header data: 
    Sweep interval:        0 
    Unrecognized option 11, length 16 
    *END* 
 
 
Database file sequence: 
File /home/bases/oltp30-etalone.fdb is the only file 
 
Analyzing database pages ... 
AGENTS (150) 
    Primary pointer page: 496, Index root page: 497 
    Total formats: 1, used formats: 1 
    Average record length: 33.60, total records: 50 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 344.00, compression ratio: 10.24 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 31% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 1 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index AGENTS_ID_DESC (2) 
    Root page: 1504311, depth: 1, leaf buckets: 1, nodes: 50 
    Average node length: 11.82, total dup: 0, max dup: 0 
    Average key length: 10.80, compression ratio: 0.83 
    Average prefix length: 1.18, average data length: 7.82 
    Clustering factor: 1, ratio: 0.02 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index AGENTS_IS_OUR_FIRM (4) 
    Root page: 1504313, depth: 1, leaf buckets: 1, nodes: 50 
    Average node length: 3.08, total dup: 48, max dup: 48 
    Average key length: 2.04, compression ratio: 0.50 
    Average prefix length: 0.96, average data length: 0.06 
    Clustering factor: 1, ratio: 0.02 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index AGENTS_IS_SUPPLIER (3) 
    Root page: 1504312, depth: 1, leaf buckets: 1, nodes: 50 
    Average node length: 3.08, total dup: 48, max dup: 44 
    Average key length: 2.04, compression ratio: 0.54 
    Average prefix length: 1.04, average data length: 0.06 
    Clustering factor: 1, ratio: 0.02 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index AGENTS_NAME_UNQ (1) 
    Root page: 1504310, depth: 1, leaf buckets: 1, nodes: 50 
    Average node length: 17.20, total dup: 0, max dup: 0 
    Average key length: 15.88, compression ratio: 0.92 
    Average prefix length: 1.42, average data length: 13.20 
    Clustering factor: 1, ratio: 0.02 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PK_AGENTS (0) 
    Root page: 1504309, depth: 1, leaf buckets: 1, nodes: 50 
    Average node length: 11.82, total dup: 0, max dup: 0 
    Average key length: 10.80, compression ratio: 0.83 
    Average prefix length: 1.18, average data length: 7.82 
    Clustering factor: 1, ratio: 0.02 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
BUSINESS_OPS (154) 
    Primary pointer page: 504, Index root page: 505 
    Total formats: 1, used formats: 1 
    Average record length: 108.20, total records: 20 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1235.00, compression ratio: 11.41 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 31% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 1 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index BO_UNIT_UNQ (1) 
    Root page: 1504242, depth: 1, leaf buckets: 1, nodes: 20 
    Average node length: 18.25, total dup: 0, max dup: 0 
    Average key length: 17.20, compression ratio: 1.24 
    Average prefix length: 7.05, average data length: 14.25 
    Clustering factor: 1, ratio: 0.05 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index BUSINESS_OPS_PREDICT_PRIOR (3) 
    Root page: 1504244, depth: 1, leaf buckets: 1, nodes: 20 
    Average node length: 5.40, total dup: 0, max dup: 0 
    Average key length: 4.35, compression ratio: 0.67 
    Average prefix length: 1.20, average data length: 1.70 
    Clustering factor: 1, ratio: 0.05 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index BUSINESS_OPS_RND_WGTH (2) 
    Root page: 1504243, depth: 1, leaf buckets: 1, nodes: 20 
    Average node length: 4.30, total dup: 6, max dup: 3 
    Average key length: 3.25, compression ratio: 0.72 
    Average prefix length: 1.35, average data length: 1.00 
    Clustering factor: 1, ratio: 0.05 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index RDB$1 (0) 
    Root page: 1504241, depth: 1, leaf buckets: 1, nodes: 20 
    Average node length: 5.20, total dup: 0, max dup: 0 
    Average key length: 4.15, compression ratio: 0.65 
    Average prefix length: 1.10, average data length: 1.60 
    Clustering factor: 1, ratio: 0.05 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
DOC_DATA (139) 
    Primary pointer page: 474, Index root page: 475 
    Total formats: 1, used formats: 1 
    Average record length: 47.06, total records: 7733790 
    Average version length: 48.16, total versions: 133438, 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: 54, data page slots: 86672 
    Data pages: 86672, average fill: 71% 
    Primary pages: 86672, secondary pages: 0, swept pages: 13061 
    Empty pages: 1, full pages: 74162 
    Fill distribution: 
     0 - 19% = 12 
    20 - 39% = 279 
    40 - 59% = 4381 
    60 - 79% = 81933 
    80 - 99% = 67 
 
    Index DOC_DATA_DOC_WARE_UNQ (0) 
    Root page: 1510614, depth: 3, leaf buckets: 23290, nodes: 7733790 
    Average node length: 18.87, total dup: 0, max dup: 0 
    Average key length: 15.88, compression ratio: 1.70 
    Average prefix length: 14.11, average data length: 12.89 
    Clustering factor: 1716569, ratio: 0.22 
    Fill distribution: 
         0 - 19% = 344 
        20 - 39% = 1782 
        40 - 59% = 4222 
        60 - 79% = 2552 
        80 - 99% = 14390 
 
    Index DOC_DATA_ID_DESC (1) 
    Root page: 1528118, depth: 3, leaf buckets: 13522, nodes: 7733790 
    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: 1539029, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 1540 
        40 - 59% = 2107 
        60 - 79% = 1216 
        80 - 99% = 8658 
 
    Index FK_DOC_DATA_DOC_LIST (2) 
    Root page: 1546711, depth: 3, leaf buckets: 8344, nodes: 7733790 
    Average node length: 6.61, total dup: 5795133, max dup: 49 
    Average key length: 3.62, compression ratio: 2.49 
    Average prefix length: 7.63, average data length: 1.37 
    Clustering factor: 1532128, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 143 
        20 - 39% = 966 
        40 - 59% = 1378 
        60 - 79% = 990 
        80 - 99% = 4867 
 
DOC_LIST (138) 
    Primary pointer page: 472, Index root page: 473 
    Total formats: 1, used formats: 1 
    Average record length: 55.69, total records: 2229037 
    Average version length: 34.70, total versions: 133909, max versions: 3 
    Average fragment length: 6.00, total fragments: 2, max fragments: 1 
    Average unpacked length: 84.00, compression ratio: 1.51 
    Pointer pages: 18, data page slots: 28376 
    Data pages: 28376, average fill: 73% 
    Primary pages: 28369, secondary pages: 7, swept pages: 7972 
    Empty pages: 8, full pages: 21291 
    Fill distribution: 
     0 - 19% = 37 
    20 - 39% = 224 
    40 - 59% = 2008 
    60 - 79% = 24917 
    80 - 99% = 1190 
 
    Index DOC_LIST_ID_DESC (1) 
    Root page: 1541130, depth: 3, leaf buckets: 4558, nodes: 2229037 
    Average node length: 11.41, total dup: 0, max dup: 0 
    Average key length: 8.45, compression ratio: 1.07 
    Average prefix length: 3.55, average data length: 5.45 
    Clustering factor: 693335, ratio: 0.31 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 954 
        40 - 59% = 841 
        60 - 79% = 771 
        80 - 99% = 1992 
 
    Index DOC_LIST_WORKER_OPTYPE (2) 
    Root page: 1544376, depth: 3, leaf buckets: 2535, nodes: 2232472 
    Average node length: 4.97, total dup: 2231573, max dup: 17949 
    Average key length: 2.01, compression ratio: 4.47 
    Average prefix length: 8.99, average data length: 0.01 
    Clustering factor: 1237751, ratio: 0.55 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 307 
        40 - 59% = 1533 
        60 - 79% = 514 
        80 - 99% = 180 
 
    Index FK_DOC_LIST_AGENTS (3) 
    Root page: 1545909, depth: 3, leaf buckets: 1985, nodes: 2229037 
    Average node length: 4.97, total dup: 2228987, max dup: 130181 
    Average key length: 2.01, compression ratio: 4.48 
    Average prefix length: 8.99, average data length: 0.01 
    Clustering factor: 1053829, ratio: 0.47 
    Fill distribution: 
         0 - 19% = 3 
        20 - 39% = 48 
        40 - 59% = 1007 
        60 - 79% = 90 
        80 - 99% = 837 
 
    Index PK_DOC_LIST (0) 
    Root page: 1538187, depth: 3, leaf buckets: 4345, nodes: 2229037 
    Average node length: 11.41, total dup: 0, max dup: 0 
    Average key length: 8.45, compression ratio: 1.07 
    Average prefix length: 3.55, average data length: 5.45 
    Clustering factor: 693335, ratio: 0.31 
    Fill distribution: 
         0 - 19% = 102 
        20 - 39% = 635 
        40 - 59% = 607 
        60 - 79% = 857 
        80 - 99% = 2144 
 
DOC_STATES (149) 
    Primary pointer page: 494, Index root page: 495 
    Total formats: 1, used formats: 1 
    Average record length: 67.50, total records: 4 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 650.00, compression ratio: 9.63 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 4% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index DOC_STATES_MCODE_UNQ (1) 
    Root page: 1504315, depth: 1, leaf buckets: 1, nodes: 4 
    Average node length: 17.75, total dup: 0, max dup: 0 
    Average key length: 16.50, compression ratio: 1.08 
    Average prefix length: 4.00, average data length: 13.75 
    Clustering factor: 1, ratio: 0.25 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index DOC_STATES_NAME_UNQ (2) 
    Root page: 1504316, depth: 1, leaf buckets: 1, nodes: 4 
    Average node length: 33.25, total dup: 0, max dup: 0 
    Average key length: 32.00, compression ratio: 0.99 
    Average prefix length: 2.50, average data length: 29.25 
    Clustering factor: 1, ratio: 0.25 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PK_DOC_STATES (0) 
    Root page: 1504314, depth: 1, leaf buckets: 1, nodes: 4 
    Average node length: 4.75, total dup: 0, max dup: 0 
    Average key length: 3.50, compression ratio: 0.86 
    Average prefix length: 1.50, average data length: 1.50 
    Clustering factor: 1, ratio: 0.25 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
FB_ERRORS (155) 
    Primary pointer page: 506, Index root page: 507 
    Total formats: 2, used formats: 2 
    Average record length: 54.76, total records: 2182 
    Average version length: 79.61, total versions: 757, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 270.43, compression ratio: 4.94 
    Pointer pages: 1, data page slots: 40 
    Data pages: 40, average fill: 70% 
    Primary pages: 40, secondary pages: 0, swept pages: 0 
    Empty pages: 7, full pages: 32 
    Fill distribution: 
     0 - 19% = 7 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 7 
    80 - 99% = 26 
 
    Index FB_ERRORS_GDS_CODE (0) 
    Root page: 382, depth: 2, leaf buckets: 2, nodes: 2182 
    Average node length: 4.40, total dup: 756, max dup: 1 
    Average key length: 2.67, compression ratio: 1.87 
    Average prefix length: 4.33, average data length: 0.67 
    Clustering factor: 1515, ratio: 0.69 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 0 
        40 - 59% = 1 
        60 - 79% = 1 
        80 - 99% = 0 
 
INVNT_SALDO (145) 
    Primary pointer page: 486, Index root page: 487 
    Total formats: 2, used formats: 1 
    Average record length: 82.75, total records: 400 
    Average version length: 23.02, total versions: 223683, max versions: 584 
    Average fragment length: 2.00, total fragments: 29, max fragments: 1 
    Average unpacked length: 104.00, compression ratio: 1.26 
    Pointer pages: 1, data page slots: 1224 
    Data pages: 1224, average fill: 91% 
    Primary pages: 12, secondary pages: 1212, swept pages: 0 
    Empty pages: 5, full pages: 1218 
    Fill distribution: 
     0 - 19% = 5 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 1 
    80 - 99% = 1218 
 
    Index PK_INVNT_SALDO (0) 
    Root page: 1510349, depth: 1, leaf buckets: 1, nodes: 400 
    Average node length: 11.22, total dup: 0, max dup: 0 
    Average key length: 10.22, compression ratio: 0.88 
    Average prefix length: 1.78, average data length: 7.22 
    Clustering factor: 326, ratio: 0.81 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 0 
        40 - 59% = 1 
        60 - 79% = 0 
        80 - 99% = 0 
 
INVNT_TURNOVER_LOG (153) 
    Primary pointer page: 502, Index root page: 503 
    Total formats: 1, used formats: 1 
    Average record length: 13.08, total records: 138812 
    Average version length: 68.28, total versions: 112242, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 88.00, compression ratio: 6.73 
    Pointer pages: 7, data page slots: 3560 
    Data pages: 2016, average fill: 84% 
    Primary pages: 2015, secondary pages: 1, swept pages: 0 
    Empty pages: 33, full pages: 1787 
    Fill distribution: 
     0 - 19% = 49 
    20 - 39% = 37 
    40 - 59% = 74 
    60 - 79% = 213 
    80 - 99% = 1643 
 
    Index INVNT_TURNOVER_LOG_WARE_DD_ID (0) 
    Root page: 1703464, depth: 3, leaf buckets: 399, nodes: 138812 
    Average node length: 13.46, total dup: 10328, max dup: 2 
    Average key length: 10.61, compression ratio: 2.54 
    Average prefix length: 19.31, average data length: 7.69 
    Clustering factor: 102812, ratio: 0.74 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 2 
        40 - 59% = 250 
        60 - 79% = 141 
        80 - 99% = 4 
 
MONEY_SALDO (141) 
    Primary pointer page: 478, Index root page: 479 
    Total formats: 1, used formats: 1 
    Average record length: 15.18, total records: 49 
    Average version length: 9.00, total versions: 16717, max versions: 948 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 32.00, compression ratio: 2.11 
    Pointer pages: 1, data page slots: 64 
    Data pages: 64, average fill: 84% 
    Primary pages: 6, secondary pages: 58, swept pages: 0 
    Empty pages: 5, full pages: 58 
    Fill distribution: 
     0 - 19% = 6 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 1 
    80 - 99% = 57 
 
    Index PK_MONEY_SALDO (0) 
    Root page: 1510361, depth: 1, leaf buckets: 1, nodes: 49 
    Average node length: 11.82, total dup: 0, max dup: 0 
    Average key length: 10.80, compression ratio: 0.83 
    Average prefix length: 1.18, average data length: 7.82 
    Clustering factor: 1, ratio: 0.02 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
MONEY_TURNOVER_LOG (140) 
    Primary pointer page: 476, Index root page: 477 
    Total formats: 1, used formats: 1 
    Average record length: 2.00, total records: 1824 
    Average version length: 44.00, total versions: 1742, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 58.00, compression ratio: 29.04 
    Pointer pages: 1, data page slots: 32 
    Data pages: 32, average fill: 55% 
    Primary pages: 31, secondary pages: 1, swept pages: 0 
    Empty pages: 6, full pages: 15 
    Fill distribution: 
     0 - 19% = 7 
    20 - 39% = 4 
    40 - 59% = 4 
    60 - 79% = 6 
    80 - 99% = 11 
 
    Index MONEY_TURNOVER_LOG_AGENT_OPTYPE (0) 
    Root page: 88097, depth: 2, leaf buckets: 3, nodes: 1824 
    Average node length: 4.29, total dup: 1726, max dup: 185 
    Average key length: 2.58, compression ratio: 7.37 
    Average prefix length: 18.48, average data length: 0.52 
    Clustering factor: 927, ratio: 0.51 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 3 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
MON_CACHE_MEMORY (165) 
    Primary pointer page: 526, Index root page: 527 
    Total formats: 2, used formats: 1 
    Average record length: 97.11, 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: 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% = 1 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 1 
 
    Index PK_MON_CACHE_MEMORY (0) 
    Root page: 1504215, depth: 1, leaf buckets: 1, nodes: 71 
    Average node length: 11.70, total dup: 0, max dup: 0 
    Average key length: 10.69, compression ratio: 0.84 
    Average prefix length: 1.30, average data length: 7.70 
    Clustering factor: 2, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
MON_LOG (162) 
    Primary pointer page: 520, Index root page: 521 
    Total formats: 2, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index MON_LOG_DTS (4) 
    Root page: 1504229, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index MON_LOG_GDSCODE (2) 
    Root page: 1504227, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index MON_LOG_ROWSET_DESC (1) 
    Root page: 1504226, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index MON_LOG_UNIT (3) 
    Root page: 1504228, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PK_MON_LOG (0) 
    Root page: 1504225, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
MON_LOG_TABLE_STATS (163) 
    Primary pointer page: 522, Index root page: 523 
    Total formats: 2, used formats: 1 
    Average record length: 67.13, total records: 30 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 611.00, compression ratio: 9.10 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 31% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 1 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index MON_LOG_TABLE_STATS_DTS (4) 
    Root page: 1504224, depth: 1, leaf buckets: 1, nodes: 30 
    Average node length: 3.50, total dup: 23, max dup: 4 
    Average key length: 2.47, compression ratio: 3.24 
    Average prefix length: 7.53, average data length: 0.47 
    Clustering factor: 1, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index MON_LOG_TABLE_STATS_GDSCODE (2) 
    Root page: 1504222, depth: 1, leaf buckets: 1, nodes: 30 
    Average node length: 2.00, total dup: 29, max dup: 29 
    Average key length: 1.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 1, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index MON_LOG_TABLE_STATS_ROWSET (1) 
    Root page: 1504221, depth: 1, leaf buckets: 1, nodes: 30 
    Average node length: 3.33, total dup: 29, max dup: 29 
    Average key length: 2.30, compression ratio: 3.91 
    Average prefix length: 8.70, average data length: 0.30 
    Clustering factor: 1, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index MON_LOG_TABLE_STATS_TN_UNIT (3) 
    Root page: 1504223, depth: 1, leaf buckets: 1, nodes: 30 
    Average node length: 12.90, total dup: 0, max dup: 0 
    Average key length: 11.87, compression ratio: 1.42 
    Average prefix length: 7.63, average data length: 9.20 
    Clustering factor: 1, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PK_MON_LOG_TABLE_STATS (0) 
    Root page: 1504220, depth: 1, leaf buckets: 1, nodes: 30 
    Average node length: 8.37, total dup: 0, max dup: 0 
    Average key length: 7.33, compression ratio: 1.23 
    Average prefix length: 4.63, average data length: 4.37 
    Clustering factor: 1, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
OPTYPES (136) 
    Primary pointer page: 468, Index root page: 469 
    Total formats: 2, used formats: 1 
    Average record length: 67.56, total records: 9 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 386.00, compression ratio: 5.71 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 9% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index OPTYPES_MCODE_UNQ (1) 
    Root page: 1544805, depth: 1, leaf buckets: 1, nodes: 9 
    Average node length: 8.56, total dup: 0, max dup: 0 
    Average key length: 6.89, compression ratio: 0.73 
    Average prefix length: 0.44, average data length: 4.56 
    Clustering factor: 1, ratio: 0.11 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PK_OPTYPES (0) 
    Root page: 1544804, depth: 1, leaf buckets: 1, nodes: 9 
    Average node length: 6.11, total dup: 0, max dup: 0 
    Average key length: 5.00, compression ratio: 0.60 
    Average prefix length: 0.89, average data length: 2.11 
    Clustering factor: 1, ratio: 0.11 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
PDISTR (146) 
    Primary pointer page: 488, Index root page: 489 
    Total formats: 1, used formats: 1 
    Average record length: 35.61, total records: 831967 
    Average version length: 25.33, total versions: 91546, max versions: 6 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 54.00, compression ratio: 1.52 
    Pointer pages: 5, data page slots: 8096 
    Data pages: 8096, average fill: 72% 
    Primary pages: 8073, secondary pages: 23, swept pages: 886 
    Empty pages: 6, full pages: 7836 
    Fill distribution: 
     0 - 19% = 7 
    20 - 39% = 15 
    40 - 59% = 36 
    60 - 79% = 7611 
    80 - 99% = 427 
 
    Index PDISTR_AGENT_ID (2) 
    Root page: 1509308, depth: 2, leaf buckets: 911, nodes: 831967 
    Average node length: 4.87, total dup: 831918, max dup: 161105 
    Average key length: 2.01, compression ratio: 4.48 
    Average prefix length: 8.99, average data length: 0.01 
    Clustering factor: 89937, ratio: 0.11 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 106 
        40 - 59% = 531 
        60 - 79% = 210 
        80 - 99% = 63 
 
    Index PDISTR_SNDOP_RCVOP_SNDID_ASC (0) 
    Root page: 1508613, depth: 3, leaf buckets: 938, nodes: 831967 
    Average node length: 5.88, total dup: 740451, max dup: 55 
    Average key length: 3.02, compression ratio: 7.28 
    Average prefix length: 21.09, average data length: 0.91 
    Clustering factor: 163067, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 85 
        40 - 59% = 425 
        60 - 79% = 94 
        80 - 99% = 334 
 
    Index PDISTR_SNDOP_RCVOP_SNDID_DESC (1) 
    Root page: 1509187, depth: 3, leaf buckets: 979, nodes: 831967 
    Average node length: 5.89, total dup: 740451, max dup: 55 
    Average key length: 3.02, compression ratio: 7.28 
    Average prefix length: 21.09, average data length: 0.91 
    Clustering factor: 165078, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 175 
        40 - 59% = 385 
        60 - 79% = 78 
        80 - 99% = 341 
 
    Index PDISTR_WORKER_SND_ID (3) 
    Root page: 1510178, depth: 3, leaf buckets: 1172, nodes: 831967 
    Average node length: 5.97, total dup: 740451, max dup: 55 
    Average key length: 3.10, compression ratio: 5.48 
    Average prefix length: 16.01, average data length: 0.99 
    Clustering factor: 157279, ratio: 0.19 
    Fill distribution: 
         0 - 19% = 4 
        20 - 39% = 234 
        40 - 59% = 633 
        60 - 79% = 199 
        80 - 99% = 102 
 
PERF_AGG (158) 
    Primary pointer page: 512, Index root page: 513 
    Total formats: 1, used formats: 1 
    Average record length: 62.82, total records: 5481 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 2.79, total fragments: 86, max fragments: 1 
    Average unpacked length: 379.00, compression ratio: 6.03 
    Pointer pages: 1, data page slots: 96 
    Data pages: 96, average fill: 57% 
    Primary pages: 76, secondary pages: 20, swept pages: 53 
    Empty pages: 12, full pages: 63 
    Fill distribution: 
     0 - 19% = 24 
    20 - 39% = 1 
    40 - 59% = 1 
    60 - 79% = 67 
    80 - 99% = 3 
 
    Index PERF_AGG_UNQ (1) 
    Root page: 1504238, depth: 2, leaf buckets: 6, nodes: 5481 
    Average node length: 5.47, total dup: 0, max dup: 0 
    Average key length: 3.58, compression ratio: 10.06 
    Average prefix length: 34.49, average data length: 1.54 
    Clustering factor: 5181, 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: 1504233, depth: 2, leaf buckets: 10, nodes: 5481 
    Average node length: 11.10, 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: 158, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 1 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 7 
 
PERF_ESTIMATED (280) 
    Primary pointer page: 1504218, Index root page: 1504219 
    Total formats: 1, used formats: 1 
    Average record length: 39.22, total records: 78221 
    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.22 
    Pointer pages: 1, data page slots: 760 
    Data pages: 760, average fill: 71% 
    Primary pages: 760, secondary pages: 0, swept pages: 0 
    Empty pages: 4, full pages: 755 
    Fill distribution: 
     0 - 19% = 5 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 755 
    80 - 99% = 0 
 
    Index PK_PERF_ESTIMATED (0) 
    Root page: 35500, depth: 2, leaf buckets: 100, nodes: 78221 
    Average node length: 10.18, total dup: 0, max dup: 0 
    Average key length: 8.19, compression ratio: 1.10 
    Average prefix length: 3.81, average data length: 5.19 
    Clustering factor: 3150, ratio: 0.04 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 1 
        40 - 59% = 1 
        60 - 79% = 0 
        80 - 99% = 98 
 
PERF_ISQL_STAT (156) 
    Primary pointer page: 508, Index root page: 509 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index PERF_ISQL_STAT_TRN (0) 
    Root page: 1504239, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
PERF_LOG (159) 
    Primary pointer page: 514, Index root page: 515 
    Total formats: 1, used formats: 1 
    Average record length: 111.12, total records: 72 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1691.00, compression ratio: 15.22 
    Pointer pages: 1, data page slots: 2 
    Data pages: 2, average fill: 57% 
    Primary pages: 2, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 1 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 1 
    40 - 59% = 0 
    60 - 79% = 1 
    80 - 99% = 0 
 
PERF_SPLIT_0 (281) 
    Primary pointer page: 573, Index root page: 574 
    Total formats: 1, used formats: 1 
    Average record length: 147.35, total records: 178187 
    Average version length: 152.59, total versions: 4599, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.51 
    Pointer pages: 7, data page slots: 6128 
    Data pages: 4376, average fill: 84% 
    Primary pages: 4375, secondary pages: 1, swept pages: 3 
    Empty pages: 116, full pages: 4187 
    Fill distribution: 
     0 - 19% = 127 
    20 - 39% = 7 
    40 - 59% = 26 
    60 - 79% = 31 
    80 - 99% = 4185 
 
PERF_SPLIT_1 (282) 
    Primary pointer page: 576, Index root page: 577 
    Total formats: 1, used formats: 1 
    Average record length: 150.04, total records: 160246 
    Average version length: 144.91, total versions: 1031, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.30 
    Pointer pages: 6, data page slots: 4128 
    Data pages: 3832, average fill: 86% 
    Primary pages: 3832, secondary pages: 0, swept pages: 2 
    Empty pages: 33, full pages: 3791 
    Fill distribution: 
     0 - 19% = 33 
    20 - 39% = 5 
    40 - 59% = 2 
    60 - 79% = 1 
    80 - 99% = 3791 
 
PERF_SPLIT_2 (283) 
    Primary pointer page: 578, Index root page: 579 
    Total formats: 1, used formats: 1 
    Average record length: 148.99, total records: 173624 
    Average version length: 151.67, total versions: 2480, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.38 
    Pointer pages: 6, data page slots: 5632 
    Data pages: 4216, average fill: 85% 
    Primary pages: 4216, secondary pages: 0, swept pages: 1 
    Empty pages: 85, full pages: 4108 
    Fill distribution: 
     0 - 19% = 92 
    20 - 39% = 8 
    40 - 59% = 3 
    60 - 79% = 4 
    80 - 99% = 4109 
 
PERF_SPLIT_3 (284) 
    Primary pointer page: 580, Index root page: 581 
    Total formats: 1, used formats: 1 
    Average record length: 143.09, total records: 170912 
    Average version length: 153.68, total versions: 8608, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.85 
    Pointer pages: 7, data page slots: 5920 
    Data pages: 4144, average fill: 85% 
    Primary pages: 4144, secondary pages: 0, swept pages: 2 
    Empty pages: 88, full pages: 4034 
    Fill distribution: 
     0 - 19% = 90 
    20 - 39% = 8 
    40 - 59% = 7 
    60 - 79% = 5 
    80 - 99% = 4034 
 
PERF_SPLIT_4 (285) 
    Primary pointer page: 582, Index root page: 583 
    Total formats: 1, used formats: 1 
    Average record length: 140.41, total records: 162796 
    Average version length: 154.23, total versions: 11401, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 12.08 
    Pointer pages: 7, data page slots: 7752 
    Data pages: 3960, average fill: 85% 
    Primary pages: 3960, secondary pages: 0, swept pages: 1 
    Empty pages: 80, full pages: 3851 
    Fill distribution: 
     0 - 19% = 88 
    20 - 39% = 9 
    40 - 59% = 6 
    60 - 79% = 8 
    80 - 99% = 3849 
 
PERF_SPLIT_5 (286) 
    Primary pointer page: 584, Index root page: 585 
    Total formats: 1, used formats: 1 
    Average record length: 131.31, total records: 173399 
    Average version length: 154.69, total versions: 22382, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 12.92 
    Pointer pages: 7, data page slots: 7456 
    Data pages: 4312, average fill: 84% 
    Primary pages: 4312, secondary pages: 0, swept pages: 1 
    Empty pages: 165, full pages: 4088 
    Fill distribution: 
     0 - 19% = 173 
    20 - 39% = 16 
    40 - 59% = 20 
    60 - 79% = 15 
    80 - 99% = 4088 
 
PERF_SPLIT_6 (287) 
    Primary pointer page: 586, Index root page: 587 
    Total formats: 1, used formats: 1 
    Average record length: 132.25, total records: 179482 
    Average version length: 154.81, total versions: 22168, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 12.82 
    Pointer pages: 7, data page slots: 5488 
    Data pages: 4384, average fill: 85% 
    Primary pages: 4384, secondary pages: 0, swept pages: 1 
    Empty pages: 104, full pages: 4243 
    Fill distribution: 
     0 - 19% = 108 
    20 - 39% = 14 
    40 - 59% = 8 
    60 - 79% = 10 
    80 - 99% = 4244 
 
PERF_SPLIT_7 (288) 
    Primary pointer page: 588, Index root page: 589 
    Total formats: 1, used formats: 1 
    Average record length: 143.92, total records: 179962 
    Average version length: 153.28, total versions: 8334, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.78 
    Pointer pages: 7, data page slots: 6296 
    Data pages: 4352, average fill: 85% 
    Primary pages: 4352, secondary pages: 0, swept pages: 4 
    Empty pages: 73, full pages: 4251 
    Fill distribution: 
     0 - 19% = 77 
    20 - 39% = 10 
    40 - 59% = 9 
    60 - 79% = 6 
    80 - 99% = 4250 
 
PERF_SPLIT_8 (289) 
    Primary pointer page: 590, Index root page: 591 
    Total formats: 1, used formats: 1 
    Average record length: 148.19, total records: 158910 
    Average version length: 149.95, total versions: 2712, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.44 
    Pointer pages: 6, data page slots: 4568 
    Data pages: 3824, average fill: 85% 
    Primary pages: 3824, secondary pages: 0, swept pages: 1 
    Empty pages: 53, full pages: 3748 
    Fill distribution: 
     0 - 19% = 57 
    20 - 39% = 7 
    40 - 59% = 7 
    60 - 79% = 4 
    80 - 99% = 3749 
 
PERF_SPLIT_9 (290) 
    Primary pointer page: 593, Index root page: 594 
    Total formats: 1, used formats: 1 
    Average record length: 125.93, total records: 199845 
    Average version length: 153.98, total versions: 33247, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 13.47 
    Pointer pages: 7, data page slots: 6496 
    Data pages: 4848, average fill: 86% 
    Primary pages: 4848, secondary pages: 0, swept pages: 2 
    Empty pages: 85, full pages: 4736 
    Fill distribution: 
     0 - 19% = 89 
    20 - 39% = 5 
    40 - 59% = 9 
    60 - 79% = 9 
    80 - 99% = 4736 
 
PHRASES (143) 
    Primary pointer page: 482, Index root page: 483 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index PHRASES_ID_DESC (3) 
    Root page: 1510354, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PHRASES_NAME (2) 
    Root page: 1510353, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PHRASES_UNQ (1) 
    Root page: 1510352, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PK_PHRASES (0) 
    Root page: 1510351, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
PSTORNED (147) 
    Primary pointer page: 490, Index root page: 491 
    Total formats: 1, used formats: 1 
    Average record length: 51.15, total records: 2111043 
    Average version length: 52.95, total versions: 63771, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 70.00, compression ratio: 1.37 
    Pointer pages: 16, data page slots: 25632 
    Data pages: 25624, average fill: 71% 
    Primary pages: 25624, secondary pages: 0, swept pages: 9728 
    Empty pages: 303, full pages: 21195 
    Fill distribution: 
     0 - 19% = 602 
    20 - 39% = 432 
    40 - 59% = 1076 
    60 - 79% = 22944 
    80 - 99% = 570 
 
    Index PSTORNED_RCV_ID (1) 
    Root page: 1506186, depth: 3, leaf buckets: 2592, nodes: 2111043 
    Average node length: 5.44, total dup: 1970379, max dup: 1416 
    Average key length: 2.49, compression ratio: 3.62 
    Average prefix length: 8.58, average data length: 0.42 
    Clustering factor: 182214, ratio: 0.09 
    Fill distribution: 
         0 - 19% = 6 
        20 - 39% = 275 
        40 - 59% = 1725 
        60 - 79% = 282 
        80 - 99% = 304 
 
    Index PSTORNED_SND_ID (0) 
    Root page: 1504819, depth: 3, leaf buckets: 2750, nodes: 2111043 
    Average node length: 5.69, total dup: 1895297, max dup: 64 
    Average key length: 2.74, compression ratio: 3.29 
    Average prefix length: 8.37, average data length: 0.63 
    Clustering factor: 376918, ratio: 0.18 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 3 
        40 - 59% = 2409 
        60 - 79% = 305 
        80 - 99% = 33 
 
    Index PSTORNED_WORKER_ID (2) 
    Root page: 1507996, depth: 3, leaf buckets: 2165, nodes: 2111043 
    Average node length: 4.96, total dup: 2110943, max dup: 27921 
    Average key length: 2.00, compression ratio: 1.20 
    Average prefix length: 2.41, average data length: 0.00 
    Clustering factor: 179481, ratio: 0.09 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 189 
        40 - 59% = 1198 
        60 - 79% = 382 
        80 - 99% = 395 
 
RULES_FOR_PDISTR (148) 
    Primary pointer page: 492, Index root page: 493 
    Total formats: 1, used formats: 1 
    Average record length: 17.00, total records: 4 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 334.00, compression ratio: 19.65 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 2% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index RULES_FOR_PDISTR_UNQ (0) 
    Root page: 1504317, depth: 1, leaf buckets: 1, nodes: 4 
    Average node length: 11.50, total dup: 0, max dup: 0 
    Average key length: 10.25, compression ratio: 0.88 
    Average prefix length: 1.50, average data length: 7.50 
    Clustering factor: 1, ratio: 0.25 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
RULES_FOR_QDISTR (137) 
    Primary pointer page: 470, Index root page: 471 
    Total formats: 1, used formats: 1 
    Average record length: 32.71, total records: 7 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 332.00, compression ratio: 10.15 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 4% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index RULES_FOR_QDISTR_RCVOP (1) 
    Root page: 1544803, depth: 1, leaf buckets: 1, nodes: 7 
    Average node length: 5.29, total dup: 2, max dup: 2 
    Average key length: 4.14, compression ratio: 0.72 
    Average prefix length: 1.43, average data length: 1.57 
    Clustering factor: 1, ratio: 0.14 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index RULES_FOR_QDISTR_UNQ (0) 
    Root page: 1544802, depth: 1, leaf buckets: 1, nodes: 7 
    Average node length: 10.14, total dup: 0, max dup: 0 
    Average key length: 8.86, compression ratio: 0.94 
    Average prefix length: 2.14, average data length: 6.14 
    Clustering factor: 1, ratio: 0.14 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
SEMAPHORES (152) 
    Primary pointer page: 500, Index root page: 501 
    Total formats: 1, used formats: 1 
    Average record length: 43.40, total records: 5 
    Average version length: 9.00, total versions: 1, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 346.00, compression ratio: 7.97 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 4% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index PK_SEMAPHORES (0) 
    Root page: 1504305, depth: 1, leaf buckets: 1, nodes: 5 
    Average node length: 12.40, total dup: 0, max dup: 0 
    Average key length: 11.00, compression ratio: 0.82 
    Average prefix length: 0.60, average data length: 8.40 
    Clustering factor: 1, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index SEMAPHORES_TASK_UNQ (1) 
    Root page: 1504306, depth: 1, leaf buckets: 1, nodes: 5 
    Average node length: 23.40, total dup: 0, max dup: 0 
    Average key length: 22.00, compression ratio: 1.07 
    Average prefix length: 4.20, average data length: 19.40 
    Clustering factor: 1, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
SETTINGS (135) 
    Primary pointer page: 466, Index root page: 467 
    Total formats: 1, used formats: 1 
    Average record length: 97.63, total records: 149 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1347.00, compression ratio: 13.80 
    Pointer pages: 1, data page slots: 3 
    Data pages: 3, average fill: 70% 
    Primary pages: 3, secondary pages: 0, swept pages: 2 
    Empty pages: 0, full pages: 2 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 1 
    60 - 79% = 0 
    80 - 99% = 2 
 
    Index SETTINGS_MCODE_WM_UNQ (1) 
    Root page: 525, depth: 1, leaf buckets: 1, nodes: 149 
    Average node length: 14.66, total dup: 0, max dup: 0 
    Average key length: 13.55, compression ratio: 2.19 
    Average prefix length: 19.07, average data length: 10.66 
    Clustering factor: 48, ratio: 0.32 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 1 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index SETTINGS_MODE_CODE (0) 
    Root page: 1544806, depth: 1, leaf buckets: 1, nodes: 149 
    Average node length: 25.56, total dup: 0, max dup: 0 
    Average key length: 24.56, compression ratio: 1.63 
    Average prefix length: 18.58, average data length: 21.56 
    Clustering factor: 14, ratio: 0.09 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 0 
        40 - 59% = 1 
        60 - 79% = 0 
        80 - 99% = 0 
 
TMP$DEP_DOCS (129) 
    Primary pointer page: 454, Index root page: 455 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index TMP_DEP_DOCS_UNQ (0) 
    Root page: 1544810, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
TMP$IDX_RECALC (132) 
    Primary pointer page: 460, Index root page: 461 
    Total formats: 2, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index TMP_IDX_RECALC_IDX_NAME_UNQ (0) 
    Root page: 1544807, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
TMP$MON_LOG (133) 
    Primary pointer page: 462, Index root page: 463 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
TMP$MON_LOG_TABLE_STATS (134) 
    Primary pointer page: 464, Index root page: 465 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
TMP$PERF_EST_WHOLE (161) 
    Primary pointer page: 518, Index root page: 519 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
TMP$PERF_LOG (160) 
    Primary pointer page: 516, Index root page: 517 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index TMP$PERF_LOG_UNIT_TRN_DTS_END (0) 
    Root page: 1504230, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
TMP$PERF_MON (131) 
    Primary pointer page: 458, Index root page: 459 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
TMP$RESULT_SET (130) 
    Primary pointer page: 456, Index root page: 457 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index TMP_RESULT_SET_DOC (1) 
    Root page: 1544809, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index TMP_RESULT_SET_WARE_DOC (0) 
    Root page: 1544808, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
TMP$SHOPPING_CART (128) 
    Primary pointer page: 452, Index root page: 453 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index TMP_SHOPCART_UNQ (0) 
    Root page: 1544811, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
TPAUSE (166) 
    Primary pointer page: 528, Index root page: 529 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index RDB$PRIMARY2 (0) 
    Root page: 1504214, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
TRACE_STAT (157) 
    Primary pointer page: 510, Index root page: 511 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
WARES (142) 
    Primary pointer page: 480, Index root page: 481 
    Total formats: 1, used formats: 1 
    Average record length: 77.52, total records: 400 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 444.00, compression ratio: 5.73 
    Pointer pages: 1, data page slots: 6 
    Data pages: 6, average fill: 77% 
    Primary pages: 6, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 5 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 5 
    80 - 99% = 1 
 
    Index FK_WARES_WARE_GROUPS (3) 
    Root page: 1552159, depth: 1, leaf buckets: 1, nodes: 400 
    Average node length: 3.17, total dup: 392, max dup: 60 
    Average key length: 2.16, compression ratio: 4.16 
    Average prefix length: 8.86, average data length: 0.14 
    Clustering factor: 48, ratio: 0.12 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PK_WARES (0) 
    Root page: 1510355, depth: 1, leaf buckets: 1, nodes: 400 
    Average node length: 11.22, total dup: 0, max dup: 0 
    Average key length: 10.22, compression ratio: 0.88 
    Average prefix length: 1.78, average data length: 7.22 
    Clustering factor: 344, ratio: 0.86 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 0 
        40 - 59% = 1 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index WARES_ID_DESC (2) 
    Root page: 1510360, depth: 1, leaf buckets: 1, nodes: 400 
    Average node length: 11.22, total dup: 0, max dup: 0 
    Average key length: 10.22, compression ratio: 0.88 
    Average prefix length: 1.78, average data length: 7.22 
    Clustering factor: 344, ratio: 0.86 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 0 
        40 - 59% = 1 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index WARES_NUMB_UNQ (1) 
    Root page: 1510358, depth: 2, leaf buckets: 3, nodes: 400 
    Average node length: 53.25, total dup: 0, max dup: 0 
    Average key length: 52.23, compression ratio: 1.00 
    Average prefix length: 2.74, average data length: 49.25 
    Clustering factor: 355, ratio: 0.89 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 1 
        80 - 99% = 2 
 
WARE_GROUPS (151) 
    Primary pointer page: 498, Index root page: 499 
    Total formats: 1, used formats: 1 
    Average record length: 32.12, total records: 8 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 346.00, compression ratio: 10.77 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 5% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index PK_WARE_GROUPS (0) 
    Root page: 1504307, depth: 1, leaf buckets: 1, nodes: 8 
    Average node length: 11.25, total dup: 0, max dup: 0 
    Average key length: 10.12, compression ratio: 0.89 
    Average prefix length: 1.75, average data length: 7.25 
    Clustering factor: 1, ratio: 0.12 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index WARE_GROUPS_NAME_UNQ (1) 
    Root page: 1504308, depth: 1, leaf buckets: 1, nodes: 8 
    Average node length: 19.88, total dup: 0, max dup: 0 
    Average key length: 18.12, compression ratio: 0.89 
    Average prefix length: 0.25, average data length: 15.88 
    Clustering factor: 1, ratio: 0.12 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
XQD_1000_1200 (176) 
    Primary pointer page: 549, Index root page: 550 
    Total formats: 1, used formats: 1 
    Average record length: 36.87, total records: 139530 
    Average version length: 69.18, total versions: 65208, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 3.42 
    Pointer pages: 3, data page slots: 4272 
    Data pages: 3144, average fill: 52% 
    Primary pages: 3144, secondary pages: 0, swept pages: 524 
    Empty pages: 689, full pages: 1825 
    Fill distribution: 
     0 - 19% = 1097 
    20 - 39% = 154 
    40 - 59% = 53 
    60 - 79% = 538 
    80 - 99% = 1302 
 
    Index XQD_1000_1200_WA_SO_RO_WKR_SND (0) 
    Root page: 100194, depth: 3, leaf buckets: 198, nodes: 139530 
    Average node length: 6.39, total dup: 121574, max dup: 14 
    Average key length: 3.95, compression ratio: 10.64 
    Average prefix length: 40.18, average data length: 1.82 
    Clustering factor: 23160, ratio: 0.17 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 21 
        40 - 59% = 98 
        60 - 79% = 61 
        80 - 99% = 17 
 
XQD_1000_3300 (178) 
    Primary pointer page: 553, Index root page: 554 
    Total formats: 1, used formats: 1 
    Average record length: 63.99, total records: 7546270 
    Average version length: 68.79, total versions: 544196, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.97 
    Pointer pages: 66, data page slots: 106608 
    Data pages: 106608, average fill: 76% 
    Primary pages: 106608, secondary pages: 0, swept pages: 17634 
    Empty pages: 59, full pages: 95355 
    Fill distribution: 
     0 - 19% = 330 
    20 - 39% = 1136 
    40 - 59% = 3904 
    60 - 79% = 89012 
    80 - 99% = 12226 
 
    Index XQD_1000_3300_WA_SO_RO_WKR_SND (0) 
    Root page: 1480454, depth: 3, leaf buckets: 10867, nodes: 7546270 
    Average node length: 6.51, total dup: 6526770, max dup: 29 
    Average key length: 3.52, compression ratio: 11.94 
    Average prefix length: 40.62, average data length: 1.38 
    Clustering factor: 1666689, ratio: 0.22 
    Fill distribution: 
         0 - 19% = 14 
        20 - 39% = 1199 
        40 - 59% = 5507 
        60 - 79% = 3493 
        80 - 99% = 654 
 
    Index XQD_1000_3300_WKR_DOC_ASC (1) 
    Root page: 1486068, depth: 3, leaf buckets: 8657, nodes: 7546270 
    Average node length: 5.39, total dup: 7254287, max dup: 167 
    Average key length: 2.39, compression ratio: 7.10 
    Average prefix length: 16.64, average data length: 0.36 
    Clustering factor: 1447300, ratio: 0.19 
    Fill distribution: 
         0 - 19% = 4 
        20 - 39% = 766 
        40 - 59% = 4772 
        60 - 79% = 1817 
        80 - 99% = 1298 
 
    Index XQD_1000_3300_WKR_DOC_DEC (2) 
    Root page: 1490608, depth: 3, leaf buckets: 8729, nodes: 7546270 
    Average node length: 5.39, total dup: 7254287, max dup: 167 
    Average key length: 2.39, compression ratio: 7.10 
    Average prefix length: 16.64, average data length: 0.36 
    Clustering factor: 1449668, ratio: 0.19 
    Fill distribution: 
         0 - 19% = 8 
        20 - 39% = 832 
        40 - 59% = 4807 
        60 - 79% = 1762 
        80 - 99% = 1320 
 
XQD_1200_2000 (177) 
    Primary pointer page: 551, Index root page: 552 
    Total formats: 1, used formats: 1 
    Average record length: 66.73, total records: 12522015 
    Average version length: 68.73, total versions: 403360, 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: 106, data page slots: 172240 
    Data pages: 172240, average fill: 77% 
    Primary pages: 172240, secondary pages: 0, swept pages: 66489 
    Empty pages: 3, full pages: 168756 
    Fill distribution: 
     0 - 19% = 50 
    20 - 39% = 310 
    40 - 59% = 1120 
    60 - 79% = 161148 
    80 - 99% = 9612 
 
    Index XQD_1200_2000_WA_SO_RO_WKR_SND (0) 
    Root page: 1495028, depth: 3, leaf buckets: 18506, nodes: 12522015 
    Average node length: 6.61, total dup: 10908592, max dup: 59 
    Average key length: 3.43, compression ratio: 12.24 
    Average prefix length: 40.70, average data length: 1.30 
    Clustering factor: 2438265, ratio: 0.19 
    Fill distribution: 
         0 - 19% = 27 
        20 - 39% = 1739 
        40 - 59% = 10387 
        60 - 79% = 5343 
        80 - 99% = 1010 
 
XQD_2000_3300 (179) 
    Primary pointer page: 555, Index root page: 556 
    Total formats: 1, used formats: 1 
    Average record length: 35.53, total records: 1834893 
    Average version length: 69.11, total versions: 892337, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 3.55 
    Pointer pages: 26, data page slots: 41248 
    Data pages: 28536, average fill: 75% 
    Primary pages: 28535, secondary pages: 1, swept pages: 3585 
    Empty pages: 1332, full pages: 23335 
    Fill distribution: 
     0 - 19% = 2365 
    20 - 39% = 1061 
    40 - 59% = 1020 
    60 - 79% = 9466 
    80 - 99% = 14624 
 
    Index XQD_2000_3300_WA_SO_RO_WKR_SND (0) 
    Root page: 1479712, depth: 3, leaf buckets: 2181, nodes: 1834893 
    Average node length: 5.51, total dup: 1761238, max dup: 97 
    Average key length: 2.55, compression ratio: 16.49 
    Average prefix length: 41.49, average data length: 0.51 
    Clustering factor: 123144, ratio: 0.07 
    Fill distribution: 
         0 - 19% = 7 
        20 - 39% = 249 
        40 - 59% = 1038 
        60 - 79% = 629 
        80 - 99% = 258 
 
XQD_2100_3300 (180) 
    Primary pointer page: 557, Index root page: 558 
    Total formats: 1, used formats: 1 
    Average record length: 34.47, total records: 1252711 
    Average version length: 69.13, total versions: 627314, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 3.66 
    Pointer pages: 22, data page slots: 34736 
    Data pages: 30712, average fill: 48% 
    Primary pages: 30711, secondary pages: 1, swept pages: 7369 
    Empty pages: 6688, full pages: 15541 
    Fill distribution: 
     0 - 19% = 11846 
    20 - 39% = 2123 
    40 - 59% = 657 
    60 - 79% = 4778 
    80 - 99% = 11308 
 
    Index XQD_2100_3300_WA_SO_RO_WKR_SND (0) 
    Root page: 1479207, depth: 3, leaf buckets: 1604, nodes: 1252711 
    Average node length: 5.80, total dup: 1168809, max dup: 99 
    Average key length: 2.86, compression ratio: 14.70 
    Average prefix length: 41.21, average data length: 0.79 
    Clustering factor: 172316, ratio: 0.14 
    Fill distribution: 
         0 - 19% = 6 
        20 - 39% = 204 
        40 - 59% = 755 
        60 - 79% = 489 
        80 - 99% = 150 
 
XQD_3300_3400 (181) 
    Primary pointer page: 559, Index root page: 560 
    Total formats: 1, used formats: 1 
    Average record length: 63.42, total records: 9180098 
    Average version length: 68.96, total versions: 730359, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.99 
    Pointer pages: 88, data page slots: 142808 
    Data pages: 142800, average fill: 69% 
    Primary pages: 142800, secondary pages: 0, swept pages: 37510 
    Empty pages: 524, full pages: 89423 
    Fill distribution: 
     0 - 19% = 1528 
    20 - 39% = 7415 
    40 - 59% = 23313 
    60 - 79% = 95916 
    80 - 99% = 14628 
 
    Index XQD_3300_3400_WA_SO_RO_WKR_SND (0) 
    Root page: 1472590, depth: 3, leaf buckets: 13467, nodes: 9180098 
    Average node length: 6.68, total dup: 7615976, max dup: 15 
    Average key length: 3.67, compression ratio: 11.46 
    Average prefix length: 40.50, average data length: 1.50 
    Clustering factor: 1946073, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 1354 
        40 - 59% = 6905 
        60 - 79% = 4494 
        80 - 99% = 712 
 
XQS_1000_1200 (182) 
    Primary pointer page: 561, Index root page: 562 
    Total formats: 1, used formats: 1 
    Average record length: 82.47, total records: 21146660 
    Average version length: 82.94, total versions: 17795, 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: 318664 
    Data pages: 318664, average fill: 81% 
    Primary pages: 318664, secondary pages: 0, swept pages: 11814 
    Empty pages: 24, full pages: 318102 
    Fill distribution: 
     0 - 19% = 37 
    20 - 39% = 24 
    40 - 59% = 85 
    60 - 79% = 27145 
    80 - 99% = 291373 
 
    Index XQS_1000_1200_DOC_ID (1) 
    Root page: 1426716, depth: 3, leaf buckets: 19643, nodes: 21146660 
    Average node length: 5.72, total dup: 20665896, max dup: 152 
    Average key length: 2.16, compression ratio: 4.16 
    Average prefix length: 8.86, average data length: 0.14 
    Clustering factor: 3279853, ratio: 0.16 
    Fill distribution: 
         0 - 19% = 4 
        20 - 39% = 0 
        40 - 59% = 8685 
        60 - 79% = 546 
        80 - 99% = 10408 
 
    Index XQS_1000_1200_RCV_ID (3) 
    Root page: 1456980, depth: 3, leaf buckets: 17162, nodes: 21146660 
    Average node length: 6.31, total dup: 18583050, max dup: 49 
    Average key length: 2.75, compression ratio: 3.27 
    Average prefix length: 8.37, average data length: 0.63 
    Clustering factor: 914057, ratio: 0.04 
    Fill distribution: 
         0 - 19% = 6 
        20 - 39% = 3 
        40 - 59% = 750 
        60 - 79% = 301 
        80 - 99% = 16102 
 
    Index XQS_1000_1200_SND_ID (2) 
    Root page: 1441073, depth: 3, leaf buckets: 21425, nodes: 21146660 
    Average node length: 6.35, total dup: 18502976, max dup: 29 
    Average key length: 2.79, compression ratio: 3.23 
    Average prefix length: 8.34, average data length: 0.66 
    Clustering factor: 3574488, ratio: 0.17 
    Fill distribution: 
         0 - 19% = 6 
        20 - 39% = 3 
        40 - 59% = 8957 
        60 - 79% = 598 
        80 - 99% = 11861 
 
    Index XQS_1000_1200_WORKER_ID (0) 
    Root page: 1413348, depth: 3, leaf buckets: 16110, nodes: 21146660 
    Average node length: 5.56, total dup: 21146560, max dup: 231528 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.42, average data length: 0.00 
    Clustering factor: 942788, ratio: 0.04 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 13 
        40 - 59% = 2893 
        60 - 79% = 419 
        80 - 99% = 12784 
 
XQS_1000_3300 (184) 
    Primary pointer page: 565, Index root page: 566 
    Total formats: 1, used formats: 1 
    Average record length: 76.38, total records: 9609153 
    Average version length: 82.60, total versions: 703150, 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: 103, data page slots: 166728 
    Data pages: 166704, average fill: 71% 
    Primary pages: 166704, secondary pages: 0, swept pages: 52421 
    Empty pages: 463, full pages: 105408 
    Fill distribution: 
     0 - 19% = 1512 
    20 - 39% = 6801 
    40 - 59% = 24061 
    60 - 79% = 60993 
    80 - 99% = 73337 
 
    Index XQS_1000_3300_DOC_ID (1) 
    Root page: 1367502, depth: 3, leaf buckets: 11313, nodes: 9609153 
    Average node length: 5.35, total dup: 9301421, max dup: 265 
    Average key length: 2.23, compression ratio: 4.03 
    Average prefix length: 8.80, average data length: 0.20 
    Clustering factor: 2086783, ratio: 0.22 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 91 
        40 - 59% = 8366 
        60 - 79% = 2808 
        80 - 99% = 46 
 
    Index XQS_1000_3300_RCV_ID (3) 
    Root page: 1379261, depth: 3, leaf buckets: 13443, nodes: 9609153 
    Average node length: 6.21, total dup: 7966870, max dup: 14 
    Average key length: 3.10, compression ratio: 2.90 
    Average prefix length: 8.07, average data length: 0.93 
    Clustering factor: 1440502, ratio: 0.15 
    Fill distribution: 
         0 - 19% = 141 
        20 - 39% = 3911 
        40 - 59% = 4470 
        60 - 79% = 2611 
        80 - 99% = 2310 
 
    Index XQS_1000_3300_SND_ID (2) 
    Root page: 1373059, depth: 3, leaf buckets: 12635, nodes: 9609153 
    Average node length: 5.96, total dup: 8340941, max dup: 44 
    Average key length: 2.85, compression ratio: 3.16 
    Average prefix length: 8.28, average data length: 0.72 
    Clustering factor: 2285815, ratio: 0.24 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 112 
        40 - 59% = 9347 
        60 - 79% = 3121 
        80 - 99% = 53 
 
    Index XQS_1000_3300_WORKER_ID (0) 
    Root page: 1362767, depth: 3, leaf buckets: 10056, nodes: 9609153 
    Average node length: 5.12, total dup: 9609053, max dup: 142485 
    Average key length: 2.00, compression ratio: 1.20 
    Average prefix length: 2.41, average data length: 0.00 
    Clustering factor: 1472738, ratio: 0.15 
    Fill distribution: 
         0 - 19% = 49 
        20 - 39% = 1338 
        40 - 59% = 4909 
        60 - 79% = 1697 
        80 - 99% = 2063 
 
XQS_1200_2000 (183) 
    Primary pointer page: 563, Index root page: 564 
    Total formats: 1, used formats: 1 
    Average record length: 78.43, total records: 11106446 
    Average version length: 82.49, total versions: 520609, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.61 
    Pointer pages: 117, data page slots: 190088 
    Data pages: 188408, average fill: 73% 
    Primary pages: 188408, secondary pages: 0, swept pages: 65408 
    Empty pages: 3458, full pages: 139645 
    Fill distribution: 
     0 - 19% = 5904 
    20 - 39% = 7774 
    40 - 59% = 17539 
    60 - 79% = 41712 
    80 - 99% = 115479 
 
    Index XQS_1200_2000_DOC_ID (1) 
    Root page: 1392101, depth: 3, leaf buckets: 13103, nodes: 11106446 
    Average node length: 5.29, total dup: 10996974, max dup: 631 
    Average key length: 2.08, compression ratio: 4.32 
    Average prefix length: 8.93, average data length: 0.07 
    Clustering factor: 2312478, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 146 
        40 - 59% = 9746 
        60 - 79% = 3135 
        80 - 99% = 76 
 
    Index XQS_1200_2000_RCV_ID (3) 
    Root page: 1406110, depth: 3, leaf buckets: 10268, nodes: 11106446 
    Average node length: 5.49, total dup: 10621774, max dup: 49 
    Average key length: 2.28, compression ratio: 3.95 
    Average prefix length: 8.77, average data length: 0.23 
    Clustering factor: 696994, ratio: 0.06 
    Fill distribution: 
         0 - 19% = 143 
        20 - 39% = 885 
        40 - 59% = 2522 
        60 - 79% = 1798 
        80 - 99% = 4920 
 
    Index XQS_1200_2000_SND_ID (2) 
    Root page: 1398638, depth: 3, leaf buckets: 14993, nodes: 11106446 
    Average node length: 6.02, total dup: 9687767, max dup: 78 
    Average key length: 2.81, compression ratio: 3.21 
    Average prefix length: 8.32, average data length: 0.68 
    Clustering factor: 2328968, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 162 
        40 - 59% = 11283 
        60 - 79% = 3460 
        80 - 99% = 86 
 
    Index XQS_1200_2000_WORKER_ID (0) 
    Root page: 1386211, depth: 3, leaf buckets: 10570, nodes: 11106446 
    Average node length: 5.21, total dup: 11106346, max dup: 184345 
    Average key length: 2.00, compression ratio: 1.20 
    Average prefix length: 2.41, average data length: 0.00 
    Clustering factor: 686061, ratio: 0.06 
    Fill distribution: 
         0 - 19% = 104 
        20 - 39% = 850 
        40 - 59% = 4652 
        60 - 79% = 1473 
        80 - 99% = 3491 
 
XQS_2000_3300 (185) 
    Primary pointer page: 567, Index root page: 568 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index XQS_2000_3300_DOC_ID (1) 
    Root page: 1361753, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index XQS_2000_3300_RCV_ID (3) 
    Root page: 1361755, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index XQS_2000_3300_SND_ID (2) 
    Root page: 1361754, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index XQS_2000_3300_WORKER_ID (0) 
    Root page: 1361752, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
XQS_2100_3300 (186) 
    Primary pointer page: 569, Index root page: 570 
    Total formats: 1, used formats: 1 
    Average record length: 76.69, total records: 9728706 
    Average version length: 82.91, total versions: 710822, 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: 106, data page slots: 171752 
    Data pages: 171712, average fill: 71% 
    Primary pages: 171712, secondary pages: 0, swept pages: 56624 
    Empty pages: 453, full pages: 101123 
    Fill distribution: 
     0 - 19% = 1557 
    20 - 39% = 7838 
    40 - 59% = 27185 
    60 - 79% = 66462 
    80 - 99% = 68670 
 
    Index XQS_2100_3300_DOC_ID (1) 
    Root page: 1344686, depth: 3, leaf buckets: 11665, nodes: 9728706 
    Average node length: 5.17, total dup: 9700095, max dup: 2469 
    Average key length: 2.03, compression ratio: 4.43 
    Average prefix length: 8.97, average data length: 0.03 
    Clustering factor: 1916344, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 26 
        20 - 39% = 1457 
        40 - 59% = 7680 
        60 - 79% = 1874 
        80 - 99% = 628 
 
    Index XQS_2100_3300_RCV_ID (3) 
    Root page: 1355717, depth: 3, leaf buckets: 13576, nodes: 9728706 
    Average node length: 6.24, total dup: 8065570, max dup: 14 
    Average key length: 3.10, compression ratio: 2.90 
    Average prefix length: 8.07, average data length: 0.93 
    Clustering factor: 1405278, ratio: 0.14 
    Fill distribution: 
         0 - 19% = 175 
        20 - 39% = 3897 
        40 - 59% = 4405 
        60 - 79% = 2649 
        80 - 99% = 2450 
 
    Index XQS_2100_3300_SND_ID (2) 
    Root page: 1350049, depth: 3, leaf buckets: 12306, nodes: 9728706 
    Average node length: 5.42, total dup: 9295983, max dup: 99 
    Average key length: 2.29, compression ratio: 3.94 
    Average prefix length: 8.76, average data length: 0.24 
    Clustering factor: 2049117, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 32 
        20 - 39% = 1397 
        40 - 59% = 8617 
        60 - 79% = 1664 
        80 - 99% = 596 
 
    Index XQS_2100_3300_WORKER_ID (0) 
    Root page: 985805, depth: 3, leaf buckets: 10274, nodes: 9728706 
    Average node length: 5.14, total dup: 9728606, max dup: 144265 
    Average key length: 2.00, compression ratio: 1.20 
    Average prefix length: 2.40, average data length: 0.00 
    Clustering factor: 1492813, ratio: 0.15 
    Fill distribution: 
         0 - 19% = 55 
        20 - 39% = 1360 
        40 - 59% = 5115 
        60 - 79% = 1699 
        80 - 99% = 2045 
 
XQS_3300_3400 (187) 
    Primary pointer page: 571, Index root page: 572 
    Total formats: 1, used formats: 1 
    Average record length: 66.94, total records: 578571 
    Average version length: 68.80, total versions: 10426, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.88 
    Pointer pages: 5, data page slots: 7984 
    Data pages: 7984, average fill: 76% 
    Primary pages: 7984, secondary pages: 0, swept pages: 3260 
    Empty pages: 7, full pages: 7073 
    Fill distribution: 
     0 - 19% = 8 
    20 - 39% = 14 
    40 - 59% = 167 
    60 - 79% = 7608 
    80 - 99% = 187 
 
    Index XQS_3300_3400_DOC_ID (1) 
    Root page: 38319, depth: 3, leaf buckets: 732, nodes: 578571 
    Average node length: 5.95, total dup: 492543, max dup: 82 
    Average key length: 3.09, compression ratio: 2.91 
    Average prefix length: 8.06, average data length: 0.94 
    Clustering factor: 100784, ratio: 0.17 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 20 
        40 - 59% = 522 
        60 - 79% = 97 
        80 - 99% = 93 
 
    Index XQS_3300_3400_SND_ID (2) 
    Root page: 32237, depth: 3, leaf buckets: 756, nodes: 578571 
    Average node length: 6.15, total dup: 474571, max dup: 29 
    Average key length: 3.29, compression ratio: 2.73 
    Average prefix length: 7.89, average data length: 1.11 
    Clustering factor: 100845, ratio: 0.17 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 25 
        40 - 59% = 536 
        60 - 79% = 91 
        80 - 99% = 104 
 
    Index XQS_3300_3400_WORKER_ID (0) 
    Root page: 375548, depth: 2, leaf buckets: 566, nodes: 578571 
    Average node length: 4.86, total dup: 578471, max dup: 9121 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.42, average data length: 0.00 
    Clustering factor: 89414, ratio: 0.15 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 23 
        40 - 59% = 329 
        60 - 79% = 89 
        80 - 99% = 125 
 
ZDOC_DATA (170) 
    Primary pointer page: 537, Index root page: 538 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
ZDOC_LIST (169) 
    Primary pointer page: 535, Index root page: 536 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
ZINVNT_TURNOVER_LOG (171) 
    Primary pointer page: 539, Index root page: 540 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
ZPDISTR (174) 
    Primary pointer page: 545, Index root page: 546 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index ZPDISTR_ID (0) 
    Root page: 1504207, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
ZPSTORNED (175) 
    Primary pointer page: 547, Index root page: 548 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index ZPSTORNED_ID (0) 
    Root page: 1504206, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
ZQDISTR (172) 
    Primary pointer page: 541, Index root page: 542 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index ZQDISTR_ID (0) 
    Root page: 1504212, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index ZQDISTR_WARE_SNDOP_RCVOP (1) 
    Root page: 1504213, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
ZQSTORNED (173) 
    Primary pointer page: 543, Index root page: 544 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index ZQSTORNED_DOC_ID (1) 
    Root page: 1504209, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index ZQSTORNED_ID (0) 
    Root page: 1504208, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index ZQSTORNED_RCV_ID (3) 
    Root page: 1504211, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index ZQSTORNED_SND_ID (2) 
    Root page: 1504210, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
ZTMP_DEP_DOCS (168) 
    Primary pointer page: 533, Index root page: 534 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
ZTMP_SHOPPING_CART (167) 
    Primary pointer page: 531, Index root page: 532 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
Z_USED_VIEWS (144) 
    Primary pointer page: 484, Index root page: 485 
    Total formats: 1, used formats: 1 
    Average record length: 29.38, total records: 29 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 99.00, compression ratio: 3.37 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 16% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index Z_USED_VIEWS_UNQ (0) 
    Root page: 1510350, depth: 1, leaf buckets: 1, nodes: 29 
    Average node length: 15.17, total dup: 0, max dup: 0 
    Average key length: 14.14, compression ratio: 1.44 
    Average prefix length: 9.17, average data length: 11.17 
    Clustering factor: 1, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
Gstat completion time Mon Mar 18 19:11:28 2024

Record versions statistics, table

TABLE_NAME TOTAL_RECS TOTAL_VERS MAX_VERSIONS VERS_TO_RECS_PRC MAXV_TO_VERS_PRC
DOC_DATA 7733790 133438 1 0.0000 0.0000
DOC_LIST 2229037 133909 3 0.0000 0.0000
FB_ERRORS 2182 757 1 0.0000 0.0000
INVNT_SALDO 400 223683 584 55900.0000 0.0000
INVNT_TURNOVER_LOG 138812 112242 1 0.0000 0.0000
MONEY_SALDO 49 16717 948 34100.0000 0.0000
MONEY_TURNOVER_LOG 1824 1742 1 0.0000 0.0000
PDISTR 831967 91546 6 0.0000 0.0000
PERF_SPLIT_0 178187 4599 1 0.0000 0.0000
PERF_SPLIT_1 160246 1031 1 0.0000 0.0000
PERF_SPLIT_2 173624 2480 1 0.0000 0.0000
PERF_SPLIT_3 170912 8608 1 0.0000 0.0000
PERF_SPLIT_4 162796 11401 1 0.0000 0.0000
PERF_SPLIT_5 173399 22382 1 0.0000 0.0000
PERF_SPLIT_6 179482 22168 1 0.0000 0.0000
PERF_SPLIT_7 179962 8334 1 0.0000 0.0000
PERF_SPLIT_8 158910 2712 1 0.0000 0.0000
PERF_SPLIT_9 199845 33247 1 0.0000 0.0000
PSTORNED 2111043 63771 1 0.0000 0.0000
SEMAPHORES 5 1 1 0.0000 100.0000
XQD_1000_1200 139530 65208 1 0.0000 0.0000
XQD_1000_3300 7546270 544196 1 0.0000 0.0000
XQD_1200_2000 12522015 403360 1 0.0000 0.0000
XQD_2000_3300 1834893 892337 1 0.0000 0.0000
XQD_2100_3300 1252711 627314 1 0.0000 0.0000
XQD_3300_3400 9180098 730359 1 0.0000 0.0000
XQS_1000_1200 21146660 17795 1 0.0000 0.0000
XQS_1000_3300 9609153 703150 1 0.0000 0.0000
XQS_1200_2000 11106446 520609 1 0.0000 0.0000
XQS_2100_3300 9728706 710822 1 0.0000 0.0000
XQS_3300_3400 578571 10426 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 ---
:127: 
:128: mscs-test-161.budzdorov.ru    Mon Mar 18 19:09:44 2024
:129:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:130: 
:131: 
:132: mscs-test-161.budzdorov.ru    Mon Mar 18 19:09:46 2024
:133:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:134: 
--- end of diff output ---

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

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