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

Hardware and OS info

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

Server and database settinfs 


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

Test configuration settings 

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

Test finish info 


FINISH_STATE                    NORMAL: TEST_TIME EXPIRED AT 2024-02-28 19:09:47
DTS_END                         2024-02-28 19:09:47.3840
FB_GDSCODE                      -1
FB_MNEMONA                      
STACK                           SP_CLIENT_ORDER(57:5) ==> SP_CHECK_TO_STOP_WORK(32:12) ==> SP_HALT_ON_ERROR(57:17)
IP                              ::1/49466
TRN_ID                          169007
ATT_ID                          581
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: 9139.29 21806 913929
customer order: creation 167.39 354 16739
customer order: refuse 13.94 428 1394
order to supplier: creation 43.67 1259 4367
order to supplier: removal 3.61 103274 361
invoice (draft): creation 43.45 3182 4345
invoice (draft): removal 53.56 830 5356
invoice accept: apply 39.21 21980 3921
invoice accept: cancel 48.18 778 4818
customer reserve: creation 3770.17 211 377017
customer reserve: removal 4654.34 62 465434
realization accept: apply 82.03 216 8203
realization accept: cancel 93.97 121 9397
payment from customer: creation 57.80 143 5780
payment from customer: removal 5.52 115 552
payment to supplier: creation 47.01 161 4701
payment to supplier: removal 3.41 116 341
service: total inventory turnovers 4.82 1128 482
service: total monetary turnovers 6.39 24 639
service: aggregate perf. data 0.79 19559 79
service: refresh index statistics 0.03 282176 3

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:02, from 28-02-2024 19:11:48 to 28-02-2024 19:11:50.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 2566
TEST_TIME 2 3046
TEST_TIME 3 3337
TEST_TIME 4 3154
TEST_TIME 5 3003
TEST_TIME 6 3656
TEST_TIME 7 4515
TEST_TIME 8 4695
TEST_TIME 9 4994
TEST_TIME 10 5423
TEST_TIME 11 5697
TEST_TIME 12 6256
TEST_TIME 13 6177
TEST_TIME 14 6285
TEST_TIME 15 6416
TEST_TIME 16 6600
TEST_TIME 17 6649
TEST_TIME 18 6659
TEST_TIME 19 6672
TEST_TIME 20 6703
TEST_TIME 21 6880
TEST_TIME 22 6980
TEST_TIME 23 7000
TEST_TIME 24 7187
TEST_TIME 25 7097
TEST_TIME 26 7119
TEST_TIME 27 7077
TEST_TIME 28 6944
TEST_TIME 29 7650
TEST_TIME 30 8649
TEST_TIME 31 9004
TEST_TIME 32 8923
TEST_TIME 33 8979
TEST_TIME 34 8951
TEST_TIME 35 8835
TEST_TIME 36 8822
TEST_TIME 37 8660
TEST_TIME 38 8753
TEST_TIME 39 8849
TEST_TIME 40 8746
TEST_TIME 41 8709
TEST_TIME 42 8674
TEST_TIME 43 8750
TEST_TIME 44 8758
TEST_TIME 45 8744
TEST_TIME 46 8736
TEST_TIME 47 8700
TEST_TIME 48 8566
TEST_TIME 49 8553
TEST_TIME 50 8601
TEST_TIME 51 8594
TEST_TIME 52 8565
TEST_TIME 53 8623
TEST_TIME 54 8626
TEST_TIME 55 8639
TEST_TIME 56 8672
TEST_TIME 57 8756
TEST_TIME 58 8714
TEST_TIME 59 8730
TEST_TIME 60 8875
TEST_TIME 61 9042
TEST_TIME 62 9157
TEST_TIME 63 9192
TEST_TIME 64 9161
TEST_TIME 65 9140
TEST_TIME 66 9086
TEST_TIME 67 9067
TEST_TIME 68 9011
TEST_TIME 69 9022
TEST_TIME 70 9037
TEST_TIME 71 8985
TEST_TIME 72 8911
TEST_TIME 73 9046
TEST_TIME 74 9076
TEST_TIME 75 9035
TEST_TIME 76 8995
TEST_TIME 77 8996
TEST_TIME 78 9127
TEST_TIME 79 9128
TEST_TIME 80 9157
TEST_TIME 81 9117
TEST_TIME 82 9294
TEST_TIME 83 9326
TEST_TIME 84 9332
TEST_TIME 85 9317
TEST_TIME 86 9310
TEST_TIME 87 9359
TEST_TIME 88 9383
TEST_TIME 89 9381
TEST_TIME 90 9306
TEST_TIME 91 9272
TEST_TIME 92 9249
TEST_TIME 93 9236
TEST_TIME 94 9210
TEST_TIME 95 9160
TEST_TIME 96 9171
TEST_TIME 97 9187
TEST_TIME 98 9140
TEST_TIME 99 9088
TEST_TIME 100 9153

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:03, from 28-02-2024 19:11:51 to 28-02-2024 19:11:54.

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 1261247 1261247 0 0.00 0 18308 7 0 0
doc_list_biud 1261247 1261247 0 0.00 0 38385 29 0 0
sp_add_invoice_to_stock 4015 3921 94 2.34 57 204748 21981 0 94
sp_cancel_adding_invoice 4818 4818 0 0.00 5 54379 779 0 0
sp_cancel_client_order 1394 1394 0 0.00 5 25702 428 0 0
sp_cancel_customer_reserve 465434 465434 0 0.00 0 37401 62 0 0
sp_cancel_pay_from_customer 552 552 0 0.00 3 12093 115 0 0
sp_cancel_pay_to_supplier 341 341 0 0.00 2 8877 117 0 0
sp_cancel_supplier_invoice 5369 5356 13 0.24 2 38398 830 0 13
sp_cancel_supplier_order 361 361 0 0.00 7 1076331 103275 0 0
sp_cancel_write_off 9397 9397 0 0.00 1 15239 122 0 0
sp_client_order 16739 16739 0 0.00 3 23232 355 0 0
sp_customer_reserve 377017 377017 0 0.00 0 55377 212 0 0
sp_fill_shopping_cart 25444 25444 0 0.00 1 8206 33 0 0
sp_fill_shopping_cart_clo_res 377000 377000 0 0.00 0 23447 18 0 0
sp_get_clo_for_invoice 3903 3903 0 0.00 0 27596 326 0 0
sp_kill_cost_storno 15108 15108 0 0.00 0 8864 62 0 0
sp_kill_qstorno_ret_qs2qd 945982 945982 0 0.00 0 38379 34 0 0
sp_kill_qty_storno 498866 498866 0 0.00 0 38383 73 0 0
sp_lock_selected_doc 16760 16760 0 0.00 0 8615 7 0 0
sp_make_cost_storno 22587 22587 0 0.00 0 13277 67 0 0
sp_multiply_rows_for_pdistr 22587 22587 0 0.00 0 18306 35 0 0
sp_multiply_rows_for_qdistr 16739 16739 0 0.00 0 16613 170 0 0
sp_pay_from_customer 5780 5780 0 0.00 4 18312 143 0 0
sp_pay_to_supplier 4701 4701 0 0.00 5 14082 161 0 0
sp_payment_common 10481 10481 0 0.00 1 11004 37 0 0
sp_qd_handle_on_cancel_clo 1394 1394 0 0.00 0 25694 380 0 0
sp_qd_handle_on_invoice_upd_sts 8721 8721 0 0.00 0 28948 318 0 0
sp_qd_handle_on_reserve_upd_sts 8203 8203 0 0.00 0 36604 67 0 0
sp_reserve_write_off 8203 8203 0 0.00 5 36641 216 0 0
sp_supplier_invoice 4345 4345 0 0.00 6 75295 3182 0 0
sp_supplier_order 4367 4367 0 0.00 5 38723 1260 0 0
srv_aggregate_perf_data 79 79 0 0.00 1853 252118 19559 0 0
srv_fill_mon_cache_memory 56 56 0 0.00 1193 105833 39348 0 0
srv_find_qd_qs_mism 874380 874380 0 0.00 0 13399 6 0 0
srv_make_invnt_saldo 482 482 0 0.00 36 94538 1128 0 0
srv_make_money_saldo 639 639 0 0.00 1 790 25 0 0
srv_recalc_idx_stat 3 3 0 0.00 196178 380492 282177 0 0
t$perf-abend:sp_add_invoice_to_stock 94 94 0 0.00 0 0 0 0 0
t$perf-abend:sp_cancel_supplier_invoice 13 13 0 0.00 0 0 0 0 0
t$perf-norm:sp_add_invoice_to_stock 3922 3922 0 0.00 0 13687 179 0 0
t$perf-norm:sp_cancel_adding_invoice 328 328 0 0.00 0 5220 98 0 0
t$perf-norm:sp_cancel_client_order 1394 1394 0 0.00 0 14588 27 0 0
t$perf-norm:sp_cancel_customer_reserve 518 518 0 0.00 0 981 8 0 0
t$perf-norm:sp_cancel_pay_from_customer 552 552 0 0.00 0 1302 6 0 0
t$perf-norm:sp_cancel_pay_to_supplier 341 341 0 0.00 0 2158 9 0 0
t$perf-norm:sp_cancel_supplier_invoice 329 329 0 0.00 0 3844 34 0 0
t$perf-norm:sp_cancel_supplier_order 361 361 0 0.00 0 32984 1914 0 0
t$perf-norm:sp_cancel_write_off 831 831 0 0.00 0 2488 8 0 0
t$perf-norm:sp_client_order 16739 16739 0 0.00 0 7201 19 0 0
t$perf-norm:sp_customer_reserve 780 780 0 0.00 0 548 4 0 0
t$perf-norm:sp_pay_from_customer 5780 5780 0 0.00 0 6110 10 0 0
t$perf-norm:sp_pay_to_supplier 4701 4701 0 0.00 0 9874 12 0 0
t$perf-norm:sp_reserve_write_off 8203 8203 0 0.00 0 5553 11 0 0
t$perf-norm:sp_supplier_invoice 4345 4345 0 0.00 0 10950 17 0 0
t$perf-norm:sp_supplier_order 4367 4367 0 0.00 0 2792 18 0 0
t$perf-norm:srv_aggregate_perf_data 79 79 0 0.00 0 261 4 0 0
t$perf-norm:srv_fill_mon_cache_memory 56 56 0 0.00 0 111 4 0 0
t$perf-norm:srv_make_invnt_saldo 482 482 0 0.00 0 815 22 0 0
t$perf-norm:srv_make_money_saldo 639 639 0 0.00 0 2276 21 0 0
t$perf-norm:srv_recalc_idx_stat 3 3 0 0.00 2 5 3 0 0
v_add_invoice_to_stock 7994 7806 188 2.35 0 5660 21 0 188
v_all_customers 31106 31106 0 0.00 0 20 1 0 0
v_all_suppliers 24992 24992 0 0.00 0 20 1 0 0
v_all_wares 33478 33478 0 0.00 0 22 1 0 0
v_cancel_adding_invoice 656 656 0 0.00 0 469 7 0 0
v_cancel_client_order 2788 2788 0 0.00 0 8737 10 0 0
v_cancel_customer_prepayment 1104 1104 0 0.00 0 5148 10 0 0
v_cancel_customer_reserve 1036 1036 0 0.00 0 3953 15 0 0
v_cancel_payment_to_supplier 682 682 0 0.00 0 3542 13 0 0
v_cancel_supplier_invoice 684 658 26 3.80 0 2452 19 0 26
v_cancel_supplier_order 722 722 0 0.00 0 5666 13 0 0
v_cancel_write_off 1662 1662 0 0.00 0 3558 17 0 0
v_max_id_clo_ord 4367 4367 0 0.00 0 1050 2 0 0
v_max_id_clo_res 780 780 0 0.00 0 4400 18 0 0
v_max_id_ord_sup 4338 4338 0 0.00 0 7406 3 0 0
v_max_non_paid_invoice 910 910 0 0.00 0 632 4 0 0
v_max_non_paid_realizn 2802 2802 0 0.00 0 4159 7 0 0
v_min_id_clo_ord 4367 4367 0 0.00 0 2165 7 0 0
v_min_id_clo_res 780 780 0 0.00 0 57 1 0 0
v_min_id_ord_sup 4338 4338 0 0.00 0 7352 9 0 0
v_min_non_paid_invoice 4701 4701 0 0.00 0 9360 25 0 0
v_min_non_paid_realizn 5780 5780 0 0.00 0 10994 33 0 0
v_our_firm 8328 8328 0 0.00 0 90 1 0 0
v_reserve_write_off 16406 16406 0 0.00 0 8637 10 0 0
x_lock_depdocs_on_canc_invoice 9845 9845 0 0.00 0 29915 141 0 0
x_lock_depdocs_on_canc_sup_ord 361 361 0 0.00 0 14106 415 0 0
x_make_qstorno_1000_1200 4367 4367 0 0.00 1 38714 1178 0 0
x_make_qstorno_1200_2000 4345 4345 0 0.00 3 75289 3065 0 0
x_make_qstorno_2100_3300 377017 377017 0 0.00 0 52989 191 0 0

Completed "Performance in DETAILS". Done for 00:00:05, from 28-02-2024 19:11:55 to 28-02-2024 19:12:00.

Memory consumption, metadata cache, attachments activity 

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


Page cache type: shared, buffers: 1000000 for all connections, with total size: 8192000000
measurement_dts measurement duration ms page cache memo used memo used, total memo allocated, total metadata cache metadata cache percent of total total attachments cnt active attachments cnt running statements cnt stalled statements cnt memo used by attachments memo used by transactions memo used by statements
17:09:50 10 8192000000 8800648528 8812658688 6649840 0.081 3 1 2 0 6750768 58144 42784
17:10:51 34782 8192000000 9899137120 10210828288 988587312 10.768 100 95 190 0 1018983104 5574048 24821744
17:12:33 18069 8192000000 9947065424 10268168192 1032048064 11.188 100 92 184 0 1063897728 8359296 23490368
17:13:56 12961 8192000000 9975790160 10302873600 1059241488 11.449 100 88 176 0 1091915424 10180560 22493376
17:15:16 13955 8192000000 10022738320 10369327104 1106622944 11.900 100 74 148 0 1135211296 10759280 17829072
17:16:34 8103 8192000000 10057027040 10413445120 1147225136 12.283 100 74 145 0 1176322816 12383952 16713728
17:17:43 2753 8192000000 10113294064 10481422336 1202313472 12.798 100 67 134 1 1228987632 11854928 14819232
17:18:47 1804 8192000000 10161427104 10534027264 1245645024 13.198 100 81 162 0 1276882560 12749744 18487792
17:19:51 1100 8192000000 10193289824 10573799424 1279551312 13.509 100 91 183 2 1313491072 13787936 20151824
17:20:53 1210 8192000000 10214734880 10602778624 1301628928 13.710 100 85 170 1 1333489008 14113120 17746960
17:21:56 36807 8192000000 10191124816 10605072384 1305789376 13.748 100 39 76 0 1320828576 6584720 8454480
17:23:37 5466 8192000000 10198014752 10616090624 1315103664 13.832 100 24 48 0 1327516480 7225280 5187536
17:24:44 16602 8192000000 10199694624 10622795776 1324672720 13.919 100 10 20 0 1332517728 5991104 1853904
17:26:02 9342 8192000000 10213206448 10632343552 1327277744 13.943 100 11 22 0 1335424848 5889568 2257536
17:27:13 20752 8192000000 10229968432 10640375808 1328646304 13.955 100 50 100 1 1346375936 6461744 11267888
17:28:34 7094 8192000000 10217705584 10638622720 1317104880 13.850 99 39 79 1 1332741504 6474688 9161936
17:29:44 20948 8192000000 10206164048 10620485632 1304306928 13.734 99 36 72 0 1319695968 6903472 8485568
17:31:25 10544 8192000000 10222295328 10633207808 1322542736 13.900 100 35 70 0 1339012480 8241712 8228032
17:32:50 35687 8192000000 10246418320 10661990400 1333538048 13.999 99 42 82 0 1353929440 9908512 10482880
17:34:33 26990 8192000000 10242250096 10662854656 1322243168 13.897 98 43 81 0 1345494352 13165072 10086112
17:36:06 36360 8192000000 10242055904 10661134336 1329206768 13.960 99 25 48 2 1348011136 12978864 5825504
17:37:56 7425 8192000000 10230698080 10637983744 1315778480 13.838 100 54 108 1 1343814608 15532928 12503200
17:39:35 6192 8192000000 10233151856 10638209024 1305290480 13.743 99 51 100 1 1336006048 18737376 11978192
17:40:53 34793 8192000000 10227040992 10642755584 1320018208 13.877 100 45 90 0 1350031760 19061424 10952128
17:42:37 4948 8192000000 10207560208 10597294080 1279731984 13.511 99 65 127 2 1312782048 18031040 15019024
17:43:49 3936 8192000000 10235735872 10635669504 1309135520 13.778 100 54 108 0 1339823584 17633792 13054272
17:45:02 4318 8192000000 10253855792 10654887936 1326458448 13.935 100 66 131 0 1363695648 21165616 16071584
17:46:22 22450 8192000000 10265120048 10672693248 1333093184 13.995 100 44 88 1 1367192528 23608512 10490832
17:48:02 1190 8192000000 10306314352 10702176256 1360555728 14.242 100 85 169 1 1409768816 29200912 20012176
17:49:08 10455 8192000000 10305699920 10713350144 1367735360 14.307 100 60 118 0 1413782768 31316176 14731232
17:50:24 9453 8192000000 10329818480 10742833152 1389169776 14.498 100 59 118 0 1439023072 35179376 14673920
17:51:41 6692 8192000000 10334139856 10754322432 1391391472 14.518 100 54 106 0 1443324736 38169648 13763616
17:52:54 11378 8192000000 10335564144 10754269184 1391617952 14.520 100 51 101 0 1443534576 38993712 12922912
17:54:09 34690 8192000000 10331172992 10758074368 1383783824 14.450 99 34 68 0 1430226304 37201184 9241296
17:56:17 9923 8192000000 10342791056 10771578880 1395499888 14.555 100 34 67 0 1446837088 42295920 9041280
17:57:33 33583 8192000000 10337535456 10785431552 1389187104 14.499 100 24 48 0 1453598144 56923760 7487280
17:59:13 54019 8192000000 10304304896 10766053376 1385773008 14.468 100 14 28 0 1431277392 41724944 3779440
18:01:13 44987 8192000000 10291123824 10741968896 1389478976 14.501 100 21 38 1 1402783840 8273632 5031232
18:02:59 28242 8192000000 10315532336 10751524864 1396060464 14.560 100 42 85 0 1412776432 7124128 9591840
18:04:30 34461 8192000000 10314418912 10759819264 1399916016 14.594 100 38 74 0 1419935376 11677040 8342320
18:06:05 100897 8192000000 10317572496 10772426752 1406094736 14.649 100 36 72 0 1427269792 12925648 8249408
18:09:03 46731 8192000000 10298925760 10757152768 1394924896 14.550 100 21 40 1 1410597680 11926144 3746640
18:11:10 27306 8192000000 10330232656 10773884928 1409708576 14.681 100 31 61 1 1427983680 10778480 7496624
18:12:38 42544 8192000000 10294896608 10756358144 1393072032 14.533 99 9 18 0 1407749920 12800912 1876976
18:14:22 41694 8192000000 10307937872 10765737984 1404136624 14.632 100 14 27 0 1418425632 11538288 2750720
18:16:04 28397 8192000000 10293655632 10748657664 1342465648 14.080 96 26 53 3 1359851568 11305408 6080512
18:17:37 60768 8192000000 10283663872 10742722560 1356389536 14.205 97 36 73 1 1373672624 8886960 8396128
18:19:46 13931 8192000000 10263337264 10720489472 1359876816 14.236 99 21 42 1 1371648768 7193392 4578560
18:21:02 75458 8192000000 10260637344 10729758720 1340363152 14.061 97 13 26 0 1356234048 12864640 3006256
18:23:26 21783 8192000000 10286194016 10739359744 1359865776 14.236 98 20 40 1 1374425760 9843488 4716496
18:24:53 56258 8192000000 10287760048 10747879424 1371646256 14.342 99 25 50 0 1394626320 17259792 5720272
18:26:58 8957 8192000000 10276814192 10710155264 1348379376 14.133 97 61 117 0 1372476960 10678112 13419472
18:28:11 36298 8192000000 10262378192 10695352320 1320378016 13.880 98 21 42 0 1342488384 16942992 5167376
18:29:59 56048 8192000000 10247421760 10704756736 1303939904 13.731 97 11 23 0 1331471952 24724864 2807184
18:31:55 29710 8192000000 10239311424 10671579136 1285361488 13.562 96 17 34 0 1297146576 8011168 3773920
18:33:27 15142 8192000000 10271856448 10692079616 1342258336 14.078 100 68 136 0 1367361184 9878864 15223984
18:35:08 104864 8192000000 10237189200 10673479680 1314001744 13.822 99 47 94 0 1340280144 16137120 10141280
18:37:56 36150 8192000000 10242139040 10682671104 1336930464 14.030 100 20 40 0 1352088640 10359136 4799040
18:39:38 39945 8192000000 10257810080 10708426752 1344651536 14.099 99 9 18 0 1362682848 15700000 2331312
18:41:19 78802 8192000000 10284672928 10744426496 1380945680 14.425 100 18 36 0 1396826240 11544944 4335616
18:43:51 66416 8192000000 10291730752 10741874688 1372453088 14.349 99 17 34 0 1390226464 13970880 3802496
18:46:00 65438 8192000000 10299916672 10758406144 1376624432 14.386 99 21 42 0 1398307856 16703392 4980032
18:48:07 47672 8192000000 10301400512 10752413696 1368739360 14.316 98 27 52 1 1384968832 10790784 5438688
18:49:58 77678 8192000000 10317345856 10773049344 1380248576 14.419 98 19 38 1 1402258656 17781216 4228864
18:52:18 65730 8192000000 10314853296 10761388032 1384401936 14.456 99 21 42 1 1400750144 11766928 4581280
18:54:29 68699 8192000000 10319326880 10767806464 1386337216 14.473 98 24 49 1 1403767696 11700624 5729856
18:56:42 47381 8192000000 10324924720 10784325632 1405582992 14.645 100 30 58 0 1426520064 14895024 6042048
18:58:35 105832 8192000000 10324070864 10781618176 1412572272 14.707 100 21 42 0 1433654656 16417760 4664624
19:01:24 29772 8192000000 10311442448 10763231232 1358195584 14.221 96 29 54 0 1373367664 9044560 6127520
19:02:57 66952 8192000000 10295530800 10759036928 1375387488 14.375 98 18 36 0 1394800560 15403712 4009360
19:05:08 70232 8192000000 10283013040 10740142080 1349335200 14.141 97 11 22 0 1371304272 19227728 2741344
19:07:39 76310 8192000000 10313658368 10768982016 1394933472 14.550 100 19 38 0 1423200320 23323072 4943776

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:13, from 28-02-2024 19:12:02 to 28-02-2024 19:12:15.

Exceptions occured during test was in run

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

Completed "Exceptions occured during test was in run". Done for 00:00:02, from 28-02-2024 19:12:16 to 28-02-2024 19:12:18.

Content of mon$database and FB version 


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


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

Database statistics 

 
Database "/home/bases/oltp30-etalone.fdb" 
Gstat execution time Wed Feb 28 19:12:19 2024 
 
Database header page information: 
    Flags            0 
    Generation        88068 
    System Change Number    0 
    Page size        8192 
    ODS version        12.0 
    Oldest transaction    166118 
    Oldest active        169133 
    Oldest snapshot        169133 
    Next transaction    169134 
    Sequence number        0 
    Next attachment ID    699 
    Implementation        HW=AMD/Intel/x64 little-endian OS=Linux CC=gcc 
    Shadow count        0 
    Page buffers        0 
    Next header page    0 
    Database dialect    3 
    Creation date        Apr 3, 2020 16:41:55 
    Attributes        force write 
 
    Variable header data: 
    Sweep interval:        0 
    Unrecognized option 11, length 16 
    *END* 
 
 
Database file sequence: 
File /home/bases/oltp30-etalone.fdb is the only file 
 
Analyzing database pages ... 
AGENTS (150) 
    Primary pointer page: 496, Index root page: 497 
    Total formats: 1, used formats: 1 
    Average record length: 33.60, total records: 50 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 344.00, compression ratio: 10.24 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 31% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 1 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index AGENTS_ID_DESC (2) 
    Root page: 1504311, depth: 1, leaf buckets: 1, nodes: 50 
    Average node length: 11.82, total dup: 0, max dup: 0 
    Average key length: 10.80, compression ratio: 0.83 
    Average prefix length: 1.18, average data length: 7.82 
    Clustering factor: 1, ratio: 0.02 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index AGENTS_IS_OUR_FIRM (4) 
    Root page: 1504313, depth: 1, leaf buckets: 1, nodes: 50 
    Average node length: 3.08, total dup: 48, max dup: 48 
    Average key length: 2.04, compression ratio: 0.50 
    Average prefix length: 0.96, average data length: 0.06 
    Clustering factor: 1, ratio: 0.02 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index AGENTS_IS_SUPPLIER (3) 
    Root page: 1504312, depth: 1, leaf buckets: 1, nodes: 50 
    Average node length: 3.08, total dup: 48, max dup: 44 
    Average key length: 2.04, compression ratio: 0.54 
    Average prefix length: 1.04, average data length: 0.06 
    Clustering factor: 1, ratio: 0.02 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index AGENTS_NAME_UNQ (1) 
    Root page: 1504310, depth: 1, leaf buckets: 1, nodes: 50 
    Average node length: 17.20, total dup: 0, max dup: 0 
    Average key length: 15.88, compression ratio: 0.92 
    Average prefix length: 1.42, average data length: 13.20 
    Clustering factor: 1, ratio: 0.02 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PK_AGENTS (0) 
    Root page: 1504309, depth: 1, leaf buckets: 1, nodes: 50 
    Average node length: 11.82, total dup: 0, max dup: 0 
    Average key length: 10.80, compression ratio: 0.83 
    Average prefix length: 1.18, average data length: 7.82 
    Clustering factor: 1, ratio: 0.02 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
BUSINESS_OPS (154) 
    Primary pointer page: 504, Index root page: 505 
    Total formats: 1, used formats: 1 
    Average record length: 108.20, total records: 20 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1235.00, compression ratio: 11.41 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 31% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 1 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index BO_UNIT_UNQ (1) 
    Root page: 1504242, depth: 1, leaf buckets: 1, nodes: 20 
    Average node length: 18.25, total dup: 0, max dup: 0 
    Average key length: 17.20, compression ratio: 1.24 
    Average prefix length: 7.05, average data length: 14.25 
    Clustering factor: 1, ratio: 0.05 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index BUSINESS_OPS_PREDICT_PRIOR (3) 
    Root page: 1504244, depth: 1, leaf buckets: 1, nodes: 20 
    Average node length: 5.40, total dup: 0, max dup: 0 
    Average key length: 4.35, compression ratio: 0.67 
    Average prefix length: 1.20, average data length: 1.70 
    Clustering factor: 1, ratio: 0.05 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index BUSINESS_OPS_RND_WGTH (2) 
    Root page: 1504243, depth: 1, leaf buckets: 1, nodes: 20 
    Average node length: 4.30, total dup: 6, max dup: 3 
    Average key length: 3.25, compression ratio: 0.72 
    Average prefix length: 1.35, average data length: 1.00 
    Clustering factor: 1, ratio: 0.05 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index RDB$1 (0) 
    Root page: 1504241, depth: 1, leaf buckets: 1, nodes: 20 
    Average node length: 5.20, total dup: 0, max dup: 0 
    Average key length: 4.15, compression ratio: 0.65 
    Average prefix length: 1.10, average data length: 1.60 
    Clustering factor: 1, ratio: 0.05 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
DOC_DATA (139) 
    Primary pointer page: 474, Index root page: 475 
    Total formats: 1, used formats: 1 
    Average record length: 47.43, total records: 7661059 
    Average version length: 48.17, total versions: 74192, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 64.00, compression ratio: 1.35 
    Pointer pages: 54, data page slots: 86656 
    Data pages: 86656, average fill: 71% 
    Primary pages: 86656, secondary pages: 0, swept pages: 26174 
    Empty pages: 7, full pages: 54056 
    Fill distribution: 
     0 - 19% = 24 
    20 - 39% = 228 
    40 - 59% = 3558 
    60 - 79% = 82832 
    80 - 99% = 14 
 
    Index DOC_DATA_DOC_WARE_UNQ (0) 
    Root page: 1510614, depth: 3, leaf buckets: 23081, nodes: 7661059 
    Average node length: 18.85, total dup: 0, max dup: 0 
    Average key length: 15.86, compression ratio: 1.70 
    Average prefix length: 14.14, average data length: 12.86 
    Clustering factor: 1683588, ratio: 0.22 
    Fill distribution: 
         0 - 19% = 314 
        20 - 39% = 2090 
        40 - 59% = 3787 
        60 - 79% = 2605 
        80 - 99% = 14285 
 
    Index DOC_DATA_ID_DESC (1) 
    Root page: 1528118, depth: 3, leaf buckets: 13405, nodes: 7661059 
    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: 1506602, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 1724 
        40 - 59% = 1797 
        60 - 79% = 1237 
        80 - 99% = 8647 
 
    Index FK_DOC_DATA_DOC_LIST (2) 
    Root page: 1546711, depth: 3, leaf buckets: 8258, nodes: 7661059 
    Average node length: 6.59, total dup: 5758723, max dup: 49 
    Average key length: 3.61, compression ratio: 2.50 
    Average prefix length: 7.64, average data length: 1.36 
    Clustering factor: 1499810, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 113 
        20 - 39% = 1113 
        40 - 59% = 1197 
        60 - 79% = 1017 
        80 - 99% = 4818 
 
DOC_LIST (138) 
    Primary pointer page: 472, Index root page: 473 
    Total formats: 1, used formats: 1 
    Average record length: 56.37, total records: 2193585 
    Average version length: 34.90, total versions: 78587, max versions: 3 
    Average fragment length: 7.75, total fragments: 4, max fragments: 1 
    Average unpacked length: 84.00, compression ratio: 1.49 
    Pointer pages: 18, data page slots: 28248 
    Data pages: 28248, average fill: 72% 
    Primary pages: 28242, secondary pages: 6, swept pages: 10998 
    Empty pages: 6, full pages: 17388 
    Fill distribution: 
     0 - 19% = 30 
    20 - 39% = 187 
    40 - 59% = 2278 
    60 - 79% = 25232 
    80 - 99% = 521 
 
    Index DOC_LIST_ID_DESC (1) 
    Root page: 1541130, depth: 3, leaf buckets: 4482, nodes: 2193585 
    Average node length: 11.41, total dup: 0, max dup: 0 
    Average key length: 8.45, compression ratio: 1.06 
    Average prefix length: 3.54, average data length: 5.46 
    Clustering factor: 686821, ratio: 0.31 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 967 
        40 - 59% = 749 
        60 - 79% = 790 
        80 - 99% = 1976 
 
    Index DOC_LIST_WORKER_OPTYPE (2) 
    Root page: 1544376, depth: 3, leaf buckets: 2510, nodes: 2196193 
    Average node length: 4.97, total dup: 2195294, max dup: 20816 
    Average key length: 2.01, compression ratio: 4.47 
    Average prefix length: 8.99, average data length: 0.01 
    Clustering factor: 1228800, ratio: 0.56 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 333 
        40 - 59% = 1536 
        60 - 79% = 472 
        80 - 99% = 168 
 
    Index FK_DOC_LIST_AGENTS (3) 
    Root page: 1545909, depth: 3, leaf buckets: 2060, nodes: 2193585 
    Average node length: 4.97, total dup: 2193535, max dup: 130042 
    Average key length: 2.01, compression ratio: 4.48 
    Average prefix length: 8.99, average data length: 0.01 
    Clustering factor: 1044008, ratio: 0.48 
    Fill distribution: 
         0 - 19% = 8 
        20 - 39% = 196 
        40 - 59% = 1013 
        60 - 79% = 53 
        80 - 99% = 790 
 
    Index PK_DOC_LIST (0) 
    Root page: 1538187, depth: 3, leaf buckets: 4269, nodes: 2193585 
    Average node length: 11.41, total dup: 0, max dup: 0 
    Average key length: 8.45, compression ratio: 1.06 
    Average prefix length: 3.54, average data length: 5.46 
    Clustering factor: 686821, ratio: 0.31 
    Fill distribution: 
         0 - 19% = 96 
        20 - 39% = 601 
        40 - 59% = 561 
        60 - 79% = 906 
        80 - 99% = 2105 
 
DOC_STATES (149) 
    Primary pointer page: 494, Index root page: 495 
    Total formats: 1, used formats: 1 
    Average record length: 67.50, total records: 4 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 650.00, compression ratio: 9.63 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 4% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index DOC_STATES_MCODE_UNQ (1) 
    Root page: 1504315, depth: 1, leaf buckets: 1, nodes: 4 
    Average node length: 17.75, total dup: 0, max dup: 0 
    Average key length: 16.50, compression ratio: 1.08 
    Average prefix length: 4.00, average data length: 13.75 
    Clustering factor: 1, ratio: 0.25 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index DOC_STATES_NAME_UNQ (2) 
    Root page: 1504316, depth: 1, leaf buckets: 1, nodes: 4 
    Average node length: 33.25, total dup: 0, max dup: 0 
    Average key length: 32.00, compression ratio: 0.99 
    Average prefix length: 2.50, average data length: 29.25 
    Clustering factor: 1, ratio: 0.25 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PK_DOC_STATES (0) 
    Root page: 1504314, depth: 1, leaf buckets: 1, nodes: 4 
    Average node length: 4.75, total dup: 0, max dup: 0 
    Average key length: 3.50, compression ratio: 0.86 
    Average prefix length: 1.50, average data length: 1.50 
    Clustering factor: 1, ratio: 0.25 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
FB_ERRORS (155) 
    Primary pointer page: 506, Index root page: 507 
    Total formats: 2, used formats: 2 
    Average record length: 54.76, total records: 2182 
    Average version length: 79.61, total versions: 757, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 270.43, compression ratio: 4.94 
    Pointer pages: 1, data page slots: 40 
    Data pages: 40, average fill: 70% 
    Primary pages: 40, secondary pages: 0, swept pages: 0 
    Empty pages: 7, full pages: 32 
    Fill distribution: 
     0 - 19% = 7 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 7 
    80 - 99% = 26 
 
    Index FB_ERRORS_GDS_CODE (0) 
    Root page: 382, depth: 2, leaf buckets: 2, nodes: 2182 
    Average node length: 4.40, total dup: 756, max dup: 1 
    Average key length: 2.67, compression ratio: 1.87 
    Average prefix length: 4.33, average data length: 0.67 
    Clustering factor: 1515, ratio: 0.69 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 0 
        40 - 59% = 1 
        60 - 79% = 1 
        80 - 99% = 0 
 
INVNT_SALDO (145) 
    Primary pointer page: 486, Index root page: 487 
    Total formats: 2, used formats: 1 
    Average record length: 82.56, total records: 400 
    Average version length: 23.00, total versions: 236691, max versions: 615 
    Average fragment length: 2.00, total fragments: 39, max fragments: 1 
    Average unpacked length: 104.00, compression ratio: 1.26 
    Pointer pages: 1, data page slots: 1304 
    Data pages: 1304, average fill: 90% 
    Primary pages: 11, secondary pages: 1293, swept pages: 0 
    Empty pages: 4, full pages: 1299 
    Fill distribution: 
     0 - 19% = 4 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 2 
    80 - 99% = 1298 
 
    Index PK_INVNT_SALDO (0) 
    Root page: 1510349, depth: 1, leaf buckets: 1, nodes: 400 
    Average node length: 11.22, total dup: 0, max dup: 0 
    Average key length: 10.22, compression ratio: 0.88 
    Average prefix length: 1.78, average data length: 7.22 
    Clustering factor: 326, ratio: 0.81 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 0 
        40 - 59% = 1 
        60 - 79% = 0 
        80 - 99% = 0 
 
INVNT_TURNOVER_LOG (153) 
    Primary pointer page: 502, Index root page: 503 
    Total formats: 1, used formats: 1 
    Average record length: 21.34, total records: 139002 
    Average version length: 68.28, total versions: 95576, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 88.00, compression ratio: 4.12 
    Pointer pages: 6, data page slots: 2592 
    Data pages: 2384, average fill: 70% 
    Primary pages: 2383, secondary pages: 1, swept pages: 0 
    Empty pages: 283, full pages: 1657 
    Fill distribution: 
     0 - 19% = 346 
    20 - 39% = 28 
    40 - 59% = 129 
    60 - 79% = 663 
    80 - 99% = 1218 
 
    Index INVNT_TURNOVER_LOG_WARE_DD_ID (0) 
    Root page: 1899610, depth: 3, leaf buckets: 392, nodes: 139002 
    Average node length: 12.91, total dup: 12723, max dup: 2 
    Average key length: 10.42, compression ratio: 2.59 
    Average prefix length: 19.49, average data length: 7.51 
    Clustering factor: 102210, ratio: 0.74 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 1 
        40 - 59% = 274 
        60 - 79% = 106 
        80 - 99% = 10 
 
MONEY_SALDO (141) 
    Primary pointer page: 478, Index root page: 479 
    Total formats: 1, used formats: 1 
    Average record length: 15.27, total records: 49 
    Average version length: 9.00, total versions: 17696, max versions: 938 
    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: 64 
    Data pages: 64, average fill: 89% 
    Primary pages: 2, secondary pages: 62, swept pages: 0 
    Empty pages: 1, full pages: 62 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 1 
    40 - 59% = 0 
    60 - 79% = 2 
    80 - 99% = 60 
 
    Index PK_MONEY_SALDO (0) 
    Root page: 1510361, depth: 1, leaf buckets: 1, nodes: 49 
    Average node length: 11.82, total dup: 0, max dup: 0 
    Average key length: 10.80, compression ratio: 0.83 
    Average prefix length: 1.18, average data length: 7.82 
    Clustering factor: 1, ratio: 0.02 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
MONEY_TURNOVER_LOG (140) 
    Primary pointer page: 476, Index root page: 477 
    Total formats: 1, used formats: 1 
    Average record length: 8.41, total records: 2419 
    Average version length: 43.31, total versions: 1971, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 58.00, compression ratio: 6.90 
    Pointer pages: 1, data page slots: 88 
    Data pages: 31, average fill: 72% 
    Primary pages: 30, secondary pages: 1, swept pages: 2 
    Empty pages: 3, full pages: 22 
    Fill distribution: 
     0 - 19% = 4 
    20 - 39% = 0 
    40 - 59% = 3 
    60 - 79% = 5 
    80 - 99% = 19 
 
    Index MONEY_TURNOVER_LOG_AGENT_OPTYPE (0) 
    Root page: 90163, depth: 2, leaf buckets: 3, nodes: 2419 
    Average node length: 4.11, total dup: 2321, max dup: 294 
    Average key length: 2.43, compression ratio: 7.82 
    Average prefix length: 18.61, average data length: 0.39 
    Clustering factor: 1213, ratio: 0.50 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 1 
        40 - 59% = 2 
        60 - 79% = 0 
        80 - 99% = 0 
 
MON_CACHE_MEMORY (165) 
    Primary pointer page: 526, Index root page: 527 
    Total formats: 2, used formats: 1 
    Average record length: 97.03, total records: 72 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 112.00, compression ratio: 1.15 
    Pointer pages: 1, data page slots: 2 
    Data pages: 2, average fill: 50% 
    Primary pages: 2, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 1 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 1 
 
    Index PK_MON_CACHE_MEMORY (0) 
    Root page: 1504215, depth: 1, leaf buckets: 1, nodes: 72 
    Average node length: 11.69, total dup: 0, max dup: 0 
    Average key length: 10.68, compression ratio: 0.84 
    Average prefix length: 1.31, average data length: 7.69 
    Clustering factor: 2, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
MON_LOG (162) 
    Primary pointer page: 520, Index root page: 521 
    Total formats: 2, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index MON_LOG_DTS (4) 
    Root page: 1504229, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index MON_LOG_GDSCODE (2) 
    Root page: 1504227, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index MON_LOG_ROWSET_DESC (1) 
    Root page: 1504226, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index MON_LOG_UNIT (3) 
    Root page: 1504228, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PK_MON_LOG (0) 
    Root page: 1504225, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
MON_LOG_TABLE_STATS (163) 
    Primary pointer page: 522, Index root page: 523 
    Total formats: 2, used formats: 1 
    Average record length: 67.13, total records: 30 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 611.00, compression ratio: 9.10 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 31% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 1 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index MON_LOG_TABLE_STATS_DTS (4) 
    Root page: 1504224, depth: 1, leaf buckets: 1, nodes: 30 
    Average node length: 3.50, total dup: 23, max dup: 4 
    Average key length: 2.47, compression ratio: 3.24 
    Average prefix length: 7.53, average data length: 0.47 
    Clustering factor: 1, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index MON_LOG_TABLE_STATS_GDSCODE (2) 
    Root page: 1504222, depth: 1, leaf buckets: 1, nodes: 30 
    Average node length: 2.00, total dup: 29, max dup: 29 
    Average key length: 1.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 1, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index MON_LOG_TABLE_STATS_ROWSET (1) 
    Root page: 1504221, depth: 1, leaf buckets: 1, nodes: 30 
    Average node length: 3.33, total dup: 29, max dup: 29 
    Average key length: 2.30, compression ratio: 3.91 
    Average prefix length: 8.70, average data length: 0.30 
    Clustering factor: 1, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index MON_LOG_TABLE_STATS_TN_UNIT (3) 
    Root page: 1504223, depth: 1, leaf buckets: 1, nodes: 30 
    Average node length: 12.90, total dup: 0, max dup: 0 
    Average key length: 11.87, compression ratio: 1.42 
    Average prefix length: 7.63, average data length: 9.20 
    Clustering factor: 1, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PK_MON_LOG_TABLE_STATS (0) 
    Root page: 1504220, depth: 1, leaf buckets: 1, nodes: 30 
    Average node length: 8.37, total dup: 0, max dup: 0 
    Average key length: 7.33, compression ratio: 1.23 
    Average prefix length: 4.63, average data length: 4.37 
    Clustering factor: 1, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
OPTYPES (136) 
    Primary pointer page: 468, Index root page: 469 
    Total formats: 2, used formats: 1 
    Average record length: 67.56, total records: 9 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 386.00, compression ratio: 5.71 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 9% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index OPTYPES_MCODE_UNQ (1) 
    Root page: 1544805, depth: 1, leaf buckets: 1, nodes: 9 
    Average node length: 8.56, total dup: 0, max dup: 0 
    Average key length: 6.89, compression ratio: 0.73 
    Average prefix length: 0.44, average data length: 4.56 
    Clustering factor: 1, ratio: 0.11 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PK_OPTYPES (0) 
    Root page: 1544804, depth: 1, leaf buckets: 1, nodes: 9 
    Average node length: 6.11, total dup: 0, max dup: 0 
    Average key length: 5.00, compression ratio: 0.60 
    Average prefix length: 0.89, average data length: 2.11 
    Clustering factor: 1, ratio: 0.11 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
PDISTR (146) 
    Primary pointer page: 488, Index root page: 489 
    Total formats: 1, used formats: 1 
    Average record length: 36.10, total records: 867526 
    Average version length: 25.49, total versions: 73479, max versions: 5 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 54.00, compression ratio: 1.50 
    Pointer pages: 6, data page slots: 8480 
    Data pages: 8480, average fill: 71% 
    Primary pages: 8462, secondary pages: 18, swept pages: 1467 
    Empty pages: 10, full pages: 7617 
    Fill distribution: 
     0 - 19% = 16 
    20 - 39% = 18 
    40 - 59% = 106 
    60 - 79% = 8060 
    80 - 99% = 280 
 
    Index PDISTR_AGENT_ID (2) 
    Root page: 1509308, depth: 2, leaf buckets: 958, nodes: 867526 
    Average node length: 4.88, total dup: 867477, max dup: 172019 
    Average key length: 2.01, compression ratio: 4.48 
    Average prefix length: 8.99, average data length: 0.01 
    Clustering factor: 93532, ratio: 0.11 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 137 
        40 - 59% = 537 
        60 - 79% = 222 
        80 - 99% = 61 
 
    Index PDISTR_SNDOP_RCVOP_SNDID_ASC (0) 
    Root page: 1508613, depth: 3, leaf buckets: 1062, nodes: 867526 
    Average node length: 5.89, total dup: 772333, max dup: 42 
    Average key length: 3.02, compression ratio: 7.28 
    Average prefix length: 21.09, average data length: 0.91 
    Clustering factor: 171198, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 68 
        40 - 59% = 647 
        60 - 79% = 120 
        80 - 99% = 226 
 
    Index PDISTR_SNDOP_RCVOP_SNDID_DESC (1) 
    Root page: 1509187, depth: 3, leaf buckets: 1093, nodes: 867526 
    Average node length: 5.89, total dup: 772333, max dup: 42 
    Average key length: 3.02, compression ratio: 7.28 
    Average prefix length: 21.09, average data length: 0.91 
    Clustering factor: 173106, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 176 
        40 - 59% = 576 
        60 - 79% = 105 
        80 - 99% = 236 
 
    Index PDISTR_WORKER_SND_ID (3) 
    Root page: 1510178, depth: 3, leaf buckets: 1212, nodes: 867526 
    Average node length: 5.97, total dup: 772333, max dup: 42 
    Average key length: 3.10, compression ratio: 5.48 
    Average prefix length: 16.01, average data length: 0.99 
    Clustering factor: 165152, ratio: 0.19 
    Fill distribution: 
         0 - 19% = 6 
        20 - 39% = 242 
        40 - 59% = 638 
        60 - 79% = 219 
        80 - 99% = 107 
 
PERF_AGG (158) 
    Primary pointer page: 512, Index root page: 513 
    Total formats: 1, used formats: 1 
    Average record length: 62.82, total records: 5437 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 2.60, total fragments: 62, max fragments: 1 
    Average unpacked length: 379.00, compression ratio: 6.03 
    Pointer pages: 1, data page slots: 96 
    Data pages: 94, average fill: 57% 
    Primary pages: 71, secondary pages: 23, swept pages: 53 
    Empty pages: 12, full pages: 63 
    Fill distribution: 
     0 - 19% = 23 
    20 - 39% = 1 
    40 - 59% = 0 
    60 - 79% = 70 
    80 - 99% = 0 
 
    Index PERF_AGG_UNQ (1) 
    Root page: 1504238, depth: 2, leaf buckets: 6, nodes: 5437 
    Average node length: 5.49, total dup: 0, max dup: 0 
    Average key length: 3.59, compression ratio: 10.02 
    Average prefix length: 34.39, average data length: 1.55 
    Clustering factor: 5066, ratio: 0.93 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 0 
        40 - 59% = 4 
        60 - 79% = 1 
        80 - 99% = 1 
 
    Index PK_PERF_AGG (0) 
    Root page: 1504233, depth: 2, leaf buckets: 10, nodes: 5437 
    Average node length: 11.11, total dup: 0, max dup: 0 
    Average key length: 9.21, compression ratio: 0.98 
    Average prefix length: 2.79, average data length: 6.21 
    Clustering factor: 148, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 1 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 7 
 
PERF_ESTIMATED (280) 
    Primary pointer page: 1504218, Index root page: 1504219 
    Total formats: 1, used formats: 1 
    Average record length: 39.10, total records: 77242 
    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: 752 
    Data pages: 752, average fill: 71% 
    Primary pages: 752, secondary pages: 0, swept pages: 0 
    Empty pages: 7, full pages: 744 
    Fill distribution: 
     0 - 19% = 8 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 744 
    80 - 99% = 0 
 
    Index PK_PERF_ESTIMATED (0) 
    Root page: 37167, depth: 2, leaf buckets: 98, nodes: 77242 
    Average node length: 10.18, total dup: 0, max dup: 0 
    Average key length: 8.19, compression ratio: 1.10 
    Average prefix length: 3.81, average data length: 5.19 
    Clustering factor: 2894, ratio: 0.04 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 0 
        40 - 59% = 1 
        60 - 79% = 0 
        80 - 99% = 97 
 
PERF_ISQL_STAT (156) 
    Primary pointer page: 508, Index root page: 509 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index PERF_ISQL_STAT_TRN (0) 
    Root page: 1504239, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
PERF_LOG (159) 
    Primary pointer page: 514, Index root page: 515 
    Total formats: 1, used formats: 1 
    Average record length: 110.57, total records: 72 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1691.00, compression ratio: 15.29 
    Pointer pages: 1, data page slots: 2 
    Data pages: 2, average fill: 56% 
    Primary pages: 2, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 1 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 1 
    40 - 59% = 0 
    60 - 79% = 1 
    80 - 99% = 0 
 
PERF_SPLIT_0 (281) 
    Primary pointer page: 573, Index root page: 574 
    Total formats: 1, used formats: 1 
    Average record length: 141.01, total records: 180427 
    Average version length: 154.65, total versions: 11750, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 12.03 
    Pointer pages: 5, data page slots: 5960 
    Data pages: 4448, average fill: 84% 
    Primary pages: 4448, secondary pages: 0, swept pages: 3 
    Empty pages: 144, full pages: 4253 
    Fill distribution: 
     0 - 19% = 147 
    20 - 39% = 23 
    40 - 59% = 14 
    60 - 79% = 10 
    80 - 99% = 4254 
 
PERF_SPLIT_1 (282) 
    Primary pointer page: 576, Index root page: 577 
    Total formats: 1, used formats: 1 
    Average record length: 137.65, total records: 165371 
    Average version length: 154.44, total versions: 14256, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 12.32 
    Pointer pages: 7, data page slots: 4984 
    Data pages: 3968, average fill: 86% 
    Primary pages: 3968, secondary pages: 0, swept pages: 2 
    Empty pages: 46, full pages: 3912 
    Fill distribution: 
     0 - 19% = 49 
    20 - 39% = 3 
    40 - 59% = 1 
    60 - 79% = 4 
    80 - 99% = 3911 
 
PERF_SPLIT_2 (283) 
    Primary pointer page: 578, Index root page: 579 
    Total formats: 1, used formats: 1 
    Average record length: 148.30, total records: 168844 
    Average version length: 151.66, total versions: 2975, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.44 
    Pointer pages: 5, data page slots: 4760 
    Data pages: 4096, average fill: 85% 
    Primary pages: 4096, secondary pages: 0, swept pages: 4 
    Empty pages: 84, full pages: 3987 
    Fill distribution: 
     0 - 19% = 86 
    20 - 39% = 9 
    40 - 59% = 6 
    60 - 79% = 10 
    80 - 99% = 3985 
 
PERF_SPLIT_3 (284) 
    Primary pointer page: 580, Index root page: 581 
    Total formats: 1, used formats: 1 
    Average record length: 127.83, total records: 191095 
    Average version length: 154.88, total versions: 29302, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 13.27 
    Pointer pages: 7, data page slots: 6576 
    Data pages: 4624, average fill: 87% 
    Primary pages: 4624, secondary pages: 0, swept pages: 4 
    Empty pages: 67, full pages: 4530 
    Fill distribution: 
     0 - 19% = 71 
    20 - 39% = 9 
    40 - 59% = 6 
    60 - 79% = 9 
    80 - 99% = 4529 
 
PERF_SPLIT_4 (285) 
    Primary pointer page: 582, Index root page: 583 
    Total formats: 1, used formats: 1 
    Average record length: 129.74, total records: 184752 
    Average version length: 154.90, total versions: 26314, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 13.07 
    Pointer pages: 7, data page slots: 6488 
    Data pages: 4472, average fill: 87% 
    Primary pages: 4472, secondary pages: 0, swept pages: 3 
    Empty pages: 58, full pages: 4384 
    Fill distribution: 
     0 - 19% = 62 
    20 - 39% = 7 
    40 - 59% = 9 
    60 - 79% = 10 
    80 - 99% = 4384 
 
PERF_SPLIT_5 (286) 
    Primary pointer page: 584, Index root page: 585 
    Total formats: 1, used formats: 1 
    Average record length: 144.74, total records: 181828 
    Average version length: 153.31, total versions: 7704, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.72 
    Pointer pages: 8, data page slots: 7552 
    Data pages: 4408, average fill: 85% 
    Primary pages: 4408, secondary pages: 0, swept pages: 2 
    Empty pages: 82, full pages: 4300 
    Fill distribution: 
     0 - 19% = 84 
    20 - 39% = 10 
    40 - 59% = 9 
    60 - 79% = 4 
    80 - 99% = 4301 
 
PERF_SPLIT_6 (287) 
    Primary pointer page: 586, Index root page: 587 
    Total formats: 1, used formats: 1 
    Average record length: 147.17, total records: 178395 
    Average version length: 151.54, total versions: 4623, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.52 
    Pointer pages: 6, data page slots: 5376 
    Data pages: 4280, average fill: 86% 
    Primary pages: 4280, secondary pages: 0, swept pages: 6 
    Empty pages: 43, full pages: 4221 
    Fill distribution: 
     0 - 19% = 47 
    20 - 39% = 4 
    40 - 59% = 4 
    60 - 79% = 3 
    80 - 99% = 4222 
 
PERF_SPLIT_7 (288) 
    Primary pointer page: 588, Index root page: 589 
    Total formats: 1, used formats: 1 
    Average record length: 124.15, total records: 198319 
    Average version length: 155.16, total versions: 34886, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 13.66 
    Pointer pages: 8, data page slots: 6808 
    Data pages: 4824, average fill: 86% 
    Primary pages: 4824, secondary pages: 0, swept pages: 2 
    Empty pages: 80, full pages: 4675 
    Fill distribution: 
     0 - 19% = 82 
    20 - 39% = 7 
    40 - 59% = 47 
    60 - 79% = 13 
    80 - 99% = 4675 
 
PERF_SPLIT_8 (289) 
    Primary pointer page: 590, Index root page: 591 
    Total formats: 1, used formats: 1 
    Average record length: 148.13, total records: 181105 
    Average version length: 152.34, total versions: 3811, 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: 7, data page slots: 6200 
    Data pages: 4392, average fill: 85% 
    Primary pages: 4392, secondary pages: 0, swept pages: 4 
    Empty pages: 81, full pages: 4284 
    Fill distribution: 
     0 - 19% = 82 
    20 - 39% = 12 
    40 - 59% = 5 
    60 - 79% = 11 
    80 - 99% = 4282 
 
PERF_SPLIT_9 (290) 
    Primary pointer page: 593, Index root page: 594 
    Total formats: 1, used formats: 1 
    Average record length: 150.65, total records: 178727 
    Average version length: 142.20, total versions: 681, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.26 
    Pointer pages: 6, data page slots: 4416 
    Data pages: 4272, average fill: 86% 
    Primary pages: 4271, secondary pages: 1, swept pages: 6 
    Empty pages: 25, full pages: 4232 
    Fill distribution: 
     0 - 19% = 28 
    20 - 39% = 3 
    40 - 59% = 6 
    60 - 79% = 5 
    80 - 99% = 4230 
 
PHRASES (143) 
    Primary pointer page: 482, Index root page: 483 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index PHRASES_ID_DESC (3) 
    Root page: 1510354, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PHRASES_NAME (2) 
    Root page: 1510353, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PHRASES_UNQ (1) 
    Root page: 1510352, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PK_PHRASES (0) 
    Root page: 1510351, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
PSTORNED (147) 
    Primary pointer page: 490, Index root page: 491 
    Total formats: 1, used formats: 1 
    Average record length: 51.81, total records: 2039636 
    Average version length: 52.96, total versions: 36134, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 70.00, compression ratio: 1.35 
    Pointer pages: 16, data page slots: 25424 
    Data pages: 25424, average fill: 69% 
    Primary pages: 25424, secondary pages: 0, swept pages: 12473 
    Empty pages: 412, full pages: 18610 
    Fill distribution: 
     0 - 19% = 787 
    20 - 39% = 630 
    40 - 59% = 1700 
    60 - 79% = 22011 
    80 - 99% = 296 
 
    Index PSTORNED_RCV_ID (1) 
    Root page: 1506186, depth: 3, leaf buckets: 2543, nodes: 2039636 
    Average node length: 5.44, total dup: 1902099, max dup: 1405 
    Average key length: 2.49, compression ratio: 3.61 
    Average prefix length: 8.58, average data length: 0.42 
    Clustering factor: 177837, ratio: 0.09 
    Fill distribution: 
         0 - 19% = 8 
        20 - 39% = 356 
        40 - 59% = 1610 
        60 - 79% = 272 
        80 - 99% = 297 
 
    Index PSTORNED_SND_ID (0) 
    Root page: 1504819, depth: 3, leaf buckets: 2751, nodes: 2039636 
    Average node length: 5.70, total dup: 1829468, max dup: 64 
    Average key length: 2.74, compression ratio: 3.28 
    Average prefix length: 8.36, average data length: 0.64 
    Clustering factor: 365689, ratio: 0.18 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 17 
        40 - 59% = 2511 
        60 - 79% = 199 
        80 - 99% = 24 
 
    Index PSTORNED_WORKER_ID (2) 
    Root page: 1507996, depth: 3, leaf buckets: 2114, nodes: 2039636 
    Average node length: 4.96, total dup: 2039536, max dup: 28394 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.41, average data length: 0.00 
    Clustering factor: 175698, ratio: 0.09 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 227 
        40 - 59% = 1122 
        60 - 79% = 391 
        80 - 99% = 372 
 
RULES_FOR_PDISTR (148) 
    Primary pointer page: 492, Index root page: 493 
    Total formats: 1, used formats: 1 
    Average record length: 17.00, total records: 4 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 334.00, compression ratio: 19.65 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 2% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index RULES_FOR_PDISTR_UNQ (0) 
    Root page: 1504317, depth: 1, leaf buckets: 1, nodes: 4 
    Average node length: 11.50, total dup: 0, max dup: 0 
    Average key length: 10.25, compression ratio: 0.88 
    Average prefix length: 1.50, average data length: 7.50 
    Clustering factor: 1, ratio: 0.25 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
RULES_FOR_QDISTR (137) 
    Primary pointer page: 470, Index root page: 471 
    Total formats: 1, used formats: 1 
    Average record length: 32.71, total records: 7 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 332.00, compression ratio: 10.15 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 4% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index RULES_FOR_QDISTR_RCVOP (1) 
    Root page: 1544803, depth: 1, leaf buckets: 1, nodes: 7 
    Average node length: 5.29, total dup: 2, max dup: 2 
    Average key length: 4.14, compression ratio: 0.72 
    Average prefix length: 1.43, average data length: 1.57 
    Clustering factor: 1, ratio: 0.14 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index RULES_FOR_QDISTR_UNQ (0) 
    Root page: 1544802, depth: 1, leaf buckets: 1, nodes: 7 
    Average node length: 10.14, total dup: 0, max dup: 0 
    Average key length: 8.86, compression ratio: 0.94 
    Average prefix length: 2.14, average data length: 6.14 
    Clustering factor: 1, ratio: 0.14 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
SEMAPHORES (152) 
    Primary pointer page: 500, Index root page: 501 
    Total formats: 1, used formats: 1 
    Average record length: 43.40, total records: 5 
    Average version length: 9.00, total versions: 1, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 346.00, compression ratio: 7.97 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 4% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index PK_SEMAPHORES (0) 
    Root page: 1504305, depth: 1, leaf buckets: 1, nodes: 5 
    Average node length: 12.40, total dup: 0, max dup: 0 
    Average key length: 11.00, compression ratio: 0.82 
    Average prefix length: 0.60, average data length: 8.40 
    Clustering factor: 1, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index SEMAPHORES_TASK_UNQ (1) 
    Root page: 1504306, depth: 1, leaf buckets: 1, nodes: 5 
    Average node length: 23.40, total dup: 0, max dup: 0 
    Average key length: 22.00, compression ratio: 1.07 
    Average prefix length: 4.20, average data length: 19.40 
    Clustering factor: 1, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
SETTINGS (135) 
    Primary pointer page: 466, Index root page: 467 
    Total formats: 1, used formats: 1 
    Average record length: 97.63, total records: 149 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1347.00, compression ratio: 13.80 
    Pointer pages: 1, data page slots: 3 
    Data pages: 3, average fill: 70% 
    Primary pages: 3, secondary pages: 0, swept pages: 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: 525, depth: 1, leaf buckets: 1, nodes: 149 
    Average node length: 14.66, total dup: 0, max dup: 0 
    Average key length: 13.55, compression ratio: 2.19 
    Average prefix length: 19.07, average data length: 10.66 
    Clustering factor: 48, ratio: 0.32 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 1 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index SETTINGS_MODE_CODE (0) 
    Root page: 1544806, depth: 1, leaf buckets: 1, nodes: 149 
    Average node length: 25.56, total dup: 0, max dup: 0 
    Average key length: 24.56, compression ratio: 1.63 
    Average prefix length: 18.58, average data length: 21.56 
    Clustering factor: 14, ratio: 0.09 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 0 
        40 - 59% = 1 
        60 - 79% = 0 
        80 - 99% = 0 
 
TMP$DEP_DOCS (129) 
    Primary pointer page: 454, Index root page: 455 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index TMP_DEP_DOCS_UNQ (0) 
    Root page: 1544810, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
TMP$IDX_RECALC (132) 
    Primary pointer page: 460, Index root page: 461 
    Total formats: 2, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index TMP_IDX_RECALC_IDX_NAME_UNQ (0) 
    Root page: 1544807, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
TMP$MON_LOG (133) 
    Primary pointer page: 462, Index root page: 463 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
TMP$MON_LOG_TABLE_STATS (134) 
    Primary pointer page: 464, Index root page: 465 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
TMP$PERF_EST_WHOLE (161) 
    Primary pointer page: 518, Index root page: 519 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
TMP$PERF_LOG (160) 
    Primary pointer page: 516, Index root page: 517 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index TMP$PERF_LOG_UNIT_TRN_DTS_END (0) 
    Root page: 1504230, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
TMP$PERF_MON (131) 
    Primary pointer page: 458, Index root page: 459 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
TMP$RESULT_SET (130) 
    Primary pointer page: 456, Index root page: 457 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index TMP_RESULT_SET_DOC (1) 
    Root page: 1544809, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index TMP_RESULT_SET_WARE_DOC (0) 
    Root page: 1544808, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
TMP$SHOPPING_CART (128) 
    Primary pointer page: 452, Index root page: 453 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index TMP_SHOPCART_UNQ (0) 
    Root page: 1544811, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
TPAUSE (166) 
    Primary pointer page: 528, Index root page: 529 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index RDB$PRIMARY2 (0) 
    Root page: 1504214, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
TRACE_STAT (157) 
    Primary pointer page: 510, Index root page: 511 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
WARES (142) 
    Primary pointer page: 480, Index root page: 481 
    Total formats: 1, used formats: 1 
    Average record length: 77.52, total records: 400 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 444.00, compression ratio: 5.73 
    Pointer pages: 1, data page slots: 6 
    Data pages: 6, average fill: 77% 
    Primary pages: 6, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 5 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 5 
    80 - 99% = 1 
 
    Index FK_WARES_WARE_GROUPS (3) 
    Root page: 1552159, depth: 1, leaf buckets: 1, nodes: 400 
    Average node length: 3.17, total dup: 392, max dup: 60 
    Average key length: 2.16, compression ratio: 4.16 
    Average prefix length: 8.86, average data length: 0.14 
    Clustering factor: 48, ratio: 0.12 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PK_WARES (0) 
    Root page: 1510355, depth: 1, leaf buckets: 1, nodes: 400 
    Average node length: 11.22, total dup: 0, max dup: 0 
    Average key length: 10.22, compression ratio: 0.88 
    Average prefix length: 1.78, average data length: 7.22 
    Clustering factor: 344, ratio: 0.86 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 0 
        40 - 59% = 1 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index WARES_ID_DESC (2) 
    Root page: 1510360, depth: 1, leaf buckets: 1, nodes: 400 
    Average node length: 11.22, total dup: 0, max dup: 0 
    Average key length: 10.22, compression ratio: 0.88 
    Average prefix length: 1.78, average data length: 7.22 
    Clustering factor: 344, ratio: 0.86 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 0 
        40 - 59% = 1 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index WARES_NUMB_UNQ (1) 
    Root page: 1510358, depth: 2, leaf buckets: 3, nodes: 400 
    Average node length: 53.25, total dup: 0, max dup: 0 
    Average key length: 52.23, compression ratio: 1.00 
    Average prefix length: 2.74, average data length: 49.25 
    Clustering factor: 355, ratio: 0.89 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 1 
        80 - 99% = 2 
 
WARE_GROUPS (151) 
    Primary pointer page: 498, Index root page: 499 
    Total formats: 1, used formats: 1 
    Average record length: 32.12, total records: 8 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 346.00, compression ratio: 10.77 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 5% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index PK_WARE_GROUPS (0) 
    Root page: 1504307, depth: 1, leaf buckets: 1, nodes: 8 
    Average node length: 11.25, total dup: 0, max dup: 0 
    Average key length: 10.12, compression ratio: 0.89 
    Average prefix length: 1.75, average data length: 7.25 
    Clustering factor: 1, ratio: 0.12 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index WARE_GROUPS_NAME_UNQ (1) 
    Root page: 1504308, depth: 1, leaf buckets: 1, nodes: 8 
    Average node length: 19.88, total dup: 0, max dup: 0 
    Average key length: 18.12, compression ratio: 0.89 
    Average prefix length: 0.25, average data length: 15.88 
    Clustering factor: 1, ratio: 0.12 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
XQD_1000_1200 (176) 
    Primary pointer page: 549, Index root page: 550 
    Total formats: 1, used formats: 1 
    Average record length: 41.44, total records: 151518 
    Average version length: 69.14, total versions: 60795, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 3.04 
    Pointer pages: 3, data page slots: 3600 
    Data pages: 2991, average fill: 59% 
    Primary pages: 2991, secondary pages: 0, swept pages: 358 
    Empty pages: 373, full pages: 1753 
    Fill distribution: 
     0 - 19% = 561 
    20 - 39% = 308 
    40 - 59% = 277 
    60 - 79% = 643 
    80 - 99% = 1202 
 
    Index XQD_1000_1200_WA_SO_RO_WKR_SND (0) 
    Root page: 104734, depth: 3, leaf buckets: 232, nodes: 151518 
    Average node length: 6.43, total dup: 131810, max dup: 14 
    Average key length: 3.95, compression ratio: 10.64 
    Average prefix length: 40.18, average data length: 1.82 
    Clustering factor: 25941, ratio: 0.17 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 46 
        40 - 59% = 119 
        60 - 79% = 61 
        80 - 99% = 6 
 
XQD_1000_3300 (178) 
    Primary pointer page: 553, Index root page: 554 
    Total formats: 1, used formats: 1 
    Average record length: 65.64, total records: 7384922 
    Average version length: 68.76, total versions: 355133, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.92 
    Pointer pages: 66, data page slots: 106168 
    Data pages: 106168, average fill: 74% 
    Primary pages: 106168, secondary pages: 0, swept pages: 30045 
    Empty pages: 21, full pages: 82943 
    Fill distribution: 
     0 - 19% = 143 
    20 - 39% = 888 
    40 - 59% = 5512 
    60 - 79% = 94312 
    80 - 99% = 5313 
 
    Index XQD_1000_3300_WA_SO_RO_WKR_SND (0) 
    Root page: 1480454, depth: 3, leaf buckets: 10772, nodes: 7384922 
    Average node length: 6.51, total dup: 6388694, max dup: 29 
    Average key length: 3.52, compression ratio: 11.94 
    Average prefix length: 40.62, average data length: 1.38 
    Clustering factor: 1624276, ratio: 0.22 
    Fill distribution: 
         0 - 19% = 9 
        20 - 39% = 1263 
        40 - 59% = 5738 
        60 - 79% = 3118 
        80 - 99% = 644 
 
    Index XQD_1000_3300_WKR_DOC_ASC (1) 
    Root page: 1486068, depth: 3, leaf buckets: 8864, nodes: 7384922 
    Average node length: 5.39, total dup: 7098234, max dup: 175 
    Average key length: 2.40, compression ratio: 7.09 
    Average prefix length: 16.64, average data length: 0.36 
    Clustering factor: 1413673, ratio: 0.19 
    Fill distribution: 
         0 - 19% = 6 
        20 - 39% = 1213 
        40 - 59% = 4895 
        60 - 79% = 1729 
        80 - 99% = 1021 
 
    Index XQD_1000_3300_WKR_DOC_DEC (2) 
    Root page: 1490608, depth: 3, leaf buckets: 8891, nodes: 7384922 
    Average node length: 5.39, total dup: 7098234, max dup: 175 
    Average key length: 2.40, compression ratio: 7.09 
    Average prefix length: 16.64, average data length: 0.36 
    Clustering factor: 1416206, ratio: 0.19 
    Fill distribution: 
         0 - 19% = 8 
        20 - 39% = 1190 
        40 - 59% = 4910 
        60 - 79% = 1747 
        80 - 99% = 1036 
 
XQD_1200_2000 (177) 
    Primary pointer page: 551, Index root page: 552 
    Total formats: 1, used formats: 1 
    Average record length: 67.41, total records: 12381883 
    Average version length: 68.70, total versions: 276146, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.87 
    Pointer pages: 106, data page slots: 171792 
    Data pages: 171792, average fill: 76% 
    Primary pages: 171792, secondary pages: 0, swept pages: 81873 
    Empty pages: 6, full pages: 160394 
    Fill distribution: 
     0 - 19% = 34 
    20 - 39% = 337 
    40 - 59% = 2758 
    60 - 79% = 163490 
    80 - 99% = 5173 
 
    Index XQD_1200_2000_WA_SO_RO_WKR_SND (0) 
    Root page: 1495028, depth: 3, leaf buckets: 18448, nodes: 12381883 
    Average node length: 6.60, total dup: 10791350, max dup: 73 
    Average key length: 3.43, compression ratio: 12.26 
    Average prefix length: 40.70, average data length: 1.30 
    Clustering factor: 2407589, ratio: 0.19 
    Fill distribution: 
         0 - 19% = 22 
        20 - 39% = 2047 
        40 - 59% = 10427 
        60 - 79% = 4960 
        80 - 99% = 992 
 
XQD_2000_3300 (179) 
    Primary pointer page: 555, Index root page: 556 
    Total formats: 1, used formats: 1 
    Average record length: 46.36, total records: 1404490 
    Average version length: 69.10, total versions: 463052, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 2.72 
    Pointer pages: 26, data page slots: 41208 
    Data pages: 27790, average fill: 58% 
    Primary pages: 27788, secondary pages: 2, swept pages: 9319 
    Empty pages: 3858, full pages: 15625 
    Fill distribution: 
     0 - 19% = 5988 
    20 - 39% = 2560 
    40 - 59% = 2099 
    60 - 79% = 10210 
    80 - 99% = 6933 
 
    Index XQD_2000_3300_WA_SO_RO_WKR_SND (0) 
    Root page: 1479712, depth: 3, leaf buckets: 2120, nodes: 1404490 
    Average node length: 5.53, total dup: 1347555, max dup: 99 
    Average key length: 2.57, compression ratio: 16.33 
    Average prefix length: 41.47, average data length: 0.53 
    Clustering factor: 92854, ratio: 0.07 
    Fill distribution: 
         0 - 19% = 7 
        20 - 39% = 829 
        40 - 59% = 922 
        60 - 79% = 318 
        80 - 99% = 44 
 
XQD_2100_3300 (180) 
    Primary pointer page: 557, Index root page: 558 
    Total formats: 1, used formats: 1 
    Average record length: 40.92, total records: 1089151 
    Average version length: 69.13, total versions: 443268, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 3.08 
    Pointer pages: 20, data page slots: 31224 
    Data pages: 26024, average fill: 49% 
    Primary pages: 26024, secondary pages: 0, swept pages: 5954 
    Empty pages: 4008, full pages: 9584 
    Fill distribution: 
     0 - 19% = 7785 
    20 - 39% = 2571 
    40 - 59% = 2849 
    60 - 79% = 6465 
    80 - 99% = 6354 
 
    Index XQD_2100_3300_WA_SO_RO_WKR_SND (0) 
    Root page: 1479207, depth: 3, leaf buckets: 1607, nodes: 1089151 
    Average node length: 5.77, total dup: 1018754, max dup: 99 
    Average key length: 2.83, compression ratio: 14.82 
    Average prefix length: 41.23, average data length: 0.77 
    Clustering factor: 155681, ratio: 0.14 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 513 
        40 - 59% = 722 
        60 - 79% = 319 
        80 - 99% = 51 
 
XQD_3300_3400 (181) 
    Primary pointer page: 559, Index root page: 560 
    Total formats: 1, used formats: 1 
    Average record length: 65.68, total records: 8832465 
    Average version length: 69.00, total versions: 410997, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.92 
    Pointer pages: 88, data page slots: 142672 
    Data pages: 142656, average fill: 66% 
    Primary pages: 142656, secondary pages: 0, swept pages: 60611 
    Empty pages: 355, full pages: 63329 
    Fill distribution: 
     0 - 19% = 1346 
    20 - 39% = 7653 
    40 - 59% = 28600 
    60 - 79% = 99972 
    80 - 99% = 5085 
 
    Index XQD_3300_3400_WA_SO_RO_WKR_SND (0) 
    Root page: 1472590, depth: 3, leaf buckets: 13442, nodes: 8832465 
    Average node length: 6.68, total dup: 7325614, max dup: 19 
    Average key length: 3.67, compression ratio: 11.44 
    Average prefix length: 40.50, average data length: 1.50 
    Clustering factor: 1890676, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 1569 
        40 - 59% = 7329 
        60 - 79% = 4145 
        80 - 99% = 398 
 
XQS_1000_1200 (182) 
    Primary pointer page: 561, Index root page: 562 
    Total formats: 1, used formats: 1 
    Average record length: 82.51, total records: 21107020 
    Average version length: 82.92, total versions: 7320, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.53 
    Pointer pages: 195, data page slots: 318208 
    Data pages: 318208, average fill: 81% 
    Primary pages: 318208, secondary pages: 0, swept pages: 12523 
    Empty pages: 40, full pages: 317133 
    Fill distribution: 
     0 - 19% = 72 
    20 - 39% = 62 
    40 - 59% = 143 
    60 - 79% = 27659 
    80 - 99% = 290272 
 
    Index XQS_1000_1200_DOC_ID (1) 
    Root page: 1426716, depth: 3, leaf buckets: 19387, nodes: 21107020 
    Average node length: 5.72, total dup: 20626767, max dup: 128 
    Average key length: 2.16, compression ratio: 4.16 
    Average prefix length: 8.86, average data length: 0.14 
    Clustering factor: 3273373, ratio: 0.16 
    Fill distribution: 
         0 - 19% = 6 
        20 - 39% = 0 
        40 - 59% = 8196 
        60 - 79% = 578 
        80 - 99% = 10607 
 
    Index XQS_1000_1200_RCV_ID (3) 
    Root page: 1456980, depth: 3, leaf buckets: 17136, nodes: 21107020 
    Average node length: 6.31, total dup: 18548808, max dup: 49 
    Average key length: 2.75, compression ratio: 3.27 
    Average prefix length: 8.37, average data length: 0.63 
    Clustering factor: 911467, ratio: 0.04 
    Fill distribution: 
         0 - 19% = 6 
        20 - 39% = 3 
        40 - 59% = 768 
        60 - 79% = 289 
        80 - 99% = 16070 
 
    Index XQS_1000_1200_SND_ID (2) 
    Root page: 1441073, depth: 3, leaf buckets: 21132, nodes: 21107020 
    Average node length: 6.34, total dup: 18467643, max dup: 29 
    Average key length: 2.79, compression ratio: 3.23 
    Average prefix length: 8.34, average data length: 0.66 
    Clustering factor: 3567386, ratio: 0.17 
    Fill distribution: 
         0 - 19% = 8 
        20 - 39% = 0 
        40 - 59% = 8407 
        60 - 79% = 602 
        80 - 99% = 12115 
 
    Index XQS_1000_1200_WORKER_ID (0) 
    Root page: 1413348, depth: 3, leaf buckets: 16050, nodes: 21107020 
    Average node length: 5.56, total dup: 21106920, max dup: 230497 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.42, average data length: 0.00 
    Clustering factor: 940295, ratio: 0.04 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 11 
        40 - 59% = 2825 
        60 - 79% = 407 
        80 - 99% = 12806 
 
XQS_1000_3300 (184) 
    Primary pointer page: 565, Index root page: 566 
    Total formats: 1, used formats: 1 
    Average record length: 79.11, total records: 9235556 
    Average version length: 82.65, total versions: 367880, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.59 
    Pointer pages: 104, data page slots: 169704 
    Data pages: 169664, average fill: 67% 
    Primary pages: 169664, secondary pages: 0, swept pages: 85175 
    Empty pages: 836, full pages: 80548 
    Fill distribution: 
     0 - 19% = 2385 
    20 - 39% = 9892 
    40 - 59% = 33454 
    60 - 79% = 76626 
    80 - 99% = 47307 
 
    Index XQS_1000_3300_DOC_ID (1) 
    Root page: 1367502, depth: 3, leaf buckets: 11327, nodes: 9235556 
    Average node length: 5.37, total dup: 8931117, max dup: 184 
    Average key length: 2.24, compression ratio: 4.02 
    Average prefix length: 8.79, average data length: 0.21 
    Clustering factor: 2026083, ratio: 0.22 
    Fill distribution: 
         0 - 19% = 3 
        20 - 39% = 133 
        40 - 59% = 9213 
        60 - 79% = 1955 
        80 - 99% = 23 
 
    Index XQS_1000_3300_RCV_ID (3) 
    Root page: 1379261, depth: 3, leaf buckets: 13148, nodes: 9235556 
    Average node length: 6.23, total dup: 7654789, max dup: 14 
    Average key length: 3.10, compression ratio: 2.90 
    Average prefix length: 8.07, average data length: 0.93 
    Clustering factor: 1394641, ratio: 0.15 
    Fill distribution: 
         0 - 19% = 126 
        20 - 39% = 4140 
        40 - 59% = 4144 
        60 - 79% = 2533 
        80 - 99% = 2205 
 
    Index XQS_1000_3300_SND_ID (2) 
    Root page: 1373059, depth: 3, leaf buckets: 12651, nodes: 9235556 
    Average node length: 5.99, total dup: 8001743, max dup: 38 
    Average key length: 2.86, compression ratio: 3.15 
    Average prefix length: 8.27, average data length: 0.73 
    Clustering factor: 2206297, ratio: 0.24 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 171 
        40 - 59% = 10275 
        60 - 79% = 2167 
        80 - 99% = 37 
 
    Index XQS_1000_3300_WORKER_ID (0) 
    Root page: 1362767, depth: 3, leaf buckets: 9793, nodes: 9235556 
    Average node length: 5.13, total dup: 9235456, max dup: 162882 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.42, average data length: 0.00 
    Clustering factor: 1438290, ratio: 0.16 
    Fill distribution: 
         0 - 19% = 53 
        20 - 39% = 1340 
        40 - 59% = 4862 
        60 - 79% = 1573 
        80 - 99% = 1965 
 
XQS_1200_2000 (183) 
    Primary pointer page: 563, Index root page: 564 
    Total formats: 1, used formats: 1 
    Average record length: 80.16, total records: 10844749 
    Average version length: 82.63, total versions: 279444, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.57 
    Pointer pages: 117, data page slots: 190888 
    Data pages: 189104, average fill: 70% 
    Primary pages: 189104, secondary pages: 0, swept pages: 82829 
    Empty pages: 4031, full pages: 129152 
    Fill distribution: 
     0 - 19% = 6979 
    20 - 39% = 9890 
    40 - 59% = 21941 
    60 - 79% = 46646 
    80 - 99% = 103648 
 
    Index XQS_1200_2000_DOC_ID (1) 
    Root page: 1392101, depth: 3, leaf buckets: 13117, nodes: 10844749 
    Average node length: 5.30, total dup: 10735833, max dup: 634 
    Average key length: 2.08, compression ratio: 4.32 
    Average prefix length: 8.93, average data length: 0.07 
    Clustering factor: 2247527, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 343 
        40 - 59% = 9946 
        60 - 79% = 2763 
        80 - 99% = 65 
 
    Index XQS_1200_2000_RCV_ID (3) 
    Root page: 1406110, depth: 3, leaf buckets: 10140, nodes: 10844749 
    Average node length: 5.49, total dup: 10369743, max dup: 49 
    Average key length: 2.28, compression ratio: 3.95 
    Average prefix length: 8.77, average data length: 0.23 
    Clustering factor: 668680, ratio: 0.06 
    Fill distribution: 
         0 - 19% = 169 
        20 - 39% = 927 
        40 - 59% = 2484 
        60 - 79% = 1811 
        80 - 99% = 4749 
 
    Index XQS_1200_2000_SND_ID (2) 
    Root page: 1398638, depth: 3, leaf buckets: 15010, nodes: 10844749 
    Average node length: 6.03, total dup: 9451671, max dup: 58 
    Average key length: 2.81, compression ratio: 3.20 
    Average prefix length: 8.32, average data length: 0.68 
    Clustering factor: 2263881, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 461 
        40 - 59% = 11446 
        60 - 79% = 3035 
        80 - 99% = 66 
 
    Index XQS_1200_2000_WORKER_ID (0) 
    Root page: 1386211, depth: 3, leaf buckets: 10391, nodes: 10844749 
    Average node length: 5.22, total dup: 10844649, max dup: 212506 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.42, average data length: 0.00 
    Clustering factor: 659059, ratio: 0.06 
    Fill distribution: 
         0 - 19% = 109 
        20 - 39% = 874 
        40 - 59% = 4527 
        60 - 79% = 1526 
        80 - 99% = 3355 
 
XQS_2000_3300 (185) 
    Primary pointer page: 567, Index root page: 568 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index XQS_2000_3300_DOC_ID (1) 
    Root page: 1361753, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index XQS_2000_3300_RCV_ID (3) 
    Root page: 1361755, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index XQS_2000_3300_SND_ID (2) 
    Root page: 1361754, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index XQS_2000_3300_WORKER_ID (0) 
    Root page: 1361752, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
XQS_2100_3300 (186) 
    Primary pointer page: 569, Index root page: 570 
    Total formats: 1, used formats: 1 
    Average record length: 79.60, total records: 9329512 
    Average version length: 82.92, total versions: 351528, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.58 
    Pointer pages: 106, data page slots: 172880 
    Data pages: 172808, average fill: 67% 
    Primary pages: 172808, secondary pages: 0, swept pages: 90253 
    Empty pages: 865, full pages: 79126 
    Fill distribution: 
     0 - 19% = 2524 
    20 - 39% = 10148 
    40 - 59% = 35032 
    60 - 79% = 80062 
    80 - 99% = 45042 
 
    Index XQS_2100_3300_DOC_ID (1) 
    Root page: 1344686, depth: 3, leaf buckets: 11492, nodes: 9329512 
    Average node length: 5.18, total dup: 9301413, max dup: 1500 
    Average key length: 2.03, compression ratio: 4.43 
    Average prefix length: 8.97, average data length: 0.03 
    Clustering factor: 1845143, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 36 
        20 - 39% = 1736 
        40 - 59% = 7477 
        60 - 79% = 1716 
        80 - 99% = 527 
 
    Index XQS_2100_3300_RCV_ID (3) 
    Root page: 1355717, depth: 3, leaf buckets: 13250, nodes: 9329512 
    Average node length: 6.25, total dup: 7732142, max dup: 14 
    Average key length: 3.10, compression ratio: 2.90 
    Average prefix length: 8.07, average data length: 0.93 
    Clustering factor: 1365345, ratio: 0.15 
    Fill distribution: 
         0 - 19% = 178 
        20 - 39% = 4123 
        40 - 59% = 4078 
        60 - 79% = 2563 
        80 - 99% = 2308 
 
    Index XQS_2100_3300_SND_ID (2) 
    Root page: 1350049, depth: 3, leaf buckets: 12057, nodes: 9329512 
    Average node length: 5.43, total dup: 8907929, max dup: 93 
    Average key length: 2.29, compression ratio: 3.93 
    Average prefix length: 8.76, average data length: 0.24 
    Clustering factor: 1972947, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 27 
        20 - 39% = 1593 
        40 - 59% = 8345 
        60 - 79% = 1577 
        80 - 99% = 515 
 
    Index XQS_2100_3300_WORKER_ID (0) 
    Root page: 985805, depth: 3, leaf buckets: 9926, nodes: 9329512 
    Average node length: 5.15, total dup: 9329412, max dup: 165578 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.42, average data length: 0.00 
    Clustering factor: 1459537, ratio: 0.16 
    Fill distribution: 
         0 - 19% = 41 
        20 - 39% = 1379 
        40 - 59% = 4963 
        60 - 79% = 1608 
        80 - 99% = 1935 
 
XQS_3300_3400 (187) 
    Primary pointer page: 571, Index root page: 572 
    Total formats: 1, used formats: 1 
    Average record length: 67.52, total records: 561836 
    Average version length: 68.85, total versions: 5320, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.87 
    Pointer pages: 5, data page slots: 7976 
    Data pages: 7976, average fill: 74% 
    Primary pages: 7976, secondary pages: 0, swept pages: 4410 
    Empty pages: 7, full pages: 5939 
    Fill distribution: 
     0 - 19% = 12 
    20 - 39% = 44 
    40 - 59% = 460 
    60 - 79% = 7377 
    80 - 99% = 83 
 
    Index XQS_3300_3400_DOC_ID (1) 
    Root page: 44449, depth: 3, leaf buckets: 739, nodes: 561836 
    Average node length: 5.95, total dup: 478076, max dup: 83 
    Average key length: 3.10, compression ratio: 2.91 
    Average prefix length: 8.05, average data length: 0.95 
    Clustering factor: 98015, ratio: 0.17 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 38 
        40 - 59% = 542 
        60 - 79% = 75 
        80 - 99% = 83 
 
    Index XQS_3300_3400_SND_ID (2) 
    Root page: 33326, depth: 3, leaf buckets: 757, nodes: 561836 
    Average node length: 6.15, total dup: 460622, max dup: 14 
    Average key length: 3.30, compression ratio: 2.73 
    Average prefix length: 7.88, average data length: 1.12 
    Clustering factor: 98059, ratio: 0.17 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 46 
        40 - 59% = 537 
        60 - 79% = 77 
        80 - 99% = 95 
 
    Index XQS_3300_3400_WORKER_ID (0) 
    Root page: 375548, depth: 2, leaf buckets: 573, nodes: 561836 
    Average node length: 4.85, total dup: 561736, max dup: 9794 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.41, average data length: 0.00 
    Clustering factor: 87107, ratio: 0.16 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 48 
        40 - 59% = 329 
        60 - 79% = 102 
        80 - 99% = 94 
 
ZDOC_DATA (170) 
    Primary pointer page: 537, Index root page: 538 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
ZDOC_LIST (169) 
    Primary pointer page: 535, Index root page: 536 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
ZINVNT_TURNOVER_LOG (171) 
    Primary pointer page: 539, Index root page: 540 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
ZPDISTR (174) 
    Primary pointer page: 545, Index root page: 546 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index ZPDISTR_ID (0) 
    Root page: 1504207, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
ZPSTORNED (175) 
    Primary pointer page: 547, Index root page: 548 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index ZPSTORNED_ID (0) 
    Root page: 1504206, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
ZQDISTR (172) 
    Primary pointer page: 541, Index root page: 542 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index ZQDISTR_ID (0) 
    Root page: 1504212, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index ZQDISTR_WARE_SNDOP_RCVOP (1) 
    Root page: 1504213, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
ZQSTORNED (173) 
    Primary pointer page: 543, Index root page: 544 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index ZQSTORNED_DOC_ID (1) 
    Root page: 1504209, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index ZQSTORNED_ID (0) 
    Root page: 1504208, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index ZQSTORNED_RCV_ID (3) 
    Root page: 1504211, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index ZQSTORNED_SND_ID (2) 
    Root page: 1504210, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
ZTMP_DEP_DOCS (168) 
    Primary pointer page: 533, Index root page: 534 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
ZTMP_SHOPPING_CART (167) 
    Primary pointer page: 531, Index root page: 532 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
Z_USED_VIEWS (144) 
    Primary pointer page: 484, Index root page: 485 
    Total formats: 1, used formats: 1 
    Average record length: 29.38, total records: 29 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 99.00, compression ratio: 3.37 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 16% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index Z_USED_VIEWS_UNQ (0) 
    Root page: 1510350, depth: 1, leaf buckets: 1, nodes: 29 
    Average node length: 15.17, total dup: 0, max dup: 0 
    Average key length: 14.14, compression ratio: 1.44 
    Average prefix length: 9.17, average data length: 11.17 
    Clustering factor: 1, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
Gstat completion time Wed Feb 28 19:12:43 2024

Record versions statistics, table

TABLE_NAME TOTAL_RECS TOTAL_VERS MAX_VERSIONS VERS_TO_RECS_PRC MAXV_TO_VERS_PRC
DOC_DATA 7661059 74192 1 0.0000 0.0000
DOC_LIST 2193585 78587 3 0.0000 0.0000
FB_ERRORS 2182 757 1 0.0000 0.0000
INVNT_SALDO 400 236691 615 59100.0000 0.0000
INVNT_TURNOVER_LOG 139002 95576 1 0.0000 0.0000
MONEY_SALDO 49 17696 938 36100.0000 0.0000
MONEY_TURNOVER_LOG 2419 1971 1 0.0000 0.0000
PDISTR 867526 73479 5 0.0000 0.0000
PERF_SPLIT_0 180427 11750 1 0.0000 0.0000
PERF_SPLIT_1 165371 14256 1 0.0000 0.0000
PERF_SPLIT_2 168844 2975 1 0.0000 0.0000
PERF_SPLIT_3 191095 29302 1 0.0000 0.0000
PERF_SPLIT_4 184752 26314 1 0.0000 0.0000
PERF_SPLIT_5 181828 7704 1 0.0000 0.0000
PERF_SPLIT_6 178395 4623 1 0.0000 0.0000
PERF_SPLIT_7 198319 34886 1 0.0000 0.0000
PERF_SPLIT_8 181105 3811 1 0.0000 0.0000
PERF_SPLIT_9 178727 681 1 0.0000 0.0000
PSTORNED 2039636 36134 1 0.0000 0.0000
SEMAPHORES 5 1 1 0.0000 100.0000
XQD_1000_1200 151518 60795 1 0.0000 0.0000
XQD_1000_3300 7384922 355133 1 0.0000 0.0000
XQD_1200_2000 12381883 276146 1 0.0000 0.0000
XQD_2000_3300 1404490 463052 1 0.0000 0.0000
XQD_2100_3300 1089151 443268 1 0.0000 0.0000
XQD_3300_3400 8832465 410997 1 0.0000 0.0000
XQS_1000_1200 21107020 7320 1 0.0000 0.0000
XQS_1000_3300 9235556 367880 1 0.0000 0.0000
XQS_1200_2000 10844749 279444 1 0.0000 0.0000
XQS_2100_3300 9329512 351528 1 0.0000 0.0000
XQS_3300_3400 561836 5320 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 ---
:1293: 
:1294: mscs-test-161.budzdorov.ru    Wed Feb 28 19:09:55 2024
:1295:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:1296: 
:1297: 
:1298: mscs-test-161.budzdorov.ru    Wed Feb 28 19:09:58 2024
:1299:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:1300: 
:1301: 
:1302: mscs-test-161.budzdorov.ru    Wed Feb 28 19:10:00 2024
:1303:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:1304: 
--- end of diff output ---

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

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