Generated by /opt/oltp-emul/oltp_isql_run_worker.sh, ISQL session No. 1 of total launched 100. 13.04.2024 07: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 15487168 kB
MemAvailable 30031076 kB
Buffers 0 kB
Cached 16219976 kB
SwapCached 2748 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-04-13 07:07:58
DTS_END                         2024-04-13 07:07:50.7050
FB_GDSCODE                      -1
FB_MNEMONA                      
STACK                           SRV_FILL_MON_CACHE_MEMORY(20:5) ==> SP_CHECK_TO_STOP_WORK(32:12) ==> SP_HALT_ON_ERROR(68:17)
IP                              ::1/58820
TRN_ID                          176853
ATT_ID                          259
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: 8996.79 17323 899679
customer order: creation 181.16 374 18116
customer order: refuse 16.21 348 1621
order to supplier: creation 49.26 1289 4926
order to supplier: removal 3.81 89752 381
invoice (draft): creation 47.48 3200 4748
invoice (draft): removal 48.67 717 4867
invoice accept: apply 42.45 20590 4245
invoice accept: cancel 43.87 773 4387
customer reserve: creation 4011.31 201 401131
customer reserve: removal 4252.96 66 425296
realization accept: apply 88.56 184 8856
realization accept: cancel 75.96 122 7596
payment from customer: creation 61.80 132 6180
payment from customer: removal 6.26 78 626
payment to supplier: creation 52.00 134 5200
payment to supplier: removal 3.59 94 359
service: total inventory turnovers 4.37 3645 437
service: total monetary turnovers 6.18 614 618
service: aggregate perf. data 0.86 18268 86
service: refresh index statistics 0.03 205880 3

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:02, from 13-04-2024 07:08:50 to 13-04-2024 07:08:52.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 6465
TEST_TIME 2 5008
TEST_TIME 3 4660
TEST_TIME 4 4636
TEST_TIME 5 5428
TEST_TIME 6 6185
TEST_TIME 7 6040
TEST_TIME 8 6044
TEST_TIME 9 5971
TEST_TIME 10 5971
TEST_TIME 11 6308
TEST_TIME 12 6375
TEST_TIME 13 6619
TEST_TIME 14 6668
TEST_TIME 15 7297
TEST_TIME 16 7273
TEST_TIME 17 7306
TEST_TIME 18 7617
TEST_TIME 19 7909
TEST_TIME 20 7924
TEST_TIME 21 8407
TEST_TIME 22 8418
TEST_TIME 23 8695
TEST_TIME 24 9368
TEST_TIME 25 10030
TEST_TIME 26 10057
TEST_TIME 27 9740
TEST_TIME 28 9660
TEST_TIME 29 9551
TEST_TIME 30 9453
TEST_TIME 31 9251
TEST_TIME 32 9002
TEST_TIME 33 8902
TEST_TIME 34 8883
TEST_TIME 35 8826
TEST_TIME 36 8719
TEST_TIME 37 8582
TEST_TIME 38 8654
TEST_TIME 39 8757
TEST_TIME 40 8820
TEST_TIME 41 8800
TEST_TIME 42 8901
TEST_TIME 43 8848
TEST_TIME 44 8943
TEST_TIME 45 8975
TEST_TIME 46 9038
TEST_TIME 47 9107
TEST_TIME 48 9286
TEST_TIME 49 9183
TEST_TIME 50 9290
TEST_TIME 51 9217
TEST_TIME 52 9353
TEST_TIME 53 9278
TEST_TIME 54 9168
TEST_TIME 55 9100
TEST_TIME 56 9056
TEST_TIME 57 9056
TEST_TIME 58 9012
TEST_TIME 59 8933
TEST_TIME 60 8821
TEST_TIME 61 8873
TEST_TIME 62 8868
TEST_TIME 63 8947
TEST_TIME 64 8955
TEST_TIME 65 8962
TEST_TIME 66 9057
TEST_TIME 67 9117
TEST_TIME 68 9089
TEST_TIME 69 9113
TEST_TIME 70 9179
TEST_TIME 71 9221
TEST_TIME 72 9233
TEST_TIME 73 9137
TEST_TIME 74 9067
TEST_TIME 75 9089
TEST_TIME 76 8998
TEST_TIME 77 8919
TEST_TIME 78 8920
TEST_TIME 79 9026
TEST_TIME 80 9018
TEST_TIME 81 8998
TEST_TIME 82 9032
TEST_TIME 83 9035
TEST_TIME 84 9121
TEST_TIME 85 9099
TEST_TIME 86 9100
TEST_TIME 87 9091
TEST_TIME 88 9174
TEST_TIME 89 9210
TEST_TIME 90 9172
TEST_TIME 91 9107
TEST_TIME 92 9033
TEST_TIME 93 9043
TEST_TIME 94 9002
TEST_TIME 95 8982
TEST_TIME 96 8968
TEST_TIME 97 8942
TEST_TIME 98 8927
TEST_TIME 99 9043
TEST_TIME 100 9009

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:04, from 13-04-2024 07:08:53 to 13-04-2024 07:08:57.

Performance in DETAILS

UNIT CNT_ALL CNT_OK CNT_ERR ERR_PRC OK_MIN_MS OK_MAX_MS OK_AVG_MS CNT_LK_CONFL CNT_USER_EXC
doc_list_aiud 1267855 1267855 0 0.00 0 16688 7 0 0
doc_list_biud 1267838 1267838 0 0.00 0 36934 27 0 0
sp_add_invoice_to_stock 4409 4245 164 3.71 25 265722 20591 0 164
sp_cancel_adding_invoice 4387 4387 0 0.00 3 73418 773 0 0
sp_cancel_client_order 1621 1621 0 0.00 3 9077 349 0 0
sp_cancel_customer_reserve 425296 425296 0 0.00 0 27873 66 0 0
sp_cancel_pay_from_customer 626 626 0 0.00 2 3127 79 0 0
sp_cancel_pay_to_supplier 359 359 0 0.00 2 4521 95 0 0
sp_cancel_supplier_invoice 4882 4867 15 0.30 1 13925 717 0 15
sp_cancel_supplier_order 381 381 0 0.00 6 998432 89752 0 0
sp_cancel_write_off 7596 7596 0 0.00 1 7102 123 0 0
sp_client_order 18116 18116 0 0.00 3 20549 374 0 0
sp_customer_reserve 401131 401131 0 0.00 0 45542 201 0 0
sp_fill_shopping_cart 27787 27787 0 0.00 1 16127 42 0 0
sp_fill_shopping_cart_clo_res 401117 401117 0 0.00 0 30269 18 0 0
sp_get_clo_for_invoice 4231 4231 0 0.00 0 28767 380 0 0
sp_kill_cost_storno 12968 12968 0 0.00 0 7098 63 0 0
sp_kill_qstorno_ret_qs2qd 863436 863436 0 0.00 0 27836 35 0 0
sp_kill_qty_storno 457232 457232 0 0.00 0 36934 75 0 0
sp_lock_selected_doc 18218 18218 0 0.00 0 6572 4 0 0
sp_make_cost_storno 24467 24467 0 0.00 0 15835 64 0 0
sp_multiply_rows_for_pdistr 24464 24464 0 0.00 0 15137 35 0 0
sp_multiply_rows_for_qdistr 18116 18116 0 0.00 0 20532 203 0 0
sp_pay_from_customer 6180 6180 0 0.00 4 15422 133 0 0
sp_pay_to_supplier 5200 5200 0 0.00 4 12002 135 0 0
sp_payment_common 11380 11380 0 0.00 1 10229 19 0 0
sp_qd_handle_on_cancel_clo 1621 1621 0 0.00 0 9072 320 0 0
sp_qd_handle_on_invoice_upd_sts 8617 8617 0 0.00 0 36933 302 0 0
sp_qd_handle_on_reserve_upd_sts 8854 8854 0 0.00 0 13756 54 0 0
sp_reserve_write_off 8856 8856 0 0.00 6 14854 185 0 0
sp_supplier_invoice 4748 4748 0 0.00 6 56790 3200 0 0
sp_supplier_order 4926 4926 0 0.00 4 22553 1289 0 0
srv_aggregate_perf_data 86 86 0 0.00 1940 411687 18268 0 0
srv_fill_mon_cache_memory 56 56 0 0.00 2077 108927 40491 0 0
srv_find_qd_qs_mism 856360 856360 0 0.00 0 16687 7 0 0
srv_make_invnt_saldo 437 437 0 0.00 39 95602 3645 0 0
srv_make_money_saldo 618 618 0 0.00 1 17488 615 0 0
srv_recalc_idx_stat 3 3 0 0.00 133079 284662 205881 0 0
t$perf-abend:sp_add_invoice_to_stock 164 164 0 0.00 0 0 0 0 0
t$perf-abend:sp_cancel_supplier_invoice 15 15 0 0.00 0 0 0 0 0
t$perf-norm:sp_add_invoice_to_stock 4245 4245 0 0.00 0 11990 168 0 0
t$perf-norm:sp_cancel_adding_invoice 354 354 0 0.00 0 13066 118 0 0
t$perf-norm:sp_cancel_client_order 1621 1621 0 0.00 0 3217 16 0 0
t$perf-norm:sp_cancel_customer_reserve 602 602 0 0.00 0 1410 14 0 0
t$perf-norm:sp_cancel_pay_from_customer 626 626 0 0.00 0 5530 20 0 0
t$perf-norm:sp_cancel_pay_to_supplier 359 359 0 0.00 0 998 5 0 0
t$perf-norm:sp_cancel_supplier_invoice 359 359 0 0.00 0 572 9 0 0
t$perf-norm:sp_cancel_supplier_order 381 381 0 0.00 0 23272 1532 0 0
t$perf-norm:sp_cancel_write_off 832 832 0 0.00 0 1521 6 0 0
t$perf-norm:sp_client_order 18116 18116 0 0.00 0 12313 14 0 0
t$perf-norm:sp_customer_reserve 898 898 0 0.00 0 542 3 0 0
t$perf-norm:sp_pay_from_customer 6180 6180 0 0.00 0 6985 8 0 0
t$perf-norm:sp_pay_to_supplier 5200 5200 0 0.00 0 5407 9 0 0
t$perf-norm:sp_reserve_write_off 8856 8856 0 0.00 0 9758 11 0 0
t$perf-norm:sp_supplier_invoice 4748 4748 0 0.00 0 2790 15 0 0
t$perf-norm:sp_supplier_order 4926 4926 0 0.00 0 3536 13 0 0
t$perf-norm:srv_aggregate_perf_data 86 86 0 0.00 0 175 6 0 0
t$perf-norm:srv_fill_mon_cache_memory 56 56 0 0.00 0 249 8 0 0
t$perf-norm:srv_make_invnt_saldo 437 437 0 0.00 0 725 11 0 0
t$perf-norm:srv_make_money_saldo 618 618 0 0.00 0 2932 8 0 0
t$perf-norm:srv_recalc_idx_stat 3 3 0 0.00 1 58 20 0 0
v_add_invoice_to_stock 8788 8460 328 3.73 0 3790 18 0 328
v_all_customers 33182 33182 0 0.00 0 34 1 0 0
v_all_suppliers 27452 27452 0 0.00 0 23 1 0 0
v_all_wares 36232 36232 0 0.00 0 25 1 0 0
v_cancel_adding_invoice 708 708 0 0.00 0 3052 13 0 0
v_cancel_client_order 3242 3242 0 0.00 0 5020 8 0 0
v_cancel_customer_prepayment 1252 1252 0 0.00 0 2022 7 0 0
v_cancel_customer_reserve 1204 1204 0 0.00 0 441 4 0 0
v_cancel_payment_to_supplier 718 718 0 0.00 0 1521 5 0 0
v_cancel_supplier_invoice 748 718 30 4.01 0 486 13 0 30
v_cancel_supplier_order 762 762 0 0.00 0 1501 6 0 0
v_cancel_write_off 1664 1664 0 0.00 0 3669 18 0 0
v_max_id_clo_ord 4925 4925 0 0.00 0 2330 2 0 0
v_max_id_clo_res 898 898 0 0.00 0 3369 15 0 0
v_max_id_ord_sup 4746 4746 0 0.00 0 6143 7 0 0
v_max_non_paid_invoice 1145 1145 0 0.00 0 850 3 0 0
v_max_non_paid_realizn 3095 3095 0 0.00 0 3685 5 0 0
v_min_id_clo_ord 4925 4925 0 0.00 0 2912 6 0 0
v_min_id_clo_res 898 898 0 0.00 0 12709 21 0 0
v_min_id_ord_sup 4746 4746 0 0.00 0 6258 9 0 0
v_min_non_paid_invoice 5200 5200 0 0.00 0 4306 10 0 0
v_min_non_paid_realizn 6180 6180 0 0.00 0 3684 13 0 0
v_our_firm 9220 9220 0 0.00 0 71 1 0 0
v_reserve_write_off 17706 17706 0 0.00 0 4408 7 0 0
x_lock_depdocs_on_canc_invoice 8895 8895 0 0.00 0 8777 107 0 0
x_lock_depdocs_on_canc_sup_ord 381 381 0 0.00 0 3565 277 0 0
x_make_qstorno_1000_1200 4926 4926 0 0.00 1 22545 1212 0 0
x_make_qstorno_1200_2000 4748 4748 0 0.00 3 56783 3034 0 0
x_make_qstorno_2100_3300 401131 401131 0 0.00 0 45535 181 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 13-04-2024 07:08:58 to 13-04-2024 07:09:02.

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
05:07:54 8 8192000000 8808628464 8823566336 12270352 0.149 5 3 4 0 12434032 92304 71376
05:08:55 27258 8192000000 9701187856 9997275136 778050800 8.673 100 89 178 0 807014432 7759616 21204016
05:10:37 15449 8192000000 9752498448 10061045760 828792624 9.187 100 87 174 0 861164896 12276160 20096112
05:11:56 21021 8192000000 9789850608 10109669376 859771536 9.498 100 89 178 0 898196688 18989104 19436048
05:13:24 10989 8192000000 9853719296 10183520256 905476848 9.953 100 84 168 0 964377808 41472688 17428272
05:14:40 11265 8192000000 9903036640 10245619712 934190528 10.236 100 78 156 0 1010123552 60271424 15661600
05:15:55 5121 8192000000 9944056752 10293837824 971941264 10.606 100 80 160 0 1060584352 72917120 15725968
05:17:03 2286 8192000000 9966823632 10330316800 999044368 10.869 100 72 146 1 1086269296 73481056 13743872
05:18:09 2165 8192000000 9971797392 10340106240 1020212736 11.074 100 84 168 1 1089360576 52150448 16997392
05:19:13 1769 8192000000 10027232720 10403762176 1046934672 11.331 100 72 144 0 1142983872 82247168 13802032
05:20:16 31723 8192000000 9983437664 10367885312 1062533200 11.481 100 59 119 3 1112553216 36857648 13162368
05:21:49 6441 8192000000 9970985408 10372456448 1067454576 11.528 100 30 60 0 1101236832 27851488 5930768
05:22:57 6405 8192000000 9990925952 10393464832 1073938224 11.590 100 28 55 2 1103421216 24031104 5451888
05:24:05 8220 8192000000 9976878208 10378592256 1076417968 11.613 100 25 50 0 1099965712 18488080 5059664
05:25:16 5804 8192000000 10016000784 10415128576 1080611744 11.653 100 54 106 0 1131428560 39643536 11173280
05:26:23 7771 8192000000 10014413504 10425012224 1091773280 11.760 100 37 75 1 1131927664 32349872 7804512
05:27:34 5618 8192000000 10003400032 10401538048 1075814048 11.608 99 33 67 0 1103403744 20999872 6589824
05:28:44 98462 8192000000 10029186416 10430132224 1039883856 11.264 95 55 110 1 1120692656 69649536 11159264
05:31:28 22420 8192000000 10096720784 10502668288 1085166336 11.697 99 49 96 0 1186685840 92154480 9365024
05:32:53 13281 8192000000 10067762048 10463277056 1076559008 11.615 98 55 111 1 1161379088 74018304 10801776
05:34:08 8723 8192000000 10062329552 10465198080 1080783056 11.655 98 50 98 0 1154239056 63407856 10048144
05:35:20 25474 8192000000 10089813904 10507993088 1098426496 11.823 99 33 64 0 1190354288 85219872 6707920
05:36:55 11665 8192000000 10119113920 10523639808 1093053536 11.772 99 49 98 0 1223119136 119540512 10525088
05:38:09 21300 8192000000 10111699856 10521612288 1072468768 11.576 97 42 82 0 1191204976 109702192 9034016
05:39:37 10709 8192000000 10152531200 10542702592 1074863648 11.599 98 58 116 2 1248658592 161512304 12282640
05:40:53 5425 8192000000 10187972656 10593497088 1098364656 11.822 99 63 123 0 1286583088 174419968 13798464
05:42:01 5146 8192000000 10179442000 10605580288 1087514720 11.719 100 59 118 2 1285227408 184448544 13264144
05:43:17 5100 8192000000 10182563440 10570784768 1094800688 11.788 100 67 132 1 1280276400 171472976 14002736
05:44:30 4625 8192000000 10248660304 10654478336 1112934336 11.960 100 57 116 1 1348866128 223440816 12490976
05:45:41 2153 8192000000 10275174976 10699419648 1118810448 12.016 100 70 135 0 1371516224 237653504 15052272
05:46:46 2076 8192000000 10287922704 10691006464 1126923344 12.092 100 77 151 1 1382259792 238451776 16884672
05:47:50 5267 8192000000 10327375376 10745630720 1140653472 12.222 100 48 92 1 1425441968 273865872 10922624
05:48:58 13590 8192000000 10256863728 10690166784 1126189072 12.085 100 32 63 0 1382621904 248867632 7565200
05:50:15 4019 8192000000 10283554256 10694266880 1122491264 12.051 100 54 108 0 1380241440 245588480 12161696
05:51:41 22274 8192000000 10123298432 10632953856 1124480128 12.069 100 16 32 1 1334680112 206260336 3939648
05:53:04 90966 8192000000 10042218608 10475823104 1124733136 12.072 100 15 29 0 1172679120 45099280 2846704
05:55:37 27995 8192000000 10058176752 10485268480 1127179392 12.095 100 51 104 4 1153056016 14933760 10942864
05:57:06 42267 8192000000 10040122464 10499928064 1127624592 12.099 100 15 30 0 1158660320 27690720 3345008
05:58:49 64708 8192000000 10051424176 10494443520 1125834944 12.082 100 19 38 0 1152578944 22706288 4037712
06:00:55 50591 8192000000 10074401232 10515939328 1123675696 12.062 99 31 61 1 1165426752 35332032 6419024
06:02:47 41011 8192000000 10126457120 10567077888 1150013776 12.310 100 28 54 0 1219358032 63534432 5809824
06:04:32 23638 8192000000 10159277424 10598977536 1154638752 12.353 100 33 66 0 1257207376 95004592 7564032
06:05:57 24343 8192000000 10184738752 10619846656 1153102960 12.339 99 46 90 0 1274238448 110633888 10501600
06:07:26 26205 8192000000 10105869520 10564845568 1133291408 12.152 99 15 30 0 1221039968 84343136 3405424
06:08:54 70776 8192000000 10064774800 10541830144 1123043904 12.056 98 15 30 0 1191127728 65015600 3068224
06:11:05 49495 8192000000 10078749216 10518523904 1122391760 12.050 98 17 35 0 1162668912 36699120 3578032
06:12:56 40116 8192000000 10105120320 10547437568 1122120816 12.047 98 40 79 0 1187382864 57731440 7530608
06:14:45 41259 8192000000 10100143712 10590646272 1100718352 11.844 97 24 48 1 1181850544 76567472 4564720
06:16:30 72938 8192000000 10060015424 10535776256 1042274160 11.287 93 21 42 0 1094312272 47953312 4084800
06:18:44 108927 8192000000 10051484144 10492137472 988220368 10.764 90 21 43 0 1024732096 32559216 3952512
06:21:43 96919 8192000000 10049265248 10511310848 1074997408 11.600 98 24 46 0 1129389072 50090912 4300752
06:24:44 60895 8192000000 10007555520 10455371776 1076520896 11.614 99 8 16 1 1107121984 29383744 1217344
06:27:16 65056 8192000000 10100581312 10552307712 1101092384 11.848 100 18 36 0 1163836656 58672448 4071824
06:29:47 45430 8192000000 10060448048 10510266368 1079027088 11.638 98 20 40 1 1142765552 59656304 4082160
06:31:37 55270 8192000000 10078082816 10509119488 1106708944 11.901 100 18 34 0 1166183584 56455328 3019312
06:33:35 39533 8192000000 10069288016 10536054784 1106688880 11.901 99 24 48 0 1176238304 64664800 4884624
06:35:21 33965 8192000000 10091566144 10524868608 1093885504 11.780 98 27 54 0 1161161728 61944816 5331408
06:36:55 39213 8192000000 10065110416 10518941696 1107026768 11.904 100 18 36 0 1155953648 45671776 3255104
06:38:36 28859 8192000000 10075574896 10494988288 1122855808 12.054 100 44 86 3 1174959408 43434960 8668640
06:40:09 87511 8192000000 10088917808 10518048768 1115118240 11.981 99 46 92 0 1180264080 55825216 9320624
06:43:22 61592 8192000000 10103703744 10579148800 1116945360 11.998 99 9 18 0 1197401440 78446800 2009280
06:45:31 82548 8192000000 10088793200 10633474048 1132742064 12.147 100 17 34 0 1214408240 78164560 3501616
06:47:58 24029 8192000000 10102189280 10539438080 1140386896 12.219 100 55 107 0 1191488816 40257264 10844656
06:49:34 48407 8192000000 10115191552 10567471104 1139327712 12.209 100 18 36 0 1204253584 60983696 3942176
06:51:23 66176 8192000000 10060527696 10499411968 1124384160 12.068 99 17 34 0 1178259344 50403792 3471392
06:53:33 38742 8192000000 10094846720 10531164160 1120339888 12.030 98 31 62 0 1179409040 53145216 5923936
06:55:14 45107 8192000000 10117432096 10628079616 1137633904 12.193 100 19 38 0 1225996064 84797648 3564512
06:57:28 21404 8192000000 10080346016 10502828032 1103543792 11.871 97 29 58 1 1136446832 27172656 5730384
06:58:52 68495 8192000000 10085072912 10517544960 1109386304 11.927 99 28 52 0 1167639552 52947616 5305632
07:01:01 31586 8192000000 10053047056 10542354432 1096553104 11.805 99 4 8 0 1152351872 55035744 763024
07:02:40 40967 8192000000 10022922144 10498723840 1094831104 11.789 99 13 26 0 1138182048 40767200 2583744
07:04:22 38141 8192000000 10041498432 10474762240 1067558272 11.529 95 22 44 0 1115579440 43516400 4504768
07:06:01 90537 8192000000 10028047888 10471419904 1037652016 11.242 93 13 26 0 1118924688 78858416 2414256

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:14, from 13-04-2024 07:09:04 to 13-04-2024 07:09:18.

Exceptions occured during test was in run

FB_MNEMONA CNT UNIT FB_GDSCODE
except 164 v_add_invoice_to_stock 335544517
except 15 v_cancel_supplier_invoice 335544517

Completed "Exceptions occured during test was in run". Done for 00:00:02, from 13-04-2024 07:09:19 to 13-04-2024 07:09:21.

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          181000
MON$OLDEST_ACTIVE               181001
MON$OLDEST_SNAPSHOT             181001
MON$NEXT_TRANSACTION            181001
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                       1908384
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             705
MON$NEXT_STATEMENT              53
MON$REPLICA_MODE                0


ISQL Version: LI-V4.0.5.3083 Firebird 4.0
Server version:
Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V4.0.5.3083 Firebird 4.0"
Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-V4.0.5.3083 Firebird 4.0/tcp (mscs-test-161.budzdorov.ru)/P17:C"
Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-V4.0.5.3083 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 Sat Apr 13 07:09:22 2024 
 
Database header page information: 
    Flags            0 
    Generation        95410 
    System Change Number    0 
    Page size        8192 
    ODS version        13.0 
    Oldest transaction    181000 
    Oldest active        181001 
    Oldest snapshot        181001 
    Next transaction    181002 
    Sequence number        0 
    Next attachment ID    705 
    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.40, total records: 7769586 
    Average version length: 48.17, total versions: 99171, 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: 89304 
    Data pages: 89304, average fill: 70% 
    Primary pages: 89303, secondary pages: 1, swept pages: 36854 
    Empty pages: 0, full pages: 69106 
    Fill distribution: 
     0 - 19% = 14 
    20 - 39% = 64 
    40 - 59% = 1780 
    60 - 79% = 87393 
    80 - 99% = 53 
 
    Index DOC_DATA_DOC_WARE_UNQ (0) 
    Root page: 1510636, depth: 3, leaf buckets: 23120, nodes: 7769586 
    Average node length: 18.90, total dup: 0, max dup: 0 
    Average key length: 15.91, compression ratio: 1.70 
    Average prefix length: 14.09, average data length: 12.91 
    Clustering factor: 1676400, ratio: 0.22 
    Fill distribution: 
         0 - 19% = 288 
        20 - 39% = 1735 
        40 - 59% = 3951 
        60 - 79% = 2321 
        80 - 99% = 14825 
 
    Index DOC_DATA_ID_DESC (1) 
    Root page: 1528140, depth: 3, leaf buckets: 13450, nodes: 7769586 
    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: 1501004, ratio: 0.19 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 1492 
        40 - 59% = 1998 
        60 - 79% = 1051 
        80 - 99% = 8909 
 
    Index FK_DOC_DATA_DOC_LIST (2) 
    Root page: 1546735, depth: 3, leaf buckets: 8320, nodes: 7769586 
    Average node length: 6.62, total dup: 5804966, max dup: 49 
    Average key length: 3.63, compression ratio: 2.48 
    Average prefix length: 7.62, average data length: 1.38 
    Clustering factor: 1494056, ratio: 0.19 
    Fill distribution: 
         0 - 19% = 149 
        20 - 39% = 923 
        40 - 59% = 1335 
        60 - 79% = 868 
        80 - 99% = 5045 
 
DOC_LIST (138) 
    Primary pointer page: 500, Index root page: 501 
    Total formats: 1, used formats: 1 
    Average record length: 56.35, total records: 2255957 
    Average version length: 58.85, total versions: 51123, max versions: 2 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 84.00, compression ratio: 1.49 
    Pointer pages: 18, data page slots: 28816 
    Data pages: 28816, average fill: 72% 
    Primary pages: 28814, secondary pages: 2, swept pages: 10218 
    Empty pages: 3, full pages: 19651 
    Fill distribution: 
     0 - 19% = 10 
    20 - 39% = 25 
    40 - 59% = 351 
    60 - 79% = 28340 
    80 - 99% = 90 
 
    Index DOC_LIST_ID_DESC (1) 
    Root page: 1541152, depth: 3, leaf buckets: 4524, nodes: 2255957 
    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: 686021, ratio: 0.30 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 903 
        40 - 59% = 793 
        60 - 79% = 700 
        80 - 99% = 2128 
 
    Index DOC_LIST_WORKER_OPTYPE (2) 
    Root page: 1544398, depth: 3, leaf buckets: 2424, nodes: 2257449 
    Average node length: 4.97, total dup: 2256550, max dup: 18521 
    Average key length: 2.01, compression ratio: 4.48 
    Average prefix length: 8.99, average data length: 0.01 
    Clustering factor: 1259730, ratio: 0.56 
    Fill distribution: 
         0 - 19% = 3 
        20 - 39% = 208 
        40 - 59% = 1379 
        60 - 79% = 566 
        80 - 99% = 268 
 
    Index FK_DOC_LIST_AGENTS (3) 
    Root page: 1545933, depth: 3, leaf buckets: 1787, nodes: 2255957 
    Average node length: 4.97, total dup: 2255907, max dup: 130396 
    Average key length: 2.01, compression ratio: 4.48 
    Average prefix length: 8.99, average data length: 0.01 
    Clustering factor: 1072087, ratio: 0.48 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 7 
        40 - 59% = 629 
        60 - 79% = 53 
        80 - 99% = 1098 
 
    Index PK_DOC_LIST (0) 
    Root page: 1538209, depth: 3, leaf buckets: 4338, nodes: 2255957 
    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: 686021, ratio: 0.30 
    Fill distribution: 
         0 - 19% = 99 
        20 - 39% = 604 
        40 - 59% = 585 
        60 - 79% = 769 
        80 - 99% = 2281 
 
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.41, total records: 400 
    Average version length: 26.87, total versions: 1421, max versions: 4 
    Average fragment length: 2.00, total fragments: 1, max fragments: 1 
    Average unpacked length: 104.00, compression ratio: 1.25 
    Pointer pages: 1, data page slots: 24 
    Data pages: 24, average fill: 52% 
    Primary pages: 7, secondary pages: 17, swept pages: 0 
    Empty pages: 7, full pages: 11 
    Fill distribution: 
     0 - 19% = 10 
    20 - 39% = 1 
    40 - 59% = 0 
    60 - 79% = 1 
    80 - 99% = 12 
 
    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: 15.18, total records: 118026 
    Average version length: 68.29, total versions: 105716, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 88.00, compression ratio: 5.80 
    Pointer pages: 7, data page slots: 3280 
    Data pages: 2120, average fill: 75% 
    Primary pages: 2119, secondary pages: 1, swept pages: 0 
    Empty pages: 215, full pages: 1549 
    Fill distribution: 
     0 - 19% = 276 
    20 - 39% = 80 
    40 - 59% = 105 
    60 - 79% = 266 
    80 - 99% = 1393 
 
    Index INVNT_TURNOVER_LOG_WARE_DD_ID (0) 
    Root page: 1705179, depth: 3, leaf buckets: 394, nodes: 118026 
    Average node length: 13.37, total dup: 8467, max dup: 2 
    Average key length: 10.66, compression ratio: 2.53 
    Average prefix length: 19.26, average data length: 7.74 
    Clustering factor: 85482, ratio: 0.72 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 29 
        40 - 59% = 331 
        60 - 79% = 32 
        80 - 99% = 1 
 
MONEY_SALDO (141) 
    Primary pointer page: 506, Index root page: 507 
    Total formats: 1, used formats: 1 
    Average record length: 15.27, total records: 49 
    Average version length: 9.00, total versions: 219, 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: 23% 
    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.32, total records: 2111 
    Average version length: 43.47, total versions: 1972, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 58.00, compression ratio: 5.12 
    Pointer pages: 1, data page slots: 80 
    Data pages: 40, average fill: 56% 
    Primary pages: 39, secondary pages: 1, swept pages: 1 
    Empty pages: 8, full pages: 22 
    Fill distribution: 
     0 - 19% = 13 
    20 - 39% = 2 
    40 - 59% = 2 
    60 - 79% = 5 
    80 - 99% = 18 
 
    Index MONEY_TURNOVER_LOG_AGENT_OPTYPE (0) 
    Root page: 92491, depth: 2, leaf buckets: 6, nodes: 2111 
    Average node length: 4.27, total dup: 2013, max dup: 228 
    Average key length: 2.51, compression ratio: 7.56 
    Average prefix length: 18.53, average data length: 0.47 
    Clustering factor: 1090, ratio: 0.52 
    Fill distribution: 
         0 - 19% = 4 
        20 - 39% = 2 
        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.64, total records: 73 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 112.00, compression ratio: 1.15 
    Pointer pages: 1, data page slots: 2 
    Data pages: 2, average fill: 51% 
    Primary pages: 2, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 1 
    Fill distribution: 
     0 - 19% = 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: 73 
    Average node length: 11.68, total dup: 0, max dup: 0 
    Average key length: 10.67, compression ratio: 0.84 
    Average prefix length: 1.32, average data length: 7.68 
    Clustering factor: 2, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
MON_LOG (162) 
    Primary pointer page: 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.07, total records: 807304 
    Average version length: 37.86, total versions: 33207, max versions: 3 
    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: 8352 
    Data pages: 8352, average fill: 66% 
    Primary pages: 8350, secondary pages: 2, swept pages: 1380 
    Empty pages: 19, full pages: 7489 
    Fill distribution: 
     0 - 19% = 36 
    20 - 39% = 46 
    40 - 59% = 205 
    60 - 79% = 8001 
    80 - 99% = 64 
 
    Index PDISTR_AGENT_ID (2) 
    Root page: 1509330, depth: 2, leaf buckets: 848, nodes: 789616 
    Average node length: 4.88, total dup: 789567, max dup: 142403 
    Average key length: 2.01, compression ratio: 4.48 
    Average prefix length: 8.99, average data length: 0.01 
    Clustering factor: 89861, ratio: 0.11 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 120 
        40 - 59% = 472 
        60 - 79% = 152 
        80 - 99% = 104 
 
    Index PDISTR_SNDOP_RCVOP_SNDID_ASC (0) 
    Root page: 1508635, depth: 3, leaf buckets: 900, nodes: 789616 
    Average node length: 5.89, total dup: 702974, max dup: 44 
    Average key length: 3.02, compression ratio: 7.29 
    Average prefix length: 21.09, average data length: 0.91 
    Clustering factor: 159222, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 47 
        40 - 59% = 429 
        60 - 79% = 124 
        80 - 99% = 300 
 
    Index PDISTR_SNDOP_RCVOP_SNDID_DESC (1) 
    Root page: 1509209, depth: 3, leaf buckets: 925, nodes: 789616 
    Average node length: 5.89, total dup: 702974, max dup: 44 
    Average key length: 3.02, compression ratio: 7.28 
    Average prefix length: 21.09, average data length: 0.91 
    Clustering factor: 161034, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 106 
        40 - 59% = 395 
        60 - 79% = 129 
        80 - 99% = 295 
 
    Index PDISTR_WORKER_SND_ID (3) 
    Root page: 1510200, depth: 3, leaf buckets: 1109, nodes: 789616 
    Average node length: 5.97, total dup: 702974, max dup: 44 
    Average key length: 3.10, compression ratio: 5.48 
    Average prefix length: 16.01, average data length: 0.99 
    Clustering factor: 153792, ratio: 0.19 
    Fill distribution: 
         0 - 19% = 3 
        20 - 39% = 224 
        40 - 59% = 580 
        60 - 79% = 217 
        80 - 99% = 85 
 
PERF_AGG (158) 
    Primary pointer page: 540, Index root page: 541 
    Total formats: 1, used formats: 1 
    Average record length: 62.77, total records: 5500 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 3.58, total fragments: 31, max fragments: 1 
    Average unpacked length: 379.00, compression ratio: 6.04 
    Pointer pages: 1, data page slots: 112 
    Data pages: 96, average fill: 57% 
    Primary pages: 87, secondary pages: 9, swept pages: 63 
    Empty pages: 14, full pages: 54 
    Fill distribution: 
     0 - 19% = 21 
    20 - 39% = 0 
    40 - 59% = 1 
    60 - 79% = 74 
    80 - 99% = 0 
 
    Index PERF_AGG_UNQ (1) 
    Root page: 1504260, depth: 2, leaf buckets: 6, nodes: 5500 
    Average node length: 5.48, total dup: 0, max dup: 0 
    Average key length: 3.58, compression ratio: 10.08 
    Average prefix length: 34.52, average data length: 1.54 
    Clustering factor: 5220, ratio: 0.95 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 0 
        40 - 59% = 4 
        60 - 79% = 0 
        80 - 99% = 2 
 
    Index PK_PERF_AGG (0) 
    Root page: 1504255, depth: 2, leaf buckets: 10, nodes: 5500 
    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: 160, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 2 
        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.04, total records: 80491 
    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: 4, full pages: 835 
    Fill distribution: 
     0 - 19% = 4 
    20 - 39% = 0 
    40 - 59% = 1 
    60 - 79% = 835 
    80 - 99% = 0 
 
    Index PK_PERF_ESTIMATED (0) 
    Root page: 37872, depth: 2, leaf buckets: 102, nodes: 80491 
    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: 3132, ratio: 0.04 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 1 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 101 
 
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: 110.65, 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.28 
    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: 151.08, total records: 175833 
    Average version length: 137.10, total versions: 142, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.23 
    Pointer pages: 6, data page slots: 5464 
    Data pages: 4360, average fill: 83% 
    Primary pages: 4358, secondary pages: 2, swept pages: 7 
    Empty pages: 26, full pages: 4309 
    Fill distribution: 
     0 - 19% = 31 
    20 - 39% = 15 
    40 - 59% = 3 
    60 - 79% = 2 
    80 - 99% = 4309 
 
PERF_SPLIT_1 (282) 
    Primary pointer page: 603, Index root page: 604 
    Total formats: 1, used formats: 1 
    Average record length: 147.08, total records: 153529 
    Average version length: 154.58, total versions: 4382, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.53 
    Pointer pages: 6, data page slots: 4776 
    Data pages: 3800, average fill: 84% 
    Primary pages: 3796, secondary pages: 4, swept pages: 4 
    Empty pages: 25, full pages: 3764 
    Fill distribution: 
     0 - 19% = 27 
    20 - 39% = 3 
    40 - 59% = 4 
    60 - 79% = 1 
    80 - 99% = 3765 
 
PERF_SPLIT_2 (283) 
    Primary pointer page: 605, Index root page: 606 
    Total formats: 1, used formats: 1 
    Average record length: 149.74, total records: 132306 
    Average version length: 152.71, total versions: 1065, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.33 
    Pointer pages: 7, data page slots: 4736 
    Data pages: 3304, average fill: 82% 
    Primary pages: 3301, secondary pages: 3, swept pages: 4 
    Empty pages: 51, full pages: 3238 
    Fill distribution: 
     0 - 19% = 54 
    20 - 39% = 8 
    40 - 59% = 2 
    60 - 79% = 1 
    80 - 99% = 3239 
 
PERF_SPLIT_3 (284) 
    Primary pointer page: 607, Index root page: 616 
    Total formats: 1, used formats: 1 
    Average record length: 149.63, total records: 161513 
    Average version length: 152.49, total versions: 1632, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.33 
    Pointer pages: 5, data page slots: 4568 
    Data pages: 3984, average fill: 84% 
    Primary pages: 3983, secondary pages: 1, swept pages: 4 
    Empty pages: 15, full pages: 3960 
    Fill distribution: 
     0 - 19% = 18 
    20 - 39% = 2 
    40 - 59% = 3 
    60 - 79% = 2 
    80 - 99% = 3959 
 
PERF_SPLIT_4 (285) 
    Primary pointer page: 617, Index root page: 618 
    Total formats: 1, used formats: 1 
    Average record length: 147.99, total records: 166287 
    Average version length: 154.85, total versions: 3633, 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: 7, data page slots: 5280 
    Data pages: 4136, average fill: 83% 
    Primary pages: 4135, secondary pages: 1, swept pages: 6 
    Empty pages: 39, full pages: 4075 
    Fill distribution: 
     0 - 19% = 41 
    20 - 39% = 9 
    40 - 59% = 4 
    60 - 79% = 7 
    80 - 99% = 4075 
 
PERF_SPLIT_5 (286) 
    Primary pointer page: 619, Index root page: 620 
    Total formats: 1, used formats: 1 
    Average record length: 145.91, total records: 142962 
    Average version length: 154.28, total versions: 4501, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.62 
    Pointer pages: 7, data page slots: 4088 
    Data pages: 3536, average fill: 83% 
    Primary pages: 3533, secondary pages: 3, swept pages: 3 
    Empty pages: 31, full pages: 3493 
    Fill distribution: 
     0 - 19% = 37 
    20 - 39% = 2 
    40 - 59% = 2 
    60 - 79% = 1 
    80 - 99% = 3494 
 
PERF_SPLIT_6 (287) 
    Primary pointer page: 621, Index root page: 622 
    Total formats: 1, used formats: 1 
    Average record length: 146.86, total records: 162304 
    Average version length: 153.28, total versions: 4841, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.55 
    Pointer pages: 7, data page slots: 5744 
    Data pages: 4024, average fill: 83% 
    Primary pages: 4021, secondary pages: 3, swept pages: 9 
    Empty pages: 29, full pages: 3981 
    Fill distribution: 
     0 - 19% = 32 
    20 - 39% = 4 
    40 - 59% = 4 
    60 - 79% = 4 
    80 - 99% = 3980 
 
PERF_SPLIT_7 (288) 
    Primary pointer page: 626, Index root page: 627 
    Total formats: 1, used formats: 1 
    Average record length: 147.91, total records: 169532 
    Average version length: 153.56, total versions: 3801, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.47 
    Pointer pages: 6, data page slots: 4784 
    Data pages: 4200, average fill: 83% 
    Primary pages: 4198, secondary pages: 2, swept pages: 1 
    Empty pages: 31, full pages: 4160 
    Fill distribution: 
     0 - 19% = 34 
    20 - 39% = 2 
    40 - 59% = 1 
    60 - 79% = 2 
    80 - 99% = 4161 
 
PERF_SPLIT_8 (289) 
    Primary pointer page: 628, Index root page: 629 
    Total formats: 1, used formats: 1 
    Average record length: 138.14, total records: 165637 
    Average version length: 154.83, total versions: 15141, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 12.28 
    Pointer pages: 7, data page slots: 5096 
    Data pages: 4160, average fill: 83% 
    Primary pages: 4157, secondary pages: 3, swept pages: 1 
    Empty pages: 73, full pages: 4063 
    Fill distribution: 
     0 - 19% = 77 
    20 - 39% = 8 
    40 - 59% = 5 
    60 - 79% = 7 
    80 - 99% = 4063 
 
PERF_SPLIT_9 (290) 
    Primary pointer page: 630, Index root page: 631 
    Total formats: 1, used formats: 1 
    Average record length: 149.37, total records: 160639 
    Average version length: 152.18, total versions: 1830, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.35 
    Pointer pages: 6, data page slots: 5288 
    Data pages: 4000, average fill: 83% 
    Primary pages: 3997, secondary pages: 3, swept pages: 7 
    Empty pages: 51, full pages: 3935 
    Fill distribution: 
     0 - 19% = 53 
    20 - 39% = 4 
    40 - 59% = 3 
    60 - 79% = 5 
    80 - 99% = 3935 
 
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: 51.95, total records: 2114105 
    Average version length: 52.93, total versions: 38898, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 70.00, compression ratio: 1.35 
    Pointer pages: 16, data page slots: 25800 
    Data pages: 25800, average fill: 71% 
    Primary pages: 25787, secondary pages: 13, swept pages: 10989 
    Empty pages: 128, full pages: 22603 
    Fill distribution: 
     0 - 19% = 243 
    20 - 39% = 203 
    40 - 59% = 730 
    60 - 79% = 24230 
    80 - 99% = 394 
 
    Index PSTORNED_RCV_ID (1) 
    Root page: 1506208, depth: 3, leaf buckets: 2574, nodes: 2114105 
    Average node length: 5.44, total dup: 1973028, max dup: 1416 
    Average key length: 2.49, compression ratio: 3.62 
    Average prefix length: 8.58, average data length: 0.42 
    Clustering factor: 183299, ratio: 0.09 
    Fill distribution: 
         0 - 19% = 6 
        20 - 39% = 282 
        40 - 59% = 1675 
        60 - 79% = 292 
        80 - 99% = 319 
 
    Index PSTORNED_SND_ID (0) 
    Root page: 1504841, depth: 3, leaf buckets: 2765, nodes: 2114105 
    Average node length: 5.69, total dup: 1897758, max dup: 66 
    Average key length: 2.74, compression ratio: 3.29 
    Average prefix length: 8.36, average data length: 0.64 
    Clustering factor: 378244, ratio: 0.18 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 8 
        40 - 59% = 2369 
        60 - 79% = 365 
        80 - 99% = 23 
 
    Index PSTORNED_WORKER_ID (2) 
    Root page: 1508018, depth: 3, leaf buckets: 2117, nodes: 2114105 
    Average node length: 4.96, total dup: 2114005, max dup: 28449 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.41, average data length: 0.00 
    Clustering factor: 181022, ratio: 0.09 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 200 
        40 - 59% = 1067 
        60 - 79% = 410 
        80 - 99% = 439 
 
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: 41.21, total records: 161595 
    Average version length: 69.16, total versions: 75155, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 3.06 
    Pointer pages: 3, data page slots: 4184 
    Data pages: 3079, average fill: 64% 
    Primary pages: 3079, secondary pages: 0, swept pages: 244 
    Empty pages: 362, full pages: 2035 
    Fill distribution: 
     0 - 19% = 492 
    20 - 39% = 166 
    40 - 59% = 208 
    60 - 79% = 880 
    80 - 99% = 1333 
 
    Index XQD_1000_1200_WA_SO_RO_WKR_SND (0) 
    Root page: 1554240, depth: 3, leaf buckets: 236, nodes: 161595 
    Average node length: 6.47, total dup: 140687, max dup: 29 
    Average key length: 3.93, compression ratio: 10.69 
    Average prefix length: 40.20, average data length: 1.80 
    Clustering factor: 27699, ratio: 0.17 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 39 
        40 - 59% = 115 
        60 - 79% = 63 
        80 - 99% = 18 
 
XQD_1000_3300 (178) 
    Primary pointer page: 581, Index root page: 582 
    Total formats: 1, used formats: 1 
    Average record length: 65.54, total records: 7150173 
    Average version length: 68.78, total versions: 407453, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.92 
    Pointer pages: 66, data page slots: 106256 
    Data pages: 106256, average fill: 72% 
    Primary pages: 106254, secondary pages: 2, swept pages: 17981 
    Empty pages: 8, full pages: 83915 
    Fill distribution: 
     0 - 19% = 83 
    20 - 39% = 692 
    40 - 59% = 6087 
    60 - 79% = 97870 
    80 - 99% = 1524 
 
    Index XQD_1000_3300_WA_SO_RO_WKR_SND (0) 
    Root page: 1480476, depth: 3, leaf buckets: 10695, nodes: 7150173 
    Average node length: 6.51, total dup: 6184783, max dup: 41 
    Average key length: 3.52, compression ratio: 11.93 
    Average prefix length: 40.61, average data length: 1.39 
    Clustering factor: 1694911, ratio: 0.24 
    Fill distribution: 
         0 - 19% = 11 
        20 - 39% = 1480 
        40 - 59% = 5910 
        60 - 79% = 2745 
        80 - 99% = 549 
 
    Index XQD_1000_3300_WKR_DOC_ASC (1) 
    Root page: 1486090, depth: 3, leaf buckets: 8555, nodes: 7150173 
    Average node length: 5.39, total dup: 6867089, max dup: 193 
    Average key length: 2.40, compression ratio: 7.07 
    Average prefix length: 16.64, average data length: 0.36 
    Clustering factor: 1491413, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 7 
        20 - 39% = 1045 
        40 - 59% = 4889 
        60 - 79% = 1563 
        80 - 99% = 1051 
 
    Index XQD_1000_3300_WKR_DOC_DEC (2) 
    Root page: 1490630, depth: 3, leaf buckets: 8588, nodes: 7150173 
    Average node length: 5.39, total dup: 6867089, max dup: 193 
    Average key length: 2.40, compression ratio: 7.07 
    Average prefix length: 16.64, average data length: 0.36 
    Clustering factor: 1493668, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 7 
        20 - 39% = 1031 
        40 - 59% = 4898 
        60 - 79% = 1579 
        80 - 99% = 1073 
 
XQD_1200_2000 (177) 
    Primary pointer page: 579, Index root page: 580 
    Total formats: 1, used formats: 1 
    Average record length: 67.24, total records: 12077739 
    Average version length: 68.75, total versions: 342672, 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: 173800 
    Data pages: 173800, average fill: 74% 
    Primary pages: 173799, secondary pages: 1, swept pages: 57148 
    Empty pages: 3, full pages: 162631 
    Fill distribution: 
     0 - 19% = 43 
    20 - 39% = 442 
    40 - 59% = 3089 
    60 - 79% = 168015 
    80 - 99% = 2211 
 
    Index XQD_1200_2000_WA_SO_RO_WKR_SND (0) 
    Root page: 1495050, depth: 3, leaf buckets: 18355, nodes: 12075037 
    Average node length: 6.61, total dup: 10526808, max dup: 64 
    Average key length: 3.42, compression ratio: 12.26 
    Average prefix length: 40.70, average data length: 1.30 
    Clustering factor: 2488448, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 43 
        20 - 39% = 2173 
        40 - 59% = 10707 
        60 - 79% = 4593 
        80 - 99% = 839 
 
XQD_2000_3300 (179) 
    Primary pointer page: 583, Index root page: 584 
    Total formats: 1, used formats: 1 
    Average record length: 45.64, total records: 1694417 
    Average version length: 69.07, total versions: 380329, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 2.76 
    Pointer pages: 26, data page slots: 41016 
    Data pages: 29423, average fill: 58% 
    Primary pages: 29358, secondary pages: 65, swept pages: 6369 
    Empty pages: 2103, full pages: 20759 
    Fill distribution: 
     0 - 19% = 3771 
    20 - 39% = 4350 
    40 - 59% = 2814 
    60 - 79% = 13397 
    80 - 99% = 5091 
 
    Index XQD_2000_3300_WA_SO_RO_WKR_SND (0) 
    Root page: 1479735, depth: 3, leaf buckets: 1851, nodes: 1412361 
    Average node length: 5.53, total dup: 1354757, max dup: 49 
    Average key length: 2.57, compression ratio: 16.35 
    Average prefix length: 41.47, average data length: 0.53 
    Clustering factor: 96599, ratio: 0.07 
    Fill distribution: 
         0 - 19% = 9 
        20 - 39% = 361 
        40 - 59% = 902 
        60 - 79% = 502 
        80 - 99% = 77 
 
XQD_2100_3300 (180) 
    Primary pointer page: 585, Index root page: 586 
    Total formats: 1, used formats: 1 
    Average record length: 37.58, total records: 1387177 
    Average version length: 69.04, total versions: 185912, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 3.35 
    Pointer pages: 22, data page slots: 34648 
    Data pages: 28704, average fill: 40% 
    Primary pages: 28703, secondary pages: 1, swept pages: 6152 
    Empty pages: 5704, full pages: 13518 
    Fill distribution: 
     0 - 19% = 8233 
    20 - 39% = 3895 
    40 - 59% = 7514 
    60 - 79% = 8678 
    80 - 99% = 384 
 
    Index XQD_2100_3300_WA_SO_RO_WKR_SND (0) 
    Root page: 1479229, depth: 3, leaf buckets: 1222, nodes: 846487 
    Average node length: 5.97, total dup: 777813, max dup: 64 
    Average key length: 3.03, compression ratio: 13.85 
    Average prefix length: 41.05, average data length: 0.95 
    Clustering factor: 127332, ratio: 0.15 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 253 
        40 - 59% = 621 
        60 - 79% = 313 
        80 - 99% = 35 
 
XQD_3300_3400 (181) 
    Primary pointer page: 587, Index root page: 588 
    Total formats: 1, used formats: 1 
    Average record length: 65.55, total records: 9237810 
    Average version length: 68.98, total versions: 508616, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.92 
    Pointer pages: 89, data page slots: 143768 
    Data pages: 143752, average fill: 69% 
    Primary pages: 143734, secondary pages: 18, swept pages: 43750 
    Empty pages: 374, full pages: 78199 
    Fill distribution: 
     0 - 19% = 1126 
    20 - 39% = 3789 
    40 - 59% = 15523 
    60 - 79% = 119886 
    80 - 99% = 3428 
 
    Index XQD_3300_3400_WA_SO_RO_WKR_SND (0) 
    Root page: 1472612, depth: 3, leaf buckets: 13467, nodes: 9231201 
    Average node length: 6.68, total dup: 7654588, max dup: 14 
    Average key length: 3.67, compression ratio: 11.45 
    Average prefix length: 40.50, average data length: 1.50 
    Clustering factor: 2085121, ratio: 0.23 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 1071 
        40 - 59% = 7003 
        60 - 79% = 4816 
        80 - 99% = 576 
 
XQS_1000_1200 (182) 
    Primary pointer page: 589, Index root page: 590 
    Total formats: 1, used formats: 1 
    Average record length: 82.49, total records: 21151014 
    Average version length: 82.98, total versions: 12842, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.53 
    Pointer pages: 196, data page slots: 319768 
    Data pages: 319768, average fill: 81% 
    Primary pages: 319764, secondary pages: 4, swept pages: 13185 
    Empty pages: 19, full pages: 319468 
    Fill distribution: 
     0 - 19% = 25 
    20 - 39% = 15 
    40 - 59% = 46 
    60 - 79% = 49743 
    80 - 99% = 269939 
 
    Index XQS_1000_1200_DOC_ID (1) 
    Root page: 1426738, depth: 3, leaf buckets: 19575, nodes: 21151014 
    Average node length: 5.72, total dup: 20669915, max dup: 136 
    Average key length: 2.16, compression ratio: 4.16 
    Average prefix length: 8.86, average data length: 0.14 
    Clustering factor: 3286355, ratio: 0.16 
    Fill distribution: 
         0 - 19% = 4 
        20 - 39% = 1 
        40 - 59% = 8514 
        60 - 79% = 570 
        80 - 99% = 10486 
 
    Index XQS_1000_1200_RCV_ID (3) 
    Root page: 1457002, depth: 3, leaf buckets: 17178, nodes: 21151014 
    Average node length: 6.31, total dup: 18586934, max dup: 49 
    Average key length: 2.75, compression ratio: 3.27 
    Average prefix length: 8.37, average data length: 0.63 
    Clustering factor: 920694, ratio: 0.04 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 7 
        40 - 59% = 771 
        60 - 79% = 280 
        80 - 99% = 16119 
 
    Index XQS_1000_1200_SND_ID (2) 
    Root page: 1441095, depth: 3, leaf buckets: 21346, nodes: 21151014 
    Average node length: 6.35, total dup: 18506398, max dup: 29 
    Average key length: 2.79, compression ratio: 3.23 
    Average prefix length: 8.34, average data length: 0.66 
    Clustering factor: 3580369, ratio: 0.17 
    Fill distribution: 
         0 - 19% = 3 
        20 - 39% = 1 
        40 - 59% = 8755 
        60 - 79% = 630 
        80 - 99% = 11957 
 
    Index XQS_1000_1200_WORKER_ID (0) 
    Root page: 1413370, depth: 3, leaf buckets: 16237, nodes: 21151014 
    Average node length: 5.56, total dup: 21150914, max dup: 228481 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.42, average data length: 0.00 
    Clustering factor: 949401, ratio: 0.04 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 16 
        40 - 59% = 3119 
        60 - 79% = 418 
        80 - 99% = 12683 
 
XQS_1000_3300 (184) 
    Primary pointer page: 593, Index root page: 594 
    Total formats: 1, used formats: 1 
    Average record length: 79.13, total records: 9609296 
    Average version length: 82.63, total versions: 429392, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.59 
    Pointer pages: 103, data page slots: 167072 
    Data pages: 167032, average fill: 71% 
    Primary pages: 167006, secondary pages: 26, swept pages: 72219 
    Empty pages: 526, full pages: 99479 
    Fill distribution: 
     0 - 19% = 1351 
    20 - 39% = 3734 
    40 - 59% = 18231 
    60 - 79% = 120916 
    80 - 99% = 22800 
 
    Index XQS_1000_3300_DOC_ID (1) 
    Root page: 1367524, depth: 3, leaf buckets: 11337, nodes: 9609296 
    Average node length: 5.36, total dup: 9301640, max dup: 257 
    Average key length: 2.23, compression ratio: 4.03 
    Average prefix length: 8.80, average data length: 0.20 
    Clustering factor: 2193507, ratio: 0.23 
    Fill distribution: 
         0 - 19% = 5 
        20 - 39% = 55 
        40 - 59% = 8502 
        60 - 79% = 2696 
        80 - 99% = 79 
 
    Index XQS_1000_3300_RCV_ID (3) 
    Root page: 1379283, depth: 3, leaf buckets: 13200, nodes: 9609296 
    Average node length: 6.23, total dup: 7964625, max dup: 14 
    Average key length: 3.10, compression ratio: 2.90 
    Average prefix length: 8.07, average data length: 0.93 
    Clustering factor: 1541480, ratio: 0.16 
    Fill distribution: 
         0 - 19% = 131 
        20 - 39% = 3837 
        40 - 59% = 3954 
        60 - 79% = 2709 
        80 - 99% = 2569 
 
    Index XQS_1000_3300_SND_ID (2) 
    Root page: 1373081, depth: 3, leaf buckets: 12656, nodes: 9609296 
    Average node length: 5.98, total dup: 8336924, max dup: 46 
    Average key length: 2.85, compression ratio: 3.16 
    Average prefix length: 8.28, average data length: 0.72 
    Clustering factor: 2380510, ratio: 0.25 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 75 
        40 - 59% = 9492 
        60 - 79% = 2969 
        80 - 99% = 119 
 
    Index XQS_1000_3300_WORKER_ID (0) 
    Root page: 1362789, depth: 3, leaf buckets: 9998, nodes: 9609296 
    Average node length: 5.13, total dup: 9609196, max dup: 148720 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.42, average data length: 0.00 
    Clustering factor: 1556898, ratio: 0.16 
    Fill distribution: 
         0 - 19% = 48 
        20 - 39% = 1279 
        40 - 59% = 4748 
        60 - 79% = 1736 
        80 - 99% = 2187 
 
XQS_1200_2000 (183) 
    Primary pointer page: 591, Index root page: 592 
    Total formats: 1, used formats: 1 
    Average record length: 79.82, total records: 11374025 
    Average version length: 82.60, total versions: 384760, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.58 
    Pointer pages: 119, data page slots: 192888 
    Data pages: 191560, average fill: 73% 
    Primary pages: 191408, secondary pages: 152, swept pages: 62582 
    Empty pages: 1967, full pages: 150186 
    Fill distribution: 
     0 - 19% = 3770 
    20 - 39% = 6492 
    40 - 59% = 15593 
    60 - 79% = 96723 
    80 - 99% = 68982 
 
    Index XQS_1200_2000_DOC_ID (1) 
    Root page: 1392123, depth: 3, leaf buckets: 13122, nodes: 11374025 
    Average node length: 5.31, total dup: 11263933, max dup: 648 
    Average key length: 2.08, compression ratio: 4.33 
    Average prefix length: 8.93, average data length: 0.07 
    Clustering factor: 2386404, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 100 
        40 - 59% = 9013 
        60 - 79% = 3877 
        80 - 99% = 130 
 
    Index XQS_1200_2000_RCV_ID (3) 
    Root page: 1406132, depth: 3, leaf buckets: 10423, nodes: 11374025 
    Average node length: 5.51, total dup: 10877531, max dup: 49 
    Average key length: 2.28, compression ratio: 3.95 
    Average prefix length: 8.77, average data length: 0.23 
    Clustering factor: 732444, ratio: 0.06 
    Fill distribution: 
         0 - 19% = 157 
        20 - 39% = 808 
        40 - 59% = 2464 
        60 - 79% = 1833 
        80 - 99% = 5161 
 
    Index XQS_1200_2000_SND_ID (2) 
    Root page: 1398660, depth: 3, leaf buckets: 15007, nodes: 11374025 
    Average node length: 6.04, total dup: 9927083, max dup: 63 
    Average key length: 2.80, compression ratio: 3.21 
    Average prefix length: 8.32, average data length: 0.68 
    Clustering factor: 2402864, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 120 
        40 - 59% = 10507 
        60 - 79% = 4235 
        80 - 99% = 144 
 
    Index XQS_1200_2000_WORKER_ID (0) 
    Root page: 1386233, depth: 3, leaf buckets: 10831, nodes: 11374025 
    Average node length: 5.23, total dup: 11373925, max dup: 184691 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.41, average data length: 0.00 
    Clustering factor: 720376, ratio: 0.06 
    Fill distribution: 
         0 - 19% = 92 
        20 - 39% = 864 
        40 - 59% = 4746 
        60 - 79% = 1499 
        80 - 99% = 3630 
 
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: 79.79, total records: 9683209 
    Average version length: 82.91, total versions: 386551, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.58 
    Pointer pages: 105, data page slots: 170448 
    Data pages: 170400, average fill: 71% 
    Primary pages: 170381, secondary pages: 19, swept pages: 74849 
    Empty pages: 523, full pages: 101917 
    Fill distribution: 
     0 - 19% = 1688 
    20 - 39% = 5640 
    40 - 59% = 20057 
    60 - 79% = 121351 
    80 - 99% = 21664 
 
    Index XQS_2100_3300_DOC_ID (1) 
    Root page: 1344708, depth: 3, leaf buckets: 11752, nodes: 9683209 
    Average node length: 5.16, total dup: 9654703, max dup: 2419 
    Average key length: 2.03, compression ratio: 4.43 
    Average prefix length: 8.97, average data length: 0.03 
    Clustering factor: 1984643, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 26 
        20 - 39% = 1432 
        40 - 59% = 8020 
        60 - 79% = 1736 
        80 - 99% = 538 
 
    Index XQS_2100_3300_RCV_ID (3) 
    Root page: 1355739, depth: 3, leaf buckets: 13233, nodes: 9683209 
    Average node length: 6.23, total dup: 8026538, max dup: 14 
    Average key length: 3.10, compression ratio: 2.90 
    Average prefix length: 8.07, average data length: 0.93 
    Clustering factor: 1516125, ratio: 0.16 
    Fill distribution: 
         0 - 19% = 168 
        20 - 39% = 3773 
        40 - 59% = 3942 
        60 - 79% = 2646 
        80 - 99% = 2704 
 
    Index XQS_2100_3300_SND_ID (2) 
    Root page: 1350071, depth: 3, leaf buckets: 12397, nodes: 9683209 
    Average node length: 5.42, total dup: 9248808, max dup: 99 
    Average key length: 2.29, compression ratio: 3.93 
    Average prefix length: 8.76, average data length: 0.24 
    Clustering factor: 2118963, ratio: 0.22 
    Fill distribution: 
         0 - 19% = 19 
        20 - 39% = 1463 
        40 - 59% = 8828 
        60 - 79% = 1555 
        80 - 99% = 532 
 
    Index XQS_2100_3300_WORKER_ID (0) 
    Root page: 987843, depth: 3, leaf buckets: 10119, nodes: 9683209 
    Average node length: 5.13, total dup: 9683109, max dup: 150415 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.42, average data length: 0.00 
    Clustering factor: 1581202, ratio: 0.16 
    Fill distribution: 
         0 - 19% = 32 
        20 - 39% = 1287 
        40 - 59% = 4974 
        60 - 79% = 1696 
        80 - 99% = 2130 
 
XQS_3300_3400 (187) 
    Primary pointer page: 599, Index root page: 600 
    Total formats: 1, used formats: 1 
    Average record length: 67.70, total records: 578717 
    Average version length: 68.82, total versions: 4644, 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: 8112 
    Data pages: 8112, average fill: 75% 
    Primary pages: 8112, secondary pages: 0, swept pages: 3780 
    Empty pages: 6, full pages: 7038 
    Fill distribution: 
     0 - 19% = 7 
    20 - 39% = 7 
    40 - 59% = 141 
    60 - 79% = 7891 
    80 - 99% = 66 
 
    Index XQS_3300_3400_DOC_ID (1) 
    Root page: 39405, depth: 3, leaf buckets: 734, nodes: 578717 
    Average node length: 5.95, total dup: 492715, max dup: 82 
    Average key length: 3.09, compression ratio: 2.91 
    Average prefix length: 8.06, average data length: 0.94 
    Clustering factor: 101911, ratio: 0.18 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 27 
        40 - 59% = 505 
        60 - 79% = 108 
        80 - 99% = 94 
 
    Index XQS_3300_3400_SND_ID (2) 
    Root page: 33894, depth: 3, leaf buckets: 755, nodes: 578717 
    Average node length: 6.15, total dup: 474624, max dup: 21 
    Average key length: 3.29, compression ratio: 2.73 
    Average prefix length: 7.89, average data length: 1.11 
    Clustering factor: 101964, ratio: 0.18 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 25 
        40 - 59% = 524 
        60 - 79% = 110 
        80 - 99% = 96 
 
    Index XQS_3300_3400_WORKER_ID (0) 
    Root page: 377587, depth: 2, leaf buckets: 565, nodes: 578717 
    Average node length: 4.86, total dup: 578617, max dup: 10078 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.41, average data length: 0.00 
    Clustering factor: 90514, ratio: 0.16 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 32 
        40 - 59% = 323 
        60 - 79% = 74 
        80 - 99% = 135 
 
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 Sat Apr 13 07:09:46 2024

Record versions statistics, table

TABLE_NAME TOTAL_RECS TOTAL_VERS MAX_VERSIONS VERS_TO_RECS_PRC MAXV_TO_VERS_PRC
DOC_DATA 7769586 99171 1 0.0000 0.0000
DOC_LIST 2255957 51123 2 0.0000 0.0000
FB_ERRORS 2182 757 1 0.0000 0.0000
INVNT_SALDO 400 1421 4 300.0000 0.0000
INVNT_TURNOVER_LOG 118026 105716 1 0.0000 0.0000
MONEY_SALDO 49 219 8 400.0000 0.0000
MONEY_TURNOVER_LOG 2111 1972 1 0.0000 0.0000
PDISTR 807304 33207 3 0.0000 0.0000
PERF_SPLIT_0 175833 142 1 0.0000 0.0000
PERF_SPLIT_1 153529 4382 1 0.0000 0.0000
PERF_SPLIT_2 132306 1065 1 0.0000 0.0000
PERF_SPLIT_3 161513 1632 1 0.0000 0.0000
PERF_SPLIT_4 166287 3633 1 0.0000 0.0000
PERF_SPLIT_5 142962 4501 1 0.0000 0.0000
PERF_SPLIT_6 162304 4841 1 0.0000 0.0000
PERF_SPLIT_7 169532 3801 1 0.0000 0.0000
PERF_SPLIT_8 165637 15141 1 0.0000 0.0000
PERF_SPLIT_9 160639 1830 1 0.0000 0.0000
PSTORNED 2114105 38898 1 0.0000 0.0000
SEMAPHORES 5 1 1 0.0000 100.0000
XQD_1000_1200 161595 75155 1 0.0000 0.0000
XQD_1000_3300 7150173 407453 1 0.0000 0.0000
XQD_1200_2000 12077739 342672 1 0.0000 0.0000
XQD_2000_3300 1694417 380329 1 0.0000 0.0000
XQD_2100_3300 1387177 185912 1 0.0000 0.0000
XQD_3300_3400 9237810 508616 1 0.0000 0.0000
XQS_1000_1200 21151014 12842 1 0.0000 0.0000
XQS_1000_3300 9609296 429392 1 0.0000 0.0000
XQS_1200_2000 11374025 384760 1 0.0000 0.0000
XQS_2100_3300 9683209 386551 1 0.0000 0.0000
XQS_3300_3400 578717 4644 1 0.0000 0.0000

Record versions statistics, chart

Total records and versions, chart

Ratios versions / total_records and max_versions / total_versions

Database validation 


Database validation was not performed, see config parameter 'run_db_validation'
===============================================================================

Comparison of old and new firebird.log: get messages that appeared during test 

--- start of diff output ---
--- end of diff output ---

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

13.04.24 07:09:58. 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-04-13 07:10:01 No severe PSQL-related problems occured
13.04.24 07:10:02. End of report.