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

Hardware and OS info

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

Server and database settinfs 


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

Test configuration settings 

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

Test finish info 


FINISH_STATE                    NORMAL: TEST_TIME EXPIRED AT 2024-02-29 01:09:38
DTS_END                         2024-02-29 01:09:38.6380
FB_GDSCODE                      -1
FB_MNEMONA                      
STACK                           SP_CANCEL_SUPPLIER_ORDER(116:18) ==> SP_CANCEL_CUSTOMER_RESERVE(36:5) ==> SP_CHECK_TO_STOP_WORK(32:12) ==> SP_HALT_ON_ERROR(57:17)
IP                              ::1/52716
TRN_ID                          163591
ATT_ID                          559
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: 8947.02 23970 894702
customer order: creation 163.26 377 16326
customer order: refuse 13.79 412 1379
order to supplier: creation 44.05 1215 4405
order to supplier: removal 3.44 103268 344
invoice (draft): creation 43.27 3528 4327
invoice (draft): removal 48.36 939 4836
invoice accept: apply 40.57 23189 4057
invoice accept: cancel 43.82 872 4382
customer reserve: creation 3946.67 220 394667
customer reserve: removal 4325.55 63 432555
realization accept: apply 76.47 189 7647
realization accept: cancel 75.98 125 7598
payment from customer: creation 55.97 166 5597
payment from customer: removal 5.19 84 519
payment to supplier: creation 45.66 176 4566
payment to supplier: removal 3.47 80 347
service: total inventory turnovers 4.63 1151 463
service: total monetary turnovers 5.99 24 599
service: aggregate perf. data 0.85 18571 85
service: refresh index statistics 0.03 324754 3

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:02, from 29-02-2024 01:11:41 to 29-02-2024 01:11:43.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 3481
TEST_TIME 2 4287
TEST_TIME 3 4135
TEST_TIME 4 4308
TEST_TIME 5 4843
TEST_TIME 6 4990
TEST_TIME 7 5531
TEST_TIME 8 5813
TEST_TIME 9 5738
TEST_TIME 10 5532
TEST_TIME 11 5624
TEST_TIME 12 5632
TEST_TIME 13 5605
TEST_TIME 14 5740
TEST_TIME 15 6092
TEST_TIME 16 6290
TEST_TIME 17 6646
TEST_TIME 18 6607
TEST_TIME 19 6775
TEST_TIME 20 7101
TEST_TIME 21 7186
TEST_TIME 22 7216
TEST_TIME 23 7206
TEST_TIME 24 7248
TEST_TIME 25 7498
TEST_TIME 26 7361
TEST_TIME 27 7496
TEST_TIME 28 7680
TEST_TIME 29 8754
TEST_TIME 30 9430
TEST_TIME 31 9228
TEST_TIME 32 9165
TEST_TIME 33 9180
TEST_TIME 34 9125
TEST_TIME 35 9167
TEST_TIME 36 9033
TEST_TIME 37 9045
TEST_TIME 38 8984
TEST_TIME 39 9093
TEST_TIME 40 8934
TEST_TIME 41 8811
TEST_TIME 42 8912
TEST_TIME 43 8926
TEST_TIME 44 8813
TEST_TIME 45 8866
TEST_TIME 46 8790
TEST_TIME 47 8838
TEST_TIME 48 8915
TEST_TIME 49 8798
TEST_TIME 50 8711
TEST_TIME 51 8677
TEST_TIME 52 8687
TEST_TIME 53 8645
TEST_TIME 54 8598
TEST_TIME 55 8578
TEST_TIME 56 8682
TEST_TIME 57 8752
TEST_TIME 58 8803
TEST_TIME 59 8758
TEST_TIME 60 8798
TEST_TIME 61 8831
TEST_TIME 62 8863
TEST_TIME 63 8904
TEST_TIME 64 8900
TEST_TIME 65 8937
TEST_TIME 66 9015
TEST_TIME 67 9043
TEST_TIME 68 9014
TEST_TIME 69 9010
TEST_TIME 70 8959
TEST_TIME 71 8949
TEST_TIME 72 8910
TEST_TIME 73 8893
TEST_TIME 74 8849
TEST_TIME 75 8822
TEST_TIME 76 8831
TEST_TIME 77 8848
TEST_TIME 78 8840
TEST_TIME 79 8982
TEST_TIME 80 8978
TEST_TIME 81 9002
TEST_TIME 82 9071
TEST_TIME 83 9058
TEST_TIME 84 9099
TEST_TIME 85 9083
TEST_TIME 86 9099
TEST_TIME 87 9127
TEST_TIME 88 9172
TEST_TIME 89 9224
TEST_TIME 90 9189
TEST_TIME 91 9128
TEST_TIME 92 9103
TEST_TIME 93 9089
TEST_TIME 94 9089
TEST_TIME 95 9068
TEST_TIME 96 9031
TEST_TIME 97 9037
TEST_TIME 98 9010
TEST_TIME 99 8949
TEST_TIME 100 8954

Performance per minute, chart


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

Performance in DETAILS

UNIT CNT_ALL CNT_OK CNT_ERR ERR_PRC OK_MIN_MS OK_MAX_MS OK_AVG_MS CNT_LK_CONFL CNT_USER_EXC
doc_list_aiud 1254556 1254556 0 0.00 0 20684 8 0 0
doc_list_biud 1254556 1254556 0 0.00 0 51568 28 0 0
sp_add_invoice_to_stock 4170 4057 113 2.70 34 231488 23190 0 113
sp_cancel_adding_invoice 4382 4382 0 0.00 3 62164 872 0 0
sp_cancel_client_order 1379 1379 0 0.00 5 9596 412 0 0
sp_cancel_customer_reserve 432555 432555 0 0.00 0 43536 63 0 0
sp_cancel_pay_from_customer 519 519 0 0.00 3 4697 85 0 0
sp_cancel_pay_to_supplier 347 347 0 0.00 3 3961 81 0 0
sp_cancel_supplier_invoice 4842 4836 6 0.12 1 51579 940 0 6
sp_cancel_supplier_order 344 344 0 0.00 6 1168964 103268 0 0
sp_cancel_write_off 7598 7598 0 0.00 1 15251 126 0 0
sp_client_order 16326 16326 0 0.00 3 24841 377 0 0
sp_customer_reserve 394667 394667 0 0.00 0 42303 220 0 0
sp_fill_shopping_cart 25046 25046 0 0.00 1 13309 42 0 0
sp_fill_shopping_cart_clo_res 394650 394650 0 0.00 0 14513 16 0 0
sp_get_clo_for_invoice 4040 4040 0 0.00 0 18412 346 0 0
sp_kill_cost_storno 12846 12846 0 0.00 0 15248 72 0 0
sp_kill_qstorno_ret_qs2qd 877888 877888 0 0.00 0 51567 35 0 0
sp_kill_qty_storno 462781 462781 0 0.00 0 51568 75 0 0
sp_lock_selected_doc 16309 16309 0 0.00 0 8258 5 0 0
sp_make_cost_storno 21850 21850 0 0.00 0 15679 69 0 0
sp_multiply_rows_for_pdistr 21850 21850 0 0.00 0 20681 44 0 0
sp_multiply_rows_for_qdistr 16326 16326 0 0.00 0 15714 169 0 0
sp_pay_from_customer 5597 5597 0 0.00 4 20687 166 0 0
sp_pay_to_supplier 4566 4566 0 0.00 4 20401 176 0 0
sp_payment_common 10163 10163 0 0.00 2 15660 35 0 0
sp_qd_handle_on_cancel_clo 1379 1379 0 0.00 0 9587 370 0 0
sp_qd_handle_on_invoice_upd_sts 8422 8422 0 0.00 0 18774 345 0 0
sp_qd_handle_on_reserve_upd_sts 7647 7647 0 0.00 0 18833 61 0 0
sp_reserve_write_off 7647 7647 0 0.00 6 19034 190 0 0
sp_supplier_invoice 4327 4327 0 0.00 5 88168 3529 0 0
sp_supplier_order 4405 4405 0 0.00 5 27539 1215 0 0
srv_aggregate_perf_data 85 85 0 0.00 1869 133968 18572 0 0
srv_fill_mon_cache_memory 57 57 0 0.00 2369 121103 38860 0 0
srv_find_qd_qs_mism 853167 853167 0 0.00 0 17986 6 0 0
srv_make_invnt_saldo 463 463 0 0.00 41 66361 1152 0 0
srv_make_money_saldo 599 599 0 0.00 1 333 24 0 0
srv_recalc_idx_stat 3 3 0 0.00 185685 412854 324755 0 0
t$perf-abend:sp_add_invoice_to_stock 113 113 0 0.00 0 0 0 0 0
t$perf-abend:sp_cancel_supplier_invoice 6 6 0 0.00 0 0 0 0 0
t$perf-norm:sp_add_invoice_to_stock 4057 4057 0 0.00 0 10858 193 0 0
t$perf-norm:sp_cancel_adding_invoice 312 312 0 0.00 0 1988 93 0 0
t$perf-norm:sp_cancel_client_order 1379 1379 0 0.00 0 2676 13 0 0
t$perf-norm:sp_cancel_customer_reserve 584 584 0 0.00 0 2448 16 0 0
t$perf-norm:sp_cancel_pay_from_customer 519 519 0 0.00 0 165 1 0 0
t$perf-norm:sp_cancel_pay_to_supplier 347 347 0 0.00 0 621 6 0 0
t$perf-norm:sp_cancel_supplier_invoice 327 327 0 0.00 0 2880 26 0 0
t$perf-norm:sp_cancel_supplier_order 344 344 0 0.00 0 33598 1808 0 0
t$perf-norm:sp_cancel_write_off 811 811 0 0.00 0 1557 6 0 0
t$perf-norm:sp_client_order 16326 16326 0 0.00 0 9010 17 0 0
t$perf-norm:sp_customer_reserve 836 836 0 0.00 0 1935 6 0 0
t$perf-norm:sp_pay_from_customer 5597 5597 0 0.00 0 8730 13 0 0
t$perf-norm:sp_pay_to_supplier 4566 4566 0 0.00 0 5837 11 0 0
t$perf-norm:sp_reserve_write_off 7647 7647 0 0.00 0 10267 14 0 0
t$perf-norm:sp_supplier_invoice 4327 4327 0 0.00 0 7595 22 0 0
t$perf-norm:sp_supplier_order 4405 4405 0 0.00 0 2871 15 0 0
t$perf-norm:srv_aggregate_perf_data 85 85 0 0.00 0 143 5 0 0
t$perf-norm:srv_fill_mon_cache_memory 57 57 0 0.00 0 184 5 0 0
t$perf-norm:srv_make_invnt_saldo 463 463 0 0.00 0 1175 27 0 0
t$perf-norm:srv_make_money_saldo 599 599 0 0.00 0 909 19 0 0
t$perf-norm:srv_recalc_idx_stat 3 3 0 0.00 1 9 4 0 0
v_add_invoice_to_stock 8304 8078 226 2.72 0 3488 18 0 226
v_all_customers 30480 30480 0 0.00 0 159 1 0 0
v_all_suppliers 24524 24524 0 0.00 0 22 1 0 0
v_all_wares 32652 32652 0 0.00 0 19 1 0 0
v_cancel_adding_invoice 624 624 0 0.00 0 216 6 0 0
v_cancel_client_order 2758 2758 0 0.00 0 3956 8 0 0
v_cancel_customer_prepayment 1038 1038 0 0.00 0 2162 7 0 0
v_cancel_customer_reserve 1168 1168 0 0.00 0 2597 7 0 0
v_cancel_payment_to_supplier 694 694 0 0.00 0 676 6 0 0
v_cancel_supplier_invoice 666 654 12 1.80 0 2956 19 0 12
v_cancel_supplier_order 688 688 0 0.00 0 1943 8 0 0
v_cancel_write_off 1622 1622 0 0.00 0 3638 15 0 0
v_max_id_clo_ord 4403 4403 0 0.00 0 1870 2 0 0
v_max_id_clo_res 836 836 0 0.00 0 1844 14 0 0
v_max_id_ord_sup 4317 4317 0 0.00 0 3713 4 0 0
v_max_non_paid_invoice 1024 1024 0 0.00 0 2247 5 0 0
v_max_non_paid_realizn 2551 2551 0 0.00 0 13310 12 0 0
v_min_id_clo_ord 4403 4403 0 0.00 0 6606 12 0 0
v_min_id_clo_res 836 836 0 0.00 0 1132 5 0 0
v_min_id_ord_sup 4317 4317 0 0.00 0 6657 11 0 0
v_min_non_paid_invoice 4566 4566 0 0.00 0 11344 20 0 0
v_min_non_paid_realizn 5597 5597 0 0.00 0 13135 28 0 0
v_our_firm 8264 8264 0 0.00 0 20 1 0 0
v_reserve_write_off 15294 15294 0 0.00 0 3420 5 0 0
x_lock_depdocs_on_canc_invoice 8891 8891 0 0.00 0 13018 133 0 0
x_lock_depdocs_on_canc_sup_ord 344 344 0 0.00 0 5681 372 0 0
x_make_qstorno_1000_1200 4405 4405 0 0.00 1 27531 1122 0 0
x_make_qstorno_1200_2000 4327 4327 0 0.00 2 88162 3378 0 0
x_make_qstorno_2100_3300 394667 394667 0 0.00 0 42231 201 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 29-02-2024 01:11:49 to 29-02-2024 01:11:53.

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:42 2 8192000000 8797116768 8807743488 3953616 0.048 1 1 2 0 4051888 55488 42784
23:10:43 26529 8192000000 9887164336 10196574208 964913328 10.537 100 84 167 0 992515568 5772944 21829296
23:12:12 27788 8192000000 9947702288 10269712384 1026966864 11.139 100 87 174 0 1057246608 8065360 22214384
23:13:46 6284 8192000000 9979022384 10309468160 1064941424 11.504 100 87 174 0 1096622160 9508896 22171840
23:14:55 13289 8192000000 10014802560 10359107584 1103176112 11.868 100 79 158 0 1132299216 10015472 19107632
23:16:10 4702 8192000000 10060803312 10415017984 1147716624 12.288 100 80 157 0 1178114000 12464000 17933376
23:17:18 3158 8192000000 10102923280 10464821248 1189103920 12.675 100 89 178 0 1223213072 14663360 19445792
23:18:23 2627 8192000000 10134844160 10506768384 1228714192 13.042 100 87 174 0 1262575536 14662352 19198992
23:19:28 2924 8192000000 10179900832 10559127552 1263416944 13.361 100 87 173 0 1294422480 11885568 19119968
23:20:34 1059 8192000000 10207495328 10592800768 1292596304 13.628 100 93 186 2 1325296400 12411760 20288336
23:21:38 1153 8192000000 10214408384 10606133248 1304639088 13.737 100 89 175 1 1338324560 13326272 20359200
23:22:41 4231 8192000000 10207610480 10608721920 1307441520 13.763 100 65 127 0 1329650768 6257232 15952016
23:23:46 7570 8192000000 10198153952 10616676352 1315351936 13.835 100 25 51 0 1328218640 6670688 6196016
23:24:55 4421 8192000000 10224743808 10630950912 1324310256 13.916 100 34 68 3 1338000256 5758816 7931184
23:26:02 6722 8192000000 10226407360 10640216064 1336646880 14.027 100 21 43 2 1346509760 4982528 4880352
23:27:11 9184 8192000000 10221306160 10645270528 1340377632 14.061 100 24 48 0 1352715312 7414944 4922736
23:28:21 42878 8192000000 10232296144 10660724736 1342508416 14.080 100 24 48 0 1354116672 6423056 5185200
23:30:08 16525 8192000000 10245878032 10659606528 1332386736 13.989 99 43 82 2 1348801920 7052336 9362848
23:31:29 8354 8192000000 10261725312 10678644736 1354422976 14.187 100 59 116 0 1377383568 9818944 13141648
23:32:43 24192 8192000000 10250470896 10665246720 1327892144 13.948 98 43 86 0 1348169168 10179760 10097264
23:34:14 14495 8192000000 10267218768 10687504384 1359065248 14.229 100 52 103 1 1384546512 14161408 11319856
23:35:32 23195 8192000000 10251253632 10667810816 1324569360 13.918 98 50 100 0 1351864912 15299920 11995632
23:37:04 7553 8192000000 10262638496 10677264384 1332009200 13.985 98 52 104 0 1358496432 15250096 11237136
23:38:14 15527 8192000000 10242391648 10649501696 1299308896 13.689 97 39 76 0 1329207328 21127680 8770752
23:39:45 18041 8192000000 10236308944 10639425536 1309730880 13.784 98 47 94 0 1340032752 19568544 10733328
23:41:09 27045 8192000000 10274847088 10687930368 1336820336 14.029 98 47 94 2 1370692976 22619392 11253248
23:42:50 5885 8192000000 10260999200 10658533376 1310454224 13.790 98 64 126 1 1351755696 25786064 15515408
23:44:01 3319 8192000000 10260158752 10654846976 1328609888 13.955 100 63 124 0 1371431232 27480384 15340960
23:45:08 5685 8192000000 10274600464 10670886912 1332479968 13.990 100 66 132 0 1378940896 30117456 16343472
23:46:22 5172 8192000000 10301472976 10702782464 1354714528 14.190 100 83 165 0 1407857328 33711024 19431776
23:47:38 6913 8192000000 10305329344 10702561280 1357276048 14.213 100 75 150 1 1410628048 35082800 18269200
23:48:54 2871 8192000000 10336664480 10737717248 1366669760 14.297 99 83 162 1 1426389904 39547104 20173040
23:50:04 10333 8192000000 10323603744 10733608960 1379291392 14.410 100 63 124 0 1428464416 33434912 15738112
23:51:20 2367 8192000000 10332542560 10742603776 1386958624 14.479 100 62 121 0 1438556768 36138080 15460064
23:52:31 6423 8192000000 10333769760 10758729728 1394737040 14.548 100 39 78 0 1444989504 39376512 10875952
23:53:43 19345 8192000000 10338543504 10769539072 1398126992 14.578 100 31 62 0 1448135296 41265200 8743104
23:55:28 21597 8192000000 10338499184 10774212608 1390761168 14.513 100 28 56 0 1446682064 47763952 8156944
23:57:17 31369 8192000000 10348826688 10787352576 1382509920 14.439 100 25 50 0 1455150496 64843392 7797184
23:59:05 22802 8192000000 10324045680 10775490560 1393275296 14.535 100 16 32 2 1435596160 38081808 4239056
00:00:47 13387 8192000000 10320425024 10754703360 1392013616 14.524 100 60 112 3 1424171248 19574208 12583424
00:02:00 7776 8192000000 10311992064 10750885888 1389643120 14.503 100 44 88 1 1416329776 15825584 10861072
00:03:20 14132 8192000000 10310593600 10752675840 1397299056 14.571 100 35 71 0 1418999856 13328720 8372080
00:04:53 58163 8192000000 10310363488 10762330112 1395486320 14.555 100 20 40 0 1424383520 24426096 4471104
00:06:53 45124 8192000000 10311357488 10772062208 1379674752 14.414 99 14 28 0 1409367024 25860704 3831568
00:08:38 80186 8192000000 10307297600 10753695744 1396095088 14.560 100 20 39 1 1406796560 6043104 4658368
00:11:00 74905 8192000000 10311090352 10778415104 1411188224 14.694 100 21 42 0 1431133584 15438112 4507248
00:13:31 15472 8192000000 10307501888 10766663680 1408493152 14.671 100 11 22 0 1422606576 11852208 2261216
00:14:49 9911 8192000000 10321777136 10770944000 1416505920 14.742 100 32 63 0 1431388704 7776656 7106128
00:16:02 84463 8192000000 10307249552 10772598784 1393542832 14.537 98 17 33 0 1408656464 11288880 3824752
00:18:34 54055 8192000000 10294328752 10751897600 1363485280 14.269 96 25 49 1 1377180736 8085200 5610256
00:20:28 76178 8192000000 10299646352 10764455936 1397283664 14.571 100 26 51 0 1418978176 16233264 5461248
00:22:48 77730 8192000000 10287063936 10754842624 1389818704 14.504 99 18 36 0 1403555808 9607280 4129824
00:25:06 100871 8192000000 10288295248 10757492736 1363595872 14.270 98 14 28 0 1384514560 17630080 3288608
00:27:50 73351 8192000000 10292113952 10746408960 1351775680 14.163 97 21 40 0 1366036480 9857568 4403232
00:30:03 27925 8192000000 10285983312 10731372544 1351000000 14.156 98 27 55 0 1370558608 13565888 5992720
00:31:35 66545 8192000000 10282758128 10719150080 1312038432 13.805 95 19 36 0 1327538528 11460192 4039904
00:33:44 57168 8192000000 10247164160 10694074368 1289768272 13.602 95 29 58 0 1309040656 13095744 6176640
00:35:44 121103 8192000000 10242644016 10689576960 1205816768 12.830 89 18 34 0 1222604080 13317600 3469712
00:38:45 108213 8192000000 10249326720 10696990720 1289776576 13.602 95 29 58 1 1315377264 19199280 6401408
00:41:39 20310 8192000000 10237946288 10675957760 1315075904 13.832 98 15 29 1 1330864368 13249872 2538592
00:43:00 50686 8192000000 10222605280 10664116224 1315005936 13.831 99 7 14 0 1322701616 6053904 1641776
00:44:52 66527 8192000000 10251488880 10690150400 1306414384 13.754 97 14 28 0 1323207408 13659456 3133568
00:46:59 58008 8192000000 10268028128 10707263488 1355761808 14.199 100 15 30 0 1371185344 11845664 3577872
00:49:02 30243 8192000000 10276488816 10714394624 1366542880 14.296 100 12 24 0 1377514928 8611440 2360608
00:50:35 49419 8192000000 10284709904 10729558016 1373784912 14.361 100 26 52 0 1393349104 13917888 5646304
00:52:27 4474 8192000000 10292947712 10719436800 1371489616 14.340 100 72 143 1 1396467200 8932192 16045392
00:53:33 38722 8192000000 10307544256 10738950144 1380852848 14.424 100 26 51 0 1396442832 9867472 5722512
00:55:17 44129 8192000000 10313993008 10755354624 1377875760 14.398 99 14 28 0 1395421936 14752912 2793264
00:57:11 33790 8192000000 10316891888 10760667136 1377458256 14.394 99 24 48 0 1397617456 15281424 4877776
00:58:45 116788 8192000000 10274623024 10717605888 1320999872 13.886 95 17 34 0 1334838992 9658224 4180896
01:01:43 75921 8192000000 10292536544 10750447616 1386958976 14.479 100 27 53 0 1404411360 11805664 5646720
01:04:16 58188 8192000000 10283349216 10741002240 1384803264 14.459 100 11 22 0 1397351360 10266832 2281264
01:06:15 38433 8192000000 10284400032 10736611328 1374666496 14.369 99 13 26 0 1386079472 8420176 2992800
01:07:59 63685 8192000000 10293972368 10746306560 1387501856 14.484 100 26 52 0 1406594032 12961216 6130960

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:14, from 29-02-2024 01:11:55 to 29-02-2024 01:12:09.

Exceptions occured during test was in run

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

Completed "Exceptions occured during test was in run". Done for 00:00:02, from 29-02-2024 01:12:10 to 29-02-2024 01:12:12.

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          161816
MON$OLDEST_ACTIVE               163965
MON$OLDEST_SNAPSHOT             163965
MON$NEXT_TRANSACTION            163965
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                       1897568
MON$STAT_ID                     1
MON$BACKUP_STATE                0
MON$CRYPT_PAGE                  0
MON$OWNER                       SYSDBA                                                                                       
MON$SEC_DATABASE                Default


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

Database statistics 

 
Database "/home/bases/oltp30-etalone.fdb" 
Gstat execution time Thu Feb 29 01:12:13 2024 
 
Database header page information: 
    Flags            0 
    Generation        85726 
    System Change Number    0 
    Page size        8192 
    ODS version        12.0 
    Oldest transaction    161816 
    Oldest active        163965 
    Oldest snapshot        163965 
    Next transaction    163966 
    Sequence number        0 
    Next attachment ID    687 
    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.52, total records: 7702523 
    Average version length: 48.16, total versions: 59544, 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: 86832 
    Data pages: 86832, average fill: 71% 
    Primary pages: 86832, secondary pages: 0, swept pages: 28304 
    Empty pages: 7, full pages: 55059 
    Fill distribution: 
     0 - 19% = 14 
    20 - 39% = 218 
    40 - 59% = 3233 
    60 - 79% = 83351 
    80 - 99% = 16 
 
    Index DOC_DATA_DOC_WARE_UNQ (0) 
    Root page: 1510614, depth: 3, leaf buckets: 23110, nodes: 7702523 
    Average node length: 18.88, total dup: 0, max dup: 0 
    Average key length: 15.89, compression ratio: 1.70 
    Average prefix length: 14.11, average data length: 12.89 
    Clustering factor: 1697332, ratio: 0.22 
    Fill distribution: 
         0 - 19% = 318 
        20 - 39% = 1855 
        40 - 59% = 4050 
        60 - 79% = 2368 
        80 - 99% = 14519 
 
    Index DOC_DATA_ID_DESC (1) 
    Root page: 1528118, depth: 3, leaf buckets: 13412, nodes: 7702523 
    Average node length: 11.20, total dup: 0, max dup: 0 
    Average key length: 8.21, compression ratio: 1.10 
    Average prefix length: 3.78, average data length: 5.22 
    Clustering factor: 1521489, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 1595 
        40 - 59% = 1954 
        60 - 79% = 1098 
        80 - 99% = 8765 
 
    Index FK_DOC_DATA_DOC_LIST (2) 
    Root page: 1546711, depth: 3, leaf buckets: 8281, nodes: 7702523 
    Average node length: 6.61, total dup: 5768961, max dup: 49 
    Average key length: 3.62, compression ratio: 2.48 
    Average prefix length: 7.63, average data length: 1.37 
    Clustering factor: 1514366, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 129 
        20 - 39% = 969 
        40 - 59% = 1351 
        60 - 79% = 906 
        80 - 99% = 4926 
 
DOC_LIST (138) 
    Primary pointer page: 472, Index root page: 473 
    Total formats: 1, used formats: 1 
    Average record length: 56.60, total records: 2223349 
    Average version length: 34.70, total versions: 62113, max versions: 4 
    Average fragment length: 4.00, total fragments: 1, max fragments: 1 
    Average unpacked length: 84.00, compression ratio: 1.48 
    Pointer pages: 18, data page slots: 28408 
    Data pages: 28408, average fill: 72% 
    Primary pages: 28401, secondary pages: 7, swept pages: 11969 
    Empty pages: 16, full pages: 18679 
    Fill distribution: 
     0 - 19% = 25 
    20 - 39% = 165 
    40 - 59% = 2148 
    60 - 79% = 25705 
    80 - 99% = 365 
 
    Index DOC_LIST_ID_DESC (1) 
    Root page: 1541130, depth: 3, leaf buckets: 4504, nodes: 2223349 
    Average node length: 11.41, total dup: 0, max dup: 0 
    Average key length: 8.45, compression ratio: 1.07 
    Average prefix length: 3.55, average data length: 5.45 
    Clustering factor: 691549, ratio: 0.31 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 894 
        40 - 59% = 826 
        60 - 79% = 744 
        80 - 99% = 2040 
 
    Index DOC_LIST_WORKER_OPTYPE (2) 
    Root page: 1544376, depth: 3, leaf buckets: 2506, nodes: 2225447 
    Average node length: 4.97, total dup: 2224548, max dup: 17662 
    Average key length: 2.01, compression ratio: 4.47 
    Average prefix length: 8.99, average data length: 0.01 
    Clustering factor: 1240936, ratio: 0.56 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 298 
        40 - 59% = 1512 
        60 - 79% = 512 
        80 - 99% = 182 
 
    Index FK_DOC_LIST_AGENTS (3) 
    Root page: 1545909, depth: 3, leaf buckets: 2033, nodes: 2223349 
    Average node length: 4.97, total dup: 2223299, max dup: 130036 
    Average key length: 2.01, compression ratio: 4.48 
    Average prefix length: 8.99, average data length: 0.01 
    Clustering factor: 1054288, ratio: 0.47 
    Fill distribution: 
         0 - 19% = 4 
        20 - 39% = 163 
        40 - 59% = 989 
        60 - 79% = 41 
        80 - 99% = 836 
 
    Index PK_DOC_LIST (0) 
    Root page: 1538187, depth: 3, leaf buckets: 4330, nodes: 2223349 
    Average node length: 11.41, total dup: 0, max dup: 0 
    Average key length: 8.45, compression ratio: 1.07 
    Average prefix length: 3.55, average data length: 5.45 
    Clustering factor: 691549, ratio: 0.31 
    Fill distribution: 
         0 - 19% = 119 
        20 - 39% = 590 
        40 - 59% = 611 
        60 - 79% = 847 
        80 - 99% = 2163 
 
DOC_STATES (149) 
    Primary pointer page: 494, Index root page: 495 
    Total formats: 1, used formats: 1 
    Average record length: 67.50, total records: 4 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 650.00, compression ratio: 9.63 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 4% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index DOC_STATES_MCODE_UNQ (1) 
    Root page: 1504315, depth: 1, leaf buckets: 1, nodes: 4 
    Average node length: 17.75, total dup: 0, max dup: 0 
    Average key length: 16.50, compression ratio: 1.08 
    Average prefix length: 4.00, average data length: 13.75 
    Clustering factor: 1, ratio: 0.25 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index DOC_STATES_NAME_UNQ (2) 
    Root page: 1504316, depth: 1, leaf buckets: 1, nodes: 4 
    Average node length: 33.25, total dup: 0, max dup: 0 
    Average key length: 32.00, compression ratio: 0.99 
    Average prefix length: 2.50, average data length: 29.25 
    Clustering factor: 1, ratio: 0.25 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PK_DOC_STATES (0) 
    Root page: 1504314, depth: 1, leaf buckets: 1, nodes: 4 
    Average node length: 4.75, total dup: 0, max dup: 0 
    Average key length: 3.50, compression ratio: 0.86 
    Average prefix length: 1.50, average data length: 1.50 
    Clustering factor: 1, ratio: 0.25 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
FB_ERRORS (155) 
    Primary pointer page: 506, Index root page: 507 
    Total formats: 2, used formats: 2 
    Average record length: 54.76, total records: 2182 
    Average version length: 79.61, total versions: 757, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 270.43, compression ratio: 4.94 
    Pointer pages: 1, data page slots: 40 
    Data pages: 40, average fill: 70% 
    Primary pages: 40, secondary pages: 0, swept pages: 0 
    Empty pages: 7, full pages: 32 
    Fill distribution: 
     0 - 19% = 7 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 7 
    80 - 99% = 26 
 
    Index FB_ERRORS_GDS_CODE (0) 
    Root page: 382, depth: 2, leaf buckets: 2, nodes: 2182 
    Average node length: 4.40, total dup: 756, max dup: 1 
    Average key length: 2.67, compression ratio: 1.87 
    Average prefix length: 4.33, average data length: 0.67 
    Clustering factor: 1515, ratio: 0.69 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 0 
        40 - 59% = 1 
        60 - 79% = 1 
        80 - 99% = 0 
 
INVNT_SALDO (145) 
    Primary pointer page: 486, Index root page: 487 
    Total formats: 2, used formats: 1 
    Average record length: 82.45, total records: 400 
    Average version length: 23.08, total versions: 224509, max versions: 586 
    Average fragment length: 2.06, total fragments: 47, max fragments: 1 
    Average unpacked length: 104.00, compression ratio: 1.26 
    Pointer pages: 1, data page slots: 1256 
    Data pages: 1256, average fill: 89% 
    Primary pages: 11, secondary pages: 1245, swept pages: 0 
    Empty pages: 4, full pages: 1251 
    Fill distribution: 
     0 - 19% = 4 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 2 
    80 - 99% = 1250 
 
    Index PK_INVNT_SALDO (0) 
    Root page: 1510349, depth: 1, leaf buckets: 1, nodes: 400 
    Average node length: 11.22, total dup: 0, max dup: 0 
    Average key length: 10.22, compression ratio: 0.88 
    Average prefix length: 1.78, average data length: 7.22 
    Clustering factor: 326, ratio: 0.81 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 0 
        40 - 59% = 1 
        60 - 79% = 0 
        80 - 99% = 0 
 
INVNT_TURNOVER_LOG (153) 
    Primary pointer page: 502, Index root page: 503 
    Total formats: 1, used formats: 1 
    Average record length: 11.57, total records: 105467 
    Average version length: 68.29, total versions: 87602, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 88.00, compression ratio: 7.61 
    Pointer pages: 7, data page slots: 2576 
    Data pages: 1632, average fill: 79% 
    Primary pages: 1631, secondary pages: 1, swept pages: 0 
    Empty pages: 17, full pages: 1255 
    Fill distribution: 
     0 - 19% = 38 
    20 - 39% = 80 
    40 - 59% = 133 
    60 - 79% = 290 
    80 - 99% = 1091 
 
    Index INVNT_TURNOVER_LOG_WARE_DD_ID (0) 
    Root page: 1704847, depth: 3, leaf buckets: 316, nodes: 105467 
    Average node length: 13.38, total dup: 6552, max dup: 2 
    Average key length: 10.70, compression ratio: 2.52 
    Average prefix length: 19.23, average data length: 7.77 
    Clustering factor: 77732, ratio: 0.74 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 22 
        40 - 59% = 203 
        60 - 79% = 45 
        80 - 99% = 45 
 
MONEY_SALDO (141) 
    Primary pointer page: 478, Index root page: 479 
    Total formats: 1, used formats: 1 
    Average record length: 15.29, total records: 49 
    Average version length: 9.00, total versions: 17353, max versions: 918 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 32.00, compression ratio: 2.09 
    Pointer pages: 1, data page slots: 64 
    Data pages: 64, average fill: 87% 
    Primary pages: 2, secondary pages: 62, swept pages: 0 
    Empty pages: 1, full pages: 62 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 11 
    80 - 99% = 52 
 
    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: 6.47, total records: 2144 
    Average version length: 43.25, total versions: 1835, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 58.00, compression ratio: 8.97 
    Pointer pages: 1, data page slots: 96 
    Data pages: 30, average fill: 66% 
    Primary pages: 30, secondary pages: 0, swept pages: 4 
    Empty pages: 5, full pages: 21 
    Fill distribution: 
     0 - 19% = 7 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 8 
    80 - 99% = 15 
 
    Index MONEY_TURNOVER_LOG_AGENT_OPTYPE (0) 
    Root page: 89290, depth: 2, leaf buckets: 4, nodes: 2144 
    Average node length: 4.22, total dup: 2046, max dup: 202 
    Average key length: 2.50, compression ratio: 7.59 
    Average prefix length: 18.54, average data length: 0.46 
    Clustering factor: 1106, ratio: 0.52 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 4 
        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: 97.15, total records: 74 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 112.00, compression ratio: 1.15 
    Pointer pages: 1, data page slots: 2 
    Data pages: 2, average fill: 52% 
    Primary pages: 2, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 1 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 1 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 1 
 
    Index PK_MON_CACHE_MEMORY (0) 
    Root page: 1504215, depth: 1, leaf buckets: 1, nodes: 74 
    Average node length: 11.69, total dup: 0, max dup: 0 
    Average key length: 10.68, compression ratio: 0.84 
    Average prefix length: 1.31, average data length: 7.69 
    Clustering factor: 2, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
MON_LOG (162) 
    Primary pointer page: 520, Index root page: 521 
    Total formats: 2, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index MON_LOG_DTS (4) 
    Root page: 1504229, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index MON_LOG_GDSCODE (2) 
    Root page: 1504227, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index MON_LOG_ROWSET_DESC (1) 
    Root page: 1504226, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index MON_LOG_UNIT (3) 
    Root page: 1504228, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PK_MON_LOG (0) 
    Root page: 1504225, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
MON_LOG_TABLE_STATS (163) 
    Primary pointer page: 522, Index root page: 523 
    Total formats: 2, used formats: 1 
    Average record length: 67.13, total records: 30 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 611.00, compression ratio: 9.10 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 31% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 1 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index MON_LOG_TABLE_STATS_DTS (4) 
    Root page: 1504224, depth: 1, leaf buckets: 1, nodes: 30 
    Average node length: 3.50, total dup: 23, max dup: 4 
    Average key length: 2.47, compression ratio: 3.24 
    Average prefix length: 7.53, average data length: 0.47 
    Clustering factor: 1, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index MON_LOG_TABLE_STATS_GDSCODE (2) 
    Root page: 1504222, depth: 1, leaf buckets: 1, nodes: 30 
    Average node length: 2.00, total dup: 29, max dup: 29 
    Average key length: 1.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 1, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index MON_LOG_TABLE_STATS_ROWSET (1) 
    Root page: 1504221, depth: 1, leaf buckets: 1, nodes: 30 
    Average node length: 3.33, total dup: 29, max dup: 29 
    Average key length: 2.30, compression ratio: 3.91 
    Average prefix length: 8.70, average data length: 0.30 
    Clustering factor: 1, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index MON_LOG_TABLE_STATS_TN_UNIT (3) 
    Root page: 1504223, depth: 1, leaf buckets: 1, nodes: 30 
    Average node length: 12.90, total dup: 0, max dup: 0 
    Average key length: 11.87, compression ratio: 1.42 
    Average prefix length: 7.63, average data length: 9.20 
    Clustering factor: 1, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PK_MON_LOG_TABLE_STATS (0) 
    Root page: 1504220, depth: 1, leaf buckets: 1, nodes: 30 
    Average node length: 8.37, total dup: 0, max dup: 0 
    Average key length: 7.33, compression ratio: 1.23 
    Average prefix length: 4.63, average data length: 4.37 
    Clustering factor: 1, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
OPTYPES (136) 
    Primary pointer page: 468, Index root page: 469 
    Total formats: 2, used formats: 1 
    Average record length: 67.56, total records: 9 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 386.00, compression ratio: 5.71 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 9% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index OPTYPES_MCODE_UNQ (1) 
    Root page: 1544805, depth: 1, leaf buckets: 1, nodes: 9 
    Average node length: 8.56, total dup: 0, max dup: 0 
    Average key length: 6.89, compression ratio: 0.73 
    Average prefix length: 0.44, average data length: 4.56 
    Clustering factor: 1, ratio: 0.11 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PK_OPTYPES (0) 
    Root page: 1544804, depth: 1, leaf buckets: 1, nodes: 9 
    Average node length: 6.11, total dup: 0, max dup: 0 
    Average key length: 5.00, compression ratio: 0.60 
    Average prefix length: 0.89, average data length: 2.11 
    Clustering factor: 1, ratio: 0.11 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
PDISTR (146) 
    Primary pointer page: 488, Index root page: 489 
    Total formats: 1, used formats: 1 
    Average record length: 36.42, total records: 796287 
    Average version length: 25.69, total versions: 53960, max versions: 5 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 54.00, compression ratio: 1.48 
    Pointer pages: 6, data page slots: 8272 
    Data pages: 8248, average fill: 67% 
    Primary pages: 8212, secondary pages: 36, swept pages: 2627 
    Empty pages: 74, full pages: 5551 
    Fill distribution: 
     0 - 19% = 172 
    20 - 39% = 249 
    40 - 59% = 478 
    60 - 79% = 7176 
    80 - 99% = 173 
 
    Index PDISTR_AGENT_ID (2) 
    Root page: 1509308, depth: 2, leaf buckets: 882, nodes: 796287 
    Average node length: 4.87, total dup: 796238, max dup: 149677 
    Average key length: 2.01, compression ratio: 4.48 
    Average prefix length: 8.99, average data length: 0.01 
    Clustering factor: 88905, ratio: 0.11 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 131 
        40 - 59% = 490 
        60 - 79% = 200 
        80 - 99% = 61 
 
    Index PDISTR_SNDOP_RCVOP_SNDID_ASC (0) 
    Root page: 1508613, depth: 3, leaf buckets: 993, nodes: 796287 
    Average node length: 5.88, total dup: 708996, max dup: 42 
    Average key length: 3.02, compression ratio: 7.29 
    Average prefix length: 21.09, average data length: 0.91 
    Clustering factor: 157297, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 3 
        20 - 39% = 137 
        40 - 59% = 503 
        60 - 79% = 100 
        80 - 99% = 250 
 
    Index PDISTR_SNDOP_RCVOP_SNDID_DESC (1) 
    Root page: 1509187, depth: 3, leaf buckets: 1025, nodes: 796287 
    Average node length: 5.88, total dup: 708996, max dup: 42 
    Average key length: 3.02, compression ratio: 7.28 
    Average prefix length: 21.09, average data length: 0.91 
    Clustering factor: 159184, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 207 
        40 - 59% = 480 
        60 - 79% = 93 
        80 - 99% = 245 
 
    Index PDISTR_WORKER_SND_ID (3) 
    Root page: 1510178, depth: 3, leaf buckets: 1142, nodes: 796287 
    Average node length: 5.96, total dup: 708996, max dup: 42 
    Average key length: 3.10, compression ratio: 5.48 
    Average prefix length: 16.01, average data length: 0.99 
    Clustering factor: 152120, ratio: 0.19 
    Fill distribution: 
         0 - 19% = 5 
        20 - 39% = 268 
        40 - 59% = 580 
        60 - 79% = 192 
        80 - 99% = 97 
 
PERF_AGG (158) 
    Primary pointer page: 512, Index root page: 513 
    Total formats: 1, used formats: 1 
    Average record length: 62.79, total records: 5467 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 2.44, total fragments: 88, max fragments: 1 
    Average unpacked length: 379.00, compression ratio: 6.04 
    Pointer pages: 1, data page slots: 96 
    Data pages: 96, average fill: 57% 
    Primary pages: 72, secondary pages: 24, swept pages: 63 
    Empty pages: 16, full pages: 64 
    Fill distribution: 
     0 - 19% = 25 
    20 - 39% = 0 
    40 - 59% = 2 
    60 - 79% = 68 
    80 - 99% = 1 
 
    Index PERF_AGG_UNQ (1) 
    Root page: 1504238, depth: 2, leaf buckets: 6, nodes: 5467 
    Average node length: 5.48, total dup: 0, max dup: 0 
    Average key length: 3.58, compression ratio: 10.06 
    Average prefix length: 34.44, average data length: 1.54 
    Clustering factor: 5197, ratio: 0.95 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 0 
        40 - 59% = 4 
        60 - 79% = 1 
        80 - 99% = 1 
 
    Index PK_PERF_AGG (0) 
    Root page: 1504233, depth: 2, leaf buckets: 10, nodes: 5467 
    Average node length: 11.11, total dup: 0, max dup: 0 
    Average key length: 9.21, compression ratio: 0.98 
    Average prefix length: 2.79, average data length: 6.21 
    Clustering factor: 154, 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.15, total records: 74757 
    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: 728 
    Data pages: 728, average fill: 71% 
    Primary pages: 728, secondary pages: 0, swept pages: 0 
    Empty pages: 6, full pages: 721 
    Fill distribution: 
     0 - 19% = 7 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 721 
    80 - 99% = 0 
 
    Index PK_PERF_ESTIMATED (0) 
    Root page: 36313, depth: 2, leaf buckets: 95, nodes: 74757 
    Average node length: 10.19, total dup: 0, max dup: 0 
    Average key length: 8.20, compression ratio: 1.10 
    Average prefix length: 3.80, average data length: 5.20 
    Clustering factor: 3283, ratio: 0.04 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 0 
        40 - 59% = 1 
        60 - 79% = 0 
        80 - 99% = 94 
 
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: 111.22, 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.20 
    Pointer pages: 1, data page slots: 2 
    Data pages: 2, average fill: 57% 
    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: 142.75, total records: 158947 
    Average version length: 152.76, total versions: 8437, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.88 
    Pointer pages: 7, data page slots: 4728 
    Data pages: 3864, average fill: 85% 
    Primary pages: 3864, secondary pages: 0, swept pages: 8 
    Empty pages: 86, full pages: 3754 
    Fill distribution: 
     0 - 19% = 93 
    20 - 39% = 6 
    40 - 59% = 6 
    60 - 79% = 8 
    80 - 99% = 3751 
 
PERF_SPLIT_1 (282) 
    Primary pointer page: 576, Index root page: 577 
    Total formats: 1, used formats: 1 
    Average record length: 138.42, total records: 177824 
    Average version length: 153.85, total versions: 15101, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 12.25 
    Pointer pages: 7, data page slots: 5008 
    Data pages: 4312, average fill: 86% 
    Primary pages: 4312, secondary pages: 0, swept pages: 2 
    Empty pages: 74, full pages: 4215 
    Fill distribution: 
     0 - 19% = 80 
    20 - 39% = 5 
    40 - 59% = 5 
    60 - 79% = 7 
    80 - 99% = 4215 
 
PERF_SPLIT_2 (283) 
    Primary pointer page: 578, Index root page: 579 
    Total formats: 1, used formats: 1 
    Average record length: 147.20, total records: 155831 
    Average version length: 150.78, total versions: 3932, 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: 4592 
    Data pages: 3784, average fill: 85% 
    Primary pages: 3783, secondary pages: 1, swept pages: 2 
    Empty pages: 80, full pages: 3683 
    Fill distribution: 
     0 - 19% = 85 
    20 - 39% = 6 
    40 - 59% = 7 
    60 - 79% = 3 
    80 - 99% = 3683 
 
PERF_SPLIT_3 (284) 
    Primary pointer page: 580, Index root page: 581 
    Total formats: 1, used formats: 1 
    Average record length: 142.24, total records: 172315 
    Average version length: 152.54, total versions: 10180, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.92 
    Pointer pages: 5, data page slots: 6216 
    Data pages: 4200, average fill: 85% 
    Primary pages: 4200, secondary pages: 0, swept pages: 5 
    Empty pages: 80, full pages: 4056 
    Fill distribution: 
     0 - 19% = 82 
    20 - 39% = 9 
    40 - 59% = 47 
    60 - 79% = 6 
    80 - 99% = 4056 
 
PERF_SPLIT_4 (285) 
    Primary pointer page: 582, Index root page: 583 
    Total formats: 1, used formats: 1 
    Average record length: 142.54, total records: 155901 
    Average version length: 152.49, total versions: 8692, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.90 
    Pointer pages: 6, data page slots: 4760 
    Data pages: 3736, average fill: 86% 
    Primary pages: 3735, secondary pages: 1, swept pages: 2 
    Empty pages: 37, full pages: 3688 
    Fill distribution: 
     0 - 19% = 37 
    20 - 39% = 6 
    40 - 59% = 2 
    60 - 79% = 2 
    80 - 99% = 3689 
 
PERF_SPLIT_5 (286) 
    Primary pointer page: 584, Index root page: 585 
    Total formats: 1, used formats: 1 
    Average record length: 126.66, total records: 188146 
    Average version length: 154.56, total versions: 30519, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 13.39 
    Pointer pages: 7, data page slots: 6088 
    Data pages: 4560, average fill: 87% 
    Primary pages: 4560, secondary pages: 0, swept pages: 3 
    Empty pages: 68, full pages: 4469 
    Fill distribution: 
     0 - 19% = 74 
    20 - 39% = 8 
    40 - 59% = 7 
    60 - 79% = 3 
    80 - 99% = 4468 
 
PERF_SPLIT_6 (287) 
    Primary pointer page: 586, Index root page: 587 
    Total formats: 1, used formats: 1 
    Average record length: 131.82, total records: 185889 
    Average version length: 154.28, total versions: 24094, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 12.87 
    Pointer pages: 6, data page slots: 5824 
    Data pages: 4520, average fill: 86% 
    Primary pages: 4520, secondary pages: 0, swept pages: 2 
    Empty pages: 81, full pages: 4412 
    Fill distribution: 
     0 - 19% = 85 
    20 - 39% = 7 
    40 - 59% = 7 
    60 - 79% = 9 
    80 - 99% = 4412 
 
PERF_SPLIT_7 (288) 
    Primary pointer page: 588, Index root page: 589 
    Total formats: 1, used formats: 1 
    Average record length: 129.18, total records: 197643 
    Average version length: 154.56, total versions: 28940, 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: 8, data page slots: 5960 
    Data pages: 4800, average fill: 86% 
    Primary pages: 4800, secondary pages: 0, swept pages: 5 
    Empty pages: 80, full pages: 4691 
    Fill distribution: 
     0 - 19% = 84 
    20 - 39% = 12 
    40 - 59% = 6 
    60 - 79% = 7 
    80 - 99% = 4691 
 
PERF_SPLIT_8 (289) 
    Primary pointer page: 590, Index root page: 591 
    Total formats: 1, used formats: 1 
    Average record length: 142.37, total records: 166470 
    Average version length: 153.33, total versions: 9580, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.91 
    Pointer pages: 8, data page slots: 4416 
    Data pages: 3992, average fill: 86% 
    Primary pages: 3992, secondary pages: 0, swept pages: 7 
    Empty pages: 37, full pages: 3943 
    Fill distribution: 
     0 - 19% = 40 
    20 - 39% = 7 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 3945 
 
PERF_SPLIT_9 (290) 
    Primary pointer page: 593, Index root page: 594 
    Total formats: 1, used formats: 1 
    Average record length: 144.96, total records: 169825 
    Average version length: 152.78, total versions: 7235, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.70 
    Pointer pages: 7, data page slots: 4784 
    Data pages: 4104, average fill: 86% 
    Primary pages: 4104, secondary pages: 0, swept pages: 9 
    Empty pages: 58, full pages: 4025 
    Fill distribution: 
     0 - 19% = 59 
    20 - 39% = 8 
    40 - 59% = 5 
    60 - 79% = 8 
    80 - 99% = 4024 
 
PHRASES (143) 
    Primary pointer page: 482, Index root page: 483 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index PHRASES_ID_DESC (3) 
    Root page: 1510354, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PHRASES_NAME (2) 
    Root page: 1510353, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PHRASES_UNQ (1) 
    Root page: 1510352, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PK_PHRASES (0) 
    Root page: 1510351, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
PSTORNED (147) 
    Primary pointer page: 490, Index root page: 491 
    Total formats: 1, used formats: 1 
    Average record length: 52.08, total records: 2081196 
    Average version length: 52.92, total versions: 26024, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 70.00, compression ratio: 1.34 
    Pointer pages: 16, data page slots: 25360 
    Data pages: 25352, average fill: 71% 
    Primary pages: 25352, secondary pages: 0, swept pages: 11381 
    Empty pages: 302, full pages: 20299 
    Fill distribution: 
     0 - 19% = 612 
    20 - 39% = 450 
    40 - 59% = 1146 
    60 - 79% = 22934 
    80 - 99% = 210 
 
    Index PSTORNED_RCV_ID (1) 
    Root page: 1506186, depth: 3, leaf buckets: 2557, nodes: 2081196 
    Average node length: 5.44, total dup: 1941729, max dup: 1416 
    Average key length: 2.49, compression ratio: 3.62 
    Average prefix length: 8.58, average data length: 0.42 
    Clustering factor: 180234, ratio: 0.09 
    Fill distribution: 
         0 - 19% = 3 
        20 - 39% = 294 
        40 - 59% = 1667 
        60 - 79% = 284 
        80 - 99% = 309 
 
    Index PSTORNED_SND_ID (0) 
    Root page: 1504819, depth: 3, leaf buckets: 2756, nodes: 2081196 
    Average node length: 5.69, total dup: 1867516, max dup: 64 
    Average key length: 2.74, compression ratio: 3.28 
    Average prefix length: 8.36, average data length: 0.64 
    Clustering factor: 372190, ratio: 0.18 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 5 
        40 - 59% = 2490 
        60 - 79% = 234 
        80 - 99% = 27 
 
    Index PSTORNED_WORKER_ID (2) 
    Root page: 1507996, depth: 3, leaf buckets: 2113, nodes: 2081196 
    Average node length: 4.96, total dup: 2081096, max dup: 27438 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.42, average data length: 0.00 
    Clustering factor: 177916, ratio: 0.09 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 187 
        40 - 59% = 1160 
        60 - 79% = 318 
        80 - 99% = 448 
 
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: 41.04, total records: 120024 
    Average version length: 69.17, total versions: 48866, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 3.07 
    Pointer pages: 3, data page slots: 4088 
    Data pages: 3008, average fill: 47% 
    Primary pages: 3007, secondary pages: 1, swept pages: 569 
    Empty pages: 579, full pages: 999 
    Fill distribution: 
     0 - 19% = 885 
    20 - 39% = 370 
    40 - 59% = 382 
    60 - 79% = 713 
    80 - 99% = 658 
 
    Index XQD_1000_1200_WA_SO_RO_WKR_SND (0) 
    Root page: 353090, depth: 3, leaf buckets: 217, nodes: 120024 
    Average node length: 6.39, total dup: 104443, max dup: 14 
    Average key length: 3.99, compression ratio: 10.54 
    Average prefix length: 40.14, average data length: 1.86 
    Clustering factor: 20794, ratio: 0.17 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 87 
        40 - 59% = 103 
        60 - 79% = 24 
        80 - 99% = 2 
 
XQD_1000_3300 (178) 
    Primary pointer page: 553, Index root page: 554 
    Total formats: 1, used formats: 1 
    Average record length: 66.11, total records: 6972833 
    Average version length: 68.80, total versions: 288656, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.91 
    Pointer pages: 64, data page slots: 103808 
    Data pages: 103808, average fill: 72% 
    Primary pages: 103808, secondary pages: 0, swept pages: 41647 
    Empty pages: 47, full pages: 63796 
    Fill distribution: 
     0 - 19% = 264 
    20 - 39% = 1268 
    40 - 59% = 9230 
    60 - 79% = 89982 
    80 - 99% = 3064 
 
    Index XQD_1000_3300_WA_SO_RO_WKR_SND (0) 
    Root page: 1480454, depth: 3, leaf buckets: 10778, nodes: 6972833 
    Average node length: 6.52, total dup: 6029699, max dup: 29 
    Average key length: 3.53, compression ratio: 11.91 
    Average prefix length: 40.61, average data length: 1.39 
    Clustering factor: 1547744, ratio: 0.22 
    Fill distribution: 
         0 - 19% = 8 
        20 - 39% = 1713 
        40 - 59% = 6180 
        60 - 79% = 2555 
        80 - 99% = 322 
 
    Index XQD_1000_3300_WKR_DOC_ASC (1) 
    Root page: 1486068, depth: 3, leaf buckets: 8499, nodes: 6972833 
    Average node length: 5.40, total dup: 6692387, max dup: 135 
    Average key length: 2.41, compression ratio: 7.05 
    Average prefix length: 16.63, average data length: 0.37 
    Clustering factor: 1356510, ratio: 0.19 
    Fill distribution: 
         0 - 19% = 10 
        20 - 39% = 1309 
        40 - 59% = 4676 
        60 - 79% = 1484 
        80 - 99% = 1020 
 
    Index XQD_1000_3300_WKR_DOC_DEC (2) 
    Root page: 1490608, depth: 3, leaf buckets: 8548, nodes: 6972833 
    Average node length: 5.40, total dup: 6692387, max dup: 135 
    Average key length: 2.41, compression ratio: 7.05 
    Average prefix length: 16.63, average data length: 0.37 
    Clustering factor: 1358953, ratio: 0.19 
    Fill distribution: 
         0 - 19% = 5 
        20 - 39% = 1381 
        40 - 59% = 4625 
        60 - 79% = 1526 
        80 - 99% = 1011 
 
XQD_1200_2000 (177) 
    Primary pointer page: 551, Index root page: 552 
    Total formats: 1, used formats: 1 
    Average record length: 67.66, total records: 12097669 
    Average version length: 68.73, total versions: 227467, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.86 
    Pointer pages: 105, data page slots: 170512 
    Data pages: 170512, average fill: 75% 
    Primary pages: 170512, secondary pages: 0, swept pages: 95062 
    Empty pages: 9, full pages: 145914 
    Fill distribution: 
     0 - 19% = 84 
    20 - 39% = 728 
    40 - 59% = 5632 
    60 - 79% = 160900 
    80 - 99% = 3168 
 
    Index XQD_1200_2000_WA_SO_RO_WKR_SND (0) 
    Root page: 1495028, depth: 3, leaf buckets: 18502, nodes: 12097669 
    Average node length: 6.59, total dup: 10542292, max dup: 53 
    Average key length: 3.43, compression ratio: 12.25 
    Average prefix length: 40.70, average data length: 1.30 
    Clustering factor: 2374561, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 24 
        20 - 39% = 2111 
        40 - 59% = 11206 
        60 - 79% = 4599 
        80 - 99% = 562 
 
XQD_2000_3300 (179) 
    Primary pointer page: 555, Index root page: 556 
    Total formats: 1, used formats: 1 
    Average record length: 47.97, total records: 1307111 
    Average version length: 69.08, total versions: 400350, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 2.63 
    Pointer pages: 26, data page slots: 41968 
    Data pages: 26224, average fill: 57% 
    Primary pages: 26223, secondary pages: 1, swept pages: 10162 
    Empty pages: 4181, full pages: 14571 
    Fill distribution: 
     0 - 19% = 6051 
    20 - 39% = 2172 
    40 - 59% = 1884 
    60 - 79% = 9974 
    80 - 99% = 6143 
 
    Index XQD_2000_3300_WA_SO_RO_WKR_SND (0) 
    Root page: 1479712, depth: 3, leaf buckets: 2065, nodes: 1307111 
    Average node length: 5.53, total dup: 1253685, max dup: 60 
    Average key length: 2.58, compression ratio: 16.27 
    Average prefix length: 41.46, average data length: 0.54 
    Clustering factor: 86900, ratio: 0.07 
    Fill distribution: 
         0 - 19% = 9 
        20 - 39% = 950 
        40 - 59% = 862 
        60 - 79% = 200 
        80 - 99% = 44 
 
XQD_2100_3300 (180) 
    Primary pointer page: 557, Index root page: 558 
    Total formats: 1, used formats: 1 
    Average record length: 45.18, total records: 893750 
    Average version length: 69.13, total versions: 308576, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 2.79 
    Pointer pages: 23, data page slots: 36520 
    Data pages: 27992, average fill: 37% 
    Primary pages: 27992, secondary pages: 0, swept pages: 9314 
    Empty pages: 6568, full pages: 6436 
    Fill distribution: 
     0 - 19% = 11277 
    20 - 39% = 4643 
    40 - 59% = 3380 
    60 - 79% = 4215 
    80 - 99% = 4477 
 
    Index XQD_2100_3300_WA_SO_RO_WKR_SND (0) 
    Root page: 1479207, depth: 3, leaf buckets: 1427, nodes: 893750 
    Average node length: 5.82, total dup: 833134, max dup: 95 
    Average key length: 2.89, compression ratio: 14.55 
    Average prefix length: 41.18, average data length: 0.82 
    Clustering factor: 120797, ratio: 0.14 
    Fill distribution: 
         0 - 19% = 3 
        20 - 39% = 568 
        40 - 59% = 621 
        60 - 79% = 214 
        80 - 99% = 21 
 
XQD_3300_3400 (181) 
    Primary pointer page: 559, Index root page: 560 
    Total formats: 1, used formats: 1 
    Average record length: 67.04, total records: 8966314 
    Average version length: 68.98, total versions: 240300, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.88 
    Pointer pages: 89, data page slots: 143816 
    Data pages: 143784, average fill: 67% 
    Primary pages: 143784, secondary pages: 0, swept pages: 79068 
    Empty pages: 265, full pages: 64862 
    Fill distribution: 
     0 - 19% = 1133 
    20 - 39% = 7300 
    40 - 59% = 28750 
    60 - 79% = 103414 
    80 - 99% = 3187 
 
    Index XQD_3300_3400_WA_SO_RO_WKR_SND (0) 
    Root page: 1472590, depth: 3, leaf buckets: 13488, nodes: 8966314 
    Average node length: 6.69, total dup: 7435656, max dup: 14 
    Average key length: 3.67, compression ratio: 11.43 
    Average prefix length: 40.50, average data length: 1.50 
    Clustering factor: 1926468, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 1432 
        40 - 59% = 7382 
        60 - 79% = 4197 
        80 - 99% = 476 
 
XQS_1000_1200 (182) 
    Primary pointer page: 561, Index root page: 562 
    Total formats: 1, used formats: 1 
    Average record length: 82.51, total records: 21086936 
    Average version length: 82.96, total versions: 5653, 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: 195, data page slots: 318048 
    Data pages: 318048, average fill: 81% 
    Primary pages: 318048, secondary pages: 0, swept pages: 13489 
    Empty pages: 73, full pages: 316512 
    Fill distribution: 
     0 - 19% = 118 
    20 - 39% = 84 
    40 - 59% = 206 
    60 - 79% = 28081 
    80 - 99% = 289559 
 
    Index XQS_1000_1200_DOC_ID (1) 
    Root page: 1426716, depth: 3, leaf buckets: 19413, nodes: 21086936 
    Average node length: 5.72, total dup: 20607502, max dup: 128 
    Average key length: 2.16, compression ratio: 4.16 
    Average prefix length: 8.86, average data length: 0.14 
    Clustering factor: 3269766, ratio: 0.16 
    Fill distribution: 
         0 - 19% = 7 
        20 - 39% = 0 
        40 - 59% = 8325 
        60 - 79% = 507 
        80 - 99% = 10574 
 
    Index XQS_1000_1200_RCV_ID (3) 
    Root page: 1456980, depth: 3, leaf buckets: 17099, nodes: 21086936 
    Average node length: 6.31, total dup: 18530011, max dup: 49 
    Average key length: 2.75, compression ratio: 3.27 
    Average prefix length: 8.37, average data length: 0.63 
    Clustering factor: 911773, ratio: 0.04 
    Fill distribution: 
         0 - 19% = 3 
        20 - 39% = 3 
        40 - 59% = 744 
        60 - 79% = 273 
        80 - 99% = 16076 
 
    Index XQS_1000_1200_SND_ID (2) 
    Root page: 1441073, depth: 3, leaf buckets: 21127, nodes: 21086936 
    Average node length: 6.34, total dup: 18450377, max dup: 29 
    Average key length: 2.79, compression ratio: 3.23 
    Average prefix length: 8.34, average data length: 0.66 
    Clustering factor: 3564137, ratio: 0.17 
    Fill distribution: 
         0 - 19% = 6 
        20 - 39% = 0 
        40 - 59% = 8454 
        60 - 79% = 591 
        80 - 99% = 12076 
 
    Index XQS_1000_1200_WORKER_ID (0) 
    Root page: 1413348, depth: 3, leaf buckets: 15903, nodes: 21086936 
    Average node length: 5.56, total dup: 21086836, max dup: 228152 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.42, average data length: 0.00 
    Clustering factor: 940472, ratio: 0.04 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 6 
        40 - 59% = 2614 
        60 - 79% = 343 
        80 - 99% = 12939 
 
XQS_1000_3300 (184) 
    Primary pointer page: 565, Index root page: 566 
    Total formats: 1, used formats: 1 
    Average record length: 80.18, total records: 9432271 
    Average version length: 82.62, total versions: 254121, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.57 
    Pointer pages: 103, data page slots: 167696 
    Data pages: 167680, average fill: 69% 
    Primary pages: 167680, secondary pages: 0, swept pages: 91550 
    Empty pages: 314, full pages: 88203 
    Fill distribution: 
     0 - 19% = 1294 
    20 - 39% = 7104 
    40 - 59% = 28375 
    60 - 79% = 80248 
    80 - 99% = 50659 
 
    Index XQS_1000_3300_DOC_ID (1) 
    Root page: 1367502, depth: 3, leaf buckets: 11343, nodes: 9432271 
    Average node length: 5.36, total dup: 9126492, max dup: 177 
    Average key length: 2.24, compression ratio: 4.02 
    Average prefix length: 8.80, average data length: 0.20 
    Clustering factor: 2097078, ratio: 0.22 
    Fill distribution: 
         0 - 19% = 3 
        20 - 39% = 105 
        40 - 59% = 8915 
        60 - 79% = 2287 
        80 - 99% = 33 
 
    Index XQS_1000_3300_RCV_ID (3) 
    Root page: 1379261, depth: 3, leaf buckets: 13346, nodes: 9432271 
    Average node length: 6.22, total dup: 7817091, max dup: 14 
    Average key length: 3.10, compression ratio: 2.90 
    Average prefix length: 8.07, average data length: 0.93 
    Clustering factor: 1464717, ratio: 0.16 
    Fill distribution: 
         0 - 19% = 137 
        20 - 39% = 4045 
        40 - 59% = 4337 
        60 - 79% = 2565 
        80 - 99% = 2262 
 
    Index XQS_1000_3300_SND_ID (2) 
    Root page: 1373059, depth: 3, leaf buckets: 12669, nodes: 9432271 
    Average node length: 5.98, total dup: 8176700, max dup: 38 
    Average key length: 2.86, compression ratio: 3.15 
    Average prefix length: 8.28, average data length: 0.72 
    Clustering factor: 2278657, ratio: 0.24 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 119 
        40 - 59% = 9954 
        60 - 79% = 2556 
        80 - 99% = 38 
 
    Index XQS_1000_3300_WORKER_ID (0) 
    Root page: 1362767, depth: 3, leaf buckets: 9894, nodes: 9432271 
    Average node length: 5.12, total dup: 9432171, max dup: 148529 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.43, average data length: 0.00 
    Clustering factor: 1503190, ratio: 0.16 
    Fill distribution: 
         0 - 19% = 40 
        20 - 39% = 1363 
        40 - 59% = 4744 
        60 - 79% = 1688 
        80 - 99% = 2059 
 
XQS_1200_2000 (183) 
    Primary pointer page: 563, Index root page: 564 
    Total formats: 1, used formats: 1 
    Average record length: 80.77, total records: 10986615 
    Average version length: 82.50, total versions: 202245, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.56 
    Pointer pages: 117, data page slots: 189640 
    Data pages: 187976, average fill: 72% 
    Primary pages: 187976, secondary pages: 0, swept pages: 79425 
    Empty pages: 3463, full pages: 134384 
    Fill distribution: 
     0 - 19% = 5860 
    20 - 39% = 8278 
    40 - 59% = 19708 
    60 - 79% = 45417 
    80 - 99% = 108713 
 
    Index XQS_1200_2000_DOC_ID (1) 
    Root page: 1392101, depth: 3, leaf buckets: 13104, nodes: 10986615 
    Average node length: 5.29, total dup: 10877644, max dup: 676 
    Average key length: 2.08, compression ratio: 4.32 
    Average prefix length: 8.93, average data length: 0.07 
    Clustering factor: 2290831, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 151 
        40 - 59% = 10029 
        60 - 79% = 2861 
        80 - 99% = 61 
 
    Index XQS_1200_2000_RCV_ID (3) 
    Root page: 1406110, depth: 3, leaf buckets: 10186, nodes: 10986615 
    Average node length: 5.49, total dup: 10505216, max dup: 49 
    Average key length: 2.28, compression ratio: 3.95 
    Average prefix length: 8.77, average data length: 0.23 
    Clustering factor: 693537, ratio: 0.06 
    Fill distribution: 
         0 - 19% = 179 
        20 - 39% = 867 
        40 - 59% = 2467 
        60 - 79% = 1856 
        80 - 99% = 4817 
 
    Index XQS_1200_2000_SND_ID (2) 
    Root page: 1398638, depth: 3, leaf buckets: 14984, nodes: 10986615 
    Average node length: 6.02, total dup: 9578062, max dup: 69 
    Average key length: 2.81, compression ratio: 3.20 
    Average prefix length: 8.32, average data length: 0.68 
    Clustering factor: 2307116, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 3 
        20 - 39% = 183 
        40 - 59% = 11544 
        60 - 79% = 3184 
        80 - 99% = 70 
 
    Index XQS_1200_2000_WORKER_ID (0) 
    Root page: 1386211, depth: 3, leaf buckets: 10448, nodes: 10986615 
    Average node length: 5.21, total dup: 10986515, max dup: 170108 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.43, average data length: 0.00 
    Clustering factor: 682990, ratio: 0.06 
    Fill distribution: 
         0 - 19% = 103 
        20 - 39% = 860 
        40 - 59% = 4498 
        60 - 79% = 1530 
        80 - 99% = 3457 
 
XQS_2000_3300 (185) 
    Primary pointer page: 567, Index root page: 568 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index XQS_2000_3300_DOC_ID (1) 
    Root page: 1361753, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index XQS_2000_3300_RCV_ID (3) 
    Root page: 1361755, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index XQS_2000_3300_SND_ID (2) 
    Root page: 1361754, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index XQS_2000_3300_WORKER_ID (0) 
    Root page: 1361752, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
XQS_2100_3300 (186) 
    Primary pointer page: 569, Index root page: 570 
    Total formats: 1, used formats: 1 
    Average record length: 80.67, total records: 9529701 
    Average version length: 82.91, total versions: 237266, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.56 
    Pointer pages: 105, data page slots: 170792 
    Data pages: 170776, average fill: 69% 
    Primary pages: 170776, secondary pages: 0, swept pages: 97997 
    Empty pages: 419, full pages: 87567 
    Fill distribution: 
     0 - 19% = 1524 
    20 - 39% = 7475 
    40 - 59% = 29271 
    60 - 79% = 84152 
    80 - 99% = 48354 
 
    Index XQS_2100_3300_DOC_ID (1) 
    Root page: 1344686, depth: 3, leaf buckets: 11621, nodes: 9529701 
    Average node length: 5.17, total dup: 9501123, max dup: 1686 
    Average key length: 2.03, compression ratio: 4.43 
    Average prefix length: 8.97, average data length: 0.03 
    Clustering factor: 1911392, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 43 
        20 - 39% = 1570 
        40 - 59% = 7740 
        60 - 79% = 1708 
        80 - 99% = 560 
 
    Index XQS_2100_3300_RCV_ID (3) 
    Root page: 1355717, depth: 3, leaf buckets: 13440, nodes: 9529701 
    Average node length: 6.24, total dup: 7897792, max dup: 14 
    Average key length: 3.10, compression ratio: 2.90 
    Average prefix length: 8.07, average data length: 0.93 
    Clustering factor: 1425558, ratio: 0.15 
    Fill distribution: 
         0 - 19% = 161 
        20 - 39% = 4035 
        40 - 59% = 4288 
        60 - 79% = 2570 
        80 - 99% = 2386 
 
    Index XQS_2100_3300_SND_ID (2) 
    Root page: 1350049, depth: 3, leaf buckets: 12251, nodes: 9529701 
    Average node length: 5.42, total dup: 9099560, max dup: 95 
    Average key length: 2.29, compression ratio: 3.93 
    Average prefix length: 8.76, average data length: 0.24 
    Clustering factor: 2039991, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 33 
        20 - 39% = 1528 
        40 - 59% = 8574 
        60 - 79% = 1602 
        80 - 99% = 514 
 
    Index XQS_2100_3300_WORKER_ID (0) 
    Root page: 985805, depth: 3, leaf buckets: 10065, nodes: 9529701 
    Average node length: 5.14, total dup: 9529601, max dup: 151445 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.43, average data length: 0.00 
    Clustering factor: 1520400, ratio: 0.16 
    Fill distribution: 
         0 - 19% = 31 
        20 - 39% = 1350 
        40 - 59% = 4985 
        60 - 79% = 1709 
        80 - 99% = 1990 
 
XQS_3300_3400 (187) 
    Primary pointer page: 571, Index root page: 572 
    Total formats: 1, used formats: 1 
    Average record length: 67.73, total records: 570016 
    Average version length: 68.72, total versions: 3595, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.86 
    Pointer pages: 5, data page slots: 7904 
    Data pages: 7904, average fill: 75% 
    Primary pages: 7904, secondary pages: 0, swept pages: 3937 
    Empty pages: 5, full pages: 6695 
    Fill distribution: 
     0 - 19% = 9 
    20 - 39% = 21 
    40 - 59% = 186 
    60 - 79% = 7632 
    80 - 99% = 56 
 
    Index XQS_3300_3400_DOC_ID (1) 
    Root page: 39706, depth: 3, leaf buckets: 733, nodes: 570016 
    Average node length: 5.95, total dup: 485258, max dup: 83 
    Average key length: 3.09, compression ratio: 2.91 
    Average prefix length: 8.05, average data length: 0.95 
    Clustering factor: 99343, ratio: 0.17 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 20 
        40 - 59% = 546 
        60 - 79% = 81 
        80 - 99% = 86 
 
    Index XQS_3300_3400_SND_ID (2) 
    Root page: 31476, depth: 3, leaf buckets: 759, nodes: 570016 
    Average node length: 6.15, total dup: 467481, max dup: 23 
    Average key length: 3.29, compression ratio: 2.73 
    Average prefix length: 7.89, average data length: 1.11 
    Clustering factor: 99390, ratio: 0.17 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 21 
        40 - 59% = 560 
        60 - 79% = 82 
        80 - 99% = 95 
 
    Index XQS_3300_3400_WORKER_ID (0) 
    Root page: 375548, depth: 2, leaf buckets: 565, nodes: 570016 
    Average node length: 4.86, total dup: 569916, max dup: 9720 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.42, average data length: 0.00 
    Clustering factor: 88250, ratio: 0.15 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 31 
        40 - 59% = 320 
        60 - 79% = 96 
        80 - 99% = 118 
 
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 Thu Feb 29 01:12:36 2024

Record versions statistics, table

TABLE_NAME TOTAL_RECS TOTAL_VERS MAX_VERSIONS VERS_TO_RECS_PRC MAXV_TO_VERS_PRC
DOC_DATA 7702523 59544 1 0.0000 0.0000
DOC_LIST 2223349 62113 4 0.0000 0.0000
FB_ERRORS 2182 757 1 0.0000 0.0000
INVNT_SALDO 400 224509 586 56100.0000 0.0000
INVNT_TURNOVER_LOG 105467 87602 1 0.0000 0.0000
MONEY_SALDO 49 17353 918 35400.0000 0.0000
MONEY_TURNOVER_LOG 2144 1835 1 0.0000 0.0000
PDISTR 796287 53960 5 0.0000 0.0000
PERF_SPLIT_0 158947 8437 1 0.0000 0.0000
PERF_SPLIT_1 177824 15101 1 0.0000 0.0000
PERF_SPLIT_2 155831 3932 1 0.0000 0.0000
PERF_SPLIT_3 172315 10180 1 0.0000 0.0000
PERF_SPLIT_4 155901 8692 1 0.0000 0.0000
PERF_SPLIT_5 188146 30519 1 0.0000 0.0000
PERF_SPLIT_6 185889 24094 1 0.0000 0.0000
PERF_SPLIT_7 197643 28940 1 0.0000 0.0000
PERF_SPLIT_8 166470 9580 1 0.0000 0.0000
PERF_SPLIT_9 169825 7235 1 0.0000 0.0000
PSTORNED 2081196 26024 1 0.0000 0.0000
SEMAPHORES 5 1 1 0.0000 100.0000
XQD_1000_1200 120024 48866 1 0.0000 0.0000
XQD_1000_3300 6972833 288656 1 0.0000 0.0000
XQD_1200_2000 12097669 227467 1 0.0000 0.0000
XQD_2000_3300 1307111 400350 1 0.0000 0.0000
XQD_2100_3300 893750 308576 1 0.0000 0.0000
XQD_3300_3400 8966314 240300 1 0.0000 0.0000
XQS_1000_1200 21086936 5653 1 0.0000 0.0000
XQS_1000_3300 9432271 254121 1 0.0000 0.0000
XQS_1200_2000 10986615 202245 1 0.0000 0.0000
XQS_2100_3300 9529701 237266 1 0.0000 0.0000
XQS_3300_3400 570016 3595 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 ---
:1351: 
:1352: mscs-test-161.budzdorov.ru    Thu Feb 29 01:09:43 2024
:1353:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:1354: 
:1355: 
:1356: mscs-test-161.budzdorov.ru    Thu Feb 29 01:09:45 2024
:1357:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:1358: 
:1359: 
:1360: mscs-test-161.budzdorov.ru    Thu Feb 29 01:09:45 2024
:1361:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:1362: 
:1363: 
:1364: mscs-test-161.budzdorov.ru    Thu Feb 29 01:09:46 2024
:1365:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:1366: 
--- end of diff output ---

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

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