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

Server and database settinfs 


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

Test configuration settings 

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

Test finish info 


FINISH_STATE                    NORMAL: TEST_TIME EXPIRED AT 2024-02-23 22:09:33
DTS_END                         2024-02-23 22:09:33.8530
FB_GDSCODE                      -1
FB_MNEMONA                      
STACK                           SP_CANCEL_SUPPLIER_ORDER(116:18) ==> SP_CANCEL_CUSTOMER_RESERVE(36:5) ==> SP_CHECK_TO_STOP_WORK(32:12) ==> SP_HALT_ON_ERROR(57:17)
IP                              ::1/38936
TRN_ID                          171285
ATT_ID                          525
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: 9492.48 20008 949248
customer order: creation 172.69 386 17269
customer order: refuse 14.75 412 1475
order to supplier: creation 45.88 1380 4588
order to supplier: removal 3.82 93349 382
invoice (draft): creation 45.04 3190 4504
invoice (draft): removal 53.26 834 5326
invoice accept: apply 41.34 20910 4134
invoice accept: cancel 48.49 803 4849
customer reserve: creation 4028.47 197 402847
customer reserve: removal 4738.49 59 473849
realization accept: apply 82.34 214 8234
realization accept: cancel 87.48 129 8748
payment from customer: creation 59.55 121 5955
payment from customer: removal 6.16 77 616
payment to supplier: creation 48.59 119 4859
payment to supplier: removal 3.65 62 365
service: total inventory turnovers 4.76 1105 476
service: total monetary turnovers 6.77 24 677
service: aggregate perf. data 0.92 14108 92
service: refresh index statistics 0.03 262681 3

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:02, from 23-02-2024 22:10:31 to 23-02-2024 22:10:33.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 4633
TEST_TIME 2 4484
TEST_TIME 3 3972
TEST_TIME 4 3986
TEST_TIME 5 4487
TEST_TIME 6 4280
TEST_TIME 7 5113
TEST_TIME 8 5052
TEST_TIME 9 4947
TEST_TIME 10 5046
TEST_TIME 11 5028
TEST_TIME 12 5320
TEST_TIME 13 5629
TEST_TIME 14 5827
TEST_TIME 15 6196
TEST_TIME 16 6230
TEST_TIME 17 6233
TEST_TIME 18 6540
TEST_TIME 19 6880
TEST_TIME 20 7081
TEST_TIME 21 7126
TEST_TIME 22 7311
TEST_TIME 23 7474
TEST_TIME 24 7843
TEST_TIME 25 8405
TEST_TIME 26 8838
TEST_TIME 27 8992
TEST_TIME 28 9120
TEST_TIME 29 9075
TEST_TIME 30 9066
TEST_TIME 31 8979
TEST_TIME 32 8919
TEST_TIME 33 8948
TEST_TIME 34 8743
TEST_TIME 35 8756
TEST_TIME 36 8712
TEST_TIME 37 8887
TEST_TIME 38 8830
TEST_TIME 39 8881
TEST_TIME 40 8930
TEST_TIME 41 9057
TEST_TIME 42 8991
TEST_TIME 43 8961
TEST_TIME 44 9009
TEST_TIME 45 9114
TEST_TIME 46 9089
TEST_TIME 47 9336
TEST_TIME 48 9509
TEST_TIME 49 9503
TEST_TIME 50 9483
TEST_TIME 51 9606
TEST_TIME 52 9634
TEST_TIME 53 9660
TEST_TIME 54 9737
TEST_TIME 55 9729
TEST_TIME 56 9624
TEST_TIME 57 9490
TEST_TIME 58 9489
TEST_TIME 59 9421
TEST_TIME 60 9462
TEST_TIME 61 9504
TEST_TIME 62 9529
TEST_TIME 63 9481
TEST_TIME 64 9535
TEST_TIME 65 9442
TEST_TIME 66 9425
TEST_TIME 67 9405
TEST_TIME 68 9394
TEST_TIME 69 9410
TEST_TIME 70 9367
TEST_TIME 71 9376
TEST_TIME 72 9444
TEST_TIME 73 9451
TEST_TIME 74 9579
TEST_TIME 75 9516
TEST_TIME 76 9693
TEST_TIME 77 9650
TEST_TIME 78 9696
TEST_TIME 79 9690
TEST_TIME 80 9712
TEST_TIME 81 9732
TEST_TIME 82 9727
TEST_TIME 83 9709
TEST_TIME 84 9665
TEST_TIME 85 9674
TEST_TIME 86 9628
TEST_TIME 87 9619
TEST_TIME 88 9574
TEST_TIME 89 9517
TEST_TIME 90 9505
TEST_TIME 91 9464
TEST_TIME 92 9459
TEST_TIME 93 9436
TEST_TIME 94 9447
TEST_TIME 95 9455
TEST_TIME 96 9493
TEST_TIME 97 9498
TEST_TIME 98 9469
TEST_TIME 99 9531
TEST_TIME 100 9496

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:03, from 23-02-2024 22:10:35 to 23-02-2024 22:10:38.

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 1317542 1317542 0 0.00 0 23132 7 0 0
doc_list_biud 1317534 1317534 0 0.00 0 40847 27 0 0
sp_add_invoice_to_stock 4214 4134 80 1.89 37 205315 20911 0 80
sp_cancel_adding_invoice 4849 4849 0 0.00 3 50225 803 0 0
sp_cancel_client_order 1475 1475 0 0.00 4 24615 412 0 0
sp_cancel_customer_reserve 473849 473849 0 0.00 0 40848 59 0 0
sp_cancel_pay_from_customer 616 616 0 0.00 3 4573 77 0 0
sp_cancel_pay_to_supplier 365 365 0 0.00 3 3559 63 0 0
sp_cancel_supplier_invoice 5332 5326 6 0.11 1 20624 835 0 6
sp_cancel_supplier_order 382 382 0 0.00 6 1041582 93349 0 0
sp_cancel_write_off 8748 8748 0 0.00 1 19566 129 0 0
sp_client_order 17269 17269 0 0.00 3 30608 386 0 0
sp_customer_reserve 402847 402847 0 0.00 0 61379 197 0 0
sp_fill_shopping_cart 26345 26345 0 0.00 1 7580 34 0 0
sp_fill_shopping_cart_clo_res 402843 402843 0 0.00 0 25512 17 0 0
sp_get_clo_for_invoice 4129 4129 0 0.00 0 26127 296 0 0
sp_kill_cost_storno 14578 14578 0 0.00 0 19532 62 0 0
sp_kill_qstorno_ret_qs2qd 962154 962154 0 0.00 0 40845 33 0 0
sp_kill_qty_storno 506987 506987 0 0.00 0 40847 70 0 0
sp_lock_selected_doc 17213 17213 0 0.00 0 9088 8 0 0
sp_make_cost_storno 23175 23175 0 0.00 0 20850 62 0 0
sp_multiply_rows_for_pdistr 23174 23174 0 0.00 0 13031 30 0 0
sp_multiply_rows_for_qdistr 17268 17268 0 0.00 0 10704 170 0 0
sp_pay_from_customer 5955 5955 0 0.00 4 22621 121 0 0
sp_pay_to_supplier 4859 4859 0 0.00 5 11431 120 0 0
sp_payment_common 10813 10813 0 0.00 1 17578 33 0 0
sp_qd_handle_on_cancel_clo 1475 1475 0 0.00 0 24607 369 0 0
sp_qd_handle_on_invoice_upd_sts 8975 8975 0 0.00 0 36609 314 0 0
sp_qd_handle_on_reserve_upd_sts 8232 8232 0 0.00 0 23418 77 0 0
sp_reserve_write_off 8234 8234 0 0.00 6 23447 214 0 0
sp_supplier_invoice 4504 4504 0 0.00 7 97382 3190 0 0
sp_supplier_order 4588 4588 0 0.00 4 44760 1381 0 0
srv_aggregate_perf_data 92 92 0 0.00 2031 132170 14108 0 0
srv_fill_mon_cache_memory 55 55 0 0.00 2028 136792 40305 0 0
srv_find_qd_qs_mism 906375 906375 0 0.00 0 9547 6 0 0
srv_make_invnt_saldo 476 476 0 0.00 32 43061 1105 0 0
srv_make_money_saldo 677 677 0 0.00 0 758 24 0 0
srv_recalc_idx_stat 3 3 0 0.00 211370 332062 262682 0 0
t$perf-abend:sp_add_invoice_to_stock 80 80 0 0.00 0 0 0 0 0
t$perf-abend:sp_cancel_supplier_invoice 6 6 0 0.00 0 0 0 0 0
t$perf-norm:sp_add_invoice_to_stock 4134 4134 0 0.00 0 13871 167 0 0
t$perf-norm:sp_cancel_adding_invoice 339 339 0 0.00 0 2003 86 0 0
t$perf-norm:sp_cancel_client_order 1475 1475 0 0.00 0 4814 17 0 0
t$perf-norm:sp_cancel_customer_reserve 545 545 0 0.00 0 4159 16 0 0
t$perf-norm:sp_cancel_pay_from_customer 616 616 0 0.00 0 3922 13 0 0
t$perf-norm:sp_cancel_pay_to_supplier 365 365 0 0.00 0 2174 8 0 0
t$perf-norm:sp_cancel_supplier_invoice 320 320 0 0.00 0 5139 35 0 0
t$perf-norm:sp_cancel_supplier_order 382 382 0 0.00 0 22601 1769 0 0
t$perf-norm:sp_cancel_write_off 814 814 0 0.00 0 3151 12 0 0
t$perf-norm:sp_client_order 17269 17269 0 0.00 0 9467 17 0 0
t$perf-norm:sp_customer_reserve 797 797 0 0.00 0 1893 10 0 0
t$perf-norm:sp_pay_from_customer 5955 5955 0 0.00 0 6095 8 0 0
t$perf-norm:sp_pay_to_supplier 4859 4859 0 0.00 0 3901 14 0 0
t$perf-norm:sp_reserve_write_off 8234 8234 0 0.00 0 7304 12 0 0
t$perf-norm:sp_supplier_invoice 4504 4504 0 0.00 0 12908 24 0 0
t$perf-norm:sp_supplier_order 4588 4588 0 0.00 0 5560 14 0 0
t$perf-norm:srv_aggregate_perf_data 92 92 0 0.00 0 282 6 0 0
t$perf-norm:srv_fill_mon_cache_memory 55 55 0 0.00 0 64 3 0 0
t$perf-norm:srv_make_invnt_saldo 476 476 0 0.00 0 625 18 0 0
t$perf-norm:srv_make_money_saldo 677 677 0 0.00 0 624 15 0 0
t$perf-norm:srv_recalc_idx_stat 3 3 0 0.00 1 65 23 0 0
v_add_invoice_to_stock 8410 8250 160 1.90 0 6364 19 0 160
v_all_customers 32218 32218 0 0.00 0 18 1 0 0
v_all_suppliers 25702 25702 0 0.00 0 23 1 0 0
v_all_wares 34530 34530 0 0.00 0 78 1 0 0
v_cancel_adding_invoice 678 678 0 0.00 0 1067 8 0 0
v_cancel_client_order 2950 2950 0 0.00 0 5880 11 0 0
v_cancel_customer_prepayment 1232 1232 0 0.00 0 4566 7 0 0
v_cancel_customer_reserve 1090 1090 0 0.00 0 787 4 0 0
v_cancel_payment_to_supplier 730 730 0 0.00 0 3190 7 0 0
v_cancel_supplier_invoice 652 640 12 1.84 0 204 12 0 12
v_cancel_supplier_order 764 764 0 0.00 0 6369 24 0 0
v_cancel_write_off 1628 1628 0 0.00 0 1491 14 0 0
v_max_id_clo_ord 4587 4587 0 0.00 0 416 1 0 0
v_max_id_clo_res 797 797 0 0.00 0 4524 18 0 0
v_max_id_ord_sup 4492 4492 0 0.00 0 3409 5 0 0
v_max_non_paid_invoice 1087 1087 0 0.00 0 603 3 0 0
v_max_non_paid_realizn 2847 2847 0 0.00 0 723 4 0 0
v_min_id_clo_ord 4587 4587 0 0.00 0 4776 7 0 0
v_min_id_clo_res 797 797 0 0.00 0 1184 7 0 0
v_min_id_ord_sup 4492 4492 0 0.00 0 6409 8 0 0
v_min_non_paid_invoice 4859 4859 0 0.00 0 6347 18 0 0
v_min_non_paid_realizn 5954 5954 0 0.00 0 17569 33 0 0
v_our_firm 8526 8526 0 0.00 0 17 1 0 0
v_reserve_write_off 16464 16464 0 0.00 0 6159 6 0 0
x_lock_depdocs_on_canc_invoice 9855 9855 0 0.00 0 31420 130 0 0
x_lock_depdocs_on_canc_sup_ord 382 382 0 0.00 0 15023 454 0 0
x_make_qstorno_1000_1200 4588 4588 0 0.00 2 44741 1310 0 0
x_make_qstorno_1200_2000 4504 4504 0 0.00 3 97350 3060 0 0
x_make_qstorno_2100_3300 402847 402847 0 0.00 0 54553 177 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 23-02-2024 22:10:39 to 23-02-2024 22:10:43.

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:37 2 8192000000 8797116768 8807743488 3953616 0.048 1 1 2 0 4051888 55488 42784
20:10:38 18901 8192000000 9884176720 10193965056 972429696 10.610 100 85 170 0 1000318640 5737792 22151152
20:12:10 16144 8192000000 9944271552 10265493504 1024734160 11.118 100 89 178 0 1055380176 7885856 22760160
20:13:35 26140 8192000000 9981800576 10316173312 1063991584 11.495 100 86 172 0 1094882720 9139136 21752000
20:15:13 8240 8192000000 10033420672 10382651392 1120384096 12.031 100 75 150 0 1148766320 10142128 18240096
20:16:29 6721 8192000000 10085735936 10446614528 1177127376 12.563 100 83 164 1 1207852304 11648176 19076752
20:17:37 2659 8192000000 10121906096 10494246912 1214262624 12.909 100 83 166 0 1245494336 12379904 18851808
20:18:42 2342 8192000000 10164279312 10540064768 1249056976 13.230 100 85 169 0 1281942880 14468672 18417232
20:19:47 1877 8192000000 10190250560 10572881920 1277000176 13.486 100 82 164 0 1309573184 14361456 18211552
20:20:52 1158 8192000000 10208747504 10592972800 1293498464 13.636 100 89 176 0 1325921392 12397536 20025392
20:21:55 24359 8192000000 10189024048 10599907328 1297960736 13.677 100 51 98 0 1318097808 9125552 11011520
20:23:22 10817 8192000000 10196625488 10610454528 1311334368 13.798 100 25 50 1 1322697136 5774144 5588624
20:24:33 11842 8192000000 10197740144 10618118144 1319060752 13.868 100 15 28 0 1327783040 5817072 2905216
20:25:51 15749 8192000000 10210389856 10629480448 1326678864 13.937 100 25 49 2 1338333488 5307216 6347408
20:27:10 35304 8192000000 10223031248 10644774912 1329072480 13.959 100 22 44 0 1339396624 5545360 4778784
20:28:45 2260 8192000000 10232996464 10651684864 1334268784 14.006 100 40 81 0 1349487728 5354768 9864176
20:29:51 30937 8192000000 10219833200 10634985472 1314900368 13.831 99 39 79 1 1331273808 6710256 9663184
20:31:29 32597 8192000000 10246761696 10657857536 1326138416 13.932 99 51 102 1 1347899616 10675280 11085920
20:33:03 82035 8192000000 10236001088 10651668480 1322870704 13.903 98 29 58 0 1341589584 11996144 6722736
20:35:30 35051 8192000000 10225108384 10641469440 1274738832 13.465 94 31 62 0 1296896992 14241888 7916272
20:37:15 9232 8192000000 10246839888 10657636352 1339276688 14.051 100 51 100 0 1363041200 12005024 11759488
20:38:39 15524 8192000000 10260532512 10668638208 1334344192 14.006 100 44 88 0 1365519744 20688352 10487200
20:40:03 15217 8192000000 10260942688 10666041344 1307346912 13.762 97 51 101 0 1342874432 23726384 11801136
20:41:28 8235 8192000000 10262283712 10661711872 1318280992 13.861 99 60 119 1 1358350320 25238720 14830608
20:42:44 6655 8192000000 10251107776 10648403968 1317749888 13.856 100 65 129 1 1363317888 29831552 15736448
20:43:56 2860 8192000000 10277623216 10677772288 1338560496 14.044 100 62 118 0 1383043280 29178016 15304768
20:45:05 2935 8192000000 10298064608 10700414976 1360737936 14.244 100 79 154 1 1408215840 29025536 18452368
20:46:11 2027 8192000000 10311822736 10711355392 1366624048 14.297 100 73 146 0 1416311760 31990224 17697488
20:47:18 9481 8192000000 10322730400 10731266048 1376409472 14.384 100 74 146 0 1433308944 37522144 19377328
20:48:32 5935 8192000000 10347931600 10757283840 1392994064 14.533 100 72 143 1 1451659216 41166704 17498448
20:49:40 5664 8192000000 10341840144 10758971392 1404387408 14.634 100 56 109 2 1446475600 28372576 13715616
20:50:49 7780 8192000000 10344582464 10764648448 1392237520 14.526 99 43 86 0 1439037312 35402784 11397008
20:52:01 14884 8192000000 10323246192 10752851968 1377266752 14.392 99 33 66 0 1423596160 37204192 9125216
20:53:24 34613 8192000000 10312948064 10763427840 1382657776 14.440 100 24 46 0 1432971424 43629792 6683856
20:55:04 55807 8192000000 10282624880 10730708992 1361091648 14.247 99 12 25 0 1392294032 28299696 2902688
20:57:02 19569 8192000000 10286512896 10729607168 1378638208 14.404 100 16 32 0 1394458768 12088960 3731600
20:58:30 31946 8192000000 10306472160 10736300032 1372004528 14.345 99 46 92 0 1391236112 8613712 10617872
21:00:05 82055 8192000000 10308708736 10752602112 1388922064 14.496 100 46 93 1 1411079696 11889568 10268064
21:02:38 46070 8192000000 10287284208 10739388416 1389618512 14.502 100 21 41 0 1405891456 11710400 4562544
21:05:00 25191 8192000000 10338430768 10775965696 1410855888 14.692 100 44 88 1 1436493232 15274912 10362432
21:06:29 62562 8192000000 10320888112 10771406848 1410962032 14.692 100 19 38 1 1430850656 15310560 4578064
21:08:59 11396 8192000000 10325232864 10775732224 1417409888 14.750 100 33 66 0 1439398384 14434848 7553648
21:10:28 83755 8192000000 10322437888 10780438528 1421474080 14.786 100 20 40 0 1434120208 7943792 4702336
21:12:56 47025 8192000000 10336291872 10799570944 1418194032 14.757 99 18 36 0 1438390640 15916912 4279696
21:14:44 60441 8192000000 10333677504 10783735808 1379965344 14.416 97 27 53 1 1404582656 18618560 5998752
21:16:46 54713 8192000000 10313959184 10775601152 1398256544 14.579 99 18 36 0 1417885184 15172112 4456528
21:18:50 16629 8192000000 10318506816 10759127040 1380469872 14.421 98 41 83 0 1403074352 13495184 9109296
21:20:16 76252 8192000000 10286693392 10737651712 1345102208 14.103 98 15 29 1 1366869168 18157040 3609920
21:22:43 105371 8192000000 10264435104 10706890752 1278905072 13.503 92 13 26 1 1305898608 23606656 3386880
21:25:35 136791 8192000000 10264685152 10716442624 1320583056 13.882 97 36 72 0 1344534688 15848640 8102992
21:29:29 19329 8192000000 10285010624 10728034304 1367084976 14.301 100 35 68 1 1394540608 19543152 7912480
21:30:53 62649 8192000000 10240297136 10690351104 1313319072 13.816 96 9 18 0 1331249328 15502480 2427776
21:33:32 50353 8192000000 10259898352 10711973888 1334797120 14.010 98 7 14 0 1358081040 21560688 1723232
21:35:40 36964 8192000000 10251100144 10699325440 1326562224 13.936 98 39 78 0 1344643888 9682112 8399552
21:37:30 72246 8192000000 10238169104 10698481664 1311574416 13.800 97 14 28 0 1324425728 9716800 3134512
21:39:43 46769 8192000000 10247936144 10689757184 1300128848 13.696 96 28 56 0 1317445824 10421440 6895536
21:41:31 85603 8192000000 10289794320 10733379584 1359919536 14.237 99 9 19 1 1380076864 18148960 2008368
21:44:00 34030 8192000000 10279793840 10718601216 1345603168 14.108 98 27 54 0 1361873888 9912624 6358096
21:45:36 53856 8192000000 10281535552 10735108096 1375988064 14.381 100 12 24 0 1392917984 13958016 2971904
21:47:47 29258 8192000000 10305790016 10747904000 1387904384 14.487 100 30 60 0 1405368960 10800080 6664496
21:49:16 37831 8192000000 10305860416 10749378560 1379544016 14.412 99 41 82 0 1402471872 14182576 8745280
21:50:55 6222 8192000000 10317591920 10756718592 1400612480 14.600 100 52 106 0 1421989616 10170496 11206640
21:52:04 57084 8192000000 10328293776 10778959872 1410491856 14.688 100 40 81 2 1435788912 16301344 8995712
21:54:36 53678 8192000000 10311899184 10789310464 1406938256 14.657 100 9 18 0 1427577072 19142032 1496784
21:56:31 41299 8192000000 10299308304 10762842112 1387915776 14.487 98 12 24 1 1398423456 7633568 2874112
21:58:27 57788 8192000000 10293995200 10755026944 1382931744 14.443 98 15 31 0 1395155200 8578224 3645232
22:01:16 65146 8192000000 10303972064 10771927040 1397492256 14.573 99 8 16 0 1407451520 8263872 1695392
22:03:29 31415 8192000000 10292068224 10741579776 1364244528 14.275 98 25 48 2 1376747600 7033280 5469792
22:05:16 35779 8192000000 10300215296 10756128768 1371474368 14.340 98 27 55 0 1392424576 15104464 5845744
22:07:00 82783 8192000000 10271408848 10725847040 1301880064 13.712 94 15 30 0 1318342944 12886880 3576000
22:09:23 19416 8192000000 9195658704 9441972224 348200784 4.077 27 4 8 0 360089648 10949568 939296

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:14, from 23-02-2024 22:10:45 to 23-02-2024 22:10:59.

Exceptions occured during test was in run

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

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

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          172395
MON$OLDEST_ACTIVE               172396
MON$OLDEST_SNAPSHOT             172396
MON$NEXT_TRANSACTION            172396
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                       1901344
MON$STAT_ID                     1
MON$BACKUP_STATE                0
MON$CRYPT_PAGE                  0
MON$OWNER                       SYSDBA                                                                                       
MON$SEC_DATABASE                Default


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

Database statistics 

 
Database "/home/bases/oltp30-etalone.fdb" 
Gstat execution time Fri Feb 23 22:11:03 2024 
 
Database header page information: 
    Flags            0 
    Generation        89821 
    System Change Number    0 
    Page size        8192 
    ODS version        12.0 
    Oldest transaction    172395 
    Oldest active        172396 
    Oldest snapshot        172396 
    Next transaction    172397 
    Sequence number        0 
    Next attachment ID    706 
    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.10, total records: 7738875 
    Average version length: 48.16, total versions: 127124, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 64.00, compression ratio: 1.36 
    Pointer pages: 54, data page slots: 86664 
    Data pages: 86664, average fill: 71% 
    Primary pages: 86664, secondary pages: 0, swept pages: 14588 
    Empty pages: 2, full pages: 70607 
    Fill distribution: 
     0 - 19% = 17 
    20 - 39% = 254 
    40 - 59% = 3237 
    60 - 79% = 83107 
    80 - 99% = 49 
 
    Index DOC_DATA_DOC_WARE_UNQ (0) 
    Root page: 1510614, depth: 3, leaf buckets: 23313, nodes: 7738875 
    Average node length: 18.87, total dup: 0, max dup: 0 
    Average key length: 15.88, compression ratio: 1.70 
    Average prefix length: 14.12, average data length: 12.88 
    Clustering factor: 1720844, ratio: 0.22 
    Fill distribution: 
         0 - 19% = 348 
        20 - 39% = 1677 
        40 - 59% = 4339 
        60 - 79% = 2557 
        80 - 99% = 14392 
 
    Index DOC_DATA_ID_DESC (1) 
    Root page: 1528118, depth: 3, leaf buckets: 13531, nodes: 7738875 
    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: 1543289, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 1441 
        40 - 59% = 2212 
        60 - 79% = 1181 
        80 - 99% = 8697 
 
    Index FK_DOC_DATA_DOC_LIST (2) 
    Root page: 1546711, depth: 3, leaf buckets: 8342, nodes: 7738875 
    Average node length: 6.61, total dup: 5798971, max dup: 49 
    Average key length: 3.62, compression ratio: 2.49 
    Average prefix length: 7.63, average data length: 1.37 
    Clustering factor: 1536373, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 125 
        20 - 39% = 869 
        40 - 59% = 1496 
        60 - 79% = 1028 
        80 - 99% = 4824 
 
DOC_LIST (138) 
    Primary pointer page: 472, Index root page: 473 
    Total formats: 1, used formats: 1 
    Average record length: 55.81, total records: 2229090 
    Average version length: 34.57, total versions: 124940, max versions: 4 
    Average fragment length: 3.50, total fragments: 2, max fragments: 1 
    Average unpacked length: 84.00, compression ratio: 1.51 
    Pointer pages: 18, data page slots: 28256 
    Data pages: 28256, average fill: 73% 
    Primary pages: 28248, secondary pages: 8, swept pages: 7427 
    Empty pages: 7, full pages: 21649 
    Fill distribution: 
     0 - 19% = 28 
    20 - 39% = 185 
    40 - 59% = 1988 
    60 - 79% = 24740 
    80 - 99% = 1315 
 
    Index DOC_LIST_ID_DESC (1) 
    Root page: 1541130, depth: 3, leaf buckets: 4559, nodes: 2229090 
    Average node length: 11.41, total dup: 0, max dup: 0 
    Average key length: 8.45, compression ratio: 1.07 
    Average prefix length: 3.55, average data length: 5.45 
    Clustering factor: 687641, ratio: 0.31 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 854 
        40 - 59% = 929 
        60 - 79% = 846 
        80 - 99% = 1930 
 
    Index DOC_LIST_WORKER_OPTYPE (2) 
    Root page: 1544376, depth: 3, leaf buckets: 2493, nodes: 2231995 
    Average node length: 4.97, total dup: 2231096, max dup: 18120 
    Average key length: 2.01, compression ratio: 4.47 
    Average prefix length: 8.99, average data length: 0.01 
    Clustering factor: 1245308, ratio: 0.56 
    Fill distribution: 
         0 - 19% = 3 
        20 - 39% = 247 
        40 - 59% = 1513 
        60 - 79% = 538 
        80 - 99% = 192 
 
    Index FK_DOC_LIST_AGENTS (3) 
    Root page: 1545909, depth: 3, leaf buckets: 2000, nodes: 2229090 
    Average node length: 4.97, total dup: 2229040, max dup: 130196 
    Average key length: 2.01, compression ratio: 4.48 
    Average prefix length: 8.99, average data length: 0.01 
    Clustering factor: 1051167, ratio: 0.47 
    Fill distribution: 
         0 - 19% = 4 
        20 - 39% = 130 
        40 - 59% = 956 
        60 - 79% = 63 
        80 - 99% = 847 
 
    Index PK_DOC_LIST (0) 
    Root page: 1538187, depth: 3, leaf buckets: 4335, nodes: 2229090 
    Average node length: 11.41, total dup: 0, max dup: 0 
    Average key length: 8.45, compression ratio: 1.07 
    Average prefix length: 3.55, average data length: 5.45 
    Clustering factor: 687641, ratio: 0.31 
    Fill distribution: 
         0 - 19% = 110 
        20 - 39% = 540 
        40 - 59% = 642 
        60 - 79% = 920 
        80 - 99% = 2123 
 
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.42, total records: 400 
    Average version length: 23.15, total versions: 236554, max versions: 619 
    Average fragment length: 2.00, total fragments: 46, max fragments: 1 
    Average unpacked length: 104.00, compression ratio: 1.26 
    Pointer pages: 1, data page slots: 1320 
    Data pages: 1320, average fill: 90% 
    Primary pages: 11, secondary pages: 1309, swept pages: 0 
    Empty pages: 4, full pages: 1315 
    Fill distribution: 
     0 - 19% = 4 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 2 
    80 - 99% = 1314 
 
    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: 19.38, total records: 113026 
    Average version length: 68.29, total versions: 80953, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 88.00, compression ratio: 4.54 
    Pointer pages: 6, data page slots: 2048 
    Data pages: 1816, average fill: 75% 
    Primary pages: 1815, secondary pages: 1, swept pages: 0 
    Empty pages: 169, full pages: 1462 
    Fill distribution: 
     0 - 19% = 211 
    20 - 39% = 40 
    40 - 59% = 55 
    60 - 79% = 323 
    80 - 99% = 1187 
 
    Index INVNT_TURNOVER_LOG_WARE_DD_ID (0) 
    Root page: 1707961, depth: 3, leaf buckets: 306, nodes: 113026 
    Average node length: 13.52, total dup: 8533, max dup: 2 
    Average key length: 10.62, compression ratio: 2.54 
    Average prefix length: 19.31, average data length: 7.69 
    Clustering factor: 82710, ratio: 0.73 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 1 
        40 - 59% = 187 
        60 - 79% = 47 
        80 - 99% = 70 
 
MONEY_SALDO (141) 
    Primary pointer page: 478, Index root page: 479 
    Total formats: 1, used formats: 1 
    Average record length: 15.22, total records: 49 
    Average version length: 9.00, total versions: 18161, max versions: 943 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 32.00, compression ratio: 2.10 
    Pointer pages: 1, data page slots: 64 
    Data pages: 64, average fill: 91% 
    Primary pages: 1, secondary pages: 63, swept pages: 0 
    Empty pages: 0, full pages: 63 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 1 
    60 - 79% = 1 
    80 - 99% = 62 
 
    Index PK_MONEY_SALDO (0) 
    Root page: 1510361, depth: 1, leaf buckets: 1, nodes: 49 
    Average node length: 11.82, total dup: 0, max dup: 0 
    Average key length: 10.80, compression ratio: 0.83 
    Average prefix length: 1.18, average data length: 7.82 
    Clustering factor: 1, ratio: 0.02 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
MONEY_TURNOVER_LOG (140) 
    Primary pointer page: 476, Index root page: 477 
    Total formats: 1, used formats: 1 
    Average record length: 6.50, total records: 1100 
    Average version length: 43.24, total versions: 941, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 58.00, compression ratio: 8.92 
    Pointer pages: 1, data page slots: 24 
    Data pages: 21, average fill: 50% 
    Primary pages: 19, secondary pages: 2, swept pages: 0 
    Empty pages: 4, full pages: 8 
    Fill distribution: 
     0 - 19% = 5 
    20 - 39% = 2 
    40 - 59% = 5 
    60 - 79% = 2 
    80 - 99% = 7 
 
    Index MONEY_TURNOVER_LOG_AGENT_OPTYPE (0) 
    Root page: 89925, depth: 2, leaf buckets: 2, nodes: 1100 
    Average node length: 4.55, total dup: 1003, max dup: 139 
    Average key length: 2.94, compression ratio: 6.46 
    Average prefix length: 18.15, average data length: 0.85 
    Clustering factor: 569, ratio: 0.52 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 2 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
MON_CACHE_MEMORY (165) 
    Primary pointer page: 526, Index root page: 527 
    Total formats: 2, used formats: 1 
    Average record length: 97.14, total records: 71 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 112.00, compression ratio: 1.15 
    Pointer pages: 1, data page slots: 2 
    Data pages: 2, average fill: 50% 
    Primary pages: 2, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 1 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 1 
 
    Index PK_MON_CACHE_MEMORY (0) 
    Root page: 1504215, depth: 1, leaf buckets: 1, nodes: 71 
    Average node length: 11.70, total dup: 0, max dup: 0 
    Average key length: 10.69, compression ratio: 0.84 
    Average prefix length: 1.30, average data length: 7.70 
    Clustering factor: 2, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
MON_LOG (162) 
    Primary pointer page: 520, Index root page: 521 
    Total formats: 2, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index MON_LOG_DTS (4) 
    Root page: 1504229, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index MON_LOG_GDSCODE (2) 
    Root page: 1504227, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index MON_LOG_ROWSET_DESC (1) 
    Root page: 1504226, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index MON_LOG_UNIT (3) 
    Root page: 1504228, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PK_MON_LOG (0) 
    Root page: 1504225, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
MON_LOG_TABLE_STATS (163) 
    Primary pointer page: 522, Index root page: 523 
    Total formats: 2, used formats: 1 
    Average record length: 67.13, total records: 30 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 611.00, compression ratio: 9.10 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 31% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 1 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index MON_LOG_TABLE_STATS_DTS (4) 
    Root page: 1504224, depth: 1, leaf buckets: 1, nodes: 30 
    Average node length: 3.50, total dup: 23, max dup: 4 
    Average key length: 2.47, compression ratio: 3.24 
    Average prefix length: 7.53, average data length: 0.47 
    Clustering factor: 1, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index MON_LOG_TABLE_STATS_GDSCODE (2) 
    Root page: 1504222, depth: 1, leaf buckets: 1, nodes: 30 
    Average node length: 2.00, total dup: 29, max dup: 29 
    Average key length: 1.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 1, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index MON_LOG_TABLE_STATS_ROWSET (1) 
    Root page: 1504221, depth: 1, leaf buckets: 1, nodes: 30 
    Average node length: 3.33, total dup: 29, max dup: 29 
    Average key length: 2.30, compression ratio: 3.91 
    Average prefix length: 8.70, average data length: 0.30 
    Clustering factor: 1, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index MON_LOG_TABLE_STATS_TN_UNIT (3) 
    Root page: 1504223, depth: 1, leaf buckets: 1, nodes: 30 
    Average node length: 12.90, total dup: 0, max dup: 0 
    Average key length: 11.87, compression ratio: 1.42 
    Average prefix length: 7.63, average data length: 9.20 
    Clustering factor: 1, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PK_MON_LOG_TABLE_STATS (0) 
    Root page: 1504220, depth: 1, leaf buckets: 1, nodes: 30 
    Average node length: 8.37, total dup: 0, max dup: 0 
    Average key length: 7.33, compression ratio: 1.23 
    Average prefix length: 4.63, average data length: 4.37 
    Clustering factor: 1, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
OPTYPES (136) 
    Primary pointer page: 468, Index root page: 469 
    Total formats: 2, used formats: 1 
    Average record length: 67.56, total records: 9 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 386.00, compression ratio: 5.71 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 9% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index OPTYPES_MCODE_UNQ (1) 
    Root page: 1544805, depth: 1, leaf buckets: 1, nodes: 9 
    Average node length: 8.56, total dup: 0, max dup: 0 
    Average key length: 6.89, compression ratio: 0.73 
    Average prefix length: 0.44, average data length: 4.56 
    Clustering factor: 1, ratio: 0.11 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PK_OPTYPES (0) 
    Root page: 1544804, depth: 1, leaf buckets: 1, nodes: 9 
    Average node length: 6.11, total dup: 0, max dup: 0 
    Average key length: 5.00, compression ratio: 0.60 
    Average prefix length: 0.89, average data length: 2.11 
    Clustering factor: 1, ratio: 0.11 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
PDISTR (146) 
    Primary pointer page: 488, Index root page: 489 
    Total formats: 1, used formats: 1 
    Average record length: 36.11, total records: 857747 
    Average version length: 25.20, total versions: 73081, 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: 6, data page slots: 8376 
    Data pages: 8376, average fill: 72% 
    Primary pages: 8364, secondary pages: 12, swept pages: 1043 
    Empty pages: 12, full pages: 7732 
    Fill distribution: 
     0 - 19% = 23 
    20 - 39% = 22 
    40 - 59% = 62 
    60 - 79% = 8028 
    80 - 99% = 241 
 
    Index PDISTR_AGENT_ID (2) 
    Root page: 1509308, depth: 2, leaf buckets: 935, nodes: 857747 
    Average node length: 4.88, total dup: 857698, max dup: 160451 
    Average key length: 2.01, compression ratio: 4.48 
    Average prefix length: 8.99, average data length: 0.01 
    Clustering factor: 94055, ratio: 0.11 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 128 
        40 - 59% = 520 
        60 - 79% = 214 
        80 - 99% = 72 
 
    Index PDISTR_SNDOP_RCVOP_SNDID_ASC (0) 
    Root page: 1508613, depth: 3, leaf buckets: 1044, nodes: 857747 
    Average node length: 5.88, total dup: 763857, max dup: 42 
    Average key length: 3.02, compression ratio: 7.29 
    Average prefix length: 21.09, average data length: 0.91 
    Clustering factor: 171176, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 77 
        40 - 59% = 620 
        60 - 79% = 97 
        80 - 99% = 248 
 
    Index PDISTR_SNDOP_RCVOP_SNDID_DESC (1) 
    Root page: 1509187, depth: 3, leaf buckets: 1094, nodes: 857747 
    Average node length: 5.89, total dup: 763857, max dup: 42 
    Average key length: 3.02, compression ratio: 7.29 
    Average prefix length: 21.09, average data length: 0.91 
    Clustering factor: 173092, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 177 
        40 - 59% = 599 
        60 - 79% = 77 
        80 - 99% = 241 
 
    Index PDISTR_WORKER_SND_ID (3) 
    Root page: 1510178, depth: 3, leaf buckets: 1163, nodes: 857747 
    Average node length: 5.97, total dup: 763857, max dup: 42 
    Average key length: 3.10, compression ratio: 5.49 
    Average prefix length: 16.01, average data length: 0.99 
    Clustering factor: 165447, ratio: 0.19 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 206 
        40 - 59% = 600 
        60 - 79% = 241 
        80 - 99% = 114 
 
PERF_AGG (158) 
    Primary pointer page: 512, Index root page: 513 
    Total formats: 1, used formats: 1 
    Average record length: 62.76, total records: 5423 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 2.59, total fragments: 49, max fragments: 1 
    Average unpacked length: 379.00, compression ratio: 6.04 
    Pointer pages: 1, data page slots: 104 
    Data pages: 104, average fill: 52% 
    Primary pages: 85, secondary pages: 19, swept pages: 50 
    Empty pages: 19, full pages: 63 
    Fill distribution: 
     0 - 19% = 34 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 69 
    80 - 99% = 1 
 
    Index PERF_AGG_UNQ (1) 
    Root page: 1504238, depth: 2, leaf buckets: 6, nodes: 5423 
    Average node length: 5.50, total dup: 0, max dup: 0 
    Average key length: 3.58, compression ratio: 10.01 
    Average prefix length: 34.34, average data length: 1.55 
    Clustering factor: 5158, ratio: 0.95 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 0 
        40 - 59% = 4 
        60 - 79% = 1 
        80 - 99% = 1 
 
    Index PK_PERF_AGG (0) 
    Root page: 1504233, depth: 2, leaf buckets: 10, nodes: 5423 
    Average node length: 11.12, total dup: 0, max dup: 0 
    Average key length: 9.21, compression ratio: 0.98 
    Average prefix length: 2.79, average data length: 6.21 
    Clustering factor: 158, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 1 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 7 
 
PERF_ESTIMATED (280) 
    Primary pointer page: 1504218, Index root page: 1504219 
    Total formats: 1, used formats: 1 
    Average record length: 39.12, total records: 78723 
    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: 760 
    Data pages: 760, average fill: 71% 
    Primary pages: 760, secondary pages: 0, swept pages: 0 
    Empty pages: 1, full pages: 758 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 0 
    40 - 59% = 1 
    60 - 79% = 758 
    80 - 99% = 0 
 
    Index PK_PERF_ESTIMATED (0) 
    Root page: 35428, depth: 2, leaf buckets: 100, nodes: 78723 
    Average node length: 10.17, total dup: 0, max dup: 0 
    Average key length: 8.19, compression ratio: 1.10 
    Average prefix length: 3.81, average data length: 5.19 
    Clustering factor: 3248, ratio: 0.04 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 1 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 99 
 
PERF_ISQL_STAT (156) 
    Primary pointer page: 508, Index root page: 509 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index PERF_ISQL_STAT_TRN (0) 
    Root page: 1504239, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
PERF_LOG (159) 
    Primary pointer page: 514, Index root page: 515 
    Total formats: 1, used formats: 1 
    Average record length: 111.22, total records: 72 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1691.00, compression ratio: 15.20 
    Pointer pages: 1, data page slots: 2 
    Data pages: 2, average fill: 57% 
    Primary pages: 2, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 1 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 1 
    40 - 59% = 0 
    60 - 79% = 1 
    80 - 99% = 0 
 
PERF_SPLIT_0 (281) 
    Primary pointer page: 573, Index root page: 574 
    Total formats: 1, used formats: 1 
    Average record length: 135.26, total records: 185370 
    Average version length: 155.04, total versions: 19430, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 12.54 
    Pointer pages: 8, data page slots: 5128 
    Data pages: 4488, average fill: 86% 
    Primary pages: 4488, secondary pages: 0, swept pages: 1 
    Empty pages: 71, full pages: 4390 
    Fill distribution: 
     0 - 19% = 75 
    20 - 39% = 4 
    40 - 59% = 8 
    60 - 79% = 10 
    80 - 99% = 4391 
 
PERF_SPLIT_1 (282) 
    Primary pointer page: 576, Index root page: 577 
    Total formats: 1, used formats: 1 
    Average record length: 129.37, total records: 183620 
    Average version length: 154.90, total versions: 26132, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 13.11 
    Pointer pages: 6, data page slots: 4648 
    Data pages: 4424, average fill: 87% 
    Primary pages: 4423, secondary pages: 1, swept pages: 2 
    Empty pages: 52, full pages: 4351 
    Fill distribution: 
     0 - 19% = 56 
    20 - 39% = 6 
    40 - 59% = 7 
    60 - 79% = 4 
    80 - 99% = 4351 
 
PERF_SPLIT_2 (283) 
    Primary pointer page: 578, Index root page: 579 
    Total formats: 1, used formats: 1 
    Average record length: 148.82, total records: 185226 
    Average version length: 153.05, total versions: 2978, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.40 
    Pointer pages: 7, data page slots: 5688 
    Data pages: 4456, average fill: 86% 
    Primary pages: 4456, secondary pages: 0, swept pages: 5 
    Empty pages: 49, full pages: 4385 
    Fill distribution: 
     0 - 19% = 52 
    20 - 39% = 10 
    40 - 59% = 2 
    60 - 79% = 6 
    80 - 99% = 4386 
 
PERF_SPLIT_3 (284) 
    Primary pointer page: 580, Index root page: 581 
    Total formats: 1, used formats: 1 
    Average record length: 149.83, total records: 170394 
    Average version length: 150.95, total versions: 1303, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.32 
    Pointer pages: 8, data page slots: 4632 
    Data pages: 4064, average fill: 86% 
    Primary pages: 4064, secondary pages: 0, swept pages: 2 
    Empty pages: 21, full pages: 4029 
    Fill distribution: 
     0 - 19% = 23 
    20 - 39% = 6 
    40 - 59% = 2 
    60 - 79% = 4 
    80 - 99% = 4029 
 
PERF_SPLIT_4 (285) 
    Primary pointer page: 582, Index root page: 583 
    Total formats: 1, used formats: 1 
    Average record length: 149.44, total records: 152870 
    Average version length: 151.39, total versions: 1605, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.35 
    Pointer pages: 6, data page slots: 4744 
    Data pages: 3704, average fill: 85% 
    Primary pages: 3704, secondary pages: 0, swept pages: 2 
    Empty pages: 71, full pages: 3616 
    Fill distribution: 
     0 - 19% = 72 
    20 - 39% = 12 
    40 - 59% = 3 
    60 - 79% = 1 
    80 - 99% = 3616 
 
PERF_SPLIT_5 (286) 
    Primary pointer page: 584, Index root page: 585 
    Total formats: 1, used formats: 1 
    Average record length: 149.01, total records: 157922 
    Average version length: 150.95, total versions: 1659, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.38 
    Pointer pages: 7, data page slots: 5328 
    Data pages: 3776, average fill: 86% 
    Primary pages: 3776, secondary pages: 0, swept pages: 2 
    Empty pages: 36, full pages: 3728 
    Fill distribution: 
     0 - 19% = 37 
    20 - 39% = 5 
    40 - 59% = 5 
    60 - 79% = 1 
    80 - 99% = 3728 
 
PERF_SPLIT_6 (287) 
    Primary pointer page: 586, Index root page: 587 
    Total formats: 1, used formats: 1 
    Average record length: 148.12, total records: 168414 
    Average version length: 152.77, total versions: 3133, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.45 
    Pointer pages: 6, data page slots: 4128 
    Data pages: 4016, average fill: 86% 
    Primary pages: 4016, secondary pages: 0, swept pages: 2 
    Empty pages: 21, full pages: 3982 
    Fill distribution: 
     0 - 19% = 23 
    20 - 39% = 3 
    40 - 59% = 5 
    60 - 79% = 4 
    80 - 99% = 3981 
 
PERF_SPLIT_7 (288) 
    Primary pointer page: 588, Index root page: 589 
    Total formats: 1, used formats: 1 
    Average record length: 150.54, total records: 168884 
    Average version length: 140.58, total versions: 414, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.27 
    Pointer pages: 8, data page slots: 4416 
    Data pages: 4032, average fill: 86% 
    Primary pages: 4032, secondary pages: 0, swept pages: 1 
    Empty pages: 27, full pages: 3993 
    Fill distribution: 
     0 - 19% = 29 
    20 - 39% = 7 
    40 - 59% = 2 
    60 - 79% = 1 
    80 - 99% = 3993 
 
PERF_SPLIT_8 (289) 
    Primary pointer page: 590, Index root page: 591 
    Total formats: 1, used formats: 1 
    Average record length: 148.99, total records: 167304 
    Average version length: 152.01, total versions: 2222, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.38 
    Pointer pages: 7, data page slots: 5520 
    Data pages: 4008, average fill: 86% 
    Primary pages: 4008, secondary pages: 0, swept pages: 2 
    Empty pages: 35, full pages: 3956 
    Fill distribution: 
     0 - 19% = 39 
    20 - 39% = 5 
    40 - 59% = 2 
    60 - 79% = 6 
    80 - 99% = 3956 
 
PERF_SPLIT_9 (290) 
    Primary pointer page: 593, Index root page: 594 
    Total formats: 1, used formats: 1 
    Average record length: 149.04, total records: 166695 
    Average version length: 152.01, total versions: 2156, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.38 
    Pointer pages: 7, data page slots: 4168 
    Data pages: 3976, average fill: 86% 
    Primary pages: 3976, secondary pages: 0, swept pages: 2 
    Empty pages: 17, full pages: 3941 
    Fill distribution: 
     0 - 19% = 21 
    20 - 39% = 3 
    40 - 59% = 8 
    60 - 79% = 3 
    80 - 99% = 3941 
 
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.19, total records: 2075034 
    Average version length: 52.88, total versions: 61306, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 70.00, compression ratio: 1.37 
    Pointer pages: 16, data page slots: 25256 
    Data pages: 25256, average fill: 71% 
    Primary pages: 25256, secondary pages: 0, swept pages: 9836 
    Empty pages: 306, full pages: 20440 
    Fill distribution: 
     0 - 19% = 584 
    20 - 39% = 419 
    40 - 59% = 1189 
    60 - 79% = 22508 
    80 - 99% = 556 
 
    Index PSTORNED_RCV_ID (1) 
    Root page: 1506186, depth: 3, leaf buckets: 2533, nodes: 2075034 
    Average node length: 5.44, total dup: 1935601, max dup: 1554 
    Average key length: 2.49, compression ratio: 3.62 
    Average prefix length: 8.58, average data length: 0.42 
    Clustering factor: 180697, ratio: 0.09 
    Fill distribution: 
         0 - 19% = 3 
        20 - 39% = 327 
        40 - 59% = 1557 
        60 - 79% = 326 
        80 - 99% = 320 
 
    Index PSTORNED_SND_ID (0) 
    Root page: 1504819, depth: 3, leaf buckets: 2752, nodes: 2075034 
    Average node length: 5.69, total dup: 1862359, max dup: 70 
    Average key length: 2.74, compression ratio: 3.29 
    Average prefix length: 8.36, average data length: 0.64 
    Clustering factor: 371925, ratio: 0.18 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 9 
        40 - 59% = 2497 
        60 - 79% = 216 
        80 - 99% = 30 
 
    Index PSTORNED_WORKER_ID (2) 
    Root page: 1507996, depth: 3, leaf buckets: 2135, nodes: 2075034 
    Average node length: 4.96, total dup: 2074934, max dup: 28065 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.41, average data length: 0.00 
    Clustering factor: 178510, ratio: 0.09 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 210 
        40 - 59% = 1146 
        60 - 79% = 412 
        80 - 99% = 366 
 
RULES_FOR_PDISTR (148) 
    Primary pointer page: 492, Index root page: 493 
    Total formats: 1, used formats: 1 
    Average record length: 17.00, total records: 4 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 334.00, compression ratio: 19.65 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 2% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index RULES_FOR_PDISTR_UNQ (0) 
    Root page: 1504317, depth: 1, leaf buckets: 1, nodes: 4 
    Average node length: 11.50, total dup: 0, max dup: 0 
    Average key length: 10.25, compression ratio: 0.88 
    Average prefix length: 1.50, average data length: 7.50 
    Clustering factor: 1, ratio: 0.25 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
RULES_FOR_QDISTR (137) 
    Primary pointer page: 470, Index root page: 471 
    Total formats: 1, used formats: 1 
    Average record length: 32.71, total records: 7 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 332.00, compression ratio: 10.15 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 4% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index RULES_FOR_QDISTR_RCVOP (1) 
    Root page: 1544803, depth: 1, leaf buckets: 1, nodes: 7 
    Average node length: 5.29, total dup: 2, max dup: 2 
    Average key length: 4.14, compression ratio: 0.72 
    Average prefix length: 1.43, average data length: 1.57 
    Clustering factor: 1, ratio: 0.14 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index RULES_FOR_QDISTR_UNQ (0) 
    Root page: 1544802, depth: 1, leaf buckets: 1, nodes: 7 
    Average node length: 10.14, total dup: 0, max dup: 0 
    Average key length: 8.86, compression ratio: 0.94 
    Average prefix length: 2.14, average data length: 6.14 
    Clustering factor: 1, ratio: 0.14 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
SEMAPHORES (152) 
    Primary pointer page: 500, Index root page: 501 
    Total formats: 1, used formats: 1 
    Average record length: 43.40, total records: 5 
    Average version length: 9.00, total versions: 1, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 346.00, compression ratio: 7.97 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 4% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index PK_SEMAPHORES (0) 
    Root page: 1504305, depth: 1, leaf buckets: 1, nodes: 5 
    Average node length: 12.40, total dup: 0, max dup: 0 
    Average key length: 11.00, compression ratio: 0.82 
    Average prefix length: 0.60, average data length: 8.40 
    Clustering factor: 1, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index SEMAPHORES_TASK_UNQ (1) 
    Root page: 1504306, depth: 1, leaf buckets: 1, nodes: 5 
    Average node length: 23.40, total dup: 0, max dup: 0 
    Average key length: 22.00, compression ratio: 1.07 
    Average prefix length: 4.20, average data length: 19.40 
    Clustering factor: 1, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
SETTINGS (135) 
    Primary pointer page: 466, Index root page: 467 
    Total formats: 1, used formats: 1 
    Average record length: 97.63, total records: 149 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1347.00, compression ratio: 13.80 
    Pointer pages: 1, data page slots: 3 
    Data pages: 3, average fill: 70% 
    Primary pages: 3, secondary pages: 0, swept pages: 1 
    Empty pages: 0, full pages: 2 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 1 
    60 - 79% = 0 
    80 - 99% = 2 
 
    Index SETTINGS_MCODE_WM_UNQ (1) 
    Root page: 525, depth: 1, leaf buckets: 1, nodes: 149 
    Average node length: 14.66, total dup: 0, max dup: 0 
    Average key length: 13.55, compression ratio: 2.19 
    Average prefix length: 19.07, average data length: 10.66 
    Clustering factor: 48, ratio: 0.32 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 1 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index SETTINGS_MODE_CODE (0) 
    Root page: 1544806, depth: 1, leaf buckets: 1, nodes: 149 
    Average node length: 25.56, total dup: 0, max dup: 0 
    Average key length: 24.56, compression ratio: 1.63 
    Average prefix length: 18.58, average data length: 21.56 
    Clustering factor: 14, ratio: 0.09 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 0 
        40 - 59% = 1 
        60 - 79% = 0 
        80 - 99% = 0 
 
TMP$DEP_DOCS (129) 
    Primary pointer page: 454, Index root page: 455 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index TMP_DEP_DOCS_UNQ (0) 
    Root page: 1544810, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
TMP$IDX_RECALC (132) 
    Primary pointer page: 460, Index root page: 461 
    Total formats: 2, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index TMP_IDX_RECALC_IDX_NAME_UNQ (0) 
    Root page: 1544807, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
TMP$MON_LOG (133) 
    Primary pointer page: 462, Index root page: 463 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
TMP$MON_LOG_TABLE_STATS (134) 
    Primary pointer page: 464, Index root page: 465 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
TMP$PERF_EST_WHOLE (161) 
    Primary pointer page: 518, Index root page: 519 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
TMP$PERF_LOG (160) 
    Primary pointer page: 516, Index root page: 517 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index TMP$PERF_LOG_UNIT_TRN_DTS_END (0) 
    Root page: 1504230, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
TMP$PERF_MON (131) 
    Primary pointer page: 458, Index root page: 459 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
TMP$RESULT_SET (130) 
    Primary pointer page: 456, Index root page: 457 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index TMP_RESULT_SET_DOC (1) 
    Root page: 1544809, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index TMP_RESULT_SET_WARE_DOC (0) 
    Root page: 1544808, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
TMP$SHOPPING_CART (128) 
    Primary pointer page: 452, Index root page: 453 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index TMP_SHOPCART_UNQ (0) 
    Root page: 1544811, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
TPAUSE (166) 
    Primary pointer page: 528, Index root page: 529 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index RDB$PRIMARY2 (0) 
    Root page: 1504214, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
TRACE_STAT (157) 
    Primary pointer page: 510, Index root page: 511 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
WARES (142) 
    Primary pointer page: 480, Index root page: 481 
    Total formats: 1, used formats: 1 
    Average record length: 77.52, total records: 400 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 444.00, compression ratio: 5.73 
    Pointer pages: 1, data page slots: 6 
    Data pages: 6, average fill: 77% 
    Primary pages: 6, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 5 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 5 
    80 - 99% = 1 
 
    Index FK_WARES_WARE_GROUPS (3) 
    Root page: 1552159, depth: 1, leaf buckets: 1, nodes: 400 
    Average node length: 3.17, total dup: 392, max dup: 60 
    Average key length: 2.16, compression ratio: 4.16 
    Average prefix length: 8.86, average data length: 0.14 
    Clustering factor: 48, ratio: 0.12 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PK_WARES (0) 
    Root page: 1510355, depth: 1, leaf buckets: 1, nodes: 400 
    Average node length: 11.22, total dup: 0, max dup: 0 
    Average key length: 10.22, compression ratio: 0.88 
    Average prefix length: 1.78, average data length: 7.22 
    Clustering factor: 344, ratio: 0.86 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 0 
        40 - 59% = 1 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index WARES_ID_DESC (2) 
    Root page: 1510360, depth: 1, leaf buckets: 1, nodes: 400 
    Average node length: 11.22, total dup: 0, max dup: 0 
    Average key length: 10.22, compression ratio: 0.88 
    Average prefix length: 1.78, average data length: 7.22 
    Clustering factor: 344, ratio: 0.86 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 0 
        40 - 59% = 1 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index WARES_NUMB_UNQ (1) 
    Root page: 1510358, depth: 2, leaf buckets: 3, nodes: 400 
    Average node length: 53.25, total dup: 0, max dup: 0 
    Average key length: 52.23, compression ratio: 1.00 
    Average prefix length: 2.74, average data length: 49.25 
    Clustering factor: 355, ratio: 0.89 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 1 
        80 - 99% = 2 
 
WARE_GROUPS (151) 
    Primary pointer page: 498, Index root page: 499 
    Total formats: 1, used formats: 1 
    Average record length: 32.12, total records: 8 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 346.00, compression ratio: 10.77 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 5% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index PK_WARE_GROUPS (0) 
    Root page: 1504307, depth: 1, leaf buckets: 1, nodes: 8 
    Average node length: 11.25, total dup: 0, max dup: 0 
    Average key length: 10.12, compression ratio: 0.89 
    Average prefix length: 1.75, average data length: 7.25 
    Clustering factor: 1, ratio: 0.12 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index WARE_GROUPS_NAME_UNQ (1) 
    Root page: 1504308, depth: 1, leaf buckets: 1, nodes: 8 
    Average node length: 19.88, total dup: 0, max dup: 0 
    Average key length: 18.12, compression ratio: 0.89 
    Average prefix length: 0.25, average data length: 15.88 
    Clustering factor: 1, ratio: 0.12 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
XQD_1000_1200 (176) 
    Primary pointer page: 549, Index root page: 550 
    Total formats: 1, used formats: 1 
    Average record length: 36.51, total records: 155772 
    Average version length: 69.18, total versions: 73633, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 3.45 
    Pointer pages: 3, data page slots: 3920 
    Data pages: 3128, average fill: 58% 
    Primary pages: 3128, secondary pages: 0, swept pages: 433 
    Empty pages: 615, full pages: 2043 
    Fill distribution: 
     0 - 19% = 824 
    20 - 39% = 91 
    40 - 59% = 79 
    60 - 79% = 805 
    80 - 99% = 1329 
 
    Index XQD_1000_1200_WA_SO_RO_WKR_SND (0) 
    Root page: 105742, depth: 3, leaf buckets: 244, nodes: 155772 
    Average node length: 6.45, total dup: 135434, max dup: 14 
    Average key length: 3.94, compression ratio: 10.66 
    Average prefix length: 40.19, average data length: 1.81 
    Clustering factor: 27225, ratio: 0.17 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 51 
        40 - 59% = 128 
        60 - 79% = 57 
        80 - 99% = 8 
 
XQD_1000_3300 (178) 
    Primary pointer page: 553, Index root page: 554 
    Total formats: 1, used formats: 1 
    Average record length: 63.64, total records: 7513360 
    Average version length: 68.76, total versions: 579163, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.98 
    Pointer pages: 65, data page slots: 105280 
    Data pages: 105280, average fill: 76% 
    Primary pages: 105280, secondary pages: 0, swept pages: 15411 
    Empty pages: 24, full pages: 97365 
    Fill distribution: 
     0 - 19% = 205 
    20 - 39% = 867 
    40 - 59% = 2413 
    60 - 79% = 88408 
    80 - 99% = 13387 
 
    Index XQD_1000_3300_WA_SO_RO_WKR_SND (0) 
    Root page: 1480454, depth: 3, leaf buckets: 10835, nodes: 7513360 
    Average node length: 6.51, total dup: 6500185, max dup: 41 
    Average key length: 3.52, compression ratio: 11.95 
    Average prefix length: 40.62, average data length: 1.38 
    Clustering factor: 1652304, ratio: 0.22 
    Fill distribution: 
         0 - 19% = 4 
        20 - 39% = 1229 
        40 - 59% = 5584 
        60 - 79% = 3336 
        80 - 99% = 682 
 
    Index XQD_1000_3300_WKR_DOC_ASC (1) 
    Root page: 1486068, depth: 3, leaf buckets: 8798, nodes: 7513360 
    Average node length: 5.39, total dup: 7223159, max dup: 226 
    Average key length: 2.39, compression ratio: 7.10 
    Average prefix length: 16.64, average data length: 0.36 
    Clustering factor: 1444315, ratio: 0.19 
    Fill distribution: 
         0 - 19% = 11 
        20 - 39% = 1021 
        40 - 59% = 4784 
        60 - 79% = 1811 
        80 - 99% = 1171 
 
    Index XQD_1000_3300_WKR_DOC_DEC (2) 
    Root page: 1490608, depth: 3, leaf buckets: 8819, nodes: 7513360 
    Average node length: 5.39, total dup: 7223159, max dup: 226 
    Average key length: 2.39, compression ratio: 7.10 
    Average prefix length: 16.64, average data length: 0.36 
    Clustering factor: 1446910, ratio: 0.19 
    Fill distribution: 
         0 - 19% = 5 
        20 - 39% = 1028 
        40 - 59% = 4755 
        60 - 79% = 1833 
        80 - 99% = 1198 
 
XQD_1200_2000 (177) 
    Primary pointer page: 551, Index root page: 552 
    Total formats: 1, used formats: 1 
    Average record length: 66.46, total records: 12477222 
    Average version length: 68.70, total versions: 450805, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.90 
    Pointer pages: 105, data page slots: 170848 
    Data pages: 170848, average fill: 78% 
    Primary pages: 170848, secondary pages: 0, swept pages: 64174 
    Empty pages: 4, full pages: 170674 
    Fill distribution: 
     0 - 19% = 4 
    20 - 39% = 0 
    40 - 59% = 18 
    60 - 79% = 159606 
    80 - 99% = 11220 
 
    Index XQD_1200_2000_WA_SO_RO_WKR_SND (0) 
    Root page: 1495028, depth: 3, leaf buckets: 18383, nodes: 12477222 
    Average node length: 6.60, total dup: 10874352, max dup: 65 
    Average key length: 3.43, compression ratio: 12.26 
    Average prefix length: 40.70, average data length: 1.30 
    Clustering factor: 2429469, ratio: 0.19 
    Fill distribution: 
         0 - 19% = 35 
        20 - 39% = 1743 
        40 - 59% = 10238 
        60 - 79% = 5311 
        80 - 99% = 1056 
 
XQD_2000_3300 (179) 
    Primary pointer page: 555, Index root page: 556 
    Total formats: 1, used formats: 1 
    Average record length: 36.04, total records: 1858090 
    Average version length: 69.12, total versions: 889636, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 3.50 
    Pointer pages: 26, data page slots: 41104 
    Data pages: 28328, average fill: 76% 
    Primary pages: 28328, secondary pages: 0, swept pages: 3196 
    Empty pages: 1317, full pages: 23819 
    Fill distribution: 
     0 - 19% = 1957 
    20 - 39% = 889 
    40 - 59% = 953 
    60 - 79% = 9939 
    80 - 99% = 14590 
 
    Index XQD_2000_3300_WA_SO_RO_WKR_SND (0) 
    Root page: 1479712, depth: 3, leaf buckets: 2248, nodes: 1858090 
    Average node length: 5.50, total dup: 1783443, max dup: 99 
    Average key length: 2.55, compression ratio: 16.50 
    Average prefix length: 41.49, average data length: 0.51 
    Clustering factor: 122892, ratio: 0.07 
    Fill distribution: 
         0 - 19% = 11 
        20 - 39% = 269 
        40 - 59% = 1110 
        60 - 79% = 629 
        80 - 99% = 229 
 
XQD_2100_3300 (180) 
    Primary pointer page: 557, Index root page: 558 
    Total formats: 1, used formats: 1 
    Average record length: 36.89, total records: 1160181 
    Average version length: 69.13, total versions: 540151, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 3.42 
    Pointer pages: 20, data page slots: 31912 
    Data pages: 27224, average fill: 50% 
    Primary pages: 27224, secondary pages: 0, swept pages: 5633 
    Empty pages: 5895, full pages: 13548 
    Fill distribution: 
     0 - 19% = 9630 
    20 - 39% = 1383 
    40 - 59% = 1033 
    60 - 79% = 5979 
    80 - 99% = 9199 
 
    Index XQD_2100_3300_WA_SO_RO_WKR_SND (0) 
    Root page: 1479207, depth: 3, leaf buckets: 1556, nodes: 1160181 
    Average node length: 5.78, total dup: 1083965, max dup: 99 
    Average key length: 2.85, compression ratio: 14.76 
    Average prefix length: 41.22, average data length: 0.78 
    Clustering factor: 156286, ratio: 0.13 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 306 
        40 - 59% = 753 
        60 - 79% = 384 
        80 - 99% = 113 
 
XQD_3300_3400 (181) 
    Primary pointer page: 559, Index root page: 560 
    Total formats: 1, used formats: 1 
    Average record length: 64.41, total records: 9118991 
    Average version length: 68.99, total versions: 593721, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.96 
    Pointer pages: 87, data page slots: 141824 
    Data pages: 141800, average fill: 69% 
    Primary pages: 141798, secondary pages: 2, swept pages: 42541 
    Empty pages: 523, full pages: 86531 
    Fill distribution: 
     0 - 19% = 1466 
    20 - 39% = 7277 
    40 - 59% = 22203 
    60 - 79% = 99431 
    80 - 99% = 11423 
 
    Index XQD_3300_3400_WA_SO_RO_WKR_SND (0) 
    Root page: 1472590, depth: 3, leaf buckets: 13421, nodes: 9118991 
    Average node length: 6.67, total dup: 7567671, max dup: 29 
    Average key length: 3.66, compression ratio: 11.47 
    Average prefix length: 40.51, average data length: 1.49 
    Clustering factor: 1989445, ratio: 0.22 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 1452 
        40 - 59% = 6826 
        60 - 79% = 4465 
        80 - 99% = 677 
 
XQS_1000_1200 (182) 
    Primary pointer page: 561, Index root page: 562 
    Total formats: 1, used formats: 1 
    Average record length: 82.47, total records: 21144713 
    Average version length: 82.99, total versions: 18437, 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: 318648 
    Data pages: 318648, average fill: 81% 
    Primary pages: 318648, secondary pages: 0, swept pages: 12159 
    Empty pages: 39, full pages: 318114 
    Fill distribution: 
     0 - 19% = 51 
    20 - 39% = 25 
    40 - 59% = 71 
    60 - 79% = 27307 
    80 - 99% = 291194 
 
    Index XQS_1000_1200_DOC_ID (1) 
    Root page: 1426716, depth: 3, leaf buckets: 19512, nodes: 21144713 
    Average node length: 5.72, total dup: 20663828, max dup: 143 
    Average key length: 2.16, compression ratio: 4.16 
    Average prefix length: 8.86, average data length: 0.14 
    Clustering factor: 3280019, ratio: 0.16 
    Fill distribution: 
         0 - 19% = 5 
        20 - 39% = 0 
        40 - 59% = 8409 
        60 - 79% = 557 
        80 - 99% = 10541 
 
    Index XQS_1000_1200_RCV_ID (3) 
    Root page: 1456980, depth: 3, leaf buckets: 17129, nodes: 21144713 
    Average node length: 6.31, total dup: 18583967, max dup: 49 
    Average key length: 2.75, compression ratio: 3.27 
    Average prefix length: 8.37, average data length: 0.63 
    Clustering factor: 911647, ratio: 0.04 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 3 
        40 - 59% = 728 
        60 - 79% = 248 
        80 - 99% = 16149 
 
    Index XQS_1000_1200_SND_ID (2) 
    Root page: 1441073, depth: 3, leaf buckets: 21346, nodes: 21144713 
    Average node length: 6.35, total dup: 18500914, max dup: 29 
    Average key length: 2.79, compression ratio: 3.23 
    Average prefix length: 8.34, average data length: 0.66 
    Clustering factor: 3573375, ratio: 0.17 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 0 
        40 - 59% = 8812 
        60 - 79% = 587 
        80 - 99% = 11945 
 
    Index XQS_1000_1200_WORKER_ID (0) 
    Root page: 1413348, depth: 3, leaf buckets: 16040, nodes: 21144713 
    Average node length: 5.56, total dup: 21144613, max dup: 229087 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.42, average data length: 0.00 
    Clustering factor: 940615, ratio: 0.04 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 11 
        40 - 59% = 2778 
        60 - 79% = 380 
        80 - 99% = 12870 
 
XQS_1000_3300 (184) 
    Primary pointer page: 565, Index root page: 566 
    Total formats: 1, used formats: 1 
    Average record length: 76.84, total records: 9626637 
    Average version length: 82.63, total versions: 649363, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.64 
    Pointer pages: 104, data page slots: 168880 
    Data pages: 168880, average fill: 71% 
    Primary pages: 168880, secondary pages: 0, swept pages: 57418 
    Empty pages: 821, full pages: 103397 
    Fill distribution: 
     0 - 19% = 2183 
    20 - 39% = 7721 
    40 - 59% = 24878 
    60 - 79% = 64088 
    80 - 99% = 70010 
 
    Index XQS_1000_3300_DOC_ID (1) 
    Root page: 1367502, depth: 3, leaf buckets: 11332, nodes: 9626637 
    Average node length: 5.36, total dup: 9319291, max dup: 243 
    Average key length: 2.23, compression ratio: 4.03 
    Average prefix length: 8.80, average data length: 0.20 
    Clustering factor: 2122219, ratio: 0.22 
    Fill distribution: 
         0 - 19% = 3 
        20 - 39% = 73 
        40 - 59% = 8349 
        60 - 79% = 2834 
        80 - 99% = 73 
 
    Index XQS_1000_3300_RCV_ID (3) 
    Root page: 1379261, depth: 3, leaf buckets: 13521, nodes: 9626637 
    Average node length: 6.23, total dup: 7982753, max dup: 14 
    Average key length: 3.10, compression ratio: 2.90 
    Average prefix length: 8.07, average data length: 0.93 
    Clustering factor: 1476591, ratio: 0.15 
    Fill distribution: 
         0 - 19% = 139 
        20 - 39% = 3690 
        40 - 59% = 4810 
        60 - 79% = 2711 
        80 - 99% = 2171 
 
    Index XQS_1000_3300_SND_ID (2) 
    Root page: 1373059, depth: 3, leaf buckets: 12652, nodes: 9626637 
    Average node length: 5.98, total dup: 8357582, max dup: 55 
    Average key length: 2.85, compression ratio: 3.16 
    Average prefix length: 8.28, average data length: 0.72 
    Clustering factor: 2320057, ratio: 0.24 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 87 
        40 - 59% = 9397 
        60 - 79% = 3063 
        80 - 99% = 104 
 
    Index XQS_1000_3300_WORKER_ID (0) 
    Root page: 1362767, depth: 3, leaf buckets: 10109, nodes: 9626637 
    Average node length: 5.13, total dup: 9626537, max dup: 145718 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.42, average data length: 0.00 
    Clustering factor: 1498657, ratio: 0.16 
    Fill distribution: 
         0 - 19% = 40 
        20 - 39% = 1279 
        40 - 59% = 5044 
        60 - 79% = 1728 
        80 - 99% = 2018 
 
XQS_1200_2000 (183) 
    Primary pointer page: 563, Index root page: 564 
    Total formats: 1, used formats: 1 
    Average record length: 78.77, total records: 11151950 
    Average version length: 82.57, total versions: 475847, 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: 118, data page slots: 191912 
    Data pages: 190232, average fill: 72% 
    Primary pages: 190232, secondary pages: 0, swept pages: 68959 
    Empty pages: 3780, full pages: 139092 
    Fill distribution: 
     0 - 19% = 6388 
    20 - 39% = 8069 
    40 - 59% = 18673 
    60 - 79% = 42032 
    80 - 99% = 115070 
 
    Index XQS_1200_2000_DOC_ID (1) 
    Root page: 1392101, depth: 3, leaf buckets: 13123, nodes: 11151950 
    Average node length: 5.30, total dup: 11042306, max dup: 630 
    Average key length: 2.08, compression ratio: 4.32 
    Average prefix length: 8.93, average data length: 0.07 
    Clustering factor: 2317615, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 204 
        40 - 59% = 9354 
        60 - 79% = 3421 
        80 - 99% = 142 
 
    Index XQS_1200_2000_RCV_ID (3) 
    Root page: 1406110, depth: 3, leaf buckets: 10386, nodes: 11151950 
    Average node length: 5.50, total dup: 10665103, max dup: 49 
    Average key length: 2.28, compression ratio: 3.95 
    Average prefix length: 8.77, average data length: 0.23 
    Clustering factor: 694536, ratio: 0.06 
    Fill distribution: 
         0 - 19% = 151 
        20 - 39% = 835 
        40 - 59% = 2659 
        60 - 79% = 1871 
        80 - 99% = 4870 
 
    Index XQS_1200_2000_SND_ID (2) 
    Root page: 1398638, depth: 3, leaf buckets: 15013, nodes: 11151950 
    Average node length: 6.03, total dup: 9727186, max dup: 67 
    Average key length: 2.81, compression ratio: 3.21 
    Average prefix length: 8.32, average data length: 0.68 
    Clustering factor: 2334155, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 236 
        40 - 59% = 10911 
        60 - 79% = 3690 
        80 - 99% = 175 
 
    Index XQS_1200_2000_WORKER_ID (0) 
    Root page: 1386211, depth: 3, leaf buckets: 10667, nodes: 11151950 
    Average node length: 5.23, total dup: 11151850, max dup: 172453 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.42, average data length: 0.00 
    Clustering factor: 683106, ratio: 0.06 
    Fill distribution: 
         0 - 19% = 86 
        20 - 39% = 888 
        40 - 59% = 4756 
        60 - 79% = 1449 
        80 - 99% = 3488 
 
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: 77.34, total records: 9720962 
    Average version length: 82.94, total versions: 633343, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.63 
    Pointer pages: 107, data page slots: 173672 
    Data pages: 173640, average fill: 70% 
    Primary pages: 173640, secondary pages: 0, swept pages: 64821 
    Empty pages: 954, full pages: 100312 
    Fill distribution: 
     0 - 19% = 2511 
    20 - 39% = 9012 
    40 - 59% = 28453 
    60 - 79% = 66303 
    80 - 99% = 67361 
 
    Index XQS_2100_3300_DOC_ID (1) 
    Root page: 1344686, depth: 3, leaf buckets: 11664, nodes: 9720962 
    Average node length: 5.18, total dup: 9692192, max dup: 1563 
    Average key length: 2.03, compression ratio: 4.43 
    Average prefix length: 8.97, average data length: 0.03 
    Clustering factor: 1934217, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 34 
        20 - 39% = 1477 
        40 - 59% = 7551 
        60 - 79% = 1974 
        80 - 99% = 628 
 
    Index XQS_2100_3300_RCV_ID (3) 
    Root page: 1355717, depth: 3, leaf buckets: 13649, nodes: 9720962 
    Average node length: 6.25, total dup: 8060684, max dup: 14 
    Average key length: 3.10, compression ratio: 2.90 
    Average prefix length: 8.07, average data length: 0.93 
    Clustering factor: 1431396, ratio: 0.15 
    Fill distribution: 
         0 - 19% = 200 
        20 - 39% = 3614 
        40 - 59% = 4792 
        60 - 79% = 2757 
        80 - 99% = 2286 
 
    Index XQS_2100_3300_SND_ID (2) 
    Root page: 1350049, depth: 3, leaf buckets: 12313, nodes: 9720962 
    Average node length: 5.43, total dup: 9286530, max dup: 99 
    Average key length: 2.29, compression ratio: 3.94 
    Average prefix length: 8.76, average data length: 0.24 
    Clustering factor: 2067079, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 28 
        20 - 39% = 1514 
        40 - 59% = 8384 
        60 - 79% = 1773 
        80 - 99% = 614 
 
    Index XQS_2100_3300_WORKER_ID (0) 
    Root page: 985805, depth: 3, leaf buckets: 10231, nodes: 9720962 
    Average node length: 5.15, total dup: 9720862, max dup: 147678 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.42, average data length: 0.00 
    Clustering factor: 1516489, ratio: 0.16 
    Fill distribution: 
         0 - 19% = 42 
        20 - 39% = 1271 
        40 - 59% = 5188 
        60 - 79% = 1664 
        80 - 99% = 2066 
 
XQS_3300_3400 (187) 
    Primary pointer page: 571, Index root page: 572 
    Total formats: 1, used formats: 1 
    Average record length: 67.04, total records: 571772 
    Average version length: 68.83, total versions: 9423, 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: 5, data page slots: 7968 
    Data pages: 7968, average fill: 75% 
    Primary pages: 7968, secondary pages: 0, swept pages: 3340 
    Empty pages: 5, full pages: 6707 
    Fill distribution: 
     0 - 19% = 6 
    20 - 39% = 31 
    40 - 59% = 263 
    60 - 79% = 7532 
    80 - 99% = 136 
 
    Index XQS_3300_3400_DOC_ID (1) 
    Root page: 46805, depth: 3, leaf buckets: 727, nodes: 571772 
    Average node length: 5.95, total dup: 486753, max dup: 82 
    Average key length: 3.09, compression ratio: 2.91 
    Average prefix length: 8.06, average data length: 0.94 
    Clustering factor: 99513, ratio: 0.17 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 34 
        40 - 59% = 510 
        60 - 79% = 82 
        80 - 99% = 101 
 
    Index XQS_3300_3400_SND_ID (2) 
    Root page: 39534, depth: 3, leaf buckets: 747, nodes: 571772 
    Average node length: 6.15, total dup: 468790, max dup: 21 
    Average key length: 3.30, compression ratio: 2.73 
    Average prefix length: 7.88, average data length: 1.12 
    Clustering factor: 99563, ratio: 0.17 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 32 
        40 - 59% = 521 
        60 - 79% = 89 
        80 - 99% = 105 
 
    Index XQS_3300_3400_WORKER_ID (0) 
    Root page: 375548, depth: 2, leaf buckets: 584, nodes: 571772 
    Average node length: 4.86, total dup: 571672, max dup: 9420 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.42, average data length: 0.00 
    Clustering factor: 88365, ratio: 0.15 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 32 
        40 - 59% = 359 
        60 - 79% = 97 
        80 - 99% = 96 
 
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 Feb 23 22:11:26 2024

Record versions statistics, table

TABLE_NAME TOTAL_RECS TOTAL_VERS MAX_VERSIONS VERS_TO_RECS_PRC MAXV_TO_VERS_PRC
DOC_DATA 7738875 127124 1 0.0000 0.0000
DOC_LIST 2229090 124940 4 0.0000 0.0000
FB_ERRORS 2182 757 1 0.0000 0.0000
INVNT_SALDO 400 236554 619 59100.0000 0.0000
INVNT_TURNOVER_LOG 113026 80953 1 0.0000 0.0000
MONEY_SALDO 49 18161 943 37000.0000 0.0000
MONEY_TURNOVER_LOG 1100 941 1 0.0000 0.0000
PDISTR 857747 73081 4 0.0000 0.0000
PERF_SPLIT_0 185370 19430 1 0.0000 0.0000
PERF_SPLIT_1 183620 26132 1 0.0000 0.0000
PERF_SPLIT_2 185226 2978 1 0.0000 0.0000
PERF_SPLIT_3 170394 1303 1 0.0000 0.0000
PERF_SPLIT_4 152870 1605 1 0.0000 0.0000
PERF_SPLIT_5 157922 1659 1 0.0000 0.0000
PERF_SPLIT_6 168414 3133 1 0.0000 0.0000
PERF_SPLIT_7 168884 414 1 0.0000 0.0000
PERF_SPLIT_8 167304 2222 1 0.0000 0.0000
PERF_SPLIT_9 166695 2156 1 0.0000 0.0000
PSTORNED 2075034 61306 1 0.0000 0.0000
SEMAPHORES 5 1 1 0.0000 100.0000
XQD_1000_1200 155772 73633 1 0.0000 0.0000
XQD_1000_3300 7513360 579163 1 0.0000 0.0000
XQD_1200_2000 12477222 450805 1 0.0000 0.0000
XQD_2000_3300 1858090 889636 1 0.0000 0.0000
XQD_2100_3300 1160181 540151 1 0.0000 0.0000
XQD_3300_3400 9118991 593721 1 0.0000 0.0000
XQS_1000_1200 21144713 18437 1 0.0000 0.0000
XQS_1000_3300 9626637 649363 1 0.0000 0.0000
XQS_1200_2000 11151950 475847 1 0.0000 0.0000
XQS_2100_3300 9720962 633343 1 0.0000 0.0000
XQS_3300_3400 571772 9423 1 0.0000 0.0000

Record versions statistics, chart

Total records and versions, chart

Ratios versions / total_records and max_versions / total_versions

Database validation 


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

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

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

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

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