Generated by /opt/oltp-emul/oltp_isql_run_worker.sh, ISQL session No. 1 of total launched 100. 15.02.2024 07:18
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 15604892 kB
MemAvailable 30293732 kB
Buffers 0 kB
Cached 16147140 kB
SwapCached 4820 kB
Command: fdisk -l
WARNING: fdisk GPT support is currently new, and therefore in an experimental phase. Use at your own discretion.
Disk /dev/sda: 599.9 GB, 599932581888 bytes, 1171743324 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 262144 bytes / 524288 bytes
Disk label type: gpt
Disk identifier: 919DACA4-2F35-4CBB-BAA7-2A8CD8F7168C
# Start End Size Type Name
1 2048 411647 200M EFI System EFI System Partition
2 411648 2508799 1G Microsoft basic
3 2508800 1171742719 557.5G Linux LVM
Disk /dev/mapper/centos_mscs--test--161-root: 53.7 GB, 53687091200 bytes, 104857600 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 262144 bytes / 524288 bytes
Disk /dev/mapper/centos_mscs--test--161-swap: 16.8 GB, 16844324864 bytes, 32899072 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 262144 bytes / 524288 bytes
Disk /dev/sdb: 536 MB, 536870912 bytes, 1048576 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 512 bytes / 512 bytes
Disk label type: dos
Disk identifier: 0x00000046
Device Boot Start End Blocks Id System
/dev/sdb1 63 514079 257008+ c W95 FAT32 (LBA)
Disk /dev/mapper/centos_mscs--test--161-home: 528.1 GB, 528109010944 bytes, 1031462912 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 262144 bytes / 524288 bytes

Server and database settinfs 


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

Test configuration settings 

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

Test finish info 


FINISH_STATE                    NORMAL: TEST_TIME EXPIRED AT 2024-02-15 07:16:35
DTS_END                         2024-02-15 07:16:35.9430
FB_GDSCODE                      -1
FB_MNEMONA                      
STACK                           SP_CLIENT_ORDER(57:5) ==> SP_CHECK_TO_STOP_WORK(32:12) ==> SP_HALT_ON_ERROR(68:17)
IP                              ::1/48148
TRN_ID                          173176
ATT_ID                          529
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: 9605.71 19591 960571
customer order: creation 181.41 423 18141
customer order: refuse 15.45 384 1545
order to supplier: creation 48.56 1279 4856
order to supplier: removal 4.10 85652 410
invoice (draft): creation 46.63 2803 4663
invoice (draft): removal 53.00 708 5300
invoice accept: apply 43.55 20971 4355
invoice accept: cancel 47.95 816 4795
customer reserve: creation 4236.15 199 423615
customer reserve: removal 4623.55 62 462355
realization accept: apply 87.43 189 8743
realization accept: cancel 84.31 125 8431
payment from customer: creation 61.84 127 6184
payment from customer: removal 6.10 68 610
payment to supplier: creation 50.54 125 5054
payment to supplier: removal 3.61 82 361
service: total inventory turnovers 3.74 4162 374
service: total monetary turnovers 6.94 494 694
service: aggregate perf. data 0.82 21632 82
service: refresh index statistics 0.03 251513 3

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:03, from 15-02-2024 07:18:33 to 15-02-2024 07:18:36.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 2311
TEST_TIME 2 3530
TEST_TIME 3 4597
TEST_TIME 4 3689
TEST_TIME 5 3873
TEST_TIME 6 4247
TEST_TIME 7 4690
TEST_TIME 8 5067
TEST_TIME 9 5629
TEST_TIME 10 5595
TEST_TIME 11 5728
TEST_TIME 12 5769
TEST_TIME 13 5858
TEST_TIME 14 6659
TEST_TIME 15 6631
TEST_TIME 16 6834
TEST_TIME 17 7169
TEST_TIME 18 7424
TEST_TIME 19 7462
TEST_TIME 20 7679
TEST_TIME 21 8319
TEST_TIME 22 8340
TEST_TIME 23 8842
TEST_TIME 24 9314
TEST_TIME 25 10125
TEST_TIME 26 10381
TEST_TIME 27 10432
TEST_TIME 28 10202
TEST_TIME 29 10403
TEST_TIME 30 10522
TEST_TIME 31 10518
TEST_TIME 32 10441
TEST_TIME 33 10199
TEST_TIME 34 10118
TEST_TIME 35 10165
TEST_TIME 36 10048
TEST_TIME 37 10027
TEST_TIME 38 10036
TEST_TIME 39 9971
TEST_TIME 40 9995
TEST_TIME 41 10153
TEST_TIME 42 10071
TEST_TIME 43 9967
TEST_TIME 44 9951
TEST_TIME 45 9792
TEST_TIME 46 9747
TEST_TIME 47 9797
TEST_TIME 48 9793
TEST_TIME 49 9764
TEST_TIME 50 9787
TEST_TIME 51 9846
TEST_TIME 52 9890
TEST_TIME 53 9908
TEST_TIME 54 9960
TEST_TIME 55 9937
TEST_TIME 56 10016
TEST_TIME 57 10088
TEST_TIME 58 10138
TEST_TIME 59 10163
TEST_TIME 60 10112
TEST_TIME 61 10123
TEST_TIME 62 9978
TEST_TIME 63 9930
TEST_TIME 64 9877
TEST_TIME 65 9815
TEST_TIME 66 9717
TEST_TIME 67 9668
TEST_TIME 68 9686
TEST_TIME 69 9684
TEST_TIME 70 9747
TEST_TIME 71 9733
TEST_TIME 72 9731
TEST_TIME 73 9780
TEST_TIME 74 9788
TEST_TIME 75 9765
TEST_TIME 76 9921
TEST_TIME 77 9935
TEST_TIME 78 9924
TEST_TIME 79 9824
TEST_TIME 80 9780
TEST_TIME 81 9729
TEST_TIME 82 9675
TEST_TIME 83 9641
TEST_TIME 84 9600
TEST_TIME 85 9585
TEST_TIME 86 9594
TEST_TIME 87 9581
TEST_TIME 88 9562
TEST_TIME 89 9601
TEST_TIME 90 9617
TEST_TIME 91 9584
TEST_TIME 92 9585
TEST_TIME 93 9642
TEST_TIME 94 9642
TEST_TIME 95 9689
TEST_TIME 96 9695
TEST_TIME 97 9758
TEST_TIME 98 9765
TEST_TIME 99 9675
TEST_TIME 100 9614

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:03, from 15-02-2024 07:18:37 to 15-02-2024 07:18:40.

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 1346999 1346999 0 0.00 0 28769 7 0 0
doc_list_biud 1346998 1346998 0 0.00 0 38341 26 0 0
sp_add_invoice_to_stock 4459 4355 104 2.33 27 229176 20972 0 104
sp_cancel_adding_invoice 4795 4795 0 0.00 4 81281 817 0 0
sp_cancel_client_order 1545 1545 0 0.00 4 27821 385 0 0
sp_cancel_customer_reserve 462355 462355 0 0.00 0 30048 63 0 0
sp_cancel_pay_from_customer 610 610 0 0.00 2 4655 68 0 0
sp_cancel_pay_to_supplier 361 361 0 0.00 2 5116 83 0 0
sp_cancel_supplier_invoice 5310 5300 10 0.18 1 24497 708 0 10
sp_cancel_supplier_order 410 410 0 0.00 11 1075198 85653 0 0
sp_cancel_write_off 8431 8431 0 0.00 1 27846 125 0 0
sp_client_order 18141 18141 0 0.00 3 36824 423 0 0
sp_customer_reserve 423615 423615 0 0.00 0 47140 200 0 0
sp_fill_shopping_cart 27658 27658 0 0.00 1 8739 33 0 0
sp_fill_shopping_cart_clo_res 423607 423607 0 0.00 0 25306 20 0 0
sp_get_clo_for_invoice 4342 4342 0 0.00 0 24929 384 0 0
sp_kill_cost_storno 14197 14197 0 0.00 0 8053 65 0 0
sp_kill_qstorno_ret_qs2qd 938851 938851 0 0.00 0 29879 34 0 0
sp_kill_qty_storno 495920 495920 0 0.00 0 38341 71 0 0
sp_lock_selected_doc 18241 18241 0 0.00 0 5293 5 0 0
sp_make_cost_storno 24323 24323 0 0.00 0 28760 55 0 0
sp_multiply_rows_for_pdistr 24322 24322 0 0.00 0 13705 33 0 0
sp_multiply_rows_for_qdistr 18141 18141 0 0.00 0 19989 224 0 0
sp_pay_from_customer 6184 6184 0 0.00 3 28357 128 0 0
sp_pay_to_supplier 5054 5054 0 0.00 4 9855 125 0 0
sp_payment_common 11238 11238 0 0.00 1 8064 20 0 0
sp_qd_handle_on_cancel_clo 1545 1545 0 0.00 0 6903 330 0 0
sp_qd_handle_on_invoice_upd_sts 9136 9136 0 0.00 0 38340 283 0 0
sp_qd_handle_on_reserve_upd_sts 8743 8743 0 0.00 0 15348 51 0 0
sp_reserve_write_off 8743 8743 0 0.00 6 30285 189 0 0
sp_supplier_invoice 4663 4663 0 0.00 6 88434 2803 0 0
sp_supplier_order 4856 4856 0 0.00 4 41992 1280 0 0
srv_aggregate_perf_data 82 82 0 0.00 1731 760386 21633 0 0
srv_fill_mon_cache_memory 57 57 0 0.00 702 124046 37043 0 0
srv_find_qd_qs_mism 915357 915357 0 0.00 0 16837 6 0 0
srv_make_invnt_saldo 374 374 0 0.00 69 102073 4163 0 0
srv_make_money_saldo 694 694 0 0.00 1 14505 495 0 0
srv_recalc_idx_stat 3 3 0 0.00 117051 348701 251514 0 0
t$perf-abend:sp_add_invoice_to_stock 104 104 0 0.00 0 0 0 0 0
t$perf-abend:sp_cancel_supplier_invoice 10 10 0 0.00 0 0 0 0 0
t$perf-norm:sp_add_invoice_to_stock 4355 4355 0 0.00 0 20389 153 0 0
t$perf-norm:sp_cancel_adding_invoice 388 388 0 0.00 0 2788 112 0 0
t$perf-norm:sp_cancel_client_order 1545 1545 0 0.00 0 17767 29 0 0
t$perf-norm:sp_cancel_customer_reserve 630 630 0 0.00 0 3199 17 0 0
t$perf-norm:sp_cancel_pay_from_customer 610 610 0 0.00 0 2167 7 0 0
t$perf-norm:sp_cancel_pay_to_supplier 361 361 0 0.00 0 616 8 0 0
t$perf-norm:sp_cancel_supplier_invoice 347 347 0 0.00 0 2341 28 0 0
t$perf-norm:sp_cancel_supplier_order 410 410 0 0.00 0 33811 1734 0 0
t$perf-norm:sp_cancel_write_off 866 866 0 0.00 0 7206 23 0 0
t$perf-norm:sp_client_order 18141 18141 0 0.00 0 11945 16 0 0
t$perf-norm:sp_customer_reserve 872 872 0 0.00 0 9636 16 0 0
t$perf-norm:sp_pay_from_customer 6184 6184 0 0.00 0 4684 10 0 0
t$perf-norm:sp_pay_to_supplier 5054 5054 0 0.00 0 2323 9 0 0
t$perf-norm:sp_reserve_write_off 8743 8743 0 0.00 0 8075 9 0 0
t$perf-norm:sp_supplier_invoice 4663 4663 0 0.00 0 7512 14 0 0
t$perf-norm:sp_supplier_order 4856 4856 0 0.00 0 8725 13 0 0
t$perf-norm:srv_aggregate_perf_data 82 82 0 0.00 0 109 4 0 0
t$perf-norm:srv_fill_mon_cache_memory 57 57 0 0.00 0 160 4 0 0
t$perf-norm:srv_make_invnt_saldo 374 374 0 0.00 0 2108 18 0 0
t$perf-norm:srv_make_money_saldo 694 694 0 0.00 0 1589 9 0 0
t$perf-norm:srv_recalc_idx_stat 3 3 0 0.00 2 57 21 0 0
v_add_invoice_to_stock 8890 8682 208 2.33 0 30894 31 0 208
v_all_customers 33584 33584 0 0.00 0 16 0 0 0
v_all_suppliers 27116 27116 0 0.00 0 195 1 0 0
v_all_wares 36278 36278 0 0.00 0 37 1 0 0
v_cancel_adding_invoice 776 776 0 0.00 0 27781 49 0 0
v_cancel_client_order 3090 3090 0 0.00 0 27408 21 0 0
v_cancel_customer_prepayment 1220 1220 0 0.00 0 4632 10 0 0
v_cancel_customer_reserve 1260 1260 0 0.00 0 11749 17 0 0
v_cancel_payment_to_supplier 722 722 0 0.00 0 3010 9 0 0
v_cancel_supplier_invoice 714 694 20 2.80 0 5384 22 0 20
v_cancel_supplier_order 820 820 0 0.00 0 1550 5 0 0
v_cancel_write_off 1732 1732 0 0.00 0 27451 44 0 0
v_max_id_clo_ord 4855 4855 0 0.00 0 6965 3 0 0
v_max_id_clo_res 872 872 0 0.00 0 4108 23 0 0
v_max_id_ord_sup 4663 4663 0 0.00 0 5127 3 0 0
v_max_non_paid_invoice 1014 1014 0 0.00 0 386 2 0 0
v_max_non_paid_realizn 3001 3001 0 0.00 0 370 2 0 0
v_min_id_clo_ord 4855 4855 0 0.00 0 2196 8 0 0
v_min_id_clo_res 872 872 0 0.00 0 10658 23 0 0
v_min_id_ord_sup 4663 4663 0 0.00 0 5255 9 0 0
v_min_non_paid_invoice 5054 5054 0 0.00 0 8059 11 0 0
v_min_non_paid_realizn 6184 6184 0 0.00 0 8052 18 0 0
v_our_firm 9060 9060 0 0.00 0 21 1 0 0
v_reserve_write_off 17486 17486 0 0.00 0 29682 12 0 0
x_lock_depdocs_on_canc_invoice 9748 9748 0 0.00 0 26155 108 0 0
x_lock_depdocs_on_canc_sup_ord 410 410 0 0.00 0 3411 276 0 0
x_make_qstorno_1000_1200 4856 4856 0 0.00 1 41979 1207 0 0
x_make_qstorno_1200_2000 4663 4663 0 0.00 2 88414 2688 0 0
x_make_qstorno_2100_3300 423615 423615 0 0.00 0 44768 177 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 15-02-2024 07:18:41 to 15-02-2024 07:18:45.

Memory consumption, metadata cache, attachments activity 

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


Page cache type: shared, buffers: 1000000 for all connections, with total size: 8192000000
measurement_dts measurement duration ms page cache memo used memo used, total memo allocated, total metadata cache metadata cache percent of total total attachments cnt active attachments cnt running statements cnt stalled statements cnt memo used by attachments memo used by transactions memo used by statements
05:16:39 1054 8192000000 8964886832 9029726208 21554096 0.262 5 4 9 0 22238144 167840 516208
05:17:42 35274 8192000000 9716257184 10014777344 797214912 8.868 100 91 183 0 826571360 7759120 21597328
05:19:23 29173 8192000000 9758265280 10066186240 830123408 9.200 100 91 182 0 863607072 11890288 21593376
05:20:53 21507 8192000000 9801682832 10117906432 865940704 9.560 100 84 168 0 903472288 18439936 19091648
05:22:20 8638 8192000000 9853460368 10181337088 902374800 9.922 100 85 170 0 962095824 40151408 19569616
05:23:30 8963 8192000000 9896363360 10234327040 933142400 10.226 100 76 150 1 1003980192 54742240 16095552
05:24:42 4935 8192000000 9947597376 10295320576 965740032 10.545 100 86 172 0 1066641216 82409904 18491280
05:25:53 2367 8192000000 9964184272 10319212544 992252848 10.803 100 88 174 0 1080293504 71038144 17002512
05:26:58 1688 8192000000 9979792496 10343698432 1014867216 11.022 100 91 180 1 1091097984 57328368 18902400
05:28:01 2903 8192000000 9999566688 10367586304 1036309648 11.229 100 81 158 0 1110867088 58106688 16450752
05:29:06 41579 8192000000 9985146272 10371293184 1057110784 11.429 100 55 108 0 1123029424 54889488 11029152
05:30:48 7811 8192000000 9970069296 10362101760 1065247136 11.507 100 28 56 0 1089149408 17737760 6164512
05:31:57 6136 8192000000 10019158624 10419892224 1074969120 11.600 100 43 85 1 1127896736 44346768 8580848
05:33:04 7006 8192000000 9988743120 10394906624 1080897152 11.656 100 21 42 0 1101260432 16152064 4211216
05:34:13 38589 8192000000 10008264416 10401890304 1085781648 11.703 100 51 103 0 1115355808 18055168 11518992
05:35:52 7819 8192000000 10018089120 10420064256 1091575696 11.758 100 54 106 2 1126381520 23136256 11669568
05:37:07 27395 8192000000 10045239120 10444316672 1106961904 11.904 100 48 93 0 1149294784 33022256 9310624
05:38:47 7091 8192000000 10117165600 10518339584 1124105424 12.066 100 60 120 1 1223070256 86911056 12053776
05:40:01 67499 8192000000 10137739664 10548191232 1135034080 12.169 100 43 85 1 1251432848 107318480 9080288
05:42:16 18442 8192000000 10104167072 10517004288 1102021008 11.857 97 40 80 0 1200775664 90618176 8136480
05:43:42 22568 8192000000 10135794768 10542964736 1092575024 11.767 97 36 72 0 1235573648 134621856 8376768
05:45:23 16068 8192000000 10133935072 10555002880 1117619968 12.005 100 43 84 0 1228911280 101966144 9325168
05:46:52 22625 8192000000 10174778416 10595577856 1112959952 11.960 98 45 90 0 1275121584 151741216 10420416
05:48:27 6642 8192000000 10233320272 10632273920 1098299760 11.822 98 56 112 0 1319153312 207156752 13696800
05:49:38 4919 8192000000 10230216784 10631241728 1097143936 11.811 99 48 95 0 1322222576 214346320 10732320
05:50:46 5722 8192000000 10217980016 10628739072 1105565248 11.890 99 47 94 1 1326590496 209792656 11232592
05:51:58 3224 8192000000 10244316208 10644262912 1115066800 11.980 100 63 122 0 1349448448 220518352 13863296
05:53:07 1883 8192000000 10263681728 10670034944 1106914848 11.903 99 61 122 1 1369841536 249242800 13683888
05:54:16 701 8192000000 10304841632 10706898944 1127159088 12.095 100 87 171 0 1403636576 256663792 19813696
05:55:22 3332 8192000000 10363447776 10760486912 1133538976 12.155 100 72 144 0 1464621440 313965392 17117072
05:56:31 7766 8192000000 10371375600 10786590720 1117598192 12.004 100 45 90 0 1484267520 354891584 11777744
05:57:42 7901 8192000000 10316583008 10806849536 1121622112 12.042 100 33 64 0 1447273760 317413152 8238496
05:58:52 6676 8192000000 10340139136 10761138176 1128306848 12.105 100 31 62 0 1442121760 306531136 7283776
06:00:06 14479 8192000000 10231570768 10715504640 1113098160 11.962 99 43 85 0 1331727792 208632512 9997120
06:01:34 26322 8192000000 10109909680 10591662080 1122207520 12.048 100 13 26 0 1239479808 114714080 2558208
06:03:38 31112 8192000000 10077497584 10504495104 1118325360 12.011 99 18 35 0 1155453264 33142928 3984976
06:05:16 9731 8192000000 10134171456 10554568704 1133507856 12.154 100 37 71 0 1214386336 73357280 7521200
06:06:29 30502 8192000000 10109955456 10586210304 1143120416 12.245 100 16 32 0 1257272816 110610736 3541664
06:08:01 20516 8192000000 10082746320 10502455296 1145832144 12.270 100 51 102 0 1166930448 11177232 9921072
06:09:23 87498 8192000000 10110124544 10546823168 1145950544 12.271 99 39 75 0 1192232720 37193616 9088560
06:11:52 66859 8192000000 10137719616 10606088192 1151132144 12.320 100 34 68 0 1254371840 95542416 7697280
06:14:09 10570 8192000000 10120545648 10560806912 1158162912 12.386 100 29 59 0 1230953520 66444032 6346576
06:15:23 21875 8192000000 10154150384 10586021888 1167275680 12.471 100 50 99 0 1248844432 71359616 10209136
06:16:49 32342 8192000000 10146263120 10615930880 1168136352 12.479 100 20 40 0 1274852816 101955824 4760640
06:18:51 48623 8192000000 10126324560 10589143040 1176714752 12.560 100 14 28 0 1225042848 45711232 2616864
06:20:44 76714 8192000000 10150955456 10609410048 1181656800 12.606 100 28 56 0 1241087360 53566928 5863632
06:24:27 40860 8192000000 10086523424 10562007040 1131042128 12.131 97 28 56 1 1168520928 31541232 5937568
06:26:24 28512 8192000000 10108404048 10581889024 1152752480 12.335 100 29 56 0 1186564048 27604704 6206864
06:27:59 41376 8192000000 10085085536 10543394816 1103771888 11.873 95 21 42 0 1155435856 47530096 4133872
06:29:40 25994 8192000000 10083834944 10508292096 1103992864 11.876 96 36 72 0 1151893536 40942432 6958240
06:31:08 56566 8192000000 10107502000 10570366976 1124902944 12.073 98 31 62 0 1204769888 73710880 6156064
06:33:06 64730 8192000000 10074103120 10505302016 1034129104 11.208 91 9 18 0 1100993056 65180320 1683632
06:35:51 19051 8192000000 10050491872 10476158976 1104507456 11.880 98 39 78 0 1134583648 22581840 7494352
06:37:13 12397 8192000000 10064057968 10514042880 1090265616 11.745 98 38 76 1 1152795616 54783008 7746992
06:38:28 72828 8192000000 10056881552 10484011008 1091313376 11.755 99 45 90 0 1156742320 56667104 8761840
06:40:58 58160 8192000000 10024646480 10470596608 1068870272 11.541 98 13 26 0 1134006016 62269632 2866112
06:43:09 35410 8192000000 10086478416 10529456128 1099112992 11.829 100 11 22 0 1177884480 76409888 2361600
06:44:46 49251 8192000000 10071994608 10514595840 1095599776 11.796 99 23 46 0 1158788128 58473344 4715008
06:46:41 55394 8192000000 10050415440 10493009920 1097694464 11.816 99 17 34 0 1141560848 39896096 3970288
06:48:36 40084 8192000000 10057719824 10526445568 1104200272 11.877 99 29 57 1 1144516928 33663632 6653024
06:50:17 37087 8192000000 10066834912 10508345344 1112392272 11.955 100 21 42 0 1143919744 27381040 4146432
06:51:56 37044 8192000000 10149958032 10654732288 1127180400 12.095 100 26 52 0 1263025472 130367920 5477152
06:53:34 44002 8192000000 10067416064 10500276224 1126018144 12.084 100 30 60 0 1176249104 44169056 6061904
06:55:19 91913 8192000000 10065972752 10519678976 1129494896 12.117 100 32 64 0 1177760784 41760464 6505424
06:58:02 82910 8192000000 10045400800 10515451904 1117797968 12.006 98 8 16 0 1145773712 26751376 1224368
07:00:25 64599 8192000000 10102089680 10542202880 1129337568 12.115 99 19 36 1 1174709088 42107264 3264256
07:02:41 31967 8192000000 10070297008 10523627520 1143178672 12.245 100 11 21 0 1185413872 40102848 2132352
07:04:13 39293 8192000000 10111200592 10550620160 1112955520 11.960 96 25 50 0 1171033824 52628720 5449584
07:06:03 45958 8192000000 10085481472 10525253632 1139352896 12.209 99 25 50 0 1185601104 40876608 5371600
07:07:54 37910 8192000000 10142441792 10591084544 1141757104 12.232 99 45 88 0 1229321024 78723536 8840384
07:09:32 124045 8192000000 10085580320 10614554624 1097393456 11.813 95 11 23 0 1164855040 65079040 2382544
07:12:36 97471 8192000000 10075071904 10544668672 1106435360 11.899 97 11 23 1 1147233504 38360144 2438000
07:15:30 68975 8192000000 9644024720 10004422656 698299840 7.854 61 19 34 0 736642800 35188608 3154352

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:14, from 15-02-2024 07:18:47 to 15-02-2024 07:19:01.

Exceptions occured during test was in run

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

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

Content of mon$database and FB version 


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


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

Database statistics 

 
Database "/home/bases/oltp40-etalone.fdb" 
Gstat execution time Thu Feb 15 07:19:05 2024 
 
Database header page information: 
    Flags            0 
    Generation        90338 
    System Change Number    0 
    Page size        8192 
    ODS version        13.0 
    Oldest transaction    171474 
    Oldest active        173378 
    Oldest snapshot        173378 
    Next transaction    173379 
    Sequence number        0 
    Next attachment ID    693 
    Implementation        HW=AMD/Intel/x64 little-endian OS=Linux CC=gcc 
    Shadow count        0 
    Page buffers        0 
    Next header page    0 
    Database dialect    3 
    Creation date        Apr 30, 2020 7:30:08 
    Attributes        force write 
 
    Variable header data: 
    Database GUID:    {58978C10-B735-40F5-8B7D-F7A1956E782B} 
    Sweep interval:        0 
    *END* 
 
 
Database file sequence: 
File /home/bases/oltp40-etalone.fdb is the only file 
 
Analyzing database pages ... 
AGENTS (150) 
    Primary pointer page: 524, Index root page: 525 
    Total formats: 1, used formats: 1 
    Average record length: 33.60, total records: 50 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 344.00, compression ratio: 10.24 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 31% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 1 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index AGENTS_ID_DESC (2) 
    Root page: 1504333, depth: 1, leaf buckets: 1, nodes: 50 
    Average node length: 11.82, total dup: 0, max dup: 0 
    Average key length: 10.80, compression ratio: 0.83 
    Average prefix length: 1.18, average data length: 7.82 
    Clustering factor: 1, ratio: 0.02 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index AGENTS_IS_OUR_FIRM (4) 
    Root page: 1504335, depth: 1, leaf buckets: 1, nodes: 50 
    Average node length: 3.08, total dup: 48, max dup: 48 
    Average key length: 2.04, compression ratio: 0.50 
    Average prefix length: 0.96, average data length: 0.06 
    Clustering factor: 1, ratio: 0.02 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index AGENTS_IS_SUPPLIER (3) 
    Root page: 1504334, depth: 1, leaf buckets: 1, nodes: 50 
    Average node length: 3.08, total dup: 48, max dup: 44 
    Average key length: 2.04, compression ratio: 0.54 
    Average prefix length: 1.04, average data length: 0.06 
    Clustering factor: 1, ratio: 0.02 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index AGENTS_NAME_UNQ (1) 
    Root page: 1504332, depth: 1, leaf buckets: 1, nodes: 50 
    Average node length: 17.20, total dup: 0, max dup: 0 
    Average key length: 15.88, compression ratio: 0.92 
    Average prefix length: 1.42, average data length: 13.20 
    Clustering factor: 1, ratio: 0.02 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PK_AGENTS (0) 
    Root page: 1504331, depth: 1, leaf buckets: 1, nodes: 50 
    Average node length: 11.82, total dup: 0, max dup: 0 
    Average key length: 10.80, compression ratio: 0.83 
    Average prefix length: 1.18, average data length: 7.82 
    Clustering factor: 1, ratio: 0.02 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
BUSINESS_OPS (154) 
    Primary pointer page: 532, Index root page: 533 
    Total formats: 1, used formats: 1 
    Average record length: 108.20, total records: 20 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1235.00, compression ratio: 11.41 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 31% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 1 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index BO_UNIT_UNQ (1) 
    Root page: 1504264, depth: 1, leaf buckets: 1, nodes: 20 
    Average node length: 18.25, total dup: 0, max dup: 0 
    Average key length: 17.20, compression ratio: 1.24 
    Average prefix length: 7.05, average data length: 14.25 
    Clustering factor: 1, ratio: 0.05 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index BUSINESS_OPS_PREDICT_PRIOR (3) 
    Root page: 1504266, depth: 1, leaf buckets: 1, nodes: 20 
    Average node length: 5.40, total dup: 0, max dup: 0 
    Average key length: 4.35, compression ratio: 0.67 
    Average prefix length: 1.20, average data length: 1.70 
    Clustering factor: 1, ratio: 0.05 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index BUSINESS_OPS_RND_WGTH (2) 
    Root page: 1504265, depth: 1, leaf buckets: 1, nodes: 20 
    Average node length: 4.30, total dup: 6, max dup: 3 
    Average key length: 3.25, compression ratio: 0.72 
    Average prefix length: 1.35, average data length: 1.00 
    Clustering factor: 1, ratio: 0.05 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index RDB$1 (0) 
    Root page: 1504263, depth: 1, leaf buckets: 1, nodes: 20 
    Average node length: 5.20, total dup: 0, max dup: 0 
    Average key length: 4.15, compression ratio: 0.65 
    Average prefix length: 1.10, average data length: 1.60 
    Clustering factor: 1, ratio: 0.05 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
DOC_DATA (139) 
    Primary pointer page: 502, Index root page: 503 
    Total formats: 1, used formats: 1 
    Average record length: 47.68, total records: 7665759 
    Average version length: 48.16, total versions: 40825, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 64.00, compression ratio: 1.34 
    Pointer pages: 55, data page slots: 88640 
    Data pages: 88640, average fill: 69% 
    Primary pages: 88639, secondary pages: 1, swept pages: 50771 
    Empty pages: 1, full pages: 58268 
    Fill distribution: 
     0 - 19% = 13 
    20 - 39% = 70 
    40 - 59% = 2499 
    60 - 79% = 86030 
    80 - 99% = 28 
 
    Index DOC_DATA_DOC_WARE_UNQ (0) 
    Root page: 1510636, depth: 3, leaf buckets: 23300, nodes: 7665759 
    Average node length: 18.86, total dup: 0, max dup: 0 
    Average key length: 15.87, compression ratio: 1.70 
    Average prefix length: 14.13, average data length: 12.87 
    Clustering factor: 1651567, ratio: 0.22 
    Fill distribution: 
         0 - 19% = 327 
        20 - 39% = 2266 
        40 - 59% = 3967 
        60 - 79% = 2534 
        80 - 99% = 14206 
 
    Index DOC_DATA_ID_DESC (1) 
    Root page: 1528140, depth: 3, leaf buckets: 13520, nodes: 7665759 
    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: 1475922, ratio: 0.19 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 1851 
        40 - 59% = 1878 
        60 - 79% = 1165 
        80 - 99% = 8626 
 
    Index FK_DOC_DATA_DOC_LIST (2) 
    Root page: 1546735, depth: 3, leaf buckets: 8340, nodes: 7665759 
    Average node length: 6.60, total dup: 5753461, max dup: 49 
    Average key length: 3.61, compression ratio: 2.49 
    Average prefix length: 7.63, average data length: 1.37 
    Clustering factor: 1468934, ratio: 0.19 
    Fill distribution: 
         0 - 19% = 119 
        20 - 39% = 1111 
        40 - 59% = 1314 
        60 - 79% = 1003 
        80 - 99% = 4793 
 
DOC_LIST (138) 
    Primary pointer page: 500, Index root page: 501 
    Total formats: 1, used formats: 1 
    Average record length: 56.92, total records: 2202482 
    Average version length: 58.86, total versions: 22570, max versions: 2 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 84.00, compression ratio: 1.48 
    Pointer pages: 18, data page slots: 28496 
    Data pages: 28496, average fill: 71% 
    Primary pages: 28496, secondary pages: 0, swept pages: 16875 
    Empty pages: 0, full pages: 14159 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 19 
    40 - 59% = 566 
    60 - 79% = 27882 
    80 - 99% = 29 
 
    Index DOC_LIST_ID_DESC (1) 
    Root page: 1541152, depth: 3, leaf buckets: 4541, nodes: 2202482 
    Average node length: 11.41, total dup: 0, max dup: 0 
    Average key length: 8.45, compression ratio: 1.06 
    Average prefix length: 3.55, average data length: 5.45 
    Clustering factor: 671485, ratio: 0.30 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 958 
        40 - 59% = 857 
        60 - 79% = 777 
        80 - 99% = 1949 
 
    Index DOC_LIST_WORKER_OPTYPE (2) 
    Root page: 1544398, depth: 3, leaf buckets: 2401, nodes: 2203190 
    Average node length: 4.97, total dup: 2202292, max dup: 20322 
    Average key length: 2.01, compression ratio: 4.47 
    Average prefix length: 8.99, average data length: 0.01 
    Clustering factor: 1250971, ratio: 0.57 
    Fill distribution: 
         0 - 19% = 3 
        20 - 39% = 220 
        40 - 59% = 1399 
        60 - 79% = 550 
        80 - 99% = 229 
 
    Index FK_DOC_LIST_AGENTS (3) 
    Root page: 1545933, depth: 3, leaf buckets: 1747, nodes: 2202482 
    Average node length: 4.97, total dup: 2202432, max dup: 130191 
    Average key length: 2.01, compression ratio: 4.48 
    Average prefix length: 8.99, average data length: 0.01 
    Clustering factor: 1053156, ratio: 0.48 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 3 
        40 - 59% = 589 
        60 - 79% = 34 
        80 - 99% = 1121 
 
    Index PK_DOC_LIST (0) 
    Root page: 1538209, depth: 3, leaf buckets: 4354, nodes: 2202482 
    Average node length: 11.41, total dup: 0, max dup: 0 
    Average key length: 8.45, compression ratio: 1.06 
    Average prefix length: 3.55, average data length: 5.45 
    Clustering factor: 671485, ratio: 0.30 
    Fill distribution: 
         0 - 19% = 102 
        20 - 39% = 627 
        40 - 59% = 675 
        60 - 79% = 870 
        80 - 99% = 2080 
 
DOC_STATES (149) 
    Primary pointer page: 522, Index root page: 523 
    Total formats: 1, used formats: 1 
    Average record length: 67.50, total records: 4 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 650.00, compression ratio: 9.63 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 4% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index DOC_STATES_MCODE_UNQ (1) 
    Root page: 1504337, depth: 1, leaf buckets: 1, nodes: 4 
    Average node length: 17.75, total dup: 0, max dup: 0 
    Average key length: 16.50, compression ratio: 1.08 
    Average prefix length: 4.00, average data length: 13.75 
    Clustering factor: 1, ratio: 0.25 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index DOC_STATES_NAME_UNQ (2) 
    Root page: 1504338, depth: 1, leaf buckets: 1, nodes: 4 
    Average node length: 33.25, total dup: 0, max dup: 0 
    Average key length: 32.00, compression ratio: 0.99 
    Average prefix length: 2.50, average data length: 29.25 
    Clustering factor: 1, ratio: 0.25 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PK_DOC_STATES (0) 
    Root page: 1504336, depth: 1, leaf buckets: 1, nodes: 4 
    Average node length: 4.75, total dup: 0, max dup: 0 
    Average key length: 3.50, compression ratio: 0.86 
    Average prefix length: 1.50, average data length: 1.50 
    Clustering factor: 1, ratio: 0.25 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
FB_ERRORS (155) 
    Primary pointer page: 534, Index root page: 535 
    Total formats: 2, used formats: 2 
    Average record length: 57.88, total records: 2182 
    Average version length: 79.61, total versions: 757, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 270.43, compression ratio: 4.67 
    Pointer pages: 1, data page slots: 40 
    Data pages: 40, average fill: 72% 
    Primary pages: 39, secondary pages: 1, swept pages: 0 
    Empty pages: 4, full pages: 34 
    Fill distribution: 
     0 - 19% = 5 
    20 - 39% = 0 
    40 - 59% = 1 
    60 - 79% = 22 
    80 - 99% = 12 
 
    Index FB_ERRORS_GDS_CODE (0) 
    Root page: 398, depth: 2, leaf buckets: 2, nodes: 2182 
    Average node length: 4.40, total dup: 756, max dup: 1 
    Average key length: 2.67, compression ratio: 1.87 
    Average prefix length: 4.33, average data length: 0.67 
    Clustering factor: 1518, ratio: 0.70 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 0 
        40 - 59% = 1 
        60 - 79% = 1 
        80 - 99% = 0 
 
INVNT_SALDO (145) 
    Primary pointer page: 514, Index root page: 515 
    Total formats: 2, used formats: 1 
    Average record length: 83.25, total records: 400 
    Average version length: 37.14, total versions: 1200, max versions: 3 
    Average fragment length: 2.00, total fragments: 5, max fragments: 1 
    Average unpacked length: 104.00, compression ratio: 1.25 
    Pointer pages: 1, data page slots: 24 
    Data pages: 24, average fill: 54% 
    Primary pages: 14, secondary pages: 10, swept pages: 0 
    Empty pages: 8, full pages: 13 
    Fill distribution: 
     0 - 19% = 11 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 13 
 
    Index PK_INVNT_SALDO (0) 
    Root page: 1510371, depth: 1, leaf buckets: 1, nodes: 400 
    Average node length: 11.22, total dup: 0, max dup: 0 
    Average key length: 10.22, compression ratio: 0.88 
    Average prefix length: 1.78, average data length: 7.22 
    Clustering factor: 326, ratio: 0.81 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 0 
        40 - 59% = 1 
        60 - 79% = 0 
        80 - 99% = 0 
 
INVNT_TURNOVER_LOG (153) 
    Primary pointer page: 530, Index root page: 531 
    Total formats: 1, used formats: 1 
    Average record length: 16.43, total records: 80093 
    Average version length: 68.31, total versions: 70045, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 88.00, compression ratio: 5.36 
    Pointer pages: 7, data page slots: 2840 
    Data pages: 1912, average fill: 56% 
    Primary pages: 1911, secondary pages: 1, swept pages: 195 
    Empty pages: 386, full pages: 852 
    Fill distribution: 
     0 - 19% = 491 
    20 - 39% = 170 
    40 - 59% = 183 
    60 - 79% = 284 
    80 - 99% = 784 
 
    Index INVNT_TURNOVER_LOG_WARE_DD_ID (0) 
    Root page: 1694758, depth: 3, leaf buckets: 377, nodes: 80093 
    Average node length: 13.17, total dup: 6397, max dup: 1 
    Average key length: 10.65, compression ratio: 2.54 
    Average prefix length: 19.27, average data length: 7.73 
    Clustering factor: 56469, ratio: 0.71 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 313 
        40 - 59% = 59 
        60 - 79% = 4 
        80 - 99% = 0 
 
MONEY_SALDO (141) 
    Primary pointer page: 506, Index root page: 507 
    Total formats: 1, used formats: 1 
    Average record length: 15.22, total records: 49 
    Average version length: 9.00, total versions: 207, max versions: 9 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 32.00, compression ratio: 2.10 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 85% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 1 
 
    Index PK_MONEY_SALDO (0) 
    Root page: 1510383, depth: 1, leaf buckets: 1, nodes: 49 
    Average node length: 11.82, total dup: 0, max dup: 0 
    Average key length: 10.80, compression ratio: 0.83 
    Average prefix length: 1.18, average data length: 7.82 
    Clustering factor: 1, ratio: 0.02 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
MONEY_TURNOVER_LOG (140) 
    Primary pointer page: 504, Index root page: 505 
    Total formats: 1, used formats: 1 
    Average record length: 11.02, total records: 1568 
    Average version length: 43.54, total versions: 1476, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 58.00, compression ratio: 5.26 
    Pointer pages: 1, data page slots: 32 
    Data pages: 32, average fill: 52% 
    Primary pages: 31, secondary pages: 1, swept pages: 2 
    Empty pages: 8, full pages: 13 
    Fill distribution: 
     0 - 19% = 10 
    20 - 39% = 3 
    40 - 59% = 2 
    60 - 79% = 5 
    80 - 99% = 12 
 
    Index MONEY_TURNOVER_LOG_AGENT_OPTYPE (0) 
    Root page: 97020, depth: 2, leaf buckets: 3, nodes: 1568 
    Average node length: 4.25, total dup: 1470, max dup: 155 
    Average key length: 2.65, compression ratio: 7.17 
    Average prefix length: 18.41, average data length: 0.59 
    Clustering factor: 841, ratio: 0.54 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 1 
        40 - 59% = 0 
        60 - 79% = 1 
        80 - 99% = 0 
 
MON_CACHE_MEMORY (165) 
    Primary pointer page: 555, Index root page: 556 
    Total formats: 2, used formats: 1 
    Average record length: 97.66, total records: 73 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 112.00, compression ratio: 1.15 
    Pointer pages: 1, data page slots: 2 
    Data pages: 2, average fill: 51% 
    Primary pages: 2, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 1 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 1 
    40 - 59% = 0 
    60 - 79% = 1 
    80 - 99% = 0 
 
    Index PK_MON_CACHE_MEMORY (0) 
    Root page: 1504238, depth: 1, leaf buckets: 1, nodes: 73 
    Average node length: 11.68, total dup: 0, max dup: 0 
    Average key length: 10.67, compression ratio: 0.84 
    Average prefix length: 1.32, average data length: 7.68 
    Clustering factor: 2, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
MON_LOG (162) 
    Primary pointer page: 548, Index root page: 549 
    Total formats: 2, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index MON_LOG_DTS (4) 
    Root page: 1504251, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index MON_LOG_GDSCODE (2) 
    Root page: 1504249, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index MON_LOG_ROWSET_DESC (1) 
    Root page: 1504248, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index MON_LOG_UNIT (3) 
    Root page: 1504250, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PK_MON_LOG (0) 
    Root page: 1504247, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
MON_LOG_TABLE_STATS (163) 
    Primary pointer page: 550, Index root page: 551 
    Total formats: 2, used formats: 1 
    Average record length: 67.13, total records: 30 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 611.00, compression ratio: 9.10 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 31% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 1 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index MON_LOG_TABLE_STATS_DTS (4) 
    Root page: 1504246, depth: 1, leaf buckets: 1, nodes: 30 
    Average node length: 3.50, total dup: 23, max dup: 4 
    Average key length: 2.47, compression ratio: 3.24 
    Average prefix length: 7.53, average data length: 0.47 
    Clustering factor: 1, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index MON_LOG_TABLE_STATS_GDSCODE (2) 
    Root page: 1504244, depth: 1, leaf buckets: 1, nodes: 30 
    Average node length: 2.00, total dup: 29, max dup: 29 
    Average key length: 1.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 1, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index MON_LOG_TABLE_STATS_ROWSET (1) 
    Root page: 1504243, depth: 1, leaf buckets: 1, nodes: 30 
    Average node length: 3.33, total dup: 29, max dup: 29 
    Average key length: 2.30, compression ratio: 3.91 
    Average prefix length: 8.70, average data length: 0.30 
    Clustering factor: 1, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index MON_LOG_TABLE_STATS_TN_UNIT (3) 
    Root page: 1504245, depth: 1, leaf buckets: 1, nodes: 30 
    Average node length: 12.90, total dup: 0, max dup: 0 
    Average key length: 11.87, compression ratio: 1.42 
    Average prefix length: 7.63, average data length: 9.20 
    Clustering factor: 1, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PK_MON_LOG_TABLE_STATS (0) 
    Root page: 1504242, depth: 1, leaf buckets: 1, nodes: 30 
    Average node length: 8.37, total dup: 0, max dup: 0 
    Average key length: 7.33, compression ratio: 1.23 
    Average prefix length: 4.63, average data length: 4.37 
    Clustering factor: 1, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
OPTYPES (136) 
    Primary pointer page: 496, Index root page: 497 
    Total formats: 2, used formats: 1 
    Average record length: 67.56, total records: 9 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 386.00, compression ratio: 5.71 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 9% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index OPTYPES_MCODE_UNQ (1) 
    Root page: 1544827, depth: 1, leaf buckets: 1, nodes: 9 
    Average node length: 8.56, total dup: 0, max dup: 0 
    Average key length: 6.89, compression ratio: 0.73 
    Average prefix length: 0.44, average data length: 4.56 
    Clustering factor: 1, ratio: 0.11 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PK_OPTYPES (0) 
    Root page: 1544826, depth: 1, leaf buckets: 1, nodes: 9 
    Average node length: 6.11, total dup: 0, max dup: 0 
    Average key length: 5.00, compression ratio: 0.60 
    Average prefix length: 0.89, average data length: 2.11 
    Clustering factor: 1, ratio: 0.11 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
PDISTR (146) 
    Primary pointer page: 516, Index root page: 517 
    Total formats: 1, used formats: 1 
    Average record length: 37.09, total records: 814068 
    Average version length: 37.87, total versions: 14526, max versions: 2 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 54.00, compression ratio: 1.46 
    Pointer pages: 6, data page slots: 8888 
    Data pages: 8888, average fill: 63% 
    Primary pages: 8885, secondary pages: 3, swept pages: 4721 
    Empty pages: 34, full pages: 3253 
    Fill distribution: 
     0 - 19% = 63 
    20 - 39% = 89 
    40 - 59% = 1527 
    60 - 79% = 7189 
    80 - 99% = 20 
 
    Index PDISTR_AGENT_ID (2) 
    Root page: 1509330, depth: 2, leaf buckets: 888, nodes: 807262 
    Average node length: 4.89, total dup: 807213, max dup: 155236 
    Average key length: 2.01, compression ratio: 4.48 
    Average prefix length: 8.99, average data length: 0.01 
    Clustering factor: 90344, ratio: 0.11 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 153 
        40 - 59% = 469 
        60 - 79% = 179 
        80 - 99% = 86 
 
    Index PDISTR_SNDOP_RCVOP_SNDID_ASC (0) 
    Root page: 1508635, depth: 3, leaf buckets: 1008, nodes: 807262 
    Average node length: 5.89, total dup: 719088, max dup: 42 
    Average key length: 3.02, compression ratio: 7.30 
    Average prefix length: 21.09, average data length: 0.91 
    Clustering factor: 159623, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 67 
        40 - 59% = 630 
        60 - 79% = 58 
        80 - 99% = 252 
 
    Index PDISTR_SNDOP_RCVOP_SNDID_DESC (1) 
    Root page: 1509209, depth: 3, leaf buckets: 1039, nodes: 807262 
    Average node length: 5.89, total dup: 719088, max dup: 42 
    Average key length: 3.02, compression ratio: 7.29 
    Average prefix length: 21.09, average data length: 0.91 
    Clustering factor: 161435, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 116 
        40 - 59% = 621 
        60 - 79% = 63 
        80 - 99% = 238 
 
    Index PDISTR_WORKER_SND_ID (3) 
    Root page: 1510200, depth: 3, leaf buckets: 1153, nodes: 807262 
    Average node length: 5.97, total dup: 719088, max dup: 42 
    Average key length: 3.10, compression ratio: 5.49 
    Average prefix length: 16.01, average data length: 0.99 
    Clustering factor: 154186, ratio: 0.19 
    Fill distribution: 
         0 - 19% = 4 
        20 - 39% = 247 
        40 - 59% = 618 
        60 - 79% = 203 
        80 - 99% = 81 
 
PERF_AGG (158) 
    Primary pointer page: 540, Index root page: 541 
    Total formats: 1, used formats: 1 
    Average record length: 62.77, total records: 5465 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 3.00, total fragments: 38, max fragments: 1 
    Average unpacked length: 379.00, compression ratio: 6.04 
    Pointer pages: 1, data page slots: 96 
    Data pages: 95, average fill: 57% 
    Primary pages: 78, secondary pages: 17, swept pages: 65 
    Empty pages: 11, full pages: 63 
    Fill distribution: 
     0 - 19% = 21 
    20 - 39% = 1 
    40 - 59% = 0 
    60 - 79% = 73 
    80 - 99% = 0 
 
    Index PERF_AGG_UNQ (1) 
    Root page: 1504260, depth: 2, leaf buckets: 7, nodes: 5465 
    Average node length: 5.52, total dup: 0, max dup: 0 
    Average key length: 3.59, compression ratio: 10.04 
    Average prefix length: 34.44, average data length: 1.55 
    Clustering factor: 5184, ratio: 0.95 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 4 
        60 - 79% = 1 
        80 - 99% = 1 
 
    Index PK_PERF_AGG (0) 
    Root page: 1504255, depth: 2, leaf buckets: 10, nodes: 5465 
    Average node length: 11.14, 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: 170, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 1 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 7 
 
PERF_ESTIMATED (280) 
    Primary pointer page: 399, Index root page: 434 
    Total formats: 1, used formats: 1 
    Average record length: 39.07, total records: 78904 
    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: 832 
    Data pages: 832, average fill: 65% 
    Primary pages: 832, secondary pages: 0, swept pages: 0 
    Empty pages: 11, full pages: 819 
    Fill distribution: 
     0 - 19% = 12 
    20 - 39% = 1 
    40 - 59% = 0 
    60 - 79% = 819 
    80 - 99% = 0 
 
    Index PK_PERF_ESTIMATED (0) 
    Root page: 37558, depth: 2, leaf buckets: 101, nodes: 78904 
    Average node length: 10.17, total dup: 0, max dup: 0 
    Average key length: 8.18, compression ratio: 1.10 
    Average prefix length: 3.82, average data length: 5.18 
    Clustering factor: 3104, ratio: 0.04 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 1 
        60 - 79% = 0 
        80 - 99% = 99 
 
PERF_ISQL_STAT (156) 
    Primary pointer page: 536, Index root page: 537 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index PERF_ISQL_STAT_TRN (0) 
    Root page: 1504261, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
PERF_LOG (159) 
    Primary pointer page: 542, Index root page: 543 
    Total formats: 1, used formats: 1 
    Average record length: 110.51, total records: 71 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1691.00, compression ratio: 15.30 
    Pointer pages: 1, data page slots: 2 
    Data pages: 2, average fill: 56% 
    Primary pages: 2, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 1 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 1 
    40 - 59% = 0 
    60 - 79% = 1 
    80 - 99% = 0 
 
PERF_SPLIT_0 (281) 
    Primary pointer page: 601, Index root page: 602 
    Total formats: 1, used formats: 1 
    Average record length: 149.08, total records: 152894 
    Average version length: 149.75, total versions: 2091, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.38 
    Pointer pages: 6, data page slots: 4728 
    Data pages: 3792, average fill: 83% 
    Primary pages: 3791, secondary pages: 1, swept pages: 1 
    Empty pages: 34, full pages: 3746 
    Fill distribution: 
     0 - 19% = 36 
    20 - 39% = 2 
    40 - 59% = 5 
    60 - 79% = 3 
    80 - 99% = 3746 
 
PERF_SPLIT_1 (282) 
    Primary pointer page: 603, Index root page: 604 
    Total formats: 1, used formats: 1 
    Average record length: 149.43, total records: 137151 
    Average version length: 148.30, total versions: 1586, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.35 
    Pointer pages: 6, data page slots: 3992 
    Data pages: 3400, average fill: 83% 
    Primary pages: 3398, secondary pages: 2, swept pages: 2 
    Empty pages: 25, full pages: 3362 
    Fill distribution: 
     0 - 19% = 29 
    20 - 39% = 1 
    40 - 59% = 4 
    60 - 79% = 4 
    80 - 99% = 3362 
 
PERF_SPLIT_2 (283) 
    Primary pointer page: 605, Index root page: 606 
    Total formats: 1, used formats: 1 
    Average record length: 148.67, total records: 140882 
    Average version length: 150.03, total versions: 2435, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.41 
    Pointer pages: 6, data page slots: 3952 
    Data pages: 3520, average fill: 83% 
    Primary pages: 3519, secondary pages: 1, swept pages: 7 
    Empty pages: 52, full pages: 3447 
    Fill distribution: 
     0 - 19% = 54 
    20 - 39% = 1 
    40 - 59% = 7 
    60 - 79% = 12 
    80 - 99% = 3446 
 
PERF_SPLIT_3 (284) 
    Primary pointer page: 607, Index root page: 608 
    Total formats: 1, used formats: 1 
    Average record length: 148.77, total records: 151002 
    Average version length: 152.15, total versions: 2790, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.40 
    Pointer pages: 6, data page slots: 5008 
    Data pages: 3784, average fill: 83% 
    Primary pages: 3782, secondary pages: 2, swept pages: 5 
    Empty pages: 57, full pages: 3704 
    Fill distribution: 
     0 - 19% = 61 
    20 - 39% = 6 
    40 - 59% = 7 
    60 - 79% = 8 
    80 - 99% = 3702 
 
PERF_SPLIT_4 (285) 
    Primary pointer page: 609, Index root page: 610 
    Total formats: 1, used formats: 1 
    Average record length: 148.18, total records: 161141 
    Average version length: 150.92, total versions: 3702, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.45 
    Pointer pages: 6, data page slots: 4576 
    Data pages: 4064, average fill: 82% 
    Primary pages: 4063, secondary pages: 1, swept pages: 7 
    Empty pages: 77, full pages: 3937 
    Fill distribution: 
     0 - 19% = 79 
    20 - 39% = 9 
    40 - 59% = 27 
    60 - 79% = 14 
    80 - 99% = 3935 
 
PERF_SPLIT_5 (286) 
    Primary pointer page: 611, Index root page: 612 
    Total formats: 1, used formats: 1 
    Average record length: 148.03, total records: 145986 
    Average version length: 151.90, total versions: 3018, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.46 
    Pointer pages: 6, data page slots: 3768 
    Data pages: 3608, average fill: 83% 
    Primary pages: 3605, secondary pages: 3, swept pages: 2 
    Empty pages: 20, full pages: 3577 
    Fill distribution: 
     0 - 19% = 21 
    20 - 39% = 3 
    40 - 59% = 6 
    60 - 79% = 1 
    80 - 99% = 3577 
 
PERF_SPLIT_6 (287) 
    Primary pointer page: 613, Index root page: 614 
    Total formats: 1, used formats: 1 
    Average record length: 149.17, total records: 151888 
    Average version length: 150.49, total versions: 2259, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.37 
    Pointer pages: 7, data page slots: 4552 
    Data pages: 3768, average fill: 83% 
    Primary pages: 3766, secondary pages: 2, swept pages: 1 
    Empty pages: 28, full pages: 3722 
    Fill distribution: 
     0 - 19% = 29 
    20 - 39% = 3 
    40 - 59% = 6 
    60 - 79% = 9 
    80 - 99% = 3721 
 
PERF_SPLIT_7 (288) 
    Primary pointer page: 615, Index root page: 616 
    Total formats: 1, used formats: 1 
    Average record length: 147.74, total records: 161954 
    Average version length: 151.40, total versions: 3969, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.48 
    Pointer pages: 7, data page slots: 5576 
    Data pages: 4056, average fill: 83% 
    Primary pages: 4053, secondary pages: 3, swept pages: 4 
    Empty pages: 70, full pages: 3966 
    Fill distribution: 
     0 - 19% = 72 
    20 - 39% = 6 
    40 - 59% = 3 
    60 - 79% = 10 
    80 - 99% = 3965 
 
PERF_SPLIT_8 (289) 
    Primary pointer page: 617, Index root page: 618 
    Total formats: 1, used formats: 1 
    Average record length: 148.63, total records: 152522 
    Average version length: 150.75, total versions: 2673, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.41 
    Pointer pages: 8, data page slots: 4552 
    Data pages: 3832, average fill: 82% 
    Primary pages: 3830, secondary pages: 2, swept pages: 4 
    Empty pages: 76, full pages: 3738 
    Fill distribution: 
     0 - 19% = 79 
    20 - 39% = 5 
    40 - 59% = 4 
    60 - 79% = 8 
    80 - 99% = 3736 
 
PERF_SPLIT_9 (290) 
    Primary pointer page: 619, Index root page: 620 
    Total formats: 1, used formats: 1 
    Average record length: 146.43, total records: 147060 
    Average version length: 152.58, total versions: 4662, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.58 
    Pointer pages: 6, data page slots: 5032 
    Data pages: 3688, average fill: 82% 
    Primary pages: 3685, secondary pages: 3, swept pages: 3 
    Empty pages: 68, full pages: 3599 
    Fill distribution: 
     0 - 19% = 72 
    20 - 39% = 7 
    40 - 59% = 6 
    60 - 79% = 4 
    80 - 99% = 3599 
 
PHRASES (143) 
    Primary pointer page: 510, Index root page: 511 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index PHRASES_ID_DESC (3) 
    Root page: 1510376, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PHRASES_NAME (2) 
    Root page: 1510375, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PHRASES_UNQ (1) 
    Root page: 1510374, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PK_PHRASES (0) 
    Root page: 1510373, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
PSTORNED (147) 
    Primary pointer page: 518, Index root page: 519 
    Total formats: 1, used formats: 1 
    Average record length: 52.32, total records: 2059964 
    Average version length: 52.92, total versions: 19814, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 70.00, compression ratio: 1.34 
    Pointer pages: 16, data page slots: 25616 
    Data pages: 25616, average fill: 69% 
    Primary pages: 25597, secondary pages: 19, swept pages: 13236 
    Empty pages: 194, full pages: 20628 
    Fill distribution: 
     0 - 19% = 357 
    20 - 39% = 395 
    40 - 59% = 1211 
    60 - 79% = 23450 
    80 - 99% = 203 
 
    Index PSTORNED_RCV_ID (1) 
    Root page: 1506208, depth: 3, leaf buckets: 2556, nodes: 2059964 
    Average node length: 5.44, total dup: 1921379, max dup: 1457 
    Average key length: 2.49, compression ratio: 3.61 
    Average prefix length: 8.58, average data length: 0.42 
    Clustering factor: 179611, ratio: 0.09 
    Fill distribution: 
         0 - 19% = 4 
        20 - 39% = 314 
        40 - 59% = 1650 
        60 - 79% = 307 
        80 - 99% = 281 
 
    Index PSTORNED_SND_ID (0) 
    Root page: 1504841, depth: 3, leaf buckets: 2750, nodes: 2059964 
    Average node length: 5.70, total dup: 1848208, max dup: 64 
    Average key length: 2.74, compression ratio: 3.28 
    Average prefix length: 8.36, average data length: 0.64 
    Clustering factor: 369678, ratio: 0.18 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 8 
        40 - 59% = 2513 
        60 - 79% = 201 
        80 - 99% = 28 
 
    Index PSTORNED_WORKER_ID (2) 
    Root page: 1508018, depth: 3, leaf buckets: 2068, nodes: 2059964 
    Average node length: 4.96, total dup: 2059864, max dup: 28488 
    Average key length: 2.00, compression ratio: 1.20 
    Average prefix length: 2.40, average data length: 0.00 
    Clustering factor: 177705, ratio: 0.09 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 204 
        40 - 59% = 1037 
        60 - 79% = 383 
        80 - 99% = 443 
 
RULES_FOR_PDISTR (148) 
    Primary pointer page: 520, Index root page: 521 
    Total formats: 1, used formats: 1 
    Average record length: 17.00, total records: 4 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 334.00, compression ratio: 19.65 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 2% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index RULES_FOR_PDISTR_UNQ (0) 
    Root page: 1504339, depth: 1, leaf buckets: 1, nodes: 4 
    Average node length: 11.50, total dup: 0, max dup: 0 
    Average key length: 10.25, compression ratio: 0.88 
    Average prefix length: 1.50, average data length: 7.50 
    Clustering factor: 1, ratio: 0.25 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
RULES_FOR_QDISTR (137) 
    Primary pointer page: 498, Index root page: 499 
    Total formats: 1, used formats: 1 
    Average record length: 32.71, total records: 7 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 332.00, compression ratio: 10.15 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 4% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index RULES_FOR_QDISTR_RCVOP (1) 
    Root page: 1544825, depth: 1, leaf buckets: 1, nodes: 7 
    Average node length: 5.29, total dup: 2, max dup: 2 
    Average key length: 4.14, compression ratio: 0.72 
    Average prefix length: 1.43, average data length: 1.57 
    Clustering factor: 1, ratio: 0.14 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index RULES_FOR_QDISTR_UNQ (0) 
    Root page: 1544824, depth: 1, leaf buckets: 1, nodes: 7 
    Average node length: 10.14, total dup: 0, max dup: 0 
    Average key length: 8.86, compression ratio: 0.94 
    Average prefix length: 2.14, average data length: 6.14 
    Clustering factor: 1, ratio: 0.14 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
SEMAPHORES (152) 
    Primary pointer page: 528, Index root page: 529 
    Total formats: 1, used formats: 1 
    Average record length: 43.40, total records: 5 
    Average version length: 9.00, total versions: 1, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 346.00, compression ratio: 7.97 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 4% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index PK_SEMAPHORES (0) 
    Root page: 1504327, depth: 1, leaf buckets: 1, nodes: 5 
    Average node length: 12.40, total dup: 0, max dup: 0 
    Average key length: 11.00, compression ratio: 0.82 
    Average prefix length: 0.60, average data length: 8.40 
    Clustering factor: 1, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index SEMAPHORES_TASK_UNQ (1) 
    Root page: 1504328, depth: 1, leaf buckets: 1, nodes: 5 
    Average node length: 23.40, total dup: 0, max dup: 0 
    Average key length: 22.00, compression ratio: 1.07 
    Average prefix length: 4.20, average data length: 19.40 
    Clustering factor: 1, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
SETTINGS (135) 
    Primary pointer page: 494, Index root page: 495 
    Total formats: 1, used formats: 1 
    Average record length: 97.62, total records: 149 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1347.00, compression ratio: 13.80 
    Pointer pages: 1, data page slots: 3 
    Data pages: 3, average fill: 70% 
    Primary pages: 3, secondary pages: 0, swept pages: 1 
    Empty pages: 0, full pages: 2 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 1 
    60 - 79% = 0 
    80 - 99% = 2 
 
    Index SETTINGS_MCODE_WM_UNQ (1) 
    Root page: 1544931, depth: 1, leaf buckets: 1, nodes: 149 
    Average node length: 14.66, total dup: 0, max dup: 0 
    Average key length: 13.55, compression ratio: 2.19 
    Average prefix length: 19.07, average data length: 10.66 
    Clustering factor: 48, ratio: 0.32 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 1 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index SETTINGS_MODE_CODE (0) 
    Root page: 1544828, depth: 1, leaf buckets: 1, nodes: 149 
    Average node length: 25.56, total dup: 0, max dup: 0 
    Average key length: 24.56, compression ratio: 1.63 
    Average prefix length: 18.58, average data length: 21.56 
    Clustering factor: 14, ratio: 0.09 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 0 
        40 - 59% = 1 
        60 - 79% = 0 
        80 - 99% = 0 
 
TMP$DEP_DOCS (129) 
    Primary pointer page: 482, Index root page: 483 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index TMP_DEP_DOCS_UNQ (0) 
    Root page: 1544832, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
TMP$IDX_RECALC (132) 
    Primary pointer page: 488, Index root page: 489 
    Total formats: 2, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index TMP_IDX_RECALC_IDX_NAME_UNQ (0) 
    Root page: 1544829, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
TMP$MON_LOG (133) 
    Primary pointer page: 490, Index root page: 491 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
TMP$MON_LOG_TABLE_STATS (134) 
    Primary pointer page: 492, Index root page: 493 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
TMP$PERF_EST_WHOLE (161) 
    Primary pointer page: 546, Index root page: 547 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
TMP$PERF_LOG (160) 
    Primary pointer page: 544, Index root page: 545 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index TMP$PERF_LOG_UNIT_TRN_DTS_END (0) 
    Root page: 1504252, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
TMP$PERF_MON (131) 
    Primary pointer page: 486, Index root page: 487 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
TMP$RESULT_SET (130) 
    Primary pointer page: 484, Index root page: 485 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index TMP_RESULT_SET_DOC (1) 
    Root page: 1544831, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index TMP_RESULT_SET_WARE_DOC (0) 
    Root page: 1544830, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
TMP$SHOPPING_CART (128) 
    Primary pointer page: 480, Index root page: 481 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index TMP_SHOPCART_UNQ (0) 
    Root page: 1544833, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
TPAUSE (166) 
    Primary pointer page: 557, Index root page: 558 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index RDB$PRIMARY2 (0) 
    Root page: 1504237, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
TRACE_STAT (157) 
    Primary pointer page: 538, Index root page: 539 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
WARES (142) 
    Primary pointer page: 508, Index root page: 509 
    Total formats: 1, used formats: 1 
    Average record length: 77.52, total records: 400 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 444.00, compression ratio: 5.73 
    Pointer pages: 1, data page slots: 6 
    Data pages: 6, average fill: 77% 
    Primary pages: 6, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 5 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 5 
    80 - 99% = 1 
 
    Index FK_WARES_WARE_GROUPS (3) 
    Root page: 1552183, depth: 1, leaf buckets: 1, nodes: 400 
    Average node length: 3.17, total dup: 392, max dup: 60 
    Average key length: 2.16, compression ratio: 4.16 
    Average prefix length: 8.86, average data length: 0.14 
    Clustering factor: 48, ratio: 0.12 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PK_WARES (0) 
    Root page: 1510377, depth: 1, leaf buckets: 1, nodes: 400 
    Average node length: 11.22, total dup: 0, max dup: 0 
    Average key length: 10.22, compression ratio: 0.88 
    Average prefix length: 1.78, average data length: 7.22 
    Clustering factor: 344, ratio: 0.86 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 0 
        40 - 59% = 1 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index WARES_ID_DESC (2) 
    Root page: 1510382, depth: 1, leaf buckets: 1, nodes: 400 
    Average node length: 11.22, total dup: 0, max dup: 0 
    Average key length: 10.22, compression ratio: 0.88 
    Average prefix length: 1.78, average data length: 7.22 
    Clustering factor: 344, ratio: 0.86 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 0 
        40 - 59% = 1 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index WARES_NUMB_UNQ (1) 
    Root page: 1510380, depth: 2, leaf buckets: 3, nodes: 400 
    Average node length: 53.25, total dup: 0, max dup: 0 
    Average key length: 52.23, compression ratio: 1.00 
    Average prefix length: 2.74, average data length: 49.25 
    Clustering factor: 355, ratio: 0.89 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 1 
        80 - 99% = 2 
 
WARE_GROUPS (151) 
    Primary pointer page: 526, Index root page: 527 
    Total formats: 1, used formats: 1 
    Average record length: 32.12, total records: 8 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 346.00, compression ratio: 10.77 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 5% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index PK_WARE_GROUPS (0) 
    Root page: 1504329, depth: 1, leaf buckets: 1, nodes: 8 
    Average node length: 11.25, total dup: 0, max dup: 0 
    Average key length: 10.12, compression ratio: 0.89 
    Average prefix length: 1.75, average data length: 7.25 
    Clustering factor: 1, ratio: 0.12 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index WARE_GROUPS_NAME_UNQ (1) 
    Root page: 1504330, depth: 1, leaf buckets: 1, nodes: 8 
    Average node length: 19.88, total dup: 0, max dup: 0 
    Average key length: 18.12, compression ratio: 0.89 
    Average prefix length: 0.25, average data length: 15.88 
    Clustering factor: 1, ratio: 0.12 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
XQD_1000_1200 (176) 
    Primary pointer page: 577, Index root page: 578 
    Total formats: 1, used formats: 1 
    Average record length: 52.10, total records: 115140 
    Average version length: 69.17, total versions: 32714, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 2.42 
    Pointer pages: 3, data page slots: 3968 
    Data pages: 2887, average fill: 47% 
    Primary pages: 2887, secondary pages: 0, swept pages: 524 
    Empty pages: 226, full pages: 508 
    Fill distribution: 
     0 - 19% = 421 
    20 - 39% = 562 
    40 - 59% = 979 
    60 - 79% = 747 
    80 - 99% = 178 
 
    Index XQD_1000_1200_WA_SO_RO_WKR_SND (0) 
    Root page: 1555479, depth: 3, leaf buckets: 224, nodes: 115140 
    Average node length: 6.52, total dup: 100306, max dup: 14 
    Average key length: 3.98, compression ratio: 10.55 
    Average prefix length: 40.15, average data length: 1.85 
    Clustering factor: 20302, ratio: 0.18 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 108 
        40 - 59% = 100 
        60 - 79% = 14 
        80 - 99% = 1 
 
XQD_1000_3300 (178) 
    Primary pointer page: 581, Index root page: 582 
    Total formats: 1, used formats: 1 
    Average record length: 67.78, total records: 7023670 
    Average version length: 68.69, total versions: 135438, 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: 68, data page slots: 110104 
    Data pages: 110104, average fill: 68% 
    Primary pages: 110103, secondary pages: 1, swept pages: 67565 
    Empty pages: 10, full pages: 35368 
    Fill distribution: 
     0 - 19% = 67 
    20 - 39% = 807 
    40 - 59% = 13741 
    60 - 79% = 95174 
    80 - 99% = 315 
 
    Index XQD_1000_3300_WA_SO_RO_WKR_SND (0) 
    Root page: 1480476, depth: 3, leaf buckets: 10858, nodes: 7023670 
    Average node length: 6.51, total dup: 6077165, max dup: 29 
    Average key length: 3.52, compression ratio: 11.94 
    Average prefix length: 40.62, average data length: 1.38 
    Clustering factor: 1651551, ratio: 0.24 
    Fill distribution: 
         0 - 19% = 10 
        20 - 39% = 1796 
        40 - 59% = 6107 
        60 - 79% = 2592 
        80 - 99% = 353 
 
    Index XQD_1000_3300_WKR_DOC_ASC (1) 
    Root page: 1486090, depth: 3, leaf buckets: 8759, nodes: 7023670 
    Average node length: 5.40, total dup: 6744712, max dup: 127 
    Average key length: 2.41, compression ratio: 7.07 
    Average prefix length: 16.63, average data length: 0.37 
    Clustering factor: 1457533, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 9 
        20 - 39% = 1440 
        40 - 59% = 4983 
        60 - 79% = 1422 
        80 - 99% = 905 
 
    Index XQD_1000_3300_WKR_DOC_DEC (2) 
    Root page: 1490630, depth: 3, leaf buckets: 8800, nodes: 7023670 
    Average node length: 5.40, total dup: 6744712, max dup: 127 
    Average key length: 2.41, compression ratio: 7.07 
    Average prefix length: 16.63, average data length: 0.37 
    Clustering factor: 1459817, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 7 
        20 - 39% = 1495 
        40 - 59% = 4956 
        60 - 79% = 1423 
        80 - 99% = 919 
 
XQD_1200_2000 (177) 
    Primary pointer page: 579, Index root page: 580 
    Total formats: 1, used formats: 1 
    Average record length: 68.21, total records: 12174130 
    Average version length: 68.68, total versions: 145146, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.85 
    Pointer pages: 111, data page slots: 179968 
    Data pages: 179968, average fill: 72% 
    Primary pages: 179966, secondary pages: 2, swept pages: 113487 
    Empty pages: 8, full pages: 120474 
    Fill distribution: 
     0 - 19% = 52 
    20 - 39% = 810 
    40 - 59% = 9074 
    60 - 79% = 169191 
    80 - 99% = 841 
 
    Index XQD_1200_2000_WA_SO_RO_WKR_SND (0) 
    Root page: 1495050, depth: 3, leaf buckets: 18609, nodes: 12172642 
    Average node length: 6.63, total dup: 10614836, max dup: 49 
    Average key length: 3.42, compression ratio: 12.27 
    Average prefix length: 40.70, average data length: 1.30 
    Clustering factor: 2465981, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 28 
        20 - 39% = 2141 
        40 - 59% = 11025 
        60 - 79% = 4680 
        80 - 99% = 735 
 
XQD_2000_3300 (179) 
    Primary pointer page: 583, Index root page: 584 
    Total formats: 1, used formats: 1 
    Average record length: 54.57, total records: 1188702 
    Average version length: 69.08, total versions: 144806, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 2.31 
    Pointer pages: 29, data page slots: 45088 
    Data pages: 26760, average fill: 46% 
    Primary pages: 26704, secondary pages: 56, swept pages: 13894 
    Empty pages: 4939, full pages: 11883 
    Fill distribution: 
     0 - 19% = 7404 
    20 - 39% = 4295 
    40 - 59% = 2610 
    60 - 79% = 10573 
    80 - 99% = 1878 
 
    Index XQD_2000_3300_WA_SO_RO_WKR_SND (0) 
    Root page: 1479735, depth: 3, leaf buckets: 1696, nodes: 1045313 
    Average node length: 5.55, total dup: 1003021, max dup: 49 
    Average key length: 2.59, compression ratio: 16.23 
    Average prefix length: 41.45, average data length: 0.55 
    Clustering factor: 69052, ratio: 0.07 
    Fill distribution: 
         0 - 19% = 12 
        20 - 39% = 756 
        40 - 59% = 763 
        60 - 79% = 155 
        80 - 99% = 10 
 
XQD_2100_3300 (180) 
    Primary pointer page: 585, Index root page: 586 
    Total formats: 1, used formats: 1 
    Average record length: 57.40, total records: 794181 
    Average version length: 69.05, total versions: 47074, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 2.20 
    Pointer pages: 23, data page slots: 35792 
    Data pages: 25799, average fill: 32% 
    Primary pages: 25798, secondary pages: 1, swept pages: 13116 
    Empty pages: 4361, full pages: 496 
    Fill distribution: 
     0 - 19% = 7668 
    20 - 39% = 7363 
    40 - 59% = 8407 
    60 - 79% = 2359 
    80 - 99% = 2 
 
    Index XQD_2100_3300_WA_SO_RO_WKR_SND (0) 
    Root page: 1479229, depth: 3, leaf buckets: 1157, nodes: 687524 
    Average node length: 5.93, total dup: 634878, max dup: 76 
    Average key length: 2.99, compression ratio: 14.04 
    Average prefix length: 41.08, average data length: 0.92 
    Clustering factor: 99951, ratio: 0.15 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 462 
        40 - 59% = 561 
        60 - 79% = 129 
        80 - 99% = 4 
 
XQD_3300_3400 (181) 
    Primary pointer page: 587, Index root page: 588 
    Total formats: 1, used formats: 1 
    Average record length: 67.88, total records: 8712237 
    Average version length: 68.88, total versions: 145475, 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: 90, data page slots: 145384 
    Data pages: 145360, average fill: 64% 
    Primary pages: 145335, secondary pages: 25, swept pages: 102637 
    Empty pages: 415, full pages: 45691 
    Fill distribution: 
     0 - 19% = 1805 
    20 - 39% = 8807 
    40 - 59% = 28667 
    60 - 79% = 105352 
    80 - 99% = 729 
 
    Index XQD_3300_3400_WA_SO_RO_WKR_SND (0) 
    Root page: 1472612, depth: 3, leaf buckets: 13403, nodes: 8710451 
    Average node length: 6.69, total dup: 7220270, max dup: 14 
    Average key length: 3.68, compression ratio: 11.43 
    Average prefix length: 40.49, average data length: 1.51 
    Clustering factor: 1923540, ratio: 0.22 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 1692 
        40 - 59% = 7480 
        60 - 79% = 3849 
        80 - 99% = 381 
 
XQS_1000_1200 (182) 
    Primary pointer page: 589, Index root page: 590 
    Total formats: 1, used formats: 1 
    Average record length: 82.53, total records: 21125913 
    Average version length: 82.93, total versions: 3217, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.53 
    Pointer pages: 196, data page slots: 319624 
    Data pages: 319624, average fill: 81% 
    Primary pages: 319620, secondary pages: 4, swept pages: 14649 
    Empty pages: 44, full pages: 318105 
    Fill distribution: 
     0 - 19% = 92 
    20 - 39% = 60 
    40 - 59% = 190 
    60 - 79% = 49711 
    80 - 99% = 269571 
 
    Index XQS_1000_1200_DOC_ID (1) 
    Root page: 1426738, depth: 3, leaf buckets: 19823, nodes: 21125913 
    Average node length: 5.72, total dup: 20645392, max dup: 128 
    Average key length: 2.16, compression ratio: 4.16 
    Average prefix length: 8.86, average data length: 0.14 
    Clustering factor: 3279706, ratio: 0.16 
    Fill distribution: 
         0 - 19% = 5 
        20 - 39% = 1 
        40 - 59% = 9054 
        60 - 79% = 534 
        80 - 99% = 10229 
 
    Index XQS_1000_1200_RCV_ID (3) 
    Root page: 1457002, depth: 3, leaf buckets: 17168, nodes: 21125913 
    Average node length: 6.31, total dup: 18565199, max dup: 49 
    Average key length: 2.75, compression ratio: 3.27 
    Average prefix length: 8.37, average data length: 0.63 
    Clustering factor: 916344, ratio: 0.04 
    Fill distribution: 
         0 - 19% = 3 
        20 - 39% = 2 
        40 - 59% = 775 
        60 - 79% = 309 
        80 - 99% = 16079 
 
    Index XQS_1000_1200_SND_ID (2) 
    Root page: 1441095, depth: 3, leaf buckets: 21664, nodes: 21125913 
    Average node length: 6.35, total dup: 18484607, max dup: 29 
    Average key length: 2.79, compression ratio: 3.23 
    Average prefix length: 8.34, average data length: 0.66 
    Clustering factor: 3573433, ratio: 0.17 
    Fill distribution: 
         0 - 19% = 7 
        20 - 39% = 1 
        40 - 59% = 9441 
        60 - 79% = 571 
        80 - 99% = 11644 
 
    Index XQS_1000_1200_WORKER_ID (0) 
    Root page: 1413370, depth: 3, leaf buckets: 15985, nodes: 21125913 
    Average node length: 5.56, total dup: 21125813, max dup: 228103 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.42, average data length: 0.00 
    Clustering factor: 945054, ratio: 0.04 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 10 
        40 - 59% = 2687 
        60 - 79% = 358 
        80 - 99% = 12928 
 
XQS_1000_3300 (184) 
    Primary pointer page: 593, Index root page: 594 
    Total formats: 1, used formats: 1 
    Average record length: 75.15, total records: 10009010 
    Average version length: 82.61, total versions: 989548, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.68 
    Pointer pages: 107, data page slots: 174016 
    Data pages: 174000, average fill: 72% 
    Primary pages: 173960, secondary pages: 40, swept pages: 33776 
    Empty pages: 327, full pages: 132635 
    Fill distribution: 
     0 - 19% = 1383 
    20 - 39% = 7857 
    40 - 59% = 21082 
    60 - 79% = 102799 
    80 - 99% = 40879 
 
    Index XQS_1000_3300_DOC_ID (1) 
    Root page: 1367524, depth: 3, leaf buckets: 11334, nodes: 10009010 
    Average node length: 5.37, total dup: 9700142, max dup: 223 
    Average key length: 2.23, compression ratio: 4.04 
    Average prefix length: 8.81, average data length: 0.19 
    Clustering factor: 2236882, ratio: 0.22 
    Fill distribution: 
         0 - 19% = 3 
        20 - 39% = 42 
        40 - 59% = 7022 
        60 - 79% = 4153 
        80 - 99% = 114 
 
    Index XQS_1000_3300_RCV_ID (3) 
    Root page: 1379283, depth: 3, leaf buckets: 13800, nodes: 10009010 
    Average node length: 6.24, total dup: 8297050, max dup: 14 
    Average key length: 3.10, compression ratio: 2.90 
    Average prefix length: 8.07, average data length: 0.93 
    Clustering factor: 1566509, ratio: 0.16 
    Fill distribution: 
         0 - 19% = 135 
        20 - 39% = 3759 
        40 - 59% = 4710 
        60 - 79% = 2563 
        80 - 99% = 2633 
 
    Index XQS_1000_3300_SND_ID (2) 
    Root page: 1373081, depth: 3, leaf buckets: 12643, nodes: 10009010 
    Average node length: 5.97, total dup: 8708967, max dup: 59 
    Average key length: 2.83, compression ratio: 3.18 
    Average prefix length: 8.30, average data length: 0.70 
    Clustering factor: 2444557, ratio: 0.24 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 46 
        40 - 59% = 7932 
        60 - 79% = 4534 
        80 - 99% = 131 
 
    Index XQS_1000_3300_WORKER_ID (0) 
    Root page: 1362789, depth: 3, leaf buckets: 10352, nodes: 10009010 
    Average node length: 5.14, total dup: 10008910, max dup: 160442 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.41, average data length: 0.00 
    Clustering factor: 1594993, ratio: 0.16 
    Fill distribution: 
         0 - 19% = 36 
        20 - 39% = 1177 
        40 - 59% = 5134 
        60 - 79% = 1801 
        80 - 99% = 2204 
 
XQS_1200_2000 (183) 
    Primary pointer page: 591, Index root page: 592 
    Total formats: 1, used formats: 1 
    Average record length: 78.64, total records: 11233386 
    Average version length: 82.53, total versions: 559455, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.60 
    Pointer pages: 119, data page slots: 193216 
    Data pages: 191904, average fill: 72% 
    Primary pages: 191720, secondary pages: 184, swept pages: 59049 
    Empty pages: 3080, full pages: 148880 
    Fill distribution: 
     0 - 19% = 5173 
    20 - 39% = 7287 
    40 - 59% = 16902 
    60 - 79% = 94142 
    80 - 99% = 68400 
 
    Index XQS_1200_2000_DOC_ID (1) 
    Root page: 1392123, depth: 3, leaf buckets: 13105, nodes: 11233386 
    Average node length: 5.30, total dup: 11124107, max dup: 641 
    Average key length: 2.08, compression ratio: 4.33 
    Average prefix length: 8.93, average data length: 0.07 
    Clustering factor: 2347930, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 109 
        40 - 59% = 9438 
        60 - 79% = 3459 
        80 - 99% = 99 
 
    Index XQS_1200_2000_RCV_ID (3) 
    Root page: 1406132, depth: 3, leaf buckets: 10384, nodes: 11233386 
    Average node length: 5.50, total dup: 10742587, max dup: 49 
    Average key length: 2.28, compression ratio: 3.95 
    Average prefix length: 8.77, average data length: 0.23 
    Clustering factor: 714225, ratio: 0.06 
    Fill distribution: 
         0 - 19% = 173 
        20 - 39% = 831 
        40 - 59% = 2541 
        60 - 79% = 1842 
        80 - 99% = 4997 
 
    Index XQS_1200_2000_SND_ID (2) 
    Root page: 1398660, depth: 3, leaf buckets: 14999, nodes: 11233386 
    Average node length: 6.02, total dup: 9805967, max dup: 67 
    Average key length: 2.80, compression ratio: 3.21 
    Average prefix length: 8.32, average data length: 0.68 
    Clustering factor: 2364374, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 4 
        20 - 39% = 150 
        40 - 59% = 11031 
        60 - 79% = 3678 
        80 - 99% = 136 
 
    Index XQS_1200_2000_WORKER_ID (0) 
    Root page: 1386233, depth: 3, leaf buckets: 10717, nodes: 11233386 
    Average node length: 5.22, total dup: 11233286, max dup: 203297 
    Average key length: 2.00, compression ratio: 1.20 
    Average prefix length: 2.40, average data length: 0.00 
    Clustering factor: 703553, ratio: 0.06 
    Fill distribution: 
         0 - 19% = 100 
        20 - 39% = 820 
        40 - 59% = 4785 
        60 - 79% = 1491 
        80 - 99% = 3521 
 
XQS_2000_3300 (185) 
    Primary pointer page: 595, Index root page: 596 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index XQS_2000_3300_DOC_ID (1) 
    Root page: 1361775, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index XQS_2000_3300_RCV_ID (3) 
    Root page: 1361777, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index XQS_2000_3300_SND_ID (2) 
    Root page: 1361776, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index XQS_2000_3300_WORKER_ID (0) 
    Root page: 1361774, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
XQS_2100_3300 (186) 
    Primary pointer page: 597, Index root page: 598 
    Total formats: 1, used formats: 1 
    Average record length: 75.78, total records: 10084417 
    Average version length: 82.93, total versions: 951443, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.66 
    Pointer pages: 109, data page slots: 177592 
    Data pages: 177544, average fill: 71% 
    Primary pages: 177506, secondary pages: 38, swept pages: 36353 
    Empty pages: 635, full pages: 131798 
    Fill distribution: 
     0 - 19% = 1942 
    20 - 39% = 8888 
    40 - 59% = 22998 
    60 - 79% = 103993 
    80 - 99% = 39723 
 
    Index XQS_2100_3300_DOC_ID (1) 
    Root page: 1344708, depth: 3, leaf buckets: 11957, nodes: 10084417 
    Average node length: 5.18, total dup: 10055337, max dup: 2297 
    Average key length: 2.03, compression ratio: 4.43 
    Average prefix length: 8.97, average data length: 0.03 
    Clustering factor: 2058382, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 18 
        20 - 39% = 1337 
        40 - 59% = 7871 
        60 - 79% = 2049 
        80 - 99% = 682 
 
    Index XQS_2100_3300_RCV_ID (3) 
    Root page: 1355739, depth: 3, leaf buckets: 13936, nodes: 10084417 
    Average node length: 6.26, total dup: 8358661, max dup: 14 
    Average key length: 3.10, compression ratio: 2.90 
    Average prefix length: 8.07, average data length: 0.93 
    Clustering factor: 1531661, ratio: 0.15 
    Fill distribution: 
         0 - 19% = 209 
        20 - 39% = 3708 
        40 - 59% = 4804 
        60 - 79% = 2462 
        80 - 99% = 2753 
 
    Index XQS_2100_3300_SND_ID (2) 
    Root page: 1350071, depth: 3, leaf buckets: 12559, nodes: 10084417 
    Average node length: 5.44, total dup: 9639980, max dup: 105 
    Average key length: 2.28, compression ratio: 3.94 
    Average prefix length: 8.76, average data length: 0.24 
    Clustering factor: 2196086, ratio: 0.22 
    Fill distribution: 
         0 - 19% = 13 
        20 - 39% = 1305 
        40 - 59% = 8699 
        60 - 79% = 1853 
        80 - 99% = 689 
 
    Index XQS_2100_3300_WORKER_ID (0) 
    Root page: 987843, depth: 3, leaf buckets: 10521, nodes: 10084417 
    Average node length: 5.16, total dup: 10084317, max dup: 162591 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.41, average data length: 0.00 
    Clustering factor: 1611880, ratio: 0.16 
    Fill distribution: 
         0 - 19% = 37 
        20 - 39% = 1252 
        40 - 59% = 5297 
        60 - 79% = 1683 
        80 - 99% = 2252 
 
XQS_3300_3400 (187) 
    Primary pointer page: 599, Index root page: 600 
    Total formats: 1, used formats: 1 
    Average record length: 66.48, total records: 584627 
    Average version length: 68.84, total versions: 16629, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.90 
    Pointer pages: 5, data page slots: 8064 
    Data pages: 8064, average fill: 76% 
    Primary pages: 8064, secondary pages: 0, swept pages: 2029 
    Empty pages: 1, full pages: 8060 
    Fill distribution: 
     0 - 19% = 2 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 7720 
    80 - 99% = 342 
 
    Index XQS_3300_3400_DOC_ID (1) 
    Root page: 51296, depth: 3, leaf buckets: 735, nodes: 584627 
    Average node length: 5.94, total dup: 498097, max dup: 82 
    Average key length: 3.09, compression ratio: 2.91 
    Average prefix length: 8.06, average data length: 0.94 
    Clustering factor: 102674, ratio: 0.18 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 24 
        40 - 59% = 506 
        60 - 79% = 107 
        80 - 99% = 98 
 
    Index XQS_3300_3400_SND_ID (2) 
    Root page: 37679, depth: 3, leaf buckets: 755, nodes: 584627 
    Average node length: 6.15, total dup: 479736, max dup: 29 
    Average key length: 3.29, compression ratio: 2.74 
    Average prefix length: 7.89, average data length: 1.11 
    Clustering factor: 102727, ratio: 0.18 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 16 
        40 - 59% = 528 
        60 - 79% = 98 
        80 - 99% = 113 
 
    Index XQS_3300_3400_WORKER_ID (0) 
    Root page: 377587, depth: 2, leaf buckets: 546, nodes: 584627 
    Average node length: 4.86, total dup: 584527, max dup: 9431 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.41, average data length: 0.00 
    Clustering factor: 91210, ratio: 0.16 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 19 
        40 - 59% = 290 
        60 - 79% = 83 
        80 - 99% = 154 
 
ZDOC_DATA (170) 
    Primary pointer page: 565, Index root page: 566 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
ZDOC_LIST (169) 
    Primary pointer page: 563, Index root page: 564 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
ZINVNT_TURNOVER_LOG (171) 
    Primary pointer page: 567, Index root page: 568 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
ZPDISTR (174) 
    Primary pointer page: 573, Index root page: 574 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index ZPDISTR_ID (0) 
    Root page: 1504230, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
ZPSTORNED (175) 
    Primary pointer page: 575, Index root page: 576 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index ZPSTORNED_ID (0) 
    Root page: 1504229, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
ZQDISTR (172) 
    Primary pointer page: 569, Index root page: 570 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index ZQDISTR_ID (0) 
    Root page: 1504235, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index ZQDISTR_WARE_SNDOP_RCVOP (1) 
    Root page: 1504236, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
ZQSTORNED (173) 
    Primary pointer page: 571, Index root page: 572 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index ZQSTORNED_DOC_ID (1) 
    Root page: 1504232, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index ZQSTORNED_ID (0) 
    Root page: 1504231, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index ZQSTORNED_RCV_ID (3) 
    Root page: 1504234, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index ZQSTORNED_SND_ID (2) 
    Root page: 1504233, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
ZTMP_DEP_DOCS (168) 
    Primary pointer page: 561, Index root page: 562 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
ZTMP_SHOPPING_CART (167) 
    Primary pointer page: 559, Index root page: 560 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
Z_USED_VIEWS (144) 
    Primary pointer page: 512, Index root page: 513 
    Total formats: 1, used formats: 1 
    Average record length: 29.38, total records: 29 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 99.00, compression ratio: 3.37 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 16% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index Z_USED_VIEWS_UNQ (0) 
    Root page: 1510372, depth: 1, leaf buckets: 1, nodes: 29 
    Average node length: 15.17, total dup: 0, max dup: 0 
    Average key length: 14.14, compression ratio: 1.44 
    Average prefix length: 9.17, average data length: 11.17 
    Clustering factor: 1, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
Gstat completion time Thu Feb 15 07:19:29 2024

Record versions statistics, table

TABLE_NAME TOTAL_RECS TOTAL_VERS MAX_VERSIONS VERS_TO_RECS_PRC MAXV_TO_VERS_PRC
DOC_DATA 7665759 40825 1 0.0000 0.0000
DOC_LIST 2202482 22570 2 0.0000 0.0000
FB_ERRORS 2182 757 1 0.0000 0.0000
INVNT_SALDO 400 1200 3 300.0000 0.0000
INVNT_TURNOVER_LOG 80093 70045 1 0.0000 0.0000
MONEY_SALDO 49 207 9 400.0000 0.0000
MONEY_TURNOVER_LOG 1568 1476 1 0.0000 0.0000
PDISTR 814068 14526 2 0.0000 0.0000
PERF_SPLIT_0 152894 2091 1 0.0000 0.0000
PERF_SPLIT_1 137151 1586 1 0.0000 0.0000
PERF_SPLIT_2 140882 2435 1 0.0000 0.0000
PERF_SPLIT_3 151002 2790 1 0.0000 0.0000
PERF_SPLIT_4 161141 3702 1 0.0000 0.0000
PERF_SPLIT_5 145986 3018 1 0.0000 0.0000
PERF_SPLIT_6 151888 2259 1 0.0000 0.0000
PERF_SPLIT_7 161954 3969 1 0.0000 0.0000
PERF_SPLIT_8 152522 2673 1 0.0000 0.0000
PERF_SPLIT_9 147060 4662 1 0.0000 0.0000
PSTORNED 2059964 19814 1 0.0000 0.0000
SEMAPHORES 5 1 1 0.0000 100.0000
XQD_1000_1200 115140 32714 1 0.0000 0.0000
XQD_1000_3300 7023670 135438 1 0.0000 0.0000
XQD_1200_2000 12174130 145146 1 0.0000 0.0000
XQD_2000_3300 1188702 144806 1 0.0000 0.0000
XQD_2100_3300 794181 47074 1 0.0000 0.0000
XQD_3300_3400 8712237 145475 1 0.0000 0.0000
XQS_1000_1200 21125913 3217 1 0.0000 0.0000
XQS_1000_3300 10009010 989548 1 0.0000 0.0000
XQS_1200_2000 11233386 559455 1 0.0000 0.0000
XQS_2100_3300 10084417 951443 1 0.0000 0.0000
XQS_3300_3400 584627 16629 1 0.0000 0.0000

Record versions statistics, chart

Total records and versions, chart

Ratios versions / total_records and max_versions / total_versions

Database validation 


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

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

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

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

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