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

Hardware and OS info

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

Server and database settinfs 


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

Test configuration settings 

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

Test finish info 


FINISH_STATE                    NORMAL: TEST_TIME EXPIRED AT 2024-03-08 22:09:41
DTS_END                         2024-03-08 22:09:41.9000
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/34044
TRN_ID                          181441
ATT_ID                          540
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: 9200.88 23797 920088
customer order: creation 182.77 324 18277
customer order: refuse 15.91 408 1591
order to supplier: creation 49.35 1289 4935
order to supplier: removal 3.20 109258 320
invoice (draft): creation 48.65 3215 4865
invoice (draft): removal 49.16 917 4916
invoice accept: apply 44.35 21340 4435
invoice accept: cancel 44.28 944 4428
customer reserve: creation 4125.98 211 412598
customer reserve: removal 4329.08 63 432908
realization accept: apply 89.34 193 8934
realization accept: cancel 82.76 121 8276
payment from customer: creation 62.37 109 6237
payment from customer: removal 5.64 123 564
payment to supplier: creation 51.44 136 5144
payment to supplier: removal 3.61 83 361
service: total inventory turnovers 5.03 952 503
service: total monetary turnovers 7.06 25 706
service: aggregate perf. data 0.87 24053 87
service: refresh index statistics 0.03 312171 3

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:03, from 08-03-2024 22:10:54 to 08-03-2024 22:10:57.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 3023
TEST_TIME 2 4532
TEST_TIME 3 4956
TEST_TIME 4 4865
TEST_TIME 5 5012
TEST_TIME 6 5200
TEST_TIME 7 4892
TEST_TIME 8 6074
TEST_TIME 9 6076
TEST_TIME 10 5902
TEST_TIME 11 6077
TEST_TIME 12 5973
TEST_TIME 13 6859
TEST_TIME 14 6752
TEST_TIME 15 6977
TEST_TIME 16 7093
TEST_TIME 17 7259
TEST_TIME 18 7456
TEST_TIME 19 7234
TEST_TIME 20 7285
TEST_TIME 21 7320
TEST_TIME 22 7708
TEST_TIME 23 7646
TEST_TIME 24 7703
TEST_TIME 25 7823
TEST_TIME 26 8076
TEST_TIME 27 8461
TEST_TIME 28 8639
TEST_TIME 29 9237
TEST_TIME 30 9739
TEST_TIME 31 9667
TEST_TIME 32 9449
TEST_TIME 33 9516
TEST_TIME 34 9501
TEST_TIME 35 9297
TEST_TIME 36 9192
TEST_TIME 37 9123
TEST_TIME 38 9139
TEST_TIME 39 9290
TEST_TIME 40 9315
TEST_TIME 41 9200
TEST_TIME 42 9256
TEST_TIME 43 9264
TEST_TIME 44 9382
TEST_TIME 45 9252
TEST_TIME 46 9187
TEST_TIME 47 9200
TEST_TIME 48 9309
TEST_TIME 49 9240
TEST_TIME 50 9342
TEST_TIME 51 9292
TEST_TIME 52 9301
TEST_TIME 53 9313
TEST_TIME 54 9272
TEST_TIME 55 9328
TEST_TIME 56 9342
TEST_TIME 57 9387
TEST_TIME 58 9440
TEST_TIME 59 9525
TEST_TIME 60 9502
TEST_TIME 61 9382
TEST_TIME 62 9299
TEST_TIME 63 9259
TEST_TIME 64 9288
TEST_TIME 65 9217
TEST_TIME 66 9161
TEST_TIME 67 9222
TEST_TIME 68 9203
TEST_TIME 69 9180
TEST_TIME 70 9145
TEST_TIME 71 9061
TEST_TIME 72 9003
TEST_TIME 73 9148
TEST_TIME 74 9132
TEST_TIME 75 9163
TEST_TIME 76 9105
TEST_TIME 77 9193
TEST_TIME 78 9234
TEST_TIME 79 9283
TEST_TIME 80 9323
TEST_TIME 81 9313
TEST_TIME 82 9325
TEST_TIME 83 9385
TEST_TIME 84 9351
TEST_TIME 85 9387
TEST_TIME 86 9386
TEST_TIME 87 9404
TEST_TIME 88 9322
TEST_TIME 89 9307
TEST_TIME 90 9291
TEST_TIME 91 9246
TEST_TIME 92 9266
TEST_TIME 93 9222
TEST_TIME 94 9196
TEST_TIME 95 9159
TEST_TIME 96 9178
TEST_TIME 97 9157
TEST_TIME 98 9201
TEST_TIME 99 9248
TEST_TIME 100 9220

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:03, from 08-03-2024 22:10:58 to 08-03-2024 22:11:01.

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 1299089 1299089 0 0.00 0 23105 7 0 0
doc_list_biud 1299071 1299071 0 0.00 0 49597 27 0 0
sp_add_invoice_to_stock 4625 4435 190 4.10 18 180131 21340 0 190
sp_cancel_adding_invoice 4428 4428 0 0.00 3 59821 944 0 0
sp_cancel_client_order 1591 1591 0 0.00 5 10879 409 0 0
sp_cancel_customer_reserve 432908 432908 0 0.00 0 24175 63 0 0
sp_cancel_pay_from_customer 564 564 0 0.00 3 11909 123 0 0
sp_cancel_pay_to_supplier 361 361 0 0.00 3 7734 84 0 0
sp_cancel_supplier_invoice 4934 4916 18 0.36 1 31913 917 0 18
sp_cancel_supplier_order 320 320 0 0.00 21 980321 109258 0 0
sp_cancel_write_off 8276 8276 0 0.00 1 14152 121 0 0
sp_client_order 18277 18277 0 0.00 3 33806 325 0 0
sp_customer_reserve 412598 412598 0 0.00 0 90413 211 0 0
sp_fill_shopping_cart 28073 28073 0 0.00 1 17080 38 0 0
sp_fill_shopping_cart_clo_res 412563 412563 0 0.00 0 21973 16 0 0
sp_get_clo_for_invoice 4400 4400 0 0.00 0 31724 292 0 0
sp_kill_cost_storno 13629 13629 0 0.00 0 9195 61 0 0
sp_kill_qstorno_ret_qs2qd 879328 879328 0 0.00 0 31852 35 0 0
sp_kill_qty_storno 465772 465772 0 0.00 0 49595 75 0 0
sp_lock_selected_doc 18406 18406 0 0.00 0 7616 7 0 0
sp_make_cost_storno 24715 24715 0 0.00 0 23085 62 0 0
sp_multiply_rows_for_pdistr 24714 24714 0 0.00 0 12515 28 0 0
sp_multiply_rows_for_qdistr 18277 18277 0 0.00 0 33774 149 0 0
sp_pay_from_customer 6237 6237 0 0.00 4 12537 110 0 0
sp_pay_to_supplier 5144 5144 0 0.00 4 12389 136 0 0
sp_payment_common 11381 11381 0 0.00 1 6490 24 0 0
sp_qd_handle_on_cancel_clo 1591 1591 0 0.00 0 10857 371 0 0
sp_qd_handle_on_invoice_upd_sts 8827 8827 0 0.00 0 49593 330 0 0
sp_qd_handle_on_reserve_upd_sts 8934 8934 0 0.00 0 15173 59 0 0
sp_reserve_write_off 8934 8934 0 0.00 6 15199 193 0 0
sp_supplier_invoice 4865 4865 0 0.00 7 81372 3215 0 0
sp_supplier_order 4935 4935 0 0.00 4 32002 1289 0 0
srv_aggregate_perf_data 87 87 0 0.00 1759 220347 24053 0 0
srv_fill_mon_cache_memory 56 56 0 0.00 1131 167432 36941 0 0
srv_find_qd_qs_mism 876279 876279 0 0.00 0 16564 7 0 0
srv_make_invnt_saldo 503 503 0 0.00 40 21379 952 0 0
srv_make_money_saldo 706 706 0 0.00 1 543 25 0 0
srv_recalc_idx_stat 3 3 0 0.00 213267 434785 312171 0 0
t$perf-abend:sp_add_invoice_to_stock 190 190 0 0.00 0 0 0 0 0
t$perf-abend:sp_cancel_supplier_invoice 18 18 0 0.00 0 0 0 0 0
t$perf-norm:sp_add_invoice_to_stock 4435 4435 0 0.00 0 13857 203 0 0
t$perf-norm:sp_cancel_adding_invoice 363 363 0 0.00 0 7498 140 0 0
t$perf-norm:sp_cancel_client_order 1591 1591 0 0.00 0 4326 19 0 0
t$perf-norm:sp_cancel_customer_reserve 585 585 0 0.00 0 5515 19 0 0
t$perf-norm:sp_cancel_pay_from_customer 564 564 0 0.00 0 206 3 0 0
t$perf-norm:sp_cancel_pay_to_supplier 361 361 0 0.00 0 4062 14 0 0
t$perf-norm:sp_cancel_supplier_invoice 375 375 0 0.00 0 561 16 0 0
t$perf-norm:sp_cancel_supplier_order 320 320 0 0.00 0 34442 2094 0 0
t$perf-norm:sp_cancel_write_off 915 915 0 0.00 0 6261 19 0 0
t$perf-norm:sp_client_order 18277 18277 0 0.00 0 8929 18 0 0
t$perf-norm:sp_customer_reserve 900 900 0 0.00 0 3377 9 0 0
t$perf-norm:sp_pay_from_customer 6237 6237 0 0.00 0 5684 10 0 0
t$perf-norm:sp_pay_to_supplier 5144 5144 0 0.00 0 8172 14 0 0
t$perf-norm:sp_reserve_write_off 8934 8934 0 0.00 0 6472 11 0 0
t$perf-norm:sp_supplier_invoice 4865 4865 0 0.00 0 4945 21 0 0
t$perf-norm:sp_supplier_order 4935 4935 0 0.00 0 6702 17 0 0
t$perf-norm:srv_aggregate_perf_data 87 87 0 0.00 0 238 9 0 0
t$perf-norm:srv_fill_mon_cache_memory 56 56 0 0.00 0 1782 33 0 0
t$perf-norm:srv_make_invnt_saldo 503 503 0 0.00 0 1648 26 0 0
t$perf-norm:srv_make_money_saldo 706 706 0 0.00 0 5687 37 0 0
t$perf-norm:srv_recalc_idx_stat 3 3 0 0.00 2 5 3 0 0
v_add_invoice_to_stock 9176 8796 380 4.14 0 5990 19 0 380
v_all_customers 33776 33776 0 0.00 0 21 1 0 0
v_all_suppliers 27556 27556 0 0.00 0 37 1 0 0
v_all_wares 36550 36550 0 0.00 0 27 1 0 0
v_cancel_adding_invoice 726 726 0 0.00 0 2021 14 0 0
v_cancel_client_order 3182 3182 0 0.00 0 3140 9 0 0
v_cancel_customer_prepayment 1128 1128 0 0.00 0 3891 9 0 0
v_cancel_customer_reserve 1170 1170 0 0.00 0 1330 5 0 0
v_cancel_payment_to_supplier 722 722 0 0.00 0 148 2 0 0
v_cancel_supplier_invoice 786 750 36 4.58 0 2385 21 0 36
v_cancel_supplier_order 640 640 0 0.00 0 603 5 0 0
v_cancel_write_off 1830 1830 0 0.00 0 2717 14 0 0
v_max_id_clo_ord 4932 4932 0 0.00 0 579 1 0 0
v_max_id_clo_res 900 900 0 0.00 0 2707 20 0 0
v_max_id_ord_sup 4863 4863 0 0.00 0 6060 5 0 0
v_max_non_paid_invoice 1161 1161 0 0.00 0 4290 9 0 0
v_max_non_paid_realizn 3080 3080 0 0.00 0 1016 4 0 0
v_min_id_clo_ord 4932 4932 0 0.00 0 1881 6 0 0
v_min_id_clo_res 900 900 0 0.00 0 5326 10 0 0
v_min_id_ord_sup 4863 4863 0 0.00 0 17066 17 0 0
v_min_non_paid_invoice 5144 5144 0 0.00 0 6487 14 0 0
v_min_non_paid_realizn 6237 6237 0 0.00 0 4738 17 0 0
v_our_firm 9088 9088 0 0.00 0 52 1 0 0
v_reserve_write_off 17867 17867 0 0.00 0 6000 6 0 0
x_lock_depdocs_on_canc_invoice 8969 8969 0 0.00 0 21479 164 0 0
x_lock_depdocs_on_canc_sup_ord 320 320 0 0.00 0 22509 454 0 0
x_make_qstorno_1000_1200 4935 4935 0 0.00 1 31979 1209 0 0
x_make_qstorno_1200_2000 4865 4865 0 0.00 3 81321 3073 0 0
x_make_qstorno_2100_3300 412598 412598 0 0.00 0 90413 192 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 08-03-2024 22:11:02 to 08-03-2024 22:11:06.

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
20:09:45 6 8192000000 8802099664 8814301184 7936288 0.096 2 2 3 0 8077376 66144 74944
20:10:46 30301 8192000000 9897490272 10209161216 973795808 10.624 100 85 170 0 1001972368 6018112 22158448
20:12:24 18513 8192000000 9952101376 10279501824 1030350240 11.172 100 84 166 0 1060191824 8738144 21103440
20:13:50 17457 8192000000 9992554176 10326691840 1071586816 11.567 100 79 158 0 1100611904 9700832 19324256
20:15:12 10220 8192000000 10028676528 10374750208 1113088960 11.962 100 78 155 0 1142606720 11077712 18440048
20:16:27 8264 8192000000 10076328416 10432573440 1158763264 12.392 100 80 160 0 1190701776 12845248 19093264
20:17:39 2928 8192000000 10121093792 10494218240 1213763408 12.904 100 77 154 0 1243812208 13159472 16889328
20:18:44 1934 8192000000 10166878256 10544525312 1251988304 13.256 100 89 178 0 1284874736 13474496 19411936
20:19:49 1568 8192000000 10202130768 10582278144 1285321760 13.562 100 90 181 1 1318519664 13690864 19507040
20:20:52 9763 8192000000 10204369056 10595282944 1296596288 13.664 100 69 133 0 1322401040 11525184 14279568
20:22:03 4475 8192000000 10202107504 10605379584 1306173568 13.751 100 40 79 1 1323896864 8790960 8932336
20:23:09 5281 8192000000 10208166576 10618343424 1316445392 13.845 100 38 77 2 1332260832 7410096 8405344
20:24:17 12134 8192000000 10207509696 10628399104 1321642080 13.892 100 26 52 1 1333354992 6354784 5358128
20:25:31 4064 8192000000 10221445616 10633805824 1326094416 13.932 100 21 42 0 1336875856 6227376 4554064
20:26:36 4180 8192000000 10224551376 10641481728 1330694960 13.973 100 28 53 0 1342783344 5596928 6491456
20:27:42 49592 8192000000 10210954816 10639097856 1318678352 13.865 99 23 46 0 1329433392 5144368 5610672
20:29:36 4469 8192000000 10225439440 10637619200 1326215968 13.933 100 40 78 1 1342009600 7267552 8526080
20:31:06 1405 8192000000 10258361856 10661269504 1341181936 14.068 100 65 123 0 1367178512 11806016 14190560
20:32:10 23879 8192000000 10238352720 10643230720 1308426256 13.772 98 57 113 0 1334185680 13252992 12506432
20:33:37 38104 8192000000 10229313808 10650492928 1331811104 13.984 100 38 75 2 1352296240 10938448 9546688
20:35:24 20673 8192000000 10242718368 10659557376 1324294864 13.916 99 40 80 0 1346082432 11880448 9907120
20:36:52 23648 8192000000 10252018848 10662670336 1322581120 13.900 99 49 96 1 1351836048 17657328 11597600
20:38:24 21751 8192000000 10232537792 10646794240 1313206272 13.815 99 45 88 1 1336695184 13047088 10441824
20:40:05 11629 8192000000 10238013920 10646511616 1313390400 13.817 99 53 103 0 1342686496 17685168 11610928
20:41:23 4456 8192000000 10254310528 10648551424 1316418256 13.844 100 75 147 0 1354223312 21178816 16626240
20:42:32 1122 8192000000 10264632688 10661654528 1326234144 13.933 100 83 164 1 1372254464 26823440 19196880
20:43:39 10443 8192000000 10241642480 10644271104 1310150848 13.787 99 65 130 0 1351103216 24470048 16482320
20:44:55 9846 8192000000 10254561328 10666225664 1330029744 13.967 100 53 105 0 1367622928 24966800 12626384
20:46:17 1520 8192000000 10288235984 10692517888 1346386064 14.115 100 57 114 0 1388772256 28547056 13839136
20:47:26 9461 8192000000 10307957200 10712817664 1365957072 14.291 100 66 133 0 1412328544 30461824 15909648
20:48:42 8665 8192000000 10318060768 10729697280 1383121568 14.444 100 63 124 2 1430021408 32358192 14541648
20:50:02 8893 8192000000 10321323600 10738376704 1373590160 14.359 99 53 104 1 1422721216 35824944 13306112
20:51:22 2020 8192000000 10350680960 10752782336 1385963696 14.470 99 83 166 1 1447111712 40626448 20521568
20:52:28 2491 8192000000 10351771392 10766000128 1397658464 14.574 100 68 133 1 1455099632 39985856 17455312
20:53:35 19525 8192000000 10360507616 10785107968 1405463952 14.644 100 33 66 1 1459623376 44855168 9304256
20:54:59 13845 8192000000 10347878864 10787958784 1406603920 14.654 100 36 72 1 1464650512 48532192 9514400
20:56:38 19072 8192000000 10330079840 10772627456 1387702032 14.485 99 22 44 0 1434534512 40818176 6014304
20:58:10 20828 8192000000 10339175696 10798510080 1404728256 14.637 100 21 42 1 1457744064 47453792 5562016
20:59:36 32846 8192000000 10323858560 10764697600 1400544752 14.600 100 28 57 0 1418087024 11621792 5920480
21:01:14 167432 8192000000 10312937184 10772578304 1378140640 14.400 98 23 46 1 1394302512 10289664 5872208
21:05:03 13389 8192000000 10322020480 10782113792 1411578992 14.698 100 18 34 2 1434307760 18935904 3792864
21:06:17 19011 8192000000 10310267696 10768564224 1409677488 14.681 100 19 38 0 1430148544 15973312 4497744
21:07:55 9233 8192000000 10348393712 10786668544 1410479952 14.688 100 63 126 2 1447744160 23037664 14226544
21:09:08 48174 8192000000 10323624912 10781417472 1415188336 14.730 100 20 41 0 1432851104 12929456 4733312
21:11:09 27140 8192000000 10282412608 10728910848 1367215824 14.302 97 33 64 1 1395021088 20173968 7631296
21:12:48 39537 8192000000 10290984224 10741833728 1357232304 14.212 97 20 40 1 1372077200 10245936 4598960
21:14:28 63369 8192000000 10277428784 10724335616 1333566416 13.999 96 16 32 0 1345838864 8899584 3372864
21:16:33 30107 8192000000 10287626032 10739339264 1372820832 14.352 99 24 48 1 1387171968 8286080 6065056
21:18:17 51757 8192000000 10300126704 10740412416 1379118688 14.409 100 31 60 1 1397781936 11460432 7202816
21:20:12 58186 8192000000 10270417344 10711916544 1307192048 13.761 95 16 32 0 1319694768 9324800 3177920
21:22:15 15383 8192000000 10260801264 10692059136 1337504560 14.035 99 42 82 0 1357427024 10552512 9369952
21:23:31 44170 8192000000 10280009376 10713309184 1340171264 14.059 99 32 64 1 1362220912 14349120 7700528
21:25:16 71260 8192000000 10278442928 10718654464 1350025888 14.148 99 18 36 0 1376013392 21833504 4154000
21:27:42 57744 8192000000 10249474176 10704650240 1294153840 13.642 96 16 32 0 1325998688 28149968 3694880
21:30:20 76951 8192000000 10269789088 10693300224 1327702448 13.946 98 36 72 0 1348618624 12174992 8741184
21:32:41 81877 8192000000 10261309168 10705850368 1354843216 14.191 100 19 38 0 1371635424 12475312 4316896
21:35:06 35180 8192000000 10265967616 10701717504 1338738848 14.046 98 44 83 1 1365964336 16690128 10535360
21:36:44 50115 8192000000 10249627312 10702757888 1335980352 14.021 98 11 22 0 1347900960 9230128 2690480
21:38:39 16666 8192000000 10244901712 10683924480 1332728464 13.992 99 26 52 0 1348907632 10114176 6064992
21:40:44 65092 8192000000 10280739184 10731065344 1376376064 14.384 100 21 42 0 1394805136 13666512 4762560
21:43:27 54344 8192000000 10290448960 10737414144 1361987008 14.255 98 21 42 1 1374406976 8082240 4337728
21:45:23 41629 8192000000 10313665808 10753769472 1378343024 14.402 99 32 64 0 1404703584 18873568 7486992
21:47:16 75839 8192000000 10306472608 10752897024 1384302352 14.455 99 9 18 0 1401749216 15727872 1718992
21:49:36 45111 8192000000 10293199376 10733543424 1348321440 14.132 97 20 40 0 1362468064 9940032 4206592
21:51:24 39293 8192000000 10303323296 10747940864 1372339984 14.348 99 27 54 1 1390352512 11962176 6050352
21:53:04 59025 8192000000 10306075840 10746191872 1366251088 14.293 98 31 62 2 1383959776 10219488 7489200
21:55:04 105113 8192000000 10278732944 10720538624 1299815776 13.694 94 10 20 0 1315620112 13910224 1894112
21:57:50 87572 8192000000 10294119824 10740449280 1357435344 14.214 98 23 46 0 1375989040 13502752 5050944
22:00:25 12816 8192000000 10275968304 10720509952 1360559456 14.242 99 25 50 0 1380166368 13552704 6054208
22:01:39 33030 8192000000 10242033696 10690805760 1327800192 13.947 97 22 44 0 1342769472 9830544 5138736
22:03:16 76417 8192000000 10263421952 10712166400 1340307072 14.060 98 10 20 0 1354847072 11819200 2720800
22:05:34 49428 8192000000 10262165280 10721071104 1344668080 14.099 99 11 21 0 1365473344 18287584 2517680
22:08:03 41104 8192000000 10264240688 10711871488 1335407056 14.016 98 20 40 0 1352055840 12094080 4554704

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:14, from 08-03-2024 22:11:08 to 08-03-2024 22:11:22.

Exceptions occured during test was in run

FB_MNEMONA CNT UNIT FB_GDSCODE
except 190 v_add_invoice_to_stock 335544517
except 18 v_cancel_supplier_invoice 335544517

Completed "Exceptions occured during test was in run". Done for 00:00:02, from 08-03-2024 22:11:23 to 08-03-2024 22:11:25.

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          180103
MON$OLDEST_ACTIVE               181559
MON$OLDEST_SNAPSHOT             181559
MON$NEXT_TRANSACTION            181559
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                       1908576
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.33734 Firebird 3.0
Server version:
Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V3.0.12.33734 Firebird 3.0"
Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-V3.0.12.33734 Firebird 3.0/tcp (mscs-test-161.budzdorov.ru)/P15:C"
Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-V3.0.12.33734 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 Fri Mar  8 22:11:26 2024 
 
Database header page information: 
    Flags            0 
    Generation        94624 
    System Change Number    0 
    Page size        8192 
    ODS version        12.0 
    Oldest transaction    180103 
    Oldest active        181559 
    Oldest snapshot        181559 
    Next transaction    181560 
    Sequence number        0 
    Next attachment ID    727 
    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.30, total records: 7808291 
    Average version length: 48.17, total versions: 96660, 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: 87304 
    Data pages: 87304, average fill: 71% 
    Primary pages: 87304, secondary pages: 0, swept pages: 20031 
    Empty pages: 4, full pages: 61146 
    Fill distribution: 
     0 - 19% = 13 
    20 - 39% = 37 
    40 - 59% = 1087 
    60 - 79% = 86149 
    80 - 99% = 18 
 
    Index DOC_DATA_DOC_WARE_UNQ (0) 
    Root page: 1510614, depth: 3, leaf buckets: 23515, nodes: 7808291 
    Average node length: 18.91, total dup: 0, max dup: 0 
    Average key length: 15.92, compression ratio: 1.70 
    Average prefix length: 14.08, average data length: 12.92 
    Clustering factor: 1735390, ratio: 0.22 
    Fill distribution: 
         0 - 19% = 370 
        20 - 39% = 1738 
        40 - 59% = 4388 
        60 - 79% = 2285 
        80 - 99% = 14734 
 
    Index DOC_DATA_ID_DESC (1) 
    Root page: 1528118, depth: 3, leaf buckets: 13599, nodes: 7808291 
    Average node length: 11.20, total dup: 0, max dup: 0 
    Average key length: 8.21, compression ratio: 1.10 
    Average prefix length: 3.79, average data length: 5.21 
    Clustering factor: 1557946, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 1565 
        40 - 59% = 2097 
        60 - 79% = 1055 
        80 - 99% = 8882 
 
    Index FK_DOC_DATA_DOC_LIST (2) 
    Root page: 1546711, depth: 3, leaf buckets: 8429, nodes: 7808291 
    Average node length: 6.63, total dup: 5823858, max dup: 49 
    Average key length: 3.64, compression ratio: 2.47 
    Average prefix length: 7.61, average data length: 1.39 
    Clustering factor: 1550990, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 141 
        20 - 39% = 945 
        40 - 59% = 1478 
        60 - 79% = 870 
        80 - 99% = 4995 
 
DOC_LIST (138) 
    Primary pointer page: 472, Index root page: 473 
    Total formats: 1, used formats: 1 
    Average record length: 56.17, total records: 2275373 
    Average version length: 34.79, total versions: 101430, max versions: 3 
    Average fragment length: 5.67, total fragments: 6, max fragments: 1 
    Average unpacked length: 84.00, compression ratio: 1.50 
    Pointer pages: 18, data page slots: 28816 
    Data pages: 28816, average fill: 73% 
    Primary pages: 28810, secondary pages: 6, swept pages: 9872 
    Empty pages: 2, full pages: 20360 
    Fill distribution: 
     0 - 19% = 18 
    20 - 39% = 146 
    40 - 59% = 1571 
    60 - 79% = 26241 
    80 - 99% = 840 
 
    Index DOC_LIST_ID_DESC (1) 
    Root page: 1541130, depth: 3, leaf buckets: 4600, nodes: 2275373 
    Average node length: 11.40, total dup: 0, max dup: 0 
    Average key length: 8.44, compression ratio: 1.07 
    Average prefix length: 3.56, average data length: 5.44 
    Clustering factor: 706416, ratio: 0.31 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 916 
        40 - 59% = 862 
        60 - 79% = 705 
        80 - 99% = 2117 
 
    Index DOC_LIST_WORKER_OPTYPE (2) 
    Root page: 1544376, depth: 3, leaf buckets: 2561, nodes: 2278408 
    Average node length: 4.97, total dup: 2277509, max dup: 19251 
    Average key length: 2.01, compression ratio: 4.47 
    Average prefix length: 8.99, average data length: 0.01 
    Clustering factor: 1255566, ratio: 0.55 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 287 
        40 - 59% = 1534 
        60 - 79% = 558 
        80 - 99% = 180 
 
    Index FK_DOC_LIST_AGENTS (3) 
    Root page: 1545909, depth: 3, leaf buckets: 2046, nodes: 2275373 
    Average node length: 4.97, total dup: 2275323, max dup: 130515 
    Average key length: 2.01, compression ratio: 4.48 
    Average prefix length: 8.99, average data length: 0.01 
    Clustering factor: 1073981, ratio: 0.47 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 37 
        40 - 59% = 1101 
        60 - 79% = 51 
        80 - 99% = 855 
 
    Index PK_DOC_LIST (0) 
    Root page: 1538187, depth: 3, leaf buckets: 4418, nodes: 2275373 
    Average node length: 11.40, total dup: 0, max dup: 0 
    Average key length: 8.44, compression ratio: 1.07 
    Average prefix length: 3.56, average data length: 5.44 
    Clustering factor: 706416, ratio: 0.31 
    Fill distribution: 
         0 - 19% = 123 
        20 - 39% = 578 
        40 - 59% = 658 
        60 - 79% = 792 
        80 - 99% = 2267 
 
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.39, total records: 400 
    Average version length: 23.23, total versions: 242333, max versions: 630 
    Average fragment length: 2.04, total fragments: 49, max fragments: 1 
    Average unpacked length: 104.00, compression ratio: 1.26 
    Pointer pages: 1, data page slots: 1368 
    Data pages: 1368, average fill: 89% 
    Primary pages: 14, secondary pages: 1354, swept pages: 0 
    Empty pages: 7, full pages: 1360 
    Fill distribution: 
     0 - 19% = 7 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 1 
    80 - 99% = 1360 
 
    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: 16.22, total records: 157099 
    Average version length: 68.30, total versions: 119786, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 88.00, compression ratio: 5.42 
    Pointer pages: 7, data page slots: 2600 
    Data pages: 2488, average fill: 76% 
    Primary pages: 2487, secondary pages: 1, swept pages: 0 
    Empty pages: 171, full pages: 2020 
    Fill distribution: 
     0 - 19% = 226 
    20 - 39% = 133 
    40 - 59% = 88 
    60 - 79% = 390 
    80 - 99% = 1651 
 
    Index INVNT_TURNOVER_LOG_WARE_DD_ID (0) 
    Root page: 1701821, depth: 3, leaf buckets: 418, nodes: 157099 
    Average node length: 13.08, total dup: 13748, max dup: 2 
    Average key length: 10.45, compression ratio: 2.58 
    Average prefix length: 19.46, average data length: 7.54 
    Clustering factor: 112379, ratio: 0.72 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 3 
        40 - 59% = 193 
        60 - 79% = 198 
        80 - 99% = 22 
 
MONEY_SALDO (141) 
    Primary pointer page: 478, Index root page: 479 
    Total formats: 1, used formats: 1 
    Average record length: 15.18, total records: 49 
    Average version length: 9.00, total versions: 17818, max versions: 985 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 32.00, compression ratio: 2.11 
    Pointer pages: 1, data page slots: 72 
    Data pages: 72, average fill: 80% 
    Primary pages: 8, secondary pages: 64, swept pages: 0 
    Empty pages: 7, full pages: 64 
    Fill distribution: 
     0 - 19% = 7 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 1 
    80 - 99% = 64 
 
    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: 1.47, total records: 1354 
    Average version length: 43.86, total versions: 1308, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 58.00, compression ratio: 39.46 
    Pointer pages: 1, data page slots: 40 
    Data pages: 40, average fill: 34% 
    Primary pages: 39, secondary pages: 1, swept pages: 0 
    Empty pages: 13, full pages: 7 
    Fill distribution: 
     0 - 19% = 20 
    20 - 39% = 3 
    40 - 59% = 4 
    60 - 79% = 7 
    80 - 99% = 6 
 
    Index MONEY_TURNOVER_LOG_AGENT_OPTYPE (0) 
    Root page: 90295, depth: 2, leaf buckets: 2, nodes: 1354 
    Average node length: 4.30, total dup: 1256, max dup: 125 
    Average key length: 2.77, compression ratio: 6.87 
    Average prefix length: 18.30, average data length: 0.70 
    Clustering factor: 729, ratio: 0.54 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 1 
        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.08, total records: 73 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 112.00, compression ratio: 1.15 
    Pointer pages: 1, data page slots: 2 
    Data pages: 2, average fill: 51% 
    Primary pages: 2, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 1 
    Fill distribution: 
     0 - 19% = 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: 73 
    Average node length: 11.68, total dup: 0, max dup: 0 
    Average key length: 10.67, compression ratio: 0.84 
    Average prefix length: 1.32, average data length: 7.68 
    Clustering factor: 2, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
MON_LOG (162) 
    Primary pointer page: 520, Index root page: 521 
    Total formats: 2, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index MON_LOG_DTS (4) 
    Root page: 1504229, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index MON_LOG_GDSCODE (2) 
    Root page: 1504227, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index MON_LOG_ROWSET_DESC (1) 
    Root page: 1504226, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index MON_LOG_UNIT (3) 
    Root page: 1504228, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PK_MON_LOG (0) 
    Root page: 1504225, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
MON_LOG_TABLE_STATS (163) 
    Primary pointer page: 522, Index root page: 523 
    Total formats: 2, used formats: 1 
    Average record length: 67.13, total records: 30 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 611.00, compression ratio: 9.10 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 31% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 1 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index MON_LOG_TABLE_STATS_DTS (4) 
    Root page: 1504224, depth: 1, leaf buckets: 1, nodes: 30 
    Average node length: 3.50, total dup: 23, max dup: 4 
    Average key length: 2.47, compression ratio: 3.24 
    Average prefix length: 7.53, average data length: 0.47 
    Clustering factor: 1, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index MON_LOG_TABLE_STATS_GDSCODE (2) 
    Root page: 1504222, depth: 1, leaf buckets: 1, nodes: 30 
    Average node length: 2.00, total dup: 29, max dup: 29 
    Average key length: 1.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 1, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index MON_LOG_TABLE_STATS_ROWSET (1) 
    Root page: 1504221, depth: 1, leaf buckets: 1, nodes: 30 
    Average node length: 3.33, total dup: 29, max dup: 29 
    Average key length: 2.30, compression ratio: 3.91 
    Average prefix length: 8.70, average data length: 0.30 
    Clustering factor: 1, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index MON_LOG_TABLE_STATS_TN_UNIT (3) 
    Root page: 1504223, depth: 1, leaf buckets: 1, nodes: 30 
    Average node length: 12.90, total dup: 0, max dup: 0 
    Average key length: 11.87, compression ratio: 1.42 
    Average prefix length: 7.63, average data length: 9.20 
    Clustering factor: 1, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PK_MON_LOG_TABLE_STATS (0) 
    Root page: 1504220, depth: 1, leaf buckets: 1, nodes: 30 
    Average node length: 8.37, total dup: 0, max dup: 0 
    Average key length: 7.33, compression ratio: 1.23 
    Average prefix length: 4.63, average data length: 4.37 
    Clustering factor: 1, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
OPTYPES (136) 
    Primary pointer page: 468, Index root page: 469 
    Total formats: 2, used formats: 1 
    Average record length: 67.56, total records: 9 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 386.00, compression ratio: 5.71 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 9% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index OPTYPES_MCODE_UNQ (1) 
    Root page: 1544805, depth: 1, leaf buckets: 1, nodes: 9 
    Average node length: 8.56, total dup: 0, max dup: 0 
    Average key length: 6.89, compression ratio: 0.73 
    Average prefix length: 0.44, average data length: 4.56 
    Clustering factor: 1, ratio: 0.11 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PK_OPTYPES (0) 
    Root page: 1544804, depth: 1, leaf buckets: 1, nodes: 9 
    Average node length: 6.11, total dup: 0, max dup: 0 
    Average key length: 5.00, compression ratio: 0.60 
    Average prefix length: 0.89, average data length: 2.11 
    Clustering factor: 1, ratio: 0.11 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
PDISTR (146) 
    Primary pointer page: 488, Index root page: 489 
    Total formats: 1, used formats: 1 
    Average record length: 35.99, total records: 806425 
    Average version length: 25.58, total versions: 72387, max versions: 4 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 54.00, compression ratio: 1.50 
    Pointer pages: 5, data page slots: 8160 
    Data pages: 8160, average fill: 69% 
    Primary pages: 8128, secondary pages: 32, swept pages: 1463 
    Empty pages: 94, full pages: 7339 
    Fill distribution: 
     0 - 19% = 206 
    20 - 39% = 162 
    40 - 59% = 130 
    60 - 79% = 7384 
    80 - 99% = 278 
 
    Index PDISTR_AGENT_ID (2) 
    Root page: 1509308, depth: 2, leaf buckets: 882, nodes: 806425 
    Average node length: 4.87, total dup: 806376, max dup: 142094 
    Average key length: 2.01, compression ratio: 4.48 
    Average prefix length: 8.99, average data length: 0.01 
    Clustering factor: 89162, ratio: 0.11 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 118 
        40 - 59% = 503 
        60 - 79% = 188 
        80 - 99% = 72 
 
    Index PDISTR_SNDOP_RCVOP_SNDID_ASC (0) 
    Root page: 1508613, depth: 3, leaf buckets: 934, nodes: 806425 
    Average node length: 5.87, total dup: 718212, max dup: 45 
    Average key length: 3.02, compression ratio: 7.29 
    Average prefix length: 21.09, average data length: 0.91 
    Clustering factor: 159550, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 91 
        40 - 59% = 413 
        60 - 79% = 124 
        80 - 99% = 305 
 
    Index PDISTR_SNDOP_RCVOP_SNDID_DESC (1) 
    Root page: 1509187, depth: 3, leaf buckets: 980, nodes: 806425 
    Average node length: 5.88, total dup: 718212, max dup: 45 
    Average key length: 3.02, compression ratio: 7.29 
    Average prefix length: 21.09, average data length: 0.91 
    Clustering factor: 161543, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 199 
        40 - 59% = 369 
        60 - 79% = 121 
        80 - 99% = 290 
 
    Index PDISTR_WORKER_SND_ID (3) 
    Root page: 1510178, depth: 3, leaf buckets: 1129, nodes: 806425 
    Average node length: 5.96, total dup: 718212, max dup: 45 
    Average key length: 3.10, compression ratio: 5.49 
    Average prefix length: 16.01, average data length: 0.99 
    Clustering factor: 154515, ratio: 0.19 
    Fill distribution: 
         0 - 19% = 4 
        20 - 39% = 237 
        40 - 59% = 571 
        60 - 79% = 212 
        80 - 99% = 105 
 
PERF_AGG (158) 
    Primary pointer page: 512, Index root page: 513 
    Total formats: 1, used formats: 1 
    Average record length: 62.88, total records: 5528 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 2.71, total fragments: 114, max fragments: 1 
    Average unpacked length: 379.00, compression ratio: 6.03 
    Pointer pages: 1, data page slots: 120 
    Data pages: 120, average fill: 46% 
    Primary pages: 97, secondary pages: 23, swept pages: 53 
    Empty pages: 32, full pages: 67 
    Fill distribution: 
     0 - 19% = 49 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 70 
    80 - 99% = 1 
 
    Index PERF_AGG_UNQ (1) 
    Root page: 1504238, depth: 2, leaf buckets: 6, nodes: 5528 
    Average node length: 5.45, total dup: 0, max dup: 0 
    Average key length: 3.56, compression ratio: 10.14 
    Average prefix length: 34.58, average data length: 1.53 
    Clustering factor: 5206, ratio: 0.94 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 0 
        40 - 59% = 4 
        60 - 79% = 0 
        80 - 99% = 2 
 
    Index PK_PERF_AGG (0) 
    Root page: 1504233, depth: 2, leaf buckets: 10, nodes: 5528 
    Average node length: 11.10, 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: 150, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 2 
        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.14, total records: 82851 
    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: 800 
    Data pages: 800, average fill: 71% 
    Primary pages: 800, secondary pages: 0, swept pages: 0 
    Empty pages: 1, full pages: 798 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 1 
    40 - 59% = 0 
    60 - 79% = 798 
    80 - 99% = 0 
 
    Index PK_PERF_ESTIMATED (0) 
    Root page: 36259, depth: 2, leaf buckets: 105, nodes: 82851 
    Average node length: 10.19, total dup: 0, max dup: 0 
    Average key length: 8.20, compression ratio: 1.10 
    Average prefix length: 3.80, average data length: 5.20 
    Clustering factor: 3397, ratio: 0.04 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 1 
        80 - 99% = 104 
 
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: 142.85, total records: 168614 
    Average version length: 151.82, total versions: 9024, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.87 
    Pointer pages: 7, data page slots: 5104 
    Data pages: 4128, average fill: 84% 
    Primary pages: 4126, secondary pages: 2, swept pages: 4 
    Empty pages: 115, full pages: 3975 
    Fill distribution: 
     0 - 19% = 118 
    20 - 39% = 10 
    40 - 59% = 11 
    60 - 79% = 15 
    80 - 99% = 3974 
 
PERF_SPLIT_1 (282) 
    Primary pointer page: 576, Index root page: 577 
    Total formats: 1, used formats: 1 
    Average record length: 145.68, total records: 181789 
    Average version length: 151.43, total versions: 6589, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.64 
    Pointer pages: 7, data page slots: 5600 
    Data pages: 4424, average fill: 85% 
    Primary pages: 4424, secondary pages: 0, swept pages: 9 
    Empty pages: 96, full pages: 4296 
    Fill distribution: 
     0 - 19% = 100 
    20 - 39% = 12 
    40 - 59% = 7 
    60 - 79% = 11 
    80 - 99% = 4294 
 
PERF_SPLIT_2 (283) 
    Primary pointer page: 578, Index root page: 579 
    Total formats: 1, used formats: 1 
    Average record length: 128.23, total records: 206492 
    Average version length: 154.06, total versions: 31303, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 13.23 
    Pointer pages: 7, data page slots: 6032 
    Data pages: 5064, average fill: 85% 
    Primary pages: 5063, secondary pages: 1, swept pages: 8 
    Empty pages: 125, full pages: 4888 
    Fill distribution: 
     0 - 19% = 133 
    20 - 39% = 16 
    40 - 59% = 19 
    60 - 79% = 11 
    80 - 99% = 4885 
 
PERF_SPLIT_3 (284) 
    Primary pointer page: 580, Index root page: 581 
    Total formats: 1, used formats: 1 
    Average record length: 123.23, total records: 213207 
    Average version length: 154.52, total versions: 39424, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 13.76 
    Pointer pages: 7, data page slots: 6512 
    Data pages: 5208, average fill: 86% 
    Primary pages: 5207, secondary pages: 1, swept pages: 2 
    Empty pages: 118, full pages: 5061 
    Fill distribution: 
     0 - 19% = 122 
    20 - 39% = 9 
    40 - 59% = 6 
    60 - 79% = 9 
    80 - 99% = 5062 
 
PERF_SPLIT_4 (285) 
    Primary pointer page: 582, Index root page: 583 
    Total formats: 1, used formats: 1 
    Average record length: 144.37, total records: 148249 
    Average version length: 151.66, total versions: 6193, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.75 
    Pointer pages: 6, data page slots: 4648 
    Data pages: 3576, average fill: 85% 
    Primary pages: 3576, secondary pages: 0, swept pages: 5 
    Empty pages: 56, full pages: 3496 
    Fill distribution: 
     0 - 19% = 61 
    20 - 39% = 5 
    40 - 59% = 6 
    60 - 79% = 9 
    80 - 99% = 3495 
 
PERF_SPLIT_5 (286) 
    Primary pointer page: 584, Index root page: 585 
    Total formats: 1, used formats: 1 
    Average record length: 133.84, total records: 185843 
    Average version length: 154.35, total versions: 20995, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 12.67 
    Pointer pages: 8, data page slots: 5600 
    Data pages: 4480, average fill: 86% 
    Primary pages: 4480, secondary pages: 0, swept pages: 6 
    Empty pages: 56, full pages: 4399 
    Fill distribution: 
     0 - 19% = 61 
    20 - 39% = 8 
    40 - 59% = 7 
    60 - 79% = 6 
    80 - 99% = 4398 
 
PERF_SPLIT_6 (287) 
    Primary pointer page: 586, Index root page: 587 
    Total formats: 1, used formats: 1 
    Average record length: 145.98, total records: 184585 
    Average version length: 152.14, total versions: 6269, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.62 
    Pointer pages: 9, data page slots: 5256 
    Data pages: 4480, average fill: 85% 
    Primary pages: 4480, secondary pages: 0, swept pages: 7 
    Empty pages: 88, full pages: 4360 
    Fill distribution: 
     0 - 19% = 93 
    20 - 39% = 5 
    40 - 59% = 10 
    60 - 79% = 13 
    80 - 99% = 4359 
 
PERF_SPLIT_7 (288) 
    Primary pointer page: 588, Index root page: 589 
    Total formats: 1, used formats: 1 
    Average record length: 138.33, total records: 181728 
    Average version length: 153.72, total versions: 15340, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 12.26 
    Pointer pages: 7, data page slots: 5576 
    Data pages: 4384, average fill: 86% 
    Primary pages: 4383, secondary pages: 1, swept pages: 5 
    Empty pages: 59, full pages: 4302 
    Fill distribution: 
     0 - 19% = 61 
    20 - 39% = 7 
    40 - 59% = 9 
    60 - 79% = 6 
    80 - 99% = 4301 
 
PERF_SPLIT_8 (289) 
    Primary pointer page: 590, Index root page: 591 
    Total formats: 1, used formats: 1 
    Average record length: 147.73, total records: 188994 
    Average version length: 151.08, total versions: 4412, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.48 
    Pointer pages: 8, data page slots: 6104 
    Data pages: 4576, average fill: 85% 
    Primary pages: 4576, secondary pages: 0, swept pages: 2 
    Empty pages: 77, full pages: 4471 
    Fill distribution: 
     0 - 19% = 82 
    20 - 39% = 9 
    40 - 59% = 9 
    60 - 79% = 5 
    80 - 99% = 4471 
 
PERF_SPLIT_9 (290) 
    Primary pointer page: 593, Index root page: 594 
    Total formats: 1, used formats: 1 
    Average record length: 146.26, total records: 174168 
    Average version length: 152.15, total versions: 5372, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.60 
    Pointer pages: 6, data page slots: 4552 
    Data pages: 4216, average fill: 85% 
    Primary pages: 4216, secondary pages: 0, swept pages: 10 
    Empty pages: 75, full pages: 4117 
    Fill distribution: 
     0 - 19% = 84 
    20 - 39% = 5 
    40 - 59% = 5 
    60 - 79% = 5 
    80 - 99% = 4117 
 
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.56, total records: 2119624 
    Average version length: 52.90, total versions: 47623, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 70.00, compression ratio: 1.36 
    Pointer pages: 16, data page slots: 25816 
    Data pages: 25816, average fill: 71% 
    Primary pages: 25816, secondary pages: 0, swept pages: 11188 
    Empty pages: 262, full pages: 20404 
    Fill distribution: 
     0 - 19% = 532 
    20 - 39% = 501 
    40 - 59% = 1235 
    60 - 79% = 23142 
    80 - 99% = 406 
 
    Index PSTORNED_RCV_ID (1) 
    Root page: 1506186, depth: 3, leaf buckets: 2626, nodes: 2119624 
    Average node length: 5.44, total dup: 1978089, max dup: 1528 
    Average key length: 2.49, compression ratio: 3.62 
    Average prefix length: 8.58, average data length: 0.42 
    Clustering factor: 182690, ratio: 0.09 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 293 
        40 - 59% = 1758 
        60 - 79% = 307 
        80 - 99% = 267 
 
    Index PSTORNED_SND_ID (0) 
    Root page: 1504819, depth: 3, leaf buckets: 2758, nodes: 2119624 
    Average node length: 5.69, total dup: 1902554, max dup: 64 
    Average key length: 2.74, compression ratio: 3.29 
    Average prefix length: 8.36, average data length: 0.64 
    Clustering factor: 378295, ratio: 0.18 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 6 
        40 - 59% = 2333 
        60 - 79% = 381 
        80 - 99% = 37 
 
    Index PSTORNED_WORKER_ID (2) 
    Root page: 1507996, depth: 3, leaf buckets: 2220, nodes: 2119624 
    Average node length: 4.96, total dup: 2119524, max dup: 27885 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.41, average data length: 0.00 
    Clustering factor: 180455, ratio: 0.09 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 221 
        40 - 59% = 1263 
        60 - 79% = 362 
        80 - 99% = 374 
 
RULES_FOR_PDISTR (148) 
    Primary pointer page: 492, Index root page: 493 
    Total formats: 1, used formats: 1 
    Average record length: 17.00, total records: 4 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 334.00, compression ratio: 19.65 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 2% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index RULES_FOR_PDISTR_UNQ (0) 
    Root page: 1504317, depth: 1, leaf buckets: 1, nodes: 4 
    Average node length: 11.50, total dup: 0, max dup: 0 
    Average key length: 10.25, compression ratio: 0.88 
    Average prefix length: 1.50, average data length: 7.50 
    Clustering factor: 1, ratio: 0.25 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
RULES_FOR_QDISTR (137) 
    Primary pointer page: 470, Index root page: 471 
    Total formats: 1, used formats: 1 
    Average record length: 32.71, total records: 7 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 332.00, compression ratio: 10.15 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 4% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index RULES_FOR_QDISTR_RCVOP (1) 
    Root page: 1544803, depth: 1, leaf buckets: 1, nodes: 7 
    Average node length: 5.29, total dup: 2, max dup: 2 
    Average key length: 4.14, compression ratio: 0.72 
    Average prefix length: 1.43, average data length: 1.57 
    Clustering factor: 1, ratio: 0.14 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index RULES_FOR_QDISTR_UNQ (0) 
    Root page: 1544802, depth: 1, leaf buckets: 1, nodes: 7 
    Average node length: 10.14, total dup: 0, max dup: 0 
    Average key length: 8.86, compression ratio: 0.94 
    Average prefix length: 2.14, average data length: 6.14 
    Clustering factor: 1, ratio: 0.14 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
SEMAPHORES (152) 
    Primary pointer page: 500, Index root page: 501 
    Total formats: 1, used formats: 1 
    Average record length: 43.40, total records: 5 
    Average version length: 9.00, total versions: 1, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 346.00, compression ratio: 7.97 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 4% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index PK_SEMAPHORES (0) 
    Root page: 1504305, depth: 1, leaf buckets: 1, nodes: 5 
    Average node length: 12.40, total dup: 0, max dup: 0 
    Average key length: 11.00, compression ratio: 0.82 
    Average prefix length: 0.60, average data length: 8.40 
    Clustering factor: 1, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index SEMAPHORES_TASK_UNQ (1) 
    Root page: 1504306, depth: 1, leaf buckets: 1, nodes: 5 
    Average node length: 23.40, total dup: 0, max dup: 0 
    Average key length: 22.00, compression ratio: 1.07 
    Average prefix length: 4.20, average data length: 19.40 
    Clustering factor: 1, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
SETTINGS (135) 
    Primary pointer page: 466, Index root page: 467 
    Total formats: 1, used formats: 1 
    Average record length: 97.63, total records: 149 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1347.00, compression ratio: 13.80 
    Pointer pages: 1, data page slots: 3 
    Data pages: 3, average fill: 70% 
    Primary pages: 3, secondary pages: 0, swept pages: 2 
    Empty pages: 0, full pages: 2 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 1 
    60 - 79% = 0 
    80 - 99% = 2 
 
    Index SETTINGS_MCODE_WM_UNQ (1) 
    Root page: 525, depth: 1, leaf buckets: 1, nodes: 149 
    Average node length: 14.66, total dup: 0, max dup: 0 
    Average key length: 13.55, compression ratio: 2.19 
    Average prefix length: 19.07, average data length: 10.66 
    Clustering factor: 48, ratio: 0.32 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 1 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index SETTINGS_MODE_CODE (0) 
    Root page: 1544806, depth: 1, leaf buckets: 1, nodes: 149 
    Average node length: 25.56, total dup: 0, max dup: 0 
    Average key length: 24.56, compression ratio: 1.63 
    Average prefix length: 18.58, average data length: 21.56 
    Clustering factor: 14, ratio: 0.09 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 0 
        40 - 59% = 1 
        60 - 79% = 0 
        80 - 99% = 0 
 
TMP$DEP_DOCS (129) 
    Primary pointer page: 454, Index root page: 455 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index TMP_DEP_DOCS_UNQ (0) 
    Root page: 1544810, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
TMP$IDX_RECALC (132) 
    Primary pointer page: 460, Index root page: 461 
    Total formats: 2, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index TMP_IDX_RECALC_IDX_NAME_UNQ (0) 
    Root page: 1544807, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
TMP$MON_LOG (133) 
    Primary pointer page: 462, Index root page: 463 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
TMP$MON_LOG_TABLE_STATS (134) 
    Primary pointer page: 464, Index root page: 465 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
TMP$PERF_EST_WHOLE (161) 
    Primary pointer page: 518, Index root page: 519 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
TMP$PERF_LOG (160) 
    Primary pointer page: 516, Index root page: 517 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index TMP$PERF_LOG_UNIT_TRN_DTS_END (0) 
    Root page: 1504230, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
TMP$PERF_MON (131) 
    Primary pointer page: 458, Index root page: 459 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
TMP$RESULT_SET (130) 
    Primary pointer page: 456, Index root page: 457 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index TMP_RESULT_SET_DOC (1) 
    Root page: 1544809, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index TMP_RESULT_SET_WARE_DOC (0) 
    Root page: 1544808, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
TMP$SHOPPING_CART (128) 
    Primary pointer page: 452, Index root page: 453 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index TMP_SHOPCART_UNQ (0) 
    Root page: 1544811, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
TPAUSE (166) 
    Primary pointer page: 528, Index root page: 529 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index RDB$PRIMARY2 (0) 
    Root page: 1504214, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
TRACE_STAT (157) 
    Primary pointer page: 510, Index root page: 511 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
WARES (142) 
    Primary pointer page: 480, Index root page: 481 
    Total formats: 1, used formats: 1 
    Average record length: 77.52, total records: 400 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 444.00, compression ratio: 5.73 
    Pointer pages: 1, data page slots: 6 
    Data pages: 6, average fill: 77% 
    Primary pages: 6, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 5 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 5 
    80 - 99% = 1 
 
    Index FK_WARES_WARE_GROUPS (3) 
    Root page: 1552159, depth: 1, leaf buckets: 1, nodes: 400 
    Average node length: 3.17, total dup: 392, max dup: 60 
    Average key length: 2.16, compression ratio: 4.16 
    Average prefix length: 8.86, average data length: 0.14 
    Clustering factor: 48, ratio: 0.12 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PK_WARES (0) 
    Root page: 1510355, depth: 1, leaf buckets: 1, nodes: 400 
    Average node length: 11.22, total dup: 0, max dup: 0 
    Average key length: 10.22, compression ratio: 0.88 
    Average prefix length: 1.78, average data length: 7.22 
    Clustering factor: 344, ratio: 0.86 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 0 
        40 - 59% = 1 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index WARES_ID_DESC (2) 
    Root page: 1510360, depth: 1, leaf buckets: 1, nodes: 400 
    Average node length: 11.22, total dup: 0, max dup: 0 
    Average key length: 10.22, compression ratio: 0.88 
    Average prefix length: 1.78, average data length: 7.22 
    Clustering factor: 344, ratio: 0.86 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 0 
        40 - 59% = 1 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index WARES_NUMB_UNQ (1) 
    Root page: 1510358, depth: 2, leaf buckets: 3, nodes: 400 
    Average node length: 53.25, total dup: 0, max dup: 0 
    Average key length: 52.23, compression ratio: 1.00 
    Average prefix length: 2.74, average data length: 49.25 
    Clustering factor: 355, ratio: 0.89 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 1 
        80 - 99% = 2 
 
WARE_GROUPS (151) 
    Primary pointer page: 498, Index root page: 499 
    Total formats: 1, used formats: 1 
    Average record length: 32.12, total records: 8 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 346.00, compression ratio: 10.77 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 5% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index PK_WARE_GROUPS (0) 
    Root page: 1504307, depth: 1, leaf buckets: 1, nodes: 8 
    Average node length: 11.25, total dup: 0, max dup: 0 
    Average key length: 10.12, compression ratio: 0.89 
    Average prefix length: 1.75, average data length: 7.25 
    Clustering factor: 1, ratio: 0.12 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index WARE_GROUPS_NAME_UNQ (1) 
    Root page: 1504308, depth: 1, leaf buckets: 1, nodes: 8 
    Average node length: 19.88, total dup: 0, max dup: 0 
    Average key length: 18.12, compression ratio: 0.89 
    Average prefix length: 0.25, average data length: 15.88 
    Clustering factor: 1, ratio: 0.12 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
XQD_1000_1200 (176) 
    Primary pointer page: 549, Index root page: 550 
    Total formats: 1, used formats: 1 
    Average record length: 36.72, total records: 137256 
    Average version length: 69.19, total versions: 64468, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 3.43 
    Pointer pages: 3, data page slots: 4384 
    Data pages: 2936, average fill: 55% 
    Primary pages: 2936, secondary pages: 0, swept pages: 499 
    Empty pages: 628, full pages: 1712 
    Fill distribution: 
     0 - 19% = 848 
    20 - 39% = 172 
    40 - 59% = 142 
    60 - 79% = 529 
    80 - 99% = 1245 
 
    Index XQD_1000_1200_WA_SO_RO_WKR_SND (0) 
    Root page: 1570724, depth: 3, leaf buckets: 212, nodes: 137256 
    Average node length: 6.39, total dup: 119590, max dup: 29 
    Average key length: 3.96, compression ratio: 10.62 
    Average prefix length: 40.17, average data length: 1.83 
    Clustering factor: 23096, ratio: 0.17 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 52 
        40 - 59% = 102 
        60 - 79% = 44 
        80 - 99% = 13 
 
XQD_1000_3300 (178) 
    Primary pointer page: 553, Index root page: 554 
    Total formats: 1, used formats: 1 
    Average record length: 64.97, total records: 6984495 
    Average version length: 68.81, total versions: 404829, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.94 
    Pointer pages: 63, data page slots: 101248 
    Data pages: 101248, average fill: 74% 
    Primary pages: 101248, secondary pages: 0, swept pages: 25840 
    Empty pages: 25, full pages: 76386 
    Fill distribution: 
     0 - 19% = 131 
    20 - 39% = 918 
    40 - 59% = 7347 
    60 - 79% = 86285 
    80 - 99% = 6567 
 
    Index XQD_1000_3300_WA_SO_RO_WKR_SND (0) 
    Root page: 1480454, depth: 3, leaf buckets: 10625, nodes: 6984495 
    Average node length: 6.51, total dup: 6042431, max dup: 29 
    Average key length: 3.52, compression ratio: 11.94 
    Average prefix length: 40.62, average data length: 1.38 
    Clustering factor: 1541262, ratio: 0.22 
    Fill distribution: 
         0 - 19% = 5 
        20 - 39% = 1808 
        40 - 59% = 5776 
        60 - 79% = 2465 
        80 - 99% = 571 
 
    Index XQD_1000_3300_WKR_DOC_ASC (1) 
    Root page: 1486068, depth: 3, leaf buckets: 8472, nodes: 6984495 
    Average node length: 5.40, total dup: 6705456, max dup: 204 
    Average key length: 2.41, compression ratio: 7.06 
    Average prefix length: 16.63, average data length: 0.37 
    Clustering factor: 1342977, ratio: 0.19 
    Fill distribution: 
         0 - 19% = 11 
        20 - 39% = 1290 
        40 - 59% = 4524 
        60 - 79% = 1685 
        80 - 99% = 962 
 
    Index XQD_1000_3300_WKR_DOC_DEC (2) 
    Root page: 1490608, depth: 3, leaf buckets: 8537, nodes: 6984495 
    Average node length: 5.40, total dup: 6705456, max dup: 204 
    Average key length: 2.41, compression ratio: 7.06 
    Average prefix length: 16.63, average data length: 0.37 
    Clustering factor: 1345593, ratio: 0.19 
    Fill distribution: 
         0 - 19% = 6 
        20 - 39% = 1404 
        40 - 59% = 4497 
        60 - 79% = 1660 
        80 - 99% = 970 
 
XQD_1200_2000 (177) 
    Primary pointer page: 551, Index root page: 552 
    Total formats: 1, used formats: 1 
    Average record length: 66.96, total records: 11990602 
    Average version length: 68.73, total versions: 347388, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.88 
    Pointer pages: 103, data page slots: 167408 
    Data pages: 167408, average fill: 76% 
    Primary pages: 167408, secondary pages: 0, swept pages: 74862 
    Empty pages: 5, full pages: 152058 
    Fill distribution: 
     0 - 19% = 38 
    20 - 39% = 495 
    40 - 59% = 4125 
    60 - 79% = 156594 
    80 - 99% = 6156 
 
    Index XQD_1200_2000_WA_SO_RO_WKR_SND (0) 
    Root page: 1495028, depth: 3, leaf buckets: 18325, nodes: 11990602 
    Average node length: 6.58, total dup: 10450144, max dup: 57 
    Average key length: 3.43, compression ratio: 12.25 
    Average prefix length: 40.70, average data length: 1.30 
    Clustering factor: 2367928, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 29 
        20 - 39% = 2586 
        40 - 59% = 10563 
        60 - 79% = 4243 
        80 - 99% = 904 
 
XQD_2000_3300 (179) 
    Primary pointer page: 555, Index root page: 556 
    Total formats: 1, used formats: 1 
    Average record length: 42.45, total records: 1633971 
    Average version length: 69.14, total versions: 630994, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 2.97 
    Pointer pages: 26, data page slots: 40976 
    Data pages: 28632, average fill: 65% 
    Primary pages: 28632, secondary pages: 0, swept pages: 6519 
    Empty pages: 2753, full pages: 19583 
    Fill distribution: 
     0 - 19% = 4393 
    20 - 39% = 1865 
    40 - 59% = 1625 
    60 - 79% = 10523 
    80 - 99% = 10226 
 
    Index XQD_2000_3300_WA_SO_RO_WKR_SND (0) 
    Root page: 1479712, depth: 3, leaf buckets: 2179, nodes: 1633971 
    Average node length: 5.51, total dup: 1568221, max dup: 99 
    Average key length: 2.55, compression ratio: 16.46 
    Average prefix length: 41.49, average data length: 0.51 
    Clustering factor: 109521, ratio: 0.07 
    Fill distribution: 
         0 - 19% = 12 
        20 - 39% = 548 
        40 - 59% = 1022 
        60 - 79% = 458 
        80 - 99% = 139 
 
XQD_2100_3300 (180) 
    Primary pointer page: 557, Index root page: 558 
    Total formats: 1, used formats: 1 
    Average record length: 35.52, total records: 1234038 
    Average version length: 69.14, total versions: 598858, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 3.55 
    Pointer pages: 21, data page slots: 34000 
    Data pages: 28072, average fill: 51% 
    Primary pages: 28072, secondary pages: 0, swept pages: 6615 
    Empty pages: 6532, full pages: 15503 
    Fill distribution: 
     0 - 19% = 9650 
    20 - 39% = 1913 
    40 - 59% = 742 
    60 - 79% = 3431 
    80 - 99% = 12336 
 
    Index XQD_2100_3300_WA_SO_RO_WKR_SND (0) 
    Root page: 1479207, depth: 3, leaf buckets: 1563, nodes: 1234038 
    Average node length: 5.74, total dup: 1156562, max dup: 104 
    Average key length: 2.80, compression ratio: 14.98 
    Average prefix length: 41.26, average data length: 0.74 
    Clustering factor: 164469, ratio: 0.13 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 210 
        40 - 59% = 749 
        60 - 79% = 440 
        80 - 99% = 162 
 
XQD_3300_3400 (181) 
    Primary pointer page: 559, Index root page: 560 
    Total formats: 1, used formats: 1 
    Average record length: 65.53, total records: 9368324 
    Average version length: 68.97, total versions: 456396, 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: 143064 
    Data pages: 143040, average fill: 70% 
    Primary pages: 143040, secondary pages: 0, swept pages: 54788 
    Empty pages: 258, full pages: 80475 
    Fill distribution: 
     0 - 19% = 862 
    20 - 39% = 3893 
    40 - 59% = 19145 
    60 - 79% = 111874 
    80 - 99% = 7266 
 
    Index XQD_3300_3400_WA_SO_RO_WKR_SND (0) 
    Root page: 1472590, depth: 3, leaf buckets: 13501, nodes: 9368324 
    Average node length: 6.67, total dup: 7774533, max dup: 23 
    Average key length: 3.66, compression ratio: 11.46 
    Average prefix length: 40.51, average data length: 1.49 
    Clustering factor: 2028885, ratio: 0.22 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 1288 
        40 - 59% = 6444 
        60 - 79% = 4885 
        80 - 99% = 882 
 
XQS_1000_1200 (182) 
    Primary pointer page: 561, Index root page: 562 
    Total formats: 1, used formats: 1 
    Average record length: 82.49, total records: 21197236 
    Average version length: 82.91, total versions: 13012, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.53 
    Pointer pages: 196, data page slots: 319528 
    Data pages: 319528, average fill: 81% 
    Primary pages: 319528, secondary pages: 0, swept pages: 13328 
    Empty pages: 42, full pages: 318705 
    Fill distribution: 
     0 - 19% = 63 
    20 - 39% = 36 
    40 - 59% = 103 
    60 - 79% = 27860 
    80 - 99% = 291466 
 
    Index XQS_1000_1200_DOC_ID (1) 
    Root page: 1426716, depth: 3, leaf buckets: 19304, nodes: 21197236 
    Average node length: 5.72, total dup: 20715332, max dup: 128 
    Average key length: 2.16, compression ratio: 4.16 
    Average prefix length: 8.86, average data length: 0.14 
    Clustering factor: 3287221, ratio: 0.16 
    Fill distribution: 
         0 - 19% = 3 
        20 - 39% = 0 
        40 - 59% = 7891 
        60 - 79% = 580 
        80 - 99% = 10830 
 
    Index XQS_1000_1200_RCV_ID (3) 
    Root page: 1456980, depth: 3, leaf buckets: 17234, nodes: 21197236 
    Average node length: 6.31, total dup: 18627848, max dup: 49 
    Average key length: 2.75, compression ratio: 3.27 
    Average prefix length: 8.37, average data length: 0.63 
    Clustering factor: 915896, ratio: 0.04 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 3 
        40 - 59% = 828 
        60 - 79% = 268 
        80 - 99% = 16133 
 
    Index XQS_1000_1200_SND_ID (2) 
    Root page: 1441073, depth: 3, leaf buckets: 21118, nodes: 21197236 
    Average node length: 6.35, total dup: 18546829, max dup: 29 
    Average key length: 2.79, compression ratio: 3.23 
    Average prefix length: 8.34, average data length: 0.66 
    Clustering factor: 3582832, ratio: 0.17 
    Fill distribution: 
         0 - 19% = 7 
        20 - 39% = 1 
        40 - 59% = 8207 
        60 - 79% = 655 
        80 - 99% = 12248 
 
    Index XQS_1000_1200_WORKER_ID (0) 
    Root page: 1413348, depth: 3, leaf buckets: 16151, nodes: 21197236 
    Average node length: 5.56, total dup: 21197136, max dup: 230326 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.42, average data length: 0.00 
    Clustering factor: 944951, ratio: 0.04 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 7 
        40 - 59% = 2932 
        60 - 79% = 388 
        80 - 99% = 12824 
 
XQS_1000_3300 (184) 
    Primary pointer page: 565, Index root page: 566 
    Total formats: 1, used formats: 1 
    Average record length: 78.67, total records: 9812230 
    Average version length: 82.60, total versions: 445554, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.60 
    Pointer pages: 105, data page slots: 170216 
    Data pages: 170192, average fill: 71% 
    Primary pages: 170192, secondary pages: 0, swept pages: 77664 
    Empty pages: 437, full pages: 98788 
    Fill distribution: 
     0 - 19% = 1327 
    20 - 39% = 5276 
    40 - 59% = 23040 
    60 - 79% = 80499 
    80 - 99% = 60050 
 
    Index XQS_1000_3300_DOC_ID (1) 
    Root page: 1367502, depth: 3, leaf buckets: 11391, nodes: 9812230 
    Average node length: 5.36, total dup: 9500470, max dup: 209 
    Average key length: 2.23, compression ratio: 4.03 
    Average prefix length: 8.80, average data length: 0.20 
    Clustering factor: 2166885, ratio: 0.22 
    Fill distribution: 
         0 - 19% = 5 
        20 - 39% = 57 
        40 - 59% = 7958 
        60 - 79% = 3260 
        80 - 99% = 111 
 
    Index XQS_1000_3300_RCV_ID (3) 
    Root page: 1379261, depth: 3, leaf buckets: 13743, nodes: 9812230 
    Average node length: 6.23, total dup: 8137611, max dup: 14 
    Average key length: 3.10, compression ratio: 2.90 
    Average prefix length: 8.07, average data length: 0.93 
    Clustering factor: 1511531, ratio: 0.15 
    Fill distribution: 
         0 - 19% = 155 
        20 - 39% = 4062 
        40 - 59% = 4416 
        60 - 79% = 2647 
        80 - 99% = 2463 
 
    Index XQS_1000_3300_SND_ID (2) 
    Root page: 1373059, depth: 3, leaf buckets: 12717, nodes: 9812230 
    Average node length: 5.98, total dup: 8514634, max dup: 41 
    Average key length: 2.85, compression ratio: 3.16 
    Average prefix length: 8.28, average data length: 0.72 
    Clustering factor: 2357611, ratio: 0.24 
    Fill distribution: 
         0 - 19% = 3 
        20 - 39% = 71 
        40 - 59% = 8897 
        60 - 79% = 3587 
        80 - 99% = 159 
 
    Index XQS_1000_3300_WORKER_ID (0) 
    Root page: 1362767, depth: 3, leaf buckets: 10192, nodes: 9812230 
    Average node length: 5.14, total dup: 9812130, max dup: 158925 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.42, average data length: 0.00 
    Clustering factor: 1545870, ratio: 0.16 
    Fill distribution: 
         0 - 19% = 38 
        20 - 39% = 1191 
        40 - 59% = 5079 
        60 - 79% = 1739 
        80 - 99% = 2145 
 
XQS_1200_2000 (183) 
    Primary pointer page: 563, Index root page: 564 
    Total formats: 1, used formats: 1 
    Average record length: 79.79, total records: 11472938 
    Average version length: 82.54, total versions: 350705, 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: 119, data page slots: 192888 
    Data pages: 191760, average fill: 73% 
    Primary pages: 191760, secondary pages: 0, swept pages: 69920 
    Empty pages: 2893, full pages: 145984 
    Fill distribution: 
     0 - 19% = 4788 
    20 - 39% = 6810 
    40 - 59% = 16538 
    60 - 79% = 43723 
    80 - 99% = 119901 
 
    Index XQS_1200_2000_DOC_ID (1) 
    Root page: 1392101, depth: 3, leaf buckets: 13145, nodes: 11472938 
    Average node length: 5.30, total dup: 11362280, max dup: 686 
    Average key length: 2.08, compression ratio: 4.33 
    Average prefix length: 8.93, average data length: 0.07 
    Clustering factor: 2387371, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 136 
        40 - 59% = 8742 
        60 - 79% = 3990 
        80 - 99% = 277 
 
    Index XQS_1200_2000_RCV_ID (3) 
    Root page: 1406110, depth: 3, leaf buckets: 10638, nodes: 11472938 
    Average node length: 5.50, total dup: 10973094, max dup: 49 
    Average key length: 2.28, compression ratio: 3.95 
    Average prefix length: 8.77, average data length: 0.23 
    Clustering factor: 718029, ratio: 0.06 
    Fill distribution: 
         0 - 19% = 157 
        20 - 39% = 908 
        40 - 59% = 2643 
        60 - 79% = 1844 
        80 - 99% = 5086 
 
    Index XQS_1200_2000_SND_ID (2) 
    Root page: 1398638, depth: 3, leaf buckets: 15031, nodes: 11472938 
    Average node length: 6.03, total dup: 10011571, max dup: 64 
    Average key length: 2.80, compression ratio: 3.21 
    Average prefix length: 8.32, average data length: 0.68 
    Clustering factor: 2403899, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 4 
        20 - 39% = 157 
        40 - 59% = 10186 
        60 - 79% = 4366 
        80 - 99% = 318 
 
    Index XQS_1200_2000_WORKER_ID (0) 
    Root page: 1386211, depth: 3, leaf buckets: 11037, nodes: 11472938 
    Average node length: 5.23, total dup: 11472838, max dup: 198943 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.42, average data length: 0.00 
    Clustering factor: 706174, ratio: 0.06 
    Fill distribution: 
         0 - 19% = 83 
        20 - 39% = 874 
        40 - 59% = 5062 
        60 - 79% = 1572 
        80 - 99% = 3446 
 
XQS_2000_3300 (185) 
    Primary pointer page: 567, Index root page: 568 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index XQS_2000_3300_DOC_ID (1) 
    Root page: 1361753, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index XQS_2000_3300_RCV_ID (3) 
    Root page: 1361755, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index XQS_2000_3300_SND_ID (2) 
    Root page: 1361754, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index XQS_2000_3300_WORKER_ID (0) 
    Root page: 1361752, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
XQS_2100_3300 (186) 
    Primary pointer page: 569, Index root page: 570 
    Total formats: 1, used formats: 1 
    Average record length: 78.96, total records: 9937365 
    Average version length: 82.92, total versions: 453289, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.60 
    Pointer pages: 107, data page slots: 174368 
    Data pages: 174336, average fill: 71% 
    Primary pages: 174336, secondary pages: 0, swept pages: 81132 
    Empty pages: 415, full pages: 98048 
    Fill distribution: 
     0 - 19% = 1435 
    20 - 39% = 5914 
    40 - 59% = 25395 
    60 - 79% = 82520 
    80 - 99% = 59072 
 
    Index XQS_2100_3300_DOC_ID (1) 
    Root page: 1344686, depth: 3, leaf buckets: 12020, nodes: 9937365 
    Average node length: 5.18, total dup: 9908217, max dup: 1553 
    Average key length: 2.03, compression ratio: 4.43 
    Average prefix length: 8.97, average data length: 0.03 
    Clustering factor: 1981878, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 38 
        20 - 39% = 1516 
        40 - 59% = 7924 
        60 - 79% = 1936 
        80 - 99% = 606 
 
    Index XQS_2100_3300_RCV_ID (3) 
    Root page: 1355717, depth: 3, leaf buckets: 13841, nodes: 9937365 
    Average node length: 6.25, total dup: 8240852, max dup: 14 
    Average key length: 3.10, compression ratio: 2.90 
    Average prefix length: 8.07, average data length: 0.93 
    Clustering factor: 1475006, ratio: 0.15 
    Fill distribution: 
         0 - 19% = 172 
        20 - 39% = 4021 
        40 - 59% = 4386 
        60 - 79% = 2672 
        80 - 99% = 2590 
 
    Index XQS_2100_3300_SND_ID (2) 
    Root page: 1350049, depth: 3, leaf buckets: 12631, nodes: 9937365 
    Average node length: 5.44, total dup: 9492748, max dup: 99 
    Average key length: 2.29, compression ratio: 3.94 
    Average prefix length: 8.76, average data length: 0.24 
    Clustering factor: 2115472, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 17 
        20 - 39% = 1441 
        40 - 59% = 8850 
        60 - 79% = 1712 
        80 - 99% = 611 
 
    Index XQS_2100_3300_WORKER_ID (0) 
    Root page: 985805, depth: 3, leaf buckets: 10383, nodes: 9937365 
    Average node length: 5.15, total dup: 9937265, max dup: 161828 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.42, average data length: 0.00 
    Clustering factor: 1571411, ratio: 0.16 
    Fill distribution: 
         0 - 19% = 40 
        20 - 39% = 1224 
        40 - 59% = 5266 
        60 - 79% = 1718 
        80 - 99% = 2135 
 
XQS_3300_3400 (187) 
    Primary pointer page: 571, Index root page: 572 
    Total formats: 1, used formats: 1 
    Average record length: 67.29, total records: 579633 
    Average version length: 68.81, total versions: 7485, 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: 8040 
    Data pages: 8040, average fill: 76% 
    Primary pages: 8040, secondary pages: 0, swept pages: 3905 
    Empty pages: 3, full pages: 6737 
    Fill distribution: 
     0 - 19% = 4 
    20 - 39% = 11 
    40 - 59% = 173 
    60 - 79% = 7719 
    80 - 99% = 133 
 
    Index XQS_3300_3400_DOC_ID (1) 
    Root page: 46283, depth: 3, leaf buckets: 750, nodes: 579633 
    Average node length: 5.95, total dup: 493566, max dup: 82 
    Average key length: 3.09, compression ratio: 2.91 
    Average prefix length: 8.06, average data length: 0.94 
    Clustering factor: 100889, ratio: 0.17 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 29 
        40 - 59% = 550 
        60 - 79% = 86 
        80 - 99% = 85 
 
    Index XQS_3300_3400_SND_ID (2) 
    Root page: 30923, depth: 3, leaf buckets: 770, nodes: 579633 
    Average node length: 6.15, total dup: 475503, max dup: 29 
    Average key length: 3.29, compression ratio: 2.73 
    Average prefix length: 7.89, average data length: 1.11 
    Clustering factor: 100944, ratio: 0.17 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 29 
        40 - 59% = 552 
        60 - 79% = 89 
        80 - 99% = 98 
 
    Index XQS_3300_3400_WORKER_ID (0) 
    Root page: 375548, depth: 2, leaf buckets: 582, nodes: 579633 
    Average node length: 4.86, total dup: 579533, max dup: 9461 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.42, average data length: 0.00 
    Clustering factor: 89594, ratio: 0.15 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 36 
        40 - 59% = 352 
        60 - 79% = 75 
        80 - 99% = 119 
 
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 Fri Mar  8 22:11:51 2024

Record versions statistics, table

TABLE_NAME TOTAL_RECS TOTAL_VERS MAX_VERSIONS VERS_TO_RECS_PRC MAXV_TO_VERS_PRC
DOC_DATA 7808291 96660 1 0.0000 0.0000
DOC_LIST 2275373 101430 3 0.0000 0.0000
FB_ERRORS 2182 757 1 0.0000 0.0000
INVNT_SALDO 400 242333 630 60500.0000 0.0000
INVNT_TURNOVER_LOG 157099 119786 1 0.0000 0.0000
MONEY_SALDO 49 17818 985 36300.0000 0.0000
MONEY_TURNOVER_LOG 1354 1308 1 0.0000 0.0000
PDISTR 806425 72387 4 0.0000 0.0000
PERF_SPLIT_0 168614 9024 1 0.0000 0.0000
PERF_SPLIT_1 181789 6589 1 0.0000 0.0000
PERF_SPLIT_2 206492 31303 1 0.0000 0.0000
PERF_SPLIT_3 213207 39424 1 0.0000 0.0000
PERF_SPLIT_4 148249 6193 1 0.0000 0.0000
PERF_SPLIT_5 185843 20995 1 0.0000 0.0000
PERF_SPLIT_6 184585 6269 1 0.0000 0.0000
PERF_SPLIT_7 181728 15340 1 0.0000 0.0000
PERF_SPLIT_8 188994 4412 1 0.0000 0.0000
PERF_SPLIT_9 174168 5372 1 0.0000 0.0000
PSTORNED 2119624 47623 1 0.0000 0.0000
SEMAPHORES 5 1 1 0.0000 100.0000
XQD_1000_1200 137256 64468 1 0.0000 0.0000
XQD_1000_3300 6984495 404829 1 0.0000 0.0000
XQD_1200_2000 11990602 347388 1 0.0000 0.0000
XQD_2000_3300 1633971 630994 1 0.0000 0.0000
XQD_2100_3300 1234038 598858 1 0.0000 0.0000
XQD_3300_3400 9368324 456396 1 0.0000 0.0000
XQS_1000_1200 21197236 13012 1 0.0000 0.0000
XQS_1000_3300 9812230 445554 1 0.0000 0.0000
XQS_1200_2000 11472938 350705 1 0.0000 0.0000
XQS_2100_3300 9937365 453289 1 0.0000 0.0000
XQS_3300_3400 579633 7485 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 ---
:156: 
:157: mscs-test-161.budzdorov.ru    Fri Mar  8 22:09:42 2024
:158:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:159: 
--- end of diff output ---

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

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