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

Hardware and OS info

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

Server and database settinfs 


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

Test configuration settings 

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

Test finish info 


FINISH_STATE                    NORMAL: TEST_TIME EXPIRED AT 2024-03-29 01:09:45
DTS_END                         2024-03-29 01:09:45.4680
FB_GDSCODE                      -1
FB_MNEMONA                      
STACK                           SP_CLIENT_ORDER(57:5) ==> SP_CHECK_TO_STOP_WORK(32:12) ==> SP_HALT_ON_ERROR(57:17)
IP                              ::1/59568
TRN_ID                          178758
ATT_ID                          613
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: 9372.80 23970 937280
customer order: creation 179.91 373 17991
customer order: refuse 15.39 324 1539
order to supplier: creation 47.98 1234 4798
order to supplier: removal 3.52 92658 352
invoice (draft): creation 48.48 3093 4848
invoice (draft): removal 50.08 722 5008
invoice accept: apply 44.07 21098 4407
invoice accept: cancel 45.07 767 4507
customer reserve: creation 4223.02 204 422302
customer reserve: removal 4405.52 58 440552
realization accept: apply 88.10 192 8810
realization accept: cancel 80.61 140 8061
payment from customer: creation 64.65 115 6465
payment from customer: removal 6.25 77 625
payment to supplier: creation 52.88 158 5288
payment to supplier: removal 3.63 85 363
service: total inventory turnovers 5.06 1216 506
service: total monetary turnovers 7.61 28 761
service: aggregate perf. data 0.94 18124 94
service: refresh index statistics 0.03 338727 3

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:02, from 29-03-2024 01:10:38 to 29-03-2024 01:10:40.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 3385
TEST_TIME 2 4324
TEST_TIME 3 5193
TEST_TIME 4 4677
TEST_TIME 5 4770
TEST_TIME 6 4810
TEST_TIME 7 4795
TEST_TIME 8 5220
TEST_TIME 9 5665
TEST_TIME 10 5566
TEST_TIME 11 5725
TEST_TIME 12 5807
TEST_TIME 13 5876
TEST_TIME 14 5980
TEST_TIME 15 5923
TEST_TIME 16 6045
TEST_TIME 17 6291
TEST_TIME 18 6459
TEST_TIME 19 6513
TEST_TIME 20 6670
TEST_TIME 21 7054
TEST_TIME 22 7473
TEST_TIME 23 7381
TEST_TIME 24 7755
TEST_TIME 25 7632
TEST_TIME 26 7757
TEST_TIME 27 9083
TEST_TIME 28 9088
TEST_TIME 29 9052
TEST_TIME 30 9181
TEST_TIME 31 9031
TEST_TIME 32 9010
TEST_TIME 33 8970
TEST_TIME 34 8883
TEST_TIME 35 8967
TEST_TIME 36 8975
TEST_TIME 37 8925
TEST_TIME 38 8927
TEST_TIME 39 8932
TEST_TIME 40 8958
TEST_TIME 41 8948
TEST_TIME 42 8896
TEST_TIME 43 9011
TEST_TIME 44 8869
TEST_TIME 45 8916
TEST_TIME 46 9103
TEST_TIME 47 9142
TEST_TIME 48 9114
TEST_TIME 49 9249
TEST_TIME 50 9293
TEST_TIME 51 9211
TEST_TIME 52 9266
TEST_TIME 53 9373
TEST_TIME 54 9459
TEST_TIME 55 9464
TEST_TIME 56 9506
TEST_TIME 57 9509
TEST_TIME 58 9414
TEST_TIME 59 9392
TEST_TIME 60 9394
TEST_TIME 61 9337
TEST_TIME 62 9341
TEST_TIME 63 9334
TEST_TIME 64 9309
TEST_TIME 65 9277
TEST_TIME 66 9180
TEST_TIME 67 9216
TEST_TIME 68 9168
TEST_TIME 69 9136
TEST_TIME 70 9151
TEST_TIME 71 9136
TEST_TIME 72 9223
TEST_TIME 73 9327
TEST_TIME 74 9310
TEST_TIME 75 9340
TEST_TIME 76 9391
TEST_TIME 77 9439
TEST_TIME 78 9492
TEST_TIME 79 9556
TEST_TIME 80 9528
TEST_TIME 81 9590
TEST_TIME 82 9603
TEST_TIME 83 9518
TEST_TIME 84 9465
TEST_TIME 85 9399
TEST_TIME 86 9453
TEST_TIME 87 9445
TEST_TIME 88 9428
TEST_TIME 89 9391
TEST_TIME 90 9392
TEST_TIME 91 9328
TEST_TIME 92 9301
TEST_TIME 93 9276
TEST_TIME 94 9257
TEST_TIME 95 9328
TEST_TIME 96 9335
TEST_TIME 97 9354
TEST_TIME 98 9389
TEST_TIME 99 9372
TEST_TIME 100 9383

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:04, from 29-03-2024 01:10:41 to 29-03-2024 01:10:45.

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 1323083 1323083 0 0.00 0 23901 8 0 0
doc_list_biud 1323078 1323078 0 0.00 0 52669 25 0 0
sp_add_invoice_to_stock 4532 4407 125 2.75 29 232911 21099 0 125
sp_cancel_adding_invoice 4507 4507 0 0.00 5 54190 768 0 0
sp_cancel_client_order 1539 1539 0 0.00 4 9374 325 0 0
sp_cancel_customer_reserve 440552 440552 0 0.00 0 26863 59 0 0
sp_cancel_pay_from_customer 625 625 0 0.00 2 7031 78 0 0
sp_cancel_pay_to_supplier 363 363 0 0.00 2 6603 86 0 0
sp_cancel_supplier_invoice 5016 5008 8 0.15 2 52672 722 0 8
sp_cancel_supplier_order 352 352 0 0.00 4 991659 92658 0 0
sp_cancel_write_off 8061 8061 0 0.00 1 10434 141 0 0
sp_client_order 17991 17991 0 0.00 3 25850 373 0 0
sp_customer_reserve 422302 422302 0 0.00 0 77384 204 0 0
sp_fill_shopping_cart 27633 27633 0 0.00 1 11683 35 0 0
sp_fill_shopping_cart_clo_res 422283 422283 0 0.00 0 14545 16 0 0
sp_get_clo_for_invoice 4388 4388 0 0.00 0 26842 289 0 0
sp_kill_cost_storno 13556 13556 0 0.00 0 10430 65 0 0
sp_kill_qstorno_ret_qs2qd 894525 894525 0 0.00 0 52666 32 0 0
sp_kill_qty_storno 473217 473217 0 0.00 0 52668 68 0 0
sp_lock_selected_doc 18329 18329 0 0.00 0 8985 6 0 0
sp_make_cost_storno 24951 24951 0 0.00 0 17796 67 0 0
sp_multiply_rows_for_pdistr 24951 24951 0 0.00 0 11970 31 0 0
sp_multiply_rows_for_qdistr 17991 17991 0 0.00 0 15544 171 0 0
sp_pay_from_customer 6465 6465 0 0.00 4 16920 115 0 0
sp_pay_to_supplier 5288 5288 0 0.00 5 18071 158 0 0
sp_payment_common 11753 11753 0 0.00 1 9483 28 0 0
sp_qd_handle_on_cancel_clo 1539 1539 0 0.00 0 9365 296 0 0
sp_qd_handle_on_invoice_upd_sts 8895 8895 0 0.00 0 37289 296 0 0
sp_qd_handle_on_reserve_upd_sts 8810 8810 0 0.00 0 18649 56 0 0
sp_reserve_write_off 8810 8810 0 0.00 7 19683 192 0 0
sp_supplier_invoice 4848 4848 0 0.00 6 95804 3093 0 0
sp_supplier_order 4798 4798 0 0.00 5 50472 1234 0 0
srv_aggregate_perf_data 94 94 0 0.00 1815 203062 18124 0 0
srv_fill_mon_cache_memory 58 58 0 0.00 1292 123183 36569 0 0
srv_find_qd_qs_mism 891786 891786 0 0.00 0 23900 7 0 0
srv_make_invnt_saldo 506 506 0 0.00 44 63487 1217 0 0
srv_make_money_saldo 761 761 0 0.00 1 3538 28 0 0
srv_recalc_idx_stat 3 3 0 0.00 244925 458606 338728 0 0
t$perf-abend:sp_add_invoice_to_stock 125 125 0 0.00 0 0 0 0 0
t$perf-abend:sp_cancel_supplier_invoice 8 8 0 0.00 0 0 0 0 0
t$perf-norm:sp_add_invoice_to_stock 4407 4407 0 0.00 0 13605 187 0 0
t$perf-norm:sp_cancel_adding_invoice 356 356 0 0.00 0 8560 113 0 0
t$perf-norm:sp_cancel_client_order 1539 1539 0 0.00 0 3137 14 0 0
t$perf-norm:sp_cancel_customer_reserve 616 616 0 0.00 0 4321 16 0 0
t$perf-norm:sp_cancel_pay_from_customer 625 625 0 0.00 0 21451 51 0 0
t$perf-norm:sp_cancel_pay_to_supplier 363 363 0 0.00 0 5044 25 0 0
t$perf-norm:sp_cancel_supplier_invoice 373 373 0 0.00 0 455 14 0 0
t$perf-norm:sp_cancel_supplier_order 352 352 0 0.00 0 36686 1685 0 0
t$perf-norm:sp_cancel_write_off 907 907 0 0.00 0 4049 11 0 0
t$perf-norm:sp_client_order 17991 17991 0 0.00 0 23403 17 0 0
t$perf-norm:sp_customer_reserve 860 860 0 0.00 0 5377 15 0 0
t$perf-norm:sp_pay_from_customer 6465 6465 0 0.00 0 6105 11 0 0
t$perf-norm:sp_pay_to_supplier 5288 5288 0 0.00 0 5676 9 0 0
t$perf-norm:sp_reserve_write_off 8810 8810 0 0.00 0 5050 9 0 0
t$perf-norm:sp_supplier_invoice 4848 4848 0 0.00 0 5952 18 0 0
t$perf-norm:sp_supplier_order 4798 4798 0 0.00 0 4628 15 0 0
t$perf-norm:srv_aggregate_perf_data 94 94 0 0.00 0 283 5 0 0
t$perf-norm:srv_fill_mon_cache_memory 58 58 0 0.00 0 249 5 0 0
t$perf-norm:srv_make_invnt_saldo 506 506 0 0.00 0 4908 32 0 0
t$perf-norm:srv_make_money_saldo 761 761 0 0.00 0 2040 11 0 0
t$perf-norm:srv_recalc_idx_stat 3 3 0 0.00 2 9 5 0 0
v_add_invoice_to_stock 9026 8776 250 2.76 0 5877 16 0 250
v_all_customers 33750 33750 0 0.00 0 103 1 0 0
v_all_suppliers 27754 27754 0 0.00 0 24 1 0 0
v_all_wares 35982 35982 0 0.00 0 79 1 0 0
v_cancel_adding_invoice 712 712 0 0.00 0 401 7 0 0
v_cancel_client_order 3078 3078 0 0.00 0 1773 4 0 0
v_cancel_customer_prepayment 1250 1250 0 0.00 0 2738 10 0 0
v_cancel_customer_reserve 1232 1232 0 0.00 0 4939 9 0 0
v_cancel_payment_to_supplier 726 726 0 0.00 0 143 3 0 0
v_cancel_supplier_invoice 762 746 16 2.09 0 292 12 0 16
v_cancel_supplier_order 704 704 0 0.00 0 1047 4 0 0
v_cancel_write_off 1814 1814 0 0.00 0 3457 14 0 0
v_max_id_clo_ord 4796 4796 0 0.00 0 1384 2 0 0
v_max_id_clo_res 860 860 0 0.00 0 2693 17 0 0
v_max_id_ord_sup 4845 4845 0 0.00 0 6877 6 0 0
v_max_non_paid_invoice 1052 1052 0 0.00 0 1708 5 0 0
v_max_non_paid_realizn 3155 3155 0 0.00 0 3475 5 0 0
v_min_id_clo_ord 4796 4796 0 0.00 0 4780 10 0 0
v_min_id_clo_res 860 860 0 0.00 0 1893 7 0 0
v_min_id_ord_sup 4845 4845 0 0.00 0 11679 10 0 0
v_min_non_paid_invoice 5288 5288 0 0.00 0 9476 19 0 0
v_min_non_paid_realizn 6465 6465 0 0.00 0 5935 18 0 0
v_our_firm 8852 8852 0 0.00 0 18 1 0 0
v_reserve_write_off 17620 17620 0 0.00 0 2865 5 0 0
x_lock_depdocs_on_canc_invoice 9142 9142 0 0.00 0 13917 137 0 0
x_lock_depdocs_on_canc_sup_ord 352 352 0 0.00 0 9723 364 0 0
x_make_qstorno_1000_1200 4798 4798 0 0.00 1 50463 1153 0 0
x_make_qstorno_1200_2000 4848 4848 0 0.00 2 95772 2973 0 0
x_make_qstorno_2100_3300 422302 422302 0 0.00 0 77380 185 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 29-03-2024 01:10:46 to 29-03-2024 01:10:50.

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
23:09:49 5 8192000000 8804092512 8817053696 9507088 0.115 3 1 2 0 9617424 67552 42784
23:10:50 18359 8192000000 9887207264 10194665472 970906336 10.596 100 87 174 0 999314912 5095248 23313328
23:12:12 16981 8192000000 9936732464 10259103744 1023280944 11.104 100 84 168 0 1052642496 7581968 21779584
23:13:34 15257 8192000000 9966747360 10295197696 1050201936 11.363 100 89 178 0 1082054144 9702176 22150032
23:14:55 11510 8192000000 10000120912 10340524032 1088310624 11.727 100 80 160 0 1118660496 10253360 20096512
23:16:14 6054 8192000000 10047300352 10397622272 1135926432 12.177 100 76 152 0 1165221808 11558464 17736912
23:17:27 6449 8192000000 10109420432 10472275968 1190060752 12.684 100 76 148 0 1219204096 12210448 16932896
23:18:36 2313 8192000000 10143579840 10516766720 1229813440 13.052 100 85 169 0 1261823712 13132128 18878144
23:19:42 1138 8192000000 10174186160 10548957184 1259652976 13.327 100 88 174 1 1292537808 13828592 19056240
23:20:45 1655 8192000000 10203607888 10585505792 1288151040 13.587 100 86 172 0 1320183280 13110592 18921648
23:21:49 4617 8192000000 10208165152 10601074688 1302657856 13.719 100 70 138 0 1330042896 12266304 15118736
23:22:55 921 8192000000 10233104048 10625089536 1318623712 13.864 100 81 162 1 1349445072 12580176 18241184
23:23:56 3730 8192000000 10209187136 10618933248 1322206528 13.897 100 48 100 3 1338587360 4694288 11686544
23:25:00 7507 8192000000 10214245232 10630197248 1325942992 13.930 100 13 23 0 1333814080 5311952 2559136
23:26:09 9186 8192000000 10223075344 10643918848 1333648336 14.000 100 14 28 0 1341862752 5451504 2762912
23:27:22 15824 8192000000 10227979776 10651037696 1339535408 14.053 100 51 98 5 1357770912 4992368 13243136
23:28:38 3238 8192000000 10247604160 10654691328 1339955280 14.057 100 52 104 1 1358218928 5630768 12632880
23:29:44 4027 8192000000 10238335472 10652409856 1336157632 14.023 100 33 64 0 1350509856 6533168 7819056
23:31:09 10914 8192000000 10266275184 10675253248 1355583872 14.198 100 60 120 0 1379696288 10858240 13254176
23:32:24 28320 8192000000 10252860256 10677547008 1346498624 14.116 99 29 58 1 1362161344 8974576 6688144
23:34:11 16363 8192000000 10256249136 10678165504 1332485552 13.990 98 33 66 0 1352106624 12039792 7581280
23:35:33 24475 8192000000 10236601280 10655879168 1299854320 13.694 96 28 56 0 1317489760 11142016 6493424
23:36:59 44353 8192000000 10267404624 10685755392 1348675936 14.136 99 37 72 0 1374781200 17284512 8820752
23:38:51 8442 8192000000 10240280384 10650931200 1287166672 13.578 96 44 88 0 1315521648 18239984 10114992
23:40:03 20779 8192000000 10259950592 10677215232 1339270912 14.051 100 49 98 1 1370208144 19703360 11233872
23:41:26 12623 8192000000 10233716544 10643824640 1288692384 13.592 96 52 105 0 1320869856 19893152 12284320
23:42:47 16687 8192000000 10279897280 10689499136 1346668352 14.117 100 53 106 0 1386004960 26446336 12890272
23:44:11 3890 8192000000 10277878640 10674126848 1332658848 13.991 100 76 149 2 1378962864 28451648 17852368
23:45:19 2442 8192000000 10273786544 10667565056 1326029744 13.931 100 74 148 0 1378539920 34498944 18011232
23:46:27 1289 8192000000 10297582608 10697732096 1346722384 14.118 100 72 144 1 1403414144 39059248 17632512
23:47:35 5695 8192000000 10316774848 10718420992 1358346224 14.223 100 79 158 1 1419804096 41821360 19636512
23:48:53 1475 8192000000 10313298016 10707759104 1342084272 14.076 99 89 177 1 1407694448 43990480 21619696
23:49:57 2421 8192000000 10333039232 10736467968 1367132256 14.301 100 80 159 0 1433409952 46648816 19628880
23:51:05 7693 8192000000 10334916624 10746810368 1382891184 14.442 100 62 121 1 1437772384 39577520 15303680
23:52:15 11107 8192000000 10324897792 10753384448 1390561408 14.511 100 36 70 0 1434432976 34847216 9024352
23:53:28 43446 8192000000 10317632016 10756558848 1386398976 14.474 100 29 58 0 1430304288 35656352 8248960
23:55:13 64266 8192000000 10309788256 10771697664 1358431312 14.223 99 16 32 0 1410319872 46889344 4999216
23:57:24 66580 8192000000 10292748192 10724134912 1365899488 14.290 100 23 46 0 1384636624 13101808 5635328
23:59:32 67048 8192000000 10279902128 10721927168 1360886480 14.245 99 18 36 0 1383153328 18243808 4023040
00:01:42 16026 8192000000 10317976704 10752983040 1384985168 14.461 100 25 50 0 1411543936 21331504 5227264
00:02:59 123183 8192000000 10296800528 10744340480 1375875392 14.380 99 22 44 0 1396140864 15453520 4811952
00:06:14 22539 8192000000 10305417696 10740211712 1382423456 14.438 100 35 68 0 1400390896 10344176 7623264
00:07:39 15920 8192000000 10319256272 10757210112 1401317536 14.607 100 42 84 0 1420348032 8595728 10434768
00:08:57 38709 8192000000 10286592816 10748563456 1367311904 14.303 98 10 20 0 1381388560 11911584 2165072
00:10:37 18834 8192000000 10294948288 10750357504 1396174656 14.561 100 20 39 0 1411803408 11404224 4224528
00:11:56 27036 8192000000 10299302784 10750320640 1383055152 14.444 100 23 40 0 1403576032 15538064 4982816
00:14:49 42746 8192000000 10320526992 10776469504 1387357744 14.482 99 21 41 0 1418110928 26108848 4644336
00:16:47 46293 8192000000 10271943712 10705612800 1303165840 13.724 94 19 38 0 1317555248 9726944 4662464
00:18:34 55246 8192000000 10297104336 10760155136 1378870656 14.406 100 12 24 0 1401854112 20019824 2963632
00:20:31 21322 8192000000 10311098096 10737852416 1369157536 14.319 99 66 131 0 1395510624 11480288 14872800
00:21:57 78663 8192000000 10286500288 10724151296 1337357616 14.034 97 28 56 1 1366692816 22993952 6341248
00:24:17 22740 8192000000 10280829312 10715205632 1334606176 14.009 98 33 66 0 1351085664 9428080 7051408
00:25:47 63919 8192000000 10283334688 10724872192 1318326672 13.862 96 23 45 0 1339874496 16786992 4760832
00:27:52 96297 8192000000 10268185984 10717581312 1313138400 13.815 96 32 64 0 1330004992 9509216 7357376
00:30:29 22185 8192000000 10254327808 10687709184 1324423120 13.917 98 40 80 1 1344183264 10603216 9156928
00:31:58 32769 8192000000 10245748160 10704703488 1347620096 14.126 99 29 58 0 1364937888 10583168 6734624
00:33:32 33929 8192000000 10261584480 10717315072 1367397264 14.304 100 12 24 1 1375819232 5620128 2801840
00:35:07 67294 8192000000 10258818272 10704662528 1333569312 13.999 97 17 34 0 1346539712 9114928 3855472
00:39:06 11379 8192000000 10262795792 10701975552 1343246320 14.087 99 40 81 0 1362227200 10823600 8157280
00:40:19 56553 8192000000 10287336800 10732666880 1356181280 14.203 98 19 38 0 1376801776 16318640 4301856
00:42:16 56585 8192000000 10278551808 10713624576 1331929776 13.985 97 26 49 0 1345665088 8073808 5661504
00:44:16 44244 8192000000 10285581632 10734292992 1369354592 14.321 99 21 42 0 1385220352 11359856 4505904
00:46:33 49603 8192000000 10287418544 10740736000 1370346256 14.330 99 20 40 0 1385579440 10722304 4510880
00:48:26 89838 8192000000 10306412736 10759856128 1379652624 14.413 99 13 26 0 1400054416 17901856 2499936
00:51:03 58294 8192000000 10303025440 10757971968 1369703568 14.324 98 13 26 0 1387754304 15455744 2594992
00:53:01 60038 8192000000 10294927168 10744733696 1360883936 14.245 98 31 62 0 1374664352 6786656 6993760
00:55:08 9916 8192000000 10296826160 10740965376 1374578128 14.368 99 37 74 0 1406640096 24104176 7957792
00:56:20 51698 8192000000 10277751216 10744627200 1381454672 14.430 100 15 30 0 1402194992 16971632 3768688
00:58:17 30901 8192000000 10258175328 10710953984 1348286528 14.132 98 18 36 0 1358563296 6417264 3859504
00:59:48 78579 8192000000 10264231936 10716618752 1332329792 13.988 97 10 20 1 1341281888 6767712 2184384
01:02:07 56998 8192000000 10257356976 10713513984 1337647344 14.036 98 11 22 0 1350565424 10703008 2215072
01:04:14 63384 8192000000 10256265984 10701127680 1335153296 14.014 98 15 30 0 1350843360 12193648 3496416
01:06:19 34568 8192000000 10264827568 10708656128 1348399872 14.133 99 22 42 1 1361616112 8351216 4865024
01:07:54 38102 8192000000 10249063248 10692751360 1300804800 13.703 96 17 34 0 1316066752 11669760 3592192
01:09:32 20261 8192000000 9276019968 9544024064 420524912 4.882 31 4 8 0 428154992 7037632 592448

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:14, from 29-03-2024 01:10:52 to 29-03-2024 01:11:06.

Exceptions occured during test was in run

FB_MNEMONA CNT UNIT FB_GDSCODE
except 125 v_add_invoice_to_stock 335544517
except 8 v_cancel_supplier_invoice 335544517

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

Content of mon$database and FB version 


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


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

Database statistics 

 
Database "/home/bases/oltp30-etalone.fdb" 
Gstat execution time Fri Mar 29 01:11:10 2024 
 
Database header page information: 
    Flags            0 
    Generation        93303 
    System Change Number    0 
    Page size        8192 
    ODS version        12.0 
    Oldest transaction    179034 
    Oldest active        179035 
    Oldest snapshot        179035 
    Next transaction    179036 
    Sequence number        0 
    Next attachment ID    723 
    Implementation        HW=AMD/Intel/x64 little-endian OS=Linux CC=gcc 
    Shadow count        0 
    Page buffers        0 
    Next header page    0 
    Database dialect    3 
    Creation date        Apr 3, 2020 16:41:55 
    Attributes        force write 
 
    Variable header data: 
    Sweep interval:        0 
    Unrecognized option 11, length 16 
    *END* 
 
 
Database file sequence: 
File /home/bases/oltp30-etalone.fdb is the only file 
 
Analyzing database pages ... 
AGENTS (150) 
    Primary pointer page: 496, Index root page: 497 
    Total formats: 1, used formats: 1 
    Average record length: 33.60, total records: 50 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 344.00, compression ratio: 10.24 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 31% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 1 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index AGENTS_ID_DESC (2) 
    Root page: 1504311, depth: 1, leaf buckets: 1, nodes: 50 
    Average node length: 11.82, total dup: 0, max dup: 0 
    Average key length: 10.80, compression ratio: 0.83 
    Average prefix length: 1.18, average data length: 7.82 
    Clustering factor: 1, ratio: 0.02 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index AGENTS_IS_OUR_FIRM (4) 
    Root page: 1504313, depth: 1, leaf buckets: 1, nodes: 50 
    Average node length: 3.08, total dup: 48, max dup: 48 
    Average key length: 2.04, compression ratio: 0.50 
    Average prefix length: 0.96, average data length: 0.06 
    Clustering factor: 1, ratio: 0.02 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index AGENTS_IS_SUPPLIER (3) 
    Root page: 1504312, depth: 1, leaf buckets: 1, nodes: 50 
    Average node length: 3.08, total dup: 48, max dup: 44 
    Average key length: 2.04, compression ratio: 0.54 
    Average prefix length: 1.04, average data length: 0.06 
    Clustering factor: 1, ratio: 0.02 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index AGENTS_NAME_UNQ (1) 
    Root page: 1504310, depth: 1, leaf buckets: 1, nodes: 50 
    Average node length: 17.20, total dup: 0, max dup: 0 
    Average key length: 15.88, compression ratio: 0.92 
    Average prefix length: 1.42, average data length: 13.20 
    Clustering factor: 1, ratio: 0.02 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PK_AGENTS (0) 
    Root page: 1504309, depth: 1, leaf buckets: 1, nodes: 50 
    Average node length: 11.82, total dup: 0, max dup: 0 
    Average key length: 10.80, compression ratio: 0.83 
    Average prefix length: 1.18, average data length: 7.82 
    Clustering factor: 1, ratio: 0.02 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
BUSINESS_OPS (154) 
    Primary pointer page: 504, Index root page: 505 
    Total formats: 1, used formats: 1 
    Average record length: 108.20, total records: 20 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1235.00, compression ratio: 11.41 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 31% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 1 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index BO_UNIT_UNQ (1) 
    Root page: 1504242, depth: 1, leaf buckets: 1, nodes: 20 
    Average node length: 18.25, total dup: 0, max dup: 0 
    Average key length: 17.20, compression ratio: 1.24 
    Average prefix length: 7.05, average data length: 14.25 
    Clustering factor: 1, ratio: 0.05 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index BUSINESS_OPS_PREDICT_PRIOR (3) 
    Root page: 1504244, depth: 1, leaf buckets: 1, nodes: 20 
    Average node length: 5.40, total dup: 0, max dup: 0 
    Average key length: 4.35, compression ratio: 0.67 
    Average prefix length: 1.20, average data length: 1.70 
    Clustering factor: 1, ratio: 0.05 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index BUSINESS_OPS_RND_WGTH (2) 
    Root page: 1504243, depth: 1, leaf buckets: 1, nodes: 20 
    Average node length: 4.30, total dup: 6, max dup: 3 
    Average key length: 3.25, compression ratio: 0.72 
    Average prefix length: 1.35, average data length: 1.00 
    Clustering factor: 1, ratio: 0.05 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index RDB$1 (0) 
    Root page: 1504241, depth: 1, leaf buckets: 1, nodes: 20 
    Average node length: 5.20, total dup: 0, max dup: 0 
    Average key length: 4.15, compression ratio: 0.65 
    Average prefix length: 1.10, average data length: 1.60 
    Clustering factor: 1, ratio: 0.05 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
DOC_DATA (139) 
    Primary pointer page: 474, Index root page: 475 
    Total formats: 1, used formats: 1 
    Average record length: 47.08, total records: 7816229 
    Average version length: 48.17, total versions: 133236, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 64.00, compression ratio: 1.36 
    Pointer pages: 54, data page slots: 86552 
    Data pages: 86552, average fill: 72% 
    Primary pages: 86552, secondary pages: 0, swept pages: 12657 
    Empty pages: 3, full pages: 78286 
    Fill distribution: 
     0 - 19% = 28 
    20 - 39% = 147 
    40 - 59% = 1861 
    60 - 79% = 84453 
    80 - 99% = 63 
 
    Index DOC_DATA_DOC_WARE_UNQ (0) 
    Root page: 1510614, depth: 3, leaf buckets: 23406, nodes: 7816229 
    Average node length: 18.91, total dup: 0, max dup: 0 
    Average key length: 15.92, compression ratio: 1.70 
    Average prefix length: 14.08, average data length: 12.92 
    Clustering factor: 1755135, ratio: 0.22 
    Fill distribution: 
         0 - 19% = 350 
        20 - 39% = 1638 
        40 - 59% = 4306 
        60 - 79% = 2360 
        80 - 99% = 14752 
 
    Index DOC_DATA_ID_DESC (1) 
    Root page: 1528118, depth: 3, leaf buckets: 13603, nodes: 7816229 
    Average node length: 11.20, total dup: 0, max dup: 0 
    Average key length: 8.21, compression ratio: 1.10 
    Average prefix length: 3.79, average data length: 5.21 
    Clustering factor: 1577146, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 1439 
        40 - 59% = 2243 
        60 - 79% = 1075 
        80 - 99% = 8845 
 
    Index FK_DOC_DATA_DOC_LIST (2) 
    Root page: 1546711, depth: 3, leaf buckets: 8401, nodes: 7816229 
    Average node length: 6.63, total dup: 5831959, max dup: 49 
    Average key length: 3.64, compression ratio: 2.47 
    Average prefix length: 7.62, average data length: 1.38 
    Clustering factor: 1570265, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 151 
        20 - 39% = 858 
        40 - 59% = 1495 
        60 - 79% = 902 
        80 - 99% = 4995 
 
DOC_LIST (138) 
    Primary pointer page: 472, Index root page: 473 
    Total formats: 1, used formats: 1 
    Average record length: 55.67, total records: 2279001 
    Average version length: 34.57, total versions: 137925, max versions: 3 
    Average fragment length: 8.00, total fragments: 1, max fragments: 1 
    Average unpacked length: 84.00, compression ratio: 1.51 
    Pointer pages: 18, data page slots: 28152 
    Data pages: 28152, average fill: 75% 
    Primary pages: 28147, secondary pages: 5, swept pages: 7029 
    Empty pages: 6, full pages: 25267 
    Fill distribution: 
     0 - 19% = 19 
    20 - 39% = 112 
    40 - 59% = 921 
    60 - 79% = 25309 
    80 - 99% = 1791 
 
    Index DOC_LIST_ID_DESC (1) 
    Root page: 1541130, depth: 3, leaf buckets: 4588, nodes: 2279001 
    Average node length: 11.40, total dup: 0, max dup: 0 
    Average key length: 8.44, compression ratio: 1.07 
    Average prefix length: 3.56, average data length: 5.44 
    Clustering factor: 708749, ratio: 0.31 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 820 
        40 - 59% = 964 
        60 - 79% = 686 
        80 - 99% = 2118 
 
    Index DOC_LIST_WORKER_OPTYPE (2) 
    Root page: 1544376, depth: 3, leaf buckets: 2521, nodes: 2282379 
    Average node length: 4.97, total dup: 2281480, max dup: 19266 
    Average key length: 2.01, compression ratio: 4.47 
    Average prefix length: 8.99, average data length: 0.01 
    Clustering factor: 1263023, ratio: 0.55 
    Fill distribution: 
         0 - 19% = 4 
        20 - 39% = 245 
        40 - 59% = 1503 
        60 - 79% = 570 
        80 - 99% = 199 
 
    Index FK_DOC_LIST_AGENTS (3) 
    Root page: 1545909, depth: 3, leaf buckets: 2031, nodes: 2279001 
    Average node length: 4.97, total dup: 2278951, max dup: 130195 
    Average key length: 2.01, compression ratio: 4.48 
    Average prefix length: 8.99, average data length: 0.01 
    Clustering factor: 1061233, ratio: 0.47 
    Fill distribution: 
         0 - 19% = 4 
        20 - 39% = 17 
        40 - 59% = 1132 
        60 - 79% = 64 
        80 - 99% = 814 
 
    Index PK_DOC_LIST (0) 
    Root page: 1538187, depth: 3, leaf buckets: 4389, nodes: 2279001 
    Average node length: 11.40, total dup: 0, max dup: 0 
    Average key length: 8.44, compression ratio: 1.07 
    Average prefix length: 3.56, average data length: 5.44 
    Clustering factor: 708749, ratio: 0.31 
    Fill distribution: 
         0 - 19% = 111 
        20 - 39% = 535 
        40 - 59% = 688 
        60 - 79% = 782 
        80 - 99% = 2273 
 
DOC_STATES (149) 
    Primary pointer page: 494, Index root page: 495 
    Total formats: 1, used formats: 1 
    Average record length: 67.50, total records: 4 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 650.00, compression ratio: 9.63 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 4% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index DOC_STATES_MCODE_UNQ (1) 
    Root page: 1504315, depth: 1, leaf buckets: 1, nodes: 4 
    Average node length: 17.75, total dup: 0, max dup: 0 
    Average key length: 16.50, compression ratio: 1.08 
    Average prefix length: 4.00, average data length: 13.75 
    Clustering factor: 1, ratio: 0.25 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index DOC_STATES_NAME_UNQ (2) 
    Root page: 1504316, depth: 1, leaf buckets: 1, nodes: 4 
    Average node length: 33.25, total dup: 0, max dup: 0 
    Average key length: 32.00, compression ratio: 0.99 
    Average prefix length: 2.50, average data length: 29.25 
    Clustering factor: 1, ratio: 0.25 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PK_DOC_STATES (0) 
    Root page: 1504314, depth: 1, leaf buckets: 1, nodes: 4 
    Average node length: 4.75, total dup: 0, max dup: 0 
    Average key length: 3.50, compression ratio: 0.86 
    Average prefix length: 1.50, average data length: 1.50 
    Clustering factor: 1, ratio: 0.25 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
FB_ERRORS (155) 
    Primary pointer page: 506, Index root page: 507 
    Total formats: 2, used formats: 2 
    Average record length: 54.76, total records: 2182 
    Average version length: 79.61, total versions: 757, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 270.43, compression ratio: 4.94 
    Pointer pages: 1, data page slots: 40 
    Data pages: 40, average fill: 70% 
    Primary pages: 40, secondary pages: 0, swept pages: 0 
    Empty pages: 7, full pages: 32 
    Fill distribution: 
     0 - 19% = 7 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 7 
    80 - 99% = 26 
 
    Index FB_ERRORS_GDS_CODE (0) 
    Root page: 382, depth: 2, leaf buckets: 2, nodes: 2182 
    Average node length: 4.40, total dup: 756, max dup: 1 
    Average key length: 2.67, compression ratio: 1.87 
    Average prefix length: 4.33, average data length: 0.67 
    Clustering factor: 1515, ratio: 0.69 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 0 
        40 - 59% = 1 
        60 - 79% = 1 
        80 - 99% = 0 
 
INVNT_SALDO (145) 
    Primary pointer page: 486, Index root page: 487 
    Total formats: 2, used formats: 1 
    Average record length: 82.41, total records: 400 
    Average version length: 22.95, total versions: 230006, max versions: 637 
    Average fragment length: 2.00, total fragments: 50, max fragments: 1 
    Average unpacked length: 104.00, compression ratio: 1.26 
    Pointer pages: 1, data page slots: 1344 
    Data pages: 1344, average fill: 86% 
    Primary pages: 13, secondary pages: 1331, swept pages: 0 
    Empty pages: 6, full pages: 1337 
    Fill distribution: 
     0 - 19% = 6 
    20 - 39% = 1 
    40 - 59% = 0 
    60 - 79% = 10 
    80 - 99% = 1327 
 
    Index PK_INVNT_SALDO (0) 
    Root page: 1510349, depth: 1, leaf buckets: 1, nodes: 400 
    Average node length: 11.22, total dup: 0, max dup: 0 
    Average key length: 10.22, compression ratio: 0.88 
    Average prefix length: 1.78, average data length: 7.22 
    Clustering factor: 326, ratio: 0.81 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 0 
        40 - 59% = 1 
        60 - 79% = 0 
        80 - 99% = 0 
 
INVNT_TURNOVER_LOG (153) 
    Primary pointer page: 502, Index root page: 503 
    Total formats: 1, used formats: 1 
    Average record length: 14.25, total records: 98773 
    Average version length: 68.28, total versions: 78162, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 88.00, compression ratio: 6.18 
    Pointer pages: 6, data page slots: 3160 
    Data pages: 1536, average fill: 79% 
    Primary pages: 1535, secondary pages: 1, swept pages: 0 
    Empty pages: 14, full pages: 1249 
    Fill distribution: 
     0 - 19% = 88 
    20 - 39% = 82 
    40 - 59% = 69 
    60 - 79% = 203 
    80 - 99% = 1094 
 
    Index INVNT_TURNOVER_LOG_WARE_DD_ID (0) 
    Root page: 1698961, depth: 3, leaf buckets: 349, nodes: 98773 
    Average node length: 13.25, total dup: 6576, max dup: 1 
    Average key length: 10.75, compression ratio: 2.51 
    Average prefix length: 19.18, average data length: 7.82 
    Clustering factor: 73886, ratio: 0.75 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 93 
        40 - 59% = 208 
        60 - 79% = 45 
        80 - 99% = 1 
 
MONEY_SALDO (141) 
    Primary pointer page: 478, Index root page: 479 
    Total formats: 1, used formats: 1 
    Average record length: 15.20, total records: 49 
    Average version length: 9.00, total versions: 19078, max versions: 1072 
    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: 72 
    Data pages: 72, average fill: 85% 
    Primary pages: 6, secondary pages: 66, swept pages: 0 
    Empty pages: 5, full pages: 66 
    Fill distribution: 
     0 - 19% = 5 
    20 - 39% = 1 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 66 
 
    Index PK_MONEY_SALDO (0) 
    Root page: 1510361, depth: 1, leaf buckets: 1, nodes: 49 
    Average node length: 11.82, total dup: 0, max dup: 0 
    Average key length: 10.80, compression ratio: 0.83 
    Average prefix length: 1.18, average data length: 7.82 
    Clustering factor: 1, ratio: 0.02 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
MONEY_TURNOVER_LOG (140) 
    Primary pointer page: 476, Index root page: 477 
    Total formats: 1, used formats: 1 
    Average record length: 2.11, total records: 1273 
    Average version length: 43.15, total versions: 1213, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 58.00, compression ratio: 27.47 
    Pointer pages: 1, data page slots: 32 
    Data pages: 29, average fill: 43% 
    Primary pages: 26, secondary pages: 3, swept pages: 1 
    Empty pages: 8, full pages: 10 
    Fill distribution: 
     0 - 19% = 11 
    20 - 39% = 4 
    40 - 59% = 3 
    60 - 79% = 2 
    80 - 99% = 9 
 
    Index MONEY_TURNOVER_LOG_AGENT_OPTYPE (0) 
    Root page: 91102, depth: 2, leaf buckets: 3, nodes: 1273 
    Average node length: 4.40, total dup: 1175, max dup: 132 
    Average key length: 2.83, compression ratio: 6.72 
    Average prefix length: 18.25, average data length: 0.75 
    Clustering factor: 693, ratio: 0.54 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 2 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
MON_CACHE_MEMORY (165) 
    Primary pointer page: 526, Index root page: 527 
    Total formats: 2, used formats: 1 
    Average record length: 97.03, total records: 75 
    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: 52% 
    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% = 0 
    80 - 99% = 1 
 
    Index PK_MON_CACHE_MEMORY (0) 
    Root page: 1504215, depth: 1, leaf buckets: 1, nodes: 75 
    Average node length: 11.68, total dup: 0, max dup: 0 
    Average key length: 10.67, compression ratio: 0.84 
    Average prefix length: 1.32, average data length: 7.68 
    Clustering factor: 2, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
MON_LOG (162) 
    Primary pointer page: 520, Index root page: 521 
    Total formats: 2, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index MON_LOG_DTS (4) 
    Root page: 1504229, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index MON_LOG_GDSCODE (2) 
    Root page: 1504227, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index MON_LOG_ROWSET_DESC (1) 
    Root page: 1504226, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index MON_LOG_UNIT (3) 
    Root page: 1504228, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PK_MON_LOG (0) 
    Root page: 1504225, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
MON_LOG_TABLE_STATS (163) 
    Primary pointer page: 522, Index root page: 523 
    Total formats: 2, used formats: 1 
    Average record length: 67.13, total records: 30 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 611.00, compression ratio: 9.10 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 31% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 1 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index MON_LOG_TABLE_STATS_DTS (4) 
    Root page: 1504224, depth: 1, leaf buckets: 1, nodes: 30 
    Average node length: 3.50, total dup: 23, max dup: 4 
    Average key length: 2.47, compression ratio: 3.24 
    Average prefix length: 7.53, average data length: 0.47 
    Clustering factor: 1, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index MON_LOG_TABLE_STATS_GDSCODE (2) 
    Root page: 1504222, depth: 1, leaf buckets: 1, nodes: 30 
    Average node length: 2.00, total dup: 29, max dup: 29 
    Average key length: 1.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 1, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index MON_LOG_TABLE_STATS_ROWSET (1) 
    Root page: 1504221, depth: 1, leaf buckets: 1, nodes: 30 
    Average node length: 3.33, total dup: 29, max dup: 29 
    Average key length: 2.30, compression ratio: 3.91 
    Average prefix length: 8.70, average data length: 0.30 
    Clustering factor: 1, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index MON_LOG_TABLE_STATS_TN_UNIT (3) 
    Root page: 1504223, depth: 1, leaf buckets: 1, nodes: 30 
    Average node length: 12.90, total dup: 0, max dup: 0 
    Average key length: 11.87, compression ratio: 1.42 
    Average prefix length: 7.63, average data length: 9.20 
    Clustering factor: 1, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PK_MON_LOG_TABLE_STATS (0) 
    Root page: 1504220, depth: 1, leaf buckets: 1, nodes: 30 
    Average node length: 8.37, total dup: 0, max dup: 0 
    Average key length: 7.33, compression ratio: 1.23 
    Average prefix length: 4.63, average data length: 4.37 
    Clustering factor: 1, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
OPTYPES (136) 
    Primary pointer page: 468, Index root page: 469 
    Total formats: 2, used formats: 1 
    Average record length: 67.56, total records: 9 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 386.00, compression ratio: 5.71 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 9% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index OPTYPES_MCODE_UNQ (1) 
    Root page: 1544805, depth: 1, leaf buckets: 1, nodes: 9 
    Average node length: 8.56, total dup: 0, max dup: 0 
    Average key length: 6.89, compression ratio: 0.73 
    Average prefix length: 0.44, average data length: 4.56 
    Clustering factor: 1, ratio: 0.11 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PK_OPTYPES (0) 
    Root page: 1544804, depth: 1, leaf buckets: 1, nodes: 9 
    Average node length: 6.11, total dup: 0, max dup: 0 
    Average key length: 5.00, compression ratio: 0.60 
    Average prefix length: 0.89, average data length: 2.11 
    Clustering factor: 1, ratio: 0.11 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
PDISTR (146) 
    Primary pointer page: 488, Index root page: 489 
    Total formats: 1, used formats: 1 
    Average record length: 35.84, total records: 813519 
    Average version length: 25.17, total versions: 80507, max versions: 5 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 54.00, compression ratio: 1.51 
    Pointer pages: 5, data page slots: 7936 
    Data pages: 7936, average fill: 72% 
    Primary pages: 7920, secondary pages: 16, swept pages: 937 
    Empty pages: 6, full pages: 7384 
    Fill distribution: 
     0 - 19% = 11 
    20 - 39% = 19 
    40 - 59% = 62 
    60 - 79% = 7518 
    80 - 99% = 326 
 
    Index PDISTR_AGENT_ID (2) 
    Root page: 1509308, depth: 2, leaf buckets: 898, nodes: 813519 
    Average node length: 4.87, total dup: 813470, max dup: 152951 
    Average key length: 2.01, compression ratio: 4.48 
    Average prefix length: 8.99, average data length: 0.01 
    Clustering factor: 90629, ratio: 0.11 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 135 
        40 - 59% = 495 
        60 - 79% = 208 
        80 - 99% = 59 
 
    Index PDISTR_SNDOP_RCVOP_SNDID_ASC (0) 
    Root page: 1508613, depth: 3, leaf buckets: 955, nodes: 813519 
    Average node length: 5.88, total dup: 724261, max dup: 42 
    Average key length: 3.02, compression ratio: 7.29 
    Average prefix length: 21.09, average data length: 0.91 
    Clustering factor: 162755, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 4 
        20 - 39% = 78 
        40 - 59% = 469 
        60 - 79% = 121 
        80 - 99% = 283 
 
    Index PDISTR_SNDOP_RCVOP_SNDID_DESC (1) 
    Root page: 1509187, depth: 3, leaf buckets: 995, nodes: 813519 
    Average node length: 5.88, total dup: 724261, max dup: 42 
    Average key length: 3.02, compression ratio: 7.29 
    Average prefix length: 21.09, average data length: 0.91 
    Clustering factor: 164767, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 178 
        40 - 59% = 421 
        60 - 79% = 100 
        80 - 99% = 296 
 
    Index PDISTR_WORKER_SND_ID (3) 
    Root page: 1510178, depth: 3, leaf buckets: 1155, nodes: 813519 
    Average node length: 5.96, total dup: 724261, max dup: 42 
    Average key length: 3.10, compression ratio: 5.48 
    Average prefix length: 16.01, average data length: 0.99 
    Clustering factor: 157354, ratio: 0.19 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 235 
        40 - 59% = 619 
        60 - 79% = 213 
        80 - 99% = 86 
 
PERF_AGG (158) 
    Primary pointer page: 512, Index root page: 513 
    Total formats: 1, used formats: 1 
    Average record length: 62.80, total records: 5493 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 2.78, total fragments: 87, max fragments: 1 
    Average unpacked length: 379.00, compression ratio: 6.03 
    Pointer pages: 1, data page slots: 96 
    Data pages: 95, average fill: 58% 
    Primary pages: 76, secondary pages: 19, swept pages: 46 
    Empty pages: 10, full pages: 66 
    Fill distribution: 
     0 - 19% = 24 
    20 - 39% = 0 
    40 - 59% = 2 
    60 - 79% = 69 
    80 - 99% = 0 
 
    Index PERF_AGG_UNQ (1) 
    Root page: 1504238, depth: 2, leaf buckets: 6, nodes: 5493 
    Average node length: 5.50, total dup: 0, max dup: 0 
    Average key length: 3.57, compression ratio: 10.08 
    Average prefix length: 34.48, average data length: 1.54 
    Clustering factor: 5199, ratio: 0.95 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 0 
        40 - 59% = 4 
        60 - 79% = 1 
        80 - 99% = 1 
 
    Index PK_PERF_AGG (0) 
    Root page: 1504233, depth: 2, leaf buckets: 10, nodes: 5493 
    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: 162, 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: 1504218, Index root page: 1504219 
    Total formats: 1, used formats: 1 
    Average record length: 39.09, total records: 81274 
    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: 784 
    Data pages: 784, average fill: 71% 
    Primary pages: 784, secondary pages: 0, swept pages: 0 
    Empty pages: 1, full pages: 782 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 1 
    40 - 59% = 0 
    60 - 79% = 782 
    80 - 99% = 0 
 
    Index PK_PERF_ESTIMATED (0) 
    Root page: 34619, depth: 2, leaf buckets: 103, nodes: 81274 
    Average node length: 10.16, total dup: 0, max dup: 0 
    Average key length: 8.17, compression ratio: 1.10 
    Average prefix length: 3.83, average data length: 5.17 
    Clustering factor: 3292, ratio: 0.04 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 0 
        40 - 59% = 1 
        60 - 79% = 0 
        80 - 99% = 102 
 
PERF_ISQL_STAT (156) 
    Primary pointer page: 508, Index root page: 509 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index PERF_ISQL_STAT_TRN (0) 
    Root page: 1504239, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
PERF_LOG (159) 
    Primary pointer page: 514, Index root page: 515 
    Total formats: 1, used formats: 1 
    Average record length: 110.54, total records: 72 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1691.00, compression ratio: 15.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: 573, Index root page: 574 
    Total formats: 1, used formats: 1 
    Average record length: 148.29, total records: 161067 
    Average version length: 152.59, total versions: 2962, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.44 
    Pointer pages: 7, data page slots: 4504 
    Data pages: 3848, average fill: 86% 
    Primary pages: 3848, secondary pages: 0, swept pages: 4 
    Empty pages: 27, full pages: 3814 
    Fill distribution: 
     0 - 19% = 28 
    20 - 39% = 4 
    40 - 59% = 1 
    60 - 79% = 1 
    80 - 99% = 3814 
 
PERF_SPLIT_1 (282) 
    Primary pointer page: 576, Index root page: 577 
    Total formats: 1, used formats: 1 
    Average record length: 148.81, total records: 154626 
    Average version length: 150.08, total versions: 1909, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.40 
    Pointer pages: 8, data page slots: 3928 
    Data pages: 3688, average fill: 86% 
    Primary pages: 3688, secondary pages: 0, swept pages: 7 
    Empty pages: 27, full pages: 3650 
    Fill distribution: 
     0 - 19% = 27 
    20 - 39% = 6 
    40 - 59% = 1 
    60 - 79% = 3 
    80 - 99% = 3651 
 
PERF_SPLIT_2 (283) 
    Primary pointer page: 578, Index root page: 579 
    Total formats: 1, used formats: 1 
    Average record length: 149.00, total records: 157973 
    Average version length: 152.35, total versions: 2222, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.38 
    Pointer pages: 7, data page slots: 4048 
    Data pages: 3792, average fill: 86% 
    Primary pages: 3792, secondary pages: 0, swept pages: 2 
    Empty pages: 38, full pages: 3738 
    Fill distribution: 
     0 - 19% = 40 
    20 - 39% = 5 
    40 - 59% = 4 
    60 - 79% = 6 
    80 - 99% = 3737 
 
PERF_SPLIT_3 (284) 
    Primary pointer page: 580, Index root page: 581 
    Total formats: 1, used formats: 1 
    Average record length: 148.00, total records: 161351 
    Average version length: 153.00, total versions: 3137, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.46 
    Pointer pages: 6, data page slots: 4432 
    Data pages: 3880, average fill: 86% 
    Primary pages: 3880, secondary pages: 0, swept pages: 5 
    Empty pages: 54, full pages: 3817 
    Fill distribution: 
     0 - 19% = 57 
    20 - 39% = 1 
    40 - 59% = 4 
    60 - 79% = 1 
    80 - 99% = 3817 
 
PERF_SPLIT_4 (285) 
    Primary pointer page: 582, Index root page: 583 
    Total formats: 1, used formats: 1 
    Average record length: 150.91, total records: 144978 
    Average version length: 136.61, total versions: 123, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.24 
    Pointer pages: 7, data page slots: 3536 
    Data pages: 3464, average fill: 86% 
    Primary pages: 3463, secondary pages: 1, swept pages: 3 
    Empty pages: 24, full pages: 3430 
    Fill distribution: 
     0 - 19% = 26 
    20 - 39% = 2 
    40 - 59% = 2 
    60 - 79% = 3 
    80 - 99% = 3431 
 
PERF_SPLIT_5 (286) 
    Primary pointer page: 584, Index root page: 585 
    Total formats: 1, used formats: 1 
    Average record length: 128.37, total records: 180246 
    Average version length: 154.75, total versions: 27107, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 13.21 
    Pointer pages: 9, data page slots: 4976 
    Data pages: 4352, average fill: 87% 
    Primary pages: 4351, secondary pages: 1, swept pages: 2 
    Empty pages: 56, full pages: 4280 
    Fill distribution: 
     0 - 19% = 58 
    20 - 39% = 7 
    40 - 59% = 4 
    60 - 79% = 3 
    80 - 99% = 4280 
 
PERF_SPLIT_6 (287) 
    Primary pointer page: 586, Index root page: 587 
    Total formats: 1, used formats: 1 
    Average record length: 134.47, total records: 170001 
    Average version length: 154.77, total versions: 18637, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 12.61 
    Pointer pages: 6, data page slots: 4920 
    Data pages: 4168, average fill: 85% 
    Primary pages: 4168, secondary pages: 0, swept pages: 4 
    Empty pages: 116, full pages: 4023 
    Fill distribution: 
     0 - 19% = 120 
    20 - 39% = 7 
    40 - 59% = 11 
    60 - 79% = 6 
    80 - 99% = 4024 
 
PERF_SPLIT_7 (288) 
    Primary pointer page: 588, Index root page: 589 
    Total formats: 1, used formats: 1 
    Average record length: 148.89, total records: 171210 
    Average version length: 151.96, total versions: 2535, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.39 
    Pointer pages: 7, data page slots: 4832 
    Data pages: 4136, average fill: 85% 
    Primary pages: 4136, secondary pages: 0, swept pages: 9 
    Empty pages: 68, full pages: 4053 
    Fill distribution: 
     0 - 19% = 73 
    20 - 39% = 2 
    40 - 59% = 6 
    60 - 79% = 5 
    80 - 99% = 4050 
 
PERF_SPLIT_8 (289) 
    Primary pointer page: 590, Index root page: 591 
    Total formats: 1, used formats: 1 
    Average record length: 148.15, total records: 153436 
    Average version length: 151.80, total versions: 2749, 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: 6, data page slots: 4376 
    Data pages: 3696, average fill: 85% 
    Primary pages: 3696, secondary pages: 0, swept pages: 2 
    Empty pages: 53, full pages: 3620 
    Fill distribution: 
     0 - 19% = 53 
    20 - 39% = 8 
    40 - 59% = 5 
    60 - 79% = 10 
    80 - 99% = 3620 
 
PERF_SPLIT_9 (290) 
    Primary pointer page: 593, Index root page: 594 
    Total formats: 1, used formats: 1 
    Average record length: 148.17, total records: 163544 
    Average version length: 152.17, total versions: 3282, 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: 6, data page slots: 4920 
    Data pages: 3952, average fill: 85% 
    Primary pages: 3952, secondary pages: 0, swept pages: 3 
    Empty pages: 48, full pages: 3857 
    Fill distribution: 
     0 - 19% = 50 
    20 - 39% = 12 
    40 - 59% = 27 
    60 - 79% = 7 
    80 - 99% = 3856 
 
PHRASES (143) 
    Primary pointer page: 482, Index root page: 483 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index PHRASES_ID_DESC (3) 
    Root page: 1510354, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PHRASES_NAME (2) 
    Root page: 1510353, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PHRASES_UNQ (1) 
    Root page: 1510352, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PK_PHRASES (0) 
    Root page: 1510351, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
PSTORNED (147) 
    Primary pointer page: 490, Index root page: 491 
    Total formats: 1, used formats: 1 
    Average record length: 51.52, total records: 2117742 
    Average version length: 52.95, total versions: 49505, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 70.00, compression ratio: 1.36 
    Pointer pages: 16, data page slots: 25264 
    Data pages: 25256, average fill: 72% 
    Primary pages: 25256, secondary pages: 0, swept pages: 9378 
    Empty pages: 172, full pages: 21886 
    Fill distribution: 
     0 - 19% = 349 
    20 - 39% = 302 
    40 - 59% = 837 
    60 - 79% = 23294 
    80 - 99% = 474 
 
    Index PSTORNED_RCV_ID (1) 
    Root page: 1506186, depth: 3, leaf buckets: 2580, nodes: 2117742 
    Average node length: 5.44, total dup: 1976899, max dup: 1663 
    Average key length: 2.48, compression ratio: 3.62 
    Average prefix length: 8.58, average data length: 0.42 
    Clustering factor: 183807, ratio: 0.09 
    Fill distribution: 
         0 - 19% = 4 
        20 - 39% = 291 
        40 - 59% = 1665 
        60 - 79% = 311 
        80 - 99% = 309 
 
    Index PSTORNED_SND_ID (0) 
    Root page: 1504819, depth: 3, leaf buckets: 2763, nodes: 2117742 
    Average node length: 5.69, total dup: 1901024, max dup: 63 
    Average key length: 2.74, compression ratio: 3.29 
    Average prefix length: 8.36, average data length: 0.64 
    Clustering factor: 379104, ratio: 0.18 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 5 
        40 - 59% = 2369 
        60 - 79% = 367 
        80 - 99% = 21 
 
    Index PSTORNED_WORKER_ID (2) 
    Root page: 1507996, depth: 3, leaf buckets: 2182, nodes: 2117742 
    Average node length: 4.96, total dup: 2117642, max dup: 27748 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.41, average data length: 0.00 
    Clustering factor: 181211, ratio: 0.09 
    Fill distribution: 
         0 - 19% = 3 
        20 - 39% = 184 
        40 - 59% = 1202 
        60 - 79% = 408 
        80 - 99% = 385 
 
RULES_FOR_PDISTR (148) 
    Primary pointer page: 492, Index root page: 493 
    Total formats: 1, used formats: 1 
    Average record length: 17.00, total records: 4 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 334.00, compression ratio: 19.65 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 2% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index RULES_FOR_PDISTR_UNQ (0) 
    Root page: 1504317, depth: 1, leaf buckets: 1, nodes: 4 
    Average node length: 11.50, total dup: 0, max dup: 0 
    Average key length: 10.25, compression ratio: 0.88 
    Average prefix length: 1.50, average data length: 7.50 
    Clustering factor: 1, ratio: 0.25 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
RULES_FOR_QDISTR (137) 
    Primary pointer page: 470, Index root page: 471 
    Total formats: 1, used formats: 1 
    Average record length: 32.71, total records: 7 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 332.00, compression ratio: 10.15 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 4% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index RULES_FOR_QDISTR_RCVOP (1) 
    Root page: 1544803, depth: 1, leaf buckets: 1, nodes: 7 
    Average node length: 5.29, total dup: 2, max dup: 2 
    Average key length: 4.14, compression ratio: 0.72 
    Average prefix length: 1.43, average data length: 1.57 
    Clustering factor: 1, ratio: 0.14 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index RULES_FOR_QDISTR_UNQ (0) 
    Root page: 1544802, depth: 1, leaf buckets: 1, nodes: 7 
    Average node length: 10.14, total dup: 0, max dup: 0 
    Average key length: 8.86, compression ratio: 0.94 
    Average prefix length: 2.14, average data length: 6.14 
    Clustering factor: 1, ratio: 0.14 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
SEMAPHORES (152) 
    Primary pointer page: 500, Index root page: 501 
    Total formats: 1, used formats: 1 
    Average record length: 43.40, total records: 5 
    Average version length: 9.00, total versions: 1, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 346.00, compression ratio: 7.97 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 4% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index PK_SEMAPHORES (0) 
    Root page: 1504305, depth: 1, leaf buckets: 1, nodes: 5 
    Average node length: 12.40, total dup: 0, max dup: 0 
    Average key length: 11.00, compression ratio: 0.82 
    Average prefix length: 0.60, average data length: 8.40 
    Clustering factor: 1, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index SEMAPHORES_TASK_UNQ (1) 
    Root page: 1504306, depth: 1, leaf buckets: 1, nodes: 5 
    Average node length: 23.40, total dup: 0, max dup: 0 
    Average key length: 22.00, compression ratio: 1.07 
    Average prefix length: 4.20, average data length: 19.40 
    Clustering factor: 1, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
SETTINGS (135) 
    Primary pointer page: 466, Index root page: 467 
    Total formats: 1, used formats: 1 
    Average record length: 97.63, total records: 149 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1347.00, compression ratio: 13.80 
    Pointer pages: 1, data page slots: 3 
    Data pages: 3, average fill: 70% 
    Primary pages: 3, secondary pages: 0, swept pages: 2 
    Empty pages: 0, full pages: 2 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 1 
    60 - 79% = 0 
    80 - 99% = 2 
 
    Index SETTINGS_MCODE_WM_UNQ (1) 
    Root page: 525, depth: 1, leaf buckets: 1, nodes: 149 
    Average node length: 14.66, total dup: 0, max dup: 0 
    Average key length: 13.55, compression ratio: 2.19 
    Average prefix length: 19.07, average data length: 10.66 
    Clustering factor: 48, ratio: 0.32 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 1 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index SETTINGS_MODE_CODE (0) 
    Root page: 1544806, depth: 1, leaf buckets: 1, nodes: 149 
    Average node length: 25.56, total dup: 0, max dup: 0 
    Average key length: 24.56, compression ratio: 1.63 
    Average prefix length: 18.58, average data length: 21.56 
    Clustering factor: 14, ratio: 0.09 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 0 
        40 - 59% = 1 
        60 - 79% = 0 
        80 - 99% = 0 
 
TMP$DEP_DOCS (129) 
    Primary pointer page: 454, Index root page: 455 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index TMP_DEP_DOCS_UNQ (0) 
    Root page: 1544810, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
TMP$IDX_RECALC (132) 
    Primary pointer page: 460, Index root page: 461 
    Total formats: 2, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index TMP_IDX_RECALC_IDX_NAME_UNQ (0) 
    Root page: 1544807, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
TMP$MON_LOG (133) 
    Primary pointer page: 462, Index root page: 463 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
TMP$MON_LOG_TABLE_STATS (134) 
    Primary pointer page: 464, Index root page: 465 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
TMP$PERF_EST_WHOLE (161) 
    Primary pointer page: 518, Index root page: 519 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
TMP$PERF_LOG (160) 
    Primary pointer page: 516, Index root page: 517 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index TMP$PERF_LOG_UNIT_TRN_DTS_END (0) 
    Root page: 1504230, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
TMP$PERF_MON (131) 
    Primary pointer page: 458, Index root page: 459 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
TMP$RESULT_SET (130) 
    Primary pointer page: 456, Index root page: 457 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index TMP_RESULT_SET_DOC (1) 
    Root page: 1544809, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index TMP_RESULT_SET_WARE_DOC (0) 
    Root page: 1544808, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
TMP$SHOPPING_CART (128) 
    Primary pointer page: 452, Index root page: 453 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index TMP_SHOPCART_UNQ (0) 
    Root page: 1544811, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
TPAUSE (166) 
    Primary pointer page: 528, Index root page: 529 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index RDB$PRIMARY2 (0) 
    Root page: 1504214, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
TRACE_STAT (157) 
    Primary pointer page: 510, Index root page: 511 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
WARES (142) 
    Primary pointer page: 480, Index root page: 481 
    Total formats: 1, used formats: 1 
    Average record length: 77.52, total records: 400 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 444.00, compression ratio: 5.73 
    Pointer pages: 1, data page slots: 6 
    Data pages: 6, average fill: 77% 
    Primary pages: 6, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 5 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 5 
    80 - 99% = 1 
 
    Index FK_WARES_WARE_GROUPS (3) 
    Root page: 1552159, depth: 1, leaf buckets: 1, nodes: 400 
    Average node length: 3.17, total dup: 392, max dup: 60 
    Average key length: 2.16, compression ratio: 4.16 
    Average prefix length: 8.86, average data length: 0.14 
    Clustering factor: 48, ratio: 0.12 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PK_WARES (0) 
    Root page: 1510355, depth: 1, leaf buckets: 1, nodes: 400 
    Average node length: 11.22, total dup: 0, max dup: 0 
    Average key length: 10.22, compression ratio: 0.88 
    Average prefix length: 1.78, average data length: 7.22 
    Clustering factor: 344, ratio: 0.86 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 0 
        40 - 59% = 1 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index WARES_ID_DESC (2) 
    Root page: 1510360, depth: 1, leaf buckets: 1, nodes: 400 
    Average node length: 11.22, total dup: 0, max dup: 0 
    Average key length: 10.22, compression ratio: 0.88 
    Average prefix length: 1.78, average data length: 7.22 
    Clustering factor: 344, ratio: 0.86 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 0 
        40 - 59% = 1 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index WARES_NUMB_UNQ (1) 
    Root page: 1510358, depth: 2, leaf buckets: 3, nodes: 400 
    Average node length: 53.25, total dup: 0, max dup: 0 
    Average key length: 52.23, compression ratio: 1.00 
    Average prefix length: 2.74, average data length: 49.25 
    Clustering factor: 355, ratio: 0.89 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 1 
        80 - 99% = 2 
 
WARE_GROUPS (151) 
    Primary pointer page: 498, Index root page: 499 
    Total formats: 1, used formats: 1 
    Average record length: 32.12, total records: 8 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 346.00, compression ratio: 10.77 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 5% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index PK_WARE_GROUPS (0) 
    Root page: 1504307, depth: 1, leaf buckets: 1, nodes: 8 
    Average node length: 11.25, total dup: 0, max dup: 0 
    Average key length: 10.12, compression ratio: 0.89 
    Average prefix length: 1.75, average data length: 7.25 
    Clustering factor: 1, ratio: 0.12 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index WARE_GROUPS_NAME_UNQ (1) 
    Root page: 1504308, depth: 1, leaf buckets: 1, nodes: 8 
    Average node length: 19.88, total dup: 0, max dup: 0 
    Average key length: 18.12, compression ratio: 0.89 
    Average prefix length: 0.25, average data length: 15.88 
    Clustering factor: 1, ratio: 0.12 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
XQD_1000_1200 (176) 
    Primary pointer page: 549, Index root page: 550 
    Total formats: 1, used formats: 1 
    Average record length: 35.42, total records: 152876 
    Average version length: 69.20, total versions: 74694, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 3.56 
    Pointer pages: 3, data page slots: 3560 
    Data pages: 2688, average fill: 66% 
    Primary pages: 2687, secondary pages: 1, swept pages: 212 
    Empty pages: 311, full pages: 1960 
    Fill distribution: 
     0 - 19% = 426 
    20 - 39% = 64 
    40 - 59% = 86 
    60 - 79% = 813 
    80 - 99% = 1299 
 
    Index XQD_1000_1200_WA_SO_RO_WKR_SND (0) 
    Root page: 1554682, depth: 3, leaf buckets: 214, nodes: 152876 
    Average node length: 6.44, total dup: 133111, max dup: 23 
    Average key length: 3.93, compression ratio: 10.68 
    Average prefix length: 40.19, average data length: 1.81 
    Clustering factor: 25476, ratio: 0.17 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 21 
        40 - 59% = 106 
        60 - 79% = 59 
        80 - 99% = 27 
 
XQD_1000_3300 (178) 
    Primary pointer page: 553, Index root page: 554 
    Total formats: 1, used formats: 1 
    Average record length: 64.30, total records: 7149510 
    Average version length: 68.76, total versions: 482918, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.96 
    Pointer pages: 62, data page slots: 100064 
    Data pages: 100064, average fill: 76% 
    Primary pages: 100064, secondary pages: 0, swept pages: 17454 
    Empty pages: 57, full pages: 92229 
    Fill distribution: 
     0 - 19% = 297 
    20 - 39% = 655 
    40 - 59% = 2294 
    60 - 79% = 85427 
    80 - 99% = 11391 
 
    Index XQD_1000_3300_WA_SO_RO_WKR_SND (0) 
    Root page: 1480454, depth: 3, leaf buckets: 10725, nodes: 7149510 
    Average node length: 6.51, total dup: 6184962, max dup: 35 
    Average key length: 3.52, compression ratio: 11.93 
    Average prefix length: 40.61, average data length: 1.39 
    Clustering factor: 1587143, ratio: 0.22 
    Fill distribution: 
         0 - 19% = 10 
        20 - 39% = 1473 
        40 - 59% = 5916 
        60 - 79% = 2843 
        80 - 99% = 483 
 
    Index XQD_1000_3300_WKR_DOC_ASC (1) 
    Root page: 1486068, depth: 3, leaf buckets: 8611, nodes: 7149510 
    Average node length: 5.39, total dup: 6866116, max dup: 173 
    Average key length: 2.40, compression ratio: 7.07 
    Average prefix length: 16.63, average data length: 0.37 
    Clustering factor: 1380384, ratio: 0.19 
    Fill distribution: 
         0 - 19% = 7 
        20 - 39% = 1035 
        40 - 59% = 5088 
        60 - 79% = 1447 
        80 - 99% = 1034 
 
    Index XQD_1000_3300_WKR_DOC_DEC (2) 
    Root page: 1490608, depth: 3, leaf buckets: 8632, nodes: 7149510 
    Average node length: 5.39, total dup: 6866116, max dup: 173 
    Average key length: 2.40, compression ratio: 7.07 
    Average prefix length: 16.63, average data length: 0.37 
    Clustering factor: 1382914, ratio: 0.19 
    Fill distribution: 
         0 - 19% = 11 
        20 - 39% = 1032 
        40 - 59% = 5114 
        60 - 79% = 1435 
        80 - 99% = 1040 
 
XQD_1200_2000 (177) 
    Primary pointer page: 551, Index root page: 552 
    Total formats: 1, used formats: 1 
    Average record length: 66.56, total records: 12080823 
    Average version length: 68.72, total versions: 419528, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.89 
    Pointer pages: 102, data page slots: 166184 
    Data pages: 166184, average fill: 77% 
    Primary pages: 166184, secondary pages: 0, swept pages: 64198 
    Empty pages: 4, full pages: 162883 
    Fill distribution: 
     0 - 19% = 36 
    20 - 39% = 256 
    40 - 59% = 1104 
    60 - 79% = 155017 
    80 - 99% = 9771 
 
    Index XQD_1200_2000_WA_SO_RO_WKR_SND (0) 
    Root page: 1495028, depth: 3, leaf buckets: 18455, nodes: 12080823 
    Average node length: 6.58, total dup: 10528676, max dup: 57 
    Average key length: 3.43, compression ratio: 12.25 
    Average prefix length: 40.70, average data length: 1.30 
    Clustering factor: 2379495, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 20 
        20 - 39% = 2173 
        40 - 59% = 11110 
        60 - 79% = 4537 
        80 - 99% = 615 
 
XQD_2000_3300 (179) 
    Primary pointer page: 555, Index root page: 556 
    Total formats: 1, used formats: 1 
    Average record length: 40.35, total records: 1801172 
    Average version length: 69.13, total versions: 749916, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 3.12 
    Pointer pages: 26, data page slots: 41624 
    Data pages: 27376, average fill: 75% 
    Primary pages: 27376, secondary pages: 0, swept pages: 3348 
    Empty pages: 1149, full pages: 23302 
    Fill distribution: 
     0 - 19% = 1899 
    20 - 39% = 891 
    40 - 59% = 787 
    60 - 79% = 10546 
    80 - 99% = 13253 
 
    Index XQD_2000_3300_WA_SO_RO_WKR_SND (0) 
    Root page: 1479712, depth: 3, leaf buckets: 2143, nodes: 1801172 
    Average node length: 5.51, total dup: 1728677, max dup: 99 
    Average key length: 2.55, compression ratio: 16.49 
    Average prefix length: 41.49, average data length: 0.51 
    Clustering factor: 124302, ratio: 0.07 
    Fill distribution: 
         0 - 19% = 17 
        20 - 39% = 245 
        40 - 59% = 987 
        60 - 79% = 660 
        80 - 99% = 234 
 
XQD_2100_3300 (180) 
    Primary pointer page: 557, Index root page: 558 
    Total formats: 1, used formats: 1 
    Average record length: 37.20, total records: 1185803 
    Average version length: 69.13, total versions: 546810, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 3.39 
    Pointer pages: 20, data page slots: 31368 
    Data pages: 25752, average fill: 54% 
    Primary pages: 25751, secondary pages: 1, swept pages: 5545 
    Empty pages: 5137, full pages: 14537 
    Fill distribution: 
     0 - 19% = 7961 
    20 - 39% = 1435 
    40 - 59% = 875 
    60 - 79% = 5318 
    80 - 99% = 10163 
 
    Index XQD_2100_3300_WA_SO_RO_WKR_SND (0) 
    Root page: 1479207, depth: 3, leaf buckets: 1520, nodes: 1185803 
    Average node length: 5.78, total dup: 1108333, max dup: 149 
    Average key length: 2.84, compression ratio: 14.80 
    Average prefix length: 41.23, average data length: 0.77 
    Clustering factor: 158637, ratio: 0.13 
    Fill distribution: 
         0 - 19% = 5 
        20 - 39% = 245 
        40 - 59% = 678 
        60 - 79% = 429 
        80 - 99% = 163 
 
XQD_3300_3400 (181) 
    Primary pointer page: 559, Index root page: 560 
    Total formats: 1, used formats: 1 
    Average record length: 65.00, total records: 9325657 
    Average version length: 68.97, total versions: 527952, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.94 
    Pointer pages: 87, data page slots: 141968 
    Data pages: 141928, average fill: 70% 
    Primary pages: 141928, secondary pages: 0, swept pages: 46252 
    Empty pages: 482, full pages: 89335 
    Fill distribution: 
     0 - 19% = 1267 
    20 - 39% = 5061 
    40 - 59% = 18190 
    60 - 79% = 107747 
    80 - 99% = 9663 
 
    Index XQD_3300_3400_WA_SO_RO_WKR_SND (0) 
    Root page: 1472590, depth: 3, leaf buckets: 13460, nodes: 9325657 
    Average node length: 6.67, total dup: 7737650, max dup: 27 
    Average key length: 3.66, compression ratio: 11.46 
    Average prefix length: 40.51, average data length: 1.49 
    Clustering factor: 2032911, ratio: 0.22 
    Fill distribution: 
         0 - 19% = 3 
        20 - 39% = 1140 
        40 - 59% = 6711 
        60 - 79% = 4872 
        80 - 99% = 734 
 
XQS_1000_1200 (182) 
    Primary pointer page: 561, Index root page: 562 
    Total formats: 1, used formats: 1 
    Average record length: 82.46, total records: 21161244 
    Average version length: 83.02, total versions: 19350, 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: 318752 
    Data pages: 318752, average fill: 81% 
    Primary pages: 318752, secondary pages: 0, swept pages: 11445 
    Empty pages: 4, full pages: 318747 
    Fill distribution: 
     0 - 19% = 4 
    20 - 39% = 0 
    40 - 59% = 1 
    60 - 79% = 26855 
    80 - 99% = 291892 
 
    Index XQS_1000_1200_DOC_ID (1) 
    Root page: 1426716, depth: 3, leaf buckets: 19477, nodes: 21161244 
    Average node length: 5.72, total dup: 20680090, max dup: 145 
    Average key length: 2.16, compression ratio: 4.16 
    Average prefix length: 8.86, average data length: 0.14 
    Clustering factor: 3281892, ratio: 0.16 
    Fill distribution: 
         0 - 19% = 3 
        20 - 39% = 1 
        40 - 59% = 8353 
        60 - 79% = 507 
        80 - 99% = 10613 
 
    Index XQS_1000_1200_RCV_ID (3) 
    Root page: 1456980, depth: 3, leaf buckets: 17157, nodes: 21161244 
    Average node length: 6.31, total dup: 18595638, max dup: 49 
    Average key length: 2.75, compression ratio: 3.27 
    Average prefix length: 8.37, average data length: 0.63 
    Clustering factor: 914357, ratio: 0.04 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 3 
        40 - 59% = 754 
        60 - 79% = 252 
        80 - 99% = 16147 
 
    Index XQS_1000_1200_SND_ID (2) 
    Root page: 1441073, depth: 3, leaf buckets: 21227, nodes: 21161244 
    Average node length: 6.35, total dup: 18515526, max dup: 29 
    Average key length: 2.79, compression ratio: 3.23 
    Average prefix length: 8.34, average data length: 0.66 
    Clustering factor: 3577169, ratio: 0.17 
    Fill distribution: 
         0 - 19% = 4 
        20 - 39% = 1 
        40 - 59% = 8528 
        60 - 79% = 602 
        80 - 99% = 12092 
 
    Index XQS_1000_1200_WORKER_ID (0) 
    Root page: 1413348, depth: 3, leaf buckets: 16197, nodes: 21161244 
    Average node length: 5.56, total dup: 21161144, max dup: 232600 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.42, average data length: 0.00 
    Clustering factor: 943327, ratio: 0.04 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 13 
        40 - 59% = 3041 
        60 - 79% = 412 
        80 - 99% = 12729 
 
XQS_1000_3300 (184) 
    Primary pointer page: 565, Index root page: 566 
    Total formats: 1, used formats: 1 
    Average record length: 78.16, total records: 9757793 
    Average version length: 82.60, total versions: 504376, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.61 
    Pointer pages: 105, data page slots: 169776 
    Data pages: 169696, average fill: 71% 
    Primary pages: 169696, secondary pages: 0, swept pages: 62403 
    Empty pages: 812, full pages: 108649 
    Fill distribution: 
     0 - 19% = 1950 
    20 - 39% = 7675 
    40 - 59% = 24544 
    60 - 79% = 62213 
    80 - 99% = 73314 
 
    Index XQS_1000_3300_DOC_ID (1) 
    Root page: 1367502, depth: 3, leaf buckets: 11348, nodes: 9757793 
    Average node length: 5.36, total dup: 9448358, max dup: 222 
    Average key length: 2.23, compression ratio: 4.03 
    Average prefix length: 8.80, average data length: 0.20 
    Clustering factor: 2158935, ratio: 0.22 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 41 
        40 - 59% = 8050 
        60 - 79% = 3157 
        80 - 99% = 100 
 
    Index XQS_1000_3300_RCV_ID (3) 
    Root page: 1379261, depth: 3, leaf buckets: 13609, nodes: 9757793 
    Average node length: 6.23, total dup: 8091745, max dup: 14 
    Average key length: 3.10, compression ratio: 2.90 
    Average prefix length: 8.07, average data length: 0.93 
    Clustering factor: 1502076, ratio: 0.15 
    Fill distribution: 
         0 - 19% = 148 
        20 - 39% = 3710 
        40 - 59% = 4760 
        60 - 79% = 2554 
        80 - 99% = 2437 
 
    Index XQS_1000_3300_SND_ID (2) 
    Root page: 1373059, depth: 3, leaf buckets: 12682, nodes: 9757793 
    Average node length: 5.98, total dup: 8470487, max dup: 41 
    Average key length: 2.85, compression ratio: 3.16 
    Average prefix length: 8.28, average data length: 0.72 
    Clustering factor: 2351927, ratio: 0.24 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 67 
        40 - 59% = 9036 
        60 - 79% = 3455 
        80 - 99% = 122 
 
    Index XQS_1000_3300_WORKER_ID (0) 
    Root page: 1362767, depth: 3, leaf buckets: 10274, nodes: 9757793 
    Average node length: 5.13, total dup: 9757693, max dup: 147607 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.42, average data length: 0.00 
    Clustering factor: 1533587, ratio: 0.16 
    Fill distribution: 
         0 - 19% = 51 
        20 - 39% = 1266 
        40 - 59% = 5205 
        60 - 79% = 1739 
        80 - 99% = 2013 
 
XQS_1200_2000 (183) 
    Primary pointer page: 563, Index root page: 564 
    Total formats: 1, used formats: 1 
    Average record length: 79.53, total records: 11443830 
    Average version length: 82.53, total versions: 385944, 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: 118, data page slots: 192320 
    Data pages: 190728, average fill: 74% 
    Primary pages: 190728, secondary pages: 0, swept pages: 63558 
    Empty pages: 3300, full pages: 149187 
    Fill distribution: 
     0 - 19% = 5288 
    20 - 39% = 6858 
    40 - 59% = 15136 
    60 - 79% = 39296 
    80 - 99% = 124150 
 
    Index XQS_1200_2000_DOC_ID (1) 
    Root page: 1392101, depth: 3, leaf buckets: 13116, nodes: 11443830 
    Average node length: 5.30, total dup: 11333961, max dup: 696 
    Average key length: 2.08, compression ratio: 4.33 
    Average prefix length: 8.93, average data length: 0.07 
    Clustering factor: 2392065, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 62 
        40 - 59% = 8997 
        60 - 79% = 3890 
        80 - 99% = 167 
 
    Index XQS_1200_2000_RCV_ID (3) 
    Root page: 1406110, depth: 3, leaf buckets: 10563, nodes: 11443830 
    Average node length: 5.49, total dup: 10945166, max dup: 49 
    Average key length: 2.28, compression ratio: 3.95 
    Average prefix length: 8.77, average data length: 0.23 
    Clustering factor: 727511, ratio: 0.06 
    Fill distribution: 
         0 - 19% = 174 
        20 - 39% = 783 
        40 - 59% = 2689 
        60 - 79% = 1831 
        80 - 99% = 5086 
 
    Index XQS_1200_2000_SND_ID (2) 
    Root page: 1398638, depth: 3, leaf buckets: 15003, nodes: 11443830 
    Average node length: 6.02, total dup: 9991194, max dup: 69 
    Average key length: 2.80, compression ratio: 3.21 
    Average prefix length: 8.32, average data length: 0.68 
    Clustering factor: 2408550, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 56 
        40 - 59% = 10591 
        60 - 79% = 4157 
        80 - 99% = 198 
 
    Index XQS_1200_2000_WORKER_ID (0) 
    Root page: 1386211, depth: 3, leaf buckets: 10918, nodes: 11443830 
    Average node length: 5.22, total dup: 11443730, max dup: 190236 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.41, average data length: 0.00 
    Clustering factor: 715719, ratio: 0.06 
    Fill distribution: 
         0 - 19% = 103 
        20 - 39% = 804 
        40 - 59% = 4896 
        60 - 79% = 1590 
        80 - 99% = 3525 
 
XQS_2000_3300 (185) 
    Primary pointer page: 567, Index root page: 568 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index XQS_2000_3300_DOC_ID (1) 
    Root page: 1361753, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index XQS_2000_3300_RCV_ID (3) 
    Root page: 1361755, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index XQS_2000_3300_SND_ID (2) 
    Root page: 1361754, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index XQS_2000_3300_WORKER_ID (0) 
    Root page: 1361752, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
XQS_2100_3300 (186) 
    Primary pointer page: 569, Index root page: 570 
    Total formats: 1, used formats: 1 
    Average record length: 78.29, total records: 9900931 
    Average version length: 82.91, total versions: 533294, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.61 
    Pointer pages: 106, data page slots: 172624 
    Data pages: 172552, average fill: 71% 
    Primary pages: 172552, secondary pages: 0, swept pages: 63147 
    Empty pages: 797, full pages: 110638 
    Fill distribution: 
     0 - 19% = 1919 
    20 - 39% = 7459 
    40 - 59% = 25084 
    60 - 79% = 64697 
    80 - 99% = 73393 
 
    Index XQS_2100_3300_DOC_ID (1) 
    Root page: 1344686, depth: 3, leaf buckets: 11857, nodes: 9900931 
    Average node length: 5.17, total dup: 9872261, max dup: 2078 
    Average key length: 2.03, compression ratio: 4.43 
    Average prefix length: 8.97, average data length: 0.03 
    Clustering factor: 1985142, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 38 
        20 - 39% = 1429 
        40 - 59% = 7812 
        60 - 79% = 1911 
        80 - 99% = 667 
 
    Index XQS_2100_3300_RCV_ID (3) 
    Root page: 1355717, depth: 3, leaf buckets: 13830, nodes: 9900931 
    Average node length: 6.24, total dup: 8209306, max dup: 14 
    Average key length: 3.10, compression ratio: 2.90 
    Average prefix length: 8.07, average data length: 0.93 
    Clustering factor: 1483215, ratio: 0.15 
    Fill distribution: 
         0 - 19% = 203 
        20 - 39% = 3776 
        40 - 59% = 4781 
        60 - 79% = 2490 
        80 - 99% = 2580 
 
    Index XQS_2100_3300_SND_ID (2) 
    Root page: 1350049, depth: 3, leaf buckets: 12485, nodes: 9900931 
    Average node length: 5.43, total dup: 9460757, max dup: 99 
    Average key length: 2.28, compression ratio: 3.94 
    Average prefix length: 8.76, average data length: 0.24 
    Clustering factor: 2119978, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 16 
        20 - 39% = 1401 
        40 - 59% = 8704 
        60 - 79% = 1712 
        80 - 99% = 652 
 
    Index XQS_2100_3300_WORKER_ID (0) 
    Root page: 985805, depth: 3, leaf buckets: 10444, nodes: 9900931 
    Average node length: 5.14, total dup: 9900831, max dup: 150338 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.42, average data length: 0.00 
    Clustering factor: 1564560, ratio: 0.16 
    Fill distribution: 
         0 - 19% = 47 
        20 - 39% = 1277 
        40 - 59% = 5304 
        60 - 79% = 1785 
        80 - 99% = 2031 
 
XQS_3300_3400 (187) 
    Primary pointer page: 571, Index root page: 572 
    Total formats: 1, used formats: 1 
    Average record length: 67.30, total records: 577374 
    Average version length: 68.76, total versions: 7442, 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: 7960 
    Data pages: 7960, average fill: 76% 
    Primary pages: 7960, secondary pages: 0, swept pages: 3568 
    Empty pages: 2, full pages: 7033 
    Fill distribution: 
     0 - 19% = 4 
    20 - 39% = 17 
    40 - 59% = 154 
    60 - 79% = 7661 
    80 - 99% = 124 
 
    Index XQS_3300_3400_DOC_ID (1) 
    Root page: 37200, depth: 3, leaf buckets: 734, nodes: 577374 
    Average node length: 5.95, total dup: 491598, max dup: 83 
    Average key length: 3.09, compression ratio: 2.91 
    Average prefix length: 8.06, average data length: 0.94 
    Clustering factor: 100791, ratio: 0.17 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 29 
        40 - 59% = 515 
        60 - 79% = 94 
        80 - 99% = 96 
 
    Index XQS_3300_3400_SND_ID (2) 
    Root page: 31426, depth: 3, leaf buckets: 755, nodes: 577374 
    Average node length: 6.15, total dup: 473528, max dup: 27 
    Average key length: 3.29, compression ratio: 2.73 
    Average prefix length: 7.89, average data length: 1.11 
    Clustering factor: 100847, ratio: 0.17 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 38 
        40 - 59% = 515 
        60 - 79% = 94 
        80 - 99% = 108 
 
    Index XQS_3300_3400_WORKER_ID (0) 
    Root page: 375548, depth: 2, leaf buckets: 591, nodes: 577374 
    Average node length: 4.86, total dup: 577274, max dup: 9484 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.41, average data length: 0.00 
    Clustering factor: 89496, ratio: 0.16 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 27 
        40 - 59% = 369 
        60 - 79% = 103 
        80 - 99% = 91 
 
ZDOC_DATA (170) 
    Primary pointer page: 537, Index root page: 538 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
ZDOC_LIST (169) 
    Primary pointer page: 535, Index root page: 536 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
ZINVNT_TURNOVER_LOG (171) 
    Primary pointer page: 539, Index root page: 540 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
ZPDISTR (174) 
    Primary pointer page: 545, Index root page: 546 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index ZPDISTR_ID (0) 
    Root page: 1504207, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
ZPSTORNED (175) 
    Primary pointer page: 547, Index root page: 548 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index ZPSTORNED_ID (0) 
    Root page: 1504206, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
ZQDISTR (172) 
    Primary pointer page: 541, Index root page: 542 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index ZQDISTR_ID (0) 
    Root page: 1504212, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index ZQDISTR_WARE_SNDOP_RCVOP (1) 
    Root page: 1504213, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
ZQSTORNED (173) 
    Primary pointer page: 543, Index root page: 544 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index ZQSTORNED_DOC_ID (1) 
    Root page: 1504209, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index ZQSTORNED_ID (0) 
    Root page: 1504208, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index ZQSTORNED_RCV_ID (3) 
    Root page: 1504211, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index ZQSTORNED_SND_ID (2) 
    Root page: 1504210, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
ZTMP_DEP_DOCS (168) 
    Primary pointer page: 533, Index root page: 534 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
ZTMP_SHOPPING_CART (167) 
    Primary pointer page: 531, Index root page: 532 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
Z_USED_VIEWS (144) 
    Primary pointer page: 484, Index root page: 485 
    Total formats: 1, used formats: 1 
    Average record length: 29.38, total records: 29 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 99.00, compression ratio: 3.37 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 16% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index Z_USED_VIEWS_UNQ (0) 
    Root page: 1510350, depth: 1, leaf buckets: 1, nodes: 29 
    Average node length: 15.17, total dup: 0, max dup: 0 
    Average key length: 14.14, compression ratio: 1.44 
    Average prefix length: 9.17, average data length: 11.17 
    Clustering factor: 1, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
Gstat completion time Fri Mar 29 01:11:34 2024

Record versions statistics, table

TABLE_NAME TOTAL_RECS TOTAL_VERS MAX_VERSIONS VERS_TO_RECS_PRC MAXV_TO_VERS_PRC
DOC_DATA 7816229 133236 1 0.0000 0.0000
DOC_LIST 2279001 137925 3 0.0000 0.0000
FB_ERRORS 2182 757 1 0.0000 0.0000
INVNT_SALDO 400 230006 637 57500.0000 0.0000
INVNT_TURNOVER_LOG 98773 78162 1 0.0000 0.0000
MONEY_SALDO 49 19078 1072 38900.0000 0.0000
MONEY_TURNOVER_LOG 1273 1213 1 0.0000 0.0000
PDISTR 813519 80507 5 0.0000 0.0000
PERF_SPLIT_0 161067 2962 1 0.0000 0.0000
PERF_SPLIT_1 154626 1909 1 0.0000 0.0000
PERF_SPLIT_2 157973 2222 1 0.0000 0.0000
PERF_SPLIT_3 161351 3137 1 0.0000 0.0000
PERF_SPLIT_4 144978 123 1 0.0000 0.0000
PERF_SPLIT_5 180246 27107 1 0.0000 0.0000
PERF_SPLIT_6 170001 18637 1 0.0000 0.0000
PERF_SPLIT_7 171210 2535 1 0.0000 0.0000
PERF_SPLIT_8 153436 2749 1 0.0000 0.0000
PERF_SPLIT_9 163544 3282 1 0.0000 0.0000
PSTORNED 2117742 49505 1 0.0000 0.0000
SEMAPHORES 5 1 1 0.0000 100.0000
XQD_1000_1200 152876 74694 1 0.0000 0.0000
XQD_1000_3300 7149510 482918 1 0.0000 0.0000
XQD_1200_2000 12080823 419528 1 0.0000 0.0000
XQD_2000_3300 1801172 749916 1 0.0000 0.0000
XQD_2100_3300 1185803 546810 1 0.0000 0.0000
XQD_3300_3400 9325657 527952 1 0.0000 0.0000
XQS_1000_1200 21161244 19350 1 0.0000 0.0000
XQS_1000_3300 9757793 504376 1 0.0000 0.0000
XQS_1200_2000 11443830 385944 1 0.0000 0.0000
XQS_2100_3300 9900931 533294 1 0.0000 0.0000
XQS_3300_3400 577374 7442 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 ---
:509: 
:510: mscs-test-161.budzdorov.ru    Fri Mar 29 01:09:57 2024
:511:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:512: 
:513: 
:514: mscs-test-161.budzdorov.ru    Fri Mar 29 01:09:57 2024
:515:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:516: 
--- end of diff output ---

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

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