Generated by /opt/oltp-emul/oltp_isql_run_worker.sh, ISQL session No. 1 of total launched 100. 28.02.2024 16:11
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 15704216 kB
MemAvailable 30306336 kB
Buffers 0 kB
Cached 16048600 kB
SwapCached 2280 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-28 16:09:45
DTS_END                         2024-02-28 16:09:45.1670
FB_GDSCODE                      -1
FB_MNEMONA                      
STACK                           SRV_RECALC_IDX_STAT(108:9) ==> SP_CHECK_TO_STOP_WORK(32:12) ==> SP_HALT_ON_ERROR(57:17)
IP                              ::1/47528
TRN_ID                          171380
ATT_ID                          530
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: 9157.02 20875 915702
customer order: creation 170.83 371 17083
customer order: refuse 14.44 368 1444
order to supplier: creation 46.43 1309 4643
order to supplier: removal 3.71 112843 371
invoice (draft): creation 46.04 3569 4604
invoice (draft): removal 53.02 911 5302
invoice accept: apply 40.57 20964 4057
invoice accept: cancel 47.57 1011 4757
customer reserve: creation 3860.94 201 386094
customer reserve: removal 4577.84 72 457784
realization accept: apply 83.55 197 8355
realization accept: cancel 86.62 128 8662
payment from customer: creation 57.88 132 5788
payment from customer: removal 5.74 72 574
payment to supplier: creation 47.05 143 4705
payment to supplier: removal 3.34 69 334
service: total inventory turnovers 4.83 1008 483
service: total monetary turnovers 5.92 32 592
service: aggregate perf. data 0.67 26795 67
service: refresh index statistics 0.03 247307 3

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:03, from 28-02-2024 16:11:40 to 28-02-2024 16:11:43.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 3998
TEST_TIME 2 5344
TEST_TIME 3 4080
TEST_TIME 4 5410
TEST_TIME 5 5961
TEST_TIME 6 6553
TEST_TIME 7 6632
TEST_TIME 8 6451
TEST_TIME 9 6280
TEST_TIME 10 6479
TEST_TIME 11 6283
TEST_TIME 12 6479
TEST_TIME 13 6253
TEST_TIME 14 6161
TEST_TIME 15 6307
TEST_TIME 16 6320
TEST_TIME 17 6536
TEST_TIME 18 6485
TEST_TIME 19 6632
TEST_TIME 20 6597
TEST_TIME 21 6539
TEST_TIME 22 6787
TEST_TIME 23 6764
TEST_TIME 24 6809
TEST_TIME 25 7029
TEST_TIME 26 7009
TEST_TIME 27 7204
TEST_TIME 28 7350
TEST_TIME 29 7464
TEST_TIME 30 7608
TEST_TIME 31 7621
TEST_TIME 32 7673
TEST_TIME 33 8357
TEST_TIME 34 9423
TEST_TIME 35 9683
TEST_TIME 36 9669
TEST_TIME 37 9468
TEST_TIME 38 9316
TEST_TIME 39 9364
TEST_TIME 40 9313
TEST_TIME 41 9353
TEST_TIME 42 9212
TEST_TIME 43 9181
TEST_TIME 44 9190
TEST_TIME 45 9104
TEST_TIME 46 9188
TEST_TIME 47 9315
TEST_TIME 48 9372
TEST_TIME 49 9347
TEST_TIME 50 9346
TEST_TIME 51 9300
TEST_TIME 52 9193
TEST_TIME 53 9079
TEST_TIME 54 9204
TEST_TIME 55 9108
TEST_TIME 56 9121
TEST_TIME 57 9055
TEST_TIME 58 8957
TEST_TIME 59 8967
TEST_TIME 60 8950
TEST_TIME 61 8963
TEST_TIME 62 8995
TEST_TIME 63 9041
TEST_TIME 64 9037
TEST_TIME 65 9166
TEST_TIME 66 9184
TEST_TIME 67 9230
TEST_TIME 68 9262
TEST_TIME 69 9275
TEST_TIME 70 9267
TEST_TIME 71 9322
TEST_TIME 72 9377
TEST_TIME 73 9291
TEST_TIME 74 9226
TEST_TIME 75 9167
TEST_TIME 76 9171
TEST_TIME 77 9160
TEST_TIME 78 9088
TEST_TIME 79 9027
TEST_TIME 80 9053
TEST_TIME 81 9047
TEST_TIME 82 9060
TEST_TIME 83 9039
TEST_TIME 84 9138
TEST_TIME 85 9178
TEST_TIME 86 9193
TEST_TIME 87 9171
TEST_TIME 88 9190
TEST_TIME 89 9356
TEST_TIME 90 9331
TEST_TIME 91 9396
TEST_TIME 92 9363
TEST_TIME 93 9344
TEST_TIME 94 9263
TEST_TIME 95 9310
TEST_TIME 96 9271
TEST_TIME 97 9271
TEST_TIME 98 9231
TEST_TIME 99 9203
TEST_TIME 100 9162

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:03, from 28-02-2024 16:11:44 to 28-02-2024 16:11:47.

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 1269800 1269800 0 0.00 0 19805 7 0 0
doc_list_biud 1269797 1269797 0 0.00 0 37115 33 0 0
sp_add_invoice_to_stock 4179 4057 122 2.91 26 170166 20965 0 122
sp_cancel_adding_invoice 4757 4757 0 0.00 4 102279 1012 0 0
sp_cancel_client_order 1444 1444 0 0.00 4 10126 369 0 0
sp_cancel_customer_reserve 457784 457784 0 0.00 0 24479 72 0 0
sp_cancel_pay_from_customer 574 574 0 0.00 3 2148 73 0 0
sp_cancel_pay_to_supplier 334 334 0 0.00 3 3141 69 0 0
sp_cancel_supplier_invoice 5312 5302 10 0.18 1 37161 911 0 10
sp_cancel_supplier_order 371 371 0 0.00 6 969527 112843 0 0
sp_cancel_write_off 8662 8662 0 0.00 1 16743 128 0 0
sp_client_order 17083 17083 0 0.00 3 26651 371 0 0
sp_customer_reserve 386094 386094 0 0.00 0 53617 202 0 0
sp_fill_shopping_cart 26322 26322 0 0.00 1 15609 36 0 0
sp_fill_shopping_cart_clo_res 386084 386084 0 0.00 0 15581 15 0 0
sp_get_clo_for_invoice 4047 4047 0 0.00 0 22083 328 0 0
sp_kill_cost_storno 14327 14327 0 0.00 0 8852 71 0 0
sp_kill_qstorno_ret_qs2qd 929903 929903 0 0.00 0 37101 39 0 0
sp_kill_qty_storno 490719 490719 0 0.00 0 37109 84 0 0
sp_lock_selected_doc 17160 17160 0 0.00 0 9341 5 0 0
sp_make_cost_storno 22892 22892 0 0.00 0 18110 77 0 0
sp_multiply_rows_for_pdistr 22892 22892 0 0.00 0 7654 30 0 0
sp_multiply_rows_for_qdistr 17083 17083 0 0.00 0 26640 179 0 0
sp_pay_from_customer 5788 5788 0 0.00 4 15966 133 0 0
sp_pay_to_supplier 4705 4705 0 0.00 5 17351 144 0 0
sp_payment_common 10492 10492 0 0.00 1 10943 31 0 0
sp_qd_handle_on_cancel_clo 1444 1444 0 0.00 0 10120 339 0 0
sp_qd_handle_on_invoice_upd_sts 8801 8801 0 0.00 0 24672 373 0 0
sp_qd_handle_on_reserve_upd_sts 8355 8355 0 0.00 0 13118 58 0 0
sp_reserve_write_off 8355 8355 0 0.00 6 17194 198 0 0
sp_supplier_invoice 4604 4604 0 0.00 6 108471 3569 0 0
sp_supplier_order 4643 4643 0 0.00 6 26474 1310 0 0
srv_aggregate_perf_data 67 67 0 0.00 2398 426452 26795 0 0
srv_fill_mon_cache_memory 57 57 0 0.00 2042 141389 37431 0 0
srv_find_qd_qs_mism 874565 874565 0 0.00 0 19191 6 0 0
srv_make_invnt_saldo 483 483 0 0.00 41 30948 1009 0 0
srv_make_money_saldo 592 592 0 0.00 1 1839 32 0 0
srv_recalc_idx_stat 3 3 0 0.00 180948 301460 247307 0 0
t$perf-abend:sp_add_invoice_to_stock 122 122 0 0.00 0 0 0 0 0
t$perf-abend:sp_cancel_supplier_invoice 10 10 0 0.00 0 0 0 0 0
t$perf-norm:sp_add_invoice_to_stock 4057 4057 0 0.00 0 13668 214 0 0
t$perf-norm:sp_cancel_adding_invoice 335 335 0 0.00 0 3952 159 0 0
t$perf-norm:sp_cancel_client_order 1444 1444 0 0.00 0 9572 19 0 0
t$perf-norm:sp_cancel_customer_reserve 595 595 0 0.00 0 694 10 0 0
t$perf-norm:sp_cancel_pay_from_customer 574 574 0 0.00 0 3522 19 0 0
t$perf-norm:sp_cancel_pay_to_supplier 334 334 0 0.00 0 1486 9 0 0
t$perf-norm:sp_cancel_supplier_invoice 332 332 0 0.00 0 2842 37 0 0
t$perf-norm:sp_cancel_supplier_order 371 371 0 0.00 0 55285 2069 0 0
t$perf-norm:sp_cancel_write_off 777 777 0 0.00 0 5356 14 0 0
t$perf-norm:sp_client_order 17083 17083 0 0.00 0 10716 23 0 0
t$perf-norm:sp_customer_reserve 863 863 0 0.00 0 1653 7 0 0
t$perf-norm:sp_pay_from_customer 5788 5788 0 0.00 0 6474 11 0 0
t$perf-norm:sp_pay_to_supplier 4705 4705 0 0.00 0 10715 13 0 0
t$perf-norm:sp_reserve_write_off 8355 8355 0 0.00 0 6374 14 0 0
t$perf-norm:sp_supplier_invoice 4604 4604 0 0.00 0 8196 20 0 0
t$perf-norm:sp_supplier_order 4643 4643 0 0.00 0 5103 21 0 0
t$perf-norm:srv_aggregate_perf_data 67 67 0 0.00 0 500 18 0 0
t$perf-norm:srv_fill_mon_cache_memory 57 57 0 0.00 0 387 11 0 0
t$perf-norm:srv_make_invnt_saldo 483 483 0 0.00 0 3902 35 0 0
t$perf-norm:srv_make_money_saldo 592 592 0 0.00 0 3662 24 0 0
t$perf-norm:srv_recalc_idx_stat 3 3 0 0.00 1 7 4 0 0
v_add_invoice_to_stock 8328 8084 244 2.92 0 5202 18 0 244
v_all_customers 31576 31576 0 0.00 0 19 1 0 0
v_all_suppliers 25666 25666 0 0.00 0 20 1 0 0
v_all_wares 34166 34166 0 0.00 0 21 1 0 0
v_cancel_adding_invoice 670 670 0 0.00 0 632 7 0 0
v_cancel_client_order 2888 2888 0 0.00 0 3400 4 0 0
v_cancel_customer_prepayment 1148 1148 0 0.00 0 1809 8 0 0
v_cancel_customer_reserve 1190 1190 0 0.00 0 1997 5 0 0
v_cancel_payment_to_supplier 668 668 0 0.00 0 346 4 0 0
v_cancel_supplier_invoice 684 664 20 2.92 0 1791 20 0 20
v_cancel_supplier_order 742 742 0 0.00 0 3401 11 0 0
v_cancel_write_off 1554 1554 0 0.00 0 3679 23 0 0
v_max_id_clo_ord 4641 4641 0 0.00 0 311 1 0 0
v_max_id_clo_res 863 863 0 0.00 0 1771 9 0 0
v_max_id_ord_sup 4598 4598 0 0.00 0 2535 5 0 0
v_max_non_paid_invoice 1111 1111 0 0.00 0 107 2 0 0
v_max_non_paid_realizn 2820 2820 0 0.00 0 7422 10 0 0
v_min_id_clo_ord 4641 4641 0 0.00 0 10300 13 0 0
v_min_id_clo_res 863 863 0 0.00 0 6731 18 0 0
v_min_id_ord_sup 4598 4598 0 0.00 0 4683 8 0 0
v_min_non_paid_invoice 4705 4705 0 0.00 0 4752 16 0 0
v_min_non_paid_realizn 5787 5787 0 0.00 0 9062 26 0 0
v_our_firm 8524 8524 0 0.00 0 23 1 0 0
v_reserve_write_off 16710 16710 0 0.00 0 4945 6 0 0
x_lock_depdocs_on_canc_invoice 9727 9727 0 0.00 0 37779 137 0 0
x_lock_depdocs_on_canc_sup_ord 371 371 0 0.00 0 22738 379 0 0
x_make_qstorno_1000_1200 4643 4643 0 0.00 1 26468 1220 0 0
x_make_qstorno_1200_2000 4604 4604 0 0.00 3 108356 3447 0 0
x_make_qstorno_2100_3300 386092 386092 0 0.00 0 45624 183 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 28-02-2024 16:11:48 to 28-02-2024 16:11:52.

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
14:09:49 3 8192000000 8800250512 8811937792 6616304 0.080 2 2 2 0 6717760 58672 42784
14:10:49 19599 8192000000 9886680672 10195357696 972368720 10.610 100 88 176 0 1001344528 5802176 23173632
14:12:20 22312 8192000000 9946231808 10269577216 1024462688 11.115 100 82 164 0 1053416096 7808160 21145248
14:13:48 9552 8192000000 9988066784 10320171008 1068579024 11.539 100 87 174 1 1099598752 9096992 21922736
14:15:03 11862 8192000000 10029674912 10374533120 1116217696 11.991 100 87 174 0 1147532496 10209472 21105328
14:16:18 7259 8192000000 10078021072 10432790528 1161954464 12.422 100 84 168 0 1193328448 11985472 19388512
14:17:28 7227 8192000000 10110966336 10478645248 1201668128 12.792 100 83 166 0 1233277504 12687104 18922272
14:18:37 2213 8192000000 10140956976 10512310272 1235630448 13.106 100 87 171 0 1267612624 13082992 18899184
14:19:43 1754 8192000000 10170186480 10551603200 1270531920 13.426 100 79 156 1 1299570896 12036784 17002192
14:20:46 1661 8192000000 10200348544 10583064576 1287614288 13.582 100 80 157 0 1319220496 13137568 18468640
14:21:48 26595 8192000000 10197725056 10601119744 1301566368 13.709 100 66 133 3 1326525088 9250288 15708432
14:23:16 7408 8192000000 10197656128 10610343936 1310189680 13.788 100 28 56 1 1324215568 7614304 6411584
14:24:26 12456 8192000000 10198308928 10617581568 1315716800 13.838 100 10 20 0 1327592592 9805616 2070176
14:25:39 13349 8192000000 10214312704 10628796416 1324596096 13.918 100 35 71 0 1343471376 10825888 8049392
14:26:52 12979 8192000000 10235298880 10647183360 1329328992 13.961 100 46 91 2 1349517488 9897808 10290688
14:28:06 4945 8192000000 10221464672 10647498752 1334397024 14.007 100 30 60 0 1348475792 7327344 6751424
14:29:16 6142 8192000000 10220257552 10638655488 1326907760 13.939 100 31 62 1 1341159184 7347968 6903456
14:30:28 9912 8192000000 10235792160 10642067456 1328394128 13.953 100 54 108 0 1349111632 8861312 11856192
14:31:46 56661 8192000000 10240366160 10653515776 1323642880 13.910 99 48 96 0 1344472336 9512816 11316640
14:33:47 2041 8192000000 10233182880 10636468224 1317770112 13.857 100 65 128 1 1342691488 10377120 14544256
14:34:53 10410 8192000000 10224230800 10626822144 1310549856 13.791 100 58 116 2 1334190880 10919280 12721744
14:36:06 21139 8192000000 10198164416 10599440384 1279485104 13.508 98 47 94 1 1305063136 15399440 10178592
14:37:31 20535 8192000000 10229043408 10632347648 1319228048 13.870 100 49 96 0 1341518512 11272272 11018192
14:38:57 11067 8192000000 10229822944 10631393280 1305476384 13.745 99 56 112 0 1333700064 15681136 12542544
14:40:15 55440 8192000000 10207376080 10618867712 1271451776 13.435 96 37 73 1 1295887248 15790784 8644688
14:42:32 10939 8192000000 10246222448 10648621056 1320346800 13.880 99 59 117 1 1347545952 14235072 12964080
14:43:56 7986 8192000000 10243462768 10645401600 1315388448 13.835 100 50 100 1 1348652432 21901392 11362592
14:45:12 5547 8192000000 10274174928 10679627776 1341035616 14.067 100 43 84 0 1375296144 24262560 9997968
14:46:26 4306 8192000000 10275629936 10674679808 1333281536 13.997 99 67 131 1 1373173632 23714288 16177808
14:47:35 15622 8192000000 10280147456 10693361664 1351194800 14.158 100 40 80 0 1388334320 27068736 10070784
14:49:04 17339 8192000000 10296459408 10699317248 1359484848 14.233 99 55 110 1 1398970400 25718816 13766736
14:50:32 3523 8192000000 10329510816 10740293632 1387493776 14.483 100 57 114 0 1433307360 31296800 14516784
14:51:40 5735 8192000000 10337588064 10755858432 1404064512 14.631 100 64 125 0 1454416512 34206960 16145040
14:52:53 2991 8192000000 10350443552 10764091392 1403788096 14.629 100 64 127 0 1456579440 36701344 16090000
14:54:03 2142 8192000000 10373056704 10789064704 1420648688 14.778 100 72 142 2 1476839296 38487120 17703488
14:55:10 3632 8192000000 10357511984 10781229056 1418694928 14.761 100 52 104 0 1465091136 32947744 13448464
14:56:21 2071 8192000000 10393628576 10807554048 1428225136 14.846 100 80 156 0 1494091744 46119200 19747408
14:57:31 6529 8192000000 10386207552 10813448192 1431413296 14.874 100 48 96 0 1491679280 47008752 13257232
14:58:57 5858 8192000000 10374381120 10797826048 1416267376 14.740 99 42 83 0 1473439040 45794336 11377328
15:00:06 19772 8192000000 10372083584 10806693888 1418426704 14.759 100 31 63 1 1479125152 51675472 9022976
15:01:28 12953 8192000000 10357904816 10793373696 1393768784 14.539 100 30 60 2 1464384448 61628368 8987296
15:02:49 6533 8192000000 10365771040 10816532480 1396788304 14.566 100 30 60 0 1472238240 66918912 8531024
15:04:13 100784 8192000000 10300299312 10765811712 1379745392 14.414 99 11 22 1 1399985616 17656096 2584128
15:06:57 128634 8192000000 10312530704 10771865600 1407620848 14.663 100 41 83 1 1434399136 16993296 9784992
15:10:09 39862 8192000000 10294923616 10756308992 1399109120 14.587 100 39 78 0 1419462384 11581056 8772208
15:11:51 17941 8192000000 10310081296 10762309632 1401025712 14.604 100 22 44 0 1415787168 10101120 4660336
15:13:11 61876 8192000000 10335243568 10786750464 1413544944 14.715 100 24 48 0 1434775856 15192112 6038800
15:15:19 30806 8192000000 10319074272 10774753280 1401952048 14.612 100 26 52 0 1430912656 22519168 6441440
15:17:02 51067 8192000000 10282047504 10752229376 1355730704 14.199 97 14 28 0 1385646592 26684544 3231344
15:18:55 20490 8192000000 10283539904 10746028032 1380424128 14.420 100 13 26 2 1396508560 13192256 2892176
15:20:16 89510 8192000000 10287264240 10749132800 1357921376 14.219 98 20 40 0 1373550912 10998144 4631392
15:23:04 66632 8192000000 10276620464 10755952640 1356769552 14.208 98 17 35 0 1384261760 23166752 4325456
15:25:45 49516 8192000000 10280918416 10738130944 1376807664 14.388 99 13 26 0 1388292240 7935808 3548768
15:27:44 57416 8192000000 10243600048 10703822848 1344168032 14.095 98 12 24 0 1353781488 6997744 2615712
15:29:45 51047 8192000000 10250769856 10705944576 1334757216 14.010 98 13 26 0 1346775232 9378272 2639744
15:31:47 45416 8192000000 10240028880 10683539456 1287166320 13.578 95 33 66 1 1305338880 10859520 7313040
15:33:36 37823 8192000000 10222449264 10683510784 1276906608 13.485 95 18 36 0 1301095408 19935600 4253200
15:35:44 36457 8192000000 10237392848 10668085248 1290323648 13.607 97 36 70 0 1307915344 9910224 7681472
15:37:22 31015 8192000000 10243717136 10687709184 1333833712 14.002 100 17 33 0 1349487408 12199328 3454368
15:38:53 60581 8192000000 10260507936 10700242944 1329802400 13.965 99 34 68 0 1348463840 11199216 7462224
15:40:54 47326 8192000000 10261173056 10704584704 1331185056 13.978 98 23 44 0 1345434704 9943472 4306176
15:42:42 77207 8192000000 10263162528 10712961024 1365211328 14.284 100 14 28 0 1375506704 7347552 2947824
15:45:00 36691 8192000000 10262236624 10708901888 1357439424 14.214 99 51 100 0 1379757216 10955600 11362192
15:46:52 29966 8192000000 10258507920 10711252992 1344623696 14.099 98 6 12 0 1353515824 7589344 1302784
15:48:22 34357 8192000000 10269316128 10726572032 1382576112 14.440 100 12 22 0 1393661968 8542704 2543152
15:50:02 50611 8192000000 10288878288 10745925632 1362889488 14.263 98 17 34 0 1382353472 15434896 4029088
15:51:53 82158 8192000000 10282819072 10745110528 1358277664 14.222 98 17 34 0 1381406272 18894304 4234304
15:54:19 55019 8192000000 10303078752 10757775360 1392787920 14.531 100 16 32 0 1406247296 9664928 3794448
15:56:29 55300 8192000000 10323206480 10776297472 1393238192 14.535 98 23 46 1 1414957984 16427952 5291840
15:58:28 141379 8192000000 10304725344 10765819904 1330171664 13.969 94 5 10 0 1345786720 14726288 888768
16:01:50 13092 8192000000 10331919968 10766651392 1396573072 14.564 99 44 89 1 1418073024 11632288 9867664
16:03:08 116861 8192000000 10307140496 10775830528 1395579120 14.556 99 31 61 0 1419245584 16715760 6950704
16:06:15 32423 8192000000 10297392704 10764255232 1400734160 14.602 99 11 21 0 1416001168 12623296 2643712
16:07:51 63496 8192000000 10277764896 10737242112 1310605680 13.792 93 13 27 0 1325936144 12137344 3193120

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:14, from 28-02-2024 16:11:54 to 28-02-2024 16:12:08.

Exceptions occured during test was in run

FB_MNEMONA CNT UNIT FB_GDSCODE
except 122 v_add_invoice_to_stock 335544517
except 10 v_cancel_supplier_invoice 335544517

Completed "Exceptions occured during test was in run". Done for 00:00:02, from 28-02-2024 16:12:09 to 28-02-2024 16:12:11.

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          170917
MON$OLDEST_ACTIVE               171999
MON$OLDEST_SNAPSHOT             171999
MON$NEXT_TRANSACTION            171999
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                       1920544
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 Wed Feb 28 16:12:12 2024 
 
Database header page information: 
    Flags            0 
    Generation        89662 
    System Change Number    0 
    Page size        8192 
    ODS version        12.0 
    Oldest transaction    170917 
    Oldest active        171999 
    Oldest snapshot        171999 
    Next transaction    172000 
    Sequence number        0 
    Next attachment ID    698 
    Implementation        HW=AMD/Intel/x64 little-endian OS=Linux CC=gcc 
    Shadow count        0 
    Page buffers        0 
    Next header page    0 
    Database dialect    3 
    Creation date        Apr 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.55, total records: 7666082 
    Average version length: 48.16, total versions: 53830, 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: 87208 
    Data pages: 87208, average fill: 70% 
    Primary pages: 87208, secondary pages: 0, swept pages: 35084 
    Empty pages: 4, full pages: 51694 
    Fill distribution: 
     0 - 19% = 47 
    20 - 39% = 544 
    40 - 59% = 4980 
    60 - 79% = 81625 
    80 - 99% = 12 
 
    Index DOC_DATA_DOC_WARE_UNQ (0) 
    Root page: 1510614, depth: 3, leaf buckets: 23146, nodes: 7666082 
    Average node length: 18.85, total dup: 0, max dup: 0 
    Average key length: 15.86, compression ratio: 1.70 
    Average prefix length: 14.13, average data length: 12.87 
    Clustering factor: 1663696, ratio: 0.22 
    Fill distribution: 
         0 - 19% = 323 
        20 - 39% = 2222 
        40 - 59% = 3807 
        60 - 79% = 2420 
        80 - 99% = 14374 
 
    Index DOC_DATA_ID_DESC (1) 
    Root page: 1528118, depth: 3, leaf buckets: 13424, nodes: 7666082 
    Average node length: 11.20, total dup: 0, max dup: 0 
    Average key length: 8.21, compression ratio: 1.10 
    Average prefix length: 3.78, average data length: 5.22 
    Clustering factor: 1487510, ratio: 0.19 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 1743 
        40 - 59% = 1869 
        60 - 79% = 1129 
        80 - 99% = 8683 
 
    Index FK_DOC_DATA_DOC_LIST (2) 
    Root page: 1546711, depth: 3, leaf buckets: 8282, nodes: 7666082 
    Average node length: 6.60, total dup: 5758832, max dup: 49 
    Average key length: 3.61, compression ratio: 2.49 
    Average prefix length: 7.64, average data length: 1.36 
    Clustering factor: 1480519, ratio: 0.19 
    Fill distribution: 
         0 - 19% = 140 
        20 - 39% = 1102 
        40 - 59% = 1223 
        60 - 79% = 967 
        80 - 99% = 4850 
 
DOC_LIST (138) 
    Primary pointer page: 472, Index root page: 473 
    Total formats: 1, used formats: 1 
    Average record length: 56.69, total records: 2197006 
    Average version length: 34.69, total versions: 55087, max versions: 3 
    Average fragment length: 5.33, total fragments: 3, max fragments: 1 
    Average unpacked length: 84.00, compression ratio: 1.48 
    Pointer pages: 18, data page slots: 28696 
    Data pages: 28696, average fill: 71% 
    Primary pages: 28686, secondary pages: 10, swept pages: 15473 
    Empty pages: 3, full pages: 16178 
    Fill distribution: 
     0 - 19% = 27 
    20 - 39% = 298 
    40 - 59% = 3268 
    60 - 79% = 24801 
    80 - 99% = 302 
 
    Index DOC_LIST_ID_DESC (1) 
    Root page: 1541130, depth: 3, leaf buckets: 4506, nodes: 2197006 
    Average node length: 11.41, total dup: 0, max dup: 0 
    Average key length: 8.45, compression ratio: 1.06 
    Average prefix length: 3.54, average data length: 5.46 
    Clustering factor: 668743, ratio: 0.30 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 998 
        40 - 59% = 778 
        60 - 79% = 745 
        80 - 99% = 1985 
 
    Index DOC_LIST_WORKER_OPTYPE (2) 
    Root page: 1544376, depth: 3, leaf buckets: 2497, nodes: 2198816 
    Average node length: 4.97, total dup: 2197917, max dup: 19955 
    Average key length: 2.01, compression ratio: 4.47 
    Average prefix length: 8.99, average data length: 0.01 
    Clustering factor: 1221025, ratio: 0.56 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 294 
        40 - 59% = 1559 
        60 - 79% = 473 
        80 - 99% = 170 
 
    Index FK_DOC_LIST_AGENTS (3) 
    Root page: 1545909, depth: 3, leaf buckets: 2061, nodes: 2197006 
    Average node length: 4.97, total dup: 2196956, max dup: 130274 
    Average key length: 2.01, compression ratio: 4.48 
    Average prefix length: 8.99, average data length: 0.01 
    Clustering factor: 1052301, ratio: 0.48 
    Fill distribution: 
         0 - 19% = 6 
        20 - 39% = 233 
        40 - 59% = 949 
        60 - 79% = 102 
        80 - 99% = 771 
 
    Index PK_DOC_LIST (0) 
    Root page: 1538187, depth: 3, leaf buckets: 4301, nodes: 2197006 
    Average node length: 11.41, total dup: 0, max dup: 0 
    Average key length: 8.45, compression ratio: 1.06 
    Average prefix length: 3.54, average data length: 5.46 
    Clustering factor: 668743, ratio: 0.30 
    Fill distribution: 
         0 - 19% = 112 
        20 - 39% = 636 
        40 - 59% = 556 
        60 - 79% = 875 
        80 - 99% = 2122 
 
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.86, total records: 400 
    Average version length: 23.07, total versions: 234165, max versions: 616 
    Average fragment length: 2.00, total fragments: 23, max fragments: 1 
    Average unpacked length: 104.00, compression ratio: 1.26 
    Pointer pages: 1, data page slots: 1288 
    Data pages: 1288, average fill: 91% 
    Primary pages: 14, secondary pages: 1274, swept pages: 0 
    Empty pages: 7, full pages: 1280 
    Fill distribution: 
     0 - 19% = 7 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 1281 
 
    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: 10.65, total records: 94144 
    Average version length: 68.29, total versions: 79467, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 88.00, compression ratio: 8.26 
    Pointer pages: 7, data page slots: 2832 
    Data pages: 1672, average fill: 70% 
    Primary pages: 1670, secondary pages: 2, swept pages: 5 
    Empty pages: 156, full pages: 1096 
    Fill distribution: 
     0 - 19% = 196 
    20 - 39% = 110 
    40 - 59% = 144 
    60 - 79% = 303 
    80 - 99% = 919 
 
    Index INVNT_TURNOVER_LOG_WARE_DD_ID (0) 
    Root page: 1712523, depth: 3, leaf buckets: 335, nodes: 94144 
    Average node length: 13.28, total dup: 7997, max dup: 2 
    Average key length: 10.56, compression ratio: 2.56 
    Average prefix length: 19.35, average data length: 7.65 
    Clustering factor: 68123, ratio: 0.72 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 102 
        40 - 59% = 181 
        60 - 79% = 51 
        80 - 99% = 0 
 
MONEY_SALDO (141) 
    Primary pointer page: 478, Index root page: 479 
    Total formats: 1, used formats: 1 
    Average record length: 15.29, total records: 49 
    Average version length: 9.00, total versions: 15672, max versions: 893 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 32.00, compression ratio: 2.09 
    Pointer pages: 1, data page slots: 56 
    Data pages: 56, average fill: 90% 
    Primary pages: 1, secondary pages: 55, swept pages: 0 
    Empty pages: 0, full pages: 55 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 7 
    80 - 99% = 49 
 
    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: 5.37, total records: 1522 
    Average version length: 43.56, total versions: 1338, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 58.00, compression ratio: 10.80 
    Pointer pages: 1, data page slots: 32 
    Data pages: 32, average fill: 46% 
    Primary pages: 31, secondary pages: 1, swept pages: 0 
    Empty pages: 7, full pages: 10 
    Fill distribution: 
     0 - 19% = 11 
    20 - 39% = 2 
    40 - 59% = 8 
    60 - 79% = 1 
    80 - 99% = 10 
 
    Index MONEY_TURNOVER_LOG_AGENT_OPTYPE (0) 
    Root page: 90242, depth: 2, leaf buckets: 2, nodes: 1522 
    Average node length: 4.16, total dup: 1424, max dup: 187 
    Average key length: 2.68, compression ratio: 7.08 
    Average prefix length: 18.38, average data length: 0.62 
    Clustering factor: 799, ratio: 0.52 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 1 
        40 - 59% = 1 
        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.05, total records: 74 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 112.00, compression ratio: 1.15 
    Pointer pages: 1, data page slots: 2 
    Data pages: 2, average fill: 52% 
    Primary pages: 2, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 1 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 1 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 1 
 
    Index PK_MON_CACHE_MEMORY (0) 
    Root page: 1504215, depth: 1, leaf buckets: 1, nodes: 74 
    Average node length: 11.69, total dup: 0, max dup: 0 
    Average key length: 10.68, compression ratio: 0.84 
    Average prefix length: 1.31, average data length: 7.69 
    Clustering factor: 2, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
MON_LOG (162) 
    Primary pointer page: 520, Index root page: 521 
    Total formats: 2, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index MON_LOG_DTS (4) 
    Root page: 1504229, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index MON_LOG_GDSCODE (2) 
    Root page: 1504227, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index MON_LOG_ROWSET_DESC (1) 
    Root page: 1504226, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index MON_LOG_UNIT (3) 
    Root page: 1504228, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PK_MON_LOG (0) 
    Root page: 1504225, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
MON_LOG_TABLE_STATS (163) 
    Primary pointer page: 522, Index root page: 523 
    Total formats: 2, used formats: 1 
    Average record length: 67.13, total records: 30 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 611.00, compression ratio: 9.10 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 31% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 1 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index MON_LOG_TABLE_STATS_DTS (4) 
    Root page: 1504224, depth: 1, leaf buckets: 1, nodes: 30 
    Average node length: 3.50, total dup: 23, max dup: 4 
    Average key length: 2.47, compression ratio: 3.24 
    Average prefix length: 7.53, average data length: 0.47 
    Clustering factor: 1, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index MON_LOG_TABLE_STATS_GDSCODE (2) 
    Root page: 1504222, depth: 1, leaf buckets: 1, nodes: 30 
    Average node length: 2.00, total dup: 29, max dup: 29 
    Average key length: 1.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 1, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index MON_LOG_TABLE_STATS_ROWSET (1) 
    Root page: 1504221, depth: 1, leaf buckets: 1, nodes: 30 
    Average node length: 3.33, total dup: 29, max dup: 29 
    Average key length: 2.30, compression ratio: 3.91 
    Average prefix length: 8.70, average data length: 0.30 
    Clustering factor: 1, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index MON_LOG_TABLE_STATS_TN_UNIT (3) 
    Root page: 1504223, depth: 1, leaf buckets: 1, nodes: 30 
    Average node length: 12.90, total dup: 0, max dup: 0 
    Average key length: 11.87, compression ratio: 1.42 
    Average prefix length: 7.63, average data length: 9.20 
    Clustering factor: 1, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PK_MON_LOG_TABLE_STATS (0) 
    Root page: 1504220, depth: 1, leaf buckets: 1, nodes: 30 
    Average node length: 8.37, total dup: 0, max dup: 0 
    Average key length: 7.33, compression ratio: 1.23 
    Average prefix length: 4.63, average data length: 4.37 
    Clustering factor: 1, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
OPTYPES (136) 
    Primary pointer page: 468, Index root page: 469 
    Total formats: 2, used formats: 1 
    Average record length: 67.56, total records: 9 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 386.00, compression ratio: 5.71 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 9% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index OPTYPES_MCODE_UNQ (1) 
    Root page: 1544805, depth: 1, leaf buckets: 1, nodes: 9 
    Average node length: 8.56, total dup: 0, max dup: 0 
    Average key length: 6.89, compression ratio: 0.73 
    Average prefix length: 0.44, average data length: 4.56 
    Clustering factor: 1, ratio: 0.11 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PK_OPTYPES (0) 
    Root page: 1544804, depth: 1, leaf buckets: 1, nodes: 9 
    Average node length: 6.11, total dup: 0, max dup: 0 
    Average key length: 5.00, compression ratio: 0.60 
    Average prefix length: 0.89, average data length: 2.11 
    Clustering factor: 1, ratio: 0.11 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
PDISTR (146) 
    Primary pointer page: 488, Index root page: 489 
    Total formats: 1, used formats: 1 
    Average record length: 36.68, total records: 835336 
    Average version length: 25.83, total versions: 46614, max versions: 4 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 54.00, compression ratio: 1.47 
    Pointer pages: 6, data page slots: 8320 
    Data pages: 8320, average fill: 69% 
    Primary pages: 8305, secondary pages: 15, swept pages: 2744 
    Empty pages: 17, full pages: 6126 
    Fill distribution: 
     0 - 19% = 33 
    20 - 39% = 48 
    40 - 59% = 365 
    60 - 79% = 7727 
    80 - 99% = 147 
 
    Index PDISTR_AGENT_ID (2) 
    Root page: 1509308, depth: 2, leaf buckets: 918, nodes: 835336 
    Average node length: 4.87, total dup: 835287, max dup: 161263 
    Average key length: 2.01, compression ratio: 4.48 
    Average prefix length: 8.99, average data length: 0.01 
    Clustering factor: 90701, ratio: 0.11 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 121 
        40 - 59% = 537 
        60 - 79% = 202 
        80 - 99% = 58 
 
    Index PDISTR_SNDOP_RCVOP_SNDID_ASC (0) 
    Root page: 1508613, depth: 3, leaf buckets: 1012, nodes: 835336 
    Average node length: 5.88, total dup: 743703, max dup: 42 
    Average key length: 3.02, compression ratio: 7.28 
    Average prefix length: 21.09, average data length: 0.91 
    Clustering factor: 165074, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 80 
        40 - 59% = 564 
        60 - 79% = 107 
        80 - 99% = 260 
 
    Index PDISTR_SNDOP_RCVOP_SNDID_DESC (1) 
    Root page: 1509187, depth: 3, leaf buckets: 1066, nodes: 835336 
    Average node length: 5.89, total dup: 743703, max dup: 42 
    Average key length: 3.02, compression ratio: 7.28 
    Average prefix length: 21.09, average data length: 0.91 
    Clustering factor: 166989, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 187 
        40 - 59% = 541 
        60 - 79% = 87 
        80 - 99% = 251 
 
    Index PDISTR_WORKER_SND_ID (3) 
    Root page: 1510178, depth: 3, leaf buckets: 1180, nodes: 835336 
    Average node length: 5.96, total dup: 743703, max dup: 42 
    Average key length: 3.10, compression ratio: 5.48 
    Average prefix length: 16.01, average data length: 0.99 
    Clustering factor: 159408, ratio: 0.19 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 254 
        40 - 59% = 626 
        60 - 79% = 216 
        80 - 99% = 84 
 
PERF_AGG (158) 
    Primary pointer page: 512, Index root page: 513 
    Total formats: 1, used formats: 1 
    Average record length: 62.88, total records: 5444 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 2.44, total fragments: 55, max fragments: 1 
    Average unpacked length: 379.00, compression ratio: 6.03 
    Pointer pages: 1, data page slots: 96 
    Data pages: 96, average fill: 56% 
    Primary pages: 74, secondary pages: 22, swept pages: 50 
    Empty pages: 15, full pages: 67 
    Fill distribution: 
     0 - 19% = 26 
    20 - 39% = 0 
    40 - 59% = 1 
    60 - 79% = 68 
    80 - 99% = 1 
 
    Index PERF_AGG_UNQ (1) 
    Root page: 1504238, depth: 2, leaf buckets: 7, nodes: 5444 
    Average node length: 5.49, total dup: 0, max dup: 0 
    Average key length: 3.59, compression ratio: 10.03 
    Average prefix length: 34.43, average data length: 1.55 
    Clustering factor: 5100, ratio: 0.94 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 4 
        60 - 79% = 1 
        80 - 99% = 1 
 
    Index PK_PERF_AGG (0) 
    Root page: 1504233, depth: 2, leaf buckets: 10, nodes: 5444 
    Average node length: 11.11, total dup: 0, max dup: 0 
    Average key length: 9.21, compression ratio: 0.98 
    Average prefix length: 2.79, average data length: 6.21 
    Clustering factor: 150, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 1 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 7 
 
PERF_ESTIMATED (280) 
    Primary pointer page: 1504218, Index root page: 1504219 
    Total formats: 1, used formats: 1 
    Average record length: 39.11, total records: 78564 
    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: 760 
    Data pages: 760, average fill: 71% 
    Primary pages: 760, secondary pages: 0, swept pages: 0 
    Empty pages: 2, full pages: 756 
    Fill distribution: 
     0 - 19% = 3 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 757 
    80 - 99% = 0 
 
    Index PK_PERF_ESTIMATED (0) 
    Root page: 33746, depth: 2, leaf buckets: 101, nodes: 78564 
    Average node length: 10.17, total dup: 0, max dup: 0 
    Average key length: 8.18, compression ratio: 1.10 
    Average prefix length: 3.82, average data length: 5.18 
    Clustering factor: 3361, ratio: 0.04 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 99 
 
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: 133.49, total records: 181065 
    Average version length: 154.32, total versions: 20728, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 12.70 
    Pointer pages: 6, data page slots: 5488 
    Data pages: 4368, average fill: 86% 
    Primary pages: 4368, secondary pages: 0, swept pages: 7 
    Empty pages: 60, full pages: 4282 
    Fill distribution: 
     0 - 19% = 64 
    20 - 39% = 3 
    40 - 59% = 9 
    60 - 79% = 11 
    80 - 99% = 4281 
 
PERF_SPLIT_1 (282) 
    Primary pointer page: 576, Index root page: 577 
    Total formats: 1, used formats: 1 
    Average record length: 147.38, total records: 175358 
    Average version length: 152.83, total versions: 4422, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.51 
    Pointer pages: 8, data page slots: 5704 
    Data pages: 4304, average fill: 84% 
    Primary pages: 4304, secondary pages: 0, swept pages: 5 
    Empty pages: 125, full pages: 4145 
    Fill distribution: 
     0 - 19% = 129 
    20 - 39% = 13 
    40 - 59% = 13 
    60 - 79% = 6 
    80 - 99% = 4143 
 
PERF_SPLIT_2 (283) 
    Primary pointer page: 578, Index root page: 579 
    Total formats: 1, used formats: 1 
    Average record length: 146.71, total records: 188749 
    Average version length: 153.14, total versions: 5618, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.56 
    Pointer pages: 8, data page slots: 7336 
    Data pages: 4576, average fill: 85% 
    Primary pages: 4576, secondary pages: 0, swept pages: 11 
    Empty pages: 86, full pages: 4467 
    Fill distribution: 
     0 - 19% = 87 
    20 - 39% = 12 
    40 - 59% = 5 
    60 - 79% = 4 
    80 - 99% = 4468 
 
PERF_SPLIT_3 (284) 
    Primary pointer page: 580, Index root page: 581 
    Total formats: 1, used formats: 1 
    Average record length: 148.26, total records: 161277 
    Average version length: 151.20, total versions: 2778, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.44 
    Pointer pages: 7, data page slots: 5816 
    Data pages: 3928, average fill: 85% 
    Primary pages: 3928, secondary pages: 0, swept pages: 8 
    Empty pages: 96, full pages: 3806 
    Fill distribution: 
     0 - 19% = 99 
    20 - 39% = 13 
    40 - 59% = 5 
    60 - 79% = 5 
    80 - 99% = 3806 
 
PERF_SPLIT_4 (285) 
    Primary pointer page: 582, Index root page: 583 
    Total formats: 1, used formats: 1 
    Average record length: 147.07, total records: 156730 
    Average version length: 152.12, total versions: 4073, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.53 
    Pointer pages: 8, data page slots: 5344 
    Data pages: 3840, average fill: 84% 
    Primary pages: 3840, secondary pages: 0, swept pages: 1 
    Empty pages: 110, full pages: 3699 
    Fill distribution: 
     0 - 19% = 116 
    20 - 39% = 10 
    40 - 59% = 5 
    60 - 79% = 10 
    80 - 99% = 3699 
 
PERF_SPLIT_5 (286) 
    Primary pointer page: 584, Index root page: 585 
    Total formats: 1, used formats: 1 
    Average record length: 145.53, total records: 170489 
    Average version length: 152.75, total versions: 6024, 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: 5344 
    Data pages: 4136, average fill: 85% 
    Primary pages: 4136, secondary pages: 0, swept pages: 4 
    Empty pages: 84, full pages: 4021 
    Fill distribution: 
     0 - 19% = 87 
    20 - 39% = 7 
    40 - 59% = 13 
    60 - 79% = 8 
    80 - 99% = 4021 
 
PERF_SPLIT_6 (287) 
    Primary pointer page: 586, Index root page: 587 
    Total formats: 1, used formats: 1 
    Average record length: 130.91, total records: 193046 
    Average version length: 154.93, total versions: 25679, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 12.96 
    Pointer pages: 7, data page slots: 5808 
    Data pages: 4712, average fill: 86% 
    Primary pages: 4712, secondary pages: 0, swept pages: 4 
    Empty pages: 62, full pages: 4529 
    Fill distribution: 
     0 - 19% = 70 
    20 - 39% = 8 
    40 - 59% = 96 
    60 - 79% = 9 
    80 - 99% = 4529 
 
PERF_SPLIT_7 (288) 
    Primary pointer page: 588, Index root page: 589 
    Total formats: 1, used formats: 1 
    Average record length: 148.84, total records: 179965 
    Average version length: 151.88, total versions: 2687, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.39 
    Pointer pages: 9, data page slots: 5456 
    Data pages: 4320, average fill: 86% 
    Primary pages: 4320, secondary pages: 0, swept pages: 3 
    Empty pages: 48, full pages: 4262 
    Fill distribution: 
     0 - 19% = 50 
    20 - 39% = 3 
    40 - 59% = 3 
    60 - 79% = 2 
    80 - 99% = 4262 
 
PERF_SPLIT_8 (289) 
    Primary pointer page: 590, Index root page: 591 
    Total formats: 1, used formats: 1 
    Average record length: 147.02, total records: 178816 
    Average version length: 153.21, total versions: 4744, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.54 
    Pointer pages: 8, data page slots: 6200 
    Data pages: 4336, average fill: 85% 
    Primary pages: 4336, secondary pages: 0, swept pages: 2 
    Empty pages: 85, full pages: 4227 
    Fill distribution: 
     0 - 19% = 89 
    20 - 39% = 6 
    40 - 59% = 5 
    60 - 79% = 10 
    80 - 99% = 4226 
 
PERF_SPLIT_9 (290) 
    Primary pointer page: 593, Index root page: 594 
    Total formats: 1, used formats: 1 
    Average record length: 142.01, total records: 164181 
    Average version length: 154.00, total versions: 9348, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.94 
    Pointer pages: 6, data page slots: 5912 
    Data pages: 4008, average fill: 85% 
    Primary pages: 4007, secondary pages: 1, swept pages: 22 
    Empty pages: 107, full pages: 3869 
    Fill distribution: 
     0 - 19% = 112 
    20 - 39% = 6 
    40 - 59% = 11 
    60 - 79% = 10 
    80 - 99% = 3869 
 
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: 52.21, total records: 2042261 
    Average version length: 52.89, total versions: 20656, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 70.00, compression ratio: 1.34 
    Pointer pages: 16, data page slots: 25440 
    Data pages: 25424, average fill: 69% 
    Primary pages: 25424, secondary pages: 0, swept pages: 13118 
    Empty pages: 341, full pages: 18708 
    Fill distribution: 
     0 - 19% = 730 
    20 - 39% = 704 
    40 - 59% = 1626 
    60 - 79% = 22226 
    80 - 99% = 138 
 
    Index PSTORNED_RCV_ID (1) 
    Root page: 1506186, depth: 3, leaf buckets: 2552, nodes: 2042261 
    Average node length: 5.45, total dup: 1903698, max dup: 1192 
    Average key length: 2.49, compression ratio: 3.61 
    Average prefix length: 8.57, average data length: 0.43 
    Clustering factor: 178134, ratio: 0.09 
    Fill distribution: 
         0 - 19% = 3 
        20 - 39% = 322 
        40 - 59% = 1683 
        60 - 79% = 260 
        80 - 99% = 284 
 
    Index PSTORNED_SND_ID (0) 
    Root page: 1504819, depth: 3, leaf buckets: 2756, nodes: 2042261 
    Average node length: 5.70, total dup: 1831825, max dup: 72 
    Average key length: 2.74, compression ratio: 3.28 
    Average prefix length: 8.36, average data length: 0.64 
    Clustering factor: 365893, ratio: 0.18 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 9 
        40 - 59% = 2527 
        60 - 79% = 197 
        80 - 99% = 22 
 
    Index PSTORNED_WORKER_ID (2) 
    Root page: 1507996, depth: 3, leaf buckets: 2116, nodes: 2042261 
    Average node length: 4.96, total dup: 2042161, max dup: 28460 
    Average key length: 2.00, compression ratio: 1.20 
    Average prefix length: 2.41, average data length: 0.00 
    Clustering factor: 176059, ratio: 0.09 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 238 
        40 - 59% = 1113 
        60 - 79% = 382 
        80 - 99% = 383 
 
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: 44.47, total records: 129248 
    Average version length: 69.19, total versions: 46217, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 2.83 
    Pointer pages: 3, data page slots: 3872 
    Data pages: 2824, average fill: 53% 
    Primary pages: 2824, secondary pages: 0, swept pages: 458 
    Empty pages: 443, full pages: 1220 
    Fill distribution: 
     0 - 19% = 620 
    20 - 39% = 313 
    40 - 59% = 444 
    60 - 79% = 568 
    80 - 99% = 879 
 
    Index XQD_1000_1200_WA_SO_RO_WKR_SND (0) 
    Root page: 102259, depth: 3, leaf buckets: 208, nodes: 129248 
    Average node length: 6.38, total dup: 112477, max dup: 14 
    Average key length: 3.97, compression ratio: 10.58 
    Average prefix length: 40.16, average data length: 1.84 
    Clustering factor: 22148, ratio: 0.17 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 57 
        40 - 59% = 95 
        60 - 79% = 48 
        80 - 99% = 6 
 
XQD_1000_3300 (178) 
    Primary pointer page: 553, Index root page: 554 
    Total formats: 1, used formats: 1 
    Average record length: 66.56, total records: 7222372 
    Average version length: 68.77, total versions: 252599, 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: 65, data page slots: 105096 
    Data pages: 105096, average fill: 73% 
    Primary pages: 105096, secondary pages: 0, swept pages: 44840 
    Empty pages: 6, full pages: 72397 
    Fill distribution: 
     0 - 19% = 63 
    20 - 39% = 530 
    40 - 59% = 6515 
    60 - 79% = 95371 
    80 - 99% = 2617 
 
    Index XQD_1000_3300_WA_SO_RO_WKR_SND (0) 
    Root page: 1480454, depth: 3, leaf buckets: 10860, nodes: 7222372 
    Average node length: 6.51, total dup: 6246368, max dup: 29 
    Average key length: 3.52, compression ratio: 11.93 
    Average prefix length: 40.61, average data length: 1.39 
    Clustering factor: 1621642, ratio: 0.22 
    Fill distribution: 
         0 - 19% = 9 
        20 - 39% = 1490 
        40 - 59% = 6059 
        60 - 79% = 2830 
        80 - 99% = 472 
 
    Index XQD_1000_3300_WKR_DOC_ASC (1) 
    Root page: 1486068, depth: 3, leaf buckets: 8787, nodes: 7222372 
    Average node length: 5.39, total dup: 6939791, max dup: 172 
    Average key length: 2.40, compression ratio: 7.08 
    Average prefix length: 16.64, average data length: 0.36 
    Clustering factor: 1415199, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 17 
        20 - 39% = 1177 
        40 - 59% = 5105 
        60 - 79% = 1492 
        80 - 99% = 996 
 
    Index XQD_1000_3300_WKR_DOC_DEC (2) 
    Root page: 1490608, depth: 3, leaf buckets: 8832, nodes: 7222372 
    Average node length: 5.39, total dup: 6939791, max dup: 172 
    Average key length: 2.40, compression ratio: 7.08 
    Average prefix length: 16.64, average data length: 0.36 
    Clustering factor: 1417719, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 4 
        20 - 39% = 1224 
        40 - 59% = 5125 
        60 - 79% = 1499 
        80 - 99% = 980 
 
XQD_1200_2000 (177) 
    Primary pointer page: 551, Index root page: 552 
    Total formats: 1, used formats: 1 
    Average record length: 67.87, total records: 12172168 
    Average version length: 68.75, total versions: 192922, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.86 
    Pointer pages: 105, data page slots: 170856 
    Data pages: 170856, average fill: 75% 
    Primary pages: 170856, secondary pages: 0, swept pages: 100414 
    Empty pages: 8, full pages: 147920 
    Fill distribution: 
     0 - 19% = 37 
    20 - 39% = 383 
    40 - 59% = 4513 
    60 - 79% = 163150 
    80 - 99% = 2773 
 
    Index XQD_1200_2000_WA_SO_RO_WKR_SND (0) 
    Root page: 1495028, depth: 3, leaf buckets: 18489, nodes: 12172168 
    Average node length: 6.60, total dup: 10609281, max dup: 54 
    Average key length: 3.43, compression ratio: 12.26 
    Average prefix length: 40.70, average data length: 1.30 
    Clustering factor: 2392320, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 28 
        20 - 39% = 2059 
        40 - 59% = 10924 
        60 - 79% = 4749 
        80 - 99% = 729 
 
XQD_2000_3300 (179) 
    Primary pointer page: 555, Index root page: 556 
    Total formats: 1, used formats: 1 
    Average record length: 50.37, total records: 1363471 
    Average version length: 69.07, total versions: 370328, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 2.50 
    Pointer pages: 28, data page slots: 44248 
    Data pages: 28719, average fill: 54% 
    Primary pages: 28718, secondary pages: 1, swept pages: 12544 
    Empty pages: 4388, full pages: 14259 
    Fill distribution: 
     0 - 19% = 7174 
    20 - 39% = 2783 
    40 - 59% = 2614 
    60 - 79% = 10513 
    80 - 99% = 5635 
 
    Index XQD_2000_3300_WA_SO_RO_WKR_SND (0) 
    Root page: 1479712, depth: 3, leaf buckets: 2131, nodes: 1363471 
    Average node length: 5.53, total dup: 1307395, max dup: 93 
    Average key length: 2.58, compression ratio: 16.28 
    Average prefix length: 41.46, average data length: 0.54 
    Clustering factor: 92836, ratio: 0.07 
    Fill distribution: 
         0 - 19% = 14 
        20 - 39% = 902 
        40 - 59% = 924 
        60 - 79% = 258 
        80 - 99% = 33 
 
XQD_2100_3300 (180) 
    Primary pointer page: 557, Index root page: 558 
    Total formats: 1, used formats: 1 
    Average record length: 47.66, total records: 974905 
    Average version length: 69.13, total versions: 301420, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 2.64 
    Pointer pages: 23, data page slots: 36864 
    Data pages: 28672, average fill: 39% 
    Primary pages: 28672, secondary pages: 0, swept pages: 9634 
    Empty pages: 6189, full pages: 6834 
    Fill distribution: 
     0 - 19% = 10403 
    20 - 39% = 4537 
    40 - 59% = 4464 
    60 - 79% = 4772 
    80 - 99% = 4496 
 
    Index XQD_2100_3300_WA_SO_RO_WKR_SND (0) 
    Root page: 1479207, depth: 3, leaf buckets: 1600, nodes: 974905 
    Average node length: 5.85, total dup: 906105, max dup: 99 
    Average key length: 2.92, compression ratio: 14.39 
    Average prefix length: 41.15, average data length: 0.85 
    Clustering factor: 136712, ratio: 0.14 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 656 
        40 - 59% = 717 
        60 - 79% = 206 
        80 - 99% = 21 
 
XQD_3300_3400 (181) 
    Primary pointer page: 559, Index root page: 560 
    Total formats: 1, used formats: 1 
    Average record length: 67.23, total records: 8698179 
    Average version length: 68.95, total versions: 209986, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.87 
    Pointer pages: 89, data page slots: 144600 
    Data pages: 144576, average fill: 64% 
    Primary pages: 144576, secondary pages: 0, swept pages: 92762 
    Empty pages: 767, full pages: 58035 
    Fill distribution: 
     0 - 19% = 2485 
    20 - 39% = 11234 
    40 - 59% = 30025 
    60 - 79% = 98469 
    80 - 99% = 2363 
 
    Index XQD_3300_3400_WA_SO_RO_WKR_SND (0) 
    Root page: 1472590, depth: 3, leaf buckets: 13396, nodes: 8698179 
    Average node length: 6.69, total dup: 7213641, max dup: 14 
    Average key length: 3.67, compression ratio: 11.43 
    Average prefix length: 40.50, average data length: 1.50 
    Clustering factor: 1806025, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 1708 
        40 - 59% = 7425 
        60 - 79% = 3891 
        80 - 99% = 370 
 
XQS_1000_1200 (182) 
    Primary pointer page: 561, Index root page: 562 
    Total formats: 1, used formats: 1 
    Average record length: 82.52, total records: 21131744 
    Average version length: 82.87, total versions: 5169, 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: 318576 
    Data pages: 318576, average fill: 81% 
    Primary pages: 318576, secondary pages: 0, swept pages: 13130 
    Empty pages: 38, full pages: 317497 
    Fill distribution: 
     0 - 19% = 64 
    20 - 39% = 45 
    40 - 59% = 144 
    60 - 79% = 27923 
    80 - 99% = 290400 
 
    Index XQS_1000_1200_DOC_ID (1) 
    Root page: 1426716, depth: 3, leaf buckets: 19544, nodes: 21131744 
    Average node length: 5.72, total dup: 20651074, max dup: 128 
    Average key length: 2.16, compression ratio: 4.16 
    Average prefix length: 8.86, average data length: 0.14 
    Clustering factor: 3277244, ratio: 0.16 
    Fill distribution: 
         0 - 19% = 6 
        20 - 39% = 0 
        40 - 59% = 8482 
        60 - 79% = 560 
        80 - 99% = 10496 
 
    Index XQS_1000_1200_RCV_ID (3) 
    Root page: 1456980, depth: 3, leaf buckets: 17172, nodes: 21131744 
    Average node length: 6.31, total dup: 18569491, max dup: 49 
    Average key length: 2.75, compression ratio: 3.27 
    Average prefix length: 8.37, average data length: 0.63 
    Clustering factor: 914368, ratio: 0.04 
    Fill distribution: 
         0 - 19% = 5 
        20 - 39% = 3 
        40 - 59% = 791 
        60 - 79% = 286 
        80 - 99% = 16087 
 
    Index XQS_1000_1200_SND_ID (2) 
    Root page: 1441073, depth: 3, leaf buckets: 21315, nodes: 21131744 
    Average node length: 6.35, total dup: 18489277, max dup: 25 
    Average key length: 2.79, compression ratio: 3.23 
    Average prefix length: 8.34, average data length: 0.66 
    Clustering factor: 3571884, ratio: 0.17 
    Fill distribution: 
         0 - 19% = 4 
        20 - 39% = 2 
        40 - 59% = 8748 
        60 - 79% = 585 
        80 - 99% = 11976 
 
    Index XQS_1000_1200_WORKER_ID (0) 
    Root page: 1413348, depth: 3, leaf buckets: 16090, nodes: 21131744 
    Average node length: 5.56, total dup: 21131644, max dup: 230029 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.42, average data length: 0.00 
    Clustering factor: 943167, ratio: 0.04 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 8 
        40 - 59% = 2884 
        60 - 79% = 388 
        80 - 99% = 12808 
 
XQS_1000_3300 (184) 
    Primary pointer page: 565, Index root page: 566 
    Total formats: 1, used formats: 1 
    Average record length: 80.58, total records: 9143949 
    Average version length: 82.60, total versions: 202842, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.56 
    Pointer pages: 106, data page slots: 172592 
    Data pages: 172552, average fill: 65% 
    Primary pages: 172552, secondary pages: 0, swept pages: 113899 
    Empty pages: 1193, full pages: 78597 
    Fill distribution: 
     0 - 19% = 3877 
    20 - 39% = 14187 
    40 - 59% = 35106 
    60 - 79% = 75381 
    80 - 99% = 44001 
 
    Index XQS_1000_3300_DOC_ID (1) 
    Root page: 1367502, depth: 3, leaf buckets: 11387, nodes: 9143949 
    Average node length: 5.38, total dup: 8841183, max dup: 169 
    Average key length: 2.24, compression ratio: 4.01 
    Average prefix length: 8.79, average data length: 0.21 
    Clustering factor: 1969544, ratio: 0.22 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 157 
        40 - 59% = 9620 
        60 - 79% = 1584 
        80 - 99% = 24 
 
    Index XQS_1000_3300_RCV_ID (3) 
    Root page: 1379261, depth: 3, leaf buckets: 13000, nodes: 9143949 
    Average node length: 6.25, total dup: 7578786, max dup: 14 
    Average key length: 3.10, compression ratio: 2.90 
    Average prefix length: 8.07, average data length: 0.93 
    Clustering factor: 1331197, ratio: 0.15 
    Fill distribution: 
         0 - 19% = 132 
        20 - 39% = 4112 
        40 - 59% = 3991 
        60 - 79% = 2479 
        80 - 99% = 2286 
 
    Index XQS_1000_3300_SND_ID (2) 
    Root page: 1373059, depth: 3, leaf buckets: 12714, nodes: 9143949 
    Average node length: 6.00, total dup: 7920688, max dup: 41 
    Average key length: 2.86, compression ratio: 3.15 
    Average prefix length: 8.27, average data length: 0.73 
    Clustering factor: 2148045, ratio: 0.23 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 194 
        40 - 59% = 10720 
        60 - 79% = 1767 
        80 - 99% = 31 
 
    Index XQS_1000_3300_WORKER_ID (0) 
    Root page: 1362767, depth: 3, leaf buckets: 9649, nodes: 9143949 
    Average node length: 5.14, total dup: 9143849, max dup: 155717 
    Average key length: 2.00, compression ratio: 1.20 
    Average prefix length: 2.41, average data length: 0.00 
    Clustering factor: 1386266, ratio: 0.15 
    Fill distribution: 
         0 - 19% = 42 
        20 - 39% = 1379 
        40 - 59% = 4602 
        60 - 79% = 1607 
        80 - 99% = 2019 
 
XQS_1200_2000 (183) 
    Primary pointer page: 563, Index root page: 564 
    Total formats: 1, used formats: 1 
    Average record length: 81.14, total records: 10871361 
    Average version length: 82.54, total versions: 151702, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.55 
    Pointer pages: 119, data page slots: 193640 
    Data pages: 191336, average fill: 70% 
    Primary pages: 191336, secondary pages: 0, swept pages: 91106 
    Empty pages: 4431, full pages: 127874 
    Fill distribution: 
     0 - 19% = 7618 
    20 - 39% = 10897 
    40 - 59% = 23404 
    60 - 79% = 46967 
    80 - 99% = 102450 
 
    Index XQS_1200_2000_DOC_ID (1) 
    Root page: 1392101, depth: 3, leaf buckets: 13139, nodes: 10871361 
    Average node length: 5.31, total dup: 10762447, max dup: 678 
    Average key length: 2.08, compression ratio: 4.32 
    Average prefix length: 8.93, average data length: 0.07 
    Clustering factor: 2262872, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 250 
        40 - 59% = 10214 
        60 - 79% = 2582 
        80 - 99% = 92 
 
    Index XQS_1200_2000_RCV_ID (3) 
    Root page: 1406110, depth: 3, leaf buckets: 10233, nodes: 10871361 
    Average node length: 5.50, total dup: 10394959, max dup: 49 
    Average key length: 2.28, compression ratio: 3.95 
    Average prefix length: 8.77, average data length: 0.23 
    Clustering factor: 684928, ratio: 0.06 
    Fill distribution: 
         0 - 19% = 175 
        20 - 39% = 914 
        40 - 59% = 2564 
        60 - 79% = 1881 
        80 - 99% = 4699 
 
    Index XQS_1200_2000_SND_ID (2) 
    Root page: 1398638, depth: 3, leaf buckets: 15024, nodes: 10871361 
    Average node length: 6.04, total dup: 9475665, max dup: 69 
    Average key length: 2.81, compression ratio: 3.20 
    Average prefix length: 8.32, average data length: 0.68 
    Clustering factor: 2279084, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 303 
        40 - 59% = 11816 
        60 - 79% = 2778 
        80 - 99% = 126 
 
    Index XQS_1200_2000_WORKER_ID (0) 
    Root page: 1386211, depth: 3, leaf buckets: 10426, nodes: 10871361 
    Average node length: 5.23, total dup: 10871261, max dup: 199649 
    Average key length: 2.00, compression ratio: 1.20 
    Average prefix length: 2.40, average data length: 0.00 
    Clustering factor: 674801, ratio: 0.06 
    Fill distribution: 
         0 - 19% = 91 
        20 - 39% = 871 
        40 - 59% = 4605 
        60 - 79% = 1483 
        80 - 99% = 3376 
 
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: 80.63, total records: 9289423 
    Average version length: 82.88, total versions: 236392, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.56 
    Pointer pages: 109, data page slots: 177312 
    Data pages: 177232, average fill: 65% 
    Primary pages: 177232, secondary pages: 0, swept pages: 114390 
    Empty pages: 1256, full pages: 78678 
    Fill distribution: 
     0 - 19% = 4030 
    20 - 39% = 15278 
    40 - 59% = 37854 
    60 - 79% = 76543 
    80 - 99% = 43527 
 
    Index XQS_2100_3300_DOC_ID (1) 
    Root page: 1344686, depth: 3, leaf buckets: 11489, nodes: 9289423 
    Average node length: 5.19, total dup: 9261180, max dup: 1549 
    Average key length: 2.03, compression ratio: 4.43 
    Average prefix length: 8.97, average data length: 0.03 
    Clustering factor: 1777477, ratio: 0.19 
    Fill distribution: 
         0 - 19% = 25 
        20 - 39% = 1673 
        40 - 59% = 7639 
        60 - 79% = 1656 
        80 - 99% = 496 
 
    Index XQS_2100_3300_RCV_ID (3) 
    Root page: 1355717, depth: 3, leaf buckets: 13199, nodes: 9289423 
    Average node length: 6.27, total dup: 7698515, max dup: 14 
    Average key length: 3.11, compression ratio: 2.90 
    Average prefix length: 8.06, average data length: 0.94 
    Clustering factor: 1291036, ratio: 0.14 
    Fill distribution: 
         0 - 19% = 182 
        20 - 39% = 4132 
        40 - 59% = 3964 
        60 - 79% = 2511 
        80 - 99% = 2410 
 
    Index XQS_2100_3300_SND_ID (2) 
    Root page: 1350049, depth: 3, leaf buckets: 12140, nodes: 9289423 
    Average node length: 5.45, total dup: 8867179, max dup: 93 
    Average key length: 2.29, compression ratio: 3.93 
    Average prefix length: 8.75, average data length: 0.25 
    Clustering factor: 1905672, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 38 
        20 - 39% = 1610 
        40 - 59% = 8562 
        60 - 79% = 1449 
        80 - 99% = 481 
 
    Index XQS_2100_3300_WORKER_ID (0) 
    Root page: 985805, depth: 3, leaf buckets: 9816, nodes: 9289423 
    Average node length: 5.16, total dup: 9289323, max dup: 157094 
    Average key length: 2.00, compression ratio: 1.20 
    Average prefix length: 2.41, average data length: 0.00 
    Clustering factor: 1397588, ratio: 0.15 
    Fill distribution: 
         0 - 19% = 46 
        20 - 39% = 1385 
        40 - 59% = 4739 
        60 - 79% = 1560 
        80 - 99% = 2086 
 
XQS_3300_3400 (187) 
    Primary pointer page: 571, Index root page: 572 
    Total formats: 1, used formats: 1 
    Average record length: 67.83, total records: 567616 
    Average version length: 68.86, total versions: 2778, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.86 
    Pointer pages: 5, data page slots: 8008 
    Data pages: 8008, average fill: 74% 
    Primary pages: 8008, secondary pages: 0, swept pages: 4579 
    Empty pages: 7, full pages: 6188 
    Fill distribution: 
     0 - 19% = 10 
    20 - 39% = 49 
    40 - 59% = 365 
    60 - 79% = 7543 
    80 - 99% = 41 
 
    Index XQS_3300_3400_DOC_ID (1) 
    Root page: 39587, depth: 3, leaf buckets: 738, nodes: 567616 
    Average node length: 5.95, total dup: 483199, max dup: 82 
    Average key length: 3.09, compression ratio: 2.91 
    Average prefix length: 8.05, average data length: 0.95 
    Clustering factor: 98610, ratio: 0.17 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 35 
        40 - 59% = 532 
        60 - 79% = 84 
        80 - 99% = 87 
 
    Index XQS_3300_3400_SND_ID (2) 
    Root page: 34518, depth: 3, leaf buckets: 761, nodes: 567616 
    Average node length: 6.15, total dup: 465400, max dup: 15 
    Average key length: 3.30, compression ratio: 2.73 
    Average prefix length: 7.88, average data length: 1.12 
    Clustering factor: 98654, ratio: 0.17 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 38 
        40 - 59% = 553 
        60 - 79% = 74 
        80 - 99% = 95 
 
    Index XQS_3300_3400_WORKER_ID (0) 
    Root page: 375548, depth: 2, leaf buckets: 579, nodes: 567616 
    Average node length: 4.86, total dup: 567516, max dup: 9488 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.41, average data length: 0.00 
    Clustering factor: 87652, ratio: 0.15 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 39 
        40 - 59% = 336 
        60 - 79% = 99 
        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 Wed Feb 28 16:12:36 2024

Record versions statistics, table

TABLE_NAME TOTAL_RECS TOTAL_VERS MAX_VERSIONS VERS_TO_RECS_PRC MAXV_TO_VERS_PRC
DOC_DATA 7666082 53830 1 0.0000 0.0000
DOC_LIST 2197006 55087 3 0.0000 0.0000
FB_ERRORS 2182 757 1 0.0000 0.0000
INVNT_SALDO 400 234165 616 58500.0000 0.0000
INVNT_TURNOVER_LOG 94144 79467 1 0.0000 0.0000
MONEY_SALDO 49 15672 893 31900.0000 0.0000
MONEY_TURNOVER_LOG 1522 1338 1 0.0000 0.0000
PDISTR 835336 46614 4 0.0000 0.0000
PERF_SPLIT_0 181065 20728 1 0.0000 0.0000
PERF_SPLIT_1 175358 4422 1 0.0000 0.0000
PERF_SPLIT_2 188749 5618 1 0.0000 0.0000
PERF_SPLIT_3 161277 2778 1 0.0000 0.0000
PERF_SPLIT_4 156730 4073 1 0.0000 0.0000
PERF_SPLIT_5 170489 6024 1 0.0000 0.0000
PERF_SPLIT_6 193046 25679 1 0.0000 0.0000
PERF_SPLIT_7 179965 2687 1 0.0000 0.0000
PERF_SPLIT_8 178816 4744 1 0.0000 0.0000
PERF_SPLIT_9 164181 9348 1 0.0000 0.0000
PSTORNED 2042261 20656 1 0.0000 0.0000
SEMAPHORES 5 1 1 0.0000 100.0000
XQD_1000_1200 129248 46217 1 0.0000 0.0000
XQD_1000_3300 7222372 252599 1 0.0000 0.0000
XQD_1200_2000 12172168 192922 1 0.0000 0.0000
XQD_2000_3300 1363471 370328 1 0.0000 0.0000
XQD_2100_3300 974905 301420 1 0.0000 0.0000
XQD_3300_3400 8698179 209986 1 0.0000 0.0000
XQS_1000_1200 21131744 5169 1 0.0000 0.0000
XQS_1000_3300 9143949 202842 1 0.0000 0.0000
XQS_1200_2000 10871361 151702 1 0.0000 0.0000
XQS_2100_3300 9289423 236392 1 0.0000 0.0000
XQS_3300_3400 567616 2778 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 ---
:1272: 
:1273: mscs-test-161.budzdorov.ru    Wed Feb 28 16:10:03 2024
:1274:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:1275: 
:1276: 
:1277: mscs-test-161.budzdorov.ru    Wed Feb 28 16:10:05 2024
:1278:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:1279: 
:1280: 
:1281: mscs-test-161.budzdorov.ru    Wed Feb 28 16:10:06 2024
:1282:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:1283: 
:1284: 
:1285: mscs-test-161.budzdorov.ru    Wed Feb 28 16:10:06 2024
:1286:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:1287: 
--- end of diff output ---

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

28.02.24 16:12:48. 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-28 16:12:50 No severe PSQL-related problems occured
28.02.24 16:12:52. End of report.