Generated by /opt/oltp-emul/oltp_isql_run_worker.sh, ISQL session No. 1 of total launched 100. 19.02.2024 04:08
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 15527812 kB
MemAvailable 30211940 kB
Buffers 20 kB
Cached 16134604 kB
SwapCached 2472 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 4.0.5
DB_NAME                         /home/bases/oltp40-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/oltp40-etalone.fdb
param=detailed_info, val=0
param=etalon_dbnm, val=/home/bases/oltp40-etalone.fd0
param=expected_workers, val=100
param=fbc, val=/opt/fb40/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=3400
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/oltp40-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-oltp40
param=unit_selection_method, val=random
param=update_conflict_percent, val=0
param=used_in_replication, val=0
param=use_mtee, val=0
param=usr, val=SYSDBA
param=wait_after_create, val=0
param=wait_for_copy, val=1
param=wait_if_not_exists, val=0
param=warm_time, val=20
param=working_mode, val=small_03
Custom name of interactive SQL utility: parameter: 'clu', value: |isql|

Test finish info 


FINISH_STATE                    NORMAL: TEST_TIME EXPIRED AT 2024-02-19 04:07:46
DTS_END                         2024-02-19 04:07:46.2980
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(68:17)
IP                              ::1/44674
TRN_ID                          176115
ATT_ID                          535
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: 9246.29 22959 924629
customer order: creation 185.68 381 18568
customer order: refuse 16.06 361 1606
order to supplier: creation 48.61 1296 4861
order to supplier: removal 3.53 89723 353
invoice (draft): creation 50.05 3146 5005
invoice (draft): removal 48.57 753 4857
invoice accept: apply 45.09 20223 4509
invoice accept: cancel 43.05 808 4305
customer reserve: creation 4279.88 196 427988
customer reserve: removal 4226.95 59 422695
realization accept: apply 90.26 190 9026
realization accept: cancel 69.70 156 6970
payment from customer: creation 63.71 121 6371
payment from customer: removal 6.62 95 662
payment to supplier: creation 52.53 141 5253
payment to supplier: removal 3.83 70 383
service: total inventory turnovers 4.32 3611 432
service: total monetary turnovers 6.77 564 677
service: aggregate perf. data 1.05 10722 105
service: refresh index statistics 0.03 326564 3

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:02, from 19-02-2024 04:08:49 to 19-02-2024 04:08:51.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 2704
TEST_TIME 2 3694
TEST_TIME 3 4353
TEST_TIME 4 4068
TEST_TIME 5 4938
TEST_TIME 6 5248
TEST_TIME 7 5131
TEST_TIME 8 5176
TEST_TIME 9 5468
TEST_TIME 10 5886
TEST_TIME 11 6435
TEST_TIME 12 6622
TEST_TIME 13 6462
TEST_TIME 14 6947
TEST_TIME 15 6933
TEST_TIME 16 7155
TEST_TIME 17 7243
TEST_TIME 18 7638
TEST_TIME 19 7727
TEST_TIME 20 8036
TEST_TIME 21 8622
TEST_TIME 22 8562
TEST_TIME 23 8994
TEST_TIME 24 9237
TEST_TIME 25 9018
TEST_TIME 26 9253
TEST_TIME 27 9502
TEST_TIME 28 9678
TEST_TIME 29 9483
TEST_TIME 30 9641
TEST_TIME 31 9581
TEST_TIME 32 9582
TEST_TIME 33 9500
TEST_TIME 34 9621
TEST_TIME 35 9707
TEST_TIME 36 9756
TEST_TIME 37 9954
TEST_TIME 38 10052
TEST_TIME 39 9981
TEST_TIME 40 9839
TEST_TIME 41 9665
TEST_TIME 42 9595
TEST_TIME 43 9553
TEST_TIME 44 9593
TEST_TIME 45 9506
TEST_TIME 46 9475
TEST_TIME 47 9447
TEST_TIME 48 9522
TEST_TIME 49 9547
TEST_TIME 50 9454
TEST_TIME 51 9534
TEST_TIME 52 9524
TEST_TIME 53 9559
TEST_TIME 54 9554
TEST_TIME 55 9538
TEST_TIME 56 9599
TEST_TIME 57 9570
TEST_TIME 58 9735
TEST_TIME 59 9723
TEST_TIME 60 9732
TEST_TIME 61 9773
TEST_TIME 62 9798
TEST_TIME 63 9805
TEST_TIME 64 9710
TEST_TIME 65 9582
TEST_TIME 66 9674
TEST_TIME 67 9595
TEST_TIME 68 9536
TEST_TIME 69 9567
TEST_TIME 70 9541
TEST_TIME 71 9472
TEST_TIME 72 9391
TEST_TIME 73 9329
TEST_TIME 74 9277
TEST_TIME 75 9304
TEST_TIME 76 9371
TEST_TIME 77 9358
TEST_TIME 78 9362
TEST_TIME 79 9333
TEST_TIME 80 9415
TEST_TIME 81 9360
TEST_TIME 82 9513
TEST_TIME 83 9515
TEST_TIME 84 9525
TEST_TIME 85 9523
TEST_TIME 86 9519
TEST_TIME 87 9634
TEST_TIME 88 9549
TEST_TIME 89 9460
TEST_TIME 90 9439
TEST_TIME 91 9494
TEST_TIME 92 9436
TEST_TIME 93 9409
TEST_TIME 94 9339
TEST_TIME 95 9295
TEST_TIME 96 9275
TEST_TIME 97 9250
TEST_TIME 98 9274
TEST_TIME 99 9272
TEST_TIME 100 9259

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:04, from 19-02-2024 04:08:52 to 19-02-2024 04:08:56.

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 1315270 1315270 0 0.00 0 20397 8 0 0
doc_list_biud 1315270 1315270 0 0.00 0 60149 24 0 0
sp_add_invoice_to_stock 4651 4509 142 3.05 27 174960 20223 0 142
sp_cancel_adding_invoice 4305 4305 0 0.00 3 43219 809 0 0
sp_cancel_client_order 1606 1606 0 0.00 4 14642 362 0 0
sp_cancel_customer_reserve 422695 422695 0 0.00 0 32754 60 0 0
sp_cancel_pay_from_customer 662 662 0 0.00 2 8710 96 0 0
sp_cancel_pay_to_supplier 383 383 0 0.00 2 3697 70 0 0
sp_cancel_supplier_invoice 4867 4857 10 0.20 1 60157 754 0 10
sp_cancel_supplier_order 353 353 0 0.00 4 792266 89724 0 0
sp_cancel_write_off 6970 6970 0 0.00 1 12598 157 0 0
sp_client_order 18568 18568 0 0.00 3 25907 382 0 0
sp_customer_reserve 427988 427988 0 0.00 0 114492 196 0 0
sp_fill_shopping_cart 28423 28423 0 0.00 1 14877 40 0 0
sp_fill_shopping_cart_clo_res 427968 427968 0 0.00 0 20183 16 0 0
sp_get_clo_for_invoice 4488 4488 0 0.00 0 32057 320 0 0
sp_kill_cost_storno 12320 12320 0 0.00 0 8043 81 0 0
sp_kill_qstorno_ret_qs2qd 857570 857570 0 0.00 0 60147 32 0 0
sp_kill_qty_storno 454300 454300 0 0.00 0 60148 70 0 0
sp_lock_selected_doc 18720 18720 0 0.00 0 10855 7 0 0
sp_make_cost_storno 25138 25138 0 0.00 0 20383 67 0 0
sp_multiply_rows_for_pdistr 25138 25138 0 0.00 0 9546 36 0 0
sp_multiply_rows_for_qdistr 18568 18568 0 0.00 0 16387 186 0 0
sp_pay_from_customer 6371 6371 0 0.00 4 13896 121 0 0
sp_pay_to_supplier 5253 5253 0 0.00 4 17549 142 0 0
sp_payment_common 11624 11624 0 0.00 1 7969 28 0 0
sp_qd_handle_on_cancel_clo 1606 1606 0 0.00 0 14633 327 0 0
sp_qd_handle_on_invoice_upd_sts 8793 8793 0 0.00 0 31292 299 0 0
sp_qd_handle_on_reserve_upd_sts 9026 9026 0 0.00 0 14123 57 0 0
sp_reserve_write_off 9026 9026 0 0.00 6 22161 191 0 0
sp_supplier_invoice 5005 5005 0 0.00 5 82224 3146 0 0
sp_supplier_order 4861 4861 0 0.00 6 50537 1296 0 0
srv_aggregate_perf_data 105 105 0 0.00 1379 98089 10723 0 0
srv_fill_mon_cache_memory 56 56 0 0.00 1183 128831 40884 0 0
srv_find_qd_qs_mism 878461 878461 0 0.00 0 16061 8 0 0
srv_make_invnt_saldo 432 432 0 0.00 29 95122 3612 0 0
srv_make_money_saldo 677 677 0 0.00 1 14301 565 0 0
srv_recalc_idx_stat 3 3 0 0.00 144040 465144 326564 0 0
t$perf-abend:sp_add_invoice_to_stock 142 142 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-norm:sp_add_invoice_to_stock 4509 4509 0 0.00 0 8641 173 0 0
t$perf-norm:sp_cancel_adding_invoice 377 377 0 0.00 0 6064 95 0 0
t$perf-norm:sp_cancel_client_order 1606 1606 0 0.00 0 4852 13 0 0
t$perf-norm:sp_cancel_customer_reserve 586 586 0 0.00 0 2016 16 0 0
t$perf-norm:sp_cancel_pay_from_customer 662 662 0 0.00 0 1363 8 0 0
t$perf-norm:sp_cancel_pay_to_supplier 383 383 0 0.00 0 637 4 0 0
t$perf-norm:sp_cancel_supplier_invoice 375 375 0 0.00 0 3175 26 0 0
t$perf-norm:sp_cancel_supplier_order 353 353 0 0.00 0 18388 1560 0 0
t$perf-norm:sp_cancel_write_off 864 864 0 0.00 0 723 6 0 0
t$perf-norm:sp_client_order 18568 18568 0 0.00 0 28011 17 0 0
t$perf-norm:sp_customer_reserve 878 878 0 0.00 0 1139 4 0 0
t$perf-norm:sp_pay_from_customer 6371 6371 0 0.00 0 28016 10 0 0
t$perf-norm:sp_pay_to_supplier 5253 5253 0 0.00 0 4911 10 0 0
t$perf-norm:sp_reserve_write_off 9026 9026 0 0.00 0 25691 12 0 0
t$perf-norm:sp_supplier_invoice 5005 5005 0 0.00 0 4666 18 0 0
t$perf-norm:sp_supplier_order 4861 4861 0 0.00 0 8384 14 0 0
t$perf-norm:srv_aggregate_perf_data 105 105 0 0.00 0 1762 40 0 0
t$perf-norm:srv_fill_mon_cache_memory 56 56 0 0.00 0 257 7 0 0
t$perf-norm:srv_make_invnt_saldo 432 432 0 0.00 0 1119 11 0 0
t$perf-norm:srv_make_money_saldo 677 677 0 0.00 0 814 6 0 0
t$perf-norm:srv_recalc_idx_stat 3 3 0 0.00 2 5 3 0 0
v_add_invoice_to_stock 9260 8976 284 3.06 0 6657 17 0 284
v_all_customers 33660 33660 0 0.00 0 23 1 0 0
v_all_suppliers 28054 28054 0 0.00 0 60 1 0 0
v_all_wares 37136 37136 0 0.00 0 22 1 0 0
v_cancel_adding_invoice 754 754 0 0.00 0 353 7 0 0
v_cancel_client_order 3212 3212 0 0.00 0 4912 7 0 0
v_cancel_customer_prepayment 1324 1324 0 0.00 0 2403 6 0 0
v_cancel_customer_reserve 1172 1172 0 0.00 0 4630 9 0 0
v_cancel_payment_to_supplier 766 766 0 0.00 0 3692 8 0 0
v_cancel_supplier_invoice 770 750 20 2.59 0 580 14 0 20
v_cancel_supplier_order 706 706 0 0.00 0 885 8 0 0
v_cancel_write_off 1728 1728 0 0.00 0 6037 16 0 0
v_max_id_clo_ord 4858 4858 0 0.00 0 523 1 0 0
v_max_id_clo_res 878 878 0 0.00 0 1252 9 0 0
v_max_id_ord_sup 4995 4995 0 0.00 0 5223 5 0 0
v_max_non_paid_invoice 1079 1079 0 0.00 0 7653 11 0 0
v_max_non_paid_realizn 3398 3398 0 0.00 0 2707 4 0 0
v_min_id_clo_ord 4858 4858 0 0.00 0 14869 13 0 0
v_min_id_clo_res 878 878 0 0.00 0 1974 13 0 0
v_min_id_ord_sup 4995 4995 0 0.00 0 3988 4 0 0
v_min_non_paid_invoice 5253 5253 0 0.00 0 6668 16 0 0
v_min_non_paid_realizn 6371 6371 0 0.00 0 7965 23 0 0
v_our_firm 9422 9422 0 0.00 0 27 1 0 0
v_reserve_write_off 18052 18052 0 0.00 0 4876 5 0 0
x_lock_depdocs_on_canc_invoice 8787 8787 0 0.00 0 11232 109 0 0
x_lock_depdocs_on_canc_sup_ord 353 353 0 0.00 0 18154 435 0 0
x_make_qstorno_1000_1200 4861 4861 0 0.00 1 50453 1211 0 0
x_make_qstorno_1200_2000 5005 5005 0 0.00 2 80821 3003 0 0
x_make_qstorno_2100_3300 427988 427988 0 0.00 0 114491 177 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 19-02-2024 04:08:57 to 19-02-2024 04:09:01.

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
02:07:50 18 8192000000 8812489376 8829009920 14989840 0.182 5 5 6 0 15312992 185040 138112
02:08:51 24045 8192000000 9713133328 10010853376 796819344 8.864 100 89 178 0 826469840 7613056 22037440
02:10:31 24826 8192000000 9769431936 10074992640 839564272 9.295 100 90 180 0 873218720 12123040 21531408
02:12:01 16016 8192000000 9797560960 10112921600 863767824 9.538 100 82 163 0 901917744 19256976 18892944
02:13:26 15634 8192000000 9855624752 10189983744 916397600 10.061 100 78 154 0 967248544 34156032 16694912
02:14:54 9064 8192000000 9905295136 10255851520 956892176 10.459 100 72 144 0 1017660000 45759488 15008336
02:16:05 4047 8192000000 9960824032 10317541376 991400320 10.795 100 77 154 0 1079949504 72992192 15556992
02:17:13 2774 8192000000 9981168768 10347274240 1013741584 11.012 100 74 148 0 1102396880 73502496 15152800
02:18:18 2797 8192000000 9993670912 10365636608 1037524624 11.241 100 69 136 0 1110465344 59448672 13492048
02:19:22 2724 8192000000 10024285856 10398998528 1051902816 11.379 100 83 165 1 1142504672 73910192 16691664
02:20:28 10239 8192000000 10032389200 10407272448 1063508640 11.490 100 81 160 1 1143347632 63754144 16084848
02:21:40 3605 8192000000 9994785776 10393698304 1073335856 11.584 100 28 56 0 1118714240 39208368 6170016
02:22:46 37287 8192000000 9996492336 10392137728 1079197024 11.640 100 49 95 0 1126348000 37606608 9544368
02:24:24 7605 8192000000 9995962608 10402934784 1083099536 11.677 100 43 89 0 1108509776 14895232 10515008
02:25:32 6572 8192000000 10010668096 10413023232 1089466368 11.738 100 37 73 0 1120878960 23904448 7508144
02:26:40 15433 8192000000 10020125360 10416738304 1095436016 11.794 100 59 117 0 1126353648 18367136 12550496
02:27:58 4996 8192000000 10039038656 10437746688 1096174080 11.801 100 44 88 1 1146424032 41511136 8738816
02:29:08 15876 8192000000 10061276784 10462695424 1102304848 11.860 100 50 97 0 1173308208 61212992 9790368
02:30:27 45127 8192000000 10084110320 10491314176 1115544928 11.985 100 34 69 1 1173350032 50650256 7154848
02:32:20 14102 8192000000 10109647680 10534948864 1122801392 12.053 100 44 88 1 1220771872 88164144 9806336
02:33:39 10182 8192000000 10078611808 10503106560 1112037392 11.952 99 38 74 1 1195650448 75914592 7698464
02:34:54 16660 8192000000 10116838192 10539216896 1127794176 12.101 100 48 94 1 1233795952 95665760 10336016
02:36:27 3754 8192000000 10161732000 10558869504 1121419408 12.040 100 63 123 0 1266544096 131779856 13344832
02:37:40 9107 8192000000 10139286864 10556592128 1107168960 11.906 99 60 119 0 1237314304 116815360 13329984
02:38:53 11732 8192000000 10130385040 10540146688 1092495808 11.766 98 44 88 0 1220568224 118526576 9545840
02:40:10 4622 8192000000 10136901056 10529574912 1096227376 11.802 98 66 131 0 1241385024 130619216 14538432
02:41:20 11738 8192000000 10155026096 10585681920 1120537136 12.032 100 50 98 1 1284850000 153218112 11094752
02:42:48 2167 8192000000 10205800240 10604724224 1123457328 12.060 100 69 138 2 1303220928 164531168 15232432
02:44:02 1182 8192000000 10214724832 10607525888 1093048320 11.772 99 85 166 0 1310474928 199168848 18257760
02:45:11 4959 8192000000 10230838592 10625499136 1112709344 11.958 100 67 134 0 1343492768 215994112 14789312
02:46:21 1936 8192000000 10246585536 10637103104 1108714640 11.920 100 84 164 3 1349451232 221908768 18827824
02:47:28 2386 8192000000 10256088032 10655498240 1123730448 12.062 100 65 128 0 1358519824 220292512 14496864
02:48:35 7035 8192000000 10256654528 10693160960 1130638112 12.127 100 52 104 0 1363440976 220783376 12019488
02:49:45 7293 8192000000 10277973296 10694557696 1128479904 12.107 100 37 74 1 1383594432 246061952 9052576
02:50:56 30022 8192000000 10211012720 10659749888 1105136016 11.886 99 31 62 1 1316550416 203620448 7793952
02:52:41 21698 8192000000 10174622592 10619461632 1118701728 12.015 100 25 50 0 1298147760 173309232 6136800
02:54:09 26596 8192000000 10124923968 10614050816 1116584000 11.995 100 15 30 0 1233391984 113561760 3246224
02:55:37 49289 8192000000 10066455552 10491785216 1104109296 11.877 99 19 37 0 1169332112 61182304 4040512
02:57:28 74860 8192000000 10077316976 10527727616 1120935456 12.036 100 14 28 0 1166026256 42401584 2689216
02:59:47 56409 8192000000 10093785136 10555871232 1129582288 12.117 100 41 83 1 1192258912 54022528 8654096
03:01:47 122546 8192000000 10124860688 10593136640 1124611280 12.071 99 6 12 0 1164179840 38747984 820576
03:04:50 51870 8192000000 10090732096 10578460672 1145962528 12.272 100 34 65 1 1203152928 50806960 6383440
03:06:42 15044 8192000000 10085779904 10525065216 1152697088 12.335 100 26 52 0 1182426544 24218960 5510496
03:08:00 88827 8192000000 10147697504 10599497728 1156328112 12.369 100 28 56 0 1228041744 66160128 5553504
03:10:37 124829 8192000000 10134386400 10554515456 1121471616 12.041 97 50 99 0 1206727520 74554928 10700976
03:13:44 37451 8192000000 10166890448 10635714560 1145004176 12.263 99 46 88 0 1272114640 117255248 9855216
03:15:32 52772 8192000000 10146210448 10615013376 1131641600 12.137 98 17 34 0 1234629120 99047280 3940240
03:17:30 43197 8192000000 10117865952 10557231104 1106303344 11.897 96 12 24 0 1201353200 92444528 2605328
03:19:14 25792 8192000000 10089966240 10576412672 1137492224 12.192 100 11 22 0 1184344720 44634336 2218160
03:20:43 6692 8192000000 10075803744 10507694080 1130188496 12.123 100 47 94 0 1179703680 40091936 9423248
03:21:51 9983 8192000000 10062984768 10472771584 1097791248 11.817 99 33 62 0 1139568384 35608240 6168896
03:23:02 41886 8192000000 10040321392 10485166080 1079815280 11.646 97 37 73 0 1151305936 64187568 7303088
03:24:46 70819 8192000000 10070241536 10572959744 1088662992 11.730 97 28 56 0 1186263184 92001504 5598688
03:27:06 20548 8192000000 10072300496 10491396096 1072226832 11.573 96 31 62 0 1124597808 46014080 6356896
03:28:28 88378 8192000000 10042536064 10487996416 1038637488 11.252 93 22 44 0 1074986240 31966112 4382640
03:30:58 123554 8192000000 10105693584 10535006208 1050609200 11.367 95 37 74 0 1091709472 34057152 7043120
03:34:10 70635 8192000000 10027546880 10459602944 1078284752 11.631 98 28 56 0 1121216768 37495936 5436080
03:36:26 56688 8192000000 10045657280 10529042432 1108948560 11.922 100 30 60 0 1171154480 55909344 6296576
03:38:59 62026 8192000000 10057811504 10510323712 1106623056 11.900 98 15 30 0 1145973024 35405776 3944192
03:41:13 80952 8192000000 10089608432 10580238336 1121029312 12.037 99 11 22 0 1194404288 71248880 2126096
03:43:40 54351 8192000000 10088777392 10527858688 1124670112 12.071 99 18 37 0 1159527840 31195056 3662672
03:45:34 30818 8192000000 10120696816 10562203648 1147077920 12.282 100 23 44 1 1220854176 69140416 4635840
03:47:24 70465 8192000000 10168401392 10620960768 1157970272 12.384 100 18 36 0 1249249760 87017040 4262448
03:49:52 38544 8192000000 10083011056 10550718464 1139579696 12.212 99 26 51 0 1214107040 69847600 4679744
03:51:34 38266 8192000000 10111353456 10552066048 1153510320 12.342 100 24 49 0 1200382704 41814976 5057408
03:53:20 4785 8192000000 10137727536 10598641664 1152933040 12.337 100 69 138 0 1227153584 59938320 14282224
03:55:06 128830 8192000000 10080310240 10517512192 1114724464 11.977 96 17 33 0 1149869712 32086208 3059040
03:58:19 81200 8192000000 10088107728 10598969344 1131650784 12.137 98 11 22 0 1202035008 68163792 2220432
04:00:43 50591 8192000000 10048711232 10526175232 1125847712 12.082 98 5 10 0 1147930784 20876160 1206912
04:02:35 68728 8192000000 10072555056 10549473280 1125912224 12.083 98 17 34 0 1189859056 60647232 3299600
04:04:48 68489 8192000000 10053658736 10507390976 1092269152 11.764 96 23 46 0 1144210368 47352784 4588432
04:07:25 26178 8192000000 9112163312 9372688384 257722560 3.050 24 13 24 1 296199536 35986384 2490592

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:14, from 19-02-2024 04:09:03 to 19-02-2024 04:09:17.

Exceptions occured during test was in run

FB_MNEMONA CNT UNIT FB_GDSCODE
except 142 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 19-02-2024 04:09:18 to 19-02-2024 04:09:20.

Content of mon$database and FB version 


MON$DATABASE_NAME               /home/bases/oltp40-etalone.fdb
MON$PAGE_SIZE                   8192
MON$ODS_MAJOR                   13
MON$ODS_MINOR                   0
MON$OLDEST_TRANSACTION          175156
MON$OLDEST_ACTIVE               176614
MON$OLDEST_SNAPSHOT             176614
MON$NEXT_TRANSACTION            176614
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-30 07:30:08.6030 GMT
MON$PAGES                       1929696
MON$STAT_ID                     1
MON$BACKUP_STATE                0
MON$CRYPT_PAGE                  0
MON$OWNER                       SYSDBA                                                                                                                                                                                                                                                      
MON$SEC_DATABASE                Default
MON$CRYPT_STATE                 0
MON$GUID                        {58978C10-B735-40F5-8B7D-F7A1956E782B}
MON$FILE_ID                     02fd0000000000002e02000000000000
MON$NEXT_ATTACHMENT             698
MON$NEXT_STATEMENT              53
MON$REPLICA_MODE                0


ISQL Version: LI-V4.0.5.3059 Firebird 4.0
Server version:
Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V4.0.5.3059 Firebird 4.0"
Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-V4.0.5.3059 Firebird 4.0/tcp (mscs-test-161.budzdorov.ru)/P17:C"
Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-V4.0.5.3059 Firebird 4.0/tcp (mscs-test-161.budzdorov.ru)/P17:C"
on disk structure version 13.0

Database statistics 

 
Database "/home/bases/oltp40-etalone.fdb" 
Gstat execution time Mon Feb 19 04:09:21 2024 
 
Database header page information: 
    Flags            0 
    Generation        92650 
    System Change Number    0 
    Page size        8192 
    ODS version        13.0 
    Oldest transaction    175156 
    Oldest active        176614 
    Oldest snapshot        176614 
    Next transaction    176615 
    Sequence number        0 
    Next attachment ID    698 
    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 30, 2020 7:30:08 
    Attributes        force write 
 
    Variable header data: 
    Database GUID:    {58978C10-B735-40F5-8B7D-F7A1956E782B} 
    Sweep interval:        0 
    *END* 
 
 
Database file sequence: 
File /home/bases/oltp40-etalone.fdb is the only file 
 
Analyzing database pages ... 
AGENTS (150) 
    Primary pointer page: 524, Index root page: 525 
    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: 1504333, 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: 1504335, 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: 1504334, 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: 1504332, 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: 1504331, 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: 532, Index root page: 533 
    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: 1504264, 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: 1504266, 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: 1504265, 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: 1504263, 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: 502, Index root page: 503 
    Total formats: 1, used formats: 1 
    Average record length: 47.58, total records: 7761827 
    Average version length: 48.17, total versions: 63588, 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: 55, data page slots: 88936 
    Data pages: 88936, average fill: 70% 
    Primary pages: 88935, secondary pages: 1, swept pages: 36679 
    Empty pages: 5, full pages: 73954 
    Fill distribution: 
     0 - 19% = 14 
    20 - 39% = 53 
    40 - 59% = 1511 
    60 - 79% = 87316 
    80 - 99% = 42 
 
    Index DOC_DATA_DOC_WARE_UNQ (0) 
    Root page: 1510636, depth: 3, leaf buckets: 23256, nodes: 7761827 
    Average node length: 18.89, total dup: 0, max dup: 0 
    Average key length: 15.90, compression ratio: 1.70 
    Average prefix length: 14.10, average data length: 12.90 
    Clustering factor: 1692552, ratio: 0.22 
    Fill distribution: 
         0 - 19% = 322 
        20 - 39% = 1637 
        40 - 59% = 4337 
        60 - 79% = 2312 
        80 - 99% = 14648 
 
    Index DOC_DATA_ID_DESC (1) 
    Root page: 1528140, depth: 3, leaf buckets: 13533, nodes: 7761827 
    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: 1516408, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 1537 
        40 - 59% = 2109 
        60 - 79% = 1109 
        80 - 99% = 8778 
 
    Index FK_DOC_DATA_DOC_LIST (2) 
    Root page: 1546735, depth: 3, leaf buckets: 8318, nodes: 7761827 
    Average node length: 6.62, total dup: 5802374, max dup: 49 
    Average key length: 3.63, compression ratio: 2.48 
    Average prefix length: 7.62, average data length: 1.38 
    Clustering factor: 1509265, ratio: 0.19 
    Fill distribution: 
         0 - 19% = 112 
        20 - 39% = 894 
        40 - 59% = 1456 
        60 - 79% = 904 
        80 - 99% = 4952 
 
DOC_LIST (138) 
    Primary pointer page: 500, Index root page: 501 
    Total formats: 1, used formats: 1 
    Average record length: 56.75, total records: 2249878 
    Average version length: 58.83, total versions: 32906, max versions: 2 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 84.00, compression ratio: 1.48 
    Pointer pages: 18, data page slots: 28792 
    Data pages: 28792, average fill: 72% 
    Primary pages: 28790, secondary pages: 2, swept pages: 10532 
    Empty pages: 30, full pages: 19549 
    Fill distribution: 
     0 - 19% = 38 
    20 - 39% = 37 
    40 - 59% = 477 
    60 - 79% = 28183 
    80 - 99% = 57 
 
    Index DOC_LIST_ID_DESC (1) 
    Root page: 1541152, depth: 3, leaf buckets: 4561, nodes: 2249878 
    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: 678497, ratio: 0.30 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 902 
        40 - 59% = 882 
        60 - 79% = 716 
        80 - 99% = 2060 
 
    Index DOC_LIST_WORKER_OPTYPE (2) 
    Root page: 1544398, depth: 3, leaf buckets: 2424, nodes: 2251241 
    Average node length: 4.97, total dup: 2250342, max dup: 18250 
    Average key length: 2.01, compression ratio: 4.48 
    Average prefix length: 8.99, average data length: 0.01 
    Clustering factor: 1277489, ratio: 0.57 
    Fill distribution: 
         0 - 19% = 5 
        20 - 39% = 208 
        40 - 59% = 1387 
        60 - 79% = 550 
        80 - 99% = 274 
 
    Index FK_DOC_LIST_AGENTS (3) 
    Root page: 1545933, depth: 3, leaf buckets: 1788, nodes: 2249878 
    Average node length: 4.97, total dup: 2249828, max dup: 130472 
    Average key length: 2.01, compression ratio: 4.48 
    Average prefix length: 8.99, average data length: 0.01 
    Clustering factor: 1069429, ratio: 0.48 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 1 
        40 - 59% = 645 
        60 - 79% = 48 
        80 - 99% = 1094 
 
    Index PK_DOC_LIST (0) 
    Root page: 1538209, depth: 3, leaf buckets: 4369, nodes: 2249878 
    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: 678497, ratio: 0.30 
    Fill distribution: 
         0 - 19% = 94 
        20 - 39% = 582 
        40 - 59% = 681 
        60 - 79% = 808 
        80 - 99% = 2204 
 
DOC_STATES (149) 
    Primary pointer page: 522, Index root page: 523 
    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: 1504337, 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: 1504338, 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: 1504336, 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: 534, Index root page: 535 
    Total formats: 2, used formats: 2 
    Average record length: 57.88, 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.67 
    Pointer pages: 1, data page slots: 40 
    Data pages: 40, average fill: 72% 
    Primary pages: 39, secondary pages: 1, swept pages: 0 
    Empty pages: 4, full pages: 34 
    Fill distribution: 
     0 - 19% = 5 
    20 - 39% = 0 
    40 - 59% = 1 
    60 - 79% = 22 
    80 - 99% = 12 
 
    Index FB_ERRORS_GDS_CODE (0) 
    Root page: 398, 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: 1518, ratio: 0.70 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 0 
        40 - 59% = 1 
        60 - 79% = 1 
        80 - 99% = 0 
 
INVNT_SALDO (145) 
    Primary pointer page: 514, Index root page: 515 
    Total formats: 2, used formats: 1 
    Average record length: 83.37, total records: 400 
    Average version length: 21.97, total versions: 3965, max versions: 11 
    Average fragment length: 2.00, total fragments: 3, max fragments: 1 
    Average unpacked length: 104.00, compression ratio: 1.25 
    Pointer pages: 1, data page slots: 40 
    Data pages: 40, average fill: 60% 
    Primary pages: 9, secondary pages: 31, swept pages: 0 
    Empty pages: 2, full pages: 18 
    Fill distribution: 
     0 - 19% = 8 
    20 - 39% = 6 
    40 - 59% = 5 
    60 - 79% = 2 
    80 - 99% = 19 
 
    Index PK_INVNT_SALDO (0) 
    Root page: 1510371, 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: 530, Index root page: 531 
    Total formats: 1, used formats: 1 
    Average record length: 12.21, total records: 57986 
    Average version length: 68.28, total versions: 54849, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 88.00, compression ratio: 7.21 
    Pointer pages: 6, data page slots: 2472 
    Data pages: 1544, average fill: 52% 
    Primary pages: 1543, secondary pages: 1, swept pages: 0 
    Empty pages: 333, full pages: 611 
    Fill distribution: 
     0 - 19% = 438 
    20 - 39% = 176 
    40 - 59% = 196 
    60 - 79% = 194 
    80 - 99% = 540 
 
    Index INVNT_TURNOVER_LOG_WARE_DD_ID (0) 
    Root page: 1689445, depth: 3, leaf buckets: 246, nodes: 57986 
    Average node length: 13.77, total dup: 2794, max dup: 2 
    Average key length: 10.89, compression ratio: 2.48 
    Average prefix length: 19.06, average data length: 7.94 
    Clustering factor: 42017, ratio: 0.72 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 123 
        40 - 59% = 104 
        60 - 79% = 18 
        80 - 99% = 1 
 
MONEY_SALDO (141) 
    Primary pointer page: 506, Index root page: 507 
    Total formats: 1, used formats: 1 
    Average record length: 15.22, total records: 49 
    Average version length: 9.00, total versions: 253, max versions: 8 
    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: 4 
    Data pages: 4, average fill: 25% 
    Primary pages: 1, secondary pages: 3, swept pages: 0 
    Empty pages: 0, full pages: 1 
    Fill distribution: 
     0 - 19% = 3 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 1 
 
    Index PK_MONEY_SALDO (0) 
    Root page: 1510383, 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: 504, Index root page: 505 
    Total formats: 1, used formats: 1 
    Average record length: 11.08, total records: 947 
    Average version length: 43.01, total versions: 889, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 58.00, compression ratio: 5.23 
    Pointer pages: 1, data page slots: 32 
    Data pages: 32, average fill: 32% 
    Primary pages: 31, secondary pages: 1, swept pages: 5 
    Empty pages: 13, full pages: 3 
    Fill distribution: 
     0 - 19% = 16 
    20 - 39% = 2 
    40 - 59% = 6 
    60 - 79% = 5 
    80 - 99% = 3 
 
    Index MONEY_TURNOVER_LOG_AGENT_OPTYPE (0) 
    Root page: 94847, depth: 2, leaf buckets: 2, nodes: 947 
    Average node length: 4.56, total dup: 849, max dup: 98 
    Average key length: 3.10, compression ratio: 6.13 
    Average prefix length: 18.01, average data length: 0.99 
    Clustering factor: 562, ratio: 0.59 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 1 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
MON_CACHE_MEMORY (165) 
    Primary pointer page: 555, Index root page: 556 
    Total formats: 2, used formats: 1 
    Average record length: 97.56, total records: 72 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 112.00, compression ratio: 1.15 
    Pointer pages: 1, data page slots: 2 
    Data pages: 2, average fill: 50% 
    Primary pages: 2, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 1 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 1 
    40 - 59% = 0 
    60 - 79% = 1 
    80 - 99% = 0 
 
    Index PK_MON_CACHE_MEMORY (0) 
    Root page: 1504238, depth: 1, leaf buckets: 1, nodes: 72 
    Average node length: 11.69, total dup: 0, max dup: 0 
    Average key length: 10.68, compression ratio: 0.84 
    Average prefix length: 1.31, average data length: 7.69 
    Clustering factor: 2, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
MON_LOG (162) 
    Primary pointer page: 548, Index root page: 549 
    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: 1504251, 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: 1504249, 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: 1504248, 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: 1504250, 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: 1504247, 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: 550, Index root page: 551 
    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: 1504246, 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: 1504244, 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: 1504243, 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: 1504245, 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: 1504242, 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: 496, Index root page: 497 
    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: 1544827, 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: 1544826, 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: 516, Index root page: 517 
    Total formats: 1, used formats: 1 
    Average record length: 36.04, total records: 797024 
    Average version length: 37.86, total versions: 33190, max versions: 2 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 54.00, compression ratio: 1.50 
    Pointer pages: 6, data page slots: 8408 
    Data pages: 8408, average fill: 65% 
    Primary pages: 8405, secondary pages: 3, swept pages: 1568 
    Empty pages: 20, full pages: 6452 
    Fill distribution: 
     0 - 19% = 56 
    20 - 39% = 95 
    40 - 59% = 616 
    60 - 79% = 7582 
    80 - 99% = 59 
 
    Index PDISTR_AGENT_ID (2) 
    Root page: 1509330, depth: 2, leaf buckets: 872, nodes: 779353 
    Average node length: 4.88, total dup: 779304, max dup: 143343 
    Average key length: 2.01, compression ratio: 4.48 
    Average prefix length: 8.99, average data length: 0.01 
    Clustering factor: 89174, ratio: 0.11 
    Fill distribution: 
         0 - 19% = 3 
        20 - 39% = 163 
        40 - 59% = 461 
        60 - 79% = 158 
        80 - 99% = 87 
 
    Index PDISTR_SNDOP_RCVOP_SNDID_ASC (0) 
    Root page: 1508635, depth: 3, leaf buckets: 934, nodes: 779353 
    Average node length: 5.88, total dup: 693954, max dup: 42 
    Average key length: 3.02, compression ratio: 7.29 
    Average prefix length: 21.09, average data length: 0.91 
    Clustering factor: 157801, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 76 
        40 - 59% = 480 
        60 - 79% = 114 
        80 - 99% = 262 
 
    Index PDISTR_SNDOP_RCVOP_SNDID_DESC (1) 
    Root page: 1509209, depth: 3, leaf buckets: 960, nodes: 779353 
    Average node length: 5.88, total dup: 693954, max dup: 42 
    Average key length: 3.02, compression ratio: 7.29 
    Average prefix length: 21.09, average data length: 0.91 
    Clustering factor: 159736, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 121 
        40 - 59% = 471 
        60 - 79% = 98 
        80 - 99% = 269 
 
    Index PDISTR_WORKER_SND_ID (3) 
    Root page: 1510200, depth: 3, leaf buckets: 1127, nodes: 779353 
    Average node length: 5.97, total dup: 693954, max dup: 42 
    Average key length: 3.10, compression ratio: 5.48 
    Average prefix length: 16.01, average data length: 0.99 
    Clustering factor: 152215, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 257 
        40 - 59% = 611 
        60 - 79% = 190 
        80 - 99% = 69 
 
PERF_AGG (158) 
    Primary pointer page: 540, Index root page: 541 
    Total formats: 1, used formats: 1 
    Average record length: 62.80, total records: 5480 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 3.17, total fragments: 18, max fragments: 1 
    Average unpacked length: 379.00, compression ratio: 6.04 
    Pointer pages: 1, data page slots: 88 
    Data pages: 88, average fill: 61% 
    Primary pages: 75, secondary pages: 13, swept pages: 58 
    Empty pages: 9, full pages: 60 
    Fill distribution: 
     0 - 19% = 13 
    20 - 39% = 0 
    40 - 59% = 3 
    60 - 79% = 72 
    80 - 99% = 0 
 
    Index PERF_AGG_UNQ (1) 
    Root page: 1504260, depth: 2, leaf buckets: 7, nodes: 5480 
    Average node length: 5.49, total dup: 0, max dup: 0 
    Average key length: 3.58, compression ratio: 10.04 
    Average prefix length: 34.44, average data length: 1.55 
    Clustering factor: 5282, ratio: 0.96 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 4 
        60 - 79% = 1 
        80 - 99% = 1 
 
    Index PK_PERF_AGG (0) 
    Root page: 1504255, depth: 2, leaf buckets: 10, nodes: 5480 
    Average node length: 11.12, 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: 168, 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: 399, Index root page: 434 
    Total formats: 1, used formats: 1 
    Average record length: 39.08, total records: 80500 
    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: 840 
    Data pages: 840, average fill: 66% 
    Primary pages: 840, secondary pages: 0, swept pages: 0 
    Empty pages: 2, full pages: 836 
    Fill distribution: 
     0 - 19% = 3 
    20 - 39% = 1 
    40 - 59% = 0 
    60 - 79% = 836 
    80 - 99% = 0 
 
    Index PK_PERF_ESTIMATED (0) 
    Root page: 33936, depth: 2, leaf buckets: 104, nodes: 80500 
    Average node length: 10.16, total dup: 0, max dup: 0 
    Average key length: 8.17, compression ratio: 1.10 
    Average prefix length: 3.83, average data length: 5.17 
    Clustering factor: 3235, ratio: 0.04 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 0 
        40 - 59% = 5 
        60 - 79% = 0 
        80 - 99% = 99 
 
PERF_ISQL_STAT (156) 
    Primary pointer page: 536, Index root page: 537 
    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: 1504261, 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: 542, Index root page: 543 
    Total formats: 1, used formats: 1 
    Average record length: 111.07, total records: 71 
    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: 56% 
    Primary pages: 2, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 1 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 1 
    40 - 59% = 0 
    60 - 79% = 1 
    80 - 99% = 0 
 
PERF_SPLIT_0 (281) 
    Primary pointer page: 601, Index root page: 602 
    Total formats: 1, used formats: 1 
    Average record length: 147.97, total records: 149997 
    Average version length: 153.12, total versions: 2948, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.46 
    Pointer pages: 5, data page slots: 4736 
    Data pages: 3752, average fill: 82% 
    Primary pages: 3751, secondary pages: 1, swept pages: 5 
    Empty pages: 60, full pages: 3666 
    Fill distribution: 
     0 - 19% = 68 
    20 - 39% = 2 
    40 - 59% = 10 
    60 - 79% = 7 
    80 - 99% = 3665 
 
PERF_SPLIT_1 (282) 
    Primary pointer page: 603, Index root page: 604 
    Total formats: 1, used formats: 1 
    Average record length: 148.81, total records: 137127 
    Average version length: 151.96, total versions: 1921, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.40 
    Pointer pages: 6, data page slots: 3672 
    Data pages: 3424, average fill: 82% 
    Primary pages: 3421, secondary pages: 3, swept pages: 10 
    Empty pages: 49, full pages: 3356 
    Fill distribution: 
     0 - 19% = 55 
    20 - 39% = 8 
    40 - 59% = 2 
    60 - 79% = 6 
    80 - 99% = 3353 
 
PERF_SPLIT_2 (283) 
    Primary pointer page: 605, Index root page: 606 
    Total formats: 1, used formats: 1 
    Average record length: 150.06, total records: 144252 
    Average version length: 150.88, total versions: 991, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.30 
    Pointer pages: 7, data page slots: 6064 
    Data pages: 3592, average fill: 83% 
    Primary pages: 3591, secondary pages: 1, swept pages: 2 
    Empty pages: 40, full pages: 3532 
    Fill distribution: 
     0 - 19% = 45 
    20 - 39% = 3 
    40 - 59% = 7 
    60 - 79% = 5 
    80 - 99% = 3532 
 
PERF_SPLIT_3 (284) 
    Primary pointer page: 607, Index root page: 608 
    Total formats: 1, used formats: 1 
    Average record length: 150.25, total records: 138593 
    Average version length: 150.15, total versions: 878, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.29 
    Pointer pages: 8, data page slots: 6152 
    Data pages: 3520, average fill: 81% 
    Primary pages: 3518, secondary pages: 2, swept pages: 10 
    Empty pages: 100, full pages: 3391 
    Fill distribution: 
     0 - 19% = 110 
    20 - 39% = 4 
    40 - 59% = 6 
    60 - 79% = 9 
    80 - 99% = 3391 
 
PERF_SPLIT_4 (285) 
    Primary pointer page: 609, Index root page: 610 
    Total formats: 1, used formats: 1 
    Average record length: 149.98, total records: 140658 
    Average version length: 152.02, total versions: 1461, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.31 
    Pointer pages: 7, data page slots: 4888 
    Data pages: 3504, average fill: 83% 
    Primary pages: 3504, secondary pages: 0, swept pages: 1 
    Empty pages: 38, full pages: 3454 
    Fill distribution: 
     0 - 19% = 40 
    20 - 39% = 3 
    40 - 59% = 2 
    60 - 79% = 5 
    80 - 99% = 3454 
 
PERF_SPLIT_5 (286) 
    Primary pointer page: 611, Index root page: 612 
    Total formats: 1, used formats: 1 
    Average record length: 149.92, total records: 135999 
    Average version length: 152.56, total versions: 1231, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.31 
    Pointer pages: 6, data page slots: 4016 
    Data pages: 3376, average fill: 83% 
    Primary pages: 3374, secondary pages: 2, swept pages: 4 
    Empty pages: 29, full pages: 3335 
    Fill distribution: 
     0 - 19% = 33 
    20 - 39% = 2 
    40 - 59% = 3 
    60 - 79% = 2 
    80 - 99% = 3336 
 
PERF_SPLIT_6 (287) 
    Primary pointer page: 613, Index root page: 614 
    Total formats: 1, used formats: 1 
    Average record length: 147.22, total records: 141608 
    Average version length: 153.37, total versions: 3452, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.52 
    Pointer pages: 5, data page slots: 4768 
    Data pages: 3528, average fill: 83% 
    Primary pages: 3526, secondary pages: 2, swept pages: 7 
    Empty pages: 48, full pages: 3467 
    Fill distribution: 
     0 - 19% = 53 
    20 - 39% = 4 
    40 - 59% = 4 
    60 - 79% = 0 
    80 - 99% = 3467 
 
PERF_SPLIT_7 (288) 
    Primary pointer page: 615, Index root page: 616 
    Total formats: 1, used formats: 1 
    Average record length: 135.72, total records: 163021 
    Average version length: 154.91, total versions: 17686, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 12.50 
    Pointer pages: 7, data page slots: 5080 
    Data pages: 4032, average fill: 85% 
    Primary pages: 4031, secondary pages: 1, swept pages: 4 
    Empty pages: 20, full pages: 4005 
    Fill distribution: 
     0 - 19% = 21 
    20 - 39% = 1 
    40 - 59% = 4 
    60 - 79% = 1 
    80 - 99% = 4005 
 
PERF_SPLIT_8 (289) 
    Primary pointer page: 617, Index root page: 618 
    Total formats: 1, used formats: 1 
    Average record length: 148.75, total records: 145274 
    Average version length: 153.55, total versions: 2489, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.40 
    Pointer pages: 8, data page slots: 4544 
    Data pages: 3648, average fill: 82% 
    Primary pages: 3646, secondary pages: 2, swept pages: 6 
    Empty pages: 67, full pages: 3561 
    Fill distribution: 
     0 - 19% = 70 
    20 - 39% = 6 
    40 - 59% = 6 
    60 - 79% = 5 
    80 - 99% = 3561 
 
PERF_SPLIT_9 (290) 
    Primary pointer page: 619, Index root page: 620 
    Total formats: 1, used formats: 1 
    Average record length: 148.69, total records: 148721 
    Average version length: 153.15, total versions: 2826, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.41 
    Pointer pages: 7, data page slots: 4072 
    Data pages: 3688, average fill: 83% 
    Primary pages: 3686, secondary pages: 2, swept pages: 5 
    Empty pages: 23, full pages: 3653 
    Fill distribution: 
     0 - 19% = 25 
    20 - 39% = 5 
    40 - 59% = 5 
    60 - 79% = 0 
    80 - 99% = 3653 
 
PHRASES (143) 
    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 
 
    Index PHRASES_ID_DESC (3) 
    Root page: 1510376, 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: 1510375, 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: 1510374, 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: 1510373, 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: 518, Index root page: 519 
    Total formats: 1, used formats: 1 
    Average record length: 52.21, total records: 2110875 
    Average version length: 52.86, total versions: 25897, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 70.00, compression ratio: 1.34 
    Pointer pages: 16, data page slots: 25904 
    Data pages: 25896, average fill: 70% 
    Primary pages: 25882, secondary pages: 14, swept pages: 11185 
    Empty pages: 156, full pages: 22560 
    Fill distribution: 
     0 - 19% = 320 
    20 - 39% = 266 
    40 - 59% = 803 
    60 - 79% = 24263 
    80 - 99% = 244 
 
    Index PSTORNED_RCV_ID (1) 
    Root page: 1506208, depth: 3, leaf buckets: 2613, nodes: 2110875 
    Average node length: 5.44, total dup: 1969191, max dup: 1492 
    Average key length: 2.49, compression ratio: 3.62 
    Average prefix length: 8.58, average data length: 0.42 
    Clustering factor: 183186, ratio: 0.09 
    Fill distribution: 
         0 - 19% = 5 
        20 - 39% = 300 
        40 - 59% = 1738 
        60 - 79% = 290 
        80 - 99% = 280 
 
    Index PSTORNED_SND_ID (0) 
    Root page: 1504841, depth: 3, leaf buckets: 2757, nodes: 2110875 
    Average node length: 5.69, total dup: 1894833, max dup: 64 
    Average key length: 2.74, compression ratio: 3.29 
    Average prefix length: 8.36, average data length: 0.64 
    Clustering factor: 377866, ratio: 0.18 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 6 
        40 - 59% = 2422 
        60 - 79% = 303 
        80 - 99% = 26 
 
    Index PSTORNED_WORKER_ID (2) 
    Root page: 1508018, depth: 3, leaf buckets: 2133, nodes: 2110875 
    Average node length: 4.96, total dup: 2110775, max dup: 26215 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.41, average data length: 0.00 
    Clustering factor: 181128, ratio: 0.09 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 194 
        40 - 59% = 1131 
        60 - 79% = 364 
        80 - 99% = 443 
 
RULES_FOR_PDISTR (148) 
    Primary pointer page: 520, Index root page: 521 
    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: 1504339, 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: 498, Index root page: 499 
    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: 1544825, 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: 1544824, 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: 528, Index root page: 529 
    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: 1504327, 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: 1504328, 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: 494, Index root page: 495 
    Total formats: 1, used formats: 1 
    Average record length: 97.62, 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: 1 
    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: 1544931, 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: 1544828, 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: 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 TMP_DEP_DOCS_UNQ (0) 
    Root page: 1544832, 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: 488, Index root page: 489 
    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: 1544829, 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: 490, Index root page: 491 
    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: 492, Index root page: 493 
    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: 546, Index root page: 547 
    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: 544, Index root page: 545 
    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: 1504252, 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: 486, Index root page: 487 
    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: 484, Index root page: 485 
    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: 1544831, 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: 1544830, 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: 480, Index root page: 481 
    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: 1544833, 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: 557, Index root page: 558 
    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: 1504237, 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: 538, Index root page: 539 
    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: 508, Index root page: 509 
    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: 1552183, 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: 1510377, 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: 1510382, 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: 1510380, 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: 526, Index root page: 527 
    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: 1504329, 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: 1504330, 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: 577, Index root page: 578 
    Total formats: 1, used formats: 1 
    Average record length: 43.88, total records: 136891 
    Average version length: 69.17, total versions: 57613, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 2.87 
    Pointer pages: 3, data page slots: 4400 
    Data pages: 3456, average fill: 48% 
    Primary pages: 3455, secondary pages: 1, swept pages: 624 
    Empty pages: 743, full pages: 1649 
    Fill distribution: 
     0 - 19% = 1163 
    20 - 39% = 332 
    40 - 59% = 205 
    60 - 79% = 792 
    80 - 99% = 964 
 
    Index XQD_1000_1200_WA_SO_RO_WKR_SND (0) 
    Root page: 1562632, depth: 3, leaf buckets: 235, nodes: 136891 
    Average node length: 6.43, total dup: 118989, max dup: 25 
    Average key length: 3.97, compression ratio: 10.58 
    Average prefix length: 40.16, average data length: 1.84 
    Clustering factor: 24127, ratio: 0.18 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 82 
        40 - 59% = 109 
        60 - 79% = 40 
        80 - 99% = 4 
 
XQD_1000_3300 (178) 
    Primary pointer page: 581, Index root page: 582 
    Total formats: 1, used formats: 1 
    Average record length: 65.35, total records: 7023785 
    Average version length: 68.79, total versions: 421933, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.93 
    Pointer pages: 65, data page slots: 105912 
    Data pages: 105912, average fill: 71% 
    Primary pages: 105911, secondary pages: 1, swept pages: 17911 
    Empty pages: 37, full pages: 73561 
    Fill distribution: 
     0 - 19% = 282 
    20 - 39% = 1123 
    40 - 59% = 7063 
    60 - 79% = 96105 
    80 - 99% = 1339 
 
    Index XQD_1000_3300_WA_SO_RO_WKR_SND (0) 
    Root page: 1480476, depth: 3, leaf buckets: 10698, nodes: 7023785 
    Average node length: 6.51, total dup: 6073837, max dup: 29 
    Average key length: 3.52, compression ratio: 11.92 
    Average prefix length: 40.61, average data length: 1.39 
    Clustering factor: 1650705, ratio: 0.24 
    Fill distribution: 
         0 - 19% = 13 
        20 - 39% = 1749 
        40 - 59% = 5827 
        60 - 79% = 2597 
        80 - 99% = 512 
 
    Index XQD_1000_3300_WKR_DOC_ASC (1) 
    Root page: 1486090, depth: 3, leaf buckets: 8714, nodes: 7023785 
    Average node length: 5.40, total dup: 6742734, max dup: 137 
    Average key length: 2.41, compression ratio: 7.06 
    Average prefix length: 16.63, average data length: 0.37 
    Clustering factor: 1455498, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 14 
        20 - 39% = 1254 
        40 - 59% = 5178 
        60 - 79% = 1331 
        80 - 99% = 937 
 
    Index XQD_1000_3300_WKR_DOC_DEC (2) 
    Root page: 1490630, depth: 3, leaf buckets: 8766, nodes: 7023785 
    Average node length: 5.40, total dup: 6742734, max dup: 137 
    Average key length: 2.41, compression ratio: 7.06 
    Average prefix length: 16.63, average data length: 0.37 
    Clustering factor: 1457898, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 9 
        20 - 39% = 1329 
        40 - 59% = 5150 
        60 - 79% = 1381 
        80 - 99% = 897 
 
XQD_1200_2000 (177) 
    Primary pointer page: 579, Index root page: 580 
    Total formats: 1, used formats: 1 
    Average record length: 67.29, total records: 12013056 
    Average version length: 68.74, total versions: 332274, 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: 107, data page slots: 174072 
    Data pages: 174072, average fill: 73% 
    Primary pages: 174071, secondary pages: 1, swept pages: 61005 
    Empty pages: 8, full pages: 156200 
    Fill distribution: 
     0 - 19% = 73 
    20 - 39% = 745 
    40 - 59% = 4881 
    60 - 79% = 166451 
    80 - 99% = 1922 
 
    Index XQD_1200_2000_WA_SO_RO_WKR_SND (0) 
    Root page: 1495050, depth: 3, leaf buckets: 18474, nodes: 12011017 
    Average node length: 6.60, total dup: 10470227, max dup: 62 
    Average key length: 3.43, compression ratio: 12.26 
    Average prefix length: 40.70, average data length: 1.30 
    Clustering factor: 2470018, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 29 
        20 - 39% = 2359 
        40 - 59% = 11014 
        60 - 79% = 4331 
        80 - 99% = 741 
 
XQD_2000_3300 (179) 
    Primary pointer page: 583, Index root page: 584 
    Total formats: 1, used formats: 1 
    Average record length: 48.76, total records: 1538524 
    Average version length: 69.10, total versions: 362706, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 2.58 
    Pointer pages: 31, data page slots: 48936 
    Data pages: 28949, average fill: 57% 
    Primary pages: 28871, secondary pages: 78, swept pages: 7233 
    Empty pages: 3232, full pages: 18308 
    Fill distribution: 
     0 - 19% = 5037 
    20 - 39% = 3441 
    40 - 59% = 2591 
    60 - 79% = 13003 
    80 - 99% = 4877 
 
    Index XQD_2000_3300_WA_SO_RO_WKR_SND (0) 
    Root page: 1479735, depth: 3, leaf buckets: 1891, nodes: 1379637 
    Average node length: 5.52, total dup: 1324008, max dup: 49 
    Average key length: 2.57, compression ratio: 16.36 
    Average prefix length: 41.47, average data length: 0.53 
    Clustering factor: 94891, ratio: 0.07 
    Fill distribution: 
         0 - 19% = 11 
        20 - 39% = 482 
        40 - 59% = 925 
        60 - 79% = 398 
        80 - 99% = 75 
 
XQD_2100_3300 (180) 
    Primary pointer page: 585, Index root page: 586 
    Total formats: 1, used formats: 1 
    Average record length: 40.98, total records: 1124809 
    Average version length: 69.04, total versions: 147977, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 3.07 
    Pointer pages: 21, data page slots: 34016 
    Data pages: 27368, average fill: 36% 
    Primary pages: 27367, secondary pages: 1, swept pages: 6567 
    Empty pages: 4854, full pages: 9933 
    Fill distribution: 
     0 - 19% = 8872 
    20 - 39% = 5533 
    40 - 59% = 6146 
    60 - 79% = 6500 
    80 - 99% = 317 
 
    Index XQD_2100_3300_WA_SO_RO_WKR_SND (0) 
    Root page: 1479229, depth: 3, leaf buckets: 1172, nodes: 747509 
    Average node length: 5.94, total dup: 688266, max dup: 69 
    Average key length: 3.01, compression ratio: 13.94 
    Average prefix length: 41.06, average data length: 0.94 
    Clustering factor: 106671, ratio: 0.14 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 381 
        40 - 59% = 579 
        60 - 79% = 201 
        80 - 99% = 11 
 
XQD_3300_3400 (181) 
    Primary pointer page: 587, Index root page: 588 
    Total formats: 1, used formats: 1 
    Average record length: 66.77, total records: 9185666 
    Average version length: 68.97, total versions: 322998, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.89 
    Pointer pages: 91, data page slots: 147040 
    Data pages: 147008, average fill: 67% 
    Primary pages: 146986, secondary pages: 22, swept pages: 56146 
    Empty pages: 430, full pages: 75705 
    Fill distribution: 
     0 - 19% = 1379 
    20 - 39% = 6326 
    40 - 59% = 23571 
    60 - 79% = 113824 
    80 - 99% = 1908 
 
    Index XQD_3300_3400_WA_SO_RO_WKR_SND (0) 
    Root page: 1472612, depth: 3, leaf buckets: 13473, nodes: 9182487 
    Average node length: 6.70, total dup: 7614126, max dup: 14 
    Average key length: 3.67, compression ratio: 11.44 
    Average prefix length: 40.50, average data length: 1.50 
    Clustering factor: 2081202, ratio: 0.23 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 1381 
        40 - 59% = 6623 
        60 - 79% = 4791 
        80 - 99% = 677 
 
XQS_1000_1200 (182) 
    Primary pointer page: 589, Index root page: 590 
    Total formats: 1, used formats: 1 
    Average record length: 82.50, total records: 21164031 
    Average version length: 82.95, total versions: 10891, 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: 197, data page slots: 319888 
    Data pages: 319888, average fill: 81% 
    Primary pages: 319883, secondary pages: 5, swept pages: 12594 
    Empty pages: 6, full pages: 319876 
    Fill distribution: 
     0 - 19% = 8 
    20 - 39% = 2 
    40 - 59% = 1 
    60 - 79% = 49620 
    80 - 99% = 270257 
 
    Index XQS_1000_1200_DOC_ID (1) 
    Root page: 1426738, depth: 3, leaf buckets: 19527, nodes: 21164031 
    Average node length: 5.72, total dup: 20682771, max dup: 153 
    Average key length: 2.16, compression ratio: 4.16 
    Average prefix length: 8.86, average data length: 0.14 
    Clustering factor: 3286518, ratio: 0.16 
    Fill distribution: 
         0 - 19% = 5 
        20 - 39% = 1 
        40 - 59% = 8393 
        60 - 79% = 553 
        80 - 99% = 10575 
 
    Index XQS_1000_1200_RCV_ID (3) 
    Root page: 1457002, depth: 3, leaf buckets: 17203, nodes: 21164031 
    Average node length: 6.31, total dup: 18599510, max dup: 49 
    Average key length: 2.75, compression ratio: 3.27 
    Average prefix length: 8.37, average data length: 0.63 
    Clustering factor: 918143, ratio: 0.04 
    Fill distribution: 
         0 - 19% = 9 
        20 - 39% = 2 
        40 - 59% = 803 
        60 - 79% = 274 
        80 - 99% = 16115 
 
    Index XQS_1000_1200_SND_ID (2) 
    Root page: 1441095, depth: 3, leaf buckets: 21289, nodes: 21164031 
    Average node length: 6.35, total dup: 18518046, max dup: 29 
    Average key length: 2.79, compression ratio: 3.23 
    Average prefix length: 8.34, average data length: 0.66 
    Clustering factor: 3580551, ratio: 0.17 
    Fill distribution: 
         0 - 19% = 4 
        20 - 39% = 2 
        40 - 59% = 8614 
        60 - 79% = 625 
        80 - 99% = 12044 
 
    Index XQS_1000_1200_WORKER_ID (0) 
    Root page: 1413370, depth: 3, leaf buckets: 16198, nodes: 21164031 
    Average node length: 5.56, total dup: 21163931, max dup: 230095 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.42, average data length: 0.00 
    Clustering factor: 946818, ratio: 0.04 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 14 
        40 - 59% = 3028 
        60 - 79% = 427 
        80 - 99% = 12727 
 
XQS_1000_3300 (184) 
    Primary pointer page: 593, Index root page: 594 
    Total formats: 1, used formats: 1 
    Average record length: 80.10, total records: 9625825 
    Average version length: 82.60, total versions: 303206, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.57 
    Pointer pages: 107, data page slots: 174320 
    Data pages: 174280, average fill: 68% 
    Primary pages: 174243, secondary pages: 37, swept pages: 84246 
    Empty pages: 497, full pages: 92968 
    Fill distribution: 
     0 - 19% = 1695 
    20 - 39% = 8041 
    40 - 59% = 29759 
    60 - 79% = 116470 
    80 - 99% = 18315 
 
    Index XQS_1000_3300_DOC_ID (1) 
    Root page: 1367524, depth: 3, leaf buckets: 11360, nodes: 9625825 
    Average node length: 5.38, total dup: 9317601, max dup: 207 
    Average key length: 2.23, compression ratio: 4.03 
    Average prefix length: 8.80, average data length: 0.20 
    Clustering factor: 2158837, ratio: 0.22 
    Fill distribution: 
         0 - 19% = 3 
        20 - 39% = 93 
        40 - 59% = 8230 
        60 - 79% = 2978 
        80 - 99% = 56 
 
    Index XQS_1000_3300_RCV_ID (3) 
    Root page: 1379283, depth: 3, leaf buckets: 13465, nodes: 9625825 
    Average node length: 6.25, total dup: 7977277, max dup: 14 
    Average key length: 3.10, compression ratio: 2.90 
    Average prefix length: 8.07, average data length: 0.93 
    Clustering factor: 1510655, ratio: 0.16 
    Fill distribution: 
         0 - 19% = 130 
        20 - 39% = 3873 
        40 - 59% = 4460 
        60 - 79% = 2526 
        80 - 99% = 2476 
 
    Index XQS_1000_3300_SND_ID (2) 
    Root page: 1373081, depth: 3, leaf buckets: 12686, nodes: 9625825 
    Average node length: 6.00, total dup: 8350758, max dup: 42 
    Average key length: 2.85, compression ratio: 3.16 
    Average prefix length: 8.28, average data length: 0.72 
    Clustering factor: 2347000, ratio: 0.24 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 101 
        40 - 59% = 9260 
        60 - 79% = 3249 
        80 - 99% = 74 
 
    Index XQS_1000_3300_WORKER_ID (0) 
    Root page: 1362789, depth: 3, leaf buckets: 10282, nodes: 9625825 
    Average node length: 5.15, total dup: 9625725, max dup: 149409 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.42, average data length: 0.00 
    Clustering factor: 1544557, ratio: 0.16 
    Fill distribution: 
         0 - 19% = 41 
        20 - 39% = 1330 
        40 - 59% = 5206 
        60 - 79% = 1794 
        80 - 99% = 1911 
 
XQS_1200_2000 (183) 
    Primary pointer page: 591, Index root page: 592 
    Total formats: 1, used formats: 1 
    Average record length: 80.72, total records: 11298890 
    Average version length: 82.58, total versions: 243814, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.56 
    Pointer pages: 120, data page slots: 195232 
    Data pages: 193736, average fill: 72% 
    Primary pages: 193625, secondary pages: 111, swept pages: 70895 
    Empty pages: 3035, full pages: 146142 
    Fill distribution: 
     0 - 19% = 5113 
    20 - 39% = 7756 
    40 - 59% = 18158 
    60 - 79% = 100412 
    80 - 99% = 62297 
 
    Index XQS_1200_2000_DOC_ID (1) 
    Root page: 1392123, depth: 3, leaf buckets: 13130, nodes: 11298890 
    Average node length: 5.30, total dup: 11189060, max dup: 621 
    Average key length: 2.08, compression ratio: 4.33 
    Average prefix length: 8.93, average data length: 0.07 
    Clustering factor: 2363577, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 117 
        40 - 59% = 9207 
        60 - 79% = 3709 
        80 - 99% = 96 
 
    Index XQS_1200_2000_RCV_ID (3) 
    Root page: 1406132, depth: 3, leaf buckets: 10451, nodes: 11298890 
    Average node length: 5.50, total dup: 10805114, max dup: 49 
    Average key length: 2.28, compression ratio: 3.95 
    Average prefix length: 8.77, average data length: 0.23 
    Clustering factor: 720988, ratio: 0.06 
    Fill distribution: 
         0 - 19% = 161 
        20 - 39% = 861 
        40 - 59% = 2553 
        60 - 79% = 1848 
        80 - 99% = 5028 
 
    Index XQS_1200_2000_SND_ID (2) 
    Root page: 1398660, depth: 3, leaf buckets: 15014, nodes: 11298890 
    Average node length: 6.03, total dup: 9859409, max dup: 64 
    Average key length: 2.81, compression ratio: 3.21 
    Average prefix length: 8.32, average data length: 0.68 
    Clustering factor: 2379967, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 150 
        40 - 59% = 10723 
        60 - 79% = 4028 
        80 - 99% = 112 
 
    Index XQS_1200_2000_WORKER_ID (0) 
    Root page: 1386233, depth: 3, leaf buckets: 10801, nodes: 11298890 
    Average node length: 5.22, total dup: 11298790, max dup: 185186 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.42, average data length: 0.00 
    Clustering factor: 709612, ratio: 0.06 
    Fill distribution: 
         0 - 19% = 103 
        20 - 39% = 858 
        40 - 59% = 4793 
        60 - 79% = 1521 
        80 - 99% = 3526 
 
XQS_2000_3300 (185) 
    Primary pointer page: 595, Index root page: 596 
    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: 1361775, 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: 1361777, 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: 1361776, 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: 1361774, 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: 597, Index root page: 598 
    Total formats: 1, used formats: 1 
    Average record length: 80.47, total records: 9737830 
    Average version length: 82.90, total versions: 299217, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.57 
    Pointer pages: 109, data page slots: 177616 
    Data pages: 177528, average fill: 68% 
    Primary pages: 177493, secondary pages: 35, swept pages: 88034 
    Empty pages: 555, full pages: 92375 
    Fill distribution: 
     0 - 19% = 1709 
    20 - 39% = 8553 
    40 - 59% = 31182 
    60 - 79% = 117870 
    80 - 99% = 18214 
 
    Index XQS_2100_3300_DOC_ID (1) 
    Root page: 1344708, depth: 3, leaf buckets: 11852, nodes: 9737830 
    Average node length: 5.19, total dup: 9708743, max dup: 2123 
    Average key length: 2.03, compression ratio: 4.43 
    Average prefix length: 8.97, average data length: 0.03 
    Clustering factor: 1987065, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 29 
        20 - 39% = 1530 
        40 - 59% = 7898 
        60 - 79% = 1823 
        80 - 99% = 572 
 
    Index XQS_2100_3300_RCV_ID (3) 
    Root page: 1355739, depth: 3, leaf buckets: 13567, nodes: 9737830 
    Average node length: 6.26, total dup: 8069856, max dup: 14 
    Average key length: 3.10, compression ratio: 2.90 
    Average prefix length: 8.07, average data length: 0.93 
    Clustering factor: 1488482, ratio: 0.15 
    Fill distribution: 
         0 - 19% = 172 
        20 - 39% = 3792 
        40 - 59% = 4488 
        60 - 79% = 2520 
        80 - 99% = 2595 
 
    Index XQS_2100_3300_SND_ID (2) 
    Root page: 1350071, depth: 3, leaf buckets: 12446, nodes: 9737830 
    Average node length: 5.45, total dup: 9299255, max dup: 99 
    Average key length: 2.29, compression ratio: 3.93 
    Average prefix length: 8.76, average data length: 0.24 
    Clustering factor: 2118020, ratio: 0.22 
    Fill distribution: 
         0 - 19% = 25 
        20 - 39% = 1446 
        40 - 59% = 8749 
        60 - 79% = 1637 
        80 - 99% = 589 
 
    Index XQS_2100_3300_WORKER_ID (0) 
    Root page: 987843, depth: 3, leaf buckets: 10400, nodes: 9737830 
    Average node length: 5.16, total dup: 9737730, max dup: 151368 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.42, average data length: 0.00 
    Clustering factor: 1580018, ratio: 0.16 
    Fill distribution: 
         0 - 19% = 36 
        20 - 39% = 1383 
        40 - 59% = 5217 
        60 - 79% = 1751 
        80 - 99% = 2013 
 
XQS_3300_3400 (187) 
    Primary pointer page: 599, Index root page: 600 
    Total formats: 1, used formats: 1 
    Average record length: 67.78, total records: 583046 
    Average version length: 68.78, total versions: 3922, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.86 
    Pointer pages: 5, data page slots: 8160 
    Data pages: 8160, average fill: 75% 
    Primary pages: 8160, secondary pages: 0, swept pages: 3504 
    Empty pages: 7, full pages: 7285 
    Fill distribution: 
     0 - 19% = 12 
    20 - 39% = 7 
    40 - 59% = 148 
    60 - 79% = 7952 
    80 - 99% = 41 
 
    Index XQS_3300_3400_DOC_ID (1) 
    Root page: 45798, depth: 3, leaf buckets: 746, nodes: 583046 
    Average node length: 5.95, total dup: 496590, max dup: 83 
    Average key length: 3.09, compression ratio: 2.91 
    Average prefix length: 8.06, average data length: 0.94 
    Clustering factor: 102002, ratio: 0.17 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 25 
        40 - 59% = 535 
        60 - 79% = 101 
        80 - 99% = 85 
 
    Index XQS_3300_3400_SND_ID (2) 
    Root page: 30313, depth: 3, leaf buckets: 768, nodes: 583046 
    Average node length: 6.15, total dup: 478273, max dup: 23 
    Average key length: 3.29, compression ratio: 2.73 
    Average prefix length: 7.89, average data length: 1.11 
    Clustering factor: 102042, ratio: 0.18 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 20 
        40 - 59% = 555 
        60 - 79% = 102 
        80 - 99% = 91 
 
    Index XQS_3300_3400_WORKER_ID (0) 
    Root page: 377587, depth: 2, leaf buckets: 563, nodes: 583046 
    Average node length: 4.86, total dup: 582946, max dup: 9491 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.41, average data length: 0.00 
    Clustering factor: 90716, ratio: 0.16 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 29 
        40 - 59% = 326 
        60 - 79% = 62 
        80 - 99% = 146 
 
ZDOC_DATA (170) 
    Primary pointer page: 565, Index root page: 566 
    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: 563, Index root page: 564 
    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: 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 
 
ZPDISTR (174) 
    Primary pointer page: 573, Index root page: 574 
    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: 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 
 
ZPSTORNED (175) 
    Primary pointer page: 575, Index root page: 576 
    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: 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 
 
ZQDISTR (172) 
    Primary pointer page: 569, Index root page: 570 
    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: 1504235, 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: 1504236, 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: 571, Index root page: 572 
    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: 1504232, 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: 1504231, 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: 1504234, 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: 1504233, 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: 561, Index root page: 562 
    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: 559, Index root page: 560 
    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: 512, Index root page: 513 
    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: 1510372, 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 Mon Feb 19 04:09:45 2024

Record versions statistics, table

TABLE_NAME TOTAL_RECS TOTAL_VERS MAX_VERSIONS VERS_TO_RECS_PRC MAXV_TO_VERS_PRC
DOC_DATA 7761827 63588 1 0.0000 0.0000
DOC_LIST 2249878 32906 2 0.0000 0.0000
FB_ERRORS 2182 757 1 0.0000 0.0000
INVNT_SALDO 400 3965 11 900.0000 0.0000
INVNT_TURNOVER_LOG 57986 54849 1 0.0000 0.0000
MONEY_SALDO 49 253 8 500.0000 0.0000
MONEY_TURNOVER_LOG 947 889 1 0.0000 0.0000
PDISTR 797024 33190 2 0.0000 0.0000
PERF_SPLIT_0 149997 2948 1 0.0000 0.0000
PERF_SPLIT_1 137127 1921 1 0.0000 0.0000
PERF_SPLIT_2 144252 991 1 0.0000 0.0000
PERF_SPLIT_3 138593 878 1 0.0000 0.0000
PERF_SPLIT_4 140658 1461 1 0.0000 0.0000
PERF_SPLIT_5 135999 1231 1 0.0000 0.0000
PERF_SPLIT_6 141608 3452 1 0.0000 0.0000
PERF_SPLIT_7 163021 17686 1 0.0000 0.0000
PERF_SPLIT_8 145274 2489 1 0.0000 0.0000
PERF_SPLIT_9 148721 2826 1 0.0000 0.0000
PSTORNED 2110875 25897 1 0.0000 0.0000
SEMAPHORES 5 1 1 0.0000 100.0000
XQD_1000_1200 136891 57613 1 0.0000 0.0000
XQD_1000_3300 7023785 421933 1 0.0000 0.0000
XQD_1200_2000 12013056 332274 1 0.0000 0.0000
XQD_2000_3300 1538524 362706 1 0.0000 0.0000
XQD_2100_3300 1124809 147977 1 0.0000 0.0000
XQD_3300_3400 9185666 322998 1 0.0000 0.0000
XQS_1000_1200 21164031 10891 1 0.0000 0.0000
XQS_1000_3300 9625825 303206 1 0.0000 0.0000
XQS_1200_2000 11298890 243814 1 0.0000 0.0000
XQS_2100_3300 9737830 299217 1 0.0000 0.0000
XQS_3300_3400 583046 3922 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 ---
:169: 
:170: mscs-test-161.budzdorov.ru    Mon Feb 19 04:08:01 2024
:171:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3400
:172: 
:173: 
:174: mscs-test-161.budzdorov.ru    Mon Feb 19 04:08:01 2024
:175:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3400
:176: 
:177: 
:178: mscs-test-161.budzdorov.ru    Mon Feb 19 04:08:01 2024
:179:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3400
:180: 
:181: 
:182: mscs-test-161.budzdorov.ru    Mon Feb 19 04:08:01 2024
:183:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3400
:184: 
--- end of diff output ---

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

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