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

Hardware and OS info

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

Server and database settinfs 


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

Test configuration settings 

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

Test finish info 


FINISH_STATE                    NORMAL: TEST_TIME EXPIRED AT 2024-02-18 07:08:50
DTS_END                         2024-02-18 07:07:49.0770
FB_GDSCODE                      -1
FB_MNEMONA                      
STACK                           SRV_FILL_MON_CACHE_MEMORY(20:5) ==> SP_CHECK_TO_STOP_WORK(32:12) ==> SP_HALT_ON_ERROR(68:17)
IP                              ::1/60024
TRN_ID                          167822
ATT_ID                          259
EXC_UNIT                        2

Test workload details

SETTING_NAME SETTING_VALUE
WORKING_MODE SMALL_03
C_WARES_MAX_ID 400
C_CUSTOMER_DOC_MAX_ROWS 10
C_SUPPLIER_DOC_MAX_ROWS 50
C_CUSTOMER_DOC_MAX_QTY 15
C_SUPPLIER_DOC_MAX_QTY 50
C_NUMBER_OF_AGENTS 50

Indexes for heavy-loaded tables

TAB_NAME IDX_NAME IDX_KEY
XQD_1000_1200 XQD_1000_1200_WA_SO_RO_WKR_SND WARE_ID,SND_OPTYPE_ID,RCV_OPTYPE_ID,WORKER_ID,SND_ID
XQD_1000_3300 XQD_1000_3300_WA_SO_RO_WKR_SND WARE_ID,SND_OPTYPE_ID,RCV_OPTYPE_ID,WORKER_ID,SND_ID
XQD_1000_3300 XQD_1000_3300_WKR_DOC_ASC WORKER_ID,DOC_ID
XQD_1000_3300 XQD_1000_3300_WKR_DOC_DEC WORKER_ID,DOC_ID
XQD_1200_2000 XQD_1200_2000_WA_SO_RO_WKR_SND WARE_ID,SND_OPTYPE_ID,RCV_OPTYPE_ID,WORKER_ID,SND_ID
XQD_2000_3300 XQD_2000_3300_WA_SO_RO_WKR_SND WARE_ID,SND_OPTYPE_ID,RCV_OPTYPE_ID,WORKER_ID,SND_ID
XQD_2100_3300 XQD_2100_3300_WA_SO_RO_WKR_SND WARE_ID,SND_OPTYPE_ID,RCV_OPTYPE_ID,WORKER_ID,SND_ID
XQD_3300_3400 XQD_3300_3400_WA_SO_RO_WKR_SND WARE_ID,SND_OPTYPE_ID,RCV_OPTYPE_ID,WORKER_ID,SND_ID

Performance in TOTAL

ACTION AVG_TIMES_PER_MINUTE AVG_ELAPSED_MS SUCCESSFUL_TIMES_DONE
*** OVERALL *** for 100 minutes: 9123.40 20023 912340
customer order: creation 167.57 456 16757
customer order: refuse 14.61 373 1461
order to supplier: creation 45.58 1328 4558
order to supplier: removal 3.57 91091 357
invoice (draft): creation 44.85 3111 4485
invoice (draft): removal 49.69 766 4969
invoice accept: apply 41.16 21420 4116
invoice accept: cancel 44.91 830 4491
customer reserve: creation 4019.80 201 401980
customer reserve: removal 4406.68 59 440668
realization accept: apply 80.45 219 8045
realization accept: cancel 78.94 138 7894
payment from customer: creation 58.89 142 5889
payment from customer: removal 5.64 96 564
payment to supplier: creation 47.98 176 4798
payment to supplier: removal 3.05 72 305
service: total inventory turnovers 3.52 3948 352
service: total monetary turnovers 5.77 596 577
service: aggregate perf. data 0.71 23406 71
service: refresh index statistics 0.03 252026 3

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:02, from 18-02-2024 07:10:35 to 18-02-2024 07:10:37.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 2973
TEST_TIME 2 2485
TEST_TIME 3 2715
TEST_TIME 4 2861
TEST_TIME 5 4001
TEST_TIME 6 4306
TEST_TIME 7 4647
TEST_TIME 8 5370
TEST_TIME 9 5408
TEST_TIME 10 5479
TEST_TIME 11 5634
TEST_TIME 12 6200
TEST_TIME 13 6334
TEST_TIME 14 6866
TEST_TIME 15 6897
TEST_TIME 16 7030
TEST_TIME 17 7327
TEST_TIME 18 7636
TEST_TIME 19 7673
TEST_TIME 20 7968
TEST_TIME 21 8581
TEST_TIME 22 8602
TEST_TIME 23 9271
TEST_TIME 24 9461
TEST_TIME 25 9607
TEST_TIME 26 9686
TEST_TIME 27 9928
TEST_TIME 28 10122
TEST_TIME 29 9874
TEST_TIME 30 9626
TEST_TIME 31 9373
TEST_TIME 32 9253
TEST_TIME 33 9208
TEST_TIME 34 9053
TEST_TIME 35 9242
TEST_TIME 36 9172
TEST_TIME 37 9074
TEST_TIME 38 8953
TEST_TIME 39 8995
TEST_TIME 40 8832
TEST_TIME 41 8928
TEST_TIME 42 8855
TEST_TIME 43 8915
TEST_TIME 44 8868
TEST_TIME 45 8941
TEST_TIME 46 8907
TEST_TIME 47 9039
TEST_TIME 48 9005
TEST_TIME 49 9044
TEST_TIME 50 9135
TEST_TIME 51 9179
TEST_TIME 52 9145
TEST_TIME 53 9129
TEST_TIME 54 9358
TEST_TIME 55 9373
TEST_TIME 56 9314
TEST_TIME 57 9170
TEST_TIME 58 9170
TEST_TIME 59 9100
TEST_TIME 60 9064
TEST_TIME 61 9110
TEST_TIME 62 9088
TEST_TIME 63 9039
TEST_TIME 64 8948
TEST_TIME 65 8898
TEST_TIME 66 8932
TEST_TIME 67 8936
TEST_TIME 68 8945
TEST_TIME 69 8966
TEST_TIME 70 8989
TEST_TIME 71 9019
TEST_TIME 72 9098
TEST_TIME 73 9093
TEST_TIME 74 9139
TEST_TIME 75 9185
TEST_TIME 76 9150
TEST_TIME 77 9231
TEST_TIME 78 9289
TEST_TIME 79 9387
TEST_TIME 80 9304
TEST_TIME 81 9213
TEST_TIME 82 9198
TEST_TIME 83 9158
TEST_TIME 84 9086
TEST_TIME 85 9073
TEST_TIME 86 9096
TEST_TIME 87 9063
TEST_TIME 88 9056
TEST_TIME 89 9064
TEST_TIME 90 9099
TEST_TIME 91 9130
TEST_TIME 92 9134
TEST_TIME 93 9101
TEST_TIME 94 9157
TEST_TIME 95 9170
TEST_TIME 96 9192
TEST_TIME 97 9211
TEST_TIME 98 9230
TEST_TIME 99 9213
TEST_TIME 100 9131

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:03, from 18-02-2024 07:10:39 to 18-02-2024 07:10:42.

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 1278210 1278210 0 0.00 0 37022 8 0 0
doc_list_biud 1278209 1278209 0 0.00 0 62694 26 0 0
sp_add_invoice_to_stock 4229 4116 113 2.67 27 238861 21421 0 113
sp_cancel_adding_invoice 4491 4491 0 0.00 5 45666 830 0 0
sp_cancel_client_order 1461 1461 0 0.00 4 16034 373 0 0
sp_cancel_customer_reserve 440668 440668 0 0.00 0 62696 59 0 0
sp_cancel_pay_from_customer 564 564 0 0.00 2 7804 96 0 0
sp_cancel_pay_to_supplier 305 305 0 0.00 2 5607 73 0 0
sp_cancel_supplier_invoice 4980 4969 11 0.22 2 33123 766 0 11
sp_cancel_supplier_order 357 357 0 0.00 6 773837 91092 0 0
sp_cancel_write_off 7894 7894 0 0.00 1 23844 139 0 0
sp_client_order 16757 16757 0 0.00 3 62638 457 0 0
sp_customer_reserve 401980 401980 0 0.00 0 58455 202 0 0
sp_fill_shopping_cart 25794 25794 0 0.00 1 17856 43 0 0
sp_fill_shopping_cart_clo_res 401977 401977 0 0.00 0 21859 18 0 0
sp_get_clo_for_invoice 4107 4107 0 0.00 0 30017 411 0 0
sp_kill_cost_storno 13254 13254 0 0.00 0 23731 68 0 0
sp_kill_qstorno_ret_qs2qd 894556 894556 0 0.00 0 62691 32 0 0
sp_kill_qty_storno 471990 471990 0 0.00 0 62694 69 0 0
sp_lock_selected_doc 16923 16923 0 0.00 0 7079 5 0 0
sp_make_cost_storno 22837 22837 0 0.00 0 37000 69 0 0
sp_multiply_rows_for_pdistr 22837 22837 0 0.00 0 28232 49 0 0
sp_multiply_rows_for_qdistr 16757 16757 0 0.00 0 62632 243 0 0
sp_pay_from_customer 5889 5889 0 0.00 3 28702 143 0 0
sp_pay_to_supplier 4798 4798 0 0.00 4 37029 176 0 0
sp_payment_common 10687 10687 0 0.00 1 14760 25 0 0
sp_qd_handle_on_cancel_clo 1461 1461 0 0.00 0 12212 337 0 0
sp_qd_handle_on_invoice_upd_sts 8596 8596 0 0.00 0 37009 311 0 0
sp_qd_handle_on_reserve_upd_sts 8045 8045 0 0.00 0 22335 46 0 0
sp_reserve_write_off 8045 8045 0 0.00 5 28251 220 0 0
sp_supplier_invoice 4485 4485 0 0.00 5 91480 3111 0 0
sp_supplier_order 4558 4558 0 0.00 4 36502 1328 0 0
srv_aggregate_perf_data 71 71 0 0.00 1561 406803 23407 0 0
srv_fill_mon_cache_memory 54 54 0 0.00 1521 142570 41012 0 0
srv_find_qd_qs_mism 869326 869326 0 0.00 0 21470 6 0 0
srv_make_invnt_saldo 352 352 0 0.00 50 92519 3948 0 0
srv_make_money_saldo 577 577 0 0.00 0 13719 597 0 0
srv_recalc_idx_stat 3 3 0 0.00 179861 344400 252027 0 0
t$perf-abend:sp_add_invoice_to_stock 113 113 0 0.00 0 0 0 0 0
t$perf-abend:sp_cancel_supplier_invoice 11 11 0 0.00 0 0 0 0 0
t$perf-norm:sp_add_invoice_to_stock 4116 4116 0 0.00 0 8703 185 0 0
t$perf-norm:sp_cancel_adding_invoice 350 350 0 0.00 0 3645 112 0 0
t$perf-norm:sp_cancel_client_order 1461 1461 0 0.00 0 6363 14 0 0
t$perf-norm:sp_cancel_customer_reserve 574 574 0 0.00 0 1278 15 0 0
t$perf-norm:sp_cancel_pay_from_customer 564 564 0 0.00 0 538 5 0 0
t$perf-norm:sp_cancel_pay_to_supplier 305 305 0 0.00 0 43 1 0 0
t$perf-norm:sp_cancel_supplier_invoice 332 332 0 0.00 0 4023 37 0 0
t$perf-norm:sp_cancel_supplier_order 357 357 0 0.00 0 24056 1720 0 0
t$perf-norm:sp_cancel_write_off 830 830 0 0.00 0 747 6 0 0
t$perf-norm:sp_client_order 16757 16757 0 0.00 0 49551 19 0 0
t$perf-norm:sp_customer_reserve 786 786 0 0.00 0 2114 8 0 0
t$perf-norm:sp_pay_from_customer 5889 5889 0 0.00 0 18140 14 0 0
t$perf-norm:sp_pay_to_supplier 4798 4798 0 0.00 0 10683 16 0 0
t$perf-norm:sp_reserve_write_off 8045 8045 0 0.00 0 50857 19 0 0
t$perf-norm:sp_supplier_invoice 4485 4485 0 0.00 0 7491 18 0 0
t$perf-norm:sp_supplier_order 4558 4558 0 0.00 0 3692 16 0 0
t$perf-norm:srv_aggregate_perf_data 71 71 0 0.00 0 502 14 0 0
t$perf-norm:srv_fill_mon_cache_memory 54 54 0 0.00 0 16 1 0 0
t$perf-norm:srv_make_invnt_saldo 352 352 0 0.00 0 596 12 0 0
t$perf-norm:srv_make_money_saldo 577 577 0 0.00 0 37180 69 0 0
t$perf-norm:srv_recalc_idx_stat 3 3 0 0.00 2 25 10 0 0
v_add_invoice_to_stock 8436 8210 226 2.67 0 15643 21 0 226
v_all_customers 31356 31356 0 0.00 0 19 1 0 0
v_all_suppliers 25702 25702 0 0.00 0 20 1 0 0
v_all_wares 33512 33512 0 0.00 0 19 1 0 0
v_cancel_adding_invoice 700 700 0 0.00 0 1041 7 0 0
v_cancel_client_order 2922 2922 0 0.00 0 15627 10 0 0
v_cancel_customer_prepayment 1128 1128 0 0.00 0 2843 7 0 0
v_cancel_customer_reserve 1148 1148 0 0.00 0 268 3 0 0
v_cancel_payment_to_supplier 610 610 0 0.00 0 321 4 0 0
v_cancel_supplier_invoice 686 664 22 3.20 0 13820 54 0 22
v_cancel_supplier_order 714 714 0 0.00 0 932 7 0 0
v_cancel_write_off 1660 1660 0 0.00 0 15656 27 0 0
v_max_id_clo_ord 4557 4557 0 0.00 0 972 1 0 0
v_max_id_clo_res 786 786 0 0.00 0 11228 38 0 0
v_max_id_ord_sup 4481 4481 0 0.00 0 4683 6 0 0
v_max_non_paid_invoice 985 985 0 0.00 0 85 2 0 0
v_max_non_paid_realizn 2833 2833 0 0.00 0 2997 3 0 0
v_min_id_clo_ord 4557 4557 0 0.00 0 15299 19 0 0
v_min_id_clo_res 786 786 0 0.00 0 1411 5 0 0
v_min_id_ord_sup 4481 4481 0 0.00 0 3356 6 0 0
v_min_non_paid_invoice 4798 4798 0 0.00 0 14753 16 0 0
v_min_non_paid_realizn 5889 5889 0 0.00 0 14754 20 0 0
v_our_firm 8268 8268 0 0.00 0 20 1 0 0
v_reserve_write_off 16090 16090 0 0.00 0 15779 8 0 0
x_lock_depdocs_on_canc_invoice 9128 9128 0 0.00 0 11278 111 0 0
x_lock_depdocs_on_canc_sup_ord 357 357 0 0.00 0 8475 362 0 0
x_make_qstorno_1000_1200 4558 4558 0 0.00 1 36494 1228 0 0
x_make_qstorno_1200_2000 4485 4485 0 0.00 2 84514 2968 0 0
x_make_qstorno_2100_3300 401980 401980 0 0.00 0 52297 181 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 18-02-2024 07:10:43 to 18-02-2024 07:10:47.

Memory consumption, metadata cache, attachments activity 

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


Page cache type: shared, buffers: 1000000 for all connections, with total size: 8192000000
measurement_dts measurement duration ms page cache memo used memo used, total memo allocated, total metadata cache metadata cache percent of total total attachments cnt active attachments cnt running statements cnt stalled statements cnt memo used by attachments memo used by transactions memo used by statements
05:07:51 1005 8192000000 8959446256 9022357504 3896544 0.047 2 1 2 0 3994160 61840 35776
05:08:54 27732 8192000000 9708220832 10005532672 787347840 8.768 100 87 174 0 816428416 7379376 21701200
05:10:25 19707 8192000000 9755923040 10060849152 829369184 9.193 100 90 180 0 862689552 11306496 22013872
05:11:52 16971 8192000000 9785705856 10100740096 853705744 9.437 100 84 167 0 892892784 19280400 19906640
05:13:17 13483 8192000000 9861488096 10191671296 906893504 9.967 100 87 174 0 966323120 39895328 19534288
05:14:34 8209 8192000000 9891941120 10233831424 942601280 10.319 100 76 150 0 1003674272 45218832 15854160
05:15:47 3924 8192000000 9944538544 10293899264 977332048 10.658 100 83 162 0 1052154224 57667968 17154208
05:16:53 2317 8192000000 9963446912 10325708800 1014475040 11.019 100 81 156 0 1081215216 50457760 16282416
05:17:58 1438 8192000000 10023579232 10385616896 1025489632 11.125 100 88 175 1 1134028304 91140432 17398240
05:19:01 1041 8192000000 10027395632 10400702464 1050515040 11.366 100 81 161 0 1137614944 70145168 16954736
05:20:03 25707 8192000000 9982520768 10373144576 1062345216 11.479 100 55 110 2 1114088800 39965856 11777728
05:21:30 6317 8192000000 9991609904 10386788352 1070569808 11.558 100 39 76 0 1106909568 28085696 8254064
05:22:37 5602 8192000000 10016224864 10413219840 1078385104 11.632 100 44 85 1 1134905024 47349424 9170496
05:23:44 6174 8192000000 9997552576 10398691328 1085240960 11.697 100 32 64 0 1112902304 20161200 7500144
05:24:54 23584 8192000000 10004012752 10401157120 1089873968 11.741 100 54 106 0 1113481888 12563328 11044592
05:26:20 6512 8192000000 10006090656 10416259072 1091449952 11.756 100 37 74 0 1124819696 25128976 8240768
05:27:27 9343 8192000000 9988167104 10391212032 1078412576 11.632 99 21 42 1 1099118608 15823952 4882080
05:28:48 55139 8192000000 10047544704 10445312000 1094631408 11.787 100 45 86 1 1134816128 31184272 9000448
05:30:59 16969 8192000000 10090330352 10487238656 1112615920 11.957 100 56 110 0 1193819408 70147280 11056208
05:32:25 11168 8192000000 10111212128 10516840448 1112100496 11.952 100 47 92 0 1227994000 106661280 9232224
05:33:42 13474 8192000000 10137013760 10539458560 1106954992 11.904 99 56 110 0 1234147504 114844128 12348384
05:35:08 41855 8192000000 10112971456 10550784000 1088417424 11.728 97 39 78 1 1221820416 124915280 8487712
05:36:58 9458 8192000000 10137467760 10553606144 1119149024 12.019 100 46 92 0 1246723680 117656480 9918176
05:38:13 10205 8192000000 10145436576 10546614272 1091848736 11.760 96 49 98 0 1226014416 123773600 10392080
05:39:27 6087 8192000000 10174510400 10583265280 1089847712 11.741 99 59 117 2 1273829680 171050592 12931376
05:40:40 4076 8192000000 10169657648 10564481024 1081783104 11.664 100 68 135 0 1281150928 184529024 14838800
05:41:49 9252 8192000000 10172379712 10557685760 1078384192 11.632 98 64 123 0 1252105712 160255712 13465808
05:43:02 11531 8192000000 10201293072 10607300608 1089822192 11.741 99 54 108 1 1298545216 196067360 12655664
05:44:20 1521 8192000000 10291700992 10682499072 1117758208 12.006 100 82 160 1 1400712416 264247488 18706720
05:45:28 2981 8192000000 10325251856 10724605952 1120358608 12.030 100 78 156 0 1416983872 279271280 17353984
05:46:36 2736 8192000000 10296455904 10703618048 1108860976 11.922 99 66 132 1 1395124784 270833904 15429904
05:47:45 4599 8192000000 10352478112 10753130496 1136702144 12.184 100 76 152 0 1455246208 301924256 16619808
05:48:56 8043 8192000000 10279192704 10734874624 1137241760 12.190 100 38 75 0 1387535440 241642704 8650976
05:50:10 13131 8192000000 10239204672 10712002560 1136964112 12.187 100 23 46 0 1393453424 250255632 6233680
05:51:26 48944 8192000000 10208247024 10737725440 1130098080 12.122 100 21 42 0 1344932080 209450784 5383216
05:53:29 25874 8192000000 10198119728 10655199232 1138469616 12.201 100 28 56 0 1285408416 140784896 6153904
05:55:02 33068 8192000000 10070307936 10536701952 1132785808 12.148 100 22 44 0 1208683760 71167040 4730912
05:56:35 45174 8192000000 10053824432 10510630912 1113934176 11.970 99 5 10 0 1146457504 31464800 1058528
05:59:08 32576 8192000000 10092961072 10518401024 1107409120 11.908 99 46 92 0 1162216368 45285936 9521312
06:00:42 27402 8192000000 10107253984 10533830656 1113101328 11.962 99 20 40 0 1176191232 59098752 3991152
06:02:10 78298 8192000000 10097664048 10592718848 1129151952 12.113 100 16 32 0 1223396208 90665440 3578816
06:04:30 64189 8192000000 10118558672 10572648448 1136407248 12.182 100 23 45 0 1212236016 71227136 4601632
06:06:47 46182 8192000000 10106140256 10566488064 1135636512 12.174 100 12 24 0 1218194256 80246416 2311328
06:08:36 22432 8192000000 10092467472 10532597760 1150459088 12.314 100 47 95 0 1200685408 40493632 9732688
06:10:05 50730 8192000000 10071593936 10562965504 1150770224 12.317 100 11 22 0 1207899472 55187168 1942080
06:11:59 64164 8192000000 10097597360 10579214336 1127574304 12.098 98 10 20 0 1177502080 48180048 1747728
06:14:04 47770 8192000000 10127741424 10596360192 1126005552 12.084 98 28 56 1 1187170320 55465488 5699280
06:15:52 38528 8192000000 10117542992 10552221696 1118039232 12.008 97 39 78 0 1203728112 76303776 9385104
06:17:43 41257 8192000000 10099205872 10546704384 1146449056 12.276 100 27 54 0 1205693296 54150832 5093408
06:19:28 52678 8192000000 10116000640 10542465024 1108568864 11.919 96 20 40 0 1173776560 60561872 4645824
06:21:26 62232 8192000000 10070611520 10585583616 1082247024 11.669 95 6 12 0 1119029536 35375456 1407056
06:23:29 134242 8192000000 10076108112 10546585600 1111375808 11.945 98 34 64 1 1151212976 32075840 7761328
06:26:44 26983 8192000000 10087069056 10536865792 1126181856 12.085 99 30 60 0 1174288032 42379904 5726272
06:28:12 17925 8192000000 10076825040 10505756672 1109819712 11.931 99 39 78 0 1186224912 68436624 7968576
06:29:30 48622 8192000000 10007790544 10465988608 1027549776 11.145 93 10 20 0 1064767072 35289456 1927840
06:31:21 63662 8192000000 10060394224 10500407296 1072965280 11.580 97 14 28 0 1112676096 36636384 3074432
06:34:53 65553 8192000000 10035034096 10482409472 1073365936 11.584 98 11 22 1 1113698032 38074336 2257760
06:37:02 57354 8192000000 10073138864 10522918912 1084527840 11.691 98 38 76 0 1173720256 81008976 8183440
06:39:22 53048 8192000000 10044440000 10475667456 1065189824 11.506 96 11 22 0 1090572672 23475712 1907136
06:41:15 32956 8192000000 10069554656 10499637248 1105607456 11.891 99 34 66 0 1157566912 44863520 7095936
06:42:50 38243 8192000000 10091230992 10522144768 1131186048 12.133 100 43 87 0 1178728400 39174320 8368032
06:44:29 49315 8192000000 10112597376 10583846912 1120475520 12.031 99 35 69 1 1219093072 91585920 7031632
06:46:21 142570 8192000000 10071837440 10570072064 1113965936 11.970 98 14 28 0 1165517312 48494976 3056400
06:50:33 56831 8192000000 10065390096 10534850560 1128934928 12.111 99 8 16 0 1182508832 51685232 1888672
06:52:30 63512 8192000000 10093177968 10542854144 1143041472 12.244 100 12 24 0 1185695488 40261184 2392832
06:54:44 54673 8192000000 10085565104 10527997952 1114861696 11.978 97 29 58 0 1169158960 47644400 6652864
06:56:51 34409 8192000000 10120466960 10570158080 1148255584 12.293 99 37 73 0 1199442320 43792496 7394240
06:58:37 100081 8192000000 10089289280 10552197120 1118288256 12.011 97 23 46 0 1175595424 52758848 4548320
07:01:27 69467 8192000000 10102542656 10609192960 1143556112 12.249 100 16 32 0 1213745008 67319696 2869200
07:03:37 62447 8192000000 10092477728 10544508928 1126154480 12.085 98 15 30 0 1156274448 27286768 2833200
07:05:41 38957 8192000000 10133149872 10631938048 1155085872 12.357 100 30 59 0 1247410176 86481584 5842720

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:14, from 18-02-2024 07:10:49 to 18-02-2024 07:11:03.

Exceptions occured during test was in run

FB_MNEMONA CNT UNIT FB_GDSCODE
except 113 v_add_invoice_to_stock 335544517
except 11 v_cancel_supplier_invoice 335544517

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

Content of mon$database and FB version 


MON$DATABASE_NAME               /home/bases/oltp40-etalone.fdb
MON$PAGE_SIZE                   8192
MON$ODS_MAJOR                   13
MON$ODS_MINOR                   0
MON$OLDEST_TRANSACTION          167393
MON$OLDEST_ACTIVE               172302
MON$OLDEST_SNAPSHOT             172302
MON$NEXT_TRANSACTION            172302
MON$PAGE_BUFFERS                1000000
MON$SQL_DIALECT                 3
MON$SHUTDOWN_MODE               0
MON$SWEEP_INTERVAL              0
MON$READ_ONLY                   0
MON$FORCED_WRITES               1
MON$RESERVE_SPACE               1
MON$CREATION_DATE               2020-04-30 07:30:08.6030 GMT
MON$PAGES                       1910304
MON$STAT_ID                     1
MON$BACKUP_STATE                0
MON$CRYPT_PAGE                  0
MON$OWNER                       SYSDBA                                                                                                                                                                                                                                                      
MON$SEC_DATABASE                Default
MON$CRYPT_STATE                 0
MON$GUID                        {58978C10-B735-40F5-8B7D-F7A1956E782B}
MON$FILE_ID                     02fd0000000000002e02000000000000
MON$NEXT_ATTACHMENT             678
MON$NEXT_STATEMENT              53
MON$REPLICA_MODE                0


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

Database statistics 

 
Database "/home/bases/oltp40-etalone.fdb" 
Gstat execution time Sun Feb 18 07:11:07 2024 
 
Database header page information: 
    Flags            0 
    Generation        90693 
    System Change Number    0 
    Page size        8192 
    ODS version        13.0 
    Oldest transaction    167393 
    Oldest active        172302 
    Oldest snapshot        172302 
    Next transaction    172303 
    Sequence number        0 
    Next attachment ID    678 
    Implementation        HW=AMD/Intel/x64 little-endian OS=Linux CC=gcc 
    Shadow count        0 
    Page buffers        0 
    Next header page    0 
    Database dialect    3 
    Creation date        Apr 30, 2020 7:30:08 
    Attributes        force write 
 
    Variable header data: 
    Database GUID:    {58978C10-B735-40F5-8B7D-F7A1956E782B} 
    Sweep interval:        0 
    *END* 
 
 
Database file sequence: 
File /home/bases/oltp40-etalone.fdb is the only file 
 
Analyzing database pages ... 
AGENTS (150) 
    Primary pointer page: 524, Index root page: 525 
    Total formats: 1, used formats: 1 
    Average record length: 33.60, total records: 50 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 344.00, compression ratio: 10.24 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 31% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 1 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index AGENTS_ID_DESC (2) 
    Root page: 1504333, depth: 1, leaf buckets: 1, nodes: 50 
    Average node length: 11.82, total dup: 0, max dup: 0 
    Average key length: 10.80, compression ratio: 0.83 
    Average prefix length: 1.18, average data length: 7.82 
    Clustering factor: 1, ratio: 0.02 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index AGENTS_IS_OUR_FIRM (4) 
    Root page: 1504335, depth: 1, leaf buckets: 1, nodes: 50 
    Average node length: 3.08, total dup: 48, max dup: 48 
    Average key length: 2.04, compression ratio: 0.50 
    Average prefix length: 0.96, average data length: 0.06 
    Clustering factor: 1, ratio: 0.02 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index AGENTS_IS_SUPPLIER (3) 
    Root page: 1504334, depth: 1, leaf buckets: 1, nodes: 50 
    Average node length: 3.08, total dup: 48, max dup: 44 
    Average key length: 2.04, compression ratio: 0.54 
    Average prefix length: 1.04, average data length: 0.06 
    Clustering factor: 1, ratio: 0.02 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index AGENTS_NAME_UNQ (1) 
    Root page: 1504332, depth: 1, leaf buckets: 1, nodes: 50 
    Average node length: 17.20, total dup: 0, max dup: 0 
    Average key length: 15.88, compression ratio: 0.92 
    Average prefix length: 1.42, average data length: 13.20 
    Clustering factor: 1, ratio: 0.02 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PK_AGENTS (0) 
    Root page: 1504331, depth: 1, leaf buckets: 1, nodes: 50 
    Average node length: 11.82, total dup: 0, max dup: 0 
    Average key length: 10.80, compression ratio: 0.83 
    Average prefix length: 1.18, average data length: 7.82 
    Clustering factor: 1, ratio: 0.02 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
BUSINESS_OPS (154) 
    Primary pointer page: 532, Index root page: 533 
    Total formats: 1, used formats: 1 
    Average record length: 108.20, total records: 20 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1235.00, compression ratio: 11.41 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 31% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 1 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index BO_UNIT_UNQ (1) 
    Root page: 1504264, depth: 1, leaf buckets: 1, nodes: 20 
    Average node length: 18.25, total dup: 0, max dup: 0 
    Average key length: 17.20, compression ratio: 1.24 
    Average prefix length: 7.05, average data length: 14.25 
    Clustering factor: 1, ratio: 0.05 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index BUSINESS_OPS_PREDICT_PRIOR (3) 
    Root page: 1504266, depth: 1, leaf buckets: 1, nodes: 20 
    Average node length: 5.40, total dup: 0, max dup: 0 
    Average key length: 4.35, compression ratio: 0.67 
    Average prefix length: 1.20, average data length: 1.70 
    Clustering factor: 1, ratio: 0.05 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index BUSINESS_OPS_RND_WGTH (2) 
    Root page: 1504265, depth: 1, leaf buckets: 1, nodes: 20 
    Average node length: 4.30, total dup: 6, max dup: 3 
    Average key length: 3.25, compression ratio: 0.72 
    Average prefix length: 1.35, average data length: 1.00 
    Clustering factor: 1, ratio: 0.05 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index RDB$1 (0) 
    Root page: 1504263, depth: 1, leaf buckets: 1, nodes: 20 
    Average node length: 5.20, total dup: 0, max dup: 0 
    Average key length: 4.15, compression ratio: 0.65 
    Average prefix length: 1.10, average data length: 1.60 
    Clustering factor: 1, ratio: 0.05 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
DOC_DATA (139) 
    Primary pointer page: 502, Index root page: 503 
    Total formats: 1, used formats: 1 
    Average record length: 47.68, total records: 7681529 
    Average version length: 48.17, total versions: 42497, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 64.00, compression ratio: 1.34 
    Pointer pages: 55, data page slots: 88800 
    Data pages: 88800, average fill: 69% 
    Primary pages: 88799, secondary pages: 1, swept pages: 47464 
    Empty pages: 14, full pages: 55933 
    Fill distribution: 
     0 - 19% = 32 
    20 - 39% = 58 
    40 - 59% = 2526 
    60 - 79% = 86161 
    80 - 99% = 23 
 
    Index DOC_DATA_DOC_WARE_UNQ (0) 
    Root page: 1510636, depth: 3, leaf buckets: 23119, nodes: 7681529 
    Average node length: 18.86, total dup: 0, max dup: 0 
    Average key length: 15.87, compression ratio: 1.70 
    Average prefix length: 14.12, average data length: 12.88 
    Clustering factor: 1659566, ratio: 0.22 
    Fill distribution: 
         0 - 19% = 314 
        20 - 39% = 2097 
        40 - 59% = 3784 
        60 - 79% = 2513 
        80 - 99% = 14411 
 
    Index DOC_DATA_ID_DESC (1) 
    Root page: 1528140, depth: 3, leaf buckets: 13426, nodes: 7681529 
    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: 1484408, ratio: 0.19 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 1767 
        40 - 59% = 1770 
        60 - 79% = 1166 
        80 - 99% = 8723 
 
    Index FK_DOC_DATA_DOC_LIST (2) 
    Root page: 1546735, depth: 3, leaf buckets: 8275, nodes: 7681529 
    Average node length: 6.60, total dup: 5762580, max dup: 49 
    Average key length: 3.62, compression ratio: 2.49 
    Average prefix length: 7.63, average data length: 1.37 
    Clustering factor: 1477500, ratio: 0.19 
    Fill distribution: 
         0 - 19% = 115 
        20 - 39% = 1088 
        40 - 59% = 1216 
        60 - 79% = 1003 
        80 - 99% = 4853 
 
DOC_LIST (138) 
    Primary pointer page: 500, Index root page: 501 
    Total formats: 1, used formats: 1 
    Average record length: 56.96, total records: 2208416 
    Average version length: 58.88, total versions: 20940, max versions: 2 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 84.00, compression ratio: 1.47 
    Pointer pages: 18, data page slots: 28648 
    Data pages: 28648, average fill: 71% 
    Primary pages: 28647, secondary pages: 1, swept pages: 16254 
    Empty pages: 5, full pages: 12724 
    Fill distribution: 
     0 - 19% = 10 
    20 - 39% = 35 
    40 - 59% = 663 
    60 - 79% = 27906 
    80 - 99% = 34 
 
    Index DOC_LIST_ID_DESC (1) 
    Root page: 1541152, depth: 3, leaf buckets: 4529, nodes: 2208416 
    Average node length: 11.41, total dup: 0, max dup: 0 
    Average key length: 8.45, compression ratio: 1.07 
    Average prefix length: 3.55, average data length: 5.45 
    Clustering factor: 674579, ratio: 0.31 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 1051 
        40 - 59% = 704 
        60 - 79% = 774 
        80 - 99% = 2000 
 
    Index DOC_LIST_WORKER_OPTYPE (2) 
    Root page: 1544398, depth: 3, leaf buckets: 2415, nodes: 2208956 
    Average node length: 4.97, total dup: 2208058, max dup: 19911 
    Average key length: 2.01, compression ratio: 4.47 
    Average prefix length: 8.99, average data length: 0.01 
    Clustering factor: 1253252, ratio: 0.57 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 265 
        40 - 59% = 1385 
        60 - 79% = 510 
        80 - 99% = 253 
 
    Index FK_DOC_LIST_AGENTS (3) 
    Root page: 1545933, depth: 3, leaf buckets: 1773, nodes: 2208416 
    Average node length: 4.97, total dup: 2208366, max dup: 129914 
    Average key length: 2.01, compression ratio: 4.48 
    Average prefix length: 8.99, average data length: 0.01 
    Clustering factor: 1057857, ratio: 0.48 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 2 
        40 - 59% = 625 
        60 - 79% = 41 
        80 - 99% = 1105 
 
    Index PK_DOC_LIST (0) 
    Root page: 1538209, depth: 3, leaf buckets: 4341, nodes: 2208416 
    Average node length: 11.41, total dup: 0, max dup: 0 
    Average key length: 8.45, compression ratio: 1.07 
    Average prefix length: 3.55, average data length: 5.45 
    Clustering factor: 674579, ratio: 0.31 
    Fill distribution: 
         0 - 19% = 108 
        20 - 39% = 696 
        40 - 59% = 538 
        60 - 79% = 874 
        80 - 99% = 2125 
 
DOC_STATES (149) 
    Primary pointer page: 522, Index root page: 523 
    Total formats: 1, used formats: 1 
    Average record length: 67.50, total records: 4 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 650.00, compression ratio: 9.63 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 4% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index DOC_STATES_MCODE_UNQ (1) 
    Root page: 1504337, depth: 1, leaf buckets: 1, nodes: 4 
    Average node length: 17.75, total dup: 0, max dup: 0 
    Average key length: 16.50, compression ratio: 1.08 
    Average prefix length: 4.00, average data length: 13.75 
    Clustering factor: 1, ratio: 0.25 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index DOC_STATES_NAME_UNQ (2) 
    Root page: 1504338, depth: 1, leaf buckets: 1, nodes: 4 
    Average node length: 33.25, total dup: 0, max dup: 0 
    Average key length: 32.00, compression ratio: 0.99 
    Average prefix length: 2.50, average data length: 29.25 
    Clustering factor: 1, ratio: 0.25 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PK_DOC_STATES (0) 
    Root page: 1504336, depth: 1, leaf buckets: 1, nodes: 4 
    Average node length: 4.75, total dup: 0, max dup: 0 
    Average key length: 3.50, compression ratio: 0.86 
    Average prefix length: 1.50, average data length: 1.50 
    Clustering factor: 1, ratio: 0.25 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
FB_ERRORS (155) 
    Primary pointer page: 534, Index root page: 535 
    Total formats: 2, used formats: 2 
    Average record length: 57.88, total records: 2182 
    Average version length: 79.61, total versions: 757, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 270.43, compression ratio: 4.67 
    Pointer pages: 1, data page slots: 40 
    Data pages: 40, average fill: 72% 
    Primary pages: 39, secondary pages: 1, swept pages: 0 
    Empty pages: 4, full pages: 34 
    Fill distribution: 
     0 - 19% = 5 
    20 - 39% = 0 
    40 - 59% = 1 
    60 - 79% = 22 
    80 - 99% = 12 
 
    Index FB_ERRORS_GDS_CODE (0) 
    Root page: 398, depth: 2, leaf buckets: 2, nodes: 2182 
    Average node length: 4.40, total dup: 756, max dup: 1 
    Average key length: 2.67, compression ratio: 1.87 
    Average prefix length: 4.33, average data length: 0.67 
    Clustering factor: 1518, ratio: 0.70 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 0 
        40 - 59% = 1 
        60 - 79% = 1 
        80 - 99% = 0 
 
INVNT_SALDO (145) 
    Primary pointer page: 514, Index root page: 515 
    Total formats: 2, used formats: 1 
    Average record length: 83.14, total records: 400 
    Average version length: 26.37, total versions: 2179, max versions: 6 
    Average fragment length: 2.00, total fragments: 14, max fragments: 1 
    Average unpacked length: 104.00, compression ratio: 1.25 
    Pointer pages: 1, data page slots: 24 
    Data pages: 24, average fill: 69% 
    Primary pages: 11, secondary pages: 13, swept pages: 0 
    Empty pages: 4, full pages: 17 
    Fill distribution: 
     0 - 19% = 5 
    20 - 39% = 1 
    40 - 59% = 1 
    60 - 79% = 1 
    80 - 99% = 16 
 
    Index PK_INVNT_SALDO (0) 
    Root page: 1510371, depth: 1, leaf buckets: 1, nodes: 400 
    Average node length: 11.22, total dup: 0, max dup: 0 
    Average key length: 10.22, compression ratio: 0.88 
    Average prefix length: 1.78, average data length: 7.22 
    Clustering factor: 326, ratio: 0.81 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 0 
        40 - 59% = 1 
        60 - 79% = 0 
        80 - 99% = 0 
 
INVNT_TURNOVER_LOG (153) 
    Primary pointer page: 530, Index root page: 531 
    Total formats: 1, used formats: 1 
    Average record length: 26.36, total records: 92012 
    Average version length: 68.29, total versions: 65094, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 88.00, compression ratio: 3.34 
    Pointer pages: 7, data page slots: 3472 
    Data pages: 1880, average fill: 63% 
    Primary pages: 1879, secondary pages: 1, swept pages: 194 
    Empty pages: 302, full pages: 1133 
    Fill distribution: 
     0 - 19% = 374 
    20 - 39% = 127 
    40 - 59% = 140 
    60 - 79% = 373 
    80 - 99% = 866 
 
    Index INVNT_TURNOVER_LOG_WARE_DD_ID (0) 
    Root page: 1701688, depth: 3, leaf buckets: 351, nodes: 92012 
    Average node length: 13.49, total dup: 7282, max dup: 2 
    Average key length: 10.67, compression ratio: 2.53 
    Average prefix length: 19.25, average data length: 7.75 
    Clustering factor: 66841, ratio: 0.73 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 162 
        40 - 59% = 146 
        60 - 79% = 40 
        80 - 99% = 2 
 
MONEY_SALDO (141) 
    Primary pointer page: 506, Index root page: 507 
    Total formats: 1, used formats: 1 
    Average record length: 15.27, total records: 49 
    Average version length: 9.00, total versions: 200, max versions: 6 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 32.00, compression ratio: 2.10 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 84% 
    Primary pages: 1, 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% = 1 
 
    Index PK_MONEY_SALDO (0) 
    Root page: 1510383, depth: 1, leaf buckets: 1, nodes: 49 
    Average node length: 11.82, total dup: 0, max dup: 0 
    Average key length: 10.80, compression ratio: 0.83 
    Average prefix length: 1.18, average data length: 7.82 
    Clustering factor: 1, ratio: 0.02 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
MONEY_TURNOVER_LOG (140) 
    Primary pointer page: 504, Index root page: 505 
    Total formats: 1, used formats: 1 
    Average record length: 16.18, total records: 1485 
    Average version length: 43.11, total versions: 1191, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 58.00, compression ratio: 3.59 
    Pointer pages: 1, data page slots: 32 
    Data pages: 32, average fill: 47% 
    Primary pages: 31, secondary pages: 1, swept pages: 9 
    Empty pages: 10, full pages: 14 
    Fill distribution: 
     0 - 19% = 11 
    20 - 39% = 4 
    40 - 59% = 2 
    60 - 79% = 2 
    80 - 99% = 13 
 
    Index MONEY_TURNOVER_LOG_AGENT_OPTYPE (0) 
    Root page: 93216, depth: 2, leaf buckets: 2, nodes: 1485 
    Average node length: 4.26, total dup: 1387, max dup: 180 
    Average key length: 2.69, compression ratio: 7.07 
    Average prefix length: 18.38, average data length: 0.62 
    Clustering factor: 810, ratio: 0.55 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 1 
        80 - 99% = 0 
 
MON_CACHE_MEMORY (165) 
    Primary pointer page: 555, Index root page: 556 
    Total formats: 2, used formats: 1 
    Average record length: 97.69, total records: 71 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 112.00, compression ratio: 1.15 
    Pointer pages: 1, data page slots: 2 
    Data pages: 2, average fill: 50% 
    Primary pages: 2, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 1 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 1 
    40 - 59% = 0 
    60 - 79% = 1 
    80 - 99% = 0 
 
    Index PK_MON_CACHE_MEMORY (0) 
    Root page: 1504238, depth: 1, leaf buckets: 1, nodes: 71 
    Average node length: 11.70, total dup: 0, max dup: 0 
    Average key length: 10.69, compression ratio: 0.84 
    Average prefix length: 1.30, average data length: 7.70 
    Clustering factor: 2, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
MON_LOG (162) 
    Primary pointer page: 548, Index root page: 549 
    Total formats: 2, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index MON_LOG_DTS (4) 
    Root page: 1504251, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index MON_LOG_GDSCODE (2) 
    Root page: 1504249, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index MON_LOG_ROWSET_DESC (1) 
    Root page: 1504248, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index MON_LOG_UNIT (3) 
    Root page: 1504250, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PK_MON_LOG (0) 
    Root page: 1504247, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
MON_LOG_TABLE_STATS (163) 
    Primary pointer page: 550, Index root page: 551 
    Total formats: 2, used formats: 1 
    Average record length: 67.13, total records: 30 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 611.00, compression ratio: 9.10 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 31% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 1 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index MON_LOG_TABLE_STATS_DTS (4) 
    Root page: 1504246, depth: 1, leaf buckets: 1, nodes: 30 
    Average node length: 3.50, total dup: 23, max dup: 4 
    Average key length: 2.47, compression ratio: 3.24 
    Average prefix length: 7.53, average data length: 0.47 
    Clustering factor: 1, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index MON_LOG_TABLE_STATS_GDSCODE (2) 
    Root page: 1504244, depth: 1, leaf buckets: 1, nodes: 30 
    Average node length: 2.00, total dup: 29, max dup: 29 
    Average key length: 1.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 1, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index MON_LOG_TABLE_STATS_ROWSET (1) 
    Root page: 1504243, depth: 1, leaf buckets: 1, nodes: 30 
    Average node length: 3.33, total dup: 29, max dup: 29 
    Average key length: 2.30, compression ratio: 3.91 
    Average prefix length: 8.70, average data length: 0.30 
    Clustering factor: 1, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index MON_LOG_TABLE_STATS_TN_UNIT (3) 
    Root page: 1504245, depth: 1, leaf buckets: 1, nodes: 30 
    Average node length: 12.90, total dup: 0, max dup: 0 
    Average key length: 11.87, compression ratio: 1.42 
    Average prefix length: 7.63, average data length: 9.20 
    Clustering factor: 1, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PK_MON_LOG_TABLE_STATS (0) 
    Root page: 1504242, depth: 1, leaf buckets: 1, nodes: 30 
    Average node length: 8.37, total dup: 0, max dup: 0 
    Average key length: 7.33, compression ratio: 1.23 
    Average prefix length: 4.63, average data length: 4.37 
    Clustering factor: 1, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
OPTYPES (136) 
    Primary pointer page: 496, Index root page: 497 
    Total formats: 2, used formats: 1 
    Average record length: 67.56, total records: 9 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 386.00, compression ratio: 5.71 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 9% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index OPTYPES_MCODE_UNQ (1) 
    Root page: 1544827, depth: 1, leaf buckets: 1, nodes: 9 
    Average node length: 8.56, total dup: 0, max dup: 0 
    Average key length: 6.89, compression ratio: 0.73 
    Average prefix length: 0.44, average data length: 4.56 
    Clustering factor: 1, ratio: 0.11 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PK_OPTYPES (0) 
    Root page: 1544826, depth: 1, leaf buckets: 1, nodes: 9 
    Average node length: 6.11, total dup: 0, max dup: 0 
    Average key length: 5.00, compression ratio: 0.60 
    Average prefix length: 0.89, average data length: 2.11 
    Clustering factor: 1, ratio: 0.11 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
PDISTR (146) 
    Primary pointer page: 516, Index root page: 517 
    Total formats: 1, used formats: 1 
    Average record length: 37.25, total records: 797370 
    Average version length: 37.91, total versions: 11148, max versions: 2 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 54.00, compression ratio: 1.45 
    Pointer pages: 6, data page slots: 8640 
    Data pages: 8640, average fill: 63% 
    Primary pages: 8638, secondary pages: 2, swept pages: 4802 
    Empty pages: 20, full pages: 3448 
    Fill distribution: 
     0 - 19% = 37 
    20 - 39% = 56 
    40 - 59% = 1336 
    60 - 79% = 7198 
    80 - 99% = 13 
 
    Index PDISTR_AGENT_ID (2) 
    Root page: 1509330, depth: 2, leaf buckets: 857, nodes: 791824 
    Average node length: 4.88, total dup: 791775, max dup: 145056 
    Average key length: 2.01, compression ratio: 4.48 
    Average prefix length: 8.99, average data length: 0.01 
    Clustering factor: 89629, ratio: 0.11 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 132 
        40 - 59% = 463 
        60 - 79% = 159 
        80 - 99% = 102 
 
    Index PDISTR_SNDOP_RCVOP_SNDID_ASC (0) 
    Root page: 1508635, depth: 3, leaf buckets: 958, nodes: 791824 
    Average node length: 5.89, total dup: 705308, max dup: 42 
    Average key length: 3.01, compression ratio: 7.30 
    Average prefix length: 21.09, average data length: 0.91 
    Clustering factor: 156908, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 44 
        40 - 59% = 561 
        60 - 79% = 100 
        80 - 99% = 252 
 
    Index PDISTR_SNDOP_RCVOP_SNDID_DESC (1) 
    Root page: 1509209, depth: 3, leaf buckets: 985, nodes: 791824 
    Average node length: 5.89, total dup: 705308, max dup: 42 
    Average key length: 3.02, compression ratio: 7.30 
    Average prefix length: 21.09, average data length: 0.91 
    Clustering factor: 158789, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 95 
        40 - 59% = 550 
        60 - 79% = 101 
        80 - 99% = 239 
 
    Index PDISTR_WORKER_SND_ID (3) 
    Root page: 1510200, depth: 3, leaf buckets: 1144, nodes: 791824 
    Average node length: 5.97, total dup: 705308, max dup: 42 
    Average key length: 3.10, compression ratio: 5.49 
    Average prefix length: 16.01, average data length: 0.99 
    Clustering factor: 151332, ratio: 0.19 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 263 
        40 - 59% = 616 
        60 - 79% = 178 
        80 - 99% = 85 
 
PERF_AGG (158) 
    Primary pointer page: 540, Index root page: 541 
    Total formats: 1, used formats: 1 
    Average record length: 62.77, total records: 5425 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 4.00, total fragments: 3, max fragments: 1 
    Average unpacked length: 379.00, compression ratio: 6.04 
    Pointer pages: 1, data page slots: 96 
    Data pages: 94, average fill: 57% 
    Primary pages: 77, secondary pages: 17, swept pages: 62 
    Empty pages: 18, full pages: 67 
    Fill distribution: 
     0 - 19% = 20 
    20 - 39% = 1 
    40 - 59% = 2 
    60 - 79% = 71 
    80 - 99% = 0 
 
    Index PERF_AGG_UNQ (1) 
    Root page: 1504260, depth: 2, leaf buckets: 6, nodes: 5425 
    Average node length: 5.51, total dup: 0, max dup: 0 
    Average key length: 3.59, compression ratio: 10.02 
    Average prefix length: 34.41, average data length: 1.55 
    Clustering factor: 5112, ratio: 0.94 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 0 
        40 - 59% = 4 
        60 - 79% = 1 
        80 - 99% = 1 
 
    Index PK_PERF_AGG (0) 
    Root page: 1504255, depth: 2, leaf buckets: 10, nodes: 5425 
    Average node length: 11.13, 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: 157, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 1 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 7 
 
PERF_ESTIMATED (280) 
    Primary pointer page: 399, Index root page: 434 
    Total formats: 1, used formats: 1 
    Average record length: 39.08, total records: 76207 
    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: 800 
    Data pages: 800, average fill: 65% 
    Primary pages: 800, secondary pages: 0, swept pages: 0 
    Empty pages: 7, full pages: 792 
    Fill distribution: 
     0 - 19% = 8 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 792 
    80 - 99% = 0 
 
    Index PK_PERF_ESTIMATED (0) 
    Root page: 36576, depth: 2, leaf buckets: 98, nodes: 76207 
    Average node length: 10.17, total dup: 0, max dup: 0 
    Average key length: 8.18, compression ratio: 1.10 
    Average prefix length: 3.81, average data length: 5.19 
    Clustering factor: 2986, ratio: 0.04 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 1 
        60 - 79% = 1 
        80 - 99% = 95 
 
PERF_ISQL_STAT (156) 
    Primary pointer page: 536, Index root page: 537 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index PERF_ISQL_STAT_TRN (0) 
    Root page: 1504261, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
PERF_LOG (159) 
    Primary pointer page: 542, Index root page: 543 
    Total formats: 1, used formats: 1 
    Average record length: 110.63, total records: 71 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1691.00, compression ratio: 15.28 
    Pointer pages: 1, data page slots: 2 
    Data pages: 2, average fill: 56% 
    Primary pages: 2, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 1 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 1 
    40 - 59% = 0 
    60 - 79% = 1 
    80 - 99% = 0 
 
PERF_SPLIT_0 (281) 
    Primary pointer page: 601, Index root page: 602 
    Total formats: 1, used formats: 1 
    Average record length: 128.89, total records: 191087 
    Average version length: 154.25, total versions: 29817, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 13.16 
    Pointer pages: 8, data page slots: 5448 
    Data pages: 4792, average fill: 84% 
    Primary pages: 4790, secondary pages: 2, swept pages: 2 
    Empty pages: 72, full pages: 4682 
    Fill distribution: 
     0 - 19% = 79 
    20 - 39% = 5 
    40 - 59% = 18 
    60 - 79% = 10 
    80 - 99% = 4680 
 
PERF_SPLIT_1 (282) 
    Primary pointer page: 603, Index root page: 604 
    Total formats: 1, used formats: 1 
    Average record length: 130.83, total records: 176723 
    Average version length: 153.77, total versions: 25340, 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: 5896 
    Data pages: 4416, average fill: 84% 
    Primary pages: 4414, secondary pages: 2, swept pages: 3 
    Empty pages: 58, full pages: 4338 
    Fill distribution: 
     0 - 19% = 59 
    20 - 39% = 5 
    40 - 59% = 4 
    60 - 79% = 10 
    80 - 99% = 4338 
 
PERF_SPLIT_2 (283) 
    Primary pointer page: 605, Index root page: 606 
    Total formats: 1, used formats: 1 
    Average record length: 128.87, total records: 161235 
    Average version length: 153.92, total versions: 25180, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 13.16 
    Pointer pages: 6, data page slots: 4984 
    Data pages: 4024, average fill: 85% 
    Primary pages: 4020, secondary pages: 4, swept pages: 1 
    Empty pages: 49, full pages: 3957 
    Fill distribution: 
     0 - 19% = 50 
    20 - 39% = 7 
    40 - 59% = 2 
    60 - 79% = 8 
    80 - 99% = 3957 
 
PERF_SPLIT_3 (284) 
    Primary pointer page: 607, Index root page: 608 
    Total formats: 1, used formats: 1 
    Average record length: 138.87, total records: 195951 
    Average version length: 153.65, total versions: 17392, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 12.21 
    Pointer pages: 7, data page slots: 5440 
    Data pages: 4928, average fill: 83% 
    Primary pages: 4926, secondary pages: 2, swept pages: 1 
    Empty pages: 85, full pages: 4810 
    Fill distribution: 
     0 - 19% = 89 
    20 - 39% = 8 
    40 - 59% = 9 
    60 - 79% = 12 
    80 - 99% = 4810 
 
PERF_SPLIT_4 (285) 
    Primary pointer page: 609, Index root page: 610 
    Total formats: 1, used formats: 1 
    Average record length: 140.05, total records: 166959 
    Average version length: 151.98, total versions: 13069, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 12.11 
    Pointer pages: 7, data page slots: 5120 
    Data pages: 4176, average fill: 83% 
    Primary pages: 4174, secondary pages: 2, swept pages: 1 
    Empty pages: 57, full pages: 4090 
    Fill distribution: 
     0 - 19% = 61 
    20 - 39% = 10 
    40 - 59% = 9 
    60 - 79% = 5 
    80 - 99% = 4091 
 
PERF_SPLIT_5 (286) 
    Primary pointer page: 611, Index root page: 612 
    Total formats: 1, used formats: 1 
    Average record length: 139.41, total records: 173969 
    Average version length: 152.38, total versions: 14361, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 12.17 
    Pointer pages: 8, data page slots: 5816 
    Data pages: 4352, average fill: 83% 
    Primary pages: 4350, secondary pages: 2, swept pages: 2 
    Empty pages: 50, full pages: 4250 
    Fill distribution: 
     0 - 19% = 50 
    20 - 39% = 20 
    40 - 59% = 26 
    60 - 79% = 5 
    80 - 99% = 4251 
 
PERF_SPLIT_6 (287) 
    Primary pointer page: 613, Index root page: 614 
    Total formats: 1, used formats: 1 
    Average record length: 142.50, total records: 152602 
    Average version length: 150.69, total versions: 8868, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.90 
    Pointer pages: 5, data page slots: 4952 
    Data pages: 3896, average fill: 81% 
    Primary pages: 3894, secondary pages: 2, swept pages: 3 
    Empty pages: 133, full pages: 3718 
    Fill distribution: 
     0 - 19% = 140 
    20 - 39% = 10 
    40 - 59% = 15 
    60 - 79% = 12 
    80 - 99% = 3719 
 
PERF_SPLIT_7 (288) 
    Primary pointer page: 615, Index root page: 616 
    Total formats: 1, used formats: 1 
    Average record length: 138.36, total records: 170092 
    Average version length: 152.97, total versions: 15257, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 12.26 
    Pointer pages: 9, data page slots: 5792 
    Data pages: 4272, average fill: 83% 
    Primary pages: 4270, secondary pages: 2, swept pages: 3 
    Empty pages: 78, full pages: 4166 
    Fill distribution: 
     0 - 19% = 81 
    20 - 39% = 10 
    40 - 59% = 6 
    60 - 79% = 7 
    80 - 99% = 4168 
 
PERF_SPLIT_8 (289) 
    Primary pointer page: 617, Index root page: 618 
    Total formats: 1, used formats: 1 
    Average record length: 111.62, total records: 207681 
    Average version length: 154.59, total versions: 57589, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 15.19 
    Pointer pages: 6, data page slots: 5400 
    Data pages: 5160, average fill: 87% 
    Primary pages: 5158, secondary pages: 2, swept pages: 2 
    Empty pages: 31, full pages: 5109 
    Fill distribution: 
     0 - 19% = 34 
    20 - 39% = 2 
    40 - 59% = 6 
    60 - 79% = 9 
    80 - 99% = 5109 
 
PERF_SPLIT_9 (290) 
    Primary pointer page: 619, Index root page: 620 
    Total formats: 1, used formats: 1 
    Average record length: 144.37, total records: 164862 
    Average version length: 150.57, total versions: 8098, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.75 
    Pointer pages: 9, data page slots: 5696 
    Data pages: 4144, average fill: 83% 
    Primary pages: 4142, secondary pages: 2, swept pages: 1 
    Empty pages: 75, full pages: 4036 
    Fill distribution: 
     0 - 19% = 76 
    20 - 39% = 10 
    40 - 59% = 13 
    60 - 79% = 8 
    80 - 99% = 4037 
 
PHRASES (143) 
    Primary pointer page: 510, Index root page: 511 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index PHRASES_ID_DESC (3) 
    Root page: 1510376, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PHRASES_NAME (2) 
    Root page: 1510375, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PHRASES_UNQ (1) 
    Root page: 1510374, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PK_PHRASES (0) 
    Root page: 1510373, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
PSTORNED (147) 
    Primary pointer page: 518, Index root page: 519 
    Total formats: 1, used formats: 1 
    Average record length: 52.24, total records: 2070516 
    Average version length: 53.00, total versions: 23938, 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: 25616 
    Data pages: 25616, average fill: 70% 
    Primary pages: 25600, secondary pages: 16, swept pages: 12454 
    Empty pages: 148, full pages: 20945 
    Fill distribution: 
     0 - 19% = 336 
    20 - 39% = 336 
    40 - 59% = 1119 
    60 - 79% = 23599 
    80 - 99% = 226 
 
    Index PSTORNED_RCV_ID (1) 
    Root page: 1506208, depth: 3, leaf buckets: 2549, nodes: 2070516 
    Average node length: 5.44, total dup: 1931398, max dup: 1421 
    Average key length: 2.49, compression ratio: 3.62 
    Average prefix length: 8.58, average data length: 0.42 
    Clustering factor: 180026, ratio: 0.09 
    Fill distribution: 
         0 - 19% = 5 
        20 - 39% = 303 
        40 - 59% = 1654 
        60 - 79% = 285 
        80 - 99% = 302 
 
    Index PSTORNED_SND_ID (0) 
    Root page: 1504841, depth: 3, leaf buckets: 2752, nodes: 2070516 
    Average node length: 5.70, total dup: 1857757, max dup: 71 
    Average key length: 2.74, compression ratio: 3.28 
    Average prefix length: 8.36, average data length: 0.64 
    Clustering factor: 370726, ratio: 0.18 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 4 
        40 - 59% = 2487 
        60 - 79% = 234 
        80 - 99% = 27 
 
    Index PSTORNED_WORKER_ID (2) 
    Root page: 1508018, depth: 3, leaf buckets: 2097, nodes: 2070516 
    Average node length: 4.96, total dup: 2070416, max dup: 28685 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.41, average data length: 0.00 
    Clustering factor: 177906, ratio: 0.09 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 186 
        40 - 59% = 1111 
        60 - 79% = 373 
        80 - 99% = 426 
 
RULES_FOR_PDISTR (148) 
    Primary pointer page: 520, Index root page: 521 
    Total formats: 1, used formats: 1 
    Average record length: 17.00, total records: 4 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 334.00, compression ratio: 19.65 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 2% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index RULES_FOR_PDISTR_UNQ (0) 
    Root page: 1504339, depth: 1, leaf buckets: 1, nodes: 4 
    Average node length: 11.50, total dup: 0, max dup: 0 
    Average key length: 10.25, compression ratio: 0.88 
    Average prefix length: 1.50, average data length: 7.50 
    Clustering factor: 1, ratio: 0.25 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
RULES_FOR_QDISTR (137) 
    Primary pointer page: 498, Index root page: 499 
    Total formats: 1, used formats: 1 
    Average record length: 32.71, total records: 7 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 332.00, compression ratio: 10.15 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 4% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index RULES_FOR_QDISTR_RCVOP (1) 
    Root page: 1544825, depth: 1, leaf buckets: 1, nodes: 7 
    Average node length: 5.29, total dup: 2, max dup: 2 
    Average key length: 4.14, compression ratio: 0.72 
    Average prefix length: 1.43, average data length: 1.57 
    Clustering factor: 1, ratio: 0.14 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index RULES_FOR_QDISTR_UNQ (0) 
    Root page: 1544824, depth: 1, leaf buckets: 1, nodes: 7 
    Average node length: 10.14, total dup: 0, max dup: 0 
    Average key length: 8.86, compression ratio: 0.94 
    Average prefix length: 2.14, average data length: 6.14 
    Clustering factor: 1, ratio: 0.14 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
SEMAPHORES (152) 
    Primary pointer page: 528, Index root page: 529 
    Total formats: 1, used formats: 1 
    Average record length: 43.40, total records: 5 
    Average version length: 9.00, total versions: 1, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 346.00, compression ratio: 7.97 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 4% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index PK_SEMAPHORES (0) 
    Root page: 1504327, depth: 1, leaf buckets: 1, nodes: 5 
    Average node length: 12.40, total dup: 0, max dup: 0 
    Average key length: 11.00, compression ratio: 0.82 
    Average prefix length: 0.60, average data length: 8.40 
    Clustering factor: 1, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index SEMAPHORES_TASK_UNQ (1) 
    Root page: 1504328, depth: 1, leaf buckets: 1, nodes: 5 
    Average node length: 23.40, total dup: 0, max dup: 0 
    Average key length: 22.00, compression ratio: 1.07 
    Average prefix length: 4.20, average data length: 19.40 
    Clustering factor: 1, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
SETTINGS (135) 
    Primary pointer page: 494, Index root page: 495 
    Total formats: 1, used formats: 1 
    Average record length: 97.62, total records: 149 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1347.00, compression ratio: 13.80 
    Pointer pages: 1, data page slots: 3 
    Data pages: 3, average fill: 70% 
    Primary pages: 3, secondary pages: 0, swept pages: 1 
    Empty pages: 0, full pages: 2 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 1 
    60 - 79% = 0 
    80 - 99% = 2 
 
    Index SETTINGS_MCODE_WM_UNQ (1) 
    Root page: 1544931, depth: 1, leaf buckets: 1, nodes: 149 
    Average node length: 14.66, total dup: 0, max dup: 0 
    Average key length: 13.55, compression ratio: 2.19 
    Average prefix length: 19.07, average data length: 10.66 
    Clustering factor: 48, ratio: 0.32 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 1 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index SETTINGS_MODE_CODE (0) 
    Root page: 1544828, depth: 1, leaf buckets: 1, nodes: 149 
    Average node length: 25.56, total dup: 0, max dup: 0 
    Average key length: 24.56, compression ratio: 1.63 
    Average prefix length: 18.58, average data length: 21.56 
    Clustering factor: 14, ratio: 0.09 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 0 
        40 - 59% = 1 
        60 - 79% = 0 
        80 - 99% = 0 
 
TMP$DEP_DOCS (129) 
    Primary pointer page: 482, Index root page: 483 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index TMP_DEP_DOCS_UNQ (0) 
    Root page: 1544832, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
TMP$IDX_RECALC (132) 
    Primary pointer page: 488, Index root page: 489 
    Total formats: 2, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index TMP_IDX_RECALC_IDX_NAME_UNQ (0) 
    Root page: 1544829, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
TMP$MON_LOG (133) 
    Primary pointer page: 490, Index root page: 491 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
TMP$MON_LOG_TABLE_STATS (134) 
    Primary pointer page: 492, Index root page: 493 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
TMP$PERF_EST_WHOLE (161) 
    Primary pointer page: 546, Index root page: 547 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
TMP$PERF_LOG (160) 
    Primary pointer page: 544, Index root page: 545 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index TMP$PERF_LOG_UNIT_TRN_DTS_END (0) 
    Root page: 1504252, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
TMP$PERF_MON (131) 
    Primary pointer page: 486, Index root page: 487 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
TMP$RESULT_SET (130) 
    Primary pointer page: 484, Index root page: 485 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index TMP_RESULT_SET_DOC (1) 
    Root page: 1544831, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index TMP_RESULT_SET_WARE_DOC (0) 
    Root page: 1544830, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
TMP$SHOPPING_CART (128) 
    Primary pointer page: 480, Index root page: 481 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index TMP_SHOPCART_UNQ (0) 
    Root page: 1544833, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
TPAUSE (166) 
    Primary pointer page: 557, Index root page: 558 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index RDB$PRIMARY2 (0) 
    Root page: 1504237, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
TRACE_STAT (157) 
    Primary pointer page: 538, Index root page: 539 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
WARES (142) 
    Primary pointer page: 508, Index root page: 509 
    Total formats: 1, used formats: 1 
    Average record length: 77.52, total records: 400 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 444.00, compression ratio: 5.73 
    Pointer pages: 1, data page slots: 6 
    Data pages: 6, average fill: 77% 
    Primary pages: 6, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 5 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 5 
    80 - 99% = 1 
 
    Index FK_WARES_WARE_GROUPS (3) 
    Root page: 1552183, depth: 1, leaf buckets: 1, nodes: 400 
    Average node length: 3.17, total dup: 392, max dup: 60 
    Average key length: 2.16, compression ratio: 4.16 
    Average prefix length: 8.86, average data length: 0.14 
    Clustering factor: 48, ratio: 0.12 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PK_WARES (0) 
    Root page: 1510377, depth: 1, leaf buckets: 1, nodes: 400 
    Average node length: 11.22, total dup: 0, max dup: 0 
    Average key length: 10.22, compression ratio: 0.88 
    Average prefix length: 1.78, average data length: 7.22 
    Clustering factor: 344, ratio: 0.86 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 0 
        40 - 59% = 1 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index WARES_ID_DESC (2) 
    Root page: 1510382, depth: 1, leaf buckets: 1, nodes: 400 
    Average node length: 11.22, total dup: 0, max dup: 0 
    Average key length: 10.22, compression ratio: 0.88 
    Average prefix length: 1.78, average data length: 7.22 
    Clustering factor: 344, ratio: 0.86 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 0 
        40 - 59% = 1 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index WARES_NUMB_UNQ (1) 
    Root page: 1510380, depth: 2, leaf buckets: 3, nodes: 400 
    Average node length: 53.25, total dup: 0, max dup: 0 
    Average key length: 52.23, compression ratio: 1.00 
    Average prefix length: 2.74, average data length: 49.25 
    Clustering factor: 355, ratio: 0.89 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 1 
        80 - 99% = 2 
 
WARE_GROUPS (151) 
    Primary pointer page: 526, Index root page: 527 
    Total formats: 1, used formats: 1 
    Average record length: 32.12, total records: 8 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 346.00, compression ratio: 10.77 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 5% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index PK_WARE_GROUPS (0) 
    Root page: 1504329, depth: 1, leaf buckets: 1, nodes: 8 
    Average node length: 11.25, total dup: 0, max dup: 0 
    Average key length: 10.12, compression ratio: 0.89 
    Average prefix length: 1.75, average data length: 7.25 
    Clustering factor: 1, ratio: 0.12 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index WARE_GROUPS_NAME_UNQ (1) 
    Root page: 1504330, depth: 1, leaf buckets: 1, nodes: 8 
    Average node length: 19.88, total dup: 0, max dup: 0 
    Average key length: 18.12, compression ratio: 0.89 
    Average prefix length: 0.25, average data length: 15.88 
    Clustering factor: 1, ratio: 0.12 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
XQD_1000_1200 (176) 
    Primary pointer page: 577, Index root page: 578 
    Total formats: 1, used formats: 1 
    Average record length: 54.18, total records: 104593 
    Average version length: 69.17, total versions: 26099, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 2.33 
    Pointer pages: 3, data page slots: 4104 
    Data pages: 2672, average fill: 46% 
    Primary pages: 2671, secondary pages: 1, swept pages: 537 
    Empty pages: 250, full pages: 319 
    Fill distribution: 
     0 - 19% = 409 
    20 - 39% = 490 
    40 - 59% = 980 
    60 - 79% = 696 
    80 - 99% = 97 
 
    Index XQD_1000_1200_WA_SO_RO_WKR_SND (0) 
    Root page: 1555179, depth: 3, leaf buckets: 201, nodes: 104593 
    Average node length: 6.58, total dup: 90869, max dup: 14 
    Average key length: 4.04, compression ratio: 10.39 
    Average prefix length: 40.09, average data length: 1.91 
    Clustering factor: 18350, ratio: 0.18 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 95 
        40 - 59% = 87 
        60 - 79% = 18 
        80 - 99% = 1 
 
XQD_1000_3300 (178) 
    Primary pointer page: 581, Index root page: 582 
    Total formats: 1, used formats: 1 
    Average record length: 67.92, total records: 6858636 
    Average version length: 68.83, total versions: 117088, 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: 66, data page slots: 107272 
    Data pages: 106912, average fill: 68% 
    Primary pages: 106911, secondary pages: 1, swept pages: 68870 
    Empty pages: 39, full pages: 36922 
    Fill distribution: 
     0 - 19% = 112 
    20 - 39% = 730 
    40 - 59% = 11942 
    60 - 79% = 93938 
    80 - 99% = 190 
 
    Index XQD_1000_3300_WA_SO_RO_WKR_SND (0) 
    Root page: 1480476, depth: 3, leaf buckets: 10725, nodes: 6858636 
    Average node length: 6.51, total dup: 5932451, max dup: 29 
    Average key length: 3.52, compression ratio: 11.92 
    Average prefix length: 40.61, average data length: 1.39 
    Clustering factor: 1599300, ratio: 0.23 
    Fill distribution: 
         0 - 19% = 11 
        20 - 39% = 1881 
        40 - 59% = 6111 
        60 - 79% = 2391 
        80 - 99% = 331 
 
    Index XQD_1000_3300_WKR_DOC_ASC (1) 
    Root page: 1486090, depth: 3, leaf buckets: 8513, nodes: 6858636 
    Average node length: 5.40, total dup: 6582475, max dup: 154 
    Average key length: 2.41, compression ratio: 7.05 
    Average prefix length: 16.63, average data length: 0.37 
    Clustering factor: 1416412, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 6 
        20 - 39% = 1357 
        40 - 59% = 4885 
        60 - 79% = 1375 
        80 - 99% = 890 
 
    Index XQD_1000_3300_WKR_DOC_DEC (2) 
    Root page: 1490630, depth: 3, leaf buckets: 8616, nodes: 6858636 
    Average node length: 5.40, total dup: 6582475, max dup: 154 
    Average key length: 2.41, compression ratio: 7.05 
    Average prefix length: 16.63, average data length: 0.37 
    Clustering factor: 1418701, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 8 
        20 - 39% = 1461 
        40 - 59% = 4905 
        60 - 79% = 1382 
        80 - 99% = 860 
 
XQD_1200_2000 (177) 
    Primary pointer page: 579, Index root page: 580 
    Total formats: 1, used formats: 1 
    Average record length: 68.35, total records: 11950732 
    Average version length: 68.72, total versions: 117175, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.84 
    Pointer pages: 108, data page slots: 176192 
    Data pages: 176192, average fill: 72% 
    Primary pages: 176190, secondary pages: 2, swept pages: 110815 
    Empty pages: 12, full pages: 119557 
    Fill distribution: 
     0 - 19% = 54 
    20 - 39% = 630 
    40 - 59% = 7791 
    60 - 79% = 167097 
    80 - 99% = 620 
 
    Index XQD_1200_2000_WA_SO_RO_WKR_SND (0) 
    Root page: 1495050, depth: 3, leaf buckets: 18343, nodes: 11949461 
    Average node length: 6.62, total dup: 10417639, max dup: 51 
    Average key length: 3.43, compression ratio: 12.26 
    Average prefix length: 40.70, average data length: 1.30 
    Clustering factor: 2435087, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 31 
        20 - 39% = 2319 
        40 - 59% = 10701 
        60 - 79% = 4569 
        80 - 99% = 723 
 
XQD_2000_3300 (179) 
    Primary pointer page: 583, Index root page: 584 
    Total formats: 1, used formats: 1 
    Average record length: 54.35, total records: 1253369 
    Average version length: 69.00, total versions: 162151, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 2.32 
    Pointer pages: 26, data page slots: 41256 
    Data pages: 29327, average fill: 44% 
    Primary pages: 29251, secondary pages: 76, swept pages: 15686 
    Empty pages: 5590, full pages: 11873 
    Fill distribution: 
     0 - 19% = 8549 
    20 - 39% = 4641 
    40 - 59% = 3457 
    60 - 79% = 10578 
    80 - 99% = 2102 
 
    Index XQD_2000_3300_WA_SO_RO_WKR_SND (0) 
    Root page: 1479735, depth: 3, leaf buckets: 1839, nodes: 1107214 
    Average node length: 5.55, total dup: 1062159, max dup: 49 
    Average key length: 2.59, compression ratio: 16.23 
    Average prefix length: 41.45, average data length: 0.55 
    Clustering factor: 78546, ratio: 0.07 
    Fill distribution: 
         0 - 19% = 11 
        20 - 39% = 879 
        40 - 59% = 789 
        60 - 79% = 150 
        80 - 99% = 10 
 
XQD_2100_3300 (180) 
    Primary pointer page: 585, Index root page: 586 
    Total formats: 1, used formats: 1 
    Average record length: 52.37, total records: 878518 
    Average version length: 69.02, total versions: 48903, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 2.41 
    Pointer pages: 23, data page slots: 36312 
    Data pages: 29775, average fill: 29% 
    Primary pages: 29774, secondary pages: 1, swept pages: 13713 
    Empty pages: 6758, full pages: 1099 
    Fill distribution: 
     0 - 19% = 11525 
    20 - 39% = 7436 
    40 - 59% = 8140 
    60 - 79% = 2659 
    80 - 99% = 15 
 
    Index XQD_2100_3300_WA_SO_RO_WKR_SND (0) 
    Root page: 1479229, depth: 3, leaf buckets: 1159, nodes: 683900 
    Average node length: 5.92, total dup: 632244, max dup: 51 
    Average key length: 2.98, compression ratio: 14.09 
    Average prefix length: 41.09, average data length: 0.91 
    Clustering factor: 94212, ratio: 0.14 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 474 
        40 - 59% = 560 
        60 - 79% = 122 
        80 - 99% = 3 
 
XQD_3300_3400 (181) 
    Primary pointer page: 587, Index root page: 588 
    Total formats: 1, used formats: 1 
    Average record length: 67.35, total records: 8910118 
    Average version length: 68.98, total versions: 226199, 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: 88, data page slots: 142344 
    Data pages: 142328, average fill: 67% 
    Primary pages: 142310, secondary pages: 18, swept pages: 72794 
    Empty pages: 199, full pages: 55155 
    Fill distribution: 
     0 - 19% = 690 
    20 - 39% = 3901 
    40 - 59% = 22826 
    60 - 79% = 113745 
    80 - 99% = 1166 
 
    Index XQD_3300_3400_WA_SO_RO_WKR_SND (0) 
    Root page: 1472612, depth: 3, leaf buckets: 13461, nodes: 8907843 
    Average node length: 6.68, total dup: 7387602, max dup: 29 
    Average key length: 3.67, compression ratio: 11.44 
    Average prefix length: 40.50, average data length: 1.50 
    Clustering factor: 2018821, ratio: 0.23 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 1593 
        40 - 59% = 7158 
        60 - 79% = 4279 
        80 - 99% = 429 
 
XQS_1000_1200 (182) 
    Primary pointer page: 589, Index root page: 590 
    Total formats: 1, used formats: 1 
    Average record length: 82.52, total records: 21093009 
    Average version length: 82.89, total versions: 5228, 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: 318984 
    Data pages: 318984, average fill: 81% 
    Primary pages: 318980, secondary pages: 4, swept pages: 12944 
    Empty pages: 51, full pages: 317899 
    Fill distribution: 
     0 - 19% = 84 
    20 - 39% = 61 
    40 - 59% = 145 
    60 - 79% = 47959 
    80 - 99% = 270735 
 
    Index XQS_1000_1200_DOC_ID (1) 
    Root page: 1426738, depth: 3, leaf buckets: 19171, nodes: 21093009 
    Average node length: 5.72, total dup: 20613365, max dup: 128 
    Average key length: 2.16, compression ratio: 4.16 
    Average prefix length: 8.86, average data length: 0.14 
    Clustering factor: 3273670, ratio: 0.16 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 0 
        40 - 59% = 7815 
        60 - 79% = 533 
        80 - 99% = 10821 
 
    Index XQS_1000_1200_RCV_ID (3) 
    Root page: 1457002, depth: 3, leaf buckets: 17110, nodes: 21093009 
    Average node length: 6.31, total dup: 18535936, max dup: 49 
    Average key length: 2.75, compression ratio: 3.27 
    Average prefix length: 8.37, average data length: 0.63 
    Clustering factor: 914994, ratio: 0.04 
    Fill distribution: 
         0 - 19% = 3 
        20 - 39% = 3 
        40 - 59% = 746 
        60 - 79% = 271 
        80 - 99% = 16087 
 
    Index XQS_1000_1200_SND_ID (2) 
    Root page: 1441095, depth: 3, leaf buckets: 20981, nodes: 21093009 
    Average node length: 6.35, total dup: 18455537, max dup: 29 
    Average key length: 2.79, compression ratio: 3.23 
    Average prefix length: 8.34, average data length: 0.66 
    Clustering factor: 3567550, ratio: 0.17 
    Fill distribution: 
         0 - 19% = 7 
        20 - 39% = 0 
        40 - 59% = 8162 
        60 - 79% = 555 
        80 - 99% = 12257 
 
    Index XQS_1000_1200_WORKER_ID (0) 
    Root page: 1413370, depth: 3, leaf buckets: 15956, nodes: 21093009 
    Average node length: 5.56, total dup: 21092909, max dup: 229514 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.42, average data length: 0.00 
    Clustering factor: 943723, ratio: 0.04 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 12 
        40 - 59% = 2710 
        60 - 79% = 326 
        80 - 99% = 12908 
 
XQS_1000_3300 (184) 
    Primary pointer page: 593, Index root page: 594 
    Total formats: 1, used formats: 1 
    Average record length: 78.21, total records: 9690332 
    Average version length: 82.53, total versions: 554345, max versions: 1 
    Average fragment length: 73.00, total fragments: 2, max fragments: 1 
    Average unpacked length: 126.00, compression ratio: 1.61 
    Pointer pages: 103, data page slots: 167424 
    Data pages: 167376, average fill: 72% 
    Primary pages: 167350, secondary pages: 26, swept pages: 68025 
    Empty pages: 218, full pages: 105255 
    Fill distribution: 
     0 - 19% = 744 
    20 - 39% = 3343 
    40 - 59% = 18526 
    60 - 79% = 118095 
    80 - 99% = 26668 
 
    Index XQS_1000_3300_DOC_ID (1) 
    Root page: 1367524, depth: 3, leaf buckets: 11332, nodes: 9690332 
    Average node length: 5.36, total dup: 9381424, max dup: 197 
    Average key length: 2.23, compression ratio: 4.03 
    Average prefix length: 8.80, average data length: 0.20 
    Clustering factor: 2227047, ratio: 0.23 
    Fill distribution: 
         0 - 19% = 4 
        20 - 39% = 32 
        40 - 59% = 8201 
        60 - 79% = 2974 
        80 - 99% = 121 
 
    Index XQS_1000_3300_RCV_ID (3) 
    Root page: 1379283, depth: 3, leaf buckets: 13552, nodes: 9690332 
    Average node length: 6.23, total dup: 8032892, max dup: 14 
    Average key length: 3.10, compression ratio: 2.90 
    Average prefix length: 8.07, average data length: 0.93 
    Clustering factor: 1584943, ratio: 0.16 
    Fill distribution: 
         0 - 19% = 131 
        20 - 39% = 3954 
        40 - 59% = 4449 
        60 - 79% = 2676 
        80 - 99% = 2342 
 
    Index XQS_1000_3300_SND_ID (2) 
    Root page: 1373081, depth: 3, leaf buckets: 12648, nodes: 9690332 
    Average node length: 5.98, total dup: 8410439, max dup: 44 
    Average key length: 2.85, compression ratio: 3.16 
    Average prefix length: 8.28, average data length: 0.72 
    Clustering factor: 2414159, ratio: 0.25 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 42 
        40 - 59% = 9172 
        60 - 79% = 3289 
        80 - 99% = 144 
 
    Index XQS_1000_3300_WORKER_ID (0) 
    Root page: 1362789, depth: 3, leaf buckets: 10065, nodes: 9690332 
    Average node length: 5.13, total dup: 9690232, max dup: 159036 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.42, average data length: 0.00 
    Clustering factor: 1614324, ratio: 0.17 
    Fill distribution: 
         0 - 19% = 43 
        20 - 39% = 1256 
        40 - 59% = 4844 
        60 - 79% = 1754 
        80 - 99% = 2168 
 
XQS_1200_2000 (183) 
    Primary pointer page: 591, Index root page: 592 
    Total formats: 1, used formats: 1 
    Average record length: 80.84, total records: 11046934 
    Average version length: 82.51, total versions: 218253, max versions: 1 
    Average fragment length: 71.00, total fragments: 1, max fragments: 1 
    Average unpacked length: 126.00, compression ratio: 1.56 
    Pointer pages: 118, data page slots: 191664 
    Data pages: 190168, average fill: 71% 
    Primary pages: 190042, secondary pages: 126, swept pages: 74608 
    Empty pages: 3065, full pages: 140332 
    Fill distribution: 
     0 - 19% = 5191 
    20 - 39% = 7714 
    40 - 59% = 18813 
    60 - 79% = 96061 
    80 - 99% = 62389 
 
    Index XQS_1200_2000_DOC_ID (1) 
    Root page: 1392123, depth: 3, leaf buckets: 13123, nodes: 11046934 
    Average node length: 5.30, total dup: 10937833, max dup: 642 
    Average key length: 2.08, compression ratio: 4.32 
    Average prefix length: 8.93, average data length: 0.07 
    Clustering factor: 2313807, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 177 
        40 - 59% = 9846 
        60 - 79% = 3011 
        80 - 99% = 89 
 
    Index XQS_1200_2000_RCV_ID (3) 
    Root page: 1406132, depth: 3, leaf buckets: 10221, nodes: 11046934 
    Average node length: 5.49, total dup: 10562726, max dup: 49 
    Average key length: 2.28, compression ratio: 3.95 
    Average prefix length: 8.77, average data length: 0.23 
    Clustering factor: 711587, ratio: 0.06 
    Fill distribution: 
         0 - 19% = 156 
        20 - 39% = 895 
        40 - 59% = 2439 
        60 - 79% = 1792 
        80 - 99% = 4939 
 
    Index XQS_1200_2000_SND_ID (2) 
    Root page: 1398660, depth: 3, leaf buckets: 15012, nodes: 11046934 
    Average node length: 6.02, total dup: 9633024, max dup: 64 
    Average key length: 2.81, compression ratio: 3.20 
    Average prefix length: 8.32, average data length: 0.68 
    Clustering factor: 2330124, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 3 
        20 - 39% = 209 
        40 - 59% = 11422 
        60 - 79% = 3265 
        80 - 99% = 113 
 
    Index XQS_1200_2000_WORKER_ID (0) 
    Root page: 1386233, depth: 3, leaf buckets: 10534, nodes: 11046934 
    Average node length: 5.22, total dup: 11046834, max dup: 194499 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.42, average data length: 0.00 
    Clustering factor: 700341, ratio: 0.06 
    Fill distribution: 
         0 - 19% = 107 
        20 - 39% = 883 
        40 - 59% = 4591 
        60 - 79% = 1461 
        80 - 99% = 3492 
 
XQS_2000_3300 (185) 
    Primary pointer page: 595, Index root page: 596 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index XQS_2000_3300_DOC_ID (1) 
    Root page: 1361775, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index XQS_2000_3300_RCV_ID (3) 
    Root page: 1361777, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index XQS_2000_3300_SND_ID (2) 
    Root page: 1361776, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index XQS_2000_3300_WORKER_ID (0) 
    Root page: 1361774, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
XQS_2100_3300 (186) 
    Primary pointer page: 597, Index root page: 598 
    Total formats: 1, used formats: 1 
    Average record length: 75.99, total records: 10179130 
    Average version length: 82.93, total versions: 930509, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.66 
    Pointer pages: 105, data page slots: 170312 
    Data pages: 170264, average fill: 75% 
    Primary pages: 170236, secondary pages: 28, swept pages: 27907 
    Empty pages: 370, full pages: 137155 
    Fill distribution: 
     0 - 19% = 891 
    20 - 39% = 2400 
    40 - 59% = 12035 
    60 - 79% = 112582 
    80 - 99% = 42356 
 
    Index XQS_2100_3300_DOC_ID (1) 
    Root page: 1344708, depth: 3, leaf buckets: 12021, nodes: 10179130 
    Average node length: 5.18, total dup: 10149623, max dup: 2205 
    Average key length: 2.03, compression ratio: 4.43 
    Average prefix length: 8.97, average data length: 0.03 
    Clustering factor: 2146842, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 26 
        20 - 39% = 1329 
        40 - 59% = 7854 
        60 - 79% = 2122 
        80 - 99% = 690 
 
    Index XQS_2100_3300_RCV_ID (3) 
    Root page: 1355739, depth: 3, leaf buckets: 13769, nodes: 10179130 
    Average node length: 6.24, total dup: 8441404, max dup: 14 
    Average key length: 3.10, compression ratio: 2.91 
    Average prefix length: 8.07, average data length: 0.93 
    Clustering factor: 1622033, ratio: 0.16 
    Fill distribution: 
         0 - 19% = 176 
        20 - 39% = 3612 
        40 - 59% = 4417 
        60 - 79% = 2713 
        80 - 99% = 2851 
 
    Index XQS_2100_3300_SND_ID (2) 
    Root page: 1350071, depth: 3, leaf buckets: 12673, nodes: 10179130 
    Average node length: 5.43, total dup: 9729995, max dup: 113 
    Average key length: 2.28, compression ratio: 3.94 
    Average prefix length: 8.76, average data length: 0.24 
    Clustering factor: 2281711, ratio: 0.22 
    Fill distribution: 
         0 - 19% = 26 
        20 - 39% = 1250 
        40 - 59% = 8885 
        60 - 79% = 1868 
        80 - 99% = 644 
 
    Index XQS_2100_3300_WORKER_ID (0) 
    Root page: 987843, depth: 3, leaf buckets: 10387, nodes: 10179130 
    Average node length: 5.15, total dup: 10179030, max dup: 162096 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.42, average data length: 0.00 
    Clustering factor: 1695510, ratio: 0.17 
    Fill distribution: 
         0 - 19% = 31 
        20 - 39% = 1104 
        40 - 59% = 4954 
        60 - 79% = 1941 
        80 - 99% = 2357 
 
XQS_3300_3400 (187) 
    Primary pointer page: 599, Index root page: 600 
    Total formats: 1, used formats: 1 
    Average record length: 67.06, total records: 577775 
    Average version length: 68.81, total versions: 10798, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.88 
    Pointer pages: 5, data page slots: 7992 
    Data pages: 7992, average fill: 76% 
    Primary pages: 7992, secondary pages: 0, swept pages: 2307 
    Empty pages: 5, full pages: 7896 
    Fill distribution: 
     0 - 19% = 7 
    20 - 39% = 3 
    40 - 59% = 21 
    60 - 79% = 7782 
    80 - 99% = 179 
 
    Index XQS_3300_3400_DOC_ID (1) 
    Root page: 44269, depth: 3, leaf buckets: 732, nodes: 577775 
    Average node length: 5.95, total dup: 492082, max dup: 82 
    Average key length: 3.09, compression ratio: 2.91 
    Average prefix length: 8.06, average data length: 0.94 
    Clustering factor: 101851, ratio: 0.18 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 23 
        40 - 59% = 520 
        60 - 79% = 98 
        80 - 99% = 91 
 
    Index XQS_3300_3400_SND_ID (2) 
    Root page: 27704, depth: 3, leaf buckets: 754, nodes: 577775 
    Average node length: 6.15, total dup: 473967, max dup: 29 
    Average key length: 3.29, compression ratio: 2.73 
    Average prefix length: 7.89, average data length: 1.11 
    Clustering factor: 101910, ratio: 0.18 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 17 
        40 - 59% = 540 
        60 - 79% = 96 
        80 - 99% = 101 
 
    Index XQS_3300_3400_WORKER_ID (0) 
    Root page: 377587, depth: 2, leaf buckets: 555, nodes: 577775 
    Average node length: 4.86, total dup: 577675, max dup: 9726 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.42, average data length: 0.00 
    Clustering factor: 90418, ratio: 0.16 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 26 
        40 - 59% = 307 
        60 - 79% = 83 
        80 - 99% = 139 
 
ZDOC_DATA (170) 
    Primary pointer page: 565, Index root page: 566 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
ZDOC_LIST (169) 
    Primary pointer page: 563, Index root page: 564 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
ZINVNT_TURNOVER_LOG (171) 
    Primary pointer page: 567, Index root page: 568 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
ZPDISTR (174) 
    Primary pointer page: 573, Index root page: 574 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index ZPDISTR_ID (0) 
    Root page: 1504230, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
ZPSTORNED (175) 
    Primary pointer page: 575, Index root page: 576 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index ZPSTORNED_ID (0) 
    Root page: 1504229, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
ZQDISTR (172) 
    Primary pointer page: 569, Index root page: 570 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index ZQDISTR_ID (0) 
    Root page: 1504235, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index ZQDISTR_WARE_SNDOP_RCVOP (1) 
    Root page: 1504236, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
ZQSTORNED (173) 
    Primary pointer page: 571, Index root page: 572 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index ZQSTORNED_DOC_ID (1) 
    Root page: 1504232, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index ZQSTORNED_ID (0) 
    Root page: 1504231, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index ZQSTORNED_RCV_ID (3) 
    Root page: 1504234, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index ZQSTORNED_SND_ID (2) 
    Root page: 1504233, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
ZTMP_DEP_DOCS (168) 
    Primary pointer page: 561, Index root page: 562 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
ZTMP_SHOPPING_CART (167) 
    Primary pointer page: 559, Index root page: 560 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
Z_USED_VIEWS (144) 
    Primary pointer page: 512, Index root page: 513 
    Total formats: 1, used formats: 1 
    Average record length: 29.38, total records: 29 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 99.00, compression ratio: 3.37 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 16% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index Z_USED_VIEWS_UNQ (0) 
    Root page: 1510372, depth: 1, leaf buckets: 1, nodes: 29 
    Average node length: 15.17, total dup: 0, max dup: 0 
    Average key length: 14.14, compression ratio: 1.44 
    Average prefix length: 9.17, average data length: 11.17 
    Clustering factor: 1, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
Gstat completion time Sun Feb 18 07:11:31 2024

Record versions statistics, table

TABLE_NAME TOTAL_RECS TOTAL_VERS MAX_VERSIONS VERS_TO_RECS_PRC MAXV_TO_VERS_PRC
DOC_DATA 7681529 42497 1 0.0000 0.0000
DOC_LIST 2208416 20940 2 0.0000 0.0000
FB_ERRORS 2182 757 1 0.0000 0.0000
INVNT_SALDO 400 2179 6 500.0000 0.0000
INVNT_TURNOVER_LOG 92012 65094 1 0.0000 0.0000
MONEY_SALDO 49 200 6 400.0000 0.0000
MONEY_TURNOVER_LOG 1485 1191 1 0.0000 0.0000
PDISTR 797370 11148 2 0.0000 0.0000
PERF_SPLIT_0 191087 29817 1 0.0000 0.0000
PERF_SPLIT_1 176723 25340 1 0.0000 0.0000
PERF_SPLIT_2 161235 25180 1 0.0000 0.0000
PERF_SPLIT_3 195951 17392 1 0.0000 0.0000
PERF_SPLIT_4 166959 13069 1 0.0000 0.0000
PERF_SPLIT_5 173969 14361 1 0.0000 0.0000
PERF_SPLIT_6 152602 8868 1 0.0000 0.0000
PERF_SPLIT_7 170092 15257 1 0.0000 0.0000
PERF_SPLIT_8 207681 57589 1 0.0000 0.0000
PERF_SPLIT_9 164862 8098 1 0.0000 0.0000
PSTORNED 2070516 23938 1 0.0000 0.0000
SEMAPHORES 5 1 1 0.0000 100.0000
XQD_1000_1200 104593 26099 1 0.0000 0.0000
XQD_1000_3300 6858636 117088 1 0.0000 0.0000
XQD_1200_2000 11950732 117175 1 0.0000 0.0000
XQD_2000_3300 1253369 162151 1 0.0000 0.0000
XQD_2100_3300 878518 48903 1 0.0000 0.0000
XQD_3300_3400 8910118 226199 1 0.0000 0.0000
XQS_1000_1200 21093009 5228 1 0.0000 0.0000
XQS_1000_3300 9690332 554345 1 0.0000 0.0000
XQS_1200_2000 11046934 218253 1 0.0000 0.0000
XQS_2100_3300 10179130 930509 1 0.0000 0.0000
XQS_3300_3400 577775 10798 1 0.0000 0.0000

Record versions statistics, chart

Total records and versions, chart

Ratios versions / total_records and max_versions / total_versions

Database validation 


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

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

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

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

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