Generated by /opt/oltp-emul/oltp_isql_run_worker.sh, ISQL session No. 1 of total launched 100. 26.02.2024 01: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 15710556 kB
MemAvailable 30223916 kB
Buffers 0 kB
Cached 16007628 kB
SwapCached 2472 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-26 01:09:38
DTS_END                         2024-02-26 01:09:38.4970
FB_GDSCODE                      -1
FB_MNEMONA                      
STACK                           SP_RESERVE_WRITE_OFF(34:5) ==> SP_CHECK_TO_STOP_WORK(32:12) ==> SP_HALT_ON_ERROR(57:17)
IP                              ::1/40402
TRN_ID                          182368
ATT_ID                          612
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: 9410.05 21099 941005
customer order: creation 188.31 350 18831
customer order: refuse 15.97 371 1597
order to supplier: creation 48.03 1339 4803
order to supplier: removal 3.39 96357 339
invoice (draft): creation 48.96 3451 4896
invoice (draft): removal 47.67 831 4767
invoice accept: apply 45.09 21472 4509
invoice accept: cancel 43.42 926 4342
customer reserve: creation 4341.58 205 434158
customer reserve: removal 4323.05 58 432305
realization accept: apply 89.41 197 8941
realization accept: cancel 74.65 140 7465
payment from customer: creation 63.94 132 6394
payment from customer: removal 6.11 101 611
payment to supplier: creation 53.65 138 5365
payment to supplier: removal 3.76 83 376
service: total inventory turnovers 4.83 1153 483
service: total monetary turnovers 7.41 31 741
service: aggregate perf. data 0.79 25472 79
service: refresh index statistics 0.03 269172 3

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:02, from 26-02-2024 01:10:50 to 26-02-2024 01:10:52.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 5431
TEST_TIME 2 4874
TEST_TIME 3 3675
TEST_TIME 4 3727
TEST_TIME 5 4427
TEST_TIME 6 4724
TEST_TIME 7 4795
TEST_TIME 8 5543
TEST_TIME 9 6085
TEST_TIME 10 6213
TEST_TIME 11 6089
TEST_TIME 12 6438
TEST_TIME 13 6634
TEST_TIME 14 6517
TEST_TIME 15 6706
TEST_TIME 16 6976
TEST_TIME 17 7103
TEST_TIME 18 7331
TEST_TIME 19 7600
TEST_TIME 20 7678
TEST_TIME 21 7602
TEST_TIME 22 7902
TEST_TIME 23 8109
TEST_TIME 24 8039
TEST_TIME 25 8693
TEST_TIME 26 8725
TEST_TIME 27 8613
TEST_TIME 28 8825
TEST_TIME 29 9055
TEST_TIME 30 9572
TEST_TIME 31 9731
TEST_TIME 32 9812
TEST_TIME 33 9798
TEST_TIME 34 9933
TEST_TIME 35 9899
TEST_TIME 36 9778
TEST_TIME 37 9578
TEST_TIME 38 9700
TEST_TIME 39 9657
TEST_TIME 40 9580
TEST_TIME 41 9472
TEST_TIME 42 9511
TEST_TIME 43 9448
TEST_TIME 44 9430
TEST_TIME 45 9500
TEST_TIME 46 9485
TEST_TIME 47 9469
TEST_TIME 48 9386
TEST_TIME 49 9394
TEST_TIME 50 9327
TEST_TIME 51 9353
TEST_TIME 52 9256
TEST_TIME 53 9231
TEST_TIME 54 9206
TEST_TIME 55 9185
TEST_TIME 56 9193
TEST_TIME 57 9252
TEST_TIME 58 9264
TEST_TIME 59 9273
TEST_TIME 60 9333
TEST_TIME 61 9422
TEST_TIME 62 9429
TEST_TIME 63 9395
TEST_TIME 64 9425
TEST_TIME 65 9471
TEST_TIME 66 9541
TEST_TIME 67 9565
TEST_TIME 68 9522
TEST_TIME 69 9434
TEST_TIME 70 9467
TEST_TIME 71 9378
TEST_TIME 72 9394
TEST_TIME 73 9447
TEST_TIME 74 9409
TEST_TIME 75 9436
TEST_TIME 76 9397
TEST_TIME 77 9423
TEST_TIME 78 9358
TEST_TIME 79 9477
TEST_TIME 80 9490
TEST_TIME 81 9509
TEST_TIME 82 9540
TEST_TIME 83 9552
TEST_TIME 84 9635
TEST_TIME 85 9593
TEST_TIME 86 9648
TEST_TIME 87 9620
TEST_TIME 88 9591
TEST_TIME 89 9513
TEST_TIME 90 9532
TEST_TIME 91 9472
TEST_TIME 92 9479
TEST_TIME 93 9447
TEST_TIME 94 9396
TEST_TIME 95 9372
TEST_TIME 96 9305
TEST_TIME 97 9394
TEST_TIME 98 9445
TEST_TIME 99 9454
TEST_TIME 100 9415

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:04, from 26-02-2024 01:10:53 to 26-02-2024 01:10:57.

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 1336282 1336282 0 0.00 0 24938 7 0 0
doc_list_biud 1336280 1336280 0 0.00 0 29689 25 0 0
sp_add_invoice_to_stock 4671 4509 162 3.46 45 248482 21472 0 162
sp_cancel_adding_invoice 4342 4342 0 0.00 5 53537 926 0 0
sp_cancel_client_order 1597 1597 0 0.00 4 8763 372 0 0
sp_cancel_customer_reserve 432305 432305 0 0.00 0 29245 59 0 0
sp_cancel_pay_from_customer 611 611 0 0.00 3 5448 101 0 0
sp_cancel_pay_to_supplier 376 376 0 0.00 2 4595 83 0 0
sp_cancel_supplier_invoice 4784 4767 17 0.35 2 16417 832 0 17
sp_cancel_supplier_order 339 339 0 0.00 7 820814 96357 0 0
sp_cancel_write_off 7465 7465 0 0.00 1 29803 141 0 0
sp_client_order 18831 18831 0 0.00 3 26322 351 0 0
sp_customer_reserve 434158 434158 0 0.00 0 117745 205 0 0
sp_fill_shopping_cart 28516 28516 0 0.00 1 13654 39 0 0
sp_fill_shopping_cart_clo_res 434146 434146 0 0.00 0 14409 14 0 0
sp_get_clo_for_invoice 4497 4497 0 0.00 0 23611 296 0 0
sp_kill_cost_storno 12794 12794 0 0.00 0 7786 69 0 0
sp_kill_qstorno_ret_qs2qd 877181 877181 0 0.00 0 29688 32 0 0
sp_kill_qty_storno 464253 464253 0 0.00 0 29689 70 0 0
sp_lock_selected_doc 18549 18549 0 0.00 0 7838 6 0 0
sp_make_cost_storno 25197 25197 0 0.00 0 13810 60 0 0
sp_multiply_rows_for_pdistr 25197 25197 0 0.00 0 16948 36 0 0
sp_multiply_rows_for_qdistr 18829 18829 0 0.00 0 26307 151 0 0
sp_pay_from_customer 6394 6394 0 0.00 4 15163 133 0 0
sp_pay_to_supplier 5365 5365 0 0.00 5 16958 138 0 0
sp_payment_common 11759 11759 0 0.00 1 15148 40 0 0
sp_qd_handle_on_cancel_clo 1597 1597 0 0.00 0 8754 336 0 0
sp_qd_handle_on_invoice_upd_sts 8839 8839 0 0.00 0 22584 324 0 0
sp_qd_handle_on_reserve_upd_sts 8941 8941 0 0.00 0 17611 57 0 0
sp_reserve_write_off 8941 8941 0 0.00 6 17659 197 0 0
sp_supplier_invoice 4896 4896 0 0.00 6 80406 3451 0 0
sp_supplier_order 4803 4803 0 0.00 5 34650 1339 0 0
srv_aggregate_perf_data 79 79 0 0.00 2200 483663 25473 0 0
srv_fill_mon_cache_memory 58 58 0 0.00 1863 139537 36446 0 0
srv_find_qd_qs_mism 893905 893905 0 0.00 0 24937 7 0 0
srv_make_invnt_saldo 483 483 0 0.00 38 55765 1153 0 0
srv_make_money_saldo 741 741 0 0.00 0 1400 32 0 0
srv_recalc_idx_stat 3 3 0 0.00 194993 403527 269172 0 0
t$perf-abend:sp_add_invoice_to_stock 162 162 0 0.00 0 0 0 0 0
t$perf-abend:sp_cancel_supplier_invoice 17 17 0 0.00 0 0 0 0 0
t$perf-norm:sp_add_invoice_to_stock 4509 4509 0 0.00 0 11716 196 0 0
t$perf-norm:sp_cancel_adding_invoice 346 346 0 0.00 0 2773 88 0 0
t$perf-norm:sp_cancel_client_order 1597 1597 0 0.00 0 1776 13 0 0
t$perf-norm:sp_cancel_customer_reserve 584 584 0 0.00 0 831 10 0 0
t$perf-norm:sp_cancel_pay_from_customer 611 611 0 0.00 0 2562 13 0 0
t$perf-norm:sp_cancel_pay_to_supplier 376 376 0 0.00 0 808 6 0 0
t$perf-norm:sp_cancel_supplier_invoice 369 369 0 0.00 0 2116 17 0 0
t$perf-norm:sp_cancel_supplier_order 339 339 0 0.00 0 19267 1870 0 0
t$perf-norm:sp_cancel_write_off 891 891 0 0.00 0 2905 9 0 0
t$perf-norm:sp_client_order 18832 18832 0 0.00 0 16054 16 0 0
t$perf-norm:sp_customer_reserve 857 857 0 0.00 0 1231 10 0 0
t$perf-norm:sp_pay_from_customer 6394 6394 0 0.00 0 5464 12 0 0
t$perf-norm:sp_pay_to_supplier 5365 5365 0 0.00 0 3062 9 0 0
t$perf-norm:sp_reserve_write_off 8941 8941 0 0.00 0 15108 13 0 0
t$perf-norm:sp_supplier_invoice 4896 4896 0 0.00 0 8510 19 0 0
t$perf-norm:sp_supplier_order 4803 4803 0 0.00 0 15567 19 0 0
t$perf-norm:srv_aggregate_perf_data 79 79 0 0.00 0 110 4 0 0
t$perf-norm:srv_fill_mon_cache_memory 58 58 0 0.00 0 398 11 0 0
t$perf-norm:srv_make_invnt_saldo 483 483 0 0.00 0 580 17 0 0
t$perf-norm:srv_make_money_saldo 741 741 0 0.00 0 4888 35 0 0
t$perf-norm:srv_recalc_idx_stat 3 3 0 0.00 2 5 3 0 0
v_add_invoice_to_stock 9314 8990 324 3.47 0 9330 26 0 324
v_all_customers 34942 34942 0 0.00 0 39 1 0 0
v_all_suppliers 27792 27792 0 0.00 0 24 1 0 0
v_all_wares 37656 37656 0 0.00 0 43 1 0 0
v_cancel_adding_invoice 692 692 0 0.00 0 1747 10 0 0
v_cancel_client_order 3194 3194 0 0.00 0 6896 9 0 0
v_cancel_customer_prepayment 1222 1222 0 0.00 0 4109 12 0 0
v_cancel_customer_reserve 1168 1168 0 0.00 0 1858 7 0 0
v_cancel_payment_to_supplier 752 752 0 0.00 0 4587 9 0 0
v_cancel_supplier_invoice 772 738 34 4.40 0 5315 23 0 34
v_cancel_supplier_order 678 678 0 0.00 0 5052 17 0 0
v_cancel_write_off 1782 1782 0 0.00 0 4980 18 0 0
v_max_id_clo_ord 4800 4800 0 0.00 0 2324 4 0 0
v_max_id_clo_res 857 857 0 0.00 0 4428 13 0 0
v_max_id_ord_sup 4888 4888 0 0.00 0 8307 4 0 0
v_max_non_paid_invoice 1157 1157 0 0.00 0 395 3 0 0
v_max_non_paid_realizn 3159 3159 0 0.00 0 4351 6 0 0
v_min_id_clo_ord 4800 4800 0 0.00 0 4610 11 0 0
v_min_id_clo_res 857 857 0 0.00 0 5632 18 0 0
v_min_id_ord_sup 4888 4888 0 0.00 0 9938 14 0 0
v_min_non_paid_invoice 5365 5365 0 0.00 0 13358 24 0 0
v_min_non_paid_realizn 6394 6394 0 0.00 0 14035 35 0 0
v_our_firm 9184 9184 0 0.00 0 17 1 0 0
v_reserve_write_off 17882 17882 0 0.00 0 9113 10 0 0
x_lock_depdocs_on_canc_invoice 8740 8740 0 0.00 0 50671 165 0 0
x_lock_depdocs_on_canc_sup_ord 339 339 0 0.00 0 8684 376 0 0
x_make_qstorno_1000_1200 4803 4803 0 0.00 2 34638 1244 0 0
x_make_qstorno_1200_2000 4896 4896 0 0.00 3 78660 3320 0 0
x_make_qstorno_2100_3300 434158 434158 0 0.00 0 117742 188 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 26-02-2024 01:10:58 to 26-02-2024 01:11:02.

Memory consumption, metadata cache, attachments activity 

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


Page cache type: shared, buffers: 1000000 for all connections, with total size: 8192000000
measurement_dts measurement duration ms page cache memo used memo used, total memo allocated, total metadata cache metadata cache percent of total total attachments cnt active attachments cnt running statements cnt stalled statements cnt memo used by attachments memo used by transactions memo used by statements
23:09:42 2 8192000000 8797116768 8807743488 3953616 0.048 1 1 2 0 4051888 55488 42784
23:10:43 19137 8192000000 9887552400 10192789504 962780960 10.516 100 92 182 0 992783296 5066000 24936336
23:12:10 23175 8192000000 9938156544 10255523840 1020862528 11.080 100 92 184 0 1051724752 6951744 23910480
23:13:43 14541 8192000000 9974037408 10302754816 1057617344 11.434 100 91 182 0 1089391408 8879040 22895024
23:15:10 11890 8192000000 10036885984 10388111360 1123990000 12.065 100 79 157 1 1152336576 9999440 18347136
23:16:42 6178 8192000000 10099257936 10459316224 1184291728 12.630 100 87 174 0 1217617232 13782976 19542528
23:17:54 2174 8192000000 10136863632 10508349440 1225493984 13.012 100 84 168 2 1258055616 13469632 19092000
23:18:58 1342 8192000000 10169945216 10545811456 1257384528 13.306 100 95 192 1 1291427872 12601552 21441792
23:20:02 2300 8192000000 10188000224 10571558912 1280097328 13.514 100 80 158 0 1310791568 13137536 17556704
23:21:06 888 8192000000 10211414336 10601545728 1302526864 13.718 100 86 171 1 1333245680 11257840 19460976
23:22:08 2030 8192000000 10212118560 10608316416 1303886576 13.731 100 57 115 0 1324909008 7738944 13283488
23:23:10 4561 8192000000 10197650000 10609795072 1308285920 13.771 100 38 76 0 1325548688 8867600 8395168
23:24:15 6957 8192000000 10201432352 10618023936 1313599584 13.819 100 22 44 0 1326401280 7766848 5034848
23:25:25 7319 8192000000 10211026480 10626412544 1320140528 13.878 100 20 40 0 1331219088 6500128 4578432
23:26:33 65410 8192000000 10234499856 10641645568 1328747872 13.956 100 37 74 1 1343698848 6149728 8801248
23:28:39 2791 8192000000 10238021456 10648027136 1333504368 13.999 100 39 78 0 1352809664 10760992 8544304
23:29:47 2633 8192000000 10217919776 10618445824 1306837024 13.757 99 42 84 0 1321920704 6037456 9046224
23:31:00 5164 8192000000 10232966576 10640801792 1329372496 13.961 100 49 98 0 1348859616 8444608 11042512
23:32:10 52622 8192000000 10250105360 10663112704 1334114544 14.004 99 61 123 0 1358305088 10098320 14092224
23:34:07 44380 8192000000 10257362816 10679484416 1350982528 14.156 100 43 84 0 1374962368 14152208 9827632
23:36:09 8802 8192000000 10238429760 10642771968 1311008448 13.795 99 51 102 0 1340042848 17664416 11369984
23:37:21 3221 8192000000 10232039824 10636615680 1310771712 13.793 99 57 114 1 1342498304 18840224 12886368
23:38:27 4706 8192000000 10254777536 10665447424 1333049264 13.995 99 60 116 0 1361381232 14971808 13360160
23:39:36 16640 8192000000 10201342960 10595553280 1254578400 13.280 94 50 100 0 1284397072 18698160 11120512
23:40:58 16848 8192000000 10221490256 10620579840 1277698688 13.492 97 50 97 2 1310228752 20468064 12062000
23:42:18 6898 8192000000 10241711168 10643464192 1317972496 13.858 100 53 105 0 1349896768 19025920 12898352
23:43:43 4397 8192000000 10265998256 10667323392 1339122816 14.050 100 58 114 1 1372501504 20061584 13317104
23:44:53 1871 8192000000 10274254496 10677981184 1337128496 14.032 99 74 146 1 1377871408 22951664 17791248
23:46:00 1856 8192000000 10304981776 10705117184 1360634448 14.243 100 78 151 0 1408349808 29039440 18675920
23:47:06 5773 8192000000 10306683440 10712846336 1357923744 14.219 100 72 142 0 1411473168 36441840 17107584
23:48:19 5735 8192000000 10315155248 10719088640 1369551744 14.323 100 77 153 0 1421312464 33076912 18683808
23:49:27 23421 8192000000 10311224544 10724745216 1373048912 14.354 100 50 98 1 1413050592 27860848 12140832
23:51:08 3185 8192000000 10327695488 10744193024 1380978976 14.425 100 60 120 0 1431282464 35943056 14360432
23:52:16 9309 8192000000 10307988464 10735448064 1383146544 14.445 100 36 72 0 1418695008 26761840 8786624
23:53:31 7389 8192000000 10328123472 10754703360 1388284464 14.491 100 41 80 0 1429945088 31156272 10504352
23:54:42 14538 8192000000 10318968992 10764636160 1392289152 14.526 100 37 74 0 1439695600 37911408 9495040
23:56:31 24211 8192000000 10332188656 10770075648 1397467536 14.572 100 22 42 0 1440913456 37951792 5494128
23:58:05 18861 8192000000 10345698704 10779078656 1398563488 14.582 100 46 90 2 1439858400 30372032 10922880
00:00:12 27295 8192000000 10315818736 10776854528 1402349296 14.616 100 15 27 1 1426735824 21021376 3365152
00:01:43 29986 8192000000 10329653968 10778308608 1407122624 14.658 100 15 30 0 1428325328 17525376 3677328
00:03:20 70009 8192000000 10317248224 10773532672 1390774144 14.513 99 12 24 1 1421699216 27884080 3040992
00:05:46 75955 8192000000 10312124000 10768719872 1403938816 14.630 100 23 46 0 1421157472 11752112 5466544
00:08:03 24450 8192000000 10335194144 10779205632 1407481792 14.662 100 42 84 2 1427873984 11112416 9279776
00:09:30 62418 8192000000 10315749088 10753261568 1391022720 14.515 99 27 53 0 1403533792 6426496 6084576
00:11:33 3404 8192000000 10325950912 10769539072 1409366864 14.678 100 60 120 1 1436995216 14633072 12995280
00:12:41 4721 8192000000 10313222976 10743279616 1378480928 14.403 99 72 141 2 1410271760 15296672 16494160
00:13:50 29238 8192000000 10297011872 10754600960 1382030288 14.435 100 15 30 0 1410246784 24426960 3789536
00:15:21 139537 8192000000 10261662048 10709037056 1267940208 13.403 91 14 28 0 1279046480 7711824 3394448
00:19:25 30118 8192000000 10268979936 10708692992 1331130416 13.977 97 52 101 0 1350820176 8554208 11135552
00:20:58 73320 8192000000 10244420688 10700816384 1318746352 13.865 97 15 30 0 1332701312 10633408 3321552
00:23:17 49533 8192000000 10230444368 10674851840 1280720464 13.520 95 17 35 0 1291989600 7137728 4131408
00:25:24 30337 8192000000 10221806352 10658967552 1272691232 13.446 96 22 42 0 1284670176 7136192 4842752
00:26:59 38903 8192000000 10227269568 10669834240 1296888112 13.667 98 16 32 0 1313204848 12902496 3414240
00:28:39 19342 8192000000 10238593840 10674896896 1326214192 13.933 100 41 80 0 1348781312 13941472 8625648
00:30:00 78153 8192000000 10223230912 10672857088 1300678192 13.701 98 7 14 0 1315075840 12934160 1463488
00:32:26 13373 8192000000 10251578400 10679652352 1325373024 13.925 99 36 71 1 1343536272 10171920 7991328
00:33:43 16708 8192000000 10253407024 10683285504 1329764464 13.965 100 31 62 0 1350136208 13579136 6792608
00:35:01 48074 8192000000 10259698064 10701721600 1336823264 14.029 99 26 52 0 1354473808 12179056 5471488
00:36:50 69727 8192000000 10261860416 10706681856 1358743168 14.226 100 25 50 1 1372960336 8882784 5334384
00:39:24 80904 8192000000 10287591888 10736599040 1381240672 14.428 100 20 40 0 1401075200 15408192 4426336
00:41:46 45701 8192000000 10290797808 10750468096 1393626048 14.538 100 18 36 0 1412288608 15183616 3478944
00:43:34 38986 8192000000 10294164048 10754260992 1398411904 14.581 100 15 30 0 1412308080 10994448 2901728
00:45:13 44165 8192000000 10296549952 10751725568 1386642592 14.476 99 18 34 1 1398337712 7281808 4413312
00:46:58 51675 8192000000 10321302400 10761351168 1369419360 14.322 97 22 44 0 1390074080 15963888 4690832
00:48:59 89242 8192000000 10305851296 10771484672 1385228960 14.463 99 13 26 1 1402536528 14615920 2691648
00:51:30 36260 8192000000 10319954672 10759692288 1391590080 14.520 99 30 62 2 1406412896 6342416 8480400
00:53:14 60555 8192000000 10310521024 10773901312 1390418064 14.510 99 8 16 0 1406842320 14906832 1517424
00:55:22 60710 8192000000 10283924816 10730061824 1325578464 13.927 95 17 34 0 1338646512 9176000 3892048
00:57:25 113337 8192000000 10285698688 10743296000 1358823648 14.227 97 37 74 0 1379876944 12519440 8533856
01:00:18 45566 8192000000 10275962272 10728513536 1365186240 14.284 99 22 44 1 1378943632 8831424 4925968
01:02:07 52753 8192000000 10266969856 10728116224 1372541472 14.350 100 8 16 0 1384145472 9898208 1705792
01:04:05 66287 8192000000 10276563600 10731200512 1324690448 13.919 96 16 32 0 1342583744 14145776 3747520
01:06:12 61637 8192000000 10261853504 10723860480 1327429456 13.944 98 12 24 1 1346716768 16409792 2877520
01:08:23 48942 8192000000 10243419216 10690588672 1284483376 13.554 95 35 71 0 1304261760 11965120 7813264

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:14, from 26-02-2024 01:11:04 to 26-02-2024 01:11:18.

Exceptions occured during test was in run

FB_MNEMONA CNT UNIT FB_GDSCODE
except 162 v_add_invoice_to_stock 335544517
except 17 v_cancel_supplier_invoice 335544517

Completed "Exceptions occured during test was in run". Done for 00:00:02, from 26-02-2024 01:11:19 to 26-02-2024 01:11:21.

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          180932
MON$OLDEST_ACTIVE               182488
MON$OLDEST_SNAPSHOT             182488
MON$NEXT_TRANSACTION            182488
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                       1910240
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 Mon Feb 26 01:11:22 2024 
 
Database header page information: 
    Flags            0 
    Generation        95340 
    System Change Number    0 
    Page size        8192 
    ODS version        12.0 
    Oldest transaction    180932 
    Oldest active        182488 
    Oldest snapshot        182488 
    Next transaction    182489 
    Sequence number        0 
    Next attachment ID    732 
    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.34, total records: 7827019 
    Average version length: 48.16, total versions: 90464, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 64.00, compression ratio: 1.35 
    Pointer pages: 54, data page slots: 87336 
    Data pages: 87336, average fill: 72% 
    Primary pages: 87336, secondary pages: 0, swept pages: 18830 
    Empty pages: 0, full pages: 65657 
    Fill distribution: 
     0 - 19% = 12 
    20 - 39% = 159 
    40 - 59% = 1506 
    60 - 79% = 85636 
    80 - 99% = 23 
 
    Index DOC_DATA_DOC_WARE_UNQ (0) 
    Root page: 1510614, depth: 3, leaf buckets: 23593, nodes: 7827019 
    Average node length: 18.92, total dup: 0, max dup: 0 
    Average key length: 15.93, compression ratio: 1.69 
    Average prefix length: 14.06, average data length: 12.94 
    Clustering factor: 1743417, ratio: 0.22 
    Fill distribution: 
         0 - 19% = 350 
        20 - 39% = 1739 
        40 - 59% = 4463 
        60 - 79% = 2360 
        80 - 99% = 14681 
 
    Index DOC_DATA_ID_DESC (1) 
    Root page: 1528118, depth: 3, leaf buckets: 13673, nodes: 7827019 
    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: 1566272, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 1608 
        40 - 59% = 2161 
        60 - 79% = 1070 
        80 - 99% = 8834 
 
    Index FK_DOC_DATA_DOC_LIST (2) 
    Root page: 1546711, depth: 3, leaf buckets: 8437, nodes: 7827019 
    Average node length: 6.64, total dup: 5827693, max dup: 49 
    Average key length: 3.65, compression ratio: 2.47 
    Average prefix length: 7.61, average data length: 1.39 
    Clustering factor: 1559223, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 115 
        20 - 39% = 906 
        40 - 59% = 1537 
        60 - 79% = 889 
        80 - 99% = 4990 
 
DOC_LIST (138) 
    Primary pointer page: 472, Index root page: 473 
    Total formats: 1, used formats: 1 
    Average record length: 56.27, total records: 2290738 
    Average version length: 34.53, total versions: 91902, max versions: 3 
    Average fragment length: 8.00, total fragments: 2, max fragments: 1 
    Average unpacked length: 84.00, compression ratio: 1.49 
    Pointer pages: 18, data page slots: 28648 
    Data pages: 28648, average fill: 74% 
    Primary pages: 28644, secondary pages: 4, swept pages: 10397 
    Empty pages: 2, full pages: 21007 
    Fill distribution: 
     0 - 19% = 12 
    20 - 39% = 59 
    40 - 59% = 885 
    60 - 79% = 26891 
    80 - 99% = 801 
 
    Index DOC_LIST_ID_DESC (1) 
    Root page: 1541130, depth: 3, leaf buckets: 4673, nodes: 2290738 
    Average node length: 11.40, total dup: 0, max dup: 0 
    Average key length: 8.44, compression ratio: 1.07 
    Average prefix length: 3.56, average data length: 5.44 
    Clustering factor: 721209, ratio: 0.31 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 962 
        40 - 59% = 918 
        60 - 79% = 704 
        80 - 99% = 2089 
 
    Index DOC_LIST_WORKER_OPTYPE (2) 
    Root page: 1544376, depth: 3, leaf buckets: 2541, nodes: 2293152 
    Average node length: 4.97, total dup: 2292253, max dup: 20997 
    Average key length: 2.01, compression ratio: 4.47 
    Average prefix length: 8.99, average data length: 0.01 
    Clustering factor: 1265854, ratio: 0.55 
    Fill distribution: 
         0 - 19% = 4 
        20 - 39% = 236 
        40 - 59% = 1524 
        60 - 79% = 574 
        80 - 99% = 203 
 
    Index FK_DOC_LIST_AGENTS (3) 
    Root page: 1545909, depth: 3, leaf buckets: 2073, nodes: 2290738 
    Average node length: 4.97, total dup: 2290688, max dup: 130479 
    Average key length: 2.01, compression ratio: 4.48 
    Average prefix length: 8.99, average data length: 0.01 
    Clustering factor: 1074980, ratio: 0.47 
    Fill distribution: 
         0 - 19% = 5 
        20 - 39% = 48 
        40 - 59% = 1147 
        60 - 79% = 56 
        80 - 99% = 817 
 
    Index PK_DOC_LIST (0) 
    Root page: 1538187, depth: 3, leaf buckets: 4420, nodes: 2290738 
    Average node length: 11.40, total dup: 0, max dup: 0 
    Average key length: 8.43, compression ratio: 1.07 
    Average prefix length: 3.56, average data length: 5.44 
    Clustering factor: 721209, ratio: 0.31 
    Fill distribution: 
         0 - 19% = 113 
        20 - 39% = 575 
        40 - 59% = 658 
        60 - 79% = 780 
        80 - 99% = 2294 
 
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.22, total records: 400 
    Average version length: 22.93, total versions: 238568, max versions: 622 
    Average fragment length: 2.09, total fragments: 58, max fragments: 1 
    Average unpacked length: 104.00, compression ratio: 1.26 
    Pointer pages: 1, data page slots: 1328 
    Data pages: 1328, average fill: 89% 
    Primary pages: 13, secondary pages: 1315, swept pages: 0 
    Empty pages: 6, full pages: 1321 
    Fill distribution: 
     0 - 19% = 6 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 1 
    80 - 99% = 1321 
 
    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: 13.73, total records: 97906 
    Average version length: 68.28, total versions: 78221, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 88.00, compression ratio: 6.41 
    Pointer pages: 7, data page slots: 2312 
    Data pages: 1928, average fill: 63% 
    Primary pages: 1927, secondary pages: 1, swept pages: 0 
    Empty pages: 204, full pages: 1019 
    Fill distribution: 
     0 - 19% = 319 
    20 - 39% = 210 
    40 - 59% = 254 
    60 - 79% = 253 
    80 - 99% = 892 
 
    Index INVNT_TURNOVER_LOG_WARE_DD_ID (0) 
    Root page: 1683928, depth: 3, leaf buckets: 392, nodes: 97907 
    Average node length: 13.47, total dup: 7251, max dup: 1 
    Average key length: 10.69, compression ratio: 2.53 
    Average prefix length: 19.23, average data length: 7.77 
    Clustering factor: 72788, ratio: 0.74 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 180 
        40 - 59% = 206 
        60 - 79% = 6 
        80 - 99% = 0 
 
MONEY_SALDO (141) 
    Primary pointer page: 478, Index root page: 479 
    Total formats: 1, used formats: 1 
    Average record length: 15.29, total records: 49 
    Average version length: 9.00, total versions: 19626, max versions: 1038 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 32.00, compression ratio: 2.09 
    Pointer pages: 1, data page slots: 72 
    Data pages: 72, average fill: 87% 
    Primary pages: 4, secondary pages: 68, swept pages: 0 
    Empty pages: 3, full pages: 68 
    Fill distribution: 
     0 - 19% = 3 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 5 
    80 - 99% = 64 
 
    Index PK_MONEY_SALDO (0) 
    Root page: 1510361, depth: 1, leaf buckets: 1, nodes: 49 
    Average node length: 11.82, total dup: 0, max dup: 0 
    Average key length: 10.80, compression ratio: 0.83 
    Average prefix length: 1.18, average data length: 7.82 
    Clustering factor: 1, ratio: 0.02 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
MONEY_TURNOVER_LOG (140) 
    Primary pointer page: 476, Index root page: 477 
    Total formats: 1, used formats: 1 
    Average record length: 5.10, total records: 952 
    Average version length: 43.25, total versions: 843, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 58.00, compression ratio: 11.37 
    Pointer pages: 1, data page slots: 104 
    Data pages: 36, average fill: 27% 
    Primary pages: 35, secondary pages: 1, swept pages: 6 
    Empty pages: 10, full pages: 6 
    Fill distribution: 
     0 - 19% = 24 
    20 - 39% = 2 
    40 - 59% = 2 
    60 - 79% = 3 
    80 - 99% = 5 
 
    Index MONEY_TURNOVER_LOG_AGENT_OPTYPE (0) 
    Root page: 92928, depth: 2, leaf buckets: 2, nodes: 952 
    Average node length: 4.60, total dup: 854, max dup: 123 
    Average key length: 3.07, compression ratio: 6.18 
    Average prefix length: 18.03, average data length: 0.97 
    Clustering factor: 504, ratio: 0.53 
    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.05, total records: 74 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 112.00, compression ratio: 1.15 
    Pointer pages: 1, data page slots: 2 
    Data pages: 2, average fill: 52% 
    Primary pages: 2, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 1 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 1 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 1 
 
    Index PK_MON_CACHE_MEMORY (0) 
    Root page: 1504215, depth: 1, leaf buckets: 1, nodes: 74 
    Average node length: 11.69, total dup: 0, max dup: 0 
    Average key length: 10.68, compression ratio: 0.84 
    Average prefix length: 1.31, average data length: 7.69 
    Clustering factor: 2, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
MON_LOG (162) 
    Primary pointer page: 520, Index root page: 521 
    Total formats: 2, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index MON_LOG_DTS (4) 
    Root page: 1504229, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index MON_LOG_GDSCODE (2) 
    Root page: 1504227, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index MON_LOG_ROWSET_DESC (1) 
    Root page: 1504226, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index MON_LOG_UNIT (3) 
    Root page: 1504228, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PK_MON_LOG (0) 
    Root page: 1504225, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
MON_LOG_TABLE_STATS (163) 
    Primary pointer page: 522, Index root page: 523 
    Total formats: 2, used formats: 1 
    Average record length: 67.13, total records: 30 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 611.00, compression ratio: 9.10 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 31% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 1 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index MON_LOG_TABLE_STATS_DTS (4) 
    Root page: 1504224, depth: 1, leaf buckets: 1, nodes: 30 
    Average node length: 3.50, total dup: 23, max dup: 4 
    Average key length: 2.47, compression ratio: 3.24 
    Average prefix length: 7.53, average data length: 0.47 
    Clustering factor: 1, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index MON_LOG_TABLE_STATS_GDSCODE (2) 
    Root page: 1504222, depth: 1, leaf buckets: 1, nodes: 30 
    Average node length: 2.00, total dup: 29, max dup: 29 
    Average key length: 1.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 1, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index MON_LOG_TABLE_STATS_ROWSET (1) 
    Root page: 1504221, depth: 1, leaf buckets: 1, nodes: 30 
    Average node length: 3.33, total dup: 29, max dup: 29 
    Average key length: 2.30, compression ratio: 3.91 
    Average prefix length: 8.70, average data length: 0.30 
    Clustering factor: 1, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index MON_LOG_TABLE_STATS_TN_UNIT (3) 
    Root page: 1504223, depth: 1, leaf buckets: 1, nodes: 30 
    Average node length: 12.90, total dup: 0, max dup: 0 
    Average key length: 11.87, compression ratio: 1.42 
    Average prefix length: 7.63, average data length: 9.20 
    Clustering factor: 1, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PK_MON_LOG_TABLE_STATS (0) 
    Root page: 1504220, depth: 1, leaf buckets: 1, nodes: 30 
    Average node length: 8.37, total dup: 0, max dup: 0 
    Average key length: 7.33, compression ratio: 1.23 
    Average prefix length: 4.63, average data length: 4.37 
    Clustering factor: 1, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
OPTYPES (136) 
    Primary pointer page: 468, Index root page: 469 
    Total formats: 2, used formats: 1 
    Average record length: 67.56, total records: 9 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 386.00, compression ratio: 5.71 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 9% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index OPTYPES_MCODE_UNQ (1) 
    Root page: 1544805, depth: 1, leaf buckets: 1, nodes: 9 
    Average node length: 8.56, total dup: 0, max dup: 0 
    Average key length: 6.89, compression ratio: 0.73 
    Average prefix length: 0.44, average data length: 4.56 
    Clustering factor: 1, ratio: 0.11 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PK_OPTYPES (0) 
    Root page: 1544804, depth: 1, leaf buckets: 1, nodes: 9 
    Average node length: 6.11, total dup: 0, max dup: 0 
    Average key length: 5.00, compression ratio: 0.60 
    Average prefix length: 0.89, average data length: 2.11 
    Clustering factor: 1, ratio: 0.11 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
PDISTR (146) 
    Primary pointer page: 488, Index root page: 489 
    Total formats: 1, used formats: 1 
    Average record length: 36.15, total records: 773554 
    Average version length: 25.72, total versions: 62554, max versions: 4 
    Average fragment length: 30.00, total fragments: 1, max fragments: 1 
    Average unpacked length: 54.00, compression ratio: 1.49 
    Pointer pages: 5, data page slots: 8088 
    Data pages: 8088, average fill: 67% 
    Primary pages: 8046, secondary pages: 42, swept pages: 1751 
    Empty pages: 187, full pages: 6858 
    Fill distribution: 
     0 - 19% = 335 
    20 - 39% = 299 
    40 - 59% = 279 
    60 - 79% = 6942 
    80 - 99% = 233 
 
    Index PDISTR_AGENT_ID (2) 
    Root page: 1509308, depth: 2, leaf buckets: 859, nodes: 773554 
    Average node length: 4.86, total dup: 773505, max dup: 141723 
    Average key length: 2.01, compression ratio: 4.48 
    Average prefix length: 8.99, average data length: 0.01 
    Clustering factor: 88021, ratio: 0.11 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 133 
        40 - 59% = 475 
        60 - 79% = 195 
        80 - 99% = 55 
 
    Index PDISTR_SNDOP_RCVOP_SNDID_ASC (0) 
    Root page: 1508613, depth: 3, leaf buckets: 913, nodes: 773554 
    Average node length: 5.87, total dup: 688514, max dup: 46 
    Average key length: 3.02, compression ratio: 7.28 
    Average prefix length: 21.09, average data length: 0.91 
    Clustering factor: 155022, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 105 
        40 - 59% = 384 
        60 - 79% = 165 
        80 - 99% = 258 
 
    Index PDISTR_SNDOP_RCVOP_SNDID_DESC (1) 
    Root page: 1509187, depth: 3, leaf buckets: 961, nodes: 773554 
    Average node length: 5.88, total dup: 688514, max dup: 46 
    Average key length: 3.02, compression ratio: 7.28 
    Average prefix length: 21.09, average data length: 0.91 
    Clustering factor: 157112, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 211 
        40 - 59% = 355 
        60 - 79% = 133 
        80 - 99% = 262 
 
    Index PDISTR_WORKER_SND_ID (3) 
    Root page: 1510178, depth: 3, leaf buckets: 1111, nodes: 773554 
    Average node length: 5.96, total dup: 688514, max dup: 46 
    Average key length: 3.10, compression ratio: 5.48 
    Average prefix length: 16.01, average data length: 0.99 
    Clustering factor: 150389, ratio: 0.19 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 267 
        40 - 59% = 572 
        60 - 79% = 192 
        80 - 99% = 79 
 
PERF_AGG (158) 
    Primary pointer page: 512, Index root page: 513 
    Total formats: 1, used formats: 1 
    Average record length: 62.93, total records: 5525 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 2.82, total fragments: 57, max fragments: 1 
    Average unpacked length: 379.00, compression ratio: 6.02 
    Pointer pages: 1, data page slots: 112 
    Data pages: 96, average fill: 57% 
    Primary pages: 82, secondary pages: 14, swept pages: 54 
    Empty pages: 15, full pages: 67 
    Fill distribution: 
     0 - 19% = 24 
    20 - 39% = 1 
    40 - 59% = 1 
    60 - 79% = 70 
    80 - 99% = 0 
 
    Index PERF_AGG_UNQ (1) 
    Root page: 1504238, depth: 2, leaf buckets: 6, nodes: 5525 
    Average node length: 5.48, total dup: 0, max dup: 0 
    Average key length: 3.57, compression ratio: 10.12 
    Average prefix length: 34.58, average data length: 1.54 
    Clustering factor: 5178, ratio: 0.94 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 0 
        40 - 59% = 4 
        60 - 79% = 0 
        80 - 99% = 2 
 
    Index PK_PERF_AGG (0) 
    Root page: 1504233, depth: 2, leaf buckets: 10, nodes: 5525 
    Average node length: 11.13, 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: 163, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 2 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 7 
 
PERF_ESTIMATED (280) 
    Primary pointer page: 1504218, Index root page: 1504219 
    Total formats: 1, used formats: 1 
    Average record length: 39.11, total records: 83242 
    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: 808 
    Data pages: 808, average fill: 71% 
    Primary pages: 808, secondary pages: 0, swept pages: 0 
    Empty pages: 6, full pages: 801 
    Fill distribution: 
     0 - 19% = 6 
    20 - 39% = 1 
    40 - 59% = 0 
    60 - 79% = 801 
    80 - 99% = 0 
 
    Index PK_PERF_ESTIMATED (0) 
    Root page: 32724, depth: 2, leaf buckets: 107, nodes: 83242 
    Average node length: 10.18, total dup: 0, max dup: 0 
    Average key length: 8.19, compression ratio: 1.10 
    Average prefix length: 3.81, average data length: 5.19 
    Clustering factor: 3372, ratio: 0.04 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 2 
        60 - 79% = 0 
        80 - 99% = 104 
 
PERF_ISQL_STAT (156) 
    Primary pointer page: 508, Index root page: 509 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index PERF_ISQL_STAT_TRN (0) 
    Root page: 1504239, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
PERF_LOG (159) 
    Primary pointer page: 514, Index root page: 515 
    Total formats: 1, used formats: 1 
    Average record length: 110.62, total records: 72 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1691.00, compression ratio: 15.29 
    Pointer pages: 1, data page slots: 2 
    Data pages: 2, average fill: 56% 
    Primary pages: 2, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 1 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 1 
    40 - 59% = 0 
    60 - 79% = 1 
    80 - 99% = 0 
 
PERF_SPLIT_0 (281) 
    Primary pointer page: 573, Index root page: 574 
    Total formats: 1, used formats: 1 
    Average record length: 141.62, total records: 188373 
    Average version length: 153.36, total versions: 11883, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.98 
    Pointer pages: 7, data page slots: 5616 
    Data pages: 4536, average fill: 86% 
    Primary pages: 4536, secondary pages: 0, swept pages: 1 
    Empty pages: 57, full pages: 4462 
    Fill distribution: 
     0 - 19% = 61 
    20 - 39% = 7 
    40 - 59% = 0 
    60 - 79% = 7 
    80 - 99% = 4461 
 
PERF_SPLIT_1 (282) 
    Primary pointer page: 576, Index root page: 577 
    Total formats: 1, used formats: 1 
    Average record length: 144.51, total records: 176877 
    Average version length: 152.50, total versions: 7814, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.74 
    Pointer pages: 7, data page slots: 5304 
    Data pages: 4280, average fill: 86% 
    Primary pages: 4280, secondary pages: 0, swept pages: 3 
    Empty pages: 70, full pages: 4187 
    Fill distribution: 
     0 - 19% = 76 
    20 - 39% = 5 
    40 - 59% = 7 
    60 - 79% = 5 
    80 - 99% = 4187 
 
PERF_SPLIT_2 (283) 
    Primary pointer page: 578, Index root page: 579 
    Total formats: 1, used formats: 1 
    Average record length: 132.03, total records: 188050 
    Average version length: 154.18, total versions: 23582, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 12.85 
    Pointer pages: 7, data page slots: 5896 
    Data pages: 4528, average fill: 87% 
    Primary pages: 4528, secondary pages: 0, swept pages: 4 
    Empty pages: 55, full pages: 4458 
    Fill distribution: 
     0 - 19% = 58 
    20 - 39% = 6 
    40 - 59% = 1 
    60 - 79% = 5 
    80 - 99% = 4458 
 
PERF_SPLIT_3 (284) 
    Primary pointer page: 580, Index root page: 581 
    Total formats: 1, used formats: 1 
    Average record length: 146.63, total records: 166839 
    Average version length: 150.19, total versions: 4877, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.57 
    Pointer pages: 8, data page slots: 5344 
    Data pages: 4040, average fill: 85% 
    Primary pages: 4040, secondary pages: 0, swept pages: 2 
    Empty pages: 73, full pages: 3940 
    Fill distribution: 
     0 - 19% = 74 
    20 - 39% = 14 
    40 - 59% = 4 
    60 - 79% = 7 
    80 - 99% = 3941 
 
PERF_SPLIT_4 (285) 
    Primary pointer page: 582, Index root page: 583 
    Total formats: 1, used formats: 1 
    Average record length: 142.55, total records: 157579 
    Average version length: 152.72, total versions: 8851, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.90 
    Pointer pages: 8, data page slots: 5272 
    Data pages: 3776, average fill: 86% 
    Primary pages: 3776, secondary pages: 0, swept pages: 2 
    Empty pages: 33, full pages: 3727 
    Fill distribution: 
     0 - 19% = 34 
    20 - 39% = 5 
    40 - 59% = 7 
    60 - 79% = 3 
    80 - 99% = 3727 
 
PERF_SPLIT_5 (286) 
    Primary pointer page: 584, Index root page: 585 
    Total formats: 1, used formats: 1 
    Average record length: 144.57, total records: 179331 
    Average version length: 152.02, total versions: 7828, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.73 
    Pointer pages: 8, data page slots: 4936 
    Data pages: 4304, average fill: 86% 
    Primary pages: 4304, secondary pages: 0, swept pages: 1 
    Empty pages: 43, full pages: 4246 
    Fill distribution: 
     0 - 19% = 47 
    20 - 39% = 6 
    40 - 59% = 2 
    60 - 79% = 3 
    80 - 99% = 4246 
 
PERF_SPLIT_6 (287) 
    Primary pointer page: 586, Index root page: 587 
    Total formats: 1, used formats: 1 
    Average record length: 139.35, total records: 185998 
    Average version length: 153.79, total versions: 14522, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 12.17 
    Pointer pages: 6, data page slots: 5632 
    Data pages: 4464, average fill: 87% 
    Primary pages: 4463, secondary pages: 1, swept pages: 6 
    Empty pages: 42, full pages: 4409 
    Fill distribution: 
     0 - 19% = 45 
    20 - 39% = 2 
    40 - 59% = 3 
    60 - 79% = 5 
    80 - 99% = 4409 
 
PERF_SPLIT_7 (288) 
    Primary pointer page: 588, Index root page: 589 
    Total formats: 1, used formats: 1 
    Average record length: 145.56, total records: 181231 
    Average version length: 151.91, total versions: 6914, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.65 
    Pointer pages: 7, data page slots: 5128 
    Data pages: 4360, average fill: 86% 
    Primary pages: 4360, secondary pages: 0, swept pages: 3 
    Empty pages: 52, full pages: 4294 
    Fill distribution: 
     0 - 19% = 56 
    20 - 39% = 3 
    40 - 59% = 5 
    60 - 79% = 1 
    80 - 99% = 4295 
 
PERF_SPLIT_8 (289) 
    Primary pointer page: 590, Index root page: 591 
    Total formats: 1, used formats: 1 
    Average record length: 147.53, total records: 189792 
    Average version length: 151.44, total versions: 4901, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.50 
    Pointer pages: 8, data page slots: 5584 
    Data pages: 4584, average fill: 86% 
    Primary pages: 4584, secondary pages: 0, swept pages: 4 
    Empty pages: 64, full pages: 4498 
    Fill distribution: 
     0 - 19% = 71 
    20 - 39% = 4 
    40 - 59% = 4 
    60 - 79% = 8 
    80 - 99% = 4497 
 
PERF_SPLIT_9 (290) 
    Primary pointer page: 593, Index root page: 594 
    Total formats: 1, used formats: 1 
    Average record length: 135.44, total records: 179074 
    Average version length: 153.63, total versions: 18325, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 12.52 
    Pointer pages: 8, data page slots: 6024 
    Data pages: 4352, average fill: 86% 
    Primary pages: 4351, secondary pages: 1, swept pages: 6 
    Empty pages: 60, full pages: 4208 
    Fill distribution: 
     0 - 19% = 66 
    20 - 39% = 6 
    40 - 59% = 66 
    60 - 79% = 8 
    80 - 99% = 4206 
 
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.73, total records: 2146236 
    Average version length: 52.93, total versions: 41650, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 70.00, compression ratio: 1.35 
    Pointer pages: 16, data page slots: 25656 
    Data pages: 25656, average fill: 72% 
    Primary pages: 25656, secondary pages: 0, swept pages: 10507 
    Empty pages: 178, full pages: 21588 
    Fill distribution: 
     0 - 19% = 338 
    20 - 39% = 306 
    40 - 59% = 930 
    60 - 79% = 23677 
    80 - 99% = 405 
 
    Index PSTORNED_RCV_ID (1) 
    Root page: 1506186, depth: 3, leaf buckets: 2620, nodes: 2146236 
    Average node length: 5.44, total dup: 2004115, max dup: 1406 
    Average key length: 2.48, compression ratio: 3.63 
    Average prefix length: 8.58, average data length: 0.42 
    Clustering factor: 184736, ratio: 0.09 
    Fill distribution: 
         0 - 19% = 5 
        20 - 39% = 243 
        40 - 59% = 1763 
        60 - 79% = 318 
        80 - 99% = 291 
 
    Index PSTORNED_SND_ID (0) 
    Root page: 1504819, depth: 3, leaf buckets: 2761, nodes: 2146236 
    Average node length: 5.69, total dup: 1926852, max dup: 70 
    Average key length: 2.74, compression ratio: 3.29 
    Average prefix length: 8.37, average data length: 0.63 
    Clustering factor: 382591, ratio: 0.18 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 4 
        40 - 59% = 2244 
        60 - 79% = 489 
        80 - 99% = 24 
 
    Index PSTORNED_WORKER_ID (2) 
    Root page: 1507996, depth: 3, leaf buckets: 2173, nodes: 2146236 
    Average node length: 4.96, total dup: 2146136, max dup: 28737 
    Average key length: 2.00, compression ratio: 1.20 
    Average prefix length: 2.41, average data length: 0.00 
    Clustering factor: 182198, ratio: 0.08 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 171 
        40 - 59% = 1161 
        60 - 79% = 409 
        80 - 99% = 430 
 
RULES_FOR_PDISTR (148) 
    Primary pointer page: 492, Index root page: 493 
    Total formats: 1, used formats: 1 
    Average record length: 17.00, total records: 4 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 334.00, compression ratio: 19.65 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 2% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index RULES_FOR_PDISTR_UNQ (0) 
    Root page: 1504317, depth: 1, leaf buckets: 1, nodes: 4 
    Average node length: 11.50, total dup: 0, max dup: 0 
    Average key length: 10.25, compression ratio: 0.88 
    Average prefix length: 1.50, average data length: 7.50 
    Clustering factor: 1, ratio: 0.25 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
RULES_FOR_QDISTR (137) 
    Primary pointer page: 470, Index root page: 471 
    Total formats: 1, used formats: 1 
    Average record length: 32.71, total records: 7 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 332.00, compression ratio: 10.15 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 4% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index RULES_FOR_QDISTR_RCVOP (1) 
    Root page: 1544803, depth: 1, leaf buckets: 1, nodes: 7 
    Average node length: 5.29, total dup: 2, max dup: 2 
    Average key length: 4.14, compression ratio: 0.72 
    Average prefix length: 1.43, average data length: 1.57 
    Clustering factor: 1, ratio: 0.14 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index RULES_FOR_QDISTR_UNQ (0) 
    Root page: 1544802, depth: 1, leaf buckets: 1, nodes: 7 
    Average node length: 10.14, total dup: 0, max dup: 0 
    Average key length: 8.86, compression ratio: 0.94 
    Average prefix length: 2.14, average data length: 6.14 
    Clustering factor: 1, ratio: 0.14 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
SEMAPHORES (152) 
    Primary pointer page: 500, Index root page: 501 
    Total formats: 1, used formats: 1 
    Average record length: 43.40, total records: 5 
    Average version length: 9.00, total versions: 1, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 346.00, compression ratio: 7.97 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 4% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index PK_SEMAPHORES (0) 
    Root page: 1504305, depth: 1, leaf buckets: 1, nodes: 5 
    Average node length: 12.40, total dup: 0, max dup: 0 
    Average key length: 11.00, compression ratio: 0.82 
    Average prefix length: 0.60, average data length: 8.40 
    Clustering factor: 1, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index SEMAPHORES_TASK_UNQ (1) 
    Root page: 1504306, depth: 1, leaf buckets: 1, nodes: 5 
    Average node length: 23.40, total dup: 0, max dup: 0 
    Average key length: 22.00, compression ratio: 1.07 
    Average prefix length: 4.20, average data length: 19.40 
    Clustering factor: 1, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
SETTINGS (135) 
    Primary pointer page: 466, Index root page: 467 
    Total formats: 1, used formats: 1 
    Average record length: 97.63, total records: 149 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1347.00, compression ratio: 13.80 
    Pointer pages: 1, data page slots: 3 
    Data pages: 3, average fill: 70% 
    Primary pages: 3, secondary pages: 0, swept pages: 2 
    Empty pages: 0, full pages: 2 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 1 
    60 - 79% = 0 
    80 - 99% = 2 
 
    Index SETTINGS_MCODE_WM_UNQ (1) 
    Root page: 525, depth: 1, leaf buckets: 1, nodes: 149 
    Average node length: 14.66, total dup: 0, max dup: 0 
    Average key length: 13.55, compression ratio: 2.19 
    Average prefix length: 19.07, average data length: 10.66 
    Clustering factor: 48, ratio: 0.32 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 1 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index SETTINGS_MODE_CODE (0) 
    Root page: 1544806, depth: 1, leaf buckets: 1, nodes: 149 
    Average node length: 25.56, total dup: 0, max dup: 0 
    Average key length: 24.56, compression ratio: 1.63 
    Average prefix length: 18.58, average data length: 21.56 
    Clustering factor: 14, ratio: 0.09 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 0 
        40 - 59% = 1 
        60 - 79% = 0 
        80 - 99% = 0 
 
TMP$DEP_DOCS (129) 
    Primary pointer page: 454, Index root page: 455 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index TMP_DEP_DOCS_UNQ (0) 
    Root page: 1544810, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
TMP$IDX_RECALC (132) 
    Primary pointer page: 460, Index root page: 461 
    Total formats: 2, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index TMP_IDX_RECALC_IDX_NAME_UNQ (0) 
    Root page: 1544807, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
TMP$MON_LOG (133) 
    Primary pointer page: 462, Index root page: 463 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
TMP$MON_LOG_TABLE_STATS (134) 
    Primary pointer page: 464, Index root page: 465 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
TMP$PERF_EST_WHOLE (161) 
    Primary pointer page: 518, Index root page: 519 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
TMP$PERF_LOG (160) 
    Primary pointer page: 516, Index root page: 517 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index TMP$PERF_LOG_UNIT_TRN_DTS_END (0) 
    Root page: 1504230, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
TMP$PERF_MON (131) 
    Primary pointer page: 458, Index root page: 459 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
TMP$RESULT_SET (130) 
    Primary pointer page: 456, Index root page: 457 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index TMP_RESULT_SET_DOC (1) 
    Root page: 1544809, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index TMP_RESULT_SET_WARE_DOC (0) 
    Root page: 1544808, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
TMP$SHOPPING_CART (128) 
    Primary pointer page: 452, Index root page: 453 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index TMP_SHOPCART_UNQ (0) 
    Root page: 1544811, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
TPAUSE (166) 
    Primary pointer page: 528, Index root page: 529 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index RDB$PRIMARY2 (0) 
    Root page: 1504214, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
TRACE_STAT (157) 
    Primary pointer page: 510, Index root page: 511 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
WARES (142) 
    Primary pointer page: 480, Index root page: 481 
    Total formats: 1, used formats: 1 
    Average record length: 77.52, total records: 400 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 444.00, compression ratio: 5.73 
    Pointer pages: 1, data page slots: 6 
    Data pages: 6, average fill: 77% 
    Primary pages: 6, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 5 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 5 
    80 - 99% = 1 
 
    Index FK_WARES_WARE_GROUPS (3) 
    Root page: 1552159, depth: 1, leaf buckets: 1, nodes: 400 
    Average node length: 3.17, total dup: 392, max dup: 60 
    Average key length: 2.16, compression ratio: 4.16 
    Average prefix length: 8.86, average data length: 0.14 
    Clustering factor: 48, ratio: 0.12 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PK_WARES (0) 
    Root page: 1510355, depth: 1, leaf buckets: 1, nodes: 400 
    Average node length: 11.22, total dup: 0, max dup: 0 
    Average key length: 10.22, compression ratio: 0.88 
    Average prefix length: 1.78, average data length: 7.22 
    Clustering factor: 344, ratio: 0.86 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 0 
        40 - 59% = 1 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index WARES_ID_DESC (2) 
    Root page: 1510360, depth: 1, leaf buckets: 1, nodes: 400 
    Average node length: 11.22, total dup: 0, max dup: 0 
    Average key length: 10.22, compression ratio: 0.88 
    Average prefix length: 1.78, average data length: 7.22 
    Clustering factor: 344, ratio: 0.86 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 0 
        40 - 59% = 1 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index WARES_NUMB_UNQ (1) 
    Root page: 1510358, depth: 2, leaf buckets: 3, nodes: 400 
    Average node length: 53.25, total dup: 0, max dup: 0 
    Average key length: 52.23, compression ratio: 1.00 
    Average prefix length: 2.74, average data length: 49.25 
    Clustering factor: 355, ratio: 0.89 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 1 
        80 - 99% = 2 
 
WARE_GROUPS (151) 
    Primary pointer page: 498, Index root page: 499 
    Total formats: 1, used formats: 1 
    Average record length: 32.12, total records: 8 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 346.00, compression ratio: 10.77 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 5% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index PK_WARE_GROUPS (0) 
    Root page: 1504307, depth: 1, leaf buckets: 1, nodes: 8 
    Average node length: 11.25, total dup: 0, max dup: 0 
    Average key length: 10.12, compression ratio: 0.89 
    Average prefix length: 1.75, average data length: 7.25 
    Clustering factor: 1, ratio: 0.12 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index WARE_GROUPS_NAME_UNQ (1) 
    Root page: 1504308, depth: 1, leaf buckets: 1, nodes: 8 
    Average node length: 19.88, total dup: 0, max dup: 0 
    Average key length: 18.12, compression ratio: 0.89 
    Average prefix length: 0.25, average data length: 15.88 
    Clustering factor: 1, ratio: 0.12 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
XQD_1000_1200 (176) 
    Primary pointer page: 549, Index root page: 550 
    Total formats: 1, used formats: 1 
    Average record length: 40.69, total records: 154062 
    Average version length: 69.18, total versions: 63505, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 3.10 
    Pointer pages: 3, data page slots: 4272 
    Data pages: 3032, average fill: 59% 
    Primary pages: 3032, secondary pages: 0, swept pages: 395 
    Empty pages: 489, full pages: 1839 
    Fill distribution: 
     0 - 19% = 658 
    20 - 39% = 204 
    40 - 59% = 200 
    60 - 79% = 628 
    80 - 99% = 1342 
 
    Index XQD_1000_1200_WA_SO_RO_WKR_SND (0) 
    Root page: 1553997, depth: 3, leaf buckets: 231, nodes: 154062 
    Average node length: 6.44, total dup: 134003, max dup: 29 
    Average key length: 3.94, compression ratio: 10.65 
    Average prefix length: 40.19, average data length: 1.81 
    Clustering factor: 26211, ratio: 0.17 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 39 
        40 - 59% = 115 
        60 - 79% = 59 
        80 - 99% = 17 
 
XQD_1000_3300 (178) 
    Primary pointer page: 553, Index root page: 554 
    Total formats: 1, used formats: 1 
    Average record length: 65.08, total records: 6887910 
    Average version length: 68.81, total versions: 387678, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.94 
    Pointer pages: 61, data page slots: 99440 
    Data pages: 99440, average fill: 74% 
    Primary pages: 99440, secondary pages: 0, swept pages: 24807 
    Empty pages: 109, full pages: 82308 
    Fill distribution: 
     0 - 19% = 864 
    20 - 39% = 1830 
    40 - 59% = 5100 
    60 - 79% = 84277 
    80 - 99% = 7369 
 
    Index XQD_1000_3300_WA_SO_RO_WKR_SND (0) 
    Root page: 1480454, depth: 3, leaf buckets: 10533, nodes: 6887910 
    Average node length: 6.51, total dup: 5957098, max dup: 29 
    Average key length: 3.52, compression ratio: 11.92 
    Average prefix length: 40.61, average data length: 1.39 
    Clustering factor: 1517733, ratio: 0.22 
    Fill distribution: 
         0 - 19% = 5 
        20 - 39% = 1862 
        40 - 59% = 5652 
        60 - 79% = 2506 
        80 - 99% = 508 
 
    Index XQD_1000_3300_WKR_DOC_ASC (1) 
    Root page: 1486068, depth: 3, leaf buckets: 8219, nodes: 6887910 
    Average node length: 5.40, total dup: 6609341, max dup: 192 
    Average key length: 2.41, compression ratio: 7.05 
    Average prefix length: 16.63, average data length: 0.37 
    Clustering factor: 1323725, ratio: 0.19 
    Fill distribution: 
         0 - 19% = 8 
        20 - 39% = 1255 
        40 - 59% = 4221 
        60 - 79% = 1595 
        80 - 99% = 1140 
 
    Index XQD_1000_3300_WKR_DOC_DEC (2) 
    Root page: 1490608, depth: 3, leaf buckets: 8288, nodes: 6887910 
    Average node length: 5.40, total dup: 6609341, max dup: 192 
    Average key length: 2.41, compression ratio: 7.05 
    Average prefix length: 16.63, average data length: 0.37 
    Clustering factor: 1326203, ratio: 0.19 
    Fill distribution: 
         0 - 19% = 3 
        20 - 39% = 1313 
        40 - 59% = 4235 
        60 - 79% = 1628 
        80 - 99% = 1109 
 
XQD_1200_2000 (177) 
    Primary pointer page: 551, Index root page: 552 
    Total formats: 1, used formats: 1 
    Average record length: 67.18, total records: 11878812 
    Average version length: 68.77, total versions: 306219, 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: 101, data page slots: 164552 
    Data pages: 164552, average fill: 77% 
    Primary pages: 164552, secondary pages: 0, swept pages: 74449 
    Empty pages: 7, full pages: 155348 
    Fill distribution: 
     0 - 19% = 23 
    20 - 39% = 258 
    40 - 59% = 2509 
    60 - 79% = 155884 
    80 - 99% = 5878 
 
    Index XQD_1200_2000_WA_SO_RO_WKR_SND (0) 
    Root page: 1495028, depth: 3, leaf buckets: 18300, nodes: 11878812 
    Average node length: 6.56, total dup: 10354970, max dup: 51 
    Average key length: 3.43, compression ratio: 12.26 
    Average prefix length: 40.70, average data length: 1.30 
    Clustering factor: 2351492, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 20 
        20 - 39% = 2574 
        40 - 59% = 10778 
        60 - 79% = 4252 
        80 - 99% = 676 
 
XQD_2000_3300 (179) 
    Primary pointer page: 555, Index root page: 556 
    Total formats: 1, used formats: 1 
    Average record length: 42.40, total records: 1557877 
    Average version length: 69.13, total versions: 602733, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 2.97 
    Pointer pages: 27, data page slots: 43400 
    Data pages: 27366, average fill: 65% 
    Primary pages: 27366, secondary pages: 0, swept pages: 7160 
    Empty pages: 2437, full pages: 18833 
    Fill distribution: 
     0 - 19% = 4514 
    20 - 39% = 1732 
    40 - 59% = 1243 
    60 - 79% = 10003 
    80 - 99% = 9874 
 
    Index XQD_2000_3300_WA_SO_RO_WKR_SND (0) 
    Root page: 1479712, depth: 3, leaf buckets: 2015, nodes: 1557877 
    Average node length: 5.52, total dup: 1494700, max dup: 99 
    Average key length: 2.56, compression ratio: 16.41 
    Average prefix length: 41.48, average data length: 0.52 
    Clustering factor: 103309, ratio: 0.07 
    Fill distribution: 
         0 - 19% = 5 
        20 - 39% = 430 
        40 - 59% = 950 
        60 - 79% = 479 
        80 - 99% = 151 
 
XQD_2100_3300 (180) 
    Primary pointer page: 557, Index root page: 558 
    Total formats: 1, used formats: 1 
    Average record length: 37.60, total records: 1205511 
    Average version length: 69.13, total versions: 548750, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 3.35 
    Pointer pages: 22, data page slots: 35160 
    Data pages: 26776, average fill: 52% 
    Primary pages: 26776, secondary pages: 0, swept pages: 6105 
    Empty pages: 5952, full pages: 14570 
    Fill distribution: 
     0 - 19% = 8554 
    20 - 39% = 1631 
    40 - 59% = 978 
    60 - 79% = 5040 
    80 - 99% = 10573 
 
    Index XQD_2100_3300_WA_SO_RO_WKR_SND (0) 
    Root page: 1479207, depth: 3, leaf buckets: 1564, nodes: 1205511 
    Average node length: 5.79, total dup: 1125547, max dup: 99 
    Average key length: 2.85, compression ratio: 14.73 
    Average prefix length: 41.21, average data length: 0.79 
    Clustering factor: 165478, ratio: 0.14 
    Fill distribution: 
         0 - 19% = 5 
        20 - 39% = 226 
        40 - 59% = 774 
        60 - 79% = 433 
        80 - 99% = 126 
 
XQD_3300_3400 (181) 
    Primary pointer page: 559, Index root page: 560 
    Total formats: 1, used formats: 1 
    Average record length: 65.66, total records: 9451845 
    Average version length: 68.92, total versions: 443334, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.92 
    Pointer pages: 90, data page slots: 146504 
    Data pages: 146496, average fill: 69% 
    Primary pages: 146495, secondary pages: 1, swept pages: 60174 
    Empty pages: 200, full pages: 79815 
    Fill distribution: 
     0 - 19% = 794 
    20 - 39% = 5472 
    40 - 59% = 23775 
    60 - 79% = 109751 
    80 - 99% = 6704 
 
    Index XQD_3300_3400_WA_SO_RO_WKR_SND (0) 
    Root page: 1472590, depth: 3, leaf buckets: 13560, nodes: 9451845 
    Average node length: 6.69, total dup: 7842322, max dup: 14 
    Average key length: 3.66, compression ratio: 11.46 
    Average prefix length: 40.50, average data length: 1.50 
    Clustering factor: 2022398, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 1037 
        40 - 59% = 6641 
        60 - 79% = 5084 
        80 - 99% = 796 
 
XQS_1000_1200 (182) 
    Primary pointer page: 561, Index root page: 562 
    Total formats: 1, used formats: 1 
    Average record length: 82.49, total records: 21198809 
    Average version length: 82.94, total versions: 12159, 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: 319344 
    Data pages: 319344, average fill: 81% 
    Primary pages: 319344, secondary pages: 0, swept pages: 12880 
    Empty pages: 5, full pages: 319338 
    Fill distribution: 
     0 - 19% = 5 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 27320 
    80 - 99% = 292019 
 
    Index XQS_1000_1200_DOC_ID (1) 
    Root page: 1426716, depth: 3, leaf buckets: 19219, nodes: 21198809 
    Average node length: 5.72, total dup: 20716750, max dup: 128 
    Average key length: 2.16, compression ratio: 4.16 
    Average prefix length: 8.86, average data length: 0.14 
    Clustering factor: 3289969, ratio: 0.16 
    Fill distribution: 
         0 - 19% = 6 
        20 - 39% = 0 
        40 - 59% = 7696 
        60 - 79% = 603 
        80 - 99% = 10914 
 
    Index XQS_1000_1200_RCV_ID (3) 
    Root page: 1456980, depth: 3, leaf buckets: 17240, nodes: 21198809 
    Average node length: 6.31, total dup: 18630338, max dup: 49 
    Average key length: 2.75, compression ratio: 3.27 
    Average prefix length: 8.37, average data length: 0.63 
    Clustering factor: 918671, ratio: 0.04 
    Fill distribution: 
         0 - 19% = 3 
        20 - 39% = 3 
        40 - 59% = 825 
        60 - 79% = 275 
        80 - 99% = 16134 
 
    Index XQS_1000_1200_SND_ID (2) 
    Root page: 1441073, depth: 3, leaf buckets: 21028, nodes: 21198809 
    Average node length: 6.35, total dup: 18548622, max dup: 29 
    Average key length: 2.79, compression ratio: 3.23 
    Average prefix length: 8.34, average data length: 0.66 
    Clustering factor: 3584754, ratio: 0.17 
    Fill distribution: 
         0 - 19% = 5 
        20 - 39% = 1 
        40 - 59% = 8045 
        60 - 79% = 622 
        80 - 99% = 12355 
 
    Index XQS_1000_1200_WORKER_ID (0) 
    Root page: 1413348, depth: 3, leaf buckets: 16273, nodes: 21198809 
    Average node length: 5.56, total dup: 21198709, max dup: 231194 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.41, average data length: 0.00 
    Clustering factor: 947284, ratio: 0.04 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 8 
        40 - 59% = 3126 
        60 - 79% = 451 
        80 - 99% = 12688 
 
XQS_1000_3300 (184) 
    Primary pointer page: 565, Index root page: 566 
    Total formats: 1, used formats: 1 
    Average record length: 78.68, total records: 9917993 
    Average version length: 82.60, total versions: 450986, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.60 
    Pointer pages: 107, data page slots: 173760 
    Data pages: 173744, average fill: 70% 
    Primary pages: 173744, secondary pages: 0, swept pages: 75982 
    Empty pages: 304, full pages: 100207 
    Fill distribution: 
     0 - 19% = 1107 
    20 - 39% = 6871 
    40 - 59% = 27704 
    60 - 79% = 74878 
    80 - 99% = 63184 
 
    Index XQS_1000_3300_DOC_ID (1) 
    Root page: 1367502, depth: 3, leaf buckets: 11415, nodes: 9917993 
    Average node length: 5.38, total dup: 9605424, max dup: 211 
    Average key length: 2.23, compression ratio: 4.04 
    Average prefix length: 8.80, average data length: 0.20 
    Clustering factor: 2178055, ratio: 0.22 
    Fill distribution: 
         0 - 19% = 3 
        20 - 39% = 62 
        40 - 59% = 7538 
        60 - 79% = 3648 
        80 - 99% = 164 
 
    Index XQS_1000_3300_RCV_ID (3) 
    Root page: 1379261, depth: 3, leaf buckets: 14032, nodes: 9917993 
    Average node length: 6.25, total dup: 8223492, max dup: 14 
    Average key length: 3.10, compression ratio: 2.90 
    Average prefix length: 8.07, average data length: 0.93 
    Clustering factor: 1509021, ratio: 0.15 
    Fill distribution: 
         0 - 19% = 156 
        20 - 39% = 4327 
        40 - 59% = 4548 
        60 - 79% = 2431 
        80 - 99% = 2570 
 
    Index XQS_1000_3300_SND_ID (2) 
    Root page: 1373059, depth: 3, leaf buckets: 12749, nodes: 9917993 
    Average node length: 6.00, total dup: 8609485, max dup: 43 
    Average key length: 2.85, compression ratio: 3.16 
    Average prefix length: 8.29, average data length: 0.71 
    Clustering factor: 2371557, ratio: 0.24 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 73 
        40 - 59% = 8554 
        60 - 79% = 3929 
        80 - 99% = 193 
 
    Index XQS_1000_3300_WORKER_ID (0) 
    Root page: 1362767, depth: 3, leaf buckets: 10387, nodes: 9917993 
    Average node length: 5.15, total dup: 9917893, max dup: 168914 
    Average key length: 2.00, compression ratio: 1.20 
    Average prefix length: 2.41, average data length: 0.00 
    Clustering factor: 1561906, ratio: 0.16 
    Fill distribution: 
         0 - 19% = 28 
        20 - 39% = 1206 
        40 - 59% = 5304 
        60 - 79% = 1732 
        80 - 99% = 2117 
 
XQS_1200_2000 (183) 
    Primary pointer page: 563, Index root page: 564 
    Total formats: 1, used formats: 1 
    Average record length: 79.92, total records: 11532285 
    Average version length: 82.57, total versions: 335433, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.58 
    Pointer pages: 119, data page slots: 194072 
    Data pages: 192848, average fill: 73% 
    Primary pages: 192848, secondary pages: 0, swept pages: 70589 
    Empty pages: 2757, full pages: 146791 
    Fill distribution: 
     0 - 19% = 4637 
    20 - 39% = 7213 
    40 - 59% = 16911 
    60 - 79% = 43186 
    80 - 99% = 120901 
 
    Index XQS_1200_2000_DOC_ID (1) 
    Root page: 1392101, depth: 3, leaf buckets: 13142, nodes: 11532285 
    Average node length: 5.30, total dup: 11421986, max dup: 620 
    Average key length: 2.08, compression ratio: 4.33 
    Average prefix length: 8.93, average data length: 0.07 
    Clustering factor: 2407529, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 77 
        40 - 59% = 8589 
        60 - 79% = 4272 
        80 - 99% = 203 
 
    Index XQS_1200_2000_RCV_ID (3) 
    Root page: 1406110, depth: 3, leaf buckets: 10636, nodes: 11532285 
    Average node length: 5.50, total dup: 11029913, max dup: 49 
    Average key length: 2.28, compression ratio: 3.95 
    Average prefix length: 8.77, average data length: 0.23 
    Clustering factor: 732672, ratio: 0.06 
    Fill distribution: 
         0 - 19% = 154 
        20 - 39% = 832 
        40 - 59% = 2687 
        60 - 79% = 1821 
        80 - 99% = 5142 
 
    Index XQS_1200_2000_SND_ID (2) 
    Root page: 1398638, depth: 3, leaf buckets: 15023, nodes: 11532285 
    Average node length: 6.03, total dup: 10066789, max dup: 59 
    Average key length: 2.80, compression ratio: 3.21 
    Average prefix length: 8.32, average data length: 0.68 
    Clustering factor: 2424011, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 96 
        40 - 59% = 10099 
        60 - 79% = 4546 
        80 - 99% = 281 
 
    Index XQS_1200_2000_WORKER_ID (0) 
    Root page: 1386211, depth: 3, leaf buckets: 10995, nodes: 11532285 
    Average node length: 5.22, total dup: 11532185, max dup: 206884 
    Average key length: 2.00, compression ratio: 1.20 
    Average prefix length: 2.41, average data length: 0.00 
    Clustering factor: 721758, ratio: 0.06 
    Fill distribution: 
         0 - 19% = 98 
        20 - 39% = 810 
        40 - 59% = 4944 
        60 - 79% = 1563 
        80 - 99% = 3580 
 
XQS_2000_3300 (185) 
    Primary pointer page: 567, Index root page: 568 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index XQS_2000_3300_DOC_ID (1) 
    Root page: 1361753, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index XQS_2000_3300_RCV_ID (3) 
    Root page: 1361755, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index XQS_2000_3300_SND_ID (2) 
    Root page: 1361754, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index XQS_2000_3300_WORKER_ID (0) 
    Root page: 1361752, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
XQS_2100_3300 (186) 
    Primary pointer page: 569, Index root page: 570 
    Total formats: 1, used formats: 1 
    Average record length: 78.96, total records: 10043678 
    Average version length: 82.87, total versions: 458731, 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: 109, data page slots: 177528 
    Data pages: 177496, average fill: 70% 
    Primary pages: 177496, secondary pages: 0, swept pages: 80462 
    Empty pages: 572, full pages: 101497 
    Fill distribution: 
     0 - 19% = 1583 
    20 - 39% = 7321 
    40 - 59% = 29079 
    60 - 79% = 76583 
    80 - 99% = 62930 
 
    Index XQS_2100_3300_DOC_ID (1) 
    Root page: 1344686, depth: 3, leaf buckets: 12156, nodes: 10043678 
    Average node length: 5.20, total dup: 10014372, max dup: 1572 
    Average key length: 2.03, compression ratio: 4.43 
    Average prefix length: 8.97, average data length: 0.03 
    Clustering factor: 1990305, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 35 
        20 - 39% = 1506 
        40 - 59% = 8070 
        60 - 79% = 1898 
        80 - 99% = 647 
 
    Index XQS_2100_3300_RCV_ID (3) 
    Root page: 1355717, depth: 3, leaf buckets: 14190, nodes: 10043678 
    Average node length: 6.27, total dup: 8327084, max dup: 14 
    Average key length: 3.10, compression ratio: 2.90 
    Average prefix length: 8.07, average data length: 0.93 
    Clustering factor: 1467835, ratio: 0.15 
    Fill distribution: 
         0 - 19% = 192 
        20 - 39% = 4348 
        40 - 59% = 4520 
        60 - 79% = 2433 
        80 - 99% = 2697 
 
    Index XQS_2100_3300_SND_ID (2) 
    Root page: 1350049, depth: 3, leaf buckets: 12822, nodes: 10043678 
    Average node length: 5.46, total dup: 9595579, max dup: 99 
    Average key length: 2.29, compression ratio: 3.94 
    Average prefix length: 8.76, average data length: 0.24 
    Clustering factor: 2125349, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 31 
        20 - 39% = 1382 
        40 - 59% = 9142 
        60 - 79% = 1695 
        80 - 99% = 572 
 
    Index XQS_2100_3300_WORKER_ID (0) 
    Root page: 985805, depth: 3, leaf buckets: 10562, nodes: 10043678 
    Average node length: 5.17, total dup: 10043578, max dup: 171231 
    Average key length: 2.00, compression ratio: 1.20 
    Average prefix length: 2.41, average data length: 0.00 
    Clustering factor: 1577159, ratio: 0.16 
    Fill distribution: 
         0 - 19% = 38 
        20 - 39% = 1299 
        40 - 59% = 5337 
        60 - 79% = 1703 
        80 - 99% = 2185 
 
XQS_3300_3400 (187) 
    Primary pointer page: 571, Index root page: 572 
    Total formats: 1, used formats: 1 
    Average record length: 67.55, total records: 581778 
    Average version length: 68.71, total versions: 5342, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.87 
    Pointer pages: 5, data page slots: 8040 
    Data pages: 8040, average fill: 76% 
    Primary pages: 8040, secondary pages: 0, swept pages: 3889 
    Empty pages: 0, full pages: 6956 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 24 
    40 - 59% = 165 
    60 - 79% = 7781 
    80 - 99% = 70 
 
    Index XQS_3300_3400_DOC_ID (1) 
    Root page: 38068, depth: 3, leaf buckets: 746, nodes: 581778 
    Average node length: 5.95, total dup: 495279, max dup: 83 
    Average key length: 3.09, compression ratio: 2.91 
    Average prefix length: 8.06, average data length: 0.94 
    Clustering factor: 101355, ratio: 0.17 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 28 
        40 - 59% = 538 
        60 - 79% = 94 
        80 - 99% = 86 
 
    Index XQS_3300_3400_SND_ID (2) 
    Root page: 29028, depth: 3, leaf buckets: 768, nodes: 581778 
    Average node length: 6.15, total dup: 477107, max dup: 21 
    Average key length: 3.29, compression ratio: 2.73 
    Average prefix length: 7.89, average data length: 1.11 
    Clustering factor: 101408, ratio: 0.17 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 25 
        40 - 59% = 553 
        60 - 79% = 94 
        80 - 99% = 96 
 
    Index XQS_3300_3400_WORKER_ID (0) 
    Root page: 375548, depth: 2, leaf buckets: 567, nodes: 581778 
    Average node length: 4.86, total dup: 581678, max dup: 9607 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.41, average data length: 0.00 
    Clustering factor: 89949, ratio: 0.15 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 32 
        40 - 59% = 319 
        60 - 79% = 81 
        80 - 99% = 135 
 
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 Mon Feb 26 01:11:47 2024

Record versions statistics, table

TABLE_NAME TOTAL_RECS TOTAL_VERS MAX_VERSIONS VERS_TO_RECS_PRC MAXV_TO_VERS_PRC
DOC_DATA 7827019 90464 1 0.0000 0.0000
DOC_LIST 2290738 91902 3 0.0000 0.0000
FB_ERRORS 2182 757 1 0.0000 0.0000
INVNT_SALDO 400 238568 622 59600.0000 0.0000
INVNT_TURNOVER_LOG 97906 78221 1 0.0000 0.0000
MONEY_SALDO 49 19626 1038 40000.0000 0.0000
MONEY_TURNOVER_LOG 952 843 1 0.0000 0.0000
PDISTR 773554 62554 4 0.0000 0.0000
PERF_SPLIT_0 188373 11883 1 0.0000 0.0000
PERF_SPLIT_1 176877 7814 1 0.0000 0.0000
PERF_SPLIT_2 188050 23582 1 0.0000 0.0000
PERF_SPLIT_3 166839 4877 1 0.0000 0.0000
PERF_SPLIT_4 157579 8851 1 0.0000 0.0000
PERF_SPLIT_5 179331 7828 1 0.0000 0.0000
PERF_SPLIT_6 185998 14522 1 0.0000 0.0000
PERF_SPLIT_7 181231 6914 1 0.0000 0.0000
PERF_SPLIT_8 189792 4901 1 0.0000 0.0000
PERF_SPLIT_9 179074 18325 1 0.0000 0.0000
PSTORNED 2146236 41650 1 0.0000 0.0000
SEMAPHORES 5 1 1 0.0000 100.0000
XQD_1000_1200 154062 63505 1 0.0000 0.0000
XQD_1000_3300 6887910 387678 1 0.0000 0.0000
XQD_1200_2000 11878812 306219 1 0.0000 0.0000
XQD_2000_3300 1557877 602733 1 0.0000 0.0000
XQD_2100_3300 1205511 548750 1 0.0000 0.0000
XQD_3300_3400 9451845 443334 1 0.0000 0.0000
XQS_1000_1200 21198809 12159 1 0.0000 0.0000
XQS_1000_3300 9917993 450986 1 0.0000 0.0000
XQS_1200_2000 11532285 335433 1 0.0000 0.0000
XQS_2100_3300 10043678 458731 1 0.0000 0.0000
XQS_3300_3400 581778 5342 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 ---
:1151: 
:1152: mscs-test-161.budzdorov.ru    Mon Feb 26 01:09:40 2024
:1153:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:1154: 
:1155: 
:1156: mscs-test-161.budzdorov.ru    Mon Feb 26 01:09:40 2024
:1157:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:1158: 
:1159: 
:1160: mscs-test-161.budzdorov.ru    Mon Feb 26 01:09:41 2024
:1161:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:1162: 
:1163: 
:1164: mscs-test-161.budzdorov.ru    Mon Feb 26 01:09:43 2024
:1165:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:1166: 
:1167: 
:1168: mscs-test-161.budzdorov.ru    Mon Feb 26 01:09:44 2024
:1169:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:1170: 
--- end of diff output ---

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

26.02.24 01:11:59. 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-26 01:12:01 No severe PSQL-related problems occured
26.02.24 01:12:02. End of report.