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

Hardware and OS info

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

Server and database settinfs 


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

Test configuration settings 

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

Test finish info 


FINISH_STATE                    NORMAL: TEST_TIME EXPIRED AT 2024-03-24 01:09:37
DTS_END                         2024-03-24 01:09:37.8240
FB_GDSCODE                      -1
FB_MNEMONA                      
STACK                           SP_RESERVE_WRITE_OFF(34:5) ==> SP_CHECK_TO_STOP_WORK(32:12) ==> SP_HALT_ON_ERROR(57:17)
IP                              ::1/46546
TRN_ID                          184180
ATT_ID                          557
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: 8949.38 20436 894938
customer order: creation 186.35 345 18635
customer order: refuse 15.74 378 1574
order to supplier: creation 50.18 1304 5018
order to supplier: removal 3.37 98518 337
invoice (draft): creation 48.90 3438 4890
invoice (draft): removal 45.89 782 4589
invoice accept: apply 44.25 21297 4425
invoice accept: cancel 41.43 950 4143
customer reserve: creation 4184.26 208 418426
customer reserve: removal 4030.69 67 403069
realization accept: apply 90.14 212 9014
realization accept: cancel 70.04 125 7004
payment from customer: creation 63.12 119 6312
payment from customer: removal 6.41 96 641
payment to supplier: creation 52.56 141 5256
payment to supplier: removal 3.80 99 380
service: total inventory turnovers 4.72 1193 472
service: total monetary turnovers 6.55 24 655
service: aggregate perf. data 0.95 16061 95
service: refresh index statistics 0.03 263355 3

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:02, from 24-03-2024 01:10:48 to 24-03-2024 01:10:50.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 2449
TEST_TIME 2 3358
TEST_TIME 3 3122
TEST_TIME 4 3999
TEST_TIME 5 4350
TEST_TIME 6 4552
TEST_TIME 7 4415
TEST_TIME 8 4744
TEST_TIME 9 5107
TEST_TIME 10 5108
TEST_TIME 11 5025
TEST_TIME 12 5153
TEST_TIME 13 5075
TEST_TIME 14 5393
TEST_TIME 15 5621
TEST_TIME 16 6012
TEST_TIME 17 5901
TEST_TIME 18 6160
TEST_TIME 19 6215
TEST_TIME 20 6207
TEST_TIME 21 6817
TEST_TIME 22 6874
TEST_TIME 23 7007
TEST_TIME 24 7146
TEST_TIME 25 7393
TEST_TIME 26 7555
TEST_TIME 27 7493
TEST_TIME 28 7882
TEST_TIME 29 8312
TEST_TIME 30 8757
TEST_TIME 31 8658
TEST_TIME 32 8605
TEST_TIME 33 8558
TEST_TIME 34 8852
TEST_TIME 35 8731
TEST_TIME 36 8543
TEST_TIME 37 8541
TEST_TIME 38 8426
TEST_TIME 39 8469
TEST_TIME 40 8408
TEST_TIME 41 8413
TEST_TIME 42 8558
TEST_TIME 43 8537
TEST_TIME 44 8475
TEST_TIME 45 8555
TEST_TIME 46 8530
TEST_TIME 47 8556
TEST_TIME 48 8736
TEST_TIME 49 8697
TEST_TIME 50 8658
TEST_TIME 51 8727
TEST_TIME 52 8817
TEST_TIME 53 8795
TEST_TIME 54 8822
TEST_TIME 55 8837
TEST_TIME 56 8996
TEST_TIME 57 8984
TEST_TIME 58 8922
TEST_TIME 59 9043
TEST_TIME 60 9132
TEST_TIME 61 9147
TEST_TIME 62 9030
TEST_TIME 63 8926
TEST_TIME 64 8944
TEST_TIME 65 8934
TEST_TIME 66 8871
TEST_TIME 67 8845
TEST_TIME 68 8795
TEST_TIME 69 8686
TEST_TIME 70 8770
TEST_TIME 71 8755
TEST_TIME 72 8777
TEST_TIME 73 8807
TEST_TIME 74 8793
TEST_TIME 75 8880
TEST_TIME 76 8903
TEST_TIME 77 8941
TEST_TIME 78 8900
TEST_TIME 79 8987
TEST_TIME 80 9023
TEST_TIME 81 9044
TEST_TIME 82 9018
TEST_TIME 83 9017
TEST_TIME 84 9062
TEST_TIME 85 9047
TEST_TIME 86 8974
TEST_TIME 87 8946
TEST_TIME 88 8951
TEST_TIME 89 8963
TEST_TIME 90 8961
TEST_TIME 91 8904
TEST_TIME 92 8852
TEST_TIME 93 8873
TEST_TIME 94 8869
TEST_TIME 95 8884
TEST_TIME 96 8864
TEST_TIME 97 8888
TEST_TIME 98 8934
TEST_TIME 99 8976
TEST_TIME 100 8950

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:03, from 24-03-2024 01:10:52 to 24-03-2024 01:10:55.

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 1277750 1277750 0 0.00 0 27170 7 0 0
doc_list_biud 1277749 1277749 0 0.00 0 34587 27 0 0
sp_add_invoice_to_stock 4501 4425 76 1.68 22 201144 21297 0 76
sp_cancel_adding_invoice 4143 4143 0 0.00 4 64573 951 0 0
sp_cancel_client_order 1574 1574 0 0.00 4 10103 378 0 0
sp_cancel_customer_reserve 403069 403069 0 0.00 0 34592 67 0 0
sp_cancel_pay_from_customer 641 641 0 0.00 3 6322 96 0 0
sp_cancel_pay_to_supplier 380 380 0 0.00 3 8590 100 0 0
sp_cancel_supplier_invoice 4589 4589 0 0.00 1 20582 783 0 0
sp_cancel_supplier_order 337 337 0 0.00 7 938171 98519 0 0
sp_cancel_write_off 7004 7004 0 0.00 1 16076 126 0 0
sp_client_order 18635 18635 0 0.00 3 28789 346 0 0
sp_customer_reserve 418426 418426 0 0.00 0 58029 208 0 0
sp_fill_shopping_cart 28519 28519 0 0.00 1 18835 38 0 0
sp_fill_shopping_cart_clo_res 418424 418424 0 0.00 0 22627 15 0 0
sp_get_clo_for_invoice 4423 4423 0 0.00 0 22560 277 0 0
sp_kill_cost_storno 12168 12168 0 0.00 0 15838 61 0 0
sp_kill_qstorno_ret_qs2qd 818068 818068 0 0.00 0 34569 36 0 0
sp_kill_qty_storno 434153 434153 0 0.00 0 34587 78 0 0
sp_lock_selected_doc 18648 18648 0 0.00 0 9310 7 0 0
sp_make_cost_storno 25005 25005 0 0.00 0 25672 69 0 0
sp_multiply_rows_for_pdistr 25005 25005 0 0.00 0 19126 28 0 0
sp_multiply_rows_for_qdistr 18635 18635 0 0.00 0 12162 140 0 0
sp_pay_from_customer 6312 6312 0 0.00 4 22957 119 0 0
sp_pay_to_supplier 5256 5256 0 0.00 5 19232 141 0 0
sp_payment_common 11568 11568 0 0.00 2 22503 40 0 0
sp_qd_handle_on_cancel_clo 1574 1574 0 0.00 0 10090 349 0 0
sp_qd_handle_on_invoice_upd_sts 8566 8566 0 0.00 0 31777 335 0 0
sp_qd_handle_on_reserve_upd_sts 9014 9014 0 0.00 0 28111 76 0 0
sp_reserve_write_off 9014 9014 0 0.00 5 28130 212 0 0
sp_supplier_invoice 4890 4890 0 0.00 6 102960 3439 0 0
sp_supplier_order 5018 5018 0 0.00 5 32911 1304 0 0
srv_aggregate_perf_data 96 95 1 1.04 1854 120270 16061 0 1
srv_fill_mon_cache_memory 60 60 0 0.00 3446 99909 33901 0 0
srv_find_qd_qs_mism 849669 849669 0 0.00 0 21674 7 0 0
srv_make_invnt_saldo 472 472 0 0.00 46 52242 1194 0 0
srv_make_money_saldo 655 655 0 0.00 0 690 24 0 0
srv_recalc_idx_stat 3 3 0 0.00 194148 361064 263355 0 0
t$perf-abend:sp_add_invoice_to_stock 76 76 0 0.00 0 0 0 0 0
t$perf-abend:srv_aggregate_perf_data 1 1 0 0.00 0 0 0 0 0
t$perf-norm:sp_add_invoice_to_stock 4425 4425 0 0.00 0 7553 162 0 0
t$perf-norm:sp_cancel_adding_invoice 371 371 0 0.00 0 1740 63 0 0
t$perf-norm:sp_cancel_client_order 1574 1574 0 0.00 0 9398 24 0 0
t$perf-norm:sp_cancel_customer_reserve 619 619 0 0.00 0 3120 13 0 0
t$perf-norm:sp_cancel_pay_from_customer 641 641 0 0.00 0 1307 3 0 0
t$perf-norm:sp_cancel_pay_to_supplier 380 380 0 0.00 0 606 3 0 0
t$perf-norm:sp_cancel_supplier_invoice 357 357 0 0.00 0 1319 17 0 0
t$perf-norm:sp_cancel_supplier_order 337 337 0 0.00 0 24039 1582 0 0
t$perf-norm:sp_cancel_write_off 932 932 0 0.00 0 5513 12 0 0
t$perf-norm:sp_client_order 18635 18635 0 0.00 0 11287 16 0 0
t$perf-norm:sp_customer_reserve 918 918 0 0.00 0 2431 8 0 0
t$perf-norm:sp_pay_from_customer 6312 6312 0 0.00 0 7795 11 0 0
t$perf-norm:sp_pay_to_supplier 5256 5256 0 0.00 0 17241 13 0 0
t$perf-norm:sp_reserve_write_off 9014 9014 0 0.00 0 7104 11 0 0
t$perf-norm:sp_supplier_invoice 4890 4890 0 0.00 0 14099 24 0 0
t$perf-norm:sp_supplier_order 5018 5018 0 0.00 0 8434 18 0 0
t$perf-norm:srv_aggregate_perf_data 95 95 0 0.00 0 266 6 0 0
t$perf-norm:srv_fill_mon_cache_memory 60 60 0 0.00 0 3 0 0 0
t$perf-norm:srv_make_invnt_saldo 472 472 0 0.00 0 5434 31 0 0
t$perf-norm:srv_make_money_saldo 655 655 0 0.00 0 978 17 0 0
t$perf-norm:srv_recalc_idx_stat 3 3 0 0.00 2 21 8 0 0
v_add_invoice_to_stock 8998 8846 152 1.68 0 6155 16 0 152
v_all_customers 34206 34206 0 0.00 0 102 1 0 0
v_all_suppliers 27554 27554 0 0.00 0 21 1 0 0
v_all_wares 37264 37264 0 0.00 0 27 1 0 0
v_cancel_adding_invoice 742 742 0 0.00 0 1079 7 0 0
v_cancel_client_order 3148 3148 0 0.00 0 3972 5 0 0
v_cancel_customer_prepayment 1282 1282 0 0.00 0 1889 5 0 0
v_cancel_customer_reserve 1238 1238 0 0.00 0 2296 5 0 0
v_cancel_payment_to_supplier 760 760 0 0.00 0 7954 15 0 0
v_cancel_supplier_invoice 714 714 0 0.00 0 1913 16 0 0
v_cancel_supplier_order 674 674 0 0.00 0 5836 17 0 0
v_cancel_write_off 1864 1864 0 0.00 0 7720 16 0 0
v_max_id_clo_ord 5008 5008 0 0.00 0 581 1 0 0
v_max_id_clo_res 918 918 0 0.00 0 1591 8 0 0
v_max_id_ord_sup 4879 4879 0 0.00 0 4906 3 0 0
v_max_non_paid_invoice 1366 1366 0 0.00 0 857 4 0 0
v_max_non_paid_realizn 3227 3227 0 0.00 0 1721 5 0 0
v_min_id_clo_ord 5008 5008 0 0.00 0 8270 13 0 0
v_min_id_clo_res 918 918 0 0.00 0 4956 14 0 0
v_min_id_ord_sup 4879 4879 0 0.00 0 7377 4 0 0
v_min_non_paid_invoice 5256 5256 0 0.00 0 18191 27 0 0
v_min_non_paid_realizn 6312 6312 0 0.00 0 21914 32 0 0
v_our_firm 9228 9228 0 0.00 0 23 1 0 0
v_reserve_write_off 18028 18028 0 0.00 0 9068 7 0 0
x_lock_depdocs_on_canc_invoice 8375 8375 0 0.00 0 21069 159 0 0
x_lock_depdocs_on_canc_sup_ord 337 337 0 0.00 0 18501 412 0 0
x_make_qstorno_1000_1200 5018 5018 0 0.00 1 32883 1221 0 0
x_make_qstorno_1200_2000 4890 4890 0 0.00 2 102932 3296 0 0
x_make_qstorno_2100_3300 418426 418426 0 0.00 0 58027 191 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 24-03-2024 01:10:56 to 24-03-2024 01:11:00.

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
23:09:41 6 8192000000 8799009520 8810303488 5304288 0.064 2 1 2 0 5403888 56816 42784
23:10:42 34060 8192000000 9905409216 10214158336 981182752 10.696 100 90 181 0 1011334176 6227888 23923536
23:12:23 19153 8192000000 9935414784 10258272256 1019878016 11.071 100 82 164 0 1049158448 8185120 21095312
23:13:51 19109 8192000000 9991578944 10323742720 1067556448 11.529 100 81 162 0 1096548864 9537232 19455184
23:15:13 8529 8192000000 10022857776 10371469312 1112860496 11.959 100 77 154 0 1142124880 10947920 18316464
23:16:24 5043 8192000000 10073828480 10431967232 1163165568 12.433 100 77 151 0 1192577200 12069856 17341776
23:17:33 2102 8192000000 10123073632 10490601472 1214716880 12.913 100 85 165 2 1246014912 12999376 18298656
23:18:37 2057 8192000000 10157740032 10536529920 1249358832 13.232 100 78 150 0 1279241488 12970944 16911712
23:19:42 1124 8192000000 10188897088 10568531968 1277879520 13.494 100 87 175 0 1312160208 14633328 19647360
23:20:44 1094 8192000000 10218745408 10603864064 1303490448 13.727 100 90 181 2 1336807776 14193408 19123920
23:21:46 23361 8192000000 10183367136 10602598400 1303836720 13.730 100 27 54 0 1317206400 7008400 6361280
23:23:12 7466 8192000000 10203226448 10614644736 1311146736 13.796 100 25 51 0 1323267024 6238816 5881472
23:24:20 8193 8192000000 10206112112 10620755968 1318425904 13.862 100 19 38 0 1328503104 5359488 4717712
23:25:29 9672 8192000000 10210407440 10628247552 1323799328 13.911 100 16 32 0 1333370544 6166320 3404896
23:26:41 12597 8192000000 10213844720 10633818112 1324239104 13.915 100 31 62 0 1337173584 5246864 7687616
23:27:58 5650 8192000000 10220930240 10636193792 1321546880 13.891 100 33 67 0 1335633136 6720032 7366224
23:29:04 9029 8192000000 10204308560 10626342912 1310743600 13.793 99 22 44 0 1320793184 5603856 4445728
23:30:23 38958 8192000000 10230402096 10636648448 1313098448 13.814 99 52 101 2 1332865408 8293920 11473040
23:32:07 99909 8192000000 10219314224 10633502720 1303953728 13.731 99 44 86 0 1324137712 9877632 10306352
23:34:54 57034 8192000000 10199450384 10600906752 1236261248 13.112 93 33 67 0 1254528384 10549616 7717520
23:36:55 10114 8192000000 10230753216 10637930496 1314792256 13.830 99 54 108 1 1338846368 12037600 12016512
23:38:16 4104 8192000000 10230170912 10630463488 1312650816 13.810 100 52 105 2 1337257696 12312624 12294256
23:39:22 9083 8192000000 10212012640 10621612032 1309717232 13.784 100 29 56 0 1329366384 13520384 6128768
23:40:35 17140 8192000000 10216417824 10609508352 1291104976 13.614 99 49 97 1 1318645136 16740880 10799280
23:42:01 13499 8192000000 10229185248 10625421312 1289721008 13.602 98 52 104 0 1319754000 17772112 12260880
23:43:18 5922 8192000000 10232646800 10630148096 1291752384 13.620 98 56 110 0 1329534768 23966128 13816256
23:44:33 3860 8192000000 10260814256 10655633408 1326869648 13.939 100 70 138 1 1369394336 25597376 16927312
23:45:43 3446 8192000000 10271381664 10677297152 1347181888 14.122 100 51 98 0 1380462608 21035344 12245376
23:46:52 9780 8192000000 10283087232 10679615488 1344271216 14.096 100 70 139 1 1385799904 25044672 16484016
23:48:17 7086 8192000000 10286237344 10693992448 1354657712 14.189 100 61 122 2 1397299680 28136336 14505632
23:49:34 5604 8192000000 10312021680 10719670272 1365827152 14.290 100 62 122 0 1414434336 33248448 15358736
23:50:45 9489 8192000000 10314907248 10735988736 1382289136 14.437 100 51 100 1 1426486672 31124144 13073392
23:52:07 3770 8192000000 10336486992 10751913984 1397278432 14.571 100 62 122 0 1441015824 27194928 16542464
23:53:14 7385 8192000000 10336668832 10759917568 1402649104 14.619 100 41 82 0 1444567680 30805440 11113136
23:54:40 11831 8192000000 10342383920 10775085056 1411250320 14.695 100 30 60 0 1447236832 27971616 8014896
23:56:05 17716 8192000000 10332221792 10773991424 1410170784 14.685 100 23 46 0 1441110144 24436080 6503280
23:57:27 21905 8192000000 10317567216 10761924608 1393927488 14.541 100 18 37 0 1429142112 29609200 5605424
23:59:06 21058 8192000000 10305688704 10767568896 1395700176 14.557 100 16 32 0 1426624512 26691648 4232688
00:00:28 25190 8192000000 10315161280 10755624960 1396992448 14.568 100 24 47 0 1417285072 14588096 5704528
00:02:01 5436 8192000000 10333517456 10766708736 1406043296 14.649 100 47 94 0 1429171136 12887312 10240528
00:03:10 78336 8192000000 10317638208 10762014720 1404972848 14.639 100 8 16 0 1418783488 12165104 1645536
00:05:50 43870 8192000000 10329668128 10767409152 1407265424 14.660 100 41 79 0 1425382320 8168352 9948544
00:07:37 43987 8192000000 10309425632 10761924608 1389230976 14.499 99 28 54 0 1404250720 8076976 6942768
00:09:23 10108 8192000000 10317029120 10759684096 1394870896 14.549 99 42 84 1 1415893840 11523504 9499440
00:10:35 21100 8192000000 10334484944 10782130176 1412831136 14.709 100 52 102 0 1445101872 20723504 11547232
00:12:02 67050 8192000000 10306274352 10763051008 1381269504 14.428 98 15 30 0 1404672256 20037760 3364992
00:14:19 10300 8192000000 10306671312 10752684032 1382003152 14.434 99 23 44 1 1407420416 19839568 5577696
00:15:32 26113 8192000000 10308891440 10757017600 1397988160 14.577 100 34 69 1 1418762304 12343232 8430912
00:17:30 42092 8192000000 10288616512 10740699136 1355871424 14.200 98 13 26 0 1369789840 10970656 2947760
00:19:17 31022 8192000000 10279622240 10723229696 1369604992 14.324 99 52 104 0 1393298208 11197952 12495264
00:20:50 14600 8192000000 10265172928 10708013056 1336788560 14.028 98 11 22 0 1350016288 10835616 2392112
00:22:09 67287 8192000000 10273367248 10703499264 1280769488 13.520 94 13 26 0 1299530240 15583792 3176960
00:24:17 24359 8192000000 10262692160 10695626752 1331399344 13.980 99 43 86 0 1351993904 11064608 9529952
00:25:42 55672 8192000000 10217275392 10644049920 1249001520 13.229 94 25 50 0 1269421664 14390528 6029616
00:27:39 38912 8192000000 10253270080 10680709120 1311241184 13.797 99 39 78 0 1339606608 19698816 8666608
00:29:19 38533 8192000000 10239773776 10696278016 1323436480 13.908 100 12 22 1 1348937840 23151056 2350304
00:31:00 82786 8192000000 10243975872 10677100544 1330681184 13.973 100 25 50 0 1349925344 13728896 5515264
00:33:27 19876 8192000000 10236296720 10667388928 1315359040 13.835 99 51 100 0 1339480768 12550560 11571168
00:35:24 48373 8192000000 10215481776 10659446784 1301055248 13.705 98 11 22 0 1310904048 7645472 2203328
00:37:13 70695 8192000000 10235751184 10681798656 1338841680 14.047 100 13 26 0 1351982576 10015584 3125312
00:39:25 66278 8192000000 10254535616 10707197952 1354509344 14.188 100 12 24 0 1365015488 7939616 2566528
00:41:32 29463 8192000000 10265780832 10718789632 1353773360 14.181 99 13 26 0 1368046112 11546560 2726192
00:43:08 24035 8192000000 10285512320 10730754048 1369463024 14.322 99 27 50 1 1381390048 6617488 5309536
00:44:34 53879 8192000000 10296407808 10750869504 1381254800 14.428 99 19 38 0 1398149872 12653984 4241088
00:46:29 32270 8192000000 10307377232 10756411392 1394478800 14.546 100 23 47 0 1408324576 8958144 4887632
00:48:02 24994 8192000000 10325334640 10762223616 1397264848 14.571 100 43 86 0 1422620416 15954192 9401376
00:49:35 84098 8192000000 10306666352 10769575936 1399139792 14.587 100 15 30 0 1415631792 13403056 3088944
00:52:00 10710 8192000000 10312102576 10749812736 1381609808 14.431 99 60 119 0 1404319984 9621104 13089072
00:53:11 54837 8192000000 10307093328 10758770688 1385200624 14.463 99 27 54 1 1406072608 14970400 5901584
00:55:08 78059 8192000000 10292734736 10741989376 1344711472 14.100 96 38 76 0 1361703472 8329344 8662656
00:57:29 38666 8192000000 10289103456 10748583936 1383795264 14.450 100 23 46 0 1402717920 13974320 4948336
00:59:08 67570 8192000000 10252342848 10707976192 1315156560 13.833 95 10 20 0 1328330160 11063616 2109984
01:01:17 56711 8192000000 10262182640 10719010816 1369151408 14.319 99 12 24 0 1379056000 7231312 2673280
01:03:30 30952 8192000000 10263420512 10715492352 1332192608 13.987 97 15 30 0 1343940448 8480064 3267776
01:05:01 51376 8192000000 10261604848 10706264064 1322067344 13.895 97 18 33 0 1339996672 14059488 3869840
01:06:53 35475 8192000000 10266694112 10703609856 1308522288 13.773 96 22 44 0 1326545424 12681216 5341920
01:08:45 50215 8192000000 10281132864 10721505280 1334305520 14.006 98 27 54 0 1355564656 15041616 6217520

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:14, from 24-03-2024 01:11:02 to 24-03-2024 01:11:16.

Exceptions occured during test was in run

FB_MNEMONA CNT UNIT FB_GDSCODE
except 1 srv_aggregate_perf_data 335544517
except 76 v_add_invoice_to_stock 335544517

Completed "Exceptions occured during test was in run". Done for 00:00:02, from 24-03-2024 01:11:17 to 24-03-2024 01:11:19.

Content of mon$database and FB version 


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


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

Database statistics 

 
Database "/home/bases/oltp30-etalone.fdb" 
Gstat execution time Sun Mar 24 01:11:20 2024 
 
Database header page information: 
    Flags            0 
    Generation        96228 
    System Change Number    0 
    Page size        8192 
    ODS version        12.0 
    Oldest transaction    181788 
    Oldest active        184358 
    Oldest snapshot        184358 
    Next transaction    184359 
    Sequence number        0 
    Next attachment ID    734 
    Implementation        HW=AMD/Intel/x64 little-endian OS=Linux CC=gcc 
    Shadow count        0 
    Page buffers        0 
    Next header page    0 
    Database dialect    3 
    Creation date        Apr 3, 2020 16:41:55 
    Attributes        force write 
 
    Variable header data: 
    Sweep interval:        0 
    Unrecognized option 11, length 16 
    *END* 
 
 
Database file sequence: 
File /home/bases/oltp30-etalone.fdb is the only file 
 
Analyzing database pages ... 
AGENTS (150) 
    Primary pointer page: 496, Index root page: 497 
    Total formats: 1, used formats: 1 
    Average record length: 33.60, total records: 50 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 344.00, compression ratio: 10.24 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 31% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 1 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index AGENTS_ID_DESC (2) 
    Root page: 1504311, depth: 1, leaf buckets: 1, nodes: 50 
    Average node length: 11.82, total dup: 0, max dup: 0 
    Average key length: 10.80, compression ratio: 0.83 
    Average prefix length: 1.18, average data length: 7.82 
    Clustering factor: 1, ratio: 0.02 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index AGENTS_IS_OUR_FIRM (4) 
    Root page: 1504313, depth: 1, leaf buckets: 1, nodes: 50 
    Average node length: 3.08, total dup: 48, max dup: 48 
    Average key length: 2.04, compression ratio: 0.50 
    Average prefix length: 0.96, average data length: 0.06 
    Clustering factor: 1, ratio: 0.02 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index AGENTS_IS_SUPPLIER (3) 
    Root page: 1504312, depth: 1, leaf buckets: 1, nodes: 50 
    Average node length: 3.08, total dup: 48, max dup: 44 
    Average key length: 2.04, compression ratio: 0.54 
    Average prefix length: 1.04, average data length: 0.06 
    Clustering factor: 1, ratio: 0.02 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index AGENTS_NAME_UNQ (1) 
    Root page: 1504310, depth: 1, leaf buckets: 1, nodes: 50 
    Average node length: 17.20, total dup: 0, max dup: 0 
    Average key length: 15.88, compression ratio: 0.92 
    Average prefix length: 1.42, average data length: 13.20 
    Clustering factor: 1, ratio: 0.02 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PK_AGENTS (0) 
    Root page: 1504309, depth: 1, leaf buckets: 1, nodes: 50 
    Average node length: 11.82, total dup: 0, max dup: 0 
    Average key length: 10.80, compression ratio: 0.83 
    Average prefix length: 1.18, average data length: 7.82 
    Clustering factor: 1, ratio: 0.02 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
BUSINESS_OPS (154) 
    Primary pointer page: 504, Index root page: 505 
    Total formats: 1, used formats: 1 
    Average record length: 108.20, total records: 20 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1235.00, compression ratio: 11.41 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 31% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 1 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index BO_UNIT_UNQ (1) 
    Root page: 1504242, depth: 1, leaf buckets: 1, nodes: 20 
    Average node length: 18.25, total dup: 0, max dup: 0 
    Average key length: 17.20, compression ratio: 1.24 
    Average prefix length: 7.05, average data length: 14.25 
    Clustering factor: 1, ratio: 0.05 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index BUSINESS_OPS_PREDICT_PRIOR (3) 
    Root page: 1504244, depth: 1, leaf buckets: 1, nodes: 20 
    Average node length: 5.40, total dup: 0, max dup: 0 
    Average key length: 4.35, compression ratio: 0.67 
    Average prefix length: 1.20, average data length: 1.70 
    Clustering factor: 1, ratio: 0.05 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index BUSINESS_OPS_RND_WGTH (2) 
    Root page: 1504243, depth: 1, leaf buckets: 1, nodes: 20 
    Average node length: 4.30, total dup: 6, max dup: 3 
    Average key length: 3.25, compression ratio: 0.72 
    Average prefix length: 1.35, average data length: 1.00 
    Clustering factor: 1, ratio: 0.05 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index RDB$1 (0) 
    Root page: 1504241, depth: 1, leaf buckets: 1, nodes: 20 
    Average node length: 5.20, total dup: 0, max dup: 0 
    Average key length: 4.15, compression ratio: 0.65 
    Average prefix length: 1.10, average data length: 1.60 
    Clustering factor: 1, ratio: 0.05 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
DOC_DATA (139) 
    Primary pointer page: 474, Index root page: 475 
    Total formats: 1, used formats: 1 
    Average record length: 47.31, total records: 7868738 
    Average version length: 48.15, total versions: 95867, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 64.00, compression ratio: 1.35 
    Pointer pages: 54, data page slots: 87016 
    Data pages: 87016, average fill: 72% 
    Primary pages: 87016, secondary pages: 0, swept pages: 14468 
    Empty pages: 7, full pages: 76077 
    Fill distribution: 
     0 - 19% = 18 
    20 - 39% = 129 
    40 - 59% = 1062 
    60 - 79% = 85779 
    80 - 99% = 28 
 
    Index DOC_DATA_DOC_WARE_UNQ (0) 
    Root page: 1510614, depth: 3, leaf buckets: 23577, nodes: 7868738 
    Average node length: 18.94, total dup: 0, max dup: 0 
    Average key length: 15.95, compression ratio: 1.69 
    Average prefix length: 14.05, average data length: 12.95 
    Clustering factor: 1779461, ratio: 0.23 
    Fill distribution: 
         0 - 19% = 385 
        20 - 39% = 1483 
        40 - 59% = 4498 
        60 - 79% = 2268 
        80 - 99% = 14943 
 
    Index DOC_DATA_ID_DESC (1) 
    Root page: 1528118, depth: 3, leaf buckets: 13666, nodes: 7868738 
    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: 1600891, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 1418 
        40 - 59% = 2286 
        60 - 79% = 993 
        80 - 99% = 8969 
 
    Index FK_DOC_DATA_DOC_LIST (2) 
    Root page: 1546711, depth: 3, leaf buckets: 8447, nodes: 7868738 
    Average node length: 6.64, total dup: 5849512, max dup: 49 
    Average key length: 3.65, compression ratio: 2.46 
    Average prefix length: 7.60, average data length: 1.40 
    Clustering factor: 1593879, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 133 
        20 - 39% = 798 
        40 - 59% = 1618 
        60 - 79% = 804 
        80 - 99% = 5094 
 
DOC_LIST (138) 
    Primary pointer page: 472, Index root page: 473 
    Total formats: 1, used formats: 1 
    Average record length: 56.28, total records: 2309898 
    Average version length: 34.57, total versions: 93005, max versions: 3 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 84.00, compression ratio: 1.49 
    Pointer pages: 18, data page slots: 28448 
    Data pages: 28448, average fill: 75% 
    Primary pages: 28442, secondary pages: 6, swept pages: 8613 
    Empty pages: 6, full pages: 25443 
    Fill distribution: 
     0 - 19% = 18 
    20 - 39% = 63 
    40 - 59% = 879 
    60 - 79% = 26297 
    80 - 99% = 1191 
 
    Index DOC_LIST_ID_DESC (1) 
    Root page: 1541130, depth: 3, leaf buckets: 4644, nodes: 2309898 
    Average node length: 11.39, total dup: 0, max dup: 0 
    Average key length: 8.43, compression ratio: 1.07 
    Average prefix length: 3.57, average data length: 5.43 
    Clustering factor: 720818, ratio: 0.31 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 832 
        40 - 59% = 992 
        60 - 79% = 646 
        80 - 99% = 2174 
 
    Index DOC_LIST_WORKER_OPTYPE (2) 
    Root page: 1544376, depth: 3, leaf buckets: 2546, nodes: 2312494 
    Average node length: 4.97, total dup: 2311595, max dup: 19650 
    Average key length: 2.01, compression ratio: 4.47 
    Average prefix length: 8.99, average data length: 0.01 
    Clustering factor: 1274353, ratio: 0.55 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 208 
        40 - 59% = 1524 
        60 - 79% = 628 
        80 - 99% = 184 
 
    Index FK_DOC_LIST_AGENTS (3) 
    Root page: 1545909, depth: 3, leaf buckets: 2115, nodes: 2309898 
    Average node length: 4.97, total dup: 2309848, max dup: 130604 
    Average key length: 2.01, compression ratio: 4.48 
    Average prefix length: 8.99, average data length: 0.01 
    Clustering factor: 1073976, ratio: 0.46 
    Fill distribution: 
         0 - 19% = 4 
        20 - 39% = 19 
        40 - 59% = 1278 
        60 - 79% = 48 
        80 - 99% = 766 
 
    Index PK_DOC_LIST (0) 
    Root page: 1538187, depth: 3, leaf buckets: 4400, nodes: 2309898 
    Average node length: 11.39, total dup: 0, max dup: 0 
    Average key length: 8.43, compression ratio: 1.07 
    Average prefix length: 3.57, average data length: 5.43 
    Clustering factor: 720818, ratio: 0.31 
    Fill distribution: 
         0 - 19% = 83 
        20 - 39% = 515 
        40 - 59% = 723 
        60 - 79% = 735 
        80 - 99% = 2344 
 
DOC_STATES (149) 
    Primary pointer page: 494, Index root page: 495 
    Total formats: 1, used formats: 1 
    Average record length: 67.50, total records: 4 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 650.00, compression ratio: 9.63 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 4% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index DOC_STATES_MCODE_UNQ (1) 
    Root page: 1504315, depth: 1, leaf buckets: 1, nodes: 4 
    Average node length: 17.75, total dup: 0, max dup: 0 
    Average key length: 16.50, compression ratio: 1.08 
    Average prefix length: 4.00, average data length: 13.75 
    Clustering factor: 1, ratio: 0.25 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index DOC_STATES_NAME_UNQ (2) 
    Root page: 1504316, depth: 1, leaf buckets: 1, nodes: 4 
    Average node length: 33.25, total dup: 0, max dup: 0 
    Average key length: 32.00, compression ratio: 0.99 
    Average prefix length: 2.50, average data length: 29.25 
    Clustering factor: 1, ratio: 0.25 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PK_DOC_STATES (0) 
    Root page: 1504314, depth: 1, leaf buckets: 1, nodes: 4 
    Average node length: 4.75, total dup: 0, max dup: 0 
    Average key length: 3.50, compression ratio: 0.86 
    Average prefix length: 1.50, average data length: 1.50 
    Clustering factor: 1, ratio: 0.25 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
FB_ERRORS (155) 
    Primary pointer page: 506, Index root page: 507 
    Total formats: 2, used formats: 2 
    Average record length: 54.76, total records: 2182 
    Average version length: 79.61, total versions: 757, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 270.43, compression ratio: 4.94 
    Pointer pages: 1, data page slots: 40 
    Data pages: 40, average fill: 70% 
    Primary pages: 40, secondary pages: 0, swept pages: 0 
    Empty pages: 7, full pages: 32 
    Fill distribution: 
     0 - 19% = 7 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 7 
    80 - 99% = 26 
 
    Index FB_ERRORS_GDS_CODE (0) 
    Root page: 382, depth: 2, leaf buckets: 2, nodes: 2182 
    Average node length: 4.40, total dup: 756, max dup: 1 
    Average key length: 2.67, compression ratio: 1.87 
    Average prefix length: 4.33, average data length: 0.67 
    Clustering factor: 1515, ratio: 0.69 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 0 
        40 - 59% = 1 
        60 - 79% = 1 
        80 - 99% = 0 
 
INVNT_SALDO (145) 
    Primary pointer page: 486, Index root page: 487 
    Total formats: 2, used formats: 1 
    Average record length: 82.11, total records: 400 
    Average version length: 22.97, total versions: 235610, max versions: 612 
    Average fragment length: 2.03, total fragments: 66, max fragments: 1 
    Average unpacked length: 104.00, compression ratio: 1.27 
    Pointer pages: 1, data page slots: 1320 
    Data pages: 1320, average fill: 89% 
    Primary pages: 13, secondary pages: 1307, swept pages: 0 
    Empty pages: 6, full pages: 1313 
    Fill distribution: 
     0 - 19% = 6 
    20 - 39% = 1 
    40 - 59% = 0 
    60 - 79% = 5 
    80 - 99% = 1308 
 
    Index PK_INVNT_SALDO (0) 
    Root page: 1510349, depth: 1, leaf buckets: 1, nodes: 400 
    Average node length: 11.22, total dup: 0, max dup: 0 
    Average key length: 10.22, compression ratio: 0.88 
    Average prefix length: 1.78, average data length: 7.22 
    Clustering factor: 326, ratio: 0.81 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 0 
        40 - 59% = 1 
        60 - 79% = 0 
        80 - 99% = 0 
 
INVNT_TURNOVER_LOG (153) 
    Primary pointer page: 502, Index root page: 503 
    Total formats: 1, used formats: 1 
    Average record length: 7.11, total records: 103172 
    Average version length: 68.29, total versions: 92442, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 88.00, compression ratio: 12.38 
    Pointer pages: 6, data page slots: 3080 
    Data pages: 1648, average fill: 78% 
    Primary pages: 1646, secondary pages: 2, swept pages: 0 
    Empty pages: 23, full pages: 1221 
    Fill distribution: 
     0 - 19% = 54 
    20 - 39% = 80 
    40 - 59% = 168 
    60 - 79% = 275 
    80 - 99% = 1071 
 
    Index INVNT_TURNOVER_LOG_WARE_DD_ID (0) 
    Root page: 1713357, depth: 3, leaf buckets: 295, nodes: 103172 
    Average node length: 13.32, total dup: 7195, max dup: 2 
    Average key length: 10.65, compression ratio: 2.53 
    Average prefix length: 19.27, average data length: 7.73 
    Clustering factor: 75277, ratio: 0.73 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 13 
        40 - 59% = 170 
        60 - 79% = 78 
        80 - 99% = 34 
 
MONEY_SALDO (141) 
    Primary pointer page: 478, Index root page: 479 
    Total formats: 1, used formats: 1 
    Average record length: 15.20, total records: 49 
    Average version length: 9.00, total versions: 18466, max versions: 960 
    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: 72 
    Data pages: 72, average fill: 82% 
    Primary pages: 8, secondary pages: 64, swept pages: 0 
    Empty pages: 7, full pages: 64 
    Fill distribution: 
     0 - 19% = 7 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 5 
    80 - 99% = 60 
 
    Index PK_MONEY_SALDO (0) 
    Root page: 1510361, depth: 1, leaf buckets: 1, nodes: 49 
    Average node length: 11.82, total dup: 0, max dup: 0 
    Average key length: 10.80, compression ratio: 0.83 
    Average prefix length: 1.18, average data length: 7.82 
    Clustering factor: 1, ratio: 0.02 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
MONEY_TURNOVER_LOG (140) 
    Primary pointer page: 476, Index root page: 477 
    Total formats: 1, used formats: 1 
    Average record length: 2.32, total records: 1830 
    Average version length: 43.57, total versions: 1735, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 58.00, compression ratio: 24.99 
    Pointer pages: 1, data page slots: 32 
    Data pages: 23, average fill: 76% 
    Primary pages: 22, secondary pages: 1, swept pages: 0 
    Empty pages: 0, full pages: 17 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 2 
    40 - 59% = 1 
    60 - 79% = 5 
    80 - 99% = 14 
 
    Index MONEY_TURNOVER_LOG_AGENT_OPTYPE (0) 
    Root page: 88652, depth: 2, leaf buckets: 3, nodes: 1830 
    Average node length: 4.21, total dup: 1732, max dup: 214 
    Average key length: 2.58, compression ratio: 7.37 
    Average prefix length: 18.47, average data length: 0.53 
    Clustering factor: 945, ratio: 0.52 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 3 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
MON_CACHE_MEMORY (165) 
    Primary pointer page: 526, Index root page: 527 
    Total formats: 2, used formats: 1 
    Average record length: 96.99, total records: 77 
    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: 54% 
    Primary pages: 2, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 1 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 1 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 1 
 
    Index PK_MON_CACHE_MEMORY (0) 
    Root page: 1504215, depth: 1, leaf buckets: 1, nodes: 77 
    Average node length: 11.68, total dup: 0, max dup: 0 
    Average key length: 10.66, compression ratio: 0.84 
    Average prefix length: 1.32, average data length: 7.68 
    Clustering factor: 2, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
MON_LOG (162) 
    Primary pointer page: 520, Index root page: 521 
    Total formats: 2, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index MON_LOG_DTS (4) 
    Root page: 1504229, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index MON_LOG_GDSCODE (2) 
    Root page: 1504227, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index MON_LOG_ROWSET_DESC (1) 
    Root page: 1504226, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index MON_LOG_UNIT (3) 
    Root page: 1504228, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PK_MON_LOG (0) 
    Root page: 1504225, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
MON_LOG_TABLE_STATS (163) 
    Primary pointer page: 522, Index root page: 523 
    Total formats: 2, used formats: 1 
    Average record length: 67.13, total records: 30 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 611.00, compression ratio: 9.10 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 31% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 1 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index MON_LOG_TABLE_STATS_DTS (4) 
    Root page: 1504224, depth: 1, leaf buckets: 1, nodes: 30 
    Average node length: 3.50, total dup: 23, max dup: 4 
    Average key length: 2.47, compression ratio: 3.24 
    Average prefix length: 7.53, average data length: 0.47 
    Clustering factor: 1, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index MON_LOG_TABLE_STATS_GDSCODE (2) 
    Root page: 1504222, depth: 1, leaf buckets: 1, nodes: 30 
    Average node length: 2.00, total dup: 29, max dup: 29 
    Average key length: 1.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 1, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index MON_LOG_TABLE_STATS_ROWSET (1) 
    Root page: 1504221, depth: 1, leaf buckets: 1, nodes: 30 
    Average node length: 3.33, total dup: 29, max dup: 29 
    Average key length: 2.30, compression ratio: 3.91 
    Average prefix length: 8.70, average data length: 0.30 
    Clustering factor: 1, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index MON_LOG_TABLE_STATS_TN_UNIT (3) 
    Root page: 1504223, depth: 1, leaf buckets: 1, nodes: 30 
    Average node length: 12.90, total dup: 0, max dup: 0 
    Average key length: 11.87, compression ratio: 1.42 
    Average prefix length: 7.63, average data length: 9.20 
    Clustering factor: 1, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PK_MON_LOG_TABLE_STATS (0) 
    Root page: 1504220, depth: 1, leaf buckets: 1, nodes: 30 
    Average node length: 8.37, total dup: 0, max dup: 0 
    Average key length: 7.33, compression ratio: 1.23 
    Average prefix length: 4.63, average data length: 4.37 
    Clustering factor: 1, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
OPTYPES (136) 
    Primary pointer page: 468, Index root page: 469 
    Total formats: 2, used formats: 1 
    Average record length: 67.56, total records: 9 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 386.00, compression ratio: 5.71 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 9% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index OPTYPES_MCODE_UNQ (1) 
    Root page: 1544805, depth: 1, leaf buckets: 1, nodes: 9 
    Average node length: 8.56, total dup: 0, max dup: 0 
    Average key length: 6.89, compression ratio: 0.73 
    Average prefix length: 0.44, average data length: 4.56 
    Clustering factor: 1, ratio: 0.11 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PK_OPTYPES (0) 
    Root page: 1544804, depth: 1, leaf buckets: 1, nodes: 9 
    Average node length: 6.11, total dup: 0, max dup: 0 
    Average key length: 5.00, compression ratio: 0.60 
    Average prefix length: 0.89, average data length: 2.11 
    Clustering factor: 1, ratio: 0.11 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
PDISTR (146) 
    Primary pointer page: 488, Index root page: 489 
    Total formats: 1, used formats: 1 
    Average record length: 35.82, total records: 757670 
    Average version length: 25.68, total versions: 73694, max versions: 5 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 54.00, compression ratio: 1.51 
    Pointer pages: 5, data page slots: 7784 
    Data pages: 7784, average fill: 69% 
    Primary pages: 7750, secondary pages: 34, swept pages: 1288 
    Empty pages: 70, full pages: 6401 
    Fill distribution: 
     0 - 19% = 184 
    20 - 39% = 219 
    40 - 59% = 340 
    60 - 79% = 6765 
    80 - 99% = 276 
 
    Index PDISTR_AGENT_ID (2) 
    Root page: 1509308, depth: 2, leaf buckets: 853, nodes: 757670 
    Average node length: 4.86, total dup: 757621, max dup: 135518 
    Average key length: 2.01, compression ratio: 4.48 
    Average prefix length: 8.99, average data length: 0.01 
    Clustering factor: 87177, ratio: 0.12 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 126 
        40 - 59% = 507 
        60 - 79% = 166 
        80 - 99% = 52 
 
    Index PDISTR_SNDOP_RCVOP_SNDID_ASC (0) 
    Root page: 1508613, depth: 3, leaf buckets: 819, nodes: 757670 
    Average node length: 5.87, total dup: 674620, max dup: 42 
    Average key length: 3.02, compression ratio: 7.30 
    Average prefix length: 21.09, average data length: 0.91 
    Clustering factor: 153281, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 109 
        40 - 59% = 209 
        60 - 79% = 153 
        80 - 99% = 348 
 
    Index PDISTR_SNDOP_RCVOP_SNDID_DESC (1) 
    Root page: 1509187, depth: 3, leaf buckets: 874, nodes: 757670 
    Average node length: 5.87, total dup: 674620, max dup: 42 
    Average key length: 3.02, compression ratio: 7.29 
    Average prefix length: 21.09, average data length: 0.91 
    Clustering factor: 155244, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 198 
        40 - 59% = 198 
        60 - 79% = 154 
        80 - 99% = 324 
 
    Index PDISTR_WORKER_SND_ID (3) 
    Root page: 1510178, depth: 3, leaf buckets: 1097, nodes: 757670 
    Average node length: 5.95, total dup: 674620, max dup: 42 
    Average key length: 3.10, compression ratio: 5.49 
    Average prefix length: 16.01, average data length: 0.99 
    Clustering factor: 149007, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 4 
        20 - 39% = 250 
        40 - 59% = 603 
        60 - 79% = 168 
        80 - 99% = 72 
 
PERF_AGG (158) 
    Primary pointer page: 512, Index root page: 513 
    Total formats: 1, used formats: 1 
    Average record length: 62.81, total records: 5409 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 2.70, total fragments: 69, max fragments: 1 
    Average unpacked length: 379.00, compression ratio: 6.03 
    Pointer pages: 1, data page slots: 176 
    Data pages: 112, average fill: 48% 
    Primary pages: 90, secondary pages: 22, swept pages: 50 
    Empty pages: 25, full pages: 64 
    Fill distribution: 
     0 - 19% = 42 
    20 - 39% = 0 
    40 - 59% = 1 
    60 - 79% = 69 
    80 - 99% = 0 
 
    Index PERF_AGG_UNQ (1) 
    Root page: 1504238, depth: 2, leaf buckets: 5, nodes: 5409 
    Average node length: 5.48, total dup: 0, max dup: 0 
    Average key length: 3.57, compression ratio: 10.05 
    Average prefix length: 34.30, average data length: 1.54 
    Clustering factor: 5116, ratio: 0.95 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 0 
        40 - 59% = 2 
        60 - 79% = 1 
        80 - 99% = 2 
 
    Index PK_PERF_AGG (0) 
    Root page: 1504233, depth: 2, leaf buckets: 10, nodes: 5409 
    Average node length: 11.12, total dup: 0, max dup: 0 
    Average key length: 9.21, compression ratio: 0.98 
    Average prefix length: 2.79, average data length: 6.21 
    Clustering factor: 142, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 1 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 7 
 
PERF_ESTIMATED (280) 
    Primary pointer page: 1504218, Index root page: 1504219 
    Total formats: 1, used formats: 1 
    Average record length: 39.13, total records: 84325 
    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: 71% 
    Primary pages: 816, secondary pages: 0, swept pages: 0 
    Empty pages: 2, full pages: 812 
    Fill distribution: 
     0 - 19% = 3 
    20 - 39% = 1 
    40 - 59% = 0 
    60 - 79% = 812 
    80 - 99% = 0 
 
    Index PK_PERF_ESTIMATED (0) 
    Root page: 33401, depth: 2, leaf buckets: 107, nodes: 84325 
    Average node length: 10.15, total dup: 0, max dup: 0 
    Average key length: 8.16, compression ratio: 1.10 
    Average prefix length: 3.84, average data length: 5.16 
    Clustering factor: 3508, ratio: 0.04 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 0 
        40 - 59% = 1 
        60 - 79% = 1 
        80 - 99% = 105 
 
PERF_ISQL_STAT (156) 
    Primary pointer page: 508, Index root page: 509 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index PERF_ISQL_STAT_TRN (0) 
    Root page: 1504239, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
PERF_LOG (159) 
    Primary pointer page: 514, Index root page: 515 
    Total formats: 1, used formats: 1 
    Average record length: 110.64, total records: 72 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1691.00, compression ratio: 15.28 
    Pointer pages: 1, data page slots: 2 
    Data pages: 2, average fill: 56% 
    Primary pages: 2, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 1 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 1 
    40 - 59% = 0 
    60 - 79% = 1 
    80 - 99% = 0 
 
PERF_SPLIT_0 (281) 
    Primary pointer page: 573, Index root page: 574 
    Total formats: 1, used formats: 1 
    Average record length: 141.35, total records: 178493 
    Average version length: 153.51, total versions: 11544, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 12.00 
    Pointer pages: 7, data page slots: 5208 
    Data pages: 4312, average fill: 86% 
    Primary pages: 4312, secondary pages: 0, swept pages: 3 
    Empty pages: 63, full pages: 4227 
    Fill distribution: 
     0 - 19% = 70 
    20 - 39% = 4 
    40 - 59% = 8 
    60 - 79% = 4 
    80 - 99% = 4226 
 
PERF_SPLIT_1 (282) 
    Primary pointer page: 576, Index root page: 577 
    Total formats: 1, used formats: 1 
    Average record length: 142.66, total records: 174581 
    Average version length: 152.24, total versions: 9529, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.89 
    Pointer pages: 7, data page slots: 4688 
    Data pages: 4208, average fill: 86% 
    Primary pages: 4208, secondary pages: 0, swept pages: 2 
    Empty pages: 61, full pages: 4120 
    Fill distribution: 
     0 - 19% = 62 
    20 - 39% = 9 
    40 - 59% = 9 
    60 - 79% = 10 
    80 - 99% = 4118 
 
PERF_SPLIT_2 (283) 
    Primary pointer page: 578, Index root page: 579 
    Total formats: 1, used formats: 1 
    Average record length: 138.67, total records: 201476 
    Average version length: 154.37, total versions: 16574, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 12.23 
    Pointer pages: 7, data page slots: 6512 
    Data pages: 4872, average fill: 86% 
    Primary pages: 4872, secondary pages: 0, swept pages: 2 
    Empty pages: 56, full pages: 4759 
    Fill distribution: 
     0 - 19% = 60 
    20 - 39% = 10 
    40 - 59% = 42 
    60 - 79% = 1 
    80 - 99% = 4759 
 
PERF_SPLIT_3 (284) 
    Primary pointer page: 580, Index root page: 581 
    Total formats: 1, used formats: 1 
    Average record length: 146.55, total records: 173711 
    Average version length: 151.66, total versions: 4860, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.57 
    Pointer pages: 7, data page slots: 5184 
    Data pages: 4240, average fill: 84% 
    Primary pages: 4239, secondary pages: 1, swept pages: 1 
    Empty pages: 115, full pages: 4094 
    Fill distribution: 
     0 - 19% = 118 
    20 - 39% = 10 
    40 - 59% = 10 
    60 - 79% = 7 
    80 - 99% = 4095 
 
PERF_SPLIT_4 (285) 
    Primary pointer page: 582, Index root page: 583 
    Total formats: 1, used formats: 1 
    Average record length: 131.24, total records: 192463 
    Average version length: 154.64, total versions: 25413, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 12.92 
    Pointer pages: 7, data page slots: 5096 
    Data pages: 4640, average fill: 87% 
    Primary pages: 4640, secondary pages: 0, swept pages: 1 
    Empty pages: 55, full pages: 4573 
    Fill distribution: 
     0 - 19% = 61 
    20 - 39% = 1 
    40 - 59% = 1 
    60 - 79% = 4 
    80 - 99% = 4573 
 
PERF_SPLIT_5 (286) 
    Primary pointer page: 584, Index root page: 585 
    Total formats: 1, used formats: 1 
    Average record length: 147.23, total records: 175944 
    Average version length: 151.52, total versions: 4164, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.52 
    Pointer pages: 6, data page slots: 4424 
    Data pages: 4200, average fill: 86% 
    Primary pages: 4199, secondary pages: 1, swept pages: 1 
    Empty pages: 31, full pages: 4159 
    Fill distribution: 
     0 - 19% = 34 
    20 - 39% = 4 
    40 - 59% = 1 
    60 - 79% = 2 
    80 - 99% = 4159 
 
PERF_SPLIT_6 (287) 
    Primary pointer page: 586, Index root page: 587 
    Total formats: 1, used formats: 1 
    Average record length: 129.12, total records: 197273 
    Average version length: 154.74, total versions: 28387, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 13.13 
    Pointer pages: 6, data page slots: 6408 
    Data pages: 4848, average fill: 85% 
    Primary pages: 4847, secondary pages: 1, swept pages: 1 
    Empty pages: 140, full pages: 4663 
    Fill distribution: 
     0 - 19% = 141 
    20 - 39% = 13 
    40 - 59% = 19 
    60 - 79% = 13 
    80 - 99% = 4662 
 
PERF_SPLIT_7 (288) 
    Primary pointer page: 588, Index root page: 589 
    Total formats: 1, used formats: 1 
    Average record length: 133.32, total records: 208199 
    Average version length: 154.52, total versions: 24422, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 12.72 
    Pointer pages: 6, data page slots: 5816 
    Data pages: 4984, average fill: 87% 
    Primary pages: 4983, secondary pages: 1, swept pages: 3 
    Empty pages: 30, full pages: 4937 
    Fill distribution: 
     0 - 19% = 32 
    20 - 39% = 4 
    40 - 59% = 5 
    60 - 79% = 6 
    80 - 99% = 4937 
 
PERF_SPLIT_8 (289) 
    Primary pointer page: 590, Index root page: 591 
    Total formats: 1, used formats: 1 
    Average record length: 146.44, total records: 177456 
    Average version length: 150.90, total versions: 5257, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.58 
    Pointer pages: 7, data page slots: 4632 
    Data pages: 4240, average fill: 86% 
    Primary pages: 4239, secondary pages: 1, swept pages: 3 
    Empty pages: 34, full pages: 4198 
    Fill distribution: 
     0 - 19% = 35 
    20 - 39% = 5 
    40 - 59% = 1 
    60 - 79% = 1 
    80 - 99% = 4198 
 
PERF_SPLIT_9 (290) 
    Primary pointer page: 593, Index root page: 594 
    Total formats: 1, used formats: 1 
    Average record length: 140.53, total records: 184748 
    Average version length: 152.92, total versions: 12968, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 12.07 
    Pointer pages: 6, data page slots: 5024 
    Data pages: 4432, average fill: 86% 
    Primary pages: 4432, secondary pages: 0, swept pages: 3 
    Empty pages: 42, full pages: 4379 
    Fill distribution: 
     0 - 19% = 44 
    20 - 39% = 5 
    40 - 59% = 2 
    60 - 79% = 2 
    80 - 99% = 4379 
 
PHRASES (143) 
    Primary pointer page: 482, Index root page: 483 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index PHRASES_ID_DESC (3) 
    Root page: 1510354, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PHRASES_NAME (2) 
    Root page: 1510353, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PHRASES_UNQ (1) 
    Root page: 1510352, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PK_PHRASES (0) 
    Root page: 1510351, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
PSTORNED (147) 
    Primary pointer page: 490, Index root page: 491 
    Total formats: 1, used formats: 1 
    Average record length: 51.74, total records: 2168212 
    Average version length: 52.95, total versions: 41403, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 70.00, compression ratio: 1.35 
    Pointer pages: 16, data page slots: 25640 
    Data pages: 25640, average fill: 73% 
    Primary pages: 25640, secondary pages: 0, swept pages: 9170 
    Empty pages: 128, full pages: 22631 
    Fill distribution: 
     0 - 19% = 258 
    20 - 39% = 234 
    40 - 59% = 651 
    60 - 79% = 24133 
    80 - 99% = 364 
 
    Index PSTORNED_RCV_ID (1) 
    Root page: 1506186, depth: 3, leaf buckets: 2648, nodes: 2168212 
    Average node length: 5.44, total dup: 2024820, max dup: 1713 
    Average key length: 2.48, compression ratio: 3.63 
    Average prefix length: 8.58, average data length: 0.42 
    Clustering factor: 186364, ratio: 0.09 
    Fill distribution: 
         0 - 19% = 3 
        20 - 39% = 279 
        40 - 59% = 1737 
        60 - 79% = 337 
        80 - 99% = 292 
 
    Index PSTORNED_SND_ID (0) 
    Root page: 1504819, depth: 3, leaf buckets: 2763, nodes: 2168212 
    Average node length: 5.69, total dup: 1946997, max dup: 64 
    Average key length: 2.73, compression ratio: 3.29 
    Average prefix length: 8.37, average data length: 0.63 
    Clustering factor: 386182, ratio: 0.18 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 0 
        40 - 59% = 2272 
        60 - 79% = 452 
        80 - 99% = 39 
 
    Index PSTORNED_WORKER_ID (2) 
    Root page: 1507996, depth: 3, leaf buckets: 2227, nodes: 2168212 
    Average node length: 4.96, total dup: 2168112, max dup: 27770 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.41, average data length: 0.00 
    Clustering factor: 183722, ratio: 0.08 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 178 
        40 - 59% = 1269 
        60 - 79% = 394 
        80 - 99% = 386 
 
RULES_FOR_PDISTR (148) 
    Primary pointer page: 492, Index root page: 493 
    Total formats: 1, used formats: 1 
    Average record length: 17.00, total records: 4 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 334.00, compression ratio: 19.65 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 2% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index RULES_FOR_PDISTR_UNQ (0) 
    Root page: 1504317, depth: 1, leaf buckets: 1, nodes: 4 
    Average node length: 11.50, total dup: 0, max dup: 0 
    Average key length: 10.25, compression ratio: 0.88 
    Average prefix length: 1.50, average data length: 7.50 
    Clustering factor: 1, ratio: 0.25 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
RULES_FOR_QDISTR (137) 
    Primary pointer page: 470, Index root page: 471 
    Total formats: 1, used formats: 1 
    Average record length: 32.71, total records: 7 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 332.00, compression ratio: 10.15 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 4% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index RULES_FOR_QDISTR_RCVOP (1) 
    Root page: 1544803, depth: 1, leaf buckets: 1, nodes: 7 
    Average node length: 5.29, total dup: 2, max dup: 2 
    Average key length: 4.14, compression ratio: 0.72 
    Average prefix length: 1.43, average data length: 1.57 
    Clustering factor: 1, ratio: 0.14 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index RULES_FOR_QDISTR_UNQ (0) 
    Root page: 1544802, depth: 1, leaf buckets: 1, nodes: 7 
    Average node length: 10.14, total dup: 0, max dup: 0 
    Average key length: 8.86, compression ratio: 0.94 
    Average prefix length: 2.14, average data length: 6.14 
    Clustering factor: 1, ratio: 0.14 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
SEMAPHORES (152) 
    Primary pointer page: 500, Index root page: 501 
    Total formats: 1, used formats: 1 
    Average record length: 43.40, total records: 5 
    Average version length: 9.00, total versions: 1, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 346.00, compression ratio: 7.97 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 4% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index PK_SEMAPHORES (0) 
    Root page: 1504305, depth: 1, leaf buckets: 1, nodes: 5 
    Average node length: 12.40, total dup: 0, max dup: 0 
    Average key length: 11.00, compression ratio: 0.82 
    Average prefix length: 0.60, average data length: 8.40 
    Clustering factor: 1, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index SEMAPHORES_TASK_UNQ (1) 
    Root page: 1504306, depth: 1, leaf buckets: 1, nodes: 5 
    Average node length: 23.40, total dup: 0, max dup: 0 
    Average key length: 22.00, compression ratio: 1.07 
    Average prefix length: 4.20, average data length: 19.40 
    Clustering factor: 1, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
SETTINGS (135) 
    Primary pointer page: 466, Index root page: 467 
    Total formats: 1, used formats: 1 
    Average record length: 97.63, total records: 149 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1347.00, compression ratio: 13.80 
    Pointer pages: 1, data page slots: 3 
    Data pages: 3, average fill: 70% 
    Primary pages: 3, secondary pages: 0, swept pages: 2 
    Empty pages: 0, full pages: 2 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 1 
    60 - 79% = 0 
    80 - 99% = 2 
 
    Index SETTINGS_MCODE_WM_UNQ (1) 
    Root page: 525, depth: 1, leaf buckets: 1, nodes: 149 
    Average node length: 14.66, total dup: 0, max dup: 0 
    Average key length: 13.55, compression ratio: 2.19 
    Average prefix length: 19.07, average data length: 10.66 
    Clustering factor: 48, ratio: 0.32 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 1 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index SETTINGS_MODE_CODE (0) 
    Root page: 1544806, depth: 1, leaf buckets: 1, nodes: 149 
    Average node length: 25.56, total dup: 0, max dup: 0 
    Average key length: 24.56, compression ratio: 1.63 
    Average prefix length: 18.58, average data length: 21.56 
    Clustering factor: 14, ratio: 0.09 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 0 
        40 - 59% = 1 
        60 - 79% = 0 
        80 - 99% = 0 
 
TMP$DEP_DOCS (129) 
    Primary pointer page: 454, Index root page: 455 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index TMP_DEP_DOCS_UNQ (0) 
    Root page: 1544810, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
TMP$IDX_RECALC (132) 
    Primary pointer page: 460, Index root page: 461 
    Total formats: 2, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index TMP_IDX_RECALC_IDX_NAME_UNQ (0) 
    Root page: 1544807, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
TMP$MON_LOG (133) 
    Primary pointer page: 462, Index root page: 463 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
TMP$MON_LOG_TABLE_STATS (134) 
    Primary pointer page: 464, Index root page: 465 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
TMP$PERF_EST_WHOLE (161) 
    Primary pointer page: 518, Index root page: 519 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
TMP$PERF_LOG (160) 
    Primary pointer page: 516, Index root page: 517 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index TMP$PERF_LOG_UNIT_TRN_DTS_END (0) 
    Root page: 1504230, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
TMP$PERF_MON (131) 
    Primary pointer page: 458, Index root page: 459 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
TMP$RESULT_SET (130) 
    Primary pointer page: 456, Index root page: 457 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index TMP_RESULT_SET_DOC (1) 
    Root page: 1544809, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index TMP_RESULT_SET_WARE_DOC (0) 
    Root page: 1544808, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
TMP$SHOPPING_CART (128) 
    Primary pointer page: 452, Index root page: 453 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index TMP_SHOPCART_UNQ (0) 
    Root page: 1544811, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
TPAUSE (166) 
    Primary pointer page: 528, Index root page: 529 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index RDB$PRIMARY2 (0) 
    Root page: 1504214, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
TRACE_STAT (157) 
    Primary pointer page: 510, Index root page: 511 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
WARES (142) 
    Primary pointer page: 480, Index root page: 481 
    Total formats: 1, used formats: 1 
    Average record length: 77.52, total records: 400 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 444.00, compression ratio: 5.73 
    Pointer pages: 1, data page slots: 6 
    Data pages: 6, average fill: 77% 
    Primary pages: 6, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 5 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 5 
    80 - 99% = 1 
 
    Index FK_WARES_WARE_GROUPS (3) 
    Root page: 1552159, depth: 1, leaf buckets: 1, nodes: 400 
    Average node length: 3.17, total dup: 392, max dup: 60 
    Average key length: 2.16, compression ratio: 4.16 
    Average prefix length: 8.86, average data length: 0.14 
    Clustering factor: 48, ratio: 0.12 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PK_WARES (0) 
    Root page: 1510355, depth: 1, leaf buckets: 1, nodes: 400 
    Average node length: 11.22, total dup: 0, max dup: 0 
    Average key length: 10.22, compression ratio: 0.88 
    Average prefix length: 1.78, average data length: 7.22 
    Clustering factor: 344, ratio: 0.86 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 0 
        40 - 59% = 1 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index WARES_ID_DESC (2) 
    Root page: 1510360, depth: 1, leaf buckets: 1, nodes: 400 
    Average node length: 11.22, total dup: 0, max dup: 0 
    Average key length: 10.22, compression ratio: 0.88 
    Average prefix length: 1.78, average data length: 7.22 
    Clustering factor: 344, ratio: 0.86 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 0 
        40 - 59% = 1 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index WARES_NUMB_UNQ (1) 
    Root page: 1510358, depth: 2, leaf buckets: 3, nodes: 400 
    Average node length: 53.25, total dup: 0, max dup: 0 
    Average key length: 52.23, compression ratio: 1.00 
    Average prefix length: 2.74, average data length: 49.25 
    Clustering factor: 355, ratio: 0.89 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 1 
        80 - 99% = 2 
 
WARE_GROUPS (151) 
    Primary pointer page: 498, Index root page: 499 
    Total formats: 1, used formats: 1 
    Average record length: 32.12, total records: 8 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 346.00, compression ratio: 10.77 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 5% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index PK_WARE_GROUPS (0) 
    Root page: 1504307, depth: 1, leaf buckets: 1, nodes: 8 
    Average node length: 11.25, total dup: 0, max dup: 0 
    Average key length: 10.12, compression ratio: 0.89 
    Average prefix length: 1.75, average data length: 7.25 
    Clustering factor: 1, ratio: 0.12 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index WARE_GROUPS_NAME_UNQ (1) 
    Root page: 1504308, depth: 1, leaf buckets: 1, nodes: 8 
    Average node length: 19.88, total dup: 0, max dup: 0 
    Average key length: 18.12, compression ratio: 0.89 
    Average prefix length: 0.25, average data length: 15.88 
    Clustering factor: 1, ratio: 0.12 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
XQD_1000_1200 (176) 
    Primary pointer page: 549, Index root page: 550 
    Total formats: 1, used formats: 1 
    Average record length: 37.54, total records: 146901 
    Average version length: 69.17, total versions: 67219, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 3.36 
    Pointer pages: 3, data page slots: 3840 
    Data pages: 2720, average fill: 63% 
    Primary pages: 2720, secondary pages: 0, swept pages: 283 
    Empty pages: 359, full pages: 1931 
    Fill distribution: 
     0 - 19% = 539 
    20 - 39% = 149 
    40 - 59% = 74 
    60 - 79% = 604 
    80 - 99% = 1354 
 
    Index XQD_1000_1200_WA_SO_RO_WKR_SND (0) 
    Root page: 103745, depth: 3, leaf buckets: 207, nodes: 146901 
    Average node length: 6.42, total dup: 127908, max dup: 14 
    Average key length: 3.94, compression ratio: 10.65 
    Average prefix length: 40.19, average data length: 1.81 
    Clustering factor: 25082, ratio: 0.17 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 26 
        40 - 59% = 90 
        60 - 79% = 69 
        80 - 99% = 21 
 
XQD_1000_3300 (178) 
    Primary pointer page: 553, Index root page: 554 
    Total formats: 1, used formats: 1 
    Average record length: 64.68, total records: 6782557 
    Average version length: 68.81, total versions: 422198, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.95 
    Pointer pages: 61, data page slots: 98544 
    Data pages: 98544, average fill: 74% 
    Primary pages: 98544, secondary pages: 0, swept pages: 18701 
    Empty pages: 35, full pages: 76991 
    Fill distribution: 
     0 - 19% = 420 
    20 - 39% = 1765 
    40 - 59% = 6418 
    60 - 79% = 82979 
    80 - 99% = 6962 
 
    Index XQD_1000_3300_WA_SO_RO_WKR_SND (0) 
    Root page: 1480454, depth: 3, leaf buckets: 10508, nodes: 6782557 
    Average node length: 6.51, total dup: 5867153, max dup: 29 
    Average key length: 3.52, compression ratio: 11.93 
    Average prefix length: 40.61, average data length: 1.39 
    Clustering factor: 1522897, ratio: 0.22 
    Fill distribution: 
         0 - 19% = 7 
        20 - 39% = 1871 
        40 - 59% = 5860 
        60 - 79% = 2352 
        80 - 99% = 418 
 
    Index XQD_1000_3300_WKR_DOC_ASC (1) 
    Root page: 1486068, depth: 3, leaf buckets: 8298, nodes: 6782557 
    Average node length: 5.40, total dup: 6507117, max dup: 147 
    Average key length: 2.41, compression ratio: 7.04 
    Average prefix length: 16.63, average data length: 0.37 
    Clustering factor: 1324851, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 10 
        20 - 39% = 1269 
        40 - 59% = 4635 
        60 - 79% = 1420 
        80 - 99% = 964 
 
    Index XQD_1000_3300_WKR_DOC_DEC (2) 
    Root page: 1490608, depth: 3, leaf buckets: 8360, nodes: 6782557 
    Average node length: 5.40, total dup: 6507117, max dup: 147 
    Average key length: 2.41, compression ratio: 7.04 
    Average prefix length: 16.63, average data length: 0.37 
    Clustering factor: 1327491, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 3 
        20 - 39% = 1356 
        40 - 59% = 4593 
        60 - 79% = 1454 
        80 - 99% = 954 
 
XQD_1200_2000 (177) 
    Primary pointer page: 551, Index root page: 552 
    Total formats: 1, used formats: 1 
    Average record length: 66.74, total records: 11771395 
    Average version length: 68.78, total versions: 379033, 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: 101, data page slots: 163408 
    Data pages: 163408, average fill: 76% 
    Primary pages: 163408, secondary pages: 0, swept pages: 64983 
    Empty pages: 10, full pages: 154084 
    Fill distribution: 
     0 - 19% = 74 
    20 - 39% = 528 
    40 - 59% = 2835 
    60 - 79% = 152550 
    80 - 99% = 7421 
 
    Index XQD_1200_2000_WA_SO_RO_WKR_SND (0) 
    Root page: 1495028, depth: 3, leaf buckets: 18115, nodes: 11771395 
    Average node length: 6.55, total dup: 10262791, max dup: 63 
    Average key length: 3.42, compression ratio: 12.26 
    Average prefix length: 40.70, average data length: 1.30 
    Clustering factor: 2342990, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 20 
        20 - 39% = 2667 
        40 - 59% = 10616 
        60 - 79% = 3954 
        80 - 99% = 858 
 
XQD_2000_3300 (179) 
    Primary pointer page: 555, Index root page: 556 
    Total formats: 1, used formats: 1 
    Average record length: 39.12, total records: 1776909 
    Average version length: 69.11, total versions: 771908, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 3.22 
    Pointer pages: 26, data page slots: 40680 
    Data pages: 28509, average fill: 72% 
    Primary pages: 28509, secondary pages: 0, swept pages: 4549 
    Empty pages: 1730, full pages: 22039 
    Fill distribution: 
     0 - 19% = 2754 
    20 - 39% = 1330 
    40 - 59% = 1417 
    60 - 79% = 9964 
    80 - 99% = 13044 
 
    Index XQD_2000_3300_WA_SO_RO_WKR_SND (0) 
    Root page: 1479712, depth: 3, leaf buckets: 2217, nodes: 1776909 
    Average node length: 5.51, total dup: 1705226, max dup: 99 
    Average key length: 2.55, compression ratio: 16.48 
    Average prefix length: 41.49, average data length: 0.51 
    Clustering factor: 123699, ratio: 0.07 
    Fill distribution: 
         0 - 19% = 17 
        20 - 39% = 347 
        40 - 59% = 1075 
        60 - 79% = 589 
        80 - 99% = 189 
 
XQD_2100_3300 (180) 
    Primary pointer page: 557, Index root page: 558 
    Total formats: 1, used formats: 1 
    Average record length: 38.94, total records: 1171214 
    Average version length: 69.14, total versions: 510578, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 3.24 
    Pointer pages: 20, data page slots: 30960 
    Data pages: 25800, average fill: 53% 
    Primary pages: 25799, secondary pages: 1, swept pages: 4996 
    Empty pages: 5204, full pages: 14043 
    Fill distribution: 
     0 - 19% = 8218 
    20 - 39% = 1395 
    40 - 59% = 914 
    60 - 79% = 5667 
    80 - 99% = 9606 
 
    Index XQD_2100_3300_WA_SO_RO_WKR_SND (0) 
    Root page: 1479207, depth: 3, leaf buckets: 1520, nodes: 1171214 
    Average node length: 5.74, total dup: 1097983, max dup: 99 
    Average key length: 2.80, compression ratio: 14.98 
    Average prefix length: 41.26, average data length: 0.74 
    Clustering factor: 151475, ratio: 0.13 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 232 
        40 - 59% = 738 
        60 - 79% = 439 
        80 - 99% = 111 
 
XQD_3300_3400 (181) 
    Primary pointer page: 559, Index root page: 560 
    Total formats: 1, used formats: 1 
    Average record length: 65.08, total records: 9682996 
    Average version length: 68.93, total versions: 536671, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.94 
    Pointer pages: 88, data page slots: 143352 
    Data pages: 143344, average fill: 72% 
    Primary pages: 143344, secondary pages: 0, swept pages: 42931 
    Empty pages: 252, full pages: 97749 
    Fill distribution: 
     0 - 19% = 774 
    20 - 39% = 3054 
    40 - 59% = 13337 
    60 - 79% = 115809 
    80 - 99% = 10370 
 
    Index XQD_3300_3400_WA_SO_RO_WKR_SND (0) 
    Root page: 1472590, depth: 3, leaf buckets: 13532, nodes: 9682996 
    Average node length: 6.67, total dup: 8033394, max dup: 29 
    Average key length: 3.66, compression ratio: 11.47 
    Average prefix length: 40.51, average data length: 1.49 
    Clustering factor: 2126320, ratio: 0.22 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 905 
        40 - 59% = 6280 
        60 - 79% = 5235 
        80 - 99% = 1110 
 
XQS_1000_1200 (182) 
    Primary pointer page: 561, Index root page: 562 
    Total formats: 1, used formats: 1 
    Average record length: 82.48, total records: 21221073 
    Average version length: 82.96, total versions: 15940, 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: 319672 
    Data pages: 319672, average fill: 81% 
    Primary pages: 319672, secondary pages: 0, swept pages: 12183 
    Empty pages: 3, full pages: 319653 
    Fill distribution: 
     0 - 19% = 6 
    20 - 39% = 1 
    40 - 59% = 3 
    60 - 79% = 27106 
    80 - 99% = 292556 
 
    Index XQS_1000_1200_DOC_ID (1) 
    Root page: 1426716, depth: 3, leaf buckets: 19455, nodes: 21221073 
    Average node length: 5.72, total dup: 20738622, max dup: 145 
    Average key length: 2.16, compression ratio: 4.16 
    Average prefix length: 8.86, average data length: 0.14 
    Clustering factor: 3291925, ratio: 0.16 
    Fill distribution: 
         0 - 19% = 4 
        20 - 39% = 1 
        40 - 59% = 8150 
        60 - 79% = 592 
        80 - 99% = 10708 
 
    Index XQS_1000_1200_RCV_ID (3) 
    Root page: 1456980, depth: 3, leaf buckets: 17293, nodes: 21221073 
    Average node length: 6.31, total dup: 18649018, max dup: 49 
    Average key length: 2.75, compression ratio: 3.27 
    Average prefix length: 8.37, average data length: 0.63 
    Clustering factor: 917676, ratio: 0.04 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 6 
        40 - 59% = 902 
        60 - 79% = 284 
        80 - 99% = 16099 
 
    Index XQS_1000_1200_SND_ID (2) 
    Root page: 1441073, depth: 3, leaf buckets: 21241, nodes: 21221073 
    Average node length: 6.35, total dup: 18568038, max dup: 29 
    Average key length: 2.79, compression ratio: 3.23 
    Average prefix length: 8.34, average data length: 0.66 
    Clustering factor: 3587563, ratio: 0.17 
    Fill distribution: 
         0 - 19% = 3 
        20 - 39% = 2 
        40 - 59% = 8414 
        60 - 79% = 660 
        80 - 99% = 12162 
 
    Index XQS_1000_1200_WORKER_ID (0) 
    Root page: 1413348, depth: 3, leaf buckets: 16300, nodes: 21221073 
    Average node length: 5.56, total dup: 21220973, max dup: 230974 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.42, average data length: 0.00 
    Clustering factor: 946417, ratio: 0.04 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 9 
        40 - 59% = 3145 
        60 - 79% = 457 
        80 - 99% = 12687 
 
XQS_1000_3300 (184) 
    Primary pointer page: 565, Index root page: 566 
    Total formats: 1, used formats: 1 
    Average record length: 78.30, total records: 10117290 
    Average version length: 82.62, total versions: 507481, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.61 
    Pointer pages: 105, data page slots: 170656 
    Data pages: 170648, average fill: 73% 
    Primary pages: 170648, secondary pages: 0, swept pages: 61333 
    Empty pages: 279, full pages: 115786 
    Fill distribution: 
     0 - 19% = 985 
    20 - 39% = 4654 
    40 - 59% = 18697 
    60 - 79% = 69739 
    80 - 99% = 76573 
 
    Index XQS_1000_3300_DOC_ID (1) 
    Root page: 1367502, depth: 3, leaf buckets: 11396, nodes: 10117290 
    Average node length: 5.36, total dup: 9803630, max dup: 191 
    Average key length: 2.23, compression ratio: 4.04 
    Average prefix length: 8.80, average data length: 0.20 
    Clustering factor: 2266167, ratio: 0.22 
    Fill distribution: 
         0 - 19% = 5 
        20 - 39% = 20 
        40 - 59% = 7106 
        60 - 79% = 4031 
        80 - 99% = 234 
 
    Index XQS_1000_3300_RCV_ID (3) 
    Root page: 1379261, depth: 3, leaf buckets: 13837, nodes: 10117290 
    Average node length: 6.23, total dup: 8389209, max dup: 14 
    Average key length: 3.10, compression ratio: 2.90 
    Average prefix length: 8.07, average data length: 0.93 
    Clustering factor: 1584583, ratio: 0.16 
    Fill distribution: 
         0 - 19% = 137 
        20 - 39% = 3669 
        40 - 59% = 4639 
        60 - 79% = 2712 
        80 - 99% = 2680 
 
    Index XQS_1000_3300_SND_ID (2) 
    Root page: 1373059, depth: 3, leaf buckets: 12723, nodes: 10117290 
    Average node length: 5.98, total dup: 8788318, max dup: 44 
    Average key length: 2.84, compression ratio: 3.17 
    Average prefix length: 8.29, average data length: 0.71 
    Clustering factor: 2461413, ratio: 0.24 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 31 
        40 - 59% = 8060 
        60 - 79% = 4354 
        80 - 99% = 278 
 
    Index XQS_1000_3300_WORKER_ID (0) 
    Root page: 1362767, depth: 3, leaf buckets: 10463, nodes: 10117290 
    Average node length: 5.14, total dup: 10117190, max dup: 159012 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.43, average data length: 0.00 
    Clustering factor: 1613519, ratio: 0.16 
    Fill distribution: 
         0 - 19% = 35 
        20 - 39% = 1165 
        40 - 59% = 5256 
        60 - 79% = 1775 
        80 - 99% = 2232 
 
XQS_1200_2000 (183) 
    Primary pointer page: 563, Index root page: 564 
    Total formats: 1, used formats: 1 
    Average record length: 79.44, total records: 11806604 
    Average version length: 82.59, total versions: 411744, 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: 192824 
    Data pages: 191760, average fill: 76% 
    Primary pages: 191760, secondary pages: 0, swept pages: 59140 
    Empty pages: 1730, full pages: 155851 
    Fill distribution: 
     0 - 19% = 2939 
    20 - 39% = 4567 
    40 - 59% = 12757 
    60 - 79% = 41776 
    80 - 99% = 129721 
 
    Index XQS_1200_2000_DOC_ID (1) 
    Root page: 1392101, depth: 3, leaf buckets: 13164, nodes: 11806604 
    Average node length: 5.31, total dup: 11695847, max dup: 644 
    Average key length: 2.08, compression ratio: 4.33 
    Average prefix length: 8.93, average data length: 0.07 
    Clustering factor: 2463881, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 51 
        40 - 59% = 7988 
        60 - 79% = 4711 
        80 - 99% = 412 
 
    Index XQS_1200_2000_RCV_ID (3) 
    Root page: 1406110, depth: 3, leaf buckets: 10826, nodes: 11806604 
    Average node length: 5.51, total dup: 11292886, max dup: 49 
    Average key length: 2.28, compression ratio: 3.96 
    Average prefix length: 8.77, average data length: 0.23 
    Clustering factor: 746287, ratio: 0.06 
    Fill distribution: 
         0 - 19% = 150 
        20 - 39% = 782 
        40 - 59% = 2681 
        60 - 79% = 1842 
        80 - 99% = 5371 
 
    Index XQS_1200_2000_SND_ID (2) 
    Root page: 1398638, depth: 3, leaf buckets: 15067, nodes: 11806604 
    Average node length: 6.03, total dup: 10313675, max dup: 62 
    Average key length: 2.80, compression ratio: 3.22 
    Average prefix length: 8.33, average data length: 0.67 
    Clustering factor: 2480567, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 6 
        20 - 39% = 70 
        40 - 59% = 9456 
        60 - 79% = 5088 
        80 - 99% = 447 
 
    Index XQS_1200_2000_WORKER_ID (0) 
    Root page: 1386211, depth: 3, leaf buckets: 11366, nodes: 11806604 
    Average node length: 5.24, total dup: 11806504, max dup: 197399 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.43, average data length: 0.00 
    Clustering factor: 734644, ratio: 0.06 
    Fill distribution: 
         0 - 19% = 77 
        20 - 39% = 804 
        40 - 59% = 5369 
        60 - 79% = 1562 
        80 - 99% = 3554 
 
XQS_2000_3300 (185) 
    Primary pointer page: 567, Index root page: 568 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index XQS_2000_3300_DOC_ID (1) 
    Root page: 1361753, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index XQS_2000_3300_RCV_ID (3) 
    Root page: 1361755, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index XQS_2000_3300_SND_ID (2) 
    Root page: 1361754, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index XQS_2000_3300_WORKER_ID (0) 
    Root page: 1361752, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
XQS_2100_3300 (186) 
    Primary pointer page: 569, Index root page: 570 
    Total formats: 1, used formats: 1 
    Average record length: 78.82, total records: 10213640 
    Average version length: 82.88, total versions: 484417, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.60 
    Pointer pages: 107, data page slots: 173936 
    Data pages: 173896, average fill: 73% 
    Primary pages: 173896, secondary pages: 0, swept pages: 66133 
    Empty pages: 314, full pages: 115659 
    Fill distribution: 
     0 - 19% = 1059 
    20 - 39% = 5198 
    40 - 59% = 21226 
    60 - 79% = 70505 
    80 - 99% = 75908 
 
    Index XQS_2100_3300_DOC_ID (1) 
    Root page: 1344686, depth: 3, leaf buckets: 12249, nodes: 10213640 
    Average node length: 5.18, total dup: 10184236, max dup: 1585 
    Average key length: 2.03, compression ratio: 4.43 
    Average prefix length: 8.97, average data length: 0.03 
    Clustering factor: 2054002, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 29 
        20 - 39% = 1371 
        40 - 59% = 8312 
        60 - 79% = 1884 
        80 - 99% = 653 
 
    Index XQS_2100_3300_RCV_ID (3) 
    Root page: 1355717, depth: 3, leaf buckets: 13937, nodes: 10213640 
    Average node length: 6.25, total dup: 8469586, max dup: 14 
    Average key length: 3.10, compression ratio: 2.90 
    Average prefix length: 8.07, average data length: 0.93 
    Clustering factor: 1547045, ratio: 0.15 
    Fill distribution: 
         0 - 19% = 201 
        20 - 39% = 3627 
        40 - 59% = 4614 
        60 - 79% = 2695 
        80 - 99% = 2800 
 
    Index XQS_2100_3300_SND_ID (2) 
    Root page: 1350049, depth: 3, leaf buckets: 12894, nodes: 10213640 
    Average node length: 5.43, total dup: 9759711, max dup: 99 
    Average key length: 2.28, compression ratio: 3.94 
    Average prefix length: 8.76, average data length: 0.24 
    Clustering factor: 2193930, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 29 
        20 - 39% = 1387 
        40 - 59% = 9075 
        60 - 79% = 1747 
        80 - 99% = 656 
 
    Index XQS_2100_3300_WORKER_ID (0) 
    Root page: 985805, depth: 3, leaf buckets: 10654, nodes: 10213640 
    Average node length: 5.15, total dup: 10213540, max dup: 161615 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.43, average data length: 0.00 
    Clustering factor: 1634395, ratio: 0.16 
    Fill distribution: 
         0 - 19% = 34 
        20 - 39% = 1170 
        40 - 59% = 5504 
        60 - 79% = 1761 
        80 - 99% = 2185 
 
XQS_3300_3400 (187) 
    Primary pointer page: 571, Index root page: 572 
    Total formats: 1, used formats: 1 
    Average record length: 67.45, total records: 589235 
    Average version length: 68.75, total versions: 6337, 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: 76% 
    Primary pages: 8080, secondary pages: 0, swept pages: 3458 
    Empty pages: 4, full pages: 7272 
    Fill distribution: 
     0 - 19% = 5 
    20 - 39% = 3 
    40 - 59% = 87 
    60 - 79% = 7860 
    80 - 99% = 125 
 
    Index XQS_3300_3400_DOC_ID (1) 
    Root page: 35956, depth: 3, leaf buckets: 754, nodes: 589235 
    Average node length: 5.95, total dup: 501909, max dup: 83 
    Average key length: 3.09, compression ratio: 2.91 
    Average prefix length: 8.06, average data length: 0.94 
    Clustering factor: 102436, ratio: 0.17 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 22 
        40 - 59% = 539 
        60 - 79% = 109 
        80 - 99% = 84 
 
    Index XQS_3300_3400_SND_ID (2) 
    Root page: 30249, depth: 3, leaf buckets: 771, nodes: 589235 
    Average node length: 6.15, total dup: 483432, max dup: 25 
    Average key length: 3.29, compression ratio: 2.74 
    Average prefix length: 7.89, average data length: 1.11 
    Clustering factor: 102497, ratio: 0.17 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 22 
        40 - 59% = 543 
        60 - 79% = 111 
        80 - 99% = 94 
 
    Index XQS_3300_3400_WORKER_ID (0) 
    Root page: 375548, depth: 2, leaf buckets: 584, nodes: 589235 
    Average node length: 4.86, total dup: 589135, max dup: 9597 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.41, average data length: 0.00 
    Clustering factor: 90942, ratio: 0.15 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 34 
        40 - 59% = 350 
        60 - 79% = 70 
        80 - 99% = 130 
 
ZDOC_DATA (170) 
    Primary pointer page: 537, Index root page: 538 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
ZDOC_LIST (169) 
    Primary pointer page: 535, Index root page: 536 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
ZINVNT_TURNOVER_LOG (171) 
    Primary pointer page: 539, Index root page: 540 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
ZPDISTR (174) 
    Primary pointer page: 545, Index root page: 546 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index ZPDISTR_ID (0) 
    Root page: 1504207, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
ZPSTORNED (175) 
    Primary pointer page: 547, Index root page: 548 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index ZPSTORNED_ID (0) 
    Root page: 1504206, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
ZQDISTR (172) 
    Primary pointer page: 541, Index root page: 542 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index ZQDISTR_ID (0) 
    Root page: 1504212, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index ZQDISTR_WARE_SNDOP_RCVOP (1) 
    Root page: 1504213, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
ZQSTORNED (173) 
    Primary pointer page: 543, Index root page: 544 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index ZQSTORNED_DOC_ID (1) 
    Root page: 1504209, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index ZQSTORNED_ID (0) 
    Root page: 1504208, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index ZQSTORNED_RCV_ID (3) 
    Root page: 1504211, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index ZQSTORNED_SND_ID (2) 
    Root page: 1504210, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
ZTMP_DEP_DOCS (168) 
    Primary pointer page: 533, Index root page: 534 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
ZTMP_SHOPPING_CART (167) 
    Primary pointer page: 531, Index root page: 532 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
Z_USED_VIEWS (144) 
    Primary pointer page: 484, Index root page: 485 
    Total formats: 1, used formats: 1 
    Average record length: 29.38, total records: 29 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 99.00, compression ratio: 3.37 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 16% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index Z_USED_VIEWS_UNQ (0) 
    Root page: 1510350, depth: 1, leaf buckets: 1, nodes: 29 
    Average node length: 15.17, total dup: 0, max dup: 0 
    Average key length: 14.14, compression ratio: 1.44 
    Average prefix length: 9.17, average data length: 11.17 
    Clustering factor: 1, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
Gstat completion time Sun Mar 24 01:11:44 2024

Record versions statistics, table

TABLE_NAME TOTAL_RECS TOTAL_VERS MAX_VERSIONS VERS_TO_RECS_PRC MAXV_TO_VERS_PRC
DOC_DATA 7868738 95867 1 0.0000 0.0000
DOC_LIST 2309898 93005 3 0.0000 0.0000
FB_ERRORS 2182 757 1 0.0000 0.0000
INVNT_SALDO 400 235610 612 58900.0000 0.0000
INVNT_TURNOVER_LOG 103172 92442 1 0.0000 0.0000
MONEY_SALDO 49 18466 960 37600.0000 0.0000
MONEY_TURNOVER_LOG 1830 1735 1 0.0000 0.0000
PDISTR 757670 73694 5 0.0000 0.0000
PERF_SPLIT_0 178493 11544 1 0.0000 0.0000
PERF_SPLIT_1 174581 9529 1 0.0000 0.0000
PERF_SPLIT_2 201476 16574 1 0.0000 0.0000
PERF_SPLIT_3 173711 4860 1 0.0000 0.0000
PERF_SPLIT_4 192463 25413 1 0.0000 0.0000
PERF_SPLIT_5 175944 4164 1 0.0000 0.0000
PERF_SPLIT_6 197273 28387 1 0.0000 0.0000
PERF_SPLIT_7 208199 24422 1 0.0000 0.0000
PERF_SPLIT_8 177456 5257 1 0.0000 0.0000
PERF_SPLIT_9 184748 12968 1 0.0000 0.0000
PSTORNED 2168212 41403 1 0.0000 0.0000
SEMAPHORES 5 1 1 0.0000 100.0000
XQD_1000_1200 146901 67219 1 0.0000 0.0000
XQD_1000_3300 6782557 422198 1 0.0000 0.0000
XQD_1200_2000 11771395 379033 1 0.0000 0.0000
XQD_2000_3300 1776909 771908 1 0.0000 0.0000
XQD_2100_3300 1171214 510578 1 0.0000 0.0000
XQD_3300_3400 9682996 536671 1 0.0000 0.0000
XQS_1000_1200 21221073 15940 1 0.0000 0.0000
XQS_1000_3300 10117290 507481 1 0.0000 0.0000
XQS_1200_2000 11806604 411744 1 0.0000 0.0000
XQS_2100_3300 10213640 484417 1 0.0000 0.0000
XQS_3300_3400 589235 6337 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 ---
:209: 
:210: mscs-test-161.budzdorov.ru    Sun Mar 24 01:09:43 2024
:211:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:212: 
:213: 
:214: mscs-test-161.budzdorov.ru    Sun Mar 24 01:09:51 2024
:215:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:216: 
:217: 
:218: mscs-test-161.budzdorov.ru    Sun Mar 24 01:09:51 2024
:219:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:220: 
:221: 
:222: mscs-test-161.budzdorov.ru    Sun Mar 24 01:09:53 2024
:223:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:224: 
:225: 
:226: mscs-test-161.budzdorov.ru    Sun Mar 24 01:09:54 2024
:227:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:228: 
--- end of diff output ---

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

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