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

Hardware and OS info

Command: hostnamectl
Static hostname mscs-test-161.budzdorov.ru
Icon name computer-server
Chassis server
Machine ID aeee285d2cca40bf84c40a748f599e77
Boot ID 2a7b53d1c5ed44b9bb2712fffac5d8c6
Operating System CentOS Linux 7 (Core)
CPE OS Name cpe:/o:centos:centos:7
Kernel Linux 3.10.0-1127.10.1.el7.x86_64
Architecture x86-64
Command: who -b
bootup_info system boot 2021-11-11 18:28
Command: dmidecode -t system|grep -i -e 'manufacturer\|product\|hypervisor'
Manufacturer HP
Product Name ProLiant DL380 Gen9
Command: dmesg | grep DMI
[ 0.000000] DMI HP ProLiant DL380 Gen9/ProLiant DL380 Gen9, BIOS P89 05/21/2018
Command: lscpu | grep -i -v flags
Architecture x86_64
CPU op-mode(s) 32-bit, 64-bit
Byte Order Little Endian
CPU(s) 24
On-line CPU(s) list 0-23
Thread(s) per core 2
Core(s) per socket 6
Socket(s) 2
NUMA node(s) 2
Vendor ID GenuineIntel
CPU family 6
Model 63
Model name Intel(R) Xeon(R) CPU E5-2620 v3 @ 2.40GHz
Stepping 2
CPU MHz 1200.000
CPU max MHz 2400.0000
CPU min MHz 1200.0000
BogoMIPS 4794.33
Virtualization VT-x
L1d cache 32K
L1i cache 32K
L2 cache 256K
L3 cache 15360K
NUMA node0 CPU(s) 0-5,12-17
NUMA node1 CPU(s) 6-11,18-23
Command: cat /proc/meminfo | grep -i -e 'memtotal\|memfree\|memavail\|buffers\|cached\|swapcached'
MemTotal 32643792 kB
MemFree 15830416 kB
MemAvailable 30288028 kB
Buffers 0 kB
Cached 15901288 kB
SwapCached 2620 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-22 22:09:41
DTS_END                         2024-03-22 22:09:41.2370
FB_GDSCODE                      -1
FB_MNEMONA                      
STACK                           SP_CANCEL_SUPPLIER_ORDER(131:22) ==> SP_CANCEL_ADDING_INVOICE(33:5) ==> SP_ADD_INVOICE_TO_STOCK(69:14) ==> SP_CHECK_TO_STOP_WORK(32:12) ==> SP_HALT_ON_ERROR(57:17)
IP                              ::1/59180
TRN_ID                          178743
ATT_ID                          577
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: 9226.99 24856 922699
customer order: creation 177.29 362 17729
customer order: refuse 16.05 369 1605
order to supplier: creation 46.87 1309 4687
order to supplier: removal 3.35 109204 335
invoice (draft): creation 46.87 3345 4687
invoice (draft): removal 50.74 848 5074
invoice accept: apply 42.50 20475 4250
invoice accept: cancel 46.10 957 4610
customer reserve: creation 4000.54 201 400054
customer reserve: removal 4486.77 65 448677
realization accept: apply 86.73 189 8673
realization accept: cancel 89.83 128 8983
payment from customer: creation 60.29 106 6029
payment from customer: removal 5.38 99 538
payment to supplier: creation 51.42 138 5142
payment to supplier: removal 3.63 96 363
service: total inventory turnovers 4.73 1125 473
service: total monetary turnovers 7.05 30 705
service: aggregate perf. data 0.82 22733 82
service: refresh index statistics 0.03 335331 3

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:02, from 22-03-2024 22:10:51 to 22-03-2024 22:10:53.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 4720
TEST_TIME 2 3601
TEST_TIME 3 4137
TEST_TIME 4 4430
TEST_TIME 5 4670
TEST_TIME 6 4820
TEST_TIME 7 4877
TEST_TIME 8 5016
TEST_TIME 9 4954
TEST_TIME 10 4953
TEST_TIME 11 5059
TEST_TIME 12 5063
TEST_TIME 13 5168
TEST_TIME 14 5494
TEST_TIME 15 6011
TEST_TIME 16 6217
TEST_TIME 17 6897
TEST_TIME 18 6934
TEST_TIME 19 7009
TEST_TIME 20 7241
TEST_TIME 21 8086
TEST_TIME 22 8032
TEST_TIME 23 8212
TEST_TIME 24 8111
TEST_TIME 25 8397
TEST_TIME 26 8591
TEST_TIME 27 9702
TEST_TIME 28 9665
TEST_TIME 29 9833
TEST_TIME 30 9665
TEST_TIME 31 9779
TEST_TIME 32 9722
TEST_TIME 33 9493
TEST_TIME 34 9293
TEST_TIME 35 9168
TEST_TIME 36 9422
TEST_TIME 37 9361
TEST_TIME 38 9349
TEST_TIME 39 9187
TEST_TIME 40 9115
TEST_TIME 41 9044
TEST_TIME 42 9007
TEST_TIME 43 9110
TEST_TIME 44 9112
TEST_TIME 45 8936
TEST_TIME 46 8931
TEST_TIME 47 8881
TEST_TIME 48 9072
TEST_TIME 49 9064
TEST_TIME 50 9013
TEST_TIME 51 9162
TEST_TIME 52 9150
TEST_TIME 53 9208
TEST_TIME 54 9223
TEST_TIME 55 9200
TEST_TIME 56 9207
TEST_TIME 57 9302
TEST_TIME 58 9209
TEST_TIME 59 9276
TEST_TIME 60 9402
TEST_TIME 61 9277
TEST_TIME 62 9269
TEST_TIME 63 9229
TEST_TIME 64 9203
TEST_TIME 65 9290
TEST_TIME 66 9283
TEST_TIME 67 9217
TEST_TIME 68 9208
TEST_TIME 69 9117
TEST_TIME 70 9108
TEST_TIME 71 9019
TEST_TIME 72 9071
TEST_TIME 73 9196
TEST_TIME 74 9190
TEST_TIME 75 9196
TEST_TIME 76 9368
TEST_TIME 77 9370
TEST_TIME 78 9328
TEST_TIME 79 9350
TEST_TIME 80 9431
TEST_TIME 81 9439
TEST_TIME 82 9477
TEST_TIME 83 9459
TEST_TIME 84 9448
TEST_TIME 85 9403
TEST_TIME 86 9310
TEST_TIME 87 9352
TEST_TIME 88 9366
TEST_TIME 89 9387
TEST_TIME 90 9326
TEST_TIME 91 9269
TEST_TIME 92 9273
TEST_TIME 93 9230
TEST_TIME 94 9209
TEST_TIME 95 9218
TEST_TIME 96 9226
TEST_TIME 97 9217
TEST_TIME 98 9258
TEST_TIME 99 9260
TEST_TIME 100 9228

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:03, from 22-03-2024 22:10:54 to 22-03-2024 22:10:57.

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 1289245 1289245 0 0.00 0 41002 7 0 0
doc_list_biud 1289240 1289240 0 0.00 0 64114 29 0 0
sp_add_invoice_to_stock 4357 4250 107 2.45 19 212576 20476 0 107
sp_cancel_adding_invoice 4610 4610 0 0.00 4 93422 957 0 0
sp_cancel_client_order 1605 1605 0 0.00 4 20337 370 0 0
sp_cancel_customer_reserve 448677 448677 0 0.00 0 64116 65 0 0
sp_cancel_pay_from_customer 538 538 0 0.00 3 12408 99 0 0
sp_cancel_pay_to_supplier 363 363 0 0.00 3 12131 97 0 0
sp_cancel_supplier_invoice 5088 5074 14 0.27 2 13596 848 0 14
sp_cancel_supplier_order 335 335 0 0.00 6 1072594 109204 0 0
sp_cancel_write_off 8983 8983 0 0.00 1 18283 129 0 0
sp_client_order 17729 17729 0 0.00 3 43734 362 0 0
sp_customer_reserve 400054 400054 0 0.00 0 68977 202 0 0
sp_fill_shopping_cart 27098 27098 0 0.00 1 13241 36 0 0
sp_fill_shopping_cart_clo_res 400048 400048 0 0.00 0 33929 15 0 0
sp_get_clo_for_invoice 4244 4244 0 0.00 0 39757 250 0 0
sp_kill_cost_storno 14494 14494 0 0.00 0 40999 69 0 0
sp_kill_qstorno_ret_qs2qd 911746 911746 0 0.00 0 64111 35 0 0
sp_kill_qty_storno 482200 482200 0 0.00 0 64113 76 0 0
sp_lock_selected_doc 17975 17975 0 0.00 0 8399 6 0 0
sp_make_cost_storno 24088 24088 0 0.00 0 24092 64 0 0
sp_multiply_rows_for_pdistr 24087 24087 0 0.00 0 9326 27 0 0
sp_multiply_rows_for_qdistr 17729 17729 0 0.00 0 17728 155 0 0
sp_pay_from_customer 6029 6029 0 0.00 4 26509 106 0 0
sp_pay_to_supplier 5142 5142 0 0.00 4 17143 138 0 0
sp_payment_common 11171 11171 0 0.00 2 26500 24 0 0
sp_qd_handle_on_cancel_clo 1605 1605 0 0.00 0 20304 339 0 0
sp_qd_handle_on_invoice_upd_sts 8854 8854 0 0.00 0 18147 322 0 0
sp_qd_handle_on_reserve_upd_sts 8672 8672 0 0.00 0 18011 67 0 0
sp_reserve_write_off 8673 8673 0 0.00 6 37283 190 0 0
sp_supplier_invoice 4687 4687 0 0.00 6 94915 3345 0 0
sp_supplier_order 4687 4687 0 0.00 5 48423 1310 0 0
srv_aggregate_perf_data 82 82 0 0.00 1664 228647 22733 0 0
srv_fill_mon_cache_memory 55 55 0 0.00 1700 151728 41983 0 0
srv_find_qd_qs_mism 879691 879691 0 0.00 0 31284 6 0 0
srv_make_invnt_saldo 473 473 0 0.00 33 45915 1125 0 0
srv_make_money_saldo 705 705 0 0.00 1 2362 31 0 0
srv_recalc_idx_stat 3 3 0 0.00 312061 358852 335331 0 0
t$perf-abend:sp_add_invoice_to_stock 107 107 0 0.00 0 0 0 0 0
t$perf-abend:sp_cancel_supplier_invoice 14 14 0 0.00 0 0 0 0 0
t$perf-norm:sp_add_invoice_to_stock 4250 4250 0 0.00 0 11062 191 0 0
t$perf-norm:sp_cancel_adding_invoice 367 367 0 0.00 0 4558 115 0 0
t$perf-norm:sp_cancel_client_order 1605 1605 0 0.00 0 6390 18 0 0
t$perf-norm:sp_cancel_customer_reserve 600 600 0 0.00 0 2715 15 0 0
t$perf-norm:sp_cancel_pay_from_customer 538 538 0 0.00 0 2328 10 0 0
t$perf-norm:sp_cancel_pay_to_supplier 363 363 0 0.00 0 854 4 0 0
t$perf-norm:sp_cancel_supplier_invoice 354 354 0 0.00 0 1650 23 0 0
t$perf-norm:sp_cancel_supplier_order 335 335 0 0.00 0 34716 1906 0 0
t$perf-norm:sp_cancel_write_off 897 897 0 0.00 0 3339 11 0 0
t$perf-norm:sp_client_order 17729 17729 0 0.00 0 6531 18 0 0
t$perf-norm:sp_customer_reserve 900 900 0 0.00 0 3548 10 0 0
t$perf-norm:sp_pay_from_customer 6029 6029 0 0.00 0 8963 11 0 0
t$perf-norm:sp_pay_to_supplier 5142 5142 0 0.00 0 9916 11 0 0
t$perf-norm:sp_reserve_write_off 8673 8673 0 0.00 0 5774 10 0 0
t$perf-norm:sp_supplier_invoice 4687 4687 0 0.00 0 4444 15 0 0
t$perf-norm:sp_supplier_order 4687 4687 0 0.00 0 3001 17 0 0
t$perf-norm:srv_aggregate_perf_data 82 82 0 0.00 0 227 7 0 0
t$perf-norm:srv_fill_mon_cache_memory 55 55 0 0.00 0 6 0 0 0
t$perf-norm:srv_make_invnt_saldo 473 473 0 0.00 0 807 20 0 0
t$perf-norm:srv_make_money_saldo 705 705 0 0.00 0 1101 19 0 0
t$perf-norm:srv_recalc_idx_stat 3 3 0 0.00 1 54 19 0 0
v_add_invoice_to_stock 8700 8486 214 2.45 0 7613 18 0 214
v_all_customers 32392 32392 0 0.00 0 42 1 0 0
v_all_suppliers 26542 26542 0 0.00 0 50 1 0 0
v_all_wares 35455 35455 0 0.00 0 42 1 0 0
v_cancel_adding_invoice 734 734 0 0.00 0 292 6 0 0
v_cancel_client_order 3210 3210 0 0.00 0 1363 4 0 0
v_cancel_customer_prepayment 1076 1076 0 0.00 0 12383 18 0 0
v_cancel_customer_reserve 1200 1200 0 0.00 0 827 5 0 0
v_cancel_payment_to_supplier 726 726 0 0.00 0 557 6 0 0
v_cancel_supplier_invoice 736 708 28 3.80 0 622 16 0 28
v_cancel_supplier_order 670 670 0 0.00 0 9572 18 0 0
v_cancel_write_off 1794 1794 0 0.00 0 12410 21 0 0
v_max_id_clo_ord 4686 4686 0 0.00 0 157 1 0 0
v_max_id_clo_res 900 900 0 0.00 0 2810 20 0 0
v_max_id_ord_sup 4682 4682 0 0.00 0 7185 4 0 0
v_max_non_paid_invoice 1239 1239 0 0.00 0 719 3 0 0
v_max_non_paid_realizn 2987 2987 0 0.00 0 5677 5 0 0
v_min_id_clo_ord 4686 4686 0 0.00 0 3526 6 0 0
v_min_id_clo_res 900 900 0 0.00 0 5626 12 0 0
v_min_id_ord_sup 4682 4682 0 0.00 0 8424 11 0 0
v_min_non_paid_invoice 5142 5142 0 0.00 0 4261 13 0 0
v_min_non_paid_realizn 6029 6029 0 0.00 0 7439 15 0 0
v_our_firm 9140 9140 0 0.00 0 21 1 0 0
v_reserve_write_off 17342 17342 0 0.00 0 14610 7 0 0
x_lock_depdocs_on_canc_invoice 9330 9330 0 0.00 0 14640 118 0 0
x_lock_depdocs_on_canc_sup_ord 335 335 0 0.00 0 16263 422 0 0
x_make_qstorno_1000_1200 4687 4687 0 0.00 1 48418 1233 0 0
x_make_qstorno_1200_2000 4687 4687 0 0.00 3 94564 3214 0 0
x_make_qstorno_2100_3300 400054 400054 0 0.00 0 52582 183 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 22-03-2024 22:10:59 to 22-03-2024 22:11:03.

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
20:09:45 3 8192000000 8799009520 8810369024 5304288 0.064 2 1 2 0 5403888 56816 42784
20:10:45 21939 8192000000 9868800256 10170130432 945331840 10.345 100 88 176 0 974616384 5268016 24016528
20:12:19 11168 8192000000 9935848704 10249900032 1011756128 10.992 100 87 174 0 1041521632 7340576 22424928
20:13:42 17598 8192000000 9966524832 10297131008 1058424480 11.441 100 78 156 0 1086964816 8236640 20303696
20:15:02 9328 8192000000 10031714096 10377494528 1121343088 12.040 100 85 170 0 1152156176 10460992 20352096
20:16:14 12022 8192000000 10074950736 10433777664 1163215376 12.433 100 73 146 0 1191694848 11159904 17319568
20:17:29 5819 8192000000 10125314608 10492514304 1206348304 12.835 100 79 156 0 1237257376 13364032 17545040
20:18:36 2320 8192000000 10158627392 10528645120 1238222880 13.130 100 81 163 0 1270225216 14183648 17818688
20:19:41 1980 8192000000 10179439152 10555035648 1265629600 13.382 100 82 162 0 1296766672 13300624 17836448
20:20:44 1158 8192000000 10206188480 10587832320 1291106176 13.614 100 91 184 1 1324149792 12612752 20430864
20:21:46 21024 8192000000 10204058080 10598187008 1298703360 13.683 100 48 95 1 1316453648 6605840 11144448
20:23:08 6478 8192000000 10203247104 10614181888 1310834928 13.794 100 39 78 1 1327199920 7949184 8415808
20:24:17 6412 8192000000 10203568432 10623217664 1321848080 13.893 100 26 50 1 1333839664 5467360 6524224
20:25:24 10513 8192000000 10207026688 10627883008 1326753088 13.938 100 29 59 0 1339508624 6370032 6385504
20:26:38 27570 8192000000 10215029328 10637389824 1317173872 13.851 99 23 46 1 1328957312 6286816 5496624
20:28:07 2559 8192000000 10229160480 10645962752 1332598160 13.991 100 41 80 0 1350538528 8922544 9017824
20:29:13 10089 8192000000 10213167664 10632904704 1323894384 13.912 100 11 23 1 1331908208 5574800 2439024
20:30:28 89169 8192000000 10237698448 10643996672 1304323344 13.735 98 60 119 0 1330150256 12470976 13355936
20:33:02 13301 8192000000 10213766576 10617348096 1298948416 13.686 99 43 85 1 1324037824 15551968 9537440
20:34:25 19575 8192000000 10228455216 10633461760 1294847664 13.648 98 58 115 0 1325156176 17901520 12406992
20:35:48 17215 8192000000 10234227648 10635571200 1318205040 13.860 100 54 107 0 1349183552 18709552 12268960
20:37:16 33076 8192000000 10239760496 10646306816 1292740880 13.629 97 41 82 0 1324458240 21918224 9799136
20:39:12 54672 8192000000 10227842240 10623295488 1242924176 13.173 94 49 94 0 1283536768 29475552 11137040
20:41:09 8684 8192000000 10241045568 10634317824 1297060528 13.669 99 51 100 0 1340575808 31971552 11543728
20:42:26 1698 8192000000 10267380704 10662916096 1323800528 13.911 100 62 123 1 1374856256 35500096 15555632
20:43:39 2258 8192000000 10286077600 10678185984 1326595024 13.936 100 79 154 0 1388571360 42335856 19640480
20:44:45 6944 8192000000 10308546960 10710523904 1354246064 14.186 100 63 124 0 1411612736 42666768 14699904
20:45:56 6942 8192000000 10322826352 10730086400 1364749184 14.280 100 66 132 2 1429736000 49039952 15946864
20:47:18 2416 8192000000 10334096624 10744823808 1382548688 14.439 100 57 112 1 1437305824 41055056 13702080
20:48:24 5332 8192000000 10342512752 10761388032 1390180656 14.507 100 51 102 1 1450887872 47329072 13378144
20:49:33 10746 8192000000 10355128960 10774921216 1391498864 14.519 100 48 93 1 1452160032 48401632 12259536
20:50:53 12597 8192000000 10338334512 10770432000 1407981872 14.666 100 40 78 0 1454764544 35895856 10886816
20:52:15 24390 8192000000 10344396688 10783113216 1413072976 14.711 100 31 62 0 1464406112 42461024 8872112
20:53:45 7088 8192000000 10367170144 10795663360 1418647392 14.761 100 48 95 0 1470640272 39697792 12295088
20:55:12 19187 8192000000 10347617888 10797391872 1408141296 14.667 100 25 50 0 1456719872 41180320 7398256
20:56:34 22358 8192000000 10309775280 10756370432 1384047248 14.453 99 20 40 1 1422014688 33017360 4950080
20:57:59 16739 8192000000 10312938192 10757595136 1377439808 14.394 98 29 58 0 1405264544 21062000 6762736
20:59:17 19273 8192000000 10315188752 10752372736 1398638544 14.583 100 43 87 0 1420151472 11711952 9800976
21:00:40 71112 8192000000 10298521264 10754322432 1383380192 14.447 99 9 18 0 1399866080 14866496 1619392
21:02:51 142536 8192000000 10309190112 10762629120 1372420704 14.349 98 31 62 1 1392049600 13068896 6560000
21:06:22 53289 8192000000 10290986272 10749059072 1381925664 14.434 99 18 36 0 1397329456 11514768 3889024
21:08:16 36554 8192000000 10291317280 10737561600 1388019968 14.488 100 32 63 0 1402256704 6361296 7875440
21:09:55 16149 8192000000 10276747056 10717073408 1360556256 14.242 99 26 52 0 1376640944 9522208 6562480
21:11:12 30740 8192000000 10304517744 10745294848 1379713552 14.414 99 38 76 1 1399624656 11065680 8845424
21:12:59 29165 8192000000 10285104592 10742542336 1383768448 14.450 100 13 25 0 1398281504 10950304 3562752
21:14:28 66661 8192000000 10283409568 10733346816 1370995184 14.336 99 24 48 0 1386775392 10134368 5645840
21:17:03 53511 8192000000 10286801680 10758737920 1360049056 14.238 98 7 14 0 1377266912 15594160 1623696
21:18:57 26845 8192000000 10271743088 10706919424 1314918592 13.831 95 31 62 0 1333759936 11621040 7220304
21:20:26 55968 8192000000 10273488560 10716381184 1319419504 13.871 96 9 18 0 1332213776 10496944 2297328
21:22:34 82697 8192000000 10260201968 10699718656 1292050752 13.623 95 17 34 0 1306182496 10627776 3503968
21:24:57 15197 8192000000 10251320240 10678624256 1331151536 13.978 100 50 100 0 1354597280 12339936 11105808
21:26:19 69580 8192000000 10269798576 10698526720 1314492160 13.827 97 27 54 0 1331168448 10999456 5676832
21:28:30 56199 8192000000 10247748400 10684989440 1287031120 13.577 96 26 52 0 1313451328 20762640 5657568
21:30:26 84185 8192000000 10241425248 10684796928 1323027680 13.904 99 38 76 1 1347573248 15199104 9346464
21:33:14 38572 8192000000 10280665184 10727624704 1358419472 14.223 100 27 54 0 1383102304 18407328 6275504
21:34:53 30590 8192000000 10261859936 10718654464 1350965392 14.156 99 13 26 0 1364121152 10207072 2948688
21:36:24 64047 8192000000 10268042496 10723065856 1359391392 14.232 99 8 16 0 1371550176 10279488 1879296
21:38:30 11506 8192000000 10271956224 10723307520 1359259120 14.231 99 8 16 0 1372965488 12037648 1668720
21:39:48 56705 8192000000 10302824160 10754244608 1391887888 14.523 100 19 36 0 1411002512 14455344 4659280
21:41:52 83256 8192000000 10294760656 10750439424 1382230128 14.436 100 9 18 0 1401994816 17874000 1890688
21:44:25 49714 8192000000 10294477312 10744360960 1355349728 14.196 97 14 28 0 1371558176 12936304 3272144
21:46:15 47898 8192000000 10274676480 10723557376 1349239648 14.141 98 15 30 1 1363984960 11837344 2907968
21:48:20 39957 8192000000 10305751280 10748375040 1365473264 14.286 98 40 81 0 1385282528 11312832 8496432
21:50:06 85903 8192000000 10304604880 10767106048 1363595760 14.270 98 16 32 0 1384412576 17689600 3127216
21:52:33 33446 8192000000 10299717776 10749382656 1375476480 14.376 99 32 63 0 1395469216 13087312 6905424
21:54:16 151728 8192000000 10301533600 10764173312 1360734080 14.244 97 38 75 0 1386217072 17089008 8393984
21:58:10 30503 8192000000 10287768240 10749538304 1366372352 14.295 98 23 43 0 1384463680 13470416 4620912
21:59:40 59503 8192000000 10269875648 10729988096 1361380272 14.250 99 15 30 0 1374044048 9045168 3618608
22:01:40 49244 8192000000 10260351088 10725785600 1340294816 14.060 97 9 18 0 1350107504 7761856 2050832
22:03:32 50116 8192000000 10275369584 10731479040 1348657216 14.135 98 21 42 0 1362717312 8889200 5170896
22:05:25 77705 8192000000 10266186624 10727936000 1304848976 13.739 95 15 30 1 1316313536 8306272 3158288
22:07:43 64543 8192000000 10275948160 10729443328 1354803856 14.191 99 18 36 0 1368841888 9841728 4196304

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:13, from 22-03-2024 22:11:05 to 22-03-2024 22:11:18.

Exceptions occured during test was in run

FB_MNEMONA CNT UNIT FB_GDSCODE
except 107 v_add_invoice_to_stock 335544517
except 14 v_cancel_supplier_invoice 335544517

Completed "Exceptions occured during test was in run". Done for 00:00:02, from 22-03-2024 22:11:19 to 22-03-2024 22:11:21.

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          178214
MON$OLDEST_ACTIVE               180479
MON$OLDEST_SNAPSHOT             180479
MON$NEXT_TRANSACTION            180479
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                       1899936
MON$STAT_ID                     1
MON$BACKUP_STATE                0
MON$CRYPT_PAGE                  0
MON$OWNER                       SYSDBA                                                                                       
MON$SEC_DATABASE                Default


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

Database statistics 

 
Database "/home/bases/oltp30-etalone.fdb" 
Gstat execution time Fri Mar 22 22:11:22 2024 
 
Database header page information: 
    Flags            0 
    Generation        94211 
    System Change Number    0 
    Page size        8192 
    ODS version        12.0 
    Oldest transaction    178214 
    Oldest active        180479 
    Oldest snapshot        180479 
    Next transaction    180480 
    Sequence number        0 
    Next attachment ID    719 
    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.34, total records: 7753645 
    Average version length: 48.16, total versions: 89213, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 64.00, compression ratio: 1.35 
    Pointer pages: 54, data page slots: 86720 
    Data pages: 86720, average fill: 71% 
    Primary pages: 86720, secondary pages: 0, swept pages: 16544 
    Empty pages: 5, full pages: 69244 
    Fill distribution: 
     0 - 19% = 31 
    20 - 39% = 257 
    40 - 59% = 2760 
    60 - 79% = 83648 
    80 - 99% = 24 
 
    Index DOC_DATA_DOC_WARE_UNQ (0) 
    Root page: 1510614, depth: 3, leaf buckets: 23357, nodes: 7753645 
    Average node length: 18.88, total dup: 0, max dup: 0 
    Average key length: 15.89, compression ratio: 1.70 
    Average prefix length: 14.11, average data length: 12.89 
    Clustering factor: 1724310, ratio: 0.22 
    Fill distribution: 
         0 - 19% = 364 
        20 - 39% = 1902 
        40 - 59% = 4067 
        60 - 79% = 2374 
        80 - 99% = 14650 
 
    Index DOC_DATA_ID_DESC (1) 
    Root page: 1528118, depth: 3, leaf buckets: 13550, nodes: 7753645 
    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: 1546387, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 1613 
        40 - 59% = 2036 
        60 - 79% = 1112 
        80 - 99% = 8789 
 
    Index FK_DOC_DATA_DOC_LIST (2) 
    Root page: 1546711, depth: 3, leaf buckets: 8377, nodes: 7753645 
    Average node length: 6.61, total dup: 5802867, max dup: 49 
    Average key length: 3.63, compression ratio: 2.48 
    Average prefix length: 7.63, average data length: 1.37 
    Clustering factor: 1539411, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 141 
        20 - 39% = 989 
        40 - 59% = 1376 
        60 - 79% = 923 
        80 - 99% = 4948 
 
DOC_LIST (138) 
    Primary pointer page: 472, Index root page: 473 
    Total formats: 1, used formats: 1 
    Average record length: 56.26, total records: 2242291 
    Average version length: 34.84, total versions: 91291, max versions: 3 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 84.00, compression ratio: 1.49 
    Pointer pages: 18, data page slots: 28384 
    Data pages: 28384, average fill: 73% 
    Primary pages: 28379, secondary pages: 5, swept pages: 9566 
    Empty pages: 3, full pages: 20970 
    Fill distribution: 
     0 - 19% = 17 
    20 - 39% = 152 
    40 - 59% = 1878 
    60 - 79% = 25579 
    80 - 99% = 758 
 
    Index DOC_LIST_ID_DESC (1) 
    Root page: 1541130, depth: 3, leaf buckets: 4562, nodes: 2242291 
    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: 687653, ratio: 0.31 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 915 
        40 - 59% = 873 
        60 - 79% = 718 
        80 - 99% = 2056 
 
    Index DOC_LIST_WORKER_OPTYPE (2) 
    Root page: 1544376, depth: 3, leaf buckets: 2549, nodes: 2245180 
    Average node length: 4.97, total dup: 2244281, max dup: 20296 
    Average key length: 2.01, compression ratio: 4.47 
    Average prefix length: 8.99, average data length: 0.01 
    Clustering factor: 1249460, ratio: 0.56 
    Fill distribution: 
         0 - 19% = 3 
        20 - 39% = 285 
        40 - 59% = 1572 
        60 - 79% = 526 
        80 - 99% = 163 
 
    Index FK_DOC_LIST_AGENTS (3) 
    Root page: 1545909, depth: 3, leaf buckets: 2050, nodes: 2242291 
    Average node length: 4.97, total dup: 2242241, max dup: 130662 
    Average key length: 2.01, compression ratio: 4.48 
    Average prefix length: 8.99, average data length: 0.01 
    Clustering factor: 1057999, ratio: 0.47 
    Fill distribution: 
         0 - 19% = 5 
        20 - 39% = 142 
        40 - 59% = 1038 
        60 - 79% = 46 
        80 - 99% = 819 
 
    Index PK_DOC_LIST (0) 
    Root page: 1538187, depth: 3, leaf buckets: 4367, nodes: 2242291 
    Average node length: 11.40, total dup: 0, max dup: 0 
    Average key length: 8.44, compression ratio: 1.07 
    Average prefix length: 3.56, average data length: 5.44 
    Clustering factor: 687653, ratio: 0.31 
    Fill distribution: 
         0 - 19% = 99 
        20 - 39% = 604 
        40 - 59% = 643 
        60 - 79% = 828 
        80 - 99% = 2193 
 
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.61, total records: 400 
    Average version length: 23.20, total versions: 234701, max versions: 612 
    Average fragment length: 2.00, total fragments: 37, max fragments: 1 
    Average unpacked length: 104.00, compression ratio: 1.26 
    Pointer pages: 1, data page slots: 1320 
    Data pages: 1320, average fill: 89% 
    Primary pages: 14, secondary pages: 1306, swept pages: 0 
    Empty pages: 7, full pages: 1312 
    Fill distribution: 
     0 - 19% = 7 
    20 - 39% = 1 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 1312 
 
    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: 7.89, total records: 67921 
    Average version length: 68.29, total versions: 60069, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 88.00, compression ratio: 11.15 
    Pointer pages: 7, data page slots: 2248 
    Data pages: 1584, average fill: 54% 
    Primary pages: 1583, secondary pages: 1, swept pages: 0 
    Empty pages: 320, full pages: 669 
    Fill distribution: 
     0 - 19% = 412 
    20 - 39% = 137 
    40 - 59% = 190 
    60 - 79% = 292 
    80 - 99% = 553 
 
    Index INVNT_TURNOVER_LOG_WARE_DD_ID (0) 
    Root page: 1708114, depth: 3, leaf buckets: 292, nodes: 67921 
    Average node length: 13.46, total dup: 4510, max dup: 1 
    Average key length: 10.79, compression ratio: 2.50 
    Average prefix length: 19.14, average data length: 7.86 
    Clustering factor: 50639, ratio: 0.75 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 187 
        40 - 59% = 76 
        60 - 79% = 27 
        80 - 99% = 0 
 
MONEY_SALDO (141) 
    Primary pointer page: 478, Index root page: 479 
    Total formats: 1, used formats: 1 
    Average record length: 15.22, total records: 49 
    Average version length: 9.00, total versions: 18320, max versions: 1009 
    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: 82% 
    Primary pages: 6, secondary pages: 66, swept pages: 0 
    Empty pages: 5, full pages: 66 
    Fill distribution: 
     0 - 19% = 6 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 12 
    80 - 99% = 54 
 
    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: 3.90, total records: 1289 
    Average version length: 43.73, total versions: 1173, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 58.00, compression ratio: 14.89 
    Pointer pages: 1, data page slots: 40 
    Data pages: 30, average fill: 41% 
    Primary pages: 28, secondary pages: 2, swept pages: 1 
    Empty pages: 12, full pages: 11 
    Fill distribution: 
     0 - 19% = 15 
    20 - 39% = 1 
    40 - 59% = 1 
    60 - 79% = 4 
    80 - 99% = 9 
 
    Index MONEY_TURNOVER_LOG_AGENT_OPTYPE (0) 
    Root page: 91058, depth: 2, leaf buckets: 3, nodes: 1289 
    Average node length: 4.42, total dup: 1191, max dup: 119 
    Average key length: 2.81, compression ratio: 6.77 
    Average prefix length: 18.27, average data length: 0.73 
    Clustering factor: 658, ratio: 0.51 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 2 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
MON_CACHE_MEMORY (165) 
    Primary pointer page: 526, Index root page: 527 
    Total formats: 2, used formats: 1 
    Average record length: 97.01, total records: 72 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 112.00, compression ratio: 1.15 
    Pointer pages: 1, data page slots: 2 
    Data pages: 2, average fill: 50% 
    Primary pages: 2, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 1 
    Fill distribution: 
     0 - 19% = 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: 72 
    Average node length: 11.69, total dup: 0, max dup: 0 
    Average key length: 10.68, compression ratio: 0.84 
    Average prefix length: 1.31, average data length: 7.69 
    Clustering factor: 2, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
MON_LOG (162) 
    Primary pointer page: 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.02, total records: 829676 
    Average version length: 25.23, total versions: 74626, max versions: 4 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 54.00, compression ratio: 1.50 
    Pointer pages: 6, data page slots: 8224 
    Data pages: 8216, average fill: 71% 
    Primary pages: 8195, secondary pages: 21, swept pages: 1294 
    Empty pages: 56, full pages: 7446 
    Fill distribution: 
     0 - 19% = 104 
    20 - 39% = 71 
    40 - 59% = 82 
    60 - 79% = 7656 
    80 - 99% = 303 
 
    Index PDISTR_AGENT_ID (2) 
    Root page: 1509308, depth: 2, leaf buckets: 909, nodes: 829676 
    Average node length: 4.87, total dup: 829627, max dup: 159207 
    Average key length: 2.01, compression ratio: 4.48 
    Average prefix length: 8.99, average data length: 0.01 
    Clustering factor: 90982, ratio: 0.11 
    Fill distribution: 
         0 - 19% = 3 
        20 - 39% = 111 
        40 - 59% = 530 
        60 - 79% = 191 
        80 - 99% = 74 
 
    Index PDISTR_SNDOP_RCVOP_SNDID_ASC (0) 
    Root page: 1508613, depth: 3, leaf buckets: 997, nodes: 829676 
    Average node length: 5.89, total dup: 738378, max dup: 42 
    Average key length: 3.02, compression ratio: 7.28 
    Average prefix length: 21.09, average data length: 0.91 
    Clustering factor: 165281, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 102 
        40 - 59% = 521 
        60 - 79% = 112 
        80 - 99% = 261 
 
    Index PDISTR_SNDOP_RCVOP_SNDID_DESC (1) 
    Root page: 1509187, depth: 3, leaf buckets: 1052, nodes: 829676 
    Average node length: 5.89, total dup: 738378, max dup: 42 
    Average key length: 3.02, compression ratio: 7.28 
    Average prefix length: 21.09, average data length: 0.91 
    Clustering factor: 167246, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 202 
        40 - 59% = 498 
        60 - 79% = 102 
        80 - 99% = 249 
 
    Index PDISTR_WORKER_SND_ID (3) 
    Root page: 1510178, depth: 3, leaf buckets: 1151, nodes: 829676 
    Average node length: 5.97, total dup: 738378, max dup: 42 
    Average key length: 3.10, compression ratio: 5.48 
    Average prefix length: 16.01, average data length: 0.99 
    Clustering factor: 159681, ratio: 0.19 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 234 
        40 - 59% = 588 
        60 - 79% = 217 
        80 - 99% = 111 
 
PERF_AGG (158) 
    Primary pointer page: 512, Index root page: 513 
    Total formats: 1, used formats: 1 
    Average record length: 62.83, total records: 5468 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 2.34, total fragments: 56, 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: 71, secondary pages: 25, swept pages: 51 
    Empty pages: 11, full pages: 64 
    Fill distribution: 
     0 - 19% = 25 
    20 - 39% = 0 
    40 - 59% = 2 
    60 - 79% = 68 
    80 - 99% = 1 
 
    Index PERF_AGG_UNQ (1) 
    Root page: 1504238, depth: 2, leaf buckets: 6, nodes: 5468 
    Average node length: 5.49, total dup: 0, max dup: 0 
    Average key length: 3.58, compression ratio: 10.04 
    Average prefix length: 34.45, average data length: 1.55 
    Clustering factor: 5153, ratio: 0.94 
    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: 5468 
    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: 150, 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: 82247 
    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: 800 
    Data pages: 800, average fill: 71% 
    Primary pages: 800, secondary pages: 0, swept pages: 0 
    Empty pages: 6, full pages: 792 
    Fill distribution: 
     0 - 19% = 7 
    20 - 39% = 1 
    40 - 59% = 0 
    60 - 79% = 792 
    80 - 99% = 0 
 
    Index PK_PERF_ESTIMATED (0) 
    Root page: 32632, depth: 2, leaf buckets: 106, nodes: 82247 
    Average node length: 10.16, total dup: 0, max dup: 0 
    Average key length: 8.17, compression ratio: 1.10 
    Average prefix length: 3.83, average data length: 5.17 
    Clustering factor: 3158, ratio: 0.04 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 0 
        40 - 59% = 4 
        60 - 79% = 1 
        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.68, 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.14 
    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.72, total records: 179060 
    Average version length: 152.67, total versions: 3898, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.48 
    Pointer pages: 7, data page slots: 6064 
    Data pages: 4296, average fill: 86% 
    Primary pages: 4295, secondary pages: 1, swept pages: 1 
    Empty pages: 45, full pages: 4237 
    Fill distribution: 
     0 - 19% = 52 
    20 - 39% = 2 
    40 - 59% = 1 
    60 - 79% = 4 
    80 - 99% = 4237 
 
PERF_SPLIT_1 (282) 
    Primary pointer page: 576, Index root page: 577 
    Total formats: 1, used formats: 1 
    Average record length: 150.26, total records: 165196 
    Average version length: 142.09, total versions: 632, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.29 
    Pointer pages: 6, data page slots: 4104 
    Data pages: 3936, average fill: 86% 
    Primary pages: 3936, secondary pages: 0, swept pages: 1 
    Empty pages: 22, full pages: 3906 
    Fill distribution: 
     0 - 19% = 24 
    20 - 39% = 3 
    40 - 59% = 0 
    60 - 79% = 2 
    80 - 99% = 3907 
 
PERF_SPLIT_2 (283) 
    Primary pointer page: 578, Index root page: 579 
    Total formats: 1, used formats: 1 
    Average record length: 141.91, total records: 175768 
    Average version length: 154.30, total versions: 10334, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.95 
    Pointer pages: 8, data page slots: 7024 
    Data pages: 4240, average fill: 86% 
    Primary pages: 4240, secondary pages: 0, swept pages: 1 
    Empty pages: 65, full pages: 4155 
    Fill distribution: 
     0 - 19% = 70 
    20 - 39% = 4 
    40 - 59% = 9 
    60 - 79% = 2 
    80 - 99% = 4155 
 
PERF_SPLIT_3 (284) 
    Primary pointer page: 580, Index root page: 581 
    Total formats: 1, used formats: 1 
    Average record length: 147.53, total records: 170132 
    Average version length: 153.64, total versions: 3665, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.50 
    Pointer pages: 5, data page slots: 4192 
    Data pages: 4056, average fill: 86% 
    Primary pages: 4056, secondary pages: 0, swept pages: 2 
    Empty pages: 22, full pages: 4023 
    Fill distribution: 
     0 - 19% = 25 
    20 - 39% = 4 
    40 - 59% = 2 
    60 - 79% = 3 
    80 - 99% = 4022 
 
PERF_SPLIT_4 (285) 
    Primary pointer page: 582, Index root page: 583 
    Total formats: 1, used formats: 1 
    Average record length: 148.34, total records: 156972 
    Average version length: 152.62, total versions: 2418, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.43 
    Pointer pages: 5, data page slots: 5496 
    Data pages: 3784, average fill: 85% 
    Primary pages: 3784, secondary pages: 0, swept pages: 1 
    Empty pages: 61, full pages: 3701 
    Fill distribution: 
     0 - 19% = 62 
    20 - 39% = 9 
    40 - 59% = 5 
    60 - 79% = 7 
    80 - 99% = 3701 
 
PERF_SPLIT_5 (286) 
    Primary pointer page: 584, Index root page: 585 
    Total formats: 1, used formats: 1 
    Average record length: 147.01, total records: 196911 
    Average version length: 153.22, total versions: 5546, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.54 
    Pointer pages: 8, data page slots: 5680 
    Data pages: 4704, average fill: 87% 
    Primary pages: 4704, secondary pages: 0, swept pages: 2 
    Empty pages: 26, full pages: 4668 
    Fill distribution: 
     0 - 19% = 29 
    20 - 39% = 1 
    40 - 59% = 3 
    60 - 79% = 4 
    80 - 99% = 4667 
 
PERF_SPLIT_6 (287) 
    Primary pointer page: 586, Index root page: 587 
    Total formats: 1, used formats: 1 
    Average record length: 147.47, total records: 163382 
    Average version length: 152.31, total versions: 3525, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.50 
    Pointer pages: 7, data page slots: 5608 
    Data pages: 3904, average fill: 86% 
    Primary pages: 3903, secondary pages: 1, swept pages: 5 
    Empty pages: 34, full pages: 3857 
    Fill distribution: 
     0 - 19% = 36 
    20 - 39% = 3 
    40 - 59% = 5 
    60 - 79% = 4 
    80 - 99% = 3856 
 
PERF_SPLIT_7 (288) 
    Primary pointer page: 588, Index root page: 589 
    Total formats: 1, used formats: 1 
    Average record length: 149.07, total records: 162334 
    Average version length: 150.33, total versions: 1605, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.38 
    Pointer pages: 7, data page slots: 4776 
    Data pages: 3896, average fill: 86% 
    Primary pages: 3896, secondary pages: 0, swept pages: 1 
    Empty pages: 48, full pages: 3830 
    Fill distribution: 
     0 - 19% = 54 
    20 - 39% = 2 
    40 - 59% = 7 
    60 - 79% = 3 
    80 - 99% = 3830 
 
PERF_SPLIT_8 (289) 
    Primary pointer page: 590, Index root page: 591 
    Total formats: 1, used formats: 1 
    Average record length: 148.82, total records: 181918 
    Average version length: 152.06, total versions: 2446, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.40 
    Pointer pages: 7, data page slots: 6040 
    Data pages: 4392, average fill: 85% 
    Primary pages: 4392, secondary pages: 0, swept pages: 4 
    Empty pages: 73, full pages: 4298 
    Fill distribution: 
     0 - 19% = 79 
    20 - 39% = 4 
    40 - 59% = 6 
    60 - 79% = 5 
    80 - 99% = 4298 
 
PERF_SPLIT_9 (290) 
    Primary pointer page: 593, Index root page: 594 
    Total formats: 1, used formats: 1 
    Average record length: 147.60, total records: 189374 
    Average version length: 153.30, total versions: 4467, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.49 
    Pointer pages: 6, data page slots: 5704 
    Data pages: 4536, average fill: 86% 
    Primary pages: 4536, secondary pages: 0, swept pages: 3 
    Empty pages: 38, full pages: 4487 
    Fill distribution: 
     0 - 19% = 42 
    20 - 39% = 4 
    40 - 59% = 1 
    60 - 79% = 2 
    80 - 99% = 4487 
 
PHRASES (143) 
    Primary pointer page: 482, Index root page: 483 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index PHRASES_ID_DESC (3) 
    Root page: 1510354, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PHRASES_NAME (2) 
    Root page: 1510353, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PHRASES_UNQ (1) 
    Root page: 1510352, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PK_PHRASES (0) 
    Root page: 1510351, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
PSTORNED (147) 
    Primary pointer page: 490, Index root page: 491 
    Total formats: 1, used formats: 1 
    Average record length: 51.53, total records: 2097365 
    Average version length: 52.85, total versions: 48361, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 70.00, compression ratio: 1.36 
    Pointer pages: 16, data page slots: 25592 
    Data pages: 25592, average fill: 71% 
    Primary pages: 25592, secondary pages: 0, swept pages: 10355 
    Empty pages: 323, full pages: 20793 
    Fill distribution: 
     0 - 19% = 622 
    20 - 39% = 536 
    40 - 59% = 1110 
    60 - 79% = 22916 
    80 - 99% = 408 
 
    Index PSTORNED_RCV_ID (1) 
    Root page: 1506186, depth: 3, leaf buckets: 2573, nodes: 2097365 
    Average node length: 5.44, total dup: 1956952, max dup: 1633 
    Average key length: 2.49, compression ratio: 3.62 
    Average prefix length: 8.58, average data length: 0.42 
    Clustering factor: 182394, ratio: 0.09 
    Fill distribution: 
         0 - 19% = 4 
        20 - 39% = 316 
        40 - 59% = 1632 
        60 - 79% = 316 
        80 - 99% = 305 
 
    Index PSTORNED_SND_ID (0) 
    Root page: 1504819, depth: 3, leaf buckets: 2760, nodes: 2097365 
    Average node length: 5.69, total dup: 1882256, max dup: 71 
    Average key length: 2.74, compression ratio: 3.29 
    Average prefix length: 8.36, average data length: 0.64 
    Clustering factor: 375434, ratio: 0.18 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 9 
        40 - 59% = 2412 
        60 - 79% = 306 
        80 - 99% = 33 
 
    Index PSTORNED_WORKER_ID (2) 
    Root page: 1507996, depth: 3, leaf buckets: 2152, nodes: 2097365 
    Average node length: 4.96, total dup: 2097265, max dup: 29280 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.41, average data length: 0.00 
    Clustering factor: 180263, ratio: 0.09 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 202 
        40 - 59% = 1169 
        60 - 79% = 370 
        80 - 99% = 409 
 
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: 37.49, total records: 150547 
    Average version length: 69.18, total versions: 69013, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 3.36 
    Pointer pages: 3, data page slots: 4256 
    Data pages: 3184, average fill: 55% 
    Primary pages: 3184, secondary pages: 0, swept pages: 457 
    Empty pages: 620, full pages: 1869 
    Fill distribution: 
     0 - 19% = 869 
    20 - 39% = 194 
    40 - 59% = 150 
    60 - 79% = 723 
    80 - 99% = 1248 
 
    Index XQD_1000_1200_WA_SO_RO_WKR_SND (0) 
    Root page: 104481, depth: 3, leaf buckets: 231, nodes: 150547 
    Average node length: 6.44, total dup: 130975, max dup: 29 
    Average key length: 3.94, compression ratio: 10.65 
    Average prefix length: 40.18, average data length: 1.82 
    Clustering factor: 26101, ratio: 0.17 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 40 
        40 - 59% = 128 
        60 - 79% = 46 
        80 - 99% = 16 
 
XQD_1000_3300 (178) 
    Primary pointer page: 553, Index root page: 554 
    Total formats: 1, used formats: 1 
    Average record length: 64.26, total records: 7285265 
    Average version length: 68.75, total versions: 497205, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.96 
    Pointer pages: 64, data page slots: 103912 
    Data pages: 103912, average fill: 75% 
    Primary pages: 103912, secondary pages: 0, swept pages: 21231 
    Empty pages: 18, full pages: 86331 
    Fill distribution: 
     0 - 19% = 121 
    20 - 39% = 782 
    40 - 59% = 5169 
    60 - 79% = 88767 
    80 - 99% = 9073 
 
    Index XQD_1000_3300_WA_SO_RO_WKR_SND (0) 
    Root page: 1480454, depth: 3, leaf buckets: 10737, nodes: 7285265 
    Average node length: 6.51, total dup: 6300680, max dup: 29 
    Average key length: 3.52, compression ratio: 11.93 
    Average prefix length: 40.61, average data length: 1.39 
    Clustering factor: 1610658, ratio: 0.22 
    Fill distribution: 
         0 - 19% = 7 
        20 - 39% = 1447 
        40 - 59% = 5655 
        60 - 79% = 2973 
        80 - 99% = 655 
 
    Index XQD_1000_3300_WKR_DOC_ASC (1) 
    Root page: 1486068, depth: 3, leaf buckets: 8626, nodes: 7285265 
    Average node length: 5.39, total dup: 6998461, max dup: 173 
    Average key length: 2.40, compression ratio: 7.08 
    Average prefix length: 16.64, average data length: 0.36 
    Clustering factor: 1402793, ratio: 0.19 
    Fill distribution: 
         0 - 19% = 8 
        20 - 39% = 1088 
        40 - 59% = 4716 
        60 - 79% = 1684 
        80 - 99% = 1130 
 
    Index XQD_1000_3300_WKR_DOC_DEC (2) 
    Root page: 1490608, depth: 3, leaf buckets: 8656, nodes: 7285265 
    Average node length: 5.39, total dup: 6998461, max dup: 173 
    Average key length: 2.40, compression ratio: 7.08 
    Average prefix length: 16.64, average data length: 0.36 
    Clustering factor: 1405316, ratio: 0.19 
    Fill distribution: 
         0 - 19% = 3 
        20 - 39% = 1114 
        40 - 59% = 4657 
        60 - 79% = 1749 
        80 - 99% = 1133 
 
XQD_1200_2000 (177) 
    Primary pointer page: 551, Index root page: 552 
    Total formats: 1, used formats: 1 
    Average record length: 66.75, total records: 12231855 
    Average version length: 68.70, total versions: 390064, 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: 104, data page slots: 168496 
    Data pages: 168496, average fill: 77% 
    Primary pages: 168496, secondary pages: 0, swept pages: 69268 
    Empty pages: 5, full pages: 163769 
    Fill distribution: 
     0 - 19% = 21 
    20 - 39% = 175 
    40 - 59% = 1284 
    60 - 79% = 158214 
    80 - 99% = 8802 
 
    Index XQD_1200_2000_WA_SO_RO_WKR_SND (0) 
    Root page: 1495028, depth: 3, leaf buckets: 18355, nodes: 12231855 
    Average node length: 6.59, total dup: 10660703, max dup: 61 
    Average key length: 3.43, compression ratio: 12.26 
    Average prefix length: 40.70, average data length: 1.30 
    Clustering factor: 2407205, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 36 
        20 - 39% = 1878 
        40 - 59% = 10746 
        60 - 79% = 4873 
        80 - 99% = 822 
 
XQD_2000_3300 (179) 
    Primary pointer page: 555, Index root page: 556 
    Total formats: 1, used formats: 1 
    Average record length: 41.16, total records: 1692808 
    Average version length: 69.13, total versions: 685237, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 3.06 
    Pointer pages: 26, data page slots: 41936 
    Data pages: 29023, average fill: 67% 
    Primary pages: 29023, secondary pages: 0, swept pages: 6207 
    Empty pages: 2224, full pages: 20374 
    Fill distribution: 
     0 - 19% = 4102 
    20 - 39% = 1723 
    40 - 59% = 1583 
    60 - 79% = 10570 
    80 - 99% = 11045 
 
    Index XQD_2000_3300_WA_SO_RO_WKR_SND (0) 
    Root page: 1479712, depth: 3, leaf buckets: 2155, nodes: 1692808 
    Average node length: 5.51, total dup: 1624653, max dup: 97 
    Average key length: 2.55, compression ratio: 16.45 
    Average prefix length: 41.49, average data length: 0.51 
    Clustering factor: 113353, ratio: 0.07 
    Fill distribution: 
         0 - 19% = 14 
        20 - 39% = 413 
        40 - 59% = 1029 
        60 - 79% = 521 
        80 - 99% = 178 
 
XQD_2100_3300 (180) 
    Primary pointer page: 557, Index root page: 558 
    Total formats: 1, used formats: 1 
    Average record length: 38.62, total records: 1153049 
    Average version length: 69.13, total versions: 507923, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 3.26 
    Pointer pages: 23, data page slots: 35896 
    Data pages: 28320, average fill: 47% 
    Primary pages: 28320, secondary pages: 0, swept pages: 6183 
    Empty pages: 5957, full pages: 12395 
    Fill distribution: 
     0 - 19% = 9636 
    20 - 39% = 2680 
    40 - 59% = 1905 
    60 - 79% = 5793 
    80 - 99% = 8306 
 
    Index XQD_2100_3300_WA_SO_RO_WKR_SND (0) 
    Root page: 1479207, depth: 3, leaf buckets: 1666, nodes: 1153049 
    Average node length: 5.80, total dup: 1075305, max dup: 99 
    Average key length: 2.87, compression ratio: 14.64 
    Average prefix length: 41.20, average data length: 0.80 
    Clustering factor: 156358, ratio: 0.14 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 428 
        40 - 59% = 832 
        60 - 79% = 350 
        80 - 99% = 55 
 
XQD_3300_3400 (181) 
    Primary pointer page: 559, Index root page: 560 
    Total formats: 1, used formats: 1 
    Average record length: 65.23, total records: 9181161 
    Average version length: 68.96, total versions: 488700, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.93 
    Pointer pages: 89, data page slots: 145000 
    Data pages: 144984, average fill: 68% 
    Primary pages: 144984, secondary pages: 0, swept pages: 52574 
    Empty pages: 317, full pages: 79877 
    Fill distribution: 
     0 - 19% = 1409 
    20 - 39% = 8092 
    40 - 59% = 25367 
    60 - 79% = 102050 
    80 - 99% = 8066 
 
    Index XQD_3300_3400_WA_SO_RO_WKR_SND (0) 
    Root page: 1472590, depth: 3, leaf buckets: 13443, nodes: 9181161 
    Average node length: 6.69, total dup: 7616479, max dup: 29 
    Average key length: 3.66, compression ratio: 11.46 
    Average prefix length: 40.51, average data length: 1.49 
    Clustering factor: 1964990, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 1268 
        40 - 59% = 6812 
        60 - 79% = 4703 
        80 - 99% = 659 
 
XQS_1000_1200 (182) 
    Primary pointer page: 561, Index root page: 562 
    Total formats: 1, used formats: 1 
    Average record length: 82.49, total records: 21184747 
    Average version length: 82.92, total versions: 13942, 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: 319232 
    Data pages: 319232, average fill: 81% 
    Primary pages: 319232, secondary pages: 0, swept pages: 12940 
    Empty pages: 19, full pages: 318767 
    Fill distribution: 
     0 - 19% = 28 
    20 - 39% = 17 
    40 - 59% = 34 
    60 - 79% = 27613 
    80 - 99% = 291540 
 
    Index XQS_1000_1200_DOC_ID (1) 
    Root page: 1426716, depth: 3, leaf buckets: 19384, nodes: 21184747 
    Average node length: 5.72, total dup: 20702974, max dup: 159 
    Average key length: 2.16, compression ratio: 4.16 
    Average prefix length: 8.86, average data length: 0.14 
    Clustering factor: 3287626, ratio: 0.16 
    Fill distribution: 
         0 - 19% = 6 
        20 - 39% = 1 
        40 - 59% = 8078 
        60 - 79% = 555 
        80 - 99% = 10744 
 
    Index XQS_1000_1200_RCV_ID (3) 
    Root page: 1456980, depth: 3, leaf buckets: 17210, nodes: 21184747 
    Average node length: 6.31, total dup: 18617933, max dup: 49 
    Average key length: 2.75, compression ratio: 3.27 
    Average prefix length: 8.37, average data length: 0.63 
    Clustering factor: 916562, ratio: 0.04 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 0 
        40 - 59% = 807 
        60 - 79% = 264 
        80 - 99% = 16137 
 
    Index XQS_1000_1200_SND_ID (2) 
    Root page: 1441073, depth: 3, leaf buckets: 21185, nodes: 21184747 
    Average node length: 6.35, total dup: 18535998, max dup: 29 
    Average key length: 2.79, compression ratio: 3.23 
    Average prefix length: 8.34, average data length: 0.66 
    Clustering factor: 3581934, ratio: 0.17 
    Fill distribution: 
         0 - 19% = 6 
        20 - 39% = 1 
        40 - 59% = 8364 
        60 - 79% = 635 
        80 - 99% = 12179 
 
    Index XQS_1000_1200_WORKER_ID (0) 
    Root page: 1413348, depth: 3, leaf buckets: 16145, nodes: 21184747 
    Average node length: 5.56, total dup: 21184647, max dup: 229331 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.42, average data length: 0.00 
    Clustering factor: 945362, ratio: 0.04 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 7 
        40 - 59% = 2933 
        60 - 79% = 386 
        80 - 99% = 12818 
 
XQS_1000_3300 (184) 
    Primary pointer page: 565, Index root page: 566 
    Total formats: 1, used formats: 1 
    Average record length: 77.74, total records: 9692344 
    Average version length: 82.57, total versions: 549180, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.62 
    Pointer pages: 103, data page slots: 166504 
    Data pages: 166472, average fill: 72% 
    Primary pages: 166472, secondary pages: 0, swept pages: 60028 
    Empty pages: 453, full pages: 108474 
    Fill distribution: 
     0 - 19% = 1494 
    20 - 39% = 5886 
    40 - 59% = 20775 
    60 - 79% = 68775 
    80 - 99% = 69542 
 
    Index XQS_1000_3300_DOC_ID (1) 
    Root page: 1367502, depth: 3, leaf buckets: 11350, nodes: 9692344 
    Average node length: 5.35, total dup: 9383319, max dup: 196 
    Average key length: 2.23, compression ratio: 4.03 
    Average prefix length: 8.80, average data length: 0.20 
    Clustering factor: 2133971, ratio: 0.22 
    Fill distribution: 
         0 - 19% = 5 
        20 - 39% = 63 
        40 - 59% = 8332 
        60 - 79% = 2874 
        80 - 99% = 76 
 
    Index XQS_1000_3300_RCV_ID (3) 
    Root page: 1379261, depth: 3, leaf buckets: 13446, nodes: 9692344 
    Average node length: 6.21, total dup: 8034346, max dup: 14 
    Average key length: 3.10, compression ratio: 2.90 
    Average prefix length: 8.07, average data length: 0.93 
    Clustering factor: 1482499, ratio: 0.15 
    Fill distribution: 
         0 - 19% = 139 
        20 - 39% = 3893 
        40 - 59% = 4312 
        60 - 79% = 2631 
        80 - 99% = 2471 
 
    Index XQS_1000_3300_SND_ID (2) 
    Root page: 1373059, depth: 3, leaf buckets: 12671, nodes: 9692344 
    Average node length: 5.96, total dup: 8413221, max dup: 44 
    Average key length: 2.85, compression ratio: 3.16 
    Average prefix length: 8.28, average data length: 0.72 
    Clustering factor: 2331679, ratio: 0.24 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 94 
        40 - 59% = 9350 
        60 - 79% = 3126 
        80 - 99% = 100 
 
    Index XQS_1000_3300_WORKER_ID (0) 
    Root page: 1362767, depth: 3, leaf buckets: 10118, nodes: 9692344 
    Average node length: 5.11, total dup: 9692244, max dup: 158695 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.41, average data length: 0.00 
    Clustering factor: 1496986, ratio: 0.15 
    Fill distribution: 
         0 - 19% = 32 
        20 - 39% = 1226 
        40 - 59% = 5066 
        60 - 79% = 1772 
        80 - 99% = 2022 
 
XQS_1200_2000 (183) 
    Primary pointer page: 563, Index root page: 564 
    Total formats: 1, used formats: 1 
    Average record length: 79.77, total records: 11256944 
    Average version length: 82.58, total versions: 346177, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.58 
    Pointer pages: 119, data page slots: 192672 
    Data pages: 191096, average fill: 72% 
    Primary pages: 191096, secondary pages: 0, swept pages: 72227 
    Empty pages: 3425, full pages: 140381 
    Fill distribution: 
     0 - 19% = 5793 
    20 - 39% = 7831 
    40 - 59% = 18765 
    60 - 79% = 42944 
    80 - 99% = 115763 
 
    Index XQS_1200_2000_DOC_ID (1) 
    Root page: 1392101, depth: 3, leaf buckets: 13133, nodes: 11256944 
    Average node length: 5.30, total dup: 11147117, max dup: 662 
    Average key length: 2.08, compression ratio: 4.33 
    Average prefix length: 8.93, average data length: 0.07 
    Clustering factor: 2338012, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 3 
        20 - 39% = 146 
        40 - 59% = 9251 
        60 - 79% = 3595 
        80 - 99% = 138 
 
    Index XQS_1200_2000_RCV_ID (3) 
    Root page: 1406110, depth: 3, leaf buckets: 10452, nodes: 11256944 
    Average node length: 5.49, total dup: 10765742, max dup: 49 
    Average key length: 2.28, compression ratio: 3.95 
    Average prefix length: 8.77, average data length: 0.23 
    Clustering factor: 696934, ratio: 0.06 
    Fill distribution: 
         0 - 19% = 149 
        20 - 39% = 890 
        40 - 59% = 2617 
        60 - 79% = 1827 
        80 - 99% = 4969 
 
    Index XQS_1200_2000_SND_ID (2) 
    Root page: 1398638, depth: 3, leaf buckets: 15021, nodes: 11256944 
    Average node length: 6.03, total dup: 9819268, max dup: 67 
    Average key length: 2.81, compression ratio: 3.21 
    Average prefix length: 8.32, average data length: 0.68 
    Clustering factor: 2354457, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 159 
        40 - 59% = 10791 
        60 - 79% = 3907 
        80 - 99% = 163 
 
    Index XQS_1200_2000_WORKER_ID (0) 
    Root page: 1386211, depth: 3, leaf buckets: 10750, nodes: 11256944 
    Average node length: 5.22, total dup: 11256844, max dup: 197428 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.41, average data length: 0.00 
    Clustering factor: 685881, ratio: 0.06 
    Fill distribution: 
         0 - 19% = 91 
        20 - 39% = 848 
        40 - 59% = 4821 
        60 - 79% = 1487 
        80 - 99% = 3503 
 
XQS_2000_3300 (185) 
    Primary pointer page: 567, Index root page: 568 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index XQS_2000_3300_DOC_ID (1) 
    Root page: 1361753, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index XQS_2000_3300_RCV_ID (3) 
    Root page: 1361755, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index XQS_2000_3300_SND_ID (2) 
    Root page: 1361754, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index XQS_2000_3300_WORKER_ID (0) 
    Root page: 1361752, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
XQS_2100_3300 (186) 
    Primary pointer page: 569, Index root page: 570 
    Total formats: 1, used formats: 1 
    Average record length: 78.43, total records: 9767154 
    Average version length: 82.89, total versions: 509084, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.61 
    Pointer pages: 105, data page slots: 169896 
    Data pages: 169872, average fill: 71% 
    Primary pages: 169872, secondary pages: 0, swept pages: 66935 
    Empty pages: 540, full pages: 105820 
    Fill distribution: 
     0 - 19% = 1719 
    20 - 39% = 6479 
    40 - 59% = 22878 
    60 - 79% = 73128 
    80 - 99% = 65668 
 
    Index XQS_2100_3300_DOC_ID (1) 
    Root page: 1344686, depth: 3, leaf buckets: 11758, nodes: 9767154 
    Average node length: 5.16, total dup: 9738187, max dup: 2074 
    Average key length: 2.03, compression ratio: 4.43 
    Average prefix length: 8.97, average data length: 0.03 
    Clustering factor: 1942742, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 31 
        20 - 39% = 1491 
        40 - 59% = 7815 
        60 - 79% = 1828 
        80 - 99% = 593 
 
    Index XQS_2100_3300_RCV_ID (3) 
    Root page: 1355717, depth: 3, leaf buckets: 13543, nodes: 9767154 
    Average node length: 6.23, total dup: 8096700, max dup: 14 
    Average key length: 3.10, compression ratio: 2.90 
    Average prefix length: 8.07, average data length: 0.93 
    Clustering factor: 1452694, ratio: 0.15 
    Fill distribution: 
         0 - 19% = 176 
        20 - 39% = 3914 
        40 - 59% = 4248 
        60 - 79% = 2623 
        80 - 99% = 2582 
 
    Index XQS_2100_3300_SND_ID (2) 
    Root page: 1350049, depth: 3, leaf buckets: 12424, nodes: 9767154 
    Average node length: 5.41, total dup: 9329837, max dup: 99 
    Average key length: 2.29, compression ratio: 3.94 
    Average prefix length: 8.76, average data length: 0.24 
    Clustering factor: 2076922, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 19 
        20 - 39% = 1522 
        40 - 59% = 8712 
        60 - 79% = 1598 
        80 - 99% = 573 
 
    Index XQS_2100_3300_WORKER_ID (0) 
    Root page: 985805, depth: 3, leaf buckets: 10171, nodes: 9767154 
    Average node length: 5.13, total dup: 9767054, max dup: 160338 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.41, average data length: 0.00 
    Clustering factor: 1525643, ratio: 0.16 
    Fill distribution: 
         0 - 19% = 42 
        20 - 39% = 1270 
        40 - 59% = 4993 
        60 - 79% = 1736 
        80 - 99% = 2130 
 
XQS_3300_3400 (187) 
    Primary pointer page: 571, Index root page: 572 
    Total formats: 1, used formats: 1 
    Average record length: 67.08, total records: 574784 
    Average version length: 68.80, total versions: 9175, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.88 
    Pointer pages: 5, data page slots: 7944 
    Data pages: 7944, average fill: 76% 
    Primary pages: 7944, secondary pages: 0, swept pages: 3504 
    Empty pages: 3, full pages: 6909 
    Fill distribution: 
     0 - 19% = 3 
    20 - 39% = 13 
    40 - 59% = 160 
    60 - 79% = 7614 
    80 - 99% = 154 
 
    Index XQS_3300_3400_DOC_ID (1) 
    Root page: 33564, depth: 3, leaf buckets: 732, nodes: 574784 
    Average node length: 5.95, total dup: 489364, max dup: 82 
    Average key length: 3.09, compression ratio: 2.91 
    Average prefix length: 8.06, average data length: 0.94 
    Clustering factor: 100443, ratio: 0.17 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 33 
        40 - 59% = 501 
        60 - 79% = 102 
        80 - 99% = 96 
 
    Index XQS_3300_3400_SND_ID (2) 
    Root page: 21932, depth: 3, leaf buckets: 748, nodes: 574784 
    Average node length: 6.15, total dup: 471289, max dup: 27 
    Average key length: 3.29, compression ratio: 2.73 
    Average prefix length: 7.89, average data length: 1.11 
    Clustering factor: 100500, ratio: 0.17 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 29 
        40 - 59% = 514 
        60 - 79% = 89 
        80 - 99% = 116 
 
    Index XQS_3300_3400_WORKER_ID (0) 
    Root page: 375548, depth: 2, leaf buckets: 573, nodes: 574784 
    Average node length: 4.86, total dup: 574684, max dup: 10260 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.41, average data length: 0.00 
    Clustering factor: 89223, ratio: 0.16 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 40 
        40 - 59% = 320 
        60 - 79% = 105 
        80 - 99% = 108 
 
ZDOC_DATA (170) 
    Primary pointer page: 537, Index root page: 538 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
ZDOC_LIST (169) 
    Primary pointer page: 535, Index root page: 536 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
ZINVNT_TURNOVER_LOG (171) 
    Primary pointer page: 539, Index root page: 540 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
ZPDISTR (174) 
    Primary pointer page: 545, Index root page: 546 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index ZPDISTR_ID (0) 
    Root page: 1504207, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
ZPSTORNED (175) 
    Primary pointer page: 547, Index root page: 548 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index ZPSTORNED_ID (0) 
    Root page: 1504206, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
ZQDISTR (172) 
    Primary pointer page: 541, Index root page: 542 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index ZQDISTR_ID (0) 
    Root page: 1504212, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index ZQDISTR_WARE_SNDOP_RCVOP (1) 
    Root page: 1504213, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
ZQSTORNED (173) 
    Primary pointer page: 543, Index root page: 544 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index ZQSTORNED_DOC_ID (1) 
    Root page: 1504209, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index ZQSTORNED_ID (0) 
    Root page: 1504208, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index ZQSTORNED_RCV_ID (3) 
    Root page: 1504211, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index ZQSTORNED_SND_ID (2) 
    Root page: 1504210, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
ZTMP_DEP_DOCS (168) 
    Primary pointer page: 533, Index root page: 534 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
ZTMP_SHOPPING_CART (167) 
    Primary pointer page: 531, Index root page: 532 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
Z_USED_VIEWS (144) 
    Primary pointer page: 484, Index root page: 485 
    Total formats: 1, used formats: 1 
    Average record length: 29.38, total records: 29 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 99.00, compression ratio: 3.37 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 16% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index Z_USED_VIEWS_UNQ (0) 
    Root page: 1510350, depth: 1, leaf buckets: 1, nodes: 29 
    Average node length: 15.17, total dup: 0, max dup: 0 
    Average key length: 14.14, compression ratio: 1.44 
    Average prefix length: 9.17, average data length: 11.17 
    Clustering factor: 1, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
Gstat completion time Fri Mar 22 22:11:46 2024

Record versions statistics, table

TABLE_NAME TOTAL_RECS TOTAL_VERS MAX_VERSIONS VERS_TO_RECS_PRC MAXV_TO_VERS_PRC
DOC_DATA 7753645 89213 1 0.0000 0.0000
DOC_LIST 2242291 91291 3 0.0000 0.0000
FB_ERRORS 2182 757 1 0.0000 0.0000
INVNT_SALDO 400 234701 612 58600.0000 0.0000
INVNT_TURNOVER_LOG 67921 60069 1 0.0000 0.0000
MONEY_SALDO 49 18320 1009 37300.0000 0.0000
MONEY_TURNOVER_LOG 1289 1173 1 0.0000 0.0000
PDISTR 829676 74626 4 0.0000 0.0000
PERF_SPLIT_0 179060 3898 1 0.0000 0.0000
PERF_SPLIT_1 165196 632 1 0.0000 0.0000
PERF_SPLIT_2 175768 10334 1 0.0000 0.0000
PERF_SPLIT_3 170132 3665 1 0.0000 0.0000
PERF_SPLIT_4 156972 2418 1 0.0000 0.0000
PERF_SPLIT_5 196911 5546 1 0.0000 0.0000
PERF_SPLIT_6 163382 3525 1 0.0000 0.0000
PERF_SPLIT_7 162334 1605 1 0.0000 0.0000
PERF_SPLIT_8 181918 2446 1 0.0000 0.0000
PERF_SPLIT_9 189374 4467 1 0.0000 0.0000
PSTORNED 2097365 48361 1 0.0000 0.0000
SEMAPHORES 5 1 1 0.0000 100.0000
XQD_1000_1200 150547 69013 1 0.0000 0.0000
XQD_1000_3300 7285265 497205 1 0.0000 0.0000
XQD_1200_2000 12231855 390064 1 0.0000 0.0000
XQD_2000_3300 1692808 685237 1 0.0000 0.0000
XQD_2100_3300 1153049 507923 1 0.0000 0.0000
XQD_3300_3400 9181161 488700 1 0.0000 0.0000
XQS_1000_1200 21184747 13942 1 0.0000 0.0000
XQS_1000_3300 9692344 549180 1 0.0000 0.0000
XQS_1200_2000 11256944 346177 1 0.0000 0.0000
XQS_2100_3300 9767154 509084 1 0.0000 0.0000
XQS_3300_3400 574784 9175 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 ---
:140: 
:141: mscs-test-161.budzdorov.ru    Fri Mar 22 22:09:43 2024
:142:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:143: 
--- end of diff output ---

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

22.03.24 22:11:58. 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-22 22:12:00 No severe PSQL-related problems occured
22.03.24 22:12:02. End of report.