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

Server and database settinfs 


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

Test configuration settings 

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

Test finish info 


FINISH_STATE                    NORMAL: TEST_TIME EXPIRED AT 2024-03-30 10:07:51
DTS_END                         2024-03-30 10:07:51.6610
FB_GDSCODE                      -1
FB_MNEMONA                      
STACK                           SP_CANCEL_SUPPLIER_ORDER(134:18) ==> SP_CANCEL_SUPPLIER_INVOICE(36:5) ==> SP_CHECK_TO_STOP_WORK(32:12) ==> SP_HALT_ON_ERROR(68:17)
IP                              ::1/36896
TRN_ID                          176858
ATT_ID                          546
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: 9589.79 18867 958979
customer order: creation 182.48 391 18248
customer order: refuse 15.81 363 1581
order to supplier: creation 48.98 1268 4898
order to supplier: removal 3.48 93604 348
invoice (draft): creation 49.67 3032 4967
invoice (draft): removal 51.29 676 5129
invoice accept: apply 44.73 20428 4473
invoice accept: cancel 46.10 664 4610
customer reserve: creation 4288.64 197 428864
customer reserve: removal 4559.13 56 455913
realization accept: apply 88.08 176 8808
realization accept: cancel 75.38 146 7538
payment from customer: creation 63.01 122 6301
payment from customer: removal 6.31 101 631
payment to supplier: creation 50.97 155 5097
payment to supplier: removal 3.50 61 350
service: total inventory turnovers 4.67 3230 467
service: total monetary turnovers 6.45 548 645
service: aggregate perf. data 1.08 13091 108
service: refresh index statistics 0.03 239040 3

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:03, from 30-03-2024 10:08:53 to 30-03-2024 10:08:56.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 4085
TEST_TIME 2 4345
TEST_TIME 3 5354
TEST_TIME 4 4489
TEST_TIME 5 5121
TEST_TIME 6 4875
TEST_TIME 7 5240
TEST_TIME 8 5830
TEST_TIME 9 6108
TEST_TIME 10 6039
TEST_TIME 11 6297
TEST_TIME 12 6498
TEST_TIME 13 6584
TEST_TIME 14 6713
TEST_TIME 15 6858
TEST_TIME 16 7124
TEST_TIME 17 7347
TEST_TIME 18 7579
TEST_TIME 19 7603
TEST_TIME 20 7680
TEST_TIME 21 7846
TEST_TIME 22 7923
TEST_TIME 23 8376
TEST_TIME 24 8633
TEST_TIME 25 8921
TEST_TIME 26 10259
TEST_TIME 27 10283
TEST_TIME 28 10251
TEST_TIME 29 10077
TEST_TIME 30 9943
TEST_TIME 31 9986
TEST_TIME 32 10065
TEST_TIME 33 10239
TEST_TIME 34 10099
TEST_TIME 35 10194
TEST_TIME 36 10323
TEST_TIME 37 10180
TEST_TIME 38 10077
TEST_TIME 39 9880
TEST_TIME 40 9809
TEST_TIME 41 9787
TEST_TIME 42 9677
TEST_TIME 43 9770
TEST_TIME 44 9772
TEST_TIME 45 9688
TEST_TIME 46 9654
TEST_TIME 47 9569
TEST_TIME 48 9537
TEST_TIME 49 9525
TEST_TIME 50 9396
TEST_TIME 51 9352
TEST_TIME 52 9263
TEST_TIME 53 9296
TEST_TIME 54 9315
TEST_TIME 55 9316
TEST_TIME 56 9305
TEST_TIME 57 9434
TEST_TIME 58 9513
TEST_TIME 59 9528
TEST_TIME 60 9542
TEST_TIME 61 9528
TEST_TIME 62 9626
TEST_TIME 63 9704
TEST_TIME 64 9715
TEST_TIME 65 9578
TEST_TIME 66 9524
TEST_TIME 67 9478
TEST_TIME 68 9492
TEST_TIME 69 9445
TEST_TIME 70 9398
TEST_TIME 71 9370
TEST_TIME 72 9356
TEST_TIME 73 9441
TEST_TIME 74 9417
TEST_TIME 75 9491
TEST_TIME 76 9459
TEST_TIME 77 9483
TEST_TIME 78 9505
TEST_TIME 79 9568
TEST_TIME 80 9534
TEST_TIME 81 9701
TEST_TIME 82 9659
TEST_TIME 83 9675
TEST_TIME 84 9642
TEST_TIME 85 9552
TEST_TIME 86 9534
TEST_TIME 87 9514
TEST_TIME 88 9453
TEST_TIME 89 9433
TEST_TIME 90 9384
TEST_TIME 91 9447
TEST_TIME 92 9416
TEST_TIME 93 9456
TEST_TIME 94 9461
TEST_TIME 95 9497
TEST_TIME 96 9547
TEST_TIME 97 9576
TEST_TIME 98 9594
TEST_TIME 99 9577
TEST_TIME 100 9597

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:03, from 30-03-2024 10:08:57 to 30-03-2024 10:09:00.

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 1351204 1351204 0 0.00 0 35906 8 0 0
doc_list_biud 1351199 1351199 0 0.00 0 84640 24 0 0
sp_add_invoice_to_stock 4561 4473 88 1.92 48 188532 20429 0 88
sp_cancel_adding_invoice 4610 4610 0 0.00 4 61489 665 0 0
sp_cancel_client_order 1581 1581 0 0.00 4 11046 363 0 0
sp_cancel_customer_reserve 455913 455913 0 0.00 0 34695 57 0 0
sp_cancel_pay_from_customer 631 631 0 0.00 2 8908 102 0 0
sp_cancel_pay_to_supplier 350 350 0 0.00 2 3700 62 0 0
sp_cancel_supplier_invoice 5133 5129 4 0.07 2 86356 676 0 4
sp_cancel_supplier_order 348 348 0 0.00 6 977143 93604 0 0
sp_cancel_write_off 7538 7538 0 0.00 1 22925 147 0 0
sp_client_order 18248 18248 0 0.00 3 29042 391 0 0
sp_customer_reserve 428864 428864 0 0.00 0 51197 197 0 0
sp_fill_shopping_cart 28100 28100 0 0.00 1 8888 34 0 0
sp_fill_shopping_cart_clo_res 428857 428857 0 0.00 0 14096 18 0 0
sp_get_clo_for_invoice 4465 4465 0 0.00 0 27809 345 0 0
sp_kill_cost_storno 13129 13129 0 0.00 0 20896 72 0 0
sp_kill_qstorno_ret_qs2qd 924841 924841 0 0.00 0 84639 30 0 0
sp_kill_qty_storno 488392 488392 0 0.00 0 84639 65 0 0
sp_lock_selected_doc 18347 18347 0 0.00 0 9950 4 0 0
sp_make_cost_storno 24671 24671 0 0.00 0 17236 64 0 0
sp_multiply_rows_for_pdistr 24671 24671 0 0.00 0 22868 37 0 0
sp_multiply_rows_for_qdistr 18248 18248 0 0.00 0 16230 207 0 0
sp_pay_from_customer 6301 6301 0 0.00 3 17144 123 0 0
sp_pay_to_supplier 5097 5097 0 0.00 4 22923 156 0 0
sp_payment_common 11398 11398 0 0.00 1 11910 23 0 0
sp_qd_handle_on_cancel_clo 1581 1581 0 0.00 0 11038 336 0 0
sp_qd_handle_on_invoice_upd_sts 9075 9075 0 0.00 0 24145 279 0 0
sp_qd_handle_on_reserve_upd_sts 8808 8808 0 0.00 0 7283 47 0 0
sp_reserve_write_off 8808 8808 0 0.00 6 17698 176 0 0
sp_supplier_invoice 4967 4967 0 0.00 6 88143 3032 0 0
sp_supplier_order 4898 4898 0 0.00 5 74492 1268 0 0
srv_aggregate_perf_data 108 108 0 0.00 1587 118176 13092 0 0
srv_fill_mon_cache_memory 59 59 0 0.00 653 128852 36742 0 0
srv_find_qd_qs_mism 913615 913615 0 0.00 0 35906 7 0 0
srv_make_invnt_saldo 467 467 0 0.00 24 95516 3230 0 0
srv_make_money_saldo 645 645 0 0.00 1 14428 548 0 0
srv_recalc_idx_stat 3 3 0 0.00 171581 324895 239040 0 0
t$perf-abend:sp_add_invoice_to_stock 88 88 0 0.00 0 0 0 0 0
t$perf-abend:sp_cancel_supplier_invoice 4 4 0 0.00 0 0 0 0 0
t$perf-norm:sp_add_invoice_to_stock 4473 4473 0 0.00 0 8207 172 0 0
t$perf-norm:sp_cancel_adding_invoice 325 325 0 0.00 0 1456 59 0 0
t$perf-norm:sp_cancel_client_order 1581 1581 0 0.00 0 2561 10 0 0
t$perf-norm:sp_cancel_customer_reserve 635 635 0 0.00 0 1191 10 0 0
t$perf-norm:sp_cancel_pay_from_customer 631 631 0 0.00 0 1006 4 0 0
t$perf-norm:sp_cancel_pay_to_supplier 350 350 0 0.00 0 160 3 0 0
t$perf-norm:sp_cancel_supplier_invoice 330 330 0 0.00 0 621 11 0 0
t$perf-norm:sp_cancel_supplier_order 348 348 0 0.00 0 21273 1481 0 0
t$perf-norm:sp_cancel_write_off 874 874 0 0.00 0 2081 6 0 0
t$perf-norm:sp_client_order 18248 18248 0 0.00 0 6798 14 0 0
t$perf-norm:sp_customer_reserve 860 860 0 0.00 0 2208 7 0 0
t$perf-norm:sp_pay_from_customer 6301 6301 0 0.00 0 3534 6 0 0
t$perf-norm:sp_pay_to_supplier 5097 5097 0 0.00 0 4165 8 0 0
t$perf-norm:sp_reserve_write_off 8808 8808 0 0.00 0 4853 9 0 0
t$perf-norm:sp_supplier_invoice 4967 4967 0 0.00 0 2850 13 0 0
t$perf-norm:sp_supplier_order 4898 4898 0 0.00 0 7848 16 0 0
t$perf-norm:srv_aggregate_perf_data 108 108 0 0.00 0 286 6 0 0
t$perf-norm:srv_fill_mon_cache_memory 59 59 0 0.00 0 1430 25 0 0
t$perf-norm:srv_make_invnt_saldo 467 467 0 0.00 0 1641 14 0 0
t$perf-norm:srv_make_money_saldo 645 645 0 0.00 0 568 3 0 0
t$perf-norm:srv_recalc_idx_stat 3 3 0 0.00 2 9 6 0 0
v_add_invoice_to_stock 9106 8930 176 1.93 0 4020 15 0 176
v_all_customers 33786 33786 0 0.00 0 20 1 0 0
v_all_suppliers 27768 27768 0 0.00 0 21 1 0 0
v_all_wares 36496 36496 0 0.00 0 20 1 0 0
v_cancel_adding_invoice 650 650 0 0.00 0 608 7 0 0
v_cancel_client_order 3162 3162 0 0.00 0 2033 7 0 0
v_cancel_customer_prepayment 1262 1262 0 0.00 0 852 6 0 0
v_cancel_customer_reserve 1270 1270 0 0.00 0 559 3 0 0
v_cancel_payment_to_supplier 700 700 0 0.00 0 1209 5 0 0
v_cancel_supplier_invoice 668 660 8 1.19 0 1652 17 0 8
v_cancel_supplier_order 696 696 0 0.00 0 209 3 0 0
v_cancel_write_off 1748 1748 0 0.00 0 2045 15 0 0
v_max_id_clo_ord 4898 4898 0 0.00 0 690 1 0 0
v_max_id_clo_res 860 860 0 0.00 0 3368 18 0 0
v_max_id_ord_sup 4953 4953 0 0.00 0 4837 5 0 0
v_max_non_paid_invoice 1064 1064 0 0.00 0 576 3 0 0
v_max_non_paid_realizn 3102 3102 0 0.00 0 1355 3 0 0
v_min_id_clo_ord 4898 4898 0 0.00 0 2241 6 0 0
v_min_id_clo_res 860 860 0 0.00 0 2324 9 0 0
v_min_id_ord_sup 4953 4953 0 0.00 0 5532 7 0 0
v_min_non_paid_invoice 5097 5097 0 0.00 0 11303 15 0 0
v_min_non_paid_realizn 6301 6301 0 0.00 0 11906 19 0 0
v_our_firm 9108 9108 0 0.00 0 30 1 0 0
v_reserve_write_off 17616 17616 0 0.00 0 2118 5 0 0
x_lock_depdocs_on_canc_invoice 9409 9409 0 0.00 0 19291 123 0 0
x_lock_depdocs_on_canc_sup_ord 348 348 0 0.00 0 16382 410 0 0
x_make_qstorno_1000_1200 4898 4898 0 0.00 1 74460 1199 0 0
x_make_qstorno_1200_2000 4967 4967 0 0.00 3 88049 2910 0 0
x_make_qstorno_2100_3300 428864 428864 0 0.00 0 51196 177 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 30-03-2024 10:09:02 to 30-03-2024 10:09:06.

Memory consumption, metadata cache, attachments activity 

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


Page cache type: shared, buffers: 1000000 for all connections, with total size: 8192000000
measurement_dts measurement duration ms page cache memo used memo used, total memo allocated, total metadata cache metadata cache percent of total total attachments cnt active attachments cnt running statements cnt stalled statements cnt memo used by attachments memo used by transactions memo used by statements
08:07:55 1820 8192000000 8955933664 9021788160 17552176 0.213 5 2 4 0 18022176 153200 316800
08:08:58 27988 8192000000 9711414432 10007957504 783513008 8.729 100 92 184 0 813167568 7640400 22014160
08:10:35 22997 8192000000 9745575680 10052378624 811965248 9.017 100 86 172 0 844081408 11821120 20295040
08:12:05 18733 8192000000 9782781696 10103345152 848067152 9.381 100 79 158 0 883594832 18395376 17132304
08:13:31 16197 8192000000 9847625216 10176970752 892290944 9.822 100 83 164 0 939798400 29923808 17583648
08:14:53 8006 8192000000 9885006640 10227310592 916208736 10.059 100 78 156 0 994691040 62678016 15804288
08:16:03 2890 8192000000 9919526784 10272223232 957031040 10.460 100 79 159 0 1026197712 53976832 15189840
08:17:09 3794 8192000000 9967762512 10330062848 984993328 10.733 100 78 156 0 1074029760 74182432 14854000
08:18:14 2404 8192000000 9991186384 10355707904 1006802416 10.944 100 82 164 1 1086715600 64695584 15217600
08:19:18 1024 8192000000 10009527088 10380419072 1029321776 11.162 100 75 147 1 1109762560 66455552 13985232
08:20:20 10259 8192000000 10004174848 10387898368 1040956416 11.274 100 61 121 0 1106928640 54202320 11769904
08:21:32 10442 8192000000 9965449968 10364100608 1046253552 11.325 100 33 67 2 1075647280 21739040 7654688
08:22:43 8773 8192000000 9969093184 10361749504 1053276784 11.392 100 44 89 2 1084979744 22260144 9442816
08:23:54 6502 8192000000 9975574960 10384642048 1059185552 11.449 100 29 57 1 1093035008 28207392 5642064
08:25:05 38305 8192000000 9977125536 10386370560 1063122304 11.486 100 20 38 1 1090938608 23694976 4121328
08:26:47 5739 8192000000 9998278240 10401259520 1069584608 11.548 100 36 71 1 1098918656 21902144 7431904
08:27:57 6497 8192000000 9998622480 10394529792 1070418976 11.556 100 48 90 2 1092532512 12491024 9622512
08:29:11 17058 8192000000 10029012864 10422452224 1072738880 11.578 99 59 114 0 1135786480 51854368 11193232
08:31:02 72045 8192000000 10067817936 10476552192 1082558256 11.672 99 44 87 0 1196556944 105328992 8669696
08:33:20 15441 8192000000 10081136640 10493489152 1108918128 11.922 100 42 84 0 1200972624 83578784 8475712
08:34:39 18824 8192000000 10082350560 10495143936 1049694880 11.358 95 43 86 0 1153798816 95085360 9018576
08:36:06 7913 8192000000 10087010160 10484383744 1071974368 11.571 98 44 84 0 1185947952 104917888 9055696
08:37:19 11631 8192000000 10096353056 10499608576 1087549648 11.719 99 43 86 0 1217624912 121122208 8953056
08:38:37 6539 8192000000 10113629632 10515365888 1084769792 11.693 100 48 96 0 1227338688 132333824 10235072
08:39:47 3615 8192000000 10111835776 10519322624 1072774704 11.579 99 60 118 0 1213036048 127701712 12559632
08:40:56 1563 8192000000 10128926960 10520870912 1065622608 11.510 99 64 125 0 1227591552 149124048 12844896
08:42:01 2390 8192000000 10147571104 10527944704 1069732672 11.550 98 67 135 0 1244948448 160875232 14340544
08:43:10 649 8192000000 10190322080 10598600704 1098123824 11.820 100 71 141 0 1292200336 178422912 15653600
08:44:17 1170 8192000000 10230342800 10630692864 1104918496 11.884 100 87 173 1 1325964368 202943472 18102400
08:45:20 4484 8192000000 10277021424 10683002880 1112125744 11.953 99 73 144 0 1369237504 241214064 15897696
08:46:29 2557 8192000000 10297370576 10697064448 1124756208 12.072 100 66 133 0 1396629216 257390208 14482800
08:47:39 2947 8192000000 10359007568 10751057920 1140340784 12.219 100 88 170 0 1455806240 297307584 18157872
08:48:44 14297 8192000000 10402626528 10837278720 1143272768 12.246 100 36 70 0 1522200912 369978096 8950048
08:50:12 11236 8192000000 10405070448 10866356224 1141419200 12.229 100 37 74 0 1494988784 344257216 9312368
08:51:29 16343 8192000000 10383250576 10823417856 1134764960 12.166 100 22 42 0 1477630832 337734256 5131616
08:52:50 19319 8192000000 10249914464 10761539584 1114326032 11.973 100 20 41 0 1436436848 316912864 5197952
08:55:02 80666 8192000000 10043253616 10453643264 1102852368 11.865 98 21 36 1 1133665216 27360400 3452448
08:57:27 25316 8192000000 10088234208 10507595776 1114588672 11.976 100 34 66 0 1180471824 58894160 6988992
08:58:57 41498 8192000000 10099347168 10540773376 1126730320 12.091 100 19 38 1 1200004848 69309440 3965088
09:00:41 46943 8192000000 10074489904 10503606272 1134675952 12.165 100 35 70 0 1167588896 26182080 6730864
09:02:31 45746 8192000000 10108713744 10563981312 1141073856 12.226 100 11 20 0 1197960400 54476512 2410032
09:04:30 99810 8192000000 10081007248 10554343424 1141852768 12.233 100 20 40 1 1194503872 48549552 4101552
09:07:14 14443 8192000000 10087597824 10541953024 1151098608 12.320 100 34 68 0 1184429152 26725456 6605088
09:08:30 20408 8192000000 10112272208 10571096064 1156988448 12.375 100 22 44 0 1213887552 52667760 4231344
09:09:51 19040 8192000000 10158673376 10601758720 1132928032 12.149 98 37 71 0 1231539584 91773008 6838544
09:11:17 41871 8192000000 10084453264 10543767552 1128121440 12.104 98 14 28 0 1180265728 49188384 2955904
09:13:01 88413 8192000000 10083266000 10550575104 1099614752 11.834 96 17 34 0 1141144160 37780064 3749344
09:15:31 43271 8192000000 10090837232 10563330048 1134326368 12.162 100 12 23 1 1200339200 63468128 2544704
09:17:32 15321 8192000000 10057123696 10497196032 1120904768 12.036 99 38 77 2 1151828640 23392000 7531872
09:18:48 49948 8192000000 10042159872 10504933376 1097772064 11.816 97 10 20 0 1124849808 25268704 1809040
09:20:38 27015 8192000000 10065121632 10512519168 1093639568 11.777 97 36 70 0 1144459312 44089904 6729840
09:22:06 36957 8192000000 10075512240 10512707584 1074497792 11.595 96 36 73 0 1148388016 66751472 7138752
09:23:44 48214 8192000000 10042625136 10509750272 1091419728 11.756 98 21 42 1 1156409472 60901424 4088320
09:25:42 53899 8192000000 10096220464 10564145152 1088187008 11.725 98 20 38 1 1148068304 56011040 3870256
09:27:45 18789 8192000000 10046667184 10460291072 1067636240 11.530 97 43 85 0 1116335808 40603856 8095712
09:29:09 71178 8192000000 10074711504 10553618432 1052567632 11.385 96 22 44 0 1113092112 56535312 3989168
09:31:27 103436 8192000000 10041462592 10469695488 1081540384 11.662 98 37 73 0 1136456608 47931248 6984976
09:34:32 45602 8192000000 10036502816 10500616192 1103164768 11.868 100 16 32 0 1159319744 53028080 3126896
09:36:18 27342 8192000000 10010502480 10471383040 1074861264 11.598 98 10 20 0 1098469328 22055552 1552512
09:37:47 32379 8192000000 10011106144 10446856192 1047567936 11.337 95 13 26 1 1067695696 17697696 2430064
09:39:22 80561 8192000000 10053519232 10508361728 1084345584 11.689 97 16 32 0 1142487904 54956976 3185344
09:41:49 39178 8192000000 10094035776 10538360832 1120426192 12.031 99 29 58 0 1170653120 44398928 5828000
09:43:28 25640 8192000000 10092404480 10518732800 1131943872 12.140 100 26 52 0 1187706496 50626336 5136288
09:44:58 50722 8192000000 10112293664 10561953792 1134856480 12.167 100 25 49 0 1195458816 55971728 4630608
09:46:50 55761 8192000000 10158400592 10616479744 1139621424 12.212 99 16 31 0 1220439600 77574992 3243184
09:48:48 61681 8192000000 10124191728 10573156352 1126090128 12.084 98 18 36 0 1175204624 45729648 3384848
09:50:57 128850 8192000000 10067329840 10519642112 1146144240 12.273 100 29 56 0 1201068800 49486464 5438096
09:54:08 70719 8192000000 10104355712 10581123072 1153382528 12.341 100 16 32 0 1214267792 57713776 3171488
09:56:19 45913 8192000000 10098432768 10548854784 1123734208 12.062 97 23 47 0 1175564896 46715680 5115008
09:58:05 63972 8192000000 10093648864 10579464192 1132548784 12.145 99 15 30 0 1203457696 67747664 3161248
10:00:14 39538 8192000000 10086027888 10524266496 1105870112 11.893 97 27 54 0 1153753184 42191072 5692000
10:02:05 59158 8192000000 10108992896 10585628672 1103296400 11.869 97 22 44 0 1182479280 74872912 4309968
10:04:16 67337 8192000000 10079591488 10522091520 1110868528 11.941 100 16 30 0 1155631120 41831168 2931424
10:06:23 10740 8192000000 10056915568 10485432320 1089509456 11.738 98 43 86 1 1133366272 35979040 7877776
10:07:40 33925 8192000000 9203013296 9507868672 328728320 3.857 31 3 6 0 371373920 42084400 561200

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


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

Exceptions occured during test was in run

FB_MNEMONA CNT UNIT FB_GDSCODE
except 88 v_add_invoice_to_stock 335544517
except 4 v_cancel_supplier_invoice 335544517

Completed "Exceptions occured during test was in run". Done for 00:00:02, from 30-03-2024 10:09:23 to 30-03-2024 10:09:25.

Content of mon$database and FB version 


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


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

Database statistics 

 
Database "/home/bases/oltp40-etalone.fdb" 
Gstat execution time Sat Mar 30 10:09:26 2024 
 
Database header page information: 
    Flags            0 
    Generation        92672 
    System Change Number    0 
    Page size        8192 
    ODS version        13.0 
    Oldest transaction    177652 
    Oldest active        177653 
    Oldest snapshot        177653 
    Next transaction    177654 
    Sequence number        0 
    Next attachment ID    708 
    Implementation        HW=AMD/Intel/x64 little-endian OS=Linux CC=gcc 
    Shadow count        0 
    Page buffers        0 
    Next header page    0 
    Database dialect    3 
    Creation date        Apr 30, 2020 7:30:08 
    Attributes        force write 
 
    Variable header data: 
    Database GUID:    {58978C10-B735-40F5-8B7D-F7A1956E782B} 
    Sweep interval:        0 
    *END* 
 
 
Database file sequence: 
File /home/bases/oltp40-etalone.fdb is the only file 
 
Analyzing database pages ... 
AGENTS (150) 
    Primary pointer page: 524, Index root page: 525 
    Total formats: 1, used formats: 1 
    Average record length: 33.60, total records: 50 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 344.00, compression ratio: 10.24 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 31% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 1 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index AGENTS_ID_DESC (2) 
    Root page: 1504333, depth: 1, leaf buckets: 1, nodes: 50 
    Average node length: 11.82, total dup: 0, max dup: 0 
    Average key length: 10.80, compression ratio: 0.83 
    Average prefix length: 1.18, average data length: 7.82 
    Clustering factor: 1, ratio: 0.02 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index AGENTS_IS_OUR_FIRM (4) 
    Root page: 1504335, depth: 1, leaf buckets: 1, nodes: 50 
    Average node length: 3.08, total dup: 48, max dup: 48 
    Average key length: 2.04, compression ratio: 0.50 
    Average prefix length: 0.96, average data length: 0.06 
    Clustering factor: 1, ratio: 0.02 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index AGENTS_IS_SUPPLIER (3) 
    Root page: 1504334, depth: 1, leaf buckets: 1, nodes: 50 
    Average node length: 3.08, total dup: 48, max dup: 44 
    Average key length: 2.04, compression ratio: 0.54 
    Average prefix length: 1.04, average data length: 0.06 
    Clustering factor: 1, ratio: 0.02 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index AGENTS_NAME_UNQ (1) 
    Root page: 1504332, depth: 1, leaf buckets: 1, nodes: 50 
    Average node length: 17.20, total dup: 0, max dup: 0 
    Average key length: 15.88, compression ratio: 0.92 
    Average prefix length: 1.42, average data length: 13.20 
    Clustering factor: 1, ratio: 0.02 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PK_AGENTS (0) 
    Root page: 1504331, depth: 1, leaf buckets: 1, nodes: 50 
    Average node length: 11.82, total dup: 0, max dup: 0 
    Average key length: 10.80, compression ratio: 0.83 
    Average prefix length: 1.18, average data length: 7.82 
    Clustering factor: 1, ratio: 0.02 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
BUSINESS_OPS (154) 
    Primary pointer page: 532, Index root page: 533 
    Total formats: 1, used formats: 1 
    Average record length: 108.20, total records: 20 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1235.00, compression ratio: 11.41 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 31% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 1 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index BO_UNIT_UNQ (1) 
    Root page: 1504264, depth: 1, leaf buckets: 1, nodes: 20 
    Average node length: 18.25, total dup: 0, max dup: 0 
    Average key length: 17.20, compression ratio: 1.24 
    Average prefix length: 7.05, average data length: 14.25 
    Clustering factor: 1, ratio: 0.05 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index BUSINESS_OPS_PREDICT_PRIOR (3) 
    Root page: 1504266, depth: 1, leaf buckets: 1, nodes: 20 
    Average node length: 5.40, total dup: 0, max dup: 0 
    Average key length: 4.35, compression ratio: 0.67 
    Average prefix length: 1.20, average data length: 1.70 
    Clustering factor: 1, ratio: 0.05 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index BUSINESS_OPS_RND_WGTH (2) 
    Root page: 1504265, depth: 1, leaf buckets: 1, nodes: 20 
    Average node length: 4.30, total dup: 6, max dup: 3 
    Average key length: 3.25, compression ratio: 0.72 
    Average prefix length: 1.35, average data length: 1.00 
    Clustering factor: 1, ratio: 0.05 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index RDB$1 (0) 
    Root page: 1504263, depth: 1, leaf buckets: 1, nodes: 20 
    Average node length: 5.20, total dup: 0, max dup: 0 
    Average key length: 4.15, compression ratio: 0.65 
    Average prefix length: 1.10, average data length: 1.60 
    Clustering factor: 1, ratio: 0.05 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
DOC_DATA (139) 
    Primary pointer page: 502, Index root page: 503 
    Total formats: 1, used formats: 1 
    Average record length: 47.15, total records: 7800485 
    Average version length: 48.16, total versions: 149052, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 64.00, compression ratio: 1.36 
    Pointer pages: 55, data page slots: 89384 
    Data pages: 89384, average fill: 70% 
    Primary pages: 89383, secondary pages: 1, swept pages: 27697 
    Empty pages: 8, full pages: 77350 
    Fill distribution: 
     0 - 19% = 17 
    20 - 39% = 99 
    40 - 59% = 1761 
    60 - 79% = 87381 
    80 - 99% = 126 
 
    Index DOC_DATA_DOC_WARE_UNQ (0) 
    Root page: 1510636, depth: 3, leaf buckets: 23396, nodes: 7800485 
    Average node length: 18.91, total dup: 0, max dup: 0 
    Average key length: 15.92, compression ratio: 1.70 
    Average prefix length: 14.08, average data length: 12.92 
    Clustering factor: 1676724, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 340 
        20 - 39% = 1764 
        40 - 59% = 4266 
        60 - 79% = 2311 
        80 - 99% = 14715 
 
    Index DOC_DATA_ID_DESC (1) 
    Root page: 1528140, depth: 3, leaf buckets: 13584, nodes: 7800485 
    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: 1501065, ratio: 0.19 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 1518 
        40 - 59% = 2175 
        60 - 79% = 1076 
        80 - 99% = 8815 
 
    Index FK_DOC_DATA_DOC_LIST (2) 
    Root page: 1546735, depth: 3, leaf buckets: 8387, nodes: 7800485 
    Average node length: 6.63, total dup: 5820733, max dup: 49 
    Average key length: 3.64, compression ratio: 2.47 
    Average prefix length: 7.61, average data length: 1.39 
    Clustering factor: 1494020, ratio: 0.19 
    Fill distribution: 
         0 - 19% = 139 
        20 - 39% = 918 
        40 - 59% = 1467 
        60 - 79% = 879 
        80 - 99% = 4984 
 
DOC_LIST (138) 
    Primary pointer page: 500, Index root page: 501 
    Total formats: 1, used formats: 1 
    Average record length: 55.76, total records: 2271162 
    Average version length: 58.89, total versions: 79452, max versions: 2 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 84.00, compression ratio: 1.51 
    Pointer pages: 18, data page slots: 28616 
    Data pages: 28616, average fill: 73% 
    Primary pages: 28614, secondary pages: 2, swept pages: 6595 
    Empty pages: 6, full pages: 25206 
    Fill distribution: 
     0 - 19% = 9 
    20 - 39% = 7 
    40 - 59% = 151 
    60 - 79% = 28282 
    80 - 99% = 167 
 
    Index DOC_LIST_ID_DESC (1) 
    Root page: 1541152, depth: 3, leaf buckets: 4592, nodes: 2271162 
    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: 680842, ratio: 0.30 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 891 
        40 - 59% = 919 
        60 - 79% = 684 
        80 - 99% = 2098 
 
    Index DOC_LIST_WORKER_OPTYPE (2) 
    Root page: 1544398, depth: 3, leaf buckets: 2416, nodes: 2273107 
    Average node length: 4.97, total dup: 2272208, max dup: 19135 
    Average key length: 2.01, compression ratio: 4.48 
    Average prefix length: 8.99, average data length: 0.01 
    Clustering factor: 1272387, ratio: 0.56 
    Fill distribution: 
         0 - 19% = 3 
        20 - 39% = 177 
        40 - 59% = 1377 
        60 - 79% = 581 
        80 - 99% = 278 
 
    Index FK_DOC_LIST_AGENTS (3) 
    Root page: 1545933, depth: 3, leaf buckets: 1782, nodes: 2271162 
    Average node length: 4.97, total dup: 2271112, max dup: 130412 
    Average key length: 2.01, compression ratio: 4.48 
    Average prefix length: 8.99, average data length: 0.01 
    Clustering factor: 1070825, ratio: 0.47 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 4 
        40 - 59% = 644 
        60 - 79% = 37 
        80 - 99% = 1097 
 
    Index PK_DOC_LIST (0) 
    Root page: 1538209, depth: 3, leaf buckets: 4389, nodes: 2271162 
    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: 680842, ratio: 0.30 
    Fill distribution: 
         0 - 19% = 114 
        20 - 39% = 575 
        40 - 59% = 655 
        60 - 79% = 766 
        80 - 99% = 2279 
 
DOC_STATES (149) 
    Primary pointer page: 522, Index root page: 523 
    Total formats: 1, used formats: 1 
    Average record length: 67.50, total records: 4 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 650.00, compression ratio: 9.63 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 4% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index DOC_STATES_MCODE_UNQ (1) 
    Root page: 1504337, depth: 1, leaf buckets: 1, nodes: 4 
    Average node length: 17.75, total dup: 0, max dup: 0 
    Average key length: 16.50, compression ratio: 1.08 
    Average prefix length: 4.00, average data length: 13.75 
    Clustering factor: 1, ratio: 0.25 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index DOC_STATES_NAME_UNQ (2) 
    Root page: 1504338, depth: 1, leaf buckets: 1, nodes: 4 
    Average node length: 33.25, total dup: 0, max dup: 0 
    Average key length: 32.00, compression ratio: 0.99 
    Average prefix length: 2.50, average data length: 29.25 
    Clustering factor: 1, ratio: 0.25 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PK_DOC_STATES (0) 
    Root page: 1504336, depth: 1, leaf buckets: 1, nodes: 4 
    Average node length: 4.75, total dup: 0, max dup: 0 
    Average key length: 3.50, compression ratio: 0.86 
    Average prefix length: 1.50, average data length: 1.50 
    Clustering factor: 1, ratio: 0.25 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
FB_ERRORS (155) 
    Primary pointer page: 534, Index root page: 535 
    Total formats: 2, used formats: 2 
    Average record length: 57.88, total records: 2182 
    Average version length: 79.61, total versions: 757, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 270.43, compression ratio: 4.67 
    Pointer pages: 1, data page slots: 40 
    Data pages: 40, average fill: 72% 
    Primary pages: 39, secondary pages: 1, swept pages: 0 
    Empty pages: 4, full pages: 34 
    Fill distribution: 
     0 - 19% = 5 
    20 - 39% = 0 
    40 - 59% = 1 
    60 - 79% = 22 
    80 - 99% = 12 
 
    Index FB_ERRORS_GDS_CODE (0) 
    Root page: 398, depth: 2, leaf buckets: 2, nodes: 2182 
    Average node length: 4.40, total dup: 756, max dup: 1 
    Average key length: 2.67, compression ratio: 1.87 
    Average prefix length: 4.33, average data length: 0.67 
    Clustering factor: 1518, ratio: 0.70 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 0 
        40 - 59% = 1 
        60 - 79% = 1 
        80 - 99% = 0 
 
INVNT_SALDO (145) 
    Primary pointer page: 514, Index root page: 515 
    Total formats: 2, used formats: 1 
    Average record length: 83.22, total records: 400 
    Average version length: 20.78, total versions: 6558, max versions: 20 
    Average fragment length: 2.00, total fragments: 9, max fragments: 1 
    Average unpacked length: 104.00, compression ratio: 1.25 
    Pointer pages: 1, data page slots: 56 
    Data pages: 56, average fill: 64% 
    Primary pages: 14, secondary pages: 42, swept pages: 0 
    Empty pages: 7, full pages: 38 
    Fill distribution: 
     0 - 19% = 16 
    20 - 39% = 1 
    40 - 59% = 1 
    60 - 79% = 4 
    80 - 99% = 34 
 
    Index PK_INVNT_SALDO (0) 
    Root page: 1510371, depth: 1, leaf buckets: 1, nodes: 400 
    Average node length: 11.22, total dup: 0, max dup: 0 
    Average key length: 10.22, compression ratio: 0.88 
    Average prefix length: 1.78, average data length: 7.22 
    Clustering factor: 326, ratio: 0.81 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 0 
        40 - 59% = 1 
        60 - 79% = 0 
        80 - 99% = 0 
 
INVNT_TURNOVER_LOG (153) 
    Primary pointer page: 530, Index root page: 531 
    Total formats: 1, used formats: 1 
    Average record length: 22.35, total records: 93944 
    Average version length: 68.28, total versions: 72801, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 88.00, compression ratio: 3.94 
    Pointer pages: 7, data page slots: 2056 
    Data pages: 1544, average fill: 79% 
    Primary pages: 1543, secondary pages: 1, swept pages: 0 
    Empty pages: 45, full pages: 1195 
    Fill distribution: 
     0 - 19% = 77 
    20 - 39% = 63 
    40 - 59% = 106 
    60 - 79% = 301 
    80 - 99% = 997 
 
    Index INVNT_TURNOVER_LOG_WARE_DD_ID (0) 
    Root page: 1763404, depth: 3, leaf buckets: 292, nodes: 93944 
    Average node length: 13.36, total dup: 6084, max dup: 2 
    Average key length: 10.72, compression ratio: 2.52 
    Average prefix length: 19.22, average data length: 7.78 
    Clustering factor: 68760, ratio: 0.73 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 46 
        40 - 59% = 156 
        60 - 79% = 72 
        80 - 99% = 17 
 
MONEY_SALDO (141) 
    Primary pointer page: 506, Index root page: 507 
    Total formats: 1, used formats: 1 
    Average record length: 15.20, total records: 49 
    Average version length: 9.00, total versions: 387, max versions: 16 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 32.00, compression ratio: 2.10 
    Pointer pages: 1, data page slots: 6 
    Data pages: 6, average fill: 24% 
    Primary pages: 1, secondary pages: 5, swept pages: 0 
    Empty pages: 0, full pages: 1 
    Fill distribution: 
     0 - 19% = 4 
    20 - 39% = 0 
    40 - 59% = 1 
    60 - 79% = 0 
    80 - 99% = 1 
 
    Index PK_MONEY_SALDO (0) 
    Root page: 1510383, depth: 1, leaf buckets: 1, nodes: 49 
    Average node length: 11.82, total dup: 0, max dup: 0 
    Average key length: 10.80, compression ratio: 0.83 
    Average prefix length: 1.18, average data length: 7.82 
    Clustering factor: 1, ratio: 0.02 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
MONEY_TURNOVER_LOG (140) 
    Primary pointer page: 504, Index root page: 505 
    Total formats: 1, used formats: 1 
    Average record length: 12.53, total records: 1840 
    Average version length: 43.29, total versions: 1660, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 58.00, compression ratio: 4.63 
    Pointer pages: 1, data page slots: 40 
    Data pages: 40, average fill: 48% 
    Primary pages: 39, secondary pages: 1, swept pages: 0 
    Empty pages: 16, full pages: 19 
    Fill distribution: 
     0 - 19% = 19 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 3 
    80 - 99% = 18 
 
    Index MONEY_TURNOVER_LOG_AGENT_OPTYPE (0) 
    Root page: 91978, depth: 2, leaf buckets: 2, nodes: 1840 
    Average node length: 4.18, total dup: 1742, max dup: 194 
    Average key length: 2.56, compression ratio: 7.41 
    Average prefix length: 18.49, average data length: 0.51 
    Clustering factor: 943, ratio: 0.51 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 0 
        40 - 59% = 2 
        60 - 79% = 0 
        80 - 99% = 0 
 
MON_CACHE_MEMORY (165) 
    Primary pointer page: 555, Index root page: 556 
    Total formats: 2, used formats: 1 
    Average record length: 97.48, total records: 75 
    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: 53% 
    Primary pages: 2, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 1 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 1 
    40 - 59% = 0 
    60 - 79% = 1 
    80 - 99% = 0 
 
    Index PK_MON_CACHE_MEMORY (0) 
    Root page: 1504238, depth: 1, leaf buckets: 1, nodes: 75 
    Average node length: 11.68, total dup: 0, max dup: 0 
    Average key length: 10.67, compression ratio: 0.84 
    Average prefix length: 1.32, average data length: 7.68 
    Clustering factor: 2, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
MON_LOG (162) 
    Primary pointer page: 548, Index root page: 549 
    Total formats: 2, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index MON_LOG_DTS (4) 
    Root page: 1504251, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index MON_LOG_GDSCODE (2) 
    Root page: 1504249, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index MON_LOG_ROWSET_DESC (1) 
    Root page: 1504248, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index MON_LOG_UNIT (3) 
    Root page: 1504250, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PK_MON_LOG (0) 
    Root page: 1504247, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
MON_LOG_TABLE_STATS (163) 
    Primary pointer page: 550, Index root page: 551 
    Total formats: 2, used formats: 1 
    Average record length: 67.13, total records: 30 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 611.00, compression ratio: 9.10 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 31% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 1 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index MON_LOG_TABLE_STATS_DTS (4) 
    Root page: 1504246, depth: 1, leaf buckets: 1, nodes: 30 
    Average node length: 3.50, total dup: 23, max dup: 4 
    Average key length: 2.47, compression ratio: 3.24 
    Average prefix length: 7.53, average data length: 0.47 
    Clustering factor: 1, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index MON_LOG_TABLE_STATS_GDSCODE (2) 
    Root page: 1504244, depth: 1, leaf buckets: 1, nodes: 30 
    Average node length: 2.00, total dup: 29, max dup: 29 
    Average key length: 1.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 1, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index MON_LOG_TABLE_STATS_ROWSET (1) 
    Root page: 1504243, depth: 1, leaf buckets: 1, nodes: 30 
    Average node length: 3.33, total dup: 29, max dup: 29 
    Average key length: 2.30, compression ratio: 3.91 
    Average prefix length: 8.70, average data length: 0.30 
    Clustering factor: 1, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index MON_LOG_TABLE_STATS_TN_UNIT (3) 
    Root page: 1504245, depth: 1, leaf buckets: 1, nodes: 30 
    Average node length: 12.90, total dup: 0, max dup: 0 
    Average key length: 11.87, compression ratio: 1.42 
    Average prefix length: 7.63, average data length: 9.20 
    Clustering factor: 1, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PK_MON_LOG_TABLE_STATS (0) 
    Root page: 1504242, depth: 1, leaf buckets: 1, nodes: 30 
    Average node length: 8.37, total dup: 0, max dup: 0 
    Average key length: 7.33, compression ratio: 1.23 
    Average prefix length: 4.63, average data length: 4.37 
    Clustering factor: 1, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
OPTYPES (136) 
    Primary pointer page: 496, Index root page: 497 
    Total formats: 2, used formats: 1 
    Average record length: 67.56, total records: 9 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 386.00, compression ratio: 5.71 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 9% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index OPTYPES_MCODE_UNQ (1) 
    Root page: 1544827, depth: 1, leaf buckets: 1, nodes: 9 
    Average node length: 8.56, total dup: 0, max dup: 0 
    Average key length: 6.89, compression ratio: 0.73 
    Average prefix length: 0.44, average data length: 4.56 
    Clustering factor: 1, ratio: 0.11 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PK_OPTYPES (0) 
    Root page: 1544826, depth: 1, leaf buckets: 1, nodes: 9 
    Average node length: 6.11, total dup: 0, max dup: 0 
    Average key length: 5.00, compression ratio: 0.60 
    Average prefix length: 0.89, average data length: 2.11 
    Clustering factor: 1, ratio: 0.11 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
PDISTR (146) 
    Primary pointer page: 516, Index root page: 517 
    Total formats: 1, used formats: 1 
    Average record length: 35.67, total records: 821474 
    Average version length: 37.86, total versions: 38025, max versions: 3 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 54.00, compression ratio: 1.51 
    Pointer pages: 6, data page slots: 8408 
    Data pages: 8400, average fill: 67% 
    Primary pages: 8398, secondary pages: 2, swept pages: 798 
    Empty pages: 26, full pages: 8113 
    Fill distribution: 
     0 - 19% = 48 
    20 - 39% = 22 
    40 - 59% = 41 
    60 - 79% = 8252 
    80 - 99% = 37 
 
    Index PDISTR_AGENT_ID (2) 
    Root page: 1509330, depth: 2, leaf buckets: 853, nodes: 796183 
    Average node length: 4.88, total dup: 796134, max dup: 140671 
    Average key length: 2.01, compression ratio: 4.48 
    Average prefix length: 8.99, average data length: 0.01 
    Clustering factor: 91345, ratio: 0.11 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 129 
        40 - 59% = 445 
        60 - 79% = 174 
        80 - 99% = 105 
 
    Index PDISTR_SNDOP_RCVOP_SNDID_ASC (0) 
    Root page: 1508635, depth: 3, leaf buckets: 976, nodes: 796183 
    Average node length: 5.89, total dup: 708907, max dup: 43 
    Average key length: 3.02, compression ratio: 7.29 
    Average prefix length: 21.09, average data length: 0.91 
    Clustering factor: 160689, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 64 
        40 - 59% = 567 
        60 - 79% = 101 
        80 - 99% = 243 
 
    Index PDISTR_SNDOP_RCVOP_SNDID_DESC (1) 
    Root page: 1509209, depth: 3, leaf buckets: 1012, nodes: 796183 
    Average node length: 5.89, total dup: 708907, max dup: 43 
    Average key length: 3.02, compression ratio: 7.29 
    Average prefix length: 21.09, average data length: 0.91 
    Clustering factor: 162692, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 108 
        40 - 59% = 574 
        60 - 79% = 105 
        80 - 99% = 224 
 
    Index PDISTR_WORKER_SND_ID (3) 
    Root page: 1510200, depth: 3, leaf buckets: 1118, nodes: 796183 
    Average node length: 5.97, total dup: 708907, max dup: 43 
    Average key length: 3.10, compression ratio: 5.48 
    Average prefix length: 16.01, average data length: 0.99 
    Clustering factor: 155417, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 220 
        40 - 59% = 602 
        60 - 79% = 200 
        80 - 99% = 94 
 
PERF_AGG (158) 
    Primary pointer page: 540, Index root page: 541 
    Total formats: 1, used formats: 1 
    Average record length: 62.77, total records: 5433 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 2.90, total fragments: 42, max fragments: 1 
    Average unpacked length: 379.00, compression ratio: 6.04 
    Pointer pages: 1, data page slots: 96 
    Data pages: 95, average fill: 57% 
    Primary pages: 80, secondary pages: 15, swept pages: 44 
    Empty pages: 10, full pages: 48 
    Fill distribution: 
     0 - 19% = 21 
    20 - 39% = 1 
    40 - 59% = 1 
    60 - 79% = 72 
    80 - 99% = 0 
 
    Index PERF_AGG_UNQ (1) 
    Root page: 1504260, depth: 2, leaf buckets: 7, nodes: 5433 
    Average node length: 5.54, total dup: 0, max dup: 0 
    Average key length: 3.59, compression ratio: 9.99 
    Average prefix length: 34.35, average data length: 1.56 
    Clustering factor: 5212, ratio: 0.96 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 4 
        60 - 79% = 1 
        80 - 99% = 1 
 
    Index PK_PERF_AGG (0) 
    Root page: 1504255, depth: 2, leaf buckets: 10, nodes: 5433 
    Average node length: 11.16, total dup: 0, max dup: 0 
    Average key length: 9.21, compression ratio: 0.98 
    Average prefix length: 2.79, average data length: 6.21 
    Clustering factor: 170, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 1 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 7 
 
PERF_ESTIMATED (280) 
    Primary pointer page: 399, Index root page: 434 
    Total formats: 1, used formats: 1 
    Average record length: 39.04, total records: 80855 
    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: 840 
    Data pages: 840, average fill: 66% 
    Primary pages: 840, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 839 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 1 
    60 - 79% = 839 
    80 - 99% = 0 
 
    Index PK_PERF_ESTIMATED (0) 
    Root page: 34407, depth: 2, leaf buckets: 102, nodes: 80855 
    Average node length: 10.16, total dup: 0, max dup: 0 
    Average key length: 8.17, compression ratio: 1.10 
    Average prefix length: 3.83, average data length: 5.17 
    Clustering factor: 2982, ratio: 0.04 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 102 
 
PERF_ISQL_STAT (156) 
    Primary pointer page: 536, Index root page: 537 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index PERF_ISQL_STAT_TRN (0) 
    Root page: 1504261, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
PERF_LOG (159) 
    Primary pointer page: 542, Index root page: 543 
    Total formats: 1, used formats: 1 
    Average record length: 111.17, total records: 71 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1691.00, compression ratio: 15.21 
    Pointer pages: 1, data page slots: 2 
    Data pages: 2, average fill: 56% 
    Primary pages: 2, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 1 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 1 
    40 - 59% = 0 
    60 - 79% = 1 
    80 - 99% = 0 
 
PERF_SPLIT_0 (281) 
    Primary pointer page: 601, Index root page: 602 
    Total formats: 1, used formats: 1 
    Average record length: 149.12, total records: 172371 
    Average version length: 152.46, total versions: 2361, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.37 
    Pointer pages: 7, data page slots: 4696 
    Data pages: 4256, average fill: 84% 
    Primary pages: 4253, secondary pages: 3, swept pages: 7 
    Empty pages: 19, full pages: 4228 
    Fill distribution: 
     0 - 19% = 22 
    20 - 39% = 2 
    40 - 59% = 1 
    60 - 79% = 3 
    80 - 99% = 4228 
 
PERF_SPLIT_1 (282) 
    Primary pointer page: 603, Index root page: 604 
    Total formats: 1, used formats: 1 
    Average record length: 145.62, total records: 150332 
    Average version length: 153.02, total versions: 5392, 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: 4352 
    Data pages: 3712, average fill: 84% 
    Primary pages: 3710, secondary pages: 2, swept pages: 1 
    Empty pages: 22, full pages: 3682 
    Fill distribution: 
     0 - 19% = 25 
    20 - 39% = 2 
    40 - 59% = 2 
    60 - 79% = 0 
    80 - 99% = 3683 
 
PERF_SPLIT_2 (283) 
    Primary pointer page: 605, Index root page: 606 
    Total formats: 1, used formats: 1 
    Average record length: 148.05, total records: 134868 
    Average version length: 154.15, total versions: 2576, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.46 
    Pointer pages: 8, data page slots: 3432 
    Data pages: 3312, average fill: 84% 
    Primary pages: 3311, secondary pages: 1, swept pages: 1 
    Empty pages: 3, full pages: 3305 
    Fill distribution: 
     0 - 19% = 4 
    20 - 39% = 1 
    40 - 59% = 1 
    60 - 79% = 2 
    80 - 99% = 3304 
 
PERF_SPLIT_3 (284) 
    Primary pointer page: 607, Index root page: 616 
    Total formats: 1, used formats: 1 
    Average record length: 147.21, total records: 133030 
    Average version length: 153.94, total versions: 3393, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.52 
    Pointer pages: 7, data page slots: 3456 
    Data pages: 3288, average fill: 84% 
    Primary pages: 3287, secondary pages: 1, swept pages: 1 
    Empty pages: 20, full pages: 3259 
    Fill distribution: 
     0 - 19% = 22 
    20 - 39% = 0 
    40 - 59% = 5 
    60 - 79% = 2 
    80 - 99% = 3259 
 
PERF_SPLIT_4 (285) 
    Primary pointer page: 617, Index root page: 618 
    Total formats: 1, used formats: 1 
    Average record length: 147.35, total records: 156139 
    Average version length: 153.34, total versions: 4181, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.51 
    Pointer pages: 7, data page slots: 4200 
    Data pages: 3872, average fill: 83% 
    Primary pages: 3870, secondary pages: 2, swept pages: 8 
    Empty pages: 30, full pages: 3828 
    Fill distribution: 
     0 - 19% = 33 
    20 - 39% = 2 
    40 - 59% = 4 
    60 - 79% = 4 
    80 - 99% = 3829 
 
PERF_SPLIT_5 (286) 
    Primary pointer page: 619, Index root page: 620 
    Total formats: 1, used formats: 1 
    Average record length: 148.44, total records: 140497 
    Average version length: 153.52, total versions: 2097, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.43 
    Pointer pages: 7, data page slots: 4080 
    Data pages: 3464, average fill: 83% 
    Primary pages: 3461, secondary pages: 3, swept pages: 4 
    Empty pages: 19, full pages: 3437 
    Fill distribution: 
     0 - 19% = 22 
    20 - 39% = 3 
    40 - 59% = 1 
    60 - 79% = 2 
    80 - 99% = 3436 
 
PERF_SPLIT_6 (287) 
    Primary pointer page: 621, Index root page: 622 
    Total formats: 1, used formats: 1 
    Average record length: 148.33, total records: 160596 
    Average version length: 153.27, total versions: 3255, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.43 
    Pointer pages: 7, data page slots: 5064 
    Data pages: 3976, average fill: 83% 
    Primary pages: 3974, secondary pages: 2, swept pages: 3 
    Empty pages: 24, full pages: 3944 
    Fill distribution: 
     0 - 19% = 29 
    20 - 39% = 2 
    40 - 59% = 0 
    60 - 79% = 1 
    80 - 99% = 3944 
 
PERF_SPLIT_7 (288) 
    Primary pointer page: 626, Index root page: 627 
    Total formats: 1, used formats: 1 
    Average record length: 147.14, total records: 157171 
    Average version length: 153.87, total versions: 4037, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.53 
    Pointer pages: 7, data page slots: 4080 
    Data pages: 3872, average fill: 84% 
    Primary pages: 3870, secondary pages: 2, swept pages: 3 
    Empty pages: 15, full pages: 3850 
    Fill distribution: 
     0 - 19% = 17 
    20 - 39% = 1 
    40 - 59% = 2 
    60 - 79% = 3 
    80 - 99% = 3849 
 
PERF_SPLIT_8 (289) 
    Primary pointer page: 628, Index root page: 629 
    Total formats: 1, used formats: 1 
    Average record length: 120.51, total records: 193825 
    Average version length: 155.06, total versions: 41484, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 14.07 
    Pointer pages: 7, data page slots: 6032 
    Data pages: 4784, average fill: 86% 
    Primary pages: 4782, secondary pages: 2, swept pages: 1 
    Empty pages: 7, full pages: 4768 
    Fill distribution: 
     0 - 19% = 12 
    20 - 39% = 2 
    40 - 59% = 0 
    60 - 79% = 2 
    80 - 99% = 4768 
 
PERF_SPLIT_9 (290) 
    Primary pointer page: 630, Index root page: 631 
    Total formats: 1, used formats: 1 
    Average record length: 145.66, total records: 158791 
    Average version length: 154.48, total versions: 6045, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.64 
    Pointer pages: 7, data page slots: 4160 
    Data pages: 3928, average fill: 84% 
    Primary pages: 3927, secondary pages: 1, swept pages: 2 
    Empty pages: 23, full pages: 3895 
    Fill distribution: 
     0 - 19% = 27 
    20 - 39% = 2 
    40 - 59% = 2 
    60 - 79% = 2 
    80 - 99% = 3895 
 
PHRASES (143) 
    Primary pointer page: 510, Index root page: 511 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index PHRASES_ID_DESC (3) 
    Root page: 1510376, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PHRASES_NAME (2) 
    Root page: 1510375, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PHRASES_UNQ (1) 
    Root page: 1510374, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PK_PHRASES (0) 
    Root page: 1510373, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
PSTORNED (147) 
    Primary pointer page: 518, Index root page: 519 
    Total formats: 1, used formats: 1 
    Average record length: 51.32, total records: 2145649 
    Average version length: 52.87, total versions: 70105, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 70.00, compression ratio: 1.36 
    Pointer pages: 16, data page slots: 25848 
    Data pages: 25848, average fill: 72% 
    Primary pages: 25835, secondary pages: 13, swept pages: 8524 
    Empty pages: 53, full pages: 24256 
    Fill distribution: 
     0 - 19% = 126 
    20 - 39% = 117 
    40 - 59% = 384 
    60 - 79% = 24473 
    80 - 99% = 748 
 
    Index PSTORNED_RCV_ID (1) 
    Root page: 1506208, depth: 3, leaf buckets: 2605, nodes: 2145649 
    Average node length: 5.44, total dup: 2003313, max dup: 1657 
    Average key length: 2.48, compression ratio: 3.62 
    Average prefix length: 8.58, average data length: 0.42 
    Clustering factor: 184705, ratio: 0.09 
    Fill distribution: 
         0 - 19% = 6 
        20 - 39% = 270 
        40 - 59% = 1692 
        60 - 79% = 326 
        80 - 99% = 311 
 
    Index PSTORNED_SND_ID (0) 
    Root page: 1504841, depth: 3, leaf buckets: 2763, nodes: 2145649 
    Average node length: 5.69, total dup: 1926829, max dup: 64 
    Average key length: 2.73, compression ratio: 3.29 
    Average prefix length: 8.37, average data length: 0.63 
    Clustering factor: 382924, ratio: 0.18 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 7 
        40 - 59% = 2320 
        60 - 79% = 406 
        80 - 99% = 29 
 
    Index PSTORNED_WORKER_ID (2) 
    Root page: 1508018, depth: 3, leaf buckets: 2107, nodes: 2145649 
    Average node length: 4.96, total dup: 2145549, max dup: 28137 
    Average key length: 2.00, compression ratio: 1.20 
    Average prefix length: 2.41, average data length: 0.00 
    Clustering factor: 182449, ratio: 0.09 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 136 
        40 - 59% = 1080 
        60 - 79% = 414 
        80 - 99% = 476 
 
RULES_FOR_PDISTR (148) 
    Primary pointer page: 520, Index root page: 521 
    Total formats: 1, used formats: 1 
    Average record length: 17.00, total records: 4 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 334.00, compression ratio: 19.65 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 2% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index RULES_FOR_PDISTR_UNQ (0) 
    Root page: 1504339, depth: 1, leaf buckets: 1, nodes: 4 
    Average node length: 11.50, total dup: 0, max dup: 0 
    Average key length: 10.25, compression ratio: 0.88 
    Average prefix length: 1.50, average data length: 7.50 
    Clustering factor: 1, ratio: 0.25 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
RULES_FOR_QDISTR (137) 
    Primary pointer page: 498, Index root page: 499 
    Total formats: 1, used formats: 1 
    Average record length: 32.71, total records: 7 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 332.00, compression ratio: 10.15 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 4% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index RULES_FOR_QDISTR_RCVOP (1) 
    Root page: 1544825, depth: 1, leaf buckets: 1, nodes: 7 
    Average node length: 5.29, total dup: 2, max dup: 2 
    Average key length: 4.14, compression ratio: 0.72 
    Average prefix length: 1.43, average data length: 1.57 
    Clustering factor: 1, ratio: 0.14 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index RULES_FOR_QDISTR_UNQ (0) 
    Root page: 1544824, depth: 1, leaf buckets: 1, nodes: 7 
    Average node length: 10.14, total dup: 0, max dup: 0 
    Average key length: 8.86, compression ratio: 0.94 
    Average prefix length: 2.14, average data length: 6.14 
    Clustering factor: 1, ratio: 0.14 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
SEMAPHORES (152) 
    Primary pointer page: 528, Index root page: 529 
    Total formats: 1, used formats: 1 
    Average record length: 43.40, total records: 5 
    Average version length: 9.00, total versions: 1, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 346.00, compression ratio: 7.97 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 4% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index PK_SEMAPHORES (0) 
    Root page: 1504327, depth: 1, leaf buckets: 1, nodes: 5 
    Average node length: 12.40, total dup: 0, max dup: 0 
    Average key length: 11.00, compression ratio: 0.82 
    Average prefix length: 0.60, average data length: 8.40 
    Clustering factor: 1, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index SEMAPHORES_TASK_UNQ (1) 
    Root page: 1504328, depth: 1, leaf buckets: 1, nodes: 5 
    Average node length: 23.40, total dup: 0, max dup: 0 
    Average key length: 22.00, compression ratio: 1.07 
    Average prefix length: 4.20, average data length: 19.40 
    Clustering factor: 1, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
SETTINGS (135) 
    Primary pointer page: 494, Index root page: 495 
    Total formats: 1, used formats: 1 
    Average record length: 97.62, total records: 149 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1347.00, compression ratio: 13.80 
    Pointer pages: 1, data page slots: 3 
    Data pages: 3, average fill: 70% 
    Primary pages: 3, secondary pages: 0, swept pages: 1 
    Empty pages: 0, full pages: 2 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 1 
    60 - 79% = 0 
    80 - 99% = 2 
 
    Index SETTINGS_MCODE_WM_UNQ (1) 
    Root page: 1544931, depth: 1, leaf buckets: 1, nodes: 149 
    Average node length: 14.66, total dup: 0, max dup: 0 
    Average key length: 13.55, compression ratio: 2.19 
    Average prefix length: 19.07, average data length: 10.66 
    Clustering factor: 48, ratio: 0.32 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 1 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index SETTINGS_MODE_CODE (0) 
    Root page: 1544828, depth: 1, leaf buckets: 1, nodes: 149 
    Average node length: 25.56, total dup: 0, max dup: 0 
    Average key length: 24.56, compression ratio: 1.63 
    Average prefix length: 18.58, average data length: 21.56 
    Clustering factor: 14, ratio: 0.09 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 0 
        40 - 59% = 1 
        60 - 79% = 0 
        80 - 99% = 0 
 
TMP$DEP_DOCS (129) 
    Primary pointer page: 482, Index root page: 483 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index TMP_DEP_DOCS_UNQ (0) 
    Root page: 1544832, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
TMP$IDX_RECALC (132) 
    Primary pointer page: 488, Index root page: 489 
    Total formats: 2, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index TMP_IDX_RECALC_IDX_NAME_UNQ (0) 
    Root page: 1544829, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
TMP$MON_LOG (133) 
    Primary pointer page: 490, Index root page: 491 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
TMP$MON_LOG_TABLE_STATS (134) 
    Primary pointer page: 492, Index root page: 493 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
TMP$PERF_EST_WHOLE (161) 
    Primary pointer page: 546, Index root page: 547 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
TMP$PERF_LOG (160) 
    Primary pointer page: 544, Index root page: 545 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index TMP$PERF_LOG_UNIT_TRN_DTS_END (0) 
    Root page: 1504252, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
TMP$PERF_MON (131) 
    Primary pointer page: 486, Index root page: 487 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
TMP$RESULT_SET (130) 
    Primary pointer page: 484, Index root page: 485 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index TMP_RESULT_SET_DOC (1) 
    Root page: 1544831, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index TMP_RESULT_SET_WARE_DOC (0) 
    Root page: 1544830, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
TMP$SHOPPING_CART (128) 
    Primary pointer page: 480, Index root page: 481 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index TMP_SHOPCART_UNQ (0) 
    Root page: 1544833, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
TPAUSE (166) 
    Primary pointer page: 557, Index root page: 558 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index RDB$PRIMARY2 (0) 
    Root page: 1504237, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
TRACE_STAT (157) 
    Primary pointer page: 538, Index root page: 539 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
WARES (142) 
    Primary pointer page: 508, Index root page: 509 
    Total formats: 1, used formats: 1 
    Average record length: 77.52, total records: 400 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 444.00, compression ratio: 5.73 
    Pointer pages: 1, data page slots: 6 
    Data pages: 6, average fill: 77% 
    Primary pages: 6, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 5 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 5 
    80 - 99% = 1 
 
    Index FK_WARES_WARE_GROUPS (3) 
    Root page: 1552183, depth: 1, leaf buckets: 1, nodes: 400 
    Average node length: 3.17, total dup: 392, max dup: 60 
    Average key length: 2.16, compression ratio: 4.16 
    Average prefix length: 8.86, average data length: 0.14 
    Clustering factor: 48, ratio: 0.12 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PK_WARES (0) 
    Root page: 1510377, depth: 1, leaf buckets: 1, nodes: 400 
    Average node length: 11.22, total dup: 0, max dup: 0 
    Average key length: 10.22, compression ratio: 0.88 
    Average prefix length: 1.78, average data length: 7.22 
    Clustering factor: 344, ratio: 0.86 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 0 
        40 - 59% = 1 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index WARES_ID_DESC (2) 
    Root page: 1510382, depth: 1, leaf buckets: 1, nodes: 400 
    Average node length: 11.22, total dup: 0, max dup: 0 
    Average key length: 10.22, compression ratio: 0.88 
    Average prefix length: 1.78, average data length: 7.22 
    Clustering factor: 344, ratio: 0.86 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 0 
        40 - 59% = 1 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index WARES_NUMB_UNQ (1) 
    Root page: 1510380, depth: 2, leaf buckets: 3, nodes: 400 
    Average node length: 53.25, total dup: 0, max dup: 0 
    Average key length: 52.23, compression ratio: 1.00 
    Average prefix length: 2.74, average data length: 49.25 
    Clustering factor: 355, ratio: 0.89 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 1 
        80 - 99% = 2 
 
WARE_GROUPS (151) 
    Primary pointer page: 526, Index root page: 527 
    Total formats: 1, used formats: 1 
    Average record length: 32.12, total records: 8 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 346.00, compression ratio: 10.77 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 5% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index PK_WARE_GROUPS (0) 
    Root page: 1504329, depth: 1, leaf buckets: 1, nodes: 8 
    Average node length: 11.25, total dup: 0, max dup: 0 
    Average key length: 10.12, compression ratio: 0.89 
    Average prefix length: 1.75, average data length: 7.25 
    Clustering factor: 1, ratio: 0.12 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index WARE_GROUPS_NAME_UNQ (1) 
    Root page: 1504330, depth: 1, leaf buckets: 1, nodes: 8 
    Average node length: 19.88, total dup: 0, max dup: 0 
    Average key length: 18.12, compression ratio: 0.89 
    Average prefix length: 0.25, average data length: 15.88 
    Clustering factor: 1, ratio: 0.12 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
XQD_1000_1200 (176) 
    Primary pointer page: 577, Index root page: 578 
    Total formats: 1, used formats: 1 
    Average record length: 40.39, total records: 155613 
    Average version length: 69.21, total versions: 74514, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 3.12 
    Pointer pages: 3, data page slots: 4184 
    Data pages: 3160, average fill: 60% 
    Primary pages: 3160, secondary pages: 0, swept pages: 303 
    Empty pages: 498, full pages: 2043 
    Fill distribution: 
     0 - 19% = 704 
    20 - 39% = 131 
    40 - 59% = 118 
    60 - 79% = 945 
    80 - 99% = 1262 
 
    Index XQD_1000_1200_WA_SO_RO_WKR_SND (0) 
    Root page: 1554665, depth: 3, leaf buckets: 221, nodes: 155613 
    Average node length: 6.46, total dup: 135486, max dup: 25 
    Average key length: 3.93, compression ratio: 10.70 
    Average prefix length: 40.20, average data length: 1.80 
    Clustering factor: 26560, ratio: 0.17 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 24 
        40 - 59% = 101 
        60 - 79% = 83 
        80 - 99% = 12 
 
XQD_1000_3300 (178) 
    Primary pointer page: 581, Index root page: 582 
    Total formats: 1, used formats: 1 
    Average record length: 64.39, total records: 7406093 
    Average version length: 68.77, total versions: 563375, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.96 
    Pointer pages: 66, data page slots: 107232 
    Data pages: 107232, average fill: 75% 
    Primary pages: 107232, secondary pages: 0, swept pages: 7545 
    Empty pages: 33, full pages: 101859 
    Fill distribution: 
     0 - 19% = 265 
    20 - 39% = 542 
    40 - 59% = 1083 
    60 - 79% = 101902 
    80 - 99% = 3440 
 
    Index XQD_1000_3300_WA_SO_RO_WKR_SND (0) 
    Root page: 1480476, depth: 3, leaf buckets: 10802, nodes: 7406093 
    Average node length: 6.51, total dup: 6408844, max dup: 29 
    Average key length: 3.51, compression ratio: 11.95 
    Average prefix length: 40.62, average data length: 1.38 
    Clustering factor: 1748774, ratio: 0.24 
    Fill distribution: 
         0 - 19% = 17 
        20 - 39% = 1220 
        40 - 59% = 5841 
        60 - 79% = 3072 
        80 - 99% = 652 
 
    Index XQD_1000_3300_WKR_DOC_ASC (1) 
    Root page: 1486090, depth: 3, leaf buckets: 8893, nodes: 7406093 
    Average node length: 5.39, total dup: 7118078, max dup: 181 
    Average key length: 2.40, compression ratio: 7.09 
    Average prefix length: 16.64, average data length: 0.36 
    Clustering factor: 1537484, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 14 
        20 - 39% = 976 
        40 - 59% = 5334 
        60 - 79% = 1582 
        80 - 99% = 987 
 
    Index XQD_1000_3300_WKR_DOC_DEC (2) 
    Root page: 1490630, depth: 3, leaf buckets: 8933, nodes: 7406093 
    Average node length: 5.39, total dup: 7118078, max dup: 181 
    Average key length: 2.40, compression ratio: 7.09 
    Average prefix length: 16.64, average data length: 0.36 
    Clustering factor: 1539827, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 6 
        20 - 39% = 1022 
        40 - 59% = 5318 
        60 - 79% = 1600 
        80 - 99% = 987 
 
XQD_1200_2000 (177) 
    Primary pointer page: 579, Index root page: 580 
    Total formats: 1, used formats: 1 
    Average record length: 66.52, total records: 12356079 
    Average version length: 68.72, total versions: 495541, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.89 
    Pointer pages: 108, data page slots: 175704 
    Data pages: 175704, average fill: 75% 
    Primary pages: 175703, secondary pages: 1, swept pages: 44461 
    Empty pages: 7, full pages: 175637 
    Fill distribution: 
     0 - 19% = 8 
    20 - 39% = 0 
    40 - 59% = 5 
    60 - 79% = 170991 
    80 - 99% = 4700 
 
    Index XQD_1200_2000_WA_SO_RO_WKR_SND (0) 
    Root page: 1495050, depth: 3, leaf buckets: 18456, nodes: 12350548 
    Average node length: 6.62, total dup: 10767257, max dup: 69 
    Average key length: 3.42, compression ratio: 12.27 
    Average prefix length: 40.70, average data length: 1.30 
    Clustering factor: 2522889, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 31 
        20 - 39% = 1820 
        40 - 59% = 10601 
        60 - 79% = 5138 
        80 - 99% = 866 
 
XQD_2000_3300 (179) 
    Primary pointer page: 583, Index root page: 584 
    Total formats: 1, used formats: 1 
    Average record length: 38.74, total records: 2089828 
    Average version length: 69.08, total versions: 583791, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 3.25 
    Pointer pages: 30, data page slots: 46480 
    Data pages: 30189, average fill: 68% 
    Primary pages: 30119, secondary pages: 70, swept pages: 1115 
    Empty pages: 346, full pages: 29152 
    Fill distribution: 
     0 - 19% = 533 
    20 - 39% = 4708 
    40 - 59% = 2555 
    60 - 79% = 13695 
    80 - 99% = 8698 
 
    Index XQD_2000_3300_WA_SO_RO_WKR_SND (0) 
    Root page: 1479735, depth: 3, leaf buckets: 1965, nodes: 1616823 
    Average node length: 5.51, total dup: 1551380, max dup: 49 
    Average key length: 2.55, compression ratio: 16.45 
    Average prefix length: 41.49, average data length: 0.51 
    Clustering factor: 116989, ratio: 0.07 
    Fill distribution: 
         0 - 19% = 16 
        20 - 39% = 223 
        40 - 59% = 961 
        60 - 79% = 593 
        80 - 99% = 172 
 
XQD_2100_3300 (180) 
    Primary pointer page: 585, Index root page: 586 
    Total formats: 1, used formats: 1 
    Average record length: 32.56, total records: 1647260 
    Average version length: 69.02, total versions: 168975, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 3.87 
    Pointer pages: 23, data page slots: 36056 
    Data pages: 28136, average fill: 43% 
    Primary pages: 28135, secondary pages: 1, swept pages: 4582 
    Empty pages: 5176, full pages: 14879 
    Fill distribution: 
     0 - 19% = 7316 
    20 - 39% = 3407 
    40 - 59% = 7505 
    60 - 79% = 9456 
    80 - 99% = 452 
 
    Index XQD_2100_3300_WA_SO_RO_WKR_SND (0) 
    Root page: 1479229, depth: 3, leaf buckets: 1201, nodes: 815519 
    Average node length: 5.95, total dup: 750875, max dup: 97 
    Average key length: 3.01, compression ratio: 13.95 
    Average prefix length: 41.07, average data length: 0.93 
    Clustering factor: 120629, ratio: 0.15 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 295 
        40 - 59% = 593 
        60 - 79% = 279 
        80 - 99% = 33 
 
XQD_3300_3400 (181) 
    Primary pointer page: 587, Index root page: 588 
    Total formats: 1, used formats: 1 
    Average record length: 64.00, total records: 9390570 
    Average version length: 68.94, total versions: 757649, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.97 
    Pointer pages: 90, data page slots: 146000 
    Data pages: 145992, average fill: 70% 
    Primary pages: 145968, secondary pages: 24, swept pages: 27239 
    Empty pages: 397, full pages: 104173 
    Fill distribution: 
     0 - 19% = 1399 
    20 - 39% = 6242 
    40 - 59% = 16222 
    60 - 79% = 115261 
    80 - 99% = 6868 
 
    Index XQD_3300_3400_WA_SO_RO_WKR_SND (0) 
    Root page: 1472612, depth: 3, leaf buckets: 13465, nodes: 9380877 
    Average node length: 6.69, total dup: 7781377, max dup: 14 
    Average key length: 3.67, compression ratio: 11.46 
    Average prefix length: 40.50, average data length: 1.50 
    Clustering factor: 2084175, ratio: 0.22 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 1096 
        40 - 59% = 6546 
        60 - 79% = 4984 
        80 - 99% = 837 
 
XQS_1000_1200 (182) 
    Primary pointer page: 589, Index root page: 590 
    Total formats: 1, used formats: 1 
    Average record length: 82.46, total records: 21172566 
    Average version length: 82.90, total versions: 22377, 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: 197, data page slots: 319976 
    Data pages: 319976, average fill: 81% 
    Primary pages: 319971, secondary pages: 5, swept pages: 11191 
    Empty pages: 0, full pages: 319969 
    Fill distribution: 
     0 - 19% = 2 
    20 - 39% = 2 
    40 - 59% = 1 
    60 - 79% = 48690 
    80 - 99% = 271281 
 
    Index XQS_1000_1200_DOC_ID (1) 
    Root page: 1426738, depth: 3, leaf buckets: 19544, nodes: 21172566 
    Average node length: 5.72, total dup: 20691145, max dup: 164 
    Average key length: 2.16, compression ratio: 4.16 
    Average prefix length: 8.86, average data length: 0.14 
    Clustering factor: 3288325, ratio: 0.16 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 4 
        40 - 59% = 8425 
        60 - 79% = 581 
        80 - 99% = 10532 
 
    Index XQS_1000_1200_RCV_ID (3) 
    Root page: 1457002, depth: 3, leaf buckets: 17212, nodes: 21172566 
    Average node length: 6.31, total dup: 18606095, max dup: 49 
    Average key length: 2.75, compression ratio: 3.27 
    Average prefix length: 8.37, average data length: 0.63 
    Clustering factor: 919585, ratio: 0.04 
    Fill distribution: 
         0 - 19% = 3 
        20 - 39% = 4 
        40 - 59% = 817 
        60 - 79% = 286 
        80 - 99% = 16102 
 
    Index XQS_1000_1200_SND_ID (2) 
    Root page: 1441095, depth: 3, leaf buckets: 21337, nodes: 21172566 
    Average node length: 6.35, total dup: 18525289, max dup: 29 
    Average key length: 2.79, compression ratio: 3.23 
    Average prefix length: 8.34, average data length: 0.66 
    Clustering factor: 3583022, ratio: 0.17 
    Fill distribution: 
         0 - 19% = 4 
        20 - 39% = 2 
        40 - 59% = 8690 
        60 - 79% = 663 
        80 - 99% = 11978 
 
    Index XQS_1000_1200_WORKER_ID (0) 
    Root page: 1413370, depth: 3, leaf buckets: 16167, nodes: 21172566 
    Average node length: 5.56, total dup: 21172466, max dup: 230064 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.42, average data length: 0.00 
    Clustering factor: 948474, ratio: 0.04 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 11 
        40 - 59% = 3002 
        60 - 79% = 384 
        80 - 99% = 12768 
 
XQS_1000_3300 (184) 
    Primary pointer page: 593, Index root page: 594 
    Total formats: 1, used formats: 1 
    Average record length: 76.76, total records: 9837976 
    Average version length: 82.59, total versions: 757248, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.64 
    Pointer pages: 106, data page slots: 172568 
    Data pages: 172544, average fill: 71% 
    Primary pages: 172511, secondary pages: 33, swept pages: 44295 
    Empty pages: 519, full pages: 120299 
    Fill distribution: 
     0 - 19% = 1865 
    20 - 39% = 7750 
    40 - 59% = 20629 
    60 - 79% = 110955 
    80 - 99% = 31345 
 
    Index XQS_1000_3300_DOC_ID (1) 
    Root page: 1367524, depth: 3, leaf buckets: 11347, nodes: 9837976 
    Average node length: 5.36, total dup: 9530247, max dup: 212 
    Average key length: 2.23, compression ratio: 4.04 
    Average prefix length: 8.80, average data length: 0.20 
    Clustering factor: 2180700, ratio: 0.22 
    Fill distribution: 
         0 - 19% = 3 
        20 - 39% = 49 
        40 - 59% = 7793 
        60 - 79% = 3412 
        80 - 99% = 90 
 
    Index XQS_1000_3300_RCV_ID (3) 
    Root page: 1379283, depth: 3, leaf buckets: 13553, nodes: 9837976 
    Average node length: 6.23, total dup: 8156033, max dup: 14 
    Average key length: 3.10, compression ratio: 2.90 
    Average prefix length: 8.07, average data length: 0.93 
    Clustering factor: 1510140, ratio: 0.15 
    Fill distribution: 
         0 - 19% = 125 
        20 - 39% = 3694 
        40 - 59% = 4607 
        60 - 79% = 2521 
        80 - 99% = 2606 
 
    Index XQS_1000_3300_SND_ID (2) 
    Root page: 1373081, depth: 3, leaf buckets: 12674, nodes: 9837976 
    Average node length: 5.97, total dup: 8548900, max dup: 44 
    Average key length: 2.84, compression ratio: 3.17 
    Average prefix length: 8.29, average data length: 0.71 
    Clustering factor: 2381788, ratio: 0.24 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 67 
        40 - 59% = 8782 
        60 - 79% = 3712 
        80 - 99% = 111 
 
    Index XQS_1000_3300_WORKER_ID (0) 
    Root page: 1362789, depth: 3, leaf buckets: 10181, nodes: 9837976 
    Average node length: 5.13, total dup: 9837876, max dup: 154063 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.41, average data length: 0.00 
    Clustering factor: 1545587, ratio: 0.16 
    Fill distribution: 
         0 - 19% = 39 
        20 - 39% = 1054 
        40 - 59% = 5231 
        60 - 79% = 1762 
        80 - 99% = 2095 
 
XQS_1200_2000 (183) 
    Primary pointer page: 591, Index root page: 592 
    Total formats: 1, used formats: 1 
    Average record length: 78.33, total records: 11498587 
    Average version length: 82.53, total versions: 622414, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.61 
    Pointer pages: 119, data page slots: 193600 
    Data pages: 192312, average fill: 74% 
    Primary pages: 192171, secondary pages: 141, swept pages: 50175 
    Empty pages: 2224, full pages: 156751 
    Fill distribution: 
     0 - 19% = 3696 
    20 - 39% = 5654 
    40 - 59% = 13910 
    60 - 79% = 97754 
    80 - 99% = 71298 
 
    Index XQS_1200_2000_DOC_ID (1) 
    Root page: 1392123, depth: 3, leaf buckets: 13123, nodes: 11498587 
    Average node length: 5.30, total dup: 11389054, max dup: 631 
    Average key length: 2.08, compression ratio: 4.33 
    Average prefix length: 8.93, average data length: 0.07 
    Clustering factor: 2416586, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 83 
        40 - 59% = 8746 
        60 - 79% = 4108 
        80 - 99% = 184 
 
    Index XQS_1200_2000_RCV_ID (3) 
    Root page: 1406132, depth: 3, leaf buckets: 10573, nodes: 11498587 
    Average node length: 5.50, total dup: 10996767, max dup: 49 
    Average key length: 2.28, compression ratio: 3.95 
    Average prefix length: 8.77, average data length: 0.23 
    Clustering factor: 745719, ratio: 0.06 
    Fill distribution: 
         0 - 19% = 128 
        20 - 39% = 800 
        40 - 59% = 2649 
        60 - 79% = 1873 
        80 - 99% = 5123 
 
    Index XQS_1200_2000_SND_ID (2) 
    Root page: 1398660, depth: 3, leaf buckets: 15010, nodes: 11498587 
    Average node length: 6.02, total dup: 10045246, max dup: 75 
    Average key length: 2.80, compression ratio: 3.22 
    Average prefix length: 8.33, average data length: 0.67 
    Clustering factor: 2433182, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 5 
        20 - 39% = 101 
        40 - 59% = 10286 
        60 - 79% = 4411 
        80 - 99% = 207 
 
    Index XQS_1200_2000_WORKER_ID (0) 
    Root page: 1386233, depth: 3, leaf buckets: 10962, nodes: 11498587 
    Average node length: 5.23, total dup: 11498487, max dup: 193193 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.42, average data length: 0.00 
    Clustering factor: 733944, ratio: 0.06 
    Fill distribution: 
         0 - 19% = 83 
        20 - 39% = 814 
        40 - 59% = 4928 
        60 - 79% = 1536 
        80 - 99% = 3601 
 
XQS_2000_3300 (185) 
    Primary pointer page: 595, Index root page: 596 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index XQS_2000_3300_DOC_ID (1) 
    Root page: 1361775, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index XQS_2000_3300_RCV_ID (3) 
    Root page: 1361777, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index XQS_2000_3300_SND_ID (2) 
    Root page: 1361776, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index XQS_2000_3300_WORKER_ID (0) 
    Root page: 1361774, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
XQS_2100_3300 (186) 
    Primary pointer page: 597, Index root page: 598 
    Total formats: 1, used formats: 1 
    Average record length: 77.38, total records: 9917724 
    Average version length: 82.88, total versions: 721127, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.63 
    Pointer pages: 108, data page slots: 176112 
    Data pages: 176064, average fill: 70% 
    Primary pages: 176031, secondary pages: 33, swept pages: 48917 
    Empty pages: 492, full pages: 112748 
    Fill distribution: 
     0 - 19% = 1749 
    20 - 39% = 7862 
    40 - 59% = 23634 
    60 - 79% = 114049 
    80 - 99% = 28770 
 
    Index XQS_2100_3300_DOC_ID (1) 
    Root page: 1344708, depth: 3, leaf buckets: 11909, nodes: 9917724 
    Average node length: 5.18, total dup: 9888476, max dup: 2416 
    Average key length: 2.03, compression ratio: 4.43 
    Average prefix length: 8.97, average data length: 0.03 
    Clustering factor: 1992235, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 23 
        20 - 39% = 1394 
        40 - 59% = 7992 
        60 - 79% = 1889 
        80 - 99% = 611 
 
    Index XQS_2100_3300_RCV_ID (3) 
    Root page: 1355739, depth: 3, leaf buckets: 13687, nodes: 9917724 
    Average node length: 6.25, total dup: 8221630, max dup: 14 
    Average key length: 3.10, compression ratio: 2.90 
    Average prefix length: 8.07, average data length: 0.93 
    Clustering factor: 1474842, ratio: 0.15 
    Fill distribution: 
         0 - 19% = 173 
        20 - 39% = 3738 
        40 - 59% = 4592 
        60 - 79% = 2470 
        80 - 99% = 2714 
 
    Index XQS_2100_3300_SND_ID (2) 
    Root page: 1350071, depth: 3, leaf buckets: 12540, nodes: 9917724 
    Average node length: 5.43, total dup: 9475988, max dup: 99 
    Average key length: 2.29, compression ratio: 3.94 
    Average prefix length: 8.76, average data length: 0.24 
    Clustering factor: 2128838, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 30 
        20 - 39% = 1395 
        40 - 59% = 8803 
        60 - 79% = 1713 
        80 - 99% = 599 
 
    Index XQS_2100_3300_WORKER_ID (0) 
    Root page: 987843, depth: 3, leaf buckets: 10261, nodes: 9917724 
    Average node length: 5.15, total dup: 9917624, max dup: 156578 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.41, average data length: 0.00 
    Clustering factor: 1568820, ratio: 0.16 
    Fill distribution: 
         0 - 19% = 37 
        20 - 39% = 1118 
        40 - 59% = 5173 
        60 - 79% = 1710 
        80 - 99% = 2223 
 
XQS_3300_3400 (187) 
    Primary pointer page: 599, Index root page: 600 
    Total formats: 1, used formats: 1 
    Average record length: 66.99, total records: 585068 
    Average version length: 68.82, total versions: 11699, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.88 
    Pointer pages: 5, data page slots: 8088 
    Data pages: 8088, average fill: 76% 
    Primary pages: 8087, secondary pages: 1, swept pages: 2303 
    Empty pages: 7, full pages: 7910 
    Fill distribution: 
     0 - 19% = 8 
    20 - 39% = 3 
    40 - 59% = 18 
    60 - 79% = 7839 
    80 - 99% = 220 
 
    Index XQS_3300_3400_DOC_ID (1) 
    Root page: 32185, depth: 3, leaf buckets: 743, nodes: 585068 
    Average node length: 5.95, total dup: 498129, max dup: 82 
    Average key length: 3.09, compression ratio: 2.91 
    Average prefix length: 8.06, average data length: 0.94 
    Clustering factor: 102951, ratio: 0.18 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 16 
        40 - 59% = 534 
        60 - 79% = 97 
        80 - 99% = 95 
 
    Index XQS_3300_3400_SND_ID (2) 
    Root page: 26334, depth: 3, leaf buckets: 762, nodes: 585068 
    Average node length: 6.15, total dup: 479812, max dup: 23 
    Average key length: 3.29, compression ratio: 2.73 
    Average prefix length: 7.89, average data length: 1.11 
    Clustering factor: 103001, ratio: 0.18 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 17 
        40 - 59% = 540 
        60 - 79% = 103 
        80 - 99% = 100 
 
    Index XQS_3300_3400_WORKER_ID (0) 
    Root page: 377587, depth: 2, leaf buckets: 565, nodes: 585068 
    Average node length: 4.86, total dup: 584968, max dup: 9658 
    Average key length: 2.00, compression ratio: 1.20 
    Average prefix length: 2.41, average data length: 0.00 
    Clustering factor: 91412, ratio: 0.16 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 27 
        40 - 59% = 331 
        60 - 79% = 65 
        80 - 99% = 141 
 
ZDOC_DATA (170) 
    Primary pointer page: 565, Index root page: 566 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
ZDOC_LIST (169) 
    Primary pointer page: 563, Index root page: 564 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
ZINVNT_TURNOVER_LOG (171) 
    Primary pointer page: 567, Index root page: 568 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
ZPDISTR (174) 
    Primary pointer page: 573, Index root page: 574 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index ZPDISTR_ID (0) 
    Root page: 1504230, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
ZPSTORNED (175) 
    Primary pointer page: 575, Index root page: 576 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index ZPSTORNED_ID (0) 
    Root page: 1504229, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
ZQDISTR (172) 
    Primary pointer page: 569, Index root page: 570 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index ZQDISTR_ID (0) 
    Root page: 1504235, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index ZQDISTR_WARE_SNDOP_RCVOP (1) 
    Root page: 1504236, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
ZQSTORNED (173) 
    Primary pointer page: 571, Index root page: 572 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index ZQSTORNED_DOC_ID (1) 
    Root page: 1504232, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index ZQSTORNED_ID (0) 
    Root page: 1504231, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index ZQSTORNED_RCV_ID (3) 
    Root page: 1504234, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index ZQSTORNED_SND_ID (2) 
    Root page: 1504233, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
ZTMP_DEP_DOCS (168) 
    Primary pointer page: 561, Index root page: 562 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
ZTMP_SHOPPING_CART (167) 
    Primary pointer page: 559, Index root page: 560 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
Z_USED_VIEWS (144) 
    Primary pointer page: 512, Index root page: 513 
    Total formats: 1, used formats: 1 
    Average record length: 29.38, total records: 29 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 99.00, compression ratio: 3.37 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 16% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index Z_USED_VIEWS_UNQ (0) 
    Root page: 1510372, depth: 1, leaf buckets: 1, nodes: 29 
    Average node length: 15.17, total dup: 0, max dup: 0 
    Average key length: 14.14, compression ratio: 1.44 
    Average prefix length: 9.17, average data length: 11.17 
    Clustering factor: 1, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
Gstat completion time Sat Mar 30 10:09:50 2024

Record versions statistics, table

TABLE_NAME TOTAL_RECS TOTAL_VERS MAX_VERSIONS VERS_TO_RECS_PRC MAXV_TO_VERS_PRC
DOC_DATA 7800485 149052 1 0.0000 0.0000
DOC_LIST 2271162 79452 2 0.0000 0.0000
FB_ERRORS 2182 757 1 0.0000 0.0000
INVNT_SALDO 400 6558 20 1600.0000 0.0000
INVNT_TURNOVER_LOG 93944 72801 1 0.0000 0.0000
MONEY_SALDO 49 387 16 700.0000 0.0000
MONEY_TURNOVER_LOG 1840 1660 1 0.0000 0.0000
PDISTR 821474 38025 3 0.0000 0.0000
PERF_SPLIT_0 172371 2361 1 0.0000 0.0000
PERF_SPLIT_1 150332 5392 1 0.0000 0.0000
PERF_SPLIT_2 134868 2576 1 0.0000 0.0000
PERF_SPLIT_3 133030 3393 1 0.0000 0.0000
PERF_SPLIT_4 156139 4181 1 0.0000 0.0000
PERF_SPLIT_5 140497 2097 1 0.0000 0.0000
PERF_SPLIT_6 160596 3255 1 0.0000 0.0000
PERF_SPLIT_7 157171 4037 1 0.0000 0.0000
PERF_SPLIT_8 193825 41484 1 0.0000 0.0000
PERF_SPLIT_9 158791 6045 1 0.0000 0.0000
PSTORNED 2145649 70105 1 0.0000 0.0000
SEMAPHORES 5 1 1 0.0000 100.0000
XQD_1000_1200 155613 74514 1 0.0000 0.0000
XQD_1000_3300 7406093 563375 1 0.0000 0.0000
XQD_1200_2000 12356079 495541 1 0.0000 0.0000
XQD_2000_3300 2089828 583791 1 0.0000 0.0000
XQD_2100_3300 1647260 168975 1 0.0000 0.0000
XQD_3300_3400 9390570 757649 1 0.0000 0.0000
XQS_1000_1200 21172566 22377 1 0.0000 0.0000
XQS_1000_3300 9837976 757248 1 0.0000 0.0000
XQS_1200_2000 11498587 622414 1 0.0000 0.0000
XQS_2100_3300 9917724 721127 1 0.0000 0.0000
XQS_3300_3400 585068 11699 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 ---
:203: 
:204: mscs-test-161.budzdorov.ru    Sat Mar 30 10:08:22 2024
:205:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3400
:206: 
--- end of diff output ---

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

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