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

Hardware and OS info

Command: hostnamectl
Static hostname mscs-test-161.budzdorov.ru
Icon name computer-server
Chassis server
Machine ID aeee285d2cca40bf84c40a748f599e77
Boot ID 2a7b53d1c5ed44b9bb2712fffac5d8c6
Operating System CentOS Linux 7 (Core)
CPE OS Name cpe:/o:centos:centos:7
Kernel Linux 3.10.0-1127.10.1.el7.x86_64
Architecture x86-64
Command: who -b
bootup_info system boot 2021-11-11 18:28
Command: dmidecode -t system|grep -i -e 'manufacturer\|product\|hypervisor'
Manufacturer HP
Product Name ProLiant DL380 Gen9
Command: dmesg | grep DMI
[ 0.000000] DMI HP ProLiant DL380 Gen9/ProLiant DL380 Gen9, BIOS P89 05/21/2018
Command: lscpu | grep -i -v flags
Architecture x86_64
CPU op-mode(s) 32-bit, 64-bit
Byte Order Little Endian
CPU(s) 24
On-line CPU(s) list 0-23
Thread(s) per core 2
Core(s) per socket 6
Socket(s) 2
NUMA node(s) 2
Vendor ID GenuineIntel
CPU family 6
Model 63
Model name Intel(R) Xeon(R) CPU E5-2620 v3 @ 2.40GHz
Stepping 2
CPU MHz 1200.000
CPU max MHz 2400.0000
CPU min MHz 1200.0000
BogoMIPS 4794.33
Virtualization VT-x
L1d cache 32K
L1i cache 32K
L2 cache 256K
L3 cache 15360K
NUMA node0 CPU(s) 0-5,12-17
NUMA node1 CPU(s) 6-11,18-23
Command: cat /proc/meminfo | grep -i -e 'memtotal\|memfree\|memavail\|buffers\|cached\|swapcached'
MemTotal 32643792 kB
MemFree 16695836 kB
MemAvailable 30130216 kB
Buffers 0 kB
Cached 15034008 kB
SwapCached 2492 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-04-06 01:09:43
DTS_END                         2024-04-06 01:09:43.2040
FB_GDSCODE                      -1
FB_MNEMONA                      
STACK                           SP_ADD_INVOICE_TO_STOCK(190:30) ==> SP_CUSTOMER_RESERVE(47:5) ==> SP_CHECK_TO_STOP_WORK(32:12) ==> SP_HALT_ON_ERROR(57:17)
IP                              ::1/57832
TRN_ID                          176701
ATT_ID                          609
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: 9325.25 19376 932525
customer order: creation 179.92 355 17992
customer order: refuse 15.40 365 1540
order to supplier: creation 48.54 1407 4854
order to supplier: removal 3.42 106895 342
invoice (draft): creation 46.56 3487 4656
invoice (draft): removal 50.76 807 5076
invoice accept: apply 42.56 21799 4256
invoice accept: cancel 45.48 910 4548
customer reserve: creation 4117.59 207 411759
customer reserve: removal 4470.63 64 447063
realization accept: apply 86.36 215 8636
realization accept: cancel 82.03 127 8203
payment from customer: creation 61.75 138 6175
payment from customer: removal 5.39 106 539
payment to supplier: creation 51.76 178 5176
payment to supplier: removal 3.56 126 356
service: total inventory turnovers 5.20 1114 520
service: total monetary turnovers 7.52 33 752
service: aggregate perf. data 0.79 21370 79
service: refresh index statistics 0.03 227815 3

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:03, from 06-04-2024 01:10:53 to 06-04-2024 01:10:56.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 3293
TEST_TIME 2 2487
TEST_TIME 3 2955
TEST_TIME 4 3068
TEST_TIME 5 3366
TEST_TIME 6 3784
TEST_TIME 7 3734
TEST_TIME 8 3808
TEST_TIME 9 4263
TEST_TIME 10 5033
TEST_TIME 11 5783
TEST_TIME 12 5690
TEST_TIME 13 6060
TEST_TIME 14 6156
TEST_TIME 15 6260
TEST_TIME 16 6900
TEST_TIME 17 6908
TEST_TIME 18 7336
TEST_TIME 19 7493
TEST_TIME 20 7483
TEST_TIME 21 7907
TEST_TIME 22 8053
TEST_TIME 23 8032
TEST_TIME 24 8055
TEST_TIME 25 8394
TEST_TIME 26 8314
TEST_TIME 27 8269
TEST_TIME 28 8628
TEST_TIME 29 9486
TEST_TIME 30 9600
TEST_TIME 31 9800
TEST_TIME 32 9682
TEST_TIME 33 9635
TEST_TIME 34 9718
TEST_TIME 35 9850
TEST_TIME 36 9702
TEST_TIME 37 9581
TEST_TIME 38 9908
TEST_TIME 39 9749
TEST_TIME 40 9642
TEST_TIME 41 9562
TEST_TIME 42 9658
TEST_TIME 43 9548
TEST_TIME 44 9567
TEST_TIME 45 9491
TEST_TIME 46 9530
TEST_TIME 47 9570
TEST_TIME 48 9535
TEST_TIME 49 9583
TEST_TIME 50 9527
TEST_TIME 51 9420
TEST_TIME 52 9384
TEST_TIME 53 9401
TEST_TIME 54 9274
TEST_TIME 55 9301
TEST_TIME 56 9290
TEST_TIME 57 9264
TEST_TIME 58 9272
TEST_TIME 59 9253
TEST_TIME 60 9261
TEST_TIME 61 9288
TEST_TIME 62 9335
TEST_TIME 63 9449
TEST_TIME 64 9464
TEST_TIME 65 9464
TEST_TIME 66 9562
TEST_TIME 67 9608
TEST_TIME 68 9595
TEST_TIME 69 9632
TEST_TIME 70 9633
TEST_TIME 71 9598
TEST_TIME 72 9505
TEST_TIME 73 9494
TEST_TIME 74 9463
TEST_TIME 75 9447
TEST_TIME 76 9390
TEST_TIME 77 9344
TEST_TIME 78 9319
TEST_TIME 79 9299
TEST_TIME 80 9298
TEST_TIME 81 9300
TEST_TIME 82 9285
TEST_TIME 83 9259
TEST_TIME 84 9350
TEST_TIME 85 9425
TEST_TIME 86 9415
TEST_TIME 87 9501
TEST_TIME 88 9457
TEST_TIME 89 9474
TEST_TIME 90 9543
TEST_TIME 91 9543
TEST_TIME 92 9504
TEST_TIME 93 9414
TEST_TIME 94 9370
TEST_TIME 95 9405
TEST_TIME 96 9367
TEST_TIME 97 9340
TEST_TIME 98 9285
TEST_TIME 99 9378
TEST_TIME 100 9331

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:03, from 06-04-2024 01:10:57 to 06-04-2024 01:11:00.

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 1308109 1308109 0 0.00 0 23308 7 0 0
doc_list_biud 1308109 1308109 0 0.00 0 62914 28 0 0
sp_add_invoice_to_stock 4411 4256 155 3.51 53 240948 21800 0 155
sp_cancel_adding_invoice 4548 4548 0 0.00 4 107335 911 0 0
sp_cancel_client_order 1540 1540 0 0.00 4 7190 365 0 0
sp_cancel_customer_reserve 447063 447063 0 0.00 0 31385 64 0 0
sp_cancel_pay_from_customer 539 539 0 0.00 2 4469 106 0 0
sp_cancel_pay_to_supplier 356 356 0 0.00 3 6491 126 0 0
sp_cancel_supplier_invoice 5086 5076 10 0.19 1 62924 807 0 10
sp_cancel_supplier_order 342 342 0 0.00 6 883073 106896 0 0
sp_cancel_write_off 8203 8203 0 0.00 1 11474 127 0 0
sp_client_order 17992 17992 0 0.00 3 18156 355 0 0
sp_customer_reserve 411759 411759 0 0.00 0 52108 208 0 0
sp_fill_shopping_cart 27499 27499 0 0.00 1 16275 38 0 0
sp_fill_shopping_cart_clo_res 411755 411755 0 0.00 0 32232 16 0 0
sp_get_clo_for_invoice 4252 4252 0 0.00 0 37816 285 0 0
sp_kill_cost_storno 13646 13646 0 0.00 0 11049 75 0 0
sp_kill_qstorno_ret_qs2qd 907747 907747 0 0.00 0 62910 34 0 0
sp_kill_qty_storno 479660 479660 0 0.00 0 62913 75 0 0
sp_lock_selected_doc 17833 17833 0 0.00 0 8989 5 0 0
sp_make_cost_storno 24239 24239 0 0.00 0 23004 67 0 0
sp_multiply_rows_for_pdistr 24239 24239 0 0.00 0 22784 42 0 0
sp_multiply_rows_for_qdistr 17992 17992 0 0.00 0 10163 163 0 0
sp_pay_from_customer 6175 6175 0 0.00 4 23286 138 0 0
sp_pay_to_supplier 5176 5176 0 0.00 5 15764 178 0 0
sp_payment_common 11351 11351 0 0.00 1 20248 38 0 0
sp_qd_handle_on_cancel_clo 1540 1540 0 0.00 0 7184 325 0 0
sp_qd_handle_on_invoice_upd_sts 8800 8800 0 0.00 0 24106 349 0 0
sp_qd_handle_on_reserve_upd_sts 8636 8636 0 0.00 0 21322 68 0 0
sp_reserve_write_off 8636 8636 0 0.00 6 23439 215 0 0
sp_supplier_invoice 4656 4656 0 0.00 7 91443 3487 0 0
sp_supplier_order 4854 4854 0 0.00 5 47481 1408 0 0
srv_aggregate_perf_data 80 79 1 1.25 1558 304928 21370 0 1
srv_fill_mon_cache_memory 57 57 0 0.00 1314 115276 37181 0 0
srv_find_qd_qs_mism 887765 887765 0 0.00 0 7448 6 0 0
srv_make_invnt_saldo 520 520 0 0.00 41 42657 1114 0 0
srv_make_money_saldo 752 752 0 0.00 1 1327 33 0 0
srv_recalc_idx_stat 3 3 0 0.00 160389 283537 227816 0 0
t$perf-abend:sp_add_invoice_to_stock 155 155 0 0.00 0 0 0 0 0
t$perf-abend:sp_cancel_supplier_invoice 10 10 0 0.00 0 0 0 0 0
t$perf-abend:srv_aggregate_perf_data 1 1 0 0.00 0 0 0 0 0
t$perf-norm:sp_add_invoice_to_stock 4256 4256 0 0.00 0 10962 199 0 0
t$perf-norm:sp_cancel_adding_invoice 342 342 0 0.00 1 11160 167 0 0
t$perf-norm:sp_cancel_client_order 1540 1540 0 0.00 0 3003 16 0 0
t$perf-norm:sp_cancel_customer_reserve 620 620 0 0.00 0 909 10 0 0
t$perf-norm:sp_cancel_pay_from_customer 539 539 0 0.00 0 5259 12 0 0
t$perf-norm:sp_cancel_pay_to_supplier 356 356 0 0.00 0 1076 10 0 0
t$perf-norm:sp_cancel_supplier_invoice 353 353 0 0.00 0 432 10 0 0
t$perf-norm:sp_cancel_supplier_order 342 342 0 0.00 0 26208 2099 0 0
t$perf-norm:sp_cancel_write_off 853 853 0 0.00 0 1134 7 0 0
t$perf-norm:sp_client_order 17992 17992 0 0.00 0 4780 18 0 0
t$perf-norm:sp_customer_reserve 860 860 0 0.00 0 870 9 0 0
t$perf-norm:sp_pay_from_customer 6175 6175 0 0.00 0 8493 13 0 0
t$perf-norm:sp_pay_to_supplier 5176 5176 0 0.00 0 5406 12 0 0
t$perf-norm:sp_reserve_write_off 8636 8636 0 0.00 0 10844 15 0 0
t$perf-norm:sp_supplier_invoice 4656 4656 0 0.00 0 4215 23 0 0
t$perf-norm:sp_supplier_order 4854 4854 0 0.00 0 3720 17 0 0
t$perf-norm:srv_aggregate_perf_data 79 79 0 0.00 0 394 18 0 0
t$perf-norm:srv_fill_mon_cache_memory 57 57 0 0.00 0 159 9 0 0
t$perf-norm:srv_make_invnt_saldo 520 520 0 0.00 0 641 26 0 0
t$perf-norm:srv_make_money_saldo 752 752 0 0.00 0 5167 30 0 0
t$perf-norm:srv_recalc_idx_stat 3 3 0 0.00 3 14 7 0 0
v_add_invoice_to_stock 8814 8504 310 3.51 0 4622 19 0 310
v_all_customers 33442 33442 0 0.00 0 23 1 0 0
v_all_suppliers 27428 27428 0 0.00 0 22 1 0 0
v_all_wares 35982 35982 0 0.00 0 31 1 0 0
v_cancel_adding_invoice 684 684 0 0.00 0 4776 14 0 0
v_cancel_client_order 3080 3080 0 0.00 0 4270 8 0 0
v_cancel_customer_prepayment 1078 1078 0 0.00 0 4465 8 0 0
v_cancel_customer_reserve 1240 1240 0 0.00 0 3234 14 0 0
v_cancel_payment_to_supplier 712 712 0 0.00 0 2108 11 0 0
v_cancel_supplier_invoice 726 706 20 2.75 0 2541 18 0 20
v_cancel_supplier_order 684 684 0 0.00 0 4390 16 0 0
v_cancel_write_off 1706 1706 0 0.00 0 5162 19 0 0
v_max_id_clo_ord 4853 4853 0 0.00 0 4063 4 0 0
v_max_id_clo_res 860 860 0 0.00 0 1764 10 0 0
v_max_id_ord_sup 4654 4654 0 0.00 0 8301 6 0 0
v_max_non_paid_invoice 969 969 0 0.00 0 1010 4 0 0
v_max_non_paid_realizn 2974 2974 0 0.00 0 1470 4 0 0
v_min_id_clo_ord 4853 4853 0 0.00 0 2790 9 0 0
v_min_id_clo_res 860 860 0 0.00 0 814 3 0 0
v_min_id_ord_sup 4654 4654 0 0.00 0 6109 4 0 0
v_min_non_paid_invoice 5176 5176 0 0.00 0 15721 26 0 0
v_min_non_paid_realizn 6175 6175 0 0.00 0 20240 33 0 0
v_our_firm 8942 8942 0 0.00 0 86 1 0 0
v_reserve_write_off 17272 17272 0 0.00 0 6717 7 0 0
x_lock_depdocs_on_canc_invoice 9271 9271 0 0.00 0 14546 154 0 0
x_lock_depdocs_on_canc_sup_ord 342 342 0 0.00 0 7432 379 0 0
x_make_qstorno_1000_1200 4854 4854 0 0.00 1 47469 1307 0 0
x_make_qstorno_1200_2000 4656 4656 0 0.00 3 90288 3363 0 0
x_make_qstorno_2100_3300 411759 411759 0 0.00 0 52107 189 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 06-04-2024 01:11:01 to 06-04-2024 01:11:05.

Memory consumption, metadata cache, attachments activity 

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


Page cache type: shared, buffers: 1000000 for all connections, with total size: 8192000000
measurement_dts measurement duration ms page cache memo used memo used, total memo allocated, total metadata cache metadata cache percent of total total attachments cnt active attachments cnt running statements cnt stalled statements cnt memo used by attachments memo used by transactions memo used by statements
23:09:47 6 8192000000 8799009520 8810369024 5304288 0.064 2 1 2 0 5403888 56816 42784
23:10:48 24667 8192000000 9902220304 10211758080 978825344 10.673 100 91 182 0 1012674608 10261568 23587696
23:12:16 25108 8192000000 9941208688 10262781952 1025483168 11.125 100 90 180 0 1056433024 7994496 22955360
23:13:46 15212 8192000000 9978171344 10312814592 1067103888 11.524 100 81 162 0 1096700640 9468480 20128272
23:15:09 10609 8192000000 10041137712 10384195584 1120008816 12.027 100 88 176 0 1151970896 10859616 21102464
23:16:26 8657 8192000000 10071521312 10427760640 1157609136 12.381 100 79 159 0 1188311280 12566416 18135728
23:17:36 2434 8192000000 10115900336 10484457472 1204930400 12.822 100 77 152 0 1234600368 12539136 17130832
23:18:41 1496 8192000000 10156172976 10529603584 1242095072 13.166 100 91 179 0 1277066480 15268384 19703024
23:19:46 1723 8192000000 10176203344 10552819712 1264572320 13.372 100 87 174 0 1297392064 13697728 19122016
23:20:50 1191 8192000000 10199899168 10585817088 1287146576 13.578 100 88 175 2 1319190496 12534576 19509344
23:21:53 1120 8192000000 10217702288 10604199936 1303540448 13.727 100 85 165 0 1333668768 12081344 18046976
23:22:56 6034 8192000000 10203453088 10607759360 1306144528 13.751 100 44 89 1 1323496096 7465792 9885776
23:24:03 6071 8192000000 10198998320 10615042048 1314580192 13.828 100 19 36 0 1328639024 9923488 4135344
23:25:09 9738 8192000000 10203788320 10620264448 1317425120 13.853 100 22 44 1 1327956640 5567168 4964352
23:26:21 47537 8192000000 10222242064 10640437248 1325952800 13.931 100 23 46 0 1336308320 4689664 5665856
23:28:09 4202 8192000000 10228244320 10648227840 1332591456 13.991 100 40 81 0 1349585216 7953568 9040192
23:29:18 8289 8192000000 10217066896 10642173952 1331043984 13.977 100 15 28 0 1339636288 5452800 3139504
23:30:33 12388 8192000000 10240012064 10653196288 1332809728 13.993 100 34 68 1 1349478384 8248784 8419872
23:31:54 65391 8192000000 10251572720 10657710080 1307533760 13.764 97 43 86 1 1330245344 12305088 10406496
23:34:04 81047 8192000000 10227766064 10644262912 1296092720 13.660 97 35 69 1 1319087184 15319616 7674848
23:36:34 26481 8192000000 10236885200 10646241280 1283309936 13.543 96 38 76 1 1313190800 20894064 8986800
23:38:08 25229 8192000000 10241479552 10655928320 1317574944 13.855 99 50 98 0 1348868608 19772496 11521168
23:39:39 10911 8192000000 10247202752 10649563136 1307664048 13.765 98 55 107 1 1339394912 19523728 12207136
23:41:02 5574 8192000000 10231181744 10629566464 1304570992 13.737 99 53 104 2 1330255792 14287792 11397008
23:42:11 1313 8192000000 10220199792 10597072896 1283135856 13.542 98 85 170 0 1319476000 16275392 20064752
23:43:17 1766 8192000000 10264626672 10660016128 1327769712 13.947 100 80 160 1 1367565856 21545536 18250608
23:44:22 7511 8192000000 10255589344 10647322624 1297676288 13.674 98 80 158 0 1344434176 27323968 19433920
23:45:36 2622 8192000000 10288315824 10685726720 1340500288 14.062 100 90 179 1 1395046960 32582912 21963760
23:46:42 1502 8192000000 10304630976 10702483456 1354934864 14.192 100 89 177 1 1410549008 34697472 20916672
23:47:52 2101 8192000000 10317419056 10718126080 1365393216 14.286 100 78 151 2 1418218736 34512208 18313312
23:49:06 9402 8192000000 10317559712 10722934784 1363805760 14.272 99 72 142 0 1410799520 29823344 17170416
23:50:23 2547 8192000000 10335621904 10740744192 1385307728 14.464 100 85 168 3 1440647552 33642720 21697104
23:51:29 5552 8192000000 10317443840 10745364480 1389552624 14.502 100 37 73 1 1424751232 25936160 9262448
23:52:41 11613 8192000000 10330031296 10754936832 1392944624 14.532 100 41 78 0 1435870464 32919824 10006016
23:54:03 4397 8192000000 10359189440 10782310400 1406652384 14.654 100 63 125 1 1464178432 41941808 15584240
23:55:32 15422 8192000000 10341270672 10774876160 1399470528 14.590 100 34 68 0 1450114528 41786448 8857552
23:56:55 12627 8192000000 10342825680 10780516352 1395353552 14.554 100 22 45 0 1449289072 47542384 6393136
23:58:11 31993 8192000000 10319592960 10768216064 1381900448 14.434 100 15 29 2 1428180160 41658416 4621296
23:59:49 39567 8192000000 10297058032 10751918080 1381885568 14.433 100 18 36 0 1402850992 16668304 4297120
00:01:46 44692 8192000000 10301576608 10760728576 1394680352 14.548 100 23 46 0 1412423936 12933760 4809824
00:03:41 57073 8192000000 10311834016 10766917632 1397654432 14.574 100 20 39 1 1416626336 14578624 4393280
00:05:50 42582 8192000000 10342448944 10784141312 1414123488 14.721 100 29 59 0 1436393824 15860480 6409856
00:07:41 89656 8192000000 10305584272 10756329472 1384600256 14.458 98 20 41 0 1404013808 15176288 4237264
00:10:25 8138 8192000000 10319117984 10763862016 1397309968 14.571 99 52 99 3 1419810864 10618352 11882544
00:11:36 34748 8192000000 10314333696 10777088000 1400296624 14.598 99 18 32 1 1413141184 9220816 3623744
00:13:12 3056 8192000000 10302052768 10745925632 1389113056 14.498 99 27 52 0 1403877392 8952928 5811408
00:14:17 15960 8192000000 10323445776 10765979648 1394977952 14.550 99 37 73 0 1412916384 8967408 8971024
00:15:35 23363 8192000000 10317575360 10779582464 1411678608 14.699 100 30 60 1 1437486800 18538960 7269232
00:17:00 44076 8192000000 10303625872 10764836864 1392727440 14.530 99 22 42 1 1413528896 15706256 5095200
00:18:46 58022 8192000000 10296251008 10741297152 1351024832 14.157 97 17 32 0 1362322224 7712064 3585328
00:20:45 73738 8192000000 10279927952 10737692672 1369740320 14.325 99 16 32 0 1382907440 9493568 3673552
00:23:00 58665 8192000000 10282387520 10726531072 1345412368 14.106 97 24 48 0 1364231712 13831168 4988176
00:27:12 40763 8192000000 10251494832 10703425536 1283318400 13.543 93 8 16 0 1296257296 11094240 1844656
00:28:59 12889 8192000000 10257481824 10687385600 1323894768 13.912 98 46 92 0 1349176336 15369968 9911600
00:30:16 34091 8192000000 10276415072 10715975680 1364052944 14.274 100 34 68 0 1383514032 11908784 7552304
00:31:54 34655 8192000000 10252623856 10693545984 1310933312 13.795 97 24 48 0 1325349824 9019536 5396976
00:33:29 37743 8192000000 10247776544 10695254016 1303151744 13.724 96 21 42 0 1316241296 8646128 4443424
00:35:08 70544 8192000000 10274703104 10724823040 1353581520 14.180 99 24 48 0 1372121136 12926400 5613216
00:37:24 61099 8192000000 10274953152 10716000256 1336453600 14.025 98 21 40 0 1350220208 8718576 5048032
00:39:26 41892 8192000000 10289577424 10731823104 1372625968 14.351 100 14 28 0 1388973968 13716304 2631696
00:41:20 79302 8192000000 10291443968 10731667456 1367463488 14.304 99 29 60 0 1383908640 9709808 6735344
00:43:40 21180 8192000000 10281203616 10734964736 1380127472 14.418 100 39 79 0 1398767024 9967968 8671584
00:45:08 31439 8192000000 10284319984 10748039168 1385981616 14.470 100 8 16 0 1398124640 10710912 1432112
00:46:41 78513 8192000000 10287300048 10750533632 1378099872 14.400 99 5 10 0 1386734448 7620848 1013728
00:49:09 49199 8192000000 10291373904 10749419520 1373005376 14.354 98 20 38 0 1389049056 11316032 4727648
00:51:01 69283 8192000000 10299714112 10754510848 1378671360 14.405 98 20 40 0 1402217184 18323520 5222304
00:53:36 81380 8192000000 10303386736 10776330240 1380356016 14.420 99 19 38 0 1407600272 23090560 4153696
00:55:58 67828 8192000000 10277208096 10738548736 1334491536 14.008 96 7 14 0 1348310048 12488432 1330080
00:58:06 38281 8192000000 10304084016 10749681664 1357735040 14.217 98 27 54 0 1374706528 11185440 5786048
00:59:47 56285 8192000000 10296528496 10747469824 1367188464 14.302 98 15 30 0 1380957424 10446704 3322256
01:01:45 115276 8192000000 10300558592 10762457088 1376770912 14.388 98 29 58 0 1398163552 14707488 6685152
01:04:52 58556 8192000000 10264662544 10724515840 1334256592 14.006 96 17 34 0 1345814688 7765792 3792304
01:06:51 93420 8192000000 10284779120 10748637184 1355908608 14.201 97 17 32 1 1371104400 11672752 3523040
01:09:30 14828 8192000000 9580006688 9916096512 712240256 7.998 52 13 27 0 725049392 9812624 2996512

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:14, from 06-04-2024 01:11:07 to 06-04-2024 01:11:21.

Exceptions occured during test was in run

FB_MNEMONA CNT UNIT FB_GDSCODE
except 1 srv_aggregate_perf_data 335544517
except 155 v_add_invoice_to_stock 335544517
except 10 v_cancel_supplier_invoice 335544517

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

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          177233
MON$OLDEST_ACTIVE               177234
MON$OLDEST_SNAPSHOT             177234
MON$NEXT_TRANSACTION            177234
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                       1917920
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 Sat Apr  6 01:11:25 2024 
 
Database header page information: 
    Flags            0 
    Generation        92445 
    System Change Number    0 
    Page size        8192 
    ODS version        12.0 
    Oldest transaction    177233 
    Oldest active        177234 
    Oldest snapshot        177234 
    Next transaction    177235 
    Sequence number        0 
    Next attachment ID    712 
    Implementation        HW=AMD/Intel/x64 little-endian OS=Linux CC=gcc 
    Shadow count        0 
    Page buffers        0 
    Next header page    0 
    Database dialect    3 
    Creation date        Apr 3, 2020 16:41:55 
    Attributes        force write 
 
    Variable header data: 
    Sweep interval:        0 
    Unrecognized option 11, length 16 
    *END* 
 
 
Database file sequence: 
File /home/bases/oltp30-etalone.fdb is the only file 
 
Analyzing database pages ... 
AGENTS (150) 
    Primary pointer page: 496, Index root page: 497 
    Total formats: 1, used formats: 1 
    Average record length: 33.60, total records: 50 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 344.00, compression ratio: 10.24 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 31% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 1 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index AGENTS_ID_DESC (2) 
    Root page: 1504311, depth: 1, leaf buckets: 1, nodes: 50 
    Average node length: 11.82, total dup: 0, max dup: 0 
    Average key length: 10.80, compression ratio: 0.83 
    Average prefix length: 1.18, average data length: 7.82 
    Clustering factor: 1, ratio: 0.02 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index AGENTS_IS_OUR_FIRM (4) 
    Root page: 1504313, depth: 1, leaf buckets: 1, nodes: 50 
    Average node length: 3.08, total dup: 48, max dup: 48 
    Average key length: 2.04, compression ratio: 0.50 
    Average prefix length: 0.96, average data length: 0.06 
    Clustering factor: 1, ratio: 0.02 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index AGENTS_IS_SUPPLIER (3) 
    Root page: 1504312, depth: 1, leaf buckets: 1, nodes: 50 
    Average node length: 3.08, total dup: 48, max dup: 44 
    Average key length: 2.04, compression ratio: 0.54 
    Average prefix length: 1.04, average data length: 0.06 
    Clustering factor: 1, ratio: 0.02 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index AGENTS_NAME_UNQ (1) 
    Root page: 1504310, depth: 1, leaf buckets: 1, nodes: 50 
    Average node length: 17.20, total dup: 0, max dup: 0 
    Average key length: 15.88, compression ratio: 0.92 
    Average prefix length: 1.42, average data length: 13.20 
    Clustering factor: 1, ratio: 0.02 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PK_AGENTS (0) 
    Root page: 1504309, depth: 1, leaf buckets: 1, nodes: 50 
    Average node length: 11.82, total dup: 0, max dup: 0 
    Average key length: 10.80, compression ratio: 0.83 
    Average prefix length: 1.18, average data length: 7.82 
    Clustering factor: 1, ratio: 0.02 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
BUSINESS_OPS (154) 
    Primary pointer page: 504, Index root page: 505 
    Total formats: 1, used formats: 1 
    Average record length: 108.20, total records: 20 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1235.00, compression ratio: 11.41 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 31% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 1 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index BO_UNIT_UNQ (1) 
    Root page: 1504242, depth: 1, leaf buckets: 1, nodes: 20 
    Average node length: 18.25, total dup: 0, max dup: 0 
    Average key length: 17.20, compression ratio: 1.24 
    Average prefix length: 7.05, average data length: 14.25 
    Clustering factor: 1, ratio: 0.05 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index BUSINESS_OPS_PREDICT_PRIOR (3) 
    Root page: 1504244, depth: 1, leaf buckets: 1, nodes: 20 
    Average node length: 5.40, total dup: 0, max dup: 0 
    Average key length: 4.35, compression ratio: 0.67 
    Average prefix length: 1.20, average data length: 1.70 
    Clustering factor: 1, ratio: 0.05 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index BUSINESS_OPS_RND_WGTH (2) 
    Root page: 1504243, depth: 1, leaf buckets: 1, nodes: 20 
    Average node length: 4.30, total dup: 6, max dup: 3 
    Average key length: 3.25, compression ratio: 0.72 
    Average prefix length: 1.35, average data length: 1.00 
    Clustering factor: 1, ratio: 0.05 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index RDB$1 (0) 
    Root page: 1504241, depth: 1, leaf buckets: 1, nodes: 20 
    Average node length: 5.20, total dup: 0, max dup: 0 
    Average key length: 4.15, compression ratio: 0.65 
    Average prefix length: 1.10, average data length: 1.60 
    Clustering factor: 1, ratio: 0.05 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
DOC_DATA (139) 
    Primary pointer page: 474, Index root page: 475 
    Total formats: 1, used formats: 1 
    Average record length: 47.39, total records: 7752178 
    Average version length: 48.16, total versions: 81225, 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: 87256 
    Data pages: 87256, average fill: 71% 
    Primary pages: 87256, secondary pages: 0, swept pages: 26081 
    Empty pages: 6, full pages: 58027 
    Fill distribution: 
     0 - 19% = 17 
    20 - 39% = 243 
    40 - 59% = 3624 
    60 - 79% = 83353 
    80 - 99% = 19 
 
    Index DOC_DATA_DOC_WARE_UNQ (0) 
    Root page: 1510614, depth: 3, leaf buckets: 23386, nodes: 7752178 
    Average node length: 18.88, total dup: 0, max dup: 0 
    Average key length: 15.89, compression ratio: 1.70 
    Average prefix length: 14.10, average data length: 12.90 
    Clustering factor: 1711400, ratio: 0.22 
    Fill distribution: 
         0 - 19% = 320 
        20 - 39% = 1830 
        40 - 59% = 4233 
        60 - 79% = 2623 
        80 - 99% = 14380 
 
    Index DOC_DATA_ID_DESC (1) 
    Root page: 1528118, depth: 3, leaf buckets: 13583, nodes: 7752178 
    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: 1533630, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 1642 
        40 - 59% = 2035 
        60 - 79% = 1208 
        80 - 99% = 8698 
 
    Index FK_DOC_DATA_DOC_LIST (2) 
    Root page: 1546711, depth: 3, leaf buckets: 8376, nodes: 7752178 
    Average node length: 6.61, total dup: 5800463, max dup: 49 
    Average key length: 3.63, compression ratio: 2.48 
    Average prefix length: 7.62, average data length: 1.38 
    Clustering factor: 1526748, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 117 
        20 - 39% = 975 
        40 - 59% = 1431 
        60 - 79% = 1008 
        80 - 99% = 4845 
 
DOC_LIST (138) 
    Primary pointer page: 472, Index root page: 473 
    Total formats: 1, used formats: 1 
    Average record length: 56.36, total records: 2243716 
    Average version length: 34.71, total versions: 81290, max versions: 4 
    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: 28560 
    Data pages: 28560, average fill: 73% 
    Primary pages: 28552, secondary pages: 8, swept pages: 11687 
    Empty pages: 7, full pages: 19782 
    Fill distribution: 
     0 - 19% = 28 
    20 - 39% = 119 
    40 - 59% = 2055 
    60 - 79% = 25808 
    80 - 99% = 550 
 
    Index DOC_LIST_ID_DESC (1) 
    Root page: 1541130, depth: 3, leaf buckets: 4589, nodes: 2243716 
    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: 694981, ratio: 0.31 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 909 
        40 - 59% = 910 
        60 - 79% = 775 
        80 - 99% = 1995 
 
    Index DOC_LIST_WORKER_OPTYPE (2) 
    Root page: 1544376, depth: 3, leaf buckets: 2530, nodes: 2246307 
    Average node length: 4.97, total dup: 2245408, max dup: 17598 
    Average key length: 2.01, compression ratio: 4.47 
    Average prefix length: 8.99, average data length: 0.01 
    Clustering factor: 1248756, ratio: 0.56 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 268 
        40 - 59% = 1563 
        60 - 79% = 524 
        80 - 99% = 174 
 
    Index FK_DOC_LIST_AGENTS (3) 
    Root page: 1545909, depth: 3, leaf buckets: 2071, nodes: 2243716 
    Average node length: 4.97, total dup: 2243666, max dup: 130498 
    Average key length: 2.01, compression ratio: 4.48 
    Average prefix length: 8.99, average data length: 0.01 
    Clustering factor: 1062055, ratio: 0.47 
    Fill distribution: 
         0 - 19% = 5 
        20 - 39% = 99 
        40 - 59% = 1109 
        60 - 79% = 48 
        80 - 99% = 810 
 
    Index PK_DOC_LIST (0) 
    Root page: 1538187, depth: 3, leaf buckets: 4353, nodes: 2243716 
    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: 694981, ratio: 0.31 
    Fill distribution: 
         0 - 19% = 88 
        20 - 39% = 580 
        40 - 59% = 644 
        60 - 79% = 886 
        80 - 99% = 2155 
 
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.42, total records: 400 
    Average version length: 22.62, total versions: 255563, max versions: 662 
    Average fragment length: 2.04, total fragments: 50, max fragments: 1 
    Average unpacked length: 104.00, compression ratio: 1.26 
    Pointer pages: 1, data page slots: 1456 
    Data pages: 1400, average fill: 90% 
    Primary pages: 9, secondary pages: 1391, swept pages: 0 
    Empty pages: 2, full pages: 1397 
    Fill distribution: 
     0 - 19% = 2 
    20 - 39% = 1 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 1397 
 
    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: 2.41, total records: 98924 
    Average version length: 68.30, total versions: 95436, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 88.00, compression ratio: 36.54 
    Pointer pages: 7, data page slots: 2736 
    Data pages: 1975, average fill: 63% 
    Primary pages: 1974, secondary pages: 1, swept pages: 0 
    Empty pages: 303, full pages: 1116 
    Fill distribution: 
     0 - 19% = 391 
    20 - 39% = 163 
    40 - 59% = 181 
    60 - 79% = 180 
    80 - 99% = 1060 
 
    Index INVNT_TURNOVER_LOG_WARE_DD_ID (0) 
    Root page: 1699568, depth: 3, leaf buckets: 399, nodes: 98924 
    Average node length: 13.49, total dup: 7172, max dup: 3 
    Average key length: 10.69, compression ratio: 2.53 
    Average prefix length: 19.23, average data length: 7.77 
    Clustering factor: 71463, ratio: 0.72 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 175 
        40 - 59% = 212 
        60 - 79% = 10 
        80 - 99% = 0 
 
MONEY_SALDO (141) 
    Primary pointer page: 478, Index root page: 479 
    Total formats: 1, used formats: 1 
    Average record length: 15.24, total records: 49 
    Average version length: 9.00, total versions: 18853, max versions: 1025 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 32.00, compression ratio: 2.10 
    Pointer pages: 1, data page slots: 72 
    Data pages: 72, average fill: 84% 
    Primary pages: 7, secondary pages: 65, swept pages: 0 
    Empty pages: 6, full pages: 65 
    Fill distribution: 
     0 - 19% = 6 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 3 
    80 - 99% = 63 
 
    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: 0.89, total records: 1599 
    Average version length: 43.51, total versions: 1566, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 58.00, compression ratio: 64.85 
    Pointer pages: 1, data page slots: 32 
    Data pages: 32, average fill: 50% 
    Primary pages: 31, secondary pages: 1, swept pages: 4 
    Empty pages: 5, full pages: 9 
    Fill distribution: 
     0 - 19% = 10 
    20 - 39% = 2 
    40 - 59% = 6 
    60 - 79% = 5 
    80 - 99% = 9 
 
    Index MONEY_TURNOVER_LOG_AGENT_OPTYPE (0) 
    Root page: 93137, depth: 2, leaf buckets: 5, nodes: 1599 
    Average node length: 4.41, total dup: 1501, max dup: 163 
    Average key length: 2.67, compression ratio: 7.11 
    Average prefix length: 18.39, average data length: 0.61 
    Clustering factor: 879, ratio: 0.55 
    Fill distribution: 
         0 - 19% = 3 
        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.09, total records: 74 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 112.00, compression ratio: 1.15 
    Pointer pages: 1, data page slots: 2 
    Data pages: 2, average fill: 52% 
    Primary pages: 2, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 1 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 1 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 1 
 
    Index PK_MON_CACHE_MEMORY (0) 
    Root page: 1504215, depth: 1, leaf buckets: 1, nodes: 74 
    Average node length: 11.69, total dup: 0, max dup: 0 
    Average key length: 10.68, compression ratio: 0.84 
    Average prefix length: 1.31, average data length: 7.69 
    Clustering factor: 2, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
MON_LOG (162) 
    Primary pointer page: 520, Index root page: 521 
    Total formats: 2, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index MON_LOG_DTS (4) 
    Root page: 1504229, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index MON_LOG_GDSCODE (2) 
    Root page: 1504227, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index MON_LOG_ROWSET_DESC (1) 
    Root page: 1504226, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index MON_LOG_UNIT (3) 
    Root page: 1504228, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PK_MON_LOG (0) 
    Root page: 1504225, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
MON_LOG_TABLE_STATS (163) 
    Primary pointer page: 522, Index root page: 523 
    Total formats: 2, used formats: 1 
    Average record length: 67.13, total records: 30 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 611.00, compression ratio: 9.10 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 31% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 1 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index MON_LOG_TABLE_STATS_DTS (4) 
    Root page: 1504224, depth: 1, leaf buckets: 1, nodes: 30 
    Average node length: 3.50, total dup: 23, max dup: 4 
    Average key length: 2.47, compression ratio: 3.24 
    Average prefix length: 7.53, average data length: 0.47 
    Clustering factor: 1, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index MON_LOG_TABLE_STATS_GDSCODE (2) 
    Root page: 1504222, depth: 1, leaf buckets: 1, nodes: 30 
    Average node length: 2.00, total dup: 29, max dup: 29 
    Average key length: 1.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 1, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index MON_LOG_TABLE_STATS_ROWSET (1) 
    Root page: 1504221, depth: 1, leaf buckets: 1, nodes: 30 
    Average node length: 3.33, total dup: 29, max dup: 29 
    Average key length: 2.30, compression ratio: 3.91 
    Average prefix length: 8.70, average data length: 0.30 
    Clustering factor: 1, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index MON_LOG_TABLE_STATS_TN_UNIT (3) 
    Root page: 1504223, depth: 1, leaf buckets: 1, nodes: 30 
    Average node length: 12.90, total dup: 0, max dup: 0 
    Average key length: 11.87, compression ratio: 1.42 
    Average prefix length: 7.63, average data length: 9.20 
    Clustering factor: 1, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PK_MON_LOG_TABLE_STATS (0) 
    Root page: 1504220, depth: 1, leaf buckets: 1, nodes: 30 
    Average node length: 8.37, total dup: 0, max dup: 0 
    Average key length: 7.33, compression ratio: 1.23 
    Average prefix length: 4.63, average data length: 4.37 
    Clustering factor: 1, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
OPTYPES (136) 
    Primary pointer page: 468, Index root page: 469 
    Total formats: 2, used formats: 1 
    Average record length: 67.56, total records: 9 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 386.00, compression ratio: 5.71 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 9% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index OPTYPES_MCODE_UNQ (1) 
    Root page: 1544805, depth: 1, leaf buckets: 1, nodes: 9 
    Average node length: 8.56, total dup: 0, max dup: 0 
    Average key length: 6.89, compression ratio: 0.73 
    Average prefix length: 0.44, average data length: 4.56 
    Clustering factor: 1, ratio: 0.11 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PK_OPTYPES (0) 
    Root page: 1544804, depth: 1, leaf buckets: 1, nodes: 9 
    Average node length: 6.11, total dup: 0, max dup: 0 
    Average key length: 5.00, compression ratio: 0.60 
    Average prefix length: 0.89, average data length: 2.11 
    Clustering factor: 1, ratio: 0.11 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
PDISTR (146) 
    Primary pointer page: 488, Index root page: 489 
    Total formats: 1, used formats: 1 
    Average record length: 35.88, total records: 812882 
    Average version length: 25.58, total versions: 76812, max versions: 4 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 54.00, compression ratio: 1.51 
    Pointer pages: 6, data page slots: 8264 
    Data pages: 8256, average fill: 69% 
    Primary pages: 8217, secondary pages: 39, swept pages: 1831 
    Empty pages: 75, full pages: 6613 
    Fill distribution: 
     0 - 19% = 146 
    20 - 39% = 153 
    40 - 59% = 314 
    60 - 79% = 7357 
    80 - 99% = 286 
 
    Index PDISTR_AGENT_ID (2) 
    Root page: 1509308, depth: 2, leaf buckets: 915, nodes: 812882 
    Average node length: 4.87, total dup: 812833, max dup: 155461 
    Average key length: 2.01, compression ratio: 4.48 
    Average prefix length: 8.99, average data length: 0.01 
    Clustering factor: 90326, ratio: 0.11 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 147 
        40 - 59% = 515 
        60 - 79% = 209 
        80 - 99% = 42 
 
    Index PDISTR_SNDOP_RCVOP_SNDID_ASC (0) 
    Root page: 1508613, depth: 3, leaf buckets: 1016, nodes: 812882 
    Average node length: 5.88, total dup: 723613, max dup: 42 
    Average key length: 3.02, compression ratio: 7.28 
    Average prefix length: 21.09, average data length: 0.91 
    Clustering factor: 161927, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 124 
        40 - 59% = 538 
        60 - 79% = 114 
        80 - 99% = 238 
 
    Index PDISTR_SNDOP_RCVOP_SNDID_DESC (1) 
    Root page: 1509187, depth: 3, leaf buckets: 1062, nodes: 812882 
    Average node length: 5.88, total dup: 723613, max dup: 42 
    Average key length: 3.02, compression ratio: 7.28 
    Average prefix length: 21.09, average data length: 0.91 
    Clustering factor: 163912, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 230 
        40 - 59% = 497 
        60 - 79% = 105 
        80 - 99% = 230 
 
    Index PDISTR_WORKER_SND_ID (3) 
    Root page: 1510178, depth: 3, leaf buckets: 1150, nodes: 812882 
    Average node length: 5.96, total dup: 723613, max dup: 42 
    Average key length: 3.10, compression ratio: 5.48 
    Average prefix length: 16.01, average data length: 0.99 
    Clustering factor: 156583, ratio: 0.19 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 254 
        40 - 59% = 586 
        60 - 79% = 221 
        80 - 99% = 87 
 
PERF_AGG (158) 
    Primary pointer page: 512, Index root page: 513 
    Total formats: 1, used formats: 1 
    Average record length: 62.84, total records: 5478 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 2.64, total fragments: 95, max fragments: 1 
    Average unpacked length: 379.00, compression ratio: 6.03 
    Pointer pages: 1, data page slots: 88 
    Data pages: 88, average fill: 62% 
    Primary pages: 71, secondary pages: 17, swept pages: 57 
    Empty pages: 4, full pages: 64 
    Fill distribution: 
     0 - 19% = 17 
    20 - 39% = 0 
    40 - 59% = 1 
    60 - 79% = 70 
    80 - 99% = 0 
 
    Index PERF_AGG_UNQ (1) 
    Root page: 1504238, depth: 2, leaf buckets: 6, nodes: 5478 
    Average node length: 5.47, total dup: 0, max dup: 0 
    Average key length: 3.58, compression ratio: 10.05 
    Average prefix length: 34.46, average data length: 1.55 
    Clustering factor: 5102, ratio: 0.93 
    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: 5478 
    Average node length: 11.10, 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: 144, 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.10, total records: 81170 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 48.00, compression ratio: 1.23 
    Pointer pages: 1, data page slots: 784 
    Data pages: 784, average fill: 71% 
    Primary pages: 784, secondary pages: 0, swept pages: 0 
    Empty pages: 2, full pages: 781 
    Fill distribution: 
     0 - 19% = 2 
    20 - 39% = 0 
    40 - 59% = 1 
    60 - 79% = 781 
    80 - 99% = 0 
 
    Index PK_PERF_ESTIMATED (0) 
    Root page: 30176, depth: 2, leaf buckets: 105, nodes: 81170 
    Average node length: 10.18, total dup: 0, max dup: 0 
    Average key length: 8.19, compression ratio: 1.10 
    Average prefix length: 3.81, average data length: 5.19 
    Clustering factor: 3000, ratio: 0.04 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 0 
        40 - 59% = 1 
        60 - 79% = 0 
        80 - 99% = 102 
 
PERF_ISQL_STAT (156) 
    Primary pointer page: 508, Index root page: 509 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index PERF_ISQL_STAT_TRN (0) 
    Root page: 1504239, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
PERF_LOG (159) 
    Primary pointer page: 514, Index root page: 515 
    Total formats: 1, used formats: 1 
    Average record length: 111.11, 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.22 
    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: 139.59, total records: 205926 
    Average version length: 151.46, total versions: 15888, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 12.15 
    Pointer pages: 7, data page slots: 5688 
    Data pages: 4936, average fill: 87% 
    Primary pages: 4935, secondary pages: 1, swept pages: 1 
    Empty pages: 42, full pages: 4880 
    Fill distribution: 
     0 - 19% = 49 
    20 - 39% = 3 
    40 - 59% = 2 
    60 - 79% = 1 
    80 - 99% = 4881 
 
PERF_SPLIT_1 (282) 
    Primary pointer page: 576, Index root page: 577 
    Total formats: 1, used formats: 1 
    Average record length: 137.48, total records: 182678 
    Average version length: 152.04, total versions: 16463, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 12.34 
    Pointer pages: 6, data page slots: 5856 
    Data pages: 4440, average fill: 85% 
    Primary pages: 4440, secondary pages: 0, swept pages: 1 
    Empty pages: 97, full pages: 4321 
    Fill distribution: 
     0 - 19% = 100 
    20 - 39% = 9 
    40 - 59% = 7 
    60 - 79% = 4 
    80 - 99% = 4320 
 
PERF_SPLIT_2 (283) 
    Primary pointer page: 578, Index root page: 579 
    Total formats: 1, used formats: 1 
    Average record length: 104.08, total records: 234576 
    Average version length: 154.35, total versions: 72804, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 16.30 
    Pointer pages: 7, data page slots: 7136 
    Data pages: 5648, average fill: 89% 
    Primary pages: 5647, secondary pages: 1, swept pages: 1 
    Empty pages: 54, full pages: 5585 
    Fill distribution: 
     0 - 19% = 55 
    20 - 39% = 4 
    40 - 59% = 3 
    60 - 79% = 0 
    80 - 99% = 5586 
 
PERF_SPLIT_3 (284) 
    Primary pointer page: 580, Index root page: 581 
    Total formats: 1, used formats: 1 
    Average record length: 138.22, total records: 185698 
    Average version length: 151.46, total versions: 15758, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 12.27 
    Pointer pages: 6, data page slots: 6632 
    Data pages: 4432, average fill: 87% 
    Primary pages: 4432, secondary pages: 0, swept pages: 1 
    Empty pages: 21, full pages: 4393 
    Fill distribution: 
     0 - 19% = 25 
    20 - 39% = 5 
    40 - 59% = 4 
    60 - 79% = 4 
    80 - 99% = 4394 
 
PERF_SPLIT_4 (285) 
    Primary pointer page: 582, Index root page: 583 
    Total formats: 1, used formats: 1 
    Average record length: 113.96, total records: 188454 
    Average version length: 154.27, total versions: 46181, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 14.88 
    Pointer pages: 7, data page slots: 6072 
    Data pages: 4576, average fill: 87% 
    Primary pages: 4576, secondary pages: 0, swept pages: 3 
    Empty pages: 74, full pages: 4476 
    Fill distribution: 
     0 - 19% = 82 
    20 - 39% = 9 
    40 - 59% = 2 
    60 - 79% = 7 
    80 - 99% = 4476 
 
PERF_SPLIT_5 (286) 
    Primary pointer page: 584, Index root page: 585 
    Total formats: 1, used formats: 1 
    Average record length: 139.41, total records: 177156 
    Average version length: 151.88, total versions: 13589, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 12.17 
    Pointer pages: 6, data page slots: 5056 
    Data pages: 4256, average fill: 86% 
    Primary pages: 4256, secondary pages: 0, swept pages: 5 
    Empty pages: 50, full pages: 4194 
    Fill distribution: 
     0 - 19% = 55 
    20 - 39% = 5 
    40 - 59% = 2 
    60 - 79% = 0 
    80 - 99% = 4194 
 
PERF_SPLIT_6 (287) 
    Primary pointer page: 586, Index root page: 587 
    Total formats: 1, used formats: 1 
    Average record length: 131.31, total records: 190464 
    Average version length: 153.57, total versions: 25060, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 12.92 
    Pointer pages: 8, data page slots: 6240 
    Data pages: 4584, average fill: 87% 
    Primary pages: 4584, secondary pages: 0, swept pages: 1 
    Empty pages: 48, full pages: 4513 
    Fill distribution: 
     0 - 19% = 49 
    20 - 39% = 8 
    40 - 59% = 6 
    60 - 79% = 9 
    80 - 99% = 4512 
 
PERF_SPLIT_7 (288) 
    Primary pointer page: 588, Index root page: 589 
    Total formats: 1, used formats: 1 
    Average record length: 123.05, total records: 198217 
    Average version length: 153.91, total versions: 36698, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 13.78 
    Pointer pages: 7, data page slots: 5688 
    Data pages: 4768, average fill: 87% 
    Primary pages: 4768, secondary pages: 0, swept pages: 3 
    Empty pages: 49, full pages: 4702 
    Fill distribution: 
     0 - 19% = 50 
    20 - 39% = 5 
    40 - 59% = 4 
    60 - 79% = 9 
    80 - 99% = 4700 
 
PERF_SPLIT_8 (289) 
    Primary pointer page: 590, Index root page: 591 
    Total formats: 1, used formats: 1 
    Average record length: 135.85, total records: 176693 
    Average version length: 152.99, total versions: 17592, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 12.48 
    Pointer pages: 7, data page slots: 5504 
    Data pages: 4264, average fill: 86% 
    Primary pages: 4263, secondary pages: 1, swept pages: 1 
    Empty pages: 67, full pages: 4185 
    Fill distribution: 
     0 - 19% = 70 
    20 - 39% = 6 
    40 - 59% = 2 
    60 - 79% = 1 
    80 - 99% = 4185 
 
PERF_SPLIT_9 (290) 
    Primary pointer page: 593, Index root page: 594 
    Total formats: 1, used formats: 1 
    Average record length: 134.22, total records: 185301 
    Average version length: 152.41, total versions: 20636, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 12.64 
    Pointer pages: 7, data page slots: 5224 
    Data pages: 4440, average fill: 87% 
    Primary pages: 4440, secondary pages: 0, swept pages: 7 
    Empty pages: 37, full pages: 4389 
    Fill distribution: 
     0 - 19% = 40 
    20 - 39% = 6 
    40 - 59% = 4 
    60 - 79% = 2 
    80 - 99% = 4388 
 
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.90, total records: 2102562 
    Average version length: 52.89, total versions: 33823, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 70.00, compression ratio: 1.35 
    Pointer pages: 16, data page slots: 25480 
    Data pages: 25480, average fill: 71% 
    Primary pages: 25480, secondary pages: 0, swept pages: 11158 
    Empty pages: 282, full pages: 20672 
    Fill distribution: 
     0 - 19% = 523 
    20 - 39% = 429 
    40 - 59% = 1086 
    60 - 79% = 23139 
    80 - 99% = 303 
 
    Index PSTORNED_RCV_ID (1) 
    Root page: 1506186, depth: 3, leaf buckets: 2598, nodes: 2102562 
    Average node length: 5.44, total dup: 1962245, max dup: 1398 
    Average key length: 2.49, compression ratio: 3.62 
    Average prefix length: 8.58, average data length: 0.42 
    Clustering factor: 181831, ratio: 0.09 
    Fill distribution: 
         0 - 19% = 5 
        20 - 39% = 338 
        40 - 59% = 1652 
        60 - 79% = 293 
        80 - 99% = 310 
 
    Index PSTORNED_SND_ID (0) 
    Root page: 1504819, depth: 3, leaf buckets: 2761, nodes: 2102562 
    Average node length: 5.69, total dup: 1887247, max dup: 64 
    Average key length: 2.74, compression ratio: 3.29 
    Average prefix length: 8.36, average data length: 0.64 
    Clustering factor: 375495, ratio: 0.18 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 6 
        40 - 59% = 2409 
        60 - 79% = 319 
        80 - 99% = 26 
 
    Index PSTORNED_WORKER_ID (2) 
    Root page: 1507996, depth: 3, leaf buckets: 2152, nodes: 2102562 
    Average node length: 4.96, total dup: 2102462, max dup: 27564 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.42, average data length: 0.00 
    Clustering factor: 179585, ratio: 0.09 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 173 
        40 - 59% = 1193 
        60 - 79% = 413 
        80 - 99% = 372 
 
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.43, total records: 147884 
    Average version length: 69.18, total versions: 67922, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 3.37 
    Pointer pages: 3, data page slots: 4320 
    Data pages: 2687, average fill: 64% 
    Primary pages: 2687, secondary pages: 0, swept pages: 268 
    Empty pages: 355, full pages: 1783 
    Fill distribution: 
     0 - 19% = 448 
    20 - 39% = 114 
    40 - 59% = 174 
    60 - 79% = 629 
    80 - 99% = 1322 
 
    Index XQD_1000_1200_WA_SO_RO_WKR_SND (0) 
    Root page: 104636, depth: 3, leaf buckets: 216, nodes: 147884 
    Average node length: 6.42, total dup: 128756, max dup: 14 
    Average key length: 3.94, compression ratio: 10.65 
    Average prefix length: 40.18, average data length: 1.82 
    Clustering factor: 25611, ratio: 0.17 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 41 
        40 - 59% = 85 
        60 - 79% = 72 
        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.98, total records: 7170099 
    Average version length: 68.75, total versions: 413335, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.94 
    Pointer pages: 63, data page slots: 102752 
    Data pages: 102752, average fill: 75% 
    Primary pages: 102752, secondary pages: 0, swept pages: 29656 
    Empty pages: 1, full pages: 78711 
    Fill distribution: 
     0 - 19% = 13 
    20 - 39% = 284 
    40 - 59% = 4799 
    60 - 79% = 91380 
    80 - 99% = 6276 
 
    Index XQD_1000_3300_WA_SO_RO_WKR_SND (0) 
    Root page: 1480454, depth: 3, leaf buckets: 10819, nodes: 7170099 
    Average node length: 6.51, total dup: 6202791, max dup: 29 
    Average key length: 3.52, compression ratio: 11.94 
    Average prefix length: 40.62, average data length: 1.38 
    Clustering factor: 1597111, ratio: 0.22 
    Fill distribution: 
         0 - 19% = 7 
        20 - 39% = 1909 
        40 - 59% = 5511 
        60 - 79% = 2758 
        80 - 99% = 634 
 
    Index XQD_1000_3300_WKR_DOC_ASC (1) 
    Root page: 1486068, depth: 3, leaf buckets: 8593, nodes: 7170099 
    Average node length: 5.39, total dup: 6886344, max dup: 180 
    Average key length: 2.40, compression ratio: 7.07 
    Average prefix length: 16.64, average data length: 0.36 
    Clustering factor: 1386884, ratio: 0.19 
    Fill distribution: 
         0 - 19% = 5 
        20 - 39% = 1217 
        40 - 59% = 4554 
        60 - 79% = 1868 
        80 - 99% = 949 
 
    Index XQD_1000_3300_WKR_DOC_DEC (2) 
    Root page: 1490608, depth: 3, leaf buckets: 8663, nodes: 7170099 
    Average node length: 5.39, total dup: 6886344, max dup: 180 
    Average key length: 2.40, compression ratio: 7.07 
    Average prefix length: 16.64, average data length: 0.36 
    Clustering factor: 1389307, ratio: 0.19 
    Fill distribution: 
         0 - 19% = 11 
        20 - 39% = 1275 
        40 - 59% = 4548 
        60 - 79% = 1873 
        80 - 99% = 956 
 
XQD_1200_2000 (177) 
    Primary pointer page: 551, Index root page: 552 
    Total formats: 1, used formats: 1 
    Average record length: 67.17, total records: 12150233 
    Average version length: 68.68, total versions: 313163, 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: 104, data page slots: 169400 
    Data pages: 169400, average fill: 76% 
    Primary pages: 169400, secondary pages: 0, swept pages: 83532 
    Empty pages: 0, full pages: 153047 
    Fill distribution: 
     0 - 19% = 20 
    20 - 39% = 318 
    40 - 59% = 3430 
    60 - 79% = 159945 
    80 - 99% = 5687 
 
    Index XQD_1200_2000_WA_SO_RO_WKR_SND (0) 
    Root page: 1495028, depth: 3, leaf buckets: 18406, nodes: 12150233 
    Average node length: 6.59, total dup: 10591770, max dup: 58 
    Average key length: 3.42, compression ratio: 12.26 
    Average prefix length: 40.70, average data length: 1.30 
    Clustering factor: 2395394, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 24 
        20 - 39% = 2582 
        40 - 59% = 10237 
        60 - 79% = 4455 
        80 - 99% = 1108 
 
XQD_2000_3300 (179) 
    Primary pointer page: 555, Index root page: 556 
    Total formats: 1, used formats: 1 
    Average record length: 42.00, total records: 1562069 
    Average version length: 69.14, total versions: 613394, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 3.00 
    Pointer pages: 29, data page slots: 45592 
    Data pages: 27704, average fill: 65% 
    Primary pages: 27704, secondary pages: 0, swept pages: 6703 
    Empty pages: 2618, full pages: 18162 
    Fill distribution: 
     0 - 19% = 4087 
    20 - 39% = 1905 
    40 - 59% = 1918 
    60 - 79% = 10459 
    80 - 99% = 9335 
 
    Index XQD_2000_3300_WA_SO_RO_WKR_SND (0) 
    Root page: 1479712, depth: 3, leaf buckets: 2153, nodes: 1562069 
    Average node length: 5.51, total dup: 1499053, max dup: 99 
    Average key length: 2.56, compression ratio: 16.40 
    Average prefix length: 41.48, average data length: 0.52 
    Clustering factor: 104257, ratio: 0.07 
    Fill distribution: 
         0 - 19% = 11 
        20 - 39% = 531 
        40 - 59% = 1120 
        60 - 79% = 412 
        80 - 99% = 79 
 
XQD_2100_3300 (180) 
    Primary pointer page: 557, Index root page: 558 
    Total formats: 1, used formats: 1 
    Average record length: 38.14, total records: 1213245 
    Average version length: 69.12, total versions: 542759, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 3.30 
    Pointer pages: 22, data page slots: 34600 
    Data pages: 27360, average fill: 52% 
    Primary pages: 27359, secondary pages: 1, swept pages: 5637 
    Empty pages: 5317, full pages: 12955 
    Fill distribution: 
     0 - 19% = 7885 
    20 - 39% = 2293 
    40 - 59% = 2583 
    60 - 79% = 4704 
    80 - 99% = 9895 
 
    Index XQD_2100_3300_WA_SO_RO_WKR_SND (0) 
    Root page: 1479207, depth: 3, leaf buckets: 1659, nodes: 1213245 
    Average node length: 5.79, total dup: 1132272, max dup: 101 
    Average key length: 2.86, compression ratio: 14.71 
    Average prefix length: 41.21, average data length: 0.79 
    Clustering factor: 170628, ratio: 0.14 
    Fill distribution: 
         0 - 19% = 7 
        20 - 39% = 352 
        40 - 59% = 791 
        60 - 79% = 422 
        80 - 99% = 87 
 
XQD_3300_3400 (181) 
    Primary pointer page: 559, Index root page: 560 
    Total formats: 1, used formats: 1 
    Average record length: 65.64, total records: 9155244 
    Average version length: 68.97, total versions: 432599, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.92 
    Pointer pages: 90, data page slots: 145816 
    Data pages: 145760, average fill: 67% 
    Primary pages: 145760, secondary pages: 0, swept pages: 65133 
    Empty pages: 500, full pages: 74291 
    Fill distribution: 
     0 - 19% = 1469 
    20 - 39% = 7690 
    40 - 59% = 27079 
    60 - 79% = 103544 
    80 - 99% = 5978 
 
    Index XQD_3300_3400_WA_SO_RO_WKR_SND (0) 
    Root page: 1472590, depth: 3, leaf buckets: 13455, nodes: 9155244 
    Average node length: 6.69, total dup: 7594122, max dup: 27 
    Average key length: 3.67, compression ratio: 11.45 
    Average prefix length: 40.50, average data length: 1.50 
    Clustering factor: 1962868, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 1518 
        40 - 59% = 6610 
        60 - 79% = 4506 
        80 - 99% = 820 
 
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: 21179645 
    Average version length: 82.89, total versions: 12756, 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: 319184 
    Data pages: 319184, average fill: 81% 
    Primary pages: 319184, secondary pages: 0, swept pages: 13115 
    Empty pages: 12, full pages: 318595 
    Fill distribution: 
     0 - 19% = 22 
    20 - 39% = 31 
    40 - 59% = 79 
    60 - 79% = 27709 
    80 - 99% = 291343 
 
    Index XQS_1000_1200_DOC_ID (1) 
    Root page: 1426716, depth: 3, leaf buckets: 19555, nodes: 21179645 
    Average node length: 5.72, total dup: 20698250, max dup: 135 
    Average key length: 2.16, compression ratio: 4.16 
    Average prefix length: 8.86, average data length: 0.14 
    Clustering factor: 3287344, ratio: 0.16 
    Fill distribution: 
         0 - 19% = 6 
        20 - 39% = 1 
        40 - 59% = 8423 
        60 - 79% = 567 
        80 - 99% = 10558 
 
    Index XQS_1000_1200_RCV_ID (3) 
    Root page: 1456980, depth: 3, leaf buckets: 17233, nodes: 21179645 
    Average node length: 6.31, total dup: 18611740, max dup: 49 
    Average key length: 2.75, compression ratio: 3.27 
    Average prefix length: 8.37, average data length: 0.63 
    Clustering factor: 919327, ratio: 0.04 
    Fill distribution: 
         0 - 19% = 3 
        20 - 39% = 3 
        40 - 59% = 834 
        60 - 79% = 299 
        80 - 99% = 16094 
 
    Index XQS_1000_1200_SND_ID (2) 
    Root page: 1441073, depth: 3, leaf buckets: 21369, nodes: 21179645 
    Average node length: 6.35, total dup: 18531988, max dup: 29 
    Average key length: 2.79, compression ratio: 3.23 
    Average prefix length: 8.34, average data length: 0.66 
    Clustering factor: 3582336, ratio: 0.17 
    Fill distribution: 
         0 - 19% = 6 
        20 - 39% = 2 
        40 - 59% = 8737 
        60 - 79% = 639 
        80 - 99% = 11985 
 
    Index XQS_1000_1200_WORKER_ID (0) 
    Root page: 1413348, depth: 3, leaf buckets: 16151, nodes: 21179645 
    Average node length: 5.56, total dup: 21179545, max dup: 230939 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.42, average data length: 0.00 
    Clustering factor: 947869, ratio: 0.04 
    Fill distribution: 
         0 - 19% = 3 
        20 - 39% = 11 
        40 - 59% = 2903 
        60 - 79% = 432 
        80 - 99% = 12802 
 
XQS_1000_3300 (184) 
    Primary pointer page: 565, Index root page: 566 
    Total formats: 1, used formats: 1 
    Average record length: 78.72, total records: 9605888 
    Average version length: 82.60, total versions: 429660, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.60 
    Pointer pages: 106, data page slots: 172816 
    Data pages: 172776, average fill: 69% 
    Primary pages: 172776, secondary pages: 0, swept pages: 84649 
    Empty pages: 793, full pages: 93354 
    Fill distribution: 
     0 - 19% = 2150 
    20 - 39% = 8972 
    40 - 59% = 31623 
    60 - 79% = 71523 
    80 - 99% = 58508 
 
    Index XQS_1000_3300_DOC_ID (1) 
    Root page: 1367502, depth: 3, leaf buckets: 11383, nodes: 9605888 
    Average node length: 5.38, total dup: 9296714, max dup: 189 
    Average key length: 2.23, compression ratio: 4.03 
    Average prefix length: 8.80, average data length: 0.20 
    Clustering factor: 2119985, ratio: 0.22 
    Fill distribution: 
         0 - 19% = 5 
        20 - 39% = 106 
        40 - 59% = 8341 
        60 - 79% = 2858 
        80 - 99% = 73 
 
    Index XQS_1000_3300_RCV_ID (3) 
    Root page: 1379261, depth: 3, leaf buckets: 13701, nodes: 9605888 
    Average node length: 6.25, total dup: 7962524, max dup: 14 
    Average key length: 3.10, compression ratio: 2.90 
    Average prefix length: 8.07, average data length: 0.93 
    Clustering factor: 1465642, ratio: 0.15 
    Fill distribution: 
         0 - 19% = 124 
        20 - 39% = 4246 
        40 - 59% = 4465 
        60 - 79% = 2603 
        80 - 99% = 2263 
 
    Index XQS_1000_3300_SND_ID (2) 
    Root page: 1373059, depth: 3, leaf buckets: 12697, nodes: 9605888 
    Average node length: 6.00, total dup: 8334004, max dup: 41 
    Average key length: 2.85, compression ratio: 3.16 
    Average prefix length: 8.28, average data length: 0.72 
    Clustering factor: 2308922, ratio: 0.24 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 120 
        40 - 59% = 9293 
        60 - 79% = 3181 
        80 - 99% = 101 
 
    Index XQS_1000_3300_WORKER_ID (0) 
    Root page: 1362767, depth: 3, leaf buckets: 10113, nodes: 9605888 
    Average node length: 5.15, total dup: 9605788, max dup: 164129 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.42, average data length: 0.00 
    Clustering factor: 1514361, ratio: 0.16 
    Fill distribution: 
         0 - 19% = 48 
        20 - 39% = 1304 
        40 - 59% = 5009 
        60 - 79% = 1690 
        80 - 99% = 2062 
 
XQS_1200_2000 (183) 
    Primary pointer page: 563, Index root page: 564 
    Total formats: 1, used formats: 1 
    Average record length: 79.98, total records: 11226848 
    Average version length: 82.53, total versions: 316554, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.58 
    Pointer pages: 118, data page slots: 191944 
    Data pages: 190568, average fill: 72% 
    Primary pages: 190568, secondary pages: 0, swept pages: 73034 
    Empty pages: 3286, full pages: 140412 
    Fill distribution: 
     0 - 19% = 5671 
    20 - 39% = 7859 
    40 - 59% = 18790 
    60 - 79% = 43438 
    80 - 99% = 114810 
 
    Index XQS_1200_2000_DOC_ID (1) 
    Root page: 1392101, depth: 3, leaf buckets: 13110, nodes: 11226848 
    Average node length: 5.30, total dup: 11116757, max dup: 642 
    Average key length: 2.08, compression ratio: 4.32 
    Average prefix length: 8.93, average data length: 0.07 
    Clustering factor: 2341023, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 253 
        40 - 59% = 8976 
        60 - 79% = 3682 
        80 - 99% = 198 
 
    Index XQS_1200_2000_RCV_ID (3) 
    Root page: 1406110, depth: 3, leaf buckets: 10465, nodes: 11226848 
    Average node length: 5.50, total dup: 10736462, max dup: 49 
    Average key length: 2.28, compression ratio: 3.95 
    Average prefix length: 8.77, average data length: 0.23 
    Clustering factor: 708294, ratio: 0.06 
    Fill distribution: 
         0 - 19% = 149 
        20 - 39% = 890 
        40 - 59% = 2604 
        60 - 79% = 1927 
        80 - 99% = 4895 
 
    Index XQS_1200_2000_SND_ID (2) 
    Root page: 1398638, depth: 3, leaf buckets: 14996, nodes: 11226848 
    Average node length: 6.03, total dup: 9795758, max dup: 72 
    Average key length: 2.81, compression ratio: 3.21 
    Average prefix length: 8.32, average data length: 0.68 
    Clustering factor: 2357456, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 312 
        40 - 59% = 10527 
        60 - 79% = 3933 
        80 - 99% = 223 
 
    Index XQS_1200_2000_WORKER_ID (0) 
    Root page: 1386211, depth: 3, leaf buckets: 10760, nodes: 11226848 
    Average node length: 5.23, total dup: 11226748, max dup: 189393 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.43, average data length: 0.00 
    Clustering factor: 697620, ratio: 0.06 
    Fill distribution: 
         0 - 19% = 96 
        20 - 39% = 852 
        40 - 59% = 4873 
        60 - 79% = 1491 
        80 - 99% = 3448 
 
XQS_2000_3300 (185) 
    Primary pointer page: 567, Index root page: 568 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index XQS_2000_3300_DOC_ID (1) 
    Root page: 1361753, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index XQS_2000_3300_RCV_ID (3) 
    Root page: 1361755, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index XQS_2000_3300_SND_ID (2) 
    Root page: 1361754, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index XQS_2000_3300_WORKER_ID (0) 
    Root page: 1361752, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
XQS_2100_3300 (186) 
    Primary pointer page: 569, Index root page: 570 
    Total formats: 1, used formats: 1 
    Average record length: 79.11, total records: 9717333 
    Average version length: 82.91, total versions: 426200, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.59 
    Pointer pages: 109, data page slots: 176496 
    Data pages: 176448, average fill: 68% 
    Primary pages: 176448, secondary pages: 0, swept pages: 89708 
    Empty pages: 881, full pages: 93058 
    Fill distribution: 
     0 - 19% = 2461 
    20 - 39% = 9687 
    40 - 59% = 33187 
    60 - 79% = 74094 
    80 - 99% = 57019 
 
    Index XQS_2100_3300_DOC_ID (1) 
    Root page: 1344686, depth: 3, leaf buckets: 11848, nodes: 9717333 
    Average node length: 5.19, total dup: 9688379, max dup: 2031 
    Average key length: 2.03, compression ratio: 4.43 
    Average prefix length: 8.97, average data length: 0.03 
    Clustering factor: 1939471, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 35 
        20 - 39% = 1595 
        40 - 59% = 7796 
        60 - 79% = 1852 
        80 - 99% = 570 
 
    Index XQS_2100_3300_RCV_ID (3) 
    Root page: 1355717, depth: 3, leaf buckets: 13824, nodes: 9717333 
    Average node length: 6.26, total dup: 8055051, max dup: 14 
    Average key length: 3.10, compression ratio: 2.90 
    Average prefix length: 8.07, average data length: 0.93 
    Clustering factor: 1438415, ratio: 0.15 
    Fill distribution: 
         0 - 19% = 191 
        20 - 39% = 4224 
        40 - 59% = 4367 
        60 - 79% = 2662 
        80 - 99% = 2380 
 
    Index XQS_2100_3300_SND_ID (2) 
    Root page: 1350049, depth: 3, leaf buckets: 12465, nodes: 9717333 
    Average node length: 5.45, total dup: 9279747, max dup: 97 
    Average key length: 2.29, compression ratio: 3.93 
    Average prefix length: 8.76, average data length: 0.24 
    Clustering factor: 2072098, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 23 
        20 - 39% = 1545 
        40 - 59% = 8660 
        60 - 79% = 1667 
        80 - 99% = 570 
 
    Index XQS_2100_3300_WORKER_ID (0) 
    Root page: 985805, depth: 3, leaf buckets: 10317, nodes: 9717333 
    Average node length: 5.16, total dup: 9717233, max dup: 165622 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.42, average data length: 0.00 
    Clustering factor: 1536316, ratio: 0.16 
    Fill distribution: 
         0 - 19% = 36 
        20 - 39% = 1334 
        40 - 59% = 5251 
        60 - 79% = 1679 
        80 - 99% = 2017 
 
XQS_3300_3400 (187) 
    Primary pointer page: 571, Index root page: 572 
    Total formats: 1, used formats: 1 
    Average record length: 67.40, total records: 574959 
    Average version length: 68.69, total versions: 6471, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.87 
    Pointer pages: 5, data page slots: 8032 
    Data pages: 8032, average fill: 75% 
    Primary pages: 8032, secondary pages: 0, swept pages: 3999 
    Empty pages: 7, full pages: 6623 
    Fill distribution: 
     0 - 19% = 12 
    20 - 39% = 28 
    40 - 59% = 287 
    60 - 79% = 7615 
    80 - 99% = 90 
 
    Index XQS_3300_3400_DOC_ID (1) 
    Root page: 37542, depth: 3, leaf buckets: 734, nodes: 574959 
    Average node length: 5.95, total dup: 489442, max dup: 83 
    Average key length: 3.09, compression ratio: 2.91 
    Average prefix length: 8.05, average data length: 0.95 
    Clustering factor: 99953, ratio: 0.17 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 28 
        40 - 59% = 512 
        60 - 79% = 101 
        80 - 99% = 93 
 
    Index XQS_3300_3400_SND_ID (2) 
    Root page: 26887, depth: 3, leaf buckets: 759, nodes: 574959 
    Average node length: 6.15, total dup: 471618, max dup: 17 
    Average key length: 3.29, compression ratio: 2.73 
    Average prefix length: 7.89, average data length: 1.11 
    Clustering factor: 100003, ratio: 0.17 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 31 
        40 - 59% = 530 
        60 - 79% = 97 
        80 - 99% = 99 
 
    Index XQS_3300_3400_WORKER_ID (0) 
    Root page: 375548, depth: 2, leaf buckets: 579, nodes: 574959 
    Average node length: 4.86, total dup: 574859, max dup: 9861 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.42, average data length: 0.00 
    Clustering factor: 88789, ratio: 0.15 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 28 
        40 - 59% = 350 
        60 - 79% = 90 
        80 - 99% = 111 
 
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 Sat Apr  6 01:11:49 2024

Record versions statistics, table

TABLE_NAME TOTAL_RECS TOTAL_VERS MAX_VERSIONS VERS_TO_RECS_PRC MAXV_TO_VERS_PRC
DOC_DATA 7752178 81225 1 0.0000 0.0000
DOC_LIST 2243716 81290 4 0.0000 0.0000
FB_ERRORS 2182 757 1 0.0000 0.0000
INVNT_SALDO 400 255563 662 63800.0000 0.0000
INVNT_TURNOVER_LOG 98924 95436 1 0.0000 0.0000
MONEY_SALDO 49 18853 1025 38400.0000 0.0000
MONEY_TURNOVER_LOG 1599 1566 1 0.0000 0.0000
PDISTR 812882 76812 4 0.0000 0.0000
PERF_SPLIT_0 205926 15888 1 0.0000 0.0000
PERF_SPLIT_1 182678 16463 1 0.0000 0.0000
PERF_SPLIT_2 234576 72804 1 0.0000 0.0000
PERF_SPLIT_3 185698 15758 1 0.0000 0.0000
PERF_SPLIT_4 188454 46181 1 0.0000 0.0000
PERF_SPLIT_5 177156 13589 1 0.0000 0.0000
PERF_SPLIT_6 190464 25060 1 0.0000 0.0000
PERF_SPLIT_7 198217 36698 1 0.0000 0.0000
PERF_SPLIT_8 176693 17592 1 0.0000 0.0000
PERF_SPLIT_9 185301 20636 1 0.0000 0.0000
PSTORNED 2102562 33823 1 0.0000 0.0000
SEMAPHORES 5 1 1 0.0000 100.0000
XQD_1000_1200 147884 67922 1 0.0000 0.0000
XQD_1000_3300 7170099 413335 1 0.0000 0.0000
XQD_1200_2000 12150233 313163 1 0.0000 0.0000
XQD_2000_3300 1562069 613394 1 0.0000 0.0000
XQD_2100_3300 1213245 542759 1 0.0000 0.0000
XQD_3300_3400 9155244 432599 1 0.0000 0.0000
XQS_1000_1200 21179645 12756 1 0.0000 0.0000
XQS_1000_3300 9605888 429660 1 0.0000 0.0000
XQS_1200_2000 11226848 316554 1 0.0000 0.0000
XQS_2100_3300 9717333 426200 1 0.0000 0.0000
XQS_3300_3400 574959 6471 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 ---
--- end of diff output ---

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

06.04.24 01:12:01. 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-04-06 01:12:03 No severe PSQL-related problems occured
06.04.24 01:12:05. End of report.