Generated by /opt/oltp-emul/oltp_isql_run_worker.sh, ISQL session No. 1 of total launched 100. 26.03.2024 10: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 15661340 kB
MemAvailable 30248036 kB
Buffers 0 kB
Cached 16058508 kB
SwapCached 2476 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-26 10:07:52
DTS_END                         2024-03-26 10:07:52.3660
FB_GDSCODE                      -1
FB_MNEMONA                      
STACK                           SP_CLIENT_ORDER(57:5) ==> SP_CHECK_TO_STOP_WORK(32:12) ==> SP_HALT_ON_ERROR(68:17)
IP                              ::1/37898
TRN_ID                          163909
ATT_ID                          552
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: 9114.05 19127 911405
customer order: creation 166.42 432 16642
customer order: refuse 14.25 411 1425
order to supplier: creation 43.54 1375 4354
order to supplier: removal 3.36 100463 336
invoice (draft): creation 44.68 3151 4468
invoice (draft): removal 53.22 806 5322
invoice accept: apply 38.92 22511 3892
invoice accept: cancel 47.98 836 4798
customer reserve: creation 3740.77 218 374077
customer reserve: removal 4670.49 57 467049
realization accept: apply 79.59 215 7959
realization accept: cancel 86.64 132 8664
payment from customer: creation 58.58 124 5858
payment from customer: removal 5.06 110 506
payment to supplier: creation 47.06 156 4706
payment to supplier: removal 3.26 78 326
service: total inventory turnovers 3.49 4270 349
service: total monetary turnovers 5.80 532 580
service: aggregate perf. data 0.90 14890 90
service: refresh index statistics 0.04 231769 4

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:02, from 26-03-2024 10:09:22 to 26-03-2024 10:09:24.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 4895
TEST_TIME 2 5949
TEST_TIME 3 4753
TEST_TIME 4 5539
TEST_TIME 5 6604
TEST_TIME 6 6144
TEST_TIME 7 6059
TEST_TIME 8 6600
TEST_TIME 9 6344
TEST_TIME 10 6046
TEST_TIME 11 6012
TEST_TIME 12 5919
TEST_TIME 13 6170
TEST_TIME 14 6461
TEST_TIME 15 6507
TEST_TIME 16 7051
TEST_TIME 17 6989
TEST_TIME 18 7488
TEST_TIME 19 7247
TEST_TIME 20 7271
TEST_TIME 21 7377
TEST_TIME 22 7734
TEST_TIME 23 7700
TEST_TIME 24 8217
TEST_TIME 25 8962
TEST_TIME 26 9358
TEST_TIME 27 9139
TEST_TIME 28 9019
TEST_TIME 29 8750
TEST_TIME 30 8568
TEST_TIME 31 8798
TEST_TIME 32 8774
TEST_TIME 33 8769
TEST_TIME 34 8652
TEST_TIME 35 8598
TEST_TIME 36 8544
TEST_TIME 37 8415
TEST_TIME 38 8332
TEST_TIME 39 8454
TEST_TIME 40 8696
TEST_TIME 41 8686
TEST_TIME 42 8605
TEST_TIME 43 8726
TEST_TIME 44 9023
TEST_TIME 45 9060
TEST_TIME 46 8977
TEST_TIME 47 9059
TEST_TIME 48 9202
TEST_TIME 49 9303
TEST_TIME 50 9244
TEST_TIME 51 9168
TEST_TIME 52 9057
TEST_TIME 53 8984
TEST_TIME 54 8968
TEST_TIME 55 9055
TEST_TIME 56 8985
TEST_TIME 57 8947
TEST_TIME 58 8976
TEST_TIME 59 8903
TEST_TIME 60 8830
TEST_TIME 61 8827
TEST_TIME 62 8806
TEST_TIME 63 8855
TEST_TIME 64 8900
TEST_TIME 65 8982
TEST_TIME 66 9084
TEST_TIME 67 9099
TEST_TIME 68 9085
TEST_TIME 69 9157
TEST_TIME 70 9216
TEST_TIME 71 9267
TEST_TIME 72 9259
TEST_TIME 73 9177
TEST_TIME 74 9129
TEST_TIME 75 9112
TEST_TIME 76 9084
TEST_TIME 77 9025
TEST_TIME 78 9046
TEST_TIME 79 9015
TEST_TIME 80 9033
TEST_TIME 81 9006
TEST_TIME 82 9127
TEST_TIME 83 9238
TEST_TIME 84 9200
TEST_TIME 85 9196
TEST_TIME 86 9257
TEST_TIME 87 9312
TEST_TIME 88 9306
TEST_TIME 89 9393
TEST_TIME 90 9363
TEST_TIME 91 9299
TEST_TIME 92 9223
TEST_TIME 93 9248
TEST_TIME 94 9220
TEST_TIME 95 9186
TEST_TIME 96 9232
TEST_TIME 97 9203
TEST_TIME 98 9143
TEST_TIME 99 9097
TEST_TIME 100 9120

Performance per minute, chart


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

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 1254284 1254284 0 0.00 0 36356 8 0 0
doc_list_biud 1254284 1254284 0 0.00 0 53301 27 0 0
sp_add_invoice_to_stock 4014 3892 122 3.03 25 214980 22511 0 122
sp_cancel_adding_invoice 4798 4798 0 0.00 3 54907 837 0 0
sp_cancel_client_order 1425 1425 0 0.00 4 14934 411 0 0
sp_cancel_customer_reserve 467049 467049 0 0.00 0 53302 58 0 0
sp_cancel_pay_from_customer 506 506 0 0.00 2 6805 111 0 0
sp_cancel_pay_to_supplier 326 326 0 0.00 3 4982 79 0 0
sp_cancel_supplier_invoice 5338 5322 16 0.29 1 24007 806 0 16
sp_cancel_supplier_order 336 336 0 0.00 11 821979 100463 0 0
sp_cancel_write_off 8664 8664 0 0.00 1 13935 133 0 0
sp_client_order 16642 16642 0 0.00 3 24487 432 0 0
sp_customer_reserve 374077 374077 0 0.00 0 58206 219 0 0
sp_fill_shopping_cart 25444 25444 0 0.00 1 16624 37 0 0
sp_fill_shopping_cart_clo_res 374068 374068 0 0.00 0 16586 18 0 0
sp_get_clo_for_invoice 3883 3883 0 0.00 0 38156 368 0 0
sp_kill_cost_storno 14294 14294 0 0.00 0 22526 71 0 0
sp_kill_qstorno_ret_qs2qd 948420 948420 0 0.00 0 53299 32 0 0
sp_kill_qty_storno 499436 499436 0 0.00 0 53301 68 0 0
sp_lock_selected_doc 16424 16424 0 0.00 0 6620 4 0 0
sp_make_cost_storno 22406 22406 0 0.00 0 13867 67 0 0
sp_multiply_rows_for_pdistr 22406 22406 0 0.00 0 13802 38 0 0
sp_multiply_rows_for_qdistr 16642 16642 0 0.00 0 24480 234 0 0
sp_pay_from_customer 5858 5858 0 0.00 4 14167 124 0 0
sp_pay_to_supplier 4706 4706 0 0.00 4 15660 157 0 0
sp_payment_common 10564 10564 0 0.00 1 13637 32 0 0
sp_qd_handle_on_cancel_clo 1425 1425 0 0.00 0 14925 384 0 0
sp_qd_handle_on_invoice_upd_sts 8681 8681 0 0.00 0 36376 311 0 0
sp_qd_handle_on_reserve_upd_sts 7959 7959 0 0.00 0 23387 68 0 0
sp_reserve_write_off 7959 7959 0 0.00 7 23413 215 0 0
sp_supplier_invoice 4468 4468 0 0.00 6 76305 3151 0 0
sp_supplier_order 4354 4354 0 0.00 5 33702 1375 0 0
srv_aggregate_perf_data 90 90 0 0.00 1905 125235 14891 0 0
srv_fill_mon_cache_memory 56 56 0 0.00 1140 121580 39532 0 0
srv_find_qd_qs_mism 871176 871176 0 0.00 0 36355 7 0 0
srv_make_invnt_saldo 349 349 0 0.00 38 81724 4271 0 0
srv_make_money_saldo 580 580 0 0.00 1 20322 533 0 0
srv_recalc_idx_stat 4 4 0 0.00 145451 311733 231770 0 0
t$perf-abend:sp_add_invoice_to_stock 122 122 0 0.00 0 0 0 0 0
t$perf-abend:sp_cancel_supplier_invoice 16 16 0 0.00 0 0 0 0 0
t$perf-norm:sp_add_invoice_to_stock 3892 3892 0 0.00 0 20949 180 0 0
t$perf-norm:sp_cancel_adding_invoice 325 325 0 0.00 0 13376 145 0 0
t$perf-norm:sp_cancel_client_order 1425 1425 0 0.00 0 1347 9 0 0
t$perf-norm:sp_cancel_customer_reserve 550 550 0 0.00 0 2024 13 0 0
t$perf-norm:sp_cancel_pay_from_customer 506 506 0 0.00 0 1178 5 0 0
t$perf-norm:sp_cancel_pay_to_supplier 326 326 0 0.00 0 423 3 0 0
t$perf-norm:sp_cancel_supplier_invoice 327 327 0 0.00 0 2245 14 0 0
t$perf-norm:sp_cancel_supplier_order 336 336 0 0.00 0 14171 1619 0 0
t$perf-norm:sp_cancel_write_off 787 787 0 0.00 0 2703 7 0 0
t$perf-norm:sp_client_order 16642 16642 0 0.00 0 19051 17 0 0
t$perf-norm:sp_customer_reserve 817 817 0 0.00 0 5453 19 0 0
t$perf-norm:sp_pay_from_customer 5858 5858 0 0.00 0 3754 5 0 0
t$perf-norm:sp_pay_to_supplier 4706 4706 0 0.00 0 6690 9 0 0
t$perf-norm:sp_reserve_write_off 7959 7959 0 0.00 0 6563 8 0 0
t$perf-norm:sp_supplier_invoice 4468 4468 0 0.00 0 22053 17 0 0
t$perf-norm:sp_supplier_order 4354 4354 0 0.00 0 5643 14 0 0
t$perf-norm:srv_aggregate_perf_data 90 90 0 0.00 0 149 4 0 0
t$perf-norm:srv_fill_mon_cache_memory 56 56 0 0.00 0 5241 94 0 0
t$perf-norm:srv_make_invnt_saldo 349 349 0 0.00 0 374 7 0 0
t$perf-norm:srv_make_money_saldo 580 580 0 0.00 0 1377 10 0 0
t$perf-norm:srv_recalc_idx_stat 4 4 0 0.00 2 23 10 0 0
v_add_invoice_to_stock 8010 7766 244 3.04 0 4301 16 0 244
v_all_customers 31310 31310 0 0.00 0 17 1 0 0
v_all_suppliers 24962 24962 0 0.00 0 127 1 0 0
v_all_wares 33284 33284 0 0.00 0 31 1 0 0
v_cancel_adding_invoice 650 650 0 0.00 0 2772 11 0 0
v_cancel_client_order 2850 2850 0 0.00 0 2647 6 0 0
v_cancel_customer_prepayment 1012 1012 0 0.00 0 1795 9 0 0
v_cancel_customer_reserve 1100 1100 0 0.00 0 1673 8 0 0
v_cancel_payment_to_supplier 652 652 0 0.00 0 2395 6 0 0
v_cancel_supplier_invoice 686 654 32 4.66 0 2891 25 0 32
v_cancel_supplier_order 672 672 0 0.00 0 1184 7 0 0
v_cancel_write_off 1574 1574 0 0.00 0 2248 16 0 0
v_max_id_clo_ord 4343 4343 0 0.00 0 769 2 0 0
v_max_id_clo_res 817 817 0 0.00 0 2871 14 0 0
v_max_id_ord_sup 4459 4459 0 0.00 0 3926 2 0 0
v_max_non_paid_invoice 1027 1027 0 0.00 0 771 3 0 0
v_max_non_paid_realizn 2723 2723 0 0.00 0 6654 6 0 0
v_min_id_clo_ord 4343 4343 0 0.00 0 5256 14 0 0
v_min_id_clo_res 817 817 0 0.00 0 2870 10 0 0
v_min_id_ord_sup 4459 4459 0 0.00 0 7410 9 0 0
v_min_non_paid_invoice 4706 4706 0 0.00 0 7812 24 0 0
v_min_non_paid_realizn 5858 5858 0 0.00 0 12510 25 0 0
v_our_firm 8244 8244 0 0.00 0 32 1 0 0
v_reserve_write_off 15918 15918 0 0.00 0 4302 5 0 0
x_lock_depdocs_on_canc_invoice 9793 9793 0 0.00 0 11227 99 0 0
x_lock_depdocs_on_canc_sup_ord 336 336 0 0.00 0 23919 410 0 0
x_make_qstorno_1000_1200 4354 4354 0 0.00 1 33684 1294 0 0
x_make_qstorno_1200_2000 4468 4468 0 0.00 3 76105 3022 0 0
x_make_qstorno_2100_3300 374077 374077 0 0.00 0 58202 198 0 0

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

Memory consumption, metadata cache, attachments activity 

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


Page cache type: shared, buffers: 1000000 for all connections, with total size: 8192000000
measurement_dts measurement duration ms page cache memo used memo used, total memo allocated, total metadata cache metadata cache percent of total total attachments cnt active attachments cnt running statements cnt stalled statements cnt memo used by attachments memo used by transactions memo used by statements
08:07:56 18 8192000000 8808968112 8823894016 10782480 0.131 5 2 2 0 10993424 148912 62032
08:08:57 33703 8192000000 9729354272 10034073600 802147664 8.918 100 86 172 0 829549008 7628112 19773232
08:10:43 16719 8192000000 9768763680 10080161792 841736128 9.317 100 94 188 0 876328704 12819088 21773488
08:12:12 13588 8192000000 9800499456 10120642560 869170480 9.592 100 84 168 0 906145792 18568336 18406976
08:13:32 8284 8192000000 9844358864 10178818048 903414944 9.932 100 79 158 0 954062288 34011808 16635536
08:14:41 9848 8192000000 9910936832 10256785408 943940096 10.332 100 74 148 0 1023165664 64403024 14822544
08:15:54 4580 8192000000 9951382528 10303680512 968408160 10.571 100 84 164 0 1068993136 83861168 16723808
08:17:03 2975 8192000000 9962132944 10325229568 997167024 10.851 100 79 158 0 1076248784 63677600 15404160
08:18:08 1888 8192000000 9993895392 10362527744 1026283408 11.133 100 78 155 0 1102480640 61535856 14661376
08:19:12 1271 8192000000 10033901968 10405076992 1045919440 11.322 100 84 165 1 1145001088 82404048 16677600
08:20:14 30611 8192000000 10004046032 10392432640 1056833200 11.426 100 64 127 3 1125932864 56368016 12731648
08:21:48 7293 8192000000 9984949408 10379804672 1066627520 11.520 100 47 92 0 1111216368 34741712 9847136
08:22:56 5901 8192000000 9990005696 10394075136 1074647040 11.596 100 46 90 0 1116697280 32998736 9051504
08:24:03 4466 8192000000 9999801680 10394689536 1084664240 11.692 100 47 94 0 1114694176 20402864 9627072
08:25:09 51957 8192000000 10010484176 10411536384 1088666832 11.730 100 51 100 0 1115563344 15897792 10998720
08:27:01 3488 8192000000 10002849520 10404384768 1090096000 11.744 100 50 101 2 1114758784 13943728 10719056
08:28:12 20535 8192000000 10012045904 10417762304 1101487024 11.852 100 41 80 0 1126688128 17133728 8067376
08:29:41 3928 8192000000 10095161872 10501156864 1112372256 11.955 100 65 128 0 1206827648 81215472 13239920
08:30:47 51629 8192000000 10086925680 10496561152 1107099552 11.905 99 45 90 0 1201993040 86485552 8407936
08:32:41 9216 8192000000 10113646192 10519887872 1115365136 11.983 100 51 102 1 1220637792 95371200 9901456
08:33:56 38773 8192000000 10084903440 10493911040 1096342304 11.803 98 40 80 0 1173554304 69139808 8072192
08:35:37 15390 8192000000 10061773072 10461052928 1095746640 11.797 99 41 80 1 1163803008 59738928 8317440
08:36:55 24813 8192000000 10097099472 10494889984 1078924096 11.637 97 49 96 0 1188528112 99906064 9697952
08:38:28 20783 8192000000 10134582752 10540453888 1098025904 11.819 99 45 90 0 1244337408 137076848 9234656
08:39:54 8277 8192000000 10141844640 10540699648 1097742592 11.816 100 48 96 0 1253351696 145426624 10182480
08:41:05 13484 8192000000 10107538016 10512625664 1072652224 11.577 98 39 78 0 1220370784 138929440 8789120
08:42:22 5660 8192000000 10153116288 10536955904 1076449824 11.614 98 77 150 0 1240500624 148370176 15680624
08:43:31 1137 8192000000 10204631360 10611023872 1112314336 11.954 100 79 156 0 1305838272 176526112 16997824
08:44:37 1945 8192000000 10195992128 10585767936 1108651248 11.920 99 70 140 0 1303238560 179591952 14995360
08:45:46 9672 8192000000 10251337376 10668838912 1135023408 12.169 100 49 97 1 1358049472 212279648 10746416
08:47:00 8929 8192000000 10261955728 10664718336 1130291264 12.124 100 64 127 1 1364483936 220213312 13979360
08:48:22 28769 8192000000 10309714736 10746490880 1132394352 12.144 100 38 76 1 1434542144 292608720 9539072
08:50:02 24767 8192000000 10277956416 10720608256 1135628512 12.174 100 21 42 0 1374102400 233554384 4919504
08:51:29 7880 8192000000 10271519936 10733694976 1120455440 12.031 100 27 52 1 1372984064 245603824 6924800
08:52:41 21285 8192000000 10131582032 10566733824 1124698208 12.071 100 16 32 1 1224188656 96175888 3314560
08:54:09 13984 8192000000 10058371600 10486157312 1125182704 12.076 100 21 44 0 1160216176 29793200 5240272
08:55:27 78357 8192000000 10105560400 10545479680 1137566656 12.193 100 21 42 0 1218268048 76516864 4184528
08:58:07 21941 8192000000 10084295296 10540154880 1136290832 12.181 100 26 52 0 1206774368 65335920 5147616
08:59:33 3200 8192000000 10090570960 10510417920 1140221248 12.218 100 59 114 1 1186528176 32690704 13616224
09:00:40 39654 8192000000 10080531840 10532818944 1139886400 12.214 100 36 70 0 1204919200 57803712 7229088
09:02:41 39018 8192000000 10137561488 10593452032 1142591088 12.240 99 18 36 0 1219648784 72781504 4276192
09:04:29 58136 8192000000 10173601728 10628296704 1154730144 12.354 100 26 52 0 1263148144 102721168 5696832
09:07:33 48565 8192000000 10131220944 10587983872 1134924688 12.168 98 20 40 0 1212289248 73016544 4348016
09:10:31 44881 8192000000 10090553728 10582704128 1147073824 12.282 100 16 32 0 1208463776 57670192 3719760
09:12:19 29813 8192000000 10116589104 10581639168 1133707632 12.156 98 27 54 1 1187192304 48309088 5175584
09:14:08 30032 8192000000 10103632432 10568110080 1126264800 12.086 98 27 54 0 1169941568 38976976 4699792
09:15:39 112007 8192000000 10082732928 10560122880 1090331840 11.746 95 7 14 0 1134997952 43532272 1133840
09:18:32 87874 8192000000 10114340944 10560724992 1126432768 12.088 99 37 74 0 1201439680 67384048 7622864
09:21:07 26112 8192000000 10100898816 10557792256 1101009840 11.847 98 29 58 1 1201681264 94042560 6628864
09:22:42 48284 8192000000 10074959552 10543382528 1100779840 11.845 99 27 54 0 1183240128 77180688 5279600
09:24:41 33417 8192000000 10058621216 10515046400 1077447920 11.623 97 12 24 1 1141138496 61379392 2311184
09:26:19 22197 8192000000 10044501024 10488717312 1090695888 11.749 99 21 42 0 1135261120 40252512 4312720
09:27:43 55611 8192000000 10031016032 10494328832 1079545936 11.643 98 14 28 0 1124772080 42612032 2614112
09:29:43 38649 8192000000 10070374224 10518716416 1067773872 11.531 97 25 50 0 1160185664 87288544 5123248
09:31:33 72234 8192000000 10059133104 10517983232 1062608656 11.481 97 13 26 0 1163027312 97540640 2878016
09:33:48 41037 8192000000 10031865760 10442989568 1060836448 11.464 98 16 32 0 1081809024 18175792 2796784
09:35:30 16715 8192000000 10031670336 10437808128 1059498496 11.452 98 48 96 0 1118928480 50369040 9060944
09:36:53 81137 8192000000 10057726560 10512138240 1058396384 11.441 97 23 46 0 1128458080 65552144 4509552
09:39:20 50676 8192000000 10062469296 10513649664 1079051840 11.638 99 51 97 0 1160177232 71385312 9740080
09:41:22 45043 8192000000 10033573984 10457571328 1097630096 11.815 100 29 56 0 1138030464 35048128 5352240
09:43:10 39308 8192000000 10072333200 10524372992 1116938544 11.998 100 16 32 0 1192856384 72665968 3251872
09:44:51 58396 8192000000 10056510576 10537398272 1114041408 11.971 99 11 20 0 1178453712 62501200 1911104
09:46:50 42152 8192000000 10117524752 10569875456 1135367456 12.172 100 34 68 0 1218228352 75435312 7425584
09:48:33 20334 8192000000 10172728400 10606292992 1146502080 12.277 100 39 78 0 1264673984 109662768 8509136
09:50:15 90534 8192000000 10087942208 10514583552 1120606784 12.033 99 17 34 0 1186355632 62546064 3202784
09:52:48 46473 8192000000 10129496400 10618466304 1124409152 12.069 99 32 64 0 1243450112 112489056 6551904
09:54:38 121580 8192000000 10070994096 10564079616 1132270000 12.143 100 21 40 0 1184294688 48452896 3571792
09:57:40 28730 8192000000 10083693296 10508673024 1140134016 12.217 100 47 93 0 1175980240 25954944 9891280
09:59:24 65548 8192000000 10105558992 10571972608 1132558320 12.145 99 23 46 1 1225884048 88276848 5048880
10:01:41 95926 8192000000 10133479296 10598162432 1147598304 12.287 100 14 28 0 1224572368 73297664 3676400
10:04:19 79636 8192000000 10064640112 10531958784 1098985104 11.828 96 14 27 0 1135243664 33656128 2602432
10:06:39 69602 8192000000 10073607920 10588364800 1109603920 11.929 98 9 18 0 1149145168 37686656 1854592

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:14, from 26-03-2024 10:09:36 to 26-03-2024 10:09:50.

Exceptions occured during test was in run

FB_MNEMONA CNT UNIT FB_GDSCODE
except 122 v_add_invoice_to_stock 335544517
except 16 v_cancel_supplier_invoice 335544517

Completed "Exceptions occured during test was in run". Done for 00:00:02, from 26-03-2024 10:09:51 to 26-03-2024 10:09:53.

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          164178
MON$OLDEST_ACTIVE               164179
MON$OLDEST_SNAPSHOT             164179
MON$NEXT_TRANSACTION            164179
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                       1915744
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             671
MON$NEXT_STATEMENT              53
MON$REPLICA_MODE                0


ISQL Version: LI-V4.0.5.3082 Firebird 4.0
Server version:
Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V4.0.5.3082 Firebird 4.0"
Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-V4.0.5.3082 Firebird 4.0/tcp (mscs-test-161.budzdorov.ru)/P17:C"
Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-V4.0.5.3082 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 26 10:09:54 2024 
 
Database header page information: 
    Flags            0 
    Generation        85866 
    System Change Number    0 
    Page size        8192 
    ODS version        13.0 
    Oldest transaction    164178 
    Oldest active        164179 
    Oldest snapshot        164179 
    Next transaction    164180 
    Sequence number        0 
    Next attachment ID    671 
    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.51, total records: 7609188 
    Average version length: 48.15, total versions: 73877, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 64.00, compression ratio: 1.35 
    Pointer pages: 55, data page slots: 88232 
    Data pages: 88232, average fill: 69% 
    Primary pages: 88231, secondary pages: 1, swept pages: 41467 
    Empty pages: 8, full pages: 62269 
    Fill distribution: 
     0 - 19% = 20 
    20 - 39% = 122 
    40 - 59% = 3829 
    60 - 79% = 84207 
    80 - 99% = 54 
 
    Index DOC_DATA_DOC_WARE_UNQ (0) 
    Root page: 1510636, depth: 3, leaf buckets: 22818, nodes: 7609188 
    Average node length: 18.83, total dup: 0, max dup: 0 
    Average key length: 15.84, compression ratio: 1.70 
    Average prefix length: 14.16, average data length: 12.84 
    Clustering factor: 1638001, ratio: 0.22 
    Fill distribution: 
         0 - 19% = 279 
        20 - 39% = 2042 
        40 - 59% = 3702 
        60 - 79% = 2584 
        80 - 99% = 14211 
 
    Index DOC_DATA_ID_DESC (1) 
    Root page: 1528140, depth: 3, leaf buckets: 13288, nodes: 7609188 
    Average node length: 11.20, total dup: 0, max dup: 0 
    Average key length: 8.22, compression ratio: 1.10 
    Average prefix length: 3.78, average data length: 5.22 
    Clustering factor: 1462666, ratio: 0.19 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 1678 
        40 - 59% = 1798 
        60 - 79% = 1225 
        80 - 99% = 8587 
 
    Index FK_DOC_DATA_DOC_LIST (2) 
    Root page: 1546735, depth: 3, leaf buckets: 8171, nodes: 7609188 
    Average node length: 6.59, total dup: 5731532, max dup: 49 
    Average key length: 3.60, compression ratio: 2.50 
    Average prefix length: 7.65, average data length: 1.35 
    Clustering factor: 1455730, ratio: 0.19 
    Fill distribution: 
         0 - 19% = 112 
        20 - 39% = 1057 
        40 - 59% = 1198 
        60 - 79% = 1025 
        80 - 99% = 4779 
 
DOC_LIST (138) 
    Primary pointer page: 500, Index root page: 501 
    Total formats: 1, used formats: 1 
    Average record length: 56.55, total records: 2167745 
    Average version length: 58.91, total versions: 37411, max versions: 2 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 84.00, compression ratio: 1.49 
    Pointer pages: 18, data page slots: 28480 
    Data pages: 28480, average fill: 70% 
    Primary pages: 28478, secondary pages: 2, swept pages: 12915 
    Empty pages: 7, full pages: 15138 
    Fill distribution: 
     0 - 19% = 21 
    20 - 39% = 97 
    40 - 59% = 1897 
    60 - 79% = 26407 
    80 - 99% = 58 
 
    Index DOC_LIST_ID_DESC (1) 
    Root page: 1541152, depth: 3, leaf buckets: 4422, nodes: 2167745 
    Average node length: 11.42, total dup: 0, max dup: 0 
    Average key length: 8.46, compression ratio: 1.06 
    Average prefix length: 3.54, average data length: 5.46 
    Clustering factor: 666313, ratio: 0.31 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 926 
        40 - 59% = 763 
        60 - 79% = 800 
        80 - 99% = 1933 
 
    Index DOC_LIST_WORKER_OPTYPE (2) 
    Root page: 1544398, depth: 3, leaf buckets: 2413, nodes: 2168489 
    Average node length: 4.97, total dup: 2167590, max dup: 17823 
    Average key length: 2.01, compression ratio: 4.47 
    Average prefix length: 8.99, average data length: 0.01 
    Clustering factor: 1236632, ratio: 0.57 
    Fill distribution: 
         0 - 19% = 3 
        20 - 39% = 276 
        40 - 59% = 1422 
        60 - 79% = 491 
        80 - 99% = 221 
 
    Index FK_DOC_LIST_AGENTS (3) 
    Root page: 1545933, depth: 3, leaf buckets: 1765, nodes: 2167745 
    Average node length: 4.97, total dup: 2167695, max dup: 129914 
    Average key length: 2.01, compression ratio: 4.48 
    Average prefix length: 8.99, average data length: 0.01 
    Clustering factor: 1043809, ratio: 0.48 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 9 
        40 - 59% = 615 
        60 - 79% = 55 
        80 - 99% = 1084 
 
    Index PK_DOC_LIST (0) 
    Root page: 1538209, depth: 3, leaf buckets: 4219, nodes: 2167745 
    Average node length: 11.42, total dup: 0, max dup: 0 
    Average key length: 8.46, compression ratio: 1.06 
    Average prefix length: 3.54, average data length: 5.46 
    Clustering factor: 666313, ratio: 0.31 
    Fill distribution: 
         0 - 19% = 81 
        20 - 39% = 589 
        40 - 59% = 588 
        60 - 79% = 879 
        80 - 99% = 2082 
 
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.31, total records: 400 
    Average version length: 24.89, total versions: 1240, max versions: 4 
    Average fragment length: 2.00, total fragments: 2, max fragments: 1 
    Average unpacked length: 104.00, compression ratio: 1.25 
    Pointer pages: 1, data page slots: 32 
    Data pages: 32, average fill: 36% 
    Primary pages: 13, secondary pages: 19, swept pages: 0 
    Empty pages: 11, full pages: 8 
    Fill distribution: 
     0 - 19% = 20 
    20 - 39% = 0 
    40 - 59% = 1 
    60 - 79% = 2 
    80 - 99% = 9 
 
    Index PK_INVNT_SALDO (0) 
    Root page: 1510371, depth: 1, leaf buckets: 1, nodes: 400 
    Average node length: 11.22, total dup: 0, max dup: 0 
    Average key length: 10.22, compression ratio: 0.88 
    Average prefix length: 1.78, average data length: 7.22 
    Clustering factor: 326, ratio: 0.81 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 0 
        40 - 59% = 1 
        60 - 79% = 0 
        80 - 99% = 0 
 
INVNT_TURNOVER_LOG (153) 
    Primary pointer page: 530, Index root page: 531 
    Total formats: 1, used formats: 1 
    Average record length: 20.43, total records: 139169 
    Average version length: 68.30, total versions: 112352, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 88.00, compression ratio: 4.31 
    Pointer pages: 6, data page slots: 3336 
    Data pages: 2168, average fill: 84% 
    Primary pages: 2167, secondary pages: 1, swept pages: 16 
    Empty pages: 47, full pages: 1930 
    Fill distribution: 
     0 - 19% = 59 
    20 - 39% = 48 
    40 - 59% = 62 
    60 - 79% = 375 
    80 - 99% = 1624 
 
    Index INVNT_TURNOVER_LOG_WARE_DD_ID (0) 
    Root page: 1705652, depth: 3, leaf buckets: 405, nodes: 139169 
    Average node length: 13.39, total dup: 12245, max dup: 2 
    Average key length: 10.51, compression ratio: 2.57 
    Average prefix length: 19.39, average data length: 7.61 
    Clustering factor: 100600, ratio: 0.72 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 9 
        40 - 59% = 256 
        60 - 79% = 130 
        80 - 99% = 8 
 
MONEY_SALDO (141) 
    Primary pointer page: 506, Index root page: 507 
    Total formats: 1, used formats: 1 
    Average record length: 15.24, total records: 49 
    Average version length: 9.00, total versions: 168, max versions: 5 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 32.00, compression ratio: 2.10 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 73% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 1 
    80 - 99% = 0 
 
    Index PK_MONEY_SALDO (0) 
    Root page: 1510383, depth: 1, leaf buckets: 1, nodes: 49 
    Average node length: 11.82, total dup: 0, max dup: 0 
    Average key length: 10.80, compression ratio: 0.83 
    Average prefix length: 1.18, average data length: 7.82 
    Clustering factor: 1, ratio: 0.02 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
MONEY_TURNOVER_LOG (140) 
    Primary pointer page: 504, Index root page: 505 
    Total formats: 1, used formats: 1 
    Average record length: 14.52, total records: 2309 
    Average version length: 43.95, total versions: 1955, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 58.00, compression ratio: 3.99 
    Pointer pages: 1, data page slots: 40 
    Data pages: 40, average fill: 59% 
    Primary pages: 39, secondary pages: 1, swept pages: 11 
    Empty pages: 11, full pages: 25 
    Fill distribution: 
     0 - 19% = 14 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 3 
    80 - 99% = 23 
 
    Index MONEY_TURNOVER_LOG_AGENT_OPTYPE (0) 
    Root page: 90596, depth: 2, leaf buckets: 3, nodes: 2309 
    Average node length: 4.17, total dup: 2211, max dup: 260 
    Average key length: 2.46, compression ratio: 7.73 
    Average prefix length: 18.58, average data length: 0.42 
    Clustering factor: 1137, ratio: 0.49 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 2 
        40 - 59% = 1 
        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.53, total records: 72 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 112.00, compression ratio: 1.15 
    Pointer pages: 1, data page slots: 2 
    Data pages: 2, average fill: 50% 
    Primary pages: 2, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 1 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 1 
    40 - 59% = 0 
    60 - 79% = 1 
    80 - 99% = 0 
 
    Index PK_MON_CACHE_MEMORY (0) 
    Root page: 1504238, depth: 1, leaf buckets: 1, nodes: 72 
    Average node length: 11.69, total dup: 0, max dup: 0 
    Average key length: 10.68, compression ratio: 0.84 
    Average prefix length: 1.31, average data length: 7.69 
    Clustering factor: 2, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
MON_LOG (162) 
    Primary pointer page: 548, Index root page: 549 
    Total formats: 2, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index MON_LOG_DTS (4) 
    Root page: 1504251, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index MON_LOG_GDSCODE (2) 
    Root page: 1504249, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index MON_LOG_ROWSET_DESC (1) 
    Root page: 1504248, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index MON_LOG_UNIT (3) 
    Root page: 1504250, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PK_MON_LOG (0) 
    Root page: 1504247, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
MON_LOG_TABLE_STATS (163) 
    Primary pointer page: 550, Index root page: 551 
    Total formats: 2, used formats: 1 
    Average record length: 67.13, total records: 30 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 611.00, compression ratio: 9.10 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 31% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 1 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index MON_LOG_TABLE_STATS_DTS (4) 
    Root page: 1504246, depth: 1, leaf buckets: 1, nodes: 30 
    Average node length: 3.50, total dup: 23, max dup: 4 
    Average key length: 2.47, compression ratio: 3.24 
    Average prefix length: 7.53, average data length: 0.47 
    Clustering factor: 1, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index MON_LOG_TABLE_STATS_GDSCODE (2) 
    Root page: 1504244, depth: 1, leaf buckets: 1, nodes: 30 
    Average node length: 2.00, total dup: 29, max dup: 29 
    Average key length: 1.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 1, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index MON_LOG_TABLE_STATS_ROWSET (1) 
    Root page: 1504243, depth: 1, leaf buckets: 1, nodes: 30 
    Average node length: 3.33, total dup: 29, max dup: 29 
    Average key length: 2.30, compression ratio: 3.91 
    Average prefix length: 8.70, average data length: 0.30 
    Clustering factor: 1, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index MON_LOG_TABLE_STATS_TN_UNIT (3) 
    Root page: 1504245, depth: 1, leaf buckets: 1, nodes: 30 
    Average node length: 12.90, total dup: 0, max dup: 0 
    Average key length: 11.87, compression ratio: 1.42 
    Average prefix length: 7.63, average data length: 9.20 
    Clustering factor: 1, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PK_MON_LOG_TABLE_STATS (0) 
    Root page: 1504242, depth: 1, leaf buckets: 1, nodes: 30 
    Average node length: 8.37, total dup: 0, max dup: 0 
    Average key length: 7.33, compression ratio: 1.23 
    Average prefix length: 4.63, average data length: 4.37 
    Clustering factor: 1, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
OPTYPES (136) 
    Primary pointer page: 496, Index root page: 497 
    Total formats: 2, used formats: 1 
    Average record length: 67.56, total records: 9 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 386.00, compression ratio: 5.71 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 9% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index OPTYPES_MCODE_UNQ (1) 
    Root page: 1544827, depth: 1, leaf buckets: 1, nodes: 9 
    Average node length: 8.56, total dup: 0, max dup: 0 
    Average key length: 6.89, compression ratio: 0.73 
    Average prefix length: 0.44, average data length: 4.56 
    Clustering factor: 1, ratio: 0.11 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PK_OPTYPES (0) 
    Root page: 1544826, depth: 1, leaf buckets: 1, nodes: 9 
    Average node length: 6.11, total dup: 0, max dup: 0 
    Average key length: 5.00, compression ratio: 0.60 
    Average prefix length: 0.89, average data length: 2.11 
    Clustering factor: 1, ratio: 0.11 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
PDISTR (146) 
    Primary pointer page: 516, Index root page: 517 
    Total formats: 1, used formats: 1 
    Average record length: 36.98, total records: 869551 
    Average version length: 37.88, total versions: 18272, max versions: 2 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 54.00, compression ratio: 1.46 
    Pointer pages: 6, data page slots: 9008 
    Data pages: 9008, average fill: 66% 
    Primary pages: 9007, secondary pages: 1, swept pages: 2382 
    Empty pages: 8, full pages: 8095 
    Fill distribution: 
     0 - 19% = 15 
    20 - 39% = 26 
    40 - 59% = 185 
    60 - 79% = 8736 
    80 - 99% = 46 
 
    Index PDISTR_AGENT_ID (2) 
    Root page: 1509330, depth: 2, leaf buckets: 915, nodes: 861070 
    Average node length: 4.89, total dup: 861021, max dup: 172177 
    Average key length: 2.01, compression ratio: 4.48 
    Average prefix length: 8.99, average data length: 0.01 
    Clustering factor: 94154, ratio: 0.11 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 139 
        40 - 59% = 467 
        60 - 79% = 193 
        80 - 99% = 114 
 
    Index PDISTR_SNDOP_RCVOP_SNDID_ASC (0) 
    Root page: 1508635, depth: 3, leaf buckets: 1015, nodes: 861070 
    Average node length: 5.90, total dup: 766737, max dup: 42 
    Average key length: 3.02, compression ratio: 7.29 
    Average prefix length: 21.09, average data length: 0.91 
    Clustering factor: 170840, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 2 
        40 - 59% = 672 
        60 - 79% = 72 
        80 - 99% = 268 
 
    Index PDISTR_SNDOP_RCVOP_SNDID_DESC (1) 
    Root page: 1509209, depth: 3, leaf buckets: 1049, nodes: 861070 
    Average node length: 5.90, total dup: 766737, max dup: 42 
    Average key length: 3.02, compression ratio: 7.29 
    Average prefix length: 21.09, average data length: 0.91 
    Clustering factor: 172765, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 52 
        40 - 59% = 667 
        60 - 79% = 73 
        80 - 99% = 256 
 
    Index PDISTR_WORKER_SND_ID (3) 
    Root page: 1510200, depth: 3, leaf buckets: 1184, nodes: 861070 
    Average node length: 5.98, total dup: 766737, max dup: 42 
    Average key length: 3.10, compression ratio: 5.49 
    Average prefix length: 16.01, average data length: 0.99 
    Clustering factor: 164529, ratio: 0.19 
    Fill distribution: 
         0 - 19% = 4 
        20 - 39% = 206 
        40 - 59% = 631 
        60 - 79% = 250 
        80 - 99% = 93 
 
PERF_AGG (158) 
    Primary pointer page: 540, Index root page: 541 
    Total formats: 1, used formats: 1 
    Average record length: 62.97, total records: 5527 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 3.94, total fragments: 18, max fragments: 1 
    Average unpacked length: 379.00, compression ratio: 6.02 
    Pointer pages: 1, data page slots: 112 
    Data pages: 87, average fill: 63% 
    Primary pages: 76, secondary pages: 11, swept pages: 59 
    Empty pages: 5, full pages: 56 
    Fill distribution: 
     0 - 19% = 11 
    20 - 39% = 1 
    40 - 59% = 1 
    60 - 79% = 74 
    80 - 99% = 0 
 
    Index PERF_AGG_UNQ (1) 
    Root page: 1504260, depth: 2, leaf buckets: 6, nodes: 5527 
    Average node length: 5.50, total dup: 0, max dup: 0 
    Average key length: 3.57, compression ratio: 10.14 
    Average prefix length: 34.65, average data length: 1.53 
    Clustering factor: 5153, ratio: 0.93 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 0 
        40 - 59% = 3 
        60 - 79% = 1 
        80 - 99% = 2 
 
    Index PK_PERF_AGG (0) 
    Root page: 1504255, depth: 2, leaf buckets: 10, nodes: 5527 
    Average node length: 11.14, total dup: 0, max dup: 0 
    Average key length: 9.21, compression ratio: 0.98 
    Average prefix length: 2.79, average data length: 6.21 
    Clustering factor: 171, 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.05, total records: 74468 
    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: 776 
    Data pages: 776, average fill: 66% 
    Primary pages: 776, secondary pages: 0, swept pages: 0 
    Empty pages: 2, full pages: 773 
    Fill distribution: 
     0 - 19% = 2 
    20 - 39% = 1 
    40 - 59% = 0 
    60 - 79% = 773 
    80 - 99% = 0 
 
    Index PK_PERF_ESTIMATED (0) 
    Root page: 33389, depth: 2, leaf buckets: 95, nodes: 74468 
    Average node length: 10.18, total dup: 0, max dup: 0 
    Average key length: 8.19, compression ratio: 1.10 
    Average prefix length: 3.81, average data length: 5.19 
    Clustering factor: 2904, ratio: 0.04 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 0 
        40 - 59% = 2 
        60 - 79% = 0 
        80 - 99% = 93 
 
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: 110.49, 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.30 
    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: 132.16, total records: 183771 
    Average version length: 153.77, total versions: 24653, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 12.83 
    Pointer pages: 7, data page slots: 6336 
    Data pages: 4592, average fill: 84% 
    Primary pages: 4588, secondary pages: 4, swept pages: 5 
    Empty pages: 59, full pages: 4515 
    Fill distribution: 
     0 - 19% = 61 
    20 - 39% = 2 
    40 - 59% = 5 
    60 - 79% = 10 
    80 - 99% = 4514 
 
PERF_SPLIT_1 (282) 
    Primary pointer page: 603, Index root page: 604 
    Total formats: 1, used formats: 1 
    Average record length: 129.64, total records: 159476 
    Average version length: 154.59, total versions: 24044, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 13.08 
    Pointer pages: 7, data page slots: 4920 
    Data pages: 3952, average fill: 85% 
    Primary pages: 3949, secondary pages: 3, swept pages: 3 
    Empty pages: 21, full pages: 3920 
    Fill distribution: 
     0 - 19% = 25 
    20 - 39% = 4 
    40 - 59% = 1 
    60 - 79% = 1 
    80 - 99% = 3921 
 
PERF_SPLIT_2 (283) 
    Primary pointer page: 605, Index root page: 606 
    Total formats: 1, used formats: 1 
    Average record length: 148.07, total records: 158185 
    Average version length: 152.02, total versions: 3478, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.45 
    Pointer pages: 5, data page slots: 5632 
    Data pages: 3960, average fill: 83% 
    Primary pages: 3958, secondary pages: 2, swept pages: 3 
    Empty pages: 61, full pages: 3879 
    Fill distribution: 
     0 - 19% = 66 
    20 - 39% = 10 
    40 - 59% = 3 
    60 - 79% = 2 
    80 - 99% = 3879 
 
PERF_SPLIT_3 (284) 
    Primary pointer page: 607, Index root page: 616 
    Total formats: 1, used formats: 1 
    Average record length: 147.10, total records: 158178 
    Average version length: 152.00, total versions: 4468, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.53 
    Pointer pages: 6, data page slots: 4928 
    Data pages: 3960, average fill: 83% 
    Primary pages: 3959, secondary pages: 1, swept pages: 1 
    Empty pages: 65, full pages: 3875 
    Fill distribution: 
     0 - 19% = 67 
    20 - 39% = 9 
    40 - 59% = 4 
    60 - 79% = 3 
    80 - 99% = 3877 
 
PERF_SPLIT_4 (285) 
    Primary pointer page: 617, Index root page: 618 
    Total formats: 1, used formats: 1 
    Average record length: 145.50, total records: 155198 
    Average version length: 153.75, total versions: 6105, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.66 
    Pointer pages: 6, data page slots: 4200 
    Data pages: 3856, average fill: 83% 
    Primary pages: 3853, secondary pages: 3, swept pages: 7 
    Empty pages: 36, full pages: 3808 
    Fill distribution: 
     0 - 19% = 41 
    20 - 39% = 2 
    40 - 59% = 1 
    60 - 79% = 3 
    80 - 99% = 3809 
 
PERF_SPLIT_5 (286) 
    Primary pointer page: 619, Index root page: 620 
    Total formats: 1, used formats: 1 
    Average record length: 129.02, total records: 164427 
    Average version length: 154.50, total versions: 25107, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 13.15 
    Pointer pages: 6, data page slots: 6496 
    Data pages: 4096, average fill: 85% 
    Primary pages: 4094, secondary pages: 2, swept pages: 2 
    Empty pages: 47, full pages: 4030 
    Fill distribution: 
     0 - 19% = 47 
    20 - 39% = 9 
    40 - 59% = 3 
    60 - 79% = 9 
    80 - 99% = 4028 
 
PERF_SPLIT_6 (287) 
    Primary pointer page: 621, Index root page: 622 
    Total formats: 1, used formats: 1 
    Average record length: 142.54, total records: 151768 
    Average version length: 152.90, total versions: 9021, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.90 
    Pointer pages: 7, data page slots: 5080 
    Data pages: 3768, average fill: 84% 
    Primary pages: 3767, secondary pages: 1, swept pages: 4 
    Empty pages: 33, full pages: 3716 
    Fill distribution: 
     0 - 19% = 35 
    20 - 39% = 5 
    40 - 59% = 1 
    60 - 79% = 12 
    80 - 99% = 3715 
 
PERF_SPLIT_7 (288) 
    Primary pointer page: 626, Index root page: 627 
    Total formats: 1, used formats: 1 
    Average record length: 146.61, total records: 147650 
    Average version length: 152.19, total versions: 4537, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.57 
    Pointer pages: 6, data page slots: 4280 
    Data pages: 3680, average fill: 83% 
    Primary pages: 3678, secondary pages: 2, swept pages: 1 
    Empty pages: 47, full pages: 3619 
    Fill distribution: 
     0 - 19% = 49 
    20 - 39% = 8 
    40 - 59% = 3 
    60 - 79% = 1 
    80 - 99% = 3619 
 
PERF_SPLIT_8 (289) 
    Primary pointer page: 628, Index root page: 629 
    Total formats: 1, used formats: 1 
    Average record length: 148.07, total records: 165801 
    Average version length: 150.81, total versions: 3662, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.45 
    Pointer pages: 7, data page slots: 5440 
    Data pages: 4144, average fill: 83% 
    Primary pages: 4142, secondary pages: 2, swept pages: 1 
    Empty pages: 57, full pages: 4063 
    Fill distribution: 
     0 - 19% = 59 
    20 - 39% = 9 
    40 - 59% = 9 
    60 - 79% = 5 
    80 - 99% = 4062 
 
PERF_SPLIT_9 (290) 
    Primary pointer page: 630, Index root page: 631 
    Total formats: 1, used formats: 1 
    Average record length: 143.22, total records: 173120 
    Average version length: 154.49, total versions: 9638, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.84 
    Pointer pages: 5, data page slots: 5064 
    Data pages: 4336, average fill: 83% 
    Primary pages: 4334, secondary pages: 2, swept pages: 4 
    Empty pages: 69, full pages: 4237 
    Fill distribution: 
     0 - 19% = 70 
    20 - 39% = 9 
    40 - 59% = 7 
    60 - 79% = 17 
    80 - 99% = 4233 
 
PHRASES (143) 
    Primary pointer page: 510, Index root page: 511 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index PHRASES_ID_DESC (3) 
    Root page: 1510376, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PHRASES_NAME (2) 
    Root page: 1510375, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PHRASES_UNQ (1) 
    Root page: 1510374, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PK_PHRASES (0) 
    Root page: 1510373, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
PSTORNED (147) 
    Primary pointer page: 518, Index root page: 519 
    Total formats: 1, used formats: 1 
    Average record length: 51.95, total records: 2019389 
    Average version length: 52.95, total versions: 36648, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 70.00, compression ratio: 1.35 
    Pointer pages: 16, data page slots: 25424 
    Data pages: 25424, average fill: 69% 
    Primary pages: 25404, secondary pages: 20, swept pages: 12979 
    Empty pages: 268, full pages: 19598 
    Fill distribution: 
     0 - 19% = 522 
    20 - 39% = 501 
    40 - 59% = 1507 
    60 - 79% = 22545 
    80 - 99% = 349 
 
    Index PSTORNED_RCV_ID (1) 
    Root page: 1506208, depth: 3, leaf buckets: 2515, nodes: 2019389 
    Average node length: 5.45, total dup: 1881713, max dup: 1849 
    Average key length: 2.50, compression ratio: 3.60 
    Average prefix length: 8.57, average data length: 0.43 
    Clustering factor: 177435, ratio: 0.09 
    Fill distribution: 
         0 - 19% = 5 
        20 - 39% = 341 
        40 - 59% = 1618 
        60 - 79% = 254 
        80 - 99% = 297 
 
    Index PSTORNED_SND_ID (0) 
    Root page: 1504841, depth: 3, leaf buckets: 2753, nodes: 2019389 
    Average node length: 5.70, total dup: 1810976, max dup: 70 
    Average key length: 2.75, compression ratio: 3.28 
    Average prefix length: 8.36, average data length: 0.64 
    Clustering factor: 363047, ratio: 0.18 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 5 
        40 - 59% = 2609 
        60 - 79% = 124 
        80 - 99% = 14 
 
    Index PSTORNED_WORKER_ID (2) 
    Root page: 1508018, depth: 3, leaf buckets: 2068, nodes: 2019389 
    Average node length: 4.96, total dup: 2019289, max dup: 27726 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.41, average data length: 0.00 
    Clustering factor: 175385, ratio: 0.09 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 246 
        40 - 59% = 1025 
        60 - 79% = 381 
        80 - 99% = 414 
 
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: 50.65, total records: 120133 
    Average version length: 69.16, total versions: 37000, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 2.49 
    Pointer pages: 3, data page slots: 3464 
    Data pages: 2871, average fill: 49% 
    Primary pages: 2871, secondary pages: 0, swept pages: 587 
    Empty pages: 343, full pages: 1175 
    Fill distribution: 
     0 - 19% = 697 
    20 - 39% = 449 
    40 - 59% = 373 
    60 - 79% = 854 
    80 - 99% = 498 
 
    Index XQD_1000_1200_WA_SO_RO_WKR_SND (0) 
    Root page: 1555388, depth: 3, leaf buckets: 214, nodes: 120133 
    Average node length: 6.43, total dup: 104395, max dup: 14 
    Average key length: 4.01, compression ratio: 10.48 
    Average prefix length: 40.12, average data length: 1.88 
    Clustering factor: 19891, ratio: 0.17 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 84 
        40 - 59% = 103 
        60 - 79% = 24 
        80 - 99% = 2 
 
XQD_1000_3300 (178) 
    Primary pointer page: 581, Index root page: 582 
    Total formats: 1, used formats: 1 
    Average record length: 67.11, total records: 7470946 
    Average version length: 68.71, total versions: 229428, 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: 70, data page slots: 112968 
    Data pages: 112968, average fill: 71% 
    Primary pages: 112967, secondary pages: 1, swept pages: 41558 
    Empty pages: 56, full pages: 70669 
    Fill distribution: 
     0 - 19% = 266 
    20 - 39% = 1040 
    40 - 59% = 8349 
    60 - 79% = 102388 
    80 - 99% = 925 
 
    Index XQD_1000_3300_WA_SO_RO_WKR_SND (0) 
    Root page: 1480476, depth: 3, leaf buckets: 10795, nodes: 7470946 
    Average node length: 6.51, total dup: 6461292, max dup: 29 
    Average key length: 3.52, compression ratio: 11.93 
    Average prefix length: 40.62, average data length: 1.38 
    Clustering factor: 1738455, ratio: 0.23 
    Fill distribution: 
         0 - 19% = 14 
        20 - 39% = 1221 
        40 - 59% = 5564 
        60 - 79% = 3298 
        80 - 99% = 698 
 
    Index XQD_1000_3300_WKR_DOC_ASC (1) 
    Root page: 1486090, depth: 3, leaf buckets: 8906, nodes: 7470946 
    Average node length: 5.38, total dup: 7183634, max dup: 140 
    Average key length: 2.39, compression ratio: 7.10 
    Average prefix length: 16.64, average data length: 0.36 
    Clustering factor: 1531087, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 12 
        20 - 39% = 997 
        40 - 59% = 5201 
        60 - 79% = 1628 
        80 - 99% = 1068 
 
    Index XQD_1000_3300_WKR_DOC_DEC (2) 
    Root page: 1490630, depth: 3, leaf buckets: 8990, nodes: 7470946 
    Average node length: 5.38, total dup: 7183634, max dup: 140 
    Average key length: 2.39, compression ratio: 7.10 
    Average prefix length: 16.64, average data length: 0.36 
    Clustering factor: 1533366, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 8 
        20 - 39% = 1074 
        40 - 59% = 5256 
        60 - 79% = 1607 
        80 - 99% = 1045 
 
XQD_1200_2000 (177) 
    Primary pointer page: 579, Index root page: 580 
    Total formats: 1, used formats: 1 
    Average record length: 68.05, total records: 12323794 
    Average version length: 68.69, total versions: 181540, 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: 109, data page slots: 177560 
    Data pages: 177560, average fill: 74% 
    Primary pages: 177559, secondary pages: 1, swept pages: 70653 
    Empty pages: 4, full pages: 162439 
    Fill distribution: 
     0 - 19% = 23 
    20 - 39% = 438 
    40 - 59% = 3532 
    60 - 79% = 172588 
    80 - 99% = 979 
 
    Index XQD_1200_2000_WA_SO_RO_WKR_SND (0) 
    Root page: 1495050, depth: 3, leaf buckets: 18478, nodes: 12321515 
    Average node length: 6.63, total dup: 10737086, max dup: 61 
    Average key length: 3.43, compression ratio: 12.25 
    Average prefix length: 40.70, average data length: 1.30 
    Clustering factor: 2519561, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 41 
        20 - 39% = 2010 
        40 - 59% = 10467 
        60 - 79% = 5019 
        80 - 99% = 941 
 
XQD_2000_3300 (179) 
    Primary pointer page: 583, Index root page: 584 
    Total formats: 1, used formats: 1 
    Average record length: 51.76, total records: 1431484 
    Average version length: 69.03, total versions: 210564, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 2.43 
    Pointer pages: 25, data page slots: 39032 
    Data pages: 28599, average fill: 51% 
    Primary pages: 28519, secondary pages: 80, swept pages: 10614 
    Empty pages: 3977, full pages: 16630 
    Fill distribution: 
     0 - 19% = 6144 
    20 - 39% = 4377 
    40 - 59% = 2973 
    60 - 79% = 12444 
    80 - 99% = 2661 
 
    Index XQD_2000_3300_WA_SO_RO_WKR_SND (0) 
    Root page: 1479735, depth: 3, leaf buckets: 1791, nodes: 1228498 
    Average node length: 5.54, total dup: 1178806, max dup: 49 
    Average key length: 2.57, compression ratio: 16.31 
    Average prefix length: 41.46, average data length: 0.54 
    Clustering factor: 85130, ratio: 0.07 
    Fill distribution: 
         0 - 19% = 8 
        20 - 39% = 586 
        40 - 59% = 844 
        60 - 79% = 318 
        80 - 99% = 35 
 
XQD_2100_3300 (180) 
    Primary pointer page: 585, Index root page: 586 
    Total formats: 1, used formats: 1 
    Average record length: 45.52, total records: 1226857 
    Average version length: 68.97, total versions: 147633, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 2.77 
    Pointer pages: 19, data page slots: 30552 
    Data pages: 27344, average fill: 42% 
    Primary pages: 27343, secondary pages: 1, swept pages: 5595 
    Empty pages: 2497, full pages: 10425 
    Fill distribution: 
     0 - 19% = 5729 
    20 - 39% = 6190 
    40 - 59% = 7982 
    60 - 79% = 7275 
    80 - 99% = 168 
 
    Index XQD_2100_3300_WA_SO_RO_WKR_SND (0) 
    Root page: 1479229, depth: 3, leaf buckets: 1364, nodes: 894342 
    Average node length: 5.95, total dup: 823709, max dup: 82 
    Average key length: 3.01, compression ratio: 13.97 
    Average prefix length: 41.07, average data length: 0.93 
    Clustering factor: 138807, ratio: 0.16 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 400 
        40 - 59% = 672 
        60 - 79% = 274 
        80 - 99% = 18 
 
XQD_3300_3400 (181) 
    Primary pointer page: 587, Index root page: 588 
    Total formats: 1, used formats: 1 
    Average record length: 66.32, total records: 8541006 
    Average version length: 68.97, total versions: 358918, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.90 
    Pointer pages: 86, data page slots: 139824 
    Data pages: 139808, average fill: 66% 
    Primary pages: 139787, secondary pages: 21, swept pages: 64853 
    Empty pages: 307, full pages: 49556 
    Fill distribution: 
     0 - 19% = 1083 
    20 - 39% = 5488 
    40 - 59% = 27509 
    60 - 79% = 104016 
    80 - 99% = 1712 
 
    Index XQD_3300_3400_WA_SO_RO_WKR_SND (0) 
    Root page: 1472612, depth: 3, leaf buckets: 13392, nodes: 8534406 
    Average node length: 6.67, total dup: 7077003, max dup: 14 
    Average key length: 3.68, compression ratio: 11.43 
    Average prefix length: 40.49, average data length: 1.51 
    Clustering factor: 1945402, ratio: 0.23 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 2126 
        40 - 59% = 7424 
        60 - 79% = 3485 
        80 - 99% = 356 
 
XQS_1000_1200 (182) 
    Primary pointer page: 589, Index root page: 590 
    Total formats: 1, used formats: 1 
    Average record length: 82.51, total records: 21073224 
    Average version length: 82.92, total versions: 9132, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.53 
    Pointer pages: 196, data page slots: 318656 
    Data pages: 318656, average fill: 81% 
    Primary pages: 318650, secondary pages: 6, swept pages: 12730 
    Empty pages: 36, full pages: 317677 
    Fill distribution: 
     0 - 19% = 77 
    20 - 39% = 67 
    40 - 59% = 142 
    60 - 79% = 47606 
    80 - 99% = 270764 
 
    Index XQS_1000_1200_DOC_ID (1) 
    Root page: 1426738, depth: 3, leaf buckets: 19138, nodes: 21073224 
    Average node length: 5.72, total dup: 20593961, max dup: 132 
    Average key length: 2.16, compression ratio: 4.16 
    Average prefix length: 8.86, average data length: 0.14 
    Clustering factor: 3271250, ratio: 0.16 
    Fill distribution: 
         0 - 19% = 5 
        20 - 39% = 1 
        40 - 59% = 7810 
        60 - 79% = 487 
        80 - 99% = 10835 
 
    Index XQS_1000_1200_RCV_ID (3) 
    Root page: 1457002, depth: 3, leaf buckets: 17098, nodes: 21073224 
    Average node length: 6.31, total dup: 18517648, max dup: 49 
    Average key length: 2.75, compression ratio: 3.27 
    Average prefix length: 8.37, average data length: 0.63 
    Clustering factor: 915197, ratio: 0.04 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 6 
        40 - 59% = 754 
        60 - 79% = 280 
        80 - 99% = 16056 
 
    Index XQS_1000_1200_SND_ID (2) 
    Root page: 1441095, depth: 3, leaf buckets: 20904, nodes: 21073224 
    Average node length: 6.34, total dup: 18438106, max dup: 29 
    Average key length: 2.79, compression ratio: 3.23 
    Average prefix length: 8.34, average data length: 0.66 
    Clustering factor: 3565129, ratio: 0.17 
    Fill distribution: 
         0 - 19% = 4 
        20 - 39% = 2 
        40 - 59% = 8040 
        60 - 79% = 568 
        80 - 99% = 12290 
 
    Index XQS_1000_1200_WORKER_ID (0) 
    Root page: 1413370, depth: 3, leaf buckets: 15986, nodes: 21073224 
    Average node length: 5.56, total dup: 21073124, max dup: 229879 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.42, average data length: 0.00 
    Clustering factor: 943763, ratio: 0.04 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 14 
        40 - 59% = 2790 
        60 - 79% = 335 
        80 - 99% = 12847 
 
XQS_1000_3300 (184) 
    Primary pointer page: 593, Index root page: 594 
    Total formats: 1, used formats: 1 
    Average record length: 79.51, total records: 8974362 
    Average version length: 82.58, total versions: 351547, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.58 
    Pointer pages: 103, data page slots: 166728 
    Data pages: 166688, average fill: 67% 
    Primary pages: 166659, secondary pages: 29, swept pages: 85028 
    Empty pages: 689, full pages: 75713 
    Fill distribution: 
     0 - 19% = 2315 
    20 - 39% = 9327 
    40 - 59% = 30323 
    60 - 79% = 108450 
    80 - 99% = 16273 
 
    Index XQS_1000_3300_DOC_ID (1) 
    Root page: 1367524, depth: 3, leaf buckets: 11313, nodes: 8974362 
    Average node length: 5.35, total dup: 8672710, max dup: 166 
    Average key length: 2.25, compression ratio: 4.01 
    Average prefix length: 8.79, average data length: 0.21 
    Clustering factor: 2031787, ratio: 0.23 
    Fill distribution: 
         0 - 19% = 4 
        20 - 39% = 188 
        40 - 59% = 9841 
        60 - 79% = 1269 
        80 - 99% = 11 
 
    Index XQS_1000_3300_RCV_ID (3) 
    Root page: 1379283, depth: 3, leaf buckets: 12679, nodes: 8974362 
    Average node length: 6.21, total dup: 7437192, max dup: 14 
    Average key length: 3.11, compression ratio: 2.90 
    Average prefix length: 8.06, average data length: 0.94 
    Clustering factor: 1416959, ratio: 0.16 
    Fill distribution: 
         0 - 19% = 122 
        20 - 39% = 3818 
        40 - 59% = 4052 
        60 - 79% = 2577 
        80 - 99% = 2110 
 
    Index XQS_1000_3300_SND_ID (2) 
    Root page: 1373081, depth: 3, leaf buckets: 12622, nodes: 8974362 
    Average node length: 5.97, total dup: 7770656, max dup: 36 
    Average key length: 2.86, compression ratio: 3.14 
    Average prefix length: 8.27, average data length: 0.73 
    Clustering factor: 2204941, ratio: 0.25 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 253 
        40 - 59% = 10918 
        60 - 79% = 1432 
        80 - 99% = 19 
 
    Index XQS_1000_3300_WORKER_ID (0) 
    Root page: 1362789, depth: 3, leaf buckets: 9518, nodes: 8974362 
    Average node length: 5.11, total dup: 8974262, max dup: 150415 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.42, average data length: 0.00 
    Clustering factor: 1444581, ratio: 0.16 
    Fill distribution: 
         0 - 19% = 43 
        20 - 39% = 1381 
        40 - 59% = 4574 
        60 - 79% = 1697 
        80 - 99% = 1823 
 
XQS_1200_2000 (183) 
    Primary pointer page: 591, Index root page: 592 
    Total formats: 1, used formats: 1 
    Average record length: 80.44, total records: 10768975 
    Average version length: 82.41, total versions: 271401, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.57 
    Pointer pages: 118, data page slots: 191904 
    Data pages: 190264, average fill: 70% 
    Primary pages: 190128, secondary pages: 136, swept pages: 79822 
    Empty pages: 3768, full pages: 130126 
    Fill distribution: 
     0 - 19% = 6501 
    20 - 39% = 9717 
    40 - 59% = 22520 
    60 - 79% = 93182 
    80 - 99% = 58344 
 
    Index XQS_1200_2000_DOC_ID (1) 
    Root page: 1392123, depth: 3, leaf buckets: 13119, nodes: 10768975 
    Average node length: 5.29, total dup: 10660049, max dup: 639 
    Average key length: 2.08, compression ratio: 4.32 
    Average prefix length: 8.93, average data length: 0.07 
    Clustering factor: 2251613, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 310 
        40 - 59% = 10343 
        60 - 79% = 2406 
        80 - 99% = 59 
 
    Index XQS_1200_2000_RCV_ID (3) 
    Root page: 1406132, depth: 3, leaf buckets: 10017, nodes: 10768975 
    Average node length: 5.49, total dup: 10297162, max dup: 49 
    Average key length: 2.28, compression ratio: 3.95 
    Average prefix length: 8.77, average data length: 0.23 
    Clustering factor: 690172, ratio: 0.06 
    Fill distribution: 
         0 - 19% = 176 
        20 - 39% = 876 
        40 - 59% = 2379 
        60 - 79% = 1818 
        80 - 99% = 4768 
 
    Index XQS_1200_2000_SND_ID (2) 
    Root page: 1398660, depth: 3, leaf buckets: 15001, nodes: 10768975 
    Average node length: 6.02, total dup: 9382654, max dup: 65 
    Average key length: 2.81, compression ratio: 3.20 
    Average prefix length: 8.31, average data length: 0.69 
    Clustering factor: 2267797, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 3 
        20 - 39% = 371 
        40 - 59% = 11850 
        60 - 79% = 2694 
        80 - 99% = 83 
 
    Index XQS_1200_2000_WORKER_ID (0) 
    Root page: 1386233, depth: 3, leaf buckets: 10259, nodes: 10768975 
    Average node length: 5.21, total dup: 10768875, max dup: 181185 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.43, average data length: 0.00 
    Clustering factor: 679031, ratio: 0.06 
    Fill distribution: 
         0 - 19% = 100 
        20 - 39% = 930 
        40 - 59% = 4303 
        60 - 79% = 1507 
        80 - 99% = 3419 
 
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: 79.82, total records: 9090567 
    Average version length: 82.93, total versions: 357636, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.58 
    Pointer pages: 106, data page slots: 171408 
    Data pages: 171312, average fill: 66% 
    Primary pages: 171280, secondary pages: 32, swept pages: 87957 
    Empty pages: 786, full pages: 77028 
    Fill distribution: 
     0 - 19% = 2674 
    20 - 39% = 11270 
    40 - 59% = 32900 
    60 - 79% = 108650 
    80 - 99% = 15818 
 
    Index XQS_2100_3300_DOC_ID (1) 
    Root page: 1344708, depth: 3, leaf buckets: 11233, nodes: 9090567 
    Average node length: 5.16, total dup: 9062657, max dup: 1486 
    Average key length: 2.03, compression ratio: 4.43 
    Average prefix length: 8.97, average data length: 0.03 
    Clustering factor: 1848001, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 28 
        20 - 39% = 1687 
        40 - 59% = 7425 
        60 - 79% = 1615 
        80 - 99% = 478 
 
    Index XQS_2100_3300_RCV_ID (3) 
    Root page: 1355739, depth: 3, leaf buckets: 12854, nodes: 9090567 
    Average node length: 6.23, total dup: 7532957, max dup: 14 
    Average key length: 3.11, compression ratio: 2.90 
    Average prefix length: 8.06, average data length: 0.94 
    Clustering factor: 1399461, ratio: 0.15 
    Fill distribution: 
         0 - 19% = 191 
        20 - 39% = 3846 
        40 - 59% = 4038 
        60 - 79% = 2560 
        80 - 99% = 2219 
 
    Index XQS_2100_3300_SND_ID (2) 
    Root page: 1350071, depth: 3, leaf buckets: 11810, nodes: 9090567 
    Average node length: 5.42, total dup: 8676005, max dup: 99 
    Average key length: 2.29, compression ratio: 3.93 
    Average prefix length: 8.75, average data length: 0.25 
    Clustering factor: 1973074, ratio: 0.22 
    Fill distribution: 
         0 - 19% = 32 
        20 - 39% = 1636 
        40 - 59% = 8160 
        60 - 79% = 1501 
        80 - 99% = 481 
 
    Index XQS_2100_3300_WORKER_ID (0) 
    Root page: 987843, depth: 3, leaf buckets: 9682, nodes: 9090567 
    Average node length: 5.13, total dup: 9090467, max dup: 152776 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.42, average data length: 0.00 
    Clustering factor: 1475865, ratio: 0.16 
    Fill distribution: 
         0 - 19% = 46 
        20 - 39% = 1425 
        40 - 59% = 4665 
        60 - 79% = 1676 
        80 - 99% = 1870 
 
XQS_3300_3400 (187) 
    Primary pointer page: 599, Index root page: 600 
    Total formats: 1, used formats: 1 
    Average record length: 67.54, total records: 563349 
    Average version length: 68.79, total versions: 5906, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.87 
    Pointer pages: 5, data page slots: 8000 
    Data pages: 8000, average fill: 74% 
    Primary pages: 8000, secondary pages: 0, swept pages: 4177 
    Empty pages: 1, full pages: 6175 
    Fill distribution: 
     0 - 19% = 4 
    20 - 39% = 21 
    40 - 59% = 259 
    60 - 79% = 7632 
    80 - 99% = 84 
 
    Index XQS_3300_3400_DOC_ID (1) 
    Root page: 41434, depth: 3, leaf buckets: 736, nodes: 563349 
    Average node length: 5.95, total dup: 479329, max dup: 83 
    Average key length: 3.10, compression ratio: 2.91 
    Average prefix length: 8.05, average data length: 0.95 
    Clustering factor: 99223, ratio: 0.18 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 33 
        40 - 59% = 543 
        60 - 79% = 74 
        80 - 99% = 85 
 
    Index XQS_3300_3400_SND_ID (2) 
    Root page: 32876, depth: 3, leaf buckets: 751, nodes: 563349 
    Average node length: 6.15, total dup: 461850, max dup: 25 
    Average key length: 3.30, compression ratio: 2.73 
    Average prefix length: 7.88, average data length: 1.12 
    Clustering factor: 99269, ratio: 0.18 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 40 
        40 - 59% = 530 
        60 - 79% = 81 
        80 - 99% = 98 
 
    Index XQS_3300_3400_WORKER_ID (0) 
    Root page: 377587, depth: 2, leaf buckets: 560, nodes: 563349 
    Average node length: 4.85, total dup: 563249, max dup: 9355 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.41, average data length: 0.00 
    Clustering factor: 88253, ratio: 0.16 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 45 
        40 - 59% = 318 
        60 - 79% = 73 
        80 - 99% = 124 
 
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 26 10:10:17 2024

Record versions statistics, table

TABLE_NAME TOTAL_RECS TOTAL_VERS MAX_VERSIONS VERS_TO_RECS_PRC MAXV_TO_VERS_PRC
DOC_DATA 7609188 73877 1 0.0000 0.0000
DOC_LIST 2167745 37411 2 0.0000 0.0000
FB_ERRORS 2182 757 1 0.0000 0.0000
INVNT_SALDO 400 1240 4 300.0000 0.0000
INVNT_TURNOVER_LOG 139169 112352 1 0.0000 0.0000
MONEY_SALDO 49 168 5 300.0000 0.0000
MONEY_TURNOVER_LOG 2309 1955 1 0.0000 0.0000
PDISTR 869551 18272 2 0.0000 0.0000
PERF_SPLIT_0 183771 24653 1 0.0000 0.0000
PERF_SPLIT_1 159476 24044 1 0.0000 0.0000
PERF_SPLIT_2 158185 3478 1 0.0000 0.0000
PERF_SPLIT_3 158178 4468 1 0.0000 0.0000
PERF_SPLIT_4 155198 6105 1 0.0000 0.0000
PERF_SPLIT_5 164427 25107 1 0.0000 0.0000
PERF_SPLIT_6 151768 9021 1 0.0000 0.0000
PERF_SPLIT_7 147650 4537 1 0.0000 0.0000
PERF_SPLIT_8 165801 3662 1 0.0000 0.0000
PERF_SPLIT_9 173120 9638 1 0.0000 0.0000
PSTORNED 2019389 36648 1 0.0000 0.0000
SEMAPHORES 5 1 1 0.0000 100.0000
XQD_1000_1200 120133 37000 1 0.0000 0.0000
XQD_1000_3300 7470946 229428 1 0.0000 0.0000
XQD_1200_2000 12323794 181540 1 0.0000 0.0000
XQD_2000_3300 1431484 210564 1 0.0000 0.0000
XQD_2100_3300 1226857 147633 1 0.0000 0.0000
XQD_3300_3400 8541006 358918 1 0.0000 0.0000
XQS_1000_1200 21073224 9132 1 0.0000 0.0000
XQS_1000_3300 8974362 351547 1 0.0000 0.0000
XQS_1200_2000 10768975 271401 1 0.0000 0.0000
XQS_2100_3300 9090567 357636 1 0.0000 0.0000
XQS_3300_3400 563349 5906 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 ---
:11: 
:12: mscs-test-161.budzdorov.ru    Tue Mar 26 10:08:02 2024
:13:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3400
:14: 
:15: 
:16: mscs-test-161.budzdorov.ru    Tue Mar 26 10:08:03 2024
:17:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3400
:18: 
:19: 
:20: mscs-test-161.budzdorov.ru    Tue Mar 26 10:08:04 2024
:21:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3400
:22: 
--- end of diff output ---

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

26.03.24 10:10:30. 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-26 10:10:32 No severe PSQL-related problems occured
26.03.24 10:10:34. End of report.