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

Hardware and OS info

Command: hostnamectl
Static hostname mscs-test-161.budzdorov.ru
Icon name computer-server
Chassis server
Machine ID aeee285d2cca40bf84c40a748f599e77
Boot ID 2a7b53d1c5ed44b9bb2712fffac5d8c6
Operating System CentOS Linux 7 (Core)
CPE OS Name cpe:/o:centos:centos:7
Kernel Linux 3.10.0-1127.10.1.el7.x86_64
Architecture x86-64
Command: who -b
bootup_info system boot 2021-11-11 18:28
Command: dmidecode -t system|grep -i -e 'manufacturer\|product\|hypervisor'
Manufacturer HP
Product Name ProLiant DL380 Gen9
Command: dmesg | grep DMI
[ 0.000000] DMI HP ProLiant DL380 Gen9/ProLiant DL380 Gen9, BIOS P89 05/21/2018
Command: lscpu | grep -i -v flags
Architecture x86_64
CPU op-mode(s) 32-bit, 64-bit
Byte Order Little Endian
CPU(s) 24
On-line CPU(s) list 0-23
Thread(s) per core 2
Core(s) per socket 6
Socket(s) 2
NUMA node(s) 2
Vendor ID GenuineIntel
CPU family 6
Model 63
Model name Intel(R) Xeon(R) CPU E5-2620 v3 @ 2.40GHz
Stepping 2
CPU MHz 1200.000
CPU max MHz 2400.0000
CPU min MHz 1200.0000
BogoMIPS 4794.33
Virtualization VT-x
L1d cache 32K
L1i cache 32K
L2 cache 256K
L3 cache 15360K
NUMA node0 CPU(s) 0-5,12-17
NUMA node1 CPU(s) 6-11,18-23
Command: cat /proc/meminfo | grep -i -e 'memtotal\|memfree\|memavail\|buffers\|cached\|swapcached'
MemTotal 32643792 kB
MemFree 15620356 kB
MemAvailable 30252288 kB
Buffers 0 kB
Cached 16102936 kB
SwapCached 2276 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-03-01 13:07:50
DTS_END                         2024-03-01 13:07:50.0490
FB_GDSCODE                      -1
FB_MNEMONA                      
STACK                           SP_SUPPLIER_ORDER(38:5) ==> SP_CHECK_TO_STOP_WORK(32:12) ==> SP_HALT_ON_ERROR(68:17)
IP                              ::1/59944
TRN_ID                          173423
ATT_ID                          525
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: 9014.47 22885 901447
customer order: creation 173.36 400 17336
customer order: refuse 15.30 388 1530
order to supplier: creation 48.04 1473 4804
order to supplier: removal 3.58 88292 358
invoice (draft): creation 47.68 3612 4768
invoice (draft): removal 50.36 750 5036
invoice accept: apply 40.83 19969 4083
invoice accept: cancel 44.89 679 4489
customer reserve: creation 3929.95 189 392995
customer reserve: removal 4363.22 57 436322
realization accept: apply 86.03 194 8603
realization accept: cancel 79.66 113 7966
payment from customer: creation 59.88 122 5988
payment from customer: removal 5.62 132 562
payment to supplier: creation 52.03 140 5203
payment to supplier: removal 3.33 78 333
service: total inventory turnovers 3.57 4409 357
service: total monetary turnovers 6.31 629 631
service: aggregate perf. data 0.80 21036 80
service: refresh index statistics 0.03 315041 3

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:02, from 01-03-2024 13:08:44 to 01-03-2024 13:08:46.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 1921
TEST_TIME 2 3006
TEST_TIME 3 3391
TEST_TIME 4 3904
TEST_TIME 5 4432
TEST_TIME 6 4082
TEST_TIME 7 4284
TEST_TIME 8 4453
TEST_TIME 9 4920
TEST_TIME 10 5427
TEST_TIME 11 5570
TEST_TIME 12 5833
TEST_TIME 13 5774
TEST_TIME 14 6330
TEST_TIME 15 6509
TEST_TIME 16 6613
TEST_TIME 17 7128
TEST_TIME 18 7475
TEST_TIME 19 7388
TEST_TIME 20 7341
TEST_TIME 21 7547
TEST_TIME 22 7696
TEST_TIME 23 8555
TEST_TIME 24 9010
TEST_TIME 25 8932
TEST_TIME 26 9174
TEST_TIME 27 8933
TEST_TIME 28 9008
TEST_TIME 29 9064
TEST_TIME 30 9327
TEST_TIME 31 9058
TEST_TIME 32 9002
TEST_TIME 33 8822
TEST_TIME 34 8790
TEST_TIME 35 8893
TEST_TIME 36 9048
TEST_TIME 37 8883
TEST_TIME 38 8839
TEST_TIME 39 8723
TEST_TIME 40 8821
TEST_TIME 41 8881
TEST_TIME 42 8907
TEST_TIME 43 9033
TEST_TIME 44 8996
TEST_TIME 45 8989
TEST_TIME 46 9020
TEST_TIME 47 9095
TEST_TIME 48 9162
TEST_TIME 49 9181
TEST_TIME 50 9209
TEST_TIME 51 9267
TEST_TIME 52 9303
TEST_TIME 53 9302
TEST_TIME 54 9280
TEST_TIME 55 9217
TEST_TIME 56 9125
TEST_TIME 57 9092
TEST_TIME 58 9019
TEST_TIME 59 9018
TEST_TIME 60 9010
TEST_TIME 61 8985
TEST_TIME 62 8973
TEST_TIME 63 8960
TEST_TIME 64 8876
TEST_TIME 65 8837
TEST_TIME 66 8907
TEST_TIME 67 8940
TEST_TIME 68 8919
TEST_TIME 69 8970
TEST_TIME 70 9001
TEST_TIME 71 9140
TEST_TIME 72 9156
TEST_TIME 73 9165
TEST_TIME 74 9235
TEST_TIME 75 9252
TEST_TIME 76 9311
TEST_TIME 77 9369
TEST_TIME 78 9457
TEST_TIME 79 9452
TEST_TIME 80 9340
TEST_TIME 81 9260
TEST_TIME 82 9282
TEST_TIME 83 9214
TEST_TIME 84 9138
TEST_TIME 85 9138
TEST_TIME 86 9093
TEST_TIME 87 9062
TEST_TIME 88 9051
TEST_TIME 89 9018
TEST_TIME 90 8989
TEST_TIME 91 8936
TEST_TIME 92 8940
TEST_TIME 93 8919
TEST_TIME 94 8968
TEST_TIME 95 8952
TEST_TIME 96 9029
TEST_TIME 97 9011
TEST_TIME 98 9066
TEST_TIME 99 9051
TEST_TIME 100 9023

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:03, from 01-03-2024 13:08:48 to 01-03-2024 13:08:51.

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 1262552 1262552 0 0.00 0 20262 7 0 0
doc_list_biud 1262551 1262551 0 0.00 0 23348 25 0 0
sp_add_invoice_to_stock 4194 4083 111 2.64 48 181048 19970 0 111
sp_cancel_adding_invoice 4489 4489 0 0.00 5 53770 679 0 0
sp_cancel_client_order 1530 1530 0 0.00 4 14686 389 0 0
sp_cancel_customer_reserve 436322 436322 0 0.00 0 23393 58 0 0
sp_cancel_pay_from_customer 562 562 0 0.00 3 13433 133 0 0
sp_cancel_pay_to_supplier 333 333 0 0.00 2 4103 79 0 0
sp_cancel_supplier_invoice 5049 5036 13 0.25 2 15257 750 0 13
sp_cancel_supplier_order 358 358 0 0.00 8 777191 88292 0 0
sp_cancel_write_off 7966 7966 0 0.00 1 6819 113 0 0
sp_client_order 17336 17336 0 0.00 3 25154 401 0 0
sp_customer_reserve 392995 392995 0 0.00 0 88276 190 0 0
sp_fill_shopping_cart 26891 26891 0 0.00 1 31804 43 0 0
sp_fill_shopping_cart_clo_res 392991 392991 0 0.00 0 18407 16 0 0
sp_get_clo_for_invoice 4073 4073 0 0.00 0 33359 359 0 0
sp_kill_cost_storno 13350 13350 0 0.00 0 7624 64 0 0
sp_kill_qstorno_ret_qs2qd 886004 886004 0 0.00 0 23205 31 0 0
sp_kill_qty_storno 468376 468376 0 0.00 0 23348 67 0 0
sp_lock_selected_doc 17589 17589 0 0.00 0 12743 6 0 0
sp_make_cost_storno 23867 23867 0 0.00 0 14370 59 0 0
sp_multiply_rows_for_pdistr 23866 23866 0 0.00 0 14953 33 0 0
sp_multiply_rows_for_qdistr 17336 17336 0 0.00 0 25135 179 0 0
sp_pay_from_customer 5988 5988 0 0.00 4 21505 123 0 0
sp_pay_to_supplier 5203 5203 0 0.00 4 25726 140 0 0
sp_payment_common 11191 11191 0 0.00 1 8165 21 0 0
sp_qd_handle_on_cancel_clo 1530 1530 0 0.00 0 14679 361 0 0
sp_qd_handle_on_invoice_upd_sts 8562 8562 0 0.00 0 16841 289 0 0
sp_qd_handle_on_reserve_upd_sts 8602 8602 0 0.00 0 14264 59 0 0
sp_reserve_write_off 8603 8603 0 0.00 6 15563 195 0 0
sp_supplier_invoice 4768 4768 0 0.00 6 98557 3613 0 0
sp_supplier_order 4804 4804 0 0.00 4 56299 1474 0 0
srv_aggregate_perf_data 80 80 0 0.00 1440 533195 21037 0 0
srv_fill_mon_cache_memory 56 56 0 0.00 1424 170812 42258 0 0
srv_find_qd_qs_mism 859430 859430 0 0.00 0 20262 5 0 0
srv_make_invnt_saldo 357 357 0 0.00 43 97613 4409 0 0
srv_make_money_saldo 631 631 0 0.00 1 18602 630 0 0
srv_recalc_idx_stat 3 3 0 0.00 232212 466707 315042 0 0
t$perf-abend:sp_add_invoice_to_stock 111 111 0 0.00 0 0 0 0 0
t$perf-abend:sp_cancel_supplier_invoice 13 13 0 0.00 0 0 0 0 0
t$perf-norm:sp_add_invoice_to_stock 4083 4083 0 0.00 0 13172 196 0 0
t$perf-norm:sp_cancel_adding_invoice 327 327 0 0.00 1 1516 66 0 0
t$perf-norm:sp_cancel_client_order 1530 1530 0 0.00 0 2574 11 0 0
t$perf-norm:sp_cancel_customer_reserve 629 629 0 0.00 0 898 8 0 0
t$perf-norm:sp_cancel_pay_from_customer 562 562 0 0.00 0 1548 11 0 0
t$perf-norm:sp_cancel_pay_to_supplier 333 333 0 0.00 0 2582 16 0 0
t$perf-norm:sp_cancel_supplier_invoice 348 348 0 0.00 0 4856 34 0 0
t$perf-norm:sp_cancel_supplier_order 358 358 0 0.00 0 22904 1847 0 0
t$perf-norm:sp_cancel_write_off 827 827 0 0.00 0 2309 8 0 0
t$perf-norm:sp_client_order 17336 17336 0 0.00 0 10460 19 0 0
t$perf-norm:sp_customer_reserve 820 820 0 0.00 0 318 5 0 0
t$perf-norm:sp_pay_from_customer 5988 5988 0 0.00 0 12567 16 0 0
t$perf-norm:sp_pay_to_supplier 5203 5203 0 0.00 0 8620 10 0 0
t$perf-norm:sp_reserve_write_off 8603 8603 0 0.00 0 6462 11 0 0
t$perf-norm:sp_supplier_invoice 4768 4768 0 0.00 0 4530 18 0 0
t$perf-norm:sp_supplier_order 4804 4804 0 0.00 0 5392 17 0 0
t$perf-norm:srv_aggregate_perf_data 80 80 0 0.00 0 254 7 0 0
t$perf-norm:srv_fill_mon_cache_memory 56 56 0 0.00 0 5 1 0 0
t$perf-norm:srv_make_invnt_saldo 357 357 0 0.00 0 3371 28 0 0
t$perf-norm:srv_make_money_saldo 631 631 0 0.00 0 648 4 0 0
t$perf-norm:srv_recalc_idx_stat 3 3 0 0.00 1 4 2 0 0
v_add_invoice_to_stock 8368 8146 222 2.65 0 12455 21 0 222
v_all_customers 31978 31978 0 0.00 0 54 1 0 0
v_all_suppliers 27572 27572 0 0.00 0 54 1 0 0
v_all_wares 34670 34670 0 0.00 0 54 1 0 0
v_cancel_adding_invoice 654 654 0 0.00 0 792 6 0 0
v_cancel_client_order 3060 3060 0 0.00 0 2520 5 0 0
v_cancel_customer_prepayment 1124 1124 0 0.00 0 13395 30 0 0
v_cancel_customer_reserve 1258 1258 0 0.00 0 7845 11 0 0
v_cancel_payment_to_supplier 666 666 0 0.00 0 322 4 0 0
v_cancel_supplier_invoice 722 696 26 3.60 0 534 12 0 26
v_cancel_supplier_order 716 716 0 0.00 0 4514 16 0 0
v_cancel_write_off 1654 1654 0 0.00 0 5521 22 0 0
v_max_id_clo_ord 4802 4802 0 0.00 0 1935 1 0 0
v_max_id_clo_res 820 820 0 0.00 0 2384 12 0 0
v_max_id_ord_sup 4754 4754 0 0.00 0 5017 5 0 0
v_max_non_paid_invoice 973 973 0 0.00 0 847 3 0 0
v_max_non_paid_realizn 2944 2944 0 0.00 0 1903 4 0 0
v_min_id_clo_ord 4802 4802 0 0.00 0 11627 11 0 0
v_min_id_clo_res 820 820 0 0.00 0 1944 12 0 0
v_min_id_ord_sup 4754 4754 0 0.00 0 5850 11 0 0
v_min_non_paid_invoice 5203 5203 0 0.00 0 7373 15 0 0
v_min_non_paid_realizn 5988 5988 0 0.00 0 8160 14 0 0
v_our_firm 8780 8780 0 0.00 0 21 1 0 0
v_reserve_write_off 17204 17204 0 0.00 0 13958 8 0 0
x_lock_depdocs_on_canc_invoice 9177 9177 0 0.00 0 28058 119 0 0
x_lock_depdocs_on_canc_sup_ord 358 358 0 0.00 0 10207 317 0 0
x_make_qstorno_1000_1200 4804 4804 0 0.00 1 56293 1391 0 0
x_make_qstorno_1200_2000 4768 4768 0 0.00 2 98546 3446 0 0
x_make_qstorno_2100_3300 392995 392995 0 0.00 0 88275 171 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 01-03-2024 13:08:52 to 01-03-2024 13:08:56.

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
11:07:54 5 8192000000 8803997264 8817270784 8896016 0.108 3 3 4 0 9091168 108208 86944
11:08:55 29508 8192000000 9719727008 10019663872 804379280 8.941 100 86 172 1 832276128 7475440 20421408
11:10:30 11948 8192000000 9747360768 10051092480 823719968 9.136 100 90 180 0 858006880 12582256 21704656
11:11:53 15207 8192000000 9780173168 10094772224 850088160 9.401 100 81 162 1 887941104 18930320 18922624
11:13:14 16543 8192000000 9846731616 10178199552 903051088 9.929 100 86 172 1 958873248 36955536 18866624
11:14:36 7548 8192000000 9905188496 10245685248 940033760 10.293 100 82 164 0 1016501824 58908192 17559872
11:15:46 2821 8192000000 9943583072 10294095872 971300272 10.599 100 82 162 0 1054794752 67469040 16025440
11:16:51 3918 8192000000 9966115408 10325925888 1003838496 10.916 100 77 153 0 1078260480 58945168 15476816
11:17:57 2772 8192000000 10008916688 10376871936 1034431760 11.211 100 81 160 1 1119981696 69488592 16061344
11:19:02 1523 8192000000 10030025584 10400698368 1051021264 11.370 100 92 180 0 1135640800 66013472 18606064
11:20:04 13498 8192000000 10042250784 10425737216 1063138656 11.487 100 68 134 1 1154070192 75776848 15154688
11:21:19 5409 8192000000 9987481600 10390388736 1068342480 11.536 100 20 40 0 1095126992 22860000 3924512
11:22:27 56392 8192000000 9980449968 10377494528 1074848448 11.598 100 40 80 2 1143497792 59421408 9227936
11:24:24 5229 8192000000 10002199472 10403586048 1081532768 11.662 100 38 74 0 1105084992 15346576 8205648
11:25:31 5455 8192000000 10001330960 10401853440 1087027664 11.714 100 34 68 0 1105113120 10785056 7300400
11:26:38 3262 8192000000 10014242608 10419060736 1093043360 11.772 100 50 94 2 1137457024 33740528 10673136
11:27:42 69038 8192000000 10016752544 10416123904 1075549424 11.605 98 46 93 1 1120701696 35061776 10090496
11:30:13 19230 8192000000 10051894608 10458243072 1102011056 11.857 99 44 88 1 1157920896 47099920 8809920
11:31:34 40303 8192000000 10083802480 10492076032 1088134112 11.725 98 49 93 1 1169903184 71769536 9999536
11:33:30 54726 8192000000 10147449488 10572701696 1102630384 11.863 98 53 108 0 1219119232 105050816 11438032
11:35:29 17270 8192000000 10141694976 10556690432 1118100000 12.009 100 41 80 2 1251506448 123795904 9610544
11:36:58 4492 8192000000 10132570320 10536996864 1084589840 11.691 98 42 84 0 1225459568 131745456 9124272
11:38:09 3774 8192000000 10095197488 10490941440 1060519648 11.461 97 54 106 2 1180870496 109265936 11084912
11:39:17 9386 8192000000 10076829744 10490580992 1065164784 11.506 100 41 81 1 1196140672 122169584 8806304
11:40:33 3477 8192000000 10149733568 10535915520 1094269136 11.783 100 81 157 4 1252414640 141977936 16167568
11:41:45 5087 8192000000 10166995808 10561519616 1102006448 11.857 99 58 116 0 1275657520 161519136 12131936
11:42:53 3521 8192000000 10184865184 10577223680 1106051616 11.895 100 79 157 2 1292038144 169099968 16886560
11:44:03 1420 8192000000 10228160736 10633236480 1106488784 11.899 99 78 150 0 1334217872 211768224 15960864
11:45:11 3256 8192000000 10229586400 10639667200 1127893328 12.101 100 84 167 0 1325867952 179816224 18158400
11:46:21 7130 8192000000 10248311264 10645188608 1135742512 12.175 100 76 148 0 1347185520 193806912 17636096
11:47:31 11059 8192000000 10284574272 10694533120 1123997248 12.065 100 54 107 1 1389952352 253755488 12199616
11:48:51 17283 8192000000 10268868800 10711601152 1124942176 12.074 100 26 50 0 1388423120 257184464 6296480
11:50:12 14786 8192000000 10177749808 10692694016 1109821216 11.931 100 25 49 0 1320667888 204868576 5978096
11:51:32 11261 8192000000 10078760544 10546294784 1109821088 11.931 99 18 36 0 1198039840 84475824 3742928
11:52:47 37612 8192000000 10041817888 10508181504 1111909936 11.950 100 10 20 0 1198194768 84111408 2173424
11:54:27 23252 8192000000 10120825552 10536341504 1132809552 12.148 100 53 103 2 1209642416 65856768 10976096
11:55:52 31203 8192000000 10161837456 10617352192 1135496064 12.173 100 16 30 0 1271753840 132852208 3405568
11:57:27 70310 8192000000 10077831312 10509082624 1143083120 12.245 100 30 59 0 1178302848 28994528 6225200
11:59:44 63655 8192000000 10114775376 10544558080 1138802224 12.204 100 36 70 0 1199296544 52988336 7505984
12:01:50 25709 8192000000 10168812144 10614308864 1149499280 12.305 100 30 60 1 1276232112 118984336 7748496
12:03:27 34432 8192000000 10119071904 10625114112 1149977696 12.309 100 18 36 0 1234298928 79930080 4391152
12:05:02 19941 8192000000 10135251840 10593992704 1141543568 12.230 99 24 48 0 1230221664 83063808 5614288
12:06:46 43809 8192000000 10157679424 10657439744 1143657200 12.250 99 20 38 0 1285363568 137240624 4465744
12:09:07 41233 8192000000 10118656112 10567299072 1136034880 12.178 99 21 42 0 1222276800 82060432 4181488
12:10:54 26884 8192000000 10062535152 10502897664 1140735712 12.222 99 17 34 0 1166242544 22165664 3341168
12:12:21 11556 8192000000 10105826192 10541858816 1154845536 12.355 100 52 105 0 1202985744 37095872 11044336
12:13:35 39367 8192000000 10079523648 10523881472 1082259088 11.669 94 11 22 0 1152458000 68046240 2152672
12:15:33 68345 8192000000 10062503024 10529038336 1059885136 11.455 93 22 44 1 1110018000 46001952 4130912
12:17:45 8284 8192000000 10060916800 10501353472 1114203920 11.972 99 36 72 0 1167364656 46066112 7094624
12:19:01 43783 8192000000 10066098384 10511237120 1108607632 11.919 99 23 46 0 1162047024 48762672 4676720
12:20:46 76324 8192000000 10037820848 10470076416 1017447856 11.047 91 27 54 1 1073871248 50812928 5610464
12:23:04 170812 8192000000 10026197504 10441543680 982984432 10.713 89 31 60 0 1022020272 33366688 5669152
12:26:56 57365 8192000000 10053956560 10514522112 1072922000 11.580 98 23 46 0 1163548416 86156960 4469456
12:28:55 43668 8192000000 10058062944 10495385600 1081101088 11.658 99 13 27 0 1147205984 63457536 2647360
12:30:52 74931 8192000000 10073650400 10513670144 1091094128 11.753 99 26 52 0 1150243728 53703088 5446512
12:33:07 54452 8192000000 10070574624 10561802240 1081832080 11.665 98 13 26 0 1180977120 96330112 2814928
12:35:12 52040 8192000000 10059823968 10494910464 1083306992 11.679 98 26 52 0 1139685264 51136048 5242224
12:37:07 39165 8192000000 10088939056 10517590016 1083712240 11.683 97 22 44 0 1142921792 54891808 4317744
12:38:50 77171 8192000000 10055738000 10498752512 1106776288 11.902 98 23 46 0 1152229600 40893600 4559712
12:41:12 44713 8192000000 10082902416 10560872448 1093062224 11.772 96 33 64 0 1162347632 62120448 7164960
12:43:03 51498 8192000000 10130322784 10586693632 1121648144 12.043 98 24 48 1 1209953840 83554800 4750896
12:44:55 148344 8192000000 10098901648 10572111872 1150583088 12.315 100 25 50 0 1212435696 56472000 5380608
12:48:34 80797 8192000000 10099968256 10570534912 1142666176 12.241 99 22 44 0 1193154832 45877200 4611456
12:50:57 86526 8192000000 10117095056 10580283392 1147406832 12.285 99 9 18 0 1205632176 56347536 1877808
12:53:24 108184 8192000000 10091969040 10538450944 1157713456 12.382 100 13 26 1 1211726400 51287936 2725008
12:56:20 72122 8192000000 10107122048 10586980352 1169988224 12.497 100 23 46 0 1233567344 58715584 4863536
12:58:32 42016 8192000000 10093527456 10591485952 1167046928 12.469 100 11 22 0 1223349696 53792864 2509904
13:00:32 51798 8192000000 10115349920 10595418112 1136147504 12.179 97 19 36 0 1200036912 60086368 3803040
13:02:25 65040 8192000000 10095463520 10575417344 1123907040 12.064 97 16 32 0 1191349344 63971600 3470704
13:04:31 38591 8192000000 10104695104 10553856000 1120990560 12.036 97 24 48 0 1177082864 51200544 4891760
13:06:13 27491 8192000000 10083736128 10509811712 1126735776 12.091 98 42 80 3 1154694880 19603648 8355456
13:07:43 17454 8192000000 9339566848 9648717824 450961104 5.217 40 11 22 0 492876624 39853872 2061648

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:14, from 01-03-2024 13:08:58 to 01-03-2024 13:09:12.

Exceptions occured during test was in run

FB_MNEMONA CNT UNIT FB_GDSCODE
except 111 v_add_invoice_to_stock 335544517
except 13 v_cancel_supplier_invoice 335544517

Completed "Exceptions occured during test was in run". Done for 00:00:02, from 01-03-2024 13:09:13 to 01-03-2024 13:09:15.

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          173687
MON$OLDEST_ACTIVE               173688
MON$OLDEST_SNAPSHOT             173688
MON$NEXT_TRANSACTION            173688
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                       1928480
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             689
MON$NEXT_STATEMENT              53
MON$REPLICA_MODE                0


ISQL Version: LI-V4.0.5.3062 Firebird 4.0
Server version:
Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V4.0.5.3062 Firebird 4.0"
Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-V4.0.5.3062 Firebird 4.0/tcp (mscs-test-161.budzdorov.ru)/P17:C"
Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-V4.0.5.3062 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 Fri Mar  1 13:09:16 2024 
 
Database header page information: 
    Flags            0 
    Generation        90692 
    System Change Number    0 
    Page size        8192 
    ODS version        13.0 
    Oldest transaction    173687 
    Oldest active        173688 
    Oldest snapshot        173688 
    Next transaction    173689 
    Sequence number        0 
    Next attachment ID    689 
    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.22, total records: 7776859 
    Average version length: 48.16, total versions: 134559, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 64.00, compression ratio: 1.36 
    Pointer pages: 55, data page slots: 89032 
    Data pages: 89032, average fill: 70% 
    Primary pages: 89031, secondary pages: 1, swept pages: 30509 
    Empty pages: 3, full pages: 76916 
    Fill distribution: 
     0 - 19% = 13 
    20 - 39% = 40 
    40 - 59% = 1745 
    60 - 79% = 87156 
    80 - 99% = 78 
 
    Index DOC_DATA_DOC_WARE_UNQ (0) 
    Root page: 1510636, depth: 3, leaf buckets: 23154, nodes: 7776859 
    Average node length: 18.89, total dup: 0, max dup: 0 
    Average key length: 15.90, compression ratio: 1.70 
    Average prefix length: 14.09, average data length: 12.91 
    Clustering factor: 1675389, ratio: 0.22 
    Fill distribution: 
         0 - 19% = 328 
        20 - 39% = 1512 
        40 - 59% = 4233 
        60 - 79% = 2214 
        80 - 99% = 14867 
 
    Index DOC_DATA_ID_DESC (1) 
    Root page: 1528140, depth: 3, leaf buckets: 13455, nodes: 7776859 
    Average node length: 11.20, total dup: 0, max dup: 0 
    Average key length: 8.21, compression ratio: 1.10 
    Average prefix length: 3.79, average data length: 5.21 
    Clustering factor: 1500382, ratio: 0.19 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 1396 
        40 - 59% = 2130 
        60 - 79% = 1029 
        80 - 99% = 8900 
 
    Index FK_DOC_DATA_DOC_LIST (2) 
    Root page: 1546735, depth: 3, leaf buckets: 8319, nodes: 7776859 
    Average node length: 6.62, total dup: 5811961, max dup: 49 
    Average key length: 3.63, compression ratio: 2.48 
    Average prefix length: 7.62, average data length: 1.38 
    Clustering factor: 1493357, ratio: 0.19 
    Fill distribution: 
         0 - 19% = 149 
        20 - 39% = 816 
        40 - 59% = 1471 
        60 - 79% = 856 
        80 - 99% = 5027 
 
DOC_LIST (138) 
    Primary pointer page: 500, Index root page: 501 
    Total formats: 1, used formats: 1 
    Average record length: 55.91, total records: 2253997 
    Average version length: 58.86, total versions: 71045, max versions: 2 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 84.00, compression ratio: 1.50 
    Pointer pages: 18, data page slots: 28776 
    Data pages: 28776, average fill: 72% 
    Primary pages: 28774, secondary pages: 2, swept pages: 7980 
    Empty pages: 3, full pages: 23063 
    Fill distribution: 
     0 - 19% = 11 
    20 - 39% = 27 
    40 - 59% = 734 
    60 - 79% = 27837 
    80 - 99% = 167 
 
    Index DOC_LIST_ID_DESC (1) 
    Root page: 1541152, depth: 3, leaf buckets: 4508, nodes: 2253997 
    Average node length: 11.40, total dup: 0, max dup: 0 
    Average key length: 8.44, compression ratio: 1.07 
    Average prefix length: 3.56, average data length: 5.44 
    Clustering factor: 679009, ratio: 0.30 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 813 
        40 - 59% = 887 
        60 - 79% = 674 
        80 - 99% = 2134 
 
    Index DOC_LIST_WORKER_OPTYPE (2) 
    Root page: 1544398, depth: 3, leaf buckets: 2451, nodes: 2255681 
    Average node length: 4.97, total dup: 2254782, max dup: 20935 
    Average key length: 2.01, compression ratio: 4.48 
    Average prefix length: 8.99, average data length: 0.01 
    Clustering factor: 1256183, ratio: 0.56 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 218 
        40 - 59% = 1457 
        60 - 79% = 534 
        80 - 99% = 240 
 
    Index FK_DOC_LIST_AGENTS (3) 
    Root page: 1545933, depth: 3, leaf buckets: 1798, nodes: 2253997 
    Average node length: 4.97, total dup: 2253947, max dup: 130205 
    Average key length: 2.01, compression ratio: 4.48 
    Average prefix length: 8.99, average data length: 0.01 
    Clustering factor: 1069814, ratio: 0.47 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 8 
        40 - 59% = 658 
        60 - 79% = 49 
        80 - 99% = 1083 
 
    Index PK_DOC_LIST (0) 
    Root page: 1538209, depth: 3, leaf buckets: 4311, nodes: 2253997 
    Average node length: 11.40, total dup: 0, max dup: 0 
    Average key length: 8.44, compression ratio: 1.07 
    Average prefix length: 3.56, average data length: 5.44 
    Clustering factor: 679009, ratio: 0.30 
    Fill distribution: 
         0 - 19% = 106 
        20 - 39% = 508 
        40 - 59% = 643 
        60 - 79% = 770 
        80 - 99% = 2284 
 
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.29, total records: 400 
    Average version length: 26.36, total versions: 3725, max versions: 11 
    Average fragment length: 2.00, total fragments: 4, max fragments: 1 
    Average unpacked length: 104.00, compression ratio: 1.25 
    Pointer pages: 1, data page slots: 40 
    Data pages: 40, average fill: 62% 
    Primary pages: 9, secondary pages: 31, swept pages: 0 
    Empty pages: 2, full pages: 24 
    Fill distribution: 
     0 - 19% = 11 
    20 - 39% = 3 
    40 - 59% = 0 
    60 - 79% = 5 
    80 - 99% = 21 
 
    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: 10.38, total records: 74147 
    Average version length: 68.27, total versions: 72421, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 88.00, compression ratio: 8.48 
    Pointer pages: 7, data page slots: 2064 
    Data pages: 1232, average fill: 82% 
    Primary pages: 1231, secondary pages: 1, swept pages: 0 
    Empty pages: 22, full pages: 999 
    Fill distribution: 
     0 - 19% = 47 
    20 - 39% = 41 
    40 - 59% = 67 
    60 - 79% = 178 
    80 - 99% = 899 
 
    Index INVNT_TURNOVER_LOG_WARE_DD_ID (0) 
    Root page: 1702628, depth: 3, leaf buckets: 242, nodes: 74147 
    Average node length: 13.68, total dup: 3522, max dup: 2 
    Average key length: 10.83, compression ratio: 2.49 
    Average prefix length: 19.12, average data length: 7.88 
    Clustering factor: 55614, ratio: 0.75 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 61 
        40 - 59% = 102 
        60 - 79% = 65 
        80 - 99% = 13 
 
MONEY_SALDO (141) 
    Primary pointer page: 506, Index root page: 507 
    Total formats: 1, used formats: 1 
    Average record length: 15.22, total records: 49 
    Average version length: 9.00, total versions: 404, max versions: 13 
    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: 8 
    Data pages: 8, average fill: 19% 
    Primary pages: 1, secondary pages: 7, swept pages: 0 
    Empty pages: 0, full pages: 1 
    Fill distribution: 
     0 - 19% = 6 
    20 - 39% = 1 
    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: 10.73, total records: 1891 
    Average version length: 42.75, total versions: 1794, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 58.00, compression ratio: 5.40 
    Pointer pages: 1, data page slots: 48 
    Data pages: 32, average fill: 62% 
    Primary pages: 31, secondary pages: 1, swept pages: 5 
    Empty pages: 7, full pages: 19 
    Fill distribution: 
     0 - 19% = 10 
    20 - 39% = 0 
    40 - 59% = 3 
    60 - 79% = 0 
    80 - 99% = 19 
 
    Index MONEY_TURNOVER_LOG_AGENT_OPTYPE (0) 
    Root page: 91747, depth: 2, leaf buckets: 3, nodes: 1891 
    Average node length: 4.16, total dup: 1793, max dup: 154 
    Average key length: 2.55, compression ratio: 7.45 
    Average prefix length: 18.50, average data length: 0.50 
    Clustering factor: 1043, ratio: 0.55 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 2 
        60 - 79% = 0 
        80 - 99% = 0 
 
MON_CACHE_MEMORY (165) 
    Primary pointer page: 555, Index root page: 556 
    Total formats: 2, used formats: 1 
    Average record length: 97.65, total records: 72 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 112.00, compression ratio: 1.15 
    Pointer pages: 1, data page slots: 2 
    Data pages: 2, average fill: 51% 
    Primary pages: 2, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 1 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 1 
    40 - 59% = 0 
    60 - 79% = 1 
    80 - 99% = 0 
 
    Index PK_MON_CACHE_MEMORY (0) 
    Root page: 1504238, depth: 1, leaf buckets: 1, nodes: 72 
    Average node length: 11.69, total dup: 0, max dup: 0 
    Average key length: 10.68, compression ratio: 0.84 
    Average prefix length: 1.31, average data length: 7.69 
    Clustering factor: 2, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
MON_LOG (162) 
    Primary pointer page: 548, Index root page: 549 
    Total formats: 2, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index MON_LOG_DTS (4) 
    Root page: 1504251, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index MON_LOG_GDSCODE (2) 
    Root page: 1504249, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index MON_LOG_ROWSET_DESC (1) 
    Root page: 1504248, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index MON_LOG_UNIT (3) 
    Root page: 1504250, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PK_MON_LOG (0) 
    Root page: 1504247, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
MON_LOG_TABLE_STATS (163) 
    Primary pointer page: 550, Index root page: 551 
    Total formats: 2, used formats: 1 
    Average record length: 67.13, total records: 30 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 611.00, compression ratio: 9.10 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 31% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 1 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index MON_LOG_TABLE_STATS_DTS (4) 
    Root page: 1504246, depth: 1, leaf buckets: 1, nodes: 30 
    Average node length: 3.50, total dup: 23, max dup: 4 
    Average key length: 2.47, compression ratio: 3.24 
    Average prefix length: 7.53, average data length: 0.47 
    Clustering factor: 1, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index MON_LOG_TABLE_STATS_GDSCODE (2) 
    Root page: 1504244, depth: 1, leaf buckets: 1, nodes: 30 
    Average node length: 2.00, total dup: 29, max dup: 29 
    Average key length: 1.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 1, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index MON_LOG_TABLE_STATS_ROWSET (1) 
    Root page: 1504243, depth: 1, leaf buckets: 1, nodes: 30 
    Average node length: 3.33, total dup: 29, max dup: 29 
    Average key length: 2.30, compression ratio: 3.91 
    Average prefix length: 8.70, average data length: 0.30 
    Clustering factor: 1, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index MON_LOG_TABLE_STATS_TN_UNIT (3) 
    Root page: 1504245, depth: 1, leaf buckets: 1, nodes: 30 
    Average node length: 12.90, total dup: 0, max dup: 0 
    Average key length: 11.87, compression ratio: 1.42 
    Average prefix length: 7.63, average data length: 9.20 
    Clustering factor: 1, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PK_MON_LOG_TABLE_STATS (0) 
    Root page: 1504242, depth: 1, leaf buckets: 1, nodes: 30 
    Average node length: 8.37, total dup: 0, max dup: 0 
    Average key length: 7.33, compression ratio: 1.23 
    Average prefix length: 4.63, average data length: 4.37 
    Clustering factor: 1, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
OPTYPES (136) 
    Primary pointer page: 496, Index root page: 497 
    Total formats: 2, used formats: 1 
    Average record length: 67.56, total records: 9 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 386.00, compression ratio: 5.71 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 9% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index OPTYPES_MCODE_UNQ (1) 
    Root page: 1544827, depth: 1, leaf buckets: 1, nodes: 9 
    Average node length: 8.56, total dup: 0, max dup: 0 
    Average key length: 6.89, compression ratio: 0.73 
    Average prefix length: 0.44, average data length: 4.56 
    Clustering factor: 1, ratio: 0.11 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PK_OPTYPES (0) 
    Root page: 1544826, depth: 1, leaf buckets: 1, nodes: 9 
    Average node length: 6.11, total dup: 0, max dup: 0 
    Average key length: 5.00, compression ratio: 0.60 
    Average prefix length: 0.89, average data length: 2.11 
    Clustering factor: 1, ratio: 0.11 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
PDISTR (146) 
    Primary pointer page: 516, Index root page: 517 
    Total formats: 1, used formats: 1 
    Average record length: 35.89, total records: 839460 
    Average version length: 37.91, total versions: 34904, max versions: 2 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 54.00, compression ratio: 1.50 
    Pointer pages: 6, data page slots: 8576 
    Data pages: 8576, average fill: 67% 
    Primary pages: 8575, secondary pages: 1, swept pages: 1107 
    Empty pages: 8, full pages: 8241 
    Fill distribution: 
     0 - 19% = 18 
    20 - 39% = 16 
    40 - 59% = 89 
    60 - 79% = 8386 
    80 - 99% = 67 
 
    Index PDISTR_AGENT_ID (2) 
    Root page: 1509330, depth: 2, leaf buckets: 865, nodes: 815840 
    Average node length: 4.88, total dup: 815791, max dup: 154052 
    Average key length: 2.01, compression ratio: 4.48 
    Average prefix length: 8.99, average data length: 0.01 
    Clustering factor: 91563, ratio: 0.11 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 129 
        40 - 59% = 450 
        60 - 79% = 161 
        80 - 99% = 123 
 
    Index PDISTR_SNDOP_RCVOP_SNDID_ASC (0) 
    Root page: 1508635, depth: 3, leaf buckets: 908, nodes: 815840 
    Average node length: 5.89, total dup: 726344, max dup: 47 
    Average key length: 3.02, compression ratio: 7.29 
    Average prefix length: 21.09, average data length: 0.91 
    Clustering factor: 163300, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 16 
        40 - 59% = 465 
        60 - 79% = 107 
        80 - 99% = 318 
 
    Index PDISTR_SNDOP_RCVOP_SNDID_DESC (1) 
    Root page: 1509209, depth: 3, leaf buckets: 933, nodes: 815840 
    Average node length: 5.89, total dup: 726344, max dup: 47 
    Average key length: 3.02, compression ratio: 7.29 
    Average prefix length: 21.09, average data length: 0.91 
    Clustering factor: 165209, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 52 
        40 - 59% = 469 
        60 - 79% = 104 
        80 - 99% = 308 
 
    Index PDISTR_WORKER_SND_ID (3) 
    Root page: 1510200, depth: 3, leaf buckets: 1139, nodes: 815840 
    Average node length: 5.97, total dup: 726344, max dup: 47 
    Average key length: 3.10, compression ratio: 5.48 
    Average prefix length: 16.01, average data length: 0.99 
    Clustering factor: 157656, ratio: 0.19 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 205 
        40 - 59% = 642 
        60 - 79% = 195 
        80 - 99% = 96 
 
PERF_AGG (158) 
    Primary pointer page: 540, Index root page: 541 
    Total formats: 1, used formats: 1 
    Average record length: 62.79, total records: 5462 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 3.04, total fragments: 26, max fragments: 1 
    Average unpacked length: 379.00, compression ratio: 6.04 
    Pointer pages: 1, data page slots: 88 
    Data pages: 88, average fill: 61% 
    Primary pages: 75, secondary pages: 13, swept pages: 47 
    Empty pages: 6, full pages: 56 
    Fill distribution: 
     0 - 19% = 14 
    20 - 39% = 0 
    40 - 59% = 1 
    60 - 79% = 73 
    80 - 99% = 0 
 
    Index PERF_AGG_UNQ (1) 
    Root page: 1504260, depth: 2, leaf buckets: 6, nodes: 5462 
    Average node length: 5.48, total dup: 0, max dup: 0 
    Average key length: 3.58, compression ratio: 10.07 
    Average prefix length: 34.45, average data length: 1.54 
    Clustering factor: 5106, ratio: 0.93 
    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: 5462 
    Average node length: 11.11, total dup: 0, max dup: 0 
    Average key length: 9.21, compression ratio: 0.98 
    Average prefix length: 2.79, average data length: 6.21 
    Clustering factor: 180, 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.12, total records: 78220 
    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: 816 
    Data pages: 816, average fill: 66% 
    Primary pages: 816, secondary pages: 0, swept pages: 0 
    Empty pages: 2, full pages: 813 
    Fill distribution: 
     0 - 19% = 3 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 813 
    80 - 99% = 0 
 
    Index PK_PERF_ESTIMATED (0) 
    Root page: 37827, depth: 2, leaf buckets: 101, nodes: 78220 
    Average node length: 10.17, total dup: 0, max dup: 0 
    Average key length: 8.18, compression ratio: 1.10 
    Average prefix length: 3.82, average data length: 5.18 
    Clustering factor: 2967, ratio: 0.04 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 0 
        40 - 59% = 1 
        60 - 79% = 0 
        80 - 99% = 98 
 
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.54, 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.30 
    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: 146.15, total records: 161198 
    Average version length: 147.35, total versions: 5648, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.60 
    Pointer pages: 7, data page slots: 4592 
    Data pages: 4024, average fill: 83% 
    Primary pages: 4023, secondary pages: 1, swept pages: 2 
    Empty pages: 56, full pages: 3946 
    Fill distribution: 
     0 - 19% = 61 
    20 - 39% = 9 
    40 - 59% = 2 
    60 - 79% = 5 
    80 - 99% = 3947 
 
PERF_SPLIT_1 (282) 
    Primary pointer page: 603, Index root page: 604 
    Total formats: 1, used formats: 1 
    Average record length: 146.66, total records: 130178 
    Average version length: 149.39, total versions: 3745, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.56 
    Pointer pages: 6, data page slots: 3552 
    Data pages: 3248, average fill: 83% 
    Primary pages: 3247, secondary pages: 1, swept pages: 2 
    Empty pages: 48, full pages: 3178 
    Fill distribution: 
     0 - 19% = 53 
    20 - 39% = 4 
    40 - 59% = 3 
    60 - 79% = 8 
    80 - 99% = 3180 
 
PERF_SPLIT_2 (283) 
    Primary pointer page: 605, Index root page: 606 
    Total formats: 1, used formats: 1 
    Average record length: 143.81, total records: 150776 
    Average version length: 151.81, total versions: 7506, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.79 
    Pointer pages: 6, data page slots: 5272 
    Data pages: 3792, average fill: 82% 
    Primary pages: 3790, secondary pages: 2, swept pages: 1 
    Empty pages: 84, full pages: 3684 
    Fill distribution: 
     0 - 19% = 88 
    20 - 39% = 4 
    40 - 59% = 8 
    60 - 79% = 7 
    80 - 99% = 3685 
 
PERF_SPLIT_3 (284) 
    Primary pointer page: 607, Index root page: 608 
    Total formats: 1, used formats: 1 
    Average record length: 140.04, total records: 171593 
    Average version length: 152.75, total versions: 13288, 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: 6, data page slots: 4464 
    Data pages: 4272, average fill: 84% 
    Primary pages: 4268, secondary pages: 4, swept pages: 5 
    Empty pages: 49, full pages: 4206 
    Fill distribution: 
     0 - 19% = 52 
    20 - 39% = 3 
    40 - 59% = 6 
    60 - 79% = 5 
    80 - 99% = 4206 
 
PERF_SPLIT_4 (285) 
    Primary pointer page: 609, Index root page: 610 
    Total formats: 1, used formats: 1 
    Average record length: 143.71, total records: 173005 
    Average version length: 151.41, total versions: 9061, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.80 
    Pointer pages: 6, data page slots: 5792 
    Data pages: 4336, average fill: 83% 
    Primary pages: 4333, secondary pages: 3, swept pages: 4 
    Empty pages: 71, full pages: 4235 
    Fill distribution: 
     0 - 19% = 79 
    20 - 39% = 6 
    40 - 59% = 9 
    60 - 79% = 7 
    80 - 99% = 4235 
 
PERF_SPLIT_5 (286) 
    Primary pointer page: 611, Index root page: 612 
    Total formats: 1, used formats: 1 
    Average record length: 142.10, total records: 170804 
    Average version length: 151.24, total versions: 10746, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.94 
    Pointer pages: 8, data page slots: 4856 
    Data pages: 4240, average fill: 84% 
    Primary pages: 4238, secondary pages: 2, swept pages: 2 
    Empty pages: 40, full pages: 4184 
    Fill distribution: 
     0 - 19% = 41 
    20 - 39% = 5 
    40 - 59% = 2 
    60 - 79% = 9 
    80 - 99% = 4183 
 
PERF_SPLIT_6 (287) 
    Primary pointer page: 613, Index root page: 614 
    Total formats: 1, used formats: 1 
    Average record length: 144.92, total records: 156251 
    Average version length: 149.52, total versions: 6632, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.70 
    Pointer pages: 6, data page slots: 4712 
    Data pages: 3920, average fill: 82% 
    Primary pages: 3917, secondary pages: 3, swept pages: 4 
    Empty pages: 75, full pages: 3824 
    Fill distribution: 
     0 - 19% = 81 
    20 - 39% = 6 
    40 - 59% = 7 
    60 - 79% = 1 
    80 - 99% = 3825 
 
PERF_SPLIT_7 (288) 
    Primary pointer page: 615, Index root page: 616 
    Total formats: 1, used formats: 1 
    Average record length: 144.26, total records: 176825 
    Average version length: 150.54, total versions: 8747, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.76 
    Pointer pages: 7, data page slots: 5024 
    Data pages: 4416, average fill: 83% 
    Primary pages: 4413, secondary pages: 3, swept pages: 1 
    Empty pages: 59, full pages: 4336 
    Fill distribution: 
     0 - 19% = 62 
    20 - 39% = 9 
    40 - 59% = 5 
    60 - 79% = 4 
    80 - 99% = 4336 
 
PERF_SPLIT_8 (289) 
    Primary pointer page: 617, Index root page: 618 
    Total formats: 1, used formats: 1 
    Average record length: 142.94, total records: 160645 
    Average version length: 151.19, total versions: 9154, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.87 
    Pointer pages: 7, data page slots: 4696 
    Data pages: 4016, average fill: 83% 
    Primary pages: 4015, secondary pages: 1, swept pages: 6 
    Empty pages: 59, full pages: 3925 
    Fill distribution: 
     0 - 19% = 67 
    20 - 39% = 7 
    40 - 59% = 3 
    60 - 79% = 14 
    80 - 99% = 3925 
 
PERF_SPLIT_9 (290) 
    Primary pointer page: 619, Index root page: 620 
    Total formats: 1, used formats: 1 
    Average record length: 145.35, total records: 158042 
    Average version length: 149.35, total versions: 6057, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.67 
    Pointer pages: 6, data page slots: 4824 
    Data pages: 3920, average fill: 83% 
    Primary pages: 3918, secondary pages: 2, swept pages: 1 
    Empty pages: 39, full pages: 3865 
    Fill distribution: 
     0 - 19% = 43 
    20 - 39% = 5 
    40 - 59% = 4 
    60 - 79% = 3 
    80 - 99% = 3865 
 
PHRASES (143) 
    Primary pointer page: 510, Index root page: 511 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index PHRASES_ID_DESC (3) 
    Root page: 1510376, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PHRASES_NAME (2) 
    Root page: 1510375, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PHRASES_UNQ (1) 
    Root page: 1510374, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PK_PHRASES (0) 
    Root page: 1510373, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
PSTORNED (147) 
    Primary pointer page: 518, Index root page: 519 
    Total formats: 1, used formats: 1 
    Average record length: 51.61, total records: 2105086 
    Average version length: 52.97, total versions: 54830, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 70.00, compression ratio: 1.36 
    Pointer pages: 16, data page slots: 25792 
    Data pages: 25792, average fill: 71% 
    Primary pages: 25778, secondary pages: 14, swept pages: 10097 
    Empty pages: 151, full pages: 22512 
    Fill distribution: 
     0 - 19% = 292 
    20 - 39% = 244 
    40 - 59% = 843 
    60 - 79% = 23881 
    80 - 99% = 532 
 
    Index PSTORNED_RCV_ID (1) 
    Root page: 1506208, depth: 3, leaf buckets: 2598, nodes: 2105086 
    Average node length: 5.44, total dup: 1964529, max dup: 1546 
    Average key length: 2.49, compression ratio: 3.62 
    Average prefix length: 8.58, average data length: 0.42 
    Clustering factor: 182274, ratio: 0.09 
    Fill distribution: 
         0 - 19% = 5 
        20 - 39% = 286 
        40 - 59% = 1742 
        60 - 79% = 277 
        80 - 99% = 288 
 
    Index PSTORNED_SND_ID (0) 
    Root page: 1504841, depth: 3, leaf buckets: 2754, nodes: 2105086 
    Average node length: 5.69, total dup: 1889806, max dup: 67 
    Average key length: 2.74, compression ratio: 3.29 
    Average prefix length: 8.36, average data length: 0.64 
    Clustering factor: 376425, ratio: 0.18 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 5 
        40 - 59% = 2380 
        60 - 79% = 348 
        80 - 99% = 21 
 
    Index PSTORNED_WORKER_ID (2) 
    Root page: 1508018, depth: 3, leaf buckets: 2106, nodes: 2105086 
    Average node length: 4.96, total dup: 2104986, max dup: 28570 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.41, average data length: 0.00 
    Clustering factor: 179819, ratio: 0.09 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 178 
        40 - 59% = 1073 
        60 - 79% = 397 
        80 - 99% = 457 
 
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: 2 
    Empty pages: 0, full pages: 2 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 1 
    60 - 79% = 0 
    80 - 99% = 2 
 
    Index SETTINGS_MCODE_WM_UNQ (1) 
    Root page: 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: 38.65, total records: 152174 
    Average version length: 69.19, total versions: 77248, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 3.26 
    Pointer pages: 3, data page slots: 4016 
    Data pages: 3360, average fill: 56% 
    Primary pages: 3360, secondary pages: 0, swept pages: 418 
    Empty pages: 652, full pages: 2081 
    Fill distribution: 
     0 - 19% = 970 
    20 - 39% = 188 
    40 - 59% = 81 
    60 - 79% = 735 
    80 - 99% = 1386 
 
    Index XQD_1000_1200_WA_SO_RO_WKR_SND (0) 
    Root page: 1554865, depth: 3, leaf buckets: 234, nodes: 152174 
    Average node length: 6.46, total dup: 132493, max dup: 17 
    Average key length: 3.94, compression ratio: 10.67 
    Average prefix length: 40.19, average data length: 1.81 
    Clustering factor: 26079, ratio: 0.17 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 41 
        40 - 59% = 118 
        60 - 79% = 63 
        80 - 99% = 10 
 
XQD_1000_3300 (178) 
    Primary pointer page: 581, Index root page: 582 
    Total formats: 1, used formats: 1 
    Average record length: 64.44, total records: 7371569 
    Average version length: 68.78, total versions: 556053, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.96 
    Pointer pages: 66, data page slots: 107472 
    Data pages: 107472, average fill: 74% 
    Primary pages: 107471, secondary pages: 1, swept pages: 10298 
    Empty pages: 31, full pages: 99591 
    Fill distribution: 
     0 - 19% = 176 
    20 - 39% = 749 
    40 - 59% = 2528 
    60 - 79% = 101052 
    80 - 99% = 2967 
 
    Index XQD_1000_3300_WA_SO_RO_WKR_SND (0) 
    Root page: 1480476, depth: 3, leaf buckets: 10763, nodes: 7371569 
    Average node length: 6.51, total dup: 6374609, max dup: 44 
    Average key length: 3.52, compression ratio: 11.93 
    Average prefix length: 40.61, average data length: 1.39 
    Clustering factor: 1701791, ratio: 0.23 
    Fill distribution: 
         0 - 19% = 12 
        20 - 39% = 1150 
        40 - 59% = 5876 
        60 - 79% = 3107 
        80 - 99% = 618 
 
    Index XQD_1000_3300_WKR_DOC_ASC (1) 
    Root page: 1486090, depth: 3, leaf buckets: 8640, nodes: 7371569 
    Average node length: 5.39, total dup: 7083503, max dup: 221 
    Average key length: 2.40, compression ratio: 7.09 
    Average prefix length: 16.64, average data length: 0.36 
    Clustering factor: 1500225, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 12 
        20 - 39% = 934 
        40 - 59% = 4820 
        60 - 79% = 1700 
        80 - 99% = 1174 
 
    Index XQD_1000_3300_WKR_DOC_DEC (2) 
    Root page: 1490630, depth: 3, leaf buckets: 8718, nodes: 7371569 
    Average node length: 5.39, total dup: 7083503, max dup: 221 
    Average key length: 2.40, compression ratio: 7.09 
    Average prefix length: 16.64, average data length: 0.36 
    Clustering factor: 1502500, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 5 
        20 - 39% = 1024 
        40 - 59% = 4843 
        60 - 79% = 1725 
        80 - 99% = 1121 
 
XQD_1200_2000 (177) 
    Primary pointer page: 579, Index root page: 580 
    Total formats: 1, used formats: 1 
    Average record length: 66.70, total records: 12205441 
    Average version length: 68.72, total versions: 454056, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.89 
    Pointer pages: 107, data page slots: 173680 
    Data pages: 173680, average fill: 75% 
    Primary pages: 173680, secondary pages: 0, swept pages: 45286 
    Empty pages: 4, full pages: 173098 
    Fill distribution: 
     0 - 19% = 4 
    20 - 39% = 11 
    40 - 59% = 136 
    60 - 79% = 169544 
    80 - 99% = 3985 
 
    Index XQD_1200_2000_WA_SO_RO_WKR_SND (0) 
    Root page: 1495050, depth: 3, leaf buckets: 18382, nodes: 12201461 
    Average node length: 6.62, total dup: 10633400, max dup: 66 
    Average key length: 3.43, compression ratio: 12.25 
    Average prefix length: 40.70, average data length: 1.30 
    Clustering factor: 2499266, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 31 
        20 - 39% = 1885 
        40 - 59% = 10771 
        60 - 79% = 4795 
        80 - 99% = 900 
 
XQD_2000_3300 (179) 
    Primary pointer page: 583, Index root page: 584 
    Total formats: 1, used formats: 1 
    Average record length: 42.34, total records: 2066804 
    Average version length: 69.05, total versions: 522549, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 2.98 
    Pointer pages: 27, data page slots: 42320 
    Data pages: 31687, average fill: 65% 
    Primary pages: 31609, secondary pages: 78, swept pages: 2842 
    Empty pages: 1123, full pages: 27681 
    Fill distribution: 
     0 - 19% = 1926 
    20 - 39% = 4431 
    40 - 59% = 2420 
    60 - 79% = 15151 
    80 - 99% = 7759 
 
    Index XQD_2000_3300_WA_SO_RO_WKR_SND (0) 
    Root page: 1479735, depth: 3, leaf buckets: 2030, nodes: 1668055 
    Average node length: 5.53, total dup: 1599966, max dup: 49 
    Average key length: 2.56, compression ratio: 16.43 
    Average prefix length: 41.48, average data length: 0.52 
    Clustering factor: 121840, ratio: 0.07 
    Fill distribution: 
         0 - 19% = 7 
        20 - 39% = 266 
        40 - 59% = 980 
        60 - 79% = 554 
        80 - 99% = 223 
 
XQD_2100_3300 (180) 
    Primary pointer page: 585, Index root page: 586 
    Total formats: 1, used formats: 1 
    Average record length: 32.93, total records: 1523965 
    Average version length: 69.04, total versions: 163767, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 3.83 
    Pointer pages: 18, data page slots: 29088 
    Data pages: 27128, average fill: 42% 
    Primary pages: 27127, secondary pages: 1, swept pages: 2823 
    Empty pages: 2882, full pages: 13206 
    Fill distribution: 
     0 - 19% = 7296 
    20 - 39% = 4790 
    40 - 59% = 5670 
    60 - 79% = 8916 
    80 - 99% = 456 
 
    Index XQD_2100_3300_WA_SO_RO_WKR_SND (0) 
    Root page: 1479229, depth: 3, leaf buckets: 1221, nodes: 771462 
    Average node length: 5.97, total dup: 709548, max dup: 64 
    Average key length: 3.03, compression ratio: 13.85 
    Average prefix length: 41.05, average data length: 0.95 
    Clustering factor: 111913, ratio: 0.15 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 395 
        40 - 59% = 621 
        60 - 79% = 200 
        80 - 99% = 5 
 
XQD_3300_3400 (181) 
    Primary pointer page: 587, Index root page: 588 
    Total formats: 1, used formats: 1 
    Average record length: 64.27, total records: 9353749 
    Average version length: 68.98, total versions: 713510, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.96 
    Pointer pages: 89, data page slots: 144832 
    Data pages: 144808, average fill: 70% 
    Primary pages: 144792, secondary pages: 16, swept pages: 28116 
    Empty pages: 318, full pages: 100585 
    Fill distribution: 
     0 - 19% = 845 
    20 - 39% = 3723 
    40 - 59% = 20250 
    60 - 79% = 112780 
    80 - 99% = 7210 
 
    Index XQD_3300_3400_WA_SO_RO_WKR_SND (0) 
    Root page: 1472612, depth: 3, leaf buckets: 13474, nodes: 9345233 
    Average node length: 6.69, total dup: 7751796, max dup: 23 
    Average key length: 3.66, compression ratio: 11.46 
    Average prefix length: 40.50, average data length: 1.50 
    Clustering factor: 2051962, ratio: 0.22 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 911 
        40 - 59% = 6941 
        60 - 79% = 4938 
        80 - 99% = 683 
 
XQS_1000_1200 (182) 
    Primary pointer page: 589, Index root page: 590 
    Total formats: 1, used formats: 1 
    Average record length: 82.48, total records: 21138971 
    Average version length: 82.98, total versions: 16647, 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: 319432 
    Data pages: 319432, average fill: 81% 
    Primary pages: 319428, secondary pages: 4, swept pages: 11529 
    Empty pages: 1, full pages: 319427 
    Fill distribution: 
     0 - 19% = 2 
    20 - 39% = 1 
    40 - 59% = 1 
    60 - 79% = 48106 
    80 - 99% = 271322 
 
    Index XQS_1000_1200_DOC_ID (1) 
    Root page: 1426738, depth: 3, leaf buckets: 19386, nodes: 21138971 
    Average node length: 5.72, total dup: 20658464, max dup: 131 
    Average key length: 2.16, compression ratio: 4.16 
    Average prefix length: 8.86, average data length: 0.14 
    Clustering factor: 3281290, ratio: 0.16 
    Fill distribution: 
         0 - 19% = 6 
        20 - 39% = 0 
        40 - 59% = 8199 
        60 - 79% = 514 
        80 - 99% = 10667 
 
    Index XQS_1000_1200_RCV_ID (3) 
    Root page: 1457002, depth: 3, leaf buckets: 17145, nodes: 21138971 
    Average node length: 6.31, total dup: 18576699, max dup: 49 
    Average key length: 2.75, compression ratio: 3.27 
    Average prefix length: 8.37, average data length: 0.63 
    Clustering factor: 917555, ratio: 0.04 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 2 
        40 - 59% = 745 
        60 - 79% = 280 
        80 - 99% = 16118 
 
    Index XQS_1000_1200_SND_ID (2) 
    Root page: 1441095, depth: 3, leaf buckets: 21139, nodes: 21138971 
    Average node length: 6.35, total dup: 18496515, max dup: 29 
    Average key length: 2.79, compression ratio: 3.23 
    Average prefix length: 8.34, average data length: 0.66 
    Clustering factor: 3575650, ratio: 0.17 
    Fill distribution: 
         0 - 19% = 5 
        20 - 39% = 0 
        40 - 59% = 8401 
        60 - 79% = 589 
        80 - 99% = 12144 
 
    Index XQS_1000_1200_WORKER_ID (0) 
    Root page: 1413370, depth: 3, leaf buckets: 16060, nodes: 21138971 
    Average node length: 5.56, total dup: 21138871, max dup: 232934 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.42, average data length: 0.00 
    Clustering factor: 946292, ratio: 0.04 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 9 
        40 - 59% = 2817 
        60 - 79% = 380 
        80 - 99% = 12853 
 
XQS_1000_3300 (184) 
    Primary pointer page: 593, Index root page: 594 
    Total formats: 1, used formats: 1 
    Average record length: 77.51, total records: 9733410 
    Average version length: 82.61, total versions: 648813, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.63 
    Pointer pages: 104, data page slots: 169224 
    Data pages: 169192, average fill: 72% 
    Primary pages: 169163, secondary pages: 29, swept pages: 47789 
    Empty pages: 526, full pages: 110404 
    Fill distribution: 
     0 - 19% = 1297 
    20 - 39% = 4131 
    40 - 59% = 20345 
    60 - 79% = 115342 
    80 - 99% = 28077 
 
    Index XQS_1000_3300_DOC_ID (1) 
    Root page: 1367524, depth: 3, leaf buckets: 11338, nodes: 9733410 
    Average node length: 5.37, total dup: 9424952, max dup: 245 
    Average key length: 2.23, compression ratio: 4.03 
    Average prefix length: 8.80, average data length: 0.20 
    Clustering factor: 2168770, ratio: 0.22 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 50 
        40 - 59% = 7976 
        60 - 79% = 3224 
        80 - 99% = 86 
 
    Index XQS_1000_3300_RCV_ID (3) 
    Root page: 1379283, depth: 3, leaf buckets: 13449, nodes: 9733410 
    Average node length: 6.24, total dup: 8068692, max dup: 14 
    Average key length: 3.10, compression ratio: 2.90 
    Average prefix length: 8.07, average data length: 0.93 
    Clustering factor: 1510229, ratio: 0.16 
    Fill distribution: 
         0 - 19% = 139 
        20 - 39% = 3748 
        40 - 59% = 4429 
        60 - 79% = 2601 
        80 - 99% = 2532 
 
    Index XQS_1000_3300_SND_ID (2) 
    Root page: 1373081, depth: 3, leaf buckets: 12654, nodes: 9733410 
    Average node length: 5.99, total dup: 8451930, max dup: 44 
    Average key length: 2.85, compression ratio: 3.16 
    Average prefix length: 8.29, average data length: 0.71 
    Clustering factor: 2365383, ratio: 0.24 
    Fill distribution: 
         0 - 19% = 5 
        20 - 39% = 52 
        40 - 59% = 8978 
        60 - 79% = 3508 
        80 - 99% = 111 
 
    Index XQS_1000_3300_WORKER_ID (0) 
    Root page: 1362789, depth: 3, leaf buckets: 10186, nodes: 9733410 
    Average node length: 5.14, total dup: 9733310, max dup: 164760 
    Average key length: 2.00, compression ratio: 1.20 
    Average prefix length: 2.41, average data length: 0.00 
    Clustering factor: 1532207, ratio: 0.16 
    Fill distribution: 
         0 - 19% = 46 
        20 - 39% = 1271 
        40 - 59% = 5019 
        60 - 79% = 1728 
        80 - 99% = 2122 
 
XQS_1200_2000 (183) 
    Primary pointer page: 591, Index root page: 592 
    Total formats: 1, used formats: 1 
    Average record length: 79.20, total records: 11436912 
    Average version length: 82.54, total versions: 484122, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.59 
    Pointer pages: 119, data page slots: 193512 
    Data pages: 192392, average fill: 73% 
    Primary pages: 192277, secondary pages: 115, swept pages: 59392 
    Empty pages: 1966, full pages: 150377 
    Fill distribution: 
     0 - 19% = 3460 
    20 - 39% = 5966 
    40 - 59% = 15889 
    60 - 79% = 97427 
    80 - 99% = 69650 
 
    Index XQS_1200_2000_DOC_ID (1) 
    Root page: 1392123, depth: 3, leaf buckets: 13122, nodes: 11436912 
    Average node length: 5.31, total dup: 11327120, max dup: 650 
    Average key length: 2.08, compression ratio: 4.33 
    Average prefix length: 8.93, average data length: 0.07 
    Clustering factor: 2392352, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 150 
        40 - 59% = 8662 
        60 - 79% = 4144 
        80 - 99% = 165 
 
    Index XQS_1200_2000_RCV_ID (3) 
    Root page: 1406132, depth: 3, leaf buckets: 10541, nodes: 11436912 
    Average node length: 5.51, total dup: 10938349, max dup: 49 
    Average key length: 2.28, compression ratio: 3.95 
    Average prefix length: 8.77, average data length: 0.23 
    Clustering factor: 729526, ratio: 0.06 
    Fill distribution: 
         0 - 19% = 159 
        20 - 39% = 791 
        40 - 59% = 2615 
        60 - 79% = 1834 
        80 - 99% = 5142 
 
    Index XQS_1200_2000_SND_ID (2) 
    Root page: 1398660, depth: 3, leaf buckets: 15010, nodes: 11436912 
    Average node length: 6.04, total dup: 9985783, max dup: 75 
    Average key length: 2.80, compression ratio: 3.21 
    Average prefix length: 8.32, average data length: 0.68 
    Clustering factor: 2408761, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 173 
        40 - 59% = 10165 
        60 - 79% = 4485 
        80 - 99% = 185 
 
    Index XQS_1200_2000_WORKER_ID (0) 
    Root page: 1386233, depth: 3, leaf buckets: 10879, nodes: 11436912 
    Average node length: 5.24, total dup: 11436812, max dup: 201218 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.41, average data length: 0.00 
    Clustering factor: 717714, ratio: 0.06 
    Fill distribution: 
         0 - 19% = 85 
        20 - 39% = 798 
        40 - 59% = 4901 
        60 - 79% = 1489 
        80 - 99% = 3606 
 
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: 78.01, total records: 9829983 
    Average version length: 82.91, total versions: 630394, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.62 
    Pointer pages: 107, data page slots: 173688 
    Data pages: 173648, average fill: 71% 
    Primary pages: 173620, secondary pages: 28, swept pages: 53570 
    Empty pages: 632, full pages: 108733 
    Fill distribution: 
     0 - 19% = 1753 
    20 - 39% = 6110 
    40 - 59% = 22347 
    60 - 79% = 116303 
    80 - 99% = 27135 
 
    Index XQS_2100_3300_DOC_ID (1) 
    Root page: 1344708, depth: 3, leaf buckets: 11831, nodes: 9829983 
    Average node length: 5.17, total dup: 9801117, max dup: 1538 
    Average key length: 2.03, compression ratio: 4.43 
    Average prefix length: 8.97, average data length: 0.03 
    Clustering factor: 1967246, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 39 
        20 - 39% = 1460 
        40 - 59% = 7800 
        60 - 79% = 1929 
        80 - 99% = 603 
 
    Index XQS_2100_3300_RCV_ID (3) 
    Root page: 1355739, depth: 3, leaf buckets: 13487, nodes: 9829983 
    Average node length: 6.24, total dup: 8148837, max dup: 14 
    Average key length: 3.10, compression ratio: 2.90 
    Average prefix length: 8.07, average data length: 0.93 
    Clustering factor: 1471778, ratio: 0.15 
    Fill distribution: 
         0 - 19% = 172 
        20 - 39% = 3715 
        40 - 59% = 4283 
        60 - 79% = 2606 
        80 - 99% = 2711 
 
    Index XQS_2100_3300_SND_ID (2) 
    Root page: 1350071, depth: 3, leaf buckets: 12482, nodes: 9829983 
    Average node length: 5.43, total dup: 9391345, max dup: 97 
    Average key length: 2.29, compression ratio: 3.94 
    Average prefix length: 8.76, average data length: 0.24 
    Clustering factor: 2102909, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 34 
        20 - 39% = 1435 
        40 - 59% = 8779 
        60 - 79% = 1655 
        80 - 99% = 579 
 
    Index XQS_2100_3300_WORKER_ID (0) 
    Root page: 987843, depth: 3, leaf buckets: 10269, nodes: 9829983 
    Average node length: 5.14, total dup: 9829883, max dup: 167191 
    Average key length: 2.00, compression ratio: 1.20 
    Average prefix length: 2.41, average data length: 0.00 
    Clustering factor: 1542867, ratio: 0.16 
    Fill distribution: 
         0 - 19% = 42 
        20 - 39% = 1251 
        40 - 59% = 5144 
        60 - 79% = 1689 
        80 - 99% = 2143 
 
XQS_3300_3400 (187) 
    Primary pointer page: 599, Index root page: 600 
    Total formats: 1, used formats: 1 
    Average record length: 67.40, total records: 575289 
    Average version length: 68.81, total versions: 7423, 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: 5, data page slots: 8080 
    Data pages: 8080, average fill: 75% 
    Primary pages: 8080, secondary pages: 0, swept pages: 3178 
    Empty pages: 2, full pages: 7063 
    Fill distribution: 
     0 - 19% = 2 
    20 - 39% = 16 
    40 - 59% = 198 
    60 - 79% = 7752 
    80 - 99% = 112 
 
    Index XQS_3300_3400_DOC_ID (1) 
    Root page: 43314, depth: 3, leaf buckets: 746, nodes: 575289 
    Average node length: 5.95, total dup: 489642, max dup: 111 
    Average key length: 3.09, compression ratio: 2.91 
    Average prefix length: 8.05, average data length: 0.95 
    Clustering factor: 101174, ratio: 0.18 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 29 
        40 - 59% = 541 
        60 - 79% = 97 
        80 - 99% = 79 
 
    Index XQS_3300_3400_SND_ID (2) 
    Root page: 33287, depth: 3, leaf buckets: 769, nodes: 575289 
    Average node length: 6.15, total dup: 471722, max dup: 29 
    Average key length: 3.30, compression ratio: 2.73 
    Average prefix length: 7.88, average data length: 1.12 
    Clustering factor: 101230, ratio: 0.18 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 31 
        40 - 59% = 553 
        60 - 79% = 102 
        80 - 99% = 83 
 
    Index XQS_3300_3400_WORKER_ID (0) 
    Root page: 377587, depth: 2, leaf buckets: 566, nodes: 575289 
    Average node length: 4.86, total dup: 575189, max dup: 9500 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.42, average data length: 0.00 
    Clustering factor: 89857, ratio: 0.16 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 27 
        40 - 59% = 330 
        60 - 79% = 88 
        80 - 99% = 120 
 
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 Fri Mar  1 13:09:39 2024

Record versions statistics, table

TABLE_NAME TOTAL_RECS TOTAL_VERS MAX_VERSIONS VERS_TO_RECS_PRC MAXV_TO_VERS_PRC
DOC_DATA 7776859 134559 1 0.0000 0.0000
DOC_LIST 2253997 71045 2 0.0000 0.0000
FB_ERRORS 2182 757 1 0.0000 0.0000
INVNT_SALDO 400 3725 11 900.0000 0.0000
INVNT_TURNOVER_LOG 74147 72421 1 0.0000 0.0000
MONEY_SALDO 49 404 13 800.0000 0.0000
MONEY_TURNOVER_LOG 1891 1794 1 0.0000 0.0000
PDISTR 839460 34904 2 0.0000 0.0000
PERF_SPLIT_0 161198 5648 1 0.0000 0.0000
PERF_SPLIT_1 130178 3745 1 0.0000 0.0000
PERF_SPLIT_2 150776 7506 1 0.0000 0.0000
PERF_SPLIT_3 171593 13288 1 0.0000 0.0000
PERF_SPLIT_4 173005 9061 1 0.0000 0.0000
PERF_SPLIT_5 170804 10746 1 0.0000 0.0000
PERF_SPLIT_6 156251 6632 1 0.0000 0.0000
PERF_SPLIT_7 176825 8747 1 0.0000 0.0000
PERF_SPLIT_8 160645 9154 1 0.0000 0.0000
PERF_SPLIT_9 158042 6057 1 0.0000 0.0000
PSTORNED 2105086 54830 1 0.0000 0.0000
SEMAPHORES 5 1 1 0.0000 100.0000
XQD_1000_1200 152174 77248 1 0.0000 0.0000
XQD_1000_3300 7371569 556053 1 0.0000 0.0000
XQD_1200_2000 12205441 454056 1 0.0000 0.0000
XQD_2000_3300 2066804 522549 1 0.0000 0.0000
XQD_2100_3300 1523965 163767 1 0.0000 0.0000
XQD_3300_3400 9353749 713510 1 0.0000 0.0000
XQS_1000_1200 21138971 16647 1 0.0000 0.0000
XQS_1000_3300 9733410 648813 1 0.0000 0.0000
XQS_1200_2000 11436912 484122 1 0.0000 0.0000
XQS_2100_3300 9829983 630394 1 0.0000 0.0000
XQS_3300_3400 575289 7423 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 ---
:28: 
:29: mscs-test-161.budzdorov.ru    Fri Mar  1 13:08:05 2024
:30:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3400
:31: 
--- end of diff output ---

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

01.03.24 13:09:51. 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-03-01 13:09:54 No severe PSQL-related problems occured
01.03.24 13:09:55. End of report.