Generated by /opt/oltp-emul/oltp_isql_run_worker.sh, ISQL session No. 1 of total launched 100. 22.02.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 15833000 kB
MemAvailable 30293356 kB
Buffers 0 kB
Cached 15907256 kB
SwapCached 2400 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-02-22 01:09:37
DTS_END                         2024-02-22 01:09:37.5740
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/41268
TRN_ID                          176442
ATT_ID                          562
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: 9106.75 21639 910675
customer order: creation 177.46 369 17746
customer order: refuse 14.70 349 1470
order to supplier: creation 47.17 1239 4717
order to supplier: removal 3.37 96502 337
invoice (draft): creation 47.63 3257 4763
invoice (draft): removal 47.89 779 4789
invoice accept: apply 43.48 19807 4348
invoice accept: cancel 43.20 888 4320
customer reserve: creation 4140.21 192 414021
customer reserve: removal 4246.73 62 424673
realization accept: apply 84.46 200 8446
realization accept: cancel 78.05 128 7805
payment from customer: creation 60.80 118 6080
payment from customer: removal 5.89 94 589
payment to supplier: creation 50.30 144 5030
payment to supplier: removal 3.25 59 325
service: total inventory turnovers 4.73 966 473
service: total monetary turnovers 6.70 28 670
service: aggregate perf. data 0.70 23823 70
service: refresh index statistics 0.03 283775 3

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:02, from 22-02-2024 01:10:59 to 22-02-2024 01:11:01.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 4041
TEST_TIME 2 4999
TEST_TIME 3 4149
TEST_TIME 4 4016
TEST_TIME 5 3890
TEST_TIME 6 3977
TEST_TIME 7 4578
TEST_TIME 8 5111
TEST_TIME 9 5439
TEST_TIME 10 5621
TEST_TIME 11 5584
TEST_TIME 12 5596
TEST_TIME 13 5599
TEST_TIME 14 5898
TEST_TIME 15 5959
TEST_TIME 16 6377
TEST_TIME 17 6429
TEST_TIME 18 6582
TEST_TIME 19 7136
TEST_TIME 20 6972
TEST_TIME 21 7148
TEST_TIME 22 7327
TEST_TIME 23 7650
TEST_TIME 24 7843
TEST_TIME 25 7789
TEST_TIME 26 8379
TEST_TIME 27 9201
TEST_TIME 28 9189
TEST_TIME 29 9187
TEST_TIME 30 9372
TEST_TIME 31 9388
TEST_TIME 32 9245
TEST_TIME 33 9287
TEST_TIME 34 9297
TEST_TIME 35 9366
TEST_TIME 36 9188
TEST_TIME 37 9100
TEST_TIME 38 9057
TEST_TIME 39 8999
TEST_TIME 40 8901
TEST_TIME 41 8890
TEST_TIME 42 8785
TEST_TIME 43 9007
TEST_TIME 44 9043
TEST_TIME 45 8895
TEST_TIME 46 8927
TEST_TIME 47 9014
TEST_TIME 48 8993
TEST_TIME 49 9036
TEST_TIME 50 9024
TEST_TIME 51 9045
TEST_TIME 52 9119
TEST_TIME 53 9153
TEST_TIME 54 9136
TEST_TIME 55 9143
TEST_TIME 56 9221
TEST_TIME 57 9312
TEST_TIME 58 9275
TEST_TIME 59 9360
TEST_TIME 60 9400
TEST_TIME 61 9477
TEST_TIME 62 9342
TEST_TIME 63 9247
TEST_TIME 64 9263
TEST_TIME 65 9191
TEST_TIME 66 9184
TEST_TIME 67 9186
TEST_TIME 68 9140
TEST_TIME 69 9142
TEST_TIME 70 9107
TEST_TIME 71 9049
TEST_TIME 72 9000
TEST_TIME 73 9055
TEST_TIME 74 9083
TEST_TIME 75 9053
TEST_TIME 76 9125
TEST_TIME 77 9184
TEST_TIME 78 9247
TEST_TIME 79 9245
TEST_TIME 80 9273
TEST_TIME 81 9274
TEST_TIME 82 9279
TEST_TIME 83 9305
TEST_TIME 84 9279
TEST_TIME 85 9431
TEST_TIME 86 9398
TEST_TIME 87 9293
TEST_TIME 88 9303
TEST_TIME 89 9329
TEST_TIME 90 9278
TEST_TIME 91 9233
TEST_TIME 92 9197
TEST_TIME 93 9139
TEST_TIME 94 9193
TEST_TIME 95 9166
TEST_TIME 96 9175
TEST_TIME 97 9145
TEST_TIME 98 9180
TEST_TIME 99 9175
TEST_TIME 100 9117

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:03, from 22-02-2024 01:11:03 to 22-02-2024 01:11:06.

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 1288928 1288928 0 0.00 0 47344 7 0 0
doc_list_biud 1288926 1288926 0 0.00 0 29567 26 0 0
sp_add_invoice_to_stock 4436 4348 88 1.98 43 188580 19807 0 88
sp_cancel_adding_invoice 4320 4320 0 0.00 5 71447 888 0 0
sp_cancel_client_order 1470 1470 0 0.00 5 6373 349 0 0
sp_cancel_customer_reserve 424673 424673 0 0.00 0 29569 62 0 0
sp_cancel_pay_from_customer 589 589 0 0.00 2 3733 95 0 0
sp_cancel_pay_to_supplier 325 325 0 0.00 3 3683 60 0 0
sp_cancel_supplier_invoice 4796 4789 7 0.14 1 14425 779 0 7
sp_cancel_supplier_order 337 337 0 0.00 7 1089819 96503 0 0
sp_cancel_write_off 7805 7805 0 0.00 1 21869 128 0 0
sp_client_order 17746 17746 0 0.00 3 12822 369 0 0
sp_customer_reserve 414021 414021 0 0.00 0 76469 193 0 0
sp_fill_shopping_cart 27226 27226 0 0.00 1 20297 40 0 0
sp_fill_shopping_cart_clo_res 414012 414012 0 0.00 0 16568 14 0 0
sp_get_clo_for_invoice 4334 4334 0 0.00 0 22790 326 0 0
sp_kill_cost_storno 13039 13039 0 0.00 0 12308 62 0 0
sp_kill_qstorno_ret_qs2qd 862277 862277 0 0.00 0 29551 34 0 0
sp_kill_qty_storno 456173 456173 0 0.00 0 29566 72 0 0
sp_lock_selected_doc 17610 17610 0 0.00 0 6131 4 0 0
sp_make_cost_storno 23890 23890 0 0.00 0 47170 63 0 0
sp_multiply_rows_for_pdistr 23889 23889 0 0.00 0 26427 34 0 0
sp_multiply_rows_for_qdistr 17746 17746 0 0.00 0 12256 163 0 0
sp_pay_from_customer 6080 6080 0 0.00 4 22657 119 0 0
sp_pay_to_supplier 5030 5030 0 0.00 5 25222 145 0 0
sp_payment_common 11110 11110 0 0.00 1 24914 35 0 0
sp_qd_handle_on_cancel_clo 1470 1470 0 0.00 0 6248 320 0 0
sp_qd_handle_on_invoice_upd_sts 8653 8653 0 0.00 0 15849 292 0 0
sp_qd_handle_on_reserve_upd_sts 8446 8446 0 0.00 0 14349 66 0 0
sp_reserve_write_off 8446 8446 0 0.00 6 27260 201 0 0
sp_supplier_invoice 4763 4763 0 0.00 7 93793 3258 0 0
sp_supplier_order 4717 4717 0 0.00 5 21309 1239 0 0
srv_aggregate_perf_data 70 70 0 0.00 2533 209914 23823 0 0
srv_fill_mon_cache_memory 57 57 0 0.00 1293 112818 37466 0 0
srv_find_qd_qs_mism 866540 866540 0 0.00 0 24103 7 0 0
srv_make_invnt_saldo 473 473 0 0.00 42 34924 967 0 0
srv_make_money_saldo 670 670 0 0.00 1 1860 28 0 0
srv_recalc_idx_stat 3 3 0 0.00 209456 414779 283776 0 0
t$perf-abend:sp_add_invoice_to_stock 88 88 0 0.00 0 0 0 0 0
t$perf-abend:sp_cancel_supplier_invoice 7 7 0 0.00 0 0 0 0 0
t$perf-norm:sp_add_invoice_to_stock 4348 4348 0 0.00 0 21802 213 0 0
t$perf-norm:sp_cancel_adding_invoice 334 334 0 0.00 0 3601 157 0 0
t$perf-norm:sp_cancel_client_order 1470 1470 0 0.00 0 4948 20 0 0
t$perf-norm:sp_cancel_customer_reserve 598 598 0 0.00 0 2165 11 0 0
t$perf-norm:sp_cancel_pay_from_customer 589 589 0 0.00 0 1356 10 0 0
t$perf-norm:sp_cancel_pay_to_supplier 325 325 0 0.00 0 2553 14 0 0
t$perf-norm:sp_cancel_supplier_invoice 331 331 0 0.00 0 3243 29 0 0
t$perf-norm:sp_cancel_supplier_order 337 337 0 0.00 0 23607 1661 0 0
t$perf-norm:sp_cancel_write_off 848 848 0 0.00 0 2185 10 0 0
t$perf-norm:sp_client_order 17746 17746 0 0.00 0 22508 23 0 0
t$perf-norm:sp_customer_reserve 835 835 0 0.00 0 9017 24 0 0
t$perf-norm:sp_pay_from_customer 6080 6080 0 0.00 0 4377 11 0 0
t$perf-norm:sp_pay_to_supplier 5030 5030 0 0.00 0 18475 14 0 0
t$perf-norm:sp_reserve_write_off 8446 8446 0 0.00 0 21217 17 0 0
t$perf-norm:sp_supplier_invoice 4763 4763 0 0.00 0 9097 23 0 0
t$perf-norm:sp_supplier_order 4717 4717 0 0.00 0 6148 15 0 0
t$perf-norm:srv_aggregate_perf_data 70 70 0 0.00 0 204 11 0 0
t$perf-norm:srv_fill_mon_cache_memory 57 57 0 0.00 0 4166 75 0 0
t$perf-norm:srv_make_invnt_saldo 473 473 0 0.00 0 2133 29 0 0
t$perf-norm:srv_make_money_saldo 670 670 0 0.00 0 1064 20 0 0
t$perf-norm:srv_recalc_idx_stat 3 3 0 0.00 2 98 37 0 0
v_add_invoice_to_stock 8842 8666 176 1.99 0 4790 17 0 176
v_all_customers 32642 32642 0 0.00 0 61 1 0 0
v_all_suppliers 26580 26580 0 0.00 0 60 1 0 0
v_all_wares 35492 35492 0 0.00 0 19 1 0 0
v_cancel_adding_invoice 668 668 0 0.00 0 1462 9 0 0
v_cancel_client_order 2940 2940 0 0.00 0 2884 6 0 0
v_cancel_customer_prepayment 1178 1178 0 0.00 0 3199 7 0 0
v_cancel_customer_reserve 1196 1196 0 0.00 0 1035 5 0 0
v_cancel_payment_to_supplier 650 650 0 0.00 0 3655 9 0 0
v_cancel_supplier_invoice 676 662 14 2.07 0 2794 18 0 14
v_cancel_supplier_order 674 674 0 0.00 0 421 4 0 0
v_cancel_write_off 1696 1696 0 0.00 0 1926 19 0 0
v_max_id_clo_ord 4717 4717 0 0.00 0 868 2 0 0
v_max_id_clo_res 835 835 0 0.00 0 2654 25 0 0
v_max_id_ord_sup 4763 4763 0 0.00 0 4008 5 0 0
v_max_non_paid_invoice 1220 1220 0 0.00 0 1219 5 0 0
v_max_non_paid_realizn 3054 3054 0 0.00 0 4404 5 0 0
v_min_id_clo_ord 4717 4717 0 0.00 0 5114 7 0 0
v_min_id_clo_res 835 835 0 0.00 0 6849 13 0 0
v_min_id_ord_sup 4763 4763 0 0.00 0 5965 16 0 0
v_min_non_paid_invoice 5030 5030 0 0.00 0 24854 26 0 0
v_min_non_paid_realizn 6080 6080 0 0.00 0 22359 30 0 0
v_our_firm 8902 8902 0 0.00 0 13 1 0 0
v_reserve_write_off 16888 16888 0 0.00 0 3531 6 0 0
x_lock_depdocs_on_canc_invoice 8778 8778 0 0.00 0 11116 126 0 0
x_lock_depdocs_on_canc_sup_ord 337 337 0 0.00 0 6409 302 0 0
x_make_qstorno_1000_1200 4717 4717 0 0.00 2 20758 1158 0 0
x_make_qstorno_1200_2000 4763 4763 0 0.00 3 93679 3109 0 0
x_make_qstorno_2100_3300 414020 414020 0 0.00 0 76468 176 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 22-02-2024 01:11:07 to 22-02-2024 01:11:11.

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:41 19 8192000000 8826441744 8847015936 25032192 0.304 8 6 7 0 25348640 112864 203584
23:10:42 17281 8192000000 9881067888 10187059200 968437072 10.571 100 90 180 0 997738304 5006672 24294560
23:12:05 5062 8192000000 9922197664 10241126400 1008864880 10.964 100 93 186 0 1040528064 7501664 24161520
23:13:15 12485 8192000000 9958062928 10283565056 1043768016 11.301 100 86 172 0 1074413872 8877904 21767952
23:14:31 14078 8192000000 10003368880 10340888576 1089439632 11.737 100 86 172 0 1119515152 9366224 20709296
23:15:51 8994 8192000000 10047563200 10397777920 1132543936 12.145 100 73 146 0 1160449328 11227872 16677520
23:17:03 6100 8192000000 10097574912 10463522816 1186190064 12.648 100 72 144 0 1213743280 11021104 16532112
23:18:12 2051 8192000000 10146908480 10516504576 1233067792 13.082 100 91 181 1 1266676384 13805184 19803408
23:19:18 6728 8192000000 10176611008 10560806912 1267575744 13.399 100 69 136 0 1294691328 12873568 14242016
23:20:26 964 8192000000 10211679664 10597027840 1298073088 13.678 100 83 166 1 1329536784 12850624 18613072
23:21:28 17539 8192000000 10210597152 10611003392 1305690816 13.747 100 58 115 0 1328432096 9450432 13290848
23:22:47 3731 8192000000 10204496800 10610941952 1312066944 13.805 100 47 93 0 1330463712 8675376 9721392
23:23:52 4730 8192000000 10207862832 10623561728 1318745696 13.865 100 36 70 0 1333409488 6505328 8158464
23:25:00 10919 8192000000 10209376896 10628079616 1322371808 13.898 100 14 30 0 1331431424 5684032 3375584
23:26:14 41886 8192000000 10215156768 10635747328 1328245712 13.951 100 35 69 0 1341877968 5788080 7844176
23:27:56 6023 8192000000 10224277808 10644615168 1331777040 13.983 100 30 58 2 1344098208 5462400 6858768
23:29:03 5557 8192000000 10204800096 10626617344 1314873168 13.830 99 15 31 0 1324319248 6001760 3444320
23:30:12 43332 8192000000 10240845872 10651127808 1337773472 14.037 100 50 98 1 1359094928 8739264 12582192
23:32:02 93505 8192000000 10227454864 10647883776 1323998816 13.913 99 48 96 0 1346282512 10641824 11641872
23:34:51 45540 8192000000 10233586720 10651234304 1323408768 13.908 99 33 66 0 1344828576 13096928 8322880
23:36:59 27233 8192000000 10213292608 10615877632 1282106304 13.532 98 42 83 0 1309174416 16719664 10348448
23:38:31 8974 8192000000 10223216960 10626433024 1293417632 13.635 98 49 98 0 1325112384 19799312 11895440
23:39:45 21946 8192000000 10225857648 10631426048 1299732496 13.693 99 37 73 0 1322360176 14338784 8288896
23:41:11 11437 8192000000 10217230640 10620166144 1304738160 13.738 100 39 78 0 1330968864 16491232 9739472
23:42:31 2698 8192000000 10235936400 10632753152 1312119360 13.805 100 62 123 0 1346720208 19680240 14920608
23:43:39 1579 8192000000 10277249808 10674147328 1342512576 14.080 100 71 142 0 1383975024 24095360 17367088
23:44:46 8380 8192000000 10279915872 10685431808 1340088688 14.058 100 59 117 0 1386553120 32037376 14427056
23:46:08 2600 8192000000 10301250544 10698162176 1358911088 14.228 100 73 144 1 1404436432 28292336 17233008
23:47:15 1471 8192000000 10314743120 10715328512 1372068112 14.346 100 74 146 0 1420603872 30952288 17583472
23:48:20 1289 8192000000 10325785168 10727497728 1374919360 14.371 100 79 158 0 1429671456 35559536 19192560
23:49:26 2848 8192000000 10325019568 10736082944 1385892592 14.469 100 61 120 0 1431870688 31069936 14908160
23:50:34 2514 8192000000 10341406960 10747396096 1390367328 14.509 100 74 144 0 1444516272 36066384 18082560
23:51:42 25301 8192000000 10339665536 10758270976 1393825216 14.540 100 38 77 2 1443658752 39249856 10583680
23:53:11 14903 8192000000 10321697392 10754879488 1392103504 14.525 100 25 50 0 1431956800 32726464 7126832
23:54:42 28835 8192000000 10320674080 10759319552 1385631072 14.467 100 35 69 0 1436074544 41302640 9140832
23:56:19 32208 8192000000 10299287632 10759421952 1376071888 14.381 100 13 26 0 1405806640 26332352 3402400
23:58:07 34003 8192000000 10302355600 10751606784 1396913184 14.568 100 14 26 1 1411488448 11676768 2898496
23:59:42 21727 8192000000 10316555504 10751401984 1398322656 14.580 100 31 60 0 1414364864 9996128 6046080
00:01:12 27804 8192000000 10319827984 10756739072 1401692928 14.610 100 40 73 4 1416987408 6875936 8418544
00:02:44 29595 8192000000 10293444560 10740207616 1379750096 14.414 99 18 36 0 1391987408 8381008 3856304
00:04:24 46215 8192000000 10303446416 10754478080 1391723600 14.521 100 14 29 0 1409178032 14537600 2916832
00:06:52 49705 8192000000 10315061072 10757316608 1389386128 14.500 99 36 72 1 1412321728 14694416 8241184
00:08:44 50004 8192000000 10307868496 10764075008 1387048752 14.480 98 12 24 0 1401888896 12176576 2663568
00:10:36 33776 8192000000 10335597552 10777133056 1399549136 14.591 99 30 59 0 1426649600 19963520 7136944
00:12:16 35428 8192000000 10311503648 10777108480 1391664048 14.521 99 16 32 1 1419082400 23445504 3972848
00:13:53 64564 8192000000 10308437152 10755313664 1374577312 14.368 98 19 38 0 1399476064 20310960 4587792
00:16:05 47921 8192000000 10274547872 10718347264 1338864960 14.047 97 19 38 0 1356498320 12696400 4936960
00:17:55 64023 8192000000 10257267408 10716782592 1304259808 13.734 95 6 12 0 1318130432 12433648 1436976
00:20:02 57836 8192000000 10275695984 10720329728 1315854656 13.839 96 23 46 0 1332991296 11916784 5219856
00:22:05 51513 8192000000 10262055840 10709622784 1310294688 13.789 96 19 38 0 1325658976 10856112 4508176
00:24:38 45919 8192000000 10249547008 10696650752 1300377392 13.699 96 14 28 0 1318313408 14524608 3411408
00:26:39 47077 8192000000 10279595472 10717732864 1361528816 14.251 100 31 62 0 1379627488 11433280 6665392
00:28:30 44951 8192000000 10258354256 10702737408 1308707568 13.774 97 24 48 0 1326688880 12689136 5292176
00:30:15 112818 8192000000 10249080848 10702307328 1330392048 13.971 99 16 32 1 1349007504 15279552 3335904
00:33:18 40393 8192000000 10248914240 10685796352 1271262400 13.433 94 28 56 0 1287660064 10318064 6079600
00:35:00 15929 8192000000 10237506992 10668052480 1319354656 13.871 100 37 74 0 1339467152 11983152 8129344
00:36:19 35708 8192000000 10236788144 10683142144 1334824848 14.011 99 9 18 0 1346047664 9289056 1933760
00:38:15 32188 8192000000 10245545200 10690359296 1330667440 13.973 99 12 24 0 1346283744 12832784 2783520
00:41:13 54047 8192000000 10258611568 10706747392 1339666896 14.054 98 9 18 0 1352119168 10677888 1774384
00:43:08 49401 8192000000 10281713424 10734260224 1375926512 14.380 100 16 32 0 1390689008 11164032 3598464
00:45:00 44316 8192000000 10297156704 10751963136 1388178624 14.490 100 21 42 0 1405369984 12291488 4899872
00:46:51 82753 8192000000 10291769056 10746236928 1358883152 14.227 98 13 28 0 1376569088 14909488 2776448
00:49:19 33968 8192000000 10308973840 10756837376 1393452816 14.537 100 38 76 0 1413301424 11368512 8480096
00:51:01 43465 8192000000 10310873072 10755538944 1396724816 14.566 100 23 46 0 1412206144 10798256 4683072
00:52:47 38004 8192000000 10309586944 10752045056 1382113264 14.435 99 40 76 0 1401014880 10468224 8433392
00:54:27 28593 8192000000 10316571808 10784436224 1388186864 14.490 99 39 78 0 1423449952 26702432 8560656
00:55:59 94998 8192000000 10292788240 10743021568 1364641744 14.279 98 20 40 0 1392792352 23424992 4725616
00:58:40 38763 8192000000 10277280032 10740965376 1388142112 14.489 100 18 36 0 1399838912 7139152 4557648
01:00:19 50149 8192000000 10269546320 10728964096 1365820464 14.290 99 17 34 0 1380689408 11177696 3691248
01:02:10 65470 8192000000 10250324368 10714034176 1348872000 14.137 99 16 32 0 1363763456 11356224 3535232
01:04:17 68923 8192000000 10263099920 10722492416 1368729584 14.316 100 10 20 0 1385537104 14413184 2394336
01:06:26 21459 8192000000 10253348032 10689667072 1321475072 13.890 98 34 68 0 1337089632 8164928 7449632
01:07:50 23226 8192000000 10261829664 10703683584 1333833184 14.002 98 29 58 1 1352182352 11538448 6810720
01:09:17 32280 8192000000 9017889472 9203429376 187755072 2.240 14 6 12 0 194292144 4946976 1590096

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:14, from 22-02-2024 01:11:13 to 22-02-2024 01:11:27.

Exceptions occured during test was in run

FB_MNEMONA CNT UNIT FB_GDSCODE
except 88 v_add_invoice_to_stock 335544517
except 7 v_cancel_supplier_invoice 335544517

Completed "Exceptions occured during test was in run". Done for 00:00:02, from 22-02-2024 01:11:28 to 22-02-2024 01:11:30.

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          176736
MON$OLDEST_ACTIVE               176737
MON$OLDEST_SNAPSHOT             176737
MON$NEXT_TRANSACTION            176737
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                       1907488
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.33731 Firebird 3.0
Server version:
Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V3.0.12.33731 Firebird 3.0"
Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-V3.0.12.33731 Firebird 3.0/tcp (mscs-test-161.budzdorov.ru)/P15:C"
Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-V3.0.12.33731 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 Thu Feb 22 01:11:31 2024 
 
Database header page information: 
    Flags            0 
    Generation        92153 
    System Change Number    0 
    Page size        8192 
    ODS version        12.0 
    Oldest transaction    176736 
    Oldest active        176737 
    Oldest snapshot        176737 
    Next transaction    176738 
    Sequence number        0 
    Next attachment ID    717 
    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.39, total records: 7795461 
    Average version length: 48.16, total versions: 81967, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 64.00, compression ratio: 1.35 
    Pointer pages: 54, data page slots: 87288 
    Data pages: 87288, average fill: 71% 
    Primary pages: 87288, secondary pages: 0, swept pages: 18179 
    Empty pages: 8, full pages: 67783 
    Fill distribution: 
     0 - 19% = 35 
    20 - 39% = 203 
    40 - 59% = 2956 
    60 - 79% = 84078 
    80 - 99% = 16 
 
    Index DOC_DATA_DOC_WARE_UNQ (0) 
    Root page: 1510614, depth: 3, leaf buckets: 23462, nodes: 7795461 
    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: 1730206, ratio: 0.22 
    Fill distribution: 
         0 - 19% = 357 
        20 - 39% = 1853 
        40 - 59% = 4171 
        60 - 79% = 2364 
        80 - 99% = 14717 
 
    Index DOC_DATA_ID_DESC (1) 
    Root page: 1528118, depth: 3, leaf buckets: 13603, nodes: 7795461 
    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: 1552735, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 1619 
        40 - 59% = 2051 
        60 - 79% = 1081 
        80 - 99% = 8852 
 
    Index FK_DOC_DATA_DOC_LIST (2) 
    Root page: 1546711, depth: 3, leaf buckets: 8412, nodes: 7795461 
    Average node length: 6.63, total dup: 5815310, max dup: 49 
    Average key length: 3.64, compression ratio: 2.47 
    Average prefix length: 7.61, average data length: 1.39 
    Clustering factor: 1545661, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 129 
        20 - 39% = 969 
        40 - 59% = 1440 
        60 - 79% = 917 
        80 - 99% = 4957 
 
DOC_LIST (138) 
    Primary pointer page: 472, Index root page: 473 
    Total formats: 1, used formats: 1 
    Average record length: 56.41, total records: 2271689 
    Average version length: 34.55, total versions: 79475, max versions: 3 
    Average fragment length: 4.00, total fragments: 1, max fragments: 1 
    Average unpacked length: 84.00, compression ratio: 1.49 
    Pointer pages: 18, data page slots: 28592 
    Data pages: 28592, average fill: 73% 
    Primary pages: 28586, secondary pages: 6, swept pages: 8591 
    Empty pages: 8, full pages: 21342 
    Fill distribution: 
     0 - 19% = 25 
    20 - 39% = 107 
    40 - 59% = 1603 
    60 - 79% = 26213 
    80 - 99% = 644 
 
    Index DOC_LIST_ID_DESC (1) 
    Root page: 1541130, depth: 3, leaf buckets: 4610, nodes: 2271689 
    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: 701422, ratio: 0.31 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 947 
        40 - 59% = 852 
        60 - 79% = 717 
        80 - 99% = 2093 
 
    Index DOC_LIST_WORKER_OPTYPE (2) 
    Root page: 1544376, depth: 3, leaf buckets: 2566, nodes: 2273970 
    Average node length: 4.97, total dup: 2273071, max dup: 21441 
    Average key length: 2.01, compression ratio: 4.47 
    Average prefix length: 8.99, average data length: 0.01 
    Clustering factor: 1252996, ratio: 0.55 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 267 
        40 - 59% = 1600 
        60 - 79% = 515 
        80 - 99% = 182 
 
    Index FK_DOC_LIST_AGENTS (3) 
    Root page: 1545909, depth: 3, leaf buckets: 2068, nodes: 2271689 
    Average node length: 4.97, total dup: 2271639, max dup: 130392 
    Average key length: 2.01, compression ratio: 4.48 
    Average prefix length: 8.99, average data length: 0.01 
    Clustering factor: 1068576, ratio: 0.47 
    Fill distribution: 
         0 - 19% = 6 
        20 - 39% = 41 
        40 - 59% = 1155 
        60 - 79% = 50 
        80 - 99% = 816 
 
    Index PK_DOC_LIST (0) 
    Root page: 1538187, depth: 3, leaf buckets: 4394, nodes: 2271689 
    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: 701422, ratio: 0.31 
    Fill distribution: 
         0 - 19% = 100 
        20 - 39% = 595 
        40 - 59% = 633 
        60 - 79% = 820 
        80 - 99% = 2246 
 
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.39, total records: 400 
    Average version length: 23.16, total versions: 236578, max versions: 618 
    Average fragment length: 2.00, total fragments: 53, max fragments: 1 
    Average unpacked length: 104.00, compression ratio: 1.26 
    Pointer pages: 1, data page slots: 1312 
    Data pages: 1312, average fill: 90% 
    Primary pages: 11, secondary pages: 1301, swept pages: 0 
    Empty pages: 4, full pages: 1306 
    Fill distribution: 
     0 - 19% = 5 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 1307 
 
    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: 8.77, total records: 84215 
    Average version length: 68.27, total versions: 73406, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 88.00, compression ratio: 10.04 
    Pointer pages: 6, data page slots: 3112 
    Data pages: 1984, average fill: 53% 
    Primary pages: 1983, secondary pages: 1, swept pages: 0 
    Empty pages: 440, full pages: 904 
    Fill distribution: 
     0 - 19% = 591 
    20 - 39% = 162 
    40 - 59% = 181 
    60 - 79% = 292 
    80 - 99% = 758 
 
    Index INVNT_TURNOVER_LOG_WARE_DD_ID (0) 
    Root page: 1708250, depth: 3, leaf buckets: 307, nodes: 84215 
    Average node length: 13.50, total dup: 4574, max dup: 2 
    Average key length: 10.80, compression ratio: 2.50 
    Average prefix length: 19.14, average data length: 7.86 
    Clustering factor: 63152, ratio: 0.75 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 153 
        40 - 59% = 82 
        60 - 79% = 71 
        80 - 99% = 0 
 
MONEY_SALDO (141) 
    Primary pointer page: 478, Index root page: 479 
    Total formats: 1, used formats: 1 
    Average record length: 15.29, total records: 49 
    Average version length: 9.00, total versions: 18165, max versions: 941 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 32.00, compression ratio: 2.09 
    Pointer pages: 1, data page slots: 64 
    Data pages: 64, average fill: 91% 
    Primary pages: 1, secondary pages: 63, swept pages: 0 
    Empty pages: 0, full pages: 63 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 4 
    80 - 99% = 60 
 
    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.17, total records: 1656 
    Average version length: 43.12, total versions: 1576, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 58.00, compression ratio: 26.68 
    Pointer pages: 1, data page slots: 40 
    Data pages: 30, average fill: 53% 
    Primary pages: 29, secondary pages: 1, swept pages: 1 
    Empty pages: 6, full pages: 14 
    Fill distribution: 
     0 - 19% = 8 
    20 - 39% = 3 
    40 - 59% = 5 
    60 - 79% = 2 
    80 - 99% = 12 
 
    Index MONEY_TURNOVER_LOG_AGENT_OPTYPE (0) 
    Root page: 89236, depth: 2, leaf buckets: 2, nodes: 1656 
    Average node length: 4.25, total dup: 1558, max dup: 180 
    Average key length: 2.62, compression ratio: 7.26 
    Average prefix length: 18.44, average data length: 0.56 
    Clustering factor: 907, ratio: 0.55 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 1 
        40 - 59% = 1 
        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.04, total records: 74 
    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: 74 
    Average node length: 11.69, total dup: 0, max dup: 0 
    Average key length: 10.68, compression ratio: 0.84 
    Average prefix length: 1.31, average data length: 7.69 
    Clustering factor: 2, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
MON_LOG (162) 
    Primary pointer page: 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.78, total records: 800467 
    Average version length: 25.24, total versions: 80837, max versions: 4 
    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: 7960 
    Data pages: 7960, average fill: 71% 
    Primary pages: 7940, secondary pages: 20, swept pages: 1138 
    Empty pages: 23, full pages: 6765 
    Fill distribution: 
     0 - 19% = 43 
    20 - 39% = 74 
    40 - 59% = 230 
    60 - 79% = 7265 
    80 - 99% = 348 
 
    Index PDISTR_AGENT_ID (2) 
    Root page: 1509308, depth: 2, leaf buckets: 879, nodes: 800467 
    Average node length: 4.87, total dup: 800418, max dup: 144627 
    Average key length: 2.01, compression ratio: 4.48 
    Average prefix length: 8.99, average data length: 0.01 
    Clustering factor: 89020, ratio: 0.11 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 113 
        40 - 59% = 506 
        60 - 79% = 195 
        80 - 99% = 63 
 
    Index PDISTR_SNDOP_RCVOP_SNDID_ASC (0) 
    Root page: 1508613, depth: 3, leaf buckets: 911, nodes: 800467 
    Average node length: 5.88, total dup: 712643, max dup: 46 
    Average key length: 3.02, compression ratio: 7.29 
    Average prefix length: 21.09, average data length: 0.91 
    Clustering factor: 159469, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 3 
        20 - 39% = 94 
        40 - 59% = 358 
        60 - 79% = 138 
        80 - 99% = 318 
 
    Index PDISTR_SNDOP_RCVOP_SNDID_DESC (1) 
    Root page: 1509187, depth: 3, leaf buckets: 961, nodes: 800467 
    Average node length: 5.88, total dup: 712643, max dup: 46 
    Average key length: 3.02, compression ratio: 7.28 
    Average prefix length: 21.09, average data length: 0.91 
    Clustering factor: 161491, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 205 
        40 - 59% = 326 
        60 - 79% = 111 
        80 - 99% = 318 
 
    Index PDISTR_WORKER_SND_ID (3) 
    Root page: 1510178, depth: 3, leaf buckets: 1134, nodes: 800467 
    Average node length: 5.96, total dup: 712643, max dup: 46 
    Average key length: 3.10, compression ratio: 5.48 
    Average prefix length: 16.01, average data length: 0.99 
    Clustering factor: 154429, ratio: 0.19 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 239 
        40 - 59% = 595 
        60 - 79% = 200 
        80 - 99% = 98 
 
PERF_AGG (158) 
    Primary pointer page: 512, Index root page: 513 
    Total formats: 1, used formats: 1 
    Average record length: 62.77, total records: 5418 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 2.55, total fragments: 94, max fragments: 1 
    Average unpacked length: 379.00, compression ratio: 6.04 
    Pointer pages: 1, data page slots: 88 
    Data pages: 88, average fill: 61% 
    Primary pages: 71, secondary pages: 17, swept pages: 49 
    Empty pages: 5, full pages: 66 
    Fill distribution: 
     0 - 19% = 18 
    20 - 39% = 1 
    40 - 59% = 0 
    60 - 79% = 68 
    80 - 99% = 1 
 
    Index PERF_AGG_UNQ (1) 
    Root page: 1504238, depth: 2, leaf buckets: 6, nodes: 5418 
    Average node length: 5.48, total dup: 0, max dup: 0 
    Average key length: 3.58, compression ratio: 10.02 
    Average prefix length: 34.35, average data length: 1.55 
    Clustering factor: 4994, ratio: 0.92 
    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: 5418 
    Average node length: 11.11, 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: 143, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 1 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 7 
 
PERF_ESTIMATED (280) 
    Primary pointer page: 1504218, Index root page: 1504219 
    Total formats: 1, used formats: 1 
    Average record length: 39.11, total records: 80804 
    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: 5, full pages: 778 
    Fill distribution: 
     0 - 19% = 5 
    20 - 39% = 1 
    40 - 59% = 0 
    60 - 79% = 778 
    80 - 99% = 0 
 
    Index PK_PERF_ESTIMATED (0) 
    Root page: 33994, depth: 2, leaf buckets: 105, nodes: 80804 
    Average node length: 10.17, total dup: 0, max dup: 0 
    Average key length: 8.18, compression ratio: 1.10 
    Average prefix length: 3.82, average data length: 5.18 
    Clustering factor: 3499, ratio: 0.04 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 1 
        40 - 59% = 3 
        60 - 79% = 0 
        80 - 99% = 100 
 
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.56, 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.15, total records: 173036 
    Average version length: 149.57, total versions: 3430, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.45 
    Pointer pages: 7, data page slots: 5328 
    Data pages: 4200, average fill: 85% 
    Primary pages: 4200, secondary pages: 0, swept pages: 1 
    Empty pages: 85, full pages: 4090 
    Fill distribution: 
     0 - 19% = 86 
    20 - 39% = 11 
    40 - 59% = 8 
    60 - 79% = 5 
    80 - 99% = 4090 
 
PERF_SPLIT_1 (282) 
    Primary pointer page: 576, Index root page: 577 
    Total formats: 1, used formats: 1 
    Average record length: 145.62, total records: 194080 
    Average version length: 153.08, total versions: 7419, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.65 
    Pointer pages: 9, data page slots: 5576 
    Data pages: 4720, average fill: 85% 
    Primary pages: 4719, secondary pages: 1, swept pages: 1 
    Empty pages: 91, full pages: 4598 
    Fill distribution: 
     0 - 19% = 94 
    20 - 39% = 16 
    40 - 59% = 8 
    60 - 79% = 5 
    80 - 99% = 4597 
 
PERF_SPLIT_2 (283) 
    Primary pointer page: 578, Index root page: 579 
    Total formats: 1, used formats: 1 
    Average record length: 127.33, total records: 189115 
    Average version length: 153.77, total versions: 29644, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 13.32 
    Pointer pages: 6, data page slots: 5912 
    Data pages: 4600, average fill: 86% 
    Primary pages: 4600, secondary pages: 0, swept pages: 5 
    Empty pages: 97, full pages: 4471 
    Fill distribution: 
     0 - 19% = 99 
    20 - 39% = 8 
    40 - 59% = 4 
    60 - 79% = 20 
    80 - 99% = 4469 
 
PERF_SPLIT_3 (284) 
    Primary pointer page: 580, Index root page: 581 
    Total formats: 1, used formats: 1 
    Average record length: 145.05, total records: 181322 
    Average version length: 152.13, total versions: 7246, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.69 
    Pointer pages: 7, data page slots: 7192 
    Data pages: 4472, average fill: 84% 
    Primary pages: 4471, secondary pages: 1, swept pages: 10 
    Empty pages: 142, full pages: 4263 
    Fill distribution: 
     0 - 19% = 147 
    20 - 39% = 19 
    40 - 59% = 16 
    60 - 79% = 29 
    80 - 99% = 4261 
 
PERF_SPLIT_4 (285) 
    Primary pointer page: 582, Index root page: 583 
    Total formats: 1, used formats: 1 
    Average record length: 145.22, total records: 154511 
    Average version length: 152.18, total versions: 5687, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.68 
    Pointer pages: 6, data page slots: 5784 
    Data pages: 3824, average fill: 83% 
    Primary pages: 3824, secondary pages: 0, swept pages: 1 
    Empty pages: 148, full pages: 3640 
    Fill distribution: 
     0 - 19% = 152 
    20 - 39% = 13 
    40 - 59% = 7 
    60 - 79% = 12 
    80 - 99% = 3640 
 
PERF_SPLIT_5 (286) 
    Primary pointer page: 584, Index root page: 585 
    Total formats: 1, used formats: 1 
    Average record length: 144.31, total records: 170757 
    Average version length: 152.36, total versions: 7389, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.75 
    Pointer pages: 6, data page slots: 4648 
    Data pages: 4144, average fill: 85% 
    Primary pages: 4144, secondary pages: 0, swept pages: 3 
    Empty pages: 90, full pages: 4030 
    Fill distribution: 
     0 - 19% = 92 
    20 - 39% = 6 
    40 - 59% = 10 
    60 - 79% = 5 
    80 - 99% = 4031 
 
PERF_SPLIT_6 (287) 
    Primary pointer page: 586, Index root page: 587 
    Total formats: 1, used formats: 1 
    Average record length: 144.14, total records: 186652 
    Average version length: 152.85, total versions: 8641, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.77 
    Pointer pages: 6, data page slots: 5760 
    Data pages: 4568, average fill: 85% 
    Primary pages: 4568, secondary pages: 0, swept pages: 1 
    Empty pages: 123, full pages: 4415 
    Fill distribution: 
     0 - 19% = 126 
    20 - 39% = 14 
    40 - 59% = 10 
    60 - 79% = 2 
    80 - 99% = 4416 
 
PERF_SPLIT_7 (288) 
    Primary pointer page: 588, Index root page: 589 
    Total formats: 1, used formats: 1 
    Average record length: 147.07, total records: 157251 
    Average version length: 151.95, total versions: 3825, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.53 
    Pointer pages: 6, data page slots: 5056 
    Data pages: 3856, average fill: 84% 
    Primary pages: 3856, secondary pages: 0, swept pages: 4 
    Empty pages: 119, full pages: 3700 
    Fill distribution: 
     0 - 19% = 120 
    20 - 39% = 10 
    40 - 59% = 9 
    60 - 79% = 18 
    80 - 99% = 3699 
 
PERF_SPLIT_8 (289) 
    Primary pointer page: 590, Index root page: 591 
    Total formats: 1, used formats: 1 
    Average record length: 145.90, total records: 173328 
    Average version length: 152.79, total versions: 5960, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.62 
    Pointer pages: 7, data page slots: 5280 
    Data pages: 4216, average fill: 85% 
    Primary pages: 4215, secondary pages: 1, swept pages: 4 
    Empty pages: 94, full pages: 4095 
    Fill distribution: 
     0 - 19% = 94 
    20 - 39% = 10 
    40 - 59% = 8 
    60 - 79% = 10 
    80 - 99% = 4094 
 
PERF_SPLIT_9 (290) 
    Primary pointer page: 593, Index root page: 594 
    Total formats: 1, used formats: 1 
    Average record length: 146.44, total records: 188186 
    Average version length: 153.12, total versions: 5766, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.58 
    Pointer pages: 6, data page slots: 5920 
    Data pages: 4584, average fill: 85% 
    Primary pages: 4583, secondary pages: 1, swept pages: 7 
    Empty pages: 103, full pages: 4447 
    Fill distribution: 
     0 - 19% = 108 
    20 - 39% = 11 
    40 - 59% = 11 
    60 - 79% = 7 
    80 - 99% = 4447 
 
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.85, total records: 2116284 
    Average version length: 52.96, total versions: 36208, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 70.00, compression ratio: 1.35 
    Pointer pages: 16, data page slots: 25664 
    Data pages: 25664, average fill: 71% 
    Primary pages: 25664, secondary pages: 0, swept pages: 10190 
    Empty pages: 299, full pages: 21368 
    Fill distribution: 
     0 - 19% = 581 
    20 - 39% = 489 
    40 - 59% = 1009 
    60 - 79% = 23268 
    80 - 99% = 317 
 
    Index PSTORNED_RCV_ID (1) 
    Root page: 1506186, depth: 3, leaf buckets: 2606, nodes: 2116284 
    Average node length: 5.44, total dup: 1975199, max dup: 1396 
    Average key length: 2.49, compression ratio: 3.62 
    Average prefix length: 8.58, average data length: 0.42 
    Clustering factor: 183178, ratio: 0.09 
    Fill distribution: 
         0 - 19% = 6 
        20 - 39% = 302 
        40 - 59% = 1714 
        60 - 79% = 287 
        80 - 99% = 297 
 
    Index PSTORNED_SND_ID (0) 
    Root page: 1504819, depth: 3, leaf buckets: 2757, nodes: 2116284 
    Average node length: 5.69, total dup: 1899691, max dup: 71 
    Average key length: 2.74, compression ratio: 3.29 
    Average prefix length: 8.36, average data length: 0.64 
    Clustering factor: 378125, ratio: 0.18 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 3 
        40 - 59% = 2384 
        60 - 79% = 342 
        80 - 99% = 28 
 
    Index PSTORNED_WORKER_ID (2) 
    Root page: 1507996, depth: 3, leaf buckets: 2185, nodes: 2116284 
    Average node length: 4.96, total dup: 2116184, max dup: 29078 
    Average key length: 2.00, compression ratio: 1.20 
    Average prefix length: 2.41, average data length: 0.00 
    Clustering factor: 180736, ratio: 0.09 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 200 
        40 - 59% = 1232 
        60 - 79% = 352 
        80 - 99% = 399 
 
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: 38.70, total records: 147475 
    Average version length: 69.19, total versions: 65040, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 3.26 
    Pointer pages: 3, data page slots: 4168 
    Data pages: 3119, average fill: 55% 
    Primary pages: 3119, secondary pages: 0, swept pages: 425 
    Empty pages: 547, full pages: 1820 
    Fill distribution: 
     0 - 19% = 804 
    20 - 39% = 267 
    40 - 59% = 164 
    60 - 79% = 671 
    80 - 99% = 1213 
 
    Index XQD_1000_1200_WA_SO_RO_WKR_SND (0) 
    Root page: 104598, depth: 3, leaf buckets: 224, nodes: 147475 
    Average node length: 6.43, total dup: 128257, max dup: 14 
    Average key length: 3.95, compression ratio: 10.63 
    Average prefix length: 40.18, average data length: 1.82 
    Clustering factor: 25303, ratio: 0.17 
    Fill distribution: 
         0 - 19% = 3 
        20 - 39% = 46 
        40 - 59% = 102 
        60 - 79% = 63 
        80 - 99% = 10 
 
XQD_1000_3300 (178) 
    Primary pointer page: 553, Index root page: 554 
    Total formats: 1, used formats: 1 
    Average record length: 64.04, total records: 7043219 
    Average version length: 68.79, total versions: 502449, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.97 
    Pointer pages: 63, data page slots: 101296 
    Data pages: 101296, average fill: 75% 
    Primary pages: 101296, secondary pages: 0, swept pages: 17755 
    Empty pages: 22, full pages: 79404 
    Fill distribution: 
     0 - 19% = 91 
    20 - 39% = 627 
    40 - 59% = 5594 
    60 - 79% = 86664 
    80 - 99% = 8320 
 
    Index XQD_1000_3300_WA_SO_RO_WKR_SND (0) 
    Root page: 1480454, depth: 3, leaf buckets: 10553, nodes: 7043219 
    Average node length: 6.51, total dup: 6094082, max dup: 29 
    Average key length: 3.52, compression ratio: 11.94 
    Average prefix length: 40.62, average data length: 1.38 
    Clustering factor: 1566978, ratio: 0.22 
    Fill distribution: 
         0 - 19% = 8 
        20 - 39% = 1636 
        40 - 59% = 5579 
        60 - 79% = 2796 
        80 - 99% = 534 
 
    Index XQD_1000_3300_WKR_DOC_ASC (1) 
    Root page: 1486068, depth: 3, leaf buckets: 8384, nodes: 7043219 
    Average node length: 5.39, total dup: 6763552, max dup: 183 
    Average key length: 2.41, compression ratio: 7.07 
    Average prefix length: 16.63, average data length: 0.37 
    Clustering factor: 1361122, ratio: 0.19 
    Fill distribution: 
         0 - 19% = 11 
        20 - 39% = 1161 
        40 - 59% = 4426 
        60 - 79% = 1668 
        80 - 99% = 1118 
 
    Index XQD_1000_3300_WKR_DOC_DEC (2) 
    Root page: 1490608, depth: 3, leaf buckets: 8401, nodes: 7043219 
    Average node length: 5.39, total dup: 6763552, max dup: 183 
    Average key length: 2.41, compression ratio: 7.07 
    Average prefix length: 16.63, average data length: 0.37 
    Clustering factor: 1363544, ratio: 0.19 
    Fill distribution: 
         0 - 19% = 9 
        20 - 39% = 1168 
        40 - 59% = 4395 
        60 - 79% = 1680 
        80 - 99% = 1149 
 
XQD_1200_2000 (177) 
    Primary pointer page: 551, Index root page: 552 
    Total formats: 1, used formats: 1 
    Average record length: 66.77, total records: 11938404 
    Average version length: 68.74, total versions: 378895, 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: 166176 
    Data pages: 166176, average fill: 76% 
    Primary pages: 166176, secondary pages: 0, swept pages: 70195 
    Empty pages: 12, full pages: 153034 
    Fill distribution: 
     0 - 19% = 38 
    20 - 39% = 388 
    40 - 59% = 3304 
    60 - 79% = 155346 
    80 - 99% = 7100 
 
    Index XQD_1200_2000_WA_SO_RO_WKR_SND (0) 
    Root page: 1495028, depth: 3, leaf buckets: 18245, nodes: 11938404 
    Average node length: 6.57, total dup: 10405101, max dup: 64 
    Average key length: 3.43, compression ratio: 12.25 
    Average prefix length: 40.70, average data length: 1.30 
    Clustering factor: 2354214, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 33 
        20 - 39% = 2416 
        40 - 59% = 10714 
        60 - 79% = 4284 
        80 - 99% = 798 
 
XQD_2000_3300 (179) 
    Primary pointer page: 555, Index root page: 556 
    Total formats: 1, used formats: 1 
    Average record length: 40.48, total records: 1690276 
    Average version length: 69.13, total versions: 700971, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 3.11 
    Pointer pages: 28, data page slots: 43824 
    Data pages: 27888, average fill: 70% 
    Primary pages: 27887, secondary pages: 1, swept pages: 5016 
    Empty pages: 1976, full pages: 20501 
    Fill distribution: 
     0 - 19% = 3057 
    20 - 39% = 1457 
    40 - 59% = 1556 
    60 - 79% = 10480 
    80 - 99% = 11338 
 
    Index XQD_2000_3300_WA_SO_RO_WKR_SND (0) 
    Root page: 1479712, depth: 3, leaf buckets: 2199, nodes: 1690276 
    Average node length: 5.52, total dup: 1621700, max dup: 99 
    Average key length: 2.56, compression ratio: 16.42 
    Average prefix length: 41.48, average data length: 0.52 
    Clustering factor: 114367, ratio: 0.07 
    Fill distribution: 
         0 - 19% = 9 
        20 - 39% = 482 
        40 - 59% = 1057 
        60 - 79% = 492 
        80 - 99% = 159 
 
XQD_2100_3300 (180) 
    Primary pointer page: 557, Index root page: 558 
    Total formats: 1, used formats: 1 
    Average record length: 41.01, total records: 1140411 
    Average version length: 69.13, total versions: 462767, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 3.07 
    Pointer pages: 20, data page slots: 32544 
    Data pages: 27176, average fill: 49% 
    Primary pages: 27176, secondary pages: 0, swept pages: 5258 
    Empty pages: 4581, full pages: 12103 
    Fill distribution: 
     0 - 19% = 8415 
    20 - 39% = 3100 
    40 - 59% = 1914 
    60 - 79% = 6294 
    80 - 99% = 7453 
 
    Index XQD_2100_3300_WA_SO_RO_WKR_SND (0) 
    Root page: 1479207, depth: 3, leaf buckets: 1658, nodes: 1140411 
    Average node length: 5.78, total dup: 1065939, max dup: 103 
    Average key length: 2.84, compression ratio: 14.77 
    Average prefix length: 41.22, average data length: 0.78 
    Clustering factor: 152197, ratio: 0.13 
    Fill distribution: 
         0 - 19% = 4 
        20 - 39% = 469 
        40 - 59% = 789 
        60 - 79% = 342 
        80 - 99% = 54 
 
XQD_3300_3400 (181) 
    Primary pointer page: 559, Index root page: 560 
    Total formats: 1, used formats: 1 
    Average record length: 65.66, total records: 9374680 
    Average version length: 68.98, total versions: 440327, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.92 
    Pointer pages: 90, data page slots: 145624 
    Data pages: 145584, average fill: 69% 
    Primary pages: 145584, secondary pages: 0, swept pages: 50342 
    Empty pages: 507, full pages: 89110 
    Fill distribution: 
     0 - 19% = 1474 
    20 - 39% = 7179 
    40 - 59% = 23093 
    60 - 79% = 106164 
    80 - 99% = 7674 
 
    Index XQD_3300_3400_WA_SO_RO_WKR_SND (0) 
    Root page: 1472590, depth: 3, leaf buckets: 13500, nodes: 9374680 
    Average node length: 6.69, total dup: 7777301, max dup: 25 
    Average key length: 3.66, compression ratio: 11.46 
    Average prefix length: 40.51, average data length: 1.49 
    Clustering factor: 2042863, ratio: 0.22 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 1041 
        40 - 59% = 6716 
        60 - 79% = 5015 
        80 - 99% = 728 
 
XQS_1000_1200 (182) 
    Primary pointer page: 561, Index root page: 562 
    Total formats: 1, used formats: 1 
    Average record length: 82.49, total records: 21169093 
    Average version length: 82.75, total versions: 11684, 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: 318944 
    Data pages: 318944, average fill: 81% 
    Primary pages: 318944, secondary pages: 0, swept pages: 12208 
    Empty pages: 13, full pages: 318625 
    Fill distribution: 
     0 - 19% = 16 
    20 - 39% = 12 
    40 - 59% = 41 
    60 - 79% = 27148 
    80 - 99% = 291727 
 
    Index XQS_1000_1200_DOC_ID (1) 
    Root page: 1426716, depth: 3, leaf buckets: 19346, nodes: 21169093 
    Average node length: 5.72, total dup: 20687740, max dup: 144 
    Average key length: 2.16, compression ratio: 4.16 
    Average prefix length: 8.86, average data length: 0.14 
    Clustering factor: 3282853, ratio: 0.16 
    Fill distribution: 
         0 - 19% = 7 
        20 - 39% = 3 
        40 - 59% = 8036 
        60 - 79% = 553 
        80 - 99% = 10747 
 
    Index XQS_1000_1200_RCV_ID (3) 
    Root page: 1456980, depth: 3, leaf buckets: 17179, nodes: 21169093 
    Average node length: 6.31, total dup: 18603132, max dup: 49 
    Average key length: 2.75, compression ratio: 3.27 
    Average prefix length: 8.37, average data length: 0.63 
    Clustering factor: 915521, ratio: 0.04 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 4 
        40 - 59% = 782 
        60 - 79% = 262 
        80 - 99% = 16129 
 
    Index XQS_1000_1200_SND_ID (2) 
    Root page: 1441073, depth: 3, leaf buckets: 21104, nodes: 21169093 
    Average node length: 6.35, total dup: 18522599, max dup: 29 
    Average key length: 2.79, compression ratio: 3.23 
    Average prefix length: 8.34, average data length: 0.66 
    Clustering factor: 3578020, ratio: 0.17 
    Fill distribution: 
         0 - 19% = 9 
        20 - 39% = 2 
        40 - 59% = 8259 
        60 - 79% = 602 
        80 - 99% = 12232 
 
    Index XQS_1000_1200_WORKER_ID (0) 
    Root page: 1413348, depth: 3, leaf buckets: 16141, nodes: 21169093 
    Average node length: 5.56, total dup: 21168993, max dup: 233038 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.42, average data length: 0.00 
    Clustering factor: 944340, ratio: 0.04 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 9 
        40 - 59% = 2944 
        60 - 79% = 390 
        80 - 99% = 12796 
 
XQS_1000_3300 (184) 
    Primary pointer page: 565, Index root page: 566 
    Total formats: 1, used formats: 1 
    Average record length: 78.55, total records: 9855009 
    Average version length: 82.62, total versions: 462593, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.60 
    Pointer pages: 106, data page slots: 171856 
    Data pages: 171792, average fill: 71% 
    Primary pages: 171792, secondary pages: 0, swept pages: 65227 
    Empty pages: 606, full pages: 106615 
    Fill distribution: 
     0 - 19% = 1644 
    20 - 39% = 7250 
    40 - 59% = 25694 
    60 - 79% = 68460 
    80 - 99% = 68744 
 
    Index XQS_1000_3300_DOC_ID (1) 
    Root page: 1367502, depth: 3, leaf buckets: 11395, nodes: 9855009 
    Average node length: 5.37, total dup: 9543953, max dup: 207 
    Average key length: 2.23, compression ratio: 4.04 
    Average prefix length: 8.80, average data length: 0.20 
    Clustering factor: 2174735, ratio: 0.22 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 60 
        40 - 59% = 7808 
        60 - 79% = 3414 
        80 - 99% = 111 
 
    Index XQS_1000_3300_RCV_ID (3) 
    Root page: 1379261, depth: 3, leaf buckets: 13781, nodes: 9855009 
    Average node length: 6.24, total dup: 8170371, max dup: 14 
    Average key length: 3.10, compression ratio: 2.90 
    Average prefix length: 8.07, average data length: 0.93 
    Clustering factor: 1501412, ratio: 0.15 
    Fill distribution: 
         0 - 19% = 124 
        20 - 39% = 4112 
        40 - 59% = 4397 
        60 - 79% = 2661 
        80 - 99% = 2487 
 
    Index XQS_1000_3300_SND_ID (2) 
    Root page: 1373059, depth: 3, leaf buckets: 12716, nodes: 9855009 
    Average node length: 5.98, total dup: 8555188, max dup: 44 
    Average key length: 2.85, compression ratio: 3.16 
    Average prefix length: 8.29, average data length: 0.71 
    Clustering factor: 2366415, ratio: 0.24 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 68 
        40 - 59% = 8739 
        60 - 79% = 3765 
        80 - 99% = 142 
 
    Index XQS_1000_3300_WORKER_ID (0) 
    Root page: 1362767, depth: 3, leaf buckets: 10298, nodes: 9855009 
    Average node length: 5.14, total dup: 9854909, max dup: 168310 
    Average key length: 2.00, compression ratio: 1.20 
    Average prefix length: 2.41, average data length: 0.00 
    Clustering factor: 1543564, ratio: 0.16 
    Fill distribution: 
         0 - 19% = 46 
        20 - 39% = 1236 
        40 - 59% = 5209 
        60 - 79% = 1667 
        80 - 99% = 2140 
 
XQS_1200_2000 (183) 
    Primary pointer page: 563, Index root page: 564 
    Total formats: 1, used formats: 1 
    Average record length: 80.14, total records: 11477103 
    Average version length: 82.64, total versions: 302920, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.57 
    Pointer pages: 120, data page slots: 194264 
    Data pages: 192936, average fill: 73% 
    Primary pages: 192936, secondary pages: 0, swept pages: 72512 
    Empty pages: 3016, full pages: 144450 
    Fill distribution: 
     0 - 19% = 4871 
    20 - 39% = 7163 
    40 - 59% = 18304 
    60 - 79% = 43945 
    80 - 99% = 118653 
 
    Index XQS_1200_2000_DOC_ID (1) 
    Root page: 1392101, depth: 3, leaf buckets: 13150, nodes: 11477103 
    Average node length: 5.30, total dup: 11367008, max dup: 643 
    Average key length: 2.08, compression ratio: 4.33 
    Average prefix length: 8.93, average data length: 0.07 
    Clustering factor: 2389083, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 71 
        40 - 59% = 8874 
        60 - 79% = 3985 
        80 - 99% = 218 
 
    Index XQS_1200_2000_RCV_ID (3) 
    Root page: 1406110, depth: 3, leaf buckets: 10557, nodes: 11477103 
    Average node length: 5.50, total dup: 10976801, max dup: 49 
    Average key length: 2.28, compression ratio: 3.95 
    Average prefix length: 8.77, average data length: 0.23 
    Clustering factor: 721002, ratio: 0.06 
    Fill distribution: 
         0 - 19% = 145 
        20 - 39% = 844 
        40 - 59% = 2568 
        60 - 79% = 1825 
        80 - 99% = 5175 
 
    Index XQS_1200_2000_SND_ID (2) 
    Root page: 1398638, depth: 3, leaf buckets: 15047, nodes: 11477103 
    Average node length: 6.03, total dup: 10017442, max dup: 63 
    Average key length: 2.80, compression ratio: 3.21 
    Average prefix length: 8.32, average data length: 0.68 
    Clustering factor: 2405521, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 5 
        20 - 39% = 92 
        40 - 59% = 10419 
        60 - 79% = 4288 
        80 - 99% = 243 
 
    Index XQS_1200_2000_WORKER_ID (0) 
    Root page: 1386211, depth: 3, leaf buckets: 10927, nodes: 11477103 
    Average node length: 5.23, total dup: 11477003, max dup: 221324 
    Average key length: 2.00, compression ratio: 1.20 
    Average prefix length: 2.40, average data length: 0.00 
    Clustering factor: 709863, ratio: 0.06 
    Fill distribution: 
         0 - 19% = 97 
        20 - 39% = 832 
        40 - 59% = 4938 
        60 - 79% = 1465 
        80 - 99% = 3595 
 
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: 79.40, total records: 9907182 
    Average version length: 82.92, total versions: 399948, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.59 
    Pointer pages: 108, data page slots: 175832 
    Data pages: 175800, average fill: 70% 
    Primary pages: 175800, secondary pages: 0, swept pages: 75873 
    Empty pages: 922, full pages: 103764 
    Fill distribution: 
     0 - 19% = 2389 
    20 - 39% = 8549 
    40 - 59% = 28625 
    60 - 79% = 69937 
    80 - 99% = 66300 
 
    Index XQS_2100_3300_DOC_ID (1) 
    Root page: 1344686, depth: 3, leaf buckets: 11940, nodes: 9907182 
    Average node length: 5.18, total dup: 9878042, max dup: 1534 
    Average key length: 2.03, compression ratio: 4.43 
    Average prefix length: 8.97, average data length: 0.03 
    Clustering factor: 1966122, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 29 
        20 - 39% = 1483 
        40 - 59% = 7955 
        60 - 79% = 1845 
        80 - 99% = 628 
 
    Index XQS_2100_3300_RCV_ID (3) 
    Root page: 1355717, depth: 3, leaf buckets: 13832, nodes: 9907182 
    Average node length: 6.25, total dup: 8213940, max dup: 14 
    Average key length: 3.10, compression ratio: 2.90 
    Average prefix length: 8.07, average data length: 0.93 
    Clustering factor: 1465235, ratio: 0.15 
    Fill distribution: 
         0 - 19% = 159 
        20 - 39% = 4097 
        40 - 59% = 4324 
        60 - 79% = 2674 
        80 - 99% = 2578 
 
    Index XQS_2100_3300_SND_ID (2) 
    Root page: 1350049, depth: 3, leaf buckets: 12617, nodes: 9907182 
    Average node length: 5.44, total dup: 9464656, max dup: 99 
    Average key length: 2.29, compression ratio: 3.94 
    Average prefix length: 8.76, average data length: 0.24 
    Clustering factor: 2102410, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 36 
        20 - 39% = 1424 
        40 - 59% = 8872 
        60 - 79% = 1701 
        80 - 99% = 584 
 
    Index XQS_2100_3300_WORKER_ID (0) 
    Root page: 985805, depth: 3, leaf buckets: 10362, nodes: 9907182 
    Average node length: 5.15, total dup: 9907082, max dup: 170667 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.41, average data length: 0.00 
    Clustering factor: 1559871, ratio: 0.16 
    Fill distribution: 
         0 - 19% = 47 
        20 - 39% = 1223 
        40 - 59% = 5251 
        60 - 79% = 1691 
        80 - 99% = 2150 
 
XQS_3300_3400 (187) 
    Primary pointer page: 571, Index root page: 572 
    Total formats: 1, used formats: 1 
    Average record length: 67.57, total records: 578026 
    Average version length: 68.88, total versions: 5145, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.86 
    Pointer pages: 5, data page slots: 8040 
    Data pages: 8040, average fill: 75% 
    Primary pages: 8040, secondary pages: 0, swept pages: 3747 
    Empty pages: 6, full pages: 6810 
    Fill distribution: 
     0 - 19% = 9 
    20 - 39% = 29 
    40 - 59% = 251 
    60 - 79% = 7669 
    80 - 99% = 82 
 
    Index XQS_3300_3400_DOC_ID (1) 
    Root page: 32303, depth: 3, leaf buckets: 744, nodes: 578026 
    Average node length: 5.95, total dup: 492260, max dup: 83 
    Average key length: 3.09, compression ratio: 2.91 
    Average prefix length: 8.06, average data length: 0.94 
    Clustering factor: 100586, ratio: 0.17 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 31 
        40 - 59% = 527 
        60 - 79% = 103 
        80 - 99% = 83 
 
    Index XQS_3300_3400_SND_ID (2) 
    Root page: 20497, depth: 3, leaf buckets: 754, nodes: 578026 
    Average node length: 6.15, total dup: 474103, max dup: 27 
    Average key length: 3.29, compression ratio: 2.73 
    Average prefix length: 7.89, average data length: 1.11 
    Clustering factor: 100640, ratio: 0.17 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 31 
        40 - 59% = 510 
        60 - 79% = 107 
        80 - 99% = 104 
 
    Index XQS_3300_3400_WORKER_ID (0) 
    Root page: 375548, depth: 2, leaf buckets: 580, nodes: 578026 
    Average node length: 4.86, total dup: 577926, max dup: 9330 
    Average key length: 2.00, compression ratio: 1.20 
    Average prefix length: 2.41, average data length: 0.00 
    Clustering factor: 89346, ratio: 0.15 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 43 
        40 - 59% = 321 
        60 - 79% = 101 
        80 - 99% = 115 
 
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 Thu Feb 22 01:11:55 2024

Record versions statistics, table

TABLE_NAME TOTAL_RECS TOTAL_VERS MAX_VERSIONS VERS_TO_RECS_PRC MAXV_TO_VERS_PRC
DOC_DATA 7795461 81967 1 0.0000 0.0000
DOC_LIST 2271689 79475 3 0.0000 0.0000
FB_ERRORS 2182 757 1 0.0000 0.0000
INVNT_SALDO 400 236578 618 59100.0000 0.0000
INVNT_TURNOVER_LOG 84215 73406 1 0.0000 0.0000
MONEY_SALDO 49 18165 941 37000.0000 0.0000
MONEY_TURNOVER_LOG 1656 1576 1 0.0000 0.0000
PDISTR 800467 80837 4 0.0000 0.0000
PERF_SPLIT_0 173036 3430 1 0.0000 0.0000
PERF_SPLIT_1 194080 7419 1 0.0000 0.0000
PERF_SPLIT_2 189115 29644 1 0.0000 0.0000
PERF_SPLIT_3 181322 7246 1 0.0000 0.0000
PERF_SPLIT_4 154511 5687 1 0.0000 0.0000
PERF_SPLIT_5 170757 7389 1 0.0000 0.0000
PERF_SPLIT_6 186652 8641 1 0.0000 0.0000
PERF_SPLIT_7 157251 3825 1 0.0000 0.0000
PERF_SPLIT_8 173328 5960 1 0.0000 0.0000
PERF_SPLIT_9 188186 5766 1 0.0000 0.0000
PSTORNED 2116284 36208 1 0.0000 0.0000
SEMAPHORES 5 1 1 0.0000 100.0000
XQD_1000_1200 147475 65040 1 0.0000 0.0000
XQD_1000_3300 7043219 502449 1 0.0000 0.0000
XQD_1200_2000 11938404 378895 1 0.0000 0.0000
XQD_2000_3300 1690276 700971 1 0.0000 0.0000
XQD_2100_3300 1140411 462767 1 0.0000 0.0000
XQD_3300_3400 9374680 440327 1 0.0000 0.0000
XQS_1000_1200 21169093 11684 1 0.0000 0.0000
XQS_1000_3300 9855009 462593 1 0.0000 0.0000
XQS_1200_2000 11477103 302920 1 0.0000 0.0000
XQS_2100_3300 9907182 399948 1 0.0000 0.0000
XQS_3300_3400 578026 5145 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 ---
:947: 
:948: mscs-test-161.budzdorov.ru    Thu Feb 22 01:10:07 2024
:949:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:950: 
:951: 
:952: mscs-test-161.budzdorov.ru    Thu Feb 22 01:10:08 2024
:953:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:954: 
:955: 
:956: mscs-test-161.budzdorov.ru    Thu Feb 22 01:10:10 2024
:957:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:958: 
--- end of diff output ---

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

22.02.24 01:12:07. 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-02-22 01:12:09 No severe PSQL-related problems occured
22.02.24 01:12:10. End of report.