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

Server and database settinfs 


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

Test configuration settings 

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

Test finish info 


FINISH_STATE                    NORMAL: TEST_TIME EXPIRED AT 2024-03-06 01:09:46
DTS_END                         2024-03-06 01:09:46.3990
FB_GDSCODE                      -1
FB_MNEMONA                      
STACK                           SP_CANCEL_SUPPLIER_ORDER(116:18) ==> SP_CANCEL_CUSTOMER_RESERVE(36:5) ==> SP_CHECK_TO_STOP_WORK(32:12) ==> SP_HALT_ON_ERROR(57:17)
IP                              ::1/51080
TRN_ID                          175535
ATT_ID                          574
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: 8995.13 26179 899513
customer order: creation 177.05 367 17705
customer order: refuse 14.83 366 1483
order to supplier: creation 46.71 1352 4671
order to supplier: removal 3.49 109992 349
invoice (draft): creation 46.93 3491 4693
invoice (draft): removal 48.85 871 4885
invoice accept: apply 43.11 21156 4311
invoice accept: cancel 43.44 907 4344
customer reserve: creation 4043.55 207 404355
customer reserve: removal 4229.00 72 422900
realization accept: apply 85.84 229 8584
realization accept: cancel 77.74 139 7774
payment from customer: creation 61.28 121 6128
payment from customer: removal 5.68 88 568
payment to supplier: creation 50.89 148 5089
payment to supplier: removal 3.87 93 387
service: total inventory turnovers 4.83 1218 483
service: total monetary turnovers 7.17 37 717
service: aggregate perf. data 0.84 23276 84
service: refresh index statistics 0.03 359447 3

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:02, from 06-03-2024 01:12:36 to 06-03-2024 01:12:38.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 2593
TEST_TIME 2 3472
TEST_TIME 3 2899
TEST_TIME 4 3325
TEST_TIME 5 4040
TEST_TIME 6 4191
TEST_TIME 7 4135
TEST_TIME 8 4987
TEST_TIME 9 5046
TEST_TIME 10 5313
TEST_TIME 11 5482
TEST_TIME 12 5995
TEST_TIME 13 6103
TEST_TIME 14 6201
TEST_TIME 15 6320
TEST_TIME 16 6312
TEST_TIME 17 6421
TEST_TIME 18 6453
TEST_TIME 19 6962
TEST_TIME 20 6976
TEST_TIME 21 7239
TEST_TIME 22 7228
TEST_TIME 23 7216
TEST_TIME 24 7540
TEST_TIME 25 7950
TEST_TIME 26 7882
TEST_TIME 27 7920
TEST_TIME 28 7980
TEST_TIME 29 8016
TEST_TIME 30 8206
TEST_TIME 31 8304
TEST_TIME 32 8631
TEST_TIME 33 9015
TEST_TIME 34 9674
TEST_TIME 35 9662
TEST_TIME 36 9595
TEST_TIME 37 9596
TEST_TIME 38 9633
TEST_TIME 39 9510
TEST_TIME 40 9419
TEST_TIME 41 9354
TEST_TIME 42 9345
TEST_TIME 43 9327
TEST_TIME 44 9169
TEST_TIME 45 9128
TEST_TIME 46 9211
TEST_TIME 47 9215
TEST_TIME 48 9148
TEST_TIME 49 9145
TEST_TIME 50 9289
TEST_TIME 51 9306
TEST_TIME 52 9445
TEST_TIME 53 9418
TEST_TIME 54 9372
TEST_TIME 55 9414
TEST_TIME 56 9412
TEST_TIME 57 9504
TEST_TIME 58 9448
TEST_TIME 59 9431
TEST_TIME 60 9400
TEST_TIME 61 9448
TEST_TIME 62 9440
TEST_TIME 63 9485
TEST_TIME 64 9463
TEST_TIME 65 9390
TEST_TIME 66 9513
TEST_TIME 67 9446
TEST_TIME 68 9317
TEST_TIME 69 9311
TEST_TIME 70 9375
TEST_TIME 71 9303
TEST_TIME 72 9266
TEST_TIME 73 9274
TEST_TIME 74 9187
TEST_TIME 75 9212
TEST_TIME 76 9182
TEST_TIME 77 9215
TEST_TIME 78 9244
TEST_TIME 79 9279
TEST_TIME 80 9281
TEST_TIME 81 9226
TEST_TIME 82 9269
TEST_TIME 83 9301
TEST_TIME 84 9319
TEST_TIME 85 9318
TEST_TIME 86 9289
TEST_TIME 87 9320
TEST_TIME 88 9312
TEST_TIME 89 9350
TEST_TIME 90 9416
TEST_TIME 91 9365
TEST_TIME 92 9286
TEST_TIME 93 9244
TEST_TIME 94 9178
TEST_TIME 95 9171
TEST_TIME 96 9189
TEST_TIME 97 9137
TEST_TIME 98 9091
TEST_TIME 99 9019
TEST_TIME 100 9000

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:03, from 06-03-2024 01:12:40 to 06-03-2024 01:12:43.

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 1269622 1269622 0 0.00 0 23194 8 0 0
doc_list_biud 1269621 1269621 0 0.00 0 29907 30 0 0
sp_add_invoice_to_stock 4429 4311 118 2.66 27 211102 21157 0 118
sp_cancel_adding_invoice 4344 4344 0 0.00 3 59335 907 0 0
sp_cancel_client_order 1483 1483 0 0.00 4 8973 367 0 0
sp_cancel_customer_reserve 422900 422900 0 0.00 0 25446 72 0 0
sp_cancel_pay_from_customer 568 568 0 0.00 3 5739 89 0 0
sp_cancel_pay_to_supplier 387 387 0 0.00 2 9605 93 0 0
sp_cancel_supplier_invoice 4896 4885 11 0.22 1 17405 871 0 11
sp_cancel_supplier_order 349 349 0 0.00 6 985354 109992 0 0
sp_cancel_write_off 7774 7774 0 0.00 1 16737 140 0 0
sp_client_order 17705 17705 0 0.00 3 19716 367 0 0
sp_customer_reserve 404355 404355 0 0.00 0 54626 207 0 0
sp_fill_shopping_cart 27061 27061 0 0.00 1 17431 39 0 0
sp_fill_shopping_cart_clo_res 404352 404352 0 0.00 0 18004 13 0 0
sp_get_clo_for_invoice 4305 4305 0 0.00 0 26009 268 0 0
sp_kill_cost_storno 13073 13073 0 0.00 0 6116 65 0 0
sp_kill_qstorno_ret_qs2qd 858808 858808 0 0.00 0 25444 39 0 0
sp_kill_qty_storno 454624 454624 0 0.00 0 29906 83 0 0
sp_lock_selected_doc 17811 17811 0 0.00 0 9358 6 0 0
sp_make_cost_storno 24106 24106 0 0.00 0 23075 72 0 0
sp_multiply_rows_for_pdistr 24106 24106 0 0.00 0 6024 29 0 0
sp_multiply_rows_for_qdistr 17705 17705 0 0.00 0 10379 154 0 0
sp_pay_from_customer 6128 6128 0 0.00 4 14324 121 0 0
sp_pay_to_supplier 5089 5089 0 0.00 4 14543 148 0 0
sp_payment_common 11217 11217 0 0.00 1 10688 26 0 0
sp_qd_handle_on_cancel_clo 1483 1483 0 0.00 0 8966 340 0 0
sp_qd_handle_on_invoice_upd_sts 8649 8649 0 0.00 0 29906 363 0 0
sp_qd_handle_on_reserve_upd_sts 8584 8584 0 0.00 0 20490 73 0 0
sp_reserve_write_off 8584 8584 0 0.00 7 20503 229 0 0
sp_supplier_invoice 4693 4693 0 0.00 5 85116 3492 0 0
sp_supplier_order 4671 4671 0 0.00 6 23493 1353 0 0
srv_aggregate_perf_data 85 84 1 1.17 1889 312676 23276 0 1
srv_fill_mon_cache_memory 57 57 0 0.00 1483 160388 39186 0 0
srv_find_qd_qs_mism 856041 856041 0 0.00 0 19285 7 0 0
srv_make_invnt_saldo 483 483 0 0.00 34 49211 1219 0 0
srv_make_money_saldo 717 717 0 0.00 1 4408 37 0 0
srv_recalc_idx_stat 3 3 0 0.00 186531 527855 359447 0 0
t$perf-abend:sp_add_invoice_to_stock 118 118 0 0.00 0 0 0 0 0
t$perf-abend:sp_cancel_supplier_invoice 11 11 0 0.00 0 0 0 0 0
t$perf-abend:srv_aggregate_perf_data 1 1 0 0.00 0 0 0 0 0
t$perf-norm:sp_add_invoice_to_stock 4311 4311 0 0.00 0 15379 218 0 0
t$perf-norm:sp_cancel_adding_invoice 336 336 0 0.00 0 6541 125 0 0
t$perf-norm:sp_cancel_client_order 1483 1483 0 0.00 0 3002 17 0 0
t$perf-norm:sp_cancel_customer_reserve 610 610 0 0.00 0 2109 12 0 0
t$perf-norm:sp_cancel_pay_from_customer 568 568 0 0.00 0 3995 19 0 0
t$perf-norm:sp_cancel_pay_to_supplier 387 387 0 0.00 0 1373 9 0 0
t$perf-norm:sp_cancel_supplier_invoice 374 374 0 0.00 0 337 12 0 0
t$perf-norm:sp_cancel_supplier_order 349 349 0 0.00 0 28733 2005 0 0
t$perf-norm:sp_cancel_write_off 815 815 0 0.00 0 11573 20 0 0
t$perf-norm:sp_client_order 17705 17705 0 0.00 0 14316 19 0 0
t$perf-norm:sp_customer_reserve 880 880 0 0.00 0 10461 22 0 0
t$perf-norm:sp_pay_from_customer 6128 6128 0 0.00 0 14154 15 0 0
t$perf-norm:sp_pay_to_supplier 5089 5089 0 0.00 0 5043 14 0 0
t$perf-norm:sp_reserve_write_off 8584 8584 0 0.00 0 14238 14 0 0
t$perf-norm:sp_supplier_invoice 4693 4693 0 0.00 0 6400 22 0 0
t$perf-norm:sp_supplier_order 4671 4671 0 0.00 0 4623 18 0 0
t$perf-norm:srv_aggregate_perf_data 84 84 0 0.00 0 209 8 0 0
t$perf-norm:srv_fill_mon_cache_memory 57 57 0 0.00 0 145 3 0 0
t$perf-norm:srv_make_invnt_saldo 483 483 0 0.00 0 3206 33 0 0
t$perf-norm:srv_make_money_saldo 717 717 0 0.00 0 1854 20 0 0
t$perf-norm:srv_recalc_idx_stat 3 3 0 0.00 3 3 3 0 0
v_add_invoice_to_stock 8844 8608 236 2.66 0 9234 21 0 236
v_all_customers 32952 32952 0 0.00 0 23 1 0 0
v_all_suppliers 26622 26622 0 0.00 0 22 1 0 0
v_all_wares 35410 35410 0 0.00 0 24 1 0 0
v_cancel_adding_invoice 672 672 0 0.00 0 277 6 0 0
v_cancel_client_order 2966 2966 0 0.00 0 4858 6 0 0
v_cancel_customer_prepayment 1136 1136 0 0.00 0 1653 4 0 0
v_cancel_customer_reserve 1220 1220 0 0.00 0 5862 15 0 0
v_cancel_payment_to_supplier 774 774 0 0.00 0 2346 7 0 0
v_cancel_supplier_invoice 770 748 22 2.85 0 2334 20 0 22
v_cancel_supplier_order 698 698 0 0.00 0 1753 6 0 0
v_cancel_write_off 1630 1630 0 0.00 0 4369 19 0 0
v_max_id_clo_ord 4668 4668 0 0.00 0 715 2 0 0
v_max_id_clo_res 880 880 0 0.00 0 1469 9 0 0
v_max_id_ord_sup 4688 4688 0 0.00 0 4950 6 0 0
v_max_non_paid_invoice 1134 1134 0 0.00 0 271 3 0 0
v_max_non_paid_realizn 2984 2984 0 0.00 0 8588 10 0 0
v_min_id_clo_ord 4668 4668 0 0.00 0 3840 9 0 0
v_min_id_clo_res 880 880 0 0.00 0 262 2 0 0
v_min_id_ord_sup 4688 4688 0 0.00 0 6773 11 0 0
v_min_non_paid_invoice 5089 5089 0 0.00 0 6034 16 0 0
v_min_non_paid_realizn 6128 6128 0 0.00 0 6019 21 0 0
v_our_firm 8746 8746 0 0.00 0 15 1 0 0
v_reserve_write_off 17168 17168 0 0.00 0 5917 8 0 0
x_lock_depdocs_on_canc_invoice 8855 8855 0 0.00 0 13977 150 0 0
x_lock_depdocs_on_canc_sup_ord 349 349 0 0.00 0 3835 307 0 0
x_make_qstorno_1000_1200 4671 4671 0 0.00 1 23478 1261 0 0
x_make_qstorno_1200_2000 4693 4693 0 0.00 2 85095 3352 0 0
x_make_qstorno_2100_3300 404355 404355 0 0.00 0 54625 191 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 06-03-2024 01:12:44 to 06-03-2024 01:12:48.

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:50 2 8192000000 8797116768 8807743488 3953616 0.048 1 1 2 0 4051888 55488 42784
23:10:51 27426 8192000000 9909396864 10223693824 994701952 10.827 100 89 178 0 1023359008 5925456 22731600
23:12:28 20058 8192000000 9967068528 10290147328 1045693408 11.319 100 96 192 1 1079153088 9531456 23928224
23:13:53 12047 8192000000 9979576560 10312130560 1061715584 11.473 100 83 166 0 1092416416 10439136 20261696
23:15:19 9152 8192000000 10016951712 10363731968 1108719984 11.920 100 76 152 0 1137850640 10791088 18339568
23:16:30 7816 8192000000 10058712384 10415476736 1146372640 12.275 100 84 167 2 1177963536 12573584 19017312
23:17:41 6461 8192000000 10104421024 10474209280 1193731552 12.718 100 79 158 1 1223739440 12410288 17597600
23:18:51 2708 8192000000 10162015632 10534924288 1242977504 13.174 100 85 168 0 1274401664 12362416 19061744
23:19:55 1712 8192000000 10186477760 10564210688 1269537488 13.417 100 92 185 0 1304689440 14702416 20449536
23:20:58 2768 8192000000 10197300800 10585911296 1293924848 13.640 100 79 156 0 1323879248 12333968 17620432
23:22:06 12214 8192000000 10184539968 10589855744 1299394480 13.690 100 23 47 0 1310024080 5276016 5353584
23:23:23 5897 8192000000 10195701376 10605985792 1309866624 13.785 100 32 62 0 1323113616 6388160 6858832
23:24:33 8189 8192000000 10211541024 10621960192 1319952160 13.876 100 33 66 1 1335552256 8142560 7457536
23:25:43 60157 8192000000 10238557472 10644844544 1327859200 13.948 100 50 101 0 1346672064 6092448 12720416
23:27:44 5627 8192000000 10230012272 10644623360 1334123216 14.004 100 40 78 0 1349460624 6030176 9307232
23:28:50 5056 8192000000 10222083600 10643296256 1335908512 14.021 100 21 39 1 1346162256 5447696 4806048
23:29:57 18621 8192000000 10222949376 10631143424 1324466560 13.917 100 44 84 1 1340617936 5404816 10746560
23:31:23 82143 8192000000 10236059504 10645749760 1316918128 13.849 98 56 110 1 1339300736 9721536 12661072
23:34:02 7851 8192000000 10235473264 10651045888 1327827520 13.948 99 42 84 1 1347307536 9526288 9953728
23:35:21 12020 8192000000 10257504144 10670350336 1345364192 14.106 100 48 96 0 1369877792 13666192 10847408
23:36:38 23561 8192000000 10238741088 10650275840 1322335456 13.898 99 46 92 0 1346128560 12984352 10808752
23:38:11 3957 8192000000 10218464800 10619113472 1312397264 13.808 99 55 105 0 1338826192 14105648 12323280
23:39:19 24787 8192000000 10215582880 10619015168 1293278928 13.634 99 51 102 0 1322184640 17324064 11581648
23:40:52 20893 8192000000 10203095328 10606964736 1277539744 13.491 99 42 84 0 1305827888 17971920 10316224
23:42:17 6961 8192000000 10213223712 10617253888 1301189952 13.706 99 54 106 1 1327315792 13835808 12290032
23:43:29 4365 8192000000 10237037136 10627567616 1308292672 13.771 100 69 137 0 1341958768 17730896 15935200
23:44:37 3035 8192000000 10242746848 10643972096 1329117200 13.959 100 56 113 1 1359513744 16996912 13399632
23:45:48 7707 8192000000 10266824944 10670243840 1336810416 14.029 100 51 102 0 1373798496 24579888 12408192
23:47:01 14616 8192000000 10283690800 10688393216 1350283248 14.150 100 60 119 1 1395298448 30450336 14564864
23:48:19 7530 8192000000 10308750016 10711089152 1361677168 14.252 100 72 143 1 1412902240 33952592 17272480
23:49:35 4769 8192000000 10318079088 10718314496 1374193664 14.365 100 82 161 1 1421579632 27104368 20281600
23:50:43 8966 8192000000 10307024528 10729115648 1381580224 14.431 100 38 76 0 1418994560 27966864 9447472
23:51:55 1477 8192000000 10328414800 10740256768 1389610016 14.502 100 70 140 1 1438161024 31451984 17099024
23:53:03 14109 8192000000 10341127856 10758246400 1394243088 14.544 100 62 124 1 1449749360 39961088 15545184
23:54:26 2906 8192000000 10348521296 10763280384 1400420560 14.599 100 61 120 0 1453553488 37109264 16023664
23:55:43 2324 8192000000 10366383424 10780524544 1413576608 14.716 100 79 157 2 1468607520 36064864 18966048
23:56:50 6532 8192000000 10373678480 10798637056 1426832400 14.833 100 58 116 0 1486691296 44771008 15087888
23:58:18 12789 8192000000 10377390528 10806292480 1428294832 14.846 100 42 84 0 1486718192 46926768 11496592
23:59:33 20843 8192000000 10372506256 10820677632 1427348816 14.838 100 25 50 2 1484235328 49576640 7309872
00:01:00 19611 8192000000 10355813872 10804707328 1409120592 14.676 100 21 40 0 1469415552 53858272 6436688
00:02:33 15300 8192000000 10345369984 10793209856 1410610848 14.689 100 29 58 1 1458357440 40629280 7117312
00:03:57 53449 8192000000 10319311552 10774765568 1410265296 14.686 100 21 39 1 1424772176 9606352 4900528
00:05:54 13783 8192000000 10312129136 10759426048 1384211168 14.454 98 24 46 0 1398344240 8845936 5287136
00:07:12 69167 8192000000 10314910144 10771353600 1378858176 14.406 98 20 40 0 1401896640 18682064 4356400
00:09:22 114284 8192000000 10314484080 10772271104 1389004752 14.497 98 21 42 0 1402578944 9388976 4185216
00:12:20 94921 8192000000 10321750608 10774241280 1386505840 14.475 98 18 36 0 1403832464 13051696 4274928
00:14:56 13798 8192000000 10305369216 10754736128 1377095280 14.391 99 34 68 0 1406672144 21248256 8328608
00:16:12 49025 8192000000 10326678864 10776993792 1396965808 14.568 99 35 70 0 1427908928 22327872 8615248
00:18:31 55718 8192000000 10284505680 10746826752 1352040496 14.166 97 11 22 0 1376036976 20933488 3062992
00:20:40 45541 8192000000 10285790800 10745667584 1377009424 14.390 100 24 48 0 1407948096 24637328 6301344
00:22:26 33324 8192000000 10254067456 10700537856 1298240336 13.679 94 10 19 0 1306400528 6143680 2016512
00:24:00 64661 8192000000 10267997888 10716770304 1357004080 14.210 99 21 42 1 1376083760 14820224 4259456
00:26:15 85798 8192000000 10263722048 10705489920 1317911600 13.858 96 21 42 1 1332224976 10163888 4149488
00:28:45 18777 8192000000 10249475360 10683703296 1309497136 13.782 97 28 56 0 1322319424 6241248 6581040
00:30:07 32428 8192000000 10246167680 10690756608 1327747536 13.947 99 19 38 0 1343794288 11721312 4325440
00:31:43 38131 8192000000 10262501760 10694488064 1333904672 14.002 99 32 64 0 1353571584 12508656 7158256
00:33:26 71662 8192000000 10248399952 10675421184 1312305392 13.807 97 27 54 0 1333594048 15626096 5662560
00:35:39 57604 8192000000 10263164032 10703171584 1354623296 14.189 100 24 48 0 1369621904 9881968 5116640
00:37:42 58553 8192000000 10283544448 10719055872 1356516160 14.206 99 30 61 1 1370120016 6986528 6617328
00:39:42 51481 8192000000 10272740256 10718846976 1359171024 14.230 99 26 52 1 1374264992 9867072 5226896
00:41:34 28446 8192000000 10288233856 10723958784 1374436912 14.367 100 46 90 1 1394203184 9562704 10203568
00:43:14 30767 8192000000 10280725312 10738282496 1388001664 14.488 100 10 20 0 1399573952 9126144 2446144
00:44:52 88119 8192000000 10298873184 10747707392 1377973632 14.398 99 10 20 0 1388807264 8930016 1903616
00:47:20 65969 8192000000 10301839792 10759909376 1400272112 14.597 100 19 38 2 1417754400 12879360 4602928
00:49:27 31630 8192000000 10311558720 10761449472 1389024320 14.497 99 19 38 0 1402448512 8342080 5082112
00:51:02 43907 8192000000 10318012032 10771091456 1407062912 14.658 100 25 50 0 1422976848 10369920 5544016
00:52:57 120886 8192000000 10321233136 10775785472 1386543984 14.475 98 25 48 0 1405564480 14057952 4962544
00:55:59 53044 8192000000 10309543840 10766336000 1375619040 14.377 98 30 60 0 1392488128 10538896 6330192
00:57:55 64180 8192000000 10315723024 10776711168 1366435376 14.295 98 21 42 0 1387379472 16025584 4918512
01:00:05 160388 8192000000 10293576160 10747969536 1338862032 14.047 96 16 32 0 1354306416 11854528 3589856
01:04:46 36391 8192000000 10273678320 10735161344 1348350928 14.133 97 14 28 0 1357836000 6636704 2848368
01:07:02 94907 8192000000 10272797072 10725371904 1345055136 14.103 98 17 34 0 1359968784 10968352 3945296
01:09:37 45021 8192000000 9501897760 9838374912 646739328 7.317 48 3 6 0 659894016 12701264 453424

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:14, from 06-03-2024 01:12:50 to 06-03-2024 01:13:04.

Exceptions occured during test was in run

FB_MNEMONA CNT UNIT FB_GDSCODE
except 1 srv_aggregate_perf_data 335544517
except 118 v_add_invoice_to_stock 335544517
except 11 v_cancel_supplier_invoice 335544517

Completed "Exceptions occured during test was in run". Done for 00:00:02, from 06-03-2024 01:13:05 to 06-03-2024 01:13:07.

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          176462
MON$OLDEST_ACTIVE               177037
MON$OLDEST_SNAPSHOT             177037
MON$NEXT_TRANSACTION            177037
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                       1924320
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.33733 Firebird 3.0
Server version:
Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V3.0.12.33733 Firebird 3.0"
Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-V3.0.12.33733 Firebird 3.0/tcp (mscs-test-161.budzdorov.ru)/P15:C"
Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-V3.0.12.33733 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 Wed Mar  6 01:13:08 2024 
 
Database header page information: 
    Flags            0 
    Generation        92336 
    System Change Number    0 
    Page size        8192 
    ODS version        12.0 
    Oldest transaction    176462 
    Oldest active        177037 
    Oldest snapshot        177037 
    Next transaction    177038 
    Sequence number        0 
    Next attachment ID    714 
    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.65, total records: 7737071 
    Average version length: 48.16, total versions: 38974, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 64.00, compression ratio: 1.34 
    Pointer pages: 54, data page slots: 87144 
    Data pages: 87144, average fill: 71% 
    Primary pages: 87144, secondary pages: 0, swept pages: 32015 
    Empty pages: 5, full pages: 54678 
    Fill distribution: 
     0 - 19% = 26 
    20 - 39% = 161 
    40 - 59% = 3023 
    60 - 79% = 83931 
    80 - 99% = 3 
 
    Index DOC_DATA_DOC_WARE_UNQ (0) 
    Root page: 1510614, depth: 3, leaf buckets: 23323, nodes: 7737071 
    Average node length: 18.89, total dup: 0, max dup: 0 
    Average key length: 15.90, compression ratio: 1.70 
    Average prefix length: 14.10, average data length: 12.90 
    Clustering factor: 1703442, ratio: 0.22 
    Fill distribution: 
         0 - 19% = 357 
        20 - 39% = 1844 
        40 - 59% = 4148 
        60 - 79% = 2447 
        80 - 99% = 14527 
 
    Index DOC_DATA_ID_DESC (1) 
    Root page: 1528118, depth: 3, leaf buckets: 13530, nodes: 7737071 
    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: 1526295, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 1634 
        40 - 59% = 1994 
        60 - 79% = 1169 
        80 - 99% = 8731 
 
    Index FK_DOC_DATA_DOC_LIST (2) 
    Root page: 1546711, depth: 3, leaf buckets: 8321, nodes: 7737071 
    Average node length: 6.62, total dup: 5785967, max dup: 49 
    Average key length: 3.63, compression ratio: 2.48 
    Average prefix length: 7.62, average data length: 1.38 
    Clustering factor: 1519194, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 100 
        20 - 39% = 992 
        40 - 59% = 1375 
        60 - 79% = 952 
        80 - 99% = 4902 
 
DOC_LIST (138) 
    Primary pointer page: 472, Index root page: 473 
    Total formats: 1, used formats: 1 
    Average record length: 56.90, total records: 2242283 
    Average version length: 34.51, total versions: 38989, max versions: 3 
    Average fragment length: 5.75, total fragments: 4, max fragments: 1 
    Average unpacked length: 84.00, compression ratio: 1.48 
    Pointer pages: 18, data page slots: 28632 
    Data pages: 28632, average fill: 72% 
    Primary pages: 28625, secondary pages: 7, swept pages: 14506 
    Empty pages: 4, full pages: 18201 
    Fill distribution: 
     0 - 19% = 17 
    20 - 39% = 113 
    40 - 59% = 1931 
    60 - 79% = 26365 
    80 - 99% = 206 
 
    Index DOC_LIST_ID_DESC (1) 
    Root page: 1541130, depth: 3, leaf buckets: 4576, nodes: 2242283 
    Average node length: 11.41, total dup: 0, max dup: 0 
    Average key length: 8.44, compression ratio: 1.07 
    Average prefix length: 3.55, average data length: 5.45 
    Clustering factor: 690026, ratio: 0.31 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 949 
        40 - 59% = 849 
        60 - 79% = 762 
        80 - 99% = 2016 
 
    Index DOC_LIST_WORKER_OPTYPE (2) 
    Root page: 1544376, depth: 3, leaf buckets: 2539, nodes: 2243700 
    Average node length: 4.97, total dup: 2242801, max dup: 20269 
    Average key length: 2.01, compression ratio: 4.47 
    Average prefix length: 8.99, average data length: 0.01 
    Clustering factor: 1243546, ratio: 0.55 
    Fill distribution: 
         0 - 19% = 3 
        20 - 39% = 314 
        40 - 59% = 1511 
        60 - 79% = 526 
        80 - 99% = 185 
 
    Index FK_DOC_LIST_AGENTS (3) 
    Root page: 1545909, depth: 3, leaf buckets: 2089, nodes: 2242283 
    Average node length: 4.97, total dup: 2242233, max dup: 130324 
    Average key length: 2.01, compression ratio: 4.48 
    Average prefix length: 8.99, average data length: 0.01 
    Clustering factor: 1063565, ratio: 0.47 
    Fill distribution: 
         0 - 19% = 6 
        20 - 39% = 83 
        40 - 59% = 1151 
        60 - 79% = 54 
        80 - 99% = 795 
 
    Index PK_DOC_LIST (0) 
    Root page: 1538187, depth: 3, leaf buckets: 4381, nodes: 2242283 
    Average node length: 11.40, total dup: 0, max dup: 0 
    Average key length: 8.44, compression ratio: 1.07 
    Average prefix length: 3.55, average data length: 5.45 
    Clustering factor: 690026, ratio: 0.31 
    Fill distribution: 
         0 - 19% = 114 
        20 - 39% = 635 
        40 - 59% = 606 
        60 - 79% = 858 
        80 - 99% = 2168 
 
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.36, total records: 400 
    Average version length: 23.23, total versions: 238267, max versions: 618 
    Average fragment length: 2.04, total fragments: 54, max fragments: 1 
    Average unpacked length: 104.00, compression ratio: 1.26 
    Pointer pages: 1, data page slots: 1472 
    Data pages: 1336, average fill: 89% 
    Primary pages: 8, secondary pages: 1328, swept pages: 0 
    Empty pages: 1, full pages: 1334 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 0 
    40 - 59% = 1 
    60 - 79% = 0 
    80 - 99% = 1334 
 
    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: 12.56, total records: 81347 
    Average version length: 68.28, total versions: 66397, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 88.00, compression ratio: 7.01 
    Pointer pages: 7, data page slots: 4312 
    Data pages: 1600, average fill: 63% 
    Primary pages: 1599, secondary pages: 1, swept pages: 69 
    Empty pages: 180, full pages: 932 
    Fill distribution: 
     0 - 19% = 289 
    20 - 39% = 156 
    40 - 59% = 141 
    60 - 79% = 260 
    80 - 99% = 754 
 
    Index INVNT_TURNOVER_LOG_WARE_DD_ID (0) 
    Root page: 1708251, depth: 3, leaf buckets: 249, nodes: 81347 
    Average node length: 13.43, total dup: 4515, max dup: 1 
    Average key length: 10.78, compression ratio: 2.50 
    Average prefix length: 19.16, average data length: 7.84 
    Clustering factor: 59747, ratio: 0.73 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 36 
        40 - 59% = 107 
        60 - 79% = 102 
        80 - 99% = 3 
 
MONEY_SALDO (141) 
    Primary pointer page: 478, Index root page: 479 
    Total formats: 1, used formats: 1 
    Average record length: 15.20, total records: 49 
    Average version length: 9.00, total versions: 18852, max versions: 1025 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 32.00, compression ratio: 2.10 
    Pointer pages: 1, data page slots: 72 
    Data pages: 72, average fill: 84% 
    Primary pages: 6, secondary pages: 66, swept pages: 0 
    Empty pages: 5, full pages: 66 
    Fill distribution: 
     0 - 19% = 5 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 7 
    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: 8.87, total records: 1252 
    Average version length: 42.78, total versions: 1001, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 58.00, compression ratio: 6.54 
    Pointer pages: 1, data page slots: 40 
    Data pages: 34, average fill: 35% 
    Primary pages: 33, secondary pages: 1, swept pages: 10 
    Empty pages: 14, full pages: 9 
    Fill distribution: 
     0 - 19% = 17 
    20 - 39% = 2 
    40 - 59% = 4 
    60 - 79% = 4 
    80 - 99% = 7 
 
    Index MONEY_TURNOVER_LOG_AGENT_OPTYPE (0) 
    Root page: 91214, depth: 2, leaf buckets: 2, nodes: 1252 
    Average node length: 4.71, total dup: 1154, max dup: 148 
    Average key length: 2.83, compression ratio: 6.71 
    Average prefix length: 18.25, average data length: 0.75 
    Clustering factor: 679, ratio: 0.54 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 2 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
MON_CACHE_MEMORY (165) 
    Primary pointer page: 526, Index root page: 527 
    Total formats: 2, used formats: 1 
    Average record length: 97.10, total records: 73 
    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: 51% 
    Primary pages: 2, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 1 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 1 
 
    Index PK_MON_CACHE_MEMORY (0) 
    Root page: 1504215, depth: 1, leaf buckets: 1, nodes: 73 
    Average node length: 11.68, total dup: 0, max dup: 0 
    Average key length: 10.67, compression ratio: 0.84 
    Average prefix length: 1.32, average data length: 7.68 
    Clustering factor: 2, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
MON_LOG (162) 
    Primary pointer page: 520, Index root page: 521 
    Total formats: 2, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index MON_LOG_DTS (4) 
    Root page: 1504229, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index MON_LOG_GDSCODE (2) 
    Root page: 1504227, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index MON_LOG_ROWSET_DESC (1) 
    Root page: 1504226, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index MON_LOG_UNIT (3) 
    Root page: 1504228, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PK_MON_LOG (0) 
    Root page: 1504225, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
MON_LOG_TABLE_STATS (163) 
    Primary pointer page: 522, Index root page: 523 
    Total formats: 2, used formats: 1 
    Average record length: 67.13, total records: 30 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 611.00, compression ratio: 9.10 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 31% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 1 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index MON_LOG_TABLE_STATS_DTS (4) 
    Root page: 1504224, depth: 1, leaf buckets: 1, nodes: 30 
    Average node length: 3.50, total dup: 23, max dup: 4 
    Average key length: 2.47, compression ratio: 3.24 
    Average prefix length: 7.53, average data length: 0.47 
    Clustering factor: 1, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index MON_LOG_TABLE_STATS_GDSCODE (2) 
    Root page: 1504222, depth: 1, leaf buckets: 1, nodes: 30 
    Average node length: 2.00, total dup: 29, max dup: 29 
    Average key length: 1.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 1, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index MON_LOG_TABLE_STATS_ROWSET (1) 
    Root page: 1504221, depth: 1, leaf buckets: 1, nodes: 30 
    Average node length: 3.33, total dup: 29, max dup: 29 
    Average key length: 2.30, compression ratio: 3.91 
    Average prefix length: 8.70, average data length: 0.30 
    Clustering factor: 1, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index MON_LOG_TABLE_STATS_TN_UNIT (3) 
    Root page: 1504223, depth: 1, leaf buckets: 1, nodes: 30 
    Average node length: 12.90, total dup: 0, max dup: 0 
    Average key length: 11.87, compression ratio: 1.42 
    Average prefix length: 7.63, average data length: 9.20 
    Clustering factor: 1, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PK_MON_LOG_TABLE_STATS (0) 
    Root page: 1504220, depth: 1, leaf buckets: 1, nodes: 30 
    Average node length: 8.37, total dup: 0, max dup: 0 
    Average key length: 7.33, compression ratio: 1.23 
    Average prefix length: 4.63, average data length: 4.37 
    Clustering factor: 1, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
OPTYPES (136) 
    Primary pointer page: 468, Index root page: 469 
    Total formats: 2, used formats: 1 
    Average record length: 67.56, total records: 9 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 386.00, compression ratio: 5.71 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 9% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index OPTYPES_MCODE_UNQ (1) 
    Root page: 1544805, depth: 1, leaf buckets: 1, nodes: 9 
    Average node length: 8.56, total dup: 0, max dup: 0 
    Average key length: 6.89, compression ratio: 0.73 
    Average prefix length: 0.44, average data length: 4.56 
    Clustering factor: 1, ratio: 0.11 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PK_OPTYPES (0) 
    Root page: 1544804, depth: 1, leaf buckets: 1, nodes: 9 
    Average node length: 6.11, total dup: 0, max dup: 0 
    Average key length: 5.00, compression ratio: 0.60 
    Average prefix length: 0.89, average data length: 2.11 
    Clustering factor: 1, ratio: 0.11 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
PDISTR (146) 
    Primary pointer page: 488, Index root page: 489 
    Total formats: 1, used formats: 1 
    Average record length: 36.81, total records: 772730 
    Average version length: 25.74, total versions: 38034, max versions: 4 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 54.00, compression ratio: 1.47 
    Pointer pages: 6, data page slots: 8232 
    Data pages: 8232, average fill: 65% 
    Primary pages: 8191, secondary pages: 41, swept pages: 3387 
    Empty pages: 111, full pages: 4121 
    Fill distribution: 
     0 - 19% = 246 
    20 - 39% = 268 
    40 - 59% = 725 
    60 - 79% = 6883 
    80 - 99% = 110 
 
    Index PDISTR_AGENT_ID (2) 
    Root page: 1509308, depth: 2, leaf buckets: 901, nodes: 772730 
    Average node length: 4.87, total dup: 772681, max dup: 148194 
    Average key length: 2.01, compression ratio: 4.48 
    Average prefix length: 8.99, average data length: 0.01 
    Clustering factor: 86841, ratio: 0.11 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 183 
        40 - 59% = 527 
        60 - 79% = 146 
        80 - 99% = 44 
 
    Index PDISTR_SNDOP_RCVOP_SNDID_ASC (0) 
    Root page: 1508613, depth: 3, leaf buckets: 945, nodes: 772730 
    Average node length: 5.87, total dup: 688133, max dup: 42 
    Average key length: 3.02, compression ratio: 7.29 
    Average prefix length: 21.09, average data length: 0.91 
    Clustering factor: 153788, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 3 
        20 - 39% = 133 
        40 - 59% = 420 
        60 - 79% = 136 
        80 - 99% = 253 
 
    Index PDISTR_SNDOP_RCVOP_SNDID_DESC (1) 
    Root page: 1509187, depth: 3, leaf buckets: 993, nodes: 772730 
    Average node length: 5.87, total dup: 688133, max dup: 42 
    Average key length: 3.02, compression ratio: 7.29 
    Average prefix length: 21.09, average data length: 0.91 
    Clustering factor: 155665, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 246 
        40 - 59% = 376 
        60 - 79% = 123 
        80 - 99% = 248 
 
    Index PDISTR_WORKER_SND_ID (3) 
    Root page: 1510178, depth: 3, leaf buckets: 1097, nodes: 772730 
    Average node length: 5.95, total dup: 688133, max dup: 42 
    Average key length: 3.10, compression ratio: 5.49 
    Average prefix length: 16.01, average data length: 0.99 
    Clustering factor: 148979, ratio: 0.19 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 261 
        40 - 59% = 555 
        60 - 79% = 189 
        80 - 99% = 90 
 
PERF_AGG (158) 
    Primary pointer page: 512, Index root page: 513 
    Total formats: 1, used formats: 1 
    Average record length: 62.84, total records: 5481 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 2.68, total fragments: 85, max fragments: 1 
    Average unpacked length: 379.00, compression ratio: 6.03 
    Pointer pages: 1, data page slots: 96 
    Data pages: 96, average fill: 57% 
    Primary pages: 74, secondary pages: 22, swept pages: 61 
    Empty pages: 11, full pages: 64 
    Fill distribution: 
     0 - 19% = 25 
    20 - 39% = 0 
    40 - 59% = 1 
    60 - 79% = 69 
    80 - 99% = 1 
 
    Index PERF_AGG_UNQ (1) 
    Root page: 1504238, depth: 2, leaf buckets: 6, nodes: 5481 
    Average node length: 5.49, total dup: 0, max dup: 0 
    Average key length: 3.59, compression ratio: 10.04 
    Average prefix length: 34.46, average data length: 1.55 
    Clustering factor: 5198, ratio: 0.95 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 0 
        40 - 59% = 4 
        60 - 79% = 1 
        80 - 99% = 1 
 
    Index PK_PERF_AGG (0) 
    Root page: 1504233, depth: 2, leaf buckets: 10, nodes: 5481 
    Average node length: 11.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: 80762 
    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: 777 
    Fill distribution: 
     0 - 19% = 6 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 778 
    80 - 99% = 0 
 
    Index PK_PERF_ESTIMATED (0) 
    Root page: 36210, depth: 2, leaf buckets: 106, nodes: 80762 
    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: 3323, ratio: 0.04 
    Fill distribution: 
         0 - 19% = 3 
        20 - 39% = 0 
        40 - 59% = 2 
        60 - 79% = 0 
        80 - 99% = 101 
 
PERF_ISQL_STAT (156) 
    Primary pointer page: 508, Index root page: 509 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index PERF_ISQL_STAT_TRN (0) 
    Root page: 1504239, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
PERF_LOG (159) 
    Primary pointer page: 514, Index root page: 515 
    Total formats: 1, used formats: 1 
    Average record length: 111.22, 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.20 
    Pointer pages: 1, data page slots: 2 
    Data pages: 2, average fill: 57% 
    Primary pages: 2, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 1 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 1 
    40 - 59% = 0 
    60 - 79% = 1 
    80 - 99% = 0 
 
PERF_SPLIT_0 (281) 
    Primary pointer page: 573, Index root page: 574 
    Total formats: 1, used formats: 1 
    Average record length: 147.91, total records: 163249 
    Average version length: 152.11, total versions: 3256, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.47 
    Pointer pages: 9, data page slots: 4536 
    Data pages: 3968, average fill: 85% 
    Primary pages: 3968, secondary pages: 0, swept pages: 21 
    Empty pages: 91, full pages: 3855 
    Fill distribution: 
     0 - 19% = 93 
    20 - 39% = 6 
    40 - 59% = 8 
    60 - 79% = 7 
    80 - 99% = 3854 
 
PERF_SPLIT_1 (282) 
    Primary pointer page: 576, Index root page: 577 
    Total formats: 1, used formats: 1 
    Average record length: 130.51, total records: 194441 
    Average version length: 154.89, total versions: 26512, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 12.99 
    Pointer pages: 7, data page slots: 5584 
    Data pages: 4688, average fill: 87% 
    Primary pages: 4688, secondary pages: 0, swept pages: 2 
    Empty pages: 52, full pages: 4612 
    Fill distribution: 
     0 - 19% = 53 
    20 - 39% = 11 
    40 - 59% = 6 
    60 - 79% = 5 
    80 - 99% = 4613 
 
PERF_SPLIT_2 (283) 
    Primary pointer page: 578, Index root page: 579 
    Total formats: 1, used formats: 1 
    Average record length: 148.87, total records: 169447 
    Average version length: 150.66, total versions: 2367, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.39 
    Pointer pages: 7, data page slots: 4432 
    Data pages: 4080, average fill: 86% 
    Primary pages: 4080, secondary pages: 0, swept pages: 5 
    Empty pages: 55, full pages: 4006 
    Fill distribution: 
     0 - 19% = 56 
    20 - 39% = 12 
    40 - 59% = 4 
    60 - 79% = 2 
    80 - 99% = 4006 
 
PERF_SPLIT_3 (284) 
    Primary pointer page: 580, Index root page: 581 
    Total formats: 1, used formats: 1 
    Average record length: 147.81, total records: 177825 
    Average version length: 152.44, total versions: 3827, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.47 
    Pointer pages: 8, data page slots: 5760 
    Data pages: 4288, average fill: 86% 
    Primary pages: 4288, secondary pages: 0, swept pages: 12 
    Empty pages: 62, full pages: 4200 
    Fill distribution: 
     0 - 19% = 63 
    20 - 39% = 9 
    40 - 59% = 5 
    60 - 79% = 11 
    80 - 99% = 4200 
 
PERF_SPLIT_4 (285) 
    Primary pointer page: 582, Index root page: 583 
    Total formats: 1, used formats: 1 
    Average record length: 149.20, total records: 165305 
    Average version length: 151.07, total versions: 2167, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.37 
    Pointer pages: 7, data page slots: 4776 
    Data pages: 3960, average fill: 86% 
    Primary pages: 3960, secondary pages: 0, swept pages: 4 
    Empty pages: 31, full pages: 3913 
    Fill distribution: 
     0 - 19% = 33 
    20 - 39% = 6 
    40 - 59% = 3 
    60 - 79% = 6 
    80 - 99% = 3912 
 
PERF_SPLIT_5 (286) 
    Primary pointer page: 584, Index root page: 585 
    Total formats: 1, used formats: 1 
    Average record length: 145.49, total records: 161526 
    Average version length: 153.13, total versions: 5803, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.66 
    Pointer pages: 8, data page slots: 5080 
    Data pages: 3928, average fill: 85% 
    Primary pages: 3928, secondary pages: 0, swept pages: 25 
    Empty pages: 90, full pages: 3816 
    Fill distribution: 
     0 - 19% = 93 
    20 - 39% = 8 
    40 - 59% = 3 
    60 - 79% = 6 
    80 - 99% = 3818 
 
PERF_SPLIT_6 (287) 
    Primary pointer page: 586, Index root page: 587 
    Total formats: 1, used formats: 1 
    Average record length: 148.16, total records: 183485 
    Average version length: 152.48, total versions: 3721, 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: 8, data page slots: 5240 
    Data pages: 4408, average fill: 86% 
    Primary pages: 4408, secondary pages: 0, swept pages: 1 
    Empty pages: 48, full pages: 4344 
    Fill distribution: 
     0 - 19% = 48 
    20 - 39% = 7 
    40 - 59% = 5 
    60 - 79% = 4 
    80 - 99% = 4344 
 
PERF_SPLIT_7 (288) 
    Primary pointer page: 588, Index root page: 589 
    Total formats: 1, used formats: 1 
    Average record length: 149.24, total records: 169760 
    Average version length: 150.52, total versions: 1870, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.36 
    Pointer pages: 7, data page slots: 4736 
    Data pages: 4088, average fill: 85% 
    Primary pages: 4088, secondary pages: 0, swept pages: 20 
    Empty pages: 55, full pages: 4009 
    Fill distribution: 
     0 - 19% = 59 
    20 - 39% = 9 
    40 - 59% = 5 
    60 - 79% = 5 
    80 - 99% = 4010 
 
PERF_SPLIT_8 (289) 
    Primary pointer page: 590, Index root page: 591 
    Total formats: 1, used formats: 1 
    Average record length: 141.25, total records: 188248 
    Average version length: 154.34, total versions: 12447, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 12.01 
    Pointer pages: 7, data page slots: 4848 
    Data pages: 4536, average fill: 86% 
    Primary pages: 4535, secondary pages: 1, swept pages: 1 
    Empty pages: 52, full pages: 4463 
    Fill distribution: 
     0 - 19% = 55 
    20 - 39% = 9 
    40 - 59% = 6 
    60 - 79% = 3 
    80 - 99% = 4463 
 
PERF_SPLIT_9 (290) 
    Primary pointer page: 593, Index root page: 594 
    Total formats: 1, used formats: 1 
    Average record length: 146.55, total records: 153515 
    Average version length: 151.55, total versions: 3883, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.57 
    Pointer pages: 6, data page slots: 4792 
    Data pages: 3680, average fill: 86% 
    Primary pages: 3680, secondary pages: 0, swept pages: 29 
    Empty pages: 51, full pages: 3619 
    Fill distribution: 
     0 - 19% = 53 
    20 - 39% = 1 
    40 - 59% = 3 
    60 - 79% = 3 
    80 - 99% = 3620 
 
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: 52.46, total records: 2096067 
    Average version length: 52.95, total versions: 11163, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 70.00, compression ratio: 1.33 
    Pointer pages: 16, data page slots: 25584 
    Data pages: 25576, average fill: 70% 
    Primary pages: 25576, secondary pages: 0, swept pages: 12034 
    Empty pages: 252, full pages: 20055 
    Fill distribution: 
     0 - 19% = 553 
    20 - 39% = 509 
    40 - 59% = 1241 
    60 - 79% = 23207 
    80 - 99% = 66 
 
    Index PSTORNED_RCV_ID (1) 
    Root page: 1506186, depth: 3, leaf buckets: 2616, nodes: 2096067 
    Average node length: 5.44, total dup: 1955798, max dup: 1471 
    Average key length: 2.49, compression ratio: 3.62 
    Average prefix length: 8.58, average data length: 0.42 
    Clustering factor: 182174, ratio: 0.09 
    Fill distribution: 
         0 - 19% = 8 
        20 - 39% = 305 
        40 - 59% = 1751 
        60 - 79% = 279 
        80 - 99% = 273 
 
    Index PSTORNED_SND_ID (0) 
    Root page: 1504819, depth: 3, leaf buckets: 2761, nodes: 2096067 
    Average node length: 5.69, total dup: 1881040, max dup: 71 
    Average key length: 2.74, compression ratio: 3.29 
    Average prefix length: 8.36, average data length: 0.64 
    Clustering factor: 375203, ratio: 0.18 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 5 
        40 - 59% = 2431 
        60 - 79% = 297 
        80 - 99% = 26 
 
    Index PSTORNED_WORKER_ID (2) 
    Root page: 1507996, depth: 3, leaf buckets: 2217, nodes: 2096067 
    Average node length: 4.96, total dup: 2095967, max dup: 28027 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.41, average data length: 0.00 
    Clustering factor: 179752, ratio: 0.09 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 239 
        40 - 59% = 1260 
        60 - 79% = 379 
        80 - 99% = 338 
 
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: 51.15, total records: 120079 
    Average version length: 69.19, total versions: 31354, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 2.46 
    Pointer pages: 3, data page slots: 4368 
    Data pages: 3216, average fill: 43% 
    Primary pages: 3216, secondary pages: 0, swept pages: 898 
    Empty pages: 606, full pages: 625 
    Fill distribution: 
     0 - 19% = 921 
    20 - 39% = 445 
    40 - 59% = 663 
    60 - 79% = 853 
    80 - 99% = 334 
 
    Index XQD_1000_1200_WA_SO_RO_WKR_SND (0) 
    Root page: 369418, depth: 3, leaf buckets: 229, nodes: 120079 
    Average node length: 6.46, total dup: 104430, max dup: 14 
    Average key length: 3.99, compression ratio: 10.54 
    Average prefix length: 40.14, average data length: 1.86 
    Clustering factor: 20792, ratio: 0.17 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 109 
        40 - 59% = 94 
        60 - 79% = 25 
        80 - 99% = 0 
 
XQD_1000_3300 (178) 
    Primary pointer page: 553, Index root page: 554 
    Total formats: 1, used formats: 1 
    Average record length: 66.58, total records: 6832543 
    Average version length: 68.79, total versions: 237666, 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: 63, data page slots: 102424 
    Data pages: 102424, average fill: 71% 
    Primary pages: 102424, secondary pages: 0, swept pages: 48997 
    Empty pages: 7, full pages: 56519 
    Fill distribution: 
     0 - 19% = 71 
    20 - 39% = 759 
    40 - 59% = 9804 
    60 - 79% = 89806 
    80 - 99% = 1984 
 
    Index XQD_1000_3300_WA_SO_RO_WKR_SND (0) 
    Root page: 1480454, depth: 3, leaf buckets: 10726, nodes: 6832543 
    Average node length: 6.52, total dup: 5908419, max dup: 29 
    Average key length: 3.53, compression ratio: 11.91 
    Average prefix length: 40.61, average data length: 1.39 
    Clustering factor: 1526984, ratio: 0.22 
    Fill distribution: 
         0 - 19% = 10 
        20 - 39% = 1945 
        40 - 59% = 6110 
        60 - 79% = 2300 
        80 - 99% = 361 
 
    Index XQD_1000_3300_WKR_DOC_ASC (1) 
    Root page: 1486068, depth: 3, leaf buckets: 8345, nodes: 6832543 
    Average node length: 5.40, total dup: 6555104, max dup: 171 
    Average key length: 2.41, compression ratio: 7.04 
    Average prefix length: 16.63, average data length: 0.37 
    Clustering factor: 1330394, ratio: 0.19 
    Fill distribution: 
         0 - 19% = 8 
        20 - 39% = 1291 
        40 - 59% = 4570 
        60 - 79% = 1518 
        80 - 99% = 958 
 
    Index XQD_1000_3300_WKR_DOC_DEC (2) 
    Root page: 1490608, depth: 3, leaf buckets: 8411, nodes: 6832543 
    Average node length: 5.40, total dup: 6555104, max dup: 171 
    Average key length: 2.41, compression ratio: 7.04 
    Average prefix length: 16.63, average data length: 0.37 
    Clustering factor: 1332893, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 1349 
        40 - 59% = 4609 
        60 - 79% = 1526 
        80 - 99% = 925 
 
XQD_1200_2000 (177) 
    Primary pointer page: 551, Index root page: 552 
    Total formats: 1, used formats: 1 
    Average record length: 68.00, total records: 11828761 
    Average version length: 68.74, total versions: 165029, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.85 
    Pointer pages: 104, data page slots: 168656 
    Data pages: 168656, average fill: 74% 
    Primary pages: 168656, secondary pages: 0, swept pages: 110082 
    Empty pages: 6, full pages: 131353 
    Fill distribution: 
     0 - 19% = 58 
    20 - 39% = 675 
    40 - 59% = 6977 
    60 - 79% = 158910 
    80 - 99% = 2036 
 
    Index XQD_1200_2000_WA_SO_RO_WKR_SND (0) 
    Root page: 1495028, depth: 3, leaf buckets: 18368, nodes: 11828761 
    Average node length: 6.58, total dup: 10310629, max dup: 71 
    Average key length: 3.43, compression ratio: 12.25 
    Average prefix length: 40.70, average data length: 1.30 
    Clustering factor: 2332233, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 43 
        20 - 39% = 2661 
        40 - 59% = 10877 
        60 - 79% = 4071 
        80 - 99% = 716 
 
XQD_2000_3300 (179) 
    Primary pointer page: 555, Index root page: 556 
    Total formats: 1, used formats: 1 
    Average record length: 57.64, total records: 1189939 
    Average version length: 69.12, total versions: 198356, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 2.19 
    Pointer pages: 30, data page slots: 46208 
    Data pages: 26840, average fill: 49% 
    Primary pages: 26840, secondary pages: 0, swept pages: 14659 
    Empty pages: 4742, full pages: 11165 
    Fill distribution: 
     0 - 19% = 7320 
    20 - 39% = 3045 
    40 - 59% = 2915 
    60 - 79% = 10778 
    80 - 99% = 2782 
 
    Index XQD_2000_3300_WA_SO_RO_WKR_SND (0) 
    Root page: 1479712, depth: 3, leaf buckets: 2023, nodes: 1189939 
    Average node length: 5.54, total dup: 1141785, max dup: 49 
    Average key length: 2.58, compression ratio: 16.27 
    Average prefix length: 41.46, average data length: 0.54 
    Clustering factor: 79397, ratio: 0.07 
    Fill distribution: 
         0 - 19% = 9 
        20 - 39% = 1074 
        40 - 59% = 780 
        60 - 79% = 147 
        80 - 99% = 13 
 
XQD_2100_3300 (180) 
    Primary pointer page: 557, Index root page: 558 
    Total formats: 1, used formats: 1 
    Average record length: 50.41, total records: 842383 
    Average version length: 69.15, total versions: 226965, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 2.50 
    Pointer pages: 23, data page slots: 36952 
    Data pages: 30400, average fill: 32% 
    Primary pages: 30399, secondary pages: 1, swept pages: 13086 
    Empty pages: 7960, full pages: 4016 
    Fill distribution: 
     0 - 19% = 13269 
    20 - 39% = 5317 
    40 - 59% = 5063 
    60 - 79% = 4449 
    80 - 99% = 2302 
 
    Index XQD_2100_3300_WA_SO_RO_WKR_SND (0) 
    Root page: 1479207, depth: 3, leaf buckets: 1495, nodes: 842383 
    Average node length: 5.85, total dup: 783611, max dup: 99 
    Average key length: 2.92, compression ratio: 14.40 
    Average prefix length: 41.15, average data length: 0.85 
    Clustering factor: 113191, ratio: 0.13 
    Fill distribution: 
         0 - 19% = 4 
        20 - 39% = 784 
        40 - 59% = 578 
        60 - 79% = 122 
        80 - 99% = 7 
 
XQD_3300_3400 (181) 
    Primary pointer page: 559, Index root page: 560 
    Total formats: 1, used formats: 1 
    Average record length: 67.58, total records: 9047829 
    Average version length: 68.93, total versions: 172169, 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: 90, data page slots: 145744 
    Data pages: 145696, average fill: 66% 
    Primary pages: 145696, secondary pages: 0, swept pages: 88131 
    Empty pages: 434, full pages: 65649 
    Fill distribution: 
     0 - 19% = 1375 
    20 - 39% = 7879 
    40 - 59% = 28895 
    60 - 79% = 105948 
    80 - 99% = 1599 
 
    Index XQD_3300_3400_WA_SO_RO_WKR_SND (0) 
    Root page: 1472590, depth: 3, leaf buckets: 13509, nodes: 9047829 
    Average node length: 6.70, total dup: 7503179, max dup: 14 
    Average key length: 3.67, compression ratio: 11.44 
    Average prefix length: 40.50, average data length: 1.50 
    Clustering factor: 1934016, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 5 
        20 - 39% = 1445 
        40 - 59% = 7074 
        60 - 79% = 4445 
        80 - 99% = 540 
 
XQS_1000_1200 (182) 
    Primary pointer page: 561, Index root page: 562 
    Total formats: 1, used formats: 1 
    Average record length: 82.52, total records: 21146982 
    Average version length: 83.07, total versions: 3724, 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: 318896 
    Data pages: 318896, average fill: 81% 
    Primary pages: 318896, secondary pages: 0, swept pages: 13782 
    Empty pages: 54, full pages: 317555 
    Fill distribution: 
     0 - 19% = 86 
    20 - 39% = 76 
    40 - 59% = 180 
    60 - 79% = 28206 
    80 - 99% = 290348 
 
    Index XQS_1000_1200_DOC_ID (1) 
    Root page: 1426716, depth: 3, leaf buckets: 19486, nodes: 21146982 
    Average node length: 5.72, total dup: 20665936, max dup: 137 
    Average key length: 2.16, compression ratio: 4.16 
    Average prefix length: 8.86, average data length: 0.14 
    Clustering factor: 3280511, ratio: 0.16 
    Fill distribution: 
         0 - 19% = 5 
        20 - 39% = 2 
        40 - 59% = 8341 
        60 - 79% = 546 
        80 - 99% = 10592 
 
    Index XQS_1000_1200_RCV_ID (3) 
    Root page: 1456980, depth: 3, leaf buckets: 17196, nodes: 21146982 
    Average node length: 6.31, total dup: 18583341, max dup: 49 
    Average key length: 2.75, compression ratio: 3.27 
    Average prefix length: 8.37, average data length: 0.63 
    Clustering factor: 915365, ratio: 0.04 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 7 
        40 - 59% = 816 
        60 - 79% = 280 
        80 - 99% = 16091 
 
    Index XQS_1000_1200_SND_ID (2) 
    Root page: 1441073, depth: 3, leaf buckets: 21284, nodes: 21146982 
    Average node length: 6.35, total dup: 18502693, max dup: 27 
    Average key length: 2.79, compression ratio: 3.23 
    Average prefix length: 8.34, average data length: 0.66 
    Clustering factor: 3575228, ratio: 0.17 
    Fill distribution: 
         0 - 19% = 4 
        20 - 39% = 1 
        40 - 59% = 8638 
        60 - 79% = 623 
        80 - 99% = 12018 
 
    Index XQS_1000_1200_WORKER_ID (0) 
    Root page: 1413348, depth: 3, leaf buckets: 16084, nodes: 21146982 
    Average node length: 5.56, total dup: 21146882, max dup: 230001 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.42, average data length: 0.00 
    Clustering factor: 944224, ratio: 0.04 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 10 
        40 - 59% = 2844 
        60 - 79% = 404 
        80 - 99% = 12826 
 
XQS_1000_3300 (184) 
    Primary pointer page: 565, Index root page: 566 
    Total formats: 1, used formats: 1 
    Average record length: 81.11, total records: 9482850 
    Average version length: 82.57, total versions: 150016, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.55 
    Pointer pages: 107, data page slots: 174272 
    Data pages: 174216, average fill: 67% 
    Primary pages: 174216, secondary pages: 0, swept pages: 110674 
    Empty pages: 1194, full pages: 83830 
    Fill distribution: 
     0 - 19% = 2843 
    20 - 39% = 10272 
    40 - 59% = 34474 
    60 - 79% = 78912 
    80 - 99% = 47715 
 
    Index XQS_1000_3300_DOC_ID (1) 
    Root page: 1367502, depth: 3, leaf buckets: 11401, nodes: 9482850 
    Average node length: 5.39, total dup: 9175095, max dup: 151 
    Average key length: 2.24, compression ratio: 4.02 
    Average prefix length: 8.80, average data length: 0.20 
    Clustering factor: 2067488, ratio: 0.22 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 132 
        40 - 59% = 8692 
        60 - 79% = 2544 
        80 - 99% = 32 
 
    Index XQS_1000_3300_RCV_ID (3) 
    Root page: 1379261, depth: 3, leaf buckets: 13530, nodes: 9482850 
    Average node length: 6.26, total dup: 7858736, max dup: 14 
    Average key length: 3.10, compression ratio: 2.90 
    Average prefix length: 8.07, average data length: 0.93 
    Clustering factor: 1418538, ratio: 0.15 
    Fill distribution: 
         0 - 19% = 163 
        20 - 39% = 4250 
        40 - 59% = 4221 
        60 - 79% = 2593 
        80 - 99% = 2303 
 
    Index XQS_1000_3300_SND_ID (2) 
    Root page: 1373059, depth: 3, leaf buckets: 12734, nodes: 9482850 
    Average node length: 6.01, total dup: 8220205, max dup: 36 
    Average key length: 2.86, compression ratio: 3.15 
    Average prefix length: 8.28, average data length: 0.72 
    Clustering factor: 2250721, ratio: 0.24 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 177 
        40 - 59% = 9733 
        60 - 79% = 2767 
        80 - 99% = 56 
 
    Index XQS_1000_3300_WORKER_ID (0) 
    Root page: 1362767, depth: 3, leaf buckets: 10098, nodes: 9482850 
    Average node length: 5.16, total dup: 9482750, max dup: 160769 
    Average key length: 2.00, compression ratio: 1.20 
    Average prefix length: 2.41, average data length: 0.00 
    Clustering factor: 1468882, ratio: 0.15 
    Fill distribution: 
         0 - 19% = 42 
        20 - 39% = 1396 
        40 - 59% = 5033 
        60 - 79% = 1658 
        80 - 99% = 1969 
 
XQS_1200_2000 (183) 
    Primary pointer page: 563, Index root page: 564 
    Total formats: 1, used formats: 1 
    Average record length: 81.65, total records: 11143599 
    Average version length: 82.50, total versions: 88235, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.54 
    Pointer pages: 120, data page slots: 194792 
    Data pages: 192960, average fill: 71% 
    Primary pages: 192960, secondary pages: 0, swept pages: 86077 
    Empty pages: 4007, full pages: 135394 
    Fill distribution: 
     0 - 19% = 6902 
    20 - 39% = 9894 
    40 - 59% = 21517 
    60 - 79% = 44823 
    80 - 99% = 109824 
 
    Index XQS_1200_2000_DOC_ID (1) 
    Root page: 1392101, depth: 3, leaf buckets: 13130, nodes: 11143599 
    Average node length: 5.31, total dup: 11033887, max dup: 631 
    Average key length: 2.08, compression ratio: 4.32 
    Average prefix length: 8.93, average data length: 0.07 
    Clustering factor: 2324546, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 182 
        40 - 59% = 9593 
        60 - 79% = 3230 
        80 - 99% = 125 
 
    Index XQS_1200_2000_RCV_ID (3) 
    Root page: 1406110, depth: 3, leaf buckets: 10392, nodes: 11143599 
    Average node length: 5.50, total dup: 10656622, max dup: 49 
    Average key length: 2.28, compression ratio: 3.95 
    Average prefix length: 8.77, average data length: 0.23 
    Clustering factor: 703951, ratio: 0.06 
    Fill distribution: 
         0 - 19% = 174 
        20 - 39% = 911 
        40 - 59% = 2555 
        60 - 79% = 1833 
        80 - 99% = 4919 
 
    Index XQS_1200_2000_SND_ID (2) 
    Root page: 1398638, depth: 3, leaf buckets: 15027, nodes: 11143599 
    Average node length: 6.03, total dup: 9716057, max dup: 54 
    Average key length: 2.81, compression ratio: 3.20 
    Average prefix length: 8.32, average data length: 0.68 
    Clustering factor: 2340952, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 4 
        20 - 39% = 218 
        40 - 59% = 11144 
        60 - 79% = 3519 
        80 - 99% = 142 
 
    Index XQS_1200_2000_WORKER_ID (0) 
    Root page: 1386211, depth: 3, leaf buckets: 10637, nodes: 11143599 
    Average node length: 5.23, total dup: 11143499, max dup: 200724 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.41, average data length: 0.00 
    Clustering factor: 693336, ratio: 0.06 
    Fill distribution: 
         0 - 19% = 96 
        20 - 39% = 872 
        40 - 59% = 4675 
        60 - 79% = 1482 
        80 - 99% = 3512 
 
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: 81.33, total records: 9611299 
    Average version length: 82.86, total versions: 162936, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.55 
    Pointer pages: 109, data page slots: 176880 
    Data pages: 176760, average fill: 67% 
    Primary pages: 176760, secondary pages: 0, swept pages: 112648 
    Empty pages: 1051, full pages: 84512 
    Fill distribution: 
     0 - 19% = 2729 
    20 - 39% = 10095 
    40 - 59% = 34840 
    60 - 79% = 81670 
    80 - 99% = 47426 
 
    Index XQS_2100_3300_DOC_ID (1) 
    Root page: 1344686, depth: 3, leaf buckets: 11825, nodes: 9611299 
    Average node length: 5.20, total dup: 9582346, max dup: 1591 
    Average key length: 2.03, compression ratio: 4.43 
    Average prefix length: 8.97, average data length: 0.03 
    Clustering factor: 1885966, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 35 
        20 - 39% = 1596 
        40 - 59% = 7868 
        60 - 79% = 1837 
        80 - 99% = 489 
 
    Index XQS_2100_3300_RCV_ID (3) 
    Root page: 1355717, depth: 3, leaf buckets: 13662, nodes: 9611299 
    Average node length: 6.27, total dup: 7964367, max dup: 14 
    Average key length: 3.11, compression ratio: 2.90 
    Average prefix length: 8.07, average data length: 0.93 
    Clustering factor: 1393039, ratio: 0.14 
    Fill distribution: 
         0 - 19% = 172 
        20 - 39% = 4254 
        40 - 59% = 4216 
        60 - 79% = 2605 
        80 - 99% = 2415 
 
    Index XQS_2100_3300_SND_ID (2) 
    Root page: 1350049, depth: 3, leaf buckets: 12442, nodes: 9611299 
    Average node length: 5.45, total dup: 9176317, max dup: 99 
    Average key length: 2.29, compression ratio: 3.93 
    Average prefix length: 8.75, average data length: 0.25 
    Clustering factor: 2016278, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 25 
        20 - 39% = 1559 
        40 - 59% = 8732 
        60 - 79% = 1609 
        80 - 99% = 517 
 
    Index XQS_2100_3300_WORKER_ID (0) 
    Root page: 985805, depth: 3, leaf buckets: 10298, nodes: 9611299 
    Average node length: 5.17, total dup: 9611199, max dup: 163248 
    Average key length: 2.00, compression ratio: 1.20 
    Average prefix length: 2.41, average data length: 0.00 
    Clustering factor: 1499435, ratio: 0.16 
    Fill distribution: 
         0 - 19% = 50 
        20 - 39% = 1437 
        40 - 59% = 5208 
        60 - 79% = 1640 
        80 - 99% = 1963 
 
XQS_3300_3400 (187) 
    Primary pointer page: 571, Index root page: 572 
    Total formats: 1, used formats: 1 
    Average record length: 67.82, total records: 575660 
    Average version length: 68.71, total versions: 2957, 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: 8064 
    Data pages: 8064, average fill: 75% 
    Primary pages: 8064, secondary pages: 0, swept pages: 4191 
    Empty pages: 8, full pages: 6470 
    Fill distribution: 
     0 - 19% = 9 
    20 - 39% = 36 
    40 - 59% = 294 
    60 - 79% = 7679 
    80 - 99% = 46 
 
    Index XQS_3300_3400_DOC_ID (1) 
    Root page: 41447, depth: 3, leaf buckets: 750, nodes: 575660 
    Average node length: 5.95, total dup: 490123, max dup: 82 
    Average key length: 3.09, compression ratio: 2.91 
    Average prefix length: 8.06, average data length: 0.94 
    Clustering factor: 99937, ratio: 0.17 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 28 
        40 - 59% = 548 
        60 - 79% = 100 
        80 - 99% = 74 
 
    Index XQS_3300_3400_SND_ID (2) 
    Root page: 30178, depth: 3, leaf buckets: 776, nodes: 575660 
    Average node length: 6.15, total dup: 472069, max dup: 14 
    Average key length: 3.29, compression ratio: 2.73 
    Average prefix length: 7.89, average data length: 1.11 
    Clustering factor: 99979, ratio: 0.17 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 30 
        40 - 59% = 580 
        60 - 79% = 87 
        80 - 99% = 78 
 
    Index XQS_3300_3400_WORKER_ID (0) 
    Root page: 375548, depth: 2, leaf buckets: 595, nodes: 575660 
    Average node length: 4.86, total dup: 575560, max dup: 9403 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.42, average data length: 0.00 
    Clustering factor: 88725, ratio: 0.15 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 42 
        40 - 59% = 376 
        60 - 79% = 80 
        80 - 99% = 96 
 
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 Wed Mar  6 01:13:33 2024

Record versions statistics, table

TABLE_NAME TOTAL_RECS TOTAL_VERS MAX_VERSIONS VERS_TO_RECS_PRC MAXV_TO_VERS_PRC
DOC_DATA 7737071 38974 1 0.0000 0.0000
DOC_LIST 2242283 38989 3 0.0000 0.0000
FB_ERRORS 2182 757 1 0.0000 0.0000
INVNT_SALDO 400 238267 618 59500.0000 0.0000
INVNT_TURNOVER_LOG 81347 66397 1 0.0000 0.0000
MONEY_SALDO 49 18852 1025 38400.0000 0.0000
MONEY_TURNOVER_LOG 1252 1001 1 0.0000 0.0000
PDISTR 772730 38034 4 0.0000 0.0000
PERF_SPLIT_0 163249 3256 1 0.0000 0.0000
PERF_SPLIT_1 194441 26512 1 0.0000 0.0000
PERF_SPLIT_2 169447 2367 1 0.0000 0.0000
PERF_SPLIT_3 177825 3827 1 0.0000 0.0000
PERF_SPLIT_4 165305 2167 1 0.0000 0.0000
PERF_SPLIT_5 161526 5803 1 0.0000 0.0000
PERF_SPLIT_6 183485 3721 1 0.0000 0.0000
PERF_SPLIT_7 169760 1870 1 0.0000 0.0000
PERF_SPLIT_8 188248 12447 1 0.0000 0.0000
PERF_SPLIT_9 153515 3883 1 0.0000 0.0000
PSTORNED 2096067 11163 1 0.0000 0.0000
SEMAPHORES 5 1 1 0.0000 100.0000
XQD_1000_1200 120079 31354 1 0.0000 0.0000
XQD_1000_3300 6832543 237666 1 0.0000 0.0000
XQD_1200_2000 11828761 165029 1 0.0000 0.0000
XQD_2000_3300 1189939 198356 1 0.0000 0.0000
XQD_2100_3300 842383 226965 1 0.0000 0.0000
XQD_3300_3400 9047829 172169 1 0.0000 0.0000
XQS_1000_1200 21146982 3724 1 0.0000 0.0000
XQS_1000_3300 9482850 150016 1 0.0000 0.0000
XQS_1200_2000 11143599 88235 1 0.0000 0.0000
XQS_2100_3300 9611299 162936 1 0.0000 0.0000
XQS_3300_3400 575660 2957 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 ---
:257: 
:258: mscs-test-161.budzdorov.ru    Wed Mar  6 01:10:46 2024
:259:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:260: 
:261: 
:262: mscs-test-161.budzdorov.ru    Wed Mar  6 01:10:50 2024
:263:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:264: 
--- end of diff output ---

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

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