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

Server and database settinfs 


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

Test configuration settings 

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

Test finish info 


FINISH_STATE                    NORMAL: TEST_TIME EXPIRED AT 2024-03-12 13:07:50
DTS_END                         2024-03-12 13:07:50.8410
FB_GDSCODE                      -1
FB_MNEMONA                      
STACK                           SP_ADD_INVOICE_TO_STOCK(190:30) ==> SP_CUSTOMER_RESERVE(47:5) ==> SP_CHECK_TO_STOP_WORK(32:12) ==> SP_HALT_ON_ERROR(68:17)
IP                              ::1/42706
TRN_ID                          176357
ATT_ID                          498
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: 9323.58 22922 932358
customer order: creation 177.89 386 17789
customer order: refuse 15.14 375 1514
order to supplier: creation 48.02 1197 4802
order to supplier: removal 3.53 92666 353
invoice (draft): creation 47.58 3070 4758
invoice (draft): removal 48.82 688 4882
invoice accept: apply 43.88 20984 4388
invoice accept: cancel 44.41 890 4441
customer reserve: creation 4229.15 200 422915
customer reserve: removal 4367.67 60 436767
realization accept: apply 86.34 203 8634
realization accept: cancel 78.02 148 7802
payment from customer: creation 61.79 113 6179
payment from customer: removal 6.09 95 609
payment to supplier: creation 50.44 139 5044
payment to supplier: removal 3.70 64 370
service: total inventory turnovers 3.90 3822 390
service: total monetary turnovers 6.39 576 639
service: aggregate perf. data 0.79 21316 79
service: refresh index statistics 0.03 311450 3

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:03, from 12-03-2024 13:10:05 to 12-03-2024 13:10:08.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 3194
TEST_TIME 2 3053
TEST_TIME 3 3434
TEST_TIME 4 3662
TEST_TIME 5 3415
TEST_TIME 6 3539
TEST_TIME 7 3953
TEST_TIME 8 4661
TEST_TIME 9 5088
TEST_TIME 10 5331
TEST_TIME 11 5399
TEST_TIME 12 5646
TEST_TIME 13 6061
TEST_TIME 14 6224
TEST_TIME 15 6489
TEST_TIME 16 6558
TEST_TIME 17 6954
TEST_TIME 18 7380
TEST_TIME 19 7538
TEST_TIME 20 8078
TEST_TIME 21 8286
TEST_TIME 22 8340
TEST_TIME 23 8782
TEST_TIME 24 9044
TEST_TIME 25 9752
TEST_TIME 26 9690
TEST_TIME 27 9577
TEST_TIME 28 9451
TEST_TIME 29 9604
TEST_TIME 30 9632
TEST_TIME 31 9412
TEST_TIME 32 9316
TEST_TIME 33 9228
TEST_TIME 34 9205
TEST_TIME 35 9176
TEST_TIME 36 9108
TEST_TIME 37 9207
TEST_TIME 38 9123
TEST_TIME 39 9228
TEST_TIME 40 9144
TEST_TIME 41 9113
TEST_TIME 42 9206
TEST_TIME 43 9262
TEST_TIME 44 9487
TEST_TIME 45 9547
TEST_TIME 46 9529
TEST_TIME 47 9484
TEST_TIME 48 9462
TEST_TIME 49 9469
TEST_TIME 50 9555
TEST_TIME 51 9660
TEST_TIME 52 9707
TEST_TIME 53 9728
TEST_TIME 54 9657
TEST_TIME 55 9562
TEST_TIME 56 9470
TEST_TIME 57 9370
TEST_TIME 58 9307
TEST_TIME 59 9398
TEST_TIME 60 9309
TEST_TIME 61 9250
TEST_TIME 62 9225
TEST_TIME 63 9099
TEST_TIME 64 9137
TEST_TIME 65 9095
TEST_TIME 66 9078
TEST_TIME 67 9094
TEST_TIME 68 9152
TEST_TIME 69 9129
TEST_TIME 70 9199
TEST_TIME 71 9257
TEST_TIME 72 9294
TEST_TIME 73 9396
TEST_TIME 74 9390
TEST_TIME 75 9383
TEST_TIME 76 9444
TEST_TIME 77 9498
TEST_TIME 78 9390
TEST_TIME 79 9352
TEST_TIME 80 9353
TEST_TIME 81 9333
TEST_TIME 82 9244
TEST_TIME 83 9216
TEST_TIME 84 9170
TEST_TIME 85 9241
TEST_TIME 86 9324
TEST_TIME 87 9284
TEST_TIME 88 9290
TEST_TIME 89 9328
TEST_TIME 90 9405
TEST_TIME 91 9380
TEST_TIME 92 9439
TEST_TIME 93 9411
TEST_TIME 94 9470
TEST_TIME 95 9478
TEST_TIME 96 9457
TEST_TIME 97 9406
TEST_TIME 98 9332
TEST_TIME 99 9370
TEST_TIME 100 9331

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:03, from 12-03-2024 13:10:09 to 12-03-2024 13:10:12.

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 1318358 1318358 0 0.00 0 20332 8 0 0
doc_list_biud 1318357 1318357 0 0.00 0 30581 25 0 0
sp_add_invoice_to_stock 4523 4388 135 2.98 26 203704 20984 0 135
sp_cancel_adding_invoice 4441 4441 0 0.00 4 60302 891 0 0
sp_cancel_client_order 1514 1514 0 0.00 3 8695 375 0 0
sp_cancel_customer_reserve 436767 436767 0 0.00 0 29157 61 0 0
sp_cancel_pay_from_customer 609 609 0 0.00 3 5880 95 0 0
sp_cancel_pay_to_supplier 370 370 0 0.00 2 1708 65 0 0
sp_cancel_supplier_invoice 4899 4882 17 0.34 2 20221 688 0 17
sp_cancel_supplier_order 353 353 0 0.00 8 820332 92667 0 0
sp_cancel_write_off 7802 7802 0 0.00 1 11852 149 0 0
sp_client_order 17789 17789 0 0.00 3 26238 387 0 0
sp_customer_reserve 422915 422915 0 0.00 0 51720 201 0 0
sp_fill_shopping_cart 27339 27339 0 0.00 1 18004 37 0 0
sp_fill_shopping_cart_clo_res 422906 422906 0 0.00 0 27765 16 0 0
sp_get_clo_for_invoice 4378 4378 0 0.00 0 31298 350 0 0
sp_kill_cost_storno 13222 13222 0 0.00 0 18871 69 0 0
sp_kill_qstorno_ret_qs2qd 886571 886571 0 0.00 0 29119 32 0 0
sp_kill_qty_storno 468770 468770 0 0.00 0 30581 70 0 0
sp_lock_selected_doc 18038 18038 0 0.00 0 8714 7 0 0
sp_make_cost_storno 24235 24235 0 0.00 0 13853 63 0 0
sp_multiply_rows_for_pdistr 24235 24235 0 0.00 0 18033 34 0 0
sp_multiply_rows_for_qdistr 17789 17789 0 0.00 0 26229 203 0 0
sp_pay_from_customer 6179 6179 0 0.00 4 17801 114 0 0
sp_pay_to_supplier 5044 5044 0 0.00 4 17966 140 0 0
sp_payment_common 11223 11223 0 0.00 1 17744 27 0 0
sp_qd_handle_on_cancel_clo 1514 1514 0 0.00 0 8688 352 0 0
sp_qd_handle_on_invoice_upd_sts 8819 8819 0 0.00 0 30580 303 0 0
sp_qd_handle_on_reserve_upd_sts 8633 8633 0 0.00 0 17926 62 0 0
sp_reserve_write_off 8634 8634 0 0.00 6 18194 204 0 0
sp_supplier_invoice 4758 4758 0 0.00 6 87722 3071 0 0
sp_supplier_order 4802 4802 0 0.00 5 44789 1198 0 0
srv_aggregate_perf_data 79 79 0 0.00 1845 353618 21317 0 0
srv_fill_mon_cache_memory 53 53 0 0.00 1201 129108 44628 0 0
srv_find_qd_qs_mism 887471 887471 0 0.00 0 20331 7 0 0
srv_make_invnt_saldo 390 390 0 0.00 31 95708 3823 0 0
srv_make_money_saldo 639 639 0 0.00 1 17378 576 0 0
srv_recalc_idx_stat 3 3 0 0.00 256567 396275 311450 0 0
t$perf-abend:sp_add_invoice_to_stock 135 135 0 0.00 0 0 0 0 0
t$perf-abend:sp_cancel_supplier_invoice 17 17 0 0.00 0 0 0 0 0
t$perf-norm:sp_add_invoice_to_stock 4388 4388 0 0.00 0 20694 201 0 0
t$perf-norm:sp_cancel_adding_invoice 374 374 0 0.00 0 2876 86 0 0
t$perf-norm:sp_cancel_client_order 1514 1514 0 0.00 0 4358 10 0 0
t$perf-norm:sp_cancel_customer_reserve 551 551 0 0.00 0 1646 13 0 0
t$perf-norm:sp_cancel_pay_from_customer 609 609 0 0.00 0 3099 12 0 0
t$perf-norm:sp_cancel_pay_to_supplier 370 370 0 0.00 0 8848 33 0 0
t$perf-norm:sp_cancel_supplier_invoice 334 334 0 0.00 0 4346 20 0 0
t$perf-norm:sp_cancel_supplier_order 353 353 0 0.00 0 24777 1425 0 0
t$perf-norm:sp_cancel_write_off 923 923 0 0.00 0 697 4 0 0
t$perf-norm:sp_client_order 17789 17789 0 0.00 0 5581 14 0 0
t$perf-norm:sp_customer_reserve 904 904 0 0.00 0 8112 21 0 0
t$perf-norm:sp_pay_from_customer 6179 6179 0 0.00 0 1859 7 0 0
t$perf-norm:sp_pay_to_supplier 5044 5044 0 0.00 0 3869 10 0 0
t$perf-norm:sp_reserve_write_off 8634 8634 0 0.00 0 4762 9 0 0
t$perf-norm:sp_supplier_invoice 4758 4758 0 0.00 0 5334 17 0 0
t$perf-norm:sp_supplier_order 4802 4802 0 0.00 0 5537 17 0 0
t$perf-norm:srv_aggregate_perf_data 79 79 0 0.00 0 161 6 0 0
t$perf-norm:srv_fill_mon_cache_memory 53 53 0 0.00 0 6 0 0 0
t$perf-norm:srv_make_invnt_saldo 390 390 0 0.00 0 1045 10 0 0
t$perf-norm:srv_make_money_saldo 639 639 0 0.00 0 1609 6 0 0
t$perf-norm:srv_recalc_idx_stat 3 3 0 0.00 1 97 34 0 0
v_add_invoice_to_stock 9026 8756 270 2.99 0 7195 18 0 270
v_all_customers 32810 32810 0 0.00 0 36 1 0 0
v_all_suppliers 26962 26962 0 0.00 0 25 1 0 0
v_all_wares 35576 35576 0 0.00 0 25 1 0 0
v_cancel_adding_invoice 748 748 0 0.00 0 1323 8 0 0
v_cancel_client_order 3028 3028 0 0.00 0 1692 3 0 0
v_cancel_customer_prepayment 1218 1218 0 0.00 0 3827 11 0 0
v_cancel_customer_reserve 1102 1102 0 0.00 0 1674 6 0 0
v_cancel_payment_to_supplier 740 740 0 0.00 0 203 3 0 0
v_cancel_supplier_invoice 702 668 34 4.84 0 2332 19 0 34
v_cancel_supplier_order 706 706 0 0.00 0 1550 5 0 0
v_cancel_write_off 1846 1846 0 0.00 0 5867 16 0 0
v_max_id_clo_ord 4798 4798 0 0.00 0 2080 2 0 0
v_max_id_clo_res 904 904 0 0.00 0 5914 29 0 0
v_max_id_ord_sup 4753 4753 0 0.00 0 5659 5 0 0
v_max_non_paid_invoice 1114 1114 0 0.00 0 4979 9 0 0
v_max_non_paid_realizn 3045 3045 0 0.00 0 1672 4 0 0
v_min_id_clo_ord 4798 4798 0 0.00 0 17975 11 0 0
v_min_id_clo_res 904 904 0 0.00 0 10073 37 0 0
v_min_id_ord_sup 4753 4753 0 0.00 0 5797 7 0 0
v_min_non_paid_invoice 5044 5044 0 0.00 0 11819 17 0 0
v_min_non_paid_realizn 6179 6179 0 0.00 0 17738 22 0 0
v_our_firm 9034 9034 0 0.00 0 18 1 0 0
v_reserve_write_off 17264 17264 0 0.00 0 3774 8 0 0
x_lock_depdocs_on_canc_invoice 8989 8989 0 0.00 0 24550 129 0 0
x_lock_depdocs_on_canc_sup_ord 353 353 0 0.00 0 15440 426 0 0
x_make_qstorno_1000_1200 4802 4802 0 0.00 1 44783 1115 0 0
x_make_qstorno_1200_2000 4758 4758 0 0.00 2 80014 2939 0 0
x_make_qstorno_2100_3300 422915 422915 0 0.00 0 51712 182 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 12-03-2024 13:10:13 to 12-03-2024 13:10:17.

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
11:07:54 2 8192000000 8796669552 8807108608 3187328 0.038 1 1 2 0 3284944 61840 35776
11:08:55 34016 8192000000 9721106720 10018676736 795379968 8.849 100 92 184 0 826248464 7761360 23107136
11:10:38 19028 8192000000 9767382224 10075066368 842580752 9.326 100 88 176 0 875188336 11981936 20625648
11:12:03 15861 8192000000 9791847264 10109796352 863380032 9.534 100 85 170 0 901634848 18158656 20096160
11:13:23 12992 8192000000 9851184112 10184429568 912635504 10.023 100 86 172 0 963165392 31988832 18541056
11:14:40 6946 8192000000 9922733248 10262814720 941531152 10.308 100 87 174 0 1024756464 64648272 18577040
11:15:49 5915 8192000000 9965415984 10313375744 972713664 10.613 100 83 164 0 1070881152 81505072 16662416
11:16:57 3696 8192000000 9972253392 10333913088 1002242896 10.900 100 76 150 0 1090479104 73259216 14976992
11:18:04 1534 8192000000 10009280832 10377625600 1030214432 11.171 100 91 179 1 1127584768 79377440 17992896
11:19:07 1011 8192000000 10024986192 10400698368 1054965728 11.408 100 84 168 1 1138883584 66778816 17139040
11:20:10 49999 8192000000 9981453136 10376949760 1066412816 11.518 100 56 111 0 1124048816 45193552 12442448
11:22:01 5124 8192000000 9985396688 10384281600 1069696144 11.549 100 32 64 2 1106546208 29470240 7379824
11:23:08 3664 8192000000 9994560640 10385477632 1075663232 11.606 100 43 80 0 1108827488 24095872 9068384
11:24:12 6135 8192000000 9987167824 10401251328 1081218048 11.659 100 23 46 0 1114625328 29000256 4407024
11:25:19 30430 8192000000 10006065968 10410078208 1083980768 11.685 100 36 73 0 1108780320 16880000 7919552
11:26:50 4612 8192000000 10025061840 10424692736 1089367440 11.737 99 51 100 1 1136410608 37252768 9790400
11:27:57 42031 8192000000 10017321472 10416070656 1097482448 11.814 100 39 79 1 1127648480 21903600 8262432
11:29:43 66960 8192000000 10093101088 10508513280 1103875136 11.874 99 51 98 1 1192405216 77637328 10892752
11:32:46 16229 8192000000 10109453664 10516893696 1121078720 12.037 100 43 85 0 1218649200 89087392 8483088
11:34:08 27941 8192000000 10163053952 10567372800 1104441568 11.880 99 47 91 0 1265670736 151162784 10066384
11:36:13 6725 8192000000 10145785600 10538221568 1105985104 11.894 99 59 116 1 1251190192 133126416 12078672
11:37:26 13150 8192000000 10153564384 10552750080 1095464256 11.795 98 49 97 0 1251419472 145163504 10791712
11:38:42 4487 8192000000 10134066688 10530664448 1095297504 11.793 99 48 92 1 1231558528 125699904 10561120
11:40:04 5127 8192000000 10196164304 10581356544 1091788944 11.760 98 83 164 0 1296377664 186518000 18070720
11:41:18 8947 8192000000 10237397424 10634338304 1133711472 12.156 100 73 144 1 1332508288 183093008 15703808
11:42:31 2931 8192000000 10219200128 10620764160 1122526880 12.051 100 61 122 0 1319966288 183686048 13753360
11:43:38 1932 8192000000 10311169552 10703642624 1134471216 12.163 100 87 173 1 1408986240 255592352 18922672
11:44:43 1616 8192000000 10303626848 10705616896 1130030672 12.122 100 86 168 2 1400613056 251222992 19359392
11:45:48 1198 8192000000 10290848672 10690281472 1133347520 12.153 100 85 170 0 1391129184 237953840 19827824
11:46:58 1823 8192000000 10305904496 10703740928 1138546816 12.202 100 89 179 0 1402138784 243008976 20582992
11:48:01 6705 8192000000 10244667600 10654625792 1115558752 11.985 98 39 76 2 1347360880 222823648 8978480
11:49:13 8845 8192000000 10251989504 10681528320 1134170128 12.161 100 37 75 1 1347593648 204850224 8573296
11:50:53 21233 8192000000 10203750976 10713714688 1129534464 12.117 100 14 27 0 1338215776 205259456 3421856
11:52:23 35315 8192000000 10049137584 10483372032 1119027424 12.018 100 14 26 0 1173981008 52210800 2742784
11:54:01 49766 8192000000 10064089296 10498064384 1130672160 12.128 100 33 66 0 1159675280 22137488 6865632
11:55:52 45010 8192000000 10139913440 10576601088 1139273712 12.209 100 36 70 0 1246484336 100283808 6926816
11:57:39 15706 8192000000 10120074912 10554957824 1141993488 12.234 100 37 72 1 1211044032 61921488 7129056
11:59:02 48137 8192000000 10077469424 10516578304 1143882976 12.252 100 42 83 0 1184175088 31542032 8750080
12:00:52 24226 8192000000 10101188000 10544631808 1152609200 12.334 100 24 48 0 1214658304 57549600 4499504
12:02:50 19081 8192000000 10122237360 10561290240 1159761824 12.401 100 35 71 0 1233538720 65967840 7809056
12:04:12 39807 8192000000 10175129200 10639536128 1156836400 12.374 100 29 57 0 1279444448 116246224 6361824
12:05:52 29543 8192000000 10165130256 10625691648 1163430640 12.435 100 21 42 0 1285490800 117304416 4755744
12:07:22 92588 8192000000 10178359680 10643746816 1167640432 12.475 100 19 38 0 1277409488 105620608 4148448
12:09:55 57326 8192000000 10157409632 10703708160 1160990160 12.413 100 11 22 0 1257639712 94493168 2156384
12:11:58 91115 8192000000 10069031216 10512928768 1080326288 11.651 93 10 20 0 1099597712 17635856 1635568
12:14:30 15809 8192000000 10075337648 10512781312 1134907104 12.168 100 42 81 0 1177924960 34110736 8907120
12:15:51 32935 8192000000 10074943216 10517049344 1114570384 11.976 98 36 72 0 1173646272 52086240 6989648
12:17:24 48950 8192000000 10112401008 10598211584 1122738656 12.053 99 16 32 0 1232365488 106381664 3245168
12:19:14 129107 8192000000 10028636368 10451705856 969218480 10.579 86 11 22 0 992515088 21574704 1721904
12:22:27 110236 8192000000 10001677952 10431442944 1046163328 11.324 95 27 54 0 1084897040 33034048 5699664
12:26:18 23746 8192000000 10083795184 10524344320 1082846720 11.675 99 50 98 0 1174901360 82178800 9875840
12:27:47 54818 8192000000 10022616016 10454835200 1083793664 11.684 98 14 28 0 1105747632 19081248 2872720
12:30:37 70847 8192000000 10047461440 10519793664 1118222096 12.010 100 20 38 0 1175929136 53622736 4084304
12:32:54 58839 8192000000 10070373664 10510528512 1054321280 11.402 94 25 50 0 1116181712 56411392 5449040
12:35:09 58045 8192000000 10068697296 10496167936 1084945376 11.695 97 24 48 0 1136764272 46412224 5406672
12:37:11 62375 8192000000 10065876496 10579701760 1111109648 11.943 99 28 56 0 1225789184 109273584 5405952
12:39:17 55613 8192000000 10111307184 10568314880 1121871552 12.045 100 27 54 0 1217579376 90479664 5228160
12:41:19 67724 8192000000 10068685600 10527154176 1112010224 11.951 98 16 32 0 1147097808 31981440 3106144
12:43:29 100631 8192000000 10111543232 10593505280 1115874032 11.988 98 17 35 0 1202807248 83276464 3656752
12:46:11 74694 8192000000 10073299760 10561413120 1138952768 12.206 100 21 42 0 1201281744 58023600 4305376
12:48:32 59239 8192000000 10096106240 10566029312 1142386464 12.238 99 4 8 0 1195875376 52622912 866000
12:50:46 53016 8192000000 10147816224 10615848960 1155607632 12.362 100 18 36 0 1243467712 83742416 4117664
12:52:47 125990 8192000000 10082618480 10511355904 1072033248 11.571 93 17 34 0 1111255952 35862768 3359936
12:56:00 68450 8192000000 10104436192 10567888896 1118541216 12.013 98 17 34 0 1188839584 66386656 3911712
12:58:12 45508 8192000000 10109103808 10550579200 1119093552 12.018 98 11 21 0 1185785040 64726416 1965072
13:00:10 31848 8192000000 10076562416 10504818688 1080844800 11.656 95 35 68 0 1126199072 38641152 6713120
13:01:48 76629 8192000000 10054130224 10548617216 1089370784 11.737 97 23 46 0 1176079872 82198496 4510592
13:04:05 113414 8192000000 10085801680 10516578304 1110909728 11.941 99 34 68 0 1163422592 45082000 7430864
13:06:58 41215 8192000000 10036904592 10482393088 1112870624 11.960 99 13 26 0 1146165168 31013984 2280560

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:14, from 12-03-2024 13:10:19 to 12-03-2024 13:10:33.

Exceptions occured during test was in run

FB_MNEMONA CNT UNIT FB_GDSCODE
except 135 v_add_invoice_to_stock 335544517
except 17 v_cancel_supplier_invoice 335544517

Completed "Exceptions occured during test was in run". Done for 00:00:02, from 12-03-2024 13:10:34 to 12-03-2024 13:10:36.

Content of mon$database and FB version 


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


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

Database statistics 

 
Database "/home/bases/oltp40-etalone.fdb" 
Gstat execution time Tue Mar 12 13:10:37 2024 
 
Database header page information: 
    Flags            0 
    Generation        92054 
    System Change Number    0 
    Page size        8192 
    ODS version        13.0 
    Oldest transaction    176138 
    Oldest active        176546 
    Oldest snapshot        176546 
    Next transaction    176547 
    Sequence number        0 
    Next attachment ID    700 
    Implementation        HW=AMD/Intel/x64 little-endian OS=Linux CC=gcc 
    Shadow count        0 
    Page buffers        0 
    Next header page    0 
    Database dialect    3 
    Creation date        Apr 30, 2020 7:30:08 
    Attributes        force write 
 
    Variable header data: 
    Database GUID:    {58978C10-B735-40F5-8B7D-F7A1956E782B} 
    Sweep interval:        0 
    *END* 
 
 
Database file sequence: 
File /home/bases/oltp40-etalone.fdb is the only file 
 
Analyzing database pages ... 
AGENTS (150) 
    Primary pointer page: 524, Index root page: 525 
    Total formats: 1, used formats: 1 
    Average record length: 33.60, total records: 50 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 344.00, compression ratio: 10.24 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 31% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 1 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index AGENTS_ID_DESC (2) 
    Root page: 1504333, depth: 1, leaf buckets: 1, nodes: 50 
    Average node length: 11.82, total dup: 0, max dup: 0 
    Average key length: 10.80, compression ratio: 0.83 
    Average prefix length: 1.18, average data length: 7.82 
    Clustering factor: 1, ratio: 0.02 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index AGENTS_IS_OUR_FIRM (4) 
    Root page: 1504335, depth: 1, leaf buckets: 1, nodes: 50 
    Average node length: 3.08, total dup: 48, max dup: 48 
    Average key length: 2.04, compression ratio: 0.50 
    Average prefix length: 0.96, average data length: 0.06 
    Clustering factor: 1, ratio: 0.02 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index AGENTS_IS_SUPPLIER (3) 
    Root page: 1504334, depth: 1, leaf buckets: 1, nodes: 50 
    Average node length: 3.08, total dup: 48, max dup: 44 
    Average key length: 2.04, compression ratio: 0.54 
    Average prefix length: 1.04, average data length: 0.06 
    Clustering factor: 1, ratio: 0.02 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index AGENTS_NAME_UNQ (1) 
    Root page: 1504332, depth: 1, leaf buckets: 1, nodes: 50 
    Average node length: 17.20, total dup: 0, max dup: 0 
    Average key length: 15.88, compression ratio: 0.92 
    Average prefix length: 1.42, average data length: 13.20 
    Clustering factor: 1, ratio: 0.02 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PK_AGENTS (0) 
    Root page: 1504331, depth: 1, leaf buckets: 1, nodes: 50 
    Average node length: 11.82, total dup: 0, max dup: 0 
    Average key length: 10.80, compression ratio: 0.83 
    Average prefix length: 1.18, average data length: 7.82 
    Clustering factor: 1, ratio: 0.02 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
BUSINESS_OPS (154) 
    Primary pointer page: 532, Index root page: 533 
    Total formats: 1, used formats: 1 
    Average record length: 108.20, total records: 20 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1235.00, compression ratio: 11.41 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 31% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 1 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index BO_UNIT_UNQ (1) 
    Root page: 1504264, depth: 1, leaf buckets: 1, nodes: 20 
    Average node length: 18.25, total dup: 0, max dup: 0 
    Average key length: 17.20, compression ratio: 1.24 
    Average prefix length: 7.05, average data length: 14.25 
    Clustering factor: 1, ratio: 0.05 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index BUSINESS_OPS_PREDICT_PRIOR (3) 
    Root page: 1504266, depth: 1, leaf buckets: 1, nodes: 20 
    Average node length: 5.40, total dup: 0, max dup: 0 
    Average key length: 4.35, compression ratio: 0.67 
    Average prefix length: 1.20, average data length: 1.70 
    Clustering factor: 1, ratio: 0.05 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index BUSINESS_OPS_RND_WGTH (2) 
    Root page: 1504265, depth: 1, leaf buckets: 1, nodes: 20 
    Average node length: 4.30, total dup: 6, max dup: 3 
    Average key length: 3.25, compression ratio: 0.72 
    Average prefix length: 1.35, average data length: 1.00 
    Clustering factor: 1, ratio: 0.05 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index RDB$1 (0) 
    Root page: 1504263, depth: 1, leaf buckets: 1, nodes: 20 
    Average node length: 5.20, total dup: 0, max dup: 0 
    Average key length: 4.15, compression ratio: 0.65 
    Average prefix length: 1.10, average data length: 1.60 
    Clustering factor: 1, ratio: 0.05 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
DOC_DATA (139) 
    Primary pointer page: 502, Index root page: 503 
    Total formats: 1, used formats: 1 
    Average record length: 47.71, total records: 7714825 
    Average version length: 48.17, total versions: 36218, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 64.00, compression ratio: 1.34 
    Pointer pages: 55, data page slots: 88920 
    Data pages: 88920, average fill: 69% 
    Primary pages: 88919, secondary pages: 1, swept pages: 50636 
    Empty pages: 2, full pages: 60438 
    Fill distribution: 
     0 - 19% = 16 
    20 - 39% = 48 
    40 - 59% = 1981 
    60 - 79% = 86868 
    80 - 99% = 7 
 
    Index DOC_DATA_DOC_WARE_UNQ (0) 
    Root page: 1510636, depth: 3, leaf buckets: 23324, nodes: 7714825 
    Average node length: 18.88, total dup: 0, max dup: 0 
    Average key length: 15.89, compression ratio: 1.70 
    Average prefix length: 14.11, average data length: 12.89 
    Clustering factor: 1676741, ratio: 0.22 
    Fill distribution: 
         0 - 19% = 328 
        20 - 39% = 2060 
        40 - 59% = 4057 
        60 - 79% = 2459 
        80 - 99% = 14420 
 
    Index DOC_DATA_ID_DESC (1) 
    Root page: 1528140, depth: 3, leaf buckets: 13540, nodes: 7714825 
    Average node length: 11.20, total dup: 0, max dup: 0 
    Average key length: 8.21, compression ratio: 1.10 
    Average prefix length: 3.78, average data length: 5.22 
    Clustering factor: 1500493, ratio: 0.19 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 1738 
        40 - 59% = 1944 
        60 - 79% = 1168 
        80 - 99% = 8690 
 
    Index FK_DOC_DATA_DOC_LIST (2) 
    Root page: 1546735, depth: 3, leaf buckets: 8371, nodes: 7714825 
    Average node length: 6.61, total dup: 5778178, max dup: 49 
    Average key length: 3.62, compression ratio: 2.48 
    Average prefix length: 7.63, average data length: 1.37 
    Clustering factor: 1493649, ratio: 0.19 
    Fill distribution: 
         0 - 19% = 127 
        20 - 39% = 1070 
        40 - 59% = 1356 
        60 - 79% = 981 
        80 - 99% = 4837 
 
DOC_LIST (138) 
    Primary pointer page: 500, Index root page: 501 
    Total formats: 1, used formats: 1 
    Average record length: 57.07, total records: 2227754 
    Average version length: 58.88, total versions: 17091, max versions: 2 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 84.00, compression ratio: 1.47 
    Pointer pages: 18, data page slots: 28776 
    Data pages: 28776, average fill: 71% 
    Primary pages: 28775, secondary pages: 1, swept pages: 17351 
    Empty pages: 3, full pages: 15476 
    Fill distribution: 
     0 - 19% = 9 
    20 - 39% = 25 
    40 - 59% = 561 
    60 - 79% = 28152 
    80 - 99% = 29 
 
    Index DOC_LIST_ID_DESC (1) 
    Root page: 1541152, depth: 3, leaf buckets: 4561, nodes: 2227754 
    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: 682214, ratio: 0.31 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 948 
        40 - 59% = 849 
        60 - 79% = 773 
        80 - 99% = 1991 
 
    Index DOC_LIST_WORKER_OPTYPE (2) 
    Root page: 1544398, depth: 3, leaf buckets: 2392, nodes: 2228453 
    Average node length: 4.97, total dup: 2227554, max dup: 19981 
    Average key length: 2.01, compression ratio: 4.48 
    Average prefix length: 8.99, average data length: 0.01 
    Clustering factor: 1259217, ratio: 0.57 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 199 
        40 - 59% = 1381 
        60 - 79% = 546 
        80 - 99% = 265 
 
    Index FK_DOC_LIST_AGENTS (3) 
    Root page: 1545933, depth: 3, leaf buckets: 1784, nodes: 2227754 
    Average node length: 4.97, total dup: 2227704, max dup: 130377 
    Average key length: 2.01, compression ratio: 4.48 
    Average prefix length: 8.99, average data length: 0.01 
    Clustering factor: 1064816, ratio: 0.48 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 4 
        40 - 59% = 632 
        60 - 79% = 49 
        80 - 99% = 1099 
 
    Index PK_DOC_LIST (0) 
    Root page: 1538209, depth: 3, leaf buckets: 4365, nodes: 2227754 
    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: 682214, ratio: 0.31 
    Fill distribution: 
         0 - 19% = 93 
        20 - 39% = 611 
        40 - 59% = 661 
        60 - 79% = 858 
        80 - 99% = 2142 
 
DOC_STATES (149) 
    Primary pointer page: 522, Index root page: 523 
    Total formats: 1, used formats: 1 
    Average record length: 67.50, total records: 4 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 650.00, compression ratio: 9.63 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 4% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index DOC_STATES_MCODE_UNQ (1) 
    Root page: 1504337, depth: 1, leaf buckets: 1, nodes: 4 
    Average node length: 17.75, total dup: 0, max dup: 0 
    Average key length: 16.50, compression ratio: 1.08 
    Average prefix length: 4.00, average data length: 13.75 
    Clustering factor: 1, ratio: 0.25 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index DOC_STATES_NAME_UNQ (2) 
    Root page: 1504338, depth: 1, leaf buckets: 1, nodes: 4 
    Average node length: 33.25, total dup: 0, max dup: 0 
    Average key length: 32.00, compression ratio: 0.99 
    Average prefix length: 2.50, average data length: 29.25 
    Clustering factor: 1, ratio: 0.25 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PK_DOC_STATES (0) 
    Root page: 1504336, depth: 1, leaf buckets: 1, nodes: 4 
    Average node length: 4.75, total dup: 0, max dup: 0 
    Average key length: 3.50, compression ratio: 0.86 
    Average prefix length: 1.50, average data length: 1.50 
    Clustering factor: 1, ratio: 0.25 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
FB_ERRORS (155) 
    Primary pointer page: 534, Index root page: 535 
    Total formats: 2, used formats: 2 
    Average record length: 57.88, total records: 2182 
    Average version length: 79.61, total versions: 757, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 270.43, compression ratio: 4.67 
    Pointer pages: 1, data page slots: 40 
    Data pages: 40, average fill: 72% 
    Primary pages: 39, secondary pages: 1, swept pages: 0 
    Empty pages: 4, full pages: 34 
    Fill distribution: 
     0 - 19% = 5 
    20 - 39% = 0 
    40 - 59% = 1 
    60 - 79% = 22 
    80 - 99% = 12 
 
    Index FB_ERRORS_GDS_CODE (0) 
    Root page: 398, depth: 2, leaf buckets: 2, nodes: 2182 
    Average node length: 4.40, total dup: 756, max dup: 1 
    Average key length: 2.67, compression ratio: 1.87 
    Average prefix length: 4.33, average data length: 0.67 
    Clustering factor: 1518, ratio: 0.70 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 0 
        40 - 59% = 1 
        60 - 79% = 1 
        80 - 99% = 0 
 
INVNT_SALDO (145) 
    Primary pointer page: 514, Index root page: 515 
    Total formats: 2, used formats: 1 
    Average record length: 83.22, total records: 400 
    Average version length: 32.91, total versions: 399, max versions: 1 
    Average fragment length: 2.00, total fragments: 9, max fragments: 1 
    Average unpacked length: 104.00, compression ratio: 1.25 
    Pointer pages: 1, data page slots: 32 
    Data pages: 32, average fill: 23% 
    Primary pages: 21, secondary pages: 11, swept pages: 0 
    Empty pages: 15, full pages: 6 
    Fill distribution: 
     0 - 19% = 22 
    20 - 39% = 3 
    40 - 59% = 0 
    60 - 79% = 1 
    80 - 99% = 6 
 
    Index PK_INVNT_SALDO (0) 
    Root page: 1510371, depth: 1, leaf buckets: 1, nodes: 400 
    Average node length: 11.22, total dup: 0, max dup: 0 
    Average key length: 10.22, compression ratio: 0.88 
    Average prefix length: 1.78, average data length: 7.22 
    Clustering factor: 326, ratio: 0.81 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 0 
        40 - 59% = 1 
        60 - 79% = 0 
        80 - 99% = 0 
 
INVNT_TURNOVER_LOG (153) 
    Primary pointer page: 530, Index root page: 531 
    Total formats: 1, used formats: 1 
    Average record length: 15.01, total records: 73249 
    Average version length: 68.29, total versions: 65827, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 88.00, compression ratio: 5.86 
    Pointer pages: 7, data page slots: 2200 
    Data pages: 1640, average fill: 61% 
    Primary pages: 1639, secondary pages: 1, swept pages: 5 
    Empty pages: 261, full pages: 887 
    Fill distribution: 
     0 - 19% = 410 
    20 - 39% = 143 
    40 - 59% = 102 
    60 - 79% = 122 
    80 - 99% = 863 
 
    Index INVNT_TURNOVER_LOG_WARE_DD_ID (0) 
    Root page: 1698642, depth: 3, leaf buckets: 323, nodes: 73249 
    Average node length: 13.59, total dup: 4489, max dup: 1 
    Average key length: 10.81, compression ratio: 2.50 
    Average prefix length: 19.12, average data length: 7.88 
    Clustering factor: 53564, ratio: 0.73 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 234 
        40 - 59% = 67 
        60 - 79% = 18 
        80 - 99% = 3 
 
MONEY_SALDO (141) 
    Primary pointer page: 506, Index root page: 507 
    Total formats: 1, used formats: 1 
    Average record length: 15.16, total records: 49 
    Average version length: 9.00, total versions: 62, max versions: 3 
    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: 1 
    Data pages: 1, average fill: 42% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 1 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index PK_MONEY_SALDO (0) 
    Root page: 1510383, depth: 1, leaf buckets: 1, nodes: 49 
    Average node length: 11.82, total dup: 0, max dup: 0 
    Average key length: 10.80, compression ratio: 0.83 
    Average prefix length: 1.18, average data length: 7.82 
    Clustering factor: 1, ratio: 0.02 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
MONEY_TURNOVER_LOG (140) 
    Primary pointer page: 504, Index root page: 505 
    Total formats: 1, used formats: 1 
    Average record length: 11.57, total records: 1281 
    Average version length: 43.50, total versions: 1188, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 58.00, compression ratio: 5.01 
    Pointer pages: 1, data page slots: 64 
    Data pages: 40, average fill: 34% 
    Primary pages: 39, secondary pages: 1, swept pages: 11 
    Empty pages: 17, full pages: 10 
    Fill distribution: 
     0 - 19% = 22 
    20 - 39% = 5 
    40 - 59% = 0 
    60 - 79% = 2 
    80 - 99% = 11 
 
    Index MONEY_TURNOVER_LOG_AGENT_OPTYPE (0) 
    Root page: 92043, depth: 2, leaf buckets: 3, nodes: 1281 
    Average node length: 4.27, total dup: 1183, max dup: 131 
    Average key length: 2.82, compression ratio: 6.73 
    Average prefix length: 18.25, average data length: 0.75 
    Clustering factor: 707, ratio: 0.55 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 2 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
MON_CACHE_MEMORY (165) 
    Primary pointer page: 555, Index root page: 556 
    Total formats: 2, used formats: 1 
    Average record length: 97.72, total records: 69 
    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: 48% 
    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% = 1 
    80 - 99% = 0 
 
    Index PK_MON_CACHE_MEMORY (0) 
    Root page: 1504238, depth: 1, leaf buckets: 1, nodes: 69 
    Average node length: 11.71, total dup: 0, max dup: 0 
    Average key length: 10.70, compression ratio: 0.84 
    Average prefix length: 1.29, average data length: 7.71 
    Clustering factor: 2, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
MON_LOG (162) 
    Primary pointer page: 548, Index root page: 549 
    Total formats: 2, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index MON_LOG_DTS (4) 
    Root page: 1504251, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index MON_LOG_GDSCODE (2) 
    Root page: 1504249, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index MON_LOG_ROWSET_DESC (1) 
    Root page: 1504248, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index MON_LOG_UNIT (3) 
    Root page: 1504250, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PK_MON_LOG (0) 
    Root page: 1504247, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
MON_LOG_TABLE_STATS (163) 
    Primary pointer page: 550, Index root page: 551 
    Total formats: 2, used formats: 1 
    Average record length: 67.13, total records: 30 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 611.00, compression ratio: 9.10 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 31% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 1 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index MON_LOG_TABLE_STATS_DTS (4) 
    Root page: 1504246, depth: 1, leaf buckets: 1, nodes: 30 
    Average node length: 3.50, total dup: 23, max dup: 4 
    Average key length: 2.47, compression ratio: 3.24 
    Average prefix length: 7.53, average data length: 0.47 
    Clustering factor: 1, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index MON_LOG_TABLE_STATS_GDSCODE (2) 
    Root page: 1504244, depth: 1, leaf buckets: 1, nodes: 30 
    Average node length: 2.00, total dup: 29, max dup: 29 
    Average key length: 1.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 1, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index MON_LOG_TABLE_STATS_ROWSET (1) 
    Root page: 1504243, depth: 1, leaf buckets: 1, nodes: 30 
    Average node length: 3.33, total dup: 29, max dup: 29 
    Average key length: 2.30, compression ratio: 3.91 
    Average prefix length: 8.70, average data length: 0.30 
    Clustering factor: 1, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index MON_LOG_TABLE_STATS_TN_UNIT (3) 
    Root page: 1504245, depth: 1, leaf buckets: 1, nodes: 30 
    Average node length: 12.90, total dup: 0, max dup: 0 
    Average key length: 11.87, compression ratio: 1.42 
    Average prefix length: 7.63, average data length: 9.20 
    Clustering factor: 1, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PK_MON_LOG_TABLE_STATS (0) 
    Root page: 1504242, depth: 1, leaf buckets: 1, nodes: 30 
    Average node length: 8.37, total dup: 0, max dup: 0 
    Average key length: 7.33, compression ratio: 1.23 
    Average prefix length: 4.63, average data length: 4.37 
    Clustering factor: 1, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
OPTYPES (136) 
    Primary pointer page: 496, Index root page: 497 
    Total formats: 2, used formats: 1 
    Average record length: 67.56, total records: 9 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 386.00, compression ratio: 5.71 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 9% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index OPTYPES_MCODE_UNQ (1) 
    Root page: 1544827, depth: 1, leaf buckets: 1, nodes: 9 
    Average node length: 8.56, total dup: 0, max dup: 0 
    Average key length: 6.89, compression ratio: 0.73 
    Average prefix length: 0.44, average data length: 4.56 
    Clustering factor: 1, ratio: 0.11 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PK_OPTYPES (0) 
    Root page: 1544826, depth: 1, leaf buckets: 1, nodes: 9 
    Average node length: 6.11, total dup: 0, max dup: 0 
    Average key length: 5.00, compression ratio: 0.60 
    Average prefix length: 0.89, average data length: 2.11 
    Clustering factor: 1, ratio: 0.11 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
PDISTR (146) 
    Primary pointer page: 516, Index root page: 517 
    Total formats: 1, used formats: 1 
    Average record length: 36.73, total records: 792396 
    Average version length: 37.95, total versions: 21208, max versions: 2 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 54.00, compression ratio: 1.47 
    Pointer pages: 6, data page slots: 8504 
    Data pages: 8504, average fill: 64% 
    Primary pages: 8500, secondary pages: 4, swept pages: 3530 
    Empty pages: 9, full pages: 4334 
    Fill distribution: 
     0 - 19% = 27 
    20 - 39% = 78 
    40 - 59% = 1086 
    60 - 79% = 7277 
    80 - 99% = 36 
 
    Index PDISTR_AGENT_ID (2) 
    Root page: 1509330, depth: 2, leaf buckets: 847, nodes: 782604 
    Average node length: 4.88, total dup: 782555, max dup: 144254 
    Average key length: 2.01, compression ratio: 4.48 
    Average prefix length: 8.99, average data length: 0.01 
    Clustering factor: 89317, ratio: 0.11 
    Fill distribution: 
         0 - 19% = 3 
        20 - 39% = 140 
        40 - 59% = 441 
        60 - 79% = 158 
        80 - 99% = 105 
 
    Index PDISTR_SNDOP_RCVOP_SNDID_ASC (0) 
    Root page: 1508635, depth: 3, leaf buckets: 921, nodes: 782604 
    Average node length: 5.89, total dup: 696507, max dup: 42 
    Average key length: 3.02, compression ratio: 7.28 
    Average prefix length: 21.09, average data length: 0.91 
    Clustering factor: 156219, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 60 
        40 - 59% = 472 
        60 - 79% = 107 
        80 - 99% = 281 
 
    Index PDISTR_SNDOP_RCVOP_SNDID_DESC (1) 
    Root page: 1509209, depth: 3, leaf buckets: 959, nodes: 782604 
    Average node length: 5.89, total dup: 696507, max dup: 42 
    Average key length: 3.02, compression ratio: 7.28 
    Average prefix length: 21.09, average data length: 0.91 
    Clustering factor: 158066, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 123 
        40 - 59% = 473 
        60 - 79% = 98 
        80 - 99% = 265 
 
    Index PDISTR_WORKER_SND_ID (3) 
    Root page: 1510200, depth: 3, leaf buckets: 1137, nodes: 782604 
    Average node length: 5.97, total dup: 696507, max dup: 42 
    Average key length: 3.10, compression ratio: 5.48 
    Average prefix length: 16.01, average data length: 0.99 
    Clustering factor: 150846, ratio: 0.19 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 264 
        40 - 59% = 609 
        60 - 79% = 187 
        80 - 99% = 75 
 
PERF_AGG (158) 
    Primary pointer page: 540, Index root page: 541 
    Total formats: 1, used formats: 1 
    Average record length: 62.74, total records: 5482 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 3.42, total fragments: 38, max fragments: 1 
    Average unpacked length: 379.00, compression ratio: 6.04 
    Pointer pages: 1, data page slots: 104 
    Data pages: 101, average fill: 53% 
    Primary pages: 86, secondary pages: 15, swept pages: 57 
    Empty pages: 17, full pages: 61 
    Fill distribution: 
     0 - 19% = 27 
    20 - 39% = 0 
    40 - 59% = 2 
    60 - 79% = 72 
    80 - 99% = 0 
 
    Index PERF_AGG_UNQ (1) 
    Root page: 1504260, depth: 2, leaf buckets: 7, nodes: 5482 
    Average node length: 5.53, total dup: 0, max dup: 0 
    Average key length: 3.59, compression ratio: 10.05 
    Average prefix length: 34.48, average data length: 1.55 
    Clustering factor: 5117, ratio: 0.93 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 4 
        60 - 79% = 1 
        80 - 99% = 1 
 
    Index PK_PERF_AGG (0) 
    Root page: 1504255, depth: 2, leaf buckets: 10, nodes: 5482 
    Average node length: 11.16, 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: 170, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 2 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 7 
 
PERF_ESTIMATED (280) 
    Primary pointer page: 399, Index root page: 434 
    Total formats: 1, used formats: 1 
    Average record length: 39.04, total records: 79824 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 48.00, compression ratio: 1.23 
    Pointer pages: 1, data page slots: 832 
    Data pages: 832, average fill: 66% 
    Primary pages: 832, secondary pages: 0, swept pages: 0 
    Empty pages: 2, full pages: 828 
    Fill distribution: 
     0 - 19% = 3 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 829 
    80 - 99% = 0 
 
    Index PK_PERF_ESTIMATED (0) 
    Root page: 35129, depth: 2, leaf buckets: 103, nodes: 79824 
    Average node length: 10.16, total dup: 0, max dup: 0 
    Average key length: 8.17, compression ratio: 1.10 
    Average prefix length: 3.83, average data length: 5.17 
    Clustering factor: 3131, ratio: 0.04 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 3 
        60 - 79% = 0 
        80 - 99% = 99 
 
PERF_ISQL_STAT (156) 
    Primary pointer page: 536, Index root page: 537 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index PERF_ISQL_STAT_TRN (0) 
    Root page: 1504261, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
PERF_LOG (159) 
    Primary pointer page: 542, Index root page: 543 
    Total formats: 1, used formats: 1 
    Average record length: 111.07, total records: 71 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1691.00, compression ratio: 15.22 
    Pointer pages: 1, data page slots: 2 
    Data pages: 2, average fill: 56% 
    Primary pages: 2, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 1 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 1 
    40 - 59% = 0 
    60 - 79% = 1 
    80 - 99% = 0 
 
PERF_SPLIT_0 (281) 
    Primary pointer page: 601, Index root page: 602 
    Total formats: 1, used formats: 1 
    Average record length: 147.73, total records: 174752 
    Average version length: 152.51, total versions: 4400, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.48 
    Pointer pages: 6, data page slots: 7520 
    Data pages: 4416, average fill: 82% 
    Primary pages: 4414, secondary pages: 2, swept pages: 38 
    Empty pages: 107, full pages: 4287 
    Fill distribution: 
     0 - 19% = 111 
    20 - 39% = 5 
    40 - 59% = 10 
    60 - 79% = 2 
    80 - 99% = 4288 
 
PERF_SPLIT_1 (282) 
    Primary pointer page: 603, Index root page: 604 
    Total formats: 1, used formats: 1 
    Average record length: 146.69, total records: 140396 
    Average version length: 152.41, total versions: 4231, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.56 
    Pointer pages: 5, data page slots: 4744 
    Data pages: 3552, average fill: 82% 
    Primary pages: 3551, secondary pages: 1, swept pages: 62 
    Empty pages: 92, full pages: 3431 
    Fill distribution: 
     0 - 19% = 93 
    20 - 39% = 13 
    40 - 59% = 9 
    60 - 79% = 4 
    80 - 99% = 3433 
 
PERF_SPLIT_2 (283) 
    Primary pointer page: 605, Index root page: 606 
    Total formats: 1, used formats: 1 
    Average record length: 146.86, total records: 150814 
    Average version length: 152.02, total versions: 4203, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.55 
    Pointer pages: 8, data page slots: 4336 
    Data pages: 3760, average fill: 83% 
    Primary pages: 3758, secondary pages: 2, swept pages: 4 
    Empty pages: 52, full pages: 3684 
    Fill distribution: 
     0 - 19% = 52 
    20 - 39% = 6 
    40 - 59% = 11 
    60 - 79% = 8 
    80 - 99% = 3683 
 
PERF_SPLIT_3 (284) 
    Primary pointer page: 607, Index root page: 616 
    Total formats: 1, used formats: 1 
    Average record length: 139.53, total records: 168592 
    Average version length: 154.86, total versions: 13598, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 12.16 
    Pointer pages: 6, data page slots: 4776 
    Data pages: 4264, average fill: 82% 
    Primary pages: 4262, secondary pages: 2, swept pages: 23 
    Empty pages: 105, full pages: 4130 
    Fill distribution: 
     0 - 19% = 109 
    20 - 39% = 9 
    40 - 59% = 8 
    60 - 79% = 9 
    80 - 99% = 4129 
 
PERF_SPLIT_4 (285) 
    Primary pointer page: 617, Index root page: 618 
    Total formats: 1, used formats: 1 
    Average record length: 147.98, total records: 154712 
    Average version length: 151.81, total versions: 3493, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.46 
    Pointer pages: 8, data page slots: 5312 
    Data pages: 3872, average fill: 83% 
    Primary pages: 3870, secondary pages: 2, swept pages: 5 
    Empty pages: 59, full pages: 3794 
    Fill distribution: 
     0 - 19% = 62 
    20 - 39% = 8 
    40 - 59% = 5 
    60 - 79% = 5 
    80 - 99% = 3792 
 
PERF_SPLIT_5 (286) 
    Primary pointer page: 619, Index root page: 620 
    Total formats: 1, used formats: 1 
    Average record length: 147.36, total records: 160830 
    Average version length: 152.18, total versions: 4130, 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: 8, data page slots: 4640 
    Data pages: 4000, average fill: 83% 
    Primary pages: 3997, secondary pages: 3, swept pages: 8 
    Empty pages: 43, full pages: 3936 
    Fill distribution: 
     0 - 19% = 47 
    20 - 39% = 2 
    40 - 59% = 8 
    60 - 79% = 7 
    80 - 99% = 3936 
 
PERF_SPLIT_6 (287) 
    Primary pointer page: 621, Index root page: 622 
    Total formats: 1, used formats: 1 
    Average record length: 148.42, total records: 162498 
    Average version length: 151.53, total versions: 3214, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.43 
    Pointer pages: 8, data page slots: 4328 
    Data pages: 4024, average fill: 83% 
    Primary pages: 4022, secondary pages: 2, swept pages: 10 
    Empty pages: 24, full pages: 3987 
    Fill distribution: 
     0 - 19% = 28 
    20 - 39% = 6 
    40 - 59% = 0 
    60 - 79% = 3 
    80 - 99% = 3987 
 
PERF_SPLIT_7 (288) 
    Primary pointer page: 626, Index root page: 627 
    Total formats: 1, used formats: 1 
    Average record length: 146.49, total records: 160692 
    Average version length: 152.82, total versions: 5248, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.58 
    Pointer pages: 7, data page slots: 5008 
    Data pages: 4024, average fill: 83% 
    Primary pages: 4022, secondary pages: 2, swept pages: 5 
    Empty pages: 65, full pages: 3939 
    Fill distribution: 
     0 - 19% = 66 
    20 - 39% = 11 
    40 - 59% = 3 
    60 - 79% = 4 
    80 - 99% = 3940 
 
PERF_SPLIT_8 (289) 
    Primary pointer page: 628, Index root page: 629 
    Total formats: 1, used formats: 1 
    Average record length: 146.23, total records: 154391 
    Average version length: 152.41, total versions: 4885, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.60 
    Pointer pages: 7, data page slots: 4952 
    Data pages: 3832, average fill: 83% 
    Primary pages: 3831, secondary pages: 1, swept pages: 9 
    Empty pages: 42, full pages: 3772 
    Fill distribution: 
     0 - 19% = 44 
    20 - 39% = 7 
    40 - 59% = 6 
    60 - 79% = 3 
    80 - 99% = 3772 
 
PERF_SPLIT_9 (290) 
    Primary pointer page: 630, Index root page: 631 
    Total formats: 1, used formats: 1 
    Average record length: 146.38, total records: 150464 
    Average version length: 152.34, total versions: 4761, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.59 
    Pointer pages: 6, data page slots: 5192 
    Data pages: 3768, average fill: 83% 
    Primary pages: 3766, secondary pages: 2, swept pages: 10 
    Empty pages: 59, full pages: 3681 
    Fill distribution: 
     0 - 19% = 67 
    20 - 39% = 12 
    40 - 59% = 4 
    60 - 79% = 5 
    80 - 99% = 3680 
 
PHRASES (143) 
    Primary pointer page: 510, Index root page: 511 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index PHRASES_ID_DESC (3) 
    Root page: 1510376, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PHRASES_NAME (2) 
    Root page: 1510375, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PHRASES_UNQ (1) 
    Root page: 1510374, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PK_PHRASES (0) 
    Root page: 1510373, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
PSTORNED (147) 
    Primary pointer page: 518, Index root page: 519 
    Total formats: 1, used formats: 1 
    Average record length: 52.50, total records: 2084193 
    Average version length: 52.92, total versions: 11858, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 70.00, compression ratio: 1.33 
    Pointer pages: 16, data page slots: 25768 
    Data pages: 25760, average fill: 69% 
    Primary pages: 25745, secondary pages: 15, swept pages: 12883 
    Empty pages: 154, full pages: 21146 
    Fill distribution: 
     0 - 19% = 329 
    20 - 39% = 331 
    40 - 59% = 1066 
    60 - 79% = 23941 
    80 - 99% = 93 
 
    Index PSTORNED_RCV_ID (1) 
    Root page: 1506208, depth: 3, leaf buckets: 2562, nodes: 2084193 
    Average node length: 5.44, total dup: 1944331, max dup: 1595 
    Average key length: 2.49, compression ratio: 3.62 
    Average prefix length: 8.58, average data length: 0.42 
    Clustering factor: 181330, ratio: 0.09 
    Fill distribution: 
         0 - 19% = 7 
        20 - 39% = 314 
        40 - 59% = 1625 
        60 - 79% = 309 
        80 - 99% = 307 
 
    Index PSTORNED_SND_ID (0) 
    Root page: 1504841, depth: 3, leaf buckets: 2760, nodes: 2084193 
    Average node length: 5.70, total dup: 1870035, max dup: 64 
    Average key length: 2.74, compression ratio: 3.28 
    Average prefix length: 8.36, average data length: 0.64 
    Clustering factor: 373267, ratio: 0.18 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 6 
        40 - 59% = 2477 
        60 - 79% = 255 
        80 - 99% = 22 
 
    Index PSTORNED_WORKER_ID (2) 
    Root page: 1508018, depth: 3, leaf buckets: 2096, nodes: 2084193 
    Average node length: 4.96, total dup: 2084093, max dup: 28023 
    Average key length: 2.00, compression ratio: 1.20 
    Average prefix length: 2.40, average data length: 0.00 
    Clustering factor: 179267, ratio: 0.09 
    Fill distribution: 
         0 - 19% = 3 
        20 - 39% = 215 
        40 - 59% = 1040 
        60 - 79% = 389 
        80 - 99% = 449 
 
RULES_FOR_PDISTR (148) 
    Primary pointer page: 520, Index root page: 521 
    Total formats: 1, used formats: 1 
    Average record length: 17.00, total records: 4 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 334.00, compression ratio: 19.65 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 2% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index RULES_FOR_PDISTR_UNQ (0) 
    Root page: 1504339, depth: 1, leaf buckets: 1, nodes: 4 
    Average node length: 11.50, total dup: 0, max dup: 0 
    Average key length: 10.25, compression ratio: 0.88 
    Average prefix length: 1.50, average data length: 7.50 
    Clustering factor: 1, ratio: 0.25 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
RULES_FOR_QDISTR (137) 
    Primary pointer page: 498, Index root page: 499 
    Total formats: 1, used formats: 1 
    Average record length: 32.71, total records: 7 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 332.00, compression ratio: 10.15 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 4% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index RULES_FOR_QDISTR_RCVOP (1) 
    Root page: 1544825, depth: 1, leaf buckets: 1, nodes: 7 
    Average node length: 5.29, total dup: 2, max dup: 2 
    Average key length: 4.14, compression ratio: 0.72 
    Average prefix length: 1.43, average data length: 1.57 
    Clustering factor: 1, ratio: 0.14 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index RULES_FOR_QDISTR_UNQ (0) 
    Root page: 1544824, depth: 1, leaf buckets: 1, nodes: 7 
    Average node length: 10.14, total dup: 0, max dup: 0 
    Average key length: 8.86, compression ratio: 0.94 
    Average prefix length: 2.14, average data length: 6.14 
    Clustering factor: 1, ratio: 0.14 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
SEMAPHORES (152) 
    Primary pointer page: 528, Index root page: 529 
    Total formats: 1, used formats: 1 
    Average record length: 43.40, total records: 5 
    Average version length: 9.00, total versions: 1, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 346.00, compression ratio: 7.97 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 4% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index PK_SEMAPHORES (0) 
    Root page: 1504327, depth: 1, leaf buckets: 1, nodes: 5 
    Average node length: 12.40, total dup: 0, max dup: 0 
    Average key length: 11.00, compression ratio: 0.82 
    Average prefix length: 0.60, average data length: 8.40 
    Clustering factor: 1, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index SEMAPHORES_TASK_UNQ (1) 
    Root page: 1504328, depth: 1, leaf buckets: 1, nodes: 5 
    Average node length: 23.40, total dup: 0, max dup: 0 
    Average key length: 22.00, compression ratio: 1.07 
    Average prefix length: 4.20, average data length: 19.40 
    Clustering factor: 1, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
SETTINGS (135) 
    Primary pointer page: 494, Index root page: 495 
    Total formats: 1, used formats: 1 
    Average record length: 97.62, total records: 149 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1347.00, compression ratio: 13.80 
    Pointer pages: 1, data page slots: 3 
    Data pages: 3, average fill: 70% 
    Primary pages: 3, secondary pages: 0, swept pages: 1 
    Empty pages: 0, full pages: 2 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 1 
    60 - 79% = 0 
    80 - 99% = 2 
 
    Index SETTINGS_MCODE_WM_UNQ (1) 
    Root page: 1544931, depth: 1, leaf buckets: 1, nodes: 149 
    Average node length: 14.66, total dup: 0, max dup: 0 
    Average key length: 13.55, compression ratio: 2.19 
    Average prefix length: 19.07, average data length: 10.66 
    Clustering factor: 48, ratio: 0.32 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 1 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index SETTINGS_MODE_CODE (0) 
    Root page: 1544828, depth: 1, leaf buckets: 1, nodes: 149 
    Average node length: 25.56, total dup: 0, max dup: 0 
    Average key length: 24.56, compression ratio: 1.63 
    Average prefix length: 18.58, average data length: 21.56 
    Clustering factor: 14, ratio: 0.09 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 0 
        40 - 59% = 1 
        60 - 79% = 0 
        80 - 99% = 0 
 
TMP$DEP_DOCS (129) 
    Primary pointer page: 482, Index root page: 483 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index TMP_DEP_DOCS_UNQ (0) 
    Root page: 1544832, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
TMP$IDX_RECALC (132) 
    Primary pointer page: 488, Index root page: 489 
    Total formats: 2, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index TMP_IDX_RECALC_IDX_NAME_UNQ (0) 
    Root page: 1544829, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
TMP$MON_LOG (133) 
    Primary pointer page: 490, Index root page: 491 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
TMP$MON_LOG_TABLE_STATS (134) 
    Primary pointer page: 492, Index root page: 493 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
TMP$PERF_EST_WHOLE (161) 
    Primary pointer page: 546, Index root page: 547 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
TMP$PERF_LOG (160) 
    Primary pointer page: 544, Index root page: 545 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index TMP$PERF_LOG_UNIT_TRN_DTS_END (0) 
    Root page: 1504252, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
TMP$PERF_MON (131) 
    Primary pointer page: 486, Index root page: 487 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
TMP$RESULT_SET (130) 
    Primary pointer page: 484, Index root page: 485 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index TMP_RESULT_SET_DOC (1) 
    Root page: 1544831, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index TMP_RESULT_SET_WARE_DOC (0) 
    Root page: 1544830, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
TMP$SHOPPING_CART (128) 
    Primary pointer page: 480, Index root page: 481 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index TMP_SHOPCART_UNQ (0) 
    Root page: 1544833, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
TPAUSE (166) 
    Primary pointer page: 557, Index root page: 558 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index RDB$PRIMARY2 (0) 
    Root page: 1504237, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
TRACE_STAT (157) 
    Primary pointer page: 538, Index root page: 539 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
WARES (142) 
    Primary pointer page: 508, Index root page: 509 
    Total formats: 1, used formats: 1 
    Average record length: 77.52, total records: 400 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 444.00, compression ratio: 5.73 
    Pointer pages: 1, data page slots: 6 
    Data pages: 6, average fill: 77% 
    Primary pages: 6, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 5 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 5 
    80 - 99% = 1 
 
    Index FK_WARES_WARE_GROUPS (3) 
    Root page: 1552183, depth: 1, leaf buckets: 1, nodes: 400 
    Average node length: 3.17, total dup: 392, max dup: 60 
    Average key length: 2.16, compression ratio: 4.16 
    Average prefix length: 8.86, average data length: 0.14 
    Clustering factor: 48, ratio: 0.12 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PK_WARES (0) 
    Root page: 1510377, depth: 1, leaf buckets: 1, nodes: 400 
    Average node length: 11.22, total dup: 0, max dup: 0 
    Average key length: 10.22, compression ratio: 0.88 
    Average prefix length: 1.78, average data length: 7.22 
    Clustering factor: 344, ratio: 0.86 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 0 
        40 - 59% = 1 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index WARES_ID_DESC (2) 
    Root page: 1510382, depth: 1, leaf buckets: 1, nodes: 400 
    Average node length: 11.22, total dup: 0, max dup: 0 
    Average key length: 10.22, compression ratio: 0.88 
    Average prefix length: 1.78, average data length: 7.22 
    Clustering factor: 344, ratio: 0.86 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 0 
        40 - 59% = 1 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index WARES_NUMB_UNQ (1) 
    Root page: 1510380, depth: 2, leaf buckets: 3, nodes: 400 
    Average node length: 53.25, total dup: 0, max dup: 0 
    Average key length: 52.23, compression ratio: 1.00 
    Average prefix length: 2.74, average data length: 49.25 
    Clustering factor: 355, ratio: 0.89 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 1 
        80 - 99% = 2 
 
WARE_GROUPS (151) 
    Primary pointer page: 526, Index root page: 527 
    Total formats: 1, used formats: 1 
    Average record length: 32.12, total records: 8 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 346.00, compression ratio: 10.77 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 5% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index PK_WARE_GROUPS (0) 
    Root page: 1504329, depth: 1, leaf buckets: 1, nodes: 8 
    Average node length: 11.25, total dup: 0, max dup: 0 
    Average key length: 10.12, compression ratio: 0.89 
    Average prefix length: 1.75, average data length: 7.25 
    Clustering factor: 1, ratio: 0.12 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index WARE_GROUPS_NAME_UNQ (1) 
    Root page: 1504330, depth: 1, leaf buckets: 1, nodes: 8 
    Average node length: 19.88, total dup: 0, max dup: 0 
    Average key length: 18.12, compression ratio: 0.89 
    Average prefix length: 0.25, average data length: 15.88 
    Clustering factor: 1, ratio: 0.12 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
XQD_1000_1200 (176) 
    Primary pointer page: 577, Index root page: 578 
    Total formats: 1, used formats: 1 
    Average record length: 43.41, total records: 118401 
    Average version length: 69.19, total versions: 50754, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 2.90 
    Pointer pages: 3, data page slots: 4056 
    Data pages: 2864, average fill: 51% 
    Primary pages: 2864, secondary pages: 0, swept pages: 367 
    Empty pages: 380, full pages: 884 
    Fill distribution: 
     0 - 19% = 563 
    20 - 39% = 365 
    40 - 59% = 663 
    60 - 79% = 757 
    80 - 99% = 516 
 
    Index XQD_1000_1200_WA_SO_RO_WKR_SND (0) 
    Root page: 104031, depth: 3, leaf buckets: 223, nodes: 118401 
    Average node length: 6.49, total dup: 102996, max dup: 14 
    Average key length: 4.00, compression ratio: 10.51 
    Average prefix length: 40.13, average data length: 1.87 
    Clustering factor: 20794, ratio: 0.18 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 93 
        40 - 59% = 112 
        60 - 79% = 18 
        80 - 99% = 0 
 
XQD_1000_3300 (178) 
    Primary pointer page: 581, Index root page: 582 
    Total formats: 1, used formats: 1 
    Average record length: 66.94, total records: 6899068 
    Average version length: 68.77, total versions: 231196, 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: 65, data page slots: 106032 
    Data pages: 106032, average fill: 70% 
    Primary pages: 106031, secondary pages: 1, swept pages: 49497 
    Empty pages: 6, full pages: 46396 
    Fill distribution: 
     0 - 19% = 50 
    20 - 39% = 540 
    40 - 59% = 9506 
    60 - 79% = 95452 
    80 - 99% = 484 
 
    Index XQD_1000_3300_WA_SO_RO_WKR_SND (0) 
    Root page: 1480476, depth: 3, leaf buckets: 10689, nodes: 6899068 
    Average node length: 6.51, total dup: 5966383, max dup: 29 
    Average key length: 3.52, compression ratio: 11.92 
    Average prefix length: 40.61, average data length: 1.39 
    Clustering factor: 1622381, ratio: 0.24 
    Fill distribution: 
         0 - 19% = 8 
        20 - 39% = 1827 
        40 - 59% = 5999 
        60 - 79% = 2477 
        80 - 99% = 378 
 
    Index XQD_1000_3300_WKR_DOC_ASC (1) 
    Root page: 1486090, depth: 3, leaf buckets: 8429, nodes: 6899068 
    Average node length: 5.40, total dup: 6621782, max dup: 150 
    Average key length: 2.41, compression ratio: 7.05 
    Average prefix length: 16.63, average data length: 0.37 
    Clustering factor: 1432008, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 5 
        20 - 39% = 1273 
        40 - 59% = 4656 
        60 - 79% = 1477 
        80 - 99% = 1018 
 
    Index XQD_1000_3300_WKR_DOC_DEC (2) 
    Root page: 1490630, depth: 3, leaf buckets: 8504, nodes: 6899068 
    Average node length: 5.40, total dup: 6621782, max dup: 150 
    Average key length: 2.41, compression ratio: 7.05 
    Average prefix length: 16.63, average data length: 0.37 
    Clustering factor: 1434336, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 5 
        20 - 39% = 1338 
        40 - 59% = 4713 
        60 - 79% = 1459 
        80 - 99% = 989 
 
XQD_1200_2000 (177) 
    Primary pointer page: 579, Index root page: 580 
    Total formats: 1, used formats: 1 
    Average record length: 68.18, total records: 11944212 
    Average version length: 68.70, total versions: 151996, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.85 
    Pointer pages: 108, data page slots: 175408 
    Data pages: 175408, average fill: 72% 
    Primary pages: 175408, secondary pages: 0, swept pages: 102730 
    Empty pages: 7, full pages: 124500 
    Fill distribution: 
     0 - 19% = 32 
    20 - 39% = 465 
    40 - 59% = 6673 
    60 - 79% = 167579 
    80 - 99% = 659 
 
    Index XQD_1200_2000_WA_SO_RO_WKR_SND (0) 
    Root page: 1495050, depth: 3, leaf buckets: 18425, nodes: 11943327 
    Average node length: 6.62, total dup: 10410770, max dup: 59 
    Average key length: 3.43, compression ratio: 12.26 
    Average prefix length: 40.70, average data length: 1.30 
    Clustering factor: 2441097, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 33 
        20 - 39% = 2617 
        40 - 59% = 10633 
        60 - 79% = 4288 
        80 - 99% = 854 
 
XQD_2000_3300 (179) 
    Primary pointer page: 583, Index root page: 584 
    Total formats: 1, used formats: 1 
    Average record length: 55.74, total records: 1204978 
    Average version length: 69.08, total versions: 205047, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 2.26 
    Pointer pages: 27, data page slots: 42992 
    Data pages: 27744, average fill: 47% 
    Primary pages: 27689, secondary pages: 55, swept pages: 13681 
    Empty pages: 4742, full pages: 11579 
    Fill distribution: 
     0 - 19% = 7311 
    20 - 39% = 3599 
    40 - 59% = 3520 
    60 - 79% = 11042 
    80 - 99% = 2272 
 
    Index XQD_2000_3300_WA_SO_RO_WKR_SND (0) 
    Root page: 1479735, depth: 3, leaf buckets: 1767, nodes: 1141240 
    Average node length: 5.54, total dup: 1094900, max dup: 49 
    Average key length: 2.58, compression ratio: 16.26 
    Average prefix length: 41.46, average data length: 0.54 
    Clustering factor: 78892, ratio: 0.07 
    Fill distribution: 
         0 - 19% = 10 
        20 - 39% = 699 
        40 - 59% = 814 
        60 - 79% = 226 
        80 - 99% = 18 
 
XQD_2100_3300 (180) 
    Primary pointer page: 585, Index root page: 586 
    Total formats: 1, used formats: 1 
    Average record length: 48.36, total records: 977943 
    Average version length: 69.04, total versions: 103735, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 2.61 
    Pointer pages: 21, data page slots: 32680 
    Data pages: 27456, average fill: 35% 
    Primary pages: 27456, secondary pages: 0, swept pages: 9612 
    Empty pages: 4722, full pages: 3323 
    Fill distribution: 
     0 - 19% = 8267 
    20 - 39% = 6443 
    40 - 59% = 8509 
    60 - 79% = 4192 
    80 - 99% = 45 
 
    Index XQD_2100_3300_WA_SO_RO_WKR_SND (0) 
    Root page: 1479229, depth: 3, leaf buckets: 1185, nodes: 744936 
    Average node length: 5.89, total dup: 689724, max dup: 56 
    Average key length: 2.96, compression ratio: 14.21 
    Average prefix length: 41.12, average data length: 0.88 
    Clustering factor: 105899, ratio: 0.14 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 413 
        40 - 59% = 570 
        60 - 79% = 195 
        80 - 99% = 7 
 
XQD_3300_3400 (181) 
    Primary pointer page: 587, Index root page: 588 
    Total formats: 1, used formats: 1 
    Average record length: 67.85, total records: 8945498 
    Average version length: 69.00, total versions: 154216, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.86 
    Pointer pages: 89, data page slots: 144000 
    Data pages: 143976, average fill: 66% 
    Primary pages: 143957, secondary pages: 19, swept pages: 89146 
    Empty pages: 353, full pages: 55833 
    Fill distribution: 
     0 - 19% = 1101 
    20 - 39% = 5797 
    40 - 59% = 22364 
    60 - 79% = 114121 
    80 - 99% = 593 
 
    Index XQD_3300_3400_WA_SO_RO_WKR_SND (0) 
    Root page: 1472612, depth: 3, leaf buckets: 13468, nodes: 8943708 
    Average node length: 6.68, total dup: 7417428, max dup: 14 
    Average key length: 3.67, compression ratio: 11.44 
    Average prefix length: 40.50, average data length: 1.50 
    Clustering factor: 2031067, ratio: 0.23 
    Fill distribution: 
         0 - 19% = 3 
        20 - 39% = 1556 
        40 - 59% = 7173 
        60 - 79% = 4253 
        80 - 99% = 483 
 
XQS_1000_1200 (182) 
    Primary pointer page: 589, Index root page: 590 
    Total formats: 1, used formats: 1 
    Average record length: 82.53, total records: 21155322 
    Average version length: 82.97, total versions: 3652, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.53 
    Pointer pages: 197, data page slots: 320016 
    Data pages: 320016, average fill: 81% 
    Primary pages: 320010, secondary pages: 6, swept pages: 14023 
    Empty pages: 44, full pages: 318843 
    Fill distribution: 
     0 - 19% = 79 
    20 - 39% = 59 
    40 - 59% = 141 
    60 - 79% = 49806 
    80 - 99% = 269931 
 
    Index XQS_1000_1200_DOC_ID (1) 
    Root page: 1426738, depth: 3, leaf buckets: 19678, nodes: 21155322 
    Average node length: 5.72, total dup: 20674285, max dup: 128 
    Average key length: 2.16, compression ratio: 4.16 
    Average prefix length: 8.86, average data length: 0.14 
    Clustering factor: 3283464, ratio: 0.16 
    Fill distribution: 
         0 - 19% = 6 
        20 - 39% = 0 
        40 - 59% = 8691 
        60 - 79% = 602 
        80 - 99% = 10379 
 
    Index XQS_1000_1200_RCV_ID (3) 
    Root page: 1457002, depth: 3, leaf buckets: 17189, nodes: 21155322 
    Average node length: 6.31, total dup: 18590654, max dup: 49 
    Average key length: 2.75, compression ratio: 3.27 
    Average prefix length: 8.37, average data length: 0.63 
    Clustering factor: 916864, ratio: 0.04 
    Fill distribution: 
         0 - 19% = 5 
        20 - 39% = 6 
        40 - 59% = 775 
        60 - 79% = 295 
        80 - 99% = 16108 
 
    Index XQS_1000_1200_SND_ID (2) 
    Root page: 1441095, depth: 3, leaf buckets: 21426, nodes: 21155322 
    Average node length: 6.35, total dup: 18510115, max dup: 29 
    Average key length: 2.79, compression ratio: 3.23 
    Average prefix length: 8.34, average data length: 0.66 
    Clustering factor: 3578020, ratio: 0.17 
    Fill distribution: 
         0 - 19% = 4 
        20 - 39% = 0 
        40 - 59% = 8872 
        60 - 79% = 667 
        80 - 99% = 11883 
 
    Index XQS_1000_1200_WORKER_ID (0) 
    Root page: 1413370, depth: 3, leaf buckets: 16045, nodes: 21155322 
    Average node length: 5.56, total dup: 21155222, max dup: 230726 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.42, average data length: 0.00 
    Clustering factor: 945762, ratio: 0.04 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 9 
        40 - 59% = 2795 
        60 - 79% = 349 
        80 - 99% = 12891 
 
XQS_1000_3300 (184) 
    Primary pointer page: 593, Index root page: 594 
    Total formats: 1, used formats: 1 
    Average record length: 81.14, total records: 9411062 
    Average version length: 82.67, total versions: 164075, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.55 
    Pointer pages: 106, data page slots: 172080 
    Data pages: 172024, average fill: 67% 
    Primary pages: 171995, secondary pages: 29, swept pages: 108979 
    Empty pages: 591, full pages: 82484 
    Fill distribution: 
     0 - 19% = 2094 
    20 - 39% = 8754 
    40 - 59% = 28027 
    60 - 79% = 117634 
    80 - 99% = 15515 
 
    Index XQS_1000_3300_DOC_ID (1) 
    Root page: 1367524, depth: 3, leaf buckets: 11357, nodes: 9411062 
    Average node length: 5.37, total dup: 9104287, max dup: 188 
    Average key length: 2.24, compression ratio: 4.02 
    Average prefix length: 8.79, average data length: 0.21 
    Clustering factor: 2144843, ratio: 0.23 
    Fill distribution: 
         0 - 19% = 4 
        20 - 39% = 82 
        40 - 59% = 8934 
        60 - 79% = 2279 
        80 - 99% = 58 
 
    Index XQS_1000_3300_RCV_ID (3) 
    Root page: 1379283, depth: 3, leaf buckets: 13282, nodes: 9411062 
    Average node length: 6.23, total dup: 7799801, max dup: 14 
    Average key length: 3.10, compression ratio: 2.90 
    Average prefix length: 8.07, average data length: 0.93 
    Clustering factor: 1506747, ratio: 0.16 
    Fill distribution: 
         0 - 19% = 119 
        20 - 39% = 3965 
        40 - 59% = 4323 
        60 - 79% = 2575 
        80 - 99% = 2300 
 
    Index XQS_1000_3300_SND_ID (2) 
    Root page: 1373081, depth: 3, leaf buckets: 12674, nodes: 9411062 
    Average node length: 5.98, total dup: 8156477, max dup: 34 
    Average key length: 2.86, compression ratio: 3.15 
    Average prefix length: 8.28, average data length: 0.72 
    Clustering factor: 2323120, ratio: 0.25 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 111 
        40 - 59% = 9879 
        60 - 79% = 2613 
        80 - 99% = 70 
 
    Index XQS_1000_3300_WORKER_ID (0) 
    Root page: 1362789, depth: 3, leaf buckets: 9914, nodes: 9411062 
    Average node length: 5.13, total dup: 9410962, max dup: 158651 
    Average key length: 2.00, compression ratio: 1.20 
    Average prefix length: 2.39, average data length: 0.00 
    Clustering factor: 1533158, ratio: 0.16 
    Fill distribution: 
         0 - 19% = 54 
        20 - 39% = 1320 
        40 - 59% = 4786 
        60 - 79% = 1735 
        80 - 99% = 2019 
 
XQS_1200_2000 (183) 
    Primary pointer page: 591, Index root page: 592 
    Total formats: 1, used formats: 1 
    Average record length: 81.60, total records: 11044736 
    Average version length: 82.54, total versions: 106086, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.54 
    Pointer pages: 119, data page slots: 192720 
    Data pages: 191080, average fill: 71% 
    Primary pages: 190944, secondary pages: 136, swept pages: 81233 
    Empty pages: 2565, full pages: 136650 
    Fill distribution: 
     0 - 19% = 4807 
    20 - 39% = 8497 
    40 - 59% = 20034 
    60 - 79% = 100646 
    80 - 99% = 57096 
 
    Index XQS_1200_2000_DOC_ID (1) 
    Root page: 1392123, depth: 3, leaf buckets: 13127, nodes: 11044736 
    Average node length: 5.31, total dup: 10935088, max dup: 686 
    Average key length: 2.08, compression ratio: 4.32 
    Average prefix length: 8.93, average data length: 0.07 
    Clustering factor: 2313294, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 187 
        40 - 59% = 9680 
        60 - 79% = 3131 
        80 - 99% = 129 
 
    Index XQS_1200_2000_RCV_ID (3) 
    Root page: 1406132, depth: 3, leaf buckets: 10324, nodes: 11044736 
    Average node length: 5.51, total dup: 10562113, max dup: 49 
    Average key length: 2.28, compression ratio: 3.95 
    Average prefix length: 8.77, average data length: 0.23 
    Clustering factor: 711974, ratio: 0.06 
    Fill distribution: 
         0 - 19% = 167 
        20 - 39% = 899 
        40 - 59% = 2547 
        60 - 79% = 1851 
        80 - 99% = 4860 
 
    Index XQS_1200_2000_SND_ID (2) 
    Root page: 1398660, depth: 3, leaf buckets: 15014, nodes: 11044736 
    Average node length: 6.04, total dup: 9629478, max dup: 64 
    Average key length: 2.81, compression ratio: 3.20 
    Average prefix length: 8.32, average data length: 0.68 
    Clustering factor: 2329496, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 4 
        20 - 39% = 236 
        40 - 59% = 11250 
        60 - 79% = 3389 
        80 - 99% = 135 
 
    Index XQS_1200_2000_WORKER_ID (0) 
    Root page: 1386233, depth: 3, leaf buckets: 10602, nodes: 11044736 
    Average node length: 5.23, total dup: 11044636, max dup: 190446 
    Average key length: 2.00, compression ratio: 1.20 
    Average prefix length: 2.39, average data length: 0.00 
    Clustering factor: 701109, ratio: 0.06 
    Fill distribution: 
         0 - 19% = 103 
        20 - 39% = 910 
        40 - 59% = 4628 
        60 - 79% = 1477 
        80 - 99% = 3484 
 
XQS_2000_3300 (185) 
    Primary pointer page: 595, Index root page: 596 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index XQS_2000_3300_DOC_ID (1) 
    Root page: 1361775, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index XQS_2000_3300_RCV_ID (3) 
    Root page: 1361777, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index XQS_2000_3300_SND_ID (2) 
    Root page: 1361776, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index XQS_2000_3300_WORKER_ID (0) 
    Root page: 1361774, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
XQS_2100_3300 (186) 
    Primary pointer page: 597, Index root page: 598 
    Total formats: 1, used formats: 1 
    Average record length: 81.68, total records: 9498581 
    Average version length: 82.97, total versions: 137325, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.54 
    Pointer pages: 108, data page slots: 175968 
    Data pages: 175880, average fill: 67% 
    Primary pages: 175853, secondary pages: 27, swept pages: 121090 
    Empty pages: 594, full pages: 80046 
    Fill distribution: 
     0 - 19% = 2286 
    20 - 39% = 10046 
    40 - 59% = 30702 
    60 - 79% = 118013 
    80 - 99% = 14833 
 
    Index XQS_2100_3300_DOC_ID (1) 
    Root page: 1344708, depth: 3, leaf buckets: 11670, nodes: 9498581 
    Average node length: 5.18, total dup: 9470104, max dup: 1529 
    Average key length: 2.03, compression ratio: 4.43 
    Average prefix length: 8.97, average data length: 0.03 
    Clustering factor: 1935917, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 19 
        20 - 39% = 1700 
        40 - 59% = 7726 
        60 - 79% = 1677 
        80 - 99% = 548 
 
    Index XQS_2100_3300_RCV_ID (3) 
    Root page: 1355739, depth: 3, leaf buckets: 13433, nodes: 9498581 
    Average node length: 6.25, total dup: 7872587, max dup: 14 
    Average key length: 3.10, compression ratio: 2.90 
    Average prefix length: 8.07, average data length: 0.93 
    Clustering factor: 1464531, ratio: 0.15 
    Fill distribution: 
         0 - 19% = 173 
        20 - 39% = 4028 
        40 - 59% = 4313 
        60 - 79% = 2499 
        80 - 99% = 2420 
 
    Index XQS_2100_3300_SND_ID (2) 
    Root page: 1350071, depth: 3, leaf buckets: 12239, nodes: 9498581 
    Average node length: 5.43, total dup: 9069482, max dup: 95 
    Average key length: 2.29, compression ratio: 3.93 
    Average prefix length: 8.76, average data length: 0.24 
    Clustering factor: 2065261, ratio: 0.22 
    Fill distribution: 
         0 - 19% = 40 
        20 - 39% = 1572 
        40 - 59% = 8449 
        60 - 79% = 1620 
        80 - 99% = 558 
 
    Index XQS_2100_3300_WORKER_ID (0) 
    Root page: 987843, depth: 3, leaf buckets: 10034, nodes: 9498581 
    Average node length: 5.15, total dup: 9498481, max dup: 160800 
    Average key length: 2.00, compression ratio: 1.20 
    Average prefix length: 2.39, average data length: 0.00 
    Clustering factor: 1551714, ratio: 0.16 
    Fill distribution: 
         0 - 19% = 53 
        20 - 39% = 1427 
        40 - 59% = 4744 
        60 - 79% = 1783 
        80 - 99% = 2027 
 
XQS_3300_3400 (187) 
    Primary pointer page: 599, Index root page: 600 
    Total formats: 1, used formats: 1 
    Average record length: 67.96, total records: 573834 
    Average version length: 68.91, total versions: 2070, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.85 
    Pointer pages: 5, data page slots: 8088 
    Data pages: 8088, average fill: 74% 
    Primary pages: 8088, secondary pages: 0, swept pages: 4386 
    Empty pages: 6, full pages: 6560 
    Fill distribution: 
     0 - 19% = 6 
    20 - 39% = 12 
    40 - 59% = 163 
    60 - 79% = 7884 
    80 - 99% = 23 
 
    Index XQS_3300_3400_DOC_ID (1) 
    Root page: 42918, depth: 3, leaf buckets: 731, nodes: 573834 
    Average node length: 5.95, total dup: 488546, max dup: 82 
    Average key length: 3.09, compression ratio: 2.91 
    Average prefix length: 8.06, average data length: 0.94 
    Clustering factor: 100857, ratio: 0.18 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 29 
        40 - 59% = 521 
        60 - 79% = 86 
        80 - 99% = 94 
 
    Index XQS_3300_3400_SND_ID (2) 
    Root page: 29708, depth: 3, leaf buckets: 752, nodes: 573834 
    Average node length: 6.15, total dup: 470664, max dup: 14 
    Average key length: 3.29, compression ratio: 2.73 
    Average prefix length: 7.89, average data length: 1.11 
    Clustering factor: 100893, ratio: 0.18 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 30 
        40 - 59% = 530 
        60 - 79% = 82 
        80 - 99% = 110 
 
    Index XQS_3300_3400_WORKER_ID (0) 
    Root page: 377587, depth: 2, leaf buckets: 560, nodes: 573834 
    Average node length: 4.86, total dup: 573734, max dup: 9072 
    Average key length: 2.00, compression ratio: 1.20 
    Average prefix length: 2.41, average data length: 0.00 
    Clustering factor: 89677, ratio: 0.16 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 35 
        40 - 59% = 319 
        60 - 79% = 75 
        80 - 99% = 131 
 
ZDOC_DATA (170) 
    Primary pointer page: 565, Index root page: 566 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
ZDOC_LIST (169) 
    Primary pointer page: 563, Index root page: 564 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
ZINVNT_TURNOVER_LOG (171) 
    Primary pointer page: 567, Index root page: 568 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
ZPDISTR (174) 
    Primary pointer page: 573, Index root page: 574 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index ZPDISTR_ID (0) 
    Root page: 1504230, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
ZPSTORNED (175) 
    Primary pointer page: 575, Index root page: 576 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index ZPSTORNED_ID (0) 
    Root page: 1504229, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
ZQDISTR (172) 
    Primary pointer page: 569, Index root page: 570 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index ZQDISTR_ID (0) 
    Root page: 1504235, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index ZQDISTR_WARE_SNDOP_RCVOP (1) 
    Root page: 1504236, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
ZQSTORNED (173) 
    Primary pointer page: 571, Index root page: 572 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index ZQSTORNED_DOC_ID (1) 
    Root page: 1504232, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index ZQSTORNED_ID (0) 
    Root page: 1504231, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index ZQSTORNED_RCV_ID (3) 
    Root page: 1504234, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index ZQSTORNED_SND_ID (2) 
    Root page: 1504233, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
ZTMP_DEP_DOCS (168) 
    Primary pointer page: 561, Index root page: 562 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
ZTMP_SHOPPING_CART (167) 
    Primary pointer page: 559, Index root page: 560 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
Z_USED_VIEWS (144) 
    Primary pointer page: 512, Index root page: 513 
    Total formats: 1, used formats: 1 
    Average record length: 29.38, total records: 29 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 99.00, compression ratio: 3.37 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 16% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index Z_USED_VIEWS_UNQ (0) 
    Root page: 1510372, depth: 1, leaf buckets: 1, nodes: 29 
    Average node length: 15.17, total dup: 0, max dup: 0 
    Average key length: 14.14, compression ratio: 1.44 
    Average prefix length: 9.17, average data length: 11.17 
    Clustering factor: 1, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
Gstat completion time Tue Mar 12 13:11:01 2024

Record versions statistics, table

TABLE_NAME TOTAL_RECS TOTAL_VERS MAX_VERSIONS VERS_TO_RECS_PRC MAXV_TO_VERS_PRC
DOC_DATA 7714825 36218 1 0.0000 0.0000
DOC_LIST 2227754 17091 2 0.0000 0.0000
FB_ERRORS 2182 757 1 0.0000 0.0000
INVNT_SALDO 400 399 1 0.0000 0.0000
INVNT_TURNOVER_LOG 73249 65827 1 0.0000 0.0000
MONEY_SALDO 49 62 3 100.0000 0.0000
MONEY_TURNOVER_LOG 1281 1188 1 0.0000 0.0000
PDISTR 792396 21208 2 0.0000 0.0000
PERF_SPLIT_0 174752 4400 1 0.0000 0.0000
PERF_SPLIT_1 140396 4231 1 0.0000 0.0000
PERF_SPLIT_2 150814 4203 1 0.0000 0.0000
PERF_SPLIT_3 168592 13598 1 0.0000 0.0000
PERF_SPLIT_4 154712 3493 1 0.0000 0.0000
PERF_SPLIT_5 160830 4130 1 0.0000 0.0000
PERF_SPLIT_6 162498 3214 1 0.0000 0.0000
PERF_SPLIT_7 160692 5248 1 0.0000 0.0000
PERF_SPLIT_8 154391 4885 1 0.0000 0.0000
PERF_SPLIT_9 150464 4761 1 0.0000 0.0000
PSTORNED 2084193 11858 1 0.0000 0.0000
SEMAPHORES 5 1 1 0.0000 100.0000
XQD_1000_1200 118401 50754 1 0.0000 0.0000
XQD_1000_3300 6899068 231196 1 0.0000 0.0000
XQD_1200_2000 11944212 151996 1 0.0000 0.0000
XQD_2000_3300 1204978 205047 1 0.0000 0.0000
XQD_2100_3300 977943 103735 1 0.0000 0.0000
XQD_3300_3400 8945498 154216 1 0.0000 0.0000
XQS_1000_1200 21155322 3652 1 0.0000 0.0000
XQS_1000_3300 9411062 164075 1 0.0000 0.0000
XQS_1200_2000 11044736 106086 1 0.0000 0.0000
XQS_2100_3300 9498581 137325 1 0.0000 0.0000
XQS_3300_3400 573834 2070 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 ---
:20: 
:21: mscs-test-161.budzdorov.ru    Tue Mar 12 13:08:16 2024
:22:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3400
:23: 
--- end of diff output ---

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

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