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

Hardware and OS info

Command: hostnamectl
Static hostname mscs-test-161.budzdorov.ru
Icon name computer-server
Chassis server
Machine ID aeee285d2cca40bf84c40a748f599e77
Boot ID 2a7b53d1c5ed44b9bb2712fffac5d8c6
Operating System CentOS Linux 7 (Core)
CPE OS Name cpe:/o:centos:centos:7
Kernel Linux 3.10.0-1127.10.1.el7.x86_64
Architecture x86-64
Command: who -b
bootup_info system boot 2021-11-11 18:28
Command: dmidecode -t system|grep -i -e 'manufacturer\|product\|hypervisor'
Manufacturer HP
Product Name ProLiant DL380 Gen9
Command: dmesg | grep DMI
[ 0.000000] DMI HP ProLiant DL380 Gen9/ProLiant DL380 Gen9, BIOS P89 05/21/2018
Command: lscpu | grep -i -v flags
Architecture x86_64
CPU op-mode(s) 32-bit, 64-bit
Byte Order Little Endian
CPU(s) 24
On-line CPU(s) list 0-23
Thread(s) per core 2
Core(s) per socket 6
Socket(s) 2
NUMA node(s) 2
Vendor ID GenuineIntel
CPU family 6
Model 63
Model name Intel(R) Xeon(R) CPU E5-2620 v3 @ 2.40GHz
Stepping 2
CPU MHz 1200.000
CPU max MHz 2400.0000
CPU min MHz 1200.0000
BogoMIPS 4794.33
Virtualization VT-x
L1d cache 32K
L1i cache 32K
L2 cache 256K
L3 cache 15360K
NUMA node0 CPU(s) 0-5,12-17
NUMA node1 CPU(s) 6-11,18-23
Command: cat /proc/meminfo | grep -i -e 'memtotal\|memfree\|memavail\|buffers\|cached\|swapcached'
MemTotal 32643792 kB
MemFree 15829756 kB
MemAvailable 30277036 kB
Buffers 0 kB
Cached 15891856 kB
SwapCached 2492 kB
Command: fdisk -l
WARNING: fdisk GPT support is currently new, and therefore in an experimental phase. Use at your own discretion.
Disk /dev/sda: 599.9 GB, 599932581888 bytes, 1171743324 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 262144 bytes / 524288 bytes
Disk label type: gpt
Disk identifier: 919DACA4-2F35-4CBB-BAA7-2A8CD8F7168C
# Start End Size Type Name
1 2048 411647 200M EFI System EFI System Partition
2 411648 2508799 1G Microsoft basic
3 2508800 1171742719 557.5G Linux LVM
Disk /dev/mapper/centos_mscs--test--161-root: 53.7 GB, 53687091200 bytes, 104857600 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 262144 bytes / 524288 bytes
Disk /dev/mapper/centos_mscs--test--161-swap: 16.8 GB, 16844324864 bytes, 32899072 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 262144 bytes / 524288 bytes
Disk /dev/sdb: 536 MB, 536870912 bytes, 1048576 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 512 bytes / 512 bytes
Disk label type: dos
Disk identifier: 0x00000046
Device Boot Start End Blocks Id System
/dev/sdb1 63 514079 257008+ c W95 FAT32 (LBA)
Disk /dev/mapper/centos_mscs--test--161-home: 528.1 GB, 528109010944 bytes, 1031462912 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 262144 bytes / 524288 bytes

Server and database settinfs 


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

Test configuration settings 

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

Test finish info 


FINISH_STATE                    NORMAL: TEST_TIME EXPIRED AT 2024-02-27 19:09:43
DTS_END                         2024-02-27 19:09:43.1140
FB_GDSCODE                      -1
FB_MNEMONA                      
STACK                           SP_RESERVE_WRITE_OFF(34:5) ==> SP_CHECK_TO_STOP_WORK(32:12) ==> SP_HALT_ON_ERROR(57:17)
IP                              ::1/36376
TRN_ID                          177133
ATT_ID                          573
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: 9332.87 21126 933287
customer order: creation 179.45 380 17945
customer order: refuse 15.94 393 1594
order to supplier: creation 47.42 1317 4742
order to supplier: removal 3.55 97115 355
invoice (draft): creation 48.55 3216 4855
invoice (draft): removal 49.03 804 4903
invoice accept: apply 44.69 20678 4469
invoice accept: cancel 45.11 890 4511
customer reserve: creation 4261.28 199 426128
customer reserve: removal 4329.14 62 432914
realization accept: apply 87.20 191 8720
realization accept: cancel 88.10 129 8810
payment from customer: creation 62.21 118 6221
payment from customer: removal 6.20 116 620
payment to supplier: creation 49.37 151 4937
payment to supplier: removal 3.19 117 319
service: total inventory turnovers 4.66 1192 466
service: total monetary turnovers 6.81 31 681
service: aggregate perf. data 0.94 17981 94
service: refresh index statistics 0.03 277437 3

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:02, from 27-02-2024 19:10:38 to 27-02-2024 19:10:40.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 4273
TEST_TIME 2 5374
TEST_TIME 3 5071
TEST_TIME 4 4421
TEST_TIME 5 4549
TEST_TIME 6 4449
TEST_TIME 7 4600
TEST_TIME 8 4577
TEST_TIME 9 4708
TEST_TIME 10 4907
TEST_TIME 11 5398
TEST_TIME 12 5472
TEST_TIME 13 5602
TEST_TIME 14 5995
TEST_TIME 15 6171
TEST_TIME 16 6374
TEST_TIME 17 6578
TEST_TIME 18 6918
TEST_TIME 19 7041
TEST_TIME 20 7523
TEST_TIME 21 7516
TEST_TIME 22 7876
TEST_TIME 23 7903
TEST_TIME 24 8165
TEST_TIME 25 8086
TEST_TIME 26 8193
TEST_TIME 27 8291
TEST_TIME 28 8667
TEST_TIME 29 9199
TEST_TIME 30 9374
TEST_TIME 31 9608
TEST_TIME 32 9396
TEST_TIME 33 9368
TEST_TIME 34 9207
TEST_TIME 35 9013
TEST_TIME 36 9222
TEST_TIME 37 9176
TEST_TIME 38 9027
TEST_TIME 39 8946
TEST_TIME 40 8938
TEST_TIME 41 9211
TEST_TIME 42 9209
TEST_TIME 43 9220
TEST_TIME 44 9205
TEST_TIME 45 9117
TEST_TIME 46 9150
TEST_TIME 47 9260
TEST_TIME 48 9155
TEST_TIME 49 9332
TEST_TIME 50 9420
TEST_TIME 51 9363
TEST_TIME 52 9375
TEST_TIME 53 9371
TEST_TIME 54 9388
TEST_TIME 55 9487
TEST_TIME 56 9499
TEST_TIME 57 9506
TEST_TIME 58 9551
TEST_TIME 59 9515
TEST_TIME 60 9427
TEST_TIME 61 9405
TEST_TIME 62 9387
TEST_TIME 63 9313
TEST_TIME 64 9260
TEST_TIME 65 9247
TEST_TIME 66 9153
TEST_TIME 67 9155
TEST_TIME 68 9160
TEST_TIME 69 9175
TEST_TIME 70 9234
TEST_TIME 71 9289
TEST_TIME 72 9292
TEST_TIME 73 9281
TEST_TIME 74 9286
TEST_TIME 75 9309
TEST_TIME 76 9359
TEST_TIME 77 9350
TEST_TIME 78 9387
TEST_TIME 79 9351
TEST_TIME 80 9425
TEST_TIME 81 9463
TEST_TIME 82 9473
TEST_TIME 83 9594
TEST_TIME 84 9546
TEST_TIME 85 9456
TEST_TIME 86 9451
TEST_TIME 87 9450
TEST_TIME 88 9400
TEST_TIME 89 9395
TEST_TIME 90 9365
TEST_TIME 91 9328
TEST_TIME 92 9302
TEST_TIME 93 9331
TEST_TIME 94 9296
TEST_TIME 95 9278
TEST_TIME 96 9296
TEST_TIME 97 9347
TEST_TIME 98 9318
TEST_TIME 99 9325
TEST_TIME 100 9342

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:03, from 27-02-2024 19:10:42 to 27-02-2024 19:10:45.

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 1323048 1323048 0 0.00 0 19969 7 0 0
doc_list_biud 1323046 1323046 0 0.00 0 64093 26 0 0
sp_add_invoice_to_stock 4522 4469 53 1.17 61 209861 20678 0 53
sp_cancel_adding_invoice 4511 4511 0 0.00 4 53174 890 0 0
sp_cancel_client_order 1594 1594 0 0.00 4 9841 393 0 0
sp_cancel_customer_reserve 432914 432914 0 0.00 0 64095 63 0 0
sp_cancel_pay_from_customer 620 620 0 0.00 3 7253 117 0 0
sp_cancel_pay_to_supplier 319 319 0 0.00 3 8813 117 0 0
sp_cancel_supplier_invoice 4910 4903 7 0.14 2 41527 804 0 7
sp_cancel_supplier_order 355 355 0 0.00 7 941912 97116 0 0
sp_cancel_write_off 8810 8810 0 0.00 1 15219 129 0 0
sp_client_order 17945 17945 0 0.00 3 38912 381 0 0
sp_customer_reserve 426128 426128 0 0.00 0 50264 200 0 0
sp_fill_shopping_cart 27539 27539 0 0.00 1 24122 36 0 0
sp_fill_shopping_cart_clo_res 426117 426117 0 0.00 0 26008 15 0 0
sp_get_clo_for_invoice 4450 4450 0 0.00 0 26294 259 0 0
sp_kill_cost_storno 14260 14260 0 0.00 0 9480 68 0 0
sp_kill_qstorno_ret_qs2qd 879896 879896 0 0.00 0 64089 34 0 0
sp_kill_qty_storno 466255 466255 0 0.00 0 64092 73 0 0
sp_lock_selected_doc 18227 18227 0 0.00 0 6826 5 0 0
sp_make_cost_storno 24327 24327 0 0.00 0 13775 65 0 0
sp_multiply_rows_for_pdistr 24325 24325 0 0.00 0 6651 27 0 0
sp_multiply_rows_for_qdistr 17945 17945 0 0.00 0 10360 155 0 0
sp_pay_from_customer 6221 6221 0 0.00 4 23800 119 0 0
sp_pay_to_supplier 4937 4937 0 0.00 5 15912 152 0 0
sp_payment_common 11157 11157 0 0.00 1 10389 23 0 0
sp_qd_handle_on_cancel_clo 1594 1594 0 0.00 0 9834 360 0 0
sp_qd_handle_on_invoice_upd_sts 8960 8960 0 0.00 0 31995 331 0 0
sp_qd_handle_on_reserve_upd_sts 8719 8719 0 0.00 0 12097 59 0 0
sp_reserve_write_off 8720 8720 0 0.00 6 22641 191 0 0
sp_supplier_invoice 4855 4855 0 0.00 7 77264 3217 0 0
sp_supplier_order 4742 4742 0 0.00 4 36471 1317 0 0
srv_aggregate_perf_data 94 94 0 0.00 2092 318607 17982 0 0
srv_fill_mon_cache_memory 56 56 0 0.00 1825 132693 40651 0 0
srv_find_qd_qs_mism 888608 888608 0 0.00 0 19968 7 0 0
srv_make_invnt_saldo 466 466 0 0.00 40 67801 1193 0 0
srv_make_money_saldo 681 681 0 0.00 1 1591 32 0 0
srv_recalc_idx_stat 3 3 0 0.00 166694 406141 277438 0 0
t$perf-abend:sp_add_invoice_to_stock 53 53 0 0.00 0 0 0 0 0
t$perf-abend:sp_cancel_supplier_invoice 7 7 0 0.00 0 0 0 0 0
t$perf-norm:sp_add_invoice_to_stock 4469 4469 0 0.00 0 32089 184 0 0
t$perf-norm:sp_cancel_adding_invoice 394 394 0 0.00 0 3588 107 0 0
t$perf-norm:sp_cancel_client_order 1594 1594 0 0.00 0 6833 24 0 0
t$perf-norm:sp_cancel_customer_reserve 572 572 0 0.00 0 675 7 0 0
t$perf-norm:sp_cancel_pay_from_customer 620 620 0 0.00 0 2045 11 0 0
t$perf-norm:sp_cancel_pay_to_supplier 319 319 0 0.00 0 1174 7 0 0
t$perf-norm:sp_cancel_supplier_invoice 317 317 0 0.00 0 754 15 0 0
t$perf-norm:sp_cancel_supplier_order 355 355 0 0.00 0 27650 2037 0 0
t$perf-norm:sp_cancel_write_off 888 888 0 0.00 0 8052 18 0 0
t$perf-norm:sp_client_order 17945 17945 0 0.00 0 6629 17 0 0
t$perf-norm:sp_customer_reserve 843 843 0 0.00 0 8059 16 0 0
t$perf-norm:sp_pay_from_customer 6221 6221 0 0.00 0 4150 11 0 0
t$perf-norm:sp_pay_to_supplier 4937 4937 0 0.00 0 3707 11 0 0
t$perf-norm:sp_reserve_write_off 8720 8720 0 0.00 0 6883 11 0 0
t$perf-norm:sp_supplier_invoice 4855 4855 0 0.00 0 6315 18 0 0
t$perf-norm:sp_supplier_order 4742 4742 0 0.00 0 6819 21 0 0
t$perf-norm:srv_aggregate_perf_data 94 94 0 0.00 0 323 8 0 0
t$perf-norm:srv_fill_mon_cache_memory 56 56 0 0.00 0 756 18 0 0
t$perf-norm:srv_make_invnt_saldo 466 466 0 0.00 0 1332 30 0 0
t$perf-norm:srv_make_money_saldo 681 681 0 0.00 0 1422 24 0 0
t$perf-norm:srv_recalc_idx_stat 3 3 0 0.00 2 5 4 0 0
v_add_invoice_to_stock 9004 8898 106 1.17 0 5128 17 0 106
v_all_customers 33478 33478 0 0.00 0 179 1 0 0
v_all_suppliers 27038 27038 0 0.00 0 16 1 0 0
v_all_wares 35890 35890 0 0.00 0 40 1 0 0
v_cancel_adding_invoice 788 788 0 0.00 0 1475 9 0 0
v_cancel_client_order 3188 3188 0 0.00 0 3628 8 0 0
v_cancel_customer_prepayment 1240 1240 0 0.00 0 3200 12 0 0
v_cancel_customer_reserve 1144 1144 0 0.00 0 398 3 0 0
v_cancel_payment_to_supplier 638 638 0 0.00 0 8803 23 0 0
v_cancel_supplier_invoice 648 634 14 2.16 0 1061 17 0 14
v_cancel_supplier_order 710 710 0 0.00 0 8746 17 0 0
v_cancel_write_off 1776 1776 0 0.00 0 9266 27 0 0
v_max_id_clo_ord 4742 4742 0 0.00 0 3181 3 0 0
v_max_id_clo_res 843 843 0 0.00 0 2634 18 0 0
v_max_id_ord_sup 4852 4852 0 0.00 0 4128 5 0 0
v_max_non_paid_invoice 1011 1011 0 0.00 0 2250 6 0 0
v_max_non_paid_realizn 2923 2923 0 0.00 0 3134 6 0 0
v_min_id_clo_ord 4742 4742 0 0.00 0 6814 8 0 0
v_min_id_clo_res 843 843 0 0.00 0 894 4 0 0
v_min_id_ord_sup 4852 4852 0 0.00 0 2909 5 0 0
v_min_non_paid_invoice 4936 4936 0 0.00 0 2691 14 0 0
v_min_non_paid_realizn 6221 6221 0 0.00 0 5938 15 0 0
v_our_firm 9008 9008 0 0.00 0 20 1 0 0
v_reserve_write_off 17436 17436 0 0.00 0 22085 10 0 0
x_lock_depdocs_on_canc_invoice 9097 9097 0 0.00 0 22623 143 0 0
x_lock_depdocs_on_canc_sup_ord 355 355 0 0.00 0 2670 286 0 0
x_make_qstorno_1000_1200 4742 4742 0 0.00 1 36466 1235 0 0
x_make_qstorno_1200_2000 4855 4855 0 0.00 4 77234 3086 0 0
x_make_qstorno_2100_3300 426128 426128 0 0.00 0 42266 182 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 27-02-2024 19:10:46 to 27-02-2024 19:10:50.

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
17:09:47 3 8192000000 8801764736 8813973504 7788416 0.094 2 2 3 0 7929520 66144 74960
17:10:48 42843 8192000000 9921045680 10233765888 997666416 10.856 100 87 174 0 1026816816 6806208 22344192
17:12:39 15449 8192000000 9963347952 10288721920 1043749040 11.301 100 86 172 0 1074104608 9133520 21222048
17:13:57 15424 8192000000 9999657680 10334703616 1078000288 11.628 100 87 174 0 1109907056 11046272 20860496
17:15:16 8948 8192000000 10033775840 10380898304 1118579008 12.014 100 83 166 2 1150319920 12236672 19504240
17:16:28 5270 8192000000 10064724592 10417713152 1147912784 12.290 100 84 167 1 1180116512 12808752 19394976
17:17:40 4205 8192000000 10109860608 10477133824 1200806320 12.784 100 76 150 0 1229965264 12184560 16974384
17:18:47 1741 8192000000 10153164352 10523353088 1240732912 13.153 100 86 173 1 1272766464 13304352 18729200
17:19:51 7344 8192000000 10177169760 10559746048 1272869664 13.448 100 78 156 0 1302257536 13057952 16329920
17:21:00 994 8192000000 10213774784 10600939520 1301610832 13.710 100 89 177 1 1333941792 12832192 19498768
17:22:02 41395 8192000000 10211621712 10610876416 1309456832 13.781 100 55 111 0 1329978720 7413280 13108608
17:23:45 2846 8192000000 10204766416 10621927424 1314528960 13.827 100 30 60 1 1332595120 11470800 6595360
17:24:48 12702 8192000000 10201300640 10625081344 1324950064 13.922 100 14 29 1 1333758112 5249232 3558816
17:26:03 7356 8192000000 10216089600 10636808192 1329755008 13.965 100 22 45 0 1341420352 6786336 4879008
17:27:11 59295 8192000000 10238166928 10654183424 1340467712 14.062 100 41 81 0 1359421024 9635232 9318080
17:29:14 8835 8192000000 10236389904 10661670912 1347302112 14.123 100 17 34 1 1357108000 5217680 4588208
17:30:29 10164 8192000000 10235381792 10646122496 1336546464 14.026 100 52 104 1 1357261280 8866368 11848448
17:31:46 18864 8192000000 10242432704 10646695936 1318477216 13.863 98 61 121 1 1342273408 10206672 13589520
17:33:09 75045 8192000000 10241766224 10663989248 1327078784 13.941 98 34 66 1 1343853440 9216192 7558464
17:35:36 20856 8192000000 10249360736 10655961088 1329594928 13.963 98 48 95 0 1354591904 14164448 10832528
17:37:16 11854 8192000000 10238796160 10643181568 1303579360 13.728 96 49 98 0 1331762336 16658352 11524624
17:38:36 27927 8192000000 10245792672 10655711232 1314593584 13.828 98 41 82 0 1343652608 18618384 10440640
17:40:08 10783 8192000000 10236635968 10644566016 1320858752 13.884 99 44 89 1 1353039296 21521600 10658944
17:41:29 3958 8192000000 10241229248 10635689984 1297484736 13.672 98 62 120 0 1331314528 19472560 14357232
17:42:38 2769 8192000000 10252752128 10646659072 1316439984 13.844 100 75 147 0 1360049968 26522816 17087168
17:43:44 7586 8192000000 10267326768 10667470848 1331990496 13.985 100 67 134 2 1373550928 25337200 16223232
17:44:59 2983 8192000000 10277502528 10666844160 1333170480 13.996 100 82 161 2 1376544128 23781872 19591776
17:46:11 1815 8192000000 10280145264 10679971840 1343722128 14.091 100 79 156 1 1390279024 26498704 20058192
17:47:19 6206 8192000000 10299439664 10702786560 1346760320 14.118 99 62 123 1 1395179696 32828416 15590960
17:48:31 2742 8192000000 10313831824 10715930624 1365114320 14.283 100 82 163 0 1419975168 35529792 19331056
17:49:37 10121 8192000000 10305681440 10710528000 1360352992 14.241 100 65 126 1 1409141008 33164720 15623296
17:50:52 4524 8192000000 10305849808 10720608256 1355382016 14.196 99 56 111 1 1400231952 31330608 13519328
17:52:02 10705 8192000000 10327970464 10738905088 1389166816 14.498 100 64 128 1 1432180272 27910768 15102688
17:53:22 15629 8192000000 10331016784 10758496256 1395190464 14.552 100 35 70 0 1440263120 36057232 9015424
17:54:42 20370 8192000000 10321874400 10753228800 1395467984 14.555 100 24 48 0 1432121520 30031568 6621968
17:56:05 22330 8192000000 10322568448 10757095424 1391250864 14.517 100 28 56 0 1434784160 36038432 7494864
17:57:34 26582 8192000000 10314752320 10757230592 1385834240 14.469 100 20 40 1 1422606688 30990544 5781904
17:59:18 54960 8192000000 10305777584 10753232896 1392364464 14.527 100 17 35 0 1413384096 16621856 4397776
18:01:18 39221 8192000000 10325112272 10758721536 1390914048 14.514 99 53 104 2 1410019392 7114720 11990624
18:02:58 118504 8192000000 10322322944 10771001344 1403916912 14.630 100 23 47 0 1425759744 16589952 5252880
18:06:18 85690 8192000000 10303540672 10757210112 1375843088 14.379 98 11 22 2 1387624432 9053504 2727840
18:08:45 46827 8192000000 10332499696 10786119680 1421575936 14.787 100 44 88 1 1450576736 16897872 12102928
18:10:46 36000 8192000000 10305350144 10766721024 1395637056 14.556 99 21 41 0 1412332624 11887216 4808352
18:12:27 26596 8192000000 10308422416 10775334912 1408593264 14.671 100 10 20 0 1425689808 15020528 2076016
18:13:58 51996 8192000000 10309012816 10770915328 1408152128 14.668 100 13 26 0 1423199184 12010688 3036368
18:15:52 43109 8192000000 10308308000 10774122496 1390576992 14.511 99 11 22 0 1404568944 11397072 2594880
18:17:40 25602 8192000000 10335277392 10768138240 1389900336 14.505 99 41 84 1 1413989248 14424208 9664704
18:19:06 97443 8192000000 10287564656 10731376640 1288208096 13.588 92 8 16 0 1307424816 17313840 1902880
18:21:45 69309 8192000000 10268728320 10716557312 1270547888 13.427 92 21 43 1 1285027360 9790032 4689440
18:24:40 106638 8192000000 10241642784 10685669376 1273771840 13.456 94 11 22 0 1291505408 15690880 2042688
18:27:27 79229 8192000000 10255303904 10704240640 1292600640 13.628 95 12 24 0 1308857472 13330192 2926640
18:29:47 100402 8192000000 10240290912 10686689280 1306059008 13.750 97 24 46 1 1321492992 10812624 4621360
18:32:36 28643 8192000000 10220866864 10657185792 1302551648 13.718 98 28 56 0 1321740496 12828384 6360464
18:34:06 49854 8192000000 10232519632 10672263168 1309908448 13.785 98 31 62 0 1332466784 15605776 6952560
18:35:58 47569 8192000000 10235805936 10675068928 1325408448 13.926 99 17 34 0 1346371648 16592112 4371088
18:37:53 44094 8192000000 10238744544 10681552896 1332276368 13.988 100 13 24 0 1353109552 17118736 3714448
18:39:50 48140 8192000000 10225601904 10658324480 1276469088 13.481 94 16 32 1 1288969920 9209136 3291696
18:41:43 22266 8192000000 10273981424 10699071488 1342570848 14.081 99 29 57 0 1355075344 5880544 6623952
18:43:08 23541 8192000000 10280750608 10717552640 1370712416 14.333 100 29 58 0 1386098816 9559664 5826736
18:44:32 21218 8192000000 10292591952 10737401856 1379114176 14.409 100 40 79 0 1399222384 11464592 8643616
18:45:54 45892 8192000000 10266768160 10705063936 1306307008 13.753 95 28 56 1 1322364000 9941008 6115984
18:47:42 31957 8192000000 10287790160 10717528064 1364206928 14.275 99 31 59 0 1378567536 7456400 6904208
18:49:19 43164 8192000000 10300092064 10742300672 1384391984 14.456 100 10 20 0 1398948272 11938448 2617840
18:51:02 96222 8192000000 10307130096 10763317248 1366793104 14.298 98 14 28 0 1392045216 21851040 3401072
18:53:45 132693 8192000000 10301346192 10751496192 1371690560 14.342 98 17 34 1 1387709840 11935696 4083584
18:56:58 23479 8192000000 10304454144 10765955072 1399035600 14.586 100 20 40 0 1417498272 14074704 4387968
18:58:54 74842 8192000000 10296103152 10755760128 1401448864 14.608 100 9 18 0 1413547936 9896160 2202912
19:01:11 51150 8192000000 10289289936 10741223424 1378309808 14.401 99 19 38 0 1391160080 8081600 4768672
19:03:03 45958 8192000000 10280394176 10728660992 1367313056 14.303 98 13 25 1 1379402928 9345312 2744560
19:04:50 55619 8192000000 10274320080 10728710144 1327825936 13.948 96 24 49 0 1343832816 10412560 5594320
19:06:52 36402 8192000000 10270963248 10701832192 1312171456 13.806 96 26 52 0 1327761072 9603984 5985632
19:08:31 58338 8192000000 10241619392 10680741888 1261567984 13.344 92 20 40 0 1281486032 15434160 4483888

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:14, from 27-02-2024 19:10:52 to 27-02-2024 19:11:06.

Exceptions occured during test was in run

FB_MNEMONA CNT UNIT FB_GDSCODE
except 53 v_add_invoice_to_stock 335544517
except 7 v_cancel_supplier_invoice 335544517

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

Content of mon$database and FB version 


MON$DATABASE_NAME               /home/bases/oltp30-etalone.fdb
MON$PAGE_SIZE                   8192
MON$ODS_MAJOR                   12
MON$ODS_MINOR                   0
MON$OLDEST_TRANSACTION          177396
MON$OLDEST_ACTIVE               177397
MON$OLDEST_SNAPSHOT             177397
MON$NEXT_TRANSACTION            177397
MON$PAGE_BUFFERS                1000000
MON$SQL_DIALECT                 3
MON$SHUTDOWN_MODE               0
MON$SWEEP_INTERVAL              0
MON$READ_ONLY                   0
MON$FORCED_WRITES               1
MON$RESERVE_SPACE               1
MON$CREATION_DATE               2020-04-03 16:41:55.3470
MON$PAGES                       1902304
MON$STAT_ID                     1
MON$BACKUP_STATE                0
MON$CRYPT_PAGE                  0
MON$OWNER                       SYSDBA                                                                                       
MON$SEC_DATABASE                Default


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

Database statistics 

 
Database "/home/bases/oltp30-etalone.fdb" 
Gstat execution time Tue Feb 27 19:11:10 2024 
 
Database header page information: 
    Flags            0 
    Generation        92405 
    System Change Number    0 
    Page size        8192 
    ODS version        12.0 
    Oldest transaction    177396 
    Oldest active        177397 
    Oldest snapshot        177397 
    Next transaction    177398 
    Sequence number        0 
    Next attachment ID    717 
    Implementation        HW=AMD/Intel/x64 little-endian OS=Linux CC=gcc 
    Shadow count        0 
    Page buffers        0 
    Next header page    0 
    Database dialect    3 
    Creation date        Apr 3, 2020 16:41:55 
    Attributes        force write 
 
    Variable header data: 
    Sweep interval:        0 
    Unrecognized option 11, length 16 
    *END* 
 
 
Database file sequence: 
File /home/bases/oltp30-etalone.fdb is the only file 
 
Analyzing database pages ... 
AGENTS (150) 
    Primary pointer page: 496, Index root page: 497 
    Total formats: 1, used formats: 1 
    Average record length: 33.60, total records: 50 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 344.00, compression ratio: 10.24 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 31% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 1 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index AGENTS_ID_DESC (2) 
    Root page: 1504311, depth: 1, leaf buckets: 1, nodes: 50 
    Average node length: 11.82, total dup: 0, max dup: 0 
    Average key length: 10.80, compression ratio: 0.83 
    Average prefix length: 1.18, average data length: 7.82 
    Clustering factor: 1, ratio: 0.02 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index AGENTS_IS_OUR_FIRM (4) 
    Root page: 1504313, depth: 1, leaf buckets: 1, nodes: 50 
    Average node length: 3.08, total dup: 48, max dup: 48 
    Average key length: 2.04, compression ratio: 0.50 
    Average prefix length: 0.96, average data length: 0.06 
    Clustering factor: 1, ratio: 0.02 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index AGENTS_IS_SUPPLIER (3) 
    Root page: 1504312, depth: 1, leaf buckets: 1, nodes: 50 
    Average node length: 3.08, total dup: 48, max dup: 44 
    Average key length: 2.04, compression ratio: 0.54 
    Average prefix length: 1.04, average data length: 0.06 
    Clustering factor: 1, ratio: 0.02 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index AGENTS_NAME_UNQ (1) 
    Root page: 1504310, depth: 1, leaf buckets: 1, nodes: 50 
    Average node length: 17.20, total dup: 0, max dup: 0 
    Average key length: 15.88, compression ratio: 0.92 
    Average prefix length: 1.42, average data length: 13.20 
    Clustering factor: 1, ratio: 0.02 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PK_AGENTS (0) 
    Root page: 1504309, depth: 1, leaf buckets: 1, nodes: 50 
    Average node length: 11.82, total dup: 0, max dup: 0 
    Average key length: 10.80, compression ratio: 0.83 
    Average prefix length: 1.18, average data length: 7.82 
    Clustering factor: 1, ratio: 0.02 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
BUSINESS_OPS (154) 
    Primary pointer page: 504, Index root page: 505 
    Total formats: 1, used formats: 1 
    Average record length: 108.20, total records: 20 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1235.00, compression ratio: 11.41 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 31% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 1 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index BO_UNIT_UNQ (1) 
    Root page: 1504242, depth: 1, leaf buckets: 1, nodes: 20 
    Average node length: 18.25, total dup: 0, max dup: 0 
    Average key length: 17.20, compression ratio: 1.24 
    Average prefix length: 7.05, average data length: 14.25 
    Clustering factor: 1, ratio: 0.05 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index BUSINESS_OPS_PREDICT_PRIOR (3) 
    Root page: 1504244, depth: 1, leaf buckets: 1, nodes: 20 
    Average node length: 5.40, total dup: 0, max dup: 0 
    Average key length: 4.35, compression ratio: 0.67 
    Average prefix length: 1.20, average data length: 1.70 
    Clustering factor: 1, ratio: 0.05 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index BUSINESS_OPS_RND_WGTH (2) 
    Root page: 1504243, depth: 1, leaf buckets: 1, nodes: 20 
    Average node length: 4.30, total dup: 6, max dup: 3 
    Average key length: 3.25, compression ratio: 0.72 
    Average prefix length: 1.35, average data length: 1.00 
    Clustering factor: 1, ratio: 0.05 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index RDB$1 (0) 
    Root page: 1504241, depth: 1, leaf buckets: 1, nodes: 20 
    Average node length: 5.20, total dup: 0, max dup: 0 
    Average key length: 4.15, compression ratio: 0.65 
    Average prefix length: 1.10, average data length: 1.60 
    Clustering factor: 1, ratio: 0.05 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
DOC_DATA (139) 
    Primary pointer page: 474, Index root page: 475 
    Total formats: 1, used formats: 1 
    Average record length: 47.26, total records: 7801575 
    Average version length: 48.16, total versions: 102898, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 64.00, compression ratio: 1.35 
    Pointer pages: 54, data page slots: 86864 
    Data pages: 86864, average fill: 72% 
    Primary pages: 86864, secondary pages: 0, swept pages: 16121 
    Empty pages: 2, full pages: 71036 
    Fill distribution: 
     0 - 19% = 13 
    20 - 39% = 141 
    40 - 59% = 2163 
    60 - 79% = 84512 
    80 - 99% = 35 
 
    Index DOC_DATA_DOC_WARE_UNQ (0) 
    Root page: 1510614, depth: 3, leaf buckets: 23407, nodes: 7801575 
    Average node length: 18.91, total dup: 0, max dup: 0 
    Average key length: 15.92, compression ratio: 1.70 
    Average prefix length: 14.08, average data length: 12.92 
    Clustering factor: 1728376, ratio: 0.22 
    Fill distribution: 
         0 - 19% = 345 
        20 - 39% = 1659 
        40 - 59% = 4320 
        60 - 79% = 2416 
        80 - 99% = 14667 
 
    Index DOC_DATA_ID_DESC (1) 
    Root page: 1528118, depth: 3, leaf buckets: 13593, nodes: 7801575 
    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: 1551498, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 1429 
        40 - 59% = 2233 
        60 - 79% = 1132 
        80 - 99% = 8799 
 
    Index FK_DOC_DATA_DOC_LIST (2) 
    Root page: 1546711, depth: 3, leaf buckets: 8403, nodes: 7801575 
    Average node length: 6.63, total dup: 5819770, max dup: 49 
    Average key length: 3.64, compression ratio: 2.47 
    Average prefix length: 7.61, average data length: 1.39 
    Clustering factor: 1544391, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 161 
        20 - 39% = 862 
        40 - 59% = 1469 
        60 - 79% = 932 
        80 - 99% = 4979 
 
DOC_LIST (138) 
    Primary pointer page: 472, Index root page: 473 
    Total formats: 1, used formats: 1 
    Average record length: 56.14, total records: 2272437 
    Average version length: 34.70, total versions: 103892, max versions: 3 
    Average fragment length: 6.00, total fragments: 2, max fragments: 1 
    Average unpacked length: 84.00, compression ratio: 1.50 
    Pointer pages: 18, data page slots: 28272 
    Data pages: 28272, average fill: 75% 
    Primary pages: 28265, secondary pages: 7, swept pages: 9003 
    Empty pages: 2, full pages: 23576 
    Fill distribution: 
     0 - 19% = 19 
    20 - 39% = 82 
    40 - 59% = 1078 
    60 - 79% = 26082 
    80 - 99% = 1011 
 
    Index DOC_LIST_ID_DESC (1) 
    Root page: 1541130, depth: 3, leaf buckets: 4597, nodes: 2272437 
    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: 701173, ratio: 0.31 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 839 
        40 - 59% = 955 
        60 - 79% = 732 
        80 - 99% = 2071 
 
    Index DOC_LIST_WORKER_OPTYPE (2) 
    Root page: 1544376, depth: 3, leaf buckets: 2508, nodes: 2275461 
    Average node length: 4.97, total dup: 2274562, max dup: 17880 
    Average key length: 2.01, compression ratio: 4.47 
    Average prefix length: 8.99, average data length: 0.01 
    Clustering factor: 1255295, ratio: 0.55 
    Fill distribution: 
         0 - 19% = 3 
        20 - 39% = 240 
        40 - 59% = 1502 
        60 - 79% = 535 
        80 - 99% = 228 
 
    Index FK_DOC_LIST_AGENTS (3) 
    Root page: 1545909, depth: 3, leaf buckets: 2020, nodes: 2272437 
    Average node length: 4.97, total dup: 2272387, max dup: 130348 
    Average key length: 2.01, compression ratio: 4.48 
    Average prefix length: 8.99, average data length: 0.01 
    Clustering factor: 1062092, ratio: 0.47 
    Fill distribution: 
         0 - 19% = 3 
        20 - 39% = 22 
        40 - 59% = 1101 
        60 - 79% = 63 
        80 - 99% = 831 
 
    Index PK_DOC_LIST (0) 
    Root page: 1538187, depth: 3, leaf buckets: 4360, nodes: 2272437 
    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: 701173, ratio: 0.31 
    Fill distribution: 
         0 - 19% = 103 
        20 - 39% = 503 
        40 - 59% = 667 
        60 - 79% = 849 
        80 - 99% = 2238 
 
DOC_STATES (149) 
    Primary pointer page: 494, Index root page: 495 
    Total formats: 1, used formats: 1 
    Average record length: 67.50, total records: 4 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 650.00, compression ratio: 9.63 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 4% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index DOC_STATES_MCODE_UNQ (1) 
    Root page: 1504315, depth: 1, leaf buckets: 1, nodes: 4 
    Average node length: 17.75, total dup: 0, max dup: 0 
    Average key length: 16.50, compression ratio: 1.08 
    Average prefix length: 4.00, average data length: 13.75 
    Clustering factor: 1, ratio: 0.25 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index DOC_STATES_NAME_UNQ (2) 
    Root page: 1504316, depth: 1, leaf buckets: 1, nodes: 4 
    Average node length: 33.25, total dup: 0, max dup: 0 
    Average key length: 32.00, compression ratio: 0.99 
    Average prefix length: 2.50, average data length: 29.25 
    Clustering factor: 1, ratio: 0.25 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PK_DOC_STATES (0) 
    Root page: 1504314, depth: 1, leaf buckets: 1, nodes: 4 
    Average node length: 4.75, total dup: 0, max dup: 0 
    Average key length: 3.50, compression ratio: 0.86 
    Average prefix length: 1.50, average data length: 1.50 
    Clustering factor: 1, ratio: 0.25 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
FB_ERRORS (155) 
    Primary pointer page: 506, Index root page: 507 
    Total formats: 2, used formats: 2 
    Average record length: 54.76, total records: 2182 
    Average version length: 79.61, total versions: 757, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 270.43, compression ratio: 4.94 
    Pointer pages: 1, data page slots: 40 
    Data pages: 40, average fill: 70% 
    Primary pages: 40, secondary pages: 0, swept pages: 0 
    Empty pages: 7, full pages: 32 
    Fill distribution: 
     0 - 19% = 7 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 7 
    80 - 99% = 26 
 
    Index FB_ERRORS_GDS_CODE (0) 
    Root page: 382, depth: 2, leaf buckets: 2, nodes: 2182 
    Average node length: 4.40, total dup: 756, max dup: 1 
    Average key length: 2.67, compression ratio: 1.87 
    Average prefix length: 4.33, average data length: 0.67 
    Clustering factor: 1515, ratio: 0.69 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 0 
        40 - 59% = 1 
        60 - 79% = 1 
        80 - 99% = 0 
 
INVNT_SALDO (145) 
    Primary pointer page: 486, Index root page: 487 
    Total formats: 2, used formats: 1 
    Average record length: 82.45, total records: 400 
    Average version length: 23.05, total versions: 230414, max versions: 601 
    Average fragment length: 2.00, total fragments: 47, max fragments: 1 
    Average unpacked length: 104.00, compression ratio: 1.26 
    Pointer pages: 1, data page slots: 1328 
    Data pages: 1272, average fill: 90% 
    Primary pages: 8, secondary pages: 1264, swept pages: 0 
    Empty pages: 1, full pages: 1270 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 1 
    80 - 99% = 1270 
 
    Index PK_INVNT_SALDO (0) 
    Root page: 1510349, depth: 1, leaf buckets: 1, nodes: 400 
    Average node length: 11.22, total dup: 0, max dup: 0 
    Average key length: 10.22, compression ratio: 0.88 
    Average prefix length: 1.78, average data length: 7.22 
    Clustering factor: 326, ratio: 0.81 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 0 
        40 - 59% = 1 
        60 - 79% = 0 
        80 - 99% = 0 
 
INVNT_TURNOVER_LOG (153) 
    Primary pointer page: 502, Index root page: 503 
    Total formats: 1, used formats: 1 
    Average record length: 11.69, total records: 106950 
    Average version length: 68.28, total versions: 88646, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 88.00, compression ratio: 7.52 
    Pointer pages: 7, data page slots: 2048 
    Data pages: 1944, average fill: 67% 
    Primary pages: 1943, secondary pages: 1, swept pages: 0 
    Empty pages: 304, full pages: 1325 
    Fill distribution: 
     0 - 19% = 376 
    20 - 39% = 72 
    40 - 59% = 75 
    60 - 79% = 225 
    80 - 99% = 1196 
 
    Index INVNT_TURNOVER_LOG_WARE_DD_ID (0) 
    Root page: 1700727, depth: 3, leaf buckets: 266, nodes: 106950 
    Average node length: 13.17, total dup: 7275, max dup: 2 
    Average key length: 10.68, compression ratio: 2.53 
    Average prefix length: 19.25, average data length: 7.75 
    Clustering factor: 78000, ratio: 0.73 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 2 
        40 - 59% = 114 
        60 - 79% = 81 
        80 - 99% = 68 
 
MONEY_SALDO (141) 
    Primary pointer page: 478, Index root page: 479 
    Total formats: 1, used formats: 1 
    Average record length: 15.27, total records: 49 
    Average version length: 9.00, total versions: 18204, max versions: 961 
    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: 64 
    Data pages: 64, average fill: 91% 
    Primary pages: 1, secondary pages: 63, swept pages: 0 
    Empty pages: 0, full pages: 63 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 1 
    40 - 59% = 0 
    60 - 79% = 1 
    80 - 99% = 62 
 
    Index PK_MONEY_SALDO (0) 
    Root page: 1510361, depth: 1, leaf buckets: 1, nodes: 49 
    Average node length: 11.82, total dup: 0, max dup: 0 
    Average key length: 10.80, compression ratio: 0.83 
    Average prefix length: 1.18, average data length: 7.82 
    Clustering factor: 1, ratio: 0.02 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
MONEY_TURNOVER_LOG (140) 
    Primary pointer page: 476, Index root page: 477 
    Total formats: 1, used formats: 1 
    Average record length: 17.47, total records: 2155 
    Average version length: 43.25, total versions: 1303, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 58.00, compression ratio: 3.32 
    Pointer pages: 1, data page slots: 40 
    Data pages: 26, average fill: 73% 
    Primary pages: 25, secondary pages: 1, swept pages: 1 
    Empty pages: 2, full pages: 20 
    Fill distribution: 
     0 - 19% = 4 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 5 
    80 - 99% = 17 
 
    Index MONEY_TURNOVER_LOG_AGENT_OPTYPE (0) 
    Root page: 89825, depth: 2, leaf buckets: 3, nodes: 2155 
    Average node length: 4.34, total dup: 2057, max dup: 211 
    Average key length: 2.47, compression ratio: 7.68 
    Average prefix length: 18.57, average data length: 0.43 
    Clustering factor: 1050, ratio: 0.49 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 1 
        40 - 59% = 2 
        60 - 79% = 0 
        80 - 99% = 0 
 
MON_CACHE_MEMORY (165) 
    Primary pointer page: 526, Index root page: 527 
    Total formats: 2, used formats: 1 
    Average record length: 97.07, total records: 72 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 112.00, compression ratio: 1.15 
    Pointer pages: 1, data page slots: 2 
    Data pages: 2, average fill: 50% 
    Primary pages: 2, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 1 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 1 
 
    Index PK_MON_CACHE_MEMORY (0) 
    Root page: 1504215, depth: 1, leaf buckets: 1, nodes: 72 
    Average node length: 11.69, total dup: 0, max dup: 0 
    Average key length: 10.68, compression ratio: 0.84 
    Average prefix length: 1.31, average data length: 7.69 
    Clustering factor: 2, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
MON_LOG (162) 
    Primary pointer page: 520, Index root page: 521 
    Total formats: 2, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index MON_LOG_DTS (4) 
    Root page: 1504229, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index MON_LOG_GDSCODE (2) 
    Root page: 1504227, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index MON_LOG_ROWSET_DESC (1) 
    Root page: 1504226, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index MON_LOG_UNIT (3) 
    Root page: 1504228, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PK_MON_LOG (0) 
    Root page: 1504225, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
MON_LOG_TABLE_STATS (163) 
    Primary pointer page: 522, Index root page: 523 
    Total formats: 2, used formats: 1 
    Average record length: 67.13, total records: 30 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 611.00, compression ratio: 9.10 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 31% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 1 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index MON_LOG_TABLE_STATS_DTS (4) 
    Root page: 1504224, depth: 1, leaf buckets: 1, nodes: 30 
    Average node length: 3.50, total dup: 23, max dup: 4 
    Average key length: 2.47, compression ratio: 3.24 
    Average prefix length: 7.53, average data length: 0.47 
    Clustering factor: 1, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index MON_LOG_TABLE_STATS_GDSCODE (2) 
    Root page: 1504222, depth: 1, leaf buckets: 1, nodes: 30 
    Average node length: 2.00, total dup: 29, max dup: 29 
    Average key length: 1.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 1, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index MON_LOG_TABLE_STATS_ROWSET (1) 
    Root page: 1504221, depth: 1, leaf buckets: 1, nodes: 30 
    Average node length: 3.33, total dup: 29, max dup: 29 
    Average key length: 2.30, compression ratio: 3.91 
    Average prefix length: 8.70, average data length: 0.30 
    Clustering factor: 1, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index MON_LOG_TABLE_STATS_TN_UNIT (3) 
    Root page: 1504223, depth: 1, leaf buckets: 1, nodes: 30 
    Average node length: 12.90, total dup: 0, max dup: 0 
    Average key length: 11.87, compression ratio: 1.42 
    Average prefix length: 7.63, average data length: 9.20 
    Clustering factor: 1, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PK_MON_LOG_TABLE_STATS (0) 
    Root page: 1504220, depth: 1, leaf buckets: 1, nodes: 30 
    Average node length: 8.37, total dup: 0, max dup: 0 
    Average key length: 7.33, compression ratio: 1.23 
    Average prefix length: 4.63, average data length: 4.37 
    Clustering factor: 1, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
OPTYPES (136) 
    Primary pointer page: 468, Index root page: 469 
    Total formats: 2, used formats: 1 
    Average record length: 67.56, total records: 9 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 386.00, compression ratio: 5.71 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 9% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index OPTYPES_MCODE_UNQ (1) 
    Root page: 1544805, depth: 1, leaf buckets: 1, nodes: 9 
    Average node length: 8.56, total dup: 0, max dup: 0 
    Average key length: 6.89, compression ratio: 0.73 
    Average prefix length: 0.44, average data length: 4.56 
    Clustering factor: 1, ratio: 0.11 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PK_OPTYPES (0) 
    Root page: 1544804, depth: 1, leaf buckets: 1, nodes: 9 
    Average node length: 6.11, total dup: 0, max dup: 0 
    Average key length: 5.00, compression ratio: 0.60 
    Average prefix length: 0.89, average data length: 2.11 
    Clustering factor: 1, ratio: 0.11 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
PDISTR (146) 
    Primary pointer page: 488, Index root page: 489 
    Total formats: 1, used formats: 1 
    Average record length: 35.87, total records: 820616 
    Average version length: 25.52, total versions: 77895, max versions: 5 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 54.00, compression ratio: 1.51 
    Pointer pages: 6, data page slots: 8312 
    Data pages: 8304, average fill: 69% 
    Primary pages: 8269, secondary pages: 35, swept pages: 1316 
    Empty pages: 102, full pages: 7450 
    Fill distribution: 
     0 - 19% = 213 
    20 - 39% = 152 
    40 - 59% = 165 
    60 - 79% = 7475 
    80 - 99% = 299 
 
    Index PDISTR_AGENT_ID (2) 
    Root page: 1509308, depth: 2, leaf buckets: 893, nodes: 820616 
    Average node length: 4.87, total dup: 820567, max dup: 150472 
    Average key length: 2.01, compression ratio: 4.48 
    Average prefix length: 8.99, average data length: 0.01 
    Clustering factor: 92003, ratio: 0.11 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 123 
        40 - 59% = 493 
        60 - 79% = 209 
        80 - 99% = 67 
 
    Index PDISTR_SNDOP_RCVOP_SNDID_ASC (0) 
    Root page: 1508613, depth: 3, leaf buckets: 1029, nodes: 820616 
    Average node length: 5.88, total dup: 730781, max dup: 47 
    Average key length: 3.02, compression ratio: 7.29 
    Average prefix length: 21.09, average data length: 0.91 
    Clustering factor: 164147, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 103 
        40 - 59% = 582 
        60 - 79% = 131 
        80 - 99% = 212 
 
    Index PDISTR_SNDOP_RCVOP_SNDID_DESC (1) 
    Root page: 1509187, depth: 3, leaf buckets: 1073, nodes: 820616 
    Average node length: 5.88, total dup: 730781, max dup: 47 
    Average key length: 3.02, compression ratio: 7.29 
    Average prefix length: 21.09, average data length: 0.91 
    Clustering factor: 166164, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 204 
        40 - 59% = 551 
        60 - 79% = 105 
        80 - 99% = 213 
 
    Index PDISTR_WORKER_SND_ID (3) 
    Root page: 1510178, depth: 3, leaf buckets: 1167, nodes: 820616 
    Average node length: 5.96, total dup: 730781, max dup: 47 
    Average key length: 3.10, compression ratio: 5.49 
    Average prefix length: 16.01, average data length: 0.99 
    Clustering factor: 159135, ratio: 0.19 
    Fill distribution: 
         0 - 19% = 5 
        20 - 39% = 267 
        40 - 59% = 571 
        60 - 79% = 243 
        80 - 99% = 81 
 
PERF_AGG (158) 
    Primary pointer page: 512, Index root page: 513 
    Total formats: 1, used formats: 1 
    Average record length: 62.76, total records: 5405 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 2.52, total fragments: 91, max fragments: 1 
    Average unpacked length: 379.00, compression ratio: 6.04 
    Pointer pages: 1, data page slots: 104 
    Data pages: 103, average fill: 52% 
    Primary pages: 76, secondary pages: 27, swept pages: 50 
    Empty pages: 19, full pages: 64 
    Fill distribution: 
     0 - 19% = 33 
    20 - 39% = 0 
    40 - 59% = 3 
    60 - 79% = 66 
    80 - 99% = 1 
 
    Index PERF_AGG_UNQ (1) 
    Root page: 1504238, depth: 2, leaf buckets: 6, nodes: 5405 
    Average node length: 5.50, total dup: 0, max dup: 0 
    Average key length: 3.59, compression ratio: 9.99 
    Average prefix length: 34.31, average data length: 1.55 
    Clustering factor: 5178, ratio: 0.96 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 2 
        60 - 79% = 1 
        80 - 99% = 2 
 
    Index PK_PERF_AGG (0) 
    Root page: 1504233, depth: 2, leaf buckets: 10, nodes: 5405 
    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: 151, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 1 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 7 
 
PERF_ESTIMATED (280) 
    Primary pointer page: 1504218, Index root page: 1504219 
    Total formats: 1, used formats: 1 
    Average record length: 39.10, total records: 80817 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 48.00, compression ratio: 1.23 
    Pointer pages: 1, data page slots: 784 
    Data pages: 784, average fill: 71% 
    Primary pages: 784, secondary pages: 0, swept pages: 0 
    Empty pages: 5, full pages: 778 
    Fill distribution: 
     0 - 19% = 5 
    20 - 39% = 1 
    40 - 59% = 0 
    60 - 79% = 778 
    80 - 99% = 0 
 
    Index PK_PERF_ESTIMATED (0) 
    Root page: 36825, depth: 2, leaf buckets: 104, nodes: 80817 
    Average node length: 10.18, total dup: 0, max dup: 0 
    Average key length: 8.19, compression ratio: 1.10 
    Average prefix length: 3.81, average data length: 5.19 
    Clustering factor: 3087, ratio: 0.04 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 2 
        60 - 79% = 0 
        80 - 99% = 101 
 
PERF_ISQL_STAT (156) 
    Primary pointer page: 508, Index root page: 509 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index PERF_ISQL_STAT_TRN (0) 
    Root page: 1504239, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
PERF_LOG (159) 
    Primary pointer page: 514, Index root page: 515 
    Total formats: 1, used formats: 1 
    Average record length: 110.64, total records: 72 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1691.00, compression ratio: 15.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: 573, Index root page: 574 
    Total formats: 1, used formats: 1 
    Average record length: 147.21, total records: 165486 
    Average version length: 151.43, total versions: 4357, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.52 
    Pointer pages: 8, data page slots: 5768 
    Data pages: 4016, average fill: 85% 
    Primary pages: 4016, secondary pages: 0, swept pages: 5 
    Empty pages: 81, full pages: 3916 
    Fill distribution: 
     0 - 19% = 87 
    20 - 39% = 6 
    40 - 59% = 2 
    60 - 79% = 5 
    80 - 99% = 3916 
 
PERF_SPLIT_1 (282) 
    Primary pointer page: 576, Index root page: 577 
    Total formats: 1, used formats: 1 
    Average record length: 122.46, total records: 198227 
    Average version length: 154.32, total versions: 37399, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 13.85 
    Pointer pages: 6, data page slots: 5720 
    Data pages: 4784, average fill: 87% 
    Primary pages: 4784, secondary pages: 0, swept pages: 5 
    Empty pages: 61, full pages: 4706 
    Fill distribution: 
     0 - 19% = 64 
    20 - 39% = 8 
    40 - 59% = 2 
    60 - 79% = 4 
    80 - 99% = 4706 
 
PERF_SPLIT_2 (283) 
    Primary pointer page: 578, Index root page: 579 
    Total formats: 1, used formats: 1 
    Average record length: 148.09, total records: 152423 
    Average version length: 151.58, total versions: 2650, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.45 
    Pointer pages: 7, data page slots: 4504 
    Data pages: 3664, average fill: 86% 
    Primary pages: 3664, secondary pages: 0, swept pages: 3 
    Empty pages: 46, full pages: 3596 
    Fill distribution: 
     0 - 19% = 49 
    20 - 39% = 8 
    40 - 59% = 5 
    60 - 79% = 5 
    80 - 99% = 3597 
 
PERF_SPLIT_3 (284) 
    Primary pointer page: 580, Index root page: 581 
    Total formats: 1, used formats: 1 
    Average record length: 139.72, total records: 169552 
    Average version length: 154.08, total versions: 12466, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 12.14 
    Pointer pages: 7, data page slots: 5664 
    Data pages: 4104, average fill: 86% 
    Primary pages: 4104, secondary pages: 0, swept pages: 11 
    Empty pages: 71, full pages: 4008 
    Fill distribution: 
     0 - 19% = 76 
    20 - 39% = 8 
    40 - 59% = 6 
    60 - 79% = 7 
    80 - 99% = 4007 
 
PERF_SPLIT_4 (285) 
    Primary pointer page: 582, Index root page: 583 
    Total formats: 1, used formats: 1 
    Average record length: 143.89, total records: 142917 
    Average version length: 153.08, total versions: 6695, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.79 
    Pointer pages: 8, data page slots: 4216 
    Data pages: 3440, average fill: 86% 
    Primary pages: 3439, secondary pages: 1, swept pages: 4 
    Empty pages: 43, full pages: 3378 
    Fill distribution: 
     0 - 19% = 50 
    20 - 39% = 3 
    40 - 59% = 2 
    60 - 79% = 6 
    80 - 99% = 3379 
 
PERF_SPLIT_5 (286) 
    Primary pointer page: 584, Index root page: 585 
    Total formats: 1, used formats: 1 
    Average record length: 136.19, total records: 163186 
    Average version length: 154.26, total versions: 15732, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 12.45 
    Pointer pages: 6, data page slots: 4600 
    Data pages: 3912, average fill: 87% 
    Primary pages: 3912, secondary pages: 0, swept pages: 1 
    Empty pages: 38, full pages: 3862 
    Fill distribution: 
     0 - 19% = 44 
    20 - 39% = 1 
    40 - 59% = 2 
    60 - 79% = 3 
    80 - 99% = 3862 
 
PERF_SPLIT_6 (287) 
    Primary pointer page: 586, Index root page: 587 
    Total formats: 1, used formats: 1 
    Average record length: 145.54, total records: 173210 
    Average version length: 152.59, total versions: 6365, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.65 
    Pointer pages: 7, data page slots: 4520 
    Data pages: 4168, average fill: 86% 
    Primary pages: 4168, secondary pages: 0, swept pages: 6 
    Empty pages: 51, full pages: 4100 
    Fill distribution: 
     0 - 19% = 56 
    20 - 39% = 6 
    40 - 59% = 3 
    60 - 79% = 2 
    80 - 99% = 4101 
 
PERF_SPLIT_7 (288) 
    Primary pointer page: 588, Index root page: 589 
    Total formats: 1, used formats: 1 
    Average record length: 143.06, total records: 167617 
    Average version length: 153.00, total versions: 8629, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.86 
    Pointer pages: 6, data page slots: 6160 
    Data pages: 4064, average fill: 85% 
    Primary pages: 4064, secondary pages: 0, swept pages: 3 
    Empty pages: 83, full pages: 3956 
    Fill distribution: 
     0 - 19% = 86 
    20 - 39% = 6 
    40 - 59% = 12 
    60 - 79% = 4 
    80 - 99% = 3956 
 
PERF_SPLIT_8 (289) 
    Primary pointer page: 590, Index root page: 591 
    Total formats: 1, used formats: 1 
    Average record length: 146.86, total records: 163662 
    Average version length: 151.33, total versions: 4429, 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: 4600 
    Data pages: 3920, average fill: 86% 
    Primary pages: 3919, secondary pages: 1, swept pages: 1 
    Empty pages: 35, full pages: 3872 
    Fill distribution: 
     0 - 19% = 38 
    20 - 39% = 9 
    40 - 59% = 1 
    60 - 79% = 0 
    80 - 99% = 3872 
 
PERF_SPLIT_9 (290) 
    Primary pointer page: 593, Index root page: 594 
    Total formats: 1, used formats: 1 
    Average record length: 146.19, total records: 158284 
    Average version length: 152.93, total versions: 4961, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.60 
    Pointer pages: 6, data page slots: 3992 
    Data pages: 3808, average fill: 86% 
    Primary pages: 3808, secondary pages: 0, swept pages: 6 
    Empty pages: 48, full pages: 3743 
    Fill distribution: 
     0 - 19% = 53 
    20 - 39% = 8 
    40 - 59% = 0 
    60 - 79% = 4 
    80 - 99% = 3743 
 
PHRASES (143) 
    Primary pointer page: 482, Index root page: 483 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index PHRASES_ID_DESC (3) 
    Root page: 1510354, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PHRASES_NAME (2) 
    Root page: 1510353, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PHRASES_UNQ (1) 
    Root page: 1510352, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PK_PHRASES (0) 
    Root page: 1510351, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
PSTORNED (147) 
    Primary pointer page: 490, Index root page: 491 
    Total formats: 1, used formats: 1 
    Average record length: 51.54, total records: 2104071 
    Average version length: 52.85, total versions: 48542, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 70.00, compression ratio: 1.36 
    Pointer pages: 16, data page slots: 25416 
    Data pages: 25408, average fill: 71% 
    Primary pages: 25408, secondary pages: 0, swept pages: 10036 
    Empty pages: 275, full pages: 21281 
    Fill distribution: 
     0 - 19% = 502 
    20 - 39% = 406 
    40 - 59% = 1013 
    60 - 79% = 23060 
    80 - 99% = 427 
 
    Index PSTORNED_RCV_ID (1) 
    Root page: 1506186, depth: 3, leaf buckets: 2595, nodes: 2104071 
    Average node length: 5.44, total dup: 1963799, max dup: 1511 
    Average key length: 2.49, compression ratio: 3.62 
    Average prefix length: 8.58, average data length: 0.42 
    Clustering factor: 182400, ratio: 0.09 
    Fill distribution: 
         0 - 19% = 8 
        20 - 39% = 274 
        40 - 59% = 1730 
        60 - 79% = 291 
        80 - 99% = 292 
 
    Index PSTORNED_SND_ID (0) 
    Root page: 1504819, depth: 3, leaf buckets: 2759, nodes: 2104071 
    Average node length: 5.69, total dup: 1888962, max dup: 70 
    Average key length: 2.74, compression ratio: 3.29 
    Average prefix length: 8.36, average data length: 0.64 
    Clustering factor: 376704, ratio: 0.18 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 8 
        40 - 59% = 2383 
        60 - 79% = 346 
        80 - 99% = 20 
 
    Index PSTORNED_WORKER_ID (2) 
    Root page: 1507996, depth: 3, leaf buckets: 2160, nodes: 2104071 
    Average node length: 4.96, total dup: 2103971, max dup: 28461 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.41, average data length: 0.00 
    Clustering factor: 180062, ratio: 0.09 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 186 
        40 - 59% = 1206 
        60 - 79% = 372 
        80 - 99% = 395 
 
RULES_FOR_PDISTR (148) 
    Primary pointer page: 492, Index root page: 493 
    Total formats: 1, used formats: 1 
    Average record length: 17.00, total records: 4 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 334.00, compression ratio: 19.65 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 2% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index RULES_FOR_PDISTR_UNQ (0) 
    Root page: 1504317, depth: 1, leaf buckets: 1, nodes: 4 
    Average node length: 11.50, total dup: 0, max dup: 0 
    Average key length: 10.25, compression ratio: 0.88 
    Average prefix length: 1.50, average data length: 7.50 
    Clustering factor: 1, ratio: 0.25 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
RULES_FOR_QDISTR (137) 
    Primary pointer page: 470, Index root page: 471 
    Total formats: 1, used formats: 1 
    Average record length: 32.71, total records: 7 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 332.00, compression ratio: 10.15 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 4% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index RULES_FOR_QDISTR_RCVOP (1) 
    Root page: 1544803, depth: 1, leaf buckets: 1, nodes: 7 
    Average node length: 5.29, total dup: 2, max dup: 2 
    Average key length: 4.14, compression ratio: 0.72 
    Average prefix length: 1.43, average data length: 1.57 
    Clustering factor: 1, ratio: 0.14 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index RULES_FOR_QDISTR_UNQ (0) 
    Root page: 1544802, depth: 1, leaf buckets: 1, nodes: 7 
    Average node length: 10.14, total dup: 0, max dup: 0 
    Average key length: 8.86, compression ratio: 0.94 
    Average prefix length: 2.14, average data length: 6.14 
    Clustering factor: 1, ratio: 0.14 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
SEMAPHORES (152) 
    Primary pointer page: 500, Index root page: 501 
    Total formats: 1, used formats: 1 
    Average record length: 43.40, total records: 5 
    Average version length: 9.00, total versions: 1, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 346.00, compression ratio: 7.97 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 4% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index PK_SEMAPHORES (0) 
    Root page: 1504305, depth: 1, leaf buckets: 1, nodes: 5 
    Average node length: 12.40, total dup: 0, max dup: 0 
    Average key length: 11.00, compression ratio: 0.82 
    Average prefix length: 0.60, average data length: 8.40 
    Clustering factor: 1, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index SEMAPHORES_TASK_UNQ (1) 
    Root page: 1504306, depth: 1, leaf buckets: 1, nodes: 5 
    Average node length: 23.40, total dup: 0, max dup: 0 
    Average key length: 22.00, compression ratio: 1.07 
    Average prefix length: 4.20, average data length: 19.40 
    Clustering factor: 1, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
SETTINGS (135) 
    Primary pointer page: 466, Index root page: 467 
    Total formats: 1, used formats: 1 
    Average record length: 97.63, total records: 149 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1347.00, compression ratio: 13.80 
    Pointer pages: 1, data page slots: 3 
    Data pages: 3, average fill: 70% 
    Primary pages: 3, secondary pages: 0, swept pages: 2 
    Empty pages: 0, full pages: 2 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 1 
    60 - 79% = 0 
    80 - 99% = 2 
 
    Index SETTINGS_MCODE_WM_UNQ (1) 
    Root page: 525, depth: 1, leaf buckets: 1, nodes: 149 
    Average node length: 14.66, total dup: 0, max dup: 0 
    Average key length: 13.55, compression ratio: 2.19 
    Average prefix length: 19.07, average data length: 10.66 
    Clustering factor: 48, ratio: 0.32 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 1 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index SETTINGS_MODE_CODE (0) 
    Root page: 1544806, depth: 1, leaf buckets: 1, nodes: 149 
    Average node length: 25.56, total dup: 0, max dup: 0 
    Average key length: 24.56, compression ratio: 1.63 
    Average prefix length: 18.58, average data length: 21.56 
    Clustering factor: 14, ratio: 0.09 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 0 
        40 - 59% = 1 
        60 - 79% = 0 
        80 - 99% = 0 
 
TMP$DEP_DOCS (129) 
    Primary pointer page: 454, Index root page: 455 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index TMP_DEP_DOCS_UNQ (0) 
    Root page: 1544810, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
TMP$IDX_RECALC (132) 
    Primary pointer page: 460, Index root page: 461 
    Total formats: 2, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index TMP_IDX_RECALC_IDX_NAME_UNQ (0) 
    Root page: 1544807, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
TMP$MON_LOG (133) 
    Primary pointer page: 462, Index root page: 463 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
TMP$MON_LOG_TABLE_STATS (134) 
    Primary pointer page: 464, Index root page: 465 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
TMP$PERF_EST_WHOLE (161) 
    Primary pointer page: 518, Index root page: 519 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
TMP$PERF_LOG (160) 
    Primary pointer page: 516, Index root page: 517 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index TMP$PERF_LOG_UNIT_TRN_DTS_END (0) 
    Root page: 1504230, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
TMP$PERF_MON (131) 
    Primary pointer page: 458, Index root page: 459 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
TMP$RESULT_SET (130) 
    Primary pointer page: 456, Index root page: 457 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index TMP_RESULT_SET_DOC (1) 
    Root page: 1544809, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index TMP_RESULT_SET_WARE_DOC (0) 
    Root page: 1544808, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
TMP$SHOPPING_CART (128) 
    Primary pointer page: 452, Index root page: 453 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index TMP_SHOPCART_UNQ (0) 
    Root page: 1544811, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
TPAUSE (166) 
    Primary pointer page: 528, Index root page: 529 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index RDB$PRIMARY2 (0) 
    Root page: 1504214, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
TRACE_STAT (157) 
    Primary pointer page: 510, Index root page: 511 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
WARES (142) 
    Primary pointer page: 480, Index root page: 481 
    Total formats: 1, used formats: 1 
    Average record length: 77.52, total records: 400 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 444.00, compression ratio: 5.73 
    Pointer pages: 1, data page slots: 6 
    Data pages: 6, average fill: 77% 
    Primary pages: 6, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 5 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 5 
    80 - 99% = 1 
 
    Index FK_WARES_WARE_GROUPS (3) 
    Root page: 1552159, depth: 1, leaf buckets: 1, nodes: 400 
    Average node length: 3.17, total dup: 392, max dup: 60 
    Average key length: 2.16, compression ratio: 4.16 
    Average prefix length: 8.86, average data length: 0.14 
    Clustering factor: 48, ratio: 0.12 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PK_WARES (0) 
    Root page: 1510355, depth: 1, leaf buckets: 1, nodes: 400 
    Average node length: 11.22, total dup: 0, max dup: 0 
    Average key length: 10.22, compression ratio: 0.88 
    Average prefix length: 1.78, average data length: 7.22 
    Clustering factor: 344, ratio: 0.86 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 0 
        40 - 59% = 1 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index WARES_ID_DESC (2) 
    Root page: 1510360, depth: 1, leaf buckets: 1, nodes: 400 
    Average node length: 11.22, total dup: 0, max dup: 0 
    Average key length: 10.22, compression ratio: 0.88 
    Average prefix length: 1.78, average data length: 7.22 
    Clustering factor: 344, ratio: 0.86 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 0 
        40 - 59% = 1 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index WARES_NUMB_UNQ (1) 
    Root page: 1510358, depth: 2, leaf buckets: 3, nodes: 400 
    Average node length: 53.25, total dup: 0, max dup: 0 
    Average key length: 52.23, compression ratio: 1.00 
    Average prefix length: 2.74, average data length: 49.25 
    Clustering factor: 355, ratio: 0.89 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 1 
        80 - 99% = 2 
 
WARE_GROUPS (151) 
    Primary pointer page: 498, Index root page: 499 
    Total formats: 1, used formats: 1 
    Average record length: 32.12, total records: 8 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 346.00, compression ratio: 10.77 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 5% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index PK_WARE_GROUPS (0) 
    Root page: 1504307, depth: 1, leaf buckets: 1, nodes: 8 
    Average node length: 11.25, total dup: 0, max dup: 0 
    Average key length: 10.12, compression ratio: 0.89 
    Average prefix length: 1.75, average data length: 7.25 
    Clustering factor: 1, ratio: 0.12 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index WARE_GROUPS_NAME_UNQ (1) 
    Root page: 1504308, depth: 1, leaf buckets: 1, nodes: 8 
    Average node length: 19.88, total dup: 0, max dup: 0 
    Average key length: 18.12, compression ratio: 0.89 
    Average prefix length: 0.25, average data length: 15.88 
    Clustering factor: 1, ratio: 0.12 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
XQD_1000_1200 (176) 
    Primary pointer page: 549, Index root page: 550 
    Total formats: 1, used formats: 1 
    Average record length: 36.94, total records: 155028 
    Average version length: 69.19, total versions: 72338, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 3.41 
    Pointer pages: 3, data page slots: 4128 
    Data pages: 3152, average fill: 57% 
    Primary pages: 3152, secondary pages: 0, swept pages: 489 
    Empty pages: 632, full pages: 2052 
    Fill distribution: 
     0 - 19% = 864 
    20 - 39% = 131 
    40 - 59% = 68 
    60 - 79% = 685 
    80 - 99% = 1404 
 
    Index XQD_1000_1200_WA_SO_RO_WKR_SND (0) 
    Root page: 106046, depth: 3, leaf buckets: 221, nodes: 155028 
    Average node length: 6.42, total dup: 135174, max dup: 29 
    Average key length: 3.91, compression ratio: 10.73 
    Average prefix length: 40.21, average data length: 1.79 
    Clustering factor: 26420, ratio: 0.17 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 30 
        40 - 59% = 111 
        60 - 79% = 58 
        80 - 99% = 21 
 
XQD_1000_3300 (178) 
    Primary pointer page: 553, Index root page: 554 
    Total formats: 1, used formats: 1 
    Average record length: 64.08, total records: 7075153 
    Average version length: 68.79, total versions: 501224, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.97 
    Pointer pages: 63, data page slots: 102800 
    Data pages: 102800, average fill: 74% 
    Primary pages: 102800, secondary pages: 0, swept pages: 19415 
    Empty pages: 128, full pages: 83112 
    Fill distribution: 
     0 - 19% = 946 
    20 - 39% = 1980 
    40 - 59% = 6092 
    60 - 79% = 84550 
    80 - 99% = 9232 
 
    Index XQD_1000_3300_WA_SO_RO_WKR_SND (0) 
    Root page: 1480454, depth: 3, leaf buckets: 10788, nodes: 7075153 
    Average node length: 6.51, total dup: 6121418, max dup: 29 
    Average key length: 3.52, compression ratio: 11.94 
    Average prefix length: 40.62, average data length: 1.38 
    Clustering factor: 1574040, ratio: 0.22 
    Fill distribution: 
         0 - 19% = 8 
        20 - 39% = 1568 
        40 - 59% = 6139 
        60 - 79% = 2735 
        80 - 99% = 338 
 
    Index XQD_1000_3300_WKR_DOC_ASC (1) 
    Root page: 1486068, depth: 3, leaf buckets: 8547, nodes: 7075153 
    Average node length: 5.40, total dup: 6792660, max dup: 171 
    Average key length: 2.41, compression ratio: 7.06 
    Average prefix length: 16.63, average data length: 0.37 
    Clustering factor: 1369545, ratio: 0.19 
    Fill distribution: 
         0 - 19% = 10 
        20 - 39% = 1318 
        40 - 59% = 4596 
        60 - 79% = 1495 
        80 - 99% = 1128 
 
    Index XQD_1000_3300_WKR_DOC_DEC (2) 
    Root page: 1490608, depth: 3, leaf buckets: 8619, nodes: 7075153 
    Average node length: 5.40, total dup: 6792660, max dup: 171 
    Average key length: 2.41, compression ratio: 7.06 
    Average prefix length: 16.63, average data length: 0.37 
    Clustering factor: 1372024, ratio: 0.19 
    Fill distribution: 
         0 - 19% = 6 
        20 - 39% = 1396 
        40 - 59% = 4631 
        60 - 79% = 1483 
        80 - 99% = 1103 
 
XQD_1200_2000 (177) 
    Primary pointer page: 551, Index root page: 552 
    Total formats: 1, used formats: 1 
    Average record length: 66.51, total records: 12023954 
    Average version length: 68.76, total versions: 427561, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.89 
    Pointer pages: 103, data page slots: 166872 
    Data pages: 166872, average fill: 77% 
    Primary pages: 166872, secondary pages: 0, swept pages: 64751 
    Empty pages: 15, full pages: 157658 
    Fill distribution: 
     0 - 19% = 70 
    20 - 39% = 568 
    40 - 59% = 3022 
    60 - 79% = 154415 
    80 - 99% = 8797 
 
    Index XQD_1200_2000_WA_SO_RO_WKR_SND (0) 
    Root page: 1495028, depth: 3, leaf buckets: 18352, nodes: 12023954 
    Average node length: 6.57, total dup: 10482733, max dup: 60 
    Average key length: 3.42, compression ratio: 12.26 
    Average prefix length: 40.70, average data length: 1.30 
    Clustering factor: 2362358, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 25 
        20 - 39% = 2208 
        40 - 59% = 11065 
        60 - 79% = 4335 
        80 - 99% = 719 
 
XQD_2000_3300 (179) 
    Primary pointer page: 555, Index root page: 556 
    Total formats: 1, used formats: 1 
    Average record length: 40.35, total records: 1853000 
    Average version length: 69.12, total versions: 771677, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 3.12 
    Pointer pages: 27, data page slots: 43216 
    Data pages: 29399, average fill: 72% 
    Primary pages: 29399, secondary pages: 0, swept pages: 4406 
    Empty pages: 1456, full pages: 23224 
    Fill distribution: 
     0 - 19% = 2635 
    20 - 39% = 1402 
    40 - 59% = 1181 
    60 - 79% = 10994 
    80 - 99% = 13187 
 
    Index XQD_2000_3300_WA_SO_RO_WKR_SND (0) 
    Root page: 1479712, depth: 3, leaf buckets: 2316, nodes: 1853000 
    Average node length: 5.51, total dup: 1778640, max dup: 99 
    Average key length: 2.54, compression ratio: 16.51 
    Average prefix length: 41.49, average data length: 0.51 
    Clustering factor: 127563, ratio: 0.07 
    Fill distribution: 
         0 - 19% = 11 
        20 - 39% = 371 
        40 - 59% = 1122 
        60 - 79% = 617 
        80 - 99% = 195 
 
XQD_2100_3300 (180) 
    Primary pointer page: 557, Index root page: 558 
    Total formats: 1, used formats: 1 
    Average record length: 36.95, total records: 1087522 
    Average version length: 69.13, total versions: 505357, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 3.41 
    Pointer pages: 22, data page slots: 34488 
    Data pages: 28688, average fill: 44% 
    Primary pages: 28688, secondary pages: 0, swept pages: 8240 
    Empty pages: 7625, full pages: 12604 
    Fill distribution: 
     0 - 19% = 11808 
    20 - 39% = 1903 
    40 - 59% = 1121 
    60 - 79% = 5396 
    80 - 99% = 8460 
 
    Index XQD_2100_3300_WA_SO_RO_WKR_SND (0) 
    Root page: 1479207, depth: 3, leaf buckets: 1482, nodes: 1087522 
    Average node length: 5.76, total dup: 1017751, max dup: 123 
    Average key length: 2.83, compression ratio: 14.84 
    Average prefix length: 41.23, average data length: 0.77 
    Clustering factor: 145194, ratio: 0.13 
    Fill distribution: 
         0 - 19% = 7 
        20 - 39% = 324 
        40 - 59% = 683 
        60 - 79% = 373 
        80 - 99% = 95 
 
XQD_3300_3400 (181) 
    Primary pointer page: 559, Index root page: 560 
    Total formats: 1, used formats: 1 
    Average record length: 65.13, total records: 9405562 
    Average version length: 68.98, total versions: 514252, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.93 
    Pointer pages: 88, data page slots: 143048 
    Data pages: 143024, average fill: 70% 
    Primary pages: 143024, secondary pages: 0, swept pages: 48006 
    Empty pages: 282, full pages: 89731 
    Fill distribution: 
     0 - 19% = 1076 
    20 - 39% = 4849 
    40 - 59% = 18815 
    60 - 79% = 109137 
    80 - 99% = 9147 
 
    Index XQD_3300_3400_WA_SO_RO_WKR_SND (0) 
    Root page: 1472590, depth: 3, leaf buckets: 13486, nodes: 9405562 
    Average node length: 6.67, total dup: 7803097, max dup: 27 
    Average key length: 3.66, compression ratio: 11.47 
    Average prefix length: 40.51, average data length: 1.49 
    Clustering factor: 2023812, ratio: 0.22 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 915 
        40 - 59% = 6761 
        60 - 79% = 5135 
        80 - 99% = 673 
 
XQS_1000_1200 (182) 
    Primary pointer page: 561, Index root page: 562 
    Total formats: 1, used formats: 1 
    Average record length: 82.47, total records: 21151879 
    Average version length: 82.93, total versions: 16581, 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: 318760 
    Data pages: 318760, average fill: 81% 
    Primary pages: 318760, secondary pages: 0, swept pages: 12562 
    Empty pages: 34, full pages: 318238 
    Fill distribution: 
     0 - 19% = 49 
    20 - 39% = 34 
    40 - 59% = 43 
    60 - 79% = 27415 
    80 - 99% = 291219 
 
    Index XQS_1000_1200_DOC_ID (1) 
    Root page: 1426716, depth: 3, leaf buckets: 19628, nodes: 21151879 
    Average node length: 5.72, total dup: 20670813, max dup: 162 
    Average key length: 2.16, compression ratio: 4.16 
    Average prefix length: 8.86, average data length: 0.14 
    Clustering factor: 3281281, ratio: 0.16 
    Fill distribution: 
         0 - 19% = 5 
        20 - 39% = 0 
        40 - 59% = 8622 
        60 - 79% = 569 
        80 - 99% = 10432 
 
    Index XQS_1000_1200_RCV_ID (3) 
    Root page: 1456980, depth: 3, leaf buckets: 17184, nodes: 21151879 
    Average node length: 6.31, total dup: 18588473, max dup: 49 
    Average key length: 2.75, compression ratio: 3.27 
    Average prefix length: 8.37, average data length: 0.63 
    Clustering factor: 914281, ratio: 0.04 
    Fill distribution: 
         0 - 19% = 4 
        20 - 39% = 1 
        40 - 59% = 812 
        60 - 79% = 269 
        80 - 99% = 16098 
 
    Index XQS_1000_1200_SND_ID (2) 
    Root page: 1441073, depth: 3, leaf buckets: 21445, nodes: 21151879 
    Average node length: 6.35, total dup: 18507368, max dup: 29 
    Average key length: 2.79, compression ratio: 3.23 
    Average prefix length: 8.34, average data length: 0.66 
    Clustering factor: 3575773, ratio: 0.17 
    Fill distribution: 
         0 - 19% = 6 
        20 - 39% = 1 
        40 - 59% = 8965 
        60 - 79% = 606 
        80 - 99% = 11867 
 
    Index XQS_1000_1200_WORKER_ID (0) 
    Root page: 1413348, depth: 3, leaf buckets: 16111, nodes: 21151879 
    Average node length: 5.56, total dup: 21151779, max dup: 230053 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.42, average data length: 0.00 
    Clustering factor: 943191, ratio: 0.04 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 8 
        40 - 59% = 2887 
        60 - 79% = 423 
        80 - 99% = 12792 
 
XQS_1000_3300 (184) 
    Primary pointer page: 565, Index root page: 566 
    Total formats: 1, used formats: 1 
    Average record length: 77.97, total records: 9874885 
    Average version length: 82.64, total versions: 533297, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.62 
    Pointer pages: 104, data page slots: 169480 
    Data pages: 169464, average fill: 72% 
    Primary pages: 169464, secondary pages: 0, swept pages: 63270 
    Empty pages: 284, full pages: 109943 
    Fill distribution: 
     0 - 19% = 1219 
    20 - 39% = 6050 
    40 - 59% = 22646 
    60 - 79% = 65966 
    80 - 99% = 73583 
 
    Index XQS_1000_3300_DOC_ID (1) 
    Root page: 1367502, depth: 3, leaf buckets: 11352, nodes: 9874885 
    Average node length: 5.36, total dup: 9564885, max dup: 282 
    Average key length: 2.23, compression ratio: 4.04 
    Average prefix length: 8.80, average data length: 0.20 
    Clustering factor: 2153125, ratio: 0.22 
    Fill distribution: 
         0 - 19% = 3 
        20 - 39% = 47 
        40 - 59% = 7730 
        60 - 79% = 3461 
        80 - 99% = 111 
 
    Index XQS_1000_3300_RCV_ID (3) 
    Root page: 1379261, depth: 3, leaf buckets: 13698, nodes: 9874885 
    Average node length: 6.23, total dup: 8187421, max dup: 14 
    Average key length: 3.10, compression ratio: 2.90 
    Average prefix length: 8.07, average data length: 0.93 
    Clustering factor: 1486284, ratio: 0.15 
    Fill distribution: 
         0 - 19% = 152 
        20 - 39% = 3742 
        40 - 59% = 4698 
        60 - 79% = 2635 
        80 - 99% = 2471 
 
    Index XQS_1000_3300_SND_ID (2) 
    Root page: 1373059, depth: 3, leaf buckets: 12682, nodes: 9874885 
    Average node length: 5.97, total dup: 8578132, max dup: 44 
    Average key length: 2.84, compression ratio: 3.17 
    Average prefix length: 8.29, average data length: 0.71 
    Clustering factor: 2352767, ratio: 0.24 
    Fill distribution: 
         0 - 19% = 4 
        20 - 39% = 44 
        40 - 59% = 8746 
        60 - 79% = 3762 
        80 - 99% = 126 
 
    Index XQS_1000_3300_WORKER_ID (0) 
    Root page: 1362767, depth: 3, leaf buckets: 10316, nodes: 9874885 
    Average node length: 5.13, total dup: 9874785, max dup: 146701 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.42, average data length: 0.00 
    Clustering factor: 1517379, ratio: 0.15 
    Fill distribution: 
         0 - 19% = 51 
        20 - 39% = 1156 
        40 - 59% = 5230 
        60 - 79% = 1868 
        80 - 99% = 2011 
 
XQS_1200_2000 (183) 
    Primary pointer page: 563, Index root page: 564 
    Total formats: 1, used formats: 1 
    Average record length: 79.47, total records: 11516688 
    Average version length: 82.55, total versions: 396740, 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: 119, data page slots: 192688 
    Data pages: 191416, average fill: 74% 
    Primary pages: 191416, secondary pages: 0, swept pages: 64198 
    Empty pages: 2882, full pages: 148454 
    Fill distribution: 
     0 - 19% = 4690 
    20 - 39% = 6301 
    40 - 59% = 15575 
    60 - 79% = 41301 
    80 - 99% = 123549 
 
    Index XQS_1200_2000_DOC_ID (1) 
    Root page: 1392101, depth: 3, leaf buckets: 13125, nodes: 11516688 
    Average node length: 5.30, total dup: 11406650, max dup: 636 
    Average key length: 2.08, compression ratio: 4.33 
    Average prefix length: 8.93, average data length: 0.07 
    Clustering factor: 2400269, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 71 
        40 - 59% = 8634 
        60 - 79% = 4259 
        80 - 99% = 159 
 
    Index XQS_1200_2000_RCV_ID (3) 
    Root page: 1406110, depth: 3, leaf buckets: 10645, nodes: 11516688 
    Average node length: 5.50, total dup: 11015125, max dup: 49 
    Average key length: 2.28, compression ratio: 3.95 
    Average prefix length: 8.77, average data length: 0.23 
    Clustering factor: 720062, ratio: 0.06 
    Fill distribution: 
         0 - 19% = 157 
        20 - 39% = 823 
        40 - 59% = 2686 
        60 - 79% = 1872 
        80 - 99% = 5107 
 
    Index XQS_1200_2000_SND_ID (2) 
    Root page: 1398638, depth: 3, leaf buckets: 15010, nodes: 11516688 
    Average node length: 6.03, total dup: 10055980, max dup: 65 
    Average key length: 2.80, compression ratio: 3.21 
    Average prefix length: 8.33, average data length: 0.67 
    Clustering factor: 2416891, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 81 
        40 - 59% = 10174 
        60 - 79% = 4576 
        80 - 99% = 178 
 
    Index XQS_1200_2000_WORKER_ID (0) 
    Root page: 1386211, depth: 3, leaf buckets: 10981, nodes: 11516688 
    Average node length: 5.23, total dup: 11516588, max dup: 185019 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.41, average data length: 0.00 
    Clustering factor: 708482, ratio: 0.06 
    Fill distribution: 
         0 - 19% = 91 
        20 - 39% = 820 
        40 - 59% = 5012 
        60 - 79% = 1443 
        80 - 99% = 3615 
 
XQS_2000_3300 (185) 
    Primary pointer page: 567, Index root page: 568 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index XQS_2000_3300_DOC_ID (1) 
    Root page: 1361753, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index XQS_2000_3300_RCV_ID (3) 
    Root page: 1361755, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index XQS_2000_3300_SND_ID (2) 
    Root page: 1361754, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index XQS_2000_3300_WORKER_ID (0) 
    Root page: 1361752, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
XQS_2100_3300 (186) 
    Primary pointer page: 569, Index root page: 570 
    Total formats: 1, used formats: 1 
    Average record length: 78.39, total records: 9981880 
    Average version length: 82.94, total versions: 525420, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.61 
    Pointer pages: 107, data page slots: 173624 
    Data pages: 173544, average fill: 71% 
    Primary pages: 173544, secondary pages: 0, swept pages: 66786 
    Empty pages: 444, full pages: 109145 
    Fill distribution: 
     0 - 19% = 1517 
    20 - 39% = 7072 
    40 - 59% = 24643 
    60 - 79% = 68750 
    80 - 99% = 71562 
 
    Index XQS_2100_3300_DOC_ID (1) 
    Root page: 1344686, depth: 3, leaf buckets: 11988, nodes: 9981880 
    Average node length: 5.18, total dup: 9952847, max dup: 1510 
    Average key length: 2.03, compression ratio: 4.43 
    Average prefix length: 8.97, average data length: 0.03 
    Clustering factor: 1956840, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 32 
        20 - 39% = 1498 
        40 - 59% = 7823 
        60 - 79% = 2011 
        80 - 99% = 624 
 
    Index XQS_2100_3300_RCV_ID (3) 
    Root page: 1355717, depth: 3, leaf buckets: 13837, nodes: 9981880 
    Average node length: 6.25, total dup: 8275831, max dup: 14 
    Average key length: 3.10, compression ratio: 2.90 
    Average prefix length: 8.07, average data length: 0.93 
    Clustering factor: 1446471, ratio: 0.14 
    Fill distribution: 
         0 - 19% = 176 
        20 - 39% = 3785 
        40 - 59% = 4669 
        60 - 79% = 2656 
        80 - 99% = 2551 
 
    Index XQS_2100_3300_SND_ID (2) 
    Root page: 1350049, depth: 3, leaf buckets: 12628, nodes: 9981880 
    Average node length: 5.43, total dup: 9538045, max dup: 106 
    Average key length: 2.29, compression ratio: 3.94 
    Average prefix length: 8.76, average data length: 0.24 
    Clustering factor: 2093654, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 26 
        20 - 39% = 1466 
        40 - 59% = 8807 
        60 - 79% = 1718 
        80 - 99% = 611 
 
    Index XQS_2100_3300_WORKER_ID (0) 
    Root page: 985805, depth: 3, leaf buckets: 10442, nodes: 9981880 
    Average node length: 5.15, total dup: 9981780, max dup: 147402 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.42, average data length: 0.00 
    Clustering factor: 1532523, ratio: 0.15 
    Fill distribution: 
         0 - 19% = 46 
        20 - 39% = 1209 
        40 - 59% = 5287 
        60 - 79% = 1744 
        80 - 99% = 2156 
 
XQS_3300_3400 (187) 
    Primary pointer page: 571, Index root page: 572 
    Total formats: 1, used formats: 1 
    Average record length: 67.08, total records: 574318 
    Average version length: 68.80, total versions: 9168, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.88 
    Pointer pages: 5, data page slots: 7976 
    Data pages: 7976, average fill: 75% 
    Primary pages: 7976, secondary pages: 0, swept pages: 3630 
    Empty pages: 7, full pages: 6803 
    Fill distribution: 
     0 - 19% = 10 
    20 - 39% = 24 
    40 - 59% = 212 
    60 - 79% = 7568 
    80 - 99% = 162 
 
    Index XQS_3300_3400_DOC_ID (1) 
    Root page: 45316, depth: 3, leaf buckets: 744, nodes: 574318 
    Average node length: 5.95, total dup: 488936, max dup: 83 
    Average key length: 3.09, compression ratio: 2.91 
    Average prefix length: 8.06, average data length: 0.94 
    Clustering factor: 100090, ratio: 0.17 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 35 
        40 - 59% = 531 
        60 - 79% = 96 
        80 - 99% = 82 
 
    Index XQS_3300_3400_SND_ID (2) 
    Root page: 30995, depth: 3, leaf buckets: 763, nodes: 574318 
    Average node length: 6.15, total dup: 470943, max dup: 25 
    Average key length: 3.29, compression ratio: 2.73 
    Average prefix length: 7.89, average data length: 1.11 
    Clustering factor: 100162, ratio: 0.17 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 33 
        40 - 59% = 543 
        60 - 79% = 92 
        80 - 99% = 95 
 
    Index XQS_3300_3400_WORKER_ID (0) 
    Root page: 375548, depth: 2, leaf buckets: 575, nodes: 574318 
    Average node length: 4.86, total dup: 574218, max dup: 9729 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.42, average data length: 0.00 
    Clustering factor: 88929, ratio: 0.15 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 24 
        40 - 59% = 335 
        60 - 79% = 113 
        80 - 99% = 103 
 
ZDOC_DATA (170) 
    Primary pointer page: 537, Index root page: 538 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
ZDOC_LIST (169) 
    Primary pointer page: 535, Index root page: 536 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
ZINVNT_TURNOVER_LOG (171) 
    Primary pointer page: 539, Index root page: 540 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
ZPDISTR (174) 
    Primary pointer page: 545, Index root page: 546 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index ZPDISTR_ID (0) 
    Root page: 1504207, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
ZPSTORNED (175) 
    Primary pointer page: 547, Index root page: 548 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index ZPSTORNED_ID (0) 
    Root page: 1504206, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
ZQDISTR (172) 
    Primary pointer page: 541, Index root page: 542 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index ZQDISTR_ID (0) 
    Root page: 1504212, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index ZQDISTR_WARE_SNDOP_RCVOP (1) 
    Root page: 1504213, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
ZQSTORNED (173) 
    Primary pointer page: 543, Index root page: 544 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index ZQSTORNED_DOC_ID (1) 
    Root page: 1504209, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index ZQSTORNED_ID (0) 
    Root page: 1504208, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index ZQSTORNED_RCV_ID (3) 
    Root page: 1504211, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index ZQSTORNED_SND_ID (2) 
    Root page: 1504210, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
ZTMP_DEP_DOCS (168) 
    Primary pointer page: 533, Index root page: 534 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
ZTMP_SHOPPING_CART (167) 
    Primary pointer page: 531, Index root page: 532 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
Z_USED_VIEWS (144) 
    Primary pointer page: 484, Index root page: 485 
    Total formats: 1, used formats: 1 
    Average record length: 29.38, total records: 29 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 99.00, compression ratio: 3.37 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 16% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index Z_USED_VIEWS_UNQ (0) 
    Root page: 1510350, depth: 1, leaf buckets: 1, nodes: 29 
    Average node length: 15.17, total dup: 0, max dup: 0 
    Average key length: 14.14, compression ratio: 1.44 
    Average prefix length: 9.17, average data length: 11.17 
    Clustering factor: 1, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
Gstat completion time Tue Feb 27 19:11:34 2024

Record versions statistics, table

TABLE_NAME TOTAL_RECS TOTAL_VERS MAX_VERSIONS VERS_TO_RECS_PRC MAXV_TO_VERS_PRC
DOC_DATA 7801575 102898 1 0.0000 0.0000
DOC_LIST 2272437 103892 3 0.0000 0.0000
FB_ERRORS 2182 757 1 0.0000 0.0000
INVNT_SALDO 400 230414 601 57600.0000 0.0000
INVNT_TURNOVER_LOG 106950 88646 1 0.0000 0.0000
MONEY_SALDO 49 18204 961 37100.0000 0.0000
MONEY_TURNOVER_LOG 2155 1303 1 0.0000 0.0000
PDISTR 820616 77895 5 0.0000 0.0000
PERF_SPLIT_0 165486 4357 1 0.0000 0.0000
PERF_SPLIT_1 198227 37399 1 0.0000 0.0000
PERF_SPLIT_2 152423 2650 1 0.0000 0.0000
PERF_SPLIT_3 169552 12466 1 0.0000 0.0000
PERF_SPLIT_4 142917 6695 1 0.0000 0.0000
PERF_SPLIT_5 163186 15732 1 0.0000 0.0000
PERF_SPLIT_6 173210 6365 1 0.0000 0.0000
PERF_SPLIT_7 167617 8629 1 0.0000 0.0000
PERF_SPLIT_8 163662 4429 1 0.0000 0.0000
PERF_SPLIT_9 158284 4961 1 0.0000 0.0000
PSTORNED 2104071 48542 1 0.0000 0.0000
SEMAPHORES 5 1 1 0.0000 100.0000
XQD_1000_1200 155028 72338 1 0.0000 0.0000
XQD_1000_3300 7075153 501224 1 0.0000 0.0000
XQD_1200_2000 12023954 427561 1 0.0000 0.0000
XQD_2000_3300 1853000 771677 1 0.0000 0.0000
XQD_2100_3300 1087522 505357 1 0.0000 0.0000
XQD_3300_3400 9405562 514252 1 0.0000 0.0000
XQS_1000_1200 21151879 16581 1 0.0000 0.0000
XQS_1000_3300 9874885 533297 1 0.0000 0.0000
XQS_1200_2000 11516688 396740 1 0.0000 0.0000
XQS_2100_3300 9981880 525420 1 0.0000 0.0000
XQS_3300_3400 574318 9168 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 ---
:1241: 
:1242: mscs-test-161.budzdorov.ru    Tue Feb 27 19:09:52 2024
:1243:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:1244: 
--- end of diff output ---

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

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